echo $form->labelEx($model, 'type'); ?> <?php echo CHtml::dropDownList('QuestionResource[type]', $model->type, $model->GetResourceType()); ?> <?php echo $form->error($model, 'type'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'language_id'); ?> <?php $data = QuestionResource::model()->GetLanguageIdList(); echo CHtml::activeDropDownList($model, 'language_id', CHtml::listData($data, 'id', 'name'), array('empty' => Yii::t('app', 'choose'))); ?> <?php echo $form->error($model, 'language_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'data'); ?> <?php echo $form->fileField($model, 'uploadedData'); ?> <?php
public function FillQuestionResource($QuestionModel, $fileData, $fileName, $path, $file_type, $type, $start_up, $language_code, &$CurrentResources) { $language = Language::model()->find("short=:short", array(':short' => $language_code)); if ($language == null) { throw new CHttpException(405, Yii::t('app', 'Language code is not exists')); } $questionResource = QuestionResource::model()->find('question_id=:question_id and language_id=:language_id and path=:path and filename=:filename', array(':question_id' => $QuestionModel->id, ':language_id' => $language->id, ':path' => $path, ':filename' => $fileName)); if ($questionResource == null) { $questionResource = new QuestionResource(); $questionResource->question_id = $QuestionModel->id; $questionResource->language_id = $language->id; $questionResource->filename = $fileName; $questionResource->path = $path; } $questionResource->data = $fileData; $questionResource->file_type = $file_type; $questionResource->type = $type; $questionResource->start_up = $start_up; if ($questionResource->save()) { //Saved OK $CurrentResources[$questionResource->id] = true; } else { throw new CHttpException(405, Yii::t('app', 'Save question resource failed')); } }
public function actionGetQuestions() { $session = Yii::app()->session; $competition_user_id = $session['competition_user_id'] ? $session['competition_user_id'] : 0; if ($competition_user_id == 0) { self::reponseJSON(array('success' => false, 'error' => Yii::t('app', 'User is not authenticated.'))); } $competitionUser = CompetitionUser::model()->findByPk($competition_user_id); if ($competitionUser != null) { // we need to get that info somewhere /* $GetLanguageIds = QuestionResource::model()->with('question')->with('question.competitionQuestions')->findAll(array( 'select' => 't.language_id', 'distinct' => true, 'condition' => 'competitionQuestions.competition_id=:competition_id', 'params' => array(':competition_id' => $competitionUser->competition_id) )); $language_id = 1; if ($GetLanguageIds != null) { foreach ($GetLanguageIds as $record) { $language_id = $record->language_id; // echo 'Found Language ID: ', $record->language_id, '<br />'; // die(); break; } } $language = Language::model()->findByPk($language_id); if ($language == null) { die('Language invalid'); } $language_code = $language->short;*/ // how about the session? if ($competitionUser->finished == 1 || $competitionUser->finish_time != null) { self::reponseJSON(array('success' => false, 'errorCode' => 999, 'error' => Yii::t('app', 'You have already finished competition.'))); } if ($competitionUser->start_time != null) { $duration = $competitionUser->competition->duration * 60; $starttime = strtotime($competitionUser->start_time); $endtime = $starttime + $duration; if ($endtime < time()) { $competitionUser->finished = 1; $competitionUser->finish_time = $endtime; $competitionUser->save(true, array('finished', 'finish_time')); self::reponseJSON(array('success' => false, 'errorCode' => 999, 'error' => Yii::t('app', 'Your time is up. Questions won\'t be loaded!'))); } } /* $count = CompetitionUserQuestion::model()->count('competition_user_id=:competition_user_id', array(':competition_user_id' => $competition_user_id));*/ $language_code = $session['preferred_language']; // error_log("Lang:".$language_code); $language = Language::model()->findByAttributes(array('short' => $language_code)); $language_id = $language->id; if (!$competitionUser->questions_prepared) { $connection = Yii::app()->db; $transaction = $connection->beginTransaction(); try { // error_log("Language code:".$language_code."id:".$language_id); // echo 'Adding new Competiton User Questions'; // generate questions order for user $criteria = new CDbCriteria(); $criteria->together = true; $criteria->with = array('competitionQuestionCategories'); $criteria->condition = 't.competition_id=:competition_id and competitionQuestionCategories.competition_category_id=:competition_category_id'; $criteria->params = array(':competition_id' => $competitionUser->competition_id, ':competition_category_id' => $competitionUser->competition_category_id); $criteria->order = 'RAND()'; $competitionQuestions = CompetitionQuestion::model()->findAll($criteria); $order = 1; foreach ($competitionQuestions as $competitionQuestion) { $competitionUserQuestion = new CompetitionUserQuestion(); $competitionUserQuestion->competition_question_id = $competitionQuestion->id; $competitionUserQuestion->competition_user_id = $competition_user_id; $competitionUserQuestion->ordering = $order; $random_seed = number_format(mt_rand(0, mt_getrandmax() - 1) / mt_getrandmax(), 9, '.', ''); $competitionUserQuestion->random_seed = $random_seed; if (!$competitionUserQuestion->save()) { var_dump($competitionUserQuestion->getErrors()); die; } $order++; } $competitionUser->questions_prepared = 1; $competitionUser->save(true, array('questions_prepared')); $transaction->commit(); } catch (Exception $e) { error_log($e); $transaction->rollback(); } } // $count = CompetitionUserQuestion::model()->count('competition_user_id=:competition_user_id', array(':competition_user_id' => $competition_user_id)); $competitionUserQuestions = CompetitionUserQuestion::model()->findAll(array('condition' => 'competition_user_id=:competition_user_id', 'params' => array(':competition_user_id' => $competition_user_id), 'order' => 'ordering ASC')); if ($competitionUserQuestions != null) { $questions = array(); foreach ($competitionUserQuestions as $competitionUserQuestion) { $question_id = $competitionUserQuestion->competitionQuestion->question_id; $startup_file = QuestionResource::model()->find('question_id=:question_id and language_id=:language_id and type=:type and start_up=:start_up', array(':question_id' => $question_id, ':language_id' => $language_id, ':type' => 1, ':start_up' => 1)); if ($startup_file != null) { $questions[] = array('id' => $question_id, 'title' => $competitionUserQuestion->competitionQuestion->question->title, 'country' => $competitionUserQuestion->competitionQuestion->question->country_of_origin, 'link' => $question_id . '/' . $language_code . '/' . $startup_file->path . $startup_file->filename, 'custom_answer' => $competitionUserQuestion->custom_answer == null ? '' : $competitionUserQuestion->custom_answer, 'random_seed' => $competitionUserQuestion->random_seed, 'css' => $competitionUserQuestion->competitionQuestion->question->css); } else { echo "Question: ", $question_id, "\n"; die('missing startup file for language id: ' . $language_id . ' question id: ' . $question_id); } } $response = array('success' => true, 'questions' => $questions, 'competition_title' => $competitionUser->competition->name, 'competition_length' => $competitionUser->competition->duration, 'seconds_to_end' => $competitionUser->start_time == null ? -1 : $competitionUser->competition->duration * 60 - time() - strtotime($competitionUser->start_time)); self::reponseJSON($response); } else { self::reponseJSON(array('success' => false, 'error' => Yii::t('app', 'No questions defined for user.'))); } } else { self::reponseJSON(array('success' => false, 'error' => Yii::t('app', 'User is not authenticated.'))); } }
?> <?php $data = CompetitionQuestion::model()->GetCompetitionNameIdList(); echo CHtml::activeDropDownList($model, 'competition_id', CHtml::listData($data, 'id', 'name'), array('empty' => Yii::t('app', 'choose'))); ?> <?php echo $form->error($model, 'competition_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'question_id'); ?> <?php $data = QuestionResource::model()->GetQuestionTitleIdList(); echo CHtml::activeDropDownList($model, 'question_id', CHtml::listData($data, 'id', 'title'), array('empty' => Yii::t('app', 'choose'))); ?> <?php echo $form->error($model, 'question_id'); ?> </div> <div class="row buttons"> <br /><?php $this->widget('zii.widgets.jui.CJuiButton', array('name' => 'button', 'caption' => $model->isNewRecord ? Yii::t('app', 'create') : Yii::t('app', 'save'), 'value' => $model->isNewRecord ? Yii::t('app', 'create') : Yii::t('app', 'save'))); ?> </div> <?php
public function actionAdminGet() { // adminget/<id>/show $starttime = microtime(true); $questionResourceArray = array(); if ($this->CanAccess('adminget')) { $keys = array_keys($_GET); if (count($keys) == 0) { die; } $question_resource_id = $keys[0]; $questionResource = QuestionResource::model()->findByPk($question_resource_id); if ($questionResource == null) { $questionResource = new QuestionResource(); die; } $questionResourceArray = array('data' => $questionResource->data, 'file_type' => $questionResource->file_type, 'length' => strlen($questionResource->data)); } if (isset($questionResourceArray['length'])) { header('Pragma: public'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Content-Transfer-Encoding: binary'); header('Content-length: ' . $questionResourceArray['length']); header('Content-Type: ' . $questionResourceArray['file_type']); header('X-Content-Type-Options: nosniff'); header('X-Frame-Options: SAMEORIGIN'); header('Connection: close'); echo $questionResourceArray['data']; } die; }