=47%RVfҫTN]U% ( bN]ቩWäNSl"2#n\|P-j>ub}r]oP0̰Mc{8M6rS)SP_}@fw6aON4?%^:v0%@LcsĘ"TaG[*&vH)Yzf Nu0=Hy(;/vR)V`tfWH\ R2_is-gX Gh/\De>kΌ pz|L;s(dV;A0:ג!btBfJ%&u@Q䣥%A3 3%CC֝ZW TlMkf4-ڼųA[L͑Q/*A4?qoߦ¬7#M]^'O5~ ''W+0C! r[܁Ջjt4ru_* FwX>Î9x-,]J, I_MqO_4.~lT{Ƥ ۰? &bż"` z=Syp3ݼj?&Ыi1B "&$mEH9PCP0PERm$d &UjPն(4 8`sCB %a|?j\[#0mҌ0XeH4Q);vݹ=u$wE}trOIQ>1Cɞ8+tHWA4vF6*%dCߤW\Xk-pjdewx?;֝.$t 7bF22$Ja&܅xY"搢C$naX}IU/IZT.k| 86/֙o'NNa1Rx^ f@˻szW/C\̹5֎!s} zT~+i Np[,ϵ#J姪AsS 7v:lFVО 2 y9M[בo ɰG} GLkws~qrMwD ^#D$ zRc/y %9O9#Jk(lE6 x0nzl}L o|j?c^rf|F[%2JhxǺ1uK M46]⮰4{װtۍ><8޽+ )&%tǍ=ˑsBio\/ RѣS+Lر8f+,1*>eĔy*˴ͥA54p"+CY?̃*lP †Kr}9Q{oE/ֶ c`.Z`DbF|\D\\3!.gF&\t ] Dx 3VT3B׬3޾<:e6!Dwm&jA잂O}Dac9m1(WY!cr47,Ո|@<{U oά!=PNiy"{fF/E=DL CMnX,2 Spjvڎ/k%щ2g\zJ{I^Ͽ(1 ﺥ:LTHˉ0;]AƜ6ycO*l%Oms DwNi_D]_HYK{/eO4 LK9-Ww9^RۗvG܅A.`uQ ،:)3>UU(9 -9D%Ru7"ZTsaNZɩ֔LL`Ǐ8)2|D;Mʍ=Gzej,q*{ܰKQl{aB?s۸. j1p*Np犹TBFb'TJ868l*y[pHgQ~g]U"JA1z?Wfޤd҆NRo[nH05]m1Em-Vĥ[zj8tG{SkuëĜa/&h:KRh"冶e?%پˮdY/`mmct}pW4^m5w`@l ('˿/P=R 'N2aW$ R)f=9>H5 \{$U&CjijvH8xq!gnS2( gMc1Qb%ִw?K*Y-J\,܇-=#wy|ł4 >mop{;~j3ݰqn X~?CD5[kLlh;fғի[8S+,4K7.~ ;,*(ԐՐ %bGh~ 3< ( ` .6ՐfMo8uҦ@ϏVM~8(y H^p|-ʎO4tZ aKx&VȾPlNnZH7FF(7xLv\*1iKht9 )pN>i "*Җ@eͺ/1JŦ^ sU*Ǚꔮ8eY ߬M!cx {{zɳbXZ*jNJGNב ē ֹGxK g Jsf?Q/Fr'`".$leaves[$x]; //echo "
"; } } $employeeid= odbc_result( $cur, 1 ); //$date_= date('d-m-Y', strtotime(odbc_result( $cur, 2 ))); $empName= odbc_result( $cur, 2 ); $d_name= odbc_result( $cur, 3 ); echo "". $cnt++ . "$employeeid$empName$d_name" ; /* for ($i=$from; $i<=$to; $i++){ $symbol= ""; //$cur1= odbc_exec($conn, "select symbol,case symbol when 'A' then 'red' when 'P' then 'Green' when 'CL' then 'Purple' when 't' then 'blue' else 'Black' end from empAttendance where date_='$i' and machineid='$employeeid'" ); $cur1= odbc_exec($conn, "select symbol,case symbol when 'A' then 'red' when 'P' then 'Green' when 'CL' then 'Purple' when 't' then 'blue' else 'Black' end from LeaveType where id in(select symbol2 from empAttendance where date_='$i' and machineid='$employeeid')"); while( odbc_fetch_row( $cur1 ) ) { $symbol= odbc_result( $cur1, 1 ); $color= odbc_result( $cur1, 2 ); } echo "$symbol"; } */ echo ""; for($x = 1; $x <= $arrlength; $x++) { //$leave=getName($conn,"select count(*) from empAttendance where machineid='$employeeid' and symbol2='".$leaves[$x]."' and (date_ BETWEEN '$from' AND '$to')" ); $leave=getName($conn,"select count(*) from empAttendance where machineid='$employeeid' and symbol2=(select id from LeaveType where symbol='".$leaves[$x]."') and (date_ BETWEEN '$from' AND '$to')" ); if($leave=="0") $leave=""; echo "$leave"; } } echo ""; odbc_close($conn); ?>