system_announcements.lib.php 28 KB

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