public function executeSavePreviewCopy()
{
$class_group1 = $this->getRequestParameter('class1');
$academic1 = $this->getRequestParameter('accal1');
$class_group2 = $this->getRequestParameter('class2');
$academic2 = $this->getRequestParameter('accal2');
$c = new Criteria();
$c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic1);
$c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group1);
$c_schedules = CourseSchedulePeer::doSelect($c);
foreach ($c_schedules as $c_schedule) {
$course_schedule = new CourseSchedule();
$course_schedule->setSubjectCurrId($c_schedule->getSubjectCurrId());
$course_schedule->setKkm($c_schedule->getKkm());
$course_schedule->setClassGroupId($class_group2);
$course_schedule->setAcademicCalendarId($academic2);
$course_schedule->setEmployeeId($c_schedule->getEmployeeId());
$course_schedule->setName($c_schedule->getName());
$course_schedule->save();
$cw = new Criteria();
$cw->add(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, $c_schedule->getId());
$c_details = CourseScheduleDetailPeer::doSelect($cw);
foreach ($c_details as $c_detail) {
$course_detail = new CourseScheduleDetail();
$course_detail->setCourseSchedule($course_schedule);
$course_detail->setLocationId($c_detail->getLocationId());
$course_detail->setClassSessionId($c_detail->getClassSessionId());
$course_detail->setDay($c_detail->getDay());
$course_detail->save();
}
$cr = new Criteria();
$cr->add(CourseScheduleTutorPeer::COURSE_SCHEDULE_ID, $c_schedule->getId());
$c_tutors = CourseScheduleTutorPeer::doSelect($cr);
foreach ($c_tutors as $c_tutor) {
$course_tutor = new CourseScheduleTutor();
$course_tutor->setCourseSchedule($course_schedule);
$course_tutor->setEmployeeId($c_tutor->getEmployeeId());
$course_tutor->save();
}
}
return $this->redirect('course_sched/preview?class_group_id=' . $class_group2 . '&accal_id=' . $academic2);
}
</td>
</tr>
<tr>
<td style="vertical-align:top;"><label><?php
echo __('Jadwal');
?>
</label></td>
<td style="text-align:center; vertical-align:top;">:</td>
<td style="vertical-align:top;">
<p class="detail" style="font-weight: bold;">
<?php
$c = new Criteria();
$c->add(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, $course_schedule->getId());
$c->addDescendingOrderByColumn(CourseScheduleDetailPeer::ID);
$cs_details = CourseScheduleDetailPeer::doSelect($c);
$course_details = CourseScheduleDetailPeer::doCount($c);
if ($course_details < 1) {
echo '-';
} else {
foreach ($cs_details as $detail) {
echo '·' . $detail->getDayString() . ' - ' . $detail->getLocation()->toString() . ' <br> <font style="color: #017FC0;">(' . $detail->getClassSession()->getBegin() . ' - ' . $detail->getClassSession()->getEnd() . ')</font><br>';
}
}
?>
</p>
</td>
</tr>
</tbody>
</table>
</td></tr></table></td>
if ($i % 2 == 0) {
echo ' even';
}
?>
">
<td class='first'><?php
echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage();
?>
</td>
<td style="color: #017FC0;"><?php
echo $subject->getSubjectCurrId() ? $subject->getSubjectCurr()->getSubject()->getName() : '-';
?>
</td>
<td style="color: #017FC0;">
<?php
$cs_detail = CourseScheduleDetailPeer::retrieveByPk($subject->getId());
echo $cs_detail->getCourseSchedule()->getKkm() ? $cs_detail->getCourseSchedule()->getKkm() : '0';
?>
</td>
<?php
$c = new Criteria();
$c->add(StudentCoursePeer::STUDENT_ID, $student->getId());
$c->add(StudentCoursePeer::SUBJECT_CURR_ID, $subject->getSubjectCurrId());
$c->add(StudentCoursePeer::CLASS_GROUP_ID, $subject->getClassGroupId());
$c->add(StudentCoursePeer::ACADEMIC_CALENDAR_ID, $subject->getAcademicCalendarId());
$student_course = StudentCoursePeer::doSelectOne($c);
?>
<?php
foreach ($grade1 as $g1) {
$cr = new Criteria();
$cr->add(StudentRaportPeer::STUDENT_COURSE_ID, $student_course->getId());
<?php
if ($pager->getNbResults() < 1) {
?>
<tr class="list"><td colspan="100"><div class="no_record"><?php
echo __('No record found');
?>
</div></td></tr>
<?php
} else {
?>
<?php
$i = 0;
foreach ($pager->getResults() as $course_schedule) {
$c = new Criteria();
$c->add(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, $course_schedule->getId());
$cs_detail = CourseScheduleDetailPeer::doSelectOne($c);
?>
<tr class="list<?php
++$i;
if ($i % 2 == 0) {
echo ' even';
}
?>
">
<td style="vertical-align: middle;"><?php
echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage();
?>
</td>
<td class='first' style="vertical-align: middle;">
<?php
public function executeSelectByAccal()
{
$accal_id = $this->getRequestParameter('accal_id');
$employee_id = $this->getRequestParameter('employee_id');
$c = new Criteria();
$c->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $employee_id, Criteria::IN);
$c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $accal_id, Criteria::IN);
$c->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID);
$c->addJoin(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, CourseSchedulePeer::ID);
$c->addAscendingOrderByColumn(CourseScheduleDetailPeer::CLASS_SESSION_ID);
$objs = CourseScheduleDetailPeer::doSelect($c);
$content = array();
$disabled = array();
foreach ($objs as $o) {
$content[$o->getCourseScheduleId()] = $o->getCourseSchedule()->getSubjectCurr()->getSubject()->getName() . ' # ' . $o->getCourseSchedule()->getClassGroup()->getName();
}
$this->content = $content;
$this->disabled = $disabled;
}
echo __('Class group');
?>
</th>
</tr>
</thead>
<tbody>
<?php
$i = 0;
foreach ($pager->getResults() as $course) {
?>
<?php
$c = new Criteria();
$c->add(CourseScheduleDetailPeer::DAY, $cs_schedule->getDay());
$c->add(CourseScheduleDetailPeer::ID, $course->getId());
$c_scheds = CourseScheduleDetailPeer::doSelect($c);
$sched_count = CourseScheduleDetailPeer::doCount($c);
?>
<?php
$j = 0;
foreach ($c_scheds as $c_sched) {
?>
<tr class="list<?php
++$j;
if ($j % 2 == 0) {
echo ' even';
}
?>
">
<td class='first'><?php
echo $c_sched->getClassSession() ? $c_sched->getClassSession()->getBegin() : '-';
?>
?>
</p></td>
</tr>
<tr>
<td style="vertical-align:top;"><label><?php
echo __('Jadwal');
?>
</label></td>
<td style="text-align:center; vertical-align:top;">:</td>
<td style="vertical-align:middle;">
<p class="detail" style="font-weight: bold;">
<?php
$c = new Criteria();
$c->add(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, $course_schedule->getId());
$c->addDescendingOrderByColumn(CourseScheduleDetailPeer::ID);
$cs_details = CourseScheduleDetailPeer::doSelect($c);
foreach ($cs_details as $detail) {
echo '· ' . $detail->getDayString() . ' - ' . $detail->getLocation()->toString() . ' <br> <font style="color: #017FC0;">(' . $detail->getClassSession()->getBegin() . ' - ' . $detail->getClassSession()->getEnd() . ')</font><br>';
}
?>
</p>
</td>
</tr>
</tbody>
</table>
</td></tr>
</table>
</td>
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = CourseScheduleDetailPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setCourseScheduleId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setLocationId($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setDay($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setClassSessionId($arr[$keys[4]]);
}
}
","<?php
echo $course_schedule->getAcademicCalendar() ? $course_schedule->getAcademicCalendar()->getDepartment()->toString() : 'n/a';
?>
","<?php
echo $course_schedule->getClassGroup() ? $course_schedule->getClassGroup()->toString() : '-';
?>
","<?php
echo $course_schedule->getSubjectCurr() ? $course_schedule->getSubjectCurr()->getSubject()->toName() : '-';
?>
","<?php
$course_schedules = CourseSchedulePeer::retrieveByPK($course_schedule->getId());
$tutors = array();
foreach ($course_schedules->getCourseScheduleTutors() as $cr) {
$tutors[] = $cr->getEmployee() ? $cr->getEmployee()->getName() : '-';
}
echo join(", ", $tutors);
?>
","<?php
$c = new Criteria();
$c->add(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, $course_schedule->getId());
$c->addAscendingOrderByColumn(CourseScheduleDetailPeer::DAY);
$rows = CourseScheduleDetailPeer::doSelect($c);
$scheds = array();
foreach ($rows as $row) {
$scheds[] = $row->getDay() ? $row->getDayString() . '(' . $row->getClassSession()->getBegin() . ' - ' . $row->getClassSession()->getEnd() . ')' : '-';
}
echo join(" , ", $scheds);
?>
"
<?php
}
if ($i % 2 == 0) {
echo ' even';
}
?>
">
<td><?php
echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage();
?>
</td>
<td style="color: #017FC0;"><?php
echo $student_score->getSubjectCurrId() ? $student_score->getSubjectCurr()->getSubject()->getName() : '-';
?>
</td>
<td style="color: #017FC0;">
<?php
$cs_detail = CourseScheduleDetailPeer::retrieveByPk($student_score->getId());
echo $cs_detail->getCourseSchedule()->getKkm() ? $cs_detail->getCourseSchedule()->getKkm() : '0';
?>
</td>
<?php
$c = new Criteria();
$c->add(StudentCoursePeer::STUDENT_ID, $student->getId());
$c->add(StudentCoursePeer::SUBJECT_CURR_ID, $student_score->getSubjectCurrId());
$c->add(StudentCoursePeer::CLASS_GROUP_ID, $student_score->getClassGroupId());
$c->add(StudentCoursePeer::ACADEMIC_CALENDAR_ID, $student_score->getAcademicCalendarId());
$student_course = StudentCoursePeer::doSelectOne($c);
?>
<!-- NIlai Raport BLP -->
<?php
public function getCourseScheduleDetailsJoinLocation($criteria = null, $con = null)
{
include_once 'lib/model/om/BaseCourseScheduleDetailPeer.php';
if ($criteria === null) {
$criteria = new Criteria();
} elseif ($criteria instanceof Criteria) {
$criteria = clone $criteria;
}
if ($this->collCourseScheduleDetails === null) {
if ($this->isNew()) {
$this->collCourseScheduleDetails = array();
} else {
$criteria->add(CourseScheduleDetailPeer::CLASS_SESSION_ID, $this->getId());
$this->collCourseScheduleDetails = CourseScheduleDetailPeer::doSelectJoinLocation($criteria, $con);
}
} else {
$criteria->add(CourseScheduleDetailPeer::CLASS_SESSION_ID, $this->getId());
if (!isset($this->lastCourseScheduleDetailCriteria) || !$this->lastCourseScheduleDetailCriteria->equals($criteria)) {
$this->collCourseScheduleDetails = CourseScheduleDetailPeer::doSelectJoinLocation($criteria, $con);
}
}
$this->lastCourseScheduleDetailCriteria = $criteria;
return $this->collCourseScheduleDetails;
}
public function filterCourse($c, $filters)
{
$filters_key = array_keys($filters);
foreach ($filters_key as $key) {
$value = $filters[$key];
if ($value == '' || $value == null) {
continue;
}
if ($key == 'ACADEMIC_CALENDAR_ID') {
$c->addJoin(VCoursePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
$column = AcademicCalendarPeer::getTableMap()->getColumn('ID');
} elseif ($key == 'DEPARTMENT_ID') {
$c->addJoin(DepartmentPeer::ID, AcademicCalendarPeer::DEPARTMENT_ID);
$c->addJoin(VCoursePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID);
$column = DepartmentPeer::getTableMap()->getColumn('ID');
} elseif ($key == 'CODE_CLASS') {
$c->addJoin(VCoursePeer::CLASS_GROUP_ID, ClassGroupPeer::ID);
$column = ClassGroupPeer::getTableMap()->getColumn('NAME');
} elseif ($key == 'EMPLOYEE_NAME') {
$c->addJoin(VCoursePeer::ID, CourseScheduleDetailPeer::ID);
$c->addJoin(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, CourseSchedulePeer::ID);
$c->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID);
$c->addJoin(CourseScheduleTutorPeer::EMPLOYEE_ID, EmployeePeer::ID);
$column = EmployeePeer::getTableMap()->getColumn('NAME');
} elseif ($key == 'DAY') {
$c->addJoin(VCoursePeer::ID, CourseScheduleDetailPeer::ID);
$column = CourseScheduleDetailPeer::getTableMap()->getColumn('DAY');
} elseif ($key == 'SUBJECT_ID') {
$c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID);
$c->addJoin(SubjectCurrPeer::ID, VCoursePeer::SUBJECT_CURR_ID);
$column = SubjectCurrPeer::getTableMap()->getColumn($key);
} elseif ($key == 'SUBJECT_NAME') {
$c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID);
$c->addJoin(SubjectCurrPeer::ID, VCoursePeer::SUBJECT_CURR_ID);
$column = SubjectPeer::getTableMap()->getColumn('NAME');
} else {
$column = VCoursePeer::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) {
$c->add($name, "%{$value}%", Criteria::LIKE);
}
}
}
}
}
public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(CourseScheduleDetailPeer::ID, $pks, Criteria::IN);
$objs = CourseScheduleDetailPeer::doSelect($criteria, $con);
}
return $objs;
}
public function executeDeleteSchedule2()
{
$course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id'));
$this->course_schedule = $course_schedule;
$c = new Criteria();
$c->add(VCoursePeer::ID, $this->getRequestParameter('vcourse_id'));
$c_schedule = VCoursePeer::doSelectOne($c);
$this->forward404Unless($c_schedule);
$cs_detail = CourseScheduleDetailPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($cs_detail);
$cs_detail->delete();
return $this->redirect('course_schedule/edit?id=' . $c_schedule->getId());
}
<?php
if ($pager->getNbResults() < 1) {
?>
<tr class="list"><td colspan="100"><div class="no_record"><?php
echo __('No record found');
?>
</div></td></tr>
<?php
} else {
?>
<?php
$i = 0;
foreach ($pager->getResults() as $course_schedule) {
$c = new Criteria();
$c->add(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, $course_schedule->getId());
$course_schedule->child = CourseScheduleDetailPeer::doCount($c);
?>
<tr id='cs_<?php
echo $course_schedule->getId();
?>
' class="list<?php
++$i;
if ($i % 2 == 0) {
echo ' even';
}
?>
">
<td id='cs_<?php
echo $course_schedule->getId();
?>
_expand' style="vertical-align: middle; text-align: center;">
