如何利用PHP和Vue实现仓库管理的仓库调拨功能

<?php
  // 连接数据库
  $conn = new mysqli("localhost", "username", "password", "dbname");

  // 获取仓库列表
  $sql = "SELECT * FROM warehouses";
  $result = $conn->query($sql);

  // 输出仓库列表
  if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
      echo "仓库名称：" . $row["name"]. "<br>";
      echo "仓库地址：" . $row["address"]. "<br><br>";
    }
  } else {
    echo "暂无仓库信息";
  }

  // 关闭数据库连接
  $conn->close();
?>

<template>
  <div>
    <h1>调拨列表</h1>
    <table>
      <thead>
        <tr>
          <th>调出仓库</th>
          <th>调入仓库</th>
          <th>调拨数量</th>
        </tr>
      </thead>
      <tbody>
        <tr v-for="transfer in transfers" :key="transfer.id">
          <td>{{ transfer.fromWarehouse }}</td>
          <td>{{ transfer.toWarehouse }}</td>
          <td>{{ transfer.quantity }}</td>
        </tr>
      </tbody>
    </table>
  </div>
</template>

<script>
export default {
  data() {
    return {
      transfers: [
        { id: 1, fromWarehouse: '仓库A', toWarehouse: '仓库B', quantity: 10 },
        { id: 2, fromWarehouse: '仓库B', toWarehouse: '仓库C', quantity: 5 },
      ],
    };
  },
};
</script>

<template>
  <div>
    <h1>新调拨</h1>
    <form @submit.prevent="submitForm">
      <label for="fromWarehouse">调出仓库：</label>
      <select id="fromWarehouse" v-model="fromWarehouse">
        <option value="仓库A">仓库A</option>
        <option value="仓库B">仓库B</option>
        <option value="仓库C">仓库C</option>
      </select><br>

      <label for="toWarehouse">调入仓库：</label>
      <select id="toWarehouse" v-model="toWarehouse">
        <option value="仓库A">仓库A</option>
        <option value="仓库B">仓库B</option>
        <option value="仓库C">仓库C</option>
      </select><br>

      <label for="quantity">调拨数量：</label>
      <input type="number" id="quantity" v-model="quantity"><br><br>

      <button type="submit">提交</button>
    </form>
  </div>
</template>

<script>
export default {
  data() {
    return {
      fromWarehouse: '',
      toWarehouse: '',
      quantity: 0,
    };
  },
  methods: {
    submitForm() {
      // 在这里可以将表单数据通过Ajax请求发送到服务器，完成调拨操作
      console.log(this.fromWarehouse, this.toWarehouse, this.quantity);
    },
  },
};
</script>