ActiveRecord

gistfile1.txt

<?php

class ActiveRecord extends CActiveRecord
{

	public static function model($className = null)
	{
		return parent::model($className ? : get_called_class());
	}

	protected function beforeSave()
	{
		if ($this->getIsNewRecord()) {
			if (isset($this->getMetaData()->columns['create_date']) && !$this->create_date)
				$this->create_date = new CDbExpression('NOW()');
			if (isset($this->getMetaData()->columns['create_user_id']) && !$this->create_user_id)
				$this->create_user_id = Yii::app()->user->id;
		}
		if (isset($this->getMetaData()->columns['last_update_date']))
			$this->last_update_date = new CDbExpression('NOW()');
		if (isset($this->getMetaData()->columns['last_update_user_id']))
			$this->last_update_user_id = Yii::app()->user->id;
		return parent::beforeSave();
	}


	/* Trick to update active_yn instead of deleting records */
	// Todo: it would be better to override CDbCommandBuilder::createDeleteCommand
	// but can't find the way to do that except using namespaces probably
	function deleteByPk($pk, $condition = '', $params = array())
	{
		if (isset($this->getMetaData()->columns['active_yn'])) {
			return $this->updateByPk($pk, array(
				'active_yn' => false,
				'last_update_date' => new CDbExpression('NOW()'),
				'last_update_user_id' => Yii::app()->user->id,
			), $condition, $params);
		} else
			return parent::deleteByPk($pk, $condition, $params);
	}

	function deleteAll($condition = '', $params = array())
	{
		if (isset($this->getMetaData()->columns['active_yn'])) {
			return $this->updateAll(array(
				'active_yn' => false,
				'last_update_date' => new CDbExpression('NOW()'),
				'last_update_user_id' => Yii::app()->user->id,
			), $condition, $params);
		} else
			return parent::deleteAll($condition, $params);
	}

	function deleteAllByAttributes($attributes, $condition = '', $params = array())
	{
		if (isset($this->getMetaData()->columns['active_yn'])) {

			$builder = $this->getCommandBuilder();
			$table = $this->getTableSchema();
			$criteria = $builder->createColumnCriteria($table, $attributes, $condition, $params);
			$command = $builder->createUpdateCommand($table, array(
				'active_yn' => false,
				'last_update_date' => new CDbExpression('NOW()'),
				'last_update_user_id' => Yii::app()->user->id,
			), $criteria);
			return $command->execute();
		} else
			return parent::deleteAll($condition, $params);
	}

	public function defaultScope()
	{
		if (isset($this->getMetaData()->columns['active_yn'])) {
			$t = $this->getTableAlias(false, false);
			return array('condition' => "$t.active_yn = 1");
		} else {
			return parent::defaultScope();
		}
	}
	/* end of trick */
}