package com.ruoyi.service.impl;


import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
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.EsModel;
import com.ruoyi.common.utils.MapUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.domain.*;
import com.ruoyi.domain.ZfEvent;
import com.ruoyi.mapper.ZfEventMapper;
import com.ruoyi.service.*;
import lombok.extern.slf4j.Slf4j;
import org.elasticsearch.action.delete.DeleteRequest;
import org.elasticsearch.action.update.UpdateRequest;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
import java.io.IOException;
import java.time.LocalDateTime;
import java.util.*;
import java.util.stream.Collectors;

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

/**
 * <p>
 * 家庭大事件表 服务实现类
 * </p>
 *
 * @author ojq
 * @since 2023-03-12
 */
@Slf4j
@Service
public class ZfEventServiceImpl extends ServiceImpl<ZfEventMapper, ZfEvent> implements ZfEventService {

    @Resource
    ZInfoUserService zInfoUserService;

    @Resource
    ZfEventService zfEventService;

    @Resource
    ZAuthorityService zAuthorityService;
    //加入到es中
    @Resource
    private EsService esSer;

    @Resource
    private ZfEventDownloadService zfEventDownloadService;

    @Resource
    private ZfEventShareService zfEventShareService;

    @Resource
    private RestHighLevelClient restHighLevelClient;
    private LambdaQueryWrapper<ZfEvent> buildCondition(ZfEvent zfEvent,List<Long> familyIdList) {
        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.between(zfEvent.getHappenStartTime() != null && zfEvent.getHappenEndTime() != null, ZfEvent::getHappenTime, zfEvent.getHappenStartTime(), zfEvent.getHappenEndTime());
        return lqw;
    }

    private LambdaQueryWrapper<ZfEvent> uniqueCondition(ZfEvent zfEvent){
        LambdaQueryWrapper<ZfEvent> lqw = new LambdaQueryWrapper<>();
        lqw.eq(!StringUtils.isEmpty(zfEvent.getAddress()), ZfEvent::getAddress, zfEvent.getAddress());
        lqw.eq(!StringUtils.isEmpty(zfEvent.getPeople()), ZfEvent::getPeople, zfEvent.getPeople());
        lqw.eq(!StringUtils.isEmpty(zfEvent.getTitle()), ZfEvent::getTitle, zfEvent.getTitle());
        lqw.eq(!StringUtils.isEmpty(zfEvent.getRemark()), ZfEvent::getRemark, zfEvent.getRemark());
        lqw.eq(zfEvent.getFamilyId()!=null,ZfEvent::getFamilyId,zfEvent.getFamilyId());
        lqw.eq(zfEvent.getHappenTime() != null, ZfEvent::getHappenTime, zfEvent.getHappenTime());
        return lqw;
    }

//    private LambdaQueryWrapper<ZfEvent> buildCondition(ZfEvent zfEvent, String familyIds, String secondFamilyAuthority) {
//        //模糊查询的条件
//        LambdaQueryWrapper<ZfEvent> lqw = buildCondition(zfEvent);
//
//        //定义一个布尔标记，标记第一家庭号是否有逗号
//        boolean flag = false;
//
//        StringBuilder secondFamilyIdsBuffer = new StringBuilder();
//
//        //处理传入的secondFamilyAuthority   3{2007 2018 2015},4{2007 2019}
//
//        if (StringUtils.isNotEmpty(secondFamilyAuthority)) {
//
//            if (secondFamilyAuthority.contains(",")) {
//                //逗号隔开得到如下串：3{2007 2018 2015}
//                String[] authorityList = secondFamilyAuthority.split(",");
//                for (String authorityAndId : authorityList) {
//                    setSecondFamilyAuthority(secondFamilyIdsBuffer, authorityAndId);
//                }
//
//                //把后面的逗号去掉
//                if (secondFamilyIdsBuffer.length() > 1) {
//                    secondFamilyIdsBuffer.deleteCharAt(secondFamilyIdsBuffer.length() - 1);
//                }
//
//            } else {
//                setSecondFamilyAuthority(secondFamilyIdsBuffer, secondFamilyAuthority);
//                //把后面的逗号去掉
//                if (secondFamilyIdsBuffer.length() > 1) {
//                    secondFamilyIdsBuffer.deleteCharAt(secondFamilyIdsBuffer.length() - 1);
//                }
//            }
//        }
//        //将StringBuffer转成String
//        String secondFamilyIds = secondFamilyIdsBuffer.toString();
//
//        //第一家庭号的条件
//        if (familyIds.contains(",")) {
//            flag = true;
//        }
//
//        //第二家庭号的条件
//        if (StringUtils.isNotEmpty(secondFamilyIds)) {
//            if (secondFamilyIds.contains(",")) {
//                String[] secondFamilyIdList = secondFamilyIds.split(",");
//                if (flag) {
//                    //如果第一家庭号和第二家庭号都有逗号
//                    String[] familyList = familyIds.split(",");
//                    String[] totalFamilyIdList = ArraysUtil.appendToArray(familyList, secondFamilyIdList);
//                    lqw.in(ZfEvent::getFamilyId, totalFamilyIdList);
//                } else {
//                    //如果第一家庭号没有逗号但是第二家庭号有逗号
//                    String[] totalFamilyIdList = ArraysUtil.appendToArray(secondFamilyIdList, familyIds);
//                    lqw.in(ZfEvent::getFamilyId, totalFamilyIdList);
//                }
//
//            } else {
//                if (flag) {
//                    //如果第一家庭号有逗号但第二家庭号没有逗号
//                    String[] familyList = familyIds.split(",");
//                    String[] totalFamilyIdList = ArraysUtil.appendToArray(familyList, secondFamilyIds);
//                    lqw.in(ZfEvent::getFamilyId, totalFamilyIdList);
//                } else {
//                    //如果第一家庭号和第二家庭号都没有逗号
//                    String[] totalFamilyIdList = ArraysUtil.appendToArray(familyIds, secondFamilyIds);
//                    lqw.in(ZfEvent::getFamilyId, totalFamilyIdList);
//                }
//            }
//        } else {
//            //如果没有第二家庭号
//            if (flag) {
//                String[] familyList = familyIds.split(",");
//                lqw.in(ZfEvent::getFamilyId, familyList);
//            } else {
//                lqw.eq(ZfEvent::getFamilyId, familyIds);
//            }
//
//        }
//
//        lqw.orderByDesc(ZfEvent::getCreateTime);
//        return lqw;
//    }
//
//    private void setSecondFamilyAuthority(StringBuilder secondFamilyIdsBuffer, String authorityAndId) {
//        //得到权限串
//        String authorities = authorityAndId.substring(2, authorityAndId.length() - 1);
//
//        if (authorities.contains(" ")) {
//            //空格隔开得到菜单id，看是否有对应的权限
//            String[] authorityIdList = authorities.split(" ");
//            for (String s : authorityIdList) {
//                if (s.equals(EVENT_LIST)) {
//                    secondFamilyIdsBuffer.append(authorityAndId.charAt(0)).append(",");
//                    break;
//                }
//            }
//        } else {
//            if (authorities.equals(EVENT_LIST)) {
//                secondFamilyIdsBuffer.append(authorityAndId.charAt(0)).append(",");
//            }
//        }
//    }
//
//    private ZInfoUser getMySelf() {
//        SysUser user = SecurityUtils.getLoginUser().getUser();
//        Long userId = user.getUserId();
//        LambdaQueryWrapper<ZInfoUser> zInfoUserLambdaQueryWrapper = new LambdaQueryWrapper<>();
//        zInfoUserLambdaQueryWrapper.eq(ZInfoUser::getUserId, userId);
//        return zInfoUserService.getOne(zInfoUserLambdaQueryWrapper);
//    }
//
//    private Long listFamilyId() {
//        ZInfoUser mySelf = getMySelf();
//        return mySelf.getFamilyId();
//    }
//
//    private String listSecondFamilyIds() {
//        ZInfoUser mySelf = getMySelf();
//        return mySelf.getSecondFamilyId();
//    }

    @Override
    public List<ZfEvent> selectByCondition(ZfEvent zfEvent) {
//        Long familyId = listFamilyId();
//        String secondFamilyIds = listSecondFamilyIds();
        //要查自己家庭的
        ZInfoUser myself = zInfoUserService.getMyself();
        System.out.println("================");

        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(EVENT_LIST)).map(ZAuthority::getFid).collect(Collectors.toList());


        //根据uaid查询相同名字下别的家庭里自己的数据
     //   Long fmid;
        System.out.println(myself.getUaid());

        List<Long> fms = zInfoUserService.findByUaidToFaid(myself.getUaid()).stream().map(ZInfoUser::getFamilyId).collect(Collectors.toList());
        if(!fms.isEmpty())
        {
            System.out.println("[[[[[[[[[[[}}}}}}}}}}}}}}}}}}");
            idList.addAll(fms);
        }
        //加上自己家庭的id
        idList.add(familyId);
        System.out.println(authority);

        //加上父母家族id
        idList.add(fatherFaId);
        idList.add(motherFaId);

        LambdaQueryWrapper<ZfEvent> lambdaQueryWrapper = buildCondition(zfEvent, idList);
        List<ZfEvent> beanRecords = list(lambdaQueryWrapper);
        log.info("从数据库中查到的为:{}", beanRecords);
        return markOwnData(familyId,fatherFaId, motherFaId, beanRecords);
    }

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

    public List<ZfEvent> markOwnData(Long familyId,Long fatherFamilyId, Long motherFamilyId,List<ZfEvent> 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());
    }

//    private static List<ZfEvent> markOwnData(String familyIds, List<ZfEvent> beanRecords) {
//        return beanRecords.stream().peek(record -> {
//            String recordFamilyId = record.getFamilyId();
//            if (familyIds.contains(",")) {
//                String[] familyIdList = familyIds.split(",");
//                for (String familyId : familyIdList) {
//                    if (familyId.equals(recordFamilyId)) {
//                        record.setOwnData(1);
//                    }
//                }
//            } else {
//                if (familyIds.equals(recordFamilyId)) {
//                    record.setOwnData(1);
//                }
//            }
//        }).collect(Collectors.toList());
//    }

    @Override
    public AjaxResult selectDataList(ZfEvent zfEvent, Integer pageNum, Integer pageSize) {
        //要查自己家庭的
        ZInfoUser myself = zInfoUserService.getMyself();
        if(myself==null)
        {
         //   System.out.println("ssssss");
            return AjaxResult.success("您没加入到对应的家庭，请联系管理员");
        }
        Long familyId = myself.getFamilyId();
        System.out.println("++++++++++++++++");
        System.out.println(familyId);
        System.out.println(myself.getFatherId());
        System.out.println(zInfoUserService.getInfoById(myself.getFatherId()));
        //查看父母的数据：
        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(EVENT_LIST)).map(ZAuthority::getFid).collect(Collectors.toList());
        //加上自己家庭的id
        idList.add(familyId);

        //加上父母家族id
        idList.add(fatherFaId);
        idList.add(motherFaId);
   //     System.out.println(myself.getUaid());
        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<ZfEvent> lqw = buildCondition(zfEvent, idList);


        Page<ZfEvent> zfEventPage = new Page<>(pageNum, pageSize);
        Page<ZfEvent> pageResult = page(zfEventPage, lqw);

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

        System.out.println(beanRecords);
        System.out.println(beanRecords.size());
        List<ZfEvent> dtoResult = markOwnData(familyId,fatherFaId, motherFaId, beanRecords);

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

//    @Override
//    public AjaxResult addData(ZfEvent zfEvent) {
//
//        String familyIds = listFamilyIds();
//        boolean flag = false;//判断当前用户的id是否有权加入当前家庭id的对象
//        if (familyIds.contains(",")) {
//            String[] familyList = familyIds.split(",");
//            for (String familyId : familyList) {
//                if (familyId.equals(zfEvent.getFamilyId())) {
//                    flag = true;
//                }
//            }
//        } else {
//            if (zfEvent.getFamilyId().equals(familyIds)) {
//                flag = true;
//            }
//        }
//        if (flag) {
//            if (save(zfEvent)) {
//                return AjaxResult.success();
//            } else {
//                return AjaxResult.error();
//            }
//
//        } else {
//            throw new RuntimeException("你没有操作该家庭号为" + zfEvent.getFamilyId() + "数据的权限");
//        }
//    }

    @Override
    public AjaxResult addData(ZfEvent zfEvent) {
        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(EVENT_LIST_ADD)).map(ZAuthority::getFid).collect(Collectors.toList());
        familyIdList.add(familyId);

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


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

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

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

        if (save(zfEvent)) {
            EsModel esModel = new EsModel();
            Integer inte = zfEvent.getId();
            String uuid = UUID.randomUUID().toString().replace("-","");
            esModel.setId(uuid);
            esModel.setCtId(Long.valueOf(inte));
            esModel.setCtTableName("家大事记");
            esModel.setBy1(zfEvent.getAddress());
            esModel.setBy2(zfEvent.getPeople());
            esModel.setBy3(zfEvent.getTitle());
            esModel.setRemark(zfEvent.getRemark());
            //这里存储查询详情的路径
            esModel.setBy5("/family/zfEvent");
            esModel.setFid(familyId);
            esSer.insertTable(esModel);

            return AjaxResult.success();
        } else {
            return AjaxResult.error();
        }
    }

//    @Override
//    public AjaxResult addData2(ZfEvent zfEvent) {
//        ZInfoUser mySelf = getMySelf();
//        String myFamilyId = mySelf.getFamilyId();
//
//        if (StringUtils.isNotEmpty(zfEvent.getFamilyId())) {
//            throw new RuntimeException("导入数据时您不能指定家庭号");
//        }
//
//        if (StringUtils.isEmpty(myFamilyId)) {
//            throw new RuntimeException("您还未加入任何家庭");
//        }
//
//        if (myFamilyId.contains(",")) {
//            String[] myFamilyIds = myFamilyId.split(",");
//            //默认添加第一个家庭的数据
//            zfEvent.setFamilyId(myFamilyIds[0]);
//        } else {
//            zfEvent.setFamilyId(myFamilyId);
//        }
//
//        //判断是否有重复数据
//        LambdaQueryWrapper<ZfEvent> zfEventLambdaQueryWrapper = uniqueCondition(zfEvent);
//        List<ZfEvent> list = list(zfEventLambdaQueryWrapper);
//        if(list.size()>0){
//            throw new RuntimeException("请勿新增重复数据");
//        }
//
//        if (save(zfEvent)) {
//            return AjaxResult.success();
//        } else {
//            return AjaxResult.error();
//        }
//    }


    @Override
    @Transactional
    public AjaxResult importExcel(MultipartFile file) {
        ExcelUtil<ZfEvent> util = new ExcelUtil<>(ZfEvent.class);
        List<ZfEvent> dataList = null;
        try {
            dataList = util.importExcel(file.getInputStream());
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
        log.info("数据列表为：{}", dataList);

        for (ZfEvent zfEvent : dataList) {
            zfEventService.addData(zfEvent);
        }

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

    }

    @Resource
    ZfLogService zfLogService;

    @Override
    @Transactional
    public AjaxResult updateData(ZfEvent zfEvent) {
        ZInfoUser myself = zInfoUserService.getMyself();
        Long familyId = myself.getFamilyId();

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

        List<ZAuthority> authority = zAuthorityService.getAuthority();
        List<Long> familyIdList = authority.stream().filter(auth -> auth.getAuthority().toString().equals(EVENT_LIST_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(zfEventService.updateById(zfEvent)){
            //到数据库中查询对应的数据
            ZfEvent dataById = getById(zfEvent.getId());

            //先到es中查询到对应那条数据在es的id
            EsModel esResult = esSer.findByCtId(dataById.getId(), "家大事记");

            if (esResult == null){
                return AjaxResult.success();
            }

            //操作es修改数据
            EsModel newModel = new EsModel();
            if(zfEvent.getAddress()!=null){
                newModel.setBy1(zfEvent.getAddress());
            }else {
                newModel.setBy1(dataById.getAddress());
            }

            if(zfEvent.getPeople()!=null){
                newModel.setBy2(zfEvent.getPeople());
            }else {
                newModel.setBy2(dataById.getPeople());
            }

            if(zfEvent.getTitle()!=null){
                newModel.setBy3(zfEvent.getTitle());
            }else {
                newModel.setBy3(dataById.getTitle());
            }

            if(zfEvent.getRemark()!=null){
                newModel.setRemark(zfEvent.getRemark());
            }else {
                newModel.setRemark(dataById.getRemark());
            }

            UpdateRequest updateRequest = new UpdateRequest("allsearchdata", esResult.getId());
            updateRequest.doc(
                    "by1",newModel.getBy1(),
                    "by2",newModel.getBy2(),
                    "by3",newModel.getBy3(),
                    "by4",newModel.getBy4(),
                    "remark",newModel.getRemark()
            );

            try {
                restHighLevelClient.update(updateRequest, RequestOptions.DEFAULT);
            } catch (IOException e) {
                throw new RuntimeException(e);
            }

            return AjaxResult.success();
        }else {
            return AjaxResult.error();
        }

    }

    @Override
    public AjaxResult deleteData(Long[] ids) {
        List<ZfEvent> dataList = zfEventService.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(EVENT_LIST_REMOVE)).map(ZAuthority::getFid).collect(Collectors.toList());
        familyIdList.add(familyId);

        for (ZfEvent data : dataList) {
            if (!familyIdList.contains(data.getFamilyId())){
                throw new RuntimeException("你没有权限操作此家庭的数据");
            }
        }

        List<ZfEvent> zfEvents = listByIds(Arrays.asList(ids));
        if (! (zfEventDownloadService.deleteData(ids) && zfEventShareService.deleteByContentId(ids)  ) ){
            return AjaxResult.error();
        }

        if (zfEventService.removeByIds(Arrays.asList(ids))) {
            //删除es中的数据
            zfEvents.stream().forEach(zfEvent -> {
                EsModel esModel = esSer.findByCtId(zfEvent.getId(), "家大事记");
                if (esModel != null){
                    DeleteRequest deleteRequest = new DeleteRequest("allsearchdata", esModel.getId());
                    try {
                        restHighLevelClient.delete(deleteRequest,RequestOptions.DEFAULT);
                    } catch (IOException e) {
                        throw new RuntimeException(e);
                    }
                }
            });


            return AjaxResult.success();
        }else {
            return AjaxResult.error();
        }

    }


}