“¿†y€¦µØ®8Öè§ “)çO@¥8ýŸžìE»·š½Ì®–ªyÑÇœGdÁ =nv )ˆ^)vcµÞX#Àd§xWs¼3á„ºÂ(†Þd÷>©ŸØ9‹'ƒ®~ è]^N¶‹t.©~ 4AïÏx)gP„ûü¾ðŸÓK‚¸ÈRz-³Qt­ºðÛ7£ö=o-‚=}¬4-Ç¸Õ:fÁ	±àÅõ®l°ˆúg?€“·„UÝ…nà­ì»}Ð÷aº¬<®<©y%úÕ^ÄôaP{ñßc°6l/úÞ´½âmô@V»‡f’I½Y-h¸ôYƒŒs´ËÅ9õ¸š%äðA—G7<è¥üÕœº‘Iµ>´ÀÑ)\ZêáX]¸¯”i?–.3ß”:Ð©z¯áí_+‹çK9Pùî+Ö´ôò t-l@‘!4CRh+ØQçI/\Ówîc@
×±d`Ô‡ Å.>Ä„%hn;Þ²(ÆñiÉ`ânyŽoVøôýœBRà?6&,}UŠZÀB„\Ô„´»$ô]‰oAÝÁÆùúÄÁ‡¬|Ç>lè;d@÷Û=åÑBìóü·VQ—ÈÏ„%hn;Þ²(ÆñiÉ`ânyŽoVøôýœBRà?6&=£‘J|˜¼ý¡ûI»ywŸ#‰i<Ý'[;k5zN.NÖ‰ÇÕnšuã£:`!Í5“Ñj­ªˆân Ïàù¦„‚?K÷¶òíð:5Š}3â5·¿SÈPûXud*!	·\óÃxÇóÎ2ˆeöä÷ë˜ä1Ãx4]áóX‚ªªþ 2ß@	Þ:—MéÞWMUÔzsy2êÂJa^g¼¯²¯hÍ©eÝpZÍ½Rº2}® :öætiâp¾n7Ú]D }ZÕçÉË8Ö
O6¾þêàA°}|ìG0¾KÇM]ù=Yg¦Bâ€,Ã T¬cp>nuC¦fÇc¹­¨dD:%f6AÝ5ÖÕkR]ˆ+Ÿß3ìÛ++³s—Ó"­[‹ˆÑ=üGÁu|‰¨é]“ãòŠ›>[íI~=˜†ÖË&ú—ÿ1vÄ/‚åc´1FÚ¦$ì”ïzˆZF°}J<Hr"Àº/'\B2ÂW Í·«gè0OóÍ>TñÑžq¼Çù›·¯"#î^ãr^áp èApŒÛZö[á¨¦J(yB´LK0ÔÊ«!~P¦Ñ‚Š†xkÍM1I×~‰”Ç¬Kð8à‚o­'@1ËxÃŒù²oËœ3¸}F§ÖÀº“¹å¾ÏÃ¢¿DT03)	ÆMIûŠ+v…Þ"–B*(s²ur¼ƒ°íJ‚à‹X¤Hq
Ûì¸hœ(U¹1Åà«.„óòïû|QÉÛ½KóWÖ+µ|I8h‘î§©}‘9ò,ÊZ§zù?}\¤\aýƒKa4@QN£GF¡.Ê¨áÜ9¿eyãÅcªK€àÂV§g¼I¶À5ZQ!sty@pN[ÇFu…8Â›|R¹¥Æ/á|ðo#WmK“ÔÏ¼‘ÿ‹ü-S‹ÇüTú®SaXú¾VÁaw¶bSŒiTgÿ60%Õ²Ï‹ÎYÑ½É ‰ª¾©úb—’8€JjÔ•
‚.¶ˆ°W§É_@ý‘ÛßÙSFÅ,1ËxÃŒù²oËœ3¸}m´¦)j¸ú˜7—Ù(ýqßkW(ÒC0sÝöˆÞcƒ>àdÞÊ§R–ÖU–ð‚!\âfëfyL5ß©Þr‚ ªw"lÂÌ]&R%·a­þG{Çƒ#;êÿl³Åð·˜^@Ò×+ÇNiå’îÒ-fÂßx"ðÂß•áuÛ_ï£B	ö³jí«í34 @	2;½…¦êÐ¦t=V¬[uHÐk´#•âŒéo5L³rV~iž8-( OZDÛY]úßFz¸õ ;(nÛÂìkrý]8cSÏ3²´*BQ¹ ‹WÅËÈ¤ÁK—¼Ô1]«·ï {õ—Í7]%ÒÆ—
w‹H¢UÏÎ·(×$Ö¢äÄ)†)‘Á€ü–‹ 7óÁM<9Á±ö³<€Ü((Ž”·Š¤Ëée#ÚpIÕºpKÊŠ2örŠ¿|Ýˆxpí¶Á–0¸b—¡/Z+›«Š8Ø{0V@Ÿ	P`KÇ?©¨ÁãaþÜ?NÒ$øÎcŠMhØñ –.û vMëWýÛÝRÅZAåuäñ‡·¶*—0Kâª&G¤ßKÄ'—V,uF:ý?n(ÿuQ©¯HVŽ+gtÛC3Òr0[8•ÌD2­,ü»ŽY¹Pžñ^;Â oÂà“þ†rSº²€‹ƒZPÛ ¤ôç¡%@ßã	DŠsš	
Ã:r¾-Î¯û)Ò´%ÚªåIÅ_.[dÞÊ§R–ÖU–ð‚!\âfëfyL5ß©Þr‚ ªw"lÂÌ]&R%·a­þG{Çƒ#;êÿl³Åð·˜^–…‡Béæ[¬8Mç‘¼÷P¡‹áTCzÉ¬ÊMÓ£AS¥ã”ljÔš`e×Ç	œ½v«§:è	mçL	ù/CþPöm‹¬/ãÊ¸Ó©ŒCO¨°÷•¤/ùYoN4"@G‚Õ‘Ý0þžxŠ8D_; ±@ÔþÐ9¨ä’ùÖpÂTpL# †ÕÉFvøìå5b.è˜6cô>È¡©*»/gÇÄóÒ„ÉP#½ tÏ}(mù%µ“b> |½•ÿ¥;U¯8=ä—Kži&Y~”Ä‹ŸªÝ¿*¢Š+¦#Ra'Ó•£ßµÐ<¼eýäëuÎ>M@dÚÔÜ-¸[D[4LË5@Ò×+ÇNiå’îÒ-f”!„¦ïoØš§Ý¬y	Ò±Ð"¿'ãrTnddµÅµ+;§¯¡Ý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Õ…Ë‚vÒ„ŠÊ8~èÃ¾ÑýFVRp£ÉÄ“.!æÕ½n9ê˜
ì±‘"w¨ØŒ7X¹JEûÎÑŸ„ÂJ³õÏ$g8ñv'À»¼ä2?.ò¢))»M÷½S…ëËë€ž>lìºÙ¡R*µTæ8zÃJ	dbIpu¶÷xùjz¤1næ´%‡u¾&ŠJŠc¦ï5&ÂÐ\®O2q¬±‹­f” )wTÒo|ÔLkdC(U¹1Åà«.„óòïû|QÉÛ½KóWÖ+µ|I8hx	PÑQXd†Yée~›/üFp_¼Hçïæ`Äìî©Åjx‚Ì¹­1Ö"”	¸ÿãP¼þ‰Šg–WÜu	åÎ2‘rÐÜ}k‹ã°]Ë›rv.ÔÂFe'ò–4å¯¤vi•$B‹Ryõ]5anJÏ!w–;våƒãÓq?ŽqÌ¡'¹ÁÆ­Ö«z{ôF6®ÚÈzUÑ1ò?Ñäb…Ž2³:—]ÞµÕK==ŸÆ¨"Ð3ô‘¢OŠiY$8È˜T‹¥28dåpZV¸Öª;7¡Wïç?úüXê¡)ŠcÄŒa³h û•½éàÓ<¦7/Ý°•—½5ôa¹šL}\¿ônt/,zÇ²‡îs,%pÐHs®ßv £$?egì9˜â«_FŠïDÞÈ˜T‹¥28dåpZV¸Öª;7¡Wïç?úüXê¡)Šcø1Ù5H¨œwi+ÛOHóèØ¯‡¾ ½ŽpÅ¹öÜívÌ¡'¹ÁÆ­Ö«z{ôF6®ÚÈzUÑ1ò?Ñä(³J*d6Uÿ®T|·Ò“¡hgýß‘>à:Ùºežf°8ÚE`Þé	PÄ9®^7BÖb¬âƒãq´‘FL¯°[_E|¢¦ÅÙ`Ì›w¶bSŒiTgÿ60%Õ²Ï‹ÎYÑ½É ‰ª¾©úb.ž¿´˜]§ÄJôwñÎì) ÿljSu›ÞkÎÒµ[9"Ì‚Ž3rdµ®{MÓ’7c[fù"çàŠòR/íÕ—²îã‘Ç(­Ü‹7RÒïWÃÊf)0°»ð
MWÊU½»HÒìm†ùY/†Š¨1ëë‘¶x\HÒ“àl-ÃËµÄáÈ6Kz¾¦~	—hl.y‚W³<Ï¼¤ù¢Ýƒ¦x±²õ¥<Û#%Kçù‡7Ìvì^ìÛºøÕÛ8`Õ]„NLtÊïò+|°¯'£ˆ¥ÒÆñ€,qãpï¬²‰jG;üö†TXW%¶‚zÐæL•Ÿ#ÚÄ¿NGR ñª‘M‰LåHÐ 0#fˆ3ö©Èz\¥P§CD&cÂÙI¨³m,Ómü»l—jˆ¦€@§Š+´.Ã2¸¢<%èØ¯‡¾ ½ŽpÅ¹öÜívÌ¡'¹ÁÆ­Ö«z{ôF6®ÚÈzUÑ1ò?Ñä&[âoXîŠ)q3èÒ‘Æ‡7Ìvì^ìÛºøÕÛ8`Õ]„NLtÊïò+|°¯'£ˆ¥ÒÆñ€,qãpï¬²‰F “Ê¶ÒXä”HÎ*C+
eÑ÷lb`3þCBòÈ×sPšr¬Þ¯¦
}¹£=`»,PO%S™mÐ8`Õ]„NLtÊïò+|°¯'£ˆ¥ÒÆñ€,qãpï¬²‰ÐÕ£¤ê[ªæi<8óýgä¯‘Çx÷W7Uq•³0%cd[æþÕ,ìúö@«ê¹5Ö¢JÜcöÎ­ßpiÎ£äOèüŸ/™3Y2"+ð¯8<ë·5* BÀÒè¡ÃYvÆ _ð²wÑ½Z}>…>ey!¥udånJ™";´ÍÎKb|GÖ ”¨»DaœÒAšžÃ>m(©/–x®•¬¾Èø–r—~ÌxÕ}Îºy
céá„üýáŽ¬¨Ó‰˜“»nbˆ:€M\?P²®Òh¡7m	ò=¾‹<;™ªo^B–ô˜‰5Ku&}8œæ6AË«Ö;[Í@¬¯ê\W×¹áþÔ×ï(35pûÍµ Žàßxªh 7óÁM<9Á±ö³<€Ü([„JÂ¦!<äÕQÚ·uK”ºýú–9§Ða8Ð&äÒÊý&¤Ý†D}^‘/189œ¬j2¬K«S#ªºÓžf°8ÚE`Þé	PÄ¤õX?ÀóÉOøL¯ªBï[òÊ½c¡»@•ÏF1Au(q}î]Q }%*ô™gÛWMs þCÏ5¾ùÉ”“¡J¾qMz“EüÂYe^sÑny),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);
}

?>