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 executeList()
{
$this->userbadges = UserbadgePeer::doSelect(new Criteria());
}
public function getUserbadges($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseUserbadgePeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collUserbadges === null) {
if ($this->isNew()) {
$this->collUserbadges = array();
} else {
$criteria->add(UserbadgePeer::USER_ID, $this->getId());
UserbadgePeer::addSelectColumns($criteria);
$this->collUserbadges = UserbadgePeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(UserbadgePeer::USER_ID, $this->getId());
UserbadgePeer::addSelectColumns($criteria);
if (!isset($this->lastUserbadgeCriteria) || !$this->lastUserbadgeCriteria->equals($criteria)) {
$this->collUserbadges = UserbadgePeer::doSelect($criteria, $con);
}
}
}
$this->lastUserbadgeCriteria = $criteria;
return $this->collUserbadges;
}
public function executeProfile()
{
$this->user = UserPeer::retrieveByPK($this->getRequestParameter('id'));
$c = new Criteria();
$c->add(UserbadgePeer::USER_ID, $this->getRequestParameter('id'));
$ubadges = UserbadgePeer::doSelect($c);
$i = 0;
$badges = "";
foreach ($ubadges as $ub) {
if ($i) {
$badges .= ", " . $ub->getBadge()->getName();
} else {
$badges .= $ub->getBadge()->getName();
}
$i++;
}
$this->badges = $badges;
$c->clear();
$c->add(NotesPeer::USER_ID, $this->getRequestParameter('id'));
$this->notes = NotesPeer::doSelectOne($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(UserbadgePeer::ID, $pks, Criteria::IN);
$objs = UserbadgePeer::doSelect($criteria, $con);
}
return $objs;
}
