system_announcements.lib.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.library
  5. */
  6. /**
  7. * Code
  8. */
  9. /**
  10. * This is the system announcements library.
  11. *
  12. * @package chamilo.library
  13. */
  14. class SystemAnnouncementManager
  15. {
  16. const VISIBLE_GUEST = 1;
  17. const VISIBLE_STUDENT = 2;
  18. const VISIBLE_TEACHER = 3;
  19. /**
  20. * Displays all announcements
  21. * @param int $visible VISIBLE_GUEST, VISIBLE_STUDENT or VISIBLE_TEACHER
  22. * @param int $id The identifier of the announcement to display
  23. */
  24. public static function display_announcements($visible, $id = -1)
  25. {
  26. $user_selected_language = api_get_interface_language();
  27. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  28. $tbl_announcement_group = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS_GROUPS);
  29. $usergroup = new UserGroup();
  30. $temp_user_groups = $usergroup->get_groups_by_user(api_get_user_id(),0);
  31. $groups =array();
  32. foreach ($temp_user_groups as $user_group) {
  33. $groups = array_merge($groups, array($user_group['id']));
  34. $groups = array_merge($groups, $usergroup->get_parent_groups($user_group['id']));
  35. }
  36. //checks if tables exists to not break platform not updated
  37. $ann_group_db_ok =false;
  38. if (Database::num_rows(Database::query("SHOW TABLES LIKE 'announcement_rel_group'")) > 0)
  39. $ann_group_db_ok =true;
  40. $groups_string = '('.implode($groups,',').')';
  41. $sql = "SELECT *, DATE_FORMAT(date_start,'%d-%m-%Y %h:%i:%s') AS display_date"
  42. ." FROM $db_table"
  43. ." WHERE (lang='$user_selected_language'"
  44. ." OR lang IS NULL)"
  45. ." AND ((NOW() BETWEEN date_start AND date_end) OR date_end='0000-00-00') ";
  46. switch ($visible) {
  47. case self::VISIBLE_GUEST :
  48. $sql .= " AND visible_guest = 1 ";
  49. break;
  50. case self::VISIBLE_STUDENT :
  51. $sql .= " AND visible_student = 1 ";
  52. break;
  53. case self::VISIBLE_TEACHER :
  54. $sql .= " AND visible_teacher = 1 ";
  55. break;
  56. }
  57. if (count($groups) > 0 and $ann_group_db_ok ) {
  58. $sql .= " OR id IN (SELECT announcement_id FROM $tbl_announcement_group "
  59. ." WHERE group_id in $groups_string) ";
  60. }
  61. global $_configuration;
  62. $current_access_url_id = 1;
  63. if ($_configuration['multiple_access_urls']) {
  64. $current_access_url_id = api_get_current_access_url_id();
  65. }
  66. $sql .= " AND access_url_id = '$current_access_url_id' ";
  67. $sql .= " ORDER BY date_start DESC LIMIT 0,7";
  68. $newsPath = api_get_path(WEB_PUBLIC_PATH).'news';
  69. $announcements = Database::query($sql);
  70. if (Database::num_rows($announcements) > 0) {
  71. $query_string = ereg_replace('announcement=[1-9]+', '', $_SERVER['QUERY_STRING']);
  72. $query_string = ereg_replace('&$', '', $query_string);
  73. $url = api_get_self();
  74. echo '<div class="system_announcements">';
  75. echo '<h3>'.get_lang('SystemAnnouncements').'</h3>';
  76. echo '<div style="margin:10px;text-align:right;"><a href="'.$newsPath.'">'.get_lang('More').'</a></div>';
  77. while ($announcement = Database::fetch_object($announcements)) {
  78. if ($id != $announcement->id) {
  79. if (strlen($query_string) > 0) {
  80. $show_url = $newsPath.'#'.$announcement->id;
  81. } else {
  82. $show_url = $newsPath.'#'.$announcement->id;
  83. }
  84. $display_date = api_convert_and_format_date($announcement->display_date, DATE_FORMAT_LONG);
  85. echo '<a name="'.$announcement->id.'"></a>
  86. <div class="system_announcement">
  87. <div class="system_announcement_title"><a name="ann'.$announcement->id.'" href="'.$show_url.'">'.$announcement->title.'</a></div><div class="system_announcement_date">'.$display_date.'</div>
  88. </div>';
  89. } else {
  90. echo '<div class="system_announcement">
  91. <div class="system_announcement_title">'
  92. .$announcement->display_date.'
  93. <a name="ann'.$announcement->id.'" href="'.$url.'?'.$query_string.'#ann'.$announcement->id.'">'.$announcement->title.'</a>
  94. </div>';
  95. }
  96. echo '<br />';
  97. }
  98. echo '</div>';
  99. }
  100. return;
  101. }
  102. /**
  103. * @param $visible
  104. * @param $id
  105. * @param int $start
  106. * @param string $user_id
  107. * @return string
  108. */
  109. public static function display_all_announcements($visible, $id = -1, $start = 0,$user_id='')
  110. {
  111. $user_selected_language = api_get_interface_language();
  112. $start = intval($start);
  113. $usergroup = new UserGroup();
  114. $tbl_announcement_group = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS_GROUPS);
  115. $temp_user_groups = $usergroup->get_groups_by_user(api_get_user_id(),0);
  116. $groups =array();
  117. foreach ($temp_user_groups as $user_group) {
  118. $groups = array_merge($groups, array($user_group['id']));
  119. $groups = array_merge($groups, $usergroup->get_parent_groups($user_group['id']));
  120. }
  121. //checks if tables exists to not break platform not updated
  122. $ann_group_db_ok =false;
  123. if( Database::num_rows(Database::query("SHOW TABLES LIKE 'announcement_rel_group'")) > 0)
  124. $ann_group_db_ok =true;
  125. $groups_string = '('.implode($groups,',').')';
  126. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  127. $now = api_get_utc_datetime();
  128. $sql = "SELECT * FROM ".$db_table."
  129. WHERE ( lang = '$user_selected_language' OR lang IS NULL) AND ( '$now' >= date_start AND '$now' <= date_end) ";
  130. switch ($visible) {
  131. case self::VISIBLE_GUEST :
  132. $sql .= " AND visible_guest = 1 ";
  133. break;
  134. case self::VISIBLE_STUDENT :
  135. $sql .= " AND visible_student = 1 ";
  136. break;
  137. case self::VISIBLE_TEACHER :
  138. $sql .= " AND visible_teacher = 1 ";
  139. break;
  140. }
  141. if (count($groups) > 0 and $ann_group_db_ok ) {
  142. $sql .= " OR id IN (
  143. SELECT announcement_id FROM $tbl_announcement_group
  144. WHERE group_id in $groups_string
  145. ) ";
  146. }
  147. if (api_is_multiple_url_enabled()) {
  148. $current_access_url_id = api_get_current_access_url_id();
  149. $sql .= " AND access_url_id IN ('1', '$current_access_url_id')";
  150. }
  151. if(!isset($_GET['start']) || $_GET['start'] == 0) {
  152. $sql .= " ORDER BY date_start DESC LIMIT ".$start.",20";
  153. } else {
  154. $sql .= " ORDER BY date_start DESC LIMIT ".($start+1).",20";
  155. }
  156. $announcements = Database::query($sql);
  157. $content = '';
  158. if (Database::num_rows($announcements) > 0) {
  159. $query_string = ereg_replace('announcement=[1-9]+', '', $_SERVER['QUERY_STRING']);
  160. $query_string = ereg_replace('&$', '', $query_string);
  161. $url = api_get_self();
  162. $content .= '<div class="system_announcements">';
  163. $content .= '<h3>'.get_lang('SystemAnnouncements').'</h3>';
  164. $content .= '<table align="center">';
  165. $content .= '<tr>';
  166. $content .= '<td>';
  167. $content .= SystemAnnouncementManager :: display_arrow($user_id);
  168. $content .= '</td>';
  169. $content .= '</tr>';
  170. $content .= '</table>';
  171. $content .= '<table align="center" border="0" width="900px">';
  172. while ($announcement = Database::fetch_object($announcements)) {
  173. $display_date = api_convert_and_format_date($announcement->display_date, DATE_FORMAT_LONG);
  174. $content .= '<tr><td>';
  175. $content .= '<a name="'.$announcement->id.'"></a>
  176. <div class="system_announcement">
  177. <h2>'.$announcement->title.'</h2><div class="system_announcement_date">'.$display_date.'</div>
  178. <br />
  179. <div class="system_announcement_content">'
  180. .$announcement->content.'
  181. </div>
  182. </div><br />';
  183. $content .= '</tr></td>';
  184. }
  185. $content .= '</table>';
  186. $content .= '<table align="center">';
  187. $content .= '<tr>';
  188. $content .= '<td>';
  189. $content .= SystemAnnouncementManager :: display_arrow($user_id);
  190. $content .= '</td>';
  191. $content .= '</tr>';
  192. $content .= '</table>';
  193. $content .= '</div>';
  194. }
  195. return $content;
  196. }
  197. /**
  198. * @param int $user_id
  199. * @return string
  200. */
  201. public static function display_arrow($user_id) {
  202. $start = (int)$_GET['start'];
  203. $nb_announcement = SystemAnnouncementManager :: count_nb_announcement($start,$user_id);
  204. $next = ((int)$_GET['start']+19);
  205. $prev = ((int)$_GET['start']-19);
  206. $content = '';
  207. $newsPath = api_get_path(WEB_PUBLIC_PATH).'news';
  208. if(!isset($_GET['start']) || $_GET['start'] == 0) {
  209. if($nb_announcement > 20) {
  210. $content .= '<a href="'.$newsPath.'?start='.$next.'">'.get_lang('NextBis').' >> </a>';
  211. }
  212. } else {
  213. echo '<a href="'.$newsPath.'?start='.$prev.'"> << '.get_lang('Prev').'</a>';
  214. if ($nb_announcement > 20) {
  215. $content .= '<a href="'.$newsPath.'?start='.$next.'">'.get_lang('NextBis').' >> </a>';
  216. }
  217. }
  218. return $content;
  219. }
  220. /**
  221. * @param int $start
  222. * @param string $user_id
  223. * @return int
  224. */
  225. public static function count_nb_announcement($start = 0, $user_id = '')
  226. {
  227. $start = intval($start);
  228. $visibility = api_is_allowed_to_create_course() ? self::VISIBLE_TEACHER : self::VISIBLE_STUDENT;
  229. $user_selected_language = api_get_interface_language();
  230. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  231. $sql = 'SELECT id FROM '.$db_table.' WHERE (lang="'.$user_selected_language.'" OR lang IS NULL) ';
  232. if (isset($user_id)) {
  233. switch ($visibility) {
  234. case self::VISIBLE_GUEST :
  235. $sql .= " AND visible_guest = 1 ";
  236. break;
  237. case self::VISIBLE_STUDENT :
  238. $sql .= " AND visible_student = 1 ";
  239. break;
  240. case self::VISIBLE_TEACHER :
  241. $sql .= " AND visible_teacher = 1 ";
  242. break;
  243. }
  244. }
  245. global $_configuration;
  246. $current_access_url_id = 1;
  247. if ($_configuration['multiple_access_urls']) {
  248. $current_access_url_id = api_get_current_access_url_id();
  249. }
  250. $sql .= " AND access_url_id = '$current_access_url_id' ";
  251. $sql .= 'LIMIT '.$start.',21';
  252. $announcements = Database::query($sql);
  253. $i = 0;
  254. while($rows = Database::fetch_array($announcements)) {
  255. $i++;
  256. }
  257. return $i;
  258. }
  259. /**
  260. * Get all announcements
  261. * @return array An array with all available system announcements (as php
  262. * objects)
  263. */
  264. public static function get_all_announcements()
  265. {
  266. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  267. $now = api_get_utc_datetime();
  268. $sql = "SELECT *, IF( '$now' >= date_start AND '$now' <= date_end, '1', '0') AS visible FROM $db_table";
  269. $current_access_url_id = 1;
  270. if (api_is_multiple_url_enabled()) {
  271. $current_access_url_id = api_get_current_access_url_id();
  272. }
  273. $sql .= " WHERE access_url_id = '$current_access_url_id' ";
  274. $sql .= " ORDER BY date_start ASC";
  275. $announcements = Database::query($sql);
  276. $all_announcements = array();
  277. while ($announcement = Database::fetch_object($announcements)) {
  278. $all_announcements[] = $announcement;
  279. }
  280. return $all_announcements;
  281. }
  282. /**
  283. * Adds an announcement to the database
  284. * @param string Title of the announcement
  285. * @param string Content of the announcement
  286. * @param string Start date (YYYY-MM-DD HH:II: SS)
  287. * @param string End date (YYYY-MM-DD HH:II: SS)
  288. * @param int Whether the announcement should be visible to teachers (1) or not (0)
  289. * @param int Whether the announcement should be visible to students (1) or not (0)
  290. * @param int Whether the announcement should be visible to anonymous users (1) or not (0)
  291. * @param string The language for which the announvement should be shown. Leave null for all langages
  292. * @param int Whether to send an e-mail to all users (1) or not (0)
  293. * @return mixed insert_id on success, false on failure
  294. */
  295. public static function add_announcement(
  296. $title,
  297. $content,
  298. $date_start,
  299. $date_end,
  300. $visible_teacher = 0,
  301. $visible_student = 0,
  302. $visible_guest = 0,
  303. $lang = null,
  304. $send_mail = 0,
  305. $add_to_calendar = false
  306. ) {
  307. $original_content = $content;
  308. $a_dateS = explode(' ',$date_start);
  309. $a_arraySD = explode('-',$a_dateS[0]);
  310. $a_arraySH = explode(':',$a_dateS[1]);
  311. $date_start_to_compare = array_merge($a_arraySD, $a_arraySH);
  312. $a_dateE = explode(' ',$date_end);
  313. $a_arrayED = explode('-',$a_dateE[0]);
  314. $a_arrayEH = explode(':',$a_dateE[1]);
  315. $date_end_to_compare = array_merge($a_arrayED,$a_arrayEH);
  316. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  317. if (!checkdate($date_start_to_compare[1], $date_start_to_compare[2], $date_start_to_compare[0])) {
  318. Display :: display_normal_message(get_lang('InvalidStartDate'));
  319. return false;
  320. }
  321. if (($date_end_to_compare[1] || $date_end_to_compare[2] || $date_end_to_compare[0]) && !checkdate($date_end_to_compare[1], $date_end_to_compare[2], $date_end_to_compare[0])) {
  322. Display :: display_normal_message(get_lang('InvalidEndDate'));
  323. return false;
  324. }
  325. if (strlen(trim($title)) == 0) {
  326. Display::display_normal_message(get_lang('InvalidTitle'));
  327. return false;
  328. }
  329. $start = api_get_utc_datetime($date_start);
  330. $end = api_get_utc_datetime($date_end);
  331. $title = Database::escape_string($title);
  332. $content = Database::escape_string($content);
  333. //Fixing urls that are sent by email
  334. $content = str_replace('src=\"/home/', 'src=\"'.api_get_path(WEB_PATH).'home/', $content);
  335. $content = str_replace('file=/home/', 'file='.api_get_path(WEB_PATH).'home/', $content);
  336. $langsql = is_null($lang) ? 'NULL' : "'".Database::escape_string($lang)."'";
  337. global $_configuration;
  338. $current_access_url_id = 1;
  339. if ($_configuration['multiple_access_urls']) {
  340. $current_access_url_id = api_get_current_access_url_id();
  341. }
  342. $sql = "INSERT INTO ".$db_table." (title,content,date_start,date_end,visible_teacher,visible_student,visible_guest, lang, access_url_id)
  343. VALUES ('".$title."','".$content."','".$start."','".$end."','".$visible_teacher."','".$visible_student."','".$visible_guest."',".$langsql.", ".$current_access_url_id.")";
  344. if ($send_mail==1) {
  345. SystemAnnouncementManager::send_system_announcement_by_email($title, $content,$visible_teacher, $visible_student, $lang);
  346. }
  347. $res = Database::query($sql);
  348. if ($res === false) {
  349. Debug::log_s(mysql_error());
  350. return false;
  351. }
  352. if ($add_to_calendar) {
  353. $agenda = new Agenda();
  354. $agenda->setType('admin');
  355. $agenda->add_event($date_start, $date_end, false, null, $title, $original_content);
  356. }
  357. return Database::insert_id();
  358. }
  359. /**
  360. * Makes the announcement id visible only for groups in groups_array
  361. * @param int announcement id
  362. * @param array array of group id
  363. **/
  364. public static function announcement_for_groups($announcement_id, $group_array)
  365. {
  366. $tbl_announcement_group = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS_GROUPS);
  367. //first delete all group associations for this announcement
  368. $res = Database::query("DELETE FROM $tbl_announcement_group WHERE announcement_id = ".intval($announcement_id));
  369. if ($res === false) {
  370. Debug::log_s(mysql_error());
  371. return false;
  372. }
  373. foreach ($group_array as $group_id) {
  374. if (intval($group_id) != 0 ) {
  375. $res = Database::query("INSERT INTO $tbl_announcement_group SET announcement_id=".intval($announcement_id)
  376. .", group_id=".intval($group_id));
  377. if ($res === false) {
  378. Debug::log_s(mysql_error());
  379. return false;
  380. }
  381. }
  382. }
  383. return true;
  384. }
  385. /**
  386. * Gets the groups of this announce
  387. * @param int announcement id
  388. * @return array array of group id
  389. **/
  390. public static function get_announcement_groups($announcement_id)
  391. {
  392. $tbl_announcement_group = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS_GROUPS);
  393. $tbl_group = Database :: get_main_table(TABLE_USERGROUP);
  394. //first delete all group associations for this announcement
  395. $res = Database::query("SELECT g.id as group_id, g.name as group_name
  396. FROM $tbl_group g , $tbl_announcement_group ag
  397. WHERE announcement_id = ".intval($announcement_id)." AND ag.group_id = g.id");
  398. $groups = Database::fetch_array($res);
  399. return $groups;
  400. }
  401. /**
  402. * Updates an announcement to the database
  403. * @param integer $id : id of the announcement
  404. * @param string $title : title of the announcement
  405. * @param string $content : content of the announcement
  406. * @param array $date_start: start date of announcement (0 => day ; 1 => month ; 2 => year ; 3 => hour ; 4 => minute)
  407. * @param array $date_end : end date of announcement (0 => day ; 1 => month ; 2 => year ; 3 => hour ; 4 => minute)
  408. * @return bool True on success, false on failure
  409. */
  410. public static function update_announcement($id, $title, $content, $date_start, $date_end, $visible_teacher = 0, $visible_student = 0, $visible_guest = 0,$lang=null, $send_mail=0) {
  411. $a_dateS = explode(' ',$date_start);
  412. $a_arraySD = explode('-',$a_dateS[0]);
  413. $a_arraySH = explode(':',$a_dateS[1]);
  414. $date_start_to_compare = array_merge($a_arraySD,$a_arraySH);
  415. $a_dateE = explode(' ',$date_end);
  416. $a_arrayED = explode('-',$a_dateE[0]);
  417. $a_arrayEH = explode(':',$a_dateE[1]);
  418. $date_end_to_compare = array_merge($a_arrayED,$a_arrayEH);
  419. $langsql = is_null($lang) ? 'NULL' : "'".Database::escape_string($lang)."'";
  420. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  421. if (!checkdate($date_start_to_compare[1], $date_start_to_compare[2], $date_start_to_compare[0])) {
  422. Display :: display_normal_message(get_lang('InvalidStartDate'));
  423. return false;
  424. }
  425. if (($date_end_to_compare[1] || $date_end_to_compare[2] || $date_end_to_compare[0]) && !checkdate($date_end_to_compare[1], $date_end_to_compare[2], $date_end_to_compare[0])) {
  426. Display :: display_normal_message(get_lang('InvalidEndDate'));
  427. return false;
  428. }
  429. if( strlen(trim($title)) == 0) {
  430. Display::display_normal_message(get_lang('InvalidTitle'));
  431. return false;
  432. }
  433. $start = api_get_utc_datetime($date_start);
  434. $end = api_get_utc_datetime($date_end);
  435. $title = Database::escape_string($title);
  436. $content = Database::escape_string($content);
  437. //Fixing urls that are sent by email
  438. $content = str_replace('src=\"/home/', 'src=\"'.api_get_path(WEB_PATH).'home/', $content);
  439. $content = str_replace('file=/home/', 'file='.api_get_path(WEB_PATH).'home/', $content);
  440. $id = intval($id);
  441. $sql = "UPDATE ".$db_table." SET lang=$langsql,title='".$title."',content='".$content."',date_start='".$start."',date_end='".$end."', ";
  442. $sql .= " visible_teacher = '".$visible_teacher."', visible_student = '".$visible_student."', visible_guest = '".$visible_guest."' , access_url_id = '".api_get_current_access_url_id()."' WHERE id = ".$id;
  443. if ($send_mail==1) {
  444. SystemAnnouncementManager::send_system_announcement_by_email($title, $content,$visible_teacher, $visible_student, $lang);
  445. }
  446. $res = Database::query($sql);
  447. if ($res === false) {
  448. Debug::log_s(mysql_error());
  449. return false;
  450. }
  451. return true;
  452. }
  453. /**
  454. * Deletes an announcement
  455. * @param int $id The identifier of the announcement that should be
  456. * @return bool True on success, false on failure
  457. */
  458. public static function delete_announcement($id)
  459. {
  460. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  461. $id = intval($id);
  462. $sql = "DELETE FROM ".$db_table." WHERE id =".$id;
  463. $res = Database::query($sql);
  464. if ($res === false) {
  465. Debug::log_s(mysql_error());
  466. return false;
  467. }
  468. return true;
  469. }
  470. /**
  471. * Gets an announcement
  472. * @param int $id The identifier of the announcement that should be
  473. * @return object Object of class StdClass or the required class, containing the query result row
  474. */
  475. public static function get_announcement($id) {
  476. $db_table = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  477. $id = intval($id);
  478. $sql = "SELECT * FROM ".$db_table." WHERE id = ".$id;
  479. $announcement = Database::fetch_object(Database::query($sql));
  480. return $announcement;
  481. }
  482. /**
  483. * Change the visibility of an announcement
  484. * @param int $announcement_id
  485. * @param int $user For who should the visibility be changed (possible values are VISIBLE_TEACHER, VISIBLE_STUDENT, VISIBLE_GUEST)
  486. * @return bool True on success, false on failure
  487. */
  488. public static function set_visibility($announcement_id, $user, $visible)
  489. {
  490. $db_table = Database::get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  491. $visible = intval($visible);
  492. $announcement_id = intval($announcement_id);
  493. if (!in_array($user, array(self::VISIBLE_GUEST, self::VISIBLE_STUDENT, self::VISIBLE_TEACHER))) {
  494. return false;
  495. }
  496. $field = ($user == self::VISIBLE_TEACHER ? 'visible_teacher' : ($user == self::VISIBLE_STUDENT ? 'visible_student' : 'visible_guest'));
  497. $sql = "UPDATE ".$db_table." SET ".$field." = '".$visible."' WHERE id='".$announcement_id."'";
  498. $res = Database::query($sql);
  499. if ($res === false) {
  500. Debug::log_s(mysql_error());
  501. return false;
  502. }
  503. return true;
  504. }
  505. /**
  506. * Send a system announcement by e-mail to all teachers/students depending on parameters
  507. * @param string Title
  508. * @param string Content
  509. * @param int Whether to send to all teachers (1) or not (0)
  510. * @param int Whether to send to all students (1) or not (0)
  511. * @param string Language (optional, considered for all languages if left empty)
  512. * @return bool True if the message was sent or there was no destination matching. False on database or e-mail sending error.
  513. */
  514. public static function send_system_announcement_by_email($title, $content, $teacher, $student, $language = null)
  515. {
  516. global $charset;
  517. if (api_is_multiple_url_enabled()) {
  518. $current_access_url_id = api_get_current_access_url_id();
  519. $url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
  520. $url_condition = " INNER JOIN $url_rel_user uu ON uu.user_id = u.user_id ";
  521. }
  522. $user_table = Database :: get_main_table(TABLE_MAIN_USER);
  523. if ($teacher <> 0 AND $student == 0) {
  524. $sql = "SELECT DISTINCT u.user_id FROM $user_table u $url_condition WHERE status = '1' ";
  525. }
  526. if ($teacher == 0 AND $student <> 0) {
  527. $sql = "SELECT DISTINCT u.user_id FROM $user_table u $url_condition WHERE status = '5' ";
  528. }
  529. if ($teacher<> 0 AND $student <> 0) {
  530. $sql = "SELECT DISTINCT u.user_id FROM $user_table u $url_condition WHERE 1 = 1 ";
  531. }
  532. if (!empty($language)) { //special condition because language was already treated for SQL insert before
  533. $sql .= " AND language = '".Database::escape_string($language)."' ";
  534. }
  535. if (api_is_multiple_url_enabled()) {
  536. $sql .= " AND access_url_id = '".$current_access_url_id."' ";
  537. }
  538. //Sent to active users
  539. $sql .= " AND email <>'' AND active = 1 ";
  540. if ((empty($teacher) or $teacher == '0') AND (empty($student) or $student == '0')) {
  541. return true;
  542. }
  543. $result = Database::query($sql);
  544. if ($result === false) {
  545. return false;
  546. }
  547. $title = api_html_entity_decode(stripslashes($title), ENT_QUOTES, $charset);
  548. $content = api_html_entity_decode(stripslashes(str_replace(array('\r\n', '\n', '\r'),'', $content)), ENT_QUOTES, $charset);
  549. $message_sent = false;
  550. while ($row = Database::fetch_array($result,'ASSOC')) {
  551. MessageManager::send_message_simple($row['user_id'], $title, $content);
  552. $message_sent = true;
  553. }
  554. return $message_sent; //true if at least one e-mail was sent
  555. }
  556. /**
  557. * @param $visible
  558. * @param null $id
  559. * @param string $type
  560. * @param bool $getCount
  561. * @param int $cutSize
  562. * @return string
  563. */
  564. public static function getAnnouncements($visible, $id = null, $type = 'resumed', $getCount = false, $cutSize = 800)
  565. {
  566. $user_selected_language = Database::escape_string(api_get_interface_language());
  567. $table = Database::get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS);
  568. $now = api_get_utc_datetime();
  569. $select = '*';
  570. if ($getCount) {
  571. $select = 'count(*) as count';
  572. }
  573. $sql = "SELECT $select
  574. FROM $table
  575. WHERE
  576. ( lang = '$user_selected_language' OR lang IS NULL) AND
  577. ( '$now' >= date_start AND '$now' <= date_end) ";
  578. switch ($visible) {
  579. case self::VISIBLE_GUEST :
  580. $sql .= " AND visible_guest = 1 ";
  581. break;
  582. case self::VISIBLE_STUDENT :
  583. $sql .= " AND visible_student = 1 ";
  584. break;
  585. case self::VISIBLE_TEACHER :
  586. $sql .= " AND visible_teacher = 1 ";
  587. break;
  588. }
  589. if (isset($id) && !empty($id)) {
  590. $id = intval($id);
  591. $sql .= " AND id = $id ";
  592. }
  593. if (api_is_multiple_url_enabled()) {
  594. $current_url_id = api_get_current_access_url_id();
  595. $sql .= " AND access_url_id IN ('1', '$current_url_id') ";
  596. }
  597. $sql .= " ORDER BY date_start DESC";
  598. $announcements = Database::query($sql);
  599. if ($getCount) {
  600. $announcement = Database::fetch_array($announcements);
  601. return $announcement['count'];
  602. }
  603. $options = array();
  604. if (Database::num_rows($announcements) > 0) {
  605. while ($announcement = Database::fetch_object($announcements)) {
  606. $content = $announcement->content;
  607. $url = api_get_path(WEB_PUBLIC_PATH).'news/'.$announcement->id;
  608. if (empty($id)) {
  609. if ($type == 'resumed') {
  610. if (api_strlen(strip_tags($content)) > $cutSize) {
  611. $content = Security::remove_XSS(Text::cut($announcement->content, $cutSize)).
  612. ' '.Display::url(get_lang('More'), $url);
  613. }
  614. } else {
  615. $content = $announcement->content;
  616. }
  617. }
  618. $announcement->title = Text::cut($announcement->title, $cutSize);
  619. $options[]= array(
  620. 'title' => $announcement->title,
  621. 'content' => $content,
  622. );
  623. }
  624. }
  625. return $options;
  626. }
  627. /**
  628. * Displays announcements as an slideshow
  629. * @param int $visible VISIBLE_GUEST, VISIBLE_STUDENT or VISIBLE_TEACHER
  630. * @param int $id The identifier of the announcement to display
  631. * @return string
  632. */
  633. public static function display_announcements_slider($visible, $id = null)
  634. {
  635. $announcements = self::getAnnouncements($visible, $id, 'resumed');
  636. $html = null;
  637. if (!empty($announcements)) {
  638. $html .= Display::page_header(get_lang('SystemAnnouncements'));
  639. $html .= Display::getSlider('portal_news', $announcements);
  640. }
  641. return $html;
  642. }
  643. /**
  644. * Displays announcements as an slideshow
  645. * @param int $visible VISIBLE_GUEST, VISIBLE_STUDENT or VISIBLE_TEACHER
  646. * @param int $id The identifier of the announcement to display
  647. * @param string $type
  648. * @return string
  649. */
  650. public static function displayAnnouncementsList($visible, $id = null, $type = 'resumed')
  651. {
  652. $announcements = self::getAnnouncements($visible, $id, $type);
  653. $html = null;
  654. if (!empty($announcements)) {
  655. $html .= Display::page_header(get_lang('SystemAnnouncements'));
  656. foreach($announcements as $announcement) {
  657. $html .= Display::page_subheader2($announcement['title']);
  658. $html .= "<p> ".$announcement['content']."</p>";
  659. }
  660. }
  661. return $html;
  662. }
  663. }