Non-Function #78
closed[API] 상품 재고량 처리 (product stock count process)
Description
1.ADMIN
1) 온라인몰 관리 > 상품 등록 관리 (/onlineProduct) > 상세 (Modify)
- Spec: p2 (attach ppt)
2.API
1) [API] 쇼핑몰 상품 리스트 (GET /api/mall_product_list), 상품정보 (GET /api/mall_product)
1-1) Response > sold_out_yn (logic change)
a) if st_product.sold_out_yn = 'Y', set 'Y'
b) else
b-1) if stock_count is NOT NULL AND stock_count <= 0, set 'Y'
(* if stock_count is NULL(empty), sold_out_yn is set by 'N' - because it means that the product stock is not managed)
c) if NOT a) or b), set 'N'
2) [API] PG 결제 컨펌 (POST /api/pay_confirm)
a) if PG pay confirm API is success
- append common order's product stock count process
3) [Common] order's product stock count process
- make common service(function) (it's called on other process)
[Logic]
a) if st_mall.mall_type is NOT 'online' (with st_order.mall_code), SKIP
b) if st_mall.mall_type = 'online'
b-1) SELECT DB (st_order_product)
- select: order_count
- condition: order_no = {order_no param}
b-2) decrease product's stock_count of b-1) selected product list
UPDATE DB (st_product)
- stock_count = stock_count - order_count
(if stock_count is minus, set by 0)
Files
Updated by Toby Pham over 1 year ago
- Status changed from New to Resolved
- Assignee changed from Toby Pham to Deca Park
Updated by Deca Park over 1 year ago
- Subject changed from 재고량 처리 (stock count process) to 상품 재고량 처리 (product stock count process)
Updated by Deca Park over 1 year ago
- Description updated (diff)
- Status changed from Resolved to In Progress
- Assignee changed from Deca Park to bryant bryant
Updated by bryant bryant over 1 year ago
- Status changed from In Progress to Resolved
- Assignee changed from bryant bryant to Deca Park
Updated by Jisoo Choi 7 months ago
- Subject changed from 상품 재고량 처리 (product stock count process) to [API] 상품 재고량 처리 (product stock count process)
- Status changed from Closed to In Progress
기존에 재고(현재 앱 재고=DB 재고)가 마이너스일 경우, 0으로 세팅되도록 개발해주셨는데, (if stock_count is minus, set by 0)
재고가 마이너스일 경우에 마이너스 값을 갖도록 수정 부탁드립니다.
*참고: 편의점 KRS 상품 정보 업데이트 시, 재고는 다시 KRS 값으로 세팅됨
**스토리 오더: (1)편의점: 재고를 KRS에서 가져옴 (2)전문점: 재고 없음 / 스토리 쇼핑: 재고를 쇼핑몰에서 직접 수정함(KRS와 완전히 무관)
Updated by Jisoo Choi 7 months ago
- Tracker changed from New Function to Non-Function
Updated by Deca Park 7 months ago
- Assignee changed from Deca Park to Toby Pham
[API] orderService.processMinusStockCount
1.As-is
UPDATE DB (st_product)
- stock_count = stock_count - order_count
(if stock_count is minus, set by 0)
2.To-be
- UPDATE DB (st_product)
stock_count = stock_count - order_count
(if stock_count is minus, set by minus value)