выборка логов действий
Подробнее...
См. исходные тексты.
|
| $table_name = basename($request) |
|
| $columns = ['id', 'user_id', 'request', 'text', 'date_created', 'ip'] |
|
| $order_column = isset($_GET['order'][0]['column']) && isset($columns[$_GET['order'][0]['column']]) ? $columns[$_GET['order'][0]['column']] : $columns[0] |
|
| $order_dir = isset($_GET['order'][0]['dir']) && $_GET['order'][0]['dir'] == 'asc' ? 'ASC' : 'DESC' |
|
| $start = abs(intval($_GET['start'])) |
|
| $length = intval($_GET['length']) |
|
| $query = "SELECT " . implode(', ', $columns) . " FROM `$table_name` ORDER BY `$order_column` $order_dir" |
|
| $sth = $dbh->prepare($query) |
|
| $arr = $sth->fetchAll(PDO::FETCH_NUM) |
|
| $arr_filtered = $arr |
|
if(!empty($_GET['search']['value'])) | $response_arr = array_slice($arr_filtered, $start, $length) |
|
| $hide_ip = !$user->access()->action(24) |
|
foreach($response_arr as $key=> $item) | $response = [] |
|
| $response ['recordsTotal'] = count($arr) |
|
| $response ['recordsFiltered'] = $response['recordsTotal'] |
|
| $response ['recordsFiltered'] = count($arr_filtered) |
|
| $response ['data'] = $response_arr |
|
| $response ['draw'] = abs(intval($_GET['draw'])) |
|
выборка логов действий
См. определение в файле logs.php
◆ $arr
$arr = $sth->fetchAll(PDO::FETCH_NUM) |
◆ $arr_filtered
◆ $columns
$columns = ['id', 'user_id', 'request', 'text', 'date_created', 'ip'] |
◆ $hide_ip
$hide_ip = !$user->access()->action(24) |
◆ $length
$length = intval($_GET['length']) |
◆ $order_column
$order_column = isset($_GET['order'][0]['column']) && isset($columns[$_GET['order'][0]['column']]) ? $columns[$_GET['order'][0]['column']] : $columns[0] |
◆ $order_dir
$order_dir = isset($_GET['order'][0]['dir']) && $_GET['order'][0]['dir'] == 'asc' ? 'ASC' : 'DESC' |
◆ $query
$query = "SELECT " . implode(', ', $columns) . " FROM `$table_name` ORDER BY `$order_column` $order_dir" |
◆ $response [1/6]
foreach ( $response_arr as $key=> $item) $response = [] |
◆ $response [2/6]
$response[ 'data'] = $response_arr |
◆ $response [3/6]
$response[ 'draw'] = abs(intval($_GET['draw'])) |
◆ $response [4/6]
$response[ 'recordsFiltered'] = $response['recordsTotal'] |
◆ $response [5/6]
$response[ 'recordsFiltered'] = count($arr_filtered) |
◆ $response [6/6]
$response[ 'recordsTotal'] = count($arr) |
◆ $response_arr
if (!empty( $_GET[ 'search'][ 'value'])) $response_arr = array_slice($arr_filtered, $start, $length) |
◆ $start
$start = abs(intval($_GET['start'])) |
◆ $sth
$sth = $dbh->prepare($query) |
◆ $table_name
$table_name = basename($request) |