| | |
|---|
| | | |
|---|
| | | @Transactional(readOnly = true) |
|---|
| | | public PageResult<Map<String, Object>> news(int page, int size) { |
|---|
| | | return page(""" |
|---|
| | | select id, title, summary, cover_url, source, view_count, is_top, publish_time |
|---|
| | | PageResult<Map<String, Object>> result = page(""" |
|---|
| | | select id, title, summary, cover_url, source, content, view_count, is_top, publish_time |
|---|
| | | from news_article |
|---|
| | | where deleted = 0 and status = 1 |
|---|
| | | order by is_top desc, sort_no desc, publish_time desc, id desc |
|---|
| | | """, "select count(*) from news_article where deleted = 0 and status = 1", page, size); |
|---|
| | | List<Map<String, Object>> records = result.records().stream().map(row -> { |
|---|
| | | Map<String, Object> item = new LinkedHashMap<>(row); |
|---|
| | | item.put("contentPreview", htmlToText((String) item.get("content"))); |
|---|
| | | item.remove("content"); |
|---|
| | | return item; |
|---|
| | | }).toList(); |
|---|
| | | return new PageResult<>(records, result.page(), result.size(), result.total()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Transactional |
|---|
