function adminindexAction()
{
$this->view->title = "All Participations";
$this->view->activeTab = "List Participations";
$this->campaign_id = $this->_request->getParam('id');
$this->tag = $this->_request->getParam('tag');
$db = Zend_Registry::get('db');
$select = $db->select();
$select->from('campaign', null);
$select->join('campaign_invitation', 'campaign.id = campaign_invitation.campaign_id', 'state');
if ($this->tag) {
$select->join('consumer', "consumer.id = campaign_invitation.consumer_id and tags like '%{$this->tag},%'");
} else {
$select->join('consumer', "consumer.id = campaign_invitation.consumer_id ");
}
$select->join('campaign_participation', 'campaign_invitation.id = campaign_participation.campaign_invitation_id', array('accept_date', 'state'));
$select->where('campaign_invitation.campaign_id = ?', $this->campaign_id)->where('consumer.pest is null or consumer.pest != 1');
$this->view->campaignParticipations = $db->fetchAll($select);
$this->view->campaign_id = $this->campaign_id;
$this->view->tag = $this->tag;
// $this->_helper->layout->disableLayout();
//print_r($this->view->campaignParticipations);die;
$this->_helper->layout->setLayout("layout_admin");
//extract the profile survey
$profileSurvey = new ProfileSurvey();
$this->view->profilesurvey = $profileSurvey->fetchAll('id !=12');
}
public function admindownloadindexAction()
{
$this->view->title = 'Reports';
$this->view->activeTab = 'Reports';
$this->_helper->layout->setLayout("layout_admin");
$profileSurveyModel = new ProfileSurvey();
$this->view->profileSurvey = $profileSurveyModel->fetchAll();
$campaignModel = new Campaign();
$this->view->campaigns = $campaignModel->fetchAll();
}
