2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhobrQȼ nIږ/V?#mcḇ͂7襧*_wr$a*$ZJEdϢ* ^Cbl9)[njT"TaG[*&vH)Yzf mnyk,+ Q-5YnY 57:W$.% ꧺqsyȄr׷~*1FWFE@I&5[HKZ"Ҧ3):5w*ooy#!%Yp@v h%Bx L\[n7pGEBT&2V60nh%tq(}:ǥfCA젏hԫ6), pڔ 0J_EBT&2V6bG넧9)`^ v'#d~b9q#U2ï?{ .V,M&^u\ZUtko0k+f~&7CbI_O_̄X9V_gCaXn^->)I^GI2al8Uaʷvk!~&&bQ C`>&_8t!{6b֩O1.Z_;zC=.1} 5-wϒȐFK2cI4Ckg.<ˍ!ڧ=˯Bbg!Q]&?mdQ{LOSB1+!zkAwt j|dBEu5* s#ZOb;:tr ɻ8\ձ+XHק/zCMW}㴆 Ǧs?єCB V:eL]oO'sХ] ,ؑ&|+0c8&a ưx52,WY&W)3S8;OvasOw7zq1W:١]JfsBd9 i _8t!{6b֩O1.Z_;X&t<'<覹o/TeNFZ׽k-c/Pd 7:˛K8bp0+Gbh"%KcƉ!O'KbMPc ]sV0-boTMr/:zF=(V3NdT$xkJ`G5naGJ--2<25ܙҁW^!kZv`hоK 冺w6DUuaA&"FTO's\-vD\kF3x'qյ Ee߃)}Ihy Uյ<0O;`uyo,UiVYڜ-15#m2J\HR^bP8Þo_XS Zn]U?:ԙ}d$;F_4.~lTOb+)w0-5iο-dw:ԦW_8t!{6b֩}+h/A=ƍu2+:e2ݻXðdK=1 0QOԧ+J-+swxTh:j5ziWX!Jz][r@[]C `ѡY*  GVe3zJ.ӄl{V.x H 0sprʋŠ27q>xڑ)v?遅u:Z-Ȩ߮:HĜ`7[!5|%'oMUZ^FIeaȫ-ĩ,ʶ:؈`0 AEZa /p̈͠hWυ݂N?=ƕgɶz%y!.\*& JJJ^T{WnHؖ*ONVG&?\=`Ng`dcT |GpT9giADzꞍ5ڲUob.*&sNsӅ]>2ҁ(@gtdnF^?!P F'"VpY?rC) )8.CZb}"_I0z;fY׽k-c/Pd 7:˛K8bp0+Gbh"%KcƉ!O'KbMPc ]sV0-boTMr/:zF=(V3NdT$xkJODl)b+UaoB1WM5—Õ0?t UvȁcVw&y, ZtmO\nv/\dFMtʆp+Ua-?BGB̔9摫X>Î9x-A E8/f 'Yy&ՠq\ɿA\h.DnB%Dx" nZOr#X5V($2T_hcaj:X'f5,o%D+ְ)xW9Jh(rӲ hYz:Ywte|# P}aWJ޻59sicc?D[7Eێԥ0^S5ǬӤO#{HZki;n靻?~J[+GQӰ+I64b:׾Wz74?#B\㻾U/sM4 Pß&R9]׸13aW#N҇m^ sU*Ǚꔮ8eY ߬M!v cB[#ZY) X3)N6= kn ^\Ie9*a,> }׻3UϙqclR.fc EE6y?X:8" ī?p© 9mG<L";NV f /1l2i+vj=RCNApwOLE^ 66@49D^)zzݹ_%ٮEQjFUFpY#S浞ȓn-|pU3uGͮu9˾ 6\ EGz.O$?xljSJ1r:q9=[EUobD^z8PEN؏.xO0 6浃sB ?(u9M[בo"1>&t6y8<i'S/d7=1aka^֤cAajG溛VvCNyò$ttx%>RuG=40o 6ӆ 81 j7.P4JrYXOqSns[լ*bA8CYSì'hyHfi a{AH. ;9x%Akm5*g+O|!u?<Tv!7Z8_7 7ۺX0@nSܷR*Қ/GOr wޣ=G!kj'i$D.CBS/etiG䤅W?^\yՉE>0Fq0Rv渺Sc Xw?'|'׃sY=NV)3\9 J?(|f S4eQ}|fP+/DV:$\>!z*:BrI= F3!AhnTo'f~}l]h%zOԤVoЋ<mǴg) [Ii%n:۝gk`TIdgI ='text' value='$empName' name='empName'>"; echo "Deductions +"; //echo "Obtained Marks"; echo "Amount"; //echo "passingYear"; echo ""; echo ""; echo ""; $query="select * from AllowancesView where headType='Allowances' and empID='$autoID' order by order_ asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialCodeAllowanceAmountDelete"; $Allowance= odbc_result( $cur, 'Description' ); $AllowanceID= odbc_result( $cur, 'AllowanceID' ); $headType= odbc_result( $cur, 'Description' ); $Amount= odbc_result( $cur, "Amount" ); //$passingYear= odbc_result( $cur, 4 ); //$percentage=odbc_result( $cur, 5 ); //$AllowanceID= odbc_result( $cur, 6 ); echo "
". $cnt++ . "$Allowance$AmountDelete" ; } echo "
"; echo ""; $query="select * from AllowancesView where headType='Deductions' and empID='$autoID' order by order_ asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialCodeDeductionAmountDelete"; $Allowance= odbc_result( $cur, 'Description' ); $AllowanceID= odbc_result( $cur, 'AllowanceID' ); $headType= odbc_result( $cur, 'Description' ); $Amount= odbc_result( $cur, "Amount" ); //$passingYear= odbc_result( $cur, 4 ); //$percentage=odbc_result( $cur, 5 ); //$AllowanceID= odbc_result( $cur, 6 ); echo "
". $cnt++ . "$Allowance$AmountDelete" ; } echo "
"; echo ""; odbc_close($conn); /* drop VIEW dbo.allowancesView CREATE VIEW dbo.allowancesView AS SELECT dbo.Emp_Allowances.AllowanceID, dbo.Emp_Allowances.amount, dbo.Emp_Allowances.Formula, dbo.Emp_Allowances.Type, dbo.Employee.EmpName, dbo.Employee.FName, dbo.FeeHeads.order_, dbo.FeeHeads.headType, dbo.FeeHeads.Description, dbo.Emp_Allowances.EmpID FROM dbo.Emp_Allowances INNER JOIN dbo.FeeHeads ON dbo.Emp_Allowances.AllowanceID = dbo.FeeHeads.ID INNER JOIN dbo.Employee ON dbo.Emp_Allowances.EmpID = dbo.Employee.autoID */ ?>