File manager

File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/sms_service/sms_service_information.php

Back
<?php include_once("../../cfg/db.php"); $request_id = $db -> escape(trim($_POST['request_id'])); $query_all_info = "SELECT tb.`id`, tb.employee_id, tb.`control_number`, tb.`message_content`, tb.`char_count`, tb.`company_id`, tb.`dealer_id`, tb.`state_id`, a_state.provDesc AS state, tb.`city_id`, a_city.citymunDesc AS city, DATE_FORMAT(tb.request_date, '%M %d, %Y') AS request_date, TIME_FORMAT(tb.request_time, '%h:%i %p') AS request_time, tb.`description`, tb.`upload_by_employee_id`, tb.`customer_type`, tb.`age_from`, tb.`age_to`, tb.`gender_id`, a_gender.gender_name AS gender, tb.`customer_data_type`, tb.`dms_id`, s_dms.name AS dms, tb.`activity_date_from`, tb.`activity_date_to`, tb.`uploaded_date_from`, tb.`uploaded_date_to`, tb.`expire`, concat(e.employee_id, ' - ', e.first_name, ' ', e.last_name) AS request_by_user , tb.brand_id, sb.name AS brand, tb.model_id, scm.name AS model, tb.variant_id, scmv.name AS variant, tb.sort_by, tb.order_by, tb.customer_status, tb.is_downloadable, tb.date_of_birth, tb.customer_category, c_cat.name AS customer_category, tb.customer_status, tb.finance_company_id, sfc.name AS finance_company, tb.insurance_company_id, sic.name AS insurance_company, tb.insurance_type_id, sit.name AS insurance_type FROM `text_blast` tb INNER JOIN employee e ON tb.employee_id=e.id /* employee / INNER JOIN source_brand sb ON tb.brand_id=sb.id / brand / INNER JOIN source_car_model scm ON tb.model_id=scm.id / model / INNER JOIN source_car_model_variant scmv ON tb.variant_id=scmv.id / variant / INNER JOIN source_insurance_company sic ON tb.insurance_company_id=sic.id / insurance company / INNER JOIN source_insurance_type sit ON tb.insurance_type_id=sit.id / insurance type / INNER JOIN source_finance_company sfc ON tb.finance_company_id=sfc.id / finance_company / LEFT OUTER JOIN all_state a_state ON tb.state_id=a_state.provCode / state / LEFT OUTER JOIN all_city a_city ON tb.city_id=a_city.id / city / INNER JOIN all_gender a_gender ON tb.gender_id=a_gender.id / gender / INNER JOIN customer_category c_cat ON tb.customer_category=c_cat.id / customer_category / INNER JOIN source_dms s_dms ON tb.dms_id=s_dms.id / source_dms / WHERE tb.`id` = '$request_id'"; // echo $query_all_info; return; // / INNER JOIN source_brand sb ON tb.brand_id=sb.id /* brand / // / INNER JOIN source_car_model scm ON tb.model_id=scm.id /* model / // / INNER JOIN source_car_model_variant scmv ON tb.variant_id=scmv.id /* variant / // / INNER JOIN source_insurance_company sic ON tb.insurance_company_id=sic.id /* insurance company / // / INNER JOIN source_insurance_type sit ON tb.insurance_type_id=sit.id /* insurance type / // / INNER JOIN source_finance_company sfc ON tb.finance_company_id=sfc.id /* finance_company / // / INNER JOIN all_state a_state ON tb.state_id=a_state.provCode /* state / // / INNER JOIN all_city a_city ON tb.city_id=a_city.id /* city / // / INNER JOIN all_gender a_gender ON tb.gender_id=a_gender.id /* gender / // / INNER JOIN customer_category c_cat ON tb.customer_category=c_cat.id /* customer_category / // / INNER JOIN source_dms s_dms ON tb.dms_id=s_dms.id /* source_dms / $info = $db -> return_result($query_all_info); $employee_id_uploader = ""; $upload_by_name = ""; foreach($info AS $data){ $return_arr['id'] = $data['id']; $return_arr['employee_id'] = $data['employee_id']; //$return_arr['report_type_id'] = $data['report_type_id']; $return_arr['control_number'] = strtoupper($data['control_number']); $return_arr['message_content'] = str_replace("\\n", "\n", $data['message_content']); $return_arr['char_count_db'] = $data['char_count']; $return_arr['company_id'] = $data['company_id']; $return_arr['dealer_id'] = $data['dealer_id']; $return_arr['state_id'] = $data['state_id']; $return_arr['state'] = $data['state']; $return_arr['city_id'] = $data['city_id']; $return_arr['city'] = $data['city']; $return_arr['request_date'] = $data['request_date'] . ' - ' .$data['request_time']; //$return_arr['report_time'] = $data['report_time']; $employee_id_uploader = $data['upload_by_employee_id']; $return_arr['customer_type'] = $data['customer_type']; $return_arr['customer_status'] = $data['customer_status']; $return_arr['gender_id'] = $data['gender_id']; $return_arr['gender'] = $data['gender']; $return_arr['customer_data_type'] = $data['customer_data_type']; $return_arr['dms_id'] = $data['dms_id']; $return_arr['dms'] = $data['dms']; $return_arr['activity_date_from'] = $data['activity_date_from']; $return_arr['activity_date_to'] = $data['activity_date_to']; $return_arr['uploaded_date_from'] = $data['uploaded_date_from']; $return_arr['uploaded_date_to'] = $data['uploaded_date_to']; $return_arr['age_from'] = $data['age_from']; $return_arr['age_to'] = $data['age_to']; $return_arr['description'] = $data['description']; $return_arr['request_by_user'] = $data['request_by_user']; $return_arr['expire'] = $data['expire']; $return_arr['brand_id'] = $data['brand_id']; $return_arr['brand'] = $data['brand']; $return_arr['model_id'] = $data['model_id']; $return_arr['model'] = $data['model']; $return_arr['variant_id'] = $data['variant_id']; $return_arr['variant'] = $data['variant']; $return_arr['sort_by'] = $data['sort_by']; $return_arr['order_by'] = $data['order_by']; $return_arr['is_downloadable'] = $data['is_downloadable']; $return_arr['date_of_birth'] = $data['date_of_birth']; $return_arr['customer_category'] = $data['customer_category']; $return_arr['customer_status'] = $data['customer_status']; $return_arr['insurance_type_id'] = $data['insurance_type_id']; $return_arr['insurance_type'] = $data['insurance_type']; $return_arr['insurance_company_id'] = $data['insurance_company_id']; $return_arr['insurance_company'] = $data['insurance_company']; $return_arr['finance_company_id'] = $data['finance_company_id']; $return_arr['finance_company'] = $data['finance_company']; } if(isNotEmpty($employee_id_uploader)){ $upload_by_name = $db -> select("SELECT concat(e.employee_id, ' - ',e.first_name,' ',e.last_name) as name FROM `employee` e WHERE e.id = '$employee_id_uploader' "); } $return_arr['upload_by_employee_id'] = $upload_by_name; if($return_arr['company_id'] != 0 ){ $return_arr['company_id'] = $db -> select("SELECT concat(code, ' - ',name) as name FROM `source_company` WHERE id = '".$return_arr['company_id']."' "); }else{ $return_arr['company_id'] = "All"; } if($return_arr['dealer_id'] != 0 ){ $return_arr['dealer_id'] = $db -> select("SELECT concat(code, ' - ',name) as name FROM `source_dealer` WHERE id = '".$return_arr['dealer_id']."' "); }else{ $return_arr['dealer_id'] = "All"; } if($return_arr['model_id'] != 0 ){ $return_arr['model_id'] = $db -> select("SELECT name FROM `source_car_model` WHERE id = '".$return_arr['model_id']."' "); }else{ $return_arr['model_id'] = "All"; } $current_user_employee_id = $_SESSION['user']['id']; $return_arr['current_user_status'] = false; $list_query = $db -> sql_query("SELECT e.id,concat(e.employee_id, ' - ',e.first_name,' ',e.last_name) as name, rs.`status`,DATE_FORMAT(date,'%M %d, %Y - %h:%i %p') as date, rs.`notes` FROM `request_status` rs INNER JOIN employee e ON rs.employee_id = e.id WHERE rs.request_id = '$request_id' ORDER BY rs.date ASC"); $approver_table = ""; while($row = $list_query->fetch_assoc()) { $request_status = '<span style=\'color:blue;\'><strong>Closed</strong></span>'; switch("".$row['status'].""){ case '0': $request_status = '<span style=\'color:orange;\'><strong>Pending</strong></span>'; break; case '1': $request_status = '<span style=\'color:green;\'><strong>Approved</strong></span>'; break; case '2': $request_status = '<span style=\'color:red;\'><strong>Declined</strong></span>'; break; case '4': $request_status = '<span style=\'color:orange;\'><strong>Suggested edit(s)</strong></span>'; break; } $approver_table = $approver_table . " <tr> <td>".$row['name']."</td> <td>".$request_status."</td> <td>".$row['date']."</td> <td>".$row['notes']."</td> </tr> "; if($row['id'] == $current_user_employee_id){ if($row['status'] != 0){ $return_arr['current_user_status'] = true; } } } $employee_query = "SELECT ( IF((SELECT count(id) FROM `request_status` WHERE request_id = id AND `status` = 4) = 0, '4' , IF((SELECT count(id) FROM `request_status` WHERE request_id = id AND `status` = 2) = 0, IF((SELECT count(id) FROM `request_status` WHERE request_id = id AND `status` = 0) = 0, '1' , '0' ) , '2' ) ) ) as status FROM `text_blast` tb /INNER JOIN report_type rt ON r.report_type_id = rt.id */ WHERE tb.id = '$request_id'"; $request_status = $db->select($employee_query); if(isset($_POST['params_generate_by_employee_id']) && isset($_POST['params_employee_id'])){ $params_generate_by_employee_id = $db -> escape(trim($_POST['params_generate_by_employee_id'])); $params_employee_id = $db -> escape(trim($_POST['params_employee_id'])); $db->sql_query("UPDATE notification_list SET status = 1 WHERE employee_id = '$params_employee_id' AND generate_by_employee_id = '$params_generate_by_employee_id' AND `request_id` = '$request_id' "); } $return_arr['request_status'] = $request_status; $return_arr['approver_list'] = $approver_table; // setup Edit button $count_declined = $db->select("SELECT COUNT(id) FROM `request_status` WHERE `request_id` = '$request_id' AND `status` = 2"); $count_id = $db->select("SELECT COUNT(id) FROM `request_status` WHERE `request_id` = '$request_id'"); $count_approved = $db->select("SELECT COUNT(id) FROM `request_status` WHERE `request_id` = '$request_id' AND `status` = 1"); $count_suggest = $db->select("SELECT COUNT(id) FROM `request_status` WHERE `request_id` = '$request_id' AND `status` = 4"); $count_closed = $db->select("SELECT COUNT(id) FROM `request_status` WHERE `request_id` = '$request_id' AND `status` = 3"); $return_arr['count_declined'] = $count_declined; $return_arr['count_id'] = $count_id; $return_arr['count_approved'] = $count_approved; $return_arr['count_suggest'] = $count_suggest; $return_arr['count_closed'] = $count_closed; // echo $return_arr['customer_data_type'];exit; echo json_encode($return_arr); function isNotEmpty($data){ return preg_match('/\S/', $data); } ?>

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