private static function roleIsUsed($oRole)
{
if ($oRole->isNew()) {
return false;
}
$iCountRolesUsed = UserRoleQuery::create()->filterByRole($oRole)->joinUserRelatedByUserId()->count();
$iCountRolesInGroupsUsed = UserGroupQuery::create()->filterByRole($oRole)->joinUserRelatedByUserId()->count();
return $iCountRolesUsed + $iCountRolesInGroupsUsed > 0;
}
public function addUsersFromArray($users = array())
{
foreach ($users as $user) {
$u = UserQuery::create()->findOneByUsername($user["username"]);
if ($u) {
if ($u == $this->data["loggedUser"]) {
$response["messages"][] = "You can not add yourself to group.";
continue;
}
$userGroup = UserGroupQuery::create()->filterByUser($u)->filterByGroup($this->data["group"])->findOne();
if ($userGroup) {
$response["messages"][] = "User " . $user["username"] . " is already in this group.";
continue;
}
$userGroup = new UserGroup();
$userGroup->setUser($u);
$userGroup->setGroup($this->data["group"]);
$userGroup->save();
} else {
$response["messages"][] = "User " . $user["username"] . " does not exist.";
}
}
}
/**
* Returns a new UserGroupQuery object.
*
* @param string $modelAlias The alias of a model in the query
* @param UserGroupQuery|Criteria $criteria Optional Criteria to build the query from
*
* @return UserGroupQuery
*/
public static function create($modelAlias = null, $criteria = null)
{
if ($criteria instanceof UserGroupQuery) {
return $criteria;
}
$query = new UserGroupQuery(null, null, $modelAlias);
if ($criteria instanceof Criteria) {
$query->mergeWith($criteria);
}
return $query;
}
/**
* Removes this object from datastore and sets delete attribute.
*
* @param PropelPDO $con
* @return void
* @throws PropelException
* @throws Exception
* @see BaseObject::setDeleted()
* @see BaseObject::isDeleted()
*/
public function delete(PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("This object has already been deleted.");
}
if ($con === null) {
$con = Propel::getConnection(UserGroupPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$deleteQuery = UserGroupQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
$ret = $this->preDelete($con);
// denyable behavior
if (!(UserGroupPeer::isIgnoringRights() || $this->mayOperate("delete"))) {
throw new PropelException(new NotPermittedException("delete.by_role", array("role_key" => "users")));
}
if ($ret) {
$deleteQuery->delete($con);
$this->postDelete($con);
$con->commit();
$this->setDeleted(true);
} else {
$con->commit();
}
} catch (Exception $e) {
$con->rollBack();
throw $e;
}
}
/**
* If this collection has already been initialized with
* an identical criteria, it returns the collection.
* Otherwise if this Group is new, it will return
* an empty collection; or if this Group has previously
* been saved, it will retrieve related UserGroups from storage.
*
* This method is protected by default in order to keep the public
* api reasonable. You can provide public methods for those you
* actually need in Group.
*
* @param Criteria $criteria optional Criteria object to narrow the query
* @param PropelPDO $con optional connection object
* @param string $join_behavior optional join type to use (defaults to Criteria::LEFT_JOIN)
* @return PropelObjectCollection|UserGroup[] List of UserGroup objects
*/
public function getUserGroupsJoinUserRelatedByUpdatedBy($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
{
$query = UserGroupQuery::create(null, $criteria);
$query->joinWith('UserRelatedByUpdatedBy', $join_behavior);
return $this->getUserGroups($query, $con);
}
