How to show customer group in checkout email?

Code: Select all

$_['text_new_email']  			= 'Email:';

Code: Select all

$_['text_customer_group']  		= 'Customer Group:';

Code: Select all

$subject = sprintf($language->get('text_new_subject'), $order_info['store_name'], $order_id);

Code: Select all

$this->load->model('account/customer_group');
$customer_info = $this->model_account_customer->getCustomer($order_info['customer_id']);
$customer_group = $this->model_account_customer_group->getCustomerGroup($customer_info['customer_group_id']);

Code: Select all

$template->data['text_email'] = $language->get('text_new_email');

Code: Select all

$template->data['text_customer_group'] = $language->get('text_customer_group');
$template->data['customer_group'] = $customer_group['name'];

Code: Select all

<b><?php echo $text_email; ?></b> <?php echo $email; ?><br />

Code: Select all

<b><?php echo $text_customer_group; ?></b> <?php echo $customer_group; ?><br />

Code: Select all

<?php
class ModelAccountCustomerGroup extends Model {
	public function getCustomerGroup($customer_group_id) {
		$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "customer_group cg LEFT JOIN " . DB_PREFIX . "customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cg.customer_group_id = '" . (int)$customer_group_id . "' AND cgd.language_id = '" . (int)$this->config->get('config_language_id') . "'");
		
		return $query->row;
	}

	public function getCustomerGroups() {
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer_group cg LEFT JOIN " . DB_PREFIX . "customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY cg.sort_order ASC, cgd.name ASC");
		
		return $query->rows;
	}
}
?>

Code: Select all

$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "customer_group WHERE customer_group_id = '" . (int)$customer_group_id . "'");

Code: Select all

$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "customer_group cg LEFT JOIN " . DB_PREFIX . "customer_group_description cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cg.customer_group_id = '" . (int)$customer_group_id . "' AND cgd.language_id = '" . (int)$this->config->get('config_language_id') . "'");