/**
* Returns a list of emails according to the requested parameters
*
* @param string $action
* @param string $tag
* @param array $attributes
* @param Project $project
* @return array
*/
private function getEmails($attributes, $context = null, $start = null, $limit = null, $order_by = 'sent_date', $dir = 'ASC', $join_params = null, $conversation_list = null, $only_count_result = null)
{
// Return if no emails should be displayed
if (!isset($attributes["viewType"]) || $attributes["viewType"] != "all" && $attributes["viewType"] != "emails") {
return null;
}
$account = array_var($attributes, "accountId");
$classif_filter = array_var($attributes, 'classifType');
$read_filter = array_var($attributes, 'readType');
//set_user_config_option('mails account filter', $account, logged_user()->getId());
//set_user_config_option('mails classification filter', $classif_filter, logged_user()->getId());
//set_user_config_option('mails read filter', $read_filter, logged_user()->getId());
$state = array_var($attributes, 'stateType');
$result = MailContents::getEmails($account, $state, $read_filter, $classif_filter, $context, $start, $limit, $order_by, $dir, $join_params, null, $conversation_list, $only_count_result);
return $result;
}
/**
* Returns a list of emails according to the requested parameters
*
* @param string $action
* @param string $tag
* @param array $attributes
* @param Project $project
* @return array
*/
private function getEmails($tag, $attributes, $project = null, $start = null, $limit = null, $order_by = 'sent_date', $dir = 'ASC', &$totalCount = 0)
{
// Return if no emails should be displayed
if (!isset($attributes["viewType"]) || $attributes["viewType"] != "all" && $attributes["viewType"] != "emails") {
return null;
}
$account = array_var($attributes, "accountId");
$classif_filter = array_var($attributes, 'classifType');
$read_filter = array_var($attributes, 'readType');
set_user_config_option('mails account filter', $account, logged_user()->getId());
set_user_config_option('mails classification filter', $classif_filter, logged_user()->getId());
set_user_config_option('mails read filter', $read_filter, logged_user()->getId());
$state = array_var($attributes, 'stateType');
list($objects, $pagination) = MailContents::getEmails($tag, $account, $state, $read_filter, $classif_filter, $project, $start, $limit, $order_by, $dir);
$totalCount = $pagination->getTotalItems();
//if standed in "All" check if all workspaces related to the email have been archived.. and if so, dont show them
if (active_project() == null) {
$aux = array();
foreach ($objects as $mail) {
$check = WorkspaceObjects::getWorkspacesByObject('MailContents', $mail->getId());
$archived = true;
foreach ($check as $wsobject) {
$ws = Projects::findById($wsobject->getId());
if ($ws->getCompletedById() != '0') {
continue;
}
$archived = false;
break;
}
if (!$archived || $check == null) {
$aux[] = $mail;
}
}
return $aux;
}
return $objects;
}
/**
* Show dashboard index page
*
* @param void
* @return null
*/
function index()
{
$this->setHelp('dashboard');
$tag = array_var($_GET, 'active_tag');
$logged_user = logged_user();
if (active_project() instanceof Project) {
$wscsv = active_project()->getAllSubWorkspacesQuery(true);
} else {
$wscsv = null;
}
$activity_log = null;
$include_private = $logged_user->isMemberOfOwnerCompany();
$include_silent = $logged_user->isAdministrator();
$activity_log = ApplicationLogs::getOverallLogs($include_private, $include_silent, $wscsv, config_option('dashboard_logs_count', 15));
if (user_config_option('show charts widget') && module_enabled('reporting')) {
$charts = ProjectCharts::getChartsAtProject(active_project(), active_tag());
tpl_assign('charts', $charts);
if (BillingCategories::count() > 0 && active_project() instanceof Project) {
tpl_assign('billing_chart_data', active_project()->getBillingTotalByUsers(logged_user()));
}
}
if (user_config_option('show messages widget') && module_enabled('notes')) {
list($messages, $pagination) = ProjectMessages::getMessages(active_tag(), active_project(), 0, 10, '`updated_on`', 'DESC', false);
tpl_assign('messages', $messages);
}
if (user_config_option('show comments widget')) {
$comments = Comments::getSubscriberComments(active_project(), $tag);
tpl_assign('comments', $comments);
}
if (user_config_option('show documents widget') && module_enabled('documents')) {
list($documents, $pagination) = ProjectFiles::getProjectFiles(active_project(), null, false, ProjectFiles::ORDER_BY_MODIFYTIME, 'DESC', 1, 10, false, active_tag(), null);
tpl_assign('documents', $documents);
}
if (user_config_option('show emails widget') && module_enabled('email')) {
$activeWs = active_project();
list($unread_emails, $pagination) = MailContents::getEmails($tag, null, 'received', 'unread', '', $activeWs, 0, 10);
if ($activeWs && user_config_option('always show unread mail in dashboard')) {
// add unread unclassified emails
list($all_unread, $pagination) = MailContents::getEmails($tag, null, 'received', 'unread', 'unclassified', null, 0, 10);
$unread_emails = array_merge($unread_emails, $all_unread);
}
tpl_assign('unread_emails', $unread_emails);
}
//Tasks widgets
$show_pending = user_config_option('show pending tasks widget') && module_enabled('tasks');
$show_in_progress = user_config_option('show tasks in progress widget') && module_enabled('tasks');
$show_late = user_config_option('show late tasks and milestones widget') && module_enabled('tasks');
if ($show_pending || $show_in_progress || $show_late) {
$assigned_to = explode(':', user_config_option('pending tasks widget assigned to filter'));
$to_company = array_var($assigned_to, 0, 0);
$to_user = array_var($assigned_to, 1, 0);
tpl_assign('assigned_to_user_filter', $to_user);
tpl_assign('assigned_to_company_filter', $to_company);
}
if ($show_pending) {
$tasks = ProjectTasks::getProjectTasks(active_project(), ProjectTasks::ORDER_BY_DUEDATE, 'ASC', null, null, $tag, $to_company, $to_user, null, true, 'all', false, false, false, 10);
tpl_assign('dashtasks', $tasks);
}
if ($show_in_progress) {
$tasks_in_progress = ProjectTasks::getOpenTimeslotTasks(logged_user(), logged_user(), active_project(), $tag, $to_company, $to_user);
tpl_assign('tasks_in_progress', $tasks_in_progress);
}
if ($show_late) {
tpl_assign('today_milestones', $logged_user->getTodayMilestones(active_project(), $tag, 10));
tpl_assign('late_milestones', $logged_user->getLateMilestones(active_project(), $tag, 10));
tpl_assign('today_tasks', ProjectTasks::getDayTasksByUser(DateTimeValueLib::now(), $logged_user, active_project(), $tag, $to_company, $to_user, 10));
tpl_assign('late_tasks', ProjectTasks::getLateTasksByUser($logged_user, active_project(), $tag, $to_company, $to_user, 10));
}
tpl_assign('activity_log', $activity_log);
$usu = logged_user();
$conditions = array("conditions" => array("`state` >= 200 AND (`state`%2 = 0) AND `trashed_by_id`=0 AND `created_by_id` =" . $usu->getId()));
$outbox_mails = MailContents::findAll($conditions);
if ($outbox_mails != null) {
if (count($outbox_mails) == 1) {
flash_error(lang('outbox mail not sent', 1));
} else {
if (count($outbox_mails) > 1) {
flash_error(lang('outbox mails not sent', count($outbox_mails)));
}
}
}
ajx_set_no_toolbar(true);
}