Margin Report v1.00

[michael_s]

Change for MarginReport2.php to make the cost portion work so that it actually calculated Gross Profit

Enjoy!


Find:

$prods_query = mysql_query("select products_id, products_price, products_cost, products_quantity from orders_products where orders_id = '" . $o[$i] . "'");

Replace With:

$prods_query = mysql_query("select op.products_id, op.products_price, op.products_quantity, p.products_cost from orders_products op, products p where op.orders_id = '" . $o[$i] . "' and op.products_id = p.products_id");



This update is for 2.56b

More...