PageRenderTime 31ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 0ms

/limesurvey/admin/statistics.php

https://github.com/tacman/citrus
PHP | 1680 lines | 1081 code | 275 blank | 324 comment | 173 complexity | d266707484116d47e06f65a3907e2864 MD5 | raw file
Possible License(s): GPL-3.0, BSD-3-Clause, LGPL-2.1, LGPL-3.0, GPL-2.0, Apache-2.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. /*
    3. 

  3.  * LimeSurvey
    4. 

  4.  * Copyright (C) 2007 The LimeSurvey Project Team / Carsten Schmitz
    5. 

  5.  * All rights reserved.
    6. 

  6.  * License: GNU/GPL License v2 or later, see LICENSE.php
    7. 

  7.  * LimeSurvey is free software. This version may have been modified pursuant
    8. 

  8.  * to the GNU General Public License, and as distributed it includes or
    9. 

  9.  * is derivative of works licensed under the GNU General Public License or
    10. 

  10.  * other free or open source software licenses.
    11. 

  11.  * See COPYRIGHT.php for copyright notices and details.
    12. 

  12.  *
    13. 

  13.  * $Id: statistics.php 9648 2011-01-07 13:06:39Z c_schmitz $
    14. 

  14.  *
    15. 

  15.  */
    16. 

  16. 

  17. /*
    18. 

  18.  * We need this later:
    19. 

  19.  *  1 - Array Dual Scale
    20. 

  20.  *  5 - 5 Point Choice
    21. 

  21.  *  A - Array (5 Point Choice)
    22. 

  22.  *  B - Array (10 Point Choice)
    23. 

  23.  *  C - Array (Yes/No/Uncertain)
    24. 

  24.  *  D - Date
    25. 

  25.  *  E - Array (Increase, Same, Decrease)
    26. 

  26.  *  F - Array (Flexible Labels)
    27. 

  27.  *  G - Gender
    28. 

  28.  *  H - Array (Flexible Labels) by Column
    29. 

  29.  *  I - Language Switch
    30. 

  30.  *  K - Multiple Numerical Input
    31. 

  31.  *  L - List (Radio)
    32. 

  32.  *  M - Multiple choice
    33. 

  33.  *  N - Numerical Input
    34. 

  34.  *  O - List With Comment
    35. 

  35.  *  P - Multiple choice with comments
    36. 

  36.  *  Q - Multiple Short Text
    37. 

  37.  *  R - Ranking
    38. 

  38.  *  S - Short Free Text
    39. 

  39.  *  T - Long Free Text
    40. 

  40.  *  U - Huge Free Text
    41. 

  41.  *  X - Boilerplate Question
    42. 

  42.  *  Y - Yes/No
    43. 

  43.  *  ! - List (Dropdown)
    44. 

  44.  *  : - Array (Flexible Labels) multiple drop down
    45. 

  45.  *  ; - Array (Flexible Labels) multiple texts
    46. 

  46.  *  | - File Upload
    47. 

    48. 

    49. 

  49.  Debugging help:
    50. 

  50.  echo '<script language="javascript" type="text/javascript">alert("HI");</script>';
    51. 

  51.  */
    52. 

  52. 

  53. //split up results to extend statistics -> NOT WORKING YET! DO NOT ENABLE THIS!
    54. 

  54. $showcombinedresults = 0;
    55. 

  55. 

  56. /*
    57. 

  57.  * this variable is used in the function shortencode() which cuts off a question/answer title
    58. 

  58.  * after $maxchars and shows the rest as tooltip
    59. 

  59.  */
    60. 

  60. $maxchars = 50;
    61. 

  61. 

  62. 

  63. 

  64. //don't call this script directly!
    65. 

  65. if (isset($_REQUEST['homedir'])) {die('You cannot start this script directly');}
    66. 

  66. 

  67. //some includes, the progressbar is used to show a progressbar while generating the graphs
    68. 

  68. //include_once("login_check.php");
    69. 

  69. require_once('classes/core/class.progressbar.php');
    70. 

  70. 

  71. //we collect all the output within this variable
    72. 

  72. $statisticsoutput ='';
    73. 

  73. 

  74. //output for chosing questions to cross query
    75. 

  75. $cr_statisticsoutput = '';
    76. 

  76. 

  77. // This gets all the 'to be shown questions' from the POST and puts these into an array
    78. 

  78. $summary=returnglobal('summary');
    79. 

  79. $statlang=returnglobal('statlang');
    80. 

  80. 

  81. //if $summary isn't an array we create one
    82. 

  82. if (isset($summary) && !is_array($summary)) {
    83. 

  83.     $summary = explode("+", $summary);
    84. 

  84. }
    85. 

  85. 

  86. //no survey ID? -> come and get one
    87. 

  87. if (!isset($surveyid)) {$surveyid=returnglobal('sid');}
    88. 

  88. 

  89. //still no survey ID -> error
    90. 

  90. if (!$surveyid)
    91. 

  91. {
    92. 

  92.     //need to have a survey id
    93. 

  93.     $statisticsoutput .= "<center>You have not selected a survey!</center>";
    94. 

  94.     exit;
    95. 

  95. }
    96. 

  96. 

  97. // Set language for questions and answers to base language of this survey
    98. 

  98. $language = GetBaseLanguageFromSurveyID($surveyid);
    99. 

  99. 

  100. 

  101. //pick the best font file if font setting is 'auto'
    102. 

  102. if ($chartfontfile=='auto')
    103. 

  103. {
    104. 

  104.     $chartfontfile='vera.ttf';
    105. 

  105.     if ( $language=='ar')
    106. 

  106.     {
    107. 

  107.         $chartfontfile='KacstOffice.ttf';
    108. 

  108.     }
    109. 

  109.     elseif  ($language=='fa' )
    110. 

  110.     {
    111. 

  111.         $chartfontfile='KacstFarsi.ttf';
    112. 

  112.     }
    113. 

  113.     elseif  ($language=='el' )
    114. 

  114.     {
    115. 

  115.         $chartfontfile='DejaVuLGCSans.ttf';
    116. 

  116.     }
    117. 

  117.     elseif  ($language=='zh-Hant-HK' || $language=='zh-Hant-TW' || $language=='zh-Hans')
    118. 

  118.     {
    119. 

  119.         $chartfontfile='fireflysung.ttf';
    120. 

  120.     }
    121. 

  121. 

  122. }
    123. 

  123. //$statisticsoutput .= "
    124. 

  124. //<script type='text/javascript'' >
    125. 

  125. //<!--
    126. 

  126. //function selectAll(name){
    127. 

  127. //	//var name=name;
    128. 

  128. //
    129. 

  129. //	alert(name);
    130. 

  130. //
    131. 

  131. //	temp = document.+name+.elements.length;
    132. 

  132. //
    133. 

  133. //    for (i=0; i < temp; i++) {
    134. 

  134. //    if(document.+name+.elements[i].checked == 1)
    135. 

  135. //    	{document.+name+.elements[i].checked = 0;
    136. 

  136. //    	 document.+name+.+name+_btn.value = 'Select All'; }
    137. 

  137. //    else {document.+name.elements[i].checked = 1;
    138. 

  138. //   	 document.+name+.+name+_btn.value = 'Deselect All'; }
    139. 

  139. //	}
    140. 

  140. //}
    141. 

  141. ////-->
    142. 

  142. //</script>";
    143. 

  143. 

  144. //hide/show the filter
    145. 

  145. //filtersettings by default aren't shown when showing the results
    146. 

  146. $statisticsoutput .= '<script type="text/javascript" src="scripts/statistics.js"></script>';
    147. 

  147. 

  148. //headline with all icons for available statistic options
    149. 

  149. //Get the menubar
    150. 

  150. $statisticsoutput .= browsemenubar($clang->gT("Quick statistics"))
    151. 

  151. 

  152. 

  153. //we need a form which can pass the selected data later
    154. 

  154. ."<form method='post' name='formbuilder' action='$scriptname?action=statistics#start'>\n";
    155. 

  155. 

  156. //Select public language file
    157. 

  157. $query = "SELECT datestamp FROM {$dbprefix}surveys WHERE sid=$surveyid";
    158. 

  158. $result = db_execute_assoc($query) or safe_die("Error selecting language: <br />".$query."<br />".$connect->ErrorMsg());
    159. 

  159. 

  160. /*
    161. 

  161.  * check if there is a datestamp available for this survey
    162. 

  162.  * yes -> $datestamp="Y"
    163. 

  163.  * no -> $datestamp="N"
    164. 

  164.  */
    165. 

  165. while ($row=$result->FetchRow()) {$datestamp=$row['datestamp'];}
    166. 

  166. 

  167. 

  168. 

  169. // 1: Get list of questions from survey
    170. 

  170. 

  171. /*
    172. 

  172.  * We want to have the following data
    173. 

  173.  * a) "questions" -> all table namens, e.g.
    174. 

  174.  * qid
    175. 

  175.  * sid
    176. 

  176.  * gid
    177. 

  177.  * type
    178. 

  178.  * title
    179. 

  179.  * question
    180. 

  180.  * preg
    181. 

  181.  * help
    182. 

  182.  * other
    183. 

  183.  * mandatory
    184. 

  184.  * lid
    185. 

  185.  * lid1
    186. 

  186.  * question_order
    187. 

  187.  * language
    188. 

  188.  *
    189. 

  189.  * b) "groups" -> group_name + group_order *
    190. 

  190.  */
    191. 

  191. $query = "SELECT questions.*, groups.group_name, groups.group_order\n"
    192. 

  192. ." FROM ".db_table_name("questions") ." as questions, ".db_table_name("groups")." as groups\n"
    193. 

  193. ." WHERE groups.gid=questions.gid\n"
    194. 

  194. ." AND groups.language='".$language."'\n"
    195. 

  195. ." AND questions.language='".$language."'\n"
    196. 

  196. ." AND questions.parent_qid=0\n"
    197. 

  197. ." AND questions.sid=$surveyid";
    198. 

  198. $result = db_execute_assoc($query) or safe_die("Couldn't do it!<br />$query<br />".$connect->ErrorMsg());
    199. 

  199. 

  200. //store all the data in $rows
    201. 

  201. $rows = $result->GetRows();
    202. 

  202. 

  203. //SORT IN NATURAL ORDER!
    204. 

  204. usort($rows, 'GroupOrderThenQuestionOrder');
    205. 

  205. 

  206. //put the question information into the filter array
    207. 

  207. foreach ($rows as $row)
    208. 

  208. {
    209. 

  209.     //store some column names in $filters array
    210. 

  210.     $filters[]=array($row['qid'],
    211. 

  211.     $row['gid'],
    212. 

  212.     $row['type'],
    213. 

  213.     $row['title'],
    214. 

  214.     $row['group_name'],
    215. 

  215.     FlattenText($row['question']));
    216. 

  216. }
    217. 

  217. 

  218. //var_dump($filters);
    219. 

  219. // SHOW ID FIELD
    220. 

  220. 

  221. $statisticsoutput .= "<div class='header ui-widget-header'>".$clang->gT("General filters")."</div><div id='statistics_general_filter'>";
    222. 

  222. 

  223. 

  224. $grapherror='';
    225. 

  225. if (!function_exists("gd_info")) {
    226. 

  226.     $grapherror.='<br />'.$clang->gT('You do not have the GD Library installed. Showing charts requires the GD library to function properly.');
    227. 

  227.     $grapherror.='<br />'.$clang->gT('visit http://us2.php.net/manual/en/ref.image.php for more information').'<br />';
    228. 

  228. }
    229. 

  229. elseif (!function_exists("imageftbbox")) {
    230. 

  230.     $grapherror.='<br />'.$clang->gT('You do not have the Freetype Library installed. Showing charts requires the Freetype library to function properly.');
    231. 

  231.     $grapherror.='<br />'.$clang->gT('visit http://us2.php.net/manual/en/ref.image.php for more information').'<br />';
    232. 

  232. }
    233. 

  233. if ($grapherror!='')
    234. 

  234. {
    235. 

  235.     unset($_POST['usegraph']);
    236. 

  236. }
    237. 

  237. 

  238. 

  239. //pre-selection of filter forms
    240. 

  240. if (incompleteAnsFilterstate() == "filter")
    241. 

  241. {
    242. 

  242.     $selecthide="selected='selected'";
    243. 

  243.     $selectshow="";
    244. 

  244.     $selectinc="";
    245. 

  245. }
    246. 

  246. elseif (incompleteAnsFilterstate() == "inc")
    247. 

  247. {
    248. 

  248.     $selecthide="";
    249. 

  249.     $selectshow="";
    250. 

  250.     $selectinc="selected='selected'";
    251. 

  251. }
    252. 

  252. else
    253. 

  253. {
    254. 

  254.     $selecthide="";
    255. 

  255.     $selectshow="selected='selected'";
    256. 

  256.     $selectinc="";
    257. 

  257. }
    258. 

  258. $statisticsoutput .="<fieldset style='clear:both;'><legend>".$clang->gT("Data selection")."</legend><ul>";
    259. 

  259. $statisticsoutput .="<li><label for='filterinc'>".$clang->gT("Include:")."</label><select name='filterinc' id='filterinc'>\n"
    260. 

  260. ."<option value='show' $selectshow>".$clang->gT("All responses")."</option>\n"
    261. 

  261. ."<option value='filter' $selecthide>".$clang->gT("Completed responses only")."</option>\n"
    262. 

  262. ."<option value='incomplete' $selectinc>".$clang->gT("Incomplete responses only")."</option>\n"
    263. 

  263. ."</select></li>\n"
    264. 

  264. 

  265. ."<li><label for='viewsummaryall'>".$clang->gT("View summary of all available fields")."</label>
    266. 

  266.                 <input type='checkbox' id='viewsummaryall' name='viewsummaryall' ";
    267. 

  267. if (isset($_POST['viewsummaryall'])) {$statisticsoutput .= "checked='checked'";}
    268. 

  268. $statisticsoutput.="/></li>";
    269. 

  269. 

  270. $statisticsoutput .="<li id='vertical_slide'";
    271. 

  271. //if ($selecthide!='')
    272. 

  272. //{
    273. 

  273. //    $statisticsoutput .= " style='display:none' ";
    274. 

  274. //}
    275. 

  275. $statisticsoutput.=" ><label id='noncompletedlbl' for='noncompleted' title='".$clang->gT("Count stats for each question based only on the total number of responses for which the question was displayed")."'>".$clang->gT("Subtotals based on displayed questions")."</label>
    276. 

  276.                 <input type='checkbox' id='noncompleted' name='noncompleted' ";
    277. 

  277. if (isset($_POST['noncompleted'])) {$statisticsoutput .= "checked='checked'";}
    278. 

  278. $statisticsoutput.=" />\n</li>\n";
    279. 

  279. 

  280. $survlangs = GetAdditionalLanguagesFromSurveyID($surveyid);
    281. 

  281. $survlangs [] = GetBaseLanguageFromSurveyID($surveyid);
    282. 

  282. $language_options="";
    283. 

  283. foreach ($survlangs as $survlang)
    284. 

  284. {
    285. 

  285.     $language_options .= "\t<option value=\"{$survlang}\"";
    286. 

  286.     if ($_SESSION['adminlang'] == $survlang)
    287. 

  287.     {
    288. 

  288.         $language_options .= "selected=\"selected\" " ;
    289. 

  289.     }
    290. 

  290.     $language_options .= ">".getLanguageNameFromCode($survlang,true)."</option>\n";
    291. 

  291. }
    292. 

  292. 

  293. $statisticsoutput .="<li><label for='statlang'>".$clang->gT("Statistics report language")."</label>"
    294. 

  294. . " <select name=\"statlang\" id=\"statlang\">".$language_options."</select>\n";
    295. 

  295. 

  296. $statisticsoutput.="\n</ul></fieldset>\n";
    297. 

  297. 

  298. $statisticsoutput .= "<fieldset id='left'><legend>".$clang->gT("Response ID")."</legend><ul><li>"
    299. 

  299. ."<label for='idG'>".$clang->gT("Greater than:")."</label>\n"
    300. 

  300. ."<input type='text' id='idG' name='idG' size='10' value='";
    301. 

  301. if (isset($_POST['idG'])){$statisticsoutput .= sanitize_int($_POST['idG']);}
    302. 

  302. $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789')\" /></li><li><label for='idL'>\n"
    303. 

  303. .$clang->gT("Less than:")."</label>\n"
    304. 

  304. ."<input type='text' id='idL' name='idL' size='10' value='";
    305. 

  305. if (isset($_POST['idL'])) {$statisticsoutput .= sanitize_int($_POST['idL']);}
    306. 

  306. $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789')\" /></li></ul></fieldset>\n";
    307. 

  307. $statisticsoutput .= "<input type='hidden' name='summary[]' value='idG' />";
    308. 

  308. $statisticsoutput .= "<input type='hidden' name='summary[]' value='idL' />";
    309. 

  309. 

  310. 

  311. //if the survey contains timestamps you can filter by timestamp, too
    312. 

  312. if (isset($datestamp) && $datestamp == "Y") {
    313. 

  313. 

  314. 

  315.     $statisticsoutput .= "<fieldset id='right'><legend>".$clang->gT("Submission date")."</legend><ul><li>"
    316. 

  316.     ."<label for='datestampE'>".$clang->gT("Equals:")."</label>\n"
    317. 

  317.     ."<input class='popupdate' id='datestampE' name='datestampE' type='text' value='";
    318. 

  318.     if (isset($_POST['datestampE'])) {$statisticsoutput .= $_POST['datestampE'];}
    319. 

  319.     $statisticsoutput .= "' /></li><li><label for='datestampG'>\n"
    320. 

  320.     ."&nbsp;&nbsp;".$clang->gT("Later than:")."</label>\n"
    321. 

  321.     ."<input class='popupdatetime' id='datestampG' name='datestampG' value='";
    322. 

  322.     if (isset($_POST['datestampG'])) {$statisticsoutput .= $_POST['datestampG'];}
    323. 

  323.     $statisticsoutput .= "' type='text' /></li><li><label for='datestampL'> ".$clang->gT("Earlier than:")."</label><input  class='popupdatetime' id='datestampL' name='datestampL' value='";
    324. 

  324.     if (isset($_POST['datestampL'])) {$statisticsoutput .= $_POST['datestampL'];}
    325. 

  325.     $statisticsoutput .= "' type='text' /></li></ul></fieldset>\n";
    326. 

  326.     $statisticsoutput .= "<input type='hidden' name='summary[]' value='datestampE' />";
    327. 

  327.     $statisticsoutput .= "<input type='hidden' name='summary[]' value='datestampG' />";
    328. 

  328.     $statisticsoutput .= "<input type='hidden' name='summary[]' value='datestampL' />";
    329. 

  329. 

  330. }
    331. 

  331. 

  332. 

  333. $statisticsoutput .="<fieldset><legend>".$clang->gT("Output options")."</legend><ul>"
    334. 

  334. 

  335. ."<li><label for='usegraph'>".$clang->gT("Show graphs")."</label><input type='checkbox' id='usegraph' name='usegraph' ";
    336. 

  336. if (isset($_POST['usegraph'])) {$statisticsoutput .= "checked='checked'";}
    337. 

  337. $statisticsoutput .= "/><br />";
    338. 

  338. if ($grapherror!='')
    339. 

  339. {
    340. 

  340.     $statisticsoutput.="<span id='grapherror' style='display:none'>$grapherror<hr /></span>";
    341. 

  341. }
    342. 

  342. $statisticsoutput.="</li>\n";
    343. 

  343. 

  344. //Output selector
    345. 

  345. $statisticsoutput .= "<li>"
    346. 

  346. ."<label>"
    347. 

  347. .$clang->gT("Select output format").":</label>"
    348. 

  348. ."<input type='radio' name='outputtype' value='html' checked='checked' /><label for='outputtype'>HTML</label> <input type='radio' name='outputtype' value='pdf' /><label for='outputtype'>PDF</label> <input type='radio' onclick='nographs();' name='outputtype' value='xls' /><label for='outputtype'>Excel</label>";
    349. 

  349. 

  350. 

  351. $statisticsoutput .= "</ul></fieldset></div><p>"
    352. 

  352. ."<input type='submit' value='".$clang->gT("View stats")."' />\n"
    353. 

  353. ."<input type='button' value='".$clang->gT("Clear")."' onclick=\"window.open('$scriptname?action=statistics&amp;sid=$surveyid', '_top')\" />\n";
    354. 

  354. 

  355. //second row below options -> filter settings headline
    356. 

  356. $statisticsoutput.="<div class='header header_statistics'>"
    357. 

  357. ."<img src='$imageurl/plus.gif' align='right' id='showfilter' /><img src='$imageurl/minus.gif' align='right' id='hidefilter' />"
    358. 

  358. .$clang->gT("Response filters")
    359. 

  359. ."</div>\n";
    360. 

  360. 

  361. $filterchoice_state=returnglobal('filterchoice_state');
    362. 

  362. $statisticsoutput.="<input type='hidden' id='filterchoice_state' name='filterchoice_state' value='{$filterchoice_state}' />\n";
    363. 

  363. 

  364. $statisticsoutput .="<table cellspacing='0' cellpadding='0' width='100%' id='filterchoices' ";
    365. 

  365. if ($filterchoice_state!='')
    366. 

  366. {
    367. 

  367.     $statisticsoutput .= " style='display:none' ";
    368. 

  368. }
    369. 

  369. $statisticsoutput .=">";
    370. 

  370. 

  371. 

  372. /*
    373. 

  373.  * let's go through the filter array which contains
    374. 

  374.  * 	['qid'],
    375. 

  375.  ['gid'],
    376. 

  376.  ['type'],
    377. 

  377.  ['title'],
    378. 

  378.  ['group_name'],
    379. 

  379.  ['question'],
    380. 

  380.  ['lid'],
    381. 

  381.  ['lid1']);
    382. 

  382.  */
    383. 

  383. 

  384. $currentgroup='';
    385. 

  385. foreach ($filters as $flt)
    386. 

  386. {
    387. 

  387.     //is there a previous question type set?
    388. 

  388.     if (!isset($previousquestiontype)) {$previousquestiontype="";}
    389. 

  389. 

  390. 

  391.     //does gid equal $currentgroup?
    392. 

  392.     if ($flt[1] != $currentgroup)
    393. 

  393.     {
    394. 

  394.         //If the groupname has changed, start a new row
    395. 

  395.         if ($currentgroup!='')
    396. 

  396.         {
    397. 

  397.             //if we've already drawn a table for a group, and we're changing - close off table
    398. 

  398.             $statisticsoutput .= "<!-- Close filter group --></tr>\n</table></div></td></tr>\n";
    399. 

  399.         }
    400. 

  400. 

  401.         $statisticsoutput .= "\t\t<tr><td><div class='header ui-widget-header'>\n"
    402. 

  402. 		
    403. 

  403.         ."<input type=\"checkbox\" id='btn_$flt[1]' onclick=\"selectCheckboxes('grp_$flt[1]', 'summary[]', 'btn_$flt[1]');\" />"
    404. 

  404. 

  405.         //use current groupname and groupid as heading
    406. 

  406.         ."<font size='1'><strong>$flt[4]</strong> (".$clang->gT("Question group")." $flt[1])</font></div></td></tr>\n\t\t"
    407. 

  407.         ."<tr><td align='center'>\n"
    408. 

  408.         ."<div id='grp_$flt[1]'><table class='filtertable'><tr>\n";
    409. 

  409. 

  410.         //counter which is used to adapt layout depending on counter #
    411. 

  411.         $counter=0;
    412. 

  412.     }
    413. 

  413. 

  414.     //we don't want more than 4 questions in a row
    415. 

  415.     //and we need a new row after each multiple/array question
    416. 

  416.     if (isset($counter) && $counter == 4 ||
    417. 

  417.     ($previousquestiontype == "1" ||
    418. 

  418.     $previousquestiontype == "A" ||
    419. 

  419.     $previousquestiontype == "B" ||
    420. 

  420.     $previousquestiontype == "C" ||
    421. 

  421.     $previousquestiontype == "E" ||
    422. 

  422.     $previousquestiontype == "F" ||
    423. 

  423.     $previousquestiontype == "H" ||
    424. 

  424.     $previousquestiontype == "K" ||
    425. 

  425.     $previousquestiontype == "Q" ||
    426. 

  426.     $previousquestiontype == "R" ||
    427. 

  427.     $previousquestiontype == ":" ||
    428. 

  428.     $previousquestiontype == ";"))
    429. 

  429.     {
    430. 

  430.         $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>"; $counter=0;
    431. 

  431.     }
    432. 

  432. 

  433.     /*
    434. 

  434.      * remember: $flt is structured like this
    435. 

  435.      *  ['qid'],
    436. 

  436.      ['gid'],
    437. 

  437.      ['type'],
    438. 

  438.      ['title'],
    439. 

  439.      ['group_name'],
    440. 

  440.      ['question'],
    441. 

  441.      ['lid'],
    442. 

  442.      ['lid1']);
    443. 

  443.      */
    444. 

  444. 

  445.     //SGQ identifier
    446. 

  446.     $myfield = "{$surveyid}X{$flt[1]}X{$flt[0]}";
    447. 

  447. 

  448.     //full question title
    449. 

  449.     $niceqtext = FlattenText($flt[5]);
    450. 

  450. 

  451.     /*
    452. 

  452.      * Check question type: This question types will be used (all others are separated in the if clause)
    453. 

  453.      *  5 - 5 Point Choice
    454. 

  454.      G - Gender
    455. 

  455.      I - Language Switch
    456. 

  456.      L - List (Radio)
    457. 

  457.      M - Multiple choice
    458. 

  458.      N - Numerical Input
    459. 

  459.      | - File Upload
    460. 

  460.      O - List With Comment
    461. 

  461.      P - Multiple choice with comments
    462. 

  462.      Y - Yes/No
    463. 

  463.      ! - List (Dropdown) )
    464. 

  464.      */
    465. 

  465.     if ($flt[2]=='M' || $flt[2]=='P' || $flt[2]=='N' || $flt[2]=='L' || $flt[2]=='5'
    466. 

  466.      || $flt[2]=='G' || $flt[2]=='I' || $flt[2]=='O' || $flt[2]=='Y' || $flt[2]=='!') //Have to make an exception for these types!
    467. 

  467.     {
    468. 

  468. 

  469.         $statisticsoutput .= "\t\t\t\t<td align='center'>";
    470. 

  470. 

  471.         //Multiple choice:
    472. 

  472.         if ($flt[2] == "M") {$myfield = "M$myfield";}
    473. 

  473.         if ($flt[2] == "P") {$myfield = "P$myfield";}
    474. 

  474. 

  475.         // File Upload will need special filters in future, hence the special treatment
    476. 

  476.         if ($flt[2] == "|") {$myfield = "|$myfield";}
    477. 

  477.         
    478. 

  478.         //numerical input will get special treatment (arihtmetic mean, standard derivation, ...)
    479. 

  479.         if ($flt[2] == "N") {$myfield = "N$myfield";}
    480. 

  480.         $statisticsoutput .= "<input type='checkbox'  id='filter$myfield' name='summary[]' value='$myfield'";
    481. 

  481. 

  482.         /*
    483. 

  483.          * one of these conditions has to be true
    484. 

  484.          * 1. SGQ can be found within the summary array
    485. 

  485.          * 2. M-SGQ can be found within the summary array (M = Multiple choice)
    486. 

  486.          * 3. N-SGQ can be found within the summary array (N = numerical input)
    487. 

  487.          *
    488. 

  488.          * Always remember that we just have very few question types that are checked here
    489. 

  489.          * due to the if ouside this section!
    490. 

  490.          *
    491. 

  491.          * Auto-check the question types mentioned above
    492. 

  492.          */
    493. 

  493.         if (isset($summary) && (array_search("{$surveyid}X{$flt[1]}X{$flt[0]}", $summary) !== FALSE  
    494. 

  494.             || array_search("M{$surveyid}X{$flt[1]}X{$flt[0]}", $summary) !== FALSE 
    495. 

  495.             || array_search("P{$surveyid}X{$flt[1]}X{$flt[0]}", $summary) !== FALSE 
    496. 

  496.             || array_search("N{$surveyid}X{$flt[1]}X{$flt[0]}", $summary) !== FALSE))
    497. 

  497.         {$statisticsoutput .= " checked='checked'";}
    498. 

  498. 

  499.         //show speaker symbol which contains full question text
    500. 

  500.         $statisticsoutput .= " /><label for='filter$myfield'>".showspeaker(FlattenText($flt[5]))
    501. 

  501.         ."</label><br />\n";
    502. 

  502. 

  503.         //numerical question type -> add some HTML to the output
    504. 

  504.         //if ($flt[2] == "N") {$statisticsoutput .= "</font>";}		//removed to correct font error
    505. 

  505.         if ($flt[2] != "N" && $flt[2] != "|") {$statisticsoutput .= "\t\t\t\t<select name='";}
    506. 

  506. 

  507.         //Multiple choice ("M"/"P") -> add "M" to output
    508. 

  508.         if ($flt[2] == "M" ) {$statisticsoutput .= "M";}
    509. 

  509.         if ($flt[2] == "P" ) {$statisticsoutput .= "P";}
    510. 

  510. 

  511.         //numerical -> add SGQ to output
    512. 

  512.         if ($flt[2] != "N" && $flt[2] != "|") {$statisticsoutput .= "{$surveyid}X{$flt[1]}X{$flt[0]}[]' multiple='multiple'>\n";}
    513. 

  513. 

  514.     }	//end if -> filter certain question types
    515. 

  515. 

  516.     $statisticsoutput .= "\t\t\t\t\t<!-- QUESTION TYPE = $flt[2] -->\n";
    517. 

  517.     /////////////////////////////////////////////////////////////////////////////////////////////////
    518. 

  518.     //This section presents the filter list, in various different ways depending on the question type
    519. 

  519.     /////////////////////////////////////////////////////////////////////////////////////////////////
    520. 

  520. 

  521.     //let's switch through the question type for each question
    522. 

  522.     switch ($flt[2])
    523. 

  523.     {
    524. 

  524.         case "K": // Multiple Numerical
    525. 

  525.             $statisticsoutput .= "\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n";
    526. 

  526. 

  527.             //get answers
    528. 

  528.             $query = "SELECT title as code, question as answer FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language = '{$language}' ORDER BY question_order";
    529. 

  529.             $result = db_execute_num($query) or safe_die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    530. 

  530. 

  531.             //counter is used for layout
    532. 

  532.             $counter2=0;
    533. 

  533. 

  534.             //go through all the (multiple) answers
    535. 

  535.             while ($row=$result->FetchRow())
    536. 

  536.             {
    537. 

  537.                 /*
    538. 

  538.                  * filter form for numerical input
    539. 

  539.                  * - checkbox
    540. 

  540.                  * - greater than
    541. 

  541.                  * - less than
    542. 

  542.                  */
    543. 

  543.                 $myfield1="K".$myfield.$row[0];
    544. 

  544.                 $myfield2="K{$myfield}".$row[0]."G";
    545. 

  545.                 $myfield3="K{$myfield}".$row[0]."L";
    546. 

  546.                 if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    547. 

  547.                  
    548. 

  548.                 //start new TD
    549. 

  549.                 $statisticsoutput .= "\t\t\t\t<td align='center' valign='top'>";
    550. 

  550.                  
    551. 

  551.                 //checkbox
    552. 

  552.                 $statisticsoutput .= "<input type='checkbox'  name='summary[]' value='$myfield1'";
    553. 

  553.                  
    554. 

  554.                 //check SGQA -> do we want to pre-check the checkbox?
    555. 

  555.                 if (isset($summary) && (array_search("K{$surveyid}X{$flt[1]}X{$flt[0]}{$row[0]}", $summary) !== FALSE))
    556. 

  556.                 {$statisticsoutput .= " checked='checked'";}
    557. 

  557.                 $statisticsoutput .= " />&nbsp;";
    558. 

  558.                  
    559. 

  559.                 //show speaker
    560. 

  560.                 $statisticsoutput .= showSpeaker($flt[3]." - ".FlattenText($row[1]))."<br />\n";
    561. 

  561. 

  562.                 //input fields
    563. 

  563.                 $statisticsoutput .= "\t\t\t\t\t<font size='1'>".$clang->gT("Number greater than").":</font><br />\n"
    564. 

  564.                 ."\t\t\t\t\t<input type='text' name='$myfield2' value='";
    565. 

  565.                 if (isset($_POST[$myfield2])){$statisticsoutput .= $_POST[$myfield2];}
    566. 

  566. 

  567.                 //check number input using JS
    568. 

  568.                 $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789.,')\" /><br />\n"
    569. 

  569.                 ."\t\t\t\t\t<font size='1'>".$clang->gT("Number less than").":</font><br />\n"
    570. 

  570.                 ."\t\t\t\t\t<input type='text' name='$myfield3' value='";
    571. 

  571.                 if (isset($_POST[$myfield3])) {$statisticsoutput .= $_POST[$myfield3];}
    572. 

  572.                 $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789.,')\" /><br />\n";
    573. 

  573.                  
    574. 

  574.                 //we added 1 form -> increase counter
    575. 

  575.                 $counter2++;
    576. 

  576.                  
    577. 

  577.             }
    578. 

  578.             break;
    579. 

  579. 

  580. 

  581. 

  582.         case "Q": // Multiple Short Text
    583. 

  583. 

  584.             //new section
    585. 

  585.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    586. 

  586. 

  587.             //get subqestions
    588. 

  588.             $query = "SELECT title as code, question as answer FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language='{$language}' ORDER BY question_order";
    589. 

  589.             $result = db_execute_num($query) or safe_die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    590. 

  590.             $counter2=0;
    591. 

  591. 

  592.             //loop through all answers
    593. 

  593.             while ($row = $result->FetchRow())
    594. 

  594.             {
    595. 

  595.                 //collecting data for output, for details see above (question type "N")
    596. 

  596.                  
    597. 

  597.                 //we have one input field for each answer
    598. 

  598.                 $myfield2 = "Q".$myfield."$row[0]";
    599. 

  599.                 if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    600. 

  600.                  
    601. 

  601.                 $statisticsoutput .= "\t\t\t\t<td align='center' valign='top'>";
    602. 

  602.                 $statisticsoutput .= "<input type='checkbox'  name='summary[]' value='$myfield2'";
    603. 

  603.                 if (isset($summary) && (array_search("Q{$surveyid}X{$flt[1]}X{$flt[0]}{$row[0]}", $summary) !== FALSE))
    604. 

  604.                 {$statisticsoutput .= " checked='checked'";}
    605. 

  605.                  
    606. 

  606.                 $statisticsoutput .= " />&nbsp;";
    607. 

  607.                 $statisticsoutput .= showSpeaker($flt[3]." - ".FlattenText($row[1]))
    608. 

  608.                 ."<br />\n"
    609. 

  609.                 ."\t\t\t\t\t<font size='1'>".$clang->gT("Responses containing").":</font><br />\n"
    610. 

  610.                 ."\t\t\t\t\t<input type='text' name='$myfield2' value='";
    611. 

  611.                 if (isset($_POST[$myfield2]))
    612. 

  612.                 {$statisticsoutput .= $_POST[$myfield2];}
    613. 

  613.                  
    614. 

  614.                 $statisticsoutput .= "' />";
    615. 

  615.                 $counter2++;
    616. 

  616.             }
    617. 

  617.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    618. 

  618.             $counter=0;
    619. 

  619.             break;
    620. 

  620. 

  621. 

  622. 

  623.             /*
    624. 

  624.              * all "free text" types (T, U, S)  get the same prefix ("T")
    625. 

  625.              */
    626. 

  626.         case "T": // Long free text
    627. 

  627.         case "U": // Huge free text
    628. 

  628. 

  629.             $myfield2="T$myfield";
    630. 

  630.             $statisticsoutput .= "\t\t\t\t<td align='center' valign='top'>";
    631. 

  631.             $statisticsoutput .= "<input type='checkbox'  name='summary[]' value='$myfield2'";
    632. 

  632.             if (isset($summary) && (array_search("T{$surveyid}X{$flt[1]}X{$flt[0]}", $summary) !== FALSE))
    633. 

  633.             {$statisticsoutput .= " checked='checked'";}
    634. 

  634. 

  635.             $statisticsoutput .= " />&nbsp;"
    636. 

  636.             ."&nbsp;".showSpeaker($niceqtext)
    637. 

  637.             ."<br />\n"
    638. 

  638.             ."\t\t\t\t\t<font size='1'>".$clang->gT("Responses containing").":</font><br />\n"
    639. 

  639.             ."\t\t\t\t\t<textarea name='$myfield2' rows='3' cols='80'>";
    640. 

  640. 

  641.             if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    642. 

  642. 

  643.             $statisticsoutput .= "</textarea>";
    644. 

  644.             break;
    645. 

  645. 

  646. 

  647. 

  648.         case "S": // Short free text
    649. 

  649. 

  650.             $myfield2="T$myfield";
    651. 

  651.             $statisticsoutput .= "\t\t\t\t<td align='center' valign='top'>";
    652. 

  652.             $statisticsoutput .= "<input type='checkbox'  name='summary[]' value='$myfield2'";
    653. 

  653. 

  654.             if (isset($summary) && (array_search("T{$surveyid}X{$flt[1]}X{$flt[0]}", $summary) !== FALSE))
    655. 

  655.             {$statisticsoutput .= " checked='checked'";}
    656. 

  656. 

  657.             $statisticsoutput .= " />&nbsp;"
    658. 

  658.             ."&nbsp;".showSpeaker($niceqtext)
    659. 

  659.             ."<br />\n"
    660. 

  660.             ."\t\t\t\t\t<font size='1'>".$clang->gT("Responses containing").":</font><br />\n"
    661. 

  661.             ."\t\t\t\t\t<input type='text' name='$myfield2' value='";
    662. 

  662. 

  663.             if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    664. 

  664. 

  665.             $statisticsoutput .= "' />";
    666. 

  666.             $statisticsoutput .= "\t\t\t\t</td>\n";
    667. 

  667.             break;
    668. 

  668. 

  669. 

  670. 

  671.         case "N": // Numerical
    672. 

  672. 

  673.             //textfields for greater and less than X
    674. 

  674.             $myfield2="{$myfield}G";
    675. 

  675.             $myfield3="{$myfield}L";
    676. 

  676.             $statisticsoutput .= "\t\t\t\t\t<font size='1'>".$clang->gT("Number greater than").":</font><br />\n"
    677. 

  677.             ."\t\t\t\t\t<input type='text' name='$myfield2' value='";
    678. 

  678. 

  679.             if (isset($_POST[$myfield2])){$statisticsoutput .= $_POST[$myfield2];}
    680. 

  680. 

  681.             $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789.,')\" /><br />\n"
    682. 

  682.             ."\t\t\t\t\t<font size='1'>".$clang->gT("Number less than").":</font><br />\n"
    683. 

  683.             ."\t\t\t\t\t<input type='text' name='$myfield3' value='";
    684. 

  684. 

  685.             if (isset($_POST[$myfield3])) {$statisticsoutput .= $_POST[$myfield3];}
    686. 

  686. 

  687.             //only numeriacl input allowed -> check using JS
    688. 

  688.             $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789.,')\" /><br />\n";
    689. 

  689. 

  690.             //put field names into array
    691. 

  691. 

  692.             break;
    693. 

  693. 

  694. 

  695.         case "|": // File Upload
    696. 

  696. 

  697.             // Number of files uploaded for greater and less than X
    698. 

  698.             $myfield2 = "{$myfield}G";
    699. 

  699.             $myfield3 = "{$myfield}L";
    700. 

  700.             $statisticsoutput .= "\t\t\t\t\t<font size='1'>".$clang->gT("Number of files greater than").":</font><br />\n"
    701. 

  701.             ."\t\t\t\t\t<input type='text' name='$myfield2' value='";
    702. 

  702. 

  703.             if (isset($_POST[$myfield2])){$statisticsoutput .= $_POST[$myfield2];}
    704. 

  704. 

  705.             $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789.,')\" /><br />\n"
    706. 

  706.             ."\t\t\t\t\t<font size='1'>".$clang->gT("Number of files less than").":</font><br />\n"
    707. 

  707.             ."\t\t\t\t\t<input type='text' name='$myfield3' value='";
    708. 

  708. 

  709.             if (isset($_POST[$myfield3])) {$statisticsoutput .= $_POST[$myfield3];}
    710. 

  710. 

  711.             //only numeriacl input allowed -> check using JS
    712. 

  712.             $statisticsoutput .= "' onkeypress=\"return goodchars(event,'0123456789.,')\" /><br />\n";
    713. 

  713. 

  714.             //put field names into array
    715. 

  715. 

  716.             break;
    717. 

  717. 

  718. 

  719.             /*
    720. 

  720.              * DON'T show any statistics for date questions
    721. 

  721.              * because there aren't any statistics implemented yet!
    722. 

  722.              *
    723. 

  723.              * Only filtering by date is possible.
    724. 

  724.              *
    725. 

  725.              * See bug report #2539 and
    726. 

  726.              * feature request #2620
    727. 

  727.              */
    728. 

  728.         case "D": // Date
    729. 

  729. 

  730.             /*
    731. 

  731.              * - input name
    732. 

  732.              * - date equals
    733. 

  733.              * - date less than
    734. 

  734.              * - date greater than
    735. 

  735.              */
    736. 

  736.             $myfield2="D$myfield";
    737. 

  737.             $myfield3="$myfield2=";
    738. 

  738.             $myfield4="$myfield2<";
    739. 

  739.             $myfield5="$myfield2>";
    740. 

  740.             $statisticsoutput .= "\t\t\t\t<td align='center' valign='top'>";
    741. 

  741. 

  742.             $statisticsoutput .= "<input type='checkbox'  name='summary[]' value='$myfield2'";
    743. 

  743. 

  744.             if (isset($summary) && (array_search("D{$surveyid}X{$flt[1]}X{$flt[0]}", $summary) !== FALSE))
    745. 

  745.             {$statisticsoutput .= " checked='checked'";}
    746. 

  746. 

  747.             $statisticsoutput .= " /><strong>";
    748. 

  748.             $statisticsoutput .= showSpeaker($niceqtext)
    749. 

  749.             ."<br />\n"
    750. 

  750. 		
    751. 

  751.             ."\t\t\t\t\t<font size='1'>".$clang->gT("Date (YYYY-MM-DD) equals").":<br />\n"
    752. 

  752.             ."\t\t\t\t\t<input name='$myfield3' type='text' value='";
    753. 

  753. 

  754.             if (isset($_POST[$myfield3])) {$statisticsoutput .= $_POST[$myfield3];}
    755. 

  755. 

  756.             $statisticsoutput .= "' /><br />\n"
    757. 

  757.             ."\t\t\t\t\t&nbsp;&nbsp;".$clang->gT("Date is")." >=<br />\n"
    758. 

  758.             ."\t\t\t\t\t<input name='$myfield4' value='";
    759. 

  759. 

  760.             if (isset($_POST[$myfield4])) {$statisticsoutput .= $_POST[$myfield4];}
    761. 

  761. 

  762.             $statisticsoutput .= "' type='text' /> <br />"
    763. 

  763.             .$clang->gT("AND/OR Date is")." <= <br /> <input  name='$myfield5' value='";
    764. 

  764. 

  765.             if (isset($_POST[$myfield5])) {$statisticsoutput .= $_POST[$myfield5];}
    766. 

  766. 

  767.             $statisticsoutput .= "' type='text' /></font>\n";
    768. 

  768.             break;
    769. 

  769. 

  770. 

  771. 

  772.         case "5": // 5 point choice
    773. 

  773. 

  774.             //we need a list of 5 entries
    775. 

  775.             for ($i=1; $i<=5; $i++)
    776. 

  776.             {
    777. 

  777.                 $statisticsoutput .= "\t\t\t\t\t<option value='$i'";
    778. 

  778.                  
    779. 

  779.                 //pre-select values which were marked before
    780. 

  780.                 if (isset($_POST[$myfield]) && is_array($_POST[$myfield]) && in_array($i, $_POST[$myfield]))
    781. 

  781.                 {$statisticsoutput .= " selected";}
    782. 

  782.                  
    783. 

  783.                 $statisticsoutput .= ">$i</option>\n";
    784. 

  784.             }
    785. 

  785. 

  786.             //End the select which starts before the CASE statement (around line 411)
    787. 

  787.             $statisticsoutput .="\t\t\t\t</select>\n";
    788. 

  788.             break;
    789. 

  789. 

  790. 

  791. 

  792.         case "G": // Gender
    793. 

  793.             $statisticsoutput .= "\t\t\t\t\t<option value='F'";
    794. 

  794. 

  795.             //pre-select values which were marked before
    796. 

  796.             if (isset($_POST[$myfield]) && is_array($_POST[$myfield]) && in_array("F", $_POST[$myfield])) {$statisticsoutput .= " selected";}
    797. 

  797. 

  798.             $statisticsoutput .= ">".$clang->gT("Female")."</option>\n";
    799. 

  799.             $statisticsoutput .= "\t\t\t\t\t<option value='M'";
    800. 

  800. 

  801.             //pre-select values which were marked before
    802. 

  802.             if (isset($_POST[$myfield]) && is_array($_POST[$myfield]) && in_array("M", $_POST[$myfield])) {$statisticsoutput .= " selected";}
    803. 

  803. 

  804.             $statisticsoutput .= ">".$clang->gT("Male")."</option>\n\t\t\t\t</select>\n";
    805. 

  805.             $statisticsoutput .= "\t\t\t\t</td>\n";
    806. 

  806.             break;
    807. 

  807. 

  808. 

  809. 

  810.         case "Y": // Yes\No
    811. 

  811.             $statisticsoutput .= "\t\t\t\t\t<option value='Y'";
    812. 

  812. 

  813.             //pre-select values which were marked before
    814. 

  814.             if (isset($_POST[$myfield]) && is_array($_POST[$myfield]) && in_array("Y", $_POST[$myfield])) {$statisticsoutput .= " selected";}
    815. 

  815. 

  816.             $statisticsoutput .= ">".$clang->gT("Yes")."</option>\n"
    817. 

  817.             ."\t\t\t\t\t<option value='N'";
    818. 

  818. 

  819.             //pre-select values which were marked before
    820. 

  820.             if (isset($_POST[$myfield]) && is_array($_POST[$myfield]) && in_array("N", $_POST[$myfield])) {$statisticsoutput .= " selected";}
    821. 

  821. 

  822.             $statisticsoutput .= ">".$clang->gT("No")."</option></select>\n";
    823. 

  823.             break;
    824. 

  824. 

  825. 

  826. 

  827.         case "I": // Language
    828. 

  828.             $survlangs = GetAdditionalLanguagesFromSurveyID($surveyid);
    829. 

  829.             $survlangs[] = GetBaseLanguageFromSurveyID($surveyid);
    830. 

  830.             foreach ($survlangs  as $availlang)
    831. 

  831.             {
    832. 

  832.                 $statisticsoutput .= "\t\t\t\t\t<option value='".$availlang."'";
    833. 

  833.                  
    834. 

  834.                 //pre-select values which were marked before
    835. 

  835.                 if (isset($_POST[$myfield]) && is_array($_POST[$myfield]) && in_array($availlang, $_POST[$myfield]))
    836. 

  836.                 {$statisticsoutput .= " selected";}
    837. 

  837. 

  838.                 $statisticsoutput .= ">".getLanguageNameFromCode($availlang,false)."</option>\n";
    839. 

  839.             }
    840. 

  840.             break;
    841. 

  841. 

  842. 

  843. 

  844.             //----------------------- ARRAYS --------------------------
    845. 

  845. 

  846.         case "A": // ARRAY OF 5 POINT CHOICE QUESTIONS
    847. 

  847. 

  848.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    849. 

  849. 

  850.             //get answers
    851. 

  851.             $query = "SELECT title, question FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language='{$language}' ORDER BY question_order";
    852. 

  852.             $result = db_execute_num($query) or safe_die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    853. 

  853.             $counter2=0;
    854. 

  854. 

  855.             //check all the results
    856. 

  856.             while ($row=$result->FetchRow())
    857. 

  857.             {
    858. 

  858.                 $myfield2 = $myfield.$row[0];
    859. 

  859.                 $statisticsoutput .= "<!-- $myfield2 - ";
    860. 

  860.                  
    861. 

  861.                 if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    862. 

  862.                  
    863. 

  863.                 $statisticsoutput .= " -->\n";
    864. 

  864.                  
    865. 

  865.                 if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    866. 

  866. 

  867.                 $statisticsoutput .= "\t\t\t\t<td align='center'>"
    868. 

  868.                 ."<input type='checkbox'  name='summary[]' value='$myfield2'";
    869. 

  869.                  
    870. 

  870.                 //pre-check
    871. 

  871.                 if (isset($summary) && array_search($myfield2, $summary)!== FALSE) {$statisticsoutput .= " checked='checked'";}
    872. 

  872.                  
    873. 

  873.                 $statisticsoutput .= " />&nbsp;"
    874. 

  874.                 .showSpeaker($niceqtext." ".str_replace("'", "`", $row[1])." - # ".$flt[3])
    875. 

  875.                 ."<br />\n"
    876. 

  876.                 ."\t\t\t\t<select name='{$surveyid}X{$flt[1]}X{$flt[0]}{$row[0]}[]' multiple='multiple'>\n";
    877. 

  877.                  
    878. 

  878.                 //there are always exactly 5 values which have to be listed
    879. 

  879.                 for ($i=1; $i<=5; $i++)
    880. 

  880.                 {
    881. 

  881.                     $statisticsoutput .= "\t\t\t\t\t<option value='$i'";
    882. 

  882. 

  883.                     //pre-select
    884. 

  884.                     if (isset($_POST[$myfield2]) && is_array($_POST[$myfield2]) && in_array($i, $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    885. 

  885.                     if (isset($_POST[$myfield2]) && $_POST[$myfield2] == $i) {$statisticsoutput .= " selected";}
    886. 

  886. 

  887.                     $statisticsoutput .= ">$i</option>\n";
    888. 

  888.                 }
    889. 

  889.                  
    890. 

  890.                 $statisticsoutput .= "\t\t\t\t</select>\n\t\t\t\t</td>\n";
    891. 

  891.                 $counter2++;
    892. 

  892.                  
    893. 

  893.                 //add this to all the other fields
    894. 

  894.             }
    895. 

  895. 

  896.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    897. 

  897.             $counter=0;
    898. 

  898.             break;
    899. 

  899. 

  900. 

  901. 

  902.             //just like above only a different loop
    903. 

  903.         case "B": // ARRAY OF 10 POINT CHOICE QUESTIONS
    904. 

  904.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    905. 

  905.             $query = "SELECT title, question FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language='{$language}' ORDER BY question_order";
    906. 

  906.             $result = db_execute_num($query) or safe_die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    907. 

  907.             $counter2=0;
    908. 

  908.             while ($row=$result->FetchRow())
    909. 

  909.             {
    910. 

  910.                 $myfield2 = $myfield . "$row[0]";
    911. 

  911.                 $statisticsoutput .= "<!-- $myfield2 - ";
    912. 

  912.                  
    913. 

  913.                 if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    914. 

  914.                  
    915. 

  915.                 $statisticsoutput .= " -->\n";
    916. 

  916.                  
    917. 

  917.                 if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    918. 

  918. 

  919.                 $statisticsoutput .= "\t\t\t\t<td align='center'>"; //heading
    920. 

  920.                 $statisticsoutput .= "<input type='checkbox'  name='summary[]' value='$myfield2'";
    921. 

  921.                  
    922. 

  922.                 if (isset($summary) && array_search($myfield2, $summary)!== FALSE) {$statisticsoutput .= " checked='checked'";}
    923. 

  923.                  
    924. 

  924.                 $statisticsoutput .= " />&nbsp;"
    925. 

  925.                 .showSpeaker($niceqtext." ".str_replace("'", "`", $row[1])." - # ".$flt[3])
    926. 

  926.                 ."<br />\n"
    927. 

  927.                 ."\t\t\t\t<select name='{$surveyid}X{$flt[1]}X{$flt[0]}{$row[0]}[]' multiple='multiple'>\n";
    928. 

  928.                  
    929. 

  929.                 //here wo loop through 10 entries to create a larger output form
    930. 

  930.                 for ($i=1; $i<=10; $i++)
    931. 

  931.                 {
    932. 

  932.                     $statisticsoutput .= "\t\t\t\t\t<option value='$i'";
    933. 

  933.                     if (isset($_POST[$myfield2]) && is_array($_POST[$myfield2]) && in_array($i, $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    934. 

  934.                     if (isset($_POST[$myfield2]) && $_POST[$myfield2] == $i) {$statisticsoutput .= " selected";}
    935. 

  935.                     $statisticsoutput .= ">$i</option>\n";
    936. 

  936.                 }
    937. 

  937.                  
    938. 

  938.                 $statisticsoutput .= "\t\t\t\t</select>\n\t\t\t\t</td>\n";
    939. 

  939.                 $counter2++;
    940. 

  940.             }
    941. 

  941. 

  942.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    943. 

  943.             $counter=0;
    944. 

  944.             break;
    945. 

  945. 

  946. 

  947. 

  948.         case "C": // ARRAY OF YES\No\$clang->gT("Uncertain") QUESTIONS
    949. 

  949.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    950. 

  950. 

  951.             //get answers
    952. 

  952.             $query = "SELECT title, question FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language='{$language}' ORDER BY question_order";
    953. 

  953.             $result = db_execute_num($query) or safe_die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    954. 

  954.             $counter2=0;
    955. 

  955. 

  956.             //loop answers
    957. 

  957.             while ($row=$result->FetchRow())
    958. 

  958.             {
    959. 

  959.                 $myfield2 = $myfield . "$row[0]";
    960. 

  960.                 $statisticsoutput .= "<!-- $myfield2 - ";
    961. 

  961.                  
    962. 

  962.                 if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    963. 

  963.                  
    964. 

  964.                 $statisticsoutput .= " -->\n";
    965. 

  965.                  
    966. 

  966.                 if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    967. 

  967.                  
    968. 

  968.                 $statisticsoutput .= "\t\t\t\t<td align='center'>"
    969. 

  969.                 ."<input type='checkbox'  name='summary[]' value='$myfield2'";
    970. 

  970.                  
    971. 

  971.                 if (isset($summary) && array_search($myfield2, $summary)!== FALSE)
    972. 

  972.                 {$statisticsoutput .= " checked='checked'";}
    973. 

  973.                  
    974. 

  974.                 $statisticsoutput .= " />&nbsp;<strong>"
    975. 

  975.                 .showSpeaker($niceqtext." ".str_replace("'", "`", $row[1])." - # ".$flt[3])
    976. 

  976.                 ."</strong><br />\n"
    977. 

  977.                 ."\t\t\t\t<select name='{$surveyid}X{$flt[1]}X{$flt[0]}{$row[0]}[]' multiple='multiple'>\n"
    978. 

  978.                 ."\t\t\t\t\t<option value='Y'";
    979. 

  979.                  
    980. 

  980.                 //pre-select "yes"
    981. 

  981.                 if (isset($_POST[$myfield2]) && is_array($_POST[$myfield2]) && in_array("Y", $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    982. 

  982.                  
    983. 

  983.                 $statisticsoutput .= ">".$clang->gT("Yes")."</option>\n"
    984. 

  984.                 ."\t\t\t\t\t<option value='U'";
    985. 

  985.                  
    986. 

  986.                 //pre-select "uncertain"
    987. 

  987.                 if (isset($_POST[$myfield2]) && is_array($_POST[$myfield2]) && in_array("U", $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    988. 

  988.                  
    989. 

  989.                 $statisticsoutput .= ">".$clang->gT("Uncertain")."</option>\n"
    990. 

  990.                 ."\t\t\t\t\t<option value='N'";
    991. 

  991.                  
    992. 

  992.                 //pre-select "no"
    993. 

  993.                 if (isset($_POST[$myfield2]) && is_array($_POST[$myfield2]) && in_array("N", $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    994. 

  994.                  
    995. 

  995.                 $statisticsoutput .= ">".$clang->gT("No")."</option>\n"
    996. 

  996.                 ."\t\t\t\t</select>\n\t\t\t\t</td>\n";
    997. 

  997.                 $counter2++;
    998. 

  998.                  
    999. 

  999.                 //add to array
    1000. 

  1000.             }
    1001. 

  1001. 

  1002.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    1003. 

  1003.             $counter=0;
    1004. 

  1004.             break;
    1005. 

  1005. 

  1006. 

  1007. 

  1008.             //similiar to the above one
    1009. 

  1009.         case "E": // ARRAY OF Increase/Same/Decrease QUESTIONS
    1010. 

  1010.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    1011. 

  1011.             $query = "SELECT title, question FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language='{$language}' ORDER BY question_order";
    1012. 

  1012.             $result = db_execute_num($query) or safe_die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    1013. 

  1013.             $counter2=0;
    1014. 

  1014. 

  1015.             while ($row=$result->FetchRow())
    1016. 

  1016.             {
    1017. 

  1017.                 $myfield2 = $myfield . "$row[0]";
    1018. 

  1018.                 $statisticsoutput .= "<!-- $myfield2 - ";
    1019. 

  1019.                  
    1020. 

  1020.                 if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    1021. 

  1021.                  
    1022. 

  1022.                 $statisticsoutput .= " -->\n";
    1023. 

  1023.                  
    1024. 

  1024.                 if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    1025. 

  1025.                  
    1026. 

  1026.                 $statisticsoutput .= "\t\t\t\t<td align='center'>"
    1027. 

  1027.                 ."<input type='checkbox'  name='summary[]' value='$myfield2'";
    1028. 

  1028.                  
    1029. 

  1029.                 if (isset($summary) && array_search($myfield2, $summary)!== FALSE) {$statisticsoutput .= " checked='checked'";}
    1030. 

  1030.                  
    1031. 

  1031.                 $statisticsoutput .= " />&nbsp;<strong>"
    1032. 

  1032.                 .showSpeaker($niceqtext." ".str_replace("'", "`", $row[1])." - # ".$flt[3])
    1033. 

  1033.                 ."</strong><br />\n"
    1034. 

  1034.                 ."\t\t\t\t<select name='{$surveyid}X{$flt[1]}X{$flt[0]}{$row[0]}[]' multiple='multiple'>\n"
    1035. 

  1035.                 ."\t\t\t\t\t<option value='I'";
    1036. 

  1036.                  
    1037. 

  1037.                 if (isset($_POST[$myfield2]) && is_array($_POST[$myfield2]) && in_array("I", $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    1038. 

  1038.                  
    1039. 

  1039.                 $statisticsoutput .= ">".$clang->gT("Increase")."</option>\n"
    1040. 

  1040.                 ."\t\t\t\t\t<option value='S'";
    1041. 

  1041.                  
    1042. 

  1042.                 if (isset($_POST[$myfield]) && is_array($_POST[$myfield2]) && in_array("S", $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    1043. 

  1043.                  
    1044. 

  1044.                 $statisticsoutput .= ">".$clang->gT("Same")."</option>\n"
    1045. 

  1045.                 ."\t\t\t\t\t<option value='D'";
    1046. 

  1046.                  
    1047. 

  1047.                 if (isset($_POST[$myfield]) && is_array($_POST[$myfield2]) && in_array("D", $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    1048. 

  1048.                  
    1049. 

  1049.                 $statisticsoutput .= ">".$clang->gT("Decrease")."</option>\n"
    1050. 

  1050.                 ."\t\t\t\t</select>\n\t\t\t\t</td>\n";
    1051. 

  1051.                 $counter2++;
    1052. 

  1052.             }
    1053. 

  1053. 

  1054.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    1055. 

  1055.             $counter=0;
    1056. 

  1056.             break;
    1057. 

  1057. 

  1058.         case ";":  //ARRAY (Multi Flex) (Text)
    1059. 

  1059.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    1060. 

  1060.             $query = "SELECT title, question FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language='{$language}' AND scale_id=0 ORDER BY question_order";
    1061. 

  1061.             $result = db_execute_num($query) or die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    1062. 

  1062.             $counter2=0;
    1063. 

  1063.             while ($row=$result->FetchRow())
    1064. 

  1064.             {
    1065. 

  1065.                 $fquery = "SELECT title, question FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language='{$language}' AND scale_id=1 ORDER BY question_order";
    1066. 

  1066.                 $fresult = db_execute_assoc($fquery);
    1067. 

  1067.                 while ($frow = $fresult->FetchRow())
    1068. 

  1068.                 {
    1069. 

  1069.                     $myfield2 = "T".$myfield . $row[0] . "_" . $frow['title'];
    1070. 

  1070.                     $statisticsoutput .= "<!-- $myfield2 - ";
    1071. 

  1071.                     if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    1072. 

  1072.                     $statisticsoutput .= " -->\n";
    1073. 

  1073.                     if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    1074. 

  1074.                     $statisticsoutput .= "\t\t\t\t<td align='center'>"
    1075. 

  1075.                     ."<input type='checkbox'  name='summary[]' value='$myfield2'";
    1076. 

  1076.                     if (isset($summary) && array_search($myfield2, $summary)!== FALSE) {$statisticsoutput .= " checked='checked'";}
    1077. 

  1077.                     $statisticsoutput .= " />&nbsp;<strong>"
    1078. 

  1078.                     .showSpeaker($niceqtext." ".str_replace("'", "`", $row[1]." [".$frow['question']."]")." - ".$row[0]."/".$frow['title'])
    1079. 

  1079.                     ."</strong><br />\n";
    1080. 

  1080.                     //$statisticsoutput .= $fquery;
    1081. 

  1081.                     $statisticsoutput .= "\t\t\t\t\t<font size='1'>".$clang->gT("Responses containing").":</font><br />\n";
    1082. 

  1082.                     $statisticsoutput .= "\t\t\t\t<input type='text' name='{$myfield2}' value='";
    1083. 

  1083.                     if(isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    1084. 

  1084.                     $statisticsoutput .= "' />\n\t\t\t\t</td>\n";
    1085. 

  1085.                     $counter2++;
    1086. 

  1086.                 }
    1087. 

  1087.             }
    1088. 

  1088.             $statisticsoutput .= "\t\t\t\t<td>\n";
    1089. 

  1089.             $counter=0;
    1090. 

  1090.             break;
    1091. 

  1091. 

  1092.         case ":":  //ARRAY (Multi Flex) (Numbers)
    1093. 

  1093.             $statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    1094. 

  1094.             $query = "SELECT title, question FROM ".db_table_name("questions")." WHERE parent_qid='$flt[0]' AND language = '{$language}'  AND scale_id=0 ORDER BY question_order";
    1095. 

  1095.             $result = db_execute_num($query) or die ("Couldn't get answers!<br />$query<br />".$connect->ErrorMsg());
    1096. 

  1096.             $counter2=0;
    1097. 

  1097.             //Get qidattributes for this question
    1098. 

  1098.             $qidattributes=getQuestionAttributes($flt[0]);
    1099. 

  1099.             if (trim($qidattributes['multiflexible_max'])!='' && trim($qidattributes['multiflexible_min']) ==''){
    1100. 

  1100.                 $maxvalue=$qidattributes['multiflexible_max'];
    1101. 

  1101.                 $minvalue=1;
    1102. 

  1102.             }
    1103. 

  1103.             if (trim($qidattributes['multiflexible_min'])!='' && trim($qidattributes['multiflexible_max']) ==''){
    1104. 

  1104.                 $minvalue=$qidattributes['multiflexible_min'];
    1105. 

  1105.                 $maxvalue=$qidattributes['multiflexible_min'] + 10;
    1106. 

  1106.             }
    1107. 

  1107.             if (trim($qidattributes['multiflexible_min'])=='' && trim($qidattributes['multiflexible_max']) ==''){
    1108. 

  1108.                 $minvalue=1;
    1109. 

  1109.                 $maxvalue=10;
    1110. 

  1110.             }
    1111. 

  1111.             if (trim($qidattributes['multiflexible_min']) !='' && trim($qidattributes['multiflexible_max']) !=''){
    1112. 

  1112.                 if($qidattributes['multiflexible_min'] < $qidattributes['multiflexible_max']){
    1113. 

  1113.                     $minvalue=$qidattributes['multiflexible_min'];
    1114. 

  1114.                     $maxvalue=$qidattributes['multiflexible_max'];
    1115. 

  1115.                 }
    1116. 

  1116.             }
    1117. 

  1117. 

  1118.             if (trim($qidattributes['multiflexible_step'])!='') {
    1119. 

  1119.                 $stepvalue=$qidattributes['multiflexible_step'];
    1120. 

  1120.             } else {
    1121. 

  1121.                 $stepvalue=1;
    1122. 

  1122.             }
    1123. 

  1123.             if ($qidattributes['multiflexible_checkbox']!=0)
    1124. 

  1124.             {
    1125. 

  1125.                 $minvalue=0;
    1126. 

  1126.                 $maxvalue=1;
    1127. 

  1127.                 $stepvalue=1;
    1128. 

  1128.             }
    1129. 

  1129.             while ($row=$result->FetchRow())
    1130. 

  1130.             {
    1131. 

  1131.                 $fquery = "SELECT * FROM ".db_table_name("questions")." WHERE parent_qid={$flt[0]} AND language='{$language}' AND scale_id=1 ORDER BY question_order, title";
    1132. 

  1132.                 $fresult = db_execute_assoc($fquery);
    1133. 

  1133.                 while ($frow = $fresult->FetchRow())
    1134. 

  1134.                 {
    1135. 

  1135.                     $myfield2 = $myfield . $row[0] . "_" . $frow['title'];
    1136. 

  1136.                     $statisticsoutput .= "<!-- $myfield2 - ";
    1137. 

  1137.                     if (isset($_POST[$myfield2])) {$statisticsoutput .= $_POST[$myfield2];}
    1138. 

  1138.                     $statisticsoutput .= " -->\n";
    1139. 

  1139.                     if ($counter2 == 4) {$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n"; $counter2=0;}
    1140. 

  1140.                     $statisticsoutput .= "\t\t\t\t<td align='center'>"
    1141. 

  1141.                     ."<input type='checkbox'  name='summary[]' value='$myfield2'";
    1142. 

  1142.                     if (isset($summary) && array_search($myfield2, $summary)!== FALSE) {$statisticsoutput .= " checked='checked'";}
    1143. 

  1143.                     $statisticsoutput .= " />&nbsp;<strong>"
    1144. 

  1144.                     .showSpeaker($niceqtext." ".str_replace("'", "`", $row[1]." [".$frow['question']."]")." - ".$row[0]."/".$frow['title'])
    1145. 

  1145.                     ."</strong><br />\n";
    1146. 

  1146.                     //$statisticsoutput .= $fquery;
    1147. 

  1147.                     $statisticsoutput .= "\t\t\t\t<select name='{$myfield2}[]' multiple='multiple' rows='5' cols='5'>\n";
    1148. 

  1148.                     for($ii=$minvalue; $ii<=$maxvalue; $ii+=$stepvalue)
    1149. 

  1149.                     {
    1150. 

  1150.                         $statisticsoutput .= "\t\t\t\t\t<option value='$ii'";
    1151. 

  1151.                         if (isset($_POST[$myfield2]) && is_array($_POST[$myfield2]) && in_array($frow['code'], $_POST[$myfield2])) {$statisticsoutput .= " selected";}
    1152. 

  1152.                         $statisticsoutput .= ">$ii</option>\n";
    1153. 

  1153.                     }
    1154. 

  1154.                     $statisticsoutput .= "\t\t\t\t</select>\n\t\t\t\t</td>\n";
    1155. 

  1155.                     $counter2++;
    1156. 

  1156.                 }
    1157. 

  1157.             }
    1158. 

  1158.             $statisticsoutput .= "\t\t\t\t<td>\n";
    1159. 

  1159.             $counter=0;
    1160. 

  1160.             break;
    1161. 

  1161.             /*
    1162. 

  1162.              * For question type "F" and "H" you can use labels.
    1163. 

  1163.              * The only difference is that the labels are applied to column heading
    1164. 

  1164.              * or rows respectively
    1165. 

  1165.              */
    1166. 

  1166.         case "F": // FlEXIBLE ARRAY
    1167. 

  1167.         case "H": // ARRAY (By Column)
    1168. 

  1168.             //$statisticsoutput .= "\t\t\t\t</tr>\n\t\t\t\t<tr>\n";
    1169. 

  1169. 

  1170.             //Get answers. We always use the answer code because the label might be too long elsewise
    1171. 

  1171.             $query =…
    1172.

Large files files are truncated, but you can click here to view the full file