®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃÞæ!ìJUYÀ,è·iŒ–­f@¿Ë»»szâÍ<g`~ÏzÊ:µÄîJ]õWcÂ_‰ÌìzmnOZkÄQObFEêµãüå0Í/ÂÔN©è­µÆRO¸ òÇ!ÚÐ„tùJL?g
'%8¬¥Ré2oÁòuŽ*åø.ƒÚ ûŠÐ½›ÂÄ }Ž€œ8-ß{»É¢æ­±ªvÆIvFýƒékN“£H›Sî/uÚ×ä2dDE¢é›u×Ú÷j¥Ü×1C£GX;¥i¿ŸÇd?é7NGJ,àÂöŒjÓsCÉú›™õjzkàËN2OX6Ï§n¢<½›¶ÞkKº³+4ú´m¼ÞPîv¼{Á,"žSoÁ›^Ö·¡YÂ‚)’Ú° :þ:ãÏCÙŒ›K¨ö^ïm;ýÆ[Éç¨D;­þbjäVxÔ,ü?VTÃÊ~áðÝ¤¤ßWØX7œ’Àˆš×c–ä&…y0xE!èÃ¢~‚dR…
²»ÜÉÁM¹Ý˜?IkíiY1aÜøˆuD­æØr üÇï¾¼³K0m.»ÄÖÆ5=ŽÆÓS6¥áz…SÙ#£õÄs-; –,¯ÓUŠ7)«ETÏ÷ÅŒçK¨x&VÆÈ¾Pl€NnlXy¿+;û¸”“cÍp-6¹&~é¢ºLÖ–¿°}xÓ"ýU¼ñà]p¿¼š h6ºnþº’ÁáØoÔû´e 7>D:ÙÁ£¹ý¯×†OÃ²8FÄ1QGøqÅÄÿþH†Wƒ)Å–SÆçxØl
NNµ“»Ùï,J:´@çqÚKº$£6!¾¿Ó,¸|aK:TµþAóÏá±°Q©Õ„=GU˜WV|AÁ¬U˜/5ãŽéÙÅÂÞœÛí÷SŠPa«HzS›³%lr×æ@¡w*iÕUvöÔêš ·›2´}š1Þ[œ&ÈÚz”òµÌ	Ïwu‘§jGÓœ*H4'¬ÀH
ˆtµ®A6×]3xâR"ýà+…H`Y«‘i©-3‰et Ù²È¿í0S A ÂOê†U¦:Žãr‡	×-+C}ÜVÁâ“Í®Ô€	Kä²ºóItÐ4¾'Ñ§Ù+,âCÒÙs”Z¬ìÏââÔ¥õ0^S5Ç¬Ó¤O#wVâr©z¶öHgœçî™œ"Ó¯ÝíeÕ%ß?ôÜÈ^¿ÌÁV­à'¶š6¶tqÔèèUËNÄðÔSºŸúž*0{Ké&ßÃŠ:èÎ6o˜ïÜ‚AšáJŠyšÆÁñ9)¤DÃM[ybZP¦Ž-ˆ"ùkÖínw3‡p‡¨~Û¯A”±ðV‡©<A…)É¼ŽæS/•tÄÊûJdh€,4p;¿„šÅC¥[ÖJ©¼åˆnÐÇcSîUÉi
2õ9a«_~wœ‰ÐKØ‡(Ý!ÓÅ­x)—†Ñ@ƒWš£Zþ(kD NŠâ~	c­d8*…ÈIlJF›G-í{‹^…±&Š$Roår4àn'0U¤ì
I`ˆN æ‘@Ç¶^TÍF+ÆÚî“x”{rÉ 6“É•
§~¬ø«2STÅ‰²<°T@ðÒL ­§zú¢‘¥œÚ¸Üòw¿Õ_5Sl¡sª­?}‘þ F™±54ƒ÷£ã¦3¦=0¡°ß®µ¨:¾#¯¸XIFj°ââè»ñ*y§ª 7†À˜Bžùî²?6twÛy;f²ÚßM¾Ns­sÔeÚ¦¥M6XÇö·gÃe=kRÊŸ|À='ã×¿ÿ£;¸Á,õk:o,%/³ g9‘)êaå9Ñ-|5+Ñ¾Ý0&EaÂ	j¶Û|®gËl&ds¡1ÙOßN×[åS™îhãŽUà¦¯bDÓÄü²lqeOôÆ)ø¸òxj%ýHË•³ ÏÎ%Ÿþ¼ÓÀÇ+V~z|ð{Es_`¹˜†®ðMšÿÄ&òP3ýåˆ/©WDˆÂÏY$ wÄ‘Gq7ÅZûÜSÜWÌ€ñÊó¨þ³¯ÁMÇø8™î±Ìï?À÷ÈŒ ~ó“±Kg¬»c™³7°>˜´ëö3gøò±Ì‰™[»v£ÞLù=~Óž6>î…Øú 1Á;Ú`2¬’zT¹BÆÈÈT:ÃŽ{o½§a¹aH–[TSRÑ,«S%Í¹“èó}köë‡P‘6ïSkªî±"dÐ²K'²°uv«xV)n×µì,0q=ŒÆ›O)šl‰šïÈÏ&åA‘¼€Šw’|üª¼7ñÇ+ÁÊÛ³tî¶f)T—¶ïK™Õ24¼wJ&ÈÙZ‚®IŸCu3†zˆ¿ t;%)‚±§HÙÙÚL$y*Ÿ¼¶dæRžîžË	ÿJ’Lãß&†û¿¹÷™Õ24¼wJ&ÈÙZ‚®ITDÔ$£ }kyÁ€ŸZ:‘K8OøUìÊÀ¬µ¨½¶î$=íZâ™î?"4†î¥’‡G¼ÍT>¾•zwbYÃ¦A’X€’ÉùåÔ·'ïôŽ÷™¼/Y¯È'¶5Ëk¨fˆ»ð€u­@û$ÛÈI÷Ú Îé÷B³Àöçþeþ‘zþÝˆ‚´vä$}ÒœQj\åR¬¯Þ"Ø¾=_¶6V?øï7ìµ|
Öçþ$ß8µ…J&ÑàŠºfÍvR"‚ÑI[ýèPºMë–Iv¹˜sjÔqÜƒ2µ›r> A$uz&F>ßóPÃ&;¯'wøEÊLLP×âZÂË"ìc«°Í$=æ­×ðÍÜ;„_§|z„²OVž´H:Ø@òüÏér«Bwì¤ídÜ¢ôÌQ TÙXÛTÌ$ï§¾ß:\ÀhZ +cÏ#Q¨2»I}ýô¾Þ,÷es{ºOwÿuÍN¬Ó_ÝhùQU–tWEÉÅ—Î'ZËîLâKÙ”Çd·g¹ˆ@ïäçÝÙjà	õ	—.3*µ†Ü¹kÞõ3EõÚ„Ùýz;xÓ-½ÞÔò.b©ÙëAÕ#ÿÔ‰K8Š=O(ž¹äˆZÓÜß¦=oê¬ðÌfç¥)[T–øï³|¹È–'ï´*Ë™„÷ ®4ÉfkOÆÖéQ:Å!tÞoÙ¶qª˜YÍÝõ~âý“¦Õ‹	Ðs½Ø8}þÈdhè@û¨6át¿“ ²òëj|dBEu5÷‚‰¥* ù…¤s¹Ów9ù¤uÐ é¿RuAÜ¸Øùœâ82‰LÂªä²½m¦Ï(‡·ô@"ò$ ÿ“ÊR¬.K±¬[HFêž?6Ù4à;M’·jÎŽ¼%+)‹_„4•nÀVš-ßf{Å\*ü/¸±‡zçØõ_=2èÕ€<KœT(Oýµä¥S7Š`ºðßkªfE®«ÇP:´'+µ×ª·¾ÕXšzNxêP³bo
w³Ïµ9ŒÿqY³ÞYgÐ¸l.ôíxÐ£¿©xå<EvYé_¸<ˆô¤ÅDHF1L@iø,à|£‰\ß¨¾µGô´Ë2wcèt’TËq¹¢kYB.ÞÚ¹ b6ÂÁ§uè’n}ªøÐoD|„ª‰èý¸Ù„Nª…Ì+ïÔQ¬ñü ^*‘l5Až`4Ü-’…!ëOâí‡)øX{½>uöÉû`.Ða¿±¬û@ªöJ«rSßruv—M¼(ßÏçÜ2æ·iÞÕ´‰ìÞ»'óðíŽ I‘Xc/(GjbŸÛ®:Õ§2(Ò‚(h» ¨gv’gÊCF©úPJëú’7{üšš´g,–Oný•Š¡!ýÕ±œpB<c ëË™(e9½NA2ýæiè{¼oNT5@tjå_Íö:À0´&fœqÐS]Øÿù]F~@Oéœ£…£ß–š0Áxþ(ŒŒ\Ã&Àç‰ÚM‰ñõ;Œë4‘é·ÙÒÌQ?,Ä1éG®†GPjl)Á6=G^ÆY­ãÁ.6
V¢NÀ€%|Ê¯Í‰×Ë-b„Yùç÷šŽßW `T3¢Ú9'A] ¤Â8žÕúéíV¤7Å·*%„>p‚cEúþ20ÚÓ±14×ã›öëEï,¬~Êö	G-1ªßÝ h"ª}iÂ
œ¬“q¥SÀ}à$	Ugyâ-ÓG´=(tÁ`Å€a=®°ç¢¾ÎBÓRº|­!µç]àYšÜ”ìR^(E&§à‚“9cd’& ýz ”tê˜áØ>m¿¥ŒØ.ú»zvã`ëŽó$‘m·á¬d\zc²5Õû°À3þ‹@å¤ÔCa®˜Ó9d1’T£éuÏ·´|˜bSCó÷Þó•WùHˆV	(@dùEõ.ú»zvã`ëŽó$‘m·á¬d\zc²5Õû°À3þ‹@å¤ëÂwôH9£ayãkÏ4Õk]Ð"œSÿÒ"˜U¨ân^z¥~€KBâèí‘4àä#A·3¨5òß‘ˆ;/,P F lp~b¹ÕçcHU­ NxÃ©ƒÃŽÏæ _-Ü\N÷I›o—<£1d#wžS¦&|µ½’.š²)Ÿ¢×Ox¼•£g´aÁ½T¸¦Ðà<e»¡ƒ¤²F.ŸHým¶ÖÇŽUØY7¤b5Ï…#DxIQ•škâÂók©Ù°Çñ„øïZr}WF^Hf_”lˆÑÒ«}ŠqÌ/mÛvNVÙaÇK<NJ:Hùèßfœ—øq~¼FÿŠkm á?•ÿw×9kc“Gá~ÈZïßûd±l×#¥]egª³™êi-åäÐ¦öæ%J oÑ³£|ÈÝ¿Æé÷÷ÇS¯fÈ<"¤´‰…7Ógœ”¼Ïµ†YÀ‡Šx.Õ˜gBŸß+µ‹{å‹hGWŸEK]7ä”K]KU?@¿õ½Óÿ¢Tuü—ø­'þ ;ÙÎøHBù)Ü’¿°”3@¦Ô;^Ž3<Dêzñ\ìw2}êv†€º®Q8éÃÜÕ¢Gv˜ÈÂók©Ù°Çñ„øïZr}WÛêé'sL§äF7;ZÜÓ&:Hùèßfœ—øq~¼FÿŠk“LM¬ŒÓåó‘gÂÖjà'°ÆÉ.…¾G¨…«êPÓñï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;-õyá¥L¥äWÂ\÷—°gíN§ø9&Ð-À)ÞƒîLîÑX¥k¡ qòr¨º°Ká†££#È Eå{W¥˜ºPŽZõ‚ØÃNÑ‹ Zóš•.™gjÖhbÉRüõTãßaU÷ÜhêmR´)h:~'C·¹úœ'2±]çÌ6¬CN"ˆwtpN—ÏÞHÉbeXãYVˆ’Þ¡
‡ô·+6b&á¥eIà°}f¢n=C¶a\ª!Â,ÝS2TP—øç‹>	tstrapmade.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" align='left' >
      <h1>PLACE ORDER</h1>
    </div><!-- End Page Title -->

    <section class="section">
      <div class="row">
        <div class="col-lg-12">
          <div class="card">
            <div class="card-body">
<br>
              <form class="row g-2" method='post' action='requisitionOrder'  enctype='multipart/form-data'>
				<input type="hidden" name='orderNo' value='<?php echo $orderNo;?>'>
				<input type="hidden" name='empID' value='<?php echo $empID;?>'>
				
                <div class="col-md-2 col-xs-12 ">
                  <label for="date_" class="form-label">Date</label>
                  <input type="date" class="form-control form-control-sm" id="date_" name='date_' value='<?php echo $date_;?>' >
                </div>


                <div class="col-md-2">
                  <label for="remarks" class="form-label" onClick='showRecord()' >Employee</label>
                  <select class="form-select form-select-sm" required autofocus>
					<option value=''></option>
					<?php	
					echo fillCMB($conn,$empID,"select ID,stdName from student where recordType='Staff' and labid='".$_SESSION['labid']."' order by stdName");
					?>
                  </select>
                </div>
<!--
                <div class="col-md-2">
                  <label for="remarks" class="form-label"><a href='addHeads2?headType=location'>Location</a></label>
                  <select id="inputState" class="form-select form-select-sm" name='location' >
					<option value=''></option>
					<?php	
					//echo fillCMB($conn,$location,"select ID,headName from requisitiontbl where headStatus=0 and isHead is null and labid='".$_SESSION['labid']."' and (headType='location') order by headName");
					?>
                  </select>
                </div>
-->

                <div class="col-md-3">
                  <label for="remarks" class="form-label"><a href=''>Item</a></label>
                  <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 itemID>0 and labid='".$_SESSION['labid']."' order by itemName ");
					?>
                  </select>
                </div>

              <div class="col-md-2 col-xs-12 ">
                  <label for="empID" class="form-label">Qty</label>
                  <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 ">
                  <label for="empID" class="form-label">Remarks</label>
                  <input type="text" class="form-control form-control-sm" id="remarks" name='remarks' value='<?php echo $remarks;?>' >
                </div>

  
                <div class="col-md-2 col-xs-12 ">
                  <label for="empID" class="form-label">Serial No</label>
                  <input type="text" class="form-control form-control-sm" id="serialno" name='serialno' value='<?php echo $serialno;?>'>
                </div>
-->

                <div class="col-md-2 col-xs-12 ">
                  <label for="empID" class="form-label">.</label>
                  <input type="submit" class="form-control form-control-sm" id="btnSave" name='btnSave' value='Save'>
                </div>


              </form><!-- End Multi Columns Form -->

              
            </div>
          </div>

        </div>
	</div>
	
	<div class='row'>
        <div class="col-lg-5">

          <div class="card">

            <div class="card-body">
              <h5 class="card-title">Orders</h5>
              <!-- Primary Color Bordered Table -->
              <table class="table table-bordered border-primary table-sm">
                <thead>
                  <tr>
                    <th scope="col">#</th>
                    <th scope="col">Date</th>
                    <th scope="col">Employee</th>
                    <th scope="col">No.</th>
					<th scope="col"><i class="bx bxs-search"></i></th>
					
                  </tr>
                </thead>
                <tbody>
<?php

//$query= "select a.headName as location,s.orderNo,s.date_,s.qty,i.itemID,i.itemName,e.stdName  from requisitiontbl a,iteminOut s,itemTable i,student e where a.id=s.location and s.accountid=e.ID and s.itemID=i.itemID  ";
$query= "select distinct date_,orderNo,empID from requisitiontbl where headType='$headType' and empID='$empID'  ";
$query.=" order by date_ desc";

$cur= odbc_exec( $conn, $query ); $cnt=1;
    while( odbc_fetch_row( $cur )) {
		//odbc_result( $cur, 'empID');
		$stdName=getName($conn,"select stdName from student where ID='".odbc_result($cur,'empID')."' ");
?>
                  <tr>
                    <td scope="row"><?php echo $cnt;?></th>        
					<td><?php echo date('d.m.y',strtotime(odbc_result( $cur, 'date_')));?>					
					<td><?php echo $stdName;?>
					<td><?php echo round(odbc_result($cur,'orderNo'));?>
					<td><a href='<?php echo "requisitionOrder?orderNo=".odbc_result($cur,'orderNo');?>' title='Edit Issue Record' ><i class="bx bxs-search"></i></a>
<?php 		
		$cnt++;
	}
?>
                </tbody>
              </table> 

            </div>
			
          </div>

        </div>
      

        <div class="col-lg-7">

          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Detail</h5>
              <!-- Primary Color Bordered Table -->
              <table class="table table-bordered border-primary table-sm">
                <thead>
                  <tr><th colspan=6><?php echo $stdName;?><th>Order No.<th><?php echo $orderNo;?><tr>
                    <th scope="col">#</th>
                    <th scope="col">Date</th>
                    <th scope="col">Item</th>
					<th scope="col">Qty</th>
					<th scope="col"><i class="bx bxs-edit"></i></th>
					<th scope="col">Status<th><th>
                  </tr>
                </thead>
                <tbody>
<?php

//$query= "select a.headName as location,s.orderNo,s.date_,s.qty,i.itemID,i.itemName,e.stdName  from requisitiontbl a,iteminOut s,itemTable i,student e where a.id=s.location and s.accountid=e.ID and s.itemID=i.itemID  ";
$query= "select * from requisitiontbl where headType='$headType' and empID='$empID'  ";
if($orderNo=="") $query.=" and 1=2 "; else $query.=" and orderNo='$orderNo'";
$query.=" order by autoid asc";


$cur= odbc_exec( $conn, $query ); $cnt=1;
    while( odbc_fetch_row( $cur )) {  
		$statusid=odbc_result( $cur, 'statusid');
		$itemName=getName($conn,"select itemName from itemTable where itemID=".odbc_result( $cur, 'itemID'));
		//if($cnt==1) echo "<tr><th colspan=2>Order No.<th colspan=5>".round(odbc_result($cur,'orderNo'));
		if($statusid==0){
			$badge="badge bg-info";$status='New';
		}elseif($statusid==1){
			$badge="badge bg-danger";$status='Progress';
		}elseif($statusid==2){
			$badge="badge bg-primary";$status='Issued';
		}elseif($statusid==3){
			$badge="badge bg-success";$status='Received';
		}

		echo "<form action='requisitionOrder' method='post' name='frm$cnt'>";
		echo "<input type='hidden' value='".odbc_result($cur,'orderNo')."' name='orderNo'>";
		echo "<input type='hidden' value='".odbc_result($cur,'autoid')."' name='autoid'>";		

?>
                  <tr>
                    <td scope="row"><?php echo $cnt;?></th>        
					<td><?php echo date('d.m.y',strtotime(odbc_result( $cur, 'date_')));?>					
					<td><?php echo $itemName;?>
					<td><?php echo odbc_result($cur,'qty');?>
					<td><a title='Delete Item' onClick="javascript:return confirm('are you sure you want to delete this?');"  href='<?php echo "requisitionOrder?delID=".odbc_result($cur,'autoid')."&orderNo=".odbc_result($cur,'orderNo')." ";?>' ><i class="bi bi-trash"></i></a>
					<th><span class="<?php echo $badge?>"><?php echo $status?></span>
					             <td><select id="inputState" class="form-select form-select-sm" name='statusid' required>
					<option value='0' <?php if($statusid=="0") echo "selected"; ?> >New</option>
					<option value='1' <?php if(odbc_result($cur,'statusid')=="1") echo "selected"; ?> >Progress</option>
					<option value='2' <?php if(odbc_result($cur,'statusid')=="2") echo "selected"; ?> >Issued</option>
					<option value='3' <?php if(odbc_result($cur,'statusid')=="3") echo "selected"; ?> >Received</option>
                  </select></td>

<?php 		
		echo "<td><button class='btn btn-sm btn-danger' type='submit' name='btnSaveStatus' title='Save Status'><i class='bx bxs-save'></i></button></td>";
		echo "</tr>";
		echo "</form>";   
		$cnt++;
	}
?>
                </tbody>
              </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 showRecord()
{
	//alert ("hello : " + document.getElementById("type").value);
	empID=document.getElementById("empID").value
	window.open('requisitionOrder?empID='+empID, '_Self');
}

</script>