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_urls".
 39:  *
 40:  * @package application.models
 41:  * @property integer $id(auto-incremented)
 42:  * @property string $title
 43:  * @property string $url
 44:  * @property integer userid
 45:  * @property integer timestamp
 46:  */
 47: class URL extends CActiveRecord{
 48: 
 49:     const DEFAULT_PROTO = 'http';
 50: 
 51:     /**
 52:      * Returns the static model of the specified AR class.
 53:      * @return Roles the static model class
 54:      */
 55:     public static function model($className=__CLASS__)
 56:     {
 57:         return parent::model($className);
 58:     }
 59: 
 60:     /**
 61:      * Prepends the default protocol to a URL that is just a bare domain, i.e.
 62:      * "google.com"
 63:      * 
 64:      * @param type $url
 65:      */
 66:     public static function prependProto($url){
 67:         return !preg_match('%^https?://%', $url) ? self::DEFAULT_PROTO.'://'.$url : $url;
 68:     }
 69: 
 70:     /**
 71:      * @return string the associated database table name
 72:      */
 73:     public function tableName()
 74:     {
 75:         return 'x2_urls';
 76:     }
 77: 
 78:     /**
 79:      * @return array validation rules for model attributes.
 80:      */
 81:     public function rules()
 82:     {
 83:         // NOTE: you should only define rules for those attributes that
 84:         // will receive user inputs.
 85:         return array(
 86:             array('title,url', 'required'),
 87:             array('title,url', 'length', 'max'=>250),
 88:             array('userid,timestamp', 'safe'),
 89:             // The following rule is used by search().
 90:             // Please remove those attributes that should not be searched.
 91:             array('title, url, userid, timestamp', 'safe', 'on'=>'search'),
 92:         );
 93:     }
 94: 
 95:     /**
 96:      * @return array relational rules.
 97:      */
 98:     public function relations()
 99:     {
100:         // NOTE: you may need to adjust the relation name and the related
101:         // class name for the relations automatically generated below.
102:         return array(
103:         );
104:     }
105: 
106:     /**
107:      * @return array customized attribute labels (name=>label)
108:      */
109:     public function attributeLabels()
110:     {
111:         return array(
112:             'title' => 'Title',
113:             'url' => 'URL',
114:             'userid' => 'User ID',
115:             'timestamp' => 'Time Stamp',
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:     {
125:         // Warning: Please modify the following code to remove attributes that
126:         // should not be searched.
127: 
128:         $criteria=new CDbCriteria;
129: 
130:         $criteria->compare('title',$this->title);
131:         $criteria->compare('url',$this->url,true);
132:         $criteria->compare('userid',$this->userid,true);
133:         $criteria->compare('timestamp',$this->timestamp,true);
134: 
135:         return new CActiveDataProvider(get_class($this), array(
136:             'criteria'=>$criteria,
137:         ));
138:     }
139: }
140: