File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/table/customer_activity.php
Back
<?php include_once("../../cfg/db.php"); include_once("../../api/controllers/utility.php"); $utility = new Utility(); // $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; $search = ""; $offset = ""; $order = "DESC"; $sort = "id"; if (isset($_GET['search'])) { $search = $db->escape(trim($_GET['search'])); } if (isset($_GET['offset'])) { $offset = $db->escape(trim($_GET['offset'])); } if (isset($_GET['limit'])) { $limit = $db->escape(trim($_GET['limit'])); $offset_limit = " LIMIT " . $offset . "," . $limit; } else { $offset_limit = ""; } if (isset($_GET['order'])) { $order = (trim($_GET['order'])); } if (isset($_GET['sort'])) { $sort = (trim($_GET['sort'])); } if (isset($_GET['customer_id'])) { $customer_id = $db->escape(trim($_GET['customer_id'])); } if (isset($_GET['vehicle_id'])) { $vehicle_id = $db->escape(trim($_GET['vehicle_id'])); } $customer_where = empty($_GET['customer_id']) ? "" : " AND customer_id = '" . $_GET['customer_id'] . "' "; $vehicle_where = empty($_GET['vehicle_id']) ? "" : " AND vehicle_id = '" . $_GET['vehicle_id'] . "' "; $json_arr['rows'] = array(); $activity_query = " SELECT %s FROM `customer_activities` aal LEFT OUTER JOIN employee e ON aal.`user_id` = e.id WHERE 1 %s %s ORDER BY %s %s "; $count = " count(1) "; $fields = " aal.*, CONCAT(e.first_name,' ',e.last_name) as user"; // echo sprintf($activity_query, $fields, $customer_where, $vehicle_where, $sort, $order) . " $offset_limit"; // exit; $activity_list_query = $db->sql_query(sprintf($activity_query, $fields, $customer_where, $vehicle_where, $sort, $order) . " $offset_limit"); $activity_list_query_count = $db->select(sprintf($activity_query, $count, $customer_where, $vehicle_where, $sort, $order)); while ($row = $activity_list_query->fetch_assoc()) { $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id' => $row['id'], 'created_at' => date("F d, Y h:iA", strtotime($row['created_at'])), 'activity' => $row['activity'], 'user' => $row['user'], ))); } $json_arr['total'] = intval($activity_list_query_count); //total number of result echo json_encode($json_arr);
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings