From many product list create a invoice "query"
SELECT *, SUM(order_qty) AS Torderqty, SUM(send_qty) AS Tsend_qty FROM purchase_invoice_details WHERE order_qty > send_qty GROUP BY inv_id
get data by codeiginter
$this -> data [ 'department' ] = $this -> db -> query ( " SELECT * FROM blog " ) -> result ();
Comments
Post a Comment