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);
}
</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: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>
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;
}
<th width="30%"><?php
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() : '-';
","<?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
}
public function getCourseScheduleDetails($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());
CourseScheduleDetailPeer::addSelectColumns($criteria);
$this->collCourseScheduleDetails = CourseScheduleDetailPeer::doSelect($criteria, $con);
}
} else {
if (!$this->isNew()) {
$criteria->add(CourseScheduleDetailPeer::CLASS_SESSION_ID, $this->getId());
CourseScheduleDetailPeer::addSelectColumns($criteria);
if (!isset($this->lastCourseScheduleDetailCriteria) || !$this->lastCourseScheduleDetailCriteria->equals($criteria)) {
$this->collCourseScheduleDetails = CourseScheduleDetailPeer::doSelect($criteria, $con);
}
}
}
$this->lastCourseScheduleDetailCriteria = $criteria;
return $this->collCourseScheduleDetails;
}
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;
}
