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

增加两个自定义报表项

XMLWord打印

    • Icon: 技术问题 技术问题
    • 解决结果: 完成
    • Icon: Medium Medium
    • 202004
    • 无
    • 无
    • Y-易路产品-
    • xinchaotest
    • 时间管理
    • 隐藏

      创建时间报表项：
      迟到早退次数：
      total_dicts = pre_data['attendance_count']
      start_date = start_date.strftime('%Y-%m-%d')
      end_date = end_date.strftime('%Y-%m-%d')
      result = {}
      for employee_id in employee_ids:
      attendance_info = total_dicts.get(employee_id,{})
      number = 0
      for day,infos in attendance_info.items():
      day = datetime.datetime.strptime(day,'%Y-%m-%d').strftime('%Y-%m-%d')
      for non,res in infos.items():
      if start_date <= day <= end_date:
      number += res['late_count'] + res['leave_early_count']
      result[employee_id] = number
      旷工次数：
      total_dicts = pre_data['attendance_count']
      start_date = start_date.strftime('%Y-%m-%d')
      end_date = end_date.strftime('%Y-%m-%d')
      result = {}
      for employee_id in employee_ids:
      attendance_info = total_dicts.get(employee_id,{})
      number = 0
      for day,infos in attendance_info.items():
      day = datetime.datetime.strptime(day,'%Y-%m-%d').strftime('%Y-%m-%d')
      for non,res in infos.items():
      if start_date <= day <= end_date:
      number += res['late_count'] + res['leave_early_count']
      result[employee_id] = number

      显示
      创建时间报表项： 迟到早退次数： total_dicts = pre_data ['attendance_count'] start_date = start_date.strftime('%Y-%m-%d') end_date = end_date.strftime('%Y-%m-%d') result = {} for employee_id in employee_ids: attendance_info = total_dicts.get(employee_id,{}) number = 0 for day,infos in attendance_info.items(): day = datetime.datetime.strptime(day,'%Y-%m-%d').strftime('%Y-%m-%d') for non,res in infos.items(): if start_date <= day <= end_date: number += res ['late_count'] + res ['leave_early_count'] result [employee_id] = number 旷工次数： total_dicts = pre_data ['attendance_count'] start_date = start_date.strftime('%Y-%m-%d') end_date = end_date.strftime('%Y-%m-%d') result = {} for employee_id in employee_ids: attendance_info = total_dicts.get(employee_id,{}) number = 0 for day,infos in attendance_info.items(): day = datetime.datetime.strptime(day,'%Y-%m-%d').strftime('%Y-%m-%d') for non,res in infos.items(): if start_date <= day <= end_date: number += res ['late_count'] + res ['leave_early_count'] result [employee_id] = number

      增加两个报表项（1）迟到&早退（次）（2）旷工（次）
      逻辑：
      迟到&早退（次）：取所选时间内迟到次数+早退次数的合计；
      旷工（次）：取所选时间内全天均未打卡天数的次数

        1. 所选时间.png
          所选时间.png
          49 kB

            wenqiang.liu 刘文强
            xin.li 李欣
            表决:
            0 为这个问题表决

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