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();
}
}
}
