$where .= " AND calls_users.user_id='{$current_user->id}' ";
$where .= " AND calls_users.accept_status != 'decline'";
// allow for differences between MySQL and Oracle 9
if ($sugar_config["dbconfig"]["db_type"] == "mysql") {
$where .= " HAVING datetime <= '" . $laterWhere["date"] . " " . $laterWhere["time"] . "' ";
} elseif ($sugar_config["dbconfig"]["db_type"] == "oci8") {
} else {
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'));
