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;
}
