| | |
| | | * 备用1 |
| | | */ |
| | | @ApiModelProperty(value= "备用1") |
| | | private String standby1 = "1"; |
| | | private String standby1 ; |
| | | |
| | | /** |
| | | * 备用2 |
| | | */ |
| | | @ApiModelProperty(value= "备用2") |
| | | private String standby2 = "1"; |
| | | private String standby2 ; |
| | | |
| | | /** |
| | | * 备用3 |
| | | */ |
| | | @ApiModelProperty(value= "备用3") |
| | | private String standby3 = "1"; |
| | | private String standby3 ; |
| | | |
| | | /** |
| | | * 备用1 |
| | | */ |
| | | @ApiModelProperty(value= "备用1") |
| | | @TableField("box_type1") |
| | | private String boxType1 = "1"; |
| | | private String boxType1 ; |
| | | |
| | | /** |
| | | * 备用2 |
| | | */ |
| | | @ApiModelProperty(value= "备用2") |
| | | @TableField("box_type2") |
| | | private String boxType2 = "1"; |
| | | private String boxType2 ; |
| | | |
| | | /** |
| | | * 备用3 |
| | | */ |
| | | @ApiModelProperty(value= "备用3") |
| | | @TableField("box_type3") |
| | | private String boxType3 = "1"; |
| | | private String boxType3 ; |
| | | |
| | | public String getBeBatch$(){ |
| | | if (null == this.beBatch){ return null; } |
| | |
| | | a.batch, |
| | | a.standby1, |
| | | a.standby2, |
| | | a.standby3, |
| | | MAX(a.box_type3) AS box_type3, |
| | | SUM(a.anfme) AS anfme |
| | | FROM asr_loc_detl a |
| | |
| | | a.batch, |
| | | a.standby1, |
| | | a.standby2, |
| | | a.standby3, |
| | | a.box_type3 |
| | | ORDER BY SUM(a.anfme) DESC |
| | | </select> |
| | |
| | | // ,{field: 'height', align: 'center',title: '高(毫米)', hide: false} |
| | | // ,{field: 'threeCode', align: 'center',title: '箱子尺寸', hide: true} |
| | | ,{field: 'standby1', align: 'center',title: '客户po', hide: false} |
| | | ,{field: 'standby3', align: 'center',title: '客户sku', hide: false} |
| | | |
| | | ,{field: 'suppCode', align: 'center',title: '供应商编码', hide: true} |
| | | // ,{field: 'beBatch$', align: 'center',title: '是否批次', hide: true} |
| | | // ,{field: 'deadTime', align: 'center',title: '保质期', hide: true} |
| | |
| | | success: function (res) { |
| | | layer.closeAll(); |
| | | if (res.code === 200 && res.data && res.data.length > 0) { |
| | | var titles = ['库存数量', '商品编号', '备注', '采购单号', '条码UPC', '单箱毛重(kg)', '客户PO']; |
| | | var fieldKeys = ['anfme', 'matnr', 'memo', 'boxType3', 'standby2', 'units', 'standby1']; |
| | | var titles = ['库存数量', '商品编号', '备注', '采购单号', '条码UPC', '单箱毛重(kg)', '客户PO','客户sku']; |
| | | var fieldKeys = ['anfme', 'matnr', 'memo', 'boxType3', 'standby2', 'units', 'standby1','standby3']; |
| | | |
| | | var exportData = res.data.map(function(item) { |
| | | return [ |
| | |
| | | item.boxType3 || '', |
| | | item.standby2 || '', |
| | | item.units || '', |
| | | item.standby1 || '' // 如字段是 order_no 改成 item.order_no |
| | | item.standby1 || '', // 如字段是 order_no 改成 item.order_no |
| | | item.standby3 || '' |
| | | ]; |
| | | }); |
| | | |
| | |
| | | height: 'full-120', |
| | | cols: [[ |
| | | {field: 'matnr', title: '商品编号', width: 160}, |
| | | {field: 'orderNo', title: '单据编号', width: 160}, |
| | | {field: 'maktx', title: '名称', width: 160}, |
| | | {field: 'standby3', title: '客户SKU'}, |
| | | {field: 'boxType1', title: '货主'}, |
| | |
| | | <div id="search-box" class="layui-form layui-card-header"> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="matnr" placeholder="SKU" autocomplete="off"> |
| | | <input class="layui-input" type="text" name="standby3" placeholder="SKU" autocomplete="off"> |
| | | </div> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="boxType3" placeholder="采购单号" autocomplete="off"> |