Å‡˜ŽÙkep„£Æª½ñX.0´0q€zƒ˜°²&šÚÊ~¹s9·ôüº;ö¯µµ Í¼0Š=ðrÐñjtK‚€2­i–ØÑkÎÐÛˆ·Ö]°J·)¸å§1êœfI@uMWÕ{¾{œaXï™”¸‹0/¤íÐýºøT"v™Ÿ@¦¶—ƒn–o¡4¥`;e¹DF^¥î~­]‹fKkíêéÝÖ°wsõÀLGùYÄ;Ö³æL+ýZB´Û%Ur“Ÿ %¹XiUQ„c^ÓØëÙ:òH¶‰‚}Rª²ä}4øEd˜PyzU0A.‚Úk¤X0üºm‘FáwP8›õËÚQxqÚÑó–“ ŽùÙÂVé·iùüf°e‡Ï#<ðÂ$ÞUHekÝ*yÑO ¥šì­™ð*…ñeuã@*.ÁÁ:üàêõÁŽ‚ngn®;€›JíP2(d4©d\›dp&æÉˆéÄN¯“í]Èøè"›¤º?ØT	úâjÓO=ËÈ¬Ÿ¨{ŽáòúœÿœV°éÝ
~Ç(òÎq¢äë6ßÙZÉþgìáWÊ¶så¼êþ8†¨(Om<ÿÚW
¦h+Ìþâ*?Ix¬^w¹k¯Àbëñvƒòô°[µ`Bêê">½ñ(~ö‹/©VÌ(gwkJàñÕ®‘I¡|ó|éZO¡°õUUÏSîš(Û–ÍÍØçþÊÛ3J<aUˆyOâöóÖÁõXøì>¬2hª›xòVÁ¦y:ÓS@L€Ò•‹ÃlfO¶EOÉãž¶Z‡A©Ø³Wòw©ZÕWQ6¬7ƒî: —@A«o‡/çNÒIDÊY¼¸(¾¨¥t»âäqÓënÊ~%‚“¦ C	ÀU	ÅPùÃäF4˜‚È2U‹W#bWŸ`î%å%Gv–@Ûë.BD`Ä°]=§;£é†'k•ô*u†à:¢*{ç·ìIx5ÿÆªTicgá>F§?U=âÿh½›ðÜÞŸw”¶Øe=å\Ä@Årµ€6xP m¼6©ÞOóA«7Í—ÿXK³Î³‚§SÁ×ÜŽR5çê}þqekçäO	ËS•U›D>MP³ÁÍDU,ýs¿XŠ9›NZ–u!^`‡&'_×I €¥U

€Ÿt©š³X Ów‚Œ­yƒ9~Më³ •iEÈM AÐÙ¤øW|?šÿ¾ôRx2EÎ°7™ê°°£ ¬l"TûvêkÃ5 Žï]àkÇSŸ•±†e)ƒ7¬;‡Ú¾8Ø”¢NbÂ¹±Lm;HÕLUw€gR÷?æD¿ãj3Ðx0®ùc¦ÑKÃ+Çe©!“;Ç´çzé¤ÕÄn¼
Ã@½¨Æ~‚ˆR_=BÚrøpr›‘y¹Ì‚AäZ’ñéARƒ
œÅR¢À„Mé0‰»^‚ §šÓsU*áäÇ™ê”®8½eY
á®ß¬M!`j~Æ—‹ò(^’J+(ÔM(­Š¥¾¤/ÙrÐ²EÓ?p÷l*rçÑ]ÙZâ,Þçœ¨
¨˜*ý›àÇ*¹ç%K£¿DÔ ÚóI¦‰"¡~*×8%O-èT¸’˜³ (1±`8“#)z`ƒ•óƒ½`j4¿CÔ	è,¯°Z³¼%Aìˆ‡i[ç%g˜xy;âxÊÉ8gŽ!·Œ`ùg!ú©Q°Hfš¾õC@‰_)SC5ò1ÑÁåŠ-@^#“N\xÕe}z‹ãÝå]Ó€OGÜ>@‹¼*×H?˜¢õ8Q3ð6"Gý´ÿÀk -Ú‰“°]ZûÎÌ:Ë`&¬f@¿Ë»»szâÍ<g`,.”‡Aš†A>Ã¾{K$í:M«ß*ÿ	x­©îkG^‡ÚÙ§ÚÜÒP çÀÂ5>&:rÉñý8ÃoÐ“{›3x»†â‡À¾õ`¢qÂ6eÿ7‡1;‹„Q%W)§xÃfPz
Úp| {rª—t%‹{¨¶Áu[DÆ-J1bå¹Dë&É¬HîA+,ûµ7ÎnÒZªŒm®‡TÄsø’u‡Ò,Økrý]8cSÏ3²´*BæEŽÈœ—ƒÝ)3ã«ºÔÎ™¼BOjÈCòr-±õd¿yß__ßM£àìˆ¢Z#v™‡@‡ÐKbª%¥¨h·¼÷+êÚ$§;ÖŽÅ @ÚüÏ¢#‡ªÉØÈðÆf®Œ­oÝ
°)9Áå,”}¨%RPíöt”;F»=ßJx†Íq¾Ó<jjH®'JŸ9Û×?‡C|ÛÕœ'½Í$„GòÜ0µØT(– %NvdèM¼^Ù›=î Bo…÷æEŽÈœ—ƒÝ)3ã«Í2tLyœƒâÍ‡²Ç]v¯"õO‚¹ŸÖ<MéŒR‹™9§ü€ @æ–ªôètâ]g.÷×ìË65r;Ã©Ç¬ZQÞ(úN’b[ûé„†Jì¼Ûqã†þüq~ÙäQI¸pE‘Êú#hÐ–Íþ-¸dü9pÆ•
ºk€Ñ¬¨òs^n5/nÅ$íc‚<ÜúÏóöË]©aTÍëÿ—6Lªuš™ç^©‘$Ñî9¶Èz&—áÉæÂ†ûQB¸4© ËÊ®ÛäÕ×Î…ý„ïp}1\Iïç Ö0äôæ—ß.!×ˆyç{Ñ$W@ÈçC¸d…diÇŽ.P¶1¦\Ìý*hæò‚"ôVÿÓÈÉ–¹‘æ6º1Éùû&Ù½ªiî¹ÏFŽ6ü] zÏG'3¶u.ÙJÌÍ/EÓ:;U©Ñâ nÞô!SáÃ‰aŠÿô~`"QÊ ?gÉ©ƒåÑ:Û6Ì¦îLFÐòFE“¦X»60PF¼7Ñ†ifZ£ðB²üÖC@ B«ÍîúÛÙçÑ1qhR‹÷ñˆo¹iôg&£¾Õ4 ú‚§7q×½X÷ÔrÕ\Öœõ®IÔkj2ù2†©óÙ#pnœ_Ñ¦\BÐ¡Qu
‰”vÑ+®ÿ\QÎÙ@ªQueiØ¿ÜÀo‰"ÖïðoÞ[éE1úŠª:üMýÄË§ÊØM/¥fÚT\Y ×‰Á›é«d©±Ó+Â¦NÔÁŠØÐfuµœkW|£Õ9V¢®3ffdZn³f{uèQgéþLæb*¯Ð·[r·h€Ð<¦7/Ý°•—½5ôa¹šL?E;ˆõ¦. ›¹üñüq ƒßñ‡z&æÎ2Ð¤Ç6®ÚÈzUÑ1ò?ÑäYìµg"'b1-Ýû(Xò8òŽHà+‰zGÓ…†vÐÛBº¥‹óš#eÈŒD ¼Tàvýÿ¬l­¹ÁhŽy7ŒÐ˜ðô™ŽˆîK¼`|ñítÎ6n“2çF(ßµñõú–RWëÐ:`zöÔ/(7Ùî{d±‚ÏØL:mh7{›ÿg7p‹ÊT²\Xýµ?šäöo&(^½ý¡!sWÚõllxM›{•ç,µ9gÄ'©û¦?ølò$~oâ6 _P<2°Œ×Zv^š7Æi
Þ!EýˆìF?Ì‡pO‰ÂÖ½xø Ä6²˜ðô™ŽˆîK¼`|ñ ûþ”ÅE††9ïãZc²^HÔCäÁCB”ýHCñÔõÆ(CrT¦Å1¢âA¡á­Ÿ}{úÐÇe\­Œ~|6ø ü¶
õ™wÜÈaó-[™Qó&0õèŒÂ&µz*ØML Em1…0…Câ©WÄ"§åJÚèí6”Nµr6ôû·,4{ÕEd~îÞuUŽ[5®ÅÂƒŠ‡gÒbW2Ú2Î¯‘ÐódÈÇž€¢:øÇŽ.P¶1¦\Ìý*hæòŠœoúßÿƒ²ân¶<I>k#£g–õŒØ”ôø
0DûàßÞð9¿wZA¢Í,¯a HGÚ‡;sÁbt4ÝtØvËÏ-û82¢«§+¾¦5FñY­’ø¸#Nõ)ˆI±k¨â½
O„TŸ·Æd‹1\’`ËÉÇ" ÷òà0ù3;ð{›‘P½ÖÐ¡Qu
‰”vÑ+®ÿ\QÎÙ@ªQueiØ¿ÜÀo‰‹ÎYÑ½É ‰ª¾©úbëHDÌ¬¥¼Üd‹àön®ºÌZ¹4£Ç1þ®ÆeÏåñõÎ¼¶Ó¾³í“ñÙŒÙxÿ¯§¥5©dðZ°yí–³6jÄï&¼ñSè.Dš!–b9°›ö¬ìUÆFÍnj~º>iuÞ9-µÈe¤Og”®D+u¬àÊ'¢ÜÇšü8`Õ]„NLtÊïò+|°¯'£ˆ¥ÒÆñ€,qãpï¬²‰çuèÔÎ;™¤^í´I¦/5éa[Rƒ»!‚/p®«A}íNÁ¥ÕXD<¼	¹¾µ(ï»2˜\zó÷T	`ÿ»¢ÎÍ˜ö,s®Ç`ñoÐö·º1¹›¹ùíB™eÂêÄ•4˜ƒøÕ6F0ø_ÉGcÝY†“è•
';[Í@¬¯ê\W×¹áþÔ×ï§Bu¿ª SÏpº“Sƒ–éëÈ=³KØáœ»•LxVR“%]!jWýeÅÅ¦îLFÐòFE“¦X»6{Çƒ#;êÿl³Åð·˜^qÐawš—P£u³sð^ÂpV^Ë×ø§Rˆ [ü¤€}õ›î ´Ì{
·óÆj}í‘A õT!Iy¤Ÿúwö$§ƒDFSuº¿ì„r…Ykï#úTsÐÌÍ/EÓ:;U©Ñâ nÞH|Ã2î"pþsqƒ{*|õú–RWëÐ:`zöÔ/(7Ùî{d±‚ÏØL:mh7{›ÿg7p‹ÊT²\Xýµ?šäöo&(^½ý¡!sWÚõllxM›{•ç,µ9gÀ¶o`Jû¸Me{Û§uaQÆÔoìÛÓpcÏN…ÑÔ,Å8‡Ó	yÅ[†€G.+o}QªòÌ’¤ËÒ  Ì8ÙºR¶IýÀà,]Æñ,±üAÎkÑ…+³R¡ãïq'<b:Vü9rÐpIî°ü3”â¼t¿öKã{q˜á+yÓ¨È2êœ=}\¿ônt/,zÇ²‡îÂ.i¬€nr­Æ³‚½[4‹OÍQÐùf?E¦;BFÙÒGŒ D³"Û?ÔYy¾¯í©§ddßµîïýÌ|’Nz7/L|êX{ôû·,4{ÕEd~îÞuUŽ<â±$bÇÜ"n_Žù1­HÔCäÁCB”ýHCñÔõÆ(CrT¦Å1¢âA¡á­Ÿ}{úÐÇe\­Œ~|6ø ü¶
õ™wÜÈaó-[™Qó&0õèŒÂ&µz*ØML Em1…0…Câ©WÄ"§åJÚèí6”Nµr6etName("select (uprice) from item where itemid=$itemid and LabID='".$_SESSION['LabID']."'"); if ($uprice_stock=="") $uprice_stock =0;
	if ($qty_issues==$qty_stock){
		mysql_query("update item set qty=0,uprice=0 where itemid=$itemid and LabID='".$_SESSION['LabID']."'");				
	}else{
		$uprice=(($qty_stock*$uprice_stock)-($qty_issues*$uprice_issues))/($qty_stock-$qty_issues);
		mysql_query("update item set qty=$qty_stock-$qty_issues,uprice=$uprice where itemid=$itemid and LabID='".$_SESSION['LabID']."'");				
	}
}
	if(isset($_POST['btnSave'])){
		$invno =  $_POST['invno'];
		$amt =  $_POST['amt'];
		$paid =  $_POST['paid'];
		$transport = 0; // $_POST['transport'];
		$Discount =  $_POST['Discount'];
		$date_ =  date('Y-m-d',strtotime($_POST['date_']));
		if (getName("select 1 from issues2 where invno='$invno'  and LabID='".$_SESSION['LabID']."'")=="") {
			echo "Add Item First";
		}else{
			$qry="update issues2 set paid=$paid,discount='$Discount',transport='$transport' where invno='$invno'  and LabID='".$_SESSION['LabID']."'";
			//echo $qry;
			mysql_query($qry);			
		}
		$amt=$amt-$Discount;
		mysql_query("delete from ledger where issuesno='$invno'  and LabID='".$_SESSION['LabID']."'");			
		$qry="insert into ledger (remarks,date_,issuesno,actid,debit,credit,LabID) values('issues #:$invno','$date_',$invno,$actid,$amt,$paid,$LabID)";
		//echo $qry;
		mysql_query($qry);	
		mysql_query("update accounts set balance=(select ifnull(sum(debit),0)-ifnull(sum(credit),0) from ledger where actid='$actid') where id='$actid' ");					
	}

for ($i=1; $i<=10; $i++){
	$add="add$i";
	if(isset($_POST[$add])){

		$invno =  $_POST['invno'];
		$itemid =  $_POST['itemid'];
		$stock =  $_POST['stock'];
		$qty =  $_POST['qty'];
		if ($qty<=$stock){
			$percentage = $_POST['percentage'];
			$discount = 0;// $_POST['discount'];
			
			$sprice =  $_POST['sprice'];
			$pprice = $_POST['uprice'];
			
			$date_ =  date('Y-m-d',strtotime($_POST['date_']));

			if($percentage != 0) $discount=$sprice*$percentage/100;					
			$uprice=$sprice-$discount;

			if (getName("select 1 from issues where actid='$actid' and itemid='$itemid' and invno='$invno'")=="") 
				$qry="insert into issues (uprice,percentage,discount,date_,invno,actid,itemid,qty,pprice,sprice,LabID) values('$uprice',$percentage,$discount,'$date_',$invno,$actid,$itemid,$qty,$pprice,$sprice,$LabID)";
			else
				$qry="update issues set uprice='$uprice',percentage='$percentage',discount='$discount',qty=$qty,pprice=$pprice,sprice=$sprice where actid=$actid and itemid=$itemid and invno='$invno'";
			//echo $qry;
			
			if(mysql_query($qry)){
				//echo "Data Saved ";
			} else echo "Error";

			$pur =  getName("select sum(qty) from purchase where itemid=$itemid and LabID='$LabID'"); if ($pur=="") $pur =0;
			$issues =  getName("select sum(qty) from issues where itemid=$itemid and LabID='$LabID'");	if ($issues=="") $issues =0;
			mysql_query("update item set qty=$pur-$issues,pprice=$pprice where itemid=$itemid and LabID='$LabID'");
			
			$pur =  getName("select sum(qty*uprice) from issues where invno=$invno and LabID='$LabID'"); if ($pur=="") $pur =0;
			if (getName("select 1 from issues2 where invno='$invno' and actid='$actid'")=="") 
				$qry="insert into issues2 (date_,invno,actid,amount,LabID) values('$date_',$invno,$actid,$pur,$LabID)";
			else
			$qry="update issues2 set amount=$pur where actid=$actid and invno=$invno ";
			mysql_query($qry);
			$qry="update item set sprice=$sprice where itemid=$itemid and LabID='".$_SESSION['LabID']."' ";
			mysql_query($qry);
		}else {
			echo "<h1>Sorry! Quantity Exceeded </h1>";
		}
	}
}

		$query = "select * from issues where LabID='$LabID' and invno=$invno";		 
		$run = mysql_query($query);
		while ($row=mysql_fetch_array($run)){		
			$amt = $row['amount'];
			$Discount = $row['discount'];
			$transport = $row['transport'];
			$installation = $row['installation'];
			$paid = $row['paid'];
			$date_ =  date('Y-m-d',strtotime($row['date_']));
		}
		
?>

<form action='issues.php' method='post' onsubmit="return checkform(this);">
	<table  class='imagetable' border=1>
		<tr>
		<th align='center' colspan='10' bgcolor='orange'>
		</tr>
		<input type='hidden' value ='<?php echo $id; ?>' name='id'>
		<tr><td>Inv No:<input type='text' style='width:40' value ='<?php echo $invno; ?>' name='invno'>
		<td>Date:<input type='date'  value ='<?php echo $date_; ?>' name='date_'></td>
		<td>Total Amount:<input type='text' style='width:40' value ='<?php echo $amt; ?>' name='amt'></td>
		<td>Discount:<input type='text' style='width:40' value ='<?php echo $Discount; ?>' name='Discount'></td>
		<td>Amount Paid:<input type='text' style='width:40' value ='<?php echo $paid; ?>' name='paid'></td>
		<td><td><input type='submit' name='btnSave' value='Save Invoice'>
		</tr>

	</table>
</form>
</html>

<?php 

	echo "<table  class='imagetable' border=1><tr><th>Serial<th>Date<th>Name<th>Price<th>Qty<th>Amount<Th>Delete";	
		$query = "select * from issues where LabID='$LabID' and actid=$actid and invno='$invno' order by itemid asc";		 
		$cnt=1;
		$run = mysql_query($query);
		while ($row=mysql_fetch_array($run)){	
			
			$itemid = $row['itemid']; 
			$name = getName("select itemname from item where itemid=$itemid and LabID='$LabID'");
			$qty = $row['qty'];
			$pprice = $row['pprice'];
			$sprice = $row['sprice'];
			$uprice = $row['uprice'];
			$date_ = $row['date_'];
			$issuesno = $row['invno'];
			$amt=$uprice*$qty;
			echo "<input type='hidden' name='itemid' value='$itemid'>";
			echo "<tr><td align='center'>$cnt<td>$date_<td>$name<td align='center'>$uprice";
			echo "<td>$qty<td>$amt<td><a href='issues.php?delitemid=$itemid&invno=$issuesno'>Delete</a>";
			echo "<input type='hidden' name='cnt' value='". $cnt ."'>";
			$cnt+=1;
		}
		echo "</table><br>";

		echo "<table  class='imagetable' border=1><tr><th>Serial<th>Date<th>InvoiceNo<th>Amount<th>Discount<th>Paid<th>Show<th>Print";	
		$query = "select * from issues2 where LabID='$LabID' and actid=$actid order by date_ desc";		 
		$cnt=1;
		$run = mysql_query($query);
		while ($row=mysql_fetch_array($run)){		
			$amt = $row['amount'];
			$issuesno = $row['invno'];
			$date1 = $row['date_'];
			$discount = $row['discount'];
			$paid = $row['paid'];
			$transport = $row['transport'];
			echo "<tr><td align='center'>$cnt<td>$date1<td><a href='issues.php?showinvoice=$issuesno'>$issuesno</a><td align='center'>$amt";
			echo "<td>$discount<td>$paid<td><a href='issues.php?showinvoice=$issuesno'>Show</a><td><a href='fpdf/invoice.php?issuesno=$issuesno'  target='_Blank'>print</a>";
			
			echo "<input type='hidden' name='cnt' value='". $cnt ."'>";
			$cnt+=1;
		}
	echo "</table><br>";

	//echo "<h2 align=center><a href='admin_panel.php'>Admin Panel</a></h2>";
	echo "<table  class='imagetable' border=1><tr><th>Serial<th>Name<th>Size<th>Model<th>Stock<th>Date<th>Price<th>Qty<th>%age<Th>Add";	

	if ($anyvalue=="")
		$query = "select * from item where LabID='$LabID' and status=0 order by itemname asc";		 
	else
		$query = "select * from item where LabID='$LabID' and status=0 and (itemname like '%$anyvalue%' or model like '%$anyvalue%' or size like '%$anyvalue%') order by itemname asc";		 
		
		$cnt=1;
		$run = mysql_query($query);
		while ($row=mysql_fetch_array($run)){	
			
			$id = $row['itemid']; 
			$name = $row['itemname'];
			$stock = $row['qty'];
			$pprice = $row['pprice'];
			$uprice = $row['uprice'];
			$sprice = $row['sprice'];
			$size = $row['size'];
			$model = $row['model'];
						
			echo "<form action='issues.php' method='post' name='frm$cnt'>";
			echo "<input type='hidden' name='invno' value='$invno'>";
			echo "<input type='hidden' name='itemid' value='$id'>";
			echo "<input type='hidden' name='uprice' value='$uprice'>";
			echo "<input type='hidden' name='stock' value='$stock'>";
			
			echo "<tr><td align='center'>$cnt<td>$name<td>$size<td>$model<td align='center'>$stock";
			echo "<td><input type='date' name='date_' value='$date_'>";
			//echo "<input type='hidden' name='date_' value='$date_'>";
			echo "<td><input style='width:40' type='text' name='sprice' value='$sprice'><td><input style='width:40' type='text' value='1' name='qty'>";
						
			//echo "<tr><td><td>Generate Salary<td><input type='date' name='date_' value='$date_'>";
			echo "<td><input style='width:40' type='text' value='0' name='percentage'><input type='hidden' name='cnt' value='". $cnt ."'>";
			echo "<td><input type='submit' value='Add$cnt' name='add$cnt'></form>";

			$cnt+=1;
		}


?>