查询仓库---查询全部货架

zss

7 天以前 a5a094d5eb9eabb81acd714c964e51f1a99502b8

查询仓库---查询全部货架

 inspect-server/src/main/java/com/yuanchu/mom/controller/WarehouseController.java

@@ -34,6 +34,13 @@
        return Result.success(warehouseService.selectWarehouse());
    }

    @ValueClassify("样品管理")
    @GetMapping("/selectWarehouseAll")
    @ApiOperation("查询仓库---查询全部货架")
    public Result selectWarehouseAll() {
        return Result.success(warehouseService.selectWarehouseAll());
    }


    @ValueClassify("样品管理")
    @PostMapping("/addShelf")

 inspect-server/src/main/java/com/yuanchu/mom/mapper/WarehouseMapper.java

@@ -15,6 +15,7 @@
public interface WarehouseMapper extends BaseMapper<Warehouse> {

    List<WarehouseDto> selectWarehouseList();
    List<WarehouseDto> selectWarehouseListAll();

}


 inspect-server/src/main/java/com/yuanchu/mom/service/WarehouseService.java

@@ -20,6 +20,7 @@
    int addWarehouse(String name);

    List<WarehouseDto> selectWarehouse();
    List<WarehouseDto> selectWarehouseAll();

    int addShelf(WarehouseShelf warehouseShelf);


 inspect-server/src/main/java/com/yuanchu/mom/service/impl/WarehouseServiceImpl.java

@@ -65,6 +65,11 @@
    }

    @Override
    public List<WarehouseDto> selectWarehouseAll() {
        return warehouseMapper.selectWarehouseListAll();
    }

    @Override
    @Transactional(rollbackFor = Exception.class)
    public int addShelf(WarehouseShelf warehouseShelf) {
        warehouseShelfMapper.insert(warehouseShelf);

 inspect-server/src/main/resources/mapper/WarehouseMapper.xml

@@ -52,4 +52,22 @@
            and state=1
        order by id, sId, crow, ccol
    </select>
    
    <select id="selectWarehouseListAll" resultMap="Warehouse">
        select w.id,
               w.name,
               ws.id   sId,
               ws.name sName,
               ws.row,
               ws.col,
               wc.id   cId,
               wc.row  crow,
               wc.col  ccol
        from warehouse w
                 left join warehouse_shelf ws on w.id = ws.warehouse_id
                 left join warehouse_cell wc on shelf_id = ws.id
        where
             state=1
        order by id, sId, crow, ccol
    </select>
</mapper>