function adminindexAction() { $this->view->title = "All Participations"; $this->view->activeTab = "List Participations"; $this->campaign_id = $this->_request->getParam('id'); $this->tag = $this->_request->getParam('tag'); $db = Zend_Registry::get('db'); $select = $db->select(); $select->from('campaign', null); $select->join('campaign_invitation', 'campaign.id = campaign_invitation.campaign_id', 'state'); if ($this->tag) { $select->join('consumer', "consumer.id = campaign_invitation.consumer_id and tags like '%{$this->tag},%'"); } else { $select->join('consumer', "consumer.id = campaign_invitation.consumer_id "); } $select->join('campaign_participation', 'campaign_invitation.id = campaign_participation.campaign_invitation_id', array('accept_date', 'state')); $select->where('campaign_invitation.campaign_id = ?', $this->campaign_id)->where('consumer.pest is null or consumer.pest != 1'); $this->view->campaignParticipations = $db->fetchAll($select); $this->view->campaign_id = $this->campaign_id; $this->view->tag = $this->tag; // $this->_helper->layout->disableLayout(); //print_r($this->view->campaignParticipations);die; $this->_helper->layout->setLayout("layout_admin"); //extract the profile survey $profileSurvey = new ProfileSurvey(); $this->view->profilesurvey = $profileSurvey->fetchAll('id !=12'); }
function admincreategroupAction() { $request = $this->getRequest(); //1.get all campaign $campaign = new Campaign(); $order = "expire_date desc"; $this->view->campaigns = $campaign->fetchAll(null, $order, null, null); //2.get all profile_survey $profileSurveyModel = new ProfileSurvey(); $this->view->profilesurveys = $profileSurveyModel->find_by_condition(); //3.execute sql $profileSurveyGroupModel = new ProfileSurveyGroup(); if ($request->isPost()) { $formData = $request->getPost(); $sql = $formData['sql']; if ($sql == null || $sql == '') { return; } else { $sql = 'select consumer.id ' . $sql; } $campaignId = $formData['campaign_id']; $profileSurveyId = $formData['profile_survey_id']; $comment = $formData['comment']; $currentTime = date("Y-m-d H:i:s"); //get all consumer id $db = Zend_Registry::get('db'); $result = $db->query($sql); $consumers = $result->fetchAll(); //4.save ProfileSurveyGroup $newProfileSurveyGroupId = $profileSurveyGroupModel->createRecord(count($consumers), $campaignId, $profileSurveyId, $currentTime, $comment); //5.insert profile survey group consumer $profileSurveyGroupConsumerModel = new ProfileSurveyGroupConsumer(); foreach ($consumers as $row) { $profileSurveyGroupConsumerModel->createRecord($newProfileSurveyGroupId, $row['id']); } } //4.get all profile survey group $this->view->profilesurveygroups = $profileSurveyGroupModel->find_by_condition('id asc'); //Zend_Debug::dump($this->view->profilesurveygroups); $this->_helper->layout->setLayout("layout_admin"); }
public function admindownloadindexAction() { $this->view->title = 'Reports'; $this->view->activeTab = 'Reports'; $this->_helper->layout->setLayout("layout_admin"); $profileSurveyModel = new ProfileSurvey(); $this->view->profileSurvey = $profileSurveyModel->fetchAll(); $campaignModel = new Campaign(); $this->view->campaigns = $campaignModel->fetchAll(); }