zhijiayun-pharmacy/zhijiayun-user/src/main/java/com/xuekairui/user/mapper/BusinessLicenseMapper.java

package com.xuekairui.user.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xuekairui.user.dto.BusinessLicenseReviewResponse;
import com.xuekairui.user.entity.BusinessLicense;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * 入驻信息Mapper
 */
@Mapper
public interface BusinessLicenseMapper extends BaseMapper<BusinessLicense> {

    /**
     * 查询用户的入驻信息
     */
    @Select("SELECT * FROM t_business_license WHERE user_id = #{userId} LIMIT 1")
    BusinessLicense selectByUserId(Long userId);

    /**
     * 审核列表查询（LEFT JOIN t_user，支持按审核状态筛选 + 手机号/联系电话关键词搜索）
     */
    @Select("<script>" +
            "SELECT bl.id, bl.store_name, bl.terminal_type, bl.province, bl.city, bl.district, " +
            "bl.store_address, bl.contact_person, bl.contact_phone, bl.credit_code, " +
            "bl.license_image_url, bl.drug_license_url, bl.medical_device_class2_url, bl.medical_device_class3_url, " +
            "bl.review_status, bl.reject_reason, bl.sync_source, bl.show_verified_badge, " +
            "bl.external_id, bl.status, " +
            "bl.reviewer_id, bl.review_time, bl.create_time, bl.update_time, " +
            "bl.user_id AS submitterUserId, " +
            "u.phone AS submitterPhone, u.nickname AS submitterNickname, u.user_name AS submitterUserName " +
            "FROM t_business_license bl LEFT JOIN t_user u ON bl.user_id = u.id " +
            "<where>" +
            "<if test='reviewStatus != null and reviewStatus != \"\"'>bl.review_status = #{reviewStatus}</if>" +
            "<if test='keyword != null and keyword != \"\"'>" +
            "AND (u.phone LIKE CONCAT('%', #{keyword}, '%') OR bl.contact_phone LIKE CONCAT('%', #{keyword}, '%'))" +
            "</if>" +
            "</where>" +
            "ORDER BY bl.create_time DESC" +
            "</script>")
    List<BusinessLicenseReviewResponse> selectReviewList(@Param("reviewStatus") String reviewStatus,
                                                         @Param("keyword") String keyword);
}