Server : nginx/1.20.1
System : Linux iZ2ze9ojcl78uluczwag69Z 4.18.0-240.22.1.el8_3.x86_64 #1 SMP Thu Apr 8 19:01:30 UTC 2021 x86_64
User : www ( 1000)
PHP Version : 7.3.28
Disable Function : passthru,exec,system,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
Directory :  /www/wwwroot/0531yanglao.com/app/admin/controller/
Upload File :
Current Directory [ Writeable ] Root Directory [ Writeable ]


Current File : /www/wwwroot/0531yanglao.com/app/admin/controller/UserLog.php
<?php
/*
 * @Description  : 用户日志
 * @Author       : https://github.com/skyselang
 * @Date         : 2020-12-01
 * @LastEditTime : 2021-03-08
 */

namespace app\admin\controller;

use think\facade\Request;
use app\admin\validate\UserLogValidate;
use app\admin\service\UserLogService;
use app\admin\service\UserService;
use app\admin\service\ApiService;

class UserLog
{
    /**
     * 用户日志列表
     *
     * @method GET
     * 
     * @return json
     */
    public function userLogList()
    {
        $page            = Request::param('page/d', 1);
        $limit           = Request::param('limit/d', 10);
        $sort_field      = Request::param('sort_field/s ', '');
        $sort_type       = Request::param('sort_type/s', '');
        $log_type        = Request::param('log_type/d', '');
        $user_keyword    = Request::param('user_keyword/s', '');
        $request_keyword = Request::param('request_keyword/s', '');
        $api_keyword     = Request::param('api_keyword/s', '');
        $create_time     = Request::param('create_time/a', []);

        $where = [];
        if ($log_type) {
            $where[] = ['log_type', '=', $log_type];
        }
        if ($user_keyword) {
            $user     = UserService::etQuery($user_keyword);
            $user_ids = array_column($user, 'user_id');
            $where[]  = ['user_id', 'in', $user_ids];
        }
        if ($request_keyword) {
            $where[] = ['request_ip|request_region|request_isp', 'like', '%' . $request_keyword . '%'];
        }
        if ($api_keyword) {
            $api     = ApiService::etQuery($api_keyword);
            $api_ids = array_column($api, 'api_id');
            $where[] = ['api_id', 'in', $api_ids];
        }
        if ($create_time) {
            $where[] = ['create_time', '>=', $create_time[0] . ' 00:00:00'];
            $where[] = ['create_time', '<=', $create_time[1] . ' 23:59:59'];
        }

        $order = [];
        if ($sort_field && $sort_type) {
            $order = [$sort_field => $sort_type];
        }

        $data = UserLogService::list($where, $page, $limit, $order);

        return success($data);
    }

    /**
     * 用户日志信息
     *
     * @method GET
     * 
     * @return json
     */
    public function userLogInfo()
    {
        $param['user_log_id'] = Request::param('user_log_id/d', '');

        validate(UserLogValidate::class)->scene('user_log_id')->check($param);

        $data = UserLogService::info($param['user_log_id']);

        if ($data['is_delete'] == 1) {
            exception('用户日志已删除:' . $param['user_log_id']);
        }

        return success($data);
    }

    /**
     * 用户日志删除
     *
     * @method POST
     * 
     * @return json
     */
    public function userLogDele()
    {
        $param['user_log_id'] = Request::param('user_log_id/d', '');

        validate(UserLogValidate::class)->scene('user_log_dele')->check($param);

        $data = UserLogService::dele($param['user_log_id']);

        return success($data);
    }

    /**
     * 用户日志统计
     *
     * @method POST
     *
     * @return json
     */
    public function UserLogSta()
    {
        $type   = Request::param('type/s', '');
        $date   = Request::param('date/a', []);
        $region = Request::param('region/s', 'city');

        $data  = [];
        $dates = ['total', 'today', 'yesterday', 'thisweek', 'lastweek', 'thismonth', 'lastmonth'];

        if ($type == 'number') {
            $number = [];
            foreach ($dates as $k => $v) {
                $number[$v] = UserLogService::staNumber($v);
            }
            $data['number'] = $number;
        } elseif ($type == 'date') {
            $data['date'] = UserLogService::staDate($date);
        } elseif ($type == 'region') {
            $data['region'] = UserLogService::staRegion($date, $region);
        } else {
            $number = [];
            foreach ($dates as $k => $v) {
                $number[$v] = UserLogService::staNumber($v);
            }

            $data['number'] = $number;
            $data['date']   = UserLogService::staDate($date);
            $data['region'] = UserLogService::staRegion($date, $region);
        }

        return success($data);
    }
}