上传的图像用于项目: 'CST技术支持'
  1. CST技术支持
  2. SLAL2-3419

【Pro-Aden】：用户活跃度统计报表

XMLWord打印

    • A-Aden-Y2020031
    • PRO
    • 基础通用功能
    • 隐藏

      月活跃：
      select
      to_char(login_date,'YYYY-mm') 日期,
      dep_trans.value 部门,
      count(distinct uc_user_login_log.user_id) the_count
      from uc_user_login_log
      left join hr_employee
      on uc_user_login_log.user_id=hr_employee.user_id
      left join emp_job on hr_employee.job_info_id=emp_job.id
      left join hr_department on emp_job.department_id=hr_department.id
      left join ir_translation dep_trans on dep_trans.res_id=hr_department.id
      and dep_trans.name ='hr.department,name'
      and dep_trans.lang='zh_CN'
      where is_delete=0
      and is_login_success =1
      and to_char(login_date,'YYYY')=to_char(current_date,'YYYY')
      group by to_char(login_date,'YYYY-mm'),dep_trans.value
      ================================
      日活跃：
      select
      to_char(login_date,'YYYY-mm-dd') 日期,
      dep_trans.value 部门,
      count(distinct uc_user_login_log.user_id) the_count
      from uc_user_login_log
      left join hr_employee
      on uc_user_login_log.user_id=hr_employee.user_id
      left join emp_job on hr_employee.job_info_id=emp_job.id
      left join hr_department on emp_job.department_id=hr_department.id
      left join ir_translation dep_trans on dep_trans.res_id=hr_department.id
      and dep_trans.name ='hr.department,name'
      and dep_trans.lang='zh_CN'
      where is_delete=0
      and is_login_success =1
      and to_char(login_date,'YYYY')=to_char(current_date,'YYYY')
      group by to_char(login_date,'YYYY-mm-dd'),dep_trans.value

      显示
      月活跃： select to_char(login_date,'YYYY-mm') 日期, dep_trans.value 部门, count(distinct uc_user_login_log.user_id) the_count from uc_user_login_log left join hr_employee on uc_user_login_log.user_id=hr_employee.user_id left join emp_job on hr_employee.job_info_id=emp_job.id left join hr_department on emp_job.department_id=hr_department.id left join ir_translation dep_trans on dep_trans.res_id=hr_department.id and dep_trans.name ='hr.department,name' and dep_trans.lang='zh_CN' where is_delete=0 and is_login_success =1 and to_char(login_date,'YYYY')=to_char(current_date,'YYYY') group by to_char(login_date,'YYYY-mm'),dep_trans.value ================================ 日活跃： select to_char(login_date,'YYYY-mm-dd') 日期, dep_trans.value 部门, count(distinct uc_user_login_log.user_id) the_count from uc_user_login_log left join hr_employee on uc_user_login_log.user_id=hr_employee.user_id left join emp_job on hr_employee.job_info_id=emp_job.id left join hr_department on emp_job.department_id=hr_department.id left join ir_translation dep_trans on dep_trans.res_id=hr_department.id and dep_trans.name ='hr.department,name' and dep_trans.lang='zh_CN' where is_delete=0 and is_login_success =1 and to_char(login_date,'YYYY')=to_char(current_date,'YYYY') group by to_char(login_date,'YYYY-mm-dd'),dep_trans.value

      由于测试环境被还原生产库导致此报表配置被冲掉，故辛苦再次处理，感谢
      【原单据：https://pm.ersoft.cn/browse/PROBUG-5131】

      需要统计用户活跃度（当天成功登录过则进行一次记录即可）

      图形：柱状图
      增加筛选条件：当前部门

      1:按天统计（当天成功登录过则进行一次记录即可）；
      横轴：按天显示，需显示当年（2021-01-01、2021-01-02····）；
      纵轴：显示人数；

      2:按月度统计（当月成功登录过则进行一次记录即可）；
      横轴：按月显示，需显示当年（2021-01、2021-02···）；
      纵轴：显示人数；

      截图为STD的用户活跃度截图

        1. image.png
          image.png
          383 kB

            grant.yang 杨光磊
            hanw 韩玮
            表决:
            0 为这个问题表决

              创建日期:
              已更新:
              已解决:

                预估时间:
                初始预估 - 尚未指定
                尚未指定
                剩余:
                剩余的估算 - 0小时
                0小时
                实际工作时间:
                耗费时间 - 2小时
                2小时