KORAIL_STORE

[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 

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

• 400 error happen (http://210.123.124.139:8082/KORAIL/swagger-ui.html#/review-recommend-controller/createReviewUsingPOST)
• attach_file / attach_file_2 / attach_file_3 : altough error doesn't happen, file isn't uploaded (refer to POST /api/qna/add)

[API] POST /api/review

1.parameter

• order_no : remove required check (not required)

[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 = ?