$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'";