<?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);
error_reporting(1);
//echo "Connected";
$userID=$user_data['u_id'];
$myCurTime=$currentTime;
$dealID= $user_data['dealer'];
$compID= $user_data['company']; 
$toDate = date_create() ->format("Y/m/d");  
	//if submit/ save to databasevar   
	if(isset($_POST['done'])){		
		$myPlate = mysql_escape_string($_POST['updateApptPlate']);			 
			$vPlateA =  str_replace(' ', '', $myPlate);		 
			$plate = str_replace('-', '', $vPlateA);
		$kmReading = mysql_escape_string($_POST['Mileage']);
		$location = mysql_escape_string($_POST['para']);
		$addBy =  mysql_escape_string($_POST['addBy']);
		$addDate = mysql_escape_string($_POST['addDate']);
		$dealerID = mysql_escape_string($_POST['MydealID']);
		$companyCode = mysql_escape_string($_POST['MycompID']);
		$addTime = mysql_escape_string($_POST['addTime']);
		$checkInOutSelect = mysql_escape_string($_POST['checkInOutSelect']);
		$chkIfPlateExist = mysql_result(mysql_query("SELECT COUNT('v_id') FROM `vts_vehicle_lists` WHERE `v_plate`='$plate' || `v_conduction`='$plate'"),0);
			if($chkIfPlateExist == 0){ //PLATE NOT FOUND
				 mysql_query("INSERT INTO vts_in_out_history (chk_plate, chk_km, chk_transaction, comp_code,dealer_code,location_code, time, date, user_id)
				VALUES('{$plate}','{$kmReading}','{$checkInOutSelect}','{$companyCode}','{$dealerID}','{$location}','{$addTime}','{$addDate}','{$addBy}')");
				if($checkInOutSelect==='IN'){ //CHECKIN BUT NO RECORDS FOUND
					//============================================================
					if($location== 3 || $location == 6){ // CHECK IF APPT OR WALKIN
						mysql_query("INSERT INTO vts_service_transaction (s_arrived_date, s_arrived_time, s_v_plate, s_comp_code, s_deal_code, s_appt_type,s_date,s_time,appt_date,time_slot_code)
						VALUES('{$addDate}','{$addTime}','{$plate}','{$companyCode}','{$dealerID}','XX','{$addDate}','{$addTime}','{$addDate}','1')");
						//ADD RECCORDS TO VEHICLE LIST WITH LIMITED INFORMATION ONLY
						}else{ //INSERT VEHICLE RECORD FOR MONITORING ONLY`
							mysql_query("INSERT INTO vts_vehicle_lists (v_plate, v_conduction, v_in_out, v_location_id, action_id)
							VALUES('{$plate}','{$plate}','1','{$dealerID}','{$location}')");	
						}
					//============================================================
				}
			}else{
				
				mysql_query("INSERT INTO vts_in_out_history (chk_plate, chk_km, chk_transaction, comp_code,dealer_code,location_code, time, date, user_id)
				VALUES('{$plate}','{$kmReading}','{$checkInOutSelect}','{$companyCode}','{$dealerID}','{$location}','{$addTime}','{$addDate}','{$addBy}')");
				
				$chkIfPlateExist = mysql_result(mysql_query("SELECT COUNT('S_id') FROM `vts_service_transaction` WHERE `s_v_plate`='$plate' || `s_conduction`='$plate'"),0);
				if($chkIfPlateExist == 0){ //PLATE NOT FOUND IN SERVICE APPOINTMENT RECORDS BUT IN THE VEHICLE LIST DATABASE
					mysql_query("INSERT INTO vts_service_transaction (s_arrived_date, s_arrived_time, s_v_plate, s_comp_code, s_deal_code, s_appt_type,s_date,s_time,appt_date,time_slot_code)
						VALUES('{$addDate}','{$addTime}','{$plate}','{$companyCode}','{$dealerID}','XX','{$addDate}','{$addTime}','{$addDate}','1')");
				}else{
					mysql_query("UPDATE `vts_service_transaction` SET `s_arrived_date`='$addDate',`s_arrived_time`='$addTime'  WHERE `s_arrived_time`='' AND `s_v_plate`='$plate' AND `s_comp_code`='$companyCode' AND `s_deal_code`='$dealerID' AND `service_status`='0' || `s_arrived_time`='' AND `s_v_plate`='$plate' AND `transferred_to`='$dealerID' AND `service_status`='0'");	
				}
				if($checkInOutSelect==='IN'){
					mysql_query("UPDATE `vts_vehicle_lists` SET `v_in_out`='1',`v_location_id`='$dealerID',`action_id`='$location' WHERE `v_plate`='$plate'");
				}else{
					mysql_query("UPDATE `vts_vehicle_lists` SET `v_in_out`='0',`v_location_id`='0',`action_id`='$location' WHERE `v_plate`='$plate'");
					mysql_query("UPDATE `vts_in_out_history` SET `tag_as_out`='OUT' WHERE `chk_plate`='$plate' AND `tag_as_out`=''");
				}
			}
			
			exit();
		 
	}
	if(isset($_POST['display'])){	
		$addDate = mysql_escape_string($_POST['addDate']);
		$getApptSum = mysql_query("SELECT * FROM `vts_service_transaction` WHERE `appt_date` = '$toDate' ORDER BY `time_slot_code` ASC");
			 echo "<table id='apptSummary' style='width:100%'>";
			 echo "<thead>";
				echo "<tr class='tablehead'>
					<th class='bgBlue;font-color:black;width:15%'>REC.NO</th>
					<th class='bgBlue;font-color:black;width:15%'>V. Plate</th>
					<th class='bgBlue;font-color:black;width:15%'>RO #</th>
					<th class='bgBlue;font-color:black;width:40%'>V. Brand</th>
					<th class='bgBlue;font-color:black;width:40%'>V. Model</th>
					<th class='bgBlue;font-color:black;width:15%'>Type </th>
					<th class='bgBlue;font-color:black;width:10%'>Appt. Date </th>
					<th class='bgBlue;font-color:black;width:10%'>Arrived Time </th>					 
					<th class='bgBlue;font-color:black;width:10%'>Current Status </th> 					
				</tr>
			</thead>"; 				
			while($row=mysql_fetch_array($getApptSum)){
				if($row['s_ro_no']===''){
					$tColor="red";
				}else{
					$tColor="black";
				}
				if($row['s_arrived_time']==''){
					$status="Waiting";
				}else{
					$status="Arrived";
				}
				$brandName=mysql_result(mysql_query("SELECT `v_brand` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0);
				$modelName=mysql_result(mysql_query("SELECT `v_model` FROM `vts_vehicle_lists` WHERE `v_plate`='".$row['s_v_plate']."'"),0);
				echo "<tr>";
					echo "<td style='font-size:12px;color:$tColor'>".$row['s_id']."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$row['s_v_plate']."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$row['s_ro_no']."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$brandName."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$modelName."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$row['s_appt_type']."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$row['appt_date']."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$row['s_arrived_time']."</td>";
					echo "<td style='font-size:12px;color:$tColor'>".$status."</td>";
				echo "</tr>";
			}
			echo "</table>";
	}
?>