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);
}
