<?php $pageno = 2; ?>
<!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/BusesList/" ><span>Master Details</span></a></li>
			<li><a href="<?php echo base_url(); ?>index.php/Administrator/BusDayReport/"  class="current" ><span>Day Report</span></a></li>
			<li><a href="<?php echo base_url(); ?>index.php/Administrator/BusReport/" ><span>Month Report/Bus</span></a></li>
			<li><a href="<?php echo base_url(); ?>index.php/Administrator/BusReport/" ><span>Month Report/Route</span></a></li>
		</ul>
	</div>   
</div>
<div class="container_16" id="wrapper">	
    <div class="grid_16" id="content"> 
		<div class="grid_9">
			<h1 class="user">Buses Day 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/BusDayReport/" method="post" enctype="multipart/form-data" name="frmUsers" id="frmTransaction" onSubmit="return ValidateForm()">
					<table style="float: right;">
						<tr>
							<td align="right" colspan="9">
								<select name="vehicleid" id="clientid" class="smallInput" >
								<option value="">Select Vehicle</option>
								<?php
									foreach ($result as $fatchrow)
									{ 
										?><option value="<?php echo $fatchrow->tag_id; ?>"><?php echo $fatchrow->vehicle_number; ?></option><?php 
									} 
								?>
								</select>
								<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>Vehicle Number</th> 
								<th>Route No.</th>
								<th>Route Name</th>
							</tr>
						</thead>
						<tbody>
							<?php
							$i=0;
							//echo "<pre>"; print_R($query); die;
							foreach ($query as $row)
							{
								$i++;
								$proid  = $row->route_bus_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') || ($row->time_out == '2009-12-31 19:31:01') || ($row->time_out == '') ){
										echo "AUTO OUT";
									} else {
										echo $row->time_out;
									} 
									?>
								</td>
								<td>
									<a href="<?php echo base_url(); ?>index.php/Administrator/VehicleDetails/<?php echo $proid; ?>" class="ajax"><?php echo $row->vehicle_number; ?></a>
								</td>
								<td><?php echo $row->id; ?></td>
								<td><?php echo $row->route_details; ?></td>
							</tr>
							<?php
							}
							?>
						</tbody>
					</table>
				</div>
			</div>
		</div>
		<div class="clear"> </div>		
	</div>
</div>
<?php include('template/footer.php'); ?>
</body>
</html>