| | |
| | | } |
| | | if(StringUtils.isBlank(model.getCode()) |
| | | ||model.getType()==null |
| | | ||model.getCateId()==null |
| | | ||model.getType()<0 |
| | | ||model.getType()>3 |
| | | ){ |
| | |
| | | if(StringUtils.isBlank(model.getCode()) |
| | | ||model.getId()==null |
| | | ||model.getType()==null |
| | | ||model.getCateId()==null |
| | | ||model.getType()<0 |
| | | ||model.getType()>3 |
| | | ){ |
| | |
| | | .set(Cars::getAuthStatus,Constants.ZERO) |
| | | .set(Cars::getType,model.getType()) |
| | | .set(Cars::getCode,model.getCode()) |
| | | .set(Cars::getGroupId,model.getGroupId()) |
| | | .set(Cars::getCateId,model.getCateId()) |
| | | .set(Cars::getEditDate,model.getEditDate()) |
| | | .set(Cars::getEdirot,model.getEdirot()) |
| | | .set(Cars::getMemberId,model.getMemberId()) |
| | |
| | | public Cars findById(Integer id) { |
| | | return carsMapper.selectById(id); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | @Override |
| | | public Cars findOne(Cars cars) { |
| | |
| | | queryWrapper.selectAs(SystemUser::getRealname,Cars::getEditorName); |
| | | queryWrapper.selectAs(Member::getPhone,Cars::getMemberPhone); |
| | | queryWrapper.selectAs(Company::getCompanyNamePath,Cars::getCompanyName); |
| | | queryWrapper.selectAs(Category::getParentId,Cars::getCatePId); |
| | | queryWrapper.selectAs(Category::getName,Cars::getCateName); |
| | | queryWrapper.select(" c.name as catePName"); |
| | | queryWrapper.select(" c1.COMPANY_NAME_PATH as carCompanyNamePath"); |
| | | queryWrapper.select(" c1.name as carCompanyName"); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,Cars::getMemberId); |
| | | queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Cars::getEdirot); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
| | | queryWrapper.leftJoin(Category.class,Category::getId,Cars::getCateId); |
| | | queryWrapper.leftJoin("category c on t4.PARENT_ID = c.id"); |
| | | queryWrapper.leftJoin("company c1 on t.GROUP_ID = c1.id"); |
| | | queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getMemberName()), ms->ms.like(Member::getName,pageWrap.getModel().getMemberName()) |
| | | .or().like(Member::getPhone,pageWrap.getModel().getMemberName())); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Company::getCompanyNamePath,pageWrap.getModel().getCompanyName()); |