<?php $pageno = 3; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<?php include('template/head.php'); ?>
	<link rel="stylesheet" href="<?php echo base_url(); ?>assets/datepicker/jquery-ui.css" />
	<!--<script src="<?php echo base_url(); ?>assets/datepicker/jquery-1.9.1.js"></script>-->
	<script src="<?php echo base_url(); ?>assets/datepicker/jquery-ui.js"></script>
	<script type="text/javascript">
	$(function() {
		$( "#datepicker" ).datepicker({ dateFormat: "yy-mm-dd" }).val();
		$( "#datepicker1" ).datepicker({ dateFormat: "yy-mm-dd" }).val();
	});
	</script>
	<!--DATA TABLE --> 
    <script type="text/javascript" src="<?php echo base_url(); ?>assets/data_table/js/jquery.dataTables.js"></script>
    <link href="<?php echo base_url(); ?>assets/data_table/css/demo_table_jui.css" rel="stylesheet" type="text/css"/>
    <link href="<?php echo base_url(); ?>assets/data_table/css/jquery-ui-1.8.4.custom.css" rel="stylesheet" type="text/css"/>
    <!--DATA TABLE -->   
    <script type="text/javascript" charset="utf-8">
	$(document).ready(function(){
		$('#datatables').dataTable({
			"sPaginationType":"full_numbers",
			"iDisplayLength": 100,
			"aaSorting":[[0, "asc"]],
			"bJQueryUI":true
		});
	});
    </script> 
	<script type="text/javascript">
	function ValidateForm(){
		var from=document.forms["frmUsers"]["from"].value;
		if (from==null || from=="")
			{
				alert("Please Enter From Date");
				return false;
			}
		var day=document.forms["frmUsers"]["to"].value;
		if (to==null || to=="")
			{
				alert("Please Enter To Date");
				return false;
			}
	}
	</script>
</head>
<body>
<?php include('template/header.php'); ?> 
<div class="grid_16" id="navheader">
	<?php include('template/topnav.php'); ?>
</div>
<div class="grid_16" id="tabs">
	<div class="container">
		<ul>
			<li><a href="<?php echo base_url(); ?>index.php/Administrator/CabsList/"  ><span>Master Details</span></a></li> 
			<li><a href="<?php echo base_url(); ?>index.php/Administrator/CabDayReport/" ><span>Day Report</span></a></li>
			<li><a href="<?php echo base_url(); ?>index.php/Administrator/CabReport/" ><span>Month Report</span></a></li>
			<li><a href="<?php echo base_url(); ?>index.php/Administrator/CabConsolidatedReport/" ><span>Consolidated Report</span></a></li>
		</ul>
	</div>   
</div>
<div class="container_16" id="wrapper">	
    <div class="grid_16" id="content"> 
		<div class="grid_9">
			<h1 class="reports">Detailed Cab Report</h1>
		</div>
		<div class="grid_15" id="textcontent">
			<div id="table">
				<div id="user_profile_main_div">
					<div id="message">
					<?php 
					if($this->session->flashdata('flsh_msg')) {
						?><p id="success" class="info"><span class="info_inner"><?php echo $this->session->flashdata('flsh_msg'); ?></span></p> <?php
					} 
					if($this->session->flashdata('flsh_msg1')) {
						?><p id="error" class="info"><span class="info_inner"><?php echo $this->session->flashdata('flsh_msg1'); ?></span></p> <?php
					} 
					?>
					</div>
					<div class="clear"></div>
					<form action="<?php echo base_url(); ?>index.php/Administrator/IndivisualCabReports/" method="post" enctype="multipart/form-data" name="frmUsers" id="frmTransaction" onSubmit="return ValidateForm()">
						<table style="float: right;">
							<tr>
								<?php foreach ($query as $row) { $tagid = $row->tag_id; } ?>
								<input type="hidden" class="input" name="tag_id"  value="<?php echo $tagid; ?>"/>
								<td align="right" colspan="9">
									<input type="text" class="smallInput" name="from"  value="" placeholder="Date From" id="datepicker"/>
									<input type="text" class="smallInput" name="to"  value="" placeholder="Date To" id="datepicker1"/>
									<span class="button">
										<input name="showresult" class="buttoncc" type="submit" id="delete" value="Show">
									</span>
									<span class="button">
										<input name="savereport" class="buttoncc" type="submit" id="delete" value="save as excel">
									</span>
								</td>
							</tr>
						</table>
					</form>	
					<table id="datatables" class="display">
						<thead>
							<tr>
								<th>Sno</th>
								<th>Tag Id</th>
								<th>Time In</th>
								<th>Time Out</th>
								<th>Total Stay Time</th>
								<th>Vehicle Number</th> 
								<th>Vehicle Type</th>
								<th>Vendor Name</th>
							</tr>
						</thead>
						<tbody>
							<?php
							$i=0;
							//echo "<pre>"; print_R($query); die;
							foreach ($query as $row)
							{
								$i++;
								$proid  = $row->vehicle_id;
							?>
							<tr>
								<td><?php echo $i;?></td>
								<td><?php echo $row->tag_no; ?></td>
								<td><?php echo $row->time_in; ?></td>
								<td>
									<?php 
									if($row->time_out == '2010-01-01 01:01:01'){
										echo "AUTU OUT";
									} else {
										echo $row->time_out;
									} 
									?>
								</td>
								<td>
									<?php
									$time_in = new DateTime($row->time_in);
									$time_out = new DateTime($row->time_out);
									$difference = $time_in->diff($time_out);
									if($row->time_out == ''){	
										echo " ";	
									}
									else if($row->time_out == '2010-01-01 01:01:01'){	
										echo "--";	
									}
									else{	
										echo format_interval($difference);	
									}
									?>
								</td>
								<td>
									<a href="<?php echo base_url(); ?>index.php/Administrator/vehicledetailscab/<?php echo $proid; ?>" title="View" class="ajax"><?php echo $row->vehicle_number; ?></a>
								</td>
								<td><?php echo $row->cab_type; ?></td>
								<td><?php echo $row->vender; ?></td>
							</tr>
							<?php
							}
							//----------------Relationship-------------------//
							$total = $i;
							$fromdate = $from['0'];
							$todate = $from['1'];
							$vehicletype = "Cab";
							echo TagRelationshipCab($tagid,$fromdate,$todate,$vehicletype,$total);
							//----------------Relationship-------------------//
							?>
						</tbody>
					</table>
				</div>
			</div>
		</div>
		<div class="clear"> </div>		
	</div>
</div>
<?php include('template/footer.php'); ?>
</body>
</html>