1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / hrm.addobyte.com / application / views / reports /
Filename : projectBasedDailyHours.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>Project Based Timesheet </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">Project * :</label>
				  <select id="pid" class="form-control" name="pid" required>
						<option value="">Choose...</option>
						<?php
						if(isset($projects) && !empty($projects)){
							foreach($projects as $tmp){
								if(isset($pid) && $pid == $tmp->pid)
									echo "<option value='$tmp->pid' selected>".($tmp->name)."</option>";
								else
									echo "<option value='$tmp->pid'>".($tmp->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($timesheets) && !empty($timesheets)){
				?>				
				<table id="" class="table table-striped table-bordered">
                      <thead>
					  
					  
						<tr>
							<th width="14%">Date</th>						
							<th width="10%">Hours</th>						
							<th width="10%">Mins</th>						
						</tr>
					  
                    
						
                      </thead>


                      <tbody>
					
						
							<?php
									foreach($timesheets as $tmp){
										
										$hours[] = $tmp->hour;
										$mins[] = $tmp->mins;
										
										echo "<tr>";											
											echo "<td>".date('d-m-Y',strtotime($tmp->date))."</td>";
											echo "<td>".($tmp->hour + floor($tmp->mins/60))."</td>";
											echo "<td>".($tmp->mins%60)."</td>";
										echo "</tr>";
									}
								
							?>                        
							<tr style='font-size:16px; color:blue;'>
								<td align="right">Total Duration</td>
								
								<?php
								$balMin = array_sum($mins)%60;
								if(array_sum($mins) < 60)
									$balHour = 0;
								else
									$balHour = floor(array_sum($mins)/60);
								echo "<td>".sprintf("%02d",array_sum($hours) + $balHour)."</td><td>".sprintf("%02d",$balMin)."</td>";
								?>
								
							</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(){
		   pid = $("#pid").val();
		   start_date = $("#start_date").val();
		   end_date = $("#end_date").val();
		   
		   window.location.href = "<?php echo base_url(); ?>reports/projectBasedDailyHours/"+pid+"/"+start_date+"/"+end_date;
	});
});
</script>