| Server IP : 38.190.208.107 / Your IP : 216.73.217.46 Web Server : nginx/1.28.1 System : Linux ht2026040333114 6.1.0-10-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.37-1 (2023-07-03) x86_64 User : root ( 0) PHP Version : 8.2.28 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv,eval,assert,passthru,system,exec,shell_exec,popen,proc_open MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /www/wwwroot/wp.3/wp-content/plugins/wp-statistics/src/Models/ |
Upload File : |
<?php
namespace WP_Statistics\Models;
use WP_Statistics\Abstracts\BaseModel;
use WP_Statistics\Utils\Query;
class ExclusionsModel extends BaseModel
{
public function countExclusions($args = [])
{
$args = $this->parseArgs($args, [
'date' => '',
'reason' => ''
]);
$result = Query::select(['SUM(count) as count'])
->from('exclusions')
->where('reason', '=', $args['reason'])
->whereDate('date', $args['date'])
->orderBy('date')
->getVar();
return $result ?? 0;
}
public function getExclusions($args = [])
{
$args = $this->parseArgs($args, [
'date' => '',
'reason' => '',
'exclusion_id' => '',
'per_page' => '',
'page' => 1,
'order_by' => 'count',
'order' => 'DESC',
'group_by' => 'reason',
]);
$result = Query::select([
'reason',
'date',
'SUM(count) as count'
])
->from('exclusions')
->where('reason', '=', $args['reason'])
->where('id', '=', $args['exclusion_id'])
->whereDate('date', $args['date'])
->perPage($args['page'], $args['per_page'])
->groupBy($args['group_by'])
->orderBy($args['order_by'], $args['order'])
->getAll();
return $result;
}
}