人物搜索 新加所有家族模块

zqy

3 天以前 3eb37463a952fb69d586769ca660886b956cb016

 zhang-content/src/main/java/com/ruoyi/service/impl/ZfPetServiceImpl.java

@@ -2,30 +2,28 @@


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.core.domain.entity.SysUser;
import com.ruoyi.common.utils.MapUtils;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.uuid.IdUtils;
import com.ruoyi.domain.ZInfoUser;
import com.ruoyi.domain.ZfMaster;
import com.ruoyi.domain.ZfPet;
import com.ruoyi.domain.ZfProperty;
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.ZInfoUserService;
import com.ruoyi.service.ZfMasterService;
import com.ruoyi.service.ZfPetService;
import com.ruoyi.service.*;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.util.StringUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import java.util.HashMap;
import java.util.List;
import javax.annotation.Resource;
import java.time.LocalDateTime;
import java.util.*;
import java.util.stream.Collectors;

import static com.ruoyi.constant.MenuAuthority.*;

/**
 * <p>
@@ -37,7 +35,7 @@
 */
@Service
@Slf4j
public class ZfPetServiceImpl extends ServiceImpl<ZfPetMapper, ZfPet> implements ZfPetService {
public class ZfPetServiceImpl extends ServiceImpl<ZfPetMapper, ZfPet> implements ZfPetService,ModuleSearchable {

    @Autowired
    ZInfoUserService zInfoUserService;
@@ -47,64 +45,299 @@

    @Autowired
    ZfPetService zfPetService;

    @Resource
    ZAuthorityService zAuthorityService;

    @Resource
    ZfPetNoteService zfPetNoteService;

    @Resource
    ZfPetSharService zfPetSharService;

    @Resource
    ZfPetDownlService zfPetDownlService;

    @Override
    public AjaxResult selectPetList(ZfPet zfPet, Integer pageNum, Integer pageSize) {
        LambdaQueryWrapper<ZfPet> lqw = buildCondition(zfPet);
        lqw.orderByDesc(ZfPet::getCreateTime);
        Page<ZfPet> ZfPetPage = new Page<>(pageNum,pageSize);
        Page<ZfPet> pageResult = page(ZfPetPage, lqw);
        HashMap<String, Object> data = MapUtils.getResult(pageResult);
    public AjaxResult selectDataList(ZfPet zfPet, Integer pageNum, Integer pageSize) {
//        LambdaQueryWrapper<ZfPet> lqw = buildCondition(zfPet);
//        lqw.orderByDesc(ZfPet::getCreateTime);
//        Page<ZfPet> ZfPetPage = new Page<>(pageNum,pageSize);
//        Page<ZfPet> pageResult = page(ZfPetPage, lqw);
//        HashMap<String, Object> data = MapUtils.getResult(pageResult);
//        return AjaxResult.success(data);

        //要查自己家庭的
        ZInfoUser myself = zInfoUserService.getMyself();
        if(myself==null)
        {
            //   System.out.println("ssssss");
            return AjaxResult.success("您没加入到对应的家庭，请联系管理员");
        }
        Long familyId = myself.getFamilyId();

        //查看父母的数据：
        Long fatherFaId = 0L;
        if(myself.getFatherId()!=null)
            fatherFaId = zInfoUserService.getInfoById(myself.getFatherId()).getFamilyId();
        Long motherFaId = 0L;
        if(myself.getMomId()!=null)
            motherFaId = zInfoUserService.getInfoById(myself.getMomId()).getFamilyId();

        //也要查别人授权的
        List<ZAuthority> authority = zAuthorityService.getAuthority();
        List<Long> idList = authority.stream().filter(auth -> auth.getAuthority().toString().equals(FAMILY_PET_LIST)).map(ZAuthority::getFid).collect(Collectors.toList());
        //加上自己家庭的id
        idList.add(familyId);

        //加上父母家族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<ZfPet> lqw = buildCondition(zfPet, idList);


        Page<ZfPet> zfPetPage = new Page<>(pageNum, pageSize);
        Page<ZfPet> pageResult = page(zfPetPage, lqw);

        List<ZfPet> beanRecords = pageResult.getRecords();//得到查询出来的数据

        List<ZfPet> dtoResult = markOwnData(familyId,fatherFaId, motherFaId, beanRecords);

        HashMap<String, Object> data = MapUtils.getResult(pageResult, dtoResult);
        return AjaxResult.success(data);
    }

    public List<ZfPet> markOwnData(Long familyId,Long fatherFamilyId, Long motherFamilyId,List<ZfPet> beanRecords){
        return beanRecords.stream().peek(
                bean -> {
                    if (Objects.equals(bean.getFamilyId(), familyId) ||(fatherFamilyId!=0L && fatherFamilyId.equals(familyId))||(motherFamilyId!=0L && motherFamilyId.equals(familyId))) {
                        bean.setOwnData(1);
                    } else {
                        bean.setOwnData(0);
                    }
                }
        ).sorted((a,b)-> b.getOwnData()-a.getOwnData()).collect(Collectors.toList());
    }




    @Override
    public List<ZfPet> selectByCondition(ZfPet zfPet) {
        LambdaQueryWrapper<ZfPet> lambdaQueryWrapper = buildCondition(zfPet);
        lambdaQueryWrapper.orderByDesc(ZfPet::getCreateTime);
        List<ZfPet> list = list(lambdaQueryWrapper);
        log.info("返回的数据为:{}",list);
//        LambdaQueryWrapper<ZfPet> lambdaQueryWrapper = buildCondition(zfPet);
//        lambdaQueryWrapper.orderByDesc(ZfPet::getCreateTime);
//        List<ZfPet> list = list(lambdaQueryWrapper);
//        log.info("返回的数据为:{}",list);
//        return list;
        //要查自己家庭的
        ZInfoUser myself = zInfoUserService.getMyself();
        Long familyId = myself.getFamilyId();

        //查看父母的数据：
        Long fatherFaId = 0L;
        if(myself.getFatherId()!=null)
            fatherFaId = zInfoUserService.getInfoById(myself.getFatherId()).getFamilyId();
        Long motherFaId = 0L;
        if(myself.getMomId()!=null)
            motherFaId = zInfoUserService.getInfoBysysId(myself.getMomId()).getFamilyId();

        //也要查别人授权的
        List<ZAuthority> authority = zAuthorityService.getAuthority();
        List<Long> idList = authority.stream().filter(auth -> auth.getAuthority().toString().equals(FAMILY_PET_LIST)).map(ZAuthority::getFid).collect(Collectors.toList());
        //加上自己家庭的id
        idList.add(familyId);

        //加上父母家族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<ZfPet> lambdaQueryWrapper = buildCondition(zfPet, idList);
        List<ZfPet> beanRecords = list(lambdaQueryWrapper);
        log.info("从数据库中查到的为:{}", beanRecords);
        return markOwnData(familyId,fatherFaId, motherFaId, beanRecords);
    }

    @Override
    public List<ZfPet> selectByIds(Long[] ids) {
        List<ZfPet> list = new ArrayList<>();
        if(ids.length!=0)
            list = listByIds(Arrays.asList(ids));
        else
            list = list();
        return list;
    }

    @Override
    @Transactional
    public AjaxResult mySave(ZfPet zfPet) {
        SysUser user = SecurityUtils.getLoginUser().getUser();
        Long userId = user.getUserId();
    public AjaxResult importExcel(MultipartFile file) {
        ExcelUtil<ZfPet> util = new ExcelUtil<>(ZfPet.class);
        List<ZfPet> dataList = null;
        try {
            dataList = util.importExcel(file.getInputStream());
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
        log.info("数据列表为：{}", dataList);

        String pid = IdUtils.fastSimpleUUID();
        zfPet.setId(pid);
        for (ZfPet zfPet : dataList) {
            zfPetService.addData(zfPet);
        }

        return AjaxResult.success("导入数据成功");
    }

    @Override
    public AjaxResult addData(ZfPet zfPet) {
        ZInfoUser myself = zInfoUserService.getMyself();
        Long familyId = myself.getFamilyId();

        if(familyId == null){
            throw new RuntimeException("您还未加入任何家庭");
        }

        List<ZAuthority> authority = zAuthorityService.getAuthority();
        List<Long> familyIdList = authority.stream().filter(auth -> auth.getAuthority().toString().equals(FAMILY_PET_ADD)).map(ZAuthority::getFid).collect(Collectors.toList());
        familyIdList.add(familyId);

        if (zfPet.getFamilyId()!=null && !familyIdList.contains(zfPet.getFamilyId())) {
            throw new RuntimeException("你没有权限操作此家庭的数据");
        }


        if(zfPet.getFamilyId() == null){
            //默认添加自己家庭的数据
            zfPet.setFamilyId(familyId);
        }

        //判断是否有重复数据
        LambdaQueryWrapper<ZfPet> lqw = uniqueCondition(zfPet);
        List<ZfPet> list = list(lqw);

        if(list.size()>0){
            throw new RuntimeException("请勿新增重复数据");
        }

        //先查找本人的数据
        LambdaQueryWrapper<ZInfoUser> zInfoLqw = new LambdaQueryWrapper<>();
        zInfoLqw.eq(ZInfoUser::getUserId,userId);
        ZInfoUser master = zInfoUserService.getOne(zInfoLqw);

        ZfMaster zfMaster = new ZfMaster();
        zfMaster.setPetId(zfPet.getId());
        zfMaster.setName(master.getNickName());
        zfMaster.setCertificateType("身份证");
        zfMaster.setCertificateNo(master.getIdNo());
        zfMaster.setPhoneNo(master.getPhoneNumber());
        zfMaster.setAddress(master.getAlwaysAddress());

        zfMasterService.save(zfMaster);

        zfPetService.save(zfPet);

        return AjaxResult.success();

        if (save(zfPet)) {
            return AjaxResult.success();
        } else {
            return AjaxResult.error();
        }
    }

    @Resource
    ZfLogService zfLogService;

    @Override
    public AjaxResult updateData(ZfPet zfPet) {
        ZInfoUser myself = zInfoUserService.getMyself();
        Long familyId = myself.getFamilyId();

        //先根据id查询出数据的familyId，看看有没有权限操作
        Long dataFamilyId = getById(zfPet.getId()).getFamilyId();

        List<ZAuthority> authority = zAuthorityService.getAuthority();
        List<Long> familyIdList = authority.stream().filter(auth -> auth.getAuthority().toString().equals(FAMILY_PET_UPDATE)).map(ZAuthority::getFid).collect(Collectors.toList());
        familyIdList.add(familyId);

        if (dataFamilyId!=null && !familyIdList.contains(dataFamilyId)) {
            throw new RuntimeException("你没有权限操作此家庭的数据");
        }

        //操作后加入日志
        ZfLog zfLog = new ZfLog();
        zfLog.setUpdateTime(LocalDateTime.now());
        zfLog.setModule("魅宠");
        zfLog.setUpdater(zInfoUserService.getMyself().getNickName());
        zfLogService.save(zfLog);

        if(updateById(zfPet)){
            return AjaxResult.success();
        }else {
            return AjaxResult.error();
        }
    }

    @Override
    public AjaxResult deleteData(Long[] ids) {
        List<ZfPet> dataList = zfPetService.listByIds(Arrays.asList(ids));

        ZInfoUser myself = zInfoUserService.getMyself();
        Long familyId = myself.getFamilyId();

        List<ZAuthority> authority = zAuthorityService.getAuthority();
        List<Long> familyIdList = authority.stream().filter(auth -> auth.getAuthority().toString().equals(FAMILY_PET_REMOVE)).map(ZAuthority::getFid).collect(Collectors.toList());
        familyIdList.add(familyId);

        for (ZfPet data : dataList) {
            if (!familyIdList.contains(data.getFamilyId())){
                throw new RuntimeException("你没有权限操作此家庭的数据");
            }
            List<ZfPetNote> petNoteByPetId = zfPetNoteService.getPetNoteByPetId(data.getId());
            if(petNoteByPetId.size() != 0)
            if (!zfPetNoteService.removeBatchByIds(petNoteByPetId))
                return AjaxResult.error();
        }
        if (! (zfPetDownlService.deleteData(ids) && zfPetSharService.deleteByContentId(ids)  ) ){
            return AjaxResult.error();
        }

        if (zfPetService.removeByIds(Arrays.asList(ids))) {
            return AjaxResult.success();
        }else {
            return AjaxResult.error();
        }
    }

//    @Override
//    @Transactional
//    public AjaxResult mySave(ZfPet zfPet) {
//        SysUser user = SecurityUtils.getLoginUser().getUser();
//        Long userId = user.getUserId();
//
//        String pid = IdUtils.fastSimpleUUID();
//        zfPet.setId(pid);
//
//        //判断是否有重复数据
//        LambdaQueryWrapper<ZfPet> lqw = uniqueCondition(zfPet);
//        List<ZfPet> list = list(lqw);
//        if(list.size()>0){
//            throw new RuntimeException("请勿新增重复数据");
//        }
//
//        //先查找本人的数据
//        LambdaQueryWrapper<ZInfoUser> zInfoLqw = new LambdaQueryWrapper<>();
//        zInfoLqw.eq(ZInfoUser::getUserId,userId);
//        ZInfoUser master = zInfoUserService.getOne(zInfoLqw);
//
//        ZfMaster zfMaster = new ZfMaster();
//        zfMaster.setPetId(zfPet.getId());
//        zfMaster.setName(master.getNickName());
//        zfMaster.setCertificateType("身份证");
//        zfMaster.setCertificateNo(master.getIdNo());
//        zfMaster.setPhoneNo(master.getPhoneNumber());
//        zfMaster.setAddress(master.getAlwaysAddress());
//
//        zfMasterService.save(zfMaster);
//
//        zfPetService.save(zfPet);
//
//        return AjaxResult.success();
//
//    }

    private LambdaQueryWrapper<ZfPet> uniqueCondition(ZfPet zfPet) {
        LambdaQueryWrapper<ZfPet> lqw = new LambdaQueryWrapper<>();
        lqw.eq(zfPet.getFamilyId()!=null,ZfPet::getFamilyId,zfPet.getFamilyId());
        lqw.eq(StringUtils.isNotEmpty(zfPet.getIdNum()),ZfPet::getIdNum,zfPet.getIdNum());
        lqw.eq(StringUtils.isNotEmpty(zfPet.getSecurityCode()),ZfPet::getSecurityCode,zfPet.getSecurityCode());
        lqw.eq(StringUtils.isNotEmpty(zfPet.getType()),ZfPet::getType,zfPet.getType());
@@ -122,13 +355,17 @@
        return lqw;
    }

    private LambdaQueryWrapper<ZfPet> buildCondition(ZfPet zfPet) {
    private LambdaQueryWrapper<ZfPet> buildCondition(ZfPet zfPet,List<Long> familyIdList) {
        LambdaQueryWrapper<ZfPet> lqw = new LambdaQueryWrapper<>();
        lqw.orderByDesc(ZfPet::getCreateTime);
        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.getType()),ZfPet::getType,zfPet.getType());
        lqw.like(StringUtils.isNotEmpty(zfPet.getName()),ZfPet::getName,zfPet.getName());
        lqw.like(zfPet.getBirth()!=null,ZfPet::getBirth,zfPet.getBirth());
//        lqw.like(zfPet.getBirth()!=null,ZfPet::getBirth,zfPet.getBirth());
        lqw.between(zfPet.getBirthStart()!=null && zfPet.getBirthEnd()!=null,ZfPet::getBirth,zfPet.getBirthStart(),zfPet.getBirthEnd());
        lqw.like(zfPet.getSex()!=null,ZfPet::getSex,zfPet.getSex());
        lqw.like(StringUtils.isNotEmpty(zfPet.getColor()),ZfPet::getColor,zfPet.getColor());
        lqw.like(StringUtils.isNotEmpty(zfPet.getProperties()),ZfPet::getProperties,zfPet.getProperties());
@@ -138,6 +375,93 @@
        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;
        }}