Project

General

Profile

Actions
Copy link

New Function #17

open

New Function #10: {API] 사용자 API 개발 (USER API development)

[API] Log

Added by Deca Park over 1 year ago. Updated over 1 year ago.

Status:
Resolved
Priority:
Normal
Assignee:
Deca Park
Start date:
02/09/2023
Due date:
% Done:

0%

Estimated time:
Spent time:
4.50 h

Description

1.[API] Exhibit (Log excel sheet on #10)

  • 1) User location log
  • 2) User statistics

2.Git

  • nmkpg_cyber_user

Related issues

Copied from New Function #15: [API] ExhibitResolvedDeca Park02/09/2023

Actions
Actions
Copy link
 #1

Updated by Deca Park over 1 year ago

Actions
Copy link
 #2

Updated by Toby Pham over 1 year ago

  • Status changed from New to In Progress
Actions
Copy link
 #3

Updated by Toby Pham over 1 year ago

  • Status changed from In Progress to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions
Copy link
 #4

Updated by Deca Park over 1 year ago

  • Status changed from Resolved to Feedback
  • Assignee changed from Deca Park to Toby Pham

1.POST /user_log
  1) logic
    - if user_id & log_time (PK) is already existed, UPDATE it (if not, INSERT)

2.GET /stats
  1) response
    a) total_move_distance / avg_move_distance
      - value is float (until 2 decimal point) (currently, integer is returned)

Actions
Copy link
 #5

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
 #6

Updated by Deca Park over 1 year ago

  • Status changed from Resolved to Feedback
  • Assignee changed from Deca Park to Toby Pham

[Test Issues]

1.API (/api/stats)

  1) response

  • although user log data exists, reponse > dashboard is returned with NULL wrong
  • dashboard.avg_move_distance : set value until 2 decimal point (ex: 15.12)
Actions
Copy link
 #7

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
 #8

Updated by Deca Park over 1 year ago

[Test Issues]

1.API (/api/stats)
  1) logic change
    a) avg_stay_time
        SUM(stay_time) / COUNT(DISTINCT user_seq)
        FROM st_user_log
        WHERE user_seq != {param user_seq}
    b) avg_move_distance / avg_view_count
      - similar with 1.1).a)
  2) response > avg_stay_time / avg_move_distance / avg_view_count
    - set value until 2 decimal point
      (currently, avg_move_distance is not applied)

Actions
Copy link

Also available in: Atom PDF