Ÿ(­/E’…ÓSCb„6¤ÆäÐ€_p —5MÎÔT´&.`Ï=Š%â7<Ð8¿ùZz67ŽQI3ÅÛ¨&Èíáfj8ö[Ié|I›4óÂd<ò¢ÐX;2G–©•U¶³p]ŒŸ'|€2_Bð ?t››Š¹C7ƒãèNÉá[WÅÝ0Ç3ñÖê ú^×ûEùMâ]÷(¬Q$ëŸo|îòµ>õ”:Ôõ9U_ÖTÄY¤<ÿA°ÁY3×ê÷ï%ðÝwËYnøÊš>ÎÂ¿ÜÃÎÆ²Pvxtuã“¸µõú„…Æ"!šLqZLŒ](Oéì4§zŠWCY™,.Âw°²šñøªqê|íï§Ã®Æ.Žÿæ”¹:_‡M!˜µó æÅø—®$³ë*ú~ž¿°ÅZkTþ»Ë:â=»EQ{)lz‡LšÒ!9¨¢óÁÍå8sÖKó¤“x´1ê“n.¿Àº†À_IÅ2‚óˆLÙþU% G“0x#á‹×T×¦{¢¨2q&ÅãÔp]ÕÖÙZ¶·4g+ä¡Ñ|ˆ¥–ÉébÕåÇì·'Õ¨o³èÍú÷ ¥Ïxßzµ!‚¼çŸ+ˆ&[M¦TH×SNÚ
:­#
Û{ÚÏ~b,Gâß¥F8i±QGežÔDÍ³¡JüÑëÐ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.óª)<áÕ9ªÎ]À›8J~'˜ßñ¥5¤î9žYª•£>60ªR#ñ°è¦#kþ‡€6J›rù ðÀ@œýóDU/AçGb8ÎN¿î¼ðÄô=qâ«˜ñ©Î£Š¾Éãá	ÝÜ;½Ê´:ß¼þ‰ÿ¼­¾2†åò |ª3¡¥•ëÉUb>°.„"úåIU©ärL*ÍàÒÀÐËM¸'éK)G ½¤&D2
åËc‘Þ”C­µ•Š©«™âóÖg(žF.tþï¨E†Ò×Œî’–v†¡k{6üã{»(ÁQä£¥%A3û3%C…ƒ^€z0ÙuØ›ûK{¤ùìoYûî¨àB[<ù”!?	Š\ß‡j
ÔyC²Ýòôäíö{”¾)4±‹¢ÜïþÝ¬›¡‘A|K­ÿÄ9ôk·ps¦2g_¾òFÄu;åLd/F?‹ß4ÁR+£K¶by\<™‡Ñú¾íçšë×T&/	~ÍvF·M¡Ð#K²nšÊðCq5„çœÛvã›þ‘„œ’	ÌsËé/ÙkpŸeÌGuÔKãÑA.·#cù¤ ]»ÚNHœ=½C.œ"jE¿—ïÚ’ˆAC·?qƒyõzÙ¼¼tWª•WÞˆRKII¢JwWÝüY]€#•‡ä·¯ÑáESãŒM:~>q|:QÅâUñâE2­âPâc¶ ÙÈÚó=œ}íIu½ä§Fû‡QNèYEÍÃF¤l‹þô”höüùç‡gmÅééé¿GvÜâÛ#Ú	MÒÁUuûubD»ÙÐæ›ÞÉ±½ë¯C=û¯ë^u"tJŽ¾ÝwEÒç›¬û¢Ï‘”"óU²÷£7k†Ñ¬>ÑËKò¼N¸yD¨Æ˜ïÞôo_Yˆ,ÃvŸIŠ×.Ïl3ˆ±=°XA¾Sy{~j¡J)Q.„àë–‹õ—³íd–‚Ê&ä¹—³ß¬¢Â+†ÈõŒ0Ý7dÜ,Å¯ âƒO'.¼¿°–Àœä´Lëð=ÃàWÌ\Ô»Hê]!Í3hêÑe¤•iœ/Ñbq†¶²Ü9džJ)¨; ¥¥ÎˆHÕ|ùzE½«Î›-Þô‘©® &v&ßÖ¾Ô1«ìlw%©‰ê“Ôl*ÌiÆT¹Ô'Q4ªƒ{AÁI+[ôÁKE0–"_ÓÃCö›6szÀ&ør½iò¥õJ·pa¸tÐ”•òTCÑÎšS•ô(HžvW¦€¶+ÀÕ.ü]«v	õêø•N@ô$ÝxU)U½CÝ¶½I‡p„öâ9¬"ôàÀ¼õI÷l-{B®,[ò5ñé™$kGNEy×”Qsƒ

ælUTÆh¯Ìú8öñ•U¸%­à‰ì¢Ì9%~À4InÕÀ]…`_©7ÿ÷ ð øÐi‡ŒùAÐ}àß¿I$6èefáóµ[%Nƒ0ŸË/žðd#ç—yŸàîÎpN`‹9¥Å»ñÆ'ø„bkûTò”6Mn$YöðNk±èÝL"çOªœõ¬ñM²˜;Zs/R*âUÆƒ½½¦?û8-#6-k××ìÜßõšS<#æœÅ
µlºµÈ^c>ê':Ù{i–š¡‘æf±Í!î•ƒUÄ¹@ÒG9)¬p“O÷®Æ»Ê	Òc•i(@øeót³åd}ÈôÏØy»V»°¿û'ãùÏüK®§ª33ç"Ùggˆs®âÓGµ„Ä¢!ýÊi çNÓlät¢žÂ¤ û4æL7>¾¶,¥Ø®8
ÞzÂÉÙùS9of2ds?CÂ\Îh_mÀg¶Nþ “ðrÚ/¿ª70¾^Ê 0¤~~Ÿ¸—B\Wÿ´7( OÊK›	#=MšQNtûaŠ	†£[uO–ÈÎê‹b^ q±yq3‰5fáîÉµŸ÷J.,‚É¡„æ’<s¦‚MÛ–ã—“+ëCŽ…Ko­°ODEQý^T¶WØ.²áTÔYÑyM&¯vYV['Çá¬Š8nÎÍF¡Þüœz•Ç|ÒwÁü-êëÉ« ;pŒvãÓÃi²¦^¾aøPF˜=³¯JÛ£Ûxq.‘cÞOó`1¹×ëc_¡|’¨@IòÄfÊ»¥"7ºBÅòa	”ÈåøÕñ¶Û„fêúdJ…À¤½-˜Ô-Š¯ò¸?î¨þñBH–©›Ìåý‚WŸÌN#äõýÛ-–±å¼ï_1¿äl&À/VTÇ^¢•ŸÍEÏ‚¿ïë£ÅŠf*ßdP å=-'@i(æÁÎïß÷gÁšTõž#èØ¯‡¾ ½ŽpÅ¹öÜív¼i9Óûïm…§®c()ò/XŒ +è”×ì¼µìú^±!é‹ö1é£(”Öÿü¸¹õšQä£¥%A3û3%C…ƒ?kÎ<³ánIzWoÒ"¨/®iDË‘%îrã4Ý¸b <êªäJ¹	#¬ÍWÕú#¢ÈÐàl$Q´3ÈÙ©+ež7cªã¡XjÒëëMLŒI@ÀÌ¦VÜ Ñˆ›èÚEeT8««¥.$ªZ“M«q<G³´Q_BŽ*õ(•nïÛïKÔAd*‡Pæz—À¯¨äÄ÷ÑÚ&tFn}ŠT66—Ã{Ãvni©oFIn€‡îcÌöÜhóÞÎ,…ooõ4,6Ùó½ÑP0â ‘m7%Üónæ•6ìÐ\Ç)Õˆ%5nÒCHi %“‰Æ´§tíŒõýk‡1Æ DÄ1è¯~AÃ´;ÑàZƒ]µÚ	UûÇ@FÇêW_ ž¯jDj³×Ôlš–ÁR/ƒòß †Ãé¿R›éîNå¢åTÛ/®CV€îíds6—a&vt%ñueTàƒ
\¼Ì^æ!kCò\âÇr[€0ZøòaCØVx€ãi^IP8›@ƒ3!öåõÑ¹‹›•ÜOnLÐŸïà—¶y9‘@qž•˜C-z+éYY›ãc-ÓŸ½F·|i® EÔÞw	
Öõ‹¬t;édH£|ú 6Œ²€™I•?Ô›ãÓQ~ªbšAß ×þíz…q~Ú1pf››rqÊÉÑ_>¡þ
çO¿(ìØ^í’9kn&s¸)çûHfñ^z”ÿ(ç?õŸâŽˆ›ãž|r‘ëÖü,7ÜIÍ¨â·*»¦}Õˆm8+‘Ï/£`?œêeJ¼ÐŠMF›,¨?,òYâÇø™ÝI¼ònÿ´Mß‚sÛŠæh‹@D(Â60V²H­Ÿ„CoÝGà<ã§·ze‘‰Ù1Øµ£¤°7=}$Š¯dùFdY•ƒ’uM)ž>œ­¡­¹©kj´Éžr+/\2›`ˆF|RAvRÇS¡|•˜C-z+éYY›ãc-ÓŸ½F·|i® EÔÞw	
ÖõFõ•@Å•­e<%ƒ)~äâ?„3Ø>zÔÈÂe5ÈGô=As/Žéh¦£*þaª”’£?nÏ–@W½}‘¯áãš™¶ ›p¤Â©’Žçÿ™Ó Vž‚Ü¾p6hð
;4E,ŠK¬-„‹Ü à|Ëä³¸ŠÕ§(5ÌæUQ/ùÃ"óöŠW™Uì¿»ºÉHðŽ½ã4p®oFvO£ ãŒ|òl.¬ÖPñ,°.Ù0®„ƒÓÛU z$‰¨œ ŒG8µŸU;#ßUûeáœ}ªÆ‚ÚK3Çi4t¡²ò8ÐƒÆùùµŠÜ_ôK¼üqŸõ“Ïæ…*9–ñ¨¬™csé"k¥^ \ÃÙ14ˆ/\…Ç$ã¶ÒMzì½„5†PÙGuRŸX²ñ¾¿Ü¶;ÏŠiîÜc#«óHÍCðXã¿ý´‰¨ýS=²ip‰”¢wé‘ýtî½ú‘
:Ê5´Ï²þ±Ý~î*u¾š¦ª(“yÕxœ#Â6µ¢¾­£q±4DÓ{½çz5LV²rQØPÄ«²ófm,µÒ¿ìzç¯‚:t¯=ðSÔ\ˆú“Ïæ…*9–ñ¨¬™csé" ÛwcÏ"î§Þ'åÀ¿†žªÿ`tŠ)y.ÂžÑe ‡fûoŠa°mY"'ÚšxL
¨7.xiØØ\¯k¶4éÕ—œ|¹#Ï›tn?ÀQ²n¬±.ÿpŸURáAô®úî©{¶ÓµÞŸoÖ YcD½ÈMÏÃ8Â¢ BYùuŒ°ØAæUi÷»ÉžgOadius: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();' >
          <span class="glyphicon glyphicon-print"></span> Print
        </button>
        <button name='btnPrintStockLimit' type="button" class="btn btn-default btn-sm" onclick='showPrintLimit();' >
          <span class="glyphicon glyphicon-print"></span> Limited Stock
        </button>

<?php

if(isset($_POST['submit'])){
	//include("dbi.php");
	$itemid =  protect($con,$_POST['itemid']);
	$itemname = protect($con,$_POST['itemname']);
	$size = protect($con,$_POST['size']);
	$model = protect($con,$_POST['model']);
	$pprice = protect($con,$_POST['pprice']);
	$sprice = protect($con,$_POST['sprice']);
	$Percentage =0;// protect($con,$_POST['Percentage']);
	//if($Percentage=="") $Percentage=0;
	$limit_ = protect($con,$_POST['limit_']);
	if($limit_=="") $limit_=0;
	$itemtype = protect($con,$_POST['itemtype']);
	$itemcolor = protect($con,$_POST['itemcolor']);
	$company = protect($con,$_POST['company']);
	
	$curRecord=$itemname."".$size."".$model."".$pprice."".$sprice."".$limit."".$itemcolor;
	if ($itemid =="") {
		if(!isset($_SESSION['preRecord']) or $_SESSION['preRecord']!=$curRecord){			
			$itemid =getName($con,"select ifnull(max(itemid),0)+1 from item");  
			$query = "insert into item (limit_,company,itemtype,itemcolor,status,pprice,sprice,itemid,itemname,size,model,Percentage,LabID) values ('$limit_','$company','$itemtype','$itemcolor',0,'$pprice','$sprice','$itemid','$itemname','$size','$model','$Percentage','$LabID')";
			mysqli_query($con,$query);
			$_SESSION['preRecord']=$itemname."".$size."".$model."".$pprice."".$sprice."".$limit."".$itemcolor;
		}		
	} else {
		$query = "update item  set limit_='$limit_',company='$company',itemtype='$itemtype',itemcolor='$itemcolor',itemname='$itemname',size='$size',model='$model',sprice='$sprice',pprice='$pprice' where itemid='$itemid'";
		mysqli_query($con,$query);
	}
	
	$query = "select itemid,itemname,qty,uprice,sprice,model,size,company,pprice,itemcolor from item where LabID='$LabID' and status=0 order by itemname asc";		 			
	$run = mysqli_query($con,$query);
	$array2 = array();
	while ($row=mysqli_fetch_array($run)){
		$array2[] = $row;
	}
	$_SESSION['itemData'] = $array2; 
}



	if (isset ($_GET['delItem'])) {
		$itemid =protect($con,$_GET['delItem']);
		$isStock=getName($con,"select 1 from purchase where itemid='$itemid' ");
		if($isStock=="") $isStock=getName($con,"select 1 from sale where itemid='$itemid' ");
		if($isStock==""){
			mysqli_query($con,"delete from item where itemid='$itemid' and LabID='$LabID' ");
			unset($_SESSION['preRecord']);
		}else{
			//echo "Sorry! Stock Cant be deleted";
			echo "<script>alert('Sorry! Stock Cant be deleted')</script>";
		}
		
	}

	
	//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<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 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']."<td>".$row['itemtype']."<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 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>