social.lib.php 49 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015
  1. <?php //$id: $
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * This class provides methods for the social network management.
  5. * Include/require it in your code to use its features.
  6. *
  7. * @package chamilo.social
  8. */
  9. //PLUGIN PLACES
  10. define('SOCIAL_LEFT_PLUGIN', 1);
  11. define('SOCIAL_CENTER_PLUGIN', 2);
  12. define('SOCIAL_RIGHT_PLUGIN', 3);
  13. require_once api_get_path(LIBRARY_PATH).'usermanager.lib.php';
  14. require_once api_get_path(LIBRARY_PATH).'message.lib.php';
  15. class SocialManager extends UserManager {
  16. private function __construct() {
  17. }
  18. /**
  19. * Allow to see contacts list
  20. * @author isaac flores paz <florespaz@bidsoftperu.com>
  21. * @return array
  22. */
  23. public static function show_list_type_friends () {
  24. $friend_relation_list=array();
  25. $count_list=0;
  26. $tbl_my_friend_relation_type = Database :: get_main_table(TABLE_MAIN_USER_FRIEND_RELATION_TYPE);
  27. $sql='SELECT id,title FROM '.$tbl_my_friend_relation_type.' WHERE id<>6 ORDER BY id ASC';
  28. $result=Database::query($sql);
  29. while ($row=Database::fetch_array($result,'ASSOC')) {
  30. $friend_relation_list[]=$row;
  31. }
  32. $count_list=count($friend_relation_list);
  33. if ($count_list==0) {
  34. $friend_relation_list[]=get_lang('UnkNow');
  35. } else {
  36. return $friend_relation_list;
  37. }
  38. }
  39. /**
  40. * Get relation type contact by name
  41. * @param string names of the kind of relation
  42. * @return int
  43. * @author isaac flores paz <florespaz@bidsoftperu.com>
  44. */
  45. public static function get_relation_type_by_name ($relation_type_name) {
  46. $list_type_friend=array();
  47. $list_type_friend=self::show_list_type_friends();
  48. foreach ($list_type_friend as $value_type_friend) {
  49. if (strtolower($value_type_friend['title'])==$relation_type_name) {
  50. return $value_type_friend['id'];
  51. }
  52. }
  53. }
  54. /**
  55. * Get the kind of relation between contacts
  56. * @param int user id
  57. * @param int user friend id
  58. * @param string
  59. * @author isaac flores paz <florespaz@bidsoftperu.com>
  60. */
  61. public static function get_relation_between_contacts ($user_id,$user_friend) {
  62. $tbl_my_friend_relation_type = Database :: get_main_table(TABLE_MAIN_USER_FRIEND_RELATION_TYPE);
  63. $tbl_my_friend = Database :: get_main_table(TABLE_MAIN_USER_REL_USER);
  64. $sql= 'SELECT rt.id as id FROM '.$tbl_my_friend_relation_type.' rt ' .
  65. 'WHERE rt.id=(SELECT uf.relation_type FROM '.$tbl_my_friend.' uf WHERE user_id='.((int)$user_id).' AND friend_user_id='.((int)$user_friend).' AND uf.relation_type <> '.USER_RELATION_TYPE_RRHH.' )';
  66. $res=Database::query($sql);
  67. if (Database::num_rows($res)>0) {
  68. $row=Database::fetch_array($res,'ASSOC');
  69. return $row['id'];
  70. } else {
  71. return USER_UNKNOW;
  72. }
  73. }
  74. /**
  75. * Gets friends id list
  76. * @param int user id
  77. * @param int group id
  78. * @param string name to search
  79. * @param bool true will load firstname, lastname, and image name
  80. * @return array
  81. * @author Julio Montoya <gugli100@gmail.com> Cleaning code, function renamed, $load_extra_info option added
  82. * @author isaac flores paz <florespaz@bidsoftperu.com>
  83. */
  84. public static function get_friends($user_id, $id_group=null, $search_name=null, $load_extra_info = true) {
  85. $list_ids_friends=array();
  86. $tbl_my_friend = Database :: get_main_table(TABLE_MAIN_USER_REL_USER);
  87. $tbl_my_user = Database :: get_main_table(TABLE_MAIN_USER);
  88. $sql='SELECT friend_user_id FROM '.$tbl_my_friend.' WHERE relation_type NOT IN ('.USER_RELATION_TYPE_DELETED.', '.USER_RELATION_TYPE_RRHH.') AND friend_user_id<>'.((int)$user_id).' AND user_id='.((int)$user_id);
  89. if (isset($id_group) && $id_group>0) {
  90. $sql.=' AND relation_type='.$id_group;
  91. }
  92. if (isset($search_name) && is_string($search_name)===true) {
  93. $search_name = trim($search_name);
  94. $search_name = str_replace(' ', '', $search_name);
  95. //$sql.=' AND friend_user_id IN (SELECT user_id FROM '.$tbl_my_user.' WHERE '.(api_is_western_name_order() ? 'concat(firstName, lastName)' : 'concat(lastName, firstName)').' like concat("%","'.Database::escape_string($search_name).'","%"));';
  96. $sql.=' AND friend_user_id IN (SELECT user_id FROM '.$tbl_my_user.' WHERE firstName LIKE "%'.Database::escape_string($search_name).'%" OR lastName LIKE "%'.Database::escape_string($search_name).'%" OR '.(api_is_western_name_order() ? 'concat(firstName, lastName)' : 'concat(lastName, firstName)').' like concat("%","'.Database::escape_string($search_name).'","%") ) ';
  97. }
  98. $res = Database::query($sql);
  99. while ($row = Database::fetch_array($res, 'ASSOC')) {
  100. if ($load_extra_info) {
  101. $path = UserManager::get_user_picture_path_by_id($row['friend_user_id'],'web',false,true);
  102. $my_user_info = api_get_user_info($row['friend_user_id']);
  103. $list_ids_friends[] = array('friend_user_id'=>$row['friend_user_id'],'firstName'=>$my_user_info['firstName'] , 'lastName'=>$my_user_info['lastName'], 'username'=>$my_user_info['username'], 'image'=>$path['file']);
  104. } else {
  105. $list_ids_friends[] = $row;
  106. }
  107. }
  108. return $list_ids_friends;
  109. }
  110. /**
  111. * get list web path of contacts by user id
  112. * @param int user id
  113. * @param int group id
  114. * @param string name to search
  115. * @param array
  116. * @author isaac flores paz <florespaz@bidsoftperu.com>
  117. */
  118. public static function get_list_path_web_by_user_id ($user_id,$id_group=null,$search_name=null) {
  119. $list_paths=array();
  120. $list_path_friend=array();
  121. $array_path_user=array();
  122. $combine_friend = array();
  123. $list_ids = self::get_friends($user_id,$id_group,$search_name);
  124. if (is_array($list_ids)) {
  125. foreach ($list_ids as $values_ids) {
  126. $list_path_image_friend[] = UserManager::get_user_picture_path_by_id($values_ids['friend_user_id'],'web',false,true);
  127. $combine_friend=array('id_friend'=>$list_ids,'path_friend'=>$list_path_image_friend);
  128. }
  129. }
  130. return $combine_friend;
  131. }
  132. /**
  133. * get web path of user invitate
  134. * @author isaac flores paz <florespaz@bidsoftperu.com>
  135. * @param int user id
  136. * @return array
  137. */
  138. public static function get_list_web_path_user_invitation_by_user_id ($user_id) {
  139. $list_paths=array();
  140. $list_path_friend=array();
  141. $list_ids = self::get_list_invitation_of_friends_by_user_id((int)$user_id);
  142. foreach ($list_ids as $values_ids) {
  143. $list_path_image_friend[] = UserManager::get_user_picture_path_by_id($values_ids['user_sender_id'],'web',false,true);
  144. }
  145. return $list_path_image_friend;
  146. }
  147. /**
  148. * Sends an invitation to contacts
  149. * @param int user id
  150. * @param int user friend id
  151. * @param string title of the message
  152. * @param string content of the message
  153. * @return boolean
  154. * @author isaac flores paz <florespaz@bidsoftperu.com>
  155. * @author Julio Montoya <gugli100@gmail.com> Cleaning code
  156. */
  157. public static function send_invitation_friend ($user_id,$friend_id,$message_title,$message_content) {
  158. $tbl_message = Database::get_main_table(TABLE_MAIN_MESSAGE);
  159. $user_id = intval($user_id);
  160. $friend_id = intval($friend_id);
  161. $message_title = Database::escape_string($message_title);
  162. $message_content = Database::escape_string($message_content);
  163. $current_date = date('Y-m-d H:i:s',time());
  164. $sql_exist='SELECT COUNT(*) AS count FROM '.$tbl_message.' WHERE user_sender_id='.($user_id).' AND user_receiver_id='.($friend_id).' AND msg_status IN(5,6,7);';
  165. $res_exist=Database::query($sql_exist);
  166. $row_exist=Database::fetch_array($res_exist,'ASSOC');
  167. if ($row_exist['count']==0) {
  168. $sql='INSERT INTO '.$tbl_message.'(user_sender_id,user_receiver_id,msg_status,send_date,title,content) VALUES('.$user_id.','.$friend_id.','.MESSAGE_STATUS_INVITATION_PENDING.',"'.$current_date.'","'.$message_title.'","'.$message_content.'")';
  169. Database::query($sql);
  170. require_once api_get_path(LIBRARY_PATH).'notification.lib.php';
  171. $notification = new Notification();
  172. $notification->save_invitation_notifications(array($friend_id), $message_title, $message_content);
  173. return true;
  174. } else {
  175. //invitation already exist
  176. $sql_if_exist='SELECT COUNT(*) AS count, id FROM '.$tbl_message.' WHERE user_sender_id='.$user_id.' AND user_receiver_id='.$friend_id.' AND msg_status=7';
  177. $res_if_exist=Database::query($sql_if_exist);
  178. $row_if_exist=Database::fetch_array($res_if_exist,'ASSOC');
  179. if ($row_if_exist['count']==1) {
  180. $sql_if_exist_up='UPDATE '.$tbl_message.'SET msg_status=5, content = "'.$message_content.'" WHERE user_sender_id='.$user_id.' AND user_receiver_id='.$friend_id.' AND msg_status = 7 ';
  181. //$sql_if_exist_up='UPDATE '.$tbl_message.'SET msg_status=5, set content = '.$message_content.' WHERE id='.$row_if_exist['id'].'';
  182. Database::query($sql_if_exist_up);
  183. return true;
  184. } else {
  185. return false;
  186. }
  187. }
  188. }
  189. /**
  190. * Get number messages of the inbox
  191. * @author isaac flores paz <florespaz@bidsoftperu.com>
  192. * @param int user receiver id
  193. * @return int
  194. */
  195. public static function get_message_number_invitation_by_user_id ($user_receiver_id) {
  196. $tbl_message=Database::get_main_table(TABLE_MAIN_MESSAGE);
  197. $sql='SELECT COUNT(*) as count_message_in_box FROM '.$tbl_message.' WHERE user_receiver_id='.intval($user_receiver_id).' AND msg_status='.MESSAGE_STATUS_INVITATION_PENDING;
  198. $res=Database::query($sql);
  199. $row=Database::fetch_array($res,'ASSOC');
  200. return $row['count_message_in_box'];
  201. }
  202. /**
  203. * Get invitation list received by user
  204. * @author isaac flores paz <florespaz@bidsoftperu.com>
  205. * @param int user id
  206. * @return array()
  207. */
  208. public static function get_list_invitation_of_friends_by_user_id ($user_id) {
  209. $list_friend_invitation=array();
  210. $tbl_message=Database::get_main_table(TABLE_MAIN_MESSAGE);
  211. $sql='SELECT user_sender_id,send_date,title,content FROM '.$tbl_message.' WHERE user_receiver_id='.intval($user_id).' AND msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;
  212. $res=Database::query($sql);
  213. while ($row=Database::fetch_array($res,'ASSOC')) {
  214. $list_friend_invitation[]=$row;
  215. }
  216. return $list_friend_invitation;
  217. }
  218. /**
  219. * Get invitation list sent by user
  220. * @author Julio Montoya <gugli100@gmail.com>
  221. * @param int user id
  222. * @return array()
  223. */
  224. public static function get_list_invitation_sent_by_user_id ($user_id) {
  225. $list_friend_invitation=array();
  226. $tbl_message=Database::get_main_table(TABLE_MAIN_MESSAGE);
  227. $sql='SELECT user_receiver_id, send_date,title,content FROM '.$tbl_message.' WHERE user_sender_id = '.intval($user_id).' AND msg_status = '.MESSAGE_STATUS_INVITATION_PENDING;
  228. $res=Database::query($sql);
  229. while ($row=Database::fetch_array($res,'ASSOC')) {
  230. $list_friend_invitation[$row['user_receiver_id']]=$row;
  231. }
  232. return $list_friend_invitation;
  233. }
  234. /**
  235. * Accepts invitation
  236. * @param int user sender id
  237. * @param int user receiver id
  238. * @author isaac flores paz <florespaz@bidsoftperu.com>
  239. * @author Julio Montoya <gugli100@gmail.com> Cleaning code
  240. */
  241. public static function invitation_accepted ($user_send_id,$user_receiver_id) {
  242. $tbl_message=Database::get_main_table(TABLE_MAIN_MESSAGE);
  243. $sql='UPDATE '.$tbl_message.' SET msg_status='.MESSAGE_STATUS_INVITATION_ACCEPTED.' WHERE user_sender_id='.((int)$user_send_id).' AND user_receiver_id='.((int)$user_receiver_id).';';
  244. Database::query($sql);
  245. }
  246. /**
  247. * Denies invitation
  248. * @param int user sender id
  249. * @param int user receiver id
  250. * @author isaac flores paz <florespaz@bidsoftperu.com>
  251. * @author Julio Montoya <gugli100@gmail.com> Cleaning code
  252. */
  253. public static function invitation_denied ($user_send_id,$user_receiver_id) {
  254. $tbl_message=Database::get_main_table(TABLE_MAIN_MESSAGE);
  255. //$msg_status=7;
  256. //$sql='UPDATE '.$tbl_message.' SET msg_status='.$msg_status.' WHERE user_sender_id='.((int)$user_send_id).' AND user_receiver_id='.((int)$user_receiver_id).';';
  257. $sql='DELETE FROM '.$tbl_message.' WHERE user_sender_id='.((int)$user_send_id).' AND user_receiver_id='.((int)$user_receiver_id).';';
  258. Database::query($sql);
  259. }
  260. /**
  261. * allow attach to group
  262. * @author isaac flores paz <florespaz@bidsoftperu.com>
  263. * @param int user to qualify
  264. * @param int kind of rating
  265. * @return void()
  266. */
  267. public static function qualify_friend ($id_friend_qualify,$type_qualify) {
  268. $tbl_user_friend=Database::get_main_table(TABLE_MAIN_USER_REL_USER);
  269. $user_id=api_get_user_id();
  270. $sql='UPDATE '.$tbl_user_friend.' SET relation_type='.((int)$type_qualify).' WHERE user_id='.((int)$user_id).' AND friend_user_id='.((int)$id_friend_qualify).';';
  271. Database::query($sql);
  272. }
  273. /**
  274. * Sends invitations to friends
  275. * @author Isaac Flores Paz <isaac.flores.paz@gmail.com>
  276. * @author Julio Montoya <gugli100@gmail.com> Cleaning code
  277. * @param void
  278. * @return string message invitation
  279. */
  280. public static function send_invitation_friend_user ($userfriend_id,$subject_message='',$content_message='') {
  281. global $charset;
  282. //$id_user_friend=array();
  283. $user_info = array();
  284. $user_info = api_get_user_info($userfriend_id);
  285. $succes = get_lang('MessageSentTo');
  286. $succes.= ' : '.api_get_person_name($user_info['firstName'], $user_info['lastName']);
  287. if (isset($subject_message) && isset($content_message) && isset($userfriend_id)) {
  288. $send_message = MessageManager::send_message($userfriend_id, $subject_message, $content_message);
  289. if ($send_message) {
  290. echo Display::display_confirmation_message($succes,true);
  291. } else {
  292. echo Display::display_error_message($succes,true);
  293. }
  294. return false;
  295. } elseif (isset($userfriend_id) && !isset($subject_message)) {
  296. $count_is_true=false;
  297. $count_number_is_true=0;
  298. if (isset($userfriend_id) && $userfriend_id>0) {
  299. $message_title = get_lang('Invitation');
  300. $count_is_true = self::send_invitation_friend(api_get_user_id(),$userfriend_id, $message_title, $content_message);
  301. if ($count_is_true) {
  302. echo Display::display_normal_message(api_htmlentities(get_lang('InvitationHasBeenSent'), ENT_QUOTES,$charset),false);
  303. }else {
  304. echo Display::display_error_message(api_htmlentities(get_lang('YouAlreadySentAnInvitation'), ENT_QUOTES,$charset),false);
  305. }
  306. }
  307. }
  308. }
  309. /**
  310. * Get user's feeds
  311. * @param int User ID
  312. * @param int Limit of posts per feed
  313. * @return string HTML section with all feeds included
  314. * @author Yannick Warnier
  315. * @since Dokeos 1.8.6.1
  316. */
  317. public static function get_user_feeds($user, $limit=5) {
  318. if (!function_exists('fetch_rss')) { return '';}
  319. $fields = UserManager::get_extra_fields();
  320. $feed_fields = array();
  321. $feeds = array();
  322. $feed = UserManager::get_extra_user_data_by_field($user,'rssfeeds');
  323. if(empty($feed)) { return ''; }
  324. $feeds = split(';',$feed['rssfeeds']);
  325. if (count($feeds)==0) { return ''; }
  326. foreach ($feeds as $url) {
  327. if (empty($url)) { continue; }
  328. $rss = @fetch_rss($url);
  329. $i = 1;
  330. if (!empty($rss->items)) {
  331. $icon_rss = '';
  332. if (!empty($feed)) {
  333. $icon_rss = Display::url(Display::return_icon('rss.png', '', array(), 32), Security::remove_XSS($feed['rssfeeds']), array('target'=>'_blank'));
  334. }
  335. $res .= '<h2>'.$rss->channel['title'].''.$icon_rss.'</h2>';
  336. $res .= '<div class="social-rss-channel-items">';
  337. foreach ($rss->items as $item) {
  338. if ($limit>=0 and $i>$limit) {break;}
  339. $res .= '<h3><a href="'.$item['link'].'">'.$item['title'].'</a></h3>';
  340. $res .= '<div class="social-rss-item-date">'.api_get_datetime($item['date_timestamp']).'</div>';
  341. $res .= '<div class="social-rss-item-content">'.$item['description'].'</div><br />';
  342. $i++;
  343. }
  344. $res .= '</div>';
  345. }
  346. }
  347. return $res;
  348. }
  349. /**
  350. * Helper functions definition
  351. */
  352. public static function get_logged_user_course_html($my_course, $count) {
  353. global $nosession, $nbDigestEntries, $orderKey, $digest, $thisCourseSysCode;
  354. if (api_get_setting('use_session_mode')=='true' && !$nosession) {
  355. global $now, $date_start, $date_end;
  356. }
  357. //initialise
  358. $result = '';
  359. // Table definitions
  360. $main_user_table = Database :: get_main_table(TABLE_MAIN_USER);
  361. $tbl_session = Database :: get_main_table(TABLE_MAIN_SESSION);
  362. $course_database = $my_course['db'];
  363. $course_tool_table = Database :: get_course_table(TABLE_TOOL_LIST, $course_database);
  364. $tool_edit_table = Database :: get_course_table(TABLE_ITEM_PROPERTY, $course_database);
  365. $course_group_user_table = Database :: get_course_table(TOOL_USER, $course_database);
  366. $user_id = api_get_user_id();
  367. $course_system_code = $my_course['k'];
  368. $course_visual_code = $my_course['c'];
  369. $course_title = $my_course['i'];
  370. $course_directory = $my_course['d'];
  371. $course_teacher = $my_course['t'];
  372. $course_teacher_email = isset($my_course['email'])?$my_course['email']:'';
  373. $course_info = Database :: get_course_info($course_system_code);
  374. $course_access_settings = CourseManager :: get_access_settings($course_system_code);
  375. $course_visibility = $course_access_settings['visibility'];
  376. $user_in_course_status = CourseManager :: get_user_in_course_status(api_get_user_id(), $course_system_code);
  377. //function logic - act on the data
  378. $is_virtual_course = CourseManager :: is_virtual_course_from_system_code($my_course['k']);
  379. if ($is_virtual_course) {
  380. // If the current user is also subscribed in the real course to which this
  381. // virtual course is linked, we don't need to display the virtual course entry in
  382. // the course list - it is combined with the real course entry.
  383. $target_course_code = CourseManager :: get_target_of_linked_course($course_system_code);
  384. $is_subscribed_in_target_course = CourseManager :: is_user_subscribed_in_course(api_get_user_id(), $target_course_code);
  385. if ($is_subscribed_in_target_course) {
  386. return; //do not display this course entry
  387. }
  388. }
  389. $has_virtual_courses = CourseManager :: has_virtual_courses_from_code($course_system_code, api_get_user_id());
  390. if ($has_virtual_courses) {
  391. $return_result = CourseManager :: determine_course_title_from_course_info(api_get_user_id(), $course_info);
  392. $course_display_title = $return_result['title'];
  393. $course_display_code = $return_result['code'];
  394. } else {
  395. $course_display_title = $course_title;
  396. $course_display_code = $course_visual_code;
  397. }
  398. $s_course_status=$my_course['s'];
  399. $s_htlm_status_icon="";
  400. if ($s_course_status==1) {
  401. $s_htlm_status_icon=Display::return_icon('course.gif', get_lang('Course')).' '.Display::return_icon('teachers.gif', get_lang('Status').': '.get_lang('Teacher'),array('style'=>'width:11px; height:11px'));
  402. }
  403. if ($s_course_status==2) {
  404. $s_htlm_status_icon=Display::return_icon('course.gif', get_lang('Course')).' '.Display::return_icon('coachs.gif', get_lang('Status').': '.get_lang('GeneralCoach'),array('style'=>'width:11px; height:11px'));
  405. }
  406. if ($s_course_status==5) {
  407. $s_htlm_status_icon=Display::return_icon('course.gif', get_lang('Course')).' '.Display::return_icon('students.gif', get_lang('Status').': '.get_lang('Student'),array('style'=>'width:11px; height:11px'));
  408. }
  409. //display course entry
  410. $result .= '<div id="div_'.$count.'">';
  411. $result .= '<h2><img src="../img/nolines_plus.gif" id="btn_'.$count.'" onclick="toogle_course(this,\''.$course_database.'\' )">';
  412. $result .= $s_htlm_status_icon;
  413. //show a hyperlink to the course, unless the course is closed and user is not course admin
  414. if ($course_visibility != COURSE_VISIBILITY_CLOSED || $user_in_course_status == COURSEMANAGER) {
  415. $result .= '<a href="javascript:void(0)" id="ln_'.$count.'" onclick=toogle_course(this,\''.$course_database.'\');>&nbsp;'.$course_title.'</a></h2>';
  416. } else {
  417. $result .= $course_display_title." "." ".get_lang('CourseClosed')."";
  418. }
  419. $current_course_settings = CourseManager :: get_access_settings($my_course['k']);
  420. // display the what's new icons
  421. if ((CONFVAL_showExtractInfo == SCRIPTVAL_InCourseList || CONFVAL_showExtractInfo == SCRIPTVAL_Both) && $nbDigestEntries > 0) {
  422. reset($digest);
  423. $result .= '<ul>';
  424. while (list ($key2) = each($digest[$thisCourseSysCode])) {
  425. $result .= '<li>';
  426. if ($orderKey[1] == 'keyTools') {
  427. $result .= "<a href=\"$toolsList[$key2] [\"path\"] $thisCourseSysCode \">";
  428. $result .= "$toolsList[$key2][\"name\"]</a>";
  429. } else {
  430. $result .= api_convert_and_format_date($key2, DATE_FORMAT_LONG, date_default_timezone_get());
  431. }
  432. $result .= '</li>';
  433. $result .= '<ul>';
  434. reset($digest[$thisCourseSysCode][$key2]);
  435. while (list ($key3, $dataFromCourse) = each($digest[$thisCourseSysCode][$key2])) {
  436. $result .= '<li>';
  437. if ($orderKey[2] == 'keyTools') {
  438. $result .= "<a href=\"$toolsList[$key3] [\"path\"] $thisCourseSysCode \">";
  439. $result .= "$toolsList[$key3][\"name\"]</a>";
  440. } else {
  441. $result .= api_convert_and_format_date($key3, DATE_FORMAT_LONG, date_default_timezone_get());
  442. }
  443. $result .= '<ul compact="compact">';
  444. reset($digest[$thisCourseSysCode][$key2][$key3]);
  445. while (list ($key4, $dataFromCourse) = each($digest[$thisCourseSysCode][$key2][$key3])) {
  446. $result .= '<li>';
  447. $result .= htmlspecialchars(substr(strip_tags($dataFromCourse), 0, CONFVAL_NB_CHAR_FROM_CONTENT));
  448. $result .= '</li>';
  449. }
  450. $result .= '</ul>';
  451. $result .= '</li>';
  452. }
  453. $result .= '</ul>';
  454. $result .= '</li>';
  455. }
  456. $result .= '</ul>';
  457. }
  458. $result .= '</li>';
  459. $result .= '</div>';
  460. if (api_get_setting('use_session_mode')=='true' && !$nosession) {
  461. $session = '';
  462. $active = false;
  463. if (!empty($my_course['session_name'])) {
  464. // Request for the name of the general coach
  465. $sql = 'SELECT lastname, firstname
  466. FROM '.$tbl_session.' ts LEFT JOIN '.$main_user_table .' tu
  467. ON ts.id_coach = tu.user_id
  468. WHERE ts.id='.(int) $my_course['id_session']. ' LIMIT 1';
  469. $rs = Database::query($sql);
  470. $sessioncoach = Database::store_result($rs);
  471. $sessioncoach = $sessioncoach[0];
  472. $session = array();
  473. $session['title'] = $my_course['session_name'];
  474. if ( $my_course['date_start']=='0000-00-00' ) {
  475. $session['dates'] = get_lang('WithoutTimeLimits');
  476. if ( api_get_setting('show_session_coach') === 'true' ) {
  477. $session['coach'] = get_lang('GeneralCoach').': '.api_get_person_name($sessioncoach['firstname'], $sessioncoach['lastname']);
  478. }
  479. $active = true;
  480. } else {
  481. $session ['dates'] = ' - '.get_lang('From').' '.$my_course['date_start'].' '.get_lang('To').' '.$my_course['date_end'];
  482. if ( api_get_setting('show_session_coach') === 'true' ) {
  483. $session['coach'] = get_lang('GeneralCoach').': '.api_get_person_name($sessioncoach['firstname'], $sessioncoach['lastname']);
  484. }
  485. $active = ($date_start <= $now && $date_end >= $now)?true:false;
  486. }
  487. }
  488. $output = array ($my_course['user_course_cat'], $result, $my_course['id_session'], $session, 'active'=>$active);
  489. } else {
  490. $output = array ($my_course['user_course_cat'], $result);
  491. }
  492. //$my_course['creation_date'];
  493. return $output;
  494. }
  495. /**
  496. * Shows the right menu of the Social Network tool
  497. *
  498. * @param string highlight link possible values: group_add, home, messages, messages_inbox, messages_compose ,messages_outbox ,invitations, shared_profile, friends, groups search
  499. * @param int group id
  500. * @param int user id
  501. * @param bool show profile or not (show or hide the user image/information)
  502. *
  503. */
  504. public static function show_social_menu($show = '', $group_id = 0, $user_id = 0, $show_full_profile = false) {
  505. if (empty($user_id)) {
  506. $user_id = api_get_user_id();
  507. }
  508. $show_groups = array('groups', 'group_messages', 'messages_list', 'group_add', 'mygroups', 'group_edit', 'member_list', 'invite_friends', 'waiting_list', 'browse_groups');
  509. $show_messages = array('messages', 'messages_inbox', 'messages_outbox', 'messages_compose');
  510. // get count unread message and total invitations
  511. $count_unread_message = MessageManager::get_number_of_messages(true);
  512. $count_unread_message = (!empty($count_unread_message)?' ('.$count_unread_message.')':'');
  513. $number_of_new_messages_of_friend = SocialManager::get_message_number_invitation_by_user_id(api_get_user_id());
  514. $group_pending_invitations = GroupPortalManager::get_groups_by_user(api_get_user_id(), GROUP_USER_PERMISSION_PENDING_INVITATION,false);
  515. $group_pending_invitations = count($group_pending_invitations);
  516. $total_invitations = $number_of_new_messages_of_friend + $group_pending_invitations;
  517. $total_invitations = (!empty($total_invitations)?' ('.$total_invitations.')':'');
  518. // Everybody can create groups
  519. /*
  520. if (api_get_setting('allow_students_to_create_groups_in_social') == 'true') {
  521. $create_group_item = '<li class="social-menu-sub-level"><a href="'.api_get_path(WEB_PATH).'main/social/group_add.php">'.Display::return_icon('group_add.png',get_lang('CreateASocialGroup'),array('hspace'=>'6','style'=>'float:left')).'<span class="'.($show=='group_add'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('CreateASocialGroup').'</span></a></li>';
  522. } else {
  523. // Only admins and teachers can create groups
  524. if (api_is_allowed_to_edit(null,true)) {
  525. $create_group_item = '<li class="social-menu-sub-level"><a href="'.api_get_path(WEB_PATH).'main/social/group_add.php">'.Display::return_icon('group_add.png',get_lang('CreateASocialGroup'),array('hspace'=>'6','style'=>'float:left')).'<span class="'.($show=='group_add'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('CreateASocialGroup').'</span></a></li>';
  526. }
  527. }*/
  528. echo '<div class="social-menu">';
  529. echo '<script type="text/javascript">
  530. function show_icon_edit(element_html) {
  531. ident="#edit_image";
  532. $(ident).show();
  533. }
  534. function hide_icon_edit(element_html) {
  535. ident="#edit_image";
  536. $(ident).hide();
  537. }
  538. </script>';
  539. if (in_array($show, $show_groups) && !empty($group_id)) {
  540. //--- Group image
  541. $group_info = GroupPortalManager::get_group_data($group_id);
  542. $big = GroupPortalManager::get_picture_group($group_id, $group_info['picture_uri'],160,GROUP_IMAGE_SIZE_BIG);
  543. $original = GroupPortalManager::get_picture_group($group_id, $group_info['picture_uri'],'',GROUP_IMAGE_SIZE_ORIGINAL);
  544. echo '<div class="social-content-image">';
  545. echo '<div class="social-background-content" onmouseout="hide_icon_edit()" onmouseover="show_icon_edit()"><center>';
  546. echo Display::url('<img src='.$big['file'].' class="social-groups-image" /> </a><br /><br />', api_get_path(WEB_PATH).'main/social/groups.php?id='.$group_id);
  547. if (GroupPortalManager::is_group_admin($group_id, api_get_user_id())) {
  548. echo '<div id="edit_image" class="hidden_message" style="display:none"><a href="'.api_get_path(WEB_PATH).'main/social/group_edit.php?id='.$group_id.'">'.get_lang('EditGroup').'</a></div>';
  549. }
  550. echo '</center></div>';
  551. echo '</div>';
  552. } else {
  553. $img_array = UserManager::get_user_picture_path_by_id($user_id,'web',true,true);
  554. $big_image = UserManager::get_picture_user($user_id, $img_array['file'],'', USER_IMAGE_SIZE_BIG);
  555. $big_image = $big_image['file'].$big_image['dir'];
  556. //--- User image
  557. echo '<div class="social-content-image">';
  558. echo '<div class="social-background-content" onmouseout="hide_icon_edit()" onmouseover="show_icon_edit()"><center>';
  559. if ($img_array['file'] != 'unknown.jpg') {
  560. echo '<a class="thickbox" href="'.$big_image.'"><img src='.$img_array['dir'].$img_array['file'].' /> </a>';
  561. } else {
  562. echo '<img src='.$img_array['dir'].$img_array['file'].' width="110px" />';
  563. }
  564. if (api_get_user_id() == $user_id) {
  565. echo '<div id="edit_image" class="hidden_message" style="display:none"><a href="'.api_get_path(WEB_PATH).'main/auth/profile.php">'.get_lang('EditProfile').'</a></div>';
  566. }
  567. echo '</center></div>';
  568. echo '</div>';
  569. }
  570. if (!in_array($show, array('shared_profile', 'groups', 'group_edit', 'member_list','waiting_list','invite_friends'))) {
  571. echo '<div align="center" class="social-menu-title">';
  572. echo '<span class="social-menu-text1">'.get_lang('Menu').'</span>';
  573. echo '</div>';
  574. echo '<div><ul>';
  575. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/home.php">'.Display::return_icon('home.png',get_lang('Home'),array('hspace'=>'6')).'<span class="'.($show=='home'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Home').'</span></a></li>';
  576. echo '<li><a href="'.api_get_path(WEB_PATH).'main/messages/inbox.php?f=social">'.Display::return_icon('instant_message.png',get_lang('Messages'),array('hspace'=>'6')).'<span class="'.($show=='messages'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Messages').$count_unread_message.'</span></a></li>';
  577. if (in_array($show, $show_messages)) {
  578. /*echo '<li><ul>';
  579. echo '<li class="social-menu-sub-level"><a href="'.api_get_path(WEB_PATH).'main/messages/new_message.php?f=social">'.Display::return_icon('compose_message.png', get_lang('ComposeMessage'), array('hspace'=>'6','style'=>'float:left')).'<span class="'.($show=='messages_compose'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('ComposeMessage').'</span></a></li>';
  580. echo '<li class="social-menu-sub-level"><a href="'.api_get_path(WEB_PATH).'main/messages/inbox.php?f=social">'.Display::return_icon('inbox.png', get_lang('Inbox'), array('hspace'=>'6')).'<span class="'.($show=='messages_inbox'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Inbox').'</span></a></li>';
  581. echo '<li class="social-menu-sub-level" style="background:none;padding:0px"><a href="'.api_get_path(WEB_PATH).'main/messages/outbox.php?f=social">'.Display::return_icon('outbox.png', get_lang('Outbox'), array('hspace'=>'6')).'<span class="'.($show=='messages_outbox'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Outbox').'</span></a></li>';
  582. echo '</ul></li>';*/
  583. }
  584. //Invitations
  585. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/invitations.php">'.Display::return_icon('invitation.png',get_lang('Invitations'),array('hspace'=>'6')).'<span class="'.($show=='invitations'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Invitations').$total_invitations.'</span></a></li>';
  586. //Shared profile and groups
  587. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/profile.php">'.Display::return_icon('my_shared_profile.png',get_lang('ViewMySharedProfile'),array('hspace'=>'6')).'<span class="'.($show=='shared_profile'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('ViewMySharedProfile').'</span></a></li>
  588. <li><a href="'.api_get_path(WEB_PATH).'main/social/friends.php">'.Display::return_icon('friend.png',get_lang('Friends'),array('hspace'=>'6')).'<span class="'.($show=='friends'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Friends').'</span></a></li>
  589. <li><a href="'.api_get_path(WEB_PATH).'main/social/groups.php">'.Display::return_icon('group.png',get_lang('SocialGroups'),array('hspace'=>'6')).'<span class="'.($show=='browse_groups'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('SocialGroups').'</span></a></li>';
  590. //Show groups
  591. /* if (in_array($show,$show_groups)) {
  592. echo $create_group_item;
  593. if (api_get_setting('allow_students_to_create_groups_in_social') == 'true' || api_is_platform_admin()) {
  594. echo '<li><ul>';
  595. echo '<li class="social-menu-sub-level" style="background:none;padding:0px"><a href="'.api_get_path(WEB_PATH).'main/social/groups.php?view=mygroups">'.Display::return_icon('group.png',get_lang('MySocialGroups'),array('hspace'=>'6')).'<span class="'.($show=='mygroups'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('MySocialGroups').'</span></a></li>';
  596. echo '</ul></li>';
  597. }
  598. }*/
  599. //Groups
  600. /*
  601. if (api_get_setting('show_groups_to_users') == 'true') {
  602. $group_class = 'social-menu-text4';
  603. if ($show == 'classes') {
  604. $group_class = 'social-menu-text-active';
  605. }
  606. echo Display::tag('li', Display::return_icon('group.png',get_lang('MyGroups'),array('hspace'=>'6')).Display::url(Display::tag('span',get_lang('MyGroups'),array('class'=>$group_class)),api_get_path(WEB_PATH).'main/social/usergroups.php'));
  607. }
  608. */
  609. //Search users
  610. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/search.php">'.Display::return_icon('zoom.png',get_lang('Search'),array('hspace'=>'6')).'<span class="'.($show=='search'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Search').'</span></a></li>';
  611. //My files
  612. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/myfiles.php">'.Display::return_icon('briefcase.png',get_lang('MyFiles'),array('hspace'=>'6'),16).'<span class="'.($show=='myfiles'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('MyFiles').'</span></a></li>';
  613. echo'</ul>
  614. </div>';
  615. }
  616. if (in_array($show, $show_groups) && !empty($group_id)) {
  617. echo GroupPortalManager::show_group_column_information($group_id, api_get_user_id(), $show);
  618. }
  619. if ($show == 'shared_profile') {
  620. echo '<div align="center" class="social-menu-title" ><span class="social-menu-text1">'.get_lang('Menu').'</span></div>';
  621. echo '<div>
  622. <ul>';
  623. // My own profile
  624. if ($show_full_profile && $user_id == intval(api_get_user_id())) {
  625. echo '
  626. <li><a href="'.api_get_path(WEB_PATH).'main/social/home.php">'.Display::return_icon('home.png',get_lang('Home'),array('hspace'=>'6')).'<span class="social-menu-text4" >'.get_lang('Home').'</span></a></li>
  627. <li><a href="'.api_get_path(WEB_PATH).'main/messages/inbox.php?f=social">'.Display::return_icon('instant_message.png',get_lang('Messages'),array('hspace'=>'6')).'<span class="social-menu-text4" >'.get_lang('Messages').$count_unread_message.'</span></a></li>';
  628. echo ' <li><a href="'.api_get_path(WEB_PATH).'main/social/invitations.php">'.Display::return_icon('invitation.png',get_lang('Invitations'),array('hspace'=>'6')).'<span class="'.($show=='invitations'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('Invitations').$total_invitations.'</span></a></li>';
  629. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/profile.php">'.Display::return_icon('my_shared_profile.png',get_lang('ViewMySharedProfile'),array('hspace'=>'6','style'=>'float:left')).'<span class="social-menu-text-active" >'.get_lang('ViewMySharedProfile').'</span></a></li>
  630. <li><a href="'.api_get_path(WEB_PATH).'main/social/friends.php">'.Display::return_icon('friend.png',get_lang('Friends'),array('hspace'=>'6')).'<span class="social-menu-text4" >'.get_lang('Friends').'</span></a></li>
  631. <li><a href="'.api_get_path(WEB_PATH).'main/social/groups.php">'.Display::return_icon('group.png',get_lang('SocialGroups'),array('hspace'=>'6')).'<span class="social-menu-text4" >'.get_lang('SocialGroups').'</span></a></li>';
  632. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/myfiles.php">'.Display::return_icon('briefcase_small.png',get_lang('MyFiles'),array('hspace'=>'6')).'<span class="'.($show=='myfiles'?'social-menu-text-active':'social-menu-text4').'" >'.get_lang('MyFiles').'</span></a></li>';
  633. }
  634. // My friend profile
  635. $html_actions = '';
  636. if ($user_id != api_get_user_id()) {
  637. echo '<li><a href="'.api_get_path(WEB_PATH).'main/messages/send_message_to_userfriend.inc.php?height=300&width=470&user_friend='.$user_id.'&view=profile&view_panel=1" class="thickbox" title="'.get_lang('SendMessage').'">';
  638. echo Display::return_icon('compose_message.png',get_lang('SendMessage')).'&nbsp;&nbsp;'.get_lang('SendMessage').'</a></li>';
  639. }
  640. //check if I already sent an invitation message
  641. $invitation_sent_list = SocialManager::get_list_invitation_sent_by_user_id(api_get_user_id());
  642. if (is_array($invitation_sent_list) && is_array($invitation_sent_list[$user_id]) && count($invitation_sent_list[$user_id]) >0 ) {
  643. echo '<li><a href="'.api_get_path(WEB_PATH).'main/social/invitations.php">'.Display::return_icon('invitation.png',get_lang('YouAlreadySentAnInvitation')).'&nbsp;&nbsp;'.get_lang('YouAlreadySentAnInvitation').'</a></li>';
  644. } else {
  645. if (!$show_full_profile) {
  646. echo '<li><a href="'.api_get_path(WEB_PATH).'main/messages/send_message_to_userfriend.inc.php?view_panel=2&height=230&width=500&user_friend='.$user_id.'" class="thickbox" title="'.get_lang('SendInvitation').'">'.Display :: return_icon('invitation.png', get_lang('SocialInvitationToFriends')).'&nbsp;'.get_lang('SendInvitation').'</a></li>';
  647. }
  648. }
  649. echo '</ul></div>';
  650. /*
  651. // ---- My Agenda Items
  652. $my_agenda_items = show_simple_personal_agenda($user_id);
  653. if (!empty($my_agenda_items)) {
  654. echo '<div class="sectiontitle">';
  655. echo get_lang('MyAgenda');
  656. echo '</div>';
  657. $tbl_personal_agenda = Database :: get_user_personal_table(TABLE_PERSONAL_AGENDA);
  658. echo '<div class="social-content-agenda">';
  659. echo '<div class="social-background-content">';
  660. echo $my_agenda_items;
  661. echo '</div>';
  662. echo '<br /><br />';
  663. echo '</div>';
  664. }
  665. */
  666. if ($show_full_profile && $user_id == intval(api_get_user_id())) {
  667. $personal_course_list = UserManager::get_personal_session_course_list($user_id);
  668. $course_list_code = array();
  669. $i=1;
  670. if (is_array($personal_course_list)) {
  671. foreach ($personal_course_list as $my_course) {
  672. if ($i<=10) {
  673. $list[] = SocialManager::get_logged_user_course_html($my_course,$i);
  674. $course_list_code[] = array('code'=>$my_course['c'],'dbName'=>$my_course['db']);
  675. } else {
  676. break;
  677. }
  678. $i++;
  679. }
  680. //to avoid repeted courses
  681. $course_list_code = array_unique_dimensional($course_list_code);
  682. }
  683. //-----Announcements
  684. $my_announcement_by_user_id= intval($user_id);
  685. $announcements = array();
  686. foreach ($course_list_code as $course) {
  687. $content = AnnouncementManager::get_all_annoucement_by_user_course($course['dbName'],$my_announcement_by_user_id);
  688. $course_info=api_get_course_info($course['code']);
  689. if (!empty($content)) {
  690. $announcements[] = '<li><a href="'.api_get_path(WEB_CODE_PATH).'announcements/announcements.php?cidReq='.$course['code'].'"'.Display::return_icon('announcement.png',get_lang('Announcements'),array('hspace'=>'6')).'<span class="social-menu-text4">'.$course_info['name'].' ('.$content['count'].')</span></a></li>';
  691. }
  692. }
  693. if (!empty($announcements)) {
  694. echo '<div align="center" class="social-menu-title" ><span class="social-menu-text1">'.get_lang('ToolAnnouncement').'</span></div>';
  695. echo '<div>';
  696. echo '<ul>';
  697. foreach ($announcements as $announcement) {
  698. echo $announcement;
  699. }
  700. echo '</ul>';
  701. echo '</div>';
  702. }
  703. }
  704. }
  705. echo '</div>';
  706. }
  707. /**
  708. * Displays a sortable table with the list of online users.
  709. * @param array $user_list
  710. */
  711. public static function display_user_list($user_list) {
  712. global $charset;
  713. if ($_GET['id'] == '') {
  714. $extra_params = array();
  715. $course_url = '';
  716. if (strlen($_GET['cidReq']) > 0) {
  717. $extra_params['cidReq'] = Security::remove_XSS($_GET['cidReq']);
  718. $course_url = '&amp;cidReq='.Security::remove_XSS($_GET['cidReq']);
  719. }
  720. foreach ($user_list as $user) {
  721. $uid = $user[0];
  722. $user_info = api_get_user_info($uid);
  723. $table_row = array();
  724. //Anonymous users can't have access to the profile
  725. if (!api_is_anonymous()) {
  726. if (api_get_setting('allow_social_tool')=='true') {
  727. $url = api_get_path(WEB_PATH).'main/social/profile.php?u='.$uid.$course_url;
  728. } else {
  729. $url = '?id='.$uid.$course_url;
  730. }
  731. } else {
  732. $url = '#';
  733. }
  734. $image_array = UserManager::get_user_picture_path_by_id($uid, 'system', false, true);
  735. if ($image_array['file'] == 'unknown.jpg') {
  736. $friends_profile['file'] = api_get_path(WEB_CODE_PATH).'img/unknown_180_100.jpg';
  737. } else {
  738. $friends_profile = UserManager::get_picture_user($uid, $image_array['file'], 80, USER_IMAGE_SIZE_ORIGINAL );
  739. }
  740. // reduce image
  741. $name = api_get_person_name($user_info['firstName'], $user_info['lastName']);
  742. $table_row[] = '<a href="'.$url.'"><img title = "'.$name.'" class="social-home-users-online" alt="'.$name.'" src="'.$friends_profile['file'].'"></a>';
  743. $table_row[] = '<a href="'.$url.'">'.(cut($user_info['firstName'],16)).'<br />'.cut($user_info['lastName'],18).'</a>';
  744. $user_anonymous = api_get_anonymous_id();
  745. $table_data[] = $table_row;
  746. }
  747. $table_header[] = array(get_lang('UserPicture'), false, 'width="90"');
  748. if (api_get_setting('show_email_addresses') == 'true') {
  749. //$table_header[] = array(get_lang('Email'), true);
  750. }
  751. echo Display::return_sortable_grid('online', $table_header, $table_data, array('per_page' => 20));
  752. //Display::display_sortable_table($table_header, $table_data, array(), array('per_page' => 10), $extra_params, array(),'grid');
  753. }
  754. }
  755. /**
  756. * Displays the information of an individual user
  757. * @param int $user_id
  758. */
  759. public static function display_individual_user($user_id) {
  760. global $interbreadcrumb;
  761. $safe_user_id = Database::escape_string($user_id);
  762. // to prevent a hacking attempt: http://www.dokeos.com/forum/viewtopic.php?t=5363
  763. $user_table = Database::get_main_table(TABLE_MAIN_USER);
  764. $sql = "SELECT * FROM $user_table WHERE user_id='".intval($safe_user_id)."'";
  765. $result = Database::query($sql);
  766. if (Database::num_rows($result) == 1) {
  767. $user_object = Database::fetch_object($result);
  768. $name = GetFullUserName($user_id).($_SESSION['_uid'] == $user_id ? '&nbsp;<strong>('.get_lang('Me').')</strong>' : '' );
  769. $alt = GetFullUserName($user_id).($_SESSION['_uid'] == $user_id ? '&nbsp;('.get_lang('Me').')' : '');
  770. $status = ($user_object->status == COURSEMANAGER ? get_lang('Teacher') : get_lang('Student'));
  771. $interbreadcrumb[] = array('url' => 'whoisonline.php', 'name' => get_lang('UsersOnLineList'));
  772. Display::display_header($alt);
  773. echo '<div class="actions-title">';
  774. echo $alt;
  775. echo '</div><br />';
  776. echo '<div>';
  777. echo '<div style="margin:0 auto; width:350px; border:1px;">';
  778. echo '<div id="whoisonline-user-image" style="float:left; padding:5px;">';
  779. if (strlen(trim($user_object->picture_uri)) > 0) {
  780. $sysdir_array = UserManager::get_user_picture_path_by_id($safe_user_id, 'system');
  781. $sysdir = $sysdir_array['dir'];
  782. $webdir_array = UserManager::get_user_picture_path_by_id($safe_user_id, 'web');
  783. $webdir = $webdir_array['dir'];
  784. $fullurl = $webdir.$user_object->picture_uri;
  785. $system_image_path = $sysdir.$user_object->picture_uri;
  786. list($width, $height, $type, $attr) = @getimagesize($system_image_path);
  787. $resizing = (($height > 200) ? 'height="200"' : '');
  788. $height += 30;
  789. $width += 30;
  790. $window_name = 'window'.uniqid('');
  791. // get the path,width and height from original picture
  792. $big_image = $webdir.'big_'.$user_object->picture_uri;
  793. $big_image_size = api_getimagesize($big_image);
  794. $big_image_width = $big_image_size[0];
  795. $big_image_height = $big_image_size[1];
  796. $url_big_image = $big_image.'?rnd='.time();
  797. echo '<input type="image" src="'.$fullurl.'" alt="'.$alt.'" onclick="javascript: return show_image(\''.$url_big_image.'\',\''.$big_image_width.'\',\''.$big_image_height.'\');"/><br />';
  798. } else {
  799. echo Display::return_icon('unknown.jpg', get_lang('Unknown'));
  800. echo '<br />';
  801. }
  802. echo '<div style="text-align:center;padding-top:5px;">'.$status.'</div>';
  803. echo '</div>';
  804. echo '<div id="whoisonline-user-info" style="float:left; padding-left:15px;">';
  805. global $user_anonymous;
  806. if (api_get_setting('allow_social_tool') == 'true' && api_get_user_id() <> $user_anonymous && api_get_user_id() <> 0) {
  807. echo '<p><a href="'.api_get_path(WEB_CODE_PATH).'social/profile.php?u='.$safe_user_id.'">'.Display :: return_icon('my_shared_profile.png', get_lang('SocialInvitationToFriends'),array('height'=>'18px')).get_lang('ViewSharedProfile').'</a></p>';
  808. $user_anonymous = api_get_anonymous_id();
  809. if ($safe_user_id != api_get_user_id() && !api_is_anonymous($safe_user_id)) {
  810. $user_relation = SocialManager::get_relation_between_contacts(api_get_user_id(), $safe_user_id);
  811. if ($user_relation == 0 || $user_relation == 6) {
  812. echo '<p><a href="main/messages/send_message_to_userfriend.inc.php?view_panel=2&height=300&width=610&user_friend='.$safe_user_id.'" class="thickbox" title="'.get_lang('SendInvitation').'">'.Display :: return_icon('invitation.png', get_lang('SocialInvitationToFriends'),array('height'=>'18px')).'&nbsp;'.get_lang('SendInvitation').'</a></p>
  813. <p><a href="main/messages/send_message_to_userfriend.inc.php?view_panel=1&height=310&width=610&user_friend='.$safe_user_id.'" class="thickbox" title="'.get_lang('SendAMessage').'">'.Display :: return_icon('mail_send.png', get_lang('SendAMessage'),array('height'=>'18px')).'&nbsp;'.get_lang('SendAMessage').'</a></p>';
  814. } else {
  815. echo '<p><a href="main/messages/send_message_to_userfriend.inc.php?view_panel=1&height=310&width=610&user_friend='.$safe_user_id.'" class="thickbox" title="'.get_lang('SendAMessage').'">'.Display :: return_icon('mail_send.png', get_lang('SendAMessage'),array('height'=>'18px')).'&nbsp;'.get_lang('SendAMessage').'</a></p>';
  816. }
  817. }
  818. }
  819. if (api_get_setting('show_email_addresses') == 'true') {
  820. echo Display::encrypted_mailto_link($user_object->email,$user_object->email).'<br />';
  821. }
  822. echo '</div>';
  823. echo '</div>';
  824. echo '</div>';
  825. echo '<div class="clear"></div>';
  826. echo '<div>';
  827. if ($user_object->competences) {
  828. echo '<dt><div class="actions-message"><strong>'.get_lang('MyCompetences').'</strong></div></dt>';
  829. echo '<dd>'.$user_object->competences.'</dd>';
  830. }
  831. if ($user_object->diplomas) {
  832. echo '<dt><div class="actions-message"><strong>'.get_lang('MyDiplomas').'</strong></div></dt>';
  833. echo '<dd>'.$user_object->diplomas.'</dd>';
  834. }
  835. if ($user_object->teach) {
  836. echo '<dt><div class="actions-message"><strong>'.get_lang('MyTeach').'</strong></div></dt>';
  837. echo '<dd>'.$user_object->teach.'</dd>';;
  838. }
  839. SocialManager::display_productions($user_object->user_id);
  840. if ($user_object->openarea) {
  841. echo '<dt><div class="actions-message"><strong>'.get_lang('MyPersonalOpenArea').'</strong></div></dt>';
  842. echo '<dd>'.$user_object->openarea.'</dd>';
  843. }
  844. echo '</div>';
  845. } else {
  846. Display::display_header(get_lang('UsersOnLineList'));
  847. echo '<div class="actions-title">';
  848. echo get_lang('UsersOnLineList');
  849. echo '</div>';
  850. }
  851. }
  852. /**
  853. * Display productions in whoisonline
  854. * @param int $user_id User id
  855. * @todo use the correct api_get_path instead of $clarolineRepositoryWeb
  856. */
  857. public static function display_productions($user_id) {
  858. $sysdir_array = UserManager::get_user_picture_path_by_id($user_id, 'system', true);
  859. $sysdir = $sysdir_array['dir'].$user_id.'/';
  860. $webdir_array = UserManager::get_user_picture_path_by_id($user_id, 'web', true);
  861. $webdir = $webdir_array['dir'].$user_id.'/';
  862. if (!is_dir($sysdir)) {
  863. mkdir($sysdir, api_get_permissions_for_new_directories(), true);
  864. }
  865. /*
  866. $handle = opendir($sysdir);
  867. $productions = array();
  868. while ($file = readdir($handle)) {
  869. if ($file == '.' || $file == '..' || $file == '.htaccess') {
  870. continue; // Skip current and parent directories
  871. }
  872. if (preg_match('/('.$user_id.'|[0-9a-f]{13}|saved)_.+\.(png|jpg|jpeg|gif)$/i', $file)) {
  873. // User's photos should not be listed as productions.
  874. continue;
  875. }
  876. $productions[] = $file;
  877. }
  878. */
  879. $productions = UserManager::get_user_productions($user_id);
  880. if (count($productions) > 0) {
  881. echo '<dt><strong>'.get_lang('Productions').'</strong></dt>';
  882. echo '<dd><ul>';
  883. foreach ($productions as $index => $file) {
  884. // Only display direct file links to avoid browsing an empty directory
  885. if (is_file($sysdir.$file) && $file != $webdir_array['file']) {
  886. echo '<li><a href="'.$webdir.urlencode($file).'" target=_blank>'.$file.'</a></li>';
  887. }
  888. // Real productions are under a subdirectory by the User's id
  889. if (is_dir($sysdir.$file)) {
  890. $subs = scandir($sysdir.$file);
  891. foreach ($subs as $my => $sub) {
  892. if (substr($sub, 0, 1) != '.' && is_file($sysdir.$file.'/'.$sub)) {
  893. echo '<li><a href="'.$webdir.urlencode($file).'/'.urlencode($sub).'" target=_blank>'.$sub.'</a></li>';
  894. }
  895. }
  896. }
  897. }
  898. echo '</ul></dd>';
  899. }
  900. }
  901. /**
  902. * Dummy function
  903. *
  904. */
  905. public static function get_plugins($place = SOCIAL_CENTER_PLUGIN) {
  906. $content = '';
  907. switch ($place) {
  908. case SOCIAL_CENTER_PLUGIN:
  909. $social_plugins = array(1, 2);
  910. if (is_array($social_plugins) && count($social_plugins)>0) {
  911. $content.= '<div id="social-plugins">';
  912. foreach($social_plugins as $plugin ) {
  913. $content.= '<div class="social-plugin-item">';
  914. $content.= $plugin;
  915. $content.= '</div>';
  916. }
  917. $content.= '</div>';
  918. }
  919. break;
  920. case SOCIAL_LEFT_PLUGIN:
  921. break;
  922. case SOCIAL_RIGHT_PLUGIN:
  923. break;
  924. }
  925. return $content;
  926. }
  927. }