public function getParentName() { if ($this->getParent() != null && $this->getParent() != 0) { return ClassGroupPeer::retrieveByPk($this->getParent())->getName(); } return '-'; }
public function executeEnquirer() { $this->applicant = $this->applicant; $this->error = false; $this->department = DepartmentPeer::retrieveByPK($this->applicant->getDepartment1()); $this->classGroup = ClassGroupPeer::retrieveByPK($this->applicant->getClassGroup1()); }
public function signInTestApplicant($user) { $this->addCredential('bo'); $this->setAttribute('user_id', $user->getId(), 'bo'); $this->setAttribute('username_long', $user->getName(), 'bo'); $this->setAuthenticated2(true, 'bo'); $this->setAttribute('username', $user->getCode(), 'bo'); $this->setAttribute('department_id1', DepartmentPeer::retrieveByPK($user->getDepartment1())->getId(), 'bo'); $this->setAttribute('department1_name', DepartmentPeer::retrieveByPK($user->getDepartment1())->getName(), 'bo'); #$this->setAttribute('department_id2', $user->getDepartment2()? DepartmentPeer::retrieveByPK($user->getDepartment2())->getId() : '', 'bo'); #$this->setAttribute('department2_name', $user->getDepartment2()? DepartmentPeer::retrieveByPK($user->getDepartment2())->getName() : '', 'bo'); $this->setAttribute('class_name1', ClassGroupPeer::retrieveByPK($user->getClassGroup1())->getName(), 'bo'); $this->setAttribute('class_parent1', ClassGroupPeer::retrieveByPK($user->getClassGroup1())->getParentName(), 'bo'); #$this->setAttribute('class_name2', $user->getClassGroup2()? ClassGroupPeer::retrieveByPK($user->getClassGroup2())->getName() : '', 'bo'); #$this->setAttribute('class_parent2', $user->getClassGroup2()? ClassGroupPeer::retrieveByPK($user->getClassGroup2())->getParentName() : '', 'bo'); $this->setAttribute('login_time', time(), 'bo'); }
public function executeGetCourseByAccal() { $accal_id = $this->getRequestParameter('accal_id'); $accal = AcademicCalendarPeer::retrieveByPK($accal_id); #$this->forward404Unless($accal); $class_id = $this->getRequestParameter('class_id'); $class = ClassGroupPeer::retrieveByPK($class_id); #$this->forward404Unless($class); $c = new Criteria(); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_id, Criteria::IN); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $accal_id, Criteria::IN); $c->add(CourseSchedulePeer::SUBJECT_CURR_ID, 319, Criteria::NOT_IN); $c->add(CourseSchedulePeer::SUBJECT_CURR_ID, 316, Criteria::NOT_IN); $objs = CourseSchedulePeer::doSelect($c); $subjects = array(); foreach ($objs as $o) { $subjects[$o->getId()] = $o->getSubjectCurr()->getSubject()->getName(); } $this->content = $subjects; $this->setTemplate('buildOptions'); }
<div class="login"> <p style="text-align:left; width:90%; line-height: 15px; padding-top: 0px;"></p> <h2 class="contentheading"><b><?php echo $this->getContext()->getUser()->getAttribute('username_long', '', 'bo'); ?> </b></h2> <?php $applicant = TestApplicantPeer::retrieveByPk($this->getContext()->getUser()->getAttribute('user_id', '', 'bo')); $cls = ClassGroupPeer::retrieveByPk($applicant->getClassGroup1()); ?> <p style="padding-top: 15px; line-height: 20px;">No. Pendaftaran Anda adalah <br><b><?php echo $applicant->getCode() ? $applicant->getCode() : '-'; ?> </b><br /> Pilihan Kelas Anda adalah <br><b><?php echo $applicant->getClassGroup1() ? $cls->toString() . ' - ' . $cls->getParentName() : '-'; ?> </b><br /><br> <?php echo link_to_remote('Informasi Detail', array('url' => 'auth/test?id=' . $applicant->getId(), 'update' => 'content', 'script' => 'true'), array('class' => 'user_logout', 'title' => 'Detail Informasi')); ?> <br /> <?php echo link_to('Logout', '/auth/logout', 'class=user_logout title=keluar'); ?> </p> </div>
public function filterEkskul($c, $filters) { $filters_key = array_keys($filters); foreach ($filters_key as $key) { $value = $filters[$key]; if ($value == '' || $value == null) { continue; } if ($key == 'DEPARTMENT_ID') { $c->addJoin(DepartmentPeer::ID, AcademicCalendarPeer::DEPARTMENT_ID); $c->addJoin(SchedulePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $column = DepartmentPeer::getTableMap()->getColumn('ID'); } elseif ($key == 'CODE_CLASS') { $c->addJoin(SchedulePeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $column = ClassGroupPeer::getTableMap()->getColumn('NAME'); } elseif ($key == 'EMPLOYEE_NAME') { $c->addJoin(SchedulePeer::EMPLOYEE_ID, EmployeePeer::ID); $column = EmployeePeer::getTableMap()->getColumn('NAME'); } elseif ($key == 'SUBJECT_ID') { $c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID); $c->addJoin(SubjectCurrPeer::ID, SchedulePeer::SUBJECT_CURR_ID); $column = SubjectPeer::getTableMap()->getColumn('ID'); } elseif ($key == 'SUBJECT_NAME') { $c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID); $c->addJoin(SubjectCurrPeer::ID, SchedulePeer::SUBJECT_CURR_ID); $column = SubjectPeer::getTableMap()->getColumn('NAME'); } elseif ($key == 'EKSUL_NAME') { $c->addJoin(SchedulePeer::GRADE_COMPONENT_ID, GradeComponentPeer::ID); $column = GradeComponentPeer::getTableMap()->getColumn('NAME'); } else { $column = SchedulePeer::getTableMap()->getColumn($key); } $name = $column->getFullyQualifiedName(); $creoleType = $column->getCreoleType(); if ($creoleType == CreoleTypes::TIMESTAMP) { $from = $value['from']; $to = $value['to']; if ($from != '' && $from != null) { $c->add($name, $from, Criteria::GREATER_EQUAL); } if ($to != '' && $to != null) { $c->add($name, $to, Criteria::LESS_EQUAL); } } else { if ($creoleType == CreoleTypes::DATE) { $c->add($name, $value, Criteria::LIKE); } else { if ($creoleType == CreoleTypes::INTEGER) { $c->add($name, $value, Criteria::EQUAL); } else { if ($creoleType == CreoleTypes::VARCHAR) { $c->add($name, "%{$value}%", Criteria::LIKE); } } } } } }
<td align="left">2.</td> <td align="left">Nama</td> <td align="center">:</td> <td align="left"><?php echo $ta->getName() ? $ta->getName() : '-'; ?> </td> </tr> <tr> <td></td> <td align="left">3.</td> <td align="left">Pilihan Kelas</td> <td align="center">:</td> <td align="left"> <?php $cls = ClassGroupPeer::retrieveByPk($ta->getClassGroup1()); echo $ta->getClassGroup1() ? $cls->toString() . ' - ' . $cls->getParentName() : '-'; ?> </td> </tr> <tr> <td></td> <td align="left">4.</td> <td align="left">Asal Sekolah</td> <td align="center">:</td> <td align="left"><?php echo $ta_detail->getJobTitle() ? $ta_detail->getJobTitle() : '-'; ?> </td> </tr> <tr>
public static function doSelectJoinAllExceptAcademicCalendar(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } VStudentCoursePeer::addSelectColumns($c); $startcol2 = VStudentCoursePeer::NUM_COLUMNS - VStudentCoursePeer::NUM_LAZY_LOAD_COLUMNS + 1; StudentPeer::addSelectColumns($c); $startcol3 = $startcol2 + StudentPeer::NUM_COLUMNS; SubjectAccalPeer::addSelectColumns($c); $startcol4 = $startcol3 + SubjectAccalPeer::NUM_COLUMNS; SubjectCurrPeer::addSelectColumns($c); $startcol5 = $startcol4 + SubjectCurrPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol6 = $startcol5 + ClassGroupPeer::NUM_COLUMNS; $c->addJoin(VStudentCoursePeer::STUDENT_ID, StudentPeer::ID); $c->addJoin(VStudentCoursePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID); $c->addJoin(VStudentCoursePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID); $c->addJoin(VStudentCoursePeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = VStudentCoursePeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = StudentPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getStudent(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addVStudentCourse($obj1); break; } } if ($newObject) { $obj2->initVStudentCourses(); $obj2->addVStudentCourse($obj1); } $omClass = SubjectAccalPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getSubjectAccal(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addVStudentCourse($obj1); break; } } if ($newObject) { $obj3->initVStudentCourses(); $obj3->addVStudentCourse($obj1); } $omClass = SubjectCurrPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getSubjectCurr(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addVStudentCourse($obj1); break; } } if ($newObject) { $obj4->initVStudentCourses(); $obj4->addVStudentCourse($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj5 = new $cls(); $obj5->hydrate($rs, $startcol5); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj5 = $temp_obj1->getClassGroup(); if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) { $newObject = false; $temp_obj5->addVStudentCourse($obj1); break; } } if ($newObject) { $obj5->initVStudentCourses(); $obj5->addVStudentCourse($obj1); } $results[] = $obj1; } return $results; }
?> </p> </td> <td><?php echo $test_applicant->getName() ? $test_applicant->getName() : '-'; ?> </td> <td><?php echo $test_applicant->getClassGroup1() ? ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup1())->getName() : '-'; ?> </td> <td><?php echo $test_applicant->getClassGroup1() ? ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup1())->getParentName() : '-'; ?> </td> <td> <?php if ($test_applicant->getApplicantType() == TestApplicant::STATUS_NEW) { echo __('Baru'); } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_TRANSFER) { echo __('Pindahan'); } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_EXTEND) { echo __('Lanjutan'); } ?> </td>
public static function doSelectJoinAllExceptStudentDetail(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } VMemberStudentPeer::addSelectColumns($c); $startcol2 = VMemberStudentPeer::NUM_COLUMNS - VMemberStudentPeer::NUM_LAZY_LOAD_COLUMNS + 1; MemberDetailPeer::addSelectColumns($c); $startcol3 = $startcol2 + MemberDetailPeer::NUM_COLUMNS; DepartmentPeer::addSelectColumns($c); $startcol4 = $startcol3 + DepartmentPeer::NUM_COLUMNS; AcademicCalendarPeer::addSelectColumns($c); $startcol5 = $startcol4 + AcademicCalendarPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol6 = $startcol5 + ClassGroupPeer::NUM_COLUMNS; StudentPeer::addSelectColumns($c); $startcol7 = $startcol6 + StudentPeer::NUM_COLUMNS; $c->addJoin(VMemberStudentPeer::MEMBER_DETAIL_ID, MemberDetailPeer::ID); $c->addJoin(VMemberStudentPeer::DEPARTMENT_ID, DepartmentPeer::ID); $c->addJoin(VMemberStudentPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $c->addJoin(VMemberStudentPeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $c->addJoin(VMemberStudentPeer::STUDENT_ID, StudentPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = VMemberStudentPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = MemberDetailPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getMemberDetail(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addVMemberStudent($obj1); break; } } if ($newObject) { $obj2->initVMemberStudents(); $obj2->addVMemberStudent($obj1); } $omClass = DepartmentPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getDepartment(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addVMemberStudent($obj1); break; } } if ($newObject) { $obj3->initVMemberStudents(); $obj3->addVMemberStudent($obj1); } $omClass = AcademicCalendarPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getAcademicCalendar(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addVMemberStudent($obj1); break; } } if ($newObject) { $obj4->initVMemberStudents(); $obj4->addVMemberStudent($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj5 = new $cls(); $obj5->hydrate($rs, $startcol5); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj5 = $temp_obj1->getClassGroup(); if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) { $newObject = false; $temp_obj5->addVMemberStudent($obj1); break; } } if ($newObject) { $obj5->initVMemberStudents(); $obj5->addVMemberStudent($obj1); } $omClass = StudentPeer::getOMClass(); $cls = Propel::import($omClass); $obj6 = new $cls(); $obj6->hydrate($rs, $startcol6); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj6 = $temp_obj1->getStudent(); if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) { $newObject = false; $temp_obj6->addVMemberStudent($obj1); break; } } if ($newObject) { $obj6->initVMemberStudents(); $obj6->addVMemberStudent($obj1); } $results[] = $obj1; } return $results; }
public function filterDetail($c, $filters) { $filters_key = array_keys($filters); foreach ($filters_key as $key) { $value = $filters[$key]; if ($value == '' || $value == null) { continue; } if ($key == 'NG_REG_TEST_PERIOD_ID') { $c->addJoin(NgRegTestPeriodPeer::ID, NgRegTestDetailPeer::NG_REG_TEST_PERIOD_ID); $column = NgRegTestPeriodPeer::getTableMap()->getColumn('ID'); } else { $column = NgRegTestDetailPeer::getTableMap()->getColumn($key); } $name = $column->getFullyQualifiedName(); $creoleType = $column->getCreoleType(); if ($creoleType == CreoleTypes::TIMESTAMP) { $from = $value['from']; $to = $value['to']; if ($from != '' && $from != null) { $c->add($name, $from, Criteria::GREATER_EQUAL); } if ($to != '' && $to != null) { $c->add($name, $to, Criteria::LESS_EQUAL); } } else { if ($creoleType == CreoleTypes::INTEGER) { if ($name == StudentPeer::CLASS_GROUP_ID) { $cg = ClassGroupPeer::retrieveByPK($value); $c->add($name, $cg->getChildRecurs(), Criteria::IN); } else { $c->add($name, $value, Criteria::EQUAL); } } else { if ($creoleType == CreoleTypes::VARCHAR || $creoleType == CreoleTypes::CHAR) { $c->add($name, "%{$value}%", Criteria::LIKE); } } } } }
++$i; ?> "<?php echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage(); ?> ","<?php echo $test_applicant->getCode(); ?> ","<?php echo $test_applicant->getName(); ?> ","<?php echo DepartmentPeer::retrieveByPK($test_applicant->getDepartment1())->toString(); ?> ","<?php echo ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup1())->toString(); ?> ","<?php echo $test_applicant->getRegTestPeriod1() ? RegTestPeriodPeer::retrieveByPK($test_applicant->getRegTestPeriod1())->getRegPeriod()->getName() : '-'; ?> ","<?php if ($test_applicant->getApplicantType() == TestApplicant::STATUS_NEW) { echo __('Baru'); } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_TRANSFER) { echo __('Pindahan'); } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_EXTEND) { echo __('Lanjutan'); } ?> ","<?php echo $test_applicant->getYear();
public function executeGetClassByAccal() { $accal_id = $this->getRequestParameter('academic_calendar_id'); $accal = AcademicCalendarPeer::retrieveByPK($accal_id); $this->forward404Unless($accal); $cg_ids = $accal->getClassGroup()->getChildRecurs(); $c = new Criteria(); $c->add(ClassGroupPeer::ID, $cg_ids, Criteria::IN); $cgs = ClassGroupPeer::doSelectOrdered($c); $classes = array(); foreach ($cgs as $cg) { $classes[$cg->getId()] = $cg->toString(); } $this->content = $classes; $this->setTemplate('buildOptions'); }
public static function doSelectJoinAllExceptLocationRelatedByLocation2(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } TestApplicantPeer::addSelectColumns($c); $startcol2 = TestApplicantPeer::NUM_COLUMNS - TestApplicantPeer::NUM_LAZY_LOAD_COLUMNS + 1; TestApplicantDetailPeer::addSelectColumns($c); $startcol3 = $startcol2 + TestApplicantDetailPeer::NUM_COLUMNS; DepartmentPeer::addSelectColumns($c); $startcol4 = $startcol3 + DepartmentPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS; RegTestPeriodPeer::addSelectColumns($c); $startcol6 = $startcol5 + RegTestPeriodPeer::NUM_COLUMNS; DepartmentPeer::addSelectColumns($c); $startcol7 = $startcol6 + DepartmentPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol8 = $startcol7 + ClassGroupPeer::NUM_COLUMNS; RegTestPeriodPeer::addSelectColumns($c); $startcol9 = $startcol8 + RegTestPeriodPeer::NUM_COLUMNS; $c->addJoin(TestApplicantPeer::TEST_APPLICANT_DETAIL_ID, TestApplicantDetailPeer::ID); $c->addJoin(TestApplicantPeer::DEPARTMENT_1, DepartmentPeer::ID); $c->addJoin(TestApplicantPeer::CLASS_GROUP1, ClassGroupPeer::ID); $c->addJoin(TestApplicantPeer::REG_TEST_PERIOD1, RegTestPeriodPeer::ID); $c->addJoin(TestApplicantPeer::DEPARTMENT_2, DepartmentPeer::ID); $c->addJoin(TestApplicantPeer::CLASS_GROUP2, ClassGroupPeer::ID); $c->addJoin(TestApplicantPeer::REG_TEST_PERIOD2, RegTestPeriodPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = TestApplicantPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = TestApplicantDetailPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getTestApplicantDetail(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addTestApplicant($obj1); break; } } if ($newObject) { $obj2->initTestApplicants(); $obj2->addTestApplicant($obj1); } $omClass = DepartmentPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getDepartmentRelatedByDepartment1(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addTestApplicantRelatedByDepartment1($obj1); break; } } if ($newObject) { $obj3->initTestApplicantsRelatedByDepartment1(); $obj3->addTestApplicantRelatedByDepartment1($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getClassGroupRelatedByClassGroup1(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addTestApplicantRelatedByClassGroup1($obj1); break; } } if ($newObject) { $obj4->initTestApplicantsRelatedByClassGroup1(); $obj4->addTestApplicantRelatedByClassGroup1($obj1); } $omClass = RegTestPeriodPeer::getOMClass(); $cls = Propel::import($omClass); $obj5 = new $cls(); $obj5->hydrate($rs, $startcol5); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj5 = $temp_obj1->getRegTestPeriodRelatedByRegTestPeriod1(); if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) { $newObject = false; $temp_obj5->addTestApplicantRelatedByRegTestPeriod1($obj1); break; } } if ($newObject) { $obj5->initTestApplicantsRelatedByRegTestPeriod1(); $obj5->addTestApplicantRelatedByRegTestPeriod1($obj1); } $omClass = DepartmentPeer::getOMClass(); $cls = Propel::import($omClass); $obj6 = new $cls(); $obj6->hydrate($rs, $startcol6); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj6 = $temp_obj1->getDepartmentRelatedByDepartment2(); if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) { $newObject = false; $temp_obj6->addTestApplicantRelatedByDepartment2($obj1); break; } } if ($newObject) { $obj6->initTestApplicantsRelatedByDepartment2(); $obj6->addTestApplicantRelatedByDepartment2($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj7 = new $cls(); $obj7->hydrate($rs, $startcol7); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj7 = $temp_obj1->getClassGroupRelatedByClassGroup2(); if ($temp_obj7->getPrimaryKey() === $obj7->getPrimaryKey()) { $newObject = false; $temp_obj7->addTestApplicantRelatedByClassGroup2($obj1); break; } } if ($newObject) { $obj7->initTestApplicantsRelatedByClassGroup2(); $obj7->addTestApplicantRelatedByClassGroup2($obj1); } $omClass = RegTestPeriodPeer::getOMClass(); $cls = Propel::import($omClass); $obj8 = new $cls(); $obj8->hydrate($rs, $startcol8); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj8 = $temp_obj1->getRegTestPeriodRelatedByRegTestPeriod2(); if ($temp_obj8->getPrimaryKey() === $obj8->getPrimaryKey()) { $newObject = false; $temp_obj8->addTestApplicantRelatedByRegTestPeriod2($obj1); break; } } if ($newObject) { $obj8->initTestApplicantsRelatedByRegTestPeriod2(); $obj8->addTestApplicantRelatedByRegTestPeriod2($obj1); } $results[] = $obj1; } return $results; }
<?php echo input_hidden_tag('accal2', $accal2); ?> </td> </tr> <tr> <td width="20%" style="vertical-align:middle;"><label><?php echo __('Class group'); ?> </label></td> <td width="2%" style="text-align:center; vertical-align:middle;">:</td> <td style="vertical-align:middle;"> <p class="detail" style="font-weight: bold;"> <?php echo $class2 ? ClassGroupPeer::retrieveByPk($class2)->getName() : '-'; ?> </p> <?php echo input_hidden_tag('class2', $class2); ?> </td> </tr> </tbody> </table> </td></tr> </table> <table class="form"> <tr><td class="form"> <table class="form_content" width="100%">
?> <?php } ?> <?php } else { ?> <?php echo '-'; ?> <?php } ?> </td> <td><?php echo $student->getClassGroupId() ? ClassGroupPeer::retrieveByPk($student->getClassGroupId())->toString() : '-'; ?> </td> <td><?php if ($student->getStatus() == Student::STATUS_ACTIVE) { echo __('_STUDENT_STATUS_ACTIVE_'); } elseif ($student->getStatus() == Student::STATUS_INACTIVE) { echo __('_STUDENT_STATUS_INACTIVE_'); } elseif ($student->getStatus() == Student::STATUS_OVERDUE) { echo __('_STUDENT_STATUS_OVERDUE_'); } elseif ($student->getStatus() == Student::STATUS_FINAL) { echo __('_STUDENT_STATUS_FINAL_'); } elseif ($student->getStatus() == Student::STATUS_GRADUATE) { echo __('_STUDENT_STATUS_GRADUATE_'); } ?>
public static function doSelectJoinAllExceptAcademicCalendar(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } AttendanceClassPeer::addSelectColumns($c); $startcol2 = AttendanceClassPeer::NUM_COLUMNS - AttendanceClassPeer::NUM_LAZY_LOAD_COLUMNS + 1; ClassGroupPeer::addSelectColumns($c); $startcol3 = $startcol2 + ClassGroupPeer::NUM_COLUMNS; $c->addJoin(AttendanceClassPeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = AttendanceClassPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getClassGroup(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addAttendanceClass($obj1); break; } } if ($newObject) { $obj2->initAttendanceClasss(); $obj2->addAttendanceClass($obj1); } $results[] = $obj1; } return $results; }
</td> </tr> <tr> <td style="text-align:left;">Nama Calon Murid</td> <td style="text-align:center;">:</td> <td style="text-align: justify;"><?php echo $appl->getName(); ?> </td> </tr> <tr> <td style="text-align:left;">Kelas</td> <td style="text-align:center;">:</td> <td style="text-align: justify;"> <?php echo $appl->getClassGroup1() ? ClassGroupPeer::retrieveByPK($appl->getClassGroup1())->getName() . ' - ' . ClassGroupPeer::retrieveByPK($appl->getClassGroup1())->getParentName() : '-'; ?> </td> </tr> <tr> <td style="text-align:left;">Asal Sekolah</td> <td style="text-align:center;">:</td> <td style="text-align: justify;"> <?php echo $appl->getTestApplicantDetail()->getJobTitle() ? $appl->getTestApplicantDetail()->getJobTitle() : '-'; ?> </td> </tr> <?php $i = 0;
public static function doSelectJoinAllExceptEmployee(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } AbsenceEkskulPeer::addSelectColumns($c); $startcol2 = AbsenceEkskulPeer::NUM_COLUMNS - AbsenceEkskulPeer::NUM_LAZY_LOAD_COLUMNS + 1; StudentPeer::addSelectColumns($c); $startcol3 = $startcol2 + StudentPeer::NUM_COLUMNS; AcademicCalendarPeer::addSelectColumns($c); $startcol4 = $startcol3 + AcademicCalendarPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS; SchedulePeer::addSelectColumns($c); $startcol6 = $startcol5 + SchedulePeer::NUM_COLUMNS; ScheduleDetailPeer::addSelectColumns($c); $startcol7 = $startcol6 + ScheduleDetailPeer::NUM_COLUMNS; GradeComponentPeer::addSelectColumns($c); $startcol8 = $startcol7 + GradeComponentPeer::NUM_COLUMNS; $c->addJoin(AbsenceEkskulPeer::STUDENT_ID, StudentPeer::ID); $c->addJoin(AbsenceEkskulPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $c->addJoin(AbsenceEkskulPeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $c->addJoin(AbsenceEkskulPeer::SCHEDULE_ID, SchedulePeer::ID); $c->addJoin(AbsenceEkskulPeer::SCHEDULE_DETAIL_ID, ScheduleDetailPeer::ID); $c->addJoin(AbsenceEkskulPeer::GRADE_COMPONENT_ID, GradeComponentPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = AbsenceEkskulPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = StudentPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getStudent(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addAbsenceEkskul($obj1); break; } } if ($newObject) { $obj2->initAbsenceEkskuls(); $obj2->addAbsenceEkskul($obj1); } $omClass = AcademicCalendarPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getAcademicCalendar(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addAbsenceEkskul($obj1); break; } } if ($newObject) { $obj3->initAbsenceEkskuls(); $obj3->addAbsenceEkskul($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getClassGroup(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addAbsenceEkskul($obj1); break; } } if ($newObject) { $obj4->initAbsenceEkskuls(); $obj4->addAbsenceEkskul($obj1); } $omClass = SchedulePeer::getOMClass(); $cls = Propel::import($omClass); $obj5 = new $cls(); $obj5->hydrate($rs, $startcol5); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj5 = $temp_obj1->getSchedule(); if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) { $newObject = false; $temp_obj5->addAbsenceEkskul($obj1); break; } } if ($newObject) { $obj5->initAbsenceEkskuls(); $obj5->addAbsenceEkskul($obj1); } $omClass = ScheduleDetailPeer::getOMClass(); $cls = Propel::import($omClass); $obj6 = new $cls(); $obj6->hydrate($rs, $startcol6); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj6 = $temp_obj1->getScheduleDetail(); if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) { $newObject = false; $temp_obj6->addAbsenceEkskul($obj1); break; } } if ($newObject) { $obj6->initAbsenceEkskuls(); $obj6->addAbsenceEkskul($obj1); } $omClass = GradeComponentPeer::getOMClass(); $cls = Propel::import($omClass); $obj7 = new $cls(); $obj7->hydrate($rs, $startcol7); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj7 = $temp_obj1->getGradeComponent(); if ($temp_obj7->getPrimaryKey() === $obj7->getPrimaryKey()) { $newObject = false; $temp_obj7->addAbsenceEkskul($obj1); break; } } if ($newObject) { $obj7->initAbsenceEkskuls(); $obj7->addAbsenceEkskul($obj1); } $results[] = $obj1; } return $results; }
public function executeGetList() { $class_id = $this->getRequestParameter('class_group_id'); $class_group = ClassGroupPeer::retrieveByPK($class_id); $this->forward404Unless($class_group); $this->class_group = $class_group; #$c = new Criteria(); #$cton1 = $c->getNewCriterion(StudentPeer::CLASS_GROUP_ID, $class_id, Criteria::IN); #$cton2 = $c->getNewCriterion(StudentPeer::STATUS, Student::STATUS_GRADUATE, Criteria::NOT_EQUAL); #$cton3 = $c->getNewCriterion(StudentPeer::STATUS, Student::STATUS_OVERDUE, Criteria::NOT_EQUAL); #$cton2->addAnd($cton3); #$cton1->addAnd($cton2); #$c->add($cton1); $c = new Criteria(); $c->add(VStudentActivePeer::CLASS_GROUP_ID, $class_id, Criteria::IN); $c->addJoin(StudentPeer::ID, VStudentActivePeer::ID); $c->addAscendingOrderByColumn(StudentPeer::NAME); $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student'); $pager = new sfPropelPager('Student', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student')); $this->getUser()->setAttribute('page', $page, 'student'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions2 = array(array('name' => 'filter', 'color' => 'white')); $this->actions2 = $actions2; }
public static function doSelectJoinAllExceptDepartment(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } VAcademicCalendarPeer::addSelectColumns($c); $startcol2 = VAcademicCalendarPeer::NUM_COLUMNS - VAcademicCalendarPeer::NUM_LAZY_LOAD_COLUMNS + 1; AcademicCalendarPeer::addSelectColumns($c); $startcol3 = $startcol2 + AcademicCalendarPeer::NUM_COLUMNS; CurriculumPeer::addSelectColumns($c); $startcol4 = $startcol3 + CurriculumPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS; CurrSystemPeer::addSelectColumns($c); $startcol6 = $startcol5 + CurrSystemPeer::NUM_COLUMNS; $c->addJoin(VAcademicCalendarPeer::PARENT, AcademicCalendarPeer::ID); $c->addJoin(VAcademicCalendarPeer::CURRICULUM_ID, CurriculumPeer::ID); $c->addJoin(VAcademicCalendarPeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $c->addJoin(VAcademicCalendarPeer::CURR_SYSTEM_ID, CurrSystemPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = VAcademicCalendarPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = AcademicCalendarPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getAcademicCalendar(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addVAcademicCalendar($obj1); break; } } if ($newObject) { $obj2->initVAcademicCalendars(); $obj2->addVAcademicCalendar($obj1); } $omClass = CurriculumPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getCurriculum(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addVAcademicCalendar($obj1); break; } } if ($newObject) { $obj3->initVAcademicCalendars(); $obj3->addVAcademicCalendar($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getClassGroup(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addVAcademicCalendar($obj1); break; } } if ($newObject) { $obj4->initVAcademicCalendars(); $obj4->addVAcademicCalendar($obj1); } $omClass = CurrSystemPeer::getOMClass(); $cls = Propel::import($omClass); $obj5 = new $cls(); $obj5->hydrate($rs, $startcol5); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj5 = $temp_obj1->getCurrSystem(); if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) { $newObject = false; $temp_obj5->addVAcademicCalendar($obj1); break; } } if ($newObject) { $obj5->initVAcademicCalendars(); $obj5->addVAcademicCalendar($obj1); } $results[] = $obj1; } return $results; }
public static function doSelectJoinAllExceptGradeComponent(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } SchedulePeer::addSelectColumns($c); $startcol2 = SchedulePeer::NUM_COLUMNS - SchedulePeer::NUM_LAZY_LOAD_COLUMNS + 1; SubjectCurrPeer::addSelectColumns($c); $startcol3 = $startcol2 + SubjectCurrPeer::NUM_COLUMNS; EmployeePeer::addSelectColumns($c); $startcol4 = $startcol3 + EmployeePeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS; LocationPeer::addSelectColumns($c); $startcol6 = $startcol5 + LocationPeer::NUM_COLUMNS; ClassSessionPeer::addSelectColumns($c); $startcol7 = $startcol6 + ClassSessionPeer::NUM_COLUMNS; AcademicCalendarPeer::addSelectColumns($c); $startcol8 = $startcol7 + AcademicCalendarPeer::NUM_COLUMNS; GradeSpecPeer::addSelectColumns($c); $startcol9 = $startcol8 + GradeSpecPeer::NUM_COLUMNS; $c->addJoin(SchedulePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID); $c->addJoin(SchedulePeer::EMPLOYEE_ID, EmployeePeer::ID); $c->addJoin(SchedulePeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $c->addJoin(SchedulePeer::LOCATION_ID, LocationPeer::ID); $c->addJoin(SchedulePeer::CLASS_SESSION_ID, ClassSessionPeer::ID); $c->addJoin(SchedulePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $c->addJoin(SchedulePeer::GRADE_SPEC_ID, GradeSpecPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = SchedulePeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = SubjectCurrPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getSubjectCurr(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addSchedule($obj1); break; } } if ($newObject) { $obj2->initSchedules(); $obj2->addSchedule($obj1); } $omClass = EmployeePeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getEmployee(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addSchedule($obj1); break; } } if ($newObject) { $obj3->initSchedules(); $obj3->addSchedule($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getClassGroup(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addSchedule($obj1); break; } } if ($newObject) { $obj4->initSchedules(); $obj4->addSchedule($obj1); } $omClass = LocationPeer::getOMClass(); $cls = Propel::import($omClass); $obj5 = new $cls(); $obj5->hydrate($rs, $startcol5); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj5 = $temp_obj1->getLocation(); if ($temp_obj5->getPrimaryKey() === $obj5->getPrimaryKey()) { $newObject = false; $temp_obj5->addSchedule($obj1); break; } } if ($newObject) { $obj5->initSchedules(); $obj5->addSchedule($obj1); } $omClass = ClassSessionPeer::getOMClass(); $cls = Propel::import($omClass); $obj6 = new $cls(); $obj6->hydrate($rs, $startcol6); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj6 = $temp_obj1->getClassSession(); if ($temp_obj6->getPrimaryKey() === $obj6->getPrimaryKey()) { $newObject = false; $temp_obj6->addSchedule($obj1); break; } } if ($newObject) { $obj6->initSchedules(); $obj6->addSchedule($obj1); } $omClass = AcademicCalendarPeer::getOMClass(); $cls = Propel::import($omClass); $obj7 = new $cls(); $obj7->hydrate($rs, $startcol7); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj7 = $temp_obj1->getAcademicCalendar(); if ($temp_obj7->getPrimaryKey() === $obj7->getPrimaryKey()) { $newObject = false; $temp_obj7->addSchedule($obj1); break; } } if ($newObject) { $obj7->initSchedules(); $obj7->addSchedule($obj1); } $omClass = GradeSpecPeer::getOMClass(); $cls = Propel::import($omClass); $obj8 = new $cls(); $obj8->hydrate($rs, $startcol8); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj8 = $temp_obj1->getGradeSpec(); if ($temp_obj8->getPrimaryKey() === $obj8->getPrimaryKey()) { $newObject = false; $temp_obj8->addSchedule($obj1); break; } } if ($newObject) { $obj8->initSchedules(); $obj8->addSchedule($obj1); } $results[] = $obj1; } return $results; }
public static function doSelectJoinAllExceptClassType(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } CounselingPeer::addSelectColumns($c); $startcol2 = CounselingPeer::NUM_COLUMNS - CounselingPeer::NUM_LAZY_LOAD_COLUMNS + 1; EmployeePeer::addSelectColumns($c); $startcol3 = $startcol2 + EmployeePeer::NUM_COLUMNS; AcademicCalendarPeer::addSelectColumns($c); $startcol4 = $startcol3 + AcademicCalendarPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS; $c->addJoin(CounselingPeer::EMPLOYEE_ID, EmployeePeer::ID); $c->addJoin(CounselingPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $c->addJoin(CounselingPeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = CounselingPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = EmployeePeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getEmployee(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addCounseling($obj1); break; } } if ($newObject) { $obj2->initCounselings(); $obj2->addCounseling($obj1); } $omClass = AcademicCalendarPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getAcademicCalendar(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addCounseling($obj1); break; } } if ($newObject) { $obj3->initCounselings(); $obj3->addCounseling($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getClassGroup(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addCounseling($obj1); break; } } if ($newObject) { $obj4->initCounselings(); $obj4->addCounseling($obj1); } $results[] = $obj1; } return $results; }
public function executeGetListForCourse() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $cr = new Criteria(); $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $class_group_id = $this->getRequestParameter('class_group_id'); $accal = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $class = ClassGroupPeer::retrieveByPK($class_group_id); $cr->add(VCourseSchedulePeer::ACADEMIC_CALENDAR_ID, $this->getRequestParameter('academic_calendar_id')); $cr->add(VCourseSchedulePeer::CLASS_GROUP_ID, $this->getRequestParameter('class_group_id')); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if ($f != null && $f != '') { $defined_filter = true; break; } } if ($defined_filter) { $this->filters = $filters; $this->filterSubject($cr, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'course_schedule')); $this->getUser()->setAttribute('max_per_page', $rpp, 'course_schedule'); $pager = new sfPropelPager('VCourseSchedule', $rpp); $pager->setCriteria($cr); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'course_schedule')); $this->getUser()->setAttribute('page', $page, 'course_schedule'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(array('name' => 'filter', 'color' => 'white')); $filter_string = ""; if ($this->filters) { foreach ($this->filters as $key => $val) { $filter_string .= "&filters[{$key}]={$val}"; } $filter_string = preg_replace('/^&/', '', $filter_string); } $this->filter_string = $filter_string; $this->subtitle = ''; $this->actions = $actions; $this->academic_calendar_id = $academic_calendar_id; $this->class_group_id = $class_group_id; }
public function filter($c, $filters) { $filters_key = array_keys($filters); foreach ($filters_key as $key) { $value = $filters[$key]; if ($value == '' || $value == null) { continue; } if ($key == 'DEPARTMENT_ID') { $c->addJoin(AcademicCalendarPeer::ID, StudentPeer::ACADEMIC_CALENDAR_ID); $c->addJoin(DepartmentPeer::ID, AcademicCalendarPeer::DEPARTMENT_ID); $column = DepartmentPeer::getTableMap()->getColumn('ID'); } elseif ($key == 'CLASS_NAME') { $c->addJoin(ClassGroupPeer::ID, StudentPeer::CLASS_GROUP_ID); $column = ClassGroupPeer::getTableMap()->getColumn('NAME'); } else { $column = StudentPeer::getTableMap()->getColumn($key); } $name = $column->getFullyQualifiedName(); $creoleType = $column->getCreoleType(); if ($creoleType == CreoleTypes::TIMESTAMP) { $from = $value['from']; $to = $value['to']; if ($from != '' && $from != null) { $c->add($name, $from, Criteria::GREATER_EQUAL); } if ($to != '' && $to != null) { $c->add($name, $to, Criteria::LESS_EQUAL); } } else { if ($creoleType == CreoleTypes::INTEGER) { $c->add($name, $value, Criteria::EQUAL); } else { if ($creoleType == CreoleTypes::VARCHAR || $creoleType == CreoleTypes::CHAR) { $c->add($name, "%{$value}%", Criteria::LIKE); } } } } }
public static function doSelectJoinAllExceptDepartment(Criteria $c, $con = null) { $c = clone $c; if ($c->getDbName() == Propel::getDefaultDB()) { $c->setDbName(self::DATABASE_NAME); } StudentSiblingPeer::addSelectColumns($c); $startcol2 = StudentSiblingPeer::NUM_COLUMNS - StudentSiblingPeer::NUM_LAZY_LOAD_COLUMNS + 1; StudentPeer::addSelectColumns($c); $startcol3 = $startcol2 + StudentPeer::NUM_COLUMNS; StudentPeer::addSelectColumns($c); $startcol4 = $startcol3 + StudentPeer::NUM_COLUMNS; ClassGroupPeer::addSelectColumns($c); $startcol5 = $startcol4 + ClassGroupPeer::NUM_COLUMNS; $c->addJoin(StudentSiblingPeer::STUDENT_ID, StudentPeer::ID); $c->addJoin(StudentSiblingPeer::STUDENT_RELATED, StudentPeer::ID); $c->addJoin(StudentSiblingPeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $rs = BasePeer::doSelect($c, $con); $results = array(); while ($rs->next()) { $omClass = StudentSiblingPeer::getOMClass(); $cls = Propel::import($omClass); $obj1 = new $cls(); $obj1->hydrate($rs); $omClass = StudentPeer::getOMClass(); $cls = Propel::import($omClass); $obj2 = new $cls(); $obj2->hydrate($rs, $startcol2); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj2 = $temp_obj1->getStudentRelatedByStudentId(); if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) { $newObject = false; $temp_obj2->addStudentSiblingRelatedByStudentId($obj1); break; } } if ($newObject) { $obj2->initStudentSiblingsRelatedByStudentId(); $obj2->addStudentSiblingRelatedByStudentId($obj1); } $omClass = StudentPeer::getOMClass(); $cls = Propel::import($omClass); $obj3 = new $cls(); $obj3->hydrate($rs, $startcol3); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj3 = $temp_obj1->getStudentRelatedByStudentRelated(); if ($temp_obj3->getPrimaryKey() === $obj3->getPrimaryKey()) { $newObject = false; $temp_obj3->addStudentSiblingRelatedByStudentRelated($obj1); break; } } if ($newObject) { $obj3->initStudentSiblingsRelatedByStudentRelated(); $obj3->addStudentSiblingRelatedByStudentRelated($obj1); } $omClass = ClassGroupPeer::getOMClass(); $cls = Propel::import($omClass); $obj4 = new $cls(); $obj4->hydrate($rs, $startcol4); $newObject = true; for ($j = 0, $resCount = count($results); $j < $resCount; $j++) { $temp_obj1 = $results[$j]; $temp_obj4 = $temp_obj1->getClassGroup(); if ($temp_obj4->getPrimaryKey() === $obj4->getPrimaryKey()) { $newObject = false; $temp_obj4->addStudentSibling($obj1); break; } } if ($newObject) { $obj4->initStudentSiblings(); $obj4->addStudentSibling($obj1); } $results[] = $obj1; } return $results; }
public function getClassGroup($con = null) { include_once 'lib/model/om/BaseClassGroupPeer.php'; if ($this->aClassGroup === null && $this->class_group_id !== null) { $this->aClassGroup = ClassGroupPeer::retrieveByPK($this->class_group_id, $con); } return $this->aClassGroup; }
</tr> <tr> <td align="left">9.</td> <td align="left">Diterima di Sekolah ini</td> <td align="center">:</td> <td align="left"></td> </tr> <tr> <td align="left"></td> <td align="left">a. Di Kelas <?php echo $score_rule ? $score_rule->getLanguage() == 'Bilingual' ? '<i style="font-size: 80%; font-weight: normal;"> / In The Grade</i>' : '' : ''; ?> </td> <td align="center">:</td> <td align="left"><?php echo $applicant ? ClassGroupPeer::retrieveByPk($applicant->getClassGroup1())->toString() : '-'; ?> </td> </tr> <tr> <td align="left"></td> <td align="left">b. Pada Tanggal <?php echo $score_rule ? $score_rule->getLanguage() == 'Bilingual' ? '<i style="font-size: 80%; font-weight: normal;"> / On The Date of</i>' : '' : ''; ?> </td> <td align="center">:</td> <td align="left">12 Juli <?php echo $student->getYear() ? $student->getYear() : ' '; ?> </td> </tr>
public function filterCounseling($c, $filters) { $filters_key = array_keys($filters); foreach ($filters_key as $key) { $value = $filters[$key]; if ($value == '' || $value == null) { continue; } if ($key == 'NAME') { $c->addJoin(ClassCounselingPeer::STUDENT_ID, StudentPeer::ID); $column = StudentPeer::getTableMap()->getColumn('NAME'); } elseif ($key == 'CODE') { $c->addJoin(ClassCounselingPeer::STUDENT_ID, StudentPeer::ID); $column = StudentPeer::getTableMap()->getColumn('CODE'); } elseif ($key == 'CODE2') { $c->addJoin(ClassCounselingPeer::STUDENT_ID, StudentPeer::ID); $column = StudentPeer::getTableMap()->getColumn('CODE2'); } elseif ($key == 'YEAR') { $c->addJoin(ClassCounselingPeer::STUDENT_ID, StudentPeer::ID); $column = StudentPeer::getTableMap()->getColumn('YEAR'); } elseif ($key == 'SUBJECT_NAME') { $c->addJoin(ClassCounselingPeer::COURSE_SCHEDULE_ID, CourseSchedulePeer::ID); $c->addJoin(CourseSchedulePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID); $c->addJoin(SubjectCurrPeer::SUBJECT_ID, SubjectPeer::ID); $column = SubjectPeer::getTableMap()->getColumn('NAME'); } elseif ($key == 'ACADEMIC_CALENDAR_ID') { $c->addJoin(ClassCounselingPeer::COURSE_SCHEDULE_ID, CourseSchedulePeer::ID); $c->addJoin(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $column = AcademicCalendarPeer::getTableMap()->getColumn('ID'); } elseif ($key == 'CLASS_NAME') { $c->addJoin(ClassCounselingPeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $column = ClassGroupPeer::getTableMap()->getColumn('NAME'); } else { $column = ClassCounselingPeer::getTableMap()->getColumn($key); } $name = $column->getFullyQualifiedName(); $creoleType = $column->getCreoleType(); if ($creoleType == CreoleTypes::TIMESTAMP) { $c->add($name, $value, Criteria::LIKE); } else { if ($creoleType == CreoleTypes::DATE) { $c->add($name, $value, Criteria::LIKE); } else { if ($creoleType == CreoleTypes::INTEGER) { $c->add($name, $value, Criteria::EQUAL); } else { if ($creoleType == CreoleTypes::VARCHAR || $creoleType == CreoleTypes::CHAR) { $c->add($name, "%{$value}%", Criteria::LIKE); } } } } } }
private function userSchoolInit() { /* Getting User School */ $schoolCriteria = new Criteria(); $schoolCriteria->add(ClassGroupPeer::DEPARTMENT_ID, $this->department->getId(), Criteria::EQUAL); $this->school = ClassGroupPeer::doSelectOne($schoolCriteria); /* Getting User Classes */ $classesCriteria = new Criteria(); $classesCriteria->add(ClassGroupPeer::PARENT, $this->school->getId(), Criteria::EQUAL); $classTemp = ClassGroupPeer::doSelect($classesCriteria); $classArray = array(); foreach ($classTemp as $temp) { $classArray[] = $temp->getId(); } $classesCriteria2 = new Criteria(); $classesCriteria2->add(ClassGroupPeer::PARENT, $classArray, Criteria::IN); $classesCriteria2->addAscendingOrderByColumn(ClassGroupPeer::NAME); $this->classes = ClassGroupPeer::doSelect($classesCriteria2); }