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