| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | @GetMapping("/page") |
|---|
| | | @ApiOperation(value = "分页", notes = "分页") |
|---|
| | | @ApiOperation(value = "我的关注用户分页", notes = "我的关注用户分页") |
|---|
| | | public Result page(MySubscribeQuery query) { |
|---|
| | | return mySubscribeService.page(query); |
|---|
| | | } |
|---|
| | |
|---|
| | | <result column="video_file_key" property="videoFileKey" /> |
|---|
| | | <result column="video_fit" property="videoFit" /> |
|---|
| | | <result column="title" property="title" /> |
|---|
| | | <result column="goods_id" property="goodsId" /> |
|---|
| | | <result column="goods_view_num" property="goodsViewNum" /> |
|---|
| | | <result column="video_duration" property="videoDuration" /> |
|---|
| | | <result column="goods_order_num" property="goodsOrderNum" /> |
|---|
| | | <result column="recommend" property="recommend" /> |
|---|
| | | <result column="status" property="status" /> |
|---|
| | | <result column="play_num" property="playNum" /> |
|---|
| | |
|---|
| | | LMS.subscribe_user_id, |
|---|
| | | LMS.id, |
|---|
| | | LM.nick_name, |
|---|
| | | LM.face, |
|---|
| | | (SELECT COUNT(*) FROM lmk_my_subscribe WHERE subscribe_user_id = LMS.subscribe_user_id AND delete_flag = 0) as fans_num |
|---|
| | | LM.face |
|---|
| | | FROM |
|---|
| | | lmk_my_subscribe LMS |
|---|
| | | LEFT JOIN li_member LM ON LMS.subscribe_user_id = LM.id |
|---|
