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:
erapower_insert_customer($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db);
// $GLOBALS['data_count_list'] = "| Accepted ".$selected_dms_type." | ".$GLOBALS['customer_inserted_count']." |
";
// $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."| Not Inserted ".$selected_dms_type." | ".$GLOBALS['customer_not_inserted_coun']." |
";
break;
case 2:
erapower_insert_vehicles($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db);
// $GLOBALS['data_count_list'] = "| Accepted ".$selected_dms_type." | ".$GLOBALS['vehicle_inserted_count']." |
";
// $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."| Not Inserted ".$selected_dms_type." | ".$GLOBALS['vehicle_not_inserted_count']." |
";
break;
case 3:
erapower_insert_service($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db);
// $GLOBALS['data_count_list'] = "| Accepted ".$selected_dms_type." | ".$GLOBALS['service_inserted_count']." |
";
// $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."| Not Inserted ".$selected_dms_type." | ".$GLOBALS['service_not_inserted_count']." |
";
break;
case 4:
erapower_insert_sale($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$db);
// $GLOBALS['data_count_list'] = "| Accepted ".$selected_dms_type." | ".$GLOBALS['sale_inserted_count']." |
";
// $GLOBALS['data_count_list'] = $GLOBALS['data_count_list']."| Not Inserted ".$selected_dms_type." | ".$GLOBALS['sale_not_inserted_count']." |
";
break;
}
}
////// START ERA POWER INSERTTION /////////
function erapower_insert_customer($selected_dms_id,$selected_dms_name,$selected_dms_type_id,$selected_dms_type,$row_data,$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 = (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 = 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 = (fix_date(($row_date_created),true));
$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 = "";
// $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;
}
// echo 'Customer: '.$data_customer_name.' - '.$data_first_name.' - '.$data_last_name;return;
//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_coun']++;
// 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.'
';
//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'=>'','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;
}
// 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 erapower_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));
//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 = (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)));
//check if plate or cs not exisiting
// 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( $vehicle_id,$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 erapower_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')";
}
$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')";
$GLOBALS['service_inserted_count']++;
}
function erapower_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;
}
}
$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 = (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_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,true);
$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')";
}
$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']++;
}
?>