Bonjour,
J'aimerais simplement ajouter le détail du retour produit sur le PDF généré pour le client qui demande un retour produit et ce quelque soit l'endroit dans le PDF (header, footer, peu importe tant que le motif est présent cela fait gagner du temps au e-commerçant).
Le scénario : Le client se connecte au backoffice et se rend dans la section retour produits. A cet instant il saisit le motif du retour. Le motif est bien consultable côté e-commercant dans la rubrique SAV -> retours. Le client génère sont étiquette de retour mais le PDF ne comporte pas le motif du retour qu'il vient de saisir.
Mes essais :
Je pense qu'il faudrait réussir à ajouter dans le fichier "/www/classes/pdf/HTMLTemplateOrderReturn.php" la fonction getOrdersReturnDetail afin de récupérer le motif du retour et l'ajouter dans le fichier '/www/classes/pdf/HTMLTemplateOrderReturn.php' mais j'avoue ne pas réussir à trouver comment faire.
Mes questions :
- Avez-vous déjà développé cela et si oui, serait-il possible de me dire la fonction à ajouter ?
- Cela vous paraît t-il trop complexe à développer ?
public static function getOrdersReturnDetail($id_order_return)
{
return Db::getInstance()->executeS('
SELECT *
FROM `' . _DB_PREFIX_ . 'order_return_detail`
WHERE `id_order_return` = ' . (int) $id_order_return);
}
-
Les fichiers concernés :
/www/classes/order/OrderReturn.php
<?php /** * Copyright since 2007 PrestaShop SA and Contributors * PrestaShop is an International Registered Trademark & Property of PrestaShop SA * * 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.md. * It is also available through the world-wide-web at this URL: * https://opensource.org/licenses/OSL-3.0 * 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 [email protected] 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 https://devdocs.prestashop.com/ for more information. * * @author PrestaShop SA and Contributors <[email protected]> * @copyright Since 2007 PrestaShop SA and Contributors * @license https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0) */ class OrderReturnCore extends ObjectModel { /** @var int */ public $id; /** @var int */ public $id_customer; /** @var int */ public $id_order; /** @var int */ public $state; /** @var string message content */ public $question; /** @var string Object creation date */ public $date_add; /** @var string Object last modification date */ public $date_upd; /** * @see ObjectModel::$definition */ public static $definition = [ 'table' => 'order_return', 'primary' => 'id_order_return', 'fields' => [ 'id_customer' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true], 'id_order' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true], 'question' => ['type' => self::TYPE_HTML, 'validate' => 'isCleanHtml'], 'state' => ['type' => self::TYPE_STRING], 'date_add' => ['type' => self::TYPE_DATE, 'validate' => 'isDate'], 'date_upd' => ['type' => self::TYPE_DATE, 'validate' => 'isDate'], ], ]; public function addReturnDetail($order_detail_list, $product_qty_list, $customization_ids, $customization_qty_input) { /* Classic product return */ if ($order_detail_list) { foreach ($order_detail_list as $key => $order_detail) { if ($qty = (int) $product_qty_list[$key]) { Db::getInstance()->insert('order_return_detail', ['id_order_return' => (int) $this->id, 'id_order_detail' => (int) $order_detail, 'product_quantity' => $qty, 'id_customization' => 0]); } } } /* Customized product return */ if ($customization_ids) { foreach ($customization_ids as $order_detail_id => $customizations) { foreach ($customizations as $customization_id) { if ($quantity = (int) $customization_qty_input[(int) $customization_id]) { Db::getInstance()->insert('order_return_detail', ['id_order_return' => (int) $this->id, 'id_order_detail' => (int) $order_detail_id, 'product_quantity' => $quantity, 'id_customization' => (int) $customization_id]); } } } } } public function checkEnoughProduct($order_detail_list, $product_qty_list, $customization_ids, $customization_qty_input) { $order = new Order((int) $this->id_order); if (!Validate::isLoadedObject($order)) { die(Tools::displayError()); } $products = $order->getProducts(); /* Products already returned */ $order_return = OrderReturn::getOrdersReturn($order->id_customer, $order->id, true); foreach ($order_return as $or) { $order_return_products = OrderReturn::getOrdersReturnProducts($or['id_order_return'], $order); foreach ($order_return_products as $key => $orp) { $products[$key]['product_quantity'] -= (int) $orp['product_quantity']; } } /* Quantity check */ if ($order_detail_list) { foreach (array_keys($order_detail_list) as $key) { if (!isset($product_qty_list[$key])) { return false; } if ($qty = (int) $product_qty_list[$key]) { if ($products[$key]['product_quantity'] - $qty < 0) { return false; } } } } /* Customization quantity check */ if ($customization_ids) { $ordered_customizations = Customization::getOrderedCustomizations((int) $order->id_cart); foreach ($customization_ids as $customizations) { foreach ($customizations as $customization_id) { $customization_id = (int) $customization_id; if (!isset($ordered_customizations[$customization_id])) { return false; } $quantity = (isset($customization_qty_input[$customization_id]) ? (int) $customization_qty_input[$customization_id] : 0); if ((int) $ordered_customizations[$customization_id]['quantity'] - $quantity < 0) { return false; } } } } return true; } public function countProduct() { if (!$data = Db::getInstance()->getRow(' SELECT COUNT(`id_order_return`) AS total FROM `' . _DB_PREFIX_ . 'order_return_detail` WHERE `id_order_return` = ' . (int) $this->id)) { return false; } return (int) ($data['total']); } public static function getOrdersReturn($customer_id, $order_id = false, $no_denied = false, Context $context = null) { if (!$context) { $context = Context::getContext(); } $data = Db::getInstance()->executeS(' SELECT * FROM `' . _DB_PREFIX_ . 'order_return` WHERE `id_customer` = ' . (int) $customer_id . ($order_id ? ' AND `id_order` = ' . (int) $order_id : '') . ($no_denied ? ' AND `state` != 4' : '') . ' ORDER BY `date_add` DESC'); foreach ($data as $k => $or) { $state = new OrderReturnState($or['state']); $data[$k]['state_name'] = $state->name[$context->language->id]; $data[$k]['type'] = 'Return'; $data[$k]['tracking_number'] = $or['id_order_return']; $data[$k]['can_edit'] = false; $data[$k]['reference'] = Order::getUniqReferenceOf($or['id_order']); } return $data; } public static function getOrdersReturnDetail($id_order_return) { return Db::getInstance()->executeS(' SELECT * FROM `' . _DB_PREFIX_ . 'order_return_detail` WHERE `id_order_return` = ' . (int) $id_order_return); } /** * @param int $order_return_id * @param Order $order * * @return array */ public static function getOrdersReturnProducts($order_return_id, $order) { $products_ret = OrderReturn::getOrdersReturnDetail($order_return_id); $products = $order->getProducts(); $tmp = []; foreach ($products_ret as $return_detail) { $tmp[$return_detail['id_order_detail']]['quantity'] = isset($tmp[$return_detail['id_order_detail']]['quantity']) ? $tmp[$return_detail['id_order_detail']]['quantity'] + (int) $return_detail['product_quantity'] : (int) $return_detail['product_quantity']; $tmp[$return_detail['id_order_detail']]['customizations'] = (int) $return_detail['id_customization']; } $res_tab = []; foreach ($products as $key => $product) { if (isset($tmp[$product['id_order_detail']])) { $res_tab[$key] = $product; $res_tab[$key]['product_quantity'] = $tmp[$product['id_order_detail']]['quantity']; $res_tab[$key]['customizations'] = $tmp[$product['id_order_detail']]['customizations']; } } return $res_tab; } public static function getReturnedCustomizedProducts($id_order) { $returns = Customization::getReturnedCustomizations($id_order); $order = new Order((int) $id_order); if (!Validate::isLoadedObject($order)) { die(Tools::displayError()); } $products = $order->getProducts(); foreach ($returns as &$return) { $return['product_id'] = (int) $products[(int) $return['id_order_detail']]['product_id']; $return['product_attribute_id'] = (int) $products[(int) $return['id_order_detail']]['product_attribute_id']; $return['name'] = $products[(int) $return['id_order_detail']]['product_name']; $return['reference'] = $products[(int) $return['id_order_detail']]['product_reference']; $return['id_address_delivery'] = $products[(int) $return['id_order_detail']]['id_address_delivery']; } return $returns; } public static function deleteOrderReturnDetail($id_order_return, $id_order_detail, $id_customization = 0) { return Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'order_return_detail` WHERE `id_order_detail` = ' . (int) $id_order_detail . ' AND `id_order_return` = ' . (int) $id_order_return . ' AND `id_customization` = ' . (int) $id_customization); } /** * Get return details for one product line. * * @param $id_order_detail */ public static function getProductReturnDetail($id_order_detail) { return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT product_quantity, date_add, orsl.name as state FROM `' . _DB_PREFIX_ . 'order_return_detail` ord LEFT JOIN `' . _DB_PREFIX_ . 'order_return` o ON o.id_order_return = ord.id_order_return LEFT JOIN `' . _DB_PREFIX_ . 'order_return_state_lang` orsl ON orsl.id_order_return_state = o.state AND orsl.id_lang = ' . (int) Context::getContext()->language->id . ' WHERE ord.`id_order_detail` = ' . (int) $id_order_detail); } /** * Add returned quantity to products list. * * @param array $products * @param int $id_order */ public static function addReturnedQuantity(&$products, $id_order) { $details = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS( 'SELECT od.id_order_detail, GREATEST(od.product_quantity_return, IFNULL(SUM(ord.product_quantity),0)) as qty_returned FROM ' . _DB_PREFIX_ . 'order_detail od LEFT JOIN ' . _DB_PREFIX_ . 'order_return_detail ord ON ord.id_order_detail = od.id_order_detail WHERE od.id_order = ' . (int) $id_order . ' GROUP BY od.id_order_detail' ); if (!$details) { return; } $detail_list = []; foreach ($details as $detail) { $detail_list[$detail['id_order_detail']] = $detail; } foreach ($products as &$product) { if (isset($detail_list[$product['id_order_detail']]['qty_returned'])) { $product['qty_returned'] = $detail_list[$product['id_order_detail']]['qty_returned']; } } } }
/www/classes/pdf/HTMLTemplateOrderReturn.php
<?php /** * Copyright since 2007 PrestaShop SA and Contributors * PrestaShop is an International Registered Trademark & Property of PrestaShop SA * * 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.md. * It is also available through the world-wide-web at this URL: * https://opensource.org/licenses/OSL-3.0 * 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 [email protected] 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 https://devdocs.prestashop.com/ for more information. * * @author PrestaShop SA and Contributors <[email protected]> * @copyright Since 2007 PrestaShop SA and Contributors * @license https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0) */ /** * @since 1.5 */ class HTMLTemplateOrderReturnCore extends HTMLTemplate { /** * @var OrderReturn */ public $order_return; /** * @var Order */ public $order; /** * @param OrderReturn $order_return * @param Smarty $smarty * * @throws PrestaShopException */ public function __construct(OrderReturn $order_return, Smarty $smarty) { $this->order_return = $order_return; $this->smarty = $smarty; $this->order = new Order($order_return->id_order); // header informations $this->date = Tools::displayDate($this->order->invoice_date); $prefix = Configuration::get('PS_RETURN_PREFIX', Context::getContext()->language->id); $this->title = sprintf(HTMLTemplateOrderReturn::l('%1$s%2$06d'), $prefix, $this->order_return->id); $this->shop = new Shop((int) $this->order->id_shop); } /** * Returns the template's HTML content. * * @return string HTML content */ public function getContent() { $delivery_address = new Address((int) $this->order->id_address_delivery); $formatted_delivery_address = AddressFormat::generateAddress($delivery_address, [], '<br />', ' '); $formatted_invoice_address = ''; if ($this->order->id_address_delivery != $this->order->id_address_invoice) { $invoice_address = new Address((int) $this->order->id_address_invoice); $formatted_invoice_address = AddressFormat::generateAddress($invoice_address, [], '<br />', ' '); } $this->smarty->assign([ 'order_return' => $this->order_return, 'return_nb_days' => (int) Configuration::get('PS_ORDER_RETURN_NB_DAYS'), 'products' => OrderReturn::getOrdersReturnProducts((int) $this->order_return->id, $this->order), 'delivery_address' => $formatted_delivery_address, 'invoice_address' => $formatted_invoice_address, 'shop_address' => AddressFormat::generateAddress($this->shop->getAddress(), [], '<br />', ' '), ]); $tpls = [ 'style_tab' => $this->smarty->fetch($this->getTemplate('invoice.style-tab')), 'addresses_tab' => $this->smarty->fetch($this->getTemplate('order-return.addresses-tab')), 'summary_tab' => $this->smarty->fetch($this->getTemplate('order-return.summary-tab')), 'product_tab' => $this->smarty->fetch($this->getTemplate('order-return.product-tab')), 'conditions_tab' => $this->smarty->fetch($this->getTemplate('order-return.conditions-tab')), ]; $this->smarty->assign($tpls); return $this->smarty->fetch($this->getTemplate('order-return')); } /** * Returns the template filename. * * @return string filename */ public function getFilename() { return Configuration::get('PS_RETURN_PREFIX', Context::getContext()->language->id, null, $this->order->id_shop) . sprintf('%06d', $this->order_return->id) . '.pdf'; } /** * Returns the template filename when using bulk rendering. * * @return string filename */ public function getBulkFilename() { return 'invoices.pdf'; } /** * Returns the template's HTML header. * * @return string HTML header */ public function getHeader() { $this->assignCommonHeaderData(); $this->smarty->assign(['header' => Context::getContext()->getTranslator()->trans('Order return', [], 'Shop.Pdf')]); return $this->smarty->fetch($this->getTemplate('header')); } }
Merci par avance de vos éclairages.
Site:
Prestashop 1.7.8.9
PHP : 7.4