| | |
| | | import com.ruoyi.service.PeopleSearchService; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import javax.annotation.Resource; |
| | | |
| | | import static com.ruoyi.common.core.page.TableSupport.PAGE_NUM; |
| | | import static com.ruoyi.common.core.page.TableSupport.PAGE_SIZE; |
| | |
| | | |
| | | |
| | | @GetMapping("/all") |
| | | public AjaxResult listAll(PeopleSea peopleSea){ |
| | | public AjaxResult listAll(@RequestBody PeopleSea peopleSea){ |
| | | Integer pageNum = Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1); |
| | | Integer pageSize = Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10); |
| | | System.out.println(peopleSearchService); |
| | |
| | | package com.ruoyi.domain; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import java.time.LocalDateTime; |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | |
| | | |
| | | /** |
| | | * <p> |
| | | * |
| | | * |
| | | * </p> |
| | | * |
| | | * @author ojq |
| | |
| | | */ |
| | | private Integer shareId; |
| | | |
| | | /** |
| | | * 参与者 |
| | | */ |
| | | private String companion; |
| | | |
| | | /** |
| | | * 参与者列表 |
| | | */ |
| | | @TableField(exist = false) |
| | | private List<String> companionList; |
| | | |
| | | // @TableField(exist = false) |
| | | // private Integer year; |
| | | |
| | | /** |
| | | * 是否有附件 |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | |
| | | } |
| | |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | */ |
| | | private Integer shareId; |
| | | |
| | | /** |
| | | * 参与者 |
| | | */ |
| | | private String companion; |
| | | |
| | | /** |
| | | * 参与者列表 |
| | | */ |
| | | @TableField(exist = false) |
| | | private List<String> companionList; |
| | | |
| | | // @TableField(exist = false) |
| | | // private Integer year; |
| | | |
| | | /** |
| | | * 是否有附件 |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | } |
| | |
| | | import java.io.Serializable; |
| | | import java.time.LocalDateTime; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * <p> |
| | | * |
| | | * |
| | | * </p> |
| | | * |
| | | * @author ojq |
| | |
| | | */ |
| | | private Integer shareId; |
| | | |
| | | /** |
| | | * 参与者 |
| | | */ |
| | | private String companion; |
| | | |
| | | /** |
| | | * 参与者列表 |
| | | */ |
| | | @TableField(exist = false) |
| | | private List<String> companionList; |
| | | |
| | | // @TableField(exist = false) |
| | | // private Integer year; |
| | | |
| | | /** |
| | | * 是否有附件 |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | |
| | | } |
| | |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | } |
| | |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | } |
| | |
| | | import java.io.Serializable; |
| | | import java.time.LocalDateTime; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * <p> |
| | | * |
| | | * |
| | | * </p> |
| | | * |
| | | * @author ojq |
| | |
| | | */ |
| | | private Integer shareId; |
| | | |
| | | /** |
| | | * 参与者 |
| | | */ |
| | | private String companion; |
| | | |
| | | /** |
| | | * 参与者列表 |
| | | */ |
| | | @TableField(exist = false) |
| | | private List<String> companionList; |
| | | |
| | | // @TableField(exist = false) |
| | | // private Integer year; |
| | | |
| | | /** |
| | | * 是否有附件 |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | |
| | | |
| | | } |
| | |
| | | import java.io.Serializable; |
| | | import java.time.LocalDateTime; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | */ |
| | | private Integer shareId; |
| | | |
| | | /** |
| | | * 是否有附件 |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 参与者列表 |
| | | */ |
| | | @TableField(exist = false) |
| | | private List<String> companionList; |
| | | |
| | | } |
| | |
| | | import java.io.Serializable; |
| | | import java.time.LocalDate; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | */ |
| | | private Integer shareId; |
| | | |
| | | /** |
| | | * 参与者 |
| | | */ |
| | | private String companion; |
| | | |
| | | /** |
| | | * 参与者列表 |
| | | */ |
| | | @TableField(exist = false) |
| | | private List<String> companionList; |
| | | |
| | | // @TableField(exist = false) |
| | | // private Integer year; |
| | | |
| | | /** |
| | | * 是否有附件 |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | |
| | | } |
| | |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | |
| | | /** |
| | |
| | | |
| | | private Integer shareId; |
| | | |
| | | /** |
| | | * 参与者 |
| | | */ |
| | | private String companion; |
| | | |
| | | /** |
| | | * 参与者列表 |
| | | */ |
| | | @TableField(exist = false) |
| | | private List<String> companionList; |
| | | |
| | | // @TableField(exist = false) |
| | | // private Integer year; |
| | | |
| | | /** |
| | | * 是否有附件 |
| | | */ |
| | | @TableField(exist = false) |
| | | private String hasAttachment; |
| | | |
| | | |
| | | /** |
| | | * 是否隐藏 |
| | | */ |
| | | private String isHide; |
| | | |
| | | } |
| | |
| | | |
| | | 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; |
| | |
| | | |
| | | @Resource |
| | | ZfPropertyMapper zfPropertyMapper; |
| | | |
| | | |
| | | @Resource |
| | | EsService esService; |
| | | |
| | | |
| | | @Resource |
| | | RestHighLevelClient restHighLevelClient; |
| | | |
| | |
| | | .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; |
| | | |
| | | } |
| | |
| | | esModel.setRemark(zfProperty.getRemark()); |
| | | //这里存储查询详情的路径 |
| | | esService.insertTable(esModel); |
| | | |
| | | |
| | | return AjaxResult.success(); |
| | | } else { |
| | | return AjaxResult.error(); |
| | |
| | | }else { |
| | | newModel.setBy6(dataById.getAddress()); |
| | | } |
| | | |
| | | |
| | | if(zfProperty.getRemark()!=null){ |
| | | newModel.setRemark(zfProperty.getRemark()); |
| | | }else { |
| | |
| | | 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; |
| | | } |
| | | } |
| | | |
| | | |
| | |
| | | @Async |
| | | public CompletableFuture<ModuleSearchResult> searchModuleAsync(String moduleCode, ModuleSearchable service, |
| | | String companion, Date startTime, Date endTime, |
| | | String hasAttachment, Integer pageNum, Integer pageSize) { |
| | | String hasAttachment) { |
| | | long start = System.currentTimeMillis(); |
| | | try { |
| | | // 调用搜索方法,返回 List<?> |
| | |
| | | } |
| | | |
| | | // 并发搜索 |
| | | Integer finalPageNum = pageNum; |
| | | Integer finalPageSize = pageSize; |
| | | |
| | | List<CompletableFuture<ModuleSearchResult>> futures = moduleCodes.stream() |
| | | .map(code -> searchModuleAsync(code, moduleSearchMap.get(code), |
| | | companion, startTime, endTime, hasAttachment, finalPageNum, finalPageSize)) |
| | | companion, startTime, endTime, hasAttachment)) |
| | | .collect(Collectors.toList()); |
| | | |
| | | // 等待完成 |
| | |
| | | |
| | | |
| | | 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.MapUtils; |
| | | import com.ruoyi.domain.TravelCount; |
| | | import com.ruoyi.domain.TravelDetail; |
| | | import com.ruoyi.domain.ZInfoUser; |
| | | import com.ruoyi.domain.ZProperty; |
| | | import com.ruoyi.common.utils.StringUtils; |
| | | import com.ruoyi.domain.*; |
| | | import com.ruoyi.domain.dto.zfEventdto; |
| | | import com.ruoyi.mapper.TravelCountMapper; |
| | | import com.ruoyi.service.ModuleSearchable; |
| | | import com.ruoyi.service.TravelCountService; |
| | | import com.ruoyi.service.TravelDetailService; |
| | | import com.ruoyi.service.ZInfoUserService; |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.text.DecimalFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.stream.Collectors; |
| | | |
| | |
| | | * @since 2023-10-06 |
| | | */ |
| | | @Service |
| | | public class TravelCountServiceImpl extends ServiceImpl<TravelCountMapper, TravelCount> implements TravelCountService { |
| | | public class TravelCountServiceImpl extends ServiceImpl<TravelCountMapper, TravelCount> implements TravelCountService, ModuleSearchable { |
| | | |
| | | @Autowired |
| | | private TravelDetailService travelDetailService; |
| | |
| | | DecimalFormat df = new DecimalFormat("0.00"); |
| | | travelCount.setTotalPrice(Double.parseDouble(df.format(entranceTotal+eatTotal+travelCount.getGroupTotal()+stayTotal+travelTotal))); |
| | | } |
| | | |
| | | |
| | | private LambdaQueryWrapper<TravelCount> buildCondition(TravelCount travelCount, List<Long> familyIdList) { |
| | | LambdaQueryWrapper<TravelCount> lqw = new LambdaQueryWrapper<>(); |
| | | lqw.orderByDesc(TravelCount::getCreateTime); |
| | | |
| | | if (StringUtils.isNotEmpty(travelCount.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(TravelCount::getIsHide, "是") |
| | | .or() |
| | | .isNull(TravelCount::getIsHide) |
| | | ); |
| | | } |
| | | if (travelCount.getHasAttachment() != null && travelCount.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(travelCount.getCompanionList()),travelCount::getCompanion,travelCount.getCompanionList()); |
| | | // if (travelCount.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+travelCount.getYear()); |
| | | // lqw.apply("YEAR(happen_time) = {0}", travelCount.getYear()); |
| | | // } |
| | | |
| | | if (CollectionUtils.isNotEmpty(travelCount.getCompanionList())) { |
| | | List<String> companionList = travelCount.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; |
| | | } |
| | | |
| | | @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) { |
| | | TravelCount travelCount = new TravelCount(); |
| | | travelCount.setCompanion(companion); |
| | | |
| | | |
| | | String[] split = companion.split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | travelCount.setCompanionList(list); |
| | | travelCount.setHasAttachment(hasAttachment); |
| | | travelCount.setIsHide("否"); |
| | | |
| | | System.out.println("[[[[[[[["+travelCount); |
| | | |
| | | return dataList(travelCount); |
| | | } |
| | | |
| | | public List<zfEventdto> dataList(TravelCount travelCount) { |
| | | |
| | | LambdaQueryWrapper<TravelCount> lqw = buildCondition(travelCount, null); |
| | | |
| | | List<TravelCount> beanRecords = list(lqw); |
| | | |
| | | |
| | | |
| | | return encapData(beanRecords); |
| | | } |
| | | |
| | | public List<zfEventdto> encapData(List<TravelCount> lis) |
| | | { |
| | | List<zfEventdto> daoRes = new ArrayList<>() ; |
| | | for(TravelCount 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; |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | |
| | | 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.domain.*; |
| | | |
| | | import com.ruoyi.domain.ZfClean; |
| | | import com.ruoyi.domain.dto.zfEventdto; |
| | | import com.ruoyi.mapper.ZfCleanMapper; |
| | | import com.ruoyi.service.*; |
| | | |
| | |
| | | */ |
| | | @Service |
| | | @Slf4j |
| | | public class ZfCleanServiceImpl extends ServiceImpl<ZfCleanMapper, ZfClean> implements ZfCleanService { |
| | | public class ZfCleanServiceImpl extends ServiceImpl<ZfCleanMapper, ZfClean> implements ZfCleanService,ModuleSearchable { |
| | | |
| | | @Resource |
| | | ZInfoUserService zInfoUserService; |
| | |
| | | |
| | | @Resource |
| | | ZfLogService zfLogService; |
| | | |
| | | |
| | | @Resource |
| | | EsService esService; |
| | | |
| | | |
| | | @Resource |
| | | RestHighLevelClient restHighLevelClient; |
| | | |
| | |
| | | .like(StringUtils.isNotEmpty(zfClean.getLocation()), ZfClean::getLocation, zfClean.getLocation()) |
| | | .like(StringUtils.isNotEmpty(zfClean.getRemark()), ZfClean::getRemark, zfClean.getRemark()) |
| | | .eq(zfClean.getHappenTime() != null, ZfClean::getHappenTime, zfClean.getHappenTime()) |
| | | .in(ZfClean::getFamilyId,familyIdList) |
| | | .in(familyIdList != null,ZfClean::getFamilyId,familyIdList) |
| | | .between(zfClean.getHappenStartTime() != null && zfClean.getHappenEndTime() != null, ZfClean::getHappenTime, zfClean.getHappenStartTime(), zfClean.getHappenEndTime()); |
| | | if (StringUtils.isNotEmpty(zfClean.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfClean::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfClean::getIsHide) |
| | | ); |
| | | } |
| | | if (zfClean.getHasAttachment() != null && zfClean.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(zfClean.getCompanionList()),zfClean::getCompanion,zfClean.getCompanionList()); |
| | | // if (zfClean.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfClean.getYear()); |
| | | // lqw.apply("YEAR(happen_time) = {0}", zfClean.getYear()); |
| | | // } |
| | | |
| | | if (CollectionUtils.isNotEmpty(zfClean.getCompanionList())) { |
| | | List<String> companionList = zfClean.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); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | lqw.eq(zfClean.getHappenTime() != null, ZfClean::getHappenTime, zfClean.getHappenTime()); |
| | | |
| | | return lqw; |
| | | } |
| | | |
| | |
| | | esModel.setFid(familyId); |
| | | //这里存储查询详情的路径 |
| | | esService.insertTable(esModel); |
| | | |
| | | |
| | | |
| | | |
| | | return AjaxResult.success(); |
| | | } else { |
| | | return AjaxResult.error(); |
| | |
| | | } |
| | | |
| | | |
| | | @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) { |
| | | ZfClean zfClean = new ZfClean(); |
| | | zfClean.setCompanion(companion); |
| | | zfClean.setHappenStartTime(happenStartTime); |
| | | zfClean.setHappenEndTime(happenEndTime); |
| | | |
| | | String[] split = companion.split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | zfClean.setCompanionList(list); |
| | | zfClean.setHasAttachment(hasAttachment); |
| | | zfClean.setIsHide("否"); |
| | | |
| | | System.out.println("[[[[[[[["+zfClean); |
| | | |
| | | return dataList(zfClean); |
| | | } |
| | | |
| | | public List<zfEventdto> dataList(ZfClean zfClean) { |
| | | |
| | | LambdaQueryWrapper<ZfClean> lqw = buildCondition(zfClean, null); |
| | | |
| | | List<ZfClean> beanRecords = list(lqw); |
| | | |
| | | |
| | | |
| | | return encapData(beanRecords); |
| | | } |
| | | |
| | | public List<zfEventdto> encapData(List<ZfClean> lis) |
| | | { |
| | | List<zfEventdto> daoRes = new ArrayList<>() ; |
| | | for(ZfClean 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; |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | |
| | | 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; |
| | | } |
| | | |
| | |
| | | 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; |
| | | } |
| | | } |
| | |
| | | .like(StringUtils.isNotEmpty(zfDoctor.getWmedical()), ZfDoctor::getWmedical, zfDoctor.getWmedical()) |
| | | .like(StringUtils.isNotEmpty(zfDoctor.getCmedical()), ZfDoctor::getCmedical, zfDoctor.getCmedical()) |
| | | .like(StringUtils.isNotEmpty(zfDoctor.getRemark()), ZfDoctor::getRemark, zfDoctor.getRemark()); |
| | | |
| | | if (StringUtils.isNotEmpty(zfDoctor.getIsHide())) { |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfDoctor::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfDoctor::getIsHide) |
| | | ); |
| | | } |
| | | if (zfDoctor.getHasAttachment() != null && zfDoctor.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | }// lqw.like(StringUtils.isNotEmpty(zfDoctor.getCompanion()),ZfDoctor::getCompanion,zfDoctor.getCompanion()); |
| | |
| | | zfDoctor.setCompanionList(list); zfDoctor.setHappenStartTime(happenStartTime); |
| | | zfDoctor.setHappenEndTime(happenEndTime); |
| | | zfDoctor.setHasAttachment(hasAttachment); |
| | | zfDoctor.setIsHide("否"); |
| | | return doctorList(zfDoctor); |
| | | } |
| | | |
| | |
| | | lqw.like(StringUtils.isNotEmpty(zfEconomy.getUsePeople()),ZfEconomy::getUsePeople,zfEconomy.getUsePeople()); |
| | | lqw.like(StringUtils.isNotEmpty(zfEconomy.getBalance()),ZfEconomy::getBalance,zfEconomy.getBalance()); |
| | | lqw.like(StringUtils.isNotEmpty(zfEconomy.getRemark()),ZfEconomy::getRemark,zfEconomy.getRemark()); |
| | | |
| | | if (StringUtils.isNotEmpty(zfEconomy.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfEconomy::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfEconomy::getIsHide) |
| | | ); |
| | | } |
| | | if (zfEconomy.getHasAttachment() != null && zfEconomy.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | |
| | | String[] split = companion.split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | System.out.println("[[[[[[[["+hasAttachment); |
| | | zfEconomy.setCompanionList(list); |
| | | zfEconomy.setHasAttachment(hasAttachment); |
| | | zfEconomy.setIsHide("否"); |
| | | |
| | | System.out.println("[[[[[[[["+zfEconomy); |
| | | |
| | | return dataList(zfEconomy); |
| | | } |
| | | |
| | |
| | | |
| | | |
| | | 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.ZfEquipment; |
| | | import com.ruoyi.domain.dto.zfEventdto; |
| | | import com.ruoyi.mapper.ZfEquipmentMapper; |
| | | import com.ruoyi.service.*; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | */ |
| | | @Service |
| | | @Slf4j |
| | | public class ZfEquipmentServiceImpl extends ServiceImpl<ZfEquipmentMapper, ZfEquipment> implements ZfEquipmentService { |
| | | public class ZfEquipmentServiceImpl extends ServiceImpl<ZfEquipmentMapper, ZfEquipment> implements ZfEquipmentService ,ModuleSearchable{ |
| | | @Resource |
| | | ZInfoUserService zInfoUserService; |
| | | |
| | |
| | | lqw.like(StringUtils.isNotEmpty(zfEquipment.getLocation()), ZfEquipment::getLocation, zfEquipment.getLocation()); |
| | | lqw.like(StringUtils.isNotEmpty(zfEquipment.getRemark()), ZfEquipment::getRemark, zfEquipment.getRemark()); |
| | | lqw.eq(zfEquipment.getHappenTime() != null, ZfEquipment::getHappenTime, zfEquipment.getHappenTime()); |
| | | lqw.in(ZfEquipment::getFamilyId,familyIdList); |
| | | lqw.in(familyIdList != null,ZfEquipment::getFamilyId,familyIdList); |
| | | lqw.between(zfEquipment.getHappenStartTime() != null && zfEquipment.getHappenEndTime() != null, ZfEquipment::getHappenTime, zfEquipment.getHappenStartTime(), zfEquipment.getHappenEndTime()); |
| | | |
| | | if (StringUtils.isNotEmpty(zfEquipment.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfEquipment::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfEquipment::getIsHide) |
| | | ); |
| | | } |
| | | if (zfEquipment.getHasAttachment() != null && zfEquipment.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(zfEquipment.getCompanionList()),zfEquipment::getCompanion,zfEquipment.getCompanionList()); |
| | | // if (zfEquipment.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfEquipment.getYear()); |
| | | // lqw.apply("YEAR(happen_time) = {0}", zfEquipment.getYear()); |
| | | // } |
| | | |
| | | if (CollectionUtils.isNotEmpty(zfEquipment.getCompanionList())) { |
| | | List<String> companionList = zfEquipment.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); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | lqw.eq(zfEquipment.getHappenTime() != null, ZfEquipment::getHappenTime, zfEquipment.getHappenTime()); |
| | | |
| | | |
| | | return lqw; |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | // //------------------------------------------------------------------------------------------ |
| | | // private LambdaQueryWrapper<ZfEquipment> buildCondition(ZfEquipment zfEquipment, String familyIds, String secondFamilyAuthority) { |
| | | // //模糊查询的条件 |
| | |
| | | esModel.setFid(familyId); |
| | | //这里存储查询详情的路径 |
| | | esService.insertTable(esModel); |
| | | |
| | | |
| | | return AjaxResult.success(); |
| | | } else { |
| | | return AjaxResult.error(); |
| | |
| | | }else { |
| | | return AjaxResult.error(); |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | @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) { |
| | | ZfEquipment zfEquipment = new ZfEquipment(); |
| | | zfEquipment.setCompanion(companion); |
| | | zfEquipment.setHappenStartTime(happenStartTime); |
| | | zfEquipment.setHappenEndTime(happenEndTime); |
| | | |
| | | String[] split = companion.split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | zfEquipment.setCompanionList(list); |
| | | zfEquipment.setHasAttachment(hasAttachment); |
| | | zfEquipment.setIsHide("否"); |
| | | |
| | | System.out.println("[[[[[[[["+zfEquipment); |
| | | |
| | | return dataList(zfEquipment); |
| | | } |
| | | |
| | | public List<zfEventdto> dataList(ZfEquipment zfEquipment) { |
| | | |
| | | LambdaQueryWrapper<ZfEquipment> lqw = buildCondition(zfEquipment, null); |
| | | |
| | | List<ZfEquipment> beanRecords = list(lqw); |
| | | |
| | | |
| | | |
| | | return encapData(beanRecords); |
| | | } |
| | | |
| | | public List<zfEventdto> encapData(List<ZfEquipment> lis) |
| | | { |
| | | List<zfEventdto> daoRes = new ArrayList<>() ; |
| | | for(ZfEquipment 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; |
| | | } |
| | | } |
| | |
| | | |
| | | |
| | | 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.ZfEvent; |
| | | import com.ruoyi.domain.dto.zfEventdto; |
| | | import com.ruoyi.mapper.ZfEventMapper; |
| | | import com.ruoyi.service.*; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | */ |
| | | @Slf4j |
| | | @Service |
| | | public class ZfEventServiceImpl extends ServiceImpl<ZfEventMapper, ZfEvent> implements ZfEventService { |
| | | public class ZfEventServiceImpl extends ServiceImpl<ZfEventMapper, ZfEvent> implements ZfEventService,ModuleSearchable { |
| | | |
| | | @Resource |
| | | ZInfoUserService zInfoUserService; |
| | |
| | | LambdaQueryWrapper<ZfEvent> lqw = new LambdaQueryWrapper<>(); |
| | | lqw.orderByDesc(ZfEvent::getCreateTime); |
| | | lqw.like(!StringUtils.isEmpty(zfEvent.getAddress()), ZfEvent::getAddress, zfEvent.getAddress()); |
| | | lqw.like(!StringUtils.isEmpty(zfEvent.getPeople()), ZfEvent::getPeople, zfEvent.getPeople()); |
| | | lqw.like(!StringUtils.isEmpty(zfEvent.getTitle()), ZfEvent::getTitle, zfEvent.getTitle()); |
| | | lqw.like(!StringUtils.isEmpty(zfEvent.getRemark()), ZfEvent::getRemark, zfEvent.getRemark()); |
| | | lqw.eq(zfEvent.getHappenTime() != null, ZfEvent::getHappenTime, zfEvent.getHappenTime()); |
| | | lqw.in(ZfEvent::getFamilyId,familyIdList); |
| | | lqw.in(familyIdList != null, ZfEvent::getFamilyId,familyIdList); |
| | | lqw.between(zfEvent.getHappenStartTime() != null && zfEvent.getHappenEndTime() != null, ZfEvent::getHappenTime, zfEvent.getHappenStartTime(), zfEvent.getHappenEndTime()); |
| | | |
| | | if (StringUtils.isNotEmpty(zfEvent.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfEvent::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfEvent::getIsHide) |
| | | ); |
| | | }else { |
| | | lqw.like(!StringUtils.isEmpty(zfEvent.getPeople()), ZfEvent::getPeople, zfEvent.getPeople()); |
| | | |
| | | } |
| | | if (zfEvent.getHasAttachment() != null && zfEvent.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(ZfEvent.getCompanionList()),ZfEvent::getCompanion,ZfEvent.getCompanionList()); |
| | | // if (ZfEvent.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+ZfEvent.getYear()); |
| | | // lqw.apply("YEAR(happen_time) = {0}", ZfEvent.getYear()); |
| | | // } |
| | | |
| | | if (CollectionUtils.isNotEmpty(zfEvent.getCompanionList())) { |
| | | List<String> companionList = zfEvent.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(people, ' ', ''), ',', ',')) > 0", |
| | | companion); |
| | | } |
| | | } |
| | | } |
| | | lqw.eq(zfEvent.getHappenTime() != null, ZfEvent::getHappenTime, zfEvent.getHappenTime()); |
| | | System.out.println("查询条件: " + lqw.getCustomSqlSegment()); |
| | | |
| | | return lqw; |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | @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) { |
| | | ZfEvent zfEvent = new ZfEvent(); |
| | | zfEvent.setPeople(companion); |
| | | zfEvent.setHappenStartTime(happenStartTime); |
| | | zfEvent.setHappenEndTime(happenEndTime); |
| | | |
| | | System.out.println("--------------"+companion+"-----------------"); |
| | | String[] split = companion.trim().replace(" ", "").replace(",", ",").split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | zfEvent.setCompanionList(list); |
| | | zfEvent.setHasAttachment(hasAttachment); |
| | | zfEvent.setIsHide("否"); |
| | | |
| | | System.out.println("[[[[[[[["+zfEvent); |
| | | |
| | | return dataList(zfEvent); |
| | | } |
| | | |
| | | public List<zfEventdto> dataList(ZfEvent zfEvent) { |
| | | |
| | | LambdaQueryWrapper<ZfEvent> lqw = buildCondition(zfEvent, null); |
| | | |
| | | List<ZfEvent> beanRecords = list(lqw); |
| | | |
| | | |
| | | |
| | | return encapData(beanRecords); |
| | | } |
| | | |
| | | public List<zfEventdto> encapData(List<ZfEvent> lis) |
| | | { |
| | | List<zfEventdto> daoRes = new ArrayList<>() ; |
| | | for(ZfEvent obj : lis) |
| | | { |
| | | zfEventdto atd = new zfEventdto(); |
| | | atd.setId(Math.toIntExact(obj.getId())); |
| | | atd.setModule("家纪"); |
| | | atd.setName(obj.getPeople()); |
| | | atd.setCreateTime(obj.getCreateTime()); |
| | | daoRes.add(atd); |
| | | } |
| | | return daoRes; |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | |
| | | 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.StringUtils; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.domain.*; |
| | | import com.ruoyi.domain.dto.zfEventdto; |
| | | import com.ruoyi.mapper.ZfPetMapper; |
| | | import com.ruoyi.service.*; |
| | | import lombok.extern.slf4j.Slf4j; |
| | |
| | | */ |
| | | @Service |
| | | @Slf4j |
| | | public class ZfPetServiceImpl extends ServiceImpl<ZfPetMapper, ZfPet> implements ZfPetService { |
| | | public class ZfPetServiceImpl extends ServiceImpl<ZfPetMapper, ZfPet> implements ZfPetService,ModuleSearchable { |
| | | |
| | | @Autowired |
| | | ZInfoUserService zInfoUserService; |
| | |
| | | |
| | | @Autowired |
| | | ZfPetService zfPetService; |
| | | |
| | | |
| | | @Resource |
| | | ZAuthorityService zAuthorityService; |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | @Override |
| | | public List<ZfPet> selectByCondition(ZfPet zfPet) { |
| | |
| | | private LambdaQueryWrapper<ZfPet> buildCondition(ZfPet zfPet,List<Long> familyIdList) { |
| | | LambdaQueryWrapper<ZfPet> lqw = new LambdaQueryWrapper<>(); |
| | | lqw.orderByDesc(ZfPet::getCreateTime); |
| | | lqw.in(ZfPet::getFamilyId,familyIdList); |
| | | lqw.in(familyIdList != null, ZfPet::getFamilyId,familyIdList); |
| | | lqw.eq(zfPet.getId()!=null,ZfPet::getId,zfPet.getId()); |
| | | lqw.like(StringUtils.isNotEmpty(zfPet.getIdNum()),ZfPet::getIdNum,zfPet.getIdNum()); |
| | | lqw.like(StringUtils.isNotEmpty(zfPet.getSecurityCode()),ZfPet::getSecurityCode,zfPet.getSecurityCode()); |
| | |
| | | lqw.like(StringUtils.isNotEmpty(zfPet.getDialect()),ZfPet::getDialect,zfPet.getDialect()); |
| | | lqw.like(StringUtils.isNotEmpty(zfPet.getDisEatHabit()),ZfPet::getDisEatHabit,zfPet.getDisEatHabit()); |
| | | lqw.like(StringUtils.isNotEmpty(zfPet.getDisLifeHabit()),ZfPet::getDisLifeHabit,zfPet.getDisLifeHabit()); |
| | | return lqw; |
| | | } |
| | | } |
| | | |
| | | |
| | | if (StringUtils.isNotEmpty(zfPet.getIsHide())) { |
| | | |
| | | lqw.and(wrapper -> wrapper |
| | | .ne(ZfPet::getIsHide, "是") |
| | | .or() |
| | | .isNull(ZfPet::getIsHide) |
| | | ); |
| | | } |
| | | if (zfPet.getHasAttachment() != null && zfPet.getHasAttachment().equals("是")) { |
| | | lqw.apply("url IS NOT NULL AND url != ''"); |
| | | } |
| | | // lqw.in(StringUtils.isNotEmpty(zfPet.getCompanionList()),zfPet::getCompanion,zfPet.getCompanionList()); |
| | | // if (zfPet.getYear() != 0) { |
| | | // System.out.println("pppppppppppppppppppppppppppppppppppppppppppppppppppp"+zfPet.getYear()); |
| | | // lqw.apply("YEAR(happen_time) = {0}", zfPet.getYear()); |
| | | // } |
| | | |
| | | if (CollectionUtils.isNotEmpty(zfPet.getCompanionList())) { |
| | | List<String> companionList = zfPet.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;} |
| | | |
| | | |
| | | @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) { |
| | | ZfPet zfPet = new ZfPet(); |
| | | zfPet.setCompanion(companion); |
| | | |
| | | |
| | | String[] split = companion.split(","); |
| | | List<String> list = Arrays.asList(split); |
| | | |
| | | zfPet.setCompanionList(list); |
| | | zfPet.setHasAttachment(hasAttachment); |
| | | zfPet.setIsHide("否"); |
| | | |
| | | System.out.println("[[[[[[[["+zfPet); |
| | | |
| | | return dataList(zfPet); |
| | | } |
| | | |
| | | public List<zfEventdto> dataList(ZfPet zfPet) { |
| | | |
| | | LambdaQueryWrapper<ZfPet> lqw = buildCondition(zfPet, null); |
| | | |
| | | List<ZfPet> beanRecords = list(lqw); |
| | | |
| | | |
| | | |
| | | return encapData(beanRecords); |
| | | } |
| | | |
| | | public List<zfEventdto> encapData(List<ZfPet> lis) |
| | | { |
| | | List<zfEventdto> daoRes = new ArrayList<>() ; |
| | | for(ZfPet obj : lis) |
| | | { |
| | | zfEventdto atd = new zfEventdto(); |
| | | atd.setId(Math.toIntExact(Long.parseLong(obj.getId()))); |
| | | atd.setModule("宠物"); |
| | | atd.setName(obj.getCompanion()); |
| | | atd.setCreateTime(obj.getCreateTime()); |
| | | daoRes.add(atd); |
| | | } |
| | | return daoRes; |
| | | }} |