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: Yii::import('application.models.X2Model');
 38: 
 39: /**
 40:  * This is the model class for table "x2_template".
 41:  * @package application.modules.template.models
 42:  */
 43: class BugReports extends X2Model {
 44: 
 45:     public $supportsWorkflow = true;
 46: 
 47:     /**
 48:      * Returns the static model of the specified AR class.
 49:      * @return Template the static model class
 50:      */
 51:     public static function model($className=__CLASS__) { return parent::model($className); }
 52: 
 53:     /**
 54:      * @return string the associated database table name
 55:      */
 56:     public function tableName() { return 'x2_bug_reports'; }
 57: 
 58:     public function behaviors() {
 59:         return array_merge(parent::behaviors(),array(
 60:             'X2LinkableBehavior'=>array(
 61:                 'class'=>'X2LinkableBehavior',
 62:                 'module'=>'bugReports'
 63:             ),
 64:             'ERememberFiltersBehavior' => array(
 65:                 'class'=>'application.components.ERememberFiltersBehavior',
 66:                 'defaults'=>array(),
 67:                 'defaultStickOnClear'=>false
 68:             ),
 69:             'InlineEmailModelBehavior' => array(
 70:                 'class'=>'application.components.InlineEmailModelBehavior',
 71:             )
 72:         ));
 73:     }
 74: 
 75: 
 76:     /**
 77:      * Retrieves a list of models based on the current search/filter conditions.
 78:      * @return CActiveDataProvider the data provider that can return the models based on the 
 79:      *  search/filter conditions.
 80:      */
 81:     public function search() {
 82:         $criteria=new CDbCriteria;
 83:         return $this->searchBase($criteria);
 84:     }
 85: 
 86:     public function afterFind(){
 87:         if($this->id!=$this->name){
 88:             $this->name=$this->id;
 89:             $this->update(array('name'));
 90:         }
 91:         return parent::afterFind();
 92:     }
 93: 
 94:     /**
 95:      * Like search but filters by status based on the user's profile
 96:      */
 97:     public function searchWithStatusFilter() {
 98:         // Warning: Please modify the following code to remove attributes that
 99:         // should not be searched.
100: 
101:         $criteria=new CDbCriteria;
102: 
103:         // $criteria->compare('status', '<>Program Manager investigation');
104: 
105:         foreach($this->getFields(true) as $fieldName => $field) {
106: 
107:             if($fieldName == 'status') { // if status exists
108:                 // filter statuses based on user's profile
109:                 $hideStatus = CJSON::decode(Yii::app()->params->profile->hideBugsWithStatus); // get a list of statuses the user wants to hide
110:                 if(!$hideStatus) {
111:                     $hideStatus = array();
112:                 }
113:                 foreach($hideStatus as $hide) {
114:                     $criteria->compare('t.status', '<>'.$hide);
115:                 }
116:             }
117:         }
118: 
119:         return $this->searchBase($criteria);
120:     }
121: 
122: }
123: