| | |
|---|
| | | .selectAs(YwPatrolPoint::getName,YwPatrolTaskRecord::getPointName) |
|---|
| | | .selectAs(YwPatrolPoint::getContent,YwPatrolTaskRecord::getContent) |
|---|
| | | .selectAs(SystemUser::getRealname,YwPatrolTaskRecord::getRealname) |
|---|
| | | |
|---|
| | | .selectAs(YwPatrolScheme::getTitle,YwPatrolTaskRecord::getSchemeTitle) |
|---|
| | | .selectAs(YwPatrolTask::getTitle,YwPatrolTaskRecord::getTaskCode) |
|---|
| | | .selectAs(YwPatrolTask::getStartDate,YwPatrolTaskRecord::getStartDate) |
|---|
| | | .selectAs(YwPatrolTask::getEndDate,YwPatrolTaskRecord::getEndDate) |
|---|
| | | |
|---|
| | | .leftJoin(YwPatrolPoint.class,YwPatrolPoint::getId,YwPatrolTaskRecord::getPointId) |
|---|
| | | .leftJoin(SystemUser.class,SystemUser::getId,YwPatrolTaskRecord::getDealUserId) |
|---|
| | | .leftJoin(YwPatrolTask.class,YwPatrolTask::getId,YwPatrolTaskRecord::getTaskId) |
|---|
| | | .leftJoin(YwPatrolScheme.class,YwPatrolScheme::getId,YwPatrolTask::getSchemeId) |
|---|
| | | .eq(YwPatrolScheme::getIsdeleted, Constants.ZERO) |
|---|
| | | .eq(Objects.nonNull(model) && Objects.nonNull(model.getTaskId()),YwPatrolTaskRecord::getTaskId, model.getTaskId()) |
|---|
| | | .eq(Objects.nonNull(model) && Objects.nonNull(model.getDealUserId()),YwPatrolTaskRecord::getDealUserId, model.getDealUserId()) |
|---|
| | | .like(StringUtils.isNotBlank(model.getPointName()),YwPatrolPoint::getName,model.getPointName()) |
|---|
| | | .eq(Objects.nonNull(model) && Objects.nonNull(model.getStatus()) , YwPatrolTaskRecord::getStatus,model.getStatus()) |
|---|
| | | .eq(Objects.nonNull(model) && Objects.nonNull(model.getDeviceId()) , YwPatrolPoint::getDeviceId,model.getDeviceId()) |
|---|
| | | .orderByDesc(YwPatrolScheme::getCreateDate) |
|---|
| | | ; |
|---|
| | | IPage<YwPatrolTaskRecord> iPage = ywPatrolTaskRecordMapper.selectJoinPage(page,YwPatrolTaskRecord.class,queryWrapper); |
|---|
