/**
* This function prints all mails
*
* @uses $CFG, $COURSE, $SESSION
* @param int $userid User ID
* @param string $order Order by ...
* @param object $options Options for url
* @param boolean $search When show mails on search
* @param array $mailssearch Mails who has search
* @return boolean Success/Fail
* @todo Finish documenting this function
**/
function email_showmails($userid, $order = '', $page = 0, $perpage = 10, $options = NULL, $search = false, $mailssearch = NULL)
{
global $CFG, $COURSE, $SESSION;
// CONTRIB-690
if (!empty($_POST['perpage']) and is_numeric($_POST['perpage'])) {
$SESSION->email_mailsperpage = $_POST['perpage'];
} else {
if (!isset($SESSION->email_mailsperpage) or empty($SESSION->email_mailsperpage)) {
$SESSION->email_mailsperpage = 10;
// Default value
}
}
require_once 'tablelib.php';
require_once 'email.class.php';
// Get actual course
if (!($course = get_record("course", "id", $COURSE->id))) {
print_error('invalidcourseid', 'block_email_list');
}
if ($course->id == SITEID) {
$coursecontext = get_context_instance(CONTEXT_SYSTEM);
// SYSTEM context
} else {
$coursecontext = get_context_instance(CONTEXT_COURSE, $course->id);
// Course context
}
$url = '';
// Build url part options
if ($options) {
$url = email_build_url($options);
}
/// Print all mails in this HTML file
// Should use this variable so that we don't break stuff every time a variable is added or changed.
$baseurl = $CFG->wwwroot . '/blocks/email_list/email/index.php?' . $url . '&page=' . $page . '&perpage=' . $perpage;
// Print init form from send data
echo '<form id="sendmail" action="' . $CFG->wwwroot . '/blocks/email_list/email/index.php?id=' . $course->id . '&folderid=' . $options->folderid . '" method="post" target="' . $CFG->framename . '" name="sendmail">';
if ($course->id == SITEID) {
$tablecolumns = array('', 'icon', 'course', 'subject', 'writer', 'timecreated');
} else {
$tablecolumns = array('', 'icon', 'subject', 'writer', 'timecreated');
}
$folder = NULL;
if (isset($options->folderid)) {
if ($options->folderid != 0) {
// Get folder
$folder = email_get_folder($options->folderid);
} else {
// solve problem with select an x mails per page for maintein in this folder
if (isset($options->folderoldid) && $options->folderoldid != 0) {
$options->folderid = $options->folderoldid;
$folder = email_get_folder($options->folderid);
}
}
}
// If actual folder is inbox type, ... change tag showing.
if ($folder) {
if (email_isfolder_type($folder, EMAIL_INBOX)) {
$strto = get_string('from', 'block_email_list');
} else {
$strto = get_string('to', 'block_email_list');
}
} else {
$strto = get_string('from', 'block_email_list');
}
if ($course->id == SITEID) {
$tableheaders = array('', '', get_string('course'), get_string('subject', 'block_email_list'), $strto, get_string('date', 'block_email_list'));
} else {
$tableheaders = array('', '', get_string('subject', 'block_email_list'), $strto, get_string('date', 'block_email_list'));
}
$table = new email_flexible_table('list-mails-' . $userid);
$table->define_columns($tablecolumns);
$table->define_headers($tableheaders);
$table->define_baseurl($baseurl);
$table->set_attribute('align', 'center');
$table->set_attribute('width', '100%');
$table->set_attribute('class', 'emailtable');
$table->set_control_variables(array(TABLE_VAR_SORT => 'ssort', TABLE_VAR_HIDE => 'shide', TABLE_VAR_SHOW => 'sshow', TABLE_VAR_IFIRST => 'sifirst', TABLE_VAR_ILAST => 'silast', TABLE_VAR_PAGE => 'spage'));
$table->sortable(true, 'timecreated', SORT_DESC);
$table->setup();
// When no search
if (!$search) {
// Get mails
$mails = email_get_mails($userid, $course->id, $table->get_sql_sort(), '', '', $options);
} else {
$mails = $mailssearch;
}
// Define long page.
$totalcount = count($mails);
$table->pagesize($SESSION->email_mailsperpage, $totalcount);
$table->inputs(true);
// Now, re-getting emails, apply pagesize (limit)
if (!$search) {
// Get mails
$mails = email_get_mails($userid, $course->id, $table->get_sql_sort(), $table->get_page_start(), $table->get_page_size(), $options);
}
if (!$mails) {
$mails = array();
}
$mailsids = email_get_ids($mails);
// Print all rows
foreach ($mails as $mail) {
$attribute = array();
$email = new eMail();
$email->set_email($mail);
if ($folder) {
if (email_isfolder_type($folder, EMAIL_SENDBOX)) {
$struser = $email->get_users_send(has_capability('moodle/site:viewfullnames', $coursecontext));
} else {
if (email_isfolder_type($folder, EMAIL_INBOX)) {
$struser = $email->get_fullname_writer(has_capability('moodle/site:viewfullnames', $coursecontext));
if (!$email->is_readed($userid, $mail->course)) {
$attribute = array('bgcolor' => $CFG->email_table_field_color);
}
} else {
if (email_isfolder_type($folder, EMAIL_TRASH)) {
$struser = $email->get_fullname_writer(has_capability('moodle/site:viewfullnames', $coursecontext));
if (!$email->is_readed($userid, $mail->course)) {
$attribute = array('bgcolor' => $CFG->email_table_field_color);
}
} else {
if (email_isfolder_type($folder, EMAIL_DRAFT)) {
$struser = $email->get_users_send(has_capability('moodle/site:viewfullnames', $coursecontext));
if (!$email->is_readed($userid, $mail->course)) {
$attribute = array('bgcolor' => $CFG->email_table_field_color);
}
} else {
$struser = $email->get_fullname_writer(has_capability('moodle/site:viewfullnames', $coursecontext));
if (!$email->is_readed($userid, $mail->course)) {
$attribute = array('bgcolor' => $CFG->email_table_field_color);
}
}
}
}
}
} else {
// Format user's
$struser = $email->get_fullname_writer(has_capability('moodle/site:viewfullnames', $coursecontext));
if (!$email->is_readed($userid, $mail->course)) {
$attribute = array('bgcolor' => $CFG->email_table_field_color);
}
}
if (!isset($options->folderid)) {
$options->folderid = 0;
}
if (email_isfolder_type($folder, EMAIL_DRAFT)) {
$urltosent = '<a href="' . $CFG->wwwroot . '/blocks/email_list/email/sendmail.php?id=' . $mail->id . '&action=' . EMAIL_EDITDRAFT . '&course=' . $course->id . '">' . $mail->subject . '</a>';
} else {
if ($course->id == SITEID) {
$urltosent = '<a href="' . $CFG->wwwroot . '/blocks/email_list/email/view.php?id=' . $mail->id . '&action=' . EMAIL_VIEWMAIL . '&course=' . $mail->course . '&folderid=' . $options->folderid . '&mails=' . $mailsids . '">' . $mail->subject . '</a>';
} else {
$urltosent = '<a href="' . $CFG->wwwroot . '/blocks/email_list/email/view.php?id=' . $mail->id . '&action=' . EMAIL_VIEWMAIL . '&course=' . $course->id . '&folderid=' . $options->folderid . '&mails=' . $mailsids . '">' . $mail->subject . '</a>';
}
}
$attachment = '';
if ($email->has_attachments()) {
$attachment = '<img src="' . $CFG->wwwroot . '/blocks/email_list/email/images/clip.gif" alt="attachment" /> ';
}
// Display diferent color if mail is reply or reply all
$extraimginfo = '';
if ($email->is_answered($userid, $course->id)) {
// Color td
unset($attribute);
$attribute = array('bgcolor' => $CFG->email_answered_color);
// Adding info img
$extraimginfo = '<img src="' . $CFG->wwwroot . '/blocks/email_list/email/images/answered.gif" alt="" /> ';
}
if (!($course_mail = get_record("course", "id", $mail->course))) {
print_error('invalidcourseid', 'block_email_list');
}
if ($course->id == SITEID) {
$table->add_data(array('<input id="mail" type="checkbox" name="mailid[]" value="' . $mail->id . '" />', $course_mail->fullname, $attachment . $extraimginfo, $urltosent, $struser, userdate($mail->timecreated)), $attribute);
} else {
$table->add_data(array('<input id="mail" type="checkbox" name="mailid[]" value="' . $mail->id . '" />', $attachment . $extraimginfo, $urltosent, $struser, userdate($mail->timecreated)), $attribute);
}
// Save previous mail
$previousmail = $mail->id;
}
$table->print_html();
// Print select action, if have mails
if ($mails) {
email_print_select_options($options, $SESSION->email_mailsperpage);
}
// End form
echo '</form>';
return true;
}
// Can create subfolders?
if (!has_capability('block/email_list:createfolder', $context)) {
print_error('forbiddencreatefolder', 'block_email_list', $CFG->wwwroot . '/blocks/email_list/email/index.php?id=' . $course->id);
}
// Print form to new folder
echo $OUTPUT->notification(get_string('nosubfolders', 'block_email_list'), '');
$mform = new folder_form('folder.php', array('id' => $id, 'course' => $courseid, 'action' => ''));
$mform->display();
}
break;
case 'cleantrash':
$trash = email_get_root_folder($USER->id, EMAIL_TRASH);
/// If necessary, delete mail and delete attachments
$options->folderid = $trash->id;
$success = true;
$mails = email_get_mails($USER->id, $course->id, NULL, '', '', $options);
// Delete reference mails
$DB->delete_records('block_email_list_foldermail', array('folderid' => $trash->id));
// Get all trash mails
if ($mails) {
foreach ($mails as $mail) {
// if mailid exist, continue ...
if ($DB->get_records('block_email_list_foldermail', array('mailid' => $mail->id))) {
continue;
} else {
// Mail is not reference by never folder (not possibility readed)
if (email_delete_attachments($mail->id) and $DB->delete_records('block_email_list_mail', array('id' => $mail->id))) {
$success = true;
}
}
}
