| | |
| | | @RequestParam Map<String, Object> param) { |
| | | Page<LocDetl> stockStatis = locDetlService.getStockStatis(toPage(curr, limit, param, LocDetl.class)); |
| | | for (LocDetl locDetl : stockStatis.getRecords()) { |
| | | Double weight = locDetl.getWeight(); |
| | | String standby1 = locDetl.getStandby1(); |
| | | Mat mat = matService.selectByMatnr(locDetl.getMatnr()); |
| | | if (mat != null) { |
| | | locDetl.sync(mat); |
| | | locDetl.setStandby1(standby1); |
| | | locDetl.setWeight(weight); |
| | | } |
| | | } |
| | | return R.ok().add(stockStatis); |
| | |
| | | return R.ok(sum); |
| | | } |
| | | |
| | | /** |
| | | * 获取库存总数 |
| | | * @return |
| | | */ |
| | | @RequestMapping("/locDetl/count2") |
| | | public R getAllCount2(){ |
| | | Integer sum = locDetlService.sum2(); |
| | | return R.ok(sum); |
| | | } |
| | | |
| | | } |
| | |
| | | ckbmList.add(storeType.getStoreId()); |
| | | } |
| | | |
| | | NccSaleXclGgsybWms nccSaleXclGgsybWms = nccSaleXclGgsybWmsService.selectOne(new EntityWrapper<NccSaleXclGgsybWms>() |
| | | /*NccSaleXclGgsybWms nccSaleXclGgsybWms = nccSaleXclGgsybWmsService.selectOne(new EntityWrapper<NccSaleXclGgsybWms>() |
| | | .eq("WLBM", combMat.getMatnr()) |
| | | .eq("VBATCHCODE", combMat.getBatch()) |
| | | .in("CKBM", ckbmList) |
| | |
| | | List<CombParam.CombMat> combMats = combParam.getCombMats(); |
| | | for (CombParam.CombMat mat : combMats) { |
| | | mat.setStandby1(nccSaleXclGgsybWms.getCkbm()); |
| | | } |
| | | }*/ |
| | | |
| | | mobileService.comb(combParam, getUserId()); |
| | | return R.ok("组托成功"); |
| | |
| | | |
| | | Integer sum(); |
| | | |
| | | Integer sum2(); |
| | | |
| | | List<LocDetl> unreason(); |
| | | |
| | | Double selectLocDetlSumQty(String locNo); |
| | |
| | | |
| | | Integer sum(); |
| | | |
| | | Integer sum2(); |
| | | |
| | | List<LocDetl> unreason(); |
| | | |
| | | Double getLocDetlSumQty(String locNo); |
| | |
| | | return this.baseMapper.sum(); |
| | | } |
| | | |
| | | /** |
| | | * 获取库存总数 |
| | | * @return |
| | | */ |
| | | @Override |
| | | public Integer sum2() { |
| | | return this.baseMapper.sum2(); |
| | | } |
| | | |
| | | @Override |
| | | public List<LocDetl> unreason() { |
| | | return this.baseMapper.unreason(); |
| | |
| | | ROW_NUMBER() over (order by sum(a.anfme) desc) as row |
| | | , a.matnr |
| | | , a.batch |
| | | , a.standby1 |
| | | , sum(a.anfme) as anfme |
| | | , sum(a.weight) as weight |
| | | from asr_loc_detl a |
| | | where 1=1 |
| | | <include refid="stockOutCondition"></include> |
| | | group by a.matnr, a.batch |
| | | group by a.matnr, a.batch , a.standby1 |
| | | ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize}) |
| | | </select> |
| | | |
| | |
| | | <select id="sum" resultType="java.lang.Integer"> |
| | | SELECT SUM(anfme) FROM asr_loc_detl |
| | | </select> |
| | | <select id="sum2" resultType="java.lang.Integer"> |
| | | SELECT SUM(weight) FROM asr_loc_detl |
| | | </select> |
| | | <select id="unreason" resultMap="BaseResultMap"> |
| | | SELECT |
| | | * |
| | |
| | | var cols = [ |
| | | {field: 'anfme', align: 'center',title: '库存数量', style: 'font-weight: bold'} |
| | | ]; |
| | | arrRemove(detlCols, "field", "anfme") |
| | | arrRemove(detlCols, "field", "zpallet") |
| | | arrRemove(detlCols, "field", "orderNo") |
| | | arrRemove(detlCols, "field", "supp") |
| | | cols.push.apply(cols, detlCols); |
| | | // cols.push({field: 'anfme', align: 'center',title: '数量', style: 'font-weight: bold'} |
| | | // ) |
| | |
| | | } |
| | | }); |
| | | |
| | | /** |
| | | * 显示库存总数量 |
| | | */ |
| | | $.ajax({ |
| | | url: baseUrl+"/locDetl/count2", |
| | | headers: {'token': localStorage.getItem('token')}, |
| | | contentType:'application/json;charset=UTF-8', |
| | | method: 'POST', |
| | | success: function (res) { |
| | | $("#countNum2").text(res.data + '个'); |
| | | } |
| | | }); |
| | | |
| | | } |
| | | }); |
| | | |
| | |
| | | </div> |
| | | </fieldset> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <fieldset class="layui-elem-field"> |
| | | <legend>总计辅数量</legend> |
| | | <div class="layui-field-box" id="countNum2"> |
| | | 请稍等 |
| | | </div> |
| | | </fieldset> |
| | | </div> |
| | | </div> |
| | | |
| | | <!-- 表格 --> |