package com.yxproject.start.mapper;

import com.yxproject.start.entity.PersonPostAbnormalEntity;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Component;

import java.util.List;

/**
 * @author Administrator
 */
@Mapper
public interface PersonPostAbnormalMapper {

    /**
     * 查询某个派出所某天的有错误的邮寄信息
     * @param date
     * @param police
     * @return
     */
    @Select("select * from PERSON_POST_ABNORMAL where FIRST_WHITE in (select UPLOAD_NO from CARD_DETAILED_LIST where POLICE_CODE=#{police} and UPLOAD_NO like CONCAT(CONCAT('%',#{date}),'%'))")
    public List<PersonPostAbnormalEntity> selectPersonPostAbnormalMsg(@Param("police")String police,@Param("date")String date);
}
