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