Wduw{Aó*19Gixh+AOgmNJ̺Ւ Cd/[!%+WSZ~<]Dhy.p0C'Ts/(yHLǑ}xf4gY*ǰ 2۪(f`,aϿ[tZ݅[3g&߿+!!GG^DʝG }y_ c1(R{ OYrlz iOu ;eE$Bu]TA,WwH4g_5,<+z:۝I lJTD`MCV䐞lRY1RlMN, ӹ;`XX%˞U8%iKH-pS$t3K; fr5tYMq*D-X,0svAOMy[!J(4kkwi辁ZRwDhTJso0w US|qf^'7E@^rk_\&0= 0GZq^Mz5 X>Î9x-L"bBakS:F2$˾hF*QH'R8]FMn)h'#(Vۑ沽ppPwMNs>ιE2cf+Wjx&M0!ˏ\ 6Dp""z'\-vD\J-cU'꤆LE8!}VM'C4YM*=r:Z2$q^jKʄn7mռ}oj4F7Սdq?;;Pz|?X8 wo놲j }ӆ_EB7N,%AFs*c g/b:x͍ 妹«cpo7{kd@yH$->h_ G5m)2=a]<0הRSzK"ޑc:ۿ3-H;’4+'L+~ѬncP$ I .M+p9`⎖Ն7g!Y?bOۭ?'^'#G؅Fڇڦ3[52P.SrqL+%5+ vydp܃wþ%|W:B=}; TIBzmNܿ,b4$6f# %!Ќh[vPp4yVŔKj'{IaUm3׿\v^%p# lA9Q̲AHX$5Ȯ g3D?@p_ZJF|"ƚfp8zW#VLuM(TӓHpoIfe:JW,(fBښ&:4#%ӰyL$pԆXU pl5ٸ wPߎ;yrm܎*_B)-/\-Wŀ1>"p6ǯʡ]!ʄú>`vߌ;A$>]F MyLy]60' hHtfjwh٫XVq]{]8P)ݼ=X&M^fkim>H[&P?ORc5rcX|o#544˜:̜8]۟{+#~B/&{]q$R=2n!3BY7\䠤j_,ˤ6}1 `,nix`;?PL@HU >@!tF-ZTv8 ,/E/#_f}Ge#u ֍'Fpeк38G~JHJڱGA0[[r ٮݎerNM1KO] .P'_Uq$|@䝁@"qv_s 7B7Ezdek=]=k3ʖ\n2JIDa«7|7:r_X œlG'!NcrOch4oRq]O8O0gX,}+{+8l{ O$&hKSۏ9*D<BּwTyJB-A%SLp5 ]\Rוf?x#`uߐ&P s=HjP#6  YN tUwt8) WP ZkM׀/I.,yDU?BB\Î9x-S!fsEF'vPbncF㿒S t-ҭdX!T wqÞ坘pa} x8 n#W+C aO54J} btO_0vO'厭rjL-cw;N8I8EyS7C5pZ_,RО SdGG}x5YcxGv5VAFԬ07 Xlf~qߏ1ܐXb&ĻL`"=2K/g{)RDZɃ}:/ <_DѿzaGo'"w5GG艇7#{=VҌxxK"Sozs6C:M qÜ]S;^&jmPuYq_2=Ji^l]",}6 4wcW@<YA̪_[h b XԙuQqTؾۗSEGЇNcu)% "r\06'ӆCҢ}#nѤn3< |[MycJ# #Z:TZZ(NR!]'MYm1-#ӯmȅ $ids=""; //foreach($checkAll as $value) { foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } //echo "IDS=".$ids; if($ids==""){ echo "

Select any Student please

"; }else{ for ($dt=$fromDate; $dt<=$toDate; $dt = date ("Y-m-d", strtotime("+1 days", strtotime($dt)))){ $dt = date('Y-m-d',strtotime($dt)); $cur=odbc_exec($conn,"delete from Leaves where date_='$dt' and stdID in ($ids) "); $qry="insert into Leaves(machineid,stdID,date_,leaveID,remarks) select machineid,stdID,'$dt','$leaveID','$message' from student where stdID in($ids)"; $cur= odbc_exec( $conn, $qry ); $qry="update empAttendance set symbol=(select headDescription from AccountHeads where ID='$leaveID') where symbol<>'P' and date_='$dt' and machineid in(select machineid from student where stdID in($ids))"; $cur= odbc_exec( $conn, $qry ); } //$qry= "insert into smsinfo(stdID,date_,text,cellNo) "; //$qry.= "select stdID,'$date_',N'".$message."',(personalNo) from studentView where personalNo is not null and personalNo<>'' and stdID in($ids)"; //$cur= odbc_exec( $conn, $qry ); echo "

Leaves added successfully

"; } $firstTime=true; } if(isset($_POST['btnSearchStaff'])){ $dID=$_POST['dID']; $shiftID=$_POST['shiftID']; $query2="select * from student where status in(0) and machineid>0 and recordType='Staff'"; if($_POST['dID']!="") $query2.=" and Designation='".$_POST['dID']."' "; if($_POST['shiftID']!="") $query2.=" and shiftID='".$_POST['shiftID']."' "; } ?> HOME

HOLIDAYS

"; $cur= odbc_exec( $conn, $query2 ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#BiometricNameFather NameAddress"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $empID= odbc_result( $cur, 'ID' ); //$personalNo= odbc_result( $cur, 'personalNo' ); $stdName= odbc_result( $cur, 'stdName' ); $fName= odbc_result( $cur, 'fname' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); $machineid= odbc_result( $cur,'machineid'); echo "
$cnt"; echo ""; echo"$machineid$stdName$fName" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; echo "
"; echo ""; // echo ""; echo ""; if ($cnt>1){ echo ""; echo "
Add Holiday
From Date"; echo "
TO Date"; echo "
Leave Type +"; echo "
Remarks"; //echo "
"; ?>
"; } ?>