Michael Mafort

CREATE TABLE `logs` (
 
          `id` int(10) unsigned NOT NULL auto_increment,
          #este é o meu id do usuario logado, meu model de autenticação chama-se authuser
          `authuser_id` int(10) unsigned NOT NULL,
          `model` varchar(60) default NULL,
          `action` varchar(20) default NULL,
          `old_data` text,
          `new_data` text,
          `created` datetime default NULL,
          PRIMARY KEY  (`id`),
          KEY `logs_FKIndex1` (`authuser_id`)
        ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

class Log extends AppModel {
 
	var $name = 'Log';
 
	//The Associations below have been created with all possible keys, those that are not needed can be removed
	var $belongsTo = array(
	      'Authuser' => array('className' => 'Authuser',
			'foreignKey' => 'authuser_id',
			'conditions' => '',
			'fields' => '',
			'order' => ''
		)
	);
 
}

 
/**
 * Behavior for log actions of tables.
 *
 * Behavior to simplify logs
 *
 * PHP versions 5
 *
 *
 * Licensed under The MIT License
 * Redistributions of files must retain the above copyright notice.
 *
 * @filesource
 * @copyright	Copyright 2005-2008, Criasol Ltd.
 * @link		http://www.criasol.com.br
 * @since		12-07-2009
 * @license		http://www.opensource.org/licenses/mit-license.php The MIT License
 */
 
/**
 * Behavior to register log to all actions in your table model
 *
 */
 
App::import('Model','Log');
App::import('Component', 'Session');
 
class LogsBehavior extends ModelBehavior {
 
/**
 * Current model
 *
 * @var Object
 */
private $Model;
 
/**
 * Session component object
 *
 * @var Object
 */
private $Session;
 
/**
 * Old data
 * last data from model before modified
 *
 * @var array
 */
private $_oldData;
 
/**
 * New data
 * new value from model after modified
 *
 * @var array
 */
private $_newData;
 
/**
 * Model log
 *
 * @var Object
 */
private $Log;
 
/**
 * Action
 * type of action called
 *
 * @var string
 */
private $_action;
 
/**
 * Deleted id
 * id from data to delete
 *
 * @var int
 */
private $_deletedId;
 
/**
 * Setup method
 *
 * Configure this behavior
 *
 * @param ObjectModel $model
 * @param array $config
 */
public function setup(&$model, $config = null){
	$this->Model = $model;
	$this->Session = new SessionComponent();
	$this->Log = new Log();
}
 
/**
 * Before save
 *
 * @param ObjectModel $model
 * @return boolean true
 */
public function beforeSave(&$model){
	if( is_numeric($this->Model->id) ){
		$this->_action = 'edit';
		$newData = $this->Model->find('first', array('conditions'=> array( "{$this->Model->name}.id" => $this->Model->data[$this->Model->name]['id'] ) ) );
 
		foreach( $newData[$this->Model->name] as $input => $value ){
			$this->_oldData .= "$input :: $valuen";
		}
 
	}
	else
		$this->_action = 'add';
 
	return true;
}
 
/**
 * After save
 *
 * @param objectModel $model
 * @param string $created
 * @return boolean true
 */
public function afterSave(&$model, $created){
	$newData = $this->Model->read(null, $this->Model->id);
	foreach( $newData[$this->Model->name] as $input => $value ){
		$this->_newData .= "$input :: $valuen";
	}
	$this->write();
	return true;
}
 
/**
 * Before delete
 *
 * @param objectModel $model
 * @param boolean $cascade
 * @return boolean true
 */
public function beforeDelete(&$model, $cascade=true){
 
	$this->_action = 'delete';
	$this->_deletedId = $this->Model->data[$this->Model->name]['id'];
	$newData = $this->Model->read(null, $this->_deletedId );
 
	foreach( $newData[$this->Model->name] as $input => $value ){
		$this->_oldData .= "$input :: $valuen";
	}
 
	return true;
}
 
/**
 * After delete action
 *
 * @param ObjectModel $model
 * @return boolean true
 */
public function afterDelete(&$model){
	$this->write();
	return true;
}
 
/**
 * Write log
 *
 * @return void
 */
public function write(){
	if( $this->Model->name == 'Log' )
		return true;
 
	$this->Log->id = null;
	$this->Log->save(array(
		'Log'=>array(
			'authuser_id' => $this->Session->read('Authuser.id'),
			'model' => $this->Model->name,
			'action' => $this->_action,
			'old_data' => $this->_oldData,
			'new_data' => $this->_newData
			)
		));
	}
 
}
?>