<?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']);