WordPress柔性供应链软件的低代码开发平台构建教程

引言：为什么选择WordPress构建供应链系统？

在当今快速变化的商业环境中，企业需要一个灵活、可扩展且成本效益高的供应链管理解决方案。传统供应链软件往往价格昂贵、实施周期长且难以定制。而WordPress作为全球最流行的内容管理系统，结合低代码开发理念，为构建柔性供应链软件提供了创新路径。

本教程将指导您如何利用WordPress生态系统构建一个功能完整的柔性供应链低代码开发平台，无需深厚的编程知识即可实现供应链管理核心功能。

环境准备与基础配置

WordPress安装与基础设置

首先，确保您已安装最新版本的WordPress。建议使用本地开发环境（如Local by Flywheel）或云服务器进行开发。

/**
 * WordPress供应链插件 - 基础配置类
 * 文件名：supply-chain-config.php
 */
class SupplyChainConfig {
    
    // 插件初始化
    public function __construct() {
        // 定义供应链模块常量
        define('SC_PLUGIN_DIR', plugin_dir_path(__FILE__));
        define('SC_PLUGIN_URL', plugin_dir_url(__FILE__));
        
        // 注册供应链自定义文章类型
        add_action('init', array($this, 'register_supply_chain_post_types'));
        
        // 初始化数据库表
        register_activation_hook(__FILE__, array($this, 'create_supply_chain_tables'));
    }
    
    // 注册供应链相关文章类型
    public function register_supply_chain_post_types() {
        // 产品类型
        register_post_type('sc_product',
            array(
                'labels' => array(
                    'name' => __('产品', 'supply-chain'),
                    'singular_name' => __('产品', 'supply-chain')
                ),
                'public' => true,
                'has_archive' => true,
                'supports' => array('title', 'editor', 'thumbnail', 'custom-fields'),
                'menu_icon' => 'dashicons-products',
                'show_in_rest' => true, // 启用Gutenberg编辑器支持
            )
        );
        
        // 供应商类型
        register_post_type('sc_supplier',
            array(
                'labels' => array(
                    'name' => __('供应商', 'supply-chain'),
                    'singular_name' => __('供应商', 'supply-chain')
                ),
                'public' => true,
                'supports' => array('title', 'editor', 'thumbnail'),
                'menu_icon' => 'dashicons-businessperson',
            )
        );
    }
    
    // 创建供应链数据库表
    public function create_supply_chain_tables() {
        global $wpdb;
        
        $charset_collate = $wpdb->get_charset_collate();
        $table_name = $wpdb->prefix . 'supply_chain_inventory';
        
        $sql = "CREATE TABLE IF NOT EXISTS $table_name (
            id mediumint(9) NOT NULL AUTO_INCREMENT,
            product_id mediumint(9) NOT NULL,
            quantity int NOT NULL DEFAULT 0,
            location varchar(100) NOT NULL,
            last_updated datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
            PRIMARY KEY (id),
            KEY product_id (product_id)
        ) $charset_collate;";
        
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($sql);
    }
}

// 初始化配置
$supply_chain_config = new SupplyChainConfig();

必要插件安装

为构建低代码平台，我们需要以下核心插件：

1. Advanced Custom Fields (ACF) - 用于创建自定义字段
2. Toolset Types - 替代方案，用于自定义内容类型
3. Gravity Forms - 创建供应链表单和工作流
4. WP Sheet Editor - 数据批量管理

核心模块开发

产品与库存管理模块

/**
 * 库存管理类
 * 文件名：inventory-manager.php
 */
class InventoryManager {
    
    // 更新库存数量
    public function update_inventory($product_id, $quantity_change, $location = 'default') {
        global $wpdb;
        
        $table_name = $wpdb->prefix . 'supply_chain_inventory';
        
        // 检查产品是否存在库存记录
        $existing = $wpdb->get_row($wpdb->prepare(
            "SELECT * FROM $table_name WHERE product_id = %d AND location = %s",
            $product_id, $location
        ));
        
        if ($existing) {
            // 更新现有库存
            $new_quantity = $existing->quantity + $quantity_change;
            
            $result = $wpdb->update(
                $table_name,
                array('quantity' => $new_quantity),
                array('id' => $existing->id),
                array('%d'),
                array('%d')
            );
            
            return $result ? $new_quantity : false;
        } else {
            // 创建新库存记录
            $result = $wpdb->insert(
                $table_name,
                array(
                    'product_id' => $product_id,
                    'quantity' => $quantity_change,
                    'location' => $location
                ),
                array('%d', '%d', '%s')
            );
            
            return $result ? $quantity_change : false;
        }
    }
    
    // 获取库存水平报告
    public function get_inventory_report($args = array()) {
        global $wpdb;
        
        $defaults = array(
            'low_stock_threshold' => 10,
            'location' => '',
            'category' => ''
        );
        
        $args = wp_parse_args($args, $defaults);
        $table_name = $wpdb->prefix . 'supply_chain_inventory';
        
        $query = "SELECT 
                    p.ID as product_id,
                    p.post_title as product_name,
                    i.quantity,
                    i.location,
                    CASE 
                        WHEN i.quantity <= %d THEN '低库存'
                        WHEN i.quantity <= %d THEN '中等库存'
                        ELSE '充足库存'
                    END as stock_status
                  FROM {$wpdb->posts} p
                  INNER JOIN $table_name i ON p.ID = i.product_id
                  WHERE p.post_type = 'sc_product' 
                  AND p.post_status = 'publish'";
        
        // 添加位置筛选
        if (!empty($args['location'])) {
            $query .= $wpdb->prepare(" AND i.location = %s", $args['location']);
        }
        
        $query .= " ORDER BY i.quantity ASC";
        
        return $wpdb->get_results($wpdb->prepare(
            $query, 
            $args['low_stock_threshold'], 
            $args['low_stock_threshold'] * 3
        ));
    }
}

// 短代码显示库存报告
add_shortcode('inventory_report', 'display_inventory_report');
function display_inventory_report($atts) {
    $atts = shortcode_atts(array(
        'threshold' => 10,
        'location' => ''
    ), $atts);
    
    $manager = new InventoryManager();
    $report = $manager->get_inventory_report(array(
        'low_stock_threshold' => $atts['threshold'],
        'location' => $atts['location']
    ));
    
    if (empty($report)) {
        return '<p>暂无库存数据</p>';
    }
    
    $output = '<table class="supply-chain-table">
                <thead>
                    <tr>
                        <th>产品名称</th>
                        <th>库存数量</th>
                        <th>位置</th>
                        <th>库存状态</th>
                    </tr>
                </thead>
                <tbody>';
    
    foreach ($report as $item) {
        $status_class = '';
        if (strpos($item->stock_status, '低库存') !== false) {
            $status_class = 'low-stock';
        } elseif (strpos($item->stock_status, '中等') !== false) {
            $status_class = 'medium-stock';
        } else {
            $status_class = 'high-stock';
        }
        
        $output .= sprintf(
            '<tr>
                <td>%s</td>
                <td>%d</td>
                <td>%s</td>
                <td class="%s">%s</td>
            </tr>',
            esc_html($item->product_name),
            $item->quantity,
            esc_html($item->location),
            $status_class,
            esc_html($item->stock_status)
        );
    }
    
    $output .= '</tbody></table>';
    
    return $output;
}

供应商关系管理模块

/**
 * 供应商管理类
 * 文件名：supplier-manager.php
 */
class SupplierManager {
    
    // 获取供应商绩效评分
    public function calculate_supplier_score($supplier_id) {
        $score = 100; // 基础分
        
        // 获取供应商订单数据
        $orders = $this->get_supplier_orders($supplier_id);
        
        if (empty($orders)) {
            return array('score' => $score, 'factors' => array('暂无订单数据'));
        }
        
        $factors = array();
        
        // 计算准时交付率
        $on_time_deliveries = 0;
        foreach ($orders as $order) {
            if ($order->delivery_status === 'on_time') {
                $on_time_deliveries++;
            }
        }
        
        $on_time_rate = ($on_time_deliveries / count($orders)) * 100;
        $score += ($on_time_rate - 90) * 0.5; // 基准90%
        
        $factors[] = sprintf('准时交付率: %.1f%%', $on_time_rate);
        
        // 计算质量合格率
        $quality_rate = $this->get_quality_rate($supplier_id);
        $score += ($quality_rate - 95) * 0.5; // 基准95%
        
        $factors[] = sprintf('质量合格率: %.1f%%', $quality_rate);
        
        // 价格竞争力评分
        $price_score = $this->calculate_price_score($supplier_id);
        $score += $price_score;
        
        $factors[] = sprintf('价格评分: %.1f/10', $price_score / 10);
        
        // 确保分数在合理范围内
        $score = max(0, min(100, $score));
        
        return array(
            'score' => round($score, 1),
            'grade' => $this->get_grade_from_score($score),
            'factors' => $factors
        );
    }
    
    // 根据分数获取等级
    private function get_grade_from_score($score) {
        if ($score >= 90) return 'A+';
        if ($score >= 80) return 'A';
        if ($score >= 70) return 'B';
        if ($score >= 60) return 'C';
        return 'D';
    }
    
    // 获取供应商订单
    private function get_supplier_orders($supplier_id) {
        global $wpdb;
        
        // 这里简化处理，实际应用中应从订单表获取数据
        return array();
    }
    
    // 获取质量合格率
    private function get_quality_rate($supplier_id) {
        // 模拟数据，实际应从质量检测记录获取
        return 97.5;
    }
    
    // 计算价格评分
    private function calculate_price_score($supplier_id) {
        // 模拟数据，实际应比较市场价格
        return 8.5;
    }
}

低代码可视化构建器

使用ACF创建供应链字段组

/**
 * 使用ACF创建供应链管理字段
 * 文件名：acf-supply-chain-fields.php
 */
if (function_exists('acf_add_local_field_group')) {
    
    // 产品额外信息字段组
    acf_add_local_field_group(array(
        'key' => 'group_product_info',
        'title' => '产品供应链信息',
        'fields' => array(
            array(
                'key' => 'field_product_sku',
                'label' => 'SKU编码',
                'name' => 'product_sku',
                'type' => 'text',
                'instructions' => '产品唯一库存单位编码',
                'required' => 1,
            ),
            array(
                'key' => 'field_product_cost',
                'label' => '成本价格',
                'name' => 'product_cost',
                'type' => 'number',
                'instructions' => '产品采购成本',
                'min' => 0,
                'step' => '0.01',
                'required' => 1,
            ),
            array(
                'key' => 'field_safety_stock',
                'label' => '安全库存',
                'name' => 'safety_stock',
                'type' => 'number',
                'instructions' => '最低库存警戒线',
                'min' => 0,
                'default_value' => 10,
            ),
            array(
                'key' => 'field_supplier',
                'label' => '主要供应商',
                'name' => 'primary_supplier',
                'type' => 'post_object',
                'post_type' => 'sc_supplier',
                'multiple' => 0,
                'return_format' => 'object',
            ),
        ),
        'location' => array(
            array(
                array(
                    'param' => 'post_type',
                    'operator' => '==',
                    'value' => 'sc_product',
                ),
            ),
        ),
        'menu_order' => 0,
        'position' => 'normal',
        'style' => 'default',
        'label_placement' => 'top',
        'instruction_placement' => 'label',
    ));
    
    // 供应商信息字段组
    acf_add_local_field_group(array(
        'key' => 'group_supplier_info',
        'title' => '供应商详细信息',
        'fields' => array(
            array(
                'key' => 'field_supplier_code',
                'label' => '供应商代码',
                'name' => 'supplier_code',
                'type' => 'text',
                'required' => 1,
            ),
            array(
                'key' => 'field_contact_person',
                'label' => '联系人',
                'name' => 'contact_person',
                'type' => 'text',
            ),
            array(
                'key' => 'field_contact_phone',
                'label' => '联系电话',
                'name' => 'contact_phone',
                'type' => 'text',
            ),
            array(
                'key' => 'field_lead_time',
                'label' => '平均交货期(天)',
                'name' => 'lead_time',
                'type' => 'number',
                'min' => 1,
                'default_value' => 7,
            ),
            array(
                'key' => 'field_supplier_rating',
                'label' => '供应商评级',
                'name' => 'supplier_rating',
                'type' => 'select',
                'choices' => array(
                    'A+' => 'A+ (优秀)',
                    'A' => 'A (良好)',
                    'B' => 'B (合格)',
                    'C' => 'C (待改进)',
                    'D' => 'D (不合格)',
                ),
                'default_value' => 'B',
            ),
        ),
        'location' => array(
            array(
                array(
                    'param' => 'post_type',
                    'operator' => '==',
                    'value' => 'sc_supplier',
                ),
            ),
        ),
    ));
}

使用Gravity Forms创建采购订单流程

/**
 * 采购订单表单处理
 * 文件名：purchase-order-form.php
 */
add_action('gform_after_submission_1', 'process_purchase_order', 10, 2);
function process_purchase_order($entry, $form) {
    
    // 获取表单提交的数据
    $supplier_id = rgar($entry, '1'); // 供应商ID
    $product_id = rgar($entry, '2');  // 产品ID
    $quantity = rgar($entry, '3');    // 采购数量
    $expected_date = rgar($entry, '4'); // 期望到货日期
    
    // 创建采购订单记录
    $order_data = array(
        'post_title' => sprintf('采购订单 - %s', date('YmdHis')),
        'post_type' => 'sc_purchase_order',
        'post_status' => 'publish',
        'meta_input' => array(
            '_supplier_id' => $supplier_id,
            '_product_id' => $product_id,
            '_quantity' => $quantity,
            '_expected_date' => $expected_date,
            '_order_status' => 'pending',
            '_created_by' => get_current_user_id(),
            '_order_date' => current_time('mysql'),
        ),
    );
    
    $order_id = wp_insert_post($order_data);
    
    if ($order_id && !is_wp_error($order_id)) {
        // 发送通知邮件
        send_order_notification($order_id, $supplier_id);
        
        // 记录操作日志
        log_supply_chain_action('purchase_order_created', array(
            'order_id' => $order_id,
            'user_id' => get_current_user_id(),
            'details' => "创建采购订单: 产品ID {$product_id}, 数量 {$quantity}"
        ));
        
        // 更新库存预期
        update_expected_inventory($product_id, $quantity);
    }
}

// 发送订单通知
function send_order_notification($order_id, $supplier_id) {
    $supplier_email = get_post_meta($supplier_id, 'contact_email', true);
    
    if (!$supplier_email) {
        return;
    }
    
    $subject = sprintf('新采购订单通知 - 订单号: %d', $order_id);
    $message = sprintf(
        "您收到一个新的采购订单。n订单号: %dn请登录系统查看详情。nn%s",
        $order_id,
        get_bloginfo('name')
    );
    
    wp_mail($supplier_email, $subject, $message);
}

// 记录供应链操作日志
function log_supply_chain_action($action, $data = array()) {
    global $wpdb;
    

$table_name = $wpdb->prefix . 'supply_chain_logs';

$wpdb->insert(
    $table_name,
    array(
        'action' => $action,
        'user_id' => get_current_user_id(),
        'data' => json_encode($data),
        'ip_address' => $_SERVER['REMOTE_ADDR'],
        'created_at' => current_time('mysql')
    ),
    array('%s', '%d', '%s', '%s', '%s')
);

}

// 更新预期库存
function update_expected_inventory($product_id, $quantity) {

$current_expected = get_post_meta($product_id, '_expected_inventory', true);
$new_expected = intval($current_expected) + $quantity;

update_post_meta($product_id, '_expected_inventory', $new_expected);

}

## 数据可视化与报表系统

### 使用Chart.js创建供应链仪表盘

/**

• 供应链仪表盘短代码
• 文件名：supply-chain-dashboard.php
  */

add_shortcode('supply_chain_dashboard', 'render_supply_chain_dashboard');
function render_supply_chain_dashboard() {

ob_start();
?>

<div class="supply-chain-dashboard">
    <div class="dashboard-header">
        <h2>供应链智能仪表盘</h2>
        <div class="dashboard-filters">
            <select id="time-range">
                <option value="7">最近7天</option>
                <option value="30" selected>最近30天</option>
                <option value="90">最近90天</option>
            </select>
            <select id="location-filter">
                <option value="">所有仓库</option>
                <option value="east">东部仓库</option>
                <option value="west">西部仓库</option>
                <option value="south">南部仓库</option>
            </select>
        </div>
    </div>
    
    <div class="dashboard-widgets">
        <div class="widget inventory-overview">
            <h3>库存概览</h3>
            <div class="widget-content">
                <canvas id="inventoryChart" width="400" height="200"></canvas>
            </div>
        </div>
        
        <div class="widget supplier-performance">
            <h3>供应商绩效</h3>
            <div class="widget-content">
                <canvas id="supplierChart" width="400" height="200"></canvas>
            </div>
        </div>
        
        <div class="widget order-tracking">
            <h3>订单状态</h3>
            <div class="widget-content">
                <div id="orderStats">
                    <div class="stat-item">
                        <span class="stat-value" id="pendingOrders">0</span>
                        <span class="stat-label">待处理</span>
                    </div>
                    <div class="stat-item">
                        <span class="stat-value" id="shippedOrders">0</span>
                        <span class="stat-label">已发货</span>
                    </div>
                    <div class="stat-item">
                        <span class="stat-value" id="deliveredOrders">0</span>
                        <span class="stat-label">已送达</span>
                    </div>
                </div>
            </div>
        </div>
        
        <div class="widget low-stock-alerts">
            <h3>低库存预警</h3>
            <div class="widget-content">
                <ul id="lowStockList">
                    <!-- 动态加载低库存产品 -->
                </ul>
            </div>
        </div>
    </div>
</div>

<script>
document.addEventListener('DOMContentLoaded', function() {
    // 初始化仪表盘数据
    loadDashboardData();
    
    // 绑定筛选器事件
    document.getElementById('time-range').addEventListener('change', loadDashboardData);
    document.getElementById('location-filter').addEventListener('change', loadDashboardData);
    
    // 设置自动刷新（每5分钟）
    setInterval(loadDashboardData, 300000);
});

function loadDashboardData() {
    const timeRange = document.getElementById('time-range').value;
    const location = document.getElementById('location-filter').value;
    
    // 使用AJAX获取数据
    fetch('/wp-admin/admin-ajax.php?action=get_supply_chain_data', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/x-www-form-urlencoded',
        },
        body: `time_range=${timeRange}&location=${location}`
    })
    .then(response => response.json())
    .then(data => {
        updateInventoryChart(data.inventory);
        updateSupplierChart(data.suppliers);
        updateOrderStats(data.orders);
        updateLowStockAlerts(data.low_stock);
    })
    .catch(error => console.error('Error:', error));
}

function updateInventoryChart(inventoryData) {
    const ctx = document.getElementById('inventoryChart').getContext('2d');
    
    // 如果图表已存在，先销毁
    if (window.inventoryChart instanceof Chart) {
        window.inventoryChart.destroy();
    }
    
    window.inventoryChart = new Chart(ctx, {
        type: 'bar',
        data: {
            labels: inventoryData.labels,
            datasets: [{
                label: '库存数量',
                data: inventoryData.values,
                backgroundColor: 'rgba(54, 162, 235, 0.5)',
                borderColor: 'rgba(54, 162, 235, 1)',
                borderWidth: 1
            }]
        },
        options: {
            responsive: true,
            scales: {
                y: {
                    beginAtZero: true
                }
            }
        }
    });
}
</script>

<style>
.supply-chain-dashboard {
    background: #f8f9fa;
    padding: 20px;
    border-radius: 8px;
}

.dashboard-header {
    display: flex;
    justify-content: space-between;
    align-items: center;
    margin-bottom: 30px;
}

.dashboard-filters select {
    padding: 8px 15px;
    border-radius: 4px;
    border: 1px solid #ddd;
    margin-left: 10px;
}

.dashboard-widgets {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));
    gap: 20px;
}

.widget {
    background: white;
    border-radius: 8px;
    padding: 20px;
    box-shadow: 0 2px 10px rgba(0,0,0,0.1);
}

.widget h3 {
    margin-top: 0;
    color: #333;
    border-bottom: 2px solid #4CAF50;
    padding-bottom: 10px;
}

#orderStats {
    display: flex;
    justify-content: space-around;
    text-align: center;
}

.stat-item {
    display: flex;
    flex-direction: column;
}

.stat-value {
    font-size: 32px;
    font-weight: bold;
    color: #4CAF50;
}

.stat-label {
    color: #666;
    font-size: 14px;
}

#lowStockList {
    list-style: none;
    padding: 0;
}

#lowStockList li {
    padding: 10px;
    border-bottom: 1px solid #eee;
    display: flex;
    justify-content: space-between;
}

#lowStockList li:last-child {
    border-bottom: none;
}
</style>

<?php
return ob_get_clean();

}

// AJAX数据处理端点
add_action('wp_ajax_get_supply_chain_data', 'ajax_get_supply_chain_data');
add_action('wp_ajax_nopriv_get_supply_chain_data', 'ajax_get_supply_chain_data');
function ajax_get_supply_chain_data() {

$time_range = intval($_POST['time_range'] ?? 30);
$location = sanitize_text_field($_POST['location'] ?? '');

$data = array(
    'inventory' => get_inventory_data($time_range, $location),
    'suppliers' => get_supplier_performance_data($time_range),
    'orders' => get_order_statistics($time_range),
    'low_stock' => get_low_stock_products()
);

wp_send_json_success($data);

}

function get_inventory_data($time_range, $location) {

global $wpdb;

$table_name = $wpdb->prefix . 'supply_chain_inventory';

$query = "SELECT 
            p.post_title as product_name,
            AVG(i.quantity) as avg_quantity
          FROM $table_name i
          INNER JOIN {$wpdb->posts} p ON i.product_id = p.ID
          WHERE p.post_type = 'sc_product'
          AND p.post_status = 'publish'
          AND i.last_updated >= DATE_SUB(NOW(), INTERVAL %d DAY)";

if ($location) {
    $query .= $wpdb->prepare(" AND i.location = %s", $location);
}

$query .= " GROUP BY i.product_id
            ORDER BY avg_quantity DESC
            LIMIT 10";

$results = $wpdb->get_results($wpdb->prepare($query, $time_range));

$labels = array();
$values = array();

foreach ($results as $row) {
    $labels[] = wp_trim_words($row->product_name, 3);
    $values[] = floatval($row->avg_quantity);
}

return array(
    'labels' => $labels,
    'values' => $values
);

}

## 自动化工作流与集成

### 创建供应链自动化规则引擎

/**

• 供应链规则引擎
• 文件名：supply-chain-rules-engine.php
  */

class SupplyChainRulesEngine {

private $rules = array();

public function __construct() {
    $this->load_rules();
    add_action('save_post_sc_product', array($this, 'check_product_rules'), 10, 3);
    add_action('sc_inventory_updated', array($this, 'check_inventory_rules'), 10, 3);
}

// 加载规则配置
private function load_rules() {
    $this->rules = array(
        'low_stock' => array(
            'condition' => 'inventory_below_threshold',
            'action' => 'create_purchase_order',
            'params' => array(
                'threshold_type' => 'safety_stock',
                'order_quantity' => 'reorder_quantity'
            ),
            'enabled' => true
        ),
        'excess_stock' => array(
            'condition' => 'inventory_above_max',
            'action' => 'create_promotion',
            'params' => array(
                'max_threshold' => 'max_stock',
                'promotion_discount' => 15
            ),
            'enabled' => true
        ),
        'supplier_performance' => array(
            'condition' => 'supplier_rating_below',
            'action' => 'notify_manager',
            'params' => array(
                'min_rating' => 'B',
                'notification_type' => 'email'
            ),
            'enabled' => true
        )
    );
}

// 检查库存规则
public function check_inventory_rules($product_id, $new_quantity, $old_quantity) {
    $product_data = $this->get_product_data($product_id);
    
    foreach ($this->rules as $rule_name => $rule) {
        if (!$rule['enabled']) continue;
        
        $condition_met = false;
        
        switch ($rule['condition']) {
            case 'inventory_below_threshold':
                $safety_stock = get_post_meta($product_id, 'safety_stock', true);
                $condition_met = ($new_quantity <= $safety_stock && $old_quantity > $safety_stock);
                break;
                
            case 'inventory_above_max':
                $max_stock = get_post_meta($product_id, 'max_stock', true) ?: 1000;
                $condition_met = ($new_quantity >= $max_stock);
                break;
        }
        
        if ($condition_met) {
            $this->execute_rule_action($rule_name, $rule, $product_id, $product_data);
        }
    }
}

// 执行规则动作
private function execute_rule_action($rule_name, $rule, $product_id, $product_data) {
    switch ($rule['action']) {
        case 'create_purchase_order':
            $this->create_auto_purchase_order($product_id, $product_data, $rule['params']);
            break;
            
        case 'create_promotion':
            $this->create_promotion_campaign($product_id, $rule['params']);
            break;
            
        case 'notify_manager':
            $this->send_manager_notification($product_id, $rule['params']);
            break;
    }
    
    // 记录规则触发
    $this->log_rule_trigger($rule_name, $product_id);
}

// 自动创建采购订单
private function create_auto_purchase_order($product_id, $product_data, $params) {
    $supplier_id = get_post_meta($product_id, 'primary_supplier', true);
    
    if (!$supplier_id) {
        error_log("无法为产品 {$product_id} 创建自动采购订单：未设置主要供应商");
        return;
    }
    
    // 计算订购数量
    $safety_stock = get_post_meta($product_id, 'safety_stock', true);
    $current_stock = $this->get_current_inventory($product_id);
    $reorder_quantity = get_post_meta($product_id, 'reorder_quantity', true) ?: $safety_stock * 2;
    
    $order_quantity = max($reorder_quantity, $safety_stock - $current_stock + $reorder_quantity);
    
    // 创建采购订单
    $order_data = array(
        'post_title' => sprintf('自动采购订单 - %s - %s', 
            $product_data['name'], 
            date('Y-m-d H:i:s')
        ),
        'post_type' => 'sc_purchase_order',
        'post_status' => 'publish',
        'meta_input' => array(
            '_supplier_id' => $supplier_id,
            '_product_id' => $product_id,
            '_quantity' => $order_quantity,
            '_order_type' => 'auto',
            '_trigger_rule' => 'low_stock',
            '_created_by' => 0, // 系统创建
            '_order_date' => current_time('mysql'),
        ),
    );
    
    $order_id = wp_insert_post($order_data);
    
    if ($order_id && !is_wp_error($order_id)) {
        // 发送系统通知
        $this->send_auto_order_notification($order_id, $product_id, $supplier_id);
        
        return $order_id;
    }
    
    return false;
}

// 获取产品数据
private function get_product_data($product_id) {
    $product = get_post($product_id);
    
    return array(
        'id' => $product_id,
        'name' => $product->post_title,
        'sku' => get_post_meta($product_id, 'product_sku', true),
        'current_stock' => $this->get_current_inventory($product_id)
    );
}

// 获取当前库存
private function get_current_inventory($product_id) {
    global $wpdb;
    $table_name = $wpdb->prefix . 'supply_chain_inventory';
    
    $result = $wpdb->get_var($wpdb->prepare(
        "SELECT SUM(quantity) FROM $table_name WHERE product_id = %d",
        $product_id
    ));
    
    return intval($result);
}

// 记录规则触发
private function log_rule_trigger($rule_name, $product_id) {
    global $wpdb;
    
    $table_name = $wpdb->prefix . 'supply_chain_rule_logs';
    
    $wpdb->insert(
        $table_name,
        array(
            'rule_name' => $rule_name,
            'product_id' => $product_id,
            'triggered_at' => current_time('mysql'),
            'details' => json_encode(array(
                'product_id' => $product_id,
                'timestamp' => time()
            ))
        )
    );
}

}

// 初始化规则引擎
$supply_chain_rules = new SupplyChainRulesEngine();

## 部署与优化建议

### 系统部署配置

1. **服务器要求**：
   - PHP 7.4+ 并启用MySQLi扩展
   - MySQL 5.7+ 或 MariaDB 10.3+
   - 至少2GB内存
   - 推荐使用对象存储服务处理文件

2. **安全配置**：

// 在wp-config.php中添加的安全配置
define('DISALLOW_FILE_EDIT', true); // 禁用主题/插件编辑器
define('FORCE_SSL_ADMIN', true); // 强制后台使用SSL

// 限制API访问
add_filter('rest_authentication_errors', function($result) {

   if (!is_user_logged_in()) {
       return new WP_Error('rest_not_logged_in', 
           '请登录后访问API', 
           array('status' => 401));
   }
   return $result;

});

3. **性能优化**：

// 启用数据缓存
add_action('init', 'init_supply_chain_cache');
function init_supply_chain_cache() {

   if (!wp_cache_get('supply_chain_inventory_report')) {
       $report = generate_inventory_report();
       wp_cache_set('supply_chain_inventory_report', $report, '', 3600); // 缓存1小时
   }