2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8Ԑj^']6ju4cvAP1DZ[eaBa)1: Lkv %k嚟V:MF Q8!CUß/@e7d0#˂JRϮM %_].ԸK3rZ TW2?`d΄U*| F-Xʦ?՝Gyزdyy..`@&Ѱi/_ c1(R{ OY)8ܞj3f*m- VxcXl<+ly *[ mD"r?*8]|OkV{Pʡu r0xמR&(} J]>k) V 3 CaLf@˻sz~Pae#~-g'bJ aEBT&2V6;z1t.\/5ƈ{֐X{<X1.fUnxvFj[/@Bw Ez-'\'[Ӄ0%0s] C Ůز^$HL@] NYXw|v%?Xgn $ eLV|fgW0YݻV3*Gi='v7S3gKlF@fuzB6*ԹΣ˃hFLO,>5:b ON?=ƕi&V΍WR^yR&ḨKx`?۶-%<5i)OW z*1!NsE~6E c Z3N#H VDZuPg`*8Ľ?*myP>먪69KS=,3gH؍7\4:v1@B9ƈ9E+u}?7m1[).H&E:?(:lme.-c>W Nk/c.c_tRV:2 ʁ}Mf:V\ x?jLf:%P^IS$+E8S.q'Ozkԁ z*1!NsE15CBYf֤^)gu GS`4בxDN3EV}^ %wH·i>Yֻ~0l|DHÁ US/&Ğ Jv"n]!^2dI4EUJ2T1f*3T+ߕ ڹo x:pO|M>>, tbM' :yw$YKlTt ׭ Abxl9-}"w߼X :"tP$pu˗O1@~>x`aTUPEXhMGRP֛ + OItBkU;n^ p)݌D{N.vՖO! I.:Ñ K,eی'C3ʴ XjӹoI Ïpf*"ƻvN-+#uH˅8灼:jMX>Î9x-tqYk@Rۛ3 ݸF20K^'pK|0$4 ˽׶߶qսFU)vBXq.:_uP2WEۛ@ 4jӹoI Ïpf*"ƻvN-+LzmY3;? uմ&4*;>`:YN*K#:>  ˨K{͈1U-4Z}[z}#5Cε-_0 HHJKV# yCddDVrng dJo ls5KdH 3ƪ"r駒l}y}ZOr#X5V($2T_hcaj:X'f5TUUz, rZ+ !_M_RݭJCLxz¤E=N["G\h^'GW2(i 9maZ 9nl2_ ճ.n 7 PsY=NV)3\9 ^]3ADk8rb!Xw j&M?pqC Su֞1(lE6 x0nzl}L o|}朔_ Sco-2o$><+Vt$oB21~l 3tm.o%(=$p * pjY./^<{#%Z|_Zxٯ9uU~P]9{= m]ЬKc!~h!F zvD8P'jNVxo[db=WS]Ƣ+ 5=8"ᚄHNuOc}mNR.T̂L:+\5_HC'SrlizAyn+ӏmh+pcYAHնsET#NK\g<5Zy ̜oRHsjUSD݀θ"tRPIB J̖,* _P*K ?f7{\+t9J?pl*r]Z,_i(c T {)zqKǙtG| QpԎU` JAj -J*>eĔy*@M\2B+ҫR_/,)hcD*'l:4/ThnTo'f~}l]s"; echo ""; $query = "select stdID,employeename from employee_personal_information where employeename like'%$keyword%' and status=0 order by employeename"; $cur1= odbc_exec( $conn, $query ); $cnt=1; echo "
"; while( odbc_fetch_row( $cur1 ) ) { $stdID= odbc_result( $cur1, 1 ); $employeename= odbc_result( $cur1, 2 ); //$query = "select type,entry1,exit1,entry2,exit2,stdID,s.employeename from empTimings t, employee_personal_information e where s.stdID=stdID"; $query = "select type,entry1,exit1,entry2,exit2 from empTimings where stdID='$stdID' and type='$type_'"; $cur= odbc_exec( $conn, $query ); $a=0; while( odbc_fetch_row( $cur ) ) { //$date_ = date('d-m-Y', strtotime(odbc_result( $cur, 1 ))); $a=1; //$type= odbc_result( $cur, 1 ); $entryTime=""; $exitTime=""; $entryTime2=""; $exitTime2=""; if (odbc_result( $cur, 2 )!="") $entryTime= date('H:i:s', strtotime(odbc_result( $cur, 2 ))); if (odbc_result( $cur, 3 )!="") $exitTime=date('H:i:s', strtotime( odbc_result( $cur, 3 ))); if (odbc_result( $cur, 4 )!="") $entryTime2= date('H:i:s', strtotime(odbc_result( $cur, 4 ))); if (odbc_result( $cur, 5 )!="") $exitTime2=date('H:i:s', strtotime( odbc_result( $cur, 5 ))); if ($entryTime=="05:00:00") $entryTime=""; if ($exitTime=="05:00:00") $exitTime=""; if ($entryTime2=="05:00:00") $entryTime2=""; if ($exitTime2=="05:00:00") $exitTime2=""; } if ($a==0){ //$type= ""; $entryTime=""; $exitTime=""; $entryTime2=""; $exitTime2=""; } echo "
stdIDNameDesignationStatusEntry1Exit1Entry2Exit2Timing
$stdID$employeename$desig$type_$entryTime$exitTime$entryTime2$exitTime2Add/Edit" ; $cnt+=1; } echo "
"; odbc_close($conn); ?>