刘琛运的技术文档

Appearance

9.20消息中心-通知设置 ​

需求 ​

https://466cpy.axshare.com

参考：阿里云，gitee的消息中心

数据库设计 ​

DROP TABLE IF EXISTS `message_notice`;
CREATE TABLE `message_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `type` varchar(255) DEFAULT NULL COMMENT '类型',
  `is_site` bit(1) DEFAULT NULL COMMENT '是否站内',
  `is_email` bit(1) DEFAULT NULL COMMENT '是否邮箱',
  `is_sms` bit(1) DEFAULT NULL COMMENT '是否短信',
  PRIMARY KEY (`id`),
  KEY `index_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

官网软件漏洞修复消息 ​

固定地址：

订阅：
http://127.0.0.1:8080/cas/login?service=http://127.0.0.1:8086/web/user/account/login/callback/bugfixes-true?client_name=userAccount&language=zh
退订：
http://127.0.0.1:8080/cas/login?service=http://127.0.0.1:8086/web/user/account/login/callback/bugfixes-false?client_name=userAccount&language=zh
https://ssocdtest.supermap.com/login?service=https%3A%2F%2Fcdtest.supermapol.com%2Fweb%2Fuser%2Faccount%2Flogin%2Fcallback%2Fbugfixes-true%3Fclient_name%3DCasClient

https://ssocdtest.supermap.com/login?service=https%3A%2F%2Fcdtest.supermapol.com%2Fweb%2Fuser%2Faccount%2Flogin%2Fcallback%2Fbugfixes-fasle%3Fclient_name%3DCasClient&language=zh

https://ssocdtest.supermap.com/login?service=https://cdtest.supermapol.com/web/user/account/login/callback/bugfixes-true?client_name=CasClient

https://ssocdtest.supermap.com/login?service=https://cdtest.supermapol.com/web/user/account/login/callback/bugfixes-true?client_name=CasClient
订阅
https://sso.supermap.com/login?service=https%3A%2F%2Fwww.supermapol.com%2Fweb%2Fuser%2Faccount%2Flogin%2Fcallback%2Fbugfixes-true%3Fclient_name%3DCasClient


退订
https://sso.supermap.com/login?service=https%3A%2F%2Fwww.supermapol.com%2Fweb%2Fuser%2Faccount%2Flogin%2Fcallback%2Fbugfixes-fasle%3Fclient_name%3DCasClient

邮件恢复订阅 ​

http://127.0.0.1:8080/cas/login?service=http://127.0.0.1:8086/web/user/account/login/callback/online_email?client_name=userAccount

https://ssocdtest.supermap.com/login?service=https://cdtest.supermapol.com/web/user/account/login/callback/online_email?client_name=CasClient
https://ssocdtest.supermap.com/login?service=https%3A%2F%2Fcdtest.supermapol.com%2Fweb%2Fuser%2Faccount%2Flogin%2Fcallback%2Fonline_email%3Fclient_name%3DCasClient

所有邮箱加恢复订阅和退订 ​

image-20230925140024512

http://127.0.0.1:8086/web/user/account/unnotice/email?type=BUG&code=eyJhbGciOiJIUzI1NiJ9.eyJqdGkiOiI5NDUwMDEiLCJzdWIiOiI5NDUwMDEiLCJpYX1QiOjE2OTU3MDk3NzgsImV4cCI6MTY5ODMwMTc3OH0.TrPFLwlYHNzkOYjOras2U9wM2gWshKyv8ScmYvaFBIc

更新服务

邮箱涉及服务

user-account
subscription
resource-center
public-service
sso

trial-listense（没有）

短信涉及服务

user-account
subscription
resource-center
public-service

subscription删除环境变量

    region-id: ${SMS_REGION_ID}
    access-key-id: ${SMS_ACCESS_KEY_ID}
    secret: ${SMS_SECRET}
    endpoint-name: ${shop.sms-config.region-id}
    product: ${SMS_PRODUCT}
    domain: ${SMS_DOMAIN}
    sign-name: ${SMS_SIGN}
    buy-template-code: ${SMS_BUY_TEMPLATE_CODE}
    sell-template-code: ${SMS_SELL_TEMPLATE_CODE}
    before-expire-template-code: ${SMS_BEFORE_EXPIRE_TEMPLATE_CODE}
    after-expire-template-code: ${SMS_AFTER_EXPIRE_TEMPLATE_CODE}
  
  
  删除
    		- name: SMS_REGION_ID
              value: cn-beijing
            - name: SMS_ACCESS_KEY_ID
              value: LTAIHt0s0Ogw6XUz
            - name: SMS_SECRET
              value: G9dUSd6UB4TgkXlwCpZsEbi1DBw4JT
            - name: SMS_PRODUCT
              value: Dysmsapi
            - name: SMS_DOMAIN
              value: dysmsapi.aliyuncs.com
            - name: SMS_SIGN
              value: 超图软件
            - name: SMS_BUY_TEMPLATE_CODE
              value: SMS_246860074
            - name: SMS_SELL_TEMPLATE_CODE
              value: SMS_246715069
            - name: SMS_BEFORE_EXPIRE_TEMPLATE_CODE
              value: SMS_462555384
            - name: SMS_AFTER_EXPIRE_TEMPLATE_CODE
              value: SMS_462585356
              
  新增：
            - name: SMS_SERVICE_URL
              value: 'http://public-service-service:8087/service/api/sms/sendSmsWithParam'

环境变量

public-service

新增数据库，通过字段判断

            - name: IPORTAL_DATABASE_URL
              value: 192.168.11.188
            - name: IPORTAL_DATABASE_PORT
              value: '31185'
            - name: IPORTAL_DATABASE
              value: iportal
            - name: IPORTAL_DATABASE_USERNAME
              value: root
            - name: IPORTAL_DATABASE_PASSWORD
              value: '123456'
            - name: SITE_URL
              value: 'https://cdtest.supermapol.com'
            - name: SSO_URL
              value: 'https://ssocdtest.supermap.com'
   新增短信模版         
            - name: SMS_MERGE_TEMPLATE_CODE
              value: SMS_257841256
            - name: SMS_BUY_TEMPLATE_CODE
              value: SMS_246860074
            - name: SMS_SELL_TEMPLATE_CODE
              value: SMS_246715069
            - name: SMS_BEFORE_EXPIRE_TEMPLATE_CODE
              value: SMS_462555384
            - name: SMS_AFTER_EXPIRE_TEMPLATE_CODE
              value: SMS_462585356

邮箱短信发送现状 ​

image-20231010102208655