安全物资和设备管理

zhangfeng

2022-11-08 f241a39f07acc5d5ede28b4152d74cbb84e4885b

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
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.SafeMaterialDetailBO;
import com.gkhy.safePlatform.equipment.entity.SafeMaterialDetailInfo;
import com.gkhy.safePlatform.equipment.entity.SafeMaterialDetailCountDO;
import com.gkhy.safePlatform.equipment.entity.SafeMaterialDetailInfoDO;
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);
}