File manager

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

Back
<?php include_once("../../cfg/db.php"); include_once("../controllers/utility.php"); include_once("../controllers/customer.php"); include_once("../controllers/compliance.php"); include_once("../compliance/required_fields.php"); include_once("../controllers/insurance.php"); include_once("../controllers/nature_of_business.php"); include_once("../controllers/profession.php"); include_once("../controllers/sales.php"); include_once("../controllers/brand.php"); include_once("../controllers/color.php"); include_once("../controllers/vehicle.php"); include_once("../controllers/affiliations.php"); include_once("../controllers/model.php"); include_once("../controllers/logger.php"); include_once("../controllers/company.php"); $utility = new Utility(); $affiliations_class = new Affiliations(); $vehicle_class = new Vehicle(); $color_class = new Color(); $insurance_company_class = new Insurance(); $sales_class = new Sales(); $customer = new Customer(); $brand_class = new Brand(); $model_class = new Model(); $profession_class = new Profession(); $nature_of_business_class = new NatureOfBusiness(); $compliance = new Compliance(); $required_fields = new RequiredFields(); $company_class = new Company(); $logger_class = new Logger(); $server_method = $_SERVER["REQUEST_METHOD"]; if (isset($_SESSION['user'])) { $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1'; } else { $granted_company_ids = ''; } if (isset($_REQUEST['apiKey'])) { $apiKey = $_REQUEST['apiKey']; if ($apiKey === '6037364564277021') { //asa sc client list $search = isset($_REQUEST['search']) ? $db->escape($_REQUEST['search']) : ''; $offset = isset($_REQUEST['offset']) ? $db->escape($_REQUEST['offset']) : ''; $limit = isset($_REQUEST['limit']) ? $db->escape($_REQUEST['limit']) : ''; $asa_id = isset($_REQUEST['asa_id']) ? $db->escape($_REQUEST['asa_id']) : ''; $sc_id = isset($_REQUEST['sc_id']) ? $db->escape($_REQUEST['sc_id']) : ''; $start_date = isset($_REQUEST['start_date']) ? $db->escape($_REQUEST['start_date']) : ''; $end_date = isset($_REQUEST['end_date']) ? $db->escape($_REQUEST['end_date']) : ''; $type = isset($_REQUEST['type']) ? $db->escape($_REQUEST['type']) : ''; $complete_type = isset($_REQUEST['status']) ? $db->escape($_REQUEST['status']) : ''; $commission_status = isset($_REQUEST['commission_status']) ? $db->escape($_REQUEST['commission_status']) : ''; $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $company = (isset($_REQUEST['company']) && $_REQUEST['company'] <> '0' && isset($_SESSION['user'])) ? $db->escape($_REQUEST['company']) : $granted_company_ids; $company = (isset($_SESSION['user'])) ? $company : ''; $secure = (isset($_REQUEST['secure']) && $db->escape($_REQUEST['secure'])) ? true : false; $brand_id = isset($_REQUEST['brand']) ? $db->escape($_REQUEST['brand']) : ''; $days = isset($_REQUEST['days']) ? $db->escape($_REQUEST['days']) : ''; $json_arr = $compliance->read_sales_by_asa_id($sales_id, $brand_id, $complete_type, $type, $commission_status, $company, $start_date, $end_date, $asa_id, $sc_id, $search, $offset, $limit, $required_fields, $days, $secure, $utility, $db); echo json_encode($json_arr); } else if ($apiKey === '6137464565377022') { //asa sc client list $search = isset($_REQUEST['search']) ? $db->escape($_REQUEST['search']) : ''; $offset = isset($_REQUEST['offset']) ? $db->escape($_REQUEST['offset']) : ''; $limit = isset($_REQUEST['limit']) ? $db->escape($_REQUEST['limit']) : ''; $start_date = isset($_REQUEST['start_date']) ? $db->escape($_REQUEST['start_date']) : ''; $end_date = isset($_REQUEST['end_date']) ? $db->escape($_REQUEST['end_date']) : ''; $group = isset($_REQUEST['group']) ? intval($db->escape($_REQUEST['group'])) : ''; $user_id = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : ''; $all_group_access = isset($_REQUEST['all_group_access']) ? intval($db->escape($_REQUEST['all_group_access'])) : ''; $all_tag_access = isset($_REQUEST['all_tag_access']) ? intval($db->escape($_REQUEST['all_tag_access'])) : ''; if (!$group && $all_group_access) { // maintain granted_company_ids } else { // change granted company ids based on company groups $company_ids_obj = $company_class->read_company_ids_by_group_id($group, $db); $company_ids_arr = array(); foreach ($company_ids_obj as $company_id_row) { $company_ids_arr[] = $company_id_row['company_id']; } $granted_company_ids = (count($company_ids_arr) > 0) ? implode(', ', $company_ids_arr) : '0'; } $company = (isset($_REQUEST['company']) && $_REQUEST['company'] <> '0' && isset($_SESSION['user'])) ? $db->escape($_REQUEST['company']) : $granted_company_ids; $company = (isset($_SESSION['user'])) ? $company : ''; $brand = (isset($_REQUEST['brand']) && $_REQUEST['brand'] <> '0') ? $db->escape($_REQUEST['brand']) : ''; $attended_filter = (isset($_REQUEST['attended_filter']) && $_REQUEST['attended_filter'] <> '0') ? $db->escape($_REQUEST['attended_filter']) : ''; $secure = (isset($_REQUEST['secure']) && $db->escape($_REQUEST['secure'])) ? true : false; $json_arr = $compliance->read_sales_future_vehicle($user_id, $all_tag_access, $attended_filter, $company, $brand, $start_date, $end_date, $search, $offset, $limit, $required_fields, $secure, $utility, $db); echo json_encode($json_arr); } else if ($apiKey === '6137334565377022') { //asa sc client list $search = isset($_REQUEST['search']) ? $db->escape($_REQUEST['search']) : ''; $offset = isset($_REQUEST['offset']) ? $db->escape($_REQUEST['offset']) : ''; $limit = isset($_REQUEST['limit']) ? $db->escape($_REQUEST['limit']) : ''; $start_date = isset($_REQUEST['start_date']) ? $db->escape($_REQUEST['start_date']) : ''; $end_date = isset($_REQUEST['end_date']) ? $db->escape($_REQUEST['end_date']) : ''; $company = (isset($_REQUEST['company']) && $_REQUEST['company'] <> '0' && isset($_SESSION['user'])) ? $db->escape($_REQUEST['company']) : $granted_company_ids; $company = (isset($_SESSION['user'])) ? $company : ''; $secure = (isset($_REQUEST['secure']) && $db->escape($_REQUEST['secure'])) ? true : false; $json_arr = $compliance->read_car_clubs($company, $start_date, $end_date, $search, $offset, $limit, $required_fields, $secure, $utility, $db); echo json_encode($json_arr); } else if ($apiKey === '7352539682138115') { //asa complete / incomplete data count list $asa_id = isset($_REQUEST['asa_id']) ? $db->escape($_REQUEST['asa_id']) : ''; $compliance->read_sales_complete_incomplete_count($asa_id, $required_fields, $db); } else if ($apiKey === '2357447068264980') { //update commision status $asa_id = isset($_REQUEST['asa_id']) ? $db->escape($_REQUEST['asa_id']) : ''; $status = isset($_REQUEST['status']) ? $db->escape($_REQUEST['status']) : '0'; $description = isset($_REQUEST['description']) ? $db->escape($_REQUEST['description']) : ''; $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $user_id = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : ''; if (!$utility->isNotEmpty($sales_id)) { $json_arr['status'] = 0; $json_arr['message'] = 'Sales ID is required'; echo json_encode($json_arr); exit; } $compliance->update_sales_commission($asa_id, $sales_id, $status, $user_id, $description, $utility, $db); $json_arr['status'] = 1; $json_arr['message'] = 'Comission status updated!'; echo json_encode($json_arr); } else if ($apiKey === '3625900201207033') { //update commision status $asa_id = isset($_REQUEST['asa_id']) ? $db->escape($_REQUEST['asa_id']) : ''; $status = isset($_REQUEST['status']) ? $db->escape($_REQUEST['status']) : '1'; $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $user_id = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : ''; if (!$utility->isNotEmpty($sales_id)) { $json_arr['status'] = 0; $json_arr['message'] = 'Sales ID is required'; echo json_encode($json_arr); exit; } $compliance->update_sales_commission_accounting($asa_id, $sales_id, $status, $user_id, $utility, $db); $json_arr['status'] = 1; $json_arr['message'] = 'Status updated!'; echo json_encode($json_arr); } else if ($apiKey === '3625900201207034') { //update commision status $asa_id = isset($_REQUEST['asa_id']) ? $db->escape($_REQUEST['asa_id']) : ''; $status = isset($_REQUEST['status']) ? $db->escape($_REQUEST['status']) : '1'; $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $user_id = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : ''; if (!$utility->isNotEmpty($sales_id)) { $json_arr['status'] = 0; $json_arr['message'] = 'Sales ID is required'; echo json_encode($json_arr); exit; } $compliance->update_sales_future_vehicle($asa_id, $sales_id, $status, $user_id, $utility, $db); $json_arr['status'] = 1; $json_arr['message'] = 'Status updated!'; echo json_encode($json_arr); } else if ($apiKey === '3625999201207034') { //update commision status $assigned_sc_id = $db->escape($_REQUEST['assigned_sc_id']); $assigned_sc_name = $db->escape($_REQUEST['assigned_sc_name']); $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $user_id = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : ''; if (!$utility->isNotEmpty($sales_id)) { $json_arr['status'] = 0; $json_arr['message'] = 'Sales ID is required'; echo json_encode($json_arr); exit; } // disable all connected asa in sales record $compliance->update_future_vehicle_assigned_sc_all($sales_id, $utility, $db); $compliance->update_future_tag_all($sales_id, $utility, $db); $obj = $compliance->read_future_vehicle_assigned_sc($sales_id, $assigned_sc_id, $utility, $db); $data = array(); foreach ($obj as $row) { $data = $row; } if (count($data) < 1) { $compliance->create_future_vehicle_assigned_sc($sales_id, $assigned_sc_id, $assigned_sc_name, $user_id, $utility, $db); } else { $compliance->update_future_vehicle_assigned_sc($sales_id, $assigned_sc_id, $assigned_sc_name, $user_id, $utility, $db); } $json_arr['status'] = 1; $json_arr['message'] = 'Status updated!'; echo json_encode($json_arr); } else if ($apiKey === '3625999201207786') { //update commision status $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $user_id = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : ''; if (!$utility->isNotEmpty($sales_id)) { $json_arr['status'] = 0; $json_arr['message'] = 'Sales ID is required'; echo json_encode($json_arr); exit; } $compliance->update_future_vehicle_assigned_sc_all($sales_id, $utility, $db); $compliance->update_future_tag_all($sales_id, $utility, $db); $json_arr['status'] = 1; $json_arr['message'] = 'Status updated!'; echo json_encode($json_arr); } else if ($apiKey === '3625999203434336') { //update commision status $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $asa_id = isset($_REQUEST['asa_id']) ? $db->escape($_REQUEST['asa_id']) : ''; $user_id = (isset($_SESSION['user'])) ? $_SESSION['user']['id'] : ''; if (!$utility->isNotEmpty($sales_id)) { $json_arr['status'] = 0; $json_arr['message'] = 'Sales ID is required'; echo json_encode($json_arr); exit; } $obj = $compliance->read_future_tag($sales_id, $asa_id, $user_id, $utility, $db); $data = array(); foreach ($obj as $row) { $data = $row; } if (count($data) < 1) { $compliance->create_future_tag($sales_id, $asa_id, $user_id, $utility, $db); } else { if ($data['status'] == 0) { $compliance->update_future_tag($sales_id, $asa_id, $user_id, '1', $utility, $db); } else { $compliance->update_future_tag($sales_id, $asa_id, $user_id, '0', $utility, $db); } } $json_arr['status'] = 1; $json_arr['message'] = 'Status updated!'; echo json_encode($json_arr); } else if ($apiKey === '2679462138438190') { //required field list plus countings $start_date = isset($_REQUEST['start_date']) ? $db->escape($_REQUEST['start_date']) : ''; $end_date = isset($_REQUEST['end_date']) ? $db->escape($_REQUEST['end_date']) : ''; $company = (isset($_REQUEST['company']) && $_REQUEST['company'] <> '0') ? $db->escape($_REQUEST['company']) : $granted_company_ids; $company = (isset($_SESSION['user'])) ? $company : ''; $asa_id = (isset($_REQUEST['asa_id']) && $_REQUEST['asa_id'] <> '') ? $db->escape($_REQUEST['asa_id']) : ''; $sc_id = (isset($_REQUEST['sc_id']) && $_REQUEST['sc_id'] <> '') ? $db->escape($_REQUEST['sc_id']) : ''; $compliance->read_required_fields_and_counts($asa_id, $sc_id, $company, $start_date, $end_date, $required_fields, $db); } else if ($apiKey === '6045085206627390') { //get status historhy $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $compliance->read_sales_compliance_status_history($sales_id, $utility, $db); } else if ($apiKey === '9917866898468776') { //required field list plus countings $start_date = isset($_REQUEST['start_date']) ? $db->escape($_REQUEST['start_date']) : ''; $end_date = isset($_REQUEST['end_date']) ? $db->escape($_REQUEST['end_date']) : ''; $company = (isset($_REQUEST['company']) && $_REQUEST['company'] <> '0') ? $db->escape($_REQUEST['company']) : $granted_company_ids; $company = (isset($_SESSION['user'])) ? $company : ''; $asa_id = (isset($_REQUEST['asa_id']) && $_REQUEST['asa_id'] <> '') ? $db->escape($_REQUEST['asa_id']) : ''; $sc_id = (isset($_REQUEST['sc_id']) && $_REQUEST['sc_id'] <> '') ? $db->escape($_REQUEST['sc_id']) : ''; // echo $company; exit; $counts = $compliance->getComplianceSummaryCount($asa_id, $sc_id, $start_date, $end_date, $company, $required_fields, $db); } else if ($apiKey === '4683843345322827') { //Read Customer Interest $search = (isset($_REQUEST['search']) && $utility->isNotEmpty($_REQUEST['search'])) ? " AND CONCAT(sc.first_name,' ',sc.last_name,' ',sc.first_name) LIKE '%" . $db->escape($_REQUEST['search']) . "%' " : ''; $offset = isset($_REQUEST['offset']) ? $_REQUEST['offset'] : ''; $limit = isset($_REQUEST['limit']) ? $_REQUEST['limit'] : ''; $order = isset($_REQUEST['order']) ? $_REQUEST['order'] : ''; $sort = isset($_REQUEST['sort']) ? $_REQUEST['sort'] : ''; $start_date = isset($_REQUEST['start_date']) ? $db->escape($_REQUEST['start_date']) : ''; $commission_status = isset($_REQUEST['commission_status']) ? $db->escape($_REQUEST['commission_status']) : ''; $end_date = isset($_REQUEST['end_date']) ? $db->escape($_REQUEST['end_date']) : ''; $company = (isset($_REQUEST['company']) && intval($_REQUEST['company']) !== 0) ? " AND sc.id IN (" . $_REQUEST['company'] . ") " : " AND sc.id IN (" . $granted_company_ids . ") "; $company = (isset($_SESSION['user'])) ? $company : ''; $complete_type = isset($_REQUEST['status']) ? $db->escape($_REQUEST['status']) : ''; $asa_only = isset($_REQUEST['asa_only']) && $_REQUEST['asa_only'] ? ' AND s.asa_sales_person <> 0 ' : ''; $offset_limit = ($utility->isNotEmpty($offset) && $utility->isNotEmpty($limit)) ? " LIMIT $offset,$limit " : ''; $order_sort = ($utility->isNotEmpty($order) && $utility->isNotEmpty($sort)) ? " ORDER BY $sort $order " : ' ORDER BY complete DESC,total DESC,rate DESC '; if ($start_date <> '' && $end_date <> '' && $start_date <> '1970-01-01') { $date_filter = " AND DATE_FORMAT(s.activity_date,'%Y-%m-%d 00:00:00') BETWEEN DATE_FORMAT('$start_date', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$end_date', '%Y-%m-%d 23:59:00') "; } else { $date_filter = ""; } $incomplete_where = " AND (" . $required_fields->getIncompleteWhere() . ") "; $complete_where = " AND (" . $required_fields->getCompleteWhere() . ") "; if ($complete_type == '0') { $complete_type = $incomplete_where; } else if ($complete_type == '1') { $complete_type = $complete_where; } else { $complete_type = ''; } if ($utility->isNotEmpty($commission_status)) { switch ($commission_status) { case "0": $commission_status = " AND ((t1.complete = 0 AND (t1.m_commission_status_id = 0 \|\| t1.m_commission_status_id = 3)) OR (t1.complete = 1 AND t1.m_commission_status_id = 3)) "; break; case "1": $commission_status = " AND ((t1.complete = 1 AND t1.m_commission_status_id = 0) OR (t1.complete = 1 AND t1.m_commission_status_id = 1) OR (t1.complete = 0 AND t1.m_commission_status_id = 1))"; break; case "2": $commission_status = " AND (t1.m_commission_status_id = 2)"; break; } } else { $commission_status = ""; } $field = " sc.id as datacon_sc_id,t1.asa_sales_person as asa_id,CONCAT(sc.last_name,' ',sc.first_name) as name, SUM(t1.complete) as complete, SUM(t1.incomplete) as incomplete, SUM(t1.total) total, ((SUM(t1.complete)/SUM(t1.total))100) as rate, SUM(IF((t1.complete = 0 AND (t1.m_commission_status_id = 0 \|\| t1.m_commission_status_id = 3)) OR (t1.complete = 1 AND t1.m_commission_status_id = 3),1, 0)) as hold "; $query = "SELECT %s FROM (" . $required_fields->getAllInOneComplianceQuery() . " /AND s.asa_sales_person <> 0 / %s / with asa sc only / %s / complete type / %s /date filter/ %s /company/ AND v.status = 1 AND s.status = 1 AND c.id IS NOT NULL AND c.id <> 0 AND c.status = 1 AND s.activity_date <> '' GROUP BY s.id ) as t1 INNER JOIN sales_consultant sc ON t1.sales_person = sc.id WHERE 1 AND (sc.id IS NOT NULL AND sc.id <> 0) %s /search/ %s /commission/ GROUP BY sc.id %s /order sort/ %s /limit/"; // echo sprintf($query, $field, $asa_only, $complete_type, $date_filter, $company, $search, $commission_status, $order_sort, $offset_limit); // exit; $list = $db->sql_query(sprintf($query, $field, $asa_only, $complete_type, $date_filter, $company, $commission_status, $search, $order_sort, $offset_limit)); // echo sprintf($query,$field,$asa_only,$complete_type,$company,$date_filter,$search,$order_sort,$offset_limit);exit; $list_count = $db->sql_num_rows(sprintf($query, ' 1 ', $asa_only, $complete_type, $date_filter, $company, $search, $commission_status, '', '')); $json_arr['rows'] = array(); foreach ($list as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'asa_id' => $row['asa_id'], 'datacon_sc_id' => $row['datacon_sc_id'], 'name' => $row['name'], 'complete' => $row['complete'], 'incomplete' => $row['incomplete'], 'total' => $row['total'], 'hold_count' => $row['hold'], 'rate' => number_format($row['rate'], 2) . '%', )) ); } $json_arr['total'] = intval($list_count); // print_r($_REQUEST); echo json_encode($json_arr); } else if ( $apiKey === '4514421721415268' && isset($_REQUEST['customer_id']) && $db->escape($_REQUEST['customer_id']) && isset($_REQUEST['vehicle_id']) && $db->escape($_REQUEST['vehicle_id']) && isset($_REQUEST['sales_id']) && $db->escape($_REQUEST['sales_id']) && isset($_REQUEST['customer_type']) && $db->escape($_REQUEST['customer_type']) ) { //update customer data file_put_contents('4514421721415268.txt', print_r($_REQUEST, true)); $customer_id = isset($_REQUEST['customer_id']) ? $db->escape($_REQUEST['customer_id']) : ''; $vehicle_id = isset($_REQUEST['vehicle_id']) ? $db->escape($_REQUEST['vehicle_id']) : ''; $sales_id = isset($_REQUEST['sales_id']) ? $db->escape($_REQUEST['sales_id']) : ''; $json_arr = $compliance->read_sales_by_asa_id($sales_id, '', '', '', '', '', '', '', '', '', '', '', '', $required_fields, '', '', $utility, $db); //must same params to same name func if ($json_arr['rows'][0]['status'] == 'COM') { $return_arr["status"] = 0; $return_arr["message"] = "No changes were made, complete data cannot be updated anymore."; echo json_encode($return_arr); exit; } // update limit days must // if(intval($json_arr['rows'][0]['release_date_count']) > 14){ // $return_arr["status"]=0; // $return_arr["message"]="No changes were made, prior update days limit has been reached."; // echo json_encode($return_arr); // exit; // } $customer_type = isset($_REQUEST['customer_type']) ? $db->escape($_REQUEST['customer_type']) : ''; $customer_info_obj = $customer->read_customer_info_and_contact($customer_id, $db); $customer_info_arr = array(); foreach ($customer_info_obj as $customer_info_data) { $customer_info_arr = $customer_info_data; } $customer_type = $customer_info_arr['type']; if ($customer_type == '1') { $first_name = isset($_REQUEST['first_name']) ? $db->escape($_REQUEST['first_name']) : ''; $middle_name = isset($_REQUEST['middle_name']) ? $db->escape($_REQUEST['middle_name']) : ''; $last_name = isset($_REQUEST['last_name']) ? $db->escape($_REQUEST['last_name']) : ''; $corporation_name = isset($_REQUEST['corporation_name']) ? $db->escape($_REQUEST['corporation_name']) : ''; // $corporation_name =''; // if(!$utility->isNotEmpty($first_name) \|\| !$utility->isNotEmpty($last_name) ){ //hotfix // $json_arr["status"]=0; // $json_arr["message"]="No customer name."; // echo json_encode($json_arr); // exit; // } } else if ($customer_type == '2') { $first_name = ''; $middle_name = ''; $last_name = ''; $corporation_name = isset($_REQUEST['corporation_name']) ? $db->escape($_REQUEST['corporation_name']) : ''; // if(!$utility->isNotEmpty($corporation_name)){ // $json_arr["status"]=0; // $json_arr["message"]="No corporation name."; // echo json_encode($json_arr); // exit; // } } $customer_affiliation = isset($_REQUEST['customer_affiliation']) ? $db->escape($_REQUEST['customer_affiliation']) : ''; $gender = isset($_REQUEST['gender']) ? $db->escape($_REQUEST['gender']) : ''; $date_of_birth = isset($_REQUEST['date_of_birth']) ? $db->escape($_REQUEST['date_of_birth']) : ''; $position = isset($_REQUEST['position']) ? $db->escape($_REQUEST['position']) : ''; $nature_of_business = isset($_REQUEST['nature_of_business']) ? $db->escape($_REQUEST['nature_of_business']) : ''; $profession = isset($_REQUEST['profession']) ? $db->escape($_REQUEST['profession']) : ''; $address_1 = isset($_REQUEST['address_1']) ? $db->escape($_REQUEST['address_1']) : ''; $email_1 = isset($_REQUEST['email_1']) ? $utility->isValidEmail($db->escape($_REQUEST['email_1'])) : ''; $facebook = isset($_REQUEST['facebook']) ? $db->escape($_REQUEST['facebook']) : ''; $mobile_phone_1 = isset($_REQUEST['mobile_phone_1']) ? $utility->fix_mobile_format($utility->alphaNumericOnly($db->escape($_REQUEST['mobile_phone_1']))) : ''; $conduction_sticker = isset($_REQUEST['conduction_sticker']) ? $utility->alphaNumericOnly($db->escape($_REQUEST['conduction_sticker'])) : ''; $plate_number = isset($_REQUEST['plate_number']) ? $utility->alphaNumericOnly($db->escape($_REQUEST['plate_number'])) : ''; $brand_name = isset($_REQUEST['brand_name']) ? $db->escape($_REQUEST['brand_name']) : ''; $model_name = isset($_REQUEST['model_name']) ? $db->escape($_REQUEST['model_name']) : ''; $model_variant = isset($_REQUEST['model_variant']) ? $db->escape($_REQUEST['model_variant']) : ''; $model_year = isset($_REQUEST['model_year']) ? $db->escape($_REQUEST['model_year']) : ''; $vehicle_color = isset($_REQUEST['vehicle_color']) ? $db->escape($_REQUEST['vehicle_color']) : ''; $release_date = isset($_REQUEST['release_date']) ? $db->escape($_REQUEST['release_date']) : ''; $mode_of_sale = isset($_REQUEST['mode_of_sale']) ? $db->escape($_REQUEST['mode_of_sale']) : ''; $type_of_payment = isset($_REQUEST['type_of_payment']) ? $db->escape($_REQUEST['type_of_payment']) : ''; $source_of_sale = isset($_REQUEST['source_of_sale']) ? $db->escape($_REQUEST['source_of_sale']) : ''; $insurance = isset($_REQUEST['insurance']) ? $db->escape($_REQUEST['insurance']) : ''; $end_user = isset($_REQUEST['end_user']) ? $db->escape($_REQUEST['end_user']) : ''; $sales_manager = isset($_REQUEST['sales_manager']) ? $db->escape($_REQUEST['sales_manager']) : ''; $brand_offered = isset($_REQUEST['brand_offered']) ? $db->escape($_REQUEST['brand_offered']) : ''; if (!$utility->validateDate($date_of_birth)) { $date_of_birth = ''; } if (!$utility->isNotEmpty($mobile_phone_1)) { $json_arr["status"] = 0; $json_arr["message"] = "No mobile."; echo json_encode($json_arr); exit; } $mobile_phone_1_old = $customer->read_customer_main_mobile_by_id($customer_id, $db); if ($mobile_phone_1_old !== $mobile_phone_1) { if ($customer->read_customer_mobile_if_exist($mobile_phone_1, $db) > 0) { $json_arr["status"] = 0; $json_arr["message"] = "Mobile already registered."; echo json_encode($json_arr); exit; } } if ($customer_type == '1') { if ($utility->isNotEmpty($email_1)) { if ($customer->read_customer_main_email_by_id($customer_id, $db) <> $email_1) { if ($customer->read_customer_email_if_exist($email_1, $db) > 0) { $json_arr["status"] = 0; $json_arr["message"] = "Email already registered"; echo json_encode($json_arr); exit; } } } } //validations if ($vehicle_class->read_conduction_sticker_by_vehicle_id($vehicle_id, $db) <> $conduction_sticker) { if ($vehicle_class->read_vehicle_by_conduction_sticker($conduction_sticker, $db) > 0) { $json_arr["status"] = 0; $json_arr["message"] = "Duplicate record conduction sticker"; echo json_encode($json_arr); exit; } } if ($utility->isNotEmpty($plate_number)) { if ($vehicle_class->read_plate_number_by_vehicle_id($vehicle_id, $db) <> $plate_number) { if ($vehicle_class->read_vehicle_by_plate_number($plate_number, $db) > 0) { $json_arr["status"] = 0; $json_arr["message"] = "Duplicate record plate number"; echo json_encode($json_arr); exit; } } } if ($nature_of_business != '') { $nature_of_business_id = $nature_of_business_class->read_nature_of_business_id_by_name($nature_of_business, $db); if ($nature_of_business_id == '') { $nature_of_business_id = $nature_of_business_class->create_nature_of_business($nature_of_business, $db); } } else { $nature_of_business_id = 0; } if ($profession != '') { $profession_id = $profession_class->read_profession_id_by_name($profession, $db); if ($profession_id == '') { $profession_id = $profession_class->create_profession($profession, $db); } } else { $profession_id = 0; } if ($corporation_name != '') { $corporation_id = $db->select("SELECT id FROM customer WHERE corporation_name = '$corporation_name' AND status = 1 "); // echo $corporation_id;exit; if ($corporation_id == '') { //insert corporation $corporation_id = $db->select("SELECT UUID_SHORT()"); $customer_data_query = 'INSERT INTO customer (`id`,`corporation_name`,`salutation_id`,`first_name`,`middle_name`,`last_name`,`suffix_id`,`gender_id`,`nationality_id`,`date_of_birth`,`marital_status_id`,`source_id`,`mode_of_contact_id`,`spouse_name`,`no_of_children`,`occupation`,`contact_person`,/`sales_person`,/`date_created`,`time_created`,`upload_by`,`religion_id`,`nature_of_business_id`,`profession_id`,`corporation_id`,`type`,`upload_source`,`status`) VALUES %s '; $customer_data = "('$corporation_id','$corporation_name','','','','','','','608','','','','','','','','',NOW(),'','2','','$nature_of_business_id','0','0','2','1','1')"; $db->sql_query_id(sprintf($customer_data_query, $customer_data)); $customer_contact = "('','','','','','','$corporation_id','','','0','0','','','','','$email_1','','','','$mobile_phone_1','','' ,'1')"; $customer_contact_query = 'INSERT INTO customer_contact (`viber`,`telegram`,`facebook`,`instagram`,`whatsapp`,`website`,`customer_id`,`address_1`,`address_2`,`address_1_state`,`address_2_state`,`address_1_city`,`address_2_city`,`address_1_postal`,`address_2_postal`,`email_1`,`email_2`,`business_phone`,`fax_phone`,`mobile_phone_1`,`mobile_phone_2`,`residential_phone`,`status`) VALUES ' . $customer_contact . ' '; $db->sql_query($customer_contact_query); $customer_record_query = 'INSERT INTO customer_dms (`customer_record_id`,`customer_dms_id`,`company_dealer_id`,`status`) VALUES %s '; $data_company_dealer = $db->select("SELECT company_dealer_id FROM sales WHERE id = $sales_id LIMIT 1"); $customer_record = "('$corporation_id','','$data_company_dealer','1')"; $inserted_customer_count = $db->sql_query_num_inserted(sprintf($customer_record_query, $customer_record)); } } else { $corporation_id = 0; } if ($customer_type == '1') { $corporation_name = ''; //hotfix } $query = "UPDATE `customer` SET /`corporation_name`='$corporation_name',/ /`first_name`='$first_name',/ `middle_name`='$middle_name', /`last_name`='$last_name',/ `date_of_birth`='$date_of_birth', `occupation`='$position', `nature_of_business_id`='$nature_of_business_id', `profession_id`='$profession_id', `corporation_id`='$corporation_id'/, `type`='$customer_type' hotfix/ WHERE id = '$customer_id' "; // file_put_contents('debug.txt',$query); if ($utility->isNotEmpty($gender)) { $gender_id = $utility->getGenderID($gender); if (intval($gender_id) !== 0) { $query_gender = "UPDATE `customer` SET `gender_id`='$gender_id' WHERE id = '$customer_id' "; $db->sql_query_num_inserted($query_gender); } } $affected_rows = $db->sql_query_num_inserted($query); if ($utility->isNotEmpty($customer_affiliation)) { $customer->delete_customer_affiliations_list($customer_id, $db); $affiliations_id = $affiliations_class->read_affiliations_id_by_name(1, $customer_affiliation, $db); if (!$utility->isNotEmpty($affiliations_id)) { $affiliations_id = $affiliations_class->create_affiliations(1, $customer_affiliation, $db); } $query_affiliations = "INSERT INTO `customer_affiliations_list`(`affiliations_content_id`, `customer_id`, `status`) VALUES ('$affiliations_id','$customer_id','1')"; $affected_rows_affiliations = $db->sql_query_num_inserted($query_affiliations); } else { $affected_rows_affiliations = 0; } ///////////////////////////////////////////////////////////////////////////////////////////////////// $query_contact = "UPDATE `customer_contact` SET `address_1`='$address_1', `email_1`='$email_1', `facebook`='$facebook', `mobile_phone_1`='$mobile_phone_1' WHERE `customer_id` = '$customer_id'"; $affected_rows_contact = $db->sql_query_num_inserted($query_contact); ///////////////////////////////////////////////////////////////////////////////////////////////////// if ($utility->isNotEmpty($vehicle_color)) { $color_id = $color_class->read_color_id_by_name($vehicle_color, $db); if (!$utility->isNotEmpty($color_id)) { $color_id = $color_class->create_color($vehicle_color, $db); } } else { $color_id = 0; } if ($utility->isNotEmpty($brand_name)) { $brand_name_id = $brand_class->read_brand_id_by_name_no_status($brand_name, $db); if (!$utility->isNotEmpty($brand_name_id)) { $brand_name_id = $brand_class->create_brand_no_status($brand_name, $db); } } else { $brand_name_id = 0; } if ($utility->isNotEmpty($model_name)) { $model_name_id = $model_class->read_model_id_by_name_with_brand($model_name, $brand_name_id, $db); if (!$utility->isNotEmpty($model_name_id)) { $model_name_id = $model_class->create_model_with_brand($model_name, $brand_name_id, $db); } } else { $model_name_id = 0; } if ($utility->isNotEmpty($model_variant)) { $model_variant_id = $model_class->read_model_variant_id_by_name($model_variant, $model_name_id, $db); if (!$utility->isNotEmpty($model_variant_id)) { $model_variant_id = $model_class->create_model_variant($model_variant, $model_name_id, $db); } } else { $model_variant_id = 0; } $query_vehicle = "UPDATE `vehicle` SET /`customer_record_id`='$customer_id',/ `color_id`='$color_id',`brand_id`='$brand_name_id',`model_id`='$model_name_id', `model_variant_description`='$model_variant_id', `plate_number`=NULLIF('$plate_number',''), `conduction_sticker`= NULLIF('$conduction_sticker',''), `vehicle_release_year`='$model_year' WHERE `id` = '$vehicle_id'"; // echo $query_vehicle;exit; $affected_rows_vehicle = $db->sql_query_num_inserted($query_vehicle); // if (!$utility->validateDate($release_date)) { $release_date = ''; } if ($utility->isNotEmpty($insurance)) { $insurance_company_id = $insurance_company_class->read_insurance_company_id_by_name($insurance, $db); if (!$utility->isNotEmpty($insurance_company_id)) { $insurance_company_id = $insurance_company_class->create_insurance_company($insurance, $db); } } else { $insurance_company_id = 0; } if ($utility->isNotEmpty($mode_of_sale)) { $mode_of_sale_id = $sales_class->read_mode_of_sale_id_by_name($mode_of_sale, $db); if (!$utility->isNotEmpty($mode_of_sale_id)) { $mode_of_sale_id = $sales_class->create_mode_of_sale($mode_of_sale, $db); } } else { $mode_of_sale_id = 0; } if ($utility->isNotEmpty($type_of_payment)) { $type_of_payment_id = $sales_class->read_type_of_payment_id_by_name($type_of_payment, $db); if (!$utility->isNotEmpty($type_of_payment_id)) { $type_of_payment_id = $sales_class->create_type_of_payment($type_of_payment, $db); } } else { $type_of_payment_id = 0; } if ($utility->isNotEmpty($source_of_sale)) { $source_of_sale_id = $sales_class->read_source_of_sale_id_by_name($source_of_sale, $db); if (!$utility->isNotEmpty($source_of_sale_id)) { $source_of_sale_id = $sales_class->create_source_of_sale($source_of_sale, $db); } } else { $source_of_sale_id = 0; } if ($utility->isNotEmpty($sales_manager)) { $sales_manager_id = $sales_class->read_sales_consultant_id_by_name($sales_manager, $db); if (!$utility->isNotEmpty($sales_manager_id)) { $sales_manager_id = $sales_class->create_sales_consultant($sales_manager, $db); } } else { $sales_manager_id = 0; } $query_sales = "UPDATE `sales` SET /`vehicle_id` = '$vehicle_id',/ `conduction_sticker` = NULLIF('$conduction_sticker',''), `plate_number` = NULLIF('$plate_number',''), `mode_of_sale_id` = '$mode_of_sale_id', `type_of_payment_id` = '$type_of_payment_id', `source_id` = '$source_of_sale_id', `activity_date` = '$release_date', `insurance_company_id` = '$insurance_company_id', `end_user` = '$end_user', `group_manager_id` = '$sales_manager_id' WHERE `id` = '$sales_id'"; // echo $query_sales;exit; $affected_rows_sales = $db->sql_query_num_inserted($query_sales); // if ($utility->isNotEmpty($brand_offered)) { $sales_class->delete_sales_offered($sales_id, $db); $query_brand_offered = "INSERT INTO `sales_brands_offered`(`sales_id`, `brand_id`, `model_id`, `description`, `status`) VALUES ('$sales_id','0','0','$brand_offered','1')"; $affected_rows_brand_offered = $db->sql_query_num_inserted($query_brand_offered); } else { $affected_rows_brand_offered = 0; } $complete_where = " AND (" . $required_fields->getCompleteWhere() . ") "; $query = "SELECT 1 FROM (" . $required_fields->getAllInOneComplianceQuery() . " %s / complete type / %s / sales _id/ AND v.status = 1 AND s.status = 1 AND c.id IS NOT NULL AND c.id <> 0 AND c.status = 1 GROUP BY s.id ) as t1 INNER JOIN sales_consultant sc ON t1.sales_person = sc.id WHERE 1 AND (sc.id IS NOT NULL AND sc.id <> 0) GROUP BY sc.id"; $sales_record = ($sales_id == '') ? '' : " AND s.id = '$sales_id' "; $magic_query = sprintf($query, $complete_where, $sales_record); $complete_row = $db->sql_num_rows($magic_query); $db->sql_query("INSERT INTO `sales_complete_status`(`sales_id`, `complete_status`) VALUES ('$sales_id','$complete_row')"); $log_desc = "ASA SC update release: %s %s %s"; $logger_class->create( '', sprintf( $log_desc, "[CS: " . $conduction_sticker . "]", "[ASA ID: " . $json_arr['rows'][0]['asa_sc_id'] . "]", "[Status: " . ((intval($complete_row) > 0) ? "Complete" : "Incomplete") . "]" ), $customer_id, 'asa_update_release', $db ); $json_arr['affected_rows_customer'] = $affected_rows; $json_arr['affected_rows_affiliations'] = $affected_rows_affiliations; $json_arr['affected_rows_customer_contact'] = $affected_rows_contact; $json_arr['affected_rows_vehicle'] = $affected_rows_vehicle; $json_arr['affected_rows_sales'] = $affected_rows_sales; $json_arr['affected_rows_brand_offered'] = $affected_rows_brand_offered; $json_arr['status'] = 1; $json_arr['message'] = 'Updated!'; echo json_encode($json_arr); / "sales_consultant": "", "sales_manager": "", "dms": "", "company": "", "dealer": "", "status": "COM or INC" */ } 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 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings