From 89cd02c7d636340cf7b4b66cb16b3b070b0c76c2 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Thu, 08 Sep 2022 10:18:10 +0800 Subject: [PATCH] 20220902 --- src/main/resources/mapper/modules/MallMemberMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/resources/mapper/modules/MallMemberMapper.xml b/src/main/resources/mapper/modules/MallMemberMapper.xml index 8e99b75..060eb78 100644 --- a/src/main/resources/mapper/modules/MallMemberMapper.xml +++ b/src/main/resources/mapper/modules/MallMemberMapper.xml @@ -347,7 +347,7 @@ inner join mall_member b on a.member_id=b.ID where 1=1 <!-- 月 --> - <if test="record.query == '2'"> + <if test="record.query == 2"> and date_format(#{record.createdTime},'%Y-%m') = date_format(a.achieve_time,'%Y-%m') </if> group by b.referrer_id -- Gitblit v1.9.1