article_page_count.tpl 468 B

1234567891011121314
  1. -- Code generated by dol build. Only Generate by tools if not existed.
  2. -- 1. You must specify the appropriate field name, instead of the *, field can be referenced in sql/sqlmap/.xml.
  3. -- 2. You must load user information from the code level if you need, because the user information is present in another table.
  4. select
  5. count(*) records
  6. from
  7. article
  8. where
  9. article.id {{.ne}} ""
  10. and
  11. article.del_flag {{.ne}} 1
  12. {{if ne .role_rule ""}}
  13. and {{.role_rule}}
  14. {{end}}