Using PHP to develop an enterprise resource planning (ERP) system that implements order tracking functions

Use PHP to develop an enterprise resource planning (ERP) system that implements order tracking functions

The enterprise resource planning (Enterprise Resource Planning, abbreviated ERP) system is a software system that integrates various management functions. Help enterprises manage their daily business processes more effectively. Among them, the order tracking function is particularly important for enterprises, which can help enterprises understand the status and progress of orders in real time.

In this article, we will develop a simple order tracking function using PHP and integrate it into a basic ERP system.

1. Create a database

First, we need to create a database and create corresponding tables in the database to store order-related information.

-- 创建订单表
CREATE TABLE orders (
  id INT PRIMARY KEY AUTO_INCREMENT,
  order_number VARCHAR(50) NOT NULL,
  customer_name VARCHAR(100) NOT NULL,
  status ENUM('待处理', '处理中', '已完成') NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 创建订单历史记录表
CREATE TABLE order_history (
  id INT PRIMARY KEY AUTO_INCREMENT,
  order_id INT NOT NULL,
  status ENUM('待处理', '处理中', '已完成') NOT NULL,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (order_id) REFERENCES orders(id)
);

2. Create a PHP class

Next, we will create a PHP class to handle order-related operations. First, we need to define an Order class, which contains some basic properties and methods.

class Order {
  private $conn;

  public function __construct($conn) {
    $this->conn = $conn;
  }

  // 创建订单
  public function createOrder($orderNumber, $customerName) {
    $status = '待处理';

    $sql = "INSERT INTO orders (order_number, customer_name, status) VALUES (?, ?, ?)";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("sss", $orderNumber, $customerName, $status);
    $stmt->execute();
    $stmt->close();
  }

  // 更新订单状态
  public function updateOrderStatus($orderId, $status) {
    $sql = "UPDATE orders SET status = ? WHERE id = ?";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("si", $status, $orderId);
    $stmt->execute();
    $stmt->close();

    // 记录订单状态变更历史
    $this->recordOrderHistory($orderId, $status);
  }

  // 记录订单状态变更历史
  private function recordOrderHistory($orderId, $status) {
    $sql = "INSERT INTO order_history (order_id, status) VALUES (?, ?)";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("is", $orderId, $status);
    $stmt->execute();
    $stmt->close();
  }

  // 获取订单详情
  public function getOrderDetail($orderId) {
    $sql = "SELECT o.*, oh.status AS history_status, oh.updated_at AS history_updated_at
            FROM orders o
            LEFT JOIN order_history oh ON o.id = oh.order_id
            WHERE o.id = ?";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("i", $orderId);
    $stmt->execute();
    $result = $stmt->get_result();
    $orderDetail = $result->fetch_assoc();
    $stmt->close();

    return $orderDetail;
  }
}

3. Implement the order tracking function

Next, we will use the above Order class to implement the order tracking function. On the page, we will display the basic information and historical status change records of the order.

// 初始化数据库连接
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "erp";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
  die("连接数据库失败：" . $conn->connect_error);
}

$order = new Order($conn);

// 创建订单
$order->createOrder("202101010001", "张三");

// 更新订单状态为处理中
$order->updateOrderStatus(1, '处理中');

// 更新订单状态为已完成
$order->updateOrderStatus(1, '已完成');

// 获取订单详情
$orderDetail = $order->getOrderDetail(1);

In the above example code, we first create an order, then update its status to Processing, and finally update the status to Completed. Finally, we obtain the order details including basic information and historical status change records.

Conclusion

Through the above development steps, we successfully developed a simple order tracking function using PHP and integrated it into a basic ERP system. Through this function, enterprises can easily track and manage the status of orders and improve order processing efficiency. Of course, we can further improve and expand this order tracking function in actual projects to adapt to the needs of different companies.

The above is the detailed content of Using PHP to develop an enterprise resource planning (ERP) system that implements order tracking functions. For more information, please follow other related articles on the PHP Chinese website!