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,JYSe,Hd3鄤";}({Tg軶%B>^~쎌3|X>Î9x-vFnָBnT1y7 gި*D:dZ3U?jgWw3jQ ; ؟hɀڹN.`jKkU*Ss@3j|f cWҰU-1yѻŨO_-Pqw 0Y\q| ֢ڱR܇#i?}da,yD]=SBWV4ڦXU M`6NSL!`Y0r&9M{O@UxEДxT|j]p6<4r_م8:d3bI[PMIvsjgq:qVԐ5>Ceeh=[5!7a5 A&v.׃(t4 SmJ~: QХ*&aawFOtႠ5OmLp>5D9:|rQF0co`?&߿+!!GGB ewsǻ>2?ɇϥJH0vEe'6C=i0 gm./@u 8JϤȼ݂o) xr0<#6ɷp_ըѷ|k\ӹ~ ۂI svN됊Paz-q|rp z,Y]#䷯ES`]i(Ӽ|tAڒu봁r-'&u :I%Xa<4v( ^Ԅd\{$lFBb5L**@qi4{ݞr/dYm{⹻ւln w 47<~1O\5Ȉ uo_9Rd`ݪY4X"Z{Egw%`y|Kt-}+ ĕ]4crJ?H؈N p-kG&k X˼b3ݱIvjcxk[;l:J_Md3F;ܤӆZYtm>-B{NDޕN[>My*}v"w4qF6ilk, 'wTbꀞ;W5urȁטƇ.+ކP82Iz $+wZ/2ƀDsϑGNu$x 2#}O0$Xֵ ;Da높k-A8R=SƼk昔%l}s#&/ Oz*t?ô"~Z*,)f_:di(dU)'EZ[6D 9uliWOzGb٧U-(`vU  k>yQX'Gʻ(~C*j\[#0mҌ1<@|/L!TQ{SP1deyEs 7Mc-zv2&,J:@qK$6\k` ZYݮv4:븕򩹿3shi PL~,vlWaxig|g7I{3hү"#?9I[U3UQ4,:ERHb[ Q 5Nq"nR: dz "+`Aܮ@3; ?hת7v>_4.~lTfGs;P}*<׋NKYxjTOSydMfA5î+CD})ejXڟX‰rVrP6|fr's38G~ 0f]jҮk gNv߂}Qȷk6EȄ+s&ϡ/M4&Bb/a/.fpT{wT`ԯX-uczw2NcԲ*qPR2HG~P^1sR~ G#pm˄\tGS&zn#m0텎݈IsEw`V혍l mk;r n;$D%ZrBLl&%^mq#8t{'ŏd:0N:*w?J-Y @"GTa}{pc~iZ-IyVΞ tEʇSg#֘`%H !r޵Vδe#@H)5Aj)Z-_KNJNHQ8`zrY^5%ќZry `%"7*Y0>LrV;x/%waz #ưHPLӉM:b?y TlO뽔hUL[mȄ l}L o|{,mhY"k9\fqb#v0OrQy,` N-Wg'g25VW!~楴19g\tBrVSR}ڮ1:µDDFy+{ )\\ͩ}*J iWE л13IzkP,.p"GS42~,Xw8ureq-YE6}!Zm|oL{/~D-* n-@#2n=D]\?XXI^c1jՠ(H)30#rx_U{j# s?Z߮V#^61)`b'd*ϟ*k#Bdo&N}9Nd(ݏĆOv mϱ^[ o\y R0tC-z+YYc-ӟ,z_Sڛ:c8K6,qE,7;G!0 md*;F|^Ƿ:@c'YNQ&ZcOujpZ9 UXhºiW@5i?Q{`XC|B*.qO/+Rj < (KI3$g9 Tg0V6yalue='Report'>"; echo ""; echo ""; $qry=""; if($keyword!=""){ $qry= "select ID from studentView where ID>0 and status=0 and (name like'%$keyword%') "; } if($session_!="") { if($qry!="") $qry.=" and (session_='$session_') "; else $qry=" select ID from studentView where ID>0 and status=0 and (session_ ='$session_') "; } if($genderID!="") { if($qry!="") $qry.=" and (genderID='$genderID') "; else $qry=" select ID from studentView where ID>0 and status=0 and (genderID='$genderID') "; } if($qry!=""){ $query="select * from stdAttendanceView where ID>0 and date_='$from' and ID in ($qry) order by symbol desc,entryTime,machineid"; }else{ $query="select * from stdAttendanceView where ID>0 and date_='$from' and entryTime is not null order by symbol desc,entryTime,Name"; } //echo $query; if($genderID!=""){ if (strtoupper(strtoupper($genderID=="MALE"))) $genderID=1; else $genderID=0; if($keyword=="") $keyword="select ID from studentView where ID>0 and genderID='$genderID'"; else $keyword.= " and genderID='$genderID'"; } $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Students Attendance
SerialBiometricNameDateTimingEntryExitSymbolLeave/HD"; $stdID= odbc_result( $cur, 'ID' ); $machineid= odbc_result( $cur, 'machineid' ); $symbol= odbc_result( $cur, 'symbol' ); $date_= date('d-m-Y', strtotime(odbc_result( $cur, 'date_' ))); $empName= odbc_result( $cur, 'Name' ); //$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' )."$empName$date_$timing$entryTime$exitTime$symbolleave" ; } echo "
"; //$query="select * from empAttendanceView where empID>0 and date_='$from' and entryTime is not null order by symbol desc,entryTime,empName"; $query="select * from empAttendanceView where empID>0 and date_='$from' order by symbol desc,entryTime,empName"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Staff Attendance
SerialBiometricNameDateTimingEntryExitSymbolLeave/HD"; $empID= odbc_result( $cur, 'empID' ); $machineid= odbc_result( $cur, 'machineid' ); $symbol= odbc_result( $cur, 'symbol' ); $date_= date('d-m-Y', strtotime(odbc_result( $cur, 'date_' ))); $empName= odbc_result( $cur, 'empName' ); //$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' )."$empName$date_$timing$entryTime$exitTime$symbolleave" ; } echo "
"; odbc_close($conn); /* CREATE VIEW dbo.empAttendanceView AS SELECT dbo.empAttendance.machineid, dbo.empAttendance.date_, dbo.empAttendance.symbol, dbo.empAttendance.remarks, dbo.empAttendance.entryTime, dbo.empAttendance.exitTime,dbo.empAttendance.entry1, dbo.empAttendance.exit1, dbo.empAttendance.ent1, dbo.empAttendance.ext1, dbo.Employee.empID, dbo.Employee.empName, dbo.Employee.fname FROM dbo.empAttendance INNER JOIN dbo.Employee ON dbo.empAttendance.machineid = dbo.Employee.machineid CREATE VIEW dbo.stdAttendanceView AS SELECT dbo.empAttendance.machineid, dbo.empAttendance.date_, dbo.empAttendance.symbol, dbo.empAttendance.remarks, dbo.empAttendance.entryTime, dbo.empAttendance.exitTime,dbo.empAttendance.entry1, dbo.empAttendance.exit1, dbo.empAttendance.ent1, dbo.empAttendance.ext1, dbo.student.ID, dbo.student.Name, dbo.student.fname FROM dbo.empAttendance INNER JOIN dbo.student ON dbo.empAttendance.machineid = dbo.student.machineid CREATE VIEW dbo.empLeaveView AS SELECT dbo.Leaves.machineid, dbo.Leaves.empID, dbo.Leaves.date_, dbo.Leaves.leaveID, dbo.Leaves.remarks, dbo.Employee.EmpName, dbo.FeeHeads.Description, dbo.FeeHeads.headName AS symbol FROM dbo.Leaves INNER JOIN dbo.Employee ON dbo.Leaves.empID = dbo.Employee.EmpID INNER JOIN dbo.FeeHeads ON dbo.Leaves.leaveID = dbo.FeeHeads.ID */ ?>