IQ96YH_u ,G6k9dd: 5U\P|2=3[=ljpL nZ Xc;rF-",Pz+4ye'~{3!`yaTLV[+1@#Ʊ vJ!FwEL$ooā>~I*/$m3cn}k cF'-?aJ|5v#=l01wQxUǤ>o&cȭ$Ҥnԏ\5iWzRS@U;߉6o&g_M,f䂉'$'{XM/5RYA.\ZVh֔:TIw0+e(er;h.#Df.e YeHR-)0J@PU]sF=κ6hD<5\Ě$ t&j[G Cxxu# ?w\۪꜒2c-&hY*p,k2`c5UqsrWX$1m1@Bq/6k6;Q%ihԄSɎkJGwIuzlbv\E.kc[A| hhؑ=^0~8Yt,eqdU:3bڑ/:Km+l>ȀA8&G5zX(w1 &^5 i;u)C^c:᧢pL-Ch[ f;:AF R?4bCJ+~<Xn>+ ]N}O3k3|3[+37їfx^t@W3q|"VZ;3sUࠚrV} :mZ7ZPaz T.&=۸Yu@ ?f*xuijO״٤Q?;Ywo!`b? ؅fEFG.Y(xx)UZ]ޣd}懲_=VH8=75DXu .i>*Rw<):WW2兟J!ucK/ #qS 8K%M//ZIV4oax&-&O-²ԯۍ4Je|7`Kv` &+2/`ex .M\'+ pv9jw(`r>ѩi?Gr+J ?.B,=>"-ye~ ]bl錍Ю,s/QBBUu`^ yR%YC;3Ʃe RJچ9aSafV? Ĝ-" [yJxM5Fy4.Zy1r ɻ8\ձ+XHק/zC,p.ao3HwFsοdⳠy18t|ۯZjvQ%qVT6㰞gO6orԷl8#ȷw7_~uo9Z8g6fOzoTc"*Z h==_#gdt~;h38I%pDRޣ}yo˛a@curkm5Z\]oiۑ z,e't͠x4s_)#$ 0?YXN δIpcU0)=#ݚ.SWsO 6COʟэsǰ455%EҀ19~Zaɽ8xI'3p)'{ɻXMͥ"_,Wӻ`.2(8yp@Pɶ8ThpI-;ˬ!Ѽ]pU `cJ,׹p!TV}GYkvAS`ok8CaZ ;AUY@NL"g5*&WjWO nl {(8mu 0 J쎙 q~.zR[A = ` ZNO)&<\v+)+_Z(/ 7#|9{bp}$y;^+B's9+PzZDekm r6[#.ţg^3y&@?gd: {]4281BlrPfRj ҽ+#?y8Uay3[#-ߣpiUO`D9AK|,g%fd/gK z0 pR!.s A,) `TbB8I8EyShwX)2}u^&?X".Z?՗ԻW{<0Dپn!UZ1;\s}7>3g̉~0X%N`U}Q>D1{OQMm}_&,Fj|aC -^zBgl_5ZՖE/ \Ef(ͰpxNc= 6:c#XKy\H 2j3DJϪI*?j\z ֳ=ZgBUTXCl/CRk(c\:%!6_$@N$l &4X&Ep'ҶPD# iK T1iKhtŏ;3`}4e AQM?שBX2 MO=llQa$9""Zm/pzhD`MCV䐞lRYP u!s_`nN&(ZYQlYIB-s͆%RL;["+l8F|n.5Tp#ipii :&GO-9.*-rM|r.\iJi/C)N{: 2"5zo􉞘t]Nн-6."c$D"4w8iKƨ-Rә_ PC,C{^ ,<n9mO19h_`UnF6ՓpW8r9qv+:oeiv_1d`ൾ$jpW%ovݶy-J`N qϨp'vC7%b౷Bw}~, S3˕ ݡ>a)-T|J6+E^IN*YI?~Wj'0DOf+p2~@Wv 9ɘtǒn\L(mFi*ќyͦ/ydoeDpE>/µ퐟4s;5CTǛ8ϩ.pïntFee set amtReceived=(select isnull(sum(amount),0) from studentPayments where stdID='$stdID' and feeID='$feeID' and date_ ='$feeDate' ) where stdID='$stdID' and feeID='$feeID' and date_ ='$feeDate'"; odbc_exec( $conn, $query ); $xyz=calculateStdBalance($conn,$stdID); } //echo "



".$query; } } } }else{ echo ""; } } if(isset($_POST['btnFeeNotice'])){ //$date_ = $_POST['date_']; $feeDate ="";// $_POST['feeDate']; $programID = $_POST['programID']; $sectionID = $_POST['sectionID']; $feeID ="";// $_POST['feeID']; $qry=" programID='$programID'"; $vehicleNo = $_POST['vehicleNo']; echo ""; } if(isset($_POST['btnFeeSlipPrint'])){ //$date_ = $_POST['date_']; $feeDate ="";// $_POST['feeDate']; $programID = $_POST['programID']; $sectionID = $_POST['sectionID']; $feeID ="";// $_POST['feeID']; $qry=" programID='$programID'"; $vehicleNo = $_POST['vehicleNo']; echo ""; } if(isset($_POST['submit'])){ //$date_ = $_POST['date_']; $feeDate ="";// $_POST['feeDate']; $programID = $_POST['programID']; $sectionID = $_POST['sectionID']; $keywords = $_POST['keywords']; $fname = $_POST['fname']; $vehicleNo = $_POST['vehicleNo']; $qry=" programID='$programID'"; } if(isset($_POST['btnSendDues'])){ $cnt = $_POST['cnt']; $feeDate ="";// $_POST['feeDate']; //$teacherID = $_POST['teacherID']; $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; //$txtMessage = $_POST['txtMessage']; $txtMessage ="*DUES NOTICE*\nRespected Parents!\nYou are requested to please pay your child dues on time.\nName=**\nDues="; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; //if(canUpdate($conn,"bulkUpdateSchool")=="0"){ if($ids!=""){ $qry="select ID,contacts,stdName,fname,programID,balance from student where balance>0 and ID in($ids) and labid='".$_SESSION['labid']."' "; $cur= odbc_exec( $conn, $qry ); while( odbc_fetch_row( $cur )) { $no=odbc_result($cur,'contacts');//getName($conn,"select contacts from student where ID='$empID'"); $txtMessage1=$txtMessage; $txtMessage1=str_replace("",odbc_result($cur,'stdName'),$txtMessage1); $txtMessage1=str_replace("",odbc_result($cur,'balance'),$txtMessage1); $txtMessage1=str_replace("",odbc_result($cur,'fname'),$txtMessage1); $txtMessage1=str_replace("",getHead($conn,odbc_result($cur,'programID')),$txtMessage1); $txtMessage1=str_replace("",getAfghaniDate($conn,$date_),$txtMessage1); if (trim($no)!="" and trim($txtMessage)!="") $ret=sendWhatsapp($no,$txtMessage1,$_SESSION['Contact']); //if (trim($no)!="" and trim($txtMessage)!="") $ret=sendWhatsapp($no,$txtMessage,'3018859522'); //echo "
".$txtMessage1; } //echo "
".$qry; } //} } if(isset($_POST['btnSendMessage'])){ $cnt = $_POST['cnt']; $feeDate ="";// $_POST['feeDate']; //$teacherID = $_POST['teacherID']; $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $txtMessage = $_POST['txtMessage']; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; //if(canUpdate($conn,"bulkUpdateSchool")=="0"){ if($ids!=""){ $qry="select ID,contacts,stdName,fname,programID from student where ID in($ids) and labid='".$_SESSION['labid']."' "; $cur= odbc_exec( $conn, $qry ); while( odbc_fetch_row( $cur )) { $no=odbc_result($cur,'contacts');//getName($conn,"select contacts from student where ID='$empID'"); $txtMessage1=str_replace("",odbc_result($cur,'stdName'),$txtMessage); $txtMessage1=str_replace("",odbc_result($cur,'fname'),$txtMessage1); $txtMessage1=str_replace("",getHead($conn,odbc_result($cur,'programID')),$txtMessage1); $txtMessage1=str_replace("",getAfghaniDate($conn,$date_),$txtMessage1); if (trim($no)!="" and trim($txtMessage)!="") $ret=sendWhatsapp($no,$txtMessage1,$_SESSION['Contact']); //if (trim($no)!="" and trim($txtMessage)!="") $ret=sendWhatsapp($no,$txtMessage,'3018859522'); } //echo "
".$qry; } //} } if(isset($_POST['btnBulkUpdate'])){ $cnt = $_POST['cnt']; $feeDate ="";// $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $feeID ="";// $_POST['feeID']; $query="update student set ID=ID "; if ($sectionID!="") $query.=",sectionID='$sectionID'"; if ($programID!="") $query.=",programID='$programID'"; if ($feeID!="") $query.=",feeID='$feeID'"; if ($feeDate!="") $query.=",feeDate='$feeDate'"; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; if($_POST['txtPassword']=='Password@'){ if(canUpdate($conn,"bulkUpdateSchool")=="0"){ if($ids!=""){ $qry=$query." where ID in($ids) and labid='".$_SESSION['labid']."' "; $cur= odbc_exec( $conn, $qry ); //echo "
".$qry; } } }else{ echo ""; } } if(isset($_POST['btnBulkInactive'])){ $cnt = $_POST['cnt']; $feeDate ="";// $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $feeID ="";// $_POST['feeID']; $query="update student set status=1"; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; if($_POST['txtPassword']=='Password@'){ if(canUpdate($conn,"bulkUpdateSchool")=="0"){ if($ids!=""){ $qry=$query." where ID in($ids) and labid='".$_SESSION['labid']."' "; $cur= odbc_exec( $conn, $qry ); //echo "
".$qry; } } }else{ echo ""; } } if(isset($_POST['btnBulkCards'])){ $cnt = $_POST['cnt']; $feeDate ="";// $_POST['feeDate']; //$teacherID = $_POST['teacherID']; $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $feeID ="";// $_POST['feeID']; $query="update student set ID=ID "; if ($sectionID!="") $query.=",sectionID='$sectionID'"; if ($programID!="") $query.=",programID='$programID'"; if ($feeID!="") $query.=",feeID='$feeID'"; if ($feeDate!="") $query.=",feeDate='$feeDate'"; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; if($ids!=""){ echo ""; } } if(isset($_POST['btnBulkCardsVertical'])){ $cnt = $_POST['cnt']; $feeDate ="";// $_POST['feeDate']; //$teacherID = $_POST['teacherID']; $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $feeID ="";// $_POST['feeID']; $query="update student set ID=ID "; if ($sectionID!="") $query.=",sectionID='$sectionID'"; if ($programID!="") $query.=",programID='$programID'"; if ($feeID!="") $query.=",feeID='$feeID'"; if ($feeDate!="") $query.=",feeDate='$feeDate'"; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; if($ids!=""){ echo ""; } } if(isset($_POST['btnCards2'])){ $sectionID = $_POST['sectionID']; $fitclass = $_POST['fitclass']; $boxIds = $_POST['boxIds']; $query="update student set ID=ID "; if ($sectionID!="") $query.=",sectionID='$sectionID'"; if ($fitclass!="") $query.=",fitclass='$fitclass'"; if ($feeID!="") $query.=",feeID='$feeID'"; //if ($boxIds!="") $query.=",boxIds='$boxIds'"; //echo "
".$ids; if($boxIds!=""){ echo ""; } } if(isset($_POST['btnVehicleList'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $vehicleNo = $_POST['vehicleNo']; echo ""; } if(isset($_POST['btnDebitors2'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $vehicleNo = $_POST['vehicleNo']; echo ""; } if(isset($_POST['btnDebitors'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $vehicleNo = $_POST['vehicleNo']; echo ""; } if(isset($_POST['btnClassesList'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $vehicleNo = $_POST['vehicleNo']; echo ""; } if(isset($_POST['btnStrength'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $feeDate = date_01(date('Y-m-d',strtotime($_POST['feeDate']))); echo ""; } if(isset($_POST['btnFreeStudents'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; echo ""; } if(isset($_POST['btnDiscountStudents'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; echo ""; } $option=0; if(isset($_POST['btnPrintList'])){ $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $feeDate = date_01(date('Y-m-d',strtotime($_POST['feeDate']))); $vehicleNo = $_POST['vehicleNo']; $option=$_POST['optionID']; if($_POST['optionID']=='FeeSlipsMini'){ echo ""; }elseif($_POST['optionID']=='FeeSlipYearly'){ echo ""; }elseif($_POST['optionID']=='schoolClassList'){ echo ""; }elseif($_POST['optionID']=='absentListSchool'){ echo ""; }elseif($_POST['optionID']==1){ echo ""; }elseif($_POST['optionID']==2){ echo ""; }elseif($_POST['optionID']==3){ echo ""; }elseif($_POST['optionID']==4){ echo ""; }elseif($_POST['optionID']=="DuesListClasswise"){ echo ""; }elseif($_POST['optionID']==5){ echo ""; }elseif($_POST['optionID']==6){ echo ""; }elseif($_POST['optionID']==7){ echo ""; }elseif($_POST['optionID']==8){ // to xls echo ""; }elseif($_POST['optionID']==9){ // to xls if($programID>0 and $sectionID>0){ echo ""; }else{ echo ""; } }elseif($_POST['optionID']=='recoveryClass'){ // to xls echo ""; } } $monthYear=getMonthYear($date_); ?> HOME
value='0'>Active value='1'> in-Active
Class
Section
.
.
Fee Reports

Post Fee
Fee Month
'>
Fee Head
Amount
Fee Password



"; $query.=" order by ID "; $txt=""; if(isset($_POST['keywords']) and $_POST['keywords']!="") $txt=strtoupper($_POST['keywords']); if(!isset($_POST['submit']) and !isset($_REQUEST['bulkIds']) ) $query= "select ID,stdName,fname,programID,sectionID,balance from student where 1=2"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#IDStudent NameFather NameClassSectionContactVehicleBalance"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $stdID= odbc_result( $cur, 'ID' ); $stdName= odbc_result( $cur, "stdName" ); $fName= odbc_result( $cur, 'fname' ); //$personalNo= odbc_result( $cur,'personalNo'); //$machineid= odbc_result( $cur,'machineid'); echo ""; echo "
$cnt"; echo ""; echo "".(odbc_result( $cur,'ID')); if($txt!=""){ echo "".str_ireplace($txt,"$txt",(odbc_result($cur,'stdName'))).""; echo "".str_ireplace($txt,"$txt",(odbc_result($cur,'fName'))); }else{ echo "$stdName$fName"; } echo "".getHead($conn,odbc_result( $cur,'programID')); echo "".getHead($conn,odbc_result( $cur,'sectionID')); if($txt!=""){ echo "".str_ireplace($txt,"$txt",(odbc_result($cur,'contacts'))); echo "".str_ireplace($txt,"$txt",(odbc_result($cur,'vehicleNo'))); }else{ echo "".(odbc_result( $cur,'contacts')); echo "".getHead($conn,odbc_result( $cur,'vehicleNo')); } echo "".(odbc_result( $cur,'balance')).""; ?> "; $cnt-=1; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; //echo ""; if($cnt>0){ echo "
Class
"; echo "		Section
"; echo "		Password
"; echo "
"; echo "
"; echo "
"; echo "
"; //echo "		"; //echo "Vehicle No
"; ?> 		Vehicle No

"; echo "
Type your message
"; //echo "
"; ?>

"; } if ($cnt==0) echo "

No Record Found

"; ?>