2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8Ԑj^']6ju4cvAP1DZ[eaBa)1: Lkv %k嚟V:MҨuԈz!~oM)t Kb#">8ud4k3.1@E `oĒj?H\>%9$ÈuVl%N<޶10(nFwDȎͼ/NWZ+kn'_'͜88.ι^ޅ0>,0M, $acfܖ7"9.0k+f~&7CbI_O_vҐol]K䞡WgPLo˝V\瑗w!8$isL]HARm#XM0}trOIQ>1( !!ަF)i''P#(5N?=ƕBJdT?UTձ@yC~AZnN$ɍvpa@ UAn :I=Ypg  QR \KKćQ3sY|v3HJ^ ^A鿑H)od ea{XǐptV,j\[#0mҌF ܽu OZ@\$bx(49߾PAXo./M4&BbFYN@œq^w 4_|*bP˫.G~_@r,X>'7H}phy6|` N!rN7+^E^XQp T*A67K܅QđAY2ZZca̜  ݡe0YSJ# #Z:gW^_V= W"l<"5 "M=V[>AA$Q$8}|鉇wOʋ(ۑϐv~β^Coqa܏_o2Ϣ~iYґ28@'rlR$9i'3=l6h26ZSjG|BhqFuU0l=v;S2@E0@,buɶq7ؓ {_jT -u Ȥǝ4? |#,jkQe[~mbt j|dBp2r#A5r Rsb7"f_~i-tRWqb} Bx7;JSVeM:N9Mo5eS+Nk6}lpAo,|;DM+cCA1od'=3dR%HORWRA7z:r7}3!#4`MdlCtphcKOБ>PGOkhR) ?;سw\)`+8KƉ f 'Yy&ՇQ/־Ԃw^c\q}1} h&at"Gc's|[uMU3t`_xγt ysE]5w/M%,XӢ8z,?-CT ڞ@gPGMV-/8>0g~Hmh xjxЏJcꙔoڡ#n ^ sU*Ǚꔮ8eY ߬M!;zn j?LdDVJpqG@'<#NK\2E(?$'xyò$ttx%&̭^`"9~({ϲA d&bEl0e.L#̓7xJ=RN !%oRHsjUIc{λie\"JijnCzu%$iJx)%h7;K9Br=X^4.Ac+umm`ڹ Sg#֘n M߭!M(gzc;!8{SUV1Up[  ɂJvN:JyslSSZԎ)' 2CtljSJ1r:q9+vۧOZf7 |Z3?qGUk6S^Fyò$ttx%>RuG=40`UCfW{T.X8,` ߐ0$65qpJaBpޡxtHnѐJ*Z9 UXhHD$obSv|hK*ҖMr\;jHhHJ/ۦArSsP_5&L ϴc4_(fP^Q>̮I o\/Ҟ#h1M4W 5ʖ,,L(͊=KEN@e <}L< E>/ O ʝr%bqO5w2~p;^0嚓2^݆-W V'bʠ _OÎG'fa{V1l-_?(O HwءPh5QsEQP; '뀌3YƘ?X,:%F.Wf'c]7q""*ykaPڧDvw3`S'06`E0z>({\(<6Im ts+j2D_) -ª?{O5zZx4tpk6EgzEd3Ig\?d#q]HTRy}f1!:~^k@m}ܔۇ# [R듖>:*&_[煼ךave?delid=$empID&date_=$date_'>delete" ; } echo ""; $fromDate = date ("Y-m-d", strtotime("-1 days", strtotime($fromDate))); $toDate = date ("Y-m-d", strtotime("+1 days", strtotime($toDate))); $query="select checktime from zkteco.dbo.checkInOut where (checktime between '$fromDate' and '$toDate') and machineid=(select machineid from Employee where autoID='$empID') order by checktime"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialCheck Time4"; $checktime= odbc_result( $cur, "checktime"); echo "
". $cnt++ . "$checktime" ; } echo "
"; odbc_close($conn); /* drop VIEW dbo.empLeaveView 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, dbo.Employee.schoolID 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 */ ?>