public function executeShow() { $userid = $this->getUser()->getAttribute('userid'); $c = new Criteria(); $c->add(AcademicPeer::USER_ID, $userid); $this->academics = AcademicPeer::doSelect($c); $c->clear(); $c->add(UserbadgePeer::USER_ID, $userid); $this->userbadges = UserbadgePeer::doSelect($c); $c->clear(); $c->add(UserbadgePeer::USER_ID, $userid); $c->addSelectColumn(UserbadgePeer::BADGE_ID); $userbadges = UserbadgePeer::doSelectRS($c); $ubarray = array(); foreach ($userbadges as $ub) { $ubarray[] = $ub[0]; } $c->clear(); $c->add(BadgePeer::ID, $ubarray, Criteria::NOT_IN); $c->addAscendingOrderByColumn(BadgePeer::NAME); $allbadges = BadgePeer::doSelect($c); $badgelist = array(); $badgelist[] = '-- Select --'; foreach ($allbadges as $badge) { $badgelist[$badge->getId()] = $badge->getName(); } $this->badgelist = $badgelist; }
public function getAcademic() { $c = new Criteria(); $c->add(AcademicPeer::USER_ID, $this->getId()); return AcademicPeer::doSelect($c); }
public function getAcademics($criteria = null, $con = null) { include_once 'lib/model/om/BaseAcademicPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collAcademics === null) { if ($this->isNew()) { $this->collAcademics = array(); } else { $criteria->add(AcademicPeer::USER_ID, $this->getId()); AcademicPeer::addSelectColumns($criteria); $this->collAcademics = AcademicPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(AcademicPeer::USER_ID, $this->getId()); AcademicPeer::addSelectColumns($criteria); if (!isset($this->lastAcademicCriteria) || !$this->lastAcademicCriteria->equals($criteria)) { $this->collAcademics = AcademicPeer::doSelect($criteria, $con); } } } $this->lastAcademicCriteria = $criteria; return $this->collAcademics; }