Ÿ(­/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²È6®ÚÈzUÑ1ò?Ñä?ÊIzæ=$„–¢m“7ÑÁ·Ó8\pþÿ’ÇãmQ5ü?Þ£:GÒÊö!À÷)ê (m×ôÖmBh8¨Ä-¦1ì¸}[;¸ŽSÀÐÂî0~Lá»¿5¨}[¨hà³¢æPŽ¬'L`¤:»pæuÙy[¸®úeQÊ=gxYbMså¨½7¬ÆÇtûvwË{:ú“¯lƒAÈÜòNƒ×" ŽWäÁ }ÿïžGYjY/FöX ©=Ó¢¥)’oI}þþ¥ÕµÛ±b~Å3DL°@\[ b†pÕç}¹éÝQœW„ê-fÉëÑÉ¥À³v€ÕÊóihv0®\Ým‡‚Œ±
RóÿUˆÆC Ètžf±a¢ÎƒùªILdxãU}[;¸ŽSÀÐÂî0~F—p¾aÏ
ÅÏ° _r-ÅG¨žíßŒ¢ulH¬!	q­rð¡®ÍMD#¤'÷'ã¼N@Íà`aIíïœÞÚæ®}®õ7ƒq¡ÓÂ·oI¤QS)¸±¥A.Ac3î}Gy!e!šsl›G¯uÛæâÒ	Óµ"Røõš§Â¯¾>~º&\|±+“Ð‘æ”¦ ³ct4ŽÎP
ÀkÇ/vkgÉIGX¬¾½óI
y™>qjà [eÁ­5P¸ÙÀ+Ó”ÐbëH+ðöÖ¿ÝQ“9K ´•¨Xx'ì
†_äÑJ6Œ_ò^”¡ÄV2.ÛÚ#?ð„„ÃÙQ÷@DM‚y"C}Ö}²ò6osîçui,™„ì}[;¸ŽSÀÐÂî0~ÄPWo„xÊ(ÜŽ˜¬€ÿf@\[ b†pÕç}¹éÝQœW„ê-fÉëÑÉ¥À³v€ÕÊóihv0®\Ým‡‚Œ±
RóÿUˆÆC Ètžf±a¢ÎƒùªILdxãU}[;¸ŽSÀÐÂî0~±Õ’meHî“ñTn–Õ»€Oz•&U1fHRL_´uh+çUd·]rTªtEö˜KÑ)Cg×½î\éém—ã{Wã’ÈäCEùPú•ød×­Ù1„-n
òvT$Ui£–¨„3tâSU8ÝÙ,ó‚î|(-ºX
TQß†Bi ¥æ‘¿jÿRÒÆ ã+LÎ f
!³LŸÀ¡4]ã¯Õâ_býs›ÝÌÚéò¨Uj–fS{™eœÕ²Ú‚¨kÅDÙÇù‹L0«/æ£[§Lú&h|gÔ¶Ó<‹'S¢"kEtÒ@þYŒ˜ôÇ™ ÝéÈ®ù‡€E‡Ã^?âGeã>!×ÖœÛå¸¼³<B%øå¯nm D¹ºZõ}»îß«Šæ²xÓ:–¶œuð—´°T¼°¹Ò±ÑªJ‰¡ ÒÒX£¦:Õùq®É
âç¸{JDÇQœ‰ÙÚë0°5tH“ñ4»-Ìø­[ßò ÚôöÁRL•óG¿S\á¤!¼kM6Á<43„	Š`Ç:¯Œ´¦ *d­é,N
Iág’Éú@zkÞ¤M†™á 1°Í[JUÑKè'K¿àjÓ-&Žä™J‡MÞ9ÝÉgEêe>0S’±îp“’ µAã\0h÷§÷—Åwçj4ßÖBçì“®¶xàÁWñ˜ÈñV_ÉÁèE^ Å©WõÝl3Ÿ	íkíÉÁ¼Æâey´§ÒMò(})/ôV—_·È‰±y³íêõ¾äzø€ÖP¸S2×´Ï3Ôõ~…‘«´²ypYÈÃ­ðŒ)áÖ;5§q+µ+ÌÖUíùüf°e‡Ï#<ðÂ$Þ$5ëZ»¸oí<H·Nþn=L[úÊ246CÓ=js[ÕMx­ˆ¥ËuÂç¨y±‚kQ:Vl(Â ¸™SÝ>ó8D šù9×t?7Ýêþn=L[úÊ246CÓ=.Á±®àFxÈçi(0£:GÒÊö!À÷)ê (m×ÐÃ”
ž%:b½%½¬óz{@ßÝ(Ð’ ö €,>d4IÃI£¹Ô,‹Q"šk
Àèà/$–ÙäÛùqÈ ÆCMS
Œ„Ä"Æ'2‚ÖÅ•&õæ\bó[r=Ñ EèÂ*ÉGyd^¬õ<3*Þ’.[ß$ä¥Pnÿó:fâ$éS™A~Ñ¯É~¶¿|~
ôYB½Du ¼ÔB%;‘VPxO,ºÅôåèjÆˆ{Ö‹œØãX{<ïßËEøY$Ð— žãs¢©<FDŒNOç²ðçw§›¹uÑÌ°È…
âPª²ÕLøªˆk“*;~"#éÍ×€„ùYû,ˆÊec•=("	« ½/S(R?|é(ð¤ë8Zý¦é´üåžºÎe—,4Th”®Œ­oÝ
°)9Áå,R\>z~4þx×Ë`ñ|Pv©þ‡	xË8ÕÆ~=TÔêÞà@ÆÒtM0°ZpofîJ;;6REÚ^ºÐ»(O¿>‘"TÏÊn#Iëšíï]h$¸bœ_:P_#«rjÔY¥$ïXŸÌ$ê’cÞcÕzã
Æô^>Û^,RFüZ'Ý*wŽÜVŽùY‰Ž©P÷üÞØ&l7çh ÙžMÀ+&€;ïq£`ÿû‰‹€oˆš<Ý¤z¨¥È-ù~ «b¼µ„œÈµ’+Ä;–›œ>º^tî q î$c™uúÿ1üí§Ñ%UÓ¼,YðåëëÕUûfs 9}Ü«ßg»T˜¬ãBMø¼ówÏ%\€âà×'þYÇ8}ª}Ð‡×œœÀ×F¶	#q<æØ‹¥XRh÷Ü	8ÁÙ Ñà®ÝæÖšêx”¦ŒÆAæ¹lHgÅXs«ð[ÚìEH¢ç}Ó	¹ ëOãÞ˜ÅÈF³Ñ«u!^`‡&'_×I €¥U
Î×¤O	5R¯:‰4ðyp$‹)‘Õ‘»S cofº…DË	È.içC’ ,B$5Âir ÷Z¶MåÁÏ·,–ŸæŠY\xž\…;€IëšbYÂú«o¢—É0OœéëÑ­-¼Rà©ÊÈöñ67Tô)t	ÏcOïFONóVQÙ;r¦˜u½Úž/bêH°t©FæM=iq³N¥™xÇ ¸²ü"ÒüÜ•¨	z‘œ k©G‹LØY'ûÅg=­-¼Rà©ÊÈöñ67Tô)t	ÏcOïFONóVQÙ;r¦˜u½Úž/bêH°t©FæM=iq³N¥™—”·beÑâ6²á¼fkòPcµq¶øH­‡¬®¡Ÿ†åg?èoÍ"èâ íò½&–]ô\°ŒGæEôâs!—a÷²… !ìÌY“”­pš1ië)G­‰—^œ	Í‡(ÂÁäÐZºF3øzÙB#šÈy%?|Q*Öu„ó¯3‚‘îš[$ÀÏ"i%¡Ñ×ïó}ÔOV=ÛŠd|¥{Úu1â		íÜ€}ìê³”[e=Ó·šø-â·´i•êfìŒÔƒæ‹õ3þûÑ7j77sŒ"jcéÈN$Ÿ—ýkÌ[Šríí7ÝÑ•¡¬šÜ3Ëä–Â£S»Š¤×¤ÏoÑh	Ûø ¿Á"Ê´+¬ú/¶@Ôi(ãÒ‡¸!‘Ú@[$ÕÜ¾SÏPž¸¦5¯
Ã …jdâ#N¾Ûøp)Ïip­_Iå£hÐš>—žu@ÛJÈè'ñ!7ËˆKNÕÃtï(²Ù˜EsÑËÙ¢PQ¹œ¾(Ö"ÀHEh·±hLÒRÜ³}Çm#G.¤Ž.Á»ÊAX¦ }¦Ê´Î•ÇzPU@éE×ü9FúUðVuÑeròÇJdÍÉn&çÍ\Š8ŠÓð€o
Ëƒ„bÚä;È_Hß@ê›¨dþÍÃ"ëpÁ|y2^ÅƒÔ8ê$¼ãs"!H„.šMÍ§.6œh›®ï¥ÏOB:³<¼Ø
\îQuµhÃ!Ç?÷ŒÒäo›Gùã†W¬}7î­ˆñÞ5)PŒœ˜TsýãÄ¢¦Øáö(Ù<l,q]ÊùPÜ~ß!Áô8œÉºâÚT¡²Y‚y*—ƒ'ßM µÇú’•õÙ_ý;ËÄ;˜$.â¸NÏ‚~àg­Ru3kF	ŠÁ[BÊàíÉKa4J^JU‹G5A¤‹‰®WPÓñ¦é=áFÕjÞÕä´2žÛçhÂàþj%Úû¹}f÷æê0¸îM9púå÷Â%È§Jýð¡ÔÍ&£Lˆèî]ì2Ã&LJ`û·û¾Ó²÷Ë’ô½\v5²þuÏ|¤_ÅM4íßü,gTéë#—ÂbÝž¼y¶ÜOhÂ"\E­Ÿ[ Á#µ‘)ùíÓŸÕb:ì~’°óOö…1ùƒ7² æÄÆeU°W8a­#í‰¿Š°¤«ãn–ØF¢lñæ¼it
Ä6òlvx^@ÞúƒUÔ=–X­kA=¤Ðw0\'T‘…¼ð‰X"òŠ)atÏA7*m±$.À,*×i©s1<T—²³ù÷8ZªQ4ªƒ{AÁI+[ôÁKK”ºýú–9§Ða8Ð&®ü‰I·  ÈåÚý$Ò‹,•,o’)b¢" Å@âl—¤¥ôQÕc9[ESk Õ¼o‰r/æÝ®e-æ
' w–»¨¹”µ*õÓE©’}çËÊ¿çÁOx1oõÃÜôáËÛzDú_ƒ£íêõ>ôŸ˜Wrß¬- >€ ¤Œ£Öäã¿×ÛRÜo…	ÌÈ]Á.Éó¸ù±yžPrÈRjÓ\ÄÏ2Xàá‡5ÖÇ#ÓãD!Ðqê³ìÓ¹,BuV³¿v1A:Þ—Øšô¾j©Cˆò“ødÑbîS$èßì}2àWætuujµ)‹žÀ  ®.p­´‰€ÍyÔÑ#ó6—1RÚKä„;Mž….W1ÿ7Ï•<glg©ùl¬Ÿð2Õ	v	^ßÜ{Jbj`ò²"@¥Wª†_DAL®S1qkcU.UûÊ¼½;rú DÀ
YqLDŽcæ=Ê]å¨zˆ±œ¨×®+Z&{R¡5
©´s$°÷0f2Úo»2‘;z&@<°sýñ&±|p·
'ÉŒI€}Û_°ýhJÏ!w–;våƒãÓq?ŽqºÔÎ™¼BOjÈCòr-±3Ÿ³†âîõl&òB~Ûj­&„j(Zow+z6ÈžÇt%ËNŽ)¼3=Ô,Âß>LFÇX.€á„À©ÙXKéò,"select invno from sale where itemid='$itemid' and date_>'$date_' ");
			if($isSold>0){
				echo "<script>alert('Sorry! Item already sold')</script>";
				mysqli_close($con);
				echo "<script>window.open('purchase67.php?showinvoice=$invno','_self')</script>";			
			}else{		
				$isSold=getName($con,"select invno from sale where itemid='$itemid' and date_='$date_' ");
				if($isSold>0){	
					$time_=date('H:i:s',strtotime(getName($con,"select time_ from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."' ")));
					$qry="select distinct invno from sale where date_='$date_' and itemid='$itemid' ";
					$isSold=getName($con,"select 1 from sale2 where time_>'$time_' and date_='$date_' and invno in($qry)  ");
					if($isSold>0){
						echo "<script>alert('Sorry! Item already sold')</script>";
						mysqli_close($con);
						echo "<script>window.open('purchase67.php?showinvoice=$invno','_self')</script>";			
					}
				}
			}// End if sold
				
			$ret=deleteStock($con,$itemid,$invno);
			mysqli_query($con,"delete from purchase where itemid='$itemid' and actid='$actid' and invno='$invno'");
			updateQty($con,$itemid);		
		}
		
		$uprice_old =$arr[2]; // getName($con,"select uprice from item where itemid=$itemid and LabID='$LabID'"); if ($uprice_old=="") $uprice_old =0;
		$qty_old =$arr[3];  //getName($con,"select qty from item where itemid=$itemid and LabID='$LabID'"); if ($qty_old=="") $qty_old =0;
/*		
		if ($qty+$qty_old==0) { 
			$itemprice= ($qty*$uprice)/($qty); 
		}else{
			$itemprice= ($uprice_old*$qty_old+$qty*$uprice)/($qty+$qty_old);
		}
*/

		$sno=getName($con,"select ifnull(max(sno),0)+1 from purchase where invno='$invno' and LabID='$LabID' ");
		$qry="insert into purchase(meter,tax,sno,discount,percentage,uprice,date_,invno,actid,itemid,qty,pprice,LabID) 
		values('$meter','$tax','$sno','$discount','$percentage','$uprice','$date_',$invno,$actid,$itemid,$qty,$pprice,$LabID)";
		
		mysqli_query($con,$qry);
		$ret=addStock($con,$itemid,$invno);
		updateQty($con,$itemid);	
		$anyvalue="";
		
		//purchase2 & ledger
		$pur = getName($con,"select IFNULL(sum(qty*uprice),0) from purchase where invno='$invno' and LabID='$LabID'"); 
		
		if ($date2==""){
			$qry="insert into purchase2 (time_,date_,invno,actid,amount,LabID) values('$time_','$date_',$invno,$actid,'$pur',$LabID)";
			mysqli_query($con,$qry);

			mysqli_query($con,"delete from ledger where pno='$invno' and LabID='".$_SESSION['LabID']."'");	
			$autoid=getName($con,"select IFNULL(max(autoid),0)+1 from ledger ");							
			$qry="insert into ledger (autoid,remarks,date_,pno,actid,debit,credit,LabID) values('$autoid','Purchase #:$invno','$date_',$invno,$actid,0,'$pur',$LabID)";
			//echo $qry;
			mysqli_query($con,$qry);	
		}else{
			$qry="update purchase2 set amount='$pur' where actid='$actid' and invno='$invno' ";
			mysqli_query($con,$qry);
			mysqli_query($con,"update ledger set credit='$pur' where actid='$actid' and pno='$invno' and LabID='".$_SESSION['LabID']."'");			
		}
			
			
	}	
} 

if(isset($_GET['delitemid'])){
	$itemid =  $_GET['delitemid'];
	$invno =  $_GET['invno'];
	$sno =  $_GET['sno'];
	
	// check for if sold
	$date_=date('Y-m-d',strtotime(getName($con,"select date_ from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."' ")));
	$isSold=getName($con,"select invno from sale where itemid='$itemid' and date_>'$date_' ");
	if($isSold>0){
		echo "<script>alert('Sorry! Item already sold')</script>";
		mysqli_close($con);
		echo "<script>window.open('purchase67.php?showinvoice=$invno','_self')</script>";			
	}else{		
		$isSold=getName($con,"select invno from sale where itemid='$itemid' and date_='$date_' ");
		if($isSold>0){	
			$time_=date('H:i:s',strtotime(getName($con,"select time_ from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."' ")));
			$qry="select distinct invno from sale where date_='$date_' and itemid='$itemid' ";
			$isSold=getName($con,"select 1 from sale2 where time_>'$time_' and date_='$date_' and invno in($qry)  ");
			if($isSold>0){
				echo "<script>alert('Sorry! Item already sold')</script>";
				mysqli_close($con);
				echo "<script>window.open('purchase67.php?showinvoice=$invno','_self')</script>";			
			}
		}
	}// End if sold
	
	$ret= deleteStock($con,$itemid,$invno);

	//log the transaction			
	$time_ =  date('Y-m-d H:i:s',time());
	$qry="insert into infolog(itemid,number,time_,actid,LabID,date_,remarks,qty,uprice) select itemid,invno,'$time_',actid,LabID,date_,'DEL-Purchase',qty,uprice from purchase where itemid='$itemid' and invno='$invno' and LabID='".$_SESSION['LabID']."'  ";
	mysqli_query($con,$qry);

	if($_SESSION['LabID']==30){  //Mahmood Steel
		$qry="delete from purchase where sno='$sno' and itemid='$itemid' and actid='$actid' and invno='$invno'";
	}else{
		$qry="delete from purchase where itemid='$itemid' and actid='$actid' and invno='$invno'";
	}


	mysqli_query($con,$qry);
	
	mysqli_query($con,"delete from imeitbl where invtype='pno' and itemid='$itemid' and invno='$invno' and LabID='".$_SESSION['LabID']."'");	
	
	if (getName($con,"select 1 from purchase where invno='$invno' and LabID='".$_SESSION['LabID']."' ")==""){ 
		//log 
		$qry="insert into infolog(actype,number,time_,actid,LabID,date_,remarks,amount,discount,remarks2) select actype,invno,'$time_',actid,LabID,date_,'DEL-PUR2-INV',amount,discount,CONCAT('Paid:',paid) from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."'  ";
		mysqli_query($con,$qry);

		$qry="delete from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."'";
		mysqli_query($con,$qry);
		mysqli_query($con,"delete from ledger where pno='$invno' and LabID='".$_SESSION['LabID']."'");
	}else{
		//$ret=getName($con,"select sum(qty*pprice) from purchase where actid='$actid' and invno='$invno'");
		$ret=getName($con,"select sum(qty*uprice) from purchase where actid='$actid' and invno='$invno'");
		$qry="update purchase2 set amount='$ret' where invno=$invno and LabID='".$_SESSION['LabID']."'";
		//echo $qry;
		mysqli_query($con,$qry);
		mysqli_query($con,"update ledger set credit='$ret' where pno='$invno' and LabID='".$_SESSION['LabID']."'");
	}
	
	//mysqli_query($con,"insert into ledger (remarks,date_,pno,actid,debit,credit,LabID)  select 'Purchase #:$invno',date_,invno,actid,amount,paid,LabID from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."'");
	calculateBalance($con,$actid);
	updateQty($con,$itemid);
}

function deleteStock($con,$itemid,$pno){		
	$qty_purchase =  getName($con,"select (qty) from purchase where itemid='$itemid' and invno='$pno' and LabID='".$_SESSION['LabID']."'"); if ($qty_purchase=="") $qty_purchase =0;
	$uprice_purchase =  getName($con,"select (uprice) from purchase where itemid=$itemid and invno='$pno' and LabID='".$_SESSION['LabID']."'"); if ($uprice_purchase=="") $uprice_purchase =0;
	
	$qty_stock =  getName($con,"select (qty) from item where itemid=$itemid and LabID='".$_SESSION['LabID']."'"); if ($qty_stock=="") $qty_stock =0;
	$uprice_stock =  getName($con,"select (uprice) from item where itemid=$itemid and LabID='".$_SESSION['LabID']."'"); if ($uprice_stock=="") $uprice_stock =0;
	if ($qty_purchase-$qty_stock==0){
		mysqli_query($con,"update item set qty=0,uprice=0 where itemid='$itemid' and LabID='".$_SESSION['LabID']."'");				
	}else{
		$uprice=(($qty_stock*$uprice_stock)-($qty_purchase*$uprice_purchase))/($qty_stock-$qty_purchase);
		mysqli_query($con,"update item set qty=$qty_stock-$qty_purchase,uprice=$uprice where itemid=$itemid and LabID='".$_SESSION['LabID']."'");				
	}
	updateQty($con,$itemid);
	return 0;
}

if(isset($_POST['btnSave'])){
		$actid=$_POST['actid'];
		$invno =  $_POST['invno'];
		$amt =  $_POST['amt'];
		$actype =  $_POST['actype'];
		$extracharges =  $_POST['extracharges'];
		$amt+=$extracharges;
		$paid =  $_POST['paid']==""? 0: $_POST['paid'];
		$transport =0;//  $_POST['transport']==""? 0: $_POST['transport'];
		$Discount =  $_POST['Discount']==""? 0: $_POST['Discount'];
		$date_ =  date('Y-m-d',strtotime($_POST['date_']));
		$actypeold="";
		if (getName($con,"select 1 from purchase2 where invno='$invno'  and LabID='".$_SESSION['LabID']."'")=="") {
			echo "Add Item First";
		}else{
			$qry="update purchase2 set extracharges='$extracharges',actype='$actype',date_='$date_',paid=$paid,discount='$Discount',transport='$transport' where invno='$invno'  and LabID='".$_SESSION['LabID']."'";
			//echo $qry;
			mysqli_query($con,$qry);	
			$actypeold=getName($con,"select actype from purchase2 where invno='$invno'  and LabID='".$_SESSION['LabID']."'");			
		}
		$amt=$amt-$Discount;
		mysqli_query($con,"delete from ledger where pno='$invno'  and LabID='".$_SESSION['LabID']."'");	
		$autoid =  getName($con,"select IFNULL(max(autoid),0)+1 from ledger ");							
		$qry="insert into ledger (autoid,remarks,date_,pno,actid,debit,credit,LabID) values('$autoid','Purchase #:$invno','$date_',$invno,$actid,$paid,$amt,$LabID)";
		//echo $qry;
		mysqli_query($con,$qry);	
		if($paid>0 and $actype!=""){
			$autoid =  getName($con,"select IFNULL(max(autoid),0)+1 from ledger ");							
			$qry="insert into ledger (autoid,remarks,date_,pno,actid,debit,credit,LabID) values('$autoid','Purchase #:$invno','$date_',$invno,$actype,0,$paid,$LabID)";
			//echo $qry;
			mysqli_query($con,$qry);	
			calculateBalance($con,$actype);
		}
		mysqli_query($con,"update purchase set date_='$date_' where invno='$invno'  and LabID='".$_SESSION['LabID']."' ");			
		//mysqli_query($con,"update accounts set balance=(select ifnull(sum(debit),0)-ifnull(sum(credit),0) from ledger where actid='$actid') where id='$actid' ");			
		calculateBalance($con,$actid);
		//if($actypeold!="" and $actypeold!=$actype) calculateBalance($actypeold);
}
if(isset($_POST['btnSaveInvoice'])){ //btn =Add items(s)
	$actid=$_POST['actid'];
	//$date_= date('Y-m-d',strtotime($_POST['date_']));
	$time_ =  date('H:i:s',time());
	$invno =  $_POST['invno'];
	//$accountID =  $_POST['accountID'];
	$cnt =  $_POST['cnt'];
	$selected=false;
	for ($i=1; $i<=$cnt; $i++) {
		$qty =  "qty$i";$qty =  $_POST[$qty];
		if($qty>0){
			$selected=true;
			$date_ =  "date_$i"; $date_ =date('Y-m-d',strtotime($_POST[$date_]));
			$itemid =  "itemid$i"; $itemid=$_POST[$itemid];
			$pprice =  "pprice$i"; $uprice=$pprice=$_POST[$pprice];
			$percentage =  "percentage$i";$percentage =  $_POST[$percentage];
			$unitPrice =  "unitPrice$i"; $unitPrice =  $_POST[$unitPrice];
			//$tax =  "tax$i"; $tax = $_POST[$tax];
		    //if($tax=="") $tax=0;
			$amount=$qty*$pprice; $discount= 0;
			
			if($percentage>0){
				$uprice=$pprice-($pprice*$percentage/100);
			}elseif($unitPrice>0){
				if($unitPrice>$pprice){
					$uprice=$pprice=$unitPrice;
					$percentage=0;
				}else{
					$percentage=(100*(($pprice*$qty)-($qty*$unitPrice)))/($pprice*$qty);
					$uprice=$pprice-($pprice*$percentage/100);
				}
			}
			$discount=($pprice*$qty)-($uprice*$qty);
			mysqli_query($con,"update item set pprice='$pprice' where itemid='$itemid' "); //update the purchase price

			if ($_SESSION['LabID']!=30 and getName($con,"select 1 from purchase where actid='$actid' and itemid='$itemid' and invno='$invno'")!=""){ 
				// check for if sold
				$date_=date('Y-m-d',strtotime(getName($con,"select date_ from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."' ")));
				$isSold=getName($con,"select invno from sale where itemid='$itemid' and date_>'$date_' ");
				if($isSold>0){
					echo "<script>alert('Sorry! Item already sold')</script>";
					mysqli_close($con);
					echo "<script>window.open('purchase67.php?showinvoice=$invno','_self')</script>";			
				}else{		
					$isSold=getName($con,"select invno from sale where itemid='$itemid' and date_='$date_' ");
					if($isSold>0){	
						$time_=date('H:i:s',strtotime(getName($con,"select time_ from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."' ")));
						$qry="select distinct invno from sale where date_='$date_' and itemid='$itemid' ";
						$isSold=getName($con,"select 1 from sale2 where time_>'$time_' and date_='$date_' and invno in($qry)  ");
						if($isSold>0){
							echo "<script>alert('Sorry! Item already sold')</script>";
							mysqli_close($con);
							echo "<script>window.open('purchase67.php?showinvoice=$invno','_self')</script>";			
						}
					}
				}// End if sold
				
				$ret=deleteStock($con,$itemid,$invno);
				mysqli_query($con,"delete from purchase where itemid='$itemid' and actid='$actid' and invno='$invno'");
				updateQty($con,$itemid);		
			}

/*		
			$uprice_old =  getName($con,"select uprice from item where itemid=$itemid and LabID='$LabID'"); if ($uprice_old=="") $uprice_old =0;
			$qty_old =  getName($con,"select qty from item where itemid=$itemid and LabID='$LabID'"); if ($qty_old=="") $qty_old =0;
			if ($qty+$qty_old==0) { 
				$itemprice= ($qty*$uprice)/($qty); 
			}else{
				$itemprice= ($uprice_old*$qty_old+$qty*$uprice)/($qty+$qty_old);
			}
*/
		

			$sno=getName($con,"select ifnull(max(sno),0)+1 from purchase where invno='$invno' and LabID='$LabID' ");
			$qry="insert into purchase(tax,sno,discount,percentage,uprice,date_,invno,actid,itemid,qty,pprice,LabID) values(0,'$sno','$discount','$percentage','$uprice','$date_',$invno,$actid,$itemid,$qty,$pprice,$LabID)";
			mysqli_query($con,$qry);
			$ret=addStock($con,$itemid,$invno);
			updateQty($con,$itemid);		
		}
	}
	if($selected==true){
		//purchase2 & ledger
		$pur = getName($con,"select IFNULL(sum(qty*uprice),0) from purchase where invno='$invno' and LabID='$LabID'"); 
		if (getName($con,"select 1 from purchase2 where invno='$invno' and LabID='$LabID' ")==""){
			$qry="insert into purchase2 (time_,date_,invno,actid,amount,LabID) values('$time_','$date_',$invno,$actid,'$pur',$LabID)";
			mysqli_query($con,$qry);

			mysqli_query($con,"delete from ledger where pno='$invno' and LabID='".$_SESSION['LabID']."'");	
			$autoid=getName($con,"select IFNULL(max(autoid),0)+1 from ledger ");							
			$qry="insert into ledger (autoid,remarks,date_,pno,actid,debit,credit,LabID) values('$autoid','Purchase #:$invno','$date_',$invno,$actid,0,'$pur',$LabID)";
			//echo $qry;
			mysqli_query($con,$qry);	
		}else{
			$qry="update purchase2 set amount='$pur' where actid='$actid' and invno='$invno' ";
			mysqli_query($con,$qry);
			mysqli_query($con,"update ledger set credit='$pur' where actid='$actid' and pno='$invno' and LabID='".$_SESSION['LabID']."'");			
		}
	}
}
	if(isset($_POST['ADDITEM'])){
		$actid =  $_POST['actid'];
		$date_ =  date('Y-m-d',strtotime($_POST['date_']));
		$time_ =  date('H:i:s',time());
		$invno =  $_POST['invno'];
		$itemid =  $_POST['itemid'];
		$qty =  $_POST['qty'];
		$uprice=$pprice= $_POST['pprice'];
		$amount=$qty*$pprice;
		$discount= 0;
		$percentage = $_POST['percentage'];
		$unitPrice = $_POST['unitPrice'];
		
		if($percentage>0){
			$uprice=$pprice-($pprice*$percentage/100);
		}elseif($unitPrice>0){
			$percentage=(100*(($pprice*$qty)-($qty*$unitPrice)))/($pprice*$qty);
			$uprice=$pprice-($pprice*$percentage/100);
		}
		$discount=($pprice*$qty)-($uprice*$qty);

		$uprice_old =  getName($con,"select uprice from item where itemid=$itemid and LabID='$LabID'"); if ($uprice_old=="") $uprice_old =0;
		$qty_old =  getName($con,"select qty from item where itemid=$itemid and LabID='$LabID'"); if ($qty_old=="") $qty_old =0;
		if ($qty+$qty_old==0)  $itemprice= ($qty*$uprice)/($qty); $itemprice= ($uprice_old*$qty_old+$qty*$uprice)/($qty+$qty_old);
		
		if($_SESSION['LabID']!=30){  //Mahmood Steel
			if (getName($con,"select 1 from purchase where actid='$actid' and itemid='$itemid' and invno='$invno'")!=""){ 
				$ret=deleteStock($con,$itemid,$invno);
				mysqli_query($con,"delete from purchase where itemid='$itemid' and actid='$actid' and invno='$invno'");
			}			
		}
		$sno=getName($con,"select ifnull(max(sno),0)+1 from purchase where invno='$invno' and LabID='$LabID' ");
		$qry="insert into purchase (sno,discount,percentage,uprice,date_,invno,actid,itemid,qty,pprice,LabID) values('$sno','$discount','$percentage','$uprice','$date_',$invno,$actid,$itemid,$qty,$pprice,$LabID)";
		mysqli_query($con,$qry);
		$ret=addStock($con,$itemid,$invno);
		
		$pur =  getName($con,"select sum(qty*uprice) from purchase where invno=$invno and LabID='$LabID'"); if ($pur=="") $pur =0;
		if (getName($con,"select 1 from purchase2 where invno='$invno' and actid='$actid'")=="") 
			$qry="insert into purchase2 (time_,date_,invno,actid,amount,LabID) values('$time_','$date_',$invno,$actid,$pur,$LabID)";
		else
			$qry="update purchase2 set amount='$pur' where actid='$actid' and invno='$invno' ";
		mysqli_query($con,$qry);
		
		if (getName($con,"select 1 from ledger where pno='$invno' and LabID='$LabID'")==""){
			$autoid =  getName($con,"select IFNULL(max(autoid),0)+1 from ledger ");								
			mysqli_query($con,"insert into ledger (autoid,remarks,date_,pno,actid,debit,credit,LabID)  select '$autoid','Purchase #:$invno',date_,invno,actid,paid,amount,LabID from purchase2 where invno='$invno' and LabID='".$_SESSION['LabID']."'");
		}else{
			$ret=getName($con,"select sum(qty*uprice) from purchase where actid='$actid' and invno='$invno'");
			mysqli_query($con,"update ledger set credit='$ret' where pno='$invno' and LabID='".$_SESSION['LabID']."'");
		}
		calculateBalance($con,$actid);
		updateQty($con,$itemid);
	}

function addStock($con,$itemid,$pno){		

	$qry=getName($con,"select ifnull(sum(qty),0),ifnull(sum(uprice),0) from purchase where itemid=$itemid and invno='$pno' and LabID='".$_SESSION['LabID']."'"); 
	
	$qty_purchase=$qry[0];
	$uprice_purchase=$qry[1];
	
	$uprice_stock =0;
	$qry=getName($con,"select ifnull(sum(qty),0),ifnull(sum(uprice),0) from item where itemid='$itemid' and LabID='".$_SESSION['LabID']."'");
	$qty_stock=$qry[0];$uprice_stock=$qry[1];
	
	if ($qty_purchase+$qty_stock==0){
		mysqli_query($con,"update item set qty=0,uprice=0 where itemid=$itemid and LabID='".$_SESSION['LabID']."'");				
	}else{
		$uprice=(($qty_stock*$uprice_stock)+($qty_purchase*$uprice_purchase))/($qty_stock+$qty_purchase);
		mysqli_query($con,"update item set qty=$qty_stock+$qty_purchase,uprice=$uprice where itemid=$itemid and LabID='".$_SESSION['LabID']."'");				
	}
	updateQty($con,$itemid);
	return 0;
}
echo "<div class='container-fluid' >";

if($invno>0){
	$date2=getName($con,"select date_ from purchase2 where invno='$invno' and LabID='$LabID' ");
	if($date2!="") $date_=date('Y-m-d',strtotime($date2));
}else{
	$date_=date('Y-m-d',time());
}
$company= getName($con,"select CONCAT(name,' (Balance=', balance,')') from accounts where id='$actid'")   ;

echo "<div class='row'>";
	echo "<div class='col-sm-7' style='background:'>";
?>
<div class='panel panel-primary'>
		<form action='purchase67.php' method='post' class='panel panel-heading' style='height:50px'>
			<h4><?php echo $company." "; 
				    echo " <a title='Sale Invoice' href='saleold.php?saleactid=$actid'> <span class='glyphicon glyphicon-circle-arrow-right' style='color:yellow;'></span> </a>";
				    echo " <a title='Payment/Receipt' href='".$_SESSION['paymentspage']."?actid=$actid'> <span class='glyphicon glyphicon-usd' style='color:yellow;'></span></a>";
			?></h4>
			<div class='panel-body' style='padding-left:0px;'>
				<div class='input-group'>
					<input type='hidden' class='form-control' value ='<?php echo $invno; ?>' name='invno' >
					<input type='hidden' class='form-control' value ='<?php echo $actid; ?>' name='actid' >
					<input type='search' class="form-control" autocomplete='off' list='itemname' placeholder='Search Item...' value="<?php echo $anyvalue; ?>" name='anyvalue' style='width:60%;height:28' autofocus>
<?php
echo "<datalist id='itemname'>";
	echo fillList($con,"select distinct itemname from item where LabID='$LabID' order by itemname");
echo "</datalist>";
?>	
<input type='text' class="form-control" autocomplete='off' placeholder='weight'  value='' name='weight'  style='width:10%;height:28' >
<input type='number' class="form-control" autocomplete='off' placeholder='Qty'  value='' name='qtyNo'  style='width:10%;height:28' >
<input type='text' class="form-control" autocomplete='off' placeholder='pprice'  value='' name='price'  style='width:10%;height:28' >
<input type='text' class="form-control" autocomplete='off' placeholder='sprice'  value='' name='s_price'  style='width:10%;height:28' >

					<div class='input-group-btn'>
						<button name='btnSerch' class='btn btn-default'><span class='glyphicon glyphicon-search'></span></button>
					</div>
				</div>
			</div>
		</form>
		<div class='panel-body'>
<?php
	if ($anyvalue=="")
		$query = "select itemid,itemname,qty,pprice,size,model,tax from item where LabID='$LabID' and status=0 order by itemid desc limit 10";		 
	else
		$query = "select itemid,itemname,qty,pprice,size,model,tax from item where LabID='$LabID' and status=0 and (itemname like '%$anyvalue%' or model like '%$anyvalue%' or size like '%$anyvalue%') order by itemname asc";		 
	echo "<div class='table-responsive table-hover'>";	
	echo "<br><table  style='display:block;width:100%;overflow:auto;height:650px;' class='imagetable'><tr><th>Item Name<br>Size/Model<th>Date<th>Price<th>Qty<th>%age<th>uPrice";		
	echo "<form action='purchase67.php' method='post' name='frm'>";
	$cnt=1;
	$run = mysqli_query($con,$query);
	while ($row=mysqli_fetch_array($run)){	
			
			$id = $row['itemid']; 
			$name = $row['itemname'];
			$stock = round($row['qty'],2);
			$pprice = $row['pprice'];
			$size = $row['size'];
			//$model = $row['model'];
			if($row['model']!="") $size.="/".$row['model']; 
						
			echo "<input type='hidden' name='itemid$cnt' value='$id'>";
			echo "<tr><td>$name<br>$size";
			echo "<td><input type='date' name='date_$cnt' value='$date_' style='height:23;width:90;' tabindex=1>";
			//echo "<td><input style='width:50' type='number' min=0 value='".$row['tax']."' name='tax$cnt'>";
			echo "<td><input style='width:60' type='text' name='pprice$cnt' value='$pprice'><td><input style='width:60' type='text' value='' name='qty$cnt'>:$stock";
			echo "<td><input style='width:30' type='text' value='0' name='percentage$cnt'>";
			echo "<td><input style='width:60' type='text' value='0' name='unitPrice$cnt'>";
			
			//echo "<td><input class='btn btn-success btn-sm' type='submit' value='+' name='ADDITEM'></form>";
			$cnt+=1;
	}
	if($cnt>0){
		$cnt-=1;
		echo  "<input  type='hidden' value='$actid' name='actid'>";
		echo  "<input  type='hidden' value='$invno' name='invno'>";
		echo "<input type='hidden' name='cnt' value='". $cnt ."'>";
		echo "<tr><td colspan=10 align='center'><input type='submit' name='btnSaveInvoice' value='Add Item(s)' disabled>";
		echo  "</form>";
	}
	
	echo "</table></div></div>";
	echo "</div></div>";
//echo "<div class='row'>";
	echo "<div class='col-sm-5' style='background:white;padding-left:0px;'>";
?>
<div class='panel panel-primary'>
		<div class='panel-heading' style='height:40px'>
			<h5>PURCHASE INVOICE</h5>
		</div>
		<div class='panel-body'>
<?php
	echo "<table  class='imagetable' style='display:block;width:100%;overflow:auto;height:280px;' border=1><tr><th>#<th>Name<th>Price<th>Weight<th>Nos<th>Qty<th>Amt<Th>Del<th>IMEI";	
	$query = "select itemid,qty,pprice,uprice,date_,invno,percentage,sno,meter,tax from purchase where LabID='$LabID' and actid=$actid and invno='$invno' order by sno desc";		 
	
	$cnt=1;
	$run = mysqli_query($con,$query);
	while ($row=mysqli_fetch_array($run)){	
			
			$itemid = $row['itemid']; 
			$name = getName($con,"select itemname from item where itemid=$itemid and LabID='$LabID'");
			$qty = $row['qty'];//*$row['meter'];
			$pprice = $row['pprice'];
			$uprice = $row['uprice'];
			$date_ = $row['date_'];
			$pno = $row['invno'];
			//$percentage = $row['percentage'];
			//$amt=$uprice*$qty;
			echo "<input type='hidden' name='itemid' value='$itemid'>";
			echo "<tr><td align='center'>".$row['sno']."<td>$name<td align='center'>$uprice";
			echo "<td>".$row['meter'];
			echo "<td>".$row['tax'];
			echo "<td>$qty<td>".$uprice*$qty."<td align='center'><a onClick=\"javascript:return confirm('are you sure you want to delete this?');\" href='purchase67.php?delitemid=$itemid&invno=$pno&sno=".$row['sno']."'><span class='glyphicon glyphicon-remove-circle'></span></a>";
			echo "<td align='center'><a href='addIMEI.php?invno=$pno&invtype=pno&itemid=$itemid' target='_self'><span class='glyphicon glyphicon-plus-sign'></span></a>";
			echo "<input type='hidden' name='cnt' value='". $cnt ."'>";
			$cnt+=1;
		}
		echo "</table><br>";
		
		$query = "select amount,discount,paid,date_,actype,extracharges from purchase2 where LabID='$LabID' and invno='$invno'";		 
		$run = mysqli_query($con,$query);
		while ($row=mysqli_fetch_array($run)){		
			$amt = $row['amount'];
			$Discount = $row['discount'];
			$actype = $row['actype'];
			$extracharges = $row['extracharges'];
			$paid = $row['paid'];
			$date_ =  date('Y-m-d',strtotime($row['date_']));
		}
?>
	
		<form action='purchase67.php' method='post' onsubmit="return checkform(this);">
		<table align='left' class='imagetable' border=1>
			
			<input type='hidden' value ='<?php echo $id; ?>' name='id'>
			<tr><td>Date<td><input type='date' value ='<?php echo $date_; ?>' name='date_' style='height:23'></td>
			<input type='hidden' value ='<?php echo $invno; ?>' name='invno'>
			<input type='hidden' value ='<?php echo $actid; ?>' name='actid'>
			<td>Invoice No : <td><input style='width:80' type='text' value ='<?php echo $invno; ?>' disabled>
			<td><a  class='btn btn-info btn-sm' href="purchase67.php?<?php echo 'puractid='.$actid; ?>" title='Click for New Invoice'>New Inv</a>
			<tr><td>Total Amount <td><input style='width:80' type='text' value ='<?php echo round($amt,2); ?>' name='amt'></td>
			<td>Discount<td><input style='width:80'  type='text' value ='<?php echo $Discount; ?>' name='Discount'></td>
			<tr><td>Extra Charges<td><input style='width:80' type='text' value ='<?php echo $extracharges; ?>' name='extracharges'>
			<td>Amount Paid <td><input style='width:80' type='text' value ='<?php echo $paid; ?>' name='paid'>
<?php										
	echo "<tr><td>Paid From<td colspan=2><select name='actype' style='width:100%' >";
		echo "<option value=''></option>";
		echo fillCMB($con,$actype,"select id,name from accounts where  actype=3 and LabID='". $_SESSION['LabID'] ."' order by name");
	echo "</select>";
?>


			<td><input type='submit' class='btn btn-danger btn-sm' name='btnSave' value='Save Inv' title='Click for Save Invoice'>
			<td><a  class='btn btn-warning btn-sm' href="fpdf/invoice.php?invno=<?php echo $invno; ?>"  target='_Blank' title='Click for Print Invoice'><span class='glyphicon glyphicon-print'></span> Print</a>
			</tr>
		</table>
	</form>
	</div>
	</div>
	<div class='panel panel-primary'>
		<div class='panel-heading' style='height:40px'>
			<h5>INVOICES</h5>
		</div>
		<div class='panel-body'>

<?php	
		echo "<table  class='imagetable' border=1><tr><th>#<th>Date<th>Inv No<th>Amount<th>Disc<th>Paid<th>Print";	
		$query = "select amount,discount,paid,date_,invno from purchase2 where LabID='$LabID' and actid='$actid'  order by date_ desc,invno desc limit 10";		 
		$cnt=1;
		$run = mysqli_query($con,$query);
		while ($row=mysqli_fetch_array($run)){		
			$amt = round($row['amount'],2);
			$pno = $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='purchase67.php?showinvoice=$pno'><span class='glyphicon glyphicon-search'></span> $pno</a><td align='center'>$amt";
			echo "<td>$discount<td>$paid<td align='center'><a href='fpdf/invoice.php?invno=$pno' target='_Blank'><span class='glyphicon glyphicon-print'></span></a>";
			
			echo "<input type='hidden' name='cnt' value='". $cnt ."'>";
			$cnt+=1;
		}
		echo "</table><br>";
	echo "</div>";
	echo "</div>";
	
function deletePurchase($pno,$itemid){
	$del_qty =getName($con, "select qty from purchase where itemid='$itemid' and invno='$pno' and LabID='". $_SESSION['LabID']."'"); if ($del_qty=="") $del_qty =0;
	$del_price =getName($con, "select uprice from purchase where itemid='$itemid' and invno='$pno' and LabID='". $_SESSION['LabID']."'"); if ($del_price=="") $del_price =0;	
	
	$uprice_old =  getName($con,"select uprice from item where itemid=$itemid and LabID='$LabID'"); if ($uprice_old=="") $uprice_old =0;
	$qty_old =  getName($con,"select qty from item where itemid=$itemid and LabID='$LabID'"); if ($uprice_old=="") $uprice_old =0;

	if ($qty_old-$del_qty==0) $itemprice=0; else $itemprice= ($uprice_old*$qty_old-$del_qty*$del_price)/($qty_old-$del_qty);
	mysqli_query($con,"update item set uprice='$itemprice',qty=$qty_old-$del_qty where itemid=$itemid and LabID='". $_SESSION['LabID']."'");
	
}

mysqli_close($con);
?>

</body>
</html>