Uninote
Uninote
用户根目录
README
发布文档
迭代10发布文档
迭代8.5发布文档
迭代8发布文档
迭代9发布文档
商城项目
消息群推
环境开关参数
逻辑梳理
一些接口流程
初始化权证相关
工作周报
2020-10
第3周
第4周
2020-11
第1周
第2周
第3周
第4周
2020-12
第1周
第2周
第3周
第4周
第5周
2021-01
第1周
第2周
第3周
第4周
2021-02
第1周
工具相关
bcompare环境变量
logviewer使用
powder使用
朋友圈项目
关联代码片段
数据库
模块接口
视频上传
需求迭代相关
sprint8.5需求逻辑

迭代8.5发布文档

发布时间： 更新时间：

迭代10发布文档

迭代8发布文档

客户端配置文件修改

配置文件路径：项目（dajx_api）内文件相对路径config/__params.php

关联任务：416-短信通知派单员

在AliyunSMS阿里云短信配置里增加了2个字段，分别为对应的短信模板和固定的发送号码

'AliyunSMS' => [
        //派单退款短信
        'TemplateOrder_dispatch' => 'SMS_205467833',
        //固定的运营人员发送号码
        'SendPhone_dispatch'=>'17729830159'
    ]

邀请二维码

加表-库dajx_api

CREATE TABLE `invite_qrcode` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `invite_code` varchar(10) NOT NULL DEFAULT '' COMMENT '邀请码',
  `qrcode_url` varchar(255) NOT NULL DEFAULT '' COMMENT '邀请二维码链接',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id',
  `scan_num` int(11) NOT NULL DEFAULT 0 COMMENT '扫码次数',
  `bind_time` int(11) NOT NULL DEFAULT 0 COMMENT '绑定时间',
  `time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `index_user_id` (`user_id`),
  KEY `index_code` (`invite_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='邀请二维码表';

加菜单-库dajx_api

INSERT INTO `menu` (`pid`, `title`, `payload`) VALUES ('700', '邀请二维码', '/admin/invite_qrcode/index.html');

加权限-库biglove

INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('0', '推荐二维码首页', '/admin/invite_qrcode/index.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('0', '推荐二维码添加', '/admin/invite_qrcode/add.html');
INSERT INTO `access` (`pid`, `title`, `urls`) VALUES ('0', '推荐二维码导出', '/admin/invite_qrcode/download.html');

虚拟拨号

加表-库dajx_api

CREATE TABLE `virtual_phone` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单id',
  `user_phone` varchar(15) NOT NULL DEFAULT '' COMMENT '用户的手机号',
  `staff_phone` varchar(15) NOT NULL DEFAULT '' COMMENT '员工的手机号',
  `x_phone` varchar(15) NOT NULL DEFAULT '' COMMENT '中间号',
  `sub_id` varchar(30) NOT NULL DEFAULT '' COMMENT '绑定关系id',
  `time` int(11) NOT NULL DEFAULT 0 COMMENT '绑定时间',
  `release_time` int(11) NOT NULL DEFAULT 0 COMMENT '过期时间',
  `call_start_time` int(11) NOT NULL DEFAULT 0 COMMENT '主叫拨打时间',
  `call_end_time` int(11) NOT NULL DEFAULT 0 COMMENT '通话结束时间',
  `call_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '呼叫类型（0未打电话，1用户给员工打，2员工给用户打）',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0默认表示绑定成功，1已经释放）',
  `call_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '拨打状态（0未播打，1正在打，2已打过包含未接和已接）0和2都是定时释放的条件',
  `update_time` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `index_oid_phone` (`order_id`,`user_phone`,`staff_phone`) USING BTREE,
  KEY `index_subs_id` (`sub_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='绑定虚拟号码';

权限整理

库biglove

先添加分类 按顺序执行，对应添加成功后获取到对应的id，再来操作下面的归属分类

--必须按照顺序操作
INSERT INTO access(pid,title,urls) VALUES(0,'订单中心','');--249
INSERT INTO access(pid,title,urls) VALUES(0,'用户中心','');--250
INSERT INTO access(pid,title,urls) VALUES(0,'服务中心','');--251
INSERT INTO access(pid,title,urls) VALUES(0,'营销中心','');--252
INSERT INTO access(pid,title,urls) VALUES(0,'系统设置','');--253
INSERT INTO access(pid,title,urls) VALUES(0,'分享中心','');--254
INSERT INTO access(pid,title,urls) VALUES(0,'优惠券中心','');--255
INSERT INTO access(pid,title,urls) VALUES(0,'其他配置','');--256
INSERT INTO access(pid,title,urls) VALUES(0,'提现申请','');--257
INSERT INTO access(pid,title,urls) VALUES(0,'公共','');--258
INSERT INTO access(pid,title,urls) VALUES(0,'未知或弃用','');--259

UPDATE access set title='附件管理-删除' WHERE id =77;

--下面是先加子菜单再进行更新

--控制台1
UPDATE access set pid=1 WHERE title = '报表统计 - 评价统计';
UPDATE access set pid=1 WHERE title = '报表统计 - 派工统计';
UPDATE access set pid=1 WHERE title = '报表统计 - 出勤率统计';
UPDATE access set pid=1 WHERE title = '报表统计 - 服务工时统计';
UPDATE access set pid=1 WHERE title = '报表统计 - 支付统计';

--订单中心249
INSERT INTO access(pid,title,urls) VALUES(249,'订单列表','');--260
UPDATE access set pid=260 WHERE title = '订单列表-查看';
UPDATE access set pid=260 WHERE title = '创建订单';
UPDATE access set pid=260 WHERE title = '订单支付管理-退款';
UPDATE access set pid=260 WHERE title = '订单支付管理-拒绝退款';

INSERT INTO access(pid,title,urls) VALUES(249,'评价列表','');--261
UPDATE access set pid=261 WHERE title = '订单评价管理-查看';
UPDATE access set pid=261 WHERE title = '订单评价管理-编辑';
UPDATE access set pid=261 WHERE title = '订单评价管理-导出';

INSERT INTO access(pid,title,urls) VALUES(249,'投诉列表','');--262
UPDATE access set pid=262 WHERE title = '订单投诉管理-查看';
UPDATE access set pid=262 WHERE title = '订单投诉管理-编辑';

--用户中心250
INSERT INTO access(pid,title,urls) VALUES(250,'用户列表','');--263
UPDATE access set pid=263 WHERE title = '用户列表-查看';
UPDATE access set pid=263 WHERE title = '用户列表-编辑';
UPDATE access set pid=263 WHERE title = '用户列表-删除';
UPDATE access set pid=263 WHERE title = '用户列表-地址设置';
UPDATE access set pid=263 WHERE title = '用户管理-查看下级账号';
UPDATE access set pid=263 WHERE title = '用户管理-查看实名认证信息';
UPDATE access set pid=263 WHERE title = '用户管理-下载二维码';

INSERT INTO access(pid,title,urls) VALUES(250,'预约列表','');--264
UPDATE access set pid=264 WHERE title = '预约就医列表-查看';
UPDATE access set pid=264 WHERE title = '预约就医列表-编辑';
UPDATE access set pid=264 WHERE title = '预约就医列表-删除';

INSERT INTO access(pid,title,urls) VALUES(250,'援助申请','');--265
UPDATE access set pid=265 WHERE title = '申请援助';
UPDATE access set pid=265 WHERE title = '编辑申请援助';
UPDATE access set pid=265 WHERE title = '删除申请援助';


--服务中心251
INSERT INTO access(pid,title,urls) VALUES(251,'服务分类','');--266
UPDATE access set pid=266 WHERE title = '服务分类模块管理';

INSERT INTO access(pid,title,urls) VALUES(251,'服务列表','');--267
UPDATE access set pid=267 WHERE title = '服务项目管理-查看';
UPDATE access set pid=267 WHERE title = '查看服务详情-查看';
UPDATE access set pid=267 WHERE title = '添加服务项目';
UPDATE access set pid=267 WHERE title = '编辑服务项目';
UPDATE access set pid=267 WHERE title = '删除服务项目';
UPDATE access set pid=267 WHERE title = '服务管理-编辑多规格';
UPDATE access set pid=267 WHERE title = '服务管理-删除多规格';
UPDATE access set pid=267 WHERE title = '服务管理-编辑补时多规格';
UPDATE access set pid=267 WHERE title = '服务管理-删除补时多规格';
UPDATE access set pid=267 WHERE title = '服务管理-编辑返佣多规格';
UPDATE access set pid=267 WHERE title = '服务管理-删除返佣多规格';
UPDATE access set pid=267 WHERE title = '服务管理-获取多规格';
UPDATE access set pid=267 WHERE title = '服务管理-获取补时多规格';

INSERT INTO access(pid,title,urls) VALUES(251,'派单列表','');--268
UPDATE access set pid=268 WHERE title = '服务下单管理';
UPDATE access set pid=268 WHERE title = '派单下单管理';
UPDATE access set pid=268 WHERE title = '回访下单管理';
UPDATE access set pid=268 WHERE title = '地图显示';
UPDATE access set pid=268 WHERE title = '人工服务下单';
UPDATE access set pid=268 WHERE title = '修改预约时间';
UPDATE access set pid=268 WHERE title = '修改备注';
UPDATE access set pid=268 WHERE title = '佣金提升';

INSERT INTO access(pid,title,urls) VALUES(251,'机构列表','');--269
UPDATE access set pid=269 WHERE title = '养老院-查看';
UPDATE access set pid=269 WHERE title = '养老院-添加';
UPDATE access set pid=269 WHERE title = '养老院-编辑';
UPDATE access set pid=269 WHERE title = '养老院-删除';

INSERT INTO access(pid,title,urls) VALUES(251,'人员列表','');--270
UPDATE access set pid=270 WHERE title = '入住老人-查看';
UPDATE access set pid=270 WHERE title = '入住老人-添加';
UPDATE access set pid=270 WHERE title = '入住老人-编辑';
UPDATE access set pid=270 WHERE title = '入住老人-删除';

INSERT INTO access(pid,title,urls) VALUES(251,'随机免单管理','');--271
UPDATE access set pid=271 WHERE title = '随机免单';
UPDATE access set pid=271 WHERE title = '随机免单-保存设置';

INSERT INTO access(pid,title,urls) VALUES(251,'开关日志','');--272
UPDATE access set pid=272 WHERE title = '随机免单-开关日志';

INSERT INTO access(pid,title,urls) VALUES(251,'促销活动管理','');--273
UPDATE access set pid=273 WHERE title = '促销活动';
UPDATE access set pid=273 WHERE title = '促销活动-新建';
UPDATE access set pid=273 WHERE title = '促销活动-编辑';
UPDATE access set pid=273 WHERE title = '促销活动-删除';
UPDATE access set pid=273 WHERE title = '促销活动-上架';
UPDATE access set pid=273 WHERE title = '促销活动-下架';
UPDATE access set pid=273 WHERE title = '促销活动-查看服务列表';

INSERT INTO access(pid,title,urls) VALUES(251,'免单日志','');--274
UPDATE access set pid=274 WHERE title = '随机免单-免单日志';

INSERT INTO access(pid,title,urls) VALUES(251,'套餐管理','');--275
UPDATE access set pid=275 WHERE title = '套餐服务列表页面';
UPDATE access set pid=275 WHERE title = '新建套餐';
UPDATE access set pid=275 WHERE title = '编辑套餐';
UPDATE access set pid=275 WHERE title = '删除套餐';
UPDATE access set pid=275 WHERE title = '上架套餐';
UPDATE access set pid=275 WHERE title = '下架套餐';
UPDATE access set pid=275 WHERE title = '编辑套餐-获取服务的规格信息';
UPDATE access set pid=275 WHERE title = '推荐套餐开关';
UPDATE access set pid=275 WHERE title = '套餐排序';

INSERT INTO access(pid,title,urls) VALUES(251,'套餐购买记录','');--276
UPDATE access set pid=276 WHERE title = '套餐购买记录页面';

--营销中心252
INSERT INTO access(pid,title,urls) VALUES(252,'广告位列表','');--277
UPDATE access set pid=277 WHERE title = '轮播图模块管理-查看';
UPDATE access set pid=277 WHERE title = '轮播图模块管理-添加';
UPDATE access set pid=277 WHERE title = '轮播图模块管理-编辑';
UPDATE access set pid=277 WHERE title = '轮播图模块管理-删除';

INSERT INTO access(pid,title,urls) VALUES(252,'广告列表','');--278
UPDATE access set pid=278 WHERE title = '轮播图属性地址-查看';
UPDATE access set pid=278 WHERE title = '轮播图属性地址-添加';
UPDATE access set pid=278 WHERE title = '轮播图属性地址-编辑';
UPDATE access set pid=278 WHERE title = '轮播图属性地址-删除';

INSERT INTO access(pid,title,urls) VALUES(252,'活动分类','');--279
UPDATE access set pid=279 WHERE title = '活动分类模块管理';
UPDATE access set pid=279 WHERE title = '活动分类模块管理-添加';
UPDATE access set pid=279 WHERE title = '活动分类模块管理-编辑';
UPDATE access set pid=279 WHERE title = '活动分类模块管理-删除';

INSERT INTO access(pid,title,urls) VALUES(252,'活动列表','');--280
UPDATE access set pid=280 WHERE title = '活动管理-查看';
UPDATE access set pid=280 WHERE title = '活动管理-添加';
UPDATE access set pid=280 WHERE title = '活动管理-编辑';
UPDATE access set pid=280 WHERE title = '活动管理-删除';
UPDATE access set pid=280 WHERE title = '活动管理-信息查看';
UPDATE access set pid=280 WHERE title = '活动人员报名管理-查看';
UPDATE access set pid=280 WHERE title = '活动人员报名管理-编辑';
UPDATE access set pid=280 WHERE title = '活动人员报名管理-删除';
UPDATE access set pid=280 WHERE title = '活动报名人员-编辑';
UPDATE access set pid=280 WHERE title = '活动报名人员-删除';

INSERT INTO access(pid,title,urls) VALUES(252,'文章列表','');--281
UPDATE access set pid=281 WHERE title = '文章详情管理-查看';
UPDATE access set pid=281 WHERE title = '文章详情管理-添加';
UPDATE access set pid=281 WHERE title = '文章详情管理-编辑';
UPDATE access set pid=281 WHERE title = '文章详情管理-删除';
UPDATE access set pid=281 WHERE title = '查看文章详情';

--系统设置253
INSERT INTO access(pid,title,urls) VALUES(253,'菜单管理','');--282
UPDATE access set pid=282 WHERE title = '菜单管理-查看';
UPDATE access set pid=282 WHERE title = '菜单管理-添加';
UPDATE access set pid=282 WHERE title = '菜单管理-编辑';
UPDATE access set pid=282 WHERE title = '菜单管理-删除';

INSERT INTO access(pid,title,urls) VALUES(253,'开通服务城市','');--283
UPDATE access set pid=283 WHERE title = '开通服务城市-查找';
UPDATE access set pid=283 WHERE title = '开通服务城市-查看';
UPDATE access set pid=283 WHERE title = '开通服务城市-添加';
UPDATE access set pid=283 WHERE title = '开通服务城市-编辑';
UPDATE access set pid=283 WHERE title = '开通服务城市-删除';

INSERT INTO access(pid,title,urls) VALUES(253,'员工列表','');--284
UPDATE access set pid=284 WHERE title = '员工管理-查看';
UPDATE access set pid=284 WHERE title = '员工管理-添加';
UPDATE access set pid=284 WHERE title = '员工管理-删除';

--管理员列表3
UPDATE access set title = '管理员列表',status=1,pid=253 WHERE id=3;
UPDATE access set pid=3 WHERE title = '管理员·查看';
UPDATE access set pid=3 WHERE title = '管理员·添加';
UPDATE access set pid=3 WHERE title = '管理员·编辑';
UPDATE access set pid=3 WHERE title = '管理员·删除';

--角色列表8
UPDATE access set title = '角色列表',status=1,pid=253 WHERE id=8;
UPDATE access set pid=8 WHERE title = '角色组·查看';
UPDATE access set pid=8 WHERE title = '角色组·添加';
UPDATE access set pid=8 WHERE title = '角色组·编辑';
UPDATE access set pid=8 WHERE title = '角色组·删除';

--权限列表13
UPDATE access set title = '权限列表',status=1,pid=253 WHERE id=13;
UPDATE access set pid=13 WHERE title = '权限路径·查看';
UPDATE access set pid=13 WHERE title = '权限路径·添加';
UPDATE access set pid=13 WHERE title = '权限路径·编辑';
UPDATE access set pid=13 WHERE title = '权限路径·删除';

INSERT INTO access(pid,title,urls) VALUES(253,'意见反馈','');--285
UPDATE access set pid=285 WHERE title = '客户端 - 意见反馈';
UPDATE access set pid=285 WHERE title = '编辑意见反馈';
UPDATE access set pid=285 WHERE title = '意见反馈-删除';
UPDATE access set pid=285 WHERE title = '员工端 - 意见反馈';
UPDATE access set pid=285 WHERE title = '员工端 - 意见反馈-编辑';
UPDATE access set pid=285 WHERE title = '员工端 - 意见反馈-删除';

INSERT INTO access(pid,title,urls) VALUES(253,'系统参数列表','');--286
UPDATE access set pid=286 WHERE title = '系统参数管理-查看';
UPDATE access set pid=286 WHERE title = '系统参数管理-编辑';

INSERT INTO access(pid,title,urls) VALUES(253,'系统公告消息','');--287
UPDATE access set pid=287 WHERE title = '系统消息管理-查看';
UPDATE access set pid=287 WHERE title = '系统消息管理-添加';
UPDATE access set pid=287 WHERE title = '系统消息管理-删除';

--分享中心254
INSERT INTO access(pid,title,urls) VALUES(254,'海报分享','');--288
UPDATE access set pid=288 WHERE title = '海报分享管理';
UPDATE access set pid=288 WHERE title = '海报分享管理-添加';
UPDATE access set pid=288 WHERE title = '海报分享管理-编辑';
UPDATE access set pid=288 WHERE title = '海报分享管理-删除';

INSERT INTO access(pid,title,urls) VALUES(254,'返佣','');--289
UPDATE access set pid=289 WHERE title = '返佣管理';
UPDATE access set pid=289 WHERE title = '返佣管理-修改保存';

INSERT INTO access(pid,title,urls) VALUES(254,'邀请赠送','');--290
UPDATE access set pid=290 WHERE title = '邀请赠送管理';
UPDATE access set pid=290 WHERE title = '邀请赠送管理-操作日志';
UPDATE access set pid=290 WHERE title = '邀请赠送管理-添加';
UPDATE access set pid=290 WHERE title = '邀请赠送管理-状态开关';
UPDATE access set pid=290 WHERE title = '邀请赠送管理-删除';

INSERT INTO access(pid,title,urls) VALUES(254,'邀请日志管理','');--291
UPDATE access set pid=291 WHERE title = '邀请日志';

INSERT INTO access(pid,title,urls) VALUES(254,'钱包列表','');--292
UPDATE access set pid=292 WHERE title = '钱包管理';
UPDATE access set pid=292 WHERE title = '钱包管理-查看流水';

INSERT INTO access(pid,title,urls) VALUES(254,'员工钱包管理','');--293
UPDATE access set pid=293 WHERE title = '员工钱包管理-页面';
UPDATE access set pid=293 WHERE title = '员工钱包流水-页面';

INSERT INTO access(pid,title,urls) VALUES(254,'邀请二维码','');--294
UPDATE access set pid=294 WHERE title = '推荐二维码首页';
UPDATE access set pid=294 WHERE title = '推荐二维码添加';
UPDATE access set pid=294 WHERE title = '推荐二维码导出';


--优惠券中心255
INSERT INTO access(pid,title,urls) VALUES(255,'优惠券管理','');--295
UPDATE access set pid=295 WHERE title = '优惠卷管理列表-查看';
UPDATE access set pid=295 WHERE title = '优惠卷管理列表-添加';
UPDATE access set pid=295 WHERE title = '优惠卷管理列表-编辑';
UPDATE access set pid=295 WHERE title = '优惠卷管理列表-删除';
UPDATE access set pid=295 WHERE title = '优惠卷领取人管理-查看';
UPDATE access set pid=295 WHERE title = '优惠卷领取人管理-添加';
UPDATE access set pid=295 WHERE title = '优惠卷领取人管理-编辑';
UPDATE access set pid=295 WHERE title = '优惠卷领取人管理-删除';
UPDATE access set pid=295 WHERE title = '优惠券子码管理';

INSERT INTO access(pid,title,urls) VALUES(255,'优惠券模块管理','');--296
UPDATE access set pid=296 WHERE title = '优惠卷模块管理-查看';
UPDATE access set pid=296 WHERE title = '优惠卷模块管理-编辑';

INSERT INTO access(pid,title,urls) VALUES(255,'优惠券事件管理','');--297
UPDATE access set pid=297 WHERE title = '优惠券事件';
UPDATE access set pid=297 WHERE title = '优惠券事件-添加';
UPDATE access set pid=297 WHERE title = '优惠券事件-编辑';
UPDATE access set pid=297 WHERE title = '优惠券事件-删除';
UPDATE access set pid=297 WHERE title = '优惠券事件-查看';
UPDATE access set pid=297 WHERE title = '优惠券事件-添加事件详情';
UPDATE access set pid=297 WHERE title = '优惠券事件-删除事件详情';

--其他配置256
INSERT INTO access(pid,title,urls) VALUES(256,'短视频','');--298
UPDATE access set pid=298 WHERE title = '视频上传';
UPDATE access set pid=298 WHERE title = '短视频管理';
UPDATE access set pid=298 WHERE title = '添加视频';
UPDATE access set pid=298 WHERE title = '编辑视频';
UPDATE access set pid=298 WHERE title = '删除视频';
UPDATE access set pid=298 WHERE title = '视频点赞人查看';

INSERT INTO access(pid,title,urls) VALUES(256,'首页弹窗提醒','');--299
UPDATE access set pid=299 WHERE title = '促销活动弹窗-查看';
UPDATE access set pid=299 WHERE title = '促销活动弹窗-编辑';
UPDATE access set pid=299 WHERE title = '促销活动弹窗-添加';
UPDATE access set pid=299 WHERE title = '促销活动弹窗-删除';

INSERT INTO access(pid,title,urls) VALUES(256,'专题模块管理','');--300
UPDATE access set pid=300 WHERE title = '促销模块管理列表';
UPDATE access set pid=300 WHERE title = '促销模块管理列表-删除';
UPDATE access set pid=300 WHERE title = '促销模块管理列表-添加';
UPDATE access set pid=300 WHERE title = '促销模块管理列表-编辑';

INSERT INTO access(pid,title,urls) VALUES(256,'订单预约申请修改','');--301
UPDATE access set pid=301 WHERE title = '申请修改预约时间';
UPDATE access set pid=301 WHERE title = '申请修改预约时间-编辑';

INSERT INTO access(pid,title,urls) VALUES(256,'标签管理','');--302
UPDATE access set pid=302 WHERE title = '标签列表';
UPDATE access set pid=302 WHERE title = '标签列表-添加';
UPDATE access set pid=302 WHERE title = '标签列表-编辑';
UPDATE access set pid=302 WHERE title = '标签列表-删除';

--提现申请257
INSERT INTO access(pid,title,urls) VALUES(257,'员工提现','');--303
UPDATE access set pid=303 WHERE title = '员工提现申请-查看';
UPDATE access set pid=303 WHERE title = '员工提现申请-编辑';

INSERT INTO access(pid,title,urls) VALUES(257,'客户提现','');--304
UPDATE access set pid=304 WHERE title = '钱包提现列表';
UPDATE access set pid=304 WHERE title = '提现审核';
UPDATE access set pid=304 WHERE title = '提现钱包流水-页面';

--公共258
UPDATE access set pid=258 WHERE title = '个人资料';
UPDATE access set pid=258 WHERE title = '用户登录';
UPDATE access set pid=258 WHERE title = '用户退出登录';
UPDATE access set pid=258 WHERE title = '管理员日志编辑';
UPDATE access set pid=258 WHERE title = '管理员日志删除';

--未知或弃用
UPDATE access set pid=259 WHERE title = '银行卡支付宝绑定列表-查看';
UPDATE access set pid=259 WHERE title = '银行卡支付宝绑定列表-编辑';
UPDATE access set pid=259 WHERE title = '银行卡支付宝绑定列表-删除';
UPDATE access set pid=259 WHERE title = '志愿者人员管理';
UPDATE access set pid=259 WHERE title = '添加志愿者人员';
UPDATE access set pid=259 WHERE title = '编辑志愿者人员';
UPDATE access set pid=259 WHERE title = '删除志愿者人员';
UPDATE access set pid=259 WHERE title = '志愿者组团管理';
UPDATE access set pid=259 WHERE title = '添加志愿者团组';
UPDATE access set pid=259 WHERE title = '编辑志愿者团组';
UPDATE access set pid=259 WHERE title = '删除志愿者团组';
UPDATE access set pid=259 WHERE title = '启动页管理-查看';
UPDATE access set pid=259 WHERE title = '启动页管理-添加';
UPDATE access set pid=259 WHERE title = '启动页管理-编辑';
UPDATE access set pid=259 WHERE title = '启动页管理-删除';
UPDATE access set pid=259 WHERE title = '实名认证';
UPDATE access set pid=259 WHERE title = '实名认证-通过与驳回';
UPDATE access set pid=259 WHERE title = '附件管理-查看';
UPDATE access set pid=259 WHERE title = '附件管理-添加';
UPDATE access set pid=259 WHERE title = '附件管理-删除';
UPDATE access set pid=259 WHERE title = '订单支付管理-查看';
UPDATE access set pid=259 WHERE title = '订单支付管理-编辑';
UPDATE access set pid=259 WHERE title = '服务订单详情查询';
UPDATE access set pid=259 WHERE title = '报表统计 - 员工佣金统计';
UPDATE access set pid=259 WHERE title = '查看服务的补时规格模板列表';
UPDATE access set pid=259 WHERE title = '保存服务的补时规格模板';
UPDATE access set pid=259 WHERE title = '删除服务的补时规格模板';
UPDATE access set pid=259 WHERE title = '删除服务的补时规格模板';
UPDATE access set pid=259 WHERE title = '获取订单名称列表';
UPDATE access set pid=259 WHERE title = '歌舞活动比赛报名人员管理';
UPDATE access set pid=259 WHERE title = '歌舞活动助力投票列表';
UPDATE access set pid=259 WHERE title = '歌舞活动比赛报名人员管理 - 编辑';
UPDATE access set pid=259 WHERE title = '歌舞活动比赛报名人员管理-删除';
UPDATE access set pid=259 WHERE title = '钱包提现列表';
UPDATE access set pid=259 WHERE title = '提现钱包流水-页面';
UPDATE access set pid=259 WHERE title = '上传视频';
UPDATE access set pid=259 WHERE title = '查看视频';
UPDATE access set pid=259 WHERE title = '检查订单自动匹配派单的状态';
UPDATE access set pid=259 WHERE title = '员工管理-编辑';

多级权限的逻辑

库biglove-表access增加字段

ALTER TABLE `biglove`.`access` ADD COLUMN `level` tinyint(1) NOT NULL DEFAULT 0 COMMENT '权限分级，0=子级权限节点，1=父级权限' AFTER `status`;

--子级菜单
update access set level = 1 where pid = 0;
--父级菜单
update access set level = 1 where urls = '';

--加索引
ALTER TABLE `biglove`.`access`
ADD INDEX `index_status_level`(`status`, `level`) USING BTREE COMMENT 'status和level联合索引';

ALTER TABLE `biglove`.`role_access`
ADD INDEX `index_access_id`(`access_id`) USING BTREE;

UPDATE access set pid=1 WHERE title = '报表统计 - 员工佣金统计';
UPDATE access set title='报表统计 - 支付统计',pid=1 WHERE id =110;
UPDATE access set pid=259 WHERE id=100;

迭代10发布文档

迭代8发布文档

点赞(0) 阅读(1) 举报
文章标题
目录
标题