| | |
| | | queryWrapper.select("t1.phone",CarUseBook::getMemberPhone); |
| | | queryWrapper.select("t2.name",CarUseBook::getDriverName); |
| | | queryWrapper.select("t2.phone",CarUseBook::getDriverPhone); |
| | | queryWrapper.select("t4.company_name_path",CarUseBook::getCompanyName); |
| | | // queryWrapper.select("t4.company_name_path",CarUseBook::getCompanyName); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,CarUseBook::getMemberId) |
| | | .leftJoin(Member.class,Member::getId,CarUseBook::getDriverId) |
| | | .leftJoin("company t4 on t1.company_id=t4.id") |
| | | // .leftJoin("company t4 on t1.company_id=t4.id") |
| | | .eq(CarUseBook::getId,id) |
| | | .last("limit 1" ); |
| | | CarUseBook model = carUseBookMapper.selectJoinOne(CarUseBook.class,queryWrapper); |