153 lines
8.1 KiB
PHP
153 lines
8.1 KiB
PHP
<?php
|
|
/**
|
|
* 2010-2023 Bl Modules.
|
|
*
|
|
* If you wish to customize this module for your needs,
|
|
* please contact the authors first for more information.
|
|
*
|
|
* It's not allowed selling, reselling or other ways to share
|
|
* this file or any other module files without author permission.
|
|
*
|
|
* @author Bl Modules
|
|
* @copyright 2010-2023 Bl Modules
|
|
* @license
|
|
*/
|
|
|
|
if (!defined('_PS_VERSION_')) {
|
|
exit;
|
|
}
|
|
|
|
class OrderFieldsAdmin extends Xmlfeeds
|
|
{
|
|
public function getFieldSettings($page, $moduleImgPath)
|
|
{
|
|
$r = Db::getInstance()->ExecuteS('
|
|
SELECT `name`, `status`, `title_xml`, `table`
|
|
FROM '._DB_PREFIX_.'blmod_xml_fields
|
|
WHERE category = "'.(int)$page.'"
|
|
');
|
|
|
|
$tags = array();
|
|
$branchNamesKey = array();
|
|
|
|
foreach ($r as $k) {
|
|
$tags[$k['name'].'+'.$k['table']] = isset($k['title_xml']) ? $k['title_xml'] : false;
|
|
$tags[$k['name'].'+'.$k['table'].'+status'] = isset($k['status']) ? $k['status'] : false;
|
|
}
|
|
|
|
if (!empty($tags)) {
|
|
$this->tags_info = $tags;
|
|
}
|
|
|
|
$branchNames = Db::getInstance()->ExecuteS('
|
|
SELECT `name`, `value`, `category`
|
|
FROM '._DB_PREFIX_.'blmod_xml_block
|
|
WHERE category = "'.(int)$page.'"
|
|
');
|
|
|
|
foreach ($branchNames as $bl) {
|
|
$branchNamesKey[$bl['name']] = isset($bl['value']) ? $bl['value'] : false;
|
|
}
|
|
|
|
$this->smarty->assign([
|
|
'branchNamesKey' => $branchNamesKey,
|
|
'moduleImgPath' => $moduleImgPath,
|
|
]);
|
|
|
|
$html = $this->displaySmarty('views/templates/admin/element/orderBlockSettings.tpl');
|
|
|
|
$html .= $this->printBlock(
|
|
'Order basic information',
|
|
array(
|
|
array('name' => 'id_order', 'title' => 'id_order', 'table' => 'orders'),
|
|
array('name' => 'reference', 'title' => 'reference', 'table' => 'orders'),
|
|
array('name' => 'invoice_number', 'title' => 'invoice_number', 'table' => 'orders'),
|
|
array('name' => 'invoice_date', 'title' => 'invoice_date', 'table' => 'orders'),
|
|
array('name' => 'gift', 'title' => 'is_gift', 'table' => 'orders'),
|
|
array('name' => 'gift_message', 'title' => 'gift_message', 'table' => 'orders'),
|
|
array('name' => 'current_state', 'title' => 'id_status', 'table' => 'orders'),
|
|
array('name' => 'name', 'title' => 'status_name', 'table' => 'order_state_lang'),
|
|
array('name' => 'payment', 'title' => 'payment', 'table' => 'orders'),
|
|
array('name' => 'date_add', 'title' => 'date_add', 'table' => 'orders'),
|
|
array('name' => 'date_upd', 'title' => 'date_upd', 'table' => 'orders'),
|
|
array('name' => 'currency', 'title' => 'currency', 'table' => 'bl_extra'),
|
|
array('name' => 'customer_message', 'title' => 'customer_messages', 'table' => 'bl_extra'),
|
|
array('name' => 'employee_message', 'title' => 'employee_messages', 'table' => 'bl_extra'),
|
|
array('name' => 'total_products', 'title' => 'total_products', 'table' => 'bl_extra'),
|
|
)
|
|
);
|
|
|
|
$html .= $this->printBlock(
|
|
'Prices, Tax',
|
|
array(
|
|
array('name' => 'total_paid', 'title' => 'total_paid', 'table' => 'orders'),
|
|
array('name' => 'total_paid_tax_incl', 'title' => 'total_paid_tax_incl', 'table' => 'orders'),
|
|
array('name' => 'total_paid_tax_excl', 'title' => 'total_paid_tax_excl', 'table' => 'orders'),
|
|
array('name' => 'total_wrapping', 'title' => 'total_wrapping', 'table' => 'orders'),
|
|
array('name' => 'total_discounts', 'title' => 'total_discounts', 'table' => 'orders'),
|
|
array('name' => 'total_products', 'title' => 'total_products', 'table' => 'orders'),
|
|
array('name' => 'tax_total_amount', 'title' => 'tax_total_amount', 'table' => 'bl_extra'),
|
|
)
|
|
);
|
|
|
|
$html .= $this->printBlock(
|
|
'Shipping, delivery',
|
|
array(
|
|
array('name' => 'shipping_number', 'title' => 'shipping_number', 'table' => 'orders'),
|
|
array('name' => 'delivery_number', 'title' => 'delivery_number', 'table' => 'orders'),
|
|
array('name' => 'delivery_date', 'title' => 'delivery_date', 'table' => 'orders'),
|
|
array('name' => 'id_carrier', 'title' => 'id_carrier', 'table' => 'orders'),
|
|
array('name' => 'name', 'title' => 'carrier_name', 'table' => 'carrier'),
|
|
array('name' => 'total_shipping', 'title' => 'total_shipping', 'table' => 'orders'),
|
|
array('name' => 'total_shipping_tax_incl', 'title' => 'total_shipping_tax_incl', 'table' => 'orders'),
|
|
array('name' => 'total_shipping_tax_excl', 'title' => 'total_shipping_tax_excl', 'table' => 'orders'),
|
|
array('name' => 'carrier_tax_rate', 'title' => 'carrier_tax_rate', 'table' => 'orders'),
|
|
array('name' => 'invoice_address', 'title' => 'invoice_address', 'table' => 'bl_extra'),
|
|
array('name' => 'delivery_address', 'title' => 'delivery_address', 'table' => 'bl_extra'),
|
|
)
|
|
);
|
|
|
|
$html .= $this->printBlock(
|
|
'Customer',
|
|
array(
|
|
array('name' => 'id_customer', 'title' => 'id_customer', 'table' => 'orders'),
|
|
array('name' => 'id_default_group', 'title' => 'id_group', 'table' => 'customer'),
|
|
array('name' => 'firstname', 'title' => 'firstname', 'table' => 'customer'),
|
|
array('name' => 'lastname', 'title' => 'lastname', 'table' => 'customer'),
|
|
array('name' => 'email', 'title' => 'email', 'table' => 'customer'),
|
|
array('name' => 'phone', 'title' => 'phone', 'table' => 'address'),
|
|
array('name' => 'birthday', 'title' => 'birthday', 'table' => 'customer'),
|
|
array('name' => 'address', 'title' => 'full_address', 'table' => 'bl_extra'),
|
|
array('name' => 'country', 'title' => 'country', 'table' => 'bl_extra'),
|
|
array('name' => 'city', 'title' => 'city', 'table' => 'bl_extra'),
|
|
array('name' => 'postcode', 'title' => 'postal_code', 'table' => 'bl_extra'),
|
|
array('name' => 'vat_number_invoice', 'title' => 'vat_number', 'table' => 'bl_extra'),
|
|
)
|
|
);
|
|
|
|
$html .= $this->printBlock(
|
|
'Products',
|
|
array(
|
|
array('name' => 'product_id', 'title' => 'product_id', 'table' => 'order_detail'),
|
|
array('name' => 'product_attribute_id', 'title' => 'product_attribute_id', 'table' => 'order_detail'),
|
|
array('name' => 'product_quantity', 'title' => 'product_quantity', 'table' => 'order_detail'),
|
|
array('name' => 'product_name', 'title' => 'product_name', 'table' => 'order_detail'),
|
|
array('name' => 'total_price_tax_incl', 'title' => 'products_price_tax_incl', 'table' => 'order_detail'),
|
|
array('name' => 'total_price_tax_excl', 'title' => 'products_price_tax_excl', 'table' => 'order_detail'),
|
|
array('name' => 'unit_price_tax_incl', 'title' => 'unit_price_tax_incl', 'table' => 'order_detail'),
|
|
array('name' => 'unit_price_tax_excl', 'title' => 'unit_price_tax_excl', 'table' => 'order_detail'),
|
|
array('name' => 'rate', 'title' => 'tax_rate', 'table' => 'tax'),
|
|
array('name' => 'product_ean13', 'title' => 'product_ean13', 'table' => 'order_detail'),
|
|
array('name' => 'product_reference', 'title' => 'product_reference', 'table' => 'order_detail'),
|
|
array('name' => 'product_upc', 'title' => 'product_upc', 'table' => 'order_detail'),
|
|
array('name' => 'product_isbn', 'title' => 'product_isbn', 'table' => 'order_detail'),
|
|
array('name' => 'product_supplier_reference', 'title' => 'supplier_reference', 'table' => 'order_detail'),
|
|
array('name' => 'id_supplier', 'title' => 'id_supplier', 'table' => 'product'),
|
|
array('name' => 'id_warehouse', 'title' => 'warehouse_id', 'table' => 'order_detail'),
|
|
)
|
|
);
|
|
|
|
return $html;
|
|
}
|
|
}
|