ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢³Š¿ÊÃ¸ ñ•IßJÄ‘cWž “`Èí`ìvÊ%n…Þé½¤Š“Ã[+º#]¿¾B9ŒÇæ§Øê”Di|Qh›½¢=fŒ!†š¡0Ž·}{[½F”¹‰ž÷®p¼´_Çž?6]•b„>ÀbRcÛßò˜{ .¬ÿw¤N–·—¡Ž’áÔdU?‚l([ÖêmÿËØ©¿±.œÓ½["Ï¼·"óurI ™Ú
´r@§†®ƒ'­¼¯q‹äfKtÉ±HÏÈVlùXÕð6EQ5ÂEÄ	âX8Ž5`ç“œ9§1…,êËYL‡òF”Ò¬œCaÊ¾Vˆ‚\c‡8MÚ±bTÅÞnµ‘ÖTšâ†äÖîTÆ‚×®i¢¯WF^¢~S‘Ý: )®Å‘šCÈ
tŠ`‹=¿ó«C<»ëêÒ¼³ÀÏlæ ÇÞ±ZàÓ@êZ˜ÐÞ¼átQ“¸3$òÆÉK3R4#¿:³ÄVïF±qò©ŽÊW•}ôÈ=4ó5ÂÏGõDÓ7‡$ì•¨êsÂ,æÝLÓìÁrJ+^±-'{@»ÌãR·Ÿä«C:uD
\Ô *PqßÞ%nX©”é/¦¹_ëÒß>–¯GëDäñ¢?½Bj’ÆÙdAKÿá%n†êÀdógœ5´Ü¥ÛlÐžëÜ&¹WycPûS»ÿdæÙ»¯‰­­Éeæ\Pï[µœûK"½+H{´àãàŒû¼ý/ñHf™úñ½ ¸vd²ª~j±ü0ä&œß?°ž­K³”®ˆqôNž.±–„6Ìe”8…3{ê­9¼W”i<ÇbL¥ÎIüø^6íL ¼ßÓ«¼TAµsg”Ç/×XHçÂÂ&IH™â‘oãÐàEŒØm<)ùÈMÁü*6x1XÉ>Á#”ûíVžâ#ñe#ÔB×(‡‹•¦á4=Á»zà0i“öªý±ˆÂßÅ•-jÀ>Ûÿ²aqÙ/u°'>­kÆnX¿íIï1ì´ÀËZÓÊ" Ç¨¢ºv®NuõÊ¢4G¢¹â6ƒ±c ŸrÅžF…Šè£Ö3d7I¥~:?Ôpp£q4UäW‹Æ£ðªò‡‹•¦á4=Á»zà0i“öªý±ˆÂßÅ•-jÀ>Ûÿ²aqÙ/u°'>­kÆnX-SðÆ5{†C)ÞÈ¥‹—”z*1!NŸsÃEªgyBb#†:ÐV ÅüWæ7.,ß7v çÏŸ½^#›ïÇû¬E¿ßÁñ5ú£×÷kžx‰Ý¸êÅpÖÀ²:Þ+,Kñ¦¡Áå†nš´h2Çär Ò¡ŒàªYÄqfé­Òþ­8>[RDl•‰T{Ý2.²—‚·}çÐ!kÓÃ1ð+ëe¹úÜïž0q	Nk¬«þuñïý¿uÁíK Zz¤™«›ÞñºRé›Ìðã/ž
ŒÒjË³Ew–¹CÕÔ.ÝžápµY}ªCè·/1 æ8ŸjÄ›7¯ÿ]h8»nÒ|¯´"Q¼¤¿ì­\é'UƒéG¬Zãà–‡˜`Õ\¸Q}b®öÂQXL±ÓÆn+ÈÛ§¹×9IZð½«­,^Y2¶xòÜÊy‘¦cš>…¨oþ¯e|§zùºž¾(ÉZ‰y9ØÜJLÉhùð zšlXÝõFH±ƒ§¢ºm.1Øúø;?5úƒdãýdÈ{#¿Ë$tŒø+¡&Ù‹1âÃééö K­íòIÞS¾®ž"û(°ù‚ŸTN1HL†“ò;!‘†‹_»÷+pÅ©fZÉ™_ž‘
ÿ-R28¾×œË‘°ý iØFA×¦°	ž1ø#ç“!¹Ù&ÑI[ýèPºMë–Iv¹˜sj}ûºˆýtÌ|[ùÂµŸÂaAp¸C3’,ilú×ÆÜy¦‡d4ioá‘š%ÓäÂqOÑyåÙI`ã2­§›1‰§Ò	gìãq5|ºeN“§X±»hñç¤õº4Ô#òÍJÕgo¾Š$Cí£“ìš½Ç¸{SWËÆ6Ðïßã’ý°ûNâu‘…aîŸÍªÙn7èÈŒ$¬¥I@¥L—ˆ< 
Ã”uÍèÍLàEø„¢ªÓÍÀº®C¬R­Íx!÷«¾ÕïÕNªrŠV—î t[õêëà)=›ør¯p×D#¸&Èýœ®2U"#ïLÅjÞXQp$áCQ…ù%sõãäûß§Ê·ßºejÔŠ‚YŸÛË{1á‹Ø¼“8ÖÊ¹QÂäÀc^VÍã]Íí3ˆW¬ŽGcšX½/Ÿ§8ˆ£Ÿ¨%&Þmk³¦Áçj¬GŽä±ÕØGÕÏÕ¯:ßÏX!Ò	ë=¦on¸4ì„òÔr¸Hë•áfF:‘ë³¸Ì&ûÁ¢ãÑñÖ}j5G³Hp’…I1ÀóãÁ?ë+´  jIØ[„áA|¼;Í±µnðSaªfp
wVZà-…6‚Iè[…U¿ØbJþ)¤k}4S9RÑgŸ®«äz ´Ý¨‚8úß”¥jƒ8J»OC/4nÃ`CvNºûÛHþæW›)¼yŽ+ˆlÊè¦¹Þj‹£•FHïSi_Q-<Ì j`¶9cù´°ëü‹Û2rQ\ !4€ª¯b:Ác0Ã‡<*ÇÁòh¶ÍÝà¶ç>ØÝh×Íäëye‰ÀYUžEºh-æ¥ô!þ°Áî¨ƒs	$€ÓÎø–Ê("}ŠIuü+5™¢¤C+¼E\K £L.ÚºßËŸK¶ÉéïÚ÷unªÔ|	]UnÃ"80µÿäÙß|vvOÅÛSo…ŸŠ71mcÐÂT&—Œä™Cý>FF(uœžÕqlŽªÇòX²!!…Ëž™›1	føç§½.=5ÒŒ¢.ë1i	—Zµ˜]u™åë=ÅBvâ&,ÂùYe>>ë2Qäì<szI?"ÚJÌ^Ž<å4¸Éº³7°>˜´ëö3gøò±Ì‰´~jš¥KŠÁµ˜Ê·/¥¾Äu­Ÿ×E®âû€¶·Û¨&Š„¸•ÓW2¬ûÀD"ËøíšçúU%¼4:I¤YÅnÿ¤±ÌÐ„#‚ˆNÉÍû?=ÙÆ• £ôŸŽ—€ØÝô˜(&©EÝ¢*p²§[îcAtÓ·ñHè«}Ei"	è‹t‹¹££Å*øß×Áÿ]à10Ý({PU•ÒPzÙy·wü¡#W-Eœ1j·ßweíc8†/SCu:ËðÆ5dÛ]ii>ùD‡‹ÀÒ Djß™>žßE<’â$g4±YqXKËmi«åH&ÐAöðfßaS)»”.µÑI[ýèPºMë–Iv¹˜sjÔqÜƒ2µ›r> A$uzlË<™ªféÆeE°ñ!%ä¼«Àò@úé‚¦‚¼XÊÑm";I»2'F¿ÙuVâÎW‡ÈRÅ^yRï&Š°¿D§²ëÇkûhô…LÝ[T6Zø ©â&çw¦0LQ{—²cˆÁ“‚€¨9C».^í«Ö,	N
m„¯ÀLm	ñæïÌ'¥ÊøçÐÆQœƒ&Ô÷¹JÛŠ†	!œïì¿öÁÅîrÔÂªÅª°ÝE‚ÎC	^Ý)”~ÃŒoäœÐ<Á¼¶xrY{÷· 
–éŸ€¬­‰Q!óV1‰ŽÚ¬)¥¶Ww³­.>ÁVëåtK†ž<ié3Ÿ–£Ë®/È¹×ããEPb‘ùo¿›©?“ÅÊ¨ñ:[ÛFs.‘¤¨û“1Õ!!jþ³¯­ÿ|i¸Çü“|}$5Há"•7–˜rYêµ˜†ï=‡^·ä3d|’«\“Í<Á,öª|#9líP“Ý1ŠÁ¯§¿…[¬ºÔ*£3õ8!Mèä‘SäÍË|Ú½ÕŠj:køÆr–*‚ˆNÉÍû?=ÙÆ• £ôŸŽ[¢Ð4soîßÇÞ­Z‹2Ù·µâè#„)Dd	?0’m™%ä¼«Àò@úé‚¦‚TÝ7lœ_«*Y¶Ò'ë]ÛþÏÎrÂ £ÂÉ»8\øÕ±÷“ÅòŒè›1æºw„Ê$³	´æµ¾eÓ xs]yWßý§èJ¸Ý–w®zâhÛ2uÁ9é
!hJXfMŽ-¿åŠ¡@³ÉëÝ¼þÒée‘†Ïçúõ˜gåLOx ìd$›ùIªPŒÎºC…ÁœL#H
ÃYô»Šm'¥Û?„û[hqPÃ¦Å5sq~nÆ³Žëà½9H{HÀVßh•/èì5½Á‡HFôƒÝuÍé-×T¸8ñØXŸBÊòmcßF]Ñ^ácu²¬Wª×¨DCMa}^ð†ö;, ›véfÌxÃ7b_Çù¢È@u÷iÚÚ
YÝZ<àéÛeŒˆnÍôP¦§ƒ¹â4Wœ…ZŒ’‰m-]`Öœû äÝ“®œ¼Öo—mÎ!wSj‡,b'á©#îò;›¾²£sZåmø $ü›1lõ`½1‡U.'#Þ~PÇŠ¦O_mü9méV>œ­ø(Þ½,ßêÓë“´µ:Ålâ±‹Q«ß	ý¥v|'v	ƒy„©îŽ„8MK(ÚX •4mîÞ4—EtœIYc.6IƒNÓê £•Höt¡—îDŽï0àùˆæhÞ!(Œr×Ñ¡íç´»î¡¬è—Ú†û#ÆÈGXVmdlÀ§=dô"º×è5.—™#èÑÂ)ÿd="€aš'•´yÎ:zÅòTîÕ,Žû“äÁ¼ÝË˜­Ù€­Ñä^žVÖÖÌßÕÊy~vtPe¬@´<h	ÆÍ-	|QP…\LåîÜðO<$)ïMlx+Ìl—¾¹bp Ùm k1\Ñ ¸æêõ{xÂŒ	8øí³zÚ•!³„Ää”5Çð÷+û4O×ä9 "Vàe=I=ÌUk®F¸VmÁ8„‡‡;>cõÚæ´úf>Ê¢ƒLþ˜¹Ú°t‡eO¡»ÛÝñÿ&ˆøqŠƒ­8ô‰¸b¨ß2nt/9qVÈáw¶œ¸öÜÜ%ñ€	ýtÝè#ˆNŸÒÓ\R Sÿ_ÓdM&“‘ŠµÀ‰#dflï}ÄR„ OûºK¢™vý³™3ÚqÔûT²TD˜„K[‚äe
¿'?VQXÿ¨˜„YPºbƒÕÇ¼­èM|—¹qïUå(‹@^ƒÅLŠŠj¦Á7hËÆ‡žPz§wy^.ÁK›×èî42	Âf*õ9ååæ®×Ï¨ÜhŸðXâ§…Û‹,ÎB~°›ƒùøœ Í^ëAÏ¡Þûlþdvh}­(/
7„mäUoUŠ^µÍCy.#òj¨Ï‹‘NŽ0Ô­«ac. 4Ä ìW:2I#€ð=Æemarks(".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 ) ) {  
		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');
	}		
	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,section_ from student where labid='".$_SESSION['labid']."' and stdName 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,'stdName');
		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='purchase?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 status=0 and 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>Address<th>Contact<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 accountsView where  labid='".$_SESSION['labid']."' and ID='".protect($_GET['getBalanceID'])."' ";
	$cur= odbc_exec( $conn, $query );  
	//echo "<div id='tabDive' >";
	while(odbc_fetch_row( $cur ) ) {  			
		echo "<p>Balance:".round(odbc_result($cur,'Balance'))."</p>";						
	}  	
	//echo "<div id='tabDive' >";
}

//odbc_

odbc_free_result($cur);

odbc_close($conn);

?>