public function campaignAction() { if ($this->getRequest()->getParam('id')) { $model = new Default_Model_DbTable_Campaigns(); $campaign = $model->fetchRow(array('project_id = ?' => $this->getRequest()->getParam('id'))); $keyword_ids = $model->getKeywordIds($campaign['project_id']); $keyword_ids = implode(', ', $keyword_ids); $this->view->keyword_titles = $model->getKeywordTitles($campaign['project_id']); $graph_data = $this->getGraphData('campaign', $keyword_ids); $this->view->title = 'Project: ' . $campaign['project_name']; $this->view->subtitle = ''; $this->view->results_cnt = $graph_data['cnt']; $this->view->min_date = $graph_data['min']; $this->view->max_date = $graph_data['max']; $model = new Default_Model_DbTable_Influencers(); $this->view->influencers = $model->getInfluencers($keyword_ids); $this->view->render('result/head.phtml'); $this->view->render('result/graph.phtml'); $this->view->render('result/influencers.phtml'); $this->view->query_ids = $keyword_ids; $this->view->render('result/wire.phtml'); } else { throw new Zend_Controller_Action_Exception('This page does not exist', 404); } }