system_announcements.lib.php 25 KB

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