File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/upload/autoline.php

Back
<?php function autoline($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db){ // print_r ($row_data); return; $GLOBALS['selected_dms_type_name'] = $selected_dms_type; switch ($selected_dms_type_id) { case 1: $customer = autoline_insert_customer($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db); // $GLOBALS['data_count_list'] = "<tr><td>Accepted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-success' >".$GLOBALS['customer_inserted_count']."</span></h5></td></tr>"; // $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Not Inserted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$GLOBALS['customer_not_inserted_count']."</span></h5></td></tr>"; break; case 2: $vehicle = autoline_insert_vehicles($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db); // $GLOBALS['data_count_list'] = "<tr><td>Accepted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-success' >".$GLOBALS['vehicle_inserted_count']."</span></h5></td></tr>"; // $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Not Inserted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$GLOBALS['vehicle_not_inserted_count']."</span></h5></td></tr>"; break; case 3: $service = autoline_insert_service($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db); // $GLOBALS['data_count_list'] = "<tr><td>Accepted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-success' >".$GLOBALS['service_inserted_count']."</span></h5></td></tr>"; // $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Not Inserted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$GLOBALS['service_not_inserted_count']."</span></h5></td></tr>"; break; case 4: $sale = autoline_insert_sale($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db); // $GLOBALS['data_count_list'] = "<tr><td>Accepted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-success' >".$GLOBALS['sale_inserted_count']."</span></h5></td></tr>"; // $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."<tr><td>Not Inserted ".$selected_dms_type."</td> <td class='text-center'><h5><span class='badge bg-danger' >".$GLOBALS['sale_not_inserted_count']."</span></h5></td></tr>"; break; } } function autoline_insert_customer($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db){ $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 = (fix_date(($row_birthday),true)); $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 = (removeNonNumeric(($row_mobile_2))); $data_business_phone = (removeNonNumeric(($row_business_phone))); $data_fax_phone = (removeNonNumeric(($row_fax_phone))); $data_residential_phone = (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_sales_person = (($row_sales_person)); $data_business_name = (($row_business_name)); $data_contact_person = (($row_contact_person )); $data_date_created = (fix_date(($row_date_created),true)); $data_time_created = (($row_time_created)); $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 = ""; // $GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['invalid_email_address']) )) ; // $GLOBALS['invalid_email_address_count']++; // $GLOBALS['customer_not_inserted_count']++; // return 0; } //check if first name and last name and company name is not empty // if(!isNotEmpty($data_customer_name) ){ // if(!isNotEmpty($data_first_name) \|\| !isNotEmpty($data_last_name)){ // //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['customer_name_empty']) )) ; // $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_first_name) \|\| !isNotEmpty($data_last_name)){ // if(!isNotEmpty($data_customer_name) ){ // //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['customer_name_empty']) )) ; // $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_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(recordCount(" COUNT(id) ","customer_dms","customer_dms_id", $data_customer_id,false,$db) > 0){ // //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['customer_already_exists']))) ; // $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_email_1,$db) > 0){ $customer_master_record_data = getMasterRecord($data_customer_name,$data_first_name,$data_last_name,$data_email_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_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,$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'=>$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(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; } // if(isNotEmpty($data_mobile_1)){ // if((isNotEmpty($data_first_name) && isNotEmpty($data_last_name))){ // // if(countCustomerMobileIndividual($data_mobile_1,$data_last_name,$db) > 0){ // if( // ($check_data_mobile_1 == $data_mobile_1) && // ($check_data_last_name <> $data_last_name) // ){ // //$GLOBALS['not_inserted_list'] = array_merge($GLOBALS['not_inserted_list'] ,array( array('id'=>'Row no.: '. $GLOBALS['current_data_row'],'type'=>'','problem'=>$GLOBALS['mobile_already_exists']) )) ; // $GLOBALS['mobile_already_exists_count']++; // $GLOBALS['customer_not_inserted_count']++; // return 0; // } // }else{ // //compare current to fetch number // // if(countCustomerMobileCorporation($data_mobile_1,$db) > 0){ // if($data_mobile_1 == $check_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['mobile_already_exists']) )) ; // $GLOBALS['mobile_already_exists_count']++; // $GLOBALS['customer_not_inserted_count']++; // return 0; // } // } // }else{ // //$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['no_mobile_number_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 = (fix_date($data_birthday,true)); //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"; // if(contains($data_customer_id,$data_customer_name,$data_first_name, $data_last_name, $data_email_1,$data_mobile_1, $GLOBALS['customer_data_individual'], $GLOBALS['customer_contact'])){ // return 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 autoline_insert_vehicles($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$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)); 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((($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 = (fix_date(($row_insurance_expiration_date),true)); $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 = (fix_date(($row_delivery_date),true)); $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 = (fix_date(($row_date_created),true)); $data_sales_person = (checkHasAlpha(($row_sales_person))); // if(isNotEmpty($data_plate_number) && isNotEmpty($data_conduction_sticker)){ // if(recordCount('count(id)','vehicle','conduction_sticker = \''.$data_conduction_sticker.'\' AND plate_number',$data_plate_number,false,$db) > 0){ // //$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['vehicle_already_exists']) )) ; // $GLOBALS['vehicle_not_inserted_count']++; // return 0; // } // } // else if(isNotEmpty($data_plate_number)){ // if(recordCount('count(id)','vehicle','plate_number',$data_plate_number,false,$db) > 0){ // //$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['vehicle_already_exists']) )) ; // $GLOBALS['vehicle_not_inserted_count']++; // return 0; // } // } // else if(isNotEmpty($data_conduction_sticker)){ // if(recordCount('count(id)','vehicle','conduction_sticker',$data_conduction_sticker,false,$db) > 0){ // //$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['vehicle_already_exists']) )) ; // $GLOBALS['vehicle_not_inserted_count']++; // return 0; // } // } // $vehicle_table = "vehicle"; // $vehicle_table_fields = array("customer_id", "color_id", "brand_id", "engine_type", "gas_type", "insurance_company_id", "insurance_type_id", "insurance_expiration_date", "finance_company_id", "model_id", "model_variant_description", "plate_number", "chassis_number", "serial_number", "vin_number", "conduction_sticker", "who_drives", "purchase_car_as_id", "delivery_date", "date_created", "time_created", "vehicle_release_year", "description", "transmission", "service_advisor", "company_dealer_id", "dms_id", "upload_by", "sales_person", "status"); // $vehicle_table_data = array( $customer_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_variant_description, $data_plate_number, $data_chassis_number, $data_serial_number, $data_vin_number, $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'] , $selected_dms_id, $_SESSION['user']['id'],$data_sales_person,"1"); // $vehicle_id = insertData($vehicle_table_fields,$vehicle_table,$vehicle_table_data,$db); // $data_modify_date = (fix_date(($row_modify_date),false)); // if(isNotEmpty($data_modify_date)){ // $data_modify_table = "vehicle_modify_history"; // $data_modify_table_fields = array("vehicle_id", "date", "modified_by","status" ); // $data_modify_table_data = array( $vehicle_id, $data_modify_date, "", "1"); // insertData($data_modify_table_fields,$data_modify_table,$data_modify_table_data,$db); // } $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']."', '".$_SESSION['user']['id']."', '$data_sales_person','$data_registration_no', '1')"; $data_notes_for_vehicle = (($row_notes_for_vehicle)); if(isNotEmpty($data_notes_for_vehicle)){ // $vehicle_notes_table = "vehicle_notes"; // $vehicle_notes_table_fields = array("vehicle_id", "data", "status" ); // $vehicle_notes_table_data = array( $vehicle_id, $data_notes_for_vehicle, "1" ); $GLOBALS['vehicle_notes'][] = "('$vehicle_id', '$data_notes_for_vehicle', '1' )"; // insertData($vehicle_notes_table_fields,$vehicle_notes_table,$vehicle_notes_table_data,$db); } $GLOBALS['vehicle_inserted_count']++; } function autoline_insert_service($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$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 = (fix_date(($row_ro_date),true)); $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 = (fix_date(($row_start_date_of_service),true)); $data_end_date_of_service = (fix_date(($row_end_date_of_service),true)); $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); 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']."', '".$_SESSION['user']['id']."', '1')"; } // $data_count = $db -> select("SELECT count(id) FROM `service` WHERE `ro_number` = '$data_ro_number'"); // if($data_count > 0){ // //$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_already_exists']) )) ; // $GLOBALS['service_not_inserted_count']++; // return 0; // } // if(!checkIfExistInArray($GLOBALS['service_ro_number'],1,$data_ro_number)){ // $GLOBALS['service_ro_number'] = array_merge($GLOBALS['service_ro_number'] ,array( array($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'] , $selected_dms_id,$_SESSION['user']['id'], $data_brand_id, $data_model_id ))) ; // } // $service_table = "service_history"; // $service_table_fields = array("ro_number", "job_code", "problem_cause", "correction", "job_summary", "amount"); // $service_table_data = array( $data_ro_number, $data_job_code, $data_problem_cause, $data_correction, $data_job_summary, $data_customer_paid_amount ); // $service_id = insertData($service_table_fields,$service_table,$service_table_data,$db); $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']."','".$_SESSION['user']['id']."','1','$data_brand_id','$data_model_id')"; $GLOBALS['service_history'][] = "('$data_ro_number', '$data_job_code','$data_problem_cause','$data_correction','$data_job_summary','$data_customer_paid_amount')"; // if(isNotEmpty($data_notes)){ // $data_notes_table = "service_notes"; // $data_notes_table_fields = array("service_id", "data", "status"); // $data_notes_table_data = array( $service_id, $data_notes, "1"); // insertData($data_notes_table_fields,$data_notes_table,$data_notes_table_data,$db); // } $GLOBALS['service_inserted_count']++; } function autoline_insert_sale($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$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; } } // 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['sale_not_inserted_count']++; // return 0; // } // $customer_id = $customer_id.'_'.$selected_dms_id.$GLOBALS['company_dealer_id']; // if(!isNotEmpty($data_order_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['no_order_number']) )) ; // $GLOBALS['not_inserted_list_v2'][] = array_merge(array($GLOBALS['no_order_number']),$row_data); // $GLOBALS['no_order_number_count']++; // $GLOBALS['sale_not_inserted_count']++; // return 0; // } // if(countSalesID($customer_id,$data_order_number,$db) > 0 ){ // //$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['sale_already_exists']) )) ; // $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_engine_number = (($row_engine_number)); $data_po_number = (($row_po_number)); $data_floor_plan_amount = (removeNonNumericCurrency(($row_floor_plan_amount))); $data_activity_date = (fix_date(($row_activity_date),true)); $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 = (fix_date(($row_insurance_expiration_date),true)); $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 = (fix_date(($row_deal_date),true)); $data_sales_person = checkHasAlpha($row_sales_person); $data_sales_person_id = getSalesConsultant($row_sales_person,$db); $data_delivery_date = (fix_date(($row_delivery_date),true)); $data_serial_number = (($row_serial_number)); $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 = fix_date($row_finance_expiration,false); $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']."', '".$_SESSION['user']['id']."', '1')"; } // $sale_table = "sales"; // $sale_table_fields = array("plate_number","customer_id","conduction_sticker", "order_number", "serial_number", "engine_number", "po_number", "floor_plan_amount", "activity_date", "sales_cost", "sale_price", "insurance_company_id", "insurance_type_id", "insurance_expiration_date", "finance_company_id", "source_id", "mode_of_contact_id", "warehouse", "stock_number", "age_of_unit", "body_size_code", "claim_number", "claim_amount", "deal_number", "deal_date", "sales_person", "delivery_date", "company_dealer_id", "dms_id", "upload_by", "status"); // $sale_table_data = array( $data_plate_number,$customer_id,$data_conduction_sticker, $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, $data_delivery_date, $GLOBALS['company_dealer_id'] , $selected_dms_id, $_SESSION['user']['id'],"1"); // $sale_id = insertData($sale_table_fields,$sale_table,$sale_table_data,$db); $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']."','".$_SESSION['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']++; } ////// END autoline INSERTTION ///////// ?>

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