<?php
echo $subject->getSubjectGroup() ? link_to_remote($subject->getSubjectGroup()->toString(), array('url' => 'subject_group/showFromSubject?id=' . $subject->getSubjectGroupId(), 'update' => 'content', 'script' => 'true', 'before' => "this.blur();showIndicator('content', 'snakebig_black');", 'complete' => "hideIndicator()"), array('class' => 'white')) : '-';
?>
</td>
<td>
<?php
echo $subject->getDepartment() ? $subject->getDepartment()->toString() : '-';
?>
<?php
#echo $subject->getDepartment()? link_to_remote($subject->getDepartment()->toString(), array('url'=>'department/show?id='.$subject->getDepartmentId(), 'update'=>'content', 'script'=>'true', 'before'=>"this.blur();showIndicator('content', 'snakebig_black');",'complete'=>"hideIndicator()"), array('class'=>'white')) : '-'
?>
</td>
<?php
$c = new Criteria();
$c->add(SubjectAccalPeer::SUBJECT_ID, $subject->getId());
$subject_curr = SubjectAccalPeer::doSelectOne($c);
$subject_count = SubjectAccalPeer::doCount($c);
?>
<td>
<?php
if ($subject_count > 0) {
echo $subject_curr->getAcademicCalendar() ? $subject_curr->getAcademicCalendar()->getYear() : '-';
} else {
echo '-';
}
?>
</td>
<td>
<?php
if ($subject_count > 0) {
echo $subject_curr->getEmployeeId() ? $subject_curr->getEmployee()->getName() : '-';
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;
}
public function executeUpdate()
{
$i18n = new sfI18N();
$i18n->initialize($this->getContext());
$i18n->setCulture($this->getUser()->getCulture());
$action_i18n = $i18n->globalMessageFormat->format('save as new');
$action_type = $this->getRequestParameter('action_type');
if ($action_type == $action_i18n || !$this->getRequestParameter('id')) {
$subject = new Subject();
$subject->setCode($this->getRequestParameter('code'));
$subject->setName($this->getRequestParameter('name'));
$subject->setCredit($this->getRequestParameter('credit'));
$subject->setSubjectGroupId($this->getRequestParameter('subject_group_id'));
$subject->setDepartmentId($this->getRequestParameter('department_id'));
$subject->save();
#$subject_curr = new SubjectCurr();
#$subject_curr->setSubject($subject);
#$subject_curr->setCurriculumId($this->getRequestParameter('curriculum_id'));
#$subject_curr->save();
#$c = new Criteria();
#$c->add(AcademicCalendarPeer::CURRICULUM_ID, $this->getRequestParameter('curriculum_id'));
#$currs = AcademicCalendarPeer::doSelect($c);
#foreach ($currs as $curr) {
# $subject_accal = new SubjectAccal();
# $subject_accal->setSubject($subject);
# $subject_accal->setAcademicCalendarId($curr->getId());
# $subject_accal->setEmployeeId($this->getRequestParameter('employee_id'));
# $subject_accal->save();
# $subject_accal_lector = new SubjectAccalLector();
# $subject_accal_lector->setSubjectAccal($subject_accal);
# $subject_accal_lector->setEmployeeId($this->getRequestParameter('employee_id'));
# $subject_accal_lector->save();
#}
$subject_accal = new SubjectAccal();
$subject_accal->setSubject($subject);
$subject_accal->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id'));
$subject_accal->setEmployeeId($this->getRequestParameter('employee_id'));
$subject_accal->save();
#$subject_accal_lector = new SubjectAccalLector();
#$subject_accal_lector->setSubjectAccal($subject_accal);
#$subject_accal_lector->setEmployeeId($this->getRequestParameter('employee_id'));
#$subject_accal_lector->save();
} else {
$subject = SubjectPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($subject);
$subject->setId($this->getRequestParameter('id'));
$subject->setCode($this->getRequestParameter('code'));
$subject->setName($this->getRequestParameter('name'));
$subject->setCredit($this->getRequestParameter('credit'));
$subject->setSubjectGroupId($this->getRequestParameter('subject_group_id'));
$subject->setDepartmentId($this->getRequestParameter('department_id'));
$subject->save();
$c = new Criteria();
$c->add(SubjectAccalPeer::ID, $this->getRequestParameter('subject_accal_id'));
$subject_accal = SubjectAccalPeer::doSelectOne($c);
#$subject_accal = SubjectAccalPeer::retrieveByPk($this->getRequestParameter('subject_accal_id'));
#$this->forward404Unless($subject_accal);
$subject_accal->setId('subject_accal_id');
$subject_accal->setSubject($subject);
$subject_accal->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id'));
$subject_accal->setEmployeeId($this->getRequestParameter('employee_id'));
$subject_accal->save();
}
return $this->redirect('subject/list');
}
