function arbreOptionRub($depart, $niveau, $prubrique, $nbprod = 0, $ok = 1, $lang = false) { $rec = ""; $espace = ""; $niveau++; $trubrique = new Rubrique(); $query = "select * from {$trubrique->table} where parent=\"{$depart}\""; $resul = CacheBase::getCache()->query($query); for ($i = 0; $i < $niveau; $i++) { $espace .= " "; } if ($resul == "" || count($resul) == 0) { return ""; } foreach ($resul as $row) { $trubriquedesc = new Rubriquedesc(); $trubriquedesc->charger($row->id, $lang); if (!$trubriquedesc->affichage_back_office_permis()) { continue; } $trubrique->charger($trubriquedesc->rubrique); $courante = new Rubrique(); $courante->charger($prubrique); if ($courante->parent == $row->id) { $selected = "selected"; } else { $selected = ""; } if ($ok == 0 || $row->id == $prubrique && $ok != -1) { $disabled = "disabled=\"disabled\""; } else { $disabled = ""; } if ($nbprod && $trubrique->nbprod() || !$nbprod) { $rec .= "<option value=\"{$row->id}\" {$disabled} {$selected}>" . $espace . $trubriquedesc->titre . "</option>"; } if ($prubrique == $row->id && $ok != -1 || $ok == 0) { $rec .= arbreOptionRub($row->id, $niveau, $prubrique, $nbprod, 0, $lang); } else { $rec .= arbreOptionRub($row->id, $niveau, $prubrique, $nbprod, $ok, $lang); } } return $rec; }
function liste_rubriques($parent, $critere, $order, $alpha) { $rubrique = new Rubrique(); $rubriquedesc = new Rubriquedesc(); if ($alpha == "alpha") { $query = "select r.id, r.ligne, r.classement from {$rubrique->table} r LEFT JOIN {$rubriquedesc->table} rd ON rd.rubrique=r.id and lang=" . ActionsLang::instance()->get_id_langue_courante() . " where r.parent=\"{$parent}\" order by rd.{$critere} {$order}"; } else { $query = "select id, ligne, classement from {$rubrique->table} where parent=\"{$parent}\" order by {$critere} {$order}"; } $resul = $rubrique->query($query); $i = 0; while ($resul && ($row = $rubrique->fetch_object($resul))) { $rubriquedesc = new Rubriquedesc(); $rubriquedesc->charger($row->id); if (!$rubriquedesc->affichage_back_office_permis()) { continue; } $fond = "ligne_" . ($i++ % 2 ? "claire" : "fonce") . "_rub"; ?> <ul class="<?php echo $fond; ?> "> <li style="width:623px;"><span id="titrerub_<?php echo $row->id; ?> " <?php if ($rubriquedesc->est_langue_courante()) { echo 'class="texte_edit"'; } ?> ><?php echo substr($rubriquedesc->titre, 0, 80); if (strlen($rubriquedesc->titre) > 80) { echo " ..."; } ?> </span></li> <li style="width:53px;"><input type="checkbox" id="rub_ligne_<?php echo $row->ref; ?> " name="ligne[]" class="sytle_checkbox" onchange="checkvalues('lignerub','<?php echo $row->id; ?> ')" <?php if ($row->ligne) { ?> checked="checked" <?php } ?> /></li> <li style="width:54px;"><?php if ($rubriquedesc->rubrique) { ?> <a href="parcourir.php?parent=<?php echo $row->id; ?> " ><?php echo trad('parcourir', 'admin'); ?> </a><?php } ?> </li> <li style="width:34px;"><a href="rubrique_modifier.php?id=<?php echo $row->id; ?> " class="txt_vert_11"><?php echo trad('editer', 'admin'); ?> </a></li> <li style="width:71px;"> <div class="bloc_classement"> <div class="classement"><a href="rubrique_modifier.php?id=<?php echo $row->id; ?> &action=modclassement&parent=<?php echo $parent; ?> &type=M"><img src="gfx/up.gif" border="0" /></a></div> <div class="classement"><span id="classementrub_<?php echo $row->id; ?> " class="classement_edit"><?php echo $row->classement; ?> </span></div> <div class="classement"><a href="rubrique_modifier.php?id=<?php echo $row->id; ?> &action=modclassement&parent=<?php echo $parent; ?> &type=D"><img src="gfx/dn.gif" border="0" /></a></div> </div> </li> <li style="width:37px; text-align:center;"><a href="javascript:supprimer_rubrique('<?php echo $row->id; ?> ','<?php echo $parent; ?> ')"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li> </ul> <?php } }
public function getList($parent, $critere, $order, $alpha) { $return = array(); $rubriquedesc = new Rubriquedesc(); if ($alpha == "alpha") { $query = "select r.id, r.ligne, r.classement from " . Rubrique::TABLE . " r LEFT JOIN " . Rubriquedesc::TABLE . " rd ON rd.rubrique=r.id and lang=" . ActionsLang::instance()->get_id_langue_courante() . " where r.parent=\"{$parent}\" order by rd.{$critere} {$order}"; } else { $query = "select id, ligne, classement from " . Rubrique::TABLE . " where parent=\"{$parent}\" order by {$critere} {$order}"; } $resul = $this->query($query); $i = 0; while ($resul && ($row = $this->fetch_object($resul))) { $rubriquedesc = new Rubriquedesc(); $rubriquedesc->charger($row->id); if (!$rubriquedesc->affichage_back_office_permis()) { continue; } $return[] = array("id" => $row->id, "ligne" => $row->ligne, "classement" => $row->classement, "titre" => $rubriquedesc->titre, "langue_courante" => $rubriquedesc->est_langue_courante(), "parent" => $parent); } return $return; }