/** * (non-PHPdoc) * @see EPDBObject::loadSummaryFields() */ public function loadSummaryFields($summaryFields = null) { if (is_null($summaryFields)) { $summaryFields = array('courses', 'students', 'active', 'instructors', 'oas', 'cas'); } else { $summaryFields = (array) $summaryFields; } $fields = array(); if (in_array('courses', $summaryFields)) { $fields['courses'] = EPCourse::count(array('org_id' => $this->getId())); } $dbr = wfGetDB(DB_SLAVE); if (in_array('students', $summaryFields)) { $courseIds = EPCourse::selectFields('id', array('org_id' => $this->getId())); if (count($courseIds) > 0) { $fields['students'] = $dbr->select('ep_students_per_course', 'COUNT(*) AS rowcount', array('spc_course_id' => $courseIds)); $fields['students'] = $fields['students']->fetchObject()->rowcount; } else { $fields['students'] = 0; } } if (in_array('active', $summaryFields)) { $now = wfGetDB(DB_SLAVE)->addQuotes(wfTimestampNow()); $fields['active'] = EPCourse::has(array('org_id' => $this->getId(), 'end >= ' . $now, 'start <= ' . $now)); } $courseFields = array(); $upInstructors = in_array('instructors', $summaryFields); $upOas = in_array('oas', $summaryFields); if ($upInstructors) { $courseFields[] = 'instructors'; $fields['instructors'] = 0; } if ($upOas) { $courseFields[] = 'online_ambs'; $fields['online_ambs'] = 0; } if (count($courseFields) > 0) { $courses = EPCourse::select($courseFields, array('org_id' => $this->getId())); foreach ($courses as $course) { // TODO: foreach set field: count and add to fields[name] } } $this->setFields($fields); }
/** * (non-PHPdoc) * @see EPEditAction::getFormFields() * @return array */ protected function getFormFields() { $fields = parent::getFormFields(); $orgOptions = EPOrg::getOrgOptions(); $fields['name'] = array('type' => 'text', 'label-message' => 'ep-course-edit-name', 'required' => true); $mcs = EPCourse::selectFields('mc', array(), array('DISTINCT')); if ($this->getRequest()->getCheck('newname')) { $newName = $this->getRequest()->getText('newname'); $mcs = array_merge(array($newName => $newName), $mcs); } else { $mcs = array_merge(array('' => ''), $mcs); } $fields['mc'] = array('class' => 'EPHTMLCombobox', 'label-message' => 'ep-course-edit-mc', 'required' => true, 'options' => array_combine($mcs, $mcs)); $fields['org_id'] = array('type' => 'select', 'label-message' => 'ep-course-edit-org', 'required' => true, 'options' => $orgOptions, 'validation-callback' => function ($value, array $alldata = null) use($orgOptions) { return in_array((int) $value, array_values($orgOptions)) ? true : wfMsg('ep-course-invalid-org'); }); $fields['token'] = array('type' => 'text', 'label-message' => 'ep-course-edit-token', 'maxlength' => 255, 'size' => 20, 'validation-callback' => function ($value, array $alldata = null) { $strLen = strlen($value); return $strLen !== 0 && $strLen < 2 ? wfMsgExt('ep-course-invalid-token', 'parsemag', 2) : true; }); $fields['term'] = array('type' => 'text', 'label-message' => 'ep-course-edit-term', 'required' => true); $fields['start'] = array('class' => 'EPHTMLDateField', 'label-message' => 'ep-course-edit-start', 'required' => true); $fields['end'] = array('class' => 'EPHTMLDateField', 'label-message' => 'ep-course-edit-end', 'required' => true); $fieldFields = EPCourse::selectFields('field', array(), array('DISTINCT')); $fieldFields = array_merge(array('' => ''), $fieldFields); $fields['field'] = array('class' => 'EPHTMLCombobox', 'label-message' => 'ep-course-edit-field', 'required' => true, 'options' => array_combine($fieldFields, $fieldFields)); $levels = EPCourse::selectFields('level', array(), array('DISTINCT')); $levels = array_merge(array('' => ''), $levels); $fields['level'] = array('class' => 'EPHTMLCombobox', 'label-message' => 'ep-course-edit-level', 'required' => true, 'options' => array_combine($levels, $levels)); $langOptions = EPUtils::getLanguageOptions($this->getLanguage()->getCode()); $fields['lang'] = array('type' => 'select', 'label-message' => 'ep-course-edit-lang', 'maxlength' => 255, 'required' => true, 'options' => $langOptions, 'validation-callback' => function ($value, array $alldata = null) use($langOptions) { return in_array($value, $langOptions) ? true : wfMsg('ep-course-invalid-lang'); }); $fields['description'] = array('type' => 'textarea', 'label-message' => 'ep-course-edit-description', 'required' => true, 'validation-callback' => function ($value, array $alldata = null) { return strlen($value) < 10 ? wfMsgExt('ep-course-invalid-description', 'parsemag', 10) : true; }, 'rows' => 10, 'id' => 'wpTextbox1'); return $this->processFormFields($fields); }
/** * (non-PHPdoc) * @see EPPager::getFilterOptions() */ protected function getFilterOptions() { $options = array(); $options['org_id'] = array('type' => 'select', 'options' => array_merge(array('' => ''), EPOrg::getOrgOptions(EPOrg::select(array('name', 'id')))), 'value' => '', 'datatype' => 'int'); $terms = EPCourse::selectFields('term', array(), array('DISTINCT'), array(), true); natcasesort($terms); $terms = array_merge(array(''), $terms); $terms = array_combine($terms, $terms); $options['term'] = array('type' => 'select', 'options' => $terms, 'value' => ''); // $options['lang'] = array( // 'type' => 'select', // 'options' => EPUtils::getLanguageOptions( $this->getLanguage()->getCode() ), // 'value' => '', // ); $options['status'] = array('type' => 'select', 'options' => array_merge(array('' => ''), EPCourse::getStatuses()), 'value' => 'current'); return $options; }