public function setQuestionAttribute($iQuestionID, $sAttributeName, $sValue)
 {
     $oModel = new self();
     $aResult = $oModel->findAll('attribute=:attributeName and qid=:questionID', array(':attributeName' => $sAttributeName, ':questionID' => $iQuestionID));
     if (!empty($aResult)) {
         $oModel->updateAll(array('value' => $sValue), 'attribute=:attributeName and qid=:questionID', array(':attributeName' => $sAttributeName, ':questionID' => $iQuestionID));
     } else {
         $oModel = new self();
         $oModel->attribute = $sAttributeName;
         $oModel->value = $sValue;
         $oModel->qid = $iQuestionID;
         $oModel->save();
     }
     return Yii::app()->db->createCommand()->select()->from($this->tableName())->where(array('and', 'qid=:qid'))->bindParam(":qid", $qid)->order('qaid asc')->query();
 }
Example #2
0
 public function insertRecords($data, $update = FALSE, $condition = FALSE)
 {
     $record = new self();
     foreach ($data as $k => $v) {
         $v = str_replace(array("'", '"'), '', $v);
         $record->{$k} = $v;
     }
     if ($update) {
         $criteria = new CdbCriteria();
         if (is_array($condition)) {
             foreach ($condition as $column => $value) {
                 $criteria->addCondition("{$column}='{$value}'");
             }
         } else {
             $criteria->where = $condition;
         }
         return $record->updateAll($data, $criteria);
     } else {
         return $record->save();
     }
 }