package com.hxzkmonitor.service.impl;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.hxzkmonitor.mapper.*;
import com.hxzkmonitor.pojo.*;
import com.hxzkmonitor.service.TbTestdata20240706Service;
import com.hxzkmonitor.util.DateUtil;
import lombok.RequiredArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
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 TbTestdata20240706ServiceImpl extends ServiceImpl<TbTestdata20240706Mapper, TbTestdata20240706> implements TbTestdata20240706Service {
    private final TbTestdata20240706Mapper TbTestdata20240706Mapper;

    private final TbUserMapper tbUserMapper;

    private final TbEquipmentMapper tbEquipmentMapper;

    private final TbCompanyMapper tbCompanyMapper;

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

    @Override
    public IPage<TbTestdata20240706> everydayxs(Page page, String keyword, String username, String time, String isdp) {
        Calendar calendar = Calendar.getInstance();
        String datey = DateUtil.formatDate4(calendar.getTime(), "yyyyMMdd");
        Page<TbTestdata20240706> pages = new Page<>(page.getCurrent(), page.getSize());
        IPage<TbTestdata20240706>  userPage = TbTestdata20240706Mapper.listall(pages,datey);
        for (int i = 0; i < userPage.getRecords().size(); i++) {
            QueryWrapper queryWrapper1 = new QueryWrapper<>();
            queryWrapper1.eq("id", userPage.getRecords().get(i).getCompanyid());
            TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper1);
            if (tbCompany != null) {
                userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
            }
        }
        return userPage;


    }

    @Override
    public List<TbTestdata20240706> 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<TbTestdata20240706> userPage = TbTestdata20240706Mapper.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());
                        }


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

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

                queryWrapper4.orderByDesc("addtime");

                List<TbTestdata20240706> userPage2 = TbTestdata20240706Mapper.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());
                        }
                    }
                }
                return userPage2;
            }

        } else {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("companyid", tbUser.getCsname());
            List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
            List<TbTestdata20240706> tb24jiancedataIPage = new ArrayList<>();
//            long curIdx = page.getCurrent() > 1 ? (page.getCurrent() - 1) * page.getSize() : 0;
//            long taol = 0;
            List<TbTestdata20240706> 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<TbTestdata20240706> userPage3 = TbTestdata20240706Mapper.selectList(queryWrapper5);

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

                        userPage = TbTestdata20240706Mapper.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());
                            }
                            tb24jiancedataIPage.add(userPage.get(j));
                        }
                    }

                }
                return tb24jiancedataIPage;
            } else {
                return tb24jiancedataIPage;
            }

        }
    }

    @Override
    public TbTestdata20240706 getonedesc(String date, String tagid) {
        return TbTestdata20240706Mapper.getonedesc(date, tagid);
    }


    @Override
    public List<TbTestdata20240706> listx2(String datey, String username) {
        if (username != null) {
            QueryWrapper queryWrapper2 = new QueryWrapper<>();
            queryWrapper2.eq("username", username);
            TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
            if (Objects.equals(tbUser.getRole(), "超级管理员")) {
                return TbTestdata20240706Mapper.listx2(datey);
            } else {
                QueryWrapper queryWrapper = new QueryWrapper<>();
                queryWrapper.eq("companyid", tbUser.getCsname());
                List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
                List<TbTestdata20240706> tb24jiancedataIPage = new ArrayList<>();
                long taol = 0;
                List<TbTestdata20240706> userPage = new ArrayList<>();
                for (int i = 0; i < tbEquipment.size(); i++) {
                    QueryWrapper queryWrapper1 = new QueryWrapper<>();
                    queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
                    userPage = TbTestdata20240706Mapper.listx3(datey, tbEquipment.get(i).getTagid());
                    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 TbTestdata20240706Mapper.listx2(datey);
        }

    }

    @Override
    public List<TbTestdata20240706> listx3(String datey, String username,String tagid) {
        if (username != null) {
            QueryWrapper queryWrapper2 = new QueryWrapper<>();
            queryWrapper2.eq("username", username);
            TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
//            if (Objects.equals(tbUser.getRole(), "超级管理员")) {
            return TbTestdata20240706Mapper.listx3(datey, tagid);
//            }else{
//                QueryWrapper queryWrapper = new QueryWrapper<>();
//                queryWrapper.eq("companyid", tbUser.getCsname());
//                List<TbEquipment> tbEquipment = tbEquipmentMapper.selectList(queryWrapper);
//                List<TbTestdata20240706> tb24jiancedataIPage = new ArrayList<>();
//                long taol = 0;
//                List<TbTestdata20240706> userPage = new ArrayList<>();
//                for (int i = 0; i < tbEquipment.size(); i++) {
//                    QueryWrapper queryWrapper1 = new QueryWrapper<>();
//                    queryWrapper1.eq("tagid", tbEquipment.get(i).getTagid());
//                    userPage = TbTestdata20240706Mapper.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 TbTestdata20240706Mapper.listx3(datey, tagid);
        }

    }

    @Override
    public TbTestdata20240706 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 TbTestdata20240706Mapper.getweiyi(datey, tagid, s);
    }

    @Override
    public Map<String, Object> gettagidweiyi( String tagid) {
//        List<TbTestdata20240706> TbTestdata20240706s = 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] = TbTestdata20240706Mapper.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<TbTestdata20240706> searcheveryxsday(Page page, String keyword, String username, String time) {
        Calendar calendar = Calendar.getInstance();
        String datey = DateUtil.formatDate4(calendar.getTime(), "yyyyMMdd");

        QueryWrapper queryWrapper2 = new QueryWrapper<>();
        queryWrapper2.eq("username", username);
        TbUser tbUser = tbUserMapper.selectOne(queryWrapper2);
        if (Objects.equals(tbUser.getRole(), "超级管理员")) {
            QueryWrapper queryWrapper = new QueryWrapper<>();
            queryWrapper.orderByDesc("addtime");
            Page<TbTestdata20240706> pages = new Page<>(page.getCurrent(), page.getSize());
            IPage<TbTestdata20240706>  userPage = TbTestdata20240706Mapper.seachlistall(pages,datey,keyword);
            for (int i = 0; i < userPage.getRecords().size(); i++) {
                QueryWrapper queryWrapper1 = new QueryWrapper<>();
                queryWrapper1.eq("id", userPage.getRecords().get(i).getCompanyid());
                TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper1);
                if (tbCompany != null) {
                    userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
                }
            }
            return userPage;
        } else {
            Page<TbTestdata20240706> pages = new Page<>(page.getCurrent(), page.getSize());
            IPage<TbTestdata20240706>  userPage = TbTestdata20240706Mapper.seachlistallname(pages,datey,keyword, String.valueOf(tbUser.getCsname()));
            for (int i = 0; i < userPage.getRecords().size(); i++) {
                QueryWrapper queryWrapper1 = new QueryWrapper<>();
                queryWrapper1.eq("id", userPage.getRecords().get(i).getCompanyid());
                TbCompany tbCompany = tbCompanyMapper.selectOne(queryWrapper1);
                if (tbCompany != null) {
                    userPage.getRecords().get(i).setCompany(tbCompany.getCompanyname());
                }
            }
            return userPage;
        }

    }

}