package com.hxzkmonitor.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
//import cn.hutool.db.Page;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.hxzkmonitor.controller.TbEvrydayweiyi2024Controller;
import com.hxzkmonitor.mapper.TbCompanyMapper;
import com.hxzkmonitor.mapper.TbEquipmentMapper;
import com.hxzkmonitor.mapper.TbUserMapper;
import com.hxzkmonitor.pojo.*;
import com.hxzkmonitor.mapper.TbEvrydayweiyi2024Mapper;
import com.hxzkmonitor.service.TbEvrydayweiyi2024Service;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.hxzkmonitor.util.DateUtil;
import lombok.RequiredArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.core.parameters.P;
import org.springframework.stereotype.Service;

import java.text.SimpleDateFormat;
import java.util.*;

/**
 * <p>
 * 服务实现类
 * </p>
 *
 * @author wangfei
 * @since 2024-08-05
 */
@Service
@RequiredArgsConstructor(onConstructor = @__(@Autowired))
public class TbEvrydayweiyi2024ServiceImpl extends ServiceImpl<TbEvrydayweiyi2024Mapper, TbEvrydayweiyi2024> implements TbEvrydayweiyi2024Service {
    private final TbEvrydayweiyi2024Mapper tbEvrydayweiyi2024Mapper;

    private final TbUserMapper tbUserMapper;

    private final TbEquipmentMapper tbEquipmentMapper;

    private final TbCompanyMapper tbCompanyMapper;

//    @Override
//    public PageInfo<TbEvrydayweiyi2024> geteveryday(Integer page, Integer limit) {
//        PageHelper.startPage(page,limit);
//        QueryWrapper queryWrapper = new QueryWrapper<>();
////        queryWrapper.eq("phone",phone);
//        List<TbEvrydayweiyi2024> list = baseMapper.selectList(queryWrapper);
//        PageInfo<TbEvrydayweiyi2024> info = new PageInfo<>(list);
//        return info;
////        return baseMapper.selectList(queryWrapper);
//    }

    @Override
    public IPage<TbEvrydayweiyi2024> geteveryday(Page page, String keyword, String username, String time, String isdp) {
        Calendar calendar = Calendar.getInstance();
        String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
        int i1 = (Integer.parseInt(datey.split("-")[2])-1) ;
        String s = datey.split("-")[0] + "-" + datey.split("-")[1] + "-" + i1;

        QueryWrapper queryWrapper2 = new QueryWrapper<>();
        queryWrapper2.eq("username", username);
        TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
        if (Objects.equals(tbUser.getRole(), "超级管理员")) {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            if (isdp == "true") {
                queryWrapper.eq("filename", s);
            }
//            if (keyword!=null){
//                queryWrapper.eq("filename",keyword );
//                queryWrapper.or("filename",keyword );
//            }
            queryWrapper.orderByDesc("addtime");

            IPage<TbEvrydayweiyi2024> userPage = tbEvrydayweiyi2024Mapper.selectPage(page, queryWrapper);
            for (int i = 0; i < userPage.getRecords().size(); i++) {
                QueryWrapper queryWrapper1 = new QueryWrapper<>();
                queryWrapper1.eq("tagid", userPage.getRecords().get(i).getTagid());
                List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
                if (tbEquipment.size() > 0) {
                    QueryWrapper queryWrapper3 = new QueryWrapper<>();
                    queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
                    TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                    if (tbCompany != null) {
                        userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
                    }
                }
            }
            return userPage;
        } else {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("companyid", tbUser.getCsname());
            List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
            List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();

            int tb24jiancedataIPagesize = 13;
            long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
            long taol = 0;
            List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
            for (int i = 0; i < tbEquipment.size(); i++) {
                QueryWrapper queryWrapper1 = new QueryWrapper<>();
                if (isdp == "true") {
                    queryWrapper1.eq("filename", s);
                }

//                queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
//                queryWrapper1.orderByDesc("addtime");
                userPage = tbEvrydayweiyi2024Mapper.listall(tbUser.getCsname());
                tb24jiancedataIPagesize+= tbEvrydayweiyi2024Mapper.selectList(queryWrapper1).size();
                for (int j = 0; j < page.getSize() && curIdx + j < userPage.size(); j++) {
                    QueryWrapper queryWrapper3 = new QueryWrapper<>();
                    queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
                    TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                    if (tbCompany != null) {
                        userPage.get((int) (curIdx + j)).setCompany(tbCompany.getCompanyname());
                    }
//                    if (tb24jiancedataIPage.size()<page.getSize()){

//                    }
//                    tb24jiancedataIPagesize.add(userPage.get((int) (curIdx + j)));


                    if (Objects.equals(userPage.get((int) (curIdx + j)).getTagid(), tbEquipment.get(i).getTagid())) {
                        tb24jiancedataIPage.add(userPage.get((int) (curIdx + j)));

                    }
                }


                if (taol == 0) {
                    taol = userPage.size();
                }

            }
//            System.out.println(userPage.size());

            page.setTotal(taol);
            page.setRecords(tb24jiancedataIPage);
            return page;
        }
    }

    @Override
    public List<TbEvrydayweiyi2024> geteverydaydp(String username) {
        Calendar calendar = Calendar.getInstance();
        String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
        int i1 = (Integer.parseInt(datey.split("-")[2])-1) ;
        String s = datey.split("-")[0] + "-" + datey.split("-")[1] + "-" + i1;

        QueryWrapper queryWrapper2 = new QueryWrapper<>();
        queryWrapper2.eq("username", username);
        TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
        if (Objects.equals(tbUser.getRole(), "超级管理员")) {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("filename", s);

            queryWrapper.orderByDesc("addtime");

            List<TbEvrydayweiyi2024> userPage = tbEvrydayweiyi2024Mapper.selectList(queryWrapper);
            if (userPage.size() > 0) {
                for (int i = 0; i < userPage.size(); i++) {
                    QueryWrapper queryWrapper1 = new QueryWrapper<>();
                    queryWrapper1.eq("tagid", userPage.get(i).getTagid());
                    List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
                    if (tbEquipment.size() > 0) {
                        QueryWrapper queryWrapper3 = new QueryWrapper<>();
                        queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
                        TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                        if (tbCompany != null) {
                            userPage.get(i).setCompany(tbCompany.getCompanyname());
                        }
                        userPage.get(i).setOnlie(tbEquipment.get(0).getOnlie());
                        userPage.get(i).setWinmax(tbUser.getWinmax());
                        userPage.get(i).setWinmin(tbUser.getWinmin());

                    }
                }
                return userPage;
            } else {
                QueryWrapper queryWrapper5 = new QueryWrapper<>();
                queryWrapper5.orderByDesc("addtime");
                List<TbEvrydayweiyi2024> userPage3 = tbEvrydayweiyi2024Mapper.selectList(queryWrapper5);

//                queryWrapper5.
                QueryWrapper queryWrapper4 = new QueryWrapper<>();
                queryWrapper4.eq("filename", userPage3.get(0).getFilename());

                queryWrapper4.orderByDesc("addtime");

                List<TbEvrydayweiyi2024> userPage2 = tbEvrydayweiyi2024Mapper.selectList(queryWrapper4);
                for (int i = 0; i < userPage2.size(); i++) {
                    QueryWrapper queryWrapper1 = new QueryWrapper<>();
                    queryWrapper1.eq("tagid", userPage2.get(i).getTagid());
                    List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
                    if (tbEquipment.size() > 0) {
                        QueryWrapper queryWrapper3 = new QueryWrapper<>();
                        queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
                        TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                        if (tbCompany != null) {
                            userPage2.get(i).setCompany(tbCompany.getCompanyname());
                        }
                        userPage2.get(i).setOnlie(tbEquipment.get(0).getOnlie());
                        userPage2.get(i).setWinmax(tbUser.getWinmax());
                        userPage2.get(i).setWinmin(tbUser.getWinmin());
                    }
                }
                return userPage2;
            }

        } else {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("companyid", tbUser.getCsname());
            List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
            List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
//            long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
//            long taol = 0;
            List<TbEvrydayweiyi2024> userPage = new ArrayList<>();

            if (tb24jiancedataIPage.size() == 0) {
                for (int i = 0; i < tbEquipment.size(); i++) {
                    QueryWrapper queryWrapper5 = new QueryWrapper<>();
                    queryWrapper5.eq("tagid", tbEquipment.get(i).getTagid());
                    queryWrapper5.orderByDesc("addtime");
                    List<TbEvrydayweiyi2024> userPage3 = tbEvrydayweiyi2024Mapper.selectList(queryWrapper5);

                    QueryWrapper queryWrapper1 = new QueryWrapper<>();
                    if (userPage3.size() > 0) {
                        queryWrapper1.eq("filename", userPage3.get(0).getFilename());
//                    queryWrapper1.eq("filename",s );
                        queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
                        queryWrapper.orderByDesc("addtime");

                        userPage = tbEvrydayweiyi2024Mapper.selectList(queryWrapper1);

                        for (int j = 0; j < userPage.size(); j++) {
                            QueryWrapper queryWrapper3 = new QueryWrapper<>();
                            queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
                            TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                            if (tbCompany != null) {
                                userPage.get(j).setCompany(tbCompany.getCompanyname());
                            }
                            userPage.get(j).setOnlie(tbEquipment.get(0).getOnlie());
                            userPage.get(j).setWinmax(tbUser.getWinmax());
                            userPage.get(j).setWinmin(tbUser.getWinmin());
                            tb24jiancedataIPage.add(userPage.get(j));
                        }
                    }

                }
                return tb24jiancedataIPage;
            } else {
                return tb24jiancedataIPage;
            }

        }
    }

    @Override
    public TbEvrydayweiyi2024 getonedesc(String date, String tagid) {
        return tbEvrydayweiyi2024Mapper.getonedesc(date, tagid);
    }


    @Override
    public List<TbEvrydayweiyi2024> listx2(String datey, String username, String date1, String date2) {
        if (username != null) {
            QueryWrapper queryWrapper2 = new QueryWrapper<>();
            queryWrapper2.eq("username", username);
            TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
            if (Objects.equals(tbUser.getRole(), "超级管理员")) {
                return tbEvrydayweiyi2024Mapper.listx2(datey, date1, date2);
            } else {
                QueryWrapper queryWrapper = new QueryWrapper<>();
                queryWrapper.eq("companyid", tbUser.getCsname());
                List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
                List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
                long taol = 0;
                List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
                for (int i = 0; i < tbEquipment.size(); i++) {
                    QueryWrapper queryWrapper1 = new QueryWrapper<>();
                    queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
                    userPage = tbEvrydayweiyi2024Mapper.listx3(datey, tbEquipment.get(i).getTagid(), date1, date2);
                    for (int j = 0; j < userPage.size(); j++) {
                        QueryWrapper queryWrapper3 = new QueryWrapper<>();
                        queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
                        TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                        if (tbCompany != null) {
                            userPage.get(j).setCompany(tbCompany.getCompanyname());
                        }
                        tb24jiancedataIPage.add(userPage.get(j));
                    }
                }
                return tb24jiancedataIPage;
            }
        } else {
            return tbEvrydayweiyi2024Mapper.listx2(datey, date1, date2);
        }

    }

    @Override
    public List<TbEvrydayweiyi2024> listx3(String datey, String username, String date1, String date2, String tagid) {
        if (username != null) {
            QueryWrapper queryWrapper2 = new QueryWrapper<>();
            queryWrapper2.eq("username", username);
            TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
//            if (Objects.equals(tbUser.getRole(), "超级管理员")) {
            return tbEvrydayweiyi2024Mapper.listx3(datey, tagid, date1, date2);
//            }else{
//                QueryWrapper queryWrapper = new QueryWrapper<>();
//                queryWrapper.eq("companyid", tbUser.getCsname());
//                List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
//                List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
//                long taol = 0;
//                List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
//                for (int i = 0; i < tbEquipment.size(); i++) {
//                    QueryWrapper queryWrapper1 = new QueryWrapper<>();
//                    queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
//                    userPage = tbEvrydayweiyi2024Mapper.listx3(datey,tbEquipment.get(i).getTagid(), date1, date2);
//                    for (int j = 0; j <  userPage.size(); j++) {
//                        QueryWrapper queryWrapper3 = new QueryWrapper<>();
//                        queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
//                        TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
//                        if (tbCompany != null) {
//                            userPage.get(j).setCompany(tbCompany.getCompanyname());
//                        }
//                        tb24jiancedataIPage.add(userPage.get(j));
//                    }
//                }
//                return tb24jiancedataIPage;
//            }
        } else {
            return tbEvrydayweiyi2024Mapper.listx3(datey, tagid, date1, date2);
        }

    }

    @Override
    public TbEvrydayweiyi2024 getweiyi( String tagid) {
        Calendar calendar = Calendar.getInstance();
        String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy");
//        Calendar date = Calendar.getInstance();
//        String date1 = DateUtil.formatDate(calendar.getTime(), "yyyy-MM-dd");
        Date date = new Date();
        SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");

//        Calendar calendar = Calendar.getInstance();
        String dated = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
        int i1 = (Integer.parseInt(dated.split("-")[2])-1) ;
        String s = dated.split("-")[0] + "-" + dated.split("-")[1] + "-" + i1;
            return tbEvrydayweiyi2024Mapper.getweiyi(datey, tagid, s);
    }

    @Override
    public Map<String, Object> gettagidweiyi( String tagid) {
//        List<TbEvrydayweiyi2024> tbEvrydayweiyi2024s = new ArrayList<>();
        Map<String, Object> result = new HashMap<>();
        String[] hd = new String[tagid.split(",").length];
        String[] ed = new String[tagid.split(",").length];
        String[] nd = new String[tagid.split(",").length];
        String[] x = new String[tagid.split(",").length];
        for (int i = 0; i < tagid.split(",").length; i++) {
            Calendar calendar = Calendar.getInstance();
            String datey = DateUtil.formatDate4(calendar.getTime(), "yyyy");
//        Calendar date = Calendar.getInstance();
//        String date1 = DateUtil.formatDate(calendar.getTime(), "yyyy-MM-dd");
            Date date = new Date();
            SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");

//        Calendar calendar = Calendar.getInstance();
            String dated = DateUtil.formatDate4(calendar.getTime(), "yyyy-MM-dd");
            int i1 = (Integer.parseInt(dated.split("-")[2])-1) ;
            String s = dated.split("-")[0] + "-" + dated.split("-")[1] + "-" + i1;
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("tagid", tagid.split(",")[i]);
            TbEquipment tbEquipment = tbEquipmentMapper.selectOne(queryWrapper);

            if (tbEquipment!=null){

                hd[i] = tbEquipment.getHdmm();
                ed[i] = tbEquipment.getEdmm();
                nd[i] =tbEquipment.getNdmm();
//                x[i] = tbEvrydayweiyi2024Mapper.getweiyi(datey, tagid.split(",")[i], s).getFilename();
            }else{
                hd[i] = "0";
                ed[i] = "0";
                nd[i] ="0";
//                x[i] = "0";
            }
        }
        result.put("ed", ed);
        result.put("nd", nd);
        result.put("hd", hd);
//            result.put("x", x);
        return result;
    }

    @Override
    public IPage<TbEvrydayweiyi2024> searcheveryday(Page page, String keyword, String username, String time) {


        QueryWrapper queryWrapper2 = new QueryWrapper<>();
        queryWrapper2.eq("username", username);
        TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
        if (Objects.equals(tbUser.getRole(), "超级管理员")) {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            if (keyword != null) {
                QueryWrapper queryWrapper3 = new QueryWrapper<>();
                queryWrapper3.eq("anchorname", keyword);
                List<TbEquipment> anchorname1 = baseMapper.selectList(queryWrapper3);
                QueryWrapper queryWrapper4 = new QueryWrapper<>();
                queryWrapper4.eq("tagid", keyword);
                List<TbEvrydayweiyi2024> tagid1 = baseMapper.selectList(queryWrapper4);
                if (tagid1.size() > 0) {

                    queryWrapper.eq("tagid", keyword);
                } else {
                    queryWrapper.eq("anchorname", keyword);
                }
            }
            if (time != null) {
                int i1 = (Integer.parseInt(time.split("-")[2])-1) ;
                String s = time.split("-")[0] + "-" + time.split("-")[1] + "-" + i1;
                queryWrapper.eq("filename", s);

            }
            queryWrapper.orderByDesc("addtime");
            IPage<TbEvrydayweiyi2024> userPage = tbEvrydayweiyi2024Mapper.selectPage(page, queryWrapper);
            for (int i = 0; i < userPage.getRecords().size(); i++) {
                QueryWrapper queryWrapper1 = new QueryWrapper<>();
                queryWrapper1.eq("tagid", userPage.getRecords().get(i).getTagid());
                List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper1);
                if (tbEquipment.size() > 0) {
                    QueryWrapper queryWrapper3 = new QueryWrapper<>();
                    queryWrapper3.eq("id", tbEquipment.get(0).getCompanyid());
                    TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                    if (tbCompany != null) {
                        userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
                    }
                }
            }
            return userPage;
        } else {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("companyid", tbUser.getCsname());
            List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
            List<TbEvrydayweiyi2024> tb24jiancedataIPage = new ArrayList<>();
            long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
            long taol = 0;
            List<TbEvrydayweiyi2024> userPage = new ArrayList<>();
            for (int i = 0; i < tbEquipment.size(); i++) {
                QueryWrapper queryWrapper1 = new QueryWrapper<>();
//                queryWrapper.eq("anchorname", keyword);
//                queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
//                QueryWrapper queryWrapper1 = new QueryWrapper<>();
                if (keyword != null) {
                    QueryWrapper queryWrapper3 = new QueryWrapper<>();
                    queryWrapper3.eq("anchorname", keyword);
                    List<TbEquipment> anchorname1 = baseMapper.selectList(queryWrapper3);
                    QueryWrapper queryWrapper4 = new QueryWrapper<>();
                    queryWrapper4.eq("tagid", keyword);
                    List<TbEvrydayweiyi2024> tagid1 = baseMapper.selectList(queryWrapper4);
                    if (tagid1.size() > 0) {

                        queryWrapper1.eq("tagid", keyword);
                    } else {
                        queryWrapper1.eq("anchorname", keyword);
                    }
                }
                if (time != null) {
                    int i1 = (Integer.parseInt(time.split("-")[2])-1) ;
                    String s = time.split("-")[0] + "-" + time.split("-")[1] + "-" + i1;
                    queryWrapper1.eq("filename", s);
                }
                queryWrapper1.orderByDesc("addtime");
                userPage = tbEvrydayweiyi2024Mapper.selectList(queryWrapper1);
                for (int j = 0; j < page.getSize() && curIdx + j < userPage.size(); j++) {
                    QueryWrapper queryWrapper3 = new QueryWrapper<>();
                    queryWrapper3.eq("id", tbEquipment.get(i).getCompanyid());
                    TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper3);
                    if (tbCompany != null) {
                        userPage.get((int) (curIdx + j)).setCompany(tbCompany.getCompanyname());
                    }
                    if (Objects.equals(userPage.get((int) (curIdx + j)).getTagid(), tbEquipment.get(i).getTagid())) {
                        tb24jiancedataIPage.add(userPage.get((int) (curIdx + j)));
                    }
                }
                if (taol == 0) {
                    taol = userPage.size();
                }
            }
            page.setTotal(taol);
            page.setRecords(tb24jiancedataIPage);
            return page;
        }

//        QueryWrapper<TbEvrydayweiyi2024> queryWrapper = new QueryWrapper<>();
//        queryWrapper.eq("ip", keyword);
//        IPage<TbEvrydayweiyi2024> ip = baseMapper.selectPage(page, queryWrapper);
//        return ip;

    }


}