ANC DAILY TALLY TOOL FROM TO
| |
TRIMISTER |
ANC TESTED FOR HIV |
ANC TESTED HIV + |
MALE ESCORT |
NEW ANC VISTS |
NEW ANC TESTED HIV + |
| DATE |
10-14 YEARS |
15-19 YEARS |
20-24 YEARS |
IN-SCH |
OUT-SCH |
NO.OF CLIENTS |
MADE ATLEST.4 |
IPT 1ST |
IPT.2ND & 3RD |
10-14 YEARS |
15-19 YEARS |
20-24 YEARS |
NO.OF CLIENTS |
10-14 YEARS |
15-19 YEARS |
20-24 YEARS |
NO.OF CLIENTS |
PARTNER ESCORT |
10-14 YEARS |
15-19 YEARS |
20-24 YEARS |
NO.OF CLIENTS |
10-14 YEARS |
15-19 YEARS |
20-24 YEARS |
NO.OF CLIENTS |
prepare("SELECT VISTDATECREATED,
sum( if( AGE_GROUP = '10-14', RECORDCOUNTER, 0 ) ) AS agegpone,
sum( if( AGE_GROUP = '15-19', RECORDCOUNTER, 0 ) ) AS agegptwo,
sum( if( AGE_GROUP = '20-24', RECORDCOUNTER, 0 ) ) AS agegpthree,
sum( if( SCHOOLINGSTATUS = 'IS', RECORDCOUNTER, 0 ) ) AS insch,
sum( if( SCHOOLINGSTATUS = 'OS', RECORDCOUNTER, 0 ) ) AS outsch,
sum( if( IPT = '1', RECORDCOUNTER, 0 ) ) AS iptone,
sum( if( IPT = '2', RECORDCOUNTER, 0 ) ) AS iptabove,
sum( if( PARTNERESCORT = 'YES', RECORDCOUNTER, 0 ) ) AS partner,
sum( if( AGE_GROUP = '10-14' AND ARTCLINIC='REFERRED', RECORDCOUNTER, 0 ) ) AS agegponex,
sum( if( AGE_GROUP = '15-19' AND ARTCLINIC='REFERRED', RECORDCOUNTER, 0 ) ) AS agegptwox,
sum( if( AGE_GROUP = '20-24' AND ARTCLINIC='REFERRED', RECORDCOUNTER, 0 ) ) AS agegpthrex,
sum( if( AGE_GROUP = '10-14' AND FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS agegponexx,
sum( if( AGE_GROUP = '15-19' AND FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS agegptwoxx,
sum( if( AGE_GROUP = '20-24' AND FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS agegpthrexx,
sum( if( AGE_GROUP = '10-14' AND VISTTYPE='NEW', RECORDCOUNTER, 0 ) ) AS agegponexxx,
sum( if( AGE_GROUP = '15-19' AND VISTTYPE='NEW', RECORDCOUNTER, 0 ) ) AS agegptwoxxx,
sum( if( AGE_GROUP = '20-24' AND VISTTYPE='NEW', RECORDCOUNTER, 0 ) ) AS agegpthrexxx,
sum( if( AGE_GROUP = '10-14' AND VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS agegponexxxx,
sum( if( AGE_GROUP = '15-19' AND VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS agegptwoxxxx,
sum( if( AGE_GROUP = '20-24' AND VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE', RECORDCOUNTER, 0 ) ) AS agegpthrexxxx,
sum( if( IPT = '4', RECORDCOUNTER, 0 ) ) AS attfo
FROM anteprogress
WHERE VISTDATECREATED BETWEEN :a AND :b GROUP BY VISTDATECREATED");
$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 AGE_GROUP = '10-14'
AND VISTDATECREATED 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 AGE_GROUP = '15-19'
AND VISTDATECREATED 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 AGE_GROUP = '20-24'
AND VISTDATECREATED 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 SCHOOLINGSTATUS = 'IS'
AND VISTDATECREATED 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 SCHOOLINGSTATUS = 'OS'
AND VISTDATECREATED 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 VISTDATECREATED 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 IPT = '4' AND VISTDATECREATED
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 IPT = '1' AND VISTDATECREATED
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 IPT = '2' AND VISTDATECREATED
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 AGE_GROUP = '10-14'
AND VISTDATECREATED BETWEEN :c AND :d AND ARTCLINIC='REFERRED'");
$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 AGE_GROUP = '15-19'
AND VISTDATECREATED BETWEEN :c AND :d AND ARTCLINIC='REFERRED'");
$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 AGE_GROUP = '20-24'
AND VISTDATECREATED BETWEEN :c AND :d AND ARTCLINIC='REFERRED'");
$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 VISTDATECREATED BETWEEN :c AND :d AND ARTCLINIC='REFERRED'");
$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 AGE_GROUP = '10-14'
AND VISTDATECREATED BETWEEN :c AND :d AND FINALREACTIVITY='POSITIVE'");
$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 AGE_GROUP = '15-19'
AND VISTDATECREATED BETWEEN :c AND :d AND FINALREACTIVITY='POSITIVE'");
$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 AGE_GROUP = '20-24'
AND VISTDATECREATED BETWEEN :c AND :d AND FINALREACTIVITY='POSITIVE'");
$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 VISTDATECREATED BETWEEN :c AND :d AND FINALREACTIVITY='POSITIVE'");
$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 VISTDATECREATED 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 AGE_GROUP = '10-14'
AND VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW'");
$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 AGE_GROUP = '15-19'
AND VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW'");
$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 AGE_GROUP = '20-24'
AND VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW'");
$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 VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW'");
$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 AGE_GROUP = '10-14'
AND VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE'");
$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 AGE_GROUP = '15-19'
AND VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE'");
$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 AGE_GROUP = '20-24'
AND VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE'");
$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 VISTDATECREATED BETWEEN :c AND :d AND VISTTYPE='NEW' AND FINALREACTIVITY='POSITIVE'");
$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);
}
?>
|