| | |
| | | const TABLE_KEY = 'table-locDetl';
|
| | | let currentPage = 1;
|
| | | let pageSize = 10;
|
| | | let allQty = 0;
|
| | | const searchInput = ref("")
|
| | | const orderBy = ref({});
|
| | | const searchParam = ref({
|
| | |
| | | let tableData = ref([]);
|
| | | getColumns();
|
| | | getPage();
|
| | |
|
| | | getTotalQty();
|
| | | const {
|
| | | getColumnSearchProps,
|
| | | handleResizeColumn,
|
| | |
| | | }
|
| | | }
|
| | |
|
| | |
|
| | | function getTotalQty() {
|
| | | state.loading = true;
|
| | | post('/api/locDetl/all/Qty').then((resp) => {
|
| | | let result = resp.data;
|
| | | if (result.code == 200) {
|
| | | let {data} = result;
|
| | | console.log("------------=======>");
|
| | | allQty = data?.allQty;
|
| | | state.loading = false;
|
| | | } else if (result.code === 401) {
|
| | | message.error(result.msg);
|
| | | logout()
|
| | | } else {
|
| | | message.error(result.msg);
|
| | | }
|
| | | })
|
| | | }
|
| | |
|
| | |
|
| | | function getPage() {
|
| | | state.loading = true;
|
| | | post('/api/locDetl/page', {
|
| | |
| | | </template>
|
| | | </template>
|
| | | <template #footer>
|
| | | <div>
|
| | | <span>当前页总量:{{ total }}</span>
|
| | | <div style="display: 'flex';">
|
| | | <span>总库存:{{ allQty }} </span>
|
| | | <span>, 当前页总量:{{ total }}</span>
|
| | | </div>
|
| | | </template>
|
| | | </a-table>
|
| | |
| | | return R.ok().add(data);
|
| | | }
|
| | |
|
| | |
|
| | | @PreAuthorize("hasAuthority('asrs:locDetl:list')")
|
| | | @PostMapping("/locDetl/all/Qty")
|
| | | public R getAllStock() {
|
| | | return locDetlService.getAllStockQty();
|
| | | }
|
| | |
|
| | | @PreAuthorize("hasAuthority('asrs:locDetl:list')")
|
| | | @PostMapping("/locDetl/outPage")
|
| | | public R outPage(@RequestBody Map<String, Object> map) {
|
| | |
| | |
|
| | | @PostMapping("/out/orderOut/wave/preview")
|
| | | @OperationLog("预览波次出库")
|
| | | @Transactional
|
| | | @Transactional(rollbackFor = Exception.class)
|
| | | public R orderOutWavePreview(@RequestBody OrderOutWavePreviewParam param) {
|
| | | if (param == null) {
|
| | | throw new CoolException("参数不能为空");
|
| | |
| | |
|
| | | @PostMapping("/out/orderOut/merge/wave")
|
| | | @OperationLog("生成波次任务")
|
| | | @Transactional
|
| | | public R orderOutMerge(@RequestBody OrderOutMergeParamDto param) {
|
| | | outManage.orderOutMergeWave(param);
|
| | | return R.ok();
|
| | | }
|
| | |
|
| | |
|
| | | @PostMapping("/out/locs/stock")
|
| | | @OperationLog("手动出库")
|
| | | public R stockOut(@RequestBody StockOutParam param) {
|
| | |
| | |
|
| | |
|
| | | List<LocDetl> getStock(String matnr, String batch, List<Long> ids);
|
| | |
|
| | | Double getAllStock();
|
| | | }
|
| | |
| | |
|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
| | | import com.baomidou.mybatisplus.extension.service.IService;
|
| | | import com.zy.asrs.framework.common.R;
|
| | | import com.zy.asrs.wms.asrs.entity.LocDetl;
|
| | | import com.zy.asrs.wms.asrs.entity.ViewLocDetl;
|
| | | import com.zy.asrs.wms.asrs.entity.param.FieldParam;
|
| | |
| | | void removeLocDetl(Long locId);
|
| | |
|
| | | List<LocDetl> queryFlatStock(String matnr, String batch, List<FieldParam> uniqueField);
|
| | |
|
| | | R getAllStockQty();
|
| | | }
|
| | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
| | | import com.zy.asrs.framework.common.R;
|
| | | import com.zy.asrs.framework.exception.CoolException;
|
| | | import com.zy.asrs.wms.asrs.entity.*;
|
| | | import com.zy.asrs.wms.asrs.entity.enums.LocAreaTypeSts;
|
| | |
| | | });
|
| | | return detls;
|
| | | }
|
| | |
|
| | | /**
|
| | | * 获取所有库存数量
|
| | | * @return
|
| | | */
|
| | | @Override
|
| | | public R getAllStockQty() {
|
| | | Map<String, Double> map = new HashMap<>();
|
| | | Double allQty = this.baseMapper.getAllStock();
|
| | | map.put("allQty", allQty);
|
| | | return R.ok().add(map);
|
| | | }
|
| | | }
|
| | |
| | | </if>
|
| | | </select>
|
| | |
|
| | | <select id="getAllStock" resultType="java.lang.Double">
|
| | | SELECT SUM(anfme) all_qty FROM man_loc_detl WHERE deleted = 0
|
| | | </select>
|
| | | </mapper>
|