public function keywordAction() { if ($this->getRequest()->getParam('id')) { $model = new Default_Model_DbTable_Keyword(); $keyword = $model->fetchRow(array('query_id = ?' => $this->getRequest()->getParam('id'))); $graph_data = $this->getGraphData('keyword', $keyword->query_id); $this->view->title = 'Daily Twitter vs. Facebook'; $this->view->subtitle = 'Keyword: ' . $keyword->query_q . ' Language: ' . $keyword->query_lang; $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->query_id); $this->view->render('result/head.phtml'); $this->view->render('result/graph.phtml'); $this->view->render('result/influencers.phtml'); $this->view->query_ids = $this->getRequest()->getParam('id'); $this->view->render('result/wire.phtml'); } else { throw new Zend_Controller_Action_Exception('This page does not exist', 404); } }
public function editAction() { $this->view->campaign_id = $this->getRequest()->getParam('campaign'); if ($this->getRequest()->getParam('id')) { $model = new Default_Model_DbTable_Keyword(); $this->view->keyword = $model->fetchRow(array('query_id = ?' => $this->getRequest()->getParam('id'))); } else { $this->view->keyword = new ArrayObject(); $this->view->keyword->query_id = ''; $this->view->keyword->query_q = ''; $this->view->keyword->query_nearplace = ''; $this->view->keyword->query_distance = ''; $this->view->keyword->query_distanceunit = ''; } $this->view->country_options = '<option value="">none</option>'; $locale = new Zend_Locale('en_US'); $countries = $locale->getTranslationList('Territory', 'en', 2); asort($countries, SORT_LOCALE_STRING); while (list($iso, $name) = each($countries)) { $iso = strtolower($iso); $this->view->country_options .= '<option value="' . $iso . '"' . (isset($this->view->keyword['query_lang']) && $iso == $this->view->keyword['query_lang'] ? ' selected' : '') . '>' . $name . '</option>'; } }