function lister_contenus($parent, $critere, $order, $alpha)
{
$contenu = new Contenu();
$contenudesc = new Contenudesc();
if ($alpha == "alpha") {
$query = "select c.id, c.ligne, c.classement from {$contenu->table} c LEFT JOIN {$contenudesc->table} cd ON cd.contenu = c.id and lang=" . ActionsLang::instance()->get_id_langue_courante() . " where dossier=\"{$parent}\" order by cd.{$critere} {$order}";
} else {
$query = "select id, ligne, classement from {$contenu->table} where dossier=\"{$parent}\" order by {$critere} {$order}";
}
$resul = $contenu->query($query);
$i = 0;
while ($resul && ($row = $contenu->fetch_object($resul))) {
$contenudesc = new Contenudesc();
$contenudesc->charger($row->id);
if (!$contenudesc->affichage_back_office_permis()) {
continue;
}
$fond = "ligne_" . ($i++ % 2 ? "claire" : "fonce") . "_rub";
?>
<ul class="<?php
echo $fond;
?>
">
<li style="width:627px;">
<span id="titrecont_<?php
echo $row->id;
?>
" <?php
if ($contenudesc->est_langue_courante()) {
echo 'class="texte_edit"';
}
?>
><?php
echo substr($contenudesc->titre, 0, 90);
if (strlen($contenudesc->titre) > 90) {
echo " ...";
}
?>
</span></li>
<li style="width:54px;">
<input type="checkbox" id="cont_ligne_<?php
echo $row->id;
?>
" name="ligne[]" class="sytle_checkbox" onchange="checkvalues('lignecont','<?php
echo $row->id;
?>
')" <?php
if ($row->ligne) {
?>
checked="checked" <?php
}
?>
/>
</li>
<li style="width:54px;"></li>
<li style="width:34px;"><a href="contenu_modifier.php?id=<?php
echo $row->id;
?>
&dossier=<?php
echo $parent;
?>
" class="txt_vert_11"><?php
echo trad('editer', 'admin');
?>
</a></li>
<li style="width:71px;">
<div class="bloc_classement">
<div class="classement"><a href="contenu_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="classementcontenu_<?php
echo $row->id;
?>
" class="contenudos_edit"><?php
echo $row->classement;
?>
</span></div>
<div class="classement"><a href="contenu_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_contenu('<?php
echo $row->id;
?>
', '<?php
echo $parent;
?>
');"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li>
</ul>
<?php
}
}
/**
*
* Return an array of content for the current folder
*
* @param string $dossier id of the current folder
* @param string $critere order by clause
* @param string $order ASC or DESC
* @param string $alpha if order is alpha pu "alpha"
* @return Array
*/
public function getList($dossier, $critere, $order, $alpha)
{
$return = array();
if ($alpha == "alpha") {
$query = "select c.id, c.dossier, c.ligne, c.classement from " . Contenu::TABLE . " p LEFT JOIN " . Contenudesc::TABLE . " pd ON cd.contenu = c.id and lang=" . ActionsLang::instance()->get_id_langue_courante() . " where c.dossier=\"{$dossier}\" order by cd.{$critere} {$order}";
} else {
$query = "select id, dossier, ligne, classement from " . Contenu::TABLE . " where dossier=\"{$dossier}\" order by {$critere} {$order}";
}
$resul = $this->query($query);
$i = 0;
while ($resul && ($row = $this->fetch_object($resul))) {
$contenudesc = new Contenudesc();
$contenudesc->charger($row->id);
if (!$contenudesc->affichage_back_office_permis()) {
continue;
}
$image = new Image();
$query_image = "select * from " . Image::TABLE . " where contenu=\"" . $row->id . "\" order by classement limit 0,1";
$resul_image = $image->query($query_image);
$row_image = $image->fetch_object($resul_image, 'image');
$return[] = array("id" => $row->id, "dossier" => $row->dossier, "ligne" => $row->ligne, "classement" => $row->classement, "titre" => $contenudesc->titre, "langue_courante" => $contenudesc->est_langue_courante(), "image" => array("fichier" => $row_image->fichier));
}
return $return;
}
