Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Frequently Ordered Items
08-24-2015, 06:52 PM,
#2
RE: Frequently Ordered Items
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
Reply


Messages In This Thread
Frequently Ordered Items - by daveparrish - 08-24-2015, 07:08 AM
RE: Frequently Ordered Items - by TimSchofield - 08-24-2015, 06:52 PM
RE: Frequently Ordered Items - by daveparrish - 08-26-2015, 11:59 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)