From 1048f01c81cf90b8ceb4d8ad070a76d32ea00380 Mon Sep 17 00:00:00 2001 From: Administrator <15274802129@163.com> Date: Tue, 22 Jul 2025 12:05:02 +0800 Subject: [PATCH] fix:修复衣服社交 Mapper 中的点赞和收藏数量统计错误- 修改了 likeCntReal 和 collectCntReal 字段的查询方式- 使用 COUNT(DISTINCT(member_id)) 替代 COUNT(id)并去除 group by 语句- 这样可以正确统计每个衣服的点赞和收藏数量,而不是按用户分组计数 --- src/main/resources/templates/febs/views/modules/votesActivity/voteRecord.html | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/main/resources/templates/febs/views/modules/votesActivity/voteRecord.html b/src/main/resources/templates/febs/views/modules/votesActivity/voteRecord.html index 81de6bc..44c9be0 100644 --- a/src/main/resources/templates/febs/views/modules/votesActivity/voteRecord.html +++ b/src/main/resources/templates/febs/views/modules/votesActivity/voteRecord.html @@ -41,12 +41,12 @@ tableIns = febs.table.init({ elem: $view.find('table'), id: 'voteRecordTable', - url: ctx + 'admin/votesActivity/voteRecord?parentId=1', + url: ctx + 'admin/happyActivity/voteRecord?parentId=1', cols: [[ {field: 'memberName', title: '昵称', minWidth: 150,align:'center'}, {field: 'activityName', title: '活动', minWidth: 150,align:'center'}, {field: 'optionName', title: '选项', minWidth: 150,align:'center'}, - {field: 'voteTime', title: '投票时间', minWidth: 150,align:'center'} + {field: 'createdTime', title: '投票时间', minWidth: 150,align:'center'} ]] }); } -- Gitblit v1.9.1