package com.mzl.flower.mapper;
|
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.mzl.flower.dto.request.sms.SmsTaskDetailQueryDTO;
|
import com.mzl.flower.dto.request.sms.SmsTaskQueryDTO;
|
import com.mzl.flower.dto.response.sms.SmsPhoneResultVO;
|
import com.mzl.flower.dto.response.sms.SmsTaskDetailVO;
|
import com.mzl.flower.entity.SmsTaskDetailDO;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* <p>
|
* Mapper 接口
|
* </p>
|
*
|
* @author @TaoJie
|
* @since 2024-12-25
|
*/
|
public interface SmsTaskDetailMapper extends BaseMapper<SmsTaskDetailDO> {
|
|
List<SmsPhoneResultVO> queryPage(@Param("dto") SmsTaskDetailQueryDTO dto, Page page);
|
|
|
@Select("SELECT\n" +
|
"\tt.id,\n" +
|
"\tt.NAME AS smsTaskName ,\n" +
|
"\tt.num as totalNum,\n" +
|
"\tst.`name` as smsTemplateName\n" +
|
"FROM\n" +
|
"\tt_sms_task t\n" +
|
"\tLEFT JOIN t_sms_template st ON t.sms_template_id = st.id\n" +
|
"\tleft join t_sms_task_detail std ON t.id = std.sms_task_id")
|
SmsTaskDetailVO getCountBySmsTaskId(Long id);
|
}
|
