![](../../../assets/img/logsbig.PNG)
Payment Report from to by pmt number
Pmt Number |
Payment Date |
Code |
Budget sub item description |
Quarter |
Payee |
Cheque No. |
Amount Paid |
prepare("SELECT * FROM payments WHERE PAYMENTDATE 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++){
?>
STI-00 |
|
|
|
|
|
|
|
Total: |
prepare("SELECT sum(AMOUNTPAYABLE) FROM payments WHERE PAYMENTDATE BETWEEN :a AND :b");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(AMOUNTPAYABLE)'];
echo formatMoney($dsdsd, true);
}
?>
|