File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/vehicle/vehiclev2.php

Back
<?php include_once("../../cfg/db.php"); include_once("../controllers/vehicle.php"); include_once("../controllers/utility.php"); include_once("../controllers/brand.php"); include_once("../controllers/model.php"); include_once("../controllers/color.php"); include_once("../controllers/customer.php"); include_once("../controllers/type.php"); include_once("../controllers/insurance.php"); include_once("../controllers/insurance_type.php"); include_once("../controllers/company_dealer.php"); include_once("../controllers/finance.php"); include_once("../controllers/group_manager.php"); include_once("../controllers/sales_consultant.php"); include_once("../controllers/sales.php"); include_once("../controllers/logger.php"); $vehicle = new Vehicle(); $utility = new Utility(); $color = new Color(); $model = new Model(); $brand = new Brand(); $customer = new Customer(); $company_dealer = new CompanyDealer(); $vehicle_type = new Type(); $insurance_company = new Insurance(); $insurance_type = new InsuranceType(); $finance_company = new Finance(); $group_manager = new GroupManager(); $sales_consultant = new SalesConsultant(); $sales = new Sales(); $logger = new Logger(); if (!isset($_SESSION['user']['id'])) { echo "Session Expired."; exit; } $my_customer_record_id = $_SESSION['user']['id']; $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1'; $fields_permissions = isset($_SESSION['user']['fields_permissions']['customer_fields']) ? $_SESSION['user']['fields_permissions']['customer_fields'] : false; $server_method = $_SERVER["REQUEST_METHOD"]; if (isset($_REQUEST['apiKey'])) { $apiKey = $_REQUEST['apiKey']; if ($apiKey === '6168105105517357' && $utility->isPostMethod($server_method)) { //Create $vehicle_id = $utility->generate_uuid($db); // $sale_id = $utility->generate_uuid($db); $vehicle_data = isset($_REQUEST['vehicle_data']) ? $_REQUEST['vehicle_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $plate_number = $utility->alphaNumericOnly($vehicle_data_array['mod-plate-number']); $conduction_sticker = $utility->alphaNumericOnly($vehicle_data_array['mod-cs-number']); $company_dealer_id = $company_dealer->read_company_dealer_id($vehicle_data_array['mod-dd-company'], $vehicle_data_array['mod-dd-dealer'], '1', $db); //validations if ($vehicle->read_vehicle_by_conduction_sticker($conduction_sticker, $db) > 0) { $return_arr["status"] = 3; $return_arr["message"] = "Duplicate vehicle record conduction sticker"; echo json_encode($return_arr); exit; } if ($utility->isNotEmpty($plate_number)) { if ($vehicle->read_vehicle_by_plate_number($plate_number, $db) > 0) { $return_arr["status"] = 4; $return_arr["message"] = "Duplicate vehicle record plate number"; echo json_encode($return_arr); exit; } } $color_name = ($vehicle_data_array["mod-dd-color"]); if ($utility->isNotEmpty($color_name)) { $color_id = $color->read_color_id_by_name($color_name, $db); if (!$utility->isNotEmpty($color_id)) { $color_id = $color->create_color($color_name, $db); } } else { $color_id = 0; } $model_variant_name = ($vehicle_data_array["mod-dd-model-variant"]); if ($utility->isNotEmpty($model_variant_name)) { $model_variant_id = $model->read_model_variant_id_by_name($model_variant_name, $vehicle_data_array['mod-dd-model'], $db); if (!$utility->isNotEmpty($model_variant_id)) { $model_variant_id = $model->create_model_variant($model_variant_name, $vehicle_data_array['mod-dd-model'], $db); } } else { $model_variant_id = 0; } $additional_array_data['or'] = $utility->alphaNumericOnly($vehicle_data_array['mod-or']); $additional_array_data['cr'] = $utility->alphaNumericOnly($vehicle_data_array['mod-cr']); $insert_vehicle = $vehicle->create_vehicle( $vehicle_id, '', //$customer_dms_id, $vehicle_data_array['mod-customer-number'], $color_id, $vehicle_data_array['mod-engine-type'], $vehicle_data_array['mod-gas-type'], $vehicle_data_array['mod-dd-brand'], $vehicle_data_array['mod-dd-model'], $vehicle_data_array['mod-model-number'], $model_variant_id, $plate_number, '', //$chassis_number, '', //$serial_number, $utility->alphaNumericOnly($vehicle_data_array['mod-vin-number']), $conduction_sticker, '', //$who_drives, '', //$purchase_car_as_id, '', //$delivery_date, $vehicle_data_array['mod-year-model'], $vehicle_data_array['mod-transmission'], $vehicle_data_array['mod-dd-type'], $vehicle_data_array['mod-reg-number'], '', //$release_number, $company_dealer_id, $_SESSION['user']['id'], '1', $additional_array_data, $db ); /* if ( $utility_class->isNotEmpty($plate_number) && $utility_class->isNotEmpty($additional_array_data['or']) && $utility_class->isNotEmpty($additional_array_data['cr']) ) { $orcrplate_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'orcr_plate', $db); $orcr_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'orcr', $db); $plate_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'plate', $db); if (!$orcrplate_exist) { if (!$orcr_exist && !$plate_exist) { $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'orcr_plate', $db); } else if (!$orcr_exist) { $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'orcr', $db); } else if (!$plate_exist) { $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'plate', $db); } } } else if ( $utility_class->isNotEmpty($additional_array_data['or']) && $utility_class->isNotEmpty($additional_array_data['cr']) ) { $orcr_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'orcr', $db); if (!$orcr_exist) { $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'orcr', $db); } }*/ $image_name = isset($_REQUEST['image_name']) ? $_REQUEST['image_name'] : array(); $image_name_array = array(); if (count($image_name) > 0) { foreach ($image_name as $image) { $image_name_array[] = "('$vehicle_id','" . $image . "')"; } $image_name_to_insert = implode(',', $image_name_array); $vehicle->insert_all_vehicle_image($image_name_to_insert, $db); } if (intval($vehicle_data_array['has-sales-record']) === 1) { $sale_id = $utility->generate_uuid($db); $vehicle_data = isset($_REQUEST['sales_data']) ? $_REQUEST['sales_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $insurance_company_name = ($vehicle_data_array["mod-dd-insurance-company"]); if ($utility->isNotEmpty($insurance_company_name)) { $insurance_company_id = $insurance_company->read_insurance_company_id_by_name($insurance_company_name, $db); if (!$utility->isNotEmpty($insurance_company_id)) { $insurance_company_id = $insurance_company->create_insurance_company($insurance_company_name, $db); } } else { $insurance_company_id = 0; } // echo $insurance_company_id;exit; $finance_company_name = ($vehicle_data_array["mod-dd-finance-company"]); if ($utility->isNotEmpty($finance_company_name)) { $finance_company_id = $finance_company->read_finance_company_id_by_name($finance_company_name, $db); if (!$utility->isNotEmpty($finance_company_id)) { $finance_company_id = $finance_company->create_finance_company($finance_company_name, $db); } } else { $finance_company_id = 0; } //DATE FORMATS $insurance_expiration_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-insurance-exp-date"])) { $insurance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-insurance-exp-date"], 'mm/dd/yyyy'); } $finance_expiration_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-finance-exp-date"])) { $finance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-finance-exp-date"], 'mm/dd/yyyy'); } $delivery_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-delivery-date"])) { $delivery_date = $utility->convert_sql_date($vehicle_data_array["mod-delivery-date"], 'mm/dd/yyyy'); } $sales_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-sales-date"])) { $sales_date = $utility->convert_sql_date($vehicle_data_array["mod-sales-date"], 'mm/dd/yyyy'); } $insert_vehicle_sales = $sales->create_vehicle_sales( $sale_id, '', //$customer_dms_id, $vehicle_id, '', //$conduction_sticker, '', //$plate_number, $utility->alphaNumericOnly($vehicle_data_array['mod-order-number']), '', //$floor_plan_amount, $sales_date, $vehicle_data_array['mod-sales-cost'], $vehicle_data_array['mod-sales-price'], $vehicle_data_array['mod-sales-discount'], $insurance_company_id, $vehicle_data_array['mod-dd-insurance-type'], $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $vehicle_data_array['mod-dd-source-of-sale'], '0', //$mode_of_contact_id, '', //$warehouse, '', //$stock_number, '', //$age_of_unit, '', //$body_size_code, '', //$claim_number, '', //$claim_amount, '', //$deal_number, '', //$deal_date, $vehicle_data_array['mod-dd-sales-consultant'], $vehicle_data_array['mod-driver'], $delivery_date, $vehicle_data_array['mod-dd-type-of-payment'], $vehicle_data_array['mod-dd-group-manager'], $company_dealer_id, '', //$purchase_car_as_id, $_SESSION['user']['id'], '1', //$status $vehicle_data_array['mod-end-user'], $vehicle_data_array['mod-dd-mode-of-sale'], $vehicle_data_array['mod-dd-group-manager-asa'], $vehicle_data_array['mod-dd-sales-consultant-asa'], $db ); $vehicle_brands_offered = isset($_REQUEST['vehicle_brands_offered']) ? $_REQUEST['vehicle_brands_offered'] : ''; $vehicle_brands_offered_array = array(); if ($vehicle_brands_offered <> '') { $vehicle_brands_offered = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_brands_offered); $vehicle_brands_offered = array_map(array($db, 'escape'), $vehicle_brands_offered); foreach ($vehicle_brands_offered as $offered) { $description = ($offered['Description']); $brands_offered_id = ($offered['Brand']); $model_offered_id = ($offered['Model']); // $model_offered_name = ($offered['Model']); // $model_offered_id = $model->read_model_id_by_name($model_offered_name, $db); $vehicle_brands_offered_array[] = "('$sale_id','" . $brands_offered_id . "', '" . $model_offered_id . "', '" . $description . "')"; } $vehicle_brands_offered_to_insert = implode(',', $vehicle_brands_offered_array); $sales->create_sales_brands_offered($vehicle_brands_offered_to_insert, $db); } } if ($insert_vehicle > 0) { $return_arr["status"] = 1; $return_arr["message"] = "Successfully inserted"; $log_desc = "Add vehicle: %s"; $logger->create( $_SESSION['user']['id'], sprintf( $log_desc, '[ID:' . $vehicle_id . ']' ), $vehicle_id, 'add_vehicle', $db ); } else { $return_arr["status"] = 0; $return_arr["message"] = "Record not inserted"; } // $return_arr["status"] = 1; // $return_arr["message"] = "Vehicle Data Inserted"; echo json_encode($return_arr); } else if ($apiKey === '4439864615669484' && $utility->isPostMethod($server_method)) { //Read Vehicle Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $db->escape($_REQUEST['vehicle_id']) : '-1'; $vehicle_data = isset($_REQUEST['vehicle_data']) ? $_REQUEST['vehicle_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $plate_number = $utility->alphaNumericOnly($vehicle_data_array['mod-plate-number']); $conduction_sticker = $utility->alphaNumericOnly($vehicle_data_array['mod-cs-number']); $company_dealer_id = $company_dealer->read_company_dealer_id($vehicle_data_array['mod-dd-company'], $vehicle_data_array['mod-dd-dealer'], '1', $db); //validations if ($vehicle->read_conduction_sticker_by_vehicle_id($vehicle_id, $db) <> $conduction_sticker) { if ($vehicle->read_vehicle_by_conduction_sticker($conduction_sticker, $db) > 0) { $return_arr["status"] = 3; $return_arr["message"] = "Duplicate record conduction sticker"; echo json_encode($return_arr); exit; } } if ($utility->isNotEmpty($plate_number)) { if ($vehicle->read_plate_number_by_vehicle_id($vehicle_id, $db) <> $plate_number) { if ($vehicle->read_vehicle_by_plate_number($plate_number, $db) > 0) { $return_arr["status"] = 4; $return_arr["message"] = "Duplicate record plate number"; echo json_encode($return_arr); exit; } } } $color_name = ($vehicle_data_array["mod-dd-color"]); // echo $color_name; if ($utility->isNotEmpty($color_name)) { $color_id = $color->read_color_id_by_name($color_name, $db); if (!$utility->isNotEmpty($color_id)) { $color_id = $color->create_color($color_name, $db); } } else { $color_id = 0; } $model_variant_name = ($vehicle_data_array["mod-dd-model-variant"]); if ($utility->isNotEmpty($model_variant_name)) { $model_variant_id = $model->read_model_variant_id_by_name($model_variant_name, $vehicle_data_array['mod-dd-model'], $db); if (!$utility->isNotEmpty($model_variant_id)) { $model_variant_id = $model->create_model_variant($model_variant_name, $vehicle_data_array['mod-dd-model'], $db); } } else { $model_variant_id = 0; } $additional_array_data['or'] = $utility->alphaNumericOnly($vehicle_data_array['mod-or']); $additional_array_data['cr'] = $utility->alphaNumericOnly($vehicle_data_array['mod-cr']); $plate_number = $utility->alphaNumericOnly($plate_number); $conduction_sticker = $utility->alphaNumericOnly($conduction_sticker); $insert_vehicle = $vehicle->update_vehicle( $vehicle_id, '', //$customer_dms_id, $vehicle_data_array['mod-customer-number'], $color_id, $vehicle_data_array['mod-engine-type'], $vehicle_data_array['mod-gas-type'], $vehicle_data_array['mod-dd-brand'], $vehicle_data_array['mod-dd-model'], $vehicle_data_array['mod-model-number'], $model_variant_id, $plate_number, '', //$chassis_number, '', //$serial_number, $utility->alphaNumericOnly($vehicle_data_array['mod-vin-number']), $conduction_sticker, '', //$vehicle_data_array['mod-driver'], '', //$purchase_car_as_id, '', //$delivery_date, $vehicle_data_array['mod-year-model'], $vehicle_data_array['mod-transmission'], $vehicle_data_array['mod-dd-type'], $vehicle_data_array['mod-reg-number'], '', //$release_number, $company_dealer_id, $_SESSION['user']['id'], '1', $additional_array_data, $db ); // if ( // $utility_class->isNotEmpty($plate_number) // && $utility_class->isNotEmpty($additional_array_data['or']) // && $utility_class->isNotEmpty($additional_array_data['cr']) // ) { // $orcrplate_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'orcr_plate', $db); // $orcr_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'orcr', $db); // $plate_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'plate', $db); // if (!$orcrplate_exist) { // if (!$orcr_exist && !$plate_exist) { // $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'orcr_plate', $db); // } else if (!$orcr_exist) { // $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'orcr', $db); // } else if (!$plate_exist) { // $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'plate', $db); // } // } // } else if ( // $utility_class->isNotEmpty($additional_array_data['or']) // && $utility_class->isNotEmpty($additional_array_data['cr']) // ) { // $orcr_exist = $vehicle->read_orcr_plate_entry($vehicle_id, 'orcr', $db); // if (!$orcr_exist) { // $vehicle->create_orcr_plate_entry($vehicle_id, $_SESSION['user']['id'], 'orcr', $db); // } // } $image_name = isset($_REQUEST['image_name']) ? $_REQUEST['image_name'] : array(); $image_name_array = array(); if (count($image_name) > 0) { foreach ($image_name as $image) { $image_name_array[] = "('$vehicle_id','" . $image . "')"; } $image_name_to_insert = implode(',', $image_name_array); $vehicle->insert_all_vehicle_image($image_name_to_insert, $db); } // START INSERT SALES RECORD $sale_id = $sales->get_sales_id_by_vehicle_id($vehicle_id, $db); if ($utility->isNotEmpty($sale_id)) { $vehicle_data = isset($_REQUEST['sales_data']) ? $_REQUEST['sales_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $insurance_company_name = ($vehicle_data_array["mod-dd-insurance-company"]); if ($utility->isNotEmpty($insurance_company_name)) { $insurance_company_id = $insurance_company->read_insurance_company_id_by_name($insurance_company_name, $db); if (!$utility->isNotEmpty($insurance_company_id)) { $insurance_company_id = $insurance_company->create_insurance_company($insurance_company_name, $db); } } else { $insurance_company_id = 0; } $finance_company_name = ($vehicle_data_array["mod-dd-finance-company"]); if ($utility->isNotEmpty($finance_company_name)) { $finance_company_id = $finance_company->read_finance_company_id_by_name($finance_company_name, $db); if (!$utility->isNotEmpty($finance_company_id)) { $finance_company_id = $finance_company->create_finance_company($finance_company_name, $db); } } else { $finance_company_id = 0; } // echo $finance_company_id;exit; //DATE FORMATS $insurance_expiration_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-insurance-exp-date"])) { $insurance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-insurance-exp-date"], 'mm/dd/yyyy'); } $finance_expiration_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-finance-exp-date"])) { $finance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-finance-exp-date"], 'mm/dd/yyyy'); } $delivery_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-delivery-date"])) { $delivery_date = $utility->convert_sql_date($vehicle_data_array["mod-delivery-date"], 'mm/dd/yyyy'); } $sales_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-sales-date"])) { $sales_date = $utility->convert_sql_date($vehicle_data_array["mod-sales-date"], 'mm/dd/yyyy'); } $insert_vehicle_sales = $sales->update_vehicle_sales( $sale_id, '', //$customer_dms_id, $vehicle_id, '', //$conduction_sticker, '', //$plate_number, $vehicle_data_array['mod-order-number'], '', //$floor_plan_amount, $sales_date, $vehicle_data_array['mod-sales-cost'], $vehicle_data_array['mod-sales-price'], $vehicle_data_array['mod-sales-discount'], $insurance_company_id, $vehicle_data_array['mod-dd-insurance-type'], $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $vehicle_data_array['mod-dd-source-of-sale'], '0', //$mode_of_contact_id, '', //$warehouse, '', //$stock_number, '', //$age_of_unit, '', //$body_size_code, '', //$claim_number, '', //$claim_amount, '', //$deal_number, '', //$deal_date, $vehicle_data_array['mod-dd-sales-consultant'], $vehicle_data_array['mod-driver'], $delivery_date, $vehicle_data_array['mod-dd-type-of-payment'], $vehicle_data_array['mod-dd-group-manager'], $company_dealer_id, '', //$purchase_car_as_id, $_SESSION['user']['id'], '1', //$status $vehicle_data_array['mod-end-user'], $vehicle_data_array['mod-dd-mode-of-sale'], $vehicle_data_array['mod-dd-group-manager-asa'], $vehicle_data_array['mod-dd-sales-consultant-asa'], $db ); $vehicle_brands_offered = isset($_REQUEST['vehicle_brands_offered']) ? $_REQUEST['vehicle_brands_offered'] : ''; $sales->delete_sales_offered($sale_id, $db); $vehicle_brands_offered_array = array(); if ($vehicle_brands_offered <> '') { $vehicle_brands_offered = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_brands_offered); $vehicle_brands_offered = array_map(array($db, 'escape'), $vehicle_brands_offered); foreach ($vehicle_brands_offered as $offered) { $description = ($offered['Description']); $brands_offered_id = ($offered['Brand']); $model_offered_id = ($offered['Model']); $vehicle_brands_offered_array[] = "('$sale_id','" . $brands_offered_id . "', '" . $model_offered_id . "', '" . $description . "')"; } $vehicle_brands_offered_to_insert = implode(',', $vehicle_brands_offered_array); $sales->create_sales_brands_offered($vehicle_brands_offered_to_insert, $db); } } else { if (intval($vehicle_data_array['has-sales-record']) === 1) { $sale_id = $utility->generate_uuid($db); $vehicle_data = isset($_REQUEST['sales_data']) ? $_REQUEST['sales_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $insurance_company_name = ($vehicle_data_array["mod-dd-insurance-company"]); if ($utility->isNotEmpty($insurance_company_name)) { $insurance_company_id = $insurance_company->read_insurance_company_id_by_name($insurance_company_name, $db); if (!$utility->isNotEmpty($insurance_company_id)) { $insurance_company_id = $insurance_company->create_insurance_company($insurance_company_name, $db); } } else { $insurance_company_id = 0; } // echo $insurance_company_id;exit; $finance_company_name = ($vehicle_data_array["mod-dd-finance-company"]); if ($utility->isNotEmpty($finance_company_name)) { $finance_company_id = $finance_company->read_finance_company_id_by_name($finance_company_name, $db); if (!$utility->isNotEmpty($finance_company_id)) { $finance_company_id = $finance_company->create_finance_company($finance_company_name, $db); } } else { $finance_company_id = 0; } //DATE FORMATS $insurance_expiration_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-insurance-exp-date"])) { $insurance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-insurance-exp-date"], 'mm/dd/yyyy'); } $finance_expiration_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-finance-exp-date"])) { $finance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-finance-exp-date"], 'mm/dd/yyyy'); } $delivery_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-delivery-date"])) { $delivery_date = $utility->convert_sql_date($vehicle_data_array["mod-delivery-date"], 'mm/dd/yyyy'); } $sales_date = ""; if ($utility->isNotEmpty($vehicle_data_array["mod-sales-date"])) { $sales_date = $utility->convert_sql_date($vehicle_data_array["mod-sales-date"], 'mm/dd/yyyy'); } $insert_vehicle_sales = $sales->create_vehicle_sales( $sale_id, '', //$customer_dms_id, $vehicle_id, '', //$conduction_sticker, '', //$plate_number, $utility->alphaNumericOnly($vehicle_data_array['mod-order-number']), '', //$floor_plan_amount, $sales_date, $vehicle_data_array['mod-sales-cost'], $vehicle_data_array['mod-sales-price'], $vehicle_data_array['mod-sales-discount'], $insurance_company_id, $vehicle_data_array['mod-dd-insurance-type'], $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $vehicle_data_array['mod-dd-source-of-sale'], '0', //$mode_of_contact_id, '', //$warehouse, '', //$stock_number, '', //$age_of_unit, '', //$body_size_code, '', //$claim_number, '', //$claim_amount, '', //$deal_number, '', //$deal_date, $vehicle_data_array['mod-dd-sales-consultant'], $vehicle_data_array['mod-driver'], $delivery_date, $vehicle_data_array['mod-dd-type-of-payment'], $vehicle_data_array['mod-dd-group-manager'], '0', //$company_dealer_id, '', //$purchase_car_as_id, $_SESSION['user']['id'], '1', //$status $vehicle_data_array['mod-end-user'], $vehicle_data_array['mod-dd-mode-of-sale'], $vehicle_data_array['mod-dd-group-manager-asa'], $vehicle_data_array['mod-dd-sales-consultant-asa'], $db ); $vehicle_brands_offered = isset($_REQUEST['vehicle_brands_offered']) ? $_REQUEST['vehicle_brands_offered'] : ''; $vehicle_brands_offered_array = array(); if ($vehicle_brands_offered <> '') { $vehicle_brands_offered = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_brands_offered); $vehicle_brands_offered = array_map(array($db, 'escape'), $vehicle_brands_offered); foreach ($vehicle_brands_offered as $offered) { $description = ($offered['Description']); $brands_offered_id = ($offered['Brand']); $model_offered_id = ($offered['Model']); // $model_offered_name = ($offered['Model']); // $model_offered_id = $model->read_model_id_by_name($model_offered_name, $db); $vehicle_brands_offered_array[] = "('$sale_id','" . $brands_offered_id . "', '" . $model_offered_id . "', '" . $description . "')"; } $vehicle_brands_offered_to_insert = implode(',', $vehicle_brands_offered_array); $sales->create_sales_brands_offered($vehicle_brands_offered_to_insert, $db); } } } // END INSERT SALES RECORD if ($insert_vehicle > 0) { $return_arr["status"] = 1; $return_arr["message"] = "Successfully updated"; $log_desc = "Update vehicle: %s"; $logger->create( $_SESSION['user']['id'], sprintf( $log_desc, '[ID:' . $vehicle_id . ']' ), $vehicle_id, 'update_vehicle', $db ); } else { $return_arr["status"] = 0; $return_arr["message"] = "Record not updated."; } echo json_encode($return_arr); } else if ($apiKey === '7832366523069856' && $utility->isPostMethod($server_method)) { //Read Vehicle Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_information = $vehicle->read_vehicle_details($vehicle_id, $db); $vehicle_information['mod-dd-brand'] = $brand->read_brand_name_by_id($vehicle_information['mod-dd-brand'], $db); $vehicle_information['mod-dd-model'] = $model->read_model_name_by_id($vehicle_information['mod-dd-model'], $db); $vehicle_information['mod-dd-color'] = $color->read_color_name_by_id($vehicle_information['mod-dd-color'], $db); //$vehicle_information['mod-dd-type'] = $vehicle_type->read_type_name_by_id($vehicle_information['mod-dd-type'], $db); echo json_encode(array($vehicle_information)); } else if ($apiKey === '1066045125469611' && $utility->isPostMethod($server_method)) { //Read Vehicle Sales Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle->read_vehicle_sales_details($vehicle_id, $db); } else if ($apiKey === '9434631886897744' && $utility->isPostMethod($server_method)) { //Read Vehicle Sales Details $image_id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '-1'; $vehicle->delete_vehicle_image($image_id, $db); } else if ($apiKey === '8310009448400393' && $utility->isPostMethod($server_method)) { //Read Vehicle DMS $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle->read_vehicle_dms($vehicle_id, $db); } else if ($apiKey === '1164288154587287' && $utility->isPostMethod($server_method)) { //Read Vehicle DMS $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $json_arr['vehicle_image'] = '<div class="col-12 text-center mt-3" id="grid-page-footer"> <div class="card-footer"> <nav aria-label="Contacts Page Navigation"> <ul class="pagination justify-content-center m-0" id="customer-owned-vehicle-paging">No Record</ul> </nav> </div> </div>'; // $images = $customer->read_customer_vehicle_image_by_vehicle_ids( $granted_company_ids,$vehicle_ids_list,$db); $vehicles = $vehicle->read_vehicle_image_display($vehicle_id, $db); if (count($vehicles) < 1) { echo json_encode($json_arr); return; } $json_arr['vehicle_image'] = ""; foreach ($vehicles as $vehicle) { $json_arr['vehicle_image'] .= ' <div class="card col-md-4 col-sm-4 p-2"> <div class="thumbnail"> <a class="" href="dist/img/customer/' . $vehicle['name'] . '" data-toggle="lightbox" data-title="' . $vehicle['date_added'] . '" data-gallery="gallery" data-footer=""> <img src="dist/img/customer/' . $vehicle['name'] . '" class=" img-fluid" alt="" style="height:250px; width:100%;" /> </a> </div> <div class="text-center" ' . ((isset($global_action_permissions['2']['4']) && in_array("3", $global_action_permissions['2']['4'])) ? '' : 'hidden') . ' > <p style="color:red;cursor:pointer;" onclick="removeImage(' . $vehicle['id'] . ')" ><u>Remove</u></p> </div> </div> '; } echo json_encode($json_arr); // echo $vehicle_list; } else if ($apiKey === '4785226316746539' && $utility->isPostMethod($server_method)) { //Read Vehicle DMS $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_information = $vehicle->read_vehicle_profile($vehicle_id, $db); $vehicle_information['mod-dd-color-name'] = $color->read_color_name_by_id($vehicle_information['mod-dd-color'], $db); $vehicle_information['mod-dd-model-variant-name'] = $model->read_model_variant_name_by_id($vehicle_information['mod-dd-model-variant'], $db); $vehicle_information['mod-dd-model-name'] = $vehicle->read_model_name_by_id($vehicle_information['mod-dd-model'], $db); $customer_name = $customer->read_customer_name_by_id($vehicle_information['mod-customer-number'], $db); if (count($customer_name) > 0) { if (intval($customer_name['type']) == 1) { $vehicle_information['mod-customer-number-name'] = $customer_name['first_name'] . ' ' . $customer_name['last_name']; } else { $vehicle_information['mod-customer-number-name'] = $customer_name['corporation_name']; } } else { $vehicle_information['mod-customer-number-name'] = ''; } $customer_id = isset($_REQUEST['customer_id']) ? $db->escape($_REQUEST['customer_id']) : '-1'; // $customer_information = $customer->read_customer_profile($customer_id,$db); // $customer_information['mod-dd-religion']= $religion->read_religion_name_by_id($customer_information['mod-dd-religion'],$db); // if($utility->isNotEmpty($customer_information['mod-birthdate'] )){ // $customer_information['mod-birthdate'] = $utility->convert_sql_date_to_date_picker($customer_information['mod-birthdate']); //$religion->read_religion_name_by_id($customer_information['mod-birthdate-unformat'],$db); // } // $customer_business = $customer->read_customer_business($customer_id,$db); // $customer_contact = $customer->read_customer_contact($customer_id,$db); // $return_information = array_merge($customer_information, $customer_business, $customer_contact); // echo json_encode(array($return_information)); echo json_encode(array($vehicle_information)); } else if ($apiKey === '5169873963910872' && $utility->isPostMethod($server_method)) { //Read Vehicle DMS $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_information = $vehicle->read_vehicle_profile_main($vehicle_id, $db); // $vehicle_information['mod-dd-color-name']= $color->read_color_name_by_id($vehicle_information['mod-dd-color'],$db); // $vehicle_information['mod-dd-model-name']= $vehicle->read_model_name_by_id($vehicle_information['mod-dd-model'],$db); // $customer_id = isset($_REQUEST['customer_id']) ? $db->escape($_REQUEST['customer_id']) : '-1' ; // $customer_information = $customer->read_customer_profile($customer_id,$db); // $customer_information['mod-dd-religion']= $religion->read_religion_name_by_id($customer_information['mod-dd-religion'],$db); // if($utility->isNotEmpty($customer_information['mod-birthdate'] )){ // $customer_information['mod-birthdate'] = $utility->convert_sql_date_to_date_picker($customer_information['mod-birthdate']); //$religion->read_religion_name_by_id($customer_information['mod-birthdate-unformat'],$db); // } // $customer_business = $customer->read_customer_business($customer_id,$db); // $customer_contact = $customer->read_customer_contact($customer_id,$db); // $return_information = array_merge($customer_information, $customer_business, $customer_contact); // echo json_encode(array($return_information)); echo json_encode(array($vehicle_information)); } else if ($apiKey === '8361020315855100' && $utility->isPostMethod($server_method)) { //Read Display $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer_information = $vehicle->read_customer_profile_display($customer_id, $granted_company_ids, $db); $customer_information['main_email'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_email']) ? $utility->mask_email($customer_information['main_email']) : '') : ((isset($fields_permissions['fields_email_1']) && !$fields_permissions['fields_email_1']) ? ($utility->isNotEmpty($customer_information['main_email']) ? $utility->mask_email($customer_information['main_email']) : '') : $customer_information['main_email']); $customer_information['main_customer_email_2'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_email_2']) ? $utility->mask_email($customer_information['main_customer_email_2']) : '') : ((isset($fields_permissions['fields_email_2']) && !$fields_permissions['fields_email_2']) ? ($utility->isNotEmpty($customer_information['main_customer_email_2']) ? $utility->mask_email($customer_information['main_customer_email_2']) : '') : $customer_information['main_customer_email_2']); $customer_information['main_customer_landline'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_landline']) ? $utility->mask($customer_information['main_customer_landline'], 2, 1) : '') : ((isset($fields_permissions['fields_landline']) && !$fields_permissions['fields_landline']) ? ($utility->isNotEmpty($customer_information['main_customer_landline']) ? $utility->mask($customer_information['main_customer_landline'], 2, 1) : '') : $customer_information['main_customer_landline']); $customer_information['main_customer_mobile'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_mobile']) ? $utility->mask($customer_information['main_customer_mobile'], 4, 1) : '') : ((isset($fields_permissions['fields_mobile_1']) && !$fields_permissions['fields_mobile_1']) ? ($utility->isNotEmpty($customer_information['main_customer_mobile']) ? $utility->mask($customer_information['main_customer_mobile'], 4, 1) : '') : $customer_information['main_customer_mobile']); $customer_information['main_customer_mobile_2'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_mobile_2']) ? $utility->mask($customer_information['main_customer_mobile_2'], 4, 1) : '') : ((isset($fields_permissions['fields_mobile_2']) && !$fields_permissions['fields_mobile_2']) ? ($utility->isNotEmpty($customer_information['main_customer_mobile_2']) ? $utility->mask($customer_information['main_customer_mobile_2'], 4, 1) : '') : $customer_information['main_customer_mobile_2']); $customer_information['main_customer_home_mobile'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_home_mobile']) ? $utility->mask($customer_information['main_customer_home_mobile'], 4, 1) : '') : ((isset($fields_permissions['fields_home_phone']) && !$fields_permissions['fields_home_phone']) ? ($utility->isNotEmpty($customer_information['main_customer_home_mobile']) ? $utility->mask($customer_information['main_customer_home_mobile'], 4, 1) : '') : $customer_information['main_customer_home_mobile']); $customer_information['main_customer_business_mobile'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_business_mobile']) ? $utility->mask($customer_information['main_customer_business_mobile'], 4, 1) : '') : ((isset($fields_permissions['fields_business_phone']) && !$fields_permissions['fields_business_phone']) ? ($utility->isNotEmpty($customer_information['main_customer_business_mobile']) ? $utility->mask($customer_information['main_customer_business_mobile'], 4, 1) : '') : $customer_information['main_customer_business_mobile']); $customer_information['main_customer_address_1'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_address_1']) ? $utility->mask($customer_information['main_customer_address_1'], 2, 2) : '') : ((isset($fields_permissions['fields_address_1']) && !$fields_permissions['fields_address_1']) ? ($utility->isNotEmpty($customer_information['main_customer_address_1']) ? $utility->mask($customer_information['main_customer_address_1'], 3, 0) : '') : $customer_information['main_customer_address_1']); $customer_information['main_customer_address_2'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_address_2']) ? $utility->mask($customer_information['main_customer_address_2'], 2, 2) : '') : ((isset($fields_permissions['fields_address_2']) && !$fields_permissions['fields_address_2']) ? ($utility->isNotEmpty($customer_information['main_customer_address_2']) ? $utility->mask($customer_information['main_customer_address_2'], 3, 0) : '') : $customer_information['main_customer_address_2']); $customer_information['main_viber'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_viber']) ? $utility->mask($customer_information['main_viber'], 2, 1) : '') : ((isset($fields_permissions['fields_viber']) && !$fields_permissions['fields_viber']) ? ($utility->isNotEmpty($customer_information['main_viber']) ? $utility->mask($customer_information['main_viber'], 2, 1) : '') : $customer_information['main_viber']); $customer_information['main_facebook'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_facebook']) ? $utility->mask($customer_information['main_facebook'], 2, 1) : '') : ((isset($fields_permissions['fields_facebook']) && !$fields_permissions['fields_facebook']) ? ($utility->isNotEmpty($customer_information['main_facebook']) ? $utility->mask($customer_information['main_facebook'], 2, 1) : '') : $customer_information['main_facebook']); $customer_information['main_instagram'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_instagram']) ? $utility->mask($customer_information['main_instagram'], 2, 1) : '') : ((isset($fields_permissions['fields_instagram']) && !$fields_permissions['fields_instagram']) ? ($utility->isNotEmpty($customer_information['main_instagram']) ? $utility->mask($customer_information['main_instagram'], 2, 1) : '') : $customer_information['main_instagram']); $customer_information['main_whatsapp'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_whatsapp']) ? $utility->mask($customer_information['main_whatsapp'], 2, 1) : '') : ((isset($fields_permissions['fields_whatsapp']) && !$fields_permissions['fields_whatsapp']) ? ($utility->isNotEmpty($customer_information['main_whatsapp']) ? $utility->mask($customer_information['main_whatsapp'], 2, 1) : '') : $customer_information['main_whatsapp']); $customer_information['main_telegram'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_telegram']) ? $utility->mask($customer_information['main_telegram'], 2, 1) : '') : ((isset($fields_permissions['fields_telegram']) && !$fields_permissions['fields_telegram']) ? ($utility->isNotEmpty($customer_information['main_telegram']) ? $utility->mask($customer_information['main_telegram'], 2, 1) : '') : $customer_information['main_telegram']); // $customer_information['main_email'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_email']) ? $utility->mask_email($customer_information['main_email']) : '' : (isset($fields_permissions['fields_email_1']) && !$fields_permissions['fields_email_1']) ? $utility->isNotEmpty($customer_information['main_email']) ? $utility->mask_email($customer_information['main_email']) : '' : $customer_information['main_email']; // $customer_information['main_customer_email_2'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_email_2']) ? $utility->mask_email($customer_information['main_customer_email_2']) : '' : (isset($fields_permissions['fields_email_2']) && !$fields_permissions['fields_email_2']) ? $utility->isNotEmpty($customer_information['main_customer_email_2']) ? $utility->mask_email($customer_information['main_customer_email_2']) : '' : $customer_information['main_customer_email_2']; // $customer_information['main_customer_landline'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_landline']) ? $utility->mask($customer_information['main_customer_landline'], 2, 1) : '' : (isset($fields_permissions['fields_landline']) && !$fields_permissions['fields_landline']) ? $utility->isNotEmpty($customer_information['main_customer_landline']) ? $utility->mask($customer_information['main_customer_landline'], 2, 1) : '' : $customer_information['main_customer_landline']; // $customer_information['main_customer_mobile'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_mobile']) ? $utility->mask($customer_information['main_customer_mobile'], 4, 1) : '' : (isset($fields_permissions['fields_mobile_1']) && !$fields_permissions['fields_mobile_1']) ? $utility->isNotEmpty($customer_information['main_customer_mobile']) ? $utility->mask($customer_information['main_customer_mobile'], 4, 1) : '' : $customer_information['main_customer_mobile']; // $customer_information['main_customer_mobile_2'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_mobile_2']) ? $utility->mask($customer_information['main_customer_mobile_2'], 4, 1) : '' : (isset($fields_permissions['fields_mobile_2']) && !$fields_permissions['fields_mobile_2']) ? $utility->isNotEmpty($customer_information['main_customer_mobile_2']) ? $utility->mask($customer_information['main_customer_mobile_2'], 4, 1) : '' : $customer_information['main_customer_mobile_2']; // $customer_information['main_customer_home_mobile'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_home_mobile']) ? $utility->mask($customer_information['main_customer_home_mobile'], 4, 1) : '' : (isset($fields_permissions['fields_home_phone']) && !$fields_permissions['fields_home_phone']) ? $utility->isNotEmpty($customer_information['main_customer_home_mobile']) ? $utility->mask($customer_information['main_customer_home_mobile'], 4, 1) : '' : $customer_information['main_customer_home_mobile']; // $customer_information['main_customer_business_mobile'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_business_mobile']) ? $utility->mask($customer_information['main_customer_business_mobile'], 4, 1) : '' : (isset($fields_permissions['fields_business_phone']) && !$fields_permissions['fields_business_phone']) ? $utility->isNotEmpty($customer_information['main_customer_business_mobile']) ? $utility->mask($customer_information['main_customer_business_mobile'], 4, 1) : '' : $customer_information['main_customer_business_mobile']; // $customer_information['main_customer_address_1'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_address_1']) ? $utility->mask($customer_information['main_customer_address_1'], 3, 0) : '' : (isset($fields_permissions['fields_address_1']) && !$fields_permissions['fields_address_1']) ? $utility->isNotEmpty($customer_information['main_customer_address_1']) ? $utility->mask($customer_information['main_customer_address_1'], 3, 0) : '' : $customer_information['main_customer_address_1']; // $customer_information['main_customer_address_2'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_customer_address_2']) ? $utility->mask($customer_information['main_customer_address_2'], 3, 0) : '' : (isset($fields_permissions['fields_address_2']) && !$fields_permissions['fields_address_2']) ? $utility->isNotEmpty($customer_information['main_customer_address_2']) ? $utility->mask($customer_information['main_customer_address_2'], 3, 0) : '' : $customer_information['main_customer_address_2']; // $customer_information['main_viber'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_viber']) ? $utility->mask($customer_information['main_viber'], 2, 1) : '' : (isset($fields_permissions['fields_viber']) && !$fields_permissions['fields_viber']) ? $utility->isNotEmpty($customer_information['main_viber']) ? $utility->mask($customer_information['main_viber'], 2, 1) : '' : $customer_information['main_viber']; // $customer_information['main_facebook'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_facebook']) ? $utility->mask($customer_information['main_facebook'], 2, 1) : '' : (isset($fields_permissions['fields_facebook']) && !$fields_permissions['fields_facebook']) ? $utility->isNotEmpty($customer_information['main_facebook']) ? $utility->mask($customer_information['main_facebook'], 2, 1) : '' : $customer_information['main_facebook']; // $customer_information['main_instagram'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_instagram']) ? $utility->mask($customer_information['main_instagram'], 2, 1) : '' : (isset($fields_permissions['fields_instagram']) && !$fields_permissions['fields_instagram']) ? $utility->isNotEmpty($customer_information['main_instagram']) ? $utility->mask($customer_information['main_instagram'], 2, 1) : '' : $customer_information['main_instagram']; // $customer_information['main_whatsapp'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_whatsapp']) ? $utility->mask($customer_information['main_whatsapp'], 2, 1) : '' : (isset($fields_permissions['fields_whatsapp']) && !$fields_permissions['fields_whatsapp']) ? $utility->isNotEmpty($customer_information['main_whatsapp']) ? $utility->mask($customer_information['main_whatsapp'], 2, 1) : '' : $customer_information['main_whatsapp']; // $customer_information['main_telegram'] = (!$fields_permissions) ? $utility->isNotEmpty($customer_information['main_telegram']) ? $utility->mask($customer_information['main_telegram'], 2, 1) : '' : (isset($fields_permissions['fields_telegram']) && !$fields_permissions['fields_telegram']) ? $utility->isNotEmpty($customer_information['main_telegram']) ? $utility->mask($customer_information['main_telegram'], 2, 1) : '' : $customer_information['main_telegram']; // $customer_information['mod-dd-religion']= $religion->read_religion_name_by_id($customer_information['mod-dd-religion'],$db); // if($utility->isNotEmpty($customer_information['information_dob'] )){ // $customer_information['information_dob'] = $utility->convert_sql_date_to_date_picker($customer_information['information_dob']); //$religion->read_religion_name_by_id($customer_information['mod-birthdate-unformat'],$db); // } // $customer_business = $customer->read_customer_business($customer_id,$db); // $customer_contact = $customer->read_customer_contact($customer_id,$db); // $return_information = array_merge($customer_information); echo json_encode(array($customer_information)); } else if ($apiKey === '7997990239771566') { //Read Display $search = isset($_REQUEST['search']) ? $db->escape($_REQUEST['search']) : ''; $vehicle->read_vehicle_cs_plate_and_id($granted_company_ids, $search, $db); } else if ($apiKey === '3074169819586596') { //Update $dms = (isset($_POST['dms']) && $_POST['dms'] != '0') ? " AND sc.dms_id = '" . $_POST['dms'] . "' " : ""; $company = (isset($_POST['company']) && $_POST['company'] != '0') ? " AND scd.company_id = '" . $_POST['company'] . "' " : ""; $my_records = (isset($_POST['my_records']) && filter_var($_POST['my_records'], FILTER_VALIDATE_BOOLEAN)) ? " AND (v.upload_by='$my_customer_record_id' OR v.modified_by='$my_customer_record_id') " : ""; $json_arr = array(); $counts = $db->sql_query(" SELECT SUM((SELECT count(1) FROM (SELECT sc.dms_id FROM vehicle v INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE v.status = 1 AND scd.company_id IN (" . $granted_company_ids . ") $dms $company $my_records GROUP BY v.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as total_count, SUM((SELECT count(1) FROM (SELECT sc.dms_id FROM vehicle v INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE v.date_uploaded > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND v.status = 1 AND scd.company_id IN (" . $granted_company_ids . ") $dms $company $my_records GROUP BY v.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as new_vehicle_count, SUM((SELECT count(1) FROM (SELECT sc.dms_id FROM vehicle v INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE v.date_modified > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND v.status = 1 AND scd.company_id IN (" . $granted_company_ids . ") $dms $company $my_records GROUP BY v.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as updated_vehicle_count, SUM((SELECT count(1) FROM (SELECT sc.dms_id FROM vehicle v INNER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id WHERE v.date_uploaded > DATE_SUB(NOW(), INTERVAL 1 DAY) AND v.status = 1 AND scd.company_id IN (" . $granted_company_ids . ") $dms $company $my_records GROUP BY v.id ) as t2 WHERE t2.dms_id = source_dms.id ) ) as new_today_vehicle_count FROM `source_dms` WHERE status = 1"); foreach ($counts as $count) { $json_arr['total_count'] = number_format($count['total_count']); $json_arr['new_vehicle_count'] = number_format($count['new_vehicle_count']); $json_arr['updated_vehicle_count'] = number_format($count['updated_vehicle_count']); $json_arr['new_today_vehicle_count'] = number_format($count['new_today_vehicle_count']); } echo json_encode($json_arr); } else if ($apiKey === '9306656513579817' && $utility->isPostMethod($server_method)) { //Read Customer Interest $start_date = isset($_REQUEST['startDate']) ? $db->escape($_REQUEST['startDate']) : ''; $end_date = isset($_REQUEST['endDate']) ? $db->escape($_REQUEST['endDate']) : ''; $company = isset($_REQUEST['company']) ? $db->escape($_REQUEST['company']) : '0'; $return_arr["total"] = $vehicle->read_vehicle_total_number($start_date, $end_date, $company, $granted_company_ids, $db); echo json_encode($return_arr); } else if ($apiKey === '4026781185955988' && $utility->isPostMethod($server_method)) { //delete vejhicle $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $return_arr = $vehicle->delete_vehicle($vehicle_id, $db); echo json_encode($return_arr); } else { $return_arr["message"] = " You are not allowed to do this action."; echo $return_arr["message"]; return; } } else { $return_arr["message"] = " You are not allowed to do this action."; echo $return_arr["message"]; return; }

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0.01 | proxy | phpinfo | Settings