®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃ¬ä»¬²i`Nˆ,›¶âøø^ìkïS,²OÆR/‚ÚÎ£õCïº]‚uÖoRaÍè“†Ü…ØÃx§¸Y"æwm»‡·	ÜD’±ö©×Àr¨î¯8XŠ‚+®}Âë/9åQÉieH×³XE}QJÂú¤øßúîPEÆ0'æ|´‹•ìï²ß¥¨‘™2ÊäœÎû²B²\RtZ—ç…n|"é:ÍÐä.ojvâN¬›³ ·aˆÑýKÇ¥ÃÌ^uÏÉ­8½#õH‚ŽQF5Œæ2\PËK:˜J'°ÏV1©ö	¿B:Ä¸ž·ñ­øã„‚ŠZéÓC3Z	ÍWÂ[tG—Dž¬¬¿‰gÜ3Dœ?@p_œq«~,îŽX'Õçd!¹]Z¹2nSÌ¨ï¨šý¢èwK«3$8í‡˜2F,pX0{Ãœ>‰sÃ÷e*YžHU`"¹ôÔ-JŒö^ ¯µ™”@
Ö–äß,9½rÂ¸ž·ñ­øã„‚ŠZéÓC3Z	ÍWÂ[tG—Dž¬¬¿‰gÜ3Dœ?@p_œq«~,îŽX'Õçd!fEŠGo{E£Þ`#•ë¾½*•°=\Ñq7Nïœ|õr8P«Ã¯CšfÙänZ±;32lK	ôfÐYÖIn¤š/ü5ÂËçqË27ÖE3òÛÈÜquƒ‘"ð8ÇAžÒí
 zZûŒ3ÚÚÆž†ª‡ã÷mÑuF ´‚±uv³cyç™ð,feÄ”gš´Ÿ@ké;MòFR’ÒÍCp4g`¹[¸W;X¿[ÌJ#àÐœ"ô°¤²¤,!©¨0q²Ýƒ¼Õh†¹BnPêê»G%Ì÷ñ,¸[Õr¹º1Eê„ÆË×-j;É¨ö_YôñªÌo8›çb{©§ôÚ—6ÁÚðâ6BNàR+Ú/.Ïy¾Õú°FI7—”oTŒm<ÐöÑ³(ÜþF¼Lt`<;ëÖÕlöWJÒpå^ÌâLåMçn¡G_|o©Òä±[©HÿÞùÆ€©2§xÝë¢'M“ÎúRwqê>àußÉê¤ Dä;n	a8¢Æ;Q?Fo¹TMåÄáJÒÊÔ'Ì¤U+u"ÂŽãŸQyÔÑ#ó6—1RÚKä„;BÛ¸£VÞÑ-êusD.¤±¸Ö'h­‘ŠÀUBl¼5c³}œ›)ùejìXÎÚŸX[‚3ox(%fJí‡!æ[Ü¨¯RÍyÉhÕ³£‚e“Ö!,Íští1¼ ÷žkt	^§Ô„d\Ž‹¢{ ‘ñÊ2²ÚEU~ý‚MjOSèÌ$àžrÊo‡mÂš3n¾d^:ùâáÓªpºú~{O®ÖkÖçâqÁÇH©º£4p)ÁU©$@¨ÆaéàŽI.;òµ“Vþ"dod±{¢ZÁÝQö¼þF`0®ˆëoêå¾ï• C	‚hÍyÑãóá4/Ÿ„(‰Bª†µL{FZ³`7§É&"¬>GYÇÛpg>Š·`\½:Ü i’‰nÏ9¥Lâ©–'Ú§·×tRzY6ùr¶[î²{Óc®jôf¨¸Øùœâ82‰LÂªä²½m¦í	åù$²5˜¬h	ì’Ð]‰ügtƒ]-~‚-˜¡›uêXÒÀ3Ò5®W—XÚmNà^š##—\ÔÈ3ÿ¶È2€QMY!/d¸Å)Ÿé²ùÊ˜ ³Ósì»	ô:°ªS=Ûf)­ÄkPY®–ÅØ&ÒÿüOQLLÚ<ýÄi¡.e5«B¸µe½Åù‡™Œú,n$¯uEÜX‰…u¶ÔP’btÍžj
æfþ¡õ óEÀ³•×J0UPy¨¶t™v¥re‹ªÀ\¬í$#½;ìÊ{äýô9\R”[³„9¾uöy0ÇÕ5£çã¥j7A¸=­…µf}gþ0+b6H}…Y“”ªY+à†™£›P3xM?ê†'å1>Ïò"¥ p6§Ç¯ Ò´…¦pÞnØÊM†§Æ®±µÑ92Ÿ+Àmj{K$ÔU3¹t`_xê•Î³¿tô “›h‡9<±žAK9ÛøMf¿¼A5²Ã®+CD}œ›)ùejìXÎÚŸXëÂ‰rVróPò6|»Üf×r'ªás—ñÌäßÝ×‡ë38ÝªG®óç~“ø¤ 0çf]€”jÎÔÒ®¾7Õ>úJ1ƒÞ“‚ß~ê›6«ýxVÍS¬Ý_VìÁ¦|pdcsß9 »dÓ¨9¶tJûX|·¦sÐm9FÛàFàctÍÅu»X6/ÇéøéYÐUÕ™Té“X¨_#× ‚`+3E«Î‰ÒBˆT}; ½× Èéoo4áfONî\ÜÔuRšT…7§É&"¬>GYÇÛpg>Í…;ÙÑ==ÆnÄbHV~èmÊ¨!Š(¦Ö9å8¤sÞ¢({¥^!Ü0r§…y¯•ØåìsÁöî~2}á»í…ühÜÉníšJÂ3ºI,©py‚:óMdFcQlÄé8fÅM·OÿÐŸliý®ÌùÙC¯w¸½#È®PéúÂ !ª'UQ,çý@«K"MÆR5½3B†=&ÞþðâƒÏ£tZ°y#€®òZÂ4Ò­R²?%PSËÖü•~id4e:KtäµJŸ0Ž<\Ö³ÇfŒ÷%*ì’ošî…6á.iz6ñ·‚T~åU$Ž‘iAò†EÅ7²ÈE‹ëÛø©·£fúoçµ¢†²§°›OÈ?ð²$©ëf
:d¤>Þì@ª//¼7Þ¡•·„ýÞoü|ÒÄìÜÙq&lÝÏ)·N"0±¿Ô€¨ÄÛÛ¤TÍ~ÁtÅŸ+à¹­‘¤r…†6u¨zM®UÞ˜bwÑ|)9%ÒK¨66\ßò§’'$Û¢Æ…HhiRÄ×X£tZ°y#€®òZÂ4Ò­RŠm6¢MüÇ|ñ™fuæÈ.ÞÉ_N²ZÐQAífÂÿ²¹	'Y®Šyç&˜šVFd×SVC
&sð.Z:v~{ð¼…×¡„GïrQý.ýÀB4'¼J›÷æ6H¥ýËÖñ¤G"hxA‡ÐÃ·î#ÊýÙÌ¼|¦¼LN<kÉìÊumyR½4Zì]†ÎÝÜsìNëÝ×òÀ?²ÖHvÐFv›‹ùú€§ÍÇ€ªì]!«ZþHÆBYºÈ™>¾5~JÝOÖ*$ºÜø‹’ìÚš¹F—ËLP&¢2“žÏ\}¨’{HáYÉ-ûËÈå7aæ!ÏèKÃ*Š&™qL FYç³.±ÂàÃ`,ýÃ@øz-i±3ú<Í8VòI€N)Òg‚2ýì4¹Â`ƒüã¦îqÆ|æxƒ"/}7¶é¼yÀÆÌý{+Ai¯–›?–ûCªö};Ñ;€ãk‰÷1¦>)/Û°jâö·ì»ä°ý¤MÀÈô2ÑvgK†”*K}‰?¸yc¬‘Ú¼ã|ú2Âìè-Ø2“aœwíB)ý^6ÙÜËé[4}ÂÞZË˜=´t«Ãž2°p7gÁítïì4J&@óyÞÁää_éö9Ð#KtäµJŸ0Ž<\Ö³ÇfŒ÷%*ì’ošî…6á.i®ËÆRyc‡Y>ãÆ®Â’9îÊ£üh92­õ5añ¨ÎÕŠË^á=B‘ŸËÊA9“!Û
…äªEÌC±&(Ì/\'=‘`]4YAÇÁvq5¨’`€“Ð­pèÕý„&nÜ$Ò1}~*ýËÖñ¤G"hxA‡ÐÃ·î#ÊýÙÌ¼|¦¼LN<kÉìÊumyR½4Zì]†ÎÝÜsìNëÝ×òÀ?²ÖHvÐFv›‹ùú€§ÍÇ€ªì]!«ZþHÆBYºÈ™ë1ÿ{‡6Fï	¼ªv”–v$ú3ÖòˆlÿTçÇù·…3)5G-QÂùVˆ…w F](#$Î;;Mvÿ"óÖŒˆ®ærNÑqè Ê%Óå,·t6V¹5xÏ™}‚wªãí(7¯UhŒ¾™?v¡%¾/ŠŠË%ƒvùðHÝW“eW¶r4(÷E™6”c·ÌºvHú.6•†ÐþâñÀ^÷§ÊEàÌY†ÎF¹¶”ª®UQ¤1ÕP˜D\ÈZ½–LIàe¢¨*ö£E,þ²ÈÀÞøh®ßk?^1\œÙ/¢Ü¸ßGÛÜ1¥"”Ø[}u¥óŒœªˆ|àb9v:¤ÙYVi‰¼Ö²G|e‰sðg””8Ž	Âœh¹¿ÙÎÕ¿–æ”šV’ËB^æ¶°ÏœÙÚë¸NÁ”eõÌ¹g!#d¶’
õæ	ÊÅÊG{‚¶7Brj™)‘7{3*øœM¥(õŠÑÃÐ¸¿8Ä”˜Æé•_ú”Š~Þ3z q«©0Ñ½œü˜ñ¬D–6å×D>È’¯´C^ãÖHŸ|Ûi ¦#:ôŸm[í†T­ ÍwÉ;ÛUÊžWº¡äÞKh=wÑ|)9%ÒK¨66\ßò§’'$Û¢Æ…HhiRÄ×X£tZ°y#€®òZÂ4Ò­RYpÏ…ŽlV<ƒ7#ªÄµäa6¨àSd;	¢o¸™ç^š¸yD¨Æ˜ïÞôo_Yˆ,Y)²–‘r/ZA­¢ð¦h›èL½"9€xG‚z¨ÌºvHú.6•†ÐþâñÀ^÷§ÊEàÌY†ÎF¹¶”ª®UQ¤1ÕP˜D\ÈZ½–LIàe¢¨*ö£E,þ²ÈÀÞøh®ßk?^1\œÙ/¢Ü¸ßGÛÜ1¥"”Ø[Þ¡$Ž+ pýRP]æ¦B‹­}?¤ô”z¶ã"“ÐÕsgÙ|g—‚«7Iû{™3ÁëÖhÝÒ¯"µ#?Ëæù¦9ØbÂý< \gYÆ)#àåt·?¯Ã´ÁÑ"~Z*,)¸Ïf_:ÇùŽd‹ñ´ùi(d´«ØÅôÂ]ü¯ð›mR‘5å5À÷wF®pk–²©¿]°ã´¡ÅZ:ÙúS‘Ê1‘%L.ÞÝ	Ù.Ð+B×ž'×´”6¯˜ØÕNŸÝëuÆÒM@©·*èFâSÈ4©þ±³ˆó¶òŽA´çÑ€#ËÆéÀ¬˜Ña dbB<^¥/‹vã›þ‘„œ’	ÌsËéÀjÆÖæè&Gª®™Þ\ëFJTMDwÇcîíÍÂEˆýü’ŽR½Hb[¶Q å£5ºéN©‹q"nRçVuP ;ŸQÃÖa*ô*–ï?Šëü c­ÔÀ‰ï§´¯év–;#Ý«
u•×D¾Èâuîðšf)`k}htName']=='btnAttendanceReport2'){
		echo "<script>window.open('Reports/attendanceReport2?from=$from&to=$to&keyword=$keyword&shiftID=$shiftID','_Blank')</script>";	
	}


	//exit();
}

if(isset($_POST['btnCalculateSingle'])){
	$shiftID = protect($_POST['shiftID']); 
	$from =  date('Y-m-d',strtotime($_POST['from'])); 
	$to =  date('Y-m-d',strtotime($_POST['to'])); 
	$keyword = protect($_POST['keyword']);	
	if($keyword!=""){
		$machineid=getName($conn,"select machineid from student where recordType='Staff' and stdName like'%$keyword%' ");
		if($machineid!=""){
			if($from>$to) $to=date('Y-m-d',strtotime($_POST['from']));
			for ($i=$from; $i<=$to; $i = date ("Y-m-d", strtotime("+1 days", strtotime($i)))){
				$type_="";//calculateAttendanceNewSingle($conn,$i,$machineid);
			}
		}
	}
	$day_= date('d',strtotime($from));
	$month_= date('m',strtotime($from));
	$year_= date('Y',strtotime($from));
}
if(isset($_GET['order_'])){
	$order_=$_GET['order_']; 
	$from =  date('Y-m-d',strtotime($_GET['from'])); 
}else{
	$order_="";
}
	

?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta content="width=device-width, initial-scale=1.0" name="viewport">

  <title>Attendance</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();'>

  <!-- ======= Header ======= -->
  <?php include_once("header.php");	 ?>

  <!-- ======= Sidebar ======= -->
  <?php include_once("sidebar.php");	 ?>

  <main id="main" class="main">

    <div class="pagetitle">
      <h1>Staff Attendance</h1>
    </div><!-- End Page Title -->

    <section class="section">
      <div class="row">
        <div class="col-lg-12">
          <div class="card">
            <div class="card-body pt-2">
 <!-- Multi Columns Form -->
              <form class="row g-2" method='post' action='studentAttendance' >

                <div class="col-md-2">
                  From
                  <input type="date" min='2024-02-01' class="form-control form-control-sm" id="inputAddres5s" name='from' placeholder="" value='<?php echo $from;?>'>
                </div>
                <div class="col-md-2">
                  To
                  <input type="date" class="form-control form-control-sm" id="inputAddres5s" name='to' placeholder="" value='<?php echo $to;?>'>
                </div>

                <div class="col-md-2">
                  Shift
                  <select id="inputState" class="form-select form-select-sm " name='shiftID' required>
                    <option selected></option>
					<?php	
					//echo fillCMB($conn,$shiftID,"select ID,headName from AccountHeads where headStatus=0 and isHead is null and (headType='Shifts') order by headType");
					echo fillCMB($conn,$shiftID,"select ID,headName from AccountHeads where headStatus=0 and labid='".$_SESSION['labid']."' and (headType='shifts') order by order_");
					?>
                  </select>
                </div>

                <div class="col-md-1">
                  <label for="inputName5" class="form-label">Late In
                  <input type="text" class="form-control form-control-sm" id="inputName5" name='lateEarlyMints' value='<?php echo $lateEarlyMints;?>'>
                </div>
                <div class="col-md-1">
                  <label for="inputEmail5" class="form-label">Early Out
                  <input type="text" class="form-control form-control-sm" id="inputEmail5" name='earlyOutMints' value='<?php echo $earlyOutMints;?>'>
                </div>

                <div class="col-md-1">
                  .
                  <input type="submit" name='submit' class="form-control form-control-sm" id="inputEmail5" value='Calculate'>
                </div>

            
                <div class="col-md-2">
                  <label for="reportName" class="form-label">Reports
                  <select id="reportName" class="form-select form-select-sm" name='reportName'>
                    <option selected></option>
					<option value="btnPrint" <?php echo($reportName=='btnPrint'?"selected":"");?> >Print</option>
					<option value="btnAttendanceReport" <?php echo($reportName=='btnAttendanceReport'?"selected":"");?>>Print1</option>
					<option value="btnAttendanceReport2" <?php echo($reportName=='btnAttendanceReport2'?"selected":"");?>>Print2</option>
					<option value="btnAttendanceReport3" <?php echo($reportName=='btnAttendanceReport3'?"selected":"");?>>Print3</option>
					<option value="btnAttendanceReport3All" <?php echo($reportName=='btnAttendanceReport3All'?"selected":"");?>>Print3All</option>
					<option value="btnSummary" <?php echo($reportName=='btnSummary'?"selected":"");?>>Summary</option>
					<option value="btnSummary2" <?php echo($reportName=='btnSummary2'?"selected":"");?>>Summary 2</option>
					<option value="btnSummary3" <?php echo($reportName=='btnSummary3'?"selected":"");?>>Summary 3</option>
					<option value="btnAttendanceLateEarly" <?php echo($reportName=='btnAttendanceLateEarly'?"selected":"");?>>Late/Early Monthly</option>
					<option value="btnAttendanceLateEarlyYearly" <?php echo($reportName=='btnAttendanceLateEarlyYearly'?"selected":"");?>>Late/Early Yearly</option>
                  </select>
                </div>

                <div class="col-md-1">
				 <br>
				  <button name='btnShowReport' class="form-control form-control-sm">Show</button>
                </div>
				
 </form><!-- End Multi Columns Form -->

            </div>
          </div>


        </div>

      </div>
    </section>

	
    <section class="section">
      <div class="row">
        <div class="col-lg-12">
          <div class="card">
            <div class="card-body pt-2">
              <!-- Primary Color Bordered Table -->
              <table class="table table-bordered table-sm table-striped">
                <thead>
                  <tr>
                    <th scope="col">#</th>
                    <th scope="col" align='center'>Code</th>
                    <th scope="col">Name</th>
                    <th scope="col">Date</th>
                    <th scope="col">Timing</th>
                    <th scope="col"><a href='studentAttendance?order_=entry&from=<?php echo $from;?>'>Entry</a></th>
					<th scope="col"><a href='studentAttendance?order_=exit&from=<?php echo $from;?>'>Exit</a></th>
					<th scope="col" align='center'>Sym</th>
					<th scope="col">Remarks</th>
					<th scope="col">Leave</th>
                  </tr>
                </thead>
                <tbody>

<?php 		
$shiftID=0;		
if($shiftID>0)
	$query="select * from empAttendanceView where recordType='Staff' and date_='$from' and shiftID='$shiftID'  ";
else
	$query="select * from empAttendanceView where recordType='Staff' and date_='$from'  ";
if($order_=='exit')
	$query.=" order by symbol desc,exitTime,stdName";
else
	$query.=" order by symbol desc,entryTime,stdName";
//echo "<br><br>".$query;
$cur= odbc_exec( $conn, $query );  
$cnt=1;
    while( odbc_fetch_row( $cur ) ) {  
		//if ($cnt==1) echo  "<table class='imagetable2' style='display:block;width:100%;overflow:auto;height:70%;' border='1' ><tr><th>Serial<th>#<th>Name<th>Date<th>Timing<th>Entry<th>Exit<th>Symbol<th>Leave/HD<th>Remarks";  
?>
                  <tr>
                    <th scope="row"><?php echo $cnt++;?></th>
                    <td align='center'><?php echo odbc_result($cur,'machineid');?></td>
                    <td><a href="<?php echo "Reports/attDetail?shiftID=".odbc_result($cur,'shiftID')."&machineid=".odbc_result($cur,'machineid')."&from=$from&to=$to";?>" target='_Blank'><?php echo odbc_result($cur,'stdName');?></td>
                    <td><?php echo date('d.m.y', strtotime(odbc_result($cur, 'date_')));?></td>
                    <td><?php echo date('h:i A', strtotime(odbc_result($cur, 'ent1')));?></td>
                    <td><?php if(!is_null(odbc_result($cur, 'entryTime'))) echo date('h:i A', strtotime(odbc_result($cur, 'entryTime')));?></td>
                    <td><?php if(!is_null(odbc_result($cur, 'exitTime'))) echo date('h:i A', strtotime(odbc_result($cur, 'exitTime')));?></td>

                    <td align='center'><?php echo odbc_result($cur,'symbol');?></td>
                    <td><?php echo odbc_result($cur,'remarks');?></td>
                    <td><a href='<?php echo "addLeave?empID=".odbc_result($cur,'ID')."&date_=".odbc_result($cur, 'date_');?>'>Leave</></td>
                  </tr>
<?php 
	}
	//"<td></a><td>$date_<td>$timing<td style='color:$color;'>$entryTime<td>$exitTime<td align='center' style='color:$color;'>$symbol<td><a href='addLeave?empID=$empID&date_=$date_'>leave</a>" ;
?>
                </tbody>
              </table>
			  
            </div>
          </div>

        </div>

      </div>
    </section>

  </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>