1.花材统计报表：控制排序字段

陶杰

2024-12-19 0a8bc68140f77ab95c6569a266206b1d473ef49b

 src/main/java/com/mzl/flower/mapper/member/MemberGrowthRecordMapper.java

@@ -11,6 +11,7 @@
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.time.LocalDate;
import java.util.List;


@@ -32,4 +33,7 @@

    List<UserGrowthRecordVO> queryUserPage(@Param("dto") UserMemberRecordQueryDTO dto, Page page);

    @Select("SELECT * from t_member_growth_record WHERE user_id  = #{userId} and deleted = '0' and record_date = #{localDate} and type= 'reduce' and source = 'downgrading'")
    List<MemberGrowthRecordVO> selectDowngradingByUserId(@Param("userId") String userId, LocalDate localDate);

}