Einzelner Hersteller ausblenden wenn kein Artikel vorhanden

[TF101]

Moin,

eine Frage, evtl hatte ja jemand schon das Problem.
Ist es möglich einzelne Hersteller(namen) in der Box manufacturers auszublenden, wenn kein Artikel dort vorhanden ist? Also evtl eine Abfrage in der manufacturers.php aus source/boxes/

Grüße
Tom

Linkback: https://www.modified-shop.org/forum/index.php?topic=32571.0

[Gulliver72]

In meinem jugendlichen Leichtsinn würde ich das so schreiben. Ist aber ungetestet.

Code: PHP  [Auswählen]

    $manufacturers_query = "select distinct m.manufacturers_id, m.manufacturers_name from ".TABLE_MANUFACTURERS." as m, ".TABLE_PRODUCTS." as p where m.manufacturers_id=p.manufacturers_id order by m.manufacturers_name";
    $manufacturers_query = xtDBquery($manufacturers_query);
    if (xtc_db_num_rows($manufacturers_query, true) <= MAX_DISPLAY_MANUFACTURERS_IN_A_LIST) {
      // Display a list
      $manufacturers_list = '';
      while ($manufacturers = xtc_db_fetch_array($manufacturers_query, true)) {
        // BOF Bert hat der Hersteller aktive Artikel, dann erstelle Link
        $active_manufacturers_query = "select products_id from ".TABLE_PRODUCTS." where manufacturers_id=$manufacturers['manufacturers_id'] and products_status=1";
        $active_manufacturers_query = xtDBquery($active_manufacturers_query);
        if (xtc_db_num_rows($active_manufacturers_query, true) > 0) {
        // EOF Bert hat der Hersteller aktive Artikel, dann erstelle Link
          $manufacturers_name = ((strlen($manufacturers['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($manufacturers['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN).'..' : $manufacturers['manufacturers_name']);
          if (isset ($_GET['manufacturers_id']) && ($_GET['manufacturers_id'] == $manufacturers['manufacturers_id'])) {
            $manufacturers_name = '<strong>'.$manufacturers_name.'</strong>';
          }
          $manufacturers_list .= '<a href="'.xtc_href_link(DIR_WS_CATALOG . FILENAME_DEFAULT, 'manufacturers_id='.$manufacturers['manufacturers_id']).'">'.$manufacturers_name.'</a><br />'; //DokuMan - 2010-09-30 - added DIR_WS_CATALOG for manufacturer_dropdown to work properly
        }
      }
      $box_content = $manufacturers_list;
    } else {
      // Display a drop-down
      $manufacturers_array = array ();
      if (MAX_MANUFACTURERS_LIST < 2) {
        $manufacturers_array[] = array ('id' => '', 'text' => PULL_DOWN_DEFAULT);
      }
      while ($manufacturers = xtc_db_fetch_array($manufacturers_query, true)) {
        // BOF Bert hat der Hersteller aktive Artikel, dann erstelle Link
        $active_manufacturers_query = "select products_id from ".TABLE_PRODUCTS." where manufacturers_id=$manufacturers['manufacturers_id'] and products_status=1";
        $active_manufacturers_query = xtDBquery($active_manufacturers_query);
        if (xtc_db_num_rows($active_manufacturers_query, true) > 0) {
        // EOF Bert hat der Hersteller aktive Artikel, dann erstelle Link
          $manufacturers_name = ((strlen($manufacturers['manufacturers_name']) > MAX_DISPLAY_MANUFACTURER_NAME_LEN) ? substr($manufacturers['manufacturers_name'], 0, MAX_DISPLAY_MANUFACTURER_NAME_LEN).'..' : $manufacturers['manufacturers_name']);
          $manufacturers_array[] = array ('id' => xtc_href_link(FILENAME_DEFAULT,xtc_manufacturer_link($manufacturers['manufacturers_id'],$manufacturers['manufacturers_name'])), 'text' => $manufacturers_name);
        }
      }

[karsta.de]

Nur Hersteller mit Artikel anzeigen =>

[TF101]

Moin,

vielen Dank! Das hat funktioniert!

Grüße Tom