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_sessions".
39: *
40: * @package application.models
41: * @property integer $id
42: * @property string $user
43: * @property integer $lastUpdated
44: * @property string $IP
45: * @property integer $status
46: */
47: class SessionLog extends CActiveRecord {
48: /**
49: * Returns the static model of the specified AR class.
50: * @return Session the static model class
51: */
52: public static function model($className=__CLASS__) {
53: return parent::model($className);
54: }
55:
56: /**
57: * @return string the associated database table name
58: */
59: public function tableName() {
60: return 'x2_session_log';
61: }
62:
63: /**
64: * @return array validation rules for model attributes.
65: */
66: public function rules() {
67: // NOTE: you should only define rules for those attributes that
68: // will receive user inputs.
69: return array(
70: array('timestamp', 'numerical', 'integerOnly'=>true),
71: array('user', 'length', 'max'=>40),
72: // The following rule is used by search().
73: // Please remove those attributes that should not be searched.
74: array('id, user, timestamp', 'safe', 'on'=>'search'),
75: );
76: }
77:
78: /**
79: * @return array relational rules.
80: */
81: public function relations() {
82: // NOTE: you may need to adjust the relation name and the related
83: // class name for the relations automatically generated below.
84: return array();
85: }
86:
87: /**
88: * @return array customized attribute labels (name=>label)
89: */
90: public function attributeLabels() {
91: return array(
92: 'id' => Yii::t('admin','Sesesion ID'),
93: 'user' => Yii::t('admin','User'),
94: 'timestamp' => Yii::t('admin','Timestamp'),
95: 'status' => Yii::t('admin','Session Event'),
96: );
97: }
98:
99: /**
100: * Retrieves a list of models based on the current search/filter conditions.
101: * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
102: */
103: public function search() {
104: // Warning: Please modify the following code to remove attributes that
105: // should not be searched.
106:
107: $criteria=new CDbCriteria;
108:
109: $criteria->compare('id',$this->id);
110: $criteria->compare('sessionId',$this->id);
111: $criteria->compare('user',$this->user,true);
112: $criteria->compare('timestamp',$this->lastUpdated);
113: $criteria->compare('status',$this->status);
114:
115: return new CActiveDataProvider(get_class($this), array(
116: 'criteria'=>$criteria,
117: ));
118: }
119:
120: public static function logSession($user, $sessionId, $status){
121: $sessionLog=Yii::app()->db->createCommand()
122: ->select('sessionLog')
123: ->from('x2_admin')
124: ->where('id=1')
125: ->queryScalar();
126: if($sessionLog){
127: $model=new SessionLog;
128: $model->user=$user;
129: $model->sessionId=$sessionId;
130: $model->status=$status;
131: $model->timestamp=time();
132: $model->save();
133: }
134: }
135:
136: public static function parseStatus($status){
137: $ret=$status;
138: switch($status){
139: case 'login':
140: $ret='Logged In';
141: break;
142: case 'invisible':
143: $ret="Went Invisible";
144: break;
145: case 'visible':
146: $ret="Went Visible";
147: break;
148: case 'passiveTimeout':
149: $ret='Timeout On Session Cleanup';
150: break;
151: case 'activeTimeout':
152: $ret='Timeout On User Activity';
153: break;
154: case 'logout':
155: $ret="Logged Out";
156: break;
157: }
158: return $ret;
159: }
160: }