LK/income_payments_management
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
24年2月变更
income_payments_management/db/2022-1-4变更.sql
T

267 lines
22 KiB
SQL
Raw Permalink Blame History

-- auto-generated definition
create table pay_meeting_contacts
(
id varchar(36) not null comment 'id',
meeting_id varchar(50) null comment '会议id',
meeting_contacts_id varchar(50) null comment '会议联系人id',
meeting_contacts_name varchar(50) null comment '会议联系人姓名',
meeting_contacts_phone varchar(50) null comment '会议联系人电话'
)
comment '会议关联联系人表';
create unique index Index_1
on pay_meeting_contacts (id);
DELETE FROM sys_permission WHERE id='1440577017224114177';
DELETE FROM sys_role_permission WHERE permission_id = '1440577017224114177';
DELETE FROM sys_depart_permission WHERE permission_id = '1440577017224114177';
DELETE FROM sys_depart_role_permission WHERE permission_id = '1440577017224114177';
DELETE FROM sys_permission WHERE id='1440521255198142465';
DELETE FROM sys_role_permission WHERE permission_id = '1440521255198142465';
DELETE FROM sys_depart_permission WHERE permission_id = '1440521255198142465';
DELETE FROM sys_depart_role_permission WHERE permission_id = '1440521255198142465';
ALTER TABLE `pay_meeting`
MODIFY COLUMN `case_committee_id` varchar(50) NULL DEFAULT NULL COMMENT '分标委项目id' AFTER `working_group_name`,
MODIFY COLUMN `case_committee_name` varchar(50) NULL DEFAULT NULL COMMENT '分标委项目名称' AFTER `case_committee_id`,
MODIFY COLUMN `council_id` varchar(50) NULL DEFAULT NULL COMMENT '理事会项目id' AFTER `standards_id`,
MODIFY COLUMN `council_name` varchar(50) NULL DEFAULT NULL COMMENT '理事会项目名称' AFTER `council_id`;
create table wx_secret
(
login_type varchar(255) null,
secret varchar(255) null
);
INSERT INTO wx_secret (login_type, secret) VALUES ('dev', 'db3482f68206b077ca67041f47462c3229d22c277308d96c02c72a128aee0f3fdd05ac2f70d22539');
INSERT INTO wx_secret (login_type, secret) VALUES ('prod', '51daf9829b6b487f99693a2032cda10abde40319b6ffdc61886b921e7eaa40c5ae3e49a5b13a2a31');
-- 2022-1-24新增
ALTER TABLE `pay_meeting`
MODIFY COLUMN `meeting_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '会议内容' AFTER `estimated_number`;
-- 2022-2-12
INSERT INTO sys_dict_item ( id, dict_id, item_text, item_value, description, sort_order, status, create_by, create_time ) VALUES ( '1492310294221639681', '1431145150766923778', '证书费用', '20', '', 20, 1, 'LKGLZ', '2022-02-12 09:31:14' );
ALTER TABLE tb_certificate_payment
MODIFY COLUMN `charge_use` tinyint(1) NULL DEFAULT 20 COMMENT '来款用途（字典表）' AFTER `mail`;
update tb_certificate_payment set charge_use = 20 where 1 = 1;
update pay_meeting set meeting_type = 5 ,case_committee_id = '1486586847797346305' ,case_committee_name = '全国汽车标准化技术委员会电动车辆分技术委员会' WHERE id = '1478574801809993729';
update pay_working_group_subitem set make_invoice = 1 where id = '1484760196725768194';
-- 2022-4-8 导入工号
/*
Navicat Premium Data Transfer
Source Server : 10.10.10.44
Source Server Type : MySQL
Source Server Version : 50711
Source Host : 10.10.10.44:3306
Source Schema : income_payments
Target Server Type : MySQL
Target Server Version : 50711
File Encoding : 65001
Date: 08/04/2022 14:33:40
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for sheet0
-- ----------------------------
DROP TABLE IF EXISTS `sheet0`;
CREATE TABLE `sheet0` (
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sheet0
-- ----------------------------
INSERT INTO `sheet0` VALUES ('06779', '闫雪');
INSERT INTO `sheet0` VALUES ('01633', '陈强');
INSERT INTO `sheet0` VALUES ('05085', '纪梦雪');
INSERT INTO `sheet0` VALUES ('02939', '解瀚光');
INSERT INTO `sheet0` VALUES ('05090', '孙悦');
INSERT INTO `sheet0` VALUES ('05095', '张清莹');
INSERT INTO `sheet0` VALUES ('05524', '王彪');
INSERT INTO `sheet0` VALUES ('04172', '赵静炜');
INSERT INTO `sheet0` VALUES ('00067', '王兆');
INSERT INTO `sheet0` VALUES ('00084', '戎辉');
INSERT INTO `sheet0` VALUES ('00066', '刘桂彬');
INSERT INTO `sheet0` VALUES ('01433', '傅剑华');
INSERT INTO `sheet0` VALUES ('01107', '李维菁');
INSERT INTO `sheet0` VALUES ('01505', '张英男');
INSERT INTO `sheet0` VALUES ('05536', '张昊');
INSERT INTO `sheet0` VALUES ('05532', '闫志强');
INSERT INTO `sheet0` VALUES ('05511', '郭琳');
INSERT INTO `sheet0` VALUES ('01627', '李琛');
INSERT INTO `sheet0` VALUES ('03054', '王一鸣');
INSERT INTO `sheet0` VALUES ('01133', '孙枝鹏');
INSERT INTO `sheet0` VALUES ('05817', '李玉刚');
INSERT INTO `sheet0` VALUES ('05755', '常晏宁');
INSERT INTO `sheet0` VALUES ('05530', '许天楚');
INSERT INTO `sheet0` VALUES ('05518', '刘静榕');
INSERT INTO `sheet0` VALUES ('05089', '彭伟强');
INSERT INTO `sheet0` VALUES ('04770', '曹丽娟');
INSERT INTO `sheet0` VALUES ('04235', '田富刚');
INSERT INTO `sheet0` VALUES ('01877', '张铜柱');
INSERT INTO `sheet0` VALUES ('01557', '张广秀');
INSERT INTO `sheet0` VALUES ('01140', '轩轶');
INSERT INTO `sheet0` VALUES ('01134', '孙振东');
INSERT INTO `sheet0` VALUES ('01003', '刘彦戎');
INSERT INTO `sheet0` VALUES ('01150', '朱彤');
INSERT INTO `sheet0` VALUES ('05515', '李铮');
INSERT INTO `sheet0` VALUES ('05509', '付越');
INSERT INTO `sheet0` VALUES ('04238', '季国田');
INSERT INTO `sheet0` VALUES ('03840', '胡月');
INSERT INTO `sheet0` VALUES ('01821', '李波');
INSERT INTO `sheet0` VALUES ('01470', '范嘉睿');
INSERT INTO `sheet0` VALUES ('01181', '刘地');
INSERT INTO `sheet0` VALUES ('04670', '文清浩');
INSERT INTO `sheet0` VALUES ('02343', '潘俊家');
INSERT INTO `sheet0` VALUES ('01162', '郭淼');
INSERT INTO `sheet0` VALUES ('02256', '殷凤轩');
INSERT INTO `sheet0` VALUES ('05586', '何丽');
INSERT INTO `sheet0` VALUES ('05525', '王惠云');
INSERT INTO `sheet0` VALUES ('05517', '刘佳仪');
INSERT INTO `sheet0` VALUES ('05508', '董坤');
INSERT INTO `sheet0` VALUES ('02141', '李金玉');
INSERT INTO `sheet0` VALUES ('01513', '张翠');
INSERT INTO `sheet0` VALUES ('01183', '杨振馨');
INSERT INTO `sheet0` VALUES ('01166', '孙怡');
INSERT INTO `sheet0` VALUES ('01047', '骆志红');
INSERT INTO `sheet0` VALUES ('01064', '朱毅');
INSERT INTO `sheet0` VALUES ('01525', '李稳');
INSERT INTO `sheet0` VALUES ('01546', '郑天雷');
INSERT INTO `sheet0` VALUES ('01726', '于洋');
INSERT INTO `sheet0` VALUES ('05387', '郝维健');
INSERT INTO `sheet0` VALUES ('05522', '刘志超');
INSERT INTO `sheet0` VALUES ('05505', '曹冬冬');
INSERT INTO `sheet0` VALUES ('03871', '胡建');
INSERT INTO `sheet0` VALUES ('02997', '兰昊');
INSERT INTO `sheet0` VALUES ('01671', '徐枭');
INSERT INTO `sheet0` VALUES ('01665', '保翔');
INSERT INTO `sheet0` VALUES ('01061', '何云堂');
INSERT INTO `sheet0` VALUES ('04202', '柳邵辉');
INSERT INTO `sheet0` VALUES ('02704', '孙航');
INSERT INTO `sheet0` VALUES ('06716', '吴嘉杰');
INSERT INTO `sheet0` VALUES ('05709', '张路');
INSERT INTO `sheet0` VALUES ('03206', '张淼');
INSERT INTO `sheet0` VALUES ('02662', '吴含冰');
INSERT INTO `sheet0` VALUES ('05514', '李宝田');
INSERT INTO `sheet0` VALUES ('05507', '陈振宇');
INSERT INTO `sheet0` VALUES ('04346', '张行');
INSERT INTO `sheet0` VALUES ('04922', '李春');
INSERT INTO `sheet0` VALUES ('02944', '张琳琳');
INSERT INTO `sheet0` VALUES ('04674', '陆春');
INSERT INTO `sheet0` VALUES ('05535', '张春荣');
INSERT INTO `sheet0` VALUES ('05533', '燕翙江');
INSERT INTO `sheet0` VALUES ('05087', '李云伟');
INSERT INTO `sheet0` VALUES ('01083', '王颖');
INSERT INTO `sheet0` VALUES ('04393', '魏墨晗');
INSERT INTO `sheet0` VALUES ('03741', '吕双');
INSERT INTO `sheet0` VALUES ('02377', '冯博');
INSERT INTO `sheet0` VALUES ('01432', '谢东明');
SET FOREIGN_KEY_CHECKS = 1;
ALTER TABLE `sys_user`
DROP INDEX `uniq_sys_user_work_no`;
update sys_user set sys_user.work_no = (select sheet0.username from sheet0 where sys_user.realname = sheet0.fullname);
DROP TABLE IF EXISTS `sheet0`;
-- 2022-04-12 合同变更
alter TABLE pay_spending_contract ADD (phone VARCHAR(22) COMMENT '联系电话',address VARCHAR(255) COMMENT '邮寄地址',post_code VARCHAR(50) COMMENT '邮编');
alter TABLE pay_mail_contract ADD (contract_type TINYINT(2) COMMENT '合同类型：1 支出合同，2 收入合同');
INSERT INTO `sys_dict` VALUES ('1509830472616779778', '合同类型', 'contract_type', '（1：支出合同，2：收入合同）', 0, 'LKGLZ', '2022-04-01 17:50:11', 'LKGLZ', '2022-04-01 17:51:38', 0);
INSERT INTO `sys_dict_item` VALUES ('1509830576870400001', '1509830472616779778', '支出合同', '1', '', 1.00, 1, 'LKGLZ', '2022-04-01 17:50:35', NULL, NULL);
INSERT INTO `sys_dict_item` VALUES ('1509830618775691265', '1509830472616779778', '收入合同', '2', '', 1.00, 1, 'LKGLZ', '2022-04-01 17:50:45', NULL, NULL);
-- 2022-04-20 新增是否是内部企业
ALTER TABLE pay_company_management ADD COLUMN internal_enterprise VARCHAR(6) DEFAULT NULL COMMENT '是否内部企业';
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1516688284384772098', '1430376267109978113', '是否内部企业', NULL, NULL, NULL, NULL, 2, 'company:updateInternalEnterprise', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-04-20 16:00:40', NULL, NULL, 0, 0, '1', 0);
-- 2022-04-24 收入合同+支出合同查询邮寄详情按钮权限
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1518071675121545217', '1433250634957398018', '查看邮寄详情', NULL, NULL, NULL, NULL, 2, 'revenueContract:mailDetail', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-04-24 11:37:46', NULL, NULL, 0, 0, '1', 0);
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1518071807695106050', '1435135348211298306', '查看邮寄详情', NULL, NULL, NULL, NULL, 2, 'expenditureContract:mailDetail', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-04-24 11:38:18', NULL, NULL, 0, 0, '1', 0);
-- 2022-04-25 工作组成员单位3个联系人修改成多个联系人变更
DROP TABLE IF EXISTS `pay_working_group_subitem_contacts`;
CREATE TABLE `pay_working_group_subitem_contacts` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`working_group_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作组id',
`working_group_sub_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作组成员id',
`contacts_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '企业联系人id',
`contacts_temporary_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '临时企业联系人id',
`contacts_temporary_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '临时企业联系人名称',
`remarks` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系人备注',
`order_num` int(3) NULL DEFAULT NULL COMMENT '序号',
`create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_wg_working_group_id`(`working_group_id`) USING BTREE,
INDEX `idx_wg_working_group_sub_id`(`working_group_sub_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工作组成员企业联系人表' ROW_FORMAT = Dynamic;
insert into pay_working_group_subitem_contacts(id,working_group_id,working_group_sub_id,contacts_id,contacts_temporary_id,contacts_temporary_name,remarks,order_num,create_by,create_time) (select MD5(UUID()),working_group_id,id,contacts_id_one,contacts_temporary_id_one,contacts_temporary_name_one,remarks_one,1,create_by,create_time FROM pay_working_group_subitem where contacts_id_one is not null and contacts_id_one !='');
insert into pay_working_group_subitem_contacts(id,working_group_id,working_group_sub_id,contacts_id,contacts_temporary_id,contacts_temporary_name,remarks,order_num,create_by,create_time) (select MD5(UUID()),working_group_id,id,contacts_id_two,contacts_temporary_id_two,contacts_temporary_name_two,remarks_two,2,create_by,create_time FROM pay_working_group_subitem where contacts_id_two is not null and contacts_id_two !='');
insert into pay_working_group_subitem_contacts(id,working_group_id,working_group_sub_id,contacts_id,contacts_temporary_id,contacts_temporary_name,remarks,order_num,create_by,create_time) (select MD5(UUID()),working_group_id,id,contacts_id_three,contacts_temporary_id_three,contacts_temporary_name_three,remarks_three,3,create_by,create_time FROM pay_working_group_subitem where contacts_id_three is not null and contacts_id_three !='');
-- 20220426 分标委资料下载
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1518868037115293697', '1438322844248055809', '下载', NULL, NULL, NULL, NULL, 2, 'fileMaintenance:download', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-04-26 16:22:14', NULL, NULL, 0, 0, '1', 0);
INSERT INTO sys_role_permission ( id, role_id, permission_id, operate_date, operate_ip ) VALUES ( '1518880097958739969', 'f6817f48af4fb3af11b9e8bf182f618b', '1518868037115293697', '2022-04-26 17:10:09', '127.0.0.1' );
-- 20220509 发票信息
ALTER TABLE `tb_member_project_subitem`
ADD COLUMN `header_name` varchar(100) NULL COMMENT '抬头名称',
ADD COLUMN `tax_number` varchar(100) NULL COMMENT '单位税号',
ADD COLUMN `invoice_address` varchar(255) NULL COMMENT '单位地址',
ADD COLUMN `invoice_phone` varchar(255) NULL COMMENT '电话号码',
ADD COLUMN `deposit_bank` varchar(255) NULL COMMENT '开户行',
ADD COLUMN `bank_account` varchar(100) NULL COMMENT '银行账户';
ALTER TABLE `tb_certificate_payment`
ADD COLUMN `header_name` varchar(100) NULL COMMENT '抬头名称',
ADD COLUMN `tax_number` varchar(100) NULL COMMENT '单位税号',
ADD COLUMN `invoice_address` varchar(255) NULL COMMENT '单位地址',
ADD COLUMN `invoice_phone` varchar(255) NULL COMMENT '电话号码',
ADD COLUMN `deposit_bank` varchar(255) NULL COMMENT '开户行',
ADD COLUMN `bank_account` varchar(100) NULL COMMENT '银行账户';
-- 2022年6月 2日 删除项目来款统计 菜单
UPDATE sys_permission SET del_flag = 1 WHERE id = 1437598477620879362;
-- 2022年6月 2日 修改科室来款 菜单 的组件
UPDATE `sys_permission` SET `url` = '/statisticalReport/projectPaymentStatisticsList', `component` = 'statisticalReport/departmentStatistics/ProjectPaymentStatisticsList' WHERE `id` = '1437597378537070593';
UPDATE `sys_permission` SET `parent_id` = '1437597378537070593' WHERE `id` = '1440597369140633602';
UPDATE `sys_permission` SET `parent_id` = '1437597378537070593' WHERE `id` = '1440597486811832321';
-- 2022年6月8日 修改统计模块的 路由缓存状态 --工作组来款\企业来款统计\个人来款统计
UPDATE `sys_permission` SET `keep_alive` = 1 WHERE `id` = '1437596772434976770';
UPDATE `sys_permission` SET `keep_alive` = 1 WHERE `id` = '1437593594347921410';
UPDATE `sys_permission` SET `keep_alive` = 1 WHERE `id` = '1437597826593595394';
-- 2022年6月11日 增加科室总体总计 的菜单创建sql
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1535558715796852737', '1437320526513905666', '科室总体统计', '/statisticalReport/departmentAllStatistics', 'statisticalReport/departmentAllStatistics/DepartmentAllStatistics', NULL, NULL, 1, NULL, '1', 7.00, 0, NULL, 1, 0, 0, 0, NULL, 'LKGLZ', '2022-06-11 17:45:02', 'LKGLZ', '2022-06-11 17:50:17', 0, 0, '1', 0);
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1535559127371321346', '1535558715796852737', '查询', '', NULL, NULL, NULL, 2, 'departmentAllStatistics:search', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-06-11 17:46:40', NULL, NULL, 0, 0, '1', 0);
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1535559323643777026', '1535558715796852737', '导出', '', NULL, NULL, NULL, 2, 'departmentAllStatistics:export', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-06-11 17:47:27', NULL, NULL, 0, 0, '1', 0);
-- 2022年8月1日 增加全所收入统计模块的sql;增加打包管理模块确认收入按钮的sql
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1553998336251633666', '1553997970898395138', '导出', NULL, NULL, NULL, NULL, 2, 'wholePaymentsStatistics:export', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-08-01 14:57:30', NULL, NULL, 0, 0, '1', 0);
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1553998246489333762', '1553997970898395138', '查询', NULL, NULL, NULL, NULL, 2, 'wholePaymentsStatistics:search', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-08-01 14:57:09', NULL, NULL, 0, 0, '1', 0);
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1553997970898395138', '1437320526513905666', '全所收入统计', '/statisticalReport/WholePaymentsStatistics', 'statisticalReport/WholePaymentsStatistics', NULL, NULL, 1, NULL, '1', 10.00, 0, NULL, 1, 0, 0, 0, NULL, 'LKGLZ', '2022-08-01 14:56:03', NULL, NULL, 0, 0, '1', 0);
INSERT INTO `sys_permission`(`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1553987184549404674', '1435493270476906497', '确认收入', NULL, NULL, NULL, NULL, 2, 'packProject:confirmPayment', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-08-01 14:13:11', NULL, NULL, 0, 0, '1', 0);
INSERT INTO `sys_permission` (`id`, `parent_id`, `name`, `url`, `component`, `component_name`, `redirect`, `menu_type`, `perms`, `perms_type`, `sort_no`, `always_show`, `icon`, `is_route`, `is_leaf`, `keep_alive`, `hidden`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `rule_flag`, `status`, `internal_or_external`) VALUES ('1570599545738825729', '1435815710331621378', '撤销', '', NULL, NULL, NULL, 2, 'incomePaymentAndInvoiving:revoke', '1', 1.00, 0, NULL, 1, 1, 0, 0, NULL, 'LKGLZ', '2022-09-16 10:24:47', NULL, NULL, 0, 0, '1', 0);
Reference in New Issue View Git Blame Copy Permalink