/**
* Exclude object from result
*
* @param ChildGroupPerson $groupPerson Object to remove from the list of results
*
* @return $this|ChildGroupPersonQuery The current query, for fluid interface
*/
public function prune($groupPerson = null)
{
if ($groupPerson) {
$this->addUsingAlias(GroupPersonTableMap::COL_ID, $groupPerson->getId(), Criteria::NOT_EQUAL);
}
return $this;
}
/**
* @param ChildGroupPerson $groupPerson The ChildGroupPerson object to add.
*/
protected function doAddGroupPerson(ChildGroupPerson $groupPerson)
{
$this->collGrouppeople[] = $groupPerson;
$groupPerson->setGroupEvePerson($this);
}
/**
* Filter the query by a related \ECP\GroupPerson object
*
* @param \ECP\GroupPerson|ObjectCollection $groupPerson the related object to use as filter
* @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
*
* @return ChildUserQuery The current query, for fluid interface
*/
public function filterByGroupPerson($groupPerson, $comparison = null)
{
if ($groupPerson instanceof \ECP\GroupPerson) {
return $this->addUsingAlias(UserTableMap::COL_ID, $groupPerson->getUserid(), $comparison);
} elseif ($groupPerson instanceof ObjectCollection) {
return $this->useGroupPersonQuery()->filterByPrimaryKeys($groupPerson->getPrimaryKeys())->endUse();
} else {
throw new PropelException('filterByGroupPerson() only accepts arguments of type \\ECP\\GroupPerson or Collection');
}
}
public function processGroups()
{
while (true) {
$groups = ECP\GroupQuery::create()->where('Group.lastComputed < ?', time() - 24 * 60 * 60)->find();
$groups->populateRelation('GroupEvePerson');
$groups->populateRelation('GroupPerson');
$evePersonNames = array();
foreach ($groups as $group) {
foreach ($group->getGroupEvepeople() as $groupEvePerson) {
$evePersonNames[] = $groupEvePerson->getName();
}
}
if (count($evePersonNames) != 0) {
$eveCharacters = ECP\EveCharacterQuery::create()->filterByCharName($evePersonNames)->_or()->filterByCorpName($evePersonNames)->_or()->filterByAllyName($evePersonNames)->find();
$eveCharacters->populateRelation('EveApi');
$eveNameDict = array();
foreach ($eveCharacters as $eveCharacter) {
$eveApi = $eveCharacter->getEveApi();
$userId = $eveApi->getUserId();
$eveNameDict[$eveCharacter->getCharName()] = array($userId);
if ($eveCharacter->getCorpId() != 0) {
$this->pushEveName($eveNameDict, $eveCharacter->getCorpName(), $userId);
}
if ($eveCharacter->getAllyId() != 0) {
$this->pushEveName($eveNameDict, $eveCharacter->getAllyName(), $userId);
}
}
foreach ($eveNameDict as $key => $userIds) {
$eveNameDict[$key] = array_unique($userIds);
}
foreach ($groups as $group) {
$personDict = array();
foreach ($group->getGrouppeople() as $groupPerson) {
$personKey = $groupPerson->getGroupPersonTypeId() . '-' . $groupPerson->getGroupEvePersonId();
if (!array_key_exists($personKey, $personDict)) {
$personDict[$personKey] = array($groupPerson);
} else {
$personDict[$personKey][] = $groupPerson;
}
}
$group->setLastComputed(time());
$connection = $this->getPropelConnection();
try {
$connection->beginTransaction();
foreach ($group->getGroupEvepeople() as $groupEvePerson) {
$name = $groupEvePerson->getName();
$userIds = array_key_exists($name, $eveNameDict) ? $eveNameDict[$name] : array();
$personKey = $groupEvePerson->getGroupPersonTypeId() . '-' . $groupEvePerson->getId();
$persons = array_key_exists($personKey, $personDict) ? $personDict[$personKey] : array();
$personByUserId = array();
foreach ($persons as $person) {
$personById[$person->getUserId()];
}
foreach ($userIds as $userId) {
if (!array_key_exists($userId, $personByUserId)) {
$groupPersonEntity = new ECP\GroupPerson();
$groupPersonEntity->setGroup($group);
$groupPersonEntity->setGroupPersonTypeId($groupEvePerson->getGroupPersonTypeId());
$groupPersonEntity->setGroupEvePersonId($groupEvePerson->getId());
$groupPersonEntity->setUserId($userId);
$this->prepareSubentitySave2($connection, $group, 'GroupPerson', $groupPersonEntity, true);
}
}
foreach ($persons as $groupPersonEntity) {
if (!in_array($groupPersonEntity->getUserId(), $userIds)) {
$group->removeGroupPerson($groupPersonEntity);
}
}
}
$group->save($connection);
$connection->commit();
} catch (Exception $e) {
$connection->rollBack();
throw $e;
}
}
}
sleep(30);
}
}
