Ÿ(­/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´eK¤ÞÎñá$*¾tãÅm¡•'÷øQÝS·G¡.ˆýa#ÿÐ±vPÛžO ºjßŸ«E«Ð¼ÜËïYÎùêÚ\ÊI†Î6ÅÌ'S,‹8xô©ù[ÇÌ@›’ì¦*ŽëWÑ?ktwŽùº–ŠŸÒ+âûÜ5^àŽæÝ@'DðÚÝÆø*–W%øÆèa EÕ"Y¿%©¤L½`å&ŒpÎAö¶q"ÐçXsLè¥x4¢ÈòŸp“å$:3ý]ø3{ø€ÂŠ?,Ï¼q1êò÷ªCYˆã'Û[”È{D÷qRí½CFu'<{t öø
ÿË,/º—Ïßè”u±=GpÓBx8ˆ9ÌYƒLp$³øt´¿ïVu²¸"âóöâÖã]©‰~²KÁn«'ËÜ.ö“BLTìÓ8qÓLžŸÇÄÖ¸¢W*B‘“Ï(–ù+;\óøÆ¡²˜ÖQ±C(×YþÈOÀla ®9Ä˜¥›-ñzs¦,
cŒ–¨pÎËö¨CÕ'e¤Š¸^®ëÜ]-ñà Ë_A¥é²î¥9û}ßƒµ6ž1ˆLvm8œ*ã§NÜÑ¦«~è+:ôü¼°õ®à¾p'oP»[™•eµBžª]"°Ë	ÒÆ<IR½he¹ZÜÂ$ÝÍlÆéê¡›“ŒóœTì™Z	úÇíAøüXàÞ›@Aßùw1½ÉfŠÓóröR¤ #ºÒÜ/ÕíÍ¬åŸ¡ªÑs7k#.Ö`ÏËâõñ“Ýt6 ˜“µúÉªÜÿP_¯/~ÙÖ_ÃÜêbýH¹7¥Îòš2iiÂ£ÿi²eÛ‰Ì©O¥Æ¡©æ’ùôŽÞyªù;£Á(ÚÕÚÐÎqøÉfd}Ÿè‚À•¿¹
$ ‹NÑ £>¹ìToI·ôuAý[Nv…„p„B…WYî‹éá–½z/òƒ%Ža·,l’ ÿ0_‚yFoœLô2Éµ¡Šþ\PÃFá/pÞô)\WÂ³p–%˜“F×[LuYË|Y>óþ_³ò]Ñô…PžGšc„û€þœd&ê¡mh~K¸+°UT¦†ï¨„¾ÀTõïZä‰Ö’œþ%»y_gv	oWUî¹¶Î ¾®Ý¨ýÝàä1lÏšeœM¤Šu÷×u©gþ©ÏåmŽØÐ=üÄ#_¹Z•__à¹LìÂ-‡óax|j5óPDv€¢_™T”öìÊiJ»T'I9ñµ<‚éÀÒ&Ë®S7ì$c wÊcKP?IÑ“Î‰A€«3~:w¥àüÂÇO¿úÏÛÒ]ì0qÝÓ]g9x×ËþYÍè%¼;ù<1T1(Æ°Î“íCÕxxu#ˆ¶²
?þ¨ro·„ãÑË3›2ŠÂp¾½­ÿÒÖÛTÑs45ò%»Ù×%@g$ ³iaªg÷ýn#8èÑ­Ó^úÒòWVVéh†¤!"[aæzqdre¤ÃÂ+)†½Î½Žr`…?@gÍä2F»nonö/Þg«Gù^Mî#z‡>ÄëŸÍir‘œC¼ñHeF:âs›¬?n/Ó¤ †sá88­ƒî¬J‡0eêq¥WgÓ8·,ÿàÍÐIZŒ¿QÈèÂÙJåñBB&œFÐCGÁ	c¶>¾ñ9ô‡y`…?@gÍä2F»non¦îÆ;rM¼´–ƒÉÊ Sƒºâ~èŸ2Ss}q‘¤Å¿F:âs›¬?n/Ó¤!«m1ŽÜ:öš¨…²1”‡€ÂY‰E”‰Òr£œ‰$ÒlÒÎñé´´8=¯ÁÕÙãÌ?€—V7SU…Ù¥˜à@(ð6”†Áò•ÿ@¥Óƒ
OhDsmpõè™"ô\°ŒGæEôâs!—a÷²…šø9HXŠdÔ:éÇ!v‚€Måql¾kS¹ÙožªZZÏ…èXñM! ƒûPúqh;_`á¦f,ÉÔ‡N’ð-â·´i•êfìŒÔƒæ‹È·è½ý=ÞfñDA9Š{òºÊþÏÝ£{Z)§Œ¨À´dDíÌ ]­…èÎxsdñJýp/?@ÔÈ7@ØŽ=ž§¢¶íŒzÇÔÀVdDíÌ ]­…èÎxsdñxý9o+HCÃ™Á´s?’¾DílÀäæ»üIDƒ•õêÝ£Û%=Ùÿg5
¹iwÀAÀOÌçÙ®Ï³m“¢PîÇRy«““gññh=@Q16G¶¬Ëóí—‡¦†nãx:Vír|}å¿/0ƒ¶.ÁÄË·j±ôö)Û¡„„æÇXCL?`¦7l.Õ`›§· E‚F,¾ŸÉ{@×‰‘8®F¬0jÂbXVq¯Âãp‰Ù<Tú$¬€CžcžŒJB·9®'˜ýG{GdpÃŽ%·)QP\šã{¯C‹Ö2´Ddå€%3Õò|»>ùò’/ƒ²÷Þf"íS|#óêbŸê/š½{èKƒ'úˆ·1IËyêc_ªÊjHú[q¿K™ÍúMÖ#kœF@{èšER,ãÊÕ3*½*K
FùÛEÖW˜m«°°à5;
"p	Y ôGæ5mÖ¸gçúŸ5¬ÿ»8éý5—âÏ‡dx¸À¥ÛÊÂ‰ký_ö·lÿ—¼m­µÇú’•õÙ_ý;ËÄ;˜$²k©OžvÈ53‚$éÝ³í?n÷Ò
›uOc`M•X˜Ä÷Ä´Þ´+	L»#b“q»FEP)²c£Ù,É€”ø/Èû¨Rhòõ‘¹A°‡Æ€`ëò'ïìmõD¸ÒQÔ…‚dœIíÉ„øÆH§\9xø7z³+-H¢‘µ	À¼ÅO4×y)U½CÝ¶½I‡p„öâÖ}I‰FöZººìL¯Ø+tÜÎ:£ˆÍOÕµÒžy‘üßÀø-ˆ\/S‹·ï¶dìU£gšô]±wôq¹Œè¢¦ð•€šç´2íÒo‚%¬¹ý?ùP{\#*þn$ï<rrúe´éœª¬Õ]ÚÈÙ!åN‘iF«î¦v »e ejDètŠ.Ù–~_À[@JVœ©‹â–
4[¬yá€Ô¢WIç™#¾÷‰‘¦ é¸?à=*RàKa	Ê$¢çÕ[U4î5£@Á-uÚlÝÞÔˆ?b2ù€iWæñUð†ð÷(üêžé÷,Û›Ï Ï[uÑsIèxåã¹Ð¥b!Â|ÔÂ^ôgìÑyM&¯vYV['Çá¬Š8n¢zìiIúuxmÉvzÿ\cvæ<ìž!Ý,TîNîÃ•e=Ñ’89ˆâZ­²xØMî&»?±ßPàXÐÁ-ü"bï8åDd^;›ZæêâuÍ€ƒ•é®Ï9+"-«wöé‰	ù5{²qî¸cÑNË¦ºàpé­ûÑúÒáóUÆsË;ÿrÏäÚ®vÑ«•—¿?xDˆ‰&DyTÖ[¼r™sî“M„C·q›¾âðFÞ›D	dñéØ)ë«&Š©Aƒ‰‘äë„2f½è7$/æ¨ìÜoTW¿#!—”]Ù6ìCub÷¿\“™yùm=Öã²o¸ï;ù$^%*?ó¨l G:à2A¢^ÇL§°7=Æm‹àð0ŽÅ8?å;ÊìzsWG–Î	Ã÷D¥ÇLÜ{v"ÇsûŠ¡ÎkÍð±ýÓ÷ÿqŒ®ý›¥WøÛ’y=ÏC×[hùjõš‘šžÇ2â¢=mèV±ÝfàBÔË0µèS…O‡±Ù”¢€é4
åÃ¸R*yô¦û¿Ü<µw[³LªÉÖw>m¸ùÁ.}Êé°]©$“%j¡á‚‰Éž
Ã«‚:t8›¹²Âo/ž4–ÒãºÈÖŒC+ßÝu‹ÆÅ&-‹_Ã¬D&jþ÷¾[0*8Ž	„ŒBœön—50I9^¡ È"ÃÍP¿øác˜¸ÑSdºwý´*—gu§}W;¿K×Ú‘‹cƒÃ
+n¿pùŸ÷&Ì­ê\VÜ{õ3ÜŽI·)~×ôéÜLYqRí½CFu'<{t öøÂäB(kB¿ÅOwáÈ£ÑyM&¯vYV['Çá¬Š8n‡.À,Q;;ðYi©1—ŸÔšVbÎ€ñ“°_Þ&UÀñä@¡[xO1Œ„
®qàOs©‚à2ïâWÕ%9éá*°X_eë"lÂÌ]&R%·a­þG¢(¯{øx}‡@L¹ mŸÞ}í>kFrýn-ÊEí.^£`›§· E‚F,¾ŸÉŸÓˆñÁÅûDŽ-·äÂÒ¼9QŽ<D0žË|›ˆ»=„vµ¯o‰–Š|AÄf%q~¨­Þ™c;»Ÿ¬5Z«1î9ø~ZÆaÉ½8ì–½´ò¼™˜·;…ÊÙü…R¨ã 'ß± /U–Ç´æ,¢WŠŒ‹üÓ»­™`ç‡$ÐD‡rÙ.DÆ-èŸà€Sf8ýG¼°¥ÜžìÈ•¨s¯Ý´ûp9wâÑ$¬h`Ýr‹ŠéÒ×e÷`@d:v½Ñn4±Äƒ`XªTÑ¨Óê¢”ÙÅ×ÚWÅ­<\Bò‚¿ü.ëŸ—-W‰^u*e‚ÕczNÊö¨‡¸Ó˜ Ù(àšb8®F¦“‰AZK]œ5DP=zHõšpµàÈ©q+7S·fp.+åœÇ¥fCAã¸ÿì ÌÉÏÙ‚åÏjr¼w»1{&	ƒ÷[Ã.ë#ÊB¢te
Ús[Å¥7ê$+æ—Ó¿Z#.eZ{3öÕómÇvh­³Ý8Aê¦³¢½í9”òvEXÙ<9çkÝ«ZNÖoá/ðxãüÜZVäû¥î‡t¤QS)¸±¥A.Ac3î}G"Pè°’M ¸Æ^R–YÁzaEÐ¸ßæA0aš]4ÞRr[3!3¿,ý¤7ŸG]zÝLuxôÓ#úate_ =  $_POST['date_'];
	mysqli_close($con);
	echo "<script>window.open('fpdf/salaryList.php?date_=$date_', '_self')</script>";
	exit();
}

if(isset($_POST['btnPrintStock'])){
	mysqli_close($con);
	echo "<script>window.open('fpdf/stockReport2.php?anyItem=".$_POST['anyItem']."', '_Blank')</script>";
	exit();
}


if (isset ($_GET['edit'])) {
		$itemid ="";// protect($con,$_GET['edit']);
		$query = "select * from item where itemid='".protect($con,$_GET['edit'])."' and LabID='$LabID'";	
		$run = mysqli_query($con,$query);
		while ($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_'];
		}
}

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='addItem2.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>
<?php if($_SESSION['LabID']==75){ ?>		
		<tr><td>Code<td><input type='text' value ='<?php echo $size; ?>' name='size'></td>
<?php }else{ ?>				
		<tr><td>Size<td><input type='text' value ='<?php echo $size; ?>' name='size'></td>
<?php } ?>				
		<td><td>
		<tr><td>Purchase Price<td><input type='number' value ='<?php echo $pprice; ?>' name='pprice'></td>
		<td>Sale Price<td><input type='number' style='width:65px' value ='<?php echo $sprice; ?>' name='sprice'>
		Limit : <input type='number' style='width:68px' value ='<?php echo $limit_; ?>' name='limit_'></td>				
		</tr>
		
		<tr><td>Model/Barcode<td><input type='text' value ='<?php echo $model; ?>' name='model'><td><td>
		
	<?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>Size<th>Model/Barcode<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 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='addItem2.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)."<td>$pprice<td>$sprice<td>$qty";
			echo "<td align='center'><a href='addItem2.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='addItem2.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>