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;
}
