/** * * 改进:使用延迟绑定,将这个函数写在父类里面 *返回某个用户所发布的所有计划列表 * @return CActiveDataProvider $dataProvider 返回CActiveDataProvider对象 * 使用attach的好处是随时绑定,不一定在初始化的时候绑定 */ public function getDataProvider(CFormModel &$condition) { $this->attachBehaviors(array('NearScopeBehavior' => array('class' => 'ext.behavior.NearScopeBehavior', 'latitude' => $condition->latitude, 'longitude' => $condition->longitude))); $dataProvider = new CActiveDataProvider(Plan::model()->unexpired()->near()->with('user'), array('pagination' => array('pageSize' => 20))); $dataProvider->setCriteria($this->addCondition($condition)); return $dataProvider; }
public function actionIndex() { $criteria = new CDbCriteria(); $relationComponent = new RelationComponent(); $friends = $relationComponent->getfriends(); $criteria->addInCondition('userId', $friends); $criteria->order = 'photoId DESC'; $dataProvider = new CActiveDataProvider('Photo', array('pagination' => array('pageSize' => 20))); $dataProvider->setCriteria($criteria); $this->page($dataProvider); $this->render('index'); }
public function actionAdmin() { $title = Yii::app()->request->getParam('title', false); $criteria = new CDbCriteria(); $criteria->order = 'id desc'; if ($title) { $criteria->compare('title', $title, true); } $dataProvider = new CActiveDataProvider('DreamApp'); $dataProvider->setCriteria($criteria); $this->render('admin', array('title' => $title, 'dataProvider' => $dataProvider)); }
/** * 返回某个关系的列表。应该按照用户名的大小写来排序,但是这里暂时成了按照注册日期来排序的! * @param $type 填写四个:friends,follows,fans,blacks * @return CActiveDataProvider 返回CActiveDataProvider对象 */ public function getList($type) { $relationComponent = new RelationComponent(); $function = 'get' . $type; $list = $relationComponent->{$function}(); $criteria = new CDbCriteria(); $criteria->addInCondition('t.userId', $list); $criteria->order = 't.userId desc'; $dataProvider = new CActiveDataProvider(User::model(), array('pagination' => array('pageSize' => 20))); $dataProvider->setCriteria($criteria); return $dataProvider; }
public function actionAdmin() { $type = Yii::app()->request->getParam('type', false); $title = Yii::app()->request->getParam('title', false); $criteria = new CDbCriteria(); $criteria->with = 'task'; $criteria->order = 't.id desc'; if ($type) { $criteria->condition = 'push_type =:push_type'; $criteria->params = array(':push_type' => $type); } if ($title) { $criteria->compare('task.app_name', $title, true); } $dataProvider = new CActiveDataProvider('DreamPushTask'); $dataProvider->setCriteria($criteria); $this->render('admin', array('type' => $type, 'title' => $title, 'dataProvider' => $dataProvider)); }
function actionDialogUser() { $model = new CActiveDataProvider('User', array('pagination' => array('pageSize' => 20))); if (!empty($_POST)) { $search = Util::input($_POST['search']); $criteria = new CDbCriteria(); $criteria->compare('user_name', $search, true, 'OR'); $criteria->compare('user_tel', $search, true, 'OR'); $model->setCriteria($criteria); } $this->render('//Dialog/DialogUser', array('model' => $model)); }
public function actionAdmin() { $title = Yii::app()->request->getParam('title', false); $criteria = new CDbCriteria(); $criteria->order = 'id desc'; if ($title) { $criteria->compare('app_name', $title, true); } else { $criteria->condition = 'show_flag != :show_flag'; $criteria->params = array(':show_flag' => 0); } $dataProvider = new CActiveDataProvider('DreamAdPackage'); $dataProvider->setCriteria($criteria); $this->render('admin', array('title' => $title, 'dataProvider' => $dataProvider)); }
public function actionRepair() { $this->checkLogin(); $params = @$_POST; if (!empty($_POST)) { // search $search = Util::input($_POST['search_code']); if (empty($search)) { $search = Util::input($_GET['serial_code']); } // productSerial $productSerial = ProductSerial::model()->findByAttributes(array('serial_no' => $search)); if (!empty($productSerial)) { $product = Product::model()->findByAttributes(array('product_code' => $productSerial->product_code)); $params['product'] = $product; $params['productSerial'] = $productSerial; } // repair history $criteria = new CDbCriteria(); $criteria->compare('serial_no', Util::input($_POST['search_code'])); $criteria->order = 'repair_id DESC'; $repairs = new CActiveDataProvider('Repair'); $repairs->setCriteria($criteria); $params['repairs'] = $repairs; } $this->render('//Basic/Repair', $params); }
/** * * 改进:使用延迟绑定,将这个函数写在父类里面 *返回某个用户所发布的所有计划列表 * * @return CActiveDataProvider $dataProvider 返回CActiveDataProvider对象 */ public function getDataProvider(CFormModel &$condition) { $dataProvider = new CActiveDataProvider(User::model()->near(), array('pagination' => array('pageSize' => 20))); $dataProvider->setCriteria($this->addCondition($condition)); return $dataProvider; }
/** * * 改进:使用延迟绑定,将这个函数写在父类里面 *返回某个用户所发布的所有计划列表 * 主页默认显示的是只在本地的。 * * * @return CActiveDataProvider $dataProvider 返回CActiveDataProvider对象 */ public function getDataProvider(CFormModel &$condition) { // $e= array_filter($condition->attributes); $model = Plan::model()->unexpired()->near(); if (empty($condition->location)) { $model = $model->local()->with(array('user', 'state')); } else { $model = $model->startThis()->with(array('user', 'state')); } $model = $model->with(array('user', 'state')); $dataProvider = new CActiveDataProvider($model, array('pagination' => array('pageSize' => 20))); $dataProvider->setCriteria($this->search($condition)); return $dataProvider; }
CHtml::link($data->refersTo->public_id(), array("useCase/view","id"=>$data->refers_to)) : null'), array('class' => 'CDataColumn', 'name' => 'Primary Actor', 'type' => 'html', 'value' => '$data->primaryActor->description'), 'order', array('class' => 'CButtonColumn', 'buttons' => array('view' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/view/$data->primaryKey")'), 'update' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/update/$data->primaryKey")'), 'delete' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/delete/$data->primaryKey")')))))); echo "<h3>Inlude</h3>"; echo CHtml::link("Add new Event to Include Scenario", array("useCaseEvent/create", "uc" => $model->id_use_case, "cat" => "4")); $criteria = new CDbCriteria(); $criteria->condition = "use_case = {$model->id_use_case} AND category = 4"; $criteria->order = "`order`"; $events = UseCaseEvent::model()->with('category0', 'useCase', 'primaryActor')->findAll($criteria); $dataProvider = new CActiveDataProvider('UseCaseEvent', array('pagination' => array('pageSize' => 20))); $dataProvider->setCriteria($criteria); $this->widget('zii.widgets.grid.CGridView', array('dataProvider' => $dataProvider, 'columns' => array('id_event', array('class' => 'CDataColumn', 'name' => 'category', 'type' => 'html', 'value' => '$data->category0->name'), 'description', array('class' => 'CDataColumn', 'name' => 'Refers To', 'type' => 'html', 'value' => 'isset($data->refersTo) ? CHtml::link($data->refersTo->public_id(), array("useCase/view","id"=>$data->refers_to)) : null'), array('class' => 'CDataColumn', 'name' => 'Primary Actor', 'type' => 'html', 'value' => '$data->primaryActor->description'), 'order', array('class' => 'CButtonColumn', 'buttons' => array('view' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/view/$data->primaryKey")'), 'update' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/update/$data->primaryKey")'), 'delete' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/delete/$data->primaryKey")')))))); echo "<h3>Alternate</h3>"; echo CHtml::link("Add new Event to Alternate Scenario", array("useCaseEvent/create", "uc" => $model->id_use_case, "cat" => "2")); $criteria = new CDbCriteria(); $criteria->condition = "use_case = {$model->id_use_case} AND category = 2"; $criteria->order = "`order`"; $events = UseCaseEvent::model()->with('category0', 'useCase', 'primaryActor')->findAll($criteria); $dataProvider = new CActiveDataProvider('UseCaseEvent', array('pagination' => array('pageSize' => 20))); $dataProvider->setCriteria($criteria); $this->widget('zii.widgets.grid.CGridView', array('dataProvider' => $dataProvider, 'columns' => array('id_event', array('class' => 'CDataColumn', 'name' => 'category', 'type' => 'html', 'value' => '$data->category0->name'), 'description', array('class' => 'CDataColumn', 'name' => 'Refers To', 'type' => 'html', 'value' => 'isset($data->refersTo) ? CHtml::link($data->refersTo->public_id(), array("useCase/view","id"=>$data->refers_to)) : null'), array('class' => 'CDataColumn', 'name' => 'Primary Actor', 'type' => 'html', 'value' => '$data->primaryActor->description'), 'order', array('class' => 'CButtonColumn', 'buttons' => array('view' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/view/$data->primaryKey")'), 'update' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/update/$data->primaryKey")'), 'delete' => array('url' => '$this->grid->controller->createUrl("/useCaseEvent/delete/$data->primaryKey")')))))); echo CHtml::image(CHtml::normalizeUrl(array('imagesvg', 'id' => $model->id_use_case)), ''); ?>
/** * Lists all models. */ public function actionIndex() { $dataProvider = new CActiveDataProvider('Pedido'); if (Yii::app()->user->checkAccess('cliente')) { $dataProvider->setCriteria(array('condition' => 'IdCliente=:id', 'params' => array(':id' => Yii::app()->user->id))); } $this->render('index', array('dataProvider' => $dataProvider)); }