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