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

【和黄药业】设计报表出汇总数据

XMLWord打印

    • Icon: 技术问题 技术问题
    • 解决结果: 完成
    • Icon: High High
    • 202103
    • 202103
    • H-和黄药业-Y2019081
    • PRO
    • hryl-uat
    • 基础通用功能
    • 隐藏

      sql:
      SELECT
      employee_id x_employee_id,
      to_char(schedule_date,'YYYY-MM') x_schedule_date,
      sum(case when product_uom.name='Day(s)' then leave_detail_view.duration when product_uom.name='Hour(s)' then leave_detail_view.duration/8.0 else 0 end) x_total_duration
      FROM leave_detail_view
      left join product_uom
      on leave_detail_view.product_uom_id=product_uom.id
      left join hr_holiday_type on leave_detail_view.leave_type=hr_holiday_type.id
      where
      to_char(leave_detail_view.schedule_date,'YYYY-MM')=to_char(current_date::timestamp + '-1 month','YYYY-MM')
      and
      hr_holiday_type.code in ('L006','L007','L011','L017')
      group by x_schedule_date,employee_id
      having
      sum(case when product_uom.name='Day(s)' then leave_detail_view.duration when product_uom.name='Hour(s)' then leave_detail_view.duration/8.0 else 0 end) >=5

      显示
      sql: SELECT employee_id x_employee_id, to_char(schedule_date,'YYYY-MM') x_schedule_date, sum(case when product_uom.name='Day(s)' then leave_detail_view.duration when product_uom.name='Hour(s)' then leave_detail_view.duration/8.0 else 0 end) x_total_duration FROM leave_detail_view left join product_uom on leave_detail_view.product_uom_id=product_uom.id left join hr_holiday_type on leave_detail_view.leave_type=hr_holiday_type.id where to_char(leave_detail_view.schedule_date,'YYYY-MM')=to_char(current_date::timestamp + '-1 month','YYYY-MM') and hr_holiday_type.code in ('L006','L007','L011','L017') group by x_schedule_date,employee_id having sum(case when product_uom.name='Day(s)' then leave_detail_view.duration when product_uom.name='Hour(s)' then leave_detail_view.duration/8.0 else 0 end) >=5

      按自然月统计上月 事假、病假、产假、流产假 合计值 >5天的员工名单
      字段：employee_id、员工编号，姓名、假期合计、月份（格式yyyymm）

        1. image.png
          image.png
          166 kB

            grant.yang 杨光磊
            jason.zhou 周子深
            表决:
            0 为这个问题表决

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