package com.hxzk.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzk.pojo.TbZypSpace;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 航锦化工受限空间安全作业证 Mapper 接口
 * </p>
 *
 * @author wangfei
 * @since 2024-04-22
 */
public interface TbZypSpaceMapper extends BaseMapper<TbZypSpace> {
//    @Select({"SELECT * FROM tb_fuwuqi WHERE none = 0  and company LIKE CONCAT('%', #{company}, '%') or servername LIKE CONCAT('%', #{servername}, '%')"})

    @Select({"select * from tb_zyp_space where code LIKE CONCAT('%', #{code}, '%') or applicant LIKE CONCAT('%', #{applicant}, '%') ORDER BY createtime DESC"})
    public List<TbZypSpace> findSearch(@Param("code") String code, @Param("applicant") String applicant);

}