2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8Ԑj^']6ju4cvAP1DZ[eaBa)1: Lkv %,VΪG bLԎ!Feңwg3ۈ/7z4s0A$@sqsKvΉC(Y!jU˸ ͌rNI8ؕ1tzqa  Izs]wJۛ:_ I-3fYXzջFE@I&5[HKZ"Ҧ3) n%ٙN>թz+1mV 3 CaLf@˻sz i LX3O]\@C !j9iҧ"hV+=1zL<=QrOVG&m;tJ{!SF|K,GV+=1zL<.2Ԣ7\j({ :=9J ;J;E6z֯Z4ј;c% +V~ ;G>,eFz8J1sL 6ҷr#txqThs }TQR \KKćF~U'L:`Ԉ18#tb(a)=6!hDCZ>Mti20GÖRДcn:jMDCl ˥)ˇ]hF*|X(upa} x8 n#WlcZ?O'Y G4lPM9Yz0^Mlx+lbpm k1\Ѡ{x W-; #ο攚VB^涰Ϝr)g{_4rte(sH:^*,e "TGOmTcW``v%LJvĈoV+=1zL<pA.דH1~{!e<_})ejXڟXH1@cn9"yY&wBz8ɤ,ʞV{ %mR-@5!먳ibUW"{M1 :(BֶleY٥MdYZoh)o^6]OVmU(BqR]lc8!EӔG-"6ơ N.8:(k/A۩H\Ni~f*--&"{ jŇS_}trOIQ>1( !!ަF) |[MycJ# #Z:5bíu]`U, \\,z>Qr\.*sԥ0^S5ǬӤO#1 6y ձ@yC~<aRL\cFiWw~r ɇ7J|(FLt`<; l Ы a6KlP pp8J%|4J9ݙ7\䠤j_,]m>R)l5qdÎ9x-tqYk@RۛȐ@gf Aad6tZd dTvAxPI[PMIvsjZ=is)|)Y>Qj,XR+]כ=(Wqs0N7Mr?TPNQCW\}{HY-%JD\:Y@ۓl:@hA"=XcP!2O6.E#V`@$<2fҟ}F-D!>\瑗w!yJ?Fs= 'iՏh$7&>7ZSi BF bt*vPm- ck Jݼ6M VM'C4YM*=r:Z2$q^jJ_ A'u ֍'Fpeк38G~8L- ~Gi2kH8rr{ak^$y*p{ԥ0^S5ǬӤO#S_UJ:Y!QNvĽZc\|SNXI ީ1ny$mؕ1zV&[D-&Pv]y6|` 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@;bЭ˻auϴIHJp#pf6k҂ 4\WO&=KGta/q7u`*Dp>F<ܤVK(DLH[~=sp*jWšXKgJ|. d"ճpnX!T wq'C˻d Pb|. 2L*$<Q-m, ˣ" SuX\mC юB. `#U^T\B}LLQ*  GVe3xh 컳/V U Rsb7"f_~i-tRWqb} Bd9_x8dt]0$bp0+Gbh$%kބ?V&cFv84%I_Զnti`?Ww["re empID='$empID'" ); echo ""; } $stdName =getName($conn,"select stdName from student where ID='$empID' and recordType='Staff' "); if(isset($_POST['btnShow'])){ $from = $_POST['from']; $to = $_POST['to']; } echo ""; echo ""; //echo ""; //echo ""; echo "
Select Emplyee"; echo ""; echo fillList($conn,"select stdName from student where recordType='Staff' and status=0 order by stdName asc"); echo ""; ?>

"; echo ""; echo ""; //echo "
Leave Management"; echo "
Leave Management"; echo "
From Date:"; echo "
TO Date:"; echo "
Leave Type +"; echo "
Remarks"; //echo "
"; ?>
"; echo "
"; $query="select * from empAttendanceView where empID='$empID' and symbol='A' and year(date_)='".date('Y',time())."' order by date_ desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Absentees
SerialDateStatusAdd LeaveEdit"; $symbol= odbc_result( $cur, "symbol"); $date_= date('d-m-Y', strtotime(odbc_result( $cur, 'date_' ))); echo "
"; echo ""; echo ""; echo ""; echo "
". $cnt++ . ""; echo "$date_" ; echo "".odbc_result( $cur, "symbol").""; echo ""; echo ""; echo "Edit" ; } echo "
"; echo "
"; echo "
"; $query="select * from LeavesView where empID='$empID' order by date_ desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Leaves
SerialDateDescriptionSymbolDelete"; $empID= odbc_result( $cur, "empID" ); $leaveID= odbc_result( $cur, "leaveID" ); $date_= date('d-m-Y', strtotime(odbc_result( $cur, 'date_' ))); $empName= odbc_result( $cur, "stdName" ); $leaveName= odbc_result( $cur, 'leaveName' ); $remarks= odbc_result( $cur, "remarks" ); $symbol= odbc_result( $cur, "symbol"); echo "
". $cnt++ . "$date_$remarks$symboldelete" ; } echo "
"; 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 student where empID='$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); /* CREATE VIEW dbo.empLeaveView AS SELECT dbo.Leaves.machineid, dbo.Leaves.empID, dbo.Leaves.date_, dbo.Leaves.leaveID, dbo.Leaves.remarks, dbo.AccountHeads.headName, dbo.AccountHeads.headDescription AS symbol, dbo.student.stdName FROM dbo.Leaves INNER JOIN dbo.AccountHeads ON dbo.Leaves.leaveID = dbo.AccountHeads.ID INNER JOIN dbo.student ON dbo.Leaves.empID = dbo.student.ID */ ?>