|
District Wise NGO
Contraceptive Acceptors and Acceptance Rate (CAR%) |
|
'1'
Group By district.Dist_Name Order By district.Dist_code");
$num=mysql_num_rows($result);
//Total Output
$Tresult =mysql_query("select sum(car_details.Total_EC) TEC,
(Sum(car_details.Pill_Old)+Sum(car_details.Pill_New)) TPill,
(Sum(car_details.Con_Old)+Sum(car_details.Con_New)) TCon,
(Sum(car_details.Inj_Old)+Sum(car_details.Inj_New)) TInj,
(Sum(car_details.IUD_Old)+Sum(car_details.IUD_New)) TIUD,
(Sum(car_details.Imp_Old)+Sum(car_details.Imp_New)) TImp,
(Sum(car_details.PerM_Old)+Sum(car_details.PerM_New)) TPerM,
(Sum(car_details.PerF_Old)+Sum(car_details.PerF_New)) TPerF,
(Sum(car_details.PerM_Old)+Sum(car_details.PerM_New)+Sum(car_details.PerF_Old)+Sum(car_details.PerF_New)) TTPer,
(((Sum(car_details.Pill_Old)+Sum(car_details.Pill_New))+
(Sum(car_details.Con_Old)+Sum(car_details.Con_New))+
(Sum(car_details.Inj_Old)+Sum(car_details.Inj_New))+
(Sum(car_details.IUD_Old)+Sum(car_details.IUD_New))+
(Sum(car_details.Imp_Old)+Sum(car_details.Imp_New))+
(Sum(car_details.PerM_Old)+Sum(car_details.PerM_New))+
(Sum(car_details.PerF_Old)+Sum(car_details.PerF_New)) )/sum(car_details.Total_EC))*100 TTCAR
from district,thana,car_details
Where ((district.Dist_code = thana.Dist_code)
And (car_details.Thana_code=thana.Thana_code))
And car_details.Month_Id='$Date' And NGO_Code<>'1'
AND district.Div_Code='$div_code'");
$Trow=mysql_fetch_array($Tresult);
$T_EC=$Trow['TEC'];
$T_Pill=$Trow['TPill'];
$T_Con=$Trow['TCon'];
$T_Inj=$Trow['TInj'];
$T_IUD=$Trow['TIUD'];
$T_Imp=$Trow['TImp'];
$T_PerM=$Trow['TPerM'];
$T_PerF=$Trow['TPerF'];
$T_Tper=$Trow['TTPer'];
$T_Total=$T_Pill+$T_Con+$T_Inj+$T_IUD+$T_Imp+$T_Tper;
$T_CAR=number_format($Trow['TTCAR'],2);
//Reporting Thana Count
$sql1=mysql_query("select count(Thana_code) Thana_code from car_details where Month_Id='$Date' And NGO_Code='1'
And substr(Thana_code,1,2)='$div_Code'");
$rowR=mysql_fetch_array($sql1);
$R_Thana=$rowR['Thana_code'];
//Total Thana Count
$sql2=mysql_query("select count(Thana_code) Thana_code from thana where substr(Thana_code,1,2)='$div_Code'");
$rowT=mysql_fetch_array($sql2);
$T_Thana=$rowT['Thana_code'];
?>
Division:
Reporting Month: , |
| District Name |
Eligible Couple |
Oral Pill |
Condom |
Injectable |
I U D |
Implant |
Permanent Method |
Total Acceptors |
CAR(%) |
| Male |
Female |
Total |
|
| |
|
|
|
|
|
|
|
|
|
Division Total |
|
|
|
|
|
|
|
|
|
|
|
