KORAIL_STORE

[API] POST /api/login            
1.Logic
  1) As-is
    - if user_status = 'US04', return error (status: 401, error_code: "user.error.dormant")
  2) To-be
    - SKIP (although user_status = 'US04', can login)

[API] /api/user
1.Resonse
  1) user_status / user_status_name (Add)
    - set by st_user.user_status

[API] 회원상태 조회 (user status view) (ADD)

1.Spec (User sheet of #32 - 20230626)

• GET /api/user_status

1.API (Add) - 회원 포인트 적립 (Save user point) : POST /api/save_point
   1) Spec (User sheet of #32 - 20230626)
   2) DB (change)
     - depart_date / arrive_date : DELETE

2.[API] GET /api/user_point
  1) Response
    a) today_save_point (Add)
      a-1) logic
        DB: st_user_save_point
        select: SUM(save_point)
        conditions: user_seq = {user_seq of id param} AND save_date = {today}
    b) today_move_distance (Add)
      b-1) logic
        DB: st_user_save_point
        select: SUM(move_distance)
        conditions: user_seq = {user_seq of id param} AND save_date = {today}
    c) today_carbon_reduce (Add)
      c-1) logic: NOT DEFINED

[API] POST /api/signup

1.server error

org.springframework.dao.DataIntegrityViolationException:
### Error updating database.  Cause: java.sql.SQLException: Data truncated for column 'event_alarm_yn' at row 1
### The error may involve com.stoneitgt.user.mapper.UserMapper.insert-Inline
### The error occurred while setting parameters
### SQL: insert into st_user (id, password,                              signup_type, username, gender,                              birth_day, hp, email,                              zipcode, address, sub_address,                              auth, user_status, user_grade, concern_station_code,                              event_alarm_yn, last_login_date, pw_mod_date,                              dormant_date, withdraw_date, email_receive_yn, sms_receive_yn,                              anniversary_name, anniversary_date,                              reg_user_seq, reg_date)         values (?, ?,                 ?, ?, ?,                 ?, ?, ?,                 ?, ?, ?,                 ?, ?, ?, ?,                 ?, ?, ?,                 ?, ?, ?, ?,                 ?, ?,                 ?, NOW())
### Cause: java.sql.SQLException: Data truncated for column 'event_alarm_yn' at row 1

2.test parameters

{
  "address": "서울 강서구 강서로 486",
  "birth_day": "19930628",
  "email": "1021kk@naver.com",
  "email_receive_yn": "Y",
  "event_alarm_yn": "N",
  "gender": "GE01",
  "hp": "01094860934",
  "id": "test1234",
  "password": "1234",
  "signup_type": "MJ01",
  "sms_receive_yn": "Y",
  "sub_address": "123123",
  "username": "강민기",
  "zipcode": "07530"
}

[API] GET /api/user_point

1.Response fields
  1) today_move_distance 
    a) change comment with "오늘 이동거리 (km)"
    b) change unit (m -> km)
      - show value until first decimal point  (round up on second decimal point)
      - ex) 650m -> 0.7km
        ex) 640m -> 0.6km
        ex) 500m -> 0.5km
  2) today_carbon_reduce (NEW)
    = {today_move_distance} (km) * 132g (round up on first decimal point)
    ex) 1.5 -> 2g
        1.4 -> 1g