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:  * Deletes oldest records if count surpasses limit
39:  */
40: class RecordLimitBehavior extends CActiveRecordBehavior {
41: 
42:     /**
43:      * @var int $limit max number of records
44:      */
45:     public $limit; 
46: 
47:     /**
48:      * @var string $timestampField will be used to find oldest record 
49:      */
50:     public $timestampField; 
51: 
52:     public function afterSave ($event) {
53:         if (!is_numeric ($this->limit)) return;
54:         if ($this->getStaticModel ()->count () > $this->limit) {
55:             $oldestRecordId = Yii::app()->db->createCommand ()
56:                 ->select ("id")
57:                 ->from ($this->owner->tableName ())
58:                 ->where (
59:                     "{$this->timestampField}=(
60:                         SELECT MIN({$this->timestampField})
61:                         FROM {$this->owner->tableName ()}
62:                     )")
63:                 ->queryScalar ();
64: 
65:             $oldest = $this->getStaticModel ()->findByPk ($oldestRecordId);
66:             if ($oldest) {
67:                 $oldest->delete ();
68:             }
69:         }
70: 
71:     }
72: 
73:     private $_staticModel;
74:     private function getStaticModel () {
75:         if (!isset ($this->_staticModel)) {
76:             $class = get_class ($this->owner);
77:             $this->_staticModel = $class::model ();
78:         }
79:         return $this->_staticModel;
80:     }
81: 
82: }
83: 
84: ?>
85: