|
![](../../assets/img/logsbig.PNG)
HCT REPORT BETWEEN AND
SERVICE DATE |
AGE GORUP |
GENDER |
SCHOOLING |
RESULTS |
POSITIVE |
|
10 - 14 |
15 - 19 |
20 - 24 |
Above 24 |
TOTAL |
FEMALE |
MALE |
TOTAL |
IS-SCH |
OUT-SCH |
TOTAL |
POS(+) |
NEG(-) |
TOTAL |
WANTED |
UN WANTED |
TOTAL |
prepare("SELECT DATECREATED, USERINITIAL,
sum( if( AGE_GROUP = '10-14', RECORDCOUNTER, 0 ) ) AS aa,
sum( if( AGE_GROUP = '15-19', RECORDCOUNTER, 0 ) ) AS bb,
sum( if( AGE_GROUP = '20-24', RECORDCOUNTER, 0 ) ) AS cc,
sum( if( AGE_GROUP = '24', RECORDCOUNTER, 0 ) ) AS dd,
sum( if( SEX = 'FEMALE', RECORDCOUNTER, 0 ) ) AS FEMALEA,
sum( if( SEX = 'MALE', RECORDCOUNTER, 0 ) ) AS MALEA,
sum( if( SCHOOLING = 'IS', RECORDCOUNTER, 0 ) ) AS insc,
sum( if( SCHOOLING = 'OS', RECORDCOUNTER, 0 ) ) AS ossc,
sum( if( HCGRESULTS = 'POSITIVE', RECORDCOUNTER, 0 ) ) AS pos,
sum( if( HCGRESULTS = 'NEGATIVE', RECORDCOUNTER, 0 ) ) AS neg,
sum( if( HCGPOSITIVE = 'WANTED', RECORDCOUNTER, 0 ) ) AS wan,
sum( if( HCGPOSITIVE = 'UN WANTED', RECORDCOUNTER, 0 ) ) AS unwan
FROM hcg
WHERE DATECREATED BETWEEN :a AND :b GROUP BY DATECREATED ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL |
prepare("SELECT sum(RECORDCOUNTER) FROM hcg WHERE
DATECREATED BETWEEN :a AND :b AND AGE_GROUP = '10-14'");
$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 hcg WHERE
DATECREATED BETWEEN :c AND :d AND AGE_GROUP = '15-19'");
$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 hcg WHERE
DATECREATED BETWEEN :c AND :d AND AGE_GROUP = '20-24'");
$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 hcg WHERE
DATECREATED BETWEEN :c AND :d AND AGE_GROUP = '24'");
$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 hcg 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 hcg WHERE SEX = 'FEMALE'
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 hcg WHERE SEX = 'MALE'
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 hcg 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 hcg WHERE SCHOOLING = 'IS' 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 hcg WHERE SCHOOLING = '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 hcg 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 hcg WHERE HCGRESULTS = '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 hcg WHERE HCGRESULTS = 'NEGATIVE' 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 hcg 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 hcg WHERE HCGPOSITIVE = 'WANTED' 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 hcg WHERE HCGPOSITIVE = 'UN WANTED' 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 hcg 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);
}
?>
|