2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZho9_IჄK:z 4`8iU5;ݰ8Kc]wZ}{w?l 9눏(Ӈρ9)dd;؛ȢFa$#zyNP,f=`dF^`qFSҎgOe\? Tg>{QoAtHl $rx]߬ rz5!8vmP9^YV9Xom;tJ{d!64&9.xDVV}CbGgp3Lcf[$2S'a`zd#U?6ap`Ǐ8)2nǂM`y%ƊQtg6CQ>;z޾6aaof:A{Is qyaW]U{[+EErUߞJa9a GV3iڭ ^ d%uI G;lP+O*.A.X(^.CApZ!ДNDa iL(4 2-o tp^Mn @027e:d)TM .$4[!j6V5Zʔi_",塠C7Ma&YO*GDbV.2F?T-γrcj߸r;L6mWk="آWYw='БS4< أky*"7Tg|g7I{3o=W .8X-iuaϺ*EP& yCVNlWz|$E$q$"wxh!a?2J/~`eX D`m=muskd c'UGW|_ʼsÄG K4_kDP&@Ur=u06H8)/דC% 2M#yPs̲QgO/{fu4gR#4/M4&Bb5aE-Zx^Bx˩h<Gl:$ೈ@?c{w&@59\pb=:eS> ktJC챬}Ӷa2E{chl8˘O5O. }`IJ|D4ϲE׆Oò8F1Qwe* ܼ[YInkd c'UGW| l~ic9._ڇK`oElY%脳QDpsmEӢ{qBXZ˧,GĸQS }]2OdK=1 0QOԬ1>3zk1]"`TVug }?.f(?XjyShD4lPݥso[xouP,n$|u4@f{٧ j.M^Xkdp X>Î9x-xbSkH8񵤋>dhДSS֤^YwOkw;kL0V*EAo1RȊzˉ>AYfJx40w8م5K+iα`ٕ9:90b`Ǐ8)2|D;MQ.RwS}cƔd ovuf\=f<ЧBL#gO`#wv+$;+'b{uju8(ɊSUVCQXکg}bTAGn-JjA4QAVbE|"Ba^>mr{]wNCpAsF4I?CqX>Î9x-xbSkH8!1nVB(,r')^3|F~U8#-08JwV,ZHZ>?VV}CbGg9)iR 5Ư4tjla&me Z{XMkA HcW``v%li4ltq!wfIRiiQ<53q@Ĵ\Q57oz5!8vmP9R=+`A5Ư4tjla&me Z{Xșm%ks:Cxxu# ?E}-zΨϋzYd *߲64o4.J{7KNɋđl?gD|a$BTK}ag9K, _=2ھmMs-N9-}(]bܴZ'[ zk.ۼf@<*4,B"-ux/ᚢ=a@öjrz"ie@*( Aô;Z] U\6FqiG|IL5DJ$vshŶ=}QY~ S4eQ}|, ]_SvЕ!nz!r,HXS8(tU*f]؊W-BOFLTZ_Gj-]kfjr-"wKQpաÇC<\O|F!_bApsjTܯj!vٳ)uVSqB>P4A/}SE s1(a_0ezEp+!![,c5lQ.*>eĔy*d쒺ڒf吏 ޜɖ: de=='All') $query="select a_head,description from allowances where description like'%$anyvalue%' or a_head like'%$anyvalue%' order by a_head,description"; else $query="select d_head,description from deductions where description like'%$anyvalue%' or d_head like'%$anyvalue%' order by d_head,description"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
"; $a_head= odbc_result( $cur, 1 ); $description= odbc_result( $cur,'description'); if($type=='All'){ $Amount=getName($conn,"select amount from employeeallowances where a_head='$a_head' and employeeid='$employeeid' "); $remarksDate=getName($conn,"select remarks from employeeallowances where a_head='$a_head' and employeeid='$employeeid' "); }else{ $Amount=getName($conn,"select damount from employeedeductions where d_head='$a_head' and employeeid='$employeeid' "); $openingBalance=getName($conn,"select openingBalance from employeedeductions where d_head='$a_head' and employeeid='$employeeid' "); $remarksDate=getName($conn,"select remarks from employeedeductions where d_head='$a_head' and employeeid='$employeeid' "); } echo ""; echo "
". $cnt++ . "$a_head" ; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; if($type=='All'){ echo ""; }else{ if("1"==getName($conn,"select 1 from advanceDetails where employeeid='$employeeid' and LDID='".odbc_result( $cur,'d_head')."'")){ echo ""; $cur1= odbc_exec($conn,"select openingBalancedate,openingBalance from advanceDetails where employeeid='$employeeid' and LDID='".odbc_result( $cur,'d_head')."' order by date_ desc "); $cnt2=0; while( odbc_fetch_row( $cur1 ) ) { if ($cnt2++==0) echo "
DateAmount" ; //if ($cnt2++==0) echo "" ; echo "
".odbc_result($cur1,'openingBalanceDate')."".odbc_result($cur1,'openingBalance'); } if($cnt2>0) echo "
"; }else{ echo "		"; echo ""; } } echo ""; } echo "

"; } $empName=getName($conn,"select employeename from employee_personal_information where employeeid='$employeeid' "); echo "
"; $total=0; $query="select * from employeeallowances where employeeid='$employeeid' order by a_head"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialTypeAllowanceAmountEDITDelete"; $Allowance= odbc_result( $cur, 'adescription' ); $a_head= odbc_result( $cur, 'a_head' ); //$headType= odbc_result( $cur, 'headType' ); $Amount= odbc_result( $cur, "Amount" ); //$passingYear= odbc_result( $cur, 4 ); //$percentage=odbc_result( $cur, 5 ); //$a_head= odbc_result( $cur, 6 ); echo "
". $cnt++ . "$a_head$Allowance$AmountEditDelete" ; $total+=odbc_result( $cur, "Amount" ); } if($cnt>1) echo "
Total$total"; echo "
"; echo "		"; $total=0; $query="select * from employeedeductions where employeeid='$employeeid' order by d_head"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialTypeDeductionsAmountOpeningEDITDelete"; $Allowance= odbc_result( $cur, 'ddescription' ); $a_head= odbc_result( $cur, 'd_head' ); //$headType= odbc_result( $cur, 'headType' ); $Amount= odbc_result( $cur, "dAmount" ); //$passingYear= odbc_result( $cur, 4 ); //$percentage=odbc_result( $cur, 5 ); //$a_head= odbc_result( $cur, 6 ); echo "
". $cnt++ . "$a_head$Allowance$Amount".odbc_result($cur,"openingBalance")."Edit"; echo "Delete" ; $total+=odbc_result( $cur, "dAmount" ); } if($cnt>1) echo "
Total$total"; echo "
"; echo "
"; odbc_close($conn); ?>