most data have created_date, created_by, updated_date and updated_by columns to audit records. in yii, these columns can be automatically updated via these 2 behaviors:

• CTimestampBehavior - a standard zii behavior that is distributed with yii
• BlameableBehavior - a user contributed extension. download from this page and unzip to /path/to/components/behaviors

edit /path/to/models/<Model>.php and add / edit behavior function:

PHP:

note

lines 6, 7: set to null if column does not exist.

line 8: update date column by default is not updated on create unless this is set to true

lines 12, 13: these are not required if the column names are 'created_by', 'modified_by'. it seems to be able to detect such column does not exist too.

now, these fields are automatically updated!

hacking blameable behavior

always update by

updatedByColumn will not be updated to current user if the field has a value, ie if it is not empty.

if you want this field to always gets updated with every data modification, go to the source code, remove the empty function checking from lines 31 and 34.

save as username instead id

add the following attribute somewhere after defining $updatedByColumn:

PHP:

find following codes:

PHP:

replace 'id' with {$this->userAttribute}, so the code looks like:

PHP:

edit /path/to/models/<Model>.php and add / edit behavior function to set userAttribute:

PHP: