package cn.exrick.xboot.your.serviceimpl;

import cn.exrick.xboot.your.entity.OrderStatusCount;
import cn.exrick.xboot.your.entity.QueryRequest;
import cn.exrick.xboot.your.mapper.SignCountMapper;
import cn.exrick.xboot.your.entity.SignCount;
import cn.exrick.xboot.your.service.ISignCountService;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import jodd.util.StringUtil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

/**
 * 状态统计表接口实现
 * @author whj
 */
@Slf4j
@Service
@Transactional
public class ISignCountServiceImpl extends ServiceImpl<SignCountMapper, SignCount> implements ISignCountService {

    @Autowired
    private SignCountMapper signCountMapper;

    @Override
    public IPage<OrderStatusCount> signCounts(OrderStatusCount orderStatusCount,QueryRequest queryRequest) {
        Page<OrderStatusCount> page = new Page<>();
        if (org.apache.commons.lang3.StringUtils.isNotBlank(queryRequest.getPageSize() + "") && (queryRequest.getPageSize() != 0)) {
            page.setCurrent(queryRequest.getPageNum());
            page.setSize(queryRequest.getPageSize());
        } else {
            page.setCurrent(0);
            page.setSize(-1);
        }
        if(StringUtil.isNotBlank(orderStatusCount.getStatisticalType())){
            IPage<OrderStatusCount> orderStatusCountIPage = this.signCountMapper.signCount(orderStatusCount, page);
            List<OrderStatusCount> records = orderStatusCountIPage.getRecords();
            List<OrderStatusCount> recordsLast = new ArrayList<>();
            Map<String, List<OrderStatusCount>> collect = records.stream().collect(Collectors.groupingBy(OrderStatusCount::getCarName));
            for (Map.Entry<String, List<OrderStatusCount>> stringListEntry : collect.entrySet()) {
                List<OrderStatusCount> recordsNew = new ArrayList<>();
                for (OrderStatusCount statusCount : stringListEntry.getValue()) {
                    statusCount.setSendDate(statusCount.getSendMonth());
                    recordsNew.add(statusCount);
                }

                for (Map.Entry<String, List<OrderStatusCount>> listEntry : recordsNew.stream().collect(Collectors.groupingBy(OrderStatusCount::getBatch)).entrySet()) {
                    for (Map.Entry<String, List<OrderStatusCount>> listEntry1 : listEntry.getValue().stream().collect(Collectors.groupingBy(OrderStatusCount::getSendMonth)).entrySet()) {
                        if(listEntry1.getValue().size() > 0){
                            List<OrderStatusCount> value = listEntry1.getValue();
                            Integer amount = 0;
                            Integer notSignCount = 0;
                            Integer abnormalSign = 0;
                            Integer signCount= 0;
                            OrderStatusCount orderStatusCount1 = value.get(0);
                            for (OrderStatusCount statusCount : value) {
                                amount += Integer.parseInt(statusCount.getAmount());
                                notSignCount += Integer.parseInt(statusCount.getNotSignCount());
                                if(statusCount.getAbnormalSign() != null){
                                    abnormalSign += Integer.parseInt(statusCount.getAbnormalSign());
                                }else {
                                    abnormalSign = 0;
                                }
                                signCount += Integer.parseInt(statusCount.getSignCount());
                            }
                            DecimalFormat df = new DecimalFormat("0.00");
                            String maerialRatio = df.format((float)signCount/amount);
                            double v = Double.parseDouble(maerialRatio)*100;
                            orderStatusCount1.setProportion(v+"%");
                            orderStatusCount1.setAmount(amount+"");
                            orderStatusCount1.setNotSignCount(notSignCount+"");
                            orderStatusCount1.setAbnormalSign(abnormalSign+"");
                            orderStatusCount1.setSignCount(signCount+"");
                            value.clear();
                            value.add(orderStatusCount1);
                            listEntry1.setValue(value);
                            recordsLast.add(orderStatusCount1);
                        }
                    }

                }
                stringListEntry.setValue(recordsNew);
            }
            orderStatusCountIPage.setRecords(recordsLast);
            return orderStatusCountIPage;
        }
        return this.signCountMapper.signCount(orderStatusCount,page);
    }

    @Override
    public List<OrderStatusCount> signCounts2New(OrderStatusCount orderStatusCount) {
        List<OrderStatusCount> records = this.signCountMapper.signCount2New(orderStatusCount);
        List<OrderStatusCount> recordsAll = this.signCountMapper.signCountNewTotal(orderStatusCount);
        for (int i=0;i<records.size();i++) {
            for (OrderStatusCount statusCountx: recordsAll) {
                if(records.get(i).getCarName().equals(statusCountx.getCarName())){
                    if(statusCountx.getProportion().length()>6){
                        String  ss = statusCountx.getProportion().replace("%","");
                        BigDecimal bigDecimal = new BigDecimal(ss);
                        double sss = bigDecimal.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
                        records.get(i).setName(sss + "%");
                    }else{
                        records.get(i).setName(statusCountx.getProportion());
                    }
                    break;
                }
            }
            if(!StrUtil.isEmpty(records.get(i).getSignCount()) && !StrUtil.isEmpty(records.get(i).getAmount()) && !StrUtil.isEmpty(records.get(i).getNotSignCount())){
                int abnormalSign = Integer.parseInt(records.get(i).getAmount())-Integer.parseInt(records.get(i).getSignCount())-Integer.parseInt(records.get(i).getNotSignCount());
                if(abnormalSign<0){
                    abnormalSign = 0;
                }
                records.get(i).setAbnormalSign(abnormalSign + "");
            }
            if(records.get(i).getProportion().length()>6){
                String  ss = records.get(i).getProportion().replace("%","");
                BigDecimal bigDecimal = new BigDecimal(ss);
                double sss = bigDecimal.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
                records.get(i).setProportion(sss+ "%");
            }
            //"oneBatch":"01段","twoBatch":"0","threeBatch":"0","fourBatch":"0","fiveBatch":"0"
            if("0".equals(records.get(i).getOneBatch())){
                records.get(i).setOneBatch(null);
            }else{
                records.get(i).setBatch("01段");
            }
            if("0".equals(records.get(i).getTwoBatch())){
                records.get(i).setTwoBatch(null);
            }else{
                records.get(i).setBatch("02段");
            }
            if("0".equals(records.get(i).getThreeBatch())){
                records.get(i).setThreeBatch(null);
            }else{
                records.get(i).setBatch("03段");
            }
            if("0".equals(records.get(i).getFourBatch())){
                records.get(i).setFourBatch(null);
            }else{
                records.get(i).setBatch("04段");
            }
            if("0".equals(records.get(i).getFiveBatch())){
                records.get(i).setFiveBatch(null);
            }else{
                records.get(i).setBatch("05段");
            }
        }
        return records;
    }

    @Override
    public IPage<OrderStatusCount> signCountsNew(OrderStatusCount orderStatusCount, QueryRequest queryRequest) {
        Page<OrderStatusCount> page = new Page<>();
        if (org.apache.commons.lang3.StringUtils.isNotBlank(queryRequest.getPageSize() + "") && (queryRequest.getPageSize() != 0)) {
            page.setCurrent(queryRequest.getPageNum());
            page.setSize(queryRequest.getPageSize());
        } else {
            page.setCurrent(0);
            page.setSize(-1);
        }
        IPage<OrderStatusCount> orderStatusCountIPage = this.signCountMapper.signCountNew(orderStatusCount, page);
        List<OrderStatusCount> recordsAll = this.signCountMapper.signCountNewTotal(orderStatusCount);
        List<OrderStatusCount> records = orderStatusCountIPage.getRecords();

        for (int i=0;i<records.size();i++) {
            for (OrderStatusCount statusCountx: recordsAll) {
                if(records.get(i).getCarName().equals(statusCountx.getCarName())){
                    if(statusCountx.getProportion().length()>6){
                        String  ss = statusCountx.getProportion().replace("%","");
                        BigDecimal bigDecimal = new BigDecimal(ss);
                        double sss = bigDecimal.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
                        records.get(i).setSendMonth(sss + "%");
                    }else{
                        records.get(i).setSendMonth(statusCountx.getProportion());
                    }
                    break;
                }
            }
            if(records.get(i).getProportion().length()>6){
                String  ss = records.get(i).getProportion().replace("%","");
                BigDecimal bigDecimal = new BigDecimal(ss);
                double sss = bigDecimal.setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue();
                records.get(i).setProportion(sss+ "%");
            }
            //"oneBatch":"01段","twoBatch":"0","threeBatch":"0","fourBatch":"0","fiveBatch":"0"
            if("0".equals(records.get(i).getOneBatch())){
                records.get(i).setOneBatch(null);
            }
            if("0".equals(records.get(i).getTwoBatch())){
                records.get(i).setTwoBatch(null);
            }
            if("0".equals(records.get(i).getThreeBatch())){
                records.get(i).setThreeBatch(null);
            }
            if("0".equals(records.get(i).getFourBatch())){
                records.get(i).setFourBatch(null);
            }
            if("0".equals(records.get(i).getFiveBatch())){
                records.get(i).setFiveBatch(null);
            }
        }
       // List<OrderStatusCount> recordsLast = new ArrayList<>();
        orderStatusCountIPage.setRecords(records);
        return orderStatusCountIPage;
    }
}