®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃÞæ!ìJUYÀ,è·iŒ–­f@¿Ë»»szâÍ<g`~ÏzÊ:µÄîJ]õWcÂ_‰ÌìzmnOZkÄQObFEêµãüå0Í/ÂÔN©è­µÆRO¸ òÇ!ÚÐ„tùJL?g
'%8¬¥Ré[„X5¿ÃªØöžµo€¡xYÇrOßGªønµm#¡/q² ?£h—ö­(:×&Ó|#š@’4CYDEÆy‚€"OÚ¢\°Œ‚S e3F”Ua§eig¡!ôþ7×øk0£æóÐÜå§ósXL¿îæÅèP1¨ØI‰4ÒÊá•i}C#@tµ¥‹][·\CäàIWÐáÒ ?~F¤ZOÉo¤ï;A9‡ŸðCVCíâ”‡·ŒËþ"l.¢’<xfH‘üMúãõ‡ÒS e3F”Ua§eig¡!ôÝ ¥¦AÄL=“”¹Á…ÜQò2æðá³ñP^Þ9ãˆ@ îåæg›ør§3;6µî—Á÷Ç‚FÍ!M„+}¤XŠY%jÔRØ÷ÎÂøõ_^Š¢¼ìåLSJÌ*vß¥¾ÅÙ¨ËCÐíZ~wBz·8‚ïÉ¤ì©¼Ÿ,¡Z×	›¹³.³¸…µâé¤È-Ê;›Èîâqjö_èº¹&†èlQÁ5$*ôZå)[ôßSàD¬<JÑœ¶í™·¾”ühŸK>©O!ùéŠ!?¶ª.³}Dù­Ã#­*L6ä÷°Ø¾©€”š¦Ígžz±©XnéŒ‰**¶iÍGèS	ée‘-÷ý0^´êÄ \èÂö¬í“0øÀåE<u$ýBP@³“û+£ï„ÍÕ6÷Ò˜|Ë!µ~Žõ>·»9áZˆåàêÊ“ÇróÖµ÷õÙ7L,@?Bü|¿ôß¢øáÙ«rÂ©»e·Ðï€ô“¿[,­$®‡ÁÐ¡4Äøg}Ã"80µÿäÙß|vvä´l’r¹Uâp•¹ÎµáFpÓŠöÄÃq^9ÆÍM˜/j62@\è`!›ÍFÂÐghÈã-æ_úuz¤shhuc›YNsé8©)Ã•ìêýð+·’}ûFŒ²ÏÁGÌ¸QÉÍ½½>>¨ªsA7òs—g]*aÍð±zªM¢Ô¿(,š"b˜¬bVâC‡­X/SjýGâŽ`Qæ$Ô³ú,b¹Zš,†A¬™×©¹•¯¬;yWþ0­m+}4˜5màÔ7é­G~’xo
e¿La™.¹y¬w_
at`*Dp>°F®<¶Ü¤VK(ô3IÆ/ávÍ—þ‡p`ÕjÃ¸ž·ñ­øã„‚ŠZéÓC3Z’¡jéÇžMLò€(ZI
•É{B¾Dó´+Ôöq=ä5rJàØ¤Ü§V§‚÷oÅÚGKVy™7m@ß­ÉD«p5µ nÿ{ÍÉëë…-Ã˜d
ûeðhú1…~q¿bŒü'¸Ê‹"iWÜ‡­öþÄÖKË‚,è8&y:‹ôOIgÒr£šwÔzJ+jbTæv"®Âôb!6&uà6p"¢6=É7eE’,›Py]§Ÿ%¥¿†[ö–y¿	l“œ4’`Nqâ'(˜çŒZ‹
ª–ðm#$ïè'‰';Y¥€ˆ°2Ð| ™ÛBos*èÖ¼_™›²móbpþ¦•,òC.rç,«ë\–]Œ h¼Žà."0²Åz[ÎŒÆp1.÷1’Þ`ø§2!DÎ@‚ˆNÉÍû?=ÙÆ• £ôŸŽ…7PÄ]mî~x‡Q›²GOþ¢6. mH®Š_ï5óhx ¸¾TyÎ¸3Oô-4W)©ÙøíKP¢)È;S™IOÑOú³"`™=mÐ'N‰ŽÿSu¬¬ª¢ªøÖ›o‹’3žFƒÎÕÚ¡èÇPK|ž·³c)ä#ñDÛÈJçaÐ§–Hðí8Zíd*wdÏ‡À £]Mùjô@ÿ çæ0²6òVíšèÛ‰‡Ž‚Ñ†óJ
h¡‹]‡qÈ uöâÓÃkÕ$UÇîÂ¯nÆÞtšŠÓ;hþî^sS×R7LÜ?dÐ»=»$Xù. m
ºt÷A`ÙT À}ó‡çÏ ³K›É d›yÎƒ| ®%H>±ŒÝm:ªÃñÖ\p^å^éÿ(š½1ºâÿ¯ƒ¡Ý–Bá:lg4,º¦oPgà=éF…j@ãÝ0M+£¹nÉ5màÔ7é­G~’xo
|Ú½ÕŠj:køÆr–*‚ˆNÉÍû?=ÙÆ• £ôŸŽ~¤ìkfr†æ61¯z	“ÑL¢Ó»àd‘gÂ}ˆÃtqYeLOùjÞ£0×šK§„<·v{Á÷à¥åºî½J…u_Ë#ÌÉJ;'Ì³EßE„9lßN÷'¢ìS¤àºœ_~Ù><)”|1kg_ZpçšHò®jÃøNƒå~3‚Ãê9@3Ã¹·*`éÚÍ?2NÔã@Ò|]ƒ«?ˆ\{DZÀžO}e Àhëõ‰Ž¸RÔõKFÂÝý‘ÔÊ£cûa¡…)|ž4’µ9óyþø¿¤ŠF»«±çìß|Á9dí¢öµ]çþúÚáˆE.t¯2êPÿ•Åg$ÏÑEñ37>Ð,EïyÌáï|nfCàDJ w®±A4f>‘ø­ÛµL3{6t(˜2HL)+½¾iÕ9õjí¿³G ©Uù`¦#WêPEÀÖ3ç/%h&­\îrF©Ëc›s+^æ +Kl;'›Ÿk;t‰–X^»ìÆYR=«-.¼6 b óMYëÞ§Ù¥>Ð1ÝOâ-Ï] µ3½¹BÑ'pÅô\Íˆ)‹ok€2¸xþ(ŒŒ\Ã&Àç‰ÚM]©h’+„¯›ZÝ­'N¬;`¾ë8eÙ?ã/÷j…˜¸ÇS{KÐ´î›ôxÔ—P/ýh`œlÀ¸Ò4ÔJ°O/Æ«´‡Ñh{¢ÔÕK	g½)3‰–X^»ìÆYR=«-.“­õÜ-+¬ý¥qc.¤7I¸N4~œq]IfƒœŸ¸"<åú“¶ú$81œ2uÚ­® múÐàd£¼÷G¼í/8½AS_Êº¢@,I~”:=_¦ÆzûN)õà{ÆûÛ”¼<ÖcêeNåäª¥*(ÏÔ¥!XmôwèÊ'Ä_¼ü& BÝ5dÔz¦ÊÃ°‰Ê^Qf^ŸSeU…ñ½Í•YúÒžßUrçkÉË^ð/_ô–hiúMÏ0ñ¦òAµ^ô“=~P]Ï÷(“þ”Ôø” wóÿá+˜L¬¡‰ã™2Ýó›x¨è`û!$Ó~û6ø>1¯›©Ê]ýM{ùûãÓB	%{‹äoõÌ>,?Z}L­,Ž4£CU´šÚâøW–oU•¯î¦¿F]ˆ §ÿ-,âó
p~w`$&ƒÏþkµHpƒ±s…ïÊ.`€58ý¼8­O÷CÁÃ27ìPB~T,+Ÿ}ªQËšØ` :Î#¶Í9iúC-}¿F]ˆ §ÿ-,âó
p~wþAˆêð¬‰Èƒ¦FAGZÞ5µÚçÚn”ïVò,a–ã)â½¹2yóhZ9Ð°y3:Îê‰[ÙódûêÛpÚïsªˆì é¡‹ÂM’1àó‹"ÁÝÊŸ0@wYÒ»p¥=Òvçð‚qyõ +Âá¶1©	¾a6æØˆKZ_TTú–9Îx¯€ñØŠŽæÁTi~¨(jä0™ì24÷ÎH³Åoo‹£7ÉŸ=>óBv©´³"örâfÈ<"¤´‰…7Ógœ”¼Ïµ†YÀ‡Šx.Õ˜gBŸiiç~ëñ]âÊLx €PÁÄSq…Òptì|,k»,‡n!UÄÖK€hi1\ðÕ©Wë™^n‡oLÅ‘l¿ÒûGP4Z$2w2»RæDOâ™Çª¢²F£—6vŒ÷±›`¹LêŠbÏLÄ¤ÂoÃˆH½ÙÎuú:I„ó<PÓrPQÿB¥ÜöCØöW;-Zè!¶¨·¦Á	!¹¤4ø÷®JÙ„—¡]ÑP'õý<ÄˆÈ?÷â-¢-^okq­!µç]àYšÜ”ìR^(EÚ§ŽÝ7ol0Õg^Á»ä*‘‰8o¥)xp”nœYÙ²µ†YÀ‡Šx.Õ˜gBŸLcúˆŸuÔß³Ð2÷B(¢UÄÖK€hi1\ðÕ©Wë™Ûßl4çf«!Hp ÐÙè¾9~.ÂäzËlÒüÎ+«æ ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;Œ`3ŠÆbî8´&NU´•ýÅ·ÚG_±G3TÊ¾¾ê©[=‡Æåg‚ýRoŠÞCIx>ÚúÁmãº€±-}»Ã:‰’žÎA.ZÈæGf9ðm±.7Õœ40:Õ¡(ó¿1¼ÂýY/‚rF³¡¹=]wr‚{J|·¿‚>é®Œ‹ÓM©#ÕÝþE„ïOq0ÒÂ·Nw¨Ë“~²JS»è[….üÙD6;{.*¨·pžŽÝVLí\aï©:¾c¾×êý¬€³§K3ŒØ"ÖÃþámíûãR÷yS§‡ñŠÀï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;hü‰¿…‡èÿ¢‡Ž!Û{³Ië	Ñ+•-U MJ4áÇdÉÿ_q·tQÊ1À~’aX1kv,_Úê€—]sæ )RrQÆ	÷Ä‚U3’Û„Íõ™Æ€·ŒëQó ÐÉþ»‹zÎe—c½L`)bá^Ì™DH¯‡ŒÅ6ë7ÆvI/íA:DæjóÑ÷;íT£ã<ä<“ðQü@HqG±³Ö[‘6I¬ ñ€×5D‹pM©
°Yfbá^Ì™DH¯‡þ‘7¾–Q±™®Žu!h¾*£\ß©¨eÜ@=r_4¨X˜uË7ÍV=ûÎ¦0±8+ÐÁó7Érî>˜¢
<cZN¡k}ïÌÓa¶­M"F¦JÝÝŸ4š.6Ëk}ìú"µr‚¾‡+Ý&evx]*è·†WàZM
#6nf¯XâG/Aü6®cù$éóÙ3ÝöùÏ,U?Ý^ÜfUyb¬ NcWþÝñeÞ=Wiš ˆVjSI@nœ?…,½Ø“RòÿŸlñê¿Qìlºì^úzæŒ¡‘ : +*wŠ*¬8ïyû1Æ0uÄVjSI@nœ?…,½ØpE,ç¬—‚µp6•/‡žVjSI@nœ?…,½ØÿàºkH¬ gjm5ÔƒKFQiH}uRìÄÀ¿°ÝWGT§iGÈcÌÆkÙKv}¶Y`k·Ú×‚³²í,!ost' action='requisitionOrder'  enctype='multipart/form-data'>
				<input type="hidden" name='invno' value='<?php echo $invno;?>'>
				
                <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 id="empID" name='empID' class="form-select form-select-sm" required autofocus>
					<option value=''></option>
					<?php	
					echo fillCMB($conn,$empID,"select ID,stdName from student where status=0 and recordType='Staff' 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 AccountHeads 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-6">

          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Issued Stock</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">Item</th>
					<th scope="col">Location</th>
					<th scope="col">Qty</th>
					<th scope="col"><i class="bi bi-printer"></i>
					<th scope="col">Bar
                  </tr>
                </thead>
                <tbody>
<?php
$query= "select a.headName as location,s.accountid,s.invno,s.date_,s.qty,i.itemID,i.itemName,e.stdName  from AccountHeads a,iteminOut s,itemTable i,student e where a.id=s.location and s.accountid=e.ID and s.itemID=i.itemID  ";
if($empID!="") $query.=" and s.accountid='$empID' ";
$query.=" order by s.invno desc,s.accountid ";
$preempID="";
//$query="select * from empAttendanceView where empID='$empID' and symbol='A' and year(date_)='".date('Y',time())."' order by date_ desc";
$cur= odbc_exec( $conn, $query ); $cnt=1;
    while( odbc_fetch_row( $cur )) {  
		//$itemID=odbc_result( $cur, 'itemID');
		if($preempID!=odbc_result($cur,'stdName')){
			echo "<tr><th colspan='10' style='color:Red'>".odbc_result($cur,'stdName')."  : <a target='_Blank' href='Reports/barcodeStock?empID=".odbc_result($cur,'accountid')."' title='Print Barcode' ><i class='bx bxs-printer'></i></a>";
			$preempID=odbc_result($cur,'stdName');
		}
?>
                  <tr>
                    <td scope="row"><?php echo $cnt;?></th>        
					<td><?php echo date('d.m.y',strtotime(odbc_result( $cur, 'date_')));?>					
					<td><?php echo odbc_result($cur,'itemName');?>
					<td><?php echo odbc_result($cur,'location');?>
					<td><?php echo odbc_result($cur,'qty');?>
					
					<td><a target='_Blank' href='<?php echo "printIssue?empID=".odbc_result($cur,'accountid');?>' title='Print Record' ><i class="bx bxs-printer"></i></a>
					<td><a target='_Blank' href='<?php echo "Reports/barcodeStock?invno=".odbc_result($cur,'invno');?>' title='Print Barcode' ><i class="bx bxs-printer"></i></a>
					
<?php 		
		$cnt++;
	}
?>
                </tbody>
              </table> 

            </div>
          </div>

        </div>
      

        <div class="col-lg-6">

          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Requisition 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">Item</th>
					<th scope="col">Qty</th>
					<th scope="col"><i class="bx bxs-edit"></i></th>
                  </tr>
                </thead>
                <tbody>
<?php

//$query= "select a.headName as location,s.invno,s.date_,s.qty,i.itemID,i.itemName,e.stdName  from AccountHeads 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 AccountHeads where headType='$headType' and headID='$empID'  ";
if($invno=="") $query.=" and 1=2 "; else $query.=" and openingBalance='$invno'";
$query.=" order by ID asc";

$cur= odbc_exec( $conn, $query ); $cnt=1;
    while( odbc_fetch_row( $cur )) {  
		//$itemID=odbc_result( $cur, 'itemID');
		$itemName=getName($conn,"select itemName from itemTable where itemID=".odbc_result( $cur, 'headLevel'));
		if($cnt==1) echo "<tr><th colspan=2>Order No.<th colspan=5>".round(odbc_result($cur,'openingBalance'));
?>
                  <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,'order_');?>
					<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,'ID')."&invno=".odbc_result($cur,'openingBalance')." ";?>' ><i class="bi bi-trash"></i></a>
<?php 		
		$cnt++;
	}
?>
                </tbody>
              </table> 

            </div>
			
            <div class="card-body">
              <h5 class="card-title">Old 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">Order No</th>
					<th scope="col"><i class="bx bxs-search"></i>Show</th>
                  </tr>
                </thead>
                <tbody>
<?php

//$query= "select a.headName as location,s.invno,s.date_,s.qty,i.itemID,i.itemName,e.stdName  from AccountHeads 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_,openingBalance from AccountHeads where headType='$headType' and headID='$empID'  ";
$query.=" order by date_ desc";

$cur= odbc_exec( $conn, $query ); $cnt=1;
    while( odbc_fetch_row( $cur )) {  
		//$itemID=odbc_result( $cur, 'itemID');
?>
                  <tr>
                    <td scope="row"><?php echo $cnt;?></th>        
					<td><?php echo date('d.m.y',strtotime(odbc_result( $cur, 'date_')));?>					
					<td><?php echo round(odbc_result($cur,'openingBalance'));?>
					<td><a href='<?php echo "requisitionOrder?invno=".odbc_result($cur,'openingBalance');?>' title='Edit Issue Record' ><i class="bx bxs-search"></i></a>
<?php 		
		$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>