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