package com.chinaztt.mes.plan.util;


import cn.hutool.core.bean.BeanUtil;
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.chinaztt.mes.plan.entity.ManufacturingOrder;
import com.chinaztt.mes.plan.entity.MasterProductionSchedule;
import com.chinaztt.mes.plan.entity.MoSamplingRule;
import com.chinaztt.mes.plan.entity.MoTestStandard;
import com.chinaztt.mes.plan.mapper.ManufacturingOrderMapper;
import com.chinaztt.mes.plan.mapper.MasterProductionScheduleMapper;
import com.chinaztt.mes.plan.mapper.MoSamplingRuleMapper;
import com.chinaztt.mes.plan.mapper.MoTestStandardMapper;
import com.chinaztt.mes.technology.dto.RoutingOperationDTO;
import com.chinaztt.mes.technology.entity.DocumentSamplingRule;
import com.chinaztt.mes.technology.entity.DocumentTestStandard;
import com.chinaztt.mes.technology.entity.JoinDocumentBomRouting;
import com.chinaztt.mes.technology.entity.RoutingOperation;
import com.chinaztt.mes.technology.mapper.DocumentSamplingRuleMapper;
import com.chinaztt.mes.technology.mapper.DocumentTestStandardMapper;
import com.chinaztt.mes.technology.mapper.JoinDocumentBomRoutingMapper;
import com.chinaztt.mes.technology.mapper.RoutingOperationMapper;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.stream.Collectors;

/**
 * @Description : 车间订单工具类
 * @ClassName : ManufacturingOrderUtils
 * @Author : sll
 * @Date: 2022-07-02  13:46
 */
@Service
@AllArgsConstructor
public class ManufacturingOrderUtils{
	private ManufacturingOrderMapper manufacturingOrderMapper;
	private RoutingOperationMapper routingOperationMapper;
	private JoinDocumentBomRoutingMapper joinDocumentBomRoutingMapper;
	private DocumentTestStandardMapper documentTestStandardMapper;
	private MoTestStandardMapper moTestStandardMapper;
	private MasterProductionScheduleMapper masterProductionScheduleMapper;
	private DocumentSamplingRuleMapper documentSamplingRuleMapper;
	private MoSamplingRuleMapper moSamplingRuleMapper;


	/**
	 * @param moId                 车间订单id
	 * @param moRoutingOperationId 车间订单工艺路线工序id
	 * @param routingOperationDTO
	 * @param outPartId 产出零件id
	 */
	public void fillStandardByOperationDoc(Long moId, Long moRoutingOperationId, RoutingOperationDTO routingOperationDTO, Long outPartId) {
		ManufacturingOrder manufacturingOrder = manufacturingOrderMapper.selectById(moId);//根据车间订单行id获取车间订单
		Long bomid = manufacturingOrder.getBomId();//获取bomid
		Long mpsid = manufacturingOrder.getMpsId();//主计划id

		MasterProductionSchedule masterProductionSchedule = masterProductionScheduleMapper.selectById(mpsid);//根据主计划id获取主计划
		Long docid = masterProductionSchedule.getTechnologyDocumentId();//工艺文件id

		RoutingOperation routingOperation = routingOperationMapper.selectById(routingOperationDTO.getId());//根据工艺工序id获取工艺工序记录行
		Long routingId = routingOperation.getRoutingId();//获取工艺id
		Long routingOperationId = routingOperation.getId();//工艺工序关系表记录行id
		//Long partId = routingOperationDTO.getPartId();//零件id
		Long partId = outPartId;

		//根据工艺文件id&&bomid&&工艺id&&零件id——>工艺路线-零件-bom的关系
		List<JoinDocumentBomRouting> joinDocumentBomRoutingList = joinDocumentBomRoutingMapper.selectList(Wrappers.<JoinDocumentBomRouting>lambdaQuery().eq(JoinDocumentBomRouting::getDocumentId,docid).eq(JoinDocumentBomRouting::getBomId,bomid).eq(JoinDocumentBomRouting::getRoutingId,routingId).eq(JoinDocumentBomRouting::getPartId,partId));
		if(CollectionUtils.isNotEmpty(joinDocumentBomRoutingList)){
			//理论上这种查法只能查出一条记录
			//万一能取到多条记录，但是不是每一条都做了检测标准，取一个存在对应检测标准的
			JoinDocumentBomRouting joinDocumentBomRouting_use = new JoinDocumentBomRouting();
			for(JoinDocumentBomRouting joinDocumentBomRouting : joinDocumentBomRoutingList){
				List<DocumentTestStandard> documentTestStandardList = documentTestStandardMapper.selectList(Wrappers.<DocumentTestStandard>lambdaQuery().eq(DocumentTestStandard::getDocBomId,joinDocumentBomRouting.getId()));
				if(CollectionUtils.isNotEmpty(documentTestStandardList)){
					joinDocumentBomRouting_use = joinDocumentBomRouting;
					break;//退出遍历
				}
			}

			List<DocumentTestStandard> documentTestStandardList = documentTestStandardMapper.selectList(Wrappers.<DocumentTestStandard>lambdaQuery().eq(DocumentTestStandard::getDocBomId,joinDocumentBomRouting_use.getId()).eq(DocumentTestStandard::getRoutingOperationId,routingOperationId));

			if(CollectionUtils.isNotEmpty(documentTestStandardList)){
				//一道工序可能会存在多条检测标准
				for(DocumentTestStandard documentTestStandard : documentTestStandardList){
					MoTestStandard moTestStandard = new MoTestStandard();
					moTestStandard.setMoRoutingOperationId(moRoutingOperationId);
					moTestStandard.setStandardNo(documentTestStandard.getStandardNo());
					moTestStandard.setStandardName(documentTestStandard.getStandardName());
					moTestStandard.setInspectionType(documentTestStandard.getInspectionType());
					moTestStandard.setJudgeFormula(documentTestStandard.getJudgeFormula());
					moTestStandard.setVersion(documentTestStandard.getVersion());
					moTestStandard.setRemark(documentTestStandard.getRemark());
					moTestStandard.setMoId(moId);
					moTestStandard.setRoutingOperationId(routingOperationDTO.getId());
					moTestStandardMapper.insert(moTestStandard);
					//创建车间订单检测标准参数
					moTestStandardMapper.createMoTestParamByDocTestStandardId(moTestStandard.getId(), documentTestStandard.getId());
				}
			}

			// 保存抽检规则
			List<DocumentSamplingRule> documentSamplingRules = documentSamplingRuleMapper.selectList(Wrappers.<DocumentSamplingRule>lambdaQuery()
					.in(DocumentSamplingRule::getDocBomId, joinDocumentBomRoutingList.stream().map(JoinDocumentBomRouting::getId).collect(Collectors.toList()))
					.eq(DocumentSamplingRule::getRoutingOperationId, routingOperationId));
			if (CollectionUtils.isNotEmpty(documentSamplingRules)) {
				for (DocumentSamplingRule documentSamplingRule : documentSamplingRules) {
					MoSamplingRule moSamplingRule = BeanUtil.copyProperties(documentSamplingRule, MoSamplingRule.class);
					moSamplingRule.setMoRoutingOperationId(moRoutingOperationId);
					moSamplingRule.setMoId(moId);
					moSamplingRuleMapper.insert(moSamplingRule);
				}
			}
		}
	}
}