/data/travel_from_112_124_34_134/travel/framework/db/CDbCommand.php(528)
516 return $result; 517 } 518 catch(Exception $e) 519 { 520 if($this->_connection->enableProfiling) 521 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 522 $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; 523 $message = $e->getMessage(); 524 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 525 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 526 if(YII_DEBUG) 527 $message .= '. The SQL statement executed was: '.$this->getText().$par; 528 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 529 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 530 } 531 } 532 533 /** 534 * Builds a SQL SELECT statement from the given query specification. 535 * @param array $query the query specification in name-value pairs. The following 536 * query options are supported: {@link select}, {@link distinct}, {@link from}, 537 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 538 * {@link limit}, {@link offset} and {@link union}. 539 * @return string the SQL statement 540 * @since 1.1.6
#0 |
+
–
/data/travel_from_112_124_34_134/travel/framework/db/CDbCommand.php(390): CDbCommand->queryInternal("fetchAll", array(2), array()) 385 * An empty array is returned if the query results in nothing. 386 * @throws CException execution failed 387 */ 388 public function queryAll($fetchAssociative=true,$params=array()) 389 { 390 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 391 } 392 393 /** 394 * Executes the SQL statement and returns the first row of the result. 395 * This is a convenient method of {@link query} when only the first row of data is needed. |
#1 |
+
–
/data/travel_from_112_124_34_134/travel/front/protected/modules/user/models/Member.php(106): CDbCommand->queryAll() 101 $sql = 'select ' .$field.' from ' . self::tableName().' where 1=1'; 102 if(!empty ($where)) { 103 $sql .=" and ".$where; 104 } 105 $command = Yii::app()->dbu->createCommand($sql); 106 $rows = $command->queryAll(); 107 return $rows; 108 } 109 110 /** 111 * 通过用户名或邮箱获取用户id |
#2 |
+
–
/data/travel_from_112_124_34_134/travel/front/protected/modules/show/models/activities/Activities_detail.php(243): Member->getRows("id,sex,username,nickname", "id in(,,20051,20053)") 238 foreach($rows as $a_row){ 239 array_push($a_user_id,$a_row['user_id']); 240 } 241 $s_user_id = implode(',', $a_user_id); 242 $joiner_info = $rows; 243 $user_info = Member::model()->getRows('id,sex,username,nickname',"id in($s_user_id)"); 244 for($i=0,$maxi=count($joiner_info); $i<$maxi; $i++){ 245 for($j=0,$maxj=count($user_info); $j<$maxj; $j++){ 246 if($joiner_info[$i]['user_id'] == $user_info[$j]['id']){ 247 if($user_info[$j]['nickname'] != '' && $user_info[$j]['nickname'] != null){ 248 $joiner_info[$i]['nickname'] = $user_info[$j]['nickname']; |
#3 |
+
–
/data/travel_from_112_124_34_134/travel/front/protected/modules/show/models/activities/Activities_detail.php(56): Activities_detail->getOneActivitiesJoinWork("25", "0") 51 52 //得到参加者id 53 $a_activities_basic_info['joiner_info'] = $this->getOneActivitiesJoinerInfo($i_activities_id, 50); 54 55 //得到参加作品 56 $a_activities_basic_info['join_work'] = $this->getOneActivitiesJoinWork($i_activities_id, $a_activities_basic_info['activities_join_type']); 57 58 //得到登录者参加作品 59 $a_activities_basic_info['loginer_work_count'] = $this->getOneActivitiesLoginerWork($i_activities_id, $a_activities_basic_info['activities_join_type']); 60 61 //得到登录者是否已经报名 |
#4 |
+
–
/data/travel_from_112_124_34_134/travel/front/protected/modules/show/controllers/ActivitiesController.php(74): Activities_detail->getOneActivitiesDeatil("25") 69 else{ 70 $this->renderPartial('join_dj_work', array('a_work_list'=>$a_work_list)); 71 } 72 } 73 else{ 74 $a_activities_info = Activities_detail::model()->getOneActivitiesDeatil($_REQUEST['id']); 75 $this->breadcrumbs = array( 76 '动景秀' => array('/show/'), 77 '活动' => array('/show/activities'), 78 $a_activities_info['activities_name'], 79 ); |
#5 |
+
–
/data/travel_from_112_124_34_134/travel/framework/web/actions/CInlineAction.php(50): ActivitiesController->actionActivitiesDetail() 45 $controller=$this->getController(); 46 $method=new ReflectionMethod($controller, $methodName); 47 if($method->getNumberOfParameters()>0) 48 return $this->runWithParamsInternal($controller, $method, $params); 49 else 50 return $controller->$methodName(); 51 } 52 53 } |
#6 |
+
–
/data/travel_from_112_124_34_134/travel/framework/web/CController.php(309): CInlineAction->runWithParams(array("show/activities/activitiesdetail/id/25" => "", "id" => "25")) 304 { 305 $priorAction=$this->_action; 306 $this->_action=$action; 307 if($this->beforeAction($action)) 308 { 309 if($action->runWithParams($this->getActionParams())===false) 310 $this->invalidActionParams($action); 311 else 312 $this->afterAction($action); 313 } 314 $this->_action=$priorAction; |
#7 |
+
–
/data/travel_from_112_124_34_134/travel/framework/web/CController.php(287): CController->runAction(CInlineAction) 282 * @see runAction 283 */ 284 public function runActionWithFilters($action,$filters) 285 { 286 if(empty($filters)) 287 $this->runAction($action); 288 else 289 { 290 $priorAction=$this->_action; 291 $this->_action=$action; 292 CFilterChain::create($this,$action,$filters)->run(); |
#8 |
+
–
/data/travel_from_112_124_34_134/travel/framework/web/CController.php(266): CController->runActionWithFilters(CInlineAction, array()) 261 { 262 if(($parent=$this->getModule())===null) 263 $parent=Yii::app(); 264 if($parent->beforeControllerAction($this,$action)) 265 { 266 $this->runActionWithFilters($action,$this->filters()); 267 $parent->afterControllerAction($this,$action); 268 } 269 } 270 else 271 $this->missingAction($actionID); |
#9 |
+
–
/data/travel_from_112_124_34_134/travel/framework/web/CWebApplication.php(276): CController->run("activitiesdetail") 271 { 272 list($controller,$actionID)=$ca; 273 $oldController=$this->_controller; 274 $this->_controller=$controller; 275 $controller->init(); 276 $controller->run($actionID); 277 $this->_controller=$oldController; 278 } 279 else 280 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 281 array('{route}'=>$route===''?$this->defaultController:$route))); |
#10 |
+
–
/data/travel_from_112_124_34_134/travel/framework/web/CWebApplication.php(135): CWebApplication->runController("show/activities/activitiesdetail/id/25") 130 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 131 $_GET[$name]=$value; 132 } 133 else 134 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 135 $this->runController($route); 136 } 137 138 /** 139 * Registers the core application components. 140 * This method overrides the parent implementation by registering additional core components. |
#11 |
+
–
/data/travel_from_112_124_34_134/travel/framework/base/CApplication.php(162): CWebApplication->processRequest() 157 */ 158 public function run() 159 { 160 if($this->hasEventHandler('onBeginRequest')) 161 $this->onBeginRequest(new CEvent($this)); 162 $this->processRequest(); 163 if($this->hasEventHandler('onEndRequest')) 164 $this->onEndRequest(new CEvent($this)); 165 } 166 167 /** |
#12 |
+
–
/data/travel_from_112_124_34_134/travel/front/index.php(36): CApplication->run() 31 32 require_once($yii); 33 //全局函数 34 require_once($globals); 35 36 Yii::createWebApplication($config)->run(); |