meidu2021/daju/resources-template/hgl-xcgl-merge.sql

#设备类型device type
 create table P_device_type (
        id varchar(36) not null,
        create_name varchar(50) comment '创建人名称',
        create_by varchar(50) comment '创建人登录名称',
        create_date datetime comment '创建日期',
        update_name varchar(50) comment '更新人名称',
        update_by varchar(50) comment '更新人登录名称',
        update_date datetime comment '更新日期',
        type_code varchar(100) not null comment '设备类型编号',
        type_name varchar(100) not null comment '设备类型名称',
        description longtext comment '描述',
        icon varchar(100) comment '图标',
        system_abbreviate varchar(100) comment '名称缩写',
        state varchar(1) default 0 comment '状态',
        primary key (id)
    );
#设备档案device
    create table P_device (
        id varchar(36) not null,
        code varchar(100) not null comment '设备编码',
        name varchar(100) not null comment '设备名称',
        type_id varchar(36) comment '设备类型',
        create_name varchar(50) comment '创建人名称',
        create_by varchar(50) comment '创建人登录名称',
        create_date datetime comment '创建日期',
        update_name varchar(50) comment '更新人名称',
        update_by varchar(50) comment '更新人登录名称',
        update_date datetime comment '更新日期',
        department varchar(100) comment '所属部门',
        description longtext comment '设备描述',
        projectid varchar(36) comment '项目',
        picture varchar(100) comment '设备照片',
        labelid varchar(36) comment '标签ID',
        sourcesys varchar(1) default 1 comment '来源系统',
        is_displayed varchar(1) default 1 comment '是否显示',
        use_time datetime comment '开始使用时间',
        invalid_time datetime comment '预计失效时间',
        area varchar(100) comment '所在区域',
        location varchar(100) comment '当前位置',
        user_name varchar(32) comment '使用人',
        maintain_count integer default 0 comment '维保次数',
        next_maintain_time datetime comment '下次维保时间',
        repair_count integer default 0 comment '维修次数',
        last_repair_time datetime comment '上次维修时间',
        state varchar(2) comment '状态',
        roomname varchar(255) comment '所属空间',
        abnormal_phone varchar(32) comment '异常通知电话',
        abnormal_time varchar(32) comment '异常通知时限',
        report_phone varchar(32) comment '逾期未处理上报电话',
        assists_name varchar(100) comment '协助人姓名',
        principal_name varchar(100) comment '负责人姓名',
        primary key (id)
    );

#维修申请单
    create table P_maintainorder (
        id varchar(36) not null,
        code varchar(100) not null comment '申请单号',
        create_name varchar(50) comment '创建人名称',
        create_by varchar(50) comment '创建人登录名称',
        create_date datetime comment '创建日期',
        update_name varchar(50) comment '更新人名称',
        update_by varchar(50) comment '更新人登录名称',
        update_date datetime comment '更新日期',
        description longtext not null comment '问题描述',
        applicantname varchar(100) comment '申请人姓名',
        applicanttype varchar(1) default 1 not null comment '申请人类型',
        projectid varchar(36) comment '项目',
        status varchar(1) comment '状态',
        primary key (id)
    );

#传感器类别
    create table P_sensor_type (
        id varchar(36) not null,
        create_name varchar(50) comment '创建人名称',
        create_by varchar(50) comment '创建人登录名称',
        create_date datetime comment '创建日期',
        type_code varchar(100) not null comment '类型编码',
        type_name varchar(100) not null comment '类型名称',
        type_unit varchar(32) not null comment '数据单位',
        department varchar(100) comment '所属部门',
        type_remark varchar(32) comment '备注',
        primary key (id)
    );

#监测点档案
    create table P_sensor_monitor_point (
        id varchar(36) not null,
        create_name varchar(50) comment '创建人名称',
        create_by varchar(50) comment '创建人登录名称',
        create_date datetime comment '创建日期',
        update_name varchar(50) comment '更新人名称',
        update_by varchar(50) comment '更新人登录名称',
        update_date datetime comment '更新日期',
        code varchar(100) not null comment '监测点编码',
        name varchar(100) not null comment '监测点名称',
        projectid varchar(36) comment '所属项目',
        picture varchar(100) comment '照片',
        sourcesys varchar(1) default 1 comment '来源系统',
        typeid varchar(36) comment '传感器类型',
        room varchar(100) comment '空间',
        deviceid varchar(36) comment '监测设备名称',
        upper varchar(10) not null comment '上限',
        floor varchar(10) not null comment '下限',
        state varchar(1) default 0 comment '状态',
        stat_type varchar(16) comment '统计类别编码',
        is_displayed varchar(1) default 1 comment '是否显示',
        primary key (id)
    );
#监测点异常记录
    create table P_sensor_abnormal (
        id varchar(36) not null,
        create_name varchar(50) comment '创建人名称',
        create_by varchar(50) comment '创建人登录名称',
        create_date datetime comment '创建日期',
        typeid varchar(36) comment '传感器类型',
        param_value varchar(100) comment '异常监测值',
        monitor_point_id varchar(36) not null comment '监测点',
        point_name varchar(100) comment '监测点名称',
        qcdstate varchar(50) comment '监测结论',
        state varchar(2) comment '异常类型',
        abnormal_cnt integer comment '发生异常次数',
        update_date datetime comment '最后处理日期',
        remark longtext comment '异常处理备注',
        primary key (id)
    );
CREATE TABLE
    p_sensor_record
    (
        id VARCHAR(36) NOT NULL,
        typeid VARCHAR(36) COMMENT '传感器类型',
        typename VARCHAR(100) COMMENT '传感器类型名称',
        typecode VARCHAR(100) COMMENT '传感器类型编码',
        pointid VARCHAR(36) COMMENT '监测点',
        pointname VARCHAR(100) COMMENT '监测点名称',
        pointcode VARCHAR(100) COMMENT '监测点编码',
        deviceid VARCHAR(36) COMMENT '监测设备',
        devicename VARCHAR(100) COMMENT '监测设备名称',
        roomname VARCHAR(100) COMMENT '空间名称',
        param_value DOUBLE COMMENT '监测值',
        typeunit VARCHAR(20) COMMENT '单位',
        UPPER DOUBLE COMMENT '上限',
        floor DOUBLE COMMENT '下限',
        recordtime DATETIME COMMENT '记录时间',
        departmentname VARCHAR(100) COMMENT '所属部门',
        projectid VARCHAR(36) COMMENT '项目',
        isalarm VARCHAR(1) COMMENT '是否报警',
        ishandle VARCHAR(1) COMMENT '是否处理',
        qcdstate VARCHAR(50) COMMENT '监测结论',
        PRIMARY KEY (id)
    )
    ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE
    p_cloud_sync_record
    (
        id CHAR(36)  NOT NULL,
        projectid CHAR(36),
        createdatetime DATETIME DEFAULT now(),
        lastdatetime DATETIME,
tablename varchar(100)
    )
    ENGINE=InnoDB DEFAULT CHARSET=utf8
;
# 工作计划
CREATE TABLE p_projecttaskplan  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新日期',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计划编码',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计划名称',
  `description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '计划详述',
  `tasktype` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计划类型',
  `cron` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '计划工作时间',
  `status` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计划状态',
  `ownerrole` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作所属角色',
  `msgAdvanceQuantity` int(20) NULL DEFAULT NULL,
  `msgAdvanceType` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `taskquantity` int(3) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

# 工作表
CREATE TABLE p_projecttask (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新日期',
  `code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作编码',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作名称',
  `description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '工作描述',
  `taskplanid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作计划',
  `msgtime` datetime(0) NULL DEFAULT NULL COMMENT '消息时间',
  `planstarttime` datetime(0) NULL DEFAULT NULL COMMENT '计划开始时间',
  `planendtime` datetime(0) NULL DEFAULT NULL COMMENT '计划结束时间',
  `exestarttime` datetime(0) NULL DEFAULT NULL COMMENT '实际开始时间',
  `exeendtime` datetime(0) NULL DEFAULT NULL COMMENT '实际结束时间',
  `owner` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务所属人',
  `executer` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行人',
  `projectid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属项目',
  `taskstatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作状态',
  `tasktype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作类型',
  `sourceid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作来源',
  `sourcetype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源类型',
  `closemsg` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '关闭原因',
  `submittime` datetime(0) NULL DEFAULT NULL COMMENT '提交上级时间',
  `dispatchtime` datetime(0) NULL DEFAULT NULL COMMENT '分配时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

# 工作计划、项目关联表
CREATE TABLE p_plan_project (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `planid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计划ID',
  `projectid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

# 工作执行结果
CREATE TABLE p_taskresult  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
  `checkpointid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检查点',
  `taskid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作',
  `picture1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture6` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture7` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture8` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture9` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `picture10` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现场图片',
  `memo` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文字说明',
  `voice1` longblob NULL COMMENT '语音说明',
  `voice2` longblob NULL COMMENT '语音说明',
  `voice3` longblob NULL COMMENT '语音说明',
  `voice4` longblob NULL COMMENT '语音说明',
  `voice5` longblob NULL COMMENT '语音说明',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

# sms发送短信记录表
CREATE TABLE p_usersms  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `phoneno` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收手机号',
  `sendtime` datetime(0) NULL DEFAULT NULL COMMENT '发送时间',
  `validtime` datetime(0) NULL DEFAULT NULL COMMENT '截止有效时间',
  `code` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '验证码',
  `outid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '反馈id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

# 给用户表增加openid字段
alter table  t_s_user  add COLUMN openid varchar(256);

# 周计划表
CREATE TABLE p_weeklyschedule  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `create_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
  `create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人登录名称',
  `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
  `update_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人名称',
  `update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人登录名称',
  `update_date` datetime(0) NULL DEFAULT NULL COMMENT '更新日期',
  `userid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'userid',
  `mondate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'mondate',
  `whatmonam` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatmonam',
  `wheremonam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheremonam',
  `whomonams` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whomonam',
  `remarkmonam` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkmonam',
  `whatmonpm` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatmonpm',
  `wheremonpm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheremonpm',
  `whomonpms` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whomonpm',
  `remarkmonpm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkmonpm',
  `tuesdate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'tuesdate',
  `whattuesam` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whattuesam',
  `wheretuesam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheretuesam',
  `whotuesams` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whotuesam',
  `remarktuesam` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarktuesam',
  `whattuespm` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whattuespm',
  `wheretuespm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheretuespm',
  `whotuespms` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whotuespm',
  `remarktuespm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarktuespm',
  `weddate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'weddate',
  `whatwedam` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatwedam',
  `wherewedam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wherewedam',
  `whowedams` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whowedam',
  `remarkwedam` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkwedam',
  `whatwedpm` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatwedpm',
  `wherewedpm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wherewedpm',
  `whowedpms` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whowedpm',
  `remarkwedpm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkwedpm',
  `thurdate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'thurdate',
  `whatthuram` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatthuram',
  `wherethuram` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wherethuram',
  `whothurams` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whothuram',
  `remarkthuram` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkthuram',
  `whatthurpm` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatthurpm',
  `wherethurpm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wherethurpm',
  `whothurpms` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whothurpm',
  `remarkthurpm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkthurpm',
  `fridate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'fridate',
  `whatfriam` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatfriam',
  `wherefriam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wherefriam',
  `whofriams` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whofriam',
  `remarkfriam` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkfriam',
  `whatfripm` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatfripm',
  `wherefripm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wherefripm',
  `whofripms` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whofripm',
  `remarkfripm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarkfripm',
  `satdate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'satdate',
  `whatsatam` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatsatam',
  `wheresatam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheresatam',
  `whosatams` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whosatam',
  `remarksatam` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarksatam',
  `whatsatpm` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatsatpm',
  `wheresatpm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheresatpm',
  `whosatpms` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whosatpm',
  `remarksatpm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarksatpm',
  `sundate` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'sundate',
  `whatsunam` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatsunam',
  `wheresunam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheresunam',
  `whosunams` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whosunam',
  `remarksunam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarksunam',
  `whatsunpm` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whatsunpm',
  `wheresunpm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'wheresunpm',
  `whosunpms` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'whosunpm',
  `remarksunpm` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarksunpm',
  `status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `whatmonamzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatmonpmzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whattuesamzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whattuespmzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatwedamzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatwedpmzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatthuramzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatthurpmzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatfriamzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatfripmzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatsatamzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatsatpmzjl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatsunamzjl` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `whatsunpmzjl` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
# 周计划参与人员表
CREATE TABLE p_weeklyschedule_parti  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `scheduleid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `userid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `participantid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `harfday` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `realname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
#生成考勤调整表
CREATE TABLE `t_bus_user_attendance_detail_adjust` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL,
  `attendance_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `attendance_detail_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `user_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `status` varchar(2) COLLATE utf8_bin DEFAULT NULL,
  `attendance_date` datetime DEFAULT NULL,
  `retreat_date` datetime DEFAULT NULL,
  `duty_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `datum_date` decimal(8,0) DEFAULT NULL,
  `time_difference` decimal(8,0) DEFAULT NULL,
  `fine_tuning_type` varchar(1) COLLATE utf8_bin DEFAULT NULL,
  `time_fine_tuning` decimal(8,0) DEFAULT NULL,
  `adjust_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `borrowstatus` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT '借调状态；0未借调，1已借调',
  `borrowspid` varchar(36) COLLATE utf8_bin DEFAULT NULL COMMENT '借调项目id',
  `borrowsdepartid` varchar(36) COLLATE utf8_bin DEFAULT NULL COMMENT '借调部门id',
  `attendance_mins` decimal(8,0) DEFAULT NULL COMMENT '考勤时间',
  `timeout_overtime_duration` decimal(8,0) DEFAULT NULL COMMENT '超时加班时长',
  `national_overtime_duration` decimal(8,0) DEFAULT NULL COMMENT '国定加班时长',
  `special_overtime` decimal(8,0) DEFAULT NULL COMMENT '特殊加班时长',
  `day_pay` decimal(8,2) DEFAULT NULL COMMENT '单次借调日薪',
  `actualattendance_date` decimal(8,0) DEFAULT NULL COMMENT '实际出勤时间',
  `json_obj` varchar(5000) COLLATE utf8_bin DEFAULT NULL COMMENT '其他字段',
  `ymd_date` date DEFAULT NULL COMMENT '当前日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='员工考勤调整详细表';

#数据字典：device_type_state
INSERT INTO t_s_typegroup (ID, typegroupcode, typegroupname) VALUES ('402884c7643eb41801643ec2ee940015', 'device_type_state', '设备类型状态');

INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643eb41801643ec3a3030017', '1', '删除', null, '402884c7643eb41801643ec2ee940015');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643eb41801643ec3c38d0019', '0', '可用', null, '402884c7643eb41801643ec2ee940015');

#数据字典：device_state
INSERT INTO t_s_typegroup (ID, typegroupcode, typegroupname) VALUES ('402884c7643ecff101643eed29a90013', 'device_state', '设备状态');

INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eed5cfa0015', '1', '入库', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eed850d0017', '2', '在用', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eedafeb0019', '3', '运行', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eede51d001b', '4', '停机', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eedfc34001d', '5', '故障', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eee272e001f', '6', '预警', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eee3d530021', '7', '删除', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eee6b9a0023', '8', '遗失', null, '402884c7643ecff101643eed29a90013');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643eee7ee80025', '9', '报废', null, '402884c7643ecff101643eed29a90013');

#数据字典：sourcesys
INSERT INTO t_s_typegroup (ID, typegroupcode, typegroupname) VALUES ('402884c7643ecff101643f0f47320038', 'sourcesys', '来源系统');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643f0fa34e003a', '1', '慧管理系统', null, '402884c7643ecff101643f0f47320038');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c7643ecff101643f101d29003c', '2', '群艺馆设备管理系统', null, '402884c7643ecff101643f0f47320038');

#数据字典：applicanttype
INSERT INTO t_s_typegroup (ID, typegroupcode, typegroupname) VALUES ('402884c764400f9d0164403b34310008', 'applicanttype', '申请人类型');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c764400f9d0164403b6b46000a', '1', '业主', null, '402884c764400f9d0164403b34310008');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c764400f9d0164403be97e000c', '2', '美都环卫员工', null, '402884c764400f9d0164403b34310008');

#数据字典：billstatus
INSERT INTO t_s_typegroup (ID, typegroupcode, typegroupname) VALUES ('402884c764400f9d0164404376b20011', 'billstatus', '单据状态');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c764400f9d016440439aed0013', '1', '已保存', null, '402884c764400f9d0164404376b20011');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('402884c764400f9d01644043bcd90015', '2', '已生效', null, '402884c764400f9d0164404376b20011');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid) VALUES ('411184c764400f9d01644043bcd90016', '3', '已关闭', null, '402884c764400f9d0164404376b20011');

#数据字典 ：abnstate
INSERT INTO t_s_typegroup (ID, typegroupcode, typegroupname, create_date, create_name) VALUES ('40289ff264ab65bd0164ab70ab8d0000', 'abnstate', '异常类型', null, null);
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028843564b6de1a0164b6e1a4e20002', '0', '正常', null, '40289ff264ab65bd0164ab70ab8d0000', '2018-07-20 16:49:58', '管理员');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028843564b6de1a0164b6e1c7f30004', '1', '报警', null, '40289ff264ab65bd0164ab70ab8d0000', '2018-07-20 16:50:07', '管理员');
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('40289ff264ab65bd0164ab77d9640005', '21', '传感器离线', null, '40289ff264ab65bd0164ab70ab8d0000', null, null);
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('40289ff264ab65bd0164ab78045f0007', '12', '超出下限', null, '40289ff264ab65bd0164ab70ab8d0000', null, null);
INSERT INTO t_s_type (ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('40289ff264ab65bd0164ab78a46d000a', '11', '超出上限', null, '40289ff264ab65bd0164ab70ab8d0000', null, null);




#菜单：
INSERT INTO t_s_function (ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style) VALUES ('402884c7643ecff101643ed5f9050001', null, 0, '设备管理', '8', '', null, '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, 'fa-desktop');
INSERT INTO t_s_function (ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style) VALUES ('402884c7643ecff101643ed79bb80003', null, 1, '设备类型管理', '1', 'deviceTypeController.do?list', '402884c7643ecff101643ed5f9050001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '');
INSERT INTO t_s_function (ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style) VALUES ('402884c7643ecff101643f23731d0058', null, 1, '设备档案', '2', 'deviceController.do?list', '402884c7643ecff101643ed5f9050001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '');
INSERT INTO t_s_function (ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style) VALUES ('40288449644437d001644457d00e0017', null, 1, '传感器类别档案', '3', 'sensorTypeController.do?list', '402884c7643ecff101643ed5f9050001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '');
INSERT INTO  t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c948a85645dd7cc01645dd8523f0000', NULL, 1, '监测点异常清单', '5', 'sensorAbnormalController.do?list', '402884c7643ecff101643ed5f9050001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-07-03 10:18:34', '2018-07-03 09:53:35', '管理员');
INSERT INTO  t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c948a85645dd7cc01645def00050005', NULL, 1, '监测点数据清单', '6', 'sensorRecordController.do?list', '402884c7643ecff101643ed5f9050001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-07-03 10:18:22', NULL);
INSERT INTO  t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('40289ff2644579f0016445b6c405005b', NULL, 1, '监测点档案', '4', 'sensorMonitorPointController.do?list', '402884c7643ecff101643ed5f9050001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-06-28 17:26:03', NULL);

INSERT INTO t_s_function (ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style) VALUES ('402884c764400f9d01644037c5a10006', null, 0, '现场管理', '8', '', null, '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, 'fa-file-text-o');
INSERT INTO t_s_function (ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style) VALUES ('402884c764404d5b0164408145b30005', null, 1, '维修申请单', '1', 'maintainorderController.do?list', '402884c764400f9d01644037c5a10006', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '');

#定时任务
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) VALUES ('40289ff264a151110164a17a8e970006', 'admin', '2018-07-16 13:05:21', '管理员', '0 1/30 * * * ? ', '0', '0', '从云端同步基础数据', 'syncBaseDataFromCloud', NULL, NULL, NULL, 'com.xcgl.middleware.task.SyncBaseDataTask', '127.0.0.1', '127.0.0.1:8080/hgl');
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) VALUES ('40289ff264a152220164a17a8e970006', 'admin', '2018-07-16 13:05:21', '管理员', '0 1/30 * * * ? ', '0', '0', '向云端同步传感器监测数据', 'sensorRecordUploadTask', NULL, NULL, NULL, 'com.xcgl.middleware.task.SensorReocrdsUploadTask', '127.0.0.1', '127.0.0.1:8080/hgl');
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) VALUES ('40289ff264a158170164a17a8e970006', 'admin', '2018-07-16 13:05:21', '管理员', '0 1/5 * * * ? ', '0', '0', '每隔几分钟获取传感器数据', 'sensorRecordSyncTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.middleware.task.SensorRecordSyncTask', '127.0.0.1', '127.0.0.1:8080/hgl');

#######定时任务
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) VALUES ('4022222264a158170164a17a8e970006', 'admin', '2018-07-16 13:05:21', '管理员', '0 0 7 * * ? *', '0', '0', '每天早晨7点发送当日工作摘要', 'pushWXMsgInMorningTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.weixin.timetask.PushWXMsgInMorning', '127.0.0.1', '127.0.0.1:8080/hgl');

INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) 
VALUES ('3122222264a158170164a17a8e970006', 'admin', '2018-07-16 13:05:21', '管理员', '0 0 1 * * ? *', '0', '0', '每日凌晨1点创建下一天计划的工作', 'createWorkFromPlanTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.weixin.timetask.CreateWorkFromPlan', '127.0.0.1', '127.0.0.1:8080/hgl');
#######每周日23：00 定时生成周计划任务
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) 
VALUES ('3122222264a158170164a17a8e971116', 'admin', '2018-07-16 13:05:21', '管理员', '0 0 23 ? ? 7 ', '0', '0', '每周日23：00 定时生成周计划任务', 'weeklyScheduleGen2WorkTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.weeklyschedule.timetask.WeeklyScheduleGen2WorkTask', '127.0.0.1', '127.0.0.1:8080/hgl');
#######每周五8：00 定时发出周计划提醒
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) 
VALUES ('3122222264a158170164a17a8e972226', 'admin', '2018-07-16 13:05:21', '管理员', '0 0 8 ? ? 5 ', '0', '0', '每周五8：00 定时发出周计划提醒', 'weeklyScheduleSendWXMsgTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.weeklyschedule.timetask.WeeklyScheduleSendWXMsgTask', '127.0.0.1', '127.0.0.1:8080/hgl');


#######任务系统
##功能权限菜单
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('4028819b65adcefa0165add2446f0001', NULL, 0, '任务工作管理', '40', '', NULL, '8a8ab0b246dc81120146dc8180830004', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', '0032', '2018-12-02 16:52:04', '2018-09-06 15:39:23', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e21e15e0018', NULL, 1, '总经办任务', '30', '', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 17:11:31', '2018-12-02 16:56:13', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e227ff0001b', NULL, 1, '行政采购部任务', '47', 'projectTaskPlanController.do?list&type=xzcgb', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:32:13', '2018-12-02 16:56:54', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e230ba6001d', NULL, 1, '项目现场任务', '10', '', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 17:11:25', '2018-12-02 16:57:30', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e23a92e0020', NULL, 1, '人力资源部任务', '50', 'projectTaskPlanController.do?list&type=xmpx', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 19:22:25', '2018-12-02 16:58:10', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e242ac30022', NULL, 1, '市场部任务', '60', 'projectTaskPlanController.do?list&type=scb', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:21:52', '2018-12-02 16:58:43', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e24e6b00024', NULL, 1, '财务部任务', '70', 'projectTaskPlanController.do?list&type=cwb', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:22:14', '2018-12-02 16:59:31', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e4739f80043', NULL, 1, '运营部任务', '45', '', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', NULL, NULL, '2018-12-02 17:37:01', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('8aa5018266613b8c016661d3d3c7000b', NULL, 1, '临时任务', '5', 'projectTaskPlanController.do?list&type=tyrw', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', '0032', '2018-12-03 09:23:06', '2018-10-11 14:32:44', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e45a4f20040', NULL, 2, '信息部任务', '5', 'projectTaskPlanController.do?list&type=xxb', '2c9358a8675e222b01676e21e15e0018', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:17:49', '2018-12-02 17:35:17', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e4a6fcc0047', NULL, 2, '党群办任务', '10', 'projectTaskPlanController.do?list&type=dqb', '2c9358a8675e222b01676e21e15e0018', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:18:23', '2018-12-02 17:40:31', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e3b6b8f002f', NULL, 2, '管理处任务', '5', 'projectTaskPlanController.do?list&type=lzsb', '2c9358a8675e222b01676e230ba6001d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 19:32:24', '2018-12-02 17:24:07', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e3ea9d30031', NULL, 2, '保安部任务', '10', 'projectTaskPlanController.do?list&type=abxg', '2c9358a8675e222b01676e230ba6001d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 19:19:44', '2018-12-02 17:27:40', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e40da210033', NULL, 2, '保洁部任务', '15', 'projectTaskPlanController.do?list&type=bjxc', '2c9358a8675e222b01676e230ba6001d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 18:40:52', '2018-12-02 17:30:03', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e42a2cc0036', NULL, 1, '工程部任务', '20', 'projectTaskPlanController.do?list&type=gcxj', '2c9358a8675e222b01676e230ba6001d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:16:48', '2018-12-02 17:32:00', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e42e7b50038', NULL, 2, '客户部(会务)任务', '25', 'projectTaskPlanController.do?list&type=khb', '2c9358a8675e222b01676e230ba6001d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:17:17', '2018-12-02 17:32:18', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e43921e003a', NULL, 2, '餐饮部任务', '30', 'projectTaskPlanController.do?list&type=cyb', '2c9358a8675e222b01676e230ba6001d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:17:35', '2018-12-02 17:33:01', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e448558003d', NULL, 2, '绿化部任务', '23', 'projectTaskPlanController.do?list&type=lhb', '2c9358a8675e222b01676e230ba6001d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:17:01', '2018-12-02 17:34:04', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e4a10180045', NULL, 2, '品质管理部任务', '5', 'projectTaskPlanController.do?list&type=pzb', '2c9358a8675e222b01676e4739f80043', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-03 09:19:05', '2018-12-02 17:40:07', '丁晟');

INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e1d8b7f0011', NULL, 0, '任务工作审查', '50', '', NULL, '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 18:01:52', '2018-12-02 16:51:29', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e5e6db50071', NULL, 1, '项目任务审查', '5', 'projecttaskController.do?list&type=tyrw', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 18:30:09', '2018-12-02 18:02:21', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a8675e222b01676e6258c20075', NULL, 1, '职能部门工作审查', '10', 'projecttaskController.do?list&type=xmpx', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', '0032', '丁晟', '0032', '2018-12-02 19:21:19', '2018-12-02 18:06:38', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21dd0001', NULL, 1, '保洁工作清单', '910', 'projecttaskController.do?list&type=bjxc', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', '0032', '2018-12-02 17:12:26', '2018-09-10 09:01:10', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21de0001', NULL, 1, '通用任务审查', '2', 'projecttaskController.do?list&type=tyrw', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', '0032', '2018-12-02 18:09:47', '2018-09-10 09:01:10', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21dff000', NULL, 1, '物料申请工作清单', '930', 'projecttaskController.do?list&type=wlsq', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', '0032', '2018-12-02 17:41:26', '2018-09-10 09:01:10', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21gg0001', NULL, 1, '培训工作清单', '940', 'projecttaskController.do?list&type=xmpx', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', '0032', '2018-12-02 17:41:38', '2018-09-10 09:01:10', '丁晟');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21hh0001', NULL, 1, '离职工作清单', '950', 'projecttaskController.do?list&type=lzsb', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', '0032', '2018-12-02 17:42:27', '2018-09-10 09:01:10', '丁晟');

# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('4028819b65adcefa0165add2446f0001', NULL, 0, '工作管理', '8', '', NULL, '8a8ab0b246dc81120146dc8180830004', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-09-06 15:39:41', '2018-09-06 15:39:23', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('8aa5018266613b8c016661d22b570007', NULL, 1, '保洁工作', '20', '', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-10-11 14:30:56', NULL);
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('8aa5018266613b8c016661d3d3c7000b', NULL, 1, '工作计划', '20', '', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-10-11 14:32:44', NULL);
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('8aa5018266613b8c016661e1a914000d', NULL, 1, '工作统计', '40', '', '4028819b65adcefa0165add2446f0001', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-10-11 14:47:51', NULL);
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('4028819b65adcefa0165add376630004', NULL, 2, '通用工作计划', '10', 'projectTaskPlanController.do?list&type=tyrw', '8aa5018266613b8c016661d3d3c7000b', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:48:07', '2018-09-06 15:40:41', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('4028819b65adcefa0165add376631114', NULL, 2, '保洁工作计划', '20', 'projectTaskPlanController.do?list&type=bjxc', '8aa5018266613b8c016661d22b570007', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:31:20', '2018-09-06 15:40:41', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('4028819b65adcefa0165add376632224', NULL, 2, '离职上报工作计划', '30', 'projectTaskPlanController.do?list&type=lzsb', '8aa5018266613b8c016661d3d3c7000b', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:48:48', '2018-09-06 15:40:41', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('4028819b65adcefa0165add376633334', NULL, 2, '物料申请工作计划', '40', 'projectTaskPlanController.do?list&type=wlsq', '8aa5018266613b8c016661d3d3c7000b', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:49:00', '2018-09-06 15:40:41', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('4028819b65adcefa0165add376634444', NULL, 2, '培训工作计划', '50', 'projectTaskPlanController.do?list&type=xmpx', '8aa5018266613b8c016661d3d3c7000b', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:48:31', '2018-09-06 15:40:41', '管理员');

# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21dd0001', NULL, 2, '保洁工作清单', '910', 'projecttaskController.do?list&type=bjxc', '8aa5018266613b8c016661d22b570007', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:31:46', '2018-09-10 09:01:10', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21de0001', NULL, 2, '通用工作清单', '920', 'projecttaskController.do?list&type=tyrw', '8aa5018266613b8c016661e1a914000d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:49:17', '2018-09-10 09:01:10', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21dff000', NULL, 2, '物料申请工作清单', '930', 'projecttaskController.do?list&type=wlsq', '8aa5018266613b8c016661e1a914000d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:49:28', '2018-09-10 09:01:10', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21gg0001', NULL, 2, '培训工作清单', '940', 'projecttaskController.do?list&type=xmpx', '8aa5018266613b8c016661e1a914000d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:49:38', '2018-09-10 09:01:10', '管理员');
# INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165c0fadf0165c0ff21hh0001', NULL, 2, '离职工作清单', '950', 'projecttaskController.do?list&type=lzsb', '8aa5018266613b8c016661e1a914000d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', 'admin', '2018-10-11 14:49:48', '2018-09-10 09:01:10', '管理员');


INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165cbe24d0165cbe450690001', NULL, 1, '入职附件', '101', '入职附件上传', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', 'admin', '2018-09-12 11:54:21', '2018-09-12 11:47:42', '管理员');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165cbe24d0165cbeb6cbc000d', NULL, 1, '离职附件', '102', '离职附件上传', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', NULL, NULL, '2018-09-12 11:55:28', NULL);
INSERT INTO  t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165cbe24d0165cbebe010000f', NULL, 1, '设备监测', '201', '实时数据采集', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', NULL, NULL, '2018-09-12 11:55:58', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165cbe24d0165cbec29280011', NULL, 1, '项目培训', '203', '培训信息采集', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', NULL, NULL, '2018-09-12 11:56:17', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('2c9358a865f619f60165f63907cc000c', NULL, 1, '项目统计', '202', '统计工作情况', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', NULL, NULL, '2018-09-20 17:04:17', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165cbe24d0165cbec29211111', NULL, 1, '项目工作', '200', '项目工作清单', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', 'admin', '2018-09-20 17:06:25', '2018-09-12 11:56:17', '管理员');
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165cbe24d0165cbec9ceb0013', NULL, 1, '规章制度', '302', '规章制度预览', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', NULL, NULL, '2018-09-12 11:56:46', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('ff80808165cbe24d0165cbee17c10015', NULL, 1, '行政审批', '301', '审批及查询', '8a8ab0b246dc81120146dc8180d2001a', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 1, '', 'admin', '管理员', NULL, NULL, '2018-09-12 11:58:23', NULL);

##  字典
INSERT INTO t_s_typegroup(ID, typegroupcode, typegroupname, create_date, create_name) VALUES ('4028819b65a8b81c0165a9182bee0015', 'tasktype', '工作类型', '2018-09-05 17:37:38', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771da8b4e003d', 'cwb', '财务部任务', NULL, '4028819b65a8b81c0165a9182bee0015', NULL, NULL);
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771daeb020040', 'cyb', '餐饮部任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:17:12', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771db1e560042', 'dqb', '党群办任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:17:25', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771dbaf2c0044', 'khb', '客户部（会务）任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:18:02', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771dbd5140046', 'lhb', '绿化部任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:18:12', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771dc25760048', 'pzb', '品质管理部任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:18:32', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771dc57a1004a', 'xxb', '信息部任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:18:45', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771dc8f6b004c', 'xzcgb', '行政采购部任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:18:59', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a86771a08c016771dda668004e', 'lzsb', '管理处任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-12-03 10:20:11', '丁晟');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a9193d630017', 'abxg', '保安部任务', NULL, '4028819b65a8b81c0165a9182bee0015', NULL, NULL);
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a91963a20019', 'sbxj', '工程部任务', NULL, '4028819b65a8b81c0165a9182bee0015', NULL, NULL);
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a924971a001b', 'bjxc', '保洁部任务', NULL, '4028819b65a8b81c0165a9182bee0015', NULL, NULL);
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a9251643001d', 'xmpx', '人力资源部任务', NULL, '4028819b65a8b81c0165a9182bee0015', NULL, NULL);
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a9251643222d', 'wlsq', '物料申请', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-09-05 17:51:45', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a9251643333d', 'lzsb', '管理处任务', NULL, '4028819b65a8b81c0165a9182bee0015', NULL, NULL);
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a9257fc4001f', 'tyrw', '通用任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-09-05 17:52:12', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028819b65a8b81c0165a9257fc40222', 'weeklyschedule', '周计划任务', NULL, '4028819b65a8b81c0165a9182bee0015', '2018-09-05 17:52:12', '管理员');

INSERT INTO t_s_typegroup(ID, typegroupcode, typegroupname, create_date, create_name) VALUES ('ff80808165cca2a10165cca4eb630001', 'taskstatus', '任务状态', '2018-09-12 15:18:05', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('ff80808165cca2a10165cca89e6b0003', '0', '未执行', NULL, 'ff80808165cca2a10165cca4eb630001', '2018-09-12 15:22:07', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('ff80808165cca2a10165cca8c6e80005', '1', '执行中', NULL, 'ff80808165cca2a10165cca4eb630001', '2018-09-12 15:22:18', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('ff80808165cca2a10165cca8e6290007', '10', '已关闭', NULL, 'ff80808165cca2a10165cca4eb630001', '2018-09-12 15:22:26', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('ff80808165cca2a10165cca909cd0009', '20', '已完成', NULL, 'ff80808165cca2a10165cca4eb630001', '2018-09-12 15:22:35', '管理员');

INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028e4f5607c064201607c0ce9561111', 'zhengshencailiao6', '*政审材料第二页', NULL, '4028e4f5607c064201607c08ba1e0001', NULL, NULL);
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('4028e4f5607c064201607c0bdcb40019', 'tijianbiao7', '*体检表第二页', NULL, '4028e4f5607c064201607c08ba1e0001', NULL, NULL);

INSERT INTO t_s_typegroup(ID, typegroupcode, typegroupname, create_date, create_name) VALUES ('2c9358a865ef71b50165ef7724330001', 'tasksourcetype', '工作来源类型', '2018-09-19 09:34:47', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a865ef71b50165ef792bab0003', 'taskplan', '工作计划', NULL, '2c9358a865ef71b50165ef7724330001', '2018-09-19 09:37:00', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a865ef71b50165ef79b81d0005', 'lsrw', '临时工作安排', NULL, '2c9358a865ef71b50165ef7724330001', '2018-09-19 09:37:36', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('2c9358a865ef71b50165ef79b81d1115', 'weeklyschedule', '周工作计划', NULL, '2c9358a865ef71b50165ef7724330001', '2018-09-19 09:37:36', '管理员');


INSERT INTO t_s_typegroup(ID, typegroupcode, typegroupname, create_date, create_name) VALUES ('402881e6662403b1016624054fd40001', 'msgTipType', '工作消息提醒时间类型', '2018-09-29 14:30:20', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('402881e6662403b10166240577910003', 'day', '天', NULL, '402881e6662403b1016624054fd40001', '2018-09-29 14:30:30', '管理员');
INSERT INTO t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('402881e6662403b101662405e7ee0005', 'minute', '分钟', NULL, '402881e6662403b1016624054fd40001', '2018-09-29 14:30:59', '管理员');


###预置角色数据，此角色用于微管理分配任务计划时使用
INSERT INTO t_s_role(ID, rolecode, rolename, self_roleweight_code, visible_roleweight_code, role_level, applogin_able_flag, create_name, create_by, create_date, update_name, update_by, update_date) VALUES ('4028867966c7e8f10166c7ea402e0001', 'T_XMNQ', '项目内勤', '200', '200', NULL, '0', NULL, NULL, NULL, '管理员', 'admin', '2018-10-31 10:20:44');
INSERT INTO t_s_role(ID, rolecode, rolename, self_roleweight_code, visible_roleweight_code, role_level, applogin_able_flag, create_name, create_by, create_date, update_name, update_by, update_date) VALUES ('4028867966c7e8f10166c7eee07f0018', 'T_XMFZR', '项目负责人', '200', '200', NULL, '0', NULL, NULL, NULL, '管理员', 'admin', '2018-10-31 10:34:28');
INSERT INTO t_s_role(ID, rolecode, rolename, self_roleweight_code, visible_roleweight_code, role_level, applogin_able_flag, create_name, create_by, create_date, update_name, update_by, update_date) VALUES ('4028867966c7e8f10166c7f95b880019', 'T_BJZG', '保洁主管', '200', '200', NULL, '0', NULL, NULL, NULL, '管理员', 'admin', '2018-10-31 11:59:47');
INSERT INTO t_s_role(ID, rolecode, rolename, self_roleweight_code, visible_roleweight_code, role_level, applogin_able_flag, create_name, create_by, create_date, update_name, update_by, update_date) VALUES ('4028867966c7e8f10166c7f9ad33001a', 'T_GCZG', '工程主管', '200', '200', NULL, '0', NULL, NULL, NULL, '管理员', 'admin', '2018-10-31 10:36:26');
INSERT INTO t_s_role(ID, rolecode, rolename, self_roleweight_code, visible_roleweight_code, role_level, applogin_able_flag, create_name, create_by, create_date, update_name, update_by, update_date) VALUES ('4028867966c7e8f10166c7f9ff1d001b', 'T_HWZG', '会务主管', '200', '200', NULL, '0', NULL, NULL, NULL, '管理员', 'admin', '2018-10-31 10:36:19');
INSERT INTO t_s_role(ID, rolecode, rolename, self_roleweight_code, visible_roleweight_code, role_level, applogin_able_flag, create_name, create_by, create_date, update_name, update_by, update_date) VALUES ('4028867966c7e8f10166c7fa49bf001c', 'T_BAZG', '保安主管', '200', '200', NULL, '0', NULL, NULL, NULL, '管理员', 'admin', '2018-10-31 10:36:12');


INSERT INTO  t_s_typegroup(ID, typegroupcode, typegroupname, create_date, create_name) VALUES ('402881e6671a9afa01671aa198260001', 'reviewScore', '评价分数', '2018-11-16 11:47:37', '管理员');
INSERT INTO  t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('402881e6671a9afa01671aa25cba0003', '10', '差', NULL, '402881e6671a9afa01671aa198260001', '2018-11-16 11:48:27', '管理员');
INSERT INTO  t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('402881e6671a9afa01671aa273c80005', '20', '及格', NULL, '402881e6671a9afa01671aa198260001', '2018-11-16 11:48:33', '管理员');
INSERT INTO  t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('402881e6671a9afa01671aa286950007', '30', '良好', NULL, '402881e6671a9afa01671aa198260001', '2018-11-16 11:48:38', '管理员');
INSERT INTO  t_s_type(ID, typecode, typename, typepid, typegroupid, create_date, create_name) VALUES ('402881e6671a9afa01671aa299b90009', '40', '优秀', NULL, '402881e6671a9afa01671aa198260001', '2018-11-16 11:48:43', '管理员');

##周计划定时任务
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) VALUES ('3122222264a158170164a17a8e971116', 'admin', '2018-07-16 13:05:21', '管理员', '0 0 1 * * ? *', '1', '1', '每日1：00 定时生成明日周计划任务', 'weeklyScheduleGen2WorkTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.weeklyschedule.timetask.WeeklyScheduleGen2WorkTask', '127.0.0.1', '127.0.0.1:8080/hgl');
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) VALUES ('3122222264a158170164a17a8e972226', 'admin', '2018-07-16 13:05:21', '管理员', '0 0 8 * * ? *', '0', '0', '每周五8：00 定时发出周计划提醒', 'weeklyScheduleSendWXMsgTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.weeklyschedule.timetask.WeeklyScheduleSendWXMsgTask', '127.0.0.1', '127.0.0.1:8080/hgl');
INSERT INTO t_s_timetask(ID, CREATE_BY, CREATE_DATE, CREATE_NAME, CRON_EXPRESSION, IS_EFFECT, IS_START, TASK_DESCRIBE, TASK_ID, UPDATE_BY, UPDATE_DATE, UPDATE_NAME, CLASS_NAME, RUN_SERVER_IP, RUN_SERVER) VALUES ('3122222264a158170164a17a8e972tt6', 'admin', '2018-07-16 13:05:21', '管理员', '0 30 6 * * ? *', '0', '0', '每日6：30 定时给闵总发出今日工作计划提醒', 'weeklyScheduleSendWXMsg4ZJLTask', 'admin', '2018-08-08 15:25:29', '管理员', 'com.xcgl.weeklyschedule.timetask.WeeklyScheduleSendWXMsg4ZJLTask', '127.0.0.1', '127.0.0.1:8080/hgl');


##周计划菜单
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('8a53b78267e96b400167e96d9da70001', NULL, 1, '查看工作计划', '98', 'weeklyscheduleController.do?list', '402889fe47eddd340147edfa0798002d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-12-26 15:32:14', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('8a53b78267e96b400167e96e7c6f0003', NULL, 1, '填写下周工作计划', '99', 'weeklyscheduleController.do?goAdd', '402889fe47eddd340147edfa0798002d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-12-26 15:33:11', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('8a53b78267e96b400167e96e7c6f3333', NULL, 1, '总经理安排工作', '99', 'weeklyscheduleController.do?goAdd&managerflag=1', '402889fe47eddd340147edfa0798002d', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2018-12-26 15:33:11', NULL);
INSERT INTO t_s_function(ID, functioniframe, functionlevel, functionname, functionorder, functionurl, parentfunctionid, iconid, desk_iconid, functiontype, function_icon_style, create_by, create_name, update_by, update_date, create_date, update_name) VALUES ('402881eb6830a378016830a5fa510001', NULL, 1, '周计划任务', '20', 'projecttaskController.do?list&type=weeklyschedule', '2c9358a8675e222b01676e1d8b7f0011', '8a8ab0b246dc81120146dc8180460000', '8a8ab0b246dc81120146dc8180dd001e', 0, '', 'admin', '管理员', NULL, NULL, '2019-01-09 11:26:50', NULL);