<?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'); }