mybatis-plus sum求和

获取合同包下所有合同的总金额之和

var contract_wrapper = QueryWrapper<GfCardEmployee>()
.eq("employee_id", employeeId);
.select("COALESCE(sum(percentage),0.00) as total");
.`in`("order_id",list)
var map = this.getMap(contract_wrapper)

var package_total_amount = map.get("total") as BigDecimal

return package_total_amount.toBigDecmil

版权声明:本文为qq_45677678原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。