1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / hrm.addobyte.com / application / views / reports /
Filename : employeeInOut.php
back
<link href="https://cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css" rel="stylesheet">

<!-- page content -->
<div class="right_col" role="main">
 <div class="row">
  <div class="col-md-12 col-sm-12 col-xs-12">
	<div class="x_panel">
	 <div class="x_title">
			<h2>Employee In/Out Timings </h2>
			<div class="clearfix"></div>
		</div>
		
		<?php
			
		?>
	
		<div class="x_content">
		
				<div class="col-md-3 col-sm-6 col-xs-12 form-group has-feedback">  
				  <label for="fullname">Employee * :</label>
				  <select id="employee" class="form-control" name="employee" required>
						<option value="">Choose...</option>
						<?php
						if(isset($employees) && !empty($employees)){
							foreach($employees as $tmp){
								if(isset($employee) && $employee == $tmp->uid)
									echo "<option value='$tmp->uid' selected>".($tmp->first_name." ".$tmp->last_name)."</option>";
								else
									echo "<option value='$tmp->uid'>".($tmp->first_name." ".$tmp->last_name)."</option>";
							}
						}
						?>
				  </select>
				</div>
				
				<div class="col-md-3 col-sm-6 col-xs-12 form-group has-feedback">  
				  <label for="fullname">Start Date * :</label>
				  <input type="text" id="start_date" class="form-control datepicker" name="start_date" required value="<?php echo isset($start)?$start:date('01-m-Y');?>" />
				</div>
				
				<div class="col-md-3 col-sm-6 col-xs-12 form-group has-feedback">  
				  <label for="fullname">End Date * :</label>
				  <input type="text" id="end_date" class="form-control datepicker" name="end_date" required value="<?php echo isset($end)?$end:date('t-m-Y');?>" />
				</div>
				
				<div class="col-md-3 col-sm-6 col-xs-12 form-group has-feedback">  
				  <label for="fullname"></label><br>
				  <a class="btn btn-success" id="getReport">Submit</a>
				</div>
					
				<?php
				if(isset($week) && !empty($week)){
				?>				
				<table id="" class="table table-striped table-bordered">
                      <thead>
					  
					  
						<tr>
							<th width="14%">Date</th>						
							<th width="14%">Clock In</th>						
							<th width="14%">Clock Out</th>						
							<th width="14%">Late</th>						
							<th width="14%">Early Leaving</th>						
							<th width="14%">Over Time</th>						
							<th width="14%">Total Work</th>						
						</tr>
					  
                    
						
                      </thead>


                      <tbody>
					
						
							<?php							
								foreach($week as $tmp){	
									
									echo "<tr>";
									echo "<td>$tmp</td>";	
									$cDate = date('Y-m-d',strtotime($tmp));
									if(isset($timesheets[$cDate])){
										
										echo "<td>";
												echo date('h:i A',strtotime($timings[$cDate]['in']));
										echo "</td>";
										echo "<td>";						
												if($timings[$cDate]['out'] != '00:00:00')
													echo date('h:i A',strtotime($timings[$cDate]['out']));
												else
													echo "-";
										echo "</td>";

										echo "<td>";
											if(strtotime("10:00") < strtotime($timings[$cDate]['in'])){
												$lateMin = round((strtotime($timings[$cDate]['in']) - strtotime("10:00"))/(60));
												echo get_display_time_from_min($lateMin);
											}else{
												echo "00:00";
											}
										echo "</td>";
										
										echo "<td>";
											if(strtotime("19:00") > strtotime($timings[$cDate]['out']) && $timings[$cDate]['out'] != '00:00:00'){
												$earlyMin = round((strtotime("19:00") - strtotime($timings[$cDate]['out']))/60);
												echo get_display_time_from_min($earlyMin);
											}else{
												echo "00:00";
											}
										echo "</td>";
										
										echo "<td>";
											if($timings[$cDate]['out'] != '00:00:00'){
												$overMin = round((strtotime($timings[$cDate]['out']) - strtotime($timings[$cDate]['in']))/60);
												$overMin = $overMin - 540; //Reduce 9 hours from total hours to calculate OT
												if($overMin > 0)
													echo get_display_time_from_min($overMin);
												else
													echo "00:00";
											}else{
												echo "00:00";
											}
										echo "</td>";
										
										echo "<td>";
											if($timings[$cDate]['out'] != '00:00:00'){
												$totalHoursTmp[] = $hours = intval($timesheets[date('Y-m-d',strtotime($tmp))]/60);
												$totalMinsTmp[] = $minutes = $timesheets[date('Y-m-d',strtotime($tmp))] - ($hours * 60);
												echo sprintf("%02d",$hours).":".sprintf("%02d",$minutes);
											}else{
												echo "00:00";
											}
										echo "</td>";		
				
									}else{
										echo "<td>-</td>";		
										echo "<td>-</td>";		
										echo "<td>-</td>";		
										echo "<td>-</td>";		
										echo "<td>-</td>";		
										echo "<td>-</td>";		
										echo "<td>-</td>";		
									}
										
									
										
										
									echo "</tr>";
								}


								echo "<td colspan='6'></td>";		
								echo "<td>";
									if(isset($totalHoursTmp) && isset($totalMinsTmp)){
										$totalHoursTmp = array_sum($totalHoursTmp);
										$totalMinsTmp = array_sum($totalMinsTmp);
										$totalHoursTmp = $totalHoursTmp + floor($totalMinsTmp / 60);
										$totalMinsTmp = $totalMinsTmp % 60;

										echo sprintf("%02d",$totalHoursTmp).":".sprintf("%02d",$totalMinsTmp);
									}
								echo "</td>";	

							
							?>
                        
						
							
                        
						
                      </tbody>
                    </table>
					
					<?php
					}
					?>
				
            </div>      
		</div>      
		</div>      
	</div>      
 <br />

</div>
<!-- /page content -->

<script>
$(document).ready(function(){
	$(".datepicker").datepicker({
		dateFormat: "dd-mm-yy"
	});
	
	$("#getReport").click(function(){
		   employee = $("#employee").val();
		   start_date = $("#start_date").val();
		   end_date = $("#end_date").val();
		   
		   window.location.href = "<?php echo base_url(); ?>reports/employeeInOut/"+employee+"/"+start_date+"/"+end_date;
	});
});
</script>