| | |
|---|
| | | .select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 5 order by pl.CREATE_DATE desc limit 1 ) as newStartDate ") |
|---|
| | | .select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 4 order by pl.CREATE_DATE desc limit 1 ) as newCallDate ") |
|---|
| | | .selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName) |
|---|
| | | .selectAs(PlatformBooks::getId,PlatformJob::getBookId) |
|---|
| | | .leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId) |
|---|
| | | .leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode) |
|---|
| | | .leftJoin(PlatformBooks.class,PlatformBooks::getJobId,PlatformJob::getId) |
|---|
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO) |
|---|
| | | .apply(" ( t1.isdeleted = 0 or t.PLATFORM_ID is null ) ") |
|---|
| | | .in(PlatformJob::getStatus, |
|---|
