<?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'])){
		$deliveryComment = mysql_escape_string($_POST['deliveryComment']);
		$selectedCS = mysql_escape_string($_POST['selectedVIN']);
		$EditRecordID = mysql_escape_string($_POST['EditRecordID']); 
		$empID = mysql_escape_string($_POST['empID']); 
		mysql_query("UPDATE `db_vehicle_inventory` SET `incoming_unit` = '0', `status` = 'Available', `date_received`='$toDate' WHERE `id`='$EditRecordID'");	
		
		//====================================INSERT LOGS TO vts_vehicle_delivery_logs=================================================================================================================
	   	 mysql_query("INSERT INTO vts_vehicle_delivery_logs (cs, notes, encoded_by)
				VALUES('{$selectedCS}','{$deliveryComment}','{$empID}')");
		echo "UNIT HAS BEEN ADDED TO YOUR INVENTORY";
		exit();
	}
?>