---
# System prepended metadata

title: Untitled

---

# 專案事項
- 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
```
![image](https://hackmd.io/_uploads/ryjWMQtdT.png)
https://github.com/popo70023/learn-react-app

https://hackmd.io/@johnsonnote/learning_bigdata
https://hackmd.io/@johnsonnote/learning_ai