package com.stylefeng.guns.modular.system.service.impl;

import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.date.DateUtil;
import com.amazonaws.services.dynamodbv2.xspec.M;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.stylefeng.guns.core.util.ToolUtil;
import com.stylefeng.guns.modular.system.dao.*;
import com.stylefeng.guns.modular.system.model.*;
import com.stylefeng.guns.modular.system.model.vo.OrderDetailVo;
import com.stylefeng.guns.modular.system.model.vo.OrderInfoVo;
import com.stylefeng.guns.modular.system.service.*;
import com.stylefeng.guns.modular.system.utils.GoogleMap.FindPlaceFromTextVo;
import com.stylefeng.guns.modular.system.utils.GoogleMap.GeocodeVo;
import com.stylefeng.guns.modular.system.utils.GoogleMap.GoogleMapUtil;
import com.stylefeng.guns.modular.system.utils.UserInfoUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.stream.Collectors;

/**
 * <p>
 *  服务实现类
 * </p>
 *
 * @author stylefeng
 * @since 2023-02-03
 */
@Service
public class TOrderServiceImpl extends ServiceImpl<TOrderMapper, TOrder> implements ITOrderService {

    @Resource
    private TUserMapper tUserMapper;

    @Resource
    private UserMapper userMapper;

    @Resource
    private TGoodsMapper tGoodsMapper;

    @Resource
    private TCompanyMapper tCompanyMapper;

    @Resource
    private TPriceMapper priceMapper;


    @Resource
    private TGroupMapper tGroupMapper;

    @Resource
    private TQuoteMapper tQuoteMapper;

    @Autowired
    private ITBoxSizeService sizeService;

    @Autowired
    private GoogleMapUtil googleMapUtil;

    @Resource
    private TPortMapper portMapper;

    @Resource
    private WareHouseMapper wareHouseMapper;

    @Resource
    private DriverNoteMapper driverNoteMapper;

    @Autowired
    private ITDriverService driverService;


    @Resource
    private TCarriersMapper carriersMapper;

    @Override
    public List<ReceivableVo> getReceivable(Page<ReceivableVo> receivableVoPage, String time, String name) {
        //TODO 时间保留
        List<ReceivableVo> list = this.baseMapper.getReceivable(receivableVoPage,name);

        Calendar instance = Calendar.getInstance();
        instance.setTime(new Date());
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
        String format = simpleDateFormat.format(new Date())+" 23:59:59";
        // 30天
        instance.add(Calendar.DATE,-30);
        String time1 = simpleDateFormat.format(instance.getTime())+" 00:00:01";
        // 60tian
        instance.add(Calendar.DATE,-30);
        String time2 = simpleDateFormat.format(instance.getTime())+" 00:00:01";
        // 90tian
        instance.add(Calendar.DATE,-30);
        String time3 = simpleDateFormat.format(instance.getTime())+" 00:00:01";

        for (ReceivableVo receivableVo : list) {
            // 根据id获取30天内的金额
            receivableVo.setTwentyDay(this.baseMapper.getTwentyDay(receivableVo.getUserId(),format,time1)==null?0:this.baseMapper.getTwentyDay(receivableVo.getUserId(),format,time1));

            // 30-60tian
            receivableVo.setThirtyDay(this.baseMapper.getTwentyDay(receivableVo.getUserId(),time1,time2)==null?0:this.baseMapper.getTwentyDay(receivableVo.getUserId(),time1,time2));
            receivableVo.setSixtyDay(this.baseMapper.getTwentyDay(receivableVo.getUserId(),time2,time3)==null?0:this.baseMapper.getTwentyDay(receivableVo.getUserId(),time2,time3));
            receivableVo.setNinetyDay(this.baseMapper.getNineDay(receivableVo.getUserId(),time3)==null?0:this.baseMapper.getNineDay(receivableVo.getUserId(),time3));

        }
        return list;
    }

    @Override
    public List<ShouldPayVo> getPayList(Page<ShouldPayVo> receivableVoPage, String time, String name) {
        List<ShouldPayVo> list = this.baseMapper.getPayList(receivableVoPage,name);

        Calendar instance = Calendar.getInstance();
        instance.setTime(new Date());
        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
        String format = simpleDateFormat.format(new Date())+" 23:59:59";
        // 30天
        instance.add(Calendar.DATE,-30);
        String time1 = simpleDateFormat.format(instance.getTime())+" 00:00:01";
        // 60tian
        instance.add(Calendar.DATE,-30);
        String time2 = simpleDateFormat.format(instance.getTime())+" 00:00:01";
        // 90tian
        instance.add(Calendar.DATE,-30);
        String time3 = simpleDateFormat.format(instance.getTime())+" 00:00:01";


        for (ShouldPayVo shouldPayVo : list) {
            shouldPayVo.setTwentyDay(this.baseMapper.getTwentyDayPay(shouldPayVo.getUserId(),format,time1)==null?0:this.baseMapper.getTwentyDayPay(shouldPayVo.getUserId(),format,time1));

            // 30-60tian
            shouldPayVo.setThirtyDay(this.baseMapper.getTwentyDayPay(shouldPayVo.getUserId(),time1,time2)==null?0:this.baseMapper.getTwentyDayPay(shouldPayVo.getUserId(),time1,time2));

            shouldPayVo.setSixtyDay(this.baseMapper.getTwentyDayPay(shouldPayVo.getUserId(),time2,time3)==null?0:this.baseMapper.getTwentyDayPay(shouldPayVo.getUserId(),time2,time3));

            shouldPayVo.setNinetyDay(this.baseMapper.getNineDayPay(shouldPayVo.getUserId(),time3)==null?0:this.baseMapper.getNineDayPay(shouldPayVo.getUserId(),time3));

        }
        return list;
    }

    @Override
    public List<ReceivablesList> listOfReceivables(Page<ReceivablesList> receivableVoPage, String time, String name, Integer invoicesId, Integer orderId, Integer state) {
        String sTime=null;
        String eTime =null;
        if(Objects.nonNull(time)){
            sTime = time.split(" - ")[0]+" 00:00:01";
            eTime = time.split(" - ")[1]+" 23:59:59";
        }
        List<ReceivablesList> receivablesLists = this.baseMapper.listOfReceivables(receivableVoPage, sTime, eTime, name, invoicesId, orderId, state);
        for (ReceivablesList receivablesList : receivablesLists) {
           Integer id= this.baseMapper.getPayStatus(receivablesList.getOrderId());
            if(id==null){
               receivablesList.setPayStatus(1);
           }else {
               receivablesList.setPayStatus(2);
           }
        }
        return receivablesLists;
    }

    @Override
    public List<PayList> listOfPay(Page<PayList> receivableVoPage, String time, String name, Integer billId, Integer orderId, Integer state) {
        String sTime=null;
        String eTime =null;
        if(Objects.nonNull(time)){
            sTime = time.split(" - ")[0]+" 00:00:01";
            eTime = time.split(" - ")[1]+" 23:59:59";
        }
        List<PayList> list = this.baseMapper.listOfPay(receivableVoPage, sTime, eTime, name, billId, orderId, state);
        return list;
    }

    @Override
    public InvoicesCarVo listOPayInfo(Long number) {
        InvoicesVo info1 = tUserMapper.getOrderInfo(number);
        InvoicesCarVo info = new InvoicesCarVo();
        BeanUtil.copyProperties(info1,info);

        // 根据订单id 获取货物信息
        Long id = info.getId();
        TOrder tOrder = this.baseMapper.selectById(id);

        List<TGoods> orders = tGoodsMapper.selectList(new EntityWrapper<TGoods>().eq("order_id", id));
        ArrayList<TGoodsVo> tGoodsVos = new ArrayList<>();
        TCompany tCompany = tCompanyMapper.selectById(info.getCompanyId());
        List<TBoxSize> tBoxSizes = sizeService.selectList(null);

        for (TGoods order : orders) {
            TGoodsVo tGoodsVo = new TGoodsVo();
            tGoodsVo.setName(tCompany.getName());
            tGoodsVo.setSize(order.getSize());
            tGoodsVo.setKg(order.getKg());
            String size = order.getSize();
            for (TBoxSize tBoxSize : tBoxSizes) {
                if(size.equals(tBoxSize.getBoxName())){
                    tGoodsVo.setLength(tBoxSize.getBoxLength());
                    tGoodsVo.setWidth(tBoxSize.getBoxWidth());
                    tGoodsVo.setHeight(tBoxSize.getBoxHigh());
                }
            }
            tGoodsVos.add(tGoodsVo);
        }
        // 付卡车公司钱
        BigDecimal payMoney = tOrder.getPayMoney();
        Integer carriersId = tOrder.getCarriersId();
        TCarriers tCarriers = carriersMapper.selectById(carriersId);
        Double commission = tCarriers.getCommission();
        BigDecimal multiply = new BigDecimal(commission).multiply(new BigDecimal(0.01));
        BigDecimal multiply1 = payMoney.multiply(multiply);
        info.setGoodsVos(tGoodsVos);
        info.setAmount(multiply1.doubleValue());
        return info;
    }

    @Override
    public Boolean confirmationOfPayment(Long number, int type, String remark) {
        Boolean b =false;
        // 同意
        if(type==1){
             b = this.baseMapper.agreePay(number);
        }else {
             b = this.baseMapper.noAgreePay(number,remark);
        }

        return b;
    }

    @Override
    public Boolean agreeOfPayment(Long number) {
        return this.baseMapper.agreeOfPayment(number);
    }

    @Resource
    private TDriverMapper driverMapper;

    @Resource
    private TPowerUnitsMapper powerUnitsMapper;

    @Override
    public IndexInfo indexList(String time) {
        IndexInfo indexInfo = new IndexInfo();
        // 卡车公司收入时间
        String sTime=null;
        String eTime=null;
        if(ToolUtil.isNotEmpty(time)){
            sTime=time.split(" - ")[0]+" 00:00:01";
            eTime=time.split(" - ")[1]+" 23:59:59";
        }
        Integer companyId = UserInfoUtil.getId();
        // 获取卡车公司收入
        Double companyIncome = this.baseMapper.getCompanyIncome(companyId, sTime, eTime);

        indexInfo.setAccountsReceivable(new BigDecimal(companyIncome));
        // 获取卡车公司支出-》 是否存在承运商  -》算价格
        EntityWrapper<TOrder> wrapper = new EntityWrapper<>();
        wrapper.eq("company_id",companyId);
        wrapper.eq("carriers_pay_status",1);
        if(sTime!=null){
            wrapper.between("success_time",sTime,eTime);
        }
        List<TOrder> orders = this.baseMapper.selectList(wrapper);
        // 找出有承运商的订单
        List<TOrder> collect = orders.stream().filter(o -> ToolUtil.isNotEmpty(o.getCarriersId())).collect(Collectors.toList());
        // 付给承运商的钱
        BigDecimal disburse = new BigDecimal(BigInteger.ZERO);
        for (TOrder tOrder : collect) {
            TCarriers tCarriers = carriersMapper.selectById(tOrder.getCarriersId());
            Double commission = tCarriers.getCommission();
            BigDecimal payMoney = tOrder.getPayMoney();
            if(ToolUtil.isNotEmpty(commission)){
                BigDecimal bigDecimal = new BigDecimal(commission);
                BigDecimal multiply = payMoney.multiply(bigDecimal).setScale(2, BigDecimal.ROUND_HALF_UP);
                disburse = disburse.add(multiply);
            }
        }
        indexInfo.setAccountsPayable(disburse);
        indexInfo.setPlatformRevenue(indexInfo.getAccountsReceivable().subtract(indexInfo.getAccountsPayable()));
        // 所有的信息
        // 所有司机
        Integer integer = driverMapper.selectCount(new EntityWrapper<TDriver>().eq("company_id", companyId).eq("remove",0));
        indexInfo.setDriver(integer);
        //车头
        Integer integer1 = powerUnitsMapper.selectCount(new EntityWrapper<TPowerUnits>().eq("company_id", companyId).eq("type", 1));
        indexInfo.setPowerUnits(integer1);
        // 车架
        indexInfo.setChassises(powerUnitsMapper.selectCount(new EntityWrapper<TPowerUnits>().eq("company_id", companyId).eq("type", 2)));
        // 总订单
        indexInfo.setOrdersTotal(this.baseMapper.selectCount(new EntityWrapper<TOrder>().eq("company_id",companyId)));
        //
        indexInfo.setInTransit(this.baseMapper.selectCount(new EntityWrapper<TOrder>().eq("company_id",companyId).eq("status","7")));
        indexInfo.setDispatching(this.baseMapper.selectCount(new EntityWrapper<TOrder>().eq("company_id",companyId).eq("status","0")));
        indexInfo.setCanceled(this.baseMapper.selectCount(new EntityWrapper<TOrder>().eq("company_id",companyId).eq("status","16")));
        indexInfo.setCompleted(this.baseMapper.selectCount(new EntityWrapper<TOrder>().eq("company_id",companyId).eq("status","1")));
        //获取当前公司的订单数量  根据当前月推算前12个月
        ArrayList<IndexMonth> indexMonths = new ArrayList<>();
        //获取当前月份

        Calendar instance = Calendar.getInstance();
        instance.setTime(new Date());
        for (int i = 0; i <12; i++) {
            if(i==0){
                IndexMonth indexMonth = new IndexMonth();
                int month = DateUtil.thisMonth();
                indexMonth.setMonth(month);
                indexMonth.setOrderNumber(this.baseMapper.selectCount(new EntityWrapper<TOrder>().eq("company_id",companyId).between("pay_time",DateUtil.beginOfMonth(new Date()),DateUtil.endOfMonth(new Date()))));
                indexMonths.add(indexMonth);
            }else {
                IndexMonth indexMonth = new IndexMonth();
                instance.add(Calendar.MONTH, -1);
                Date time1 = instance.getTime();
                int month = DateUtil.month(time1);
                indexMonth.setMonth(month);
                indexMonth.setOrderNumber(this.baseMapper.selectCount(new EntityWrapper<TOrder>().eq("company_id",companyId).between("pay_time",DateUtil.beginOfMonth(time1),DateUtil.endOfMonth(time1))));
                indexMonths.add(indexMonth);
            }
        }
        indexInfo.setList(indexMonths);
        return indexInfo;
    }




    @Override
    public InvoicesVoTwo listOfReceivablesInfo(Long orderId) {
        InvoicesVoTwo invoicesVoTwo = new InvoicesVoTwo();
        TOrder tOrder = this.baseMapper.selectById(orderId);
        invoicesVoTwo.setId(tOrder.getId());
        invoicesVoTwo.setPickupDate(tOrder.getShipmentDate());
        invoicesVoTwo.setDeliveryDate(tOrder.getDeliveryDate());
        invoicesVoTwo.setInvoiceNumber(tOrder.getInvoiceNumber());
        invoicesVoTwo.setRemark(tOrder.getRemark());
        // 根据订单id 获取价格
        List<TPrice> prices = priceMapper.selectList(new EntityWrapper<TPrice>().eq("order_id", tOrder.getId()));
        ArrayList<TPriceVo> priceVos = new ArrayList<TPriceVo>();
        for (TPrice price : prices) {
            TPriceVo tPriceVo = new TPriceVo();
            tPriceVo.setId(price.getId());
            tPriceVo.setPrice(price.getCarPrice());
            tPriceVo.setType(price.getType());
            priceVos.add(tPriceVo);
        }
        invoicesVoTwo.setPriceVos(priceVos);

        return invoicesVoTwo;
    }
    @Override
    public InvoicesVoOne listOfReceivablesInfoOne(Long orderId) {
        InvoicesVoOne info = tUserMapper.getOrderInfoOne(orderId);
        // 根据订单id 获取货物信息
        Long id = info.getId();

        TOrder tOrder = this.baseMapper.selectById(id);
        List<TGoods> orders = tGoodsMapper.selectList(new EntityWrapper<TGoods>().eq("order_id", id));
        ArrayList<TGoodsVo> tGoodsVos = new ArrayList<>();
        TCompany tCompany = tCompanyMapper.selectById(info.getCompanyId());
        List<TBoxSize> tBoxSizes = sizeService.selectList(null);
        for (TGoods order : orders) {
            TGoodsVo tGoodsVo = new TGoodsVo();
            tGoodsVo.setName(tCompany.getName());
            tGoodsVo.setSize(order.getSize());
            tGoodsVo.setKg(order.getKg());
            String size = order.getSize();
            for (TBoxSize tBoxSize : tBoxSizes) {
                if(size.equals(tBoxSize.getBoxName())){
                    tGoodsVo.setLength(tBoxSize.getBoxLength());
                    tGoodsVo.setWidth(tBoxSize.getBoxWidth());
                    tGoodsVo.setHeight(tBoxSize.getBoxHigh());
                }
            }
            tGoodsVos.add(tGoodsVo);
        }

        // 根据订单id 获取价格
        List<TPrice> prices = priceMapper.selectList(new EntityWrapper<TPrice>().eq("order_id", tOrder.getId()));

        ArrayList<TPriceVo> priceVos = new ArrayList<TPriceVo>();
        for (TPrice price : prices) {
            TPriceVo tPriceVo = new TPriceVo();
            tPriceVo.setId(price.getId());
            tPriceVo.setPrice(price.getCarPrice());
            tPriceVo.setType(price.getType());
            priceVos.add(tPriceVo);
        }
        info.setGoodsVos(tGoodsVos);
        info.setPriceVos(priceVos);



        return info;
    }




    @Override
    public List<OrderListVo> getOrderList(Page<OrderListVo> orderListVoPage, OrderListDto dto) {
        String sTime =null;
        String eTime = null;
        if(ToolUtil.isNotEmpty(dto.getDateRange())){
            String[] split = dto.getDateRange().split(" - ");
            sTime=split[0]+" 00:00:01";
            eTime=split[1]+" 23:59:59";
        }
        Integer id = UserInfoUtil.getId();
        List<OrderListVo> list = this.baseMapper.getOrderListOne(orderListVoPage,sTime,eTime,dto.getCustomerName(),dto.getId(),dto.getGroupId(),dto.getSaleId(),dto.getState(),id,dto.getType());
            for (OrderListVo orderListVo : list) {
            // TODO 对接第三方 看是否能提柜
            if(Objects.nonNull(dto.getState())){
                if(dto.getState()==1){

                }else {

                }
            }
        }
        return list;
    }

    @Override
    public List<GoodsInfoVo> getGoodsInfo(Long orderId) {
        TOrder tOrder = this.baseMapper.selectById(orderId);
        ArrayList<GoodsInfoVo> goodsInfoVos = new ArrayList<>();
        List<TGoods> goods = tGoodsMapper.selectList(new EntityWrapper<TGoods>().eq("order_id", orderId));
        for (TGoods g : goods) {
            GoodsInfoVo goodsInfoVo = new GoodsInfoVo();
            goodsInfoVo.setAwbNo(g.getBillNumber());
            goodsInfoVo.setContainer(g.getContainerNumber());
            goodsInfoVo.setHazmat(g.getDanger());
            goodsInfoVo.setOverWeight(g.getWeight());
            goodsInfoVo.setShippingLine(g.getShippingLine());
            goodsInfoVo.setSize(g.getSize());
            goodsInfoVo.setType(g.getType());
            goodsInfoVo.setTypeClass(g.getTypeClass());
            goodsInfoVo.setWeight(g.getKg());
            goodsInfoVos.add(goodsInfoVo);
        }
        return goodsInfoVos;
    }

    @Override
    public OrderInfo getOrderInfo(Long orderId) {
        OrderInfo orderInfo = new OrderInfo();
        ArrayList<LonLat> lonLats = new ArrayList<>();

        TOrder tOrder = this.baseMapper.selectById(orderId);
        orderInfo.setSlat(tOrder.getStartLat());
        orderInfo.setSlon(tOrder.getStartLon());
        LonLat lonLat = new LonLat();
        lonLat.setLat(tOrder.getStartLat());
        lonLat.setLng(tOrder.getStartLon());
        lonLats.add(lonLat);
        String s = tOrder.geteAddress();
        GeocodeVo geocode = googleMapUtil.getGeocode(s);
        orderInfo.setElat(String.valueOf(geocode.getLat()));
        orderInfo.setElon(String.valueOf(geocode.getLng()));
//        lonLat=new LonLat();
//        lonLat.setLng("-113.066919618184");
//        lonLat.setLat("37.684389618184");
        lonLats.add(lonLat);
//        orderInfo.setElat("37.684389618184");
//        orderInfo.setElon("-113.066919618184");
//
        orderInfo.setLonLats(lonLats);
        Long quoteId = tQuoteMapper.selectList(new EntityWrapper<TQuote>().eq("order_id", tOrder.geteZipZ())).get(0).getId();
        orderInfo.setType(tOrder.getType());
        orderInfo.setQuoteId(quoteId);
        // 获取用户
        Integer userId = tOrder.getUserId();
        TUser tUser = tUserMapper.selectById(userId);
        orderInfo.setCustomer(tUser.getCompanyName());
        // 获取组
        Integer groupId = tUser.getGroupId();
        if(groupId!=null) {
            TGroup tGroup = tGroupMapper.selectById(groupId);
            orderInfo.setSalesGroup(tGroup.getName());
            Integer salesId = tGroup.getSalesId();
            User user = userMapper.selectById(salesId);
            orderInfo.setSales(user.getName());
        }
        // 获取码头id  获取码头地址  pickup信息
        Integer portId = tOrder.getPort();
        TPort tPort = portMapper.selectById(portId);
        orderInfo.setAddress(tOrder.geteAddress());
        orderInfo.setContactName(tOrder.getsName());
        orderInfo.setContactPhone(tOrder.getsPhone());
        orderInfo.setContactEmail(tOrder.getsEmail());
        orderInfo.setShipmentDate(tOrder.getShipmentDate());
        orderInfo.setResidentitalPickUp(tOrder.getAccessorialStr());

        String warehouse = tOrder.getWarehouse();
        // 是仓库
        if(!"0".equals(warehouse)){
            TWarehouse tWarehouse = wareHouseMapper.selectList(new EntityWrapper<TWarehouse>().eq("company_id", tOrder.getCompanyId()).eq("code", warehouse)).get(0);
            orderInfo.setWareHouse(tWarehouse.getAddress());
        }
        // destination信息
        orderInfo.setEndAddress(tOrder.geteAddress());
        orderInfo.setECompanyName(tOrder.geteCompanyName());
        orderInfo.setEContactName(tOrder.geteName());
        orderInfo.setEContactPhone(tOrder.getePhone());
        orderInfo.setEContactEmail(tOrder.geteEmail());
        orderInfo.setDeliveryDate(tOrder.getDeliveryDate());
        orderInfo.setDeliverStr(tOrder.getDeliveryStr());
        orderInfo.setCarrierQuoteNumber(quoteId);

        // 根据订单id获取货物
        List<TGoods> goods = tGoodsMapper.selectList(new EntityWrapper<TGoods>().eq("order_id", orderId));
        ArrayList<String> strings = new ArrayList<>();
        goods.forEach(e->{
            strings.add(e.getContainerNumber());
            orderInfo.setBl(e.getBillNumber());
        });
        orderInfo.setContainer(strings);
        ArrayList<DriverNoteVo> driverNoteVos = new ArrayList<>();
        ArrayList<DriverNoteVo> driverNoteVos1 = new ArrayList<>();

        // 获取司机note  和 trouble
        List<DriverNote> driverNotes = driverNoteMapper.selectList(new EntityWrapper<DriverNote>().eq("order_id", orderId));
        for (DriverNote driverNote : driverNotes) {
            DriverNoteVo driverNoteVo = new DriverNoteVo();
            BeanUtil.copyProperties(driverNote,driverNoteVo);
            TDriver tDriver = driverService.selectById(driverNoteVo.getDriverId());
            driverNoteVo.setDriverName(tDriver.getDriverName());
            if(driverNoteVo.getType()==1){
                driverNoteVos.add(driverNoteVo);
            }else {
                driverNoteVos1.add(driverNoteVo);
            }
        }
        orderInfo.setNote(driverNoteVos);
        orderInfo.setTrouble(driverNoteVos1);
        orderInfo.setState(tOrder.getState());
        return orderInfo;


    }

    @Override
    public Boolean addOrderFile(Long orderId, String url, String name) {
        return this.baseMapper.addOrderFile(orderId,url,name);
    }

    @Override
    public List<OrderInfoVo> getOrderListIndex(Page<OrderInfoVo> orderInfoVoPage, int id, String containerNo, String sTime, String eTime,int type) {
        List<OrderInfoVo> orderListIndex = this.baseMapper.getOrderListIndex(orderInfoVoPage, id, containerNo, sTime, eTime,type);
        for (OrderInfoVo listIndex : orderListIndex) {
            if(listIndex.getStatus()==6&&listIndex.getSendType().equals("Live Unload")){
                TTransportation tTransportation = tTransportationService.selectOne(new EntityWrapper<TTransportation>().eq("order_id", listIndex.getOrderId()).eq("type", 4));
                if(tTransportation!=null){
                    Integer portId = tTransportation.getPortId();
                    TPort tPort = portMapper.selectById(portId);
                    listIndex.setPortName(tPort.getName());
                    listIndex.setReturnTime(tTransportation.getReturnDate());
                }

            }
        }
        return orderListIndex;
    }


    @Resource
    private TTransportationService tTransportationService;

    @Resource
    private ITExamSiteService examSiteService;

    @Resource
    private TYardService yardService;
    @Override
    public Map<String, Object>  orderInfo(Long id, int did) {
        OrderDetailVo orderDetailVo = new OrderDetailVo();
        List<Map<String, Object>> maps = new ArrayList<>();
        Integer driverId =0;
        // 获取经纬度
        TOrder tOrder = this.baseMapper.selectById(id);
        if(tOrder.getExamSite()!=null && tOrder.getType().equals("Live Unload")){
            if(tOrder.getStatus().equals("0")){
                orderDetailVo.setNextStatus("2");
            }else
            if(tOrder.getStatus().equals("2")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("3");
            }else
            if(tOrder.getStatus().equals("3")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("4");
            }else
            if(tOrder.getStatus().equals("4")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("12");
            }else
            if(tOrder.getStatus().equals("12")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("13");
            }else
            if(tOrder.getStatus().equals("13")){
                orderDetailVo.setNextStatus("14");
            }else
            if(tOrder.getStatus().equals("14")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("5");
            }else
            if(tOrder.getStatus().equals("5")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("6");
            }else
            if(tOrder.getStatus().equals("6")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("7");
            }else
            if(tOrder.getStatus().equals("7")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("8");
            }else
            if(tOrder.getStatus().equals("8")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("9");
            }else
            if(tOrder.getStatus().equals("9")){
                driverId=tOrder.geteDriverid();
                orderDetailVo.setNextStatus("10");
            }else
            if(tOrder.getStatus().equals("10")){
                driverId=tOrder.geteDriverid();
                orderDetailVo.setNextStatus("11");
            }else
            if(tOrder.getStatus().equals("11")){
                driverId=tOrder.geteDriverIdOne();
                orderDetailVo.setNextStatus("18");
            }
        }else if(tOrder.getExamSite()==null && tOrder.getType().equals("Live Unload")){
            if(tOrder.getStatus().equals("0")){
                orderDetailVo.setNextStatus("2");
            }else
            if(tOrder.getStatus().equals("2")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("3");
            }else
            if(tOrder.getStatus().equals("3")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("4");
            }else
            if(tOrder.getStatus().equals("4")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("5");
            }else
            if(tOrder.getStatus().equals("5")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("6");
            }else
            if(tOrder.getStatus().equals("6")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("7");
            }else
            if(tOrder.getStatus().equals("7")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("8");
            }else
            if(tOrder.getStatus().equals("8")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("9");
            }else
            if(tOrder.getStatus().equals("9")){
                driverId=tOrder.geteDriverid();
                orderDetailVo.setNextStatus("10");
            }else
            if(tOrder.getStatus().equals("10")){
                driverId=tOrder.geteDriverid();
                orderDetailVo.setNextStatus("11");
            }else
            if(tOrder.getStatus().equals("11")){
                driverId=tOrder.geteDriverIdOne();
                orderDetailVo.setNextStatus("18");
            }
        }else if(tOrder.getExamSite()!=null && !tOrder.getType().equals("Live Unload")){
            if(tOrder.getStatus().equals("0")){
                orderDetailVo.setNextStatus("2");
            }else
            if(tOrder.getStatus().equals("2")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("3");
            }else
            if(tOrder.getStatus().equals("3")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("4");
            }else
            if(tOrder.getStatus().equals("4")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("12");
            }else
            if(tOrder.getStatus().equals("12")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("13");
            }else
            if(tOrder.getStatus().equals("13")){
                orderDetailVo.setNextStatus("14");
            }else
            if(tOrder.getStatus().equals("14")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("5");
            }else
            if(tOrder.getStatus().equals("5")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("6");
            }else
            if(tOrder.getStatus().equals("6")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("7");
            }else
            if(tOrder.getStatus().equals("7")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("8");
            }else
            if(tOrder.getStatus().equals("8")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("9");
            }
        }else {
            if(tOrder.getStatus().equals("0")){
                orderDetailVo.setNextStatus("2");
            }else
            if(tOrder.getStatus().equals("2")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("3");
            }else
            if(tOrder.getStatus().equals("3")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("4");
            }else
            if(tOrder.getStatus().equals("4")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("5");
            }else
            if(tOrder.getStatus().equals("5")){
                driverId=tOrder.getsDriverid();
                orderDetailVo.setNextStatus("6");
            }else
            if(tOrder.getStatus().equals("6")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("7");
            }else
            if(tOrder.getStatus().equals("7")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("8");
            }else
            if(tOrder.getStatus().equals("8")){
                driverId=tOrder.getsDriverIdOne();
                orderDetailVo.setNextStatus("9");
            }
        }
        String startLat = tOrder.getStartLat();
        String startLon = tOrder.getStartLon();
        orderDetailVo.setLat(startLat);
        orderDetailVo.setLon(startLon);
        String s = tOrder.geteAddress();
        try {
//            FindPlaceFromTextVo findplacefromtext = googleMapUtil.findplacefromtext(s);
//            Double lat = findplacefromtext.getLat();
//            Double lng = findplacefromtext.getLng();
//            orderDetailVo.setELat(lat.toString());
//            orderDetailVo.setELon(lng.toString());
            orderDetailVo.setELat("0");
            orderDetailVo.setELon("0");
        } catch (Exception e) {
            e.printStackTrace();
        }
        String type = tOrder.getType();
        TGoods tGoods = tGoodsMapper.selectList(new EntityWrapper<TGoods>().eq("order_id", id)).get(0);
        orderDetailVo.setOrderType(type);
        orderDetailVo.setContainerNumber(tGoods.getContainerNumber());
        TTransportation tTransportations = tTransportationService.selectOne(new EntityWrapper<TTransportation>().eq("order_id", id).eq("type",1));
          // 第一个port
        HashMap<String, Object> orderInfo = getOrderInfo(tTransportations, tOrder);

        ArrayList<Map<String,String>> strings = new ArrayList<>();
        TPort tPort1 = portMapper.selectById(tOrder.getPort());
        System.out.println(tPort1+"12312321");
        strings.add(getLat(tPort1.getAddress(),1));

        orderInfo.put("7_danger",tGoods.getDanger());
        orderInfo.put("8_weight",tGoods.getWeight());
        Map<String, Object> map = sortMapByKey(orderInfo);
        if(tOrder.getsDriverid()==did){
            maps.add(map);
        }
        if(tOrder.getExamSite()!=null){
            Integer examSite = tOrder.getExamSite();
            TExamSite tExamSite = examSiteService.selectById(examSite);
            // 第二个检查站
            Map<String, Object> examInfo = getExamInfo(tExamSite);
            if(tOrder.getsDriverid()==did){
                maps.add(examInfo);
            }
            strings.add(getLat(tExamSite.getAddress(),2));
        }
        TTransportation tTransportations1 = tTransportationService.selectOne(new EntityWrapper<TTransportation>().eq("order_id", id).eq("type",2));
        Map<String, Object> yardOne=null;
        if(ToolUtil.isNotEmpty(tTransportations1)) {
            Integer yardId = tTransportations1.getYardId();
            TYard tYard = yardService.selectById(yardId);
            if(tYard!=null){
                strings.add(getLat(tYard.getStreetAddress(), 3));
            }
            // 第三个  yard
            yardOne = getYardOne(tTransportations1, tYard);
        }
        // 第四个  destination
        Map<String, Object> destination = getDestination(tOrder);
        strings.add(getLat(tOrder.geteAddress(),4));
        if(tOrder.getsDriverIdOne()==did){
            if(yardOne!=null){
                maps.add(yardOne);
            }
            maps.add(destination);
        }
        TTransportation tTransportations2 = tTransportationService.selectOne(new EntityWrapper<TTransportation>().eq("order_id", id).eq("type",3));
        if(tTransportations2!=null){
            TYard tYard1 = yardService.selectById(tTransportations2.getYardId());
            // 第五个  yard
            Map<String, Object> yardOne1 = getYardOne(tTransportations2, tYard1);
            if(tOrder.geteDriverid()==did && tOrder.getType().equals("Live Unload")){
                maps.add(yardOne1);
            }
        }

        TTransportation tTransportations3 = tTransportationService.selectOne(new EntityWrapper<TTransportation>().eq("order_id", id).eq("type",4));
        if(tTransportations3!=null){
            TPort tPort = portMapper.selectById(tTransportations3.getPortId());
            if(ToolUtil.isNotEmpty(tPort)){
                // 第六个 port
                Map<String, Object> port = getPort(tTransportations3, tPort);
                if(tOrder.geteDriverIdOne()==did && tOrder.getType().equals("Live Unload")){
                    maps.add(port);
                }
            }
        }
        orderDetailVo.setTGoods(tGoods);
        orderDetailVo.setOrderId(id);
        orderDetailVo.setStatus(tOrder.getStatus());
        orderDetailVo.setList(maps);
        if(did==driverId){
            orderDetailVo.setButton(1);
        }
        HashMap<String, Object> map1 = new HashMap<>();
        map1.put("lonlat",strings);
        map1.put("data",orderDetailVo);
        return map1;
    }

    @Override
    public void saveLonLat(Long id, String lon, String lat) {
        this.baseMapper.saveLonLat(id,lon,lat);
    }

    @Override
    public List<Map<String, Object>> getLonLat(Long orderId) {
        return this.baseMapper.getLonLat(orderId);
    }

    private HashMap<String, String> getLat(String a,Integer type){
        HashMap<String, String> map = new HashMap<>();
        try {
            GeocodeVo geocode = googleMapUtil.getGeocode(a);
            map.put("lon",String.valueOf(geocode.getLng()));
            map.put("lat",String.valueOf(geocode.getLat()));
            map.put("type",type.toString());
        }catch (Exception e){
            e.printStackTrace();
            map.put("lon",null);
            map.put("lat",null);
        }

        return map;
    }

    private HashMap<String, Object> getOrderInfo(TTransportation tTransportation,TOrder tOrder){
        HashMap<String, Object> map = new HashMap<>();
        String name = tTransportation.getName();
        String phone = tTransportation.getPhone();
        String email = tTransportation.getEmail();
        Date shipmentDate = tOrder.getShipmentDate();
        Date pickupTimeTruck = tOrder.getPickupTimeTruck();
        map.put("1_title","Port");
        map.put("2_contactName",name);
        map.put("3_contactPhone",phone);
        map.put("4_contactEmail",email);
        map.put("5_shipmentEta",shipmentDate);
        map.put("6_pickupDate",pickupTimeTruck);
        return map;
    }

    private Map<String, Object> getPort(TTransportation tTransportation,TPort tPort){
        HashMap<String, Object> map = new HashMap<>();
        String address = tPort.getAddress();
        Integer city = tPort.getCity();
        TCountry cityInfo = countryService.selectById(city);
        TCountry state = countryService.selectById(cityInfo.getParentId());
        TCountry tCountry = countryService.selectById(state.getParentId());
        map.put("1_title","Port");
        map.put("2_address",address+cityInfo.getName()+state.getName()+tPort.getZipCode()+tCountry.getName());
        map.put("3_portName",tPort.getName());
        map.put("4_contactName",tTransportation.getName());
        map.put("5_contactPhone",tTransportation.getPhone());
        map.put("6_contactEmail",tTransportation.getEmail());
        map.put("7_returnTimeToPort",tTransportation.getReturnDate());
        Map<String, Object> map1 = sortMapByKey(map);
        return map1;
    }

    @Resource
    private ITCountryService countryService;

    private Map<String, Object> getExamInfo(TExamSite tExamSite){
        HashMap<String, Object> map = new HashMap<>();
        String address = tExamSite.getAddress();
        String cityName = countryService.selectById(tExamSite.getCity()).getName();
        String stateName = countryService.selectById(tExamSite.getState()).getName();
        String name = countryService.selectById(tExamSite.getCountry()).getName();
        map.put("1_title","Exam Site");
        map.put("2_address",address+cityName+stateName+tExamSite.getZipCode()+name);
        map.put("3_examSiteName",tExamSite.getStateName());
        map.put("4_contactName",tExamSite.getContactName());
        map.put("5_contactPhone",tExamSite.getContactPhone());
        map.put("6_contactEmail",tExamSite.getContactEmail());
        Map<String, Object> map1 = sortMapByKey(map);
        return map1;
    }


    private static Map<String, Object> sortMapByKey(Map<String, Object> map) {
        if (map == null || map.isEmpty()) {
            return null;
        }

        Map<String, Object> sortMap = new TreeMap<String, Object>(
                new MapKeyComparator());

        sortMap.putAll(map);

        return sortMap;
    }

    static class MapKeyComparator implements Comparator<String>{

        @Override
        public int compare(String str1, String str2) {

            return str1.compareTo(str2);
        }
    }

    private Map<String, Object> getYardOne(TTransportation tTransportations1,TYard yard){
        HashMap<String, Object> map = new HashMap<>();
//        String cityName = countryService.selectById(yard.getCity()).getName();
//        String stateName = countryService.selectById(yard.getState()).getName();
//        String name = countryService.selectById(yard.getCountry()).getName();
        map.put("1_title","Yard");
        if(yard!=null){
            map.put("2_address",yard.getStreetAddress()+yard.getCity()+yard.getState()+yard.getZipCode()+yard.getCountry());
            map.put("3_yardName",yard.getYardName());
        }else {
            map.put("2_address","");
            map.put("3_yardName","");
        }
        map.put("4_contactName",tTransportations1.getName());
        map.put("5_contactPhone",tTransportations1.getPhone());
        map.put("6_contactEmail",tTransportations1.getEmail());
        Map<String, Object> map1 = sortMapByKey(map);
        return map1;
    }

    private Map<String, Object> getDestination(TOrder tOrder){
        HashMap<String, Object> map = new HashMap<>();
        TPort tPort = portMapper.selectById(tOrder.getPort());
        String cityName = countryService.selectById(tPort.getCity()).getName();
        TCountry tCountry = countryService.selectById(countryService.selectById(tPort.getCity()).getParentId());
        String stateName = tCountry.getName();
        String name = countryService.selectById(tCountry.getParentId()).getName();
        map.put("1_title","Destination");
        map.put("2_address",tOrder.geteAddress()+cityName+stateName+tOrder.geteZipCode()+name);
        map.put("3_companyName",tOrder.geteCompanyName());
        map.put("4_contactName",tOrder.geteName());
        map.put("5_contactPhone",tOrder.getePhone());
        map.put("6_contactEmail",tOrder.geteEmail());
        // 1是亚马逊仓库
        if("0".equals(tOrder.getWarehouse())){
            map.put("8_isWarehouse",0);
        }else {
            map.put("8_isWarehouse",1);
        }
        map.put("9_delivery",tOrder.getDeliveryStr());
        map.put("7_deliveryDate",tOrder.getDeliveryDate());
        Map<String, Object> map1 = sortMapByKey(map);
        return map1;
    }



}