hust-epi/whepi-web/src/main/java/com/bofeng/dao/QzTaskDao.java

package com.bofeng.dao;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.bofeng.entity.QzTask;
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 QzTaskDao extends BaseMapper<QzTask> {

    List<QzTask> selectAll();

    QzTask queryByTaskId(Long taskId);

    List<QzTask> queryByHouseNumber(@Param("houseNumber") String houseNumber, @Param("status") Integer status);

    Integer updateStatusById(@Param("taskId") Long taskId, @Param("status") Integer status);

    List<QzTask> queryQzTaskByStatus(@Param("taskStatus") Integer taskStatus);

    List<QzTask> queryQzTask(@Param("taskStatus") Integer taskStatus, @Param("taskTitle") String taskTitle, @Param("userId") Long userId);

    //当前用户名称
    QzTask selectUserName(@Param("userId") Long userId);

    //当前用户门牌id 门牌号
    QzTask selectHome(@Param("userId") Long userId);

    @Select("select count(1) from qz_task where DATE_FORMAT(time_create,'%Y-%m-%d')=#{queryDate}\n" +
            "union all select count(1) from qz_task where DATE_FORMAT(time_create,'%Y-%m-%d')=#{queryDate} and task_status=3\n" +
            "union all select count(1) from qz_task where DATE_FORMAT(time_create,'%Y-%m-%d')=#{queryDate} and task_status in (1,2)\n" +
            "union all select count(1) from qz_task where time_create BETWEEN date_add(#{queryDate}, interval -30 day) and date_add(#{queryDate}, interval 1 day)\n" +
            "union all select count(1) from qz_task where time_create BETWEEN date_add(#{queryDate}, interval -30 day) and date_add(#{queryDate}, interval 1 day) and task_status=3\n" +
            "union all select count(1) from qz_task where time_create BETWEEN date_add(#{queryDate}, interval -30 day) and date_add(#{queryDate}, interval 1 day) and task_status in (1,2);\n" +
            "")
    List<Long> queryUserHelpAnaly(@Param("queryDate") String queryDate);

}