文件上传服务器地址

KKSU

2024-02-19 4aad16fd01bed0070570bc2e4bf10e812a489976

文件上传服务器地址

 src/main/java/cc/mrbird/febs/mall/mapper/MallProductBuyMapper.java

@@ -12,6 +12,7 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

public interface MallProductBuyMapper extends BaseMapper<MallProductBuy> {
@@ -33,4 +34,7 @@
    IPage<ApiOrderSellVo> selectSellListInPage(IPage<ApiOrderSellVo> page, @Param("record")ApiOrderSellDto apiOrderBuyDto);

    List<MallProductBuy> selectTotalPerk();

    BigDecimal selectTotalPerkByMemberId(@Param("memberId")Long id);

}

 src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallMemberServiceImpl.java

@@ -311,6 +311,9 @@

        Integer pickCount = mallProductBuyMapper.selectListByMemberIdAndState(id);
        mallMemberVo.setPickCount(pickCount);

        BigDecimal totalPerk = mallProductBuyMapper.selectTotalPerkByMemberId(mallMember.getId());
        mallMemberVo.setTotalPerk(totalPerk);
        return new FebsResponse().success().data(mallMemberVo);
    }


 src/main/java/cc/mrbird/febs/mall/vo/MallMemberVo.java

@@ -108,4 +108,7 @@
    @ApiModelProperty(value = "支付后，确认倒计时的分钟数，60，为paytime开始计算60分钟的倒计时")
    private Integer minuteCnt;

    @ApiModelProperty(value = "收益总额")
    private BigDecimal totalPerk;

}

 src/main/resources/mapper/modules/MallProductBuyMapper.xml

@@ -68,4 +68,9 @@
        GROUP BY member_id;
    </select>

    <select id="selectTotalPerkByMemberId" resultType="java.math.BigDecimal">
        select SUM(total_perk) from mall_product_buy
        where state = 3 and member_id = #{memberId}
    </select>

</mapper>