function poll($aData) { $voteid = isset($aData['poll']) ? $aData['poll'] : ''; $id = $aData['id'] ? $aData['id'] : ''; $tblPolliP = new Pandamp_Modules_Misc_Poll_Model_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 Pandamp_Modules_Misc_Poll_Model_Poll(); $rowPoll = $tblPoll->find($id)->current(); if ($rowPoll) { $rowPoll->voters = $rowPoll->voters + 1; $rowPoll->save(); } $tblOption = new Pandamp_Modules_Misc_Option_Model_Option(); $rowOption = $tblOption->fetchRow("guid='{$voteid}' AND pollGuid='{$id}'"); if ($rowOption) { $rowOption->hits = $rowOption->hits + 1; $rowOption->save(); } } } }
function pollAction() { $this->_helper->layout->setLayout('layout-polling'); $this->_helper->layout->setLayoutPath(array('layoutPath' => ROOT_DIR . '/app/modules/polling/layouts')); $pollId = $this->_getParam('guid') ? $this->_getParam('guid') : ''; $tblPolling = new Pandamp_Modules_Misc_Poll_Model_Poll(); $time = time(); $date = date("Y-m-d H:i:s", $time); $rowPoll = $tblPolling->fetchAll("guid NOT IN('{$pollId}') AND checkedTime < '{$date}'", "checkedTime DESC"); $this->view->rowPoll = $rowPoll; $this->view->pollId = $pollId; }
public function fetchPollingAction() { $start = $this->_getParam('start') ? $this->_getParam('start') : 0; $end = $this->_getParam('limit') ? $this->_getParam('limit') : 10; $tblPoll = new Pandamp_Modules_Misc_Poll_Model_Poll(); $rowset = $tblPoll->fetchAll(null, null, $end, $start); $a = array(); $a['totalCount'] = count($rowset); $i = 0; if ($a['totalCount'] != 0) { foreach ($rowset as $row) { $a['poll'][$i]['guid'] = $row->guid; $a['poll'][$i]['title'] = $row->title; $i++; } } if ($a['totalCount'] == 0) { $a['poll'][$i]['guid'] = ''; $a['poll'][$i]['title'] = ''; } echo Zend_Json::encode($a); }