KORAIL_STORE

[order status change history - Logic]

1.DB (st_order_change)
  - db change
  1) insert definition
    a) job_type : 'scheduler' / 'admin' / 'pos' / 'agent'
    b) scheduler_name : scheduler name
      - if not scheduler, NULL
    c) order_no : current order_no
    d) if order is smart order
      - set smart_order_status_before / smart_order_status_after
    e) else if order is online shop order
      - set order_status_before / order_status_after
    f) payment_status_before : payment_status before order status is changed
    g) payment_status_after : payment_status when order status is changed - if payment_status is not changed, set payment_status_after by payment_status_before
      - if no change, set by payment_status_before)
    h) reg_user_seq : 
      - if ADMIN, set admin user_seq
      - if scheduler, NULL
    i) reg_date : datetime when update

2.ADMIN
  1) when OrderService.update() is called AND order status is updated
    a) if it's called by Scheduler
      - INSERT st_order_change (job_type: scheduler) - scheduler_name / payment_status_before / payment_status_after are not set
    b) if it's called by ADMIN
      - INSERT st_order_change (job_type: admin)

3.API
  1) AgentController : storeOrderStatusNew()
    a) when OrderService.update() is called AND order status is updated - if payment_status is not changed, set payment_status_after by payment_status_before
      - INSERT st_order_change (job_type: agent)
  2) PosController : orderProductReceive()
    a) when OrderService.update() is called AND order status is updated
      - INSERT st_order_change (job_type: pos)
  3) OrderController : storeOrderCancel()
    a) when OrderService.update() is called AND order status is updated
      - INSERT st_order_change (job_type: app)