Source for file announcements.php

 

 

 

 

 

$language_file[] = 'announcements';

$language_file[] = 'group';

$language_file[] = 'survey';

 

$use_anonymous = true;

 

$this_section=SECTION_COURSES;

 

$nameTools = get_lang('Announcement');

 

 

if(isset($_GET['id_session']))

    $_SESSION['id_session'] = $_GET['id_session'];

 

 

$display_announcement_list = true;

$display_form             = false;

$display_title_list          = true;

 

$maximum     = '12';

 

$length     = '36';

 

$tbl_course_user           = Database::get_main_table(TABLE_MAIN_COURSE_USER);

$tbl_user                  = Database::get_main_table(TABLE_MAIN_USER);

$tbl_courses            = Database::get_main_table(TABLE_MAIN_COURSE);

$tbl_sessions            = Database::get_main_table(TABLE_MAIN_SESSION);

$tbl_session_course_user= Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

$tbl_group                 = Database::get_course_table(TABLE_GROUP);

$tbl_groupUser          = Database::get_course_table(TABLE_GROUP_USER);

$tbl_announcement        = Database::get_course_table(TABLE_ANNOUNCEMENT);

$tbl_item_property      = Database::get_course_table(TABLE_ITEM_PROPERTY);

 

$_SESSION['source_type']="Ad_Valvas";

 

    include('announcements.inc.php');

 

    $form_elements= array ('emailTitle'=>stripslashes($emailTitle), 'newContent'=>stripslashes($newContent), 'id'=>$id, 'to'=>$selectedform, 'emailoption'=>$email_ann);

    $_SESSION['formelements']=$form_elements;

 

    if($id) // this is to correctly handle edits

    {

          $action="edit";

    }else

    {

          $action="add";

    }

 

    // ============== //

    // 7 = Ad_Valvas    //

    // ============== //

    if($surveyid)

    {

        header("Location: ../resourcelinker/resourcelinker.php?source_id=7&action=$action&id=$id&originalresource=no&publish_survey=$surveyid&db_name=$db_name&cidReq=$cidReq");

        exit;

    }

    else

    {

        header("Location: ../resourcelinker/resourcelinker.php?source_id=7&action=$action&id=$id&originalresource=no");

        exit;

    }

    exit;

 

include(api_get_path(LIBRARY_PATH).'events.lib.inc.php');

 

require_once(api_get_path(LIBRARY_PATH).'groupmanager.lib.php');

require_once(api_get_path(INCLUDE_PATH).'lib/mail.lib.inc.php');

require_once(api_get_path(INCLUDE_PATH).'conf/mail.conf.php');

require_once(api_get_path(LIBRARY_PATH).'debug.lib.inc.php');

require_once(api_get_path(LIBRARY_PATH).'tracking.lib.php');

 

    $display_form = true;

 

    $form_elements= array ('emailTitle'=>$_POST['emailTitle'], 'newContent'=>$_POST['newContent'], 'id'=>$_POST['id'], 'emailoption'=>$_POST['email_ann']);

    $_SESSION['formelements']=$form_elements;

 

    $form_elements                = $_SESSION['formelements'];

 

    $title_to_modify            = $form_elements["emailTitle"];

 

    $content_to_modify          = $form_elements["newContent"];

 

    $announcement_to_modify     = $form_elements["id"];

 

 

$setting_select_groupusers=true;

    $_SESSION['select_groupusers']="hide";

$select_groupusers_status=$_SESSION['select_groupusers'];

if (!empty($_POST['To']) and ($select_groupusers_status=="hide"))

    $_SESSION['select_groupusers']="show";

if (!empty($_POST['To']) and ($select_groupusers_status=="show"))

    $_SESSION['select_groupusers']="hide";

 

 

if (((!empty($_GET['action']) && $_GET['action'] == 'add') && $_GET['origin'] == "") || (!empty($_GET['action']) && $_GET['action'] == 'edit') || !empty($_POST['To']))

    $display_form = true;

 

if ((empty($originalresource) || ($originalresource!=='no')) and (!empty($action) && $action=='add'))

    $_SESSION['formelements']=null;

    //unset($_SESSION['formelements']);

    unset_session_resources();

 

 

$htmlHeadXtra[] = to_javascript();

 

 

    if($_GET['toolgroup'] == strval(intval($_GET['toolgroup']))){ //check is integer

        $toolgroup = $_GET['toolgroup'];

        $_SESSION['select_groupusers'] = 'hide';

    }else{

        $toolgroup = 0;

    }

    api_session_register("toolgroup");

 

 

if (!empty($_SESSION['formelements']) and !empty($_GET['originalresource']) and $_GET['originalresource'] == 'no')

    $form_elements            = $_SESSION['formelements'];

    $title_to_modify        = $form_elements['emailTitle'];

    $content_to_modify        = $form_elements['newContent'];

    $announcement_to_modify    = $form_elements['id'];

    $to                        = $form_elements['to'];

    //load_edit_users('announcement',$announcement_to_modify);

 

    $email_ann                = $form_elements['emailoption'];

    $to[] = 'USER:'.intval($_GET['remind_inactive']);

$surveyid = 0;

    $surveyid=Database::escape_string($_REQUEST['publish_survey']);

$cidReq=Database::escape_string($_REQUEST['cidReq']);

    $db_name=Database::escape_string($_REQUEST['db_name']);

    $sql_temp = "SELECT * FROM $db_name.survey WHERE survey_id='$surveyid'";

    $res_temp = api_sql_query($sql_temp, __FILE__, __LINE__);

    $obj=@Database::fetch_object($res_temp);

    $template=$obj->template;

    $interbreadcrumb[] = array ("url" => "../survey/survey_list.php?cidReq=$cidReq", "name" => get_lang('Survey'));

    $nameTools = get_lang('PublishSurvey');

$nameTools = get_lang('Announcement');

 

$nameTools12 = get_lang('PublishSurvey');

 

 

 

if (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath')

    //we are not in the learning path

    Display::Display_header($nameTools,"Announcements");

    //we are in the learning path, only display central data and change css

    $display_title_list = false;

    $display_announcement_list = false;

    $display_specific_announcement = true;

    $announcement_id = $_REQUEST['ann_id'];

    ?> <link rel="stylesheet" type="text/css" href="<?php echo $clarolineRepositoryWeb ?>css/default.css">

    <!-- css file for announcements -->

    <link href="../css/announcements.css" rel="stylesheet" type="text/css">

    <?php

 

echo "<a name=\"top\"></a>";

 

 

if (api_is_allowed_to_edit() OR (api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous()))

    /*

    // $_GET['isStudentView']<>"false" is added to prevent that the visibility

    // is changed after you do the following:

    // change visibility -> studentview -> course manager view

    if (isset($_GET['isStudentView']) && $_GET['isStudentView']!='false')

    {

        if (isset($_GET['id']) AND $_GET['id'] AND isset($_GET['action']) AND $_GET['action']=="showhide")

        {

            $id=intval(addslashes($_GET['id']));

            change_visibility(TOOL_ANNOUNCEMENT,$id);

            $message = get_lang("Visible");

        }

    }

 

    /*

    if (!empty($_GET['action']) AND $_GET['action']=='delete' AND isset($_GET['id']))

    {

        //api_sql_query("DELETE FROM  $tbl_announcement WHERE id='$delete'",__FILE__,__LINE__);

        $id=intval(addslashes($_GET['id']));

 

        // tooledit : visibility = 2 : only visibile for platform administrator

        api_sql_query("UPDATE $tbl_item_property SET visibility='2' WHERE tool='".TOOL_ANNOUNCEMENT."' and ref='".$id."'",__FILE__,__LINE__);

 

        delete_added_resource("Ad_Valvas", $delete);

 

        $id = null;

        $emailTitle = null;

        $newContent = null;

 

        $message = get_lang("AnnouncementDeleted");

    }

 

    /*

    if (!empty($_GET['action']) and $_GET['action']=='delete_all')

    {

 

        //api_sql_query("DELETE FROM $tbl_announcement",__FILE__,__LINE__);

 

        api_sql_query("UPDATE $tbl_item_property SET visibility='2' WHERE tool='".TOOL_ANNOUNCEMENT."'",__FILE__,__LINE__);

 

        delete_all_resources_type("Ad_Valvas");

 

        $id = null;

        $emailTitle = null;

        $newContent = null;

 

        $message = get_lang("AnnouncementDeletedAll");

    }

 

    /*

    if (!empty($_GET['action']) and $_GET['action']=='modify' AND isset($_GET['id']))

    {

        $display_form = true;

 

        // RETRIEVE THE CONTENT OF THE ANNOUNCEMENT TO MODIFY

        $id = intval(addslashes($_GET['id']));

        $sql="SELECT * FROM  $tbl_announcement WHERE id='$id'";

        $result = api_sql_query($sql,__FILE__,__LINE__);

        $myrow = Database::fetch_array($result);

 

        if ($myrow)

        {

            $announcement_to_modify     = $myrow['id'];

            $content_to_modify         = $myrow['content'];

 

            $title_to_modify             = $myrow['title'];

 

            if ($originalresource!=="no") // and !addresources)

            {

                //unset_session_resources();

                edit_added_resources("Ad_Valvas", $announcement_to_modify);

                $to=load_edit_users("announcement", $announcement_to_modify);

            }

 

            $display_announcement_list = false;

        }

 

        if ($to=="everyone" OR !empty($_SESSION['toolgroup']))

        {

            $_SESSION['select_groupusers']="hide";

        }

        else

        {

            $_SESSION['select_groupusers']="show";

        }

 

    }

 

    /*

    if (!empty($_GET['down']))

    {

        $thisAnnouncementId = intval($_GET['down']);

        $sortDirection = "DESC";

    }

 

    if (!empty($_GET['up']))

    {

        $thisAnnouncementId = intval($_GET['up']);

        $sortDirection = "ASC";

    }

 

    if (!empty($sortDirection))

    {

        if (!in_array(trim(strtoupper($sortDirection)), array('ASC', 'DESC')))

        {

            $sortDirection='ASC';

        }

        $my_sql = "SELECT announcement.id, announcement.display_order " .

                "FROM $tbl_announcement announcement, " .

                "$tbl_item_property itemproperty " .

                "WHERE itemproperty.ref=announcement.id " .

                "AND itemproperty.tool='".TOOL_ANNOUNCEMENT."' " .

                "AND itemproperty.visibility<>2 " .

                "ORDER BY display_order $sortDirection";

        $result = api_sql_query($my_sql,__FILE__,__LINE__);

 

        while (list ($announcementId, $announcementOrder) = Database::fetch_row($result))

        {

            // STEP 2 : FOUND THE NEXT ANNOUNCEMENT ID AND ORDER.

            //          COMMIT ORDER SWAP ON THE DB

 

            if (isset ($thisAnnouncementOrderFound) && $thisAnnouncementOrderFound == true)

            {

                $nextAnnouncementId = $announcementId;

                $nextAnnouncementOrder = $announcementOrder;

                api_sql_query("UPDATE $tbl_announcement " .

                        "SET display_order = '$nextAnnouncementOrder' " .

                        "WHERE id =  '$thisAnnouncementId'",__FILE__,__LINE__);

                api_sql_query("UPDATE $tbl_announcement " .

                        "SET display_order = '$thisAnnouncementOrder' " .

                        "WHERE id =  '$nextAnnouncementId.'",__FILE__,__LINE__);

 

                break;

            }

 

            // STEP 1 : FIND THE ORDER OF THE ANNOUNCEMENT

 

            if ($announcementId == $thisAnnouncementId)

            {

                $thisAnnouncementOrder = $announcementOrder;

                $thisAnnouncementOrderFound = true;

            }

        }

        // show message

        $message = get_lang('AnnouncementMoved');

    }

 

    /*

    if (api_is_allowed_to_edit() OR (api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous()))

    {

 

        $emailTitle=(!empty($_POST['emailTitle'])?$_POST['emailTitle']:'');

        $newContent=(!empty($_POST['newContent'])?$_POST['newContent']:'');

        $submitAnnouncement=isset($_POST['submitAnnouncement'])?$_POST['submitAnnouncement']:0;

 

        $id = 0;

        if(!empty($_POST['id']))

        {

            $id=intval($_POST['id']);

        }

 

        if ($submitAnnouncement)

        {

            

            if(isset($id)&&$id) // there is an Id => the announcement already exists => update mode

            {

                $edit_id = edit_advalvas_item($id,$emailTitle,$newContent,$_POST['selectedform']);

                if(!$delete)

                {

                    update_added_resources("Ad_Valvas", $id);

                }

                $message = get_lang('AnnouncementModified');

            }

            else //insert mode

            {

                if(!$surveyid){

                    $result = api_sql_query("SELECT MAX(display_order) FROM $tbl_announcement",__FILE__,__LINE__);

    

                    list($orderMax) = Database::fetch_row($result);

                    $order = $orderMax + 1;

                    if(!empty($_SESSION['toolgroup'])){

                        //$insert_id=store_advalvas_item($_POST['emailTitle'],$_POST['newContent'],$order,array('GROUP:'.$_SESSION['toolgroup']));

                        $insert_id=store_advalvas_group_item($_POST['emailTitle'],$_POST['newContent'],$order,array('GROUP:'.$_SESSION['toolgroup']),$_POST['selectedform']);

                    }else{

                        $insert_id=store_advalvas_item($_POST['emailTitle'],$_POST['newContent'],$order,$_POST['selectedform']);

                    }

    

                    store_resources($_SESSION['source_type'],$insert_id);

    

                    $_SESSION['select_groupusers']="hide";

    

                    $message = get_lang('AnnouncementAdded');

                }

 

 

 

     $to_email_address =$_POST['emailsAdd'];

     $to_email_to = explode(',', $to_email_address);

     $to_email = array_unique($to_email_to);

     $db_name = $_REQUEST['db_name'];

    for($i=0;$i<count($to_email);$i++)

   {

 

            $to= trim($to_email[$i]);

            $db_name = $_REQUEST['db_name'];

            $newContentone=str_replace("#page#","choose_language.php",$newContent);

            $newContenttwo=str_replace("#temp#",$template,$newContentone);

            $newContentthree=str_replace("#sid#",$surveyid,$newContenttwo);

            $newContentfour=str_replace("#mail#",$to,$newContentthree);

            $newContentfive=str_replace("#db_name#",$db_name,$newContentfour);

            $newContentsix=str_replace("#uid#","",$newContentfive);

 

     $subject=stripslashes($emailTitle);

     $message=stripslashes($newContentsix);

 

    $sender_name = $_SESSION['_user']['lastName'].' '.$_SESSION['_user']['firstName'];

    $email = $_SESSION['_user']['mail'];

    $headers="From:$sender_name\r\nReply-to: $email\r\nContent-type: text/html; charset=iso-8859-15";

    //@mail($to,$subject,$message,$headers);

    //api_send_mail($to,$subject,$message,$headers);

    api_mail('',$to,$subject,$message,$sender_name,$email,$headers);

    $sql_date="SELECT * FROM $db_name.survey WHERE survey_id='$surveyid'";

    $res_date=api_sql_query($sql_date, __FILE__, __LINE__);

    $obj_date=Database::fetch_object($res_date);

    $end_date=$obj_date->avail_till;

    $table_reminder = Database :: get_main_table(TABLE_MAIN_SURVEY_REMINDER);

    if($_REQUEST['reminder']=="1")

    {

        $time=getdate();

        $time = $time['yday'];

        $time = $time+7;

        $sql_insert="INSERT INTO $table_reminder(sid,db_name,email,subject,content,reminder_choice,reminder_time,avail_till) values('$surveyid','$db_name','$to','".addslashes($subject)."','".addslashes($message)."','1','$time','$end_date')";

        api_sql_query($sql_insert, __FILE__, __LINE__);

    }

    else if($_REQUEST['reminder']=="2")

    {

        $time=getdate();

        $time = $time['yday'];

        $time = $time+14;

        $sql_insert="INSERT INTO $table_reminder(sid,db_name,email,subject,content,reminder_choice,reminder_time,avail_till) values('$surveyid','$db_name','$to','".addslashes($subject)."','".addslashes($message)."','1','$time','$end_date')";

        api_sql_query($sql_insert, __FILE__, __LINE__);

    }

    else if($_REQUEST['reminder']=="3")

    {

        $time=getdate();

        $time = $time['yday'];

        $time = $time+30;

        $sql_insert="INSERT INTO $table_reminder(sid,db_name,email,subject,content,reminder_choice,reminder_time,avail_till) values('$surveyid','$db_name','$to','".addslashes($subject)."','".addslashes($message)."','1','$time','$end_date')";

        api_sql_query($sql_insert, __FILE__, __LINE__);

    }

  }

 }

 

                /*===================================================================

 

                if ($_POST['email_ann'] && empty($_POST['onlyThoseMails']))

                {

                    

                      $sent_to=sent_to("announcement", $insert_id);

                    

                    $userlist   = $sent_to['users'];

                    $grouplist  = $sent_to['groups'];

 

                        // groepen omzetten in users

                        if ($grouplist)

                        {

 

                            $grouplist = "'".implode("', '",$grouplist)."'";    //protect individual elements with surrounding quotes

                            $sql = "SELECT user_id

                                    WHERE gu.group_id IN (".$grouplist.")";

 

 

                            $groupMemberResult = api_sql_query($sql,__FILE__,__LINE__);

 

 

                            if ($groupMemberResult)

                            {

                                while ($u = Database::fetch_array($groupMemberResult))

                                {

                                    $userlist [] = $u ['user_id']; // complete the user id list ...

                                }

                            }

                        }

 

 

                        if(is_array($userlist))

                        {

                            $userlist = "'".implode("', '", array_unique($userlist) )."'";

 

                            // send to the created 'userlist'

                            $sqlmail = "SELECT user_id, lastname, firstname, email

                                                        WHERE user_id IN (".$userlist.")";

                        }

                        else if(empty($_POST['not_selected_form']))

                        {

                            if(empty($_SESSION['id_session']) || api_get_setting('use_session_mode')=='false')

                            {

                                // send to everybody

                                $sqlmail = "SELECT user.user_id, user.email, user.lastname, user.firstname

                                             WHERE course_code='".Database::escape_string($_course['sysCode'])."'

                            }

                            else

                            {

                                $sqlmail = "SELECT user.user_id, user.email, user.lastname, user.firstname

                                                AND $tbl_session_course_user.course_code = '".$_course['id']."'

                                                AND $tbl_session_course_user.id_session = ".intval($_SESSION['id_session']);

                                

                            }

                        }

 

                        if($sqlmail!='')

                        {

                            $result = api_sql_query($sqlmail,__FILE__,__LINE__);

 

                            /*=================================================================================

 

 

                            while ($myrow = Database::fetch_array($result))

                            {

                                /*    Header : Bericht van uw lesgever - GES ($_cid)

 

 

 

 

                                $emailsubjbericht = api_is_allowed_to_edit() ? get_lang('professorMessage') : get_lang('LearnerMessage');

                                $emailSubject = $emailsubjbericht. " - ".$_course['official_code'];

                                $emailSubject = $emailTitle;

 

                                $db_name = Database::get_course_table(TABLE_MAIN_SURVEY);

 

                                if($surveyid)

                                {

                                    $newContentone=str_replace("#page#","choose_language.php",$newContent);

                                    $newContenttwo=str_replace("#temp#",$template,$newContentone);

                                    $newContentthree=str_replace("#sid#",$surveyid,$newContenttwo);

                                    $newContentfour=str_replace("#mail#",$myrow["email"],$newContentthree);

                                    $newContentfive=str_replace("#db_name#",$db_name,$newContentfour);

                                    $newContentsix=str_replace("#uid#",$myrow["user_id"],$newContentfive);

                                    $message=stripslashes($newContentsix);

 

                                    $sender_name = $_SESSION['_user']['lastName'].' '.$_SESSION['_user']['firstName'];

                                    $email = $_SESSION['_user']['mail'];

 

 

                                    $headers="From:$sender_name\r\nReply-to: $email\r\nContent-type: text/html; charset=iso-8859-15";

                                    //@mail($myrow["email"],stripslashes($emailTitle),$message,$headers);

                                    api_mail('',$myrow["email"],stripslashes($emailTitle),$message,$sender_name,$email);

                                }

                                else

                                {

                                    $mail_body = $myrow["lastname"]." ".$myrow["firstname"]." <".$myrow["email"]."><br /> \n\n".stripslashes($emailTitle)."<br />".trim(stripslashes($newContent))." <br /><br />-- <br />";

                                    $mail_body .= $_user['firstName'].' '.$_user['lastName']." ";

                                    $mail_body .= "<".$_user['mail'].">\n";

                                    $mail_body .= $_course['official_code'].' '.$_course['name'];

 

                                    //set the charset and use it for the encoding of the email - small fix, not really clean (should check the content encoding origin first)

                                    //here we use the encoding used for the webpage where the text is encoded (ISO-8859-1 in this case)

 

                                    //$to_email_address =$_POST['emailsAdd'];

                                    //$mail_body;

                                    $headers = array();

                                      if(empty($charset)){$charset='ISO-8859-1';}

                                    $headers['Content-Type'] = 'text/html';

                                    $headers['charset'] = $charset;

                                    $mailid=$myrow["email"];

 

                                    $newmail = api_mail_html($myrow["lastname"].' '.$myrow["firstname"], $myrow["email"], stripslashes($emailSubject), $mail_body, $_SESSION['_user']['lastName'].' '.$_SESSION['_user']['firstName'], $_SESSION['_user']['mail'],$headers);

                                }

                                

                                $sql_date="SELECT * FROM $db_name WHERE survey_id='$surveyid'";

                                $res_date=api_sql_query($sql_date, __FILE__, __LINE__);

                                $obj_date=Database::fetch_object($res_date);

                                $end_date=$obj_date->avail_till;

                                $table_reminder = Database :: get_main_table(TABLE_MAIN_SURVEY_REMINDER);

                                

                                if($_REQUEST['reminder']=="1")

                                {

                                    $time=getdate();

                                    $time = $time['yday'];

                                    $time = $time+7;

                                    $sql="INSERT INTO $table_reminder(sid,db_name,email,subject,content,reminder_choice,reminder_time,avail_till) values('$surveyid','$db_name','$mailid','".addslashes($emailSubject)."','".addslashes($mail_body)."','1','$time','$end_date')";

                                    api_sql_query($sql, __FILE__, __LINE__);

                                }

                                else if($_REQUEST['reminder']=="2")

                                {

                                    $time=getdate();

                                    $time = $time['yday'];

                                    $time = $time+14;

                                    $sql="INSERT INTO $table_reminder(sid,db_name,email,subject,content,reminder_choice,reminder_time,avail_till) values('$surveyid','$db_name','$mailid','".addslashes($emailSubject)."','".addslashes($mail_body)."','1','$time','$end_date')";

                                    api_sql_query($sql, __FILE__, __LINE__);

 

                                }

                                else if($_REQUEST['reminder']=="3")

                                {

                                    $time=getdate();

                                    $time = $time['yday'];

                                    $time = $time+30;

                                    $sql="INSERT INTO $table_reminder(sid,db_name,email,subject,content,reminder_choice,reminder_time,avail_till) values('$surveyid','$db_name','$mailid','".addslashes($emailSubject)."','".addslashes($mail_body)."','1','$time','$end_date')";

                                    api_sql_query($sql, __FILE__, __LINE__);

                                }

                            }

                            update_mail_sent($insert_id);

                            $message = $added_and_sent;

                        }

 

                    } // $email_ann*/

 

                }    // isset

 

 

            // UNSET VARIABLES

 

                unset_session_resources();

                unset($form_elements);

                $_SESSION['formelements']=null;

 

                $newContent = null;

                $emailTitle = null;

 

                unset($emailTitle);

                unset($newContent);

                unset($content_to_modify);

                unset($title_to_modify);

 

 

 

 

 $surveyid=$_REQUEST['surveyid'];

 $cidReq = $_REQUEST['cidReq'];

 ?>

<script>

    window.location.href="../survey/survey_list.php?<?php echo  api_get_cidreq(); ?>&published=published&surveyid=<?php echo $_REQUEST['publish_survey']; ?>";

</script>

 

    }    // if $submit Announcement

 

 

 

 

 

  }

 

 

if (empty($_GET['origin']) || $_GET['origin'] !== 'learnpath')

    //api_display_tool_title($nameTools);

    Display::display_introduction_section(TOOL_ANNOUNCEMENT);

 

 

 

    // The commands below will change these display settings if they need it

 

 

        if (empty($_GET['origin']) OR $_GET['origin'] !== 'learnpath')

        {

            echo "\n\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";

            echo "\t<tr>\n";

 

            echo "\t\t<td width=\"20%\" valign=\"top\">\n";

        }

      /*======================================================================

        if(api_is_allowed_to_edit() OR (api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous()) ) // check teacher status

        {

              if (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath')

                {

 

                    $sql="SELECT

                }

        }

        else     // students only get to see the visible announcements

        {

            if (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath')

                {

                    $group_memberships=GroupManager::get_group_ids($_course['dbName'], $_user['user_id']);

 

                    // the user is member of several groups => display personal announcements AND his group announcements AND the general announcements

                    if (is_array($group_memberships) && count($group_memberships)>0)

                    {

                        $sql="SELECT

                            AND    ( toolitemproperties.to_user_id='".$_user['user_id']."'" .

                                "OR toolitemproperties.to_group_id IN (0, ".implode(", ", $group_memberships).") )

                    }

                    // the user is not member of any group

                    else

                    {

                        // this is an identified user => show the general announcements AND his personal announcements

                        if ($_user['user_id'])

                        {

                            $sql="SELECT

                                AND ( toolitemproperties.to_user_id='".$_user['user_id']."' OR toolitemproperties.to_group_id='0')

                        }

                        // the user is not identiefied => show only the general announcements

                        else

                        {

                            $sql="SELECT

                        }

                    }

                }

        }

 

 

$result = api_sql_query($sql,__FILE__,__LINE__);

 

$announcement_number = Database::num_rows($result);

 

        if ((api_is_allowed_to_edit() OR (api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous())) and (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath'))

        {

 

            echo "<a href='".api_get_self()."?".api_get_cidreq()."&action=add&origin=".(empty($_GET['origin'])?'':$_GET['origin'])."'><img src=\"../img/announce_add.gif\"> ".get_lang("AddAnnouncement")."</a><br/>";

            

        }

        if (api_is_allowed_to_edit() && $announcement_number > 1)

        {

            echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&action=delete_all\" onclick=\"javascript:if(!confirm('".get_lang("ConfirmYourChoice")."')) return false;\"><img src=\"../img/valves_delete.gif\"/> ".get_lang("AnnouncementDeleteAll")."</a>\n";

        }    // if announcementNumber > 1

        echo "<hr noshade size=\"1\">";

 

    

if ($display_title_list == true)

    echo "\t\t\t<table>\n";

    while ($myrow = Database::fetch_array($result))

    {

            $title = $myrow['title'];

 

            echo "\t\t\t\t<tr>\n";

            echo "\t\t\t\t\t<td width=\"15%\">\n";

            if ($myrow['visibility']==0)

                { $class="class=\"invisible\"";}

            else

            { $class="";}

            echo "\t\t\t\t\t\t<a style=\"text-decoration:none\" href=\"announcements.php?".api_get_cidreq()."#".$myrow['id']."\" ".$class.">" . api_trunc_str($title,$length) . "</a>\n";

            echo "\t\t\t\t\t</td>\n\t\t\t\t</tr>\n";

    }

    echo "\t\t\t</table>\n";

 

if (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath')

    echo   "\t\t</td>\n";

    echo "\t\t<td width=\"20\" background=\"../img/verticalruler.gif\">&nbsp;</td>\n";

    // START RIGHT PART

    echo    "\t\t<td valign=\"top\">\n";

 

 

if (isset($message) && $message == true)

    Display::display_normal_message($message);

    $display_announcement_list = true;

    $display_form             = false;

 

 

 

    if ($display_form == true)

    {

        

        $content_to_modify=stripslashes($content_to_modify);

        $title_to_modify=stripslashes($title_to_modify);

        

        // DISPLAY ADD ANNOUNCEMENT COMMAND

 

        echo "<form method=\"post\" name=\"f1\" action=\"".api_get_self()."?publish_survey=$surveyid&id=".$_GET['id']."&db_name=$db_name&cidReq=".$_GET['cidReq']."&action=".$_GET['action']."\" style=\"margin:0px;\">\n";

 

        //this variable defines if the course administrator can send a message to a specific user / group

        // or not

        //echo "sessiewaarde: ".$_SESSION['select_groupusers'];

    if(empty($_SESSION['toolgroup'])){

        

        echo "<table><tr><td>";

        echo get_lang("SentTo").": ";

        echo "</td><td>";

        if(isset($_GET['id']) && is_array($to)){

            echo '&nbsp;';

        }

        elseif(isset($_GET['remind_inactive']))

        {

            $email_ann = '1';

            $_SESSION['select_groupusers']="show";

            $content_to_modify = sprintf(get_lang('RemindInactiveLearnersMailContent'),api_get_setting('siteName'), 7);

            $title_to_modify = sprintf(get_lang('RemindInactiveLearnersMailSubject'),api_get_setting('siteName'));

        }

        elseif(isset($_GET['remindallinactives']) && $_GET['remindallinactives']=='true')

        {

            $since = isset($_GET['since']) ? intval($_GET['since']) : 6;

            $to = Tracking :: get_inactives_students_in_course($_course['id'],$since, $_SESSION['id_session']);

            foreach($to as &$user)

            {

                $user = 'USER:'.$user;

            }

            $_SESSION['select_groupusers']="show";

            $email_ann = '1';

            $content_to_modify = sprintf(get_lang('RemindInactiveLearnersMailContent'),api_get_setting('siteName'),$since);

            $title_to_modify = sprintf(get_lang('RemindInactiveLearnersMailSubject'),api_get_setting('siteName'));

            

            //echo '&nbsp;<script type="text/javascript">document.onload = "document.getElementById(\'recipient_list\').style.display=\'block\'";</script>';

        }

        else{

            echo get_lang("Everybody");

        }

        echo "</td><td>";

        echo '<a href="#" onclick="if(document.getElementById(\'recipient_list\').style.display==\'none\') document.getElementById(\'recipient_list\').style.display=\'block\'; else document.getElementById(\'recipient_list\').style.display=\'none\';">'.get_lang('ModifyRecipientList').'</span>';

        echo "</td></tr></table>";

        show_to_form($to);

 

        echo "<br /><br />";

 

        if (!isset($announcement_to_modify) ) $announcement_to_modify ="";

        if ($announcement_to_modify=='')

        {

            ($email_ann=='1')?$checked='checked':$checked='';

            echo "<input class=\"checkbox\" type=checkbox value=\"1\" name=\"email_ann\" $checked> ".get_lang('EmailOption')," : ",

            "<br /><br />";

        }

    }else{

            if (!isset($announcement_to_modify) ) $announcement_to_modify ="";

            if ($announcement_to_modify=='')

            {

                ($email_ann=='1' || !empty($surveyid))?$checked='checked':$checked='';

                echo "<input class=\"checkbox\" type=checkbox value=\"1\" name=\"email_ann\" $checked> ".get_lang('EmailOption')," : ".get_lang('MyGroup'),

                "<br><br>";

                echo '<a href="#" onclick="if(document.getElementById(\'recipient_list\').style.display==\'none\') document.getElementById(\'recipient_list\').style.display=\'block\'; else document.getElementById(\'recipient_list\').style.display=\'none\';">'.get_lang('ModifyRecipientList').'</a>';

                

                show_to_form_group($_SESSION['toolgroup']);

                

                echo '<br><br>';

            }

        }

        if($surveyid){

            echo    get_lang('EmailAddress').": <input type=\"text\" name=\"emailsAdd\" value=\"".$emails_add."\" size=\"52\">(Comma separated for multiple)<br>";

            echo    get_lang('OnlyThoseAddresses').": <input type=\"checkbox\" name=\"onlyThoseMails\"><br>";

        }

        echo    get_lang('EmailTitle').": <input type=\"text\" name=\"emailTitle\" value=\"".$title_to_modify."\" size=\"52\"><br />";

 

                unset($title_to_modify);

                $title_to_modify = null;

 

 

        if (!isset($announcement_to_modify) ) $announcement_to_modify ="";

        if (!isset($content_to_modify) )         $content_to_modify ="";

        if (!isset($title_to_modify))         $title_to_modify = "";

        

        echo    "<br />\n<input type=\"hidden\" name=\"id\" value=\"".$announcement_to_modify."\">";

        if($surveyid){

            $content_to_modify='<br /><a href="'.api_get_path(WEB_CODE_PATH).'/survey/#page#?temp=#temp#&surveyid=#sid#&uid=#uid#&mail=#mail#&db_name=#db_name">'.get_lang('ClickHereToOpenSurvey').'</a><br />

                                            '.get_lang('OrCopyPasteUrl').' <br />

                                            '.api_get_path(WEB_CODE_PATH).'/survey/#page#?temp=#temp#&surveyid=#sid#&uid=#uid#&mail=#mail#&db_name=#db_name&nbsp';

        }

                //api_disp_html_area('newContent',$content_to_modify,'250px');

                

                require_once(api_get_path(LIBRARY_PATH) . "/fckeditor/fckeditor.php");

                $oFCKeditor = new FCKeditor('newContent') ;

                $oFCKeditor->BasePath    = api_get_path(WEB_PATH) . 'main/inc/lib/fckeditor/' ;

                $oFCKeditor->Height        = '250';

                $oFCKeditor->Width        = '100%';

                $oFCKeditor->Value        = $content_to_modify;

                $oFCKeditor->Config['CustomConfigurationsPath'] = api_get_path(REL_PATH)."main/inc/lib/fckeditor/myconfig.js";

                $oFCKeditor->ToolbarSet = "Announcements";

                

                $TBL_LANGUAGES = Database::get_main_table(TABLE_MAIN_LANGUAGE);

                $sql="SELECT isocode FROM ".$TBL_LANGUAGES." WHERE english_name='".$_SESSION["_course"]["language"]."'";

                $result_sql=api_sql_query($sql, __FILE__, __LINE__);

                $isocode_language=Database::result($result_sql,0,0);

                $oFCKeditor->Config['DefaultLanguage'] = $isocode_language;

                

                echo $oFCKeditor->CreateHtml();

 

                if(empty($_SESSION['toolgroup'])){

                    echo '<br /><input type="Submit" name="submitAnnouncement" value="'.get_lang('Ok').'" onclick="selectAll(this.form.elements[3],true)" /><br /><br />';

                }

                else{

                    echo '<br /><input type="Submit" name="submitAnnouncement" value="'.get_lang('Ok').'" onclick="selectAll(this.form.elements[4],true)" /><br /><br />';

                }

                echo '</form><br />';

        if((isset($_GET['action']) && isset($_GET['id']) && is_array($to))||isset($_GET['remindallinactives'])||isset($_GET['remind_inactive'])){

            echo '<script>document.getElementById(\'recipient_list\').style.display=\'block\';</script>';

        }

    } // displayform

 

 

 

 

 

    if ($display_announcement_list && !$surveyid)

    {

        // by default we use the id of the current user. The course administrator can see the announcement of other users by using the user / group filter

        $user_id=$_user['user_id'];

        if (isset($_SESSION['user']))

        {

            $user_id=$_SESSION['user'];

        }

        if (isset($_SESSION['group']))

        {

            $group_id=$_SESSION['group'];

        }

 

        //$group_memberships=GroupManager::get_group_ids($_course['dbName'], $_user['user_id']);

        $group_memberships=GroupManager::get_group_ids($_course['dbName'],$_user['user_id']);