/**
  * Returns a new UserOrganizationQuery object.
  *
  * @param     string $modelAlias The alias of a model in the query
  * @param   UserOrganizationQuery|Criteria $criteria Optional Criteria to build the query from
  *
  * @return UserOrganizationQuery
  */
 public static function create($modelAlias = null, $criteria = null)
 {
     if ($criteria instanceof UserOrganizationQuery) {
         return $criteria;
     }
     $query = new UserOrganizationQuery();
     if (null !== $modelAlias) {
         $query->setModelAlias($modelAlias);
     }
     if ($criteria instanceof Criteria) {
         $query->mergeWith($criteria);
     }
     return $query;
 }
 public function setRole($user, $role)
 {
     $uo = UserOrganizationQuery::create()->filterByOrganization($this)->filterByUser($user)->findOne();
     if ($uo) {
         $uo->setOrganizationRole($role)->save();
     }
 }
});
/*
 * add user to organization
 */
$app->post('/organizations/:id/users', function ($org_id) use($app) {
    if_is_admin(function () use($app, $org_id) {
        $org = OrganizationQuery::create()->findPk($org_id);
        if ($org) {
            $data = json_decode($app->request()->getBody(), true);
            $alreadyInOrg = array();
            $added = 0;
            foreach ($data as $u_id) {
                $u = UserQuery::create()->findPk($u_id);
                if ($u) {
                    // number of organization users
                    $c = UserOrganizationQuery::create()->filterByOrganization($org)->filterByInviteToken('', Criteria::NOT_EQUAL)->count();
                    if ($c > 0 && $org->hasUser($u)) {
                        $alreadyInOrg[] = $u->guessName();
                    } else {
                        $org->addUser($u);
                        $added++;
                        // make first user the admin
                        // if ($c == 0) {
                        //     $org->save();
                        //     $org->setRole($u, 'admin');
                        // }
                        DatawrapperHooks::execute(DatawrapperHooks::USER_ORGANIZATION_ADD, $org, $u);
                    }
                }
            }
            $org->save();
});
/*
 * add user to organization
 */
$app->post('/organizations/:id/users', function ($org_id) use($app) {
    if_is_admin(function () use($app, $org_id) {
        $org = OrganizationQuery::create()->findPk($org_id);
        if ($org) {
            $data = json_decode($app->request()->getBody(), true);
            $alreadyInOrg = array();
            $added = 0;
            foreach ($data as $u_id) {
                $u = UserQuery::create()->findPk($u_id);
                if ($u) {
                    // number of organization users
                    $c = UserOrganizationQuery::create()->filterByOrganization($org)->count();
                    if ($c > 0 && $org->hasUser($u)) {
                        $alreadyInOrg[] = $u->guessName();
                    } else {
                        $org->addUser($u);
                        $added++;
                        // make first user the admin
                        // if ($c == 0) {
                        //     $org->save();
                        //     $org->setRole($u, 'admin');
                        // }
                        DatawrapperHooks::execute(DatawrapperHooks::USER_ORGANIZATION_ADD, $org, $u);
                    }
                }
            }
            $org->save();
 /**
  * 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(UserOrganizationPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
     }
     $con->beginTransaction();
     try {
         $deleteQuery = UserOrganizationQuery::create()->filterByPrimaryKey($this->getPrimaryKey());
         $ret = $this->preDelete($con);
         if ($ret) {
             $deleteQuery->delete($con);
             $this->postDelete($con);
             $con->commit();
             $this->setDeleted(true);
         } else {
             $con->commit();
         }
     } catch (Exception $e) {
         $con->rollBack();
         throw $e;
     }
 }
Beispiel #6
0
 /**
  * If this collection has already been initialized with
  * an identical criteria, it returns the collection.
  * Otherwise if this User is new, it will return
  * an empty collection; or if this User has previously
  * been saved, it will retrieve related UserOrganizations 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 User.
  *
  * @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|UserOrganization[] List of UserOrganization objects
  */
 public function getUserOrganizationsJoinOrganization($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN)
 {
     $query = UserOrganizationQuery::create(null, $criteria);
     $query->joinWith('Organization', $join_behavior);
     return $this->getUserOrganizations($query, $con);
 }