SUMMARY OF ANC PERFORMANCE BETWEEN AND
| AGE GROUP |
IS-SCH |
OUT-SCH |
TOTAL |
MALE ESCORT |
ANC TESTED FOR HIV |
ANC TESTED HIV + |
NEW ANC VISTS |
NEW ANC TESTED HIV + |
prepare("SELECT DATECREATED, USERINITIAL,
CASE
WHEN AGE BETWEEN 10 AND 14 THEN '10-14'
WHEN AGE BETWEEN 15 AND 19 THEN '15-19'
WHEN AGE BETWEEN 20 AND 24 THEN '20-24'
WHEN AGE > 24 THEN 'Over 24'
END AS age_range,
sum( if( SCHOOLINGSTATUS = 'IS', RECORDCOUNTER, 0 ) ) AS insc,
sum( if( SCHOOLINGSTATUS = 'OS', RECORDCOUNTER, 0 ) ) AS ossc,
sum( if( PARTNERESCORT = 'YES', RECORDCOUNTER, 0 ) ) AS partner,
sum( if( ARTCLINIC='REFERRED', RECORDCOUNTER, 0 ) ) AS ref,
sum( if( FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS pos,
sum( if( VISTTYPE='NEW', RECORDCOUNTER, 0 ) ) AS newx,
sum( if( VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS explosion
FROM anteprogress
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(RECORDCOUNTER) FROM anteprogress WHERE SCHOOLINGSTATUS = 'IS' AND
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(RECORDCOUNTER)'];
echo formatMoney($dsdsd, true);
}
?> |
prepare("SELECT sum(RECORDCOUNTER) FROM anteprogress WHERE SCHOOLINGSTATUS = 'OS'
AND 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(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM anteprogress 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(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM anteprogress WHERE PARTNERESCORT = 'YES' AND 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(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM anteprogress WHERE ARTCLINIC='REFERRED' AND 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(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM anteprogress WHERE FINALREACTIVITY='POSITIVE' AND 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(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM anteprogress WHERE VISTTYPE='NEW' AND 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(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM anteprogress WHERE VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE' AND 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(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|