package com.hxzkappboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.hxzkappboot.pojo.TbWarning;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author wangfei
 * @since 2024-03-08
 */
public interface TbWarningMapper extends BaseMapper<TbWarning> {

    @Select("SELECT w.id,w.type,w.tagid,w.status,w.time,w.baoliu1,w.baoliu2,w.baoliu3,w.baoliu4,w.baoliu5,w.baoliu6,p.name FROM tb_warnning w\n" +
            "INNER JOIN tb_person p on p.tagid = w.tagid where status = '未处理' or status = '已处理' order by w.time desc")
    List<TbWarning> findSelect();


    @Select("SELECT w.*,p.personname as pName,p.baoliu1 as pbaoliu1,p.type as ptype\n" +
            "FROM tb_warnning w\n" +
            "INNER JOIN tb_person p ON w.tagid = p.tagid\n" +
            "WHERE w.status='未处理' and p.company = #{company}  order by addtime desc  LIMIT #{current}, #{size}")
    List<TbWarning> findwarper(@Param("company")String company,@Param("current") long current, @Param("size") long size);

    @Select("SELECT w.*,p.personname as pName,p.baoliu1 as pbaoliu1,p.type as ptype\n" +
            "FROM tb_warnning w\n" +
            "INNER JOIN tb_person p ON w.tagid = p.tagid\n" +
            "WHERE w.status='未处理' order by addtime desc LIMIT #{current}, #{size}")
    List<TbWarning> findwarper3(@Param("current") long current, @Param("size") long size);

    @Select("SELECT w.*,p.*,p.baoliu1 as pbaoliu1,p.type as ptype\n" +
            "FROM tb_warnning w\n" +
            "INNER JOIN tb_person p ON w.tagid = p.tagid\n" +
            "WHERE status='未处理' and w.tagid = #{tagid}  and p.company = #{company}  order by addtime desc  LIMIT #{current}, #{size}")
    List<TbWarning> findwarper1(@Param("company")String company, @Param("tagid")String tagid,@Param("current") long current, @Param("size") long size);

    @Select("SELECT w.*,p.*,p.baoliu1 as pbaoliu1,p.type as ptype\n" +
            "FROM tb_warnning w\n" +
            "INNER JOIN tb_person p ON w.tagid = p.tagid\n" +
            "WHERE status='未处理' and w.tagid = #{tagid}  order by addtime desc  LIMIT #{current}, #{size}")
    List<TbWarning> findwarper11(@Param("tagid")String tagid,@Param("current") long current, @Param("size") long size);


    @Select("SELECT w.*,p.personname as pName,p.baoliu1 as pbaoliu1,p.type as ptype\n" +
            "FROM tb_warnning w\n" +
            "INNER JOIN tb_person p ON w.tagid = p.tagid\n" +
            "WHERE status='未处理' and p.company = #{company}  order by addtime desc ")
    List<TbWarning> findwarper2(@Param("company")String company);


}