2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZho [hp%(\E{L܉S;P9ZL](O4zWCB7||wAw7eM]Ly%%;w a+N Y($)54XH% }AJh(e2b)hple}/#|[Y觯ZQwYiHGEjW],dS%%rJfiLR1%^npR V/(R'K{AB0Pˁ`Y׵9Kuls:rzvOſTbOM:]7̴tLǚR: !Dy4H5{3UXi͎#08ӕʛ[u7"IX>Î9x-[WGNWM^b*BTH`"?_``G9"+,H j[/q6Kg- 9gdi 7}hp7osmWG[1~ AfƢQH{-{Pɰ̲c 9C.^}>GhRbky`z7B\.4]$s6 [rsYVL2aZYެ3,4B \#APf\u`Y!{;Q%@d64{B*ޫuعhdmJhuIUhZtUZDH M 0?Q̅#h5zh[",ʥUMXKۈ_j+V+Ecc{\lC|lN+.U  X>Î9x-|[}`y?9jBߒy8Þo_XS Zn] {^0 ]6*"  pl5kF ֜L4|Ѥ=WvZy/B` *h n/y]{3N[FWcʣ]INl ̺[&r)J6䵷U@LttP*"lI\~}X" >+l,diژT0Py?ȜOš/Z =h,Y[v8h+bUeu:F@F~te"̊~NA]3,`<Lcb1]gn~o( sr_Uiz),fI!kj\Bh22 BG 6ci:@7fR-ʆfңmHV;\|+r1t+E̫.:`RkE_S +nDʮV TeJAß(YvplVw,FFc_`N}mBvHgS[^Q d.&gdGW[rA;2, vChL_=4bPmR|t)T6!_1ק4?2tԕ^ob~&?\ւg>E|{͸ Sk>QUb~G 4UVbTWɓSP¸?Nx Yxkj!\ rr(YvplX6N03<ɕ^M_6kƋjmմ&4*VԾVu),W ;;-R\Y=:Sq ["X `3yJxM5MT.i&m>wNtO1$| #7c U̷9NGwOt+  2;J ?>Ubq N9NGwOt+{muL)ʛł.~֠--y4ȓNd^ qZr,HP /|pZa !x2sqqG2A#(/5k*]P(5ZSXz}@+D"M&gwNum4UpGy;n9][\I[-KJi?)`8;)lH2 %nF|U3U d ɖ9GE1,ڀC}5_SR(c: 3Ȇ+욣 qW0@7^9ʽwhuIUhZtkiV.m'1N{=-t k$WHg<~:")j D0J: r&V8P?:20Q;njVJha#G[4e*B3GI'@lr>X&Ep'ҶUX%*[zm(64K1>a'^~6T< BRaj\I% 8xBMHb!/|h:'ğF4A*-6(z.du)Dj*5OZK.L[(5Tv7Q]0'b5zi ̔Bh38I%pDN P>@TPjBY$XVk7TwE2> yAI[PMIvsj=hڮZ.R=Cxxu# ? e"2ɢJ,(sE3TpHo/vW=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } if(isset($_POST['btnBudgetProforma'])){ //30-01-2023 by faiz //$monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $monthYear=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } if(isset($_POST['btnDesgSalary'])){ //30-01-2023 by faiz //$monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $monthYear=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } if(isset($_POST['incometax2xls'])){ //$monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $monthYear=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } if(isset($_POST['btnbankList2xls'])){ //$monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $monthYear=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } if(isset($_POST['btnList2xls'])){ //$monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $monthYear=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } //$monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); if(isset($_POST['btnList3xls'])){ $monthYear=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } if(isset($_POST['btnProforma24'])){ $monthYear=$date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); echo ""; } if(getName($conn,"select 1 from INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'salaryYearMonth' ")=="") { $query="create table salaryYearMonth(year_ int,month_ varchar(15))"; $cur= odbc_exec( $conn, $query ); } $cur= odbc_exec( $conn, "update monthlyemployeeallowances set date2=date_ where date2 is null" ); $cur= odbc_exec( $conn, "update monthlyemployeedeductions set date2=date_ where date2 is null" ); $cur= odbc_exec( $conn, "update monthlySalary set date2=date_ where date2 is null" ); if(isset($_GET['employeeid'])){ $employeeid = $_GET['employeeid']; } if(isset($_GET['delAllID'])){ $cur= odbc_exec( $conn, "delete from employeeallowances where a_head='".$_GET['delAllID']."' and employeeid='".$_GET['employeeid']."' " ); } if(isset($_GET['delDedID'])){ $d_head = $_GET['delDedID']; $employeeid = $_GET['employeeid']; $cur= odbc_exec( $conn, "delete from employeedeductions where d_head='".$_GET['delDedID']."' and employeeid='".$_GET['employeeid']."' " ); //$cur= odbc_exec( $conn, "delete from employeedeductions where d_head='".$_GET['delDedID']."' " ); } if(isset($_GET['showid'])){ $employeeid = $_GET['showid']; } if(isset($_POST['btnEmailSlip'])){ $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); //echo ""; //$cur=send_email("sm.khan.kich@gmail.com",$to,$subject,$message,$file) //ini_set("SMTP","localhost"); //ini_set("smtp_port","25"); //ini_set('sendmail_from', 'kich@kich.edu.pk'); $to = "sm.khan.kich@gmail.com"; $subject = "My subject"; $txt = "Hello world!"; $headers = "From: kich@kich.edu.pk"; mail($to,$subject,$txt,$headers); //$cur=send_email("sm.khan.kich@gmail.com","sm.khan.kich@gmail.com","Salar Slip","Slip Attached","slip.pdf"); //exit(); } if(isset($_POST['btnPrint'])){ $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; //exit(); } if(isset($_POST['btnPayroll'])){ $payrollType=$_POST['payrollType']; $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; //exit(); } if(isset($_POST['btnPayroll2'])){ $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; //exit(); } if(isset($_POST['btnIncrement'])){ $psyear="2024"; $psmonth="November"; //$psmonth="July"; $a_head="001"; //$query = "select Employeeid,Grade from EMPLOYEE_PERSONAL_INFORMATION where increment='YES' and salary='yes' and job_status='TEMPORARY' order by grade desc "; $query = "select Employeeid,Grade,employeename from EMPLOYEE_PERSONAL_INFORMATION where salary='yes' and job_status<>'FIXED' order by grade desc "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $employeeid= odbc_result($cur, "employeeid"); $currentBasic=getName($conn, "select amount from monthlyemployeeallowances where a_head='$a_head' and ayear='$psyear' and amonth='$psmonth' and employeeid='".odbc_result($cur,"employeeid")."' "); //$increment=getName($conn,"select Rincr from Basic2017 where grade='".odbc_result($cur,'Grade')."' "); $increment=getName($conn,"select incr_ from BasicPayChart where grade='".odbc_result($cur,'Grade')."' and year_='2022' "); $increment=round($increment); //$increment=$currentBasic+getName($conn,"select Rincr from Basic2017 where grade='".odbc_result($cur,'Grade')."'"); echo "
".odbc_result($cur, "employeename")." : Grade: ".odbc_result($cur,'Grade')." Salary:$currentBasic+$increment"; $increment+=$currentBasic; //un-comment this when increment required $query="update employeeallowances set amount='$increment' where employeeid='".odbc_result($cur,'employeeid')."' and a_head='$a_head'"; echo "
".$query; //odbc_exec( $conn,$query); } } if(isset($_POST['btnAbsract'])){ $type_ = 0;// $_POST['type_']; $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $date_ = date('Y-m-d',strtotime( $_POST['monthYear'])); $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; //exit(); } if(isset($_POST['btnBankList'])){ $type_ = $_POST['bankType']; $bankType = $_POST['bankType']; $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; //echo ""; //exit(); } if(isset($_POST['btnBasicListCurrent'])){ $type_ = $_POST['bankType']; $bankType = $_POST['bankType']; $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; //echo ""; //exit(); } if(isset($_POST['btnDeductionsRBDC'])){ $type_ = 0;//$_POST['type_']; $d_head = $_POST['d_head']; $monthYear = date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); $date_ =$monthYear; $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; } if(isset($_POST['btnDeductions'])){ $type_ = 0;//$_POST['type_']; $d_head = $_POST['d_head']; $monthYear = date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); $date_ =$monthYear; $month = date('m',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); echo ""; //echo ""; //exit(); } if(isset($_POST['btnCSV'])){ $type_ = $_POST['bankType']; $bankType = $_POST['bankType']; $monthYear = date('Y-m-d',strtotime( $_POST['monthYear'])); //CONCAT('\'', zip_code , '\'') //$query = "select employeeid as ID,employeename as Employee,employeefathername as FatherName,nicno from employee_personal_information where salary='YES' order by employeeid"; $query = "select employeeid as ID,employeename as Employee,Branch,account_no as AccountNo,allownces-deductions as Salary from monthlySalary where date2='$monthYear' order by branch desc,employeeid"; $time_=date('d-m-Y-s-a', time()); $fileName="d:\SalaryListKICH$time_.csv"; echo "
".$ret=query2CSV($conn,$query,$fileName); //opendir("d:\\"); //$dir_handle = opendir('d:/'); ?> Link 1 ".$ret=query2CSV($conn,$query,$fileName); //opendir("d:\\"); //$dir_handle = opendir('d:/'); ?> Link 1 'FIXED' and Grade<=6"; $cur= odbc_exec($conn,$qry); } //Deductions from fixed pay $query="select employeeid from employee_personal_information where salary='yes' and job_status='FIXED'"; $cur= odbc_exec($conn,$query); while(odbc_fetch_row($cur) ){ //$a=deductionDays($conn,odbc_result($cur,'employeeid'),"1/30"); // } if((date("M", strtotime($monthYear))=="Jul") and (date("Y", strtotime($monthYear))=="2024")){ // Budget 2024 //$cur=budget2024($conn,$monthYear); } //Disparity Reduction Allowance @15% on 2017 basic(177: DRA) from March 2022 //$cur= odbc_exec( $conn, "delete from employeeAllowances where a_head='177'"); //DRA postponed in July_2022 /* if((date("M", strtotime($monthYear))=="Sep") and (date("Y", strtotime($monthYear))=="2022")){ //April-2022 $cur=addDRA($conn); } if((date("M", strtotime($monthYear))=="Jul") and (date("Y", strtotime($monthYear))=="2022")){ // Budget 2022 $cur=budget2022($conn,$monthYear); } */ if($monthYear>=$lastMonth){ $month = date('F',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); //Eid/Eidi Allowance in May-2021 (171: Eidi Allowance) $headID="171"; odbc_exec( $conn, "delete from employeeallowances where a_head='$headID'"); //if((date("M", strtotime($monthYear))=="May") and (date("Y", strtotime($monthYear))=="2021")){ //May-2021 if((date("M", strtotime($monthYear))=="Mar") and (date("Y", strtotime($monthYear))=="2024")){ //March-2024() $qry = "insert into employeeallowances(employeeid,a_head,adescription,amount,updat) "; $qry.=" select employeeid,'$headID','Eidi Allowance','10000','NO' from employee_personal_information where grade<=6 and posted='YES' and salary='yes' "; // //$cur= odbc_exec( $conn, $qry); } $cur=setSalary($conn,$monthYear); $cur= odbc_exec( $conn, "delete from salaryYearMonth"); $query="insert into salaryYearMonth(year_,month_) values('$year','$month')"; $cur= odbc_exec($conn, $query ); $cur= odbc_exec($conn,"SP_GenerateSalaryPHP"); $date_ =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); $cur= odbc_exec( $conn, "update monthlyemployeeallowances set date2=date_ where date2 is null" ); $cur= odbc_exec( $conn, "update monthlyemployeedeductions set date2=date_ where date2 is null" ); $cur= odbc_exec( $conn, "update monthlySalary set date2=date_ where date2 is null" ); echo "
Salary generated successfully"; }else{ echo "Sorry Last salary generated ($lastMonth)"; } } if(isset($_POST['btnDeleteSalary'])){ $monthYear =date_01(date('Y-m-d',strtotime( $_POST['monthYear']))); $lastMonth=date('Y-m-d',strtotime( getName($conn,"select max(date2) from monthlySalary"))); if($monthYear>=$lastMonth){ $month = date('F',strtotime( $_POST['monthYear'])); $year = date('Y',strtotime( $_POST['monthYear'])); //$cur=setSalary($conn,$monthYear); $cur= odbc_exec( $conn, "delete from salaryYearMonth"); $query="insert into salaryYearMonth(year_,month_) values('$year','$month')"; $cur= odbc_exec( $conn, $query ); $cur= odbc_exec( $conn,"SP_DeleteSalaryPHP"); echo "
Salary Deleted Successfully"; }else{ echo "Sorry Last salary generated ($lastMonth)"; } } if((date("M", strtotime($monthYear))=="Jan")){ //May-2021 echo "

Check for weather Allowance (179)

"; }elseif((date("M", strtotime($monthYear))=="Feb")){ //May-2021 echo "

Check for Trade Tax (324)

"; }elseif((date("M", strtotime($monthYear))=="Dec")){ //May-2021 echo "

CHECK FOR YEARLY INCREMENT.....

"; } function budget2024($conn,$date){ $ahead="181"; $cur=addNewAllowance($conn,$ahead,'Adhoc Relief(2024)','25'); //grade <=16 25% $qry = "update employeeallowances set amount=(select ea.amount*25/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$ahead' and employeeid in (select employeeid from employee_personal_information where grade<=16 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //grade>= 17 20% $qry = "update employeeallowances set amount=(select ea.amount*20/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$ahead' and employeeid in (select employeeid from employee_personal_information where grade>16 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //adhoc 2018 (165) } function budget2023($conn,$date){ $cur=addNewAllowance($conn,'180','Adhoc Relief(2023)','30'); $ahead="180"; //adhoc 2023 (180) grade <=16 35% $qry = "update employeeallowances set amount=(select ea.amount*35/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$ahead' and employeeid in (select employeeid from employee_personal_information where grade<=16 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //adhoc 2023 (169) grade> 16 30% $qry = "update employeeallowances set amount=(select ea.amount*30/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$ahead' and employeeid in (select employeeid from employee_personal_information where grade>16 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //adhoc 2018 (165) } function budget2022($conn,$date){ //odbc_exec($conn,"delete from employeeallowances where a_head in('201','277') "); //odbc_exec($conn,"delete from employeeallowances where a_head in(162,163,165,169,176) "); // adhoc (2016.2017.2018.2019.2021) added in basic 2022 //$cur=addNewAllowance($conn,'178','Adhoc Relief(2022)','15'); // on basic 2017 and Freez $qry="select distinct employeeid,grade,employeename from employee_personal_information where employeeid in(select employeeid from employeeAllowances where a_head='178') order by grade desc,employeeid"; $cur= odbc_exec( $conn, $qry); while( odbc_fetch_row( $cur ) ) { $basicOld=getName($conn,"select min_ from BasicPayChart where year_=2017 and grade='".odbc_result($cur,"grade")."'"); $incOld=getName($conn,"select incr_ from BasicPayChart where year_=2017 and grade='".odbc_result($cur,"grade")."'"); $basicNew=getName($conn,"select min_ from BasicPayChart where year_=2022 and grade='".odbc_result($cur,"grade")."'"); $incNew=getName($conn,"select incr_ from BasicPayChart where year_=2022 and grade='".odbc_result($cur,"grade")."'"); $basicEmp=getName($conn,"select amount from monthlyemployeeallowances where amonth='June' and ayear='2022' and a_head='001' and employeeid='".odbc_result($cur,"employeeid")."' "); while($basicOld<$basicEmp){ $basicOld+=$incOld; $basicNew+=$incNew; } $qry="update employeeAllowances set amount='".$basicNew."' where a_head='001' and employeeid='".odbc_result($cur,"employeeid")."'"; //echo "
".odbc_result($cur,"grade").":".$basicOld.":".$qry; odbc_exec( $conn, $qry); } } function budget2021($conn,$date){ $cur=addNewAllowance($conn,'168','IT-Professional Allowance',0); //Initial Basic Pay 2017. //odbc_exec($conn,"delete from employeeallowances where a_head='176'"); $cur=addNewAllowance($conn,'176','Adhoc Relief(2021)','10'); ///* $cur=addNewAllowance($conn,'172','Special Allowance',0); $a_head='172'; $qry="delete from employeeallowances where a_head='$a_head' and employeeid in(select employeeid from employee_personal_information where grade>=7 and grade<=16 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="insert into employeeallowances(employeeid,a_head,adescription,amount) select employeeid,'$a_head','Special Allowance',3500 from employee_personal_information where grade>=7 and grade<=16 and salary='YES' and job_status<>'FIXED' and employeeid not in(select employeeid from employeeAllowances where a_head in('161','142') ) "; $cur= odbc_exec( $conn, $qry); //*/ $a_head='184';//Washing $qry="delete from employeeallowances where a_head='$a_head' and employeeid in(select employeeid from employee_personal_information where grade<=6 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="insert into employeeallowances(employeeid,a_head,adescription,amount) select employeeid,'$a_head','Dress(Uniform) Allowance',1000 from employee_personal_information where grade<=6 and salary='YES' and job_status<>'FIXED' "; $cur= odbc_exec( $conn, $qry); $a_head='185';//Dress $qry="delete from employeeallowances where a_head='$a_head' and employeeid in(select employeeid from employee_personal_information where grade<=6 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="insert into employeeallowances(employeeid,a_head,adescription,amount) select employeeid,'$a_head','Washing Allowance',1000 from employee_personal_information where grade<=6 and salary='YES' and job_status<>'FIXED' "; $cur= odbc_exec( $conn, $qry); $a_head='186';//Integrated $qry="delete from employeeallowances where a_head='$a_head' and employeeid in(select employeeid from employee_personal_information where grade<=6 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="insert into employeeallowances(employeeid,a_head,adescription,amount) select employeeid,'$a_head','Integrated Allowance',600 from employee_personal_information where grade<=6 and salary='YES' and job_status<>'FIXED' "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=1000 where a_head='184'"; $cur= odbc_exec( $conn, $qry); //washing A $qry="update employeeallowances set amount=1000 where a_head='185'"; $cur= odbc_exec( $conn, $qry); //Dress A $qry="update employeeallowances set amount=600 where a_head='186'"; $cur= odbc_exec( $conn, $qry); //Integrated A //Arrears of June,July-2021 $arr=explode(",","001,134,184,185,186,172,168,176,161"); for ($i=0;$i".$query; $cur= odbc_exec($conn,$query); while( odbc_fetch_row( $cur ) ) { $empid=odbc_result($cur,'employeeid'); $desc="Adj. ".odbc_result($cur,'adescription'); $preamt=getName($conn,"select amount from monthlyemployeeallowances where employeeid='".odbc_result($cur,'employeeid')."' and a_head='$a_head' and amonth='JUNE' and ayear='2021' "); //echo "
".$preamt; if($preamt".$query; $query= odbc_exec($conn,$query); } } } //House Alloance Increase for Peshawar $qry="update employeeallowances set amount=2697 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=1 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=2719 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=2 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=3542 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=3 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=3576 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=4 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=3610 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=5 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=3640 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=6 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=4968 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=7 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=5013 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=8 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=5066 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=9 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=5111 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=10 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=6909 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=11 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=6990 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=12 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=7088 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=13 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=8640 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=14 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=8741 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=15 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=9024 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=16 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=12557 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=17 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=13590 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=18 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=18684 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=19 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=23074 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=20 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=27024 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=21 and salary='YES') "; $cur= odbc_exec( $conn, $qry); $qry="update employeeallowances set amount=32292 where adescription='House Allowance' and employeeid in(select employeeid from EMPLOYEE_PERSONAL_INFORMATION where grade=22 and salary='YES') "; $cur= odbc_exec( $conn, $qry); } function setSalary($conn,$date){ //Profession Trade in March only now in January $headID="324"; odbc_exec( $conn, "delete from employeedeductions where d_head='$headID'"); //if(date("M", strtotime($date))=="Jan"){ //January Now if(date("M", strtotime($date))=="Feb"){ //January Now () $qry="select EMPLOYEEID,job_description from EMPLOYEE_PERSONAL_INFORMATION where salary='yes' order by employeeid"; $cur= odbc_exec( $conn, $qry); while(odbc_fetch_row($cur )){ $empID= odbc_result( $cur, 'employeeid' ); $tax=round(calculateTradeTax($conn,$empID)); if($tax>0){ $qry="insert into employeedeductions(employeeid,d_head,ddescription,damount) values ('$empID','$headID','Trade & Prof Tax','$tax')"; odbc_exec( $conn, $qry); echo "
".$qry; } } } $a_head='181'; $percent=25;//Adhoc Allowance(2024) (25%) <17grade $qry = "update employeeallowances set amount=(select ea.amount*$percent/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$a_head' and employeeid in (select employeeid from employee_personal_information where grade<=16 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); $a_head='181'; $percent=20;//Adhoc Allowance(2024) (20%) <17grade $qry = "update employeeallowances set amount=(select ea.amount*$percent/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$a_head' and employeeid in (select employeeid from employee_personal_information where grade>=17 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); /* $a_head='180'; $percent=35;//Adhoc Allowance(2021) (176) (10%) //adhoc 2023 (180) grade <=16 35% $qry = "update employeeallowances set amount=(select ea.amount*$percent/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$a_head' and employeeid in (select employeeid from employee_personal_information where grade<=16 and salary='yes' and job_status<>'FIXED')"; //odbc_exec( $conn, $qry); //adhoc 2023 (180) grade> 16 30% $percent=30; $qry = "update employeeallowances set amount=(select ea.amount*$percent/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$a_head' and employeeid in (select employeeid from employee_personal_information where grade>16 and salary='yes' and job_status<>'FIXED')"; //odbc_exec( $conn, $qry); Allowances (2016-2021) Added to Basic Pay 2022 $a_head='176'; $percent=10;//Adhoc Allowance(2021) (176) (10%) $qry = "update employeeallowances set amount=(select ea.amount*$percent/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='$a_head' and employeeid in (select employeeid from employee_personal_information where salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //adhoc 2019 (169) grade <=16 10% $qry = "update employeeallowances set amount=(select ea.amount*10/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='169' and employeeid in (select employeeid from employee_personal_information where grade<=16 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //adhoc 2019 (169) grade> 16 5% $qry = "update employeeallowances set amount=(select ea.amount*5/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='169' and employeeid in (select employeeid from employee_personal_information where grade>16 and salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //adhoc 2018 (165) $qry = "update employeeallowances set amount=(select ea.amount*10/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='165' and employeeid in (select employeeid from employee_personal_information where salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); //adhoc 2017 (163) $qry = "update employeeallowances set amount=(select ea.amount*10/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.=" where a_head='163' and employeeid in (select employeeid from employee_personal_information where salary='yes' and job_status<>'FIXED')"; odbc_exec($conn,$qry); */ // Deputation Allowance (159) 20% of Basic Pay $qry = "update employeeallowances set amount=(select ea.amount*20/100 from employeeallowances ea where ea.a_head='001' and employeeallowances.employeeid=ea.employeeid )"; $qry.= " where a_head='159' and employeeid in (select employeeid from employee_personal_information where salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); $headID="360"; //Income Tax odbc_exec($conn, "delete from employeedeductions where d_head='360'");//Incoem Tax $qry="select EMPLOYEEID,job_description from EMPLOYEE_PERSONAL_INFORMATION where salary='yes' order by employeeid"; $cur= odbc_exec( $conn, $qry); while( odbc_fetch_row( $cur ) ) { $empID= odbc_result( $cur, 'employeeid' ); $tax=round(calculateTax($conn,$empID)/12); if($tax>0){ $qry="insert into employeedeductions(employeeid,d_head,ddescription,damount) values ('$empID','$headID','Income Tax','$tax')"; odbc_exec( $conn, $qry); } } return 0; } function calculateTax($conn,$empID){ //in 2019 $tax=0; //$amt=getName($conn,"select sum(amount) from employeeAllowances where employeeid='$empID' and (adescription not like'%Adj.%') and (adescription not like'%subsidy%') "); //$amt=getName($conn,"select sum(amount) from employeeAllowances where employeeid='$empID' and (adescription not like'%Adj.%') "); $amt=getName($conn,"select sum(amount) from employeeAllowances where employeeid='$empID' and (adescription not like'%Adj.%') and (adescription not like'Others') and (adescription not like'Eidi Allowance') and (adescription not like'%Weather%') "); //Others Eid Allowance=171 //2024 if($amt!=""){ $amt= $amt*12; if ($amt <= 600000) $tax = 0; elseIf($amt <= 1200000) $tax = ($amt-600000) * 5 / 100; elseIf($amt <= 2200000) $tax = 30000+($amt - 1200000) * 15 / 100; elseIf($amt <= 3200000) $tax = 180000 + ($amt - 2200000) * 25 / 100; elseIf($amt <= 4100000) $tax = 430000 + ($amt - 3200000) * 30 / 100; else //$tax = 700000 + ($amt - 6000000) * 35 / 100; $tax = 700000 + ($amt - 4100000) * 35 / 100; } //echo "
$empID=$amt Tax=".round($tax)." monthly=".round($tax/12) ; return $tax; /* //2023 if($amt!=""){ //echo "
$empID=$amt"; $amt= $amt*12; if ($amt <= 600000) //2023 Slab $tax = 0; elseIf($amt <= 1200000) $tax = ($amt-600000) * 2.5 / 100; elseIf($amt <= 2400000) $tax = 15000+($amt - 1200000) * 12.5 / 100; elseIf($amt <= 3600000) $tax = 165000 + ($amt - 2400000) * 22.5 / 100; elseIf($amt <= 6000000) $tax = 435000 + ($amt - 3600000) * 27.5 / 100; elseIf($amt <= 12000000) $tax = 1095000 + ($amt - 6000000) * 35 / 100; } return $tax; /* 2022 if ($amt <= 600000) //2022 Slab $tax = 0; elseIf($amt <= 1200000) $tax = ($amt-600000) * 2.5 / 100; elseIf($amt <= 2400000) $tax = 15000+($amt - 1200000) * 12.5 / 100; elseIf($amt <= 3600000) $tax = 165000 + ($amt - 2400000) * 20 / 100; elseIf($amt <= 6000000) $tax = 405000 + ($amt - 3600000) * 25 / 100; elseIf($amt <= 12000000) $tax = 1005000 + ($amt - 6000000) * 32.5 / 100; else $tax = 2995000 + ($amt - 12000000) * 35 / 100; */ /* 2017 if ($amt <= 600000) $tax = 0; elseIf($amt <= 1200000) $tax = ($amt-600000) * 5 / 100; elseIf($amt <= 1800000) $tax = 30000+($amt - 1200000) * 10 / 100; //$tax = 15000+($amt - 1200000) * 12.5 / 100; elseIf($amt <= 2500000) $tax = 90000 + ($amt - 1800000) * 15 / 100; elseIf($amt <= 3500000) $tax = 195000 + ($amt - 2500000) * 17.5 / 100; elseIf($amt <= 5000000) $tax = 370000 + ($amt - 3500000) * 20 / 100; elseIf($amt <= 8000000) $tax = 670000 + ($amt - 5000000) * 22.5 / 100; else $tax='out'; */ } function calculateTradeTax($conn,$empID){ $tax=0; $amt=getName($conn,"select sum(amount) from employeeAllowances where employeeid='$empID' and (adescription not like'%Adj.%') and (adescription not like'%Weather%') "); // slab Feb-2024 attached to software coments If($empID=="666-66-000006" Or $empID == "000-050140256") // 'Dr. Shehnaz/Dr. Zubina $tax = 30000; elseIf($amt<=20000) $tax = 0; elseIf ($amt <= 30000) $tax = 1000; elseIf ($amt <= 50000) $tax = 1200; elseIf ($amt <= 100000) $tax = 1500; elseIf ($amt <= 200000) $tax = 2000; elseIf ($amt <= 500000) $tax = 3000; else $tax = 5000; return $tax; /* $grade=getName($conn,"select grade from employee_personal_information where employeeid='$empID' "); If($empID=="666-66-000006" Or $empID == "000-050140256") // 'Dr. Shehnaz/Dr. Zubina $tax = 30000; elseIf ($grade <= 6) $tax = 0; elseIf ($grade <= 12) $tax = 1000; elseIf ($grade <= 16) $tax = 1200; elseIf ($grade == 17) $tax = 1500; elseIf ($grade == 18) $tax = 1800; elseIf ($grade == 19) $tax = 2000; else $tax = 3000; */ } echo "
"; echo ""; echo "
For the Month:"; echo ""; echo ""; //echo ""; echo ""; echo ""; echo ""; //echo ""; echo " "; echo " "; //Dated: 13.02.24 echo " "; //Dated: 13.02.24 echo " "; //Dated: 13.02.24 //echo ""; echo ""; echo ""; echo ""; // for Regular Staff Only echo ""; echo ""; echo "
"; echo " "; echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; // Coments/Changes made in this month $query= "select * from commentsTable where month(date_)='".date("m", strtotime($monthYear))."' and year(date_)='".date("Y", strtotime($monthYear))."' order by date_ desc,autoID"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
"; $date2= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $employeename=getName($conn,"select employeename from employee_personal_information where employeeid='".odbc_result( $cur, 'empID' )."'"); $remarks= odbc_result( $cur, 'remarks' ); $autoID= odbc_result( $cur,'autoID'); echo "
Coments/Changes
#DateNameremarksEdit
$cnt$date2$employeename$remarksEdit" ; echo "".odbc_result( $cur, 'image1' ).""; $cnt+=1; } echo "
"; //Check Advance payments , 331:Overpayment, 368: GP-1, 370: GP2 ,301:house Advance, 303:car advance $query= "select * from employeedeductions where d_head in('331','368','301','303','370') order by d_head,employeeid "; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Advances/Overpayment
SerialEmp IDNameDescriptionInstallmentBalanceSalary"; $employeename=getName($conn,"select employeename from employee_personal_information where employeeid='".odbc_result($cur,"employeeid")."'"); $allowanceID=odbc_result( $cur, 'd_head' ); $employeeid=odbc_result( $cur, 'employeeid' ); $subTotal=getName($conn,"select isnull(sum(openingbalance),0) from advanceDetails where LDID='$allowanceID' and employeeid='$employeeid' "); $subTotal=$subTotal-getName($conn,"select sum(damount) from monthlyemployeedeductions where d_head='$allowanceID' and employeeid='$employeeid' and date2<='$date_'"); if($subTotal". $cnt++ . "".odbc_result($cur,"employeeid")."$employeename".odbc_result($cur,"ddescription")."".odbc_result($cur,"damount")."" ; echo "$subTotal"; }else{ echo "
". $cnt++ . "".odbc_result($cur,"employeeid")."$employeename".odbc_result($cur,"ddescription")."".odbc_result($cur,"damount")."" ; echo "$subTotal"; } echo "Salary"; //echo "del"; } echo "
"; //$cur= odbc_exec( $conn,"delete from employeeAllowances where adescription like 'Adj.%'"); //Adjustment allownces $query = "select e.employeeid as ID,e.employeename as Name,a.a_head as Head,a.adescription as Allowance,a.amount As Amount from employeeallowances a,employee_personal_information e where e.employeeid=a.employeeid and a.adescription like 'Adj%' order by e.employeename,a.a_head"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Allowances Adjustment
SerialEmp IDNameCodeDescriptionAmountDelete"; echo "
". $cnt++ . "".odbc_result($cur,"ID")."".odbc_result($cur,"Name")."".odbc_result($cur,"Head")."".odbc_result($cur,"Allowance")."".odbc_result($cur,"Amount")."" ; echo "del"; } echo "
"; //Adjustment Deductions $query= "select * from employeedeductions where ddescription like 'Adj%' order by employeeid "; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Deductions Adjustment
SerialEmp IDNameDescriptionAmountDelete"; $employeename=getName($conn,"select employeename from employee_personal_information where employeeid='".odbc_result($cur,"employeeid")."'"); echo "
". $cnt++ . "".odbc_result($cur,"employeeid")."$employeename".odbc_result($cur,"ddescription")."".odbc_result($cur,"damount")."" ; echo "del"; } echo "
"; //Adjustment Deductions $query= "select * from employee_personal_information where salary='yes' and increment='NO' and job_status<>'FIXED' order by employeeid "; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
No Increement for
SerialEmp IDNameDescriptionAmountDelete"; echo "
". $cnt++ . "".odbc_result($cur,"employeeid")."".odbc_result($cur,"employeename"); //echo "del"; } echo "
"; echo "
Fixed"; $query="select * from employee_personal_information where salary='YES' and job_status='FIXED' order by grade desc,employeename"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialEmp IDNameFather NameDesignationBPSAllowancesDeductionsNet SalrySalarySlipSlipsTax"; $employeeid= odbc_result( $cur, "employeeid" ); $employeename= odbc_result( $cur,'employeename' ); $Basic= getName($conn,"select sum(Amount) from monthlyemployeeallowances where date2='$date_' and employeeid='$employeeid'"); $Deductions= getName($conn,"select sum(dAmount) from monthlyemployeedeductions where date2='$date_' and employeeid='$employeeid'"); $employeefathername= odbc_result( $cur, 'employeefathername' ); $Absentee= odbc_result( $cur, 7 ); $Others= odbc_result( $cur, 8 ); $Net= $Basic-$Deductions; $Allowance= odbc_result( $cur, 10 ); echo "
"; echo "
". $cnt++ . "$employeeid$employeename$employeefathername"; echo "".odbc_result($cur,"job_description"); echo "".odbc_result($cur,'grade')."$Basic$Deductions$NetSalary"; echo "SlipSlips" ; echo "Tax" ; echo ""; //echo ""; echo ""; //http://localhost:81/payroll/fpdf/incomeTaxStatment?from=2018-08-01&to=2019-08-01&d_head=360&empID=777-77-000199 } echo "
"; $query="select * from employee_personal_information where salary='YES' and job_status<>'FIXED' order by employeename"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialEmp IDNameFather NameBPSAllowancesDeductionsNet SalrySalarySlipSlipsTax"; $employeeid= odbc_result( $cur, "employeeid" ); //$date_= date('d-m-Y', strtotime(odbc_result( $cur, 2 ))); $employeename= odbc_result( $cur,'employeename' ); //$monthYear= date('M-Y', strtotime(odbc_result( $cur, 6 ))); $Basic= getName($conn,"select sum(Amount) from monthlyemployeeallowances where date2='$date_' and employeeid='$employeeid'"); $Deductions= getName($conn,"select sum(dAmount) from monthlyemployeedeductions where date2='$date_' and employeeid='$employeeid'"); $employeefathername= odbc_result( $cur, 'employeefathername' ); //$Deductions= odbc_result( $cur, 6 ); $Absentee= odbc_result( $cur, 7 ); $Others= odbc_result( $cur, 8 ); $Net= $Basic-$Deductions; $Allowance= odbc_result( $cur, 10 ); echo "
"; echo "
". $cnt++ . "$employeeid$employeename$employeefathername"; echo "".odbc_result($cur,'grade')."$Basic$Deductions$NetSalary"; echo "Slip"; echo "Slips" ; echo "Tax" ; echo "BroadSheet" ; echo ""; //echo ""; echo ""; //http://localhost:81/payroll/fpdf/incomeTaxStatment?from=2018-08-01&to=2019-08-01&d_head=360&empID=777-77-000199 } echo "
"; //addNewAllowance('165',''Adhoc Relief (2018)','10') function addNewAllowance($conn,$a_head,$description,$percent){ if($percent>0){ odbc_exec( $conn, "delete from employeeAllowances where a_head='$a_head' "); $qry = "insert into employeeallowances(employeeid,a_head,adescription,amount) "; $qry.= " select employeeid,'$a_head','$description',amount*$percent/100 from employeeallowances "; $qry.= " where a_head='001' and employeeid in (select employeeid from employee_personal_information where salary='yes' and job_status<>'FIXED')"; odbc_exec( $conn, $qry); } odbc_exec( $conn, "delete from Allowances where a_head='$a_head' "); $qry = "insert into Allowances(a_head,Description,type) values('$a_head','$description','R') "; odbc_exec( $conn, $qry); $a_head=$a_head+100; //Adj. $description="Adj. $description"; odbc_exec( $conn, "delete from Allowances where a_head='$a_head' "); $qry = "insert into Allowances(a_head,Description,type) values('$a_head','$description','R') "; odbc_exec( $conn, $qry); odbc_exec( $conn, "delete from deductions where d_head='$a_head' "); $qry = "insert into deductions(d_head,Description,type) values('$a_head','$description','R') "; odbc_exec( $conn, $qry); return 0; } odbc_close($conn); function deductionDays($conn,$empID,$days){ $days=explode("/",$days); $gross=getName($conn,"select sum(amount) from employeeAllowances where employeeid='$empID' and adescription not like 'Adj%' "); if($gross>0){ //echo $days[0]."*".$gross."/".$days[1]; $amount=$days[0]*($gross/$days[1]); odbc_exec($conn,"delete from employeedeductions where employeeid='$empID' and d_head='201' "); $qry = "insert into employeedeductions(employeeid,d_head,ddescription,damount) "; $qry.= " select '$empID',d_head,Description,$amount from deductions where d_head='201' "; //echo "
".$qry; odbc_exec( $conn, $qry); } return 0; } function addDRA($conn){ //Disparity Reduction Allowance from March-2022 $headID="177"; $cur=addNewAllowance($conn,$headID,'Disparity Reduction Allowance',0); odbc_exec($conn,"delete from employeeallowances where a_head='$headID'"); odbc_exec($conn,"delete from employeeallowances where a_head='277'"); //return 0; //exit(); //$qry="select employeeid from employeeAllowances where a_head in()"; $query="select employeeid,grade,employeename from employee_personal_information where salary='yes' and job_status<>'FIXED' order by employeeid "; $cur= odbc_exec( $conn, $query ); while(odbc_fetch_row($cur)) { $amount=getName($conn,"select min_ from BasicPayChart where year_=2017 and grade='".odbc_result($cur,"grade")."' "); //echo "
select amount from employeeAllowances where a_head<>'001' and amount>=$amount and employeeid='".odbc_result($cur,"employeeid")."' "; $isGreaterAll=getName($conn,"select amount from employeeAllowances where a_head<>'001' and amount>=$amount and employeeid='".odbc_result($cur,"employeeid")."' "); if($isGreaterAll==""){ //$amount=getName($conn,"select amount from employeeAllowances where a_head='001' and employeeid='".odbc_result($cur,"employeeid")."' "); //$amount=round($amount*15/100); //@15% $amount=getName($conn,"select amount from monthlyemployeeallowances where a_head='$headID' and employeeid='".odbc_result($cur,"employeeid")."' "); $qry = "insert into employeeallowances(employeeid,a_head,adescription,amount,updat) "; $qry.=" values('".odbc_result($cur,"employeeid")."','$headID','Disparity Reduction Allowance','$amount','NO' ) "; $cur2= odbc_exec($conn, $qry); //echo "
".$qry; $amount=2*$amount; //@15% 2 months Mar & Apr & may //for March & April Arrears $qry = "insert into employeeallowances(employeeid,a_head,adescription,amount,updat) "; $qry.=" values('".odbc_result($cur,"employeeid")."','277','Adj. Disparity Reduction Allowance','$amount','NO' ) "; $cur2= odbc_exec($conn, $qry); }else{ echo "
".odbc_result($cur,"employeename"); } } return 0; } ?>