IN KIND CONTRIBUTION / DONATION REPORT FROM TO
Date recieved | Description | Location | Unit of measure | Donated by | Qty | Unit price | Amount | Basis of valuation | Budget code |
---|---|---|---|---|---|---|---|---|---|
Total: | prepare("SELECT sum(ITEMPRICE) FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :a AND :b AND GOODSRECEIVABLETYPE = 'DONATION'"); $results->bindParam(':a', $d1); $results->bindParam(':b', $d2); $results->execute(); for($i=0; $rows = $results->fetch(); $i++){ $dsdsd=$rows['sum(ITEMPRICE)']; echo formatMoney($dsdsd, true); } ?> |