Exemplo n.º 1
0
 public function executeSaveUploadTryout()
 {
     $scores = $this->getRequestParameter('score');
     $id_course = 0;
     foreach ($scores as $k => $score) {
         if ($score != null) {
             if ($score != '-') {
                 $ids = split('_', $k);
                 #$ids [0] == Id Student
                 #$ids [1] == Id Course Schedule
                 #$ids [2] == Id Grade Spec
                 $course_schedule = CourseSchedulePeer::retrieveByPK($ids[1]);
                 $id_course = $course_schedule->getId();
                 $c = new Criteria();
                 $c->add(StudentTryoutPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId());
                 $c->add(StudentTryoutPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId());
                 $c->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId());
                 $c->add(StudentTryoutPeer::STUDENT_ID, $ids[0]);
                 $c->add(StudentTryoutPeer::GRADE_SPEC_ID, $ids[2]);
                 $st = StudentTryoutPeer::doSelectOne($c);
                 if ($st == null) {
                     $st = new StudentTryout();
                 }
                 $st->setStudentId($ids[0]);
                 $st->setGradeSpecId($ids[2]);
                 $st->setAcademicCalendarId($course_schedule->getAcademicCalendarId());
                 $st->setClassGroupId($course_schedule->getClassGroupId());
                 $st->setSubjectCurrId($course_schedule->getSubjectCurrId());
                 $st->setGrade($score);
                 $st->save();
             } else {
                 $ids = split('_', $k);
                 #$ids [0] == Id Student
                 #$ids [1] == Id Course Schedule
                 #$ids [2] == Id Grade Spec
                 $course_schedule = CourseSchedulePeer::retrieveByPK($ids[1]);
                 $id_course = $course_schedule->getId();
                 $c = new Criteria();
                 $c->add(StudentTryoutPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId());
                 $c->add(StudentTryoutPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId());
                 $c->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId());
                 $c->add(StudentTryoutPeer::STUDENT_ID, $ids[0]);
                 $c->add(StudentTryoutPeer::GRADE_SPEC_ID, $ids[2]);
                 $st = StudentTryoutPeer::doSelectOne($c);
                 if ($st != null) {
                     $st->delete();
                 }
             }
         }
     }
     return $this->redirect('course_score_new/uploadTryoutFinish?course_id=' . $id_course);
 }
Exemplo n.º 2
0
</td>
                <td style="color: #017FC0;"><?php 
        echo $student->getName();
        ?>
</td>
            	<?php 
        foreach ($grade1 as $g1) {
            $c = new Criteria();
            $c->add(StudentTryoutPeer::STUDENT_ID, $student->getId());
            $c->add(StudentTryoutPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId());
            $c->add(StudentTryoutPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId());
            $c->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId());
            $c->add(StudentTryoutPeer::GRADE_SPEC_ID, $g1->getId());
            $st = StudentTryoutPeer::doSelectOne($c);
            if ($st == null) {
                $st = new StudentTryout();
            }
            ?>
                <td align="center" style="text-align:center" class="first">
                <?php 
            echo input_tag('score[' . $student->getId() . '_' . $g1->getId() . ']', $st != null ? $st->getGrade() : '', array('size' => 2, 'maxlength' => 5, 'style' => 'font-size: 10px;'));
            ?>
                </td>
				<?php 
        }
        ?>
                <td align="center" style="text-align:center">
                <?php 
        $grade1_ids = array();
        foreach ($grade1 as $g1) {
            $grade1_ids[] = $g1->getId();
Exemplo n.º 3
0
 public function executeSaveTryout()
 {
     $subject_id = $this->getRequestParameter('subject_id');
     $class_id = $this->getRequestParameter('class_id');
     $accal_id = $this->getRequestParameter('accal_id');
     $course_id = $this->getRequestParameter('course_id');
     $course_schedule = CourseSchedulePeer::retrieveByPK($course_id);
     $this->forward404Unless($course_schedule);
     $scores = $this->getRequestParameter('score');
     foreach ($scores as $k => $score) {
         if ($score != null) {
             if ($score != '-') {
                 $ids = split('_', $k);
                 $c = new Criteria();
                 $c->add(StudentTryoutPeer::SUBJECT_CURR_ID, $subject_id);
                 $c->add(StudentTryoutPeer::CLASS_GROUP_ID, $class_id);
                 $c->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $accal_id);
                 $c->add(StudentTryoutPeer::STUDENT_ID, $ids[0]);
                 $c->add(StudentTryoutPeer::GRADE_SPEC_ID, $ids[1]);
                 $st = StudentTryoutPeer::doSelectOne($c);
                 if ($st == null) {
                     $st = new StudentTryout();
                 }
                 $st->setStudentId($ids[0]);
                 $st->setGradeSpecId($ids[1]);
                 $st->setAcademicCalendarId($accal_id);
                 $st->setClassGroupId($class_id);
                 $st->setSubjectCurrId($subject_id);
                 $st->setGrade($score);
                 $st->save();
             } else {
                 $ids = split('_', $k);
                 $c = new Criteria();
                 $c->add(StudentTryoutPeer::SUBJECT_CURR_ID, $subject_id);
                 $c->add(StudentTryoutPeer::CLASS_GROUP_ID, $class_id);
                 $c->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $accal_id);
                 $c->add(StudentTryoutPeer::STUDENT_ID, $ids[0]);
                 $c->add(StudentTryoutPeer::GRADE_SPEC_ID, $ids[1]);
                 $st = StudentTryoutPeer::doSelectOne($c);
                 if ($st != null) {
                     $st->delete();
                 }
             }
         }
     }
     return $this->redirect('course_score/listTryout?course_id=' . $course_schedule->getId());
 }
Exemplo n.º 4
0
        echo $student->getName();
        ?>
</td>
            	
				<?php 
        $j = 0;
        foreach ($grade1 as $g1) {
            $c = new Criteria();
            $c->add(StudentTryoutPeer::STUDENT_ID, $student->getId());
            $c->add(StudentTryoutPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId());
            $c->add(StudentTryoutPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId());
            $c->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId());
            $c->add(StudentTryoutPeer::GRADE_SPEC_ID, $g1->getId());
            $st = StudentTryoutPeer::doSelectOne($c);
            if ($st == null) {
                $st = new StudentTryout();
            }
            ?>
                <td style="text-align:center; vertical-align: middle; font-size: 10px; font-weight: bold;" <?php 
            ++$j;
            if ($j % 2 != 0) {
                echo 'class="first"';
            }
            ?>
>
                <?php 
            echo $st != null ? $st->getGrade() ? $st->getGrade() : '-' : '-';
            ?>
                </td>
				<?php 
        }