public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(CourseScheduleTutorPeer::ID, $pks, Criteria::IN);
$objs = CourseScheduleTutorPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeSelectByClass()
{
$class_id = $this->getRequestParameter('class_id');
$accal_id = $this->getRequestParameter('accal_id');
$c = new Criteria();
$c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_id);
$c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $accal_id);
$c->addAscendingOrderByColumn(CourseSchedulePeer::ID);
$objs = CourseSchedulePeer::doSelect($c);
$content = array();
$disabled = array();
foreach ($objs as $o) {
$c = new Criteria();
$c->add(CourseScheduleTutorPeer::COURSE_SCHEDULE_ID, $o->getId());
$cst = CourseScheduleTutorPeer::doSelect($c);
$tutors = array();
foreach ($cst as $cr) {
$tutors[] = $cr->getEmployee() ? $cr->getEmployee()->getName() : '-';
}
$content[$o->getId()] = $o->getSubjectCurr()->getSubject()->getName() . ' # ' . join("‚", $tutors);
}
$this->content = $content;
$this->disabled = $disabled;
}
public function getCourseScheduleTutors($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseCourseScheduleTutorPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collCourseScheduleTutors === null) {
if ($this->isNew()) {
$this->collCourseScheduleTutors = array();
} else {
$criteria->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $this->getId());
CourseScheduleTutorPeer::addSelectColumns($criteria);
$this->collCourseScheduleTutors = CourseScheduleTutorPeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $this->getId());
CourseScheduleTutorPeer::addSelectColumns($criteria);
if (!isset($this->lastCourseScheduleTutorCriteria) || !$this->lastCourseScheduleTutorCriteria->equals($criteria)) {
$this->collCourseScheduleTutors = CourseScheduleTutorPeer::doSelect($criteria, $con);
}
}
}
$this->lastCourseScheduleTutorCriteria = $criteria;
return $this->collCourseScheduleTutors;
}
public function executeDeleteSubject()
{
$course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($course_schedule);
$accal_id = $this->getRequestParameter('accal_id');
$this->accal_id = $accal_id;
$class_id = $this->getRequestParameter('class_id');
$this->class_id = $class_id;
$ref_error = 0;
foreach ($course_schedule->getRefCountMethods() as $ref) {
$method = "count" . $ref['affix'];
$count = $course_schedule->{$method}();
if ($count > 0) {
++$ref_error;
$this->getRequest()->setError('course_sched/deleteSubject/' . sfInflector::camelize($ref['table']), $count);
}
}
if ($ref_error > 0) {
$this->getRequest()->setError('course_sched/deleteSubject', '_ERR_DELETE_ (' . $course_schedule->toString() . ' - id:' . $course_schedule->getId() . ')');
} else {
$c = new Criteria();
$c->add(CourseScheduleTutorPeer::COURSE_SCHEDULE_ID, $course_sched->getId());
$cs_tutors = CourseScheduleTutorPeer::doSelect($c);
foreach ($cs_tutors as $o) {
$o->delete();
}
$course_schedule->delete();
}
return $this->redirect('course_sched/preview?class_group_id=' . $class_id . '&accal_id=' . $accal_id);
}
