query("SELECT GOODSRECIEVEDDATE FROM procplanning GROUP BY GOODSRECIEVEDDATE DESC"))
{ while ($row = $result->fetch_assoc() ) { $stss=$stss. "
SUMMARY REPORT FOR ITEMS RECIEVED AND ISSUED FROM to
| Date recieved |
Description |
Unit of measure |
Opening bal |
Quantity recieved |
Quantity issued |
Balance in stock |
Stock value |
Total cost for qty recieved |
Total cost for qty issued |
prepare("SELECT * FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :a AND :b ORDER by id DESC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
| |
|
|
|
|
|
|
|
|
|
| Total: |
prepare("SELECT sum(QTYRECIEVED) FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :a AND :b");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(QTYRECIEVED)'];
echo formatMoney($dsdsd, true);
}
?>
|
prepare("SELECT sum(QTYISSUED) FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(QTYISSUED)'];
echo formatMoney($zxc, true);
}
?>
|
|
prepare("SELECT sum(TTCOSTRECIEVED) FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(TTCOSTRECIEVED)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(TTCOSTISSUED) FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(TTCOSTISSUED)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(TTCOSTISSUED) FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(TTCOSTISSUED)'];
echo formatMoney($zxc, true);
}
?>
|