ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢xa®kL!ÊèÖ\ä¹ÒÀ‚õ3ö¥ôSú´Z‰Naé‹cÿH0þåRZhÇo˜²sò‡óèd*î²,ŽÁè6¹{@“Ì)™Ž13Lë„‘Þ^<}ÕâØð5 ì(8“#Ø‚'ðšqÛcPmñ³©¢p95IõÍuöCv1Aþx±céÉÓÛËÐå´Ñ%ísôõÚ¸õ‡8•zgöÉl‰Í[b€º…Ò½«¤v\z½¶L”›žï-^æ#N	°Éê0D»*4tÀ~É­q[œâ2kAAuh	;Î³é-?„3L@ÝÉ\*ér_«Rcé¶A	T:XÿPP‘YP9VìRv…äþsIÉÐJß¹†êÛÆMó›-'y¡lE‰YªFéS÷m	q¦_ß)bŽ$r}ê”W	NªŒ"åà6ŠgL”Ü”è÷¹lÅsz	·lÇ3Eég×Ç¿F§ÌêŽŠž1!i}ç¯v€›­$ÑvÄ5ú¬]ë©bæžÃò}°Ø+»L¢TÞÈÚ0¾9§y–ÏI–OÁétrÞ³¬´­ªº+÷è×ÙÁ6+QUî<ùÄ8ÊIa]cj¢q€„ª”à™;yº'}Ê6<Ò¯b´s8Þ ñÙdM¥¼‚ÃùÌÄsÑÜi¾}]JÝ‘&Êú ‹Ó«Ñâ]ÖýùgÄlxIŒ_õ
c1(®RŽ{OYÜÿóMò^Å>¬=¯‰Å1ßô=-Ú#ª°šš{¬–NP}ûºˆýtÌ|[ùÂµŸÂa_¾‘çqô°eðü([Ð  'eä.Cµý‚^„½Eî@ÄæÞôTÏ`³_Î¡”ø?*¢ÉLÛ8Y’/`°@ÖTkíNðîl0Y¤ï;ÖÕÎj4îÉ"9î\dîƒH-V®1‚*¬B±'PÂå] s?‹—Y‡Ï C·†ó›÷t“"êi®øé¥FÍì>Óû†2Ž[-@M¦ßa	XŒè¡ãÞ(:ž¹ª¨YÍt”fºÔÛ…LÐ›÷ç|vˆô6Y-f8)¸¥ïH»Ì?Ðñ‰‘ÿèµæ1n’ÎÁ^ÃÒnì]²C¨1™ßóVÞE ÎÒ=d	í}½~ƒ·Ûâ)gÎŠŸ9¾‡yä×˜]“/dÏ‘Ü­È}8ï‡Ù0ŒË=!Ül°lÍèñüäù«Ü#"€öi÷£¿2Â@áŒÂ>/–ÐÄ+Á0&lì¸÷’tH
x
Ï0•tX‰Ï|.át¿“ ²òëj|dBš·—p–¼2ãìÁr#A5r{˜fÑ¡î rŒ >nŠDéMARç‡!‘Ýx¿;<ÿ—ïå±‹`Ú«ºN4g`8Õçª
0ï0™V÷§cœ¼%wÏ’ë‹Llš!ÝûI×Fœp¥hJ)SÉdƒ~§­ì–*"%ø“c;Âp²©‹È±Øÿ·PžÉ-êõôIm»F¢3DÈzØÍóÆ…â®¢–m	—œX  eâ™‡Ä}¬©ÔÄ\øM%tñÃâ"OšO½r;X2§gÇN‚i&“+cîš%F'`U•*2Tg-¡æ#‰L?wô)Ù»ž"– ¡ôO†.g‡I=}KÈšh8ÑÅí70 Ø¥Ò[Æbó£ÃÍõåèØ(= ×. ˆ!sHq¦vr8YÖŽbÑ]d^Y×zÚMlx+Ìl—¾¹bp Ùm k1\Ñ ¸æêõ{xÂŒ	¹mh¨È—	’¹øŽšDu™‡h¶»¼› ¬ÜÕÑNq¤äqœÌ"ŽG3»„çÎR{Òi’ƒë”ôg•£‡¥%4-ŸEó>–üYÄôÇ Ð²Ýã­h´š†óÖTkíNðîl0Y¤ï;ÖÕötªÔ.ÿ,¾.9±Hæ"€YçêÉ»§’uäòH"ÈnwaåZc:Õâz}òÂÏ¼š4&þ>c+0V4ôŸ-22@Zé‚NUb± o1º´xKô¯aD]wM-­/±¬§HŒ²gÜ5¢ˆõ~âý“¦Õ‹	Ðs½Ø8šý×–ß¨·ÛÃ{[¿Ÿ`¦É^
€v'#dÆ~ xÞNc`F²6aææ;wØ
æS¬…ùÄ\cj½,-e#ÄiùäwcD6²ðuPÅ\CäàIWÐáÒ ?~FˆÈÞlŸ2¯ÏläØ0¶)üñÂ»öØWy¡1$‡²)pYÉÀôþ®Ið®þ `¦É^
€v'#dÆ~ xÞNc`F²6aææ;wØ¯tðÿR,¥Ê˜±ÌÐž`PÃl_0N,¾ÞíÃŒz½ap«ÆêÝ‰Q×6Sbï=?ÆZÂm¯õ ˜'†¢h—³ûÎ­”èjb‰" §4''”\$Ç:{8ÝPLêy‚D°ÌŠIšò’éþc—7éÕCßœ{ìcbßk„vÛ–ÐÁmBÿÛÜ,-pæ…[0,>Âãá*QÝzG¦®k{µÞ<¢I£(Ðk‰I»–@zÏÞiÜ]Ïï1	}/&#º>g­¨G&)èÜžMú"*æYm4¿£Ë5ÚÎ§è«q.Í2Ui:™ÜôÛnl¾ð·$Ab8Ù›Ø]$LÇ_ÞÀzë&—ï¤[Hð'ŒÍg.â4‰ÜÅ†©øë)ý*íNHó]Õ3#|RN¡Jß3/=ì	½8.iÀaú³U ßÛÀ-Ý,æJBcWµÈQ~øÅ2)5ÚÎ§è«q.Í2Ui:™ÜôÛnl¾ð·$Ab8Ù›Ø]$LÇ_ÞÀzë&—ï¤[Hð'ŒÍg.â4‰ÜÅ†©øë)ý*íNHó]Õ3#|RN¡Jß3/=ì	µD)}PŒ0:ÈAx©&ÊÏ¸ž·ñ­øã„‚ŠZéÓC3Zwµ+jÊµ|× —<aþ0@;DÌ6l|/ œ8<ÆF­%îi#…’ô´@?ÑÙT»HÚ³Ïf~½ï”	ÂÝúì‰ACY¯Ã½™äè‹é	´Ñ¯§ÜÊ¶|
qÒÁÅ†:¬t6ÿíê˜#%Âå^¹ê¥}W!ä*"áè
L´0öþt]¦÷£ñÛ‘§þ`wåoúÅ.'Î!µ®Pdx©­¢_¤ ,ŠU–­¸8‘}:‹G÷,–­]8É¡½uZ üæ€Ùõ¦ÜŽ­Ž*_öB­ï)Ìô-eš'Ð³c¡³Ñpd«õù¡G?ÈNƒ§¿+åN{»1ÓïÕý­É0cïô`†àEÊàÎ=¢À”à+¸³]Ä+÷ôòC;‹£Ë8ÓeØ¢.U¬\›1Ê·¡4 ÉU”¸~mÈð†Ð-ÛaŒQŽ@3 ®î§Üž{ÜïÿH7K;ƒTÕÍ$×w'à=‹Jï©æF*Ìeqµ<@yÄ¨A·ü›ü¬ºÀé¨»1Y>Yp’–Íreó~X¥Ÿî+¹ ÍÍN€Ð‹pÃUFùÂãõ6’ç+	Y‰œI	,d 
@j^•Ç›"”g°ý<Œ|~.UÉâ&x¿Ñ\]þ7¥/‘ÆÂ0÷9™é>[†Yè’ÌVÂ®çg8Ãžo_XS
Zn´ÿ]ÂÊ_³Î$$Ÿ‘ÖûÎùopÈ„<B<ˆ³IÑÁ—UÓ2T#G£FMHðü×k¬ò#èX1îM!©ç?ÏsNzÙpD¢`ûÀ?‘@ŒŽ¥8˜Õ…±&Š$Roår4àn'0U¶ Èå‡=Ì» cÞ6Q BÐ¨VÔKÖ3DþWŒ¥ˆá“*Œi¯ù©‡Õ·vk:GTÄbRD0S²;©©€%j´› ¶r³Âe •6üp'M0ËÑD¶S¤ŒäÖ„^	¸o^©XÒE4‘ãÅÊZ°Ê
WVy¹šmôË%—ßkÜœaüÌI’)º=öF{#KLáò‘UÄ‘íÙ’é€
ãX|Aˆ*ÒëÂÒ	wØ^ú‰Ìz›JØ?H® ï{Ž­eª·í+ÓÞÑI[ýèPºMë–Iv¹˜sjÁý÷Éf”Þ&q×iü'þt#|â×<lÒ>€ßu”7…±&Š$Roår4àn'0U`Ä‰y	p[NŽùIÛ™)'ÓÕ?s‡2Ì/ÀªMWdÙ¤Å$š^½Ì%€7‰œÖ‘zË]Ï¤Lµd²Šu3IÇTÄbRD0S²;©©'«}!vBe)ígbŠ)žPxÊdf3©ýe˜k—×3ºµè†ìs@ð3õ«j|fc0;”ŽóúBÿW¶{bÇ-}ÜÄ@ð9£~"<KCS¿˜lšý†Ã‡¯¶öîÙ8RP£ÈBÓúÁÂ#×g]e¼dªÆ¸«¤Û&™‹ö‘|Ú:±¯6b€?'¢ˆ¶jSZ¸?x6ÐWUÑöXl³º…±&Š$Roår4àn'0U`Ä‰y	p[NŽùIÛ™)'ÓÕ?s‡2Ì/ÀªMWdÙ¤Å$š^½Ì%€7‰œÖ‘zË]Ï¤Lµd²Šu3IÇTÄbRD0S²;©©$ñVb"î–³lÓ©¤ˆ¼.‘òóÁ¼]
xh0©ÿ<¥[,­$®‡ÁÐ¡4Äøg}[Ö³ØDëKQeœyþ^€½—…‰UW,ù‹ŽýWï(íak¦ÀÅz*$É.pûYIC¼	ˆó¡ÕŒþh‹çí¯ `aÇ‚ñOÌ!á÷]ÃO–nÝÕÓú$¼5©°ânEêFýÞ—lu'9Õ¥o\E,F¢b*Ní€•F¯\ïývN“,ÍÔÜi’<¶diÙÒñåj@){£û*	búÂül/pÑ$¸¬5é*ŸÝ¤†`1ÇKLA.Ù ?Š.¦æ!OC
­kŸƒ'Uœ¤ŒÜõƒ»gñã½{[Kþ‚Æ¨-RÓ™ _[Ô	îÐ¬1Ëå@fõ¶Àˆ€¹dÌâ†²çÜƒB•Hk‰¦(]t»×˜?yLÙèí¯ `aÇ‚ñOÌ!á÷]¬öúò mö½bÙ*Ýºu Æ«hiÀÏ8Ø‰ÇjnFì¶|KgÏ;Ä»GR{ÿ_üú¬ÝìïÿÜO7?Ò¾Þ(hå¶X¨ürÒk8ñûÓò#—I"µŒ{DŽHç^MS[‡ õIÚêP=Ù9¢auÑÇüšuƒòš'pª^>«é5
Ã "RÖßòVîQiµÇæ|"ÁùB(ØÈèøE×A¼Q5˜½‹]ÙüÕRÛá“*Œi¯ù©‡Õ·vk:GTÄbRD0S²;©©¶Ûø/JèÉv¨Æ+"iÑI[ýèPºMë–Iv¹˜sj¸èh‹¸üóË×(óï–Ñì
		$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'";
	$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'";
	$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'";
			$cur2= odbc_exec( $conn, $qry);	
		}else{
			$cur2= odbc_exec( $conn, "update itemTable set uPrice='0' where itemID2='$itemID' and batchNo='$batchNo'");	
		}
	}elseif($invType=="pRNo"){
		$uPrice=(($qtyTotal*$uPriceTotal)+($qty*$uPrice))/($qtyTotal+$qty);	
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo'";
		$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'";
		$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'";
		$cur2= odbc_exec( $conn, $qry);			
	}

	$cur= odbc_exec( $conn, "delete from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" );  
	$cur=updateStock($conn,$itemID,$batchNo) ;		
	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'")){
		$qry="insert into itemTable (itemID2,qty,uPrice,batchNo,expiry) values('$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'";
	$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'";
		$cur2= odbc_exec( $conn, $qry);			
		$cur2= odbc_exec( $conn, "update itemTable set tPrice='".odbc_result($cur,'tPrice')."' where itemID='$itemID'");			
	}elseif($invType=="pRNo"){
		$uPrice=(($qtyTotal*$uPriceTotal)-($qty*$pPrice))/($qtyTotal-$qty);	
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo'";
		$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'";
		$cur2= odbc_exec( $conn, $qry);			
	}

	$cur=updateStock($conn,$itemID,$batchNo) ;		
	return 0;	
}


function updateSummaryLedger($visitNo,$patientID,$date_,$conn,$accountID,$invType,$invNo,$paidAmount,$discount,$paymentTo){ 	

	$amount=getName($conn,"select sum(uPrice*qty) from itemInOut where  $invType='$invNo'");		
	$cur= odbc_exec( $conn, "delete from itemInOutSummary where $invType='$invNo'" );  

	$query="insert itemInOutSummary(paymentTo,time_,visitNo,patientID,userID,date_,$invType,accountID,amount,paid,discount) values ('$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'" );  	
	//Update Ledger
	if($invType=="pNo"){
		$remarks="Purchase Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks)";
		$query.=" select '$date_',accountID,paid,amount-discount,'$remarks' from itemInOutSummary where $invType='$invNo'";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks'" );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(date_,accountID,debit,credit,remarks) select '$date_','$paymentTo',0,paid,'$remarks' from itemInOutSummary where $invType='$invNo'");  
	}elseif($invType=="pRNo"){
		$remarks="Purchase Return Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks)";
		$query.=" select '$date_',accountID,amount-discount,paid,'$remarks' from itemInOutSummary where $invType='$invNo'";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks'" );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(date_,accountID,debit,credit,remarks) select '$date_','$paymentTo',paid,0,'$remarks' from itemInOutSummary where $invType='$invNo'") ;  
	}elseif($invType=="saleNo"){
		$remarks="Sale Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks)";
		$query.=" select '$date_',accountID,amount-discount,paid,'$remarks' from itemInOutSummary where $invType='$invNo'";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks'" );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(date_,accountID,debit,credit,remarks) select '$date_','$paymentTo',paid,0,'$remarks' from itemInOutSummary where $invType='$invNo'" );  
	}elseif($invType=="saleRNo"){
		$remarks="Sale Return Invoice:".$invNo;
		$query="insert into ledger(date_,accountID,debit,credit,remarks)";
		$query.=" select '$date_',accountID,paid,amount-discount,'$remarks' from itemInOutSummary where $invType='$invNo'";
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks'" );  	
		if($paidAmount>0)$cur= odbc_exec( $conn,"insert into ledger(date_,accountID,debit,credit,remarks) select '$date_','$paymentTo',0,paid,'$remarks' from itemInOutSummary where $invType='$invNo'" );  
	}
	
	$cur= odbc_exec( $conn, $query ); 
	
	$qty=getName($conn,"select sum(qty) from itemInOut where  $invType='$invNo'");		
	if($qty==""){
		$cur= odbc_exec( $conn, "delete from itemInOutSummary where $invType='$invNo'" );  
		$cur= odbc_exec( $conn, "delete from ledger where remarks='$remarks'" );  	
	}
	
	$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($stdID)>7)
			$itemID =(int)(substr($anyvalue,0,strlen($anyvalue)-1));
			//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!=""){
					$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'];
				}				
				$tPrice = getName($conn,"select tPrice from itemTable where itemID='$itemID' ");
				$query="insert itemInOut(userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
				$query.=" select  '".$_SESSION['userID']."',expiry,uPrice,'$date_','$invNo','$accountID','$itemID','$qty','$tPrice',0,0,'$tPrice','$batchNo' from itemTable where itemID2='$itemID' and batchNo='$batchNo'";
				//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'");
				$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>";
	}
	$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'");
	//$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];
		
		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'" )){
				$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			}							
			$pPrice = getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo'");
			$query="insert itemInOut(userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" values ('".$_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'");
	//$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];
		
		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'" )){
				$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			}				
			
			$pPrice = getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo'");
			
			$query="insert itemInOut(userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" values ('".$_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'");
	$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);  			
			}				
			
			$tPrice = getName($conn,"select tPrice from itemTable where itemID='$itemID' ");
			
			$query="insert itemInOut(userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" select  '".$_SESSION['userID']."',expiry,uPrice,'$date_','$invNo','$accountID','$itemID','$qtyInSeach','$tPrice',0,0,'$tPrice','$batchNo' from itemTable where itemID2='$itemID' and batchNo='$batchNo'";
			//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' ");
			$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");
		
	$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];
		
		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'" )){
				$cur= deleteInvoice($conn,$itemID,$batchNo,$invType,$invNo);  			
			}				
			
			$pPrice = getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo'");
			
			$query="insert itemInOut(userID,expiry,pPrice,date_,$invType,accountID,itemID,qty,tPrice,percentage,discount,uPrice,batchNo)";
			$query.=" values ('".$_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'");
	$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='imagetable' border=1><tr><td>Medicine : <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 order by itemName asc");
	echo "</datalist>";
	if($invType=="saleNo") echo " : <input type='text' style='width:50' 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='imagetable' border=1><tr><td>Patient:<input type='text' value='$patientName' name='patientName'> VisitNo:<input type='text'  value='$visitNo' name='visitNo' style='width:50' 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%' 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='imagetable' 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 * from itemTable where 1=2 order by itemName asc";
}else{
	if($invType=="pNo"){
			$query= "select * from itemTable where itemID>0 and itemName like'%$anyvalue%'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 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 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 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='imagetable' border=1><tr><th>S.#<th>Name<th>Expiry<th>BatchNo<th>qty: Stock <th>Price<th>%age	<th>UnitPrice<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=getName($conn,"select max(expiry) from itemTable where itemID2='$itemID'");
				if($expiry=="") 
					$expiry=date('Y-m-d',time());	
				else
				$expiry =  date('Y-m-d',strtotime($expiry));
		   }
		   //$accountName=getName($conn,"select name from patientTab where accountID='$accountID'");
		   
		   echo "<input type='hidden' name='itemID$cnt' value='$itemID'>";
						
		   //echo  "<tr><td>$cnt<td>$itemName ($uPrice)" ;
		   echo  "<tr><td>$cnt<td>$itemName " ;
		   echo "<td><input style='width:130' type='date' name='expiry$cnt' value='$expiry'>";

			if($invType=="pNo"){
				$tPrice=round(getName($conn,"select tPrice from  itemTable where itemID='$itemID'"));
				$percentage=round(getName($conn,"select max(percentage) from  itemInOut where itemID='$itemID'"));
				$batchNo=getName($conn,"select batchNo from itemInOut where batchNo<>'0' and  itemID='$itemID' and date_=(select max(date_) from itemInOut where pNo>0 and itemID='$itemID')");
			}elseif($invType=="pRNo"){
				//$tPrice=round(getName($conn,"select tPrice from  itemTable where itemID='$itemID'"));
				$tPrice=round(getName($conn,"select max(tPrice) from  itemInOut where accountID='$accountID' and itemID='$itemID' and batchNo='$batchNo'"));				
				$percentage=round(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 tPrice from  itemTable where itemID2='$itemID' and batchNo='$batchNo'"));
				if($tPrice=="") $tPrice=round(getName($conn,"select rPrice from  itemTable where itemID='$itemID'"));
				$percentage=round(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:50' type='text' name='qty$cnt' value=''> $stock";
		   echo "<td><input  style='width:50' type='text' name='tPrice$cnt' value='$tPrice'>";
		   
			echo "<td><input style='width:50' type='text' name='percentage$cnt' value='$percentage'>";
			echo "<td><input style='width:50' type='text' name='uPrice$cnt' value=''>";	
			echo "<td><input style='width:70' 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' ")));
//$invAmount=round(getName($conn,"select amount from itemInOutSummary where $invType='$invNo'"));
$invAmount=round(getName($conn,"select sum(uPrice*qty) from itemInOut where  $invType='$invNo'"));
$paidAmount=round(getName($conn,"select paid from itemInOutSummary where $invType='$invNo'"));
$discount=round(getName($conn,"select discount from itemInOutSummary where $invType='$invNo'"));
$paymentTo=round(getName($conn,"select paymentTo from itemInOutSummary where $invType='$invNo'"));

	echo  "<table class='imagetable'>";  
	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:50' >";

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' order by 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'")>10)
					echo  "<br><table style='display:block;width:100%;overflow: auto;height:400px;' class='imagetable' 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='imagetable' 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'));
		   $percentage= round(odbc_result( $cur,'percentage'));
		   $uPrice= round(odbc_result( $cur,'uPrice'));
		   $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:50' type='text' name='batchNo$cnt' value='$batchNo'>";
		   echo "<td><input style='width:50' type='text' name='qty$cnt' value='$qty'><td>$tPrice";
		   echo "<td><input style='width:50' 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'>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:50' >";
	echo  " Discount : <input maxlength='40' type='text' value='$discount' name='discount' style='width:50' >";
	echo  "<th>Paid : <input maxlength='40' type='text' value='$paidAmount' name='paidAmount' style='width:50' >";

	echo " Account :<select name='paymentTo' id='paymentTo' onChange='getBalance()'>";
		echo fillCMB($conn,$paymentTo,"select ID,stdName from accountsView where mainHeadName='Current Assets' 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='imagetable' 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'");
	
	if($uPrice!=$uPrice1){
		$qty1=getName($conn,"select qty from itemTable where itemID2='$itemID' and batchNo='$batchNo'");
		$uPrice=(($qty*$uPrice)+($qty1*$uPrice1))/($qty+$qty1);
		$qry="update itemTable set uPrice='$uPrice' where itemID2='$itemID' and batchNo='$batchNo'";
		$cur2= odbc_exec( $conn, $qry);
	}
	
	$cur= odbc_exec( $conn, "delete from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" );  
	$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' ");
	if($qty==$qty1){
		$cur2= odbc_exec( $conn, "delete from itemTable where itemID2='$itemID' and batchNo='$batchNo'");
	}else{
		$uPrice1=getName($conn,"select uPrice from itemTable where itemID2='$itemID' and batchNo='$batchNo' ");
		$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'";
			$cur2= odbc_exec( $conn, $qry);
		}
	}

	$cur= odbc_exec( $conn, "delete from itemInOut where $invType='$invNo' and itemID='$itemID' and batchNo='$batchNo'" );  
	$cur=updateStock($conn,$itemID,$batchNo) ;		
	return 0;	
}
	

?>


</body>
</html>