private function getProfessors() { $professors = ProfessorQuery::create()->orderByLastName()->orderByFirstName()->find(); $professors_arr = ['' => '']; foreach ($professors as $professor) { $name = $professor->toString(true); $id = $professor->getId(); $professors_arr[$id] = $name; } return $professors_arr; }
/** * Create Professor query. * */ protected function createQuery($array, $search) { $this->professors = ProfessorQuery::create()->orderByLastName()->orderByFirstName(); if (isset($array['FirstName']) && $array['FirstName'] !== "") { $this->professors->where("professor.first_name like '%" . $array['FirstName'] . "%'"); } if (isset($array['LastName']) && $array['LastName'] !== "") { $this->professors->where("professor.last_name like '%" . $array['LastName'] . "%'"); } if ($search) { session(['professor_filter' => $array]); } }
private function getProfessors($status) { $professors = ProfessorQuery::create()->orderByLastName()->orderByFirstName(); if ($status === 'student') { $course_id = \Auth::user()->getStudent()->getCourseId(); $professors->joinEngagement(); $professors->where('Engagement.course_id = ?', $course_id); } $professors->find(); $professors_arr = ['' => '']; foreach ($professors as $professor) { $name = $professor->toString(true); $id = $professor->getId(); $professors_arr[$id] = $name; } return $professors_arr; }
/** * Performs an INSERT on the database, given a Professor or Criteria object. * * @param mixed $criteria Criteria or Professor 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(ProfessorTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from Professor object } if ($criteria->containsKey(ProfessorTableMap::COL_ID) && $criteria->keyContainsValue(ProfessorTableMap::COL_ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . ProfessorTableMap::COL_ID . ')'); } // Set the correct dbName $query = ProfessorQuery::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); }); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $professor = ProfessorQuery::create()->findPK($id); $professor->delete(); flash()->success("DELETED"); session(['attribute' => \Lang::get('general.PROFESSOR')]); return redirect($this->main_page); }
/** * 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 = ChildProfessorQuery::create(); $criteria->add(ProfessorTableMap::COL_ID, $this->id); return $criteria; }
/** * Returns a new ChildProfessorQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return ChildProfessorQuery */ public static function create($modelAlias = null, Criteria $criteria = null) { if ($criteria instanceof ChildProfessorQuery) { return $criteria; } $query = new ChildProfessorQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
/** * Get the associated ChildProfessor object * * @param ConnectionInterface $con Optional Connection object. * @return ChildProfessor The associated ChildProfessor object. * @throws PropelException */ public function getProfessor(ConnectionInterface $con = null) { if ($this->aProfessor === null && $this->professor_id !== null) { $this->aProfessor = ChildProfessorQuery::create()->findPk($this->professor_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->aProfessor->addAdminUsers($this); */ } return $this->aProfessor; }