<?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