+- 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.