# 專案事項
- User 用戶
- [ ] 資料庫表格規劃 1天
- userId, username, password, email, refreshToken
- [x] API
- [x] signUp
- [x] Delete
- [x] Get
- [x] Update
- [x] PostMan 規格撰寫
- [x] 連接資料庫
- [ ] 用戶密碼加鹽 1天
- Administrator 管理員
- [ ] 資料庫表格規劃 1天
- adminId, adminname, password, email, refreshToken
- [ ] API 含PostMan共1天
- [ ] 防呆,防止管理員幹掉自己/以及保證至少一個激活中的管理員帳號
- [ ] Create
- [ ] Delete
- [ ] Get
- [ ] Update
- [ ] PostMan 規格撰寫
- Database 資料庫
- [x] 完成TypeOrm的sqlite設定
- Auth 認證/Permissions 權限
- 用戶組
- User
- Admin
- [ ] 權限系統模組實現 3天
- [ ] 權限表格 1天檢查
- [ ] Product權限細節
- [ ] Order權限細節
- [x] 學會怎麼使用並產生JWT token
- [x] API
- [x] SignIn
- [x] Logout
- [x] RefreshToken
- [x] AuthGuard實現
- [ ] 驗證後權限訊息傳遞 3天
- Product 產品
- [x] 資料庫表格規劃
- productId, price, stock, thumbnail, title, description, categories
- [ ] API
- [x] Create
- [x] Delete
- [ ] Get 1天
- [x] 全部查詢
- [ ] 分類查詢
- [x] Update
- [ ] Put 1天
- [ ] 更改價錢
- [ ] 更改庫存
- [x] PostMan 規格撰寫
- [x] 權限規劃
- User
- get
- Admin
- get,delete,create,update,put
- Order 訂單
- [ ] 資料庫表格規劃 含購物車Dto 2天
- [ ] 購物車Dto規劃
- [ ] 儲存當下Product狀態的實現 3天
- [ ] API
- [ ] Create 3天
- [ ] 生成訂單
- [ ] 規劃訂單相關參數由系統代為生成訂單原始資料
- [ ] 接收購物車資料並保證相關參數符合商品資訊
- [ ] Delete 含Get1天
- [ ] Get
- [ ] 全部查詢
- [ ] 用戶訂單查詢
- [ ] 訂單時間查詢
- [ ] Put 1天
- [ ] 更改狀態[Admin]
- [ ] 退貨/取消訂單[User]
- [ ] PostMan 規格撰寫 1天
- [ ] 權限規劃
- User
- Admin
- Announcement 公告
- [ ] 資料庫表格規劃 1天
- [ ] API CRUD含PostMan1天
- [ ] Create
- [ ] Delete
- [ ] Get
- [ ] 全部查詢
- [ ] 時間查詢
- [ ] Update
- [ ] PostMan 規格撰寫
- [x] 權限規劃
- User
- get
- Admin
- get,delete,create,update
共26天
```mermaid
gantt
dateFormat YYYY-MM-DD
axisFormat %m-%d
title 時間表
excludes weekends
section 實現
User用戶 :2024-01-09, 2d
Admin :2d
Auth :7d
Product :2d
Order : 11d
Announcement :2d
```

https://github.com/popo70023/learn-react-app
https://hackmd.io/@johnsonnote/learning_bigdata
https://hackmd.io/@johnsonnote/learning_ai