/**
* This method receives a Criteria and adds the joins necesary to join a preceptor with his division courses or commissions.
*
* @param integer $user_id
*
* @return Criteria
*/
public static function retrieveCourseIdsjoinWithDivisionCourseOrCommission($user_id, $add_division_courses = false)
{
$preceptor = self::retrievePreceptorBySfGuardUserId($user_id);
if (is_null($preceptor)) {
return array();
}
$c1 = new Criteria();
$c1->addJoin(CoursePeer::ID, CoursePreceptorPeer::COURSE_ID);
$c1->add(CoursePreceptorPeer::PRECEPTOR_ID, $preceptor->getId());
$c1->clearSelectColumns();
$c1->addSelectColumn(CoursePeer::ID);
$stmt = CoursePeer::doSelectStmt($c1);
$course_ids = $stmt->fetchAll(PDO::FETCH_COLUMN);
if ($add_division_courses) {
$c2 = new Criteria();
$c2->addJoin(CoursePeer::DIVISION_ID, DivisionPeer::ID);
$c2->addJoin(DivisionPeer::ID, DivisionPreceptorPeer::DIVISION_ID);
$c2->add(DivisionPreceptorPeer::PRECEPTOR_ID, $preceptor->getId());
$c2->clearSelectColumns();
$c2->addSelectColumn(CoursePeer::ID);
$stmt = CoursePeer::doSelectStmt($c2);
$course_ids = array_merge($course_ids, $stmt->fetchAll(PDO::FETCH_COLUMN));
}
return $course_ids;
}
/**
* Method to do selects.
*
* @param Criteria $criteria The Criteria object used to build the SELECT statement.
* @param PropelPDO $con
* @return array Array of selected Objects
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doSelect(Criteria $criteria, PropelPDO $con = null)
{
return CoursePeer::populateObjects(CoursePeer::doSelectStmt($criteria, $con));
}
/**
* Reloads this object from datastore based on primary key and (optionally) resets all associated objects.
*
* This will only work if the object has been saved and has a valid primary key set.
*
* @param boolean $deep (optional) Whether to also de-associated any related objects.
* @param PropelPDO $con (optional) The PropelPDO connection to use.
* @return void
* @throws PropelException - if this object is deleted, unsaved or doesn't have pk match in db
*/
public function reload($deep = false, PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("Cannot reload a deleted object.");
}
if ($this->isNew()) {
throw new PropelException("Cannot reload an unsaved object.");
}
if ($con === null) {
$con = Propel::getConnection(CoursePeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
// We don't need to alter the object instance pool; we're just modifying this instance
// already in the pool.
$stmt = CoursePeer::doSelectStmt($this->buildPkeyCriteria(), $con);
$row = $stmt->fetch(PDO::FETCH_NUM);
$stmt->closeCursor();
if (!$row) {
throw new PropelException('Cannot find matching row in the database to reload object values.');
}
$this->hydrate($row, 0, true);
// rehydrate
if ($deep) {
// also de-associate any related objects?
}
// if (deep)
}
