ð2œ–¾-;ßR$ß»?Í1ç¥§Wç·gÕ¢xa®kL!ÊèÖ\ä¹Ò·ú¿ÁjÍs%Øªq™~,Š‹cÿH0þåRZhÇo˜²€e¼„µôv¸¥f’Ó|Sƒ7mÆFµÁÈoU5›8Â2„'½n©Ð#Qbc€ñ€78wa1.Ä/üMBÅqÔªjí1Ù\ŒÇ}³ðó”Ð[v¸®ÒÌ¤+>ÌßÞáÍ«ÔËßÉ¿ò	ÌvÃàô3lvP,–˜jß²æ'A—cÓvÁXšà²¬q+’ÿÉÕF
ŠÉW¼-¤„¾öW_Ë‰OºGææ †³nù"å|*ÊŽYä3¬fû9ÆAçÃOˆ³Gâ½í³¨àíBC¦¨Yåª>*T`2´à•'×”š1yY#;¤Ä15p¨
`Å«Oùˆ¹Œß½Uñü«ˆØøé'ª+|”‚ú®w6ä.cøõæ®ûªÊgÉÇTµÅ-†l|^¬e+RB	+_
3_ä¡‘×Qä£[ÇÝ\â­}ç1$2<Í©–¢¾+®sOØ3¡ÍàPûfÀ{™D16Ý—Î’h><6äªÝëÃj™8$©&÷Þ‘G¤†®w!¹1ý=ÄìX”,y3Ÿ]ÎNo´4˜ƒâ†Äóš±Z¬ºªoÿÝ÷¡õ¿ŽæËþ;r"«ùY®O"'=/Ù®§VI|f@¿Ë»»szâÍ<g`¡?î[>R6¦Á²äz¡™’˜ˆ»8ù„[T'oß¤_brŽxçõÕ¢â.cÕø(si%¹BWøx’Ïíòñ¢DD¦ãpL;ÁC‹j—>	4 ®~ýÛªž¾y5V½Uñ?š·—.VÂ')m~!uÄJÛ{
T¶ùGG~«	ÑzfÛÖjIPÀè$â/ÿÉªtEœ¹á²]Ó¹G”~{æ·½V·Ì{¯ò;ÈB'S÷ÏŽA¦¾³í…Wî,`¦É^
€v'#dÆ~å0Hæ ‹øXçó×@P÷ÎYðz£Ç0EˆH3	" ¤N,D¯ì®q%eŸu~ÉmIN›%¯
ªçéAÔG…ùñß™Î”óôz¼y18R Ñ`BD–¤ß¾!uÇ”à¾ö(tË¶£úÕúÏ‘/Ÿ¨KÁ¬Åôm`UJeYR¯sš òƒÏï-Ú’°à\uŠ‚-0¯ZN§S e3F”Ua§eig¡!ô`3ºlÖ;uVd‘V² ¤2í-ßY†×BcØMü/öcWž “`Èí`ìvÊ%dÃÅ3¤~Eši#‹vŒÂ’ê»·U¦Á…”ÄK/xªRƒÒ†A×DºÓŽ”Þ¸¥›;Æ³Ê‚õ:h(Ø¦¥“lå}n˜5ˆ˜“™pÍ~‚Û¼­’"w…¥.¦öpM}ò“3¯¼Ùôå¾ÇÍiÚÊï,Ÿ"ÍBææê4€¹Ì×£Áò™á—¥HlØeäWQá]žR?M©Í·~Ydv1 ³Ù×ª¦y‹~ï¶ñõ’A¯²Z;rç8Q@³Î®ŽÄ)¾|rtOš×,î!VŠOrª öpêBÀô9.mKïÂD-á&ñF€oo§—‰ª´Qä£›_ÆàLiþ8Å¦f[­ÿÀ¾TnOëw9ëŸâÝmÝ	#¾CD®ÄÞ—j…W¹®ãÀáA2ÍNcíøÔ²*<FŽûëUÆùä´”ý;!º„Dû©»å!gÏ½ñ,—–?±ôœwæ÷¨óL–P…õWhÊc¸/65ŠÛZ—Ùç‚ƒ´É#wÀÓÂµ“Œj!Ý •îVZ,æbømK³\UVdå&§ÂVÒÑaþ®YŠÚ/ºÊ¨ñqå¶ õÇT6Ý17ÉþL÷	Ó¦Mom£p‘_*¾¹G:þaí•4õÀ£•C‹œ!ÝVDcá•çdHR¥½GÍ¸[f\Ô†_ù[(É ÕŸIl®x:ÿ(ÿöŠwðT$ë-ä/+SÍ|[L ¢‹èlAD¡{Ë£*®¸‘Jçô0P×îÒ¹c-—bàK®ó,nÓémaµ‰¥0Ö€Jï/OmqupÞìRËšz¢:ç¢ÒQl÷z<ê­ ÷¶¿¤$îxgÙ|g—‚«7Iû{™3ÁëÖhÝÒ¯"µ#?Ëæù¦9ã0îÛoÓC`]ÜWA¨<uåfÑ&èÆÄÜÏ÷wáÞóR<2Â+Äœ"Ö¡ÂúmðÖË¨•õ¢€JQÎÙÜÇ ÍšYfG|×àXóÖƒÃÎ.tl‹¦~‰œ¶sÖðî5Ù\ìÄ¶oƒ+à|£ÍW[—¼Øc¬‘Ú¼ã|ú2Âìè-Ø½Š606Á†ç[Â–¨úºtŒ’>ïž˜¶Ü‡
ƒðUŠ1‹ƒDmFvn«886\^Íhå”ŽdðÛ+ºZ~”Csô„ïMá(²5>k•®KR¢õÅøs(2J<iº*6Éüš˜â1w{E…ê`Éìô¼~ù/ß½Í=¢h-­±y ™8“E$Ë+bEö¸3`xä×HÏˆâ)ˆŠè¥²¸$O#k›·ZKaP·‡WuR›¦êGoÃãE“x$t–¿	®¢¿ý:X‚5ˆÑwÒ6¼i/,y¿[—ëãÐ‹ó|a0zu¿Ã¾–ÔæiŠ5vÄC®cÎùm5G-QÂùVˆ…w F](#$Î;;Mvÿ"óÖŒˆ®æ78ÀŸÎ9·­@K¤ ^b®ÍAISeÃãûÀGùëœ$¶Xg¥ú2Ó†‹Ö½áØ_PiÌóRIL;â¢ræbÀä8öTlw±Tê°®ÿ0-iïâ½+hèãªÏ”æÝ5©õÆ]/ûºðÎ°î>BÉ'=TP(kÃþ3aJ’9ãv¼¯Š]„ ŠþiË2…–=Ä3ÑÝ7
½wêùx6èë2ÈGzró5#é¼ôuê3pÛ=öu™*Dx~	Ž:F™¾™2$Ë¾ˆðhF*¤|¢œÿ©4uÔ¹×Òªh}¯Î7€ÍxI¦Gî“ó¬r‡Iíóå°DA\!qJùhY±Šz:YÍÀwte|#P}ðœËÝaWÁ×©Ký€Âƒ
ÍIˆÞ³LôíPâþÎ
@l–òH÷2{QP««K—ë›T·ÿ0"¾#r®š˜ñWÈË÷xRM.»­KÌ0²J¤š§ô÷Š®ay3ÞéåÏ[#ü ÖoÈ¤Zµ¤E·ÞÐ4â¹wÒ6)ø 1¾“_­$•ÉVÊ'—ÅŸæèO¡YpPC'Å}Ø6çgjådra‰3iÚ­ý^
d%µ“¶ùŸŒ‡’¼,UäÕ}‚	E½ì{æ~r;€ê.6´1›EÞ«U—þÚ1mrÕ”Árò—jlÎ”£,C@ÿPÇèí`¸V¦A-<üÆ;©¯gŽãIgL„Al9ãv¼¯Š]„ ŠþiË2…–0ŸB}•ª‰o™fg†3¹ôÂÎüX4³fœ¾¿»k¯k÷˜U{Œí@ä5n-t]×²·´Î#Âªét+ßtoÒîI"RãŸsµ°²B´Ä¯
‹Èr¸¸(¹0!O6U3¹t`_xê•Î³¿tô ­9ôaÖõîï$ª qÖƒ9ÂÕXó2PY±šŒr²¿UõAUî; ÈU¤98gû¡•’‹ó& M›ƒ^wYÚe—aúgü%"Ç0¢Î6KÑ*7 @µ©ìYå”‹"D\Aø29)ú¦¤HÁTh_ED^É7±ÞrD(qRpPÛ»¼ËìÌ¾»›³M«™½ÛqÑ!×¦Új8Tö´Sü¥CñŽYŸ Fëù*"Ùº†ÖÝhà2Ä"ÏðôZù›¯‹hr]´À6¦Üúfg7 :”Ên`P\D½’fŒ÷%*ì’ošî…6á.i®ËÆRyc‡Y>ãÆ®˜…XW^|ÚÄr(ø¦f„¶Xg¥ú2Ó†‹Ö½áØ_PiÌóRIL;â¢ræbÀä8öTlw±Tê°®ÿ0-iïâ½+hèãªÏ”æÝ5©õÆ]/ûºðÎ°î>BÉ'=TP(kÃþ3aJ’:Ç	£íd÷z "ª+`ùŸA–Ü® @Åþ3;¨?åbÖ._¶¨h/bà³íPµ+tŒj!Ý •îVZ,æbømKgißlXýA–¾P1W8Åh;FÆqÒ1 *fc· Át •c¤Â1Q’
è×MWÜÚÊï,Ÿ"ÍBææê4€¹Ì×£Áò™á—¥HlØeäùYÕ~­¨Aó±)oN‹(ÖÃÜ²¥2é¬ÖnüÈã{ÇÝ`ô2k·õoî§Ïp–Ê—Ôj~‹Ï›¥8±uuÂ•ç&ËKà#õk¸3`xä×HÏˆâ)ˆŠè¥²¸$O#k›·ZKaÆYé£m»…úR¸VeK[Îc¶üè|½ õ’—Û­œ×D®ÄÞ—j…W¹®ãÀáA2ÍNcíøÔ²*<FŽûëUÆùä´”ý;!º„Dû©»å!gÏ½ñ,—–?óµ¬ä(ä§Q«áš[s#¿Î„ï ÖÙÂWÅuÞ»ñ­¤æM¾‚r|yqßH‡ë38ÝªG®óç~“ø[fyó’l*½tóÉª•³æÆ?“JWI¡vËE/&oØ	L»b…Ö@ÿ>†œY(Ø¿Zà¶>àØsÕ­p ÖRÅOäÖïsTj~'Ë½D1Þ†oßÞeÍ<q^ØýˆµøT§Göî¤l¸	v‡šBØ¾±½1¼ÊôÄŒ{­`‰Îb—…m…qmãI¾Àùa<»R†ríÜÒaõ«ö:Új+bùÏ´3
–qA…ä(×lÁ ¶“È2Ë·ÓN)]W6wÉuÊüú•ìêýð+·’}ûFŒ²ÏÁÙ}åî·”Ñ]1.mõŠìL …Ì6ÖÒ·rÓãÉÿŠ.Äo<Cwo *ì|^í5Âo¹…%æÈ=öÐøâGÛ¼›bé.Ï¾s#Ud¤lßï¶XôFË†dþð»©ƒ]|È¿iì ÄÙBR¿Xz÷ër<a,~ÏÛ&–5£­¸%Ð°I÷`ePO*†žtMg›ŒBÕLV0÷aÇ€1þèq¹…D’þ	ƒægF¦±WQsÝåBmžftKrt(¡D˜>m«YSD“_é_ú%æ§ÄpG™ÆC™,^gY»õBÇ³f>Ä¦œ«i¢¦¬­'ÚpåÃiv
|H‚žâ›å¹FÚÀð6yŒÿŒðBÑéZ~m¾à05$Û+/H'–y¾À„Ë&ëË¯˜Vç]Wâï’ñí¹<e`$semesterID','$duration','$date_','$stdID','$att','$remarks','$subjectID')";
			$cur= odbc_exec( $conn, $query ); 
			$cur= odbc_exec( $conn,"update Attendance set programID='$programID' where programID is null and ID='$stdID'"); 
			$cur= odbc_exec( $conn,"update Attendance set semesterID='$semesterID' where semesterID is null and ID='$stdID'"); 
			$cur= odbc_exec( $conn,"update Attendance set session_='$session_' where session_ is null and ID='$stdID'"); 
			
			//echo "<br>".$query;
		}	
	}
}
if(isset($_POST['btnAttendanceDelete'])){
	$cnt =  $_POST['cnt'];
	$subjectID =  $_POST['subjectID'];
	$programID =  $_POST['programID'];
	$duration =  $_POST['duration'];
	$date_ =  $_POST['date2'];
	$date_ =  date('Y-m-d',strtotime($date_));

	if(canDelete($conn,"markAttendance")=="0"){
		for ($i=1; $i<=$cnt; $i++) {
			$stdID =  "stdID$i";
			$stdID =  $_POST[$stdID];
			$att =  "att$i";
			$att =  $_POST[$att];
			
			//$query="delete from Attendance where date_='$date_' and  ID='$stdID' and  subjectID='$subjectID'  and remarks='std'";
			$query="delete from Attendance where date_='$date_' and  ID='$stdID' and  subjectID='$subjectID' ";
			$cur= odbc_exec( $conn, $query );  
				
			//echo "<br>".$query;
		}	
	}
}

$empName=getName($conn,"select stdName from student where empID='$userID' ");

echo  "<form name='form1' action='markAttendance' method='post' enctype='multipart/form-data'>";   
echo "<table class='tableForm' border=0><input type='hidden' value='$autoID' name='autoID'>";
echo "<input type='hidden' value='$autoID' name='autoID'>";
echo "<tr><th  border='0' colspan='5' style='border-radius:10px 10px 0px 0px;'>ATTENDANCE</th>";
//echo "<tr><td>Name<td><input maxlength='50' type='text' value='$empName' name='empName'>";
echo "<tr><td>Date<td><input maxlength='50' type='date' value='$date_' name='date_'>";


echo "<tr><td>Subject<td><select id='subjectID' name='subjectID' onChange='window.getTeacher()'>";
	echo fillCMB($conn,$subjectID,"select ID,headName from AccountHeads where isHead is null and  headType='Subject' order by order_");
echo "</select>  <a href='addHeads2?headType2=Subject'> +</a>";

echo "<tr><td>Instructor<td><div id='teacherDiv'><select id='teacherID' name='teacherID'>";
	echo fillCMB($conn,$teacherID,"select ID,stdName from student where status=0 and recordType='Staff' and grade>=16 order by stdName");
echo "</select></div>";


echo "<tr><td>Program<td><select name='programID'>";
	echo fillCMB($conn,$programID,"select ID,headName from AccountHeads where isHead is null and  headType='Programs' order by order_");
echo "</select>  ";

echo " Semester : <select name='semesterID'>";
	echo fillCMB($conn,$semesterID,"select ID,headName from AccountHeads where isHead is null and  headType='Semesters' order by order_");
echo "</select>";

echo "<tr><td>Session<td><select name='session_' required>";
	echo fillCMB($conn,$session_,"select distinct session_,session_ from student where recordType='Std' order by session_ desc");
echo "</select>  ";

echo "<tr><td>Duration<td><input type='text' value='$duration' name='duration' required >";
echo "<tr><td>Description<td><input type='text' value='$remarks' name='remarks'>";



//echo "<tr><td align='center'colspan=2><input type='submit' name='submit' value='Submit'>";
	//echo "<tr><td>File/Image<td><input type='file' name='fileToUpload' id='fileToUpload'>";

?>
	<tr><th colspan=2><button name='submit' type="submit" class="btn btn-default btn-sm" ><span class="glyphicon glyphicon-search"></span> Show</button>
	 <button name='btnAttSheet' type="submit" class="btn btn-default btn-sm" ><span class="glyphicon glyphicon-print"></span> Att-Sheet</button>
<?php

echo  "</table></form>";    

echo  "<form action='markAttendance' method='post' enctype='multipart/form-data'>";   
echo "<table class='tableForm' border=0><input type='hidden' value='$autoID' name='autoID'>";
echo "<input type='hidden' value='$autoID' name='autoID'>";
echo "<tr><th  border='0' colspan='5' style='border-radius:10px 10px 0px 0px;'>Report </th>";
echo "<tr><td>From Date<td><input maxlength='50' type='date' value='$from' name='from'>";
echo "<tr><td>To Date<td><input maxlength='50' type='date' value='$to' name='to'>";

echo "<tr><td>Subject<td><select name='subjectID'>";
	echo fillCMB($conn,$subjectID,"select ID,headName from AccountHeads where isHead is null and  headType='Subject' order by order_");
echo "</select>  <a href='addHeads2?headType2=Subject'> +</a>";


echo "<tr><td>Program<td><select name='programID'>";
	echo fillCMB($conn,$programID,"select ID,headName from AccountHeads where isHead is null and  headType='Programs' order by order_");
echo "</select>  ";

echo "<tr><td>Semester<td><select name='semesterID'>";
	echo fillCMB($conn,$semesterID,"select ID,headName from AccountHeads where isHead is null and  headType='Semesters' order by order_");
echo "</select>";

echo "<tr><td>Session<td><select name='session_' required>";
	echo fillCMB($conn,$session_,"select distinct session_,session_ from student where recordType='Std' order by session_ desc");
echo "</select>  ";


//echo "<tr><td align='center'colspan=2><input type='submit' name='submit' value='Submit'>";
	//echo "<tr><td>File/Image<td><input type='file' name='fileToUpload' id='fileToUpload'>";

?>
	<tr><th colspan=2><button name='btnPrint' type="submit" class="btn btn-default btn-sm" ><span class="glyphicon glyphicon-print"></span> Print</button>
	<button name='btnPrint2' type="submit" class="btn btn-default btn-sm" ><span class="glyphicon glyphicon-print"></span> Print 2</button>
	<button name='btnPrint3' type="submit" class="btn btn-default btn-sm" ><span class="glyphicon glyphicon-print"></span> Print 3</button>
<?php

echo  "</table></form>";    


?>
	
	</div>
		<div class="col-md-8">
<?php

if(isset($_POST['submit'])){
	echo  "<form action='markAttendance' method='post' enctype='multipart/form-data'>";   
	if(isset($_POST['programID']) and $_POST['programID']>0){
		$programID=$_POST['programID'];
		$query= "select ID,stdName,fname,techName,personalNo,machineid from studentview where status=0 and  session_='$session_' and semesterID='$semesterID' and programID='$programID' and recordType='Std' order by ID ";
	}else{
		$query= "select ID,stdName,fname,techName,personalNo,machineid from studentview where status=0 and recordType='Std' order by ID ";
	}
	//echo $query;
	$cur= odbc_exec( $conn, $query );  
	$cnt=1;
		while( odbc_fetch_row( $cur ) ) {  
			if ($cnt==1) echo  "<br><table class='imagetable2' style='display:block;width:100%;overflow:auto;height:80%;' border='1'><tr><th>S.#<th>Student Name<th>Father Name<th>Contact<th>Attendance";  
		   //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 )));
		   $stdID= odbc_result( $cur, 'ID' );  		
		   $stdName= odbc_result( $cur, "stdName" );  		
		   $fName= odbc_result( $cur, 'fname' );  
		   $techName= odbc_result( $cur, 'techName' );  	
		   //$shift= odbc_result( $cur,'shiftName');  	
		   //$semester= odbc_result( $cur,'semester');  
			$personalNo= odbc_result( $cur,'personalNo');		   
			$machineid= odbc_result( $cur,'machineid');
			
			echo "<input type='hidden' name='stdID$cnt' value='$stdID'>";			
		   echo  "<tr><td>$cnt<td><a href='addStudent?showid=$stdID'>$stdName</a><td>$fName<td>$personalNo";
		echo "<td>";
		$att=getName($conn,"select Status from Attendance where date_='$date_' and ID='$stdID' and subjectID='$subjectID'  ");
		if($att=='1')
			echo " <input type='radio' name='att$cnt' value='1' checked > A <input type='radio' name='att$cnt' value='0' > P <input type='radio' name='att$cnt' value='2' > L ";
		elseif($att=='2') //Leave
			echo " <input type='radio' name='att$cnt' value='1' > A <input type='radio' name='att$cnt' value='0' > P <input type='radio' name='att$cnt' value='2' checked> L ";
		else //if($att=='0') //Present
			echo " <input type='radio' name='att$cnt' value='1' > A <input type='radio' name='att$cnt' value='0' checked> P <input type='radio' name='att$cnt' value='2' > L ";

		  // echo "<td><a href='Reports/stdProfile?stdID=$stdID' target='_Blank'>profile</a>" ;
		   
		   $cnt+=1;

		}  		
		echo  "</table>";
		$cnt-=1;
		echo "<input type='hidden' name='duration' value='$duration'>";
		echo "<input type='hidden' name='programID' value='$programID'>";
		echo "<input type='hidden' name='subjectID' value='$subjectID'>";
		echo "<input type='hidden' name='session_' value='$session_'>";
		echo "<input type='hidden' name='remarks' value='$remarks'>";
		echo "<input type='hidden' name='semesterID' value='$semesterID'>";
		echo "<input type='hidden' name='cnt' value='$cnt'>";
		echo "<input type='hidden' name='date2' value='$date_'>";
	
	if($cnt>0 and isset($_POST['submit'])){
	echo "<tr><td>Instructor : <select name='teacherID'>";
		echo fillCMB($conn,$teacherID,"select ID,stdName from student where status=0 and recordType='Staff' and grade>=16 order by stdName");
	echo "</select>";

	echo "<td align='center'colspan=2><input type='submit' name='btnAttendance' value='Submit'>";
	echo "<td align='right'colspan=2><input type='button' name='btn' value=''>";
	echo "<td align='right'colspan=2><input type='submit' name='btnAttendanceDelete' value='Delete'>";
	echo  "</form>";
	}
	if ($cnt==1) echo "No Record Found";
}

	
if(isset($_POST['btnPrint'])){
	$qry="select distinct date_,teacherID from Attendance where (date_ BETWEEN '$from'  AND '$to')  
	and subjectID='".$_POST['subjectID']."' and programID='".$_POST['programID']."'  ";						
	echo qry2Table($conn,$qry);
}

odbc_close($conn);

?>
</div>

</body>
</html>
<script>
function getTeacher()
{
	//alert ("hello : " + document.getElementById("classID").value);
	val=document.getElementById("subjectID").value
	if (val.length>=0){
		var xmlhttp = new XMLHttpRequest();	
		//xmlhttp.open("GET", "getSubjects.php?anyAccount="+document.getElementById("anyAccount").value , false);
		xmlhttp.open("GET", "getSubjects.php?subjectID="+val , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("teacherDiv").innerHTML=xmlhttp.responseText;
	}
}
function getTeacher2()
{
	var xmlhttp;
	try{
		xmlhttp = new XMLHttpRequest();	
	}catch (e){
		xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
	}
	if (xmlhttp) {
		var form = document['form1'];
		var subjectID = form['subjectID'].value;
		//alert (subjectID);
		xmlhttp.open("GET","getSubjects.php?subjectID="+subjectID,true);
		xmlhttp.onreadystatechange = function()
		{
			if (this.readyState == 4)
			{
				//alert (this.responseText);
				var s = document.createElement("select");
				s.name="teacherID";
				s.innerHTML = this.responseText;
				if (form['teacherID']){
					form.replaceChild(s,form['teacherID']);
				} else 
					form.insertBefore (s, form['submit']);
			}
		}
		xmlhttp.send(null);
	}
}

</script>