#

Junjie

2025-07-06 0d04bc5d8080b82338302fba0a59fccff2eaedfc

 zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java

@@ -1,9 +1,11 @@
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;
@@ -54,4 +56,17 @@

    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();
}