Notificaion

DB Schema

• group_list

• send_list

[{firstName: "test1", lastName: "ccc", sendTarget: "[email protected]"}, 
{firstName: "test1", lastName: "ccc", sendTarget: "[email protected]"}]

• config example (smtp)

{
"host":"smtp.gmail.com",
"port":465,
"secure":true,
"user":"[email protected]",
"pass":"1qaz@WSX3edc"
"FromMailAddr":"SCADA Notification <[email protected]>",
"subject": "test"
}

• password加解密

  • | crypto-js https://github.com/brix/crypto-js | | :--- |

dbmanager

• dao function

  • create notify

  • get notify

  • update notify

  • delete notify

  • create smtp_config

  • get smtp_config

  • update smtp_config

  • delete smtpconfig

API

• POST /Group - 建立Group
  • type是email(1)的話就要填config裡相關欄位, line(2)/wechat(3)就不用帶config
  • sendTarget依照type帶不同的值, 像是email addr/ token...

// request body
{
  "name": "string(128)",
  "description": "string(256)",
  "type": number(1|2|3),
  "config": {
    "host": "string(256)",
    "port": 0,
    "secure": true,
    "username": "string(128)",
    "password": "string(128)",
    "senderEmail": "string(256)",
    "emailSubject": "string(256)"
  },
  "sendList": [
    {
      "firstName": "string(32)",
      "lastName": "string(32)",
      "sendTarget": "string(256)"
    }
  ]
}

• GET /Group - 取出Group

  • 安全考量不會回傳password

• PUT /Group/{group_id} - 更新Group

  • 規則跟insert一樣

  • config欄位一定要全帶或都不帶

  • sendList一定要全帶或都不帶

  • 其他欄位有改到再帶

  • config.password 有改到再帶

    • 這個UI要不要加上確認新密碼功能? 要找和益討論

• DELETE / Group/{group_id} 刪除Group

• POST / Group/test

  • 這跟當初討論的不太依樣，當初是說test/send都在同一支就好

  • 但流程上，user是在group建立前就要測試了，所以沒有goupId可以測

  {
    "type": 1,
    "sendList": []
  }
  

• POST /Group/send 送出通知 (要在body裡帶group_id)

  • subject可不帶，但config裡就要設定，兩者都沒時，報錯

  // request body
  [{
    "groupId": 1,
    "msg": "test",
    "subject": "test"
  },{
    "groupId": 2,
    "msg": "test"
  }]
  

TODO

• 密碼安全機制

  • https://github.com/brix/crypto-js#aes-encryption

  • 目前只有套用在smtp password

  • 存進db前先加密, 要使用該passowrd寄信時，再解密

  • 因為有duplicate/update等功能，固密碼可以取出，但是以加密過的字串取出

• postgres不能存特殊符號 例如 roy's line

• delete 應該要顯示not found

• 刪掉g_notify

• 測試sso 三種腳色

• 寫測試

• 寫文件

• 修改package.json 固定板號

• eryn

  • 新的sso user登入時 跳出的修改密碼視窗是壞掉的

  • 沒有登出

  • UI沒版號?

• 補上git readme

• server code ugilify

  • https://stackoverflow.com/questions/45533101/how-to-use-uglify-es-with-gulp

• ssl/tls

  • 輸入可以大小寫 但回傳一律傳大寫

• Features