public function DeploymentMatchingOrgs()
{
$filterWhereClause = SangriaPage_Controller::generateFilterWhereClause();
$range = self::getSurveyRange('ViewDeploymentsPerRegion');
if ($range == SurveyType::MARCH_2015) {
$range_filter = "D.Created >= '" . SURVEY_START_DATE . "'";
} else {
$range_filter = "D.Created < '" . SURVEY_START_DATE . "'";
}
$date_filter = ' AND ' . SangriaPage_Controller::$date_filter_query;
$query = "SELECT DISTINCT O.Name FROM Deployment D JOIN DeploymentSurvey S ON (D.DeploymentSurveyID = S.ID) JOIN Org O on (S.OrgID = O.ID) WHERE " . $range_filter . $filterWhereClause . $date_filter;
$results = DB::query($query);
$list = new ArrayList();
foreach ($results as $row) {
$list->push(new Org($row));
}
return $list;
}
