![]() |
Frequently Ordered Items - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Development Discussion & Specification (http://www.weberp.org/forum/forumdisplay.php?fid=10) +--- Thread: Frequently Ordered Items (/showthread.php?tid=2549) |
Frequently Ordered Items - daveparrish - 08-24-2015 Hi All I would like to modify the Frequently Ordered Items to only show results only for the current customer, has anyone done this? I have tried to modify SelectOrderItems.php line 1508 $SixMonthsAgo = DateAdd (Date($_SESSION['DefaultDateFormat']),'m',-6); Without success. Thanks For all the great work. RE: Frequently Ordered Items - TimSchofield - 08-24-2015 Can you try changing the SQL at line 1452 in SelectOrderItems.php to: $SQL="SELECT stockmaster.units, stockmaster.description, stockmaster.longdescription, stockmaster.stockid, salesorderdetails.stkcode, SUM(qtyinvoiced) salesqty FROM `salesorderdetails`INNER JOIN `stockmaster` ON salesorderdetails.stkcode = stockmaster.stockid INNER JOIN salesorders ON salesorders.orderno=salesorderdetails.orderno WHERE ActualDispatchDate >= '" . FormatDateForSQL($SixMonthsAgo) . "' AND salesorders.debtorno='" . $_SESSION['Items'.$identifier]->DebtorNo . "' GROUP BY stkcode ORDER BY salesqty DESC LIMIT " . $_SESSION['FrequentlyOrderedItems']; This should show the frequently ordered items just for the selected customer but I haven't tested this so can you let me know if it works? Tim RE: Frequently Ordered Items - daveparrish - 08-26-2015 Thanks For the help worked great. |