PHP CActiveDataProvider::setPagination方法代码示例

 protected function createDataArray()
 {
     \Yii::beginProfile('createDataArray');
     $data = [];
     Yii::beginProfile('getData');
     if (!$this->config['serverSide']) {
         $paginator = $this->dataProvider->getPagination();
         if ($this->dataProvider instanceof \CActiveDataProvider) {
             $this->dataProvider->criteria->order = '';
         }
         $this->dataProvider->setPagination(false);
         $source = $this->dataProvider->getData(true);
         $this->dataProvider->setPagination($paginator);
     } else {
         $source = $this->dataProvider->getData();
     }
     Yii::endProfile('getData');
     Yii::beginProfile('renderCells');
     // Get column name map.
     $names = array_map([$this, 'getColumnName'], $this->columns);
     foreach ($source as $i => $r) {
         $row = [];
         foreach ($this->columns as $j => $column) {
             $name = $names[$j];
             $row[$name] = $column->getDataCellContent($i);
         }
         $metaRow = [];
         if ($this->addMetaData !== false) {
             Yii::beginProfile('addMetaData');
             if (is_callable([$r, 'getKeyString'])) {
                 $metaRow['data-key'] = call_user_func([$r, 'getKeyString']);
             }
             if (is_array($this->addMetaData)) {
                 foreach ($this->addMetaData as $field) {
                     $metaRow["data-{$field}"] = \CHtml::value($r, $field);
                 }
             }
             Yii::endProfile('addMetaData');
         }
         if (isset($this->rowCssClassExpression)) {
             $metaRow['class'] = $this->evaluateExpression($this->rowCssClassExpression, array('row' => $i, 'data' => $r));
         }
         $row['metaData'] = $metaRow;
         $data[] = $row;
     }
     \Yii::endProfile('renderCells');
     \Yii::endProfile('createDataArray');
     return $data;
 }

 public function actionGridProduct()
 {
     $search = null;
     $criteria = new CDbCriteria();
     if (!empty($_POST)) {
         $search = Util::input($_POST['search']);
         $criteria->condition = "\n        product_code LIKE(:search)\n        OR product_name LIKE(:search)\n      ";
         $criteria->params = array('search' => '%' . $search . '%');
     }
     $product = new Product();
     $model = new CActiveDataProvider($product, array('sort' => array('defaultOrder' => 'product_id DESC')));
     $pagination = new CPagination();
     $pagination->setPageSize(40);
     $model->setPagination($pagination);
     $model->setCriteria($criteria);
     $this->render('//Dialog/GridProduct', array('model' => $model));
 }

 /**
  * Lists all notes.
  */
 public function actionIndex()
 {
     $model = new Note('search');
     if (isset($_GET['Note'])) {
         $model->attributes = $_GET['Note'];
         $dataProvider = $model->search();
     } else {
         $dataProvider = new CActiveDataProvider('Note', array('criteria' => array('order' => 'upload_timestamp DESC')));
     }
     $dataProvider->setPagination(array('pageSize' => 16));
     $students = Student::model()->findAll();
     $usernames = array();
     foreach ($students as $student) {
         $usernames[] = $student->username;
     }
     $this->render('index', array('model' => $model, 'dataProvider' => $dataProvider, 'usernames' => $usernames));
 }

    public function actionIndex($id){
        $this->initialize($id);
        $editMode = $this->checkEditMode($id, Yii::app()->user->getId());

        $lecture = Lecture::model()->findByPk($id);

        $criteria = new CDbCriteria();
        $criteria->addCondition('id_lecture='.$id);

        $dataProvider = new CActiveDataProvider('LectureElement');
        $dataProvider->criteria = $criteria;
        $criteria->order = 'block_order ASC';
        $dataProvider->setPagination(array(
                'pageSize' => '200',
            )
        );

        $owners = [];

        $criteria1 = new CDbCriteria();
        $criteria1->alias='teacher_module';
        $criteria1->select = 'idTeacher';
        $criteria1->addCondition('idModule='.$lecture->idModule);
        $criteria1->toArray();
        $temp = TeacherModule::model()->findAll($criteria1); //info about owners
        for($i = 0; $i < count($temp);$i++){
            array_push($owners, $temp[$i]->idTeacher);
        }
        $teachers = Teacher::model()->findAllByPk($owners);

        $countBlocks = LectureElement::model()->count('id_lecture = :id', array(':id' => $id));

        $this->render('index', array(
            'dataProvider' => $dataProvider,
            'lecture' => $lecture,
            'editMode' => $editMode,
            'countBlocks' => $countBlocks,
            'teachers' => $teachers,
        ));
    }

    public function actionIndex()
	{
        $model = new Permissions('search');
        if(isset($_GET['Permissions']))
            $model->attributes=$_GET['Permissions'];

		$dataProvider = new CActiveDataProvider('Permissions');

        $dataProvider->setPagination(array(
                'pageSize' => '50',
            )
        );

        if(!isset($_GET['ajax'])) $this->render('index', array(
            'dataProvider' => $dataProvider,
            'model' => $model,
        ));
        else  $this->renderPartial('index', array(
            'dataProvider' => $dataProvider,
            'model' => $model,
        ));
	}

 /**
  * An AJAX called method to export module data.
  *
  * This method actually prepares all the data via recursive AJAX requests
  * until all data has been exported. This exports each module into the CSV
  * by class, using pagination to cut down on request time.
  *
  * @param string $model The name of the current model being exported
  * @param int $page The page of data which the data provider's paginator is on
  */
 public function actionGlobalExport($model, $page)
 {
     if (class_exists($model)) {
         ini_set('memory_limit', -1);
         $file = $this->safePath();
         $fp = fopen($file, 'a+');
         $tempModel = X2Model::model($model);
         $meta = array_keys($tempModel->attributes);
         $meta[] = $model;
         if ($page == 0) {
             fputcsv($fp, $meta);
         }
         // If we're on the first page for this model, need to add metadata.
         $dp = new CActiveDataProvider($model, array('pagination' => array('pageSize' => 100)));
         $pg = $dp->getPagination();
         $pg->setCurrentPage($page);
         // These two lines will set the data provider
         $dp->setPagination($pg);
         // paginator to the requested page of data
         $records = $dp->getData();
         $pageCount = $dp->getPagination()->getPageCount();
         // Total number of pages
         foreach ($records as $record) {
             // Re-pack all unpacked attributes for writing to a file, so that
             // they can be interpolated as strings:
             foreach ($record->behaviors() as $name => $config) {
                 $behavior = $record->asa($name);
                 if ($behavior instanceof TransformedFieldStorageBehavior) {
                     $behavior->packAll();
                     $record->disableBehavior($name);
                 }
             }
             $tempAttributes = $tempModel->attributes;
             $tempAttributes = array_merge($tempAttributes, $record->attributes);
             if ($model == 'Profile') {
                 $tempAttributes['theme'] = json_encode($record->theme);
             }
             $tempAttributes[] = $model;
             fputcsv($fp, $tempAttributes);
             // Export the data to CSV
         }
         unset($tempModel, $dp);
         fclose($fp);
         if ($page + 1 < $pageCount) {
             echo $page + 1;
             // If there are still more pages to go, echo the next page number
         }
     }
 }

 /**
  * Get list items
  * array returned consists of array(list_item_name_code => list_item_name, ...)
  * @param $list_code
  * @param bool $dropdown_array_source
  * @return array
  */
 public function getItemsForListCode($list_code, $dropdown_array_source = false)
 {
     $dataProvider = new CActiveDataProvider('SystemList', array('criteria' => array('condition' => "system_list_code = '" . $list_code . "' AND system_list_item_active = 1", 'order' => 'system_list_item_order ASC')));
     if ($dropdown_array_source) {
         $arr = array();
         $dataProvider->setPagination(false);
         $data = $dataProvider->getData();
         foreach ($data as $item) {
             $arr[$item->system_list_item_code] = $item->system_list_item_name;
         }
         return $arr;
     }
     // to get list of object
     $dataProvider->setPagination(false);
     return $dataProvider->getData();
 }

 /**
  * Based on requested return type, return the data
  * 
  * @param CActiveDataProvider $dataProvider
  * @param mixed $return_type
  */
 function getResultsBasedForReturnType($dataProvider, $return_type = self::LB_QUERY_RETURN_TYPE_ACTIVE_DATA_PROVIDER)
 {
     switch ($return_type) {
         case self::LB_QUERY_RETURN_TYPE_ACTIVE_DATA_PROVIDER:
             return $dataProvider;
         case self::LB_QUERY_RETURN_TYPE_MODELS_ARRAY:
             $dataProvider->setPagination(false);
             return $dataProvider->getData();
         case self::LB_QUERY_RETURN_TYPE_DATASOURCE_JSON:
             return $this->getResultsAsDatasourceJSON($dataProvider);
         case self::LB_QUERY_RETURN_TYPE_DROPDOWN_ARRAY:
             return $this->getResultsAsDropDownArray($dataProvider);
         default:
             return $dataProvider;
     }
 }

 public function actionRecargasIngresadas()
 {
     $model = new Recarga('search');
     $model->unsetAttributes();
     $criteria = new CDbCriteria(array('condition' => 'usuario_id =:usuario_id', 'order' => 'id DESC', 'limit' => 500, 'params' => array(':usuario_id' => 1)));
     $model = Recarga::model()->findAll($criteria);
     $dataProvider = new CActiveDataProvider('Recarga', array('criteria' => $criteria));
     $dataProvider->setPagination(false);
     //FIN CONSULTA
     $this->render('recargas_ingresadas', array('dataProvider' => $dataProvider, 'model' => $model));
 }

 /**
  * 
  * @param unknown $account_id
  * @param string $get_data
  * @return <multitype: array,CActiveDataProvider>
  */
 public function getInvitesToAccount($account_id, $get_data = false)
 {
     $account = Account::model()->findByPk($account_id);
     $dataProvider = new CActiveDataProvider('AccountInvitation', array('criteria' => array('condition' => "account_invitation_to_email = '{$account->account_email}'")));
     if ($get_data === true) {
         $dataProvider->setPagination(false);
         return $dataProvider->getData();
     }
     return $dataProvider;
 }

 public function getItemsList($list_code)
 {
     $dataProvider = new CActiveDataProvider('UserList', array('criteria' => array('condition' => "system_list_code = '" . $list_code . "'", 'order' => 'system_list_item_order ASC')));
     $dataProvider->setPagination(false);
     return $dataProvider->getData();
 }

 /**
  * Retrieves a list of all models.
  * @return CActiveDataProvider.
  */
 public function getAll()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $dp = new CActiveDataProvider(get_class($this), array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'date ASC')));
     $dp->setPagination(array('pageSize' => $dp->getTotalItemCount()));
     return $dp;
 }

 /**
  * Return list of all the members of other teams that this account belongs to.
  * This is used for team that this account is NOT the master account of that team.
  * 
  * @param unknown $account_id
  */
 public function getMyOtherTeams($account_id, $subscription_id)
 {
     // get all master accounts that I'm member of
     //		$members = AccountTeamMember::model()->findAll('member_account_id = :account_id',
     //				array(":account_id" => $account_id));
     //		$master_accounts_ids = array(0);
     //		foreach($members as $mem)
     //		{
     //			$master_accounts_ids[] = $mem->master_account_id;
     //		}
     //		$master_accounts_ids_str = implode(',', $master_accounts_ids);
     // get all members of these master accounts
     $dataProvider = new CActiveDataProvider('AccountTeamMember', array('criteria' => array('condition' => "account_subscription_id = {$subscription_id} AND member_account_id = {$account_id}", 'order' => 'master_account_id DESC', 'with' => array('member_account'))));
     $dataProvider->setPagination(false);
     return $dataProvider;
 }

 /**
  * Lists all models.
  */
 public function actionIndex()
 {
     $criteria = new CDbCriteria(array('condition' => 'status=' . Post::STATUS_PUBLISHED, 'order' => 'update_time ASC', 'with' => array('commentCount', 'category')));
     if (isset($_GET['tag'])) {
         $criteria->addSearchCondition('tags', $_GET['tag']);
     } elseif (isset($_GET['cat'])) {
         $criteria->addCondition(array('category.url = :url'));
         $criteria->params = array(':url' => $_GET['cat']);
     } else {
         $criteria->mergeWith(array('order' => 'update_time DESC', 'limit' => 7));
     }
     $dataProvider = new CActiveDataProvider('Post', array('pagination' => array('pageSize' => Yii::app()->params['postsPerPage'], 'pageVar' => "page"), 'criteria' => $criteria));
     if (!isset($_GET['tag']) && !isset($_GET['cat'])) {
         $dataProvider->setPagination(false);
     }
     $this->render('index', array('dataProvider' => $dataProvider));
 }

 /**
  * @return Advertisement[]
  */
 protected function loadAdvertisement()
 {
     $dataProvider = new CActiveDataProvider('Advertisement', array('criteria' => array('order' => '`order` ASC, id ASC', 'offset' => $this->offset, 'limit' => $this->limit)));
     $dataProvider->setPagination(false);
     return $dataProvider->getData();
 }