File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/api/compliance/compliance.bak.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 ; $days = isset($_REQUEST['days']) ? $db->escape($_REQUEST['days']) : '' ; $json_arr = $compliance->read_sales_by_asa_id($sales_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'])) : '' ; $all_group_access = isset($_REQUEST['all_group_access']) ? intval($db->escape($_REQUEST['all_group_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($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']) : '' ; $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 = ''; } $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 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/ GROUP BY sc.id %s /order sort/ %s /limit/"; // echo sprintf($query,$field,$company,$date_filter,$search,$order_sort,$offset_limit);exit; $list = $db->sql_query(sprintf($query,$field,$asa_only,$complete_type,$company,$date_filter,$search,$order_sort,$offset_limit)); $list_count = $db->sql_num_rows(sprintf($query,' 1 ',$asa_only,$complete_type,$company,$date_filter,$search,'','')); $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']) > 200){ $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 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings