KORAIL_STORE

[Scheduler - dormant user process]

1.Logic conditions (to get dormant users)
  1) add condition

• auth='AU02'

  2) when compare last_login_date, just check with yyyymmdd (exclude time)

[ADMIN] kakao message manual send page

0.URL : /kakaoMessage/

1.page definition

  1) sub title: "Kakao 알림톡 수동 발송"

  2) Table
    a) column name
      - 알림톡 명 / 발송
    b) rows
      - 2 rows (hard-coding)
      b-1) 알림톡 명 (message type)
        - 포인트소멸안내 : point expire message (call sendUserPointExpireMessage())
        - 휴면회원안내 : dormant member message
      b-2) 발송
        - add 발송(send) button
        - if the button clicks
          + show confirm msg("해당 알림톡을 발송 처리 하시겠습니까?")
          + if YES, call the process
          + if done, show complete msg.("알림톡 발송 처리가 완료되었습니다.")
          + if error, show common server error msg.

[Scheduler - kakao send message & DB process]

1.kakao send message (point expire) : msg_template_id = 'ap0002' (포인트소멸안내)

  1) logic
    a) get st_user_save_point SUM based with expire days
      [logic]
      DB: st_user_save_point
      select: SUM(save_point)
      conditions: DATE(save_date) <= (current DATE - 365 days)
      group by: user_seq
    b) get st_user_use_point SUM
      [logic]
      DB: st_user_use_point
      select: SUM(use_point)
      conditions: DATE(reg_date) <= (current DATE)
      group by: user_seq
    c) if a) SUM(save_point) <= b) SUM(use_point), SKIP
       else a) SUM(save_point) > b) SUM(use_point)
         - send message & DB process

  2) send message
    a) if {hp} of target user_no is empty(NULL), SKIP
    b) if kakao message was sent into taget user within recent 7 days, SKIP
      [check logic]
      DB: st_kakao_message_send
      conditions: msg_template_id='ap0002' AND receive_user_seq = {taget user_seq} AND current DATE <= point_expire_date 
    c) get message template 
        - DB: st_kakao_message_template
        - conditions: msg_template_id='ap0002'
    d) call kakao message send
      d-1) get message after set values of {st_kakao_message_template.msg_content}
        - "userName" : user name of target user_no
        - "expirePoint" : a) SUM(save_point) - b) SUM(use_point) (from No 1)
        - "pointExpireDate" : set by {current DATE + 7 days} (format: yyyy-mm-dd)
        - "baseDate" : set by current DATE (format: yyyy-mm-dd)
      d-2) call ORACLE procedure
         - refer to attach txt file 
         - use ORACLE DB properites of config
    e) INSERT DB (st_kakao_message_send)
        - msg_template_id: 'ap0002'
        - receive_user_seq: target user_no
        - receive_tel_no: {hp} of target user_no
        - msg_send_date : current datetime
        - msg_content : send message content
        - point_expire_date : {pointExpireDate}
        - expire_point : {expirePoint}
        - point_expire_proc_yn: 'N'

  3) server log
    - level: INFO
    - message: "[Scheduler] 알림톡 포인트소멸안내(ap0002): " + "total Kakao message send count: {total count}"

2.DB process (point expire) : msg_template_id = 'ap0002' (포인트소멸안내)
  1) logic
    DB: st_kakao_message_send
    conditions: msg_template_id='ap0002' AND point_expire_date <= current DATE AND point_expire_proc_yn = 'N'

  2) INSERT
     DB: st_user_save_point
     set
       - user_seq : {target user_seq}
       - save_point : -{expire_point} (minus value)
       - save_date : current date
       - reg_date : current date
       - reg_user_seq : {target user_seq}
       - admin_add_yn: 'Y'
       - admin_save_reason: "사용 기간 만료"
  3) UPDATE
      DB: st_kakao_message_send
      conditions: msg_code = {target msg_code}
        - point_expire_proc_yn = 'Y'

  4) server log
    - level: INFO
    - message: "[Scheduler] 알림톡-포인트소멸안내(ap0002): " + "total DB process count: {total count}"

[Scheduler - kakao send message & DB process]

1.kakao send message (delivery message) : msg_template_id = 'ap0001' (배송알림)

  1) [ADMIN] 스토리 쇼핑 관리 > 주문/배송 관리 (/onlineOrder) > 상세(Modify)
    a) 저장(save) button
      a-1) if 주문 상태 (order_status) is updated with 'OS02' (배송중)
        - send kakao message

  2) send kakao message
    a) if {hp} of target user_no is empty(NULL), SKIP
    a-1) if delivery_company_code OR delivery_invoice_no is empty(NULL), SKIP
    b) get message template 
        - DB: st_kakao_message_template
        - conditions: msg_template_id='ap0001'
    c) call kakao message send
      c-1) get message after set values of {st_kakao_message_template.msg_content}
        - "userName" : user name of target user_no
        - "productName" : refer to [API] GET /api/agent/store_order_list
           "{first product_name} {first order_count}개 외 {other produnct count except first}건"
            ex) "상품 1개 외 2건"
        - "orderNo" : {order_no}
        - "deliveryCompanyName" : {delivery_company_code} code name (Code: DC)
        - "deliveryInvoiceNo" : {delivery_invoice_no}
        - "deliveryViewUrl" : "http://info.sweettracker.co.kr/tracking/4?t_key=&amp;t_code=&amp;t_invoice=&quot;
          [parameter value]
          t_key : {delivery.api.key} property
          t_code : {delivery_company_code}
          t_invoice : {delivery_invoice_no}
      c-2) call ORACLE procedure
         - refer to attach txt file 
         - use ORACLE DB properites of config
    d) INSERT DB (st_kakao_message_send)
        - msg_template_id: 'ap0001'
        - receive_user_seq: target user_no
        - receive_tel_no: {hp} of target user_no
        - msg_send_date : current datetime
        - msg_content : send message content

  3) server log
    - level: INFO
    - message: "[Scheduler] 알림톡 배송알림(ap0001): " + "total Kakao message send count: {total count}"