| 1234567891011121314151617 |
- select
- sys_user_template_detail.*
- 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}}
- LIMIT {{.rows}} OFFSET {{.offset}}
|
