# zhiy_buzao_leave-the-school-system

**Repository Path**: ivuex/zhiy_buzao_leave-the-school-system

## Basic Information

- **Project Name**: zhiy_buzao_leave-the-school-system
- **Description**: 学校请假系统。wechat miniprogram frontend + python backend 。
- **Primary Language**: JavaScript
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-02-11
- **Last Updated**: 2021-06-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

<p align="center">
  <a href="https://github.com/joey66666/Leava">
    <img src="https://github.com/joey66666/Leava/blob/master/docs/logo/Leava.png"  width="152">
  </a>
  <h1 align="center">Leava</h1>
  <p align="center">
    <a href="https://github.com/joey66666/Leava/blob/master/LICENSE_cn"><img src="https://img.shields.io/badge/%E8%AE%B8%E5%8F%AF%E8%AF%81-%E5%8F%8D996-red.svg?style=popout-square"></a>
    <a href="https://github.com/joey66666/Leava/blob/master/README_en.md"><img src="https://img.shields.io/badge/doc-English-blue.svg?style=popout-square"></a>
    <a href="http://hits.dwyl.io/joey66666/Leava" alt="hit count"><img src="http://hits.dwyl.io/joey66666/Leava.svg" /></a> 
  </p>
  <p align="center">
    基于Flask + MySQL的在线请假微信小程序<br>
  </p>
</p>

[English Version](https://github.com/joey66666/Leava/blob/master/README_en.md)

### 👋🏻仓库路径声明

- [Images&UI](https://github.com/joey66666/Leava/tree/master/Images%26UI/UI%E5%9B%BEpng) 为UI图

- [frontend](https://github.com/joey66666/Leava/tree/master/frontend) 为微信小程序源代码

- [backend](https://github.com/joey66666/Leava/tree/master/backend) 为后端源代码

- [docs](https://github.com/joey66666/Leava/tree/master/docs) 为数据库设计文档，调试记录，流程图和真机调试截图

### 💡如何启动

[搭建指南](https://github.com/joey66666/Leava/issues/10)

任何问题请在[Discussions](https://github.com/joey66666/Leava/discussions)中提问


1. 建立数据库
   
    MySQL design

    > Three tables

    |  Name   |    explanation    |
    | :-----: | :--------: |
    | student | student information |
    | teacher | teacher information |
    |  leave  |   leave history   |

    > Table - student

    |       name        |   explanation   | type-length |
    | :---------------: | :------: | :-----------: |
    | student_id(pri key) | id |  decimal-65   |
    |       name        | name |  varchar-255  |
    |      s_class      | class |  varchar-255  |
    |      passwd       | password |  varchar-255  |
    |       room        | dormitory |  varchar-255  |

    > Table - teacher

    |       name        |               explanation               | type-length |
    | :---------------: | :------------------------------: | :-----------: |
    | teacher_id(pri key) |             id             |  decimal-65   |
    |       name        |             name             |  varchar-255  |
    |      passwd       |             password             |  varchar-255  |
    |       role        | 0 is staff, 1 is faculty |     int-2     |

    > Table - leave

    |       name        |               explanation               | type-length |
    | :--------------: | :-----------------------------------------: | :-----------: |
    | leave_num(pri key) |                  unique index                   |  decimal-65   |
    |    student_id    |     reference on student(student_id)      |  decimal-65   |
    |    start_time    |                start time                 |  datetime-0   |
    |     end_time     |                end time                 |  datetime-0   |
    |      reason      |                  reason                   |  varchar-255  |
    |       flag       | status (0 is decline, 1 is waiting, 2 is approved) |     int-2     |
    |       type       |       type（1 is absence, 2 is sickness,3 is others）       |  int-2   |
    |   teacher1_id    |                 stuff's id                  |  decimal-65   |
    |   teacher2_id    |                faculty's id                 |     decimal-26     |
    |      ensure      |             route of picture              |  varchar-255  |

2. 安装依赖

- [flask](https://github.com/pallets/flask)

- [sqlalchemy](https://github.com/zzzeek/sqlalchemy)

- [flask_sqlalchemy](https://github.com/pallets/flask-sqlalchemy)

- [werkzeug.security](https://github.com/pallets/werkzeug)

## 启动后端服务

**在RESTful_backend.py 32和368行配置数据库**

```python 
python RESTful_backend.py
```

API

| URL                          | explanation                                                         |
| ---------------------------- | ------------------------------------------------------------ |
| /login                       | post ('userId', 'userPwd'); return (flag etc) |
| /student/ask_leave           | post ('leave_num','student_id','start_time','end_time','reason','flag','teacher1_id','teacher2_id','type','ensure'); return (True \ False)                                   |
| /student/search_leave        | post ('student_id'), return ('leave_num','student_id','start_time','end_time','reason','flag','teacher1_id','teacher2_id','type','ensure') |
| /student/search_leave_detail | post('student_id'), return ('student_id','class','name','room') |
| /teacher/search_leave        | post('teacher_id'), return('leave_num','student_id','start_time','end_time','reason','flag','teacher1_id','teacher2_id','type','ensure') |
| /teacher/update_leave        | post('leave_num','flag'); return (True / False)      |
| /teacher2/search_leave       | post('teacher_id'), return ('leave_num','student_id','start_time','end_time','reason','flag','teacher1_id','teacher2_id','type','ensure') |
| /teacher/search_id           | post('school'), return ('teacher_id','name','role')                       |
| /pwd                  | post('userId','userPwd') return (True / False)                         |
| /name                 | post('name'), return ('leave_num','student_id','start_time','end_time','reason','flag','teacher1_id','teacher2_id','type','ensure','class','school','room') |


### 🗣用户需求：

- 学生提交请假请求，查看自己的请假详情和请假是否被批准等情况

- 辅导员管理学生的请假请求，查看学生请假记录

- 任课老师接查看学生的请假请求和是否被批准情况

### 👥用户身份

1. 学生，用户名为学号， 长度9位
2. 辅导员，用户名为工号， 长度6位
3. 任课教师，用户名为工号， 长度6位

### 🛠技术栈

前端：微信小程序

后端：Flask+微信云开发（上传图片功能使用云开发，其他功能使用Flask）

数据库：MySQL

### 🖇功能流程

![功能流程](https://github.com/joey66666/Leava/blob/master/docs/%E8%AF%B7%E5%81%87%E7%B3%BB%E7%BB%9F%E6%B5%81%E7%A8%8B%E5%8A%9F%E8%83%BD%E5%9B%BE.jpg)

### 🔩架构设计

![ 架构设计](https://github.com/joey66666/Leava/blob/master/docs/%E8%AF%B7%E5%81%87%E7%B3%BB%E7%BB%9F%E6%9E%B6%E6%9E%84%E8%AE%BE%E8%AE%A1.jpg)

### 📸最终效果

![demo](https://github.com/joey66666/Leava/blob/master/docs/final_demo.jpg)

[More screen shots](https://github.com/joey66666/Leava/tree/master/docs/screenshot)


### 👍🏻致谢

[Fuhaixu](https://github.com/Fuhaixu)、ZYN、[xuyongxiang](https://github.com/xuyongxiang134)