当前位置：首页 > news >正文

群控系统服务端开发模式-应用开发-业务架构逻辑开发BaseAPI继续开发一

news 2025/1/17 14:42:07

思来想去，还是加一张系统配置表，主要的作用是配置网站信息及token过期时间的。

一、添加系统配置表

1、创建表语句

CREATE TABLE `cluster_control`.`nc_param_system`  (`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',`website_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站名称',`website_describe` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站描述',`website_keyword` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站关键字',`security_password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二次密码',`checked_backend_log` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '后端Log',`website_filing_applica` varchar(250) NOT NULL COMMENT '网站备案申明',`platform_token_expira` smallint(6) UNSIGNED NULL DEFAULT 0 COMMENT '平台端token过期时间',`update_time` datetime(0) NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',PRIMARY KEY (`id`)
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置文件';

2、表结构

3、添加配置数据

INSERT INTO `cluster_control`.`nc_param_system`(`website_name`, `website_describe`, `website_keyword`, `security_password`, `checked_backend_log`, `website_filing_applica`, `platform_token_expira`, `update_time`) VALUES ('国际群控系统', '国际群控系统', '群控系统|国际群控系统', 'cX#IdvJlYX6LmYr8gR@v', 'https://yuanlong-base.oss-cn-hangzhou.aliyuncs.com/2024-04-14/c59313916105916258762d26806a158c85a6bb59.png', 'Copyright © 2028 Themepure. All Rights Reserved|群控系统|http://www.yuanlongsoftware.cn', 1800, '2024-10-29 09:49:55')

二、token数据层开发

1、系统配置数据层开发

<?php
/*** 系统配置参数数据层管理* User: 龙哥·三年风水* Date: 2024/10/29* Time: 10:20*/
namespace app\model\common;
use app\model\Tools;
use Redis\Redis;
class ParamSystem extends Tools
{protected static $name = 'param_system';protected static $connection = 'mysql';protected $pk = 'id';protected static $unsetField = ['update_time','create_time','status'];//获取单条数据public static function dataFind($where = [], $field='*', $unsetField=[]){$fieldL = 0; //预防字段少于数据库字段等情况下,加入等级进行区分。保障Redis存储最高性if($field == '*'){$res = Redis::select(config('cache.stores.redis.other_db'))->hgetall('param_system1');}else{$res = Redis::select(config('cache.stores.redis.other_db'))->hmget('param_system1',explode(',',$field));}foreach($res as $v){if(empty($v)){$fieldL = 1;break;}}if($fieldL === 1){$fields = $field;if($fieldL === 1)$fields = '*';$res = self::dataFinds(self::$name, $where, $fields, true,self::$connection);if(count($unsetField) > 0){//如果单独添加过滤数据,则优先并入数据foreach($unsetField as $v){array_push(self::$unsetField,$v);}}if(!empty(self::$unsetField)){//主动过滤修改时间等状态foreach(self::$unsetField as $v){if(isset($res[$v]))unset($res[$v]);}}//过滤好了之后存入RedisRedis::select(config('cache.stores.redis.other_db'))->hmset('param_system1',$res);}if($field != '*'){//根据需要,将需要的字段过滤返回$data = [];$list = explode(',',$field);foreach($list as $k=>$v){if($fieldL === 1){$data[$v] = $res[$v];}else{$data[$v] = $res[$k];}}$res = $data;}return  $res;}//保存数据public static function save($data, $where = [], $unsetField=[]){self::dataSaves(self::$name, $data, $where, self::$connection);if(count($unsetField) > 0){//如果单独添加过滤数据,则优先并入数据foreach($unsetField as $v){array_push(self::$unsetField,$v);}}if(count(self::$unsetField) > 0){//主动过滤修改时间等状态foreach(self::$unsetField as $v){if(isset($data[$v]))unset($data[$v]);}}//过滤好了之后存入RedisRedis::select(config('cache.stores.redis.other_db'))->hmset('param_system1',$data);}
}

2、管理员数据层开发

<?php
/*** 管理员数据控制* User: 龙哥·三年风水* Date: 2024/10/29* Time: 10:26*/
namespace app\model\permission;
use app\model\Tools;
class Admin extends Tools
{protected static $name = 'permission_admin';protected static $connection = 'mysql';protected $pk = 'id';protected static $unsetField = ['update_time','create_time'];//获取分页数据public static function getRedisList($where = [], $limit = []){return self::dataRedisLists(self::$name, $where, $limit, self::$connection);}//获取所有数据public static function getAll($where = [], $field = '*', $order = '', $join = []){return self::dataAlls(self::$name, $where, $field, $order, $join, self::$connection);}//获取单条数据public static function dataFind($where = [], $field, $findType = true){return self::dataFinds(self::$name, $where, $field, $findType, self::$connection);}//保存数据public static function redisSave($data, $pk = ''){return self::dataRedisSaves(self::$name, $data, $pk, self::$connection);}//删除数据 -- 带图片的public static function dataDetele($pk){self::dataRedisDeteles(self::$name, $pk, self::$connection);}
}

3、token数据层开发

<?php
/*** 登录用户数据管理* User: 龙哥 三年风水* Date: 2024/10/29* Time: 10:26*/
namespace app\model\common;
use app\model\Tools;
use Redis\Redis;
use app\model\common\ParamSystem as SystemModel;
use app\model\permission\Admin;
class Token extends Tools
{protected static $name = 'permission_token';protected static $connection = 'mysql';protected $pk = 'token';//查询列表public static function dataList($where,$field,$limit,$order){return self::dataLists(self::$name, $where, $field, $limit, $order, [], self::$connection);}public static function dataFind($where = [], $field, $findType = true){return self::dataFinds(self::$name, $where, $field, $findType, self::$connection);}//保存数据public static function save($data, $where = []){return self::dataSaves(self::$name, $data, $where, self::$connection);}//修改token整个状态public static function setToken($token, $attack, $clientIp){$data['admin_id'] = 0;$data['username'] = '';$data['avatar'] = '';$data['realname'] = '';$data['email'] = '';$data['ip'] = '';$data['department_id'] = 0;$data['grade_id'] = 0;$data['role_id'] = 0;$redisToken = Redis::select(config('cache.stores.redis.token_db'))->get('token_'.$token);if(empty($redisToken))return array('status' => false, 'info' => 'token已经过期咯,请重新登录!', 'data' => $data);//获取系统配置的过期时间$systemParam = SystemModel::dataFind(['id' => 1],'platform_token_expira');//验证是否跨站攻击$attackToken = Redis::select(config('cache.stores.redis.token_db'))->get('token_' . $redisToken);if(!empty($attackToken)){if ($attackToken === $attack){//如果传过来加密后的token与Redis里面记录的一样，就禁止访问、延长过期时间并加入黑名单Redis::select(config('cache.stores.redis.token_db'))->expire('token_'.$token, $systemParam['platform_token_expira']);//加入黑名单Redis::select(config('cache.stores.redis.default_db'))->sadd('black-list', $clientIp);return array('status' => false, 'info' => '跨站攻击', 'data' => $data);}}Redis::select(config('cache.stores.redis.token_db'))->expire('token_'.$token, $systemParam['platform_token_expira']);Redis::select(config('cache.stores.redis.token_db'))->setex('token_' . $redisToken, $systemParam['platform_token_expira'], serialize($attack));$resAdminFind = Admin::dataFind(['id' => $redisToken], 'username,avatar,realname,email,ip,department_id,grade_id,role_id,status',true);if ($resAdminFind['status'] !== 1) return array('status' => false, 'info' => '该用户已被禁用', 'data' => $data);$data['admin_id'] = $redisToken;$data['username'] = $resAdminFind['username'];$data['avatar'] = $resAdminFind['avatar'];$data['realname'] = $resAdminFind['realname'];$data['email'] = $resAdminFind['email'];$data['ip'] = $resAdminFind['ip'];$data['department_id'] = $resAdminFind['department_id'];$data['grade_id'] = $resAdminFind['grade_id'];$data['role_id'] = $resAdminFind['role_id'];return array('status' => true, 'info' => '', 'data' => $data);}
}