1、
QueryWrapper<Order> queryWrapper = new QueryWrapper<Order>();
queryWrapper.select("ifnull(sum(amount_total),0) as sumAll");
Order ord= orderService.getOne(queryWrapper);
//取值
ord.getSumAll()
2、
QueryWrapper<SbhPlatOrder> queryWrapper = new QueryWrapper<>();
queryWrapper.select("sum(amt) as total ");
queryWrapper.between("order_end_time", merPlatOrderRequest.getStartTime(),merPlatOrderRequest.getEndTime());
Map<String, Object> count = sbhPlatOrderManager.getMap(queryWrapper);
if (count==null){
return Result.success(0L);
}
Double total = Double.valueOf(String.valueOf(count.get("total")));
return Result.success(total.longValue());
3、
return this.getMap(new QueryWrapper<LevyPromoteDetail>()
.select("service_id serviceId,separate_state separateState,count(1) countSum,sum(pay_success_amt) payAmount")
.eq("settle_number", settleNumber)
.eq("service_id", enterpriseProviderDTO.getProviderId())
.groupBy("service_id, separate_state"));
4、***☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆
QueryWrapper<SbhPlatOrder> queryWrapper = Wrappers.query();
queryWrapper.lambda()
.ge(SbhPlatOrder::getCreateTime, new Date())
.lt(SbhPlatOrder::getCreateTime, new Date())
.groupBy(SbhPlatOrder::getProduct, SbhPlatOrder::getEnterpriseId, SbhPlatOrder::getLevyId);
queryWrapper.lambda().select(SbhPlatOrder::getEnterpriseId, SbhPlatOrder::getProduct);
String columns= queryWrapper.getSqlSelect()+",sum(IFNULL(suc_amt,0))";
queryWrapper.select(columns);
List<SbhPlatOrder> list = sbhPlatOrderManager.list(queryWrapper);