PHP社が開発した売上ログ機能をERP（基幹業務システム）で活用

CREATE TABLE sales_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    order_number VARCHAR(20) NOT NULL,
    sales_amount DECIMAL(10, 2) NOT NULL,
    sales_date DATE NOT NULL,
    customer_id INT NOT NULL
);

function insertSalesLog($orderNumber, $salesAmount, $salesDate, $customerId) {
    $dsn = 'mysql:host=localhost;dbname=erp_system';
    $username = 'username';
    $password = 'password';

    try {
        $pdo = new PDO($dsn, $username, $password);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $stmt = $pdo->prepare('INSERT INTO sales_logs (order_number, sales_amount, sales_date, customer_id) VALUES (:orderNumber, :salesAmount, :salesDate, :customerId)');
        $stmt->bindParam(':orderNumber', $orderNumber);
        $stmt->bindParam(':salesAmount', $salesAmount);
        $stmt->bindParam(':salesDate', $salesDate);
        $stmt->bindParam(':customerId', $customerId);

        $stmt->execute();

        echo '销售日志已成功插入到数据库中。';
    } catch (PDOException $e) {
        echo '插入销售日志失败：' . $e->getMessage();
    }
}

function getSalesLogsByDateRange($startDate, $endDate) {
    $dsn = 'mysql:host=localhost;dbname=erp_system';
    $username = 'username';
    $password = 'password';

    try {
        $pdo = new PDO($dsn, $username, $password);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $stmt = $pdo->prepare('SELECT * FROM sales_logs WHERE sales_date BETWEEN :startDate AND :endDate');
        $stmt->bindParam(':startDate', $startDate);
        $stmt->bindParam(':endDate', $endDate);

        $stmt->execute();

        $salesLogs = $stmt->fetchAll(PDO::FETCH_ASSOC);

        return $salesLogs;
    } catch (PDOException $e) {
        echo '查询销售日志失败：' . $e->getMessage();
    }
}