ªI:Ü«¶cØ+¾ÆñÌ]Yîˆ”F3KD$ˆ×²>Wœ—\âx6t¹±ÿ)"± àÝ>ýk0)þH”Áö×2†¿û„‰$€{#ÚB+vlÇ-³Ð‘UPo«³ •iXìåî‰FhFTøW	§+Ó3¡•ç¿¿„1¶ØvÎW(gZsò‡óèd*î²,ŽÁè6¹{@“Ì)™Ž13Lë„‘EFw±ºûzÿ¬˜ðÊ™Ú¿%E$I‘hgê…“ÀB¸ƒÛÅwóÏš6;íj@°A¶Z‰–[_q£Á-É|Ðþ'Ñ¡'l!L{ÛBø9¾½RO—<{Î¨XÉ¦ûëà_=2èÕ€<KœT(Oýµä/“îÑ‚±¿ƒ—.q@V»yÕ€™R÷Æ>¶(J*þ9Ý?øî¥d\Œ¯®¿´.GÙÔX,Þ"¿ÒüŒ)ý-¨zuÕOœ¬`)K?ê—|Â¼Úe×ÜMÈütJLHBgöTHm°{Ñ‘íÙL¥|ûÐÃŽ±ï$ˆCmíéýØ±ð£ìØ<c=22iH8Xãç¶ÑæÅµ=Íw4üõ“Jº†²…n$Å™'ÄÔŠæ’1n¸;«ŽOe:`ì¥Dv~ºÛs×:Åž>k……O]mFP€#Ê¹èÜm1R ¶ýÅâåáFÈºn7ƒ¶“éçâm†âÏ·èŠo»ÆƒtŸú K	\,“3n4LÅèÚî
¥OÝ®ªÒ$Î–¦d´Fœ£_‡RxÌVðr„	#}–fÅ¦[|v´º©b¨TË·VëO–ùEéÀ‘Âd¨MÉ±0XGX›¡$Eyè§ê*xX.×ŠSõDDPíÖã^ÕpÝFÔË²ÿ`7‡Ì»Õ¯ëI Yùç÷šŽßW `T3¢ÚV&ËÁZ‹æThCô¸ZQ’+”ipÛn:
ÕQOªRÏ,¨™ÃL†¦K®P¡ŒXÒIÕ7ÌÛV	éMM#a+ÔfÈ<"¤´‰…7Ógœ”¼Ïôvyvœ£.¨’Þªëf•t®±¥†qwžBäçç/QÿB¥ÜöCØöW;-Zè!å+«ˆTPËµ{²Ø4‡Ü±ÒO„çôW¦åMÆ)íK¾ÞR‚ß¡…Ç¾±½ÙÎuú:I„ó<PÓrPQÿB¥ÜöCØöW;-Zè!å+«ˆTPËµ{²Ø42ÈþNW›…ë=Íÿâƒ¾£zk”B0*±É‡~é·ƒAð=ŒÂfˆ|xñÛÑxþ(ŒŒ\Ã&Àç‰ÚMåì¾¹RM:O$( ¼@½äS¥Å4[U:p‹>Ÿ..ÎíQÐ0(­ÏOŒ/'H‹7¤b5Ï…#DxIQ•škâÂók©Ù°Çñ„øïZr}WF^Hf_”lˆÑÒ«}ŠqWþ8·?Oè`á)jü¯! ílÆf[ó~ðófè·¥…”›y}]?Çˆ,ã÷õÿ„, ´¶õì\Šnø=Ô‡A¸†?.KH·~†VÕø¨}ük2IÕRa—Ý!Éõ3:Îê‰[ÙódûêÛpÚïsªˆì é¡‹Â˜ÃàŽÝ{! ] ï§ˆš\éïÂMÆR §û±s‹ý®6è†CO¾fÕª×°°Ék õk}ÒµV9¦«Ó7¤çoô¤¶Õ…©ˆUYªu»…N˜…–hŽúúN¿®8*R\gì££RÃoÜÿ7¤b5Ï…#DxIQ•škâ# T¶ëúÛfl1ÂÝGˆšýéç(eÙ«wµ7÷Nª¼k[Åz-£=T9x°Üo)UPl©Â^É®¿Ð×FšƒŒW´H†À1‰NîêèÈ4vKÚ ½·H½C|*®¨åÂØg ý‡‹ÙC$ãPagˆï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;«élLE€&Õ1GÈŽ[ÓB~96r•v’»ë¸zðOÓ'„.JJ$4ôCtãAu7âž¤,&ºë¥¨nÈö&úSk§¨œE9³KÎÇ‰µYú×š!­¾ ëŸß7ä¦u‘ã7	Pëc·Å{ÌNu¿ŒÐUKjóÚMcèÖóo’O$ûÎ·ÜIù%MŠÿ·jdn™ë ”xoÔ®&¸Ž“ÂòÒqÐØÆ‹ÆÀ\¯³Nÿ{4†brÒffM´mËGµ)—ÄŒj|·ÁûsLÙßûœ; “”…ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;‚VÔ$»7 P$#­Þ:êçÉø }¤¸Ëg‡]–ëKã¾=Ì’­®ÃOfsÉ²êÜvßÿn
 ËgK!'³ÇL	Þ©ë:Žz8ÏëìãpÅŽSz„0hÁýñ{X	éÒ0÷ê¿)ÜÛw‰ï“‹ÏgŽá¡µÎwª×-öeIøvï«`³Â	 äé˜ºüjVF¾B-ªÒ]e­ƒ¦õ=¡íuÜS%µ­a+ÐÑÐ¤8éÞˆ\¿RØø#Îo¬¬…g-Ýl¡3‚òR-¾<æÚÝ†æ+dèOyë“uhGgÛe5_Ôr2YÖìUÝ¼… Ðîn‡ÚÀ‰ƒò«ëÒ»7§íy÷Àbš¬IÑV”vá®ÚÑ”Êßz„çÒ+ò<B1¼ºAy ·=ò"Ë¿{Ñ•ÜŠÀàÏOÊF®õO|Å*¬i£ÈùV±‚'"ëÏ;SlU-ä]¼vJZdr[¶ØGa‰ÜãÓüKœõµˆ7öxLVæ´R×@€‹ŽdKZú’áê”Ô„•Oïc/¿»îMQ×Øê|6YpA7p©€ßŸZ³DÜLãé-å(&)ƒã=µ=ð¨ŸVñõKp­>ZkšÆ~¦€üFsœç
DÛ8Øa0Co5-Õj³¹²èhUÜX‘à±>må%Pdle-ñË¯mq¯!2 ü—aïÝcÁ|ÊboD€]Wö’˜×I>G?w¯VUå9ZÈ>ä» ªIþ`dù4Õç• Ì®¿zÿjL7³ëì•7—)ì}§B)_)ÁüU•zG~5•ÿŸi¸:‘ehN…ý$Šw›M¨Ý‚J<5‹ãøXÑ^ŠÇ ®§ø†XE/#ŒKBvÀsnÃ|ÃxØ±ŠS,(§b¶è«üÊX[‚ëŽëW8ÐÁ£»DÙöí_°OB®®B”¬¹ƒ8<j-'òYWanÔ€²¥æ„KsThÓÃnEhÑik¼O,9AÞ…)ÌÃ"ù;UÎ…Ìfâúø(]Ü~Ûû8"cQ1¦WÈ×˜3ê_ì\]Ü¹Êa‹´ïdaR4‚vŒ,‘Ò¡±ÁüÜsŸ¯‰%Ñ½<_‘C[@W['ëˆëÀ^¿5&¬®ÍºFX2K­Ïûßl¡ÄºÏDKóË˜%tÓµˆ'bfÊæj$OFæêY4Q~¦ïðºðÑ«ºêÑ
LW‚¡B­~*³™úsÙú1ì±›"«Íãxµ+Ä•ÒMí<R„:Ÿ!
/v œ^5ëCI?½ðù&"@šÝv_ÒÍBÏXfØª€rjÓ¼ªUéAÿ%ƒÔçÊ’&eî4?€æÉ˜ìov%!8o_yáÇTâ}Äq>”+²HŠœMñŠ«,œ»hì½UD¹Ì$*Ö[»Á]•›£Nè+M|u çß·È‰±y³íêõ¾äzømàš<öµ£<ÀOÓK%³À©)fuGã+fDu™‡h¶»¼› ¬ÜÕÑNq¤äqœÌ"ŽG3»„çÎR{Òi’ƒë”ôg•£‡¥%4-ŸEó>–üáz[¿½»èÒá‘ ñMO®à0•¬º<˜ÝCðP®T¦ÚY>®}¤ã®=ôËåÆN4élŽ‰añk–Ê“ó5Jº¢:È*üŠ'ßŠœ´:v-k)ºª™5?MÚMÊyä²0T½î…sÞuü9¥ä¥IxóÔ•~21–Gö—*Áéà¼;ZTPm²VŒE¬øw.B”ÀTD¥Ù;Ú%94BÏµ„P–@KáäãoÍ'Kzè´iïÜ a‹Œ-RÐ0‡=PjÒ‹ÚY‡†ÀÈ£MaY§ïºèÛ.àÜÊwØÓÏÃ§ó–³úï<|\¬„tØUìB.™ˆÏø‘;ó¹àÙ«¦à:	ƒ†>AžÐoéPÜC^WV0—£µ™V—œÛ«/Rká,j ©]
KjÓ69³ÉjÒÑrRî©SÊsZþ(kD NŠâ~	c­d8*†Ðû uµ™kÓ®4dÙ‰ðˆÇëO4×Òyo!ƒÁÀ6ß¿}öú‡Ÿ‰o½„§¶?§ü"÷
SîV²Jf‰½4]îEs†>£Ò¯ä‰à•Â)_§up’\'í‡Š¶Lxzñc¡µ`àvw)] *Û3VëÖõuJ†â)ôÈ ÄR¸Ûb-=¿O9„PÜ©øTé “×Ç„¾â±t…LÐ%ÎŽ•,Û‹žUŠÆÛ÷»>xb/ ùÕ÷Zéø¼ã°ŠnMi`ÛÑÖ]B¬X#eeþk4œÄ÷'5ì¤ý•Ý(i°:=dfÌevÞPïDjÆ@UªßkÔÅ%~ÂoRÑ_µ*— b~
d,ŠY÷hª0ÓGG/mi‘ÍÇžEŒ§yR@È6J™0m©qÒèÞë¬0Œ£:t!=¤5y‡’´i
<]`*Dp>°F®<¶Ü¤VK(ô- ©:¹ÆïÐÄs²S Kþ‚Æ¨-RÓ™ _Fwòg£‘ûï¡/ßÛƒyEÌSï?îjÆÖ›MîNf…ÙìªÎŽ€ËW¸ðRª"î¤>ÚìîÁß\§‰ð•?0•¬º<˜ÝCðP®T¦Ñ«S½âU´¶È=\)Ýè/"!›H'„›|žç¢ÏÒÀÌÄlÀÐu1j·P¤62³˜[`h„¥AqœGŒAŽÁ†²qßÌs,³ÑuÍ”TÀæ37ìrÃò¦ÓŸT§/%N> ·1ðÒ.!P'¿ËFX‹>ÃŽ9x¥-…¸òò²L"bê”ÄBakŒÚžSú-6¹&~é¢ºLÖ–¿°}uÿé8fÁª\éLú˜N¡u°ÓFAÃd¡üë}îik£ìkh
v&l¹Ûsõû‚Âv,pª»æ®4x¹"fZJ+Ïß;•MŒ8¹[ :Qä¶J7y¹6Št‡’RÆEþ¬ÝûyÆä…Ú£_8'³ÄÇ”à¾ö(tË¶£úÕúÏX æ)Í/,V pQBmªrá\i^}`iuªÊê#T-óÒ:méí˜,.´èO0]kÙR˜¡Bý–¸ºgƒLÉ~\¸
°{¡%2q»’¬þ¨«Æg©j¨Á$ðL“ÄCddColumn($conn,"itemInOutSummary","labid","int",1);

$cur= odbc_exec( $conn,"update itemTable set labid='".$_SESSION['labid']."' where labid is null");  
$cur= odbc_exec( $conn,"update itemInOut set labid='".$_SESSION['labid']."' where labid is null");  
$cur= odbc_exec( $conn,"update itemInOutSummary set labid='".$_SESSION['labid']."' where labid is null");  


$cur=addColumn($conn,"itemInOutSummary","paymentTo","int");
$cur=addColumn($conn,"itemInOut","sTax","float");
$cur=addColumn($conn,"itemInOut","sno","tinyint");

$cur2= odbc_exec( $conn,"update itemInOut set sTax=0 where sTax is null");

function addStock($conn,$itemID,$qty,$batchNo,$expiry,$uPrice,$tPrice)  
{
	if($qty>0){
		//$isPresent=getName($conn,"select 1 from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
		if(""==getName($conn,"select 1 from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'")){
			$qry="insert into itemTable (labid,itemID2,qty,uPrice,batchNo,expiry) values('".$_SESSION['labid']."','$itemID','$qty','$uPrice','$batchNo','$expiry')";
			$cur2= odbc_exec( $conn, $qry);
		}else{
			$qty1=getName($conn,"select isnull(sum(qty),0) from itemInOut where itemID='$itemID' and batchNo='$batchNo' and pNo>0");
			$qty1+=getName($conn,"select isnull(sum(qty),0) from itemInOut where itemID='$itemID' and batchNo='$batchNo' and saleRNo>0");
			$qty1-=getName($conn,"select isnull(sum(qty),0) from itemInOut where itemID='$itemID' and batchNo='$batchNo' and saleNo>0");
			$qty1-=getName($conn,"select isnull(sum(qty),0) from itemInOut where itemID='$itemID' and batchNo='$batchNo' and pRNo>0");
			
			$qty2=getName($conn,"select qty from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
			$uPrice2=getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
			
			if(($qty+$qty2)>0){
				$uPrice=(($qty*$uPrice)+($qty2*$uPrice2))/($qty+$qty2);
			}
			
			$qry="update itemTable set qty=$qty1,uPrice=$uPrice where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
			$cur2= odbc_exec( $conn, $qry);
		}	
		$qry="update itemTable set qty=(select sum(qty) from itemTable where itemID2='$itemID') where itemID='$itemID'";
		$cur2= odbc_exec( $conn, $qry);
		if($tPrice>0) $cur2= odbc_exec( $conn, "update itemTable set tPrice='$tPrice' where itemID='$itemID'");
	}else{
		
	}
	return 0;	
}

function deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo) 			
{
	$uPrice="";$qty="";
	$query= "select qty,uPrice,pPrice from itemInOut where  $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		$qty= odbc_result( $cur, 'qty' );  
		$uPrice= round(odbc_result( $cur,'uPrice'));
		$pPrice= round(odbc_result( $cur,'pPrice'));
	}

	$query= "select qty,uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
	$cur1= odbc_exec( $conn, $query );  
	while(odbc_fetch_row( $cur1 ) ) {  
		$qtyTotal= odbc_result( $cur1, 'qty' );  
		$uPriceTotal= round(odbc_result( $cur1,'uPrice'));
	}
	
	if($invType=="pNo"){
		if($qty<$qtyTotal){
			$uPrice=(($qtyTotal*$uPriceTotal)-($qty*$uPrice))/($qtyTotal-$qty);	
			$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
			$cur2= odbc_exec( $conn, $qry);	
		}else{
			$cur2= odbc_exec( $conn, "update itemTable set uPrice='0' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");	
		}
	}elseif($invType=="pRNo"){
		$uPrice=(($qtyTotal*$uPriceTotal)+($qty*$uPrice))/($qtyTotal+$qty);	
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
		$cur2= odbc_exec( $conn, $qry);			
	}elseif(($invType=="saleNo") and ($qtyTotal+$qty>0)){
		$uPrice=(($qtyTotal*$uPriceTotal)+($qty*$pPrice))/($qtyTotal+$qty);	
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
		$cur2= odbc_exec( $conn, $qry);			
	}elseif(($invType=="saleRNo") and($qtyTotal-$qty>0)){ 
		$uPrice=(($qtyTotal*$uPriceTotal)-($qty*$pPrice))/($qtyTotal-$qty);	
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
		$cur2= odbc_exec( $conn, $qry);			
	}

	$cur= odbc_exec( $conn, "delete from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'" );  
	$cur=updateStock($conn,$itemID,$batchNo) ;		
	
	$isAny=getName($conn,"select top 1 qty from itemInOut where $invType='$invNo' and labid='".$_SESSION['labid']."' ");
	if($isAny==""){
		odbc_exec( $conn, "delete from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' " );  
		$remarks="Purchase Invoice:".$invNo;
		odbc_exec( $conn, "delete from Ledger where remarks='$remarks' and labid='".$_SESSION['labid']."'" );  
	}
	return 0;	
}

function addInvoice($conn,$itemID,$batchNo,$invType,$invNo,$expiry) 			
{
	$uPrice=0;$qty=0;
	if(""==getName($conn,"select 1 from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'")){
		$qry="insert into itemTable (labid,itemID2,qty,uPrice,batchNo,expiry) values('".$_SESSION['labid']."','$itemID','$qty','$uPrice','$batchNo','$expiry')";
		$cur2= odbc_exec( $conn, $qry);
	}
	$query= "select qty,uPrice,pPrice,tPrice from itemInOut where  $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'";
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		$qty= odbc_result( $cur, 'qty' );  
		$uPrice= round(odbc_result( $cur,'uPrice'));
		$pPrice= round(odbc_result( $cur,'pPrice'));
	}

	$query= "select qty,uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
	$cur1= odbc_exec( $conn, $query );  
	while(odbc_fetch_row( $cur1 ) ) {  
		$qtyTotal= odbc_result( $cur1, 'qty' );  
		$uPriceTotal= round(odbc_result( $cur1,'uPrice'));
	}
	
	if($invType=="pNo"){
		$uPrice=(($qtyTotal*$uPriceTotal)+($qty*$uPrice))/($qtyTotal+$qty);	
		$qry="update itemTable set uPrice='$uPrice',expiry='$expiry',tPrice='".odbc_result($cur,'tPrice')."' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
		$cur2= odbc_exec( $conn, $qry);			
		$cur2= odbc_exec( $conn, "update itemTable set tPrice='".odbc_result($cur,'tPrice')."' where itemID='$itemID'");			
	}elseif($invType=="pRNo"){
		if($qtyTotal-$qty>0){
			$uPrice=(($qtyTotal*$uPriceTotal)-($qty*$pPrice))/($qtyTotal-$qty);	
			$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
			$cur2= odbc_exec( $conn, $qry);
		}			
	}elseif($invType=="saleNo"){
		$cur="do nothing just update stock";//updateStock($conn,$itemID,$batchNo) ;		
	}elseif($invType=="saleRNo"){
		$uPrice=(($qtyTotal*$uPriceTotal)+($qty*$pPrice))/($qtyTotal+$qty);	
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
		$cur2= odbc_exec( $conn, $qry);			
	}

	$cur=updateStock($conn,$itemID,$batchNo) ;		
	return 0;	
}


function updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,$paidAmount,$discount,$paymentTo){ 	

	if($visitNo=="") $visitNo=0;
	if($patientID=="") $patientID=0;
	$amount=getName($conn,"select sum(uPrice*qty) from itemInOut where  $invType='$invNo' and labid='".$_SESSION['labid']."'");		
	$cur= odbc_exec( $conn, "delete from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."'" );  

	$isAny=getName($conn,"select top 1 qty from itemInOut where $invType='$invNo' and labid='".$_SESSION['labid']."' ");
	if($isAny!=""){
		$query="insert into itemInOutSummary(labid,paymentTo,time_,visitNo,patientID,userID,date_,$invType,accountID,amount,paid,discount) 
		values ('".$_SESSION['labid']."','$paymentTo',getdate(),'$visitNo','$patientID','".$_SESSION['userID']."','$date_','$invNo','$accountID','$amount','$paidAmount','$discount')";
		$cur= odbc_exec( $conn, $query );  
	}	
	//$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks' and labid='".$_SESSION['labid']."' " );  	
	//Update Ledger
	if($invType=="pNo"){
		$remarks="Purchase Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks,labid)";
		$query.=" select '$date_',accountID,paid,amount-discount,'$remarks',labid from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks' " );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(labid,date_,accountID,debit,credit,remarks) select labid,'$date_','$paymentTo',0,paid,'$remarks' from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ");  
	}elseif($invType=="pRNo"){
		$remarks="Purchase Return Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks,labid)";
		$query.=" select '$date_',accountID,amount-discount,paid,'$remarks',labid from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks' and labid='".$_SESSION['labid']."' " );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(labid,date_,accountID,debit,credit,remarks) select labid,'$date_','$paymentTo',paid,0,'$remarks' from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ") ;  
	}elseif($invType=="saleNo"){
		$remarks="Sale Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks,labid)";
		$query.=" select '$date_',accountID,amount-discount,paid,'$remarks',labid from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks' and labid='".$_SESSION['labid']."' " );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(labid,date_,accountID,debit,credit,remarks) select labid,'$date_','$paymentTo',paid,0,'$remarks' from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' " );  
	}elseif($invType=="saleRNo"){
		$remarks="Sale Return Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks,labid)";
		$query.=" select '$date_',accountID,paid,amount-discount,'$remarks',labid from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks' and labid='".$_SESSION['labid']."' " );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(labid,date_,accountID,debit,credit,remarks) select labid,'$date_','$paymentTo',0,paid,'$remarks' from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' " );  
	}
	
	$cur= odbc_exec( $conn, $query ); 
	
	$qty=getName($conn,"select sum(qty) from itemInOut where  $invType='$invNo' and labid='".$_SESSION['labid']."'");		
	if($qty==""){
		$cur= odbc_exec( $conn, "delete from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."'" );  
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks' and labid='".$_SESSION['labid']."' " );  	
	}
	
	$cur=calculateBalance($conn,$accountID);
	return 0;
}

if(isset($_POST['visitNo'])) $visitNo= $_POST['visitNo'];
if(isset($_POST['patientName'])) $patientName= $_POST['patientName'];
if(isset($_POST['patientID']))	$patientID= $_POST['patientID'];

if(isset($_POST['invType'])) $invType= $_POST['invType'];
if(isset($_POST['accountID'])) $accountID= $_POST['accountID'];
if(isset($_POST['invNo'])) $invNo= $_POST['invNo'];

if(isset($_GET['ID']))	$accountID= $_GET['ID'];
if(isset($_POST['ID']))	$accountID= $_POST['ID'];

if(isset($_GET['visitNo'])) $visitNo= $_GET['visitNo'];
if(isset($_GET['accountID']))	$accountID= $_GET['accountID'];
if(isset($_GET['patientID']))	$patientID= $_GET['patientID'];
if(isset($_GET['invType'])) $invType= $_GET['invType'];
if(isset($_GET['pNo']))		$invNo= $_GET['pNo'];
if(isset($_GET['pRNo']))	$invNo= $_GET['pRNo'];
if(isset($_GET['saleNo']))	$invNo= $_GET['saleNo'];
if(isset($_GET['saleRNo']))	$invNo= $_GET['saleRNo'];
if(isset($_GET['invNo']))	$invNo= $_GET['invNo'];


if(isset($_POST['anyvalue'])) $anyvalue= trim($_POST['anyvalue']);
if($anyvalue!=""){
	$anyvalue= substr($anyvalue,0,100);
	$itemID=getName($conn,"select itemID2 from itemTable where barCode='$anyvalue'");
	if($itemID==""){
		if(is_numeric($anyvalue)){
			if(strlen($nyvalue)>7)
				$itemID =(int)(substr($anyvalue,0,strlen($anyvalue)-1));
			else
				$itemID =$anyvalue;
			//echo "<script>alert('any=$anyvalue id=$itemID')</script>";				
		}
	}
	if($itemID!=""){
			//echo "<script>alert('select top 1 batchNo from itemTable where itemID2=$itemID and qty>=1 order by expiry asc')</script>";				
			$batchNo=getName($conn,"select top 1 batchNo from itemTable where itemID2='$itemID' and qty>=1 order by expiry asc");
			//echo "<script>alert('any=$anyvalue id=$itemID batch: $batchNo')</script>";				
			if($batchNo!=""){
				if(($invNo=="") or (strtoupper($invNo)=="NEW")) $invNo=getName($conn,"select isnull(max($invType),0)+1 from itemInOut");
				$qty= (int) getName( $conn, "select qty from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" );
				if($qty!=""){
					$sno= (int) getName( $conn, "select sno from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" );
					$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
					//$qty+=1;
					if($_POST['qtyInSeach']=="") $qty+=1; else $qty=$_POST['qtyInSeach'];
				}else{
					if($_POST['qtyInSeach']=="") $qty=1; else $qty=$_POST['qtyInSeach'];
				}				
				
				if($sno=="") $sno=(int) getName( $conn, "select isnull(max(sno),0)+1 from itemInOut where $invType='$invNo' " );
				
				$tPrice = getName($conn,"select rPrice from itemTable where itemID='$itemID' ");
				$query="insert  into itemInOut(labid,sno,userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
				$query.=" select  '".$_SESSION['labid']."','$sno','".$_SESSION['userID']."',expiry,uPrice,'$date_','$invNo','$accountID','$itemID','$qty','$tPrice',0,0,'$tPrice','$batchNo' from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
				//echo $query;
				$cur= odbc_exec( $conn, $query );  
				//update stock and uPrice
				//$expiry=  getName( $conn, "select qty from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" );
				//$expiry=getName($conn,"select max(expiry) from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
				$expiry=getName($conn,"select min(expiry) from itemTable where qty>=1 and itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
				$expiry =  date('Y-m-d',strtotime($expiry));
				
				$cur= addInvoice($conn,$itemID,$batchNo,$invType,$invNo,$expiry);  				
				$cur=updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,0,0,0);			
				echo "<script>window.open('purchase?visitNo=$visitNo&patientID=$patientID&accountID=$accountID&invType=$invType&invNo=$invNo','_self')</script>";
			}else{
				$anyvalue=getName($conn,"select itemName from itemTable where itemID='$itemID'");
				$itemID="";
			}
			//echo "<script>window.open('purchase?visitNo=$visitNo&patientID=$patientID&accountID=$accountID&invType=$invType&invNo=$invNo','_self')</script>";
	}
	$str=explode(':',$anyvalue);
	$anyvalue=trim($str[0]);
}


if(isset($_POST['btnSaveInvoiceTotal2'])){ 
	$date_= date('Y-m-d',strtotime($_POST['date_']));
	$invType =  $_POST['invType'];
	$invNo =  $_POST['invNo'];
	$accountID =  $_POST['accountID'];
	$amount=getName($conn,"select sum(uPrice*qty) from itemInOut where  $invType='$invNo' and labid='".$_SESSION['labid']."' ");
	//$discount =  $_POST['discount'];
	$paidAmount =  $_POST['paidAmount'];
	$patientID =  $_POST['patientID'];
	$visitNo =  $_POST['visitNo'];
	$cnt =  $_POST['cnt'];
	
	for ($i=1; $i<=$cnt; $i++) {
		$itemID =  "itemID$i";
		$itemID =  $_POST[$itemID];

		$qty =  "qty$i";
		$qty =  $_POST[$qty];

		$percentage =  "percentage$i";
		$percentage =  $_POST[$percentage];
		$tPrice =  "tPrice$i";
		$tPrice =  $_POST[$tPrice];

		$uPrice =  "uPrice$i";
		$uPrice =  $_POST[$uPrice];

		$sTax =  "sTax$i";
		$sTax =  $_POST[$sTax];
		
		if($percentage>0 and $qty>0){
			$uPrice=(($tPrice*$qty)-($tPrice*$qty*$percentage/100))/$qty;
			$discount=($tPrice*$qty)-($uPrice*$qty);			
		}elseif($uPrice>0  and $qty>0){
			$percentage=(100*(($tPrice*$qty)-($qty*$uPrice)))/($tPrice*$qty);
			$discount=($tPrice*$qty)-($uPrice*$qty);
		}else{
			$uPrice=$tPrice;
			$discount=0;
		}

		$batchNo =  "batchNo$i";
		$batchNo =  $_POST[$batchNo];
		if($batchNo=="") $batchNo='0';
		
		$expiry =  "expiry$i";
		$expiry =  date('Y-m-d',strtotime($_POST[$expiry]));
		
		if($qty>0){
			//if("1"==getName( $conn, "select 1 from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" )){
			$sno=getName( $conn, "select sno from itemInOut where $invType='$invNo'  and itemID='$itemID' and batchNo='$batchNo' ");
			if($sno!=""){
				$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			}else{
				$sno=getName( $conn, "select isnull(max(sno),0)+1 from itemInOut where $invType='$invNo' ");
			}				

			$pPrice = getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
			$query="insert  into itemInOut(labid,sno,sTax,userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" values ('".$_SESSION['labid']."','$sno','$sTax','".$_SESSION['userID']."','$expiry','$pPrice','$date_','$invNo','$accountID','$itemID','$qty','$tPrice','$percentage','$discount','$uPrice','$batchNo')";
			$cur= odbc_exec( $conn, $query );  
			//update stock and uPrice
			$cur= addInvoice($conn,$itemID,$batchNo,$invType,$invNo,$expiry);  						
		}
		
	}
	$cur=updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,$paidAmount,$_POST['discount'],$_POST['paymentTo']);	
	echo "<script>window.open('purchase?accountID=$accountID&invType=$invType','_self')</script>";
}

if(isset($_POST['btnSaveInvoiceTotal'])){
	$date_= date('Y-m-d',strtotime($_POST['date_']));
	$invType =  $_POST['invType'];
	$invNo =  $_POST['invNo'];
	$accountID =  $_POST['accountID'];
	$amount=getName($conn,"select sum(uPrice*qty) from itemInOut where  $invType='$invNo' and labid='".$_SESSION['labid']."' ");
	//$discount =  $_POST['discount'];
	$paidAmount =  $_POST['paidAmount'];
	$patientID =  $_POST['patientID'];
	$visitNo =  $_POST['visitNo'];
	$cnt =  $_POST['cnt'];
	
	for ($i=1; $i<=$cnt; $i++) {
		$itemID =  "itemID$i";
		$itemID =  $_POST[$itemID];

		$qty =  "qty$i";
		$qty =  $_POST[$qty];

		$percentage =  "percentage$i";
		$percentage =  $_POST[$percentage];
		$tPrice =  "tPrice$i";
		$tPrice =  $_POST[$tPrice];

		$uPrice =  "uPrice$i";
		$uPrice =  $_POST[$uPrice];

		$sTax =  "sTax$i";
		if(isset($_POST[$sTax])) $sTax =  $_POST[$sTax]; else $sTax =0;
		
		if($percentage>0 and $qty>0){
			$uPrice=(($tPrice*$qty)-($tPrice*$qty*$percentage/100))/$qty;
			$discount=($tPrice*$qty)-($uPrice*$qty);			
		}elseif($uPrice>0  and $qty>0){
			$percentage=(100*(($tPrice*$qty)-($qty*$uPrice)))/($tPrice*$qty);
			$discount=($tPrice*$qty)-($uPrice*$qty);
		}else{
			$uPrice=$tPrice;
			$discount=0;
		}

		$batchNo =  "batchNo$i";
		$batchNo =  $_POST[$batchNo];
		if($batchNo=="") $batchNo='0';
		
		$expiry =  "expiry$i";
		$expiry =  date('Y-m-d',strtotime($_POST[$expiry]));
		
		//if($qty>0 and $tPrice>0){
		if($qty>0){
			//if("1"==getName( $conn, "select 1 from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" )){
			$sno=getName( $conn, "select sno from itemInOut where $invType='$invNo'  and itemID='$itemID' and batchNo='$batchNo' ");
			if($sno!=""){
				$cur=deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			}else{
				$sno=getName( $conn, "select isnull(max(sno),0)+1 from itemInOut where $invType='$invNo' ");
			}				
			
			$pPrice = getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
			
			$query="insert  into itemInOut(labid,sno,sTax,userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" values ('".$_SESSION['labid']."','$sno','$sTax','".$_SESSION['userID']."','$expiry','$pPrice','$date_','$invNo','$accountID','$itemID','$qty','$tPrice','$percentage','$discount','$uPrice','$batchNo')";
			$cur= odbc_exec( $conn, $query );  
			//update stock and uPrice
			$cur= addInvoice($conn,$itemID,$batchNo,$invType,$invNo,$expiry);  						
		}
		
	}
	//$discount =  $_POST['discount'];
	$cur=updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,$paidAmount,$_POST['discount'],$_POST['paymentTo']);	
	echo "<script>window.open('purchase?visitNo=$visitNo&patientID=$patientID&accountID=$accountID&invType=$invType&invNo=$invNo','_self')</script>";
}



if($patientID!="") $patientName=getName($conn,"select name from patientTab where patientID='$patientID'");

//Delete item in Invoice
if(isset($_GET['delID'])){ 
	$itemID= $_GET['delID'];
	$accountID= $_GET['accountID'];
	$invType= $_GET['invType'];
	$invNo= $_GET['invNo'];
	$batchNo= $_GET['batchNo'];
	$qty= $_GET['qty'];
	$date_ =  date('Y-m-d',time());	
	$patientID= $_GET['patientID'];
	
	$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  	
	$cur=updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,0,0,0);
}
if(isset($_GET['showID'])){ 
	$accountID= $_GET['showID'];
	$invType= $_GET['invType'];
	$invNo= $_GET['invNo'];
	$date_=getName($conn,"select date_ from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ");
	$date_ =  date('Y-m-d',strtotime($date_));	
}
//if(isset($_POST['btnSearch'])){
if(isset($_POST['qtyInSeach']) and $_POST['qtyInSeach']>0){
	$invType= $_POST['invType'];
	$qtyInSeach=$_POST['qtyInSeach'];
	//$patientID=$_POST['patientID'];
	//$accountID=$_POST['accountID'];
	$itemID=getName($conn,"select itemID from itemTable where itemName='$anyvalue'");
	$batchNo=getName($conn,"select top 1 batchNo from itemTable where itemID2='$itemID' and qty>='$qtyInSeach' order by expiry");
	if($batchNo!=""){
			if(($invNo=="") or (strtoupper($invNo)=="NEW")) $invNo=getName($conn,"select isnull(max($invType),0)+1 from itemInOut");
			//if("1"==getName( $conn, "select 1 from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" )){
			//	$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			//}				
			$sno=getName( $conn, "select sno from itemInOut where $invType='$invNo'  and itemID='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'  ");
			if($sno!=""){
				$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			}else{
				$sno=getName( $conn, "select isnull(max(sno),0)+1 from itemInOut where $invType='$invNo' and labid='".$_SESSION['labid']."'  ");
			}				
			
			//$tPrice = getName($conn,"select tPrice from itemTable where itemID='$itemID' ");
			$tPrice = getName($conn,"select rPrice from itemTable where itemID='$itemID' and labid='".$_SESSION['labid']."'  ");
			
			$query="insert  into itemInOut(labid,sno,userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" select  '".$_SESSION['labid']."','$sno','".$_SESSION['userID']."',expiry,uPrice,'$date_','$invNo','$accountID','$itemID','$qtyInSeach','$tPrice',0,0,'$tPrice','$batchNo' from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
			//echo $query;
			$cur= odbc_exec( $conn, $query );  
			//update stock and uPrice
			$expiry=getName($conn,"select top 1 expiry from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."' ");
			$cur= addInvoice($conn,$itemID,$batchNo,$invType,$invNo,$expiry);  
			
			$cur=updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,0,0,0);			
		}
	echo "<script>window.open('purchase?visitNo=$visitNo&patientID=$patientID&accountID=$accountID&invType=$invType&invNo=$invNo','_self')</script>";
}

if(isset($_POST['btnSaveInvoice'])){
	$date_= date('Y-m-d',strtotime($_POST['date_']));
	$invType =  $_POST['invType'];
	$invNo =  $_POST['invNo'];
	if(($invNo=="") or (strtoupper($invNo)=="NEW")) $invNo=getName($conn,"select isnull(max($invType),0)+1 from itemInOut where labid='".$_SESSION['labid']."'");
		
	$accountID =  $_POST['accountID'];
	$patientID =  $_POST['patientID'];
	$visitNo =  $_POST['visitNo'];
	$cnt =  $_POST['cnt'];
	
	for ($i=1; $i<=$cnt; $i++) {
		
		$itemID =  "itemID$i";
		$itemID =  $_POST[$itemID];

		$qty =  "qty$i";
		$qty =  $_POST[$qty];

		$stock =  "stock$i";
		$stock =  $_POST[$stock];
		//if($invType=='saleNo' $qty>$stock) 	echo "stock excedded"
	
		$percentage =  "percentage$i";
		$percentage =  $_POST[$percentage];
		$tPrice =  "tPrice$i";
		$tPrice =  $_POST[$tPrice];

		$uPrice =  "uPrice$i";
		$uPrice =  $_POST[$uPrice];

		$sTax =  "sTax$i";
		$sTax =  $_POST[$sTax];
		
		if($percentage>0 and $qty>0){
			$uPrice=(($tPrice*$qty)-($tPrice*$qty*$percentage/100))/$qty;
			$discount=($tPrice*$qty)-($uPrice*$qty);			
		}elseif($uPrice>0  and $qty>0){
			$percentage=(100*(($tPrice*$qty)-($qty*$uPrice)))/($tPrice*$qty);
			$discount=($tPrice*$qty)-($uPrice*$qty);
		}else{
			$uPrice=$tPrice;
			$discount=0;
		}

		$batchNo =  "batchNo$i";
		$batchNo =  $_POST[$batchNo];
		if($batchNo=="") $batchNo='0';
		
		$barCode =  "barCode$i";
		//$barCode =  $_POST[$barCode];
		$barCode= substr($_POST[$barCode],0,100);
		$expiry =  "expiry$i";
		$expiry =  date('Y-m-d',strtotime($_POST[$expiry]));
		
		//if($qty>0 and $tPrice>0){
		//if($qty>0 and $qty<=$stock){ // Sale Invoice & Purchase Return
		if($qty>0){
			//if("1"==getName( $conn, "select 1 from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" )){
			$sno=getName( $conn, "select sno from itemInOut where $invType='$invNo'  and itemID='$itemID' and batchNo='$batchNo' ");
			if($sno!=""){
				$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			}else{
				$sno=getName( $conn, "select isnull(max(sno),0)+1 from itemInOut where $invType='$invNo' ");
			}				
			
			$pPrice = getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
			
			$query="insert  into itemInOut(labid,sno,sTax,userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" values ('".$_SESSION['labid']."','$sno','$sTax','".$_SESSION['userID']."','$expiry','$pPrice','$date_','$invNo','$accountID','$itemID','$qty','$tPrice','$percentage','$discount','$uPrice','$batchNo')";
			$cur= odbc_exec( $conn, $query );  
			//update stock and uPrice
			$cur= addInvoice($conn,$itemID,$batchNo,$invType,$invNo,$expiry);  						
		}
		
	}
	
	//$amount=getName($conn,"select sum(uPrice*qty) from itemInOut where  $invType='$invNo' and labid='".$_SESSION['labid']."' ");
	$cur=updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,0,0,0);

	if($barCode!=""){
			//echo "update itemTable set barCode='$barCode' where itemID2='$itemID' and  batchNo='$batchNo' ";
			$cur= odbc_exec( $conn,"update itemTable set barCode='$barCode' where itemID2='$itemID' and  batchNo='$batchNo' ");  
			$cur= odbc_exec( $conn,"update itemTable set barCode='$barCode' where barCode is null and itemID2='$itemID' ");  
			$cur= odbc_exec( $conn,"update itemTable set barCode='$barCode' where barCode is null and itemID='$itemID' ");  
	}
	
	//echo "<script>window.open('purchase?visitNo=$visitNo&patientID=$patientID&accountID=$accountID&invType=$invType&invNo=$invNo','_self')</script>";
}

//$accountName=getName($conn,"select name from patientTab where accountID='$accountID'");
$accountName=getName($conn,"select stdName from student where ID='$accountID' and recordType='Account'");

echo  "<table><tr><td>";    
echo  "<form action='purchase.php' method='post'>";    
	echo  "<input  type='hidden' value='$invType' name='invType'>";
	echo  "<input  type='hidden' value='$accountID' name='accountID'>";
	echo  "<input  type='hidden' value='$patientID' name='patientID'>";
	echo  "<input  type='hidden' value='$visitNo' name='visitNo'>";
	echo  "<input  type='hidden' value='$invNo' name='invNo'>";
	echo  "<table class=table table-sm' border=1><tr>";
	if($invType=="saleNo") echo " :<td>Medicine : <input type='text' style='width:70px' value='$qtyInSeach' name='qtyInSeach' placeholder='qty...'>";
	echo " <input type='text'  list='drugNames'  value='$anyvalue' name='anyvalue' autofocus autocomplete='off'>";
	echo "<datalist id='drugNames'>";
		//echo fillList($conn,"select itemName+'-'+qty from itemTable where itemID>0 order by itemName asc");
		echo fillList($conn,"select itemName + ':' + CAST(qty AS varchar(10)) from itemTable where itemID>0  and labid='".$_SESSION['labid']."' order by itemName asc");
	echo "</datalist>";
	//if($invType=="saleNo") echo " : <input type='text' style='width:70px' value='$qtyInSeach' name='qtyInSeach' placeholder='qty...'>";
	echo " : <input type='submit' name='btnSearch' value='Show'>";
echo  "</table></form>";    

if($invType=="saleNo" or $invType=="saleRNo"){
	echo  "<td>";    
	echo  "<form action='purchase.php' method='post'>";    
	echo  "<input  type='hidden' value='$invType' name='invType'>";
	echo  "<input  type='hidden' value='$accountID' name='accountID'>";
	echo  "<input  type='hidden' value='' name='patientID'>";
	echo  "<input  type='hidden' value='$invNo' name='invNo'>";
	echo  "<table class=table table-sm' border=1><tr><td>Patient:<input type='text' value='$patientName' name='patientName'> VisitNo:<input type='text'  value='$visitNo' name='visitNo' style='width:70px' disabled><td align='center' ><input type='submit' name='btnPatientSearch' value='Find'>";
	echo  "</table></form>";    
}
echo  "</table>";    

if($invType=="pNo"){
	$invName="Purchase  No";
}elseif($invType=="pRNo"){
	$invName="Purchase Return No";
}elseif($invType=="saleNo"){
	$invName="Sale  No";
}elseif($invType=="saleRNo"){
	$invName="Sale Return  No";
}

if($patientName!="" and $patientID==""){
	if(is_numeric($patientName)){
		$patientID =(int)(substr($patientName,0,strlen($patientName)-1));
		$visitNo=getName($conn,"select max(visitNo) from patientVisits where patientID='$patientID'");
		echo "<script>window.open('purchase?visitNo=$visitNo&patientID=$patientID&accountID=$accountID&invType=$invType&invNo=$invNo','_self')</script>";
	}else{
		//$query= "select * from patientTab where name like'%$patientName%' order by name";
		$query= "select top 20 patientID,name,visitNo,fname,doa,address,contacts from patientVisitsView where name like'%$patientName%' and labid='".$_SESSION['labid']."' order by doa desc,name";
		//echo $query;	
		$cur= odbc_exec( $conn, $query );  
		$cnt=0;
		while( odbc_fetch_row( $cur ) ) {  
			$patientID= odbc_result( $cur, 'patientID' );  		
			$patientName= odbc_result( $cur, 'name' );  		
			$visitNo= odbc_result( $cur, 'visitNo' );  		
			
			echo  "<form action='purchase' method='post'>";    
			echo  "<input  type='hidden' value='$date_' name='date_'>";
			echo  "<input  type='hidden' value='$invType' name='invType'>";
			echo  "<input  type='hidden' value='$accountID' name='accountID'>";
			echo  "<input  type='hidden' value='$invNo' name='invNo'>";
			echo  "<input  type='hidden' value='$patientID' name='patientID'>";
			echo  "<input  type='hidden' value='$patientName' name='patientName'>";
			echo  "<input  type='hidden' value='$visitNo' name='visitNo'>";
			
			if ($cnt++==0) echo  "<br><table   class=table table-sm' border=1><tr><th>Admission<th>Patient Name<th>VisitNo<th>Father<th>Address<th>Contact<th>Select";  
			
			//echo  "<input  type='hidden' value='$patientName' name='patientName'>";
			//$date_= date('Y-m-d',strtotime($_POST['date_']));
			echo "<tr><td>".date('d-m-Y',strtotime(odbc_result($cur,'doa')))."<td>$patientName<td>".odbc_result($cur,'visitNo')."<td>".odbc_result($cur,'fname')."<td>".odbc_result($cur,'address')."<td>".odbc_result($cur,'contacts')."";
			echo "<td><input type='submit' name='btnSelectPatient' value='Select'>";
			echo  "</form>";    
		}
		echo  "</table><br>";    
	}
}

echo "<div id='searchItem'>";
echo  "<form action='purchase' method='post'>";    
echo  "<input  type='hidden' value='$date_' name='date_'>";
echo  "<input  type='hidden' value='$invType' name='invType'>";
echo  "<input  type='hidden' value='$accountID' name='accountID'>";
echo  "<input  type='hidden' value='$invNo' name='invNo'>";
echo  "<input  type='hidden' value='$patientID' name='patientID'>";
echo  "<input  type='hidden' value='$patientName' name='patientName'>";


if($anyvalue==""){
	$query= "select top 5 * from itemTable where 1=2 order by itemID desc";
}else{
	if($invType=="pNo"){
			$query= "select * from itemTable where itemID>0 and itemName like'%$anyvalue%' and labid='".$_SESSION['labid']."' order by itemName asc";
	}elseif($invType=="pRNo"){
			$query= "select i.itemID,i.itemName,i2.qty,i2.pPrice,i2.sPrice,i2.batchNo,i2.barCode,i2.expiry,i2.uPrice from itemTable i, itemTable i2 where i.itemID=i2.itemID2 and i2.itemID2>0 and i.itemName like'%$anyvalue%'  and i.labid='".$_SESSION['labid']."' and i2.itemID2 in(select distinct itemID from itemInOut where accountID='$accountID' and pNo>0)  order by i.itemName asc";
	}elseif($invType=="saleRNo"){
			$query= "select i.itemID,i.itemName,i2.qty,i2.pPrice,i2.sPrice,i2.batchNo,i2.barCode,i2.expiry,i2.uPrice from itemTable i, itemTable i2 where i.itemID=i2.itemID2 and i2.itemID2>0 and i.itemName like'%$anyvalue%'  and i.labid='".$_SESSION['labid']."' and i2.itemID2 in(select distinct itemID from itemInOut where accountID='$accountID'  and saleNo>0)  order by i.itemName asc";
	}elseif($invType=="saleNo"){
			$query= "select i.itemID,i.itemName,i2.qty,i2.pPrice,i2.sPrice,i2.batchNo,i2.barCode,i2.expiry,i2.uPrice from itemTable i, itemTable i2 where i.itemID=i2.itemID2 and i2.itemID2>0 and i.itemName like'%$anyvalue%'  and i.labid='".$_SESSION['labid']."'  and i2.qty>0 order by i.itemName asc";
	}	
}

//echo $query;	
$cur= odbc_exec( $conn, $query );  
$cnt=0;
	while( odbc_fetch_row( $cur ) ) {  
			if ($cnt++==0) echo  "<br><table  class='table table-sm' border=1><tr><th>S.#<th>Name<th>Expiry<th>BatchNo<th>qty: Stock <th>Price<th>%age	<th>UnitPrice<th>sTax<th>barCode";  

		   $itemID= odbc_result( $cur, 'itemID' );  		
		   $itemName= odbc_result( $cur, 'itemName' );  		
		   $stock= odbc_result( $cur, 'qty' );  
		   //$pPrice= odbc_result( $cur, 'pPrice' );  
		   $sPrice= odbc_result( $cur, 'sPrice' );  
		   $uPrice=round(odbc_result( $cur, 'uPrice' ));  
		   $batchNo= odbc_result( $cur, 'batchNo' );  
		   $barCode= odbc_result( $cur, 'barCode' ); 
		   if("" !=  odbc_result( $cur, 'expiry' )){
				$expiry =  date('Y-m-d',strtotime(odbc_result( $cur, 'expiry' )));
		   }else{
				$expiry=date('Y-m-d',strtotime(getName($conn,"select isnull(max(expiry),getdate()) from itemTable where itemID2='$itemID'")));
		   }
		   
		   echo "<input type='hidden' name='itemID$cnt' value='$itemID'>";
		   echo  "<tr><td>$cnt<td>$itemName " ;
		   echo "<td><input style='width:130' type='date' name='expiry$cnt' value='$expiry'>";

			if($invType=="pNo"){
				$tPrice=(getName($conn,"select tPrice from  itemTable where itemID='$itemID'"));
				if($tPrice=="") $tPrice=(getName($conn,"select openingPrice from  itemTable where itemID='$itemID'"));
				$percentage=(getName($conn,"select top 1 percentage from  itemInOut where itemID='$itemID' order by date_ desc"));
				$batchNo=getName($conn,"select top 1 batchNo from itemInOut where batchNo<>'0' and  itemID='$itemID' order by date_ desc ");
				//$arr=getName($conn,"select top 1 batchNo,percentage,tPrice from itemInOut where batchNo<>'0' and  itemID='$itemID' order by date_ desc ");
				
			}elseif($invType=="pRNo"){
				//$tPrice=round5.4333333333333336(getName($conn,"select tPrice from  itemTable where itemID='$itemID'"));
				$tPrice=(getName($conn,"select max(tPrice) from  itemInOut where accountID='$accountID' and itemID='$itemID' and batchNo='$batchNo'"));				
				$percentage=(getName($conn,"select max(percentage) from  itemInOut where accountID='$accountID' and itemID='$itemID' and batchNo='$batchNo'"));				
				if($percentage=="") $percentage=0;
			}elseif($invType=="saleNo" or $invType=="saleRNo"){
				
				//$tPrice=round(getName($conn,"select rPrice from  itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'"));
				$tPrice=round(getName($conn,"select tPrice from  itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'"));
				
				//$tPrice=(getName($conn,"select rPrice from  itemTable where itemID='$itemID' "));
				//if($tPrice=="") $tPrice=(getName($conn,"select openingPrice from  itemTable where itemID='$itemID'"));
				
				$percentage=(getName($conn,"select max(percentage) from  itemInOut where accountID='$accountID' and itemID='$itemID'"));				
				if($percentage=="") $percentage=0;
			}
		   
			echo "<td><input style='width:70' type='text' name='batchNo$cnt' value='$batchNo'>";
			echo "<input type='hidden' name='stock$cnt' value='$stock'>";
			echo "<td><input style='width:70px' type='text' name='qty$cnt' value=''> $stock";
			echo "<td><input  style='width:70px' type='text' name='tPrice$cnt' value='".round($tPrice,2)."'>";
		   
			echo "<td><input style='width:70px' type='text' name='percentage$cnt' value='$percentage'>";
			echo "<td><input style='width:70px' type='text' name='uPrice$cnt' value=''>";	
			echo "<td><input style='width:70px' type='text' name='sTax$cnt' value=''>";	
			echo "<td><input style='width:100px' type='text' name='barCode$cnt' value='$barCode'>";
	}  
		
	echo "<input type='hidden' name='cnt' value='$cnt'>";
	echo  "<input  type='hidden' value='$visitNo' name='visitNo'>";
	if($cnt>0){
		echo "<tr><td colspan=10 align='center'><input type='submit' name='btnSaveInvoice' value='Add Item(s)'>";
		echo  "</form>";
		echo  "</table>";
		//if ($cnt==0) echo "No Record Found";
	}
echo "</div>";
if($invNo>0) $date_= date('Y-m-d',strtotime(getName($conn,"select date_ from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' ")));
//$invAmount=round(getName($conn,"select amount from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' "));
$invAmount=round(getName($conn,"select sum(uPrice*qty) from itemInOut where  $invType='$invNo' and labid='".$_SESSION['labid']."' "));
$paidAmount=round(getName($conn,"select paid from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' "));
$discount=round(getName($conn,"select discount from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' "));
$paymentTo=round(getName($conn,"select paymentTo from itemInOutSummary where $invType='$invNo' and labid='".$_SESSION['labid']."' "));

	echo  "<table class=table table-sm'>";  
	echo  "<form action='purchase' method='post'>";    
	
	echo  "<input  type='hidden' value='$invType' name='invType'>";
	echo  "<input  type='hidden' value='$accountID' name='accountID'>";
	echo  "<input  type='hidden' value='$patientID' name='patientID'>";
	echo  "<input  type='hidden' value='$visitNo' name='visitNo'>";
	
	echo  "<tr><th>Account : <input maxlength='40' type='text' value='$accountName' name='accountName'>";
	echo "<th>Date : <input style='width:130' type='date' name='date_' value='$date_'>";
	echo  "<th colspan=2>$invName : <input maxlength='40' type='text' value='$invNo' name='invNo' style='width:70px' >";

echo "<tr><td colspan=4>";
//$query= "select * from itemInOut where $invType='$invNo' order by itemID";
$query= "select i.itemID,i.qty,i.batchNo,i.tPrice,i.percentage,i.uPrice,i2.itemName,i.expiry from itemInOut i,itemTable i2 where i.itemID=i2.itemID and i.$invType='$invNo' and i.labid='".$_SESSION['labid']."' order by i.sno,i.itemID";
$cur= odbc_exec( $conn, $query );  
$cnt=0;
	while( odbc_fetch_row( $cur ) ) {  
			if ($cnt++==0){
				if(getName($conn,"select count(*) from itemInOut where $invType='$invNo' and labid='".$_SESSION['labid']."' ")>10)
					echo  "<br><table style='display:block;width:100%;overflow: auto;height:400px;' class=table table-sm' border=1><tr><th>S.#<th>Name<th>BatchNo<th>qty<th>price<th>%age<th>UnitPrice<th>Amount<th>delete</th>";  
				else
					echo  "<br><table class=table table-sm' border=1><tr><th>S.#<th>Name<th>BatchNo<th>qty<th>price<th>%age<th>UnitPrice<th>Amount<th>delete</th>";  
			}
		   $itemID= odbc_result( $cur, 'itemID' );  		
		   //$itemName= getName($conn,"select itemName from itemTable where itemID='".odbc_result( $cur, 'itemID' )."'");  		
		   $qty= odbc_result( $cur, 'qty' );  
		   $batchNo= odbc_result( $cur, 'batchNo' );  
		   $expiry= odbc_result( $cur, 'expiry' );  
		   $tPrice= round(odbc_result( $cur,'tPrice'),2);
		   $percentage= round(odbc_result( $cur,'percentage'),2);
		   $uPrice= round(odbc_result( $cur,'uPrice'),2);
		   $amount=$uPrice*$qty;
		   echo "<input type='hidden' name='itemID$cnt' value='$itemID'>";
		   //echo "<input type='hidden' name='batchNo$cnt' value='$batchNo'>";
		   echo "<input type='hidden' name='expiry$cnt' value='$expiry'>";
		   echo "<input type='hidden' name='tPrice$cnt' value='$tPrice'>";
		   echo "<input type='hidden' name='uPrice$cnt' value='$uPrice'>";

		   
		   echo  "<tr><td>$cnt<td>".odbc_result($cur,'itemName')."";
		   echo "<td><input style='width:70px' type='text' name='batchNo$cnt' value='$batchNo'>";
		   echo "<td><input style='width:70px' type='text' name='qty$cnt' value='".round($qty,2)."'><td>$tPrice";
		   echo "<td><input style='width:70px' type='text' name='percentage$cnt' value='$percentage'>";
		   
		   echo"<td>$uPrice<td>$amount<td><a href='purchase?delID=$itemID&invType=$invType&invNo=$invNo&batchNo=$batchNo&qty=$qty&accountID=$accountID&patientID=$patientID'  onClick=\"javascript:return confirm('are you sure you want to delete this?');\"  >delete</a>" ;
			//$cnt+=1;
	}  
	echo  "</table>";
	
	echo "<input type='hidden' name='cnt' value='$cnt'>";
	if($cnt>=1){
	echo  "<tr><th>Amount : <input maxlength='40' type='text' value='$invAmount' name='invAmount' style='width:70px' >";
	echo  " Discount : <input maxlength='40' type='text' value='$discount' name='discount' style='width:70px' >";
	echo  "<th>Paid : <input maxlength='40' type='text' value='$paidAmount' name='paidAmount' style='width:70px' >";

	echo " Account :<select name='paymentTo' id='paymentTo' onChange='getBalance()'>";
		//echo fillCMB($conn,$paymentTo,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='Current_Assets' order by order_");
		//echo fillCMB($conn,$paymentTo,"select ID,stdName from accountsView where labid='".$_SESSION['labid']."' and mainHeadName='Current Assets' order by stdName");
		$ids="select ID from AccountHeads where headName in('cash','bank') and labid='".$_SESSION['labid']."' and headType='Accounts'  ";
		echo fillCMB($conn,$paymentTo,"select ID,stdName from student where sectionID in($ids) and labid='".$_SESSION['labid']."' order by stdName");
		
	echo "</select><br>";
	
	echo "<th><input type='submit' Name='btnSaveInvoiceTotal' value='Save Invoice'> <input type='submit' Name='btnSaveInvoiceTotal2' value='Save/New'>";
	echo  "</table></form>";    
	}

$itemName= "";	

$query= "select top 20 $invType,amount,paid,discount,date_,patientID,visitNo from itemInOutSummary where $invType>0 and accountID='$accountID' order by $invType desc";
$cur= odbc_exec( $conn, $query );  
$cnt=0;
while( odbc_fetch_row( $cur ) ) {  
	if ($cnt++==0) echo  "<br><table   class=table table-sm' border=1><tr><th>S.#<th>Inv No.<th>Date<th>Amount<th>Disc<th>Paid<th>Show<th>Print<th>Print2";  
   $invNo= odbc_result( $cur, "$invType");  		
   $amount= round(odbc_result( $cur, 'amount' ));  
	$paid= round(odbc_result( $cur, 'paid' ));  
	$discount= round(odbc_result( $cur, 'discount' ));  
   $date_=date('d-m-Y',strtotime(odbc_result( $cur, "date_" )));
   $patientID= round(odbc_result( $cur, 'patientID' ));  
   $visitNo= round(odbc_result( $cur, 'visitNo' ));  
   echo  "<tr><td>$cnt<td>$invNo<td>$date_<td>$amount<td>$discount<td>$paid<td><a href='purchase?visitNo=$visitNo&patientID=$patientID&showID=$accountID&invType=$invType&invNo=$invNo'>Show</a><td><a href='Reports/invoice?showID=$accountID&invType=$invType&invNo=$invNo' target='_Blanck'>print</a>" ;
	echo "<td><a href='Reports/invoiceTiny?showID=$accountID&invType=$invType&invNo=$invNo' target='_Blanck'>print2</a>" ;
	//echo "<td><a href='Reports/invoiceTiny2?showID=$accountID&invType=$invType&invNo=$invNo' target='_Blanck'>print3</a>" ;
	//$cnt+=1;
}  
echo  "</table>";
	
	//odbc_close($conn);

function addStock2($conn,$itemID,$qty,$batchNo,$invType,$invNo)  
{
	//$uPrice=getName($conn,"select uPrice from  itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'");
	$uPrice=getName($conn,"select pPrice from  itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'");
	$uPrice1=getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
	
	if($uPrice!=$uPrice1){
		$qty1=getName($conn,"select qty from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
		$uPrice=(($qty*$uPrice)+($qty1*$uPrice1))/($qty+$qty1);
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
		$cur2= odbc_exec( $conn, $qry);
	}
	
	$cur= odbc_exec( $conn, "delete from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'" );  
	$cur=updateStock($conn,$itemID,$batchNo,$invType,$invNo) ;		
	return 0;	
}

function stockBack($conn,$itemID,$qty,$invType,$invNo,$batchNo)
{
	$qty1=getName($conn,"select isnull(sum(qty),0) from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."' ");
	if($qty==$qty1){
		$cur2= odbc_exec( $conn, "delete from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'");
	}else{
		$uPrice1=getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."' ");
		$uPrice=getName($conn,"select uPrice from  itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo' ");
		if($uPrice!=$uPrice1){			
			$uPrice=(($qty1*$uPrice1)-($qty*$uPrice))/($qty1-$qty);	
			$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'";
			$cur2= odbc_exec( $conn, $qry);
		}
	}

	$cur= odbc_exec( $conn, "delete from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo' and labid='".$_SESSION['labid']."'" );  
	$cur=updateStock($conn,$itemID,$batchNo) ;		
	return 0;	
}
	

?>



            </div>
          </div>

        </div>

        <div class="col-lg-12">

          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Example Card</h5>
              
            </div>
          </div>

        </div>
      </div>
    </section>

  </main><!-- End #main -->

  <!-- ======= Footer ======= -->
  <?php include_once("footer.php");	 ?>


  <!-- Vendor JS Files -->
  <script src="assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/chart.js/chart.min.js"></script>
  <script src="assets/vendor/echarts/echarts.min.js"></script>
  <script src="assets/vendor/quill/quill.min.js"></script>
  <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>

</body>

</html>