public function actionSearch()
{
Yii::beginProfile('search_jukebox');
$questions = null;
$data = null;
$jukeboxCount = '';
$session = new CHttpSession();
$session->open();
$modelJukeboxQuestions = new JukeboxQuestions();
//$questions = JukeboxQuestionsApi::searchQuestion($data);
if (isset($_POST['JukeboxMin']) && isset($_POST['JukeboxQuestions'])) {
$modelJukeboxQuestions->attributes = $_POST['JukeboxQuestions'];
$data['keyword'] = $_POST['keyword'];
$criteria = JukeboxQuestionsApi::getCriteriaObject($data);
$total = JukeboxQuestions::model()->count($criteria);
$pages = new CPagination($total);
$pages->pageSize = Yii::app()->params['resultsPerPage'];
$pages->applyLimit($criteria);
$questions = JukeboxQuestionsApi::searchJukeboxWithCriteria($criteria);
$jukeboxCount = $total;
$session['search-criteria-jukebox'] = $criteria;
$session['results-page'] = $total;
} elseif (isset($_POST['submit']) && isset($_POST['JukeboxQuestions'])) {
$modelJukeboxQuestions->attributes = $_POST['JukeboxQuestions'];
$data = $_POST['JukeboxQuestions'];
$data['keyword'] = $_POST['keyword'];
$data['time'] = $_POST['time'];
$criteria = JukeboxQuestionsApi::getCriteriaObject($data);
$total = JukeboxQuestions::model()->count($criteria);
$pages = new CPagination($total);
$pages->pageSize = Yii::app()->params['resultsPerPage'];
$pages->applyLimit($criteria);
$questions = JukeboxQuestionsApi::searchJukeboxWithCriteria($criteria);
$jukeboxCount = $total;
$session['search-criteria-jukebox'] = $criteria;
$session['results-page'] = $total;
} else {
if (isset($session['search-criteria-jukebox'])) {
$criteria = $session['search-criteria-jukebox'];
//$criteria = new CDbCriteria;
} else {
$criteria = JukeboxQuestionsApi::getCriteriaObject($data);
}
$total = JukeboxQuestions::model()->count($criteria);
$pages = new CPagination($total);
$pages->pageSize = Yii::app()->params['resultsPerPage'];
$pages->applyLimit($criteria);
$questions = JukeboxQuestionsApi::searchJukeboxWithCriteria($criteria);
$jukeboxCount = $total;
}
$this->render('search', array('modelJukeboxQuestions' => $modelJukeboxQuestions, 'questions' => $questions, 'pages' => $pages, 'jukeboxCount' => $jukeboxCount));
Yii::endProfile('search_jukebox');
}
echo $form->labelEx($model, 'user_id');
?>
<?php
echo $form->dropDownList($model, 'user_id', UserApi::getUserList(), array('empty' => 'Select'));
?>
<?php
echo $form->error($model, 'user_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'question_id');
?>
<?php
echo $form->dropDownList($model, 'question_id', CHtml::listData(JukeboxQuestions::model()->findAll(), 'id', 'question'), array('empty' => 'Select'));
?>
<?php
echo $form->error($model, 'question_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'rate');
?>
<?php
echo $form->textField($model, 'rate');
?>
<?php
echo $form->error($model, 'rate');
public static function getAllJukeboxQuestionsOfUser($userId, $count = '')
{
$criteria = new CDbCriteria();
$criteria->condition = 'user_id=:userId';
$criteria->params = array(':userId' => $userId);
if ($count) {
$criteria->limit = $count;
}
$jukeboxQuestions = JukeboxQuestions::model()->findAll($criteria);
if ($jukeboxQuestions) {
return $jukeboxQuestions;
} else {
return false;
}
}
/**
* 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 = JukeboxQuestions::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
