package com.hxzkappboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzkappboot.pojo.TbUser;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserDao extends BaseMapper<TbUser> {
    @Select("select u.*,c.id as company from tb_user u LEFT JOIN tb_company c ON u.company=c.companyname where username = #{username}  and password = #{password}")
    public TbUser findUser(TbUser user);

    @Select("select * from tb_user where cid != 'null'  and cid != ''")
    public List<TbUser> findUserCid( );
}