예제 #1
0
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 .= "&nbsp;&nbsp;&nbsp;";
    }
    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;
}
예제 #2
0
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;
 }