package com.qianwen.smartman.modules.smis.mapper; import com.baomidou.mybatisplus.core.conditions.Wrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import java.util.List; import java.util.Set; import org.apache.ibatis.annotations.Param; import com.qianwen.core.datascope.annotation.DataAuth; import com.qianwen.smartman.modules.smis.dto.WorkstationRealTimeStatusDTO; import com.qianwen.smartman.modules.smis.dto.WorkstationWcsDmpDTO; import com.qianwen.smartman.modules.smis.entity.ProductionCalendarDay; import com.qianwen.smartman.modules.smis.entity.Workstation; import com.qianwen.smartman.modules.smis.vo.DmpVariablesVO; import com.qianwen.smartman.modules.smis.vo.WorkMachineEasyVO; import com.qianwen.smartman.modules.smis.vo.WorkstationRealTimeStatusVO; import com.qianwen.smartman.modules.smis.vo.WorkstationVO; import com.qianwen.smartman.modules.mdc.dto.GroupWorkDTO; import com.qianwen.smartman.modules.mdc.dto.WorkstationDmpDTO; import com.qianwen.smartman.modules.report.dto.WorkstationDataDTO; public interface WorkstationMapper extends BaseMapper { List queryDmpList(@Param("workstationId") String workstationId); /** * 工位分页查询 * @param groupIdList * @param page 分页信息 * @param keyWord 关键字 * @param groupId 分组id * @param allWorkstationId * @param status 状态 * @param type 工位类型 * @param year * @return 分页数据 */ @DataAuth(code = "workstation") List listPage(List groupIdList, IPage page, String keyWord, Long groupId, Long allWorkstationId, @Param("status")Integer status,@Param("type") Integer type, Integer year); @DataAuth(code = "workstation")

> P selectPage(P page, @Param("ew") Wrapper queryWrapper); @DataAuth(code = "workstation") List selectList(@Param("ew") Wrapper queryWrapper); List listWorkstation(@Param("groupIds") List groupIds); @DataAuth(code = "workstation") List getWorkstationListByWorkStationGroupIdList(IPage page, @Param("dto") WorkstationRealTimeStatusDTO dto); @DataAuth(code = "workstation") IPage listWorkStationOnShiftIndex(IPage page, @Param("year") Integer year, @Param("queryDate") String queryDate, @Param("shift") Integer shift, @Param("type") Integer type, @Param("ids") List ids); Integer countWorkStationOnShiftIndex(@Param("year") Integer year, @Param("queryDate") String queryDate, @Param("shift") Integer shift, @Param("type") Integer type, @Param("ids") List ids); List listWorkStationByGroupId(@Param("ids") List ids); Set findByIndexAndDateAndTypeAndYear(@Param("year") Integer year, @Param("queryDate") String queryDate, @Param("shift") Integer shift, @Param("type") Integer type); List findByMachineShortCode(@Param("code") String code); List queryWcsList(@Param("workstationId") String workstationId); WorkstationWcsDmpDTO queryDateTypeState(@Param("code") Integer code, @Param("workstationId") String workstationId); List queryGroupWorkStation(List ids); List listWorkStationOnShift(@Param("year") Integer year, @Param("queryDate") String queryDate, @Param("shifts") List shifts, @Param("type") Integer type, @Param("ids") List ids); IPage queryWorkstationAndGroup(IPage page, @Param("workstationIds") List workstationIds); ProductionCalendarDay getDayShift(@Param("workstationId") Long workstationId, @Param("calendarDate") String calendarDate); IPage getWorkstationData(IPage page, @Param("keyword") String keyword, @Param("workstationIds") List workstationIds); IPage getWorkstationDataWithIndexName(IPage page, @Param("keyword") String keyword, @Param("indexName") String indexName, @Param("startTime") String startTime, @Param("endTime") String endTime, @Param("workstationIds") List workstationIds); List getDmpVar(@Param("workstationId") String workstationId); WorkMachineEasyVO getWorkMachine(@Param("workstationId") String workstationId); @DataAuth(code = "workstation") List listMachine(@Param("status") Integer status, @Param("keyword") String keyword); List getWorkstationListInMaintainOrRepairById(@Param("orderProcessId") Long orderProcessId, @Param("workstationIdList") Set workstationIdList); List getWorkstationListInMaintainOrRepairByIdList(@Param("orderProcessIdList") List orderProcessIdList, @Param("workstationIdList") Set workstationIdList); @DataAuth(code = "workstation") List listWorkstationDataByGroup(@Param("groupId") String groupId); }