New Function #60
open
Added by yg yoon over 1 year ago.
Updated over 1 year ago.
Description
[요청사항]
전시유물 조회 진행율에 대한 API 추가 요청 드립니다.
** 첨부파일 로그_통계 시트의 2. 사용자 통계 조회 부분 참조
--> RESPONSE / progress_rate 항목 추가 (붉은색 으로 마킹됨)
Files
[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
- Assignee changed from Deca Park to Toby Pham
- Status changed from New to Resolved
- Assignee changed from Toby Pham to Deca Park
- Assignee changed from Deca Park to yg yoon
Also available in: Atom
PDF