分页标签导航

POST

https://test.myusmile.online/bff/cloud/health/post/page/navigation

#he_post 帖子表
#he_post_tag 帖子标签关联表
#he_tag_config 标签配置表
#he_post_category_navigation 帖子分类导航关联表
#he_navigation 无级导航表

SELECT tag.post_id as '帖子ID',post.title as '帖子标题',tag.tag_config_id as '标签配置ID', con.tag_name as '标签名称',cate.navigation_id as '导航ID',avg.name as '导航名称' FROM he_post_tag as tag
INNER JOIN he_tag_config as con on con.id = tag.tag_config_id
INNER JOIN he_post_category_navigation as cate on tag.post_id = cate.post_id
INNER JOIN he_navigation as avg on avg.id =cate.navigation_id
INNER JOIN he_post as post on post.id = tag.post_id
#状态（1: 草稿, 2: 待审核, 3: 审核通过, 4: 审核不通过, 5: 已上架, 6: 已下架, 7: 已删除）'
where avg.id = 19 and post.status = 5 ORDER BY tag_config_id desc;

请求参数

Header 参数

TOK

string

可选

默认值:

Body 参数application/json

navigationId

integer

导航ID

可选

pageNum

integer

请求页数

可选

pageSize

integer

请求数量

可选

isRandom

boolean

是否随机排序

可选

tagId

integer

标签ID

可选

未传参默认为推荐模块

示例

{
  "navigationId":19,
  "pageNum": 1,
  "pageSize": 10,
  "userId":1,
  "isRandom": true
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://test.myusmile.online/bff/cloud/health/post/page/navigation' \
--header 'TOK: ' \
--header 'Content-Type: application/json' \
--data-raw '{
  "navigationId":19,
  "pageNum": 1,
  "pageSize": 10,
  "userId":1,
  "isRandom": true
}'

返回响应

🟢200成功

application/json

Body

object {0}

示例

{}

修改于 2025-02-05 08:02:08

根据导航查询标签

获取帖子详情