executeQuery('SELECT CODIGO FROM VEHICULOS_STOCKS WHERE ALIAS = ?', 's', [$stock])->fetch_assoc();//Get the stock id with alias if($stockID['CODIGO']) { $headers = apache_request_headers(); $dev = []; if(isset($_POST['remove'])) {//Desactivar vehiculo en las BBDD $remove = Statics::SafeInput($bd_conn, $_POST['remove']); $res = $Schema->executeQuery('SELECT CODIGO, MOSTRAR, BASTIDOR FROM VEHICULOS WHERE STOCK = ? AND BASTIDOR = ?', 'is', [$stockID['CODIGO'], $chassis]); if($res->num_rows) { $wsCar = $res->fetch_assoc(); if($remove === 'Remove::') {//Only if has this value $data['status'] = 'Successful'; $data['message'] = 'Car removed'; $MotherCar->set_codigo_vehiculo_tabla_vehiculos($wsCar['CODIGO']); $MotherCar->set_activo(0); $MotherCar->update_vehiculo(); $MotherCar->set_tipo_precios_extra(1); $MotherCar->set_limite_precios_extra(date('Y-m-d H:i:s')); $MotherCar->update_precios_extra(); $MotherCar->set_activo_link(0); $MotherCar->update_links(); $MotherCar->update_portal(true); Statics::add_trace_history($bd_conn, $headers['Client-Id'], $MotherCar->get_codigo_vehiculo_tabla_vehiculos(), 4, 'servMultiPost'); } else { $data['status'] = 'Fail'; $data['message'] = 'Car unable to remove, incorrect value'; } $dev['devs']['car_key'] = $wsCar['CODIGO']; $data['car'] = ['car_name' => $wsCar['MOSTRAR'], 'car_chassis' => $wsCar['BASTIDOR']]; } else { $data['status'] = 'Fail'; $data['message'] = 'Car not found'; } } else { if(isset($_POST['car_brand']) && isset($_POST['car_model'])) { $data['status'] = 'Successful'; $brand = !empty($_POST['car_brand']) ? Statics::SafeInput($bd_conn, $_POST['car_brand']) : '[DESCONOCIDA]'; $model = !empty($_POST['car_model']) ? Statics::SafeInput($bd_conn, $_POST['car_model']) : '[DESCONOCIDA]'; $car_version = !empty($_POST['car_version']) ? Statics::SafeInput($bd_conn, $_POST['car_version']) : ''; $car_fuel = !empty($_POST['car_fuel']) ? Statics::SafeInput($bd_conn, $_POST['car_fuel']) : ''; $car_gearbox = !empty($_POST['car_gearbox']) ? Statics::SafeInput($bd_conn, $_POST['car_gearbox']) : ''; $car_emissions = !empty($_POST['car_emissions']) ? Statics::SafeInput($bd_conn, $_POST['car_emissions']) : ''; $car_color = !empty($_POST['car_color']) ? Statics::SafeInput($bd_conn, $_POST['car_color']) : ''; $enrollment_date = !empty($_POST['enrollment_date']) ? date('Y-m-d', strtotime(Statics::SafeInput($bd_conn, $_POST['enrollment_date']))) : 'asd'; $car_year = !empty($_POST['car_year']) ? Statics::SafeInput($bd_conn, $_POST['car_year']) : 0; $eurotax = !empty($_POST['eurotax']) ? Statics::SafeInput($bd_conn, $_POST['eurotax']) : 0; $car_km = !empty($_POST['car_km']) ? Statics::SafeInput($bd_conn, $_POST['car_km']) : 0; $financed_price = !empty($_POST['financed_price']) ? Statics::SafeInput($bd_conn, $_POST['financed_price']) : 0; $special_price = !empty($_POST['special_price']) ? Statics::SafeInput($bd_conn, $_POST['special_price']) : 0; $special_financed_price = !empty($_POST['special_financed_price']) ? Statics::SafeInput($bd_conn, $_POST['special_financed_price']) : 0; $car_note = !empty($_POST['car_note']) ? Statics::SafeInput($bd_conn, $_POST['car_note']) : NULL; $enrollment = !empty($_POST['enrollment']) ? Statics::SafeInput($bd_conn, $_POST['enrollment']) : false; $enrollmentTitle = !empty($_POST['enrollment']) ? ' - ' . $enrollment : false; if(isset($_POST['portal_alias'])) { if(!empty($_POST['portal_alias'])) { $portal_alias = strtoupper(Statics::SafeInput($bd_conn, $_POST['portal_alias'])); $portal_info = $MotherCar->select_portal($portal_alias); if($portal_info) { include_once "includes/includeMultiPost.php"; } else { $data['status'] = 'Error'; $data['portal'] = 'Portal not found'; } } else { $data['status'] = 'Error'; $data['message'] = 'Portal empty'; } } else { $data['status'] = 'Fail'; $data['message'] = 'Undefined portal'; } if(isset($_POST['dev'])) {//Para mostrar datos internos $devKey = Statics::SafeInput($bd_conn, $_POST['dev']); if($devKey === 'DevInfo::') { $data = array_merge($data, $dev); } } } else { $data['status'] = 'Fail'; $data['message'] = 'Undefined car brand and model'; } } } else { $data['status'] = 'Fail'; $data['message'] = 'Undefined stock ' . $stock; } } else { $data['status'] = 'Fail'; $data['message'] = 'Stock ,chassis and price are required'; } } else { $data['status'] = 'Error'; $data['message'] = 'Stock ,chassis and price are required'; } } else { $data['code'] = 'unauthorized_client'; $data['message'] = 'Invalid authorization token'; } header("Content-type: application/json; charset=utf-8"); echo json_encode($data); ?>