PageRenderTime 31ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 1ms

/application/controllers/admin/printablesurvey.php

https://bitbucket.org/sammousa/valuematchbv-ls2
PHP | 1827 lines | 1446 code | 204 blank | 177 comment | 189 complexity | eded729a03d39c1f741bc4307e2d22fb MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1, BSD-3-Clause, GPL-3.0, LGPL-3.0 
    

  1. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
    2. 

  2. /*
    3. 

  3.  * LimeSurvey
    4. 

  4.  * Copyright (C) 2007-2011 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$
    14. 

  14.  */
    15. 

  15. 

  16. /**
    17. 

  17.  * Printable Survey Controller
    18. 

  18.  *
    19. 

  19.  * This controller shows a printable survey.
    20. 

  20.  *
    21. 

  21.  * @package        LimeSurvey
    22. 

  22.  * @subpackage    Backend
    23. 

  23.  */
    24. 

  24. class printablesurvey extends Survey_Common_Action
    25. 

  25. {
    26. 

  26. 

  27.     /**
    28. 

  28.      * Show printable survey
    29. 

  29.      */
    30. 

  30.     function index($surveyid, $lang = null)
    31. 

  31.     {
    32. 

  32.         $surveyid = sanitize_int($surveyid);
    33. 

  33.         if(!hasSurveyPermission($surveyid,'surveycontent','read'))
    34. 

  34.         {
    35. 

  35.             $clang = $this->getController()->lang;
    36. 

  36.             $aData['surveyid'] = $surveyid;
    37. 

  37.             $this->getController()->_css_admin_includes(Yii::app()->getConfig('adminstyleurl')."superfish.css");
    38. 

  38.             $message['title']= $clang->gT('Access denied!');
    39. 

  39.             $message['message']= $clang->gT('You do not have sufficient rights to access this page.');
    40. 

  40.             $message['class']= "error";
    41. 

  41.             $this->_renderWrappedTemplate('survey', array("message"=>$message), $aData);
    42. 

  42.         }
    43. 

  43.         else
    44. 

  44.         {
    45. 

  45.             // PRESENT SURVEY DATAENTRY SCREEN
    46. 

  46.             // Set the language of the survey, either from GET parameter of session var
    47. 

  47.             if (isset($lang))
    48. 

  48.             {
    49. 

  49.                 $lang = preg_replace("/[^a-zA-Z0-9-]/", "", $lang);
    50. 

  50.                 if ($lang) $surveyprintlang = $lang;
    51. 

  51.             } else
    52. 

  52.             {
    53. 

  53.                 $surveyprintlang=getBaseLanguageFromSurveyID((int) $surveyid);
    54. 

  54.             }
    55. 

  55.             $_POST['surveyprintlang']=$surveyprintlang;
    56. 

  56. 

  57.             // Setting the selected language for printout
    58. 

  58.             $clang = new limesurvey_lang($surveyprintlang);
    59. 

  59. 

  60.             $desrow = Survey::model()->with(array('languagesettings'=>array('condition'=>'surveyls_language=:language','params'=>array(':language'=>$surveyprintlang))))->findByAttributes(array('sid' => $surveyid));
    61. 

  61. 

  62.             if (is_null($desrow))
    63. 

  63.                 $this->getController()->error('Invalid survey ID');
    64. 

  64. 

  65.             $desrow = array_merge($desrow->attributes, $desrow->languagesettings[0]->attributes);
    66. 

  66. 

  67.             //echo '<pre>'.print_r($desrow,true).'</pre>';
    68. 

  68.             $template = $desrow['template'];
    69. 

  69.             $welcome = $desrow['surveyls_welcometext'];
    70. 

  70.             $end = $desrow['surveyls_endtext'];
    71. 

  71.             $surveyname = $desrow['surveyls_title'];
    72. 

  72.             $surveydesc = $desrow['surveyls_description'];
    73. 

  73.             $surveyactive = $desrow['active'];
    74. 

  74.             $surveytable = "{{survey_".$desrow['sid']."}}";
    75. 

  75.             $surveyexpirydate = $desrow['expires'];
    76. 

  76.             $surveyfaxto = $desrow['faxto'];
    77. 

  77.             $dateformattype = $desrow['surveyls_dateformat'];
    78. 

  78. 

  79.             Yii::app()->loadHelper('surveytranslator');
    80. 

  80.             
    81. 

  81.             if (!is_null($surveyexpirydate))
    82. 

  82.             {
    83. 

  83.                 $dformat=getDateFormatData($dateformattype);
    84. 

  84.                 $dformat=$dformat['phpdate'];
    85. 

  85. 

  86.                 $expirytimestamp = strtotime($surveyexpirydate);
    87. 

  87.                 $expirytimeofday_h = date('H',$expirytimestamp);
    88. 

  88.                 $expirytimeofday_m = date('i',$expirytimestamp);
    89. 

  89. 

  90.                 $surveyexpirydate = date($dformat,$expirytimestamp);
    91. 

  91. 

  92.                 if(!empty($expirytimeofday_h) || !empty($expirytimeofday_m))
    93. 

  93.                 {
    94. 

  94.                     $surveyexpirydate .= ' &ndash; '.$expirytimeofday_h.':'.$expirytimeofday_m;
    95. 

  95.                 };            
    96. 

  96.                 sprintf($clang->gT("Please submit by %s"), $surveyexpirydate);
    97. 

  97.             }
    98. 

  98.             else
    99. 

  99.             {
    100. 

  100.                 $surveyexpirydate='';
    101. 

  101.             }
    102. 

  102. 

  103.             if(is_file(Yii::app()->getConfig('usertemplaterootdir').DIRECTORY_SEPARATOR.$template.DIRECTORY_SEPARATOR.'print_survey.pstpl'))
    104. 

  104.             {
    105. 

  105.                 define('PRINT_TEMPLATE_DIR' , Yii::app()->getConfig('usertemplaterootdir').DIRECTORY_SEPARATOR.$template.DIRECTORY_SEPARATOR , true);
    106. 

  106.                 define('PRINT_TEMPLATE_URL' , Yii::app()->getConfig('usertemplaterooturl').'/'.$template.'/' , true);
    107. 

  107.             }
    108. 

  108.             elseif(is_file(Yii::app()->getConfig('usertemplaterootdir').'/'.$template.'/print_survey.pstpl'))
    109. 

  109.             {
    110. 

  110.                 define('PRINT_TEMPLATE_DIR' , Yii::app()->getConfig('standardtemplaterootdir').DIRECTORY_SEPARATOR.$template.DIRECTORY_SEPARATOR , true);
    111. 

  111.                 define('PRINT_TEMPLATE_URL' , Yii::app()->getConfig('standardtemplaterooturl').'/'.$template.'/' , true);
    112. 

  112.             }
    113. 

  113.             else
    114. 

  114.             {
    115. 

  115.                 define('PRINT_TEMPLATE_DIR' , Yii::app()->getConfig('standardtemplaterootdir').DIRECTORY_SEPARATOR.'default'.DIRECTORY_SEPARATOR , true);
    116. 

  116.                 define('PRINT_TEMPLATE_URL' , Yii::app()->getConfig('standardtemplaterooturl').'/default/' , true);
    117. 

  117.             }
    118. 

  118. 

  119.             LimeExpressionManager::StartSurvey($surveyid, 'survey',NULL,false,LEM_PRETTY_PRINT_ALL_SYNTAX);
    120. 

  120.             $moveResult = LimeExpressionManager::NavigateForwards();
    121. 

  121. 

  122.             $condition = "sid = '{$surveyid}' AND language = '{$surveyprintlang}'";
    123. 

  123.             $degresult = Groups::model()->getAllGroups($condition, array('group_order'));  //xiao,
    124. 

  124. 

  125.             if (!isset($surveyfaxto) || !$surveyfaxto and isset($surveyfaxnumber))
    126. 

  126.             {
    127. 

  127.                 $surveyfaxto=$surveyfaxnumber; //Use system fax number if none is set in survey.
    128. 

  128.             }
    129. 

  129. 

  130. 

  131.             $headelements = getPrintableHeader();
    132. 

  132. 

  133.             //if $showsgqacode is enabled at config.php show table name for reference
    134. 

  134.             $showsgqacode = Yii::app()->getConfig("showsgqacode");
    135. 

  135.             if(isset($showsgqacode) && $showsgqacode == true)
    136. 

  136.             {
    137. 

  137.                 $surveyname =  $surveyname."<br />[".$clang->gT('Database')." ".$clang->gT('table').": $surveytable]";
    138. 

  138.             }
    139. 

  139.             else
    140. 

  140.             {
    141. 

  141.                 $surveyname = $surveyname;
    142. 

  142.             }
    143. 

  143. 

  144.             $survey_output = array(
    145. 

  145.             'SITENAME' => Yii::app()->getConfig("sitename")
    146. 

  146.             ,'SURVEYNAME' => $surveyname
    147. 

  147.             ,'SURVEYDESCRIPTION' => $surveydesc
    148. 

  148.             ,'WELCOME' => $welcome
    149. 

  149.             ,'END' => $end
    150. 

  150.             ,'THEREAREXQUESTIONS' => 0
    151. 

  151.             ,'SUBMIT_TEXT' => $clang->gT("Submit Your Survey.")
    152. 

  152.             ,'SUBMIT_BY' => $surveyexpirydate
    153. 

  153.             ,'THANKS' => $clang->gT("Thank you for completing this survey.")
    154. 

  154.             ,'HEADELEMENTS' => $headelements
    155. 

  155.             ,'TEMPLATEURL' => PRINT_TEMPLATE_URL
    156. 

  156.             ,'FAXTO' => $surveyfaxto
    157. 

  157.             ,'PRIVACY' => ''
    158. 

  158.             ,'GROUPS' => ''
    159. 

  159.             );
    160. 

  160. 

  161.             $survey_output['FAX_TO'] ='';
    162. 

  162.             if(!empty($surveyfaxto) && $surveyfaxto != '000-00000000') //If no fax number exists, don't display faxing information!
    163. 

  163.             {
    164. 

  164.                 $survey_output['FAX_TO'] = $clang->gT("Please fax your completed survey to:")." $surveyfaxto";
    165. 

  165.             }
    166. 

  166. 

  167.             /**
    168. 

  168.              * Output arrays:
    169. 

  169.              *    $survey_output  =       final vaiables for whole survey
    170. 

  170.              *        $survey_output['SITENAME'] =
    171. 

  171.              *        $survey_output['SURVEYNAME'] =
    172. 

  172.              *        $survey_output['SURVEY_DESCRIPTION'] =
    173. 

  173.              *        $survey_output['WELCOME'] =
    174. 

  174.              *        $survey_output['THEREAREXQUESTIONS'] =
    175. 

  175.              *        $survey_output['PDF_FORM'] =
    176. 

  176.              *        $survey_output['HEADELEMENTS'] =
    177. 

  177.              *        $survey_output['TEMPLATEURL'] =
    178. 

  178.              *        $survey_output['SUBMIT_TEXT'] =
    179. 

  179.              *        $survey_output['SUBMIT_BY'] =
    180. 

  180.              *        $survey_output['THANKS'] =
    181. 

  181.              *        $survey_output['FAX_TO'] =
    182. 

  182.              *        $survey_output['SURVEY'] =     contains an array of all the group arrays
    183. 

  183.              *
    184. 

  184.              *    $groups[]       =       an array of all the groups output
    185. 

  185.              *        $group['GROUPNAME'] =
    186. 

  186.              *        $group['GROUPDESCRIPTION'] =
    187. 

  187.              *        $group['QUESTIONS'] =     templated formatted content if $question is appended to this at the end of processing each question.
    188. 

  188.              *        $group['ODD_EVEN'] =     class to differentiate alternate groups
    189. 

  189.              *        $group['SCENARIO'] =
    190. 

  190.              *
    191. 

  191.              *    $questions[]    =       contains an array of all the questions within a group
    192. 

  192.              *        $question['QUESTION_CODE'] =         content of the question code field
    193. 

  193.              *        $question['QUESTION_TEXT'] =         content of the question field
    194. 

  194.              *        $question['QUESTION_SCENARIO'] =         if there are conditions on a question, list the conditions.
    195. 

  195.              *        $question['QUESTION_MANDATORY'] =     translated 'mandatory' identifier
    196. 

  196.              *        $question['QUESTION_CLASS'] =         classes to be added to wrapping question div
    197. 

  197.              *        $question['QUESTION_TYPE_HELP'] =         instructions on how to complete the question
    198. 

  198.              *        $question['QUESTION_MAN_MESSAGE'] =     (not sure if this is used) mandatory error
    199. 

  199.              *        $question['QUESTION_VALID_MESSAGE'] =     (not sure if this is used) validation error
    200. 

  200.              *        $question['ANSWER'] =                contains formatted HTML answer
    201. 

  201.              *        $question['QUESTIONHELP'] =         content of the question help field.
    202. 

  202.              *
    203. 

  203.              */
    204. 

  204. 

  205.             $total_questions = 0;
    206. 

  206.             $mapquestionsNumbers=Array();
    207. 

  207.             $answertext = '';   // otherwise can throw an error on line 1617
    208. 

  208. 

  209.             // =========================================================
    210. 

  210.             // START doin the business:
    211. 

  211.             foreach ($degresult->readAll() as $degrow)
    212. 

  212.             {
    213. 

  213.                 // ---------------------------------------------------
    214. 

  214.                 // START doing groups
    215. 

  215.                 $deqresult=Questions::model()->getQuestions($surveyid, $degrow['gid'], $surveyprintlang, 0, '"I"');
    216. 

  216.                 $deqrows = array(); //Create an empty array in case FetchRow does not return any rows
    217. 

  217.                 foreach ($deqresult->readAll() as $deqrow) {$deqrows[] = $deqrow;} // Get table output into array
    218. 

  218. 

  219.                 // Perform a case insensitive natural sort on group name then question title of a multidimensional array
    220. 

  220.                 usort($deqrows, 'groupOrderThenQuestionOrder');
    221. 

  221. 

  222.                 if ($degrow['description'])
    223. 

  223.                 {
    224. 

  224.                     $group_desc = $degrow['description'];
    225. 

  225.                 }
    226. 

  226.                 else
    227. 

  227.                 {
    228. 

  228.                     $group_desc = '';
    229. 

  229.                 }
    230. 

  230. 

  231.                 $group = array(
    232. 

  232.                     'GROUPNAME' => $degrow['group_name']
    233. 

  233.                     ,'GROUPDESCRIPTION' => $group_desc
    234. 

  234.                     ,'QUESTIONS' => '' // templated formatted content if $question is appended to this at the end of processing each question.
    235. 

  235.                 );
    236. 

  236. 

  237.                 // A group can have only hidden questions. In that case you don't want to see the group's header/description either.
    238. 

  238.                 $bGroupHasVisibleQuestions = false;
    239. 

  239.                 $gid = $degrow['gid'];
    240. 

  240.                 //Alternate bgcolor for different groups
    241. 

  241.                 if (!isset($group['ODD_EVEN']) || $group['ODD_EVEN'] == ' g-row-even')
    242. 

  242.                 {
    243. 

  243.                     $group['ODD_EVEN'] = ' g-row-odd';}
    244. 

  244.                 else
    245. 

  245.                 {
    246. 

  246.                     $group['ODD_EVEN'] = ' g-row-even';
    247. 

  247.                 }
    248. 

  248. 

  249.                 //Loop through questions
    250. 

  250.                 foreach ($deqrows as $deqrow)
    251. 

  251.                 {
    252. 

  252.                     // - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    253. 

  253.                     // START doing questions
    254. 

  254. 

  255.                     $qidattributes=getQuestionAttributeValues($deqrow['qid'],$deqrow['type']);
    256. 

  256.                     if ($qidattributes['hidden'] == 1 && $deqrow['type'] != '*')
    257. 

  257.                     {
    258. 

  258.                         continue;
    259. 

  259.                     }
    260. 

  260.                     $bGroupHasVisibleQuestions = true;
    261. 

  261. 

  262.                     //GET ANY CONDITIONS THAT APPLY TO THIS QUESTION
    263. 

  263. 

  264.                     $printablesurveyoutput = '';
    265. 

  265.                     $sExplanation = ''; //reset conditions explanation
    266. 

  266.                     $s=0;
    267. 

  267.                     // TMSW Conditions->Relevance:  show relevance instead of this whole section to create $explanation
    268. 

  268. 

  269. 

  270.                     $scenarioresult=Conditions::model()->getScenarios($deqrow['qid']);
    271. 

  271.                     $scenarioresult = $scenarioresult->readAll();
    272. 

  272.                     //Loop through distinct scenarios, thus grouping them together.
    273. 

  273.                     foreach ($scenarioresult as $scenariorow)
    274. 

  274.                     {
    275. 

  275.                         if( $s == 0 && count($scenarioresult) > 1)
    276. 

  276.                         {
    277. 

  277.                             $sExplanation .= '<p class="scenario">'." -------- Scenario {$scenariorow['scenario']} --------</p>\n\n";
    278. 

  278.                         }
    279. 

  279.                         if($s > 0)
    280. 

  280.                         {
    281. 

  281.                             $sExplanation .= '<p class="scenario">'.' -------- '.$clang->gT("or")." Scenario {$scenariorow['scenario']} --------</p>\n\n";
    282. 

  282.                         }
    283. 

  283. 

  284.                         $x=0;
    285. 

  285. 

  286.                         $conditions1="qid={$deqrow['qid']} AND scenario={$scenariorow['scenario']}";
    287. 

  287.                         $distinctresult=Conditions::model()->getSomeConditions(array('cqid','method', 'cfieldname', 'value'), $conditions1, array('cqid'),array('cqid', 'method','cfieldname','value'));
    288. 

  288. 

  289.                         //Loop through each condition for a particular scenario.
    290. 

  290.                         foreach ($distinctresult->readAll() as $distinctrow)
    291. 

  291.                         {
    292. 

  292.                             $condition = "qid = '{$distinctrow['cqid']}' AND parent_qid = 0 AND language = '{$surveyprintlang}'";
    293. 

  293.                             $subresult=Questions::model()->find($condition);
    294. 

  294. 

  295.                             if($x > 0)
    296. 

  296.                             {
    297. 

  297.                                 $sExplanation .= ' <em class="scenario-and-seperator">'.$clang->gT('and').'</em> ';
    298. 

  298.                             }
    299. 

  299.                             if(trim($distinctrow['method'])=='') //If there is no method chosen assume "equals"
    300. 

  300.                             {
    301. 

  301.                                 $distinctrow['method']='==';
    302. 

  302.                             }
    303. 

  303. 

  304.                             if($distinctrow['cqid']){ // cqid != 0  ==> previous answer match
    305. 

  305.                                 if($distinctrow['method']=='==')
    306. 

  306.                                 {
    307. 

  307.                                     $sExplanation .= $clang->gT("Answer was")." ";
    308. 

  308.                                 }
    309. 

  309.                                 elseif($distinctrow['method']=='!=')
    310. 

  310.                                 {
    311. 

  311.                                     $sExplanation .= $clang->gT("Answer was NOT")." ";
    312. 

  312.                                 }
    313. 

  313.                                 elseif($distinctrow['method']=='<')
    314. 

  314.                                 {
    315. 

  315.                                     $sExplanation .= $clang->gT("Answer was less than")." ";
    316. 

  316.                                 }
    317. 

  317.                                 elseif($distinctrow['method']=='<=')
    318. 

  318.                                 {
    319. 

  319.                                     $sExplanation .= $clang->gT("Answer was less than or equal to")." ";
    320. 

  320.                                 }
    321. 

  321.                                 elseif($distinctrow['method']=='>=')
    322. 

  322.                                 {
    323. 

  323.                                     $sExplanation .= $clang->gT("Answer was greater than or equal to")." ";
    324. 

  324.                                 }
    325. 

  325.                                 elseif($distinctrow['method']=='>')
    326. 

  326.                                 {
    327. 

  327.                                     $sExplanation .= $clang->gT("Answer was greater than")." ";
    328. 

  328.                                 }
    329. 

  329.                                 elseif($distinctrow['method']=='RX')
    330. 

  330.                                 {
    331. 

  331.                                     $sExplanation .= $clang->gT("Answer matched (regexp)")." ";
    332. 

  332.                                 }
    333. 

  333.                                 else
    334. 

  334.                                 {
    335. 

  335.                                     $sExplanation .= $clang->gT("Answer was")." ";
    336. 

  336.                                 }
    337. 

  337.                                 if($distinctrow['value'] == '') {
    338. 

  338.                                     $sExplanation .= ' '.$clang->gT("Not selected").' ';
    339. 

  339.                                 }
    340. 

  340.                                 //If question type is numerical or multi-numerical, show the actual value - otherwise, don't.
    341. 

  341.                                 if($subresult['type'] == 'N' || $subresult['type'] == 'K') {
    342. 

  342.                                     $sExplanation .= ' '.$distinctrow['value']. ' ';
    343. 

  343.                                 }
    344. 

  344.                             }
    345. 

  345.                             if(!$distinctrow['cqid']) { // cqid == 0  ==> token attribute match
    346. 

  346.                                 $tokenData = getTokenFieldsAndNames($surveyid);
    347. 

  347.                                 preg_match('/^{TOKEN:([^}]*)}$/',$distinctrow['cfieldname'],$extractedTokenAttr);
    348. 

  348.                                 $sExplanation .= "Your ".$tokenData[strtolower($extractedTokenAttr[1])]['description']." ";
    349. 

  349.                                 if($distinctrow['method']=='==')
    350. 

  350.                                 {
    351. 

  351.                                     $sExplanation .= $clang->gT("is")." ";
    352. 

  352.                                 }
    353. 

  353.                                 elseif($distinctrow['method']=='!=')
    354. 

  354.                                 {
    355. 

  355.                                     $sExplanation .= $clang->gT("is NOT")." ";
    356. 

  356.                                 }
    357. 

  357.                                 elseif($distinctrow['method']=='<')
    358. 

  358.                                 {
    359. 

  359.                                     $sExplanation .= $clang->gT("is less than")." ";
    360. 

  360.                                 }
    361. 

  361.                                 elseif($distinctrow['method']=='<=')
    362. 

  362.                                 {
    363. 

  363.                                     $sExplanation .= $clang->gT("is less than or equal to")." ";
    364. 

  364.                                 }
    365. 

  365.                                 elseif($distinctrow['method']=='>=')
    366. 

  366.                                 {
    367. 

  367.                                     $sExplanation .= $clang->gT("is greater than or equal to")." ";
    368. 

  368.                                 }
    369. 

  369.                                 elseif($distinctrow['method']=='>')
    370. 

  370.                                 {
    371. 

  371.                                     $sExplanation .= $clang->gT("is greater than")." ";
    372. 

  372.                                 }
    373. 

  373.                                 elseif($distinctrow['method']=='RX')
    374. 

  374.                                 {
    375. 

  375.                                     $sExplanation .= $clang->gT("is matched (regexp)")." ";
    376. 

  376.                                 }
    377. 

  377.                                 else
    378. 

  378.                                 {
    379. 

  379.                                     $sExplanation .= $clang->gT("is")." ";
    380. 

  380.                                 }
    381. 

  381.                                 $answer_section = ' '.$distinctrow['value'].' ';
    382. 

  382.                             }
    383. 

  383. 

  384.                             $conresult=Conditions::model()->getConditionsQuestions($distinctrow['cqid'],$deqrow['qid'],$scenariorow['scenario'],$surveyprintlang);
    385. 

  385. 

  386.                             $conditions=array();
    387. 

  387.                             foreach ($conresult->readAll() as $conrow)
    388. 

  388.                             {
    389. 

  389. 

  390.                                 $postans="";
    391. 

  391.                                 $value=$conrow['value'];
    392. 

  392.                                 switch($conrow['type'])
    393. 

  393.                                 {
    394. 

  394.                                     case "Y":
    395. 

  395.                                     switch ($conrow['value'])
    396. 

  396.                                     {
    397. 

  397.                                         case "Y": $conditions[]=$clang->gT("Yes"); break;
    398. 

  398.                                         case "N": $conditions[]=$clang->gT("No"); break;
    399. 

  399.                                     }
    400. 

  400.                                     break;
    401. 

  401.                                     case "G":
    402. 

  402.                                     switch($conrow['value'])
    403. 

  403.                                     {
    404. 

  404.                                         case "M": $conditions[]=$clang->gT("Male"); break;
    405. 

  405.                                         case "F": $conditions[]=$clang->gT("Female"); break;
    406. 

  406.                                     } // switch
    407. 

  407.                                     break;
    408. 

  408.                                     case "A":
    409. 

  409.                                     case "B":
    410. 

  410.                                     case ":":
    411. 

  411.                                     case ";":
    412. 

  412.                                         $conditions[]=$conrow['value'];
    413. 

  413.                                         break;
    414. 

  414.                                     case "C":
    415. 

  415.                                     switch($conrow['value'])
    416. 

  416.                                     {
    417. 

  417.                                         case "Y": $conditions[]=$clang->gT("Yes"); break;
    418. 

  418.                                         case "U": $conditions[]=$clang->gT("Uncertain"); break;
    419. 

  419.                                         case "N": $conditions[]=$clang->gT("No"); break;
    420. 

  420.                                     } // switch
    421. 

  421.                                     break;
    422. 

  422.                                     case "E":
    423. 

  423.                                     switch($conrow['value'])
    424. 

  424.                                     {
    425. 

  425.                                         case "I": $conditions[]=$clang->gT("Increase"); break;
    426. 

  426.                                         case "D": $conditions[]=$clang->gT("Decrease"); break;
    427. 

  427.                                         case "S": $conditions[]=$clang->gT("Same"); break;
    428. 

  428.                                     }
    429. 

  429.                                     case "1":
    430. 

  430.                                         $labelIndex=preg_match("/^[^#]+#([01]{1})$/",$conrow['cfieldname']);
    431. 

  431.                                         if ($labelIndex == 0)
    432. 

  432.                                         { // TIBO
    433. 

  433. 

  434.                                             $condition="qid='{$conrow['cqid']}' AND code='{$conrow['value']}' AND scale_id=0 AND language='{$surveyprintlang}'";
    435. 

  435.                                             $fresult=Answers::model()->getAllRecords($condition);
    436. 

  436. 

  437.                                             foreach($fresult->readAll() as $frow)
    438. 

  438.                                             {
    439. 

  439.                                                 $postans=$frow['answer'];
    440. 

  440.                                                 $conditions[]=$frow['answer'];
    441. 

  441.                                             } // while
    442. 

  442.                                         }
    443. 

  443.                                         elseif ($labelIndex == 1)
    444. 

  444.                                         {
    445. 

  445. 

  446.                                             $condition="qid='{$conrow['cqid']}' AND code='{$conrow['value']}' AND scale_id=1 AND language='{$surveyprintlang}'";
    447. 

  447.                                             $fresult=Answers::model()->getAllRecords($condition);
    448. 

  448.                                             foreach($fresult->readAll() as $frow)
    449. 

  449.                                             {
    450. 

  450.                                                 $postans=$frow['answer'];
    451. 

  451.                                                 $conditions[]=$frow['answer'];
    452. 

  452.                                             } // while
    453. 

  453.                                         }
    454. 

  454.                                         break;
    455. 

  455.                                     case "L":
    456. 

  456.                                     case "!":
    457. 

  457.                                     case "O":
    458. 

  458.                                     case "R":
    459. 

  459.                                         $condition="qid='{$conrow['cqid']}' AND code='{$conrow['value']}' AND language='{$surveyprintlang}'";
    460. 

  460.                                         $ansresult=Answers::model()->findAll($condition);
    461. 

  461. 

  462.                                         foreach ($ansresult as $ansrow)
    463. 

  463.                                         {
    464. 

  464.                                             $conditions[]=$ansrow['answer'];
    465. 

  465.                                         }
    466. 

  466.                                         if($conrow['value'] == "-oth-") {
    467. 

  467.                                             $conditions[]=$clang->gT("Other");
    468. 

  468.                                         }
    469. 

  469.                                         $conditions = array_unique($conditions);
    470. 

  470.                                         break;
    471. 

  471.                                     case "M":
    472. 

  472.                                     case "P":
    473. 

  473.                                         $condition=" parent_qid='{$conrow['cqid']}' AND title='{$conrow['value']}' AND language='{$surveyprintlang}'";
    474. 

  474.                                         $ansresult=Questions::model()->findAll($condition);
    475. 

  475.                                         foreach ($ansresult as $ansrow)
    476. 

  476.                                         {
    477. 

  477.                                             $conditions[]=$ansrow['question'];
    478. 

  478.                                         }
    479. 

  479.                                         $conditions = array_unique($conditions);
    480. 

  480.                                         break;
    481. 

  481.                                     case "N":
    482. 

  482.                                         $conditions[]=$value;
    483. 

  483.                                         break;
    484. 

  484.                                     case "F":
    485. 

  485.                                     case "H":
    486. 

  486.                                     default:
    487. 

  487.                                         $value=substr($conrow['cfieldname'], strpos($conrow['cfieldname'], "X".$conrow['cqid'])+strlen("X".$conrow['cqid']), strlen($conrow['cfieldname']));
    488. 

  488. 

  489.                                         $condition=" qid='{$conrow['cqid']}' AND code='{$conrow['value']}' AND language='{$surveyprintlang}'";
    490. 

  490. 

  491.                                         $fresult=Answers::model()->getAllRecords($condition);
    492. 

  492.                                         foreach ($fresult->readAll() as $frow)
    493. 

  493.                                         {
    494. 

  494.                                             $postans=$frow['answer'];
    495. 

  495.                                             $conditions[]=$frow['answer'];
    496. 

  496.                                         } // while
    497. 

  497.                                         break;
    498. 

  498.                                 } // switch
    499. 

  499. 

  500.                                 // Now let's complete the answer text with the answer_section
    501. 

  501.                                 $answer_section="";
    502. 

  502.                                 switch($conrow['type'])
    503. 

  503.                                 {
    504. 

  504.                                     case "A":
    505. 

  505.                                     case "B":
    506. 

  506.                                     case "C":
    507. 

  507.                                     case "E":
    508. 

  508.                                     case "F":
    509. 

  509.                                     case "H":
    510. 

  510.                                     case "K":
    511. 

  511.                                         $thiscquestion=$fieldmap[$conrow['cfieldname']];
    512. 

  512.                                         $condition="parent_qid='{$conrow['cqid']}' AND title='{$thiscquestion['aid']}' AND language='{$surveyprintlang}'";
    513. 

  513.                                         $ansresult= Questions::model()->findAll($condition);
    514. 

  514. 

  515.                                         foreach ($ansresult as $ansrow)
    516. 

  516.                                         {
    517. 

  517.                                             $answer_section=" (".$ansrow['question'].")";
    518. 

  518.                                         }
    519. 

  519.                                         break;
    520. 

  520. 

  521.                                     case "1": // dual: (Label 1), (Label 2)
    522. 

  522.                                         $labelIndex=substr($conrow['cfieldname'],-1);
    523. 

  523.                                         $thiscquestion=$fieldmap[$conrow['cfieldname']];
    524. 

  524.                                         $condition="parent_qid='{$conrow['cqid']}' AND title='{$thiscquestion['aid']}' AND language='{$surveyprintlang}'";
    525. 

  525.                                         $ansresult= Questions::model()->findAll($condition);
    526. 

  526.                                         $cqidattributes = getQuestionAttributeValues($conrow['cqid'], $conrow['type']);
    527. 

  527.                                         if ($labelIndex == 0)
    528. 

  528.                                         {
    529. 

  529.                                             if (trim($cqidattributes['dualscale_headerA']) != '') {
    530. 

  530.                                                 $header = $clang->gT($cqidattributes['dualscale_headerA']);
    531. 

  531.                                             } else {
    532. 

  532.                                                 $header = '1';
    533. 

  533.                                             }
    534. 

  534.                                         }
    535. 

  535.                                         elseif ($labelIndex == 1)
    536. 

  536.                                         {
    537. 

  537.                                             if (trim($cqidattributes['dualscale_headerB']) != '') {
    538. 

  538.                                                 $header = $clang->gT($cqidattributes['dualscale_headerB']);
    539. 

  539.                                             } else {
    540. 

  540.                                                 $header = '2';
    541. 

  541.                                             }
    542. 

  542.                                         }
    543. 

  543.                                         foreach ($ansresult->readAll() as $ansrow)
    544. 

  544.                                         {
    545. 

  545.                                             $answer_section=" (".$ansrow['question']." ".sprintf($clang->gT("Label %s"),$header).")";
    546. 

  546.                                         }
    547. 

  547.                                         break;
    548. 

  548.                                     case ":":
    549. 

  549.                                     case ";": //multi flexi: ( answer [label] )
    550. 

  550.                                         $thiscquestion=$fieldmap[$conrow['cfieldname']];
    551. 

  551.                                         $condition="parent_qid='{$conrow['cqid']}' AND title='{$thiscquestion['aid']}' AND language='{$surveyprintlang}'";
    552. 

  552.                                         $ansresult= Questions::model()->findAll($condition);
    553. 

  553.                                         foreach ($ansresult as $ansrow)
    554. 

  554.                                         {
    555. 

  555. 

  556.                                             $condition = "qid = '{$conrow['cqid']}' AND code = '{$conrow['value']}' AND language= '{$surveyprintlang}'";
    557. 

  557.                                             $fresult= Answers::model()->findAll($condition);
    558. 

  558.                                             foreach ($fresult as $frow)
    559. 

  559.                                             {
    560. 

  560.                                                 //$conditions[]=$frow['title'];
    561. 

  561.                                                 $answer_section=" (".$ansrow['question']."[".$frow['answer']."])";
    562. 

  562.                                             } // while
    563. 

  563.                                         }
    564. 

  564.                                         break;
    565. 

  565.                                     case "R": // (Rank 1), (Rank 2)... TIBO
    566. 

  566.                                         $thiscquestion=$fieldmap[$conrow['cfieldname']];
    567. 

  567.                                         $rankid=$thiscquestion['aid'];
    568. 

  568.                                         $answer_section=" (".$clang->gT("RANK")." $rankid)";
    569. 

  569.                                         break;
    570. 

  570.                                     default: // nothing to add
    571. 

  571.                                         break;
    572. 

  572.                                 }
    573. 

  573.                             }
    574. 

  574. 

  575.                             if (count($conditions) > 1)
    576. 

  576.                             {
    577. 

  577.                                 $sExplanation .=  "'".implode("' <em class='scenario-or-seperator'>".$clang->gT("or")."</em> '", $conditions)."'";
    578. 

  578.                             }
    579. 

  579.                             elseif (count($conditions) == 1)
    580. 

  580.                             {
    581. 

  581.                                 $sExplanation .= "'".$conditions[0]."'";
    582. 

  582.                             }
    583. 

  583.                             unset($conditions);
    584. 

  584.                             // Following line commented out because answer_section  was lost, but is required for some question types
    585. 

  585.                             //$explanation .= " ".$clang->gT("to question")." '".$mapquestionsNumbers[$distinctrow['cqid']]."' $answer_section ";
    586. 

  586.                             if($distinctrow['cqid']){
    587. 

  587.                                 $sExplanation .= " <span class='scenario-at-seperator'>".$clang->gT("at question")."</span> '".$mapquestionsNumbers[$distinctrow['cqid']]." [".$subresult['title']."]' (".strip_tags($subresult['question'])."$answer_section)" ;
    588. 

  588.                             }
    589. 

  589.                             else{
    590. 

  590.                                 $sExplanation .= " ".$distinctrow['value'] ;
    591. 

  591.                             }
    592. 

  592.                             //$distinctrow
    593. 

  593.                             $x++;
    594. 

  594.                         }
    595. 

  595.                         $s++;
    596. 

  596.                     }
    597. 

  597. 

  598.                         $qinfo = LimeExpressionManager::GetQuestionStatus($deqrow['qid']);
    599. 

  599.                         $relevance = trim($qinfo['info']['relevance']);
    600. 

  600.                         $sEquation = $qinfo['relEqn'];
    601. 

  601. 

  602.                         if (trim($relevance) != '' && trim($relevance) != '1')
    603. 

  603.                         {
    604. 

  604.                             if (isset($qidattributes['printable_help'][$surveyprintlang]) && $qidattributes['printable_help'][$surveyprintlang]!='')
    605. 

  605.                             {
    606. 

  606.                                 $sExplanation=$qidattributes['printable_help'][$surveyprintlang];
    607. 

  607.                             }
    608. 

  608.                             elseif ($sExplanation=='') // There is only a relevance equation without conditions
    609. 

  609.                             {
    610. 

  610.                                 $sExplanation=$sEquation;
    611. 

  611.                                 $sEquation='&nbsp;'; // No need to show it twice
    612. 

  612.                             }
    613. 

  613.                             $sExplanation = "<b>".$clang->gT('Only answer this question if the following conditions are met:')."</b><br/> ".$sExplanation;
    614. 

  614.                             if (Yii::app()->getConfig('showrelevance')) 
    615. 

  615.                             {
    616. 

  616.                                 $sExplanation.="<span class='printable_equation'><br>".$sEquation."</span>";
    617. 

  617.                             }
    618. 

  618.                         }
    619. 

  619.                         else
    620. 

  620.                         {
    621. 

  621.                             $sExplanation = '';
    622. 

  622.                         }
    623. 

  623. 

  624.                         ++$total_questions;
    625. 

  625. 

  626.                         //TIBO map question qid to their q number
    627. 

  627.                         $mapquestionsNumbers[$deqrow['qid']]=$total_questions;
    628. 

  628.                         //END OF GETTING CONDITIONS
    629. 

  629. 

  630.                         $qid = $deqrow['qid'];
    631. 

  631.                         $fieldname = "$surveyid"."X"."$gid"."X"."$qid";
    632. 

  632. 

  633.                         if(isset($showsgqacode) && $showsgqacode == true)
    634. 

  634.                         {
    635. 

  635.                             $deqrow['question'] = $deqrow['question']."<br />".$clang->gT("ID:")." $fieldname <br />".
    636. 

  636.                                                   $clang->gT("Question code:")." ".$deqrow['title'];
    637. 

  637.                         }
    638. 

  638. 

  639.                         $question = array(
    640. 

  640.                          'QUESTION_NUMBER' => $total_questions    // content of the question code field
    641. 

  641.                         ,'QUESTION_CODE' => $deqrow['title']
    642. 

  642.                         ,'QUESTION_TEXT' => preg_replace('/(?:<br ?\/?>|<\/(?:p|h[1-6])>)$/is' , '' , $deqrow['question'])    // content of the question field
    643. 

  643.                         ,'QUESTION_SCENARIO' => $sExplanation    // if there are conditions on a question, list the conditions.
    644. 

  644.                         ,'QUESTION_MANDATORY' => ''        // translated 'mandatory' identifier
    645. 

  645.                         ,'QUESTION_ID' => $deqrow['qid']    // id to be added to wrapping question div
    646. 

  646.                         ,'QUESTION_CLASS' => getQuestionClass( $deqrow['type'])    // classes to be added to wrapping question div
    647. 

  647.                         ,'QUESTION_TYPE_HELP' => $qinfo['validTip']   // ''        // instructions on how to complete the question // prettyValidTip is too verbose; assuming printable surveys will use static values
    648. 

  648.                         ,'QUESTION_MAN_MESSAGE' => ''        // (not sure if this is used) mandatory error
    649. 

  649.                         ,'QUESTION_VALID_MESSAGE' => ''        // (not sure if this is used) validation error
    650. 

  650.                         ,'QUESTION_FILE_VALID_MESSAGE' => ''// (not sure if this is used) file validation error
    651. 

  651.                         ,'QUESTIONHELP' => ''            // content of the question help field.
    652. 

  652.                         ,'ANSWER' => ''                // contains formatted HTML answer
    653. 

  653.                         );
    654. 

  654. 

  655.                         if($question['QUESTION_TYPE_HELP'] != "") {
    656. 

  656.                             $question['QUESTION_TYPE_HELP'] .= "<br />\n";
    657. 

  657.                         }
    658. 

  658. 

  659.                         if ($deqrow['mandatory'] == 'Y')
    660. 

  660.                         {
    661. 

  661.                             $question['QUESTION_MANDATORY'] = $clang->gT('*');
    662. 

  662.                             $question['QUESTION_CLASS'] .= ' mandatory';
    663. 

  663.                         }
    664. 

  664. 

  665. 

  666.                         //DIFFERENT TYPES OF DATA FIELD HERE
    667. 

  667.                         if ($deqrow['help'])
    668. 

  668.                         {
    669. 

  669.                             $question['QUESTIONHELP'] = $deqrow['help'];
    670. 

  670.                         }
    671. 

  671. 

  672. 

  673.                         if (!empty($qidattributes['page_break']))
    674. 

  674.                         {
    675. 

  675.                             $question['QUESTION_CLASS'] .=' breakbefore ';
    676. 

  676.                         }
    677. 

  677. 

  678. 

  679.                         if (isset($qidattributes['maximum_chars']) && $qidattributes['maximum_chars']!='') {
    680. 

  680.                             $question['QUESTION_CLASS'] ="max-chars-{$qidattributes['maximum_chars']} ".$question['QUESTION_CLASS'];
    681. 

  681.                         }
    682. 

  682. 

  683.                         switch($deqrow['type'])
    684. 

  684.                         {
    685. 

  685.                             // ==================================================================
    686. 

  686.                             case "5":    //5 POINT CHOICE
    687. 

  687.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT('Please choose *only one* of the following:');
    688. 

  688.                                 $question['ANSWER'] .= "\n\t<ul>\n";
    689. 

  689.                                 for ($i=1; $i<=5; $i++)
    690. 

  690.                                 {
    691. 

  691.                                     $question['ANSWER'] .="\t\t<li>\n\t\t\t".self::_input_type_image('radio',$i)."\n\t\t\t$i ".self::_addsgqacode("($i)")."\n\t\t</li>\n";
    692. 

  692.                                 }
    693. 

  693.                                 $question['ANSWER'] .="\t</ul>\n";
    694. 

  694. 

  695.                                 break;
    696. 

  696. 

  697.                                 // ==================================================================
    698. 

  698.                             case "D":  //DATE
    699. 

  699.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT('Please enter a date:');
    700. 

  700.                                 $question['ANSWER'] .= "\t".self::_input_type_image('text',$question['QUESTION_TYPE_HELP'],30,1);
    701. 

  701.                                 break;
    702. 

  702. 

  703.                                 // ==================================================================
    704. 

  704.                             case "G":  //GENDER
    705. 

  705.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose *only one* of the following:");
    706. 

  706. 

  707.                                 $question['ANSWER'] .= "\n\t<ul>\n";
    708. 

  708.                                 $question['ANSWER'] .= "\t\t<li>\n\t\t\t".self::_input_type_image('radio',$clang->gT("Female"))."\n\t\t\t".$clang->gT("Female")." ".self::_addsgqacode("(F)")."\n\t\t</li>\n";
    709. 

  709.                                 $question['ANSWER'] .= "\t\t<li>\n\t\t\t".self::_input_type_image('radio',$clang->gT("Male"))."\n\t\t\t".$clang->gT("Male")." ".self::_addsgqacode("(M)")."\n\t\t</li>\n";
    710. 

  710.                                 $question['ANSWER'] .= "\t</ul>\n";
    711. 

  711.                                 break;
    712. 

  712. 

  713.                                 // ==================================================================
    714. 

  714.                             case "L": //LIST drop-down/radio-button list
    715. 

  715. 

  716.                                 // ==================================================================
    717. 

  717.                             case "!": //List - dropdown
    718. 

  718.                                 if (isset($qidattributes['display_columns']) && trim($qidattributes['display_columns'])!='')
    719. 

  719.                                 {
    720. 

  720.                                     $dcols=$qidattributes['display_columns'];
    721. 

  721.                                 }
    722. 

  722.                                 else
    723. 

  723.                                 {
    724. 

  724.                                     $dcols=0;
    725. 

  725.                                 }
    726. 

  726.                                 if (isset($qidattributes['category_separator']) && trim($qidattributes['category_separator'])!='') {
    727. 

  727.                                     $optCategorySeparator = $qidattributes['category_separator'];
    728. 

  728.                                 }
    729. 

  729.                                 else
    730. 

  730.                                 {
    731. 

  731.                                     unset($optCategorySeparator);
    732. 

  732.                                 }
    733. 

  733. 

  734.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose *only one* of the following:");
    735. 

  735.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    736. 

  736. 

  737.                                 $dearesult=Answers::model()->getAllRecords(" qid='{$deqrow['qid']}' AND language='{$surveyprintlang}' ", array('sortorder','answer'));
    738. 

  738.                                 $dearesult=$dearesult->readAll();
    739. 

  739.                                 $deacount=count($dearesult);
    740. 

  740.                                 if ($deqrow['other'] == "Y") {$deacount++;}
    741. 

  741. 

  742.                                 $wrapper = setupColumns(0, $deacount);
    743. 

  743. 

  744.                                 $question['ANSWER'] = $wrapper['whole-start'];
    745. 

  745. 

  746.                                 $rowcounter = 0;
    747. 

  747.                                 $colcounter = 1;
    748. 

  748. 

  749.                                 foreach ($dearesult as $dearow)
    750. 

  750.                                 {
    751. 

  751.                                     if (isset($optCategorySeparator))
    752. 

  752.                                     {
    753. 

  753.                                         list ($category, $answer) = explode($optCategorySeparator,$dearow['answer']);
    754. 

  754.                                         if ($category != '')
    755. 

  755.                                         {
    756. 

  756.                                             $dearow['answer'] = "($category) $answer ".self::_addsgqacode("(".$dearow['code'].")");
    757. 

  757.                                         }
    758. 

  758.                                         else
    759. 

  759.                                         {
    760. 

  760.                                             $dearow['answer'] = $answer.self::_addsgqacode(" (".$dearow['code'].")");
    761. 

  761.                                         }
    762. 

  762.                                         $question['ANSWER'] .= "\t".$wrapper['item-start']."\t\t".self::_input_type_image('radio' , $dearow['answer'])."\n\t\t\t".$dearow['answer']."\n".$wrapper['item-end'];
    763. 

  763.                                     }
    764. 

  764.                                     else
    765. 

  765.                                     {
    766. 

  766.                                         $question['ANSWER'] .= "\t".$wrapper['item-start']."\t\t".self::_input_type_image('radio' , $dearow['answer'])."\n\t\t\t".$dearow['answer'].self::_addsgqacode(" (".$dearow['code'].")")."\n".$wrapper['item-end'];
    767. 

  767.                                     }
    768. 

  768.                                     ++$rowcounter;
    769. 

  769.                                     if ($rowcounter == $wrapper['maxrows'] && $colcounter < $wrapper['cols'])
    770. 

  770.                                     {
    771. 

  771.                                         if($colcounter == $wrapper['cols'] - 1)
    772. 

  772.                                         {
    773. 

  773.                                             $question['ANSWER'] .= $wrapper['col-devide-last'];
    774. 

  774.                                         }
    775. 

  775.                                         else
    776. 

  776.                                         {
    777. 

  777.                                             $question['ANSWER']  .= $wrapper['col-devide'];
    778. 

  778.                                         }
    779. 

  779.                                         $rowcounter = 0;
    780. 

  780.                                         ++$colcounter;
    781. 

  781.                                     }
    782. 

  782.                                 }
    783. 

  783.                                 if ($deqrow['other'] == 'Y')
    784. 

  784.                                 {
    785. 

  785.                                     if(trim($qidattributes["other_replace_text"][$surveyprintlang])=='')
    786. 

  786.                                     {$qidattributes["other_replace_text"][$surveyprintlang]="Other";}
    787. 

  787.                                     //                    $printablesurveyoutput .="\t".$wrapper['item-start']."\t\t".self::_input_type_image('radio' , $clang->gT("Other"))."\n\t\t\t".$clang->gT("Other")."\n\t\t\t<input type='text' size='30' readonly='readonly' />\n".$wrapper['item-end'];
    788. 

  788.                                     $question['ANSWER']  .= $wrapper['item-start-other'].self::_input_type_image('radio',$clang->gT($qidattributes["other_replace_text"][$surveyprintlang])).' '.$clang->gT($qidattributes["other_replace_text"][$surveyprintlang]).self::_addsgqacode(" (-oth-)")."\n\t\t\t".self::_input_type_image('other').self::_addsgqacode(" (".$deqrow['sid']."X".$deqrow['gid']."X".$deqrow['qid']."other)")."\n".$wrapper['item-end'];
    789. 

  789.                                 }
    790. 

  790.                                 $question['ANSWER'] .= $wrapper['whole-end'];
    791. 

  791.                                 //Let's break the presentation into columns.
    792. 

  792.                                 break;
    793. 

  793. 

  794.                                 // ==================================================================
    795. 

  795.                             case "O":  //LIST WITH COMMENT
    796. 

  796.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose *only one* of the following:");
    797. 

  797.                                 $dearesult=Answers::model()->getAllRecords(" qid='{$deqrow['qid']}' AND language='{$surveyprintlang}'", array('sortorder', 'answer') );
    798. 

  798. 

  799.                                 $question['ANSWER'] = "\t<ul>\n";
    800. 

  800.                                 foreach ($dearesult->readAll() as $dearow)
    801. 

  801.                                 {
    802. 

  802.                                     $question['ANSWER'] .= "\t\t<li>\n\t\t\t".self::_input_type_image('radio',$dearow['answer'])."\n\t\t\t".$dearow['answer'].self::_addsgqacode(" (".$dearow['code'].")")."\n\t\t</li>\n";
    803. 

  803.                                 }
    804. 

  804.                                 $question['ANSWER'] .= "\t</ul>\n";
    805. 

  805. 

  806.                                 $question['ANSWER'] .= "\t<p class=\"comment\">\n\t\t".$clang->gT("Make a comment on your choice here:")."\n";
    807. 

  807.                                 $question['ANSWER'] .= "\t\t".self::_input_type_image('textarea',$clang->gT("Make a comment on your choice here:"),50,8).self::_addsgqacode(" (".$deqrow['sid']."X".$deqrow['gid']."X".$deqrow['qid']."comment)")."\n\t</p>\n";
    808. 

  808.                                 break;
    809. 

  809. 

  810.                                 // ==================================================================
    811. 

  811.                             case "R":  //RANKING Type Question
    812. 

  812.                                 $rearesult=Answers::model()->getAllRecords(" qid='{$deqrow['qid']}' AND language='{$surveyprintlang}'", array('sortorder', 'answer'));
    813. 

  813.                                 $rearesult = $rearesult->readAll();
    814. 

  814.                                 $reacount = count($rearesult);
    815. 

  815.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please number each box in order of preference from 1 to")." $reacount";
    816. 

  816.                                 $question['QUESTION_TYPE_HELP'] .= self::_min_max_answers_help($qidattributes, $surveyprintlang, $surveyid);
    817. 

  817.                                 $question['ANSWER'] = "\n<ul>\n";
    818. 

  818.                                 foreach ($rearesult as $rearow)
    819. 

  819.                                 {
    820. 

  820.                                     $question['ANSWER'] .="\t<li>\n\t".self::_input_type_image('rank','',4,1)."\n\t\t&nbsp;".$rearow['answer'].self::_addsgqacode(" (".$fieldname.$rearow['code'].")")."\n\t</li>\n";
    821. 

  821.                                 }
    822. 

  822.                                 $question['ANSWER'] .= "\n</ul>\n";
    823. 

  823.                                 break;
    824. 

  824. 

  825.                                 // ==================================================================
    826. 

  826.                             case "M":  //Multiple choice (Quite tricky really!)
    827. 

  827. 

  828.                                 if (trim($qidattributes['display_columns'])!='')
    829. 

  829.                                 {
    830. 

  830.                                     $dcols=$qidattributes['display_columns'];
    831. 

  831.                                 }
    832. 

  832.                                 else
    833. 

  833.                                 {
    834. 

  834.                                     $dcols=0;
    835. 

  835.                                 }
    836. 

  836.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose *all* that apply:");
    837. 

  837.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    838. 

  838. 

  839.                                 $mearesult = Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}' AND language='{$surveyprintlang}' ", array('question_order'));
    840. 

  840.                                 $mearesult = $mearesult->readAll();
    841. 

  841.                                 $meacount = count($mearesult);
    842. 

  842.                                 if ($deqrow['other'] == 'Y') {$meacount++;}
    843. 

  843. 

  844.                                 $wrapper = setupColumns($dcols, $meacount);
    845. 

  845.                                 $question['ANSWER'] = $wrapper['whole-start'];
    846. 

  846. 

  847.                                 $rowcounter = 0;
    848. 

  848.                                 $colcounter = 1;
    849. 

  849. 

  850.                                 foreach ($mearesult as $mearow)
    851. 

  851.                                 {
    852. 

  852.                                     $question['ANSWER'] .= $wrapper['item-start'].self::_input_type_image('checkbox',$mearow['question'])."\n\t\t".$mearow['question'].self::_addsgqacode(" (".$fieldname.$mearow['title'].") ").$wrapper['item-end'];
    853. 

  853.                                     ++$rowcounter;
    854. 

  854.                                     if ($rowcounter == $wrapper['maxrows'] && $colcounter < $wrapper['cols'])
    855. 

  855.                                     {
    856. 

  856.                                         if($colcounter == $wrapper['cols'] - 1)
    857. 

  857.                                         {
    858. 

  858.                                             $question['ANSWER'] .= $wrapper['col-devide-last'];
    859. 

  859.                                         }
    860. 

  860.                                         else
    861. 

  861.                                         {
    862. 

  862.                                             $question['ANSWER'] .= $wrapper['col-devide'];
    863. 

  863.                                         }
    864. 

  864.                                         $rowcounter = 0;
    865. 

  865.                                         ++$colcounter;
    866. 

  866.                                     }
    867. 

  867.                                 }
    868. 

  868.                                 if ($deqrow['other'] == "Y")
    869. 

  869.                                 {
    870. 

  870.                                     if (trim($qidattributes['other_replace_text'][$surveyprintlang])=='')
    871. 

  871.                                     {
    872. 

  872.                                         $qidattributes["other_replace_text"][$surveyprintlang]="Other";
    873. 

  873.                                     }
    874. 

  874.                                     if(!isset($mearow['answer'])) $mearow['answer']="";
    875. 

  875.                                     $question['ANSWER'] .= $wrapper['item-start-other'].self::_input_type_image('checkbox',$mearow['answer']).$clang->gT($qidattributes["other_replace_text"][$surveyprintlang]).":\n\t\t".self::_input_type_image('other').self::_addsgqacode(" (".$fieldname."other) ").$wrapper['item-end'];
    876. 

  876.                                 }
    877. 

  877.                                 $question['ANSWER'] .= $wrapper['whole-end'];
    878. 

  878.                                 //                }
    879. 

  879.                                 break;
    880. 

  880. 

  881.                                  // ==================================================================
    882. 

  882.                             case "P":  //Multiple choice with comments
    883. 

  883.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose all that apply and provide a comment:");
    884. 

  884. 

  885.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    886. 

  886.                                 $mearesult=Questions::model()->getAllRecords("parent_qid='{$deqrow['qid']}'  AND language='{$surveyprintlang}'", array('question_order'));
    887. 

  887.                                 //                $printablesurveyoutput .="\t\t\t<u>".$clang->gT("Please choose all that apply and provide a comment:")."</u><br />\n";
    888. 

  888.                                 $j=0;
    889. 

  889.                                 $longest_string = 0;
    890. 

  890.                                 foreach ($mearesult->readAll() as $mearow)
    891. 

  891.                                 {
    892. 

  892.                                     $longest_string = longestString($mearow['question'] , $longest_string );
    893. 

  893.                                     $question['ANSWER'] .= "\t<li><span>\n\t\t".self::_input_type_image('checkbox',$mearow['question']).$mearow['question'].self::_addsgqacode(" (".$fieldname.$mearow['title'].") ")."</span>\n\t\t".self::_input_type_image('text','comment box',60).self::_addsgqacode(" (".$fieldname.$mearow['title']."comment) ")."\n\t</li>\n";
    894. 

  894.                                     $j++;
    895. 

  895.                                 }
    896. 

  896.                                 if ($deqrow['other'] == "Y")
    897. 

  897.                                 {
    898. 

  898.                                     $question['ANSWER'] .= "\t<li class=\"other\">\n\t\t<div class=\"other-replacetext\">".$clang->gT('Other:').self::_input_type_image('other','',1)."</div>".self::_input_type_image('othercomment','comment box',50).self::_addsgqacode(" (".$fieldname."other) ")."\n\t</li>\n";
    899. 

  899.                                     $j++;
    900. 

  900.                                 }
    901. 

  901. 

  902.                                 $question['ANSWER'] = "\n<ul>\n".$question['ANSWER']."</ul>\n";
    903. 

  903.                                 break;
    904. 

  904. 

  905. 

  906.                                 // ==================================================================
    907. 

  907.                             case "Q":  //MULTIPLE SHORT TEXT
    908. 

  908.                                 $width=60;
    909. 

  909. 

  910.                                 // ==================================================================
    911. 

  911.                             case "K":  //MULTIPLE NUMERICAL
    912. 

  912.                                 $question['QUESTION_TYPE_HELP'] = "";
    913. 

  913.                                 $width=(isset($width))?$width:16;
    914. 

  914. 

  915.     //                            if (!empty($qidattributes['equals_num_value']))
    916. 

  916.     //                            {
    917. 

  917.     //                                $question['QUESTION_TYPE_HELP'] .= "* ".sprintf($clang->gT('Total of all entries must equal %d'),$qidattributes['equals_num_value'])."<br />\n";
    918. 

  918.     //                            }
    919. 

  919.     //                            if (!empty($qidattributes['max_num_value']))
    920. 

  920.     //                            {
    921. 

  921.     //                                $question['QUESTION_TYPE_HELP'] .= sprintf($clang->gT('Total of all entries must not exceed %d'), $qidattributes['max_num_value'])."<br />\n";
    922. 

  922.     //                            }
    923. 

  923.     //                            if (!empty($qidattributes['min_num_value']))
    924. 

  924.     //                            {
    925. 

  925.     //                                $question['QUESTION_TYPE_HELP'] .= sprintf($clang->gT('Total of all entries must be at least %s'),$qidattributes['min_num_value'])."<br />\n";
    926. 

  926.     //                            }
    927. 

  927. 

  928.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please write your answer(s) here:");
    929. 

  929. 

  930. 

  931.                                 $longest_string = 0;
    932. 

  932.                                 $mearesult=Questions::model()->getAllRecords("parent_qid='{$deqrow['qid']}' AND language='{$surveyprintlang}'", array('question_order'));
    933. 

  933.                                 foreach ($mearesult->readAll() as $mearow)
    934. 

  934.                                 {
    935. 

  935.                                     $longest_string = longestString($mearow['question'] , $longest_string );
    936. 

  936.                                     if (isset($qidattributes['slider_layout']) && $qidattributes['slider_layout']==1)
    937. 

  937.                                     {
    938. 

  938.                                       $mearow['question']=explode(':',$mearow['question']);
    939. 

  939.                                       $mearow['question']=$mearow['question'][0];
    940. 

  940.                                     }
    941. 

  941.                                     $question['ANSWER'] .=  "\t<li>\n\t\t<span>".$mearow['question']."</span>\n\t\t".self::_input_type_image('text',$mearow['question'],$width).self::_addsgqacode(" (".$fieldname.$mearow['title'].") ")."\n\t</li>\n";
    942. 

  942.                                 }
    943. 

  943.                                 $question['ANSWER'] =  "\n<ul>\n".$question['ANSWER']."</ul>\n";
    944. 

  944.                                 break;
    945. 

  945. 

  946. 

  947.                                 // ==================================================================
    948. 

  948.                             case "S":  //SHORT TEXT
    949. 

  949.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please write your answer here:");
    950. 

  950.                                 $question['ANSWER'] = self::_input_type_image('text',$question['QUESTION_TYPE_HELP'], 50);
    951. 

  951.                                 break;
    952. 

  952. 

  953. 

  954.                                 // ==================================================================
    955. 

  955.                             case "T":  //LONG TEXT
    956. 

  956.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please write your answer here:");
    957. 

  957.                                 $question['ANSWER'] = self::_input_type_image('textarea',$question['QUESTION_TYPE_HELP'], '100%' , 8);
    958. 

  958.                                 break;
    959. 

  959. 

  960. 

  961.                                 // ==================================================================
    962. 

  962.                             case "U":  //HUGE TEXT
    963. 

  963.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please write your answer here:");
    964. 

  964.                                 $question['ANSWER'] = self::_input_type_image('textarea',$question['QUESTION_TYPE_HELP'], '100%' , 30);
    965. 

  965.                                 break;
    966. 

  966. 

  967. 

  968.                                 // ==================================================================
    969. 

  969.                             case "N":  //NUMERICAL
    970. 

  970.                                 $prefix="";
    971. 

  971.                                 $suffix="";
    972. 

  972.                                 if($qidattributes['prefix'][$surveyprintlang] != "") {
    973. 

  973.                                     $prefix=$qidattributes['prefix'][$surveyprintlang];
    974. 

  974.                                 }
    975. 

  975.                                 if($qidattributes['suffix'][$surveyprintlang] != "") {
    976. 

  976.                                     $suffix=$qidattributes['suffix'][$surveyprintlang];
    977. 

  977.                                 }
    978. 

  978.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please write your answer here:");
    979. 

  979.                                 $question['ANSWER'] = "<ul>\n\t<li>\n\t\t<span>$prefix</span>\n\t\t".self::_input_type_image('text',$question['QUESTION_TYPE_HELP'],20)."\n\t\t<span>$suffix</span>\n\t\t</li>\n\t</ul>";
    980. 

  980.                                 break;
    981. 

  981. 

  982.                                 // ==================================================================
    983. 

  983.                             case "Y":  //YES/NO
    984. 

  984.                                   $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose *only one* of the following:");
    985. 

  985.                                 $question['ANSWER'] = "\n<ul>\n\t<li>\n\t\t".self::_input_type_image('radio',$clang->gT('Yes'))."\n\t\t".$clang->gT('Yes').self::_addsgqacode(" (Y)")."\n\t</li>\n";
    986. 

  986.                                 $question['ANSWER'] .= "\n\t<li>\n\t\t".self::_input_type_image('radio',$clang->gT('No'))."\n\t\t".$clang->gT('No').self::_addsgqacode(" (N)")."\n\t</li>\n</ul>\n";
    987. 

  987.                                 break;
    988. 

  988. 

  989. 

  990.                                 // ==================================================================
    991. 

  991.                             case "A":  //ARRAY (5 POINT CHOICE)
    992. 

  992.                                 $condition = "parent_qid = '{$deqrow['qid']}'  AND language= '{$surveyprintlang}'";
    993. 

  993.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose the appropriate response for each item:");
    994. 

  994.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    995. 

  995. 

  996.                                 $question['ANSWER'] = "
    997. 

  997.             <table>
    998. 

  998.                 <thead>
    999. 

  999.                     <tr>
    1000. 

  1000.                         <td>&nbsp;</td>
    1001. 

  1001.                         <th style='font-family:Arial,helvetica,sans-serif;font-weight:normal;'>1&nbsp;&nbsp;&nbsp;&nbsp;".self::_addsgqacode(" (1)")."</th>
    1002. 

  1002.                         <th style='font-family:Arial,helvetica,sans-serif;font-weight:normal;'>2&nbsp;&nbsp;&nbsp;&nbsp;".self::_addsgqacode(" (2)")."</th>
    1003. 

  1003.                         <th style='font-family:Arial,helvetica,sans-serif;font-weight:normal;'>3&nbsp;&nbsp;&nbsp;&nbsp;".self::_addsgqacode(" (3)")."</th>
    1004. 

  1004.                         <th style='font-family:Arial,helvetica,sans-serif;font-weight:normal;'>4&nbsp;&nbsp;&nbsp;&nbsp;".self::_addsgqacode(" (4)")."</th>
    1005. 

  1005.                         <th style='font-family:Arial,helvetica,sans-serif;font-weight:normal;'>5".self::_addsgqacode(" (5)")."</th>
    1006. 

  1006.                     </tr>
    1007. 

  1007.                 </thead>
    1008. 

  1008.                 <tbody>";
    1009. 

    1010. 

  1010.                                 $j=0;
    1011. 

  1011.                                 $rowclass = 'array1';
    1012. 

  1012.                                 $mearesult= Questions::model()->getAllRecords( $condition, array('question_order'));
    1013. 

  1013.                                 foreach ($mearesult->readAll() as $mearow)
    1014. 

  1014.                                 {
    1015. 

  1015.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n";
    1016. 

  1016.                                     $rowclass = alternation($rowclass,'row');
    1017. 

  1017. 

  1018.                                     //semantic differential question type?
    1019. 

  1019.                                     if (strpos($mearow['question'],'|'))
    1020. 

  1020.                                     {
    1021. 

  1021.                                         $answertext = substr($mearow['question'],0, strpos($mearow['question'],'|')).self::_addsgqacode(" (".$fieldname.$mearow['title'].")")." ";
    1022. 

  1022.                                     }
    1023. 

  1023.                                     else
    1024. 

  1024.                                     {
    1025. 

  1025.                                         $answertext=$mearow['question'].self::_addsgqacode(" (".$fieldname.$mearow['title'].")");
    1026. 

  1026.                                     }
    1027. 

  1027.                                     $question['ANSWER'] .= "\t\t\t<th class=\"answertext\">$answertext</th>\n";
    1028. 

  1028. 

  1029.                                     for ($i=1; $i<=5; $i++)
    1030. 

  1030.                                     {
    1031. 

  1031.                                         $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$i)."</td>\n";
    1032. 

  1032.                                     }
    1033. 

  1033. 

  1034.                                     $answertext .= $mearow['question'];
    1035. 

  1035. 

  1036.                                     //semantic differential question type?
    1037. 

  1037.                                     if (strpos($mearow['question'],'|'))
    1038. 

  1038.                                     {
    1039. 

  1039.                                         $answertext2 = substr($mearow['question'],strpos($mearow['question'],'|')+1);
    1040. 

  1040.                                         $question['ANSWER'] .= "\t\t\t<th class=\"answertextright\">$answertext2</td>\n";
    1041. 

  1041.                                     }
    1042. 

  1042.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1043. 

  1043.                                     $j++;
    1044. 

  1044.                                 }
    1045. 

  1045.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1046. 

  1046.                                 break;
    1047. 

  1047. 

  1048.                                 // ==================================================================
    1049. 

  1049.                             case "B":  //ARRAY (10 POINT CHOICE)
    1050. 

  1050. 

  1051.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose the appropriate response for each item:");
    1052. 

  1052.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    1053. 

  1053. 

  1054.                                 $question['ANSWER'] .= "\n<table>\n\t<thead>\n\t\t<tr>\n\t\t\t<td>&nbsp;</td>\n";
    1055. 

  1055.                                 for ($i=1; $i<=10; $i++)
    1056. 

  1056.                                 {
    1057. 

  1057.                                     $question['ANSWER'] .= "\t\t\t<th>$i".self::_addsgqacode(" ($i)")."</th>\n";
    1058. 

  1058.                                 }
    1059. 

  1059.                                 $question['ANSWER'] .= "\t</thead>\n\n\t<tbody>\n";
    1060. 

  1060.                                 $j=0;
    1061. 

  1061.                                 $rowclass = 'array1';
    1062. 

  1062.                                 $mearesult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}' AND language='{$surveyprintlang}' ", array('question_order'));
    1063. 

  1063.                                 foreach ($mearesult->readAll() as $mearow)
    1064. 

  1064.                                 {
    1065. 

  1065. 

  1066.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n\t\t\t<th class=\"answertext\">{$mearow['question']}".self::_addsgqacode(" (".$fieldname.$mearow['title'].")")."</th>\n";
    1067. 

  1067.                                     $rowclass = alternation($rowclass,'row');
    1068. 

  1068. 

  1069.                                     for ($i=1; $i<=10; $i++)
    1070. 

  1070.                                     {
    1071. 

  1071.                                         $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$i)."</td>\n";
    1072. 

  1072.                                     }
    1073. 

  1073.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1074. 

  1074.                                     $j++;
    1075. 

  1075.                                 }
    1076. 

  1076.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1077. 

  1077.                                 break;
    1078. 

  1078. 

  1079.                                 // ==================================================================
    1080. 

  1080.                             case "C":  //ARRAY (YES/UNCERTAIN/NO)
    1081. 

  1081. 

  1082.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose the appropriate response for each item:");
    1083. 

  1083.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    1084. 

  1084. 

  1085.                                 $question['ANSWER'] = '
    1086. 

  1086.             <table>
    1087. 

  1087.                 <thead>
    1088. 

  1088.                     <tr>
    1089. 

  1089.                         <td>&nbsp;</td>
    1090. 

  1090.                         <th>'.$clang->gT("Yes").self::_addsgqacode(" (Y)").'</th>
    1091. 

  1091.                         <th>'.$clang->gT("Uncertain").self::_addsgqacode(" (U)").'</th>
    1092. 

  1092.                         <th>'.$clang->gT("No").self::_addsgqacode(" (N)").'</th>
    1093. 

  1093.                     </tr>
    1094. 

  1094.                 </thead>
    1095. 

  1095.                 <tbody>
    1096. 

  1096.             ';
    1097. 

  1097.                                 $j=0;
    1098. 

  1098. 

  1099.                                 $rowclass = 'array1';
    1100. 

  1100. 

  1101.                                 $mearesult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}'  AND language='{$surveyprintlang}' ", array('question_order'));
    1102. 

  1102.                                 foreach ($mearesult->readAll() as $mearow)
    1103. 

  1103.                                 {
    1104. 

  1104.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n";
    1105. 

  1105.                                     $question['ANSWER'] .= "\t\t\t<th class=\"answertext\">{$mearow['question']}".self::_addsgqacode(" (".$fieldname.$mearow['title'].")")."</th>\n";
    1106. 

  1106.                                     $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$clang->gT("Yes"))."</td>\n";
    1107. 

  1107.                                     $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$clang->gT("Uncertain"))."</td>\n";
    1108. 

  1108.                                     $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$clang->gT("No"))."</td>\n";
    1109. 

  1109.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1110. 

  1110. 

  1111.                                     $j++;
    1112. 

  1112.                                     $rowclass = alternation($rowclass,'row');
    1113. 

  1113.                                 }
    1114. 

  1114.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1115. 

  1115.                                 break;
    1116. 

  1116. 

  1117.                             case "E":  //ARRAY (Increase/Same/Decrease)
    1118. 

  1118.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose the appropriate response for each item:");
    1119. 

  1119.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    1120. 

  1120. 

  1121.                                 $question['ANSWER'] = '
    1122. 

  1122.             <table>
    1123. 

  1123.                 <thead>
    1124. 

  1124.                     <tr>
    1125. 

  1125.                         <td>&nbsp;</td>
    1126. 

  1126.                         <th>'.$clang->gT("Increase").self::_addsgqacode(" (I)").'</th>
    1127. 

  1127.                         <th>'.$clang->gT("Same").self::_addsgqacode(" (S)").'</th>
    1128. 

  1128.                         <th>'.$clang->gT("Decrease").self::_addsgqacode(" (D)").'</th>
    1129. 

  1129.                     </tr>
    1130. 

  1130.                 </thead>
    1131. 

  1131.                 <tbody>
    1132. 

  1132.             ';
    1133. 

  1133.                                 $j=0;
    1134. 

  1134.                                 $rowclass = 'array1';
    1135. 

  1135. 

  1136.                                 $mearesult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}'  AND language='{$surveyprintlang}' ", array('question_order'));
    1137. 

  1137.                                 foreach ($mearesult->readAll() as $mearow)
    1138. 

  1138.                                 {
    1139. 

  1139.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n";
    1140. 

  1140.                                     $question['ANSWER'] .= "\t\t\t<th class=\"answertext\">{$mearow['question']}".self::_addsgqacode(" (".$fieldname.$mearow['title'].")")."</th>\n";
    1141. 

  1141.                                     $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$clang->gT("Increase"))."</td>\n";
    1142. 

  1142.                                     $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$clang->gT("Same"))."</td>\n";
    1143. 

  1143.                                     $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio',$clang->gT("Decrease"))."</td>\n";
    1144. 

  1144.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1145. 

  1145.                                     $j++;
    1146. 

  1146.                                     $rowclass = alternation($rowclass,'row');
    1147. 

  1147.                                 }
    1148. 

  1148.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1149. 

  1149.                                 break;
    1150. 

  1150. 

  1151.                                 // ==================================================================
    1152. 

  1152.                             case ":": //ARRAY (Multi Flexible) (Numbers)
    1153. 

  1153.                                 $headstyle="style='padding-left: 20px; padding-right: 7px'";
    1154. 

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

  1155.                                     $maxvalue=$qidattributes['multiflexible_max'];
    1156. 

  1156.                                     $minvalue=1;
    1157. 

  1157.                                 }
    1158. 

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

  1159.                                     $minvalue=$qidattributes['multiflexible_min'];
    1160. 

  1160.                                     $maxvalue=$qidattributes['multiflexible_min'] + 10;
    1161. 

  1161.                                 }
    1162. 

  1162.                                 if (trim($qidattributes['multiflexible_min'])=='' && trim($qidattributes['multiflexible_max']) =='') {
    1163. 

  1163.                                     $minvalue=1;
    1164. 

  1164.                                     $maxvalue=10;
    1165. 

  1165.                                 }
    1166. 

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

  1167.                                     if($qidattributes['multiflexible_min'] < $qidattributes['multiflexible_max']){
    1168. 

  1168.                                         $minvalue=$qidattributes['multiflexible_min'];
    1169. 

  1169.                                         $maxvalue=$qidattributes['multiflexible_max'];
    1170. 

  1170.                                     }
    1171. 

  1171.                                 }
    1172. 

  1172. 

  1173.                                 if (trim($qidattributes['multiflexible_step'])!='') {
    1174. 

  1174.                                     $stepvalue=$qidattributes['multiflexible_step'];
    1175. 

  1175.                                 }
    1176. 

  1176.                                 else
    1177. 

  1177.                                 {
    1178. 

  1178.                                     $stepvalue=1;
    1179. 

  1179.                                 }
    1180. 

  1180.                                 if ($qidattributes['multiflexible_checkbox']!=0) {
    1181. 

  1181.                                     $checkboxlayout=true;
    1182. 

  1182.                                 } else {
    1183. 

  1183.                                     $checkboxlayout=false;
    1184. 

  1184.                                 }
    1185. 

  1185. 

  1186.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    1187. 

  1187. 

  1188.                                 $question['ANSWER'] .= "\n<table>\n\t<thead>\n\t\t<tr>\n\t\t\t<td>&nbsp;</td>\n";
    1189. 

  1189.                                 $fresult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}' and scale_id=1 AND language='{$surveyprintlang}' ", array('question_order'));
    1190. 

  1190.                                 $fresult = $fresult->readAll();
    1191. 

  1191.                                 $fcount = count($fresult);
    1192. 

  1192.                                 $fwidth = "120";
    1193. 

  1193.                                 $i=0;
    1194. 

  1194.                                 //array to temporary store X axis question codes
    1195. 

  1195.                                 $xaxisarray = array();
    1196. 

  1196.                                 foreach ($fresult as $frow)
    1197. 

  1197. 

  1198.                                 {
    1199. 

  1199.                                     $question['ANSWER'] .= "\t\t\t<th>{$frow['question']}</th>\n";
    1200. 

  1200.                                     $i++;
    1201. 

  1201. 

  1202.                                     //add current question code
    1203. 

  1203.                                     $xaxisarray[$i] = $frow['title'];
    1204. 

  1204.                                 }
    1205. 

  1205.                                 $question['ANSWER'] .= "\t\t</tr>\n\t</thead>\n\n\t<tbody>\n";
    1206. 

  1206.                                 $a=1; //Counter for pdfoutput
    1207. 

  1207.                                 $rowclass = 'array1';
    1208. 

  1208. 

  1209.                                 $mearesult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}' and scale_id=0 AND language='{$surveyprintlang}' ", array('question_order'));
    1210. 

  1210.                                 $result = $mearesult->readAll();
    1211. 

  1211.                                 foreach ($result as $frow)
    1212. 

  1212.                                 {
    1213. 

  1213.                                     $question['ANSWER'] .= "\t<tr class=\"$rowclass\">\n";
    1214. 

  1214.                                     $rowclass = alternation($rowclass,'row');
    1215. 

  1215. 

  1216.                                     $answertext=$frow['question'];
    1217. 

  1217.                                     if (strpos($answertext,'|')) {$answertext=substr($answertext,0, strpos($answertext,'|'));}
    1218. 

  1218.                                     $question['ANSWER'] .= "\t\t\t\t\t<th class=\"answertext\">$answertext</th>\n";
    1219. 

  1219.                                     //$printablesurveyoutput .="\t\t\t\t\t<td>";
    1220. 

  1220.                                     for ($i=1; $i<=$fcount; $i++)
    1221. 

  1221.                                     {
    1222. 

  1222. 

  1223.                                         $question['ANSWER'] .= "\t\t\t<td>\n";
    1224. 

  1224.                                         if ($checkboxlayout === false)
    1225. 

  1225.                                         {
    1226. 

  1226.                                             $question['ANSWER'] .= "\t\t\t\t".self::_input_type_image('text','',4).self::_addsgqacode(" (".$fieldname.$frow['title']."_".$xaxisarray[$i].") ")."\n";
    1227. 

  1227.                                         }
    1228. 

  1228.                                         else
    1229. 

  1229.                                         {
    1230. 

  1230.                                             $question['ANSWER'] .= "\t\t\t\t".self::_input_type_image('checkbox').self::_addsgqacode(" (".$fieldname.$frow['title']."_".$xaxisarray[$i].") ")."\n";
    1231. 

  1231.                                         }
    1232. 

  1232.                                         $question['ANSWER'] .= "\t\t\t</td>\n";
    1233. 

  1233.                                     }
    1234. 

  1234.                                     $answertext=$frow['question'];
    1235. 

  1235.                                     if (strpos($answertext,'|'))
    1236. 

  1236.                                     {
    1237. 

  1237.                                         $answertext=substr($answertext,strpos($answertext,'|')+1);
    1238. 

  1238.                                         $question['ANSWER'] .= "\t\t\t<th class=\"answertextright\">$answertext</th>\n";
    1239. 

  1239.                                     }
    1240. 

  1240.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1241. 

  1241.                                     $a++;
    1242. 

  1242.                                 }
    1243. 

  1243.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1244. 

  1244.                                 break;
    1245. 

  1245. 

  1246.                                 // ==================================================================
    1247. 

  1247.                             case ";": //ARRAY (Multi Flexible) (text)
    1248. 

  1248.                                 $headstyle="style='padding-left: 20px; padding-right: 7px'";
    1249. 

  1249.                                 $mearesult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}' AND scale_id=0 AND language='{$surveyprintlang}' ", array('question_order'));
    1250. 

  1250.                                 $mearesult=$mearesult->readAll();
    1251. 

  1251. 

  1252.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    1253. 

  1253. 

  1254.                                 $question['ANSWER'] .= "\n<table>\n\t<thead>\n\t\t<tr>\n\t\t\t<td>&nbsp;</td>\n";
    1255. 

  1255.                                 $fresult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}'  AND scale_id=1 AND language='{$surveyprintlang}' ", array('question_order'));
    1256. 

  1256.                                 $fresult = $fresult->readAll();
    1257. 

  1257.                                 $fcount = count($fresult);
    1258. 

  1258.                                 $fwidth = "120";
    1259. 

  1259.                                 $i=0;
    1260. 

  1260.                                 //array to temporary store X axis question codes
    1261. 

  1261.                                 $xaxisarray = array();
    1262. 

  1262.                                 foreach ($fresult as $frow)
    1263. 

  1263.                                 {
    1264. 

  1264.                                     $question['ANSWER'] .= "\t\t\t<th>{$frow['question']}</th>\n";
    1265. 

  1265.                                     $i++;
    1266. 

  1266. 

  1267.                                     //add current question code
    1268. 

  1268.                                     $xaxisarray[$i] = $frow['title'];
    1269. 

  1269.                                 }
    1270. 

  1270.                                 $question['ANSWER'] .= "\t\t</tr>\n\t</thead>\n\n<tbody>\n";
    1271. 

  1271.                                 $a=1;
    1272. 

  1272.                                 $rowclass = 'array1';
    1273. 

  1273. 

  1274.                                 foreach ($mearesult as $mearow)
    1275. 

  1275.                                 {
    1276. 

  1276.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n";
    1277. 

  1277.                                     $rowclass = alternation($rowclass,'row');
    1278. 

  1278.                                     $answertext=$mearow['question'];
    1279. 

  1279.                                     if (strpos($answertext,'|')) {$answertext=substr($answertext,0, strpos($answertext,'|'));}
    1280. 

  1280.                                     $question['ANSWER'] .= "\t\t\t<th class=\"answertext\">$answertext</th>\n";
    1281. 

  1281. 

  1282.                                     for ($i=1; $i<=$fcount; $i++)
    1283. 

  1283.                                     {
    1284. 

  1284.                                         $question['ANSWER'] .= "\t\t\t<td>\n";
    1285. 

  1285.                                         $question['ANSWER'] .= "\t\t\t\t".self::_input_type_image('text','',23).self::_addsgqacode(" (".$fieldname.$mearow['title']."_".$xaxisarray[$i].") ")."\n";
    1286. 

  1286.                                         $question['ANSWER'] .= "\t\t\t</td>\n";
    1287. 

  1287.                                     }
    1288. 

  1288.                                     $answertext=$mearow['question'];
    1289. 

  1289.                                     if (strpos($answertext,'|'))
    1290. 

  1290.                                     {
    1291. 

  1291.                                         $answertext=substr($answertext,strpos($answertext,'|')+1);
    1292. 

  1292.                                         $question['ANSWER'] .= "\t\t\t\t<th class=\"answertextright\">$answertext</th>\n";
    1293. 

  1293.                                     }
    1294. 

  1294.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1295. 

  1295.                                     $a++;
    1296. 

  1296.                                 }
    1297. 

  1297.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1298. 

  1298.                                 break;
    1299. 

  1299. 

  1300.                                 // ==================================================================
    1301. 

  1301.                             case "F": //ARRAY (Flexible Labels)
    1302. 

  1302.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose the appropriate response for each item:");
    1303. 

  1303.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    1304. 

  1304. 

  1305.                                 $fresult=Answers::model()->getAllRecords(" scale_id=0 AND qid='{$deqrow['qid']}'  AND language='{$surveyprintlang}'", array('sortorder','code'));
    1306. 

  1306.                                 $fresult = $fresult->readAll(); 
    1307. 

  1307.                                 $fcount = count($fresult);
    1308. 

  1308.                                 $fwidth = "120";
    1309. 

  1309.                                 $i=1;
    1310. 

  1310.                                 $column_headings = array();
    1311. 

  1311.                                 foreach ($fresult as $frow)
    1312. 

  1312.                                 {
    1313. 

  1313.                                     $column_headings[] = $frow['answer'].self::_addsgqacode(" (".$frow['code'].")");
    1314. 

  1314.                                 }
    1315. 

  1315.                                 if (trim($qidattributes['answer_width'])!='')
    1316. 

  1316.                                 {
    1317. 

  1317.                                     $iAnswerWidth=100-$qidattributes['answer_width'];
    1318. 

  1318.                                 }
    1319. 

  1319.                                 else
    1320. 

  1320.                                 {
    1321. 

  1321.                                     $iAnswerWidth=80;
    1322. 

  1322.                                 }
    1323. 

  1323.                                 if (count($column_headings)>0)
    1324. 

  1324.                                 {
    1325. 

  1325.                                     $col_width = round($iAnswerWidth / count($column_headings));
    1326. 

  1326. 

  1327.                                 }
    1328. 

  1328.                                 else
    1329. 

  1329.                                 {
    1330. 

  1330.                                     $heading='';
    1331. 

  1331.                                 }
    1332. 

  1332.                                 $question['ANSWER'] .= "\n<table>\n\t<thead>\n\t\t<tr>\n";
    1333. 

  1333.                                 $question['ANSWER'] .= "\t\t\t<td>&nbsp;</td>\n";
    1334. 

  1334.                                 foreach($column_headings as $heading)
    1335. 

  1335.                                 {
    1336. 

  1336.                                     $question['ANSWER'] .= "\t\t\t<th style=\"width:$col_width%;\">$heading</th>\n";
    1337. 

  1337.                                 }
    1338. 

  1338.                                 $i++;
    1339. 

  1339.                                 $question['ANSWER'] .= "\t\t</tr>\n\t</thead>\n\n\t<tbody>\n";
    1340. 

  1340.                                 $counter = 1;
    1341. 

  1341.                                 $rowclass = 'array1';
    1342. 

  1342. 

  1343.                                 $mearesult=Questions::model()->getAllRecords(" parent_qid='{$deqrow['qid']}'  AND language='{$surveyprintlang}' ", array('question_order'));
    1344. 

  1344.                                 foreach ($mearesult->readAll() as $mearow)
    1345. 

  1345.                                 {
    1346. 

  1346.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n";
    1347. 

  1347.                                     $rowclass = alternation($rowclass,'row');
    1348. 

  1348.                                     if (trim($answertext)=='') $answertext='&nbsp;';
    1349. 

  1349. 

  1350.                                     //semantic differential question type?
    1351. 

  1351.                                     if (strpos($mearow['question'],'|'))
    1352. 

  1352.                                     {
    1353. 

  1353.                                         $answertext = substr($mearow['question'],0, strpos($mearow['question'],'|')).self::_addsgqacode(" (".$fieldname.$mearow['title'].")")." ";
    1354. 

  1354.                                     }
    1355. 

  1355.                                     else
    1356. 

  1356.                                     {
    1357. 

  1357.                                         $answertext=$mearow['question'].self::_addsgqacode(" (".$fieldname.$mearow['title'].")");
    1358. 

  1358.                                     }
    1359. 

  1359. 

  1360.                                     if (trim($qidattributes['answer_width'])!='')
    1361. 

  1361.                                     {
    1362. 

  1362.                                         $sInsertStyle=' style="width:'.$qidattributes['answer_width'].'%" ';
    1363. 

  1363.                                     }
    1364. 

  1364.                                     else
    1365. 

  1365.                                     {
    1366. 

  1366.                                         $sInsertStyle='';
    1367. 

  1367.                                     }
    1368. 

  1368.                                     $question['ANSWER'] .= "\t\t\t<th $sInsertStyle class=\"answertext\">$answertext</th>\n";
    1369. 

  1369. 

  1370.                                     for ($i=1; $i<=$fcount; $i++)
    1371. 

  1371.                                     {
    1372. 

  1372.                                         $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio')."</td>\n";
    1373. 

  1373. 

  1374.                                     }
    1375. 

  1375.                                     $counter++;
    1376. 

  1376. 

  1377.                                     $answertext=$mearow['question'];
    1378. 

  1378. 

  1379.                                     //semantic differential question type?
    1380. 

  1380.                                     if (strpos($mearow['question'],'|'))
    1381. 

  1381.                                     {
    1382. 

  1382.                                         $answertext2=substr($mearow['question'],strpos($mearow['question'],'|')+1);
    1383. 

  1383.                                         $question['ANSWER'] .= "\t\t\t<th class=\"answertextright\">$answertext2</th>\n";
    1384. 

  1384.                                     }
    1385. 

  1385.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1386. 

  1386.                                 }
    1387. 

  1387.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1388. 

  1388.                                 break;
    1389. 

  1389. 

  1390.                                 // ==================================================================
    1391. 

  1391.                             case "1": //ARRAY (Flexible Labels) multi scale
    1392. 

  1392. 

  1393.                                 $leftheader= $qidattributes['dualscale_headerA'][$surveyprintlang];
    1394. 

  1394.                                 $rightheader= $qidattributes['dualscale_headerB'][$surveyprintlang];
    1395. 

  1395. 

  1396.                                 $headstyle = 'style="padding-left: 20px; padding-right: 7px"';
    1397. 

  1397.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose the appropriate response for each item:");
    1398. 

  1398.                                 $question['QUESTION_TYPE_HELP'] .= self::_array_filter_help($qidattributes, $surveyprintlang, $surveyid);
    1399. 

  1399. 

  1400.                                 $question['ANSWER'] .= "\n<table>\n\t<thead>\n";
    1401. 

  1401. 

  1402. 

  1403.                                 $condition = "qid= '{$deqrow['qid']}'  AND language= '{$surveyprintlang}' AND scale_id=0";
    1404. 

  1404.                                 $fresult= Answers::model()->getAllRecords( $condition, array('sortorder', 'code'));
    1405. 

  1405.                                 $fresult = $fresult->readAll();
    1406. 

  1406.                                 $fcount = count($fresult);
    1407. 

  1407. 

  1408.                                 $fwidth = "120";
    1409. 

  1409.                                 $l1=0;
    1410. 

  1410.                                 $printablesurveyoutput2 = "\t\t\t<td>&nbsp;</td>\n";
    1411. 

  1411.                                 $myheader2 = '';
    1412. 

  1412.                                 foreach ($fresult as $frow)
    1413. 

  1413.                                 {
    1414. 

  1414.                                     $printablesurveyoutput2 .="\t\t\t<th>{$frow['answer']}".self::_addsgqacode(" (".$frow['code'].")")."</th>\n";
    1415. 

  1415.                                     $myheader2 .= "<td></td>";
    1416. 

  1416.                                     $l1++;
    1417. 

  1417.                                 }
    1418. 

  1418.                                 // second scale
    1419. 

  1419.                                 $printablesurveyoutput2 .="\t\t\t<td>&nbsp;</td>\n";
    1420. 

  1420.                                 //$fquery1 = "SELECT * FROM {{answers}} WHERE qid='{$deqrow['qid']}'  AND language='{$surveyprintlang}' AND scale_id=1 ORDER BY sortorder, code";
    1421. 

  1421.                                // $fresult1 = Yii::app()->db->createCommand($fquery1)->query();
    1422. 

  1422.                                 $fresult1 = Answers::model()->getAllRecords(" qid='{$deqrow['qid']}'  AND language='{$surveyprintlang}' AND scale_id=1 ", array('sortorder','code'));
    1423. 

  1423.                                 $fresult1 = $fresult1->readAll();
    1424. 

  1424.                                 $fcount1 = count ($fresult1);
    1425. 

  1425.                                 $fwidth = "120";
    1426. 

  1426.                                 $l2=0;
    1427. 

  1427. 

  1428.                                 //array to temporary store second scale question codes
    1429. 

  1429.                                 $scale2array = array();
    1430. 

  1430.                                 foreach ($fresult1 as $frow1)
    1431. 

  1431.                                 {
    1432. 

  1432.                                     $printablesurveyoutput2 .="\t\t\t<th>{$frow1['answer']}".self::_addsgqacode(" (".$frow1['code'].")")."</th>\n";
    1433. 

  1433. 

  1434.                                     //add current question code
    1435. 

  1435.                                     $scale2array[$l2] = $frow1['code'];
    1436. 

  1436. 

  1437.                                     $l2++;
    1438. 

  1438.                                 }
    1439. 

  1439.                                 // build header if needed
    1440. 

  1440.                                 if ($leftheader != '' || $rightheader !='')
    1441. 

  1441.                                 {
    1442. 

  1442.                                     $myheader = "\t\t\t<td>&nbsp;</td>";
    1443. 

  1443.                                     $myheader .= "\t\t\t<th colspan=\"".$l1."\">$leftheader</th>\n";
    1444. 

  1444. 

  1445.                                     if ($rightheader !='')
    1446. 

  1446.                                     {
    1447. 

  1447.                                         // $myheader .= "\t\t\t\t\t" .$myheader2;
    1448. 

  1448.                                         $myheader .= "\t\t\t<td>&nbsp;</td>";
    1449. 

  1449.                                         $myheader .= "\t\t\t<th colspan=\"".$l2."\">$rightheader</td>\n";
    1450. 

  1450.                                     }
    1451. 

  1451. 

  1452.                                     $myheader .= "\t\t\t\t</tr>\n";
    1453. 

  1453.                                 }
    1454. 

  1454.                                 else
    1455. 

  1455.                                 {
    1456. 

  1456.                                     $myheader = '';
    1457. 

  1457.                                 }
    1458. 

  1458.                                 $question['ANSWER'] .= $myheader . "\t\t</tr>\n\n\t\t<tr>\n";
    1459. 

  1459.                                 $question['ANSWER'] .= $printablesurveyoutput2;
    1460. 

  1460.                                 $question['ANSWER'] .= "\t\t</tr>\n\t</thead>\n\n\t<tbody>\n";
    1461. 

  1461. 

  1462.                                 $rowclass = 'array1';
    1463. 

  1463. 

  1464.                                 //counter for each subquestion
    1465. 

  1465.                                 $sqcounter = 0;
    1466. 

  1466.                                 $mearesult=Questions::model()->getAllRecords(" parent_qid={$deqrow['qid']}  AND language='{$surveyprintlang}' ", array('question_order'));
    1467. 

  1467.                                 foreach ($mearesult->readAll() as $mearow)
    1468. 

  1468.                                 {
    1469. 

  1469.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n";
    1470. 

  1470.                                     $rowclass = alternation($rowclass,'row');
    1471. 

  1471.                                     $answertext=$mearow['question'].self::_addsgqacode(" (".$fieldname.$mearow['title']."#0) / (".$fieldname.$mearow['title']."#1)");
    1472. 

  1472.                                     if (strpos($answertext,'|')) {$answertext=substr($answertext,0, strpos($answertext,'|'));}
    1473. 

  1473.                                     $question['ANSWER'] .= "\t\t\t<th class=\"answertext\">$answertext</th>\n";
    1474. 

  1474.                                     for ($i=1; $i<=$fcount; $i++)
    1475. 

  1475.                                     {
    1476. 

  1476.                                         $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio')."</td>\n";
    1477. 

  1477.                                     }
    1478. 

  1478.                                     $question['ANSWER'] .= "\t\t\t<td>&nbsp;</td>\n";
    1479. 

  1479.                                     for ($i=1; $i<=$fcount1; $i++)
    1480. 

  1480.                                     {
    1481. 

  1481.                                         $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio')."</td>\n";
    1482. 

  1482.                                     }
    1483. 

  1483. 

  1484.                                     $answertext=$mearow['question'];
    1485. 

  1485.                                     if (strpos($answertext,'|'))
    1486. 

  1486.                                     {
    1487. 

  1487.                                         $answertext=substr($answertext,strpos($answertext,'|')+1);
    1488. 

  1488.                                         $question['ANSWER'] .= "\t\t\t<th class=\"answertextright\">$answertext</th>\n";
    1489. 

  1489.                                     }
    1490. 

  1490.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1491. 

  1491. 

  1492.                                     //increase subquestion counter
    1493. 

  1493.                                     $sqcounter++;
    1494. 

  1494.                                 }
    1495. 

  1495.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1496. 

  1496.                                 break;
    1497. 

  1497. 

  1498.                                 // ==================================================================
    1499. 

  1499.                             case "H": //ARRAY (Flexible Labels) by Column
    1500. 

  1500.                                 //$headstyle="style='border-left-style: solid; border-left-width: 1px; border-left-color: #AAAAAA'";
    1501. 

  1501.                                 $headstyle="style='padding-left: 20px; padding-right: 7px'";
    1502. 

  1502. 

  1503.                                 $condition = "parent_qid= '{$deqrow['qid']}'  AND language= '{$surveyprintlang}'";
    1504. 

  1504.                                 $fresult= Questions::model()->getAllRecords( $condition, array('question_order', 'title'));
    1505. 

  1505.                                 $fresult = $fresult->readAll();
    1506. 

  1506.                                 $question['QUESTION_TYPE_HELP'] .= $clang->gT("Please choose the appropriate response for each item:");
    1507. 

  1507.                                 $question['ANSWER'] .= "\n<table>\n\t<thead>\n\t\t<tr>\n\t\t\t<td>&nbsp;</td>\n";
    1508. 

  1508. 

  1509.                                 $fcount = count($fresult);
    1510. 

  1510.                                 $fwidth = "120";
    1511. 

  1511.                                 $i=0;
    1512. 

  1512.                                 foreach ($fresult as $frow)
    1513. 

  1513.                                 {
    1514. 

  1514.                                     $question['ANSWER'] .= "\t\t\t<th>{$frow['question']}".self::_addsgqacode(" (".$fieldname.$frow['title'].")")."</th>\n";
    1515. 

  1515.                                     $i++;
    1516. 

  1516.                                 }
    1517. 

  1517.                                 $question['ANSWER'] .= "\t\t</tr>\n\t</thead>\n\n\t<tbody>\n";
    1518. 

  1518.                                 $a=1;
    1519. 

  1519.                                 $rowclass = 'array1';
    1520. 

  1520. 

  1521.                                 $mearesult=Answers::model()->getAllRecords(" qid='{$deqrow['qid']}' AND scale_id=0 AND language='{$surveyprintlang}' ", array('sortorder','code'));
    1522. 

  1522.                                 foreach ($mearesult->readAll() as $mearow)
    1523. 

  1523.                                 {
    1524. 

  1524.                                     //$_POST['type']=$type;
    1525. 

  1525.                                     $question['ANSWER'] .= "\t\t<tr class=\"$rowclass\">\n";
    1526. 

  1526.                                     $rowclass = alternation($rowclass,'row');
    1527. 

  1527.                                     $question['ANSWER'] .= "\t\t\t<th class=\"answertext\">{$mearow['answer']}".self::_addsgqacode(" (".$mearow['code'].")")."</th>\n";
    1528. 

  1528.                                     //$printablesurveyoutput .="\t\t\t\t\t<td>";
    1529. 

  1529.                                     for ($i=1; $i<=$fcount; $i++)
    1530. 

  1530.                                     {
    1531. 

  1531.                                         $question['ANSWER'] .= "\t\t\t<td>".self::_input_type_image('radio')."</td>\n";
    1532. 

  1532.                                     }
    1533. 

  1533.                                     //$printablesurveyoutput .="\t\t\t\t\t</tr></table></td>\n";
    1534. 

  1534.                                     $question['ANSWER'] .= "\t\t</tr>\n";
    1535. 

  1535.                                     $a++;
    1536. 

  1536.                                 }
    1537. 

  1537.                                 $question['ANSWER'] .= "\t</tbody>\n</table>\n";
    1538. 

  1538. 

  1539.                                 break;
    1540. 

  1540.                             case "|":   // File Upload
    1541. 

  1541.                                 $question['QUESTION_TYPE_HELP'] .= "Kindly attach the aforementioned documents along with the survey";
    1542. 

  1542.                                 break;
    1543. 

  1543.                                 // === END SWITCH ===================================================
    1544. 

  1544.                         }
    1545. 

  1545. 

  1546.                         $question['QUESTION_TYPE_HELP'] = self::_star_replace($question['QUESTION_TYPE_HELP']);
    1547. 

  1547.                         $group['QUESTIONS'] .= self::_populate_template( 'question' , $question);
    1548. 

  1548. 

  1549.                     }
    1550. 

  1550.                     if ($bGroupHasVisibleQuestions)
    1551. 

  1551.                     {
    1552. 

  1552.                         $survey_output['GROUPS'] .= self::_populate_template( 'group' , $group );
    1553. 

  1553.                     }
    1554. 

  1554.             }
    1555. 

  1555. 

  1556.             $survey_output['THEREAREXQUESTIONS'] =  str_replace( '{NUMBEROFQUESTIONS}' , $total_questions , $clang->gT('There are {NUMBEROFQUESTIONS} questions in this survey'));
    1557. 

  1557.             
    1558. 

  1558.             // START recursive tag stripping.
    1559. 

  1559.             // PHP 5.1.0 introduced the count parameter for preg_replace() and thus allows this procedure to run with only one regular expression.
    1560. 

  1560.             // Previous version of PHP needs two regular expressions to do the same thing and thus will run a bit slower.
    1561. 

  1561.             $server_is_newer = version_compare(PHP_VERSION , '5.1.0' , '>');
    1562. 

  1562.             $rounds = 0;
    1563. 

  1563.             while($rounds < 1)
    1564. 

  1564.             {
    1565. 

  1565.                 $replace_count = 0;
    1566. 

  1566.                 if($server_is_newer) // Server version of PHP is at least 5.1.0 or newer
    1567. 

  1567.                 {
    1568. 

  1568.                     $survey_output['GROUPS'] = preg_replace(
    1569. 

  1569.                     array(
    1570. 

  1570.                                              '/<td>(?:&nbsp;|&#160;| )?<\/td>/isU'
    1571. 

  1571.                                              ,'/<th[^>]*>(?:&nbsp;|&#160;| )?<\/th>/isU'
    1572. 

  1572.                                              ,'/<([^ >]+)[^>]*>(?:&nbsp;|&#160;|\r\n|\n\r|\n|\r|\t| )*<\/\1>/isU'
    1573. 

  1573.                                              )
    1574. 

  1574.                                              ,array(
    1575. 

  1575.                                              '[[EMPTY-TABLE-CELL]]'
    1576. 

  1576.                                              ,'[[EMPTY-TABLE-CELL-HEADER]]'
    1577. 

  1577.                                              ,''
    1578. 

  1578.                                              )
    1579. 

  1579.                                              ,$survey_output['GROUPS']
    1580. 

  1580.                                              ,-1
    1581. 

  1581.                                              ,$replace_count
    1582. 

  1582.                                              );
    1583. 

  1583.                 }
    1584. 

  1584.                 else // Server version of PHP is older than 5.1.0
    1585. 

  1585.                 {
    1586. 

  1586.                     $survey_output['GROUPS'] = preg_replace(
    1587. 

  1587.                     array(
    1588. 

  1588.                                              '/<td>(?:&nbsp;|&#160;| )?<\/td>/isU'
    1589. 

  1589.                                              ,'/<th[^>]*>(?:&nbsp;|&#160;| )?<\/th>/isU'
    1590. 

  1590.                                              ,'/<([^ >]+)[^>]*>(?:&nbsp;|&#160;|\r\n|\n\r|\n|\r|\t| )*<\/\1>/isU'
    1591. 

  1591.                                              )
    1592. 

  1592.                                              ,array(
    1593. 

  1593.                                              '[[EMPTY-TABLE-CELL]]'
    1594. 

  1594.                                              ,'[[EMPTY-TABLE-CELL-HEADER]]'
    1595. 

  1595.                                              ,''
    1596. 

  1596.                                              )
    1597. 

  1597.                                              ,$survey_output['GROUPS']
    1598. 

  1598.                                              );
    1599. 

  1599.                                              $replace_count = preg_match(
    1600. 

  1600.                                      '/<([^ >]+)[^>]*>(?:&nbsp;|&#160;|\r\n|\n\r|\n|\r|\t| )*<\/\1>/isU'
    1601. 

  1601.                                      , $survey_output['GROUPS']
    1602. 

  1602.                                      );
    1603. 

  1603.                 }
    1604. 

  1604. 

  1605.                 if($replace_count == 0)
    1606. 

  1606.                 {
    1607. 

  1607.                     ++$rounds;
    1608. 

  1608.                     $survey_output['GROUPS'] = preg_replace(
    1609. 

  1609.                     array(
    1610. 

  1610.                                      '/\[\[EMPTY-TABLE-CELL\]\]/'
    1611. 

  1611.                                      ,'/\[\[EMPTY-TABLE-CELL-HEADER\]\]/'
    1612. 

  1612.                                      ,'/\n(?:\t*\n)+/'
    1613. 

  1613.                                      )
    1614. 

  1614.                                      ,array(
    1615. 

  1615.                                      '<td>&nbsp;</td>'
    1616. 

  1616.                                      ,'<th>&nbsp;</th>'
    1617. 

  1617.                                      ,"\n"
    1618. 

  1618.                                      )
    1619. 

  1619.                                      ,$survey_output['GROUPS']
    1620. 

  1620.                                      );
    1621. 

  1621. 

  1622.                 }
    1623. 

  1623.             }
    1624. 

  1624. 

  1625.             $survey_output['GROUPS'] = preg_replace( '/(<div[^>]*>){NOTEMPTY}(<\/div>)/' , '\1&nbsp;\2' , $survey_output['GROUPS']);
    1626. 

  1626. 

  1627.             // END recursive empty tag stripping.
    1628. 

  1628. 

  1629.             echo self::_populate_template( 'survey' , $survey_output );
    1630. 

  1630.             
    1631. 

  1631.         }// End print
    1632. 

  1632.     }
    1633. 

  1633. 

  1634.     /**
    1635. 

  1635.      * A poor mans templating system.
    1636. 

  1636.      *
    1637. 

  1637.      *     $template    template filename (path is privided by config.php)
    1638. 

  1638.      *     $input        a key => value array containg all the stuff to be put into the template
    1639. 

  1639.      *     $line         for debugging purposes only.
    1640. 

  1640.      *
    1641. 

  1641.      * Returns a formatted string containing template with
    1642. 

  1642.      * keywords replaced by variables.
    1643. 

  1643.      *
    1644. 

  1644.      * How:
    1645. 

  1645.      */
    1646. 

  1646.     private function _populate_template( $template , $input  , $line = '')
    1647. 

  1647.     {
    1648. 

  1648.         $full_path = PRINT_TEMPLATE_DIR.'print_'.$template.'.pstpl';
    1649. 

  1649.         $full_constant = 'TEMPLATE'.$template.'.pstpl';
    1650. 

  1650.         if(!defined($full_constant))
    1651. 

  1651.         {
    1652. 

  1652.             if(is_file($full_path))
    1653. 

  1653.             {
    1654. 

  1654.                 define( $full_constant , file_get_contents($full_path));
    1655. 

  1655. 

  1656.                 $template_content = constant($full_constant);
    1657. 

  1657.                 $test_empty = trim($template_content);
    1658. 

  1658.                 if(empty($test_empty))
    1659. 

  1659.                 {
    1660. 

  1660.                     return "<!--\n\t$full_path\n\tThe template was empty so is useless.\n-->";
    1661. 

  1661.                 }
    1662. 

  1662.             }
    1663. 

  1663.             else
    1664. 

  1664.             {
    1665. 

  1665.                 define($full_constant , '');
    1666. 

  1666.                 return "<!--\n\t$full_path is not a propper file or is missing.\n-->";
    1667. 

  1667.             }
    1668. 

  1668.         }
    1669. 

  1669.         else
    1670. 

  1670.         {
    1671. 

  1671.             $template_content = constant($full_constant);
    1672. 

  1672.             $test_empty = trim($template_content);
    1673. 

  1673.             if(empty($test_empty))
    1674. 

  1674.             {
    1675. 

  1675.                 return "<!--\n\t$full_path\n\tThe template was empty so is useless.\n-->";
    1676. 

  1676.             }
    1677. 

  1677.         }
    1678. 

  1678. 

  1679.         if(is_array($input))
    1680. 

  1680.         {
    1681. 

  1681.             foreach($input as $key => $value)
    1682. 

  1682.             {
    1683. 

  1683.                 $find[] = '{'.$key.'}';
    1684. 

  1684.                 $replace[] = $value;
    1685. 

  1685.             }
    1686. 

  1686.             return str_replace( $find , $replace , $template_content );
    1687. 

  1687.         }
    1688. 

  1688.         else
    1689. 

  1689.         {
    1690. 

  1690.             if(Yii::app()->getConfig('debug') > 0)
    1691. 

  1691.             {
    1692. 

  1692.                 if(!empty($line))
    1693. 

  1693.                 {
    1694. 

  1694.                     $line =  'LINE '.$line.': ';
    1695. 

  1695.                 }
    1696. 

  1696.                 return '<!-- '.$line.'There was nothing to put into the template -->'."\n";
    1697. 

  1697.             }
    1698. 

  1698.         }
    1699. 

  1699.     }
    1700. 

  1700. 

  1701.     private function _min_max_answers_help($qidattributes, $surveyprintlang, $surveyid) {
    1702. 

  1702.         $clang = $this->getController()->lang;
    1703. 

  1703.         $output = "";
    1704. 

  1704.         if(!empty($qidattributes['min_answers'])) {
    1705. 

  1705.             $output .= "\n<p class='extrahelp'>".sprintf($clang->gT("Please choose at least %s items."), $qidattributes['min_answers'])."</p>\n";
    1706. 

  1706.         }
    1707. 

  1707.         if(!empty($qidattributes['max_answers'])) {
    1708. 

  1708.             $output .= "\n<p class='extrahelp'>".sprintf($clang->gT("Please choose no more than %s items."),$qidattributes['max_answers'])."</p>\n";
    1709. 

  1709.         }
    1710. 

  1710.         return $output;
    1711. 

  1711.     }
    1712. 

  1712. 

  1713. 

  1714.     private function _input_type_image( $type , $title = '' , $x = 40 , $y = 1 , $line = '' )
    1715. 

  1715.     {
    1716. 

  1716.         if($type == 'other' or $type == 'othercomment')
    1717. 

  1717.         {
    1718. 

  1718.             $x = 1;
    1719. 

  1719.         }
    1720. 

  1720.         $tail = substr($x , -1 , 1);
    1721. 

  1721.         switch($tail)
    1722. 

  1722.         {
    1723. 

  1723.             case '%':
    1724. 

  1724.             case 'm':
    1725. 

  1725.             case 'x':    $x_ = $x;
    1726. 

  1726.             break;
    1727. 

  1727.             default:    $x_ = $x / 2;
    1728. 

  1728.         }
    1729. 

  1729. 

  1730.         if($y < 2)
    1731. 

  1731.         {
    1732. 

  1732.             $y_ = 2;
    1733. 

  1733.         }
    1734. 

  1734.         else
    1735. 

  1735.         {
    1736. 

  1736.             $y_ = $y * 2;
    1737. 

  1737.         }
    1738. 

  1738. 

  1739.         if(!empty($title))
    1740. 

  1740.         {
    1741. 

  1741.             $div_title = ' title="'.htmlspecialchars($title).'"';
    1742. 

  1742.         }
    1743. 

  1743.         else
    1744. 

  1744.         {
    1745. 

  1745.             $div_title = '';
    1746. 

  1746.         }
    1747. 

  1747.         switch($type)
    1748. 

  1748.         {
    1749. 

  1749.             case 'textarea':
    1750. 

  1750.             case 'text':    $style = ' style="width:'.$x_.'em; height:'.$y_.'em;"';
    1751. 

  1751.             break;
    1752. 

  1752.             default:    $style = '';
    1753. 

  1753.         }
    1754. 

  1754. 

  1755.         switch($type)
    1756. 

  1756.         {
    1757. 

  1757.             case 'radio':
    1758. 

  1758.             case 'checkbox':if(!defined('IMAGE_'.$type.'_SIZE'))
    1759. 

  1759.             {
    1760. 

  1760.                 $image_dimensions = getimagesize(PRINT_TEMPLATE_DIR.'print_img_'.$type.'.png');
    1761. 

  1761.                 // define('IMAGE_'.$type.'_SIZE' , ' width="'.$image_dimensions[0].'" height="'.$image_dimensions[1].'"');
    1762. 

  1762.                 define('IMAGE_'.$type.'_SIZE' , ' width="14" height="14"');
    1763. 

  1763.             }
    1764. 

  1764.             $output = '<img src="'.PRINT_TEMPLATE_URL.'print_img_'.$type.'.png"'.constant('IMAGE_'.$type.'_SIZE').' alt="'.htmlspecialchars($title).'" class="input-'.$type.'" />';
    1765. 

  1765.             break;
    1766. 

  1766. 

  1767.             case 'rank':
    1768. 

  1768.             case 'other':
    1769. 

  1769.             case 'othercomment':
    1770. 

  1770.             case 'text':
    1771. 

  1771.             case 'textarea':$output = '<div class="input-'.$type.'"'.$style.$div_title.'>{NOTEMPTY}</div>';
    1772. 

  1772.             break;
    1773. 

  1773. 

  1774.             default:    $output = '';
    1775. 

  1775.         }
    1776. 

  1776.         return $output;
    1777. 

  1777.     }
    1778. 

  1778. 

  1779.     private function _star_replace($input)
    1780. 

  1780.     {
    1781. 

  1781.         return preg_replace(
    1782. 

  1782.                  '/\*(.*)\*/U'
    1783. 

  1783.                  ,'<strong>\1</strong>'
    1784. 

  1784.                  ,$input
    1785. 

  1785.                  );
    1786. 

  1786.     }
    1787. 

  1787. 

  1788.     private function _array_filter_help($qidattributes, $surveyprintlang, $surveyid) 
    1789. 

  1789.     {
    1790. 

  1790.         $clang = $this->getController()->lang;
    1791. 

  1791.         $output = "";
    1792. 

  1792.         if(!empty($qidattributes['array_filter']))
    1793. 

  1793.         {
    1794. 

  1794.             $newquestiontext = Questions::model()->findByAttributes(array('title' => $qidattributes['array_filter'], 'language' => $surveyprintlang, 'sid' => $surveyid))->getAttribute('question');
    1795. 

  1795.             $output .= "\n<p class='extrahelp'>
    1796. 

  1796.                 ".sprintf($clang->gT("Only answer this question for the items you selected in question %s ('%s')"),$qidattributes['array_filter'], flattenText(breakToNewline($newquestiontext['question'])))."
    1797. 

  1797.             </p>\n";
    1798. 

  1798.         }
    1799. 

  1799.         if(!empty($qidattributes['array_filter_exclude']))
    1800. 

  1800.         {
    1801. 

  1801.             $newquestiontext = Questions::model()->findByAttributes(array('title' => $qidattributes['array_filter_exclude'], 'language' => $surveyprintlang, 'sid' => $surveyid))->getAttribute('question');
    1802. 

  1802. 

  1803.             $output .= "\n    <p class='extrahelp'>
    1804. 

  1804.                 ".sprintf($clang->gT("Only answer this question for the items you did not select in question %s ('%s')"),$qidattributes['array_filter_exclude'], breakToNewline($newquestiontext['question']))."
    1805. 

  1805.             </p>\n";
    1806. 

  1806.         }
    1807. 

  1807.         return $output;
    1808. 

  1808.     }
    1809. 

  1809. 

  1810.     /*
    1811. 

  1811.      * $code: Text string containing the reference (column heading) for the current (sub-) question
    1812. 

  1812.      *
    1813. 

  1813.      * Checks if the $showsgqacode setting is enabled at config and adds references to the column headings
    1814. 

  1814.      * to the output so it can be used as a code book for customized SQL queries when analysing data.
    1815. 

  1815.      *
    1816. 

  1816.      * return: adds the text string to the overview
    1817. 

  1817.      */
    1818. 

  1818.     private function _addsgqacode($code)
    1819. 

  1819.     {
    1820. 

  1820.         $showsgqacode = Yii::app()->getConfig('showsgqacode');
    1821. 

  1821.         if(isset($showsgqacode) && $showsgqacode == true)
    1822. 

  1822.         {
    1823. 

  1823.             return $code;
    1824. 

  1824.         }
    1825. 

  1825.     }
    1826. 

  1826. 

  1827. }
    1828. 

  1828.