find
Code: Select all
$this->data['filter_customer'] = $filter_customer;Code: Select all
$this->data['filter_group_customer'] = $filter_group_customer;Thanks! I got it working in 1.5.6.4
But it displays customer group id in order list page.
How can I change the column contents to customer group name?
But it displays customer group id in order list page.
How can I change the column contents to customer group name?
From my previous steps, replace this portion:Matahari_169 wrote:Thanks! I got it working in 1.5.6.4
But it displays customer group id in order list page.
How can I change the column contents to customer group name?
Code: Select all
$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, o.customer_group_id AS group_customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";
Code: Select all
$sql = "SELECT `o`.`order_id`, CONCAT(`o`.`firstname`, ' ', `o`.`lastname`) AS `customer`, (SELECT `gc`.`name` FROM `" . DB_PREFIX . "customer_group` `gc` WHERE `gc`.`customer_group_id` = `o`.`customer_group_id`) AS `group_customer`, (SELECT `os`.`name` FROM `" . DB_PREFIX . "order_status` `os` WHERE `os`.`order_status_id` = `o`.`order_status_id` AND `os`.`language_id` = '" . (int)$this->config->get('config_language_id') . "') AS `status`, `o`.`total`, `o`.`currency_code`, `o`.`currency_value`, `o`.`date_added`, `o`.`date_modified` FROM `" . DB_PREFIX . "order` `o`";
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Hi straightlight, thank you for your code. im using opencart 1.5.3.1 and had tried using the above code to achieve getting customer group name display on order list but i'm getting error from mysql saying table gc.name not exist.. I had successfully added a column "customer group" on sale page displaying customer group ID. I wish to get customer group name displayed.straightlight wrote:From my previous steps, replace this portion:Matahari_169 wrote:Thanks! I got it working in 1.5.6.4
But it displays customer group id in order list page.
How can I change the column contents to customer group name?
with:Code: Select all
$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, o.customer_group_id AS group_customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";
Code: Select all
$sql = "SELECT `o`.`order_id`, CONCAT(`o`.`firstname`, ' ', `o`.`lastname`) AS `customer`, (SELECT `gc`.`name` FROM `" . DB_PREFIX . "customer_group` `gc` WHERE `gc`.`customer_group_id` = `o`.`customer_group_id`) AS `group_customer`, (SELECT `os`.`name` FROM `" . DB_PREFIX . "order_status` `os` WHERE `os`.`order_status_id` = `o`.`order_status_id` AND `os`.`language_id` = '" . (int)$this->config->get('config_language_id') . "') AS `status`, `o`.`total`, `o`.`currency_code`, `o`.`currency_value`, `o`.`date_added`, `o`.`date_modified` FROM `" . DB_PREFIX . "order` `o`";
Any help is appreciated. Thank you.
Verify in your customer_group table if the name field does exist. In the v2.x releases, the name field would rather be located in the customer_group_description table.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
straightlight wrote:Verify in your customer_group table if the name field does exist. In the v2.x releases, the name field would rather be located in the customer_group_description table.
Thank you straightlight for your pointer. Solved.. Successfully display customer group name.
*For the benefit of others if anyone is having the same issue i face,
I'm using Opencart Version 1.5.3.1,
in <file name="admin/model/sale/order.php">
Code: Select all
<search position="replace" error="log"><![CDATA[$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";]]></search>
Code: Select all
<add><![CDATA[$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT gc.name FROM " . DB_PREFIX . "customer_group_description gc WHERE gc.customer_group_id = o.customer_group_id) AS group_customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";]]></add>ps, i wanted to upload the vqmod file but i dont know why cloudflare is blocking me from uploading.
anyway theres always alternative way, here is the link to the VQMOD http://pastebin.com/fscQGAHh
Code: Select all
<add><![CDATA[$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT gc.name FROM " . DB_PREFIX . "customer_group_description gc WHERE gc.customer_group_id = o.customer_group_id) AS group_customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";]]></add>
Code: Select all
<add><![CDATA[$sql = "SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT gc.name FROM " . DB_PREFIX . "customer_group_description gc WHERE gc.customer_group_id = o.customer_group_id) AS group_customer, (SELECT os.name FROM " . DB_PREFIX . "order_status os WHERE os.order_status_id = o.order_status_id AND `gc`.`language_id` = `os`.`language_id` AND os.language_id = '" . (int)$this->config->get('config_language_id') . "') AS status, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `" . DB_PREFIX . "order` o";]]></add>
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I wanted to create two columns - "Shipping_address_2" and "comment" in this view. I made all the changes to the four files and uploaded the changed files to the server. However there was no change visible in the order list. Is there anything else that one needs to do for the changes to become active
Hi
I am using V2.1.0.1. Would this work for this version. I have made all the suggested changes and uploaded the changed files (did not use vqMod). However there is no change in the order list.
I am adding two columns: Shipping_address_2 and Comment.
I am using V2.1.0.1. Would this work for this version. I have made all the suggested changes and uploaded the changed files (did not use vqMod). However there is no change in the order list.
I am adding two columns: Shipping_address_2 and Comment.
Who is online
Users browsing this forum: No registered users and 22 guests
