/*
|
* 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.annotation.SqlParser;
|
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.ManufacturingOrderDTO;
|
import com.chinaztt.mes.plan.dto.MoTestStandardDTO;
|
import com.chinaztt.mes.plan.entity.ManufacturingOrder;
|
import com.chinaztt.mes.plan.entity.OrderParam;
|
import com.chinaztt.mes.plan.excel.ManufacturingOrderData;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* 制造订单表
|
*
|
* @author cxf
|
* @date 2020-09-24 14:26:01
|
*/
|
@Mapper
|
public interface ManufacturingOrderMapper extends BaseMapper<ManufacturingOrder> {
|
|
/**
|
* 分页查询
|
*
|
* @param page
|
* @param query
|
* @return
|
*/
|
@SqlParser(filter = true)
|
IPage<List<ManufacturingOrder>> getManufacturingOrderPage(Page page, @Param("ew") QueryWrapper<ManufacturingOrderDTO> query, @Param("orderParam") OrderParam orderParam);
|
|
/**
|
* 根据id查询制造订单
|
*
|
* @param id
|
* @return
|
*/
|
ManufacturingOrderDTO selectDtoById(Long id);
|
/**
|
* 通过id查询工单来源
|
*
|
* @param id
|
* @return
|
*/
|
List<ManufacturingOrderDTO> getOperationSupplyById(Long id);
|
/**
|
* 分页查询
|
*
|
* @param page
|
* @param query
|
* @param list
|
* @return
|
*/
|
IPage<List<ManufacturingOrder>> getManufacturingOrderPageByCustomer(Page page,@Param("ew") QueryWrapper<ManufacturingOrderDTO> query,@Param("list")List<Long> list);
|
|
/**
|
* 根据状态查询对应的工单
|
*
|
* @param moId
|
* @param state
|
* @return
|
*/
|
List<String> checkOperationTaskStateByMoId(@Param("moId") Long moId, @Param("stateList") List<String> stateList);
|
/**
|
* 分页查询制造订单报表
|
* @param page
|
* @param gen
|
* @return
|
*/
|
IPage<ManufacturingOrderDTO> getStatementPage(Page page, @Param("ew")QueryWrapper<ManufacturingOrderDTO> gen);
|
|
/**
|
* 根据报工产出的SN号查询制造订单
|
*
|
* @param sn
|
* @return
|
*/
|
List<MoTestStandardDTO> getManufacturingOrder(@Param("sn")String sn);
|
|
/**
|
* distinct 查询 零件id | 工艺id | bomId
|
* @param ids
|
* @return
|
*/
|
List<String> getMergeCheckData(@Param("ids") List<Long> ids);
|
|
/**
|
* 根据工单查找SN
|
* @param taskId
|
* @return
|
*/
|
String getSNByTaskId(@Param("taskId") Long taskId);
|
|
/**
|
* exccel导出查询
|
*
|
* @param query
|
* @param list
|
* @return
|
*/
|
List<ManufacturingOrderData> getExcelDataByList(@Param("ew") QueryWrapper<ManufacturingOrderDTO> query,@Param("list")List<Long> list);
|
|
/**
|
* exccel导出查询
|
*
|
* @param query
|
* @param orderParam
|
* @return
|
*/
|
@SqlParser(filter = true)
|
List<ManufacturingOrderData> getExcelDataByParam( @Param("ew") QueryWrapper<ManufacturingOrderDTO> query, @Param("orderParam") OrderParam orderParam);
|
|
/**
|
* 查找对应车间订单下所有工单状态
|
* @param moId
|
* @return
|
*/
|
List<String> getAllStateByMoId(@Param("moId") Long moId);
|
}
|
