---
# System prepended metadata

title: R360 2019年年底前預計要完成的部分

---

# R360 2019年年底前預計要完成的部分
### Data fabric
- [x] 實作AWS SIT(QAS) data fabric and DB環境 (pic: Terry, Peter)
- [x] 測通MPS2 allocated member
- [ ] 介接MPS2 Demand table, 需要的欄位有Project_Code, MP_Provider, Role (pic: Irene, MPS2負責人:Lily Shao, NIFI負責人:Jerry YJ Chen)
```
Lily team 2020一月才開工
```
- [x] Member list要顯示Site欄位(窗口: Edison Liu) (v)來自HCM
- [ ] 介接廠區人員清單，因為Member list要顯示工廠的成員(來自於NPI系統)
```
2019/12/17 update: 由Terry追蹤
```
- [ ] 介接HCM(人資資料) (pic:Irene, NIFI負責人:Jerry YJ Chen)
```
2019/12/13 update: 缺分機欄位
```
- [x] 調整Dev環境的架構(VPC, public and private subnet)
- [x] PLM要增加update_time欄位 (tracking Allen, 提ITSM單)
- [x] PTS role要加action和update_time欄位 (還沒上code)
- [ ] 與MIS對測回傳機制，需討論是否要做site to site VPN (有和Jerry對測, nifi get S3 object)
- [ ] 測site to client VPN (Jerry, David DW Lin)
- [ ] PLM project data initial
- [x] PLM project member data initial
```
2019/12/16 update: Irene確認已initial, 且資料驗證無誤
```
- [ ] PTS allocated member data initial (Josh)
```
2019/12/16 update: 
```
- [x] PTS role data initial (Josh)
```
2019/12/16 update: Josh確認已initial
```
- [ ] 介接財務系統Business ORG(BG資料的來源。若來不及，就要去複製WiNerve PRD上的Project)
```
2019/12/17 update: Irene已收到同意信
```
- [ ] 整理Project裡重複的Product Type

### Backend
- [x] Swagger文件補齊,本來寫在 wiki 改寫到 swagger (Project_API and Member_API)
- [x] CICD
- [ ] 訂定member list上傳格式
- [ ] ~~訂定schedule上傳格式~~
- [ ] 修改 project member , project schedule 要能發出通知 , 已有SysNotificationController但沒insert data以及trigger時機點
- [x] [Team Member List][Member List][API]下載當天的Member excel (pic: Irene)
- [x] [Team Member List]上傳檔案 (pic: Irene)
- [x] Survey S3是否有目錄的概念
- [ ] Member list mail group建立 (<span style='color: blue'>暫時不做</span>)

### Frontend
- [ ] Dash board長相要跟WiNerve project list一致
- [ ] Task & Deliverable系統分析和設計(DB & API)
- [ ] Profile系統分析和設計
- [ ] 與Mandy Yu談串接方式(Layout report)
- [ ] Schedule甘特圖要更好操作
- [ ] 與Alice實作demo site




