File manager

File manager - Edit - /home/autoph/public_html/connectv1/z_data.php

Back
<?php //dev@DEV2021 //DEV@dev10244 ini_set('memory_limit', '-1'); include_once('cfg/db.php'); read_customer_profile_display($db); function read_customer_profile_display($db){ //read implementation $query_customer_info = "SELECT ci.id, ci.corporation_id,snob.name as profession ,sr.name as religion, ci.corporation_name,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, cc.landline, 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,ci.contact_person, ci.time_created, cc.address_1, cc.address_2, 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,snb.name as nature_of_business, ( IF( ci.category_id <> 0,ccat.name, IF( COUNT(se.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, smoc.name as mode_of_contact, sct.name as customer_type, DATE_FORMAT(ci.date_modified, '%M %d, %Y - %h:%i:%s %p') AS date_modified, em.first_name AS emfname, em.middle_name AS emmname, em.last_name AS emlname FROM customer ci LEFT OUTER JOIN customer_category ccat ON ci.category_id = ccat.id LEFT OUTER JOIN source_profession snob ON ci.profession_id=snob.id LEFT OUTER JOIN source_nature_of_business snb ON ci.nature_of_business_id=snb.id LEFT OUTER JOIN source_religion sr ON ci.religion_id = sr.id LEFT OUTER JOIN all_gender g ON ci.gender_id=g.id LEFT OUTER JOIN customer_contact cc ON ci.id=cc.customer_id LEFT OUTER JOIN all_suffix sx ON ci.suffix_id=sx.id LEFT OUTER JOIN all_countries ac ON ci.nationality_id=ac.num_code LEFT OUTER JOIN all_marital_status ams ON ci.marital_status_id=ams.id LEFT OUTER JOIN employee e ON ci.upload_by=e.id LEFT OUTER JOIN employee em ON ci.modified_by=em.id LEFT OUTER JOIN customer_dms cd ON ci.id=cd.customer_record_id LEFT OUTER JOIN source_company_dealer scd ON cd.company_dealer_id=scd.id LEFT OUTER JOIN source_company sc ON scd.company_id=sc.id LEFT OUTER JOIN source_dms sdms ON sc.dms_id=sdms.id LEFT OUTER JOIN source_dealer sd ON scd.dealer_id=sd.id LEFT OUTER JOIN all_city acity1 ON cc.address_1_city=acity1.id LEFT OUTER JOIN all_city acity2 ON cc.address_2_city=acity2.id LEFT OUTER JOIN source_customer_type sct ON ci.type=sct.id LEFT OUTER JOIN vehicle v ON ci.id = v.customer_record_id LEFT OUTER JOIN sales s ON v.id = s.vehicle_id LEFT OUTER JOIN service se ON v.id = se.vehicle_id LEFT OUTER JOIN source_mode_of_contact smoc ON cc.mode_of_contact_id = smoc.id WHERE 1 AND ci.status = 1 AND ci.upload_source = 0 AND DATE(ci.date_uploaded) < '2021-08-01' GROUP BY ci.id ORDER BY sc.name ASC, sd.name ASC /LIMIT 2*/ "; // echo $query_customer_info; return; $customer_info = $db -> return_result($query_customer_info); $suffix = ""; $involvements = "SELECT sd.name AS dms, sc.code AS company, sdr.code AS dealer FROM `customer_dms` cd 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_dms sd ON sc.`dms_id` = sd.id INNER JOIN source_dealer sdr ON sdr.id = scd.dealer_id WHERE 1 AND `customer_record_id` IN ('%s') "; $scs_involve = "SELECT CONCAT(sp.first_name,' ',sp.last_name) as sales_consultant FROM `sales` s LEFT OUTER JOIN sales_consultant sp ON s.sales_person = sp.id LEFT OUTER JOIN vehicle v ON s.vehicle_id = v.id WHERE 1 AND v.customer_record_id IN ('%s') ; "; $all_data = array(); foreach($customer_info as $data){ $arr = array(); //start connected company and dealer $involvements_qry = sprintf($involvements,$data['id']); $in = $db->return_result($involvements_qry); $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); //end connected company and dealer //start connected company and dealer $sc_qry = sprintf($scs_involve,$data['id']); $sc_qry_in = $db->return_result($sc_qry); $scs = array(); foreach($sc_qry_in as $data2){ $scs = array_merge($scs, array($data2['sales_consultant'])); } $scs_new = array_unique($scs); $list_scs = implode(', ', $scs_new); //end connected company and dealer if(intval($data['corporation_id']) <= 0){ $customer_corporation_name = ''; }else{ $customer_corporation_name = $db->select("SELECT corporation_name FROM customer WHERE id = '".$data['corporation_id']."' AND status = 1"); } if($data['suffix'] == "None"){ $suffix = ""; } else { $suffix = " " . $data['suffix']; } $arr['customer_record_id'] = $data['id']; $arr['information_source_company'] = $data['source_company']; $arr['information_source_dealer'] = $data['source_dealer']; // $arr['information_source_dms'] = $data['source_dms']; if(intval($data['type']) === 1){ $arr['main_corporation_name'] = ''; // $arr['full_name'] = $data['first_name'] . " " . $data['middle_name'] . " " . $data['last_name'] . " " . $suffix; $arr['main_first_name'] = $data['first_name']; $arr['main_middle_name'] = $data['middle_name']; $arr['main_last_name'] = $data['last_name']; // $arr['suffix'] = $suffix; }else{ $arr['main_corporation_name'] = $data['corporation_name']; // $arr['full_name'] = ''; $arr['main_first_name'] = ''; $arr['main_middle_name'] = ''; $arr['main_last_name'] = ''; // $arr['suffix'] = ''; } $arr['main_email'] = $data['email_1']; // $arr['main_customer_email_2'] = $data['email_2']; // $arr['information_religion'] = $data['religion']; $arr['main_customer_mobile'] = $data['mobile_phone_1']; // $arr['main_customer_landline'] = $data['landline']; // $arr['main_customer_mobile_2'] = $data['mobile_phone_2']; // $arr['main_customer_home_mobile'] = $data['residential_phone']; // $arr['fax_phone'] = $data['fax_phone']; // $arr['main_customer_business_mobile'] = $data['business_phone']; $arr['information_gender'] = $data['gender_name']; // $arr['information_date_created'] = $data['date_created']; // $arr['information_dob'] = $data['birthdate']; // // $arr['information_nationality'] = $data['nationality']; // $arr['no_of_children'] = $data['no_of_children']; // $arr['information_age'] = $data['age_number']; // $arr['information_position'] = $data['occupation']; // $arr['information_marital_status'] = $data['marital_status']; // $arr['information_spouse'] = $data['spouse_name']; // $arr['contact_person'] = $data['contact_person']; // $arr['time_created'] = $data['time_created']; $arr['main_address_1'] = $data['address_1']; // $arr['main_address_2'] = $data['address_2']; $arr['main_city_1'] = $data['address_1_city']; // $arr['main_city_2'] = $data['address_2_city']; // $arr['main_postal_1'] = $data['address_1_postal']; // $arr['main_postal_2'] = $data['address_2_postal']; // $arr['main_customer_address_1'] = $arr['main_address_1'].' '.$arr['main_city_1'].' '.$arr['main_postal_1']; // $arr['main_customer_address_2'] = $arr['main_address_2'].' '.$arr['main_city_2'].' '.$arr['main_postal_2']; // $arr['information_uploaded_by'] = $data['efname'] . " " . $data['elname']; // $arr['information_date_uploaded'] = $data['date_uploaded']; // $arr['information_modified_by'] = $data['emfname'] . " " . $data['emlname']; // $arr['information_date_modified'] = $data['date_modified']; // $arr['customer_type'] = (intval($data['type']) === 1) ? 'Individual' : 'Corporation' ; // $arr['main_customer_type'] = $data['customer_type']; // $arr['customer_type_id'] = $data['type']; // $arr['main_category'] = $data['customer_category']; // $arr['main_customer_status'] =(intval($data['isActive']) == 1 ? 'Active' : 'Inactive'); // $arr['main_customer_moc'] = $data['mode_of_contact']; // $arr['main_facebook'] = $data['facebook']; // $arr['main_instagram'] = $data['instagram']; // $arr['main_viber'] = $data['viber']; // $arr['main_telegram'] = $data['telegram']; // $arr['main_whatsapp'] = $data['whatsapp']; // $arr['main_website_link'] = $data['website']; // $arr['information_business_company_name'] = $customer_corporation_name; // $arr['information_profession'] = $data['profession']; // $arr['information_nature_of_work_business'] = $data['nature_of_business']; // $arr['information_dms_list'] = $list_dms; $arr['information_company_list'] = $list_company; $arr['information_dealer_list'] = $list_dealer; $arr['sc_list'] = $list_scs; $all_data[] = $arr; } // return $arr; echo json_encode($all_data); } ?>

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