public function view() { $u = new User(); $ui = UserInfo::getByID($u->getUserID()); $dh = Core::make('helper/date'); /* @var $dh \Concrete\Core\Localization\Service\Date */ if (is_object($ui)) { $this->set('uLastLogin', $dh->formatDateTime($ui->getLastLogin())); $this->set('uName', $ui->getUserName()); $this->set('lastEditSite', $dh->formatDateTime(PageStatistics::getSiteLastEdit())); $llu = UserStatistics::getLastLoggedInUser(); if ($llu->getUserID() == $u->getUserID()) { $this->set('lastLoginSite', t('Your login is the most recent.')); } else { $this->set('lastLoginSite', $dh->formatDateTime($llu->getLastLogin())); } } $this->set('totalFormSubmissions', FormBlockStatistics::getTotalSubmissions()); $this->set('totalFormSubmissionsToday', FormBlockStatistics::getTotalSubmissions(date('Y-m-d'))); }
private function loadSurveyResponses() { $c = Page::getCurrentPage(); $db = Loader::db(); $tempMiniSurvey = new MiniSurvey(); $pageBase = \URL::to($c); if ($_REQUEST['action'] == 'deleteForm') { if (!Loader::helper('validation/token')->validate('deleteForm')) { $this->error->add(t('Invalid Token.')); } else { $this->deleteForm($_REQUEST['bID'], $_REQUEST['qsID']); } } if ($_REQUEST['action'] == 'deleteFormAnswers') { if (!Loader::helper('validation/token')->validate('deleteFormAnswers')) { $this->error->add(t('Invalid Token.')); } else { $this->deleteFormAnswers($_REQUEST['qsID']); $this->redirect('/dashboard/reports/forms'); } } if ($_REQUEST['action'] == 'deleteResponse') { if (!Loader::helper('validation/token')->validate('deleteResponse')) { $this->error->add(t('Invalid Token.')); } else { $this->deleteAnswers($_REQUEST['asid']); } } //load surveys $surveysRS = FormBlockStatistics::loadSurveys($tempMiniSurvey); //index surveys by question set id $surveys = array(); while ($survey = $surveysRS->fetchRow()) { //get Survey Answers $survey['answerSetCount'] = MiniSurvey::getAnswerCount($survey['questionSetId']); $surveys[$survey['questionSetId']] = $survey; } //load requested survey response if (!empty($_REQUEST['qsid'])) { $questionSet = intval(preg_replace('/[^[:alnum:]]/', '', $_REQUEST['qsid'])); //get Survey Questions $questionsRS = MiniSurvey::loadQuestions($questionSet); $questions = array(); while ($question = $questionsRS->fetchRow()) { $questions[$question['msqID']] = $question; } //get Survey Answers $answerSetCount = MiniSurvey::getAnswerCount($questionSet); //pagination $pageBaseSurvey = $pageBase . '?qsid=' . $questionSet; $paginator = Loader::helper('pagination'); $sortBy = $_REQUEST['sortBy']; $paginator->init((int) $_REQUEST['page'], $answerSetCount, $pageBaseSurvey . '&page=%pageNum%&sortBy=' . $sortBy, $this->pageSize); if ($this->pageSize > 0) { $limit = $paginator->getLIMIT(); } else { $limit = ''; } $answerSets = FormBlockStatistics::buildAnswerSetsArray($questionSet, $sortBy, $limit); } $this->set('questions', $questions); $this->set('answerSets', $answerSets); $this->set('paginator', $paginator); $this->set('questionSet', $questionSet); $this->set('surveys', $surveys); }