INSERT INTO dispatch.bill_daily(`id`, `type`, `organization_id`, `created_time`,`date`,`bill_month_id`,`ope_count`,`head_count`) (#{item.id}, #{item.type,typeHandler=org.apache.ibatis.type.EnumOrdinalTypeHandler}, #{item.orgId}, #{item.createdTime}, #{item.date},#{item.monthlyBillId}, #{item.opeCount}, #{item.headCount}) SELECT `organization_id` as orgId, sum(`ope_count`) as count FROM dispatch.bill_daily WHERE date >= #{date} and date < DATE_ADD(#{date},INTERVAL 1 MONTH) AND type = #{type} GROUP BY (`organization_id`) select t.orgId as orgId, concat(t.year,'-',LPAD(t.month,2,'0'),'-01') as billMonth, sum(opeCount) as count FROM ( SELECT a.organization_id as orgId, a.ope_count as opeCount, YEAR(a.date) as year, MONTH(a.date) as month FROM dispatch.bill_daily a WHERE a.organization_id = #{orgId} and a.type = #{type} AND a.date <= #{endDate} AND a.date between #{fromDate} and #{endDate} ) t GROUP BY t.orgId,t.year,t.month SELECT a.organization_id as orgId, DATE(a.created_time) as date, count( DISTINCT a.tenant_employee_id ) as opeCount, count(DISTINCT a.tenant_employee_id) as headCount FROM dispatch.tenant_employee_attendance_records a WHERE a.created_time <= #{endDate} a.created_time between #{fromDate} and #{endDate} and a.organization_id = #{orgId} GROUP BY a.organization_id, DATE(a.created_time) SELECT a.payer_organization_id as orgId, DATE(a.created_time) as date, count( a.id ) as opeCount, count(DISTINCT a.called_employee_id) as headCount FROM dispatch.vga_roll_call_employees a WHERE a.created_time <= #{endDate} a.created_time between #{fromDate} and #{endDate} and a.payer_organization_id = #{orgId} GROUP BY a.payer_organization_id, DATE(a.created_time) SELECT a.payer_organization_id as orgId, DATE(a.created_time) as date, count( a.pk_id ) as opeCount, count(DISTINCT a.reference_number) as headCount FROM dispatch.analytics_log a WHERE a.type = 0 and a.payer_organization_id = #{orgId} AND a.created_time <= #{endDate} AND a.created_time between #{fromDate} and #{endDate} GROUP BY a.payer_organization_id, DATE(a.created_time) SELECT a.payer_organization_id as orgId, DATE(a.created_time) as date, count( a.pk_id ) as opeCount, count(DISTINCT a.reference_number) as headCount FROM dispatch.analytics_log a WHERE a.type = 1 and a.payer_organization_id = #{orgId} AND a.created_time <= #{endDate} AND a.created_time between #{fromDate} and #{endDate} GROUP BY a.payer_organization_id,DATE(a.created_time)