package com.gkhy.safePlatform.equipment.repository;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.gkhy.safePlatform.equipment.entity.*;
|
import com.gkhy.safePlatform.equipment.model.dto.req.SafeMatetrialDetailQuery;
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.stereotype.Repository;
|
|
import java.time.LocalDateTime;
|
import java.util.List;
|
|
@Repository
|
public interface SafeMaterialDetailInfoRepository extends BaseMapper<SafeMaterialDetailInfo> {
|
Integer getTotalCount();
|
|
SafeMaterialDetailInfo queryById(Long id);
|
void updateReceiptStatus(@Param("id") Long id, @Param("status") Byte status,@Param("wareHousingTime") LocalDateTime wareHousingTime);
|
|
List<SafeMaterialDetailInfo> getListByIds(List<Long> ids);
|
|
void updateReceiptStatusByIds(@Param("ids") List<Long> ids, @Param("irStatus") Byte irStatus, @Param("wareHousingTime")LocalDateTime wareHousingTime);
|
|
List<SafeMaterialDetailCountDO> getCountGroupBySmId(@Param("ids") List<Long> ids, @Param("irStatus") Byte irStatus);
|
|
List<SafeMaterialDetailCountDO> getStatisticsValidStock(@Param("smIds") List<Long> smIds,@Param("validStatus") Byte validStatus,@Param("irStatus") Byte irStatus);
|
|
void deleteBatch(Long[] ids);
|
|
void updateDeliveryStatusByIds(@Param("detailBO")SafeMaterialDetailBO detailBO);
|
|
void deliveryBatchRandom(@Param("detailBO")SafeMaterialDetailBO detailBO);
|
|
Integer getValidStockCount(@Param("smId")Long smId, @Param("validStatus")Byte validStatus, @Param("irStatus")Byte irStatus);
|
|
List<SafeMaterialDetailInfoDO> listByCondition(Page<SafeMaterialDetailInfo> page, @Param("query") SafeMatetrialDetailQuery query);
|
|
int getCountBySmIds(@Param("smIds") List<Long> smIds);
|
|
int getCountBySmId(Long smId);
|
|
void updateValidStatus(@Param("id") Long id, @Param("validStatus")Byte validStatus);
|
|
List<Long> getRfidNotNullList(@Param("count") Integer count,@Param("smId")Long smId);
|
|
List<Long> getRfidNullList(@Param("count") Integer count,@Param("smId") Long smId);
|
|
List<Long> getIdListByRfid(Integer count, Long smId, String rfid);
|
|
List<SafeMaterialClassifyStockDO> getSmallClassifyStockByIds(@Param("smallClassifyIds") List<Long> smallClassifyIds);
|
|
List<SafeMaterialDetailDO> getListBySmallClassifyIds(List<Long> smallClassifyIds,@Param("depIds") List<Long> depIds);
|
|
List<SafeMaterialDetailInfoDO> getListByRfids(List<String> rfids);
|
}
|