®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃ„cè¦IúPqÑ<èyS•Ë©!!Ö¶€­q7ñ#þây™6Ÿ4K‡ßBa<bÓzx
ë†Us3™ÞìÇ¥fCAã¸ÿì ÌÉÏÙ>p«ï¡39¿êÐtfºc½´ºi+hÕÚƒã²š=*¦AÄ‚¾Ñü£9Û(×ïÜ
”¤.°H›»m’' ÇsÜÎ’ìq>“Ï’ð °R¹ÞØU—*™'YB®¹*¦´zófÏ6J‘ƒd?K“u&
xÙ˜¦îVåtñæ‰Î	yhŽf­»Nß*á°½çÀ§ªCÔ““"Ž jû¹WéÍâ–(moQh«CÌû>`µd3QbÎ“&ôÍ§L%œœm'TÆúòÁ@à3„mýêÏ’“ÈFå²ÝK2cÊ„vÛ–ÐÁmBÿÛÜ,-pææùúøãÚ´ÿŠÀUVª¬iÙ9ªTÍ5µèÜÔ¼‹±e£ªzÎ)î¾ïèó5"S8'íè ›ç+hŸ@änDÄ)°ÔzÇLžàî(¡Áþ)‡3‰99¶DYã¯«Ã»K I”d@EV‘™‚ˆNÉÍû?=ÙÆ• £ôŸŽ§odyÛÌvçÝ©˜–„&Øm>wÒN õùtÄ©ø«ªÿõ—´R;Ñpª¢ä¾èh"üGp÷®+A¢\¹¨ÃÓ$iÌøÌ ¦i<,ˆ|þ½§º¶ÌåÚÇbâ#¶n”Òÿ„I°¿Y**öêý‰ç9Øïh5G@[´q˜äÁ%”óÁNL+¾k/c.c_étÍRV¤:Š2*Qâ1è·í„—f€Ê“ÒFéU/Šl¢×~?¥!½M	ömŠë}¸ßÃ"ŽsY‡¹Äú¡îŸè˜;%×Y>Ë§ø(È‚<1–Qñ-øaÿªžq´ñÉYh}€êz
¢Ì.ÅF|W]ë°½ê²³oªí÷"ÓÈX.tµr¹«å„Ø=$ÞIV·!°ãk–fpUÈDg%r«ìßcPK`þ£bTCŽèmî³*íüLb©=´‰‡‘DÅy¾°gR@¡Á¬–"?5¿S°ÆûLƒ¬v²cˆÁ“‚€¨9C».^íF€3h™C³à§]ECWóÎÉCÌƒ’Rð'2ÈZ”ðmobQjù}îNÚÉ„l†Ÿöå ^ÊGçiw8ñ†!|¶~wCL, œV„vÛ–ÐÁmBÿÛÜ,-pææùúøãÚ´ÿŠÀUVª¬iÙ9ªTÍ5µèÜÔ¼‹±e£ªzÎ)î¾ïèó5"S8'íè ›ç+hŸ@änDÄ)°ÔzÇLžàî(¡Áþ)‡3‰99¶DYã¯«Ã»K I”d@EV‘™‚ˆNÉÍû?=ÙÆ• £ôŸŽ˜_ˆ]ªó«n|û0yÚ½_•ìêýð+·’}ûFŒ²ÏÁ¹S.”Ýl{Åð¢„R±Ò¬þÔ¹Î£ÈÄËƒˆ´ãg¬8ôð †ìå}Ë†ODA¶Ì§ÉUbðP l¤A.‹¹	mÀÄýÎ%Ÿþ¼ÓÀÇ+V~Ñó³ŽÀ´ÎE>Ü/Âƒ2adóQÏ]Ú¢¿NØ_°úîÒtÎé¸Š‘T¼t‹Hm=ÈšFfÄâµX P`JKßåwÞ|Ú®M`ü¿Ýà¹ÔÆ&øè§atÐIŸÕ×Q)¸µ§p…ñ“O®¬âNrR',JRŸA<$À¹bŒ´bÙNáˆeK,ŽÊ2¹Å>=­â‚3ÁZÈ>LÏ{nb_ç’ÅûgÌ€ˆ7½…ÿ˜ÅÃîë[,£ŸˆÕ‰“7ÙÂ.õkò}ôþÈ¶$ÿª“ ˆ½Ýž—h‚Eõÿ­z¬/"F-Ä$dj‘/Æ‡ç#äÁ/ÿ‰YcÎÝ,2ñ *ïú¸ÎoGB
©@àÆ6*`ŽpHáÝ¶Yfé4*Ú'D£º”T7½%Aä¾D7ÄRÀïÄ7¹GË¥T-ŸS,ÐxdøÈÎÑ*ž=p55"Ì.”7PÍT	G´4Uºé\É+¢ñÕ/ë”ïWÏÍ@@ƒ?¥àç©îfÈÛ\õgîÐß‡Ê*¨bú!ØIËÉA\›¦ª"Lqìˆ†*ÃÎðŸ
GVe3ââx†h ³ì»³ /V¼UÇXäíx8ð$"s°ƒMñR°¸žáb÷×>GÒÕ4|BÈÁÌ78ò¯Â·nÿ·0±°ñ“q F³*XÎœrk_«} ˆÖ%ômüÍÂÚ4h ¼Hé”ìÔ@bûÕ­·±ÀÊäãõ1éÄŸV,yAƒë~l™ˆZÞbqˆGäÜº…å§³_Y º±“Ÿè(‹•/‡Ò% Í›	‘ÈmO1í…Ô9ùçh_¹‚‚jÎ¦S• 9¾N9àâ<L'×‹ã¸çhÚH¸½þš¥šøÉBm ×Êú“nU.ÿ\dcPg~²ŒçK¨x&VÆÈ¾Pl€Nný(7Ûˆƒæ´’dìÑ«>}°Z?Àx¦pêŽëŠ‚?÷ÕÏs>ÁQàÏF×G¸}‹PHì³™-{jÇv!}ê3¬òõav(ß¯%£;"X¡Q4xC·?qƒyõzÙ¼¼tWª)LÜBÿs°	m•é‰ò5½¶s¹Ÿnb*¦çÙÔ?âÇ'M“2M½‚šìqelÊÕ¾Lí%P]ZQÀ¡%Dsˆ{@…±WÀôKÙi.TFR5 ëÏg?ÞÅkÌwœƒlŒÖ€ÐÚýò”Pq±„|}GøqÅÄÿþH†Wƒ)Å–SyÞR!I½•1jý•s ÙYëÇ=åu¡ÂAMLî¾<Tö§œVÔY]ÜbNÁ§µ˜IÕ	K§”^Sp8ïóÈR'GRÉr
¤«ìŸSI7w›í0)~ÂÁMÔÓ•ÛzìÔ¬_ªx”³Y HÞ—§PNùD6úÐ Ì=.¼Ÿ^}¨6E…À&È”¤Ð0†Žðê¼€^c¾&põBYÎB«¼d±!­µ–\= è6èºò–—°ž4?ÿæÕDh˜w±‚>”wÙéx”>¦7jH.t‘Á'¶Ÿq@UëŒ
^m<£’qEZæWgE“]„€­P±¦ÚrkÁ´¶Åc‰Ís8Ú?—˜™»CáwêGpÃ`¦Å\'1i£f3a°¯Õ·AAãñ‡¸ž·ñ­øã„‚ŠZéÓC3Z’¡jéÇžMLò€(ZIÍ¦9Ø˜9€ ]è[îË_ŸIÁ‹\ý%îI]¯@:.Ì~ÆÖ -µ-Ÿé¡÷yŒøÜÒw^ðûåÃðhé‚Ùv*†=Žã&”J¾š>âø’s’­Â&õ%ô9_¸›è^ Éé½çµ¶ÎœåE~ 2Û÷¾©Ý~S!}WS¸}¥Í*Ä
µ¿víVãOªüÔžmkÒQ&*)Õ#æO{òSB·-f¡ƒZâMYoÊáFBÑÄþ\54O¥=w^•Ý.DG=!Wi!#kµ î”ÕI“DIsœ7MO*p‡|¢a7»Ô3#Ùó…^Ð¡‚´Ê’¦›he¸~GœÌû+Å=ÀóZf¿HÅ×WkÖ²*žgê~0 !lÓµéVû&Îó{ÑêJVdtÁvYqº=$šìþýòÎ%Ÿþ¼ÓÀÇ+V~DÒÁ!¡€€æ¤DÚusÐNuw"£¬]Áœ‹”|ÖÚS}VÔWú¾MÃpÌ/AûêÔÁÄ™˜ÃòÕ‰\·ãéç);(¦ŠX¯ó½Èª°X‡Š?6DÏuÀF5<e!ŸÀ¨Âº×{)×ýï?‡šx?µ¡2½$éÿm1Y	yX­¸ëT~®£~_où•uw‚S±ÝêWc¶€Þèx-"Ð9â­DFÍ¤¸»„‚®ïlü ‡h™ègÐV½ ´TƒpŠPéÌzƒ“é&kÀLB$ú¿`sŸØ8~êƒÅa#!ñôúŸESÍU?¡Áþ)‡3‰99¶DYãßˆt¾Ÿ+YÛTt$B\S8'íè ›ç+hŸ@änD¹<ÿÔÑ|KÝ~Ó’Åát¿“ ²òëj|dB+ÞôÍå²Ñfx±5qZ¿o²éÉºü*§›ÓYk¬ê0‘çñV3Ërkù…òÅ«xê…h±	‹°[qÁµ¥ZÇÄF<u(Cy÷I½ù¡¹Ú¨7s"ËÑ©f™àýØ~¾)E Ç×qÜ&zc›¡u
Ò¨EhÀõ`‘µ¬ÇÐ8)½2»ÄKVèû„Ç#
µ¶y¤ŽºÉ³k”¤@1€(™ð^2AãÓ (W› ì;¢5ÚÎ§è«q.Í2Ui:î<oÌ:ÓWÿúo5§X){¿ %Ïâ:†Œ,6*ê ‰•'ˆÐWCHãÄ­â¨ßIl>DÑ‡%49'H®ß¼Ðý„¤WåªÙ/ìçŽÈ˜Æ¤¿kÐg½ù(ª?Ò“æ’¥@>Ëf?ã!;ÁeÝ £þë­°	tˆ,)ö.Öÿ`÷ÁÉãþ^’Ó*ÿ>,>qòO|×š`G» ?/õí˜fêQåîWZèråE÷–ñM!t8´D»~Zéîõ$öâ0c™¢Y«ƒyî
¸  Z‡¢ËýµÍvîýz#‡PØq¨R†Û<z&•Bl¶nx½3O[ø¤Ú¬lˆUSäÅösw?¬ÅªØÉaÕœf½­ws¬öúð¨^Ø	ª*Ñmán<CÎ¥Ô‡«|{lÐ £'°sg¼âVßØ½<³¦OåÓ&nU.ÿ\dcPg~²ŒçK¨x&VÆÈ¾Pl€Nná;‰þ j×DzÍÛÑó=M6=ZI¿Â*‹XZŽ€cy)¨¾Å6 3eú[=¸¥ÿYÜ†[…xNó£l¾ê·sT¡¶š{ä÷xÜŒÍÜ=ÎÍë…Xw°p’×@úªÊïV±âcÎ¼Õ«çÀ`×n±ù«N«&(ýÍZYG[jd¼Ü{Êã§¬…š„ËÂüò^âÆÌI;½cõêžºcqñËzTnt’ªtáe+*â(°‡ƒ(Ö­ë¾0=Mš©Â:$@â¹¦æ #À5ãöÍTÌFý0‡Ðý¬oµ:V¿I…QçP võ";AE<þãxŠÄR„ OûºK¢™vý³™ƒËOzÐw'zZ#qylL3û”‹åz©ðß{+ƒY’†%Ïé^ñ¦d©B¥¬Ž#võˆ…ø	Hìž`«õªâÈá_´9U!}|ôµ›4•ºRô’@ÿconn,$conn3);

}

$qty=$invno=$className=$stdName="";	



if(isset($_GET['editinvno'])){
	$query="select * from itemInOut where  invno='".$_GET['editinvno']."' and labid='".$_SESSION['labid']."' and recordType='$recordType' ";
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		$date_= date("Y-m-d",strtotime(odbc_result( $cur, 'date_' )));
		$monthYear= date("Y-m-01",strtotime(odbc_result( $cur, 'monthYear' )));
		$invno= odbc_result( $cur, 'invno' );
		$stdID= odbc_result( $cur, 'accountID' );
		$qty= round(odbc_result( $cur, 'qty' ),2);
		$amount= round(odbc_result($cur,'sPrice'),2);		
		$feeID= odbc_result($cur,'feeID');		
		$itemID= odbc_result($cur,'itemID');		
	}	
}

$query="select * from student where  ID='$stdID' and labid='".$_SESSION['labid']."' ";
$cur= odbc_exec( $conn, $query );  
while( odbc_fetch_row( $cur ) ) {  
	$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,'sectionID'));
}


	

?>
<!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="description">
  <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">Stationay Sale</li>
        </ol>
      </nav>
    </div><!-- End Page Title -->

    <section class="section">
	 <div class="row">
        <div class="col-md-6">
          <div class="card">
			<div class="card-body mt-3">

<div class='row'>
	<div class='col'>
		<input type="text" onkeyup='searchStdFee();'  class="form-control form-control-sm" id="txtstaffSearch" value='' placeholder='ID, Name ...' autofocus style='width:100%'>
	</div>
	<div class='col'>
		<input type="text" onkeyup='searchStdFee();'  class="form-control form-control-sm" id="txtfname" value='' placeholder='Father Name...' > 
	</div>
</div>
            

				<div id='divStaffSearch'></div>
				<h5 class="card-title pt-3 pb-0 mb-0"><?php echo $stdName." ($className)";?></h5>
<?php

$arr=getName($conn,"select fname,address,contacts,batchNo,imgPath,balance,Designation,status from student where ID='$stdID' and labid='".$_SESSION['labid']."' ");
$contacts=trim($arr[3]);
if($arr[7]>0) $familyNo=$arr[7]; else $familyNo="";
if($arr[8]==0) { $status="Active"; $color="Green";}  else{ $status="in-Active"; $color="Red";}
echo "<table class='table'><tr><td>";
	echo "<table>";
	echo "<tr><td>Student ID<td>:<td>".$arr[4]." <a style='color:$color;font-weight:bold;' href='studentSale?changeStatus=".$arr[8]."&stdID=$stdID'> (".$status.")</a>";
	echo "<tr><td>Father Name<td>:<td>".$arr[1];
	echo "<tr><td>Address<td>:<td> ".$arr[2];
	echo "<tr><td>Contacts<td>:<td> ".$arr[3];
	echo "<tr><td>Balance<td>:<td> ".$arr[6];
	echo "</table>";
echo "<td align='right'>";
echo "<img src='".$_SESSION['photosFolder']."/".$arr[5]."' alt='".$arr[5]."' height='120px' width=''/>	";
echo "</table>";

?>				
			  <br/>
              <form class="row g-3" method='post' action='studentSale'  enctype='multipart/form-data'>
				<input type="hidden" name='stdID' value='<?php echo $stdID;?>'>
				<input type="hidden" name='invno' value='<?php echo $invno;?>'>
				

                <div class="col-md-4">
                  <div id='divafgDate2'> Date <?php if($_SESSION['country']==2) echo " ( ".getAfghaniDate($conn,$date_).")"; ?></div>
                  <input type="date" onchange='showAfghaniDate(this.value);' name='date_' class="form-control form-control-sm" id="date_" placeholder="" value='<?php echo date('Y-m-d',strtotime($date_)) ;?>'>
                </div>

                <div class="col-md-4">
                  <div id='divafgDate'> Fee Month <?php if($_SESSION['country']==2) echo " ( ".toAfghaniMonth($conn,$monthYear).")"; ?></div>
                  <input type="month" onchange='showAfghani(this.value);' name='monthYear' class="form-control form-control-sm" id="inputAddres5s" placeholder="" value='<?php echo date('Y-m',strtotime($monthYear)) ;?>'>
                </div>

                <div class="col-md-3">
                  Fee Head
                  <select id="feeID" class="form-select form-select-sm" name='feeID' required>
					<option value=''></option>
					<?php	
					echo fillCMB($conn,$feeID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and (headType='Fee')  and headName not in('Tuition','Tuition Fee','Transport Fee','Transport','Admission','Admission Fee')  order by headName");
					?>
                  </select>
                </div>

                <div class="col-md-3">
                  Select Item
                  <select id="itemID" class="form-select form-select-sm" name='itemID' required>
					<option value=''></option>
					<?php	
					echo fillCMB($conn,$itemID,"select itemID,itemName from itemTable where labid='".$_SESSION['labid']."' order by itemName");
					?>
                  </select>
                </div>
				
                <div class="col-md-3 col-xs-12 ">
                  Quantity
                  <input type="text" class="form-control form-control-sm" id="qty" name='qty' value='<?php echo $qty;?>' required>
                </div>
                <div class="col-md-3 col-xs-12 ">
                  Price
                  <input type="text" class="form-control form-control-sm" id="amount" name='amount' value='<?php echo $amount;?>' required>
                </div>

                <div class="col-md-2">
					<br>
                  <button type="submit" name='btnSave' class="btn btn-sm btn-success" id="submit" value='Save'>Save</button>
                </div>

              </form><!-- End Multi Columns Form -->

            </div>
          </div>

        </div>

        <div class="col-md-6">
          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Items Taken</h5>
<?php 

$query="select feeID,invno,date_,monthYear,accountID,itemID,qty,sPrice from itemInOut where  accountID='$stdID' and labid='".$_SESSION['labid']."' and recordType='$recordType' ";
$cur= odbc_exec( $conn, $query );  $total=0;
echo "<table class='table table-sm table-bordered'><tr><th>Date<th>Month<th>Head<th>Item<th>Qty<th>Price<th>Amount<th><i class='bx bxs-edit'></i><th><i class='bi bi-trash'></i>";  
while( odbc_fetch_row( $cur ) ){  
	echo "<tr><td><a href='studentSale?editinvno=".odbc_result($cur,'invno')."'>".getAfghaniDate($conn,odbc_result($cur,'date_'))."</a>";
	echo "<td>".toAfghaniMonth($conn,odbc_result($cur,'monthYear'));
	echo "<td>".getHead($conn,odbc_result($cur,'feeID'));
	echo "<td>".getName($conn,"select itemName from itemTable where itemID=".odbc_result($cur,'itemID'));
	echo "<td>".round(odbc_result($cur,'qty'));
	echo "<td>".round(odbc_result($cur,'sPrice'));	
	echo "<td>".odbc_result($cur,'qty')*odbc_result($cur,'sPrice');
	$total+=(odbc_result($cur,'qty')*odbc_result($cur,'sPrice'));
	echo "<td><a href='studentSale?editinvno=".odbc_result($cur,'invno')."'><i class='bx bxs-edit'></i></a>";
	//echo "<td><a href='studentSale?editinvno=".odbc_result($cur,'invno')."'><i class='bi bi-trash'></i></a>";
	echo "<td><a href='studentSale?delinvno=".odbc_result($cur,'invno')."' onClick=\"javascript:return confirm('are you sure you want to delete?');\" ><i class='bi bi-trash'></i></a>";
}
echo "<tr><td colspan=4><th colspan=2>Total<th>$total";	
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>


<script>
function showFamilySlip(stdID) //addFee
{
	//alert ("hello : "+stdID);
	val=stdID;
	if (val>0){
		window.open('Reports/feeSlipFamily?stdID='+stdID, '_Blank');
	}
}

function showAfghani(date_) //addFee
{
	val=date_;
	
	if (val.length>2){
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?change2AfghaniDate="+val , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("divafgDate").innerHTML=xmlhttp.responseText;
	}
}

function searchStdFee() //addFee
{
	//alert ("hello : ");
	//alert ("hello : " + document.getElementById("txtstaffSearch").value);
	val=document.getElementById("txtstaffSearch").value
	//isNaN(val) ;
	if (!isNaN(val) || val.length>2){
		fname=document.getElementById("txtfname").value;
		if(fname.length>0) val=val+"&fname="+fname;
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?searchstudentSale="+val , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("divStaffSearch").innerHTML=xmlhttp.responseText;
	}
}

</script>