=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_MqOU*|Pcb/M4&Bb3&5u7t Ɂ$%YR VtAڒu봁r-'doIj.*-.!m 7Mc-zv2&CРCP5R:C8JCQ\'Pg2a=J+%6RZMIaM8vvRgbEt`oQvٴXJJL 5rl S4eQ}|fP+/DV:$Еxl>5j󞴣> xjq0ih^O;[)(*Qu_#uG}?噉t׮Q# 0zT~+i Np[,ϵ#J姪A-(C~z2/"#lKz aXj$ 3$&yò$ttx%'Hk՗#}K\7NI^'l_f%h7;Bpޡx 738\$(AY|Bc+;Rp/ qy\pvpHD7<܅7(KI3$g9{nvm\0Ttqj@Q:tXG(%Si(^=im=06UjHv'uY`719F4gZe n=ҏ۞Y9t@ӏTcfu]Q*47,Ո|@<<u֛NCiW `#goShq(UfӤ+S瞮0@EB)4,E+ HAԮo?gT-MG pиڶ3iټqDN%25+5.NȢGӛGlRP5 5 WClVd8] !'.jRn"m],f7;W5O;inچE[Tx7weArM^v!is@}GS5D} L긔qDZrKMh:e>ml_nL{OXEF*@!Q׌#_yL ^wA4B5 ⽅6z,OG8Zyl>+Pmf|e3nj$ gUKiջ0Udq_=~_%LTpnd%:%xaTJa S04CC _6zAy0Q+L#pgZM"ǭ]D& $uNAq-nPcpEDt徺*F9t$<<'_X vكep')"|}p,MtgjVv\MV:B`*h-nczΆH'C\HYݶu׽i , ,G& nMlx+lbpm k1\Ѡ{x c"n;0[+(V΍WR^yR&ḨKx`?۶hT.=Vg&،n[0ȉ qr-oO'sХ] ,ؑ'le+~D7O9;uՔ)]O%c+9 hȂb=<}r"$IW周>U+'~#X( hIFHd>E6`4@7?^g`#.E%Y.Ct0~H M>oL]u2;L1OonwF͍8z *r;D5pɰT(^^ўVS\;ћDC)01 6b0piC\HYݶg׹Cʝix+>vSxP$)N6LRXVWK[L_jb@;r7H*+JǴ>5w2~p.8 * 4JCb,@8oIP.8p $E.)@JԆ>#="7MtU 9iuQR4aJ݃cLBP)%ԥois0I{{K( 9 )`LQ܍t/k\FKr Pk~6XmwZQu[6fs0/.$leaves[$x]; //echo "
"; } } $empID= 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++ . "$empID$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='$empID'" ); $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='$empID')"); 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='$empID' and symbol2='".$leaves[$x]."' and (date_ BETWEEN '$from' AND '$to')" ); $leave=getName($conn,"select count(*) from empAttendance where machineid='$empID' 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); ?>