- select
- count(*) records
- from
- sys_user_template_detail
- where
- {{if ne .del_flag ""}}
- sys_user_template_detail.del_flag = {{.del_flag}}
- {{else}}
- sys_user_template_detail.del_flag = 0
- {{end}}
- {{if ne .name ""}}
- and sys_user_template_detail.name like '%{{.name}}%'
- {{end}}
- {{if ne .temp_id ""}}
- and sys_user_template_detail.temp_id = '{{.temp_id}}'
- {{end}}
|