| | |
|---|
| | | .select("o.type as orderType") |
|---|
| | | .select("o.good_level as goodLevel") |
|---|
| | | .select("o.total_amount as totalAmount") |
|---|
| | | .select("o.pay_amount as payAmount") |
|---|
| | | .select("(o.pay_amount + ifnull(o.OVERDUE_AMOUNT,0)) as payAmount") |
|---|
| | | .select("c2.name as goodLevelName") |
|---|
| | | .innerJoin("orders o on o.id = t.ORDER_ID ") |
|---|
| | | .leftJoin("category c1 on c1.id = o.GOOD_TYPE and c1.DELETED = 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())); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
