(08-30-2017, 11:07 AM)TurboPT Wrote: It seems that no rows are found for the items? (and only the column headings are displayed)
In the InternalStockRequestFulfill.php file, at line 316 (the column headings start at line 317), can you add the code below, temporarily, to see if the query seems to be correct?
(check that all query values appear as expected)
PHP Code:
echo $LineSQL . '<br />';
Because that output is in the middle of a table creation, you might have to view the browser page source to find that query output, or add an exit statement after the echo.
If the query appears to be ok, you may have to manually cross-check to see if the expected data actually exists in tables: stockrequestitems and stockmaster.
If needed, post that query output in another reply if you can.
Hello,
thanks for the reply! I included "echo $LineSQL . '<br />'; " as you suggested and it seems the query is fine..."</tr>SELECT stockrequestitems.dispatchitemsid,
stockrequestitems.dispatchid,
stockrequestitems.stockid,
stockrequestitems.decimalplaces,
stockrequestitems.uom,
stockmaster.description,
stockrequestitems.quantity,
stockrequestitems.qtydelivered
FROM stockrequestitems
LEFT JOIN stockmaster
ON stockmaster.stockid=stockrequestitems.stockid
WHERE dispatchid='2202'
AND completed=0<br /><tr>"
When i checked from the database it seems i get confused with the data which is there, but dispatchitemsid = 0 for every stock which is there, is it ok to be like that?
another thing I've released is that this problem keeps on coming back and goes away(like i have dates in 2013, 2014....where encountered that same problem), so like today my user was able to fullfill the stock request actually of them he received today.