Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
sql select
<? php
public static function getAllIndicatorValuesOverview($userId = null) {
$surveys = self::getConnection()->query(
'SELECT surveys.surveyId,surveys.year,user.organizationName
FROM surveys
LEFT JOIN user ON surveys.userId=user.userId'
)->fetchAll();
foreach($surveys as &$survey) {
$indicators = self::getConnection()->query(
'SELECT indicator.name,indicatorvalue.value
FROM indicator
LEFT JOIN indicatorvalue ON indicator.indicatorId=indicatorvalue.indicatorId
WHERE indicatorvalue.surveyId=?', $survey['surveyId']
)->fetchAll();
foreach($indicators as $indicator) {
$survey[$indicator['name']] = $indicator['value'];
}
$survey = (array) $survey;
}
return $surveys;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment