2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8Ԑj^']6ju4cvAP1DZ[eaBa)1: Lkv %k嚟V:Mo 1e? BŞ3o\v(ϯ ݕh.46N됊Paz-qjRğ;)XgONs^t#X(杕{U<EղßpC]~͂YuLrBL҈>=nMW,]؆lhM|\Ɩi.rHۣIE*tu1h2?ڟNE2Y'.€8֪I+B']`!,K\ f0&&;'GH3y~uBPU!Du “7h 'Ι8#ge\ɠS37v=2Ɂ"``*'b2pAo,jڨӵ>ySw{i~I[PMIvsjpfE"ϼэ j"/)6gꌪ/P A}ǙJk]k-aqYh}a\#~Q\!۴]*۵3R}={cNŊ% .Uo H-ՐPͪm-^F6} }@;o"L'aԇLXo 4(B̕DZ qn .f;=+"xNO$oIY7W z*1!NsE$f/n(5~38 &[Q*8Ľ?*6\*BP+-E0gYv VAM'E~$1N~O 7+p0wg.2dI4EUJ~#pjy_CsPFd$=ITPRFK+b|LbAX@^Ri~ncћxgwޟSY(,StN-aEmE뫈L*eT[:BpMb u}*}FͬPQI]vfrP+(Wqs0NEױi| NH=&:e&Cxxu# ?u.Qo Ki=SoACL2(ll[)&-PEry$8v/ ߦL?̽{R;1Yªj< E2`ywޞБ"L-0LV'>GRP֛ + OItBkU;n^ Î9x-tqYk@Rۛ3 ݸF20K^'pK|čuR Ni}Nܗ߶qսFU)vBJ軄KrdS#0g +-\ѕͳH* R9]׸13O񾈧"02ʘ ' ;O{eLrQ e EJlWϓ˰Yf)+7e/rԝo w+}'MٚE[-s7 17( ()c(撡wAz'J̦0Qn1d鰃[ǟ`8#)z``j4E+lbyIs JB8ݛox~gz .WD{TKs}'9{X&GOȠP~ w2ۨ2A5T'< L@*Pڀz`J&TAj\Vr^+%hx0MhųyœH٧ Pmd&oP#3?dY,%Q0+Q _>=&OoHN8~ quI)y+.\D;{$Tf\khbjMI7zT~+iEw`V혍l ΨW1 ngϥBl;_G!:ɹپW:SĴJ˞r# H{=*:\"&эCi'>PRn}DP#3?dfꡙ򈞯j v_ӟqDYV+$YXGrxFofTcgLIGὰH Swp© 9,Ճ:o}.wX$L: :Ā0 KbOebJAdg@p9Mx9t晆L4a]nŒp~]6q ^voormal") { echo ""; echo ""; }else { echo ""; echo ""; } //echo ""; //echo "Remarks"; echo ""; echo ""; $query = "select e.empID,e.empName,d.d_Name from employee e, designition d where e.empName like'%$keyword%' and d.D_ID=e.designation and e.status=0 order by e.designation,e.empName"; $cur1= odbc_exec( $conn, $query ); $cnt=1; echo "
"; while( odbc_fetch_row( $cur1 ) ) { $empID= odbc_result( $cur1, 1 ); $empName= odbc_result( $cur1, 2 ); $desig= odbc_result( $cur1, 3 ); //$query = "select type,entry1,exit1,entry2,exit2,empID,e.empname from empTimings t, employee e where e.empID=empID"; $query = "select type,entry1,exit1,entry2,exit2 from empTimings where empID='$empID' 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 "
EmpIDNameDesignationStatusEntry1Exit1Entry2Exit2Timing
$empID$empName$desig$type_$entryTime$exitTime$entryTime2$exitTime2Add/Edit" ; $cnt+=1; } echo "
"; odbc_close($conn); ?>