function getListAvailableVariant($idrubrique)
{
$return = array();
$qList = "SELECT * FROM " . self::TABLE . " WHERE rubrique={$idrubrique}";
$rList = $this->query($qList);
$notAvailable = array();
while ($rList && ($theAssociatedVariant = $this->fetch_object($rList))) {
$notAvailable[] = $theAssociatedVariant->declinaison;
}
$variant = new Declinaison();
$qVariant = "SELECT * FROM " . Declinaison::TABLE . "" . (!empty($notAvailable) ? " WHERE id NOT IN(" . implode(',', $notAvailable) . ")" : '');
$rVariant = $variant->query($qVariant);
while ($rVariant && ($theVariant = $variant->fetch_object($rVariant))) {
$variantDescription = new Declinaisondesc($theVariant->id);
$return[] = array('id' => $theVariant->id, 'titre' => $variantDescription->titre);
}
return $return;
}
function declinaison_liste_select($idrubrique)
{
$rubdeclinaison = new Rubdeclinaison();
$query = "select * from {$rubdeclinaison->table} where rubrique={$idrubrique}";
$resul = $rubdeclinaison->query($query);
$listeid = "";
while ($resul && ($row = $rubdeclinaison->fetch_object($resul))) {
$listeid .= $row->declinaison . ",";
}
if (strlen($listeid) > 0) {
$listeid = substr($listeid, 0, strlen($listeid) - 1);
$declinaison = new Declinaison();
$query = "select * from {$declinaison->table} where id NOT IN({$listeid})";
$resul = $declinaison->query($query);
} else {
$declinaison = new Declinaison();
$query = "select * from {$declinaison->table}";
$resul = $declinaison->query($query);
}
?>
<select class="form_select" id="prod_decli">
<option value=""> </option>
<?php
while ($resul && ($row = $declinaison->fetch_object($resul))) {
$declinaisondesc = new Declinaisondesc($row->id);
?>
<option value="<?php
echo $row->id;
?>
"><?php
echo $declinaisondesc->titre;
?>
</option>
<?php
}
?>
</select>
<?php
}
