package com.xzx.gc.system.service;

import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.convert.Convert;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.lang.Dict;
import cn.hutool.core.util.NumberUtil;
import cn.hutool.core.util.StrUtil;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.xzx.gc.common.constant.Constants;
import com.xzx.gc.common.exception.RestException;
import com.xzx.gc.common.utils.BusinessUtil;
import com.xzx.gc.common.utils.RedisUtil;
import com.xzx.gc.entity.*;
import com.xzx.gc.model.admin.ItemModel;
import com.xzx.gc.model.admin.OrderModel;
import com.xzx.gc.model.admin.StorageModel;
import com.xzx.gc.model.order.FenceDto;
import com.xzx.gc.model.order.ItemDto;
import com.xzx.gc.model.system.QueryParentDTO;
import com.xzx.gc.model.system.SysEnvironmentalInfoListReq;
import com.xzx.gc.model.system.SysEnvironmentalInfoReq;
import com.xzx.gc.model.system.SysEnvironmentalInfoVo;
import com.xzx.gc.system.mapper.AddressMapper;
import com.xzx.gc.system.mapper.OrderItemInfoMapper;
import com.xzx.gc.system.mapper.OrderStorageDetailMapper;
import com.xzx.gc.system.mapper.SysEnvironmentalInfoMapper;
import com.xzx.gc.util.DoubleUtil;
import com.xzx.gc.util.SessionUtil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import tk.mybatis.mapper.entity.Example;

import javax.servlet.http.HttpServletRequest;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.*;
import java.util.stream.Collectors;

@Service
@Transactional
@Slf4j
public class SysEnvironmentalInfoService{

    @Autowired
    private SysEnvironmentalInfoMapper sysEnvironmentalInfoMapper;

    @Autowired
    private UserService userService;

    @Autowired
    private BusinessUtil businessUtil;

    @Autowired
    private PartnerGaodeService partnerGaodeService;
    @Autowired
    private FenceService fenceService;

    @Autowired
    private AddressMapper addressMapper;
    @Autowired
    private CityPartnerService cityPartnerService;

    @Autowired
    private AddressLevelService addressLevelService;

    @Autowired
    private OrderService orderService;

    @Autowired
    private OrderItemInfoMapper orderItemInfoMapper;

    @Autowired
    private OrderStorageDetailMapper orderStorageDetailMapper;

    @Autowired
    private SysItemPriceService sysItemPriceService;


    public List<SysEnvironmentalInfoVo> getSysEnvironmentalInfoList(SysEnvironmentalInfoReq sysEnvironmentalInfoReq) {

        //回收员ID
        String receiver = sysEnvironmentalInfoReq.getReceiver();
        String townId=Constants.TIANXIN_CODE;
        int unionFlag = sysEnvironmentalInfoReq.getUnionFlag();

        List<SysEnvironmentalInfo> byPartnerId=CollUtil.newArrayList();
        //区域id  安卓会传送同时分类将显示所有合伙人区域下的分类取并集
        String areaId = sysEnvironmentalInfoReq.getAreaId();

        if (StrUtil.isBlank(areaId)) {


            if(StrUtil.isNotBlank(sysEnvironmentalInfoReq.getAddressId())){

                AddressInfo addressInfo = addressMapper.selectByPrimaryKey(sysEnvironmentalInfoReq.getAddressId());
                if(StrUtil.isNotBlank(addressInfo.getTownshipId())) {
                    FenceDto fence = fenceService.getFence(addressInfo.getTownshipId(), false, addressInfo.getLongitude(), addressInfo.getLatitude(), true);
                    if (StrUtil.isNotBlank(fence.getFenceId())) {
                        townId = fenceService.findTownId(addressInfo.getTownshipId(), fence.getFenceId());
                    }
                }else {
                    townId=Constants.DEFAULT_ID;
                }
            }else {
                //普通用户
                String longitude = sysEnvironmentalInfoReq.getLongitude();

                if(StrUtil.isNotBlank(longitude)){
                    String latitude = sysEnvironmentalInfoReq.getLatitude();
                    String location = longitude + "," + latitude;
                    //根据用户经纬度查询位置
                    AddressLevelInfo byLocation = userService.findByLocation(location);
                    if (byLocation != null) {
                        townId = byLocation.getLevel3Id();
                        FenceDto fence = fenceService.getFence(townId, false, location.split(",")[0], location.split(",")[1], true);
                        if(StrUtil.isNotBlank(fence.getFenceId())){
                            townId =fenceService.findTownId(townId, fence.getFenceId());
                        }
                    }
                }
            }
        } else {
            townId=sysEnvironmentalInfoReq.getAreaId();

            if(unionFlag==1) {
                //根据区域查询合伙人Id
                PartnerGaode byTownId = partnerGaodeService.findByTownId(townId);
                String partnerId = byTownId.getPartnerId();
                //根据合伙人查询所有分类
                byPartnerId =findByPartnerIdForSecond(partnerId);
            }
        }

        //要根据用户所在的市去查找对应的分类价格
        List<SysEnvironmentalInfoVo> list;

        //type 1为大类 2为物品
        Dict dict = Dict.create().set("type", 1);
        dict.set("cityId",townId);

        //是否首页展示
//        if("1".equals(sysEnvironmentalInfoReq.getHomeFlag())){
//            dict.set("showFlag","1");
//        }

        list = sysEnvironmentalInfoMapper.getSysEnvironmentalInfoListWithMap(dict);
        if(CollUtil.isNotEmpty(list)){
                setSecondList(list,townId,false,receiver);
                //合伙人区域下的分类取并集
                if(unionFlag==1){
                    setUnion(list, byPartnerId);
                }

        }else {

            //取天心区的分类 但不显示价格
            townId=Constants.TIANXIN_CODE;
            dict = Dict.create().set("type", 1);
            dict.set("cityId",townId);
            list = sysEnvironmentalInfoMapper.getSysEnvironmentalInfoListWithMap(dict);
            if(CollUtil.isNotEmpty(list)){
                setSecondList(list,townId,true,receiver);
            }
        }
        return list;
    }

    public List<SysEnvironmentalInfoVo> homeAppliance(String townId) {
        townId=Constants.TIANXIN_CODE;
        List<SysEnvironmentalInfoVo> byCityId = getByTownIdForHome(townId);
        if(CollUtil.isEmpty(byCityId)){
            townId=Constants.TIANXIN_CODE;
            byCityId=getByTownIdForHome(townId);
        }
        return  byCityId;
    }

    private List<SysEnvironmentalInfoVo> getByTownIdForHome(String townId){
        Dict dict = Dict.create().set("type", 1);
        dict.set("cityId",townId);
        List<SysEnvironmentalInfoVo> list = sysEnvironmentalInfoMapper.getSysEnvironmentalInfoListWithMap(dict);
        list=list.stream().filter(x->x.getItemType().equals(Constants.HOUSE_HOLD_ITEM_TYPE)||x.getItemType().equals(Constants.HOUSE_HOLD_OTHER_ITEM_TYPE)).collect(Collectors.toList());
        if(CollUtil.isNotEmpty(list)){
            setSecondList(list,townId,false,null);
        }
        return list;
    }

    public List<SysEnvironmentalInfo>  findByPartnerIdForSecond(String partnerId){
        Example example=new Example(SysEnvironmentalInfo.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("delFlag",Constants.DEL_NOT_FLAG);
        criteria.andEqualTo("partnerId",partnerId);
        criteria.andIsNotNull("parentId");
        return sysEnvironmentalInfoMapper.selectByExample(example);
    }


    private void setUnion(  List<SysEnvironmentalInfoVo> list,List<SysEnvironmentalInfo> byPartnerId){

        List<SysEnvironmentalInfoVo> allList=CollUtil.newArrayList();
        for (SysEnvironmentalInfoVo sysEnvironmentalInfoVo:list){
            List<SysEnvironmentalInfoVo> list1 = sysEnvironmentalInfoVo.getList();
            CollUtil.addAll(allList,list1);
        }


        for (SysEnvironmentalInfo sysEnvironmentalInfo : byPartnerId) {
            String itemType = sysEnvironmentalInfo.getItemType();
            long count = allList.stream().filter(x -> x.getItemType().equals(itemType)).count();
            if(count==0){
                //不属于当前区域的价格全都置于0
                SysEnvironmentalInfoVo sysEnvironmentalInfoVo=new SysEnvironmentalInfoVo();
                BeanUtil.copyProperties(sysEnvironmentalInfo,sysEnvironmentalInfoVo);
                sysEnvironmentalInfoVo.setPrice(Constants.MONEY_INIT.toString());
                sysEnvironmentalInfoVo.setSecondPrice(Constants.MONEY_INIT.toString());
                sysEnvironmentalInfoVo.setPutStoragePrice(Constants.MONEY_INIT);
                allList.add(sysEnvironmentalInfoVo);
            }
        }

        for (int i = 0; i < list.size(); i++) {
            SysEnvironmentalInfoVo sysEnvironmentalInfoVo = list.get(i);
            if(i==0) {
                sysEnvironmentalInfoVo.setList(allList);
            }else {
                sysEnvironmentalInfoVo.setList(CollUtil.newArrayList());
            }
        }
    }
    /**
     * 获取二级分类
     * @param list
     * @param cityId
     * @param hidePrice 是否隐藏价格
     */
    private void setSecondList(  List<SysEnvironmentalInfoVo> list,String cityId,boolean hidePrice,String receiver){
        for (SysEnvironmentalInfoVo sysEnvironmentalInfoVo : list) {
            Long id = sysEnvironmentalInfoVo.getId();
            if(hidePrice){
                sysEnvironmentalInfoVo.setPutStoragePrice(null);
                sysEnvironmentalInfoVo.setSecondPrice(null);
                sysEnvironmentalInfoVo.setPrice(null);
            }
            Dict dict = Dict.create();
            dict.set("parentId",id);
            dict.set("type",2);
            dict.set("cityId",cityId);
            List<SysItemPrice> priceList=null;
            if(StrUtil.isNotBlank(receiver)) {
                priceList=sysItemPriceService.findPriceByUserId(receiver);
            }
            List<SysEnvironmentalInfoVo> sysEnvironmentalInfoList = sysEnvironmentalInfoMapper.getSysEnvironmentalInfoListWithMap(dict);
            for (SysEnvironmentalInfoVo environmentalInfoVo : sysEnvironmentalInfoList) {
                if(hidePrice){
                    environmentalInfoVo.setPutStoragePrice(null);
                    environmentalInfoVo.setSecondPrice(null);
                    environmentalInfoVo.setPrice(null);
                }

                //根据每个分类查询出回收员设定的价格
                if(CollUtil.isNotEmpty(priceList)){
                    List<SysItemPrice> byItemAndList = sysItemPriceService.findByItemAndList(priceList, environmentalInfoVo.getItemType());
                    environmentalInfoVo.setPriceList(byItemAndList);
                }

            }


            //查询所有分类的售卖次数  按合伙人区分
//            if(businessUtil.getVersion(request.getHeader("version")).compareTo(Convert.toDouble(CommonEnum.版本号1点6.getValue()))>=0) {
//                if(CollUtil.isNotEmpty(sysEnvironmentalInfoList)){
//                    //根据区域查找合伙人
//                    String partnerId=null;
//                    PartnerGaode byCityId=null;
//                    if(level==2){
//                        byCityId = partnerGaodeService.findByCityId(cityId);
//                    }else if(level==3){
//                        byCityId = partnerGaodeService.findByTownId(cityId);
//                    }
//
//                    if(byCityId!=null){
//                        partnerId = byCityId.getPartnerId();
//                        List<OrderItemInfo> orderItemInfos = orderItemService.sumGroupTypeByPatnerId(partnerId);
//                        if(CollUtil.isNotEmpty(orderItemInfos)){
//                            for (SysEnvironmentalInfoVo environmentalInfoVo : sysEnvironmentalInfoList) {
//                                String itemType = environmentalInfoVo.getItemType();
//                                List<OrderItemInfo> collect = orderItemInfos.stream().filter(x -> x.getItemType().equals(itemType)).collect(Collectors.toList());
//                                if(CollUtil.isNotEmpty(collect)){
//                                    int saleNum = collect.get(0).getSaleNum();
//                                    String s = StringUtils.intChange2Str(saleNum);
//                                    environmentalInfoVo.setSaleNum(s);
//                                }
//                            }
//                        }
//                    }
//                }
//            }

            /**
             * 根据分类查订单分类
             */
            sysEnvironmentalInfoVo.setList(sysEnvironmentalInfoList);
        }
    }


    /**
     * 批量修改分类价格
     */
    public void batchUpdateSysEnvironmentalInfo(SysEnvironmentalInfoListReq infoListReq){
        String areaId = infoListReq.getAreaId();
        String partnerId = infoListReq.getPartnerId();
        List<SysEnvironmentalInfoReq> sysEnvironmentalInfoList= infoListReq.getSysEnvironmentalInfoList();
        if (CollUtil.isNotEmpty(sysEnvironmentalInfoList)){
                for (SysEnvironmentalInfoReq req : sysEnvironmentalInfoList) {
                    int unionFlag = req.getUnionFlag();
                    SysEnvironmentalInfo sysEnvironmentalInfo=new SysEnvironmentalInfo();
                    sysEnvironmentalInfo.setPrice(req.getPrice());
                    sysEnvironmentalInfo.setSecondPrice(req.getSecondPrice());
                    sysEnvironmentalInfo.setPutStoragePrice(businessUtil.changeMul(Convert.toBigDecimal(req.getPutStoragePrice())));
                    if(unionFlag==0){
                        //根据区域和itemType修改
                        Example example=new Example(SysEnvironmentalInfo.class);
                        Example.Criteria criteria = example.createCriteria();
                        criteria.andEqualTo("delFlag",Constants.DEL_NOT_FLAG);
                        criteria.andEqualTo("cityId",areaId);
                        criteria.andEqualTo("itemType",req.getItemType());
                        sysEnvironmentalInfoMapper.updateByExampleSelective(sysEnvironmentalInfo,example);
                    }else if(unionFlag==1){
                        //应用到所有  根据合伙人和itemType修改
                        Example example=new Example(SysEnvironmentalInfo.class);
                        Example.Criteria criteria = example.createCriteria();
                        criteria.andEqualTo("delFlag",Constants.DEL_NOT_FLAG);
                        criteria.andEqualTo("partnerId",partnerId);
                        criteria.andEqualTo("itemType",req.getItemType());
                        sysEnvironmentalInfoMapper.updateByExampleSelective(sysEnvironmentalInfo,example);
                    }
                }
        }
    }


    /**
     * 后台分类列表查询
     * @param item
     * @return
     */
    public Map<String, Object> querOperaIteml(ItemModel item) {

        List<String> partnerIds = new ArrayList<>();
        if(null!=item.getPartnerId()&&!"".equals(item.getPartnerId())){
            partnerIds.add(item.getPartnerId());
        }else{
            partnerIds = cityPartnerService.queryPartnerByCurrent();
        }
        if (null != partnerIds && partnerIds.size() > 0) {
            List<String> townIds = cityPartnerService.queryTownIdsByPartnerId(partnerIds.get(0));
            item.setTownIdList(townIds);
        }
        Map<String, Object> map = new HashMap<>();
        PageHelper.startPage(item.getPageNum(),item.getLimitNum());
        List<ItemModel> list = sysEnvironmentalInfoMapper.queryOperaIteml(item);
        PageInfo<ItemModel> pageInfo=new PageInfo<>(list);
        for (ItemModel itemModel : list) {
            String townId = itemModel.getCityId();
            if (null != townId && !"".equals(townId)) {
                Map<String, Object> objmap = addressLevelService.queryCityByTownId(townId);
                String cityId = objmap.get("cid").toString();
                String pid = objmap.get("pid").toString();

                List<List<String>> resList = new ArrayList<>();
                List<String> detailList = new ArrayList<>();
                detailList.add(pid);
                detailList.add(cityId);
                detailList.add(townId);
                resList.add(detailList);
                itemModel.setResultArea(resList);

            }

        }
        map.put("data", list);
        map.put("count", pageInfo.getTotal());
        map.put("code", 0);
        return map;
    }

    /**
     * 后台类别查询
     * @param item
     * @return
     */
    public Map<String, Object> queryOperateItemList(ItemModel item) {
        Map<String, Object> map = new HashMap<>();
        PageHelper.startPage(item.getPageNum(),item.getLimitNum());
        List<ItemModel> list =  sysEnvironmentalInfoMapper.queryOperateItemList(item);
        PageInfo<ItemModel> pageInfo=new PageInfo<>(list);

        for (ItemModel obj : list) {
            obj = queryChildItem(obj);
        }
        map.put("data", list);
        map.put("count", pageInfo.getTotal());
        map.put("code", 0);
        return map;
    }


    /**
     * 无限子类算法（时间有限）
     *
     * @param item
     * @return
     */
    private ItemModel queryChildItem(ItemModel item) {
        List<ItemModel> child = sysEnvironmentalInfoMapper.queryOperateItemChildren(item);
        List<ItemModel> childm = new ArrayList<>();
        for (ItemModel obj : child) {
            childm.add(obj);
        }
        item.setChildren(childm);
        for (ItemModel cObj : childm) {
            if (null != cObj.getParentId()) {
                queryChildItem(cObj);
            }
        }
        return item;
    }

    public Map<String, Object> updateOperateItem(ItemModel item) {
        Map<String, Object> map = new HashMap<>();
        String cityId = item.getCityId();
        PartnerGaode byTownId = partnerGaodeService.findByTownId(cityId);

        //根据区域查询围栏
        List<String>  townIds = cityPartnerService.queryFenceIdByPartnerId(byTownId.getPartnerId());
        List<OrderModel> orderList = orderService.queryOrderByCityId(cityId,townIds);
        if(CollUtil.isNotEmpty(orderList)) {
            throw new RestException("存在待入库和入库中的订单");
        }
        String title=item.getTitle();

        SysEnvironmentalInfo sysEnvironmentalInfo = sysEnvironmentalInfoMapper.selectByPrimaryKey(item.getId());
        if(!sysEnvironmentalInfo.getTitle().equals(title)){
            SysEnvironmentalInfo byCityAndTitle = findByCityAndTitle(title, cityId);
            if(byCityAndTitle!=null){
                throw new RestException("当前分类已存在");
            }
        }


        // 对排序字段进行处理
        setSort(item);

        int i = updateItem(item);

        //父类隐藏则子类都隐藏
        if(0==Convert.toInt(item.getShowFlag(),1)) {
            if (sysEnvironmentalInfo.getParentId() == null) {
                List<ItemModel> children = item.getChildren();
                for (ItemModel child : children) {
                    SysEnvironmentalInfo obj = new SysEnvironmentalInfo();
                    obj.setId(child.getId());
                    obj.setShowFlag(Convert.toShort(0));
                    sysEnvironmentalInfoMapper.updateByPrimaryKeySelective(obj);
                }
            }
        }
        setSortAggin(item);
        map.put("code", 0);
        map.put("num", i);
        return map;
    }


    private int updateItem(ItemModel item){
        return sysEnvironmentalInfoMapper.updateItem(item);
    }


    private void setSort(ItemModel item) {
        ItemModel im = new ItemModel();
        im.setLimit(1000);
        im.setParentId(item.getParentId());
        List<ItemModel> list = sysEnvironmentalInfoMapper.querIteml(im);
        // 找到原始的sort数据
        int originalSort = item.getSort();

        for (ItemModel imx : list) {
            if (originalSort <= imx.getSort()) {
                imx.setSort(imx.getSort() + 1);
            }
        }
        for (ItemModel imx : list) {
            updateItem(imx);
        }
    }


    private void setSortAggin(ItemModel item) {
        ItemModel im = new ItemModel();
        im.setLimit(1000);
        im.setParentId(item.getParentId());
        List<ItemModel> list = sysEnvironmentalInfoMapper.querIteml(im);
        list.sort((x, y) -> Integer.compare(x.getSort(), y.getSort()));
        int f = 1;
        for (ItemModel itemModel : list) {
            itemModel.setSort(f++);
        }
        for (ItemModel itemModel : list) {
            updateItem(itemModel);
        }
    }

    /**
     * 根据城市和标题查询
     * @param title
     * @param cityId
     * @return
     */
    public SysEnvironmentalInfo findByCityAndTitle(String title,String cityId){
        SysEnvironmentalInfo sysEnvironmentalInfo=new SysEnvironmentalInfo();
        sysEnvironmentalInfo.setCityId(Convert.toInt(cityId));
        sysEnvironmentalInfo.setTitle(title);
        sysEnvironmentalInfo.setDelFlag(0);
        return sysEnvironmentalInfoMapper.selectOne(sysEnvironmentalInfo);
    }

    public SysEnvironmentalInfo findById(Long id){
        return sysEnvironmentalInfoMapper.selectByPrimaryKey(id);
    }

    public SysEnvironmentalInfo findByItemTypeAndAreaNotDel(String itemType,Integer areaId) {
        Example example=new Example(SysEnvironmentalInfo.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("itemType",itemType);
        criteria.andEqualTo("cityId",areaId);
        criteria.andEqualTo("delFlag",Constants.DEL_NOT_FLAG);
        SysEnvironmentalInfo sysEnvironmentalInfo1 = sysEnvironmentalInfoMapper.selectOneByExample(example);
        return  sysEnvironmentalInfo1;
    }


    public Map<String, Object> addOperateParent(ItemModel item) {
        List<String> townIdList = item.getTownIdList();
        String cityId = townIdList.get(0);
        PartnerGaode byTownId = partnerGaodeService.findByTownId(cityId);
        item.setPartnerId(byTownId.getPartnerId());
        String title = item.getTitle();
        Map<String, Object> map = new HashMap<>();
        Long parentId = item.getParentId();

        //验证 如果是天心区 大类和物品都不能出现重复标题  不是天心区，则要验证物品不能出现重复名称
        if(Constants.TIANXIN_CODE.equals(cityId)){
            SysEnvironmentalInfo byCityAndTitle = findByCityAndTitle(title, cityId);
            if(byCityAndTitle!=null){
                throw new RestException("已经有相同的物品");
            }
        }else{
            if(parentId!=null) {
                SysEnvironmentalInfo byCityAndTitle = findByCityAndTitle(title, cityId);
                if(byCityAndTitle!=null){
                    throw new RestException("已经有相同的物品");
                }
            }
        }


        String itemType=System.currentTimeMillis() + "" + (int) (Math.random() * (10000 - 10) + 10);

        //添加大类 必须和总部保持一致
        if(!Constants.TIANXIN_CODE.equals(cityId)&&parentId==null) {
            SysEnvironmentalInfo byCityAndTitle = findByCityAndTitle(title, Constants.TIANXIN_CODE);
            itemType=byCityAndTitle.getItemType();
        }

        item.setItemType(itemType);
        item.setCreateTime(DateUtil.now());
        // 对排序字段进行处理
        setSort(item);

        int i = 0;
        for (String townId : townIdList) {
            item.setCityId(townId);
            i = sysEnvironmentalInfoMapper.insertItemOperate(item);
        }
        setSortAggin(item);
        map.put("count", i);
        map.put("code", 0);
        return map;
    }



    /**
     * 删除后台分类
     * @param item
     * @return
     */
    public Map<String, Object> delOperateItem(ItemModel item) {
        Map<String, Object> map = new HashMap<>();
        ItemModel im = new ItemModel();
        im.setLimit(10);
        im.setParentId(item.getId());
        List<ItemModel> list = sysEnvironmentalInfoMapper.querIteml(im);
        if (list.size() > 0) {
            map.put("code", -1);
            map.put("num", 0);
            return map;
        }
        int i = sysEnvironmentalInfoMapper.delItem(item);
        map.put("code", 0);
        map.put("num", i);
        return map;
    }

    public Map<String,Object> queryTypeData(StorageModel storageModel){
        List<String> partnerIds = new ArrayList<>();
        if(StrUtil.isNotBlank(storageModel.getPartnerId())){
            partnerIds.add(storageModel.getPartnerId());
        }else{
            partnerIds = cityPartnerService.queryPartnerByCurrent();
        }

        Map<String,String> lastMap = new HashMap<>();
        Map<String,Object> detailImage = new HashMap<>();
        if(null!=storageModel.getImageType()&&!"".equals(storageModel.getImageType())) {
            if (storageModel.getImageType().equals("day")) {
                lastMap.put("startTime", cn.hutool.core.date.DateUtil.today() +" 00:00:00");
                lastMap.put("endTime",cn.hutool.core.date.DateUtil.today()+" 23:59:59");
            } else {
                List<Map<String,String>> weekOrMonthImgList  = com.xzx.gc.util.DateUtil.query12MonthStartTimeAndEndTime();
                lastMap = weekOrMonthImgList.get(0);
            }
        }
        detailImage = queryPageSysStorageTypeName(lastMap.get("startTime"),lastMap.get("endTime"),storageModel.getTypeName(),storageModel.getPage(),storageModel.getLimit(),partnerIds,storageModel.getParentId(),storageModel.getDelFlag());

        return detailImage;
    }

    private Map<String,Object> queryPageSysStorageTypeName(String startTime,String endTime,String typeName,int page,int limit,List<String> partnerIds,String parentId,String delFlag){
        String partnerId="";
        if(null!=partnerIds&&partnerIds.size()>0){
            partnerId = partnerIds.get(0);
        }
        PageHelper.startPage(page,limit);

        List<SysEnvironmentalInfo> list = sysEnvironmentalInfoMapper.findPage(partnerId,typeName,parentId,delFlag);


        for (SysEnvironmentalInfo sysEnvironmentalInfo : list) {
            ItemDto orderItem = orderItemInfoMapper.findByTypeAndPartnerAndTime(sysEnvironmentalInfo.getPartnerId(), sysEnvironmentalInfo.getItemType(), startTime, endTime);
            orderItem=orderItem==null?new ItemDto():orderItem;
            sysEnvironmentalInfo.setOldMoney(orderItem.getMoney());
            ItemDto storageItem = orderStorageDetailMapper.findByTypeAndPartnerAndTime(sysEnvironmentalInfo.getPartnerId(), sysEnvironmentalInfo.getItemType(), startTime, endTime);
            storageItem=storageItem==null?new ItemDto():storageItem;
            BigDecimal moneyError = NumberUtil.sub(Convert.toBigDecimal(storageItem.getMoney()), Convert.toBigDecimal(orderItem.getMoney()));
            BigDecimal weightError = NumberUtil.sub(Convert.toBigDecimal(storageItem.getWeight()), Convert.toBigDecimal(orderItem.getWeight()));
            BigDecimal money = Convert.toBigDecimal(orderItem.getMoney()).divide(new BigDecimal("10000"),2);
            BigDecimal moneyErrorBig = new BigDecimal(moneyError.toString()).divide(new BigDecimal("10000"),2);
            BigDecimal weight = Convert.toBigDecimal(orderItem.getWeight()).divide(new BigDecimal("1000"),3);
            BigDecimal weightErrorBig = new BigDecimal(weightError.toString()).divide(new BigDecimal("1000"),3);
            sysEnvironmentalInfo.setMoney(DoubleUtil.roundTwo(money+""));
            sysEnvironmentalInfo.setMoneyError(DoubleUtil.roundTwo(moneyErrorBig+""));
            sysEnvironmentalInfo.setWeight(DoubleUtil.roundThree(weight+""));
            sysEnvironmentalInfo.setWeightError(DoubleUtil.roundThree(weightErrorBig+""));
        }
        PageInfo<SysEnvironmentalInfo> pageInfo = new PageInfo<>(list);
        int count = Convert.toInt(pageInfo.getTotal());

        //总金额
        BigDecimal totalMoney = new BigDecimal("0");

        for (SysEnvironmentalInfo sysEnvironmentalInfo:list) {
            totalMoney = totalMoney.add(Convert.toBigDecimal(sysEnvironmentalInfo.getOldMoney()));
        }

        for (SysEnvironmentalInfo sysEnvironmentalInfo:list) {
            BigDecimal rate;
            if(totalMoney.compareTo(BigDecimal.ZERO)==0){
                rate=BigDecimal.ZERO;
            }else {
                rate = Convert.toBigDecimal(sysEnvironmentalInfo.getOldMoney(), Constants.MONEY_INIT).divide(totalMoney, 2, RoundingMode.HALF_UP);
            }
            sysEnvironmentalInfo.setRate(rate.multiply(new BigDecimal("100")).toString()+"%");
        }

        Map<String,Object> imageData = new HashMap<>();
        imageData.put("totalMoney",DoubleUtil.roundTwo(totalMoney.toString()));
        imageData.put("data",list);
        imageData.put("count",count);
        return imageData;
    }

    public List<SysEnvironmentalInfo> queryParent(QueryParentDTO queryParentDTO) {
        Example example=new Example(SysEnvironmentalInfo.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("cityId",queryParentDTO.getCityId());
        criteria.andIsNull("parentId");
        return sysEnvironmentalInfoMapper.selectByExample(example);
    }


}