<?php
        $vdate="200819/usratt/usratt";
        include_once('../etc/dbv2.php');
        include_once('../etc/sessionv2.php');
        include_once("../lib/language_$LG.php");
        $PDF=$_REQUEST['pdf'];
        if(!$PDF)
            ISACCESS("estaff",1);//autoreject

        //get info to prepare pdf
		include('../inc/get_host_info.php');
		//Debug
		//echo "$host<br>$uri<br>$pdfhost<br>$maindir<br>$sysapp<br>";
        
        sys_log($link,"attendance","View","Access attendance process",'',$_SESSION['sid']);
        
        if($_SESSION['sid']>0){
            $sid=$_SESSION['sid'];
        }else{
            $sid=$_REQUEST['sid'];
            $allsid=$_REQUEST['allsid']; //simpan 1 and 0
            if((!$allsid)&&($sid==""))//$allsid=0 and sid='' maksudnya baru masuk page
                $sid=$_SESSION['current_sid'];//maka bg curreny sid dlm current session
            //kalau else dia akan nilai sid dari request
            $_SESSION['current_sid']=$sid;
        }
   	
        $fullatt=$_REQUEST['fullatt'];
		$showfilter=$_REQUEST['showfilter'];
        $search=$_REQUEST['search'];
        if($search!="")
            $sqlsearch="and (name like '%$search%' or uid='$search' or hp='$search' or mel='$search' or ic='$search')";
            
        $jobdiv=stripslashes($_REQUEST['jobdiv']);
        if($jobdiv!="")
            $sqljobdiv="and jobdiv='".addslashes($jobdiv)."'";
        
        $job=stripslashes($_REQUEST['job']);
        if($job!="")
            $sqljob="and job='".addslashes($job)."'";
            
        $jobsta=stripslashes($_REQUEST['jobsta']);
        if($jobsta!="")
            $sqljobsta="and jobsta='$jobsta'";
    
        $job=$_REQUEST['job'];
        if($div!="")
            $sqljob="and job='$job'";
            
        
        $viewlist=$_REQUEST['viewlist'];
        
        if($sid!=""){
            $sql="select sname from sch where id=$sid";
            $res=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
            $row=mysqli_fetch_assoc($res);
            $sname=$row['sname'];
            $sqlsid=" and sch_id=$sid";				  
        }
        
        $year=$_REQUEST['year'];
        if($year=="")
            $year=date('Y');
       
        $month=$_REQUEST['month'];
        if($month=="")
            $month=date('m');
            
        $mon=sprintf('%02d',$month);
        $sqlmonthclaim=" and (claim_month='$mon')";

		$gender=$_REQUEST['gender'];
		if($gender!=""){
			$sqlgender=" and sex='$gender'";
		}
        
        $sql="select prm from type where grp='month' and (sid=0 or sid='$sid') and val='$month'";
        $res=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
        $row=mysqli_fetch_assoc($res);
        $monthname=$row['prm'];
        
        $tamat=$_REQUEST['tamat'];
        if($tamat=="")
            //echo $tamat;
            $tamat=0;
        
        $sqltamat="and status=$tamat";
        
        include("../inc/getsmsidv2.php");
        include("../inc/pagecontrol.php");   
?>
<!DOCTYPE html>
<!-- Template Name: Awfatech-->
<!--[if IE 8]><html class="ie8" lang="en"><![endif]-->
<!--[if IE 9]><html class="ie9" lang="en"><![endif]-->
<!--[if !IE]><!-->
<html lang="en">
	<!--<![endif]-->
	<!-- start: HEAD -->
	<head>
		<title>Attendent</title>
        <?php if($PDF)include_once("$MYLIB/inc/myheader_setting.php");?>
	</head>
<body>
	<form name="myform" id="myform" method="post">
        <input type="hidden" name="page" value="../usratt/usratt.php"><!-- paging need info page name -->
		<input type="hidden" name="showfilter" value="<?php echo $showfilter;?>"><!-- use to keep status show/not filter-->
        <input type="hidden" name="tamat" value="">
        <!-- start: CONTENT -->
		<div class="wrap-content container bg-light-grey text-black" id="container">
            <?php if(!$PDF){?>
			<!-- section: TOP MENU -->
			<?php include("../usratt/top_menu.php");?>	
			<!-- start: FILTER -->
			<div class="no-print printhidden"><!-- filter line 1 -->
				<?php include("../../app/inc/div_select_sid_eboss.php");?>
				<div class="checkbox-inline no-padding">
					<span class="input-icon">
						<input id="submitsearch" class="form-control text-bold" name="search" type="text" value="<?php echo $search;?>" placeholder="<?php echo $lg_search;?>">
						<i class="fa fa-search"></i>
					</span>
				</div>
				<div class="checkbox-inline no-padding" style="margin:0px 0px 0px -35px !important;">
					<a class="btn no-padding checkbox-inline text-dark text-bold" onClick="document.myform.search.value='';document.myform.search.focus();">x</a>
				</div>
				&nbsp;<!-- put some space coz of -margin -->
                <div class="checkbox-inline no-padding">
                    <a class="btn btn-warning text-black btn-sm text-bold" onclick="main_process_page('../usratt/usratt_list.php',1,'mycontent');">
                        <i class="fa fa-search"></i> <?php echo $lg_process;?> </a>
                </div>
				<!-- more button to show more filter -->
                <div class="checkbox-inline no-padding">
                    <a class="btn btn-sm btn-grey text-black text-bold" onclick="if(document.myform.showfilter.value=='1') document.myform.showfilter.value='0';else document.myform.showfilter.value='1'; showhide('div_show_filter');">
                        <i class="fa fa-cog"></i> <?php echo $lg_more;?>
                    </a>
                </div>
			</div>
            <!-- default hidden filter only open on click more -->
            <div id="div_show_filter" class="no-print printhidden" <?php if(!$showfilter) echo "style=\"display: none;\"";?>>
                <div class="checkbox-inline no-padding">
					<select class="form-control input-sm" name="year" onchange="main_process_page('../usratt/usratt_list.php',1,'mycontent');">
					<?php
						echo "<option value=\"$year\">$year</option>";
						$sql="select prm,val from type where grp='sysyear' and (sid=0 or sid='$sid') and prm!='$year' order by val desc";
						$res=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
						while($row=mysqli_fetch_assoc($res)){
							$s=$row['prm'];
							$v=$row['val'];
							echo "<option value=\"$s\">$s</option>";
						}
					?>
					</select>
				</div>
				<div class="checkbox-inline no-padding">
					<select class="form-control input-sm" name="month" onchange="main_process_page('../usratt/usratt_list.php',1,'mycontent');">
					<?php
						echo "<option value=\"$month\">$monthname</option>";
						$sql="select prm,code from type where grp='month' and (sid=0 or sid='$sid') and code!='$month' order by val";
						$res=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
						while($row=mysqli_fetch_assoc($res)){
							$p=$row['prm'];
							$v=$row['code'];
							echo "<option value=\"$v\">$p</option>";
						}
					?>
					</select>
				</div>
                <div class="checkbox-inline no-padding">
					<select class="form-control input-sm" name="group" onchange="main_process_page('../usratt/usratt_list.php',1,'mycontent');">
					<?php
						if($group==""){$selected="selected";}else{$selected="";}
						echo "<option value=\"\" $selected>- $lg_all $lg_group -</option>";
						$sql="select prm,code,des from type where grp='usratt'";
						$resgroup=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
						while($rowgroup=mysqli_fetch_assoc($resgroup)){
							$prmgroup=$rowgroup['prm'];
							$groupcode=$rowgroup['code'];
							$prmremark=$rowgroup['des'];
							if($group==$groupcode){$selected="selected";}else{$selected="";}
							echo "<option value=\"$groupcode\" $selected>$prmgroup - $prmremark</option>";
						}
					?>
					</select>
				</div>
				<div class="checkbox-inline no-padding">
					<select class="form-control input-sm" name="jobdiv" onchange="main_process_page('../usratt/usratt_list.php',1,'mycontent');">
						<?php	
						if($jobdiv!="")
							echo "<option value=\"$jobdiv\">$jobdiv</option>";
						echo "<option value=\"\">- $lg_all $lg_division -</option>";
						$xjobdiv=addslashes($jobdiv);
						$sql="select prm from type where grp='jobdiv' and (sid=0 or sid='$sid') and prm!='$xjobdiv'";
						$res=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
						while($row=mysqli_fetch_assoc($res)){
							$x=stripslashes($row['prm']);
							echo "<option value=\"$x\">$x</option>";
						}
					?>
					</select>
				</div>
				
				<div class="checkbox-inline no-padding">
					<select class="form-control input-sm" name="jobsta" onchange="main_process_page('../usratt/usratt_list.php',1,'mycontent');">
					<?php	
						if($jobsta!="")
							echo "<option value=\"$jobsta\">$jobsta</option>";
						echo "<option value=\"\">- $lg_all $lg_status -</option>";
						$sql="select prm from type where grp='jobsta' and (sid=0 or sid='$sid') and prm!='$jobsta'";
						$res=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
						while($row=mysqli_fetch_assoc($res)){
							$x=strtoupper(stripslashes($row['prm']));
							echo "<option value=\"$x\">$x</option>";
						}
					?>
					</select>
				</div>
				<div class="checkbox-inline no-padding">
					<select class="form-control input-sm" name="gender" onchange="main_process_page('../usratt/usratt_list.php',1,'mycontent');">
					<?php	
						if($gender==""){$selected="selected";}else{$selected="";}
						echo "<option value=\"\" $selected>- $lg_all $lg_gender -</option>";
						$sql="select prm,val from type where grp='sex' and (sid=0 or sid='$sid')";
						$res=mysqli_query($link,$sql)or die("$sql failed:".mysqli_error($link));
						while($row=mysqli_fetch_assoc($res)){
							$x=strtoupper(stripslashes($row['prm']));
							$v=strtoupper(stripslashes($row['val']));
							if($gender==$v){$selected="selected";}else{$selected="";}
							echo "<option value=\"$v\" $selected>$x</option>";
						}
					?>
					</select>
				</div>
				<br>	
				<!--<div class="checkbox clip-check check-warning checkbox-inline">
					<input type="checkbox" id="cb1" name="show_clockout" value="1" onclick="main_process_page('../usratt/usratt_list.php',1,'mycontent');" <?php if($show_clockout) echo "checked";?>>
					<label for="cb1" class="text-dark text-bold"> <?php echo "$lg_clockout";?> </label>
				</div>-->
				
				<div class="checkbox clip-check check-warning checkbox-inline">
					<input type="checkbox" id="cb2" name="tamat" value="1" onclick="main_process_page('../usratt/usratt_list.php',1,'mycontent');" <?php if($tamat) echo "checked";?>>
					<label for="cb2" class="text-black text-bold"> <?php echo "$lg_staff $lg_resign $lg_only";?> </label>
					<input type="checkbox" id="cb3" name="fullatt" value="1" onclick="main_process_page('../usratt/usratt_list.php',1,'mycontent');" <?php if($fullatt) echo "checked";?>>
					<label for="cb3" class="text-black text-bold"> <?php echo "Show Full";?> </label>
					<input type="checkbox" id="cb4" name="fullmonth" value="1" onclick="swal('<?php echo $lg_reminder;?>','<?php echo $lg_display_will_be_cramped;?>');main_process_page('../usratt/usratt_list.php',1,'mycontent');" <?php if($fullmonth) echo "checked";?>>
					<label for="cb4" class="text-black text-bold"> <?php echo "Show Full Month";?> </label>
				</div>
			</div>
			<!-- end: FILTER -->
			<?php }?>

			<!-- section: CONTENT-->
			<div class="panel panel-white no-radius no-padding" id="mycontent">
				<?php include("usratt_list.php");?>
			</div>
			<!-- end: STORY -->
        </div><!-- end: CONTENT -->
    </form>
	<?php include("../inc/ver_info.php");?>
</body>
</html>