File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/customer/customer_individual_view.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, 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, 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, ( IF( COUNT(v.id) > 0 && COUNT(s.id) < 1, 'SVO', IF( COUNT(se.id) < 1 && COUNT(s.id) > 0, 'SAO', IF( COUNT(v.id) = 1 && COUNT(se.id) > 0 && COUNT(s.id) > 0, 'LYL', IF( COUNT(v.id) > 1 && COUNT(v.id) < 4, 'SLY', IF( COUNT(v.id) > 3, 'VIP','None'/VVIP/ ) ) ) ) ) ) as customer_category, IF( (SELECT DATEDIFF(NOW(),se.start_date_of_service) <= 365) \|\| (SELECT DATEDIFF(NOW(),s.activity_date) <= 365) , '1','2' ) as isActive 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 LEFT OUTER JOIN vehicle v ON cd.customer_dms_id = v.customer_id LEFT OUTER JOIN sales s ON cd.customer_dms_id = s.customer_id LEFT OUTER JOIN service se ON cd.customer_dms_id = se.customer_id WHERE ci.id='$id' ORDER BY ci.id ASC LIMIT 1"; //echo $query_customer_info; return; $involvements = "SELECT sd.name AS dms, sc.code AS company, sdr.code AS dealer FROM `customer_dms` cd INNER JOIN source_dms sd ON cd.`dms_id` = sd.id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dealer sdr ON sdr.id = scd.dealer_id WHERE `customer_record_id` IN ('$id')"; // echo $query_customer_info; return; $customer_info = $db -> return_result($query_customer_info); $suffix = ""; $in = $db->return_result($involvements); //echo $involvements; return; $dms = array(); $company = array(); $dealer = array(); foreach($in as $data1){ $dms = array_merge($dms, array($data1['dms'])); $company = array_merge($company, array($data1['company'])); $dealer = array_merge($dealer, array($data1['dealer'])); } $dms_new = array_unique($dms); $company_new = array_unique($company); $dealer_new = array_unique($dealer); $list_dms = implode(', ', $dms_new); $list_company = implode(', ', $company_new); $list_dealer = implode(', ', $dealer_new); //echo $query_customer_info; return; foreach($customer_info as $data){ if($data['suffix'] == "None"){ $suffix = ""; } else { $suffix = " " . $data['suffix']; } $arr['photo'] = $data['photo']; $arr['full_name'] = $data['first_name'] . " " . $data['middle_name'] . " " . $data['last_name'] . " " . $suffix; $arr['firstname'] = $data['first_name']; $arr['middlename'] = $data['middle_name']; $arr['lastname'] = $data['last_name']; $arr['suffix'] = $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['upload_by'] = $data['efname'] . " " . $data['emname']. " " . $data['elname']; $arr['date_uploaded'] = $data['date_uploaded']; $arr['type'] = (intval($data['type']) === 1) ? 'Individual' : 'Corporation' ; $arr['customer_category'] = $data['customer_category']; $arr['is_active'] =(intval($data['isActive']) == 1 ? 'Active' : 'Inactive'); $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['']; } $arr['dms_list'] = $list_dms; $arr['company_list'] = $list_company; $arr['dealer_list'] = $list_dealer; echo json_encode($arr); ?>

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