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 executeBadges() { $c = new Criteria(); $c->addAscendingOrderByColumn(BadgePeer::NAME); $this->badges = BadgePeer::doSelect($c); }
public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(BadgePeer::ID, $pks, Criteria::IN); $objs = BadgePeer::doSelect($criteria, $con); } return $objs; }
public function executeLor() { $this->type = $this->getRequestParameter('type'); $this->toid = $this->getRequestParameter('for'); $this->foruser = UserPeer::retrieveByPK($this->toid); $badges = BadgePeer::doSelect(new Criteria()); $allbadges = array(); foreach ($badges as $badge) { $allbadges[$badge->getName()] = $badge->getName(); } $this->badges = $allbadges; }