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.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where  p_online = '1' AND p.company = #{company} AND (p.p_tagid = #{name} or p.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" +
            "\tp_tagid LIKE '%F%' \n" +
            "ORDER BY\n" +
            "\t`p_addtiem` DESC \n" +
            "\tLIMIT 1;")
    TbPerson upTag();

    @Select("SELECT p.p_tagid,p.p_power,p.p_name,p_online,p.p_image,p.baoliu2,p.baoliu3,p.baoliu13,p.baoliu4,p.baoliu19,p.p_sos,p.p_addtiem,p.p_department,p.company as company,d.departmentName AS bumen1, d.baoliu5 AS bumencolor FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.p_online = 1 and p.company = #{company}")
    List<TbPersonAndDepartment> findAllBuMen(@Param("company")String company);

    @Select("SELECT p.p_tagid as id,p.p_name as name,p.baoliu2 as baoliu2,p.baoliu3 as baoliu3,p.baoliu19 as baoliu19,p.p_department as pdepartment,p.baoliu4 as baoliu4,p.company as company,p.p_power as ppower,p.p_online as online FROM tb_person p INNER JOIN tb_department d ON p.p_department = d.departmentName where p.company = #{company}")
    List<PersonCesium> findAllBuMenCesium(@Param("company")String company);

}