skill.ajax.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Responses to AJAX calls
  5. */
  6. require_once '../global.inc.php';
  7. require_once api_get_path(LIBRARY_PATH).'skill.lib.php';
  8. require_once api_get_path(LIBRARY_PATH).'gradebook.lib.php';
  9. $action = isset($_REQUEST['a']) ? $_REQUEST['a'] : null;
  10. $skill = new Skill();
  11. $gradebook = new Gradebook();
  12. $skill_gradebook = new SkillRelGradebook();
  13. switch ($action) {
  14. case 'add':
  15. if (isset($_REQUEST['id']) && !empty($_REQUEST['id'])) {
  16. $skill_id = $skill->edit($_REQUEST);
  17. } else {
  18. $skill_id = $skill->add($_REQUEST);
  19. }
  20. echo $skill_id;
  21. case 'delete_skill':
  22. echo $skill->delete($_REQUEST['skill_id']);
  23. break;
  24. case 'find_skills':
  25. $skills = $skill->find('all', array('where' => array('name LIKE %?% '=>$_REQUEST['tag'])));
  26. $return_skills = array();
  27. foreach ($skills as $skill) {
  28. $skill['caption'] = $skill['name'];
  29. $skill['value'] = $skill['id'];
  30. $return_skills[] = $skill;
  31. }
  32. echo json_encode($return_skills);
  33. break;
  34. case 'get_gradebooks':
  35. $gradebooks = $gradebook_list = $gradebook->get_all();
  36. $gradebook_list = array();
  37. //Only course gradebook with certificate
  38. if (!empty($gradebooks)) {
  39. foreach ($gradebooks as $gradebook) {
  40. if ($gradebook['parent_id'] == 0 && !empty($gradebook['certif_min_score']) && !empty($gradebook['document_id'])) {
  41. $gradebook_list[] = $gradebook;
  42. //$gradebook['name'] = $gradebook['name'];
  43. //$gradebook_list[] = $gradebook;
  44. } else {
  45. // $gradebook['name'] = $gradebook_list[$gradebook['parent_id']]['name'].' > '.$gradebook['name'];
  46. //$gradebook_list[] = $gradebook;
  47. }
  48. }
  49. }
  50. echo json_encode($gradebook_list);
  51. break;
  52. case 'find_gradebooks':
  53. $gradebooks = $gradebook->find('all', array('where' => array('name LIKE %?% ' => $_REQUEST['tag'])));
  54. $return = array();
  55. foreach ($gradebooks as $item) {
  56. $item['caption'] = $item['name'];
  57. $item['value'] = $item['id'];
  58. $return[] = $item;
  59. }
  60. echo json_encode($return);
  61. break;
  62. case 'get_course_info_popup':
  63. $course_info = api_get_course_info($_REQUEST['code']);
  64. $courses = CourseManager::process_hot_course_item(array($course_info));
  65. Display::display_no_header();
  66. Display::$global_template->assign('span_size', 9);
  67. Display::$global_template->assign('show_ranking', false);
  68. Display::$global_template->assign('hot_courses', $courses);
  69. echo Display::$global_template->fetch('default/layout/hot_course_item_popup.tpl');
  70. break;
  71. case 'gradebook_exists':
  72. $data = $gradebook->get($_REQUEST['gradebook_id']);
  73. if (!empty($data)) {
  74. echo 1;
  75. } else {
  76. echo 0;
  77. }
  78. break;
  79. case 'get_skills_by_profile':
  80. $skill_rel_profile = new SkillRelProfile();
  81. $profile_id = isset($_REQUEST['profile_id']) ? $_REQUEST['profile_id'] : null;
  82. $skills = $skill_rel_profile->get_skills_by_profile($profile_id);
  83. echo json_encode($skills);
  84. break;
  85. case 'get_saved_profiles':
  86. $skill_profile = new SkillProfile();
  87. $profiles = $skill_profile->get_all();
  88. Display::display_no_header();
  89. Display::$global_template->assign('profiles', $profiles);
  90. echo Display::$global_template->fetch('default/skill/profile_item.tpl');
  91. break;
  92. case 'get_skills':
  93. $load_user_data = isset($_REQUEST['load_user_data']) ? $_REQUEST['load_user_data'] : null;
  94. //$parent_id = intval($_REQUEST['parent_id']);
  95. $id = intval($_REQUEST['id']);
  96. $skills = $skill->get_all($load_user_data, false, $id);
  97. echo json_encode($skills);
  98. break;
  99. case 'get_skill_info':
  100. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  101. $skill_info = $skill->get_skill_info($id);
  102. echo json_encode($skill_info);
  103. break;
  104. case 'get_skill_course_info':
  105. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  106. $skill_info = $skill->get_skill_info($id);
  107. $courses = $skill->get_courses_by_skill($id);
  108. $html = '';
  109. if (!empty($courses)) {
  110. $html = sprintf(get_lang('ToGetToLearnXYouWillNeedToTakeOneOfTheFollowingCourses'), '<i>'.$skill_info['name'].'</i>').'<br />';
  111. foreach ($courses as $course) {
  112. $url = '#';
  113. $attributes = array('class' => 'course_description_popup', 'rel' => $course['code']);
  114. $html .= Display::url(sprintf(get_lang('SkillXWithCourseX'), $skill_info['name'], $course['title']), $url, $attributes).'<br />';
  115. }
  116. }
  117. echo $html;
  118. break;
  119. case 'get_skills_tree_json':
  120. $user_id = isset($_REQUEST['load_user']) && $_REQUEST['load_user'] == 1 ? api_get_user_id() : 0;
  121. $skill_id = isset($_REQUEST['skill_id']) ? $_REQUEST['skill_id'] : 0;
  122. $depth = isset($_REQUEST['main_depth']) ? $_REQUEST['main_depth'] : 2;
  123. $all = $skill->get_skills_tree_json($user_id, $skill_id, false, $depth);
  124. echo $all;
  125. break;
  126. case 'get_gradebook_info':
  127. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  128. $info = $gradebook->get($id);
  129. echo json_encode($info);
  130. break;
  131. case 'load_children':
  132. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  133. $load_user_data = isset($_REQUEST['load_user_data']) ? $_REQUEST['load_user_data'] : null;
  134. $skills = $skill->get_children($id, $load_user_data);
  135. $return = array();
  136. foreach ($skills as $skill) {
  137. if (isset($skill['data']) && !empty($skill['data'])) {
  138. $return[$skill['data']['id']] = array(
  139. 'id' => $skill['data']['id'],
  140. 'name' => $skill['data']['name'],
  141. 'passed'=> $skill['data']['passed']);
  142. }
  143. }
  144. $success = true;
  145. if (empty($return)) {
  146. $success = false;
  147. }
  148. $result = array (
  149. 'success' => $success,
  150. 'data' => $return
  151. );
  152. echo json_encode($result);
  153. break;
  154. case 'load_direct_parents':
  155. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  156. $skills = $skill->get_direct_parents($id);
  157. $return = array();
  158. foreach($skills as $skill) {
  159. $return [$skill['data']['id']] = array (
  160. 'id' => $skill['data']['id'],
  161. 'parent_id' => $skill['data']['parent_id'],
  162. 'name' => $skill['data']['name']
  163. );
  164. }
  165. echo json_encode($return);
  166. break;
  167. case 'profile_matches':
  168. $skill_rel_user = new SkillRelUser();
  169. $skills = $_REQUEST['skill_id'];
  170. $total_skills_to_search = $skills;
  171. $users = $skill_rel_user->get_user_by_skills($skills);
  172. $user_list = array();
  173. $count_skills = count($skills);
  174. if (!empty($users)) {
  175. foreach ($users as $user) {
  176. $user_info = api_get_user_info($user['user_id']);
  177. $user_list[$user['user_id']]['user'] = $user_info;
  178. $my_user_skills = $skill_rel_user->get_user_skills($user['user_id']);
  179. $user_skill_list = array();
  180. foreach ($my_user_skills as $skill_item) {
  181. $user_skill_list[] = $skill_item['skill_id'];
  182. }
  183. $user_skills = array();
  184. $found_counts = 0;
  185. foreach ($skills as $skill_id) {
  186. $found = false;
  187. if (in_array($skill_id, $user_skill_list)) {
  188. $found = true;
  189. $found_counts++;
  190. $user_skills[$skill_id] = array('skill_id' => $skill_id, 'found' => $found);
  191. }
  192. }
  193. foreach ($my_user_skills as $my_skill) {
  194. if (!isset($user_skills[$my_skill['skill_id']])) {
  195. $user_skills[$my_skill['skill_id']] = array('skill_id' => $my_skill['skill_id'], 'found' => false);
  196. }
  197. $total_skills_to_search[$my_skill['skill_id']] = $my_skill['skill_id'];
  198. }
  199. $user_list[$user['user_id']]['skills'] = $user_skills;
  200. $user_list[$user['user_id']]['total_found_skills'] = $found_counts;
  201. }
  202. $ordered_user_list = array();
  203. foreach ($user_list as $user_id => $user_data) {
  204. $ordered_user_list[$user_data['total_found_skills']][] = $user_data;
  205. }
  206. if (!empty($ordered_user_list)) {
  207. arsort($ordered_user_list);
  208. }
  209. }
  210. Display::display_no_header();
  211. Display::$global_template->assign('order_user_list', $ordered_user_list);
  212. Display::$global_template->assign('total_search_skills', $count_skills);
  213. $skill_list = array();
  214. if (!empty($total_skills_to_search)) {
  215. $total_skills_to_search = $skill->get_skills_info($total_skills_to_search);
  216. foreach ($total_skills_to_search as $skill_info) {
  217. $skill_list[$skill_info['id']] = $skill_info;
  218. }
  219. }
  220. Display::$global_template->assign('skill_list', $skill_list);
  221. echo Display::$global_template->fetch('default/skill/profile.tpl');
  222. break;
  223. case 'delete_gradebook_from_skill':
  224. case 'remove_skill':
  225. if (!empty($_REQUEST['skill_id']) && !empty($_REQUEST['gradebook_id'])) {
  226. $skill_item = $skill_gradebook->get_skill_info($_REQUEST['skill_id'], $_REQUEST['gradebook_id']);
  227. if (!empty($skill_item)) {
  228. $skill_gradebook->delete($skill_item['id']);
  229. echo 1;
  230. } else {
  231. echo 0;
  232. }
  233. } else {
  234. echo 0;
  235. }
  236. break;
  237. case 'save_profile':
  238. $skill_profile = new SkillProfile();
  239. $params = $_REQUEST;
  240. //$params['skills'] = isset($_SESSION['skills']) ? $_SESSION['skills'] : null;
  241. $params['skills'] = $params['skill_id'];
  242. $skill_data = $skill_profile->save($params);
  243. if (!empty($skill_data)) {
  244. echo 1;
  245. } else {
  246. echo 0;
  247. }
  248. break;
  249. case 'skill_exists':
  250. $skill_data = $skill->get($_REQUEST['skill_id']);
  251. if (!empty($skill_data)) {
  252. echo 1;
  253. } else {
  254. echo 0;
  255. }
  256. break;
  257. default:
  258. echo '';
  259. }
  260. exit;