| | |
| | | return R.ok(orderService.selectAllorderNo()); |
| | | } |
| | | |
| | | @RequestMapping(value = "/order/list/AllCu") |
| | | @ManagerAuth |
| | | public R orderCuList(@RequestParam(required = false) String orderNo){ |
| | | EntityWrapper<Order> wrapper = new EntityWrapper<>(); |
| | | if (!Cools.isEmpty(orderNo)) { |
| | | wrapper.like("order_no", orderNo); |
| | | } |
| | | wrapper.le("settle", 2).eq("status", 1); |
| | | wrapper.orderBy("create_time", false); |
| | | List<Order> orders = orderService.selectList(wrapper); |
| | | // 保留出库单 |
| | | if (!Cools.isEmpty(orders)) { |
| | | Iterator<Order> iterator = orders.iterator(); |
| | | while (iterator.hasNext()) { |
| | | Order order = iterator.next(); |
| | | if (order.getDocType() != null) { |
| | | DocType docType = docTypeService.selectById(order.getDocType()); |
| | | if (docType != null) { |
| | | if (docType.getPakout() == 1) { |
| | | iterator.remove(); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | return R.ok().add(orders); |
| | | } |
| | | |
| | | //订单组托2 |
| | | @RequestMapping(value = "/order/list/orderNo") |
| | | public R orderListorderNo(@RequestParam String orderNo) { |
| | |
| | | enabled: false |
| | | datasource: |
| | | driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver |
| | | url: jdbc:sqlserver://10.10.10.100:1433;databasename=stasrs |
| | | #url: jdbc:sqlserver://127.0.0.1:1433;databasename=stasrs |
| | | #url: jdbc:sqlserver://10.10.10.100:1433;databasename=stasrs |
| | | url: jdbc:sqlserver://127.0.0.1:1433;databasename=stasrs |
| | | username: sa |
| | | password: sa@123 |
| | | mvc: |
| | |
| | | toolbar: '#toolbar', |
| | | cellMinWidth: 50, |
| | | cols: [[ |
| | | {type: 'checkbox'} |
| | | {type: 'checkbox',width: 50} |
| | | ,{field: 'locNo', align: 'center',title: '库位号'} |
| | | ,{field: 'locSts$', align: 'center',title: '库位状态', width: 180, style: 'color: #8E2323'} |
| | | // ,{field: 'whsType$', align: 'center',title: '库位类型'} |
| | |
| | | toolbar: '#toolbar', |
| | | cellMinWidth: 50, |
| | | cols: [[ |
| | | {type: 'checkbox'} |
| | | {type: 'checkbox',width: 50} |
| | | ,{field: 'wrkNo', align: 'center',title: '工作号',sort: true, width: 85} |
| | | ,{field: 'ioTime$', align: 'center',title: '工作时间',sort: true, width: 160} |
| | | ,{field: 'wrkSts$', align: 'center',title: '工作状态'} |
| | |
| | | var pageCurr; |
| | | function getCol() { |
| | | var cols = [ |
| | | {type: 'checkbox'} |
| | | {type: 'checkbox',width: 50} |
| | | ,{field: 'locNo', align: 'center',title: '货位'} |
| | | ]; |
| | | cols.push.apply(cols, detlCols); |
| | |
| | | <script> |
| | | function getCol() { |
| | | var cols = [ |
| | | {type: 'checkbox', fixed: 'left'} |
| | | {type: 'checkbox',width: 50, fixed: 'left'} |
| | | ]; |
| | | cols.push.apply(cols, matCols); |
| | | cols.push( |
| | |
| | | <script> |
| | | function getCol() { |
| | | var cols = [ |
| | | {type: 'checkbox', fixed: 'left'} |
| | | {type: 'checkbox',width: 50, fixed: 'left'} |
| | | |
| | | |
| | | ]; |
| | |
| | | |
| | | function getCol() { |
| | | let cols = [ |
| | | {type: 'checkbox', merge: ['locNo']} |
| | | {type: 'checkbox',width: 50, merge: ['locNo']} |
| | | ,{field: 'locNo', align: 'center',title: '库位号', merge: true, style: 'font-weight: bold'} |
| | | ]; |
| | | cols.push.apply(cols, detlCols); |
| | |
| | | |
| | | function getCol() { |
| | | var cols = [ |
| | | {type: 'checkbox', merge: ['locNo']} |
| | | {type: 'checkbox',width: 50, merge: ['locNo']} |
| | | ,{field: 'locNo', align: 'center',title: '库位号', merge: true, style: 'font-weight: bold'} |
| | | // ,{field: 'locNo$', align: 'center',title: '库位号'} |
| | | ]; |
| | |
| | | <script> |
| | | function getCol() { |
| | | let cols = [ |
| | | {type: 'checkbox', fixed: 'left'} |
| | | {type: 'checkbox',width: 50, fixed: 'left'} |
| | | ]; |
| | | cols.push.apply(cols, matCols); |
| | | cols.push( |
| | |
| | | |
| | | function getCol() { |
| | | var cols = [ |
| | | {type: 'checkbox'} |
| | | {type: 'checkbox',width: 50} |
| | | ,{field: 'locNo$', align: 'center',title: '库位号'} |
| | | ]; |
| | | cols.push.apply(cols, detlCols); |
| | |
| | | toolbar: '#toolbar', |
| | | cellMinWidth: 50, |
| | | cols: [[ |
| | | {type: 'checkbox'} |
| | | {type: 'checkbox',width: 50} |
| | | ,{field: 'matnr', align: 'center',title: '商品编号', sort:true} |
| | | ,{field: 'maktx', align: 'center',title: '商品名称', sort:true} |
| | | ,{field: 'loc_no', align: 'center',title: '库位号', sort:true} |
| | |
| | | |
| | | function getCol() { |
| | | var cols = [ |
| | | {type: 'checkbox'} |
| | | {type: 'checkbox',width: 50} |
| | | ,{field: 'loc_no', align: 'center',title: '库位号'} |
| | | ]; |
| | | cols.push.apply(cols, detlCols); |
| | |
| | | limit: 500, |
| | | cellMinWidth: 50, |
| | | cols: [[ |
| | | {type: 'checkbox', fixed: 'left', width:30}, |
| | | {type: 'checkbox', fixed: 'left', width:50}, |
| | | {field: 'count', align: 'center', title: '数量', event: 'detail', style:'color: blue', width:50}, |
| | | {field: 'matnr', align: 'center', title: '编码', event: 'detail'}, |
| | | {field: 'maktx', align: 'center', title: '名称', event: 'detail'}, |
| | |
| | | pidName: 'resourceId' // pid字段名称 |
| | | }, |
| | | cols: [[ |
| | | {type: 'checkbox', fixed: 'left'} |
| | | {type: 'checkbox',width: 50, fixed: 'left'} |
| | | ,{field: 'id', title: 'ID', sort: true,align: 'center', fixed: 'left', width: 80, hide: true} |
| | | ,{field: 'name', align: 'left',title: '菜单名称'} |
| | | ,{field: 'code', align: 'center',title: '菜单编码'} |
| | |
| | | <script> |
| | | function getCol() { |
| | | var cols = [ |
| | | {type: 'checkbox', fixed: 'left'} |
| | | {type: 'checkbox',width: 50, fixed: 'left'} |
| | | ]; |
| | | cols.push.apply(cols, matCols); |
| | | cols.push( |
| | |
| | | pidName: 'parentId' // pid字段名称 |
| | | }, |
| | | cols: [[ |
| | | {type: 'checkbox'} |
| | | {type: 'checkbox',width: 50} |
| | | ,{type: 'numbers'} |
| | | ,{field: 'name', align: 'left',title: '名称', minWidth: 150} |
| | | // ,{field: 'uuid', align: 'center',title: '编号'} |