123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773 |
- <?php
- /* For licensing terms, see /license.txt */
- // @todo this could be integrated in the inc/lib/model.lib.php + try to clean this file
- // @todo this file was rewrote in the model ajax controller
- $libpath = api_get_path(LIBRARY_PATH);
- // 1. Setting variables needed by jqgrid
- $action = $_GET['a'];
- $page = intval($_REQUEST['page']); //page
- $limit = intval($_REQUEST['rows']); //quantity of rows
- $sidx = $_REQUEST['sidx']; //index (field) to filter
- $sord = $_REQUEST['sord']; //asc or desc
- if (strpos(strtolower($sidx), 'asc') !== false) {
- $sidx = str_replace(array('asc', ','), '', $sidx);
- $sord = 'asc';
- }
- if (strpos(strtolower($sidx), 'desc') !== false) {
- $sidx = str_replace(array('desc', ','), '', $sidx);
- $sord = 'desc';
- }
- if (!in_array($sord, array('asc','desc'))) {
- $sord = 'desc';
- }
- if (!in_array($action,
- array(
- 'get_exercise_results',
- 'get_hotpotatoes_exercise_results',
- 'get_work_user_list',
- 'get_work_user_list_others',
- 'get_work_user_list_all',
- 'get_timelines',
- 'get_user_skill_ranking',
- 'get_usergroups_teacher',
- 'get_question_list',
- 'get_user_list_plugin_widescale'
- )
- ))
- {
- api_protect_admin_script(true);
- }
- if ($action == 'get_user_list_plugin_widescale') {
- $allowed = api_is_drh() || api_is_platform_admin();
- if (!$allowed) {
- api_not_allowed();
- }
- }
- //Search features
- $ops = array(
- 'eq' => '=', //equal
- 'ne' => '<>', //not equal
- 'lt' => '<', //less than
- 'le' => '<=', //less than or equal
- 'gt' => '>', //greater than
- 'ge' => '>=', //greater than or equal
- 'bw' => 'LIKE', //begins with
- 'bn' => 'NOT LIKE', //doesn't begin with
- 'in' => 'LIKE', //is in
- 'ni' => 'NOT LIKE', //is not in
- 'ew' => 'LIKE', //ends with
- 'en' => 'NOT LIKE', //doesn't end with
- 'cn' => 'LIKE', //contains
- 'nc' => 'NOT LIKE' //doesn't contain
- );
- //@todo move this in the display_class or somewhere else
- /**
- * @param $col
- * @param $oper
- * @param $val
- * @return string
- */
- function get_where_clause($col, $oper, $val)
- {
- global $ops;
- if (empty($col)) {
- return '';
- }
- if ($oper == 'bw' || $oper == 'bn') {
- $val .= '%';
- }
- if ($oper == 'ew' || $oper == 'en') {
- $val = '%'.$val;
- }
- if ($oper == 'cn' || $oper == 'nc' || $oper == 'in' || $oper == 'ni') {
- $val = '%'.$val.'%';
- }
- $val = Database::escape_string($val);
- return " $col {$ops[$oper]} '$val' ";
- }
- $where_condition = ""; //if there is no search request sent by jqgrid, $where should be empty
- $operation = isset($_REQUEST['oper']) ? $_REQUEST['oper'] : false;
- $export_format = isset($_REQUEST['export_format']) ? $_REQUEST['export_format'] : 'csv';
- $search_field = isset($_REQUEST['searchField']) ? $_REQUEST['searchField'] : false;
- $search_oper = isset($_REQUEST['searchOper']) ? $_REQUEST['searchOper'] : false;
- $search_string = isset($_REQUEST['searchString']) ? $_REQUEST['searchString'] : false;
- $extra_fields = array();
- $questionFields = array();
- if ($_REQUEST['_search'] == 'true') {
- $where_condition = ' 1 = 1 ';
- $where_condition_in_form = get_where_clause($search_field, $search_oper, $search_string);
- if (!empty($where_condition_in_form)) {
- $where_condition .= ' AND '.$where_condition_in_form;
- }
- $filters = isset($_REQUEST['filters']) ? json_decode($_REQUEST['filters']) : false;
- // for now
- if (!empty($filters)) {
- switch($action) {
- case 'get_questions':
- $type = 'question';
- break;
- case 'get_sessions':
- $type = 'session';
- break;
- }
- // Extra field.
- $extraField = new ExtraField($type);
- $result = $extraField->getExtraFieldRules($filters, 'extra_');
- $extra_fields = $result['extra_fields'];
- $condition_array = $result['condition_array'];
- if (!empty($condition_array)) {
- $where_condition .= ' AND ( ';
- $where_condition .= implode($filters->groupOp, $condition_array);
- $where_condition .= ' ) ';
- }
- // Question field
- $resultQuestion = $extraField->getExtraFieldRules($filters, 'question_');
- $questionFields = $resultQuestion['extra_fields'];
- $condition_array = $resultQuestion['condition_array'];
- if (!empty($condition_array)) {
- $where_condition .= ' AND ( ';
- $where_condition .= implode($filters->groupOp, $condition_array);
- $where_condition .= ' ) ';
- }
- }
- }
- // get index row - i.e. user click to sort $sord = $_GET['sord'];
- // get the direction
- if (!$sidx) {
- $sidx = 1;
- }
- //2. Selecting the count FIRST
- //@todo rework this
- switch ($action) {
- case 'get_user_list_plugin_widescale':
- $count = UserManager::get_user_data(null, null, null, null, true);
- break;
- case 'get_question_list':
- require_once api_get_path(SYS_CODE_PATH).'exercice/exercise.class.php';
- $exerciseId = isset($_REQUEST['exerciseId']) ? $_REQUEST['exerciseId'] : null;
- $exercise = new Exercise(api_get_course_int_id());
- $exercise->read($exerciseId, false);
- $count = $exercise->getQuestionCount();
- break;
- case 'get_group_reporting':
- $course_id = isset($_REQUEST['course_id']) ? $_REQUEST['course_id'] : null;
- $group_id = isset($_REQUEST['gidReq']) ? $_REQUEST['gidReq'] : null;
- $count = Tracking::get_group_reporting($course_id, $group_id, 'count');
- break;
- case 'get_user_course_report_resumed':
- $count = CourseManager::get_count_user_list_from_course_code(true, 'ruc');
- break;
- case 'get_user_course_report':
- $count = CourseManager::get_count_user_list_from_course_code(false);
- break;
- case 'get_course_exercise_medias':
- $course_id = api_get_course_int_id();
- $count = Question::get_count_course_medias($course_id);
- break;
- case 'get_user_skill_ranking':
- $skill = new Skill();
- $count = $skill->get_user_list_skill_ranking_count();
- break;
- case 'get_work_user_list_all':
- require_once api_get_path(SYS_CODE_PATH).'work/work.lib.php';
- $work_id = $_REQUEST['work_id'];
- $count = get_count_work($work_id);
- break;
- case 'get_work_user_list_others':
- require_once api_get_path(SYS_CODE_PATH).'work/work.lib.php';
- $work_id = $_REQUEST['work_id'];
- $count = get_count_work($work_id, api_get_user_id());
- break;
- case 'get_work_user_list':
- require_once api_get_path(SYS_CODE_PATH).'work/work.lib.php';
- $work_id = $_REQUEST['work_id'];
- $courseInfo = api_get_course_info();
- // All
- if ($courseInfo['show_score'] == '0') {
- $count = get_count_work($work_id, null, api_get_user_id());
- } else {
- $count = get_count_work($work_id, api_get_user_id());
- }
- break;
- case 'get_exercise_results':
- $exercise_id = $_REQUEST['exerciseId'];
- if (isset($_GET['filter_by_user']) && !empty($_GET['filter_by_user'])) {
- $filter_user = intval($_GET['filter_by_user']);
- if ($where_condition == "") {
- $where_condition .= " te.exe_user_id = '$filter_user'" ;
- } else {
- $where_condition .= " AND te.exe_user_id = '$filter_user'";
- }
- }
- $count = ExerciseLib::get_count_exam_results($exercise_id, $where_condition);
- break;
- case 'get_admin_exercise_results':
- $count = ExerciseLib::get_admin_count_exam_results($where_condition);
- break;
- case 'get_hotpotatoes_exercise_results':
- $hotpot_path = $_REQUEST['path'];
- $count = ExerciseLib::get_count_exam_hotpotatoes_results($hotpot_path);
- break;
- case 'get_sessions':
- $list_type = isset($_REQUEST['list_type']) ? $_REQUEST['list_type'] : 'simple';
- if ($list_type == 'simple') {
- $count = SessionManager::get_sessions_admin(array('where'=> $where_condition, 'extra' => $extra_fields), true);
- } else {
- $count = SessionManager::get_count_admin_complete(array('where'=> $where_condition, 'extra' => $extra_fields));
- }
- break;
- case 'get_extra_fields':
- $type = $_REQUEST['type'];
- $obj = new ExtraField($type);
- $count = $obj->get_count();
- break;
- case 'get_extra_field_options':
- $type = $_REQUEST['type'];
- $field_id = $_REQUEST['field_id'];
- $obj = new ExtraFieldOption($type);
- $count = $obj->get_count_by_field_id($field_id);
- break;
- case 'get_timelines':
- require_once $libpath.'timeline.lib.php';
- $obj = new Timeline();
- $count = $obj->get_count();
- break;
- case 'get_gradebooks':
- require_once $libpath.'gradebook.lib.php';
- $obj = new Gradebook();
- $count = $obj->get_count();
- break;
- case 'get_event_email_template':
- $obj = new EventEmailTemplate();
- $count = $obj->get_count();
- break;
- case 'get_careers':
- $obj = new Career();
- $count = $obj->get_count();
- break;
- case 'get_promotions':
- $obj = new Promotion();
- $count = $obj->get_count();
- break;
- case 'get_grade_models':
- $obj = new GradeModel();
- $count = $obj->get_count();
- break;
- case 'get_usergroups':
- $obj = new UserGroup();
- $count = $obj->get_count();
- break;
- case 'get_usergroups_teacher':
- $obj = new UserGroup();
- $type = isset($_REQUEST['type']) ? $_REQUEST['type'] : 'registered';
- $course_id = api_get_course_int_id();
- if ($type == 'registered') {
- $count = $obj->get_usergroup_by_course_with_data_count($course_id);
- } else {
- $count = $obj->get_count();
- }
- break;
- default:
- exit;
- }
- //3. Calculating first, end, etc
- $total_pages = 0;
- if ($count > 0) {
- if (!empty($limit)) {
- $total_pages = ceil($count/$limit);
- }
- }
- if ($page > $total_pages) {
- $page = $total_pages;
- }
- $start = $limit * $page - $limit;
- if ($start < 0) {
- $start = 0;
- }
- //4. Deleting an element if the user wants to
- if (isset($_REQUEST['oper']) && $_REQUEST['oper'] == 'del') {
- $obj->delete($_REQUEST['id']);
- }
- $is_allowedToEdit = api_is_allowed_to_edit(null, true) || api_is_allowed_to_edit(true) || api_is_drh();
- //5. Querying the DB for the elements
- $columns = array();
- switch ($action) {
- case 'get_user_list_plugin_widescale':
- $columns = array('username', 'firstname', 'lastname', 'exam_password');
- $column_names = array(get_lang('Username'), get_lang('Firstname'), get_lang('Lastname'), get_lang('Password'));
- $result = UserManager::get_user_data($start, $limit, $sidx, $sord);
- break;
- case 'get_question_list':
- if (isset($exercise) && !empty($exercise)) {
- $extraField = new ExtraField('question');
- $extraFields = $extraField->get_all(array('field_filter = ?' => 1));
- $columns = array('question', 'type', 'category', 'level', 'score');
- if (!empty($extraFields)) {
- foreach ($extraFields as $extraField) {
- $columns[] = $extraField['field_variable'];
- }
- }
- $columns[] = 'actions';
- $result = $exercise->getQuestionListPagination($start, $limit, $sidx, $sord, $where_condition, $extraFields);
- }
- break;
- case 'get_group_reporting':
- $columns = array('name', 'time', 'progress', 'score', 'works', 'messages', 'actions');
- $result = Tracking::get_group_reporting($course_id, $group_id, 'all', $start, $limit, $sidx, $sord, $where_condition);
- break;
- case 'get_course_exercise_medias':
- $columns = array('question');
- $result = Question::get_course_medias($course_id, $start, $limit, $sidx, $sord, $where_condition);
- if (!empty($result)) {
- foreach ($result as &$media) {
- $media['id'] = $media['iid'];
- }
- }
- break;
- case 'get_user_course_report_resumed':
- $columns = array('extra_ruc', 'training_hours', 'count_users', 'count_users_registered', 'average_hours_per_user', 'count_certificates');
- $column_names = array(get_lang('Company'), get_lang('TrainingHoursAccumulated'), get_lang('CountOfSubscriptions'), get_lang('CountOfUsers'), get_lang('AverageHoursPerStudent'), get_lang('CountCertificates'));
- $result = CourseManager::get_user_list_from_course_code(null, null, "LIMIT $start, $limit", " $sidx $sord", null, null, true, true, 'ruc');
- $new_result = array();
- if (!empty($result)) {
- foreach ($result as $row) {
- $row['training_hours'] = api_time_to_hms($row['training_hours']);
- $row['average_hours_per_user'] = api_time_to_hms($row['average_hours_per_user']);
- $new_result[] = $row;
- }
- $result = $new_result;
- }
- break;
- case 'get_user_course_report':
- $columns = array('course', 'user', 'time', 'certificate', 'progress_100', 'progress');
- $column_names = array(get_lang('Course'), get_lang('User'), get_lang('ManHours'), get_lang('CertificateGenerated'), get_lang('Approved'), get_lang('CourseAdvance'));
- $extra_fields = UserManager::get_extra_fields(0, 100, null, null, true, true);
- if (!empty($extra_fields)) {
- foreach ($extra_fields as $extra) {
- $columns[] = $extra['1'];
- $column_names[] = $extra['3'];
- }
- }
- $result = CourseManager::get_user_list_from_course_code(null, null, "LIMIT $start, $limit", " $sidx $sord", null, null, true);
- break;
- case 'get_user_skill_ranking':
- $columns = array('photo', 'firstname', 'lastname', 'skills_acquired', 'currently_learning', 'rank');
- $result = $skill->get_user_list_skill_ranking($start, $limit, $sidx, $sord, $where_condition);
- $result = ArrayClass::msort($result, 'skills_acquired', 'asc');
- $skills_in_course = array();
- if (!empty($result)) {
- //$counter = 1;
- foreach ($result as &$item) {
- $user_info = api_get_user_info($item['user_id']);
- $personal_course_list = UserManager::get_personal_session_course_list($item['user_id']);
- $count_skill_by_course = array();
- foreach ($personal_course_list as $course_item) {
- if (!isset($skills_in_course[$course_item['code']])) {
- $count_skill_by_course[$course_item['code']] = $skill->get_count_skills_by_course($course_item['code']);
- $skills_in_course[$course_item['code']] = $count_skill_by_course[$course_item['code']];
- } else {
- $count_skill_by_course[$course_item['code']] = $skills_in_course[$course_item['code']];
- }
- }
- $item['photo'] = Display::img($user_info['avatar_small']);
- $item['currently_learning'] = !empty($count_skill_by_course) ? array_sum($count_skill_by_course) : 0;
- }
- }
- break;
- case 'get_work_user_list_all':
- if (isset($_GET['type']) && $_GET['type'] == 'simple') {
- //$columns = array('type', 'firstname', 'lastname', 'username', 'title', 'qualification', 'sent_date', 'qualificator_id', 'actions');
- $columns = array('type', 'firstname', 'lastname', 'title', 'qualification', 'sent_date', 'qualificator_id', 'actions');
- } else {
- //$columns = array('type', 'firstname', 'lastname', 'username', 'title', 'sent_date', 'actions');
- $columns = array('type', 'firstname', 'lastname', 'title', 'sent_date', 'actions');
- }
- $result = get_work_user_list($start, $limit, $sidx, $sord, $work_id, $where_condition);
- break;
- case 'get_work_user_list_others':
- if (isset($_GET['type']) && $_GET['type'] == 'simple') {
- //$columns = array('type', 'firstname', 'lastname', 'username', 'title', 'qualification', 'sent_date', 'qualificator_id', 'actions');
- $columns = array('type', 'firstname', 'lastname', 'title', 'qualification', 'sent_date', 'qualificator_id', 'actions');
- } else {
- //$columns = array('type', 'firstname', 'lastname', 'username', 'title', 'sent_date', 'actions');
- $columns = array('type', 'firstname', 'lastname', 'title', 'sent_date', 'actions');
- }
- $where_condition .= " AND u.user_id <> ".api_get_user_id();
- $result = get_work_user_list($start, $limit, $sidx, $sord, $work_id, $where_condition);
- break;
- case 'get_work_user_list':
- if (isset($_GET['type']) && $_GET['type'] == 'simple') {
- //$columns = array('type', 'firstname', 'lastname', 'username', 'title', 'qualification', 'sent_date', 'qualificator_id', 'actions');
- $columns = array('type', 'firstname', 'lastname', 'title', 'qualification', 'sent_date', 'qualificator_id', 'actions');
- } else {
- //$columns = array('type', 'firstname', 'lastname', 'username', 'title', 'sent_date', 'actions');
- $columns = array('type', 'firstname', 'lastname', 'title', 'sent_date', 'actions');
- }
- $where_condition .= " AND u.user_id = ".api_get_user_id();
- $result = get_work_user_list($start, $limit, $sidx, $sord, $work_id, $where_condition);
- break;
- case 'get_exercise_results':
- $course = api_get_course_info();
- //used inside get_exam_results_data()
- $documentPath = api_get_path(SYS_COURSE_PATH) . $course['path'] . "/document";
- if ($is_allowedToEdit) {
- $columns = array('firstname', 'lastname', 'username', 'group_name', 'exe_duration', 'start_date', 'exe_date', 'score', 'status', 'lp', 'actions');
- }
- $result = ExerciseLib::get_exam_results_data($start, $limit, $sidx, $sord, $exercise_id, $where_condition);
- break;
- case 'get_admin_exercise_results':
- $columns = array('username', 'firstname', 'lastname', 'score', 'link', 'session');
- $result = ExerciseLib::get_admin_exam_results_data($start, $limit, $sidx, $sord, $where_condition);
- break;
- case 'get_hotpotatoes_exercise_results':
- $course = api_get_course_info();
- //used inside get_exam_results_data()
- $documentPath = api_get_path(SYS_COURSE_PATH) . $course['path'] . "/document";
- $columns = array('firstname', 'lastname', 'username', 'group_name', 'exe_date', 'score', 'actions');
- $result = ExerciseLib::get_exam_results_hotpotatoes_data($start, $limit, $sidx, $sord, $hotpot_path, $where_condition); //get_exam_results_data($start, $limit, $sidx, $sord, $exercise_id, $where_condition);
- break;
- case 'get_sessions':
- $session_columns = SessionManager::get_session_columns($list_type);
- $columns = $session_columns['simple_column_name'];
- if ($list_type == 'simple') {
- $result = SessionManager::get_sessions_admin(array('where'=> $where_condition, 'order'=>"$sidx $sord", 'extra' => $extra_fields, 'limit'=> "$start , $limit"), false);
- } else {
- $result = SessionManager::get_sessions_admin_complete(array('where'=> $where_condition, 'order'=>"$sidx $sord", 'extra' => $extra_fields, 'limit'=> "$start , $limit"));
- }
- break;
- case 'get_timelines':
- $columns = array('headline', 'actions');
- if (!in_array($sidx, $columns)) {
- $sidx = 'headline';
- }
- $course_id = api_get_course_int_id();
- $result = Database::select('*', $obj->table, array('where' => array('parent_id = ? AND c_id = ?' => array('0', $course_id)), 'order'=>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- foreach ($result as $item) {
- if (!$item['status']) {
- $item['name'] = '<font style="color:#AAA">'.$item['name'].'</font>';
- }
- $item['headline'] = Display::url($item['headline'], api_get_path(WEB_CODE_PATH).'timeline/view.php?id='.$item['id']);
- $item['actions'] = Display::url(Display::return_icon('add.png', get_lang('AddItems')), api_get_path(WEB_CODE_PATH).'timeline/?action=add_item&parent_id='.$item['id']);
- $item['actions'] .= Display::url(Display::return_icon('edit.png', get_lang('Edit')), api_get_path(WEB_CODE_PATH).'timeline/?action=edit&id='.$item['id']);
- $item['actions'] .= Display::url(Display::return_icon('delete.png', get_lang('Delete')), api_get_path(WEB_CODE_PATH).'timeline/?action=delete&id='.$item['id']);
- $new_result[] = $item;
- }
- $result = $new_result;
- break;
- case 'get_gradebooks':
- $columns = array('name', 'certificates','skills', 'actions', 'has_certificates');
- if (!in_array($sidx, $columns)) {
- $sidx = 'name';
- }
- $result = Database::select('*', $obj->table, array('order'=>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- foreach ($result as $item) {
- if ($item['parent_id'] != 0) {
- continue;
- }
- $skills = $obj->get_skills_by_gradebook($item['id']);
- //Fixes bug when gradebook doesn't have names
- if (empty($item['name'])) {
- $item['name'] = $item['course_code'];
- } else {
- //$item['name'] = $item['name'].' ['.$item['course_code'].']';
- }
- $item['name'] = Display::url($item['name'], api_get_path(WEB_CODE_PATH).'gradebook/index.php?id_session=0&cidReq='.$item['course_code']);
- if (!empty($item['certif_min_score']) && !empty($item['document_id'])) {
- $item['certificates'] = Display::return_icon('accept.png', get_lang('WithCertificate'), array(), ICON_SIZE_SMALL);
- $item['has_certificates'] = '1';
- } else {
- $item['certificates'] = Display::return_icon('warning.png', get_lang('NoCertificate'), array(), ICON_SIZE_SMALL);
- $item['has_certificates'] = '0';
- }
- if (!empty($skills)) {
- foreach ($skills as $skill) {
- $item['skills'] .= Display::span($skill['name'], array('class' => 'label_tag skill'));
- }
- }
- $new_result[] = $item;
- }
- $result = $new_result;
- break;
- case 'get_event_email_template':
- $columns = array('subject', 'event_type_name', 'language_id', 'activated', 'actions');
- if(!in_array($sidx, $columns)) {
- $sidx = 'subject';
- }
- $result = Database::select('*', $obj->table, array('order'=>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- foreach ($result as $item) {
- $language_info = api_get_language_info($item['language_id']);
- $item['language_id'] = $language_info['english_name'];
- $item['actions'] = Display::url(Display::return_icon('edit.png', get_lang('Edit')), api_get_path(WEB_CODE_PATH).'admin/event_type.php?action=edit&event_type_name='.$item['event_type_name']);
- $item['actions'] .= Display::url(Display::return_icon('delete.png', get_lang('Delete')), api_get_path(WEB_CODE_PATH).'admin/event_controller.php?action=delete&id='.$item['id']);
- /*if (!$item['status']) {
- $item['name'] = '<font style="color:#AAA">'.$item['subject'].'</font>';
- }*/
- $new_result[] = $item;
- }
- $result = $new_result;
- break;
- case 'get_careers':
- $columns = array('name', 'description', 'actions');
- if (!in_array($sidx, $columns)) {
- $sidx = 'name';
- }
- $result = Database::select('*', $obj->table, array('order'=>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- foreach ($result as $item) {
- if (!$item['status']) {
- $item['name'] = '<font style="color:#AAA">'.$item['name'].'</font>';
- }
- $new_result[] = $item;
- }
- $result = $new_result;
- break;
- case 'get_promotions':
- $columns = array('name', 'career', 'description', 'actions');
- if (!in_array($sidx, $columns)) {
- $sidx = 'name';
- }
- $result = Database::select('p.id,p.name, p.description, c.name as career, p.status', "$obj->table p LEFT JOIN ".Database::get_main_table(TABLE_CAREER)." c ON c.id = p.career_id ", array('order' =>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- foreach($result as $item) {
- if (!$item['status']) {
- $item['name'] = '<font style="color:#AAA">'.$item['name'].'</font>';
- }
- $new_result[] = $item;
- }
- $result = $new_result;
- break;
- case 'get_grade_models':
- $columns = array('name', 'description', 'actions');
- if (!in_array($sidx, $columns)) {
- $sidx = 'name';
- }
- $result = Database::select('*', "$obj->table ", array('order' =>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- foreach($result as $item) {
- $new_result[] = $item;
- }
- $result = $new_result;
- break;
- case 'get_usergroups':
- $columns = array('name', 'users', 'courses', 'sessions', 'group_type', 'actions');
- $result = Database::select('*', $obj->table, array('order'=>"name $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- if (!empty($result)) {
- foreach ($result as $group) {
- $group['sessions'] = count($obj->get_sessions_by_usergroup($group['id']));
- $group['courses'] = count($obj->get_courses_by_usergroup($group['id']));
- $group['users'] = count($obj->get_users_by_usergroup($group['id']));
- switch ($group['group_type']) {
- case '0':
- $group['group_type'] = Display::label(get_lang('Class'), 'info');
- break;
- case '1':
- $group['group_type'] = Display::label(get_lang('Social'), 'success');
- break;
- }
- $new_result[] = $group;
- }
- $result = $new_result;
- }
- $columns = array('name', 'users', 'courses','sessions', 'group_type');
- if (!in_array($sidx, $columns)) {
- $sidx = 'name';
- }
- //Multidimensional sort
- ArrayClass::msort($result, $sidx);
- break;
- case 'get_extra_fields':
- $obj = new ExtraField($type);
- $columns = array('field_display_text', 'field_variable', 'field_type', 'field_changeable', 'field_visible', 'field_filter', 'field_order');
- $result = Database::select('*', $obj->table, array('order'=>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- $new_result = array();
- if (!empty($result)) {
- foreach ($result as $item) {
- $item['field_type'] = $obj->get_field_type_by_id($item['field_type']);
- $item['field_changeable'] = $item['field_changeable'] ? Display::return_icon('right.gif') : Display::return_icon('wrong.gif');
- $item['field_visible'] = $item['field_visible'] ? Display::return_icon('right.gif') : Display::return_icon('wrong.gif');
- $item['field_filter'] = $item['field_filter'] ? Display::return_icon('right.gif') : Display::return_icon('wrong.gif');
- $new_result[] = $item;
- }
- $result = $new_result;
- }
- break;
- case 'get_extra_field_options':
- $obj = new ExtraFieldOption($type);
- $columns = array('option_display_text', 'option_value', 'option_order');
- $result = Database::select('*', $obj->table, array('where' => array("field_id = ? " => $field_id),'order'=>"$sidx $sord", 'LIMIT'=> "$start , $limit"));
- break;
- case 'get_usergroups_teacher':
- $columns = array('name', 'users', 'actions');
- $options = array('order'=>"name $sord", 'LIMIT'=> "$start , $limit");
- $options['course_id'] = $course_id;
- switch ($type) {
- case 'not_registered':
- $options['where'] = array(" (course_id IS NULL OR course_id != ?) " => $course_id);
- $result = $obj->get_usergroup_not_in_course($options);
- break;
- case 'registered':
- $options['where'] = array(" usergroup.course_id = ? " => $course_id);
- $result = $obj->get_usergroup_in_course($options);
- break;
- }
- $new_result = array();
- if (!empty($result)) {
- foreach ($result as $group) {
- $group['users'] = count($obj->get_users_by_usergroup($group['id']));
- if ($obj->usergroup_was_added_in_course($group['id'], $course_id)) {
- $url = 'class.php?action=remove_class_from_course&id='.$group['id'];
- $icon = Display::return_icon('delete.png', get_lang('Remove'));
- } else {
- $url = 'class.php?action=add_class_to_course&id='.$group['id'];
- $icon = Display::return_icon('add.png', get_lang('Add'));
- }
- $group['actions'] = Display::url($icon, $url);
- $new_result[] = $group;
- }
- $result = $new_result;
- }
- if (!in_array($sidx, $columns)) {
- $sidx = 'name';
- }
- //Multidimensional sort
- ArrayClass::msort($result, $sidx);
- break;
- default:
- exit;
- }
- $allowed_actions = array(
- 'get_careers',
- 'get_promotions',
- 'get_usergroups',
- 'get_usergroups_teacher',
- 'get_gradebooks',
- 'get_sessions',
- 'get_exercise_results',
- 'get_admin_exercise_results',
- 'get_hotpotatoes_exercise_results',
- 'get_work_user_list',
- 'get_work_user_list_others',
- 'get_work_user_list_all',
- 'get_timelines',
- 'get_grade_models',
- 'get_event_email_template',
- 'get_user_skill_ranking',
- 'get_extra_fields',
- 'get_extra_field_options',
- 'get_course_exercise_medias',
- 'get_user_course_report',
- 'get_user_course_report_resumed',
- 'get_group_reporting',
- 'get_question_list',
- 'get_user_list_plugin_widescale'
- );
- //5. Creating an obj to return a json
- if (in_array($action, $allowed_actions)) {
- $response = new stdClass();
- $response->page = $page;
- $response->total = $total_pages;
- $response->records = $count;
- if ($operation && $operation == 'excel') {
- $j = 1;
- $array = array();
- if (empty($column_names)) {
- $column_names = $columns;
- }
- //Headers
- foreach ($column_names as $col) {
- $array[0][] = $col;
- }
- foreach ($result as $row) {
- foreach ($columns as $col) {
- $array[$j][] = strip_tags($row[$col]);
- }
- $j++;
- }
- switch ($export_format) {
- case 'xls':
- Export::export_table_xls($array, 'company_report');
- break;
- case 'csv':
- default:
- Export::export_table_csv($array, 'company_report');
- break;
- }
- exit;
- }
- $i = 0;
- if (!empty($result)) {
- foreach ($result as $row) {
- //print_r($row);
- // if results tab give not id, set id to $i otherwise id="null" for all <tr> of the jqgrid - ref #4235
- if (!isset($row['id']) || isset($row['id']) && $row['id'] == "") {
- $response->rows[$i]['id']=$i;
- } else {
- $response->rows[$i]['id']=$row['id'];
- }
- $array = array();
- foreach ($columns as $col) {
- $array[] = isset($row[$col]) ? $row[$col] : null;
- }
- $response->rows[$i]['cell']=$array;
- $i++;
- }
- }
- echo json_encode($response);
- }
- exit;
|