package com.hxzkappboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzkappboot.pojo.TbDepartment;
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 TbDepartmentMapper extends BaseMapper<TbDepartment> {

    @Select("SELECT * \n" +
            "FROM tb_department \n" +
            "WHERE company = #{company} LIMIT #{current}, #{size}")
    List<TbDepartment> findwarper(@Param("company")String company, @Param("current") long current, @Param("size") long size);

    @Select("SELECT * \n" +
            "FROM tb_department \n" +
            " LIMIT #{current}, #{size}")
    List<TbDepartment> findwarper3( @Param("current") long current, @Param("size") long size);

    @Select("SELECT * \n" +
            "FROM tb_department \n" +
            "WHERE name = #{objectid} and company = #{company} LIMIT #{current}, #{size}")
    List<TbDepartment> findwarper1(@Param("company")String company, @Param("objectid")String objectid,@Param("current") long current, @Param("size") long size);


    @Select("SELECT * \n" +
            "FROM tb_department \n" +
            "WHERE name = #{objectid} LIMIT #{current}, #{size}")
    List<TbDepartment> findwarper11( @Param("objectid")String objectid,@Param("current") long current, @Param("size") long size);


}