Artikel der Unter- / Unterkategorie in der Hauptkategorie darstellen

[localhorst]

Hallo,

ich habe nun modified eCommerce Shopsoftware in der Version 1.05-SP1d im lokalen Einsatz. Jedoch stehe ich vor dem Problem den Workaround von Elexyr in die /includes/modules/default.php einzubauen. Diese hat sich ja nun scheinbar grundlegend verändert. Kopiere ich die alte default.php zeigt er mir alle Produkte an.

Zur Zeit sieht meine default.php so aus:

Code: PHP  [Auswählen]

<?php
/* -----------------------------------------------------------------------------------------
   $Id: default.php 2774 2012-04-20 18:30:22Z web28 $

   modified eCommerce Shopsoftware - community made shopping
   http://www.modified eCommerce Shopsoftware.org

   Copyright (c) 2010 modified eCommerce Shopsoftware
  -----------------------------------------------------------------------------------------
  based on:
  (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
  (c) 2002-2003 osCommerce(default.php,v 1.84 2003/05/07); www.oscommerce.com
  (c) 2003 nextcommerce (default.php,v 1.11 2003/08/22); www.nextcommerce.org
  (c) 2006 xt:Commerce (cross_selling.php 1243 2005-09-25); www.(( Wir dulden keine kommerziellen Werbelinks - Bitte <a href="index.php?topic=3013.0">Forenregeln</a> beachten! ))

  Released under the GNU General Public License
  -----------------------------------------------------------------------------------------
  Third Party contributions:
  Enable_Disable_Categories 1.3        Autor: Mikel Williams | mikel@ladykatcostumes.com
  Customers Status v3.x  (c) 2002-2003 Copyright Elari elari@free.fr | www.unlockgsm.com/dload-osc/
  | CVS : http://cvs.sourceforge.net/cgi-bin/viewcvs...by=date#dirlist

  Released under the GNU General Public License
  ---------------------------------------------------------------------------------------*/

$default_smarty = new smarty;
$default_smarty->assign('tpl_path','templates/'.CURRENT_TEMPLATE.'/');
$default_smarty->assign('session', session_id());

// define defaults
$main_content = '';
$group_check = '';
$fsk_lock = '';

// include needed functions
require_once (DIR_FS_INC.'xtc_customer_greeting.inc.php');
require_once (DIR_FS_INC.'xtc_get_path.inc.php');
require_once (DIR_FS_INC.'xtc_check_categories_status.inc.php');
require_once (DIR_FS_INC.'xtc_get_subcategories.inc.php');

// check categorie exist
if (xtc_check_categories_status($current_category_id) >= 1) {
  $error = CATEGORIE_NOT_FOUND;
  include (DIR_WS_MODULES.FILENAME_ERROR_HANDLER);
  return;
}

/**
 * list of categories
 *
 */
if ($category_depth == 'nested') {

  if (GROUP_CHECK == 'true') {
    $group_check = "AND c.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";
  }

  $category_query = "-- /includes/modules/default.php
                     SELECT c.categories_image,
                            c.categories_template,
                            cd.categories_name,
                            cd.categories_heading_title,
                            cd.categories_description
                          FROM ".TABLE_CATEGORIES." c
                          JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd on cd.categories_id = c.categories_id
                          WHERE c.categories_id = '".$current_category_id."'
                            ".$group_check."
                            AND cd.language_id = '".(int) $_SESSION['languages_id']."'";
  $category_query = xtDBquery($category_query);
  $category = xtc_db_fetch_array($category_query, true);

  if (MAX_DISPLAY_CATEGORIES_PER_ROW > 0) {
    // check to see if there are deeper categories within the current category
    $categories_query = "-- /includes/modules/default.php
                         SELECT c.categories_id,
                                c.categories_image,
                                c.parent_id,
                                cd.categories_name,
                                cd.categories_heading_title,
                                cd.categories_description
                              FROM ".TABLE_CATEGORIES." c
                              JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd on cd.categories_id = c.categories_id
                              WHERE c.categories_status = '1'
                                ".$group_check."
                                AND c.parent_id = '".$current_category_id."'
                                AND cd.language_id = '".(int) $_SESSION['languages_id']."'
                              ORDER BY sort_order, cd.categories_name";
    $categories_query = xtDBquery($categories_query);
    $categories_content = array();
    while ($categories = xtc_db_fetch_array($categories_query, true)) {
      $cPath_new = xtc_category_link($categories['categories_id'],$categories['categories_name']);
      $image = '';
      if ($categories['categories_image'] != '') {
        $image = DIR_WS_IMAGES.'categories/'.$categories['categories_image'];
        if(!file_exists($image)) $image = DIR_WS_IMAGES.'categories/noimage.gif';
        $image = $image;
      }
      $categories_content[] = array ('CATEGORIES_NAME' => $categories['categories_name'],
                                     'CATEGORIES_HEADING_TITLE' => $categories['categories_heading_title'],
                                     'CATEGORIES_IMAGE' => $image,
                                     'CATEGORIES_LINK' => xtc_href_link(FILENAME_DEFAULT, $cPath_new),
                                     'CATEGORIES_DESCRIPTION' => $categories['categories_description']);
    }
  }

  $new_products_category_id = $current_category_id;
  include (DIR_WS_MODULES.FILENAME_NEW_PRODUCTS);

  $image = '';
  if ($category['categories_image'] != '') {
    $image = DIR_WS_IMAGES.'categories/'.$category['categories_image'];
    if(!file_exists($image)) $image = DIR_WS_IMAGES.'categories/noimage.gif';
    $image = $image;
  }
  // get default template
  if ($category['categories_template'] == '' || $category['categories_template'] == 'default') {
    $files = array ();
    $cl_dir = DIR_FS_CATALOG.'templates/'.CURRENT_TEMPLATE.'/module/categorie_listing/';
    if ($dir = opendir($cl_dir)) {
      while (($file = readdir($dir)) !== false) {
        if (is_file($cl_dir.$file) && (substr($file, 0, 1) != '.') && (substr($file, -5) == '.html') && ($file != 'index.html')) {
          $files[] = $file;
        }
      }
      closedir($dir);
    }
    sort($files);
    $category['categories_template'] = $files[0];
  }

  $max_per_row = MAX_DISPLAY_CATEGORIES_PER_ROW;
  $width = $max_per_row ? intval(100 / $max_per_row).'%' : '';
  $default_smarty->assign('TR_COLS', $max_per_row);
  $default_smarty->assign('TD_WIDTH', $width);
  $default_smarty->assign('CATEGORIES_NAME', $category['categories_name']);
  $default_smarty->assign('CATEGORIES_HEADING_TITLE', $category['categories_heading_title']);
  $default_smarty->assign('CATEGORIES_IMAGE', $image);
  $default_smarty->assign('CATEGORIES_DESCRIPTION', $category['categories_description']);
  $default_smarty->assign('language', $_SESSION['language']);
  $default_smarty->assign('module_content', $categories_content);
  $default_smarty->caching = 0;
  $main_content = $default_smarty->fetch(CURRENT_TEMPLATE.'/module/categorie_listing/'.$category['categories_template']);
  $smarty->assign('main_content', $main_content);


/**
  * list of products
  *
  */
} elseif ($category_depth == 'products' || (isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] > 0)) {

  $select = '';
  $from = '';
  $where = '';

  // fsk18 lock
  if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
    $fsk_lock = ' AND p.products_fsk18!=1';
  }
  // group check
  if (GROUP_CHECK == 'true') {
    $group_check = " AND p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";
  }
  // sorting query
  if (isset($_GET['manufacturers_id']) && isset($_GET['filter_id'])) {
    $categories_id = (int)$_GET['filter_id'];
  } else {
    $categories_id = $current_category_id;
  }
  $sorting_query = xtDBquery("-- /includes/modules/default.php
                              SELECT products_sorting,
                                     products_sorting2
                                FROM ".TABLE_CATEGORIES."
                               WHERE categories_id='".$categories_id ."'");
  $sorting_data = xtc_db_fetch_array($sorting_query,true);
  if (empty($sorting_data['products_sorting'])) { //Fallback für products_sorting auf products_name
    $sorting_data['products_sorting'] = 'pd.products_name';
  }
  if (empty($sorting_data['products_sorting2'])) { //Fallback für products_sorting2 auf ascending
    $sorting_data['products_sorting2'] = 'ASC';
  }
  $sorting = ' ORDER BY '.$sorting_data['products_sorting'].' '.$sorting_data['products_sorting2'].' ';

  if (isset($_GET['manufacturers_id'])) {
    // show the products of a specified manufacturer
    $select .= "m.manufacturers_name, ";
    $from   .= "LEFT JOIN ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id ";
    $where  .= " AND m.manufacturers_id = '".(int) $_GET['manufacturers_id']."' ";
    if (isset($_GET['filter_id']) && xtc_not_null($_GET['filter_id'])) {
      // We are asked to show only a specific category
      $from   .= "JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = pd.products_id ";
      $where  .= "AND p2c.categories_id = '".(int)$_GET['filter_id']."' ";
    } else {
      // We show them all
    }
  } else {
    // show the products in a given categorie
    $from   .= "JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = pd.products_id ";
    $where  .= "AND p2c.categories_id = '".$current_category_id."' ";
    if (isset($_GET['filter_id']) && xtc_not_null($_GET['filter_id'])) {
      // We are asked to show only specific catgeory
      $select .= "m.manufacturers_name, ";
      $from   .= "LEFT JOIN ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id ";
      $where  .= "AND m.manufacturers_id = '".(int)$_GET['filter_id']."' ";
    } else {
      // We show them all
        $cPathA = explode("_", $cPath);
        $size = sizeof($cPathA)-1;
        $subcategories_array = array();
        xtc_get_subcategories($subcategories_array, $cPathA[$size]);
        $size_sc = sizeof($subcategories_array); //Subcat count
        $cat_Search = "(";
        for($i = 0; $i <$size_sc; $i++){
          $cat_Search .= "p2c.categories_id = '" . $subcategories_array[$i] . "' or ";
        }
        $cat_Search .= "p2c.categories_id = '" . $cPathA[$size] . "'" . ")";
    }
  }
 
  $listing_sql = "-- /includes/modules/default.php
                  SELECT ".$select."
                         p.products_id,
                         p.products_ean,
                         p.products_quantity,
                         p.products_shippingtime,
                         p.products_model,
                         p.products_image,
                         p.products_price,
                         p.products_discount_allowed,
                         p.products_weight,
                         p.products_tax_class_id,
                         p.products_date_available,
                         p.manufacturers_id,
                         p.products_fsk18,
                         p.products_vpe,
                         p.products_vpe_status,
                         p.products_vpe_value,
                         pd.products_name,
                         pd.products_description,
                         pd.products_short_description
                       FROM ".TABLE_PRODUCTS_DESCRIPTION." pd
                       JOIN ".TABLE_PRODUCTS." p
                       ".$from."
                       WHERE p.products_status = '1'
                         AND p.products_id = pd.products_id
                         AND pd.language_id = '".(int) $_SESSION['languages_id']."'
                         AND ".$cat_Search."
                         ".$group_check."
                         ".$fsk_lock."
                         ".$where."
                         ".$sorting;
echo $cat_Search;
    // optional Product List Filter
  if (PRODUCT_LIST_FILTER == 'true') {
    if (isset($_GET['manufacturers_id'])) {
      $filterlist_sql = "-- /includes/modules/default.php
                         SELECT distinct c.categories_id as id,
                                         cd.categories_name as name
                                       FROM ".TABLE_PRODUCTS." p
                                       JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = p.products_id
                                       JOIN ".TABLE_CATEGORIES." c on c.categories_id = p2c.categories_id
                                       JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd on cd.categories_id = p2c.categories_id
                                       WHERE p.products_status = '1'
                                         AND cd.language_id = '".(int) $_SESSION['languages_id']."'
                                         AND p.manufacturers_id = '".(int) $_GET['manufacturers_id']."'
                                         ORDER BY cd.categories_name";
    } else {
      $filterlist_sql = "-- /includes/modules/default.php
                         SELECT distinct m.manufacturers_id as id,
                                         m.manufacturers_name as name
                                       FROM ".TABLE_PRODUCTS." p
                                       JOIN ".TABLE_PRODUCTS_TO_CATEGORIES." p2c on p2c.products_id = p.products_id
                                       JOIN ".TABLE_MANUFACTURERS." m on m.manufacturers_id = p.manufacturers_id
                                       WHERE p.products_status = '1'
                                         AND p2c.categories_id = '".$current_category_id."'
                                         ORDER BY m.manufacturers_name";
    }
    $filterlist_query = xtDBquery($filterlist_sql);
    if (xtc_db_num_rows($filterlist_query, true) > 1) {
      $manufacturer_dropdown = xtc_draw_form('filter', DIR_WS_CATALOG . FILENAME_DEFAULT, 'get');
      if (isset($_GET['manufacturers_id'])) {
        $manufacturer_dropdown .= xtc_draw_hidden_field('manufacturers_id', (int)$_GET['manufacturers_id']);
        $options = array (array ('id' => '', 'text' => TEXT_ALL_CATEGORIES)); // DokuMan - 2012-03-27 - added missing "id" for xtc_draw_pull_down_menu
      } else {
        $manufacturer_dropdown .= xtc_draw_hidden_field('cat', $current_category_id);
        $options = array (array ('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); // DokuMan - 2012-03-27 - added missing "id" for xtc_draw_pull_down_menu
      }
      $manufacturer_dropdown .= xtc_draw_hidden_field('sort', isset($_GET['sort']) ? $_GET['sort'] : '');
      $manufacturer_dropdown .= xtc_hide_session_id()  .PHP_EOL; //Session ID nur anhängen, wenn Cookies deaktiviert sind

      while ($filterlist = xtc_db_fetch_array($filterlist_query, true)) {
        $options[] = array ('id' => $filterlist['id'], 'text' => $filterlist['name']);
      }
      $manufacturer_dropdown .= xtc_draw_pull_down_menu('filter_id', $options, isset($_GET['filter_id']) ? (int)$_GET['filter_id'] : '', 'onchange="this.form.submit()"');
      $manufacturer_dropdown .= '<noscript><input type="submit" value="'.SMALL_IMAGE_BUTTON_VIEW.'" id="filter_submit" /></noscript>';
      $manufacturer_dropdown .= '</form>'."\n";
    }
  }

  include (DIR_WS_MODULES.FILENAME_PRODUCT_LISTING);


/**
  * default content page
  *
  */
} else {

  if (GROUP_CHECK == 'true') {
    $group_check = "AND group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";
  }
  $shop_content_query = xtDBquery("-- /includes/modules/default.php
                                   SELECT content_title,
                                          content_heading,
                                          content_text,
                                          content_file
                                        FROM ".TABLE_CONTENT_MANAGER."
                                        WHERE content_group='5'
                                          ".$group_check."
                                          AND languages_id='".(int) $_SESSION['languages_id']."'");
  $shop_content_data = xtc_db_fetch_array($shop_content_query,true);

  $default_smarty->assign('title', $shop_content_data['content_heading']);

  include (DIR_WS_INCLUDES.FILENAME_CENTER_MODULES);

  if ($shop_content_data['content_file'] != '') {
    ob_start();
    if (strpos($shop_content_data['content_file'], '.txt')) {
      echo '<pre>';
    }
    include (DIR_FS_CATALOG.'media/content/'.$shop_content_data['content_file']);
    if (strpos($shop_content_data['content_file'], '.txt')){
      echo '</pre>';
    }
    $shop_content_data['content_text'] = ob_get_contents();
    ob_end_clean();
  }

  $default_smarty->assign('text', str_replace('{$greeting}', xtc_customer_greeting(), $shop_content_data['content_text']));
  $default_smarty->assign('language', $_SESSION['language']);

  // set cache ID
  if (!CacheCheck()) {
    $default_smarty->caching = 0;
    $main_content = $default_smarty->fetch(CURRENT_TEMPLATE.'/module/main_content.html');
  } else {
    $default_smarty->caching = 1;
    $default_smarty->cache_lifetime = CACHE_LIFETIME;
    $default_smarty->cache_modified_check = CACHE_CHECK;
    $cache_id = $_SESSION['language'].$_SESSION['currency'].$_SESSION['customer_id'];
    $main_content = $default_smarty->fetch(CURRENT_TEMPLATE.'/module/main_content.html', $cache_id);
  }
  $smarty->assign('main_content', $main_content);
}
 

Vielen Dank im Voraus!

[Holzer]

Hallo! vor langer Zeit wurde diese Frage gepostet... gibt es heute (im Jahre 2013) eine Lösung? 

Hallo Zusammen,

ich habe da auch noch ein ähnliches Problem:

Artikel Holzlaufrad ist in den Kategorien "Holzlaufrad", "Holzspielzeug nach alter", "Holzspielzeug nach Farben".

So jetzt das Problem:

Der letzte Link mit dem ich den Artikel aufrufe ist immer mit der Kategorie Holzspielzeug nach Farben verknüpft. ( http://www.wooodys.de/Holzspielzeug-nach-Farben/Holzlaufrad-Pony-Bike-Adrian::295.html )

Er soll aber mit seiner Kategorie (Holzlaufrad) auftauchen.

Wie bewerkstellige ich das?

[HaldOn]

Hallo Zusammen,

habe das untenstehende Lösung von Elexyr in 1.5 SP1d implementiert.

Jetzt habe ich nur noch das Problem wenn sich ein Artikel in zwei Unterkategorien der selben Hauptkategorie befindet wird dieser dann 2x in der Hauptkategorie angezeigt.
Leider weiss ich nicht, wie ich es lösen könnte das der Artikel nur einmal in der Hauptkategorie ausgegenen wird.

Für Hilfe wäre ich Dankbar.

... so, der Lösung wieder einen Schritt weiter:

in der "index.php":

Code: PHP  [Auswählen]

if ($cateqories_products['total']> 0) {

hiermit ersetzen:

Code: PHP  [Auswählen]

if (xtc_count_products_in_category($cPath)> 0) {

Dann in der "/includes/modules/default.php" am Anfang folgendes einfügen:

Code: PHP  [Auswählen]

require_once (DIR_FS_INC.'xtc_get_subcategories.inc.php');

im Bereich der Abfrage

Code: PHP  [Auswählen]

  // show the products in a given categorie

in der ELSE Schleife nach //sorting query und //we show them all (ca. Zeile 467) folgendes VOR der $listing_sql einfügen:

Code: PHP  [Auswählen]

   $cPathA = explode("_", $cPath);
   $size = sizeof($cPathA)-1;
   $subcategories_array = array();
   xtc_get_subcategories($subcategories_array, $cPathA[$size]);
   $size_sc = sizeof($subcategories_array); //Subcat count
   $cat_Search = "(";
   for($i = 0; $i <$size_sc; $i++){
      $cat_Search .= "p2c.categories_id = '" . $subcategories_array[$i] . "' or ";
   }
   $cat_Search .= "p2c.categories_id = '" . $cPathA[$size] . "'" . ")";

Dann muss noch das listing am Ende geändert werden:

Code: PHP  [Auswählen]

[...]
                                  ".$fsk_lock."
                                  and pd.language_id = '".(int) $_SESSION['languages_id']."' and " . $cat_Search . "
                                  ".$sorting;

... damit werden ALLE Artikel (auch in den Unterkategorien) angezeigt.

Einen Schönheitsfehler hab ich aber noch:

In der gleichen Datei soll vor

Code: PHP  [Auswählen]

include (DIR_WS_MODULES.FILENAME_PRODUCT_LISTING);

folgendes eingefügt werden:

Code: PHP  [Auswählen]

<!-- BOF: Show subcategories in Product Listing -->
<div><table border="0" width="100%" cellspacing="0" cellpadding="2"><tr>
      <?php
          if ($_GET['manufacturers_id'] == '')
         {
                 if (isset($cPath)) {
         if (ereg('_', $cPath)) {
            $category_links = array_reverse($cPath_array);
            $cat_to_search = $category_links[0];
            }
         else {
            $cat_to_search = $cPath;
            }
          // check to see if there are deeper categories within the current category
           $categories_query = xtc_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $cat_to_search . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' order by sort_order, cd.categories_name");
             if (xtc_db_num_rows($categories_query)> 0 ) {
                $rows = 0;
               while ($categories = xtc_db_fetch_array($categories_query)) {
                   $rows++;
                  $cPath_new = xtc_get_path($categories['categories_id']);
                  $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
                  echo '                <td align="center" class="smallText" style="width: ' . $width . '" valign="top"><a href="' . xtc_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . xtc_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";
                  if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != xtc_db_num_rows($categories_query))) {
                     echo '              </tr>' . "\n";
                     echo '              <tr>' . "\n";
                     }
               }
            }
      }
         }
         else
         {
         echo "";
         }
         ?>
</tr></table></div>
<!-- EOF: Show subcategories in Product Listing -->
 

[hpzeller]

Hallo redcan

Also ich habe jetzt den Thread nicht durchgelesen, aber wenn es um folgendes geht

Jetzt habe ich nur noch das Problem wenn sich ein Artikel in zwei Unterkategorien der selben Hauptkategorie befindet wird dieser dann 2x in der Hauptkategorie angezeigt.

Dann kannst du das versuchen:

Ersetze folgenden Code

Code: PHP  [Auswählen]

           $categories_query = xtc_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $cat_to_search . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' order by sort_order, cd.categories_name");

durch diesen Code

Code: PHP  [Auswählen]

           $categories_query = xtc_db_query("select distinct c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $cat_to_search . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' order by sort_order, cd.categories_name");

Gruss
Hanspeter

[HaldOn]

Hallo Hanspeter,

vielen Dank für die schnelle Antwort!
Ich werde es nachher mal testen.

[muellerundmueller]

Ich kram das mal aus. Hat das mal einer auf die aktuelle Shopversion 1.06 angepasst?

[web0null]

Hast du es schon probiert in der aktuellen Shopversion?

Gruß