# 後端工作清單
- 負責人：張智聖、黃翊誠
- 候補工作人員：周芳妤
## 連結
- [程式組會議0415](/dErnqIKZRfac40uFzzjojw)
- [Laravel專案使用說明書](/W6HQDT4CRoONYaOJs1RjDQ)
- [架構](/@Futureway/Structure)
- [懶人包](/BgyPJ2fPT2uxqxLZsapIxQ)
- [神秘講義](https://reurl.cc/q58ynN)
- [講解連結](https://www.bilibili.com/video/BV1gE411j78F?spm_id_from=333.337.search-card.all.click)
- [github指令集](https://ithelp.ithome.com.tw/articles/10241407)
- [如果想要系辦電腦請參考](https://stackoverflow.com/questions/26208848/xampp-installation-on-win-8-1-with-uac-warning)
## 架構設計
* PHP版本：
* Laravel版本：
### 介紹
* id -> PK, A.I,bigIncrements
* level -> unsignedTinyInteger(0~255)
- Integer(-128~128)
* (前置詞)name -> VARCHAR(255) NOT NULL
* content -> TEXT NULL
* creator -> Foriegn_Key(FK)
* Create timesteamp -> DEFAULT CURRENNT-TIME
* Update-TS->
### 架構
1. course:id,course name,info,CTS, UTS,
2. unit: id, unit name, creator, corse id -> FK, CTS, UTS
3. part: id, name, info, creator, unit id -> FK, content, video_id, video_platform, CTS, UTS
4. note: id, content, user id -> FK, part id -> FK, CTS, UTS
### 新版架構(整理中)
1. course：id,level,order,course name,parent id -> FK,video id,part content,visible,CTS, UTS
2. permission：id,course id -> FK,permission type,permission `f?` id -> FK
3. note：id,note content,user id -> FK,course id -> FK
---
### 課程/單元
| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值 |
| -------- | -------- | -------- | ---- | -------- |
| 課程ID | coid | integer | | PK, A_I |
| 階層 | level | integer | | 0 |
| 順序 | order | integer | | |
| 課程名稱 | coname | string | 255 | |
| 上層ID | pid | integer | | NULL、FK |
| 文本內容 | content | text | | NULL |
| 課程介紹 | cointro | text | | NULL |
| 可見性 | visible | string | 255 | 1 |
* 子單元 影片時間
### 單元
| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值 |
| -------- | -------- | -------- | ---- | -------- |
| 單元ID | unid | integer | | PK, A_I |
| 階層 | level | integer | | 0 |
| 順序 | order | integer | | |
| 單元名稱 | unname | string | 255 | |
| 上層ID | pid | integer | | NULL、FK |
| 影片ID | vid | string | 255 | NULL |
| 文本內容 | uncontent| text | | NULL |
| 單元介紹 | unintro | text | | NULL |
| 可見性 | visible | string | 255 | 1 |
### 權限
| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值 |
| -------- | -------- | -------- | ---- | ------ |
| 權限ID | prid | integer | | PK, A_I |
| 課程ID | coid | integer | | FK |
| 權限類型 | prtype | string | 1 | s:學生 c:班級 |
| 開放ID | prfid | string | 255 | FK |
* 開放ID：被開放權限的那個人或班級的
### 筆記
| 欄位用途 | 欄位名稱 | 資料型別 | 長度 | 預設值 |
| -------- | -------- | -------- | ---- | ------ |
| 筆記ID | noid | integer | | PK |
| 筆記內容 | nocontent| text | | NULL |
| 使用者ID | userid | string | 255 | FK |
| 課程ID | coid | integer | | FK |
### reply
---
## 功能筆記
## 練習
```
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<!-- CSS only -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-0evHe/X+R7YkIZDRvuzKMRqM+OrBnVFBL6DOitfPri4tjfHxaWutUpFmBp4vmVor" crossorigin="anonymous">
</head>
<body>
<section>
<div class="container">
<div class="row">
<nav class="navbar navbar-expand-lg bg-light d-flex ">
<div class="col-lg-4">
</div>
<div class="col-lg-8">
<div class="container-fluid justify-content-end">
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup"
aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse justify-content-center" id="navbarNavAltMarkup">
<div class="navbar-nav fs-4 fw-bold">
<a class="nav-link active" aria-current="page" href="#">首頁</a>
<a class="nav-link" href="#">計畫全貌</a>
<a class="nav-link" href="#">最新消息</a>
<a class="nav-link" href="#">歷年成果</a>
<a class="nav-link" href="#">關於我們</a>
<a class="nav-link" href="#">常見問題</a>
<a class="nav-link" href="#">相關連結</a>
</div>
</div>
</div>
</div>
</nav>
</div>
</div>
</section>
</body>
<!-- JavaScript Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/js/bootstrap.bundle.min.js"
integrity="sha384-pprn3073KE6tl6bjs2QrFaJGz5/SUsLqktiwsUTF55Jfv3qYSDhgCecCxMW52nD2"
crossorigin="anonymous"></script>
</html>
```
[假圖](https://picsum.photos/)
```
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<!-- CSS only -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet"
integrity="sha384-0evHe/X+R7YkIZDRvuzKMRqM+OrBnVFBL6DOitfPri4tjfHxaWutUpFmBp4vmVor" crossorigin="anonymous">
</head>
<body>
<!-- header section -->
<section>
<div class="container">
<div class="row">
<nav class="navbar navbar-expand-lg bg-light d-flex ">
<div class="col-lg-4">
</div>
<div class="col-lg-8">
<div class="container-fluid justify-content-end">
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup"
aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse justify-content-center" id="navbarNavAltMarkup">
<div class="navbar-nav fs-4 fw-bold">
<a class="nav-link active" aria-current="page" href="#">首頁</a>
<a class="nav-link" href="#">計畫全貌</a>
<a class="nav-link" href="#">最新消息</a>
<a class="nav-link" href="#">歷年成果</a>
<a class="nav-link" href="#">關於我們</a>
<a class="nav-link" href="#">常見問題</a>
<a class="nav-link" href="#">相關連結</a>
</div>
</div>
</div>
</div>
</nav>
</div>
</div>
</section>
<!-- content section -->
<section>
<div class="container">
<div class="row">
<div id="carouselExampleIndicators col-12" class="carousel slide" data-bs-ride="carousel">
<div class="carousel-indicators">
<button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="0" class="active"
aria-current="true" aria-label="Slide 1"></button>
<button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="1"
aria-label="Slide 2"></button>
<button type="button" data-bs-target="#carouselExampleIndicators" data-bs-slide-to="2"
aria-label="Slide 3"></button>
</div>
<div class="carousel-inner">
<div class="carousel-item active">
<img src="https://picsum.photos/210/40" class="d-block w-100" alt="...">
</div>
<div class="carousel-item">
<img src="https://picsum.photos/210/40" class="d-block w-100" alt="...">
</div>
<div class="carousel-item">
<img src="https://picsum.photos/210/40" class="d-block w-100" alt="...">
</div>
</div>
<button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleIndicators"
data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#carouselExampleIndicators"
data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>
<div class="pt-5 d-flex">
<div class="row">
<div class="col-md col-6">
<ul>
<li></li>
<ol></ol>
<ol></ol>
<ol></ol>
</ul>
</div>
<div class="col-md col-6">
<ul>
<li></li>
<ol></ol>
<ol></ol>
<ol></ol>
</ul>
</div>
<div class="col-md col-6">
<ul>
<li></li>
<ol></ol>
<ol></ol>
<ol></ol>
</ul>
</div>
<div class="col-md col-6">
<ul>
<li></li>
<ol></ol>
<ol></ol>
<ol></ol>
</ul>
</div>
</div>
</div>
</div>
</section>
</body>
<!-- JavaScript Bundle with Popper -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.0-beta1/dist/js/bootstrap.bundle.min.js"
integrity="sha384-pprn3073KE6tl6bjs2QrFaJGz5/SUsLqktiwsUTF55Jfv3qYSDhgCecCxMW52nD2"
crossorigin="anonymous"></script>
</html>
```
【10/04(二)-創新課程成果展活動行前通知】
活動時間:上午8:00-10:00
活動地點:五權國小3F視聽教室
集合時間:上午7:15(最晚7:30)
—————————
活動注意事項:
1. 請夥伴們穿著「藍色」團服
2. 因應疫情請各位自行攜帶口罩，如出隊當天有發燒症狀，請於早上7點前於群組回報!
3.具體的分工會在當天進行指派
—————————
須攜帶物品:
1.口罩
2.個人藥物
備註:
1.如有幫忙購買老師指定用品時，請報統編【76000424】
—————————
請各位夥伴看完出隊公告後回覆收到，如果有無法出席教學活動的夥伴請事前告知，謝謝
Sign in with Wallet
Connect another wallet