public static function getMenusUsuarisOptions($idU, $idS) { $RET = ""; $C = new Criteria(); $C->add(GestioMenusPeer::ACTIU, true); $TOTS = GestioMenusPeer::doSelect($C); $C = new Criteria(); $C->add(self::USUARI_ID, $idU); $C->add(self::ACTIU, true); $C->add(self::SITE_ID, $idS); $PART = UsuarisMenusPeer::doSelect($C); foreach ($TOTS as $OM) { $exist = false; foreach ($PART as $OUM) { $exist = $OM->getMenuId() == $OUM->getMenuId() || $exist; } if (!$exist) { $RET .= '<option id="' . $OM->getMenuId() . '" value="' . $OM->getMenuId() . '">' . addslashes($OM->getTitol()) . '</option>'; } else { $RET .= '<option selected id="' . $OM->getMenuId() . '" value="' . $OM->getMenuId() . '">' . addslashes($OM->getTitol()) . '</option>'; } } return $RET; }
/** * Retrieve object using using composite pkey values. * @param int $usuari_id * @param int $menu_id * @param int $site_id * @param PropelPDO $con * @return UsuarisMenus */ public static function retrieveByPK($usuari_id, $menu_id, $site_id, PropelPDO $con = null) { $key = serialize(array((string) $usuari_id, (string) $menu_id, (string) $site_id)); if (null !== ($obj = UsuarisMenusPeer::getInstanceFromPool($key))) { return $obj; } if ($con === null) { $con = Propel::getConnection(UsuarisMenusPeer::DATABASE_NAME, Propel::CONNECTION_READ); } $criteria = new Criteria(UsuarisMenusPeer::DATABASE_NAME); $criteria->add(UsuarisMenusPeer::USUARI_ID, $usuari_id); $criteria->add(UsuarisMenusPeer::MENU_ID, $menu_id); $criteria->add(UsuarisMenusPeer::SITE_ID, $site_id); $v = UsuarisMenusPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }
/** * Gets an array of UsuarisMenus objects which contain a foreign key that references this object. * * If this collection has already been initialized with an identical Criteria, it returns the collection. * Otherwise if this Sites has previously been saved, it will retrieve * related UsuarisMenuss from storage. If this Sites is new, it will return * an empty collection or the current collection, the criteria is ignored on a new object. * * @param PropelPDO $con * @param Criteria $criteria * @return array UsuarisMenus[] * @throws PropelException */ public function getUsuarisMenuss($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(SitesPeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collUsuarisMenuss === null) { if ($this->isNew()) { $this->collUsuarisMenuss = array(); } else { $criteria->add(UsuarisMenusPeer::SITE_ID, $this->site_id); UsuarisMenusPeer::addSelectColumns($criteria); $this->collUsuarisMenuss = UsuarisMenusPeer::doSelect($criteria, $con); } } else { // criteria has no effect for a new object if (!$this->isNew()) { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(UsuarisMenusPeer::SITE_ID, $this->site_id); UsuarisMenusPeer::addSelectColumns($criteria); if (!isset($this->lastUsuarisMenusCriteria) || !$this->lastUsuarisMenusCriteria->equals($criteria)) { $this->collUsuarisMenuss = UsuarisMenusPeer::doSelect($criteria, $con); } } } $this->lastUsuarisMenusCriteria = $criteria; return $this->collUsuarisMenuss; }