/**
 * @param $project_ids
 * @return mixed
 */
function prepare_relevant_issues($project_ids)
{
    $specmanagement_database_api = new specmanagement_database_api();
    $reachable_issue_ids = array();
    foreach ($project_ids as $project_id) {
        $project_related_issue_ids = $specmanagement_database_api->get_bugs_by_project($project_id);
        if (!is_null($project_related_issue_ids)) {
            foreach ($project_related_issue_ids as $project_related_issue_id) {
                array_push($reachable_issue_ids, $project_related_issue_id);
            }
        }
    }
    return $reachable_issue_ids;
}