| UNIT/DISTT. : |
FOR THE MONTH OF - |
| File Name : |
|
| TITLE |
NO OF EMPLOYEES |
INSURANCE |
SAVING |
TOTAL |
$mnth=$_POST['txtmnth'];
$yr=$_POST['txtyr'];
$cader=$_POST['cadre'];
if($cader==''){
$cadcond=" and a.bill_category is null";
}else{
$cadcond=" and a.bill_category='".$cader."'";
}
if($mnth==gmdate("m",time()+19800)){
$dc=" and (b.joining_unit='".$_SESSION['Unit']."' OR b.joining_sub_unit='".$_SESSION['Unit']."' or b.archive_date='".$_SESSION['Unit']."')";
}else{
$dc=" and (a.posting_unit='".$_SESSION['Unit']."')";
}
$qry="select a.gis_insurance, a.gis_saving from salary_detail a, new_posting_detail b where a.personal_number=b.personal_number ".$dc." and a.for_month=".$mnth." and a.for_year=".$yr." and a.gis_insurance!=0 and a.gis_saving!=0 and a.sus_status!=4 ".$cadcond;
$salaryDetail=mysql_query($qry) or die(mysql_error());
if(mysql_num_rows($salaryDetail)!=0){
while($row=mysql_fetch_array($salaryDetail)){
$gisTotal=$row['gis_insurance']+$row['gis_saving'];
if($gisTotal=="400") {
++$oneTwentySlabCounter;
$ins120= $ins120+($row['gis_insurance']);
$sav120= $sav120+($row['gis_saving']);
$total120=$ins120+$sav120;
}else if($gisTotal=="200"){
++$sixtySlabCounter;
$ins60= $ins60+($row['gis_insurance']);
$sav60= $sav60+($row['gis_saving']);
$total60=$ins60+$sav60;
}else if($gisTotal=="100"){
++$thirtySlabCounter;
$ins30= $ins30+($row['gis_insurance']);
$sav30= $sav30+($row['gis_saving']);
$total30=$ins30+$sav30;
}
$totalCount=$oneTwentySlabCounter+$sixtySlabCounter+$thirtySlabCounter;
$totalIns=$ins120+$ins60+$ins30;
$totalSav=$sav120+$sav60+$sav30;
$grandTotal=$total120+$total60+$total30;
}
}?>
| @ 400/- P.M. |
0 |
0 |
0 |
0 |
| @ 200/- P.M. |
0 |
0 |
0 |
0 |
| @ 100/- P.M. |
0 |
0 |
0 |
0 |
| TOTAL - |
0 |
0.00 |
0.00 |
0.00 |
| TOTAL -
ZERO Only |
|