Actions
New Function #60
open[API] 유물 조회 진행율 API 추가
Description
[요청사항]
전시유물 조회 진행율에 대한 API 추가 요청 드립니다.
** 첨부파일 로그_통계 시트의 2. 사용자 통계 조회 부분 참조
--> RESPONSE / progress_rate 항목 추가 (붉은색 으로 마킹됨)
Files
Updated by Deca Park over 1 year ago
[API] GET /api/stats
1.Response
1) add field : progress_rate (float)
a) logic
- value = ({user's view exhibit count} / {total exhibit count}) x 100
- value is unitl 2 decimal point (ex: 100.12) (don't show .0 - ex) 100.00 -> 100)
a-1) {user's view exhibit count}
COUNT(DISTINCT exhibit_seq) FROM st_user_exhibit WHERE user_seq = {the user_seq}
a-2) {total exhibit count}
COUNT(*) FROM st_exhibit
Updated by Deca Park over 1 year ago
- Assignee changed from Deca Park to Toby Pham
Updated by Toby Pham over 1 year ago
- Status changed from New to Resolved
- Assignee changed from Toby Pham to Deca Park
Actions