public function executeGetLectors()
{
$subject_id = $this->getRequestParameter('subject_id');
$subject = SubjectPeer::retrieveByPK($subject_id);
if (!$subject) {
$subject_accal_id = $this->getRequestParameter('subject_accal_l_id');
$subject_accal = SubjectAccalPeer::retrieveByPK($subject_accal_id);
$subject = $subject_accal->getSubject();
}
$this->forward404Unless($subject);
$subject_id = $subject->getId();
$c = new Criteria();
$c->add(TeachingCompetencyPeer::SUBJECT_ID, $subject_id);
$c->addJoin(TeachingCompetencyPeer::EMPLOYEE_ID, EmployeePeer::ID);
$objs = EmployeePeer::doSelect($c);
$lectors = array();
foreach ($objs as $o) {
$lectors[$o->getId()] = $o->toString();
}
$this->content = $lectors;
$this->forward404Unless($subject);
$this->setTemplate('buildOptions');
}
public function getSubject($con = null)
{
include_once 'lib/model/om/BaseSubjectPeer.php';
if ($this->aSubject === null && $this->subject_id !== null) {
$this->aSubject = SubjectPeer::retrieveByPK($this->subject_id, $con);
}
return $this->aSubject;
}
public function executeGetLectors()
{
$subject_id = $this->getRequestParameter('subject_id');
$accal_id = $this->getRequestParameter('accal_id');
$accal = AcademicCalendarPeer::retrieveByPK($accal_id);
$this->forward404Unless($accal);
$subject = SubjectPeer::retrieveByPK($subject_id);
$subject_academic = null;
if (!$subject) {
$subject_academic_id = $this->getRequestParameter('subject_academic_id');
$subject_academic = SubjectAccalPeer::retrieveByPK($subject_academic_id);
$subject = $subject_academic->getSubject();
}
$this->forward404Unless($subject);
$subject_id = $subject->getId();
if ($subject_academic == null) {
$c = new Criteria();
$c->add(SubjectAccalPeer::ACADEMIC_CALENDAR_ID, $accal_id);
$c->add(SubjectAccalPeer::SUBJECT_ID, $subject_id);
$subject_academic = SubjectAccalPeer::doSelectOne($c);
}
$c = new Criteria();
$c->add(TeachingCompetencyPeer::SUBJECT_ID, $subject_id);
$c->addJoin(TeachingCompetencyPeer::EMPLOYEE_ID, EmployeePeer::ID);
$c->addAscendingOrderByColumn(EmployeePeer::EMP_NO);
$objs = EmployeePeer::doSelect($c);
$lectors = array();
$disabled = array();
$cs_counts = array();
foreach ($objs as $o) {
$lectors[$o->getId()] = $o->toString();
if ($subject_academic) {
$c = new Criteria();
$c->add(CourseSchedulePeer::EMPLOYEE_ID, $o->getId());
$c->add(CourseSchedulePeer::SUBJECT_ACCAL_ID, $subject_academic->getId());
$cs_count = CourseSchedulePeer::doCount($c);
$cs_counts[$o->getId()] = $cs_count;
}
}
$this->selected_lectors = array();
if ($subject_academic) {
$sals = $subject_academic->getSubjectAccalLectors();
foreach ($sals as $sal) {
$this->selected_lectors[$sal->getEmployeeId()] = 1;
}
}
$this->cs_counts = $cs_counts;
$this->lectors = $lectors;
$this->forward404Unless($subject);
$this->setTemplate('buildCheckBoxes');
$this->disabled = $disabled;
$this->accal = $accal;
$this->subject_academic = $subject_academic;
}
