social.lib.php 48 KB

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