Borgas
Members-
Posts
33 -
Joined
-
Last visited
Profile Information
-
Location
Lisbon
-
Activity
Project Owner
Recent Profile Visitors
459 profile views
Borgas's Achievements
-
[SOLUTION] How to use order_conf variables in any email template.
Borgas replied to mpdas108's topic in Core developers
Works like a charm Just copy mails/_partials to YOURTHEME/MAILS/LANGUAGES Edit as you wich -
[SOLUTION] How to use order_conf variables in any email template.
Borgas replied to mpdas108's topic in Core developers
Hello Any solution for 1.7.8? Hello Already create the Orderhistory.php overide Can you point where is the sendemail function? I would like to send email with products that customer bought with a link I have {products} in modern theme, but is not showing nothing PS 1.7.8 -
Hello Prestashop version 1.7.8 Is it possible to insert in email theme (modern) the products that customer buy? I would like the customer get the list of prodcuts, even after order confirmation sent. And able to click on them and go to product page. I tried {meta_products} and {products} with no sucess Thank you
-
Hi Knacky Is it possible to point some how, how to extract from orders? I have one product with combinations, how can i get them but from orders. Thank you
-
Product features in cart summary - Prestashop 1.7.6.4
Borgas replied to grupaperun's topic in General topics
Works great in 1.7.6 Is there a way to filter by id the feature? {if $feature.id_feature == 1 OR $feature.id_feature == 10 OR $feature.id_feature == 20 } This doens´t work in checkout, only in product pages -
Hi After upgrade from 1.7.5 to 1.7.6 if you import anything from advance parameter - import, after job done the page doesn´t return to import configuration again. You have a clean page as i show in attachement
-
Hello I did manage to insert on list info such as phone ou phone mobile But when i try to put "company" the result is ambiguos I don´t want to enable B2B, because field "company" is beeing used for other info
-
Hi Forum Prestashop 1.6.1.18 I have a SQL request to export all orders with products to csv: SELECT d.id_order AS ID_Registo, o.reference AS ref, os.name AS Estado_Pagamento, o.date_upd AS Data, d.product_name AS Produto, d.product_reference AS Referencia, d.product_quantity AS Quantidade, d.product_price AS Preco_Produto, ai.company AS Matricula, CONCAT_WS( ' ', g.firstname, g.lastname ) AS Nome_Cliente, CONCAT_WS(' ', ad.address1, ad.address2, ad.other, ad.phone, ad.phone_mobile) AS Morada, ad.postcode AS Cod_Postal, ad.city AS Localidade, CONCAT_WS(' ', ai.address1, ai.address2, ai.other) AS Morada, g.email AS Email, ai.phone AS Telefone, ai.phone_mobile AS Telemóvel FROM psha_order_detail d LEFT JOIN psha_orders o ON ( d.id_order = o.id_order ) LEFT JOIN psha_customer g ON ( o.id_customer = g.id_customer ) LEFT JOIN psha_stock_available s ON (d.product_id = s.id_product) LEFT JOIN psha_address ad ON (o.id_address_delivery = ad.id_address) LEFT JOIN psha_address ai ON (o.id_address_invoice = ai.id_address) LEFT JOIN psha_group_lang gl ON ( g.id_default_group = gl.id_group ) LEFT JOIN psha_order_state_lang os ON ( o.current_state = os.id_order_state ) WHERE os.id_lang =1 GROUP BY d.id_order, d.product_name ORDER BY d.id_order DESC But 1 (only) product as a custom field. How can i show it on list/request??
-
Hi Forum I manage to add Carrier to Orders List, saving a file named "AdminOrdersController.php" inside override/controllers/admin and this works showing the Carrier in order list Can you help me how can i show the custom field saved in cart before order??? PS 1.6.1.18 <?php class AdminOrdersController extends AdminOrdersControllerCore { public function __construct() { $this->bootstrap = true; $this->table = 'order'; $this->className = 'Order'; $this->lang = false; $this->addRowAction('view'); $this->explicitSelect = true; $this->allow_export = true; $this->deleted = false; $this->context = Context::getContext(); $this->_select = ' a.id_currency, a.id_order AS id_pdf, CONCAT(LEFT(c.`firstname`, 1), \'. \', c.`lastname`) AS `customer`, osl.`name` AS `osname`, IF(carrier.`name` = "0", "-", carrier.`name`) AS `carriername`, os.`color`, IF((SELECT so.id_order FROM `'._DB_PREFIX_.'orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1) as new, country_lang.name as cname, IF(a.valid, 1, 0) badge_success'; $this->_join = ' LEFT JOIN `'._DB_PREFIX_.'customer` c ON (c.`id_customer` = a.`id_customer`) LEFT JOIN `'._DB_PREFIX_.'address` address ON address.id_address = a.id_address_delivery LEFT JOIN `'._DB_PREFIX_.'country` country ON address.id_country = country.id_country LEFT JOIN `'._DB_PREFIX_.'country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = '.(int)$this->context->language->id.') LEFT JOIN `'._DB_PREFIX_.'carrier` carrier ON a.id_carrier = carrier.id_carrier LEFT JOIN `'._DB_PREFIX_.'order_state` os ON (os.`id_order_state` = a.`current_state`) LEFT JOIN `'._DB_PREFIX_.'order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = '.(int)$this->context->language->id.')'; $this->_orderBy = 'id_order'; $this->_orderWay = 'DESC'; $this->_use_found_rows = true; $statuses = OrderState::getOrderStates((int)$this->context->language->id); foreach ($statuses as $status) { $this->statuses_array[$status['id_order_state']] = $status['name']; } $this->fields_list = array( 'id_order' => array( 'title' => $this->l('ID'), 'align' => 'text-center', 'class' => 'fixed-width-xs' ), 'reference' => array( 'title' => $this->l('Reference') ), 'new' => array( 'title' => $this->l('New client'), 'align' => 'text-center', 'type' => 'bool', 'tmpTableFilter' => true, 'orderby' => false, 'callback' => 'printNewCustomer' ), 'customer' => array( 'title' => $this->l('Customer'), 'havingFilter' => true, ), ); if (Configuration::get('PS_B2B_ENABLE')) { $this->fields_list = array_merge($this->fields_list, array( 'company' => array( 'title' => $this->l('Company'), 'filter_key' => 'c!company' ), )); } $this->fields_list = array_merge($this->fields_list, array( 'total_paid_tax_incl' => array( 'title' => $this->l('Total'), 'align' => 'text-right', 'type' => 'price', 'currency' => true, 'callback' => 'setOrderCurrency', 'badge_success' => true ), 'payment' => array( 'title' => $this->l('Payment') ), 'carriername' => array( 'title' => $this->l('Carrier'), 'type' => 'text', 'align' => 'text-center', 'class' => 'fixed-width-xl', 'filter_key' => 'carrier!name', 'filter_type' => 'text', 'order_key' => 'carrier!name' ), 'osname' => array( 'title' => $this->l('Status'), 'type' => 'select', 'color' => 'color', 'list' => $this->statuses_array, 'filter_key' => 'os!id_order_state', 'filter_type' => 'int', 'order_key' => 'osname' ), 'date_add' => array( 'title' => $this->l('Date'), 'align' => 'text-right', 'type' => 'datetime', 'filter_key' => 'a!date_add' ), 'id_pdf' => array( 'title' => $this->l('PDF'), 'align' => 'text-center', 'callback' => 'printPDFIcons', 'orderby' => false, 'search' => false, 'remove_onclick' => true ) )); if (Country::isCurrentlyUsed('country', true)) { $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT DISTINCT c.id_country, cl.`name` FROM `'._DB_PREFIX_.'orders` o '.Shop::addSqlAssociation('orders', 'o').' INNER JOIN `'._DB_PREFIX_.'address` a ON a.id_address = o.id_address_delivery INNER JOIN `'._DB_PREFIX_.'country` c ON a.id_country = c.id_country INNER JOIN `'._DB_PREFIX_.'country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = '.(int)$this->context->language->id.') ORDER BY cl.name ASC'); $country_array = array(); foreach ($result as $row) { $country_array[$row['id_country']] = $row['name']; } $part1 = array_slice($this->fields_list, 0, 3); $part2 = array_slice($this->fields_list, 3); $part1['cname'] = array( 'title' => $this->l('Delivery'), 'type' => 'select', 'list' => $country_array, 'filter_key' => 'country!id_country', 'filter_type' => 'int', 'order_key' => 'cname' ); $this->fields_list = array_merge($part1, $part2); } $this->shopLinkType = 'shop'; $this->shopShareDatas = Shop::SHARE_ORDER; if (Tools::isSubmit('id_order')) { // Save context (in order to apply cart rule) $order = new Order((int)Tools::getValue('id_order')); $this->context->cart = new Cart($order->id_cart); $this->context->customer = new Customer($order->id_customer); } $this->bulk_actions = array( 'updateOrderStatus' => array('text' => $this->l('Change Order Status'), 'icon' => 'icon-refresh') ); AdminController::__construct(); } }
-
-
Inserir DIV no footer
Borgas replied to Borgas's topic in PrestaShop Download: instalação, atualização e configuração
Obrigado pela resposta. Essa parte eu sei de atribuir nomes para identificar os divs. O que pretendia era inserir uma imagem "atrás" do div page. Mas resolvi o problema modules/themeconfigurator/theme4.css .columns-container { background: url(../img/footer.png) bottom no-repeat; background-color:#FFF; } -
Inserir DIV no footer
Borgas replied to Borgas's topic in PrestaShop Download: instalação, atualização e configuração
Já consegui adicionar a imagem conforme queria, mas não faz os 100% de largura como pretendia... modules/themeconfigurator/theme4.css .columns-container { background: url(../img/footer.png) bottom no-repeat; background-color:#FFF; }