/** * Create AdminUser query. * */ protected function createQuery($array, $search) { $this->users = AdminUserQuery::create(); if (isset($array['Name']) && $array['Name'] !== "") { $this->users->where("admin_user.name like '%" . $array['Name'] . "%'"); } if (isset($array['Login']) && $array['Login'] !== "") { $this->users->where("admin_user.login like '%" . $array['Login'] . "%'"); } if (isset($array['Email']) && $array['Email'] !== "") { $this->users->where("admin_user.email like '%" . $array['Email'] . "%'"); } if (isset($array['Status']) && $array['Status'] !== "") { $this->users->where("admin_user.status = '" . $array['Status'] . "'"); } if (isset($array['LanguageId']) && $array['LanguageId'] !== "") { $this->users->where("admin_user.language_id = " . $array['LanguageId']); } if (isset($array['CredentialId']) && $array['CredentialId'] !== "") { $this->users->useAdminUserCredentialQuery()->where("admin_user_credential.admin_credential_id = " . $array['CredentialId'])->endUse(); } if ($search) { session(['admin_user_filter' => $array]); } }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Student is new, it will return * an empty collection; or if this Student has previously * been saved, it will retrieve related AdminUsers 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 Student. * * @param Criteria $criteria optional Criteria object to narrow the query * @param ConnectionInterface $con optional connection object * @param string $joinBehavior optional join type to use (defaults to Criteria::LEFT_JOIN) * @return ObjectCollection|ChildAdminUser[] List of ChildAdminUser objects */ public function getAdminUsersJoinTranslationLanguage(Criteria $criteria = null, ConnectionInterface $con = null, $joinBehavior = Criteria::LEFT_JOIN) { $query = ChildAdminUserQuery::create(null, $criteria); $query->joinWith('TranslationLanguage', $joinBehavior); return $this->getAdminUsers($query, $con); }
/** * Performs an INSERT on the database, given a AdminUser or Criteria object. * * @param mixed $criteria Criteria or AdminUser object containing data that is used to create the INSERT statement. * @param ConnectionInterface $con the ConnectionInterface connection to use * @return mixed The new primary key. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doInsert($criteria, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(AdminUserTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from AdminUser object } if ($criteria->containsKey(AdminUserTableMap::COL_ID) && $criteria->keyContainsValue(AdminUserTableMap::COL_ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . AdminUserTableMap::COL_ID . ')'); } // Set the correct dbName $query = AdminUserQuery::create()->mergeWith($criteria); // use transaction because $criteria could contain info // for more than one table (I guess, conceivably) return $con->transaction(function () use($con, $query) { return $query->doInsert($con); }); }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @throws LogicException if no primary key is defined * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = ChildAdminUserQuery::create(); $criteria->add(AdminUserTableMap::COL_ID, $this->id); return $criteria; }
/** * Get the associated ChildAdminUser object * * @param ConnectionInterface $con Optional Connection object. * @return ChildAdminUser The associated ChildAdminUser object. * @throws PropelException */ public function getAdminUser(ConnectionInterface $con = null) { if ($this->aAdminUser === null && $this->admin_user_id !== null) { $this->aAdminUser = ChildAdminUserQuery::create()->findPk($this->admin_user_id, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aAdminUser->addAdminUserCredentials($this); */ } return $this->aAdminUser; }
/** * Returns a new ChildAdminUserQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return ChildAdminUserQuery */ public static function create($modelAlias = null, Criteria $criteria = null) { if ($criteria instanceof ChildAdminUserQuery) { return $criteria; } $query = new ChildAdminUserQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $user = AdminUserQuery::create()->findPK($id); $user->delete(); flash()->success("DELETED"); session(['attribute' => \Lang::get('general.USER')]); return redirect($this->main_page); }