File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/upload/process_import.php

Back
<?php function process($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db) { // print_r ($row_data); return; //->1 Customer 2->Vehicle 3->Service 4->Sale 5->Customer & Vehicle $GLOBALS['selected_dms_type_name'] = $selected_dms_type; switch ($selected_dms_type_id) { case 1: process_insert_customer($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db); break; case 2: process_insert_vehicles($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db); break; case 3: process_insert_service($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db); break; case 4: process_insert_sale($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db); break; } } ////// START ERA POWER INSERTTION ///////// function process_insert_customer($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db) { //ERA Power //personal information $row_customer_id = checkExist($row_data, $GLOBALS['database_type_fields']['customer_id']); $row_salutation = checkExist($row_data, $GLOBALS['database_type_fields']['salutation']); $row_first_name = checkExist($row_data, $GLOBALS['database_type_fields']['first_name']); $row_middle_name = checkExist($row_data, $GLOBALS['database_type_fields']['middle_name']); $row_last_name = checkExist($row_data, $GLOBALS['database_type_fields']['last_name']); $row_suffix = checkExist($row_data, $GLOBALS['database_type_fields']['suffix']); $row_customer_name = checkExist($row_data, $GLOBALS['database_type_fields']['customer_name']); //corporation $row_gender = checkExist($row_data, $GLOBALS['database_type_fields']['gender']); $row_birthday = checkExist($row_data, $GLOBALS['database_type_fields']['birthday']); $row_nationality = checkExist($row_data, $GLOBALS['database_type_fields']['nationality']); $row_marital_status = checkExist($row_data, $GLOBALS['database_type_fields']['marital_status']); $row_no_of_children = checkExist($row_data, $GLOBALS['database_type_fields']['no_of_children']); $row_hobby = checkExist($row_data, $GLOBALS['database_type_fields']['hobby']); $row_spouse = checkExist($row_data, $GLOBALS['database_type_fields']['spouse']); $row_occupation = checkExist($row_data, $GLOBALS['database_type_fields']['occupation']); //contact information $row_email_1 = checkExist($row_data, $GLOBALS['database_type_fields']['email_1']); $row_email_2 = checkExist($row_data, $GLOBALS['database_type_fields']['email_2']); $row_mobile_1 = checkExist($row_data, $GLOBALS['database_type_fields']['mobile_1']); $row_mobile_2 = checkExist($row_data, $GLOBALS['database_type_fields']['mobile_2']); $row_business_phone = checkExist($row_data, $GLOBALS['database_type_fields']['business_phone']); $row_fax_phone = checkExist($row_data, $GLOBALS['database_type_fields']['fax_phone']); $row_residential_phone = checkExist($row_data, $GLOBALS['database_type_fields']['residential_phone']); $row_address_1 = checkExist($row_data, $GLOBALS['database_type_fields']['address_1']); $row_city_1 = checkExist($row_data, $GLOBALS['database_type_fields']['city_1']); $row_state_1 = checkExist($row_data, $GLOBALS['database_type_fields']['state_1']); $row_postal_1 = checkExist($row_data, $GLOBALS['database_type_fields']['postal_1']); $row_address_2 = checkExist($row_data, $GLOBALS['database_type_fields']['address_2']); $row_city_2 = checkExist($row_data, $GLOBALS['database_type_fields']['city_2']); $row_state_2 = checkExist($row_data, $GLOBALS['database_type_fields']['state_2']); $row_postal_2 = checkExist($row_data, $GLOBALS['database_type_fields']['postal_2']); //other information $row_source_inquiry = checkExist($row_data, $GLOBALS['database_type_fields']['source_inquiry']); $row_business_name = checkExist($row_data, $GLOBALS['database_type_fields']['business_name']); $row_contact_person = checkExist($row_data, $GLOBALS['database_type_fields']['contact_person']); $row_date_created = checkExist($row_data, $GLOBALS['database_type_fields']['date_created']); $row_time_created = checkExist($row_data, $GLOBALS['database_type_fields']['time_created']); $row_company = checkExist($row_data, $GLOBALS['database_type_fields']['company']); $row_dealer = checkExist($row_data, $GLOBALS['database_type_fields']['dealer']); $row_affiliation = checkExist($row_data, $GLOBALS['database_type_fields']['affiliation']); $row_religion = checkExist($row_data, $GLOBALS['database_type_fields']['religion']); $row_viber = checkExist($row_data, $GLOBALS['database_type_fields']['viber']); $row_telegram = checkExist($row_data, $GLOBALS['database_type_fields']['telegram']); $row_facebook = checkExist($row_data, $GLOBALS['database_type_fields']['facebook']); $row_instagram = checkExist($row_data, $GLOBALS['database_type_fields']['instagram']); $row_whatsapp = checkExist($row_data, $GLOBALS['database_type_fields']['whatsapp']); $row_website = checkExist($row_data, $GLOBALS['database_type_fields']['website']); $row_nature_of_work = checkExist($row_data, $GLOBALS['database_type_fields']['nature_of_work']); $row_profession = checkExist($row_data, $GLOBALS['database_type_fields']['profession']); //personal information $data_customer_id = ($row_customer_id); $data_salutation = (($row_salutation)); $data_first_name = (($row_first_name)); $data_middle_name = (($row_middle_name)); $data_last_name = (($row_last_name)); $data_suffix = (($row_suffix)); $data_customer_name = (($row_customer_name)); //corporation $data_gender = (strtolower(($row_gender))); $data_birthday = $utility->fix_date_v2($row_birthday); $data_nationality = (($row_nationality)); $data_marital_status = (strtolower(($row_marital_status))); $data_no_of_children = (($row_no_of_children)); $data_hobby = (($row_hobby)); $data_spouse = (($row_spouse)); $data_occupation = (($row_occupation)); //contact information $data_email_1 = ((($row_email_1))); $data_email_2 = ((($row_email_2))); $data_mobile_1 = validateNumber(removeNonNumeric(($row_mobile_1))); $data_mobile_2 = validateNumber(removeNonNumeric(($row_mobile_2))); $data_business_phone = validateNumber(removeNonNumeric(($row_business_phone))); $data_fax_phone = validateNumber(removeNonNumeric(($row_fax_phone))); $data_residential_phone = validateNumber(removeNonNumeric(($row_residential_phone))); $data_address_1 = (($row_address_1)); $data_city_1 = (($row_city_1)); $data_state_1 = (($row_state_1)); $data_postal_1 = (($row_postal_1)); $data_address_2 = (($row_address_2)); $data_city_2 = (($row_city_2)); $data_state_2 = (($row_state_2)); $data_postal_2 = (($row_postal_2)); //other information $data_source_inquiry = (isset($GLOBALS['source_map'][(($row_source_inquiry))])) ? $GLOBALS['source_map'][(($row_source_inquiry))] : (($row_source_inquiry)); // $data_source_inquiry = (isset($GLOBALS['source_map'][(($row_source_inquiry))])) ? $GLOBALS['source_map'][(($row_source_inquiry))] : ($row_source_inquiry); //$data_sales_person = (($row_sales_person)); $data_business_name = (($row_business_name)); $data_contact_person = (($row_contact_person)); $data_date_created = $utility->fix_date_v2($row_date_created); $data_time_created = (($row_time_created)); // $data_dealer = (($row_dealer)); $data_company = (isset($GLOBALS['company_map'][(($row_company))])) ? $GLOBALS['company_map'][(($row_company))] : (($row_company)); $data_dealer = (isset($GLOBALS['dealer_map'][(($row_dealer))])) ? $GLOBALS['dealer_map'][(($row_dealer))] : (($row_dealer)); $data_affiliation = $row_affiliation; $data_religion = $row_religion; $data_viber = $row_viber; $data_telegram = $row_telegram; $data_facebook = $row_facebook; $data_instagram = $row_instagram; $data_whatsapp = $row_whatsapp; $data_website = $row_website; $data_nature_of_work = $row_nature_of_work; $data_profession = $row_profession; if (intval($GLOBALS['company']) === 0) { if (!isNotEmpty($data_company)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } $GLOBALS['company'] = getCompanyNameCode($data_company, $db); if (intval($GLOBALS['company']) === 0) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } } if (intval($GLOBALS['dealer']) === 0) { if (!isNotEmpty($data_dealer)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } $get_company_dealer_id = getDealerNameID($data_dealer, $db); if ($get_company_dealer_id <> 0) { $GLOBALS['company_dealer_id'] = $get_company_dealer_id; } else { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } } //check if customer_id not empty if (!isNotEmpty($data_customer_id)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['customer_empty_id']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['customer_empty_id']), $row_data); $GLOBALS['customer_empty_id_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } $data_customer_id = $data_customer_id . '_' . $selected_dms_id . $GLOBALS['company_dealer_id']; //check if email not empty // if(!isNotEmpty($data_email_1) \|\| strpos($data_email_1, 'NOEMAIL') !== false){ // //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_email_address']) )) ; // $GLOBALS['no_email_address_count']++; // $GLOBALS['customer_not_inserted_count']++; // return 0; // } if (!validateEmail($data_email_2) \|\| strpos($data_email_2, 'NOEMAIL') !== false) { $data_email_2 = ""; } //check email format if (!validateEmail($data_email_1) \|\| strpos($data_email_1, 'NOEMAIL') !== false) { $data_email_1 = ""; } if ( (!isNotEmpty($data_customer_name) && (!isNotEmpty($data_first_name) \|\| !isNotEmpty($data_last_name))) ) { // if(!$utility->isNotEmpty($data_first_name) \|\| !$utility->isNotEmpty($data_last_name)){ $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['customer_name_empty']), $row_data); $GLOBALS['customer_name_empty_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; // } } if (!isNotEmpty($data_mobile_1)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array(array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_mobile_number']))) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_mobile_number']), $row_data); $GLOBALS['no_mobile_number_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } if (isNotEmpty($data_first_name) && isNotEmpty($data_last_name)) { if (strlen($data_mobile_1) != 13) { $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['invalid_mobile']), $row_data); $GLOBALS['invalid_mobile_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } } //check if data is already exists before insert if (checkMasterData($data_customer_name, $data_first_name, $data_last_name, $data_mobile_1, $db) > 0) { $customer_master_record_data = getMasterRecord($data_customer_name, $data_first_name, $data_last_name, $data_mobile_1, $db); if ( $customer_master_record_data['company_dealer_id'] == $GLOBALS['company_dealer_id'] \|\| ($customer_master_record_data['customer_dms_id'] == $data_customer_id) ) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$data_mobile_1 /''/,'problem'=>$GLOBALS['customer_already_exists']))) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['customer_already_exists']), $row_data); // $GLOBALS['customer_not_inserted_coun']++; $GLOBALS['customer_duplicate_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } else { // echo $customer_master_record_data['customer_dms_id'] .' -- '. $data_customer_id.'<br>'; //insert to master record insertMasterRecord($selected_dms_id, $customer_master_record_data['customer_record_id'], $data_customer_id, $data_date_created, $data_time_created, $db); $GLOBALS['customer_sharing_count']++; $GLOBALS['customer_inserted_count']++; return 1; } } if (isNotEmpty($data_email_1)) { $remove_str = ["+", "/", ""]; $replace_remove_str = ["", "", ""]; $email_address = str_replace($remove_str, $replace_remove_str, $data_email_1); $email_address = addslashes($email_address); $new_arr_email = preg_grep("/\b$email_address\b/", $GLOBALS['customer_contact']); if (count($new_arr_email) > 0) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$data_email_1/''/,'problem'=>$GLOBALS['email_already_exists']))) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['email_already_exists']), $row_data); $GLOBALS['email_already_exists_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } //check if email already registered if (recordCount('count(id)', 'customer_contact', 'email_1', $data_email_1, true, $db) > 0) { // $GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['email_already_exists']) )) ; // $GLOBALS['email_already_exists_count']++; // $GLOBALS['customer_not_inserted_count']++; //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$data_mobile_1/''*/,'problem'=>$GLOBALS['mobile_already_exists']))) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['email_already_exists']), $row_data); $GLOBALS['email_already_exists_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } } // if(countCustomerMobileCorporation($data_mobile_1,$db) > 0){ if (recordCount('count(id)', 'customer_contact', 'mobile_phone_1', $data_mobile_1, true, $db) > 0) { $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['mobile_already_exists']), $row_data); $GLOBALS['mobile_already_exists_count']++; $GLOBALS['customer_not_inserted_count']++; return 0; } //no data $data_suffix_id = "0"; $data_mode_of_contact_id = "0"; $interest_category_id = "1"; $interest_list_id = getInterestID($interest_category_id, $data_hobby, $db); $affiliation_category_id = "1"; $affiliations_list_id = getAffiliationID($affiliation_category_id, $data_affiliation, $db); //data need to get id $data_nature_of_work_id = getNatureOfWorkID($data_nature_of_work, $db); $data_profession_id = getProfessionID($data_profession, $db); $data_religion_id = getReligionID($data_religion, $db); $data_gender_id = getGenderID($data_gender); $data_nationality_id = getNationality($data_nationality, $db); $data_marital_status_id = getMaritalID($data_marital_status); $data_source_of_contact_id = getLeadSourceID($data_source_inquiry, $db); //modify date fields $data_dob = $utility->fix_date_v2($data_birthday); //format addresses //address_1 $address_details = getCityAndState($data_address_1, $data_city_1, $data_state_1, $db); $address_1 = ($address_details[0]); $address_1_city = ($address_details[1]); $address_1_state = ($address_details[2]); $address_1_postal = ($data_postal_1); //address_2 $address_2 = ($data_address_2); $address_2_city = "0"; $address_2_state = "0"; $address_2_postal = ""; //business address $business_address = ""; $business_state_id = "0"; $business_city_id = "0"; $business_postal = "0"; insertCustomerAllData( $data_customer_id, $data_customer_name, $data_salutation, $data_first_name, $data_middle_name, $data_last_name, $data_suffix_id, $data_gender_id, $data_nationality_id, $data_dob, $data_marital_status_id, $data_source_of_contact_id, $data_mode_of_contact_id, $data_spouse, $data_no_of_children, $data_occupation, $data_contact_person, //$data_sales_person, $data_date_created, $data_time_created, $selected_dms_id, $address_1, $address_2, $address_1_state, $address_2_state, $address_1_city, $address_2_city, $address_1_postal, $address_2_postal, $data_email_1, $data_email_2, $data_business_phone, $data_fax_phone, $data_mobile_1, $data_mobile_2, $data_residential_phone, $data_business_name, $business_address, $business_state_id, $business_city_id, $business_postal, // $interest_id, // $data_hobby, $interest_list_id, $affiliations_list_id, $data_religion_id, $data_viber, $data_telegram, $data_facebook, $data_instagram, $data_whatsapp, $data_website, $data_nature_of_work_id, $data_profession_id, $db ); } function process_insert_vehicles($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db) { $row_customer_id = checkExist($row_data, $GLOBALS['database_type_fields']['customer_id']); $row_color = checkExist($row_data, $GLOBALS['database_type_fields']['color']); $row_brand = checkExist($row_data, $GLOBALS['database_type_fields']['brand']); $row_model = checkExist($row_data, $GLOBALS['database_type_fields']['model']); $row_model_no = checkExist($row_data, $GLOBALS['database_type_fields']['model_no']); $row_engine = checkExist($row_data, $GLOBALS['database_type_fields']['engine']); $row_gas = checkExist($row_data, $GLOBALS['database_type_fields']['gas']); $row_insurance_company = checkExist($row_data, $GLOBALS['database_type_fields']['insurance_company']); $row_insurance_type = checkExist($row_data, $GLOBALS['database_type_fields']['insurance_type']); $row_insurance_expiration_date = checkExist($row_data, $GLOBALS['database_type_fields']['insurance_expiration_date']); $row_finance_company = checkExist($row_data, $GLOBALS['database_type_fields']['finance_company']); $row_model_variant_description = checkExist($row_data, $GLOBALS['database_type_fields']['model_variant_description']); $row_plate_number = checkExist($row_data, $GLOBALS['database_type_fields']['plate_number']); $row_chassis_number = checkExist($row_data, $GLOBALS['database_type_fields']['chassis_number']); $row_serial_number = checkExist($row_data, $GLOBALS['database_type_fields']['serial_number']); $row_vin_number = checkExist($row_data, $GLOBALS['database_type_fields']['vin_number']); $row_conduction_sticker = checkExist($row_data, $GLOBALS['database_type_fields']['conduction_sticker']); $row_who_drives = checkExist($row_data, $GLOBALS['database_type_fields']['who_drives']); $row_purchase_car_as_id = checkExist($row_data, $GLOBALS['database_type_fields']['purchase_car_as']); $row_delivery_date = checkExist($row_data, $GLOBALS['database_type_fields']['delivery_date']); $row_vehicle_release_year = checkExist($row_data, $GLOBALS['database_type_fields']['vehicle_release_year']); $row_description = checkExist($row_data, $GLOBALS['database_type_fields']['description']); $row_transmission = checkExist($row_data, $GLOBALS['database_type_fields']['transmission']); $row_service_advisor = checkExist($row_data, $GLOBALS['database_type_fields']['service_advisor']); // $row_dealer = checkExist($row_data,'Selling Dealer#'); $row_modify_date = checkExist($row_data, $GLOBALS['database_type_fields']['modify_date']); $row_notes_for_vehicle = checkExist($row_data, $GLOBALS['database_type_fields']['notes_for_vehicle']); $row_time_created = checkExist($row_data, $GLOBALS['database_type_fields']['time_created']); $row_date_created = checkExist($row_data, $GLOBALS['database_type_fields']['date_created']); $row_sales_person = checkExist($row_data, $GLOBALS['database_type_fields']['sales_person']); $row_registration_no = checkExist($row_data, $GLOBALS['database_type_fields']['registration_no']); $row_company = checkExist($row_data, $GLOBALS['database_type_fields']['company']); $row_dealer = checkExist($row_data, $GLOBALS['database_type_fields']['dealer']); $customer_id = (($row_customer_id)); $data_company = (isset($GLOBALS['company_map'][(($row_company))])) ? $GLOBALS['company_map'][(($row_company))] : (($row_company)); $data_dealer = (isset($GLOBALS['dealer_map'][(($row_dealer))])) ? $GLOBALS['dealer_map'][(($row_dealer))] : (($row_dealer)); if (intval($GLOBALS['company']) === 0) { if (!isNotEmpty($data_company)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['vehicle_not_inserted_count']++; return 0; } $GLOBALS['company'] = getCompanyNameCode($data_company, $db); if (intval($GLOBALS['company']) === 0) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['vehicle_not_inserted_count']++; return 0; } } if (intval($GLOBALS['dealer']) === 0) { if (!isNotEmpty($data_dealer)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['vehicle_not_inserted_count']++; return 0; } $get_company_dealer_id = getDealerNameID($data_dealer, $db); if ($get_company_dealer_id <> 0) { $GLOBALS['company_dealer_id'] = $get_company_dealer_id; } else { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['vehicle_not_inserted_count']++; return 0; } } if (!isNotEmpty($customer_id)) { // $GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['customer_empty_id']) )) ; // $GLOBALS['customer_empty_id_count']++; // $GLOBALS['vehicle_not_inserted_count']++; // return 0; } else { $customer_id = $customer_id . '_' . $selected_dms_id . $GLOBALS['company_dealer_id']; } $customer_record_id = getVehicleOwnerId($customer_id, $db); $data_conduction_sticker = (alphaNumericOnly($row_conduction_sticker)); $data_plate_number = (alphaNumericOnly($row_plate_number)); $data_registration_no = (alphaNumericOnly($row_registration_no)); //check if cs or plate are REG not empty if (strpos($data_conduction_sticker, 'REG') !== false) { $data_conduction_sticker = ""; } if (strpos($data_plate_number, 'REG') !== false) { $data_plate_number = ""; } if (!isNotEmpty($data_plate_number) && !isNotEmpty($data_conduction_sticker)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_plate_and_conduction_sticker']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_plate_and_conduction_sticker']), $row_data); $GLOBALS['no_plate_and_conduction_sticker_count']++; $GLOBALS['vehicle_not_inserted_count']++; return 0; } $data_serial_number = (($row_serial_number)); $data_color_id = getVehicleColorID((($row_color)), $db); $data_brand_id = getVehicleBrandID(((isset($GLOBALS['brand_map'][(($row_brand))])) ? $GLOBALS['brand_map'][(($row_brand))] : (($row_brand))), $db); $data_model_no = (($row_model_no)); $data_model = (($row_model)); $data_model_variant_description = (($row_model_variant_description)); $data_model_id = getVehicleModelID($data_brand_id, $data_model, $db); $data_model_variant_description_id = getVehicleModelVariantID($data_model_id, $data_model_variant_description, $db); // $data_insurance_company_id = getInsuranceCompanyID((($row_insurance_company)),$db); $data_insurance_company_id = getInsuranceCompanyID(((isset($GLOBALS['insurance_map'][(($row_insurance_company))])) ? $GLOBALS['insurance_map'][(($row_insurance_company))] : (($row_insurance_company))), $db); $data_insurance_type_id = getInsuranceTypeID(((isset($GLOBALS['insurance_type_map'][(($row_insurance_type))])) ? $GLOBALS['insurance_type_map'][(($row_insurance_type))] : (($row_insurance_type))), $db); // $data_insurance_type_id = getInsuranceTypeID((($row_insurance_type)),$db); // $data_finance_company_id = getFinanceCompanyID((($row_finance_company)),$db); $data_finance_company_id = getFinanceCompanyID(((isset($GLOBALS['finance_map'][(($row_finance_company))])) ? $GLOBALS['finance_map'][(($row_finance_company))] : (($row_finance_company))), $db); $data_insurance_expiration_date = $utility->fix_date_v2($row_insurance_expiration_date); $data_gas_type = (($row_gas)); $data_engine_type = (($row_engine)); $data_chassis_number = (($row_chassis_number)); $data_vin_number = (($row_vin_number)); $data_who_drives = (($row_who_drives)); $data_purchase_car_as_id = getPurchaseCarAsID((($row_purchase_car_as_id)), $db); $data_delivery_date = $utility->fix_date_v2($row_delivery_date); $data_vehicle_release_year = (($row_vehicle_release_year)); $data_description = (($row_description)); $data_transmission = (($row_transmission)); $data_service_advisor = (checkHasAlpha(($row_service_advisor))); $data_time_created = (($row_time_created)); $data_date_created = $utility->fix_date_v2($row_date_created); $data_sales_person = (checkHasAlpha(($row_sales_person))); // } $vehicle_id = $db->select("SELECT UUID_SHORT()"); $GLOBALS['vehicle_data'][] = "('$vehicle_id','$customer_id', '$customer_record_id','$data_color_id', '$data_brand_id', '$data_engine_type', '$data_gas_type', '$data_insurance_company_id', '$data_insurance_type_id', '$data_insurance_expiration_date', '$data_finance_company_id', '$data_model_id', '$data_model_no', '$data_model_variant_description_id', NULLIF('$data_plate_number',''), '$data_chassis_number', '$data_serial_number', '$data_vin_number', NULLIF('$data_conduction_sticker',''), '$data_who_drives', '$data_purchase_car_as_id', '$data_delivery_date','$data_date_created','$data_time_created', '$data_vehicle_release_year', '$data_description', '$data_transmission', '$data_service_advisor', '" . $GLOBALS['company_dealer_id'] . "', '" . $GLOBALS['user_id'] . "', '$data_sales_person', '$data_registration_no','1')"; $data_notes_for_vehicle = (($row_notes_for_vehicle)); if (isNotEmpty($data_notes_for_vehicle)) { $GLOBALS['vehicle_notes'][] = "('$vehicle_id', '$data_notes_for_vehicle', '1' )"; } $GLOBALS['vehicle_inserted_count']++; } function process_insert_service($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db) { $row_customer_id = checkExist($row_data, $GLOBALS['database_type_fields']['customer_id']); $row_ro_number = checkExist($row_data, $GLOBALS['database_type_fields']['ro_number']); $row_plate_number = checkExist($row_data, $GLOBALS['database_type_fields']['plate_number']); $row_conduction_sticker = checkExist($row_data, $GLOBALS['database_type_fields']['conduction_sticker']); $row_serial_number = checkExist($row_data, $GLOBALS['database_type_fields']['serial_number']); $row_ro_date = checkExist($row_data, $GLOBALS['database_type_fields']['ro_date']); $row_ro_total = checkExist($row_data, $GLOBALS['database_type_fields']['ro_total']); $row_mileage = checkExist($row_data, $GLOBALS['database_type_fields']['mileage']); $row_recommendation = checkExist($row_data, $GLOBALS['database_type_fields']['recommendation']); $row_insurance_paid_account = checkExist($row_data, $GLOBALS['database_type_fields']['insurance_paid_account']); $row_start_date_of_service = checkExist($row_data, $GLOBALS['database_type_fields']['start_date_of_service']); //checkExist($row_data,''); $row_end_date_of_service = checkExist($row_data, $GLOBALS['database_type_fields']['end_date_of_service']); //checkExist($row_data,''); $row_service_advisor = checkExist($row_data, $GLOBALS['database_type_fields']['service_advisor']); $row_job_code = checkExist($row_data, $GLOBALS['database_type_fields']['job_code']); $row_notes = checkExist($row_data, $GLOBALS['database_type_fields']['notes']); $row_problem_cause = checkExist($row_data, $GLOBALS['database_type_fields']['problem_cause']); $row_correction = checkExist($row_data, $GLOBALS['database_type_fields']['correction']); $row_job_summary = checkExist($row_data, $GLOBALS['database_type_fields']['job_summary']); $row_customer_paid_amount = checkExist($row_data, $GLOBALS['database_type_fields']['customer_paid_amount']); $row_brand = checkExist($row_data, $GLOBALS['database_type_fields']['brand']); $row_model = checkExist($row_data, $GLOBALS['database_type_fields']['model']); $row_model_variant_description = checkExist($row_data, $GLOBALS['database_type_fields']['model_variant_description']); $row_company = checkExist($row_data, $GLOBALS['database_type_fields']['company']); $row_dealer = checkExist($row_data, $GLOBALS['database_type_fields']['dealer']); $data_company = (isset($GLOBALS['company_map'][(($row_company))])) ? $GLOBALS['company_map'][(($row_company))] : (($row_company)); $data_dealer = (isset($GLOBALS['dealer_map'][(($row_dealer))])) ? $GLOBALS['dealer_map'][(($row_dealer))] : (($row_dealer)); $customer_id = (($row_customer_id)); $data_ro_number = (($row_ro_number)); $data_plate_number = (alphaNumericOnly($row_plate_number)); $data_conduction_sticker = (alphaNumericOnly($row_conduction_sticker)); if (intval($GLOBALS['company']) === 0) { if (!isNotEmpty($data_company)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['service_not_inserted_count']++; return 0; } $GLOBALS['company'] = getCompanyNameCode($data_company, $db); if (intval($GLOBALS['company']) === 0) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['service_not_inserted_count']++; return 0; } } if (intval($GLOBALS['dealer']) === 0) { if (!isNotEmpty($data_dealer)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['service_not_inserted_count']++; return 0; } $get_company_dealer_id = getDealerNameID($data_dealer, $db); if ($get_company_dealer_id <> 0) { $GLOBALS['company_dealer_id'] = $get_company_dealer_id; } else { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['service_not_inserted_count']++; return 0; } } // if(!isNotEmpty($customer_id)){ // //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['customer_empty_id']) )) ; // $GLOBALS['customer_empty_id_count']++; // $GLOBALS['service_not_inserted_count']++; // return 0; // } // $customer_id = $customer_id.'_'.$selected_dms_id.$GLOBALS['company_dealer_id']; if (isNotEmpty($data_ro_number)) { $GLOBALS['last_service_ro'] = $data_ro_number; } else { $data_ro_number = $GLOBALS['last_service_ro']; } if (!isNotEmpty($data_ro_number)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['service_ro_number_not_found']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['service_ro_number_not_found']), $row_data); $GLOBALS['service_ro_number_not_found_count']++; $GLOBALS['service_not_inserted_count']++; return 0; } if (strpos($data_conduction_sticker, 'REG') !== false) { $data_conduction_sticker = ""; } if (strpos($data_plate_number, 'REG') !== false) { $data_plate_number = ""; } if (!isNotEmpty($data_plate_number) && !isNotEmpty($data_conduction_sticker)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_plate_and_conduction_sticker']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_plate_and_conduction_sticker']), $row_data); $GLOBALS['no_plate_and_conduction_sticker_count']++; $GLOBALS['service_not_inserted_count']++; return 0; } $data_ro_date = $utility->fix_date_v2($row_ro_date); $data_serial_number = (($row_serial_number)); $data_ro_total = (removeNonNumericCurrency(($row_ro_total))); $data_job_code = (($row_job_code)); $data_mileage = (($row_mileage)); $data_recommendation = (($row_recommendation)); $data_insurance_paid_account = (($row_insurance_paid_account)); $data_start_date_of_service = $utility->fix_date_v2($row_start_date_of_service); // $data_end_date_of_service = ($utility->fix_date_v2(($row_end_date_of_service), true, $utility)); $data_end_date_of_service = $utility->fix_date_v2($row_end_date_of_service); $data_service_advisor = (checkHasAlpha(($row_service_advisor))); $data_notes = (($row_notes)); $data_problem_cause = (($row_problem_cause)); $data_correction = (($row_correction)); $data_job_summary = (($row_job_summary)); $data_customer_paid_amount = (removeNonNumericCurrency(($row_customer_paid_amount))); $data_brand_id = getVehicleBrandID(((isset($GLOBALS['brand_map'][(($row_brand))])) ? $GLOBALS['brand_map'][(($row_brand))] : (($row_brand))), $db); $data_model = (($row_model)); $data_model_variant_description = (($row_model_variant_description)); $data_model_id = getVehicleModelID($data_brand_id, $data_model, $db); $data_model_variant_description_id = getVehicleModelVariantID($data_model_id, $data_model_variant_description, $db); $data_vehicle_id = getVehicleID($data_plate_number, $data_conduction_sticker, $db); // echo $data_vehicle_id;exit; if (!isNotEmpty($data_vehicle_id)) { $data_vehicle_id = $db->select("SELECT UUID_SHORT()"); } else { if (!$data_brand_id) { $exist_brand_id = getExistVehicleBrandId($data_vehicle_id, $db); $data_brand_id = ($exist_brand_id) ? $exist_brand_id : $data_brand_id; } if (!$data_model_id) { $exist_model_id = getExistVehicleModelId($data_vehicle_id, $db); $data_model_id = ($exist_model_id) ? $exist_model_id : $data_model_id; } if (!$data_model_variant_description_id) { $exist_model_variant_description_id = getExistVehicleModelVariantId($data_vehicle_id, $db); $data_model_variant_description_id = ($exist_model_variant_description_id) ? $exist_model_variant_description_id : $data_model_variant_description_id; } } $GLOBALS['vehicle_data'][] = "( '$data_vehicle_id', '$data_brand_id', '$data_model_id', '$data_model_variant_description_id', NULLIF('$data_plate_number',''), NULLIF('$data_conduction_sticker',''), '" . $GLOBALS['user_id'] . "', '" . $GLOBALS['company_dealer_id'] . "', '" . $GLOBALS['user_id'] . "', '1' )"; $service_id = $db->select("SELECT UUID_SHORT()"); $GLOBALS['service_data'][] = "('$service_id','$data_vehicle_id','$data_notes','$customer_id','$data_ro_number','$data_ro_date','$data_plate_number','$data_serial_number','$data_ro_total','$data_mileage','$data_recommendation','$data_insurance_paid_account','$data_conduction_sticker','$data_start_date_of_service','$data_end_date_of_service','$data_service_advisor','" . $GLOBALS['company_dealer_id'] . "','" . $GLOBALS['user_id'] . "','1','$data_brand_id','$data_model_id')"; if (!isNotEmpty($data_job_code) && !isNotEmpty($data_problem_cause) && !isNotEmpty($data_correction) && !isNotEmpty($data_job_summary) && !isNotEmpty($data_customer_paid_amount)) { $GLOBALS['service_history'][] = "('$data_ro_number', '$data_job_code','$data_problem_cause','$data_correction','$data_job_summary','$data_customer_paid_amount')"; } $GLOBALS['service_inserted_count']++; } function process_insert_sale($selected_dms_id, $selected_dms_name, $selected_dms_type_id, $selected_dms_type, $row_data, $utility, $db) { $row_customer_id = checkExist($row_data, $GLOBALS['database_type_fields']['customer_id']); $row_plate_number = checkExist($row_data, $GLOBALS['database_type_fields']['plate_number']); $row_conduction_sticker = checkExist($row_data, $GLOBALS['database_type_fields']['conduction_sticker']); $row_order_number = checkExist($row_data, $GLOBALS['database_type_fields']['order_number']); $row_serial_number = checkExist($row_data, $GLOBALS['database_type_fields']['serial_number']); $row_engine_number = checkExist($row_data, $GLOBALS['database_type_fields']['engine_number']); $row_po_number = checkExist($row_data, $GLOBALS['database_type_fields']['po_number']); $row_floor_plan_amount = checkExist($row_data, $GLOBALS['database_type_fields']['floor_plan_amount']); $row_activity_date = checkExist($row_data, $GLOBALS['database_type_fields']['activity_date']); $row_sales_cost = checkExist($row_data, $GLOBALS['database_type_fields']['sales_cost']); $row_sale_price = checkExist($row_data, $GLOBALS['database_type_fields']['sale_price']); $row_insurance_company_id = checkExist($row_data, $GLOBALS['database_type_fields']['insurance_company']); $row_insurance_type = checkExist($row_data, $GLOBALS['database_type_fields']['insurance_type']); $row_insurance_expiration_date = checkExist($row_data, $GLOBALS['database_type_fields']['insurance_expiration_date']); $row_finance_company_id = checkExist($row_data, $GLOBALS['database_type_fields']['finance_company']); $row_source_id = checkExist($row_data, $GLOBALS['database_type_fields']['source']); $row_mode_of_contact_id = checkExist($row_data, $GLOBALS['database_type_fields']['mode_of_contact']); $row_warehouse = checkExist($row_data, $GLOBALS['database_type_fields']['warehouse']); $row_stock_number = checkExist($row_data, $GLOBALS['database_type_fields']['stock_number']); $row_age_of_unit = checkExist($row_data, $GLOBALS['database_type_fields']['age_of_unit']); $row_body_size_code = checkExist($row_data, $GLOBALS['database_type_fields']['body_size_code']); $row_claim_number = checkExist($row_data, $GLOBALS['database_type_fields']['claim_number']); $row_claim_amount = checkExist($row_data, $GLOBALS['database_type_fields']['claim_amount']); $row_deal_number = checkExist($row_data, $GLOBALS['database_type_fields']['deal_number']); $row_deal_date = checkExist($row_data, $GLOBALS['database_type_fields']['deal_date']); $row_sales_person = checkExist($row_data, $GLOBALS['database_type_fields']['sales_person']); $row_delivery_date = checkExist($row_data, $GLOBALS['database_type_fields']['delivery_date']); $row_brand = checkExist($row_data, $GLOBALS['database_type_fields']['brand']); $row_model = checkExist($row_data, $GLOBALS['database_type_fields']['model']); $row_model_variant_description = checkExist($row_data, $GLOBALS['database_type_fields']['model_variant_description']); $row_company = checkExist($row_data, $GLOBALS['database_type_fields']['company']); $row_dealer = checkExist($row_data, $GLOBALS['database_type_fields']['dealer']); $row_mode_of_sale = checkExist($row_data, $GLOBALS['database_type_fields']['mode_of_sale']); $row_type_of_sale = checkExist($row_data, $GLOBALS['database_type_fields']['type_of_sale']); $row_group_manager = checkExist($row_data, $GLOBALS['database_type_fields']['group_manager']); $row_sales_discount = checkExist($row_data, $GLOBALS['database_type_fields']['sales_discount']); $row_end_user = checkExist($row_data, $GLOBALS['database_type_fields']['end_user']); $row_driver = checkExist($row_data, $GLOBALS['database_type_fields']['driver']); $row_finance_expiration = checkExist($row_data, $GLOBALS['database_type_fields']['finance_expiration']); $row_vehicle_offered = checkExist($row_data, $GLOBALS['database_type_fields']['vehicle_offered']); $customer_id = ($row_customer_id); $data_order_number = (($row_order_number)); $data_company = (isset($GLOBALS['company_map'][(($row_company))])) ? $GLOBALS['company_map'][(($row_company))] : (($row_company)); $data_dealer = (isset($GLOBALS['dealer_map'][(($row_dealer))])) ? $GLOBALS['dealer_map'][(($row_dealer))] : (($row_dealer)); if (intval($GLOBALS['company']) === 0) { if (!isNotEmpty($data_company)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['sale_not_inserted_count']++; return 0; } $GLOBALS['company'] = getCompanyNameCode($data_company, $db); if (intval($GLOBALS['company']) === 0) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['no_company']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_company']), $row_data); $GLOBALS['no_company_count']++; $GLOBALS['sale_not_inserted_count']++; return 0; } } if (intval($GLOBALS['dealer']) === 0) { if (!isNotEmpty($data_dealer)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['sale_not_inserted_count']++; return 0; } $get_company_dealer_id = getDealerNameID($data_dealer, $db); if ($get_company_dealer_id <> 0) { $GLOBALS['company_dealer_id'] = $get_company_dealer_id; } else { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_dealer']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_dealer']), $row_data); $GLOBALS['no_dealer_count']++; $GLOBALS['sale_not_inserted_count']++; return 0; } } $data_conduction_sticker = (alphaNumericOnly($row_conduction_sticker)); $data_plate_number = (alphaNumericOnly($row_plate_number)); if (strpos($data_conduction_sticker, 'REG') !== false) { $data_conduction_sticker = ""; } if (strpos($data_plate_number, 'REG') !== false) { $data_plate_number = ""; } if (!isNotEmpty($data_plate_number) && !isNotEmpty($data_conduction_sticker)) { //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>$GLOBALS['selected_dms_type_name'],'problem'=>$GLOBALS['no_plate_and_conduction_sticker']) )) ; $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_plate_and_conduction_sticker']), $row_data); $GLOBALS['no_plate_and_conduction_sticker_count']++; $GLOBALS['sale_not_inserted_count']++; return 0; } $data_brand_id = getVehicleBrandID(((isset($GLOBALS['brand_map'][(($row_brand))])) ? $GLOBALS['brand_map'][(($row_brand))] : (($row_brand))), $db); $data_model = (($row_model)); $data_model_variant_description = (($row_model_variant_description)); $data_model_id = getVehicleModelID($data_brand_id, $data_model, $db); $data_model_variant_description_id = getVehicleModelVariantID($data_model_id, $data_model_variant_description, $db); $data_serial_number = (($row_serial_number)); $data_engine_number = (($row_engine_number)); $data_po_number = (($row_po_number)); $data_floor_plan_amount = (removeNonNumericCurrency(($row_floor_plan_amount))); $data_activity_date = $utility->fix_date_v2($row_activity_date); $data_sales_cost = (removeNonNumericCurrency(($row_sales_cost))); $data_sale_price = (removeNonNumericCurrency(($row_sale_price))); // $data_insurance_company_id = getInsuranceCompanyID((($row_insurance_company_id)),$db); $data_insurance_company_id = getInsuranceCompanyID(((isset($GLOBALS['insurance_map'][(($row_insurance_company_id))])) ? $GLOBALS['insurance_map'][(($row_insurance_company_id))] : (($row_insurance_company_id))), $db); $data_insurance_type_id = getInsuranceTypeID(((isset($GLOBALS['insurance_type_map'][(($row_insurance_type))])) ? $GLOBALS['insurance_type_map'][(($row_insurance_type))] : (($row_insurance_type))), $db); // $data_insurance_type_id = getInsuranceTypeID((($row_insurance_type_id)),$db); // $data_finance_company_id = getFinanceCompanyID((($row_finance_company_id)),$db); $data_finance_company_id = getFinanceCompanyID(((isset($GLOBALS['finance_map'][(($row_finance_company_id))])) ? $GLOBALS['finance_map'][(($row_finance_company_id))] : (($row_finance_company_id))), $db); $data_insurance_expiration_date = $utility->fix_date_v2($row_insurance_expiration_date); $data_source_id = getLeadSourceID(((isset($GLOBALS['source_map'][(($row_source_id))])) ? $GLOBALS['source_map'][(($row_source_id))] : (($row_source_id))), $db); // $data_source_id = getLeadSourceID((isset($GLOBALS['source_map'][(($row_source_id))])) ? $GLOBALS['source_map'][(($row_source_id))] : ($row_source_id)); $data_mode_of_contact_id = (($row_mode_of_contact_id)); $data_warehouse = (($row_warehouse)); $data_stock_number = (($row_stock_number)); $data_age_of_unit = (($row_age_of_unit)); $data_body_size_code = (($row_body_size_code)); $data_claim_number = (($row_claim_number)); $data_claim_amount = (removeNonNumericCurrency(($row_claim_amount))); $data_deal_number = (($row_deal_number)); $data_deal_date = $utility->fix_date_v2($row_deal_date); $data_sales_person = checkHasAlpha($row_sales_person); $data_sales_person_id = getSalesConsultant($row_sales_person, $db); $data_delivery_date = $utility->fix_date_v2($row_delivery_date); $data_mode_of_sale = getModeOfSale($row_mode_of_sale, $db); $data_type_of_payment = getTypeOfPayment($row_type_of_sale, $db); $data_group_manager = getSalesConsultant($row_group_manager, $db); $data_sales_discount = removeNonNumericCurrency($row_sales_discount); $data_end_user = $row_end_user; $data_driver = $row_driver; $data_finance_expiration = $utility->fix_date_v2($row_finance_expiration); $data_vehicle_offered = $row_vehicle_offered; $data_vehicle_id = getVehicleID($data_plate_number, $data_conduction_sticker, $db); if (!isNotEmpty($data_vehicle_id)) { $data_vehicle_id = $db->select("SELECT UUID_SHORT()"); $GLOBALS['vehicle_data'][] = "('$data_vehicle_id', '$data_brand_id', '$data_model_id', '$data_model_variant_description_id', NULLIF('$data_plate_number',''), NULLIF('$data_conduction_sticker',''), '" . $GLOBALS['company_dealer_id'] . "', '" . $GLOBALS['user_id'] . "', '1')"; } $sales_id = $db->select("SELECT UUID_SHORT()"); $GLOBALS['sales_data'][] = "('$sales_id',NULLIF('$data_vehicle_id',''),NULLIF('$data_plate_number',''),'$customer_id',NULLIF('$data_conduction_sticker',''),NULLIF('$data_order_number',''),'$data_serial_number','$data_engine_number','$data_po_number','$data_floor_plan_amount','$data_activity_date','$data_sales_cost','$data_sale_price','$data_insurance_company_id','$data_insurance_type_id','$data_insurance_expiration_date','$data_finance_company_id','$data_source_id','$data_mode_of_contact_id','$data_warehouse','$data_stock_number','$data_age_of_unit','$data_body_size_code','$data_claim_number','$data_claim_amount','$data_deal_number','$data_deal_date','$data_sales_person_id','$data_delivery_date','" . $GLOBALS['company_dealer_id'] . "','" . $GLOBALS['user_id'] . "','1','$data_brand_id','$data_model_id','$data_mode_of_sale','$data_type_of_payment','$data_group_manager','$data_sales_discount','$data_end_user','$data_driver','$data_finance_expiration')"; if (isNotEmpty($data_vehicle_offered)) { $GLOBALS['vehicle_offered'][] = "('$sales_id', '0','0','$data_vehicle_offered','1')"; } $GLOBALS['sale_inserted_count']++; }

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings