package com.chinaztt.mes.warehouse.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.warehouse.dto.JoinStockOrderDTO;
import com.chinaztt.mes.warehouse.entity.JoinStockOrder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;

/**
 * 客户订单库存预留表
 *
 * @author cxf
 * @date 2021-07-21 15:36:57
 */
@Mapper
public interface JoinStockOrderMapper extends BaseMapper<JoinStockOrder> {
	/**
	 * 分页查询
	 *
	 * @param page
	 * @param gen
	 * @return
	 */
	IPage<JoinStockOrderDTO> getJoinStockOrderPage(Page page, @Param("ew") QueryWrapper<JoinStockOrderDTO> gen);

	/**
	 * 刷新客户订单的已预留数量
	 *
	 * @param id
	 * @param total
	 * @return
	 */
	int updateOrderById(@Param("id") Long id, @Param("total") BigDecimal total);

	/**
	 * 刷新工单的已预留数量
	 *
	 * @param id
	 * @param total
	 * @return
	 */
	int updateOperationTaskId(@Param("id") Long id, @Param("total") BigDecimal total);

	/**
	 * 将当前工单下的所需物料的已预留数量置空
	 *
	 * @param id
	 * @return
	 */
	void updateOperationTaskMaterial(Long id);

	/**
	 * 更新工单下的所需物料的已预留数量
	 *
	 * @param id
	 * @param number
	 * @param partId
	 * @return
	 */
	void updateOperationTaskMaterialById(@Param("id") Long id, @Param("number") BigDecimal number, @Param("partId") Long partId);

	/**
	 * 查找发货绑定的客户订单的GSM的合同产品id
	 *
	 * @param stockOrderId
	 * @return
	 */
	Long selectCustomerOrder(Long stockOrderId);

	/**
	 * 根据stockId查询预留总数量
	 *
	 * @param stockId
	 * @return
	 */
	BigDecimal selectTotalQuantityByStockId(@Param("stockId") Long stockId);

	JoinStockOrderDTO getStockOrderById(Long id);
}