Project

General

Profile

Actions
Copy link

New Function #41

closed

New Function #32: [API] API for mobile App

[API] Review&Recommend

Added by Deca Park almost 2 years ago. Updated about 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Deca Park
Start date:
04/18/2023
Due date:
% Done:

0%

Estimated time:
Spent time:
4.00 h

Description

1.Git

  • KORAIL_STORE/korail_store_user

2.Swagger UI (https://swagger.io/tools/swagger-ui/)

  • apply this into API

3.Spec (Review_Recommend sheet on #32)

  • 1 상품 후기 리스트 (product review list)
  • 2 쇼핑몰 후기 리스트 (mall review list)
  • 3 후기 정보 (review info)
  • 4 후기 등록 (register review)
  • 5 후기 수정 (modify review)
  • 6 후기 삭제  (delete review)
  • 7 추천 사용처 리스트 (recommend mall list)
  • 8 추천 사용처 정보 (recommend mall info)

Files

review_update.png (49.1 KB) review_update.png Deca Park, 06/21/2023 01:51 PM

Related issues

Copied from New Function #40: [API] ProductClosedDeca Park04/18/2023

Actions
Copied to New Function #42: [API] UserClosedDeca Park04/18/2023

Actions
Actions
Copy link
 #1

Updated by Deca Park almost 2 years ago

Actions
Copy link
 #2

Updated by Deca Park almost 2 years ago

Actions
Copy link
 #3

Updated by jason jason almost 2 years ago

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

Updated by Deca Park over 1 year ago

[API] Spec change

1.Spec (Change)

  • Review_Recommend sheet on #32 (20230620)

2.product review list (GET /api/product_review_list)
  mall review list (GET /api/mall_review_list)
  review info (GET /api/review)
  1) Response
    a) add fields
      attach_file_2_url : set by st_review.attach_file_2 (NEW)
      attach_file_3_url : set by st_review.attach_file_3 (NEW)

3.register review (POST /api/review)
  modify review (PUT /api/review)
  1) Parameters
    attach_file_2 / attach_file_3 (NEW)
  2) logic
    INSERT into st_review.attach_file_2 / attach_file_3 (NEW)

4.delete review (DELETE /api/review)
  1) logic
    - when DELETE data, DELETE st_files data and physical file of attach_file / attach_file_2 / attach_file_3

5.recommend mall list (GET /api/recommend_mall_list)
  1) Parameters
    - category_code (REMOVE)
    - mall_name (NEW)
  2) logic
    a) if mall_name param exists, add condition: st_mall.mall_name LIKE 

Actions
Copy link
 #5

Updated by Deca Park over 1 year ago

  • Status changed from Resolved to Feedback
  • Assignee changed from Deca Park to Toby Pham
Actions
Copy link
 #6

Updated by Toby Pham over 1 year ago

  • Status changed from Feedback to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions
Copy link
 #7

Updated by Deca Park over 1 year ago

[API] PUT /api/review

1.Spec fix

  • refer to attach image
Actions
Copy link
 #8

Updated by Deca Park over 1 year ago

[API] POST /api/review
         PUT /api/review

[API] POST /api/review

1.parameter

  • order_no : remove required check (not required)
Actions
Copy link
 #9

Updated by Deca Park over 1 year ago

[API] POST /api/review_modify

1.400 error happens bcz select SQL
  - st_product / st_order : should be OUTER JOIN
  [SQL]
    FROM st_review review
    INNER JOIN st_user U ON U.user_seq = review.reg_user_seq
    INNER JOIN st_mall mall ON mall.mall_code = review.mall_code
    INNER JOIN st_product product ON product.product_code = review.product_code
    INNER JOIN st_order stOrder ON stOrder.order_no = review.order_no
    WHERE review.review_code = ?

Actions
Copy link
 #10

Updated by Deca Park about 1 year ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF