if ($sugar_config["dbconfig"]["db_type"] == "mssql") { //add condition for MS Sql server. $where .= " AND calls.date_start + ' ' + calls.time_start <= '" . $laterWhere["date"] . " " . $laterWhere["time"] . "' "; } else { $GLOBALS['log']->fatal("No database type identified."); } } $call->disable_row_level_security = true; $focus_calls_list = $call->get_full_list("time_start", $where); } $open_activity_list = array(); if (count($focus_meetings_list) > 0) { foreach ($focus_meetings_list as $meeting) { $td = $timedate->merge_date_time(from_db_convert($meeting->date_start, 'date'), from_db_convert($meeting->time_start, 'time')); $tag = 'span'; if ($meeting->ACLAccess('view', $meeting->isOwner($current_user->id))) { $tag = 'a'; } $open_activity_list[] = array('name' => $meeting->name, 'id' => $meeting->id, 'type' => 'Meeting', 'module' => 'Meetings', 'status' => $meeting->status, 'parent_id' => $meeting->parent_id, 'parent_type' => $meeting->parent_type, 'parent_name' => $meeting->parent_name, 'contact_id' => $meeting->contact_id, 'contact_name' => $meeting->contact_name, 'normal_date_start' => $meeting->date_start, 'date_start' => $timedate->to_display_date($td), 'normal_time_start' => $meeting->time_start, 'time_start' => $timedate->to_display_time($td, true), 'required' => $meeting->required, 'accept_status' => $meeting->accept_status, 'tag' => $tag); } } if (count($focus_calls_list) > 0) { foreach ($focus_calls_list as $call) { $td = $timedate->merge_date_time(from_db_convert($call->date_start, 'date'), from_db_convert($call->time_start, 'time')); $tag = 'span'; if ($call->ACLAccess('view', $call->isOwner($current_user->id))) { $tag = 'a'; } $open_activity_list[] = array('name' => $call->name, 'id' => $call->id, 'type' => 'Call', 'module' => 'Calls', 'status' => $call->status, 'parent_id' => $call->parent_id, 'parent_type' => $call->parent_type, 'parent_name' => $call->parent_name, 'contact_id' => $call->contact_id, 'contact_name' => $call->contact_name, 'date_start' => $timedate->to_display_date($td), 'normal_date_start' => $call->date_start, 'normal_time_start' => $call->time_start, 'time_start' => $timedate->to_display_time($td, true), 'required' => $call->required, 'accept_status' => $call->accept_status, 'tag' => $tag); } }