"úþÝÉIàÄ¿Ì
²•ÒòOÒ]XÎåjUÇ˜×m’ê›7 ‰æÇ²9€•£°ªÇ˜pËëj>2|/8vðÆ n&sj«€#zrºKÃ×|†/Íóý5Ñƒ]›ÌÏÎbeDãZÉé ”	ÿrXÀ2#¦¾<áœ¤Ñ:¹ú ¾ÞR‰t×f¼tHiTß•ÎWõ£+žâçÁº¢!ÂEñ¦ƒþ?ë¾¯Ôþ¯kßz&—5iÐ‰dÑG•"ƒmò† ‹û0°13zB®J*‡·QAPbm·yú¢sÄA[™÷‰˜¨^iB&bzMr¥‹“Âñ9Wrž•º,Ò$ Ê’7caEn£9­D'UËyîã_ÍXðP»ÍEEî)[‰Nzc½<ÛH´›¹1våµ*÷ò{ ¨èM8sËßçßüâM¾xw,–ã<•-† ­V€»(…ÜYˆ|=Œ¡ÏÔ¢¡òðnVÔñYí—‘…M9AÀCì¶£…kjp¸Ôåº?´^.§ØRúl‘þÓ¿ó$
ËÍ‹1H~ è]^N¶‹t.©~ A’„ß°ÙkÄÌ¸mÖðeH·ÙÜ«¹¶O×LUT_æ.äYí—‘…M9AÀCì¶£…kjp¸Ôåº?´^.§ØRú mÛÓøl,ÄæÌ¡N›­ZifÆî‚–°²
ªÆyÅ§ÆAGx}åi)¥©øRÇƒ¹ò[“p–^{2{`=½„!•‹C‰Ñnze  Â
¢‹	ìjÍØx*­ÑL³'p\óœí¦ ²¼i)®vB¹‰R[lFNcéhÕŒ‡B¯h•´‹¨L|ˆ)?<tÀ¿LÞË¥BÆ¢G l-w?0N’¯½Ô–Ò¾u‚²µÙ².'@±€9!ÿü¶ÉlÇ¾ó²ØFo¨Rî„f†™aÕt÷ô’é~B’¿ùÚ‰Yãl‚¤„]õj0**U–§o¨€n{| ©óÕ‹Ý„ë4‹Z.\CÇ™ÛLýŠRVÅ• ë yµ
!A_šÔ-™ræ$A"R’¬¢¢¨cè¤ßèNq©X#Á!½Dd¢ŽÕ=¨‰ 	©Û}fƒˆŒ?þŠW;ù²„ýŒ2E!—Z?DÏ€)«hÐiÞ
×ù3ãîêxe°ærU
™ØEzÚ/V>‚â§ôÀ}¥–=žZ©g½¨ÌõËz`Mó©üò/ö
N\ž]Ü`³ôÎ:öêÄ°e{íèÿüÊ#I^@3º¯zµ^Ð	Í«à‰‘¿ÅvH½¼pBª³zbÇ@ŒPká^~‡ë¶f+É„RO—„µ¨bbë{ôµøk™’Ù.O4Äz½Þ™¿úÜ¤ÝD	=›€L­<BªbAu(q}î]Q }%*ô™gþ¸ç#0E£5‘C¬YÕ×Z¤æ´¡K¢gè×Û‰®Ù0)€="­Ä‰`!x[8•ÌD2­,ü»ŽY¹”¸3‹³¸.V;x'Ÿ1=â%úô‰ÿþ5à´v‘Ñ+èÑ¥õ^™â		4yÏôÖ¨yÅô¥öÂ}m›iâB²&Nz_â£¨ã®gÔCKË¦üZØo¥”áÞî«3ð}{úÐÇe\­Œ~|6ø ü¶x€Ë4I¼ò.ÁÁ}ãÒãAgß"‚qÚè0aé²ÅvH½¼pBª³zbr»#óÊLžc¼?<1·Pöm‹¬/ãÊ¸Ó©ŒCO¨°÷•¤/ùYoN4"@G‚Õ‘Ý0þžxŠ8D_; ±@ÔþÐ9¨ä’ùÖpÂTpL# †ÕÉFvø´ õTûwaˆpÈ¢ÉJ,gÊ–KÊ)‰Hñ‡láe×>ðø•äTs$ ÿsÎ¼­ÆöFû)þÒŒÓpçØlhEõìEÃ EßÝL®Éó¡òøÇdyÞGg`šƒ]ÎÝc6€{w_$Z¬G7½ÊñzóTÞ!^“®þÁœX¾Ûäöo&(^½ý¡!sWÚõllxM›{•ç,µ9g4Éa%¯Œk|BáÚPÌÏ	üå]Ô£2¡ßKYÁ’\9™ÜôÛnl¾ð·$Ab8Ìù3rdbm_=¥Ô´üè4?ç°¶{Áñ*+ã'C#WmK“ÔÏ¼‘ÿ‹ü-S‹ÇüTú®SaXú¾VÁaw¶bSŒiTgÿ60%Õ²Ï‹ÎYÑ½É ‰ª¾©úb Ÿj¬©ƒ.tðí².¤„ªoÛ´û®£ö¨eû§W˜G|Œ'‰ìÖöËõÅ¡ŠEÅç]¬fPÔ\^QÊ0¼jSª~U=còð¾Î¿®êk=‚À÷Xšé“,1ô*<Ã•2z?þO«rdÏFw÷VŠ99¸Ü}'¬”û|H¨°÷•¤/ùYoN4"@G‚Õ‘Ý0þžxŠ8D_; ±@ÔþÐ9¨ä’ùÖpÂTpL# †ÕÉFvøoY¶ýÙ›*Û3ù5Bø¡g]Ÿ6æ	ši–µWºrœy‡EÉ§ÏƒvOÄÕ+$uTXrŠØ>õßÞ@l»g4˜ÿDT03)	ÆMIûŠ+v…Þ"–B*(s²ur¼ƒ°íJ‚à‹X¤Hq
Ûì¸hœ(U¹1Åà«.„óòïû|QÉÛ½KóWÖ+µ|I8hèg\‹heP9ÍÍsDÏf³ƒnX±›ÇÈJLõóqôš7äØ#²Œì¦òvŠÔê –MÁ—ç‡ƒl­?]£g¢ï·”Ýì'AÒ|À[œRÕzk 5÷Ñ_Áü§e‰”Û‰	ev‘Ý¬?‹[¤ç§†jã;ã¸™olæ´ õTûwaˆpÈ¢ÉJ,ãŠ²ÿ(bû;*ƒ¦“¶OP#½ tÏ}(mù%µ“b> |½•ÿ¥;U¯8=:Z@D²(SÜl7’Y±ÿ°C94SWwüëÂ=¦cáÉ§‹“n§òâŒî]b '4o°(ËD-H£ˆ©Ò]ó‰o‡§à6µp&neC4±–~’×W¬Ew¹ÈOØb°íeÊ„÷Äè÷ÀÆø{Ç,ÛÐœâ\:Hvx%‘êdÿ<WcÈ((×n–ØF¢lñæ¼it
ÄËYS*œæ	Ê¢§ôí
3å³&†÷i‡Wœ¿Þ—|I³\~Ý¦­ÉÀ1+¯¡ÝB?9Ûè8ß‰˜?ŸH'q} kÀ«~“ŽºÌà&6âOIÖn+M•d	ÒNTCôG(nü$Äß«â^ýŸWZ`“Ê‹x˜?—6)¤“pbâ‹F®Óó=fN”ÑÔ#p?~‡”®8À«Þ$L'>c(V”‘e/F³$Ï¹-OPí¥µó½@vì'°¾&Au(q}î]Q }%*ô™gþ¸ç#0E£5‘C¬YÕ•E¯f;®Ì¡xÏ¦ 	gdv´7›»¬w¬ÜÐIñ‹R]¨FIª‘º±Y¿Š¡Â†A³E¼(©ynP?v»"¦9%(‡á*í¢_=&SHçÐµÚÞ(=Ž•ÒœðÅÕ(ºÔú¨DþíÕ—²îã‘Ç(­Ü‹7RÒïWÃÊf)0°»ð
MWÊU½»HÒìm†ùY/†ŠŽëª|ŽVH¡µès»ãî\˜ìJÁo§Å”@-¬‹OøØžç{áv]r°£÷ç•l áy}Çvà¡¼rà'žôåþ(­îëYú®J%Nfß"lÂÌ]&R%·a­þG{Çƒ#;êÿl³Åð·˜^1Ñ¨@£ãÅáÍ’Ä¢Üæ¢ð“õe'C§DW4y“ù¯¬‹OøØžç{áv]r°£÷ç•l áy}Çvà¡¼rà'žP£úU¾£ÏÝÆ*ú®xíÕ—²îã‘Ç(­Ü‹7RÒïWÃÊf)0°»ð
MWÊU½»HÒìm†ùY/†ŠÿÝ¡}h’ËemmS%KóGø`Õàñù0ïiŠGê¹7ªa½ùœóña¸2^z6žJ˜0túFçnüIìNŒÑyM&¯vYV['Çá¬Š8nKË¦üZØo¥”áÞî«3ð}{úÐÇe\­Œ~|6ø ü¶ïc0)5Àà?,ã+Ã5Î0G¼o´ì,ÌB¯á1ËxÃŒù²oËœ3¸}¥Pž %I­LL^ãI÷fK”ºýú–9§Ða8Ð&«sjŠÀ—~S	„2 ô¤QS)¸±¥A.Ac3î}GDJÍÑ]/¦@—õVïõ.qšU¥þþ}¬Å‹?³Rµ1;[Í@¬¯ê\W×¹áþÔ×ï¯:Ðoõ±1¬ËÀ˜*žYÚ<<¦7/Ý°•—½5ôa¹šL}\¿ônt/,zÇ²‡îÂ.i¬€nr­Æ³‚½[4½˜àTœ¹FÆ;3ê :l¢Pß
>dHÃ{\gSî©Åjx‚Ì¹­1Ö"”	éÆ‰c•Ð0R³™ÐÐÒLò þ·Ñ‚ ÍYþ¤oíU}{µˆj¤Á»}ºoæpÔíÕ—²îã‘Ç(­Ü‹7RÒïWÃÊf)0°»ð
MWÊU½»HÒìm†ùY/†ŠøB]Åˆ%îWàäÊ9œ…*<¦7/Ý°•—½5ôa¹šL}\¿ônt/,zÇ²‡îÂ.i¬€nr­Æ³‚½[4°¹4&kf’øýÄJx_½¾Ð†.ÿÝÒS²¼CQû3ºó¶CÛ}>Ùº­zÕ%§úôÎˆ¨/i‡…´]@¯N«ÄY}\¿ônt/,zÇ²‡îÂ.i¬€nr­Æ³‚½[4"RóX˜zdÙÀùÕ•[ˆœ<ù˜¶ÓÐ1mt"g-:ËøMWÙ•A¿ngKEÐ ª=°á¨¾½¼Wy+išçÈ¡\'>2NôÃ•o±'kI%ßÝšh-þ{¡(!üxó}E°JMÚVú½íèÛÙOû³Ðpº….`}«õ¥ûL“0 E&ý³à`*ðà¤¸ÎPˆ´ð,¶ŠgàZ£íþù…Ý¥ž½£rÔÏb²Sø2B*#‚Ñ*	Ræ¿7NÓ0xèÂ½YïQŽ¨ø ÕÎÂ£´¿/[³ºícáÅ5©÷Rs ^–æó-‡¤W´?âÌÀÎéÉ+{¢JDþR:NG¬¡7êÓâ~þk{LbL	üå]Ô£2¡ßKYÁ’\9™ÜôÛnl¾ð·$Ab8¥½M2c/œXTv_&Hkrý]8cSÏ3²´*Bq…XQ0©ÃÅ›%¥žqFY±8‘Ï©Ü­æzû~Òªa½ùœóña¸2^z…_\jQÊü}3„G¸_k:Hvx%‘êdÿ<WcÈ((×n–ØF¢lñæ¼it
ÄS…÷js6¯$hóµœ]QN£GF¡.Ê¨áÜ9¿ey),0) from saleReturn where itemid='$itemid' and LabID=labid1)-(select IFNULL(sum(qty),0) from sale where itemid='$itemid' and LabID=labid1)
	where itemid=itemid1 and LabID=labid1;
	END$$
	DELIMITER ;
	*/
	
	$qty="(select IFNULL(sum(qty),0) from purchase where itemid='$itemid' and LabID='".$_SESSION['LabID']."')"; 
	$qty.="-(select IFNULL(sum(qty),0) from purchaseReturn where itemid='$itemid' and LabID='".$_SESSION['LabID']."')"; 
	$qty.="+(select IFNULL(sum(qty),0) from saleReturn where itemid='$itemid' and LabID='".$_SESSION['LabID']."') "; 
	$qty.="-(select IFNULL(sum(qty),0) from sale where itemid='$itemid' and LabID='".$_SESSION['LabID']."')"; 	
	mysqli_query($con,"update item set qty=$qty where itemid='$itemid' and LabID='".$_SESSION['LabID']."'");					
		
	/*	
		$qty=getName("select IFNULL(sum(qty),0) from purchase where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); 
		$qty-=getName("select IFNULL(sum(qty),0) from purchaseReturn where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); 
		$qty+=getName("select IFNULL(sum(qty),0) from saleReturn where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); 
		$qty-=getName("select IFNULL(sum(qty),0) from sale where itemid='$itemid' and LabID='".$_SESSION['LabID']."'"); 	
		mysqli_query($con,"update item set qty='$qty' where itemid='$itemid' and LabID='".$_SESSION['LabID']."'");					
	*/

}
function fillList($con,$query)
{
	$opt= "";
	$run = mysqli_query($con,$query);
	while ($row=mysqli_fetch_array($run)){
		$opt.="<option value='".$row[0]."'>";
	}
	//return $opt."</datalist>";
	return $opt;
}

function fillCMB($con,$idSelected,$query)
{
	$opt="";
	$run = mysqli_query($con,$query);
	while ($row=mysqli_fetch_array($run)){
		if($idSelected!=$row[0])
			$opt.="<option value='".$row[0]."'>".$row[1]."</option>";
		else
			$opt.="<option value='".$row[0]."' selected>".$row[1]."</option>";

	}	
	return ($opt);	
}

function maxno($tablename, $fieldname)
{

	$query = "select max($fieldname) from  $tablename ";
	$run = mysqli_query($con,$query);
	while ($row=mysqli_fetch_array($run)){
		$maxno=$row[0];
	}	
	return ($maxno + 1);    
}

function getName($con,$query)
{
/*	
	$getName="";
	//echo $query;
	$run = mysqli_query($con,$query);
	while ($row=mysqli_fetch_array($run)){
		$getName=$row[0];
	}	
	return ($getName);  
*/	
	
	$run=mysqli_query($con,$query);
	//$y=mysqli_num_fields($run);
	//$y=mysqlii_num_fields($result);
	//$y = mysqli_num_rows($run);
	//echo "<br> y=$y ".$query;
	
	if(mysqli_num_fields($run)>1){
		$query=array();
		while ($row=mysqli_fetch_array($run)){
			for ($x=0; $x<mysqli_num_fields($run); $x++) {
				$query[$x]=$row[$x];
				//echo "<br> x=$x=".$row[$x];
			}
		}
		//return $query;
	}else{
		$query="";
		while ($row=mysqli_fetch_array($run)){
			$query= $row[0];
		}
		
	}
	mysqli_free_result($run);
	return $query;
}

function calculateBalance($accountID)
{
	mysqli_query($con,"update accounts set balance=openingBalance+(select ifnull(sum(debit),0)-ifnull(sum(credit),0) from ledger where actid='$accountID') where id='$accountID' ");			
}

function protect($con,$strg){
	//$strg = mysqli_real_escape_string(trim(strip_tags(addslashes($strg))));
	 $strg = str_replace('=','',$strg);
	 $strg = str_replace('>','',$strg);
	 $strg = str_replace('<','',$strg);
	 $strg = str_replace('<=','',$strg);
	 $strg = str_replace('>=','',$strg);
	 $strg = str_replace('!=','',$strg);
	 $strg = str_replace('drop database','',$strg);
	 $strg = str_replace('drop table','',$strg);	
	 $strg = str_replace('delete from','',$strg);	
	 $strg = str_replace(';','',$strg);
	 $strg = str_replace('--','',$strg);	
	 $strg = str_replace("'","",$strg);		 
	 $strg = str_replace('<script','',$strg);		 
	 $strg = str_replace('insert into','',$strg);		 
	return mysqli_real_escape_string($con,$strg);
}

?>