package org.ta.pddserver.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.ta.pdd.entity.ExpMailLogsEntity;

import java.util.List;

@Mapper
public interface ExpMailLogsMapper extends BaseMapper<ExpMailLogsEntity> {


    @Select("SELECT a.`created`, a.`status`, b.`name` AS `operator` FROM `exp_mail_logs` a, `user` b  WHERE a.`mailNo` = #{mailNo} AND a.`operator` = b.`account` ;")
    List<ExpMailLogsEntity> findListByMailNo(@Param("mailNo") String mailNo);
}
