system_find_user_template_detail_page_count.tpl 366 B

12345678910111213141516
  1. select
  2. count(*) records
  3. from
  4. sys_user_template_detail
  5. where
  6. {{if ne .del_flag ""}}
  7. sys_user_template_detail.del_flag = {{.del_flag}}
  8. {{else}}
  9. sys_user_template_detail.del_flag = 0
  10. {{end}}
  11. {{if ne .name ""}}
  12. and sys_user_template_detail.name like '%{{.name}}%'
  13. {{end}}
  14. {{if ne .temp_id ""}}
  15. and sys_user_template_detail.temp_id = '{{.temp_id}}'
  16. {{end}}