功能介绍
管理员;首页,个人中心,部门管理,员工管理,员工考勤管理,员工请假管理,部门调动管理,出差申请管理,员工工资管理,系统管理等
小程序:首页、我的(员工考勤,员工请假,部门调动,出差申请,员工工资等)等
数据库脚本
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: springboot1h3t5
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `springboot1h3t5`
--
/*!40000 DROP DATABASE IF EXISTS `springboot1h3t5`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboot1h3t5` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `springboot1h3t5`;
--
-- Table structure for table `bumen`
--
DROP TABLE IF EXISTS `bumen`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bumen` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`bumen` VARCHAR(200) DEFAULT NULL COMMENT '部门',
PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='部门';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bumen`
--
LOCK TABLES `bumen` WRITE;
/*!40000 ALTER TABLE `bumen` DISABLE KEYS */;
INSERT INTO `bumen` VALUES (11,'2022-04-18 07:01:02','生产部门'),(12,'2022-04-18 07:01:02','部门2'),(13,'2022-04-18 07:01:02','部门3'),(14,'2022-04-18 07:01:02','部门4'),(15,'2022-04-18 07:01:02','部门5'),(16,'2022-04-18 07:01:02','部门6');
/*!40000 ALTER TABLE `bumen` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bumendiaodong`
--
DROP TABLE IF EXISTS `bumendiaodong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bumendiaodong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yuangongzhanghao` varchar(200) DEFAULT NULL COMMENT '员工账号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`bumen` varchar(200) DEFAULT NULL COMMENT '部门',
`shenqingbumen` varchar(200) DEFAULT NULL COMMENT '申请部门',
`shenqingyuanyin` longtext COMMENT '申请原因',
`shenqingshijian` datetime DEFAULT NULL COMMENT '申请时间',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='部门调动';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bumendiaodong`
--
LOCK TABLES `bumendiaodong` WRITE;
/*!40000 ALTER TABLE `bumendiaodong` DISABLE KEYS */;
INSERT INTO `bumendiaodong` VALUES (51,'2022-04-18 07:01:02','员工账号1','员工姓名1','upload/bumendiaodong_touxiang1.jpg','部门1','申请部门1','申请原因1','2022-04-18 15:01:02','是','',1),(52,'2022-04-18 07:01:02','员工账号2','员工姓名2','upload/bumendiaodong_touxiang2.jpg','部门2','申请部门2','申请原因2','2022-04-18 15:01:02','是','',2),(53,'2022-04-18 07:01:02','员工账号3','员工姓名3','upload/bumendiaodong_touxiang3.jpg','部门3','申请部门3','申请原因3','2022-04-18 15:01:02','是','',3),(54,'2022-04-18 07:01:02','员工账号4','员工姓名4','upload/bumendiaodong_touxiang4.jpg','部门4','申请部门4','申请原因4','2022-04-18 15:01:02','是','',4),(55,'2022-04-18 07:01:02','员工账号5','员工姓名5','upload/bumendiaodong_touxiang5.jpg','部门5','申请部门5','申请原因5','2022-04-18 15:01:02','是','',5),(56,'2022-04-18 07:01:02','员工账号6','员工姓名6','upload/bumendiaodong_touxiang6.jpg','部门6','申请部门6','申请原因6','2022-04-18 15:01:02','是','',6);
/*!40000 ALTER TABLE `bumendiaodong` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chuchashenqing`
--
DROP TABLE IF EXISTS `chuchashenqing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuchashenqing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yuangongzhanghao` varchar(200) DEFAULT NULL COMMENT '员工账号',
`yuangongxingming` varchar(200) DEFAULT NULL COMMENT '员工姓名',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`bumen` varchar(200) DEFAULT NULL COMMENT '部门',
`chuchariqi` date DEFAULT NULL COMMENT '出差日期',
`chuchatianshu` varchar(200) DEFAULT NULL COMMENT '出差天数'