<meta charset="utf-8">

<meta name="viewport" content="width=device-width initial-scale=1.0">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="description" content="Browse Vehicles">

<title>All Vehicles</title>

<link rel="icon" type="image/png" href="images/caricon.png">

<link rel="stylesheet" type=text/css href="styles/main.css">

<link rel="stylesheet" type="text/css" href="styles/bootstrap4/bootstrap.min.css">

<link rel="stylesheet" type="text/css" href="styles/util.css">

<link rel="stylesheet" type="text/css" href="styles/style.css">

<link rel="stylesheet" type="text/css" href="styles/table.css">

<script type="text/javascript" src="http://code.jquery.com/jquery-1.10.1.min.js"></script>

<?php session_start(); ?>

<header>

<div id="logo"><a><img src="images/logo.png"></a></div>

<nav>

<ul>

<?php

if(isset($_SESSION['customer']))

{

echo '<li><a href="logout.php">Logout</a></li>';

echo '<li><a href="custAccount.html" style=text-decoration:none;>Welcome ' . $_SESSION['fname'] . '</a></li>';

} else if(isset($_SESSION['wsmanager']) || isset($_SESSION['ldmanager1']) || isset($_SESSION['ldmanager2']) || isset($_SESSION['salesrep1']) || isset($_SESSION['salesrep2']))

{

echo '<li><a href="logout.php">Logout</a></li>';

echo '<li><a href="empAccount.html" style=text-decoration:none;>Welcome ' . $_SESSION['fname'] . '</a></li>';

} else

{

echo '<li>';

echo '<a style=color:red;>Sign In</a>';

echo '<ul class="dropdown">';

echo '<li><a href="signIn.html">Customers</a></li>';

echo '<li><a href="empSignin.html">Employees</a></li>';

echo '</ul>';

echo '</li>';

echo '<li><a href="registerPage.html">Register</a></li>';

}

?>

<li><a>|</a></li>

<li><a href="contactUs.html">Contact Us</a></li>

<li><a href="tabVehicles.html">Vehicles</a></li>

<li><a href="tabPackages.html">Packages</a></li>

<li><a href="tabRebates.html">Rebates</a></li>

<li><a href="index.html">Home</a></li>

</ul>

</nav>

<div class="services">

<div class="container">

<div class="row">

<div class="col text-center">

<div class="section_title">View All Vehicles</div>

<div class="section_subtitle">Search for the perfect one</div>

</div>

</div>

</div>

</div>

</header>

<!-- Cars in the database for dealer -->

<?php

$dbconnect = mysqli_connect("127.0.0.1", "root", "", "globalviews");

$query = "SELECT serial_no, color, warehouse, rebate, dealer, model.model, model.price, model.type, model.gas_mileage,

model.seat, model.engine FROM available_auto

INNER JOIN model ON globalviews.available_auto.model = globalviews.model.model";

$output = $dbconnect->query($query);

if($_SERVER["REQUEST_METHOD"] == "POST")

{

//collect value of search input fields

$color = $_POST['color'];

$model = $_POST['model'];

$mileage = $_POST['gas_mileage'];

$seat = $_POST['seat'];

$engine = $_POST['engine'];

$min = $_POST['min_price'];

$max = $_POST['max_price'];

if(isset($_POST['column']))

{

//collect value of sort input fields

$column = $_POST['column'];

}

if(isset($_POST['order']))

{

$order = $_POST['order'];

}

$query = "SELECT serial_no, color, warehouse, rebate, dealer, model.model, model.price, model.type, model.gas_mileage,

model.seat, model.engine FROM available_auto

INNER JOIN model ON globalviews.available_auto.model = globalviews.model.model";

$conditions = array();

$sort = array();

if(!empty($color))

{

$conditions[] = "color LIKE '%$color%'";

}

if(!empty($model))

{

$conditions[] = "model.model LIKE '%$model%'";

}

if(!empty($mileage))

{

$conditions[] = "gas_mileage LIKE '%$mileage%'";

}

if(!empty($seat))

{

$conditions[] = "seat LIKE '%$seat%'";

}

if(!empty($engine))

{

$conditions[] = "engine LIKE '%$engine%'";

}

if(!empty($min) && !empty($max))

{

$conditions[] = "model.price BETWEEN '$min' AND '$max'";

}

if(!empty($column) && !empty($order))

{

$sort[] = " ORDER BY $column $order";

} else if(!empty($column))

{

$sort[] = " ORDER BY $column";

}

$sql = $query;

if(count($conditions) > 0 && count($sort) > 0)

{

$sql .= " WHERE " . implode(' AND ', $conditions);

$sql .= implode(' ', $sort);

} else if(count($conditions) == 0 && count($sort) > 0)

{

$sql .= implode(' ', $sort);

} else

{

$sql .= " WHERE " . implode(' AND ', $conditions);

}

$output = $dbconnect->query($sql);

}

?>

<div class="limiter">

<div class="container-table100">

<div class="wrap-table100">

<form method="POST" action= "<?php echo $_SERVER['PHP_SELF'];?>">

<div style="text-align:right">

<span class="login100-form-title" style="display:inline-block;float:left;">Search:</span>

<div style="width:17%;display:inline-block;" class="wrap-input100">

<input class="input100" type="text" name="color" placeholder="Search Color">

<span class="focus-input100-1"></span>

<span class="focus-input100-2"></span>

</div>

<div style="width:17%;display:inline-block" class="wrap-input100">

<input class="input100" type="text" name="model" placeholder="Search Model">

<span class="focus-input100-1"></span>

<span class="focus-input100-2"></span>

</div>

<div style="width:17%;display:inline-block" class="wrap-input100">

<input class="input100" type="text" name="gas_mileage" placeholder="Search Gas Mileage">

<span class="focus-input100-1"></span>

<span class="focus-input100-2"></span>

</div>

<div style="width:17%;display:inline-block" class="wrap-input100">

<input class="input100" type="text" name="seat" placeholder="Search Seats">

<span class="focus-input100-1"></span>

<span class="focus-input100-2"></span>

</div>

<div style="width:17%;display:inline-block" class="wrap-input100">

<input class="input100" type="text" name="engine" placeholder="Search Engine">

<span class="focus-input100-1"></span>

<span class="focus-input100-2"></span>

</div>

</div>

<div style="text-align:right;margin-top:10px;">

<span class="login100-form-title" style="display:inline-block;float:left;">Filter:</span>

<div style="width:17%;display:inline-block" class="wrap-input100">

<input class="input100" type="" id="min" name="min_price" placeholder="Minimum Range">

</div>

<div style="width:17%;display:inline-block" class="wrap-input100">

<input class="input100" type="" id="max" name="max_price" placeholder="Maximum Range">

</div>

</div>

<div style="text-align:right;margin-top:10px;">

<span class="login100-form-title" style="display:inline-block;float:left;">Sort:</span>

<select style="width:17%;display:inline-block" class="wrap-input100" name="column">

<option value="" selected>Sort By</option>

<option value="price">Price</option>

<option value="gas_mileage">Gas Mileage</option>

<option value="engine">Engine</option>

<option value="color">Color</option>

<option value="model">Model</option>

<span class="focus-input100-1"></span>

<span class="focus-input100-2"></span>

</select>

<select style="width:17%;display:inline-block" class="wrap-input100" name="order">

<option value="" selected>Order By</option>

<option value="DESC">High to Low</option>

<option value="ASC">Low to High</option>

<option value="DESC">Z-A</option>

<option value="ASC">A-Z</option>

<span class="focus-input100-1"></span>

<span class="focus-input100-2"></span>

</select>

</div>

<input style="padding:10px;float:right;margin:10px 0px" type="submit" name="submit" value="Submit">

</form>

<br>

<?php if($output){ ?>

<div class="table100 ver2 m-b-110" style="margin-top:50px;">

<div class="table100-head">

<table>

<thead>

<tr class="row100 head">

<th class="cell100 column1">Serial No.</th>

<th class="cell100 column2">Model</th>

<th class="cell100 column3">Color</th>

<th class="cell100 column4">Warehouse</th>

<th class="cell100 column5">Dealership</th>

<th class="cell100 column6">Rebate<input style="margin-left:10px" type="checkbox" id="myCheck"></th>

<th class="cell100 column7">Price</th>

<th class="cell100 column8">Type</th>

<th class="cell100 column9">Gas Mileage</th>

<th class="cell100 column10">Seat</th>

<th class="cell100 column11">Engine</th>

</tr>

</thead>

</table>

</div>

<div class="table100-body js-pscroll ps ps--active-y">

<table>

<tbody>

<?php if(($output)){

while($result = mysqli_fetch_assoc($output)){ ?>

<tr class="row100 body">

<td class="cell100 column1"><?php echo $result['serial_no']?></td>

<td class="cell100 column2"><?php echo $result['model']?></td>

<td class="cell100 column3"><?php echo $result['color']?></td>

<td class="cell100 column4"><?php echo $result['warehouse']?></td>

<td class="cell100 column5"><?php echo $result['dealer']?></td>

<td class="cell100 column6"><?php echo $result['rebate']?></td>

<td class="cell100 column7"><?php echo $result['price']?></td>

<td class="cell100 column8"><?php echo $result['type']?></td>

<td class="cell100 column9"><?php echo $result['gas_mileage']?></td>

<td class="cell100 column10"><?php echo $result['seat']?></td>

<td class="cell100 column11"><?php echo $result['engine']?></td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

</div>

<?php } } else { ?>

<section>

<h1 style="margin-top:50px;" id="page_title">No Vehicles Available <?php echo $dbconnect->error?></h1>

</section>

<?php } ?>

</div>

</div>

</div>

<script>

$(document).ready(function () {

$('#myCheck').change( function() {

$('td:contains("No")').parent().toggle();

});

});

</script>

<footer>

<h3>All Rights Reserved, Copyright &copy; 2020</h3>

</footer>