Img des catégories mères&filles dans la boxe catégories, ---| Résolu & optimisé ! |--- Options

[cocomino]

hello,
bon comme j'ai pas la science infuse, je pose la question.
Je travaille sur la boxe catégories (pas des plus simples à modifier) et souhaite afficher l'image de la catégorie active dedans.
donc je suis parti du code original de la boxe categories et j'ai ajouté après :

Code

tep_show_category($first_element);

  $info_box_contents = array();
  $info_box_contents[] = array('text' => $categories_string);

ceci :

Code

if ($cPath>0){  
  $info_box_contents[] = array('text' => tep_image(DIR_WS_IMAGES . tep_get_category_image($categories_image), tep_get_category_image($categories_name), 128, 128));
  
  }

évidemment, la fonction tep_get_category_image n'existe pas, donc je l'ai créé dans le fichier general.php :

Code

////
// Return a category image  
  function tep_get_category_image($language = '') {
    global $languages_id;
    global $current_category_id;    
    if (empty($language)) $language = $languages_id;    
    $category_image_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
    $category_image = tep_db_fetch_array($category_image_query);    
    return $category_image['categories_image'];    
  }
////

la question que je me pose, c'est est ce que j'ai pas réinventé la roue ? n'y a t'il pas une autre solution en exploitant déjà le code existant de la boxe, voir des fonctions natives d'oscommerce ? j'ai pas mal trituré mes poves méninges, mais à mon niveau, j'ai vu que ça... Qu'en pensez vous ?

'ci les zamis !

cdt

[cocomino]

non, j'ai pas besoin de l'exploder, le $cPath est toujours un entier avec mon code.
regarde je te mets le code de la boxe categories que j'exploite actuellement :

Code

<?php
/*
  $Id: categories.php 1739 2007-12-20 00:52:16Z hpdl $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/
  
  function tep_show_category($counter) {
    global $tree, $categories_string, $cPath_array, $current_category_id;

    for ($i=0; $i<$tree[$counter]['level']; $i++) {
      $categories_string .= "&nbsp;&nbsp;";
    }

    $categories_string .= '<a href="';

    if ($tree[$counter]['parent'] == 0) {
      $cPath_new = 'cPath=' . $counter;
      } else {
      $cPath_new = 'cPath=' . $tree[$counter]['path'];
    }

    $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">';

    if (isset($cPath_array) && in_array($counter, $cPath_array)) {
      $categories_string .= '<b>';
    }

// display category name
    $categories_string .= $tree[$counter]['name'];

    if (isset($cPath_array) && in_array($counter, $cPath_array)) {
      $categories_string .= '</b>';
    }

    if (tep_has_category_subcategories($counter)) {
      $categories_string .= '';
    }

    $categories_string .= '</a>';

    if (SHOW_COUNTS == 'true') {
      $products_in_category = tep_count_products_in_category($counter);
      if ($products_in_category > 0) {
        $categories_string .= '&nbsp;(' . $products_in_category . ')';
      }
    }

    $categories_string .= '<br>';

    if ($tree[$counter]['next_id'] != false) {
      tep_show_category($tree[$counter]['next_id']);
    
    }
  }
?>
<!-- categories //-->
          <tr>
            <td>
<?php
  $info_box_contents = array();
  $info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES);
  
  new infoBoxHeading($info_box_contents, true, true);

  $categories_string = '';
  $tree = array();
  
  //$categories_query = tep_db_query("select c.categories_id, c.categories_image, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, c.parent_id, cd.categories_name");
  $categories_query = tep_db_query("select c.categories_id, c.categories_image, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$cPath . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name");
  
  while ($categories = tep_db_fetch_array($categories_query))  {  
    $tree[$categories['categories_id']] = array('name' => $categories['categories_name'],
                                                'image' => $categories['categories_image'],
                                                'parent' => $categories['parent_id'],
                                                'level' => 0,
                                                'path' => $categories['categories_id'],
                                                'next_id' => false);
    
    if (isset($parent_id)) {
      $tree[$parent_id]['next_id'] = $categories['categories_id'];
    }
    
    
    $parent_id = $categories['categories_id'];
    
    if (!isset($first_element)) {
      $first_element = $categories['categories_id'];
      
      
     }
    
  }

  //------------------------
  if (tep_not_null($cPath)) {
    $new_path = '';
    reset($cPath_array);
    while (list($key, $value) = each($cPath_array)) {
      
      unset($parent_id);
      unset($first_id);
      $categories_query = tep_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 = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name");
      if (tep_db_num_rows($categories_query)) {
        $new_path .= $value;
        while ($row = tep_db_fetch_array($categories_query)) {
          $tree[$row['categories_id']] = array('name' => $row['categories_name'],
                                               'image' => $row['categories_image'],
                                               'parent' => $row['parent_id'],
                                               'level' => $key+1,
                                               'path' => $new_path . '_' . $row['categories_id'],
                                               'next_id' => false);

          if (isset($parent_id)) {
            $tree[$parent_id]['next_id'] = $row['categories_id'];
          }
          

          $parent_id = $row['categories_id'];

          if (!isset($first_id)) {
            $first_id = $row['categories_id'];
          }

          $last_id = $row['categories_id'];
        }
        
        $tree[$last_id]['next_id'] = $tree[$value]['next_id'];
        $tree[$value]['next_id'] = $first_id;
        $new_path .= '_';
      } else {
        break;
      }
    }
  }

  tep_show_category($first_element);

  $info_box_contents = array();
  $info_box_contents[] = array('text' => $categories_string);
  
  if ($cPath > 0) {

  // le $cPath est toujours un entier et correspond à la current_category_id

  echo $cPath;

// fin du com pour gentag;o)
  $info_box_contents[] = array('text' => tep_image(DIR_WS_IMAGES . tep_get_category_image($categories_image), tep_get_category_image($categories_name), 128, 128));
  }else{  
  $info_box_contents[] = array('text' => tep_image(DIR_WS_IMAGES. $tree[$current_category_id]['image'], $tree[$current_category_id]['name'], 128, 128));
  }
  new infoBox($info_box_contents);  
?>
            </td>
          </tr>
<!-- categories_eof //-->

d'ailleurs, en mettant dans le fichier general.php (code corrigé sur les conseil de shoprun) :

Code

function tep_get_category_image($categories_id) {
    global $languages_id;
    global $current_category_id;    
    if (empty($language)) $language = $languages_id;    
    $category_image_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
    $category_image = tep_db_fetch_array($category_image_query);    
    return $category_image['categories_image'];    
  }

et que tu mets à la place de :

Code

$info_box_contents[] = array('text' => tep_image(DIR_WS_IMAGES . tep_get_category_image($categories_image), tep_get_category_image($categories_name), 128, 128));

ça :

Code

  $info_box_contents[] = array('text' => tep_image(DIR_WS_IMAGES . tep_get_category_image($cPath), tep_get_category_image($categories_name), 128, 128));

tu obtiens le même résultat.


question à 1000 croquettes au poisson : comment exploiter avec le tableau $tree cette valeur $cPath comme une $categories_id pour appeler l'image qui lui correspond ? (pas d'égalité sur $cpath , ça fait foirer le script)

Ce message a été modifié par coconimo - 12 Sep 2008, 15:27.