Project

General

Profile

Actions
Copy link

Non-Function #209

closed

[ADMIN] 구매 적립금 0원 미생성(삭제) 처리

Added by Jisoo Choi about 1 year ago. Updated about 1 year ago.

Status:
Closed
Priority:
High
Assignee:
Jisoo Choi
Start date:
11/28/2023
Due date:
% Done:

0%

Estimated time:
Spent time:
0.25 h

Description

 

 

 

현재 [포인트/구매 관리 > 적립금 설정]에서 구매 적립금 설정 값이 null인데

적립되는 금액이 0인 경우에도 계속 이력이 생성되고 있는 것 같습니다.

구매 적립금이 0원인 경우에는 적립 이력을 생성하지 않도록 처리를 부탁드리고 싶습니다.

Files

0원 적립금.png (634 KB) 0원 적립금.png Jisoo Choi, 11/28/2023 06:54 PM
Actions
Copy link
 #1

Updated by Deca Park about 1 year ago

  • Assignee changed from Deca Park to bryant bryant

1.Create st_user_save_money (when order)

  1) although st_money_coupon.money_grant_ratio is NULL

  • save_money_type: SM01, save_money: 0 data is inserted wrong. (don't create 0 data)
Actions
Copy link
 #2

Updated by Deca Park about 1 year ago

  • Priority changed from Normal to High
Actions
Copy link
 #3

Updated by bryant bryant about 1 year ago

  • Status changed from New to Resolved
  • Assignee changed from bryant bryant to Deca Park
Actions
Copy link
 #4

Updated by Deca Park about 1 year ago

  • Assignee changed from Deca Park to Jisoo Choi

[적립금 0원 데이터 삭제 SQL]

DELETE FROM st_user_save_money
WHERE save_money=0;

Actions
Copy link
 #5

Updated by Jisoo Choi about 1 year ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF