Division Wise
Contraceptive Distribution and Performed by NGO
Reporting Period:
Select Month
January
February
March
April
May
June
July
August
September
October
November
December
Select Year
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
$m=$_POST['H_Mon']; $y=$_POST['H_Year']; $Date="$y-$m-28"; ?>
//Month name $sql=mysql_query("select M_name from month where M_id='$m'"); $rowM=mysql_fetch_array($sql); $VDate=$rowM['M_name']; //Query output $result = mysql_query("Select division.Div_Name, Sum(pill_shukhi) shukhi,Sum(pill_apon) apon,Sum(condom_nirapod) condom, Sum(inj_vial) inj_vial,Sum(inj_syringe) inj_siringe, Sum(iud_normal) iud_normal,Sum(iud_partum) iud_partum,Sum(iud_total) iud_total,Sum(iud_remove) iud_remove, Sum(imp_normal) imp_normal,Sum(imp_jadel) imp_jadel,Sum(imp_remove)implant_remove, Sum(ecp_pieces) ecp,Sum(misoprostol_dose) misoprostol,Sum(mrm_pack) mrm_pack,Sum(inj_mgs4) inj_mgs4, Sum(mnp_saset) mnp_saset,Sum(ifa_number) ifa_number,Sum(sanitary_pad) sanitary_pad, Sum(male_number) per_male,Sum(female_normal) femalenormal,Sum(female_partum) femalepn,Sum(female_total) female_total From division,district,thana,distribution_details Where division.Div_code = district.Div_code And district.Dist_code = thana.Dist_code And distribution_details .thana_code=thana.thana_code And distribution_details .Month_Id='$Date' And NGO_Code<>'1' Group By division.Div_code Order By division.Div_code "); $num=mysql_num_rows($result); //Reporting Thana Count $sql1=mysql_query("select count(Thana_code) Thana_code from distribution_details where Month_Id='$Date' And NGO_Code='1'"); $row1=mysql_fetch_array($sql1); $R_Thana=$row1['Thana_code']; //Total Thana Count $sql2=mysql_query("select count(Thana_code) Thana_code from thana "); $row2=mysql_fetch_array($sql2); $T_Thana=$row2['Thana_code']; //Month name $sql=mysql_query("select m_name from month where M_id='$m'"); $rowM=mysql_fetch_array($sql); $M_Name=$rowM['m_name']; ?>
Reporting Period: echo $M_Name; ?>, echo $y;?>
Distribution & Performed
Sl no
Division
Distridution
Performed
Oral Pill (Cycle)
Condom (Nirapad)
(Pieces)
Injectable
IUD
Implant
ECP
Misoprostol
(Dose)
MRM
(Pack )
Injection
MgS04
MNP
(Saset)
IFO
(Number)
Sanitary Pad
(Number)
Permanant Method
New
Remove
New
Remove
Male (Number)
Female (Number)
Shukhi
Apon
Vial
Syringe
Normal
Post partum
Total
Implanon
Jadel
Normal
Post partum
Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
$count=0; $i=0; while ($i<$num){ $division_name=mysql_result($result,$i,"division.Div_Name"); $shukhi=mysql_result($result,$i,"shukhi"); $apon=mysql_result($result,$i,"apon"); $condom=mysql_result($result,$i,"condom"); $inj_vial=mysql_result($result,$i,"inj_vial"); $inj_siringe=mysql_result($result,$i,"inj_siringe"); $iud_normal=mysql_result($result,$i,"iud_normal"); $iud_pn=mysql_result($result,$i,"iud_partum"); $iud_total=mysql_result($result,$i,"iud_total"); $iud_remove=mysql_result($result,$i,"iud_remove"); $imp_normal=mysql_result($result,$i,"imp_normal"); $imp_jadel=mysql_result($result,$i,"imp_jadel"); $implant_remove=mysql_result($result,$i,"implant_remove"); $ecp=mysql_result($result,$i,"ecp"); $misoprostol=mysql_result($result,$i,"misoprostol"); $mrm_pack=mysql_result($result,$i,"mrm_pack"); $inj_mgs4=mysql_result($result,$i,"inj_mgs4"); $mnp_saset=mysql_result($result,$i,"mnp_saset"); $per_male=mysql_result($result,$i,"per_male"); $ifa_number=mysql_result($result,$i,"ifa_number"); $sanitary_pad=mysql_result($result,$i,"sanitary_pad"); $per_male=mysql_result($result,$i,"per_male"); $femalenormal=mysql_result($result,$i,"femalenormal"); $femalepn=mysql_result($result,$i,"femalepn"); $female_total=$femalenormal+$femalepn; $count=$count+1; $T3=$T3+$shukhi; $T4=$T4+$apon; $T5=$T5+$condom; $T6=$T6+$inj_vial; $T7=$T7+$inj_siringe; $T8=$T8+$iud_normal; $T9=$T9+$iud_pn; $T11=$T11+$iud_remove; $T12=$T12+$implant_remove; $T13=$T13+$imp_jadel; $T14=$T14+$implant_remove; $T15=$T15+$ecp; $T16=$T16+$misoprostol; $T17=$T17+$mrm_pack; $T18=$T18+$inj_mgs4; $T19=$T19+$mnp_saset; $T20=$T20+$ifa_number; $T21=$T21+$sanitary_pad; $T22=$T22+$per_male; $T23=$T23+$femalenormal; $T24=$T24+$femalepn; ?>
echo $count;?>
echo $division_name;?>
echo $shukhi;?>
echo $apon;?>
echo $condom;?>
echo $inj_vial;?>
echo $inj_siringe;?>
echo $iud_normal;?>
echo $iud_pn;?>
echo $iud_total;?>
echo $iud_remove;?>
echo $imp_normal;?>
echo $imp_jadel;?>
echo $implant_remove;?>
echo $ecp;?>
echo $misoprostol;?>
echo $mrm_pack;?>
echo $inj_mgs4;?>
echo $mnp_saset;?>
echo $ifa_number;?>
echo $sanitary_pad;?>
echo $per_male;?>
echo $femalenormal;?>
echo $femalepn;?>
echo $female_total;?>
++$i; } $T10=$T8+$T9; $T25=$T23+$T24; ?>
echo 'National total';?>
echo $T3;?>
echo $T4;?>
echo $T5;?>
echo $T6;?>
echo $T7;?>
echo $T8;?>
echo $T9;?>
echo $T10;?>
echo $T11;?>
echo $T12;?>
echo $T13;?>
echo $T14;?>
echo $T15;?>
echo $T16;?>
echo $T17;?>
echo $T18;?>
echo $T19;?>
echo $T20;?>
echo $T21;?>
echo $T22;?>
echo $T23;?>
echo $T24;?>
echo $T25;?>