| | |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | 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.StringUtils; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.domain.*; |
| | | import com.ruoyi.domain.dto.zfEventdto; |
| | | import com.ruoyi.mapper.ZfPropertyMapper; |
| | | import com.ruoyi.service.*; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | */ |
| | | @Slf4j |
| | | @Service |
| | | public class IZfPropertyServiceImpl extends ServiceImpl<ZfPropertyMapper, ZfProperty> implements IZfPropertyService { |
| | | public class IZfPropertyServiceImpl extends ServiceImpl<ZfPropertyMapper, ZfProperty> implements IZfPropertyService,ModuleSearchable { |
| | | |
| | | @Resource |
| | | IZfPropertyService zfPropertyService; |
| | |
| | | .like(!StringUtils.isEmpty(zfProperty.getAddress()), ZfProperty::getAddress, zfProperty.getAddress()) |
| | | .like(!StringUtils.isEmpty(zfProperty.getRemark()), ZfProperty::getRemark, zfProperty.getRemark()) |
| | | .eq(zfProperty.getFamilyId()!=null,ZfProperty::getFamilyId,zfProperty.getFamilyId()) |
| | | .in(ZfProperty::getFamilyId,familyIdList) |
| | | .in(familyIdList!=null,ZfProperty::getFamilyId,familyIdList) |
| | | .eq(zfProperty.getHappenTime()!=null,ZfProperty::getHappenTime,zfProperty.getHappenTime()) |
| | | .between(zfProperty.getHappenStartTime() != null && zfProperty.getHappenEndTime() != null, ZfProperty::getHappenTime, zfProperty.getHappenStartTime(), zfProperty.getHappenEndTime()); |
| | | lqw.orderByDesc(ZfProperty::getCreateTime); |
| | | |
| | | |
| | | if (StringUtils.isNotEmpty(zfProperty.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfProperty::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfProperty::getIsHide) |
| | | ); |
| | | } |
| | | if (zfProperty.getHasAttachment() != null && zfProperty.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(zfEconomy.getCompanionList()),ZfEconomy::getCompanion,zfEconomy.getCompanionList()); |
| | | // if (zfEconomy.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfEconomy.getYear()); |
| | | // lqw.apply("YEAR(happen_time) = {0}", zfEconomy.getYear()); |
| | | // } |
| | | |
| | | if (CollectionUtils.isNotEmpty(zfProperty.getCompanionList())) { |
| | | List<String> companionList = zfProperty.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); |
| | | } |
| | | } |
| | | } |
| | | System.out.println("查询条件: " + lqw.getCustomSqlSegment()); |
| | | return lqw; |
| | | |
| | | } |
| | |
| | | return AjaxResult.success(result); |
| | | } |
| | | |
| | | @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) { |
| | | ZfProperty zfProperty = new ZfProperty(); |
| | | zfProperty.setCompanion(companion); |
| | | zfProperty.setHappenStartTime(happenStartTime); |
| | | zfProperty.setHappenEndTime(happenEndTime); |
| | | |
| | | String[] split = companion.trim().replace(" ", "").replace(",", ",").split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | zfProperty.setCompanionList(list); |
| | | zfProperty.setHasAttachment(hasAttachment); |
| | | zfProperty.setIsHide("否"); |
| | | |
| | | |
| | | return dataList(zfProperty); |
| | | } |
| | | |
| | | public List<zfEventdto> dataList(ZfProperty zfProperty) { |
| | | |
| | | LambdaQueryWrapper<ZfProperty> lqw = buildCondition(zfProperty, null); |
| | | |
| | | List<ZfProperty> beanRecords = list(lqw); |
| | | |
| | | |
| | | |
| | | return encapData(beanRecords); |
| | | } |
| | | |
| | | public List<zfEventdto> encapData(List<ZfProperty> lis) |
| | | { |
| | | List<zfEventdto> daoRes = new ArrayList<>() ; |
| | | for(ZfProperty 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; |
| | | } |
| | | } |
| | | |
| | | |