You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
virt/web/app/Utils/SafeDatatables.php

206 lines
7.7 KiB
PHTML

<?php
namespace App\Utils;
use App\Services\AdminPermission;
use Ozdemir\Datatables\Datatables as BaseDatatables;
use Ozdemir\Datatables\DB\DatabaseInterface;
final class SafeDatatables extends BaseDatatables
{
private const DEFAULT_PAGE_SIZE = 10;
private const MAX_PAGE_SIZE = 100;
private const MAX_OFFSET = 1000000;
private const MAX_SEARCH_LENGTH = 200;
private const MAX_SEARCH_WORDS = 8;
private const MAX_ORDER_COLUMNS = 5;
protected $input = [];
private $allowAllRows;
public function __construct(DatabaseInterface $db, $allowAllRows = false)
{
$this->allowAllRows = (bool) $allowAllRows;
parent::__construct($db);
$draw = isset($this->input['draw']) && is_scalar($this->input['draw'])
? filter_var($this->input['draw'], FILTER_VALIDATE_INT)
: false;
$this->input['draw'] = $draw === false ? 0 : max(0, (int) $draw);
}
protected function filterglobal()
{
$search = $this->input('search');
$requestColumns = $this->input('columns');
$searchValue = is_array($search) && isset($search['value']) && is_scalar($search['value'])
? trim(substr((string) $search['value'], 0, self::MAX_SEARCH_LENGTH))
: '';
if ($searchValue === '' || !is_array($requestColumns) || !is_array($this->columns)) {
return null;
}
$searchValue = preg_replace('/\W+/u', ' ', $searchValue);
$words = array_slice(array_values(array_filter(explode(' ', trim((string) $searchValue)), 'strlen')), 0, self::MAX_SEARCH_WORDS);
$searchGroups = [];
foreach ($words as $word) {
$matches = [];
foreach ($this->columns as $index => $column) {
if (!$this->isRequestColumnSearchable($requestColumns, $index)
|| !$this->isSafeServerColumn($column)) {
continue;
}
if (!$this->canSearchColumn($column)) {
continue;
}
$matches[] = $column . ' LIKE binary ' . $this->db->escape($word);
}
$searchGroups[] = $matches === []
? '1 = 0'
: '(' . implode(' OR ', $matches) . ')';
}
return $searchGroups === [] ? null : implode(' AND ', $searchGroups);
}
protected function filterindividual()
{
$requestColumns = $this->input('columns');
if (!is_array($requestColumns) || !is_array($this->columns)) {
return null;
}
$matches = [];
foreach ($this->columns as $index => $column) {
$requestColumn = isset($requestColumns[$index]) ? $requestColumns[$index] : null;
$value = is_array($requestColumn)
&& isset($requestColumn['search'])
&& is_array($requestColumn['search'])
&& isset($requestColumn['search']['value'])
&& is_scalar($requestColumn['search']['value'])
? trim(substr((string) $requestColumn['search']['value'], 0, self::MAX_SEARCH_LENGTH))
: '';
if ($value === ''
|| !$this->isRequestColumnSearchable($requestColumns, $index)
|| !$this->isSafeServerColumn($column)) {
continue;
}
if (!$this->canSearchColumn($column)) {
$matches[] = '1 = 0';
continue;
}
$matches[] = $column . ' LIKE ' . $this->db->escape($value);
}
return $matches === [] ? null : ' (' . implode(' AND ', $matches) . ')';
}
protected function limit()
{
$offset = filter_var($this->input('start'), FILTER_VALIDATE_INT);
$pageSize = filter_var($this->input('length'), FILTER_VALIDATE_INT);
$offset = $offset === false ? 0 : max(0, min((int) $offset, self::MAX_OFFSET));
if ($this->allowAllRows && $pageSize === -1) {
return '';
}
$pageSize = $pageSize === false || $pageSize <= 0
? self::DEFAULT_PAGE_SIZE
: min((int) $pageSize, self::MAX_PAGE_SIZE);
return " LIMIT {$offset}, {$pageSize} ";
}
protected function orderby()
{
$requestOrders = $this->input('order');
$orders = [];
if (is_array($requestOrders) && is_array($this->columns)) {
foreach (array_slice($requestOrders, 0, self::MAX_ORDER_COLUMNS) as $requestOrder) {
if (!is_array($requestOrder)
|| !isset($requestOrder['column'])
|| !is_scalar($requestOrder['column'])) {
continue;
}
$index = filter_var($requestOrder['column'], FILTER_VALIDATE_INT);
$direction = isset($requestOrder['dir']) && is_scalar($requestOrder['dir'])
? strtolower((string) $requestOrder['dir'])
: '';
$column = $index !== false && isset($this->columns[$index]) ? $this->columns[$index] : null;
if (!$this->isSafeServerColumn($column)
|| !$this->canSearchColumn($column)
|| !in_array($direction, ['asc', 'desc'], true)) {
continue;
}
$orders[] = $column . ' ' . $direction;
}
}
if ($orders !== []) {
return ' ORDER BY ' . implode(', ', $orders);
}
if ($this->hasOrderIn) {
return null;
}
foreach ((array) $this->columns as $column) {
if ($this->isSafeServerColumn($column) && $this->canSearchColumn($column)) {
return ' ORDER BY ' . $column . ' asc';
}
}
return null;
}
private function isRequestColumnSearchable(array $requestColumns, $index)
{
return isset($requestColumns[$index])
&& is_array($requestColumns[$index])
&& isset($requestColumns[$index]['searchable'])
&& is_scalar($requestColumns[$index]['searchable'])
&& (string) $requestColumns[$index]['searchable'] === 'true';
}
private function isSafeServerColumn($column)
{
return is_string($column) && preg_match('/^[A-Za-z_][A-Za-z0-9_]*$/', $column) === 1;
}
private function canSearchColumn($column)
{
if (AdminPermission::isSuperAdmin()) {
return true;
}
$column = strtolower((string) $column);
$exactSensitiveColumns = [
'email', 'user_email', 'user_name', 'username', 'account', 'apple_id',
'im_value', 'telegram_id', 'reg_ip', 'ip', 'ipv4', 'ipv6', 'port',
'address', 'receive_address', 'wallet_address', 'txid', 'trade_no',
'out_trade_no', 'passwd', 'password', 'token', 'key', 'secret', 'code',
'api_key_name', 'api_key_preview', 'request_ip', 'report_ip', 'user_ip',
'node_ip', 'access_addr', 'payment_account', 'zhifubao', 'location',
'request_domain', 'request_user_agent', 'url', 'uri', 'path',
'request_path', 'request_url', 'host', 'domain', 'query', 'endpoint',
'server', 'access_host', 'info', 'page_title', 'content',
'gemini_message', 'dns_endpoints', 'dns_rule_preview', 'pass',
'nss_pass', 'nssr_pass', 'connection_password', 'applepass', 'apple_pass',
];
if (in_array($column, $exactSensitiveColumns, true)) {
return false;
}
return preg_match(
'/(^|_)(email|user_name|username|apple_id|im_value|telegram_id|passwd|password|token|secret|credential|api_key|txid|trade_no|ip|ipv4|ipv6|wallet_address|payment_account)(_|$)/',
$column
) !== 1;
}
}