| | |
|---|
| | | .selectAs(PlatformGroup::getName,Platform::getGroupName) |
|---|
| | | .select(" (select ifnull(TIMESTAMPDIFF(HOUR, '2023-01-01 '||pg.start_time||':00', '2023-01-01 '||pg.end_time||':00' ),0) from platform_group pg " + |
|---|
| | | " where t.group_id = pg.id ) as openTime ") |
|---|
| | | .select(" ( select ROUND( ifnull(SUM(pl.PARAM3),0) / 3600 , 2 ) from platform_log pl where pl.OBJ_ID = t.id and pl.remark = t.id " + |
|---|
| | | " and pl.CREATE_DATE > '"+Utils.Date.getStart(platform.getQueryDateStart())+"' " + |
|---|
| | | "and pl.CREATE_DATE <= '"+Utils.Date.getEnd(platform.getQueryDateEnd())+"' ) as workCountTime ") |
|---|
| | | .select(" ( select ROUND( ifnull(SUM(pl.PARAM3),0) / 3600 , 2 ) from platform_log pl where pl.remark = t.id " + |
|---|
| | | " and pl.CREATE_DATE > '"+DateUtil.getFomartDate(platform.getQueryDateStart(),"yyyy-MM-dd")+" 00:00:00' " + |
|---|
| | | "and pl.CREATE_DATE <= '"+DateUtil.getFomartDate(platform.getQueryDateEnd(),"yyyy-MM-dd")+" 23:59:59' ) as workCountTime ") |
|---|
| | | .leftJoin(PlatformGroup.class,PlatformGroup::getId,Platform::getGroupId); |
|---|
| | | queryWrapper |
|---|
| | | .eq(platform.getGroupId() != null, Platform::getGroupId, platform.getGroupId()) |
|---|
