®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃ<ï@õ\«Ni…¤ÖÀGÊ0PŠ(•dCª¿ª3Sº$'c¨rÕ|©ù-;Þà,»Ž²gºv½§»Qó°¾‡´“WÒ
'¦CbN®q¶á{ÓlÊ%““Z\Ö=¥Ô¬š¯ðŒX¶Mc­“ÑD!0—-üD¹‹¸À]#ßŸa\ÎM›!†öšw÷‰©ô¯ÀuÝç+‡°Ö…6Ï”]€°K9$ðåˆºZØü@H$…¿ cæVp´œúÈ·{-	w]Þˆ~ŠtKO‹-)êœN½öc?àëà‡ „+$QuÉU-!Zú‰R¾Úc«$ôy}§½ûØöÐTŸqF}l·o–©›€/[N]ž7šMc-z€‚v´2¤‰&†EÃ$õ¶˜©~oŸYnóŒtAÚ’uë´Ýr-£þ'¦Ê	h÷qÙ;)­­Ó`7šMc-z€‚v´2¤‰&†]é¨9wõmY¸lQä£¥%A3û3%C…ƒëÿz2âù7³šœ÷KÏÚ•ÙèŠÔ|ÅvÀð¦ž¿ ]>½}ƒ÷¶ŸØ‹`²ä›l÷qncØ`éÚ‹VŽÃcâ|‰i¾Õè:†¦ÚZF!DòXª`æŸí£Ýo¹+¿‡ë38ÝªG®óç~“øáö<xÁöçgœ=0B—*ðNÓnU^rÂØ8N”?".jÏ\Áç‡[ô#»0¹mÒŒkrˆ÷M"ÜÀvØÔ8Fˆ‹ì‡B$G¢€Ýuô	2y£_}ôM¹½îÇq»všQì©3¼-ßØŸÁÅRZí¢2‚ÖÅ•&õæ\bó[r=®ÈÃòº*­–>ã€}³ÚBÎS‚L°H+I&ék?×†oŽH¦«ÑÌˆwuMfäÿÞ†ÅõP½8Ô2Iªóz¦è±[4X«R¹È+F¢/‘†<¨ð©«4v›(’ñ	^§Ô„d\Ž‹¢{$l¡FBÏb×ïÊæ5ÖÖí®ëJüíÕN}d¾lMâäÅ¿=ÑáxF‘Yœ™}°Z?Àx¦pêŽëŠ‚?÷Õmf™ÛUígE	‘ª£ŠRnø@‘å¤]#^€k½:ÑýVh*CÃª×
»ð:µ?ƒDá·4·Ë¶[=C~‹*çjª¦ Èì›&»Ö;î5¾=a«=k4$žÊ‚ìÎ“^Ps‘ ::”Þ½eWðpGwŒ_@dg¦a ™¢®¦iL(42-’òå¶"IYå¦$§6»É½ËP¸mJ^±ÈKŽ	àXÛ²œÔ'Ì¤U+u"ÂŽãŸQyÔÑ#ó6—1RÚKä„;BÛ¸£VÞÑ-êusD.¤|IAÃKxQ±ž´:à^û½/©M4&B•”ÀbŽ˜ ×í’ÊËUjK ú+ä…3$!Œ¬P1æ*–‡ò:o-µ/ýª¯ 4ãÎ°¬àÏø<£šfg7 :”Ên`P\D½’fŒ÷%*ì’ošî…6á.iÒh¾Ë(†çVÎ›™A)æ]ï™ÃÑ°^Ž³…AËpï¨ö•ý
‹H‘×„,lÂ·ï™jÌàÆ¾ó 5*Ð±7s÷ýböÉ67é)3ß™«a×&gš#VA¢‘±Q„*³Ôÿ,e Ó"TGÞOm‘T:F™¾™2$Ë¾ˆðhF*!7¬Zºcáäã	˜¸oæc0~NÑk—	†ªÌO==Ãû½/©M4&B•”ÀbŽ˜ /a/¨Í.£fpÂþ‡‘ÀÜ6ÖacéO#Ð!ØOw‚}tËrOI´ÌQÇ>1Ä¢ƒS½kÏ×~Ï¾Éà¤âå#Yè(îÿ7CÙžø€ÓÐÙ¤øW|?šÿ¾ôRx2¾ú^ÞNZ êT–©ÁÇ­·¸yD¨Æ˜ïÞôo_Yˆ,ŠÄÇX±—ÓNËœ	d©)Ý^W‹7b‰~pì†9B­’¶(ÖµY"Õä’ÀP5Ý@E–jlàdï8¿{6fˆÐA~Œóè30Kšh,Žú–‘È{·+$ó1Võ¯‘¹2\šÎ@:éªÝ#ƒ¤ãè£iÛ±á¨í¦Íž3×x€’ô‡x¶ÌÌ”8à¤^¿AñèQ"0~NÑk—	†ªÌO==Ãû½/©M4&B•”ÀbŽ˜ /a/¨Í.£fpÂþ‡‘ÀÜ6ÖacéO#Ð!ØOw‚}tËrOI´ÌQÇ>1Ä¢ƒS½kÏ×~Ï¾Éà¤âå#Yè(îÿ7CÙžø€ÓÐÙ¤øW|?šÿ¾ôRx26o,8ËÙõÈ2Ï½Ç$]X>:FÉ+k—¡§ZØšæÛ@†g`2‡1w6sE2‘×+Ëé§Œ~hÐ28è{Å±E{#û%WÍ g•7	 llžÏ\}¨’{HáYÉ-û…Ãœ±Ñ£Çë¶¶·ÌÔÖ5qøŽúS'¡dšM'Ü®&e\-©YU|ãÈ©?Ts»q?¶=ëcbf©÷¶Xg¥ú2Ó†‹Ö½áØ_PiÌóRIL;â¢ræbÀä8øÖûÌkc€©œ}ÜBrÙ·ð˜Û õCÕìJÀô3:Wî«¶²ãŠ¨,°&È[È†¼«bÎ“íCÕxxu#ˆ¶²
?e÷‡
º+ æSúÊ½û={cE ˜1_½1!”·ˆÎ‚}tËrOI´ÌQÇ>1Ä!xQIòâ®5ü´†ôLÒÓä°#\J›‚šïPv‡ë38ÝªG®óç~“ø¤ 0çf]€”jÎÔÒ®˜Ö¢ÆQŠ
¾Å*ŒÂÿsÀX©§GóG®Þÿÿ†‰¥iJ¥WIrÒjU®´%¼vã›þ‘„œ’	ÌsËé1ñ:ºM\ÜG¿¾üËµ"RÝú·dÅ7—ZJhß¡à¢$ã»yË0Ú°Ä½qW­W’âÜã#èÉÄøM†uû¶€¤Q–ì·Ë.,+CF	´ö§M?>Šü z¤fÔý×¦OûêUÏ¸3ù…Ã0@aÏÿ“äÌ‚ 0"_OO—S ¸þdùU³Œ$;ýà2v6olÅ¢ù²î¤.(ãp=K7«3—d«ûLªq›ôõINÔË«“~›óì‚cû–ÖÞl•ž*ãçhCJÈ*4fýmEDQKÛKÏR6ßa§ƒà¹gÔ”fL³|©Ú~'‰ê#
O´q»ÉÄÒ7šMc-z€‚v´2¤‰&†Ùï,J:´@çqÚKº$£6¤ÏÓZ·F2­†Ø2¼ð1¸1’êMOu¤èþ(}ÀdðKæ(¼OÙ]ûŒÖ@dœ‰"jc4‡—fe3YÕ˜Ðjzµ’úá‡ÑN	!ÃJ†#ÝÍù`›ÁÉ÷?¢ÿPÜ
7,‚mUÛ&'M_3«k-Øe„ÔÉ:4¼ÛåžŒwg¦Iˆ
P?œ:‡¯$ê%ÌØÉeíX™ö'SÐçÈA<o¾@Yé½lÓ2÷—ø08ù)}
w ‘FÎzKü› þ{è–Ûéì‘ûÞað@…2¥‹n+˜nŽà‘Z7"çßÔþTä +á¥A¾"·žâ¤›ÏM{Íatyí°h‡r¦GûÉåGf\»‹)W–!xâÔ¿WŽEèyå"¼vÜXåÌNî6!¯Á.<‡E­š[³ ÕÐßªÎ4 SÃVš~Ê™–‘Bb•ìëÉ”nÿWkê&É\©Ó¿fdDÊókÛÁded|:x¸SºT°>cUU©”9Ù¬‰P_l`Ý=qZ<Ä{–dÚÐ&(Fý<óHÎTU¹µ)µÚ“©Ùë2Òon'Pá<j~Â%'Ë«¯JÜ`­e'L‹áÝRr8açÏ¦Â;ÃëxŸ#ô+ˆ±çâ=4¹‹x$NBLEÁßA-‹$‹Lœ4’`Nqâ'(˜çŒZ‹
ª	f•¡ãœõš˜ŠÍhö_t-ÑÅ[ªXâ;ë€I)Qnûžh„ÅH£-ì\>¿ö	;Û$æ5pŽŽ
]·-¶¬xðbé_ËÄÄGÊŽ<JáëI!lÓµéVû&Îó{ÑêJ7ŸÕŽ\ðxqä×žrBÿ¾ÆMlx+Ìl—¾¹bp Ùm k1\Ñ ¸æêõ{xÂŒ	P€oP˜ÒÎÛi>/ßC¬¦EWNöêî™ab°ã›?g%ÁÜ—n®%±Æª¨@å ¤)Ö?C¡Ê³=.:ï÷ø QmÂôåJÏQÖ!ö bv¹ÄÁ= HÜ¿j¨®g‘bADha(|U…tNT©+´µ-7~úÅ®‚­ÎÓUŸßÃeG”C¥K¡­"‰³¡ ¤×–È‘ª÷‘§À’Ê^åîÄœë¡¤BÆ±zGÝ¢BH0êÒ}#ÿúÔMU–{L¨÷ŸmkÖ¿K*ƒÁ`9ƒÙÑïpÍÝ§@|Arb)x‡Ò
×NqMÊ¿YìâK³3;´dR¹ßð9ƒé¢¶e¶|êMíé>µ`VXâØeÍüƒÆJ·¨@øÔ|þ}X‹>ÃŽ9x¥-…¸òò¨üxb´Sºøòk‡ÎH8Œê×‚AØGùìrö½¶Çr¼T­dCKÄÒp:è3‚ýÃU9 +:îŒÆŒÏ„ð²x@¯ßŠß?Y–#_‰7é‘îÏ5à"ÐSÂÔòr>Ãc*ÃÎðŸ
GVe3ââ©><µ*wxJÔsÅŽÓ8;ÂÝ/Q_Pb{4üTUØXª¯êXàË™°“íÿš’ÙN³7°>˜´ëö3gøò±Ì‰àÇ(—~Šå÷0©B’/×Oîý2 øþÇ{ l H‘jÕÆÑê]yò°V÷lY„€ºy&Ô;‡ìCêyâ·Ÿ‹*ÍÞX9©~ªb¨sç«ò·ëÑZ -ò@ï¡Z¢ç°~ùÂâEÙÉæj±q+.i}EÕá™äG>¾—1ãO¼Ø¼E; ¾Ê²êHuõ%“Âg±6ÿ·SåÓVk÷åiìˆåc>¨÷í8àsÇ¿£)«ÚºNÂ‹¡‚ªbqÛv«y•4rné.^ðåî,K[Pž¯X\{/ÜÑèËq¢7ßìu»Öï`*Dp>°F®<¶Ü¤VK(ôË+õððÑŠ³÷Q»YÐ.ú¶ŠR1rÊï `F7¤.Ù%Mh‘Dçd&}b¨Ÿjì)Úx¬lò2Þ™Fïñ9Ù­jHºrÚ‰º¼bi¤h1Ê¨N¾Í¤»÷ÖÄ-@^BBµç,pãó–ÕI<NìøÊIRîâçòáõr%ÎeöXpæGa  09†nÆ‘ûL3 j‹‘9†±„ª~€«lL~ùÂâEÙÉæj±q+.i„.ÕKAVóaÖŽO}Ø¹ Ô','$Remarks','$amount','$vno','$date_',".$_SESSION['userID'].",".$_SESSION['labid'].")";
		//$cur= odbc_exec( $conn, $query );  
		//$cur=updateBalance($conn,$expID);
			
		$temp_name=$_FILES["fileToUpload"]["tmp_name"];
		$imageFileType = pathinfo($temp_name,PATHINFO_EXTENSION);
		$picname=$vno."_".basename($_FILES["fileToUpload"]["name"]);
		$target_file = "uploadData/".$vno."_". basename($_FILES["fileToUpload"]["name"]);
		if(move_uploaded_file($temp_name, $target_file)){
				
				$oldImg=getName($conn,"select path_ from recovery where vno='$vno'");
				if ($oldImg!="") unlink("uploadData/$oldImg");
				
				$query="update recovery set path_='$picname' where vno='$vno'";
				$cur= odbc_exec( $conn, $query );
		}
			
		//echo "<script>window.open('recovery','_self')</script>";
	}	
}

$contacts=$expID= "";$Remarks= "";	$amount= "";$vno= "";$Department= "";$anyvalue= "";	$Remarks= "";	
$Status=0; $vno=""; $Balance="";$Salary=0;
//$date_ =  date('Y-m-d',time());	



if (isset($_GET['vno'])) {
	$vno = $_GET['vno'];
	$query = "select * from recovery where vno='$vno'";
	//echo $query;
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {        
	   $from=$date_= date("Y-m-d", strtotime(odbc_result( $cur, 'date_' )));
	   $expID= odbc_result( $cur, 'expID' );  		
	   $Remarks= odbc_result($cur,'Remarks');  		
	   $amount= round(odbc_result( $cur, 'amount' ));  
	   $vno= odbc_result( $cur,'vno');
	   $paymentType= odbc_result( $cur,'paymentType');
	   $contacts= odbc_result( $cur,'contacts');
	}  
}

?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta content="width=device-width, initial-scale=1.0" name="viewport">

  <title>HOME</title>
  <meta content="" name="Remarks">
  <meta content="" name="keywords">

  <!-- Favicons -->
  <link href="<?php echo $_SESSION['icon']; ?>" rel="icon">
  <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">

  <!-- Google Fonts -->
  <link href="https://fonts.gstatic.com" rel="preconnect">
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Nunito:300,300i,400,400i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">

  <!-- Vendor CSS Files -->
  <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
  <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <link href="assets/vendor/quill/quill.snow.css" rel="stylesheet">
  <link href="assets/vendor/quill/quill.bubble.css" rel="stylesheet">
  <link href="assets/vendor/remixicon/remixicon.css" rel="stylesheet">
  <link href="assets/vendor/simple-datatables/style.css" rel="stylesheet">

  <!-- Template Main CSS File -->
  <link href="assets/css/style.css" rel="stylesheet">

  <!-- =======================================================
  * Template Name: NiceAdmin - v2.3.1
  * Template URL: https://bootstrapmade.com/nice-admin-bootstrap-admin-html-template/
  * Author: BootstrapMade.com
  * License: https://bootstrapmade.com/license/
  ======================================================== -->
</head>
<body onload='w3_close();'>

  <!-- ======= Header ======= -->
  <?php include_once("header.php");	 ?>

  <!-- ======= Sidebar ======= -->
  <?php include_once("sidebar.php");	 ?>

  <main id="main" class="main">

    <div class="pagetitle">
      <nav>
        <ol class="breadcrumb">
          <li class="breadcrumb-item"><a href="index">Home</a></li>
          <li class="breadcrumb-item active">recovery</li>
        </ol>
      </nav>
    </div><!-- End Page Title -->

    <section class="section">
      <div class="row">
        <div class="col-lg-12">

          <div class="card">
            <div class="card-body mt-3">


<?php 

echo  "<form action='recoveryInstitute' method='post'>";    
echo  "<table class='table table-sm table-striped'><tr><input type='hidden' value='$anyvalue' name='anyvalue' placeholder='Keyword'><td>From<td><input type='date' value='$from' name='from'></td><td>To<td><input maxlength='10' type='date' value='$to' name='to'><td align='center'colspan=2><input type='submit' name='btnShow' value='Show'>";
echo "<input type='hidden' value='$programID' name='programID' >";
echo "<input type='hidden' value='$sectionID' name='sectionID' >";
echo "<td><input type='submit' name='btnPrint' value='Print'>";
//echo "<td><input type='submit' name='btnPrintCombined' value='Income_Expenses'>";
?>

<!-- 					  <td>Programm<td>
					  <select id="programID"  name='programID' >
						<option value=''></option>
						<?php	
						echo fillCMB($conn,$programID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='className' order by order_");
						?>
					  </select>
						<td>
					  <select id="sectionID"  name='sectionID' >
						<option value=''></option>
						<?php	
						echo fillCMB($conn,$sectionID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='sectionName' order by headName");
						?>
					  </select>
-->

<?php
//echo "<td><input type='submit' name='btnRecoveryClass' value='Class-Recovery'>";
echo  "</table></form>";    


?>

              
            </div>
          </div>

        </div>

        <div class="col-lg-12">

          <div class="card">
            <div class="card-body mt-3">

<?php 
$query= "select date_,stdID,Amount,feeID,paymentType,Remarks,paymentDate,discount from studentPayments where  stdID in (select ID from student where labid='".$_SESSION['labid']."') and paymentDate  between '$from' and '$to' and Remarks like'%$anyvalue%' order by paymentDate asc";
//echo $query;
	
$cur= odbc_exec( $conn, $query );  
$cnt=1;$total=0;
		while( odbc_fetch_row( $cur ) ) {  
			if ($cnt==1) echo  "<br><table class='table table-sm table-striped' ><tr><th>#<th>Date<th>Student<th>Class<th>Fee<th>Amount<th>Disc<th>Balance<th>Type";  
		   //$date_= date("d.m.y", strtotime(odbc_result( $cur, 'paymentDate' )));
		   $date_=getAfghaniDate($conn,odbc_result($cur,'paymentDate'));
		   //$expID= odbc_result( $cur, 'expID' );  		
		   $Remarks= odbc_result( $cur, 'Remarks' );  		
		   $total+=(odbc_result( $cur, 'amount' ));
		   //$vno= odbc_result( $cur,'vno');
		   //$path_= odbc_result( $cur,'path_');
		   echo  "<tr><td>$cnt<td>$date_";
		   $arr=getName($conn,"select stdName,programID,balance from student where ID=".odbc_result( $cur,'stdID'));
		   echo "<td>".$arr[1];
		   
		   
		   echo "<td>".getHead($conn,$arr[2]);
		   echo "<td>".getHead($conn,odbc_result( $cur,'feeID'));
		   echo "<td><a href='addFee?stdID=".odbc_result( $cur,'stdID')."' target='_blank'>".round(odbc_result( $cur, 'amount'))."</a>";;
		   echo "<td>".(odbc_result( $cur,'discount'));
		   echo "<td>".($arr[3]);
		   echo "<td>".getName($conn,"select stdName from student where ID=".odbc_result( $cur,'paymentType'));
		   //echo "<td>$amount<td align='center'><a href='recoveryInstitute?vno=$vno'><i class='bx bxs-edit'></i></a>" ;
		   //cho "<td align='center'><a onClick=\"javascript:return confirm('are you sure you want to delete this?');\" href='recoveryInstitute?delvno=$vno'><i class='bx bxs-trash'></i></a>" ;
		   //echo "<td align='center'><a href='Reports/expensePrint?vno=$vno' target='_blank'><i class='bx bxs-printer'></i></a>" ;
		   //echo "<td align='center'><a  onClick=\"javascript:return confirm('are you sure you want to delete this?');\" href='sale.php?delitemid=$itemid&invno=$saleno'><span class='glyphicon glyphicon-remove'></span></a>";			
			$cnt+=1;
		}  
	if ($cnt==1) {
		echo "No Record Found";
	}else{
		echo "<tr><td align='center' colspan=4><th>Total<th>$total<td><td>" ;
	}
	echo  "</table>";


?>
            </div>
          </div>

        </div>
      </div>
    </section>

  </main><!-- End #main -->

  <!-- ======= Footer ======= -->
  <?php include_once("footer.php");	 ?>


  <!-- Vendor JS Files -->
  <script src="assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/chart.js/chart.min.js"></script>
  <script src="assets/vendor/echarts/echarts.min.js"></script>
  <script src="assets/vendor/quill/quill.min.js"></script>
  <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>

</body>

</html>