skill.ajax.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269
  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 'gradebook_exists':
  63. $data = $gradebook->get($_REQUEST['gradebook_id']);
  64. if (!empty($data)) {
  65. echo 1;
  66. } else {
  67. echo 0;
  68. }
  69. break;
  70. case 'get_skills_by_profile':
  71. $skill_rel_profile = new SkillRelProfile();
  72. $profile_id = isset($_REQUEST['profile_id']) ? $_REQUEST['profile_id'] : null;
  73. $skills = $skill_rel_profile->get_skills_by_profile($profile_id);
  74. echo json_encode($skills);
  75. break;
  76. case 'get_saved_profiles':
  77. $skill_profile = new SkillProfile();
  78. $profiles = $skill_profile->get_all();
  79. Display::display_no_header();
  80. Display::$global_template->assign('profiles', $profiles);
  81. echo Display::$global_template->fetch('default/skill/profile_item.tpl');
  82. break;
  83. case 'get_skills':
  84. $load_user_data = isset($_REQUEST['load_user_data']) ? $_REQUEST['load_user_data'] : null;
  85. //$parent_id = intval($_REQUEST['parent_id']);
  86. $id = intval($_REQUEST['id']);
  87. $skills = $skill->get_all($load_user_data, false, $id);
  88. echo json_encode($skills);
  89. break;
  90. case 'get_skill_info':
  91. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  92. $skill_info = $skill->get_skill_info($id);
  93. echo json_encode($skill_info);
  94. break;
  95. case 'get_skills_tree_json':
  96. $user_id = isset($_REQUEST['load_user']) && $_REQUEST['load_user'] == 1 ? api_get_user_id() : 0;
  97. $skill_id = isset($_REQUEST['skill_id']) ? $_REQUEST['skill_id'] : 0;
  98. $depth = isset($_REQUEST['main_depth']) ? $_REQUEST['main_depth'] : 2;
  99. $all = $skill->get_skills_tree_json($user_id, $skill_id, false, $depth);
  100. echo $all;
  101. break;
  102. case 'get_gradebook_info':
  103. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  104. $info = $gradebook->get($id);
  105. echo json_encode($info);
  106. break;
  107. case 'load_children':
  108. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  109. $load_user_data = isset($_REQUEST['load_user_data']) ? $_REQUEST['load_user_data'] : null;
  110. $skills = $skill->get_children($id, $load_user_data);
  111. $return = array();
  112. foreach ($skills as $skill) {
  113. if (isset($skill['data']) && !empty($skill['data'])) {
  114. $return[$skill['data']['id']] = array(
  115. 'id' => $skill['data']['id'],
  116. 'name' => $skill['data']['name'],
  117. 'passed'=> $skill['data']['passed']);
  118. }
  119. }
  120. $success = true;
  121. if (empty($return)) {
  122. $success = false;
  123. }
  124. $result = array (
  125. 'success' => $success,
  126. 'data' => $return
  127. );
  128. echo json_encode($result);
  129. break;
  130. case 'load_direct_parents':
  131. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  132. $skills = $skill->get_direct_parents($id);
  133. $return = array();
  134. foreach($skills as $skill) {
  135. $return [$skill['data']['id']] = array (
  136. 'id' => $skill['data']['id'],
  137. 'parent_id' => $skill['data']['parent_id'],
  138. 'name' => $skill['data']['name']
  139. );
  140. }
  141. echo json_encode($return);
  142. break;
  143. case 'profile_matches':
  144. $skill_rel_user = new SkillRelUser();
  145. $skills = $_REQUEST['skill_id'];
  146. $total_skills_to_search = $skills;
  147. $users = $skill_rel_user->get_user_by_skills($skills);
  148. $user_list = array();
  149. $count_skills = count($skills);
  150. if (!empty($users)) {
  151. foreach ($users as $user) {
  152. $user_info = api_get_user_info($user['user_id']);
  153. $user_list[$user['user_id']]['user'] = $user_info;
  154. $my_user_skills = $skill_rel_user->get_user_skills($user['user_id']);
  155. $user_skill_list = array();
  156. foreach ($my_user_skills as $skill_item) {
  157. $user_skill_list[] = $skill_item['skill_id'];
  158. }
  159. $user_skills = array();
  160. $found_counts = 0;
  161. foreach ($skills as $skill_id) {
  162. $found = false;
  163. if (in_array($skill_id, $user_skill_list)) {
  164. $found = true;
  165. $found_counts++;
  166. $user_skills[$skill_id] = array('skill_id' => $skill_id, 'found' => $found);
  167. }
  168. }
  169. foreach ($my_user_skills as $my_skill) {
  170. if (!isset($user_skills[$my_skill['skill_id']])) {
  171. $user_skills[$my_skill['skill_id']] = array('skill_id' => $my_skill['skill_id'], 'found' => false);
  172. }
  173. $total_skills_to_search[$my_skill['skill_id']] = $my_skill['skill_id'];
  174. }
  175. $user_list[$user['user_id']]['skills'] = $user_skills;
  176. $user_list[$user['user_id']]['total_found_skills'] = $found_counts;
  177. }
  178. $ordered_user_list = array();
  179. foreach ($user_list as $user_id => $user_data) {
  180. $ordered_user_list[$user_data['total_found_skills']][] = $user_data;
  181. }
  182. if (!empty($ordered_user_list)) {
  183. arsort($ordered_user_list);
  184. }
  185. }
  186. Display::display_no_header();
  187. Display::$global_template->assign('order_user_list', $ordered_user_list);
  188. Display::$global_template->assign('total_search_skills', $count_skills);
  189. $skill_list = array();
  190. if (!empty($total_skills_to_search)) {
  191. $total_skills_to_search = $skill->get_skills_info($total_skills_to_search);
  192. foreach ($total_skills_to_search as $skill_info) {
  193. $skill_list[$skill_info['id']] = $skill_info;
  194. }
  195. }
  196. Display::$global_template->assign('skill_list', $skill_list);
  197. echo Display::$global_template->fetch('default/skill/profile.tpl');
  198. break;
  199. case 'delete_gradebook_from_skill':
  200. case 'remove_skill':
  201. if (!empty($_REQUEST['skill_id']) && !empty($_REQUEST['gradebook_id'])) {
  202. $skill_item = $skill_gradebook->get_skill_info($_REQUEST['skill_id'], $_REQUEST['gradebook_id']);
  203. if (!empty($skill_item)) {
  204. $skill_gradebook->delete($skill_item['id']);
  205. echo 1;
  206. } else {
  207. echo 0;
  208. }
  209. } else {
  210. echo 0;
  211. }
  212. break;
  213. case 'save_profile':
  214. $skill_profile = new SkillProfile();
  215. $params = $_REQUEST;
  216. //$params['skills'] = isset($_SESSION['skills']) ? $_SESSION['skills'] : null;
  217. $params['skills'] = $params['skill_id'];
  218. $skill_data = $skill_profile->save($params);
  219. if (!empty($skill_data)) {
  220. echo 1;
  221. } else {
  222. echo 0;
  223. }
  224. break;
  225. case 'skill_exists':
  226. $skill_data = $skill->get($_REQUEST['skill_id']);
  227. if (!empty($skill_data)) {
  228. echo 1;
  229. } else {
  230. echo 0;
  231. }
  232. break;
  233. default:
  234. echo '';
  235. }
  236. exit;