/var/www/html/sg_survey-test/framework/db/CDbCommand.php(543)
531 { 532 if($this->_connection->enableProfiling) 533 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 534 535 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 536 $message=$e->getMessage(); 537 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 538 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 539 540 if(YII_DEBUG) 541 $message.='. The SQL statement executed was: '.$this->getText().$par; 542 543 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 544 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 545 } 546 } 547 548 /** 549 * Builds a SQL SELECT statement from the given query specification. 550 * @param array $query the query specification in name-value pairs. The following 551 * query options are supported: {@link select}, {@link distinct}, {@link from}, 552 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 553 * {@link limit}, {@link offset} and {@link union}. 554 * @throws CDbException if "from" key is not present in given query parameter 555 * @return string the SQL statement
#0 |
+
–
/var/www/html/sg_survey-test/framework/db/CDbCommand.php(396): CDbCommand->queryInternal("fetchAll", array(2), array()) 391 * An empty array is returned if the query results in nothing. 392 * @throws CException execution failed 393 */ 394 public function queryAll($fetchAssociative=true,$params=array()) 395 { 396 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 397 } 398 399 /** 400 * Executes the SQL statement and returns the first row of the result. 401 * This is a convenient method of {@link query} when only the first row of data is needed. |
#1 |
+
–
/var/www/html/sg_survey-test/framework/db/ar/CActiveFinder.php(810): CDbCommand->queryAll() 805 * @param CJoinQuery $query the query to be executed. 806 */ 807 public function runQuery($query) 808 { 809 $command=$query->createCommand($this->_builder); 810 foreach($command->queryAll() as $row) 811 $this->populateRecord($query,$row); 812 } 813 814 /** 815 * Populates the active records with the query data. |
#2 |
+
–
/var/www/html/sg_survey-test/framework/db/ar/CActiveFinder.php(441): CJoinElement->runQuery(CJoinQuery) 436 { 437 $query=new CJoinQuery($this,$criteria); 438 $this->_finder->baseLimited=($criteria->offset>=0 || $criteria->limit>=0); 439 $this->buildQuery($query); 440 $this->_finder->baseLimited=false; 441 $this->runQuery($query); 442 } 443 elseif(!$this->_joined && !empty($this->_parent->records)) // not joined before 444 { 445 $query=new CJoinQuery($this->_parent); 446 $this->_joined=true; |
#3 |
+
–
/var/www/html/sg_survey-test/framework/db/ar/CActiveFinder.php(68): CJoinElement->find(CDbCriteria) 63 { 64 $this->_joinTree->tableAlias=$criteria->alias; 65 $this->_joinTree->rawTableAlias=$this->_builder->getSchema()->quoteTableName($criteria->alias); 66 } 67 68 $this->_joinTree->find($criteria); 69 $this->_joinTree->afterFind(); 70 71 if($all) 72 { 73 $result = array_values($this->_joinTree->records); |
#4 |
+
–
/var/www/html/sg_survey-test/framework/db/ar/CActiveRecord.php(1364): CActiveFinder->query(CDbCriteria, true) 1359 return $all ? $this->populateRecords($command->queryAll(), true, $criteria->index) : $this->populateRecord($command->queryRow()); 1360 } 1361 else 1362 { 1363 $finder=$this->getActiveFinder($criteria->with); 1364 return $finder->query($criteria,$all); 1365 } 1366 } 1367 1368 /** 1369 * Applies the query scopes to the given criteria. |
#5 |
+
–
/var/www/html/sg_survey-test/application/models/LSActiveRecord.php(74): CActiveRecord->query(CDbCriteria, true) 69 * @since 1.1.7 70 */ 71 protected function query($criteria, $all = false, $asAR = true) 72 { 73 if ($asAR === true) { 74 return parent::query($criteria, $all); 75 } else { 76 $this->beforeFind(); 77 $this->applyScopes($criteria); 78 if (!$all) { 79 $criteria->limit = 1; |
#6 |
+
–
/var/www/html/sg_survey-test/framework/db/ar/CActiveRecord.php(1478): LSActiveRecord->query(CDbCriteria, true) 1473 */ 1474 public function findAll($condition='',$params=array()) 1475 { 1476 Yii::trace(get_class($this).'.findAll()','system.db.ar.CActiveRecord'); 1477 $criteria=$this->getCommandBuilder()->createCriteria($condition,$params); 1478 return $this->query($criteria,true); 1479 } 1480 1481 /** 1482 * Finds a single active record with the specified primary key. 1483 * See {@link find()} for detailed explanation about $condition and $params. |
#7 |
+
–
/var/www/html/sg_survey-test/application/helpers/admin/export/SurveyDao.php(46): CActiveRecord->findAll(array("condition"
=> "question.sid=534913 AND answerL10ns.language = 'en'", "order"
=> "question.question_order, t.scale_id, sortorder")) 41 safeDie("An invalid survey ID was encountered"); 42 } 43 44 $survey->groups = QuestionGroup::model()->findAll(array("condition" => 'sid='.$intId, 'order'=>'group_order')); 45 $survey->questions = Question::model()->findAll(array("condition" => 'sid='.$intId, 'order'=>'question_order')); 46 $aAnswers = Answer::model()->with('answerL10ns', 'question')->findAll(array('condition'=>'question.sid='.$intId.' AND answerL10ns.language = \''.$lang.'\'', 'order' => 'question.question_order, t.scale_id, sortorder')); 47 foreach ($aAnswers as $aAnswer) { 48 if(!empty($oOptions->stripHtmlCode) && $oOptions->stripHtmlCode == 1 && Yii::app()->controller->action->id !='remotecontrol'){ 49 $answer=stripTagsFull($aAnswer->answerL10ns[$lang]->answer); 50 } else { 51 $answer=$aAnswer->answerL10ns[$lang]->answer; |
#8 |
+
–
/var/www/html/sg_survey-test/application/helpers/admin/exportresults_helper.php(102): SurveyDao->loadSurveyById("534913", "en", FormattingOptions) 097 if (!($writer instanceof IWriter)) { 098 throw new Exception(sprintf('Writer for %s should implement IWriter', $sExportPlugin)); 099 } 100 101 $surveyDao = new SurveyDao(); 102 $survey = $surveyDao->loadSurveyById($iSurveyId, $sLanguageCode, $oOptions); 103 $writer->init($survey, $sLanguageCode, $oOptions); 104 105 $surveyDao->loadSurveyResults($survey, $oOptions->responseMinRecord, $oOptions->responseMaxRecord, $sFilter, $oOptions->responseCompletionState, $oOptions->selectedColumns, $oOptions->aResponses); 106 $writer->write($survey, $sLanguageCode, $oOptions, true); 107 $result = $writer->close(); |
#9 |
+
–
/var/www/html/sg_survey-test/application/controllers/admin/export.php(337): ExportSurveyResultsService->exportResponses("534913", "en", "csv", FormattingOptions, ...) 332 } else { 333 $sFilter = ''; 334 } 335 336 viewHelper::disableHtmlLogging(); 337 $resultsService->exportResponses($iSurveyID, $explang, $sExportType, $options, $sFilter); 338 339 Yii::app()->end(); 340 } 341 342 /* |
#10 |
unknown(0): export->exportresults()
|
#11 |
+
–
/var/www/html/sg_survey-test/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(export, array()) 104 elseif($param->isDefaultValueAvailable()) 105 $ps[]=$param->getDefaultValue(); 106 else 107 return false; 108 } 109 $method->invokeArgs($object,$ps); 110 return true; 111 } 112 } |
#12 |
+
–
/var/www/html/sg_survey-test/application/core/Survey_Common_Action.php(86): CAction->runWithParamsInternal(export,
ReflectionMethod, array("r" =>
"admin/export/sa/exportresults/surveyid/534913", "sa" =>
"exportresults", "surveyid" => 534913, "iSurveyId" => 534913,
...)) 81 $oMethod = new ReflectionMethod($this, $sDefault); 82 } 83 84 // We're all good to go, let's execute it 85 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params 86 return parent::runWithParamsInternal($this, $oMethod, $params); 87 } 88 89 /** 90 * Some functions have different parameters, which are just an alias of the 91 * usual parameters we're getting in the url. This function just populates |
#13 |
+
–
/var/www/html/sg_survey-test/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("r"
=> "admin/export/sa/exportresults/surveyid/534913", "sa" =>
"exportresults", "surveyid" => 534913, "iSurveyId" => 534913,
...)) 303 { 304 $priorAction=$this->_action; 305 $this->_action=$action; 306 if($this->beforeAction($action)) 307 { 308 if($action->runWithParams($this->getActionParams())===false) 309 $this->invalidActionParams($action); 310 else 311 $this->afterAction($action); 312 } 313 $this->_action=$priorAction; |
#14 |
+
–
/var/www/html/sg_survey-test/framework/web/CController.php(286): CController->runAction(export) 281 * @see runAction 282 */ 283 public function runActionWithFilters($action,$filters) 284 { 285 if(empty($filters)) 286 $this->runAction($action); 287 else 288 { 289 $priorAction=$this->_action; 290 $this->_action=$action; 291 CFilterChain::create($this,$action,$filters)->run(); |
#15 |
+
–
/var/www/html/sg_survey-test/framework/web/CController.php(265): CController->runActionWithFilters(export, array()) 260 { 261 if(($parent=$this->getModule())===null) 262 $parent=Yii::app(); 263 if($parent->beforeControllerAction($this,$action)) 264 { 265 $this->runActionWithFilters($action,$this->filters()); 266 $parent->afterControllerAction($this,$action); 267 } 268 } 269 else 270 $this->missingAction($actionID); |
#16 |
+
–
/var/www/html/sg_survey-test/application/controllers/AdminController.php(165): CController->run("export") 160 } 161 162 $this->runModuleController($action); 163 164 165 return parent::run($action); 166 } 167 168 /** 169 * Starting with LS4, 3rd party developper can extends any of the LimeSurve controllers. 170 */ |
#17 |
+
–
/var/www/html/sg_survey-test/framework/web/CWebApplication.php(282): AdminController->run("export") 277 { 278 list($controller,$actionID)=$ca; 279 $oldController=$this->_controller; 280 $this->_controller=$controller; 281 $controller->init(); 282 $controller->run($actionID); 283 $this->_controller=$oldController; 284 } 285 else 286 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 287 array('{route}'=>$route===''?$this->defaultController:$route))); |
#18 |
+
–
/var/www/html/sg_survey-test/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/export/sa/exportresults/surveyid/534913") 136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 137 $_GET[$name]=$value; 138 } 139 else 140 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 141 $this->runController($route); 142 } 143 144 /** 145 * Registers the core application components. 146 * This method overrides the parent implementation by registering additional core components. |
#19 |
+
–
/var/www/html/sg_survey-test/framework/base/CApplication.php(185): CWebApplication->processRequest() 180 public function run() 181 { 182 if($this->hasEventHandler('onBeginRequest')) 183 $this->onBeginRequest(new CEvent($this)); 184 register_shutdown_function(array($this,'end'),0,false); 185 $this->processRequest(); 186 if($this->hasEventHandler('onEndRequest')) 187 $this->onEndRequest(new CEvent($this)); 188 } 189 190 /** |
#20 |
+
–
/var/www/html/sg_survey-test/index.php(195): CApplication->run() 190 require_once APPPATH . 'core/LSYii_Application' . EXT; 191 192 $config = require_once(APPPATH . 'config/internal' . EXT); 193 194 Yii::$enableIncludePath = false; 195 Yii::createApplication('LSYii_Application', $config)->run(); 196 197 /* End of file index.php */ 198 /* Location: ./index.php */ |