X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fsurvey%2Fsurvey.inc.php;h=296f03b95ff1b27a054ba7d43deb9e3d8f6945ae;hb=5f317a8d97f36d3a201149039b6996586b57826d;hp=7e715fd9fbc9d481c91212a2d34b0db63795b86f;hpb=956cd5c10a027f75283d91545a5d5feeed1874ef;p=platal.git diff --git a/modules/survey/survey.inc.php b/modules/survey/survey.inc.php index 7e715fd..296f03b 100644 --- a/modules/survey/survey.inc.php +++ b/modules/survey/survey.inc.php @@ -1,6 +1,6 @@ "sondage ouvert à tout le monde, anonyme", + self::MODE_XANON => "sondage restreint aux polytechniciens, anonyme", + self::MODE_XIDENT => "sondage restreint aux polytechniciens, non anonyme"); + private static $shortModes = array(self::MODE_ALL => "tout le monde, anonyme", + self::MODE_XANON => "polytechniciens, anonyme", + self::MODE_XIDENT => "polytechniciens, non anonyme"); + + public static function getModes($long = true) { + return ($long)? self::$longModes : self::$shortModes; + } + + private static $types = array('text' => 'Texte court', + 'textarea' => 'Texte long', + 'num' => 'Numérique', + 'radio' => 'Choix multiples (une réponse)', + 'checkbox' => 'Choix multiples (plusieurs réponses)', + 'radiotable' => 'Questions multiples à choix multiples (une réponse)', + 'checkboxtable' => 'Questions multiples à choix mutliples (plusieurs réponses)'); - public function __construct() + public static function getTypes() { - parent::__construct('surveys'); - $this->registerFieldValidator('shortname', 'ShortNameFieldValidator'); - $this->registerFieldFormatter('voters', 'JSonFieldFormatter'); - $this->registerFieldFormatter('viewers', 'JSonFieldFormatter'); + return self::$types; } - protected function postFetch() + public static function isType($t) { - if (!is_null($this->voters)) { - $this->voterFilter = UserFilter::fromExportedConditions($this->voters); - } else { - $this->voterFilter = null; - } - if (!is_null($this->viewers)) { - $this->viewerFilter = UserFilter::fromExportedConditions($this->viewers); - } else { - $this->viewerFilter = null; + return array_key_exists($t, self::$types); + } + // }}} + + // {{{ properties, constructor and basic methods + private $id; + private $title; + private $description; + private $end; + private $mode; + private $promos; + private $valid; + private $questions; + private $creator; + + public function __construct($args, $id = -1, $valid = false, $questions = null) + { + $this->update($args); + $this->id = $id; + $this->valid = $valid; + $this->questions = ($questions == null)? array() : $questions; + } + + public function update($args) + { + $this->title = $args['title']; + $this->description = $args['description']; + $this->end = $args['end']; + $this->mode = (isset($args['mode']))? $args['mode'] : self::MODE_ALL; + $this->creator = $args['uid']; + if ($this->mode == self::MODE_ALL) { + $args['promos'] = ''; } - if (!$this->fetchQuestions) { + $args['promos'] = str_replace(' ', '', $args['promos']); + $this->promos = ($args['promos'] == '' || preg_match('#^(\d{4}-?|(\d{4})?-\d{4})(,(\d{4}-?|(\d{4})?-\d{4}))*$#', $args['promos']))? $args['promos'] : '#'; + } + + public function canSeeEarlyResults(User $user) + { + return $user->id() == $this->creator || $user->checkPerms('admin'); + } + // }}} + + // {{{ functions to access general information + public function isMode($mode) + { + return ($this->mode == $mode); + } + + public function checkPromo($promo) + { + if ($this->promos == '') { return true; } - $selector = new SurveyQuestion($this); - $selector->sid = $this->id; - - $stack = array(); - foreach ($selector as $question) { - $question = $question->typedInstance(); - if (is_null($question->parent)) { - $this->addQuestion($question); + $promos = explode(',', $this->promos); + foreach ($promos as $p) { + if ((preg_match('#^\d{4}$#', $p) && $p == $promo) || + (preg_match('#^\d{4}-$#', $p) && intval(substr($p, 0, 4)) <= $promo) || + (preg_match('#^-\d{4}$#', $p) && intval(substr($p, 1)) >= $promo) || + (preg_match('#^\d{4}-\d{4}$#', $p) && + (intval(substr($p, 0, 4)) <= $promo && intval(substr($p, 5)) >= $promo || + intval(substr($p, 0, 4)) >= $promo && intval(substr($p, 5)) <= $promo ))) { + return true; + } + } + return false; + } + + public function isValid() + { + return $this->valid; + } + + public function isEnded() + { + return (strtotime($this->end) - time() <= 0); + } + + public function getTitle() + { + return $this->title; + } + // }}} + + // {{{ function toArray() : converts a question (or the whole survey) to array, with results if the survey is ended + public function toArray($i = 'all') + { + if ($i != 'all' && $i != 'root') { // if a specific question is requested, then just returns this question converted to array + $i = intval($i); + if (array_key_exists($i, $this->questions)) { + return $this->questions[$i]->toArray(); } else { - $pos = count($stack) - 1; - while ($stack[$pos]->qid != $question->parent) { - --$pos; - array_pop($stack); + return null; + } + } else { // else returns the root converted to array in any case + $a = array('title' => $this->title, + 'description' => $this->description, + 'end' => $this->end, + 'mode' => $this->mode, + 'promos' => $this->promos, + 'valid' => $this->valid, + 'type' => 'root'); + if ($this->id != -1) { + $a['id'] = $this->id; + } + if ($this->isEnded()) { // if the survey is ended, then adds here the number of votes + $sql = 'SELECT COUNT(id) + FROM survey_votes + WHERE survey_id={?};'; + $tot = XDB::query($sql, $this->id); + $a['votes'] = $tot->fetchOneCell(); + } + if ($i == 'all' && count($this->questions) > 0) { // if the whole survey is requested, then returns all the questions converted to array + $qArr = array(); + for ($k = 0; $k < count($this->questions); $k++) { + $q = $this->questions[$k]->toArray(); + $q['id'] = $k; + if ($this->isEnded()) { // if the survey is ended, then adds here the results of this question + $q['result'] = $this->questions[$k]->getResultArray($this->id, $k); + } + $qArr[$k] = $q; } - Platal::assert(count($stack) > 0, "Invalid question structure"); - Platal::assert($stack[$pos] instanceof SurveyQuestionContainer, "Invalid question type"); - $stack[$pos]->addQuestion($question); + $a['questions'] = $qArr; } - array_push($stack, $question); + return $a; } - return true; } + // }}} + + // {{{ function toCSV() : builds a CSV file containing all the results of the survey + public function toCSV($sep = ',', $enc = '"', $asep='|') + { + $nbq = count($this->questions); + //require_once dirname(__FILE__) . '/../../classes/varstream.php'; + VarStream::init(); + global $csv_output; + $csv_output = ''; + $csv = fopen('var://csv_output', 'w'); + $line = ($this->isMode(self::MODE_XIDENT))? array('id', 'Nom', 'Prenom', 'Promo') : array('id'); + $qids = array(); + for ($qid = 0; $qid < $nbq; $qid++) { + $qids[$qid] = count($line); // stores the first id of a question (in case of questions with subquestions) + array_splice($line, count($line), 0, $this->questions[$qid]->getCSVColumns()); // the first line contains the questions + } + $nbf = count($line); + $users = array(); + if ($this->isMode(self::MODE_XIDENT)) { // if the mode is non anonymous + $users = XDB::fetchAllAssoc('vid', 'SELECT v.id AS vid, v.uid + FROM survey_votes AS v + WHERE v.survey_id = {?} + ORDER BY vid ASC', + $this->id); + } + $sql = 'SELECT v.id AS vid, a.question_id AS qid, a.answer AS answer + FROM survey_votes AS v + INNER JOIN survey_answers AS a ON a.vote_id=v.id + WHERE v.survey_id={?} + ORDER BY vid ASC, qid ASC, answer ASC'; + $res = XDB::iterator($sql, $this->id); // retrieves all answers from database + $vid = -1; + $vid_ = 0; + while (($cur = $res->next()) != null) { + if ($vid != $cur['vid']) { // if the vote id changes, then starts a new line + fputcsv($csv, $line, $sep, $enc); // stores the former line into $csv_output + $vid = $cur['vid']; + $line = array_fill(0, $nbf, ''); // creates an array full of empty string + $line[0] = $vid_; // the first field is a 'clean' vote id (not the one stored in database) + if ($this->isMode(self::MODE_XIDENT)) { // if the mode is non anonymous + if (array_key_exists($vid, $users)) { // and if the user data can be found + $user=PlUser::getWithUID($users[$vid]); + $line[1] = $user->lastName(); // adds the user data (in the first fields of the line) + $line[2] = $user->firstName(); + $line[3] = $user->promo(); + } + } + $vid_++; + } + $ans = $this->questions[$cur['qid']]->formatAnswer($cur['answer']); // formats the current answer + if (!is_null($ans)) { + if (is_array($ans)) { + $fid = $qids[$cur['qid']] + $ans['id']; // computes the field id + $a = $ans['answer']; + } else { + $fid = $qids[$cur['qid']]; + $a = $ans; + } + if ($line[$fid] != '') { // if this field already contains something + $line[$fid] .= $asep; // then adds a separator before adding the new answer + } + $line[$fid] .= $a; // adds the current answer to the correct field + } + } + fputcsv($csv, $line, $sep, $enc); // stores the last line into $csv_output + return $csv_output; + } + // }}} - protected function preSave() + // {{{ function factory($type, $args) : builds a question according to the given type + public function factory($t, $args) { - if (!is_null($this->voterFilter)) { - $this->voters = $this->voterFilter->exportConditions(); + switch ($t) { + case 'text': + return new SurveyText($args); + case 'textarea': + return new SurveyTextarea($args); + case 'num': + return new SurveyNum($args); + case 'radio': + return new SurveyRadio($args); + case 'checkbox': + return new SurveyCheckbox($args); + case 'radiotable': + return new SurveyRadioTable($args); + case 'checkboxtable': + return new SurveyCheckboxTable($args); + default: + return null; + } + } + // }}} + + // {{{ questions manipulation functions + public function addQuestion($i, $c) + { + $i = intval($i); + if ($this->valid || $i > count($this->questions)) { + return false; } else { - $this->voters = null; + array_splice($this->questions, $i, 0, array($c)); + return true; } - if (!is_null($this->viewerFilter)) { - $this->viewers = $this->viewerFilter->exportConditions(); + } + + public function delQuestion($i) + { + $i = intval($i); + if ($this->valid || !array_key_exists($i, $this->questions)) { + return false; } else { - $this->viewers = null; + array_splice($this->questions, $i, 1); + return true; + } + } + + public function editQuestion($i, $a) + { + if ($i == 'root') { + $this->update($a); + } else { + $i = intval($i); + if ($this->valid ||!array_key_exists($i, $this->questions)) { + return false; + } else { + $this->questions[$i]->update($a); + } } return true; } + // }}} + + // {{{ function checkSyntax() : checks syntax of the questions (currently the root only) before storing the survey in database + private static $errorMessages = array( + "datepassed" => "la date de fin de sondage est déjà dépassée : vous devez préciser une date future", + "promoformat" => "les restrictions à certaines promotions sont mal formattées" + ); - protected function postSave() + public function checkSyntax() { - $questions = array(); - $selector = new SurveyQuestion($this); - $selector->sid = $this->id; - $selector->delete(); + $rArr = array(); + // checks that the end date given is not already passed + // (unless the survey has already been validated : an admin can have a validated survey expired) + if (!$this->valid && $this->isEnded()) { + $rArr[] = array('question' => 'root', 'error' => self::$errorMessages["datepassed"]); + } + if ($this->promos != '' && !preg_match('#^(\d{4}-?|(\d{4})?-\d{4})(,(\d{4}-?|(\d{4})?-\d{4}))*$#', $this->promos)) { + $rArr[] = array('question' => 'root', 'error' => self::$errorMessages["promoformat"]); + } + return (empty($rArr))? null : $rArr; + } + // }}} - $this->reassignQuestionIds(); - foreach ($this->questions as $question) { - $question->sid = $this->id; - $question->insert(); + // {{{ functions that manipulate surveys in database + // {{{ static function retrieveList() : gets the list of available survey (current, old and not validated surveys) + public static function retrieveList($type, $tpl = true) + { + switch ($type) { + case 'c': + case 'current': + $where = 'end > NOW()'; + break; + case 'o': + case 'old': + $where = 'end <= NOW()'; + break; + default: + return null; + } + if (!S::user()->checkPerms(PERMS_USER)) { + $where .= XDB::format(' AND mode = {?}', self::MODE_ALL); + } + $sql = 'SELECT id, title, uid, end, mode + FROM surveys + WHERE '.$where.' + ORDER BY end DESC;'; + if ($tpl) { + return XDB::iterator($sql); + } else { + return XDB::iterRow($sql); } } + // }}} - public function clearQuestions() + // {{{ static function retrieveSurvey() : gets a survey in database (and unserialize the survey object structure) + public static function retrieveSurvey($sid) { - $this->fetchQuestions = true; - $this->questions = array(); + $sql = 'SELECT questions, title, description, end, mode, promos, uid + FROM surveys + WHERE id={?}'; + $res = XDB::query($sql, $sid); + $data = $res->fetchOneAssoc(); + if (is_null($data) || !is_array($data)) { + return null; + } + $survey = new Survey($data, $sid, true, unserialize($data['questions'])); + return $survey; } + // }}} - public function addQuestion(SurveyQuestion $question, $pos = null) + // {{{ static function retrieveSurveyInfo() : gets information about a survey (title, description, end date, restrictions) but does not unserialize the survey object structure + public static function retrieveSurveyInfo($sid) { - $question->parent = null; - if (is_null($pos)) { - $this->questions[] = $question; - } else { - array_splice($this->questions, $pos, 0, $question); + $sql = 'SELECT title, description, end, mode, promos + FROM surveys + WHERE id={?}'; + $res = XDB::query($sql, $sid); + return $res->fetchOneAssoc(); + } + // }}} + + // {{{ static function retrieveSurveyReq() : gets a survey request to validate + public static function retrieveSurveyReq($id) + { + $surveyreq = Validate::get_request_by_id($id); + if ($surveyreq == null) { + return null; } + $data = array('title' => $surveyreq->title, + 'description' => $surveyreq->description, + 'end' => $surveyreq->end, + 'mode' => $surveyreq->mode, + 'promos' => $surveyreq->promos); + $survey = new Survey($data, $id, false, $surveyreq->questions); + return $survey; } + // }}} - public function newQuestion($type, $pos = null) + // {{{ function proposeSurvey() : stores a proposition of survey in database (before validation) + public function proposeSurvey() { - $question = SurveyQuestion::instanceForType($this, $type); - $this->addQuestion($question, $pos); - return $question; + $surveyreq = new SurveyReq($this->title, $this->description, $this->end, $this->mode, $this->promos, $this->questions, S::user()); + return $surveyreq->submit(); } + // }}} - public function questionForId($qid) + // {{{ function updateSurvey() : updates a survey in database (before validation) + public function updateSurvey() { - $prev = null; - foreach ($this->questions as $question) { - if ($qid == $question->qid) { - return $question; - } else if ($qid < $question->qid) { - Platal::assert($prev instanceof SurveyQuestionGroup, - "Id gap must be caused by question groups"); - return $prev->child($qid); + if ($this->valid) { + $sql = 'UPDATE surveys + SET questions={?}, + title={?}, + description={?}, + end={?}, + mode={?}, + promos={?} + WHERE id={?};'; + return XDB::execute($sql, serialize($this->questions), $this->title, $this->description, $this->end, $this->mode, $this->promos, $this->id); + } else { + $surveyreq = Validate::get_request_by_id($this->id); + if ($surveyreq == null) { + return false; } - $prev = $question; + return $surveyreq->updateReq($this->title, $this->description, $this->end, $this->mode, $this->promos, $this->questions); } - Platal::assert($prev instanceof SurveyQuestionGroup, - "Id gap must be caused by question groups"); - return $prev->child($qid); } + // }}} - public function reassignQuestionIds() + // {{{ functions vote() and hasVoted() : handles vote to a survey + public function vote($uid, $args) { - $id = 0; - foreach ($this->questions as $question) { - $question->qid = $id; - if ($question instanceof SurveyQuestionContainer) { - $id = $question->reassignQuestionIds(); - } else { - $id++; + XDB::execute('INSERT INTO survey_votes + SET survey_id = {?}, uid = {?}', + $this->id, ($uid == 0) ? null : $uid); // notes the user as having voted + $vid = XDB::insertId(); + for ($i = 0; $i < count($this->questions); $i++) { + $ans = $this->questions[$i]->checkAnswer($args[$i]); + if (!is_null($ans) && is_array($ans)) { + foreach ($ans as $a) { + XDB::execute('INSERT INTO survey_answers + SET vote_id = {?}, + question_id = {?}, + answer = {?}', $vid, $i, $a); + } } } - return $id; } - public function export() + public function hasVoted($uid) { - $export = parent::export(); - $export['questions'] = $this->exportQuestions(); - return $export; + $res = XDB::query('SELECT id + FROM survey_votes + WHERE survey_id = {?} AND uid = {?};', $this->id, $uid); // checks whether the user has already voted + return ($res->numRows() != 0); } + // }}} - public function exportQuestions() + // {{{ static function deleteSurvey() : deletes a survey (and all its votes) + public static function deleteSurvey($sid) { - $export = array(); - foreach ($this->questions as $question) { - $export[] = $question->export(); - } - return $export; + $sql = 'DELETE s.*, v.*, a.* + FROM surveys AS s + LEFT JOIN survey_votes AS v + ON v.survey_id=s.id + LEFT JOIN survey_answers AS a + ON a.vote_id=v.id + WHERE s.id={?};'; + return XDB::execute($sql, $sid); } + // }}} - public function exportQuestionsToJSON() + // {{{ static function purgeVotes() : clears all votes concerning a survey (I'm not sure whether it's really useful) + public static function purgeVotes($sid) { - return json_encode($this->exportQuestions()); + $sql = 'DELETE v.*, a.* + FROM survey_votes AS v + LEFT JOIN survey_answers AS a + ON a.vote_id=v.id + WHERE v.survey_id={?};'; + return XDB::execute($sql, $sid); } + // }}} + + // }}} +} +// }}} + +// {{{ abstract class SurveyQuestion +abstract class SurveyQuestion +{ + // {{{ common properties, constructor, and basic methods + private $question; + private $comment; - /* Return an indicator of the progression of the survey: - * negative values means 'the survey is not started' - * 0 means 'the survey is in progress' - * positive values means 'the survey expired' - */ - public function progression() + public function __construct($args) { - if (!$this->flags->hasFlag('validated')) { - return -2; - } - $now = time(); - if ($this->begin->format('U') > $now) { - return -1; - } - if ($this->end->format('U') <= $now) { - return 1; - } - return 0; + $this->update($args); } - public function canSee(User $user) + public function update($a) { - if ($this->canSeeResults($user) || $this->canVote($user)) { - return true; - } - return false; + $this->question = $a['question']; + $this->comment = $a['comment']; } - public function canSeeResults(User $user) + abstract protected function getQuestionType(); + // }}} + + // {{{ function toArray() : converts to array + public function toArray() { - if ($user->id() == $this->uid || $user->hasFlag('admin')) { - return true; - } - if (is_null($this->viewerFilter)) { - return $this->viewerFilter->checkUser($user); + return array('type' => $this->getQuestionType(), 'question' => $this->question, 'comment' => $this->comment); + } + // }}} + + // {{{ function checkSyntax() : checks question elements (before storing into database), not currently needed (with new structure) + protected function checkSyntax() + { + return null; + } + // }}} + + // {{{ function checkAnswer : returns a correct answer (or a null value if error) + public function checkAnswer($ans) + { + return null; + } + // }}} + + // {{{ functions regarding the results of a survey + abstract public function getResultArray($sid, $qid); + + public function formatAnswer($ans) + { + return $ans; + } + + public function getCSVColumns() + { + return $this->question; + } + // }}} +} +// }}} + +// {{{ abstract class SurveySimple and its derived classes : "open" questions +// {{{ abstract class SurveySimple extends SurveyQuestion +abstract class SurveySimple extends SurveyQuestion +{ + public function checkAnswer($ans) + { + return array($ans); + } + + public function getResultArray($sid, $qid) + { + $sql = 'SELECT answer + FROM survey_answers + WHERE vote_id IN (SELECT id FROM survey_votes WHERE survey_id={?}) + AND question_id={?} + ORDER BY RAND() + LIMIT 5;'; + $res = XDB::query($sql, $sid, $qid); + return $res->fetchAllAssoc(); + } +} +// }}} + +// {{{ class SurveyText extends SurveySimple : simple text field, allowing a few words +class SurveyText extends SurveySimple +{ + public function getQuestionType() + { + return "text"; + } +} +// }}} + +// {{{ class SurveyTextarea extends SurveySimple : textarea field, allowing longer comments +class SurveyTextarea extends SurveySimple +{ + public function getQuestionType() + { + return "textarea"; + } +} +// }}} + +// {{{ class SurveyNum extends SurveySimple : allows numerical answers +class SurveyNum extends SurveySimple +{ + public function checkAnswer($ans) + { + return array(intval($ans)); + } + + protected function getQuestionType() + { + return "num"; + } +} +// }}} +// }}} + +// {{{ abstract class SurveyList and its derived classes : restricted questions that allows only a list of possible answers +// {{{ abstract class SurveyList extends SurveyQuestion +abstract class SurveyList extends SurveyQuestion +{ + protected $choices; + + public function update($args) + { + parent::update($args); + $this->choices = array(); + foreach ($args['choices'] as $val) { + if (trim($val) || trim($val) == '0') { + $this->choices[] = $val; + } } - return false; } - public function canVote(User $user) + public function toArray() { - $status = $this->progression(); - if ($status < 0) { - return "Ce sondage n'est pas encore commencé"; - } else if ($status > 0) { - return "Ce sondage est terminé"; + $rArr = parent::toArray(); + $rArr['choices'] = $this->choices; + return $rArr; + } + + public function getResultArray($sid, $qid) + { + $sql = 'SELECT answer, COUNT(id) AS count + FROM survey_answers + WHERE vote_id IN (SELECT id FROM survey_votes WHERE survey_id={?}) + AND question_id={?} + GROUP BY answer ASC'; + $res = XDB::query($sql, $sid, $qid); + return $res->fetchAllAssoc(); + } + + public function formatAnswer($ans) + { + if (array_key_exists($ans, $this->choices)) { + return $this->choices[$ans]; + } else { + return null; } - if (!is_null($this->voterFilter) && !$this->voterFilter->checkUser($user)) { - return "Ce sondage ne s'adresse pas à toi"; + } +} +// }}} + +// {{{ class SurveyRadio extends SurveyList : radio question, allows one answer among the list offered +class SurveyRadio extends SurveyList +{ + public function checkAnswer($ans) + { + $a = intval($ans); + return (array_key_exists($a, $this->choices))? array($a) : null; + } + + protected function getQuestionType() + { + return "radio"; + } +} +// }}} + +// {{{ class SurveyCheckbox extends SurveyList : checkbox question, allows any number of answers among the list offered +class SurveyCheckbox extends SurveyList +{ + public function checkAnswer($ans) + { + $rep = array(); + foreach ($ans as $a) { + $a = intval($a); + if (array_key_exists($a, $this->choices)) { + $rep[] = $a; + } } - $vote = SurveyVote::getVote($this, $user, false); - if (is_null($vote)) { - return "Tu as déjà voté à ce sondage."; + return (count($rep) == 0)? null : $rep; + } + + protected function getQuestionType() + { + return "checkbox"; + } +} +// }}} +// }}} + +// {{{ abstract class SurveyTable and its derived classes : table question, each column represents a choice, each line represents a question +// {{{ abstract class SurveyTable extends SurveyList +abstract class SurveyTable extends SurveyList +{ + protected $subquestions; + + public function update($args) + { + parent::update($args); + $this->subquestions = array(); + foreach ($args['subquestions'] as $val) { + if (trim($val) || trim($val) == '0') { + $this->subquestions[] = $val; + } } - return true; } - public function vote(User $user, array $answers) + public function toArray() { - if (!$this->canVote($user)) { - return array('survey' => "Tu n'es pas autorisé à voter à ce sondage."); + $rArr = parent::toArray(); + $rArr['subquestions'] = $this->subquestions; + return $rArr; + } + + public function getResultArray($sid, $qid) + { + $sql = 'SELECT answer, COUNT(id) AS count + FROM survey_answers + WHERE vote_id IN (SELECT id FROM survey_votes WHERE survey_id={?}) + AND question_id={?} + GROUP BY answer ASC'; + $res = XDB::iterator($sql, $sid, $qid); + $result = array(); + for ($i = 0; $i < count($this->subquestions); $i++) { + $result[$i] = array_fill(0, count($this->choices), 0); } - $vote = SurveyVote::getVote($this, $user); - if (is_null($vote)) { - return $vote; + while ($r = $res->next()) { + list($i, $j) = explode(':', $r['answer']); + $result[$i][$j] = $r['count']; } - $answers = new PlDict($answers); - foreach ($this->questions as $question) { - $question->vote($vote, $answers); + return $result; + } + + public function formatAnswer($ans) + { + list($q, $c) = explode(':', $ans); + if (array_key_exists($q, $this->subquestions) && array_key_exists($c, $this->choices)) { + return array('id' => $q, 'answer' => $this->choices[$c]); + } else { + return null; } - return $vote; } - public static function get($name, $fetchQuestions = true) + public function getCSVColumns() { - if (is_array($name)) { - $name = $name[0]; + $q = parent::getCSVColumns(); + if (empty($this->subquestions)) { + return $q; } - $survey = new Survey(); - $survey->fetchQuestions = $fetchQuestions; - if (can_convert_to_integer($name)) { - $survey->id = $name; - } else { - $survey->shortname = $name; + $a = array(); + for ($k = 0; $k < count($this->subquestions); $k++) { + $a[$k] = $q.' : '.$this->subquestions[$k]; } - if (!$survey->fetch()) { - return null; + return $a; + } +} +// }}} + +// {{{ class SurveyRadioTable extends SurveyTable : SurveyTable with radio type choices +class SurveyRadioTable extends SurveyTable +{ + public function checkAnswer($ans) + { + $rep = array(); + foreach ($ans as $k => $a) { + if (!array_key_exists($k, $this->subquestions)) { + continue; + } + $a = intval($a); + if (array_key_exists($a, $this->choices)) { + $rep[] = $k . ':' . $a; + } } - return $survey; + return (count($rep) == 0)? null : $rep; } - public static function iterActive() + protected function getQuestionType() { - $survey = new Survey(); - $survey->fetchQuestions = false; - return $survey->iterateOnCondition('begin <= CURDATE() AND end >= CURDATE() - AND FIND_IN_SET(\'validated\', flags)'); + return "radiotable"; } + } +// }}} -class ShortNameFieldValidator implements PlDBTableFieldValidator +// {{{ class SurveyCheckboxTable extends SurveyTable : SurveyTable with checkbox type choices +class SurveyCheckboxTable extends SurveyTable { - public function __construct(PlDBTableField $field, $value) + public function checkAnswer($ans) { - if (can_convert_to_integer($value) || !preg_match('/^[a-z0-9]+[-_\.a-z0-9]*[a-z0-9]+$/i', $value)) { - throw new PlDBBadValueException($value, $field, - 'The shortname can only contain alphanumerical caracters, dashes, underscores and dots'); + $rep = array(); + foreach ($ans as $k => $aa) { + if (!array_key_exists($k, $this->subquestions)) { + continue; + } + foreach ($aa as $a) { + $a = intval($a); + if (array_key_exists($a, $this->choices)) { + $rep[] = $k . ':' . $a; + } + } } + return (count($rep) == 0)? null : $rep; + } + + protected function getQuestionType() + { + return "checkboxtable"; } + } +// }}} +// }}} -// vim:set et sw=4 sts=4 ts=4 foldmethod=marker enc=utf-8: +// vim:set et sw=4 sts=4 ts=4 foldmethod=marker fenc=utf-8: ?>