<?php 
include 'core/database/connect.php';
//$connect_error = 'Sorry, we\'re experiencing connection problem.  Please try again later...  Thank you!';
//mysql_connect('localhost','root','aee1024') or die ($connect_error);
//mysql_select_db('db_vts') or die($connect_error);
 
$toDate = date_create() ->format("Y/m/d");
$toTime =Explode(":", date('H:i:s'));
error_reporting(0);
	 
	//if submit/ save to database	
	if(isset($_POST['done'])){
		$vDateReceived = mysql_escape_string($_POST['vDateReceived']);
		$vVINNumber = mysql_escape_string($_POST['vVINNumber']);
		$vEngineNo = mysql_escape_string($_POST['vEngineNo']);
		$vDescripton = mysql_escape_string($_POST['vDescripton']);
		$vStatus = mysql_escape_string($_POST['vStatus']);
		$myBrand = mysql_escape_string($_POST['myBrand']);
		$invModel = mysql_escape_string($_POST['invModel']);
		$yearModel = mysql_escape_string($_POST['yearModel']);
		$vColor = mysql_escape_string($_POST['vColor']);
		$vLocation = mysql_escape_string($_POST['vLocation']);
		$vAllocation = mysql_escape_string($_POST['vAllocation']);
		$vCSNumber = mysql_escape_string($_POST['vCSNumber']);
		if($vStatus === 'Incoming'){
		$incoming = 1;
		}else {
		$incoming = 0;
		}
		 mysql_query("INSERT INTO db_vehicle_inventory (brand, brand_code, cs_number,year_model,description,color,vin_number,engine_code,date_received,unit_location,selling_dealer,status,incoming_unit)
		VALUES('{$myBrand}','{$invModel}','{$vCSNumber}','{$yearModel}','{$vDescripton}','{$vColor}','{$vVINNumber}','{$vEngineNo}','{$vDateReceived}','{$vLocation}','{$vAllocation}','{$vStatus}','{$incoming}')");
		echo "ADDITIONAL UNIT HAS BEEN ADDED TO YOUR INVENTORY";
		exit();
	}
?>