public static function retrieveByUser($user_id, $max = 5)
{
$userGroups = HistoryGroupUserPeer::retrieveByUserId($user_id);
$groups = array();
foreach ($userGroups as $result) {
$groups[] = $result->getHistoryGroup();
}
$c = new Criteria();
$crit0 = $c->getNewCriterion(self::HISTORY_GROUP_ID, '');
$crit_groups = array();
foreach ($groups as $group) {
$group = HistoryGroupPeer::retrieveByName($group->getName());
$crit_groups[] = $c->getNewCriterion(self::HISTORY_GROUP_ID, $group->getId());
}
sfContext::getInstance()->getLogger()->info('Groups: [' . count($crit_groups) . ']');
foreach ($crit_groups as $crit_group) {
$crit0->addOr($crit_group);
}
$c->add($crit0);
$c->addDescendingOrderByColumn(self::CREATED_AT);
$c->setLimit($max);
sfContext::getInstance()->getLogger()->info('Grabbing history now');
return self::doSelect($c);
}
public function getHistoryGroupUsersJoinHistoryGroup($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseHistoryGroupUserPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collHistoryGroupUsers === null) {
if ($this->isNew()) {
$this->collHistoryGroupUsers = array();
} else {
$criteria->add(HistoryGroupUserPeer::USER_ID, $this->getId());
$this->collHistoryGroupUsers = HistoryGroupUserPeer::doSelectJoinHistoryGroup($criteria, $con);
}
} else {
$criteria->add(HistoryGroupUserPeer::USER_ID, $this->getId());
if (!isset($this->lastHistoryGroupUserCriteria) || !$this->lastHistoryGroupUserCriteria->equals($criteria)) {
$this->collHistoryGroupUsers = HistoryGroupUserPeer::doSelectJoinHistoryGroup($criteria, $con);
}
}
$this->lastHistoryGroupUserCriteria = $criteria;
return $this->collHistoryGroupUsers;
}
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(HistoryGroupUserPeer::ID, $pks, Criteria::IN);
$objs = HistoryGroupUserPeer::doSelect($criteria, $con);
}
return $objs;
}
public function isSubscribedToHistoryGroup($historyGroup)
{
$group = HistoryGroupPeer::retrieveByName($historyGroup);
$c = new Criteria();
$c->add(HistoryGroupUserPeer::HISTORY_GROUP_ID, $group->getId());
$c->add(HistoryGroupUserPeer::USER_ID, $this->getSfGuardUser()->getId());
$subscription = HistoryGroupUserPeer::doSelectOne($c);
if ($subscription == null) {
sfContext::getInstance()->getLogger()->info('User is not subscribed');
return false;
}
sfContext::getInstance()->getLogger()->info('User is subscribed');
return true;
}
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = HistoryGroupUserPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setUuid($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setHistoryGroupId($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setUserId($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setVersion($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setDeletedAt($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setCreatedAt($arr[$keys[6]]);
}
}
