PHP Order::getCustomerNbOrders方法代码示例

 public function renderView()
 {
     $this->tpl_view_vars['query'] = Tools::safeOutput($this->query);
     $this->tpl_view_vars['show_toolbar'] = true;
     if (count($this->errors)) {
         return parent::renderView();
     } else {
         $nb_results = 0;
         foreach ($this->_list as $list) {
             if ($list != false) {
                 $nb_results += count($list);
             }
         }
         $this->tpl_view_vars['nb_results'] = $nb_results;
         if (isset($this->_list['features']) && count($this->_list['features'])) {
             $this->tpl_view_vars['features'] = $this->_list['features'];
         }
         if (isset($this->_list['categories']) && count($this->_list['categories'])) {
             $categories = array();
             foreach ($this->_list['categories'] as $category) {
                 $categories[] = getPath($this->context->link->getAdminLink('AdminCategories', false), $category['id_category']);
             }
             $this->tpl_view_vars['categories'] = $categories;
         }
         if (isset($this->_list['products']) && count($this->_list['products'])) {
             $view = '';
             $this->initProductList();
             $helper = new HelperList();
             $helper->shopLinkType = '';
             $helper->simple_header = true;
             $helper->identifier = 'id_product';
             $helper->actions = array('edit');
             $helper->show_toolbar = false;
             $helper->table = 'product';
             $helper->currentIndex = $this->context->link->getAdminLink('AdminProducts', false);
             $helper->token = Tools::getAdminTokenLite('AdminProducts');
             if ($this->_list['products']) {
                 $view = $helper->generateList($this->_list['products'], $this->fields_list['products']);
             }
             $this->tpl_view_vars['products'] = $view;
         }
         if (isset($this->_list['customers']) && count($this->_list['customers'])) {
             $view = '';
             $this->initCustomerList();
             $helper = new HelperList();
             $helper->shopLinkType = '';
             $helper->simple_header = true;
             $helper->identifier = 'id_customer';
             $helper->actions = array('edit', 'view');
             $helper->show_toolbar = false;
             $helper->table = 'customer';
             $helper->currentIndex = $this->context->link->getAdminLink('AdminCustomers', false);
             $helper->token = Tools::getAdminTokenLite('AdminCustomers');
             if ($this->_list['customers']) {
                 foreach ($this->_list['customers'] as $key => $val) {
                     $this->_list['customers'][$key]['orders'] = Order::getCustomerNbOrders((int) $val['id_customer']);
                 }
                 $view = $helper->generateList($this->_list['customers'], $this->fields_list['customers']);
             }
             $this->tpl_view_vars['customers'] = $view;
         }
         if (isset($this->_list['orders']) && count($this->_list['orders'])) {
             $view = '';
             $this->initOrderList();
             $helper = new HelperList();
             $helper->shopLinkType = '';
             $helper->simple_header = true;
             $helper->identifier = 'id_order';
             $helper->actions = array('view');
             $helper->show_toolbar = false;
             $helper->table = 'order';
             $helper->currentIndex = $this->context->link->getAdminLink('AdminOrders', false);
             $helper->token = Tools::getAdminTokenLite('AdminOrders');
             if ($this->_list['orders']) {
                 $view = $helper->generateList($this->_list['orders'], $this->fields_list['orders']);
             }
             $this->tpl_view_vars['orders'] = $view;
         }
         if (isset($this->_list['modules']) && count($this->_list['modules'])) {
             $this->tpl_view_vars['modules'] = $this->_list['modules'];
         }
         if (isset($this->_list['addons']) && count($this->_list['addons'])) {
             $this->tpl_view_vars['addons'] = $this->_list['addons'];
         }
         return parent::renderView();
     }
 }

    public function viewgroup()
    {
        global $cookie;
        $currentIndex = 'index.php?tab=AdminGroups';
        $obj = $this->loadObject(true);
        $group = new Group(intval($obj->id));
        $defaultLanguage = intval(Configuration::get('PS_LANG_DEFAULT'));
        echo '
		<fieldset style="width: 400px">
			<div style="float: right"><a href="' . $currentIndex . '&updategroup&id_group=' . $obj->id . '&token=' . $this->token . '"><img src="../img/admin/edit.gif" /></a></div>
			<span style="font-weight: bold; font-size: 14px;">' . strval($obj->name[intval($cookie->id_lang)]) . '</span>
			<div class="clear">&nbsp;</div>
			' . $this->l('Reduction:') . ' ' . floatval($obj->reduction) . $this->l('%') . '
		</fieldset>
		<div class="clear">&nbsp;</div>';
        $customers = $obj->getCustomers();
        $this->fieldsDisplay = array('ID' => array('title' => $this->l('ID')), 'sex' => array('title' => $this->l('Sex')), 'name' => array('title' => $this->l('Name')), 'e-mail' => array('title' => $this->l('e-mail')), 'birthdate' => array('title' => $this->l('Birth date')), 'register_date' => array('title' => $this->l('Register date')), 'orders' => array('title' => $this->l('Orders')), 'status' => array('title' => $this->l('Status')), 'actions' => array('title' => $this->l('Actions')));
        if (isset($customers) and !empty($customers) and $nbCustomers = sizeof($customers)) {
            echo '<h2>' . $this->l('Customers member of this group') . ' (' . $nbCustomers . ')</h2>
			<table cellspacing="0" cellpadding="0" class="table widthfull">
				<tr>';
            foreach ($this->fieldsDisplay as $field) {
                echo '<th' . (isset($field['width']) ? 'style="width: ' . $field['width'] . '"' : '') . '>' . $field['title'] . '</th>';
            }
            echo '
				</tr>';
            $irow = 0;
            foreach ($customers as $k => $customer) {
                $imgGender = $customer['id_gender'] == 1 ? '<img src="../img/admin/male.gif" alt="' . $this->l('Male') . '" />' : ($customer['id_gender'] == 2 ? '<img src="../img/admin/female.gif" alt="' . $this->l('Female') . '" />' : '');
                echo '
				<tr class="' . ($irow++ % 2 ? 'alt_row' : '') . '">
					<td>' . $customer['id_customer'] . '</td>
					<td class="center">' . $imgGender . '</td>
					<td>' . stripslashes($customer['lastname']) . ' ' . stripslashes($customer['firstname']) . '</td>
					<td>' . stripslashes($customer['email']) . '<a href="mailto:' . stripslashes($customer['email']) . '"> <img src="../img/admin/email_edit.gif" alt="' . $this->l('Write to this customer') . '" /></a></td>
					<td>' . Tools::displayDate($customer['birthday'], intval($cookie->id_lang)) . '</td>
					<td>' . Tools::displayDate($customer['date_add'], intval($cookie->id_lang)) . '</td>
					<td>' . Order::getCustomerNbOrders($customer['id_customer']) . '</td>
					<td class="center"><img src="../img/admin/' . ($customer['active'] ? 'enabled.gif' : 'forbbiden.gif') . '" alt="" /></td>
					<td class="center" width="60px">
						<a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&viewcustomer&token=' . Tools::getAdminToken('AdminCustomers' . intval(Tab::getIdFromClassName('AdminCustomers')) . intval($cookie->id_employee)) . '">
						<img src="../img/admin/details.gif" alt="' . $this->l('View orders') . '" /></a>
						<a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&addcustomer&token=' . Tools::getAdminToken('AdminCustomers' . intval(Tab::getIdFromClassName('AdminCustomers')) . intval($cookie->id_employee)) . '">
						<img src="../img/admin/edit.gif" alt="' . $this->l('Modify this customer') . '" /></a>
						<a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&deletecustomer&token=' . Tools::getAdminToken('AdminCustomers' . intval(Tab::getIdFromClassName('AdminCustomers')) . intval($cookie->id_employee)) . '" onclick="return confirm(\'' . $this->l('Are you sure?', __CLASS__, true, false) . '\');">
						<img src="../img/admin/delete.gif" alt="' . $this->l('Delete this customer') . '" /></a>
					</td>
				</tr>';
            }
            echo '</table>';
        }
    }

    public function display()
    {
        global $cookie;
        $currentIndex = 'index.php';
        $currency = new Currency(Configuration::get('PS_CURRENCY_DEFAULT'));
        $query = trim(Tools::getValue('bo_query'));
        $nbCategories = $nbProducts = $nbCustomers = 0;
        /* Display categories if any has been matching */
        if (isset($this->_list['categories']) and $nbCategories = sizeof($this->_list['categories'])) {
            echo '<h3>' . $nbCategories . ' ' . ($nbCategories > 1 ? $this->l('categories found with') : $this->l('category found with')) . ' <b>"' . Tools::htmlentitiesUTF8($query) . '"</b></h3>';
            echo '<table cellspacing="0" cellpadding="0" class="table">';
            $irow = 0;
            foreach ($this->_list['categories'] as $k => $category) {
                echo '<tr class="' . ($irow++ % 2 ? 'alt_row' : '') . '"><td>' . rtrim(getPath($currentIndex . '?tab=AdminCatalog', $category['id_category'], '', $query), ' >') . '</td></tr>';
            }
            echo '</table>
			<div class="clear">&nbsp;</div>';
        }
        /* Display products if any has been matching */
        if (isset($this->_list['products']) and !empty($this->_list['products']) and $nbProducts = sizeof($this->_list['products'])) {
            echo '<h3>' . $nbProducts . ' ' . ($nbProducts > 1 ? $this->l('products found with') : $this->l('product found with')) . ' <b>"' . Tools::htmlentitiesUTF8($query) . '"</b></h3>
			<table class="table" cellpadding="0" cellspacing="0">
				<tr>';
            foreach ($this->fieldsDisplay['catalog'] as $field) {
                echo '<th' . (isset($field['width']) ? 'style="width: ' . $field['width'] . '"' : '') . '>' . $field['title'] . '</th>';
            }
            echo '</tr>';
            foreach ($this->_list['products'] as $k => $product) {
                echo '
				<tr>
					<td>' . $product['id_product'] . '</td>
					<td align="center">' . ($product['manufacturer_name'] != NULL ? stripslashes($product['manufacturer_name']) : '--') . '</td>
					<td>' . $product['reference'] . '</td>
					<td><a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&addproduct&token=' . Tools::getAdminToken('AdminCatalog' . (int) Tab::getIdFromClassName('AdminCatalog') . (int) $cookie->id_employee) . '">' . stripslashes($product['nameh']) . '</a></td>
					<td>' . Tools::displayPrice($product['price'], $currency) . '</td>
					<td>' . stripslashes($product['tax_name']) . '</td>
					<td align="center">' . $product['quantity'] . '</td>
					<td align="center">' . $product['weight'] . ' ' . Configuration::get('PS_WEIGHT_UNIT') . '</td>
					<td align="center"><a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&status&token=' . Tools::getAdminToken('AdminCatalog' . (int) Tab::getIdFromClassName('AdminCatalog') . (int) $cookie->id_employee) . '">
					<img src="../img/admin/' . ($product['active'] ? 'enabled.gif' : 'forbbiden.gif') . '" alt="" /></a></td>
					<td>
						<a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&addproduct&token=' . Tools::getAdminToken('AdminCatalog' . (int) Tab::getIdFromClassName('AdminCatalog') . (int) $cookie->id_employee) . '">
						<img src="../img/admin/edit.gif" alt="' . $this->l('Modify this product') . '" /></a>&nbsp;
						<a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&deleteproduct&token=' . Tools::getAdminToken('AdminCatalog' . (int) Tab::getIdFromClassName('AdminCatalog') . (int) $cookie->id_employee) . '"
							onclick="return confirm(\'' . $this->l('Do you want to delete this product?', __CLASS__, true, false) . ' (' . addslashes($product['name']) . ')\');">
						<img src="../img/admin/delete.gif" alt="' . $this->l('Delete this product') . '" /></a>
					</td>
				</tr>';
            }
            echo '</table>
			<div class="clear">&nbsp;</div>';
        }
        /* Display customers if any has been matching */
        if (isset($this->_list['customers']) and !empty($this->_list['customers']) and $nbCustomers = sizeof($this->_list['customers'])) {
            echo '<h3>' . $nbCustomers . ' ' . ($nbCustomers > 1 ? $this->l('customers') : $this->l('customer')) . ' ' . $this->l('found with') . ' <b>"' . Tools::htmlentitiesUTF8($query) . '"</b></h3>
			<table cellspacing="0" cellpadding="0" class="table widthfull">
				<tr>';
            foreach ($this->fieldsDisplay['customers'] as $field) {
                echo '<th' . (isset($field['width']) ? 'style="width: ' . $field['width'] . '"' : '') . '>' . $field['title'] . '</th>';
            }
            echo '</tr>';
            $irow = 0;
            foreach ($this->_list['customers'] as $k => $customer) {
                $imgGender = $customer['id_gender'] == 1 ? '<img src="../img/admin/male.gif" alt="' . $this->l('Male') . '" />' : ($customer['id_gender'] == 2 ? '<img src="../img/admin/female.gif" alt="' . $this->l('Female') . '" />' : '');
                echo '
				<tr class="' . ($irow++ % 2 ? 'alt_row' : '') . '">
					<td>' . $customer['id_customer'] . '</td>
					<td class="center">' . $imgGender . '</td>
					<td>' . stripslashes($customer['lastname']) . ' ' . stripslashes($customer['firstname']) . '</td>
					<td>' . stripslashes($customer['email']) . '<a href="mailto:' . stripslashes($customer['email']) . '"> <img src="../img/admin/email_edit.gif" alt="' . $this->l('Write to this customer') . '" /></a></td>
					<td>' . Tools::displayDate($customer['birthday'], (int) $cookie->id_lang) . '</td>
					<td>' . Tools::displayDate($customer['date_add'], (int) $cookie->id_lang) . '</td>
					<td>' . Order::getCustomerNbOrders($customer['id_customer']) . '</td>
					<td class="center"><img src="../img/admin/' . ($customer['active'] ? 'enabled.gif' : 'forbbiden.gif') . '" alt="" /></td>
					<td class="center" width="60px">
						<a href="' . $currentIndex . '?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&viewcustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '">
						<img src="../img/admin/details.gif" alt="' . $this->l('View orders') . '" /></a>
						<a href="' . $currentIndex . '?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&addcustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '">
						<img src="../img/admin/edit.gif" alt="' . $this->l('Modify this customer') . '" /></a>
						<a href="' . $currentIndex . '?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&deletecustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '" onclick="return confirm(\'' . $this->l('Are you sure?', __CLASS__, true, false) . '\');">
						<img src="../img/admin/delete.gif" alt="' . $this->l('Delete this customer') . '" /></a>
					</td>
				</tr>';
            }
            echo '</table>
			<div class="clear">&nbsp;</div>';
        }
        /* Display error if nothing has been matching */
        if (!$nbCategories and !$nbProducts and !$nbCustomers) {
            echo '<h3>' . $this->l('Nothing found for') . ' "' . Tools::htmlentitiesUTF8($query) . '"</h3>';
        }
    }

    public function viewgroup()
    {
        global $cookie;
        $currentIndex = 'index.php?tab=AdminGroups';
        if (!($obj = $this->loadObject(true))) {
            return;
        }
        $defaultLanguage = (int) Configuration::get('PS_LANG_DEFAULT');
        echo '
		<fieldset style="width: 400px">
			<div style="float: right"><a href="' . $currentIndex . '&updategroup&id_group=' . $obj->id . '&token=' . $this->token . '"><img src="../img/admin/edit.gif" /></a></div>
			<span style="font-weight: bold; font-size: 14px;">' . strval($obj->name[(int) $cookie->id_lang]) . '</span>
			<div class="clear">&nbsp;</div>
			' . $this->l('Discount:') . ' ' . (double) $obj->reduction . $this->l('%') . '
		</fieldset>
		<div class="clear">&nbsp;</div>';
        $this->fieldsDisplay = array('ID' => array('title' => $this->l('ID')), 'sex' => array('title' => $this->l('Sex')), 'name' => array('title' => $this->l('Name')), 'e-mail' => array('title' => $this->l('e-mail')), 'birthdate' => array('title' => $this->l('Birth date')), 'register_date' => array('title' => $this->l('Registration date')), 'orders' => array('title' => $this->l('Orders')), 'status' => array('title' => $this->l('Status')), 'actions' => array('title' => $this->l('Actions')));
        if ($nbCustomers = $obj->getCustomers(true)) {
            echo '<h2>' . $this->l('Customer members of this group') . ' (' . $nbCustomers . ')</h2>';
            // Pagination Begin
            $customersPerPage = Tools::getValue('customerPerPage') ? (int) Tools::getValue('customerPerPage') : 50;
            $totalPages = ceil($nbCustomers / $customersPerPage);
            $perPageOptions = array(20, 50, 100, 300);
            $customerPageIndex = Tools::getValue('customerPageIndex') && Tools::getValue('customerPageIndex') <= $totalPages ? (int) Tools::getValue('customerPageIndex') : 1;
            $from = Tools::getValue('customerPageIndex') ? ((int) $customerPageIndex - 1) * (int) $customersPerPage : 0;
            $customers = $obj->getCustomers(false, $from, $customersPerPage);
            echo '<table><tr>
				<form method="post" action="' . Tools::htmlentitiesUTF8($_SERVER['REQUEST_URI']) . '">
				<td style="vertical-align: bottom;"><span style="float: left; height:30px">';
            if ($customerPageIndex > 1) {
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=1" src="../img/admin/list-prev2.gif">&nbsp';
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=' . ($customerPageIndex - 1) . '" src="../img/admin/list-prev.gif">&nbsp';
            }
            echo 'Page <b><select onChange="submit()" name="customerPageIndex" id="customerPageIndex">';
            for ($i = 1; $i <= $totalPages; $i++) {
                echo '<option value="' . $i . '"' . ((int) $customerPageIndex === $i ? 'selected="selected"' : '') . '>' . $i . '</option>';
            }
            echo '</select></b> / ' . $totalPages;
            if ($customerPageIndex < $totalPages) {
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=' . ((int) $customerPageIndex + 1) . '" src="../img/admin/list-next.gif">';
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=' . $totalPages . '" src="../img/admin/list-next2.gif">';
            }
            echo '			| Display
						<select onchange="document.getElementById(\'customerPageIndex\').value=1; submit();" name="customerPerPage">';
            foreach ($perPageOptions as $option) {
                echo '<option value="' . $option . '"' . ((int) $customersPerPage == $option ? 'selected="selected"' : '') . '>' . $option . '</option>';
            }
            echo '	</select> / ' . $nbCustomers . ' result(s)	
					</span><span class="clear"></span></td>
				</form>
			</tr>
			</table>
			<div class="clear"></div>';
            // Pagination End
            echo '<table cellspacing="0" cellpadding="0" class="table widthfull">
				<tr>';
            foreach ($this->fieldsDisplay as $field) {
                echo '<th' . (isset($field['width']) ? 'style="width: ' . $field['width'] . '"' : '') . '>' . $field['title'] . '</th>';
            }
            echo '
				</tr>';
            $irow = 0;
            foreach ($customers as $k => $customer) {
                $imgGender = $customer['id_gender'] == 1 ? '<img src="../img/admin/male.gif" alt="' . $this->l('Male') . '" />' : ($customer['id_gender'] == 2 ? '<img src="../img/admin/female.gif" alt="' . $this->l('Female') . '" />' : '');
                echo '
				<tr class="' . ($irow++ % 2 ? 'alt_row' : '') . '">
					<td>' . $customer['id_customer'] . '</td>
					<td class="center">' . $imgGender . '</td>
					<td>' . stripslashes($customer['lastname']) . ' ' . stripslashes($customer['firstname']) . '</td>
					<td>' . stripslashes($customer['email']) . '<a href="mailto:' . stripslashes($customer['email']) . '"> <img src="../img/admin/email_edit.gif" alt="' . $this->l('Write to this customer') . '" /></a></td>
					<td>' . Tools::displayDate($customer['birthday'], (int) $cookie->id_lang) . '</td>
					<td>' . Tools::displayDate($customer['date_add'], (int) $cookie->id_lang) . '</td>
					<td>' . Order::getCustomerNbOrders($customer['id_customer']) . '</td>
					<td class="center"><img src="../img/admin/' . ($customer['active'] ? 'enabled.gif' : 'forbbiden.gif') . '" alt="" /></td>
					<td class="center" width="60px">
						<a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&viewcustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '">
						<img src="../img/admin/details.gif" alt="' . $this->l('View orders') . '" /></a>
						<a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&addcustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '">
						<img src="../img/admin/edit.gif" alt="' . $this->l('Modify this customer') . '" /></a>
						<a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&deletecustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '" onclick="return confirm(\'' . $this->l('Are you sure?', __CLASS__, true, false) . '\');">
						<img src="../img/admin/delete.gif" alt="' . $this->l('Delete this customer') . '" /></a>
					</td>
				</tr>';
            }
            echo '</table>';
        } else {
            echo '<p><img src="../img/admin/information.png" style="float:left;margin-right:5px;" alt="" /> ' . $this->l('No user in this group.') . '</p>';
        }
    }

//.........这里部分代码省略.........
                $f = fopen($target_path, 'r');
                //read header to get the search strings
                $line = fgetcsv($f);
                $lines = array();
                while ($line = fgetcsv($f)) {
                    $lines[] = $line;
                }
                $updatedCustomerIds = array();
                foreach ($lines as $line) {
                    $customerEmail = $line[0];
                    $sql = "select cus.id_customer , cusg.id_group from ps_customer cus left join ps_customer_group cusg on (cusg.id_customer = cus.id_customer) where cus.email = '" . $customerEmail . "'";
                    $result = Db::getInstance()->ExecuteS($sql);
                    $customerId = null;
                    $groups = array();
                    foreach ($result as $k => $row) {
                        if (!empty($row['id_group'])) {
                            array_push($groups, $row['id_group']);
                        }
                        $customerId = $row['id_customer'];
                    }
                    if (!in_array($id_group1, $groups)) {
                        $sql = "insert into ps_customer_group values ({$customerId} , {$id_group1})";
                        $result = Db::getInstance()->ExecuteS($sql);
                        array_push($updatedCustomerIds, $customerId);
                    }
                }
                $smarty->assign('updated_rows', count($customerId));
            }
        }
        $this->fieldsDisplay = array('ID' => array('title' => $this->l('ID')), 'sex' => array('title' => $this->l('Sex')), 'name' => array('title' => $this->l('Name')), 'e-mail' => array('title' => $this->l('e-mail')), 'birthdate' => array('title' => $this->l('Birth date')), 'register_date' => array('title' => $this->l('Registration date')), 'orders' => array('title' => $this->l('Orders')), 'status' => array('title' => $this->l('Status')), 'actions' => array('title' => $this->l('Actions')));
        if ($nbCustomers = $obj->getCustomers(true)) {
            echo '<h2>' . $this->l('Customer members of this group') . ' (' . $nbCustomers . ')</h2>';
            // Pagination Begin
            $customersPerPage = Tools::getValue('customerPerPage') ? (int) Tools::getValue('customerPerPage') : 50;
            $totalPages = ceil($nbCustomers / $customersPerPage);
            $perPageOptions = array(20, 50, 100, 300);
            $customerPageIndex = Tools::getValue('customerPageIndex') && Tools::getValue('customerPageIndex') <= $totalPages ? (int) Tools::getValue('customerPageIndex') : 1;
            $from = Tools::getValue('customerPageIndex') ? ((int) $customerPageIndex - 1) * (int) $customersPerPage : 0;
            $customers = $obj->getCustomers(false, $from, $customersPerPage);
            echo '<tr>
                            <form method="post" action="' . Tools::htmlentitiesUTF8($_SERVER['REQUEST_URI']) . '">
                            <td style="vertical-align: bottom;"><span style="float: left; height:30px">';
            if ($customerPageIndex > 1) {
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=1" src="../img/admin/list-prev2.gif">&nbsp';
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=' . ($customerPageIndex - 1) . '" src="../img/admin/list-prev.gif">&nbsp';
            }
            echo 'Page <b><select onChange="submit()" name="customerPageIndex" id="customerPageIndex">';
            for ($i = 1; $i <= $totalPages; $i++) {
                echo '<option value="' . $i . '"' . ((int) $customerPageIndex === $i ? 'selected="selected"' : '') . '>' . $i . '</option>';
            }
            echo '</select></b> / ' . $totalPages;
            if ($customerPageIndex < $totalPages) {
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=' . ((int) $customerPageIndex + 1) . '" src="../img/admin/list-next.gif">';
                echo '&nbsp<input type="image" onclick="document.getElementById(\'customerPageIndex\').value=' . $totalPages . '" src="../img/admin/list-next2.gif">';
            }
            echo '			| Display
                                            <select onchange="document.getElementById(\'customerPageIndex\').value=1; submit();" name="customerPerPage">';
            foreach ($perPageOptions as $option) {
                echo '<option value="' . $option . '"' . ((int) $customersPerPage == $option ? 'selected="selected"' : '') . '>' . $option . '</option>';
            }
            echo '	</select> / ' . $nbCustomers . ' result(s)	
                                    </span><span class="clear"></span></td>
                            </form>
                    </tr>';
            // Pagination End
            echo '<table cellspacing="0" cellpadding="0" class="table widthfull">
                            <tr>';
            foreach ($this->fieldsDisplay as $field) {
                echo '<th' . (isset($field['width']) ? 'style="width: ' . $field['width'] . '"' : '') . '>' . $field['title'] . '</th>';
            }
            echo '
                            </tr>';
            $irow = 0;
            foreach ($customers as $k => $customer) {
                $imgGender = $customer['id_gender'] == 1 ? '<img src="../img/admin/male.gif" alt="' . $this->l('Male') . '" />' : ($customer['id_gender'] == 2 ? '<img src="../img/admin/female.gif" alt="' . $this->l('Female') . '" />' : '');
                echo '
                            <tr class="' . ($irow++ % 2 ? 'alt_row' : '') . '">
                                    <td>' . $customer['id_customer'] . '</td>
                                    <td class="center">' . $imgGender . '</td>
                                    <td>' . stripslashes($customer['lastname']) . ' ' . stripslashes($customer['firstname']) . '</td>
                                    <td>' . stripslashes($customer['email']) . '<a href="mailto:' . stripslashes($customer['email']) . '"> <img src="../img/admin/email_edit.gif" alt="' . $this->l('Write to this customer') . '" /></a></td>
                                    <td>' . Tools::displayDate($customer['birthday'], (int) $cookie->id_lang) . '</td>
                                    <td>' . Tools::displayDate($customer['date_add'], (int) $cookie->id_lang) . '</td>
                                    <td>' . Order::getCustomerNbOrders($customer['id_customer']) . '</td>
                                    <td class="center"><img src="../img/admin/' . ($customer['active'] ? 'enabled.gif' : 'forbbiden.gif') . '" alt="" /></td>
                                    <td class="center" width="60px">
                                            <a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&viewcustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '">
                                            <img src="../img/admin/details.gif" alt="' . $this->l('View orders') . '" /></a>
                                            <a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&addcustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '">
                                            <img src="../img/admin/edit.gif" alt="' . $this->l('Modify this customer') . '" /></a>
                                            <a href="index.php?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&deletecustomer&token=' . Tools::getAdminToken('AdminCustomers' . (int) Tab::getIdFromClassName('AdminCustomers') . (int) $cookie->id_employee) . '" onclick="return confirm(\'' . $this->l('Are you sure?', __CLASS__, true, false) . '\');">
                                            <img src="../img/admin/delete.gif" alt="' . $this->l('Delete this customer') . '" /></a>
                                    </td>
                            </tr>';
            }
            echo '</table>';
        } else {
            echo '<p><img src="../img/admin/information.png" style="float:left;margin-right:5px;" alt="" /> ' . $this->l('No user in this group.') . '</p>';
        }
    }

    public function display()
    {
        global $cookie;
        $currentIndex = 'index.php';
        $currency = new Currency(Configuration::get('PS_CURRENCY_DEFAULT'));
        $query = isset($_POST['bo_query']) ? trim(strval($_POST['bo_query'])) : '';
        /* Display categories if any has been matching */
        if (isset($this->_list['categories']) and $nbCategories = sizeof($this->_list['categories'])) {
            echo '<h3>' . $nbCategories . ' ' . ($nbCategories > 1 ? $this->l('categories found with') : $this->l('category found with')) . ' <b>"' . $query . '"</b></h3>';
            echo '
			<table cellspacing="0" cellpadding="0" class="table">';
            $irow = 0;
            foreach ($this->_list['categories'] as $k => $category) {
                echo '<tr class="' . ($irow++ % 2 ? 'alt_row' : '') . '"><td>' . rtrim(getPath($currentIndex . '?tab=AdminCatalog', $category['id_category'], '', $query), ' >') . '</td></tr>';
            }
            echo '</table><br /><br />';
        } else {
            $nbCategories = 0;
        }
        /* Display products if any has been matching */
        if (isset($this->_list['products']) and !empty($this->_list['products']) and $nbProducts = sizeof($this->_list['products'])) {
            echo '<h3>' . $nbProducts . ' ' . ($nbProducts > 1 ? $this->l('products found with') : $this->l('product found with')) . ' <b>"' . $query . '"</b></h3>
			<table class="table" cellpadding="0" cellspacing="0">
				<tr>';
            foreach ($this->fieldsDisplay as $field) {
                echo '<th' . (isset($field['width']) ? 'style="width: ' . $field['width'] . '"' : '') . '>' . $field['title'] . '</th>';
            }
            echo '
				</tr>';
            foreach ($this->_list['products'] as $k => $product) {
                echo '
				<tr>
					<td>' . $product['id_product'] . '</td>
					<td align="center">' . ($product['manufacturer_name'] != NULL ? stripslashes($product['manufacturer_name']) : '--') . '</td>
					<td>' . $product['reference'] . '</td>
					<td><a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&addproduct&token=' . Tools::getAdminToken('AdminCatalog' . intval(Tab::getIdFromClassName('AdminCatalog')) . intval($cookie->id_employee)) . '">' . stripslashes($product['nameh']) . '</a></td>
					<td>' . Tools::displayPrice($product['price'], $currency) . '</td>
					<td>' . stripslashes($product['tax_name']) . '</td>
					<td align="center">' . $product['quantity'] . '</td>
					<td align="center">' . $product['weight'] . ' ' . Configuration::get('PS_WEIGHT_UNIT') . '</td>
					<td align="center"><a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&status&token=' . Tools::getAdminToken('AdminCatalog' . intval(Tab::getIdFromClassName('AdminCatalog')) . intval($cookie->id_employee)) . '">
					<img src="../img/admin/' . ($product['active'] ? 'enabled.gif' : 'forbbiden.gif') . '" alt="" /></a></td>
					<td>
						<a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&addproduct&token=' . Tools::getAdminToken('AdminCatalog' . intval(Tab::getIdFromClassName('AdminCatalog')) . intval($cookie->id_employee)) . '">
						<img src="../img/admin/edit.gif" alt="' . $this->l('Modify this product') . '" /></a>&nbsp;
						<a href="' . $currentIndex . '?tab=AdminCatalog&id_product=' . $product['id_product'] . '&deleteproduct&token=' . Tools::getAdminToken('AdminCatalog' . intval(Tab::getIdFromClassName('AdminCatalog')) . intval($cookie->id_employee)) . '" onclick="return confirm(\'' . $this->l('Do you want to delete', __CLASS__, true, false) . ' ' . addslashes($product['name']) . $this->l('?', __CLASS__, true, false) . '\');">
						<img src="../img/admin/delete.gif" alt="' . $this->l('Delete this product') . '" /></a>
					</td>
				</tr>';
            }
            echo '</table>';
        } else {
            $nbProducts = 0;
        }
        /* Display customers if any has been matching */
        if (isset($this->_list['customers']) and !empty($this->_list['customers']) and $nbCustomers = sizeof($this->_list['customers'])) {
            echo '<h3>' . $nbCustomers . ' ' . ($nbCustomers > 1 ? $this->l('customers') : $this->l('customer')) . ' ' . $this->l('found with') . ' <b>"' . $query . '"</b></h3>
			<table cellspacing="0" cellpadding="0" class="table widthfull">
				<tr>';
            foreach ($this->fieldsDisplay as $field) {
                echo '<th' . (isset($field['width']) ? 'style="width: ' . $field['width'] . '"' : '') . '>' . $field['title'] . '</th>';
            }
            echo '
				</tr>';
            $irow = 0;
            foreach ($this->_list['customers'] as $k => $customer) {
                $imgGender = $customer['id_gender'] == 1 ? '<img src="../img/admin/male.gif" alt="' . $this->l('Male') . '" />' : ($customer['id_gender'] == 2 ? '<img src="../img/admin/female.gif" alt="' . $this->l('Female') . '" />' : '');
                echo '
				<tr class="' . ($irow++ % 2 ? 'alt_row' : '') . '">
					<td>' . $customer['id_customer'] . '</td>
					<td class="center">' . $imgGender . '</td>
					<td>' . stripslashes($customer['lastname']) . ' ' . stripslashes($customer['firstname']) . '</td>
					<td>' . stripslashes($customer['email']) . '<a href="mailto:' . stripslashes($customer['email']) . '"> <img src="../img/admin/email_edit.gif" alt="' . $this->l('Write to this customer') . '" /></a></td>
					<td>' . Tools::displayDate($customer['birthday'], intval($cookie->id_lang)) . '</td>
					<td>' . Tools::displayDate($customer['date_add'], intval($cookie->id_lang)) . '</td>
					<td>' . Order::getCustomerNbOrders($customer['id_customer']) . '</td>
					<td class="center"><img src="../img/admin/' . ($customer['active'] ? 'enabled.gif' : 'forbbiden.gif') . '" alt="" /></td>
					<td class="center" width="60px">
						<a href="' . $currentIndex . '?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&viewcustomer&token=' . Tools::getAdminToken('AdminCustomers' . intval(Tab::getIdFromClassName('AdminCustomers')) . intval($cookie->id_employee)) . '">
						<img src="../img/admin/details.gif" alt="' . $this->l('View orders') . '" /></a>
						<a href="' . $currentIndex . '?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&addcustomer&token=' . Tools::getAdminToken('AdminCustomers' . intval(Tab::getIdFromClassName('AdminCustomers')) . intval($cookie->id_employee)) . '">
						<img src="../img/admin/edit.gif" alt="' . $this->l('Modify this customer') . '" /></a>
						<a href="' . $currentIndex . '?tab=AdminCustomers&id_customer=' . $customer['id_customer'] . '&deletecustomer&token=' . Tools::getAdminToken('AdminCustomers' . intval(Tab::getIdFromClassName('AdminCustomers')) . intval($cookie->id_employee)) . '" onclick="return confirm(\'' . $this->l('Are you sure?', __CLASS__, true, false) . '\');">
						<img src="../img/admin/delete.gif" alt="' . $this->l('Delete this customer') . '" /></a>
					</td>
				</tr>';
            }
            echo '</table>';
        } else {
            $nbCustomers = 0;
        }
        if (isset($this->_list['cart'])) {
            $cart = $this->_list['cart'];
            $products = $cart->getProducts();
            $discounts = $cart->getDiscounts();
            $total_discounts = $cart->getOrderTotal(false, 2);
            $total_shipping = $cart->getOrderShippingCost($cart->id_carrier);
            $total_wrapping = $cart->getOrderTotal(true, 6);
            $total_products = $cart->getOrderTotal(true, 1);
            $total_price = $cart->getOrderTotal();
//.........这里部分代码省略.........