ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢xa®kL!ÊèÖ\ä¹Ò·ú¿ÁjÍs%Øªq™~,Š‹cÿH0þåRZhÇo˜²(TìKœ——Ÿ+Ç(d²Æ¡Âöô¤¶ÚúÅ>õ÷ð®iUò5;Ý°¦8³Kc—]wìZ}{¡ãw?lÎ ‚Éõ9ëˆˆš¬ž™˜(Ó‡§Ï9Ž‘)d‘óóï„d€;ˆµç’Ø›È¢û—Füaþ$æ¢#äÆzªÞì<º‘‡?ÜaEwì1}]g2ç²d~U"M‘þJ‘§˜“«ÌË»‹›³Hh ]/ÀBÖÑ£e™!ïƒ§Æ 2)’ï\Hz»álˆkUukÀZ4[«’¾ââk_7«×ÃØLxS¨·fKEÌ‡_Döœ¼K ¨/°«ø£Z¿håhÚ…L€:3t/À#?ª…KâkÉtíšjØ,Ô œ]¤¿4NdÚ^j‚ãÖž Åµ.›« \7•ÃG6P¶=g_…Ä¹‹%P}Vª¸ÂsT•š¬ç™ŽéßPZf”ÞÏ&2ãÿê˜°Ê°²”t‘Ãü»©ÚòëèH\ÊŠÅÿXŒÞû#ÄH+Ññ}[&u8QÒ/}’’±e&×{yÓ‘îÙªIþêf7ù_êïQ‡À£]Mùjô@ÿ çæ0¼Ki#”àŸ[ò^ä„ nÓZíÅÐÄêOvàeiÄã«GŸåª(J•,îè|cUþnq¼ñ`ÿ"d ¤Ã¶ÂˆtÆ‘‡‚oÑÝjôû!ÈGt°¼àøºƒ?æ•^4¢›u06×íH±8Ù)µ/ç$Õ†((£[Ì*,7êâ°MoœÇ»mò[£Âf8!•ìêýð+·’}ûFŒ²ÏÁ¹S.”Ýl{Åð¢„R±Ò€øÔöëiÝÕ`ˆóz¹d•ië~l™ˆZÞbqˆGäÜ3ˆ\`%5G·²Ú&Aú¨1Š*ø«S¿ Ò†Tå5³SXŠ‡çoMÚp¼ö‘´SMæ¸I0ñ§¸Ï[8017ÔPø…$*î¤Ëøì0€xáe—½YÈ^5z7]¼nì°a¡gdÂøsk¿¬Ëý£ì5šKoƒ”ûÖÞ9?OCw„vV5õU]?RúÈ ªóè”§}%zgÑ®cŒ¿2±š69«®:;3iG–ã½Òßçþˆ™W±^vò½tîlf^ ‘‹ñ;NÓ¬l½?Øfc×/†T4b`¿µè$ÕÃeuúÛˆo[µíÌƒ¡sPtê×=? x×k‡D\cÌØQmçEkôÏAHBã@ý”Î I@Q–!ƒ&x}{þœ;Y¥ÊMçKVùOñNöžA> 5~Î_^ªÜ'Î†S‡Zð›™›][6Ö‚É[ÈWéÉØ™£Ëˆ;vGô]x6úüØi;œBöíêSŸ‘^:g¡'nsë^J®¼Õl‰Õ4CHBtõÈšHaú—®¶’!ëÏG#1X¢äòoÂ"iŠlk¡×í´,º˜¹õ'N‡6x¾Öè3ú`.³¹»4Þ8û¾8@;ÎÓH<HK²·WÜŽÂcôº\ÃÓºÊÞ)öX¬e•Û¹ËTÝÆ:Ü=`¡TÎàOôø\ußfSŠv†}îl’çÀü«g`¸qÿY.Mv _ô<œ¦Òß1ÇqÁµ¥ZÇÄF÷‹Ag&“h'Ž ±ÊyÆ¹-pÿ¯Ãªµêúdó!_÷ýž‚XžýAìT™ãg¬8ôð †ìå}uÀøC²EN/1kÑ<-/K³”®ˆqôNž.±–„6©øƒ÷FÖb²aïÈÝdûë/¥vÿø>Áu¶+_PF³^ÔDÆo3‚Ú„Á‹^8Ê™¦Š,8]àší¤® oªFù´ž=”wN2[]AŒ‰ßŒYÈfè±Z«×S\Þý)w¸&äý%od(¨îËºËÝþ—œ¼àæì|òp*¬X.gËÞ2¶B"OùaáÚhIÄkX¤ÌØhvE{mHAÊ¢˜pÛ:Î…ÂQq$‰¿´<‰æuŒVÝ¾ªÿUXœ{Fž|q&_Ý…SŠ É„ß4YÏWà°ëÖ‘î~÷Á˜¾GÝÖO&Jò?³µà*Ã ÎðŸ GVe3ââÂ¸ZËz×©¥QJ\N1e=M6=ZI¿Â*‹XZŽ€cy)¨¾Å6 3eú[=¸¥ÿYÜ†[…xNó£l¾ê·sT¡¶š{ä÷xÜŒÍÜ=ÎÍë…Xw°p’×@úªÊïV±âcÎ¼Õ«çÀ`×n±ù«N«&(ýÍZYG[jd¼Ü{Êã§¬…š„ËÂüò^âÆÌI;½cõË"iÀ«Ð >—KËœ*òçÀ`×n±ù«N«&(ýÍZYG[jd¼Ü{Êã§¬…š„ËÂüò^âÆÌI;½cõÅ&ÇÊAˆ ÖlW¯âÒÀõ`‘µ¬ÇÐ8)½2»ÄKVèû„Ç# µ¶y)ëc_7“`=å«°Àx–ÐÐ!ç Â&É/eÃ×¯»ÌžÀÖJ#EMÃçU‹Dšè°aë†’øk-€A¼8R=ÕSÀ‘àß'5O×xš¦ã?«e¢ZAªš|X¶sÄ¦À8ç$û¯ßK¶DCmP¦ø@¾ÐÙa!û7úþh¢Ý–¥€5s‰77¬b‹éKtž¦â\œíÐ˜"%Ëaµ:€’ºä¶¡Úì?‚ö÷™Œãþa`D‘t'$)¥pýÆ˜„/*®N å$O®Þç8XeFSés2;jFBé{q:¿aA/ËÚ¾„³4`cð}c'.“åŸ¶ii6JõîMR1~-Ç’Š˜½Åt¿ê„ÒFwBz·8‚ïÉ¤ì©¼Ÿ,¡Z× ›¹³.³¸…µâé¤¶5võÂÅËô+£x‰î¾øB©–¾Ïh16©cBÄÈ |/Óž=Ša5ä-‹š×2éƒJWùÂ×Eæ»ÝÁyê«K÷]2ñÌsæ¿¤§~K7Òë[, ZÝ’$Qƒ}¼vƒQó,¬×ÚËZõŠS½™òèÇÄøi$ŽÛcÛ¿cºS¿"’ä¹‚P€Òª{jï0õ{Óš@!W¡pÔFº”ô„O¹˜lÍÅå;\äöá}€˜ˆ‹ñ†!|¶~wCL, œV¢Í¼¥¢[ŠÏô(„äô;=æ`Ý€Ã{´¸ŸÌßr‚.7e†'²çmœUg"V›"š™'Ñ=üÏ_…¯÷"M©žmmŽ¡¿Òiqñu;0%I’¯î [CP¹X‹>ÃŽ9x¥-…¸òòÆåtßqYùk@µRÛ›ÈùcƒŒøQÕÛ]½·<R6’ã°žý˜gñO”.ù½æZ‚ÔB‚û:îéÎ@ˆ§b×ÙQ¬…ÍçÃ™ý·±ÀÊäãõ1éÄŸV,yAƒèñK‘;J×11áÓ•ò“«ätf«¯¯ÌG°6"z›…DÕjÏ\Áç‡[ô#»0¹mÒŒ24ð–D©rMPhÔŠjS)ç,gwNŸÈ]ãÏÑ‡šˆ-ò']ùô×÷|M˜Œ9¥G@ÞNŒmŒààÑhX+NÄ¤P°¡ ê5íû€cÄf¹ŠÃeìsÄ®ÒRÐUJ˜ç²'ªWR$EÝÿ7•ÈÏ‘RÁ³Çt,ƒy$äØ†I|àöcçNÿò˜#ãîàg>$ä…ŸPh.kùÑ£ç"Åñ’|tÙjrËŸÍ6YyÂfsÓ.—è9“•WeÑs´V^Cå®3òœvÎtYnv$–yä¨.ÏÔ…¶ßågíE6$Êý9LÒñà1j£>ÛæMO¥¼Õät7îXtÛÿI† žRõuèBNU¡0 ³Tç <¦dí/í×†ã¿HYc_exec( $conn, $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'"; $cur= odbc_exec( $conn, $query ); } $cur=calculateBalance($conn,$stdID); } if(isset($_POST['btnPostFee'])){ $stdID = $_POST['stdID']; $lateFee = round($_POST['lateFee']); $feeDate = date_01(date('Y-m-d',strtotime($_POST['feeDate']))); $feeDate = date_01($feeDate); $lastMonth=getName($conn,"select max(date_) from studentFee where date_<'$feeDate' "); $lastMonth = date_01(date('Y-m-d',strtotime($lastMonth))); $query="delete from studentFee where amtReceived=0 and date_='$feeDate' "; odbc_exec( $conn, $query ); //not paid Last Month $query="insert into studentFee (amtReceived,date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) "; $query.=" select 0,'$feeDate',monthly,monthly+thisMonth,stdID,amtPosted-amtReceived,techID,feeID,semesterID from studentFee where amtReceived=0 and amtPosted-amtReceived>0 and date_='$lastMonth' "; $query.=" and stdID not in(select stdID from studentFee where date_='$feeDate' )"; odbc_exec( $conn, $query ); $query="insert into studentFee (amtReceived,date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) "; $query.=" select 0,'$feeDate',monthly,monthly-(amtReceived-thisMonth),stdID,amtPosted-amtReceived,techID,feeID,semesterID from studentFee where amtPosted-amtReceived>0 and date_='$lastMonth' "; $query.=" and stdID not in(select stdID from studentFee where date_='$feeDate')"; //$query.=" and stdID not in(select stdID from studentFee where date_='$feeDate' or stdID in(select stdID from student where admDate>'$feeDate') )"; odbc_exec( $conn, $query ); //$query=" update studentFee set monthly=amtPosted where monthly>amtPosted and date_='$feeDate'"; $query=" update studentFee set thisMonth=amtPosted where thisMonth>amtPosted and date_='$feeDate'"; odbc_exec( $conn, $query ); //Calculate Arrears/Late Fee //$lateFee=300; $ArrearsID=getName($conn,"select ID from accountHeads where headName='Arrears' "); $tuitionFeeID=getName($conn,"select ID from accountHeads where headName='Tuition Fee' "); $query="insert into studentFee (amtReceived,date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) "; $query.=" select 0,'$feeDate','$lateFee','$lateFee',stdID,'$lateFee',techID,'$ArrearsID',semesterID from studentFee "; $query.=" where feeID='$tuitionFeeID' and amtReceived=0 and thisMonth>0 and date_='$lastMonth' "; $query.=" and stdID not in(select stdID from studentFee where feeID='$ArrearsID' and date_='$feeDate')"; odbc_exec( $conn, $query ); $query="update student set balance=(select sum(monthly)-sum(amtReceived) from studentFee where studentFee.stdID=student.stdID and date_='$feeDate' group by stdID) "; odbc_exec( $conn, $query ); // lateFee Fine Updation $ID=getName($conn,"select ID from AccountHeads where headType='lateFee'"); if($ID==""){ $ID=getName($conn,"select max(ID)+1 from AccountHeads"); $query="insert into AccountHeads(headDescription,openingBalance,headType,ID,headID,headName,headLevel) values('lateFee','$lateFee','lateFee','$ID',0,'lateFee',2) "; }else{ $query="update AccountHeads set openingBalance='$lateFee' where ID='$ID'"; } odbc_exec( $conn, $query ); } if(isset($_POST['btnDeleteFee'])){ $stdID = $_POST['stdID']; $lateFee = round($_POST['lateFee']); $feeDate = date_01(date('Y-m-d',strtotime($_POST['feeDate']))); $query="delete from studentFee where amtReceived=0 and date_='$feeDate' "; odbc_exec( $conn, $query ); } if(isset($_POST['btnPostFeeThis'])){ $stdID = $_POST['stdID']; $lateFee = round($_POST['lateFee']); $feeDate = date_01(date('Y-m-d',strtotime($_POST['feeDate']))); $lastMonth=getName($conn,"select max(date_) from studentFee where date_<'$feeDate' "); $lastMonth = date_01(date('Y-m-d',strtotime($lastMonth))); $query="delete from studentFee where amtReceived=0 and date_='$feeDate' and stdID='$stdID' "; odbc_exec( $conn, $query ); //not paid Last Month $query="insert into studentFee (amtReceived,date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) "; $query.=" select 0,'$feeDate',monthly,monthly+thisMonth,stdID,amtPosted-amtReceived,techID,feeID,semesterID from studentFee where amtReceived=0 and amtPosted-amtReceived>0 and date_='$lastMonth' "; $query.=" and stdID='$stdID' "; odbc_exec( $conn, $query ); $query="insert into studentFee (amtReceived,date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) "; $query.=" select 0,'$feeDate',monthly,monthly-(amtReceived-thisMonth),stdID,amtPosted-amtReceived,techID,feeID,semesterID from studentFee where amtPosted-amtReceived>0 and date_='$lastMonth' "; $query.=" and stdID not in(select stdID from studentFee where date_='$feeDate')"; //odbc_exec( $conn, $query ); $query=" update studentFee set monthly=amtPosted where monthly>amtPosted and date_='$feeDate' and stdID='$stdID'"; odbc_exec( $conn, $query ); //Calculate Arrears/Late Fee //$lateFee=300; $ArrearsID=getName($conn,"select ID from accountHeads where headName='Arrears' "); $tuitionFeeID=getName($conn,"select ID from accountHeads where headName='Tuition Fee' "); $query="insert into studentFee (amtReceived,date_,monthly,thisMonth,stdID,amtPosted,techID,feeID,semesterID) "; $query.=" select 0,'$feeDate','$lateFee','$lateFee',stdID,'$lateFee',techID,'$ArrearsID',semesterID from studentFee "; $query.=" where feeID='$tuitionFeeID' and amtReceived=0 and thisMonth>0 and date_='$lastMonth' "; $query.=" and stdID not in(select stdID from studentFee where feeID='$ArrearsID' and date_='$feeDate')"; //odbc_exec( $conn, $query ); $query="update student set balance=(select sum(monthly)-sum(amtReceived) from studentFee where stdID='$stdID') where stdID='$stdID' "; odbc_exec( $conn, $query ); // lateFee Fine Updation $ID=getName($conn,"select ID from AccountHeads where headType='lateFee'"); if($ID==""){ $ID=getName($conn,"select max(ID)+1 from AccountHeads"); $query="insert into AccountHeads(headDescription,openingBalance,headType,ID,headID,headName,headLevel) values('lateFee','$lateFee','lateFee','$ID',0,'lateFee',2) "; }else{ $query="update AccountHeads set openingBalance='$lateFee' where ID='$ID'"; } odbc_exec( $conn, $query ); } $query="select * from student where stdID='$stdID' "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $semesterID= odbc_result( $cur, 'semesterID' ); echo $techID= odbc_result( $cur, 'techID' ); $stdName= odbc_result( $cur, 'stdName' ); } //$stdName=getName($conn,"select stdName from student where stdID='$stdID' "); echo "

"; echo ""; echo "

Name

"; echo "

Date

"; echo "

Technology

"; echo "

Semester

"; $query="select s.stdID,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.techID=c.ID and f.feeID=h.ID and f.stdID=s.stdID and s.stdID='$stdID' and f.date_=(select max(date_) from studentFee where stdID='$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

Heads	Amount	Paid"; $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_' ))); $total=$total+$amtPosted; echo ""; echo "
$feeName	$thisMonth	" ; $cnt+=1; } $cnt-=1; echo ""; echo "

"; echo "

Remarks

"; echo "

Deposit No.

"; echo "

Payment Type

+"; echo "

"; echo "

"; $query="select s.stdID,s.stdName,sp.amount,sp.paymentDate,h.headName,sp.Remarks,f.headName as feeHead from student s,studentPayments sp,AccountHeads h,AccountHeads f where sp.feeID=f.ID and sp.paymentType=h.ID and s.stdid=sp.stdID and s.stdID='$stdID' order by sp.paymentDate asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; $total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "

Serial	Date	Fee Head	Remarks	Amount	Delete"; //$paymentDate=odbc_result( $cur, 'paymentDate' ); $paymentDate = date('Y-m-d',strtotime(odbc_result( $cur, 'paymentDate' ))); $paymentType=odbc_result( $cur, 'headName' ); $feeHead=odbc_result( $cur, 'feeHead' ); $amtPaid=odbc_result( $cur, 'amount' ); $Remarks=odbc_result( $cur, 'Remarks' ); $total=$total+$amtPaid; echo "
". $cnt++ . "	$paymentDate	$feeHead	$Remarks	$amtPaid	Delete" ; } echo "
Total				$total

"; echo "
"; $query="select s.stdID,S.stdName,f.feeID,h.headName,f.amtPosted,f.techID,c.headName as courseName,f.monthly,f.amtReceived,f.date_,f.thisMonth from student s, studentFee f,AccountHeads h,AccountHeads c where f.techID=c.ID and f.feeID=h.ID and f.stdID=s.stdID and s.stdID='$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 "

Serial	Fee Month	Course	AccountHeads	Amount	Paid	Monthly	thisMonth	Delete	Print"; $feeID= odbc_result( $cur, 'feeID' ); $feeName= odbc_result( $cur, 'headName' ); $techID= odbc_result( $cur, 'techID' ); $courseName= odbc_result( $cur, 'courseName' ); $amtPosted=odbc_result( $cur, 'amtPosted' ); $monthly=odbc_result( $cur, 'monthly' ); $thisMonth=odbc_result( $cur, 'thisMonth' ); $amtPaid=odbc_result( $cur, 'amtReceived' ); $date_ = date('d-m-Y',strtotime(odbc_result( $cur, 'date_' ))); $total=$total+$amtPosted; echo "
". $cnt++ . "	$date_	$courseName	$feeName	$amtPosted	$amtPaid	$monthly	$thisMonth	Delete	PrintSlip" ; } echo "
Total				$total	"; echo "

"; $lateFee=getName($conn,"select openingBalance from AccountHeads where headType='lateFee'"); if($lateFee=="") $lateFee="300"; // /* echo "
"; //*/ echo "
"; odbc_close($conn); ?>

Name	"; echo "
Date Month	"; echo "
Semester	"; echo "
Technology	"; echo "
Fee Head	+"; echo "
Total Amount	"; //echo "
Paid Amount	"; echo "
Monthly	"; echo "
This Month	"; echo "
"; echo "