博主介紹：?從事軟件開(kāi)發(fā)10年之余，專注于Java技術(shù)領(lǐng)域、Python人工智能及數(shù)據(jù)挖掘、小程序項(xiàng)目開(kāi)發(fā)和Android項(xiàng)目開(kāi)發(fā)等。CSDN、掘金、華為云、InfoQ、阿里云等平臺(tái)優(yōu)質(zhì)作者?

??文末獲取源碼聯(lián)系??

???? 精彩專欄推薦訂閱???? 不然下次找不到喲
————————————————

計(jì)算機(jī)畢業(yè)設(shè)計(jì)題目《1000套》?

目錄

一.前言介紹及開(kāi)發(fā)技術(shù)

二.功能設(shè)計(jì)

三.功能截圖

四.數(shù)據(jù)庫(kù)表結(jié)構(gòu)設(shè)計(jì)

五.關(guān)鍵代碼

六.論文目錄參考

七.源碼獲取

一.前言介紹及開(kāi)發(fā)技術(shù)

時(shí)代在飛速進(jìn)步，?每個(gè)行業(yè)都在努力發(fā)展現(xiàn)在先進(jìn)技術(shù)，通過(guò)這些先進(jìn)的技術(shù)來(lái)提高自己的水平和優(yōu)勢(shì)，智慧養(yǎng)老中心管理系統(tǒng)當(dāng)然不能排除在外。智慧養(yǎng)老中心管理系統(tǒng)是在實(shí)際應(yīng)用和軟件工程的開(kāi)發(fā)原理之上，運(yùn)用Java語(yǔ)言以及SpringBoot+vue框架開(kāi)發(fā)的一個(gè)管理系統(tǒng)。

二.功能設(shè)計(jì)

?系統(tǒng)啟動(dòng)后，在登錄界面，輸入正確的賬號(hào)密碼，選擇進(jìn)入管理員界面或老人信息界面，管理員界面是用來(lái)管理頁(yè)面與老人信息，老人信息界面可以正常的使用發(fā)布文章等功能；管理員模塊屬于是網(wǎng)站的后臺(tái)，進(jìn)入之后有大量的管理員功能，管理員也可以使用老人信息模塊的功能，為了維護(hù)網(wǎng)站的穩(wěn)定與頁(yè)面的布局，將管理員模塊的功能詳細(xì)化后可以使用系統(tǒng)管理對(duì)頁(yè)面進(jìn)行布局修改，可以發(fā)布公告提示老人信息規(guī)范，老人信息模塊只可以查看健康信息和費(fèi)用收繳信息，并且更改個(gè)人信息。

三.功能截圖

?打開(kāi)系統(tǒng)的網(wǎng)址后，首先看到的就是首頁(yè)界面。在這里，人們能夠看到智慧養(yǎng)老中心管理系統(tǒng)的導(dǎo)航條和公告信息等。

?當(dāng)老人沒(méi)有賬戶時(shí)可以通過(guò)注冊(cè)來(lái)登錄系統(tǒng)，只需要根據(jù)相應(yīng)的提示，輸入用戶名和密碼等信息。

?在監(jiān)控信息頁(yè)面的選擇或者輸入監(jiān)控名稱進(jìn)行搜索監(jiān)控詳細(xì)信息。

?在交友互動(dòng)頁(yè)面的輸入欄中輸入互動(dòng)標(biāo)題進(jìn)行搜索互動(dòng)信息，或點(diǎn)擊發(fā)布帖子進(jìn)行交友互動(dòng)。

?在個(gè)人中心頁(yè)面可以更新個(gè)人詳細(xì)信息，并在我的發(fā)布頁(yè)面對(duì)信息進(jìn)行發(fā)布操作。

?在遠(yuǎn)程求助頁(yè)面，老人點(diǎn)擊遠(yuǎn)程求助，在遠(yuǎn)程求助對(duì)話框填寫(xiě)需要求助的內(nèi)容，點(diǎn)擊發(fā)布信息后，管理員會(huì)在后臺(tái)回復(fù)信息。

?后臺(tái)用戶登錄，在登錄頁(yè)面選擇需要登錄的角色，在正確輸入用戶名和密碼后，進(jìn)入操作系統(tǒng)進(jìn)行操作。

?管理員進(jìn)入主頁(yè)面，主要功能包括對(duì)首頁(yè)、個(gè)人中心、老人信息管理、監(jiān)控信息管理、健康信息管理、費(fèi)用收繳管理、交友互動(dòng)、系統(tǒng)管理等進(jìn)行操作。

?管理員點(diǎn)擊老人信息管理。進(jìn)入老人信息管理頁(yè)面選擇性別進(jìn)行查詢、新增和刪除老人詳細(xì)信息，并進(jìn)行詳情，修改和刪除操作。

?管理員點(diǎn)擊監(jiān)控信息管理。進(jìn)入監(jiān)控信息管理頁(yè)面輸入監(jiān)控名稱可以查詢、新增或刪除監(jiān)控信息，并進(jìn)行查看詳情，修改和刪除等操作。

?管理員點(diǎn)擊健康信息管理。進(jìn)入健康信息頁(yè)面輸入體重、發(fā)布日期起始至結(jié)束可以查詢、新增或刪除健康信息，并進(jìn)行查看詳情，修改和刪除等操作。

?管理員點(diǎn)擊費(fèi)用收繳管理。進(jìn)入費(fèi)用收繳管理頁(yè)面輸入繳費(fèi)單號(hào)、繳費(fèi)類型、性別、聯(lián)系電話可以查詢、新增或刪除費(fèi)用收繳信息，并進(jìn)行查看詳情，修改和刪除等操作。

?管理員點(diǎn)擊交友互動(dòng)。進(jìn)入交友互動(dòng)頁(yè)面輸入帖子標(biāo)題進(jìn)行查詢、返回和刪除交友互動(dòng)信息，并進(jìn)行詳情，修改，查看評(píng)論或刪除等操作。

管理員點(diǎn)擊系統(tǒng)管理可以對(duì)遠(yuǎn)程求助，輪播圖管理和公告信息進(jìn)行詳細(xì)操作；在公告信息頁(yè)面輸入標(biāo)題可以查詢、新增和刪除公告信息，并進(jìn)行詳情，修改和刪除操作。

四.數(shù)據(jù)庫(kù)表結(jié)構(gòu)設(shè)計(jì)

DROP TABLE IF EXISTS `ordinary_staff`;
CREATE TABLE `ordinary_staff`(
	   `ordinary_staff_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '普通員工ID',
`gender` varchar(64) comment '性別',
`post_type` varchar(64) comment '崗位類型',
`department_type` varchar(64) comment '部門(mén)類型',
`examine_state` varchar(16) DEFAULT '已通過(guò)' NOT NULL comment '審核狀態(tài)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`user_id` int(11) DEFAULT '0' NOT NULL comment '用戶ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (ordinary_staff_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '普通員工';

DROP TABLE IF EXISTS `ministry_of_personnel`;
CREATE TABLE `ministry_of_personnel`(
	   `ministry_of_personnel_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '人事部門(mén)ID',
`gender` varchar(64) comment '性別',
`department_type` varchar(64) comment '部門(mén)類型',
`post_type` varchar(64) comment '崗位類型',
`examine_state` varchar(16) DEFAULT '已通過(guò)' NOT NULL comment '審核狀態(tài)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`user_id` int(11) DEFAULT '0' NOT NULL comment '用戶ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (ministry_of_personnel_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '人事部門(mén)';

DROP TABLE IF EXISTS `administrative_department`;
CREATE TABLE `administrative_department`(
	   `administrative_department_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理部門(mén)ID',
`gender` varchar(64) comment '性別',
`post_type` varchar(64) comment '崗位類型',
`department_type` varchar(64) comment '部門(mén)類型',
`examine_state` varchar(16) DEFAULT '已通過(guò)' NOT NULL comment '審核狀態(tài)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`user_id` int(11) DEFAULT '0' NOT NULL comment '用戶ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (administrative_department_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '管理部門(mén)';

DROP TABLE IF EXISTS `financial_department`;
CREATE TABLE `financial_department`(
	   `financial_department_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '財(cái)務(wù)部門(mén)ID',
`gender` varchar(64) comment '性別',
`department_type` varchar(64) comment '部門(mén)類型',
`post_type` varchar(64) comment '崗位類型',
`examine_state` varchar(16) DEFAULT '已通過(guò)' NOT NULL comment '審核狀態(tài)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`user_id` int(11) DEFAULT '0' NOT NULL comment '用戶ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (financial_department_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '財(cái)務(wù)部門(mén)';

DROP TABLE IF EXISTS `department_information`;
CREATE TABLE `department_information`(
	   `department_information_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部門(mén)信息ID',
`department_number` varchar(64) comment '部門(mén)編號(hào)',
`department_type` varchar(64) comment '部門(mén)類型',
`number_of_departments` varchar(64) comment '部門(mén)人數(shù)',
`department_profile` text comment '部門(mén)簡(jiǎn)介',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (department_information_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '部門(mén)信息';
insert into `department_information` values (1,'部門(mén)編號(hào)1','部門(mén)類型1','部門(mén)人數(shù)1','部門(mén)簡(jiǎn)介1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `department_information` values (2,'部門(mén)編號(hào)2','部門(mén)類型2','部門(mén)人數(shù)2','部門(mén)簡(jiǎn)介2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `department_information` values (3,'部門(mén)編號(hào)3','部門(mén)類型3','部門(mén)人數(shù)3','部門(mén)簡(jiǎn)介3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `department_information` values (4,'部門(mén)編號(hào)4','部門(mén)類型4','部門(mén)人數(shù)4','部門(mén)簡(jiǎn)介4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `department_information` values (5,'部門(mén)編號(hào)5','部門(mén)類型5','部門(mén)人數(shù)5','部門(mén)簡(jiǎn)介5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `department_information` values (6,'部門(mén)編號(hào)6','部門(mén)類型6','部門(mén)人數(shù)6','部門(mén)簡(jiǎn)介6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `department_information` values (7,'部門(mén)編號(hào)7','部門(mén)類型7','部門(mén)人數(shù)7','部門(mén)簡(jiǎn)介7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `department_information` values (8,'部門(mén)編號(hào)8','部門(mén)類型8','部門(mén)人數(shù)8','部門(mén)簡(jiǎn)介8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `position_information`;
CREATE TABLE `position_information`(
	   `position_information_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '崗位信息ID',
`job_no` varchar(64) comment '崗位編號(hào)',
`post_type` varchar(64) comment '崗位類型',
`number_of_posts` varchar(64) comment '崗位人數(shù)',
`job_profile` text comment '崗位簡(jiǎn)介',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (position_information_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '崗位信息';
insert into `position_information` values (1,'崗位編號(hào)1','崗位類型1','崗位人數(shù)1','崗位簡(jiǎn)介1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `position_information` values (2,'崗位編號(hào)2','崗位類型2','崗位人數(shù)2','崗位簡(jiǎn)介2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `position_information` values (3,'崗位編號(hào)3','崗位類型3','崗位人數(shù)3','崗位簡(jiǎn)介3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `position_information` values (4,'崗位編號(hào)4','崗位類型4','崗位人數(shù)4','崗位簡(jiǎn)介4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `position_information` values (5,'崗位編號(hào)5','崗位類型5','崗位人數(shù)5','崗位簡(jiǎn)介5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `position_information` values (6,'崗位編號(hào)6','崗位類型6','崗位人數(shù)6','崗位簡(jiǎn)介6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `position_information` values (7,'崗位編號(hào)7','崗位類型7','崗位人數(shù)7','崗位簡(jiǎn)介7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `position_information` values (8,'崗位編號(hào)8','崗位類型8','崗位人數(shù)8','崗位簡(jiǎn)介8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `clock_in`;
CREATE TABLE `clock_in`(
	   `clock_in_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '考勤打卡ID',
`punch_in_number` varchar(64) comment '打卡編號(hào)',
`clock_in_time` varchar(64) comment '打卡時(shí)間',
`punch_in_type` varchar(64) comment '打卡類型',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (clock_in_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '考勤打卡';
insert into `clock_in` values (1,'打卡編號(hào)1','打卡時(shí)間1','打卡類型1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `clock_in` values (2,'打卡編號(hào)2','打卡時(shí)間2','打卡類型2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `clock_in` values (3,'打卡編號(hào)3','打卡時(shí)間3','打卡類型3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `clock_in` values (4,'打卡編號(hào)4','打卡時(shí)間4','打卡類型4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `clock_in` values (5,'打卡編號(hào)5','打卡時(shí)間5','打卡類型5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `clock_in` values (6,'打卡編號(hào)6','打卡時(shí)間6','打卡類型6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `clock_in` values (7,'打卡編號(hào)7','打卡時(shí)間7','打卡類型7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `clock_in` values (8,'打卡編號(hào)8','打卡時(shí)間8','打卡類型8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `leave_management`;
CREATE TABLE `leave_management`(
	   `leave_management_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '請(qǐng)假管理ID',
`leave_no` varchar(64) comment '請(qǐng)假編號(hào)',
`leave_type` varchar(64) comment '請(qǐng)假類型',
`leave_start_time` date comment '請(qǐng)假開(kāi)始時(shí)間',
`leave_end_time` date comment '請(qǐng)假結(jié)束時(shí)間',
`total_time` varchar(64) comment '總共時(shí)長(zhǎng)',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`financial_department` int(11) DEFAULT 0 comment '財(cái)務(wù)部門(mén)',
`reason_for_leave` text comment '請(qǐng)假原因',
`examine_state` varchar(16) DEFAULT '未審核' NOT NULL comment '審核狀態(tài)',
`examine_reply` varchar(16) DEFAULT '' comment '審核回復(fù)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (leave_management_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '請(qǐng)假管理';
insert into `leave_management` values (1,'請(qǐng)假編號(hào)1','請(qǐng)假類型1','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)1',0,0,0,'請(qǐng)假原因1','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `leave_management` values (2,'請(qǐng)假編號(hào)2','請(qǐng)假類型2','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)2',0,0,0,'請(qǐng)假原因2','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `leave_management` values (3,'請(qǐng)假編號(hào)3','請(qǐng)假類型3','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)3',0,0,0,'請(qǐng)假原因3','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `leave_management` values (4,'請(qǐng)假編號(hào)4','請(qǐng)假類型4','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)4',0,0,0,'請(qǐng)假原因4','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `leave_management` values (5,'請(qǐng)假編號(hào)5','請(qǐng)假類型5','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)5',0,0,0,'請(qǐng)假原因5','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `leave_management` values (6,'請(qǐng)假編號(hào)6','請(qǐng)假類型6','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)6',0,0,0,'請(qǐng)假原因6','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `leave_management` values (7,'請(qǐng)假編號(hào)7','請(qǐng)假類型7','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)7',0,0,0,'請(qǐng)假原因7','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `leave_management` values (8,'請(qǐng)假編號(hào)8','請(qǐng)假類型8','2022-3-24','2022-3-24','總共時(shí)長(zhǎng)8',0,0,0,'請(qǐng)假原因8','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `attendance_statistics`;
CREATE TABLE `attendance_statistics`(
	   `attendance_statistics_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '考勤統(tǒng)計(jì)ID',
`statistical_number` varchar(64) comment '統(tǒng)計(jì)編號(hào)',
`statistical_type` varchar(64) comment '統(tǒng)計(jì)類型',
`number_of_people` int(11) DEFAULT 0 comment '人數(shù)',
`time` date comment '時(shí)間',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (attendance_statistics_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '考勤統(tǒng)計(jì)';
insert into `attendance_statistics` values (1,'統(tǒng)計(jì)編號(hào)1','統(tǒng)計(jì)類型1',5,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `attendance_statistics` values (2,'統(tǒng)計(jì)編號(hào)2','統(tǒng)計(jì)類型2',10,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `attendance_statistics` values (3,'統(tǒng)計(jì)編號(hào)3','統(tǒng)計(jì)類型3',15,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `attendance_statistics` values (4,'統(tǒng)計(jì)編號(hào)4','統(tǒng)計(jì)類型4',20,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `attendance_statistics` values (5,'統(tǒng)計(jì)編號(hào)5','統(tǒng)計(jì)類型5',25,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `attendance_statistics` values (6,'統(tǒng)計(jì)編號(hào)6','統(tǒng)計(jì)類型6',30,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `attendance_statistics` values (7,'統(tǒng)計(jì)編號(hào)7','統(tǒng)計(jì)類型7',35,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `attendance_statistics` values (8,'統(tǒng)計(jì)編號(hào)8','統(tǒng)計(jì)類型8',40,'2022-3-24',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `reimbursement_information`;
CREATE TABLE `reimbursement_information`(
	   `reimbursement_information_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '報(bào)銷(xiāo)信息ID',
`reimbursement_no` varchar(64) comment '報(bào)銷(xiāo)編號(hào)',
`reimbursement_type` varchar(64) comment '報(bào)銷(xiāo)類型',
`reimbursement_amount` int(11) DEFAULT 0 comment '報(bào)銷(xiāo)金額',
`reimbursement_time` date comment '報(bào)銷(xiāo)時(shí)間',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`financial_department` int(11) DEFAULT 0 comment '財(cái)務(wù)部門(mén)',
`reimbursement_data` longtext comment '報(bào)銷(xiāo)資料',
`examine_state` varchar(16) DEFAULT '未審核' NOT NULL comment '審核狀態(tài)',
`examine_reply` varchar(16) DEFAULT '' comment '審核回復(fù)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (reimbursement_information_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '報(bào)銷(xiāo)信息';
insert into `reimbursement_information` values (1,'報(bào)銷(xiāo)編號(hào)1','報(bào)銷(xiāo)類型1',5,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)1','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `reimbursement_information` values (2,'報(bào)銷(xiāo)編號(hào)2','報(bào)銷(xiāo)類型2',10,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)2','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `reimbursement_information` values (3,'報(bào)銷(xiāo)編號(hào)3','報(bào)銷(xiāo)類型3',15,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)3','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `reimbursement_information` values (4,'報(bào)銷(xiāo)編號(hào)4','報(bào)銷(xiāo)類型4',20,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)4','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `reimbursement_information` values (5,'報(bào)銷(xiāo)編號(hào)5','報(bào)銷(xiāo)類型5',25,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)5','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `reimbursement_information` values (6,'報(bào)銷(xiāo)編號(hào)6','報(bào)銷(xiāo)類型6',30,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)6','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `reimbursement_information` values (7,'報(bào)銷(xiāo)編號(hào)7','報(bào)銷(xiāo)類型7',35,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)7','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `reimbursement_information` values (8,'報(bào)銷(xiāo)編號(hào)8','報(bào)銷(xiāo)類型8',40,'2022-3-24',0,0,0,'此處可上傳文字、圖片、視頻、超鏈接、表格等內(nèi)容區(qū)8','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `revenue_information`;
CREATE TABLE `revenue_information`(
	   `revenue_information_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '收入信息ID',
`revenue_number` varchar(64) comment '收入編號(hào)',
`income_type` varchar(64) comment '收入類型',
`revenue_amount` int(11) DEFAULT 0 comment '收入金額',
`income_time` date comment '收入時(shí)間',
`handling_personnel` varchar(64) comment '辦理人員',
`finance` int(11) DEFAULT 0 comment '財(cái)務(wù)',
`revenue_remarks` text comment '收入備注',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (revenue_information_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '收入信息';
insert into `revenue_information` values (1,'收入編號(hào)1','收入類型1',5,'2022-3-24','辦理人員1',0,'收入備注1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `revenue_information` values (2,'收入編號(hào)2','收入類型2',10,'2022-3-24','辦理人員2',0,'收入備注2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `revenue_information` values (3,'收入編號(hào)3','收入類型3',15,'2022-3-24','辦理人員3',0,'收入備注3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `revenue_information` values (4,'收入編號(hào)4','收入類型4',20,'2022-3-24','辦理人員4',0,'收入備注4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `revenue_information` values (5,'收入編號(hào)5','收入類型5',25,'2022-3-24','辦理人員5',0,'收入備注5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `revenue_information` values (6,'收入編號(hào)6','收入類型6',30,'2022-3-24','辦理人員6',0,'收入備注6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `revenue_information` values (7,'收入編號(hào)7','收入類型7',35,'2022-3-24','辦理人員7',0,'收入備注7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `revenue_information` values (8,'收入編號(hào)8','收入類型8',40,'2022-3-24','辦理人員8',0,'收入備注8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `expenditure_information`;
CREATE TABLE `expenditure_information`(
	   `expenditure_information_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '支出信息ID',
`expenditure_number` varchar(64) comment '支出編號(hào)',
`expenditure_type` varchar(64) comment '支出類型',
`payment_slip` int(11) DEFAULT 0 comment '支出費(fèi)用',
`expenditure_time` date comment '支出時(shí)間',
`expenditure_personnel` varchar(64) comment '支出人員',
`finance` int(11) DEFAULT 0 comment '財(cái)務(wù)',
`expenditure_remarks` text comment '支出備注',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (expenditure_information_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '支出信息';
insert into `expenditure_information` values (1,'支出編號(hào)1','支出類型1',5,'2022-3-24','支出人員1',0,'支出備注1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `expenditure_information` values (2,'支出編號(hào)2','支出類型2',10,'2022-3-24','支出人員2',0,'支出備注2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `expenditure_information` values (3,'支出編號(hào)3','支出類型3',15,'2022-3-24','支出人員3',0,'支出備注3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `expenditure_information` values (4,'支出編號(hào)4','支出類型4',20,'2022-3-24','支出人員4',0,'支出備注4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `expenditure_information` values (5,'支出編號(hào)5','支出類型5',25,'2022-3-24','支出人員5',0,'支出備注5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `expenditure_information` values (6,'支出編號(hào)6','支出類型6',30,'2022-3-24','支出人員6',0,'支出備注6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `expenditure_information` values (7,'支出編號(hào)7','支出類型7',35,'2022-3-24','支出人員7',0,'支出備注7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `expenditure_information` values (8,'支出編號(hào)8','支出類型8',40,'2022-3-24','支出人員8',0,'支出備注8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `employee_salary`;
CREATE TABLE `employee_salary`(
	   `employee_salary_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '員工工資ID',
`salary_number` varchar(64) comment '工資編號(hào)',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`financial_department` int(11) DEFAULT 0 comment '財(cái)務(wù)部門(mén)',
`administrative_department` int(11) DEFAULT 0 comment '管理部門(mén)',
`department_type` varchar(64) comment '部門(mén)類型',
`post_type` varchar(64) comment '崗位類型',
`full_name` varchar(64) comment '姓名',
`base_pay` int(11) DEFAULT 0 comment '基本工資',
`deduction_fee` int(11) DEFAULT 0 comment '扣款費(fèi)',
`overtime_pay` int(11) DEFAULT 0 comment '加班費(fèi)',
`total_amount` varchar(64) comment '總金額',
`finance` int(11) DEFAULT 0 comment '財(cái)務(wù)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (employee_salary_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '員工工資';
insert into `employee_salary` values (1,'工資編號(hào)1',0,0,0,0,'部門(mén)類型1','崗位類型1','姓名1',5,5,5,'總金額1',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `employee_salary` values (2,'工資編號(hào)2',0,0,0,0,'部門(mén)類型2','崗位類型2','姓名2',10,10,10,'總金額2',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `employee_salary` values (3,'工資編號(hào)3',0,0,0,0,'部門(mén)類型3','崗位類型3','姓名3',15,15,15,'總金額3',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `employee_salary` values (4,'工資編號(hào)4',0,0,0,0,'部門(mén)類型4','崗位類型4','姓名4',20,20,20,'總金額4',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `employee_salary` values (5,'工資編號(hào)5',0,0,0,0,'部門(mén)類型5','崗位類型5','姓名5',25,25,25,'總金額5',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `employee_salary` values (6,'工資編號(hào)6',0,0,0,0,'部門(mén)類型6','崗位類型6','姓名6',30,30,30,'總金額6',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `employee_salary` values (7,'工資編號(hào)7',0,0,0,0,'部門(mén)類型7','崗位類型7','姓名7',35,35,35,'總金額7',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `employee_salary` values (8,'工資編號(hào)8',0,0,0,0,'部門(mén)類型8','崗位類型8','姓名8',40,40,40,'總金額8',0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `announcement_notice`;
CREATE TABLE `announcement_notice`(
	   `announcement_notice_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告通知ID',
`announcement_no` varchar(64) comment '公告編號(hào)',
`announcement_type` varchar(64) comment '公告類型',
`announcement_title` varchar(64) comment '公告標(biāo)題',
`publisher` int(11) DEFAULT 0 comment '發(fā)布人',
`announcement_content` text comment '公告內(nèi)容',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (announcement_notice_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '公告通知';
insert into `announcement_notice` values (1,'公告編號(hào)1','公告類型1','公告標(biāo)題1',0,'公告內(nèi)容1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `announcement_notice` values (2,'公告編號(hào)2','公告類型2','公告標(biāo)題2',0,'公告內(nèi)容2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `announcement_notice` values (3,'公告編號(hào)3','公告類型3','公告標(biāo)題3',0,'公告內(nèi)容3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `announcement_notice` values (4,'公告編號(hào)4','公告類型4','公告標(biāo)題4',0,'公告內(nèi)容4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `announcement_notice` values (5,'公告編號(hào)5','公告類型5','公告標(biāo)題5',0,'公告內(nèi)容5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `announcement_notice` values (6,'公告編號(hào)6','公告類型6','公告標(biāo)題6',0,'公告內(nèi)容6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `announcement_notice` values (7,'公告編號(hào)7','公告類型7','公告標(biāo)題7',0,'公告內(nèi)容7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `announcement_notice` values (8,'公告編號(hào)8','公告類型8','公告標(biāo)題8',0,'公告內(nèi)容8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `file_information`;
CREATE TABLE `file_information`(
	   `file_information_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文件信息ID',
`document_number` varchar(64) comment '文件編號(hào)',
`file_type` varchar(64) comment '文件類型',
`document_title` varchar(64) comment '文件標(biāo)題',
`enclosure` varchar(255) comment '附件',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`financial_department` int(11) DEFAULT 0 comment '財(cái)務(wù)部門(mén)',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`sender` int(11) DEFAULT 0 comment '發(fā)件人',
`sending_time` date comment '發(fā)送時(shí)間',
`document_content` text comment '文件內(nèi)容',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (file_information_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '文件信息';
insert into `file_information` values (1,'文件編號(hào)1','文件類型1','文件標(biāo)題1','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `file_information` values (2,'文件編號(hào)2','文件類型2','文件標(biāo)題2','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `file_information` values (3,'文件編號(hào)3','文件類型3','文件標(biāo)題3','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `file_information` values (4,'文件編號(hào)4','文件類型4','文件標(biāo)題4','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `file_information` values (5,'文件編號(hào)5','文件類型5','文件標(biāo)題5','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `file_information` values (6,'文件編號(hào)6','文件類型6','文件標(biāo)題6','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `file_information` values (7,'文件編號(hào)7','文件類型7','文件標(biāo)題7','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `file_information` values (8,'文件編號(hào)8','文件類型8','文件標(biāo)題8','點(diǎn)此下載',0,0,0,0,'2022-3-24','文件內(nèi)容8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `my_email`;
CREATE TABLE `my_email`(
	   `my_email_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '我的郵箱ID',
`mailbox_number` varchar(64) comment '郵箱編號(hào)',
`mailbox_type` varchar(64) comment '郵箱類型',
`mailbox_title` varchar(64) comment '郵箱標(biāo)題',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`financial_department` int(11) DEFAULT 0 comment '財(cái)務(wù)部門(mén)',
`administrative_department` int(11) DEFAULT 0 comment '管理部門(mén)',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`content` text comment '內(nèi)容',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (my_email_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '我的郵箱';
insert into `my_email` values (1,'郵箱編號(hào)1','郵箱類型1','郵箱標(biāo)題1',0,0,0,0,'內(nèi)容1','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_email` values (2,'郵箱編號(hào)2','郵箱類型2','郵箱標(biāo)題2',0,0,0,0,'內(nèi)容2','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_email` values (3,'郵箱編號(hào)3','郵箱類型3','郵箱標(biāo)題3',0,0,0,0,'內(nèi)容3','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_email` values (4,'郵箱編號(hào)4','郵箱類型4','郵箱標(biāo)題4',0,0,0,0,'內(nèi)容4','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_email` values (5,'郵箱編號(hào)5','郵箱類型5','郵箱標(biāo)題5',0,0,0,0,'內(nèi)容5','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_email` values (6,'郵箱編號(hào)6','郵箱類型6','郵箱標(biāo)題6',0,0,0,0,'內(nèi)容6','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_email` values (7,'郵箱編號(hào)7','郵箱類型7','郵箱標(biāo)題7',0,0,0,0,'內(nèi)容7','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_email` values (8,'郵箱編號(hào)8','郵箱類型8','郵箱標(biāo)題8',0,0,0,0,'內(nèi)容8','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `my_job`;
CREATE TABLE `my_job`(
	   `my_job_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '我的工作ID',
`job_number` varchar(64) comment '工作編號(hào)',
`type_of_work` varchar(64) comment '工作類型',
`job_title` varchar(64) comment '工作標(biāo)題',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`job_content` text comment '工作內(nèi)容',
`workflow` text comment '工作流程',
`examine_state` varchar(16) DEFAULT '未審核' NOT NULL comment '審核狀態(tài)',
`examine_reply` varchar(16) DEFAULT '' comment '審核回復(fù)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (my_job_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '我的工作';
insert into `my_job` values (1,'工作編號(hào)1','工作類型1','工作標(biāo)題1',0,'工作內(nèi)容1','工作流程1','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_job` values (2,'工作編號(hào)2','工作類型2','工作標(biāo)題2',0,'工作內(nèi)容2','工作流程2','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_job` values (3,'工作編號(hào)3','工作類型3','工作標(biāo)題3',0,'工作內(nèi)容3','工作流程3','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_job` values (4,'工作編號(hào)4','工作類型4','工作標(biāo)題4',0,'工作內(nèi)容4','工作流程4','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_job` values (5,'工作編號(hào)5','工作類型5','工作標(biāo)題5',0,'工作內(nèi)容5','工作流程5','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_job` values (6,'工作編號(hào)6','工作類型6','工作標(biāo)題6',0,'工作內(nèi)容6','工作流程6','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_job` values (7,'工作編號(hào)7','工作類型7','工作標(biāo)題7',0,'工作內(nèi)容7','工作流程7','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `my_job` values (8,'工作編號(hào)8','工作類型8','工作標(biāo)題8',0,'工作內(nèi)容8','工作流程8','未審核','','0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `punch_in_record`;
CREATE TABLE `punch_in_record`(
	   `punch_in_record_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '簽到打卡記錄ID',
`punch_in_number` varchar(64) comment '打卡編號(hào)',
`clock_in_time` varchar(64) comment '打卡時(shí)間',
`punch_in_type` varchar(64) comment '打卡類型',
`check_in_time` datetime comment '簽到時(shí)間',
`post_type` varchar(64) comment '崗位類型',
`department_type` varchar(64) comment '部門(mén)類型',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`administrative_department` int(11) DEFAULT 0 comment '管理部門(mén)',
`financial_department` int(11) DEFAULT 0 comment '財(cái)務(wù)部門(mén)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (punch_in_record_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '簽到打卡記錄';
insert into `punch_in_record` values (1,'打卡編號(hào)1','打卡時(shí)間1','打卡類型1','2022-3-24 18:45:7','崗位類型1','部門(mén)類型1',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `punch_in_record` values (2,'打卡編號(hào)2','打卡時(shí)間2','打卡類型2','2022-3-24 18:45:7','崗位類型2','部門(mén)類型2',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `punch_in_record` values (3,'打卡編號(hào)3','打卡時(shí)間3','打卡類型3','2022-3-24 18:45:7','崗位類型3','部門(mén)類型3',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `punch_in_record` values (4,'打卡編號(hào)4','打卡時(shí)間4','打卡類型4','2022-3-24 18:45:7','崗位類型4','部門(mén)類型4',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `punch_in_record` values (5,'打卡編號(hào)5','打卡時(shí)間5','打卡類型5','2022-3-24 18:45:7','崗位類型5','部門(mén)類型5',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `punch_in_record` values (6,'打卡編號(hào)6','打卡時(shí)間6','打卡類型6','2022-3-24 18:45:7','崗位類型6','部門(mén)類型6',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `punch_in_record` values (7,'打卡編號(hào)7','打卡時(shí)間7','打卡類型7','2022-3-24 18:45:7','崗位類型7','部門(mén)類型7',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');
insert into `punch_in_record` values (8,'打卡編號(hào)8','打卡時(shí)間8','打卡類型8','2022-3-24 18:45:7','崗位類型8','部門(mén)類型8',0,0,0,0,'0','2022-03-24 18:45:07','2022-03-24 18:45:07');

DROP TABLE IF EXISTS `sign_out_punch_in_record`;
CREATE TABLE `sign_out_punch_in_record`(
	   `sign_out_punch_in_record_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '簽退打卡記錄ID',
`punch_in_number` varchar(64) comment '打卡編號(hào)',
`clock_in_time` varchar(64) comment '打卡時(shí)間',
`punch_in_type` varchar(64) comment '打卡類型',
`sign_out_time` datetime comment '簽退時(shí)間',
`post_type` varchar(64) comment '崗位類型',
`department_type` varchar(64) comment '部門(mén)類型',
`ordinary_staff` int(11) DEFAULT 0 comment '普通員工',
`personnel_department` int(11) DEFAULT 0 comment '人事部門(mén)',
`administrative_department` int(11) DEFAULT 0 comment '管理部門(mén)',
`financial_department` int(11) DEFAULT 0 comment '財(cái)務(wù)部門(mén)',
`recommend` int(11) DEFAULT '0' NOT NULL comment '智能推薦',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間',
 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間',

	   PRIMARY KEY (sign_out_punch_in_record_id)
	)ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '簽退打卡記錄';
insert into `sign_out_punch_in_record` values (1,'打卡編號(hào)1','打卡時(shí)間1','打卡類型1','2022-3-24 18:45:8','崗位類型1','部門(mén)類型1',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');
insert into `sign_out_punch_in_record` values (2,'打卡編號(hào)2','打卡時(shí)間2','打卡類型2','2022-3-24 18:45:8','崗位類型2','部門(mén)類型2',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');
insert into `sign_out_punch_in_record` values (3,'打卡編號(hào)3','打卡時(shí)間3','打卡類型3','2022-3-24 18:45:8','崗位類型3','部門(mén)類型3',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');
insert into `sign_out_punch_in_record` values (4,'打卡編號(hào)4','打卡時(shí)間4','打卡類型4','2022-3-24 18:45:8','崗位類型4','部門(mén)類型4',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');
insert into `sign_out_punch_in_record` values (5,'打卡編號(hào)5','打卡時(shí)間5','打卡類型5','2022-3-24 18:45:8','崗位類型5','部門(mén)類型5',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');
insert into `sign_out_punch_in_record` values (6,'打卡編號(hào)6','打卡時(shí)間6','打卡類型6','2022-3-24 18:45:8','崗位類型6','部門(mén)類型6',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');
insert into `sign_out_punch_in_record` values (7,'打卡編號(hào)7','打卡時(shí)間7','打卡類型7','2022-3-24 18:45:8','崗位類型7','部門(mén)類型7',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');
insert into `sign_out_punch_in_record` values (8,'打卡編號(hào)8','打卡時(shí)間8','打卡類型8','2022-3-24 18:45:8','崗位類型8','部門(mén)類型8',0,0,0,0,'0','2022-03-24 18:45:08','2022-03-24 18:45:08');

DROP TABLE IF EXISTS `access_token`;
CREATE TABLE `access_token` (
  `token_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '臨時(shí)訪問(wèn)牌ID',
  `token` varchar(64) DEFAULT NULL COMMENT '臨時(shí)訪問(wèn)牌',
  `info` text,
  `maxage` int(2) NOT NULL DEFAULT '2' COMMENT '最大壽命：默認(rèn)2小時(shí)',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間：',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間：',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用戶編號(hào):',
  PRIMARY KEY (`token_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='臨時(shí)訪問(wèn)牌';
insert into `access_token` values ('57','5accf85cb6a7f06f0aa2968deadaec1b',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('58','46ff1d4d07714f046ba07b34bffe0af9',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('59','ed9d6cba9826fda1beafcd9326be7a86',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('60','c99763c1833ea0785d9e2b81da3fd28f',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('61','33fbfaccd6d1cb9143e4129bd919d4b0',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('62','493e13da5f293ba67a56a0fe3e1fa6cf',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('63','c4b48e9e2160db09c703041a8fee0a1f',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('64','d13cdaefd3823c360c959a02a262f71d',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('65','6c6ff426fd77ea5a2025ce5ed2e42c8a',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('66','80930065a61ffcdd5cbb75f60932973c',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('67','94114763cf2e3b020495d8a27096d4ef',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('68','761052c551c97c9317bc3aa475c85b84',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('69','7c44ef14131a0ba7c16aa16cef104065',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('70','96380f3d9542c80d04bdade1cf7635a5',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('71','bfdc7acfcbf5763fda81945b60961222',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('72','170a598e51ae8ae2badde20a42fe171d',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('73','c82c357488c75926a92d8a9608d4b367',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('74','4d35290c023f407a820f37dbbb1ceb09',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('75','8d19162776682b695c0f62f3c7a92fec',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('76','a7ea2cdc9a2be179e19200e593ad5a69',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('77','c79a554f9832adc01f19682c5d576bc4',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('78','1c7d95001fa09951a679841c8100ad1f',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('79','776da1bcdd01ddb3cbf0a37fa13fc5b0',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('80','d336e88e57c329d0166931292c1fac41',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('81','37a40f526a6c82fc6110b512802d35bf',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('82','691ad331771f4109206d58aeee572371',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('83','9942e458886219960d3344b4a6a6fbec',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('84','e9939a8b7ccf9f548f0bbb5664981f96',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('85','f5b27912060d1909bef61fab9d96faae',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('86','7c5888682f1d449eb1b62f0054a79fbf',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('87','00dfdc6ac21c4a9da80fd71c990764d1',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('88','3cce592bc72840ab932ce96d85a194da',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('89','43fdaa989a644ad683ef4b4d488e8629',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('90','d6a3cecadacff0dbd6b43b25372cc2a2',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('91','5570bc5b07b3589f4ef8553bd46eb0d1',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('92','5570bc5b07b3589f4ef8553bd46eb0d1',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('93','26c553bd2ee2ab6605d18dfd310d85f9',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('94','3fd52f81236ed2c37ff91a6696d4e47a',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('95','893332e9ee67d60d8312b3700c58a359',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('96','b7844068ade535b2e517df4a40948703',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('97','179b37a5e1893c3af6b946bd5a1c8625',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('98','3a47b8a040a83ebbc9194cb255dc668c',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('99','afa60196afb77dcc2b520ed13a817560',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
insert into `access_token` values ('100','7fc6d9b324f8c0a3a1784d04ef132692',null,'2',"2022-01-14 07:32:09.000 ","2022-01-14 07:32:09.000 ",'1');
DROP TABLE IF EXISTS `auth`;
CREATE TABLE `auth` (
  `auth_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '授權(quán)ID：',
  `user_group` varchar(64) DEFAULT NULL COMMENT '用戶組：',
  `mod_name` varchar(64) DEFAULT NULL COMMENT '模塊名：',
  `table_name` varchar(64) DEFAULT NULL COMMENT '表名：',
  `page_title` varchar(255) DEFAULT NULL COMMENT '頁(yè)面標(biāo)題：',
  `path` varchar(255) DEFAULT NULL COMMENT '路由路徑：',
  `position` varchar(32) DEFAULT NULL COMMENT '位置：',
  `mode` varchar(32) NOT NULL DEFAULT '_blank' COMMENT '跳轉(zhuǎn)方式：',
  `add` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可增加：',
  `del` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可刪除：',
  `set` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可修改：',
  `get` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否可查看：',
  `field_add` varchar(500) DEFAULT NULL COMMENT '添加字段：',
  `field_set` varchar(500) DEFAULT NULL COMMENT '修改字段：',
  `field_get` varchar(500) DEFAULT NULL COMMENT '查詢字段：',
  `table_nav_name` varchar(255) DEFAULT NULL COMMENT '跨表導(dǎo)航名稱：',
  `table_nav` varchar(255) DEFAULT NULL COMMENT '跨表導(dǎo)航：',
  `option` text COMMENT '配置：',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間：',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間：',
  PRIMARY KEY (`auth_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='定制授權(quán)';
DROP TABLE IF EXISTS `upload`;
CREATE TABLE `upload` (
  `upload_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '上傳ID',
  `name` varchar(64) DEFAULT NULL COMMENT '文件名',
  `path` varchar(255) DEFAULT NULL COMMENT '訪問(wèn)路徑',
  `file` varchar(255) DEFAULT NULL COMMENT '文件路徑',
  `display` varchar(255) DEFAULT NULL COMMENT '顯示順序',
  `father_id` int(11) DEFAULT '0' COMMENT '父級(jí)ID',
  `dir` varchar(255) DEFAULT NULL COMMENT '文件夾',
  `type` varchar(32) DEFAULT NULL COMMENT '文件類型',
  PRIMARY KEY (`upload_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
insert into `upload` values ('1','movie.mp4','/upload/movie.mp4','',null,'0',null,'video');
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶ID：[0,8388607]用戶獲取其他與用戶相關(guān)的數(shù)據(jù)',
  `state` smallint(1) unsigned NOT NULL DEFAULT '1' COMMENT '賬戶狀態(tài)：[0,10](1可用|2異常|3已凍結(jié)|4已注銷(xiāo))',
  `user_group` varchar(32) DEFAULT NULL COMMENT '所在用戶組：[0,32767]決定用戶身份和權(quán)限',
  `login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上次登錄時(shí)間：',
  `phone` varchar(11) DEFAULT NULL COMMENT '手機(jī)號(hào)碼：[0,11]用戶的手機(jī)號(hào)碼，用于找回密碼時(shí)或登錄時(shí)',
  `phone_state` smallint(1) unsigned NOT NULL DEFAULT '0' COMMENT '手機(jī)認(rèn)證：[0,1](0未認(rèn)證|1審核中|2已認(rèn)證)',
  `username` varchar(16) NOT NULL DEFAULT '' COMMENT '用戶名：[0,16]用戶登錄時(shí)所用的賬戶名稱',
  `nickname` varchar(16) DEFAULT '' COMMENT '昵稱：[0,16]',
  `password` varchar(64) NOT NULL DEFAULT '' COMMENT '密碼：[0,32]用戶登錄所需的密碼，由6-16位數(shù)字或英文組成',
  `email` varchar(64) DEFAULT '' COMMENT '郵箱：[0,64]用戶的郵箱，用于找回密碼時(shí)或登錄時(shí)',
  `email_state` smallint(1) unsigned NOT NULL DEFAULT '0' COMMENT '郵箱認(rèn)證：[0,1](0未認(rèn)證|1審核中|2已認(rèn)證)',
  `avatar` varchar(255) DEFAULT NULL COMMENT '頭像地址：[0,255]',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間：',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用戶賬戶：用于保存用戶登錄信息';
insert into `user` values ('1','1','管理員',"2022-04-19 07:32:09.000 ",null,'0','admin','admin','bfd59291e825b5f2bbf1eb76569f8fe7','','0','/api/upload/avatar.jpg',"2022-04-19 07:32:09.000 ");
DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
  `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶組ID：[0,8388607]',
  `display` smallint(4) unsigned NOT NULL DEFAULT '100' COMMENT '顯示順序：[0,1000]',
  `name` varchar(16) NOT NULL DEFAULT '' COMMENT '名稱：[0,16]',
  `description` varchar(255) DEFAULT NULL COMMENT '描述：[0,255]描述該用戶組的特點(diǎn)或權(quán)限范圍',
  `source_table` varchar(255) DEFAULT NULL COMMENT '來(lái)源表：',
  `source_field` varchar(255) DEFAULT NULL COMMENT '來(lái)源字段：',
  `source_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '來(lái)源ID：',
  `register` smallint(1) unsigned DEFAULT '0' COMMENT '注冊(cè)位置:',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間：',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間：',
  PRIMARY KEY (`group_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用戶組：用于用戶前端身份和鑒權(quán)';
DROP TABLE IF EXISTS `hits`;
CREATE TABLE `hits` (
  `hits_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '點(diǎn)贊ID：',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '點(diǎn)贊人：',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時(shí)間：',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時(shí)間：',
  `source_table` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '來(lái)源表：',
  `source_field` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '來(lái)源字段：',
  `source_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '來(lái)源ID：',
  PRIMARY KEY (`hits_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
insert into `auth` values ('1','管理員','普通員工','ordinary_staff','普通員工','/ordinary_staff/table','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('2','管理員','普通員工','ordinary_staff','普通員工詳情','/ordinary_staff/view','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('3','管理員','人事部門(mén)','ministry_of_personnel','人事部門(mén)','/ministry_of_personnel/table','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{"export_db":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('4','管理員','人事部門(mén)','ministry_of_personnel','人事部門(mén)詳情','/ministry_of_personnel/view','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('5','管理員','管理部門(mén)','administrative_department','管理部門(mén)','/administrative_department/table','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('6','管理員','管理部門(mén)','administrative_department','管理部門(mén)詳情','/administrative_department/view','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('7','管理員','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)','/financial_department/table','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('8','管理員','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)詳情','/financial_department/view','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('9','管理員','部門(mén)信息','department_information','部門(mén)信息','/department_information/table','','_blank','1','1','1','1','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('10','管理員','部門(mén)信息','department_information','部門(mén)信息詳情','/department_information/view','','_blank','1','1','1','1','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('11','管理員','崗位信息','position_information','崗位信息','/position_information/table','','_blank','1','1','1','1','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('12','管理員','崗位信息','position_information','崗位信息詳情','/position_information/view','','_blank','1','1','1','1','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('13','管理員','考勤打卡','clock_in','考勤打卡','/clock_in/table','','_blank','1','1','1','1','punch_in_number,clock_in_time,punch_in_type','punch_in_number,clock_in_time,punch_in_type','punch_in_number,clock_in_time,punch_in_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('14','管理員','考勤打卡','clock_in','考勤打卡詳情','/clock_in/view','','_blank','1','1','1','1','punch_in_number,clock_in_time,punch_in_type','punch_in_number,clock_in_time,punch_in_type','punch_in_number,clock_in_time,punch_in_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('15','管理員','請(qǐng)假管理','leave_management','請(qǐng)假管理','/leave_management/table','','_blank','1','1','1','1','leave_no,leave_type,leave_start_time,leave_end_time,total_time,ordinary_staff,personnel_department,financial_department,reason_for_leave','leave_no,leave_type,leave_start_time,leave_end_time,total_time,ordinary_staff,personnel_department,financial_department,reason_for_leave','leave_no,leave_type,leave_start_time,leave_end_time,total_time,ordinary_staff,personnel_department,financial_department,reason_for_leave',null,'0','{"examine":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('16','管理員','請(qǐng)假管理','leave_management','請(qǐng)假管理詳情','/leave_management/view','','_blank','1','1','1','1','leave_no,leave_type,leave_start_time,leave_end_time,total_time,ordinary_staff,personnel_department,financial_department,reason_for_leave','leave_no,leave_type,leave_start_time,leave_end_time,total_time,ordinary_staff,personnel_department,financial_department,reason_for_leave','leave_no,leave_type,leave_start_time,leave_end_time,total_time,ordinary_staff,personnel_department,financial_department,reason_for_leave',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('17','管理員','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)','/attendance_statistics/table','','_blank','1','1','1','1','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{"figure":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('18','管理員','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)詳情','/attendance_statistics/view','','_blank','1','1','1','1','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('19','管理員','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息','/reimbursement_information/table','','_blank','1','1','1','1','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data',null,'0','{"examine":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('20','管理員','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息詳情','/reimbursement_information/view','','_blank','1','1','1','1','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('21','管理員','收入信息','revenue_information','收入信息','/revenue_information/table','','_blank','1','1','1','1','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{"figure":true,"export_db":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('22','管理員','收入信息','revenue_information','收入信息詳情','/revenue_information/view','','_blank','1','1','1','1','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('23','管理員','支出信息','expenditure_information','支出信息','/expenditure_information/table','','_blank','1','1','1','1','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{"figure":true,"export_db":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('24','管理員','支出信息','expenditure_information','支出信息詳情','/expenditure_information/view','','_blank','1','1','1','1','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('25','管理員','員工工資','employee_salary','員工工資','/employee_salary/table','','_blank','1','1','1','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('26','管理員','員工工資','employee_salary','員工工資詳情','/employee_salary/view','','_blank','1','1','1','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('27','管理員','公告通知','announcement_notice','公告通知','/announcement_notice/table','','_blank','1','1','1','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('28','管理員','公告通知','announcement_notice','公告通知詳情','/announcement_notice/view','','_blank','1','1','1','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('29','管理員','文件信息','file_information','文件信息','/file_information/table','','_blank','1','1','1','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('30','管理員','文件信息','file_information','文件信息詳情','/file_information/view','','_blank','1','1','1','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('31','管理員','我的郵箱','my_email','我的郵箱','/my_email/table','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('32','管理員','我的郵箱','my_email','我的郵箱詳情','/my_email/view','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('33','管理員','我的工作','my_job','我的工作','/my_job/table','','_blank','1','1','1','1','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{"examine":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('34','管理員','我的工作','my_job','我的工作詳情','/my_job/view','','_blank','1','1','1','1','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('35','管理員','簽到打卡記錄','punch_in_record','簽到打卡記錄','/punch_in_record/table','','_blank','1','1','1','1','punch_in_number,clock_in_time,punch_in_type,check_in_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,check_in_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,check_in_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('36','管理員','簽到打卡記錄','punch_in_record','簽到打卡記錄詳情','/punch_in_record/view','','_blank','1','1','1','1','punch_in_number,clock_in_time,punch_in_type,check_in_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,check_in_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,check_in_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('37','管理員','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄','/sign_out_punch_in_record/table','','_blank','1','1','1','1','punch_in_number,clock_in_time,punch_in_type,sign_out_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,sign_out_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,sign_out_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('38','管理員','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄詳情','/sign_out_punch_in_record/view','','_blank','1','1','1','1','punch_in_number,clock_in_time,punch_in_type,sign_out_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,sign_out_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department','punch_in_number,clock_in_time,punch_in_type,sign_out_time,post_type,department_type,ordinary_staff,personnel_department,administrative_department,financial_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('39','管理員','評(píng)論','comment','評(píng)論列表','/comment/table','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('40','管理員','評(píng)論','comment','評(píng)論詳情','/comment/view','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('41','管理員','評(píng)論','comment','我的評(píng)論','/comment/list','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('42','管理員','評(píng)論','comment','評(píng)論詳情','/comment/details','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('43','普通員工','普通員工','ordinary_staff','普通員工','/ordinary_staff/table','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('44','普通員工','普通員工','ordinary_staff','普通員工詳情','/ordinary_staff/view','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('45','普通員工','人事部門(mén)','ministry_of_personnel','人事部門(mén)','/ministry_of_personnel/table','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('46','普通員工','人事部門(mén)','ministry_of_personnel','人事部門(mén)詳情','/ministry_of_personnel/view','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('47','普通員工','管理部門(mén)','administrative_department','管理部門(mén)','/administrative_department/table','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('48','普通員工','管理部門(mén)','administrative_department','管理部門(mén)詳情','/administrative_department/view','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('49','普通員工','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)','/financial_department/table','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('50','普通員工','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)詳情','/financial_department/view','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('51','普通員工','部門(mén)信息','department_information','部門(mén)信息','/department_information/table','','_blank','0','0','0','0','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('52','普通員工','部門(mén)信息','department_information','部門(mén)信息詳情','/department_information/view','','_blank','0','0','0','0','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('53','普通員工','崗位信息','position_information','崗位信息','/position_information/table','','_blank','0','0','0','0','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('54','普通員工','崗位信息','position_information','崗位信息詳情','/position_information/view','','_blank','0','0','0','0','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('55','普通員工','考勤打卡','clock_in','考勤打卡','/clock_in/table','','_blank','0','0','0','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('56','普通員工','考勤打卡','clock_in','考勤打卡詳情','/clock_in/view','','_blank','0','0','0','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('57','普通員工','請(qǐng)假管理','leave_management','請(qǐng)假管理','/leave_management/table','','_blank','1','1','1','1','ordinary_staff,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','ordinary_staff,reason_for_leave,,,leave_type,leave_no','ordinary_staff,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('58','普通員工','請(qǐng)假管理','leave_management','請(qǐng)假管理詳情','/leave_management/view','','_blank','1','1','1','1','ordinary_staff,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','ordinary_staff,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','ordinary_staff,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('59','普通員工','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)','/attendance_statistics/table','','_blank','0','0','0','0','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{"figure":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('60','普通員工','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)詳情','/attendance_statistics/view','','_blank','0','0','0','0','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('61','普通員工','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息','/reimbursement_information/table','','_blank','1','1','1','1','ordinary_staff,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','ordinary_staff,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','ordinary_staff,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('62','普通員工','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息詳情','/reimbursement_information/view','','_blank','1','1','1','1','ordinary_staff,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','ordinary_staff,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','ordinary_staff,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('63','普通員工','收入信息','revenue_information','收入信息','/revenue_information/table','','_blank','0','0','0','0','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{"figure":false,"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('64','普通員工','收入信息','revenue_information','收入信息詳情','/revenue_information/view','','_blank','0','0','0','0','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('65','普通員工','支出信息','expenditure_information','支出信息','/expenditure_information/table','','_blank','0','0','0','0','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{"figure":false,"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('66','普通員工','支出信息','expenditure_information','支出信息詳情','/expenditure_information/view','','_blank','0','0','0','0','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('67','普通員工','員工工資','employee_salary','員工工資','/employee_salary/table','','_blank','0','0','0','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('68','普通員工','員工工資','employee_salary','員工工資詳情','/employee_salary/view','','_blank','0','0','0','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('69','普通員工','公告通知','announcement_notice','公告通知','/announcement_notice/table','','_blank','0','0','0','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('70','普通員工','公告通知','announcement_notice','公告通知詳情','/announcement_notice/view','','_blank','0','0','0','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('71','普通員工','文件信息','file_information','文件信息','/file_information/table','','_blank','0','0','0','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('72','普通員工','文件信息','file_information','文件信息詳情','/file_information/view','','_blank','0','0','0','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('73','普通員工','我的郵箱','my_email','我的郵箱','/my_email/table','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('74','普通員工','我的郵箱','my_email','我的郵箱詳情','/my_email/view','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('75','普通員工','我的工作','my_job','我的工作','/my_job/table','','_blank','1','1','1','1','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('76','普通員工','我的工作','my_job','我的工作詳情','/my_job/view','','_blank','1','1','1','1','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('77','普通員工','簽到打卡記錄','punch_in_record','簽到打卡記錄','/punch_in_record/table','','_blank','1','1','1','1','ordinary_staff,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','ordinary_staff,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','ordinary_staff,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('78','普通員工','簽到打卡記錄','punch_in_record','簽到打卡記錄詳情','/punch_in_record/view','','_blank','1','1','1','1','ordinary_staff,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','ordinary_staff,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','ordinary_staff,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('79','普通員工','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄','/sign_out_punch_in_record/table','','_blank','1','1','1','1','punch_in_type,clock_in_time,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('80','普通員工','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄詳情','/sign_out_punch_in_record/view','','_blank','1','1','1','1','punch_in_type,clock_in_time,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('81','普通員工','評(píng)論','comment','評(píng)論列表','/comment/table','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('82','普通員工','評(píng)論','comment','評(píng)論詳情','/comment/view','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('83','普通員工','評(píng)論','comment','我的評(píng)論','/comment/list','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('84','普通員工','評(píng)論','comment','評(píng)論詳情','/comment/details','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('85','人事部門(mén)','普通員工','ordinary_staff','普通員工','/ordinary_staff/table','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('86','人事部門(mén)','普通員工','ordinary_staff','普通員工詳情','/ordinary_staff/view','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('87','人事部門(mén)','人事部門(mén)','ministry_of_personnel','人事部門(mén)','/ministry_of_personnel/table','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{"export_db":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('88','人事部門(mén)','人事部門(mén)','ministry_of_personnel','人事部門(mén)詳情','/ministry_of_personnel/view','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('89','人事部門(mén)','管理部門(mén)','administrative_department','管理部門(mén)','/administrative_department/table','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('90','人事部門(mén)','管理部門(mén)','administrative_department','管理部門(mén)詳情','/administrative_department/view','','_blank','1','1','1','1','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('91','人事部門(mén)','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)','/financial_department/table','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('92','人事部門(mén)','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)詳情','/financial_department/view','','_blank','1','1','1','1','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('93','人事部門(mén)','部門(mén)信息','department_information','部門(mén)信息','/department_information/table','','_blank','1','1','1','1','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('94','人事部門(mén)','部門(mén)信息','department_information','部門(mén)信息詳情','/department_information/view','','_blank','1','1','1','1','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('95','人事部門(mén)','崗位信息','position_information','崗位信息','/position_information/table','','_blank','1','1','1','1','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('96','人事部門(mén)','崗位信息','position_information','崗位信息詳情','/position_information/view','','_blank','1','1','1','1','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('97','人事部門(mén)','考勤打卡','clock_in','考勤打卡','/clock_in/table','','_blank','1','1','1','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('98','人事部門(mén)','考勤打卡','clock_in','考勤打卡詳情','/clock_in/view','','_blank','1','1','1','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('99','人事部門(mén)','請(qǐng)假管理','leave_management','請(qǐng)假管理','/leave_management/table','','_blank','1','1','1','1','personnel_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','personnel_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','personnel_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('100','人事部門(mén)','請(qǐng)假管理','leave_management','請(qǐng)假管理詳情','/leave_management/view','','_blank','1','1','1','1','personnel_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','personnel_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','personnel_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('101','人事部門(mén)','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)','/attendance_statistics/table','','_blank','1','1','1','1','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{"figure":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('102','人事部門(mén)','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)詳情','/attendance_statistics/view','','_blank','1','1','1','1','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('103','人事部門(mén)','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息','/reimbursement_information/table','','_blank','1','1','1','1','personnel_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','personnel_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','personnel_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('104','人事部門(mén)','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息詳情','/reimbursement_information/view','','_blank','1','1','1','1','personnel_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','personnel_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','personnel_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('105','人事部門(mén)','收入信息','revenue_information','收入信息','/revenue_information/table','','_blank','0','0','0','0','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{"figure":false,"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('106','人事部門(mén)','收入信息','revenue_information','收入信息詳情','/revenue_information/view','','_blank','0','0','0','0','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('107','人事部門(mén)','支出信息','expenditure_information','支出信息','/expenditure_information/table','','_blank','0','0','0','0','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{"figure":false,"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('108','人事部門(mén)','支出信息','expenditure_information','支出信息詳情','/expenditure_information/view','','_blank','0','0','0','0','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('109','人事部門(mén)','員工工資','employee_salary','員工工資','/employee_salary/table','','_blank','1','1','1','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('110','人事部門(mén)','員工工資','employee_salary','員工工資詳情','/employee_salary/view','','_blank','1','1','1','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('111','人事部門(mén)','公告通知','announcement_notice','公告通知','/announcement_notice/table','','_blank','0','0','0','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('112','人事部門(mén)','公告通知','announcement_notice','公告通知詳情','/announcement_notice/view','','_blank','0','0','0','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('113','人事部門(mén)','文件信息','file_information','文件信息','/file_information/table','','_blank','0','0','0','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('114','人事部門(mén)','文件信息','file_information','文件信息詳情','/file_information/view','','_blank','0','0','0','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('115','人事部門(mén)','我的郵箱','my_email','我的郵箱','/my_email/table','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('116','人事部門(mén)','我的郵箱','my_email','我的郵箱詳情','/my_email/view','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('117','人事部門(mén)','我的工作','my_job','我的工作','/my_job/table','','_blank','0','0','0','0','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('118','人事部門(mén)','我的工作','my_job','我的工作詳情','/my_job/view','','_blank','0','0','0','0','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('119','人事部門(mén)','簽到打卡記錄','punch_in_record','簽到打卡記錄','/punch_in_record/table','','_blank','1','1','1','1','personnel_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','personnel_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','personnel_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('120','人事部門(mén)','簽到打卡記錄','punch_in_record','簽到打卡記錄詳情','/punch_in_record/view','','_blank','1','1','1','1','personnel_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','personnel_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','personnel_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('121','人事部門(mén)','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄','/sign_out_punch_in_record/table','','_blank','1','1','1','1','punch_in_type,clock_in_time,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,personnel_department,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,personnel_department,department_type,post_type,sign_out_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('122','人事部門(mén)','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄詳情','/sign_out_punch_in_record/view','','_blank','1','1','1','1','punch_in_type,clock_in_time,personnel_department,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,personnel_department,department_type,post_type,sign_out_time,punch_in_number','punch_in_type,clock_in_time,personnel_department,department_type,post_type,sign_out_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('123','人事部門(mén)','評(píng)論','comment','評(píng)論列表','/comment/table','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('124','人事部門(mén)','評(píng)論','comment','評(píng)論詳情','/comment/view','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('125','人事部門(mén)','評(píng)論','comment','我的評(píng)論','/comment/list','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('126','人事部門(mén)','評(píng)論','comment','評(píng)論詳情','/comment/details','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('127','財(cái)務(wù)部門(mén)','普通員工','ordinary_staff','普通員工','/ordinary_staff/table','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('128','財(cái)務(wù)部門(mén)','普通員工','ordinary_staff','普通員工詳情','/ordinary_staff/view','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('129','財(cái)務(wù)部門(mén)','人事部門(mén)','ministry_of_personnel','人事部門(mén)','/ministry_of_personnel/table','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('130','財(cái)務(wù)部門(mén)','人事部門(mén)','ministry_of_personnel','人事部門(mén)詳情','/ministry_of_personnel/view','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('131','財(cái)務(wù)部門(mén)','管理部門(mén)','administrative_department','管理部門(mén)','/administrative_department/table','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('132','財(cái)務(wù)部門(mén)','管理部門(mén)','administrative_department','管理部門(mén)詳情','/administrative_department/view','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('133','財(cái)務(wù)部門(mén)','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)','/financial_department/table','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('134','財(cái)務(wù)部門(mén)','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)詳情','/financial_department/view','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('135','財(cái)務(wù)部門(mén)','部門(mén)信息','department_information','部門(mén)信息','/department_information/table','','_blank','0','0','0','0','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('136','財(cái)務(wù)部門(mén)','部門(mén)信息','department_information','部門(mén)信息詳情','/department_information/view','','_blank','0','0','0','0','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('137','財(cái)務(wù)部門(mén)','崗位信息','position_information','崗位信息','/position_information/table','','_blank','0','0','0','0','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('138','財(cái)務(wù)部門(mén)','崗位信息','position_information','崗位信息詳情','/position_information/view','','_blank','0','0','0','0','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('139','財(cái)務(wù)部門(mén)','考勤打卡','clock_in','考勤打卡','/clock_in/table','','_blank','0','0','0','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('140','財(cái)務(wù)部門(mén)','考勤打卡','clock_in','考勤打卡詳情','/clock_in/view','','_blank','0','0','0','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('141','財(cái)務(wù)部門(mén)','請(qǐng)假管理','leave_management','請(qǐng)假管理','/leave_management/table','','_blank','1','1','1','1','financial_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','financial_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','financial_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('142','財(cái)務(wù)部門(mén)','請(qǐng)假管理','leave_management','請(qǐng)假管理詳情','/leave_management/view','','_blank','1','1','1','1','financial_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','financial_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time','financial_department,reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('143','財(cái)務(wù)部門(mén)','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)','/attendance_statistics/table','','_blank','0','0','0','0','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{"figure":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('144','財(cái)務(wù)部門(mén)','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)詳情','/attendance_statistics/view','','_blank','0','0','0','0','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('145','財(cái)務(wù)部門(mén)','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息','/reimbursement_information/table','','_blank','1','1','1','1','financial_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','financial_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','financial_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('146','財(cái)務(wù)部門(mén)','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息詳情','/reimbursement_information/view','','_blank','1','1','1','1','financial_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','financial_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no','financial_department,reimbursement_data,reimbursement_time,reimbursement_amount,reimbursement_type,reimbursement_no',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('147','財(cái)務(wù)部門(mén)','收入信息','revenue_information','收入信息','/revenue_information/table','','_blank','1','1','1','1','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{"figure":true,"export_db":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('148','財(cái)務(wù)部門(mén)','收入信息','revenue_information','收入信息詳情','/revenue_information/view','','_blank','1','1','1','1','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('149','財(cái)務(wù)部門(mén)','支出信息','expenditure_information','支出信息','/expenditure_information/table','','_blank','1','1','1','1','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{"figure":true,"export_db":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('150','財(cái)務(wù)部門(mén)','支出信息','expenditure_information','支出信息詳情','/expenditure_information/view','','_blank','1','1','1','1','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('151','財(cái)務(wù)部門(mén)','員工工資','employee_salary','員工工資','/employee_salary/table','','_blank','0','0','0','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('152','財(cái)務(wù)部門(mén)','員工工資','employee_salary','員工工資詳情','/employee_salary/view','','_blank','0','0','0','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('153','財(cái)務(wù)部門(mén)','公告通知','announcement_notice','公告通知','/announcement_notice/table','','_blank','0','0','0','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('154','財(cái)務(wù)部門(mén)','公告通知','announcement_notice','公告通知詳情','/announcement_notice/view','','_blank','0','0','0','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('155','財(cái)務(wù)部門(mén)','文件信息','file_information','文件信息','/file_information/table','','_blank','0','0','0','0','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('156','財(cái)務(wù)部門(mén)','文件信息','file_information','文件信息詳情','/file_information/view','','_blank','0','0','0','0','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('157','財(cái)務(wù)部門(mén)','我的郵箱','my_email','我的郵箱','/my_email/table','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('158','財(cái)務(wù)部門(mén)','我的郵箱','my_email','我的郵箱詳情','/my_email/view','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('159','財(cái)務(wù)部門(mén)','我的工作','my_job','我的工作','/my_job/table','','_blank','0','0','0','0','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{"examine":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('160','財(cái)務(wù)部門(mén)','我的工作','my_job','我的工作詳情','/my_job/view','','_blank','0','0','0','0','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('161','財(cái)務(wù)部門(mén)','簽到打卡記錄','punch_in_record','簽到打卡記錄','/punch_in_record/table','','_blank','1','1','1','1','financial_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','financial_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','financial_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('162','財(cái)務(wù)部門(mén)','簽到打卡記錄','punch_in_record','簽到打卡記錄詳情','/punch_in_record/view','','_blank','1','1','1','1','financial_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','financial_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','financial_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('163','財(cái)務(wù)部門(mén)','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄','/sign_out_punch_in_record/table','','_blank','1','1','1','1','financial_department,personnel_department,ordinary_staff,department_type,post_type,sign_out_time,punch_in_number','financial_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number','financial_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('164','財(cái)務(wù)部門(mén)','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄詳情','/sign_out_punch_in_record/view','','_blank','1','1','1','1','financial_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number','financial_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number','financial_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number',null,'1','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('165','財(cái)務(wù)部門(mén)','評(píng)論','comment','評(píng)論列表','/comment/table','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('166','財(cái)務(wù)部門(mén)','評(píng)論','comment','評(píng)論詳情','/comment/view','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('167','財(cái)務(wù)部門(mén)','評(píng)論','comment','我的評(píng)論','/comment/list','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('168','財(cái)務(wù)部門(mén)','評(píng)論','comment','評(píng)論詳情','/comment/details','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('169','管理部門(mén)','普通員工','ordinary_staff','普通員工','/ordinary_staff/table','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('170','管理部門(mén)','普通員工','ordinary_staff','普通員工詳情','/ordinary_staff/view','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('171','管理部門(mén)','人事部門(mén)','ministry_of_personnel','人事部門(mén)','/ministry_of_personnel/table','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('172','管理部門(mén)','人事部門(mén)','ministry_of_personnel','人事部門(mén)詳情','/ministry_of_personnel/view','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('173','管理部門(mén)','管理部門(mén)','administrative_department','管理部門(mén)','/administrative_department/table','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('174','管理部門(mén)','管理部門(mén)','administrative_department','管理部門(mén)詳情','/administrative_department/view','','_blank','0','0','0','0','gender,post_type,department_type','gender,post_type,department_type','gender,post_type,department_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('175','管理部門(mén)','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)','/financial_department/table','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('176','管理部門(mén)','財(cái)務(wù)部門(mén)','financial_department','財(cái)務(wù)部門(mén)詳情','/financial_department/view','','_blank','0','0','0','0','gender,department_type,post_type','gender,department_type,post_type','gender,department_type,post_type',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('177','管理部門(mén)','部門(mén)信息','department_information','部門(mén)信息','/department_information/table','','_blank','0','0','0','1','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('178','管理部門(mén)','部門(mén)信息','department_information','部門(mén)信息詳情','/department_information/view','','_blank','0','0','0','1','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile','department_number,department_type,number_of_departments,department_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('179','管理部門(mén)','崗位信息','position_information','崗位信息','/position_information/table','','_blank','0','0','0','1','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('180','管理部門(mén)','崗位信息','position_information','崗位信息詳情','/position_information/view','','_blank','0','0','0','1','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile','job_no,post_type,number_of_posts,job_profile',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('181','管理部門(mén)','考勤打卡','clock_in','考勤打卡','/clock_in/table','','_blank','0','0','0','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('182','管理部門(mén)','考勤打卡','clock_in','考勤打卡詳情','/clock_in/view','','_blank','0','0','0','1',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',',punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('183','管理部門(mén)','請(qǐng)假管理','leave_management','請(qǐng)假管理','/leave_management/table','','_blank','0','0','0','1',',reason_for_leave,,,leave_type,leave_no,total_time,leave_end_time,leave_start_time,financial_department,personnel_department,ordinary_staff',',reason_for_leave,,,leave_type,leave_no,leave_end_time,leave_start_time,total_time,financial_department,personnel_department,ordinary_staff',',reason_for_leave,,,leave_type,leave_no,total_time,financial_department,personnel_department,ordinary_staff,leave_end_time,leave_start_time',null,'0','{"examine":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('184','管理部門(mén)','請(qǐng)假管理','leave_management','請(qǐng)假管理詳情','/leave_management/view','','_blank','0','0','0','1',',reason_for_leave,,,leave_type,leave_no,total_time,financial_department,personnel_department,ordinary_staff,leave_end_time,leave_start_time',',reason_for_leave,,,leave_type,leave_no',',reason_for_leave,,,leave_type,leave_no,total_time,financial_department,personnel_department,ordinary_staff,leave_end_time,leave_start_time',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('185','管理部門(mén)','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)','/attendance_statistics/table','','_blank','0','0','0','0','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{"figure":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('186','管理部門(mén)','考勤統(tǒng)計(jì)','attendance_statistics','考勤統(tǒng)計(jì)詳情','/attendance_statistics/view','','_blank','0','0','0','0','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department','statistical_number,statistical_type,number_of_people,time,personnel_department',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('187','管理部門(mén)','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息','/reimbursement_information/table','','_blank','0','0','0','1','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data',null,'0','{"examine":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('188','管理部門(mén)','報(bào)銷(xiāo)信息','reimbursement_information','報(bào)銷(xiāo)信息詳情','/reimbursement_information/view','','_blank','0','0','0','1','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data','reimbursement_no,reimbursement_type,reimbursement_amount,reimbursement_time,ordinary_staff,personnel_department,financial_department,reimbursement_data',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('189','管理部門(mén)','收入信息','revenue_information','收入信息','/revenue_information/table','','_blank','0','0','0','0','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{"figure":false,"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('190','管理部門(mén)','收入信息','revenue_information','收入信息詳情','/revenue_information/view','','_blank','0','0','0','0','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks','revenue_number,income_type,revenue_amount,income_time,handling_personnel,finance,revenue_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('191','管理部門(mén)','支出信息','expenditure_information','支出信息','/expenditure_information/table','','_blank','0','0','0','0','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{"figure":false,"export_db":false}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('192','管理部門(mén)','支出信息','expenditure_information','支出信息詳情','/expenditure_information/view','','_blank','0','0','0','0','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks','expenditure_number,expenditure_type,payment_slip,expenditure_time,expenditure_personnel,finance,expenditure_remarks',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('193','管理部門(mén)','員工工資','employee_salary','員工工資','/employee_salary/table','','_blank','0','0','0','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('194','管理部門(mén)','員工工資','employee_salary','員工工資詳情','/employee_salary/view','','_blank','0','0','0','1','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance','salary_number,ordinary_staff,personnel_department,financial_department,administrative_department,department_type,post_type,full_name,base_pay,deduction_fee,overtime_pay,total_amount,finance',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('195','管理部門(mén)','公告通知','announcement_notice','公告通知','/announcement_notice/table','','_blank','1','1','1','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('196','管理部門(mén)','公告通知','announcement_notice','公告通知詳情','/announcement_notice/view','','_blank','1','1','1','1','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content','announcement_no,announcement_type,announcement_title,publisher,announcement_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('197','管理部門(mén)','文件信息','file_information','文件信息','/file_information/table','','_blank','1','1','1','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('198','管理部門(mén)','文件信息','file_information','文件信息詳情','/file_information/view','','_blank','1','1','1','1','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content','document_number,file_type,document_title,enclosure,ordinary_staff,financial_department,personnel_department,sender,sending_time,document_content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('199','管理部門(mén)','我的郵箱','my_email','我的郵箱','/my_email/table','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('200','管理部門(mén)','我的郵箱','my_email','我的郵箱詳情','/my_email/view','','_blank','1','1','1','1','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content','mailbox_number,mailbox_type,mailbox_title,ordinary_staff,financial_department,administrative_department,personnel_department,content',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('201','管理部門(mén)','我的工作','my_job','我的工作','/my_job/table','','_blank','0','0','0','1','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{"examine":true}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('202','管理部門(mén)','我的工作','my_job','我的工作詳情','/my_job/view','','_blank','0','0','0','1','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow','job_number,type_of_work,job_title,ordinary_staff,job_content,workflow',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('203','管理部門(mén)','簽到打卡記錄','punch_in_record','簽到打卡記錄','/punch_in_record/table','','_blank','1','1','1','1','administrative_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','administrative_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','administrative_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('204','管理部門(mén)','簽到打卡記錄','punch_in_record','簽到打卡記錄詳情','/punch_in_record/view','','_blank','1','1','1','1','administrative_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','administrative_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number','administrative_department,department_type,check_in_time,post_type,punch_in_type,clock_in_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('205','管理部門(mén)','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄','/sign_out_punch_in_record/table','','_blank','1','1','1','1','administrative_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number','administrative_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number','administrative_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('206','管理部門(mén)','簽退打卡記錄','sign_out_punch_in_record','簽退打卡記錄詳情','/sign_out_punch_in_record/view','','_blank','1','1','1','1','administrative_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number','administrative_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number','administrative_department,punch_in_type,clock_in_time,department_type,post_type,sign_out_time,punch_in_number',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('207','管理部門(mén)','評(píng)論','comment','評(píng)論列表','/comment/table','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('208','管理部門(mén)','評(píng)論','comment','評(píng)論詳情','/comment/view','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('209','管理部門(mén)','評(píng)論','comment','我的評(píng)論','/comment/list','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `auth` values ('210','管理部門(mén)','評(píng)論','comment','評(píng)論詳情','/comment/details','','_blank','0','0','0','0','','','',null,'0','{}',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `user_group` values ('1','100','管理員',null,'','','0',null,"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `user_group` values ('2','100','游客',null,'','','0','0',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `user_group` values ('3','100','普通員工',null,'ordinary_staff','ordinary_staff_id','0','0',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `user_group` values ('4','100','人事部門(mén)',null,'ministry_of_personnel','ministry_of_personnel_id','0','0',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `user_group` values ('5','100','財(cái)務(wù)部門(mén)',null,'financial_department','financial_department_id','0','0',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");
insert into `user_group` values ('6','100','管理部門(mén)',null,'administrative_department','administrative_department_id','0','0',"2022-03-24 10:45:08.000 ","2022-03-24 10:45:08.000 ");

五.關(guān)鍵代碼

package com.controller;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.TokenEntity;
import com.entity.UserEntity;
import com.service.TokenService;
import com.service.UserService;
import com.utils.CommonUtil;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;

/**
 * 登錄相關(guān)
 */
@RequestMapping("users")
@RestController
public class UserController{
	
	@Autowired
	private UserService userService;
	
	@Autowired
	private TokenService tokenService;

	/**
	 * 登錄
	 */
	@IgnoreAuth
	@PostMapping(value = "/login")
	public R login(String username, String password, String captcha, HttpServletRequest request) {
		UserEntity user = userService.selectOne(new EntityWrapper<UserEntity>().eq("username", username));
		if(user==null || !user.getPassword().equals(password)) {
			return R.error("賬號(hào)或密碼不正確");
		}
		String token = tokenService.generateToken(user.getId(),username, "users", user.getRole());
		return R.ok().put("token", token);
	}
	
	/**
	 * 注冊(cè)
	 */
	@IgnoreAuth
	@PostMapping(value = "/register")
	public R register(@RequestBody UserEntity user){
//    	ValidatorUtils.validateEntity(user);
    	if(userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername())) !=null) {
    		return R.error("用戶已存在");
    	}
        userService.insert(user);
        return R.ok();
    }

	/**
	 * 退出
	 */
	@GetMapping(value = "logout")
	public R logout(HttpServletRequest request) {
		request.getSession().invalidate();
		return R.ok("退出成功");
	}
	
	/**
     * 密碼重置
     */
    @IgnoreAuth
	@RequestMapping(value = "/resetPass")
    public R resetPass(String username, HttpServletRequest request){
    	UserEntity user = userService.selectOne(new EntityWrapper<UserEntity>().eq("username", username));
    	if(user==null) {
    		return R.error("賬號(hào)不存在");
    	}
    	user.setPassword("123456");
        userService.update(user,null);
        return R.ok("密碼已重置為：123456");
    }
	
	/**
     * 列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,UserEntity user){
        EntityWrapper<UserEntity> ew = new EntityWrapper<UserEntity>();
    	PageUtils page = userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/list")
    public R list( UserEntity user){
       	EntityWrapper<UserEntity> ew = new EntityWrapper<UserEntity>();
      	ew.allEq(MPUtil.allEQMapPre( user, "user")); 
        return R.ok().put("data", userService.selectListView(ew));
    }

    /**
     * 信息
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") String id){
        UserEntity user = userService.selectById(id);
        return R.ok().put("data", user);
    }
    
    /**
     * 獲取用戶的session用戶信息
     */
    @RequestMapping("/session")
    public R getCurrUser(HttpServletRequest request){
    	Long id = (Long)request.getSession().getAttribute("userId");
        UserEntity user = userService.selectById(id);
        return R.ok().put("data", user);
    }

    /**
     * 保存
     */
    @PostMapping("/save")
    public R save(@RequestBody UserEntity user){
//    	ValidatorUtils.validateEntity(user);
    	if(userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername())) !=null) {
    		return R.error("用戶已存在");
    	}
        userService.insert(user);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody UserEntity user){
//        ValidatorUtils.validateEntity(user);
    	UserEntity u = userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername()));
    	if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {
    		return R.error("用戶名已存在。");
    	}
        userService.updateById(user);//全部更新
        return R.ok();
    }

    /**
     * 刪除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        userService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
}

六.論文目錄參考

七.源碼獲取

感謝大家的閱讀，如有不懂的問(wèn)題可以評(píng)論區(qū)交流或私聊！

喜歡文章可以點(diǎn)贊、收藏、關(guān)注、評(píng)論啦

獲取源碼請(qǐng)私信文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-765860.html

到了這里，關(guān)于計(jì)算機(jī)畢業(yè)設(shè)計(jì) 智慧養(yǎng)老中心管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) Java實(shí)戰(zhàn)項(xiàng)目 附源碼+文檔+視頻講解的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！