I:ܫc+]YF3KD $ײ >Ww!LdiyV2pfKi#[^a=Cq,NNWq8VeuI *PNM0S8'蠛+h@nDsL7dCvxv"nFg2_1H)߸Kt}s|:$3aeH\آ{W JV+:yI}\[_[uy_y>"n+GBMaMB8\H~Q%^t=Y ﬑s+o7k?']3)R_@ e9GWiRM1h%YoZʙXYHP8nت柳qZG(h *A[KI"u&Bha La2ʄШ}trOIQ>1,H+ RS9g)nzcUxEn KcB3'#F/vΐ*>(+h'DCP&]S_._$l| _`;zo;qoҏ7`D>J: Q \u)C^c:᧢pL-Ch[p%t阘q!/ۡdW(wt A[}trOIQ>10qߢTh׍>{i=mjȘ-VR^g!l`ngyp3!nqqr3 #ឰmjˆxz)5.Q v|'v y8MK(X 4meLa.yw_ atke΋p6!x!W"}u8tF"7;WkWMYY5cK paoB1WM3Z`l~g"Kr[GOF^ YÙ'Ur)]xe)YWxh [ $ZQ4& }l8lNۼ3*n?Jf.Ⴍ%7>6o+[Xll2+ o-B@eB".({-Ūa՜fws&h)/1V6Ʒ #AjC9hF7U-!sۆvH0YKȸ:L q+X&Ep'Ҷbۖ Ŀ%`JNlGyDY5m*\R\IzM`.A[g/#*?yRTF---x'kr|i>֙ֈw&'g}φbxE2ZFhg`)rf`5".7PT G4UP?6&'v' {*D U'wB`P|p?k\A[Ik=it@H/:N*P\lg Hx61#u_mSBi^`DvtC_U(jg7DCf l5$(m.-J #G Jx&yܮ&NJySyjltO7>3g̉|!, /:m)~RD5l}2? (/Lr`\;qoҏ7`D>J:rI!E 9e.uAmYCd-K? iD1Vb>G4|B+e<'ZSdeĞ]:?R,fU"uumPx1 $0&߈t+YTt$B\ S8'蠛+h@nD߳y 4o+;k$2Ȁ?qiVL2]{슜h5tR~wB:qNbD҈BNb-%Ɖyho4ϕ񘘡B.eL RgNoMpoki6lzo&k sudv{qC]FLr\>ht*]Q^ \7Kƨ-Rә_.'zp &NI3m!+dLa<H\:O-'] |M% E:ƽ- ( έ'?ELlDTȭ16Yxr}M^cǎt=Li0\o,Y썩L.,}~p'E4/Ysi`5b#_NME2HbTi8H b/%ÁchT%EE)Koаn j qo| .>/rL??ۭ{֞(+yAa|CSafu>. ӵo@|P $KV# y?ZTGGT,2>Ԁ{ɬ8 }B0}eYwק= VN0jG̸Qͽ>>sY0tx[w-307 ` n%ѵl6Bx$츞㄂ZC3ZG S}BBg-{R* _C"iTu |.US/L*_w8?%u{ ᾢ{" =9!\ w+EyWsHc׷CnZ-S8'蠛+h@nD@ҬFwb}FNA&Xbb^%P]6̓եmKd\ua14-;LdW!H;X1PFcuHq$nMXEԯC|[o#\=Ncd?6oC ʩ4ȬŪa՜fwsڞjxw' @~R g2hh=Q4Ga(zF}a5vueDate=addHeadValue($conn,'dueDateFee',$value); $dueDate=getName($conn,"select headName from AccountHeads where headType='dueDateFee' and labid='".$_SESSION['labid']."' "); if($dueDate==""){ $dueDate= date('Y-m-d',time()); }else{ $dueDate = date('Y-m-d',strtotime($dueDate)); } $cur=addColumn($conn,"ledger","stdID","int",-1); $cur=addColumn($conn,"ledger","labid","int",-1); $cur=addColumn($conn,"ledger","feeID","int",-1); $cur=addColumn($conn,"studentPayments","userID","int",-1); if(isset($_GET['stdID'])){ $stdID = $_GET['stdID']; } if(isset($_GET['delID'])){ $stdID = $_GET['delID']; $feeID = $_GET['feeID']; $techID = $_GET['techID']; $date_ = date('Y-m-d',strtotime($_GET['date_'])); //if(canDelete($conn,"addFee")=="0") { $query="delete from studentFee where techID='$techID' and feeID='$feeID' and stdID='$stdID' and date_='$date_' "; odbc_exec( $conn, $query ); $cur=calculateStdBalance($conn,$stdID); //} } if(isset($_GET['delPayment'])){ //echo "





"; $stdID = $_GET['delPayment']; $feeID = $_GET['feeID']; $paymentDate = date('Y-m-d',strtotime($_GET['paymentDate'])); $feeDate = date('Y-m-d',strtotime($_GET['feeDate'])); if(canDelete($conn,"addFee")=="0") { $feeMonth=getName($conn,"select date_ from studentPayments where stdID='$stdID' and paymentDate='$paymentDate' and feeID='$feeID' and date_='$feeDate' "); $feeMonth = date('Y-m-d',strtotime($feeMonth)); $query="delete from studentPayments where stdID='$stdID' and paymentDate='$paymentDate' and feeID='$feeID' and date_='$feeDate' "; odbc_exec( $conn, $query ); //delete from ledger $query="delete from ledger where stdID='$stdID' and date_='$paymentDate' and feeID='$feeID' and labid='".$_SESSION['labid']."' "; odbc_exec( $conn, $query ); $paid="select isnull(sum(amount),0) from studentPayments where stdID='$stdID' and feeID='$feeID' and date_ ='$feeDate' "; $query="update studentFee set amtReceived=($paid) where stdID='$stdID' and feeID='$feeID' and date_ ='$feeDate' ";// (select max(date_) from studentFee where stdID='$stdID')"; $cur= odbc_exec( $conn, $query ); //echo "
".$query; $cur=calculateStdBalance($conn,$stdID); } } if(isset($_REQUEST['genetaFeeNext'])){ $stdID = $_REQUEST['stdID']; $feeID = $_REQUEST['feeID']; $lastMonth =date_01(date('Y-m-d',strtotime($_REQUEST['genetaFeeNext']))); $feeDate = date_01(date ("Y-m-d", strtotime("+31 days", strtotime($lastMonth)))); //$lastMonth =date_01(date('Y-m-d',strtotime($lastMonth))); //echo "







"."select monthly,amtPosted-amtReceived from studentFee where stdID='$stdID' and date_='$lastMonth' and feeID='$feeID'"; $arr=getName($conn,"select monthly,amtPosted-amtReceived,techID,semesterID from studentFee where stdID='$stdID' and date_='$lastMonth' and feeID='$feeID'"); if(count($arr)>0){ $thisMonth=$monthly=$arr[1]; $amtPosted=$arr[2]; $techID=$arr[3]; $semesterID=$arr[4]; //if(canSave($conn,"addFee")=="0") { $query="delete from studentFee where stdID='$stdID' and date_='$feeDate' and feeID='$feeID' "; odbc_exec( $conn, $query ); $query="insert into studentFee(date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) values('$feeDate','$monthly','$thisMonth','$stdID','$amtPosted','$techID','$feeID','$semesterID')"; $cur= odbc_exec( $conn, $query ); $query="update studentFee 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'"; $cur= odbc_exec( $conn, $query ); $cur=calculateStdBalance($conn,$stdID); //} } echo ""; exit2($conn,$conn3); } if(isset($_POST['btnGenerateFeeSingle'])){ $stdID = $_POST['stdID']; $feeID = $_POST['feeID']; $feeDate =date_01(date('Y-m-d',strtotime($_POST['feeDate']))); $lastMonth = date ("Y-m-d", strtotime("-5 days", strtotime($feeDate))); $lastMonth =date_01(date('Y-m-d',strtotime($lastMonth))); //echo "







"."select monthly,amtPosted-amtReceived from studentFee where stdID='$stdID' and date_='$lastMonth' and feeID='$feeID'"; $arr=getName($conn,"select monthly,amtPosted-amtReceived,techID,semesterID from studentFee where stdID='$stdID' and date_='$lastMonth' and feeID='$feeID'"); if(count($arr)>0){ $thisMonth=$monthly=$arr[1]; $amtPosted=$arr[2]; $techID=$arr[3]; $semesterID=$arr[4]; //if(canSave($conn,"addFee")=="0") { $query="delete from studentFee where stdID='$stdID' and date_='$feeDate' and feeID='$feeID' "; odbc_exec( $conn, $query ); $query="insert into studentFee(date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) values('$feeDate','$monthly','$thisMonth','$stdID','$amtPosted','$techID','$feeID','$semesterID')"; $cur= odbc_exec( $conn, $query ); $query="update studentFee 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'"; $cur= odbc_exec( $conn, $query ); $cur=calculateStdBalance($conn,$stdID); //} } echo ""; exit2($conn,$conn3); } if(isset($_POST['btnGenerateFee'])){ $stdID = $_POST['stdID']; $feeID = $_POST['feeID']; $amtPosted = $_POST['amtPosted']; $amtReceived =0;// $_POST['amtReceived']; $monthly = $_POST['monthly']; $thisMonth = $monthly;//$_POST['thisMonth']; $techID=0;// $_POST['techID']; $semesterID = $_POST['semesterID']; $feeDate =date_01(date('Y-m-d',strtotime($_POST['feeDate']))); $dueDate =(date('Y-m-d',strtotime($_POST['dueDate']))); $dueDate=addHeadValue($conn,'dueDateFee',$dueDate); //if(canSave($conn,"addFee")=="0") { $query="delete from studentFee where stdID='$stdID' and date_='$feeDate' and feeID='$feeID' "; odbc_exec( $conn, $query ); $query="insert into studentFee(amtReceived,date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) values('$amtReceived','$feeDate','$monthly','$thisMonth','$stdID','$amtPosted','$techID','$feeID','$semesterID')"; $cur= odbc_exec( $conn, $query ); $query="update studentFee 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'"; $cur= odbc_exec( $conn, $query ); $cur=calculateStdBalance($conn,$stdID); //} echo ""; exit2($conn,$conn3); } if(isset($_POST['btnFeeReceipt'])){ //Fee Paid $stdID = $_POST['stdID']; $bankDepositNo = $_POST['bankDepositNo']; $techID = $_POST['techID']; $semesterID = $_POST['semesterID']; //$amtPaid = $_POST['amtPaid']; $paymentType = $_POST['paymentType']; $Remarks = $_POST['Remarks']; $paymentDate = date('Y-m-d',strtotime($_POST['paymentDate'])); $stdName=getName($conn,"select stdName from student where ID='$stdID' "); $cnt = $_POST['cnt']; for ($i=1; $i<=$cnt; $i++) { $feeID = "feeID$i"; $feeID = $_POST[$feeID]; $amt = "amt$i"; $amt = $_POST[$amt]; $feeDate = "feeDate$i"; $feeDate = $feeDate = date('Y-m-d',strtotime($_POST[$feeDate])); $query="delete from studentPayments where stdID='$stdID' and paymentDate='$paymentDate' and feeID='$feeID' and date_='$feeDate' "; odbc_exec( $conn, $query ); $lastMonth=getName($conn,"select max(date_) from studentFee where stdID='$stdID' "); $lastMonth = date_01(date('Y-m-d',strtotime($lastMonth))); $query="insert into studentPayments(userID,bankDepositNo,date_,feeID,semesterID,techID,Remarks,stdID,amount,paymentDate,paymentType) values('".$_SESSION['userID']."','$bankDepositNo','$feeDate','$feeID','$semesterID','$techID','$Remarks','$stdID','$amt','$paymentDate','$paymentType')"; if($amt>0) $cur= odbc_exec( $conn, $query ); //echo "
".$query; //$query="update studentFee set amtReceived=(select isnull(sum(amount),0) from studentPayments where stdID='$stdID' and feeID='$feeID' and date_ ='$lastMonth' ) where stdID='$stdID' and feeID='$feeID' and date_ ='$lastMonth'"; $query="update studentFee 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 ); //echo "
".$query; //Cash Debited $query="delete from ledger where stdID='$stdID' and date_='$paymentDate' and feeID='$feeID'"; odbc_exec( $conn, $query ); $remarks="Fee received from $stdName"; $query="insert into ledger(remarks,stdID,accountID,feeID,debit,date_,userID,labid) values('$remarks','$stdID','$paymentType','$feeID','$amt','$paymentDate',".$_SESSION['userID'].",".$_SESSION['labid'].")"; if($amt>0) $cur= odbc_exec( $conn, $query ); //$query="insert into ledger(accountID,feeID,credit,date_,userID,labid) values('$stdID','$feeID','$amount','$date_',".$_SESSION['userID'].",".$_SESSION['labid'].")"; //$cur= odbc_exec( $conn, $query ); } $cur=calculateStdBalance($conn,$stdID); $cur=calculateBalance($conn,$paymentType); //exit(); echo ""; exit2($conn,$conn3); } $query="select * from student where ID='$stdID' "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $semesterID= odbc_result( $cur, 'semesterID' ); $techID= odbc_result($cur,'techID'); $stdName= odbc_result($cur,'stdName'); $fname= odbc_result($cur,'fName'); $programID= odbc_result($cur,'programID'); $className= getHead($conn,odbc_result($cur,'programID')); $className.= "-". getHead($conn,odbc_result($cur,'semesterID')); } //exit(); ?> HOME

Student Fee

Fee Month
Program
Semester
Fee Head
Total Amount
Monthly Amount

Due Date
Receive Fee
Date
Semester
0 and f.techID=c.ID and f.feeID=h.ID and f.stdID=s.ID and s.ID='$stdID' and f.date_=(select max(date_) from studentFee where stdID='$stdID') order by f.date_ desc,f.feeID asc"; $query="select s.ID,S.stdName,f.feeID,h.headName,f.amtPosted,f.techID,c.headName as courseName,f.thisMonth,f.amtReceived,f.date_ from student s, studentFee f,AccountHeads h,AccountHeads c where f.thisMonth-f.amtReceived>0 and f.techID=c.ID and f.feeID=h.ID and f.stdID=s.ID and s.ID='$stdID' order by f.date_ desc,f.feeID asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; $total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Fee HeadAmountPaid"; $feeID= odbc_result( $cur, 'feeID' ); $feeName= odbc_result( $cur, 'headName' ); $amtPosted=odbc_result( $cur, 'amtPosted' ); $thisMonth=odbc_result( $cur, 'thisMonth' )-odbc_result( $cur, 'amtReceived' ); $amtPaid=odbc_result( $cur, 'amtReceived' ); $date_ = date('d-m-Y',strtotime(odbc_result( $cur, 'date_' ))); $feeDate = date('Y-m-d',strtotime(odbc_result( $cur, 'date_' ))); $total=$total+$amtPosted; echo ""; echo ""; echo "
$feeName (".toAfghaniMonth($conn,odbc_result( $cur, 'date_' )).")"; //echo "".$feeDate.":".$feeID; echo "$thisMonth" ; $cnt+=1; } $cnt-=1; echo ""; echo "
"; ?>
Remarks
Deposit No.
Payment Type

Fee Slips
# Date Fee Head Total Monthly Paid Generate
'> =1){ ?> Generate
Payments
# Date Month Fee Head Remarks Amount
'>
Post Fee
"; echo "";; echo "";; echo ""; echo "
Post Fee for the Month"; ?> LateFee"; //echo ""; echo ""; //echo ""; echo "
"; ?>