query("SELECT FINANCIALPERIOD FROM procplanning GROUP BY FINANCIALPERIOD DESC"))
{ while ($row = $result->fetch_assoc() ) { $stss=$stss. "
Procurement Plan Reconciliation Report for
| Item description |
Code |
Sub item |
Amount required for quarterly purchase |
Total budget amount |
|
Quarterly expenditures |
|
Total expenditure |
Variance |
| |
|
|
Q1 |
Q2 |
Q3 |
Q4 |
|
Q1 |
Q2 |
Q3 |
Q4 |
|
|
prepare("SELECT * FROM procplanning WHERE FINANCIALPERIOD BETWEEN :a AND :b ORDER by ITEMDESCRIPTION ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total: |
prepare("SELECT sum(FIRSTQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :a AND :b");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(FIRSTQTR)'];
echo formatMoney($dsdsd, true);
}
?>
|
prepare("SELECT sum(SECONDQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(SECONDQTR)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(THIRDQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(THIRDQTR)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(FOURTHQTR) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(FOURTHQTR)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(BUDGETAMOUNT) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(BUDGETAMOUNT)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(FIRSTQTROB) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(FIRSTQTROB)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(SECONDQTROB) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(SECONDQTROB)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(THIRDQTROB) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(THIRDQTROB)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(FOUTHQTROB) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(FOUTHQTROB)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(TOTALROB) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(TOTALROB)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(VARIANCE) FROM procplanning WHERE FINANCIALPERIOD BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(VARIANCE)'];
echo formatMoney($zxc, true);
}
?>
|