public function index()
{
$user_id = mysql_real_escape_string(Site::CurrentUser()->id);
$all_surveys = Survey::find_all("surveys.active = true");
$all_responses = SurveyResponse::find_all("users.id = '{$user_id}'");
$responses = array();
$surveys = array();
foreach ($all_responses as $response) {
$responses[] = $response->survey_id;
}
foreach ($all_surveys as $survey) {
if (!in_array($survey->id, $responses)) {
if ($survey->event_id > 0) {
$event_id = mysql_real_escape_string($survey->event_id);
$user_id = mysql_real_escape_string(Site::CurrentUser()->id);
$result = EventSignup::find("events.id = '{$event_id}' AND users.id = '{$user_id}' AND event_signups.paid");
if ($result) {
$surveys[] = $survey;
}
} else {
$surveys[] = $survey;
}
}
}
$this->assign("surveys", $surveys);
$this->title = "Surveys";
$this->render("survey/index.tpl");
}
public function responses($reload = false)
{
if ($reload or !$this->responses_cache) {
$id = mysql_real_escape_string($this->id);
$this->responses_cache = SurveyResponse::find_all("surveys.id = '{$id}'");
}
return $this->responses_cache;
}
