public static function getAvailableInstructorsForCourseIdAndYear($courseId, $year, PropelPDO $conn) { $query = "SELECT DISTINCT %s as i FROM %s JOIN %s ON %s=%s WHERE %s='%s' AND %s=%s"; $query = sprintf($query, CourseInstructorAssociationPeer::ID, AutoCourseRatingPeer::TABLE_NAME, CourseInstructorAssociationPeer::TABLE_NAME, AutoCourseRatingPeer::COURSE_INS_ID, CourseInstructorAssociationPeer::ID, CourseInstructorAssociationPeer::COURSE_ID, $courseId, CourseInstructorAssociationPeer::YEAR, $year); $statement = $conn->prepare($query); $statement->execute(); $ids = $statement->fetchAll(PDO::FETCH_COLUMN, 0); $results = array(); $c = new Criteria(); $c->addJoin(CourseInstructorAssociationPeer::INSTRUCTOR_ID, InstructorPeer::ID); foreach ($ids as $id) { $crit = $c->getNewCriterion(CourseInstructorAssociationPeer::ID, $id); $c->addOr($crit); } $c->addAscendingOrderByColumn(InstructorPeer::LAST_NAME); $c->addAscendingOrderByColumn(InstructorPeer::FIRST_NAME); $raw = CourseInstructorAssociationPeer::doSelectJoinInstructor($c, $conn); foreach ($raw as $obj) { $results[] = $obj->getInstructor(); } return $results; }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Course is new, it will return * an empty collection; or if this Course has previously * been saved, it will retrieve related CourseInstructorAssociations 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 Course. */ public function getCourseInstructorAssociationsJoinInstructor($criteria = null, $con = null, $join_behavior = Criteria::LEFT_JOIN) { if ($criteria === null) { $criteria = new Criteria(CoursePeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collCourseInstructorAssociations === null) { if ($this->isNew()) { $this->collCourseInstructorAssociations = array(); } else { $criteria->add(CourseInstructorAssociationPeer::COURSE_ID, $this->id); $this->collCourseInstructorAssociations = CourseInstructorAssociationPeer::doSelectJoinInstructor($criteria, $con, $join_behavior); } } else { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(CourseInstructorAssociationPeer::COURSE_ID, $this->id); if (!isset($this->lastCourseInstructorAssociationCriteria) || !$this->lastCourseInstructorAssociationCriteria->equals($criteria)) { $this->collCourseInstructorAssociations = CourseInstructorAssociationPeer::doSelectJoinInstructor($criteria, $con, $join_behavior); } } $this->lastCourseInstructorAssociationCriteria = $criteria; return $this->collCourseInstructorAssociations; }