|  |  |  | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if(StringUtils.isBlank(model.getCode()) | 
|---|
|  |  |  | ||model.getType()==null | 
|---|
|  |  |  | ||model.getCateId()==null | 
|---|
|  |  |  | ||model.getType()<0 | 
|---|
|  |  |  | ||model.getType()>3 | 
|---|
|  |  |  | ){ | 
|---|
|  |  |  | throw  new BusinessException(ResponseStatus.BAD_REQUEST); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | if(model.getMemberId()!=null){ | 
|---|
|  |  |  | //检查车主信息 | 
|---|
|  |  |  | Member member =memberMapper.selectOne(new QueryWrapper<Member>().lambda() | 
|---|
|  |  |  | 
|---|
|  |  |  | } | 
|---|
|  |  |  | model.setMemberHkId(member.getHkId()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if(!Constants.checkCarNo(model.getCode())){ | 
|---|
|  |  |  | throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"请输入正确的车牌!"); | 
|---|
|  |  |  | }; | 
|---|
|  |  |  |  | 
|---|
|  |  |  | //检查车牌号是否重复 | 
|---|
|  |  |  | if(carsMapper.selectCount(new QueryWrapper<Cars>().lambda() | 
|---|
|  |  |  | .eq(Cars::getCode,model.getCode() ) | 
|---|
|  |  |  | 
|---|
|  |  |  | if(StringUtils.isBlank(model.getCode()) | 
|---|
|  |  |  | ||model.getId()==null | 
|---|
|  |  |  | ||model.getType()==null | 
|---|
|  |  |  | ||model.getCateId()==null | 
|---|
|  |  |  | ||model.getType()<0 | 
|---|
|  |  |  | ||model.getType()>3 | 
|---|
|  |  |  | ){ | 
|---|
|  |  |  | 
|---|
|  |  |  | Cars car = carJoinMapper.selectById(model.getId()); | 
|---|
|  |  |  | if(car ==null ||Constants.equalsInteger(car.getIsdeleted(),Constants.ONE)){ | 
|---|
|  |  |  | throw  new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,车辆信息不存在!"); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if(!Constants.checkCarNo(model.getCode())){ | 
|---|
|  |  |  | throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"请输入正确的车牌!"); | 
|---|
|  |  |  | }; | 
|---|
|  |  |  | if(model.getMemberId()!=null){ | 
|---|
|  |  |  | //检查车主信息 | 
|---|
|  |  |  | Member member =memberMapper.selectOne(new QueryWrapper<Member>().lambda() | 
|---|
|  |  |  | 
|---|
|  |  |  | .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()); | 
|---|
|  |  |  | 
|---|
|  |  |  | queryWrapper.eq(pageWrap.getModel().getType()!=null,Cars::getType,pageWrap.getModel().getType()); | 
|---|
|  |  |  | queryWrapper.eq(pageWrap.getModel().getAuthStatus()!=null,Cars::getAuthStatus,pageWrap.getModel().getAuthStatus()); | 
|---|
|  |  |  | queryWrapper.orderByDesc(Cars::getCreateDate); | 
|---|
|  |  |  | //数据权限开始--------------------start---------------- | 
|---|
|  |  |  | LoginUserInfo userInfo =pageWrap.getModel().getLoginUserInfo(); | 
|---|
|  |  |  | if(userInfo!=null && userInfo.getCompanyIdList()!=null){ | 
|---|
|  |  |  | if(  userInfo.getCompanyIdList().size() ==0){ | 
|---|
|  |  |  | //只能看自己(拜访人) | 
|---|
|  |  |  | queryWrapper.eq(Cars::getMemberId,userInfo.getMemberId()); | 
|---|
|  |  |  | }else{ | 
|---|
|  |  |  | queryWrapper.in(Cars::getGroupId ,userInfo.getCompanyIdList()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | } | 
|---|
|  |  |  | //数据权限开始--------------------end---------------- | 
|---|
|  |  |  |  | 
|---|
|  |  |  | IPage<Cars> result = carJoinMapper.selectJoinPage(page, Cars.class,queryWrapper); | 
|---|
|  |  |  | if(result!=null && result.getRecords()!=null && result.getRecords().size()>0){ | 
|---|
|  |  |  | List<String> codes = new ArrayList<>(); | 
|---|