PrestaShop 1.7 后台产品列表添加批发价格列的专业指南

<?php
if (!defined('_PS_VERSION_')) {
    exit;
}

class MyProductListEnhancer extends Module
{
    public function __construct()
    {
        $this->name = 'myproductlistenhancer';
        $this->tab = 'front_office_features';
        $this->version = '1.0.0';
        $this->author = 'Your Name';
        $this->need_instance = 0;
        $this->ps_versions_compliancy = [
            'min' => '1.7',
            'max' => _PS_VERSION_,
        ];
        $this->bootstrap = true;

        parent::__construct();

        $this->displayName = $this->l('My Product List Enhancer');
        $this->description = $this->l('Adds wholesale price column to product list.');

        $this->confirmUninstall = $this->l('Are you sure you want to uninstall?');
    }

    public function install()
    {
        return parent::install() &&
               $this->registerHook('actionAdminProductsListingFieldsModifier');
    }

    public function uninstall()
    {
        return parent::uninstall();
    }

    /**
     * Hook to modify the product listing fields and query.
     * This hook is called in AdminProductsController.
     *
     * @param array $params Contains 'list_fields', 'sql_get_products_base', 'sql_get_products_join', 'sql_get_products_where'
     */
    public function hookActionAdminProductsListingFieldsModifier(array $params)
    {
        // 1. 添加批发价格列的定义
        $params['list_fields']['wholesale_price'] = [
            'title' => $this->l('Wholesale price'),
            'align' => 'text-center',
            'type' => 'price', // 或者 'float'
            'class' => 'fixed-width-lg',
            'currency_id' => Configuration::get('PS_CURRENCY_DEFAULT'), // 获取默认货币ID
            'callback' => 'displayPrice', // 使用回调函数格式化价格显示
            'callback_object' => $this, // 回调函数所在的类实例
            'orderby' => true,
            'search' => true,
        ];

        // 2. 修改 SQL 查询以包含 wholesale_price 字段
        // 注意：wholesale_price 通常存储在 ps_product 表中
        // 如果存储在其他表，需要修改 $params['sql_get_products_join'] 来进行 JOIN
        $params['sql_get_products_base'] = str_replace(
            'SELECT p.id_product, p.reference, p.is_virtual, p.id_category_default, ',
            'SELECT p.id_product, p.reference, p.is_virtual, p.id_category_default, p.wholesale_price, ',
            $params['sql_get_products_base']
        );
    }

    /**
     * Callback function to display price with currency.
     * This is used by the 'callback' option in list_fields.
     *
     * @param float $price The price value.
     * @param array $row The full product row data (not directly used here, but available).
     * @return string Formatted price string.
     */
    public function displayPrice($price, $row)
    {
        if (Validate::isPrice($price)) {
            return Tools::displayPrice($price, (int)Configuration::get('PS_CURRENCY_DEFAULT'));
        }
        return $this->l('N/A');
    }
}

{# ... 其他列头 ... #}
<th scope="col" class="text-center" style="width: 9%">
    {{ ps.sortable_column_header("Wholesale price"|trans({}, 'Admin.Catalog.Feature'), 'wholesale_price', orderBy, sortOrder) }}
</th>
{# ... 其他列头 ... #}