function postcampaigndoAction() { if ($this->autoAccountBinding() == false) { return; } if ($this->_request->isPost()) { $formData = $this->_request->getPost(); if ($this->postToIndicate($formData)) { //save report successfully $consumer = $this->_currentUser; $survey_id = (int) $this->_request->getParam('i2_survey_id', 0); $code = $this->_request->getParam('id'); $currentTime = date("Y-m-d H:i:s"); $campaignModel = new Campaign(); $this->view->campaign = $campaignModel->fetchRow("post_campaign_survey=" . $survey_id . " or " . "post_campaign_survey_en=" . $survey_id); $db = Zend_Registry::get('db'); $campaignId = $this->view->campaign->id; $this->view->campaign_id = $campaignId; if ($campaignId > 0) { //change campaign_participation state $db = Zend_Registry::get('db'); $select2 = $db->select(); $select2->from('campaign_participation', '*')->join('campaign_invitation', 'campaign_invitation.id = campaign_participation.campaign_invitation_id', null)->where('campaign_invitation.consumer_id = ?', $consumer['id'])->where('campaign_invitation.campaign_id = ?', $campaignId)->where("campaign_participation.state != 'COMPLETED'"); $isExist = $db->fetchAll($select2); if ($isExist != null) { $campaing_participateModel = new CampaignParticipation(); $campaign_participation = $campaing_participateModel->fetchRow('campaign_invitation_id = ' . $isExist[0]['campaign_invitation_id']); $campaign_participation->state = 'COMPLETED'; $campaign_participation->save(); //add 200 points for member in reward_point_transaction_record $rewardPointTransactionRecordModel = new RewardPointTransactionRecord(); $rewardPointTransaction = array("consumer_id" => $consumer['id'], "date" => date("Y-m-d H:i:s"), "transaction_id" => "5", "point_amount" => "200"); $id = $rewardPointTransactionRecordModel->insert($rewardPointTransaction); } $this->view->message = "Success"; } } else { //failed $this->view->message = "Failed"; $this->render('failed'); } } else { $this->view->xianei_redirect = $this->xiaonei_redirect('home'); $this->render('redirect2home'); } }
function postcampaignfinishedAction() { $this->view->activeTab = 'Campaign'; $this->view->title = $this->view->title = $this->view->translate("Wildfire") . " - " . $this->view->translate("You_are_in"); $id = (int) $this->_request->getParam('survey'); $campaignModel = new Campaign(); $this->view->campaign = $campaignModel->fetchRow("post_campaign_survey=" . $id . " or " . "post_campaign_survey_en=" . $id); $db = Zend_Registry::get('db'); $campaignId = $this->view->campaign->id; $this->view->campaign_id = $campaignId; $consumer = $this->_currentUser; if ($campaignId > 0) { //change campaign_participation state $db = Zend_Registry::get('db'); $select2 = $db->select(); $select2->from('campaign_participation', '*')->join('campaign_invitation', 'campaign_invitation.id = campaign_participation.campaign_invitation_id', null)->where('campaign_invitation.consumer_id = ?', $consumer->id)->where('campaign_invitation.campaign_id = ?', $campaignId)->where("campaign_participation.state != 'COMPLETED'"); $isExist = $db->fetchAll($select2); // Zend_Debug::dump($isExist[0]['campaign_invitation_id']); if ($isExist != null) { $campaing_participateModel = new CampaignParticipation(); $campaign_participation = $campaing_participateModel->fetchRow('campaign_invitation_id = ' . $isExist[0]['campaign_invitation_id']); $campaign_participation->state = 'COMPLETED'; $campaign_participation->save(); //add 200 points for member in reward_point_transaction_record $rewardPointTransactionRecordModel = new RewardPointTransactionRecord(); $rewardPointTransaction = array("consumer_id" => $consumer->id, "date" => date("Y-m-d H:i:s"), "transaction_id" => "5", "point_amount" => "200"); $id = $rewardPointTransactionRecordModel->insert($rewardPointTransaction); //2011-05-13 change the rank of consumer $rankModel = new Rank(); $rankModel->changeConsumerRank($consumer->id); } } }