From 973f5b74551ca31cf275d448956b3f2642a9f372 Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Tue, 22 Jul 2025 11:47:05 +0800 Subject: [PATCH] feat(mall): 衣物社交列表增加点赞和收藏功能 --- src/main/java/cc/mrbird/febs/mall/vo/clothes/AdminClothesSocialListVo.java | 4 ++++ src/main/resources/templates/febs/views/modules/clothesType/socialList.html | 32 ++++++++++++++++++++++---------- src/main/resources/mapper/modules/ClothesSocialMapper.xml | 4 ++++ 3 files changed, 30 insertions(+), 10 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/vo/clothes/AdminClothesSocialListVo.java b/src/main/java/cc/mrbird/febs/mall/vo/clothes/AdminClothesSocialListVo.java index 22bf8df..6ee7a50 100644 --- a/src/main/java/cc/mrbird/febs/mall/vo/clothes/AdminClothesSocialListVo.java +++ b/src/main/java/cc/mrbird/febs/mall/vo/clothes/AdminClothesSocialListVo.java @@ -8,6 +8,10 @@ private String name; private String socialTitle; private Integer socialState; + private Integer likeCnt; + private Integer collectCnt; + private Integer likeCntReal; + private Integer collectCntReal; private Integer commentState; private Integer hotState; diff --git a/src/main/resources/mapper/modules/ClothesSocialMapper.xml b/src/main/resources/mapper/modules/ClothesSocialMapper.xml index f6f5228..9ae3cd6 100644 --- a/src/main/resources/mapper/modules/ClothesSocialMapper.xml +++ b/src/main/resources/mapper/modules/ClothesSocialMapper.xml @@ -10,6 +10,10 @@ a.del_flag as delFlag, a.hot_state as hotState, a.comment_state as commentState, + a.like_cnt as likeCnt, + a.collect_cnt as collectCnt, + (select count(id) from clothes_social_follow where source_type = 1 and a.id = source_id and type = 1 group by member_id) as likeCntReal, + (select count(id) from clothes_social_follow where source_type = 1 and a.id = source_id and type = 2 group by member_id) as collectCntReal, a.state as socialState from clothes_social a left join mall_member b on a.member_id = b.id diff --git a/src/main/resources/templates/febs/views/modules/clothesType/socialList.html b/src/main/resources/templates/febs/views/modules/clothesType/socialList.html index a7f124b..c40ad9e 100644 --- a/src/main/resources/templates/febs/views/modules/clothesType/socialList.html +++ b/src/main/resources/templates/febs/views/modules/clothesType/socialList.html @@ -255,16 +255,28 @@ url: ctx + 'admin/clothesType/socialList', toolbar:"#scToolbar", defaultToolbar:[], - cols: [[ - {type: 'numbers', title: '', width: 80}, - {title: '操作', toolbar: '#activityOption', minWidth: 400, align: 'center'}, - {field: 'name', title: '发布人', minWidth: 150,align:'left'}, - {field: 'socialTitle', title: '标题', minWidth: 150,align:'left'}, - {field: 'commentState', title: '允许评论', templet: '#commentStateSwitch', minWidth: 130,align:'center'}, - {field: 'socialState', title: '状态', templet: '#scStateSwitch', minWidth: 130,align:'center'}, - {field: 'hotState', title: '显示首页', templet: '#scHotStateSwitch', minWidth: 130,align:'center'}, - {templet:"#socialDelFlagFormat", title: '是否删除', minWidth: 140,align:'left'}, - ]] + cols: + [ + [ + {type: 'numbers', title: '序号', rowspan: 2, width: 80}, + {title: '操作', toolbar: '#activityOption', minWidth: 400, rowspan: 2,align: 'center'}, + {field: 'name', title: '发布人', minWidth: 150,rowspan: 2,align:'center'}, + {field: 'socialTitle', title: '标题', minWidth: 150,rowspan: 2,align:'center'}, + {align: 'center', title: '点赞', colspan: 2}, + {align: 'center', title: '收藏', colspan: 2}, + {field: 'commentState', title: '允许评论', templet: '#commentStateSwitch', minWidth: 130,rowspan: 2,align:'center'}, + {field: 'socialState', title: '状态', templet: '#scStateSwitch', minWidth: 130,rowspan: 2,align:'center'}, + {field: 'hotState', title: '显示首页', templet: '#scHotStateSwitch', minWidth: 130,rowspan: 2,align:'center'}, + {templet:"#socialDelFlagFormat", title: '是否删除', minWidth: 140,rowspan: 2,align:'center'}, + {align: 'center', title: '', colspan: 4}, + ], + [ + {field: 'likeCnt', title: '点赞', minWidth: 150,align:'center'}, + {field: 'likeCntReal', title: '点赞数量', minWidth: 150,align:'center'}, + {field: 'collectCnt', title: '收藏', minWidth: 150,align:'center'}, + {field: 'collectCntReal', title: '收藏数量', minWidth: 150,align:'center'}, + ] + ] }); } -- Gitblit v1.9.1