package com.yuanchu.mom.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuanchu.mom.mapper.*;
import com.yuanchu.mom.pojo.*;
import com.yuanchu.mom.service.*;
import com.yuanchu.mom.utils.MyUtil;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.stream.Collectors;

/**
 * 订单(Order)表服务实现类
 *
 * @author zss
 * @since 2023-07-31 11:57:44
 */
@Service("orderService")
public class OrdersServiceImpl implements OrdersService {

    @Resource
    SaleMapper saleMapper;

    @Resource
    MaterialMapper materialMapper;

    @Resource
    StandardService standardService;

    @Resource
    SpecificationsService specificationsService;

    @Resource
    SaleMaterialMapper saleMaterialMapper;

    @Resource
    ManufactureOrderMapper manufactureOrderMapper;

    @Resource
    ManualTechnologyService manualTechnologyService;

    @Resource
    TechnologyMapper technologyMapper;

    @Resource
    ProductMapper productMapper;

    @Resource
    MbomMapper mbomMapper;

    @Resource
    ManualProductService manualProductService;

    @Resource
    ManualMbomService manualMbomService;


    //查询所有订单列表
    @Override
    public IPage<Map<String, Object>> selectAllOrder(Page<Object> page, String orderCode, String name, Integer type, String time) {
        return saleMapper.selectAllOrder(page, orderCode, name, type, time);
    }

    //编制订单BOM
    @Override
    @Transactional(rollbackFor = Exception.class)
    public void compile(Integer id) {
        /*更改订单BOM的状态为已编制1*/
        SaleMaterial saleMaterial = saleMaterialMapper.selectById(id);
        saleMaterial.setType(1);
        saleMaterialMapper.updateById(saleMaterial);
        /*新增生产订单+编制工序*/
        //查询订单信息
        Sale sale = saleMapper.selectById(saleMaterial.getSaleId());
        ManufactureOrder manufactureOrder = ManufactureOrder.builder()
                .orderCode(sale.getOrderNumber())
                .customerCode(sale.getCode())
                .proname(sale.getProname())
                .saleman(sale.getSaleman())
                .name(saleMaterial.getName())
                .specifications(saleMaterial.getSpecifications())
                .unit(saleMaterial.getUnit())
                .number(saleMaterial.getNumber())
                .downtime(sale.getCreateTime())
                .deltime(sale.getDelTime())
                .qualityTraceability(MyUtil.getTimeSixNumberCode("GPT", "GPT"))
                .downman(sale.getOrderName())
                .build();
        //新增生产订单
        manufactureOrderMapper.insert(manufactureOrder);
        //产品编码
        String code = materialMapper.selMcode(manufactureOrder.getName());
        //型号id
        Integer specificationId = getSpecificationId(manufactureOrder.getName(), code, manufactureOrder.getSpecifications());
        //默认最新版本
        Integer version = technologyMapper.selectVerByTec(specificationId).get(0);
        /*正序查询该型号最新版本下的工艺路线*/
        LambdaQueryWrapper<Technology> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(Technology::getSpecificationsId,specificationId);
        queryWrapper.eq(Technology::getVersion,version);
        queryWrapper.orderByAsc(Technology::getFather);
        List<Technology> technologyList = technologyMapper.selectList(queryWrapper);
        List<ManualTechnology> manualTechnologyList = technologyList.stream().map(technology -> {
            ManualTechnology manualTechnology = ManualTechnology.builder()
                    .techname(technology.getName()) //工艺
                    .techfather(technology.getFather()) //工序
                    .deviceGroup(technology.getDeviceGroup()) //生产设备组
                    .manufactureOrderId(manufactureOrder.getId()) //生产订单id
                    .productionQuota(technology.getProductionQuota()) //生产效率
                    .technologyId(technology.getId()) //标准bom中工艺路线id
                    .build();
            return manualTechnology;
        }).collect(Collectors.toList());
        /*新增编制工艺表*/
        manualTechnologyService.saveBatch(manualTechnologyList);
        //根据标准bom的工艺路线id查询标准bom中的技术指标
        for (ManualTechnology manualTechnology : manualTechnologyList) {
            List<Product> productList = productMapper.selProByVerSpe(manualTechnology.getTechnologyId());
            List<ManualProduct> manualProducts = new ArrayList<>();
            for (Product product : productList) {
                ManualProduct manualProduct = ManualProduct.builder()
                        .manualTechnologyId(manualTechnology.getId()) //关联 生产订单id
                        .name(product.getName())
                        .father(product.getFather())
                        .unit(product.getUnit())
                        .required(product.getRequired())
                        .internal(product.getInternal())
                        .build();
                manualProducts.add(manualProduct);
            }
            /*新增编制技术指标表*/
            manualProductService.saveBatch(manualProducts);
        }
        //根据标准bom的工艺路线id查询标准bom中的物料清单
        for (ManualTechnology manualTechnology : manualTechnologyList) {
            List<Mbom> mbomList = mbomMapper.selectList(Wrappers.<Mbom>query().eq("technology_id",manualTechnology.getTechnologyId()));
            List<ManualMbom> manualMboms = new ArrayList<>();
            for (Mbom mbom : mbomList) {
                ManualMbom manualMbom = ManualMbom.builder()
                        .manualTechnologyId(manualTechnology.getId()) //关联 生产订单id
                        .name(mbom.getName())
                        .unit(mbom.getUnit())
                        .num(mbom.getNum())
                        .qualityTraceability(mbom.getQualityTraceability())
                        .specifications(mbom.getSpecifications())
                        .build();
                manualMboms.add(manualMbom);
            }
            /*新增编制物料清单表*/
            manualMbomService.saveBatch(manualMboms);
        }
    }

    /*根据样品名称,样品编号,型号规格获取型号id*/
    private Integer getSpecificationId(String name, String mcode, String specification) {
        //获取物料id
        Material material = materialMapper.selectOne(Wrappers.<Material>query()
                .eq("name", name)
                .eq("code", mcode));
        if (Objects.isNull(material)) {
            return null;
        }
        //获取规格名称和型号名称
        String[] split = specification.split("-");
        String stName = split[0];
        String spName = split[1]+split[2];
        //获取规格id
        Standard standard = standardService.getOne(Wrappers.<Standard>query()
                .eq("name", stName)
                .eq("material_id", material.getId()));
        //获取型号id
        Specifications specifications = specificationsService.getOne(Wrappers.<Specifications>query()
                .eq("name", spName)
                .eq("standard_id", standard.getId()));
        return specifications.getId();
    }

}