public function getStudent() { $c = new Criteria(); $c->add(StudentPeer::ID, $this->getPayer()); $student = StudentPeer::doSelectOne($c); return $student; }
<p class="user_detail" style="padding-top: 5px;"><?php echo link_to_function('Edit Akun', visual_effect('toggle_appear', 'edit_account', array('onclick' => 'this.blur()')), 'class=user_info_black title="' . __('Edit Akun') . '"'); ?> </p> </td> </tr> <tr id="edit_account" style="display:none; line-height:20px;"> <td> <?php if ($this->getContext()->getUser()->getAttribute('usertype', '', 'bo') == 'student') { ?> <?php $username = $this->getContext()->getUser()->getAttribute('username', '', 'bo'); $c = new Criteria(); $c->add(StudentPeer::CODE, $this->getContext()->getUser()->getAttribute('username_long', '', 'bo')); $user = StudentPeer::doSelectOne($c); ?> <?php echo form_tag('user/updateStudent'); ?> <input type="hidden" value="<?php #echo $user->getId() ?> " name="id" id="id" /> <label style="color:#000; font-weight: bold; text-align:left;"><?php echo __('Username'); ?> </label><br /> <input type="text" name="login" id="login" value="<?php echo $username; ?>
public function executeGetListScore() { $cur13Lib = new cur13Lib(); $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $class_group_id = $this->getRequestParameter('class_group_id'); $class_group = ClassGroupPeer::retrieveByPK($class_group_id); $this->forward404Unless($class_group); $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->forward404Unless($academic_calendar); ## Cek apakah Guru Tersebut merupakan Walas dari kelas ini $cf = new Criteria(); $cf->add(CounselingTutorPeer::EMPLOYEE_ID, $employee->getId()); $cf->addJoin(CounselingPeer::ID, CounselingTutorPeer::COUNSELING_ID); $cf->add(CounselingPeer::CLASS_GROUP_ID, $class_group->getId()); $cf->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent()); $counsel_tutor = CounselingPeer::doSelectOne($cf); $this->counsel_tutor = $counsel_tutor; $c = new Criteria(); if ($cur13Lib->isFullAccess($employee)) { $cf = new Criteria(); $cf->addJoin(CounselingPeer::ID, CounselingTutorPeer::COUNSELING_ID); $cf->add(CounselingPeer::CLASS_GROUP_ID, $class_group->getId()); $cf->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent()); $counsel_tutor = CounselingPeer::doSelectOne($cf); $this->counsel_tutor = $counsel_tutor; $c = new Criteria(); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId()); $c->addAscendingOrderByColumn(CourseSchedulePeer::CLASS_GROUP_ID); } else { $c = new Criteria(); $c->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $employee->getId(), Criteria::IN); $c->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId()); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); if (!$this->getRequest()->getParameter('sort') && !$this->getUser()->getAttribute('sort_field', null, 'course')) { $c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID); $c->addJoin(CourseSchedulePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID); $c->addAscendingOrderByColumn(SubjectPeer::NAME); } } /* $c->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $employee->getId(), Criteria::IN); $c->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId(), Criteria::IN); ## Khusus Home Session $cton1 = $c->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 84, Criteria::NOT_IN); $cton2 = $c->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 85, Criteria::NOT_IN); $cton1->addAnd($cton2); $c->add($cton1); if (!$this->getRequest()->getParameter('sort') && !$this->getUser()->getAttribute('sort_field', null, 'course')) { $c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID); $c->addJoin(CourseSchedulePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID); $c->addAscendingOrderByColumn(SubjectPeer::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(), 'course')); $this->getUser()->setAttribute('max_per_page', $rpp, 'course'); $pager = new sfPropelPager('CourseSchedule', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'course')); $this->getUser()->setAttribute('page', $page, 'course'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $cw = new Criteria(); $cw->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $employee->getId(), Criteria::IN); $cw->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID); $cw->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cw->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId(), Criteria::IN); ## Khusus Home Session $cton1 = $cw->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 84, Criteria::NOT_IN); $cton2 = $cw->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 85, Criteria::NOT_IN); $cton1->addAnd($cton2); $cw->add($cton1); $cw->addAscendingOrderByColumn(CourseSchedulePeer::ID); $cw->setLimit(1); $course_schedule = CourseSchedulePeer::doSelectOne($cw); ## Menangkap satu ID Siswa $ct = new Criteria(); $ct->add(StudentAccalPeer::CLASS_GROUP_ID, $class_group->getId()); $ct->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $ct->addJoin(StudentPeer::ID, StudentAccalPeer::STUDENT_ID); $ct->add(StudentPeer::STATUS, 2, Criteria::NOT_EQUAL); $ct->add(StudentPeer::STATUS, 3, Criteria::NOT_EQUAL); $ct->addAscendingOrderByColumn(StudentPeer::NAME); $ct->setLimit(1); $student = StudentPeer::doSelectOne($ct); $this->student = $student; $this->setTemplate('getCourse'); $actions = array(); $this->actions = $actions; if ($academic_calendar->getCourseModel() == 'A') { $this->term = ScoreRule::ONE; } else { $this->term = ScoreRule::TWO; } $this->course_schedule = $course_schedule; $this->subtitle = $academic_calendar->toString() . ' # ' . $class_group->toString(); $this->employee_id = $employee_id; $this->employee = $employee; $this->academic_calendar = $academic_calendar; $this->class_group = $class_group; }
public function executeEditStudent() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, $this->getModuleName()); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); if (!$acl) { $this->forward('default', 'error404'); } $this->can_add = $acl->getAddPriv() == 1; $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $member = MemberPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($member); $this->member_detail = $member->getMemberDetail(); $c = new Criteria(); $c->add(StudentPeer::CODE, $member->getCode()); $student = StudentPeer::doSelectOne($c); #$student = StudentPeer::retrieveByPk($this->getRequestParameter('student_id')); $this->forward404Unless($student); $this->student_detail = $student->getStudentDetail(); if ($this->hasRequestParameter('no_reg') && $this->getRequestParameter('no_reg') != '' && $this->getRequestParameter('no_reg') != null) { $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'member/deleteStudent?id=' . $member->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'member/listStudent?filters[NO_REG]=' . $this->getRequestParameter('no_reg'), 'color' => 'white')); } elseif ($this->hasRequestParameter('code') && $this->getRequestParameter('code') != '' && $this->getRequestParameter('code') != null) { $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'member/deleteStudent?id=' . $member->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'member/listStudent?filters[CODE]=' . $this->getRequestParameter('code'), 'color' => 'white')); } elseif ($this->hasRequestParameter('dept_id') && $this->getRequestParameter('dept_id') != '' && $this->getRequestParameter('dept_id') != null) { $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'member/deleteStudent?id=' . $member->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'member/listStudent?filters[DEPARTMENT_ID]=' . $this->getRequestParameter('dept_id'), 'color' => 'white')); } elseif ($this->hasRequestParameter('status') && $this->getRequestParameter('status') != '' && $this->getRequestParameter('status') != null) { $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'member/deleteStudent?id=' . $member->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'member/listStudent?filters[STATUS]=' . $this->getRequestParameter('status'), 'color' => 'white')); } elseif ($this->hasRequestParameter('name') && $this->getRequestParameter('name') != '' && $this->getRequestParameter('name') != null) { $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'member/deleteStudent?id=' . $member->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'member/listStudent?filters[NAME]=' . $this->getRequestParameter('name'), 'color' => 'white')); } else { $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'member/deleteStudent?id=' . $member->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'member/listStudent', 'color' => 'white')); } $this->filter_noreg = $this->getRequestParameter('no_reg'); $this->filter_code = $this->getRequestParameter('code'); $this->filter_deptid = $this->getRequestParameter('dept_id'); $this->filter_status = $this->getRequestParameter('status'); $this->filter_name = $this->getRequestParameter('name'); $this->subtitle = $member->toString() . ' - id:' . $member->getId(); $this->type = 'edit'; $this->member = $member; $this->student = $student; $this->actions = $actions; }
public function executeDoLogin() { if ($this->hasRequestParameter('login_user') && $this->hasRequestParameter('login_password')) { // check if the user exists $c = new Criteria(); $c->add(UserPeer::LOGIN, $this->getRequestParameter('login_user')); $user = UserPeer::doSelectOne($c); if ($user) { // check if the password is correct $password = $this->getRequestParameter('login_password'); $crypted = sha1(sfConfig::get('app_salt') . $password); if ($crypted == $user->getPassword()) { // sign in $this->getContext()->getUser()->signIn($user); // proceed to home page $this->setTemplate('index'); return; } } else { $c = new Criteria(); $c->add(StudentPeer::CODE, $this->getRequestParameter('login_user')); $user = StudentPeer::doSelectOne($c); if ($user) { // check if the password is correct $password = $this->getRequestParameter('login_password'); $crypted = sha1(sfConfig::get('app_salt') . $password); if ($crypted == $user->getPassword()) { // sign in $this->getContext()->getUser()->signInStudent($user); // proceed to home page $this->setTemplate('index'); return; } } else { $c = new Criteria(); $c->add(EmployeePeer::EMP_NO, $this->getRequestParameter('login_user')); $user = EmployeePeer::doSelectOne($c); if ($user) { // check if the password is correct $password = $this->getRequestParameter('login_password'); $crypted = sha1(sfConfig::get('app_salt') . $password); if ($crypted == $user->getPassword()) { // sign in $this->getContext()->getUser()->signInLector($user); // proceed to home page $this->setTemplate('index'); return; } } } } // an error was found $this->getRequest()->setError('login_error_title', 'Login failed'); $this->getRequest()->setError('login_error_msg', 'Your username or password are not correct. Please try again.'); $this->getRequest()->setParameter('login_submit', null); return $this->forward('default', 'login'); } else { $this->forward('default', 'login'); } }
public function getStudent() { $c = new Criteria(); $c->add(StudentPeer::PERSON_ID, $this->getId()); return StudentPeer::doSelectOne($c); }
public function getStudentId($criteria = null, $con = null) { $c = new Criteria(); $c->add(StudentPeer::MEMBER_ID, $this->getId()); return StudentPeer::doSelectOne($c); }
public function getNameWriters($separator = null) { $writers = array(); if ($this->getCatCategory() && $this->getCatCategory()->getCatTemplate() && $this->getCatCategory()->getCatTemplate()->getCode() == 'Book') { $catalog_writers = $this->getCatalogWritersJoinWriter(); foreach ($catalog_writers as $cw) { array_push($writers, $cw->getWriter()->getName()); } return join($separator ? $separator : ' / ', $writers); } elseif ($this->getCatCategory() && $this->getCatCategory()->getCatTemplate() && $this->getCatCategory()->getCatTemplate()->getCode() == 'ebook') { $catalog_writers = $this->getCatalogWritersJoinWriter(); foreach ($catalog_writers as $cw) { array_push($writers, $cw->getWriter()->getName()); } return join($separator ? $separator : ' / ', $writers); } else { if ($this->getCatCategoryId() == Catalog::STUDENT) { $cd = new Criteria(); $cd->add(CatalogStudentPeer::CATALOG_ID, $this->getId()); $cd->addJoin(StudentPeer::ID, CatalogStudentPeer::STUDENT_ID); $student = StudentPeer::doSelectOne($cd); return $student->getName(); } elseif ($this->getCatCategoryId() == Catalog::TEACHER) { $cd = new Criteria(); $cd->add(CatalogStudentPeer::CATALOG_ID, $this->getId()); $cd->addJoin(StudentPeer::ID, CatalogStudentPeer::STUDENT_ID); $student = StudentPeer::doSelectOne($cd); return $student->getName(); } elseif ($this->getCatCategoryId() == Catalog::MOSLEM) { $catalog_writers = $this->getCatalogWritersJoinWriter(); foreach ($catalog_writers as $cw) { array_push($writers, $cw->getWriter()->getName()); } return join($separator ? $separator : ' / ', $writers); } else { return $this->getStudentName(); } } }