拼接查询条件:
Wrapper<PO> wrapper = OrderWrappers.buildStatusGroupQuery(statusQuery);
public static LambdaQueryWrapper<PO> buildStatusGroupQuery(OrderQuery query) {
return Wrappers.<PO>lambdaQuery()
.eq(PO::getDr, 0)
.eq(StringUtils.hasText(query.getBusinessType()), PO::getBussinessType, query.getBusinessType())
.eq(Objects.nonNull(query.getType()), PO::getOrderType, query.getType())
.groupBy(PO::getStatus);
}
查询返回结果:
this.baseMapper.queryOrderListStatus(wrapper);
@ResultMap("listStatusCountMap")
@Select("select order_status,count(1) as order_count from odc_purchase_order_ps ${ew.customSqlSegment}")
List<PurchaseOrderStatusDTO> queryOrderListStatus(@Param(Constants.WRAPPER)Wrapper<PO> wrapper);