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>';
     }
 }