| | |
| | | WHEN order_state = 2 THEN "已支付" |
| | | END) AS orderStateName |
| | | FROM se_vc_recharge |
| | | <where> |
| | | <if test = "orderState != null"> |
| | | order_state = #{orderState,jdbcType=TINYINT} |
| | | </if> |
| | | </where> |
| | | where order_state = 2 |
| | | order by recharge_time DESC |
| | | <if test="pageCurr != null and pageSize != null"> |
| | | LIMIT ${(pageCurr-1)*pageSize}, ${pageSize} |
| | |
| | | SELECT |
| | | COUNT(*) |
| | | FROM se_vc_recharge |
| | | <where> |
| | | <if test = "orderState != null"> |
| | | order_state = #{orderState,jdbcType=TINYINT} |
| | | </if> |
| | | </where> |
| | | where order_state = 2 |
| | | </select> |
| | | </mapper> |
| | |
| | | */ |
| | | @GetMapping(path = "/getVcRechargeRecords") |
| | | @SsoAop() |
| | | public BaseResponse<QueryResultVo<List<VoVcRecharge>>> getVcRechargeRecords(@RequestBody DtoVcRecharge dtoVcRecharge){ |
| | | public BaseResponse<QueryResultVo<List<VoVcRecharge>>> getVcRechargeRecords(DtoVcRecharge dtoVcRecharge){ |
| | | try { |
| | | QueryResultVo<List<VoVcRecharge>> res = virtualCardSv.getVcRechargeRecords(dtoVcRecharge); |
| | | return BaseResponseUtils.buildSuccess(res); |
| | |
| | | * @Description |
| | | */ |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @ToString(callSuper = true) |
| | | @NoArgsConstructor |
| | | @AllArgsConstructor |
| | | @Builder |
| | | @Schema(name = "虚拟卡充值记录查询条件") |
| | | public class DtoVcRecharge extends QueryConditionVo { |
| | | |
| | | @Schema(description = "订单状态", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | @Length(message = "订单状态不大于{max},不小于{min}", min = 1, max = 2) |
| | | private Byte orderState; |
| | | // @Schema(description = "订单状态", requiredMode = Schema.RequiredMode.NOT_REQUIRED) |
| | | // @Length(message = "订单状态不大于{max},不小于{min}", min = 1, max = 2) |
| | | // private Byte orderState; |
| | | } |