![](../../assets/img/logsbig.PNG)
TOLLFREE REPORT FOR THE PERIOD BETWEEN TO
Number of young people calling on tollfree by age and gender
AGE GROUP |
FEMALE |
MALE |
TOTAL |
prepare("SELECT DATECREATED,
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( SEX = 'FEMALE', RECORDCOUNTER, 0 ) ) AS FEMALE,
sum( if( SEX = 'MALE', RECORDCOUNTER, 0 ) ) AS MALE
FROM tollfree
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 tollfree WHERE SEX = 'FEMALE' 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 tollfree 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 tollfree 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);
}
?>
|
Number of calls by months
AGE GROUP |
JULY |
AUG |
SEPT |
OCT |
NOV |
DEC |
JAN |
FEB |
MARCH |
APRIL |
MAY |
JUNE |
prepare("SELECT DATECREATED,
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( FISCALMONTH = '07', RECORDCOUNTER, 0 ) ) AS july,
sum( if( FISCALMONTH = '08', RECORDCOUNTER, 0 ) ) AS aug,
sum( if( FISCALMONTH = '09', RECORDCOUNTER, 0 ) ) AS sept,
sum( if( FISCALMONTH = '10', RECORDCOUNTER, 0 ) ) AS oct,
sum( if( FISCALMONTH = '11', RECORDCOUNTER, 0 ) ) AS nov,
sum( if( FISCALMONTH = '12', RECORDCOUNTER, 0 ) ) AS dece,
sum( if( FISCALMONTH = '01', RECORDCOUNTER, 0 ) ) AS jani,
sum( if( FISCALMONTH = '02', RECORDCOUNTER, 0 ) ) AS febi,
sum( if( FISCALMONTH = '03', RECORDCOUNTER, 0 ) ) AS march,
sum( if( FISCALMONTH = '04', RECORDCOUNTER, 0 ) ) AS apr,
sum( if( FISCALMONTH = '05', RECORDCOUNTER, 0 ) ) AS ma,
sum( if( FISCALMONTH = '06', RECORDCOUNTER, 0 ) ) AS juna
FROM tollfree
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 tollfree WHERE FISCALMONTH = '07'
AND DATECREATED BETWEEN :a AND :b");
$resultia->bindParam(':a', $d1);
$resultia->bindParam(':b', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM tollfree WHERE FISCALMONTH = '08'
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 tollfree WHERE FISCALMONTH = '09'
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 tollfree WHERE FISCALMONTH = '10'
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 tollfree WHERE FISCALMONTH = '11'
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 tollfree WHERE FISCALMONTH = '12'
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 tollfree WHERE FISCALMONTH = '01'
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 tollfree WHERE FISCALMONTH = '02'
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 tollfree WHERE FISCALMONTH = '03'
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 tollfree WHERE FISCALMONTH = '04'
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 tollfree WHERE FISCALMONTH = '05'
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 tollfree WHERE FISCALMONTH = '06'
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);
}
?>
|
Number of callers by reason for calling
PROBLEM CATEGORY |
FEMALE |
MALE |
TOTAL |
prepare("SELECT DATECREATED, PROBLEMCATEGORY,
sum( if( SEX = 'FEMALE', RECORDCOUNTER, 0 ) ) AS FEMALEX,
sum( if( SEX = 'MALE', RECORDCOUNTER, 0 ) ) AS MALEX
FROM tollreasons
WHERE DATECREATED BETWEEN :a AND :b GROUP BY PROBLEMCATEGORY ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
|
|
|
|
Total: |
prepare("SELECT sum(RECORDCOUNTER) FROM tollreasons WHERE SEX = 'FEMALE'
AND DATECREATED BETWEEN :a AND :b");
$resultia->bindParam(':a', $d1);
$resultia->bindParam(':b', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM tollreasons 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 tollreasons 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);
}
?>
|
Number of callers by gender and geographical location
DISTRICT |
FEMALE |
MALE |
TOTAL |
prepare("SELECT DATECREATED, DISTRICT,
sum( if( SEX = 'FEMALE', RECORDCOUNTER, 0 ) ) AS FEMALEY,
sum( if( SEX = 'MALE', RECORDCOUNTER, 0 ) ) AS MALEY
FROM tollfree
WHERE DATECREATED BETWEEN :a AND :b GROUP BY DISTRICT ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
|
|
|
|
Total: |
prepare("SELECT sum(RECORDCOUNTER) FROM tollfree WHERE SEX = 'FEMALE'
AND DATECREATED BETWEEN :a AND :b");
$resultia->bindParam(':a', $d1);
$resultia->bindParam(':b', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
|
prepare("SELECT sum(RECORDCOUNTER) FROM tollfree 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 tollfree 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);
}
?>
|