New Function #126
closed[ADMIN/API] QA-20231010
Description
1.Spec
- refer to attach ppt
Files
Updated by Deca Park 11 months ago
[ADMIN] 스토리 쇼핑 관리 > 메인 노출 상품 관리 (/onlineMainProduct) - p13
1.상품 노출 옵션 (product_show_type)
1) radio button
- when page is loaded, set by DB(st_setting_product) value - 1 row data
DB (st_setting_product) : mall_type='online' AND mall_code = NULL
- if No DB data, 신상품순(new) option is selected by default
2.노출 상품 선택 (main product list)
1) list
- display with DB (st_setting_product_main) data regardless of 상품 노출 옵션 (product_show_type)
(currently, if product_show_type = 'new'(신상품순), product list is not displayed)
2) columns
a) 매장명 : show mall_name of the product
3.저장 (save)
1) DB (st_setting_product) - 1 row data
- if no data, INSERT (mall_type='online' AND mall_code = NULL)
- if data exists, UPDATE
[ADMIN] 스토리 오더 관리 > 메인 노출 상품 관리 (/storeMainProduct) - p14
1.상품 노출 옵션 (product_show_type) / 노출 상품 선택 (main product list) / 저장 (save)
- same with /onlineMainProduct except
DB (st_setting_product) : mall_type='store' AND mall_code = NULL (1 row data)
2.노출 상품 선택 (main product list)
1) columns
a) 매장명 : show mall_name of the product
[ADMIN] 스토리 오더 관리 > 상품 관리 (/storeProduct) - p17
1.상품 순서/노출 설정 button
- if store is selected on left store list, show it
- if not, hide it
2.상품 순서/노출 설정 modal
1) 노출 상품 선택 (product_show_type)
a) radio button
- when page is loaded, set by DB(st_setting_product) value - 1 row data per mall
DB (st_setting_product) : mall_type='store' AND mall_code = {selected mall_code}
- if No DB data, 신상품순(new) option is selected by default
2) product list
- display product list regardless of 노출 상품 선택 (product_show_type)
3) 저장 (save)
a) DB (st_setting_product) - 1 row data
- if no data, INSERT (mall_type='online' AND mall_code = {selected mall_code})
- if data exists, UPDATE
(currently, whenever save, data is inserted wrong)
b) product list - DB (st_product)
b-1) 순서 (show_order)
- UPDATE show_order (currently, it's not updated)
Updated by Deca Park 11 months ago
[ADMIN] 대시보드 (/main)
1.if login admin auth = ‘AU00’ (시스템관리자) or ‘AU01’(관리자) - p8
1) 스토리 오더 매출 TOP 10 / 스토리 쇼핑 매출 TOP 10 (sale amount ranking)
a) SQL
- driving table should be st_order
- currently, driving table is st_mall. so although no order data, 10 count mall is shown wrong
2.if login admin auth = ‘AU10’ (스토리쇼핑 관리자) - p10
1) 스토리 쇼핑 주문 현황
a) order_status - (Code: OS)
- code is 10 count
- 'OS30'(교환재배송중) is added but it's not shown
Updated by Deca Park 11 months ago
[API] GET /api/main/product_list
1.logic
1) when display st_setting_product_main data
[Logic]
DB: st_setting_product_main
condition: setting_code = {setting_code of the st_setting_product}
sort: sort_no ASC
[API] GET /api/store_product_list
1.logic
1) when get product list with show_order
[logic]
DB: st_product
condition: mall_code={mall_code param} and show_yn=‘Y’
sort: show_order IS NULL ASC, show_order ASC
Updated by Deca Park 11 months ago
[ADMIN] 스토리 쇼핑 관리 > 상품 등록 관리 (/onlineProduct)
1.List
1) product list (when the menu is clicked)
- display products with mall_type='online'
(currently, all products are shown regardless of mall_type)
2.상세 (Modify)
1) 저장 (save)
- server error happens
[ADMIN] 스토리 오더 관리 > 상품 관리 (/storeProduct)
1.List
1) product list (when the menu is clicked)
- display products with mall_type='store'
(currently, all products are shown regardless of mall_type)
2.상세 (Modify)
1) 저장 (save)
- server error happens
3.상품 순서/노출 설정 modal
1) product list
a) sort
- st_product.show_order IS NULL ASC, show_order ASC, product_name ASC
2) 상품 노출 여부 (show_yn)
a) if it's changed but No 순서 (show_order) input
- server error happens
- if no show_order input, show_yn should just be updated