prepare("SELECT * FROM payments"); for($i=0; $row = $result->fetch(); $i++){ $cname=$row['PLANDETAILS']; $invoice=$row['id']; $date=$row['PAYMENTDATE']; $cash=$row['due_date']; $cashier=$row['cashier']; $pt=$row['type']; $am=$row['AMOUNTPAYABLE']; if($pt=='cash'){ $cash=$row['due_date']; $amount=$cash-$am; } } ?>
query("SELECT GOODSRECIEVEDDATE FROM procplanning GROUP BY GOODSRECIEVEDDATE DESC")) { while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; } } $connect->close(); ?>
From : To:

IN KIND CONTRIBUTION / DONATION REPORT FROM   TO   

prepare("SELECT * FROM recievables WHERE GOODSRECIEVEDDATE BETWEEN :a AND :b AND GOODSRECEIVABLETYPE = 'DONATION' ORDER by id DESC "); $result->bindParam(':a', $d1); $result->bindParam(':b', $d2); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ ?>
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); } ?>
Back