/* * 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.production.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.production.dto.DutyRecordDTO; import com.chinaztt.mes.production.entity.DutyRecord; import com.chinaztt.mes.production.excel.*; import com.chinaztt.ztt.common.data.datascope.DataScope; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; /** * 上班记录 * * @author cxf * @date 2021-01-20 09:11:25 */ @Mapper public interface DutyRecordMapper extends BaseMapper { /** * 分页查询 * * @param page * @param gen * @param scope * @return */ IPage> getDutyRecordPage(Page page, @Param("ew") QueryWrapper gen, DataScope scope); /** * 通过id查询上班记录 * * @param id * @return */ DutyRecordDTO getDtoById(Long id); /** * 导出 * * @param gen * @return */ List exportList(@Param("ew") QueryWrapper gen); /** * 导出 * * @param gen * @return */ List exportPersonBoard(@Param("ew") QueryWrapper gen); /** * 通过工作站id查询班次 * * @param workstationId * @return */ DutyRecordDTO getDutyRecordByWorkstationId(Long workstationId); /** * 根据id备份记录 * * @param id * @param type * @return */ int backDutyRecordById(@Param("id") Long id, @Param("type") String type); /** * 根据id备份删除记录 * * @param id * @param operator * @return */ int backDeleteDutyRecordById(@Param("id") Long id, @Param("operator") String operator); /** * 通过id查询操作记录 * * @param id * @return */ List getOperatingRecord(Long id); /** * 根据班次id查找之后的班次记录id * * @param dutyRecordId * @return */ List selectComingByDutyRecordId(Long dutyRecordId); /** * 查询详细的人工记录 * * @param page * @param gen * @return */ IPage> getArtificialRecord(Page page, @Param("ew") QueryWrapper gen); /** * 导出 * * @param gen * @return */ List exportAttendance(@Param("ew") QueryWrapper gen); /** * 根据id更新待处理 * * @param dutyRecordId * @return */ int refreshPendingById(Long dutyRecordId); /** * 根据id更新班次产量 * * @param dutyRecordId * @return */ int refreshDutyOutputById(Long dutyRecordId); int batchbackDutyRecordByIds(@Param("ids") List ids, @Param("type") String type); /** * 导出班次工资 * * @param gen * @return */ List exportShiftWage(@Param("ew") QueryWrapper gen); /** * 查询未提交班次信息 * * @param startIndex * @return */ List selectUnsubmitRecord(@Param("startIndex")Long startIndex); /** * 展示该工作中心对应的未提交班次信息 * * @param workCenter * @return */ List selectUnsubmitWorkstation(@Param("workCenter")String workCenter); }