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 [email protected].
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_list_criteria".
39: *
40: * @package application.models
41: * @property integer $id
42: * @property integer $listId
43: * @property string $type
44: * @property string $attribute
45: * @property string $comparison
46: * @property string $value
47: */
48: class X2ListCriterion extends CActiveRecord {
49: /**
50: * Returns the static model of the specified AR class.
51: * @return ContactListCriterion the static model class
52: */
53: public static function model($className=__CLASS__) {
54: return parent::model($className);
55: }
56:
57: /**
58: * @return string the associated database table name
59: */
60: public function tableName() {
61: return 'x2_list_criteria';
62: }
63:
64: /**
65: * @return array validation rules for model attributes.
66: */
67: public function rules() {
68: // NOTE: you should only define rules for those attributes that
69: // will receive user inputs.
70: return array(
71: array('listId', 'required'),
72: array('id, listId', 'numerical', 'integerOnly'=>true),
73: array('comparison', 'length', 'max'=>10),
74: array('type', 'length', 'max'=>20),
75: array('attribute', 'length', 'max'=>40),
76: array('value', 'length', 'max'=>100),
77: // The following rule is used by search().
78: // Please remove those attributes that should not be searched.
79: array('id, listId, type, attribute, comparison, value', 'safe', 'on'=>'search'),
80: );
81: }
82:
83: /**
84: * @return array relational rules.
85: */
86: public function relations() {
87: // NOTE: you may need to adjust the relation name and the related
88: // class name for the relations automatically generated below.
89: return array(
90: );
91: }
92:
93: /**
94: * @return array customized attribute labels (name=>label)
95: */
96: public function attributeLabels() {
97: return array(
98: 'id' => Yii::t('app','ID'),
99: 'listId' => Yii::t('contacts','List'),
100: 'type' => Yii::t('contacts','Type'),
101: 'attribute' => Yii::t('contacts','Attribute'),
102: 'comparison' => Yii::t('contacts','Comparison'),
103: 'value' => Yii::t('contacts','Value'),
104: );
105: }
106:
107: /**
108: * @return array available comparison types (value=>label)
109: */
110: public function getComparisonList() {
111: return array(
112: '='=>Yii::t('contacts','equals'),
113: '>'=>Yii::t('contacts','greater than'),
114: '<'=>Yii::t('contacts','less than'),
115: '<>'=>Yii::t('contacts','not equal to'),
116: 'list'=>Yii::t('contacts','in list'),
117: 'notList'=>Yii::t('contacts','not in list'),
118: 'empty'=>Yii::t('contacts','empty'),
119: 'notEmpty'=>Yii::t('contacts','not empty'),
120: 'contains'=>Yii::t('contacts','contains'),
121: 'noContains'=>Yii::t('contacts','does not contain'),
122: );
123: }
124:
125: /**
126: * Retrieves a list of models based on the current search/filter conditions.
127: * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
128: */
129: public function search() {
130: // Warning: Please modify the following code to remove attributes that
131: // should not be searched.
132:
133: $criteria=new CDbCriteria;
134:
135: $criteria->compare('id',$this->id,true);
136: $criteria->compare('listId',$this->listId,true);
137: $criteria->compare('type',$this->type,true);
138: $criteria->compare('attribute',$this->attribute,true);
139: $criteria->compare('comparison',$this->comparison,true);
140: $criteria->compare('value',$this->value,true);
141:
142: return new CActiveDataProvider(get_class($this), array(
143: 'criteria'=>$criteria,
144: ));
145: }
146: }
147: