사이버기념관 (nmkpg_cyber)

[ADMIN] Dashboard menu

• spec: p3 ~ 4

[ADMIN] 통계 (statistics) menu

• URL: /statistics

[통계 (/statistics)]
1.all TAB
  1) grid
    - sort: date DESC (but graph date is ASC)
    - apply into 다운로드(excel download) too
2.접속률 TAB
  1) graph
    a) 일 전체 평균 
      - display the label fully (currently, it's cutten a little)

.
[Dashboard]
1.graph on 접속률 area
  1) x-axis 
    - apply date format: mm-dd (05-01)

[Dashboard]

1.접속률
  1) change rate
    - if divide value is 0, don't show value
      (ex: 오늘 접속량 : (2 - 0)/0)

2.가입률 및 도달률
  1) user count area
    a) 전체 회원
      a-1) logic (change)
        DB: st_user
        select: COUNT
        condition: reg_date = {today-1} AND user_type IN ('UT1','UT5')
    b) 도슨트 회원
      - fix label
      b-1) logic (change)
        DB: st_user
        select: COUNT
        condition: reg_date = {today-1} AND user_type = 'UT1'
    c) 탈퇴 회원
      - fix label
      c-1) logic (change)
        DB: st_user
        select: COUNT
        condition: user_wdw_date = {today-1} AND user_stt = '00'
    d) change rate
      - if divide value is 0,  don't show value

  2) 체류 시간 / 이동 거리 / 컨텐츠 호출 area
    a) logic (change)
      DB: st_user_log
      condition: log_time = {today-1}
    
      DB: st_user_exihibit
      condition: reg_date = {today-1}