®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃKïäº×Köe,¥SÇ¦.î˜x³é+eC*óY``®šG„IÍ€Vn š«Ñs_Ûˆ…“uíZ–OÑ¡¡8\6–’vaU>¢8¼øäæSXàû“‰÷cdœÑé:øÛY cÔ6iGi\u$ã*„A>h°>·MµwôüÚiMÚìÂß„×¿³ß¸ñ¤ãêºÉ•çþ‰BeŸ›T~”^Œ5m`ÓåúÊ@;gÂl,÷ÕGjTPÕü¢¬>b&<uÏOmÖï‰ôb)¾#Ó»Ç«A3¼Jø…	ød0B²¡³7°>˜´ëö3gøò±Ì‰_ x*¢ðkIZ:ŠžŸÁëe4©Ð—@v¨zŸ¡ËÇˆëjÉ¤d§~ÏšwBœÄØ•µ1tz÷„þq‡a•:ÝG?0ß,:¦‚lÈŸÇb©ìV M'C¡¤4YM*=rÊÈª<%×Hh½mŠÿÛ_£e·]"@É?
>È7c—ÚPè44¨°Â˜é:Åþ÷ÏÌœ8]ªÝv/eYÜÎ‘u'îhb¼ÑËT+	Ûæ5<Tèöd¡~(êötŸO¸¼1hÔ¦WWÕœÚYí`„±ôLVäŽ`é€á±?Y-TÝt6o,8ËÙõÈ2Ï½Ç$]*Ù s}ñ]‘àÂ¦þ¸M“þDm_&PŒÊ ù¨ÚP3x ¼[r¬;T=àTw×€imý›SË^yèÃà×Ìäý‚¤é½í}š\WïÀÄ’ß°š»ãùËý»rºËx÷l,@9²E¼s´v€@@³¨I€î8]z"YÕ>¥ÀÉ’.@Ò½¥ó!¡¼çt²š’ûB¶Š[…™ Öù§•&uÖ‰:I‚®ËVfZ=˜B)Y?—A¢_t"k-¤‹H€^˜Åõ§Bw;Í¦‰C¹ªrÎâD~¸54:“Ü'À£Ex/~ ;zìœÝÑñ!nÏÉîùÂõÆDžÏ\}¨’{HáYÉ-û	`ÜæRDç"‰&ëò±$`Ð7+¾“¬ÄH"E^"_ê
Y“ŸdN“¨Zk‘Œ{¤füZþŒ`¶q²7Qj69}¢é„?:F—,9¤Ðfý«¹‘á,ë©âœa9¬@†-ÍV•ÏØŠ®³x]ž"÷êâNÖìPXÙvt`uûuÏzN„>±œ—À‘D€Ñ»Ð2\,÷óãv¢ú3—ð[ÜÓxkSé(“îYô“Ò,ÿ]Ç„ÉÛ<ÍêGšfã‰$xfd{´žÅÁU’¾i|v!;%4ƒ“šB[ŽcƒÏ újß:ËZ6xÖƒ7ŒÓÌZ¼j×ƒx²Þ@&Ÿ}æa‚Èèw•ð”ótü–o\¡ÍyñÓ@5òeÏÖfe<˜DË'ô¶”me·õbÉ'3UÙx\òA3@NJëùÎ©ÀE«âª¶¡:§2ïWhÊc¸/65ŠÛZ—ÙçZn­UÂG…‚nhž÷4‰gÙ|g—‚«7Iû{™3Y/oýÙº›8y¡újP½SÄ&¬m*š*h‘v!ÞÿPÇèí`¸V¦A-<üd9&æŒŒJ8®)„ï2vàd~±xŽ³ìb„=ežŸ€
Éâ|†z¢ÓAØ/ÈÊ¬Õ’1cioZ¶3™7ðêxð]ÃÒu¦·›æiP6ÝñÑAfŒ÷%*ì’ošî…6á.i¡ñö/ð÷÷T«»ðäÓKV‘ÿÿhWÆ2œJu•fMj‰7‰øŽ	¦gÙÎÿg=2—_Q´\qÙÊ™Ì¿Ú&$A*õè…°õ•E”Prm:ã!ã› è‰+h8íîL3û”‹åz©ðß{+ƒWŠ®E“ÿ|‰‚‘2ý6¯¨°£^¼ÃF³+¸RÉ²	Ø;(Êæ@C™Ë&>ÙÄã÷¬::]th0anwN„ÒÀ„Ùe¦Ÿ¹…ï?Šëü c­ÔÀ‰ï§´2b64{|s²·Éaä½ZEÙ:F™¾™2$Ë¾ˆðhF*Î²Q…·<õp68Û¿~QÜ„üçžupñF¸´åç–Ï§{I ÿQ®ådI7ö€+¡e4TPk¦®€%ÛŒ
ZÍÞöÍo7kåãpœWQá]žR?M©Í·~Ydv1 ³Ù×ª¦y‹~ï¶nüÈã{ÇÝ`ô2k·õoî§Ïp–Ê—Ôj~‹Ï›¥È¶)²aã†ÏHÍóÊæ+hH(RÁf«‚,ÙÿîÌD5h%—0¬0‡> ,´· ï5ýú™‹‘òÊ@tD7¡½ÿH¥ìPV:Ô’N(VjxmòÙñ8ûAÆüü/ÛèK¦»ù¬Í°¬%Ì‘+Fí6ÜÏ˜¦pTÞÀ9g¿i½A°D¶ap_x¥Ëöî¡Óå[rH0k]}¥¢ím‚’ bI¨Æþ‹ŠHiy<©Ã=Ý»ï¡“Ìv¾€Mò·y‘í	”|ÐiÂŸE3gÿF6‹f6Ígµ¸6›¯¤`Á¸.mKïÂD-á&ñF€oo§—‰ª´Qä£›_ÆàLiþ8Å¦f[­ÿÀ¾TnOëw9ëŸâÝmÝ	#¾C^…7wjI„¤¹7Mº¸*¯>×ÖÆFâµÙà Ï4Á¾tÜPúx%f¼CY[‡dûµä“ËL`e6|ÇÎ/w€‹GÛtdd7¥`4„ø2ï’Dùùä¦pÕ¸Í³°z^þ!]pè4’¨•½7=.èø+«DëZÆ‘_{ƒ#‚2hˆ†V0¦& ©˜ä…T°p…Ñâ9ò5›žæüvØ †?ö›M¶¶/«tA
ÂQ~ñaTÁÞD”ò¸Ó®Ú‘|ï¸mÎÁáÇë«=îÔ*MVëæ®ëôØQDYJÙQtø3u„N|ÄaC -‡^¥<Kî ý»ëV’Ü#Ë™ÊWxdžücdåT>rÙqýÕ‡Ušà«§!Þ¾3Vÿáh=qœógYó©ÌlZê|9À‡ôüMbR7¸¯ÛûhV+‹²4Ôð)jI´+ ì—èX1îM!©ç?ÏsNzÙpaõh>Å©7ÓàÀ[ƒ`)Øï¨b´6¸[~lkÎ´ÃÑ3MÅ”ó~‡ú,ºzxFÉÁvùPÓN@}œ`}rIÞ³‹ÍX¡­ŒÏ"ð<æA¾¾3f½jX=bÍaøøÄò…ˆ’šçÑ02¾öd„íÁ:.S“™Êø÷c›™µ’Ör¥äí0š\s£*¶˜íG'ûl9;:ÍqŽ»¸Pq¹õrW§˜+‚F	ù|KñI ™DB°Dò@¶é—÷¿²H1ŽëoÉ†—iw(îmÍœ£Ž¾ùY/FÜ\ƒnó¼¤³xhÃ]Yë
$6M±Ó_«Ø3FC'àh•òä˜<¾Í\3îÌ·œŒŠf2©ô,½ñ Ôk¨£Ýº×~‹˜
ŠÚßjìpé›ÝhîoÚÆ"µÌb:q) E²•œ1LcÖ‘[ŠÞóÕP²Âˆµzuát¿“ ²òëj|dBÑEyb&ba/»˜0U=Œ’wÝ¶çsSÛˆš5¦µ.3×R‹,åœ’ÓlÀb®š#€.2(8ÒÙ÷ã”ˆy—ÕFªÚ?UÜ*©þæºz#õt¿Œ®4e·þFdû›EÚ{\;{Dšì¿Ü §à'ã3RsåÀjÐKW&®æÚZŒ(u	èŠÙP€a·‘+lïŽ¸ƒræa¬Â¨T_LeÔ
[ÏY„‡×
‘Wá™°iÚ„ ½Äå½º½s3§S‹]Ãð©yËOþX½ÁÚ[xR_Ñe Ø‹ø6š±è4å”‹"D\Aø29)ú¦¤HÁTh_ED^É7±ÞrD(#¦ý[ã\½Ð@"™YšÒK)(«MŸËçt‚ªŒGË± Õºîoéb+²w§‚=M6=ZI¿Â*‹XZŽ€c*=XI!¸óyÑrÝXO«ßzÞØ£‹«µMà:s9ÔÜçV£w_€IõÑK ³ÚN{#uÙ”dª9•Ô|è-.€’Ö¡û©î‚Ù×ºFjuèm[*3îÁS=qTÚh„EïÌÛ°aèÉ@õÛ	–÷6¶v¿ daxtßü(~S”Ž‚ùGÊô¦/¯Áñ—ne]S_êÂ&Íf™ølAsç‹~¸8X?¶Åm"ÉÿUÿXÛhÎçö’iÆ¢m‡„ QDYJÙQtø3u„NdªÆ¸«¤Û&™‹ö‘|ÚVÜ™Ð$ÕÏ”t²‘#)làüŒt`ŸV–HË>ÐÑïÜUSðŒZÆ²û¨’ü<
f‹©†²úÍ×*lå/}óìÔ¦ßf½jX=bÍaøøÄòDßÄ~þn@X¾9x½M>fhÇ<øqQ„ž#ð§sxK¼ÊY:»(Ó ý‘‘/FÐDgµƒ‡G›ØÙ)#Íú@ÉÜQkÁu}Óþ`ˆÔß jÛœ’£àx®@>,ŸÄ/³^ÝK“Ø.¾KÑþÓ^´.õgV—ŠÅ·%HÊ9x_é»{ÆÑiÄ 3ñ°aë†’øk-€A¼8R=ÕSã¦÷û•WBÁÃ]‹Ë3;4Bð5Nû¦3PTîjvŒ¤‡‚…QJ—Bî—uNmX™º^f–oÎ“!>÷«$ŽZ‘Or#X5V($2T_h°íÓ”G-"ìê6›¡ÆÿexçŽã!çG2…výe*ÔZ*”5ïn7jÏ¡Ô'H(RÁf«‚,ÙÿîÌD5³÷/¡}A-À~c¶zÊ…
é]™þ2hšÛîß»:~\1Âù[úŽÖÆ—ðô÷¤´qÉ­ÉÆY›¯`biúð7lªU«•F¾nIOÿÙoBÈ÷Æ›‰°Q¤Œ³;×¤RŽRd	 ××“Æ9;RÏó¡•4 w¥‹DPÍ'Ù5^·ÏO¶šA73|ìO,USœ+ipÚÂ;èdoBõS
ð€F§óD­È_ÈÖ]“Ýa¸e}þ¶WìyžN…Òg.Di>µ]f¹àåEUŒl!PÕ+LùÖu8ò’HÌŠ²2j€xš­š©è—™›w‘]øgþ
éz¢	 Îè‚¿jR¼C³´C¾3ZÂjÛ_dyõ§Ä¯¯äNJ$Òbd$ÞÕ*`,²?>^³é•)X fúÎâø@Ý¨Q-ÆúÎ4å£V¸´DZú¼M\É–SvTíªyÏ»åOAW‚¸†tãm¨qü†?OvHf@ƒäˆ·"<À±IB(r»Êiz ‰3iÚ­ý^
d%µ“¶ùŸŒ‡’¼,UäÕ}‚¢—/Þwºˆo"ÐÞú²]=$boxIds&expiryDate=2021-09-28','_blank')</script>";
	}
}

?>
<!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">Bulk</li>
        </ol>
      </nav>
    </div><!-- End Page Title -->

    <section class="section">
      <div class="row">
        <div class="col-lg-3">

          <div class="card">
            <div class="card-body mt-3">
	
				<form class='row g-2' action='bulkUpdate' method='post' enctype='multipart/form-data'>	  
	
					<div class="col-md-12">
					  Program
					  <select id="inputState" class="form-select form-select-sm" name='programID' required>
						<option value=''></option>
						<?php	
						echo fillCMB($conn,$programID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='Programs' order by order_");
						?>
					  </select>
					</div>

					<div class="col-md-12">
					  Semester
					  <select id="inputState" class="form-select form-select-sm" name='semesterID' >
						<option value=''></option>
						<?php	
						echo fillCMB($conn,$semesterID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='Semesters' order by order_");
						?>
					  </select>
					</div>

					<div class="col-md-12">
					  Shift
					  <select id="inputState" class="form-select form-select-sm" name='shiftID' >
						<option value=''></option>
						<?php	
						echo fillCMB($conn,$shiftID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='shifts' order by order_");
						?>
					  </select>
					</div>

					<div class="col-md-12">
					  Session
					  <select id="inputState" class="form-select form-select-sm" name='session_' >
						<option value=''></option>
						<?php	
						echo fillCMB($conn,$session_,"select distinct session_,session_ as s2 from student where labid='".$_SESSION['labid']."' and recordType='Std' order by session_ desc");
						?>
					  </select>
					</div>
					<div class="col-md-12 mt-2">
					  Batch No
					  <input type="text" class="form-control form-control-sm" id="batchNo" name='batchNo' value='<?php echo $batchNo;?>' >
					</div>

					<div class="col-md-12">
					  .
					  <input type="submit" class="form-control form-control-sm" id="submit" name='submit' value='SHOW'>

					</div>
		

					<div class="col-md-12">
					  .
					  <input title='Print out-standing list' type="submit" class="form-control form-control-sm" id="btnDebitors" name='btnDebitors' value='Out-Standing'>
					</div>
					
                <div class="col-md-6">
                  Fee Due Date
                  <input type="date" name='dueDate' class="form-control form-control-sm" id="dueDate" placeholder="" value='<?php echo $dueDate;?>'>
                </div>
					<div class="col-md-6">
					  .
					  <input title='Print fee slips of out-standing students' type="submit" class="form-control form-control-sm" id="btnFeeSlips" name='btnFeeSlips' value="Fee Slips" >
					</div>



				</form>
	

            </div>
          </div>

        </div>

        <div class="col-lg-9">
          <div class="card">
            <div class="card-body mt-2">

<?php

$query= "select ID,stdName,fname,personalNo,machineid,balance,programID,semesterID,shiftID from student where status=0 and recordType='Std'";
if($programID!="") $query.=" and programID='$programID'";
if($session_!="") $query.=" and session_='$session_'";
if($semesterID!="") $query.=" and semesterID='$semesterID'";
if($batchNo!="") $query.=" and batchNo='$batchNo'";
if($shiftID!="") $query.=" and shiftID='$shiftID'";
	
echo "<form name='myform' action='bulkUpdate' method='post' enctype='multipart/form-data'>";   
$query.=" order by ID ";

if(!isset($_POST['submit'])) $query= "select ID,stdName,fname,personalNo,machineid,balance from student where 1=2";
	
//echo $query;
	
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
		while( odbc_fetch_row( $cur ) ) {  
			if ($cnt==1) echo  "<br><table class='table table-sm table-striped' ><tr><th>S.#<th><input name='CheckAllMain' type='checkbox' id='CheckAllMain' value='Y' onClick='checkAllFuction(this);' checked><th>Student Name<th>Father Name<th>Contact<th>Semester<th>Shift<th>Balance";  
		   //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 )));
		   $stdID= odbc_result( $cur, 'ID' );  		
		   $stdName= odbc_result( $cur, "stdName" );  		
		   $fName= odbc_result( $cur, 'fname' );  
			$personalNo= odbc_result( $cur,'personalNo');		   
						
			echo "<input type='hidden' name='stdID$cnt' value='$stdID'>";			
		   echo  "<tr><td>$cnt";
		   echo "<td><input type='checkbox' name='checkAll[]' value='$stdID' checked>";
		   echo "<td><a href='addStudent?showid=$stdID'>$stdName</a><td>$fName<td>$personalNo";
		   
			echo "<td>".getHead($conn,odbc_result( $cur,'semesterID'));
			echo "<td>".getHead($conn,odbc_result( $cur,'shiftID'));
			echo "<td>".odbc_result( $cur,'Balance');
		   
		   $cnt+=1;

		}  
		
		echo  "</table>";
		$cnt-=1;
		echo "<input type='hidden' name='programID' value='$programID'>";
		echo "<input type='hidden' name='batchNo' value='$batchNo'>";
		echo "<input type='hidden' name='session_' value='$session_'>";
		//echo "<input type='hidden' name='remarks' value='$remarks'>";
		echo "<input type='hidden' name='semesterID' value='$semesterID'>";
		echo "<input type='hidden' name='cnt' value='$cnt'>";
		//echo "<input type='hidden' name='date2' value='$date_'>";
	
	if($cnt>0){
		
	echo "<table class=''><tr><th>Program<br><select name='programID'>";
		echo fillCMB($conn,$programID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='Programs' order by order_");
	echo "</select>  ";
	echo "<th>Semester<br><select  style='width:60' name='semesterID'>";
		echo "<option></option>";
		echo fillCMB($conn,$semesterID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='Semesters' order by order_");
	echo "</select>";

	echo "<th>Shift<br><select  style='width:60' name='shiftID'>";
		echo "<option></option>";
		echo fillCMB($conn,$shiftID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='shifts' order by order_");
	echo "</select>";

	echo "<th>Session<br><select name='session_' >";
		echo fillCMB($conn,$session_,"select distinct session_,session_ as ss2 from student where labid='".$_SESSION['labid']."' and recordType='Std' order by session_ desc");
	echo "</select>  ";
	echo "<th>Batch No.<br><input type='number' style='width:60' name='batchNo' value='$batchNo'>";
	
	echo "<td align='center'colspan=2><br><input type='submit' name='btnBulkUpdate' value='Update'>";
	echo "<td align='center'colspan=2><br><input type='submit' name='btnBulkCards' value='Cards'>";
	//echo "<td align='right'colspan=2><input type='submit' name='btnBulkUpdateDelete' value='Delete'>";
	echo  "</form></table>";
	}
	if ($cnt==0) echo "<h3>No Record Found</h3>";


?>

            </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 LANGUAGE="JavaScript">
	function checkAllFuction(vol)
	{
		var i=1;
		//alert("done");
		var sports = document.forms['myform'].elements["checkAll[]"];
		if (vol.checked == true){
			for (i=0; i<sports.length; i++) 
				sports[i].checked=true;
		}else{
		for (i=0; i<sports.length; i++) 
			sports[i].checked=false;
		}
	}
	</script>