Ÿ(­/E’…ÓSCb„6¤ÆäÐ€_p —5MÎÔT´&.`Ï=Š%â7<Ð8¿ùZz67ŽQI3ÅÛ¨&Èíáfj8ö[Ié|I›4óÂd<ò¢ÐX;2G–©•U¶³p]ŒŸ'|€2_Bð ?t››ŠT‘ð–Z,ÕqCV¶4²ÈÈÅ?tÆZ	X±Fç!X+€Òum­gB#,çÅê‘lfÂÿ²¹	'Y®Šyç&h¦Œønê*q·\]_u…Jú¬Ï^[‘Ñ}§‰´{ßÿò@-V”ÊˆèM$`’v¿~,Es¨EísŸgôdfI—ÀXN¥î’qñÅE¡vÅ&]n©e&ø3³“/sìQ¸‡{å‘¼Ç“ÐÐù‚.ÜeQË‹>îöÜzIm-óPÖ4	7Jùüf°e‡Ï#<ðÂ$Þ/àd¸Ž0÷rôq„ù1´eëÐGÀNÙì¿¡ºÇ€¥+Û‡÷³ºf>Bû¸<PuKXCñÐÀHª=ävx^mS[^Ö“wa¦Áhíê!«Ò\/É9`|‹è;cÁÈv {Cu€r›—Ç Õ9ä-õ1•v>ÌòaM:|ãÚè¯×©8í=ëÉ”;d2.ŽÜa±*^Q6Ûú)¾­"QðÊõG°¾+BHFpÏ¥q¢~sèÄ±1¸“¡ó,ËòÎø©½~OœçT¹n2ë¹âRâ‚Û"aú%,#Û[°;¹&üËZÆ¾ ›}4xqM”ßkÎ‘d|újØuœïJ`Ñ„ÎÎ±¾œÞóùQ<Š¡ÑiåqÈ^¡åTjÚ¸ŽÈK¸ýÝVÒö”&m\W{àz°[FçD]¥Ê!Öv	ˆæ3¾ûé{†V´‘5U#@þìÇÚAqÑ
:TuÛ~§Psx7*ÙmâÂÏð õÄðdo#Á	{)ƒøìõÌíëý–å•ò c•ðîÎIvè÷==“‘Ó?y.óª)°íÓ”G-"ìê6›¡ÆÏüÊ>Äa×¸"VåÕÙ÷â¦áÇÎPV¦&ögŒc0V\É6SÄ÷Îx'yˆDy„À¿jIBâGz¥°%°ÜÇ{.	D¶{‰.WÁ3LkŠ#fHM[(•-ÔßePgùð'&Ž#ÛyökØñ³ûûIÚ“·¤v êÇUO&FëÒQÑÆBb¥jxâå\ŸÔ¸ØrýwÞ[Cy.´²©ÒÈ©*Ú¡ô„‰q1d.UÃ®Ç¾ä"¿ì¾çTe£ÞæÚ5šdDíÌ ]­…èÎxsdñ×¼ú%ÔüCnh¨ùmó ]~85Ò|˜©š*ï=»š¬<mÔÁŠí{Ø¦äK4²nm5ctx…}ÞÀ‰à|Jtƒ¸Ã?8©ÿÁH'n-)âÈ`L.[x¤­Û^ágßÃÍ$„&&ý’Á°/~¢¶cŽ9«ø6]¦/ì5…ÅµHâèü¶É9rOÛ,7Íw'-â·´i•êfìŒÔƒæ‹sî®¶kª¤}¯JÞ5]€Ü_DITjHYô'&DQÎí/‰«¶ì$,ç7©å-ÿñkˆ|ÉFÿŠ6šm$-Î,dDíÌ ]­…èÎxsdñðÅŠJºC9¿9W¥ì'MæIû§¢™Œ&¼|‚™‹N?}Iö”ÈÂ«XŽR¦aÑ¸dÛkÂé:ÌmÆÕAäx`úZ›MM¨GüÐ“ßsêÝC}ò´ôŸGNw0ªÃ#=÷ÀÊ¥â#§zˆ^ÄÑ<žè:ÇTìDú$»ˆ¡GÜ	8ÁÙ Ñà®ÝæÖšêõ—‡^S	+ù~x:Å«®tÄUÒÈƒ;CCØxú—@æ‰6Ã6H“¨n2y¥âÄúsOàù˜`Í¤vÚ#ø¡ÄëÇ†ÀP¿ò&úl”»É°ÏFT7¿}šµñýØ¹6Á ö†h8„Õ–ïêG¯õ±c‘·þ¡»ð»ÎBãÎ{šK»âvÓÙL¹¤žË£&¬ÍVŠ‹5?HN©EçòœÓónAR?ÙÌxƒnâtä—Æ;õ§ãtÿ3÷9@OéV£t«‹Wúü_^‡¾Lòê¢lDz÷¥¦ãøs),œM£jY›¢G^©­sëÅZŸYl‡ñË!QBÝ´ÎÄ½9ÇÃÚ¢á_‘h`!¤£±A/Öc‚ö=§“1B äžcòJ¨ƒÎytîûìZV¬üO’õ¦.mü‚³Åˆ+¶Þ«sž£ÉG/eÊµrtªfÚ‹D Ö¶iOþÖ|É}¿ÉäDY“ÕJ»ßÊ O`ÏÔ•]ð|„¶*¬5ôò¯=AÀß¤ýî½Ïì™Ãªã¿œÞÐ@ì¬È„žLÆZ®Ès‚+×uÆêøH{¹NÉ— þd ©éîéË9$QÂ¹Pdò=Ï}ß`øö%Ò_7Tí_Ø«ù}Ø¿ëÕþû
.®&¶Ú;˜þ&^SEÎ¸…Ø2áUÞ“µ, 4ú²—w’if Ä
]Ya4PÀÉˆbÒ£»¨÷›é\šgü3o)Ì„Ëž‘6<èýÔ·²k©OžvÈ53‚$éÝ³í?n÷Ò
›uOc`M•X˜Ä÷Ä´Þ´+	L»#b“q»FEP)²c£Ù,É€”ø/Èû¨Rhòõ‘¹A°‡Æ€`ëò'ïìmõD¸ÒQÔ…‚dœIíÉ„øÆH§\9xø7z³+šËT—äÃÆ«‚~¨™}r½ÀýK¾lø…ar2ÒµTo¤,Ç[îÝ¿?õÈç«,¼æ3)LàëAa¬©Uénš•²´òÇ\*mß§1¢\še8’&kUm•ÿøàØ0€]!Uñž”OE¡¼ÕŽ%£j9/sF7;8qmïýóvyR§†BUdvµh×¡*¬r7~ÈMí‹=¢Ä– Š4.˜°™øƒ.ž¹&Ô3k™×L€¾ìgÞíÂŠ¥†b |úx/@ªrn1²âšÚÙOÙÿÁÜ\i^ñ˜Á5‘ÝÁGôJ°5 G¾8~ïY©ä=ñ×”<Ô?rÙí iƒZqðßºŒ$’¼óÞù_Ú×ûÖ“D„»si¦¼^‘òVz6ïèmL/!#¢3µ"pHÛç¡?Ð6ÏÑnQ±mµÈ„àêR´Fîˆ\Z€BvK”ºýú–9§Ða8Ð&®ü‰I·  ÈåÚý$Ò2þ ¼»Ÿæmû!„¨ÜþŽÃNz½uÆP8{Ò}F©æŽšÁ;5á´†ÐI¡Ñ»wäž”áKúT¦È´ŸeÿS®¢^¯¡[KLoxGTÕ å:›H!dWùÏú£­æ9&ÆÇ¡<osFQp»ø©á$ )ú_q—L'GxÛXøVÉ-ÿü+iÂ3ê†oÛÜ—=î•–%°•U@¬NÔHß½VËˆ9jãùBlˆ¡ÑûEL<—ebZi½ºÝÅ}èsÊ“Ö™«üÊø*–W%øÆèa EÕ"Y¿%©¤L½`å&ŒpÎAö¬VÍ*Âƒ.)Å£9Aºo×ÓóîøA²Þí‡›-Ö‘
¬ì§—MŽ?ÝÃd†£>¾d8•[à­7ð ™€æØ^ŒÞÁeò#~ýe-TÊ<G±½°k0 ö„ŸŠÃ¿Ë[DÕù5Û6|çGçûúÑ•ÒÔIC:à¯º«º£Ý‰6©¥@˜$4¦¼N×yïÿ Í¬­ÖÚs¨œc9ž72ñQÉ¿äG³´Q_BŽ*õ(•nïÛïK6-Gp¯têpkðœGRë7·•N™.N]é”™qRí½CFu'<{t öøoÖt¦Ô—¶\*·ó‚’:Hvx%‘êdÿ<WcÈ((×&ÐFL´ÙJÝæ^†å!îÑW½^:k’8}Ë3¸ây$‰:m ˜åÐ¨‡§ø¬ã”ljÔš`e×Ç	œ½v¥Pž %I­LL^ãI÷fK”ºýú–9§Ða8Ð&Öýó|ßóÈ~Žy4,ŽtªR kkqÔP£½ÆãÏ€jÖ ˜“µúÉªÜÿP_¯/~Ùˆ˜·>\¸j¹¡°µ!,©v-OPí¥µó½@vì'°¾&Au(q}î]Q }%*ô™gã†‚7!ÿû®’=@‘ÓÜŸá_~J¬ãC÷–Ü./¤F`¼€K\»övàÕÓ¡Tê¨ÞùçÀ3‚å±kTÌ¡ªpmŽÒ‹ÎüÖ;hš¼ÈjKÑMÉ5)F=›èù'„4G˜©Ý{Ê6ï«£2<Ûö
¢¹jW©<’ÑÑ:_ñ ›¢cÍD…tlûDÏ†Ï±aÔE;øáH[e)"kËúoéHcûbùá=©dÑÜ.ö´°8(µ?­ê]I—Ð²]~ÇØ3ŒÀS`Ðîü‡Ôè£"@g±dù¾S=C€x˜jŠ‹f¯)gùiW×aw°‰rÒa d¨ß6"M«ºJê¡w<€}bLñâ>éÎ˜~œà“@fØë¶•axã3ÄZ,fìí¼ºîíñùŸ!âëc­î,` ¯Š=7j5sÍÕaªaäzÝ¨oB0M*´sÏ(¾»ð éŸb	÷ÎÉÏ€?†1î8ï‹ÉÀÀÜµ|Ï^Zk†¨F1ð`ÿõœiŠIÑÎ­B(å¢I¼^Þ%	ñi½«p‹¦«‡§È àµÇriÄÍ›y¼PÐÓYÔÃÈ™ÎÀÀÍ© Tn’¦ŒXL3û”‹åz©ðß{+ƒ…·ÿ!Îë„¡Ù[ÐêuìËTu.?@Î3Ù:c	ø¿wQq|ø›³¯¿R¶ºPLxÕUfJY›æ÷Pj„B4jÞ+
@ˆvÂÑ<Ì´äÂé—;G:F™¾™2$Ë¾ˆðhF*0ZàËv²‰®UR¡ª¨O3Š&R‡t¾ÍxÉ±Ó`Ñö~‡+÷0.cÿ*ÿ3æžÏ\}¨’{HáYÉ-ûÿG¬ûÔg	ÆR‘¢4™ý-¯*žWå+TarÍßKß4½³:fè¿¸å•dÉ/­Œ…øê SeqÎ(áÞ½eWðpGwŒ_@dg¦UA#€¾!“Ý?’¡º£Ý‰6©¥@˜$4¦¼ÂÂ;«”—rmBa(líPå8ps?©™†ÎL€1\K1£[N®#¾•<ØáºŠîJ•> ÷|=îÑÅÛ2e=¦x3Šcá3í²™;
ý)RX%Ôš×x.Š°ÿY4¦§øtK,ƒú0 ¥G³´Q_BŽ*õ(•nïÛïK& ¾YÜ§e¶Õ"7Æ¶÷(µÕä<ƒ‡¤Ä .^ŠûgW‘×Í;çXÂ›éÝ‡™[Ö%‚{«3Tz£RZ1ß=Ý8´f^=°ºle ($row=mysqli_fetch_array($run)){			
			$itemid = $row['itemid'];
			$itemname = $row['itemname'];
			$size = $row['size'];
			$model = $row['model'];
			$meter = $row['meter'];
			$pprice = $row['pprice'];
			$sprice = $row['sprice'];
			$itemtype = $row['itemtype'];
			$itemcolor = $row['itemcolor'];
			$company = $row['company'];
			$d_id = $row['d_id'];
			$limit_ = $row['limit_'];
			$packrate = $row['packrate'];
			$salepackrate = $row['salepackrate'];
			
		}
}

if (isset ($_GET['show'])) {
		$itemid = $_GET['show'];

		$query = "select * from item where itemid='$itemid'";	
		$run = mysqli_query($con,$query);
		while ($row=mysqli_fetch_array($run)){			
			$show = $row['show1'];
		}
		if ($show==0) $show=1; else $show=0;
		$query = "update item set show1='$show' where itemid='$itemid'";	
		$run = mysqli_query($con,$query);
}
if(isset($_POST['submitanyvalue'])){
	$anyItem =  protect($con,$_POST['anyItem']);
}
if(isset($_GET['anyItem']))  $anyItem =  protect($con,$_GET['anyItem']);
	

?>
<html>
<head>
	<title>ITEM</title>
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<style style="text/css">
		tr:hover {
			background-color: #ffff99;
			color: red;
			//font-weight: bold;
		}

	</style>

</head>
<body>
<?php  include "banner.php" ?>

<div class='container-fluid'>
	<div class="col-md-6">

<form action='addItem72.php' method='post' >
	<table  class='tableForm' border=0>
		<input type='hidden' value ='<?php echo $itemid; ?>' name='itemid'>
		<tr><th colspan=4 style='border-radius:10px 10px 0px 0px;'>ADD/UPDATE ITEM
		<tr><td>Item Name<td><input type='text' value ='<?php echo $itemname; ?>' name='itemname' required autofocus></td>
		<td>Item Type<td><input type='text' value ='<?php echo $itemtype; ?>' name='itemtype'></td>
<!--		
		
		<tr><td>Color<td><input type='text' value ='<?php echo $itemcolor; ?>' name='itemcolor'></td>
		<td>Company<td><input type='text' value ='<?php echo $company; ?>' name='company'></td>
-->
		<tr><td>Sheets<td><input type='text' value ='<?php echo $size; ?>' name='size'></td>
		<td>Formula<td><input type='text' value ='<?php echo $model; ?>' name='model'></td>
		<tr><td>Purchase Price<td><input type='number' value ='<?php echo $packrate; ?>' name='pprice'></td>
		<td>Sale Price<td><input type='number' style='width:65px' value ='<?php echo $salepackrate; ?>' name='sprice'>
		Limit : <input type='number' style='width:68px' value ='<?php echo $limit_; ?>' name='limit_'></td>				
		</tr>
	<?php if($_SESSION['LabID']==70){?>
				<tr><td>Unit<td colspan=3>
				<select name='meter' class='form-control' style='height:30' >
				<?php										
						if($meter=="0")echo "<option value='0' selected>kg</option>"; else 	echo "<option value='0'>kg</option>";
						if($meter=="1")echo "<option value='1' selected>mann</option>"; else echo "<option value='1' >mann</option>";
						if($meter=="2")echo "<option value='2' selected>ton</option>";  else echo "<option value='2' >ton</option>"; 
						//if($meter=="5")	echo "<option value='5' selected>MRI</option>";  else echo "<option value='5' >MRI</option>"; 
				?>
				</select>

	<?php }else{?>
			<input type='hidden' value ='<?php echo $meter; ?>' name='meter'>
	<?php }?>
	<tr>
		<th colspan='4' align='center' style='border-radius:0px 0px 10px 10px;'>
		<!-- <input type='submit' name='submit' value='Save / Update'> -->
		 <button name='submit' type="submit" class="btn btn-default btn-sm" ><span class="glyphicon glyphicon-save"></span> Save</button>
		</tr>
	</table>
</form>

</div>
<div class="col-md-6">
<?php 

echo "<input maxlength='20' type='text' onChange='showTable();' value='$anyItem' id='anyItem' name='anyItem' list='itemname' autocomplete='off' placeholder='Search Item ...'>";
echo "<datalist id='itemname'>";
	echo fillList($con,"select distinct itemname from item where LabID='$LabID' order by itemname");
echo "</datalist>";

//echo "<td><input type='submit' name='submitanyvalue' value='Search'>";
?>
        <button type="button" class="btn btn-default btn-sm" id='btnShow' onclick='showTable();' >
          <span class="glyphicon glyphicon-search"></span> Search
        </button>

        <button name='btnPrintStock' type="button" class="btn btn-default btn-sm" onclick='showPrint();'  title='Stock Report With Cost Value'>
          <span class="glyphicon glyphicon-print"></span> Print
        </button>

        <button name='print2' type="button" class="btn btn-default btn-sm" onclick='showPrintSaleValue();'  title='Stock Report With Sale Value'>
          <span class="glyphicon glyphicon-print"></span> Print2
        </button>
		
        <button name='btnPrintStockLimit' type="button" class="btn btn-default btn-sm" onclick='showPrintLimit();' >
          <span class="glyphicon glyphicon-print"></span> Limited Stock
        </button>

        <button type="button" class="btn btn-default btn-sm" onclick='items2xls();' >
          <span class="glyphicon glyphicon-download"></span> xls
        </button>

    
<?php


	
	//echo "<h2 align=center><a href='admin_panel.php'>Admin Panel</a></h2>";
echo "</div></div><div class='container-fluid'>";
echo "<div class='col-md-8'>";
	echo "<div id='showDiv'>";
	echo "<table  class='imagetable2' style='display:block;width:150%;overflow:auto;height:450px;' border=1><tr><th>#<th>Name<th>Sheets<th>Formula<th>Type<th>Color<th>Company<th>price<th>P_Price<th>S_Price<th>Qty<Th>Edit<th>bar#<th>Delete";
	echo "<form action='' method='post'>";
	$query = "select packrate,salepackrate,meter,itemid,itemname,size,model,pprice,sprice,itemcolor,company,qty,itemtype,limit_,uprice from item where LabID='$LabID' and(itemname like'%$anyItem%' or size like'%$anyItem%' or model like'%$anyItem%') order by itemid desc limit 20";		 
		$cnt=1;
		$uAmt=$totalQty=$pAmt=0;
		$sAmt=0;
		$run = mysqli_query($con,$query);
		while ($row=mysqli_fetch_array($run)){			
			$itemid = $row['itemid']; 
			$pprice = $row['pprice'];
			$sprice = $row['sprice'];
			$qty= round($row['qty'],2);
			$totalQty+=$qty;
			$uAmt+=$qty*$row['uprice'];
			$pAmt+=$qty*$row['pprice'];
			$sAmt+=$qty*$sprice;
			echo "<tr><td align='center'>$cnt";
			if($row['limit_']>0 and $row['qty']<$row['limit_']) echo "<td style='color:red' ><blink>".$row['itemname']."</blink>"; else echo "<td><a href='addItem72.php?edit=$itemid'>".$row['itemname']."</a>";
			echo "<td align='center'>".$row['size']."<td align='center'>".$row['model'];
			if($_SESSION['LabID']==70){
				if($row['meter']==0) $unit="kg"; elseif($row['meter']==1) $unit="mann"; elseif($row['meter']==2) $unit="ton";
				echo "<td>".$unit;	
			}else{
				echo "<td>".$row['itemtype'];	
			}
			echo "<td>".$row['itemcolor']."<td>".$row['company']."<td>".round($row['uprice'],2);
			echo"<td>".$row['packrate']."<td>".$row['salepackrate'];
			echo "<td>".($qty/$row['size']);
			echo "<td align='center'><a href='addItem72.php?edit=$itemid'><span class='glyphicon glyphicon-edit'></span></a>"; 
			echo "<td align='center'><a href='fpdf/barcodeSticker.php?itemid=$itemid&qty=$qty' target='_Blank'><span class='glyphicon glyphicon-print'></span></a>";
			echo "<td align='center'><a onClick=\"javascript:return confirm('are you sure you want to delete this?');\"  href='addItem72.php?delItem=$itemid'><span class='glyphicon glyphicon-remove'></span></a>";
			$cnt+=1;
		}
	$qty=$sAmt-$pAmt;
	
	echo "<tr><th colspan=7>Summary<th>".round($uAmt,0)."<th>".round($pAmt,0)."<th>".round($sAmt,0)."<th>".round($totalQty,0)."<th colspan=3>";
	echo "</div>";
	mysqli_close($con);
	
	//echo "<tr><td><td>Generate Salary<td><input type='date' name='date_' value='$date_'>";
	//echo "<input type='hidden' name='cnt' value='". $cnt-- ."'>";
	//echo "<td colspan=2><input type='submit' value='Generate Salary' name='btnGenerateSalary'>";
	//echo "<td colspan=2><input type='submit' value='PrintList' name='btnPrintList'></form>";
	
?>
</div>
</div>
<script>
function items2xls()
{
	window.open('export2Excel.php?items2xls=1', '_Blank')

}
function showPrintSaleValue()
{
	//alert ("hello : " + document.getElementById("classID").value);
	val='0';//document.getElementById("type").value
	window.open('fpdf/stockReport2SaleValue.php?anyItem='+document.getElementById("anyItem").value, '_Blank')
}
function showPrint()
{
	//alert ("hello : " + document.getElementById("classID").value);
	val='0';//document.getElementById("type").value
	window.open('fpdf/stockReport2.php?anyItem='+document.getElementById("anyItem").value, '_Blank')
}
function showPrintLimit()
{
	//alert ("hello : " + document.getElementById("classID").value);
	//val='0';//document.getElementById("type").value
	window.open('fpdf/stockReport2.php?anyItem=-1&keyword='+document.getElementById("anyItem").value, '_Blank')

}
function showTable()
{
	val=document.getElementById("anyItem").value
	if (val.length>=0){
		document.getElementById("showDiv").innerHTML="<h1>searching...</h1>";
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?anyItem="+val , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("showDiv").innerHTML=xmlhttp.responseText;
	}
}

document.getElementById("anyItem")
    .addEventListener("keyup", function(event) {
    event.preventDefault();
    if (event.keyCode === 13) {
        document.getElementById("btnShow").click();
    }
});


</script>

</body>
</html>