PrestaShop 1.7 后台产品列表添加批发价列教程

<!-- 尝试在 products_table.html.twig 中添加列头 -->
<th scope="col" class="text-center" style="width: 9%">
    {{ ps.sortable_column_header("Wholesale price"|trans({}, 'Admin.Catalog.Feature'), 'wholesale_price', orderBy, sortOrder) }}
</th>

<!-- 尝试在 list.html.twig 中添加列数据 -->
<td class="text-center">
    <a href="{{ product.url|default('') }}#tab-step2">{{ product.wholesale_price|default('N/A'|trans({}, 'Admin.Global')) }}</a>
</td>

modules/
└── myproductwholesale/
    └── myproductwholesale.php
    └── config.xml (PrestaShop自动生成)

<?php
/**
 * 2007-2024 PrestaShop
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/osl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to http://www.prestashop.com for more information.
 *
 * @author    PrestaShop SA <contact@prestashop.com>
 * @copyright 2007-2024 PrestaShop SA
 * @license   https://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 */

if (!defined('_PS_VERSION_')) {
    exit;
}

class MyProductWholesale extends Module
{
    public function __construct()
    {
        $this->name = 'myproductwholesale';
        $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 Wholesale Price Column');
        $this->description = $this->l('Adds a wholesale price column to the product catalog in the back office.');

        $this->confirmUninstall = $this->l('Are you sure you want to uninstall? All data will be lost.');
    }

    /**
     * Module installation
     *
     * @return bool
     */
    public function install()
    {
        return parent::install() &&
               $this->registerHook('actionAdminProductsListingFieldsModifier');
    }

    /**
     * Module uninstallation
     *
     * @return bool
     */
    public function uninstall()
    {
        return parent::uninstall();
    }

    /**
     * Hook to modify the product listing fields and data in the back office.
     *
     * @param array $params Contains 'list_fields' and 'list'
     * @return void
     */
    public function hookActionAdminProductsListingFieldsModifier(array $params)
    {
        // 确保 $params['list_fields'] 和 $params['list'] 存在且是数组
        if (!isset($params['list_fields']) || !isset($params['list']) || !is_array($params['list_fields']) || !is_array($params['list'])) {
            return;
        }

        // 1. 添加新的列定义到 $params['list_fields']
        // 'wholesale_price' 是我们自定义的字段名
        $params['list_fields']['wholesale_price'] = [
            'title' => $this->l('Wholesale price'), // 列标题
            'align' => 'text-center', // 对齐方式
            'type' => 'price', // 数据类型，PrestaShop会根据此类型进行格式化
            'currency' => true, // 是否显示货币符号
            'orderby' => true, // 是否可排序
            // 'filter' => true, // 如果需要过滤，可以启用
        ];

        // 2. 遍历产品列表，为每个产品填充 'wholesale_price' 数据
        foreach ($params['list'] as &$product_data) {
            $id_product = (int) $product_data['id_product'];

            // 实例化 Product 对象以获取批发价
            $product = new Product($id_product, false, (int)Context::getContext()->language->id);
            if (Validate::isLoadedObject($product)) {
                $product_data['wholesale_price'] = $product->wholesale_price;
            } else {
                $product_data['wholesale_price'] = 0; // 或者 'N/A'
            }
        }
    }
}