skill.ajax.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Responses to AJAX calls
  5. */
  6. require_once __DIR__.'/../global.inc.php';
  7. $action = isset($_REQUEST['a']) ? $_REQUEST['a'] : null;
  8. api_block_anonymous_users();
  9. Skill::isAllowed(api_get_user_id());
  10. $skill = new Skill();
  11. $gradebook = new Gradebook();
  12. $skillGradeBook = new SkillRelGradebook();
  13. $userId = api_get_user_id();
  14. switch ($action) {
  15. case 'add':
  16. if (api_is_platform_admin() || api_is_drh()) {
  17. if (isset($_REQUEST['id']) && !empty($_REQUEST['id'])) {
  18. $skill_id = $skill->edit($_REQUEST);
  19. } else {
  20. $skill_id = $skill->add($_REQUEST);
  21. }
  22. }
  23. echo $skill_id;
  24. break;
  25. case 'delete_skill':
  26. if (api_is_platform_admin() || api_is_drh()) {
  27. echo $skill->delete($_REQUEST['skill_id']);
  28. }
  29. break;
  30. case 'find_skills':
  31. $skills = $skill->find('all', ['where' => ['name LIKE %?% '=>$_REQUEST['q']]]);
  32. $return_skills = [[
  33. 'items' => []
  34. ]];
  35. foreach ($skills as $skill) {
  36. $return_skills['items'][] = [
  37. 'id' => $skill['id'],
  38. 'text' => $skill['name']
  39. ];
  40. }
  41. header('Content-Type: application/json');
  42. echo json_encode($return_skills);
  43. break;
  44. case 'get_gradebooks':
  45. $gradebooks = $gradebook_list = $gradebook->get_all();
  46. $gradebook_list = [];
  47. //Only course gradebook with certificate
  48. if (!empty($gradebooks)) {
  49. foreach ($gradebooks as $gradebook) {
  50. if ($gradebook['parent_id'] == 0 && !empty($gradebook['certif_min_score']) && !empty($gradebook['document_id'])) {
  51. $gradebook_list[] = $gradebook;
  52. //$gradebook['name'] = $gradebook['name'];
  53. //$gradebook_list[] = $gradebook;
  54. } else {
  55. // $gradebook['name'] = $gradebook_list[$gradebook['parent_id']]['name'].' > '.$gradebook['name'];
  56. //$gradebook_list[] = $gradebook;
  57. }
  58. }
  59. }
  60. echo json_encode($gradebook_list);
  61. break;
  62. case 'find_gradebooks':
  63. $gradebooks = $gradebook->find('all', ['where' => ['name LIKE %?% ' => $_REQUEST['tag']]]);
  64. $return = [];
  65. foreach ($gradebooks as $item) {
  66. $item['key'] = $item['name'];
  67. $item['value'] = $item['id'];
  68. $return[] = $item;
  69. }
  70. echo json_encode($return);
  71. break;
  72. case 'get_course_info_popup':
  73. $course_info = api_get_course_info($_REQUEST['code']);
  74. $courses = CourseManager::processHotCourseItem(
  75. [
  76. ['c_id' => $course_info['real_id']]
  77. ]
  78. );
  79. Display::display_no_header();
  80. Display::$global_template->assign('hot_courses', $courses);
  81. $template = Display::$global_template->get_template('layout/hot_course_item_popup.tpl');
  82. echo Display::$global_template->fetch($template);
  83. break;
  84. case 'gradebook_exists':
  85. $data = $gradebook->get($_REQUEST['gradebook_id']);
  86. if (!empty($data)) {
  87. echo 1;
  88. } else {
  89. echo 0;
  90. }
  91. break;
  92. case 'get_skills_by_profile':
  93. $skill_rel_profile = new SkillRelProfile();
  94. $profile_id = isset($_REQUEST['profile_id']) ? $_REQUEST['profile_id'] : null;
  95. $skills = $skill_rel_profile->getSkillsByProfile($profile_id);
  96. echo json_encode($skills);
  97. break;
  98. case 'get_saved_profiles':
  99. $skill_profile = new SkillProfile();
  100. $profiles = $skill_profile->get_all();
  101. Display::display_no_header();
  102. Display::$global_template->assign('profiles', $profiles);
  103. $template = Display::$global_template->get_template('skill/profile_item.tpl');
  104. echo Display::$global_template->fetch($template);
  105. break;
  106. case 'get_skills':
  107. $load_user_data = isset($_REQUEST['load_user_data']) ? $_REQUEST['load_user_data'] : null;
  108. $id = intval($_REQUEST['id']);
  109. $skills = $skill->get_all($load_user_data, false, $id);
  110. echo json_encode($skills);
  111. break;
  112. case 'get_skill_info':
  113. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  114. $skill_info = $skill->getSkillInfo($id);
  115. echo json_encode($skill_info);
  116. break;
  117. case 'get_skill_course_info':
  118. $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;
  119. $skill_info = $skill->getSkillInfo($id);
  120. $courses = $skill->getCoursesBySkill($id);
  121. $sessions = $skill->getSessionsBySkill($id);
  122. $html = '';
  123. if (!empty($courses) || !empty($sessions)) {
  124. Display::display_no_header();
  125. Display::$global_template->assign('skill', $skill_info);
  126. Display::$global_template->assign('courses', $courses);
  127. Display::$global_template->assign('sessions', $sessions);
  128. $template = Display::$global_template->get_template('skill/skill_info.tpl');
  129. $html = Display::$global_template->fetch($template);
  130. }
  131. echo $html;
  132. break;
  133. case 'get_skills_tree_json':
  134. header('Content-Type: application/json');
  135. $userId = isset($_REQUEST['load_user']) && $_REQUEST['load_user'] == 1 ? api_get_user_id() : 0;
  136. $skill_id = isset($_REQUEST['skill_id']) ? intval($_REQUEST['skill_id']) : 0;
  137. $depth = isset($_REQUEST['main_depth']) ? intval($_REQUEST['main_depth']) : 2;
  138. $all = $skill->getSkillsTreeToJson($userId, $skill_id, false, $depth);
  139. echo $all;
  140. break;
  141. case 'get_user_skill':
  142. $skillId = isset($_REQUEST['profile_id']) ? intval($_REQUEST['profile_id']) : 0;
  143. $skill = $skill->userHasSkill($userId, $skillId);
  144. if ($skill) {
  145. echo 1;
  146. } else {
  147. echo 0;
  148. }
  149. break;
  150. case 'get_all_user_skills':
  151. $skills = $skill->getUserSkills($userId, true);
  152. echo json_encode($skills);
  153. break;
  154. case 'get_user_skills':
  155. $skills = $skill->getUserSkills($userId, true);
  156. Display::display_no_header();
  157. Display::$global_template->assign('skills', $skills);
  158. $template = Display::$global_template->get_template('skill/user_skills.tpl');
  159. echo Display::$global_template->fetch($template);
  160. break;
  161. case 'get_gradebook_info':
  162. $id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : null;
  163. $info = $gradebook->get($id);
  164. echo json_encode($info);
  165. break;
  166. case 'load_children':
  167. $id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : null;
  168. $load_user_data = isset($_REQUEST['load_user_data']) ? $_REQUEST['load_user_data'] : null;
  169. $skills = $skill->getChildren($id, $load_user_data);
  170. $return = [];
  171. foreach ($skills as $skill) {
  172. if (isset($skill['data']) && !empty($skill['data'])) {
  173. $return[$skill['data']['id']] = [
  174. 'id' => $skill['data']['id'],
  175. 'name' => $skill['data']['name'],
  176. 'passed'=> $skill['data']['passed']
  177. ];
  178. }
  179. }
  180. $success = true;
  181. if (empty($return)) {
  182. $success = false;
  183. }
  184. $result = [
  185. 'success' => $success,
  186. 'data' => $return
  187. ];
  188. echo json_encode($result);
  189. break;
  190. case 'load_direct_parents':
  191. $id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : null;
  192. $skills = $skill->getDirectParents($id);
  193. $return = [];
  194. foreach ($skills as $skill) {
  195. $return [$skill['data']['id']] = [
  196. 'id' => $skill['data']['id'],
  197. 'parent_id' => $skill['data']['parent_id'],
  198. 'name' => $skill['data']['name']
  199. ];
  200. }
  201. echo json_encode($return);
  202. break;
  203. case 'profile_matches':
  204. $skill_rel_user = new SkillRelUser();
  205. $skills = (!empty($_REQUEST['skill_id']) ? $_REQUEST['skill_id'] : []);
  206. $total_skills_to_search = $skills;
  207. $users = $skill_rel_user->getUserBySkills($skills);
  208. $user_list = [];
  209. $count_skills = count($skills);
  210. $ordered_user_list = null;
  211. if (!empty($users)) {
  212. foreach ($users as $user) {
  213. $user_info = api_get_user_info($user['user_id']);
  214. $user_list[$user['user_id']]['user'] = $user_info;
  215. $my_user_skills = $skill_rel_user->getUserSkills($user['user_id']);
  216. $user_skill_list = [];
  217. foreach ($my_user_skills as $skill_item) {
  218. $user_skill_list[] = $skill_item['skill_id'];
  219. }
  220. $user_skills = [];
  221. $found_counts = 0;
  222. foreach ($skills as $skill_id) {
  223. $found = false;
  224. if (in_array($skill_id, $user_skill_list)) {
  225. $found = true;
  226. $found_counts++;
  227. $user_skills[$skill_id] = ['skill_id' => $skill_id, 'found' => $found];
  228. }
  229. }
  230. foreach ($my_user_skills as $my_skill) {
  231. if (!isset($user_skills[$my_skill['skill_id']])) {
  232. $user_skills[$my_skill['skill_id']] = [
  233. 'skill_id' => $my_skill['skill_id'],
  234. 'found' => false
  235. ];
  236. }
  237. $total_skills_to_search[$my_skill['skill_id']] = $my_skill['skill_id'];
  238. }
  239. $user_list[$user['user_id']]['skills'] = $user_skills;
  240. $user_list[$user['user_id']]['total_found_skills'] = $found_counts;
  241. }
  242. foreach ($user_list as $user_id => $user_data) {
  243. $ordered_user_list[$user_data['total_found_skills']][] = $user_data;
  244. }
  245. if (!empty($ordered_user_list)) {
  246. krsort($ordered_user_list);
  247. }
  248. }
  249. Display::display_no_header();
  250. Display::$global_template->assign('order_user_list', $ordered_user_list);
  251. Display::$global_template->assign('total_search_skills', $count_skills);
  252. $skill_list = [];
  253. if (!empty($total_skills_to_search)) {
  254. $total_skills_to_search = $skill->getSkillsInfo($total_skills_to_search);
  255. foreach ($total_skills_to_search as $skill_info) {
  256. $skill_list[$skill_info['id']] = $skill_info;
  257. }
  258. }
  259. Display::$global_template->assign('skill_list', $skill_list);
  260. $template = Display::$global_template->get_template('skill/profile.tpl');
  261. echo Display::$global_template->fetch($template);
  262. break;
  263. case 'delete_gradebook_from_skill':
  264. case 'remove_skill':
  265. if (api_is_platform_admin() || api_is_drh()) {
  266. if (!empty($_REQUEST['skill_id']) && !empty($_REQUEST['gradebook_id'])) {
  267. $skill_item = $skillGradeBook->getSkillInfo(
  268. $_REQUEST['skill_id'],
  269. $_REQUEST['gradebook_id']
  270. );
  271. if (!empty($skill_item)) {
  272. $skillGradeBook->delete($skill_item['id']);
  273. echo 1;
  274. } else {
  275. echo 0;
  276. }
  277. } else {
  278. echo 0;
  279. }
  280. }
  281. break;
  282. case 'get_profile':
  283. $skillRelProfile = new SkillRelProfile();
  284. $profileId = isset($_REQUEST['profile_id']) ? intval($_REQUEST['profile_id']) : null;
  285. $profile = $skillRelProfile->getProfileInfo($profileId);
  286. echo json_encode($profile);
  287. break;
  288. case 'save_profile':
  289. if (api_is_platform_admin() || api_is_drh()) {
  290. $skill_profile = new SkillProfile();
  291. $params = $_REQUEST;
  292. $params['skills'] = isset($params['skill_id']) ? $params['skill_id'] : null;
  293. $profileId = isset($_REQUEST['profile']) ? intval($_REQUEST['profile']) : null;
  294. if ($profileId > 0) {
  295. $skill_profile->updateProfileInfo(
  296. $profileId,
  297. $params['name'],
  298. $params['description']
  299. );
  300. $skill_data = 1;
  301. } else {
  302. $skill_data = $skill_profile->save($params);
  303. }
  304. if (!empty($skill_data)) {
  305. echo 1;
  306. } else {
  307. echo 0;
  308. }
  309. }
  310. break;
  311. case 'delete_profile':
  312. if (api_is_platform_admin() || api_is_drh()) {
  313. $profileId = $_REQUEST['profile'];
  314. $skillProfile = new SkillProfile();
  315. $isDeleted = $skillProfile->delete($profileId);
  316. echo json_encode([
  317. 'status' => $isDeleted
  318. ]);
  319. }
  320. break;
  321. case 'skill_exists':
  322. $skill_data = $skill->get($_REQUEST['skill_id']);
  323. if (!empty($skill_data)) {
  324. echo 1;
  325. } else {
  326. echo 0;
  327. }
  328. break;
  329. case 'search_skills':
  330. $skills = $skill->find(
  331. 'all',
  332. [
  333. 'where' => ['name LIKE %?% ' => $_REQUEST['q']]
  334. ]
  335. );
  336. $returnSkills = [];
  337. foreach ($skills as $skill) {
  338. $returnSkills[] = [
  339. 'id' => $skill['id'],
  340. 'text' => $skill['name']
  341. ];
  342. }
  343. echo json_encode([
  344. 'items' => $returnSkills
  345. ]);
  346. break;
  347. default:
  348. echo '';
  349. }
  350. exit;