jiaosong
2023-08-18 b5a63b29313463d1c2fd1b5678a2d6b2bb8a7044
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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
package doumeemes.dao.ext;
 
import doumeemes.dao.business.model.Appliances;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import doumeemes.dao.ext.bean.*;
import doumeemes.dao.ext.dto.QueryAppliancesByManualDTO;
import doumeemes.dao.ext.vo.AppliancesExtListVO;
import doumeemes.dao.ext.dto.QueryAppliancesExtDTO;
import io.swagger.models.auth.In;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
 
public interface AppliancesExtMapper extends BaseMapper<Appliances> {
 
    /**
     * 管理页面查询
     * @author 江蹄蹄
     * @date 2022/04/20 11:01
     */
    List<AppliancesExtListVO> selectList(QueryAppliancesExtDTO dto);
 
    AppliancesExtListVO findMaxSerial(QueryAppliancesExtDTO pageWrap);
 
    List<AppliancesExtListVO> selectListByCondition(QueryAppliancesExtDTO dto);
 
    OutScanBean scanDetailForOut(@Param("brCode") Integer brCode , @Param("code") String code
                                ,@Param("rootDepartId") Integer rootDepartId);
 
    List<AppliancesMaterialBean> getMaterialByLocationId(@Param("locationIds") String locationIds);
 
    AppliancesBoxNumBean getTypeNumByLocationId(@Param("locationIds") String locationIds ,
                                                @Param("label") String label ,
                                                @Param("materialId") String materialId  ,
                                                @Param("inIds") String inIds );
 
    AppliancesBoxNumBean getTypeNumByInIds(@Param("locationIds") String locationIds ,
                                                @Param("label") String label ,
                                                @Param("materialId") String materialId  ,
                                                @Param("inIds") String inIds );
 
 
    AppliancesBoxNumBean getTypeNumUnitByLocationId(@Param("locationIds") String locationIds ,
                                                @Param("label") String label ,
                                                @Param("materialId") Integer materialId  ,
                                                @Param("inIds") String inIds );
 
    AppliancesBoxNumBean getNumByInIds(@Param("inIds") String inIds );
 
 
 
 
    List<AppliancesMaterialBean> getMaterialByInIdLocationIds(@Param("id") Integer id,@Param("locationIds") String locationIds);
 
    List<AppliancesMaterialBean> getMaterialByInIdLocationIdsNew(@Param("id") Integer id,@Param("locationIds") List<Integer> locationIds);
 
 
    AppliancesBoxNumBean getMaterialNumTypeByInIdLocationIds(@Param("id") Integer id ,
                                                    @Param("locationIds") String locationIds,
                                                    @Param("label") String label ,
                                                    @Param("materialId") Integer materialId  );
 
 
    AppliancesBoxNumBean getMaterialNumTypeByInIdLocationIdsNew(@Param("id") Integer id ,
                                                             @Param("locationIds") List<Integer> locationIds,
                                                             @Param("type") Integer type ,
                                                             @Param("materialId") Integer materialId  );
 
 
    List<AppliancesFroWTransferBean> getDataToWTransfer(@Param("proceduresId") Integer proceduresId ,
                                                                   @Param("produceLocationIds") String produceLocationIds,
                                                                   @Param("finishLocationIds") String finishLocationIds ,
                                                                   @Param("inIds") String inIds ,
                                                                   @Param("qualified") String qualified,
                                                                   @Param("rejects") String rejects ,
                                                                   @Param("scrap") String scrap );
 
    List<AppliancesFroWTransferBean> getDataToWTransferNew(@Param("proceduresId") Integer proceduresId ,
                                                        @Param("allLocationIds") String allLocationIds,
                                                        @Param("inIds") String inIds  );
 
 
     void editById(Appliances appliances);
 
 
 
    List<ReserveMaterialBean> reserveMaterialBeanList(@Param("id") Integer id,@Param("locationIds") List<Integer> locationIds);
 
 
    List<AppliancesExtListVO> findListPageForManual(QueryAppliancesByManualDTO dto);
}