ATTENDECE BY TYPE OF SERVICE AND AGE GROUP BETWEEN AND
| AGE GROUP |
STI's |
FP |
ANC |
HCG |
PNC |
HCT |
PAC |
TOLLFREE |
OTHER AILMENTS |
COUNSELLING SERVICES |
TOTAL |
prepare("SELECT DATECREATED,
CASE
WHEN AGE1 BETWEEN 10 AND 14 THEN '10-14'
WHEN AGE1 BETWEEN 15 AND 19 THEN '15-19'
WHEN AGE1 BETWEEN 20 AND 24 THEN '20-24'
WHEN AGE1 > 24 THEN 'Over 24'
END AS age_range,
sum( if( SERVICETYPE = 'MEDICAL SERVICES', RECORDCOUNTER, 0 ) ) AS me,
sum( if( SERVICETYPE = 'COUNSELLING SERVICES', RECORDCOUNTER, 0 ) ) AS co,
sum( if( SERVICETYPE = 'PREGNANCY RELATED SERVICES', RECORDCOUNTER, 0 ) ) AS pre,
sum( if( SCHOOLING = 'IS', RECORDCOUNTER, 0 ) ) AS insc,
sum( if( SCHOOLING = 'OS', RECORDCOUNTER, 0 ) ) AS ossc,
sum(STI),
sum(FP),
sum(ANC),
sum(HCG),
sum(PNC),
sum(HCT),
sum(PAC),
sum(TOLLFREE),
sum(OTHERAILMENTS),
sum(GENERALCOUNSELLING)
FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :a AND :b GROUP BY age_range ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
|
|
|
|
|
|
|
|
|
|
|
|
| TOTAL: |
prepare("SELECT sum(STI)
FROM cmpatientsregistration WHERE DATECREATED BETWEEN :a AND :b");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(STI)'];
echo formatMoney($dsdsd, true);
}
?>
|
prepare("SELECT sum(FP) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(FP)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(ANC) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(ANC)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(HCG) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(HCG)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(PNC) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(PNC)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(HCT) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(HCT)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(PAC) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(PAC)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(TOLLFREE) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(TOLLFREE)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(OTHERAILMENTS) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(OTHERAILMENTS)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(GENERALCOUNSELLING) FROM cmpatientsregistration
WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(GENERALCOUNSELLING)'];
echo formatMoney($zxc, true);
}
?>
|
|