Exemplo n.º 1
0
 protected function _postDelete()
 {
     $tblPollIp = new App_Model_Db_Table_PollIp();
     $tblPollIp->delete("pollGuid='" . $this->guid . "'");
     $tblPollOpt = new App_Model_Db_Table_PollOption();
     $tblPollOpt->delete("pollGuid='" . $this->guid . "'");
 }
Exemplo n.º 2
0
 function poll($aData)
 {
     $voteid = isset($aData['poll']) ? $aData['poll'] : '';
     $id = $aData['id'] ? $aData['id'] : '';
     $tblPolliP = new App_Model_Db_Table_PollIp();
     $ip_result = $tblPolliP->fetchRow("ip='" . Pandamp_Lib_Formater::getRealIpAddr() . "' AND pollGuid='" . $id . "'");
     if (!isset($ip_result)) {
         $rowIp = $tblPolliP->fetchNew();
         $rowIp->dateOfPoll = date("Y-m-d H:i:s");
         $rowIp->ip = Pandamp_Lib_Formater::getRealIpAddr();
         $rowIp->voteId = $voteid;
         $rowIp->pollGuid = $id;
         $rowIp->save();
         if ($voteid) {
             $tblPoll = new App_Model_Db_Table_Poll();
             $rowPoll = $tblPoll->find($id)->current();
             if ($rowPoll) {
                 $rowPoll->voters = $rowPoll->voters + 1;
                 $rowPoll->save();
             }
             $tblOption = new App_Model_Db_Table_PollOption();
             $rowOption = $tblOption->fetchRow("guid='{$voteid}' AND pollGuid='{$id}'");
             if ($rowOption) {
                 $rowOption->hits = $rowOption->hits + 1;
                 $rowOption->save();
             }
         }
     }
 }
Exemplo n.º 3
0
 function viewAction()
 {
     $tblPolling = new App_Model_Db_Table_Poll();
     $tblOption = new App_Model_Db_Table_PollOption();
     $time = time();
     $date = date("Y-m-d H:i:s", $time);
     $rowPoll = $tblPolling->fetchRow("checkedTime < '{$date}'", "checkedTime DESC");
     $this->view->rowPoll = $rowPoll;
     $rowOpt = $tblOption->fetchAll("pollGuid='{$rowPoll->guid}'", "text ASC");
     $this->view->rowOpt = $rowOpt;
 }
Exemplo n.º 4
0
 public function deleteAction()
 {
     $this->_helper->getHelper('layout')->disableLayout();
     $this->_helper->getHelper('viewRenderer')->setNoRender();
     $this->preProcessSession();
     $request = $this->getRequest();
     $result = 'RESULT_ERROR';
     if ($request->isPost()) {
         $guid = $request->getPost('guid');
         $ids = array();
         $ids = Zend_Json::decode($guid);
         $pollingDb = new App_Model_Db_Table_Poll();
         $pollingOptionDb = new App_Model_Db_Table_PollOption();
         foreach ($ids as $pollId) {
             $pollingDb->delete(['guid=?' => $pollId]);
             $pollingOptionDb->delete(['pollGuid=?' => $pollId]);
         }
         $result = 'RESULT_OK';
     }
     $this->getResponse()->setBody($result);
 }