File manager - Edit - /home/autoph/public_html/connectv1/app/update/customer/load_customer_individual.php
Back
<?php include('../../../cfg/db.php'); $id = $db->escape($_POST['id']); $query_customer_info = "SELECT ci.id, ci.first_name, ci.middle_name, ci.last_name, g.gender_name, DATE_FORMAT(ci.date_created, '%M %d, %Y') AS date_created, cc.email_1, cc.email_2, cc.mobile_phone_1, cc.mobile_phone_2, cc.residential_phone, cc.fax_phone, cc.business_phone, /*sx.suffix_name AS suffix_name,*/ ci.suffix_id AS suffix, ac.nationality, ci.no_of_children, ci.occupation, ams.name AS marital_status, DATE_FORMAT(ci.date_of_birth, '%M %d, %Y') AS birthdate, si.name AS sources, smc.name AS mode_of_contact, ci.contact_person, ci.time_created, cc.address_1, cc.address_2, /*astate1.provDesc AS address_1_state,*/cc.address_1_state, astate2.provDesc AS address_2_state, acity1.citymunDesc AS address_1_city, sc.code AS source_company, sd.code AS source_dealer, sdms.name AS source_dms, acity2.citymunDesc AS address_2_city, cc.address_1_postal, cc.address_2_postal, ci.photo, ci.spouse_name, DATE_FORMAT(ci.date_uploaded, '%M %d, %Y - %h:%i:%s %p') AS date_uploaded, e.first_name AS efname, e.middle_name AS emname, e.last_name AS elname, TIMESTAMPDIFF(YEAR,ci.date_of_birth, CURDATE() ) as age_number , ci.type, cc.viber, cc.facebook, cc.instagram, cc.whatsapp, cc.telegram, cc.website FROM customer ci INNER JOIN all_gender g ON ci.gender_id=g.id INNER JOIN customer_contact cc ON ci.id=cc.customer_id INNER JOIN all_suffix sx ON ci.suffix_id=sx.id INNER JOIN all_countries ac ON ci.nationality_id=ac.num_code INNER JOIN all_marital_status ams ON ci.marital_status_id=ams.id INNER JOIN source_of_inquiry si ON ci.source_id=si.id INNER JOIN source_mode_of_contact smc ON ci.mode_of_contact_id=smc.id INNER JOIN employee e ON ci.upload_by=e.id INNER JOIN customer_dms cd ON ci.id=cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id=scd.id INNER JOIN source_dms sdms ON cd.dms_id=sdms.id INNER JOIN source_company sc ON scd.company_id=sc.id INNER JOIN source_dealer sd ON scd.dealer_id=sd.id LEFT OUTER JOIN all_state astate1 ON cc.address_1_state=astate1.provCode LEFT OUTER JOIN all_state astate2 ON cc.address_2_state=astate2.provCode INNER JOIN all_city acity1 ON cc.address_1_city=acity1.id INNER JOIN all_city acity2 ON cc.address_2_city=acity2.id WHERE ci.id='$id' ORDER BY ci.id ASC LIMIT 1"; //echo $query_customer_info; return; $customer_info = $db -> return_result($query_customer_info); $suffix = ""; foreach($customer_info as $data){ $arr['photo'] = $data['photo']; $arr['firstname'] = $data['first_name']; $arr['middlename'] = $data['middle_name']; $arr['lastname'] = $data['last_name']; $arr['suffix'] = $data['suffix']; $arr['email'] = $data['email_1']; $arr['email_2'] = $data['email_2']; $arr['contact'] = $data['mobile_phone_1']; $arr['contact_2'] = $data['mobile_phone_2']; $arr['residential_phone'] = $data['residential_phone']; $arr['fax_phone'] = $data['fax_phone']; $arr['business_phone'] = $data['business_phone']; $arr['gender'] = $data['gender_name']; $arr['date_created'] = $data['date_created']; $arr['date_of_birth'] = $data['birthdate']; $arr['nationality'] = $data['nationality']; $arr['no_of_children'] = $data['no_of_children']; $arr['age_number'] = $data['age_number']; $arr['occupation'] = $data['occupation']; $arr['marital_status'] = $data['marital_status']; $arr['spouse_name'] = $data['spouse_name']; $arr['source_name'] = $data['sources']; $arr['mode_of_contact'] = $data['mode_of_contact']; $arr['contact_person'] = $data['contact_person']; $arr['time_created'] = $data['time_created']; $arr['source_company'] = $data['source_company']; $arr['source_dealer'] = $data['source_dealer']; $arr['source_dms'] = $data['source_dms']; $arr['address_1'] = $data['address_1']; $arr['address_2'] = $data['address_2']; $arr['city_1'] = $data['address_1_city']; $arr['city_2'] = $data['address_2_city']; $arr['state_1'] = $data['address_1_state']; $arr['state_2'] = $data['address_2_state']; $arr['postal_1'] = $data['address_1_postal']; $arr['postal_2'] = $data['address_2_postal']; $arr['type'] = (intval($data['type']) === 1) ? 'Individual' : 'Corporate' ; $arr['facebook'] = $data['facebook']; $arr['instagram'] = $data['instagram']; $arr['viber'] = $data['viber']; $arr['telegram'] = $data['telegram']; $arr['whatsapp'] = $data['whatsapp']; $arr['website_link'] = $data['website']; //$arr['dms'] = $data['']; } echo json_encode($arr); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings