package com.hxzkappboot.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
|
import com.hxzkappboot.pojo.PersonCesium;
|
import com.hxzkappboot.pojo.TbPerson;
|
import com.hxzkappboot.pojo.TbPersonAndDepartment;
|
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 TbPersonMapper extends BaseMapper<TbPerson> {
|
|
// @Select({"select * from tb_person where p_fencename = #{name}"})
|
// List<TbPerson> findAllperson(String name);
|
|
// @Select("SELECT p.*, d.name AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.department = d.name where online = '1' AND p.company = #{company} AND (p.tagid = #{name} or p.name = #{name})")
|
// TbPerson findOnePerson(@Param("name")String name,@Param("company")String company);
|
|
@Select("SELECT p.*, d.name AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.department = d.name where online = '1' AND (p.tagid = #{name} or p.name = #{name})")
|
TbPerson findOnePerson(@Param("name")String name,@Param("company")String company);
|
|
@Select("SELECT\n" +
|
"\t* \n" +
|
"FROM\n" +
|
"\t`tb_person` \n" +
|
"WHERE\n" +
|
"\ttagid LIKE '%F%' \n" +
|
"ORDER BY\n" +
|
"\t`addtiem` DESC \n" +
|
"\tLIMIT 1;")
|
TbPerson upTag();
|
|
// @Select("SELECT p.*,d.name AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.department = d.name where p.online = 1 and p.company = #{company}")
|
// List<TbPerson> findAllBuMen(@Param("company")String company);
|
//
|
// @Select("SELECT p.* FROM tb_person p INNER JOIN tb_department d ON p.department = d.name where p.company = #{company}")
|
// List<TbPerson> findAllBuMenCesium(@Param("company")String company);
|
|
@Select("SELECT p.*,d.name AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.department = d.name where p.online = 1 and p.company = #{company}")
|
List<TbPerson> findAllBuMen(@Param("company")String company);
|
|
@Select("SELECT p.*,d.name AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.department = d.name where p.online = 1 ")
|
List<TbPerson> findAllBuMen3();
|
|
@Select("SELECT p.* FROM tb_person p INNER JOIN tb_department d ON p.department = d.name where p.company = #{company} ")
|
List<TbPerson> findAllBuMenCesium(@Param("company")String company);
|
|
@Select("SELECT p.* FROM tb_person p INNER JOIN tb_department d ON p.department = d.name")
|
List<TbPerson> findAllBuMenCesium3();
|
|
}
|