'
);
}
// function initToolTip() {
// var bootstrapTooltip = $.fn.tooltip.noConflict();
// $.fn.bstooltip = bootstrapTooltip;
// $(".tooltip-me").bstooltip();
// }
function tableMobileFormatter(value, row, index) {
if ((value != null && value.trim() == "") || value == "-") {
return " (Not Provided) ";
}
if (value == "-1") {
return "";
}
return "" + value + "";
}
function tableNameFormatter(value, row, index) {
if ((value != null && value.trim() == "") || value == "-") {
return " (Not Provided) ";
}
if (value == "-1") {
return "";
}
//ACTIVE LINK TRIGGER EDIT
return "" + value + "";
}
function tableEmailFormatter(value, row, index) {
if ((value != null && value.trim() == "") || value == "-") {
return " (Not Provided) ";
}
if (value == "-1") {
return "";
}
return "" + value + "";
}
function addDataSourceItem() {
var data_source = document.getElementById("data-source-list");
// console.log('asdfasd');
console.log(data_source);
const data_source_base = document.querySelector(
"#data-source-list-clone tbody tr"
);
data_source.appendChild(data_source_base.cloneNode(true));
console.log(data_source)
// Generate a unique ID for the select> in the new row.
var dataSourceIdDateNow = uniqId();
var newDataSourceCustomerNoId =
"data-source-customer-no-" + dataSourceIdDateNow;
var newDataSourceDmsId = "data-source-dms-" + dataSourceIdDateNow;
var newDataSourceCompanyId = "data-source-company-" + dataSourceIdDateNow;
var newDataSourceDealerId = "data-source-dealer-" + dataSourceIdDateNow;
var dataSourceItem = [];
dataSourceItem[0] = newDataSourceCustomerNoId;
dataSourceItem[1] = newDataSourceDmsId;
dataSourceItem[2] = newDataSourceCompanyId;
dataSourceItem[3] = newDataSourceDealerId;
$("#input-modal-customer-no").attr("id", newDataSourceCustomerNoId);
$("#" + newDataSourceCustomerNoId)
.on("keyup", removeextra)
.blur(removeextra);
$("#" + newDataSourceCustomerNoId).on("keypress", function (e) {
var regex = new RegExp("^[0-9a-zA-Z]+$");
var str = String.fromCharCode(!e.charCode ? e.which : e.charCode);
if (regex.test(str)) {
return true;
}
e.preventDefault();
return false;
});
$("#select-modal-dms").attr("id", newDataSourceDmsId).select2({
placeholder: "Select DMS",
allowClear: true,
});
$("#select-modal-company")
.attr("id", newDataSourceCompanyId)
.select2({
placeholder: "Select Company",
allowClear: true,
language: {
noResults: function () {
return "Select DMS first";
},
},
escapeMarkup: function (markup) {
return markup;
},
ajax: {
url: "api/company/company.php",
dataType: "json",
delay: 1,
data: function (data) {
return {
search: data.term, // search term
dms_id: $("#" + newDataSourceDmsId).val(),
apiKey: "3568127986733141",
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
$("#mod-preferred-moc").select2({
placeholder: "Select mode of contact",
allowClear: true,
tags: false,
minimumResultsForSearch: -1,
language: {
noResults: function () {
return "Select mode of contact";
},
},
escapeMarkup: function (markup) {
return markup;
},
ajax: {
url: "api/mode_of_contact/mode_of_contact.php",
dataType: "json",
delay: 250,
data: function (data) {
return {
search: data.term, // search term
apiKey: "1557741601453763",
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
$("#mod-business-company").select2({
placeholder: "Search Company by name, email and mobile",
allowClear: true,
language: {
noResults: function () {
return "Search Company by name, email and mobile";
},
},
escapeMarkup: function (markup) {
return markup;
},
ajax: {
url: "api/customer_update/customerv2_update.php",
dataType: "json",
delay: 250,
data: function (data) {
return {
search: data.term, // search term
apiKey: "3975247589935894",
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
$("#select-modal-dealer")
.attr("id", newDataSourceDealerId)
.select2({
placeholder: "Select Dealer",
allowClear: true,
language: {
noResults: function () {
return "Search or enter dealer name";
},
},
escapeMarkup: function (markup) {
return markup;
},
ajax: {
url: "api/dealer/dealer.php",
dataType: "json",
delay: 250,
data: function (data) {
return {
apiKey: "6209267133015033",
company_id: $("#" + newDataSourceCompanyId).val(),
search: data.term, // search term
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
$("#" + newDataSourceDmsId).on("change", function (event) {
$("#" + newDataSourceCompanyId)
.val("")
.trigger("change");
});
$("#" + newDataSourceCompanyId).on("change", function (event) {
$("#" + newDataSourceDealerId)
.val("")
.trigger("change");
});
return dataSourceItem;
}
function addInterestItem() {
// CREATE ROW
var interest_list = document.getElementById("interest-list");
const interest_list_base = document.querySelector(
"#interest-list-clone tbody tr"
);
var interestItem = [];
interest_list.appendChild(interest_list_base.cloneNode(true));
// Generate a unique ID for the select> in the new row.
var InterestIdDateNow = uniqId();
var newInterestCategoryId = "interest-category-" + InterestIdDateNow;
var newInterestContentId = "interest-content-" + InterestIdDateNow;
interestItem[0] = newInterestCategoryId;
interestItem[1] = newInterestContentId;
// alert(interestItem.pop(0));
// alert(interestItem.pop(1));
// Update the ID of the select> in the new row
// (it should be the only one with an `id` of '#element'),
// and initialize the Select2.
$("#select-category").attr("id", newInterestCategoryId).select2({
placeholder: "Select Category",
allowClear: true,
});
$("#select-content")
.attr("id", newInterestContentId)
.select2({
tags: true,
placeholder: "Select",
allowClear: true,
language: {
noResults: function () {
return "Search or enter interest";
},
},
escapeMarkup: function (markup) {
return markup;
},
placeholder: "Search or enter interest",
ajax: {
url: "api/interest_hobbies/interest_hobbies.php",
dataType: "json",
delay: 250,
data: function (data) {
return {
apiKey: "5068581874181452",
interestCategory: $("#" + newInterestCategoryId).val(),
search: data.term, // search term
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
$("#" + newInterestCategoryId).on("select2:select", function (e) {
$("#" + newInterestContentId)
.val("")
.trigger("change");
});
$("#" + newInterestCategoryId).on("select2:unselecting", function (e) {
$("#" + newInterestContentId)
.val("")
.trigger("change");
});
return interestItem;
// CREATE ROW
}
function addAffiliationsItem() {
// CREATE ROW
var affiliations_list = document.getElementById("affiliations-list");
const affiliations_list_base = document.querySelector(
"#affiliations-list-clone tbody tr"
);
var affiliationsItem = [];
affiliations_list.appendChild(affiliations_list_base.cloneNode(true));
// Generate a unique ID for the select> in the new row.
var affiliationsIdDateNow = uniqId();
var newaffiliationsCategoryId =
"affiliations-category-" + affiliationsIdDateNow;
var newaffiliationsContentId =
"affiliations-content-" + affiliationsIdDateNow;
affiliationsItem[0] = newaffiliationsCategoryId;
affiliationsItem[1] = newaffiliationsContentId;
// alert(affiliationsItem.pop(0));
// alert(affiliationsItem.pop(1));
// Update the ID of the select> in the new row
// (it should be the only one with an `id` of '#element'),
// and initialize the Select2.
$("#select-category-affiliations")
.attr("id", newaffiliationsCategoryId)
.select2({
placeholder: "Select Category",
allowClear: true,
});
$("#select-content-affiliations")
.attr("id", newaffiliationsContentId)
.select2({
tags: true,
placeholder: "Search or enter affiliations",
allowClear: true,
language: {
noResults: function () {
return "Search or enter affiliations";
},
},
escapeMarkup: function (markup) {
return markup;
},
placeholder: "Search or enter affiliations",
ajax: {
url: "api/affiliations/affiliations.php",
dataType: "json",
delay: 250,
data: function (data) {
return {
apiKey: "8048636851659915",
affiliationsCategory: $("#" + newaffiliationsCategoryId).val(),
search: data.term, // search term
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
// $('#' + newaffiliationsCategoryId).on('select2:select', function(e) {
// $('#' + newaffiliationsContentId).val('').trigger('change')
// });
// $('#' + newaffiliationsCategoryId).on("select2:unselecting", function(e) {
// $('#' + newaffiliationsContentId).val('').trigger('change')
// });
return affiliationsItem;
// CREATE ROW
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$(document).ready(function () {
$("#addRowDataSource").click(function () {
if (
!checkIfDataSourceIncomplete() &&
$("#data-source-list-table tbody tr").length > 0
) {
sweetAlertSimple(
"error",
"Oops...",
"Complete the data source details first"
);
} else {
addDataSourceItem();
}
});
$("#data-source-list").on("click", ".btnRemoveDataSource", function () {
if ($("#data-source-list-table tbody tr").length < 2) {
sweetAlertSimple("error", "Oops...", "Need at least 1 data source");
} else {
$(this).closest("tr").remove();
}
});
$("#addRowChildren").click(function () {
var validate_data_children_list = checkIfChildrenIncomplete();
if (
!validate_data_children_list[0] &&
$("#children-list-table tbody tr").length > 0
) {
sweetAlertSimple("error", "Oops...", "Complete the child details first");
} else if (!validate_data_children_list[1]) {
sweetAlertSimple("error", "Oops...", "Children data invalid mobile");
} else {
addCustomerChildren();
}
});
$("#children-list").on("click", ".btnRemoveChildren", function () {
$(this).closest("tr").remove();
});
$("#addRowContactPerson").click(function () {
var validate_data_contact_person = checkIfContactPersonIncomplete();
if (
!validate_data_contact_person[0] &&
$("#contact-person-list-table tbody tr").length > 0
) {
sweetAlertSimple(
"error",
"Oops...",
"Complete the data of contact person first"
);
} else if (!validate_data_contact_person[1]) {
sweetAlertSimple("error", "Oops...", "Contact person invalid email");
} else if (!validate_data_contact_person[2]) {
sweetAlertSimple("error", "Oops...", "Contact person invalid mobile");
} else {
addCustomerContactPerson();
}
});
$("#contact-person-list").on("click", ".btnRemoveContactPerson", function () {
$(this).closest("tr").remove();
});
//Date picker
$("#mod-birth-date").datetimepicker({
format: "L",
});
$("#mod-established-date").datetimepicker({
format: "L",
});
$("[data-mask]").inputmask();
$("#modal-customer").on("hidden.bs.modal", function (e) {
$(this)
.find("input,textarea")
.val("")
.end()
.find("select")
.prop("selectedIndex", 0)
.find("input[type=checkbox], input[type=radio]")
.prop("checked", "")
.end();
$(".modal-select2").val("").trigger("change");
});
$("#modal-customer").on("shown.bs.modal", function () {
$("input:text:visible:first").focus();
});
$(document).on("wheel", "input[type=number]", function (e) {
$(this).blur();
});
$("#mod-nature-of-business").select2({
// tags: true,
placeholder: "Select Nature of Business",
allowClear: true,
escapeMarkup: function (markup) {
return markup;
},
ajax: {
url: "api/nature_of_business/nature_of_business.php",
dataType: "json",
delay: 250,
data: function (data) {
return {
apiKey: "6902545878701742",
search: data.term, // search term
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
$("#mod-dd-profession").select2({
tags: true,
placeholder: "Select Profession",
allowClear: true,
escapeMarkup: function (markup) {
return markup;
},
ajax: {
url: "api/profession/profession.php",
dataType: "json",
delay: 250,
data: function (data) {
return {
apiKey: "8920139547181378",
search: data.term, // search term
};
},
processResults: function (response) {
return {
results: response,
};
},
cache: true,
},
});
$("#mod-dd-inquiry").select2({
placeholder: "Select Source of Inquiry",
allowClear: true,
});
$("#mod-dd-gender").select2({
placeholder: "Select Gender",
allowClear: true,
minimumResultsForSearch: -1,
});
$("#mod-dd-marital-status").select2({
placeholder: "Select Marital Status",
allowClear: true,
minimumResultsForSearch: -1,
});
$("#mod-dd-nationality").select2({
placeholder: "Select Nationality",
allowClear: true,
});
addRowInterest();
addRowAffiliations();
refreshModalReligion();
refreshModalCities();
// initToolTip();
$('[data-toggle="tooltip"]').tooltip();
});
PK BZΘ ltms.jsnu [ var upload_image_name = [];
var myDropzone;
function photoDropzoneListener() {
Dropzone.autoDiscover = false; // Disable auto-discovery
// Initialize Dropzone
myDropzone = new Dropzone("#upload-ltms-photo", {
url: "api/upload/upload_image_ltms.php", // Ensure the URL is correct
autoProcessQueue: false, // Disable auto-upload
acceptedFiles: '.png,.jpg,.jpeg',
maxFilesize: 40, // Max file size in MB
maxFiles: 10, // Max number of files
clickable: true,
addRemoveLinks: true,
dictCancelUpload: 'Cancel',
parallelUploads: 10, // Allow multiple files to be uploaded in parallel
renameFile: function (file) {
var extension = file.name.substr((file.name.lastIndexOf('.') + 1)).toLowerCase();
let newName = uniqImgId() + '.' + extension;
upload_image_name.push(newName);
return newName;
},
init: function () {
this.on("maxfilesexceeded", function (file) {
alert('Only 10 images allowed.');
this.removeFile(file);
return;
});
this.on("error", function (file, response) {
alert(response || 'Error uploading file.');
});
this.on("success", function (file, response) {
sweetAlertSimple('success', 'Nice...',"Successfully uploaded!");
console.log("Success:", response); // Log the success response
});
this.on('sending', function (file, xhr, formData) {
formData.append("cuid", customer_record_id);
formData.append("did", $('#did').val());
});
this.on('complete', function (file) {
// Check if all files are uploaded
// sweetAlertSimple('success', 'Nice...',"Successfully uploaded!");
if (myDropzone.getQueuedFiles().length === 0 && myDropzone.getUploadingFiles().length === 0) {
$('#loading-indicator').hide();
setTimeout(() => {
// Refresh the page or update the UI
window.location.reload();
}, "1000");
}
});
}
});
// Handle form submit button click
$('#ltms-submit').on('click', function (e) {
e.preventDefault(); // Prevent default form submission
if (myDropzone.getQueuedFiles().length > 0) {
$('#loading-indicator').show(); // Show loading indicator
myDropzone.processQueue(); // Upload files if there are any
} else {
alert('No files to upload.');
}
});
}
$("#btn-upload-ltms").on('click',function(){
$("#ltms-container").show();
$(this).hide();
$("#customer-ltms-image-data").hide();
});
$("#ltms-submit-cancel").on('click',function(){
// window.location.reload();
$("#ltms-container").hide();
$("#btn-upload-ltms").show();
$("#customer-ltms-image-data").show();
});
function uniqImgId() {
var id = Math.round(new Date().getTime() + (Math.random() * 100));
return id;
}
function removeImage(id) {
// alert(id);
Swal.fire({
icon: 'warning',
html: 'Do you want to remove this image?',
showDenyButton: false,
showCancelButton: true,
confirmButtonText: `Confirm`,
denyButtonText: `Don't Confirm`,
}).then((result) => {
if (result.isConfirmed) {
// toastr.remove();
$.ajax({
url: "api/upload/upload_image_ltms.php",
method: "POST",
data: {
apiKey: '9434631886897744',
id: id
},
cache: false,
beforeSend: function() {
sweetAlertSimple('info', 'Oops...', 'Removing image...');
},
success: function(data) {
// fetchVehicleInfo(vehicle_record_id, customer_record_id)
// readVehicleImage(vehicle_record_id);
readLtmsUpload();
sweetAlertSimple('success', 'Oops...', 'Image remove successfully.');
// setTimeout(() => {
// // Refresh the page or update the UI
// window.location.reload();
// }, "1000");
}
})
} else if (result.isDenied) {
// Swal.fire('', 'Changes are not saved', 'info')
}
})
}
function readLtmsUpload() {
$.ajax({
url: "api/upload/upload_image_ltms.php",
type: "POST",
dataType: 'json',
data: {
apiKey: '1164288154587287',
cuid:customer_record_id
},
beforeSend: function() {},
success: function(result) {
// result.total
$('#customer-ltms-image-data').html('');
$('#customer-ltms-image-data').append(result.vehicle_image);
}
});
}
readLtmsUpload();
photoDropzoneListener();PK BZ! `o o customer_view.jsnu [ //GLOBALS WITTHOUT PHP
var customer_record_type = "1";
var vehicle_form = false;
//FUNCTIONS
function initVehicleSection() {
if (!vehicle_form) {
vehicle_form = true;
$.ajax({
url: 'include/components/customer/modal/vehicle_form.php',
type: 'post',
beforeSend: function() {
$('#customer-vehicle-button').attr('disabled', true);
},
success: function(data) {
$('#vehicle_form').html(data);
$.ajax({
url: 'dist/js/vehicle/vehicle_form.js',
type: 'post',
success: function(data) {
$('#customer-vehicle-button').attr('disabled', false);
initVehicle();
},
error: function() {
$('#vehicle_form').text('An error occurred');
}
});
},
error: function() {
$('#vehicle_form').text('An error occurred');
}
});
} else {
$('#modal-vehicle').modal('show');
initOwnerSelect2();
}
}
function refreshTableLogs() {
var $table = $('#logs-table')
$table.bootstrapTable('destroy').bootstrapTable();
$(function() {
$table.bootstrapTable('refresh', {
url: 'app/table/customer_log.php'
});
})
}
function queryParamsLogs(params) {
console.log(params)
return {
search: params.search,
offset: params.offset,
limit: params.limit,
sort: params.sort,
order: params.order,
customer_id: customer_record_id
};
}
function queryParamsSales(params) {
return {
search: params.search,
offset: params.offset,
limit: params.limit,
customer_id: customer_record_id
};
}
function queryParamsService(params) {
return {
search: params.search,
offset: params.offset,
limit: params.limit,
customer_id: customer_record_id
};
}
function queryParamsCorporationCustomer(params) {
return {
search: params.search,
offset: params.offset,
limit: params.limit,
customer_id: customer_record_id,
customer_corporation: true
};
}
function readCustomerSalesImage() {
$.ajax({
url: "api/customer/customerv2.php",
type: "POST",
dataType: 'json',
data: {
apiKey: '7472626829226859',
customer_id: customer_record_id
},
beforeSend: function() {
$('#loader').show();
},
success: function(result) {
// result.total
$('#customer-sales-image-data').html('');
$('#customer-sales-image-data').append(result.sales_image);
$('#loader').hide();
}
});
}
function readCustomerChildren(isModal) {
$.ajax({
url: "api/customer/customerv2.php",
method: "POST",
dataType: 'json',
data: {
apiKey: '8307826786414874',
customer_id: customer_record_id
},
beforeSend: function() {},
success: function(result) {
var obj = jQuery.parseJSON(JSON.stringify(result));
var index = 0;
if (isModal) {
if (obj.length > 0) {
// $('#unit_association').click();
}
} else {
$('#information_family_list').empty()
$("#information_family_list").append(
'| Date | Dealer | RO Number | Amount | CS | Plate | Brand | Model | Service Advisor |
|---|
| Date | Order Number | Dealer | CS | Amount | Brand | Model | Sales Person |
|---|
| Picture | Name | Mobile |
|---|
| Date | Activity | User |
|---|
| Date | Logs |
|---|
';print_r($customer_data_array);echo''; $insert_customer_contact = $customer->create_customer_contact( $customer_id, $customer_data_array["mod-address-1"], $customer_data_array["mod-address-2"], '0', //state 1 '0', //state 2 $customer_data_array["mod-dd-city-1"], $customer_data_array["mod-dd-city-2"], $customer_data_array["mod-postal-1"], $customer_data_array["mod-postal-2"], $customer_data_array["mod-email"], (isset($customer_data_array["mod-other-email1"]) ? $customer_data_array["mod-other-email1"] : ''), (isset($customer_data_array["mod-other-email2"]) ? $customer_data_array["mod-other-email2"] : ''), $customer_data_array["mod-viber"], $customer_data_array["mod-facebook"], $customer_data_array["mod-instagram"], $customer_data_array["mod-telegram"], $customer_data_array["mod-whatsapp"], '', //other social $customer_data_array["mod-website"], $utility->fix_mobile_format($customer_data_array["mod-business-number"]), '', //fax $new_customer_number, (isset($customer_data_array["mod-other-mobile-number1"]) ? $utility->fix_mobile_format($customer_data_array["mod-other-mobile-number1"]): ''), (isset($customer_data_array["mod-other-mobile-number2"]) ? $utility->fix_mobile_format($customer_data_array["mod-other-mobile-number2"]) : ''), $utility->fix_mobile_format($customer_data_array["mod-home-phone"]), $mode_of_contact_id, $customer_data_array["mod-landline"], '1', $db ); // echo'
';print_r( $insert_customer_contact);echo'';exit; $customer_dms_array = array(); if ($customer_dms <> '') { foreach ($customer_dms as $customer_dms_row) { $company_dealer_id = $company_dealer->read_company_dealer_id($customer_dms_row['Company'], $customer_dms_row['Dealer'], '1', $db); $customer_dms_array[] = "('$customer_id','" . $customer_dms_row['Customer_No'] . '_' . $customer_dms_row['DMS'] . $company_dealer_id . "'," . $company_dealer_id . ",'1')"; } $customer_dms_to_insert = implode(',', $customer_dms_array); $insert_customer_dms = $customer->create_customer_dms($customer_dms_to_insert, $db); } $customer_contact_persons = isset($_REQUEST['customer_contact_person']) ? $_REQUEST['customer_contact_person'] : ''; // print_r($customer_contact_persons);exit; $customer_contact_person_array = array(); if ($customer_contact_persons <> '') { $customer_contact_persons = array_map(array($utility, 'upperCaseNestedArray'), $customer_contact_persons); $customer_contact_persons = array_map(array($db, 'escape'), $customer_contact_persons); foreach ($customer_contact_persons as $customer_contact_person) { $customer_contact_person_array[] = "('$customer_id','" . $customer_contact_person['Fullname'] . "','" . $customer_contact_person['Email'] . "','" . (($utility->isNotEmpty($customer_contact_person["Mobile"])) ? '+63' . $customer_contact_person["Mobile"] : '') . "','1')"; } $contact_person_to_insert = implode(',', $customer_contact_person_array); $customer->create_customer_contact_person($contact_person_to_insert, $db); } $customer_childrens = isset($_REQUEST['customer_children']) ? $_REQUEST['customer_children'] : ''; $customer_children_array = array(); if ($customer_childrens <> '') { $customer_childrens = array_map(array($utility, 'upperCaseNestedArray'), $customer_childrens); $customer_childrens = array_map(array($db, 'escape'), $customer_childrens); foreach ($customer_childrens as $customer_children) { $new_children_date_of_birth = $utility->convert_sql_date($customer_children['Birthday'], 'mm/dd/yyyy'); $customer_children_array[] = "('$customer_id','" . $customer_children['Firstname'] . "', '" . $customer_children['Lastname'] . "','" . $new_children_date_of_birth . "','" . (($utility->isNotEmpty($customer_children['Mobile'])) ? '+63' . $customer_children['Mobile'] : '') . "','1')"; } $customer_children_to_insert = implode(',', $customer_children_array); $customer->create_customer_children($customer_children_to_insert, $db); } $customer_interests = isset($_REQUEST['customer_interest']) ? $_REQUEST['customer_interest'] : ''; $customer_interest_array = array(); if ($customer_interests <> '') { $customer_interests = array_map(array($utility, 'upperCaseNestedArray'), $customer_interests); $customer_interests = array_map(array($db, 'escape'), $customer_interests); foreach ($customer_interests as $customer_interest) { $interest_category_id = $customer_interest['Category']; $interest_name = ($customer_interest['Interest']); $interest_id = $interest_hobbies->read_interest_id_by_name($interest_category_id, $interest_name, $db); if (!$utility->isNotEmpty($interest_id)) { $interest_id = $interest_hobbies->create_interest($interest_category_id, $interest_name, $db); } $customer_interest_array[] = "('" . $interest_id . "','$customer_id','1')"; } $customer_interest_to_insert = implode(',', $customer_interest_array); $customer->create_customer_interest_list($customer_interest_to_insert, $db); } $customer_affiliations = isset($_REQUEST['customer_affiliations']) ? $_REQUEST['customer_affiliations'] : ''; $customer_affiliations_array = array(); if ($customer_affiliations <> '') { $customer_affiliations = array_map(array($utility, 'upperCaseNestedArray'), $customer_affiliations); $customer_affiliations = array_map(array($db, 'escape'), $customer_affiliations); foreach ($customer_affiliations as $customer_affiliation) { $affiliations_category_id = $customer_affiliation['Category']; $affiliations_name = ($customer_affiliation['Affiliations']); $affiliations_id = $affiliations->read_affiliations_id_by_name($affiliations_category_id, $affiliations_name, $db); if (!$utility->isNotEmpty($affiliations_id)) { $affiliations_id = $affiliations->create_affiliations($affiliations_category_id, $affiliations_name, $db); } $customer_affiliations_array[] = "('" . $affiliations_id . "','$customer_id','1')"; } $customer_affiliations_to_insert = implode(',', $customer_affiliations_array); $customer->create_customer_affiliations_list($customer_affiliations_to_insert, $db); } if (intval($insert_customer) > 0 && intval($insert_customer_contact) > 0) { $return_arr["status"] = 1; $return_arr["message"] = "Customer Data Inserted"; $log_desc = "Add customer: %s"; $logger->create( $_SESSION['user']['id'], sprintf( $log_desc, ($customer_type == 1) ? '[ID:' . $customer_id . ', ' . $customer_data_array["mod-firstname"] . ' ' . $customer_data_array["mod-lastname"] . ']' : '[ID:' . $customer_id . ', ' . $customer_data_array["mod-corporation-name"] . ']' ), $customer_id, 'add_customer', $db ); } else { $return_arr["status"] = 0; $return_arr["message"] = "Customer Data Not Inserted"; } // $return_arr["status"]=1; // $return_arr["message"]="Customer Data Inserted"; echo json_encode($return_arr); } else if ($apiKey === '8906433219679554') { //Update customer details $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer_data = isset($_REQUEST['customer_data']) ? $_REQUEST['customer_data'] : '{}'; $customer_data_array = json_decode($customer_data, true); $customer_data_array = array_map(array($utility, 'upperCaseNestedArray'), $customer_data_array); $customer_data_array = array_map(array($db, 'escape'), $customer_data_array); $customer_type = 1; //Defualt Individual Customer if ($utility->isNotEmpty($customer_data_array["mod-corporation-name"])) { $customer_type = 2; } // if($customer_type == 1){ $new_customer_number = (($utility->isNotEmpty($customer_data_array["mod-contact"])) ? '+63' . $customer_data_array["mod-contact"] : ''); //modify $new_customer_number2 =(isset($customer_data_array["mod-other-mobile-number1"]) ? (($utility->isNotEmpty($customer_data_array["mod-other-mobile-number1"])) ? '+63' . $customer_data_array["mod-other-mobile-number1"] : '') : ''); $new_customer_number3 =(isset($customer_data_array["mod-other-mobile-number2"]) ? (($utility->isNotEmpty($customer_data_array["mod-other-mobile-number2"])) ? '+63' . $customer_data_array["mod-other-mobile-number2"] : '') : ''); // }else if($customer_type == 2){ // $new_customer_number = (($utility->isNotEmpty($customer_data_array["mod-contact-corporation"])) ? $customer_data_array["mod-contact-corporation"] : ''); // $new_customer_number = $utility->fix_mobile_format($new_customer_number); // } $customer_dms = isset($_REQUEST['customer_dms']) ? $_REQUEST['customer_dms'] : ''; $customer_dms = array_map("unserialize", array_unique(array_map("serialize", $customer_dms))); $customer_dms = array_map(array($db, 'escape'), $customer_dms); $force_update = isset($_REQUEST['force_update']) ? $_REQUEST['force_update'] : false; $force_update_reason = isset($_REQUEST['force_update_reason']) ? $db->escape($_REQUEST['force_update_reason']) : ''; // if($customer_dms <> ''){ // foreach ($customer_dms as $customer_dms_row){ // $company_dealer_id = $company_dealer->read_company_dealer_id($customer_dms_row['Company'],$customer_dms_row['Dealer'],'1',$db); // $customer_dms_id = $customer_dms_row['Customer_No'].'_'.$customer_dms_row['DMS'].$company_dealer_id; // $customer_dms_information = $customer->get_customer_dms_company_dealer_name_by_customer_dms_id($customer_dms_id,$db); // if(count($customer_dms_information) > 0 && $customer_id <> $customer_dms_information['customer_record_id']){ // $customer_dms_information = array_map(array($utility, 'upperCaseNestedArray'), $customer_dms_information); // $customer_dms_information = array_map(array($db, 'escape'), $customer_dms_information); // $return_arr["status"]=4; // $return_arr["message"]="This customer no. ".$customer_dms_row['Customer_No']." is already exist in ".$customer_dms_information['dms_name'].', '.$customer_dms_information['company_name'].' and '.$customer_dms_information['dealer_name']; // echo json_encode($return_arr); // exit; // } // } // } // if($customer->read_customer_name_if_exist($customer_data_array["mod-corporation-name"],$db) > 0){ // $customer_name = $customer->read_customer_info_and_id_by_name($customer_data_array["mod-corporation-name"],$db); // if($customer_name['corporation_name'] == $customer_data_array["mod-corporation-name"]){ $old_infos = $customer->read_customer_info_and_contact($customer_id, $db); $old_info_array = array(); foreach ($old_infos as $old_info) { $old_info_array = $old_info; } if ($db->escape($old_info_array['corporation_name']) <> $customer_data_array["mod-corporation-name"]) { if ($customer->read_customer_name_if_exist($customer_data_array["mod-corporation-name"], $db) > 0) { $return_arr["status"] = 0; $return_arr["message"] = "Customer name already exists."; echo json_encode($return_arr); exit; } } if ($customer_type == 1) { if ($old_info_array['mobile_phone_1'] <> $new_customer_number) { if (!$force_update) { if ($customer->read_customer_mobile_if_exist($new_customer_number, $db) > 0) { $return_arr["status"] = 2; $return_arr["message"] = "Mobile already registered."; echo json_encode($return_arr); exit; } } } // if($customer_type == 1){ if ($utility->isNotEmpty($customer_data_array["mod-email"])) { // if($customer_id == '27563965982706219'){ // echo $old_info_array['email_1'] .' '. $customer_data_array["mod-email"] ; // exit; // } if (strtolower($old_info_array['email_1']) <> strtolower($customer_data_array["mod-email"])) { if (!$force_update) { if ($customer->read_customer_email_if_exist($customer_data_array["mod-email"], $db) > 0) { $return_arr["status"] = 3; $return_arr["message"] = "Email already registered"; echo json_encode($return_arr); exit; } } } } } //reason in force update if ($force_update) { // $customer->insert_duplicate_reason($customer_id,$customer_data_array["mod-email"],$new_customer_number,$force_update_reason,$_SESSION['user']['id'],$utility,$db); $log_desc = "Duplicate customer: %s %s %s %s"; $logger->create( $_SESSION['user']['id'], sprintf( $log_desc, ($customer_type == 1) ? '[ID:' . $customer_id . ', ' . $customer_data_array["mod-firstname"] . ' ' . $customer_data_array["mod-lastname"] . ']' : '[ID:' . $customer_id . ', ' . $customer_data_array["mod-corporation-name"] . ']', ($utility->isNotEmpty($new_customer_number)) ? '[Mobile: ' . $new_customer_number . ']' : '', ($utility->isNotEmpty($customer_data_array["mod-email"])) ? '[Email: ' . $customer_data_array["mod-email"] . ']' : '', ($utility->isNotEmpty($force_update_reason)) ? '[Reason: ' . $force_update_reason . ']' : '' ), $customer_id, 'duplicate_customer', $db ); } $religion_name = ($customer_data_array["mod-dd-religion"]); if ($utility->isNotEmpty($religion_name)) { $religion_id = $religion->read_religion_id_by_name($religion_name, $db); if (!$utility->isNotEmpty($religion_id)) { $religion_id = $religion->create_religion($religion_name, $db); } } else { $religion_id = 0; } $date_of_birth = ''; if ($utility->isNotEmpty($customer_data_array["mod-birthdate"])) { $date_of_birth = $utility->convert_sql_date($customer_data_array["mod-birthdate"], 'mm/dd/yyyy'); } $nature_of_business_name = ($customer_data_array["mod-nature-of-business"]); if ($utility->isNotEmpty($nature_of_business_name)) { $nature_of_business_id = $nature_of_business->read_nature_of_business_id_by_name($nature_of_business_name, $db); if (!$utility->isNotEmpty($nature_of_business_id)) { $nature_of_business_id = $nature_of_business->create_nature_of_business($nature_of_business_name, $db); } } else { $nature_of_business_id = 0; } $profession_name = ($customer_data_array["mod-dd-profession"]); if ($utility->isNotEmpty($profession_name)) { $profession_id = $profession->read_profession_id_by_name($profession_name, $db); if (!$utility->isNotEmpty($profession_id)) { $profession_id = $profession->create_profession($profession_name, $db); } } else { $profession_id = 0; } $array_data['aha_status'] = intval($customer_data_array['aha-status']); // Insert Customer Informnation $update_customer = $customer->update_customer( $array_data, $customer_id, $customer_data_array["mod-corporation-name"], 0, //salutation_id $customer_data_array["mod-firstname"], $customer_data_array["mod-middlename"], $customer_data_array["mod-lastname"], $customer_data_array["mod-dd-suffix"], $customer_data_array["mod-dd-gender"], $customer_data_array["mod-dd-nationality"], $date_of_birth, $customer_data_array["mod-dd-marital-status"], 0, //source_id deprecated 0, //mode_of_contact_id deprecated $customer_data_array["mod-spouse"], $customer_data_array["mod-position"], '', //contact_person deprecated 'default.png', $_SESSION['user']['id'], $customer_type, $customer_data_array["mod-dd-customer-category"], $religion_id, $_SESSION['user']['id'], $customer_data_array["mod-business-company"], $profession_id, $nature_of_business_id, 1, //status $db ); // // Insert Customer Business // $update_customer_business = $customer->update_customer_business( // $customer_id, // $customer_data_array["mod-dd-profession"], // $customer_data_array["mod-business-company"], // '', //address // '0', //city_id // '', //postal // '1', //status // $db); $mode_of_contact_name = ($customer_data_array["mod-preferred-moc"]); if ($utility->isNotEmpty($mode_of_contact_name)) { $mode_of_contact_id = $mode_of_contact->read_mode_of_contact_id_by_name($mode_of_contact_name, $db); if (!$utility->isNotEmpty($mode_of_contact_id)) { $mode_of_contact_id = $mode_of_contact->create_mode_of_contact($mode_of_contact_name, $db); } } else { $mode_of_contact_id = 0; } $update_customer_contact = $customer->update_customer_contact( // var_dump($utility->fix_mobile_format($customer_data_array["mod-other-mobile-number"]));exit; $customer_id, $customer_data_array["mod-address-1"], $customer_data_array["mod-address-2"], '0', //state 1 '0', //state 2 $customer_data_array["mod-dd-city-1"], $customer_data_array["mod-dd-city-2"], $customer_data_array["mod-postal-1"], $customer_data_array["mod-postal-2"], $customer_data_array["mod-email"], (isset($customer_data_array["mod-other-email1"]) ? $customer_data_array["mod-other-email1"] : ''), (isset($customer_data_array["mod-other-email2"]) ? $customer_data_array["mod-other-email2"] : ''), $customer_data_array["mod-viber"], $customer_data_array["mod-facebook"], $customer_data_array["mod-instagram"], $customer_data_array["mod-telegram"], $customer_data_array["mod-whatsapp"], '', //other social $customer_data_array["mod-website"], (isset($customer_data_array["mod-business-number"]) ? $utility->fix_mobile_format($customer_data_array["mod-business-number"]) :''), '', //fax $new_customer_number, (isset($customer_data_array['mod-other-mobile-number1']) ? $utility->fix_mobile_format($customer_data_array["mod-other-mobile-number1"]):''), (isset($customer_data_array['mod-other-mobile-number2']) ? $utility->fix_mobile_format($customer_data_array["mod-other-mobile-number2"]):''), $utility->fix_mobile_format($customer_data_array["mod-home-phone"]), $mode_of_contact_id, $customer_data_array["mod-landline"], '1', $db ); $customer->delete_customer_dms($customer_id, $granted_company_ids, $db); $customer_dms_array = array(); if ($customer_dms <> '') { foreach ($customer_dms as $customer_dms_row) { $company_dealer_id = $company_dealer->read_company_dealer_id($customer_dms_row['Company'], $customer_dms_row['Dealer'], '1', $db); $customer_dms_array[] = "('$customer_id','" . $customer_dms_row['Customer_No'] . '_' . $customer_dms_row['DMS'] . $company_dealer_id . "'," . $company_dealer_id . ",'1')"; } $customer_dms_to_insert = implode(',', $customer_dms_array); $insert_customer_dms = $customer->create_customer_dms($customer_dms_to_insert, $db); } $customer_contact_persons = isset($_REQUEST['customer_contact_person']) ? $_REQUEST['customer_contact_person'] : ''; // print_r($customer_contact_persons);exit; $customer->delete_contact_person($customer_id, $db); $customer_contact_person_array = array(); if ($customer_contact_persons <> '') { $customer_contact_persons = array_map(array($utility, 'upperCaseNestedArray'), $customer_contact_persons); $customer_contact_persons = array_map(array($db, 'escape'), $customer_contact_persons); foreach ($customer_contact_persons as $customer_contact_person) { $customer_contact_person_array[] = "('$customer_id','" . $customer_contact_person['Fullname'] . "','" . $customer_contact_person['Email'] . "','" . (($utility->isNotEmpty($customer_contact_person["Mobile"])) ? '+63' . $customer_contact_person["Mobile"] : '') . "','1')"; } $contact_person_to_insert = implode(',', $customer_contact_person_array); $customer->create_customer_contact_person($contact_person_to_insert, $db); } $customer_childrens = isset($_REQUEST['customer_children']) ? $_REQUEST['customer_children'] : ''; $customer_children_array = array(); $customer->delete_customer_children($customer_id, $db); if ($customer_childrens <> '') { $customer_childrens = array_map(array($utility, 'upperCaseNestedArray'), $customer_childrens); $customer_childrens = array_map(array($db, 'escape'), $customer_childrens); foreach ($customer_childrens as $customer_children) { $new_children_date_of_birth = $utility->convert_sql_date($customer_children['Birthday'], 'mm/dd/yyyy'); $customer_children_array[] = "('$customer_id','" . $customer_children['Firstname'] . "', '" . $customer_children['Lastname'] . "','" . $new_children_date_of_birth . "','" . (($utility->isNotEmpty($customer_children['Mobile'])) ? '+63' . $customer_children['Mobile'] : '') . "','1')"; } $customer_children_to_insert = implode(',', $customer_children_array); $customer->create_customer_children($customer_children_to_insert, $db); } $customer_interests = isset($_REQUEST['customer_interest']) ? $_REQUEST['customer_interest'] : ''; $customer_interest_array = array(); $customer->delete_customer_interest_list($customer_id, $db); if ($customer_interests <> '') { $customer_interests = array_map(array($utility, 'upperCaseNestedArray'), $customer_interests); $customer_interests = array_map(array($db, 'escape'), $customer_interests); foreach ($customer_interests as $customer_interest) { $interest_category_id = $customer_interest['Category']; $interest_name = ($customer_interest['Interest']); $interest_id = $interest_hobbies->read_interest_id_by_name($interest_category_id, $interest_name, $db); if (!$utility->isNotEmpty($interest_id)) { $interest_id = $interest_hobbies->create_interest($interest_category_id, $interest_name, $db); } $customer_interest_array[] = "('" . $interest_id . "','$customer_id','1')"; } $customer_interest_to_insert = implode(',', $customer_interest_array); $customer->create_customer_interest_list($customer_interest_to_insert, $db); } $customer_affiliations = isset($_REQUEST['customer_affiliations']) ? $_REQUEST['customer_affiliations'] : ''; $customer_affiliations_array = array(); $customer->delete_customer_affiliations_list($customer_id, $db); if ($customer_affiliations <> '') { $customer_affiliations = array_map(array($utility, 'upperCaseNestedArray'), $customer_affiliations); $customer_affiliations = array_map(array($db, 'escape'), $customer_affiliations); foreach ($customer_affiliations as $customer_affiliation) { $affiliations_category_id = $customer_affiliation['Category']; $affiliations_name = ($customer_affiliation['Affiliations']); $affiliations_id = $affiliations->read_affiliations_id_by_name($affiliations_category_id, $affiliations_name, $db); if (!$utility->isNotEmpty($affiliations_id)) { $affiliations_id = $affiliations->create_affiliations($affiliations_category_id, $affiliations_name, $db); } $customer_affiliations_array[] = "('" . $affiliations_id . "','$customer_id','1')"; } $customer_affiliations_to_insert = implode(',', $customer_affiliations_array); $customer->create_customer_affiliations_list($customer_affiliations_to_insert, $db); } if (intval($update_customer) > 0 && intval($update_customer_contact) > 0) { $return_arr["status"] = 1; $return_arr["message"] = "Customer Data Updated"; $old_name = ''; $new_name = ''; if ($customer_type == 1) { $old_name = $old_info_array['first_name'] . ' ' . $old_info_array['middle_name'] . ' ' . $old_info_array['last_name']; $new_name = $customer_data_array["mod-firstname"] . ' ' . $customer_data_array["mod-middlename"] . ' ' . $customer_data_array["mod-lastname"]; } else if ($customer_type == 2) { $old_name = $old_info_array['corporation_name']; $new_name = $customer_data_array["mod-corporation-name"]; } // echo'NEW DATA
';print_r($customer_data_array);echo''; // echo'OLD DATA :
';print_r($old_info_array); echo''; //modify $log_name = ($old_name == $new_name) ? '' : "[Name: " . $old_name . " to " . $new_name . "]\n"; $log_mobile = ($old_info_array["mobile_phone_1"] == $new_customer_number) ? '' : "[Mobile: " . $old_info_array["mobile_phone_1"] . " to " . $new_customer_number . "]\n"; $log_mobile2 = ($old_info_array['mobile_phone_2'] == $new_customer_number2 ? '' : '[Other Mobile 1 :'. $old_info_array['mobile_phone_2'].' to '.$new_customer_number2.']\n'); $log_mobile3 =($old_info_array['mobile_phone_3'] == $new_customer_number3 ? '' : '[Other Mobile 2 :'. $old_info_array['mobile_phone_3'].' to '.$new_customer_number3.']\n'); $log_email = ($old_info_array["email_1"] == $customer_data_array["mod-email"]) ? '' : "[Email: " . $old_info_array["email_1"] . " to " . $customer_data_array["mod-email"] . "]\n"; $log_email2 =(isset($customer_data_array["mod-other-email1"]) ? ($old_info_array["email_2"] == $customer_data_array["mod-other-email1"]) ? '' : "[Email: " . $old_info_array["email_2"] . " to " . $customer_data_array["mod-other-email1"] . "]\n" :''); $log_email3 =(isset($customer_data_array["mod-other-email2"]) ? ($old_info_array["email_3"] == $customer_data_array["mod-other-email2"]) ? '' : "[Email: " . $old_info_array["email_3"] . " to " . $customer_data_array["mod-other-email2"] . "]\n" : ''); $log_address = ($old_info_array["address_1"] == $customer_data_array["mod-address-1"]) ? '' : "[Address: " . $old_info_array["address_1"] . " to " . $customer_data_array["mod-address-1"] . "]\n"; $log_address2 = ($old_info_array["address_2"] == $customer_data_array["mod-address-2"]) ? '' : "[Other address: " . $old_info_array["address_2"] . " to " . $customer_data_array["mod-address-2"] . "]\n"; $log_bday = ($old_info_array["date_of_birth"] == date('Y-m-d',strtotime($customer_data_array["mod-birthdate"]))) ? '' : "[Birthday: " . $old_info_array["date_of_birth"] . " to " . date('Y-m-d',strtotime($customer_data_array["mod-birthdate"])) . "]\n"; $log_gender = ($old_info_array["gender_id"] == $customer_data_array["mod-dd-gender"]) ? '' : "[Gender: " . ($old_info_array["gender_id"]==1 ? 'Male' : 'Female') . " to " . ($customer_data_array["mod-dd-gender"]==1 ? 'Male' : 'Female') . "]\n"; $log_desc = "Update customer: %s%s%s%s%s%s%s%s%s%s%s%s"; //modify $logger->create( $_SESSION['user']['id'], sprintf( $log_desc, "[ID:" . $customer_id . ", " . $new_name . "]\n", $log_name, $log_gender, $log_bday, $log_mobile, $log_mobile2, $log_mobile3, $log_email, $log_email2, $log_email3, $log_address, $log_address2 ), $customer_id, 'update_customer', $db ); } else { $return_arr["status"] = 0; $return_arr["message"] = "Customer Data Not Updated"; } // $return_arr["status"]=1; // $return_arr["message"]="Customer Data Updated"; echo json_encode($return_arr); } else if ($apiKey === '3463916057587803' && $utility->isPostMethod($server_method)) { //Read $customer_id = isset($_REQUEST['customer_id']) ? $db->escape($_REQUEST['customer_id']) : '-1'; $customer_information = $customer->read_customer_profile($customer_id, $db); $customer_information['mod-dd-religion'] = $religion->read_religion_name_by_id($customer_information['mod-dd-religion'], $db); if ($utility->isNotEmpty($customer_information['mod-birthdate'])) { $customer_information['mod-birthdate'] = $utility->convert_sql_date_to_date_picker($customer_information['mod-birthdate']); //$religion->read_religion_name_by_id($customer_information['mod-birthdate-unformat'],$db); } // $customer_business = $customer->read_customer_business($customer_id,$db); $customer_contact = $customer->read_customer_contact($customer_id, $db); $return_information = array_merge($customer_information, $customer_contact); echo json_encode(array($return_information)); } else if ($apiKey === '8361020315855100' && $utility->isPostMethod($server_method)) { //Read Display // echo'aaaaa';exit $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer_information = $customer->read_customer_profile_display($customer_id, $granted_company_ids, $db); $customer_information['main_email'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_email']) ? $utility->mask_email($customer_information['main_email']) : '') : ((isset($fields_permissions['fields_email_1']) && !$fields_permissions['fields_email_1']) ? ($utility->isNotEmpty($customer_information['main_email']) ? $utility->mask_email($customer_information['main_email']) : '') : $customer_information['main_email']); $customer_information['main_customer_email_2'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_email_2']) ? $utility->mask_email($customer_information['main_customer_email_2']) : '') : ((isset($fields_permissions['fields_email_2']) && !$fields_permissions['fields_email_2']) ? ($utility->isNotEmpty($customer_information['main_customer_email_2']) ? $utility->mask_email($customer_information['main_customer_email_2']) : '') : $customer_information['main_customer_email_2']); $customer_information['main_customer_landline'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_landline']) ? $utility->mask($customer_information['main_customer_landline'], 2, 1) : '') : ((isset($fields_permissions['fields_landline']) && !$fields_permissions['fields_landline']) ? ($utility->isNotEmpty($customer_information['main_customer_landline']) ? $utility->mask($customer_information['main_customer_landline'], 2, 1) : '') : $customer_information['main_customer_landline']); $customer_information['main_customer_mobile'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_mobile']) ? $utility->mask($customer_information['main_customer_mobile'], 4, 1) : '') : ((isset($fields_permissions['fields_mobile_1']) && !$fields_permissions['fields_mobile_1']) ? ($utility->isNotEmpty($customer_information['main_customer_mobile']) ? $utility->mask($customer_information['main_customer_mobile'], 4, 1) : '') : $customer_information['main_customer_mobile']); $customer_information['main_customer_mobile_2'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_mobile_2']) ? $utility->mask($customer_information['main_customer_mobile_2'], 4, 1) : '') : ((isset($fields_permissions['fields_mobile_2']) && !$fields_permissions['fields_mobile_2']) ? ($utility->isNotEmpty($customer_information['main_customer_mobile_2']) ? $utility->mask($customer_information['main_customer_mobile_2'], 4, 1) : '') : $customer_information['main_customer_mobile_2']); $customer_information['main_customer_home_mobile'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_home_mobile']) ? $utility->mask($customer_information['main_customer_home_mobile'], 4, 1) : '') : ((isset($fields_permissions['fields_home_phone']) && !$fields_permissions['fields_home_phone']) ? ($utility->isNotEmpty($customer_information['main_customer_home_mobile']) ? $utility->mask($customer_information['main_customer_home_mobile'], 4, 1) : '') : $customer_information['main_customer_home_mobile']); $customer_information['main_customer_business_mobile'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_business_mobile']) ? $utility->mask($customer_information['main_customer_business_mobile'], 4, 1) : '') : ((isset($fields_permissions['fields_business_phone']) && !$fields_permissions['fields_business_phone']) ? ($utility->isNotEmpty($customer_information['main_customer_business_mobile']) ? $utility->mask($customer_information['main_customer_business_mobile'], 4, 1) : '') : $customer_information['main_customer_business_mobile']); $customer_information['main_customer_address_1'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_address_1']) ? $utility->mask($customer_information['main_customer_address_1'], 2, 2) : '') : ((isset($fields_permissions['fields_address_1']) && !$fields_permissions['fields_address_1']) ? ($utility->isNotEmpty($customer_information['main_customer_address_1']) ? $utility->mask($customer_information['main_customer_address_1'], 3, 0) : '') : $customer_information['main_customer_address_1']); $customer_information['main_customer_address_2'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_customer_address_2']) ? $utility->mask($customer_information['main_customer_address_2'], 2, 2) : '') : ((isset($fields_permissions['fields_address_2']) && !$fields_permissions['fields_address_2']) ? ($utility->isNotEmpty($customer_information['main_customer_address_2']) ? $utility->mask($customer_information['main_customer_address_2'], 3, 0) : '') : $customer_information['main_customer_address_2']); $customer_information['main_viber'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_viber']) ? $utility->mask($customer_information['main_viber'], 2, 1) : '') : ((isset($fields_permissions['fields_viber']) && !$fields_permissions['fields_viber']) ? ($utility->isNotEmpty($customer_information['main_viber']) ? $utility->mask($customer_information['main_viber'], 2, 1) : '') : $customer_information['main_viber']); $customer_information['main_facebook'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_facebook']) ? $utility->mask($customer_information['main_facebook'], 2, 1) : '') : ((isset($fields_permissions['fields_facebook']) && !$fields_permissions['fields_facebook']) ? ($utility->isNotEmpty($customer_information['main_facebook']) ? $utility->mask($customer_information['main_facebook'], 2, 1) : '') : $customer_information['main_facebook']); $customer_information['main_instagram'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_instagram']) ? $utility->mask($customer_information['main_instagram'], 2, 1) : '') : ((isset($fields_permissions['fields_instagram']) && !$fields_permissions['fields_instagram']) ? ($utility->isNotEmpty($customer_information['main_instagram']) ? $utility->mask($customer_information['main_instagram'], 2, 1) : '') : $customer_information['main_instagram']); $customer_information['main_whatsapp'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_whatsapp']) ? $utility->mask($customer_information['main_whatsapp'], 2, 1) : '') : ((isset($fields_permissions['fields_whatsapp']) && !$fields_permissions['fields_whatsapp']) ? ($utility->isNotEmpty($customer_information['main_whatsapp']) ? $utility->mask($customer_information['main_whatsapp'], 2, 1) : '') : $customer_information['main_whatsapp']); $customer_information['main_telegram'] = (!$fields_permissions) ? ($utility->isNotEmpty($customer_information['main_telegram']) ? $utility->mask($customer_information['main_telegram'], 2, 1) : '') : ((isset($fields_permissions['fields_telegram']) && !$fields_permissions['fields_telegram']) ? ($utility->isNotEmpty($customer_information['main_telegram']) ? $utility->mask($customer_information['main_telegram'], 2, 1) : '') : $customer_information['main_telegram']); // $customer_information['mod-dd-religion']= $religion->read_religion_name_by_id($customer_information['mod-dd-religion'],$db); // // if($utility->isNotEmpty($customer_information['information_dob'] )){ // $customer_information['information_dob'] = $utility->convert_sql_date_to_date_picker($customer_information['information_dob']); //$religion->read_religion_name_by_id($customer_information['mod-birthdate-unformat'],$db); // } // $customer_business = $customer->read_customer_ business($customer_id,$db); // $customer_contact = $customer->read_customer_contact($customer_id,$db); // $return_information = array_merge($customer_information); echo json_encode(array($customer_information)); // echo'
';print_r($customer_information);echo'';exit; } else if ($apiKey === '6579442853321353' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_profile_interest($customer_id, $db); } else if ($apiKey === '3099751888433363' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_dms($customer_id, $granted_company_ids, $db); } else if ($apiKey === '4788616921820004' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_contact_person($customer_id, $db); } else if ($apiKey === '8307826786414874' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_children($customer_id, $db); } else if ($apiKey === '2089441825396664' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_education($customer_id, $db); } else if ($apiKey === '5660696728127200' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_affiliations($customer_id, $db); } else if ($apiKey === '5474981987699557' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_unit_association($customer_id, $db); } else if ($apiKey === '2223348764004177' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_car_club($customer_id, $db); } else if ($apiKey === '9526394287040079' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_political_club($customer_id, $db); } else if ($apiKey === '7193296844816864' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_network_marketing($customer_id, $db); } else if ($apiKey === '4432527649394050' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_media_publication($customer_id, $db); } else if ($apiKey === '5103641855052276' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_sme_group($customer_id, $db); } else if ($apiKey === '1773522681941804' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_fraternities_sororities($customer_id, $db); } else if ($apiKey === '1803139298208721' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_facebook_group($customer_id, $db); } else if ($apiKey === '4010640559253012' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_celebrity_influencers($customer_id, $db); } else if ($apiKey === '9707323227112625' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_profile_dms($customer_id, $db); } else if ($apiKey === '4938305064275028' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_profile_company($customer_id, $db); } else if ($apiKey === '7340685518692652' && $utility->isPostMethod($server_method)) { //Read Customer Interest $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $customer->read_customer_profile_dealer($customer_id, $db); } else if ($apiKey === '9490540601210798') { //Update } else if ($apiKey === '7472626829226859' && $utility->isPostMethod($server_method)) { //Delete' $customer_id = isset($_REQUEST['customer_id']) ? $_REQUEST['customer_id'] : '-1'; $vehicle_ids = $customer->read_customer_vehicle_ids($customer_id, $db); // $json_arr['sales_image'] = '
