# 專案事項 - 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