public function actionRank() { //$rank = GameEventReportDayModel::model()->getRank(10); $rank = array(); $thread = GameEventThreadModel::model()->findAll(); if ($thread) { foreach ($thread as $value) { $sql = "SELECT thread_id,point, user_phone,id,SEC_TO_TIME(TIME_TO_SEC(time(time_end))-TIME_TO_SEC(time(time_start))) as time_play\n\t\t\t\t\t\tFROM game_event_report_day\n\t\t\t\t\t\twhere thread_id=:thread_id\n\t\t\t\t\t\tORDER BY point DESC,time_play ASC\n\t\t\t\t\t\tlimit 1"; $command = Yii::app()->db->createCommand($sql); $command->bindParam(':thread_id', $value->id, PDO::PARAM_INT); $rank[] = $command->queryRow(); } } $rankSort = array(); foreach ($rank as $value) { if ($value) { $rankSort[$value['point']] = $value; } } krsort($rankSort); $this->render('rank', array('rank' => $rankSort)); }
public function actionDeleteQuestion() { $threadId = Yii::app()->request->getParam('thread_id', null); $questionId = Yii::app()->request->getParam('question_id', null); $questionId = (int) $questionId; if ($threadId && $questionId) { $model = GameEventThreadModel::model()->findByPk($threadId); $oldQuestionList = explode(',', $model['question_list']); $newQuestionList = ''; foreach ($oldQuestionList as $question) { $newQuestionList .= $questionId == (int) $question ? '' : ',' . trim($question); } $newQuestionList = $newQuestionList != '' ? substr($newQuestionList, 1) : ''; $model->question_list = $newQuestionList; $model->save(); $this->redirect(Yii::app()->createUrl("event/gameEventQuestion/view", array("id" => $threadId))); } /* if(Yii::app()->request->isPostRequest) { // we only allow deletion via POST request $this->loadModel($id)->delete(); // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser if(!isset($_GET['ajax'])) $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('index')); } else throw new CHttpException(400,'Invalid request. Please do not repeat this request again.'); */ }
public function actionAddQuestion() { $flag = true; $threadId = Yii::app()->request->getParam('thread_id', ""); if (Yii::app()->getRequest()->ispostRequest) { $flag = false; $questionList = $_POST['cid']; $model = GameEventThreadModel::model()->findByPk($threadId); $oldQuestionList = explode(',', $model['question_list']); $newQuestionList = $model['question_list'] ? ',' . $model['question_list'] : ''; foreach ($questionList as $question) { $newQuestionList .= in_array($question, $oldQuestionList) ? '' : ',' . $question; } $newQuestionList = $newQuestionList != '' ? substr($newQuestionList, 1) : ''; $model->question_list = $newQuestionList; $model->save(); //AdminCollectionItemModel::model()->addList($this->userId, $collect_id, $albumList, 'album'); } if ($flag) { Yii::app()->user->setState('pageSize', 20); $questionModel = new GameEventQuestionModel(); $questionModel->unsetAttributes(); if (isset($_GET['GameEventQuestionModel'])) { $questionModel->attributes = $_GET['GameEventQuestionModel']; } $questionModel->setAttributes(array('status' => GameEventQuestionModel::PUBLISHED)); Yii::app()->clientScript->scriptMap['jquery.js'] = false; $this->renderPartial('addQuestion', array('questionModel' => $questionModel, 'thread_id' => $threadId), false, true); } }