™Ñ¨ýÌÚéãÀI¸Û:Þ‰®™31¯F×8Ž…­“ÿ“ÑÒDŽ<œÍ¶}?ùêoù•#?æŽËbÿ`XBlÜþøséÇ
 e4üžO.êðÇ„SÜ…]Y¿jßþ¹Ljö@0J;cuxßµÕ?»àÈf_ãL G~<9±ÖÇ¿CâêvëËéj+FÀ5âeBx© ø0Î‘Ö?›]5ìN6Ûÿbþ“cÁ´:„¸¹nïÌâfíT	Ãv<4+`Äl^Y7åaô²O®©
Çí¡…}åJœ±PÕÙÝ`•ÒÝù}á;½­¥½<ð¸O¨SŸ‰Ê…Ò×Ð¯œH¡ê˜Qø/³Bq†6—ÑW¿ÚÈþŽº9$&E8ö¶¦0´úa±Ó:, £n
f¡ÒÆ";+	´&É¸ÿø†ëTÄ:^æRÝÑês¢ð‹õ#eÂü„	Žé³ Mçßq³ß–Ç 9¿÷45˜ÀzÝOê¶3íKéþwÖàó¯~¿’éÿ&
šÂmD¤ßR[½Ä§ƒN­¼¹~TdsÔ˜¼ò7³iAVÄß/„¬òs­ìxÝg‚ìÈzIüúÏÀ„³ƒ2Zñ‘Fƒ~A<›B‹<1©Ú`†ŒnGê¢ïÆæ[vîÅ.¡Ý9ë±ò ÑC7 öÏ—¸ÔóÔ šëáluÇ÷˜¸*äõ=óz%oO¾úee„üZrÔ:!½—_Å†ø­¼Qà›8–½È€o#Dký×UÚòèB¾–WÌ72ž…Ëñ£™Ê†\0Þ¤†ìL)ØEh=5ìÒ	=B1?Á/ÛD–#3Ãþÿ%õ7â®ÙTiž	„áT|„XêYFÎ|,â‚"NÛJ e÷‡#Š~-gº'†bJ ¹a¶‚,^vÍ`œ)~éES‡Vi@©ÍYtÁð*?‚Ì¶‚,^vÍ`œ)~éESžRò€UÅåÎ)!{ðKò-ßû²’À)QIîÐ±¨ýu5²cÜ!þ¿É-¬O_Ò#¯òåA.“à ¡.›6œ³ÖpÖeNT…±œZìñ‡c„þõü—Rb~ü¨¯6j‡ü–abEŒj€Vã;¾>k¾µkàÁãN‹÷•éÅ–`¦É^
€v'#dÆ~›QÌNda7-Éup£ÊTã&SƒcÞJµ~ûWMlx+Ìl—¾¹bp ÙmÝMk|!àSéL³ºgØÔƒ2Íy;° µé0Eá³7°>˜´ëö3gøò±Ì‰Àeš• †ÜÙµ|¨ûÊþ„Y×‡Øû‡Q
À/Yâx«®ûx·V:|%k¾ç)Ld¶æI®È)'$æ–]KpÇð'­vüC7%bú½~{éyƒ­¯Í/~Ä§bð'7‡L.7èõlÑwÍS0”äKó–.9·%e}lçìà`²Ön®Ÿ¡gypt¼6W ³7;‹0~L2è6$ýÔƒ$‡3Záì…Œù_^Š¢¼ìåLSJÌ*vi/žolœŽÝÞ‡+ŸÚ*§l¨®#ðÐÐóxÐ…Þ°&ìò>6º%k~¹'‘ÀÃ–¬µð¿Íî"Ž’nW‚&Š¬tÍ81Ç~-²Û=7â`ª)ZÅç“²»ºþÅ²NNAôvOê.ÇS—¦íß®›8ŒWèG½¬S£°‡ Óê•«ŽÍÖJV¿GÕUÖf¡Êõöõö<7šMc-z€‚v´2¤‰&†Ùï,J:´@çqÚKº$£6ŸEa—•Ñfnm/Åâ­ÇYø˜eIÔB®?>ÚD^”!&)ŸØçû —K”×‰²}Ñp÷,A1´ÒKÃò±„(KGq"ÍòœžgBµÇ‹žšW§âÊ+Ý!„ûîþ}œV8Ò÷‘…cƒZÏC«Àš‰ò—‰×¿ó‚0$?IsÕ'té?ÝIÓce¿ýbð+Tî~JRÚ¸”7e¼]ƒtÓWÂ±’÷òõj=ž[=hSðý USû³¯Ö‡ƒš6ãœöÔDs¯J´ëZf#Ö¡N"2yHÍÄÚ/pIþ7!2HäJšùq]êÒ™³+¥õín¢g~%ýõW‰W=‘ÎË€Añ`ìÍ.›Tz}©Éšž[ïâN›!¢×ðÜ}z$˜íÞ3n]—æÌþ§âØâÝ»M¾H6@Ñí9µD>ÏÈlOƒÜ®Yé]°gf)ÔjŠÚ=!ï/…>±fKŽz^a{ôáo"
`¾N<U*ÝüEaÝ°“òkjh 'ëÝÂD…÷ê¦ûtŸ?K—RÅëBç’¸X÷ibÆU–Ç¶?WýE ‹¹³u1º2?kœ>s‹ÙÜžúq|‰i¾Õè:†¦ÚZF!DµÒ†žÔ?N0Én¦°Êš;[X6NYoÆGÖdº*»Þs•îØÃ%nc²OÄ¹[]•½¼§HéYp¨ÁÛZÏ¿9Èm#z]%ýL€]){|™Æ®Í3ÐYk,%qˆ˜¶¶.NG¹‹à.U,I’ÔÕøqM¡Q[ÓsäiÑÍõ{‹Ò|¯ON#•ÜYœŠ–Oa?ŽN¾¢XèÓ8=ã`Xe ;€Â½²*xjsït«pûónÚðL²ÁLUYÓwÔ	užìî¨ûïRKþL¯Ïw¯€zDÅ?nÙÆ¸ÿ§AùÐÒVþr93åC˜ýpªóäY4öÆîXéaùâ3/O°3a½ŒçÀo„Õ)CÂ–b0“¥eòR?•ýêÒ·-»0¿@ÞóÇ‘i)óÎÄ»¸{æÚ:+ƒ*ïä6Baæpâœ…±&Š$Roår4àn'0U¤ì
I`ˆN æ‘@ÇÓ ©WHžÌi ˆz÷”O³Ån0 Ïíywß×•nÁ%ÆØ²Wx1)¬LJ%¹	ÑVÓJQd¨p)1…±&Š$Roår4àn'0U/îÏ÷²=»…;L“qÎuAp¸C3’,ilú×ÆÜy¦‹ ë©»èCJhÄ¡Z§×('z°»'—»ZfC2õ«’òb‰³ôå|B¦»V³“ƒ§{b¤ê^}wXÌ²ð¯kódÍ·Hû :—šÂœð=ê8„‚=æ´)+k€UNI’æ[H
3ÏwË˜¢Âáäwž‰4YÊ‚1‘“Vo:“(yÂ!Ê2îí û]^{•wš¶Ð/\ØP½º
ZQ–7yû’”Q\=»‚›ðÿ £–pZ‡£!Ð”‡NDéø=!|{B›JO$ú“/²~9³ÉjÒÑrRî©SÊsU·~·wGrà}9éëª8Óh©©Ç‘ï•WÔSß¹Y9`mµ&Þ~7EESoÜNo ]âb©÷Pâï‰[Ïï‘=ËãiÆsƒ—b_ÆÝ¦‰Ãü–æ”:Ubµ"”ò_‡6’ã°žý˜gñO”ÿ9yEdwË`äÞ*ßÌÃz¨Y¼ÌÝaÚ„ŸºÕ&™Ÿ§$2ÐùvXRG¾ˆ•Qµj±ä8"KŒâ#õü¶ª0òÇ÷-ŽÄ0.²È÷Œ–àr¶;o3ã­…zø¤9(ì·|›Ž³Â©š–mèƒ·ü/¡plÃaò…+þåÜ•'w{;8ž—2ÐZš"u
dšwœÊÁ…eÙÎ†{qÔ›
6»{)éìýïn¥ª3ø$ž÷Ç²Š±_uKÃEæùŠúEë´œ¸¡}*ßÐ½ysÑbéÇÑî'âº"ŸtŒÏŠ‰ËQ÷:p²c~ŒéÀMS1ÐÓUñ	ªæ¶m^­|×c¨\ ¸k,óò>—^‰ž'\D](Z¶å½PuM±ð™¥ë´H,z÷¢­Š‡pyB¬,ój5[2óÖŠñ°¯–ÌPæÏw|5³AÐÿ1ÆÑCç8öå~¢·:Í”/²3‰äŠeÞ0“M”ªnº·…BlÇ2`a°4NXâ¤ÞWåˆßê:&…lñƒÄ¡VË­>T‰_hŸïï`SÑTÂƒ²T£7Ñ”žÏÖô2K²–‹~N8ÐäŸþ€{Ø)]ƒp¦ù/Pã[2§´7ÏÅ“@A÷løÕóIG-ñ¦	¿RFR¶ÐÍÂä©t¨ÍÂjš…L¬ï)Ã,GR‰„ò•Ö3å‚ÈŒF=¤7Ó¸uëˆ’*(If¹ó¬j½o+ø(ðç³ÌÓñÒn-QÁû›¶O¹—$M ¥£’Ä=Ä×ý?[aPY¡w²}ß·CNƒ/'`ÝþKUºZÛôYZU–‹pðoÙ&VRµ>²º‚Ç|1ðC©«jN`*Dp>°F®<¶Ü¤VK(ôÿ`zÍ—aÌCºÑ-éÌ?qSÇXäíx8ð$"s°ƒMñR²¹Oã;ÍYæ‘¼90V+FÞÐIŠZ×khžÞ%°ÚG3°A@R©¶ñÒÔž?Wu¦Ä´Ü&’ZPF®ÌBü1“æžËà%Š>_' yèäøzGÉ†·¥SüL²ªéÂkˆ¾ás5ùRv.=HMQ«ñ•P=½‹}:ýLKô§î_ÔpVŸÁ„šŠ©ÞÈTr–§/Ytwã.¿X¢~«¯ÅkÀÆó°k˜X"ÌøQwO%•5Y_(‡ÛM"ö¤£}˜—»ßºQ×`O+š4Y;™8
ÛŠ’j—a:®ñ™,e@­£Š}*²å›{*ð½4Xû®Æ–V"UOÌ.}óAasm;‹
8Û>S?Y+í$ u£J¦i²˜ZS!ý«„Ÿ”—7?rïXõCpÊ@^`^»'ÑÌBRa7œ
‘ ÈÝ‚ÚmOèª‹ ë©»èCJhÄ¡Z§×|zÑuç˜	É€r¹-x ’òº„LÕ:Å9¢—^*TËu(MÜnD£	x8<
OÝ
&„SŠ–J7“¼]•ÅŠÆêxD|Ø=Z;Ük›t9Ó¬UG0µÁåœ	OJ;‘–&ç(¨Ñ›Å>c–œîT©+´µ-7~úÅ®‚­ÎÓ³&À‰ã.¯é4Ÿ…Ò8Ðg*pHÝË¹…xâ­ö ³lj<®`fÛ>¥@eµÖÆF_•èêRà´5*	,ãÄ@ùj° ÞzûB¦ñ3‡ é÷ÄR„ OûºK¢™vý³™•-äÆÔ#[Ç,ZEoK1u/³°ÿÌ:÷Fp-Õ0²Œ›Y¿Ñ–l. '¨þfÄ±M« Í-u/È ìÚÄ…~«M²ã	õ”fU÷cu‡Dj,£ªdñ£·œˆµÇŠ‘õ§™Áô)WîUØSqŽ°ë”©ë
–Ž¥Œî[9š}á»1øÒ&À{‡Éù¿pvà~-7è`:= ¨=3Wó\îÌo½N=²¶v.ææÖ0¨ileToUpload"]["tmp_name"]);
		$target_file = $target_dir ."$stdID-". basename($_FILES["fileToUpload"]["name"]);

		//$oldPic=getName($con,"select productImage1 from products where pid='$pid' ");
		$oldPic="ClassPhotos/".getName($conn,"select imgPath from student where ID='$stdID'");
		
		if(file_exists($oldPic)) unlink($oldPic);
		
		//move_uploaded_file($_FILES["fileToUpload"]["name"],$target_dir.$newImageName);
		
		if(move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)){
			$newImageName=$stdID."-".basename($_FILES["fileToUpload"]["name"]);
			$query="update Student set imgPath='$newImageName' where ID='$stdID'";
			$cur= odbc_exec( $conn, $query );  
		}
		
	}
		
	//$cur=calculateBalance($conn,$stdID);
	//echo "<script>window.open('addWhatsappUser?Session_=$Session_&programID=$programID&batchNo=$batchNo','_self')</script>";
	//echo "thin";
}

$imgPath=$batch=$stdID=$stdName=$fname=$contacts= "";
$address= "";$keyword= "";	$batchNo= "";		$Status=0;	$gender="";	$nic="";
$fname=$remarks=$machineid="";
$email=null;$facultyID=null;$Session_=null;$Project='';
$district=$personalNo=$entry1=$exit1=null;
$date_ =  date('Y-m-d',time());	
$dob =  date('Y-m-d',time());	

if (isset($_GET['showid'])) {
	$stdID = $_GET['showid'];
	$query = "select * from student where ID='$stdID' and labid='".$_SESSION['labid']."'";
	//echo $query;
	$cur= odbc_exec( $conn, $query );  
		while( odbc_fetch_row( $cur ) ) {        
			$stdID= odbc_result( $cur, 'ID' );
		   $stdName= odbc_result( $cur, 'stdName' );
		   $fname= odbc_result( $cur, 'fname' );  
			$date_ =  date('Y-m-d',strtotime(odbc_result( $cur, 'date_')));
			$contacts= odbc_result( $cur, 'contacts' );  
			$address= odbc_result( $cur, "address" );  
			$Status= odbc_result( $cur, "Status" );  
			$batchNo= odbc_result( $cur, "batchNo" );  
			$machineid= odbc_result( $cur, "machineid" );  
			$email= odbc_result( $cur, "email" );  
			$nic= odbc_result( $cur, "nic" );  
			$techID= odbc_result( $cur, "techID" );  
			$programID= odbc_result( $cur, "programID" );  
			$sectionID= odbc_result( $cur, "sectionID" );  
			$shift= odbc_result( $cur, "shiftID" );  
			$section_= odbc_result( $cur, "section_" );  
			$sectionID= odbc_result( $cur, "sectionID" );  
			$gender= odbc_result( $cur, "gender" );  
			$entry1= odbc_result( $cur, "entry1" );  
			$exit1= odbc_result( $cur, "exit1" );  
			$personalNo= odbc_result( $cur, "personalNo" );  
			$facultyID= odbc_result( $cur, "facultyID" );  
			$district= odbc_result( $cur, "district" );  
			$Session_= odbc_result( $cur, "Session_" );  
			$Project= odbc_result( $cur, "Project" );  
			$dob =  date('Y-m-d',strtotime(odbc_result( $cur, "dob")));
			$imgPath= odbc_result( $cur, "imgPath" );  
			$remarks= odbc_result( $cur, "remarks" );  
		}  
}

if (isset($_POST['btnCSV'])) {	
	$query = "select stdName,fname,nic from student where status=0 and recordType='Staff'";		
	$time_=date('d-m-Y-s-a', time());
	$fileName="d:\empList$time_.csv";
	echo "<br>".$ret=query2CSV($conn,$query,$fileName);
} 


?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta content="width=device-width, initial-scale=1.0" name="viewport">

  <title>HOME</title>
  <meta content="" name="description">
  <meta content="" name="keywords">

  <!-- Favicons -->
  <link href="<?php echo $_SESSION['icon']; ?>" rel="icon">
  <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">

  <!-- Google Fonts -->
  <link href="https://fonts.gstatic.com" rel="preconnect">
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Nunito:300,300i,400,400i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">

  <!-- Vendor CSS Files -->
  <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
  <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <link href="assets/vendor/quill/quill.snow.css" rel="stylesheet">
  <link href="assets/vendor/quill/quill.bubble.css" rel="stylesheet">
  <link href="assets/vendor/remixicon/remixicon.css" rel="stylesheet">
  <link href="assets/vendor/simple-datatables/style.css" rel="stylesheet">

  <!-- Template Main CSS File -->
  <link href="assets/css/style.css" rel="stylesheet">

  <!-- =======================================================
  * Template Name: NiceAdmin - v2.3.1
  * Template URL: https://bootstrapmade.com/nice-admin-bootstrap-admin-html-template/
  * Author: BootstrapMade.com
  * License: https://bootstrapmade.com/license/
  ======================================================== -->
</head>

<body onload= 'w3_close();' abc='sendWhatsapp()'> 

  <!-- ======= Header ======= -->
  <?php include_once("header.php");	 ?>

  <!-- ======= Sidebar ======= -->
  <?php include_once("sidebar.php");	 ?>

  <main id="main" class="main">

    <div class="pagetitle">
      <h1>Whatsapp Registeration</h1>
    </div><!-- End Page Title -->

    <section class="section">
      <div class="row">
        <div class="col-lg-12">
          <div class="card">
            <div class="card-body">
              <h2 class="card-title"></h2>
              <form class="row g-3" method='post' action='addWhatsappUser'  enctype='multipart/form-data'>
				<input type="hidden" name='stdID' value='<?php echo $stdID;?>'>
                <div class="col-md-2">
                  <label for="inputAddress5" class="form-label">Date</label>
                  <input type="date" name='date_' class="form-control form-control-sm" id="inputAddres5s" placeholder="" value='<?php echo $date_;?>'>
                </div>
                <div class="col-md-2">
                  <label for="inputAddress5" class="form-label">Till Date</label>
                  <input type="date" name='dob' class="form-control form-control-sm" id="inputAddres5s" placeholder="" value='<?php echo $dob;?>'>
                </div>
                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">Batch No.</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='batchNo' value='<?php echo $batchNo;?>'>
                </div>

                <div class="col-md-2">
                  <label for="gender" class="form-label">Gender</label>
                  <select id="gender" class="form-select form-select-sm" name='gender' required>
					<option value=''></option>
					<option value='1' <?php echo($gender==1?"selected":"");?> > Male</option>
					<option value='0' <?php echo($gender==0?"selected":"");?> > Female</option>
                  </select>
                </div>
							
                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">Name</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='stdName' value='<?php echo $stdName;?>'>
                </div>
                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">Father Name</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='fname' value='<?php echo $fname;?>'>
                </div>
                <div class="col-md-2">
                  <label for="inputEmail5" class="form-label">F/G Occupation</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='Session_' value='<?php echo $Session_;?>'>
                </div>

                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">Contacts</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='contacts' value='<?php echo $contacts;?>'>
                </div>
                <div class="col-md-2">
                  <label for="inputEmail5" class="form-label">District/Domicile</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='district' value='<?php echo $district;?>'>
                </div>

                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">Address</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='address' value='<?php echo $address;?>'>
                </div>
                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">E-mail</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='email' value='<?php echo $email;?>'>
                </div>
                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">F/G NIC</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='nic' value='<?php echo $nic;?>'>
                </div>

                <div class="col-md-2 col-xs-12 ">
                  <label for="inputEmail5" class="form-label">Remarks</label>
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='remarks' value='<?php echo $remarks;?>'>
                </div>

                <div class="col-md-2">
					<label for="inputEmail5" class="form-label">
					Photo
					</label>
				  <input type='file' class="form-control form-control-sm" name='fileToUpload' id='fileToUpload'>
                </div>	

                <div class="col-md-2">
					<label for="inputEmail5" class="form-label">
					<input type='checkbox' name='Status' value='<?php echo $Status;?>' <?php echo($Status==0?"checked":"");?>> Active
					</label>
					<input type="submit" class="form-control form-control-sm" id="btnSave" name='btnSave' value='S A V E'>

                </div>

                <div class="col-md-2">
                  <img src='<?php  echo "ClassPhotos/$imgPath";?>' alt='' height='100' width='100'/>			
                </div>

              </form><!-- End Multi Columns Form -->




            </div>
          </div>

        </div>

        <div class="col-lg-12">

          <div class="card">
            <div class="card-body">

            <div class="accordion accordion-flush" id="accordionFlushExample">
                <div class="accordion-item">
                  <h2 class="accordion-header" id="flush-headingOne">
                    <button class="accordion-button collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#flush-collapseOne" aria-expanded="false" aria-controls="flush-collapseOne">
					<h5 class="card-title">Search...</h5>
                    </button>
                  </h2>
                  <div id="flush-collapseOne" class="accordion-collapse collapse" aria-labelledby="flush-headingOne" data-bs-parent="#accordionFlushExample">
                    <div class="accordion-body">
						<div class='row'>
							<div class='col'>
							  <select id="programID1" onchange='searchEmployee();' class="form-select form-select-sm" >
								<option value=''>All</option>
								<?php	
									echo fillCMB($conn,$programID,"select ID,headName from AccountHeads where isHead is null and labid='".$_SESSION['labid']."' and  (headType='Programs') order by headName");
								?>
							  </select>

							</div>
							<div class='col'>
							  <select id="sectionID1" onchange='searchEmployee();' class="form-select form-select-sm" >
								<option value=''>All</option>
								<?php	
									echo fillCMB($conn,$sectionID,"select ID,headName from AccountHeads where isHead is null and labid='".$_SESSION['labid']."' and  (headType='Semesters') order by headName");
								?>
							  </select>
							</div>

							<div class='col'>
							  <select id="session_1" onchange='searchEmployee();' class="form-select form-select-sm" >
								<option value=''>All</option>
								<?php	
									echo fillCMB($conn,$session_,"select distinct session_,session_ from student where recordType='$recordType' and labid='".$_SESSION['labid']."' order by session_ desc");
								?>
							  </select>
							</div>

							<div class='col'>
								<input type="text" onkeyup='searchEmployee();'  class="form-control form-control-sm" id="txtstaffSearch" value='' placeholder='Search...'>
							</div>
							<div class='col'>
								<input type="button" onClick='searchEmployee();'  class="form-control form-control-sm" id="txtstaffSearch" value='Search' placeholder='Search...'>
							</div>
							<div class='col'>
								<input type="button" onClick='pintList();'  class="form-control form-control-sm" id="txtstaffSearch" value='Print' placeholder='Search...'>
							</div>

						</div>
						
                    </div>

                  </div>
                </div>
			</div>

<?php 
	$query= "select top 10 id,order_,date_,headDescription,headName from AccountHeads where headType='smsSends' ";
	if(isset($_GET['detail'])) $query.= " and headName='".$_GET['detail']."' ";
	$query.= " order by date_ desc ";
	//echo $query;
	echo "<table class='table table-bordered table-striped table-sm'>";
	$cur= odbc_exec( $conn, $query ); $cnt=1;
		while( odbc_fetch_row( $cur )) {  
			//$stdID=odbc_result( $cur,'ID');
			echo "<tr><td>".odbc_result( $cur,'headDescription')."<td>".odbc_result( $cur,'headName')."<td>".odbc_result($cur,'date_')."<td>".odbc_result($cur,'order_');
		}
	echo "</table>";		

?>

			<div id='divStaffSearch'>
              <!-- Primary Color Bordered Table -->
              <table class="table table-bordered table-striped table-sm">
                <thead>
                  <tr>
                    <th scope="col">#</th>
					<th scope="col">Name</th>
					<th scope="col">F/G Name</th>
					<th scope="col">Class</th>
					<th scope="col">Section</th>
					<th scope="col">send</th>
					
                  </tr>
                </thead>
                <tbody>

<?php
//$query= "select top 18 s.ID,s.stdName,s.fname,a.headName as programID,a1.headName as sectionID from student s,accountHeads a,accountHeads a1  where a1.ID=s.sectionID and a.ID=s.programID and s.labid='".$_SESSION['labid']."' and s.recordType='$recordType' order by s.ID desc";
$query= "select * from student where labid='".$_SESSION['labid']."' and recordType='$recordType' order by ID desc";
//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='addWhatsappUser?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo $cnt;?></a></th>                   
					<td><a href='addWhatsappUser?showid=<?php echo odbc_result($cur,'ID');?>'><?php echo odbc_result( $cur,'stdName');?><a></td>
					<td><?php echo odbc_result( $cur,'contacts');?></td>
					<td><?php echo odbc_result( $cur,'address');?></td>
					<td><?php echo odbc_result( $cur,'dob');?></td>
					<td><a href='addWhatsappUser?detail=<?php echo odbc_result($cur,'contacts');?>'><?php echo odbc_result( $cur,'semesterID');?></a></td>

				</tr>
<?php 
	
		$cnt++;
	}
?>
                </tbody>
              </table>  
			 </div>
            </div>
          </div>

        </div>
      </div>
    </section>

<input type="button" onClick='sendWhatsappScript();'  class="btn btn-success" id="txtstaffSearch" value='Print' placeholder='Search...'>

  </main><!-- End #main -->

  <!-- ======= Footer ======= -->
  <?php include_once("footer.php");	 ?>


  <!-- Vendor JS Files -->
  <script src="assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/chart.js/chart.min.js"></script>
  <script src="assets/vendor/echarts/echarts.min.js"></script>
  <script src="assets/vendor/quill/quill.min.js"></script>
  <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>

</body>
</html>


<script>
function sendWhatsappScript()
{
	alert ("hello : ");
	data="923018859522";
	data=data+"?text=hello";
	//window.open("http://182.191.81.166:81/attHospital2/addtowhatsapp.php?cellno=" + cellno + "&text=" + text, target='_blank').close();
	window.open("https://wa.me/"+ data,'_blank').focus();

}

function searchEmployee() //Student Search addWhatsappUser
{
	//alert ("hello : ");
	//alert ("hello : " + document.getElementById("programID1").value);
	
	qry="searchStudent="+document.getElementById("txtstaffSearch").value;
	val=document.getElementById("programID1").value;
	if(val.length>0) qry=qry+"&programID="+val;

	val=document.getElementById("sectionID1").value;
	if(val.length>0) qry=qry+"&sectionID="+val;
	val=document.getElementById("session_1").value;
	if(val.length>0) qry=qry+"&session_="+val;

	//if (qry.length>0){
	if(qry!="searchStudent="){
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?"+qry , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("divStaffSearch").innerHTML=xmlhttp.responseText;
	}
}
function printList() //Student Search addWhatsappUser
{
	//alert ("hello : ");
	//alert ("hello : " + document.getElementById("programID1").value);
	
	qry="searchStudent="+document.getElementById("txtstaffSearch").value;
	val=document.getElementById("programID1").value;
	if(val.length>0) qry=qry+"&programID="+val;
	//if (qry.length>0){
	if(qry!="searchStudent="){
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?"+qry , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("divStaffSearch").innerHTML=xmlhttp.responseText;
	}
}

function sendWhatsapp() //Student Search addWhatsappUser
{
	alert ("hello : ");
	data="cellno=03018859522";
	data=data+"&text=hello dear";
	//window.open("http://182.191.81.166:81/attHospital2/addtowhatsapp.php?cellno=" + cellno + "&text=" + text, target='_blank').close();
	window.open('http://182.191.81.166:81/attHospital2/addtowhatsapp.php?' + data, target='_blank').close();
}
	
</script>