public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = CounselingTutorPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setCounselingId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setEmployeeId($arr[$keys[2]]); } }
</tr> <tr><td colspan="3" height="30px"></td></tr> <tr> <td></td> <td style="text-align: left; font-size: 10px; font-weight: bold;"> <?php $c = new Criteria(); $c->add(EmployeePeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $c->add(EmployeePeer::STAFF_TYPE_ID, 14); $employee = EmployeePeer::doSelectOne($c); echo $employee->getName() ? $employee->getName() : '-'; ?> </td> <td style="text-align: left; font-size: 10px; font-weight: bold;"> <?php $cb = new Criteria(); $cb->add(CounselingTutorPeer::COUNSELING_ID, $counseling->getId()); $cb->addAscendingOrderByColumn(CounselingTutorPeer::ID); $counseling_tutor = CounselingTutorPeer::doSelect($cb); $tutors = array(); foreach ($counseling_tutor as $cr) { $tutors[] = $cr->getEmployee() ? $cr->getEmployee()->getName() : ''; } echo join(", ", $tutors); ?> </td> </tr> </table> </center>
public function getCounselingTutorsJoinCounseling($criteria = null, $con = null) { include_once 'lib/model/om/BaseCounselingTutorPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collCounselingTutors === null) { if ($this->isNew()) { $this->collCounselingTutors = array(); } else { $criteria->add(CounselingTutorPeer::EMPLOYEE_ID, $this->getId()); $this->collCounselingTutors = CounselingTutorPeer::doSelectJoinCounseling($criteria, $con); } } else { $criteria->add(CounselingTutorPeer::EMPLOYEE_ID, $this->getId()); if (!isset($this->lastCounselingTutorCriteria) || !$this->lastCounselingTutorCriteria->equals($criteria)) { $this->collCounselingTutors = CounselingTutorPeer::doSelectJoinCounseling($criteria, $con); } } $this->lastCounselingTutorCriteria = $criteria; return $this->collCounselingTutors; }
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(CounselingTutorPeer::ID, $pks, Criteria::IN); $objs = CounselingTutorPeer::doSelect($criteria, $con); } return $objs; }
public function executeSave() { $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'); $counseling = new Counseling(); $counseling->setId($this->getRequestParameter('id')); $counseling->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $counseling->setClassGroupId($this->getRequestParameter('class_group_id')); $counseling->setEmployeeId($this->getRequestParameter('employee_id')); $counseling->setClassTypeId($this->getRequestParameter('class_type_id')); $counseling->save(); $c = new Criteria(); $c->add(CounselingTutorPeer::COUNSELING_ID, $counseling->getId()); CounselingTutorPeer::doDelete($c); $tutors = $this->getRequestParameter('isSelected'); if ($tutors) { foreach ($tutors as $id) { $cr = new CounselingTutor(); $cr->setCounseling($counseling); $cr->setEmployeeId($id); $cr->save(); } } return $this->redirect('counselor/edit?id=' . $counseling->getId()); }
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'); $counseling = CounselingPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($counseling); $counseling->setId($this->getRequestParameter('id')); $counseling->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $counseling->setClassGroupId($this->getRequestParameter('class_group_id')); $counseling->save(); $c = new Criteria(); $c->add(CounselingTutorPeer::COUNSELING_ID, $counseling->getId()); CounselingTutorPeer::doDelete($c); $tutors = $this->getRequestParameter('isSelected'); if ($tutors) { foreach ($tutors as $id) { $cr = new CounselingTutor(); $cr->setCounseling($counseling); $cr->setEmployeeId($id); $cr->save(); } } $params = array(); foreach (explode('&', $this->getRequestParameter('student_list_ser')) as $p) { $p = explode('=', $p); $params[rawurldecode($p[0])][] = rawurldecode($p[1]); } $accal = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('academic_calendar_id')); if (array_key_exists('students', $params)) { foreach ($params['students'] as $stu_id) { $stu = StudentPeer::retrieveByPk($stu_id); $stu->setAcademicCalendarId($counseling->getAcademicCalendarId()); $stu->setClassGroupId($counseling->getClassGroupId()); $stu->save(); $c = new Criteria(); $c->add(AcademicCalendarPeer::PARENT, $counseling->getAcademicCalendarId()); $academics = AcademicCalendarPeer::doSelect($c); if ($academics) { foreach ($academics as $academic) { $cr = new Criteria(); $cr->add(StudentAccalPeer::STUDENT_ID, $stu_id); $cr->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic->getId()); #$cr->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $stu_accal = StudentAccalPeer::doSelectOne($cr); if ($stu_accal == null) { $stu_accal = new StudentAccal(); } $stu_accal->setStudentId($stu_id); $stu_accal->setAcademicCalendarId($academic->getId()); $stu_accal->setClassGroupId($counseling->getClassGroupId()); $stu_accal->save(); } } } } return $this->redirect('counselor/showPreview?id=' . $counseling->getId()); }
} ?> </tbody> </table> <br /><br /> <table align="center" style="border-collapse:collapse; margin-left: 0px;width:90%; page-break-after: always;"> <tr> <?php $cb = new Criteria(); $cb->add(CounselingTutorPeer::COUNSELING_ID, $counseling->getId()); $cb->addAscendingOrderByColumn(CounselingTutorPeer::ID); $counseling_tutor = CounselingTutorPeer::doSelect($cb); $tutor_count = CounselingTutorPeer::doCount($cb); ?> <?php if ($tutor_count > 1) { ?> <td width="40%" style="vertical-align: top; font-size: 11px;"></td> <td width="60%" style="vertical-align: top; font-size: 11px;"> <?php } else { ?> <td width="60%" style="vertical-align: top; font-size: 11px;"></td>