1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
public static function getSousCategories()
{
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT DISTINCT c.id_category, cl.name, c.id_parent
FROM '._DB_PREFIX_.'category c, '._DB_PREFIX_.'category_lang cl
WHERE c.id_category=cl.id_category
AND cl.id_lang = '.(int) 1);
return $result;
}
public static function afficher_arbre($parent, $niveau, $array) {
$retour = '';
$niveau_precedent = 0;
if (!$niveau && !$niveau_precedent){
$retour .= '<ul>';
}
foreach ($array as $noeud) {
if ($parent == $noeud['id_parent']) {
if ($niveau_precedent < $niveau){
$retour .= '<ul>';
}
$retour .= '<li>' . $noeud['libelle'];
$niveau_precedent = $niveau;
$retour .= self::afficher_arbre($noeud['id_categorie'], ($niveau + 1), $array);
}
}
if (($niveau_precedent == $niveau) && ($niveau_precedent != 0)){
$retour .= '</ul></li>';
}else if ($niveau_precedent == $niveau){
$retour .= '</ul>';
}else{
$retour .= '</li>';
}
return $retour;
} |
Partager