| | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.example.erp.entity.pp.FlowCard; |
| | | import com.example.erp.entity.sd.OrderDetail; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | |
| | | @Mapper |
| | | public interface FlowCardMapper extends BaseMapper<FlowCard> { |
| | | //流程卡管理查询 |
| | | List<FlowCard> selectFlowCard(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | | List<FlowCard> selectFlowCard(Integer offset, Integer pageSize, String selectTime1, String selectTime2, FlowCard flowCard); |
| | | |
| | | //分页查询 |
| | | Map<String, Integer> getPageTotal(Integer offset, Integer pageSize, Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | | Map<String, Integer> getPageTotal(Integer offset, Integer pageSize, String selectTime1, String selectTime2, FlowCard flowCard); |
| | | |
| | | //分架数据查询 |
| | | List<FlowCard> selectFlowCardMp(Date selectTime1, Date selectTime2, FlowCard flowCard); |
| | |
| | | Boolean deleteReportingWork(String processId); |
| | | Boolean deleteReportingWorkByOrderId(String orderId); |
| | | |
| | | List<Map<String, String>> selectPrintFlowCardMp(Date selectTime1, Date selectTime2, String orderId, String project, FlowCard flowCard); |
| | | List<Map<String, String>> selectPrintFlowCardMp(Date selectTime1, Date selectTime2, String orderId, String project, Integer state, FlowCard flowCard); |
| | | |
| | | List<Map<String, String>> selectPrintFlowCard(Date selectTime1, Date selectTime2); |
| | | |
| | |
| | | Boolean updateInventory(String processId, String orderNumber, String technologyNumber, Integer completedQuantity); |
| | | |
| | | Boolean updateComposing(String processId); |
| | | |
| | | Boolean updateProcessCardRack(String processId,String technologyNumber,String rack); |
| | | |
| | | List<Map<String, String>> getPrintLabel(String projectNo); |
| | | |
| | |
| | | Integer selectProjectProcessPrintCount(String projectNo); |
| | | |
| | | int flowCardToOptimizeCount(String orderId); |
| | | |
| | | List<Map<String, Object>> getFlowCardDetail(String processId); |
| | | |
| | | Map<String,Object> getGlassThicknessByProdutionId(String orderId,String productionId); |
| | | |
| | | List<OrderDetail> getOrderDetailByProductionId(String orderId, String productionId, String type, Float inLenMax, Float inLenMin, Float inShortMax, Float inShortMin, Float glassThickness); |
| | | |
| | | Boolean revokeComposing(String processId); |
| | | |
| | | Integer selectProjectNo(String processId); |
| | | |
| | | List<Map<String, String>> selectPrintDetailsMp2(String orderId); |
| | | |
| | | List<Map<String, Object>> getPrintOrderDataDetails(String orderId, Integer orderNumber, Integer printQuantity); |
| | | |
| | | Boolean updatePrintNumberMp(String processId, Integer orderNumber); |
| | | |
| | | String getOrderIdByProcessId(String processId); |
| | | |
| | | Boolean updateFlowCardIsMerge(String processId); |
| | | |
| | | Integer flowCardDetailMergeMp(String processId); |
| | | |
| | | String getProcessName(String processSub); |
| | | |
| | | List<Map<String, Object>> getProcessNameList(); |
| | | } |