ATTENDECE TO SERVICES BY MONTH BETWEEN AND
SERVICE TYPE | JULY | AUG | SEPT | OCT | NOV | DEC | JAN | FEB | MARCH | APRIL | MAY | JUNE |
---|---|---|---|---|---|---|---|---|---|---|---|---|
TOTAL: | prepare("SELECT sum(RECORDCOUNTER) FROM cmpatientsregistration WHERE FISCALMONTH = '07' 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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 cmpatientsregistration 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); } ?> |