# FYP

- Good day learning center by PHP and Mysql
- 28-Mar-2023, 1-Jun-2023
- https://github.com/lahirudanushka/School-Management-System---PHP-MySQL
- http://schoolms.gearhostpreview.com/

### 網站名: Good day learning center by PHP and Mysql

## 時間:

- 4 月 21 完成紅字既part (milestone 1)
- 6 月 1 完成埋剩餘既部分 (milestone 2)

## Roles of users and the functions

### Administrator

- 4月21

  - Update, Add, Delete Subject (4月21)
  - Update, Add, Delete Schedule (4月21)
  - Update, Add, Delete Class room (4月21)
  - Update, Add, Delete Student (4月21)
  - Update, Add, Delete Teacher (4月21)
  - Update, Add, Delete User (4月21)

- 6月1號

  - Update, Add, Delete Attendance

  - Update, Add, Delete Exam

  - Update, Add, Delete Exam result

  - Update, Add Payment info

  - Print payment receipt

  - Update, Add, Delete Student

    - 加多個subject既欄位, 比student揀反subject喺自己profile度.

  - Update, Add, Delete Teacher

    - 加多個subject既欄位, 比老師揀反subject喺自己profile度.

  - Update Add, Delete Schedule

    - schedule 想有subject name, teacher name, classroom, day, start time and end time.

  - Update, Add, Delete Class room

    - classroom table list想show埋class room既location

### Teacher:

- 4月21

  - Update , Add Student (4月21)
  - Update Teacher (4月21)
  - Update Subject (4月21)
  - Update Add, Delete Schedule (4月21)
  - View class room (4月21)

- 6月1號

  - Update Add, Delete Attendance

    1. list schedules ?
    2. user click schedule to update
    3. tick student
    4. click update

  - Update, Add, Delete Exam

  - Add Exam result

  - Send Notice to student and Administrator

  - Update , Add Student

    - 可以update student既class room, (classroom 跟 subject)
    - -> update student既subject

  - Update Teacher

    - 加多個subject既欄位, 比老師揀反subject喺自己profile度.

  - Update Add, Delete Schedule

    - schedule 想有
      - subject name,
      - teacher name,
      - classroom,
      - day,
      - start time and
      - end time.

  - View class room

    - classroom table list想show埋class room既location

### Student:

- 4月21

  - View Schedule (4月21)

- 6月1號

  - View Notice
  - View Exam Results
    - http://localhost:3000/showStudentExamResults

### Login system:

- Registeration (註冊賬號)

- forgot password (忘記密碼)

- 如果打錯賬號密碼會有 error prompt 出來

  - User申請完成之後用反自己account登入系統.

  - 每個user都有自己獨立的account.

## UI:

- 簡潔就可

## DOCS:

- Project Proposal
- Initial Report~
- prototype Demo - 1st version
- 之後六月再做好另外果一半既網站,
  - 先交document and user guide
- 當save或者edit完一個item既時候,
  - 喺畫面上面show save successfully or failed.

## schema:

- show tables used
  - e.g. `2023_03_29_171749_create_notice_student_rel.php`