Remove all password-related pages from X.net
[platal.git] / modules / survey / survey.inc.php
CommitLineData
8fe81c50 1<?php
2/***************************************************************************
5e1513f6 3 * Copyright (C) 2003-2011 Polytechnique.org *
8fe81c50 4 * http://opensource.polytechnique.org/ *
5 * *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
10 * *
11 * This program is distributed in the hope that it will be useful, *
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
14 * GNU General Public License for more details. *
15 * *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
18 * Foundation, Inc., *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
21
905ab104
FB
22// {{{ class Survey : root of any survey, contains all questions
23class Survey
8fe81c50 24{
905ab104
FB
25 // {{{ static properties and functions, regarding survey modes and question types
26 const MODE_ALL = 0;
27 const MODE_XANON = 1;
28 const MODE_XIDENT = 2;
29 private static $longModes = array(self::MODE_ALL => "sondage ouvert à tout le monde, anonyme",
30 self::MODE_XANON => "sondage restreint aux polytechniciens, anonyme",
31 self::MODE_XIDENT => "sondage restreint aux polytechniciens, non anonyme");
32 private static $shortModes = array(self::MODE_ALL => "tout le monde, anonyme",
33 self::MODE_XANON => "polytechniciens, anonyme",
34 self::MODE_XIDENT => "polytechniciens, non anonyme");
35
36 public static function getModes($long = true) {
37 return ($long)? self::$longModes : self::$shortModes;
38 }
39
40 private static $types = array('text' => 'Texte court',
41 'textarea' => 'Texte long',
42 'num' => 'Numérique',
43 'radio' => 'Choix multiples (une réponse)',
44 'checkbox' => 'Choix multiples (plusieurs réponses)',
45 'radiotable' => 'Questions multiples à choix multiples (une réponse)',
46 'checkboxtable' => 'Questions multiples à choix mutliples (plusieurs réponses)');
8fe81c50 47
905ab104 48 public static function getTypes()
8fe81c50 49 {
905ab104 50 return self::$types;
8fe81c50 51 }
52
905ab104 53 public static function isType($t)
8fe81c50 54 {
905ab104
FB
55 return array_key_exists($t, self::$types);
56 }
57 // }}}
58
59 // {{{ properties, constructor and basic methods
60 private $id;
61 private $title;
62 private $description;
63 private $end;
64 private $mode;
65 private $promos;
66 private $valid;
67 private $questions;
68 private $creator;
69
70 public function __construct($args, $id = -1, $valid = false, $questions = null)
71 {
72 $this->update($args);
73 $this->id = $id;
74 $this->valid = $valid;
75 $this->questions = ($questions == null)? array() : $questions;
76 }
77
78 public function update($args)
79 {
80 $this->title = $args['title'];
81 $this->description = $args['description'];
82 $this->end = $args['end'];
83 $this->mode = (isset($args['mode']))? $args['mode'] : self::MODE_ALL;
84 $this->creator = $args['uid'];
85 if ($this->mode == self::MODE_ALL) {
86 $args['promos'] = '';
90343d1e 87 }
905ab104
FB
88 $args['promos'] = str_replace(' ', '', $args['promos']);
89 $this->promos = ($args['promos'] == '' || preg_match('#^(\d{4}-?|(\d{4})?-\d{4})(,(\d{4}-?|(\d{4})?-\d{4}))*$#', $args['promos']))? $args['promos'] : '#';
90 }
91
92 public function canSeeEarlyResults(User $user)
93 {
94 return $user->id() == $this->creator || $user->checkPerms('admin');
95 }
96 // }}}
97
98 // {{{ functions to access general information
99 public function isMode($mode)
100 {
101 return ($this->mode == $mode);
102 }
103
104 public function checkPromo($promo)
105 {
106 if ($this->promos == '') {
4b8c8634 107 return true;
108 }
905ab104
FB
109 $promos = explode(',', $this->promos);
110 foreach ($promos as $p) {
111 if ((preg_match('#^\d{4}$#', $p) && $p == $promo) ||
112 (preg_match('#^\d{4}-$#', $p) && intval(substr($p, 0, 4)) <= $promo) ||
113 (preg_match('#^-\d{4}$#', $p) && intval(substr($p, 1)) >= $promo) ||
114 (preg_match('#^\d{4}-\d{4}$#', $p) &&
115 (intval(substr($p, 0, 4)) <= $promo && intval(substr($p, 5)) >= $promo ||
116 intval(substr($p, 0, 4)) >= $promo && intval(substr($p, 5)) <= $promo ))) {
117 return true;
118 }
119 }
120 return false;
121 }
122
123 public function isValid()
124 {
125 return $this->valid;
126 }
127
128 public function isEnded()
129 {
130 return (strtotime($this->end) - time() <= 0);
131 }
132
133 public function getTitle()
134 {
135 return $this->title;
136 }
137 // }}}
138
139 // {{{ function toArray() : converts a question (or the whole survey) to array, with results if the survey is ended
140 public function toArray($i = 'all')
141 {
142 if ($i != 'all' && $i != 'root') { // if a specific question is requested, then just returns this question converted to array
143 $i = intval($i);
144 if (array_key_exists($i, $this->questions)) {
145 return $this->questions[$i]->toArray();
8fe81c50 146 } else {
905ab104
FB
147 return null;
148 }
149 } else { // else returns the root converted to array in any case
150 $a = array('title' => $this->title,
151 'description' => $this->description,
152 'end' => $this->end,
153 'mode' => $this->mode,
154 'promos' => $this->promos,
155 'valid' => $this->valid,
156 'type' => 'root');
157 if ($this->id != -1) {
158 $a['id'] = $this->id;
159 }
160 if ($this->isEnded()) { // if the survey is ended, then adds here the number of votes
161 $sql = 'SELECT COUNT(id)
162 FROM survey_votes
163 WHERE survey_id={?};';
164 $tot = XDB::query($sql, $this->id);
165 $a['votes'] = $tot->fetchOneCell();
166 }
167 if ($i == 'all' && count($this->questions) > 0) { // if the whole survey is requested, then returns all the questions converted to array
168 $qArr = array();
169 for ($k = 0; $k < count($this->questions); $k++) {
170 $q = $this->questions[$k]->toArray();
171 $q['id'] = $k;
172 if ($this->isEnded()) { // if the survey is ended, then adds here the results of this question
173 $q['result'] = $this->questions[$k]->getResultArray($this->id, $k);
174 }
175 $qArr[$k] = $q;
8fe81c50 176 }
905ab104 177 $a['questions'] = $qArr;
8fe81c50 178 }
905ab104 179 return $a;
8fe81c50 180 }
181 }
905ab104
FB
182 // }}}
183
184 // {{{ function toCSV() : builds a CSV file containing all the results of the survey
185 public function toCSV($sep = ',', $enc = '"', $asep='|')
186 {
187 $nbq = count($this->questions);
188 //require_once dirname(__FILE__) . '/../../classes/varstream.php';
189 VarStream::init();
190 global $csv_output;
191 $csv_output = '';
192 $csv = fopen('var://csv_output', 'w');
193 $line = ($this->isMode(self::MODE_XIDENT))? array('id', 'Nom', 'Prenom', 'Promo') : array('id');
194 $qids = array();
195 for ($qid = 0; $qid < $nbq; $qid++) {
196 $qids[$qid] = count($line); // stores the first id of a question (in case of questions with subquestions)
197 array_splice($line, count($line), 0, $this->questions[$qid]->getCSVColumns()); // the first line contains the questions
198 }
199 $nbf = count($line);
200 $users = array();
201 if ($this->isMode(self::MODE_XIDENT)) { // if the mode is non anonymous
202 $users = User::getBulkUsersWithUIDs(XDB::fetchAllAssoc('vid', 'SELECT v.id AS vid, v.uid
203 FROM survey_votes AS v
204 WHERE v.survey_id = {?}
205 ORDER BY vid ASC',
206 $this->id));
207 }
208 $sql = 'SELECT v.id AS vid, a.question_id AS qid, a.answer AS answer
209 FROM survey_votes AS v
210 INNER JOIN survey_answers AS a ON a.vote_id=v.id
211 WHERE v.survey_id={?}
212 ORDER BY vid ASC, qid ASC, answer ASC';
213 $res = XDB::iterator($sql, $this->id); // retrieves all answers from database
214 $vid = -1;
215 $vid_ = 0;
216 while (($cur = $res->next()) != null) {
217 if ($vid != $cur['vid']) { // if the vote id changes, then starts a new line
218 fputcsv($csv, $line, $sep, $enc); // stores the former line into $csv_output
219 $vid = $cur['vid'];
220 $line = array_fill(0, $nbf, ''); // creates an array full of empty string
221 $line[0] = $vid_; // the first field is a 'clean' vote id (not the one stored in database)
222 if ($this->isMode(self::MODE_XIDENT)) { // if the mode is non anonymous
223 if (array_key_exists($vid, $users)) { // and if the user data can be found
224 $line[1] = $users[$vid]->lastName(); // adds the user data (in the first fields of the line)
225 $line[2] = $users[$vid]->firstName();;
226 $line[3] = $users[$vid]->promo();
227 }
228 }
229 $vid_++;
230 }
231 $ans = $this->questions[$cur['qid']]->formatAnswer($cur['answer']); // formats the current answer
232 if (!is_null($ans)) {
233 if (is_array($ans)) {
234 $fid = $qids[$cur['qid']] + $ans['id']; // computes the field id
235 $a = $ans['answer'];
236 } else {
237 $fid = $qids[$cur['qid']];
238 $a = $ans;
239 }
240 if ($line[$fid] != '') { // if this field already contains something
241 $line[$fid] .= $asep; // then adds a separator before adding the new answer
242 }
243 $line[$fid] .= $a; // adds the current answer to the correct field
244 }
245 }
246 fputcsv($csv, $line, $sep, $enc); // stores the last line into $csv_output
247 return $csv_output;
248 }
249 // }}}
8fe81c50 250
905ab104
FB
251 // {{{ function factory($type, $args) : builds a question according to the given type
252 public function factory($t, $args)
90343d1e 253 {
905ab104
FB
254 switch ($t) {
255 case 'text':
256 return new SurveyText($args);
257 case 'textarea':
258 return new SurveyTextarea($args);
259 case 'num':
260 return new SurveyNum($args);
261 case 'radio':
262 return new SurveyRadio($args);
263 case 'checkbox':
264 return new SurveyCheckbox($args);
265 case 'radiotable':
266 return new SurveyRadioTable($args);
267 case 'checkboxtable':
268 return new SurveyCheckboxTable($args);
269 default:
270 return null;
271 }
272 }
273 // }}}
274
275 // {{{ questions manipulation functions
276 public function addQuestion($i, $c)
277 {
278 $i = intval($i);
279 if ($this->valid || $i > count($this->questions)) {
280 return false;
90343d1e 281 } else {
905ab104
FB
282 array_splice($this->questions, $i, 0, array($c));
283 return true;
90343d1e 284 }
905ab104
FB
285 }
286
287 public function delQuestion($i)
288 {
289 $i = intval($i);
290 if ($this->valid || !array_key_exists($i, $this->questions)) {
291 return false;
292 } else {
293 array_splice($this->questions, $i, 1);
294 return true;
295 }
296 }
297
298 public function editQuestion($i, $a)
299 {
300 if ($i == 'root') {
301 $this->update($a);
90343d1e 302 } else {
905ab104
FB
303 $i = intval($i);
304 if ($this->valid ||!array_key_exists($i, $this->questions)) {
305 return false;
306 } else {
307 $this->questions[$i]->update($a);
308 }
90343d1e
FB
309 }
310 return true;
311 }
905ab104 312 // }}}
90343d1e 313
905ab104
FB
314 // {{{ function checkSyntax() : checks syntax of the questions (currently the root only) before storing the survey in database
315 private static $errorMessages = array(
316 "datepassed" => "la date de fin de sondage est déjà dépassée : vous devez préciser une date future",
317 "promoformat" => "les restrictions à certaines promotions sont mal formattées"
318 );
319
320 public function checkSyntax()
4b8c8634 321 {
905ab104
FB
322 $rArr = array();
323 // checks that the end date given is not already passed
324 // (unless the survey has already been validated : an admin can have a validated survey expired)
325 if (!$this->valid && $this->isEnded()) {
326 $rArr[] = array('question' => 'root', 'error' => self::$errorMessages["datepassed"]);
327 }
328 if ($this->promos != '' && !preg_match('#^(\d{4}-?|(\d{4})?-\d{4})(,(\d{4}-?|(\d{4})?-\d{4}))*$#', $this->promos)) {
329 $rArr[] = array('question' => 'root', 'error' => self::$errorMessages["promoformat"]);
330 }
331 return (empty($rArr))? null : $rArr;
332 }
333 // }}}
334
335 // {{{ functions that manipulate surveys in database
336 // {{{ static function retrieveList() : gets the list of available survey (current, old and not validated surveys)
337 public static function retrieveList($type, $tpl = true)
338 {
339 switch ($type) {
340 case 'c':
341 case 'current':
342 $where = 'end > NOW()';
343 break;
344 case 'o':
345 case 'old':
346 $where = 'end <= NOW()';
347 break;
348 default:
349 return null;
350 }
a88f005d
RB
351 if (!S::user()->checkPerms(PERMS_USER)) {
352 $where .= XDB::format(' AND mode = {?}', self::MODE_ALL);
353 }
905ab104
FB
354 $sql = 'SELECT id, title, end, mode
355 FROM surveys
356 WHERE '.$where.'
357 ORDER BY end DESC;';
358 if ($tpl) {
359 return XDB::iterator($sql);
360 } else {
361 return XDB::iterRow($sql);
362 }
363 }
364 // }}}
4b8c8634 365
905ab104
FB
366 // {{{ static function retrieveSurvey() : gets a survey in database (and unserialize the survey object structure)
367 public static function retrieveSurvey($sid)
368 {
369 $sql = 'SELECT questions, title, description, end, mode, promos, uid
370 FROM surveys
371 WHERE id={?}';
372 $res = XDB::query($sql, $sid);
373 $data = $res->fetchOneAssoc();
374 if (is_null($data) || !is_array($data)) {
375 return null;
8fe81c50 376 }
905ab104
FB
377 $survey = new Survey($data, $sid, true, unserialize($data['questions']));
378 return $survey;
5c6e38d7 379 }
905ab104 380 // }}}
5c6e38d7 381
905ab104
FB
382 // {{{ static function retrieveSurveyInfo() : gets information about a survey (title, description, end date, restrictions) but does not unserialize the survey object structure
383 public static function retrieveSurveyInfo($sid)
3ddf2584 384 {
905ab104
FB
385 $sql = 'SELECT title, description, end, mode, promos
386 FROM surveys
387 WHERE id={?}';
388 $res = XDB::query($sql, $sid);
389 return $res->fetchOneAssoc();
3ddf2584 390 }
905ab104 391 // }}}
3ddf2584 392
905ab104
FB
393 // {{{ static function retrieveSurveyReq() : gets a survey request to validate
394 public static function retrieveSurveyReq($id)
5c6e38d7 395 {
905ab104
FB
396 $surveyreq = Validate::get_request_by_id($id);
397 if ($surveyreq == null) {
398 return null;
8fe81c50 399 }
905ab104
FB
400 $data = array('title' => $surveyreq->title,
401 'description' => $surveyreq->description,
402 'end' => $surveyreq->end,
403 'mode' => $surveyreq->mode,
404 'promos' => $surveyreq->promos);
405 $survey = new Survey($data, $id, false, $surveyreq->questions);
406 return $survey;
8fe81c50 407 }
905ab104 408 // }}}
8fe81c50 409
905ab104
FB
410 // {{{ function proposeSurvey() : stores a proposition of survey in database (before validation)
411 public function proposeSurvey()
8fe81c50 412 {
905ab104
FB
413 $surveyreq = new SurveyReq($this->title, $this->description, $this->end, $this->mode, $this->promos, $this->questions, S::user());
414 return $surveyreq->submit();
8fe81c50 415 }
905ab104 416 // }}}
8fe81c50 417
905ab104
FB
418 // {{{ function updateSurvey() : updates a survey in database (before validation)
419 public function updateSurvey()
90343d1e 420 {
905ab104
FB
421 if ($this->valid) {
422 $sql = 'UPDATE surveys
423 SET questions={?},
424 title={?},
425 description={?},
426 end={?},
427 mode={?},
428 promos={?}
429 WHERE id={?};';
430 return XDB::execute($sql, serialize($this->questions), $this->title, $this->description, $this->end, $this->mode, $this->promos, $this->id);
431 } else {
432 $surveyreq = Validate::get_request_by_id($this->id);
433 if ($surveyreq == null) {
434 return false;
90343d1e 435 }
905ab104 436 return $surveyreq->updateReq($this->title, $this->description, $this->end, $this->mode, $this->promos, $this->questions);
90343d1e 437 }
90343d1e 438 }
905ab104 439 // }}}
90343d1e 440
905ab104
FB
441 // {{{ functions vote() and hasVoted() : handles vote to a survey
442 public function vote($uid, $args)
8fe81c50 443 {
905ab104
FB
444 XDB::execute('INSERT INTO survey_votes
445 SET survey_id = {?}, uid = {?}',
446 $this->id, ($uid == 0) ? null : $uid); // notes the user as having voted
447 $vid = XDB::insertId();
448 for ($i = 0; $i < count($this->questions); $i++) {
449 $ans = $this->questions[$i]->checkAnswer($args[$i]);
450 if (!is_null($ans) && is_array($ans)) {
451 foreach ($ans as $a) {
452 XDB::execute('INSERT INTO survey_answers
453 SET vote_id = {?},
454 question_id = {?},
455 answer = {?}', $vid, $i, $a);
456 }
8fe81c50 457 }
8fe81c50 458 }
8fe81c50 459 }
460
905ab104 461 public function hasVoted($uid)
8fe81c50 462 {
905ab104
FB
463 $res = XDB::query('SELECT id
464 FROM survey_votes
465 WHERE survey_id = {?} AND uid = {?};', $this->id, $uid); // checks whether the user has already voted
466 return ($res->numRows() != 0);
b46de52d 467 }
905ab104 468 // }}}
b46de52d 469
905ab104
FB
470 // {{{ static function deleteSurvey() : deletes a survey (and all its votes)
471 public static function deleteSurvey($sid)
b46de52d 472 {
905ab104
FB
473 $sql = 'DELETE s.*, v.*, a.*
474 FROM surveys AS s
475 LEFT JOIN survey_votes AS v
476 ON v.survey_id=s.id
477 LEFT JOIN survey_answers AS a
478 ON a.vote_id=v.id
479 WHERE s.id={?};';
480 return XDB::execute($sql, $sid);
8fe81c50 481 }
905ab104 482 // }}}
8fe81c50 483
905ab104
FB
484 // {{{ static function purgeVotes() : clears all votes concerning a survey (I'm not sure whether it's really useful)
485 public static function purgeVotes($sid)
b46de52d 486 {
905ab104
FB
487 $sql = 'DELETE v.*, a.*
488 FROM survey_votes AS v
489 LEFT JOIN survey_answers AS a
490 ON a.vote_id=v.id
491 WHERE v.survey_id={?};';
492 return XDB::execute($sql, $sid);
b46de52d 493 }
905ab104
FB
494 // }}}
495
496 // }}}
497}
498// }}}
499
500// {{{ abstract class SurveyQuestion
501abstract class SurveyQuestion
502{
503 // {{{ common properties, constructor, and basic methods
504 private $question;
505 private $comment;
b46de52d 506
905ab104 507 public function __construct($args)
90343d1e 508 {
905ab104 509 $this->update($args);
90343d1e
FB
510 }
511
905ab104 512 public function update($a)
8fe81c50 513 {
905ab104
FB
514 $this->question = $a['question'];
515 $this->comment = $a['comment'];
8fe81c50 516 }
8fe81c50 517
905ab104
FB
518 abstract protected function getQuestionType();
519 // }}}
520
521 // {{{ function toArray() : converts to array
522 public function toArray()
90343d1e 523 {
905ab104
FB
524 return array('type' => $this->getQuestionType(), 'question' => $this->question, 'comment' => $this->comment);
525 }
526 // }}}
527
528 // {{{ function checkSyntax() : checks question elements (before storing into database), not currently needed (with new structure)
529 protected function checkSyntax()
530 {
531 return null;
532 }
533 // }}}
534
535 // {{{ function checkAnswer : returns a correct answer (or a null value if error)
536 public function checkAnswer($ans)
537 {
538 return null;
539 }
540 // }}}
541
542 // {{{ functions regarding the results of a survey
543 abstract public function getResultArray($sid, $qid);
544
545 public function formatAnswer($ans)
546 {
547 return $ans;
548 }
549
550 public function getCSVColumns()
551 {
552 return $this->question;
553 }
554 // }}}
555}
556// }}}
557
558// {{{ abstract class SurveySimple and its derived classes : "open" questions
559// {{{ abstract class SurveySimple extends SurveyQuestion
560abstract class SurveySimple extends SurveyQuestion
561{
562 public function checkAnswer($ans)
563 {
564 return array($ans);
565 }
566
567 public function getResultArray($sid, $qid)
568 {
569 $sql = 'SELECT answer
570 FROM survey_answers
571 WHERE vote_id IN (SELECT id FROM survey_votes WHERE survey_id={?})
572 AND question_id={?}
573 ORDER BY RAND()
574 LIMIT 5;';
575 $res = XDB::query($sql, $sid, $qid);
576 return $res->fetchAllAssoc();
577 }
578}
579// }}}
580
581// {{{ class SurveyText extends SurveySimple : simple text field, allowing a few words
582class SurveyText extends SurveySimple
583{
584 public function getQuestionType()
585 {
586 return "text";
587 }
588}
589// }}}
590
591// {{{ class SurveyTextarea extends SurveySimple : textarea field, allowing longer comments
592class SurveyTextarea extends SurveySimple
593{
594 public function getQuestionType()
595 {
596 return "textarea";
597 }
598}
599// }}}
600
601// {{{ class SurveyNum extends SurveySimple : allows numerical answers
602class SurveyNum extends SurveySimple
603{
604 public function checkAnswer($ans)
605 {
606 return array(intval($ans));
607 }
608
609 protected function getQuestionType()
610 {
611 return "num";
612 }
613}
614// }}}
615// }}}
616
617// {{{ abstract class SurveyList and its derived classes : restricted questions that allows only a list of possible answers
618// {{{ abstract class SurveyList extends SurveyQuestion
619abstract class SurveyList extends SurveyQuestion
620{
621 protected $choices;
622
623 public function update($args)
624 {
625 parent::update($args);
626 $this->choices = array();
627 foreach ($args['choices'] as $val) {
628 if (trim($val) || trim($val) == '0') {
629 $this->choices[] = $val;
630 }
90343d1e 631 }
90343d1e
FB
632 }
633
905ab104 634 public function toArray()
90343d1e 635 {
905ab104
FB
636 $rArr = parent::toArray();
637 $rArr['choices'] = $this->choices;
638 return $rArr;
639 }
640
641 public function getResultArray($sid, $qid)
642 {
643 $sql = 'SELECT answer, COUNT(id) AS count
644 FROM survey_answers
645 WHERE vote_id IN (SELECT id FROM survey_votes WHERE survey_id={?})
646 AND question_id={?}
647 GROUP BY answer ASC';
648 $res = XDB::query($sql, $sid, $qid);
649 return $res->fetchAllAssoc();
650 }
651
652 public function formatAnswer($ans)
653 {
654 if (array_key_exists($ans, $this->choices)) {
655 return $this->choices[$ans];
656 } else {
657 return null;
90343d1e 658 }
905ab104
FB
659 }
660}
661// }}}
662
663// {{{ class SurveyRadio extends SurveyList : radio question, allows one answer among the list offered
664class SurveyRadio extends SurveyList
665{
666 public function checkAnswer($ans)
667 {
668 $a = intval($ans);
669 return (array_key_exists($a, $this->choices))? array($a) : null;
670 }
671
672 protected function getQuestionType()
673 {
674 return "radio";
675 }
676}
677// }}}
678
679// {{{ class SurveyCheckbox extends SurveyList : checkbox question, allows any number of answers among the list offered
680class SurveyCheckbox extends SurveyList
681{
682 public function checkAnswer($ans)
683 {
684 $rep = array();
685 foreach ($ans as $a) {
686 $a = intval($a);
687 if (array_key_exists($a, $this->choices)) {
688 $rep[] = $a;
689 }
90343d1e 690 }
905ab104
FB
691 return (count($rep) == 0)? null : $rep;
692 }
693
694 protected function getQuestionType()
695 {
696 return "checkbox";
697 }
698}
699// }}}
700// }}}
701
702// {{{ abstract class SurveyTable and its derived classes : table question, each column represents a choice, each line represents a question
703// {{{ abstract class SurveyTable extends SurveyList
704abstract class SurveyTable extends SurveyList
705{
706 protected $subquestions;
707
708 public function update($args)
709 {
710 parent::update($args);
711 $this->subquestions = array();
712 foreach ($args['subquestions'] as $val) {
713 if (trim($val) || trim($val) == '0') {
714 $this->subquestions[] = $val;
715 }
90343d1e 716 }
90343d1e
FB
717 }
718
905ab104 719 public function toArray()
90343d1e 720 {
905ab104
FB
721 $rArr = parent::toArray();
722 $rArr['subquestions'] = $this->subquestions;
723 return $rArr;
724 }
725
726 public function getResultArray($sid, $qid)
727 {
728 $sql = 'SELECT answer, COUNT(id) AS count
729 FROM survey_answers
730 WHERE vote_id IN (SELECT id FROM survey_votes WHERE survey_id={?})
731 AND question_id={?}
732 GROUP BY answer ASC';
733 $res = XDB::iterator($sql, $sid, $qid);
734 $result = array();
735 for ($i = 0; $i < count($this->subquestions); $i++) {
736 $result[$i] = array_fill(0, count($this->choices), 0);
90343d1e 737 }
905ab104
FB
738 while ($r = $res->next()) {
739 list($i, $j) = explode(':', $r['answer']);
740 $result[$i][$j] = $r['count'];
90343d1e 741 }
905ab104
FB
742 return $result;
743 }
744
745 public function formatAnswer($ans)
746 {
747 list($q, $c) = explode(':', $ans);
748 if (array_key_exists($q, $this->subquestions) && array_key_exists($c, $this->choices)) {
749 return array('id' => $q, 'answer' => $this->choices[$c]);
750 } else {
751 return null;
90343d1e 752 }
90343d1e
FB
753 }
754
905ab104 755 public function getCSVColumns()
797d27db 756 {
905ab104
FB
757 $q = parent::getCSVColumns();
758 if (empty($this->subquestions)) {
759 return $q;
797d27db 760 }
905ab104
FB
761 $a = array();
762 for ($k = 0; $k < count($this->subquestions); $k++) {
763 $a[$k] = $q.' : '.$this->subquestions[$k];
8fe81c50 764 }
905ab104
FB
765 return $a;
766 }
767}
768// }}}
769
770// {{{ class SurveyRadioTable extends SurveyTable : SurveyTable with radio type choices
771class SurveyRadioTable extends SurveyTable
772{
773 public function checkAnswer($ans)
774 {
775 $rep = array();
776 foreach ($ans as $k => $a) {
777 if (!array_key_exists($k, $this->subquestions)) {
778 continue;
779 }
780 $a = intval($a);
781 if (array_key_exists($a, $this->choices)) {
782 $rep[] = $k . ':' . $a;
783 }
5c6e38d7 784 }
905ab104 785 return (count($rep) == 0)? null : $rep;
8fe81c50 786 }
787
905ab104 788 protected function getQuestionType()
8fe81c50 789 {
905ab104 790 return "radiotable";
8fe81c50 791 }
905ab104 792
5c6e38d7 793}
905ab104 794// }}}
8fe81c50 795
905ab104
FB
796// {{{ class SurveyCheckboxTable extends SurveyTable : SurveyTable with checkbox type choices
797class SurveyCheckboxTable extends SurveyTable
5c6e38d7 798{
905ab104 799 public function checkAnswer($ans)
8fe81c50 800 {
905ab104
FB
801 $rep = array();
802 foreach ($ans as $k => $aa) {
803 if (!array_key_exists($k, $this->subquestions)) {
804 continue;
805 }
806 foreach ($aa as $a) {
807 $a = intval($a);
808 if (array_key_exists($a, $this->choices)) {
809 $rep[] = $k . ':' . $a;
810 }
811 }
2f4b93be 812 }
905ab104
FB
813 return (count($rep) == 0)? null : $rep;
814 }
815
816 protected function getQuestionType()
817 {
818 return "checkboxtable";
4b8c8634 819 }
905ab104 820
8fe81c50 821}
905ab104
FB
822// }}}
823// }}}
8fe81c50 824
8602c852 825// vim:set et sw=4 sts=4 ts=4 foldmethod=marker enc=utf-8:
8fe81c50 826?>