dolibarr 25.0.0-alpha
studs.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2013-2015 Laurent Destailleur <eldy@users.sourceforge.net>
3 * Copyright (C) 2014 Marcos García <marcosgdf@gmail.com>
4 * Copyright (C) 2024-2026 MDW <mdeweerd@users.noreply.github.com>
5 * Copyright (C) 2024-2025 Frédéric France <frederic.france@free.fr>
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 3 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License
18 * along with this program. If not, see <https://www.gnu.org/licenses/>.
19 */
20
27if (!defined('NOLOGIN')) {
28 define("NOLOGIN", 1); // This means this output page does not require to be logged.
29}
30if (!defined('NOCSRFCHECK')) {
31 define("NOCSRFCHECK", 1); // We accept to go on this page from external web site.
32}
33if (!defined('NOBROWSERNOTIF')) {
34 define('NOBROWSERNOTIF', '1');
35}
36if (!defined('NOIPCHECK')) {
37 define('NOIPCHECK', '1'); // Do not check IP defined into conf $dolibarr_main_restrict_ip
38}
39
40// Load Dolibarr environment
41require '../../main.inc.php';
48require_once DOL_DOCUMENT_ROOT."/core/lib/admin.lib.php";
49require_once DOL_DOCUMENT_ROOT."/core/lib/files.lib.php";
50require_once DOL_DOCUMENT_ROOT."/opensurvey/class/opensurveysondage.class.php";
51require_once DOL_DOCUMENT_ROOT."/opensurvey/lib/opensurvey.lib.php";
52require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
53
54// Init vars
55$action = GETPOST('action', 'aZ09');
56$numsondage = '';
57if (GETPOST('sondage')) {
58 $numsondage = GETPOST('sondage', 'alpha');
59}
60
61$object = new Opensurveysondage($db);
62$result = $object->fetch('', $numsondage);
63
64$nblines = $object->fetch_lines();
65
66//If the survey has not yet finished, then it can be modified
67$canbemodified = ((empty($object->date_fin) || dol_get_last_hour($object->date_fin) > dol_now()) && $object->status != Opensurveysondage::STATUS_CLOSED);
68
69// Security check
70if (!isModEnabled('opensurvey')) {
71 httponly_accessforbidden('Module Opensurvey not enabled');
72}
73
74
75/*
76 * Actions
77 */
78
79$nbcolonnes = substr_count($object->sujet, ',') + 1;
80
81$listofvoters = explode(',', $_SESSION["savevoter"] ?? '');
82
83$error = 0;
84
85// Add comment
86if (GETPOST('ajoutcomment', 'alpha')) {
87 if (!$canbemodified || empty($object->allow_comments)) {
88 // Comments are refused when the survey is expired/closed or when the survey does not allow comments
89 // (the comment form is hidden in that case, so a comment here can only come from a forged POST).
90 httponly_accessforbidden('ErrorForbidden');
91 }
92
93 $comment = GETPOST("comment", 'alphanohtml');
94 $comment_user = GETPOST('commentuser', 'alphanohtml');
95
96 if (!$comment) {
97 $error++;
98 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Comment")), null, 'errors');
99 }
100 if (!$comment_user) {
101 $error++;
102 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Name")), null, 'errors');
103 }
104
105 if (!in_array($comment_user, $listofvoters)) {
106 setEventMessages($langs->trans("UserMustBeSameThanUserUsedToVote"), null, 'errors');
107 $error++;
108 }
109
110 $user_ip = getUserRemoteIP();
111 $nb_post_max = getDolGlobalInt("MAIN_SECURITY_MAX_POST_ON_PUBLIC_PAGES_BY_IP_ADDRESS", 200);
112 $now = dol_now();
113 $minmonthpost = dol_time_plus_duree($now, -1, "m");
114 // Calculate nb of post for IP
115 $nb_post_ip = 0;
116 if ($nb_post_max > 0) { // Calculate only if there is a limit to check
117 $sql = "SELECT COUNT(id_comment) as nb_comments";
118 $sql .= " FROM ".MAIN_DB_PREFIX."opensurvey_comments";
119 $sql .= " WHERE ip = '".$db->escape($user_ip)."'";
120 $sql .= " AND date_creation > '".$db->idate($minmonthpost)."'";
121 $resql = $db->query($sql);
122 if ($resql) {
123 $num = $db->num_rows($resql);
124 $i = 0;
125 while ($i < $num) {
126 $i++;
127 $obj = $db->fetch_object($resql);
128 $nb_post_ip = $obj->nb_comments;
129 }
130 }
131 }
132
133 if ($nb_post_max > 0 && $nb_post_ip >= $nb_post_max) {
134 setEventMessages($langs->trans("AlreadyTooMuchPostOnThisIPAdress"), null, 'errors');
135 $error++;
136 }
137
138 if (!$error) {
139 $resql = $object->addComment($comment, $comment_user, $user_ip);
140
141 if (!$resql) {
142 dol_print_error($db);
143 }
144 }
145}
146
147// Add vote
148if (GETPOST("boutonp") || GETPOST("boutonp.x") || GETPOST("boutonp_x")) { // boutonp for chrome, boutonp_x for firefox
149 if (!$canbemodified) {
150 httponly_accessforbidden('ErrorForbidden');
151 }
152
153 // If the name is entered correctly
154 if (GETPOST('nom', 'alphanohtml')) {
155 $nouveauchoix = '';
156 for ($i = 0; $i < $nbcolonnes; $i++) {
157 if (GETPOSTISSET("choix".$i) && GETPOST("choix".$i) == '1') {
158 $nouveauchoix .= "1";
159 } elseif (GETPOSTISSET("choix".$i) && GETPOST("choix".$i) == '2') {
160 $nouveauchoix .= "2";
161 } else {
162 $nouveauchoix .= "0";
163 }
164 }
165
166 $user_ip = getUserRemoteIP();
167 $nb_post_max = getDolGlobalInt("MAIN_SECURITY_MAX_POST_ON_PUBLIC_PAGES_BY_IP_ADDRESS", 200);
168 $now = dol_now();
169 $minmonthpost = dol_time_plus_duree($now, -1, "m");
170 // Calculate nb of post for IP
171 $nb_post_ip = 0;
172 if ($nb_post_max > 0) { // Calculate only if there is a limit to check
173 $sql = "SELECT COUNT(id_users) as nb_records";
174 $sql .= " FROM ".MAIN_DB_PREFIX."opensurvey_user_studs";
175 $sql .= " WHERE ip = '".$db->escape($user_ip)."'";
176 $sql .= " AND date_creation > '".$db->idate($minmonthpost)."'";
177 $resql = $db->query($sql);
178 if ($resql) {
179 $num = $db->num_rows($resql);
180 $i = 0;
181 while ($i < $num) {
182 $i++;
183 $obj = $db->fetch_object($resql);
184 $nb_post_ip = $obj->nb_records;
185 }
186 }
187 }
188
189
190 $nom = substr(GETPOST("nom", 'alphanohtml'), 0, 64);
191
192 // Check if vote already exists
193 $sql = 'SELECT id_users, nom as name';
194 $sql .= ' FROM '.MAIN_DB_PREFIX.'opensurvey_user_studs';
195 $sql .= " WHERE id_sondage = '".$db->escape($numsondage)."' AND nom = '".$db->escape($nom)."' ORDER BY id_users";
196 $resql = $db->query($sql);
197 if (!$resql) {
198 dol_print_error($db);
199 }
200
201 $num_rows = $db->num_rows($resql);
202
203 if ($num_rows > 0) {
204 setEventMessages($langs->trans("VoteNameAlreadyExists"), null, 'errors');
205 $error++;
206 } elseif ($nb_post_max > 0 && $nb_post_ip >= $nb_post_max) {
207 setEventMessages($langs->trans("AlreadyTooMuchPostOnThisIPAdress"), null, 'errors');
208 $error++;
209 } else {
210 $now = dol_now();
211 $sql = 'INSERT INTO '.MAIN_DB_PREFIX.'opensurvey_user_studs (nom, id_sondage, reponses, ip, date_creation)';
212 $sql .= " VALUES ('".$db->escape($nom)."', '".$db->escape($numsondage)."','".$db->escape($nouveauchoix)."', '".$db->escape($user_ip)."', '".$db->idate($now)."')";
213 $resql = $db->query($sql);
214
215 if ($resql) {
216 // Add voter to session
217 $_SESSION["savevoter"] = $nom.','.(empty($_SESSION["savevoter"]) ? '' : $_SESSION["savevoter"]); // Save voter
218 $listofvoters = explode(',', $_SESSION["savevoter"]);
219
220 if ($object->mailsonde) {
221 if ($object->fk_user_creat) {
222 $userstatic = new User($db);
223 $userstatic->fetch($object->fk_user_creat);
224
225 $email = $userstatic->email;
226 } else {
227 $email = $object->mail_admin;
228 }
229
230 //Linked user may not have an email set
231 if ($email) {
232 include_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';
233
234 $application = ($conf->global->MAIN_APPLICATION_TITLE ? $conf->global->MAIN_APPLICATION_TITLE : 'Dolibarr ERP/CRM');
235
236 $link = getUrlSondage($numsondage, true);
237 $link = '<a href="'.$link.'">'.$link.'</a>';
238 $body = str_replace('\n', '<br>', $langs->transnoentities('EmailSomeoneVoted', $nom, $link));
239 //var_dump($body);exit;
240
241 $cmailfile = new CMailFile("[".$application."] ".$langs->trans("Poll").': '.$object->title, $email, $conf->global->MAIN_MAIL_EMAIL_FROM, $body, null, null, null, '', '', 0, -1);
242 $result = $cmailfile->sendfile();
243 }
244 }
245 } else {
246 dol_print_error($db);
247 }
248 }
249 } else {
250 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Name")), null, 'errors');
251 }
252}
253
254
255// Update vote
256$testmodifier = false;
257$testligneamodifier = false;
258$ligneamodifier = -1;
259$modifier = -1;
260for ($i = 0; $i < $nblines; $i++) {
261 if (GETPOSTISSET('modifierligne'.$i)) {
262 $ligneamodifier = $i;
263 $testligneamodifier = true;
264 }
265
266 //test to see if a line is to be modified
267 if (GETPOSTISSET('validermodifier'.$i)) {
268 $modifier = $i;
269 $testmodifier = true;
270 }
271}
272
273if ($testmodifier) {
274 $nouveauchoix = '';
275 for ($i = 0; $i < $nbcolonnes; $i++) {
276 if (GETPOSTISSET("choix".$i) && GETPOST("choix".$i) == '1') {
277 $nouveauchoix .= "1";
278 } elseif (GETPOSTISSET("choix".$i) && GETPOST("choix".$i) == '2') {
279 $nouveauchoix .= "2";
280 } else {
281 $nouveauchoix .= "0";
282 }
283 }
284
285 if (!$canbemodified) {
286 httponly_accessforbidden('ErrorForbidden');
287 }
288
289 // The vote must be a vote of this survey and of a voter of this session, as the interface only offers to save the votes of the voter
290 $idtomodify = GETPOSTINT("idtomodify".$modifier);
291 $sql = "SELECT nom FROM ".MAIN_DB_PREFIX."opensurvey_user_studs";
292 $sql .= " WHERE id_users = ".((int) $idtomodify);
293 $sql .= " AND id_sondage = '".$db->escape($object->id_sondage)."'";
294 $resql = $db->query($sql);
295 $objvote = ($resql ? $db->fetch_object($resql) : null);
296 if (!$objvote || !in_array($objvote->nom, $listofvoters)) {
297 httponly_accessforbidden('ErrorForbidden');
298 }
299
300 $sql = 'UPDATE '.MAIN_DB_PREFIX."opensurvey_user_studs";
301 $sql .= " SET reponses = '".$db->escape($nouveauchoix)."'";
302 $sql .= " WHERE id_users = ".((int) $idtomodify);
303 $sql .= " AND id_sondage = '".$db->escape($object->id_sondage)."'";
304
305 $resql = $db->query($sql);
306 if (!$resql) {
307 dol_print_error($db);
308 }
309}
310
311// Delete comment
312$idcomment = GETPOSTINT('deletecomment');
313if ($idcomment) {
314 if (!$canbemodified) {
315 httponly_accessforbidden('ErrorForbidden');
316 }
317
318 // Only the author of a comment (a voter of this session) can delete it, as the interface only shows the link to him
319 $commentofvoter = false;
320 foreach ($object->getComments() as $commentline) {
321 if ($commentline->id_comment == $idcomment && in_array($commentline->usercomment, $listofvoters)) {
322 $commentofvoter = true;
323 break;
324 }
325 }
326 if (!$commentofvoter) {
327 httponly_accessforbidden('ErrorForbidden');
328 }
329
330 $resql = $object->deleteComment($idcomment);
331}
332
333
334
335/*
336 * View
337 */
338
339$form = new Form($db);
340
341$arrayofjs = array();
342$arrayofcss = array('/opensurvey/css/style.css');
343
344llxHeaderSurvey($object->title, "", 0, 0, $arrayofjs, $arrayofcss, $numsondage);
345
346if (empty($object->ref)) { // For survey, id is a hex string
347 $langs->load("errors");
348 print $langs->trans("ErrorRecordNotFound");
349
351
352 $db->close();
353 exit();
354}
355
356// Define format of choices
357$toutsujet = explode(",", $object->sujet);
358$listofanswers = array();
359foreach ($toutsujet as $value) {
360 $tmp = explode('@', $value);
361 $listofanswers[] = array('label' => $tmp[0], 'format' => (!empty($tmp[1]) ? $tmp[1] : 'checkbox'));
362}
363$toutsujet = str_replace("°", "'", $toutsujet);
364
365
366print '<div class="survey_intro">';
367print '<div class="survey_invitation">'.$langs->trans("YouAreInivitedToVote").'</div>';
368print '<div class="small">';
369print '<span class="opacitymedium">'.$langs->trans("OpenSurveyHowTo").'</span><br>';
370if (empty($object->allow_spy)) {
371 print '<span class="opacitymedium">'.$langs->trans("YourVoteIsPrivate").'</span><br>';
372} else {
373 print $form->textwithpicto('<span class="opacitymedium">'.$langs->trans("YourVoteIsPublic").'</span>', $langs->trans("CanSeeOthersVote")).'<br>';
374}
375print '</div>';
376print '</div>';
377print '<br>';
378
379if (empty($object->description)) {
380 print '<div class="corps">'."\n";
381} else {
382 print '<br>'."\n";
383}
384
385// show title of survey
386$titre = str_replace("\\", "", $object->title);
387print '<div class="survey_title">'.img_picto('', 'poll', 'class="size15x paddingright"').' <strong>'.dol_htmlentities($titre).'</strong></div>';
388
389if (!empty($object->description)) {
390 print '<br><div class="corps">'."\n";
391}
392
393// show description of survey
394if ($object->description) {
395 print dol_htmlentitiesbr($object->description);
396}
397
398print '</div>'."\n";
399
400//The survey has expired, users can't vote or do any action
401if (!$canbemodified) {
402 print '<br><center><div class="center warning">'.$langs->trans('SurveyExpiredInfo').'</div></center>';
404
405 $db->close();
406 exit;
407}
408
409print '<div class="cadre"> '."\n";
410print '<br><br>'."\n";
411
412// Start to show survey result
413print '<div class="div-table-responsive">';
414print '<table class="resultats">'."\n";
415
416// Show choice titles
417if ($object->format == "D") {
418 //display of survey topics
419 print '<tr>'."\n";
420 print '<td></td>'."\n";
421
422 //display of years
423 $colspan = 1;
424 $nbofsujet = count($toutsujet);
425 for ($i = 0; $i < $nbofsujet; $i++) {
426 if (isset($toutsujet[$i + 1]) && date('Y', intval($toutsujet[$i])) == date('Y', intval($toutsujet[$i + 1]))) {
427 $colspan++;
428 } else {
429 print '<td colspan='.$colspan.' class="annee">'.date('Y', intval($toutsujet[$i])).'</td>'."\n";
430 $colspan = 1;
431 }
432 }
433
434 print '</tr>'."\n";
435 print '<tr>'."\n";
436 print '<td></td>'."\n";
437
438 //display of months
439 $colspan = 1;
440 for ($i = 0; $i < $nbofsujet; $i++) {
441 $cur = intval($toutsujet[$i]); // intval() is used to remove the @* suffix which logically belongs to strftime()
442 if (!isset($toutsujet[$i + 1])) {
443 $next = false;
444 } else {
445 $next = intval($toutsujet[$i + 1]);
446 }
447
448 if ($next && dol_print_date($cur, "%B") == dol_print_date($next, "%B") && dol_print_date($cur, "%Y") == dol_print_date($next, "%Y")) {
449 $colspan++;
450 } else {
451 print '<td colspan='.$colspan.' class="mois">'.dol_print_date($cur, "%B").'</td>'."\n";
452 $colspan = 1;
453 }
454 }
455
456 print '</tr>'."\n";
457 print '<tr>'."\n";
458 print '<td></td>'."\n";
459
460 //display of days
461 $colspan = 1;
462 for ($i = 0; $i < $nbofsujet; $i++) {
463 $cur = intval($toutsujet[$i]);
464 if (!isset($toutsujet[$i + 1])) {
465 $next = false;
466 } else {
467 $next = intval($toutsujet[$i + 1]);
468 }
469 if ($next && dol_print_date($cur, "%a %d") == dol_print_date($next, "%a %d") && dol_print_date($cur, "%B") == dol_print_date($next, "%B")) {
470 $colspan++;
471 } else {
472 print '<td colspan="'.$colspan.'" class="jour">'.dol_print_date($cur, "%a %d").'</td>'."\n";
473 $colspan = 1;
474 }
475 }
476
477 print '</tr>'."\n";
478
479 //Display schedules
480 if (strpos($object->sujet, '@') !== false) {
481 print '<tr>'."\n";
482 print '<td></td>'."\n";
483
484 for ($i = 0; isset($toutsujet[$i]); $i++) {
485 $heures = explode('@', $toutsujet[$i]);
486 if (isset($heures[1])) {
487 print '<td class="heure">'.dol_htmlentities($heures[1]).'</td>'."\n";
488 } else {
489 print '<td class="heure"></td>'."\n";
490 }
491 }
492
493 print '</tr>'."\n";
494 }
495} else {
496 //display of survey topics
497 print '<tr>'."\n";
498 print '<td></td>'."\n";
499
500 for ($i = 0; isset($toutsujet[$i]); $i++) {
501 $tmp = explode('@', $toutsujet[$i]);
502 print '<td class="sujet">'.dol_escape_htmltag($tmp[0]).'</td>'."\n";
503 }
504
505 print '</tr>'."\n";
506}
507
508
509// Loop on each answer
510$currentusername = '';
511$sumfor = array();
512$sumagainst = array();
513$compteur = 0;
514$sql = "SELECT id_users, nom as name, id_sondage, reponses";
515$sql .= " FROM ".MAIN_DB_PREFIX."opensurvey_user_studs";
516$sql .= " WHERE id_sondage = '".$db->escape($numsondage)."'";
517$resql = $db->query($sql);
518if (!$resql) {
519 dol_print_error($db);
520 exit;
521}
522$num = $db->num_rows($resql);
523while ($compteur < $num) {
524 $obj = $db->fetch_object($resql);
525
526 $ensemblereponses = $obj->reponses;
527
528 // Set if line of pre-authentified user
529 $mod_ok = (in_array($obj->name, $listofvoters));
530
531 if (!$mod_ok && !$object->allow_spy) {
532 $compteur++;
533 continue;
534 }
535
536 print '<tr>'."\n";
537
538 // Name
539 print '<td class="nom">'.img_picto($obj->name, 'user', 'class="pictofixedwidth"').dol_htmlentities($obj->name).'</td>'."\n";
540
541 // If the line does not need modification, show the data
542 if (!$testligneamodifier) {
543 for ($i = 0; $i < $nbcolonnes; $i++) {
544 $car = substr($ensemblereponses, $i, 1);
545 //print 'xx'.$i."-".$car.'-'.$listofanswers[$i]['format'].'zz';
546
547 if (empty($listofanswers[$i]['format']) || !in_array($listofanswers[$i]['format'], array('yesno', 'foragainst'))) {
548 if (((string) $car) == "1") {
549 print '<td class="ok">OK</td>'."\n";
550 } else {
551 print '<td class="non">KO</td>'."\n";
552 }
553 // Total
554 if (!isset($sumfor[$i])) {
555 $sumfor[$i] = 0;
556 }
557 if (((string) $car) == "1") {
558 $sumfor[$i]++;
559 }
560 }
561 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'yesno') {
562 if (((string) $car) == "1") {
563 print '<td class="ok">'.$langs->trans("Yes").'</td>'."\n";
564 } elseif (((string) $car) == "0") {
565 print '<td class="non">'.$langs->trans("No").'</td>'."\n";
566 } else {
567 print '<td class="vide">&nbsp;</td>'."\n";
568 }
569 // Total
570 if (!isset($sumfor[$i])) {
571 $sumfor[$i] = 0;
572 }
573 if (!isset($sumagainst[$i])) {
574 $sumagainst[$i] = 0;
575 }
576 if (((string) $car) == "1") {
577 $sumfor[$i]++;
578 }
579 if (((string) $car) == "0") {
580 $sumagainst[$i]++;
581 }
582 }
583 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'foragainst') {
584 if (((string) $car) == "1") {
585 print '<td class="ok">'.$langs->trans("For").'</td>'."\n";
586 } elseif (((string) $car) == "0") {
587 print '<td class="non">'.$langs->trans("Against").'</td>'."\n";
588 } else {
589 print '<td class="vide">&nbsp;</td>'."\n";
590 }
591 // Total
592 if (!isset($sumfor[$i])) {
593 $sumfor[$i] = 0;
594 }
595 if (!isset($sumagainst[$i])) {
596 $sumagainst[$i] = 0;
597 }
598 if (((string) $car) == "1") {
599 $sumfor[$i]++;
600 }
601 if (((string) $car) == "0") {
602 $sumagainst[$i]++;
603 }
604 }
605 }
606 } else {
607 // Else, replace the user's choices with a line of checkboxes for entry
608 if ($compteur == $ligneamodifier) {
609 for ($i = 0; $i < $nbcolonnes; $i++) {
610 $car = substr($ensemblereponses, $i, 1);
611 print '<td class="vide">';
612 if (empty($listofanswers[$i]['format']) || !in_array($listofanswers[$i]['format'], array('yesno', 'foragainst'))) {
613 print '<input type="checkbox" name="choix'.$i.'" value="1" ';
614 if ($car == '1') {
615 print 'checked';
616 }
617 print '>';
618 }
619 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'yesno') {
620 $arraychoice = array('2' => '&nbsp;', '0' => $langs->trans("No"), '1' => $langs->trans("Yes"));
621 print $form->selectarray("choix".$i, $arraychoice, $car);
622 }
623 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'foragainst') {
624 $arraychoice = array('2' => '&nbsp;', '0' => $langs->trans("Against"), '1' => $langs->trans("For"));
625 print $form->selectarray("choix".$i, $arraychoice, $car);
626 }
627 print '</td>'."\n";
628 }
629 } else {
630 for ($i = 0; $i < $nbcolonnes; $i++) {
631 $car = substr($ensemblereponses, $i, 1);
632 if (empty($listofanswers[$i]['format']) || !in_array($listofanswers[$i]['format'], array('yesno', 'foragainst'))) {
633 if (((string) $car) == "1") {
634 print '<td class="ok">OK</td>'."\n";
635 } else {
636 print '<td class="non">KO</td>'."\n";
637 }
638 // Total
639 if (!isset($sumfor[$i])) {
640 $sumfor[$i] = 0;
641 }
642 if (((string) $car) == "1") {
643 $sumfor[$i]++;
644 }
645 }
646 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'yesno') {
647 if (((string) $car) == "1") {
648 print '<td class="ok">'.$langs->trans("For").'</td>'."\n";
649 } elseif (((string) $car) == "0") {
650 print '<td class="non">'.$langs->trans("Against").'</td>'."\n";
651 } else {
652 print '<td class="vide">&nbsp;</td>'."\n";
653 }
654 // Total
655 if (!isset($sumfor[$i])) {
656 $sumfor[$i] = 0;
657 }
658 if (!isset($sumagainst[$i])) {
659 $sumagainst[$i] = 0;
660 }
661 if (((string) $car) == "1") {
662 $sumfor[$i]++;
663 }
664 if (((string) $car) == "0") {
665 $sumagainst[$i]++;
666 }
667 }
668 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'foragainst') {
669 if (((string) $car) == "1") {
670 print '<td class="ok">'.$langs->trans("For").'</td>'."\n";
671 } elseif (((string) $car) == "0") {
672 print '<td class="non">'.$langs->trans("Against").'</td>'."\n";
673 } else {
674 print '<td class="vide">&nbsp;</td>'."\n";
675 }
676 // Total
677 if (!isset($sumfor[$i])) {
678 $sumfor[$i] = 0;
679 }
680 if (!isset($sumagainst[$i])) {
681 $sumagainst[$i] = 0;
682 }
683 if (((string) $car) == "1") {
684 $sumfor[$i]++;
685 }
686 if (((string) $car) == "0") {
687 $sumagainst[$i]++;
688 }
689 }
690 }
691 }
692 }
693
694 // Button edit at end of line
695 if ($compteur != $ligneamodifier && $mod_ok) {
696 $currentusername = $obj->name;
697 print '<td class="casevide"><input type="submit" class="button small" name="modifierligne'.$compteur.'" value="'.dol_escape_htmltag($langs->trans("Edit")).'"></td>'."\n";
698 }
699
700 // Ask for confirmation to modify the line
701 for ($i = 0; $i < $nblines; $i++) {
702 if (GETPOSTISSET("modifierligne".$i)) {
703 if ($compteur == $i) {
704 print '<td class="casevide">';
705 print '<input type="hidden" name="idtomodify'.$compteur.'" value="'.$obj->id_users.'">';
706 print '<input type="submit" class="button button-save small" name="validermodifier'.$compteur.'" value="'.dol_escape_htmltag($langs->trans("Save")).'">';
707 print '</td>'."\n";
708 }
709 }
710 }
711
712 $compteur++;
713 print '</tr>'."\n";
714}
715
716// Add line to add new record
717if ($ligneamodifier < 0 && (!isset($_SESSION['nom']))) {
718 print '<tr>'."\n";
719 print '<td class="nom">'."\n";
720 if (isset($_SESSION['nom'])) {
721 print '<input type=hidden name="nom" value="'.$_SESSION['nom'].'">'.$_SESSION['nom']."\n";
722 } else {
723 print '<input type="text" name="nom" placeholder="'.dol_escape_htmltag($langs->trans("Name")).'" maxlength="64" class=" minwidth175" value="">'."\n";
724 }
725 print '</td>'."\n";
726
727 // show cell form checkbox for a new choice
728 for ($i = 0; $i < $nbcolonnes; $i++) {
729 print '<td class="vide">';
730 if (empty($listofanswers[$i]['format']) || !in_array($listofanswers[$i]['format'], array('yesno', 'foragainst'))) {
731 print '<input type="checkbox" name="choix'.$i.'" value="1"';
732 if (GETPOSTISSET('choix'.$i) && GETPOST('choix'.$i) == '1') {
733 print ' checked';
734 }
735 print '>';
736 }
737 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'yesno') {
738 $arraychoice = array('2' => '&nbsp;', '0' => $langs->trans("No"), '1' => $langs->trans("Yes"));
739 print $form->selectarray("choix".$i, $arraychoice, GETPOST('choix'.$i));
740 }
741 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'foragainst') {
742 $arraychoice = array('2' => '&nbsp;', '0' => $langs->trans("Against"), '1' => $langs->trans("For"));
743 print $form->selectarray("choix".$i, $arraychoice, GETPOST('choix'.$i));
744 }
745 print '</td>'."\n";
746 }
747
748 // Show button to add a new line into database
749 print '<td><input type="image" class="borderimp classfortooltip" title="'.dolPrintHTML($langs->trans("AddTheVote")).'" name="boutonp" value="'.$langs->trans("Vote").'" src="'.img_picto('', 'edit_add', '', 0, 1).'"></td>'."\n";
750 print '</tr>'."\n";
751}
752
753// Select value of best choice (for checkbox columns only)
754$nbofcheckbox = 0;
755$meilleurecolonne = null;
756for ($i = 0; $i < $nbcolonnes; $i++) {
757 if (empty($listofanswers[$i]['format']) || !in_array($listofanswers[$i]['format'], array('yesno', 'foragainst'))) {
758 $nbofcheckbox++;
759 }
760 if (isset($sumfor[$i])) {
761 if ($i == 0) {
762 $meilleurecolonne = $sumfor[$i];
763 }
764 if (!isset($meilleurecolonne) || $sumfor[$i] > $meilleurecolonne) {
765 $meilleurecolonne = $sumfor[$i];
766 }
767 }
768}
769
770if ($object->allow_spy) {
771 // Show line total
772 print '<tr>'."\n";
773 print '<td class="center">'.$langs->trans("Total").'</td>'."\n";
774 for ($i = 0; $i < $nbcolonnes; $i++) {
775 $showsumfor = isset($sumfor[$i]) ? $sumfor[$i] : '';
776 $showsumagainst = isset($sumagainst[$i]) ? $sumagainst[$i] : '';
777 if (empty($showsumfor)) {
778 $showsumfor = 0;
779 }
780 if (empty($showsumagainst)) {
781 $showsumagainst = 0;
782 }
783
784 print '<td>';
785 if (empty($listofanswers[$i]['format']) || !in_array($listofanswers[$i]['format'], array('yesno', 'foragainst'))) {
786 print $showsumfor;
787 }
788 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'yesno') {
789 print $langs->trans("Yes").': '.$showsumfor.'<br>'.$langs->trans("No").': '.$showsumagainst;
790 }
791 if (!empty($listofanswers[$i]['format']) && $listofanswers[$i]['format'] == 'foragainst') {
792 print $langs->trans("For").': '.$showsumfor.'<br>'.$langs->trans("Against").': '.$showsumagainst;
793 }
794 print '</td>'."\n";
795 }
796 print '</tr>';
797 // Show picto winner
798 if ($nbofcheckbox >= 2) {
799 print '<tr>'."\n";
800 print '<td class="somme"></td>'."\n";
801 for ($i = 0; $i < $nbcolonnes; $i++) {
802 //print 'xx'.(!empty($listofanswers[$i]['format'])).'-'.$sumfor[$i].'-'.$meilleurecolonne;
803 if (empty($listofanswers[$i]['format']) || !in_array($listofanswers[$i]['format'], array('yesno', 'foragainst')) && isset($sumfor[$i]) && isset($meilleurecolonne) && $sumfor[$i] == $meilleurecolonne) {
804 print '<td class="somme"><img src="'.dol_buildpath('/opensurvey/img/medaille.png', 1).'"></td>'."\n";
805 } else {
806 print '<td class="somme"></td>'."\n";
807 }
808 }
809 print '</tr>'."\n";
810 }
811}
812print '</table>'."\n";
813print '</div>'."\n";
814
815print '</div>'."\n";
816
817if ($object->allow_spy) {
818 $toutsujet = explode(",", $object->sujet);
819 $toutsujet = str_replace("°", "'", $toutsujet);
820
821 $compteursujet = 0;
822 $meilleursujet = '';
823
824 for ($i = 0; $i < $nbcolonnes; $i++) {
825 if (isset($sumfor[$i]) && isset($meilleurecolonne) && $sumfor[$i] == $meilleurecolonne) {
826 $meilleursujet .= ($meilleursujet ? ", " : "");
827 if ($object->format == "D") {
828 if (strpos($toutsujet[$i], '@') !== false) {
829 $toutsujetdate = explode("@", $toutsujet[$i]);
830 $meilleursujet .= dol_print_date($toutsujetdate[0], 'daytext').' ('.dol_print_date($toutsujetdate[0], '%A').') - '.$toutsujetdate[1];
831 } else {
832 $meilleursujet .= dol_print_date((empty($toutsujet[$i]) ? 0 : $toutsujet[$i]), 'daytext').' ('.dol_print_date((empty($toutsujet[$i]) ? 0 : $toutsujet[$i]), '%A').')';
833 }
834 } else {
835 $tmps = explode('@', $toutsujet[$i]);
836 $meilleursujet .= dol_htmlentities($tmps[0]);
837 }
838
839 $compteursujet++;
840 }
841 }
842
843 //$meilleursujet = substr($meilleursujet, 1);
844 $meilleursujet = str_replace("°", "'", $meilleursujet);
845
846 // Show best choice
847 if ($nbofcheckbox >= 2) {
848 $vote_str = $langs->trans('votes');
849 print '<p class="affichageresultats">'."\n";
850
851 if (isset($meilleurecolonne) && $compteursujet == "1") {
852 print '<img src="'.dol_buildpath('/opensurvey/img/medaille.png', 1).'"> '.$langs->trans('TheBestChoice').": <b>".$meilleursujet."</b> - <b>".$meilleurecolonne."</b> ".$vote_str.".\n";
853 } elseif (isset($meilleurecolonne)) {
854 print '<img src="'.dol_buildpath('/opensurvey/img/medaille.png', 1).'"> '.$langs->trans('TheBestChoices').": <b>".$meilleursujet."</b> - <b>".$meilleurecolonne."</b> ".$vote_str.".\n";
855 }
856
857 print '</p><br>'."\n";
858 }
859}
860
861print '<br>';
862
863
864// Comment list
865$comments = $object->getComments();
866
867if ($comments) {
868 print '<br>'.img_picto('', 'note', 'class="pictofixedwidth"').'<span class="bold opacitymedium">'.$langs->trans("CommentsOfVoters").':</span><br>'."\n";
869
870 foreach ($comments as $obj) {
871 // Set if line of pre-authentified user
872 //$mod_ok = (in_array($obj->name, $listofvoters));
873
874 print '<div class="comment"><span class="usercomment">';
875 if (in_array($obj->usercomment, $listofvoters)) {
876 print '<a href="'.$_SERVER["PHP_SELF"].'?deletecomment='.$obj->id_comment.'&sondage='.$numsondage.'"> '.img_picto('', 'delete', '', 0, 0, 0, '', 'nomarginleft').'</a> ';
877 }
878 //else print img_picto('', 'ellipsis-h', '', 0, 0, 0, '', 'nomarginleft').' ';
879 print img_picto('', 'user', 'class="pictofixedwidth"').dol_htmlentities($obj->usercomment).':</span> <span class="comment">'.dol_nl2br(dol_htmlentities($obj->comment))."</span></div>";
880 }
881}
882
883// Form to add comment
884if ($object->allow_comments && $currentusername) {
885 print '<br><div class="addcomment"><span class="opacitymedium">'.$langs->trans("AddACommentForPoll")."</span><br>\n";
886
887 print '<textarea name="comment" rows="'.ROWS_2.'" class="quatrevingtpercent">'.dol_escape_htmltag(GETPOST('comment', 'alphanohtml'), 0, 1).'</textarea><br>'."\n";
888 print $langs->trans("Name").': ';
889 print '<input type="text" name="commentuser" maxlength="64" value="'.dol_escape_htmltag(GETPOSTISSET('commentuser') ? GETPOST('commentuser', 'alphanohtml') : (empty($_SESSION['nom']) ? $currentusername : $_SESSION['nom'])).'"> &nbsp; '."\n";
890 print '<input type="submit" class="button smallpaddingimp" name="ajoutcomment" value="'.dol_escape_htmltag($langs->trans("AddComment")).'"><br>'."\n";
891 print '</form>'."\n";
892
893 print '</div>'."\n"; // div add comment
894}
895
896print '<br><br>';
897
898print '<a name="bas"></a>'."\n";
899
901
902$db->close();
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
Class to send emails (with attachments or not) Usage: $mailfile = new CMailFile($subject,...
Class to manage generation of HTML components Only common components must be here.
Put here description of your class.
Class to manage Dolibarr users.
dol_get_last_hour($date, $gm='tzserver')
Return GMT time for last hour of a given GMT date (it replaces hours, min and second part to 23:59:59...
Definition date.lib.php:672
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0, $tz='')
Add a delay to a date.
Definition date.lib.php:127
dol_now($mode='gmt')
Return date for now.
dol_nl2br($stringtoencode, $nl2brmode=0, $forxml=false)
Replace CRLF in string with a HTML BR tag.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
dol_htmlentities($string, $flags=ENT_QUOTES|ENT_SUBSTITUTE, $encoding='UTF-8', $double_encode=false)
Replace htmlentities functions.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
getUserRemoteIP($trusted=0)
Return the real IP of remote user.
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
dol_htmlentitiesbr($stringtoencode, $nl2brmode=0, $pagecodefrom='UTF-8', $removelasteolbr=1)
This function is called to encode a string into a HTML string but differs from htmlentities because a...
isModEnabled($module)
Is Dolibarr module enabled.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Definition html.lib.php:183
llxFooterSurvey()
Show footer for new member.
getUrlSondage($id, $admin=false)
Function for generating URLs for surveys.
llxHeaderSurvey($title, $head="", $disablejs=0, $disablehead=0, $arrayofjs=[], $arrayofcss=[], $numsondage='')
Show header for new member.
print $langs trans('Date')." left Ref Label right Qty right Price right TotalHT right TotalTTC right right right right right right right right right centpercent right TotalHT right n right VAT right n right TotalVAT right n No sujeto a RE IRPF right TotalLT1 right n right TotalLT2 right n right TotalTTC right n takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency takeposcustomercurrency right TotalTTC takeposcustomercurrency right takeposcustomercurrency n right Paid right PaymentTypeShortLIQ right SELECT p pos_change as p datep as date
Definition receipt.php:492
httponly_accessforbidden($message='1', $http_response_code=403, $stringalreadysanitized=0)
Show a message to say access is forbidden and stop program.