| | |
| | | @TableField("temp1") |
| | | |
| | | private String temp1; |
| | | @TableField("temp2") |
| | | |
| | | private String temp2; |
| | | |
| | | @TableField("packing") |
| | | private String packing; |
| | |
| | | // 物料编号 |
| | | private String matnr; |
| | | |
| | | private String proType; |
| | | |
| | | private String temp2; |
| | | |
| | | |
| | | // 序列码 |
| | | private String itemBatch; |
| | |
| | | } |
| | | WaitPakin waitPakin = new WaitPakin(); |
| | | waitPakin.sync(mat); |
| | | waitPakin.setProType(detlDto.getProType()); |
| | | waitPakin.setTemp2(detlDto.getTemp2()); |
| | | waitPakin.setBatch(detlDto.getBatch()); |
| | | waitPakin.setZpallet(param.getBarcode()); // 托盘码 |
| | | waitPakin.setIoStatus("N"); // 入出状态 |
| | |
| | | |
| | | private Double anfme; |
| | | |
| | | private String temp2; |
| | | private String proType; |
| | | |
| | | public DetlDto() { |
| | | } |
| | | |
| | |
| | | this.anfme = anfme; |
| | | } |
| | | |
| | | public DetlDto(String matnr, String batch, Double anfme, String proType, String temp2) { |
| | | this.matnr = matnr; |
| | | this.batch = batch; |
| | | this.anfme = anfme; |
| | | this.proType = proType; |
| | | this.temp2 = temp2; |
| | | } |
| | | |
| | | public DetlDto(String orderNo, String matnr, String batch, Double anfme) { |
| | | this.orderNo = orderNo; |
| | | this.matnr = matnr; |
| | |
| | | mat.setTagId(priTag.getId()); |
| | | } |
| | | mat.setStatus(1); |
| | | if(itemTB.getTemp2() != null){ |
| | | mat.setLength(Double.parseDouble(itemTB.getTemp2())); |
| | | } |
| | | // mat.setLength(Double.parseDouble(itemTB.getTemp2())); |
| | | mat.setCreateTime(now); |
| | | mat.setUpdateTime(now); |
| | | if (!matService.insert(mat)) { |
| | |
| | | <if test="specs!=null and specs!='' "> |
| | | and a.specs like '%' + #{specs} + '%' |
| | | </if> |
| | | |
| | | <if test="proType!=null and proType!='' "> |
| | | and a.pro_type like '%' + #{proType} + '%' |
| | | </if> |
| | | <if test="temp1!=null and temp1!='' "> |
| | | and a.temp1 like '%' + #{temp1} + '%' |
| | | </if> |
| | | <if test="temp2!=null and temp2!='' "> |
| | | and a.temp2 like '%' + #{temp2} + '%' |
| | | </if> |
| | | <if test="sPgNO!=null and sPgNO!='' "> |
| | | and a.pg_no like '%' + #{sPgNO} + '%' |
| | | </if> |
| | |
| | | a.model, |
| | | a.pro_type AS proType, |
| | | a.out_order_no AS outOrderNo, |
| | | a.temp2 AS temp2, |
| | | -- 非分组字段用聚合函数获取一个代表值(例如MAX或MIN) |
| | | MAX(a.matnr) AS matnr, |
| | | MAX(a.specs) AS specs, |
| | |
| | | FROM asr_loc_detl a |
| | | WHERE 1=1 |
| | | <include refid="stockOutConditionTwo"/> |
| | | GROUP BY a.model, a.pro_type, a.out_order_no |
| | | GROUP BY a.model, a.pro_type, a.out_order_no, a.temp2 |
| | | ) t |
| | | WHERE t.row BETWEEN ((#{pageNumber}-1)*#{pageSize}+1) AND (#{pageNumber}*#{pageSize}) |
| | | </select> |
| | |
| | | ,{field: 'proType', align: 'center',title: '属性', hide: false} |
| | | ,{field: 'temp1', align: 'center',title: '名称总称', hide: false} |
| | | ,{field: 'outOrderNo', align: 'center',title: '合同号', hide: true} |
| | | ,{field: 'temp2', align: 'center',title: '客户图号', hide: false} |
| | | |
| | | |
| | | ] |
| | |
| | | ,{field: 'proType', align: 'center',title: '属性', hide: false} |
| | | ,{field: 'temp1', align: 'center',title: '名称总称', hide: false} |
| | | ,{field: 'outOrderNo', align: 'center',title: '合同号', hide: false} |
| | | ,{field: 'temp2', align: 'center',title: '客户图号', hide: false} |
| | | |
| | | ] |
| | | |
| | |
| | | ,{field: 'danger$', align: 'center',title: '危险品', hide: true} |
| | | ,{field: 'proType', align: 'center',title: '属性', hide: false} |
| | | ,{field: 'temp1', align: 'center',title: '名称总称', hide: false} |
| | | ,{field: 'temp2', align: 'center',title: '客户图号', hide: false} |
| | | |
| | | ]; |
| | | |
| | |
| | | {field: 'temp1', title:'产品总称', align: 'center'}, |
| | | {field: 'outOrderNo', title:'合同号', align: 'center'}, |
| | | {field: 'proType', title:'属性', align: 'center'}, |
| | | {field: 'temp2', title:'客户图号', align: 'center'}, |
| | | |
| | | ]], |
| | | request: { |
| | | pageName: 'curr', |
| | |
| | | ,{field: 'proType', align: 'center',title: '属性', hide: false} |
| | | ,{field: 'temp1', align: 'center',title: '名称总称', hide: false} |
| | | ,{field: 'outOrderNo', align: 'center',title: '合同号', hide: false} |
| | | ,{field: 'temp2', align: 'center',title: '客户图号', hide: false} |
| | | |
| | | |
| | | ]; |
| | |
| | | ,{field: 'proType', align: 'center',title: '属性', hide: false} |
| | | ,{field: 'temp1', align: 'center',title: '名称总称', hide: false} |
| | | ,{field: 'outOrderNo', align: 'center',title: '合同号', hide: false} |
| | | ,{field: 'temp2', align: 'center',title: '客户图号', hide: false} |
| | | |
| | | ]; |
| | | |
| | |
| | | <input class="layui-input" type="text" name="specs" placeholder="产品规格" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <!-- <div class="layui-inline">--> |
| | | <!-- <div class="layui-input-inline">--> |
| | | <!-- <input class="layui-input" type="text" name="outOrderNo" placeholder="派工单号" autocomplete="off">--> |
| | | <!-- </div>--> |
| | | <!-- </div>--> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="temp2" placeholder="客户图号" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="outOrderNo" placeholder="合同号" autocomplete="off"> |
| | |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="maktx" placeholder="物料描述" autocomplete="off"> |
| | | <input class="layui-input" type="text" name="proType" placeholder="属性" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <!-- <div class="layui-inline">--> |
| | | <!-- <div class="layui-input-inline">--> |
| | | <!-- <input class="layui-input" type="text" name="sPgNO" placeholder="派工单号" autocomplete="off">--> |
| | | <!-- </div>--> |
| | | <!-- </div>--> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="temp1" placeholder="总称" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="temp2" placeholder="客户图号" autocomplete="off"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-inline"> |
| | | <input class="layui-input" type="text" name="outOrderNo" placeholder="合同号" autocomplete="off"> |