File manager

File manager - Edit - /home/autoph/public_html/connectv1/app/report/report_information.php

Back
<?php include_once("../../cfg/db.php"); $record_id = $db -> escape(trim($_POST['record_id'])); $query_all_info = "SELECT r.`id`, r.employee_id, r.report_type_id, r.`control_number`, r.`description`, r.`company_id`, r.`dealer_id`, r.`state_id`, r.`city_id`, DATE_FORMAT(r.report_date, '%M %d, %Y') as report_date, TIME_FORMAT(r.report_time, '%h:%i %p') as report_time, r.`upload_by_employee_id`, r.`customer_type`, r.`age_from`, r.`age_to`, r.`gender_id`, r.`customer_data_type`, r.`dms_id`, r.`activity_date_from`, r.`activity_date_to`, r.`uploaded_date_from`, r.`uploaded_date_to`, r.`expire`, concat(e.employee_id, ' - ',e.first_name,' ',e.last_name) as request_by_user , r.brand_id, r.model_id, r.sort_by, r.order_by, r.is_downloadable, r.date_of_birth, r.customer_category, r.customer_status, r.finance_company_id, r.insurance_company_id, r.insurance_type_id FROM `report` r INNER JOIN employee e ON r.employee_id=e.id WHERE r.`id` = '$record_id'"; // echo $query_all_info; return; $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['description'] = $data['description']; $return_arr['company_id'] = $data['company_id']; $return_arr['dealer_id'] = $data['dealer_id']; $return_arr['state_id'] = $data['state_id']; $return_arr['city_id'] = $data['city_id']; $return_arr['report_date'] = $data['report_date'] . ' - ' .$data['report_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['gender_id'] = $data['gender_id']; $return_arr['customer_data_type'] = $data['customer_data_type']; $return_arr['dms_id'] = $data['dms_id']; $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['request_by_user'] = $data['request_by_user']; $return_arr['expire'] = $data['expire']; $return_arr['brand_id'] = $data['brand_id']; $return_arr['model_id'] = $data['model_id']; $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_company_id'] = $data['insurance_company_id']; $return_arr['finance_company_id'] = $data['finance_company_id']; } 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 `report_status` rs INNER JOIN employee e ON rs.employee_id = e.id WHERE rs.report_id = '$record_id' ORDER BY rs.date ASC"); $approver_table = ""; while($row = $list_query->fetch_assoc()) { $report_status = '<span style=\'color:orange;\'><strong>Pending</strong></span>'; switch("".$row['status'].""){ case '0': $report_status = '<span style=\'color:orange;\'><strong>Pending</strong></span>'; break; case '1': $report_status = '<span style=\'color:green;\'><strong>Approved</strong></span>'; break; case '2': $report_status = '<span style=\'color:red;\'><strong>Declined</strong></span>'; break; } $approver_table = $approver_table . " <tr> <td>".$row['name']."</td> <td>".$report_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 DATEDIFF(r.expire,NOW()) < 0),'3', IF( (SELECT count(id) FROM `report_status` WHERE report_id = r.id AND `status` = 2) = 0 , IF( (SELECT count(id) FROM `report_status` WHERE report_id = r.id AND `status` = 0) = 0 , '1', '0' ), '2' ) ) ) as status FROM `report`r INNER JOIN report_type rt ON r.report_type_id = rt.id WHERE r.id = '$record_id' "; $report_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 `record_id` = '$record_id' "); } $return_arr['report_status'] = $report_status; $return_arr['approver_list'] = $approver_table; // 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.02 | proxy | phpinfo | Settings