#

Junjie

8 天以前 edf5eb33c88d88062e295db466a654ac0a646ded

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
package com.zy.asrs.wcs.core.mapper;
 
import com.zy.asrs.wcs.core.domain.dto.WorkChartAxis;
import com.zy.asrs.wcs.core.entity.Task;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
 
import java.util.List;
 
@Mapper
@Repository
public interface TaskMapper extends BaseMapper<Task> {
 
    List<Task> selectOutboundByShuttleNo(@Param("shuttleNo") Integer shuttleNo);
 
    List<Task> selectByAnalyzeSts();
 
    List<Task> selectByExecuteSts();
 
    List<Task> selectChargeByAnalyzeSts();
 
    List<Task> selectChargeByExecuteSts();
 
    List<Task> selectManualByAnalyzeSts();
 
    List<Task> selectManualByExecuteSts();
 
    List<Task> selectMoveByAnalyzeSts();
 
    List<Task> selectMoveByExecuteSts();
 
    List<Task> selectWaitAnalyzeInBoundTask();
 
    List<Task> selectPakOut();
 
    List<Task> selectWaitAnalyzeMoveTask();
 
    List<Task> selectWaitAnalyzeLadenMoveTask();
 
    List<Task> selectLadenMoveByAnalyzeSts();
 
    List<Task> selectLadenMoveByExecuteSts();
 
    List<Task> hasChargeInLoc(String locNo);
 
    Task selectMoveWorking(Integer shuttleNo);
 
    Task selectManualWorking(Integer shuttleNo);
 
    List<Task> selectWorkingByShuttle(Integer shuttleNo, String taskNo);
 
    List<Task> selectWorkingByLift(Integer liftNo, String taskNo);
 
    Task selectChargeWorking(Integer shuttleNo);
 
    @Select("SELECT\n" +
            "    ymd,\n" +
            "    SUM(sto_qty) AS inqty,\n" +
            "    SUM(ret_qty) AS outqty\n" +
            "FROM\n" +
            "    asr_sta_inout_view\n" +
            "WHERE\n" +
            "    ymd >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 12 DAY), '%Y-%m-%d')\n" +
            "GROUP BY\n" +
            "    ymd\n" +
            "ORDER BY\n" +
            "    ymd;")
    List<WorkChartAxis> selectByLineCharts();
}