KORAIL_STORE

2.Scheduler - KRS Store Product DB (1)

• make Scheduler with 3 (STORE / GOODS / SALEITEM)

  1) logic
    a) SELECT KRS DB (VI_APP_GOODS_STORY)
       columns: set according to following mapping info (not use *)
       condition:
         - TRANS_YN = 'N'
       sort : ITEM_CD ASC, DEPT_CD ASC
    b) mapping
      ------------------------------------------------------------
      KRS: VI_APP_GOODS_STORY  ->  KORAIL: st_product
           (PK: DEPT_CD+ITEM_CD)         (PK: product_code)
      ------------------------------------------------------------
      DEPT_CD -> mall_code
      ITEM_CD -> krs_item_cd (NEW)
                    -> product_code : set by "{DEPT_CD}-{ITEM_CD}" - ex) "204623-7000427"
      ITEM_NM -> product_name
      BAR_CD -> krs_bar_cd (NEW)
      SALE_PRICE -> price
      SALE_PRICE_DC -> sale_price (temporarily, set same with price)
                              -> if SALE_PRICE > SALE_PRICE_DC, set discount_type = 'amount', discount_amount = SALE_PRICE - SALE_PRICE_DC
                              -> when UPDATE, if NOT (SALE_PRICE > SALE_PRICE_DC), set discount_type = NULL, discount_amount = NULL
      NORMAL_JAEGO_QTY -> stock_count
      IMG_URL -> krs_img_url (NEW)
      MEM_DC_RATE -> staff_discount_rate
      MEM_SALE_PRICE -> staff_sale_price
                     -> staff_discount_type : if MEM_DC_RATE is NOT NULL, set by 'rate'

    c) INSERT/UPDATE KORAIL DB (st_product)
      c-1) if data is NOT existed (with mall_code & krs_item_cd) , INSERT st_product
        - product_type : 'general'
        - reg_date : current date
      c-2) if data is existed, UPDATE st_product
        - mod_date : current date
    d) if KRS data is committed into KORAIL DB (st_product)
      - UPDATE VI_APP_GOODS_STORY
        SET TRANS_YN = 'Y' 
        WHERE DEPT_CD = {mall_code} AND ITEM_CD = {krs_item_cd}
      - if TRANS_YN = 'Y', this data is excluded on next time

3.Scheduler - KRS Store Product DB (2)

• make Scheduler with 3 (STORE / GOODS / SALEITEM)

  1) logic
    a) SELECT KRS DB (VI_APP_SALEITEM_STORY)
       columns: set according to following mapping info (not use *)
       condition:
         - TRANS_YN = 'N'
       sort : ITEM_CD ASC, DEPT_CD ASC
    b) mapping
      ------------------------------------------------------------
      KRS: VI_APP_SALEITEM_STORY -> KORAIL: st_product
              (PK: DEPT_CD+PLU_CD)                 (PK: product_code)
      ------------------------------------------------------------
      DEPT_CD -> mall_code
      PLU_CD -> krs_bar_cd (NEW)
                  -> product_code : set by "{DEPT_CD}-{PLU_CD}" - ex) "204623-2021747800430"
      ITEM_CD -> krs_item_cd (NEW)
      PLU_NM -> product_name
      SALE_PRICE -> price / sale_price
      IMG_URL -> krs_img_url (NEW)
      APP_SALE_YN -> show_yn
      MEM_DC_RATE -> staff_discount_rate
      MEM_SALE_PRICE -> staff_sale_price
                     -> staff_discount_type : if MEM_DC_RATE is NOT NULL, set by 'rate'
                                                        (when UPDATE, MEM_DC_RATE is NULL, set staff_discount_type = NULL)

    c) INSERT/UPDATE KORAIL DB (st_product)
      c-1) if data is NOT existed (with mall_code & krs_bar_cd) , INSERT st_product
        - product_type : 'general'
        - reg_date : current date
      c-2) if data is existed, UPDATE st_product
        - mod_date : current date
    d) if KRS data is committed into KORAIL DB (st_product)
      - UPDATE VI_APP_SALEITEM_STORY
        SET TRANS_YN = 'Y' 
        WHERE DEPT_CD = {mall_code} AND PLU_CD = {krs_bar_cd}
      - if TRANS_YN = 'Y', this data is excluded on next time

1. URL scheduler manually [KRS STORE]

• /krsScheduler/run?type=store

2. URL scheduler manually [KRS GOODS]

• /krsScheduler/run?type=goods

3. URL scheduler manually [KRS SALEITEM]

• /krsScheduler/run?type=saleitem

[KRS Scheduler]

1.crontab

  1) store scheduler
    - everyday 4 AM

  2) store product (goods AND saleitem) scheduler
    - everyday 4:15 AM

[KRS GOODS/SALEITEM DB scheduler]

1.DB (st_product)
  1) krs_taxn_se_cd (NEW)
    - if GOODS scheduler, set by TAXN_SE_CD
    - if SALEITEM scheduler, set by TAX_GUB

  2) reg_user_seq
    - don't set by 0 (DB column is changed by NULL)

  3) sold_out_yn
    - set by 'N' (default)

  4) max_order_count
    - set by 5 (defautl)

[ADMIN] 스토리 오더 관리 > 매장 관리 (/store)

1.KRS 수동 업데이트 button
  - if login st_user.auth = 'AU00' or 'AU01', show it
    else hide it

[ADMIN] 스토리 오더 관리 > 상품 관리 (/storeProduct)

1.편의점 KRS 수동 업데이트 / 전문점 KRS 수동 업데이트 button
   - if login st_user.auth = 'AU00' or 'AU01', show it
    else hide it