/*
 *    Copyright (c) 2018-2025, ztt All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 * Redistributions of source code must retain the above copyright notice,
 * this list of conditions and the following disclaimer.
 * Redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the following disclaimer in the
 * documentation and/or other materials provided with the distribution.
 * Neither the name of the pig4cloud.com developer nor the names of its
 * contributors may be used to endorse or promote products derived from
 * this software without specific prior written permission.
 * Author: ztt
 */

package com.chinaztt.mes.plan.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.chinaztt.mes.plan.dto.MpsRequirementsDTO;
import com.chinaztt.mes.plan.entity.MpsRequirements;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

/**
 * 计划与排程
 *
 * @author luh
 * @date 2020-08-22 10:47:51
 */
@Mapper
public interface MpsRequirementsMapper extends BaseMapper<MpsRequirements> {

    /**
     * Description: 分页
     *
     * @param page
     * @param mpsRequirements
	 * @param type
     * @return IPage<List<MpsRequirements>>
     * @author: luh
     * @date: 2020/8/24 10:06
     */
    IPage<List<MpsRequirements>> getMpsRequirementsPage(Page page, @Param("ew") QueryWrapper<MpsRequirementsDTO> mpsRequirements,@Param("type")String type);

    /**
     * Description: 根据id查询生产计划
     *
     * @param id
     * @return
     */
    MpsRequirementsDTO selectDtoById(Long id);

    /**
     * Description: 根据id过滤查询该客户订单已下发计划的总数量
     *
     * @param id
     * @return
     */
    BigDecimal getQtyRequiredSumById(Long id);

    /**
     * Description: 根据id查询对应客户订单的销售数量
     *
     * @param id
     * @return
     */
    BigDecimal getOrderQuantityById(Long id);

    /**
     * Description: 根据id更新主生产计划-计划数量
     *
     * @param mpsRequirementsDTO
     * @return
     */
    int updatePlanRequiredById(@Param("param") MpsRequirementsDTO mpsRequirementsDTO);

    /**
     * Description: 根据id查询生成的计划
     *
     * @param id
     * @return
     */
    List<String> selectScheduleByRequirementsId(Long id);
}