| | |
|---|
| | | @Repository |
|---|
| | | public interface MemberGrowthRecordMapper extends BaseMapper<MemberGrowthRecord> { |
|---|
| | | |
|---|
| | | @Select("SELECT CASE WHEN SUM(growth) < 0 THEN 0 ELSE SUM(growth) END as total_growth from t_member_growth_record WHERE user_id = #{userId} and deleted = '0'") |
|---|
| | | @Select("SELECT COALESCE(CASE WHEN SUM(growth) < 0 THEN 0 ELSE SUM(growth) END, 0) as total_growth from t_member_growth_record WHERE user_id = #{userId} and deleted = '0'") |
|---|
| | | Integer getSumGrowthByUsertId(@Param("userId") String userId); |
|---|
| | | |
|---|
| | | List<MemberGrowthRecordVO> queryPage(@Param("dto") MemberRecordQueryDTO dto, Page page); |
|---|
