PHP ActiveDataProvider::prepare方法代码示例

 public function init()
 {
     if (is_array($this->remap)) {
         $this->isClosure = false;
     } elseif (is_callable($this->remap)) {
         $this->isClosure = true;
     } else {
         throw new ErrorException('remap is wrong type!.');
     }
     //init dataProvider
     $this->dataProvider->prepare();
     return parent::init();
 }

 /**
  * Lists all MyClick models.
  * @return mixed
  */
 public function actionIndex()
 {
     $query = (new \yii\db\Query())->select('article.*')->from('my_click')->where(['user_id' => \Yii::$app->user->id])->orderBy('my_click.id DESC');
     $click_query = $query->limit(50)->join('LEFT JOIN', 'article', 'article.id = my_click.article_id');
     $provide = new ActiveDataProvider(['query' => $click_query, 'pagination' => ['pageSize' => 10]]);
     $provide->prepare();
     $pagination = $provide->getPagination();
     return $this->render('index', ['data' => $provide->getModels(), 'pageCount' => $pagination->pageCount, 'page' => $pagination->page, 'links' => $pagination->getLinks()]);
 }

 public function actionIndex()
 {
     if (\Yii::$app->user->isGuest) {
         $this->redirect(['user/sign-in/login']);
     }
     $article = (new Query())->from('article')->all();
     $query = Article::find();
     $provide = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC, 'title' => 'simon']]]);
     $provide->prepare();
     $pagination = $provide->getPagination();
     return $this->render('index', ['article' => $provide->getModels(), 'pageCount' => $pagination->pageCount, 'page' => $pagination->page, 'links' => $pagination->getLinks()]);
 }

 /**
  * Lists all words.
  * @param string $sort
  * @param string $search
  * @return mixed
  */
 public function actionIndex($sort = null, $search = null)
 {
     $query = Word::find()->userId(Yii::$app->user->id);
     if ($search === null) {
         $query->sort($sort);
     } else {
         $query->search($search);
     }
     $provider = new ActiveDataProvider(['query' => $query, 'sort' => false, 'pagination' => ['pageSize' => Yii::$app->params['wordPerPage']]]);
     $provider->prepare(true);
     return $this->render('index', ['provider' => $provider, 'search' => $search]);
 }

 public function search($params)
 {
     $query = Url::find();
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => []]);
     $this->load($params);
     if (!$this->validate()) {
         return $dataProvider;
     }
     $query->andFilterWhere(['user_id' => $this->user_id]);
     $query->andFilterWhere(['like', 'link', $this->link])->andFilterWhere(['like', 'name', $this->name]);
     $dependency = new \yii\caching\DbDependency(['sql' => 'SELECT MAX(updated_at) FROM url', 'reusable' => true]);
     Yii::$app->db->cache(function ($db) use($dataProvider) {
         $dataProvider->prepare();
     }, Yii::$app->params['cacheExpire'], $dependency);
     return $dataProvider;
 }

 /**
 //     * @param integer|null $category
 * @return array - dataProvider and pagination.
 */
 public function actionCategory()
 {
     // controller->action->id: e.g table-lights
     $categoryID = $this->findCategoryBySlug(\Yii::$app->controller->action->id);
     //        $productsQuery = Product::find();
     //        $productsQuery->joinWith('category');
     //        $productsQuery
     //            ->orFilterWhere(['category.parent_id' => $categoryID])
     //            ->orWhere(['category.id' => $categoryID]);
     $productsQuery = Product::find()->joinWith('category')->orFilterWhere(['category.parent_id' => $categoryID])->orWhere(['category.id' => $categoryID]);
     $dataProvider = new ActiveDataProvider(['query' => $productsQuery, 'pagination' => ['pagesize' => 3]]);
     $dependency = new DbDependency();
     $dependency->sql = 'SELECT count(id) FROM product';
     \Yii::$app->db->cache(function ($db) use($dataProvider) {
         $dataProvider->prepare();
     }, 3600, $dependency);
     return $dataProvider;
 }

 /**
  * Create sitemap files
  * @return array
  */
 public function buildPages()
 {
     /** @var \yii\db\ActiveRecord $owner */
     $owner = $this->owner;
     $query = $owner::find();
     $basePath = $this->module->getFilesPath();
     preg_match('/([A-Za-z]+)$/', get_class($owner), $matchResult);
     $fileSuffix = strtolower($matchResult[0]);
     // Apply scopes
     if (is_callable($this->scope)) {
         call_user_func($this->scope, $query);
     }
     // Build data provider for separated on pages
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => $this->module->perPage, 'pageSizeLimit' => [10, 50000]]]);
     // Build pages
     $pages = [];
     $dataProvider->prepare();
     $pageCount = $dataProvider->pagination->getPageCount();
     for ($page = 0; $page < $pageCount; $page++) {
         $dataProvider->pagination->setPage($page);
         $dataProvider->prepare(true);
         // Processing one page
         $pageUrls = [];
         $n = 0;
         foreach ($dataProvider->getModels() as $model) {
             $urlData = call_user_func($this->dataClosure, $model);
             $pageUrls[$n]['loc'] = $urlData['loc'];
             $pageUrls[$n]['lastmod'] = $urlData['lastmod'];
             if (isset($urlData['changefreq'])) {
                 $pageUrls[$n]['changefreq'] = $urlData['changefreq'];
             } elseif ($this->defaultChangefreq !== false) {
                 $pageUrls[$n]['changefreq'] = $this->defaultChangefreq;
             }
             if (isset($urlData['priority'])) {
                 $pageUrls[$n]['priority'] = $urlData['priority'];
             } elseif ($this->defaultPriority !== false) {
                 $pageUrls[$n]['priority'] = $this->defaultPriority;
             }
             if (isset($urlData['news'])) {
                 $pageUrls[$n]['news'] = $urlData['news'];
             }
             if (isset($urlData['images'])) {
                 $pageUrls[$n]['images'] = $urlData['images'];
             }
             ++$n;
         }
         $xmlData = Yii::$app->view->renderPhpFile($this->module->viewPath . '/default/page-template.php', ['urls' => $pageUrls]);
         $fileUrl = "sitemap_files/{$fileSuffix}_{$page}.xml";
         if (file_put_contents($basePath . '/' . $fileUrl, $xmlData)) {
             $pages[] = ['loc' => $fileUrl, 'lastmod' => time()];
             echo "OK: {$basePath}/{$fileUrl}\n";
         }
     }
     return $pages;
 }

 /**
  * init
  */
 public function init()
 {
     //init dataProvider
     $this->dataProvider->prepare();
     return parent::init();
 }

 /**
  * @param $params
  * @return ActiveDataProvider
  * @throws \yii\base\InvalidConfigException
  */
 public static function getDataProvider($params)
 {
     $query = Post::find()->with('user', 'topic')->orderBy(['created_at' => SORT_ASC]);
     if ($params['topic_id']) {
         $query->andWhere(['topic_id' => $params['topic_id']]);
     }
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['route' => '/topic/default/view', 'params' => ['id' => $params['topic_id'], 'page' => $params['page']], 'forcePageParam' => false, 'pageSizeLimit' => false, 'defaultPageSize' => Yii::$app->config->get('display_posts_count')]]);
     $dataProvider->prepare();
     return $dataProvider;
 }

 /**
  * Вывод в файл
  * @param ActiveDataProvider $dataProvider
  * @param string $sFileName
  * @return boolean
  */
 public function exportToFile($dataProvider, $sFileName)
 {
     $dataProvider->prepare();
     $nMaxCount = $dataProvider->pagination->totalCount;
     $objPHPExcel = new PHPExcel();
     $oSheet = $objPHPExcel->getSheet(0);
     $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_sqlite3;
     $bCache = PHPExcel_Settings::setCacheStorageMethod($cacheMethod);
     $oDefaultStyle = $objPHPExcel->getDefaultStyle();
     $oDefaultStyle->getFont()->setName('Arial');
     $oDefaultStyle->getFont()->setSize(8);
     //        $oSheet->getPageSetup()
     //            ->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT) // ORIENTATION_LANDSCAPE
     //            ->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4)
     //            ->setFitToPage(true)
     //            ->setFitToWidth(1)
     //            ->setFitToHeight(0);
     //
     //        $oSheet->getPageMargins()
     //            ->setTop(0.5)
     //            ->setRight(0.35)
     //            ->setLeft(0.35)
     //            ->setBottom(1);
     //        $oSheet->getHeaderFooter()
     //            ->setEvenFooter('&CСтраница &P [&N]')
     //            ->setOddFooter('&CСтраница &P [&N]');
     $nPageCount = $dataProvider->pagination->pageCount;
     if ($dataProvider->pagination->totalCount > $nMaxCount) {
         $nPageCount = floor($nMaxCount / $dataProvider->pagination->pageSize);
     }
     $cou = 0;
     $nRow = $this->nStartRow;
     foreach ($this->columnWidth as $k => $v) {
         if ($v !== null) {
             $oSheet->getColumnDimension($this->colIndexToName($k + 1))->setWidth($v);
         }
     }
     $sLastCol = $this->colIndexToName(max(count($this->columnWidth), count($this->columnTitles), count($this->columnValues)));
     $n = $nRow;
     $sTit = 'A' . $nRow++;
     $oSheet->setCellValue($sTit, 'Выгрузка от ' . date('d.m.Y H:i'));
     $objPHPExcel->getActiveSheet()->mergeCells($sTit . ':' . $sLastCol . $n);
     $sdataTitle = $this->dataTitle === null ? Yii::$app->name : $this->dataTitle;
     if ($sdataTitle != '') {
         $n = $nRow;
         $sTit = 'A' . $nRow++;
         $oSheet->setCellValue($sTit, $sdataTitle);
         $objPHPExcel->getActiveSheet()->mergeCells($sTit . ':' . $sLastCol . $n);
     }
     if (count($this->columnTitles) > 0) {
         $nRow++;
         $oSheet->fromArray($this->columnTitles, null, 'A' . $nRow++);
     }
     for ($page = 0; $page < $nPageCount; $page++) {
         $dataProvider->pagination->setPage($page);
         $dataProvider->refresh();
         foreach ($dataProvider->getModels() as $model) {
             $aData = [];
             foreach ($this->columnValues as $v) {
                 $aData[] = $v instanceof Closure ? call_user_func($v, $model, $cou) : $model->{$v};
             }
             $oSheet->fromArray($aData, null, 'A' . $nRow);
             $cou++;
             $nRow++;
         }
     }
     $oSheet->getPageSetup()->setPrintArea('A' . $this->nStartRow . ':' . $sLastCol . ($nRow - 1));
     $format = $this->getFileExt($sFileName, 'xls');
     if ($format == 'xls') {
         $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
     } else {
         $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
     }
     $objWriter->save($sFileName);
     return true;
 }