package org.jeecg.modules.project.service.impl;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.UUID;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;

import org.jeecg.common.util.DateUtils;
import org.jeecg.modules.excel.ExcelUtils;
import org.jeecg.modules.project.entity.ProProject;
import org.jeecg.modules.project.entity.ProProjectLink;
import org.jeecg.modules.project.entity.ProSummary;
import org.jeecg.modules.project.mapper.ProProjectLinkMapper;
import org.jeecg.modules.project.mapper.ProProjectMapper;
import org.jeecg.modules.project.mapper.ProSummaryMapper;
import org.jeecg.modules.project.service.IProProjectService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import lombok.extern.slf4j.Slf4j;

@Service
@Slf4j
public class ProProjectService extends ServiceImpl<ProProjectMapper, ProProject> implements IProProjectService {
    @Autowired
    private ProProjectMapper projectMapper;
    @Autowired
    private ProProjectLinkMapper linkMapper;

    @Autowired
    private ProSummaryMapper summaryMapper;

    @Autowired
    private ExcelUtils excelUtils;

    @Override
    @Transactional
    public Integer importExcel(List<Map<Integer, String>> listMap) {

        ProProject project = excelUtils.CoverProProject(listMap);
        List<ProProjectLink> linkList = project.getLinkList();
        List<ProProjectLink> linkList1 = new ArrayList<>();
        List<ProProjectLink> linkList2 = new ArrayList<>();
        List<ProProjectLink> linkList3 = new ArrayList<>();
        List<ProProjectLink> linkList4 = new ArrayList<>();
        List<ProProjectLink> linkList5 = new ArrayList<>();
        List<ProProjectLink> linkList6 = new ArrayList<>();

        Map<String, Object> map = new HashMap<>();
        map.put("xmbh", project.getXmbh());
        List<ProProject> proProjects = projectMapper.selectByMap(map);
        if (proProjects != null && proProjects.size() > 0) {
            return 0;
        }

        projectMapper.insert(project);
        //插入项目概述与预测
        ProSummary summary = project.getSummary();
        if (project.getId() != null) {
            summary.setPro(project.getId());
            summaryMapper.insert(summary);
        }



/*
        ProSummary mary = new ProSummary();
        mary.setPro(project.getId());
        mary.setGs(project.getBzgz());
        mary.setYc(project.getXzgz());
        //设置类型为 周计划
        mary.setType(1);
        summaryMapper.insert(mary);
*/


        for (int i = 0; i < linkList.size(); i++) {
            ProProjectLink link = linkList.get(i);
            String s = UUID.randomUUID().toString().replaceAll("-", "");
            link.setId(s);
            link.setPro(project.getId());
            link.setLeaf(true);
            if (link.getLevel() == 1) {
                linkList1.add(link);
            } else if (link.getLevel() == 2) {
                linkList2.add(link);
            } else if (link.getLevel() == 3) {
                linkList3.add(link);
            } else if (link.getLevel() == 4) {
                linkList4.add(link);
            } else if (link.getLevel() == 5) {
                linkList5.add(link);
            } else if (link.getLevel() == 6) {
                linkList6.add(link);
            }

        }
        double sort = 0.0;
        for (int i = 0; i < linkList1.size(); i++) {
            ProProjectLink link1 = linkList1.get(i);
            sort += 10;
            link1.setSortNo(sort);

            for (int j = 0; j < linkList2.size(); j++) {
                ProProjectLink link2 = linkList2.get(j);
                if (link2.getSxh().startsWith(link1.getSxh())) {
                    link2.setPid(link1.getId());
                    link1.setLeaf(false);
                    sort += 10;
                    link2.setSortNo(sort);
                    for (int k = 0; k < linkList3.size(); k++) {
                        ProProjectLink link3 = linkList3.get(k);
                        if (link3.getSxh().startsWith(link2.getSxh())) {
                            link3.setPid(link2.getId());
                            link2.setLeaf(false);
                            sort += 10;
                            link3.setSortNo(sort);
                            for (int l = 0; l < linkList4.size(); l++) {
                                ProProjectLink link4 = linkList4.get(l);
                                if (link4.getSxh().startsWith(link3.getSxh())) {
                                    link4.setPid(link3.getId());
                                    link3.setLeaf(false);
                                    sort += 10;
                                    link4.setSortNo(sort);

                                    for (int i5 = 0; i5 < linkList5.size(); i5++) {
                                        ProProjectLink link5 = linkList5.get(i5);
                                        if (link5.getSxh().startsWith(link4.getSxh())) {
                                            link5.setPid(link4.getId());
                                            link4.setLeaf(false);
                                            sort += 10;
                                            link5.setSortNo(sort);

                                            for (int i6 = 0; i6 < linkList6.size(); i6++) {
                                                ProProjectLink link6 = linkList6.get(i6);
                                                if (link6.getSxh().startsWith(link5.getSxh())) {
                                                    link6.setPid(link5.getId());
                                                    link5.setLeaf(false);
                                                    sort += 10;
                                                    link6.setSortNo(sort);
                                                }
                                            }
                                        }
                                    }

                                }
                            }
                        }


                    }
                }


            }
        }
        linkList.clear();
        linkList.addAll(linkList1);
        linkList.addAll(linkList2);
        linkList.addAll(linkList3);
        linkList.addAll(linkList4);
        linkList.addAll(linkList5);
        linkList.addAll(linkList6);
        int wczs = 0;
        for (int i = 0; i < linkList.size(); i++) {
            ProProjectLink link = linkList.get(i);
            if (link.getWcjd() != null && link.getWcjd() == 1) {
                wczs += 1;
            }
            linkMapper.insert(link);
        }

        try {
            // 计算项目周期
            if (project.getKsrq() != null && project.getJsrq() != null) {
                int xmzq = DateUtils.daysBetween(project.getKsrq(), project.getJsrq());
                project.setXmzq(xmzq);
            }
            // 计算项目已用时间
            if (project.getKsrq() != null) {
                int yysj = DateUtils.daysBetween(project.getKsrq(), new Date());
                project.setYysj(yysj);
            }
            // 计算项目剩余时间
            if (project.getKsrq() != null) {
                int sysj = DateUtils.daysBetween(new Date(), project.getJsrq());
                project.setSysj(sysj);
            }
            // 计算项目时间进度
            if (project.getXmzq() != null && project.getXmzq() > 0 && project.getYysj() != null) {
                Double sjjd = Double.valueOf(project.getYysj()) / Double.valueOf(project.getXmzq()) * 100;
                BigDecimal b = new BigDecimal(sjjd);
                sjjd = b.setScale(1, BigDecimal.ROUND_HALF_UP).doubleValue();
                project.setSjjd(sjjd);
            }

            project.setRwzs(linkList.size());
            project.setWcrws(wczs);

            if (wczs > 0 && !linkList.isEmpty()) {
                Double jd = Double.valueOf(wczs) / Double.valueOf(linkList.size()) * 100;
                BigDecimal b = new BigDecimal(jd);
                jd = b.setScale(1, BigDecimal.ROUND_HALF_UP).doubleValue();
                project.setWcjd(jd);
            }
            projectMapper.updateById(project);

        } catch (Exception e) {
            e.printStackTrace();
        }

        return 1;
    }

    @Override
    public void updateProject(ProProject project) {

        try {//TODO

            //插入项目概述与预测
          /*  ProSummary mary = new ProSummary();
            mary.setPro(project.getId());
            mary.setGs(project.getBzgz());
            mary.setYc(project.getXzgz());
            //设置类型为 周计划
            mary.setType(1);
            //一天最多只能插入一条  先删除多余数据
            Map<String,Object> map =  new HashMap<>();
            map.put("create_time",DateUtils.formatDate());
            List<ProSummary> proSummaries = summaryMapper.selectByMap(map);
            if(proSummaries!=null && proSummaries.size() > 0){
                for (int i = 0; i < proSummaries.size(); i++) {
                    ProSummary proSummary = proSummaries.get(i);
                    summaryMapper.deleteById(proSummary.getId());
                }
            }
            summaryMapper.insert(mary);
*/
            // 计算项目周期
            if (project.getKsrq() != null && project.getJsrq() != null) {
                int xmzq = DateUtils.daysBetween(project.getKsrq(), project.getJsrq());
                project.setXmzq(xmzq);
            }
            // 计算项目已用时间
            if (project.getKsrq() != null) {
                int yysj = DateUtils.daysBetween(project.getKsrq(), new Date());
                project.setYysj(yysj);
            }
            // 计算项目剩余时间
            if (project.getKsrq() != null) {
                int sysj = DateUtils.daysBetween(new Date(), project.getJsrq());
                project.setSysj(sysj);
            }
            // 计算项目时间进度
            if (project.getXmzq() != null && project.getXmzq() > 0 && project.getYysj() != null) {
                Double sjjd = Double.valueOf(project.getYysj()) / Double.valueOf(project.getXmzq()) * 100;
                BigDecimal b = new BigDecimal(sjjd);
                sjjd = b.setScale(1, BigDecimal.ROUND_HALF_UP).doubleValue();
                project.setSjjd(sjjd);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        projectMapper.updateById(project);

    }

    @Override
    public void updateProjectByLink(String id) {
        try {

            ProProjectLink link = linkMapper.selectById(id);
            ProProject pro = projectMapper.selectById(link.getPro());
            Map<String, Object> map = new HashMap<>();
            map.put("pro", link.getPro());
            List<ProProjectLink> linkList = linkMapper.selectByMap(map);
            int wczs = 0;
            for (int i = 0; i < linkList.size(); i++) {
                ProProjectLink item = linkList.get(i);
                if (item.getWcjd() != null && item.getWcjd() == 1) {
                    wczs += 1;
                }
            }

            pro.setRwzs(linkList.size());
            pro.setWcrws(wczs);

            if (wczs > 0 && !linkList.isEmpty()) {
                Double jd = Double.valueOf(wczs) / Double.valueOf(linkList.size()) * 100;
                BigDecimal b = new BigDecimal(jd);
                jd = b.setScale(1, BigDecimal.ROUND_HALF_UP).doubleValue();
                pro.setWcjd(jd);
            }
            //设置本周更新状态
            pro.setRenewal(1);
            pro.setBgrq(new Date());
            projectMapper.updateById(pro);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    @Override
    public List<Map<String, Object>> generalBulletinBoard(Map<String, Object> params) {

        return projectMapper.generalBulletinBoard(params);
    }

    @Override
    public IPage<ProProject> queryCustomPageList(Page page, ProProject project) {
        return projectMapper.queryCustomPageList(page, project);
    }

    @Override
    public void resetProjectRenewal() {
        LambdaUpdateWrapper<ProProject> updateWrapper = new LambdaUpdateWrapper();
        updateWrapper.set(ProProject::getRenewal,0);
        this.update(updateWrapper);

    }

}