[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * record_companies sidebox - displays list of record companies for customer to filter products on

   4   *

   5   * @package templateSystem

   6   * @copyright Copyright 2003-2005 Zen Cart Development Team

   7   * @copyright Portions Copyright 2003 osCommerce

   8   * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

   9   * @version $Id: record_companies.php 2834 2006-01-11 22:16:37Z birdbrain $

  10   */
  11  
  12    $record_company_query = "select record_company_id, record_company_name
  13                            from " . TABLE_RECORD_COMPANY . "
  14                            order by record_company_name";
  15  
  16    $record_company = $db->Execute($record_company_query);
  17  
  18    if ($record_company->RecordCount()>0) {
  19      $number_of_rows = $record_company->RecordCount()+1;
  20  
  21  // Display a list

  22      $record_company_array = array();
  23      if (!isset($_GET['record_company_id']) || $_GET['record_company_id'] == '' ) {
  24        $record_company_array[] = array('id' => '', 'text' => PULL_DOWN_ALL);
  25      } else {
  26        $record_company_array[] = array('id' => '', 'text' => PULL_DOWN_RECORD_COMPANIES);
  27      }
  28  
  29      while (!$record_company->EOF) {
  30        $record_company_name = ((strlen($record_company->fields['record_company_name']) > MAX_DISPLAY_RECORD_COMPANY_NAME_LEN) ? substr($record_company->fields['record_company_name'], 0, MAX_DISPLAY_RECORD_COMPANY_NAME_LEN) . '..' : $record_company->fields['record_company_name']);
  31        $record_company_array[] = array('id' => $record_company->fields['record_company_id'],
  32                                         'text' => $record_company_name);
  33  
  34        $record_company->MoveNext();
  35      }
  36        require($template->get_template_dir('tpl_record_company_select.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_record_company_select.php');
  37  
  38      $title = '<label>' . BOX_HEADING_RECORD_COMPANY . '</label>';
  39      $title_link = false;
  40      require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  41    }
  42  ?>