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 }