| | |
| | | company.setHkDate(company.getCreateDate()); |
| | | company.setEditDate(company.getCreateDate()); |
| | | company.setEditor(company.getCreator()); |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | company.setHkId(UUID.randomUUID().toString().replace("-","")); |
| | | companyMapper.insert(company); |
| | | //下发海康安防平台 |
| | |
| | | insert.setCode(company.getCode()); |
| | | insert.setParentId(company.getParentId()); |
| | | insert.setLinkName(company.getLinkName()); |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | insert.setLinkPhone(company.getLinkPhone()); |
| | | companyMapper.insert(insert); |
| | | return insert.getId(); |
| | |
| | | company.setHkDate(company.getHkDate()); |
| | | company.setHkId(StringUtils.defaultString(model.getHkId(),UUID.randomUUID().toString().replace("-",""))); |
| | | company.setParentId(null);//不支持修改父级 |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | companyMapper.updateById(company); |
| | | //更新的companyPath |
| | | String newName = model.getCompanyNamePath().replace(model.getName(),company.getName()); |
| | |
| | | if (company.getQueryHiddenDanger() != null && Constants.equalsInteger(company.getQueryHiddenDanger(),Constants.ONE)) { |
| | | queryWrapper.apply(" t.id in ( select hdp.COMPANY_ID from hidden_danger_param hdp where hdp.ISDELETED = 0 and hdp.STATUS = 0 and hdp.TYPE = 0 ) "); |
| | | } |
| | | queryWrapper.orderByDesc(Company::getCreateDate); |
| | | queryWrapper.orderByAsc(Company::getPinyin); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Company::getParentId); |
| | | queryWrapper.select(" t.* ") |
| | | .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) as countNum") ; |
| | |
| | | queryWrapper.ge(Company::getFsDate, Utils.Date.getStart(pageWrap.getModel().getFsDate())); |
| | | queryWrapper.le(Company::getFsDate, Utils.Date.getEnd(pageWrap.getModel().getFsDate())); |
| | | } |
| | | queryWrapper.orderByDesc(Company::getCreateDate); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Company::getParentId); |
| | | /* .leftJoin(Member.class, Member::getId,Company::getHeadId)*/ |
| | | /* queryWrapper.leftJoin(" company c on c.id=t.parent_id");*/ |
| | |
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getStatus()),Company::getStatus,Constants.ZERO); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Company::getName,pageWrap.getModel().getName()); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getParentName()),"c.name",pageWrap.getModel().getParentName()); |
| | | queryWrapper.orderByAsc(Company::getPinyin); |
| | | IPage<Company> companyIPage = companyJoinMapper.selectJoinPage(page, Company.class, queryWrapper); |
| | | return PageData.from(companyIPage); |
| | | } |
| | |
| | | LambdaQueryWrapper<Company> wrapper = new LambdaQueryWrapper<>(); |
| | | |
| | | wrapper.eq(Company::getIsdeleted,Constants.ZERO) |
| | | .eq(Constants.equalsInteger(type,Constants.ONE),Company::getType,type); |
| | | .eq(Constants.equalsInteger(type,Constants.ONE),Company::getType,type) |
| | | .orderByAsc(Company::getPinyin); |
| | | List<Company> companies = companyMapper.selectList(wrapper); |
| | | return getCompanyTree( companies, null); |
| | | } |
| | |
| | | if (CollectionUtils.isEmpty(companies)){ |
| | | return; |
| | | } |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | //新增的情况存在记录 |
| | | if (Objects.isNull(company.getId())){ |
| | | throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"公司名称已存在"); |