public function getQuiz()
{
$criteria = new CDbCriteria();
$criteria->join = "left join ew_lesson l on l.mediaId=t.id";
$criteria->condition = "l.mediaType='quiz' and l.id=" . intval($this->id);
$quiz = Quiz::model()->find($criteria);
return $quiz;
}
public function getNewestQuizzesInCategory($category)
{
$criteria = new CDbCriteria();
$criteria->condition = "category = '" . $category . "'";
$criteria->order = 'created_at DESC';
$data = Quiz::model()->findAll($criteria);
return $data;
}
public function actionDeleteRatingQuiz()
{
$request = Yii::app()->request;
try {
$id = StringHelper::filterString($request->getPost('id'));
if (Quiz::model()->delelteRatingQuiz($id)) {
ResponseHelper::JsonReturnSuccess('');
} else {
ResponseHelper::JsonReturnError('');
}
} catch (Exception $ex) {
ResponseHelper::JsonReturnError($ex->getMessage());
}
}
protected function loadModel($id)
{
/**
* TODO или сделать в один запрос?
*/
$criteria = new CDbCriteria();
$criteria->compare('t.active', Quiz::STATUS_ACTIVE);
/** @var $quiz Quiz */
$quiz = Quiz::model()->findByPk($id, $criteria);
if ($quiz === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
$criteria = new CDbCriteria(array('with' => 'answers', 'order' => 't.sequence ASC, answers.sequence ASC'));
$criteria->compare('t.id_quiz', $id);
$questions = QuizQuestion::model()->findAll($criteria);
if (empty($questions)) {
throw new CHttpException(404, 'The requested page does not exist.');
}
$quiz->addRelatedRecord('questions', $questions, false);
return $quiz;
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Quiz::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function actionGetCategories()
{
$data = Quiz::model()->getCategories();
ResponseHelper::JsonReturnSuccess($data);
}
