Project

General

Profile

Actions
Copy link

Non-Function #550

closed

[DATA] KRS 매칭 데이터 변경

Added by Jisoo Choi about 1 month ago. Updated 17 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Jisoo Choi
Start date:
08/14/2024
Due date:
% Done:

0%

Estimated time:
Spent time:
0.25 h

Description

 

 

 

현재 KRS에서 '매장 위치'로 갖고 오는 데이터 항목 수정을 부탁드립니다.

 

스토리웨이 플러스 DB [st_mall] TABLE의 "mall_location"(매장 위치)

- (현재) KRS [VI_APP_STORE_STORY] TABLE의 "STORE_LC_NM"

- (수정) KRS [VI_APP_STORE_STORY] TABLE의 "RN_DETAIL_ADDR"

 

*매칭되는 데이터만 수정하면 될 것 같습니다. (API 및 표시 내용 관련 수정사항 x)

 

 

 

 

Files

스크린샷 2024-08-20 105000.png (53.9 KB) 스크린샷 2024-08-20 105000.png Jisoo Choi, 08/20/2024 10:50 AM
Actions
Copy link
 #1

Updated by Deca Park about 1 month ago

  • Assignee changed from Deca Park to Toby Pham

[ADMIN] Scheduler / Manual > schedulerKRSStore

1.saveStore

  1) mall_location

  • As-is: VI_APP_STORE_STORY.STORE_LC_NM
  • To-be: VI_APP_STORE_STORY.RN_DETAIL_ADDR

    -> (change)

    if ADDR_TY_CD = 'L', set by ADDR2
    if ADDR_TY_CD = 'R', set by RN_DETAIL_ADDR

Actions
Copy link
 #2

Updated by Toby Pham about 1 month ago

  • Status changed from New to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions
Copy link
 #3

Updated by Deca Park about 1 month ago

  • Assignee changed from Deca Park to Jisoo Choi
Actions
Copy link
 #4

Updated by Jisoo Choi about 1 month ago

 

 

[현재 스토리 오더 매장 정보]

*개발 서버 / KRS 정보 수동 업데이트 완료

매장명: 영등포3층맞이방카페트리핀(직영)

매장코드: 223529

건물 내 위치: 맞이방

 

- (기존) KRS VI_APP_STORE_STORY.STORE_LC_NM: 맞이방

- (수정) KRS VI_APP_STORE_STORY.RN_DETAIL_ADDR: 3층 맞이방 카페 트리핀

 

혹시 기존에 들어가 있던 정보 때문에 RN_DETAIL_ADDR의 정보로 변경되지 않는 걸까요?

아니면 개발 서버의 스케줄러는 따로 변동이 없는 건지 확인을 부탁드리고 싶습니다!

 

(개발) 매장 정보: http://210.123.124.139:8084/store/223529?menuCode=M7001&mallName=%ED%8A%B8%EB%A6%AC%ED%95%80

 

 

Actions
Copy link
 #5

Updated by Jisoo Choi 30 days ago

  • Status changed from Feedback to Closed
  • Assignee changed from Deca Park to Jisoo Choi
Actions
Copy link
 #6

Updated by Jisoo Choi 30 days ago

  • Status changed from Closed to In Progress
  • Assignee changed from Jisoo Choi to Deca Park
Actions
Copy link
 #7

Updated by Deca Park 30 days ago

  • Status changed from In Progress to Resolved
  • Assignee changed from Deca Park to Jisoo Choi
Actions
Copy link
 #8

Updated by Jisoo Choi 29 days ago

  • Status changed from Resolved to Closed
Actions
Copy link
 #9

Updated by Jisoo Choi 20 days ago

  • Status changed from Closed to In Progress
  • Assignee changed from Jisoo Choi to Deca Park

 

 

스토리웨이 플러스 DB [st_mall] TABLE의 "mall_location"(매장 위치)

 

- (현재) KRS [VI_APP_STORE_STORY] TABLE의 "RN_DETAIL_ADDR"

- (수정) 

(1) KRS [VI_APP_STORE_STORY] TABLE의 "ADDR_TY_CD"가 "L"인 경우, "ADDR2"  

(2) KRS [VI_APP_STORE_STORY] TABLE의 "ADDR_TY_CD"가 "R"인 경우, "RN_DETAIL_ADDR"

 

 

주요 담당자가 ADDR_TY_CD에 대해 몰랐다고 해서, 추가로 전달 받은 상태입니다.

수정을 부탁드립니다. 감사합니다.

 

 

 

 

Actions
Copy link
 #10

Updated by Deca Park 20 days ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Deca Park to bryant bryant
Actions
Copy link
 #11

Updated by bryant bryant 20 days ago

  • Status changed from Feedback to Resolved
  • Assignee changed from bryant bryant to Deca Park
Actions
Copy link
 #12

Updated by Deca Park 19 days ago

  • Assignee changed from Deca Park to Jisoo Choi
Actions
Copy link
 #13

Updated by Jisoo Choi 17 days ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF