| | |
| | | where 1=1 |
| | | <if test="callTaskResult.startTime!=null and callTaskResult.startTime!=''"> |
| | | and ct."scene_id" = 228 |
| | | and date_format(ctr."gmt_create",'%Y-%m-%d') >= #{callTaskResult.startTime} |
| | | and ctr."gmt_create" >= #{callTaskResult.startTime} |
| | | </if> |
| | | <if test="callTaskResult.endTime!=null and callTaskResult.endTime!=''"> |
| | | and date_format(ctr."gmt_create",'%Y-%m-%d') <= #{callTaskResult.endTime} |
| | | and ctr."gmt_create" <= #{callTaskResult.endTime} |
| | | </if> |
| | | <if test="list != null and list.size()>0"> |
| | | and ctr."task_id" in |