| | |
|---|
| | | 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); |
|---|
| | | SmsTaskDetailVO getCountBySmsTaskId(@Param("id") Long id); |
|---|
| | | |
|---|
| | | @Select("select count(1) from t_sms_task_detail where sms_task_id =#{id} and deleted = '0'") |
|---|
| | | Integer getBySmsTaskId(@Param("id")Long id); |
|---|
| | | } |
|---|
