Yii CActiveRecord 逻辑删除封装

<?php
class BaseModel extends CActiveRecord
{
    /**
     * Set id,cretate_time,update_time value before save this model
     */
    protected function beforeSave()
    {
        if($this->isNewRecord)
        {
            if($this->hasAttribute('id'))
            {
                $this->id = StringUtil::uuid();
            }

            if($this->hasAttribute('creator') && empty($this->creator))
            {
                $this->creator = Yii::app()->user->id;
            }

            if($this->hasAttribute('create_time'))
            {
                $this->create_time = new CDbExpression('NOW()');
            }
        }

        if($this->hasAttribute('updated_time'))
        {
            $this->updated_time = new CDbExpression('NOW()');
        }

        return parent::beforeSave();
    }


    /**
     * check the value is true or false
     * @param $value The need checked value
     */
    public function checkTruthy($value)
    {
        $truthy = (bool)$value;
        if('string' == gettype($value))
        {
            if ('true' != $value && '1' != $value)
            {
                $truthy = false;
            }
        }
        return $truthy;
    }

    /**
     * logic delete, set is delete cloum true if has
     * @see CActiveRecord::deleteByPK()
     */
    public function deleteByPK($pk,$condition='',$params=array())
    {
        Yii::trace(get_class($this).'.deleteByPk()','system.model.CActiveRecord');

        if($this->hasAttribute('is_delete'))
        {
            return $this->updateByPk($pk, array('is_delete' => Constant::DELETED), $condition, $params);
        }
        else
        {
            return parent::deleteByPK($pk, $condition, $params);
        }
    }

    /**
     * logic delete, set is delete cloum true if has
     * @see CActiveRecord::deleteAll()
     */
    public function deleteAll($condition='',$params=array())
    {
        Yii::trace(get_class($this).'.deleteAll()','system.model.BaseModel');

        if($this->hasAttribute('is_delete'))
        {
            return $this->updateAll(array('is_delete' => Constant::DELETED), $condition, $params);
        }
        else
        {
            return parent::deleteAll($condition, $params);
        }
    }

    /**
     * logic delete, set is delete cloum true if has
     * @see CActiveRecord::deleteAllByAttributes()
     */
    public function deleteAllByAttributes($attributes,$condition='',$params=array())
    {
        Yii::trace(get_class($this).'.deleteAllByAttributes()','system.model.BaseModel');

        if($this->hasAttribute('is_delete'))
        {
            $builder=$this->getCommandBuilder();
            $criteria=$builder->createCriteria($condition,$params);

            if(is_array($attributes))
            {
                $columnCriteria = new CDbCriteria();

                foreach ($attributes as $key => $value)
                {
                    if($this->hasAttribute($key))
                    {
                        $columnCriteria->compare($key, $value);
                    }
                }

                $criteria->mergeWith($columnCriteria);
            }

            return $this->updateAll(array('is_delete' => Constant::DELETED), $criteria);
        }
        else
        {
            return parent::deleteAllByAttributes($attributes, $condition, $params);
        }
    }

    /**
     * filter deleted
     * @see CActiveRecord::query()
     */
    protected function query($criteria,$all=false)
    {
        if($this->hasAttribute('is_delete'))
        {
            $criteria->compare($this->getTableAlias() . '.is_delete', Constant::NOT_DELETED);
        }

        return parent::query($criteria,$all);
    }

    /**
     * filter deleted
     * @see CActiveRecord::count()
     */
    public function count($condition='',$params=array())
    {
        Yii::trace(get_class($this).'.count()','app.model.BaseModel');
        $builder=$this->getCommandBuilder();
        $criteria=$builder->createCriteria($condition,$params);

        if($this->hasAttribute('is_delete'))
        {
            $criteria->compare($this->getTableAlias() . '.is_delete', Constant::NOT_DELETED);
        }

        $this->applyScopes($criteria);

        if(empty($criteria->with))
            return $builder->createCountCommand($this->getTableSchema(),$criteria)->queryScalar();
        else
        {
            $finder=new CActiveFinder($this,$criteria->with);
            return $finder->count($criteria);
        }
    }

    /**
     * filter deleted
     * @see CActiveRecord::countByAttributes()
     */
    public function countByAttributes($attributes,$condition='',$params=array())
    {
        Yii::trace(get_class($this).'.countByAttributes()','app.model.BaseModel');
        $prefix=$this->getTableAlias(true).'.';
        $builder=$this->getCommandBuilder();
        $criteria=$builder->createColumnCriteria($this->getTableSchema(),$attributes,$condition,$params,$prefix);

        if($this->hasAttribute('is_delete'))
        {
            $criteria->compare($this->getTableAlias() . '.is_delete', Constant::NOT_DELETED);
        }

        $this->applyScopes($criteria);

        if(empty($criteria->with))
            return $builder->createCountCommand($this->getTableSchema(),$criteria)->queryScalar();
        else
        {
            $finder=new CActiveFinder($this,$criteria->with);
            return $finder->count($criteria);
        }
    }

    /**
     * remove attributes from record model
     */
    public function uselessFields()
    {
        return array('is_delete');
    }

    /**
     * romeve useless fileds when CJSON::encode.
     */
    public function getIterator()
    {
        $attributes=$this->getAttributes();
        $uselessFields = $this->uselessFields();
        foreach($uselessFields as $field)
        {
            if(isset($attributes[$field]))
            {
                unset($attributes[$field]);
            }
        }
        return new CMapIterator($attributes);
    }
}

封装方法时需要先看一下Yii中的有关源码，有的只需要要在源码的基础上添加上自己的条件即可，如count等，只是添加了is_delete条件的判断

转载自：http://blog.csdn.net/f0225/article/details/19079155