NN2026031605/app/Models/ActionLogModel.php

<?php
// +----------------------------------------------------------------------
// | LARAVEL8.0 框架 [ LARAVEL ][ RXThinkCMF ]
// +----------------------------------------------------------------------
// | 版权所有 2017~2021 LARAVEL研发中心
// +----------------------------------------------------------------------
// | 官方网站: http://www.laravel.cn
// +----------------------------------------------------------------------
// | Author: laravel开发员 <laravel.qq.com>
// +----------------------------------------------------------------------

namespace App\Models;

use App\Services\RedisService;
use Illuminate\Support\Facades\DB;

/**
 * 行为日志-模型
 * @author laravel开发员
 * @since 2020/11/10
 * Class ActionLogModel
 * @package App\Models
 */
class ActionLogModel extends BaseModel
{
    // 设置数据表
    protected $table = null;
    // 自定义日志标题
    protected static $title = '';
    // 自定义日志内容
    protected static $content = '';

    public function __construct()
    {
        // 设置表名
        $this->table = 'action_log_' . date('Y') . '_' . date('m');
        // 初始化行为日志表
        $this->initTable();
    }

    /**
     * 初始化行为日志表
     * @return string|null
     * @since 2020/11/10
     * @author laravel开发员
     */
    private function initTable()
    {
        $tbl = DB_PREFIX . $this->table;
        if (!$this->tableExists($tbl)) {
            $sql = "CREATE TABLE `lev_action_log_2026_05` (
              `id` int UNSIGNED NOT NULL COMMENT '唯一性标识',
              `username` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作人用户名',
              `method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求类型',
              `module` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模型',
              `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作方法',
              `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作页面',
              `param` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求参数(JSON格式)',
              `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志标题',
              `type` tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT '操作类型：1-后台 2-APP',
              `content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '内容',
              `ip` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP地址',
              `user_agent` varchar(360) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'User-Agent',
              `create_user` int UNSIGNED NOT NULL DEFAULT '0' COMMENT '添加人',
              `create_time` int UNSIGNED NOT NULL DEFAULT '0' COMMENT '添加时间',
              `update_user` int UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新人',
              `update_time` int UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
              `mark` tinyint UNSIGNED NOT NULL DEFAULT '1' COMMENT '有效标识：1正常 0删除'
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统行为日志表'";
            DB::select($sql);
        }
        return $tbl;
    }

    /**
     * 设置标题
     * @param $title 标题
     * @since 2020/11/10
     * @author laravel开发员
     */
    public static function setTitle($title)
    {
        self::$title = $title;
    }

    /**
     * 设置内容
     * @param $content 内容
     * @since 2020/11/10
     * @author laravel开发员
     */
    public static function setContent($content)
    {
        self::$content = $content;
    }

    /**
     * 创建行为日志
     * @author laravel开发员
     * @since 2020/11/10
     */
    public static function record()
    {
        if (!self::$title) {
            // 操作控制器名
            $menuModel = new MenuModel();
            $info = $menuModel->getOne([
                ['url', '=', request()->url()],
            ]);
            if ($info) {
                if ($info['type'] == 1) {
                    $menuInfo = $menuModel->getInfo($info['pid']);
                    self::$title = $menuInfo['title'];
                } else {
                    self::$title = $info['title'];
                }
            }
        }

        // 登录用户ID
        $userId = session('userId');
        if(empty($userId)){
            $userId = RedisService::get("caches:admin:".get_client_ip());
        }

        $userModel = new UserModel();
        $userInfo = $userModel->getInfo($userId);

        // 日志数据
        $data = [
            'username' => isset($userInfo['username']) ? $userInfo['username'] : '未知',
            'module' => 'admin',
            'action' => request()->path(),
            'method' => request()->method(),
            'url' => request()->url(true), // 获取完成URL
            'param' => request()->all() ? json_encode(request()->all()) : '',
            'title' => self::$title ? self::$title : '操作日志',
            'type' => self::$title == '登录系统' ? 1 : (self::$title == '注销系统' ? 2 : 0),
            'content' => self::$content,
            'ip' => request()->ip(),
            'user_agent' => request()->server('HTTP_USER_AGENT'),
            'create_user' => $userId? $userId : 0,
            'create_time' => time(),
        ];
        // 日志入库
        self::insert($data);
    }
}