| | |
|---|
| | | .select("o.total_amount as totalAmount") |
|---|
| | | .select("o.pay_amount as payAmount") |
|---|
| | | .select("c2.name as goodLevelName") |
|---|
| | | .leftJoin("orders o on o.id = t.ORDER_ID and o.DELETED = 0") |
|---|
| | | .innerJoin("orders o on o.id = t.ORDER_ID ") |
|---|
| | | .leftJoin("category c1 on c1.id = o.GOOD_TYPE and c1.DELETED = 0") |
|---|
| | | .leftJoin("category c2 on c2.id = c1.RELATION_ID and c2.DELETED = 0 and c2.TYPE = 3") |
|---|
| | | .eq(OrdersRefund::getDeleted, 0); |
|---|
| | |
|---|
| | | wrapper.ge(OrdersRefund::getCreateTime, model.getCreateStartTime()); |
|---|
| | | } |
|---|
| | | if (model.getCreateEndTime() != null) { |
|---|
| | | wrapper.le(OrdersRefund::getCreateTime, model.getCreateEndTime()); |
|---|
| | | wrapper.le(OrdersRefund::getCreateTime, Utils.Date.getEnd(model.getCreateEndTime())); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
