File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/sms_service/review_request.php

Back
<?php include_once("../../cfg/db.php"); include_once("../notification/notification.php"); include_once("../sms/send_sms.php"); include_once("../mail/send_mail.php"); include_once("../language/en-US.php"); include_once("../../api/controllers/utility.php"); if(!isset($_SESSION['user'])){ exit(); } $utility = new Utility(); $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; $sort_by = $db->escape(($_POST['sort-by'])); $level = $db->escape(($_POST['level'])); $date_from = $db->escape(($_POST['reg-from'])); $date_to = $db->escape(($_POST['reg-to'])); $company = $db->escape(($_POST['company'])); $dealer = $db->escape(($_POST['dealer'])); $customer_type = $db->escape(($_POST['type'])); $customer_category = $db->escape(($_POST['category'])); $customer_status = $db->escape(($_POST['active-status'])); $customer_data = $db->escape(($_POST['filter-data'])); $gender = $db->escape(($_POST['gender'])); $date_of_birth = $db->escape(($_POST['date-of-birth'])); $age_from = $db->escape(($_POST['age-from'])); $age_to = $db->escape(($_POST['age-to'])); $brand = $db->escape(($_POST['brand'])); $model = $db->escape(($_POST['model'])); $variant = $db->escape(($_POST['variant'])); $state = $db->escape(($_POST['state'])); $city = $db->escape(($_POST['city'])); $description = $db->escape(($_POST['description'])); $message_content = $db->escape(($_POST['message-content'])); // if(isNotEmpty($upload_date_from) && isNotEmpty($upload_date_to)){ // $filter_date_upload = " AND c.date_uploaded BETWEEN DATE_FORMAT('$upload_date_from', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$upload_date_to', '%Y-%m-%d 23:59:00') "; // } else { // $filter_date_upload = ""; // } // if(isNotEmpty($activity_date_from) && isNotEmpty($activity_date_to)){ // $filter_date_created = " AND c.date_created BETWEEN DATE_FORMAT('$activity_date_from', '%Y-%m-%d 00:00:00') AND DATE_FORMAT('$activity_date_to', '%Y-%m-%d 23:59:00') "; // } else { // $filter_date_created = ""; // } if(isNotEmpty($age_from) && isNotEmpty($age_to)){ $filter_age = " AND TIMESTAMPDIFF(YEAR,c.date_of_birth, CURDATE()) BETWEEN '$age_from' AND '$age_to' "; }else{ $filter_age = ""; } // if(isNotEmpty($upload_by_id)){ // $filter_upload_by = " AND c.upload_by = '$upload_by_id' "; // }else{ // $filter_upload_by = ""; // } $company = ($company != '0') ? " AND scd.company_id = '$company' " : " AND scd.company_id IN (".$granted_company_ids.") " ; $dealer = ($dealer != '0') ? " AND scd.dealer_id = '$dealer' " : "" ; $gender =($gender != '0') ? " AND c.gender_id = '".$gender."' " : "" ; $dms =($dms_id != '0') ? " AND sc.dms_id = '".$dms_id."' " : "" ; $state = ($state != '0') ? " AND cc.address_1_state = '$state' " : "" ; $city = ($city != '0') ? " AND cc.address_1_city = '$city' " : "" ; $customer_type = ($customer_type != '0') ? " AND c.type = '$customer_type' " : "" ; $customer_category = ($customer_category != '0') ? " HAVING customer_category = '$customer_category' " : "" ; $customer_status = ($customer_status != '0') ? " ".(($customer_category != '0') ? " AND " : " HAVING " )." isActive = '$customer_status' " : "" ; //default $brand = ($brand != '0') ? " AND v.brand_id = '$brand' " : "" ; $model = ($model != '0') ? " AND v.model_id = '$model' " : "" ; $variant = ($variant != '0') ? " AND v.model_variant_description = '$variant' " : ""; $complete_data = ""; $incomplete_data = ""; $mobile_phone_1 = ""; $email_1 = ""; $address_1 = ""; $date_of_birth =""; if(isNotEmpty($customer_data) && $customer_data != '0'){ switch($customer_data){ case "Complete Data": $complete_data = " AND ((c.date_of_birth <> '' and ag.id <> 0 and cc.address_1 <> '' and cc.email_1 <> '' and cc.mobile_phone_1 <> '') AND c.type = 1) OR (cc.address_1 <> '' AND cc.email_1 <> '' AND c.type = 2) "; break; case "Incomplete Data": $incomplete_data = " AND ((c.date_of_birth = '' OR ag.id = 0 OR cc.address_1 = '' OR cc.email_1 = '') AND c.type = 1) OR (cc.address_1 = '' or cc.email_1 = '' AND c.type = 2) "; break; case "No Mobile": $mobile_phone_1 = " AND cc.mobile_phone_1 = '' "; break; case "No Email": $email_1 = " AND cc.email_1 = '' "; break; case "No Address": $address_1 = " AND cc.address_1 = '' "; break; case "No Gender": $gender = " AND ag.gender_id = '0' AND c.type = '1' "; break; case "No Date of birth": $date_of_birth = " AND c.date_of_birth = '' AND c.type = '1' "; break; } } // $insurance_company = ($insurance_company_id != '0') ? " AND (s.insurance_company_id = '$insurance_company_id') " : "" ; // $insurance_type = ($insurance_type_id != '0') ? " AND (s.insurance_type_id = '$insurance_type_id') " : "" ; // $finance_company = ($finance_company_id != '0') ? " AND (s.finance_company_id = '$finance_company_id') " : "" ; if(isNotEmpty($date_of_birth) && isNotEmpty($date_of_birth)){ $filter_dob = " AND c.date_of_birth = '$date_of_birth' "; }else{ $filter_dob = ""; } switch(intval($sort_by)){ case 1: //lastname $filter_sort_by = " c.last_name "; break; case 2: //firstname $filter_sort_by = " c.first_name "; break; case 3: //corporation name $filter_sort_by = " c.corporation_name "; break; case 4: //date created $filter_sort_by = " c.date_created "; break; case 5: //date uploaded $filter_sort_by = " c.date_uploaded "; break; } $return_data = array(); $query = " SELECT %s FROM customer c INNER JOIN customer_category ccat ON c.category_id = ccat.id INNER JOIN customer_contact cc ON c.id = cc.customer_id INNER JOIN employee e ON c.upload_by = e.id INNER JOIN customer_dms cd ON c.id = cd.customer_record_id INNER JOIN source_company_dealer scd ON cd.company_dealer_id = scd.id INNER JOIN source_company sc ON scd.company_id = sc.id INNER JOIN all_gender ag ON c.gender_id = ag.id INNER JOIN all_marital_status am ON c.marital_status_id = am.id INNER JOIN all_countries ac ON c.nationality_id = ac.num_code INNER JOIN all_suffix asx ON c.suffix_id = asx.id LEFT OUTER JOIN vehicle v ON c.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 WHERE 1 %s /* upload_date / %s / date_created / %s / dms / %s / company / %s / dealer / %s / age / %s / gender / %s / state / %s / city / / %s /* upload_by / %s / complete_data / %s / incomplete_id / %s / no_address / %s / no_dob / %s / type / %s / dob / %s / brand / %s / model / / %s /* insurance_company / / %s /* insurance_type / / %s /* finance_company / AND c.status = 1 GROUP BY c.id %s %s "; // ORDER BY $filter_sort_by $order_by // LEFT OUTER JOIN source_brand sbv // ON v.brand_id=sbv.id // LEFT OUTER JOIN source_car_model scmv // ON v.model_id=scmv.id // LEFT OUTER JOIN source_brand sbs // ON s.brand_id=sbs.id // LEFT OUTER JOIN source_car_model scms // ON s.model_id=scms.id // LEFT OUTER JOIN source_brand sbse // ON se.brand_id=sbse.id // LEFT OUTER JOIN source_car_model scmse // ON se.model_id=scmse.id // IF(c.type = 1, // concat(c.first_name,' ',c.middle_name,' ',c.last_name, ' ', IF(c.suffix_id < 1, '',asx.suffix_name )) // , // c.corporation_name // ) $fields = " c.id, c.photo, c.first_name, c.last_name, asx.suffix_name AS suffix, c.corporation_name, am.name as marital_status, ag.gender_name, c.date_of_birth, 'Individual' as customer_type, c.date_uploaded, TIMESTAMPDIFF(YEAR,c.date_of_birth, CURDATE()) as age_number, c.date_created, cc.mobile_phone_1, cc.mobile_phone_2, cc.email_1, cc.email_2, cc.business_phone, cc.fax_phone, cc.residential_phone, cc.address_1, c.contact_person, ac.nationality, c.occupation, c.no_of_children, c.type, (IF( c.category_id <> 0,ccat.id, IF( COUNT(se.id) > 0 && COUNT(s.id) < 1, '1', IF( COUNT(se.id) < 1 && COUNT(s.id) > 0, '2', IF( COUNT(v.id) = 1 && COUNT(se.id) > 0 && COUNT(s.id) > 0, '3', IF( COUNT(v.id) > 1 && COUNT(v.id) < 4, '4', IF( COUNT(v.id) > 3, '5','0'/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"; $count = " ( IF( c.category_id <> 0,ccat.id, IF( COUNT(se.id) > 0 && COUNT(s.id) < 1, '1', IF( COUNT(se.id) < 1 && COUNT(s.id) > 0, '2', IF( COUNT(v.id) = 1 && COUNT(se.id) > 0 && COUNT(s.id) > 0, '3', IF( COUNT(v.id) > 1 && COUNT(v.id) < 4, '4', IF( COUNT(v.id) > 3, '5','0'/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"; // echo sprintf($query,$fields,$filter_date_upload,$filter_date_created,$dms,$company,$dealer,$filter_age,$gender,$state,$city,$filter_upload_by, $complete_data,$incomplete_data,$address_1,$date_of_birth,$customertype,$filter_dob,$brand,$model,$insurance_company,$insurance_type,$finance_company,$customercategory,$customerstatus); return; $data_list = $db->sql_query(sprintf($query,$fields,$filter_date_upload,$filter_date_created,$dms,$company,$dealer,$filter_age,$gender,$state,$city,$complete_data,$incomplete_data,$address_1,$date_of_birth,$customertype,$filter_dob,$brand,$model,$variant,$insurance_company,$insurance_type,$finance_company,$customercategory,$customerstatus)); $query_count = $db->select("SELECT COUNT(1) FROM ( ".sprintf($query,$count,$filter_date_upload,$filter_date_created,$dms,$company,$dealer,$filter_age,$gender,$state,$city,$complete_data,$incomplete_data,$address_1,$date_of_birth,$customertype,$filter_dob,$brand,$model,$insurance_company,$insurance_type,$finance_company,$customercategory,$customerstatus) ." ) as total_count"); foreach($data_list as $data){ } ?>

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