<?php
$data = array();
loader_import('cms.Workspace.Message');
$msg = new WorkspaceMessage();
$data['folders'] = $msg->categories();
$inbox = new StdClass();
$inbox->name = intl_get('Inbox');
$inbox->count = db_shift('select count(*) from sitellite_msg_recipient where type = "user" and user = ? and category = ""', session_username());
$outbox = new StdClass();
$outbox->name = intl_get('Sent');
$outbox->count = db_shift('select count(*) from sitellite_message where from_user = ?', session_username());
$trash = new StdClass();
$trash->name = intl_get('Trash');
$trash->count = db_shift('select count(*) from sitellite_msg_recipient where type = "user" and status = "trash" and user = ?', session_username());
array_unshift($data['folders'], $trash);
array_unshift($data['folders'], $outbox);
array_unshift($data['folders'], $inbox);
echo template_simple(CMS_JS_ALERT_MESSAGE, $GLOBALS['cgi']);
echo template_simple('messages/index.spt', $data);
$list = $msg->getSent(false, false, $limit, $cgi->offset, $cgi->orderBy, $cgi->sort);
} elseif ($cgi->category == 'Inbox') {
$list = $msg->getFolder('', false, $limit, $cgi->offset, $cgi->orderBy, $cgi->sort);
} elseif ($cgi->category == 'Trash') {
$list = $msg->getTrash($limit, $cgi->offset, $cgi->orderBy, $cgi->sort);
} else {
$list = $msg->getFolder($cgi->category, false, $limit, $cgi->offset, $cgi->orderBy, $cgi->sort);
}
if ($cgi->category == 'Sent') {
$dg = new DataGrid('sitellite_message', array('subject' => intl_get('Subject'), 'msg_date' => intl_get('Date'), 'recipients' => intl_get('To')), $limit);
$dg->skipHeader('recipients');
} else {
$dg = new DataGrid('sitellite_message', array('subject' => intl_get('Subject'), 'msg_date' => intl_get('Date'), 'from_user' => intl_get('From')), $limit);
if ($cgi->category != 'Trash') {
$dg->setDeleteUrl(site_prefix() . '/index/cms-messages-delete-action');
$categories = $msg->categories();
$dg->footer = template_simple('messages/footer.spt', array('list' => $categories, 'current' => $cgi->category));
}
}
$dg->primaryKey('id');
$dg->setEditUrl(site_prefix() . '/index/cms-messages-view-action');
if ($cgi->category == 'Sent') {
$dg->filter(array('subject' => 'filter_cms_messages_subject', 'msg_date' => 'filter_cms_messages_date', 'recipients' => 'filter_cms_messages_to'));
} else {
$dg->filter(array('subject' => 'filter_cms_messages_subject', 'msg_date' => 'filter_cms_messages_date', 'from_user' => 'filter_cms_messages_from'));
}
$dg->rememberValue('category', $cgi->category);
$dg->list =& $list;
$dg->total =& $msg->total;
page_title(intl_get('Folder') . ': ' . $cgi->category);
echo template_simple(CMS_JS_ALERT_MESSAGE, $GLOBALS['cgi']);
