ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢xa®kL!ÊèÖ\ä¹Ò·ú¿ÁjÍs%Øªq™~,Š‹cÿH0þåRZhÇo˜²sò‡óèd*î²,ŽÁè6¹{@“Ì)™Ž13Lë„‘Þ^<}ÕâØð5 ì(8<#Í"¸Õå:Ÿáíž)šTç×%M­’}î }uh]îßñ„@)žÞ¦ž8·íç…·¥¨*3V¬2y¿‹vûÕ_[€ðv&š3$ÃÍÇý8þ‚ýÜs¨pØÄ®j7£bŽªs™·2!ÜÙv×¨–
IFÏ:h©ö*|ÚCû|h—€èÜ—˜Ia±£sHlQø¡‘~k˜e!…ŒÞÎgàûm2n…w-ŽÚ6Ùð‡ËzL$¹Lãòkv1Ù2ÒZ™Ì¹{'rÅÝ‘¤#7(ÐLk€F	‚ÇíñÖw´ƒá›:?óI”¬b5*oÔqîyì9ÿùTx}ÝT„îòÝ°TŸôó[“4Ì¿üø#oIÖ{áT@‘·Ê³Ø$X!eÆU²‹GAÄ„±úæb[¬ã~L\Ù©†óBã¤´[aC¾8F8à:/êè§ØC_¸pÕ¼ã3’SìÜ9\{uÆ)Í¥-ã¤~=úx¹âv[OÍR`7ö Fióôüy*[B‘‹`÷6£>á] ç4luD	¿œ}{-fvB£Òöxn;ÅèÜS²	fd©ƒÏjXåÅ’°ða}œ›)ùejìXÎÚŸXªŒþZßpëìÑJžm 7¨Û>~
ÿ÷m9J(Çp žï ü¥p7ùë:ˆÙ× ™ã,Dú¼Å9¨4öáx’Atí}2§«ÉüTÅ
ãŸ\ºÄ
53Wbšè”Ü×w¼ž»4Ùëq„ÌF6Ñ³¬m?ŸL[„¸°'‚+û_æ©8†²$¶-#·ÞÞÂÝ‰ž¸WEE›EC8jBÈMp‡Á>0LšÌuéçå‹±“ÕßŸ+?ùÔ³ÐXo§Õ%xþ—úö<±ªŠ®._W%Ï[ˆÿ—`hh†f‘†È›~øJ“KªŽLM”†X<Â¹£Ô,»ŸÏæÅƒ`´\{>ÄÇÄéš¹ËIeX>Ðêgäéw'åï§~ðwö˜ì £b¿Óy‘ë„†'?ÓàÇÛuº)ú¬D=jJcnTšU6”1x8>ú¾Md°ôØÛN3­¡^^ƒ9VÔ½$ÎÝ	Ô÷ÖÚf‹…9‹|ñ[}™AuP0»­ùƒfó¾·(y•ÝÇõ¦É‡Ø%S¥êC-F—X1Ë9µµàêiXvê•Q•1&b¼…—“2ÏEôûB§)g=¼ÓÍÙ Hvó•ÅáèÏCšïHw¬3ýXèzbÙÌ3ØêASö|ýœœ2…hÇmF9³ÉjÒÑrRî©SÊsZþ(kD NŠâ~	c­d8*ñŽlÐþ?~ ¨ƒb«kÐ­Âã5VˆGV×xôdÉÈÅŽ… ¹4píçD§£€‚Û‡z¼eøX­³´ƒ¡ÿ›1¥PÐPÝßCœý•ù*Æc°Ì;¸m°ýÑ},ê=ª¦))·`›™’pþ‰¥ïàÚO¬º¦ý°“Xú6L`5
uáæ7[`Òe"Y%•&Þ]<PŽÜˆŽe&û¼‰ÏöÉÚ2/`!ðÊ…BÌO²@¯Œ“h¡âÎ%Ÿþ¼ÓÀÇ+V~Ñó³ŽÀ´ÎE>Ü/Â>iG¼š¸£Ý£?!`ÖÛAÝØ%d|Ä&8ý†`ÚspËhŒoîªû$È/–,ï>‰F a¢œÏ^wD%ƒº„ž\ø3_¡´1í¦Ž*IsÜ­M1¾ÙÈÙÃ$ŒµQîÎÐXåÓR_00„†1;ÔÑîºÍfá$“ù“yñË2eöÞ‚eÖn4N€”(‹4»Ì=ºýg—AÙÏN´lz”¯ õ¿«ul\±eŸïKm¥âÎDW»àÊé>aËùÂ·ô¾¨åJ¶¢Ï-7–pZ‡£!Ð”‡NDéjËŒCò"¶Ø°‘?Ki“gh‡á:ûvwøÜœ:¸šJk¨ÓL
Ç\21ÈUxÙ¬®í¿,ß¸*klÊ¥r}W‘èòå¨®‹^t5n‚Bçé£¬µð¿Íî"Ž’nW‚&:·dãêî¾Yå¶‰m-&7¶jÄ³¡T›XrI\äÝ¥ÒðQ™|9ÊÒØVh¦…Fm‰^µÏZ 3±Â¾ÿ1-gA1Ö¶PÝ%6ÜÝdEœArìÌqîã‘Š´»®¼•ešw¨ãx?ò;ƒžÑ¾4æ«7Ò«s›Žð¡ç¤¯'Ã«æ¨°«ñ×Àk”Ä}G.‘3WOA’ˆG½Ù¤ÏKü¤ tµ”T£-÷ÚˆÏV°üHpêf8÷éRÌìŸˆ6¬wDEßV•.“åŸ¶ii6JõîMR1KÜWãÄ‡+üP
ü¾1Ç½7L5:¦“×C&+CMÌœd³Ñù¼_õî¿yýbØ
¸r#G‹ÃÇ¿uJ©&ïôj‹|ñ[}™AuP0»­ùƒX’O6le¼Òž}õ†–Á(qYò=$ÜWÐg‡¯·uÌp)õlÂ|¶ëØ8 ªO æÞéª€žúÆ6~øèÛëG³›¦»Žü-÷ ‡þ­=.Z^©vÈÓÚ‡I|ùg=®µÕ`–Í*ÌNâÀõ`‘µ¬ÇÐ8)½2»—æ|›á€ëDÖ;áMïÒé.Ì~ÆÖ -µ-Ÿé¡÷yžŠ£ß‰š¬°ã>wQ3IVŒnÍEVœÔŒõêµ 	l“žcë;°¯ð×H\ç5Êõ­§ Ðáa"ç)oup…ð×ÿßÂÇ”l]7Ø‹‰'eDiÇ×AØBw“rÎï,}.ÓBï»t£#ÅÌµ:Î;¾V¥šz š”è7ð€-(j4È‘ S<¶sÔÒ}žçÄ|át¿“ ²òëj|dBTðç’)XÐ-sd<õ §,ËS‹&Op:;{Þ=i~aŠEné	6Ûj+¥R×îrvqÝ›Vš/š-|íÌšöûâé°/2´WóM9‰3iÚ­ý^
d%µ“¶²>†êãÓýe!ì /Ræ†I9Q|Ùëg™vðqïÁÓ®R§ü¶šëþ”ý‰gU²çPüRq ýÕO5Šw?šƒž°î´Ç’b9&aîŠ2dµ çÐ\{ó †ä“^¦âN\®Ø³°1û8Žhâ¬Ü´44¨°Â˜é:Åþ÷ÏÌœ8]<A¾í›NÏ¾ à;&¡ï?fçƒb7‡ÙüÀUsxb_Çc9!ª€¼R»
Y³)ÔF³	(-SPRïMÊ
ˆ»ÌÁ
aÆçóQÃév8=¥§ÿ  ôQoœà<ø¥ØY /ŽTøÜ–>OgöóºÕq·µ •F,e	”¥ºÎ|	SŠ¿€>ŒòœÑ0­,¬4]·xúä„5Æyî¹^¥õªpK¹rm–zþÚûõÌ¦’ †~ôÆ	e’…g£À†€öùèy§9M˜[¼Ä×‘íoøïµð¯1^GˆŸ“æ®î´îEüŠ+t)«ÆŽáévJŠïì ü]^-ï¢ÿó™ ‰‰MŒÁ«Õ`á-ÇS©H$úy!¯vŒ-ëÚßçŸ÷z¿š™¶ ›p¤Â©’Žçÿ™Ó `¹Â Næsö=I±Mti;«ª×=îEýjá
ÚJ1ñí³í3¼W!Ím‚_±‚I¬7ê•Ðiçö?xtÔL#-NÍ*ØF‰ÅP÷Íø\3±ÔT§âB^rã.$"]U¾z.4¾ÈÙBÓR+äÊê^T (4©£#îL?ˆ=y6–c©k‰VÒê¥æ3j»@+YÙÛˆQ´àËøçåeqÙ3Š¬^…ñš€ÃÇ·¯” :ÐÅîœóAÞ ;j²i¡§«
Ÿç åÎgô¤•2)Û©ºmØ6Èîˆ9zôßsaïÏyQ^%˜no›A§k\ÅÔú‰ªg³F¾Ô‚üèru‚«ÅHçu#Ž[ÖS…
"É©«g¯òcfI¤¾\ƒÛÌ2§&—Çä”tQ6Õ,O|ªe?iÒÑš¡íƒ
CpnÂß£m`I!rˆËôw–OÃk€”.„­³³t‘þçiÓþGä¤…ý±Ž¨àÜÃ,tÃž—µ½ôÉý‘"uQlýš$m0|ÿÖCÑzs–• [ÿ?”z+ös7y²‡b mlv¨h_³0Õ F÷üò°Î$`ÉÇ£C¾tìŒ¶äOåžÇ¥fCAã¸ÿì ÌÉÏÙÊWò}.§¨%üsdsy„¸«k+f~¤&ë7CbI_çO_ƒ²‘ó	Iy9mS	J¨ñÞa)6Q_ˆÑ™tQCÌ ªÏHž‘@Cœ&Ë=~¹rðƒ­sÂ! àÈëÌr.ÉG[x˜çßèû©¨Ê[cú¼4Ckæg8=-¯…Êö™T…é5+Ï¡]ªÎI8
k›½õÕèÜ«ÄÿÃU9 +:îŒÆŒÏ„ð²x:t!=¤5y‡’´i
<]`*Dp>°F®<¶Ü¤VK(ôT7]cBÝØ¾[¸GµçÊ3ÇÃº Á²÷b¾¥ òÐ¤Ñó'ŠDÎnÅÉK…BiÏO?j,Ã¤JÚdlúìm¾ÈG1Ý¹·f§*äœÙ±nÒ“¢`Äš~¹’Ï_}ÅÁ>w®çK«4ÛL[Ž‘½"ÃsÆ-æ,4Xæ†Tõ™ó\8ßå÷‹ÑkÅ‘£…{À[×´›*zÜ·Ô' ìXš0#J‡Æ…¦µïHwèFÃÿ§s©ÎØ NSF3X‚,{ºÿÎv­¶+[Ôx÷ó³Ìh£E¼†BðT&2›V6šÊ÷Ò‚JHÅ¾³tÛ9‹žó6SJï@ËeþÆ3!&Í×A¦@‡×Ö³ç|>°–˜ÄL«KÊ×>X,ò:%ôF.Wfõ£]{qÀ‰ç3ú‰’`KnÚø ºÃ>u2!ùó!ý0=!”oJ&Ný×Çud„6‹JXé%iÉzn²ö3*‚­9"ŸÝú»…i´W™ùnïi†	J^6®ÑœAFMMõcì(:Õ²Àùûøšìô•ËÎDœ{YFº^—ßYƒö •vnûC\ÀÌmùÔ÷F5å±#}9öl¤"âJ¥Â‰ Y×ªêGí9T¦—4	íàGu?M#AÏ`ÔÉ|;>åì°B»Í	öWTÆß?»“Ü1ayiB{gpF¦Wêm6{{Í:mÜÇÌË¤ò§XõFíÔõ}Ç²Îd$ÎÄqÅ|’¶|×/N¸’$ª®=úâËÌÔòÎ^z¦8›¯Âè
œJw´þ¥length='5' style='width:60' type='text' value='' name='slipno'>";
	echo  "<tr><td>Remarks<td colspan=3><input maxlength='50' type='text' value='' name='Remarks'>";
	echo  "<tr><td>Amount Paid<td><input maxlength='5' type='text' value='' name='paidAmt' required>";
	echo  "<td>Discount<td><input maxlength='5' style='width:60' type='text' value='' name='Discount' >";
	echo  "<tr><td>Payment Date<td><input type='date' value='$date' name='paidDate'>";
	echo "<td align='center' colspan=2>";//<input type='submit' name='paid' value='Paid'>";
	echo "<button name='paid' type='submit' class='btn btn-default btn-sm' ><span class='glyphicon glyphicon-save'></span> Save";
	echo  "</table></form>";    

}
else {
	$ID= $_SESSION['stdid'];	   
}

	$stdID= "";
	$stdName= "";	

	//(case when (1) then '1' else '2' end)
	
	//(case when ([obtmarks] * 100 / [totalMarks] < 40) then 'Fail' when ([obtmarks] * 100 / [totalMarks] < 50) then 'D' when ([obtmarks] * 100 / [totalMarks] < 60) then 'C' when ([obtmarks] * 100 / [totalMarks] < 70) then 'B' when ([obtmarks] * 100 / [totalMarks] < 80) then 'A' when ([obtmarks] * 100 / [totalMarks] < 90) then 'A+' else 'A++' end)
if(isset($_POST['find'])){
	$stdID= $_POST['stdID'];
	$stdName= $_POST['stdName'];	
	$fName= $_POST['fName'];	
	if ($stdID=="") 
		$query= "select ID,name,fname,classfit,sectionname,preaddress,resphone,status,Balance from studentview where  name like'%$stdName%' and fname like'%$fName%' order by name";
	else
		$query= "select ID,name,fname,classfit,sectionname,preaddress,resphone,status,Balance from studentview where  ID='$stdID'";
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
		while( odbc_fetch_row( $cur ) ) {  
			if ($cnt==1) echo  "<br><table   class='imagetable2' border=1><tr><th>S.#<th>ID<th>Student Name<th>Father Name<th>Address<th>Contact<th>Class<th>Sec</th><th>Status<th>Balance<th>Certificate</th>";  
		   //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 )));
		   $id= odbc_result( $cur, 1 );  		
		   $name= odbc_result( $cur, 2 );  		
		   $fname= odbc_result( $cur, 3 );  
			$class= odbc_result( $cur, 4 );  		   
		   $section= odbc_result( $cur, 5 );  	
		   $address= odbc_result( $cur, 6 );  	
		   $resphone= odbc_result( $cur,7);  	
		   $Balance= odbc_result( $cur,9);
		   if (odbc_result( $cur,8)=="0") $status="Enrolled" ;  	else $status="Struck Off" ;
		   echo  "<tr><td>$cnt<td><a style='text-decoration:underline;' href='feeEntry?showid=$id'>$id</a><td>$name<td>$fname<td>$address<td>$resphone<td>$class<td>$section<td>$status<td>$Balance<td><a href='Reports/printlist?stdID=$id' target='_blank'>Print</a>" ;
			$cnt+=1;
		}  
		echo  "</table>";
	if ($cnt==1) echo "No Record Found";
	
}
//$query = "select top 12 Monthname2,dateActual,ReceiptNo,TuitionFee,Transport,Examination,Transcript,Security,Paid,Session_  from Feeview where stdid='$ID' order by date_ desc";
if (isset($_GET['showid'])) {
	$stdID = $_GET['showid'];
	$totalRecords=getName($conn,"select count(*)  from Feeview where stdid='$stdID' ");

	$query = "select Monthname2,dateActual,ReceiptNo,TuitionFee,Transport,Examination,Security,Transcript,Paid,Session_,Discount,AdmFee,Date_  from Feeview where stdid='$stdID' order by date_";
	$cur= odbc_exec( $conn, $query );  
	$i=1;
	$arrears=0;
	$cnt=1;
	echo  "<br><table class='imagetable2' style='display:block;width:100%;overflow:auto;height:50%;'><tr><th>#<th>Month<th>Adm<th>Tuition<th>Transport<th>Exam<th>Hostel<th>Others<th>Total<th>Disc<th>Paid<th>SlipNo<th>Balance<th>Paid<th>Payment Date";  
		while( odbc_fetch_row( $cur ) ) {        
		  
		   //$Month= odbc_result( $cur, 1 );
		   $Month= date("m-Y", strtotime(odbc_result( $cur,'Date_')));
		   $dateActual= odbc_result( $cur, 2 );  
		   if ($dateActual=="" ){
				$dateActual =  date('Y-m-d',time());
		   }else {
				$dateActual =  date('Y-m-d',strtotime($dateActual));
		   }
		  //if ($Date!='') $Date = date("d-m-Y", strtotime($Date));
		   $SlipNo= odbc_result( $cur, 3 ); 
		   $TuitionFee= odbc_result($cur, 4 ); 
			$Transport= odbc_result($cur, 5 ); 
			$ExamFee= odbc_result($cur, 6 ); 
			$latefee= odbc_result($cur, 7 ); // Transcript 
			$others= odbc_result($cur, 8 ); 
			$Paid= odbc_result($cur, 9 ); 
			//$Session= odbc_result($cur, 10 ); 
			$Discount= odbc_result($cur, 11 ); 
			$AdmFee= odbc_result($cur, 12 ); 
			$Date_= odbc_result($cur, 13 ); 
			
			$Total=$TuitionFee+$Transport+$ExamFee+$latefee+$others+$AdmFee;
			$Balance=$arrears+$Total-$Paid-$Discount;
				
			if ($totalRecords-$i<8) 	{
				if ($cnt==1) echo "<br>Pre_Balance=$arrears<th>Paid<th><span class='glyphicon glyphicon-print'></span>"  ;
				echo "<tr><td>$cnt";
				//Reports/feeSlipOld?stdID=1827&date_=2020-10-25&classID=2&sectionID=1&dueDate=2020-11-25
				//echo "<td>$Month";
				echo "<td><a href='Reports/feeSlipOld?stdID=$stdID&date_=$Date_&classID=2&sectionID=1&dueDate=$Date_' target='_blank'>$Month</a>" ;
				echo "<td>$AdmFee<td>$TuitionFee<td>$Transport<td>$ExamFee<td>$latefee<td>$others<td>$Total<td>$Discount<td>$Paid<td>$SlipNo<td>$Balance";  
				echo "<td><form action='feeEntry.php' method='post'><input type='hidden' value='$Date_' name='paidMonth$cnt'><input type='hidden' value='$cnt' name='cnt$cnt'>";
				echo "<input type='hidden' name='slipno' value='0'>";
				echo "<input type='hidden' name='stdID' value='$stdID'>";
				echo "<input type='hidden' name='Remarks' value='NA'>";
				echo "<input type='hidden' name='Discount' value='0'>";
				echo "<input type='text' style='width:60;' value='$Paid' name='paidAmt$cnt'>";
				echo "<td><input type='date' name='paidDate$cnt' value='$dateActual'>";
				echo "<td><input type='submit' name='btnPaid$cnt' value='Paid'></form>";
				echo "<td><a href='Reports/feeSlipOld?stdID=$stdID&date_=$Date_&classID=2&sectionID=1&dueDate=$Date_' target='_blank'><span class='glyphicon glyphicon-print'></span></a>";
				
				$cnt+=1;
			}
				
			//if ($i!=1) $arrears=$Balance;
			$arrears=$Balance;
			
			$i+=1;
		}  
		echo  "</table>";
}
	
	odbc_close($conn);
?>

<h6>Note:Run Application on Server to take effect in half second. Thanks</h6>

</body>
</html>