/*
 Navicat Premium Data Transfer

 Source Server         : person
 Source Server Type    : MySQL
 Source Server Version : 80012
 Source Host           : localhost:3306
 Source Schema         : person_system

 Target Server Type    : MySQL
 Target Server Version : 80012
 File Encoding         : 65001

 Date: 27/04/2021 14:29:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for b_contract
-- ----------------------------
DROP TABLE IF EXISTS `b_contract`;
CREATE TABLE `b_contract`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同名称',
  `part_a` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同甲方',
  `part_b` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同乙方',
  `sign_date` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同签订日期',
  `person_a` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '甲方负责人',
  `person_b` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '乙方负责人',
  `amount` float NULL DEFAULT NULL COMMENT '合同金额',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '合同管理' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_contract
-- ----------------------------
INSERT INTO `b_contract` VALUES (2, '设备采购', '哈尔滨理工大学', '青软实训基地', '2021-04-25', NULL, NULL, 10000, NULL, NULL);
INSERT INTO `b_contract` VALUES (3, '售卖老旧机器', '联想集团', '哈尔滨理工大学', '2021-04-25', NULL, NULL, 20000, NULL, NULL);

-- ----------------------------
-- Table structure for b_convert_apply
-- ----------------------------
DROP TABLE IF EXISTS `b_convert_apply`;
CREATE TABLE `b_convert_apply`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `apply_user_id` bigint(20) NULL DEFAULT NULL COMMENT '申请人',
  `apply_date` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请日期',
  `apply_content` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请内容',
  `status` int(11) NULL DEFAULT 0 COMMENT '状态',
  `approval_date` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批日期',
  `approval_user_id` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批人',
  `approval_result` int(11) NULL DEFAULT NULL COMMENT '审批结果',
  `approval_opinion` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批意见',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '转正申请' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_convert_apply
-- ----------------------------
INSERT INTO `b_convert_apply` VALUES (5, 2, '2020-05-17', '申请电脑', 2, '2020-05-17', '1', 2, '通过', '2020-05-17 08:56:50', '2020-05-17 09:13:46');
INSERT INTO `b_convert_apply` VALUES (6, 4, '2020-05-17', '申请钢笔', 2, '2021-04-25', '1', 2, '通过', '2020-05-17 09:10:40', '2021-04-25 18:57:08');
INSERT INTO `b_convert_apply` VALUES (7, 4, '2020-05-17', '申请钢笔', 1, '2021-04-25', '1', 1, '通过', '2020-05-17 09:10:40', '2021-04-26 19:53:52');
INSERT INTO `b_convert_apply` VALUES (8, 4, '2020-05-17', '申请钢笔', 2, '2021-04-25', '1', 2, '通过', '2020-05-17 09:10:40', '2021-04-25 18:57:08');
INSERT INTO `b_convert_apply` VALUES (9, 4, '2020-05-17', '申请钢笔', 2, '2021-04-25', '1', 2, '通过', '2020-05-17 09:10:40', '2021-04-25 18:57:08');
INSERT INTO `b_convert_apply` VALUES (10, 4, '2020-05-17', '申请钢笔', 2, '2021-04-25', '1', 2, '通过', '2020-05-17 09:10:40', '2021-04-25 18:57:08');
INSERT INTO `b_convert_apply` VALUES (11, 4, '2020-05-17', '申请物资', 2, '2021-04-25', '1', 2, '通过', '2020-05-17 09:10:40', '2021-04-25 18:57:08');
INSERT INTO `b_convert_apply` VALUES (12, 4, '2020-05-17', '申请钢笔', 2, '2021-04-25', '1', 2, '通过', '2020-05-17 09:10:40', '2021-04-25 18:57:08');

-- ----------------------------
-- Table structure for b_interview_plan
-- ----------------------------
DROP TABLE IF EXISTS `b_interview_plan`;
CREATE TABLE `b_interview_plan`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `candidate` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '候选人姓名',
  `candidate_mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '候选人电话',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面试人邮箱',
  `meet_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '面试时间',
  `meet_user_id` bigint(20) NULL DEFAULT NULL COMMENT '面试官',
  `status` int(11) NULL DEFAULT 0 COMMENT '面试结果',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '面试计划' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_interview_plan
-- ----------------------------
INSERT INTO `b_interview_plan` VALUES (9, '齐力辉', '13766998945', '1203313263@qq.com', '2021-04-25 18:16:41', 3, 0, '2021-04-25 18:17:05', NULL);
INSERT INTO `b_interview_plan` VALUES (10, '王', '13755668749', '1203313263@qq.com', '2021-04-26 10:48:23', 4, 0, '2021-04-26 10:48:59', NULL);
INSERT INTO `b_interview_plan` VALUES (11, '赵', '13455669874', '1203313263@qq.com', '2021-04-20 10:50:46', 3, 1, '2021-04-26 10:51:15', NULL);
INSERT INTO `b_interview_plan` VALUES (12, '小明', '13699885461', '811386782@qq.com', '2021-04-27 11:05:35', 16, 1, '2021-04-26 11:06:03', NULL);
INSERT INTO `b_interview_plan` VALUES (13, 'xx', '12333332123', '1203313263@qq.com', '2021-04-27 11:05:35', 3, 1, '2021-04-26 11:12:33', NULL);
INSERT INTO `b_interview_plan` VALUES (15, '刘清华', '12033668947', '1203313263@qq.com', '2021-04-29 11:30:51', 8, 1, '2021-04-26 11:33:00', NULL);
INSERT INTO `b_interview_plan` VALUES (16, '哈哈', '13766998947', '1203313263@qq.com', '2021-04-20 19:45:20', 4, 0, '2021-04-26 19:46:37', NULL);

-- ----------------------------
-- Table structure for b_merit_set
-- ----------------------------
DROP TABLE IF EXISTS `b_merit_set`;
CREATE TABLE `b_merit_set`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `set_date` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日期',
  `month_quota` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '月考核指标',
  `week_quota` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '周考核指标',
  `create_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '绩效设置' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_merit_set
-- ----------------------------
INSERT INTO `b_merit_set` VALUES (2, '2020-12-13', '400', '100', NULL, NULL);
INSERT INTO `b_merit_set` VALUES (5, '2021-04-26', '1200', '300', NULL, NULL);
INSERT INTO `b_merit_set` VALUES (6, '2021-03-31', '1000', '250', NULL, NULL);
INSERT INTO `b_merit_set` VALUES (7, '2021-03-31', '1000', '250', NULL, NULL);
INSERT INTO `b_merit_set` VALUES (8, '2021-03-31', '1000', '250', NULL, NULL);
INSERT INTO `b_merit_set` VALUES (9, '2021-03-31', '1000', '250', NULL, NULL);
INSERT INTO `b_merit_set` VALUES (10, '2021-03-31', '1000', '250', NULL, NULL);
INSERT INTO `b_merit_set` VALUES (11, '2021-04-26', '400', '100', NULL, NULL);

-- ----------------------------
-- Table structure for b_recruit_need
-- ----------------------------
DROP TABLE IF EXISTS `b_recruit_need`;
CREATE TABLE `b_recruit_need`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dept` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '需求部门',
  `need_num` int(11) NULL DEFAULT NULL COMMENT '需求人数',
  `post` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位类型',
  `education` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历要求',
  `work_time` int(11) NULL DEFAULT NULL COMMENT '工作年限要求',
  `demand` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '招聘要求',
  `status` int(11) NULL DEFAULT NULL COMMENT '需求状态',
  `recruit_user_id` bigint(20) NULL DEFAULT NULL COMMENT '招聘负责人',
  `need_user_id` bigint(20) NULL DEFAULT NULL COMMENT '需求负责人',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '招聘需求' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_recruit_need
-- ----------------------------
INSERT INTO `b_recruit_need` VALUES (5, NULL, 2, '财务专员', '本科', 2, '有相关助理经验', 0, 4, 3, '2020-05-17 08:58:47', NULL);
INSERT INTO `b_recruit_need` VALUES (6, NULL, 12, 'JAVA开发', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (7, NULL, 12, 'JAVA开发', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (8, NULL, 12, 'web开发', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (9, NULL, 12, 'JAVA开发', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (10, NULL, 12, 'JAVA开发', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (11, NULL, 5, 'JAVA开发', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (12, NULL, 12, '服务器开发', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (13, NULL, 12, '人事专员', '本科', 2, '无', 1, 3, 4, '2021-04-23 20:33:05', NULL);
INSERT INTO `b_recruit_need` VALUES (14, NULL, 10, '数据分析师', '硕士', 3, '985毕业', 0, 3, 4, '2021-04-26 20:05:57', NULL);

-- ----------------------------
-- Table structure for b_salary_record
-- ----------------------------
DROP TABLE IF EXISTS `b_salary_record`;
CREATE TABLE `b_salary_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `salary_month` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工资月份',
  `must_salary` float NULL DEFAULT 0 COMMENT '应发工资',
  `reality_salary` float NULL DEFAULT 0 COMMENT '实发工资',
  `fund_amount` float NULL DEFAULT 0 COMMENT '公积金扣款',
  `tax_amount` float NULL DEFAULT 0 COMMENT '个税扣款',
  `medical_amount` float NULL DEFAULT 0 COMMENT '医保扣款',
  `pension_amount` float NULL DEFAULT 0 COMMENT '养老扣款',
  `injured_amount` float NULL DEFAULT 0 COMMENT '工伤扣款',
  `birth_amount` float NULL DEFAULT 0 COMMENT '生育扣款',
  `unemployment_amount` float NULL DEFAULT 0 COMMENT '失业扣款',
  `leave_amount` float NULL DEFAULT 0 COMMENT '请假扣款',
  `late_amount` float NULL DEFAULT 0 COMMENT '迟到扣款',
  `base_amount` float NULL DEFAULT 0 COMMENT '基本工资',
  `work_amount` float NULL DEFAULT 0 COMMENT '工龄工资',
  `overtime_amount` float NULL DEFAULT 0 COMMENT '加班费',
  `merits_amount` float NULL DEFAULT 0 COMMENT '绩效奖金',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `salary_sum` float NULL DEFAULT NULL COMMENT '工资总数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工资记录' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_salary_record
-- ----------------------------
INSERT INTO `b_salary_record` VALUES (29, 8, '2021-04', 3000, 0, 50, 50, 1000, 50, 450, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-23 19:34:47', NULL, 3400);
INSERT INTO `b_salary_record` VALUES (30, 2, '2021-04', 2000, 0, 100, 50, 50, 40, 460, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-23 19:42:10', NULL, 1400);
INSERT INTO `b_salary_record` VALUES (31, 8, '2021-01', 2000, 0, 100, 200, 3000, 30, 400, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-23 19:44:24', NULL, 4270);
INSERT INTO `b_salary_record` VALUES (32, 13, '2021-04', 20000, 0, 0, 0, 20000, 1200, 1800, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-23 19:50:35', NULL, 37000);
INSERT INTO `b_salary_record` VALUES (33, 4, '2021-04', 3000, 0, 200, 100, 5000, 50, 350, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-23 20:38:08', NULL, 7300);
INSERT INTO `b_salary_record` VALUES (34, 8, '2020-03', 200, 0, 50, 50, 100, 50, 50, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-24 15:50:02', NULL, 100);
INSERT INTO `b_salary_record` VALUES (35, 14, '2021-04', 100000000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-24 20:24:11', NULL, 100000000);
INSERT INTO `b_salary_record` VALUES (36, 16, '2021-04', 100000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 11:01:24', NULL, 100000);
INSERT INTO `b_salary_record` VALUES (37, 2, '2020-01', 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 12:53:40', NULL, 1000);
INSERT INTO `b_salary_record` VALUES (38, 2, '2020-02', 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 12:54:03', NULL, 1000);
INSERT INTO `b_salary_record` VALUES (39, 3, '2020-01', 1000, 0, 2, 2, 2, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 12:54:21', NULL, 994);
INSERT INTO `b_salary_record` VALUES (41, 3, '2021-01', 5000, 0, 0, 500, 450, 100, 1520, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 14:46:37', NULL, 3330);
INSERT INTO `b_salary_record` VALUES (42, 14, '2021-02', 5000, 0, 50, 50, 50, 10, 200, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 15:27:24', NULL, 4740);
INSERT INTO `b_salary_record` VALUES (43, 8, '2021-03', 5000, 0, 600, 500, 2000, 500, 500, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 15:33:27', NULL, 4875);
INSERT INTO `b_salary_record` VALUES (44, 8, '2020-12', 5000, 0, 500, 500, 5000, 645, 3000, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 15:45:20', NULL, 5355);
INSERT INTO `b_salary_record` VALUES (45, 3, '2020-05', 5000, 0, 100, 120, 15, 402, 10, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 19:24:40', NULL, 4383);
INSERT INTO `b_salary_record` VALUES (46, 12, '2020-02', 2000, 0, 50, 20, 500, 128, 100, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 19:49:11', NULL, 2202);
INSERT INTO `b_salary_record` VALUES (47, 8, '2021-07', 20000, 0, 500, 200, 400, 3620, 1200, 0, 0, 0, 0, 0, 0, 0, 0, '2021-04-26 20:08:15', NULL, 14880);

-- ----------------------------
-- Table structure for b_train_plan
-- ----------------------------
DROP TABLE IF EXISTS `b_train_plan`;
CREATE TABLE `b_train_plan`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主键',
  `train_date` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日期',
  `content` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容',
  `participant` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参加人员',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '培训计划' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_train_plan
-- ----------------------------
INSERT INTO `b_train_plan` VALUES (4, '培训员工代码能力', '2021-04-25', '大家一起观看学习视频', '研发部所有人员', NULL, NULL);

-- ----------------------------
-- Table structure for b_user_doc
-- ----------------------------
DROP TABLE IF EXISTS `b_user_doc`;
CREATE TABLE `b_user_doc`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '员工id',
  `education` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历',
  `birth` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生日',
  `entry_date` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入职日期',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `user_no` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户邮箱',
  `dept_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '员工档案' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_user_doc
-- ----------------------------
INSERT INTO `b_user_doc` VALUES (18, 2, '本科', '1998-03-06', '2021-04-26', '2021-04-26 18:09:55', NULL, '0002', '13766998954', '1203313263@qq.com', '5');
INSERT INTO `b_user_doc` VALUES (19, 3, '本科', '1998-06-30', '2021-04-19', '2021-04-26 18:10:39', NULL, '0003', '13766998956', '1203313263@163.com', '6');
INSERT INTO `b_user_doc` VALUES (20, 8, '本科', '1998-06-25', '2021-04-12', '2021-04-26 18:56:54', NULL, '0008', '13766998947', '1203313263@qq.com', '4');
INSERT INTO `b_user_doc` VALUES (22, 4, '硕士', '1999-04-21', '2021-04-25', '2021-04-27 12:19:17', NULL, '0004', '13766998947', '1203313263@qq.com', '7');
INSERT INTO `b_user_doc` VALUES (23, 13, '本科', '1999-04-20', '2021-04-19', '2021-04-27 12:20:34', NULL, '0013', '13766998947', '1203313263@qq.com', '7');
INSERT INTO `b_user_doc` VALUES (24, 12, '本科', '2009-04-06', '2021-04-27', '2021-04-27 12:34:00', NULL, '0012', '13766998947', '2229324592@qq.com', '5');
INSERT INTO `b_user_doc` VALUES (25, 15, '硕士', '1997-03-05', '2021-04-12', '2021-04-27 12:36:18', NULL, '0015', '13766998947', '315335718@qq.com', '4');

-- ----------------------------
-- Table structure for b_user_plan
-- ----------------------------
DROP TABLE IF EXISTS `b_user_plan`;
CREATE TABLE `b_user_plan`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '员工',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '计划名称',
  `start_date` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开始日期',
  `end_date` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结束日期',
  `status` int(11) NULL DEFAULT 0 COMMENT '计划状态',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
  `content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '个人计划' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_user_plan
-- ----------------------------
INSERT INTO `b_user_plan` VALUES (34, 2, '学习Springboot', '2021-04-25', '2020-05-30', 0, '2020-05-17 08:48:20', '2021-04-25 22:20:56', '在慕课网每天一课');
INSERT INTO `b_user_plan` VALUES (35, 2, '完成实习的一周工作', '2021-04-20', '2021-04-25', 0, '2020-05-17 08:49:10', '2021-04-25 22:21:35', '每天都要认真工作');
INSERT INTO `b_user_plan` VALUES (36, 4, '开展5.1员工素养培训', '2021-04-06', '2020-05-13', 1, '2020-05-17 09:09:42', '2021-04-25 22:22:28', '围绕企业规划进行探讨');
INSERT INTO `b_user_plan` VALUES (37, 1, '完成论文的撰写', '2021-04-25', '2021-04-30', 0, '2021-04-25 22:22:54', NULL, '一天写一节。');
INSERT INTO `b_user_plan` VALUES (38, 1, '完成论文的撰写', '2021-04-25', '2021-04-30', 1, '2021-04-25 22:22:54', '2021-04-26 19:51:45', '一天写一节。');
INSERT INTO `b_user_plan` VALUES (39, 1, '完成论文的撰写', '2021-04-25', '2021-04-30', 0, '2021-04-25 22:22:54', NULL, '一天写一节。');
INSERT INTO `b_user_plan` VALUES (40, 1, '完成论文的撰写', '2021-04-25', '2021-04-30', 0, '2021-04-25 22:22:54', NULL, '一天写一节。');
INSERT INTO `b_user_plan` VALUES (41, 1, '完成论文的撰写', '2021-04-25', '2021-04-30', 0, '2021-04-25 22:22:54', NULL, '一天写一节。');

-- ----------------------------
-- Table structure for b_work_daily
-- ----------------------------
DROP TABLE IF EXISTS `b_work_daily`;
CREATE TABLE `b_work_daily`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '员工id',
  `work_month` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作月份',
  `work_date` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作日期',
  `work_content` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工作内容',
  `progress` int(11) NULL DEFAULT NULL COMMENT '完成进度',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '工作日报' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_work_daily
-- ----------------------------
INSERT INTO `b_work_daily` VALUES (6, 2, '2020-05', '2021-04-25', '完成代码bug的修改', 100, '2020-05-17 08:49:56', '2021-04-25 22:23:27');
INSERT INTO `b_work_daily` VALUES (7, 2, '2020-05', '2020-05-16', '完成论文第一章', 100, '2020-05-17 08:50:41', '2021-04-25 22:23:44');
INSERT INTO `b_work_daily` VALUES (8, 4, '2020-05', '2020-05-17', '进行招聘工作', 50, '2020-05-17 09:10:18', '2021-04-25 22:24:03');
INSERT INTO `b_work_daily` VALUES (9, 1, '2021-04', '2021-04-25', 'test', 100, '2021-04-25 18:35:02', '2021-04-25 18:43:07');

-- ----------------------------
-- Table structure for b_work_record
-- ----------------------------
DROP TABLE IF EXISTS `b_work_record`;
CREATE TABLE `b_work_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '员工id',
  `work_date` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作日期',
  `up_time` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上班时间',
  `down_time` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下班时间',
  `status` int(11) NULL DEFAULT 4 COMMENT '状态',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `work_month` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `up_status` int(11) NULL DEFAULT NULL COMMENT '上班状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出勤记录' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of b_work_record
-- ----------------------------
INSERT INTO `b_work_record` VALUES (48, 1, '2021-04-06', '07:26:55', NULL, 0, '2021-04-25 15:27:08', NULL, '2021-04', 0);
INSERT INTO `b_work_record` VALUES (49, 1, '2021-04-07', '07:31:17', NULL, 0, '2021-04-25 15:34:44', NULL, '2021-04', 0);
INSERT INTO `b_work_record` VALUES (50, 1, '2021-04-08', '07:39:42', NULL, 0, '2021-04-25 15:39:54', NULL, '2021-04', 0);
INSERT INTO `b_work_record` VALUES (51, 1, '2021-04-10', '07:48:56', '17:39:42', 2, '2021-04-25 15:49:07', '2021-04-25 17:40:33', '2021-04', 0);
INSERT INTO `b_work_record` VALUES (52, 1, '2021-04-13', '09:21:27', '19:40:10', 0, '2021-04-25 16:21:39', '2021-04-25 17:41:11', '2021-04', 0);
INSERT INTO `b_work_record` VALUES (58, 1, '2021-04-26', '08:01:49', NULL, 4, '2021-04-25 18:02:03', NULL, '2021-04', 0);
INSERT INTO `b_work_record` VALUES (59, 8, '2021-04-01', '08:59:59', '19:59:59', 0, '2021-04-25 20:00:10', '2021-04-25 20:00:40', '2021-04', 0);
INSERT INTO `b_work_record` VALUES (60, 8, '2021-04-02', '06:00:45', '20:02:45', 3, '2021-04-25 20:01:00', '2021-04-25 20:01:10', '2021-04', 0);
INSERT INTO `b_work_record` VALUES (61, 8, '2021-04-03', '09:00:45', '18:00:45', 0, '2021-04-25 20:01:30', '2021-04-25 20:03:51', '2021-04', 0);
INSERT INTO `b_work_record` VALUES (63, 8, '2021-04-11', '06:05:07', '22:08:10', 3, '2021-04-25 20:06:12', '2021-04-25 20:06:34', '2021-04', 0);
INSERT INTO `b_work_record` VALUES (64, 8, '2021-04-19', '08:05:07', '18:05:07', 4, '2021-04-25 20:06:50', '2021-04-25 20:06:58', '2021-04', 0);
INSERT INTO `b_work_record` VALUES (65, 1, '2021-04-12', '10:08:54', '18:05:54', 2, '2021-04-25 20:09:10', '2021-04-25 20:11:59', '2021-04', 1);
INSERT INTO `b_work_record` VALUES (66, 1, '2021-04-27', '10:25:45', NULL, 4, '2021-04-26 19:26:28', NULL, '2021-04', 1);
INSERT INTO `b_work_record` VALUES (67, 1, '2021-03-16', '09:09:33', NULL, 4, '2021-04-26 20:09:47', NULL, '2021-03', 1);
INSERT INTO `b_work_record` VALUES (68, 4, '2021-04-01', '06:50:47', '16:50:47', 2, '2021-04-27 12:50:55', '2021-04-27 12:51:09', '2021-04', 0);

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `param_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'key',
  `param_value` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `param_key`(`param_key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置信息表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', 0, '云存储配置信息');

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`  (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '上级部门ID，一级部门为0',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名称',
  `order_num` int(11) NULL DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '是否删除  -1：已删除  0：正常',
  PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门管理' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES (1, 0, 'xxxxx技术有限公司', 0, 0);
INSERT INTO `sys_dept` VALUES (2, 1, '长沙分公司', 1, -1);
INSERT INTO `sys_dept` VALUES (3, 1, 'xxxxx技术有限公司上海分部', 2, 0);
INSERT INTO `sys_dept` VALUES (4, 3, '研发部', 0, 0);
INSERT INTO `sys_dept` VALUES (5, 3, '销售部', 1, 0);
INSERT INTO `sys_dept` VALUES (6, 3, '财务部', 0, 0);
INSERT INTO `sys_dept` VALUES (7, 3, '人事部', 0, 0);
INSERT INTO `sys_dept` VALUES (8, 3, '后勤管理部', 0, 0);

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称',
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典类型',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典码',
  `value` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典值',
  `order_num` int(11) NULL DEFAULT 0 COMMENT '排序',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标记  -1：已删除  0：正常',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `type`(`type`, `code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据字典表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES (1, '性别', 'sex', '0', '女', 0, NULL, 0);
INSERT INTO `sys_dict` VALUES (2, '性别', 'sex', '1', '男', 1, NULL, 0);
INSERT INTO `sys_dict` VALUES (3, '性别', 'sex', '2', '未知', 3, NULL, 0);
INSERT INTO `sys_dict` VALUES (4, '工作状态', 'work_status', '0', '正常', 0, '0-正常；1-迟到；2-早退；3加班', 0);
INSERT INTO `sys_dict` VALUES (5, '工作状态', 'work_status', '1', '迟到', 1, '迟到', 0);
INSERT INTO `sys_dict` VALUES (6, '工作状态', 'work_status', '2', '早退', 2, '早退', 0);
INSERT INTO `sys_dict` VALUES (7, '工作状态', 'work_status', '3', '加班', 3, '加班', 0);

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 331 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO `sys_log` VALUES (1, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"wdc\",\"name\":\"王大锤\",\"salt\":\"1sbkoGf5x7Q5lqxvCs5I\",\"email\":\"1111@qq.com\",\"mobile\":\"18651234456\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"May 15, 2020 10:29:02 PM\",\"deptId\":4,\"deptName\":\"生产部\"}', 179, '0:0:0:0:0:0:0:1', '2020-05-31 12:26:17');
INSERT INTO `sys_log` VALUES (2, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":3,\"username\":\"cw\",\"name\":\"财务小王\",\"salt\":\"2E5mvF1xjXFoY0narVz9\",\"email\":\"gy@qq.com\",\"mobile\":\"13455676543\",\"status\":1,\"roleIdList\":[3],\"createTime\":\"May 16, 2020 3:11:08 PM\",\"deptId\":6,\"deptName\":\"财务部\"}', 19, '0:0:0:0:0:0:0:1', '2020-05-31 12:26:29');
INSERT INTO `sys_log` VALUES (3, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":4,\"username\":\"rs\",\"name\":\"人事小李\",\"salt\":\"NF4cYNKNmsMA997exGGN\",\"email\":\"zf@qq.com\",\"mobile\":\"19877678790\",\"status\":1,\"roleIdList\":[4],\"createTime\":\"May 16, 2020 3:11:43 PM\",\"deptId\":7,\"deptName\":\"人事部\"}', 17, '0:0:0:0:0:0:0:1', '2020-05-31 12:26:38');
INSERT INTO `sys_log` VALUES (4, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":21,\"userId\":3,\"salaryMonth\":\"2020-04\",\"mustSalary\":4500.0,\"realitySalary\":4300.0,\"createTime\":\"2020-05-31 14:42:48\"}', 58, '0:0:0:0:0:0:0:1', '2020-05-31 14:42:48');
INSERT INTO `sys_log` VALUES (5, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":6,\"candidate\":\"刘琦琦\",\"candidateMobile\":\"18723409981\",\"meetTime\":\"2020-05-20 08:58:55\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2020-05-17 08:59:28\"}', 84, '0:0:0:0:0:0:0:1', '2020-05-31 22:23:58');
INSERT INTO `sys_log` VALUES (6, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":6,\"candidate\":\"刘琦琦\",\"candidateMobile\":\"18723409981\",\"meetTime\":\"2020-05-20 08:58:55\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2020-05-17 08:59:28\"}', 7, '0:0:0:0:0:0:0:1', '2020-05-31 22:25:01');
INSERT INTO `sys_log` VALUES (7, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":6,\"candidate\":\"刘琦琦\",\"candidateMobile\":\"18723409981\",\"meetTime\":\"2020-05-20 08:58:55\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2020-05-17 08:59:28\"}', 93154, '0:0:0:0:0:0:0:1', '2020-05-31 22:28:18');
INSERT INTO `sys_log` VALUES (8, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":6,\"candidate\":\"刘琦琦\",\"candidateMobile\":\"18723409981\",\"meetTime\":\"2020-05-20 08:58:55\",\"meetUserId\":3,\"status\":2,\"createTime\":\"2020-05-17 08:59:28\"}', 7, '0:0:0:0:0:0:0:1', '2020-05-31 22:28:29');
INSERT INTO `sys_log` VALUES (9, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":22,\"userId\":6,\"salaryMonth\":\"2020-06\",\"mustSalary\":3000.0,\"realitySalary\":500.0,\"fundAmount\":50.0,\"taxAmount\":30.0,\"medicalAmount\":150.0,\"pensionAmount\":210.0,\"injuredAmount\":650.0,\"createTime\":\"2020-05-31 22:54:07\"}', 62, '0:0:0:0:0:0:0:1', '2020-05-31 22:54:07');
INSERT INTO `sys_log` VALUES (10, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":92,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"绩效考核\",\"type\":0,\"orderNum\":0}', 25, '0:0:0:0:0:0:0:1', '2020-06-01 21:22:19');
INSERT INTO `sys_log` VALUES (11, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":43,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"培训管理\",\"type\":0,\"icon\":\"fa fa-street-view\",\"orderNum\":5}', 12, '0:0:0:0:0:0:0:1', '2020-06-01 21:22:58');
INSERT INTO `sys_log` VALUES (12, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":93,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"考核设置\",\"url\":\"#\",\"perms\":\"#\",\"type\":1,\"orderNum\":0}', 8, '0:0:0:0:0:0:0:1', '2020-06-01 21:24:02');
INSERT INTO `sys_log` VALUES (13, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":92,\"parentName\":\"绩效考核\",\"name\":\"考核设置\",\"url\":\"#\",\"perms\":\"#\",\"type\":1,\"orderNum\":0}', 15, '0:0:0:0:0:0:0:1', '2020-06-01 21:24:24');
INSERT INTO `sys_log` VALUES (14, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":92,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"绩效考核\",\"type\":0,\"icon\":\"fa fa-bar-chart\",\"orderNum\":0}', 6, '0:0:0:0:0:0:0:1', '2020-06-01 21:25:23');
INSERT INTO `sys_log` VALUES (15, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":94,\"parentId\":93,\"parentName\":\"考核设置\",\"name\":\"查看\",\"type\":2,\"orderNum\":0}', 11, '0:0:0:0:0:0:0:1', '2020-06-01 21:26:19');
INSERT INTO `sys_log` VALUES (16, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":95,\"parentId\":93,\"parentName\":\"考核设置\",\"name\":\"增加\",\"type\":2,\"orderNum\":0}', 7, '0:0:0:0:0:0:0:1', '2020-06-01 21:26:39');
INSERT INTO `sys_log` VALUES (17, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":96,\"parentId\":93,\"parentName\":\"考核设置\",\"name\":\"编辑\",\"type\":2,\"orderNum\":0}', 8, '0:0:0:0:0:0:0:1', '2020-06-01 21:26:52');
INSERT INTO `sys_log` VALUES (18, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":97,\"parentId\":93,\"parentName\":\"考核设置\",\"name\":\"删除\",\"type\":2,\"orderNum\":0}', 14, '0:0:0:0:0:0:0:1', '2020-06-01 21:27:03');
INSERT INTO `sys_log` VALUES (19, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":98,\"parentId\":43,\"parentName\":\"培训管理\",\"name\":\"培训计划\",\"url\":\"#\",\"type\":1,\"orderNum\":0}', 11, '0:0:0:0:0:0:0:1', '2020-06-01 21:28:55');
INSERT INTO `sys_log` VALUES (20, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":92,\"parentName\":\"绩效考核\",\"name\":\"考核设置\",\"url\":\"/person/merit/list\",\"perms\":\"#\",\"type\":1,\"orderNum\":0}', 16, '0:0:0:0:0:0:0:1', '2020-06-02 20:49:58');
INSERT INTO `sys_log` VALUES (21, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":92,\"parentName\":\"绩效考核\",\"name\":\"考核设置\",\"url\":\"modules/person/merit.html\",\"perms\":\"#\",\"type\":1,\"orderNum\":0}', 11, '0:0:0:0:0:0:0:1', '2020-06-02 20:50:43');
INSERT INTO `sys_log` VALUES (22, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":94,\"parentId\":93,\"parentName\":\"考核设置\",\"name\":\"查看\",\"perms\":\"person:merit:list,person:merit:info\",\"type\":2,\"orderNum\":0}', 9, '0:0:0:0:0:0:0:1', '2020-06-02 20:51:53');
INSERT INTO `sys_log` VALUES (23, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":99,\"parentId\":98,\"parentName\":\"培训计划\",\"name\":\"查看\",\"perms\":\"person:train:list,person:train:info\",\"type\":2,\"orderNum\":0}', 15, '0:0:0:0:0:0:0:1', '2020-06-02 20:54:35');
INSERT INTO `sys_log` VALUES (24, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":100,\"parentId\":98,\"parentName\":\"培训计划\",\"name\":\"新增\",\"perms\":\"person:train:save\",\"type\":2,\"orderNum\":0}', 8, '0:0:0:0:0:0:0:1', '2020-06-02 20:54:54');
INSERT INTO `sys_log` VALUES (25, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":101,\"parentId\":98,\"parentName\":\"培训计划\",\"name\":\"编辑\",\"perms\":\"person:train:update\",\"type\":2,\"orderNum\":0}', 14, '0:0:0:0:0:0:0:1', '2020-06-02 20:55:13');
INSERT INTO `sys_log` VALUES (26, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":102,\"parentId\":98,\"parentName\":\"培训计划\",\"name\":\"删除\",\"perms\":\"person:train:delete\",\"type\":2,\"orderNum\":0}', 8, '0:0:0:0:0:0:0:1', '2020-06-02 20:55:30');
INSERT INTO `sys_log` VALUES (27, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":98,\"parentId\":43,\"parentName\":\"培训管理\",\"name\":\"培训计划\",\"url\":\"modules/person/train.html\",\"type\":1,\"orderNum\":0}', 9, '0:0:0:0:0:0:0:1', '2020-06-02 20:56:34');
INSERT INTO `sys_log` VALUES (28, 'admin', '保存培训计划', 'com.person.modules.person.controller.TrainPlanController.save()', '{\"id\":1,\"title\":\"新员工培训\",\"trainDate\":\"2020-01-01\",\"content\":\"培训公司安全规范\",\"participant\":\"所有新员工\"}', 96, '0:0:0:0:0:0:0:1', '2020-06-02 21:04:01');
INSERT INTO `sys_log` VALUES (29, 'admin', '保存培训计划', 'com.person.modules.person.controller.TrainPlanController.save()', '{\"id\":2,\"title\":\"测试\",\"trainDate\":\"2020-06-03\",\"content\":\"测试\",\"participant\":\"测试\"}', 7, '0:0:0:0:0:0:0:1', '2020-06-02 21:07:13');
INSERT INTO `sys_log` VALUES (30, 'admin', '修改培训计划', 'com.person.modules.person.controller.TrainPlanController.update()', '{\"id\":2,\"title\":\"测试1\",\"trainDate\":\"2020-06-04\",\"content\":\"测试1\",\"participant\":\"测试1\"}', 9, '0:0:0:0:0:0:0:1', '2020-06-02 21:07:22');
INSERT INTO `sys_log` VALUES (31, 'admin', '删除培训计划', 'com.person.modules.person.controller.TrainPlanController.delete()', '[2]', 11, '0:0:0:0:0:0:0:1', '2020-06-02 21:07:28');
INSERT INTO `sys_log` VALUES (32, 'admin', '保存培训计划', 'com.person.modules.person.controller.TrainPlanController.save()', '{\"id\":3,\"title\":\"侧1耳\",\"trainDate\":\"2020-06-17\",\"content\":\"存储\",\"participant\":\"长度\"}', 6, '0:0:0:0:0:0:0:1', '2020-06-02 21:08:07');
INSERT INTO `sys_log` VALUES (33, 'admin', '保存绩效设置', 'com.person.modules.person.controller.MeritController.save()', '{\"id\":1,\"setDate\":\"2020-06-02\",\"monthQuota\":\"11\",\"weekQuota\":\"22\"}', 85, '0:0:0:0:0:0:0:1', '2020-06-02 21:16:35');
INSERT INTO `sys_log` VALUES (34, 'admin', '修改绩效设置', 'com.person.modules.person.controller.MeritController.update()', '{\"id\":1,\"setDate\":\"2020-06-02\",\"monthQuota\":\"113\",\"weekQuota\":\"224\"}', 13, '0:0:0:0:0:0:0:1', '2020-06-02 21:17:08');
INSERT INTO `sys_log` VALUES (35, 'admin', '删除绩效设置', 'com.person.modules.person.controller.MeritController.delete()', '[1]', 9, '0:0:0:0:0:0:0:1', '2020-06-02 21:19:06');
INSERT INTO `sys_log` VALUES (36, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":12,\"userId\":1,\"age\":0,\"deptName\":\"江苏富梓民轮胎厂\",\"deptId\":1,\"education\":\"博士\",\"userNo\":\"0001\",\"birth\":\"1976-06-15\",\"entryDate\":\"2013-06-04\",\"userType\":\"1\",\"createTime\":\"2020-06-04 22:27:49\"}', 178, '0:0:0:0:0:0:0:1', '2020-06-04 22:27:49');
INSERT INTO `sys_log` VALUES (37, 'admin', '保存绩效设置', 'com.person.modules.person.controller.MeritController.save()', '{\"id\":2,\"setDate\":\"2020-12-13\",\"monthQuota\":\"400\",\"weekQuota\":\"100\"}', 72, '0:0:0:0:0:0:0:1', '2020-12-13 16:29:35');
INSERT INTO `sys_log` VALUES (38, 'admin', '修改合同档案', 'com.person.modules.person.controller.ContractController.update()', '{\"id\":2,\"name\":\"材料采购合同\",\"partA\":\"甲方\",\"partB\":\"乙方\",\"signDate\":\"2020-05-14\",\"amount\":38672.65}', 32, '0:0:0:0:0:0:0:1', '2020-12-13 16:58:18');
INSERT INTO `sys_log` VALUES (39, 'admin', '修改合同档案', 'com.person.modules.person.controller.ContractController.update()', '{\"id\":3,\"name\":\"销售合同\",\"partA\":\"华为科技\",\"partB\":\"京东科技\",\"signDate\":\"2020-05-20\",\"amount\":36732.55}', 12, '0:0:0:0:0:0:0:1', '2020-12-13 16:58:44');
INSERT INTO `sys_log` VALUES (40, 'admin', '保存用户', 'com.person.modules.sys.controller.SysUserController.save()', '{\"userId\":7,\"username\":\"123\",\"name\":\"123\",\"password\":\"87119cd5418f2d249bb043398d8436efcd67da8da39592be9ae5f31b87e0eaeb\",\"salt\":\"aWfWc7hNDxzypTm6nV7f\",\"email\":\"1203313264@qq.com\",\"mobile\":\"13744665987\",\"status\":1,\"roleIdList\":[4],\"createTime\":\"Apr 23, 2021 6:12:38 PM\",\"deptId\":5,\"deptName\":\"销售部\"}', 1760, '0:0:0:0:0:0:0:1', '2021-04-23 18:12:40');
INSERT INTO `sys_log` VALUES (41, 'admin', '保存角色', 'com.person.modules.sys.controller.SysRoleController.save()', '{\"roleId\":5,\"roleName\":\"普通员工\",\"remark\":\"普通员工\",\"deptId\":4,\"deptName\":\"生产部\",\"menuIdList\":[41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,92,93,94,95,96,97],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"Apr 23, 2021 6:15:53 PM\"}', 178, '0:0:0:0:0:0:0:1', '2021-04-23 18:15:54');
INSERT INTO `sys_log` VALUES (42, 'admin', '保存用户', 'com.person.modules.sys.controller.SysUserController.save()', '{\"userId\":8,\"username\":\"lqh\",\"name\":\"刘清华\",\"password\":\"499d422f59bbe7665c7660cfb70f8511e7785a7f3bbca2132f08ed7f92f89b36\",\"salt\":\"Qp1dOgRJaFkhFMhe9ETF\",\"email\":\"1203313263@qq.com\",\"mobile\":\"13766998956\",\"status\":1,\"roleIdList\":[5],\"createTime\":\"Apr 23, 2021 6:16:56 PM\",\"deptId\":4,\"deptName\":\"生产部\"}', 1522, '0:0:0:0:0:0:0:1', '2021-04-23 18:16:58');
INSERT INTO `sys_log` VALUES (43, 'admin', '保存用户', 'com.person.modules.sys.controller.SysUserController.save()', '{\"userId\":12,\"username\":\"haiyang\",\"name\":\"海洋\",\"password\":\"90fcfdaef3e5ba0d686d5f0ebfefa25085ba0480f8eceeee9cfd581cdd167021\",\"salt\":\"8ES0qsUNXQALRhoXSXN3\",\"email\":\"2229324592@qq.com\",\"mobile\":\"12344555698\",\"status\":1,\"roleIdList\":[5],\"createTime\":\"Apr 23, 2021 6:28:10 PM\",\"deptId\":5,\"deptName\":\"销售部\"}', 1496, '0:0:0:0:0:0:0:1', '2021-04-23 18:28:10');
INSERT INTO `sys_log` VALUES (44, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":27,\"userId\":6,\"salaryMonth\":\"2020-01\",\"mustSalary\":123.0,\"fundAmount\":1.0,\"taxAmount\":1.0,\"medicalAmount\":1.0,\"pensionAmount\":1.0,\"injuredAmount\":1.0,\"salarySum\":120.0,\"createTime\":\"2021-04-23 19:31:45\"}', 222, '0:0:0:0:0:0:0:1', '2021-04-23 19:31:46');
INSERT INTO `sys_log` VALUES (45, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"userId\":8,\"salaryMonth\":\"2021-03\",\"mustSalary\":125.0,\"fundAmount\":1.0,\"taxAmount\":1.0,\"medicalAmount\":1.0,\"pensionAmount\":1.0,\"injuredAmount\":1.0,\"createTime\":\"2021-04-23 19:33:12\"}', 50, '0:0:0:0:0:0:0:1', '2021-04-23 19:33:12');
INSERT INTO `sys_log` VALUES (46, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":28,\"userId\":8,\"salaryMonth\":\"2021-02\",\"mustSalary\":125.0,\"fundAmount\":1.0,\"taxAmount\":1.0,\"medicalAmount\":1.0,\"pensionAmount\":1.0,\"injuredAmount\":1.0,\"salarySum\":122.0,\"createTime\":\"2021-04-23 19:33:17\"}', 61, '0:0:0:0:0:0:0:1', '2021-04-23 19:33:17');
INSERT INTO `sys_log` VALUES (47, 'admin', '删除工资', 'com.person.modules.person.controller.SalaryRecordController.delete()', '[18,19,20,21,22,23,24,25,26,27]', 163, '0:0:0:0:0:0:0:1', '2021-04-23 19:33:54');
INSERT INTO `sys_log` VALUES (48, 'admin', '删除工资', 'com.person.modules.person.controller.SalaryRecordController.delete()', '[28]', 56, '0:0:0:0:0:0:0:1', '2021-04-23 19:34:01');
INSERT INTO `sys_log` VALUES (49, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":29,\"userId\":8,\"salaryMonth\":\"2021-04\",\"mustSalary\":3000.0,\"fundAmount\":50.0,\"taxAmount\":50.0,\"medicalAmount\":1000.0,\"pensionAmount\":50.0,\"injuredAmount\":450.0,\"salarySum\":3400.0,\"createTime\":\"2021-04-23 19:34:47\"}', 170, '0:0:0:0:0:0:0:1', '2021-04-23 19:34:48');
INSERT INTO `sys_log` VALUES (50, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"wdc\",\"name\":\"王大锤\",\"salt\":\"1sbkoGf5x7Q5lqxvCs5I\",\"email\":\"1203313263@qq.com\",\"mobile\":\"18651234456\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"May 15, 2020 10:29:02 PM\",\"deptId\":4,\"deptName\":\"生产部\"}', 251, '0:0:0:0:0:0:0:1', '2021-04-23 19:40:29');
INSERT INTO `sys_log` VALUES (51, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":3,\"username\":\"cw\",\"name\":\"财务小王\",\"salt\":\"2E5mvF1xjXFoY0narVz9\",\"email\":\"1203313263@qq.com\",\"mobile\":\"13455676543\",\"status\":1,\"roleIdList\":[3],\"createTime\":\"May 16, 2020 3:11:08 PM\",\"deptId\":6,\"deptName\":\"财务部\"}', 179, '0:0:0:0:0:0:0:1', '2021-04-23 19:40:59');
INSERT INTO `sys_log` VALUES (52, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":4,\"username\":\"rs\",\"name\":\"人事小李\",\"salt\":\"NF4cYNKNmsMA997exGGN\",\"email\":\"1203313263@qq.com\",\"mobile\":\"19877678790\",\"status\":1,\"roleIdList\":[4],\"createTime\":\"May 16, 2020 3:11:43 PM\",\"deptId\":7,\"deptName\":\"人事部\"}', 160, '0:0:0:0:0:0:0:1', '2021-04-23 19:41:06');
INSERT INTO `sys_log` VALUES (53, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":5,\"username\":\"存储\",\"name\":\"王婷婷\",\"salt\":\"MVDlRa0lGADPLXgehAH2\",\"email\":\"1203313263@qq.com\",\"mobile\":\"13766994511\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"May 24, 2020 1:38:31 PM\",\"deptId\":4,\"deptName\":\"生产部\"}', 141, '0:0:0:0:0:0:0:1', '2021-04-23 19:41:17');
INSERT INTO `sys_log` VALUES (54, 'admin', '删除用户', 'com.person.modules.sys.controller.SysUserController.delete()', '[6]', 71, '0:0:0:0:0:0:0:1', '2021-04-23 19:41:24');
INSERT INTO `sys_log` VALUES (55, 'admin', '删除用户', 'com.person.modules.sys.controller.SysUserController.delete()', '[7]', 72, '0:0:0:0:0:0:0:1', '2021-04-23 19:41:29');
INSERT INTO `sys_log` VALUES (56, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":30,\"userId\":2,\"salaryMonth\":\"2021-04\",\"mustSalary\":2000.0,\"fundAmount\":100.0,\"taxAmount\":50.0,\"medicalAmount\":50.0,\"pensionAmount\":40.0,\"injuredAmount\":460.0,\"salarySum\":1400.0,\"createTime\":\"2021-04-23 19:42:10\"}', 191, '0:0:0:0:0:0:0:1', '2021-04-23 19:42:10');
INSERT INTO `sys_log` VALUES (57, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":31,\"userId\":8,\"salaryMonth\":\"2021-01\",\"mustSalary\":2000.0,\"fundAmount\":100.0,\"taxAmount\":200.0,\"medicalAmount\":3000.0,\"pensionAmount\":30.0,\"injuredAmount\":400.0,\"salarySum\":4270.0,\"createTime\":\"2021-04-23 19:44:24\"}', 1701, '0:0:0:0:0:0:0:1', '2021-04-23 19:44:26');
INSERT INTO `sys_log` VALUES (58, 'admin', '保存用户', 'com.person.modules.sys.controller.SysUserController.save()', '{\"userId\":13,\"username\":\"dh\",\"name\":\"邓昊\",\"password\":\"fc4bc78a6888a37ed2dacd0d40f5b84f3c7269555734c2616035188317278dc5\",\"salt\":\"x58YJ5oX6qptqwtQOdeK\",\"email\":\"582899640@qq.com\",\"mobile\":\"13766998949\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"Apr 23, 2021 7:46:51 PM\",\"deptId\":7,\"deptName\":\"人事部\"}', 1403, '0:0:0:0:0:0:0:1', '2021-04-23 19:46:52');
INSERT INTO `sys_log` VALUES (59, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":32,\"userId\":13,\"salaryMonth\":\"2021-04\",\"mustSalary\":20000.0,\"fundAmount\":0.0,\"taxAmount\":0.0,\"medicalAmount\":20000.0,\"pensionAmount\":1200.0,\"injuredAmount\":1800.0,\"salarySum\":37000.0,\"createTime\":\"2021-04-23 19:50:35\"}', 1598, '0:0:0:0:0:0:0:1', '2021-04-23 19:50:37');
INSERT INTO `sys_log` VALUES (60, 'admin', '保存用户', 'com.person.modules.sys.controller.SysUserController.save()', '{\"userId\":14,\"username\":\"qlh\",\"name\":\"齐力辉\",\"password\":\"e389bd2668bc97fa28a20f0c937a3af1f8455a2bc284e168ed467809dde33b93\",\"salt\":\"HnlyGNxaS9Mmrqy6V5kI\",\"email\":\"1499910521@qq.com\",\"mobile\":\"13766998987\",\"status\":1,\"roleIdList\":[5],\"createTime\":\"Apr 23, 2021 8:11:19 PM\",\"deptId\":4,\"deptName\":\"生产部\"}', 2049, '0:0:0:0:0:0:0:1', '2021-04-23 20:11:20');
INSERT INTO `sys_log` VALUES (61, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":7,\"candidate\":\"李海洋\",\"candidateMobile\":\"13645468794\",\"meetTime\":\"2021-04-21 20:26:49\",\"meetUserId\":4,\"status\":0,\"createTime\":\"2021-04-23 20:27:18\"}', 67, '0:0:0:0:0:0:0:1', '2021-04-23 20:27:19');
INSERT INTO `sys_log` VALUES (62, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":4,\"username\":\"rs\",\"name\":\"人事小李\",\"password\":\"c4ade571b45f569230b7782b9d657bc6e724913d7d429bf742ad17dabf0753bc\",\"salt\":\"NF4cYNKNmsMA997exGGN\",\"email\":\"1203313263@qq.com\",\"mobile\":\"19877678790\",\"status\":1,\"roleIdList\":[4],\"createTime\":\"May 16, 2020 3:11:43 PM\",\"deptId\":7,\"deptName\":\"人事部\"}', 223, '0:0:0:0:0:0:0:1', '2021-04-23 20:29:36');
INSERT INTO `sys_log` VALUES (63, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":3,\"username\":\"cw\",\"name\":\"财务小王\",\"password\":\"676bd505a6d523cb00f4f79bf6dc7a2954d761a3aee0d045c21f8d6e2172a179\",\"salt\":\"2E5mvF1xjXFoY0narVz9\",\"email\":\"1203313263@qq.com\",\"mobile\":\"13455676543\",\"status\":1,\"roleIdList\":[3],\"createTime\":\"May 16, 2020 3:11:08 PM\",\"deptId\":6,\"deptName\":\"财务部\"}', 113, '0:0:0:0:0:0:0:1', '2021-04-23 20:29:49');
INSERT INTO `sys_log` VALUES (64, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"wdc\",\"name\":\"王大锤\",\"password\":\"a977e04a469ee5b213c31dc60d03f75de2bfeda871f465c723c304313f748e7d\",\"salt\":\"1sbkoGf5x7Q5lqxvCs5I\",\"email\":\"1203313263@qq.com\",\"mobile\":\"18651234456\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"May 15, 2020 10:29:02 PM\",\"deptId\":4,\"deptName\":\"生产部\"}', 141, '0:0:0:0:0:0:0:1', '2021-04-23 20:29:57');
INSERT INTO `sys_log` VALUES (65, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"上海分公司\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,74,52,77,79],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 216, '0:0:0:0:0:0:0:1', '2021-04-23 20:32:42');
INSERT INTO `sys_log` VALUES (66, 'admin', '保存招聘要求', 'com.person.modules.person.controller.RecruitNeedController.save()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":0,\"recruitUserId\":3,\"needUserId\":4,\"createTime\":\"2021-04-23 20:33:05\"}', 51, '0:0:0:0:0:0:0:1', '2021-04-23 20:33:05');
INSERT INTO `sys_log` VALUES (67, 'admin', '审核', 'com.person.modules.person.controller.ConvertApplyController.approval()', '{\"id\":6,\"applyUserId\":4,\"applyDate\":\"2020-05-17\",\"applyContent\":\"申请转正\",\"status\":2,\"approvalUserId\":1,\"approvalResult\":2,\"createTime\":\"2020-05-17 09:10:40\",\"updateTime\":\"2021-04-23 20:37:15\"}', 137, '0:0:0:0:0:0:0:1', '2021-04-23 20:37:15');
INSERT INTO `sys_log` VALUES (68, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":33,\"userId\":4,\"salaryMonth\":\"2021-04\",\"mustSalary\":3000.0,\"fundAmount\":200.0,\"taxAmount\":100.0,\"medicalAmount\":5000.0,\"pensionAmount\":50.0,\"injuredAmount\":350.0,\"salarySum\":7300.0,\"createTime\":\"2021-04-23 20:38:08\"}', 1700, '0:0:0:0:0:0:0:1', '2021-04-23 20:38:10');
INSERT INTO `sys_log` VALUES (69, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":4,\"roleName\":\"人事专员\",\"remark\":\"人事专员\",\"deptId\":3,\"deptName\":\"上海分公司\",\"menuIdList\":[1,2,15,16,17,18,31,32,41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,73,74,75,76,52,77,78,79,80,45,53,69,70,71,72],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:31:13 PM\"}', 140, '0:0:0:0:0:0:0:1', '2021-04-23 20:39:38');
INSERT INTO `sys_log` VALUES (70, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"上海分公司\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,92,93,94],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 142, '0:0:0:0:0:0:0:1', '2021-04-23 20:48:51');
INSERT INTO `sys_log` VALUES (71, 'admin', '修改绩效设置', 'com.person.modules.person.controller.MeritController.update()', '{\"id\":2,\"setDate\":\"2020-12-13\",\"monthQuota\":\"400\",\"weekQuota\":\"100\"}', 50, '0:0:0:0:0:0:0:1', '2021-04-24 15:49:27');
INSERT INTO `sys_log` VALUES (72, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":34,\"userId\":8,\"salaryMonth\":\"2020-03\",\"mustSalary\":200.0,\"fundAmount\":50.0,\"taxAmount\":50.0,\"medicalAmount\":100.0,\"pensionAmount\":50.0,\"injuredAmount\":50.0,\"salarySum\":100.0,\"createTime\":\"2021-04-24 15:50:02\"}', 1885, '0:0:0:0:0:0:0:1', '2021-04-24 15:50:05');
INSERT INTO `sys_log` VALUES (73, 'admin', '保存绩效设置', 'com.person.modules.person.controller.MeritController.save()', '{\"id\":3,\"monthQuota\":\"400\",\"weekQuota\":\"123\"}', 68, '0:0:0:0:0:0:0:1', '2021-04-24 15:50:20');
INSERT INTO `sys_log` VALUES (74, 'admin', '删除绩效设置', 'com.person.modules.person.controller.MeritController.delete()', '[3]', 135, '0:0:0:0:0:0:0:1', '2021-04-24 15:50:30');
INSERT INTO `sys_log` VALUES (75, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 200, '0:0:0:0:0:0:0:1', '2021-04-24 16:00:46');
INSERT INTO `sys_log` VALUES (76, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 3, '0:0:0:0:0:0:0:1', '2021-04-24 16:01:12');
INSERT INTO `sys_log` VALUES (77, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 16:01:15');
INSERT INTO `sys_log` VALUES (78, 'admin', '保存招聘要求', 'com.person.modules.person.controller.RecruitNeedController.save()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 202, '0:0:0:0:0:0:0:1', '2021-04-24 16:10:10');
INSERT INTO `sys_log` VALUES (79, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 4, '0:0:0:0:0:0:0:1', '2021-04-24 16:10:28');
INSERT INTO `sys_log` VALUES (80, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 3, '0:0:0:0:0:0:0:1', '2021-04-24 16:10:45');
INSERT INTO `sys_log` VALUES (81, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 16:11:07');
INSERT INTO `sys_log` VALUES (82, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 1, '0:0:0:0:0:0:0:1', '2021-04-24 16:11:17');
INSERT INTO `sys_log` VALUES (83, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 16:13:15');
INSERT INTO `sys_log` VALUES (84, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 1, '0:0:0:0:0:0:0:1', '2021-04-24 16:16:10');
INSERT INTO `sys_log` VALUES (85, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 16:16:20');
INSERT INTO `sys_log` VALUES (86, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 16:17:28');
INSERT INTO `sys_log` VALUES (87, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 16:18:30');
INSERT INTO `sys_log` VALUES (88, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 1, '0:0:0:0:0:0:0:1', '2021-04-24 16:18:42');
INSERT INTO `sys_log` VALUES (89, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 6, '0:0:0:0:0:0:0:1', '2021-04-24 16:25:08');
INSERT INTO `sys_log` VALUES (90, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":7,\"status\":0,\"createTime\":\"2021-04-24 16:10:10\"}', 38, '0:0:0:0:0:0:0:1', '2021-04-24 16:26:52');
INSERT INTO `sys_log` VALUES (91, 'admin', '修改合同档案', 'com.person.modules.person.controller.ContractController.update()', '{\"id\":3,\"name\":\"销售合同\",\"partA\":\"华为科技\",\"partB\":\"京东科技\",\"signDate\":\"2020-05-20\",\"amount\":36732.6}', 5, '0:0:0:0:0:0:0:1', '2021-04-24 16:27:17');
INSERT INTO `sys_log` VALUES (92, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":35,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-24\",\"upTime\":\"16:56:18\",\"status\":1,\"createTime\":\"2021-04-24 16:56:36\"}', 217, '0:0:0:0:0:0:0:1', '2021-04-24 16:56:36');
INSERT INTO `sys_log` VALUES (93, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":35,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-24\",\"upTime\":\"16:56:18\",\"downTime\":\"16:56:18\",\"status\":2,\"createTime\":\"2021-04-24 16:56:36\",\"updateTime\":\"2021-04-24 16:56:47\"}', 74, '0:0:0:0:0:0:0:1', '2021-04-24 16:56:48');
INSERT INTO `sys_log` VALUES (94, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":36,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-15\",\"upTime\":\"16:56:18\",\"status\":1,\"createTime\":\"2021-04-24 16:56:56\"}', 72, '0:0:0:0:0:0:0:1', '2021-04-24 16:56:57');
INSERT INTO `sys_log` VALUES (95, 'admin', '删除招聘要求', 'com.person.modules.person.controller.RecruitNeedController.delete()', '[7]', 141, '0:0:0:0:0:0:0:1', '2021-04-24 17:34:48');
INSERT INTO `sys_log` VALUES (96, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":54,\"parentId\":42,\"parentName\":\"考勤管理\",\"name\":\"考勤记录\",\"url\":\"modules/person/work.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 138, '0:0:0:0:0:0:0:1', '2021-04-24 18:11:24');
INSERT INTO `sys_log` VALUES (97, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 63, '0:0:0:0:0:0:0:1', '2021-04-24 19:22:30');
INSERT INTO `sys_log` VALUES (98, 'admin', '保存绩效设置', 'com.person.modules.person.controller.MeritController.save()', '{\"id\":4,\"monthQuota\":\"123\",\"weekQuota\":\"123\"}', 179, '0:0:0:0:0:0:0:1', '2021-04-24 19:26:53');
INSERT INTO `sys_log` VALUES (99, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"recruitUserId\":3,\"needUserId\":4,\"createTime\":\"2021-04-23 20:33:05\"}', 9, '0:0:0:0:0:0:0:1', '2021-04-24 19:27:40');
INSERT INTO `sys_log` VALUES (100, 'admin', '保存招聘要求', 'com.person.modules.person.controller.RecruitNeedController.save()', '{\"id\":8,\"status\":0,\"createTime\":\"2021-04-24 19:27:52\"}', 109, '0:0:0:0:0:0:0:1', '2021-04-24 19:27:53');
INSERT INTO `sys_log` VALUES (101, 'admin', '删除招聘要求', 'com.person.modules.person.controller.RecruitNeedController.delete()', '[8]', 166, '0:0:0:0:0:0:0:1', '2021-04-24 19:28:35');
INSERT INTO `sys_log` VALUES (102, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"recruitUserId\":3,\"needUserId\":4,\"createTime\":\"2021-04-23 20:33:05\"}', 3, '0:0:0:0:0:0:0:1', '2021-04-24 19:28:48');
INSERT INTO `sys_log` VALUES (103, 'admin', '修改员工档案', 'com.person.modules.person.controller.UserDocController.update()', '{\"id\":11,\"userId\":5,\"age\":0,\"mobile\":\"18677894453\",\"deptId\":8,\"education\":\"本科\",\"userNo\":\"0005\",\"birth\":\"1986-05-30\",\"entryDate\":\"2020-05-04\",\"userType\":\"0\",\"createTime\":\"2020-05-24 21:42:56\"}', 87, '0:0:0:0:0:0:0:1', '2021-04-24 19:34:12');
INSERT INTO `sys_log` VALUES (104, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 7, '0:0:0:0:0:0:0:1', '2021-04-24 19:46:17');
INSERT INTO `sys_log` VALUES (105, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 19:47:03');
INSERT INTO `sys_log` VALUES (106, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":5,\"needNum\":2,\"post\":\"经理助理\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"有相关助理经验\",\"status\":0,\"createTime\":\"2020-05-17 08:58:47\"}', 43, '0:0:0:0:0:0:0:1', '2021-04-24 19:50:00');
INSERT INTO `sys_log` VALUES (107, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":6,\"needNum\":12,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 19:50:11');
INSERT INTO `sys_log` VALUES (108, 'admin', '修改工资', 'com.person.modules.person.controller.SalaryRecordController.update()', '{\"id\":34,\"salaryMonth\":\"2020-03\",\"mustSalary\":200.0,\"realitySalary\":0.0,\"fundAmount\":50.0,\"taxAmount\":50.0,\"medicalAmount\":100.0,\"pensionAmount\":50.0,\"injuredAmount\":50.0,\"salarySum\":100.0,\"birthAmount\":0.0,\"unemploymentAmount\":0.0,\"leaveAmount\":0.0,\"lateAmount\":0.0,\"baseAmount\":0.0,\"workAmount\":0.0,\"overtimeAmount\":0.0,\"meritsAmount\":0.0,\"createTime\":\"2021-04-24 15:50:02\"}', 47, '0:0:0:0:0:0:0:1', '2021-04-24 19:53:45');
INSERT INTO `sys_log` VALUES (109, 'admin', '修改工资', 'com.person.modules.person.controller.SalaryRecordController.update()', '{\"id\":34,\"salaryMonth\":\"2020-03\",\"mustSalary\":200.0,\"realitySalary\":0.0,\"fundAmount\":50.0,\"taxAmount\":50.0,\"medicalAmount\":100.0,\"pensionAmount\":50.0,\"injuredAmount\":50.0,\"salarySum\":100.0,\"birthAmount\":0.0,\"unemploymentAmount\":0.0,\"leaveAmount\":0.0,\"lateAmount\":0.0,\"baseAmount\":0.0,\"workAmount\":0.0,\"overtimeAmount\":0.0,\"meritsAmount\":0.0,\"createTime\":\"2021-04-24 15:50:02\"}', 3, '0:0:0:0:0:0:0:1', '2021-04-24 19:53:50');
INSERT INTO `sys_log` VALUES (110, 'admin', '修改工资', 'com.person.modules.person.controller.SalaryRecordController.update()', '{\"id\":34,\"salaryMonth\":\"2020-03\",\"mustSalary\":200.0,\"realitySalary\":0.0,\"fundAmount\":50.0,\"taxAmount\":50.0,\"medicalAmount\":100.0,\"pensionAmount\":50.0,\"injuredAmount\":50.0,\"salarySum\":100.0,\"birthAmount\":0.0,\"unemploymentAmount\":0.0,\"leaveAmount\":0.0,\"lateAmount\":0.0,\"baseAmount\":0.0,\"workAmount\":0.0,\"overtimeAmount\":0.0,\"meritsAmount\":0.0,\"createTime\":\"2021-04-24 15:50:02\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-24 19:54:26');
INSERT INTO `sys_log` VALUES (111, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":92,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"效绩指标\",\"type\":0,\"icon\":\"\",\"orderNum\":0}', 189, '0:0:0:0:0:0:0:1', '2021-04-24 20:11:13');
INSERT INTO `sys_log` VALUES (112, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":93,\"parentId\":92,\"parentName\":\"效绩指标\",\"name\":\"绩效设置\",\"url\":\"modules/person/merit.html\",\"perms\":\"#\",\"type\":1,\"orderNum\":0}', 60, '0:0:0:0:0:0:0:1', '2021-04-24 20:11:30');
INSERT INTO `sys_log` VALUES (113, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":53,\"parentId\":45,\"parentName\":\"档案管理\",\"name\":\"员工信息\",\"url\":\"modules/person/doc.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 68, '0:0:0:0:0:0:0:1', '2021-04-24 20:11:54');
INSERT INTO `sys_log` VALUES (114, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":44,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"人才招聘\",\"type\":0,\"icon\":\"\",\"orderNum\":1}', 162, '0:0:0:0:0:0:0:1', '2021-04-24 20:13:11');
INSERT INTO `sys_log` VALUES (115, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":51,\"parentId\":44,\"parentName\":\"人才招聘\",\"name\":\"招聘公告\",\"url\":\"modules/person/need.html\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 95, '0:0:0:0:0:0:0:1', '2021-04-24 20:13:28');
INSERT INTO `sys_log` VALUES (116, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":34,\"userId\":3,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-17\",\"upTime\":\"09:12:07\",\"downTime\":\"20:14:03\",\"status\":3,\"createTime\":\"2020-05-17 09:12:08\",\"updateTime\":\"2021-04-24 20:14:12\"}', 184, '0:0:0:0:0:0:0:1', '2021-04-24 20:14:12');
INSERT INTO `sys_log` VALUES (117, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":35,\"userId\":14,\"salaryMonth\":\"2021-04\",\"mustSalary\":1.0E8,\"fundAmount\":0.0,\"taxAmount\":0.0,\"medicalAmount\":0.0,\"pensionAmount\":0.0,\"injuredAmount\":0.0,\"salarySum\":1.0E8,\"createTime\":\"2021-04-24 20:24:11\"}', 1681, '0:0:0:0:0:0:0:1', '2021-04-24 20:24:13');
INSERT INTO `sys_log` VALUES (118, 'admin', '保存用户', 'com.person.modules.sys.controller.SysUserController.save()', '{\"userId\":15,\"username\":\"djq\",\"name\":\"狄家奇\",\"password\":\"e70054b7b076b2a64184218c5bb23b984f6a1bfc5097d455b08c86fce754d098\",\"salt\":\"DKEWsVHzYZm1aCUTTybW\",\"email\":\"315335718@qq.com\",\"mobile\":\"13766998947\",\"status\":1,\"roleIdList\":[5],\"createTime\":\"Apr 24, 2021 8:25:44 PM\",\"deptId\":4,\"deptName\":\"研发部\"}', 1742, '0:0:0:0:0:0:0:1', '2021-04-24 20:25:45');
INSERT INTO `sys_log` VALUES (119, 'admin', '删除绩效设置', 'com.person.modules.person.controller.MeritController.delete()', '[4]', 66, '0:0:0:0:0:0:0:1', '2021-04-24 22:20:25');
INSERT INTO `sys_log` VALUES (120, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,73,52,79,92,93,94],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 279, '0:0:0:0:0:0:0:1', '2021-04-25 11:07:13');
INSERT INTO `sys_log` VALUES (121, 'cw', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":6,\"candidate\":\"刘琦琦\",\"candidateMobile\":\"18723409981\",\"meetTime\":\"2020-05-20 08:58:55\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2020-05-17 08:59:28\"}', 82, '0:0:0:0:0:0:0:1', '2021-04-25 11:08:00');
INSERT INTO `sys_log` VALUES (122, 'cw', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":6,\"candidate\":\"刘琦琦\",\"candidateMobile\":\"18723409981\",\"meetTime\":\"2020-05-20 08:58:55\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2020-05-17 08:59:28\"}', 3, '0:0:0:0:0:0:0:1', '2021-04-25 11:09:01');
INSERT INTO `sys_log` VALUES (123, 'rs', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":7,\"candidate\":\"李海洋\",\"candidateMobile\":\"13645468794\",\"meetTime\":\"2021-04-21 20:26:49\",\"meetUserId\":4,\"status\":1,\"createTime\":\"2021-04-23 20:27:18\"}', 149, '0:0:0:0:0:0:0:1', '2021-04-25 11:13:09');
INSERT INTO `sys_log` VALUES (124, 'rs', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":8,\"candidate\":\"代胜辉\",\"candidateMobile\":\"13766998948\",\"meetTime\":\"2021-04-25 11:12:52\",\"meetUserId\":4,\"status\":0,\"createTime\":\"2021-04-25 11:13:41\"}', 89, '0:0:0:0:0:0:0:1', '2021-04-25 11:13:42');
INSERT INTO `sys_log` VALUES (125, 'rs', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":8,\"candidate\":\"代胜辉\",\"candidateMobile\":\"13766998948\",\"meetTime\":\"2021-04-25 11:12:52\",\"meetUserId\":4,\"status\":0,\"createTime\":\"2021-04-25 11:13:41\"}', 5, '0:0:0:0:0:0:0:1', '2021-04-25 12:51:44');
INSERT INTO `sys_log` VALUES (126, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":43,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"个人申请\",\"type\":0,\"icon\":\"\",\"orderNum\":5}', 174, '0:0:0:0:0:0:0:1', '2021-04-25 13:51:09');
INSERT INTO `sys_log` VALUES (127, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":46,\"parentId\":43,\"parentName\":\"个人申请\",\"name\":\"工作计划\",\"url\":\"modules/person/plan.html\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 177, '0:0:0:0:0:0:0:1', '2021-04-25 13:52:28');
INSERT INTO `sys_log` VALUES (128, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":43,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"工作计划\",\"type\":0,\"icon\":\"\",\"orderNum\":5}', 95, '0:0:0:0:0:0:0:1', '2021-04-25 13:53:09');
INSERT INTO `sys_log` VALUES (129, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":46,\"parentId\":43,\"parentName\":\"工作计划\",\"name\":\"个人规划\",\"url\":\"modules/person/plan.html\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 142, '0:0:0:0:0:0:0:1', '2021-04-25 13:53:35');
INSERT INTO `sys_log` VALUES (130, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":6,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-17\",\"workContent\":\"今日完成领导交代的各项任务\",\"progress\":1000,\"createTime\":\"2020-05-17 08:49:56\",\"updateTime\":\"2021-04-25 13:54:17\"}', 96, '0:0:0:0:0:0:0:1', '2021-04-25 13:54:17');
INSERT INTO `sys_log` VALUES (131, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":55,\"parentId\":43,\"parentName\":\"工作计划\",\"name\":\"工作周报\",\"url\":\"modules/person/daily.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 101, '0:0:0:0:0:0:0:1', '2021-04-25 13:54:43');
INSERT INTO `sys_log` VALUES (132, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":57,\"parentId\":43,\"parentName\":\"工作计划\",\"name\":\"个人申请\",\"url\":\"modules/person/apply.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 95, '0:0:0:0:0:0:0:1', '2021-04-25 13:56:47');
INSERT INTO `sys_log` VALUES (133, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":27,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-16\",\"upTime\":\"09:38:42\",\"downTime\":\"18:38:42\",\"status\":1,\"createTime\":\"2020-05-17 08:39:24\",\"updateTime\":\"2021-04-25 14:32:34\"}', 210, '0:0:0:0:0:0:0:1', '2021-04-25 14:32:35');
INSERT INTO `sys_log` VALUES (134, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":37,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-25\",\"upTime\":\"10:32:15\",\"status\":1,\"createTime\":\"2021-04-25 14:32:51\"}', 88, '0:0:0:0:0:0:0:1', '2021-04-25 14:32:52');
INSERT INTO `sys_log` VALUES (135, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":36,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-15\",\"upTime\":\"16:56:18\",\"downTime\":\"16:32:15\",\"status\":2,\"createTime\":\"2021-04-24 16:56:56\",\"updateTime\":\"2021-04-25 14:33:06\"}', 107, '0:0:0:0:0:0:0:1', '2021-04-25 14:33:07');
INSERT INTO `sys_log` VALUES (136, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"workDate\":\"2021-04-25\",\"upTime\":\"10:40:52\"}', 48, '0:0:0:0:0:0:0:1', '2021-04-25 14:41:12');
INSERT INTO `sys_log` VALUES (137, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":38,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-18\",\"upTime\":\"10:40:52\",\"status\":1,\"createTime\":\"2021-04-25 14:41:16\"}', 48, '0:0:0:0:0:0:0:1', '2021-04-25 14:41:17');
INSERT INTO `sys_log` VALUES (138, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"workDate\":\"2021-04-25\"}', 2, '0:0:0:0:0:0:0:1', '2021-04-25 14:45:18');
INSERT INTO `sys_log` VALUES (139, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":35,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-24\",\"upTime\":\"16:56:18\",\"downTime\":\"16:56:18\",\"status\":2,\"createTime\":\"2021-04-24 16:56:36\",\"updateTime\":\"2021-04-25 14:53:40\"}', 108, '0:0:0:0:0:0:0:1', '2021-04-25 14:53:40');
INSERT INTO `sys_log` VALUES (140, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"workDate\":\"2021-04-25\",\"upTime\":\"08:57:15\"}', 52, '0:0:0:0:0:0:0:1', '2021-04-25 14:57:32');
INSERT INTO `sys_log` VALUES (141, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":39,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-20\",\"upTime\":\"08:57:15\",\"createTime\":\"2021-04-25 14:57:36\"}', 65, '0:0:0:0:0:0:0:1', '2021-04-25 14:57:36');
INSERT INTO `sys_log` VALUES (142, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"workDate\":\"2021-04-24\",\"upTime\":\"04:57:15\"}', 3, '0:0:0:0:0:0:0:1', '2021-04-25 14:58:49');
INSERT INTO `sys_log` VALUES (143, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"workDate\":\"2021-04-28\",\"upTime\":\"15:02:51\"}', 3, '0:0:0:0:0:0:0:1', '2021-04-25 15:09:44');
INSERT INTO `sys_log` VALUES (144, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":40,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-28\",\"upTime\":\"15:02:51\",\"upStatus\":1,\"createTime\":\"2021-04-25 15:07:31\"}', 382476, '127.0.0.1', '2021-04-25 15:09:44');
INSERT INTO `sys_log` VALUES (145, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":40,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-28\",\"upTime\":\"15:02:51\",\"downTime\":\"18:10:06\",\"status\":0,\"upStatus\":1,\"createTime\":\"2021-04-25 15:07:31\",\"updateTime\":\"2021-04-25 15:10:22\"}', 100, '0:0:0:0:0:0:0:1', '2021-04-25 15:10:23');
INSERT INTO `sys_log` VALUES (146, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":40,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-28\",\"upTime\":\"15:02:51\",\"downTime\":\"16:10:07\",\"status\":2,\"upStatus\":1,\"createTime\":\"2021-04-25 15:07:31\",\"updateTime\":\"2021-04-25 15:10:36\"}', 71, '0:0:0:0:0:0:0:1', '2021-04-25 15:10:36');
INSERT INTO `sys_log` VALUES (147, 'admin', '删除考勤', 'com.person.modules.person.controller.WorkRecordController.delete()', '[26,27,28,29,30,31,32,33,34,35]', 225, '0:0:0:0:0:0:0:1', '2021-04-25 15:14:09');
INSERT INTO `sys_log` VALUES (148, 'admin', '删除考勤', 'com.person.modules.person.controller.WorkRecordController.delete()', '[36,37,38,39,40]', 59, '0:0:0:0:0:0:0:1', '2021-04-25 15:14:17');
INSERT INTO `sys_log` VALUES (149, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":41,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"07:30:57\",\"createTime\":\"2021-04-25 15:14:37\"}', 134, '0:0:0:0:0:0:0:1', '2021-04-25 15:14:38');
INSERT INTO `sys_log` VALUES (150, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":41,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"07:30:57\",\"downTime\":\"16:13:57\",\"status\":2,\"createTime\":\"2021-04-25 15:14:37\",\"updateTime\":\"2021-04-25 15:14:57\"}', 110, '0:0:0:0:0:0:0:1', '2021-04-25 15:14:58');
INSERT INTO `sys_log` VALUES (151, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":42,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-02\",\"upTime\":\"07:15:02\",\"createTime\":\"2021-04-25 15:17:07\"}', 100, '0:0:0:0:0:0:0:1', '2021-04-25 15:17:08');
INSERT INTO `sys_log` VALUES (152, 'admin', '删除考勤', 'com.person.modules.person.controller.WorkRecordController.delete()', '[41,42]', 80, '0:0:0:0:0:0:0:1', '2021-04-25 15:18:13');
INSERT INTO `sys_log` VALUES (153, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":43,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"07:18:07\",\"createTime\":\"2021-04-25 15:18:25\"}', 122, '0:0:0:0:0:0:0:1', '2021-04-25 15:18:25');
INSERT INTO `sys_log` VALUES (154, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":44,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-02\",\"upTime\":\"07:18:07\",\"createTime\":\"2021-04-25 15:19:42\"}', 117, '0:0:0:0:0:0:0:1', '2021-04-25 15:19:43');
INSERT INTO `sys_log` VALUES (155, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":45,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-03\",\"upTime\":\"07:20:25\",\"createTime\":\"2021-04-25 15:20:42\"}', 177, '0:0:0:0:0:0:0:1', '2021-04-25 15:20:42');
INSERT INTO `sys_log` VALUES (156, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":46,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-05\",\"upTime\":\"07:20:25\",\"createTime\":\"2021-04-25 15:22:22\"}', 161, '0:0:0:0:0:0:0:1', '2021-04-25 15:22:22');
INSERT INTO `sys_log` VALUES (157, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":48,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-06\",\"upTime\":\"07:26:55\",\"upStatus\":0,\"createTime\":\"2021-04-25 15:27:08\"}', 152, '0:0:0:0:0:0:0:1', '2021-04-25 15:27:09');
INSERT INTO `sys_log` VALUES (158, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":49,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-07\",\"upTime\":\"07:31:17\",\"upStatus\":0,\"createTime\":\"2021-04-25 15:34:44\"}', 441986, '0:0:0:0:0:0:0:1', '2021-04-25 15:38:57');
INSERT INTO `sys_log` VALUES (159, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":50,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-08\",\"upTime\":\"07:39:42\",\"upStatus\":0,\"createTime\":\"2021-04-25 15:39:54\"}', 224, '0:0:0:0:0:0:0:1', '2021-04-25 15:39:54');
INSERT INTO `sys_log` VALUES (160, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":51,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-10\",\"upTime\":\"07:48:56\",\"upStatus\":0,\"createTime\":\"2021-04-25 15:49:07\"}', 211, '0:0:0:0:0:0:0:1', '2021-04-25 15:49:07');
INSERT INTO `sys_log` VALUES (161, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":52,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-13\",\"upTime\":\"09:21:27\",\"upStatus\":0,\"createTime\":\"2021-04-25 16:21:39\"}', 129, '0:0:0:0:0:0:0:1', '2021-04-25 16:21:40');
INSERT INTO `sys_log` VALUES (162, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":53,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-14\",\"upTime\":\"10:21:27\",\"upStatus\":0,\"createTime\":\"2021-04-25 16:21:55\"}', 88, '0:0:0:0:0:0:0:1', '2021-04-25 16:21:56');
INSERT INTO `sys_log` VALUES (163, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":55,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-16\",\"upTime\":\"10:27:59\",\"upStatus\":1,\"createTime\":\"2021-04-25 16:28:11\"}', 156, '0:0:0:0:0:0:0:1', '2021-04-25 16:28:12');
INSERT INTO `sys_log` VALUES (164, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":55,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-16\",\"upTime\":\"10:27:59\",\"downTime\":\"18:27:59\",\"upStatus\":1,\"createTime\":\"2021-04-25 16:28:11\",\"updateTime\":\"2021-04-25 16:32:40\"}', 152, '0:0:0:0:0:0:0:1', '2021-04-25 16:32:41');
INSERT INTO `sys_log` VALUES (165, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":55,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-16\",\"upTime\":\"10:27:59\",\"downTime\":\"18:27:59\",\"upStatus\":1,\"createTime\":\"2021-04-25 16:28:11\",\"updateTime\":\"2021-04-25 16:35:54\"}', 103, '0:0:0:0:0:0:0:1', '2021-04-25 16:35:54');
INSERT INTO `sys_log` VALUES (166, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":54,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-15\",\"upTime\":\"10:25:33\",\"downTime\":\"16:37:54\",\"status\":2,\"upStatus\":0,\"createTime\":\"2021-04-25 16:27:25\",\"updateTime\":\"2021-04-25 16:38:03\"}', 176, '0:0:0:0:0:0:0:1', '2021-04-25 16:38:04');
INSERT INTO `sys_log` VALUES (167, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":55,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-16\",\"upTime\":\"10:27:59\",\"downTime\":\"18:27:59\",\"upStatus\":1,\"createTime\":\"2021-04-25 16:28:11\",\"updateTime\":\"2021-04-25 16:38:11\"}', 53, '0:0:0:0:0:0:0:1', '2021-04-25 16:38:11');
INSERT INTO `sys_log` VALUES (168, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":55,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-16\",\"upTime\":\"10:27:59\",\"downTime\":\"22:27:59\",\"status\":3,\"upStatus\":1,\"createTime\":\"2021-04-25 16:28:11\",\"updateTime\":\"2021-04-25 16:44:11\"}', 221, '0:0:0:0:0:0:0:1', '2021-04-25 16:44:11');
INSERT INTO `sys_log` VALUES (169, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":55,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-16\",\"upTime\":\"10:27:59\",\"downTime\":\"19:27:59\",\"status\":0,\"upStatus\":1,\"createTime\":\"2021-04-25 16:28:11\",\"updateTime\":\"2021-04-25 16:44:19\"}', 61, '0:0:0:0:0:0:0:1', '2021-04-25 16:44:20');
INSERT INTO `sys_log` VALUES (170, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":56,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-18\",\"upTime\":\"07:05:41\",\"upStatus\":0,\"createTime\":\"2021-04-25 17:05:58\"}', 214, '0:0:0:0:0:0:0:1', '2021-04-25 17:05:58');
INSERT INTO `sys_log` VALUES (171, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":56,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-18\",\"upTime\":\"07:05:41\",\"downTime\":\"17:05:41\",\"status\":2,\"upStatus\":0,\"createTime\":\"2021-04-25 17:05:58\",\"updateTime\":\"2021-04-25 17:06:09\"}', 59, '0:0:0:0:0:0:0:1', '2021-04-25 17:06:09');
INSERT INTO `sys_log` VALUES (172, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":51,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-10\",\"upTime\":\"07:48:56\",\"downTime\":\"18:39:42\",\"status\":4,\"upStatus\":0,\"createTime\":\"2021-04-25 15:49:07\",\"updateTime\":\"2021-04-25 17:39:52\"}', 191, '0:0:0:0:0:0:0:1', '2021-04-25 17:39:53');
INSERT INTO `sys_log` VALUES (173, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":51,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-10\",\"upTime\":\"07:48:56\",\"downTime\":\"19:39:42\",\"status\":0,\"upStatus\":0,\"createTime\":\"2021-04-25 15:49:07\",\"updateTime\":\"2021-04-25 17:40:21\"}', 106, '0:0:0:0:0:0:0:1', '2021-04-25 17:40:21');
INSERT INTO `sys_log` VALUES (174, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":51,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-10\",\"upTime\":\"07:48:56\",\"downTime\":\"17:39:42\",\"status\":2,\"upStatus\":0,\"createTime\":\"2021-04-25 15:49:07\",\"updateTime\":\"2021-04-25 17:40:33\"}', 93, '0:0:0:0:0:0:0:1', '2021-04-25 17:40:34');
INSERT INTO `sys_log` VALUES (175, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":52,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-13\",\"upTime\":\"09:21:27\",\"downTime\":\"19:40:10\",\"status\":0,\"upStatus\":0,\"createTime\":\"2021-04-25 16:21:39\",\"updateTime\":\"2021-04-25 17:40:46\"}', 73, '0:0:0:0:0:0:0:1', '2021-04-25 17:40:47');
INSERT INTO `sys_log` VALUES (176, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":52,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-13\",\"upTime\":\"09:21:27\",\"downTime\":\"21:40:10\",\"status\":3,\"upStatus\":0,\"createTime\":\"2021-04-25 16:21:39\",\"updateTime\":\"2021-04-25 17:40:57\"}', 122, '0:0:0:0:0:0:0:1', '2021-04-25 17:40:57');
INSERT INTO `sys_log` VALUES (177, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":52,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-13\",\"upTime\":\"09:21:27\",\"downTime\":\"19:40:10\",\"status\":0,\"upStatus\":0,\"createTime\":\"2021-04-25 16:21:39\",\"updateTime\":\"2021-04-25 17:41:11\"}', 130, '0:0:0:0:0:0:0:1', '2021-04-25 17:41:11');
INSERT INTO `sys_log` VALUES (178, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":57,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-22\",\"upTime\":\"06:40:10\",\"upStatus\":0,\"createTime\":\"2021-04-25 17:43:34\"}', 188, '0:0:0:0:0:0:0:1', '2021-04-25 17:43:34');
INSERT INTO `sys_log` VALUES (179, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":56,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-18\",\"upTime\":\"07:05:41\",\"downTime\":\"17:05:41\",\"status\":2,\"upStatus\":0,\"createTime\":\"2021-04-25 17:05:58\",\"updateTime\":\"2021-04-25 17:43:49\"}', 59, '0:0:0:0:0:0:0:1', '2021-04-25 17:43:49');
INSERT INTO `sys_log` VALUES (180, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":58,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-26\",\"upTime\":\"08:01:49\",\"upStatus\":0,\"createTime\":\"2021-04-25 18:02:03\"}', 112, '0:0:0:0:0:0:0:1', '2021-04-25 18:02:03');
INSERT INTO `sys_log` VALUES (181, 'admin', '删除考勤', 'com.person.modules.person.controller.WorkRecordController.delete()', '[56,55,54,53]', 86, '0:0:0:0:0:0:0:1', '2021-04-25 18:02:13');
INSERT INTO `sys_log` VALUES (182, 'admin', '删除考勤', 'com.person.modules.person.controller.WorkRecordController.delete()', '[47,46,45,44,43]', 68, '0:0:0:0:0:0:0:1', '2021-04-25 18:02:23');
INSERT INTO `sys_log` VALUES (183, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":9,\"candidate\":\"齐力辉\",\"candidateMobile\":\"13766998945\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-25 18:16:41\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-25 18:17:05\"}', 193, '0:0:0:0:0:0:0:1', '2021-04-25 18:17:06');
INSERT INTO `sys_log` VALUES (184, 'admin', '删除面试', 'com.person.modules.person.controller.InterviewPlanController.delete()', '[8,7,6]', 111, '0:0:0:0:0:0:0:1', '2021-04-25 18:21:03');
INSERT INTO `sys_log` VALUES (185, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":13,\"userId\":8,\"age\":0,\"mobile\":\"13766998945\",\"deptName\":\"研发部\",\"deptId\":4,\"education\":\"本科\",\"userNo\":\"0008\",\"birth\":\"1998-04-25\",\"entryDate\":\"2021-04-25\",\"userType\":\"0\",\"createTime\":\"2021-04-25 18:22:34\"}', 149, '0:0:0:0:0:0:0:1', '2021-04-25 18:22:34');
INSERT INTO `sys_log` VALUES (186, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":6,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-17\",\"workContent\":\"今日完成领导交代的各项任务\",\"progress\":100,\"createTime\":\"2020-05-17 08:49:56\",\"updateTime\":\"2021-04-25 18:30:10\"}', 118, '0:0:0:0:0:0:0:1', '2021-04-25 18:30:11');
INSERT INTO `sys_log` VALUES (187, 'admin', '保存日报', 'com.person.modules.person.controller.WorkDailyController.save()', '{\"id\":9,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-25\",\"workContent\":\"test\",\"progress\":10000,\"createTime\":\"2021-04-25 18:35:02\"}', 176, '0:0:0:0:0:0:0:1', '2021-04-25 18:35:03');
INSERT INTO `sys_log` VALUES (188, 'admin', '保存日报', 'com.person.modules.person.controller.WorkDailyController.save()', '{\"progress\":10000}', 3, '0:0:0:0:0:0:0:1', '2021-04-25 18:35:54');
INSERT INTO `sys_log` VALUES (189, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":9,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-25\",\"workContent\":\"test\",\"progress\":100,\"createTime\":\"2021-04-25 18:35:02\",\"updateTime\":\"2021-04-25 18:43:07\"}', 188, '0:0:0:0:0:0:0:1', '2021-04-25 18:43:08');
INSERT INTO `sys_log` VALUES (190, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":7,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-16\",\"workContent\":\"完成招标计划书的概述部分\",\"progress\":-10,\"createTime\":\"2020-05-17 08:50:41\",\"updateTime\":\"2021-04-25 18:43:20\"}', 146, '0:0:0:0:0:0:0:1', '2021-04-25 18:43:21');
INSERT INTO `sys_log` VALUES (191, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":7,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-16\",\"workContent\":\"完成招标计划书的概述部分\",\"progress\":-10,\"createTime\":\"2020-05-17 08:50:41\",\"updateTime\":\"2021-04-25 18:50:26\"}', 101, '0:0:0:0:0:0:0:1', '2021-04-25 18:50:26');
INSERT INTO `sys_log` VALUES (192, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":7,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-16\",\"workContent\":\"完成招标计划书的概述部分\",\"progress\":-10,\"createTime\":\"2020-05-17 08:50:41\",\"updateTime\":\"2021-04-25 18:51:22\"}', 154, '0:0:0:0:0:0:0:1', '2021-04-25 18:51:22');
INSERT INTO `sys_log` VALUES (193, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":7,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-16\",\"workContent\":\"完成招标计划书的概述部分\",\"progress\":20,\"createTime\":\"2020-05-17 08:50:41\",\"updateTime\":\"2021-04-25 18:51:40\"}', 95, '0:0:0:0:0:0:0:1', '2021-04-25 18:51:41');
INSERT INTO `sys_log` VALUES (194, 'admin', '审核', 'com.person.modules.person.controller.ConvertApplyController.approval()', '{\"id\":6,\"applyUserId\":4,\"applyDate\":\"2020-05-17\",\"applyContent\":\"申请转正\",\"status\":1,\"approvalUserId\":1,\"approvalResult\":1,\"createTime\":\"2020-05-17 09:10:40\",\"updateTime\":\"2021-04-25 18:54:05\"}', 91, '0:0:0:0:0:0:0:1', '2021-04-25 18:54:06');
INSERT INTO `sys_log` VALUES (195, 'admin', '审核', 'com.person.modules.person.controller.ConvertApplyController.approval()', '{\"id\":6,\"applyUserId\":4,\"applyDate\":\"2020-05-17\",\"applyContent\":\"申请转正\",\"status\":2,\"approvalDate\":\"2021-04-25\",\"approvalUserId\":1,\"approvalResult\":2,\"approvalOpinion\":\"通过\",\"createTime\":\"2020-05-17 09:10:40\",\"updateTime\":\"2021-04-25 18:57:08\"}', 181, '0:0:0:0:0:0:0:1', '2021-04-25 18:57:09');
INSERT INTO `sys_log` VALUES (196, 'lqh', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":59,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"08:59:59\",\"upStatus\":0,\"createTime\":\"2021-04-25 20:00:10\"}', 177, '0:0:0:0:0:0:0:1', '2021-04-25 20:00:11');
INSERT INTO `sys_log` VALUES (197, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":59,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"08:59:59\",\"downTime\":\"18:59:59\",\"status\":4,\"upStatus\":0,\"createTime\":\"2021-04-25 20:00:10\",\"updateTime\":\"2021-04-25 20:00:21\"}', 101, '0:0:0:0:0:0:0:1', '2021-04-25 20:00:22');
INSERT INTO `sys_log` VALUES (198, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":59,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"08:59:59\",\"downTime\":\"18:59:59\",\"status\":4,\"upStatus\":0,\"createTime\":\"2021-04-25 20:00:10\",\"updateTime\":\"2021-04-25 20:00:33\"}', 53, '0:0:0:0:0:0:0:1', '2021-04-25 20:00:33');
INSERT INTO `sys_log` VALUES (199, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":59,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"08:59:59\",\"downTime\":\"19:59:59\",\"status\":0,\"upStatus\":0,\"createTime\":\"2021-04-25 20:00:10\",\"updateTime\":\"2021-04-25 20:00:40\"}', 64, '0:0:0:0:0:0:0:1', '2021-04-25 20:00:40');
INSERT INTO `sys_log` VALUES (200, 'lqh', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":60,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-02\",\"upTime\":\"06:00:45\",\"upStatus\":0,\"createTime\":\"2021-04-25 20:01:00\"}', 43, '0:0:0:0:0:0:0:1', '2021-04-25 20:01:00');
INSERT INTO `sys_log` VALUES (201, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":60,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-02\",\"upTime\":\"06:00:45\",\"downTime\":\"20:02:45\",\"status\":3,\"upStatus\":0,\"createTime\":\"2021-04-25 20:01:00\",\"updateTime\":\"2021-04-25 20:01:10\"}', 35, '0:0:0:0:0:0:0:1', '2021-04-25 20:01:10');
INSERT INTO `sys_log` VALUES (202, 'lqh', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":61,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-03\",\"upTime\":\"09:00:45\",\"upStatus\":0,\"createTime\":\"2021-04-25 20:01:30\"}', 118, '0:0:0:0:0:0:0:1', '2021-04-25 20:01:31');
INSERT INTO `sys_log` VALUES (203, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":61,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-03\",\"upTime\":\"09:00:45\",\"downTime\":\"18:00:45\",\"status\":4,\"upStatus\":0,\"createTime\":\"2021-04-25 20:01:30\",\"updateTime\":\"2021-04-25 20:01:38\"}', 83, '0:0:0:0:0:0:0:1', '2021-04-25 20:01:38');
INSERT INTO `sys_log` VALUES (204, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":61,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-03\",\"upTime\":\"09:00:45\",\"downTime\":\"20:00:45\",\"status\":3,\"upStatus\":0,\"createTime\":\"2021-04-25 20:01:30\",\"updateTime\":\"2021-04-25 20:03:29\"}', 121, '0:0:0:0:0:0:0:1', '2021-04-25 20:03:29');
INSERT INTO `sys_log` VALUES (205, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":61,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-03\",\"upTime\":\"09:00:45\",\"downTime\":\"19:00:45\",\"status\":0,\"upStatus\":0,\"createTime\":\"2021-04-25 20:01:30\",\"updateTime\":\"2021-04-25 20:03:40\"}', 53, '0:0:0:0:0:0:0:1', '2021-04-25 20:03:41');
INSERT INTO `sys_log` VALUES (206, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":61,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-03\",\"upTime\":\"09:00:45\",\"downTime\":\"18:00:45\",\"status\":0,\"upStatus\":0,\"createTime\":\"2021-04-25 20:01:30\",\"updateTime\":\"2021-04-25 20:03:51\"}', 74, '0:0:0:0:0:0:0:1', '2021-04-25 20:03:51');
INSERT INTO `sys_log` VALUES (207, 'lqh', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"workDate\":\"2021-04-01\",\"upTime\":\"06:00:45\"}', 1, '0:0:0:0:0:0:0:1', '2021-04-25 20:04:03');
INSERT INTO `sys_log` VALUES (208, 'lqh', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":62,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-09\",\"upTime\":\"06:00:45\",\"upStatus\":0,\"createTime\":\"2021-04-25 20:04:06\"}', 69, '0:0:0:0:0:0:0:1', '2021-04-25 20:04:07');
INSERT INTO `sys_log` VALUES (209, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":62,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-09\",\"upTime\":\"06:00:45\",\"downTime\":\"18:00:45\",\"status\":4,\"upStatus\":0,\"createTime\":\"2021-04-25 20:04:06\",\"updateTime\":\"2021-04-25 20:04:18\"}', 128, '0:0:0:0:0:0:0:1', '2021-04-25 20:04:19');
INSERT INTO `sys_log` VALUES (210, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":62,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-09\",\"upTime\":\"06:00:45\",\"downTime\":\"21:00:45\",\"status\":3,\"upStatus\":0,\"createTime\":\"2021-04-25 20:04:06\",\"updateTime\":\"2021-04-25 20:05:46\"}', 119, '0:0:0:0:0:0:0:1', '2021-04-25 20:05:47');
INSERT INTO `sys_log` VALUES (211, 'lqh', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":63,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-11\",\"upTime\":\"06:05:07\",\"upStatus\":0,\"createTime\":\"2021-04-25 20:06:12\"}', 120, '0:0:0:0:0:0:0:1', '2021-04-25 20:06:13');
INSERT INTO `sys_log` VALUES (212, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":63,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-11\",\"upTime\":\"06:05:07\",\"downTime\":\"22:08:10\",\"status\":3,\"upStatus\":0,\"createTime\":\"2021-04-25 20:06:12\",\"updateTime\":\"2021-04-25 20:06:34\"}', 148, '0:0:0:0:0:0:0:1', '2021-04-25 20:06:35');
INSERT INTO `sys_log` VALUES (213, 'lqh', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":64,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-19\",\"upTime\":\"08:05:07\",\"upStatus\":0,\"createTime\":\"2021-04-25 20:06:50\"}', 40, '0:0:0:0:0:0:0:1', '2021-04-25 20:06:51');
INSERT INTO `sys_log` VALUES (214, 'lqh', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":64,\"userId\":8,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-19\",\"upTime\":\"08:05:07\",\"downTime\":\"18:05:07\",\"status\":4,\"upStatus\":0,\"createTime\":\"2021-04-25 20:06:50\",\"updateTime\":\"2021-04-25 20:06:58\"}', 69, '0:0:0:0:0:0:0:1', '2021-04-25 20:06:58');
INSERT INTO `sys_log` VALUES (215, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"workDate\":\"2021-04-13\",\"upTime\":\"10:08:54\"}', 62, '0:0:0:0:0:0:0:1', '2021-04-25 20:09:06');
INSERT INTO `sys_log` VALUES (216, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":65,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-12\",\"upTime\":\"10:08:54\",\"upStatus\":1,\"createTime\":\"2021-04-25 20:09:10\"}', 63, '0:0:0:0:0:0:0:1', '2021-04-25 20:09:10');
INSERT INTO `sys_log` VALUES (217, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":65,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-12\",\"upTime\":\"10:08:54\",\"downTime\":\"18:05:54\",\"status\":4,\"upStatus\":1,\"createTime\":\"2021-04-25 20:09:10\",\"updateTime\":\"2021-04-25 20:09:27\"}', 119923, '0:0:0:0:0:0:0:1', '2021-04-25 20:11:22');
INSERT INTO `sys_log` VALUES (218, 'admin', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":65,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-12\",\"upTime\":\"10:08:54\",\"downTime\":\"18:05:54\",\"status\":2,\"upStatus\":1,\"createTime\":\"2021-04-25 20:09:10\",\"updateTime\":\"2021-04-25 20:11:59\"}', 192660, '0:0:0:0:0:0:0:1', '2021-04-25 20:15:07');
INSERT INTO `sys_log` VALUES (219, 'admin', '修改合同档案', 'com.person.modules.person.controller.ContractController.update()', '{\"id\":2,\"name\":\"设备采购\",\"partA\":\"哈尔滨理工大学\",\"partB\":\"青软实训基地\",\"signDate\":\"2020-05-14\",\"amount\":10000.0}', 109, '0:0:0:0:0:0:0:1', '2021-04-25 22:14:19');
INSERT INTO `sys_log` VALUES (220, 'admin', '修改合同档案', 'com.person.modules.person.controller.ContractController.update()', '{\"id\":2,\"name\":\"设备采购\",\"partA\":\"哈尔滨理工大学\",\"partB\":\"青软实训基地\",\"signDate\":\"2021-04-25\",\"amount\":10000.0}', 123, '0:0:0:0:0:0:0:1', '2021-04-25 22:14:34');
INSERT INTO `sys_log` VALUES (221, 'admin', '修改合同档案', 'com.person.modules.person.controller.ContractController.update()', '{\"id\":3,\"name\":\"售卖老旧机器\",\"partA\":\"联想集团\",\"partB\":\"哈尔滨理工大学\",\"signDate\":\"2021-04-25\",\"amount\":20000.0}', 177, '0:0:0:0:0:0:0:1', '2021-04-25 22:15:17');
INSERT INTO `sys_log` VALUES (222, 'admin', '删除培训计划', 'com.person.modules.person.controller.TrainPlanController.delete()', '[3,1]', 69, '0:0:0:0:0:0:0:1', '2021-04-25 22:17:08');
INSERT INTO `sys_log` VALUES (223, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"wdc\",\"name\":\"代胜辉\",\"password\":\"465eb796858668c09235a6b8e2c9992aecaebf6a84bf5e9cc0929f5587fe15d2\",\"salt\":\"1sbkoGf5x7Q5lqxvCs5I\",\"email\":\"1203313263@qq.com\",\"mobile\":\"18651234456\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"May 15, 2020 10:29:02 PM\",\"deptId\":4,\"deptName\":\"研发部\"}', 298, '0:0:0:0:0:0:0:1', '2021-04-25 22:17:31');
INSERT INTO `sys_log` VALUES (224, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":3,\"username\":\"cw\",\"name\":\"小明_财务\",\"salt\":\"2E5mvF1xjXFoY0narVz9\",\"email\":\"1203313263@qq.com\",\"mobile\":\"13455676543\",\"status\":1,\"roleIdList\":[3],\"createTime\":\"May 16, 2020 3:11:08 PM\",\"deptId\":6,\"deptName\":\"财务部\"}', 291, '0:0:0:0:0:0:0:1', '2021-04-25 22:17:52');
INSERT INTO `sys_log` VALUES (225, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"dsh\",\"name\":\"代胜辉\",\"salt\":\"1sbkoGf5x7Q5lqxvCs5I\",\"email\":\"1203313263@qq.com\",\"mobile\":\"18651234456\",\"status\":1,\"roleIdList\":[2],\"createTime\":\"May 15, 2020 10:29:02 PM\",\"deptId\":4,\"deptName\":\"研发部\"}', 257, '0:0:0:0:0:0:0:1', '2021-04-25 22:18:07');
INSERT INTO `sys_log` VALUES (226, 'admin', '修改用户', 'com.person.modules.sys.controller.SysUserController.update()', '{\"userId\":4,\"username\":\"rs\",\"name\":\"小李_人事\",\"salt\":\"NF4cYNKNmsMA997exGGN\",\"email\":\"1203313263@qq.com\",\"mobile\":\"19877678790\",\"status\":1,\"roleIdList\":[4],\"createTime\":\"May 16, 2020 3:11:43 PM\",\"deptId\":7,\"deptName\":\"人事部\"}', 137, '0:0:0:0:0:0:0:1', '2021-04-25 22:18:22');
INSERT INTO `sys_log` VALUES (227, 'admin', '删除用户', 'com.person.modules.sys.controller.SysUserController.delete()', '[5]', 69, '0:0:0:0:0:0:0:1', '2021-04-25 22:18:27');
INSERT INTO `sys_log` VALUES (228, 'admin', '修改个人计划', 'com.person.modules.person.controller.UserPlanController.update()', '{\"id\":34,\"userId\":2,\"name\":\"学习Springboot\",\"content\":\"在慕课网每天一课\",\"startDate\":\"2021-04-25\",\"endDate\":\"2020-05-30\",\"status\":0,\"createTime\":\"2020-05-17 08:48:20\",\"updateTime\":\"2021-04-25 22:20:56\"}', 122, '0:0:0:0:0:0:0:1', '2021-04-25 22:20:56');
INSERT INTO `sys_log` VALUES (229, 'admin', '修改个人计划', 'com.person.modules.person.controller.UserPlanController.update()', '{\"id\":35,\"userId\":2,\"name\":\"完成实习的一周工作\",\"content\":\"每天都要认真工作\",\"startDate\":\"2021-04-20\",\"endDate\":\"2020-05-28\",\"status\":0,\"createTime\":\"2020-05-17 08:49:10\",\"updateTime\":\"2021-04-25 22:21:28\"}', 181, '0:0:0:0:0:0:0:1', '2021-04-25 22:21:29');
INSERT INTO `sys_log` VALUES (230, 'admin', '修改个人计划', 'com.person.modules.person.controller.UserPlanController.update()', '{\"id\":35,\"userId\":2,\"name\":\"完成实习的一周工作\",\"content\":\"每天都要认真工作\",\"startDate\":\"2021-04-20\",\"endDate\":\"2021-04-25\",\"status\":0,\"createTime\":\"2020-05-17 08:49:10\",\"updateTime\":\"2021-04-25 22:21:35\"}', 70, '0:0:0:0:0:0:0:1', '2021-04-25 22:21:35');
INSERT INTO `sys_log` VALUES (231, 'admin', '修改个人计划', 'com.person.modules.person.controller.UserPlanController.update()', '{\"id\":36,\"userId\":4,\"name\":\"开展5.1员工素养培训\",\"content\":\"围绕企业规划进行探讨\",\"startDate\":\"2021-04-06\",\"endDate\":\"2020-05-13\",\"status\":1,\"createTime\":\"2020-05-17 09:09:42\",\"updateTime\":\"2021-04-25 22:22:28\"}', 74, '0:0:0:0:0:0:0:1', '2021-04-25 22:22:29');
INSERT INTO `sys_log` VALUES (232, 'admin', '保存个人计划', 'com.person.modules.person.controller.UserPlanController.save()', '{\"id\":37,\"userId\":1,\"name\":\"完成论文的撰写\",\"content\":\"一天写一节。\",\"startDate\":\"2021-04-25\",\"endDate\":\"2021-04-30\",\"status\":0,\"createTime\":\"2021-04-25 22:22:54\"}', 62, '0:0:0:0:0:0:0:1', '2021-04-25 22:22:55');
INSERT INTO `sys_log` VALUES (233, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":6,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2021-04-25\",\"workContent\":\"完成代码bug的修改\",\"progress\":100,\"createTime\":\"2020-05-17 08:49:56\",\"updateTime\":\"2021-04-25 22:23:27\"}', 54, '0:0:0:0:0:0:0:1', '2021-04-25 22:23:28');
INSERT INTO `sys_log` VALUES (234, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":7,\"userId\":2,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-16\",\"workContent\":\"完成论文第一章\",\"progress\":100,\"createTime\":\"2020-05-17 08:50:41\",\"updateTime\":\"2021-04-25 22:23:44\"}', 71, '0:0:0:0:0:0:0:1', '2021-04-25 22:23:45');
INSERT INTO `sys_log` VALUES (235, 'admin', '修改日报', 'com.person.modules.person.controller.WorkDailyController.update()', '{\"id\":8,\"userId\":4,\"workMonth\":\"2020-05\",\"workDate\":\"2020-05-17\",\"workContent\":\"进行招聘工作\",\"progress\":50,\"createTime\":\"2020-05-17 09:10:18\",\"updateTime\":\"2021-04-25 22:24:03\"}', 149, '0:0:0:0:0:0:0:1', '2021-04-25 22:24:04');
INSERT INTO `sys_log` VALUES (236, 'admin', '保存培训计划', 'com.person.modules.person.controller.TrainPlanController.save()', '{\"id\":4,\"title\":\"培训员工代码能力\",\"trainDate\":\"2021-04-25\",\"content\":\"大家一起观看学习视频\",\"participant\":\"研发部所有人员\"}', 148, '0:0:0:0:0:0:0:1', '2021-04-25 22:25:19');
INSERT INTO `sys_log` VALUES (237, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":9,\"candidate\":\"齐力辉\",\"candidateMobile\":\"13766998945\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-25 18:16:41\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2021-04-25 18:17:05\"}', 188, '0:0:0:0:0:0:0:1', '2021-04-26 10:46:36');
INSERT INTO `sys_log` VALUES (238, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":10,\"candidate\":\"王\",\"candidateMobile\":\"13755668749\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-26 10:48:23\",\"meetUserId\":4,\"status\":0,\"createTime\":\"2021-04-26 10:48:59\"}', 198, '0:0:0:0:0:0:0:1', '2021-04-26 10:49:00');
INSERT INTO `sys_log` VALUES (239, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":10,\"candidate\":\"王\",\"candidateMobile\":\"13755668749\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-26 10:48:23\",\"meetUserId\":4,\"status\":1,\"createTime\":\"2021-04-26 10:48:59\"}', 173, '0:0:0:0:0:0:0:1', '2021-04-26 10:49:46');
INSERT INTO `sys_log` VALUES (240, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":11,\"candidate\":\"赵\",\"candidateMobile\":\"13455669874\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-20 10:50:46\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-26 10:51:15\"}', 185, '0:0:0:0:0:0:0:1', '2021-04-26 10:51:15');
INSERT INTO `sys_log` VALUES (241, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":11,\"candidate\":\"赵\",\"candidateMobile\":\"13455669874\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-20 10:50:46\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2021-04-26 10:51:15\"}', 102, '0:0:0:0:0:0:0:1', '2021-04-26 10:51:22');
INSERT INTO `sys_log` VALUES (242, 'admin', '保存用户', 'com.person.modules.sys.controller.SysUserController.save()', '{\"userId\":16,\"username\":\"wang\",\"name\":\"王\",\"password\":\"17c066d6cc91817ca51b380c61ce93b5211cd4d01a6c8d48804577470289abc4\",\"salt\":\"KF0SZzlwruZFIZDBpu9Y\",\"email\":\"811386782@qq.com\",\"mobile\":\"13877998974\",\"status\":1,\"roleIdList\":[3],\"createTime\":\"Apr 26, 2021 10:59:44 AM\",\"deptId\":6,\"deptName\":\"财务部\"}', 2158, '0:0:0:0:0:0:0:1', '2021-04-26 10:59:45');
INSERT INTO `sys_log` VALUES (243, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":36,\"userId\":16,\"salaryMonth\":\"2021-04\",\"mustSalary\":100000.0,\"fundAmount\":0.0,\"taxAmount\":0.0,\"medicalAmount\":0.0,\"pensionAmount\":0.0,\"injuredAmount\":0.0,\"salarySum\":100000.0,\"createTime\":\"2021-04-26 11:01:24\"}', 1656, '0:0:0:0:0:0:0:1', '2021-04-26 11:01:26');
INSERT INTO `sys_log` VALUES (244, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":12,\"candidate\":\"小明\",\"candidateMobile\":\"13699885461\",\"email\":\"811386782@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":16,\"status\":0,\"createTime\":\"2021-04-26 11:06:03\"}', 1657, '0:0:0:0:0:0:0:1', '2021-04-26 11:06:06');
INSERT INTO `sys_log` VALUES (245, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":13,\"candidate\":\"xx\",\"candidateMobile\":\"12333332123\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-26 11:12:33\"}', 1494, '0:0:0:0:0:0:0:1', '2021-04-26 11:12:35');
INSERT INTO `sys_log` VALUES (246, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":14,\"candidate\":\"刘\",\"candidateMobile\":\"12033665261\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-29 11:29:15\",\"meetUserId\":8,\"status\":0,\"createTime\":\"2021-04-26 11:29:45\"}', 3265, '0:0:0:0:0:0:0:1', '2021-04-26 11:29:49');
INSERT INTO `sys_log` VALUES (247, 'admin', '删除面试', 'com.person.modules.person.controller.InterviewPlanController.delete()', '[14]', 112, '0:0:0:0:0:0:0:1', '2021-04-26 11:30:57');
INSERT INTO `sys_log` VALUES (248, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":15,\"candidate\":\"刘清华\",\"candidateMobile\":\"12033668947\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-29 11:30:51\",\"meetUserId\":8,\"status\":0,\"createTime\":\"2021-04-26 11:33:00\"}', 3229, '0:0:0:0:0:0:0:1', '2021-04-26 11:33:04');
INSERT INTO `sys_log` VALUES (249, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":15,\"candidate\":\"刘清华\",\"candidateMobile\":\"12033668947\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-29 11:30:51\",\"meetUserId\":8,\"status\":1,\"createTime\":\"2021-04-26 11:33:00\"}', 1421, '0:0:0:0:0:0:0:1', '2021-04-26 11:39:02');
INSERT INTO `sys_log` VALUES (250, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":13,\"candidate\":\"xx\",\"candidateMobile\":\"12333332123\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2021-04-26 11:12:33\"}', 1637, '0:0:0:0:0:0:0:1', '2021-04-26 11:42:03');
INSERT INTO `sys_log` VALUES (251, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":13,\"candidate\":\"xx\",\"candidateMobile\":\"12333332123\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-26 11:12:33\"}', 140, '0:0:0:0:0:0:0:1', '2021-04-26 11:43:02');
INSERT INTO `sys_log` VALUES (252, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":13,\"candidate\":\"xx\",\"candidateMobile\":\"12333332123\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2021-04-26 11:12:33\"}', 1957, '0:0:0:0:0:0:0:1', '2021-04-26 11:43:44');
INSERT INTO `sys_log` VALUES (253, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":9,\"candidate\":\"齐力辉\",\"candidateMobile\":\"13766998945\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-25 18:16:41\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-25 18:17:05\"}', 153, '0:0:0:0:0:0:0:1', '2021-04-26 11:47:33');
INSERT INTO `sys_log` VALUES (254, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":10,\"candidate\":\"王\",\"candidateMobile\":\"13755668749\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-26 10:48:23\",\"meetUserId\":4,\"status\":0,\"createTime\":\"2021-04-26 10:48:59\"}', 171, '127.0.0.1', '2021-04-26 11:49:54');
INSERT INTO `sys_log` VALUES (255, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":11,\"candidate\":\"赵\",\"candidateMobile\":\"13455669874\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-20 10:50:46\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-26 10:51:15\"}', 145, '0:0:0:0:0:0:0:1', '2021-04-26 11:50:24');
INSERT INTO `sys_log` VALUES (256, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":11,\"candidate\":\"赵\",\"candidateMobile\":\"13455669874\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-20 10:50:46\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-26 10:51:15\"}', 5, '0:0:0:0:0:0:0:1', '2021-04-26 11:56:48');
INSERT INTO `sys_log` VALUES (257, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":12,\"candidate\":\"小明\",\"candidateMobile\":\"13699885461\",\"email\":\"811386782@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":16,\"status\":1,\"createTime\":\"2021-04-26 11:06:03\"}', 1810, '0:0:0:0:0:0:0:1', '2021-04-26 12:00:10');
INSERT INTO `sys_log` VALUES (258, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":12,\"candidate\":\"小明\",\"candidateMobile\":\"13699885461\",\"email\":\"811386782@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":16,\"status\":1,\"createTime\":\"2021-04-26 11:06:03\"}', 1514, '0:0:0:0:0:0:0:1', '2021-04-26 12:00:11');
INSERT INTO `sys_log` VALUES (259, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":12,\"candidate\":\"小明\",\"candidateMobile\":\"13699885461\",\"email\":\"811386782@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":16,\"status\":1,\"createTime\":\"2021-04-26 11:06:03\"}', 1868, '0:0:0:0:0:0:0:1', '2021-04-26 12:01:24');
INSERT INTO `sys_log` VALUES (260, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":12,\"candidate\":\"小明\",\"candidateMobile\":\"13699885461\",\"email\":\"811386782@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":16,\"status\":1,\"createTime\":\"2021-04-26 11:06:03\"}', 1407, '0:0:0:0:0:0:0:1', '2021-04-26 12:01:25');
INSERT INTO `sys_log` VALUES (261, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":12,\"candidate\":\"小明\",\"candidateMobile\":\"13699885461\",\"email\":\"811386782@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":16,\"status\":1,\"createTime\":\"2021-04-26 11:06:03\"}', 1359, '0:0:0:0:0:0:0:1', '2021-04-26 12:01:49');
INSERT INTO `sys_log` VALUES (262, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":13,\"candidate\":\"xx\",\"candidateMobile\":\"12333332123\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-27 11:05:35\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2021-04-26 11:12:33\"}', 1682, '0:0:0:0:0:0:0:1', '2021-04-26 12:03:46');
INSERT INTO `sys_log` VALUES (263, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":11,\"candidate\":\"赵\",\"candidateMobile\":\"13455669874\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-20 10:50:46\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-26 10:51:15\"}', 36, '0:0:0:0:0:0:0:1', '2021-04-26 12:05:56');
INSERT INTO `sys_log` VALUES (264, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":9,\"candidate\":\"齐力辉\",\"candidateMobile\":\"13766998945\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-25 18:16:41\",\"meetUserId\":3,\"status\":0,\"createTime\":\"2021-04-25 18:17:05\"}', 40, '0:0:0:0:0:0:0:1', '2021-04-26 12:13:02');
INSERT INTO `sys_log` VALUES (265, 'admin', '保存绩效设置', 'com.person.modules.person.controller.MeritController.save()', '{\"id\":5,\"setDate\":\"2021-04-26\",\"monthQuota\":\"1200\",\"weekQuota\":\"1000\"}', 101, '0:0:0:0:0:0:0:1', '2021-04-26 12:39:54');
INSERT INTO `sys_log` VALUES (266, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":51,\"parentId\":44,\"parentName\":\"人才招聘\",\"name\":\"人才内推\",\"url\":\"modules/person/need.html\",\"perms\":\"\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 142, '0:0:0:0:0:0:0:1', '2021-04-26 12:49:54');
INSERT INTO `sys_log` VALUES (267, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":37,\"userId\":2,\"salaryMonth\":\"2020-01\",\"mustSalary\":1000.0,\"fundAmount\":0.0,\"taxAmount\":0.0,\"medicalAmount\":0.0,\"pensionAmount\":0.0,\"injuredAmount\":0.0,\"salarySum\":1000.0,\"createTime\":\"2021-04-26 12:53:40\"}', 1733, '0:0:0:0:0:0:0:1', '2021-04-26 12:53:42');
INSERT INTO `sys_log` VALUES (268, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":38,\"userId\":2,\"salaryMonth\":\"2020-02\",\"mustSalary\":1000.0,\"fundAmount\":0.0,\"taxAmount\":0.0,\"medicalAmount\":0.0,\"pensionAmount\":0.0,\"injuredAmount\":0.0,\"salarySum\":1000.0,\"createTime\":\"2021-04-26 12:54:03\"}', 1472, '0:0:0:0:0:0:0:1', '2021-04-26 12:54:05');
INSERT INTO `sys_log` VALUES (269, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":39,\"userId\":3,\"salaryMonth\":\"2020-01\",\"mustSalary\":1000.0,\"fundAmount\":2.0,\"taxAmount\":2.0,\"medicalAmount\":2.0,\"pensionAmount\":2.0,\"injuredAmount\":2.0,\"salarySum\":994.0,\"createTime\":\"2021-04-26 12:54:21\"}', 1576, '0:0:0:0:0:0:0:1', '2021-04-26 12:54:23');
INSERT INTO `sys_log` VALUES (270, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":2,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"员工管理\",\"url\":\"modules/sys/user.html\",\"type\":1,\"icon\":\"\",\"orderNum\":1}', 117, '0:0:0:0:0:0:0:1', '2021-04-26 13:07:44');
INSERT INTO `sys_log` VALUES (271, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":2,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"员工管理\",\"url\":\"modules/sys/user.html\",\"type\":1,\"icon\":\"\",\"orderNum\":1}', 118, '0:0:0:0:0:0:0:1', '2021-04-26 13:11:59');
INSERT INTO `sys_log` VALUES (272, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":15,\"candidate\":\"刘清华\",\"candidateMobile\":\"12033668947\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-29 11:30:51\",\"meetUserId\":8,\"status\":0,\"createTime\":\"2021-04-26 11:33:00\"}', 93, '0:0:0:0:0:0:0:1', '2021-04-26 13:14:13');
INSERT INTO `sys_log` VALUES (273, 'admin', '修改绩效设置', 'com.person.modules.person.controller.MeritController.update()', '{\"id\":5,\"setDate\":\"2021-04-26\",\"monthQuota\":\"1200\",\"weekQuota\":\"300\"}', 123, '0:0:0:0:0:0:0:1', '2021-04-26 13:39:10');
INSERT INTO `sys_log` VALUES (274, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":2,\"roleName\":\"总经理\",\"remark\":\"总经理\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,31,32,33,34,35,36,37,38,39,40,41,56,81,82,83,84,42,54,62,63,64,86,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,44,51,73,74,75,76,52,77,78,79,80,45,53,69,70,71,72,87,88,89,90,91,92,93,94,95,96,97],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:29:43 PM\"}', 189, '0:0:0:0:0:0:0:1', '2021-04-26 13:41:30');
INSERT INTO `sys_log` VALUES (275, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":53,\"parentId\":45,\"parentName\":\"档案管理\",\"name\":\"员工档案\",\"url\":\"modules/person/doc.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 74, '0:0:0:0:0:0:0:1', '2021-04-26 13:41:56');
INSERT INTO `sys_log` VALUES (276, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"userId\":3,\"salaryMonth\":\"2020-01\",\"mustSalary\":5000.0,\"fundAmount\":5000.0,\"taxAmount\":50.0,\"medicalAmount\":50.0,\"pensionAmount\":50.0,\"injuredAmount\":200.0,\"createTime\":\"2021-04-26 14:45:47\"}', 54, '0:0:0:0:0:0:0:1', '2021-04-26 14:45:47');
INSERT INTO `sys_log` VALUES (277, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":40,\"userId\":3,\"salaryMonth\":\"2020-02\",\"mustSalary\":5000.0,\"fundAmount\":5000.0,\"taxAmount\":50.0,\"medicalAmount\":50.0,\"pensionAmount\":50.0,\"injuredAmount\":200.0,\"salarySum\":-250.0,\"createTime\":\"2021-04-26 14:45:55\"}', 1586, '0:0:0:0:0:0:0:1', '2021-04-26 14:45:57');
INSERT INTO `sys_log` VALUES (278, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":41,\"userId\":3,\"salaryMonth\":\"2021-01\",\"mustSalary\":5000.0,\"fundAmount\":0.0,\"taxAmount\":500.0,\"medicalAmount\":450.0,\"pensionAmount\":100.0,\"injuredAmount\":1520.0,\"salarySum\":3330.0,\"createTime\":\"2021-04-26 14:46:37\"}', 1337, '0:0:0:0:0:0:0:1', '2021-04-26 14:46:39');
INSERT INTO `sys_log` VALUES (279, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":42,\"userId\":14,\"salaryMonth\":\"2021-02\",\"mustSalary\":5000.0,\"fundAmount\":50.0,\"taxAmount\":50.0,\"medicalAmount\":50.0,\"pensionAmount\":10.0,\"injuredAmount\":200.0,\"salarySum\":4740.0,\"createTime\":\"2021-04-26 15:27:24\"}', 1610, '0:0:0:0:0:0:0:1', '2021-04-26 15:27:26');
INSERT INTO `sys_log` VALUES (280, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":43,\"userId\":8,\"salaryMonth\":\"2021-03\",\"mustSalary\":5000.0,\"fundAmount\":600.0,\"taxAmount\":500.0,\"medicalAmount\":2000.0,\"pensionAmount\":500.0,\"injuredAmount\":500.0,\"salarySum\":4875.0,\"createTime\":\"2021-04-26 15:33:27\"}', 1605, '0:0:0:0:0:0:0:1', '2021-04-26 15:33:29');
INSERT INTO `sys_log` VALUES (281, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":44,\"userId\":8,\"salaryMonth\":\"2020-12\",\"mustSalary\":5000.0,\"fundAmount\":500.0,\"taxAmount\":500.0,\"medicalAmount\":5000.0,\"pensionAmount\":645.0,\"injuredAmount\":3000.0,\"salarySum\":5355.0,\"createTime\":\"2021-04-26 15:45:20\"}', 1496, '0:0:0:0:0:0:0:1', '2021-04-26 15:45:22');
INSERT INTO `sys_log` VALUES (282, 'admin', '删除工资', 'com.person.modules.person.controller.SalaryRecordController.delete()', '[40]', 154, '0:0:0:0:0:0:0:1', '2021-04-26 15:45:41');
INSERT INTO `sys_log` VALUES (283, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"userId\":2,\"mobile\":\"12312131231\",\"deptName\":\"财务部\",\"deptId\":6,\"education\":\"本科\",\"birth\":\"2021-04-26\",\"entryDate\":\"2021-04-12\",\"userType\":\"0\",\"createTime\":\"2021-04-26 16:48:24\"}', 75, '0:0:0:0:0:0:0:1', '2021-04-26 16:48:24');
INSERT INTO `sys_log` VALUES (284, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":14,\"userId\":2,\"mobile\":\"12311223312\",\"deptName\":\"研发部\",\"deptId\":4,\"education\":\"本科\",\"userNo\":\"0002\",\"birth\":\"1998-04-30\",\"entryDate\":\"2021-04-26\",\"userType\":\"0\",\"createTime\":\"2021-04-26 16:49:41\"}', 135, '0:0:0:0:0:0:0:1', '2021-04-26 16:49:41');
INSERT INTO `sys_log` VALUES (285, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":15,\"userId\":3,\"mobile\":\"13766998947\",\"deptName\":\"财务部\",\"deptId\":6,\"education\":\"硕士\",\"userNo\":\"0003\",\"birth\":\"2010-04-07\",\"entryDate\":\"2021-04-26\",\"userType\":\"1\",\"createTime\":\"2021-04-26 17:47:15\"}', 194, '0:0:0:0:0:0:0:1', '2021-04-26 17:47:15');
INSERT INTO `sys_log` VALUES (286, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":16,\"userId\":8,\"mobile\":\"13766998546\",\"deptName\":\"后勤管理部\",\"deptId\":8,\"education\":\"本科\",\"userNo\":\"0008\",\"birth\":\"1998-06-30\",\"email\":\"1203313263@qq.com\",\"entryDate\":\"2021-04-12\",\"userType\":\"3\",\"createTime\":\"2021-04-26 17:49:53\"}', 138, '0:0:0:0:0:0:0:1', '2021-04-26 17:49:53');
INSERT INTO `sys_log` VALUES (287, 'admin', '删除员工档案', 'com.person.modules.person.controller.UserDocController.delete()', '[16,15,14]', 77, '0:0:0:0:0:0:0:1', '2021-04-26 17:53:32');
INSERT INTO `sys_log` VALUES (288, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":17,\"userId\":2,\"mobile\":\"13766998947\",\"deptName\":\"销售部\",\"deptId\":5,\"education\":\"本科\",\"userNo\":\"0002\",\"birth\":\"1999-06-06\",\"email\":\"1203313263@qq.com\",\"entryDate\":\"2021-04-13\",\"userType\":\"0\",\"createTime\":\"2021-04-26 17:54:04\"}', 150, '0:0:0:0:0:0:0:1', '2021-04-26 17:54:05');
INSERT INTO `sys_log` VALUES (289, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":45,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"合同管理\",\"type\":0,\"icon\":\"\",\"orderNum\":2}', 149, '0:0:0:0:0:0:0:1', '2021-04-26 18:01:42');
INSERT INTO `sys_log` VALUES (290, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":53,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"员工档案\",\"url\":\"modules/person/doc.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 71, '0:0:0:0:0:0:0:1', '2021-04-26 18:04:35');
INSERT INTO `sys_log` VALUES (291, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":53,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"员工信息\",\"url\":\"modules/person/doc.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 72, '0:0:0:0:0:0:0:1', '2021-04-26 18:05:01');
INSERT INTO `sys_log` VALUES (292, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":18,\"userId\":2,\"mobile\":\"13766998954\",\"deptName\":\"销售部\",\"deptId\":5,\"education\":\"本科\",\"userNo\":\"0002\",\"birth\":\"1998-03-06\",\"email\":\"1203313263@qq.com\",\"entryDate\":\"2021-04-26\",\"createTime\":\"2021-04-26 18:09:55\"}', 178, '0:0:0:0:0:0:0:1', '2021-04-26 18:09:56');
INSERT INTO `sys_log` VALUES (293, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":19,\"userId\":3,\"mobile\":\"13766998956\",\"deptName\":\"财务部\",\"deptId\":6,\"education\":\"本科\",\"userNo\":\"0003\",\"birth\":\"1998-06-30\",\"email\":\"1203313263@163.com\",\"entryDate\":\"2021-04-19\",\"createTime\":\"2021-04-26 18:10:39\"}', 117, '0:0:0:0:0:0:0:1', '2021-04-26 18:10:40');
INSERT INTO `sys_log` VALUES (294, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,73,52,79,53,69,70,71,72,92,93,94],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 229, '0:0:0:0:0:0:0:1', '2021-04-26 18:21:03');
INSERT INTO `sys_log` VALUES (295, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":4,\"roleName\":\"人事专员\",\"remark\":\"人事专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[1,2,15,16,17,18,31,32,41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,73,74,75,76,52,77,78,79,80,45,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:31:13 PM\"}', 108, '0:0:0:0:0:0:0:1', '2021-04-26 18:21:50');
INSERT INTO `sys_log` VALUES (296, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":5,\"roleName\":\"普通员工\",\"remark\":\"普通员工\",\"deptId\":4,\"deptName\":\"研发部\",\"menuIdList\":[41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,53,69,92,93,94,95,96,97],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"Apr 23, 2021 6:15:54 PM\"}', 92, '0:0:0:0:0:0:0:1', '2021-04-26 18:22:04');
INSERT INTO `sys_log` VALUES (297, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":4,\"roleName\":\"人事专员\",\"remark\":\"人事专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[1,2,15,16,17,18,31,32,41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,73,74,75,76,52,77,78,79,80,45,53,69,70,71,72],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:31:13 PM\"}', 119, '0:0:0:0:0:0:0:1', '2021-04-26 18:22:16');
INSERT INTO `sys_log` VALUES (298, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":53,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"员工信息\",\"url\":\"modules/person/doc.html\",\"type\":0,\"icon\":\"\",\"orderNum\":0}', 144, '0:0:0:0:0:0:0:1', '2021-04-26 18:23:05');
INSERT INTO `sys_log` VALUES (299, 'admin', '保存菜单', 'com.person.modules.sys.controller.SysMenuController.save()', '{\"menuId\":103,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"员工信息\",\"type\":0,\"orderNum\":0}', 42, '0:0:0:0:0:0:0:1', '2021-04-26 18:23:36');
INSERT INTO `sys_log` VALUES (300, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":53,\"parentId\":53,\"parentName\":\"员工信息\",\"name\":\"个人信息\",\"url\":\"modules/person/doc.html\",\"type\":0,\"icon\":\"\",\"orderNum\":0}', 99, '0:0:0:0:0:0:0:1', '2021-04-26 18:24:10');
INSERT INTO `sys_log` VALUES (301, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":53,\"parentId\":103,\"parentName\":\"员工信息\",\"name\":\"个人信息\",\"url\":\"modules/person/doc.html\",\"type\":1,\"icon\":\"\",\"orderNum\":0}', 185, '0:0:0:0:0:0:0:1', '2021-04-26 18:25:11');
INSERT INTO `sys_log` VALUES (302, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,73,52,79,92,93,94,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 71, '0:0:0:0:0:0:0:1', '2021-04-26 18:27:22');
INSERT INTO `sys_log` VALUES (303, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":5,\"roleName\":\"普通员工\",\"remark\":\"普通员工\",\"deptId\":4,\"deptName\":\"研发部\",\"menuIdList\":[41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,92,93,94,95,96,97,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"Apr 23, 2021 6:15:54 PM\"}', 91, '0:0:0:0:0:0:0:1', '2021-04-26 18:27:43');
INSERT INTO `sys_log` VALUES (304, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,44,51,73,52,79,92,93,94,103,53,69,70,72],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 169, '0:0:0:0:0:0:0:1', '2021-04-26 18:30:25');
INSERT INTO `sys_log` VALUES (305, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":2,\"roleName\":\"总经理\",\"remark\":\"总经理\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[1,2,15,16,17,18,3,19,20,21,22,4,23,24,25,26,31,32,33,34,35,36,37,38,39,40,41,56,81,82,83,84,42,54,62,63,64,86,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,44,51,73,74,75,76,52,77,78,79,80,45,87,88,89,90,91,92,93,94,95,96,97,103,53,69,70,71,72],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:29:43 PM\"}', 191, '0:0:0:0:0:0:0:1', '2021-04-26 18:30:40');
INSERT INTO `sys_log` VALUES (306, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,44,51,73,52,77,79,92,93,94,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 121, '0:0:0:0:0:0:0:1', '2021-04-26 18:31:51');
INSERT INTO `sys_log` VALUES (307, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":4,\"roleName\":\"人事专员\",\"remark\":\"人事专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[1,2,15,16,17,18,31,32,41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,44,51,73,74,75,76,52,77,78,79,80,45,103,53,69,70,71,72],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:31:13 PM\"}', 96, '0:0:0:0:0:0:0:1', '2021-04-26 18:32:15');
INSERT INTO `sys_log` VALUES (308, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":5,\"roleName\":\"普通员工\",\"remark\":\"普通员工\",\"deptId\":4,\"deptName\":\"研发部\",\"menuIdList\":[41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,92,93,94,95,96,97,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"Apr 23, 2021 6:15:54 PM\"}', 121, '0:0:0:0:0:0:0:1', '2021-04-26 18:32:30');
INSERT INTO `sys_log` VALUES (309, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[1,31,32,41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,44,51,73,52,77,79,92,93,94,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 267, '0:0:0:0:0:0:0:1', '2021-04-26 18:42:48');
INSERT INTO `sys_log` VALUES (310, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":1,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"公司后台\",\"type\":0,\"icon\":\"\",\"orderNum\":10}', 145, '0:0:0:0:0:0:0:1', '2021-04-26 18:55:35');
INSERT INTO `sys_log` VALUES (311, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":20,\"userId\":8,\"age\":0,\"mobile\":\"13766998947\",\"deptName\":\"研发部\",\"deptId\":4,\"education\":\"本科\",\"userNo\":\"0008\",\"birth\":\"1998-06-25\",\"email\":\"1203313263@qq.com\",\"entryDate\":\"2021-04-12\",\"createTime\":\"2021-04-26 18:56:54\"}', 211, '0:0:0:0:0:0:0:1', '2021-04-26 18:56:55');
INSERT INTO `sys_log` VALUES (312, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,44,51,73,52,77,79,92,93,94,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 148, '0:0:0:0:0:0:0:1', '2021-04-26 18:57:59');
INSERT INTO `sys_log` VALUES (313, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[1,31,32,41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,44,51,73,52,77,79,92,93,94,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 126, '0:0:0:0:0:0:0:1', '2021-04-26 18:59:20');
INSERT INTO `sys_log` VALUES (314, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":45,\"userId\":3,\"salaryMonth\":\"2020-05\",\"mustSalary\":5000.0,\"fundAmount\":100.0,\"taxAmount\":120.0,\"medicalAmount\":15.0,\"pensionAmount\":402.0,\"injuredAmount\":10.0,\"salarySum\":4383.0,\"createTime\":\"2021-04-26 19:24:40\"}', 1557, '0:0:0:0:0:0:0:1', '2021-04-26 19:24:42');
INSERT INTO `sys_log` VALUES (315, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":66,\"userId\":1,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-27\",\"upTime\":\"10:25:45\",\"upStatus\":1,\"createTime\":\"2021-04-26 19:26:28\"}', 77, '0:0:0:0:0:0:0:1', '2021-04-26 19:26:29');
INSERT INTO `sys_log` VALUES (316, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":15,\"candidate\":\"刘清华\",\"candidateMobile\":\"12033668947\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-29 11:30:51\",\"meetUserId\":8,\"status\":1,\"createTime\":\"2021-04-26 11:33:00\"}', 1515, '0:0:0:0:0:0:0:1', '2021-04-26 19:30:57');
INSERT INTO `sys_log` VALUES (317, 'admin', '保存面试', 'com.person.modules.person.controller.InterviewPlanController.save()', '{\"id\":16,\"candidate\":\"哈哈\",\"candidateMobile\":\"13766998947\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-20 19:45:20\",\"meetUserId\":4,\"status\":0,\"createTime\":\"2021-04-26 19:46:37\"}', 3086, '0:0:0:0:0:0:0:1', '2021-04-26 19:46:41');
INSERT INTO `sys_log` VALUES (318, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":46,\"userId\":12,\"salaryMonth\":\"2020-02\",\"mustSalary\":2000.0,\"fundAmount\":50.0,\"taxAmount\":20.0,\"medicalAmount\":500.0,\"pensionAmount\":128.0,\"injuredAmount\":100.0,\"salarySum\":2202.0,\"createTime\":\"2021-04-26 19:49:11\"}', 1737, '0:0:0:0:0:0:0:1', '2021-04-26 19:49:13');
INSERT INTO `sys_log` VALUES (319, 'admin', '修改个人计划', 'com.person.modules.person.controller.UserPlanController.update()', '{\"id\":38,\"userId\":1,\"name\":\"完成论文的撰写\",\"content\":\"一天写一节。\",\"startDate\":\"2021-04-25\",\"endDate\":\"2021-04-30\",\"status\":1,\"createTime\":\"2021-04-25 22:22:54\",\"updateTime\":\"2021-04-26 19:51:45\"}', 80, '0:0:0:0:0:0:0:1', '2021-04-26 19:51:46');
INSERT INTO `sys_log` VALUES (320, 'admin', '审核', 'com.person.modules.person.controller.ConvertApplyController.approval()', '{\"id\":7,\"applyUserId\":4,\"applyDate\":\"2020-05-17\",\"applyContent\":\"申请钢笔\",\"status\":1,\"approvalDate\":\"2021-04-25\",\"approvalUserId\":1,\"approvalResult\":1,\"approvalOpinion\":\"通过\",\"createTime\":\"2020-05-17 09:10:40\",\"updateTime\":\"2021-04-26 19:53:52\"}', 59, '0:0:0:0:0:0:0:1', '2021-04-26 19:53:52');
INSERT INTO `sys_log` VALUES (321, 'admin', '修改招聘要求', 'com.person.modules.person.controller.RecruitNeedController.update()', '{\"id\":11,\"needNum\":5,\"post\":\"JAVA开发\",\"education\":\"本科\",\"workTime\":2,\"demand\":\"无\",\"status\":1,\"createTime\":\"2021-04-23 20:33:05\"}', 121, '0:0:0:0:0:0:0:1', '2021-04-26 19:56:13');
INSERT INTO `sys_log` VALUES (322, 'admin', '保存绩效设置', 'com.person.modules.person.controller.MeritController.save()', '{\"id\":6,\"monthQuota\":\"1000\",\"weekQuota\":\"250\"}', 47, '0:0:0:0:0:0:0:1', '2021-04-26 20:01:35');
INSERT INTO `sys_log` VALUES (323, 'admin', '修改绩效设置', 'com.person.modules.person.controller.MeritController.update()', '{\"id\":6,\"setDate\":\"2021-03-31\",\"monthQuota\":\"1000\",\"weekQuota\":\"250\"}', 70, '0:0:0:0:0:0:0:1', '2021-04-26 20:01:41');
INSERT INTO `sys_log` VALUES (324, 'admin', '保存绩效设置', 'com.person.modules.person.controller.MeritController.save()', '{\"id\":11,\"setDate\":\"2021-04-26\",\"monthQuota\":\"400\",\"weekQuota\":\"100\"}', 90, '0:0:0:0:0:0:0:1', '2021-04-26 20:03:27');
INSERT INTO `sys_log` VALUES (325, 'admin', '保存招聘要求', 'com.person.modules.person.controller.RecruitNeedController.save()', '{\"id\":14,\"needNum\":10,\"post\":\"数据分析师\",\"education\":\"硕士\",\"workTime\":3,\"demand\":\"985毕业\",\"status\":0,\"recruitUserId\":3,\"needUserId\":4,\"createTime\":\"2021-04-26 20:05:57\"}', 167, '0:0:0:0:0:0:0:1', '2021-04-26 20:05:58');
INSERT INTO `sys_log` VALUES (326, 'admin', '修改面试', 'com.person.modules.person.controller.InterviewPlanController.update()', '{\"id\":11,\"candidate\":\"赵\",\"candidateMobile\":\"13455669874\",\"email\":\"1203313263@qq.com\",\"meetTime\":\"2021-04-20 10:50:46\",\"meetUserId\":3,\"status\":1,\"createTime\":\"2021-04-26 10:51:15\"}', 1584, '0:0:0:0:0:0:0:1', '2021-04-26 20:06:48');
INSERT INTO `sys_log` VALUES (327, 'admin', '保存工资', 'com.person.modules.person.controller.SalaryRecordController.save()', '{\"id\":47,\"userId\":8,\"salaryMonth\":\"2021-07\",\"mustSalary\":20000.0,\"fundAmount\":500.0,\"taxAmount\":200.0,\"medicalAmount\":400.0,\"pensionAmount\":3620.0,\"injuredAmount\":1200.0,\"salarySum\":14880.0,\"createTime\":\"2021-04-26 20:08:15\"}', 1592, '0:0:0:0:0:0:0:1', '2021-04-26 20:08:17');
INSERT INTO `sys_log` VALUES (328, 'admin', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":67,\"userId\":1,\"workMonth\":\"2021-03\",\"workDate\":\"2021-03-16\",\"upTime\":\"09:09:33\",\"upStatus\":1,\"createTime\":\"2021-04-26 20:09:47\"}', 141, '0:0:0:0:0:0:0:1', '2021-04-26 20:09:48');
INSERT INTO `sys_log` VALUES (329, 'admin', '删除考勤', 'com.person.modules.person.controller.WorkRecordController.delete()', '[62]', 105, '0:0:0:0:0:0:0:1', '2021-04-26 20:10:17');
INSERT INTO `sys_log` VALUES (330, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":21,\"userId\":4,\"age\":0,\"mobile\":\"13455664879\",\"education\":\"硕士\",\"userNo\":\"0004\",\"birth\":\"1999-04-05\",\"email\":\"1203313263@qq.com\",\"entryDate\":\"2021-04-25\",\"createTime\":\"2021-04-27 11:56:35\"}', 249, '0:0:0:0:0:0:0:1', '2021-04-27 11:56:36');
INSERT INTO `sys_log` VALUES (331, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":22,\"userId\":4,\"age\":0,\"mobile\":\"13766998947\",\"deptId\":7,\"education\":\"硕士\",\"userNo\":\"0004\",\"birth\":\"1999-04-21\",\"email\":\"1203313263@qq.com\",\"entryDate\":\"2021-04-25\",\"createTime\":\"2021-04-27 12:19:17\"}', 194, '0:0:0:0:0:0:0:1', '2021-04-27 12:19:18');
INSERT INTO `sys_log` VALUES (332, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":23,\"userId\":13,\"age\":0,\"mobile\":\"13766998947\",\"deptId\":7,\"education\":\"本科\",\"userNo\":\"0013\",\"birth\":\"1999-04-20\",\"email\":\"1203313263@qq.com\",\"entryDate\":\"2021-04-19\",\"createTime\":\"2021-04-27 12:20:34\"}', 117, '0:0:0:0:0:0:0:1', '2021-04-27 12:20:34');
INSERT INTO `sys_log` VALUES (333, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"userId\":8,\"age\":0,\"mobile\":\"13766998947\",\"education\":\"本科\",\"birth\":\"2009-04-06\",\"entryDate\":\"2021-04-27\",\"createTime\":\"2021-04-27 12:33:56\"}', 68, '0:0:0:0:0:0:0:1', '2021-04-27 12:33:57');
INSERT INTO `sys_log` VALUES (334, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":24,\"userId\":12,\"age\":0,\"mobile\":\"13766998947\",\"deptId\":5,\"education\":\"本科\",\"userNo\":\"0012\",\"birth\":\"2009-04-06\",\"email\":\"2229324592@qq.com\",\"entryDate\":\"2021-04-27\",\"createTime\":\"2021-04-27 12:34:00\"}', 55, '0:0:0:0:0:0:0:1', '2021-04-27 12:34:01');
INSERT INTO `sys_log` VALUES (335, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"userId\":13,\"age\":0,\"education\":\"硕士\",\"birth\":\"1997-03-05\",\"entryDate\":\"2021-04-12\",\"createTime\":\"2021-04-27 12:36:15\"}', 68, '0:0:0:0:0:0:0:1', '2021-04-27 12:36:15');
INSERT INTO `sys_log` VALUES (336, 'admin', '保存员工档案', 'com.person.modules.person.controller.UserDocController.save()', '{\"id\":25,\"userId\":15,\"age\":0,\"mobile\":\"13766998947\",\"deptId\":4,\"education\":\"硕士\",\"userNo\":\"0015\",\"birth\":\"1997-03-05\",\"email\":\"315335718@qq.com\",\"entryDate\":\"2021-04-12\",\"createTime\":\"2021-04-27 12:36:18\"}', 67, '0:0:0:0:0:0:0:1', '2021-04-27 12:36:19');
INSERT INTO `sys_log` VALUES (337, 'admin', '修改菜单', 'com.person.modules.sys.controller.SysMenuController.update()', '{\"menuId\":1,\"parentId\":0,\"parentName\":\"一级菜单\",\"name\":\"公司架构\",\"type\":0,\"icon\":\"\",\"orderNum\":10}', 94, '0:0:0:0:0:0:0:1', '2021-04-27 12:38:46');
INSERT INTO `sys_log` VALUES (338, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":5,\"roleName\":\"普通员工\",\"remark\":\"普通员工\",\"deptId\":4,\"deptName\":\"研发部\",\"menuIdList\":[1,31,32,41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,92,93,94,95,96,97,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"Apr 23, 2021 6:15:54 PM\"}', 207, '0:0:0:0:0:0:0:1', '2021-04-27 12:39:31');
INSERT INTO `sys_log` VALUES (339, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":5,\"roleName\":\"普通员工\",\"remark\":\"普通员工\",\"deptId\":4,\"deptName\":\"研发部\",\"menuIdList\":[41,56,81,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,100,101,102,92,93,94,95,96,97,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"Apr 23, 2021 6:15:54 PM\"}', 201, '0:0:0:0:0:0:0:1', '2021-04-27 12:49:38');
INSERT INTO `sys_log` VALUES (340, 'admin', '修改角色', 'com.person.modules.sys.controller.SysRoleController.update()', '{\"roleId\":3,\"roleName\":\"财务专员\",\"remark\":\"财务专员\",\"deptId\":3,\"deptName\":\"xxxxx技术有限公司上海分部\",\"menuIdList\":[41,56,81,82,83,84,42,54,62,63,64,43,46,47,48,49,50,55,58,59,60,61,57,65,66,67,68,85,98,99,44,51,73,52,77,79,92,93,94,103,53,69],\"deptIdList\":[1,3,4,5,6,7,8],\"createTime\":\"May 15, 2020 8:30:29 PM\"}', 134, '0:0:0:0:0:0:0:1', '2021-04-27 12:50:20');
INSERT INTO `sys_log` VALUES (341, 'rs', '保存考勤', 'com.person.modules.person.controller.WorkRecordController.save()', '{\"id\":68,\"userId\":4,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"06:50:47\",\"upStatus\":0,\"createTime\":\"2021-04-27 12:50:55\"}', 69, '0:0:0:0:0:0:0:1', '2021-04-27 12:50:56');
INSERT INTO `sys_log` VALUES (342, 'rs', '修改考勤', 'com.person.modules.person.controller.WorkRecordController.update()', '{\"id\":68,\"userId\":4,\"workMonth\":\"2021-04\",\"workDate\":\"2021-04-01\",\"upTime\":\"06:50:47\",\"downTime\":\"16:50:47\",\"status\":2,\"upStatus\":0,\"createTime\":\"2021-04-27 12:50:55\",\"updateTime\":\"2021-04-27 12:51:09\"}', 110, '0:0:0:0:0:0:0:1', '2021-04-27 12:51:10');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) NULL DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) NULL DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单管理' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, 0, '公司架构', NULL, NULL, 0, '', 10);
INSERT INTO `sys_menu` VALUES (2, 1, '员工管理', 'modules/sys/user.html', NULL, 1, '', 1);
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'modules/sys/role.html', NULL, 1, '', 2);
INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'modules/sys/menu.html', NULL, 1, '', 3);
INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:perms', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:perms', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (31, 1, '部门管理', 'modules/sys/dept.html', NULL, 1, '', 1);
INSERT INTO `sys_menu` VALUES (32, 31, '查看', NULL, 'sys:dept:list,sys:dept:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (33, 31, '新增', NULL, 'sys:dept:save,sys:dept:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (34, 31, '修改', NULL, 'sys:dept:update,sys:dept:select', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (35, 31, '删除', NULL, 'sys:dept:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (36, 1, '字典管理', 'modules/sys/dict.html', NULL, 1, '', 6);
INSERT INTO `sys_menu` VALUES (37, 36, '查看', NULL, 'sys:dict:list,sys:dict:info', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (38, 36, '新增', NULL, 'sys:dict:save', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (39, 36, '修改', NULL, 'sys:dict:update', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (40, 36, '删除', NULL, 'sys:dict:delete', 2, NULL, 6);
INSERT INTO `sys_menu` VALUES (41, 0, '工资管理', NULL, NULL, 0, '', 3);
INSERT INTO `sys_menu` VALUES (42, 0, '考勤管理', NULL, NULL, 0, '', 4);
INSERT INTO `sys_menu` VALUES (43, 0, '工作计划', NULL, NULL, 0, '', 5);
INSERT INTO `sys_menu` VALUES (44, 0, '人才招聘', NULL, NULL, 0, '', 1);
INSERT INTO `sys_menu` VALUES (45, 0, '合同管理', NULL, NULL, 0, '', 2);
INSERT INTO `sys_menu` VALUES (46, 43, '个人规划', 'modules/person/plan.html', '', 1, '', 0);
INSERT INTO `sys_menu` VALUES (47, 46, '查看', NULL, 'person:plan:list,person:plan:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (48, 46, '新增', NULL, 'person:plan:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (49, 46, '修改', NULL, 'person:plan:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (50, 46, '删除', NULL, 'person:plan:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (51, 44, '人才内推', 'modules/person/need.html', '', 1, '', 0);
INSERT INTO `sys_menu` VALUES (52, 44, '面试计划', 'modules/person/interview.html', '', 1, '', 0);
INSERT INTO `sys_menu` VALUES (53, 103, '个人信息', 'modules/person/doc.html', NULL, 1, '', 0);
INSERT INTO `sys_menu` VALUES (54, 42, '考勤记录', 'modules/person/work.html', NULL, 1, '', 0);
INSERT INTO `sys_menu` VALUES (55, 43, '工作周报', 'modules/person/daily.html', NULL, 1, '', 0);
INSERT INTO `sys_menu` VALUES (56, 41, '工资查询', 'modules/person/salary.html', NULL, 1, '', 0);
INSERT INTO `sys_menu` VALUES (57, 43, '个人申请', 'modules/person/apply.html', NULL, 1, '', 0);
INSERT INTO `sys_menu` VALUES (58, 55, '查询', '', 'person:daily:list,person:daily:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (59, 55, '增加', '', 'person:daily:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (60, 55, '编辑', NULL, 'person:daily:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (61, 55, '删除', NULL, 'person:daily:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (62, 54, '查询', NULL, 'person:work:list,person:work:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (63, 54, '上班', NULL, 'person:work:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (64, 54, '下班', NULL, 'person:work:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (65, 57, '申请', NULL, 'person:apply:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (66, 57, '查看', NULL, 'person:apply:list,person:apply:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (67, 57, '删除', NULL, 'person:apply:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (68, 57, '编辑', NULL, 'person:apply:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (69, 53, '查看', NULL, 'person:doc:list,person:doc:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (70, 53, '新增', NULL, 'person:doc:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (71, 53, '编辑', NULL, 'person:doc:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (72, 53, '删除', NULL, 'person:doc:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (73, 51, '查看', NULL, 'person:need:list,person:need:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (74, 51, '新增', NULL, 'person:need:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (75, 51, '编辑', NULL, 'person:need:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (76, 51, '删除', NULL, 'person:need:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (77, 52, '查看', NULL, 'person:interview:list,person:interview:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (78, 52, '新增', NULL, 'person:interview:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (79, 52, '编辑', NULL, 'person:interview:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (80, 52, '删除', NULL, 'person:interview:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (81, 56, '查看', NULL, 'person:salary:list,person:salary:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (82, 56, '新增', NULL, 'person:salary:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (83, 56, '编辑', NULL, 'person:salary:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (84, 56, '删除', NULL, 'person:salary:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (85, 57, '审核', NULL, 'person:apply:approval', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (86, 54, '删除', NULL, 'person:work:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (87, 45, '合同管理', 'modules/person/contract.html', NULL, 1, '', 0);
INSERT INTO `sys_menu` VALUES (88, 87, '查看', NULL, 'person:contract:list,person:contract:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (89, 87, '增加', NULL, 'person:contract:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (90, 87, '编辑', NULL, 'person:contract:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (91, 87, '删除', NULL, 'person:contract:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (92, 0, '效绩指标', NULL, NULL, 0, '', 0);
INSERT INTO `sys_menu` VALUES (93, 92, '绩效设置', 'modules/person/merit.html', '#', 1, NULL, 0);
INSERT INTO `sys_menu` VALUES (94, 93, '查看', NULL, 'person:merit:list,person:merit:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (95, 93, '增加', NULL, 'person:merit:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (96, 93, '编辑', NULL, 'person:merit:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (97, 93, '删除', NULL, 'person:merit:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (98, 43, '培训计划', 'modules/person/train.html', NULL, 1, NULL, 0);
INSERT INTO `sys_menu` VALUES (99, 98, '查看', NULL, 'person:train:list,person:train:info', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (100, 98, '新增', NULL, 'person:train:save', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (101, 98, '编辑', NULL, 'person:train:update', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (102, 98, '删除', NULL, 'person:train:delete', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (103, 0, '员工信息', NULL, NULL, 0, NULL, 0);

-- ----------------------------
-- Table structure for sys_oss
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文件上传' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '管理员', '超级管理员', 1, '2020-05-14 22:28:37');
INSERT INTO `sys_role` VALUES (2, '总经理', '总经理', 3, '2020-05-15 20:29:43');
INSERT INTO `sys_role` VALUES (3, '财务专员', '财务专员', 3, '2020-05-15 20:30:29');
INSERT INTO `sys_role` VALUES (4, '人事专员', '人事专员', 3, '2020-05-15 20:31:13');
INSERT INTO `sys_role` VALUES (5, '普通员工', '普通员工', 4, '2021-04-23 18:15:54');

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 189 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与部门对应关系' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
INSERT INTO `sys_role_dept` VALUES (19, 1, 1);
INSERT INTO `sys_role_dept` VALUES (20, 1, 3);
INSERT INTO `sys_role_dept` VALUES (21, 1, 4);
INSERT INTO `sys_role_dept` VALUES (22, 1, 5);
INSERT INTO `sys_role_dept` VALUES (141, 2, 1);
INSERT INTO `sys_role_dept` VALUES (142, 2, 3);
INSERT INTO `sys_role_dept` VALUES (143, 2, 4);
INSERT INTO `sys_role_dept` VALUES (144, 2, 5);
INSERT INTO `sys_role_dept` VALUES (145, 2, 6);
INSERT INTO `sys_role_dept` VALUES (146, 2, 7);
INSERT INTO `sys_role_dept` VALUES (147, 2, 8);
INSERT INTO `sys_role_dept` VALUES (155, 4, 1);
INSERT INTO `sys_role_dept` VALUES (156, 4, 3);
INSERT INTO `sys_role_dept` VALUES (157, 4, 4);
INSERT INTO `sys_role_dept` VALUES (158, 4, 5);
INSERT INTO `sys_role_dept` VALUES (159, 4, 6);
INSERT INTO `sys_role_dept` VALUES (160, 4, 7);
INSERT INTO `sys_role_dept` VALUES (161, 4, 8);
INSERT INTO `sys_role_dept` VALUES (197, 5, 1);
INSERT INTO `sys_role_dept` VALUES (198, 5, 3);
INSERT INTO `sys_role_dept` VALUES (199, 5, 4);
INSERT INTO `sys_role_dept` VALUES (200, 5, 5);
INSERT INTO `sys_role_dept` VALUES (201, 5, 6);
INSERT INTO `sys_role_dept` VALUES (202, 5, 7);
INSERT INTO `sys_role_dept` VALUES (203, 5, 8);
INSERT INTO `sys_role_dept` VALUES (204, 3, 1);
INSERT INTO `sys_role_dept` VALUES (205, 3, 3);
INSERT INTO `sys_role_dept` VALUES (206, 3, 4);
INSERT INTO `sys_role_dept` VALUES (207, 3, 5);
INSERT INTO `sys_role_dept` VALUES (208, 3, 6);
INSERT INTO `sys_role_dept` VALUES (209, 3, 7);
INSERT INTO `sys_role_dept` VALUES (210, 3, 8);

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1425 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色与菜单对应关系' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (217, 1, 1);
INSERT INTO `sys_role_menu` VALUES (218, 1, 2);
INSERT INTO `sys_role_menu` VALUES (219, 1, 15);
INSERT INTO `sys_role_menu` VALUES (220, 1, 16);
INSERT INTO `sys_role_menu` VALUES (221, 1, 17);
INSERT INTO `sys_role_menu` VALUES (222, 1, 18);
INSERT INTO `sys_role_menu` VALUES (223, 1, 3);
INSERT INTO `sys_role_menu` VALUES (224, 1, 19);
INSERT INTO `sys_role_menu` VALUES (225, 1, 20);
INSERT INTO `sys_role_menu` VALUES (226, 1, 21);
INSERT INTO `sys_role_menu` VALUES (227, 1, 22);
INSERT INTO `sys_role_menu` VALUES (228, 1, 4);
INSERT INTO `sys_role_menu` VALUES (229, 1, 23);
INSERT INTO `sys_role_menu` VALUES (230, 1, 24);
INSERT INTO `sys_role_menu` VALUES (231, 1, 25);
INSERT INTO `sys_role_menu` VALUES (232, 1, 26);
INSERT INTO `sys_role_menu` VALUES (233, 1, 31);
INSERT INTO `sys_role_menu` VALUES (234, 1, 32);
INSERT INTO `sys_role_menu` VALUES (235, 1, 33);
INSERT INTO `sys_role_menu` VALUES (236, 1, 34);
INSERT INTO `sys_role_menu` VALUES (237, 1, 35);
INSERT INTO `sys_role_menu` VALUES (238, 1, 36);
INSERT INTO `sys_role_menu` VALUES (239, 1, 37);
INSERT INTO `sys_role_menu` VALUES (240, 1, 38);
INSERT INTO `sys_role_menu` VALUES (241, 1, 39);
INSERT INTO `sys_role_menu` VALUES (242, 1, 40);
INSERT INTO `sys_role_menu` VALUES (243, 1, 41);
INSERT INTO `sys_role_menu` VALUES (244, 1, 56);
INSERT INTO `sys_role_menu` VALUES (245, 1, 81);
INSERT INTO `sys_role_menu` VALUES (246, 1, 82);
INSERT INTO `sys_role_menu` VALUES (247, 1, 83);
INSERT INTO `sys_role_menu` VALUES (248, 1, 84);
INSERT INTO `sys_role_menu` VALUES (249, 1, 42);
INSERT INTO `sys_role_menu` VALUES (250, 1, 54);
INSERT INTO `sys_role_menu` VALUES (251, 1, 43);
INSERT INTO `sys_role_menu` VALUES (252, 1, 46);
INSERT INTO `sys_role_menu` VALUES (253, 1, 47);
INSERT INTO `sys_role_menu` VALUES (254, 1, 48);
INSERT INTO `sys_role_menu` VALUES (255, 1, 49);
INSERT INTO `sys_role_menu` VALUES (256, 1, 50);
INSERT INTO `sys_role_menu` VALUES (257, 1, 55);
INSERT INTO `sys_role_menu` VALUES (258, 1, 58);
INSERT INTO `sys_role_menu` VALUES (259, 1, 59);
INSERT INTO `sys_role_menu` VALUES (260, 1, 60);
INSERT INTO `sys_role_menu` VALUES (261, 1, 61);
INSERT INTO `sys_role_menu` VALUES (262, 1, 57);
INSERT INTO `sys_role_menu` VALUES (263, 1, 65);
INSERT INTO `sys_role_menu` VALUES (264, 1, 66);
INSERT INTO `sys_role_menu` VALUES (265, 1, 67);
INSERT INTO `sys_role_menu` VALUES (266, 1, 68);
INSERT INTO `sys_role_menu` VALUES (267, 1, 85);
INSERT INTO `sys_role_menu` VALUES (268, 1, 44);
INSERT INTO `sys_role_menu` VALUES (269, 1, 51);
INSERT INTO `sys_role_menu` VALUES (270, 1, 73);
INSERT INTO `sys_role_menu` VALUES (271, 1, 74);
INSERT INTO `sys_role_menu` VALUES (272, 1, 75);
INSERT INTO `sys_role_menu` VALUES (273, 1, 76);
INSERT INTO `sys_role_menu` VALUES (274, 1, 52);
INSERT INTO `sys_role_menu` VALUES (275, 1, 77);
INSERT INTO `sys_role_menu` VALUES (276, 1, 78);
INSERT INTO `sys_role_menu` VALUES (277, 1, 79);
INSERT INTO `sys_role_menu` VALUES (278, 1, 80);
INSERT INTO `sys_role_menu` VALUES (279, 1, 45);
INSERT INTO `sys_role_menu` VALUES (280, 1, 53);
INSERT INTO `sys_role_menu` VALUES (281, 1, 69);
INSERT INTO `sys_role_menu` VALUES (282, 1, 70);
INSERT INTO `sys_role_menu` VALUES (283, 1, 71);
INSERT INTO `sys_role_menu` VALUES (284, 1, 72);
INSERT INTO `sys_role_menu` VALUES (1071, 2, 1);
INSERT INTO `sys_role_menu` VALUES (1072, 2, 2);
INSERT INTO `sys_role_menu` VALUES (1073, 2, 15);
INSERT INTO `sys_role_menu` VALUES (1074, 2, 16);
INSERT INTO `sys_role_menu` VALUES (1075, 2, 17);
INSERT INTO `sys_role_menu` VALUES (1076, 2, 18);
INSERT INTO `sys_role_menu` VALUES (1077, 2, 3);
INSERT INTO `sys_role_menu` VALUES (1078, 2, 19);
INSERT INTO `sys_role_menu` VALUES (1079, 2, 20);
INSERT INTO `sys_role_menu` VALUES (1080, 2, 21);
INSERT INTO `sys_role_menu` VALUES (1081, 2, 22);
INSERT INTO `sys_role_menu` VALUES (1082, 2, 4);
INSERT INTO `sys_role_menu` VALUES (1083, 2, 23);
INSERT INTO `sys_role_menu` VALUES (1084, 2, 24);
INSERT INTO `sys_role_menu` VALUES (1085, 2, 25);
INSERT INTO `sys_role_menu` VALUES (1086, 2, 26);
INSERT INTO `sys_role_menu` VALUES (1087, 2, 31);
INSERT INTO `sys_role_menu` VALUES (1088, 2, 32);
INSERT INTO `sys_role_menu` VALUES (1089, 2, 33);
INSERT INTO `sys_role_menu` VALUES (1090, 2, 34);
INSERT INTO `sys_role_menu` VALUES (1091, 2, 35);
INSERT INTO `sys_role_menu` VALUES (1092, 2, 36);
INSERT INTO `sys_role_menu` VALUES (1093, 2, 37);
INSERT INTO `sys_role_menu` VALUES (1094, 2, 38);
INSERT INTO `sys_role_menu` VALUES (1095, 2, 39);
INSERT INTO `sys_role_menu` VALUES (1096, 2, 40);
INSERT INTO `sys_role_menu` VALUES (1097, 2, 41);
INSERT INTO `sys_role_menu` VALUES (1098, 2, 56);
INSERT INTO `sys_role_menu` VALUES (1099, 2, 81);
INSERT INTO `sys_role_menu` VALUES (1100, 2, 82);
INSERT INTO `sys_role_menu` VALUES (1101, 2, 83);
INSERT INTO `sys_role_menu` VALUES (1102, 2, 84);
INSERT INTO `sys_role_menu` VALUES (1103, 2, 42);
INSERT INTO `sys_role_menu` VALUES (1104, 2, 54);
INSERT INTO `sys_role_menu` VALUES (1105, 2, 62);
INSERT INTO `sys_role_menu` VALUES (1106, 2, 63);
INSERT INTO `sys_role_menu` VALUES (1107, 2, 64);
INSERT INTO `sys_role_menu` VALUES (1108, 2, 86);
INSERT INTO `sys_role_menu` VALUES (1109, 2, 43);
INSERT INTO `sys_role_menu` VALUES (1110, 2, 46);
INSERT INTO `sys_role_menu` VALUES (1111, 2, 47);
INSERT INTO `sys_role_menu` VALUES (1112, 2, 48);
INSERT INTO `sys_role_menu` VALUES (1113, 2, 49);
INSERT INTO `sys_role_menu` VALUES (1114, 2, 50);
INSERT INTO `sys_role_menu` VALUES (1115, 2, 55);
INSERT INTO `sys_role_menu` VALUES (1116, 2, 58);
INSERT INTO `sys_role_menu` VALUES (1117, 2, 59);
INSERT INTO `sys_role_menu` VALUES (1118, 2, 60);
INSERT INTO `sys_role_menu` VALUES (1119, 2, 61);
INSERT INTO `sys_role_menu` VALUES (1120, 2, 57);
INSERT INTO `sys_role_menu` VALUES (1121, 2, 65);
INSERT INTO `sys_role_menu` VALUES (1122, 2, 66);
INSERT INTO `sys_role_menu` VALUES (1123, 2, 67);
INSERT INTO `sys_role_menu` VALUES (1124, 2, 68);
INSERT INTO `sys_role_menu` VALUES (1125, 2, 85);
INSERT INTO `sys_role_menu` VALUES (1126, 2, 98);
INSERT INTO `sys_role_menu` VALUES (1127, 2, 99);
INSERT INTO `sys_role_menu` VALUES (1128, 2, 100);
INSERT INTO `sys_role_menu` VALUES (1129, 2, 101);
INSERT INTO `sys_role_menu` VALUES (1130, 2, 102);
INSERT INTO `sys_role_menu` VALUES (1131, 2, 44);
INSERT INTO `sys_role_menu` VALUES (1132, 2, 51);
INSERT INTO `sys_role_menu` VALUES (1133, 2, 73);
INSERT INTO `sys_role_menu` VALUES (1134, 2, 74);
INSERT INTO `sys_role_menu` VALUES (1135, 2, 75);
INSERT INTO `sys_role_menu` VALUES (1136, 2, 76);
INSERT INTO `sys_role_menu` VALUES (1137, 2, 52);
INSERT INTO `sys_role_menu` VALUES (1138, 2, 77);
INSERT INTO `sys_role_menu` VALUES (1139, 2, 78);
INSERT INTO `sys_role_menu` VALUES (1140, 2, 79);
INSERT INTO `sys_role_menu` VALUES (1141, 2, 80);
INSERT INTO `sys_role_menu` VALUES (1142, 2, 45);
INSERT INTO `sys_role_menu` VALUES (1143, 2, 87);
INSERT INTO `sys_role_menu` VALUES (1144, 2, 88);
INSERT INTO `sys_role_menu` VALUES (1145, 2, 89);
INSERT INTO `sys_role_menu` VALUES (1146, 2, 90);
INSERT INTO `sys_role_menu` VALUES (1147, 2, 91);
INSERT INTO `sys_role_menu` VALUES (1148, 2, 92);
INSERT INTO `sys_role_menu` VALUES (1149, 2, 93);
INSERT INTO `sys_role_menu` VALUES (1150, 2, 94);
INSERT INTO `sys_role_menu` VALUES (1151, 2, 95);
INSERT INTO `sys_role_menu` VALUES (1152, 2, 96);
INSERT INTO `sys_role_menu` VALUES (1153, 2, 97);
INSERT INTO `sys_role_menu` VALUES (1154, 2, 103);
INSERT INTO `sys_role_menu` VALUES (1155, 2, 53);
INSERT INTO `sys_role_menu` VALUES (1156, 2, 69);
INSERT INTO `sys_role_menu` VALUES (1157, 2, 70);
INSERT INTO `sys_role_menu` VALUES (1158, 2, 71);
INSERT INTO `sys_role_menu` VALUES (1159, 2, 72);
INSERT INTO `sys_role_menu` VALUES (1202, 4, 1);
INSERT INTO `sys_role_menu` VALUES (1203, 4, 2);
INSERT INTO `sys_role_menu` VALUES (1204, 4, 15);
INSERT INTO `sys_role_menu` VALUES (1205, 4, 16);
INSERT INTO `sys_role_menu` VALUES (1206, 4, 17);
INSERT INTO `sys_role_menu` VALUES (1207, 4, 18);
INSERT INTO `sys_role_menu` VALUES (1208, 4, 31);
INSERT INTO `sys_role_menu` VALUES (1209, 4, 32);
INSERT INTO `sys_role_menu` VALUES (1210, 4, 41);
INSERT INTO `sys_role_menu` VALUES (1211, 4, 56);
INSERT INTO `sys_role_menu` VALUES (1212, 4, 81);
INSERT INTO `sys_role_menu` VALUES (1213, 4, 42);
INSERT INTO `sys_role_menu` VALUES (1214, 4, 54);
INSERT INTO `sys_role_menu` VALUES (1215, 4, 62);
INSERT INTO `sys_role_menu` VALUES (1216, 4, 63);
INSERT INTO `sys_role_menu` VALUES (1217, 4, 64);
INSERT INTO `sys_role_menu` VALUES (1218, 4, 43);
INSERT INTO `sys_role_menu` VALUES (1219, 4, 46);
INSERT INTO `sys_role_menu` VALUES (1220, 4, 47);
INSERT INTO `sys_role_menu` VALUES (1221, 4, 48);
INSERT INTO `sys_role_menu` VALUES (1222, 4, 49);
INSERT INTO `sys_role_menu` VALUES (1223, 4, 50);
INSERT INTO `sys_role_menu` VALUES (1224, 4, 55);
INSERT INTO `sys_role_menu` VALUES (1225, 4, 58);
INSERT INTO `sys_role_menu` VALUES (1226, 4, 59);
INSERT INTO `sys_role_menu` VALUES (1227, 4, 60);
INSERT INTO `sys_role_menu` VALUES (1228, 4, 61);
INSERT INTO `sys_role_menu` VALUES (1229, 4, 57);
INSERT INTO `sys_role_menu` VALUES (1230, 4, 65);
INSERT INTO `sys_role_menu` VALUES (1231, 4, 66);
INSERT INTO `sys_role_menu` VALUES (1232, 4, 67);
INSERT INTO `sys_role_menu` VALUES (1233, 4, 68);
INSERT INTO `sys_role_menu` VALUES (1234, 4, 85);
INSERT INTO `sys_role_menu` VALUES (1235, 4, 98);
INSERT INTO `sys_role_menu` VALUES (1236, 4, 99);
INSERT INTO `sys_role_menu` VALUES (1237, 4, 44);
INSERT INTO `sys_role_menu` VALUES (1238, 4, 51);
INSERT INTO `sys_role_menu` VALUES (1239, 4, 73);
INSERT INTO `sys_role_menu` VALUES (1240, 4, 74);
INSERT INTO `sys_role_menu` VALUES (1241, 4, 75);
INSERT INTO `sys_role_menu` VALUES (1242, 4, 76);
INSERT INTO `sys_role_menu` VALUES (1243, 4, 52);
INSERT INTO `sys_role_menu` VALUES (1244, 4, 77);
INSERT INTO `sys_role_menu` VALUES (1245, 4, 78);
INSERT INTO `sys_role_menu` VALUES (1246, 4, 79);
INSERT INTO `sys_role_menu` VALUES (1247, 4, 80);
INSERT INTO `sys_role_menu` VALUES (1248, 4, 45);
INSERT INTO `sys_role_menu` VALUES (1249, 4, 103);
INSERT INTO `sys_role_menu` VALUES (1250, 4, 53);
INSERT INTO `sys_role_menu` VALUES (1251, 4, 69);
INSERT INTO `sys_role_menu` VALUES (1252, 4, 70);
INSERT INTO `sys_role_menu` VALUES (1253, 4, 71);
INSERT INTO `sys_role_menu` VALUES (1254, 4, 72);
INSERT INTO `sys_role_menu` VALUES (1468, 5, 41);
INSERT INTO `sys_role_menu` VALUES (1469, 5, 56);
INSERT INTO `sys_role_menu` VALUES (1470, 5, 81);
INSERT INTO `sys_role_menu` VALUES (1471, 5, 42);
INSERT INTO `sys_role_menu` VALUES (1472, 5, 54);
INSERT INTO `sys_role_menu` VALUES (1473, 5, 62);
INSERT INTO `sys_role_menu` VALUES (1474, 5, 63);
INSERT INTO `sys_role_menu` VALUES (1475, 5, 64);
INSERT INTO `sys_role_menu` VALUES (1476, 5, 43);
INSERT INTO `sys_role_menu` VALUES (1477, 5, 46);
INSERT INTO `sys_role_menu` VALUES (1478, 5, 47);
INSERT INTO `sys_role_menu` VALUES (1479, 5, 48);
INSERT INTO `sys_role_menu` VALUES (1480, 5, 49);
INSERT INTO `sys_role_menu` VALUES (1481, 5, 50);
INSERT INTO `sys_role_menu` VALUES (1482, 5, 55);
INSERT INTO `sys_role_menu` VALUES (1483, 5, 58);
INSERT INTO `sys_role_menu` VALUES (1484, 5, 59);
INSERT INTO `sys_role_menu` VALUES (1485, 5, 60);
INSERT INTO `sys_role_menu` VALUES (1486, 5, 61);
INSERT INTO `sys_role_menu` VALUES (1487, 5, 57);
INSERT INTO `sys_role_menu` VALUES (1488, 5, 65);
INSERT INTO `sys_role_menu` VALUES (1489, 5, 66);
INSERT INTO `sys_role_menu` VALUES (1490, 5, 67);
INSERT INTO `sys_role_menu` VALUES (1491, 5, 68);
INSERT INTO `sys_role_menu` VALUES (1492, 5, 85);
INSERT INTO `sys_role_menu` VALUES (1493, 5, 98);
INSERT INTO `sys_role_menu` VALUES (1494, 5, 99);
INSERT INTO `sys_role_menu` VALUES (1495, 5, 100);
INSERT INTO `sys_role_menu` VALUES (1496, 5, 101);
INSERT INTO `sys_role_menu` VALUES (1497, 5, 102);
INSERT INTO `sys_role_menu` VALUES (1498, 5, 92);
INSERT INTO `sys_role_menu` VALUES (1499, 5, 93);
INSERT INTO `sys_role_menu` VALUES (1500, 5, 94);
INSERT INTO `sys_role_menu` VALUES (1501, 5, 95);
INSERT INTO `sys_role_menu` VALUES (1502, 5, 96);
INSERT INTO `sys_role_menu` VALUES (1503, 5, 97);
INSERT INTO `sys_role_menu` VALUES (1504, 5, 103);
INSERT INTO `sys_role_menu` VALUES (1505, 5, 53);
INSERT INTO `sys_role_menu` VALUES (1506, 5, 69);
INSERT INTO `sys_role_menu` VALUES (1507, 3, 41);
INSERT INTO `sys_role_menu` VALUES (1508, 3, 56);
INSERT INTO `sys_role_menu` VALUES (1509, 3, 81);
INSERT INTO `sys_role_menu` VALUES (1510, 3, 82);
INSERT INTO `sys_role_menu` VALUES (1511, 3, 83);
INSERT INTO `sys_role_menu` VALUES (1512, 3, 84);
INSERT INTO `sys_role_menu` VALUES (1513, 3, 42);
INSERT INTO `sys_role_menu` VALUES (1514, 3, 54);
INSERT INTO `sys_role_menu` VALUES (1515, 3, 62);
INSERT INTO `sys_role_menu` VALUES (1516, 3, 63);
INSERT INTO `sys_role_menu` VALUES (1517, 3, 64);
INSERT INTO `sys_role_menu` VALUES (1518, 3, 43);
INSERT INTO `sys_role_menu` VALUES (1519, 3, 46);
INSERT INTO `sys_role_menu` VALUES (1520, 3, 47);
INSERT INTO `sys_role_menu` VALUES (1521, 3, 48);
INSERT INTO `sys_role_menu` VALUES (1522, 3, 49);
INSERT INTO `sys_role_menu` VALUES (1523, 3, 50);
INSERT INTO `sys_role_menu` VALUES (1524, 3, 55);
INSERT INTO `sys_role_menu` VALUES (1525, 3, 58);
INSERT INTO `sys_role_menu` VALUES (1526, 3, 59);
INSERT INTO `sys_role_menu` VALUES (1527, 3, 60);
INSERT INTO `sys_role_menu` VALUES (1528, 3, 61);
INSERT INTO `sys_role_menu` VALUES (1529, 3, 57);
INSERT INTO `sys_role_menu` VALUES (1530, 3, 65);
INSERT INTO `sys_role_menu` VALUES (1531, 3, 66);
INSERT INTO `sys_role_menu` VALUES (1532, 3, 67);
INSERT INTO `sys_role_menu` VALUES (1533, 3, 68);
INSERT INTO `sys_role_menu` VALUES (1534, 3, 85);
INSERT INTO `sys_role_menu` VALUES (1535, 3, 98);
INSERT INTO `sys_role_menu` VALUES (1536, 3, 99);
INSERT INTO `sys_role_menu` VALUES (1537, 3, 44);
INSERT INTO `sys_role_menu` VALUES (1538, 3, 51);
INSERT INTO `sys_role_menu` VALUES (1539, 3, 73);
INSERT INTO `sys_role_menu` VALUES (1540, 3, 52);
INSERT INTO `sys_role_menu` VALUES (1541, 3, 77);
INSERT INTO `sys_role_menu` VALUES (1542, 3, 79);
INSERT INTO `sys_role_menu` VALUES (1543, 3, 92);
INSERT INTO `sys_role_menu` VALUES (1544, 3, 93);
INSERT INTO `sys_role_menu` VALUES (1545, 3, 94);
INSERT INTO `sys_role_menu` VALUES (1546, 3, 103);
INSERT INTO `sys_role_menu` VALUES (1547, 3, 53);
INSERT INTO `sys_role_menu` VALUES (1548, 3, 69);

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '盐',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_no` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统用户' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', 'e1153123d7d180ceeb820d577ff119876678732a68eef4e6ffc0b1f06a01f91b', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', 1, 1, '2016-11-11 11:11:11', '管理员', '0001');
INSERT INTO `sys_user` VALUES (2, 'dsh', '465eb796858668c09235a6b8e2c9992aecaebf6a84bf5e9cc0929f5587fe15d2', '1sbkoGf5x7Q5lqxvCs5I', '1203313263@qq.com', '18651234456', 1, 4, '2020-05-15 22:29:02', '代胜辉', '0002');
INSERT INTO `sys_user` VALUES (3, 'cw', '676bd505a6d523cb00f4f79bf6dc7a2954d761a3aee0d045c21f8d6e2172a179', '2E5mvF1xjXFoY0narVz9', '1203313263@qq.com', '13455676543', 1, 6, '2020-05-16 15:11:08', '小明_财务', '0003');
INSERT INTO `sys_user` VALUES (4, 'rs', 'c4ade571b45f569230b7782b9d657bc6e724913d7d429bf742ad17dabf0753bc', 'NF4cYNKNmsMA997exGGN', '1203313263@qq.com', '19877678790', 1, 7, '2020-05-16 15:11:43', '小李_人事', '0004');
INSERT INTO `sys_user` VALUES (8, 'lqh', '499d422f59bbe7665c7660cfb70f8511e7785a7f3bbca2132f08ed7f92f89b36', 'Qp1dOgRJaFkhFMhe9ETF', '1203313263@qq.com', '13766998956', 1, 4, '2021-04-23 18:16:56', '刘清华', NULL);
INSERT INTO `sys_user` VALUES (12, 'haiyang', '90fcfdaef3e5ba0d686d5f0ebfefa25085ba0480f8eceeee9cfd581cdd167021', '8ES0qsUNXQALRhoXSXN3', '2229324592@qq.com', '12344555698', 1, 5, '2021-04-23 18:28:10', '海洋', NULL);
INSERT INTO `sys_user` VALUES (13, 'dh', 'fc4bc78a6888a37ed2dacd0d40f5b84f3c7269555734c2616035188317278dc5', 'x58YJ5oX6qptqwtQOdeK', '582899640@qq.com', '13766998949', 1, 7, '2021-04-23 19:46:51', '邓昊', NULL);
INSERT INTO `sys_user` VALUES (14, 'qlh', 'e389bd2668bc97fa28a20f0c937a3af1f8455a2bc284e168ed467809dde33b93', 'HnlyGNxaS9Mmrqy6V5kI', '1499910521@qq.com', '13766998987', 1, 4, '2021-04-23 20:11:20', '齐力辉', NULL);
INSERT INTO `sys_user` VALUES (15, 'djq', 'e70054b7b076b2a64184218c5bb23b984f6a1bfc5097d455b08c86fce754d098', 'DKEWsVHzYZm1aCUTTybW', '315335718@qq.com', '13766998947', 1, 4, '2021-04-24 20:25:44', '狄家奇', NULL);
INSERT INTO `sys_user` VALUES (16, 'wang', '17c066d6cc91817ca51b380c61ce93b5211cd4d01a6c8d48804577470289abc4', 'KF0SZzlwruZFIZDBpu9Y', '811386782@qq.com', '13877998974', 1, 6, '2021-04-26 10:59:45', '王', NULL);

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与角色对应关系' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (1, 1, 1);
INSERT INTO `sys_user_role` VALUES (12, 7, 4);
INSERT INTO `sys_user_role` VALUES (13, 8, 5);
INSERT INTO `sys_user_role` VALUES (14, 9, 2);
INSERT INTO `sys_user_role` VALUES (15, 12, 5);
INSERT INTO `sys_user_role` VALUES (19, 5, 2);
INSERT INTO `sys_user_role` VALUES (20, 13, 2);
INSERT INTO `sys_user_role` VALUES (21, 14, 5);
INSERT INTO `sys_user_role` VALUES (25, 15, 5);
INSERT INTO `sys_user_role` VALUES (27, 3, 3);
INSERT INTO `sys_user_role` VALUES (28, 2, 2);
INSERT INTO `sys_user_role` VALUES (29, 4, 4);
INSERT INTO `sys_user_role` VALUES (30, 16, 3);

SET FOREIGN_KEY_CHECKS = 1;