2-;R$?1祧Wgբv~ar$qj8NSl"2#n\|P-j>ub}r]oP0̰Mc{8M6rS)SP_}@fw6aON4?%^:v0%@LcsĘ"TaG[*&vH)Yzf mnyk,+ƺDW6t q$^S6] '#7h2 a%R,JY@tʜ{C?VШSӣA'c nY&fdRfKitHh3.ǭ6uwOq!|uq=3A6|3vRZ<:52Si /!J;MSƙ!m0dxqr S2_L}{]΁Kƣiu { O¦ӆKƣiu 4I?}I"5m``o<8 \ _Ѭ0t[ S j0%mTڗ}'|ߥ͂ ?*aK㔭U3".w/y|:AL~)=YOeo|$w|NPXvt`uu׀p3D}|Te&vG\g5oBE38G~<xg=0B*%/`T5wBz8ɤ,Z .ڍ#{Mzİa높k-A8R=SnT@6_)EҞX;·jƾ5*б7*~_"pq{(C;xЩhת7v>_4.~lT윓?lvq/l 7Mc-zv2&,J:@qK$6 qQ*L2HM|^ 5'愯jcLdp:%~,/>L, >:v4;b3EAq؉ U^IQD0)[AD '?|ؘSSA33,Yy&\+~p9md1>"p6ǯ?`PcTB.(uC"BKg*zVLd@|׶g'|ߥlPͽi9et2ewx?; R3R@.IMx?te'6C=i0 gm./@xlCOifՎQR \KKćQ3sY|ˁmwr4mt͠h d<&2+9'Ec ֔*0SasY=NV)3\9 ^]3ADk8rb!Xw j&M?pqC‰h.1j󞴣> xjq0ih^O;[)(*Qu_6TЙ`]B0!5]Aw.ր8݁+zJ8*4=fF1s&]ؙ]Ҥb0VmRfYDZAQtq y?DT]|*334~'(WeĔy*˴ͥA54p"+CY?̃*lP †Kr}9Q{oE/ֶ cX[+ZW2اv[oȳQ )m񣛿-GrCL"vKq@Ʊrck,,v/av? ?~@1-}0j[0I bbjATKbp0+GbhΧW4+o| tgB=&;s˺sķV΍WR^yR&ḨKx`?۶ɹC56ʖs كGt7dKzT )z-*G?F5PN.5Na a43lX,:%F.Wfl$_-AFƓ+b?Ajɮnn!m:q$_ z*1!NsE?%rC nɵjKaŁv`?֙Uǒ1`rO L„QU=*'#*鐹!smP#V,e1׵cHLɱ@c ϦKf&=(=QӉSTdr}kd~_*-懿[Jz 6Ll}Q^q9lt*S+?R@˔5">$dخMٵB;ttՆO\bǒY0f QW܇.q0c )GNsxȚ5׳?(ܟs^O XZFY8R߸}nNyɉQ5dy+myP>먪6K3SVo"LW] 9o/U"==B{z+r3+U{x#4:8g7a\zVQ9P@^/oQgqmrpw 5xpa2QU=*'#*r SOh0.OgjJ| e4W/t|ؒ)I/b'ш]5]3xbo-:}d9uj*7 =P߽ ᗶ}SJbQRZpK0`iW~:'>y2IVǪ[(M8c}p AlqP3K>X,:%F.Wfp$i,FNQT>+XWi{LrC-EkK>X,:%F.WfU lm+anxn (&ͮ' Qd,b[n#se9>fp|5y8Uͮ' Qd,b[p65GY J-anxn (&}0e & :۳R9'$_rv3~b]c8-D-CC0#U-0}ͩj Abc*JFًY-/`֐ z*1!NsE" 5Up}!1@KV1. =5 iFޏ[ Q4MBz1K·jƾ5*б7˱#{XΫ\]u@\G꽵?#3Adgt9lqSqTx>%,CA^Eu'Pyא"qܠ0Ӯ/4%X8S7mͭ 3 F.`>Վe霆oK<f%aR4Jwgb{`4 {xgy=0~ jL:;N$cAz^Ev(sDDs&vHjp+ҹ!}ؙynbmOl P$Ґ'imI;VlWlYCAX=L?0*dp0\,Q*w.R%̙*K4@' *K+?; ڋӼI+ǁinAިҤ\ vGko2#L]%r[Q 4Z&>F%rqI5Lx:YݭYeɘrf> ]v{f7jployeeid from empAttendance a, employee_personal_information s, LeaveType lt where a.symbol2=lt.id and a.machineid=s.machineid and s. day(a.date_)='$day_' and month(a.date_)='$month_' and year(a.date_)='$year_' order by a.entryTime,s.employeename"; $query="select * from empAttendanceView where date_='$from' order by symbol desc,entryTime,employeename"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Staff Attendance
SerialBiometricNameDateTimingEntryExitSymbolLeave/HD"; $employeeid= odbc_result( $cur, 'employeeid' ); $machineid= odbc_result( $cur, 'machineid' ); $symbol= odbc_result( $cur, 'symbol' ); $date_= date('d-m-Y', strtotime(odbc_result( $cur, 'date_' ))); $employeename= odbc_result( $cur, 'employeename' ); //$d_name= odbc_result( $cur, 9 ); $timing= date('h:i A', strtotime(odbc_result( $cur, 'ent1' ))); $color= odbc_result( $cur, 10 ); $lateMints= odbc_result( $cur, 11 ); if ($lateMints<=10) $lateMints=""; else $lateMints=" ($lateMints)"; $entryTime=""; $exitTime=""; $entryTime2=""; $exitTime2=""; if (odbc_result( $cur, 'entryTime' )!="") $entryTime= date('h:i A', strtotime(odbc_result( $cur, 'entryTime' ))); if (odbc_result( $cur, 'exitTime' )!="") $exitTime=date('h:i A', strtotime( odbc_result( $cur, 'exitTime' ))); //if (odbc_result( $cur, 6 )!="") $entryTime2= date('h:i A', strtotime(odbc_result( $cur, 6 ))); //if (odbc_result( $cur, 7 )!="") $exitTime2=date('h:i A', 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=""; echo "
". $cnt++ . "".odbc_result( $cur, 'machineid' )."$employeename$date_$timing$entryTime$exitTime$symbolleave" ; } echo "
"; odbc_close($conn); ?>