| | |
| | | //今日补贴 |
| | | BigDecimal todayAmount = this.baseMapper.selectTodayAmountByCreateTimeAndMemberId(yyyyMMddToday,member.getId()); |
| | | apiMallSubsidyAmountInfoVo.setTodayAmount(todayAmount); |
| | | //今日累计接单 |
| | | Integer todayTotalCnt = this.baseMapper.selectCountByCreateTimeAndMemberId(yyyyMMddToday,member.getId()); |
| | | //累计接单 |
| | | Integer todayTotalCnt = this.baseMapper.selectCountByCreateTimeAndMemberId(null,member.getId()); |
| | | apiMallSubsidyAmountInfoVo.setTodayTotalCnt(todayTotalCnt); |
| | | //昨日补贴 |
| | | BigDecimal yesterdayAmount = this.baseMapper.selectTodayAmountByCreateTimeAndMemberId(yyyyMMddYesterday,member.getId()); |
| | |
| | | @ApiModelProperty(value = "今日补贴") |
| | | private BigDecimal todayAmount = BigDecimal.ZERO; |
| | | |
| | | @ApiModelProperty(value = "今日累计接单") |
| | | @ApiModelProperty(value = "累计接单") |
| | | private Integer todayTotalCnt = 0; |
| | | |
| | | @ApiModelProperty(value = "昨日补贴") |
| | |
| | | count(a.id) |
| | | from mall_order_info a |
| | | where |
| | | a.status <![CDATA[>= ]]> 4 |
| | | a.status = 4 |
| | | and a.member_id = #{memberId} |
| | | <if test="createdTime != null"> |
| | | and date_format(a.CREATED_TIME, '%Y-%m-%d') = #{createdTime} |
| | |
| | | ifnull(sum(a.subsidy_amount),0) |
| | | from mall_order_info a |
| | | where |
| | | a.status <![CDATA[>= ]]> 4 |
| | | a.status = 4 |
| | | and a.member_id = #{memberId} |
| | | <if test="createdTime != null"> |
| | | and date_format(a.CREATED_TIME, '%Y-%m-%d') = #{createdTime} |