Yii CActiveRecord 逻辑删除封装

最新推荐文章于 2025-04-16 16:15:26 发布

doushen1

最新推荐文章于 2025-04-16 16:15:26 发布

阅读量1.1k

点赞数

分类专栏： Yii

Yii 专栏收录该内容

7 篇文章

订阅专栏

本文探讨了在数据库模型设计中如何实现数据的高效存储与快速检索，通过实例展示了使用ORM（对象关系映射）技术简化操作过程，并介绍了在实际应用中如何进行模型的前后端分离，以及如何在数据库中实现数据的逻辑删除与查询优化。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?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.youkuaiyun.com/f0225/article/details/19079155