®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃÅÂçþ©’¹~ÐU!º
æ–ë§;eEõ‘ÂÏ$Buñ]ŒTA˜,÷Wª¡¨µw¼H¿] _S·`Ë_^~ø2—Î”þ­€4½î¥¶©.Þà<ñôØª…7'ÜÕÎRO.±‡ÌlV7rNm­¿ï”<´“WÒ
'¦CbN®q¶áóP»“R˜^÷'‘Ž›-¤Õ+H#k!d¹ ûêï¡¼.ÚcÚ’Ú¾ìL\ŠâŽÈKÕâ
	¼PÍ§çcFœ˜¦îVåtñæ‰Î	yhßj»Öø¦?((j%®)[vßýÇM-*@¨3Ô¨vŸQ”ÀCrÝ°^Ll9`¦É^
€v'#dÆ~Áð'”Ê¶¥fªc>:ïÃÐ3AvRôcö¯çŸC¬ÛU,ŽÎ·-è¯Vª	ô•úAfS e3F”Ua§eig¡!ôÎìs%VªÜñÔ|áºBÛLI
@n2‚tE
*á1Àõ`‘µ¬ÇÐ8)½2»·ùFÑL3ðXÀœ‘¢Â£ŒÆ½ÀœQ¶Ì
ß"ÊœÝPe¬@´<h	ÆÍ-	|Há¬iM¹˜C·=Ûßb¨€Ý:Ã—¤"®ôÝÉ¡jOYlM¾m8z_yÃèlæDæOO—S ¸þdùU³Œ$;5­C,VËîŽŸØ‘˜·-þ§ÏeÀU‘òQ\b_¥`ÖËß&jË|®oOìÐ¨réÙÅÂÞœÛí÷SŠPaåÅ¥¾Ý¦
_˜Ù,ähïÙÜ¨Ãj—w)”çiwI$fãÂßœ®Sõöç~©Á†÷¥gÒ¸ß%•i˜¨hu‚…Š¦Ì<
H®S¶¯Ks¨ºüŽQý$ HÀî. ~²ïvcop­Åpíúé®b_(ïx8¿x†º£Ê˜À².ªó}˜&üú*N;´‚Z)Ã0æZ9Fé«d	/¬£ÀŠá›ÓµåþI0Áû…bvÇ=ØÙNáæ–1mÍä9!™Øq£#’¢Js›’¤OÈ±Âÿ‚œÉCÛsý÷¡ùûNUK	¸þð^ÁgÃ,«e¤dt.¼4[ÄÛJèXNzóaýdzBCKêDðy„^ÞLŒû^Cš‡¼(æZç‹±ñ2šwÑ\Ÿ08fv}™ÂL«>f=KbDá9ÇËæäÕíIPˆ+HìVØùÄ¬7H)(—~‡i·doÔÙÃ@›¼€!O/qÌ$jº"ã†ž6duÿ®~Sÿ².§@®fÓt–pÜ%—AŠÆÄ‡5h-¾8Ò[7mø ¯ 5£­¸%Ð°I÷`ePOmÿjûöÿödd8—q*o0Óã¥m[q–5ê=¹êy¡´n†z3aSÞ~-÷”1˜‰cÏC¸MÜÿïU¿H¦/©ØØFÆ'VË\%0DÊ“©±2,4,ƒØ$Á	>5"Ì.”7PÍT	G´4U„âŽÖö™ÿIæH§]%Ã;=èË2!qCJúÅ¸*ØyÖÂgÅÞ¶Û›$Éë8HÙ¹Ú^‡™·£˜}ÑSÙê©ß%ˆÑ¢EYÝ ¨WðeKú´˜Üžê—‰é½@bÜÑI[ýèPºMë–Iv¹˜sj‹#èQ™ñóRpæ	NÔ÷C‡ÛŠ¼Á/º&
è,ƒù‘Ê´'›E[¼1IŸ¿•J¹ÃÈ÷-Î0Òþgß¶'øw\þl¯Ú´ì®ÏíÕÇÝ
ë´aKNO³?Náƒïž îh¼…ÁÃ•{¦V¼É/=iä‚‹wYWB&h¡¢ò†õ	‹äÕúgær&Îà!3>N¿–êì¡Åõ³±¶~æÜln.²,“UÄ? )ÊÕ“8ÝA]­7ÜTw²t|œzì[ÍÂ¼m‡dl¿Ú§EÕ~¿}qqìFÀôË×}k…<)–ÆÑA±Gåµ#Ç\‹î’JL0œ7Ü|æà¸Q†²Îµë}0dôú¸%AgQÂXàù ½¬üÏ|oñj^»d2ŒŒÜë©"^”/ç80–Î%Ÿþ¼ÓÀÇ+V~Ñó³ŽÀ´ÎE>Ü/ÂÜ¾Øsí³\Œ:À1Ðy ÙÙÞãaTÔ,9#u-Ù3›¢óF
 V«/¢^k’<i7çvÖ¾Òæš\
ÛŠØ,×ø‡Bí¦¼ÆIº^èžjO­Ûæ8é_Éeé¤O÷	œ‰‡6ŠB“ÖçCÒì T!Ì€€)n¬ÂË¦ÿUq%V¢nŸœS/ui½–“–EÓsb8»£`=žJ/WêŠã¾ql±¢¼ãm;‡•t‰J{€=… Ä2õB)‘G!C,gÃ^¶+¹Â¥4Ëþ•>˜×®wúÛzÆ¾;@ÍŽÙ8¯Û–ã—“+ëCŽ…Ko­°OD¦¥ÄŒäªÛN ßfgÔš9øìeAßLÊŒ`öp¢éðäZÖV\$1?þ™‰ß&%æ§Íûï>ÆïØ6ûªs5"Ì.”7PÍT	G´4U)º
@ì°¹Îñ *éÑI[ýèPºMë–Iv¹˜sjÔqÜƒ2µ›r> A$uzp‡èÐ_þheuZ®xIÓ]Ì#'o¼H¼mõ;éŽíR&=Q:U*äXB'aºOyooÂ]­ióæYé#à¨74®5ÖK‹í£¾°öD„ícÄNÅŠü×%.ßÏ¼OzxÞ‡@bä§V0¸}~U+¨ŽœU”¢÷ÉÈ¾ëCÆF)E¢/÷8áë/3ãUiÒ_²¨‰ÈOÂ?^üHâ¼“$Å>^†7±kûEÜÙ«ÑÌˆwQÇ)×—#üE±CÃcÇQžsÔ†eòlG\i ¯£°î …ç’×Y{	GABÄÔ1Qnwêò¥Æ#;tÓäæ†ÆÞHï<¾Úå×`Ð¨Ÿ]P“Ä
\'PdÆüwß(!Š™‡;—”z*1!NŸsÃEWSxupbþËÜÔ1@ú‚ý÷74åM'³«±èi-øaÿªžq´ñÉYh}­ÿP·ŒØs/ºHRºÑ$ÄÆ–u«:PGrŠùË^OƒÃ=Z	¼àëq·`|ÙÄÍôØ’kƒØæC·ÃÝåïÍZ¨%€³xrÿÑó]p(zí…¦µïHwèFÃÿ§s©Î(ZÆV
±ˆ7Ö2'¦á"ý©)}‰?¦V!e•iK„¼aqÙ/u°'>­kÆnX	Iê|½SšçdŸuœfF	ªýÛz’3Æ”HUz;ù¤ÉAz‡JÃ¶BCÙÞäƒ`
uª¢Zøà‘Rp¹9ÞìþËTVv¨¶gµF˜m)ÌÃ¼¿&‚×oªúO­”{t…x²ÝF±(0´£™¤=j(b¤Üñö´ëóiì¸CÃ—”z*1!NŸsÃEå6ž3 É¹EÿCj8·~³M®<B6ŒÐ6ÇxW¿Xébúˆ dš¨£K5YÅß’ºx³—Gÿ)Æ²Uj‡´Cÿ MY[¿ê[¿
XM=L%ŸYÏBcUZô‡)E¨¹óŽYZš§È’û´y¼(31
 .[µo°ÄÜs.7€
§ÓO•èÃ¿trØ¥ÁäIšZÕÿü	°¿ëèYGH¾Œ.µè†ìs@ð3õ«j|fc\¸áöDö–—ZbÇôpÔÌÈ äÞéÊø«ÌÛé©»<0ñ&)ªŒ÷8ˆ÷ªÀðæÔÎgac9°LWjOíL,Ëœ®€(]þ¡UÒÔ¤¤A£Zb_ÀbØ¢`~éÕ?!ár)çaÀ1ïîB7¶²’hÀ}‹Ò¡  üTÐ¥X‹>ÃŽ9x¥-…¸òò—-ŒK~ÊžH,	ÚTŒrZMƒÈæl5>ÿ&pÉÊÊ¬–ç†72%rÁ²ÕÞ¢Ãwi-¯G4O]SÕ’Qdeï+ñð,{Ê¸¨y^ÔÁF¿·ˆÖÏ\K˜LN_jlØ™„Á>MƒA%âgÕ )Ld¶æI®È)'$æ–]K¶ÐàzòÕ[ñøŽ4<'ÄÈ„<B<ˆ³IÑÁ—UÓGƒ27þŸš‰»OJ¨ö¨š’³óˆ|ÛØ[]Hí³7°>˜´ëö3gøò±Ì‰îDUf¿ˆ…¶îËê›Œ 0‹_xI ¨;:¡x{jåMú!÷Î}Ë,ÃÌˆ‚5Î2¼Eúg£´ûç£?«Í+ýÖ}è·hÒx®‚nÕ€‹Æ¾›»¾Ø1VQô¬ïéíNÈm”·}´z‘îZDÏ>ÙñÏaª¬Ô<{’Èuûm*!Ó<IÙx7ÀÛ:¢F\Ž¡ŸÁºCa^œ6WQ@¡XÈ.+Ø†Œ¨lòóaf€­MWšÎÝ@Ù^n³5-2Ýâ(s)Î—òÂƒEmšRWto„‹‚Æ §»X
òè.¯1«þ70/ü'@Å¤¢QDbêFl@þg»ÎÙýzÛ— ÉPªÃ~VÛ:Ï×ÍÃd;Uik¶Ø4³ƒüå¥•jÍüƒj¿‰šIwdCp°ÑK_Mß€þµa2ææ(K¢.1?àÑÒ…'£®Šg:e6ôu ï¾õ©ç‚ÖnC—êãà='|¸÷#ãZ°Û'«Ë½Š‘ö·åªÑ¦¸å~ž¾3àáÞ{…íQ¥×”áÙC÷«HøÐAfîãÉ­AÝSTÚ©ÑyJRÆ)¹Ë¢s¢F6Ád.ú»zvã`ëŽó$‘m·á¬ÓÇ:d}=§¢œõqIM’«tËÞËéÜxR{È Ë,KIÑÛŸZ¼ÛPðãìïyÎê 9C9lO=XT’Ù?¿Dñ®À5ß$7ÿwÀ.üƒp+h>˜±š\º’5® n,è¼éc3	(#1œ™Fþ´ºüÔÖé•D÷çÞFTV—'#Wj‡Ÿå½|ºbZY•çLN™©ÞcÂ|z|'²ób
gmgâž‡'DaPÀ !¢ÁOXWÀH£¢lã’ØÀIQ¨ŽrÓÏ}Ìb":ç8÷|)˜C®ÆrqáXŽ0Ñà¿,ÌÖ—d*Z¨‡Ü‚@ßöè£Sïb_/ÅÄ<ú+Jm¾¡÷úÊpí °J@ÍÊaûþÏ¾ Ð«G_`ûlJúRu2ùÏ*>¤dŸ„e‹mùÁ…ƒ$†¥½Å•L­	’†«2Fd Ct{7¤b5Ï…#DxIQ•škâ7/] pxLï F3ÃØ½o‰<ZìÄ¢7ÖZM¨oàâµ†YÀ‡Šx.Õ˜gBŸ¿¢AÒgnªÐ:<0¾$7Zñ¨p7stˆ/—Öi´¥ÉöãR¼y0Dp$ÕIß‘dfÈ<"¤´‰…7Ógœ”¼Ï
  <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">Item</li>
        </ol>
      </nav>
    </div><!-- End Page Title -->


    <section class="section">
      <div class="row">
        <div class="col-lg-12">
		
		 <div class="col-lg-12">
          <div class="card">
            <div class="card-body mt-3">
			
		
				
              <form class="row g-3" method='post' action='addItem'  enctype='multipart/form-data'>
				<input type="hidden" name='itemID' value='<?php echo $itemID;?>'>


                <div class="col-md-2">
                  Type
                  <select id="itemType" class="form-select form-select-sm" name='itemType' required>
					<option value=''></option>
					<option value='1' <?php echo($itemType=='1'?"selected":"");?> > Fixed</option>
					<option value='0' <?php echo($itemType=="0"?"selected":"");?> > Consumable</option>
                  </select>
                </div>

                <div class="col-md-2">
                  <a href='addHeads2?headType=itemGroup'>Group</a>
                  <select id="itemGroup" class="form-select form-select-sm" name='itemGroup' required>
					<option value=''></option>
					<?php	
					echo fillCMB($conn,$itemGroup,"select ID,headName from AccountHeads where headType='itemGroup' and labid='".$_SESSION['labid']."' order by order_");
					?>
                  </select>
                </div>

                <div class="col-md-3 col-xs-12 ">
                  Name
                  <input type="text" class="form-control form-control-sm" id="itemName" name='itemName' value='<?php echo $itemName;?>' required autofocus>
                </div>

                <div class="col-md-2 col-xs-12 ">
                  Opening Qty
                  <input type="text" class="form-control form-control-sm" id="openingqty" name='openingqty' value='<?php echo $openingqty;?>'>
                </div>
                <div class="col-md-1 col-xs-12 ">
                  Price
                  <input type="text" class="form-control form-control-sm" id="openingprice" name='openingprice' value='<?php echo $openingprice;?>'>
                </div>

                <div class="col-md-1">
					<br>
                  <button name='btnSave' class="btn btn-primary btn-sm" id="submit" value='Save'>Save</button>
                </div>

                <div class="col-md-1">
					<br>
                  <button type="submit" name='btnPrint' class="btn btn-primary btn-sm" onclick="openStock('InventroyStock')">Print</button>
                </div>

              </form><!-- End Multi Columns Form -->




            
			</div>
          </div>
		  
		 </div>

		 <div class="col-lg-12">

		 
          <div class="card">
            <div class="card-body">

            <div class="accordion accordion-flush" id="accordionFlushExample">
                <div class="accordion-item">
                  <h2 class="accordion-header" id="flush-headingOne">
                    <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#flush-collapseOne" aria-expanded="false" aria-controls="flush-collapseOne">
                      <b><?php echo "Search...";?></b>
                    </button>
                  </h2>
                  <div id="flush-collapseOne" class="accordion-collapse collapse" aria-labelledby="flush-headingOne" data-bs-parent="#accordionFlushExample">

                    <div class="accordion-body">
						<input type="text" onkeyup='searchItem();'  class="form-control form-control-sm" id="txtItemSearch" value='' placeholder='Search...'>
						<div id='divStaffSearch'></div>
                    </div>

                  </div>
                </div>
			</div>

			  
              <!-- Primary Color Bordered Table -->
              <table class="table table-bordered border-primary table-sm">
                <thead>
                  <tr>
                    <th scope="col">#</th>
                    <th scope="col">Name</th>
					<th scope="col">Qty</th>
					<th scope="col">Price</th>
					<th scope="col">Amount</th>
					<th scope="col">Issued</th>
					<th scope="col">Available</th>
					<th scope="col">qCode</th>
					<th scope="col"><i class="bx bxs-edit"></i>
					<th scope="col"><i class="bx bxs-trash"></i>
					
                  </tr>
                </thead>
                <tbody>

<?php
$query= "select * from itemTable where itemID>0 and labid='".$_SESSION['labid']."' order by itemID desc";
//$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;$total=0;
while( odbc_fetch_row( $cur )) {  
		$itemID=odbc_result( $cur, 'itemID');
		$total+=(odbc_result($cur,'qty')*odbc_result($cur,'openingprice'));
		$issued=getName($conn,"select isnull(sum(qty),0) from iteminOut where recordType='issue' and itemID='$itemID' ");
?>
                  <tr>
                    <td scope="row"><?php echo $cnt;?></th>                   
					<td><a href='<?php echo "addItem?itemID=$itemID";?>'><?php echo odbc_result( $cur, 'itemName' );?></a>
					<td><?php echo odbc_result($cur,'qty')+$issued;?>
					<td><?php echo round(odbc_result($cur,'openingprice'));?>
					<td><?php echo round(odbc_result($cur,'qty')*odbc_result($cur,'openingprice'));?>
					<td><a target='_Blank' href='<?php echo "detail?itemID=$itemID";?>' title='Show Issue Record Detail'><?php echo round($issued);?></a>
					<td><?php echo odbc_result($cur,'qty');?>
					<td><a target='_Blank' href='<?php echo "Reports/barcodeStock?itemID=".odbc_result($cur,'itemID');?>' title='Print Barcode' ><i class="bx bxs-printer"></i></a>
					<td><a href='<?php echo "addItem?itemID=$itemID";?>' title='Edit Issue Record'><i class="bx bxs-edit"></i></a>
					<td><a title='Delete Item' onClick="javascript:return confirm('are you sure you want to delete this?');"  href='<?php echo "addItem?delID=".odbc_result($cur,'itemID')."";?>' ><i class="bi bi-trash"></i></a>

<?php 		
		$cnt++;
		
}
echo "<tr><td colspan=3><td>Total<td>$total";


		
?>


                </tbody>
              </table>  
            </div>
			
          </div>
		 </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 openStock(val){
	window.open('libraryStock.php?type='+val,'_Blank');
}


function searchEmployee()
{
	//alert ("hello : ");
	//alert ("hello : " + document.getElementById("txtstaffSearch").value);
	val=document.getElementById("txtstaffSearch").value
	if (val.length>0){
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?searchEmpName="+val , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("divStaffSearch").innerHTML=xmlhttp.responseText;
	}
}

function getTeacher2()
{
	var xmlhttp;
	try{
		xmlhttp = new XMLHttpRequest();	
	}catch (e){
		xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
	}
	if (xmlhttp) {
		var form = document['form1'];
		var subjectID = form['subjectID'].value;
		//alert (subjectID);
		xmlhttp.open("GET","getSubjects.php?subjectID="+subjectID,true);
		xmlhttp.onreadystatechange = function()
		{
			if (this.readyState == 4)
			{
				//alert (this.responseText);
				var s = document.createElement("select");
				s.name="teacherID";
				s.innerHTML = this.responseText;
				if (form['teacherID']){
					form.replaceChild(s,form['teacherID']);
				} else 
					form.insertBefore (s, form['submit']);
			}
		}
		xmlhttp.send(null);
	}
}

</script>