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(); }