| | |
| | | ROW_NUMBER() over (order by mo.create_time desc) as row, |
| | | mod.* |
| | | from man_order_detl_pakout mod |
| | | inner join man_order mo on mod.order_id = mo.id |
| | | inner join man_order_pakout mo on mod.order_id = mo.id |
| | | inner join man_doc_type mdt on mo.doc_type = mdt.doc_id |
| | | where 1=1 |
| | | and mo.settle <= 2 |
| | |
| | | select |
| | | count(1) |
| | | from man_order_detl_pakout mod |
| | | inner join man_order mo on mod.order_id = mo.id |
| | | inner join man_order_pakout mo on mod.order_id = mo.id |
| | | inner join man_doc_type mdt on mo.doc_type = mdt.doc_id |
| | | where 1=1 |
| | | and mo.settle <= 2 |
| | |
| | | |
| | | insTb = table.render({ |
| | | elem: '#originTable', |
| | | url: baseUrl + '/order/nav/list/auth', |
| | | url: baseUrl + '/pakout/order/nav/list/auth', |
| | | height: 'full-120', |
| | | headers: {token: localStorage.getItem('token')}, |
| | | request: { |