(Alek), age (28) => (29)] or [name, age] * * - "version_id" [int] : cooperates with RevisionBehavior to link the the shadow table (thus linking to old data) * * Remember that Logable behavior needs to be added after RevisionBehavior. In fact, just put it last to be safe. * * Optionally register what user was responisble for the activity : * * - Supply configuration only if defaults are wrong. Example given with defaults : * * public $actsAs = array('Logable' => array('userModel' => 'User', 'userKey' => 'user_id')); * * - In AppController (or single controller if only needed once) add these lines to beforeFilter : * * if (count($this->uses) && $this->{$this->modelClass}->Behaviors->loaded('Logable')) { * $this->{$this->modelClass}->setUserData($this->activeUser); * } * * Where "$activeUser" should be an array in the standard format for the User model used : * * $activeUser = array( $UserModel->alias => array( $UserModel->primaryKey => 123, $UserModel->displayField => 'Alexander')); * // any other key is just ignored by this behaviour. * * @author Alexander Morland (alexander#maritimecolours.no) * @co-author Eskil Mjelva Saatvedt * @co-author Ronny Vindenes * @co-author Carl Erik Fyllingen * @contributor Miha * @category Behavior * @version 2.2 * @modified 3.june 2009 by Miha * @modified 2011-11-17 ms (mark scherer) cake2.0 ready * */ class LogableBehavior extends ModelBehavior { public $user = null; # user data array public $UserModel = null; protected $_defaults = array( 'enabled' => true, 'on' => 'save', // validate/save 'userModel' => CLASS_USER, 'logModel' => 'Tools.Log', 'userKey' => 'user_id', 'change' => 'list', 'descriptionIds' => true, 'skip' => array(), 'ignore' => array(), 'classField' => 'model', 'foreignKey' => 'foreign_id', 'autoRelation' => false, # attach relation to the model (hasMany Log) ); /** * Config options are : * - userModel : 'User'. Class name of the user model you want to use (User by default), if you want to save User in log * - userKey : 'user_id'. The field for saving the user to (user_id by default). * - change : 'list' > [name, age]. Set to 'full' for [name (alek) => (Alek), age (28) => (29)] * - descriptionIds : TRUE. Set to false to not include model id and user id in the title field * - skip: array(). String array of actions to not log * - ignore: array(). Fields to ignore * * @param Object $Model * @param array $config */ public function setup(Model $Model, $config = array()) { if (!is_array($config)) { $config = array(); } $this->settings[$Model->alias] = array_merge($this->_defaults, $config); $this->settings[$Model->alias]['ignore'][] = $Model->primaryKey; $this->Log = ClassRegistry::init($this->settings[$Model->alias]['logModel']); if ($this->settings[$Model->alias]['userModel'] !== $Model->alias) { $this->UserModel = ClassRegistry::init($this->settings[$Model->alias]['userModel']); } else { $this->UserModel = $Model; } } public function settings(Model $Model) { return $this->settings[$Model->alias]; } public function enableLog(Model $Model, $enable = null) { if ($enable !== null) { $this->settings[$Model->alias]['enabled'] = $enable; } return $this->settings[$Model->alias]['enabled']; } /** * Useful for getting logs for a model, takes params to narrow find. * This method can actually also be used to find logs for all models or * even another model. Using no params will return all activities for * the models it is called from. * * Possible params : * 'model' : mixed (null) String with className, null to get current or false to get everything * 'action' : string (null) String with action (add/edit/delete), null gets all * 'order' : string ('created DESC') String with custom order * 'conditions : array (array()) Add custom conditions * 'foreign_id' : int (null) Add a int * * (remember to use your own user key if you're not using 'user_id') * 'user_id' : int (null) Defaults to all users, supply id if you want for only one User * * @param Object $Model * @param array $params * @return array */ public function findLog(Model $Model, $params = array()) { $defaults = array( $this->settings[$Model->alias]['classField'] => null, 'action' => null, 'order' => $this->Log->alias . '.id DESC', $this->settings[$Model->alias]['userKey'] => null, 'conditions' => array(), $this->settings[$Model->alias]['foreignKey'] => null, 'fields' => array(), 'limit' => 50, ); $params = array_merge($defaults, $params); $options = array('order' => $params['order'], 'conditions' => $params['conditions'], 'fields' => $params['fields'], 'limit' => $params['limit']); if ($params[$this->settings[$Model->alias]['classField']] === null) { $params[$this->settings[$Model->alias]['classField']] = $Model->alias; } if ($params[$this->settings[$Model->alias]['classField']]) { if ($this->Log->hasField($this->settings[$Model->alias]['classField'])) { $options['conditions'][$this->settings[$Model->alias]['classField']] = $params[$this->settings[$Model->alias]['classField']]; } elseif ($this->Log->hasField('description')) { $options['conditions']['description LIKE '] = $params[$this->settings[$Model->alias]['classField']] . '%'; } else { return false; } } if ($params['action'] && $this->Log->hasField('action')) { $options['conditions']['action'] = $params['action']; } if ($params[$this->settings[$Model->alias]['userKey']] && $this->UserModel && is_numeric($params[$this->settings[$Model->alias]['userKey']])) { $options['conditions'][$this->settings[$Model->alias]['userKey']] = $params[$this->settings[$Model->alias]['userKey']]; } if ($params[$this->settings[$Model->alias]['foreignKey']] && is_numeric($params[$this->settings[$Model->alias]['foreignKey']])) { $options['conditions'][$this->settings[$Model->alias]['foreignKey']] = $params[$this->settings[$Model->alias]['foreignKey']]; } return $this->Log->find('all', $options); } /** * Get list of actions for one user. * Params for getting (one line) activity descriptions * and/or for just one model * * @example $this->Model->findUserActions(301, array('model' => 'BookTest')); * @example $this->Model->findUserActions(301, array('events' => true)); * @example $this->Model->findUserActions(301, array('fields' => array('id','model'),'model' => 'BookTest'); * @param Object $Model * @param integer $user_id * @param array $params * @return array */ public function findUserActions(Model $Model, $userId, $params = array()) { if (!$this->UserModel) { return null; } // if logged in user is asking for her own log, use the data we allready have if (isset($this->user) && isset($this->user[$this->UserModel->alias][$this->UserModel->primaryKey]) && $userId == $this->user[$this-> UserModel->alias][$this->UserModel->primaryKey] && isset($this->user[$this->UserModel->alias][$this->UserModel->displayField])) { $username = $this->user[$this->UserModel->alias][$this->UserModel->displayField]; } else { $this->UserModel->recursive = -1; $user = $this->UserModel->find('first', array('conditions' => array($this->UserModel->primaryKey => $userId))); $username = $user[$this->UserModel->alias][$this->UserModel->displayField]; } $fields = array(); if (isset($params['fields'])) { if (is_array($params['fields'])) { $fields = $params['fields']; } else { $fields = array($params['fields']); } } $conditions = array($this->settings[$Model->alias]['userKey'] => $userId); if (isset($params[$this->settings[$Model->alias]['classField']])) { $conditions[$this->settings[$Model->alias]['classField']] = $params[$this->settings[$Model->alias]['classField']]; } $order = array($this->Log->alias . '.id' => 'DESC'); if (isset($params['order'])) { $order = $params['order']; } $data = $this->Log->find('all', array( 'conditions' => $conditions, 'recursive' => -1, 'fields' => $fields, 'order' => $order )); if (!isset($params['events']) || (isset($params['events']) && $params['events'] == false)) { return $data; } $result = array(); foreach ($data as $key => $row) { $one = $row[$this->Log->alias]; $result[$key][$this->Log->alias]['id'] = $one['id']; $result[$key][$this->Log->alias]['event'] = $username; // have all the detail models and change as list : if (isset($one[$this->settings[$Model->alias]['classField']]) && isset($one['action']) && isset($one['change']) && isset($one[$this-> settings[$Model->alias]['foreignKey']])) { if ($one['action'] === 'edit') { $result[$key][$this->Log->alias]['event'] .= ' edited ' . $one['change'] . ' of ' . strtolower($one[$this->settings[$Model->alias]['classField']]) . '(id ' . $one[$this->settings[$Model->alias]['foreignKey']] . ')'; // ' at '.$one['created']; } elseif ($one['action'] === 'add') { $result[$key][$this->Log->alias]['event'] .= ' added a ' . strtolower($one[$this->settings[$Model->alias]['classField']]) . '(id ' . $one[$this-> settings[$Model->alias]['foreignKey']] . ')'; } elseif ($one['action'] === 'delete') { $result[$key][$this->Log->alias]['event'] .= ' deleted the ' . strtolower($one[$this->settings[$Model->alias]['classField']]) . '(id ' . $one[$this-> settings[$Model->alias]['foreignKey']] . ')'; } } elseif (isset($one[$this->settings[$Model->alias]['classField']]) && isset($one['action']) && isset($one[$this->settings[$Model->alias]['foreignKey']])) { // have model,foreign_id and action if ($one['action'] === 'edit') { $result[$key][$this->Log->alias]['event'] .= ' edited ' . strtolower($one[$this->settings[$Model->alias]['classField']]) . '(id ' . $one[$this-> settings[$Model->alias]['foreignKey']] . ')'; // ' at '.$one['created']; } elseif ($one['action'] === 'add') { $result[$key][$this->Log->alias]['event'] .= ' added a ' . strtolower($one[$this->settings[$Model->alias]['classField']]) . '(id ' . $one[$this-> settings[$Model->alias]['foreignKey']] . ')'; } elseif ($one['action'] === 'delete') { $result[$key][$this->Log->alias]['event'] .= ' deleted the ' . strtolower($one[$this->settings[$Model->alias]['classField']]) . '(id ' . $one[$this-> settings[$Model->alias]['foreignKey']] . ')'; } } else { // only description field exist $result[$key][$this->Log->alias]['event'] = $one['description']; } } return $result; } /** * Use this to supply a model with the data of the logged in User. * Intended to be called in AppController::beforeFilter like this : * * if ($this->{$this->modelClass}->Behaviors->loaded('Logable')) { * $this->{$this->modelClass}->setUserData($activeUser);/ * } * * The $userData array is expected to look like the result of a * User::find(array('id'=>123)); * * @param Object $Model * @param array $userData */ public function setUserData(Model $Model, $userData = null) { if ($userData === null && isset($Model->Session)) { $userData = (array)$Model->Session->read('Auth'); } elseif ($userData === null && class_exists('CakeSession')) { $userData = (array)CakeSession::read('Auth'); } if ($userData !== null) { $this->user = $userData; } } /** * Used for logging custom actions that arent crud, like login or download. * * @example $this->Boat->customLog('ship', 66, array('title' => 'Titanic heads out')); * @param Object $Model * @param string $action name of action that is taking place (dont use the crud ones) * @param integer $id id of the logged item (ie foreign_id in logs table) * @param array $values optional other values for your logs table * @return mixed Success */ public function customLog(Model $Model, $action, $id = null, $values = array()) { $logData[$this->Log->alias] = $values; if ($id === null) { $id = $Model->id; } if ($this->Log->hasField($this->settings[$Model->alias]['foreignKey']) && is_numeric($id)) { $logData[$this->Log->alias][$this->settings[$Model->alias]['foreignKey']] = $id; } $title = null; if (isset($values['title'])) { $title = $values['title']; unset($logData[$this->Log->alias]['title']); } $logData[$this->Log->alias]['action'] = $action; return $this->_saveLog($Model, $logData, $title); } public function clearUserData(Model $Model) { $this->user = null; } public function setUserIp(Model $Model, $userIP = null) { if ($userIP === null) { $userIP = Utility::getClientIp(); } $this->userIP = $userIP; } public function beforeDelete(Model $Model, $cascade = true) { $this->setUserData($Model); if (!$this->settings[$Model->alias]['enabled']) { return true; } if (isset($this->settings[$Model->alias]['skip']['delete']) && $this->settings[$Model->alias]['skip']['delete']) { return true; } $Model->recursive = -1; $Model->read(); return true; } public function afterDelete(Model $Model) { if (!$this->settings[$Model->alias]['enabled']) { return true; } if (isset($this->settings[$Model->alias]['skip']['delete']) && $this->settings[$Model->alias]['skip']['delete']) { return true; } $logData = array(); if ($this->Log->hasField('description')) { $logData[$this->Log->alias]['description'] = $Model->alias; if (isset($Model->data[$Model->alias][$Model->displayField]) && $Model->displayField != $Model->primaryKey) { $logData[$this->Log->alias]['description'] .= ' "' . $Model->data[$Model->alias][$Model->displayField] . '"'; } if ($this->settings[$Model->alias]['descriptionIds']) { $logData[$this->Log->alias]['description'] .= ' (' . $Model->id . ') '; } $logData[$this->Log->alias]['description'] .= __('deleted'); } $logData[$this->Log->alias]['action'] = 'delete'; $this->_saveLog($Model, $logData); } public function beforeValidate(Model $Model, $options = array()) { if (!$this->settings[$Model->alias]['enabled'] || $this->settings[$Model->alias]['on'] !== 'validate') { return true; } $this->_prepareLog($Model); return true; } public function beforeSave(Model $Model, $options = array()) { if (!$this->settings[$Model->alias]['enabled'] || $this->settings[$Model->alias]['on'] !== 'save') { return true; } $this->_prepareLog($Model); return true; } protected function _prepareLog(Model $Model) { if ($this->user === null) { $this->setUserData($Model); } if ($Model->id && empty($this->old)) { $options = array('conditions' => array($Model->primaryKey => $Model->id), 'recursive' => -1); $this->old = $Model->find('first', $options); } } public function afterSave(Model $Model, $created, $options = array()) { if (!$this->settings[$Model->alias]['enabled']) { return true; } if (!empty($this->settings[$Model->alias]['skip']['add']) && $created) { return true; } elseif (!empty($this->settings[$Model->alias]['skip']['edit']) && !$created) { return true; } $keys = array_keys($Model->data[$Model->alias]); $diff = array_diff($keys, $this->settings[$Model->alias]['ignore']); if (count($diff) === 0 && empty($Model->logableAction)) { return false; } if ($Model->id) { $id = $Model->id; } elseif ($Model->insertId) { $id = $Model->insertId; } if ($this->Log->hasField($this->settings[$Model->alias]['foreignKey'])) { $logData[$this->Log->alias][$this->settings[$Model->alias]['foreignKey']] = $id; } if ($this->Log->hasField('description')) { $logData[$this->Log->alias]['description'] = $Model->alias . ' '; if (isset($Model->data[$Model->alias][$Model->displayField]) && $Model->displayField != $Model->primaryKey) { $logData[$this->Log->alias]['description'] .= '"' . $Model->data[$Model->alias][$Model->displayField] . '" '; } if ($this->settings[$Model->alias]['descriptionIds']) { $logData[$this->Log->alias]['description'] .= '(' . $id . ') '; } if ($created) { $logData[$this->Log->alias]['description'] .= __('added'); } else { $logData[$this->Log->alias]['description'] .= __('updated'); } } if ($this->Log->hasField('action')) { if ($created) { $logData[$this->Log->alias]['action'] = 'add'; } else { $logData[$this->Log->alias]['action'] = 'edit'; } } if ($this->Log->hasField('change')) { $logData[$this->Log->alias]['change'] = ''; $dbFields = array_keys($Model->schema()); $changedFields = array(); foreach ($Model->data[$Model->alias] as $key => $value) { if (isset($Model->data[$Model->alias][$Model->primaryKey]) && !empty($this->old) && isset($this->old[$Model->alias][$key])) { $old = $this->old[$Model->alias][$key]; } else { $old = ''; } if ($key !== 'modified' && !in_array($key, $this->settings[$Model->alias]['ignore']) && $value != $old && in_array($key, $dbFields)) { if ($this->settings[$Model->alias]['change'] === 'full') { $changedFields[] = $key . ' (' . $old . ') => (' . $value . ')'; } elseif ($this->settings[$Model->alias]['change'] === 'serialize') { $changedFields[$key] = array('old' => $old, 'value' => $value); } else { $changedFields[] = $key; } } } $changes = count($changedFields); if (!$changes) { return true; } if ($this->settings[$Model->alias]['change'] === 'serialize') { $logData[$this->Log->alias]['change'] = serialize($changedFields); } else { $logData[$this->Log->alias]['change'] = implode(', ', $changedFields); } $logData[$this->Log->alias]['changes'] = $changes; } if (empty($logData)) { return true; } return $this->_saveLog($Model, $logData); } /** * Does the actual saving of the Log model. Also adds the special field if possible. * * If model field in table, add the Model->alias * If action field is NOT in table, remove it from dataset * If the userKey field in table, add it to dataset * If userData is supplied to model, add it to the title * * @param Object $Model * @param array $logData * @return mixed Success */ public function _saveLog(Model $Model, $logData, $title = null) { if ($title !== null) { $logData[$this->Log->alias]['title'] = $title; } elseif ($Model->displayField == $Model->primaryKey) { $logData[$this->Log->alias]['title'] = $Model->alias . ' (' . $Model->id . ')'; } elseif (isset($Model->data[$Model->alias][$Model->displayField])) { $logData[$this->Log->alias]['title'] = $Model->data[$Model->alias][$Model->displayField]; } elseif ($Model->id) { $logData[$this->Log->alias]['title'] = $Model->field($Model->displayField); } elseif (!empty($logData[$this->Log->alias][$this->settings[$Model->alias]['foreignKey']])) { $options = array( 'conditions' => $logData[$this->Log->alias][$this->settings[$Model->alias]['foreignKey']], 'recursive' => -1 ); $record = $Model->find('first', $options); if ($record) { $logData[$this->Log->alias]['title'] = $record[$Model->alias][$Model->displayField]; } } if ($this->Log->hasField($this->settings[$Model->alias]['classField'])) { // by miha nahtigal $logData[$this->Log->alias][$this->settings[$Model->alias]['classField']] = $Model->name; } if ($this->Log->hasField($this->settings[$Model->alias]['foreignKey']) && !isset($logData[$this->Log->alias][$this->settings[$Model->alias]['foreignKey']])) { if ($Model->id) { $logData[$this->Log->alias][$this->settings[$Model->alias]['foreignKey']] = $Model->id; } elseif ($Model->insertId) { $logData[$this->Log->alias][$this->settings[$Model->alias]['foreignKey']] = $Model->insertId; } } if (!$this->Log->hasField('action')) { unset($logData[$this->Log->alias]['action']); } elseif (isset($Model->logableAction) && !empty($Model->logableAction)) { $logData[$this->Log->alias]['action'] = implode(',', $Model->logableAction); // . ' ' . $logData[$this->Log->alias]['action']; unset($Model->logableAction); } if ($this->Log->hasField('version_id') && isset($Model->versionId)) { $logData[$this->Log->alias]['version_id'] = $Model->versionId; unset($Model->versionId); } if ($this->Log->hasField('ip') && $this->userIP) { $logData[$this->Log->alias]['ip'] = $this->userIP; } if ($this->Log->hasField($this->settings[$Model->alias]['userKey']) && $this->user && isset($this->user[$this->UserModel->alias])) { $logData[$this->Log->alias][$this->settings[$Model->alias]['userKey']] = $this->user[$this->UserModel->alias][$this->UserModel->primaryKey]; } if ($this->Log->hasField('description')) { if (empty($logData[$this->Log->alias]['description'])) { $logData[$this->Log->alias]['description'] = __('Custom action'); } if ($this->user && $this->UserModel && isset($this->user[$this->UserModel->alias])) { $logData[$this->Log->alias]['description'] .= ' ' . __('by') . ' ' . $this->settings[$Model->alias]['userModel'] . ' "' . $this->user[$this->UserModel->alias][$this->UserModel->displayField] . '"'; if ($this->settings[$Model->alias]['descriptionIds']) { $logData[$this->Log->alias]['description'] .= ' (' . $this->user[$this->UserModel->alias][$this->UserModel->primaryKey] . ')'; } } else { // UserModel is active, but the data hasnt been set. Assume system action. $logData[$this->Log->alias]['description'] .= __(' by System'); } $logData[$this->Log->alias]['description'] .= '.'; } $this->Log->create($logData); return $this->Log->save(null, false); } }