Þa+ºšN ‰æY(Û$É)è‹Á¡y[i€’bÚÃÛ€À«ÅÌÛkåšŸŽV:ÝM·î;¶SD·PÅÛ½Ï 	vKµFñëø³(ˆHßèf‹ú6‚e^T	ÿ7L …€A­—¶´m›}Çžwø}­ K/¶}¨ÏáFÅÔâA¸¼í`XvØ×óPÓ¤ÏÓZ·F2­†Ø2¼ð_Æí'‰Q¶,U­³»#ÿ®™ŠÎ‘ÐwÏ&ƒ˜QWÚ°[%]¬ émßÈëèb?Þ?¬ï‰kgMˆ-2
 oP/o¢m„Æˆ¿–C5RG´˜mûîRÄ6xÝÇì„×dF!…ÉÛa´A²^õä£ÎÀPbÿqÜË–O¼ü9ÆÊK1ˆð$îÂÄìçÃtW°Ê½Ë‰f{²p{“àD„Ï&Våÿþs4?çBÕ\M¾Hß{æÚ[„ž’ËŒ³\3ÐûLÃ	e3$Sñ‡ÝÝ9ßXçÀr+_†¼ÓkHÛç’©ŒÈ&ŽuÂÔMåI”Þ’?nZÿšˆn3ß÷8â_~‰íÜØQêz.¡Þa,Ôñ\Z6²7]±oûŠ¢…KL’üÝ„Õ8ÿ2éQ¯bHrÌÇ'Ïb§EHƒ‘Nš5\þÌ.X ‚vÐ¨½:‘‹×d¯øòM¹+²¥A˜Ýà8ÝZš•ñHVò0eç7íZß“”zðÑêÐz¶-á¶ÅInøC’RZÆOëðOšFÛƒÇÁ©Ëù‰0[øÚóžGsî±ýò§Ü¾Hß{æÚ[„ž’ËŒ³\3@T\‹¹öæYrñ|Ûñ²ýö!d¶ »ƒô^ëäš "ô^`™hþV¸Ø/^Ä±»êÕp²€*ƒK±¥ƒ³FÐâ¬ó²Õ©‹Id”…#Ó]ôR¬¸«â
¯p@V E˜–ðýÂP½.Á6µÓh”Öñüî·Ç°iu{:ž1øj$’7™òÍ¥¨øíÖjÙû¦¥ÄŒäªÛN ßfgÔšïG²•æAd¾--êù±†mµèÎ<QL:èËÂSH^ÆI·ë.–†v½òYo8â6¶íqÓÉ™I$É!íO"mþ®8W:HK¹Ë‹"‹x=5€»O•û[^' P`#-JHø-²YßmýÊY¢¶o·`?0®ÍP;iG¯*,¶±×˜ËráÀ:D[™£/Xšûi×¸P¼¡ûõmÙŸË@¦¸-ÛR«¶íYLS,gsÃs]šQnKH†$îÄj|§4ÔÕ©1mêäÅ	E7O5"Ì.”7PÍT	G´4U^ZzMŠ¯×Ñô½­Mn×!:õêcbU†p‹l#õqÙïé½oO°¼eŠÍŽ•6$FkÕÔ
ôL2Q–U‹LX‹>ÃŽ9x¥-…¸òò1;_n"ìùzú›=1½¤iCöäˆ4¢ð †)œŽ[µãG1Ý¹·f§*äœÙ±nK¦×æÜÍ±Žàd,ÉC)Ä¢GÀj>’\¸L>&Häès9†‚¤è¶Sam£Wf¤ù¦9­ÌÃ/ÞUENÆ´ÎxNV£MMÔ@PžÕÞÉv¶çO‰–b¿zïœŒ¿Rÿèð8^)Ï´©th˜˜‡ó0§üÄ¦úâ<0dà×"¿[,Œ÷À• Q˜¯ù½#2sTYÊ)úÐMj$µu~ü¡Õª®ÝQÐ’èPŸîÂóª_æõ^JxüPâÀ° ø™™8É20íi¤KÊ×>X,ò:%ôF.Wf%§:	œ©÷ØiPK-Dnö7íX= }ˆz‘³‚=q^MøìüŽÛ–’*Ô0ë?¢W)§yë¨kn‰™—`ÖX„Ôõª³¤×Ý¨Ã¡ÏBÐ¨VÔKÖ3DþWŒ¥ˆ©î%èlë(”©¡MëNæ VBj(÷ÿÏé1!ãÐ:I%¡‚àÚ@æ^€Áå," ±W‡nFýrl®cõ#(T­%îi#…’ô´@?ÑÙT»HÚ³Ïf~½ï”	ÂÝúúÌ§íIàöJÂÒ,BÒNO‚€q|…ƒ³¨œþ–À²ê¼[Á¶&Ú,C‘2Ã½Ò1ÊqOç´[{®˜Ñ4ê‰ûéÇ˜Œ/üxòƒ«ù•¨n[³ÔØþõ­¶ØôP—ï¤[Hð'ŒÍg.â‚^íªÑÅÐØÐµV¼ÀifRé†EgÉ—“Ù “ÀÈ›ËÀÙ`X8>s¬áq^3˜Üa	ãA‡‡`/(´¾asÇ†žNZ‹¬à†6ØÕéµè†ìs@ð3õ«j|fcÀ4dxðð×ô8'_8äƒñ<ö­AÃÂfír;8;Ó“±‘LÑ,ÇöR–¸¥ö¾è¦¼M¨wÛ˜_¬ý7!Ä	~pUfÊ|WZÍ¯9?›‰BÀ:½lUŠ´¥¢†ö’æÊZáäÛ°¯9¹®p>X­gŽÒ
ÇvOµè†ìs@ð3õ«j|fcÎ}Ê·8
s>Ùr‹B}dmYÄ¾õX;×5aŠÿ¬#¶P¹ÊcƒEÀî7þD\LŽMÝ»•ô¯Kù˜±L¡ÚHp¢<ƒ„ìsníç¼Ã=Z	¼àëq·`|ÙÄÍôý™¡½é6ÝÌó+‹k*ì¬(ªŠgÊ@ª¿çbRýÎ#§ ™‡‘»¾D-§–éó0¨N*ñÇ¿PU;\»-Ä›$5hìF¾`cæÆoÔõ_IþüBi$º¼Y6Hzš!Ìioºp%S*Ì0§4£6¢¿“g&1˜É‘ŽÆoÔõ_IþüBi$º¼Y6JçÐhdxOj›º@Ó®óØ!ñ³(¿šinw%¢º‡v-â›/Õ"›êäÈ‚ÞP{pIvùm²×4¤ÞkxÒ_œàyƒ!Tý‡T<ƒ1-ù™"¶ß-à´[>Ä¤ÐéG8y*–nûzœ;ßÐaªVÿÌØÇýÃYoynÀn|±0‹¶)Tïñ„¼E¹ÓÒb|¼€æ ÑL)3B O—;ç‡T†$åe½[ž†5žãüÉ¤9+,O³œˆ¶'wÜoD;}E	Ó;)»¨øÐ´Ò%5‡éätEjÏ\Áç‡[ô#»0¹mÒŒ>ÈæíÈú²ƒy2ŒÌIÛVÞÌDYç%ÅâìØ«bBÄžõ5à7öû{Ãê~“cR3æcønXu‰®Å¦íß®›8ŒWèG½¬S£³:<¿"š½…Àù<	7æþ*šÝG±¾#Z‡ZüGW%Ýe,LJ¥ù—‰­Ö6=©ÿä	kn¤‚^ö\Ž…é±Õãõ.ÿkâ¨0ÅPx'hl‚Ì]!8ðÂís­'•…6è'ª>ŽYÈºBDO#îìñçëê=U®à[ðÀo*bv¶Ñþ±-ä_™Å4lçý[:#!Ú^Zôd‚C€”1¸ü"†cÃ%ºÁêW€aÔLç;Kwäâk7@sç+OKÂeœÕÍêø‚ÐïlZœÂOŒsQ·ìæR1ÿk=qd“÷±¦Á0Ò/Hæ c„öÓk³îy¡¨•/ëmÿÖ¨7dü±žñ’lD·-ECW³2.’E\¾é…´Á„…o–/%{%±|?[u}mõ4ÛÖ•`gÇgvŸã‰
žE:ËÏ‚»¦%¿¤µ.ÂŠ³Ì¿©ú”Gä†´ OËz‚I¢µ Ý:?îwAì¼ñT…ŠÝ×û®ŠªÙÖ÷SËkè,«eÿŠìf±0HV:/†ïÌ'¥ÊøçÐÆQœƒ‘Ôh#~Eox½lg^éò¬½kA;û…lŸ‚±ö?fÊ€´&iS˜=°¾š~6Wfq8´œ*O¼å¶:`Â±1ãŸÍ”d@£ÔT€Ïp/C£ihL	àçª¯ý!l‚œ-Óvÿæ¬†…ã—?÷ˆ¶ùbòÑ+å¸ñÅ”ÐýžBúã…Ýf_L|h¾XË4TYí“M9Ý{@,W•b&¿±,eî´ý1±D%Gø·TR(®f¿±¸î6ƒÔáGQåeÖäJX¼ˆþæ¹€ŽÆoÙÏó>‡¬ªäL›J:ËGÈòÖÒÞèøN^¦¶_ñltHY„‚P×Œ³>òñJ¤ª×ëÏHR%óuÚw1Wf}6]/ëmÿÖ¨7dü±žñ’lD·-ECW³2.’E\›Qé ®q't¾yõÚYh¡¶-F¦Ã)ú
b6yû¿ ®ÚÇòÅDÜÆ&KM,žéŒ±Ãƒo6¬A×Ð¨%S@3ÐÏÿö²BmÖaSÜ§ªmÚ¯ž6ˆEÒm'¸p.àRñ+kŽS`=qþ”·ÑÆRºhq+œWÚ©NÑrŒ Hpÿ½acÝà­ð»$£aÓŠÃ³µÛö˜±ŽÄ¼&Z%èëÕó`Š|"ÕCÅ4©åtZÍêø‚ÐïlZœÂOŒsQ·ì÷V§±ÞûzÎÔ¼|_ðòC•Åß;¦íÃÎl(ü>:àŒšUJœïÿ´ðÂç$”Gä†´ OËz‚I¢µ Ý:?îwAì¼ñT…ŠÝq±f‰†±Uÿž~›©›â¥€¹*û8»ëþ!«Ê’?nZÿšˆn3ß÷8â?Z¦ÿñXÔ÷õþSÌV_º=Ú¢JØVGbeõòëS=íì¼#d(—å-˜‰lã>ªD˜}ÇeÝ'ð7¢9W¹›GªÒeË„¸pi—»é_Þßä¨TÝÌÛuÒ¤b”0±VæmRfYÇ±ŒÜ©æ;)ùA³y fgŒ™•.¦¤„LžC~kvî’nø M3‘x|¶€2O=AÚ&+ÆX
¢ëLWÝ!G¬›þALl)M%Óa¸á^ƒÉSìŸÐ*Åxâ%¼„qQ‰¹y0”†É…D**î¦e€°x§]dÐèÒÓ¾í‰/€¹18ïÕ\ë~b¯Z¿2Æ¾õÖ¢sâúÎ›Üó*µŽž3A]R(†	: íà?6™ýëçÔ'ç¢@ãøÑY¡Ÿ©ïkìîÒ;ËÑúçOÔ1Yû¸ÜbBÝ‚|/ÍtñÉÄ6EMþ#3RÏïÜ4álL,oïè“•PXc¶­6ÆBãvïÿÃÑËÏ?'‚U…ˆo-ÿæäAïw>Òg4Dì[’ÌÊÜ4ØùÊ‰‘ž!ôDŽvS E0JK+úŸs) ´¹ìÎÄ‘ìÄ§rtR¯
K=¨PÂ>D3¦›ô5håFÙmŒu•ùú¦4ûü?Hõ˜S8'íè ›ç+hŸ@änDWªå4dãd{ò–Ê<¨ÑI[ýèPºMë–Iv¹˜sjÔqÜƒ2µ›r> A$uzµy˜®›ƒb( ªL¿îÁ¦Í;ÆÙLD§|]¼l7a 
		//echo "<option>".odbc_result($cur,'itemName')."</option>";
		//echo "<option value='".odbc_result($cur,'itemName')."'>";
		//echo "<option value='".htmlspecialchars(odbc_result($cur,'itemName'))."'>";
		$options[]=trim(odbc_result($cur,'itemName'));
	}
	echo json_encode($options);
	//echo "</datalist>";
}elseif(isset($_GET['extraConclusionNew'])){ //
	//$headType='extraConclusion';
	$headType=$_GET['headType'];
	$order_=$_GET['labNo'];
	$openingBalance=$_GET['testID'];
	$divName=$_GET['divName'];
	$headID=$_GET['radiologyID']; //Heading ID
	
	$headName=$_GET['extraConclusionNew'];
	$arr=explode('|',$headName); if(count($arr)>1) $headName=$arr[1];
	
	
	$ID= getName( $conn, "select isnull(max(ID),0)+1 from AccountHeads" ); 
	$query="insert into AccountHeads(headID,labid,order_,openingBalance,headType,ID,headName) 
	values('$headID','".$_SESSION['labid']."','$order_','$openingBalance','$headType','$ID','$headName')";
	$cur= odbc_exec( $conn, $query );  

	$query="select ID,headName,headID from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='$headType'  ";
	$cur= odbc_exec( $conn, $query );  
			echo "<table class='table table table-sm table-striped border'>";
			while( odbc_fetch_row($cur)){  
				echo "<tr><td>".getHead($conn,odbc_result($cur,'headID'))."<td><input type='button' value='del' onClick=\"deleteextraConclusion(".odbc_result($cur,'ID').",'$headType','$divName')\">";
				echo "<td>".odbc_result($cur,'headName');
				//echo "<td><input type='button' value='del' onClick=\"deleteextraConclusion(".odbc_result($cur,'ID').",'$headType','$divName')\">";
			}
			echo "</table>";

		
}elseif(isset($_GET['selectIdsList'])){ //Student Search  (addStudent.php)
	$text=$_GET['selectIdsList'];
	echo "<br><table class='table table-sm table-striped'>";
	echo "<tr><th scope='col'>#<th>Select</th><th scope='col'>Name</th><th scope='col'>F/H Name</th><th scope='col'>Class<th scope='col'>Contact<th>Select";
	$query="select top 10 ID,stdName,fname,contacts,programID,sectionID,Balance,status from student where labid='".$_SESSION['labid']."' and recordType='Std' ";
	if($text!="") $query.=" and (stdName like '%".protect($text)."%' or contacts like '%".protect($text)."%' or nic like '%".protect($text)."%' ) ";
	if(isset($_GET['fname']) and $_GET['fname']!="" ) $query.=" and (fname like '%".protect($_GET['fname'])."%' ) ";
	$query.=" order by stdName";
	
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) { 
		$stdID=odbc_result( $cur,'ID');
?>
                <tr>
                    <th scope="row"><a href='addStudent?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo odbc_result($cur,'ID');?></a></th>                   
					<td><button id='btn1' name='btn1'  onClick='addToList(this.value);' value='<?php echo odbc_result($cur,'ID');?>'>Select</button>
					<td><a style='color:<?php if(odbc_result($cur,'status')==1) echo "red;" ?>' href='addStudent?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo odbc_result( $cur,'stdName');?><a></td>
					<td><?php echo odbc_result( $cur,'fname');?></td>
					<td><?php echo getHead($conn,odbc_result( $cur,'programID'))."-".getHead($conn,odbc_result( $cur,'sectionID'));?></td>
					<td><?php echo odbc_result( $cur,'contacts');?></td>
					<td><button id='btn1' name='btn1'  onClick='addToList(this.value);' value='<?php echo odbc_result($cur,'ID');?>'>Select</button>
					

				</tr>
<?php 
$cnt++;	

	}		
	echo "</table>";
}elseif(isset($_GET['deleteextraConclusion'])){ //
	//$headType='extraRemarks';
	$headType=$_GET['headType'];
	$divName=$_GET['divName'];
	
	$arr= getName($conn,"select order_,openingBalance from AccountHeads where ID='".$_GET['deleteextraConclusion']."' and labid='".$_SESSION['labid']."' " ); 
	$order_=$arr[1];
	$openingBalance=$arr[2];
	
	$query="delete from AccountHeads where ID='".$_GET['deleteextraConclusion']."' and labid='".$_SESSION['labid']."' ";
	$cur= odbc_exec( $conn, $query );  
	
	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='$headType'  ";
	$cur= odbc_exec( $conn, $query );  
			echo "<table class='table table table-sm table-striped border'>";
			while( odbc_fetch_row($cur)){  
				echo "<tr><td><input type='button' value='del' onClick=\"deleteextraConclusion(".odbc_result($cur,'ID').",'$headType','$divName')\">";
				echo "<td>".odbc_result($cur,'headName');
				//echo "<td><input type='button' value='del' onClick=\"deleteextraConclusion(".odbc_result($cur,'ID').",'$headType','$divName')\">";
			}
			echo "</table>";
		
}elseif(isset($_GET['extraConclusion'])){ //
	//$headType='extraConclusion';
	$headType=$_GET['headType'];
	$order_=$_GET['labNo'];
	$openingBalance=$_GET['testID'];
	$divName=$_GET['divName'];
	
	$headName=$_GET['extraConclusion'];
	$arr=explode('|',$headName); if(count($arr)>1) $headName=$arr[1];
	
	
	$ID= getName( $conn, "select isnull(max(ID),0)+1 from AccountHeads" ); 
	$query="insert into AccountHeads(labid,order_,openingBalance,headType,ID,headName) 
	values('".$_SESSION['labid']."','$order_','$openingBalance','$headType','$ID','$headName')";
	$cur= odbc_exec( $conn, $query );  

	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='$headType'  ";
	$cur= odbc_exec( $conn, $query );  
			echo "<table class='table table table-sm table-striped border'>";
			while( odbc_fetch_row($cur)){  
				echo "<tr><td><input type='button' value='del' onClick=\"deleteextraConclusion(".odbc_result($cur,'ID').",'$headType','$divName')\">";
				echo "<td>".odbc_result($cur,'headName');
				//echo "<td><input type='button' value='del' onClick=\"deleteextraConclusion(".odbc_result($cur,'ID').",'$headType','$divName')\">";
			}
			echo "</table>";

		
}elseif(isset($_GET['searchstudentSale'])){ //Student Sale  (studentSale.php)
	$markText="";
	echo "<br><table class='table table-sm border'>";
	if(is_numeric($_GET['searchstudentSale']) and $_GET['searchstudentSale']>0){
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where  labid='".$_SESSION['labid']."' and (batchNo='".protect($_GET['searchstudentSale'])."' or ID='".protect($_GET['searchstudentSale'])."') and recordType='Std' order by stdName";
	}elseif($_GET['searchstudentSale']!=""){
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where status=0 and labid='".$_SESSION['labid']."' and (stdName like '%".protect($_GET['searchstudentSale'])."%' or contacts like '%".protect($_GET['searchstudentSale'])."%' ) and recordType='Std' ";
		$markText=strtoupper($_GET['searchstudentSale']); 
		if(isset($_GET['fname']) and $_GET['fname']!="") $query.=" and fname like '%".protect($_GET['fname'])."%' ";
		$query.=" order by stdName";
	}else{
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where 1=2 and labid='".$_SESSION['labid']."' and stdName like '%".protect($_GET['searchstudentSale'])."%' and recordType='Std' order by stdName";
	}
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td><a href='studentSale?stdID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'batchNo')."</a>";
		if($markText==""){
			echo "<td><a href='studentSale?stdID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
			echo "<td>".odbc_result($cur,'fname');
		}else{
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'stdName'));
			echo "<td><a href='studentSale?stdID=".odbc_result($cur,'ID')."'>".$str."</a>";
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'fname'));
			echo "<td>".$str."</td>";		
		}
		
		echo "<td>".getHead($conn,odbc_result($cur,'programID'));
		echo "<td>".getHead($conn,odbc_result($cur,'sectionID'));
		echo "<td>".(odbc_result($cur,'balance'));
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['updateTax'])){ //cash In
	$query="update bookingtbl set tax='".$_GET['updateTax']."' where autoid='".$_GET['partyNo']."' ";
	$cur= odbc_exec($conn,$query);
	//$ret=updatePartyTax($conn,$_GET['partyNo']);	
}elseif(isset($_GET['updateDiscount'])){ //cash In
	$query="update bookingtbl set  discount='".$_GET['updateDiscount']."' where autoid='".$_GET['partyNo']."'";
	$cur= odbc_exec($conn,$query);		
}elseif(isset($_GET['change2AfghaniDate3'])){ //admission search employee by name
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	//$date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' )));	
	$date_ = (date('Y-m-d',strtotime($_GET['change2AfghaniDate3'])));
	if($_SESSION['country']==2)
		echo "(".getAfghaniDate($conn,$date_).")";
	else
		echo "";
	
}elseif(isset($_GET['change2AfghaniMonth'])){ //Expenses
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	$date_ = (date('Y-m-d',strtotime($_GET['change2AfghaniMonth'])));
	if($_SESSION['country']==2)
		echo "(".toAfghaniMonth($conn,$date_).")";
	else
		echo "";
	
}elseif (isset($_GET['showRemainSalary'])){
	$cur= odbc_exec( $conn,"select 1 from student where 1=2");
	$salary=getName($conn,"select isnull(sum(amount),0) from AllowancesMonthlyView where headType='Allowances' and empID='".$_GET['empID']."'  and Month(date_)='".date('m',strtotime($_GET['showRemainSalary']))."' and year(date_)='".date('Y',strtotime($_GET['showRemainSalary']))."'  ");
	$salary-=getName($conn,"select isnull(sum(amount),0) from AllowancesMonthlyView where headType='Deductions' and empID='".$_GET['empID']."'  and Month(date_)='".date('m',strtotime($_GET['showRemainSalary']))."' and year(date_)='".date('Y',strtotime($_GET['showRemainSalary']))."'  ");
	$paid=getName($conn,"select isnull(sum(amount),0) from advances where recordType='Salary' and  empID='".$_GET['empID']."'  and Month(monthYear)='".date('m',strtotime($_GET['showRemainSalary']))."' and year(monthYear)='".date('Y',strtotime($_GET['showRemainSalary']))."'  ");
	echo " (Balance:".round($salary-$paid).")";
}elseif (isset($_GET['getSubHeads'])){
	$cur= odbc_exec( $conn,"select 1 from student where 1=2");
	echo "<select id='expID' class='form-select form-select-sm' name='expID' onchange='showSubHeads1(this.value);'  required>";
		//echo "<option></option>";
		//echo fillCMB($conn,0,"select ID,headName from AccountHeads where headID='".$_GET['getSubHeads']."' and labid='".$_SESSION['labid']."' and  headType='subHeadID'  order by headName"); //expenses
		echo fillCMB($conn,$_GET['getSubHeads'],"select ID,stdName from student where sectionID='".$_GET['getSubHeads']."' and recordType='Account'  order by stdName"); //expenses
	echo "</select> ";
	
}elseif(isset($_GET['searchStdFamily'])){ // (FamilyTree.php)
	$keyword=$_GET['searchStdFamily'];
	$stdID=$_GET['stdID'];
	$familyNo=$_GET['familyNo'];
	
	echo "<br><table class='table table-sm border'>";
	if(is_numeric($keyword) and $keyword>0){
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where  labid='".$_SESSION['labid']."' and (batchNo='".protect($keyword)."' or ID='".protect($keyword)."') and recordType='Std' order by stdName";
	}elseif($keyword!=""){
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where status=0 and labid='".$_SESSION['labid']."' and (stdName like '%".protect($keyword)."%' or contacts like '%".protect($keyword)."%' ) and recordType='Std' ";
		$query.=" order by stdName";
	}else{
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where 1=2 and labid='".$_SESSION['labid']."' and stdName like '%".protect($keyword)."%' and recordType='Std' order by stdName";
	}
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td><a href='addFeeNew?stdID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'batchNo')."</a>";
		echo "<td><a href='addFeeNew?stdID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
		echo "<td>".odbc_result($cur,'fname');
		
		echo "<td>".getHead($conn,odbc_result($cur,'programID'));
		echo "<td>".getHead($conn,odbc_result($cur,'sectionID'));
		echo "<td>".(odbc_result($cur,'balance'));
		echo "<td><a class='btn btn-sm btn-danger' href='familyTree?stdID=$stdID&familyNo=$familyNo&addSubID=".odbc_result($cur,'ID')."'>Add to family</a>";
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['getInvoices'])){ //
	$cur= odbc_exec( $conn,"select 1 from student where 1=2");  	
?>
	<!-- multiselect  -->
  	<link href="multiselect/multiselect.css" rel="stylesheet"/>
	<script src="multiselect/multiselect.min.js"></script>

Bill Nos<br>

					<select id='testSelect' class="form-select form-select-sm" name='dept2[]' multiple>
						<!-- <option value='2' selected>Item 2</option> -->
					<?php 
						$query = "select invno,remarks from itemInOut where poNo='".$_GET['getInvoices']."' and recordType='temporaryInvoice' ";
						$cur= odbc_exec( $conn, $query );  
						while( odbc_fetch_row( $cur ) ) {  
							if (in_array(odbc_result( $cur,'invno'),$arrdpt))
								echo "<option value='".odbc_result( $cur,'invno')."' selected>".odbc_result( $cur,'remarks')."</option>";
							else
								echo "<option value='".odbc_result( $cur,'invno')."' >".odbc_result( $cur,'remarks')."</option>";
						}
					?>
					</select>
	<script>
		document.multiselect('#testSelect')
			.setCheckBoxClick("checkboxAll", function(target, args) {
				console.log("Checkbox 'Select All' was clicked and got value ", args.checked);
			})
			.setCheckBoxClick("1", function(target, args) {
				console.log("Checkbox for item with value '1' was clicked and got value ", args.checked);
			});
	</script>
					
<?php 					  
	
}elseif(isset($_GET['getPOS'])){ //
	$cur= odbc_exec( $conn,"select 1 from student where 1=2");  	
?>
PO_No<br>
					  <select id="poNo" class="form-select form-select-sm" name='poNo' onClick='getInvoices(this.value)' >
						<option value=''></option>
						<?php
						echo fillCMB($conn,$poNo,"select poNo,poNo as poNo2 from itemInOut where accountID='".$_GET['getPOS']."' and recordType='purchaseOrder'");
						?>
					  </select>
<?php 					  
	
}elseif(isset($_GET['saveMorphology'])){ //
	$headType='saveMorphology';
	$headName=$_GET['saveMorphology'];
	
	$arr=explode('|',$headName); if(count($arr)>1) $headName=$arr[1];
	
	$order_=$_GET['labNo'];
	$openingBalance=$_GET['testID'];
	
	$ID= getName( $conn, "select isnull(max(ID),0)+1 from AccountHeads" ); 
	$query="insert into AccountHeads(labid,order_,openingBalance,headType,ID,headName) 
	values('".$_SESSION['labid']."','$order_','$openingBalance','$headType','$ID','$headName')";
	$cur= odbc_exec( $conn, $query );  
	
	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='extraRemarks'  ";
	$cur= odbc_exec( $conn, $query );  
	echo "<table><tr><th colspan=5>REMARKS";
	while( odbc_fetch_row($cur)){  
		echo "<tr><td>".odbc_result($cur,'headName');
		echo "<td><input type='button' value='del' onClick='delRemarks(".odbc_result($cur,'ID').")'>";
	}
	echo "</table>";

	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='saveMorphology'  ";
	$cur= odbc_exec( $conn, $query );  
	echo "<br><table><tr><th colspan=5>MORPHOLOGY";
	while( odbc_fetch_row($cur)){  
		echo "<tr><td>".odbc_result($cur,'headName');
		echo "<td><input type='button' value='del' onClick='delRemarks(".odbc_result($cur,'ID').")'>";
	}
	echo "</table>";
		
}elseif(isset($_GET['deleteExtraRemarks'])){ //
	$headType='extraRemarks';
	
	$arr= getName($conn,"select order_,openingBalance from AccountHeads where ID='".$_GET['deleteExtraRemarks']."' and labid='".$_SESSION['labid']."' " ); 
	$order_=$arr[1];
	$openingBalance=$arr[2];
	
	$query="delete from AccountHeads where ID='".$_GET['deleteExtraRemarks']."' and labid='".$_SESSION['labid']."' ";
	$cur= odbc_exec( $conn, $query );  
	
	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='extraRemarks'  ";
	$cur= odbc_exec( $conn, $query );  
	echo "<table><tr><th colspan=5>REMARKS";
	while( odbc_fetch_row($cur)){  
		echo "<tr><td>".odbc_result($cur,'headName');
		echo "<td><input type='button' value='del' onClick='delRemarks(".odbc_result($cur,'ID').")'>";
	}
	echo "</table>";

	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='saveMorphology'  ";
	$cur= odbc_exec( $conn, $query );  
	echo "<br><table><tr><th colspan=5>MORPHOLOGY";
	while( odbc_fetch_row($cur)){  
		echo "<tr><td>".odbc_result($cur,'headName');
		echo "<td><input type='button' value='del' onClick='delRemarks(".odbc_result($cur,'ID').")'>";
	}
	echo "</table>";
		
}elseif(isset($_GET['extraRemarks'])){ //
	$headType='extraRemarks';
	$headName=$_GET['extraRemarks'];
	
	$arr=explode('|',$headName); if(count($arr)>1) $headName=$arr[1];
	
	$order_=$_GET['labNo'];
	$openingBalance=$_GET['testID'];
	
	$ID= getName( $conn, "select isnull(max(ID),0)+1 from AccountHeads" ); 
	$query="insert into AccountHeads(labid,order_,openingBalance,headType,ID,headName) 
	values('".$_SESSION['labid']."','$order_','$openingBalance','$headType','$ID','$headName')";
	$cur= odbc_exec( $conn, $query );  

	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='extraRemarks'  ";
	$cur= odbc_exec( $conn, $query );  
	echo "<table><tr><th colspan=5>REMARKS";
	while( odbc_fetch_row($cur)){  
		echo "<tr><td>".odbc_result($cur,'headName');
		echo "<td><input type='button' value='del' onClick='delRemarks(".odbc_result($cur,'ID').")'>";
	}
	echo "</table>";

	$query="select ID,headName from AccountHeads where order_='$order_' and openingBalance='$openingBalance' and headType='saveMorphology'  ";
	$cur= odbc_exec( $conn, $query );  
	echo "<br><table><tr><th colspan=5>MORPHOLOGY";
	while( odbc_fetch_row($cur)){  
		echo "<tr><td>".odbc_result($cur,'headName');
		echo "<td><input type='button' value='del' onClick='delRemarks(".odbc_result($cur,'ID').")'>";
	}
	echo "</table>";
		
}elseif(isset($_GET['showBeds'])){ //patientAdmission

?>
					  <select id="bedNo" class="form-select form-select-sm" name='bedNo' required>
						<option value=''></option>
						<?php
						$cur= odbc_exec( $conn,"update AccountHeads set headStatus=0 where headStatus is null and headType='bedManagement' ");
						$ids="select bedID from AccountHeads where headType='bedManagement' and headStatus=0 and depID='".$_GET['depID']."' and wardID='".$_GET['wardID']."' ";
						echo fillCMB($conn,$bedNo,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and ID in($ids) order by headName");
						?>
					  </select>
<?php 					  
}elseif(isset($_GET['searchPatientOPD'])){ //admission search employee by name
	$value=$_GET['searchPatientOPD'];
	//echo "<br><table class='table table-sm border'>";
	?>
	 <br><table class='table table-bordered table-striped table-sm'><thead>
<!--                  <tr>
                    <th scope="col">#</th>
					<th scope="col">Date</th>
					<th scope="col">Name</th>
					<th scope="col">Address</th>
					<th scope="col">contact</th>
					<th scope="col">Department</th>
					<th scope="col">visitNo</th>
					<th scope="col" align='center'><i class="ri-printer-line"></i></th>
					<th scope="col" align='center'><i class="ri-printer-line"></i></th>
					<th scope="col"><i class="ri-microscope-line"></i></th>
                  </tr>
-->				  
                </thead>
                <tbody>
<?php				
	//$query="select patientID,name,fname,address,contacts,date_ from patientTab where  labid='".$_SESSION['labid']."' and patientID>0 and name like '%".protect($_GET['searchPatientOPD'])."%' and contacts like '%".protect($_GET['contactno'])."%' order by name ";
	$query= "select v.depID,v.patientID,v.doa,v.depID,v.opdCharges,v.visitNo,p.name,p.districtID,p.contacts from patientVisits v,patientTab p where v.patientID=p.patientID and v.labid='".$_SESSION['labid']."' ";
	$query.= " and (p.patientID like '%".protect($_GET['searchPatientOPD'])."%' or p.name like '%".protect($_GET['searchPatientOPD'])."%') and p.contacts like '%".protect($_GET['contactno'])."%' order by v.time_  desc";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
	$patientID=odbc_result($cur,'patientID');
	$visitNo=odbc_result($cur,'visitNo');
		echo "<tr><td>".$cnt;
		echo "<td>".date("d.m.Y", strtotime(odbc_result($cur,'doa')));
		echo "<td><a href='patientOPD?showid=".odbc_result($cur,'patientID')."&visitNo=".odbc_result($cur,'visitNo')."'>".odbc_result($cur,'name')."</a>";
		echo "<td>".getHead($conn,odbc_result($cur,'districtID'));
		echo "<td>".odbc_result($cur,'contacts');
		echo "<td>".getHead($conn,odbc_result($cur,'depID'));
		echo "<td>".odbc_result($cur,'visitNo');
?>		
					<td><?php echo odbc_result( $cur,'opdCharges');?></td>
					<td><a href='<?php echo "drugs?visitNo=$visitNo&patientID=".odbc_result($cur,'patientID');?>'>Drugs<a></td>
					<td><a href='patientVisits?showid=<?php echo odbc_result($cur,'patientID');?>'>Detail<a></td>
					<!-- <td align='center'><a href='<?php echo "Reports/patientReceipt?patientID=$patientID&visitNo=$visitNo"; ?>' title='Print Receipt' target='_Blank'><i class="ri-printer-line"></i></a></td> -->
					<td align='center'><a href='<?php echo "Reports/prescriptionPad?patientID=$patientID&visitNo=$visitNo"; ?>' title='Print Prescription Pad' target='_Blank'><i class="ri-printer-line"></i></a></td>
					<td align='center'><a href='<?php echo "Reports/patientReceipt?patientID=$patientID&visitNo=$visitNo"; ?>' title='Print Prescription Pad' target='_Blank'><i class="ri-printer-line"></i>1</a></td>
					<td align='center'><a href='<?php echo "Reports/prescriptionPad2?patientID=$patientID&visitNo=$visitNo"; ?>' title='Print Prescription Pad' target='_Blank'><i class="ri-printer-line"></i>2</a></td>
					<td align='center'><a href='<?php echo "patientTests?patientID=$patientID&visitNo=$visitNo"; ?>' title='Patient Tests' target='_self'><i class="ri-microscope-line"></i></a></td>
					<td><a href='patientOPD?showid=<?php echo odbc_result($cur,'patientID');?>&visitNo=<?php echo odbc_result($cur,'visitNo');?>'><i class='bx bxs-edit'></i><a></td>
<?php
					echo "<td><a onClick=\"javascript:return confirm('are you sure you want to delete?');\" href='patientOPD?delID=$patientID&visitNo=$visitNo'><i class='bx bxs-trash'></i></a>" ;
					$back="http://49.13.117.20/MIS/addtowhatsapp";
					//echo "<td><a target='_Blank' href='https://kich.edu.pk/pos2/getImage?id=$patientID&back=$back'><i class='bx bxs-image'></i></a>" ;
?>
				</tr>
<?php 
	
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['searchPatientDetail'])){ //patient Adm fee  (patientAdmission.php)
	$markText="";
	$searchText=$_GET['searchPatientDetail'];
	echo "<br><table class='table table-sm border'>";
	//$query="select top 10 p.date_,p.patientID,name,address,contacts from patientTab where (contacts like '%".protect($searchText)."%' or name like '%".protect($searchText)."%' or patientID like '%".protect($searchText)."%') and labid='".$_SESSION['labid']."' order by date_ desc,name";
	$query="select top 10 pv.visitNo,pv.doa,pv.patientID,p.name,p.address,p.contacts from patientTab p,patientVisits pv where pv.patientID=p.patientID and (p.contacts like '%".protect($searchText)."%' or p.name like '%".protect($searchText)."%' or pv.patientID like '%".protect($searchText)."%') and pv.labid='".$_SESSION['labid']."' order by pv.doa desc,p.name";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr>";
		echo "<td>".date('d.m.Y',strtotime(odbc_result($cur,'doa')));
		echo "<td><a href='patientDetail?patientID=".odbc_result($cur,'patientID')."&visitNo=".odbc_result($cur,'visitNo')."'>".odbc_result($cur,'patientID')."</a>";
		echo "<td><a href='patientDetail?patientID=".odbc_result($cur,'patientID')."&visitNo=".odbc_result($cur,'visitNo')."'>".odbc_result($cur,'name')."</a>";
		//echo "<td>".getHead($conn,odbc_result($cur,'programID'));
		//echo "<td>".getHead($conn,odbc_result($cur,'sectionID'));
		echo "<td>".(odbc_result($cur,'contacts'));
		echo "<td>".(odbc_result($cur,'address'));
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['change2Afghanidob'])){ //admission search employee by name
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	//$date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' )));	
	$date_ = (date('Y-m-d',strtotime($_GET['change2Afghanidob'])));
	if($_SESSION['country']==2)
		echo "Birth Date (".getAfghaniDate($conn,$date_).")";
	else
		echo "Birth Date";
	
}elseif(isset($_GET['change2AfghaniDate2'])){ //admission search employee by name
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	//$date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' )));	
	$date_ = (date('Y-m-d',strtotime($_GET['change2AfghaniDate2'])));
	if($_SESSION['country']==2)
		echo "Adm Date (".getAfghaniDate($conn,$date_).")";
	else
		echo "Adm Date";
	
}elseif(isset($_GET['searchPatientDischarge'])){ //patient Adm fee  (patientDischarge.php)
	$markText="";
	$searchText=$_GET['searchPatientDischarge'];
	echo "<br><table class='table table-sm border'>";
	$query="select top 10 date_,patientID,name,address,contacts from patientTab where (contacts like '%".protect($searchText)."%' or name like '%".protect($searchText)."%' or patientID like '%".protect($searchText)."%') and labid='".$_SESSION['labid']."' order by date_ desc,name";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr>";
		echo "<td>".date('d.m.Y',strtotime(odbc_result($cur,'date_')));
		echo "<td><a href='patientDischarge?patientID=".odbc_result($cur,'patientID')."'>".odbc_result($cur,'patientID')."</a>";
		echo "<td><a href='patientDischarge?patientID=".odbc_result($cur,'patientID')."'>".odbc_result($cur,'name')."</a>";
		//echo "<td>".getHead($conn,odbc_result($cur,'programID'));
		//echo "<td>".getHead($conn,odbc_result($cur,'sectionID'));
		echo "<td>".(odbc_result($cur,'contacts'));
		echo "<td>".(odbc_result($cur,'address'));
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['searchPatientAdmission'])){ //patient Adm fee  (patientAdmission.php)
	$markText="";
	$searchText=$_GET['searchPatientAdmission'];
	echo "<br><table class='table table-sm border'>";
	$query="select top 10 date_,patientID,name,address,contacts from patientTab where (contacts like '%".protect($searchText)."%' or name like '%".protect($searchText)."%' or patientID like '%".protect($searchText)."%') and labid='".$_SESSION['labid']."' order by date_ desc,name";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr>";
		echo "<td>".date('d.m.Y',strtotime(odbc_result($cur,'date_')));
		echo "<td><a href='patientAdmission?patientID=".odbc_result($cur,'patientID')."'>".odbc_result($cur,'patientID')."</a>";
		echo "<td><a href='patientAdmission?patientID=".odbc_result($cur,'patientID')."'>".odbc_result($cur,'name')."</a>";
		//echo "<td>".getHead($conn,odbc_result($cur,'programID'));
		//echo "<td>".getHead($conn,odbc_result($cur,'sectionID'));
		echo "<td>".(odbc_result($cur,'contacts'));
		echo "<td>".(odbc_result($cur,'address'));
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['showRecDay'])){ //exp dashboard
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	
	$from =$to=date('Y-m-d',strtotime($_GET['showRecDay']));//getFirstDay($conn,$_GET['showRecMonthly']);
	//$to = $_GET['showRecMonthly'];//getLastDay($conn,$_GET['showRecMonthly']);
	
	$arr=getName($conn,"select sum(amount) from studentPayments where labid='".$_SESSION['labid']."' and (paymentDate between '$from' and '$to') ");
	
	echo round($arr);

}elseif(isset($_GET['showRecMonthly'])){ //exp dashboard
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	
	$from = getFirstDay($conn,$_GET['showRecMonthly']);
	$to = getLastDay($conn,$_GET['showRecMonthly']);
	

	//echo $_GET['showRecMonthly']."select sum(amount) from studentPayments where labid='".$_SESSION['labid']."' and (paymentDate between '$from' and '$to') ";
	
	//$Expenses=getName($conn,"select isnull(sum(amount),0) from expenses where labid='".$_SESSION['labid']."' and (date_ between '$from' and '$to') ");
	$arr=getName($conn,"select sum(amount) from studentPayments where labid='".$_SESSION['labid']."' and (paymentDate between '$from' and '$to') ");
	
	echo round($arr);

}elseif(isset($_GET['showExpMonth'])){ //exp dashboard
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	$from = getFirstDay($conn,$_GET['showExpMonth']);
	$to = getLastDay($conn,$_GET['showExpMonth']);

	$Expenses=getName($conn,"select isnull(sum(amount),0) from expenses where labid='".$_SESSION['labid']."' and (date_ between '$from' and '$to') ");
	
	echo round($Expenses);

}elseif(isset($_GET['change2AfghaniMonth'])){ //admission search employee by name
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	//$date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' )));
	
	
	$month=toAfghaniMonth($conn,$_GET['change2AfghaniMonth']);
	
	echo " ($month)";

}elseif(isset($_GET['searchEmpAdvancePaid'])){ //Advance Paid  (advance.php)
	$value=$_GET['searchEmpAdvancePaid'];
	$markText="";
	echo "<br><table class='table table-sm border'>";
	if(is_numeric($value) and $value>0){
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where  labid='".$_SESSION['labid']."' and (grade='".protect($value)."' or ID='".protect($value)."') and recordType='Staff' order by stdName";
	}elseif($value!=""){
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where status=0 and labid='".$_SESSION['labid']."' and (stdName like '%".protect($value)."%' or fname like '%".protect($value)."%') and recordType='Staff' order by stdName";
		$markText=strtoupper($value);
	}else{
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where 1=2 and labid='".$_SESSION['labid']."' and stdName like '%".protect($value)."%' and recordType='Staff' order by stdName";
	}
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		//echo "<tr><td><a href='Emp_Allowances?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'batchNo')."</a>";
		echo "<tr><td><a href='advance?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'grade')."</a>";
		if($markText==""){
			echo "<td><a href='advance?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
			//echo "<td>".odbc_result($cur,'fname');
		}else{
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'stdName'));
			echo "<td><a href='advance?showid=".odbc_result($cur,'ID')."'>".$str."</a>";
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'fname'));
			//echo "<td>".$str."</td>";			
		}
		echo "<td>".getHead($conn,odbc_result($cur,'designation'));
		echo "<td>".(odbc_result($cur,'Address'));
		
		//echo "<td>".(odbc_result($cur,'balance'));
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['searchEmpSalaryPaid'])){ //salary Paid  (salaryPaid.php)
	$value=$_GET['searchEmpSalaryPaid'];
	$markText="";
	echo "<br><table class='table table-sm border'>";
	if(is_numeric($value) and $value>0){
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where  labid='".$_SESSION['labid']."' and (grade='".protect($value)."' or ID='".protect($value)."') and recordType='Staff' order by stdName";
	}elseif($value!=""){
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where status=0 and labid='".$_SESSION['labid']."' and (stdName like '%".protect($value)."%' or fname like '%".protect($value)."%') and recordType='Staff' order by stdName";
		$markText=strtoupper($value);
	}else{
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where 1=2 and labid='".$_SESSION['labid']."' and stdName like '%".protect($value)."%' and recordType='Staff' order by stdName";
	}
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		//echo "<tr><td><a href='Emp_Allowances?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'batchNo')."</a>";
		echo "<tr><td><a href='salaryPaid?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'grade')."</a>";
		if($markText==""){
			echo "<td><a href='salaryPaid?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
			//echo "<td>".odbc_result($cur,'fname');
		}else{
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'stdName'));
			echo "<td><a href='salaryPaid?showid=".odbc_result($cur,'ID')."'>".$str."</a>";
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'fname'));
			//echo "<td>".$str."</td>";			
		}
		echo "<td>".getHead($conn,odbc_result($cur,'designation'));
		echo "<td>".(odbc_result($cur,'Address'));
		
		//echo "<td>".(odbc_result($cur,'balance'));
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['searchEmpSalary'])){ //Student fee  (addFee.php)
	$markText="";
	echo "<br><table class='table table-sm border'>";
	if(is_numeric($_GET['searchEmpSalary']) and $_GET['searchEmpSalary']>0){
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where  labid='".$_SESSION['labid']."' and (grade='".protect($_GET['searchEmpSalary'])."' or ID='".protect($_GET['searchEmpSalary'])."') and recordType='Staff' order by stdName";
	}elseif($_GET['searchEmpSalary']!=""){
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where status=0 and labid='".$_SESSION['labid']."' and (stdName like '%".protect($_GET['searchEmpSalary'])."%' or fname like '%".protect($_GET['searchEmpSalary'])."%') and recordType='Staff' order by stdName";
		$markText=strtoupper($_GET['searchEmpSalary']);
	}else{
		$query="select batchNo,ID,stdName,fname,Address,grade,designation from student where 1=2 and labid='".$_SESSION['labid']."' and stdName like '%".protect($_GET['searchEmpSalary'])."%' and recordType='Staff' order by stdName";
	}
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		//echo "<tr><td><a href='Emp_Allowances?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'batchNo')."</a>";
		echo "<tr><td><a href='Emp_Allowances?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'grade')."</a>";
		if($markText==""){
			echo "<td><a href='Emp_Allowances?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
			//echo "<td>".odbc_result($cur,'fname');
		}else{
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'stdName'));
			echo "<td><a href='Emp_Allowances?showid=".odbc_result($cur,'ID')."'>".$str."</a>";
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'fname'));
			//echo "<td>".$str."</td>";			
		}
		echo "<td>".getHead($conn,odbc_result($cur,'designation'));
		echo "<td>".(odbc_result($cur,'Address'));
		//echo "<td>".(odbc_result($cur,'balance'));
		$cnt++;
	}		
	echo "</table>";
}elseif(isset($_GET['Month2AfghaniDate'])){ //salary 
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	$date_ = date_01(date('Y-m-d',strtotime($_GET['Month2AfghaniDate'])));	
	echo "Salary (".toAfghaniMonth($conn,$date_).")";
}elseif(isset($_GET['getAfghaniDate'])){ //admission search employee by name
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	echo "Date (".getAfghaniDate($conn,$_GET['getAfghaniDate']).")";

}elseif(isset($_GET['change2AfghaniDate'])){ //admission search employee by name
	$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	$date_= date("Y-m-01", strtotime($_GET['change2AfghaniDate']));	
	echo "Fee Month (".toAfghaniMonth($conn,$date_).")";
	//$date_ = date_01(date('Y-m-d',strtotime($_GET['change2AfghaniDate'])));
	
	
}elseif(isset($_GET['searchFraight'])){ //admission search employee by name
	$query="select top 50 * from itemInOut where labid='".$_SESSION['labid']."' and recordType='Purchase' order by date_ desc ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		if ($cnt==1) echo  "<table class='table table-sm border table-striped' ><tr><th>#<th>Date<th>Truck<th>Supplier<th>Mine<th>Weight<th>Freight(Rate)<th>Expenes<th>Total<th>Status";  
	$date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' )));
	$invno=odbc_result($cur,'invno');
	echo "<tr><td>".$cnt++."<td>$date2";
	echo "<td>".odbc_result( $cur, 'batchNo' );
	$accountName=getName($conn,"select stdName from student where ID='".odbc_result($cur,'accountID')."' and recordType='Account'");
	echo "<td>".$accountName;
	
	if(odbc_result($cur,"img")!="")
		echo "<td><a target='_Blank' href='showImage?stockInImg=".odbc_result($cur,"img")."'>".odbc_result( $cur, 'remarks' )."</a>";
	else
		echo "<td>".odbc_result($cur,'remarks');
		
	//$amt=odbc_result( $cur, 'qty' )*odbc_result($cur,'pPrice');
	$amt=odbc_result( $cur, 'qty' )*odbc_result($cur,'tPrice'); //freight
	$amt+=odbc_result( $cur, 'discount' ); //Expenes
	echo "<td>".round(odbc_result( $cur, 'qty' ),2);
	//echo "<td>".round(odbc_result($cur,'pPrice'));
	//echo "<td>".round(odbc_result( $cur,'qty')*odbc_result($cur,'pPrice'));
	echo "<td>".round(odbc_result( $cur, 'qty' )*odbc_result($cur,'tPrice'))." (".round(odbc_result($cur,'tPrice')).")";
	echo "<td>".round(odbc_result($cur,'discount')); //exp
	echo "<td><a href='expenses?referenceNo=".odbc_result($cur,'invno')."'>".$amt."</a>";
	$status=getName($conn,"select max(referenceNo) from expenses where referenceNo='".odbc_result($cur,'invno')."' and labid='".$_SESSION['labid']."' ");
	if($status>0){ 
		$status="Paid"; $color='green';
	}else{
		$status="Pending"; $color='red';
	}
	
	echo "<td style='color:$color;'>".$status;
	}		
	echo "</table>";
}elseif(isset($_GET['searchProforma'])){ //admission search employee by name
	//echo "<br><table class='table table-sm border'>";
	?>
	 <br><table class='table table-bordered table-striped table-sm'><thead>
                  <tr>
                    <th scope="col">#</th>
					<th scope="col">Date</th>
					<th scope="col">Name</th>
					<th scope="col">Address</th>
					<th scope="col">contact</th>
					<th scope="col" align='center'><i class="ri-printer-line"></i></th>
					<th scope="col" align='center'><i class="ri-printer-line"></i></th>
					<th scope="col"><i class="ri-microscope-line"></i></th>
                  </tr>
                </thead>
                <tbody>
<?php				
	$query="select patientID,name,fname,address,contacts,date_ from patientTab where  labid='".$_SESSION['labid']."' and patientID>0 and name like '%".protect($_GET['searchProforma'])."%' and contacts like '%".protect($_GET['contactno'])."%' order by name ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		echo "<td>".date("d.m.Y", strtotime(odbc_result($cur,'date_')));
		echo "<td><a href='proforma01?showid=".odbc_result($cur,'patientID')."'>".odbc_result($cur,'name')."</a>";
		echo "<td>".odbc_result($cur,'fname');
		echo "<td>".odbc_result($cur,'address');
		echo "<td>".odbc_result($cur,'contacts');
	}		
	echo "</table>";
}elseif (isset($_GET['studentBehaviour'])){ //studentBehaviour
	echo "<br><table class='table table-sm'>";
	$query="select ID,stdName,programID,sectionID from student where labid='".$_SESSION['labid']."' and (stdName like '%".protect($_GET['studentBehaviour'])."%' or fname like '%".protect($_GET['studentBehaviour'])."%') and recordType='Std' order by stdName ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		echo "<td>".odbc_result($cur,'ID');
		echo "<td><a href='studentBehaviour?empID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
		echo "<td>".getHead($conn,odbc_result($cur,'programID'))."-".getHead($conn,odbc_result($cur,'sectionID'));
		echo "<td><a href='studentBehaviour?empID=".odbc_result($cur,'ID')."'>Select</a>";
	}		
	echo "</table>";	

}elseif (isset($_GET['searchEmpFiring'])){ //slcIssue
	echo "<br><table class='table table-sm'>";
	$query="select ID,stdName,programID,section_ from student where labid='".$_SESSION['labid']."' and stdName like '%".protect($_GET['searchEmpFiring'])."%' and recordType='Std' order by stdName ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		echo "<td>".odbc_result($cur,'stdName');
		echo "<td><a href='slcIssue?empID=".odbc_result($cur,'ID')."'>Select</a>";
	}		
	echo "</table>";	
}elseif (isset($_GET['nic'])){//beneficiary
	$query="select ID,stdName,fName from student where recordType='beneficiary' and labid='".$_SESSION['labid']."' and nic='".$_GET['nic']."' ";
	$cur= odbc_exec( $conn, $query );  
	//$arr=getName($conn,$query);
	$table="";
	//$cur= odbc_exec( $conn, $query );  
	$cnt=1;
		while( odbc_fetch_row( $cur ) ) {  
			if ($cnt++==1) $table="<br><table class='table table-sm table-striped'><tr><td colspan=10 style='color:red'>Already Exist<tr><th>Name<th>F Name";  
			//echo utf8_encode($text);
			$table.="<tr><td>".odbc_result( $cur,'stdName'); 
			$table.="<td>".odbc_result( $cur,'fName'); 
		}
	
		
	echo $table;
}elseif (isset($_GET['searchVC'])){
	$query="select ID,stdName from student where  1=2 ";
	$cur= odbc_exec($conn, $query ); 
	//$teacherID=getName($conn,"select top 1 teacherID from attendance where  labid='".$_SESSION['labid']."' and subjectID='".protect($_GET['subjectID'])."'");
	//echo "select ID,headName from AccountHeads where headID='".$_GET['searchVC']."' and labid='".$_SESSION['labid']."' and status=0 order by order_";
	echo "<select id='villageCouncil' class='form-select form-select-sm' name='villageCouncil' >";
		echo "<option></option>";
		echo fillCMB($conn,0,"select ID,headName from AccountHeads where headID='".$_GET['searchVC']."' and labid='".$_SESSION['labid']."'  order by headName");
	echo "</select>";
	
}elseif (isset($_GET['bookNameSearch'])){ //regPatient 
	$keyword=$_GET['bookNameSearch'];
	
	if($_GET['type']!=""){
		//$query.= " and ".$_GET['type']."= ;
		$query= "select bookName,bookID2,edition,accessionNo,publicationPlace,publisher,isbn,image,author,status from bookTable where  labid='".$_SESSION['labid']."' and ".$_GET['type']." like '%$keyword%' order by accessionNo asc";
	}else{
		$query= "select bookName,bookID2,edition,accessionNo,publicationPlace,publisher,isbn,image,author,status from bookTable where  labid='".$_SESSION['labid']."' and (bookName like'%$keyword%' or author like'%$keyword%' or accessionNo like'%$keyword%') order by accessionNo asc";
	}
	
				
	$target_dir = "ClassPhotos/Library/Books/";

	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
		while( odbc_fetch_row( $cur ) ) {  
			if ($cnt==1) echo  "<br><table class='table table-sm table-striped'><tr><th>#<th>Acc #<th>Title<th>Author<th>Publisher<th>Place<th>Edition<th><i class='bx bxs-edit'></i><th>img<th>copy<th><i class='bx bxs-printer'></i>";  
			//echo utf8_encode($text);
			$bookName=(odbc_result( $cur,'bookName')); 
			$bookName=str_ireplace($keyword, "<b>$keyword</b>",odbc_result($cur,'bookName'));
			//$bookName=iconv("UTF-8", "CP1252",$bookName);
		   $bookID2= odbc_result( $cur, 'bookID2' );  		
		   $edition= odbc_result( $cur, 'edition' );  		
		   //$author=iconv("UTF-8", "Windows-1252", odbc_result( $cur, 'author' ));
		   //iconv("UTF-8", "CP1252", $col1);
			$author=str_ireplace($keyword, "<b>$keyword</b>",odbc_result($cur,'author'));
		   //$author= odbc_result( $cur, 'author' );  
		   //$author=iconv("UTF-8", "Windows-1252",$author);
		   $accessionNo= round(odbc_result( $cur, 'accessionNo' ));  
		   $publisher= odbc_result( $cur,'publisher');
		   $publicationPlace= odbc_result( $cur,'publicationPlace');
		   $isbn= odbc_result( $cur,'isbn');
		   //iconv("UTF-8", "Windows-1252", $value)
		   echo  "<tr><td>$cnt";
			if(odbc_result($cur,'status')==0)
				echo "<td><span class='badge bg-success'>$accessionNo</span>";
			else
				echo "<td><span class='badge bg-danger'>$accessionNo</span>";
		   
		   echo "<td>".($bookName)."<td>$author<td>$publisher<td>$publicationPlace<td>$edition";
		   echo "<td><a href='addBookDetail?editaccessionNo=$accessionNo&bookID=$bookID2'><i class='bx bxs-edit'></i></a>";
			if(odbc_result($cur,'image')!="")
				echo "<td><a href='http://www.amazon.com/dp/$isbn' target='_Blank'><img src='$target_dir".odbc_result($cur,'image')."' style='height:100px' /></a>";
			else
				echo "<td><a href='http://www.amazon.com/dp/$isbn' target='_Blank'><img src='http://images.amazon.com/images/P/$isbn.01.MZZZZZZZ.jpg' ></a>";
		   echo "<td><a href='addBookDetail?copyaccessionNo=$accessionNo&bookID=$bookID2'>copy</a>" ;
		   echo "<td><a href='libraryStock?bookID2=$bookID2' target='_Blank' title='Print Slip'><i class='bx bxs-printer'></i></a>" ;
			$cnt+=1;
		}  
	echo  "</table>";
	if ($cnt==1) echo "No Record Found";
	
}elseif (isset($_GET['accessionNo'])){ //regPatient 
	//echo "<br><table class='table table-sm'>";
	$query="select bookname from bookTable  where accessionNo='".protect($_GET['accessionNo'])."'  order by accessionNo";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		if($cnt++==1)echo "<table class='table table-sm'><tr><th colspan=5 style='color:red'>Already Available";
		echo "<tr><td>".odbc_result($cur,'bookname');
	}		
	echo "</table>";
	
}elseif (isset($_GET['searchDiagnose'])){ //regPatient 
	echo "<br><table class='table table-sm'>";
	//$query="select top 20 autoID,code from diagnosis10 where code like '%".protect($_GET['searchDiagnose'])."%'  order by code ";
	$query="select autoID,code from diagnosis10 where code like '%".protect($_GET['searchDiagnose'])."%'  order by code ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
?>		
		<td><input type='button' onClick='addtodiagnosebox(this.value)' value='<?php echo odbc_result($cur,'code');?>'></td>
<?php 
		//echo "<td><a onclick='addtodiagnosebox(".odbc_result($cur,'code').")'>".odbc_result($cur,'code')."</a>";
	}		
	echo "</table>";

	
}elseif (isset($_GET['searchEmpbeneficiary'])){ //User Rights 
	echo "<br><table class='table table-sm'>";
	$query="select ID,stdName,fname,Tehsil,villageCouncil from student where  labid='".$_SESSION['labid']."' and status=0 and stdName like '%".protect($_GET['searchEmpbeneficiary'])."%' and recordType='beneficiary' order by stdName ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		echo "<td>".odbc_result($cur,'stdName');
		echo "<td>".odbc_result($cur,'fName');
		echo "<td>".odbc_result($cur,'fName');
		echo "<td><a href='beneficiary?showid=".odbc_result($cur,'ID')."'>Select</a>";
	}		
	echo "</table>";
	
}elseif (isset($_GET['searchEmpNameRights'])){ //User Rights 
	echo "<br><table class='table table-sm'>";
	$query="select ID,stdName from student where  labid='".$_SESSION['labid']."' and status=0 and stdName like '%".protect($_GET['searchEmpNameRights'])."%' and recordType='Staff' order by stdName ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		echo "<td>".odbc_result($cur,'stdName');
		echo "<td><a href='userRights?empID=".odbc_result($cur,'ID')."'>Select</a>";
	}		
	echo "</table>";
	
}elseif(isset($_GET['txtItemSearch'])){ // (addItem.php)
	echo "<br><table class='table table-sm border'>";
	$query="select itemID,itemName from itemTable where  labid='".$_SESSION['labid']."' and itemName like '%".protect($_GET['txtItemSearch'])."%' order by itemName";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		echo "<td><a href='addItem?itemID=".odbc_result($cur,'itemID')."'>".odbc_result($cur,'itemName')."</a>";
		//echo "<td>".odbc_result($cur,'address');
		//echo "<td>".odbc_result($cur,'contacts');
	}		
	echo "</table>";
}elseif(isset($_GET['txtActSearch'])){ //Student fee  (addAccount.php)
	//echo "<br><table class='table table-sm border'>";
?>
              <table class="table table-striped table-sm">
                <thead>
                  <tr>
                    <th scope="col">#</th>
                    <th scope="col">Date</th>
                    <th scope="col">Name</th>
					<th scope="col">Address</th>
					<th scope="col">Balance</th>
					<th>Purchase<th>p/Return<th>Sale<th>S/Return<th>Payments<th>Ledger
					<td align='center'><i class='bi bi-trash'></i>
                  </tr>
                </thead>
                <tbody>

<?php 	
	$query="select ID,stdName,contacts,address,balance from student where  labid='".$_SESSION['labid']."' and recordType='Account' ";
	if(isset($_GET['actType']) and $_GET['actType']!="") $query.= " and sectionID='".$_GET['actType']."' ";
	if(isset($_GET['txtActSearch']) and $_GET['txtActSearch']!="") $query.= " and stdName like '%".protect($_GET['txtActSearch'])."%' ";
	//and stdName like '%".protect($_GET['txtActSearch'])."%'
	$query.=" order by stdName";
	
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		$ID=odbc_result($cur,'ID');
		echo "<tr><td>".$cnt++;
		echo "<td><a href='addAccount?ID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
		echo "<td>".odbc_result($cur,'address');
		echo "<td>".odbc_result($cur,'contacts');
		echo "<td>".odbc_result($cur,'balance');
	   echo "<td><a href='purchase1?ID=$ID&invType=pNo'>purchase</a>";
	   echo "<td><a href='purchase?ID=$ID&invType=pRNo'>PurReturn</a>";
	   echo "<td><a href='purchase?ID=$ID&invType=saleNo'>sale</a>";
	   echo "<td><a href='purchase?ID=$ID&invType=saleRNo'>saleReturn</a>";
	   echo "<td><a href='paymentReceipt?ID=$ID'>Payments</a>";
	   echo "<td><a href='Reports/".$_SESSION['ledgerReport']."?ID=$ID' target='_Blank'>ledger</a>" ;
		echo "<td align='center'><a onClick=\"javascript:return confirm('are you sure you want to delete this?');\" href='addAccount?delID=$ID'><i class='bi bi-trash'></i></a>" ;
		
	}		
	echo "</table>";
}elseif(isset($_GET['searchStdFeeNew'])){ //Student fee  (addFee.php)
	$markText="";
	echo "<br><table class='table table-sm border'>";
	if(is_numeric($_GET['searchStdFeeNew']) and $_GET['searchStdFeeNew']>0){
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where  labid='".$_SESSION['labid']."' and (batchNo='".protect($_GET['searchStdFeeNew'])."' or ID='".protect($_GET['searchStdFeeNew'])."') and recordType='Std' order by stdName";
	}elseif($_GET['searchStdFeeNew']!=""){
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where labid='".$_SESSION['labid']."' and (stdName like '%".protect($_GET['searchStdFeeNew'])."%' or contacts like '%".protect($_GET['searchStdFeeNew'])."%' ) and recordType='Std' ";
		$markText=strtoupper($_GET['searchStdFeeNew']); 
		if(isset($_GET['fname']) and $_GET['fname']!="") $query.=" and fname like '%".protect($_GET['fname'])."%' ";
		$query.=" order by stdName";
	}elseif(isset($_GET['fname']) and $_GET['fname']!=""){
		$query="select top 10 batchNo,ID,stdName,fname,programID,sectionID,Balance from student where labid='".$_SESSION['labid']."' and (stdName like '%".protect($_GET['searchStdFeeNew'])."%' or contacts like '%".protect($_GET['searchStdFeeNew'])."%' ) and recordType='Std' ";
		$markText=strtoupper($_GET['searchStdFeeNew']); 
		if(isset($_GET['fname']) and $_GET['fname']!="") $query.=" and fname like '%".protect($_GET['fname'])."%' ";
		$query.=" order by stdName";
	}else{
		$query="select batchNo,ID,stdName,fname,programID,sectionID,Balance from student where 1=2 and labid='".$_SESSION['labid']."' and stdName like '%".protect($_GET['searchStdFeeNew'])."%' and recordType='Std' order by stdName";
	}
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		//echo "<tr><td>".$cnt++;
		//echo "<tr><td>".odbc_result($cur,'batchNo');
		echo "<tr><td><a href='addFeeNew?stdID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'batchNo')."</a>";
		if($markText==""){
			echo "<td><a href='addFeeNew?stdID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
			echo "<td>".odbc_result($cur,'fname');
		}else{
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'stdName'));
			//echo "<td>".$str."</td>";
			echo "<td><a href='addFeeNew?stdID=".odbc_result($cur,'ID')."'>".$str."</a>";
			$str=str_ireplace($markText, "<b>$markText</b>",odbc_result($cur,'fname'));
			echo "<td>".$str."</td>";
			
		}
		
		echo "<td>".getHead($conn,odbc_result($cur,'programID'));
		echo "<td>".getHead($conn,odbc_result($cur,'sectionID'));
		echo "<td>".(odbc_result($cur,'balance'));
		$cnt++;

	}		
	echo "</table>";
}elseif(isset($_GET['searchStdFee'])){ //Student fee  (addFee.php)
	echo "<br><table class='table table-sm border'>";
	//$query="select ID,stdName,fname,contacts,programName,semesterName from studentview where  labid='".$_SESSION['labid']."' and stdName like '%".protect($_GET['searchStdFee'])."%' and recordType='Std' order by stdName";
	if(is_numeric($_GET['searchStdFee']) and $_GET['searchStdFee']>0){
		$query="select balance,ID,stdName,fname,contacts,programID,semesterID from student where labid='".$_SESSION['labid']."' and ID='".$_GET['searchStdFee']."' and recordType='Std' order by stdName";
	}else{
		$query="select balance,ID,stdName,fname,contacts,programID,semesterID from student where labid='".$_SESSION['labid']."' and stdName like '%".protect($_GET['searchStdFee'])."%' and recordType='Std' order by stdName";
	}
	$cur= odbc_exec($conn,$query);  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".odbc_result($cur,'ID');
		echo "<td><a href='addFee?stdID=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
		echo "<td>".odbc_result($cur,'fname');
		echo "<td>".getHead($conn,odbc_result($cur,'programID'));
		echo "<td>".getHead($conn,odbc_result($cur,'semesterID'));
		echo "<td>".odbc_result($cur,'balance');
		$cnt++;
	}		
	echo "</table>";
}elseif(isset($_GET['searchStudent'])){ //Student Search  (addStudent.php)
	//$cur= odbc_exec( $conn,"select 1 from student where 1=0 ");
	echo "<br><table class='table table-sm table-striped'>";
	echo "<tr><th scope='col'>#</th><th scope='col'>Name</th><th scope='col'>F/H Name</th><th scope='col'>Semester</th><th scope='col'>Program</th><th scope='col'>contact<th>Balance";
	$query="select ID,stdName,fname,contacts,programID,semesterID,Balance,status from student where  labid='".$_SESSION['labid']."' and recordType='Std' ";
	if($_GET['searchStudent']!="") $query.=" and (stdName like '%".protect($_GET['searchStudent'])."%' or nic like '%".protect($_GET['searchStudent'])."%' ) ";
	if(isset($_GET['programID']) and $_GET['programID']!="") $query.=" and programID=".$_GET['programID'];
	if(isset($_GET['semesterID']) and $_GET['semesterID']!="") $query.=" and semesterID=".$_GET['semesterID'];
	if(isset($_GET['session_']) and $_GET['session_']!="") $query.=" and session_='".$_GET['session_']."'";
	$query.=" order by stdName";
	
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) { 
		$stdID=odbc_result( $cur,'ID');
?>
                <tr>
                    <th scope="row"><a href='addStudent?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo odbc_result($cur,'ID');?></a></th>                   
					<td><a style='color:<?php if(odbc_result($cur,'status')==1) echo "red;" ?>' href='addStudent?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo odbc_result( $cur,'stdName');?><a></td>
					<td><?php echo odbc_result( $cur,'fname');?></td>
					<td><?php echo getHead($conn,odbc_result( $cur,'semesterID'));?></td>
					<td><?php echo getHead($conn,odbc_result( $cur,'programID'));?></td>
					<td><?php echo odbc_result( $cur,'contacts');?></td>
					<td><?php echo odbc_result( $cur,'Balance');?></td>
					<td><a href='<?php echo "addFee?stdID=$stdID";?>'>Fee</a>
					<td><a href='<?php echo "Reports/stdProfile?stdID=$stdID";?>' target='_Blank'>profile</a>
					<td><a href='<?php echo "Reports/stdCard?stdID=$stdID&expiryDate=$date_";?>' target='_Blank'>Card</a>

				</tr>
<?php 
$cnt++;	
/*
		echo "<tr><td>".$cnt++;
		echo "<td><a href='addStudent?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
		echo "<td>".odbc_result($cur,'fname');
		echo "<td>".odbc_result($cur,'programName');
		echo "<td>".odbc_result($cur,'semesterName');
		echo "<td>".odbc_result($cur,'contacts');
*/		
	}		
	echo "</table>";
}elseif(isset($_GET['searchStudentSchool'])){ //Student Search  (addStudentSchool.php)
	echo "<br><table class='table table-sm table-striped'>";
	echo "<tr><th scope='col'>#</th><th scope='col'>Name</th><th scope='col'>F/H Name</th><th scope='col'>Class</th><th scope='col'>Section</th><th scope='col'>contact<th>Balance<th>Fee";
	$qry=$query="select batchNo,ID,stdName,fname,contacts,programID,sectionID ,Balance,status from student where  labid='".$_SESSION['labid']."' and recordType='Std' ";
	if(is_numeric($_GET['searchStudentSchool'])){
		if($_GET['searchStudentSchool']!="") $query.=" and batchNo='".protect($_GET['searchStudentSchool'])."' ";
	}else{
		$txtSearch=$_GET['searchStudentSchool'];
		$len=strlen($txtSearch);
		if($len>2){
			$txtSearch=$_GET['searchStudentSchool'];
			$query.=" and stdName like '%".protect($_GET['searchStudentSchool'])."%' ";
		}
		if(isset($_GET['programID']) and $_GET['programID']!="") $query.=" and programID=".$_GET['programID'];
		if(isset($_GET['sectionID']) and $_GET['sectionID']!="") $query.=" and sectionID=".$_GET['sectionID'];
		if(isset($_GET['session_']) and $_GET['session_']!="") $query.=" and session_='".$_GET['session_']."'";
		if($qry==$query) $query.=" and 1=2"; // if no search
		$query.=" order by stdName";
	}
	//echo $query;
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while(odbc_fetch_row($cur)){ 
		$stdID=odbc_result( $cur,'ID');
?>
                <tr>
                    <th scope="row"><a href='addStudentSchool?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo odbc_result( $cur,'ID');?></a></th>                   
					<td><a style='color:<?php if(odbc_result($cur,'status')==1) echo "red;" ?>' href='addStudentSchool?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo odbc_result( $cur,'stdName');?><a></td>
					<td><?php echo odbc_result( $cur,'fname');?></td>
					<td><?php echo getHead($conn,odbc_result( $cur,'programID'));?></td>
					<td><?php echo getHead($conn,odbc_result( $cur,'sectionID'));?></td>
					<td><?php echo odbc_result( $cur,'contacts');?></td>
					<td><?php echo odbc_result( $cur,'Balance');?></td>
					<td><a href='<?php echo "addFeeNew?stdID=$stdID";?>'>Fee</a>

<td>
					<form name='<?php echo "addFeeNew".$cnt?>' method='post' action="addStudentSchool">
					<input type='hidden' name='stdID' value='<?php echo $stdID?>'>
		
					<select class='form-select form-select-sm' name='certificate' required>
						<option value='stdProfileSchool'>Admission Form</option>
						<option value='stdCard'>Student Card</option>
						<option value='birthCertificate'>Birth Certificate</option>
						<option value='characterCertificate'>Character Certificate</option>
					</select>
					<input type='submit' name='btnCertificate' value='Print'>
					</form>
<?php 
		echo "<td align='center' title='Delete Student Record Permanently'><a onClick=\"javascript:return confirm('are you sure you want to delete this?');\" href='addStudentSchool?delstdID=$stdID'><i class='bi bi-trash'></i></a>" ;
		$cnt+=1;
?>

				</tr>
<?php 	
		
	}		
	echo "</table>";
}elseif(isset($_GET['searchPatientTest'])){ //test patient serach name search  (patientTests.php)
	$value=$_GET['searchPatientTest'];
	$date_=date('Y-m-d',strtotime($_GET['date_']));
	echo "<br><table class='table table-sm table-striped border'><tr><th>#<th>MRNo<th>Date<th>Name<th>Department<th>Address";
	
	if(is_numeric($value) and $value>0){
		$query="select p.dailyNo,p.visitNo,p.patientID,p.doa,p1.name,p1.depID,p1.address from patientVisits p, patientTab p1 where p.doa='$date_' and p.patientID=p1.patientID and p.labid='".$_SESSION['labid']."' and p.dailyNo='$value' order by p.doa ";
	}else{
		$query="select top 10 p.dailyNo,p.visitNo,p.patientID,p.doa,p1.name,p1.depID,p1.address from patientVisits p, patientTab p1 where p.patientID=p1.patientID and p.labid='".$_SESSION['labid']."' and (p1.name like '%".protect($_GET['searchPatientTest'])."%' or p.patientID like '%".protect($_GET['searchPatientTest'])."%' or p.dailyNo like '%".protect($_GET['searchPatientTest'])."%') order by p.doa desc ";
	}
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while(odbc_fetch_row($cur)){  
		//if($cnt==1) echo "<";
		echo "<tr><td>".$cnt++;
		echo "<td>".odbc_result($cur,'patientID');
		echo "<td>".date('d.m.Y',strtotime(odbc_result($cur,'doa')));
		echo "<td><a href='patientTests?showid=".odbc_result($cur,'patientID')."&visitNo=".odbc_result($cur,'visitNo')." '>".odbc_result($cur,'name')."</a>";
		echo "<td>".getHead($conn,odbc_result($cur,'depID'));
		echo "<td>".odbc_result($cur,'address');
	}		
	echo "</table>";
}elseif(isset($_GET['searchPatient'])){ //admission search employee by name
	$value=$_GET['searchPatient']
	//echo "<br><table class='table table-sm border'>";
	?>
	 <br><table class='table table-bordered table-striped table-sm'><thead>
                  <tr>
                    <th scope="col">#</th>
					<th scope="col">Date</th>
					<th scope="col">Name</th>
					<th scope="col">Address</th>
					<th scope="col">contact</th>
					<th scope="col" align='center'><i class="ri-printer-line"></i></th>
					<th scope="col" align='center'><i class="ri-printer-line"></i></th>
					<th scope="col"><i class="ri-microscope-line"></i></th>
                  </tr>
                </thead>
                <tbody>
<?php				
	$query="select patientID,name,fname,address,contacts,date_ from patientTab where  labid='".$_SESSION['labid']."' and patientID>0 and name like '%".protect($_GET['searchPatient'])."%' and contacts like '%".protect($_GET['contactno'])."%' order by name ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		echo "<td>".date("d.m.Y", strtotime(odbc_result($cur,'date_')));
		echo "<td><a href='regPatient?showid=".odbc_result($cur,'patientID')."'>".odbc_result($cur,'name')."</a>";
		echo "<td>".odbc_result($cur,'fname');
		echo "<td>".odbc_result($cur,'address');
		echo "<td>".odbc_result($cur,'contacts');
	}		
	echo "</table>";
}elseif(isset($_GET['searchEmpAdmission'])){ //admission search employee by name
	echo "<br><table class='table table-bordered table-striped table-sm'>";
	echo "<tr><th>#<th>Name<th>F/Name<th>Address<th>Salary<th>Card";

	$query="select ID,stdName,fname,address,status from student where  labid='".$_SESSION['labid']."' and stdName like '%".protect($_GET['searchEmpAdmission'])."%' and recordType='Staff' order by stdName ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++;
		//style='color:<?php if(odbc_result($cur,'status')==1) echo "red;" 
		if(odbc_result($cur,'status')==1)
			echo "<td><a style='color:red;' href='admission?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
		else
			echo "<td><a href='admission?showid=".odbc_result($cur,'ID')."'>".odbc_result($cur,'stdName')."</a>";
		echo "<td>".odbc_result($cur,'fname');
		echo "<td>".odbc_result($cur,'Address');
		echo "<td><a href='Emp_Allowances?showid=".odbc_result($cur,'ID')."'>Salary</a>";
		echo "<td><a href='Reports/empCard?empID=".odbc_result($cur,'ID')."&expiryDate=$date_' target='_Blank'>Card</a>";
	}		
	echo "</table>";
	
}elseif (isset($_GET['searchEmpName'])){ //addLeave 
	echo "<br><table class='table table-sm'>";
	$query="select ID,stdName,Status from student where labid='".$_SESSION['labid']."' and status=0 and stdName like '%".protect($_GET['searchEmpName'])."%' and recordType='Staff' order by stdName ";
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	while( odbc_fetch_row($cur)){  
		echo "<tr><td>".$cnt++;		
		$stdName=str_ireplace($_GET['searchEmpName'],"<mark>".$_GET['searchEmpName']."</mark>",odbc_result($cur,'stdName'));
		echo "<td>".$stdName;
		if(odbc_result($cur,'status')==1) $color='red'; else $color='';
		echo "<td><a style='color:$color' href='addLeave?empID=".odbc_result($cur,'ID')."'>Select</a>";
	}		
	echo "</table>";
	
}elseif (isset($_GET['subjectID'])){
	//$subjectID = $_GET['subjectID'];
	$teacherID=getName($conn,"select top 1 teacherID from attendance where  labid='".$_SESSION['labid']."' and subjectID='".protect($_GET['subjectID'])."'");
	echo "<select id='teacherID' name='teacherID'>";
		echo fillCMB($conn,$teacherID,"select ID,stdName from student where  labid='".$_SESSION['labid']."' and status=0 and recordType='Staff' and grade>=16  order by stdName");
	echo "</select>";
	
}elseif (isset($_GET['jobID'])){ // jobDiv in jobFormula.php
	$query="select * from AccountHeads where  labid='".$_SESSION['labid']."' and headType='jobPercent' and headID='".protect($_GET['jobID'])."' order by order_ ";
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
	   if ($cnt==1) echo  "<br><table class='table' border=1><tr><th>Serial<th>Degree<th>Education<th>percentage<th>EDIT<th>Delete";  		
		$jobID=getName($conn,"select headName from AccountHeads where  labid='".$_SESSION['labid']."' and ID='".odbc_result($cur,'headID')."'");  			     		
		$degreeID= getName($conn,"select headName from AccountHeads where  labid='".$_SESSION['labid']."' and ID='".odbc_result($cur,'Balance')."'");  			     		
		$percent=odbc_result( $cur,'openingBalance');  			     		
		echo  "<tr ><td>". $cnt++ . "<td>$jobID<td>$degreeID<td>$percent<td><a href='jobFormula?editjobID=".odbc_result($cur,'headID')."&degreeID=".odbc_result($cur,'Balance')."&order_=".odbc_result($cur,'order_')."&percent=$percent'>Edit</a>" ;
		echo "<td><a href='jobFormula?deljobID=".odbc_result($cur,'ID')."'>Delete</a>" ;
		$jobID=odbc_result($cur,'headID');  			     		
	}  
	echo  "</table>";	
}elseif (isset($_GET['jobID2'])){ // formulaDiv in jobFormula.php 
	$query = "select Balance,openingBalance from AccountHeads where  labid='".$_SESSION['labid']."' and headType='jobPercent' order by order_";			
	$cur= odbc_exec( $conn, $query );  $cnt=1;
	echo  "<br><table class='table'><th>Serial<th>Name";  		
	while( odbc_fetch_row( $cur ) ) {		
		$degreeID[$cnt]= odbc_result($cur,1);  			     							
		$percent[$cnt]= odbc_result($cur,2); 
		$marks=getName($conn,"select headName from AccountHeads where  labid='".$_SESSION['labid']."' and ID='".$degreeID[$cnt]."'  ");
		echo "<th>".$marks."<br>".odbc_result($cur,2);
		$cnt++;
	}
	echo "<th>Total";  		

	$query = "select ID,stdName from student where  labid='".$_SESSION['labid']."' and  recordType='Candidate' order by ID";
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
    while( odbc_fetch_row( $cur ) ) {  
		echo "<tr><td>".$cnt++."<td>".odbc_result($cur,'stdName');
		$total=0;
		for($x = 1; $x <= count($degreeID); $x++) {
			$marks=(float) getName($conn,"select obtMarks*".$percent[$x]."/totalMarks from qualification where  labid='".$_SESSION['labid']."' and degreeID='".$degreeID[$x]."' and ID='".odbc_result($cur,'ID')."' ");
			echo "<td align='center'>".floatval($marks);
			$total+=$marks;
		}
		echo "<td>$total";
	}
	
	echo "</table>";
}elseif (isset($_GET['shiftID'])){
	$query = "select autoID,remarks,entryTime,dayID,exitTime,headName,lateIn,earlyOut from tblShiftView where  labid='".$_SESSION['labid']."' and shiftID='".protect($_GET['shiftID'])."' order by shiftID,dayID";
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
	echo  "<br><table class='table' border=1><tr><th>Serial<th>Shift<th>Day<th>In<th>Out<th>late<th>Early<th>EDIT<th>Delete";  
    while( odbc_fetch_row( $cur ) ) {  
       $autoID= odbc_result( $cur,'autoID');  		
	   $remarks= odbc_result( $cur,'remarks');  		
	   $entryTime= round(odbc_result( $cur,'entryTime'));  		
	   $dayname=getDay(odbc_result( $cur,'dayID'));
        echo  "<tr><td>$cnt<td>".odbc_result( $cur,'headName')."<td>$dayname<td>".odbc_result( $cur,'entryTime')."<td>".odbc_result($cur,'exitTime').
		"<td>".odbc_result($cur,'lateIn')."<td>".odbc_result($cur,'earlyOut')."<td align='center'><a href='shifts?editvno=$autoID'><span class='glyphicon glyphicon-edit'></span>edit</a>" ;
        echo "<td><a onClick=\"javascript:return confirm('are you sure you want to delete this?');\" href='shifts?delvno=$autoID'><span class='glyphicon glyphicon-remove'></span>del</a>";
		if ($cnt==1) {
			$total1= $entryTime; 
		} else {
			$total1= $total1+ $entryTime;
		}
		
		$cnt+=1;
    }  
	
}elseif (isset($_GET['itemName'])){
	//echo "<table>";
	$pNo=$_GET['pNo'];
	$query= "select itemID,itemName,rPrice,percentage,tPrice,barCode,qty,pPrice,expiry from itemTable where  labid='".$_SESSION['labid']."' and itemID>0 and itemName='".protect($_GET['itemName'])."'";
	$cur= odbc_exec( $conn,$query);  
	while( odbc_fetch_row( $cur ) ) {  
		$itemID=odbc_result( $cur, 'itemID');
		$rPrice=odbc_result( $cur, 'rPrice');
		$percentage=odbc_result( $cur, 'percentage');
		$tPrice=odbc_result( $cur, 'tPrice');
		$expiry=odbc_result( $cur, 'expiry');
	}
	echo  "<form action='addItem2' method='post'>";    
	echo  "<input  type='hidden' value='$itemID' name='itemID'>";
	echo  "<input  type='hidden' value='".protect($_GET['itemName'])."' name='itemName'>";
	echo  "<table class='table'><tr><td>Retail/Sale Price<td><input maxlength='10' type='text' id='rPrice' value='$rPrice' name='rPrice' required>";
	//echo "  Price/tabs : <input style='width:80' type='text' value='' name='monthly' id='tabPrice' onKeyup='calculatePrice();' onfocusout='' >";
	//echo " Nos of Tables : <input style='width:80' type='text' value='' id='tablets' onKeyup='changeValues();'>";
	echo  "<tr><td>Percentage<td><input maxlength='10' type='text' value='$percentage' name='percentage'>";
	echo  "<tr><td>Trade/Purchase Price<td><input maxlength='10' type='text' value='$tPrice' name='tPrice'>";
	
	echo  "<tr><td>Opening<td>qty:<input type='text' style='width:60' value='' name='qty'>
		%age:<input type='text' style='width:60' value='' name='percentage2'>Unit:<input type='text' style='width:60' value='' name='uPrice'>
		Batch:<input type='text' style='width:60' value='' name='batchNo'> Expiry:<input type='date' value='$expiry' name='expiry'>
		Inv#:<input type='text' style='width:60' value='$pNo' name='pNo'>";
	
	//echo  "<tr><td>Packing<td><input type='text' value='$packing' id='packing' name='packing'>";
	//echo  "<tr><td>Stock Limit<td><input type='text' value='$limit' name='limit'>";	
	//echo  "<tr><td>Barcode<td><input type='text' value='$barCode' name='barCode'>";
	echo "<tr><td align='center' colspan=2><input type='submit' Name='btnSave' value='Add to Invoice'>";
	echo "</table>";
	echo "</form>";
	$query= "select itemID,itemName,rPrice,percentage,tPrice,barCode,qty,pPrice from itemTable where  labid='".$_SESSION['labid']."' and itemID>0 and itemName='".protect($_GET['itemName'])."' ";
	$cur= odbc_exec( $conn, $query );  
	$cnt=0;
		while( odbc_fetch_row( $cur ) ) {  
			if ($cnt++==0) echo  "<br><table class='table' border=1><tr><th>S.#<th>Name<th>qty<th>Retail<th>%age<th>Trade";  
		   $itemID= odbc_result( $cur, 'itemID' );  		
		   $itemName= odbc_result( $cur, 'itemName' );  		
		   $size=strlen($itemName);
		   $rPrice= round(odbc_result( $cur, 'rPrice' ),2);  
		   $percentage= odbc_result( $cur,'percentage');
		   $tPrice= round(odbc_result( $cur,'tPrice'),2);
		   
		   echo  "<tr><td>$cnt<td>$itemName<td>".odbc_result( $cur,'qty')."<td>$rPrice<td>$percentage<td>$tPrice";
		   //$amount+=odbc_result( $cur, 'tPrice' )*odbc_result( $cur, 'qty' );
		
		}  	
		//if($cnt>0) echo  "<tr><th colspan=6>Summary<th>".round($amount) ;
		echo  "</table>";

}elseif (isset($_GET['doctorID'])){
	$forDate= date("Y-m-d", strtotime($_GET['forDate']));
	$query= "select * from appointment where  labid='".$_SESSION['labid']."' and autoID>0 and doctorID='".protect($_GET['doctorID'])."' and forDate='$forDate'  order by aptNo asc";
	$cur= odbc_exec( $conn, $query );  
	$cnt=0;
	while( odbc_fetch_row( $cur ) ) {  
		if ($cnt++==0) echo  "<br><table   class='table' border=1><tr><th>S.#<th>Date<th>Apt No.<th>Name<th>Address<th>Contact<th>EDIT<th>Slip";  
	   $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' )));
	   $forDate= date("d-m-Y", strtotime(odbc_result( $cur, 'forDate' )));
	   $autoID= odbc_result( $cur, 'autoID' );  		
	   $name= odbc_result( $cur, 'name' );  		
	   $address= odbc_result( $cur, 'address' );  	
	   $contacts= odbc_result( $cur,'contacts');  	
	   $doctorID= odbc_result( $cur,'doctorID');
	   echo  "<tr><td>$cnt<td>$forDate<td>".odbc_result( $cur, 'aptNo' )."<td>$name<td>$address<td>$contacts<td><a style='text-decoration:underline;' href='makeAppointment?showid=$autoID'>edit</a>" ;
	   echo "<td><a href='Reports/appointmentSlip?autoID=$autoID' target='_Blank'>Slip</a>";

	}  
	echo  "</table>";
	if ($cnt==0) echo "No Record Found";
}elseif (isset($_GET['subHeadID'])){
	//$query="select ID,headName from AccountHeads where  labid='".$_SESSION['labid']."' and headID='".protect($_GET['headID'])."' order by order_";
	$query = "select * from accountsView where  labid='".$_SESSION['labid']."' and accountID>0 and headID='".protect($_GET['subHeadID'])."' order by stdName";
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
	echo  "<br><table class='table' border=1><tr><th>Serial<th>Account Name<th>Description<th>Opening<th>Balance<th>Order<th>EDIT<th>Ledger";  
		while( odbc_fetch_row( $cur ) ) {  
			$ID= odbc_result( $cur, 'ID' );  		
			$headName= odbc_result( $cur, 'headName' );  
			$headType= odbc_result( $cur, 'headType' );  
			$openingBalance= odbc_result( $cur, 'openingBalance' );  			   		
			$order_= odbc_result( $cur, 'order_' );  			   		
			$symbol= odbc_result( $cur, 'headDescription' );  			   		
			
			echo  "<tr><td>$cnt<td>$headName<td>$symbol<td>$openingBalance<td>".round(odbc_result($cur,'Balance'))."<td>$order_<td><a href='addHeads4?editvno=$ID'>edit</a>" ;
			echo "<td><a href='Reports/ledger2?accountID=$ID' target='_Blank'>ledger</a>" ;
			$cnt+=1;
		}  	
	echo  "</table>";
}elseif (isset($_GET['headID'])){
	//$classID = $_GET['classID'];
	//$query= "select ID,Name from section where  labid='".$_SESSION['labid']."' and ID in (select distinct section_ from student where  labid='".$_SESSION['labid']."' and fitClass='".protect($_GET['headID'])."') order by ID";
	$query="select ID,headName from AccountHeads where  labid='".$_SESSION['labid']."' and headID='".protect($_GET['headID'])."' order by order_";
	$cur= odbc_exec( $conn, $query );  
	while( odbc_fetch_row( $cur ) ) {  
		echo "<option value='".odbc_result( $cur,1)."'>".odbc_result( $cur,2)."</option>";
	}
}elseif (isset($_GET['headID3'])){
	$query = "select * from AccountHeads where  labid='".$_SESSION['labid']."' and ID>0 and headID='".protect($_GET['headID3'])."' order by headType,order_";
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
	echo "<div id='tabDive' >";
	echo  "<br><table class='table' border=1><tr><th>Serial<th>Account Name<th>Order<th>Symbol<th>EDIT</th>";  
	while( odbc_fetch_row( $cur ) ) {  
			$ID= odbc_result( $cur, 'ID' );  		
			$headName= odbc_result( $cur, 'headName' );  
			$headType= odbc_result( $cur, 'headType' );  
			$openingBalance= odbc_result( $cur, 'openingBalance' );  			   		
			$order_= odbc_result( $cur, 'order_' );  			   		
			$symbol= odbc_result( $cur, 'headDescription' );  			   		
			echo  "<tr><td>$cnt<td>$headName<td>$order_<td>$symbol<td><a href='addHeads3?editvno=$ID'>edit</a>" ;
			$cnt+=1;
	}  
	echo  "</table>";
}elseif (isset($_GET['headID4'])){
	$query = "select * from accountsView where  labid='".$_SESSION['labid']."' and mainHeadID='".protect($_GET['headID4'])."' order by stdName";
	//$query= "select * from student where  labid='".$_SESSION['labid']."' and accountID>0 order by accountID desc";
	//echo $query;
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
	while( odbc_fetch_row( $cur ) ) {  
		if ($cnt==1) echo  "<br><table   class='table' border=1><tr><th><a href='feeEntry.php'>S.#</a><th>Name<th>Address<th>Opening<th>Balance<th>Edit<th>Purchase<th>pReturn<th>Payments<th>Ledger";  
	   $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' )));
	   $accountID= odbc_result( $cur, 'ID' );  		
	   $accountName= odbc_result( $cur, 'stdName' );  		
	   $address= odbc_result( $cur, 'address' );  
	   $contacts= odbc_result( $cur,'contacts');
	   echo  "<tr><td>$cnt<td>$accountName<td>$address<td>".odbc_result($cur,'admFee')."<td>".odbc_result($cur,'Balance')."<td><a href='addAccount?accountID=$accountID'>Edit</a>";
	   
	   echo "<td><a href='purchase?accountID=$accountID&invType=pNo'>purchase</a>";
	   echo "<td><a href='purchase?accountID=$accountID&invType=pRNo'>PurReturn</a>";
	   //echo "<td><a href='purchase?accountID=$accountID&invType=saleNo'>sale</a>";
	   //echo "<td><a href='purchase?accountID=$accountID&invType=saleRNo'>saleReturn</a>";
	   echo "<td><a href='paymentReceipt?accountID=$accountID'>Payments</a>";
	   echo "<td><a href='Reports/".$_SESSION['ledgerReport']."?accountID=$accountID' target='_Blank'>ledger</a>" ;
		$cnt+=1;
	}  
	echo  "</table>";
}elseif (isset($_GET['getBalanceID'])){
	//$query = "select Balance from accountsView where  labid='".$_SESSION['labid']."' and ID='".protect($_GET['getBalanceID'])."'  and recordType='Account'";
	$query = "select Balance from student where labid='".$_SESSION['labid']."' and ID='".protect($_GET['getBalanceID'])."' ";
	$cur= odbc_exec( $conn, $query );  
	while(odbc_fetch_row( $cur ) ) {  			
		echo "(Balance:".round(odbc_result($cur,'Balance')).")";						
	}  	
}

//odbc_

odbc_free_result($cur);

//odbc_close($conn);
exit2($conn,$conn3);

?>