| | |
| | | |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.domain.*; |
| | | import com.ruoyi.domain.ZfCollection; |
| | | import com.ruoyi.domain.dto.zfEventdto; |
| | | import com.ruoyi.mapper.ZfCollectionMapper; |
| | | import com.ruoyi.service.*; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | */ |
| | | @Service |
| | | @Slf4j |
| | | public class ZfCollectionServiceImpl extends ServiceImpl<ZfCollectionMapper, ZfCollection> implements ZfCollectionService { |
| | | public class ZfCollectionServiceImpl extends ServiceImpl<ZfCollectionMapper, ZfCollection> implements ZfCollectionService,ModuleSearchable { |
| | | |
| | | @Resource |
| | | ZfCollectionService zfCollectionService; |
| | | |
| | | |
| | | @Resource |
| | | ZInfoUserService zInfoUserService; |
| | | |
| | |
| | | lqw.like(StringUtils.isNotEmpty(zfCollection.getPrice()),ZfCollection::getPrice,zfCollection.getPrice()); |
| | | lqw.like(StringUtils.isNotEmpty(zfCollection.getLocation()),ZfCollection::getLocation,zfCollection.getLocation()); |
| | | lqw.like(StringUtils.isNotEmpty(zfCollection.getRemark()),ZfCollection::getRemark,zfCollection.getRemark()); |
| | | lqw.in(ZfCollection::getFamilyId,familyIdList); |
| | | lqw.in(familyIdList != null,ZfCollection::getFamilyId,familyIdList); |
| | | lqw.eq(zfCollection.getHappenTime() != null, ZfCollection::getHappenTime, zfCollection.getHappenTime()); |
| | | lqw.between(zfCollection.getHappenStartTime() != null && zfCollection.getHappenEndTime() != null, ZfCollection::getHappenTime, zfCollection.getHappenStartTime(), zfCollection.getHappenEndTime()); |
| | | |
| | | if (StringUtils.isNotEmpty(zfCollection.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfCollection::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfCollection::getIsHide) |
| | | ); |
| | | } |
| | | if (zfCollection.getHasAttachment() != null && zfCollection.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(zfCollection.getCompanionList()),zfCollection::getCompanion,zfCollection.getCompanionList()); |
| | | // if (zfCollection.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfCollection.getYear()); |
| | | // lqw.apply("YEAR(happen_time) = {0}", zfCollection.getYear()); |
| | | // } |
| | | |
| | | if (CollectionUtils.isNotEmpty(zfCollection.getCompanionList())) { |
| | | List<String> companionList = zfCollection.getCompanionList(); |
| | | |
| | | // 清理和去重 |
| | | companionList = companionList.stream() |
| | | .map(String::trim) |
| | | .filter(s -> !s.isEmpty()) |
| | | .distinct() |
| | | .collect(Collectors.toList()); |
| | | |
| | | if (!companionList.isEmpty()) { |
| | | // 确保所有参与人都在companion字段中 |
| | | for (String companion : companionList) { |
| | | lqw.apply("FIND_IN_SET({0}, REPLACE(REPLACE(companion, ' ', ''), ',', ',')) > 0", |
| | | companion); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | return lqw; |
| | | } |
| | | |
| | |
| | | //加上父母家族id |
| | | idList.add(fatherFaId); |
| | | idList.add(motherFaId); |
| | | |
| | | List<Long> fms = zInfoUserService.findByUaidToFaid(myself.getUaid()).stream().map(ZInfoUser::getFamilyId).collect(Collectors.toList()); |
| | | if(!fms.isEmpty()) |
| | | { |
| | | idList.addAll(fms); |
| | | } |
| | | LambdaQueryWrapper<ZfCollection> lambdaQueryWrapper = buildCondition(zfCollection, idList); |
| | | List<ZfCollection> beanRecords = list(lambdaQueryWrapper); |
| | | log.info("从数据库中查到的为:{}", beanRecords); |
| | |
| | | //加上父母家族id |
| | | idList.add(fatherFaId); |
| | | idList.add(motherFaId); |
| | | |
| | | List<Long> fms = zInfoUserService.findByUaidToFaid(myself.getUaid()).stream().map(ZInfoUser::getFamilyId).collect(Collectors.toList()); |
| | | if(!fms.isEmpty()) |
| | | { |
| | | idList.addAll(fms); |
| | | } |
| | | // String familyIds = listFamilyIds(); |
| | | // String secondFamilyAuthority = listSecondFamilyIds(); |
| | | LambdaQueryWrapper<ZfCollection> lqw = buildCondition(zfCollection, idList); |
| | |
| | | return AjaxResult.success(data); |
| | | } |
| | | |
| | | |
| | | |
| | | // @Override |
| | | // public AjaxResult addData2(ZfCollection zfCollection){ |
| | | // ZInfoUser mySelf = getMySelf(); |
| | |
| | | |
| | | } |
| | | |
| | | @Override |
| | | public String getModuleCode() { |
| | | return "收藏"; |
| | | } |
| | | |
| | | @Override |
| | | // @Cacheable(value = "economy_search", key = "T(String).format('2045_%s_%s_%s_%s',#companion != null ? #companion : 'null',#happenStartTime != null ? #happenStartTime.getTime() : 0,#happenEndTime != null ? #happenEndTime.getTime() : 0,#hasAttachment != null ? #hasAttachment : 'null')") |
| | | public List<?> search(String companion, Date happenStartTime,Date happenEndTime,String hasAttachment) { |
| | | ZfCollection zfCollection = new ZfCollection(); |
| | | zfCollection.setCompanion(companion); |
| | | zfCollection.setHappenStartTime(happenStartTime); |
| | | zfCollection.setHappenEndTime(happenEndTime); |
| | | |
| | | String[] split = companion.split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | zfCollection.setCompanionList(list); |
| | | zfCollection.setHasAttachment(hasAttachment); |
| | | zfCollection.setIsHide("否"); |
| | | |
| | | System.out.println("[[[[[[[["+zfCollection); |
| | | |
| | | return dataList(zfCollection); |
| | | } |
| | | |
| | | public List<zfEventdto> dataList(ZfCollection zfCollection) { |
| | | |
| | | LambdaQueryWrapper<ZfCollection> lqw = buildCondition(zfCollection, null); |
| | | |
| | | List<ZfCollection> beanRecords = list(lqw); |
| | | |
| | | |
| | | |
| | | return encapData(beanRecords); |
| | | } |
| | | |
| | | public List<zfEventdto> encapData(List<ZfCollection> lis) |
| | | { |
| | | List<zfEventdto> daoRes = new ArrayList<>() ; |
| | | for(ZfCollection obj : lis) |
| | | { |
| | | zfEventdto atd = new zfEventdto(); |
| | | atd.setId(Math.toIntExact(obj.getId())); |
| | | atd.setModule("收藏"); |
| | | atd.setName(obj.getCompanion()); |
| | | atd.setCreateTime(obj.getCreateTime()); |
| | | daoRes.add(atd); |
| | | } |
| | | return daoRes; |
| | | } |
| | | } |