public function actionFindUser($group, $term) { $dataProvider = new CActiveDataProvider('User', array('criteria' => array('select' => array('id', 'email')), 'pagination' => array('pageSize' => 500))); $criteria = $dataProvider->getCriteria(); $criteria->compare('email', $term, true); $result = CHtml::listData($dataProvider->getData(), 'id', 'email'); $members = Yii::app()->db->createCommand()->select('userid')->from(AuthAssignment::model()->tableName())->where('itemname=:group', array(':group' => $group))->queryColumn(); echo CJSON::encode(array_diff_key($result, array_flip($members))); Yii::app()->end(); }
public function getCriteria() { $criteria = parent::getCriteria(); $meta = CActiveRecord::model($this->modelClass)->meta(); // if (isset($meta['lang'])) // { // $criteria->addCondition("lang = '" . Yii::app()->language . "'"); // } return $criteria; }
public function getCriteria() { $criteria = parent::getCriteria(); $class = $this->modelClass; $model = $class::model(); $meta = $model->meta(); if (isset($meta['lang'])) { $criteria->addCondition("lang = '" . Yii::app()->language . "'"); } return $criteria; }
public function actionIndex() { $model = $this->loadModel(); $model->resetScope(); $dataProvider = new CActiveDataProvider($model, array('criteria' => array('with' => array('societe' => array())), 'pagination' => array('pageSize' => 50), 'sort' => array('defaultOrder' => 'societe.name', 'attributes' => array('societe_name' => array('asc' => 'societe.name', 'desc' => 'societe.name DESC'), '*')))); if (null !== ($formData = Yii::app()->request->getParam(get_class($model)))) { Yii::app()->session->offsetSet($this->id . '__filter', $formData); $this->redirect('index'); } $model->setAttributes(Yii::app()->session->offsetGet($this->id . '__filter', array())); $criteria = $dataProvider->getCriteria(); foreach ($model->attributes as $attribute => $value) { if (empty($value)) { continue; } $criteria->compare($attribute, $value); } $this->render('index', array('dataProvider' => $dataProvider, 'model' => $model)); }