function get_LO_filter()
{
//addCss('style_filterbox');
$back_url = $this->back_url;
$jump_url = $this->jump_url;
$next_url = $this->next_url;
require_once _base_ . '/lib/lib.form.php';
require_once _lms_ . '/lib/lib.course.php';
$ref =& $_SESSION['report_tempdata']['columns_filter'];
YuiLib::load();
Util::get_js(Get::rel_path('lms') . '/admin/modules/report/courses_filter.js', true, true);
//back to columns category selection
if (isset($_POST['undo_filter'])) {
//go back at the previous step
Util::jump_to($back_url);
}
//set $_POST data in $_SESSION['report_tempdata']
$selector = new Selector_Course();
if (isset($_POST['update_tempdata'])) {
$selector->parseForState($_POST);
$temp = array('all_courses' => $_POST['all_courses'] == 1 ? true : false, 'selected_courses' => $selector->getSelection(), 'lo_types' => isset($_POST['lo_types']) ? $_POST['lo_types'] : array(), 'lo_milestones' => isset($_POST['lo_milestones']) ? $_POST['lo_milestones'] : array(), 'showed_columns' => isset($_POST['cols']) ? $_POST['cols'] : array(), 'custom_fields' => array(), 'order_by' => Get::req('order_by', DOTY_STRING, 'userid'), 'order_dir' => Get::req('order_dir', DOTY_STRING, 'asc'), 'show_suspended' => Get::req('show_suspended', DOTY_INT, 0) > 0);
foreach ($ref['custom_fields'] as $val) {
$temp['custom_fields'][] = array('id' => $val['id'], 'label' => $val['label'], 'selected' => isset($_POST['custom'][$val['id']]) ? true : false);
}
$_SESSION['report_tempdata']['columns_filter'] = $temp;
} else {
//first loading of this page -> prepare $_SESSION data structure
//if (isset($_SESSION['report_update']) /* && is equal to id_report */) break;
//get users' custom fields
require_once _adm_ . '/lib/lib.field.php';
$fman = new FieldList();
$fields = $fman->getFlatAllFields();
$custom = array();
foreach ($fields as $key => $val) {
$custom[] = array('id' => $key, 'label' => $val, 'selected' => false);
}
if (!isset($_SESSION['report_tempdata']['columns_filter'])) {
$_SESSION['report_tempdata']['columns_filter'] = array('all_courses' => false, 'selected_courses' => $selector->getSelection(), 'lo_types' => array(), 'lo_milestones' => array(), 'showed_columns' => array(), 'custom_fields' => $custom, 'order_by' => 'userid', 'order_dir' => 'asc', 'show_suspended' => 'show_suspended');
}
}
//filter setting done, go to next step
if (isset($_POST['import_filter']) || isset($_POST['show_filter']) || isset($_POST['pre_filter'])) {
$temp_url = $next_url;
if (isset($_POST['pre_filter'])) {
$temp_url .= '&show=1&nosave=1';
}
if (isset($_POST['show_filter'])) {
$temp_url .= '&show=1';
}
Util::jump_to($temp_url);
}
cout(Form::getHidden('update_tempdata', 'update_tempdata', 1), 'content');
$lang = $this->lang;
//box for direct course selection
$selection =& $ref['selected_courses'];
$selector->parseForState($_POST);
$selector->resetSelection($selection);
$temp = count($selection);
$box = new ReportBox('course_selector');
$box->title = Lang::t('_REPORT_COURSE_SELECTION', 'report');
$box->description = false;
$box->body .= '<div class="fc_filter_line filter_corr">';
$box->body .= '<input id="all_courses" name="all_courses" type="radio" value="1" ' . ($ref['all_courses'] ? 'checked="checked"' : '') . ' />';
$box->body .= ' <label for="all_courses">' . $lang->def('_ALL_COURSES') . '</label>';
$box->body .= ' <input id="sel_courses" name="all_courses" type="radio" value="0" ' . ($ref['all_courses'] ? '' : 'checked="checked"') . ' />';
$box->body .= ' <label for="sel_courses">' . $lang->def('_SEL_COURSES') . '</label>';
$box->body .= '</div>';
$box->body .= '<div id="selector_container"' . ($ref['all_courses'] ? ' style="display:none"' : '') . '>';
//$box->body .= Form::openElementSpace();
$box->body .= $selector->loadCourseSelector(true);
//$box->body .= Form::closeElementSpace();
$box->body .= '<br /></div>';
$box->footer = $lang->def('_CURRENT_SELECTION') . ': <span id="csel_foot">' . ($ref['all_courses'] ? Lang::t('_ALL', 'standard') : ($temp != '' ? $temp : '0')) . '</span>';
//.'</div>';
cout($box->get(), 'content');
cout('<script type="text/javascript">courses_count=' . ($temp == '' ? '0' : $temp) . ';' . 'courses_all="' . Lang::t('_ALL', 'standard') . '";' . "\n" . 'YAHOO.util.Event.addListener(window, "load", courses_selector_init);</script>', 'page_head');
$box = new ReportBox('lo_selection');
$box->title = $lang->def('_SELECT_LO_OPTIONS');
//LO columns selection
$lo_trans = $this->getLOTypesTranslations();
$box->body .= Form::getOpenFieldset(Lang::t('_RU_LO_TYPES', 'report'), 'lotypes_fieldset');
$res = sql_query("SELECT * FROM %lms_lo_types");
while ($row = mysql_fetch_assoc($res)) {
$trans = isset($lo_trans[$row['objectType']]) ? $lo_trans[$row['objectType']] : "";
$box->body .= Form::getCheckBox($trans, 'lo_type_' . $row['objectType'], 'lo_types[' . $row['objectType'] . ']', $row['objectType'], in_array($row['objectType'], $ref['lo_types']) ? true : false);
}
$box->body .= Form::getCloseFieldset();
$box->body .= Form::getOpenFieldset($lang->def('_RU_LO_MILESTONES'), 'lomilestones_fieldset');
$box->body .= Form::getCheckBox($lang->def('_NONE'), 'lo_milestone_0', 'lo_milestones[]', _MILESTONE_NONE, in_array(_MILESTONE_NONE, $ref['lo_milestones']) ? true : false);
$box->body .= Form::getCheckBox($lang->def('_START'), 'lo_milestone_1', 'lo_milestones[]', _MILESTONE_START, in_array(_MILESTONE_START, $ref['lo_milestones']) ? true : false);
$box->body .= Form::getCheckBox($lang->def('_END'), 'lo_milestone_2', 'lo_milestones[]', _MILESTONE_END, in_array(_MILESTONE_END, $ref['lo_milestones']) ? true : false);
$box->body .= Form::getCloseFieldset();
cout($box->get(), 'content');
function is_showed($which)
{
if (isset($_SESSION['report_tempdata']['columns_filter'])) {
return in_array($which, $_SESSION['report_tempdata']['columns_filter']['showed_columns']);
} else {
return false;
}
}
//box for columns selection
$arr_fieldset = array('user' => '', 'course' => '', 'lo' => '');
$box = new ReportBox('columns_selection');
$box->title = $lang->def('_SELECT_THE_DATA_COL_NEEDED');
$box->description = false;
//prepare fieldsets
foreach ($this->LO_columns as $val) {
if ($val['select']) {
$line = Form::getCheckBox($val['label'], 'col_sel_' . $val['key'], 'cols[]', $val['key'], is_showed($val['key']));
switch ($val['group']) {
case 'user':
$arr_fieldset['user'] .= $line;
break;
case 'course':
$arr_fieldset['course'] .= $line;
break;
case 'lo':
$arr_fieldset['lo'] .= $line;
break;
}
} else {
if ($val['key'] == '_CUSTOM_FIELDS_') {
//custom fields
if (count($ref['custom_fields']) > 0) {
foreach ($ref['custom_fields'] as $key => $val) {
$arr_fieldset['user'] .= Form::getCheckBox($val['label'], 'col_custom_' . $val['id'], 'custom[' . $val['id'] . ']', $val['id'], $val['selected']);
}
}
}
}
}
//print fieldsets
foreach ($arr_fieldset as $fid => $fieldset) {
$ftitle = '';
switch ($fid) {
case 'user':
$ftitle = Lang::t('_USER_CUSTOM_FIELDS', 'report');
break;
case 'course':
$ftitle = Lang::t('_COURSE_FIELDS', 'report');
break;
case 'lo':
$ftitle = Lang::t('_LEARNING_OBJECTS', 'standard');
break;
}
$box->body .= Form::getOpenFieldset($ftitle, 'fieldset_' . $fid . '_fields');
$box->body .= $fieldset;
$box->body .= Form::getCloseFieldset();
}
cout($box->get(), 'content');
//other options
$box = new ReportBox('other_options');
$box->title = Lang::t('_OTHER_OPTION', 'course');
$box->description = false;
$sort_list = array('userid' => Lang::t('_USERID', 'standard'), 'firstname' => Lang::t('_FIRSTNAME', 'standard'), 'lastname' => Lang::t('_LASTNAME', 'standard'), 'email' => Lang::t('_EMAIL', 'standard'), 'course_code' => Lang::t('_COURSE_CODE', 'standard'), 'course_name' => Lang::t('_COURSE_NAME', 'standard'), 'object_title' => Lang::t('_LEARNING_OBJECTS', 'standard'), 'object_type' => Lang::t('_RU_LO_TYPES', 'report'), 'first_attempt' => Lang::t('_LO_COL_FIRSTATT', 'report'), 'last_attempt' => Lang::t('_LO_COL_LASTATT', 'report'));
$dir_list = array('asc' => Lang::t('_ORD_ASC_TITLE', 'standard'), 'desc' => Lang::t('_ORD_DESC_TITLE', 'standard'));
$sort_selected = array_key_exists($ref['order_by'], $sort_list) ? $ref['order_by'] : 'userid';
$dir_selected = array_key_exists($ref['order_dir'], $dir_list) ? $ref['order_dir'] : 'asc';
$sort_dir_dropdown = Form::getInputDropdown('', 'order_dir', 'order_dir', $dir_list, $dir_selected, '');
$box->body .= Form::getDropdown(Lang::t('_ORDER_BY', 'standard'), 'order_by', 'order_by', $sort_list, $sort_selected, $sort_dir_dropdown);
$box->body .= Form::getCheckbox(Lang::t('_SHOW_SUSPENDED', 'organization_chart'), 'show_suspended', 'show_suspended', 1, (bool) $ref['show_suspended']);
cout($box->get(), 'content');
}
function get_course_val_filter()
{
$back_url = $this->back_url;
$jump_url = $this->jump_url;
$next_url = $this->next_url;
require_once _base_ . '/lib/lib.form.php';
require_once _adm_ . '/lib/lib.directory.php';
require_once _adm_ . '/class.module/class.directory.php';
require_once _lms_ . '/lib/lib.course.php';
$lang =& DoceboLanguage::createInstance('report', 'framework');
$glang =& DoceboLanguage::createInstance('admin_course_managment', 'lms');
if (!isset($_SESSION['report_tempdata']['columns_filter'])) {
$_SESSION['report_tempdata']['columns_filter'] = array();
}
$ref =& $_SESSION['report_tempdata']['columns_filter'];
if (Get::req('is_updating', DOTY_INT, 0) > 0) {
$ref['showed_cols'] = Get::req('cols', DOTY_MIXED, array());
}
function is_showed($which, &$arr)
{
if (isset($arr['showed_cols'])) {
return in_array($which, $arr['showed_cols']);
} else {
return false;
}
}
if (isset($_POST['import_filter']) || isset($_POST['show_filter']) || isset($_POST['pre_filter'])) {
$temp_url = $next_url;
if (isset($_POST['pre_filter'])) {
$temp_url .= '&show=1&nosave=1';
}
if (isset($_POST['show_filter'])) {
$temp_url .= '&show=1';
}
Util::jump_to($temp_url);
}
cout($this->page_title . Form::openForm('user_report_rows_courses', $jump_url) . Form::getHidden('update_tempdata', 'update_tempdata', 1) . Form::getHidden('is_updating', 'is_updating', 1) . Form::getOpenFieldset($lang->def('_COURSE_FIELDS'), 'fieldset_course_fields') . Form::getCheckBox($lang->def('_COURSE_CODE'), 'col_sel_coursecode', 'cols[]', '_CODE_COURSE', is_showed('_CODE_COURSE', $ref)) . Form::getCheckBox($glang->def('_COURSE_NAME'), 'col_sel_coursename', 'cols[]', '_NAME_COURSE', is_showed('_NAME_COURSE', $ref)) . Form::getCheckBox($glang->def('_CATEGORY'), 'col_sel_category', 'cols[]', '_COURSE_CATEGORY', is_showed('_COURSE_CATEGORY', $ref)) . Form::getCheckBox($glang->def('_STATUS'), 'col_sel_status', 'cols[]', '_COURSESTATUS', is_showed('_COURSESTATUS', $ref)) . Form::getCheckBox($glang->def('_CREATION_DATE', 'report'), 'col_sel_publication', 'cols[]', '_PUBLICATION_DATE', is_showed('_PUBLICATION_DATE', $ref)) . Form::getCloseFieldset() . Form::getOpenFieldset($lang->def('_COURSE', 'levels'), 'fieldset_course_fields') . Form::getCheckBox($lang->def('_MAX_SCORE'), 'col_hight_vote', 'cols[]', '_HIGH_VOTE', is_showed('_HIGH_VOTE', $ref)) . Form::getCheckBox($lang->def('_MIN_SCORE'), 'col_less_vote', 'cols[]', '_LESS_VOTE', is_showed('_LESS_VOTE', $ref)) . Form::getCheckBox($lang->def('_SCORE'), 'show_medium_vote', 'cols[]', '_MEDIUM_VOTE', is_showed('_MEDIUM_VOTE', $ref)) . Form::getCloseFieldset() . Form::openButtonSpace() . Form::getBreakRow() . Form::getButton('pre_filter', 'pre_filter', $lang->def('_SHOW_NOSAVE', 'report')) . Form::getButton('ok_filter', 'import_filter', $lang->def('_SAVE_BACK')) . Form::getButton('show_filter', 'show_filter', $lang->def('_SAVE_SHOW')) . Form::getButton('undo_filter', 'undo_filter', $lang->def('_UNDO')) . Form::closeButtonSpace() . Form::closeForm() . '</div>');
}
