package com.zy.asrs.mapper;
|
|
import com.zy.asrs.domain.dto.LocChartPie;
|
import com.zy.asrs.domain.dto.WorkChartAxis;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
import java.util.Map;
|
|
@Mapper
|
@Repository
|
public interface ReportQueryMapper {
|
|
@Select("select \n" +
|
"Min(wm.io_time) as node,\n" +
|
"isnull(count(1), 0) as val\n" +
|
"from asr_wrk_mast_log wm\n" +
|
"where wm.wrk_sts = 5 \n" +
|
"and (wm.io_type = 1 OR wm.io_type = 54)\n" +
|
"and datediff(d, wm.io_time, getdate())<=7 \n" +
|
"group by datediff(day,wm.io_time,getdate())\n" +
|
"order by Min(wm.io_time) asc\n")
|
List<Map<String, Object>> queryPakinRep();
|
|
//饼状图
|
@Select("select * from asr_loc_use_view")
|
public LocChartPie getLocUseRate();
|
|
|
//曲线图
|
@Select("select ymd,SUM(sto_qty) inqty,SUM(ret_qty) outqty from asr_sta_inout_view "
|
+ "where ymd>CONVERT(char(10), DATEADD(DAY,-12,GETDATE()), 120) group by ymd order by ymd")
|
public List<WorkChartAxis> getChartAxis();
|
|
|
}
|
