zhangfeng
2022-11-21 99968f83982943669af3829ea6bc3bbe745cada4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
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);
}