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. HRA CCA P/AH |
KW/ALLO. P.C.F. 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);?>