public static function getQuestions($blockId)
{
$criteria = new CDbCriteria();
$relationTableName = QuestionsBlockQuestion::model()->tableName();
$criteria->addCondition("id NOT IN (SELECT DISTINCT questionId FROM {$relationTableName} WHERE questionBlockId = :blockId)");
$criteria->params = array(':blockId' => $blockId);
return CHtml::listData(SurveyPurposeQuestion::model()->findAll($criteria), 'id', 'title');
}
public function actionDeleteQuestion($id, $questionId)
{
$relation = QuestionsBlockQuestion::model()->findByAttributes(array('questionId' => $questionId, 'questionBlockId' => $id));
if ($relation) {
$relation->delete();
}
$this->redirect(array('view', 'id' => $id));
}
protected function afterDelete()
{
QuestionsBlockQuestion::model()->deleteAllByAttributes(array('questionId' => $this->idCache));
parent::afterDelete();
}