| | |
| | | wrapper.orderBy("create_time",false); |
| | | return R.ok(basArmMastService.selectPage(new Page<>(curr, limit), wrapper)); |
| | | } |
| | | @RequestMapping(value = "/basArmMast/listArm/auth") |
| | | @ManagerAuth |
| | | public R listArm(@RequestParam(defaultValue = "1") Integer curr, |
| | | @RequestParam(defaultValue = "10") Integer limit, |
| | | @RequestParam(required = false) String orderByField, |
| | | @RequestParam(required = false) String orderByType, |
| | | @RequestParam(required = false) String condition, |
| | | @RequestParam Map<String, Object> param) { |
| | | EntityWrapper<BasArmMast> wrapper = new EntityWrapper<>(); |
| | | excludeTrash(param); |
| | | convert(param, wrapper); |
| | | allLike(BasArmMast.class, param.keySet(), wrapper, condition); |
| | | |
| | | if (!Cools.isEmpty(orderByField)) { |
| | | wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType)); |
| | | } |
| | | wrapper.orderBy("create_time", false); |
| | | |
| | | // 如果不需要分页,使用 selectList() 获取所有数据 |
| | | List<BasArmMast> allData = basArmMastService.selectList(wrapper); |
| | | |
| | | return R.ok(allData); // 直接返回所有数据 |
| | | } |
| | | |
| | | |
| | | private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){ |
| | | for (Map.Entry<String, Object> entry : map.entrySet()){ |
| | |
| | | path = imPurreceiveBillAddress; |
| | | break; |
| | | case "OUI_RECEIVEBIll"://委外入库单 |
| | | jsonObject.put("billstatus", Arrays.asList("A"));//数据状态 [A:暂存, B:已提交, C:已审核] |
| | | jsonObject.put("billstatus", Arrays.asList("C"));//数据状态 [A:暂存, B:已提交, C:已审核] |
| | | jsonObject.put("auditdate_start", latestUpdateTime); |
| | | jsonObject.put("auditdate_end", sdf1.format(now)); |
| | | path = omOutsourcereceiptQuery; |
| | | break; |
| | | case "SAL_OUTSTOCK"://销售出库单查询 |
| | | path = imSaloutbill; |
| | | jsonObject.put("modify_starttime", latestUpdateTime);//业务起始日期 |
| | |
| | | */ |
| | | public class HttpHandler { |
| | | |
| | | private static final Integer DEFAULT_TIMEOUT_SECONDS = 5; |
| | | private static final Integer DEFAULT_TIMEOUT_SECONDS = 10; |
| | | private static final MediaType MEDIA_TYPE = MediaType.parse("application/json;charset=utf-8"); |
| | | |
| | | private String uri; |
| | |
| | | tableIns = table.render({ |
| | | elem: '#basArmMastExp', |
| | | headers: {token: localStorage.getItem('token')}, |
| | | url: baseUrl+'/basArmMast/list/auth', |
| | | url: baseUrl+'/basArmMast/listArm/auth', |
| | | page: true, |
| | | limit: 15, |
| | | limits: [15, 30, 50, 100, 200, 500], |
| | |
| | | {field: 'matnr', align: 'center', title: '商品编号'}, |
| | | {field: 'po', align: 'center', title: 'PO'}, |
| | | {field: 'upc', align: 'center', title: 'UPC'}, |
| | | {field: 'sortingLine', align: 'center', title: '起点'}, |
| | | {field: 'staNo', align: 'center', title: '起点'}, |
| | | {field: 'status', align: 'center', title: '作业状态', templet: function(d){ |
| | | return '2.单码完成等待托盘完成'; // 因为现在只显示状态2,固定显示 |
| | | }}, |
| | |
| | | }; |
| | | } |
| | | |
| | | var records = res.data.records || []; |
| | | var records = res.data || []; |
| | | var groupMap = new Map(); // 用来汇总状态为2的数据 |
| | | |
| | | records.forEach(function(item) { |
| | | // 只处理状态为2的记录,其他状态直接忽略(隐藏) |
| | | |
| | | if (String(item.status) === '2') { |
| | | // 生成唯一标识(5个字段组合) |
| | | var key = [ |
| | | item.armNo || '', |
| | | item.sortingLine || '', |
| | | item.staNo || '', |
| | | item.barcode || '', |
| | | item.matnr || '', |
| | | item.orderNo || '' |
| | |
| | | matnr: item.matnr, |
| | | po: item.po || '', |
| | | upc: item.upc || '', |
| | | sortingLine: item.sortingLine, |
| | | staNo: item.staNo, |
| | | barcode: item.barcode, |
| | | supplier: item.supplier || '', |
| | | status: '2', // 固定显示为2 |
| | |
| | | // ,{field: 'unit', align: 'center',title: '单位', hide: true} |
| | | // ,{field: 'price', align: 'center',title: '单价', hide: true} |
| | | ,{field: 'standby2', align: 'center',title: '条码upc', hide: false} |
| | | ,{field: 'units', align: 'center',title: '单箱毛重kg', hide: true} |
| | | ,{field: 'units', align: 'center',title: '单箱毛重kg', hide: false} |
| | | // ,{field: 'barcode', align: 'center',title: '条码', hide: true} |
| | | // ,{field: 'origin', align: 'center',title: '在库标记', hide: true} |
| | | ,{field: 'manu', align: 'center',title: '仓库编码', hide: true} |
| | | // ,{field: 'manuDate', align: 'center',title: '生产日期', hide: true} |
| | | // ,{field: 'safeQty', align: 'center',title: '总件数', hide: true} |
| | | ,{field: 'weight', align: 'center',title: '单箱净重kg', hide: false} |
| | | ,{field: 'weight', align: 'center',title: '单箱净重kg', hide: true} |
| | | // ,{field: 'manLength', align: 'center',title: '长(毫米)', hide: false} |
| | | // ,{field: 'width', align: 'center',title: '宽(毫米)', hide: false} |
| | | // ,{field: 'height', align: 'center',title: '高(毫米)', hide: false} |
| | |
| | | success: function (res) { |
| | | layer.closeAll(); |
| | | if (res.code === 200 && res.data && res.data.length > 0) { |
| | | var titles = ['库存数量', '商品编号', '商品名称', '采购单号', '条码UPC', '单箱净重(kg)', '客户PO']; |
| | | var fieldKeys = ['anfme', 'matnr', 'maktx', 'boxType3', 'standby2', 'weight', 'standby1']; |
| | | var titles = ['库存数量', '商品编号', '商品名称', '采购单号', '条码UPC', '单箱毛重(kg)', '客户PO']; |
| | | var fieldKeys = ['anfme', 'matnr', 'maktx', 'boxType3', 'standby2', 'units', 'standby1']; |
| | | |
| | | var exportData = res.data.map(function(item) { |
| | | return [ |
| | |
| | | item.maktx || '', // 如果 maktx 为空可默认 |
| | | item.boxType3 || '', |
| | | item.standby2 || '', |
| | | item.weight || '', |
| | | item.units || '', |
| | | item.standby1 || '' // 如字段是 order_no 改成 item.order_no |
| | | ]; |
| | | }); |