Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure you want to rename?
SAFE MODE
/
application
/
views
/
admin
/
tables
:
ticket_pipe_log.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php defined('BASEPATH') or exit('No direct script access allowed'); $aColumns = [ 'name', 'date', 'email_to', 'email', 'subject', 'message', 'status', ]; $sWhere = []; if ($this->ci->input->post('activity_log_date')) { array_push($sWhere, 'AND date LIKE "' . $this->ci->db->escape_like_str(to_sql_date($this->ci->input->post('activity_log_date'))) . '%" ESCAPE \'!\''); } $sIndexColumn = 'id'; $sTable = db_prefix().'tickets_pipe_log'; $result = data_tables_init($aColumns, $sIndexColumn, $sTable, [], $sWhere); $output = $result['output']; $rResult = $result['rResult']; foreach ($rResult as $aRow) { $row = []; for ($i = 0; $i < count($aColumns); $i++) { $_data = $aRow[$aColumns[$i]]; if ($aColumns[$i] == 'date') { $_data = _dt($_data); } elseif ($aColumns[$i] == 'message') { $_data = mb_substr($_data, 0, 800); } $row[] = $_data; } $output['aaData'][] = $row; }