2-;R$?1祧WgբxakL!\0ӘV&bl-¥6v P5۶E-8h~з ™ ga!/*C2=3(;dY0&î1J v儏DPxe 3oSŲᣦ!2ͅhq ؏@x˲QGUDU]\nnRx3L<uj|5riah+%d7휴d$bQup=CP ~iU5;ݰ8Kc]wZ}{wο"9r/3 #!HXV)2ug+'&Pn 87~*LҜ9d4H((1HWuBK ~ +f' egc\̋k Ti,wͪI=NR6 y1v7Սdq?;;P л6>Jh̊Hƭp"2,z "L틦}Bdm[LgbJ3EWz ET66ZSCAa5'gDʑ'ˮv&42YD6ZPyS(F׍BN Pٔƍx¬O-LA4{_*R axTa',%~qh0 o.jd 5{4WLcMJ>m:`X96XfXٙBXyΡ- pmԊ_ c1(R{ OYϔ h/E\UL  7Mc-zv2&"i @u<80XHWGkF)(&E[Jqw [Rz 0+DF) Q)GZ˥~#f%D-tǫVjX#j~ ɢqy0wi s;M):VInQ:[y"4 SF-(AHxvM01,^*ۛEm0QV4o4+&WC'D൑5&{R5 s$0f2 'I}*bP݄u`fR;mԜ&BR(m,̼w_  4r ؕ%ݨvGK̍s% *CEFWmSNM{}X;f? l-h601ЋbZ,ot,ԛ6nts4y $Jcy<~zTg#-]*  GVe3g} C&OQ䣥%A3 3%CBtVm2lH@@Qý cg)hIM ܅~~INw>XhۼA w55^W>t\be4{ jŇS_}trOIQ>1P'oUNs|ʸ_7bd,MU }Z%P@ `7.MM S3u>tS63t NTڱ\ZVl~WC?# k,ăF9|a+3nk?2,&Iz"% 81@jtV ThA:a*Xpq|cPw<RSzK"ޑN\X$xx qiٯ.ކb+^3:Չl@@_[3FpCv810m)jτ9iWpͤ{كTDӡJ# #Z:gW^_V=  Wǵj/= <f=d24qz8J1sy{3"&&7{wD5ECP3M+tJZ'P-0syzͰ\Q^7z<*8FZw/aA4(X2 Gđ7G̸Qͽ>>sE_*L>sg{~}P!.oo{`9څ0Q2`Jg1lD^h3 %unMeݸ{qw߆?L%xT™#h4oď yh9jrRSsP`l3t{1bɓJИ7鐼]͈6>Bص1pmAҘ n ֍qE-"s2msHpuXvs%)cȿ|<)5R-ZɃ}:/ <_Dѿza " d F"HD9,0 L^Z1sܣ{6^Ѭ&_r?X&ڞʤ؊bc0q?D}D;WI&?;E0[Up߮8WGSB/9j)Q̺+<@ñp{suZ:F2$˾hF*9٬4`՜%%:SWwp@w4Zq;zdlm:=~MgYXR?Fr DVnhL춐jnVv7+@ObeK]#=`(ر3L2-%B)VȼZ3~fEA}5NwJɧY$nvX>f=Cl*QM*tNռW[}'V@Ydxqpl3kM H})ejXڟXUVg0@kj܂?Ѓ0wQO S:]r`s.N^mwxFp| }Gg-{R*B mc~܃F tM +=*v!XBGAU- >sN5O0j&D[9ZT2Yyg$i,Ǖ}%sB&ܠ:z $cur= odbc_exec( $conn, $qry ); } echo "

Leaves added successfully

"; }else{ echo "

Select Employee please

"; //exit(); } $firstTime=true; } if(isset($_POST['btnGenerateSMSNew'])){ $firstTime=false; $leaveID = $_POST['leaveID']; $message = $_POST['message']; $fromDate = date('Y-m-d',strtotime( $_POST['fromDate'])); $toDate = date('Y-m-d',strtotime( $_POST['toDate'])); $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']."' "; } //echo $query2; echo "
"; echo ""; echo "
Designation"; echo "Shift"; //echo ""; ?>
"; //for staff if($query2!=""){ //echo $query2; echo ""; $cur= odbc_exec( $conn, $query2 ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#BiometricNameFather NameAddressContact"; //$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'); //$machineid= odbc_result( $cur,'machineid'); //$nic= odbc_result( $cur,'nic'); echo "
$cnt"; echo ""; echo"$machineid$stdName$fName$address$contacts" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; echo "
"; echo ""; //echo ""; //echo ""; echo ""; if ($cnt>1) { echo ""; echo "
"; echo "
Add Holiday
From Date"; echo "
TO Date"; echo "
Leave Type +"; echo "
Remarks"; //echo "
"; ?>
"; } odbc_close($conn); ?>