$where .= ") ";
$where .= " AND meetings_users.user_id='{$current_user->id}' ";
$where .= " AND meetings_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") {
$where .= " AND meetings.date_start + ' ' + meetings.time_start <= '" . $laterWhere["date"] . " " . $laterWhere["time"] . "' ";
} else {
$GLOBALS['log']->fatal("No database type identified.");
}
}
$meeting->disable_row_level_security = true;
$focus_meetings_list = $meeting->get_full_list("time_start", $where);
}
if (ACLController::checkAccess('Calls', 'list', true)) {
$call = new Call();
$where = '(';
$or = false;
foreach ($open_status as $status) {
if ($or) {
$where .= ' OR ';
}
$or = true;
$where .= " calls.status = '{$status}' ";
}
$where .= ") ";
$where .= " AND calls_users.user_id='{$current_user->id}' ";
$where .= " AND calls_users.accept_status != 'decline'";
