| | |
|---|
| | | JkKeys model = pageWrap.getModel(); |
|---|
| | | MPJLambdaWrapper<JkKeys> wrapper = new MPJLambdaWrapper<JkKeys>() |
|---|
| | | .selectAll(JkKeys.class) |
|---|
| | | .selectAs(JkCabinetGrid::getCode,JkKeys::getGridCode) |
|---|
| | | .selectAs(JkCabinet::getName,JkKeys::getCabinetName) |
|---|
| | | .select("j.code",JkKeys::getGridCode) |
|---|
| | | .select("j1.name",JkKeys::getCabinetName) |
|---|
| | | .leftJoin(Cars.class,Cars::getId,JkKeys::getCarId) |
|---|
| | | .leftJoin(JkCabinetGrid.class,JkCabinetGrid::getKeyId,JkKeys::getId) |
|---|
| | | .leftJoin(JkCabinet.class,JkCabinet::getId,JkCabinetGrid::getCabinetId) |
|---|
| | | .leftJoin(" jk_cabinet_grid j on j.key_id = t.id and j.isdeleted = 0 ") |
|---|
| | | .leftJoin(" jk_cabinet j1 on j.CABINET_ID = j1.id ") |
|---|
| | | .eq(JkKeys::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO) |
|---|
| | | // .eq(JkCabinetGrid::getIsdeleted,Constants.ZERO) |
|---|
| | | .like(StringUtils.isNotBlank(model.getCode()),JkKeys::getCode,model.getCode()) |
|---|
| | | .like(StringUtils.isNotBlank(model.getCarCode()),JkKeys::getCarCode,model.getCode()); |
|---|
| | | IPage<JkKeys> iPage = jkKeysMapper.selectJoinPage(page,JkKeys.class,wrapper); |
|---|
