®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃ¼³Ew¢ÍxÒÉïøLTÈ)ÚZÑ
2¹¾e€¨;[cg¡6ÑýTS{*	\Å	jC·¬E¯®_¯Vt×›CËñý¤&«Rò6:D~÷Õ=,µ@IL8
!Û™j‹Ñ>–«›³ub}»r]o¦P0ÀÌ°M†c{é8”	i¹´-ø¶îé½—ŸYüšîØž‘::„6øØp[.K{ýÌ,-ð„õ,…_Ñ_	ÏÑH÷Wóí|—Ø¨¤"‰ ÷‹H]{dZø¸yþƒh`nûŒ
S7µŽ™«zÑe«ZZèô:¤£‘S±Á¬B¼|Û~¾…
6I8ƒöp¼OSç(fÊÏ(àÊeš^Wä
ðO_³à×ÇNwwÚÎñÆ%œÂ‹é¬¡¯sÎvÅ›¼™áF³ä„/Ì¿	¾T÷ñ÷$œI¢ú%XB¯[+ƒv‘¨­¯sJ€AÅ/I3{X0È°ÂÁöÈzþØn›M±;ìâž|mçIÝ„H
„É¿ôGKUÓ¥šR¸UÛ~Dé€ª]‡Ÿy@¿=fŠ:¹˜A·0øæ—7xŽž:S
F/º×bqÉ«'jJgÿ²¿ÞÆN½r${@-µ§ÿ´kþO§p\nøG§Y)ƒüœÉçv­Gyù9ÍeO¦ È†á“›wµË“­õÜ-+¬ý¥qc.¤òçz¥¨€hªC?±'åCf\Ù&h×ý¶!g´ÈkOÞ Ç=3ºÜ×qNHÄäô€Sa¹ÌkŽrù/àœ¬ÌÁôÉ´•ÈDAS‰þ¡IjÛ–óê†KŸE0ú‚ —ˆ‡»®ëOp[Û¨¦Ø¯­YÇ'¿­•)&"›ZúÊÏ=—MÆºñ½Í•YúÒžßUrçÒ
JMÔ(!a˜+{9OµÔ5ýVÂ›Þúä“¼ ®žÞc‘l%L¹']4½á_ÌŽFÏÔÉî»Ì[Àõñ;ôÀó=v´ŽÎeVãÊ®pÚïsªˆì é¡‹ÂZYØè „òå1?¿ÅÛ1VòÚ÷Ú¼ÚTÄ¤£OÎ2zÖRHK	ÆÖmñDDû/Ç6-33:Îê‰[ÙódûêÛpÚïsªˆì é¡‹ÂZYØè „òå1?¿ÅÛ1VòWBî?¦«¥[nçïøâÓ@Ð ¶! ýjQJ6Ë†7¤b5Ï…#DxIQ•škâÂók©Ù°Çñ„øïZr}W3PÿEbºùêt¼Ë¤Òx =vïVìxöÍýÑÁpÖ$äb¾Vï‹ïÄÈxøÍãØã´½ÙÎuú:I„ó<PÓrPQÿB¥ÜöCØöW;-Zè!üÑ¡üQÅÊN–6(ä\¬°’5­Íê°càÈ–QÆûÛ±‹!IÂt¯ÉÕ†KT¸žhi
­.Æ¦€ Þ=Ã!®yáøÇ@•ñÚëãÜ>¢Ì<æÎºÈº	rî•¹_<L‹ßË›¢ªÇöœb€a6æØˆKZ_TTú–9Îx¯€ñØŠŽæÁTi~¨(4”–~“UÔÞxfSÒfzV(&±Î-|ÜãËÓ–Ç2r%·ƒAð=ŒÂfˆ|xñÛÑxþ(ŒŒ\Ã&Àç‰ÚMåì¾¹RM:O$( ¼@½Àž;Vz*>²¬×üì¡Åñ½kñH P©ä#âW5r½ÙÎuú:I„ó<PÓrPÙ`ð«y¾$ˆ¨VG¥0`Á|LWÓíV‡‡Ì'fÛÇ®·i‹Ü÷øXw.˜ãÏîÄ-àêZX@ÞSé[{¿ˆÈ?÷â-¢-^okq­!µç]àYšÜ”ìR^(EÍ„¢oI¡ÜÈS×Ï9Eï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;j‹UÄôí~v/Í?§´#D95®*–*¾Iµ&¿ Ð0¶u/ÂÐ÷8j‚ž­À‡ånÛ4I#±}bµuw€‹Ðhmõ ŠÞ‹'ÂFäPäA×î¹âï'´TÓ'‹1šµ:b©!‚íZ‡ßæ}ÒÇ8¬¦ëî¿5úÜ1Œdf§[¥"þžò_‘èA cËÆ{ƒÔç}…DÒ`>ª0,\«ÏÓ`ðjÅ^òD§DÀ]Ña2íù¼È¸ÞùUD¸ç(ižñf½2ŠƒG!2òµjZLBö½^Ø}Ì¡V£éï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;¥ž8¬Jöw5\x˜Ô¸Ë WŽ:Dý`¼ha™ü3³ÉÝŽå¿ïž¡<-?°#è ü·wÑª?Ù×hfÎ@±'•ˆi5/ô*>Ýø,B„•òdÈo…„¦‡êRÉƒnOê×-ï‚w'd]—kÑFY]õueç®m
d±|ÛX1kv,_Úê€—]sæ )g—A£ý×V·Z;”½‘q€¨°¥5"œ]Ÿbh PË¬±Ì‰C2W´ ´V^ÞáôœnªŸvŸ1zÁ*êp+>ÂGÝ¨›?X¸`ã‚ˆðŒã;ÆþS— —ÉƒSU½Eü³f"ZE‡øó²"»?üJï’Vº	ìçVd!L Tž2~ã]´ßM\§Ö0„O¯'ßáüïOÐÂL>Îµ1Õ>½RÊ°ã‰žMÕi ÂXáxo\ZÜÉÍýê»GªA>Î!Žp”n$c~¤ŸšS×ÁEEª÷-oXçù#÷ânÑ%¢'r	znâ@jŒºÍ|M]Ep8Y¨ž3L©µå¡6/¸œ6šhƒHwh•„o­uºé©P2äÛv¨'KÝÏ$=j7„’?ˆ†Mïç_BIßÿÌ÷×-d…spZï·ÓàéÎÿwª¹ñŠ,½‰Ñ‹ †EH›˜]ÂdŸ¬A×ÙLD0Ø§zQ‘]L¦:ÝBqH*0Àn’ý‰ÇeÔžËkÜ:,R³ëì•7—)ì}§B)_uLYã{8kò©õ:¾Ë8"nákÂö×•–9‡©üû±3Ùu"K8Æ–x¥ýæIiG*NŽ˜×Ïß¡Éeäo:f(})E‡²ÿðäæ‹q€ûwå˜×Ïß¡Éeäo:f(}ÈG§Œó==ªIYìb7æ÷öehÝDv¡e%]^~UÇ[Œˆy™tÇ¸(cL~ã;'T"NO:UQ¯+ƒZ[yþ¢•…Îï±~Õ.7iE¤ùö	qÉœ'BlÀ9ÃÈ´ƒä€…ãR¾«%§žt®]Å1ˆxqÂç8hÿˆn¡ –’L®*Mñ)káœý|kê êÙÞi×PâŸÒç¾p±d	š:Ük&¦^iúæ‹wÍ$\;vQáŠøÜNÓ]*¶‡ð0•ÔáOkUÅ™!šŒÍ¨–`=¿5.¾·SSœ+	?™.Y•îå‚í¥¼ih7i’Jº ÿŒ{ÖŠóŽ>è¨4´G6^–ÄC)s©ŸEWyEÿ0€­8n‹ð£KÜúåISû’•À›±,K5cN‹gjÆÈ)ù+ÍÈ”@î»x=×ÔÓÈ_#¿]ÙŽÂÔu>íŸ¯÷:öÁÉû4o©ÖæùÙ›žZg­:ÿ”iky/1Q­ýµöQžGZ
­ª€@;~ºø£—%<	òr‚Ä”>@FÇµvð•±”5Tè2>DQ&ðñÁ“³–U•þ­^Éç\ ;fkÞâx?>ðR [¦– É#fä¨Ãqq†
sÍu š8_ºUãcÞ™B9xOÈìžì|ÿ¼×4è¼ÑÙk¹rõc]¹%šŒÃN…¡}ç†Ç”’20§$x¯Ë×â6÷¨­&VÑ¼B*æ6]Ò¤nRÒ jÈÛ¬™Íþ@šHÕAžRm#XäM°Ÿ0Jî‹Ml*èht]™ù…Û}o9ò¶P•Ú¥zK zLC«ó^=¶˜Ö’HygUÕ#¦l(…tÐdßlŠÁï·˜Í½‡R-ÕúÂœ!Íž'ÉßäŸÚŸú}ÌD¡E@iþŽ:€e5EþGö*mPÿ—v¦LÖ[k&MW,
CÄ=àÒ´ÅcîÌáÑñî‘5„LöØn"…×[³ ]xäø±þI´Ó $8ä"þs-.£wÃp°ÿ½a#v¤çôü_'fK¦­±—D¸ªbË£xÉiéå™+sÒƒP¢„@¥ìÿþ GÐ&A½‘ÙïTÁÅ—²|~7ÐHRkÓZ¶™Þ_Cò*5«AA§é…ùÐÿ8–aQ‚¢^§‘£€“¥ñÁù2Þj%ð1’ oÛgðåRÈ4©ãé!‘2—»W¤þcƒ$—íÃ± Ç•·$sÞRr[3!3¿,ý¤7µ †ø.MY\Æì\óè|í_«õ
ño() §[ž 9Ñ¢Å:™‘Zù™2$q^jÔ˜n²og]9N‘+ú2SeäOQ°ß¹[Âe'V—ãg>i2Å4¶0ò$9@ˆ¾ÙÔ‘Í*Z…\s¿tF¶"Ç.ŽfÉYáG¢ÝÃŠWlŠú™©}Ê4$»TZZ(¥ßNR!]'ÕãM\â5òqéföMþ¦)v¾K§ËßÚý4xøÃ€³Gÿ2~}Iõ¨)ø²hï|q4»Ë&U›q M¥ÙŽ8»By5G-QÂùVˆ…w F](#$š~i¼ôýË×)Æ®ä›E’å,ÇÑMc…mÔpµè¹ê¦*·Ú›NL!yË%Œ³G¹«Ð¹*z÷”»»šS‡Dˆ=H³³¶Í‚“(gZµ“‡‰K×$Xqp.™&)9ÑI"RãŸsµ°²B´¬0çEw/P&sïú¡JMÝ*1"RÏÇ¢ì;ò»*¥7“Ò®u^`€&å£ÀØtüô¢¡Óï¯4ÏÐ0.ýF+*±&Æ]ÑøÉðn
[ÑëÜ[‚¹¢†¨·*€ôN:O‚÷d]«Koèóó)DßW½í(²6´(d1S÷vóU*/på‚
ø4BêÇ&æÃç{Ñud¡9 9ÅXÆ£EáJc7Urg¦„¤[F¢ÙbÔIÑ Êƒ<îÈmçéŽ›ÿ«Êä«mÝÞ
Ô„œMw	ž÷Å´›S±ÂÝK}?9xV *ú¡kßñcÓŠZÀHµ}*__àÚ|hº&ÚúÓ"Â2k-°Õ¡9íLñ/¨Ê—æc@vÊpÕ:«Å§³ðáÒ×`³Jª}9þ³«>“”‹òEü§_ÛhV½k>“ì~lä­ë„äÁ!§ ]; ƒóS•tŒ…Ö“žéˆéhù¾ì”KtUnúÆ™Ã×Ú.W->ÝáØ½’ïuI&ø/i> Print</button>";

echo  "</table></form>";    
		


	
odbc_close($conn2);

?>

              <!-- Primary Color Bordered Table -->
			  <br><h4>Attendance</h4>
              <table class="table table-bordered table-sm table-striped">
                <thead>
                  <tr>
                    <th scope="col">Date</th>
                    <th scope="col">Day</th>
                    <th scope="col">In</th>
					<th scope="col">Out</th>
					<th scope="col" align='center'>Status</th>
                  </tr>
                </thead>
                <tbody>

<?php 		

$empID=$_SESSION['userID'];
$to = ( date('Y-m-d',time()));
//$from = date('Y-m-d',time());
$from=date('Y-m-d', strtotime($to. " -30 day"));

$query="select * from empAttendanceView where recordType='Staff' and (date_ between '$from' and '$to') and ID='$empID'  ";
$query.=" order by date_ desc,entryTime,stdName";

$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>
                    <td><?php echo date('d.m.y', strtotime(odbc_result($cur, 'date_')));?></td>
                    <td><?php echo date('l', strtotime(odbc_result($cur, 'date_')));?></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>

                  </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 class="col-lg-6">

          <div class="card">

            <div class="card-body">
              <h5 class="card-title">Absentees/Leaves/Holidays</h5>
			  <hr>

<?php
$startDate=getName($conn,"select headName from AccountHeads where headType='startDate'");
$query=getName($conn,"select count(*) from empAttendanceView where ID='$empID' and symbol='A' and date_>='$startDate' ");
if($query>0){
?>
              <!-- Primary Color Bordered Table -->
              <table class="table table-bordered border-primary table-sm">
                <thead><tr><th colspan=10>Absentees
                </thead>
                <tbody>
<?php
$query="select * from empAttendanceView where ID='$empID' and symbol='A' and date_>='$startDate' order by date_ desc";
$cur= odbc_exec( $conn, $query ); $cnt=1;
    while( odbc_fetch_row( $cur )) {  
		echo "<form action='addLeave' method='post' name='frm$cnt'>";
		echo "<input type='hidden' value='$empID' name='empID'>";
		echo "<input type='hidden' value='$cnt' name='cnt'>";
		echo "<input type='hidden' value='".odbc_result( $cur, 'date_' )."' name='date_'>";
		
?>
                  <tr>
                    <th scope="row"><?php echo $cnt;?></th>                   
                    <td><?php echo date('d-m-Y  l', strtotime(odbc_result( $cur, 'date_' )));?></td>

<?php 

		echo "</form>";
		
		$cnt++;
	}
?>
                </tbody>
              </table>  
<?php
} 
?>	

		  
              <div class="accordion accordion-flush" id="accordionFlushExample">

<?php


$query="select distinct symbol,count(*) as total from LeavesView where empID='$empID'  and date_>='$startDate' group by symbol order by symbol desc";
$cur= odbc_exec( $conn, $query );  $cnt=1;
while( odbc_fetch_row( $cur ) ) {  
		//($conn,$leaveID,"select ID,headName from AccountHeads where headStatus=0 and isHead is null and (headType='Leaves') order by headType");
		$lname=getName($conn,"select headName from AccountHeads where headDescription='".odbc_result($cur,'symbol')."' and (headType='Leaves')");
?>
                <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-<?php echo odbc_result($cur,'symbol');?>" aria-expanded="false" aria-controls="flush-<?php echo odbc_result($cur,'symbol');?>">
                      <b><?php echo odbc_result($cur,'symbol')."= $lname = ".odbc_result($cur,'total');?></b>
                    </button>
                  </h2>
                  <div id="flush-<?php echo odbc_result($cur,'symbol');?>" class="accordion-collapse collapse" aria-labelledby="flush-headingOne" data-bs-parent="#accordionFlushExample">
                    <div class="accordion-body">

              <!-- Primary Color Bordered Table -->
              <table class="table table-bordered border-primary table-sm">
                <thead>
                  <tr>
                    <th scope="col">#</th>
                    <th scope="col">Date</th>
					<th scope="col">added On</th>					
					<th scope="col">IMG</th>					
                  </tr>
                </thead>
                <tbody>

<?php		
$query="select * from LeavesView where symbol='".odbc_result($cur,'symbol')."' and empID='$empID'  and date_>='$startDate' order by date_ desc";
$cur2= odbc_exec( $conn, $query ); $cnt=1;
while( odbc_fetch_row( $cur2 ) ){  
		//echo  "<tr ><td>".$cnt++;
		//echo "<td>".date('d-m-Y H:i:s', strtotime(odbc_result($cur,'time_' )))." | ".odbc_result($cur,"userID");
?>
                  <tr>
                    <th scope="row"><?php echo $cnt++;?></th>
                    <td><a target='_Blank' href='<?php echo "showImage?appName=".odbc_result($cur2,"img")."";?>' >
						<?php echo date('d.m.y', strtotime(odbc_result($cur2, 'date_')));?>
					</a></td>
                    
					</a>
					</td>
					<td><?php echo date('d.m.y H:i', strtotime(odbc_result($cur2,'time_' ))); ?>


                    <td><a target='_Blank' href='<?php echo "showImage?appName=".odbc_result($cur2,"img")."";?>' >
						<?php echo (odbc_result($cur2,"img")==""?"":"img");?>
					</a></td>

					
                  </tr>
<?php 
	if(odbc_result($cur2,'remarks')!="") echo "<tr><td colspan=5>".odbc_result($cur2,'remarks');
	//if(odbc_result($cur2,'img')!="") echo "<tr><td colspan=5><a href='showImage?'>Image";
	
?>

				  
<?php 
	}
?>
                </tbody>
              </table>  



						<div id='divStaffSearch'></div>
				</div>						
	

                   

                  </div>
                </div>
<?php
 }
?>				
			</div>

			  
            </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>