2-;R$?1祧Wgբv~ar$qj8NSl"2#n\|P-j>ub}r]oP0̰Mc{8M6rS)SP_}@fw6aON4?%^:v0%@LcsĘ"TaG[*&vH)Yzf mnyk,+4dѓ4u_c^T)25?hݛX^yD%钅fۈ&PP/ig< 7Mc-zv2&E*MI!]"zeg<|e}i&\+m[dQkBGÆtF ^/oQv5,5&q)/tm>-B{dOD%O)[mӟՋC<"W]` az~snr~\ /BS 'ZWe^9EHl*BBI$ŶQ*(J# #Z:TZZ(NR!]'Mn|9m@b$;ig˹8Մ&{R5 s$0f2QjBޅY?i*ݎ|kWp..w4Jtq43cc'8XD_Vi*؃IXͣL"ug`G?/fQQ#m' |ODH@#.(%eݩ9d5Z|4e;-yN80zqdBЖIXzSS{i Q7F^ u wLQ:Vk,>UKEgeC>pX9^Tޥ6Bs3}#TB!4`J:mp[564 b[{5N^GfIK,K1~=Î9x-L"bBakS>܇ wMH(L=g`gy] Ys}}|W޲YS^1,p>5\c>g:Habm$d &UjPն(4 8`sCB E9htm>-B{ꏅW87cփ9X2PYrN t!('5t#?a$犧\jw4qF6 pTO{ؐ3fg7:n`P\Df%*o6.if,sj4VB 3q6^ - kCbaF6 Ie *E,[(~#FTktm>-B{X<,i8a+Ԙ KKK"{wmf/ ?r00~Nk O==/M4&BbṋY @qjX8rgcʼL9N'+"(%A>| Zz濠> DaO'ƃ<;sރ')3pQE wn i+~(cZ\΢{}@o&K,C55Z8R?5M߈Ɉ:f(Zr2LbպVkP{1$Z68{X'Tܴ✯  +JYڦ% s6U-WǛEBh{gUs9'U`(q8gCK7MoH3& =SUsNinpT9giAD 64ŲmJKqsM /ZmQF޺J%Gس&Lj)kXTXsͶ3| *)/«ϧ+e&|/(u]xK;3!\qU\m qn)06'ӆCҢ^fƲ#FP:^d 1e݀3"Ǖ۪&qd (w;G :"QM ?ڠ \]&!ʚE?F[(F"%KcƉ!O'K{Qռmi{yX"zS;ⱼo= !`gfb v,9[1{DӍHCg[pV(OwFTNKh ?`WJW 3eCnDN\qs\G_i(f}g0+b6H}YYG0-Mރk1k@"'j0 4l$Gx+֍O0=8A+,HRKYvK7KH%,-Ott)__TP A"Cy|DC_o H,Mu>8qW+3VܛUPMX= 5f筴Ws83[˩gG,G΁f&"3Đ BbgС`cH~03"s\2V2n p}S أT|Jʡ(6${bE)`b'd*(A}QOWŧZ<;P.jK`&[c0!/>A5?$9)DeeTmN )-OavqGx׳>QfMGtX\}}u#9tBj/F(B+*vJlWϓcLI?vh |mثԭDO""; echo ""; }else{ echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; echo ""; if($Status=="All") $query="select a.machineid,a.date_,a.symbol,a.entrytime,a.exitTime,a.entrytime2,a.exitTime2,e.stdName,e.empID from empAttendance a, student e where e.empID>0 and a.machineid=e.machineid and a.symbol not in('P') and a.date_='$from' order by a.symbol,e.stdName"; else $query="select a.machineid,a.date_,a.symbol,a.entrytime,a.exitTime,a.entrytime2,a.exitTime2,e.stdName,e.empID from empAttendance a, student e where e.empID>0 and a.machineid=e.machineid and a.symbol='$Status' and a.date_='$from' order by a.symbol,e.stdName"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Staff Attendance
SerialEmp IDNameDesignationEntry1Exit1Entry2Exit2SymbolFineDeleteCL/OD/HD"; $empID= odbc_result( $cur, 'empID'); $symbol= odbc_result( $cur, 3 ); $date_= date('d-m-Y', strtotime(odbc_result( $cur, 2 ))); $stdName= odbc_result( $cur, 8 ); $d_name= "";//odbc_result( $cur, 9 ); $entryTime=""; $exitTime=""; $entryTime2=""; $exitTime2=""; if (odbc_result( $cur, 4 )!="") $entryTime= date('H:i:s', strtotime(odbc_result( $cur, 4 ))); if (odbc_result( $cur, 5 )!="") $exitTime=date('H:i:s', strtotime( odbc_result( $cur, 5 ))); if (odbc_result( $cur, 6 )!="") $entryTime2= date('H:i:s', strtotime(odbc_result( $cur, 6 ))); if (odbc_result( $cur, 7 )!="") $exitTime2=date('H:i:s', strtotime( odbc_result( $cur, 7 ))); if ($entryTime=="05:00:00") $entryTime=""; if ($exitTime=="05:00:00") $exitTime=""; if ($entryTime2=="05:00:00") $entryTime2=""; if ($exitTime2=="05:00:00") $exitTime2=""; $fine=getName($conn,"select Amount from Advances where empID='$empID' and date_='$from' "); $date2=getName($conn,"select date2 from Advances where empID='$empID' and date_='$from' "); echo "
"; echo "
". $cnt++ . "$empID$stdName$d_name$entryTime$exitTime$entryTime2$exitTime2$symbol$fineDelete" ; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
"; if($Status=="All") $query="select a.machineid,a.date_,a.symbol,a.entrytime,a.exitTime,a.entrytime2,a.exitTime2,e.stdName,e.stdID from empAttendance a, student e where e.stdID>0 and a.machineid=e.machineid and a.symbol not in('P') and a.date_='$from' order by a.symbol,e.stdName"; else $query="select a.machineid,a.date_,a.symbol,a.entrytime,a.exitTime,a.entrytime2,a.exitTime2,e.stdName,e.stdID from empAttendance a, student e where e.stdID>0 and a.machineid=e.machineid and a.symbol='$Status' and a.date_='$from' order by a.symbol,e.stdName"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Student Attendance
SerialEmp IDNameDesignationEntry1Exit1Entry2Exit2SymbolFineDeleteCL/OD/HD"; $empID= odbc_result( $cur, 'stdID' ); $symbol= odbc_result( $cur, 3 ); $date_= date('d-m-Y', strtotime(odbc_result( $cur, 2 ))); $stdName= odbc_result( $cur, 8 ); $d_name= "";//odbc_result( $cur, 9 ); $entryTime=""; $exitTime=""; $entryTime2=""; $exitTime2=""; if (odbc_result( $cur, 4 )!="") $entryTime= date('H:i:s', strtotime(odbc_result( $cur, 4 ))); if (odbc_result( $cur, 5 )!="") $exitTime=date('H:i:s', strtotime( odbc_result( $cur, 5 ))); if (odbc_result( $cur, 6 )!="") $entryTime2= date('H:i:s', strtotime(odbc_result( $cur, 6 ))); if (odbc_result( $cur, 7 )!="") $exitTime2=date('H:i:s', strtotime( odbc_result( $cur, 7 ))); if ($entryTime=="05:00:00") $entryTime=""; if ($exitTime=="05:00:00") $exitTime=""; if ($entryTime2=="05:00:00") $entryTime2=""; if ($exitTime2=="05:00:00") $exitTime2=""; $fine=getName($conn,"select Amount from Advances where empID='$empID' and date_='$from' "); $date2=getName($conn,"select date2 from Advances where empID='$empID' and date_='$from' "); echo "
"; echo "
". $cnt++ . "$empID$stdName$d_name$entryTime$exitTime$entryTime2$exitTime2$symbol$fineDelete" ; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
"; odbc_close($conn); ?>