Dynamic Invoice - beta version Create and manage invoices directly from database (Added in version 4.5)

  
                $pdocrud = new PDOCrud();
                // set header fields of invoice. These fields basically will be shown before the
                // items table. Rest fields will be shown after the items table
                $headerFields = array("order_number", "order_date","company_id","client_id", "order_due_date");
                $pdocrud->setInvoiceDetails($headerFields);

                // This will add the print invoice pdf button. Please note that you need to 
                // buy xinvoice script to use this operation.
                $text = '';
                $pdocrud->enqueueBtnActions("printpdf", "javascript:;", "printpdf", $text);

                // This is the sql that will be used to create the invoice pdf. You can learn 
                // more about the how to create this sql here 
                // http://xinvoice.biz/demo/pages/database-invoice-creation
                $sql = "SELECT ot.order_number as invoice__no, ot.order_date as invoice__date, ot.order_due_date as invoice__due_date, ot.shipping as total__shipping, ot.tax as total__tax,ot.discount as total__discount, ot.order_total  as total_grandtotal, ot.payment_method as payment__method1, co.company_name as from__name,co.address1 as from__address1, co.address2 as from_address2, co.city as from__city, co.country as from__country, co.state as from__state,co.email as from__email, cl.client_name as to__name, cl.address1 as to__address1, cl.address2 as to__address2, cl.city as to__city, cl.state as to__state, cl.country as to_country, cl.email as to__email, oi.item_name as item__name, oi.item_desc as item__desc, oi.item_qty as item__qty, oi.item_qty as item__qty, oi.item_rate as item__rate, oi.item_total as item__total FROM x_ordertable as ot INNER JOIN x_order_items as oi on ot.order_id = oi.order_id INNER JOIN x_company as co on ot.company_id = co.company_id INNER JOIN x_clients as cl on ot.client_id = cl.client_id where ot.order_id = {order_id}";
                 
                //set invoice complete data
                $pdocrud->invoicePrint($sql);

                // set javascript based calculations to dynamically calculation fields totals
                $pdocrud->setJsActions("order_total", "{order_sub_total} + {tax} + {shipping} - {discount}","change");

                // this is also dynamic calculation, You need to set the column 
                $pdocrud->setLeftJoinJsActions("col5", "col3 * col4","change", array("col3"=>"input",
                    "col4" => "input"));


                // below functions are not required for invoice generation, you know these functions
                // already. Since we are using company table and client table, we can easily manage 
                // this using our related table function.
                $pdocrud->relatedData('company_id','x_company','company_id',array("company_name","address1", "city" ,"state", "country"));
                $pdocrud->relatedData('client_id','x_clients','client_id',array("client_name","address1", "city" ,"state", "country"));                
                // Order table and order items table needs to be joined.
                $pdocrud->joinTable("x_order_items", "x_order_items.order_id = x_ordertable.order_id", "LEFT JOIN");
                // lets convert the item table to dropdown and get the data from products table.
                $pdocrud->fieldTypes("item_name", "select");
                $pdocrud->fieldDataBinding("item_name", "x_products", "product_id", array("product_name"), "db", "-", array(), array("product_name"));
                                
                echo $pdocrud->dbTable("x_ordertable")->render();