S. No. |
B/NO. NAME RANK SCALE |
GPF_NO. PLI_NO. BNK_NM A/C_NO |
B_PAY SPL.PAY PP_1/SH_DO PP_2/TP/EA |
D.A. HR/A CC/A P/AH |
KW/ALLO. SW/ALLO. SO/SSI/A CON_A |
COM_A BODR/TRG. HILL/SMCH MEDAL/A |
GPF_HON. BLANG./A P/HAND/A OTH_A(CL/IR) |
GROSS |
GPF -AG |
GPF -IV |
HBA-1 HBA-2 HBA-3 PLI_DED |
HB/INT1 HB/INT2 HB/INT3 I-TAX |
CAR/MC/SC C/MC,INT. CYCLE CYCLE/INT. |
COMPUT_A COMP.INT GIS INST. |
GIS SAV. |
AI_INS HR_DED VE_DED MISDED |
TO- -TAL DEDs |
NET PAY ABLE |
RE- -MA- -RK |
$i=1;
$basic_pay=0;$spl_pay=0;$pp1_shado_allowance=0;$pp2_tp_elec_allownce=0;
$da=0;$hra_amount=0;$cca_amount=0;$p_ahar_allownce=0;
$k_m_allownce=0; $so_ssi_allownce=0;$convance_allownce=0;
$computer_allownce=0;$border_allownce=0;$hill_allownce=0;$medal_allownce=0;
$binalngual_allownce=0;$phy_hand_allownce=0;$other_allow_cl_ir=0;
$hba_1st_balance_recovery=0;$hba_2nd_balance_recovery=0;$hba_3rd_balance_recovery=0;$pli=0;
$hba_int_1st_balance_recov=0;$hba_int_2nd_Balance_recov=0;$hba_int_3rd_Balance_recov=0;$income_tax=0;
$mc_sc_adv_balance_rec=0;$mc_sc_int_balance_rec=0;$cycle_adv_balance_rec=0;
$computer_allownce=0; $computer_advance_INT_Balance_recovery=0; $gis_insurance=0;
$gis_saving=0;$house_rent_recovery2=0; $vehicle_deduction=0; $misc_adv_recov=0;
$dedectionSal=0;$net=0;$grossSal=0;
$gpfag=0;$gpfiv=0;
while($pnoArr=mysql_fetch_array($pnoquery)){
$salaryDetail=mysql_query("select * from salary_detail where personal_number='".$pnoArr['personal_number']."'") or die("salary query error = ".mysql_error());
if(mysql_num_rows($salaryDetail)!=0){
$row=mysql_fetch_array($salaryDetail);?>
|
|
|
$basic_pay=$basic_pay+$row['basic_pay'] ?>
$spl_pay=$spl_pay+$row['spl_pay'] ?>
$pp1_shado_allowance=$pp1_shado_allowance+$row['pp1_shado_allowance'] ?>
$pp2_tp_elec_allownce=$pp2_tp_elec_allownce+$row['pp2_tp_elec_allownce'] ?>
|
$da=$da+$row['da'] ?>
$hra_amount=$hra_amount+$row['hra_amount'] ?>
$cca_amount=$cca_amount+$row['cca_amount'] ?>
$p_ahar_allownce=$p_ahar_allownce+$row['p_ahar_allownce'] ?>
|
$k_m_allownce=$k_m_allownce+$row['k_m_allownce'] ?>
$so_ssi_allownce=$so_ssi_allownce+$row['so_ssi_allownce'] ?>
$convance_allownce=$convance_allownce+$row['convance_allownce'] ?>
|
$computer_allownce=$computer_allownce+$row['computer_allownce']?>
$border_allownce=$border_allownce+$row['border_allownce']?>
$hill_allownce=$hill_allownce+$row['hill_allownce']?>
$medal_allownce=$medal_allownce+$row['medal_allownce']?>
/
/
|
$binalngual_allownce=$binalngual_allownce+$row['binalngual_allownce']?>
$phy_hand_allownce=$phy_hand_allownce+$row['phy_hand_allownce']?>
$other_allow_cl_ir=$other_allow_cl_ir+$row['other_allow_cl_ir']?>
|
$grossSal=$grossSal+$gross;?>0 |
00 |
$gpfiv=$gpfiv+$row['gpf_subs'];?>
.00 |
$hba_1st_balance_recovery=$hba_1st_balance_recovery+$row['hba_1st_recv']?>
$hba_2nd_balance_recovery=$hba_2nd_balance_recovery+$row['hba_2nd_recv']?>
$hba_3rd_balance_recovery=$hba_3rd_balance_recovery+$row['hba_3rd_recv']?>
$pli=$pli+$row['pli']?>
|
$hba_int_1st_balance_recov=$hba_int_1st_balance_recov+$row['hba_int_1st_recovery']?>
$hba_int_2nd_Balance_recov=$hba_int_2nd_Balance_recov+$row['hba_int_2nd_recov']?>
$hba_int_3rd_Balance_recov=$hba_int_3rd_Balance_recov+$row['hba_int3rd_recov']?>
$income_tax=$income_tax+$row['income_tax']?>
|
$mc_sc_adv_balance_rec=$mc_sc_adv_balance_rec+$row['mc_sc_adv_recovery']?>
$mc_sc_int_balance_rec=$mc_sc_int_balance_rec+$row['mc_sc_int_recovery']?>
$cycle_adv_balance_rec=$cycle_adv_balance_rec+$row['cycle_adv_recovery']?>
|
$computer_allownce=$computer_allownce+$row['computer_allownce']?>
$computer_advance_INT_Balance_recovery=$computer_advance_INT_Balance_recovery+$row['computer_advance_INT_Balance_recovery']?>
$gis_insurance=$gis_insurance+$row['gis_insurance']?>
|
$gis_saving=$gis_saving+$row['gis_saving']?>
|
$house_rent_recovery2=$house_rent_recovery2+$row['house_rent_recovery2']?>
$vehicle_deduction=$vehicle_deduction+$row['vehicle_deduction']?>
$misc_adv_recov=$misc_adv_recov+$row['misc_adv_recov']?>
|
$dedectionSal=$dedectionSal+$dedection?>
0
|
$net=$net+($gross-$dedection);?>
0
|
|
$i++;
}
}
//echo "counter = ".$i;?>