public function executeEnquirer() { $this->applicant = $this->applicant; $this->error = false; $this->department = DepartmentPeer::retrieveByPK($this->applicant->getDepartment1()); $this->classGroup = ClassGroupPeer::retrieveByPK($this->applicant->getClassGroup1()); }
public function departmentAvailable($id) { $return = array(); $current = DepartmentPeer::retrieveByPK($id); if ($current) { $return[] = $id; } else { return null; } $childCriteria = new Criteria(); $childCriteria->add(DepartmentPeer::PARENT, $id, Criteria::EQUAL); $child = DepartmentPeer::doSelect($childCriteria); if (!$child) { return $return; } $childArray = array(); foreach ($child as $c) { $return[] = $c->getId(); $childArray[] = $c->getId(); } $moreChildCriteria = new Criteria(); $moreChildCriteria->add(DepartmentPeer::PARENT, $childArray, Criteria::IN); $moreChild = DepartmentPeer::doSelect($moreChildCriteria); if (!$moreChild) { return $return; } foreach ($moreChild as $c) { $return[] = $c->getId(); } return $return; //$moreChildCriteria = new Criteria() }
public function getAllParentDepartmentId($departmentId) { $thisDepartment = DepartmentPeer::retrieveByPK($departmentId); if (!$thisDepartment) { if (SF_ENVIRONMENT == 'dev') { echo 'department dengan id ' . $departmentId . ' tidak ditemukan'; } return false; } $department = array(); $department[] = $thisDepartment->getId(); $current = $thisDepartment; $stop = false; $n = 0; while (!$stop) { if ($current->getParent() < 1) { $stop = true; break; } $parent = DepartmentPeer::retrieveByPK($current->getParent()); if (!$parent) { $stop = true; break; } else { $department[] = $parent->getId(); $current = $parent; } } return $department; }
public function generateApplicantCode($status, $department) { $year = date('Y'); $month = date('m'); if ($status != NgStatusApplicant::CONFIRMED) { $code_appl = 'REG'; } else { $code_appl = 'FRM'; } $dept_code = DepartmentPeer::retrieveByPK($department)->getNumCode() . '-'; $stu_code = ParamsPeer::retrieveByCode('applicant_code'); $sc = $stu_code->getValue(); $sc = explode('$', $sc); array_shift($sc); $code_len = 0; $code = ''; foreach ($sc as $k => $v) { $v = explode('#', $v); if ($v[0] == 'app') { $code_len += $v[1]; $code .= str_pad($code_appl, $v[1], '0', STR_PAD_LEFT); } elseif ($v[0] == 'dept') { $code .= str_pad($dept_code, $v[1], '0', STR_PAD_LEFT); $code_len += $v[1]; } elseif ($v[0] == 'year') { if (strlen($year) <= $v[1]) { $code .= str_pad($year, $v[1], '0', STR_PAD_LEFT); } else { $code .= substr($year, strlen($year) - $v[1]); } $code_len += $v[1]; } elseif ($v[0] == 'month') { if (strlen($month) <= $v[1]) { $code .= str_pad($month, $v[1], '0', STR_PAD_LEFT); } else { $code .= substr($month, strlen($month) - $v[1]); } $code_len += $v[1]; } elseif ($v[0] == 'seq') { $c = new Criteria(); $c->add(NgTestApplicantPeer::CODE, $code . '%', Criteria::LIKE); $c->addDescendingOrderByColumn(NgTestApplicantPeer::CODE); $c->setLimit(1); $last_applicant = NgTestApplicantPeer::doSelectOne($c); if ($last_applicant) { $lap = $last_applicant->getCode(); $lap = substr_replace($lap, '', 0, $code_len); $lap = substr($lap, 0, $v[1]); $lap++; $code .= str_pad($lap, $v[1], '0', STR_PAD_LEFT); } else { $code .= str_pad(1, $v[1], '0', STR_PAD_LEFT); break; } } $sc[$k] = $v; } return $code; }
public function getCourseModelRecurs() { if (!$this->getCourseModel()) { if ($this->getParent()) { $p = DepartmentPeer::retrieveByPK($this->getParent()); return $p->getCourseModelRecurs(); } return self::CM_CUSTOM; } return $this->getCourseModel(); }
/** * Implementation for 'GET' method for Rest API * * @param mixed $depUid Primary key * * @return array $result Returns array within multiple records or a single record depending if * a single selection was requested passing id(s) as param */ protected function get($depUid = null) { $result = array(); try { $noArguments = true; $argumentList = func_get_args(); foreach ($argumentList as $arg) { if (!is_null($arg)) { $noArguments = false; } } if ($noArguments) { $criteria = new Criteria('workflow'); $criteria->addSelectColumn(DepartmentPeer::DEP_UID); $criteria->addSelectColumn(DepartmentPeer::DEP_PARENT); $criteria->addSelectColumn(DepartmentPeer::DEP_MANAGER); $criteria->addSelectColumn(DepartmentPeer::DEP_LOCATION); $criteria->addSelectColumn(DepartmentPeer::DEP_STATUS); $criteria->addSelectColumn(DepartmentPeer::DEP_REF_CODE); $criteria->addSelectColumn(DepartmentPeer::DEP_LDAP_DN); $dataset = AppEventPeer::doSelectRS($criteria); $dataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); while ($dataset->next()) { $result[] = $dataset->getRow(); } } else { $record = DepartmentPeer::retrieveByPK($depUid); if ($record) { $result = $record->toArray(BasePeer::TYPE_FIELDNAME); } else { $paramValues = ""; foreach ($argumentList as $arg) { $paramValues .= strlen($paramValues) ? ', ' : ''; if (!is_null($arg)) { $paramValues .= "{$arg}"; } else { $paramValues .= "NULL"; } } throw new RestException(417, "table Department ({$paramValues})"); } } } catch (RestException $e) { throw new RestException($e->getCode(), $e->getMessage()); } catch (Exception $e) { throw new RestException(412, $e->getMessage()); } return $result; }
public function signInTestApplicant($user) { $this->addCredential('bo'); $this->setAttribute('user_id', $user->getId(), 'bo'); $this->setAttribute('username_long', $user->getName(), 'bo'); $this->setAuthenticated2(true, 'bo'); $this->setAttribute('username', $user->getCode(), 'bo'); $this->setAttribute('department_id1', DepartmentPeer::retrieveByPK($user->getDepartment1())->getId(), 'bo'); $this->setAttribute('department1_name', DepartmentPeer::retrieveByPK($user->getDepartment1())->getName(), 'bo'); #$this->setAttribute('department_id2', $user->getDepartment2()? DepartmentPeer::retrieveByPK($user->getDepartment2())->getId() : '', 'bo'); #$this->setAttribute('department2_name', $user->getDepartment2()? DepartmentPeer::retrieveByPK($user->getDepartment2())->getName() : '', 'bo'); $this->setAttribute('class_name1', ClassGroupPeer::retrieveByPK($user->getClassGroup1())->getName(), 'bo'); $this->setAttribute('class_parent1', ClassGroupPeer::retrieveByPK($user->getClassGroup1())->getParentName(), 'bo'); #$this->setAttribute('class_name2', $user->getClassGroup2()? ClassGroupPeer::retrieveByPK($user->getClassGroup2())->getName() : '', 'bo'); #$this->setAttribute('class_parent2', $user->getClassGroup2()? ClassGroupPeer::retrieveByPK($user->getClassGroup2())->getParentName() : '', 'bo'); $this->setAttribute('login_time', time(), 'bo'); }
public function executeSearchByDepartment(sfWebRequest $request) { $conn = Propel::getConnection(); $this->searchType = searchActions::SEARCH_BY_DEPARTMENT; $rawDeptList = DepartmentPeer::getAll($conn); $deptList = array(); foreach ($rawDeptList as $obj) { $deptList[$obj->getId()] = $obj->getId(); } $this->deptList = $deptList; if ($request->hasParameter("deptId")) { $deptId = $request->getParameter("deptId"); if (helperFunctions::isMaliciousString($deptId)) { $this->forward404(); } $this->deptId = $deptId; $deptObj = DepartmentPeer::retrieveByPK($deptId, $conn); $this->resultTitle = "Results for " . $deptObj->getId() . " (" . $deptObj->getDescr() . ")"; $this->results = $deptObj->getCourses(null, $conn); } else { $this->deptId = $rawDeptList[0]->getId(); } }
</td> </tr> </table> </td> <td width="50%" class="first"> <table border="0" width="100%"> <tr> <td class="first" style="vertical-align:middle;" width="30%"><label><?php echo __('Department_2'); ?> </label></td> <td class="first" width="2%" style="text-align:center; vertical-align:middle;">:</td> <td class="first" style="vertical-align:middle;"> <p class="detail"> <b><?php echo $test_applicant->getDepartment2() ? DepartmentPeer::retrieveByPK($test_applicant->getDepartment2())->toString() : '-'; ?> </b></p> </td> </tr> <tr> <td style="vertical-align:middle;" width="30%"><label><?php echo __('Class Group'); ?> </label></td> <td width="2%" style="text-align:center; vertical-align:middle;">:</td> <td style="vertical-align:middle;"> <p class="detail"><b> <?php echo $test_applicant->getClassGroup2() ? ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup2())->toString() : '-'; ?>
public function executeGetByDepartment() { $dept_id = $this->getRequestParameter('department_id'); $dept = DepartmentPeer::retrieveByPK($dept_id); $this->forward404Unless($dept); $c = new Criteria(); $c->add(AcademicCalendarPeer::CURRICULUM_ID, CurriculumPeer::ID); $c->add(CurriculumPeer::DEPARTMENT_ID, $dept_id); $objs = AcademicCalendarPeer::doSelectFiltered($c); $array = array(); if ($this->getRequestParameter('include_blank') == 'true') { $array[] = ''; } foreach ($objs as $obj) { $array[$obj->getId()] = $obj->toString(); } $this->content = $array; $this->setTemplate('buildOptions'); }
?> </div> <div style="float:left; width: 50%;"> <h2 class="titlesubmenu">Username</h2> <h3 class="titletext"><?php echo $this->getContext()->getUser()->getAttribute('username', '', 'bo'); ?> </h3> <h2 class="titlesubmenu">Role</h2> <h3 class="titletext"><?php echo UserGroupPeer::retrieveByPK($this->getContext()->getUser()->getAttribute('group_id', '', 'bo'))->getName(); ?> </h3> <h2 class="titlesubmenu">Tingkat</h2> <h3 class="titletext"><?php echo DepartmentPeer::retrieveByPK($this->getContext()->getUser()->getAttribute('department_id', '', 'bo'))->getName(); ?> </h3> </div> </div> <?php $c = new Criteria(); $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $c->add(PublicInformationPeer::DEPARTMENT_ID, $dept->getChildRecurs(), Criteria::IN); $c->add(PublicInformationPeer::PUBLISHED, 1, Criteria::IN); $information = PublicInformationPeer::doSelect($c); ?> <div class="home_news"> <h1 class="titlecontent"><?php echo __('PublicInformation'); ?>
</td> <td class='first' nowrap> <?php echo DepartmentPeer::retrieveByPK($test_applicant->getDepartment1())->toString() . ' (' . $test_applicant->getIsPass1() . '-' . $test_applicant->getRank1() . ')'; ?> </td> <td class='first'><?php echo ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup1())->toString(); ?> </td> <td class='first'><?php echo $test_applicant->getRegTestPeriod1() ? RegTestPeriodPeer::retrieveByPK($test_applicant->getRegTestPeriod1())->getRegPeriod()->getName() : '-'; ?> </td> <td nowrap><?php echo $test_applicant->getDepartment2() ? DepartmentPeer::retrieveByPK($test_applicant->getDepartment2())->toString() . ' (' . $test_applicant->getIsPass1() . '-' . $test_applicant->getRank1() . ')' : '-'; ?> </td> <td><?php echo $test_applicant->getClassGroup2() ? ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup2())->toString() : '-'; ?> </td> <td><?php echo $test_applicant->getRegTestPeriod2() ? RegTestPeriodPeer::retrieveByPK($test_applicant->getRegTestPeriod2())->getRegPeriod()->getName() : '-'; ?> </td> <td ><?php if ($test_applicant->getApplicantType() == TestApplicant::STATUS_NEW) { echo __('Baru'); } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_TRANSFER) { echo __('Pindahan');
public function save($param) { $department_id = $param['department_id']; $departmentAvailable = $this->tools->departmentAvailable($department_id); $article = new WebArticle(); if (empty($param['section'])) { $this->jsonwrapper->show_json_error('section', 'Kolom section harap diisi.'); } $articleSection = DepartmentPeer::retrieveByPK($param['section']); if (!$articleSection) { $this->jsonwrapper->show_json_error('type', 'Kolom article type harap diisi.'); } if (!in_array($param['section'], $departmentAvailable)) { $this->jsonwrapper->show_json_error('forbidden', 'Maaf, anda tidak dapat membuat article dalam section ini.'); } if (empty($param['title'])) { $this->jsonwrapper->show_json_error('title', 'Kolom title harap diisi.'); } if (empty($param['initial'])) { $this->jsonwrapper->show_json_error('initial', 'Kolom initial harap diisi.'); } if (empty($param['description'])) { $this->jsonwrapper->show_json_error('description', 'Kolom description harap diisi.'); } if (!empty($param['id'])) { $article = WebArticlePeer::retrieveByPK($param['id']); if (!$article) { $this->jsonwrapper->show_json_error('id', 'Article tidak ditemukan.'); } if (!in_array($article->getDepartmentId(), $departmentAvailable)) { $this->jsonwrapper->show_json_error('forbidden', 'Maaf, anda tidak dapat mengedit article ini.'); } } else { $article->setPublished(0); $article->setCreated(date('Y-m-d H:i:s')); } /* Add */ $article->setTitle($param['title']); $article->setInitial($param['initial']); $article->setDepartmentId($param['section']); $article->setDescription($param['description']); if (!$article->validate()) { var_dump($article->validate()); } $article->save(); $output = array('success' => 1, 'data' => $param); $this->jsonwrapper->print_json($output); }
/** * Start browsing the directory and register files * * @return Exception code = 400 if directory non-existent * An array containing list of non-imported files if successful */ public function doImport() { if (!file_exists($this->_dir)) { throw new Exception("directory non-existent", 400); } $errArr = array(); $handler = opendir($this->_dir); // TODO: does not do recrusive listing, do we need that? while (false !== ($file = readdir($handler))) { if ($file != '.' && $file != '..') { $err = false; $pos = strrpos($file, '.'); $fileName = strtoupper(substr($file, 0, $pos)); $token = strtok($fileName, '_'); $counter = 0; while (false !== $token) { switch ($counter) { case 0: if (strlen($token) != 7) { $err = true; } $rawCourseCode = $token; break; case 1: if ($token != substr($this->_year, 0, 4)) { $err = true; } break; case 2: if ($token != "EXAM") { if (substr($token, 0, 5) == "EXAM(") { // name could have the following syntax: AER205S_2009_EXAM(2).pdf $count = strtok($token, '('); $count = strtok('('); $count = strtok($count, ')'); if ($count === false || !is_numeric($count)) { $err = true; } } else { $err = true; } } break; } $token = strtok("_"); $counter++; } if ($counter != 3 || $err) { $err = true; } else { // assume course code is 7 chars in length with the last char being either S, F or Y $part1 = substr($rawCourseCode, 0, 6); //e.g. AER205 $part2 = substr($rawCourseCode, 6, 1); //e.g. F switch ($part2) { case "F": case "S": $courseCode = $part1 . "H1"; $descr = $part1 . " " . $this->_year . " Official Exam" . (isset($count) ? ' (' . $count . ')' : ''); break; case "Y": $courseCode = $part1 . "Y1"; $descr = $part1 . " " . $this->_year . " Official Exam" . (isset($count) ? ' (' . $count . ')' : ''); break; default: $err = true; break; } if (!$err) { $conn = Propel::getConnection(); // check if we have exam of this descr already $examArr = ExamPeer::getExamsForYearAndCourseId($courseCode, $this->_year, $conn); foreach ($examArr as $ex) { if ($ex->getType() == EnumItemPeer::EXAM && $ex->getDescr() == $descr) { $err = true; break; } } if (!$err) { // first check if course exists $course = CoursePeer::retrieveByPK($courseCode, $conn); if (!isset($course)) { $course = new Course(); //$course->setDeptId(substr($courseCode, 0, 3)); $course->setDescr($courseCode); $course->setIsEng(1); $course->setId($courseCode); $dept = DepartmentPeer::retrieveByPK(substr($courseCode, 0, 3), $conn); if (!isset($dept)) { $dept = new Department(); $dept->setId(substr($courseCode, 0, 3)); $dept->setDescr(substr($courseCode, 0, 3)); $dept->save($conn); } $course->setDepartment($dept); $course->save($conn); } // register exam $exam = new Exam(); $exam->setType(EnumItemPeer::EXAM); $exam->setDescr($descr); $exam->setCourseId($courseCode); $exam->setFilePath($this->_dir . $file); $exam->setYear($this->_year); $exam->save(); } } } if ($err) { $errArr[] = $file; } } } closedir($handler); return $errArr; }
/** * Remove the row * * @param array $aData or string $ProUid * @return string * */ public function remove($ProUid) { if (is_array($ProUid)) { $ProUid = isset($ProUid['DEP_UID']) ? $ProUid['DEP_UID'] : ''; } try { $oCriteria = new Criteria('workflow'); $oCriteria->addSelectColumn(UsersPeer::USR_UID); $oCriteria->add(UsersPeer::DEP_UID, $ProUid, Criteria::EQUAL); $oDataset = UsersPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $oDataset->next(); $aFields = array(); while ($aRow = $oDataset->getRow()) { $aFields['USR_UID'] = $aRow['USR_UID']; $aFields['DEP_UID'] = ''; $oDepto = UsersPeer::retrieveByPk($aFields['USR_UID']); if (is_object($oDepto) && get_class($oDepto) == 'UsersPeer') { return true; } else { $oDepto = new Users(); $oDepto->update($aFields); } $oDataset->next(); } $oPro = DepartmentPeer::retrieveByPK($ProUid); if (!is_null($oPro)) { $dptoTitle = $this->Load($oPro->getDepUid()); Content::removeContent('DEPO_TITLE', '', $oPro->getDepUid()); Content::removeContent('DEPO_DESCRIPTION', '', $oPro->getDepUid()); G::auditLog("DeleteDepartament", "Departament Name: " . $dptoTitle['DEPO_TITLE'] . " Departament ID: (" . $oPro->getDepUid() . ") "); return $oPro->delete(); } else { throw new Exception("The row '{$ProUid}' in table Group doesn't exist!"); } } catch (Exception $oError) { throw $oError; } }
public function executeSelectPeriodByDept() { $dept_id = $this->getRequestParameter('department_id'); $department = DepartmentPeer::retrieveByPK($dept_id); $c = new Criteria(); $c->add(AcademicCalendarPeer::DEPARTMENT_ID, $this->getRequestParameter('department_id')); $c->addJoin(NgRegPeriodPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $c->add(NgRegPeriodPeer::STATUS, NgRegPeriod::OPEN); $nrps = NgRegPeriodPeer::doSelect($c); $content = array(); foreach ($nrps as $r) { $content[$r->getId()] = $r->toString(); } $this->content = $content; $this->disabled = $disabled; }
public function executeGetApplSched() { $this->ng_reg_period = NgRegPeriodPeer::retrieveByPK($this->getRequestParameter('ng_reg_period_id')); $this->forward404Unless($this->ng_reg_period); $this->ng_reg_test_period = NgRegTestPeriodPeer::retrieveByPK($this->getRequestParameter('ng_reg_test_period_id')); $this->forward404Unless($this->ng_reg_test_period); $this->ng_test_schedule = NgTestSchedulePeer::retrieveByPK($this->getRequestParameter('ng_test_schedule_id')); $this->forward404Unless($this->ng_test_schedule); $ct = new Criteria(); $ct->add(NgTestSubjectPeer::COURSE_MODEL, DepartmentPeer::retrieveByPK($this->ng_reg_period->getAcademicCalendar()->getDepartmentId())->getCourseModel()); $this->test_subjects = NgTestSubjectPeer::doSelect($ct); $c = new Criteria(); $c->add(NgTestApplSchedPeer::NG_TEST_SCHEDULE_ID, $this->ng_test_schedule->getId()); $c->addJoin(NgTestApplicantPeer::ID, NgTestApplSchedPeer::NG_TEST_APPLICANT_ID); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'applicant')); $this->getUser()->setAttribute('max_per_page', $rpp, 'applicant'); $pager = new sfPropelPager('NgTestApplicant', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'applicant')); $this->getUser()->setAttribute('page', $page, 'applicant'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $this->type = 'edit'; $this->actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")), array('name' => 'cancel', 'url' => 'ng_reg_detail/listTest?id=' . $this->ng_reg_period->getId(), 'color' => 'black')); }
/** * setDepartment function * function to set the department * @param int $departmentId */ public function setDepartment($departmentId) { $this->department = DepartmentPeer::retrieveByPK($departmentId); }
public function saveToDatabase() { if (isset($this->_infoArr) && isset($this->_mappingArr)) { $err = ""; $conn = Propel::getConnection(); $dt = date("Y-m-d H:i:s"); $len = count($this->_infoArr); for ($i = 0; $i < $len; $i++) { $courseCode = substr($this->_infoArr[$i]["courseCode"], 0, 8); $deptId = substr($courseCode, 0, 3); $deptObj = DepartmentPeer::retrieveByPK($deptId, $conn); if (!isset($deptObj)) { // new department found, save to db $deptObj = new Department(); $deptObj->setId($deptId); $deptObj->setDescr($deptId); $deptObj->save($conn); } $course = CoursePeer::retrieveByPK($courseCode, $conn); if (!isset($course)) { // new course found, save to db $course = new Course(); $course->setDescr($this->_infoArr[$i]["courseName"]); $course->setIsEng(1); $course->setDeptId($deptId); $course->setId($courseCode); $course->save($conn); } elseif ($course->getDescr() == $course->getId()) { // exam importer registers course description as course id // if we encounter this situation, amend it with the proper description $course->setDescr($this->_infoArr[$i]["courseName"]); $course->save($conn); } try { $instr = InstructorPeer::findInstructorByName($this->_infoArr[$i]["instrFirstName"], $this->_infoArr[$i]["instrLastName"], $conn); } catch (Exception $e) { if ($e->getCode() == 1) { // no instructor found $instr = new Instructor(); $instr->setFirstName($this->_infoArr[$i]["instrFirstName"]); $instr->setLastName($this->_infoArr[$i]["instrLastName"]); $instr->setDeptId($course->getDeptId()); $instr->save($conn); } else { // TODO: big problem, duplicate instructors found // log error and move on continue; } } // create CourseInstructorAssociation if it doesn't exist try { $assoc = CourseInstructorAssociationPeer::findForYearAndInstructorIdAndCourseId($this->_year, $course->getId(), $instr->getId(), $conn); } catch (Exception $e) { if ($e->getCode() == 1) { // create new object $assoc = new CourseInstructorAssociation(); $assoc->setYear($this->_year); $assoc->setCourseId($course->getId()); $assoc->setInstructorId($instr->getId()); $assoc->save($conn); } else { // TODO: big problem, duplicate assocs found // log error and move on continue; } } // enrolled and responded if (isset($this->_infoArr[$i]["enrolled"])) { $ratingObj = new AutoCourseRating(); $ratingObj->setFieldId(RatingFieldPeer::NUMBER_ENROLLED); $ratingObj->setRating(0); $ratingObj->setImportDt($dt); $ratingObj->setNumber($this->_infoArr[$i]["enrolled"]); $ratingObj->setCourseInsId($assoc->getId()); $ratingObj->save($conn); } if (isset($this->_infoArr[$i]["response"])) { $ratingObj = new AutoCourseRating(); $ratingObj->setFieldId(RatingFieldPeer::NUMBER_RESPONDED); $ratingObj->setRating(0); $ratingObj->setImportDt($dt); $ratingObj->setNumber($this->_infoArr[$i]["response"]); $ratingObj->setCourseInsId($assoc->getId()); $ratingObj->save($conn); } // we can now save the real rating data $ratingArr = $this->_ratingArr[$i]; foreach ($ratingArr as $fieldId => $data) { foreach ($data as $rating => $number) { $ratingObj = new AutoCourseRating(); $ratingObj->setFieldId($fieldId); $ratingObj->setRating($rating); $ratingObj->setNumber($number); $ratingObj->setImportDt($dt); $ratingObj->setCourseInsId($assoc->getId()); $ratingObj->save($conn); } } } } else { throw new Exception("readCsv method has not been called."); } }
<?php $i = 0; foreach ($pager->getResults() as $test_applicant) { ++$i; ?> "<?php echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage(); ?> ","<?php echo $test_applicant->getCode(); ?> ","<?php echo $test_applicant->getName(); ?> ","<?php echo DepartmentPeer::retrieveByPK($test_applicant->getDepartment1())->toString(); ?> ","<?php echo ClassGroupPeer::retrieveByPK($test_applicant->getClassGroup1())->toString(); ?> ","<?php echo $test_applicant->getRegTestPeriod1() ? RegTestPeriodPeer::retrieveByPK($test_applicant->getRegTestPeriod1())->getRegPeriod()->getName() : '-'; ?> ","<?php if ($test_applicant->getApplicantType() == TestApplicant::STATUS_NEW) { echo __('Baru'); } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_TRANSFER) { echo __('Pindahan'); } elseif ($test_applicant->getApplicantType() == TestApplicant::STATUS_EXTEND) { echo __('Lanjutan'); }
public function executeShowMedical() { $employee_medical = EmployeeMedicalPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($employee_medical); $this->subtitle = $employee_medical->toString() . ' - id:' . $employee_medical->getId(); $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->forward404Unless($academic_calendar); $department_id = $this->getRequestParameter('department_id'); $department = DepartmentPeer::retrieveByPK($department_id); $this->forward404Unless($department); $actions = array(array('name' => 'Kembali', 'url' => 'employee_report/lisMedical?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'black')); $this->actions = $actions; $this->employee_medical = $employee_medical; $actions2 = array(array('name' => '<span>Rekap Kepegawaian</span>', 'url' => 'employee_report/list', 'color' => 'sky')); array_push($actions2, array('name' => '<span>Mutasi Jabatan</span>', 'url' => 'employee_report/listJob?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Absensi Pegawai</span>', 'url' => 'employee_report/listAbsence?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Absen Per Pegawai</span>', 'url' => 'employee_report/listAbsenceEmployee?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Cuti Pegawai</span>', 'url' => 'employee_report/listLeave?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Izin Pegawai</span>', 'url' => 'employee_report/listPermit?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Pengobatan</span>', 'url' => 'employee_report/listMedical?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sun', 'type' => 'direct')); array_push($actions2, array('name' => '<span>Gaji Pegawai</span>', 'url' => 'employee_report/listSalary?academic_calendar_id=' . $academic_calendar->getId() . '&department_id=' . $department->getId(), 'color' => 'sky')); $this->actions2 = $actions2; $cd = new Criteria(); $cd->add(EmployeeDetailPeer::EMPLOYEE_ID, $employee_permit->getEmployeeId()); $this->employee_detail = EmployeeDetailPeer::doSelectOne($cd); $this->academic_calendar = $academic_calendar; $this->department = $department; }
?> ISLAM AL-AZHAR 10 KEMBANGAN<br /> TAHUN PELAJARAN 2011 / 2012 <?php } elseif ($appl->getDepartment1() == 3) { ?> <?php echo DepartmentPeer::retrieveByPK($appl->getDepartment1())->toString(); ?> ISLAM AL-AZHAR 8 KEMBANGAN<br /> TAHUN PELAJARAN 2011 / 2012 <?php } else { ?> <?php echo DepartmentPeer::retrieveByPK($appl->getDepartment1())->toString(); ?> ISLAM AL-AZHAR 9 KEMBANGAN<br /> TAHUN PELAJARAN 2011 / 2012 <?php } ?> </td> </tr> <tr><td colspan="3"><hr noshade></td></tr> <tr> <td width="25%" style="text-align:left;">No. Test</td> <td width="3%" style="text-align:center">:</td> <td style="text-align:justify;"><?php echo $appl->getCode(); ?>
echo include_partial('global/listAsPDF', array('title' => '', 'subtitle' => '')); use_helper('Number', 'myHelper'); $dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo'); $depts = $dept->getId(); ?> <center> <table class="list_content" width="30%"> <thead> <tr> <th align="center" style="vertical-align: middle; font-size: 12px;" height="40px"> <?php echo __('Perpustakaan'); ?> <br><?php echo DepartmentPeer::retrieveByPK($depts)->getName(); ?> </th> </tr> </thead> <tbody> <tr class="list"> <td align="center" style="font-size: 12px;"> <?php $jumlah = substr_count($catalog->getCode(), "-"); $potong = explode("-", $catalog->getCode()); if ($jumlah == 1) { echo $potong[0] . '<br>' . $potong[1]; } elseif ($jumlah == 2) { echo $potong[0] . '<br>' . $potong[1] . '<br>' . $potong[2]; } elseif ($jumlah == 3) {
public function save($param) { $department_id = $param['department_id']; $departmentAvailable = $this->tools->departmentAvailable($department_id); $item = new WebItem(); if (empty($param['section'])) { $this->jsonwrapper->show_json_error('section', 'Kolom section harap diisi.'); } $itemSection = DepartmentPeer::retrieveByPK($param['section']); if (!$itemSection) { $this->jsonwrapper->show_json_error('type', 'Section yang anda masukkan tidak ditemukan.'); } if (!in_array($param['section'], $departmentAvailable)) { $this->jsonwrapper->show_json_error('forbidden', 'Maaf, anda tidak dapat membuat news dalam section ini.'); } if (empty($param['category_id'])) { $this->jsonwrapper->show_json_error('category', 'Kolom category harap diisi.'); } $itemCategory = WebItemCategoryPeer::retrieveByPK($param['category_id']); if (!$itemCategory) { $this->jsonwrapper->show_json_error('category', 'News Category yang anda masukkan tidak ditemukan.'); } if (empty($param['date'])) { $this->jsonwrapper->show_json_error('date', 'Kolom created harap diisi.'); } if (empty($param['hour'])) { $param['hour'] = 0; } if (empty($param['minute'])) { $param['minute'] = 0; } $newDate = $param['date'] . ' ' . $param['hour'] . ':' . $param['minute'] . ':00'; $newDate = date('Y-m-d H:i:s', strtotime($newDate)); if (empty($param['title'])) { $this->jsonwrapper->show_json_error('title', 'Kolom title harap diisi.'); } if (empty($param['initial'])) { $this->jsonwrapper->show_json_error('initial', 'Kolom initial harap diisi.'); } if (empty($param['image'])) { /* $this->jsonwrapper->show_json_error('image', 'Kolom image harap diisi.'); */ $param['image'] = ''; } if (empty($param['description'])) { $this->jsonwrapper->show_json_error('description', 'Kolom description harap diisi.'); } if (!empty($param['id'])) { $item = WebItemPeer::retrieveByPK($param['id']); if (!$item) { $this->jsonwrapper->show_json_error('id', 'News tidak ditemukan.'); } if (!in_array($item->getDepartmentId(), $departmentAvailable)) { $this->jsonwrapper->show_json_error('forbidden', 'Maaf, anda tidak dapat mengedit news ini.'); } } else { $item->setPublished(0); $item->setCreated(date('Y-m-d H:i:s')); } /* Add */ $item->setTitle($param['title']); $item->setInitial($param['initial']); $item->setImage($param['image']); $item->setDepartmentId($param['section']); $item->setItemCategoryId($param['category_id']); $item->setDescription($param['description']); $item->setCreated($newDate); if (!$item->validate()) { var_dump($item->validate()); } $item->save(); $output = array('success' => 1, 'data' => $param); $this->jsonwrapper->print_json($output); }
public function getDepartmentRelatedByDepartment2($con = null) { include_once 'lib/model/om/BaseDepartmentPeer.php'; if ($this->aDepartmentRelatedByDepartment2 === null && $this->department_2 !== null) { $this->aDepartmentRelatedByDepartment2 = DepartmentPeer::retrieveByPK($this->department_2, $con); } return $this->aDepartmentRelatedByDepartment2; }
public function executeEnquiryProcess() { /* Initialize */ $this->getEnquirer(); $valid = true; $error_message = array(); $now = date('Y-m-d H:i:s'); /* Filter User */ if (!$this->filterUser(true)) { $this->jsonwrapper->print_json(array('success' => false, 'code' => 'security', 'message' => 'You must login to access this url.')); } /* Get All Parameter */ $param = $this->getAllRequestParameter(); /* enquiry_name */ if (empty($param['enquirer_name'])) { $error_message[] = array('field' => 'enquirer_name', 'message' => 'Please enter your enquirer name'); $valid = false; } /* enquiry_type */ if (empty($param['enquiry_type'])) { $error_message[] = array('field' => 'enquiry_type', 'message' => 'Please enter enquiry type'); $valid = false; } else { /* Check enquiry type exist or not */ switch ($param['enquiry_type']) { case TestApplicant::ENQ_PHONE: case TestApplicant::ENQ_FAX: case TestApplicant::ENQ_EMAIL: case TestApplicant::ENQ_DIRECT: break; default: $error_message[] = array('field' => 'enquiry_type', 'message' => 'Enquiry type does not exist'); $valid = false; break; } } /* enquiry_getinformation */ if (empty($param['getinformation'])) { $error_message[] = array('field' => 'getinformation', 'message' => 'Please enter this field'); $valid = false; } else { switch ($param['getinformation']) { case TestApplicant::REG_INFO_FAM: case TestApplicant::REG_INFO_NEWSP: case TestApplicant::REG_INFO_SCH: case TestApplicant::REG_INFO_BAN: case TestApplicant::REG_INFO_MISC: break; default: $error_message[] = array('field' => 'getinformation', 'message' => 'Information type does not exist'); $valid = false; break; } } /* enquiry comment */ if (empty($param['comment'])) { $error_message[] = array('field' => 'comment', 'message' => 'Please enter a comment'); $valid = false; } /* --- Applicant --- */ /* applicant name */ if (empty($param['applicant_name'])) { $error_message[] = array('field' => 'applicant_name', 'message' => 'Please enter your Applicant Fullname'); $valid = false; } /* Relationship */ if (empty($param['relationship'])) { $error_message[] = array('field' => 'relationship', 'message' => 'Please enter your relation with applicant'); $valid = false; } /* Address */ if (empty($param['address'])) { $error_message[] = array('field' => 'address', 'message' => 'Please enter applicant address'); $valid = false; } /* POB */ if (empty($param['pob'])) { $error_message[] = array('field' => 'pob', 'message' => 'Please enter applicant place of birth'); $valid = false; } /* DOB */ if (empty($param['dob'])) { $error_message[] = array('field' => 'dob', 'message' => 'Please enter applicant date of birth'); $valid = false; } /* present school */ if (empty($param['present_school'])) { $error_message[] = array('field' => 'present_school', 'message' => 'Please enter Applicant Present School'); $valid = false; } /* present level */ if (empty($param['present_level'])) { $error_message[] = array('field' => 'present_level', 'message' => 'Please enter Applicant Present Level'); $valid = false; } /* school_interested */ if (empty($param['school_interested'])) { $error_message[] = array('field' => 'school_interested', 'message' => 'Please enter Applicant School Interested'); $valid = false; } else { /* Check School Interested Exist or Not */ $department = DepartmentPeer::retrieveByPK($param['school_interested']); if (!$department) { $error_message[] = array('field' => 'school_interested', 'message' => 'Shool Interested you entered is not valid'); $valid = false; } else { if ($department->getParent() == 0) { $error_message[] = array('field' => 'school_interested', 'message' => 'Shool Interested you entered is not valid'); $valid = false; } else { /* level_interested */ if (empty($param['level_interested'])) { $error_message[] = array('field' => 'level_interested', 'message' => 'Please enter Applicant Level Interested'); $valid = false; } else { /* Check class exist or not */ $classCriteria = new Criteria(); $classCriteria->add(VClassGroupPeer::DEPARTMENT_ID, $department->getId(), Criteria::EQUAL); $classCriteria->add(VCLassGroupPeer::ID, $param['level_interested'], Criteria::EQUAL); $classInterested = VCLassGroupPeer::doSelectOne($classCriteria); if (!$classInterested) { $error_message[] = array('field' => 'level_interested', 'message' => 'Level Interested you entered is not valid'); $valid = false; } } } } } /* Check all parameter valid or not */ if (!$valid) { $this->jsonwrapper->print_json(array('success' => false, 'code' => 'notvalid', 'error' => $error_message)); } /* Start Transaction */ $connection = Propel::getConnection('propel'); $connection->begin(); /* TABLE TEST_APPLICANT_ENQUIRER */ $this->user->setFullname($param['enquirer_name']); $this->user->setEnquiryType($param['enquiry_type']); $this->user->setComments($param['comment']); /* Try Save */ try { $this->user->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error save enquirer - process1')); } /* TABLE TEST_APPLICANT */ /* Get this applicant, if empty then create a new one */ $applicant = $this->pmbTools->getApplicant($this->user); if (!$applicant) { $applicant = new TestApplicant(); $newApplicant = true; } else { $newApplicant = false; } /* If New Applicant */ /* This field cannot be changed */ if ($newApplicant) { $applicantCode = $this->pmbTools->generateApplicantCode(StudentDetail::BUY); $applicant->setStatus(StudentDetail::BUY); $applicant->setCode($this->pmbTools->generateApplicantCode(StudentDetail::BUY)); $applicant->setEnrolled(0); $applicant->setApplicantType(TestApplicant::STATUS_NEW); } /* Field can be changed */ $applicant->setName($param['applicant_name']); $applicant->setTestApplicantEnquirerId($this->user->getId()); $applicant->setEnquirerRelation($param['relationship']); $applicant->setRegInfo($param['getinformation']); $applicant->setYear(date('Y', strtotime($now))); $applicant->setDepartment1($department->getId()); $applicant->setClassGroup1($classInterested->getId()); /* Try save applicant */ try { $applicant->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error save applicant - process2')); } /* TABLE APPLICANT_DETAIL */ if ($applicant->getTestApplicantDetail()) { $applicantDetail = $applicant->getTestApplicantDetail(); $newApplicantDetail = false; } else { $applicantDetail = new TestApplicantDetail(); $newApplicantDetail = true; } /* Fill Applicant Detail */ $applicantDetail->setAddress($param['address']); $applicantDetail->setPob($param['pob']); $applicantDetail->setDob(date('Y-m-d', strtotime($param['dob']))); $applicantDetail->setSchoolOfOrigin($param['present_school']); $applicantDetail->setClassOfOrigin($param['present_level']); /* Try save applicant_detail */ try { $applicantDetail->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error save applicant_detail - process3')); } if ($newApplicantDetail) { /* Create relation between applicant and applicant_detail */ $applicant->setTestApplicantDetailId($applicantDetail->getId()); try { $applicant->save(); } catch (Exception $e) { $connection->rollback(); $this->jsonwrapper->print_json(array('success' => false, 'code' => 'fail', 'message' => 'Error while save the data, please try again later.', 'message2' => 'Error create relation between applicant and applicant_detail - process3.1')); } } $connection->commit(); $this->jsonwrapper->print_json(array('success' => true, 'code' => 'success', 'message' => 'Data successfully saved', 'href' => $this->pmbTools->pmbUrl('account/index'))); }
$item = WebSlideshowPeer::doSelectOne($itemCriteria); if (!$item) { $this->jsonwrapper->show_json_error('not found', 'Image item tidak ditemukan.'); } $output = array('success' => 1, 'data' => $item->toArray()); $this->jsonwrapper->print_json($output); } public function categorysave($param) { $department_id = $param['department_id']; $departmentAvailable = $this->tools->departmentAvailable($department_id); $category = new WebImageCategory(); if (empty($param['section'])) { $this->jsonwrapper->show_json_error('section', 'Kolom section harap diisi.'); } $itemSection = DepartmentPeer::retrieveByPK($param['section']); if (!$itemSection) { $this->jsonwrapper->show_json_error('section', 'Section tidak ditemukan.'); } if (!in_array($param['section'], $departmentAvailable)) { $this->jsonwrapper->show_json_error('forbidden', 'Maaf, anda tidak dapat membuat image item di section ini.'); } if (empty($param['name'])) { $this->jsonwrapper->show_json_error('name', 'Kolom nama harap diisi.'); } if (empty($param['initial'])) { $this->jsonwrapper->show_json_error('initial', 'Kolom initial harap diisi.'); } if (!empty($param['id'])) { $category = WebImageCategoryPeer::retrieveByPK($param['id']); if (!$category) { $this->jsonwrapper->show_json_error('id', 'Category tidak ditemukan.'); } if (!in_array($category->getDepartmentId(), $departmentAvailable)) { $this->jsonwrapper->show_json_error('forbidden', 'Maaf, anda tidak dapat mengedit category ini.'); } } else { $category->setPublished(0); $category->setCreated(date('Y-m-d H:i:s')); } /* Add */ $category->setName($param['name']); $category->setInitial($param['initial']); $category->setDepartmentId($param['section']);
public function getDepartment($con = null) { include_once 'lib/model/om/BaseDepartmentPeer.php'; if ($this->aDepartment === null && $this->department_id !== null) { $this->aDepartment = DepartmentPeer::retrieveByPK($this->department_id, $con); } return $this->aDepartment; }
body { margin: 30px; margin-top: 10px; } body * { font-size: 12px; font-family: Times New Roman; } p.header, p.subheader, p.bigheader { margin: 0; margin-left: 5px; margin-right: 10px; padding: 0; font-family: corpidoffice;} p.header { font-size: 12px; font-weight: bold; color: black; } p.bigheader { font-size: 16px; font-weight: bold; color: black; } p.subheader { font-size: 10px; } table.list_content { border-collapse: collapse; width: auto; margin: auto; margin-top: 20px; } table.list_content td, table.list_content th { border: 1px solid black; padding: 2px 4px; vertical-align: top; } .list_content th { font-style: italic; background-color: #DAF383; text-align: left; } .even td { background-color: #F4F4F2; } .pager_top { width: 100%; text-align: left; } .pager_record, .pager_page { display: none; } td.list { text-align: center; } </style> <?php $dept = DepartmentPeer::retrieveByPK($department_id); $c = new Criteria(); $c->add(DepartmentDetailPeer::DEPARTMENT_ID, $dept->getId()); $department_detail = DepartmentDetailPeer::doSelectOne($c); ?> <table width="100%" style="left: -20px;"> <tr><td align="right"> <table style="padding:0; border-collapse:collapse;" width="100%"> <tr> <td align="left" width="100%"> <table border="0" width="100%"> <tr> <td align="right" width="15%" style="vertical-align: middle;"> <img src='<?php echo image_path('logo_' . $dept->getNumCode() . '.jpg', true);