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-qڐe: 2z( g^c&xL%YiYp*}JI2j,_gP"<-]A\"73_#9:w0ױ\B-CU?rJj64%Q*;=+,K7G^:C8JCQ\'r2P jM, $acfܖ7"9.0b^L"C&߿+!!GGFH!kJ4k3.1@ͪӺCUài6ښE3}jxW u $w ;|F ȡWgPLo˝VA'Q}%+$>| 먍21I=Gxbܠ KG ul𪃃#:=/26 %ʞky$Vd;4ӏBRh"1ĹdW <鎦]?Sڀ""UL\rǻNm.5\<#DB R!]U{[+EEr$2ca#6BV"}Z-Q?.鏘KVj~o::z2:~{"k:pV&t[Jz 6Ll}-JyWnru#wq5J \Rkʣbg*zm Shd TBD^5[A0)Q!b]."亐l6)89\^:ÚUVxY-I`dAP2F8}L4zY+Ԁ΀B*]~}p⼭ት˶B䬦" 2q))rZA~\Zڲbp0+Gbh"%KcƉ!O'K5\<#DB R!]U{[+EEr$2ca#62)rogxiW4*I pXPO= :g0M>bK, .yr7}zȫw(l8˘O5Of]ZC`v( k$WHg<~:")j D0J:fuzB6*X'wnZ_bp!ۣ^օ;p&`*Dp>F<ܤVK(3g֕3}hul\eKmaȇdt+$B9̭v̙z_I }ʒ]NKDCmP@ ׳$]/5pI+kHřd~ֺe9,_rƹ&+-ZhܧDx]s"?P:'u)GiGD j 4 8 u<¸U;LvSVp2f5 s=Du t\(;(#M o`U~O=,-JdJF_#Q cP3; _THo!{2Q)v頵X0"aq6^o jS$vlqPNFEcNN?Z,sfpߕx-gQV/exԹvu*Ũ 4& |=Hs-FWB(ʇF\G>Fcf}w`{5)H͙h?()DW(O-w eXăKegjaUBAbYFX *v<;c-L׽4ee{kF8J=z%QNIr~EqՍ~ #pW!C[mk>.pͱ'c\>ə\OG8K! O]A?086QVܛUPMX= 5f筴Ws83[ϳ|pZM VK:W:]A6:sӌcMa᪟R<)&KO@_ egn}Dw=O9+ reŤ/UEt+t9J?pl*r]Z,piOIK=8X( vY~Vkj֍~#.Fh3ٸZ-1Uu樂J[WA7&6 @)v0?dـ݉C5gpuقUl!CMKvZP{^2|y;A p==эCi'>PRn}D"; echo "Leave Type"; //echo "Remarks"; echo ""; echo ""; $query = "select e.employeeid,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 ) ) { $employeeid= odbc_result( $cur1, 1 ); $empName= odbc_result( $cur1, 2 ); $desig= odbc_result( $cur1, 3 ); //$query = "select type,entry1,exit1,entry2,exit2,employeeid,e.empname from empTimings t, employee e where e.employeeid=employeeid"; $query = "select type,entry1,exit1,entry2,exit2 from empTimings where employeeid='$employeeid' 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
$employeeid$empName$desig$type_$entryTime$exitTime$entryTime2$exitTime2Add/Edit" ; $cnt+=1; } echo "
"; odbc_close($conn); ?>