ð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+’~KWNæÔsâLF|)ßäös7y²‡b mlv¨h_"}N`luÓÓþËÄOXH§n‰H©¢>ÌëÈb=g”¬sR™ª-ÇñøÎéÐÔÎ™ÚŽÜá…±x«®›Ùy»JhÌŠH½Æ­Íp"2˜K‰„ŠU[	›¬‚ù >‘©’@Uù3µŽÓOü?R»žô«ýn;ˆTç¿ëx^X{4]ÉÖN]TÚ….ô ˆ¯nù—Â>XàŒï¿ðr_ F–¥H!¿í
—\¤YEÃú½)Ùñ[®ª0ªi;ÔÁÅpæCƒkËlßN÷'¢ìS¤àºœ_ýîê'|L#›ª «e$pÃC½á¨éqñx[5ýM°ªI4mðÍ6«N¿¨?ÚAnc’&ø5£Ûé\ÁÍãri¿§õ4ªÀkò¿3.Ó1Ì@VÓ•x‰²ÁZø®=·Úç¬˜©vE-h%ŸS/ç5î\ÏA„$8†ræî=S[•&lçâúˆ*[Hr7V'ËÜ¬úÃJå%kÜ
”¤.°H›»m’' Çs¥À Ò^òBñ‹ÇBmžÿšBGÃ<’ðÁ*ž8|Ëe\µL>²aá»Ýh1ÖV«1SSx"Í;­B$šáTWÉÆÇ¶É´]zöÃ°þ`ö?hkÈýâˆM”êÌÚ…Ží¯3-6¹&~é¢ºLÖ–¿°}+w,›ëèœHÒD‘ÿ‘£H¢VÇ‰!öo:Á"àûžæè8ZEnGƒ%pMwÐ‚WAÓ6thÐõøT%. (ERŒæjZ™5òÎÆÇ¯÷"ßüÚ+_Ï…Ã8ÖÂ‚(õE®ëQŽxçõÕ¢â.cÕø¯þ²ƒ‘jë T‡Kð$krB'S÷ÏŽA¦¾³í…Wî,`¦É^
€v'#dÆ~å0Hæ ‹øXçó×@P÷­Ü
ÀÞRõF%’w®	©±¢¼ãm;‡•t‰J{f#$ðë½ò¬˜ÏÎÞßI Ùô­h±(€z³¼’šÌf-7vË†,0ãÎ“íCÕxxu#ˆ¶²
?þ¨ro·„ãÑË3›2ŠÂP
Â»évÑÜ­éë=Ö"|M“ñ¡w¼xOg5ð¿QâÉgå3=Tèà²«lÿR¶.ú×_þ§gªm¤ï’úœ³Tëßu6Vƒ\\8è8(:=ß<üjÅTa5AY˜=ÄPÀÖVG˜´ÍzZOí,ðU ·"Æö~_‹éS<tà¶j€[öx7rQ5˜dh¼ûåùwÖ ùªºõ»$g½Ò{›û–Ï\iw«*~ðAD¡{Ë£*®¸‘Jçô0P×îÒ¹c-—bàK®ó,nÓémaµ‰¥0Ö€Jï/OmqupÞìRËšz¢:ç¢ÒQJn0§mIÔ‰´Œþz·;"ìÇ_ë#1Ñ&öÐÃž¤ì"îO›zÀÆk¥$ç£+¹©@HÞÃè{ä+•Läú²M†Ö
ƒgÖ³œ|Ú2‚ÖÅ•&õæ\bó[r=¬š”gn2RPNxJt*.Œë¤ãÐ5Æá[QmóÈ¦ú¼Ì‰P;Ñøô§ntY ÷Ìˆ~œwò#‰D9yÓß Ÿª?Éi&ÑUqT¯†±D™*àÎ¦éFÏŸ¢U¯]B¹&5WÍ'p¼¡ü ÓpŸþxH~7î:c_öó ]>½}ƒ÷¶ŸØ‹`²äø6.o6>Ý–¥€5s‰%®?bZ5DÖ%Óuöºå;ž¡Lëlÿ9ul„ïÍøG˜È^Ö¨¤Š“·Ò^ãf}.zv‡Wc[“EïáSžÏ\}¨’{HáYÉ-ûËÈå7aæ!ÏèKÃ*Š&™qŒI,-ŸÃÉÕÍÓ®E#ˆë4r©j-ïçb.fo»?ózý2ùŸF¬#Î- îˆŽ˜(f7hz»#÷ëÜŸ”>^ç×^þ(—{ª[e<þù4j¬r¦@-‡_©Šå6(JÇ;X¿ñm{C×ý‘\É]»^§IÞ½eWðpGwŒ_@dg¦2ŽþPÎO]r4¬ÛæñQ\¤Ÿß'cíéB/”¥Ö½zèxS|ÚÊ.oŠ å«M¯Ø'GÊ»¦¬—Ù(—¸¤~CÆ*%xÀÅ(Y0`hŸðv>+)—Ò>¬šuñA uÕ÷èVûfØOºÜ|ç’Dùùä¦pÕ¸Í³°z4`×f¦‚Ó`P9M4míóÁN/_^s7LÞðl4_*hÄ6ã±{%MÇäö³²GëÊ^÷,]ù<É+Â =Ú.Z'	+Òý‹ó€Xo@ÎôžŸEHùò‚“ÛK)(«MŸËçt‚ªŒGË*®#öÐ\ÓMP­"lÒ&^¥…×&ýJþ÷ŒJJ¤æ8Ñ00zš^[óø­56mV² U^ÔWæÇn¤+®¶ì8_Q¿êÂ°î>ÿÿ¤&Eˆýü’ŽR½Hb[¶oøssù€‚œÈ(†jÜ}¬m×‡ºPÃ¥ÒÀ3Æ†9"¨ñÏE,8Úi(’UÉ}ãîèÛ’¹CæÑ°D;}¯š'öâÐc°ìµ…rÄp”:š,CÜÀBùì’%ÓbI"RãŸsµ°²B´Ä¯
‹Èr¸¸(¹0!O6U3¹t`_xê•Î³¿tô Å)yaŒÊ~)Üw-óæ<²±»pÓÄ—JÐ›ÊnKË›M]TÐe¤}Ñín;¿2ò ¬wŒmfŸ/?r0÷ñŽŸ‡\©P¨zU\’Ï¨mß Ÿª?Éi&ÑUqT¯†±D™*àÎ¦éFÏŸ¢U¯]B¹&5WÍ'p¼¡ü ÓpŸþxH~7î:c_öó ]>½}ƒ÷¶ŸØ‹`²äø6.o6>Ý–¥€5s‰%®?bZ5DÖ%Óuöºå;ž¡Lëlÿ9ul„ïÍøG˜È^Ö¨¤Š“·Ò^ãf}.zv‡Wc[“EïáSžÏ\}¨’{HáYÉ-ûËÈå7aæ!ÏèKÃ*Š&™q‰žìèÙØ>À¾&ÂÔšQ÷k$éßüû°&–‡S»p¼Ý~åì]¿âÀ–J;…”®¢òlÐ#édénŒÂ<Xõ:7Ï ÄãÝÁcÀŽ®˜U{Œí@ä5n-t]×,ÞŒuM§mž]5°ƒ%ü¢¡PXŽ	´'jøÀFZ„D¸­"ÑdÏ‘ÖÊU½Ðì¤6ã#8Rrü¿µ@µsm¥áöZu;7ÅûÛéö™˜Ädhû¾MÊ!ÞžUj¶Vý‚p°Än{Y©A¡YZ2¾ôËö<žtê^óù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´|£¯>âqÌrÀï„
ÏÕ”Árò—jlÎ”£,C@ÿPÇèí`¸V¦A-<üÆ;©¯gŽãIgL„Al9ãv¼¯Š]„ ŠþiË2…–0ŸB}•ª‰o™fg†3¹ôwé[åXz'UïÞ9“S•ÛwÑ|)9%ÒK¨66\ßò§ç*â† ÃŒ$§ã”´ß¼÷š§à×Ô ^ÐqÍè²bÏÉâ
Ñj„Jª™üªVÿÙÕY€Q¢i£ª¶p•rÊáö£Ú{\;{Dšì¿Ü <iº*6Éüš˜â1w{E…ê`Éìô¼~ù/ß½Í=¢h>³î(üV_ÆÄ	JÖz{è'•‘Î°‰ý>vR‰!Aqê”dêH®ê„ö[J7az¼P·‡WuR›¦êGoÃãE“x$t–¿	®¢¿ý:X‚ýÖÐQ ”‹ûJú±ëjLZùeDµ«tAjÎ´üiäÐª¨di5b…±óPo^–òŒkwØò¿—.ÖÊ5ˆ^~Ïä¤€‚ZºÜ»·òÛšjÏ¢[ÀVH/ù§—b1ü«L(¢-T¹ØêÆ|ú•:þº~{F_Ÿ«„TC.GFkûbáF¹
¦(ú“ÜÆbÔÇçzè¶l¬Ãb[ÝP¶ŠLw”¥÷@¦ÝÍ)ñ†-K.ÕÔ†ÿ¸—Âû½/©M4&B•”ÀbŽ˜ ppýoÔhFÑö£SÍ”š²Ã«¼º	«ŠVª“ŒZ%M=ª„dœo˜ÀšEî |7ù)½.’lˆ„°t%äQÕòå¾<©ÿæHl°ƒ0ƒS¤‹{i›x*WÙ
wóúä£5’½is°—–Usô&Ð¶‘P("ƒVçy@bã4
t3º¬Ì¤>}’Ú ‹‚hEzªX¦*?7Šd^Myâ=²½´ D‚§µîãL…œWZ|÷v¡Å~o§_Û³ã‚=úŠs³¢(Ôµgv‡­ŒWfÐÁ{4	òÒm!µÃÖÜÚžwæŸOj¢Œv8ÝÄît¨,8ð”Ì˜.³ž¿- ˆ$?Ö+²¼žYÐÂÞ™'4•ÉP_PÐE€\7LSX½7#3„:\±Ä†¤Î%Ÿþ¼ÓÀÇ+V~Ñó³ŽÀ´ÎE>Ü/Âžâ[ñ¹6CòaêIYÞÍ^à`G» ?/õí˜fêQåî:°Ð%dnV¢*ßgÙR$a½G]]jÖ¡½ªÜÍŠ]Áùûhã¥1híævÀ¤G¨W' Ë‰;ÒØbü¦ì_‘b@ÇŸ>êwÒ;-}ñTýù²Mog6ùX•S/rh®0Ís|üZéï?Û¬ÛCÔº»w,tV¥_±èªI‘c €Þ7ÊÔs.zñ–b0ŠpuÖÕþã@'lFãò ]ñêuaì¢ø†;ÄƒßÓ4^IÑ’‘ö XËòHWÕQion','$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-6"  >
<?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>