1: <?php
2: /*****************************************************************************************
3: * X2Engine Open Source Edition is a customer relationship management program developed by
4: * X2Engine, Inc. Copyright (C) 2011-2016 X2Engine Inc.
5: *
6: * This program is free software; you can redistribute it and/or modify it under
7: * the terms of the GNU Affero General Public License version 3 as published by the
8: * Free Software Foundation with the addition of the following permission added
9: * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
10: * IN WHICH THE COPYRIGHT IS OWNED BY X2ENGINE, X2ENGINE DISCLAIMS THE WARRANTY
11: * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
12: *
13: * This program is distributed in the hope that it will be useful, but WITHOUT
14: * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
15: * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
16: * details.
17: *
18: * You should have received a copy of the GNU Affero General Public License along with
19: * this program; if not, see http://www.gnu.org/licenses or write to the Free
20: * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
21: * 02110-1301 USA.
22: *
23: * You can contact X2Engine, Inc. P.O. Box 66752, Scotts Valley,
24: * California 95067, USA. or at email address contact@x2engine.com.
25: *
26: * The interactive user interfaces in modified source and object code versions
27: * of this program must display Appropriate Legal Notices, as required under
28: * Section 5 of the GNU Affero General Public License version 3.
29: *
30: * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
31: * these Appropriate Legal Notices must retain the display of the "Powered by
32: * X2Engine" logo. If the display of the logo is not reasonably feasible for
33: * technical reasons, the Appropriate Legal Notices must display the words
34: * "Powered by X2Engine".
35: *****************************************************************************************/
36:
37: /**
38: * This is the model class for table "x2_changelog".
39: *
40: * The followings are the available columns in table 'x2_changelog':
41: * @property integer $id
42: * @property string $type
43: * @property integer $itemId
44: * @property string $changedBy
45: * @property string $changed
46: * @property string $fieldName
47: * @property string $oldValue
48: * @property string $newValue
49: * @property boolean $diff
50: * @property integer $timestamp
51: */
52: class Changelog extends CActiveRecord {
53: /**
54: * Returns the static model of the specified AR class.
55: * @param string $className active record class name.
56: * @return Changelog the static model class
57: */
58: public static function model($className=__CLASS__) {
59: return parent::model($className);
60: }
61:
62: /**
63: * @return string the associated database table name
64: */
65: public function tableName() {
66: return 'x2_changelog';
67: }
68:
69: /**
70: * @return array validation rules for model attributes.
71: */
72: public function rules() {
73: return array();
74: // array('type, itemId, changedBy', 'required'),
75: // array('itemId, timestamp', 'numerical', 'integerOnly'=>true),
76: // array('type, changedBy', 'length', 'max'=>50),
77: // array('fieldName', 'length', 'max'=>255),
78: // array('diff', 'boolean'),
79: // array('changed, oldValue, newValue', 'safe'),
80: // array('id, type, itemId, changedBy, changed, fieldName, oldValue, newValue, timestamp', 'safe', 'on'=>'search'),
81: // );
82: }
83:
84: public function behaviors() {
85: return array(
86: 'ERememberFiltersBehavior' => array(
87: 'class' => 'application.components.ERememberFiltersBehavior',
88: 'defaults'=>array(),
89: 'defaultStickOnClear'=>false
90: ),
91: );
92: }
93:
94: /**
95: * @return array relational rules.
96: */
97: public function relations() {
98: return array();
99: }
100:
101: /**
102: * @return array customized attribute labels (name=>label)
103: */
104: public function attributeLabels() {
105: return array(
106: 'id' => Yii::t('admin','ID'),
107: 'type' => Yii::t('admin','Type'),
108: 'itemId' => Yii::t('admin','Item'),
109: 'changedBy' => Yii::t('admin','Changed By'),
110: 'changed' => Yii::t('admin','Changed'),
111: 'fieldName' => Yii::t('admin','Field Name'),
112: 'oldValue' => Yii::t('admin','Old Value'),
113: 'newValue' => Yii::t('admin','New Value'),
114: 'diff' => Yii::t('admin','Diff'),
115: 'timestamp' => Yii::t('admin','Timestamp'),
116: );
117: }
118:
119: /**
120: * Retrieves a list of models based on the current search/filter conditions.
121: * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
122: */
123: public function search() {
124: // Warning: Please modify the following code to remove attributes that
125: // should not be searched.
126:
127: $criteria=new CDbCriteria;
128:
129: $parameters = array('limit'=>ceil(Profile::getResultsPerPage()));
130: $criteria->scopes = array('findAll'=>array($parameters));
131:
132: $criteria->compare('id',$this->id);
133: $criteria->compare('type',$this->type,true);
134: $criteria->compare('itemId',$this->itemId);
135: $criteria->compare('changedBy',$this->changedBy,true);
136: $criteria->compare('recordName',$this->recordName,true);
137: $criteria->compare('fieldName',$this->fieldName,true);
138: $criteria->compare('oldValue',$this->oldValue,true);
139: $criteria->compare('newValue',$this->newValue,true);
140: $criteria->compare('diff',$this->diff,true);
141: $criteria->compare('timestamp',$this->timestamp);
142:
143: return new SmartActiveDataProvider(get_class($this), array(
144: 'sort'=>array(
145: 'defaultOrder'=>'timestamp DESC',
146: ),
147: 'pagination'=>array(
148: 'pageSize'=>Profile::getResultsPerPage(),
149: ),
150: 'criteria'=>$criteria,
151: ));
152: }
153: }