PHP CActiveDataProvider::getTotalItemCount方法代码示例

 public function testCountCriteria()
 {
     // 1
     $dataProvider = new CActiveDataProvider('Post', array('criteria' => array('condition' => 'content LIKE "%content%"', 'order' => 'create_time DESC', 'with' => array('author')), 'pagination' => array('pageSize' => 5)));
     $this->assertSame($dataProvider->countCriteria, $dataProvider->criteria);
     $this->assertEquals(5, $dataProvider->getTotalItemCount(true));
     // 2
     $dataProvider->setCountCriteria(array('condition' => 'content LIKE "%content 1%"'));
     $this->assertNotSame($dataProvider->countCriteria, $dataProvider->criteria);
     $this->assertEquals(1, $dataProvider->getTotalItemCount(true));
     // 3
     $dataProvider->setCountCriteria(array('condition' => 'content LIKE "%content%"'));
     $this->assertNotSame($dataProvider->countCriteria, $dataProvider->criteria);
     $this->assertEquals(5, $dataProvider->getTotalItemCount(true));
 }

 protected function runAjax()
 {
     /** @var \CClientScript; */
     $cs = Yii::app()->clientscript;
     $result = ['data' => $this->createDataArray()];
     $result['recordsTotal'] = intval($this->dataProvider->getTotalItemCount());
     $result['recordsFiltered'] = $this->filteredCount();
     $result['draw'] = Yii::app()->request->getParam('draw');
     if (isset($cs->scripts[$cs::POS_READY])) {
         $result['scripts'] = implode(" ", $cs->scripts[$cs::POS_READY]);
     }
     // Add filter values.
     $model = $this->dataProvider->model;
     $baseCriteria = $model->getDbCriteria();
     $result['filterData'] = [];
     /** @var \CDataColumn $column */
     foreach ($this->columns as $column) {
         if (isset($column->filter)) {
             switch ($column->filter) {
                 case "select":
                 case "select-strict":
                     $values = [];
                     // Get all values for this column.
                     $criteria = clone $this->dataProvider->countCriteria;
                     $criteria->distinct = true;
                     $criteria->select = $column->name;
                     foreach ($model->cache(120)->findAll($criteria) as $instance) {
                         $values[$instance->{$column->name}] = ["key" => $instance->{$column->name}, "value" => isset($column->value) ? $column->evaluateExpression($column->value, ['data' => $instance, 'row' => -1]) : $instance->{$column->name}];
                     }
                     usort($values, function ($a, $b) {
                         return strcasecmp($a['value'], $b['value']);
                     });
                     $result['filterData'][$column->name] = $values;
                     break;
                 case "select-month":
                     $values = [];
                     // Get all values for this column.
                     $criteria = clone $this->dataProvider->countCriteria;
                     $criteria->distinct = true;
                     $criteria->select = $column->name;
                     //                            $criteria->limit = -1;
                     //                              $command = App()->db->schema->commandBuilder->createFindCommand($model->tableName(), $criteria);
                     //                            $values = $command->queryColumn();
                     foreach ($model->findAll($criteria) as $dateModel) {
                         /** @var \DateTime $date */
                         $date = $dateModel->{$column->name};
                         $key = $date->format("Y-m");
                         $values[$key] = ["key" => $key, "value" => \Yii::app()->dateFormatter->format("MMMM yyyy", $date)];
                     }
                     krsort($values);
                     $result['filterData'][$column->name] = array_values($values);
                     break;
                 default:
             }
         }
     }
     $model->setDbCriteria($baseCriteria);
     header("Content-Type: application/json");
     echo json_encode($result, JSON_PRETTY_PRINT);
 }

 /**
  * 查看推荐记录
  */
 public function actionShowrecommended()
 {
     //echo time();die;
     //if ($_POST){var_dump($_POST);die;}
     //获取表单参数
     $CompanyName = Yii::app()->request->getParam("CompanyName");
     $MobPhone = Yii::app()->request->getParam("MobPhone");
     $Email = Yii::app()->request->getParam("Email");
     $Month = Yii::app()->request->getParam("Month");
     $RecomMethod = Yii::app()->request->getParam("RecomMethod");
     $MemberStatus = Yii::app()->request->getParam("MemberStatus");
     //设置页面标题
     $this->pageTitle = Yii::app()->name . ' - ' . "推荐记录";
     $organID = Yii::app()->user->getOrganID();
     //查询语句
     $sql = 't.RecomStatus=1 and t.OrganID= ' . $organID;
     if (!empty($CompanyName)) {
         //机构名称
         $sql .= " and t.CompanyName like '%" . $CompanyName . "%'";
     }
     if (!empty($MobPhone)) {
         //手机
         $sql .= " and t.MobPhone like '%" . $MobPhone . "%'";
     }
     if (!empty($Email)) {
         //邮箱
         $sql .= " and t.Email like '%" . $Email . "%'";
     }
     if (!empty($Month)) {
         //几月前
         $sql .= " and record.RecomTime>(UNIX_TIMESTAMP(NOW())-{$Month}*30*24*60*60)";
     }
     if (!empty($RecomMethod)) {
         //推荐方式
         $sql .= " and record.RecomMethod = '{$RecomMethod}'";
     }
     if (!empty($MemberStatus)) {
         //会员状态
         $sql .= " and record.MemberStatus = " . $MemberStatus;
     }
     $criteria = new CDbCriteria();
     $criteria->select = "*";
     $criteria->with = 'record';
     $criteria->condition = $sql;
     $dataProvider = new CActiveDataProvider('RecommendList', array('criteria' => $criteria, 'pagination' => array('pageSize' => '10')));
     $data = $dataProvider->getData();
     //无法传值到表单中    暂时用PayStatus字段保存收益
     foreach ($data as $key => $value) {
         if ($value['CompanyType'] == 1) {
             $value['CompanyType'] = '生产商';
         } elseif ($value['CompanyType'] == 2) {
             $value['CompanyType'] = '经销商';
         } else {
             $value['CompanyType'] = '服务店';
         }
     }
     $count = $dataProvider->getTotalItemCount();
     //count($recmlistes);
     $this->render('showrecommended', array('dataProvider' => $dataProvider, 'count' => $count));
 }

 /**
  * 手机客户端的分页，防止分页重复，与网页显示无关
  * @param  CActiveDataProvider $dataProvider
  *
  */
 public function page(CActiveDataProvider &$dataProvider, $more = true)
 {
     $total = $dataProvider->getTotalItemCount();
     $pageSzie = $dataProvider->getPagination()->getPageSize();
     $dataProvider->getPagination()->pageVar = 'page';
     $pageCount = ceil($total / $pageSzie);
     if ($dataProvider->getTotalItemCount() == 0) {
         $this->send(ERROR_EMPTY, 'data empty', $more);
     } else {
         if (isset($_GET['page'])) {
             if ($pageCount >= $_GET['page']) {
                 $this->send(0, $dataProvider->getData(), $more, array('page' => $pageCount));
             }
         } else {
             $this->send(ERROR_NONE, $dataProvider->getData(), $more, array('page' => $pageCount));
         }
     }
 }

 /**
  * Renders the browse view and caluclates required values for the
  * roller (image roll at the page top).
  */
 public function actionBrowse()
 {
     // the browse view requires information on the basket contents
     $testBasket = Yii::app()->user->getState('basketContents');
     if (!isset($testBasket)) {
         Yii::app()->user->setState('basketContents', array());
     }
     // the user can't access ?r=image/browse without the offset value set
     if (!isset($_GET['browseOffset'])) {
         $this->redirect(array('search'));
     }
     $currentlyviewedrow = $_GET['browseOffset'];
     // if someone tries to manually enter an invalid number, negative, it's set to 0
     if ($currentlyviewedrow < 0) {
         $currentlyviewedrow = 0;
     }
     // next and prev variables set.
     $next = $currentlyviewedrow + 1;
     $prev = $currentlyviewedrow - 1;
     $rollCriteria = Yii::app()->user->getState('imagesearchcriteria');
     $rollCriteria->offset = $currentlyviewedrow - 4;
     if ($currentlyviewedrow < 5) {
         $rollCriteria->limit = $currentlyviewedrow + 5;
     } else {
         $rollCriteria->limit = 9;
     }
     $rollDataProvider = new CActiveDataProvider('Image', array('criteria' => $rollCriteria, 'Pagination' => false));
     $totalAmount = $rollDataProvider->getTotalItemCount();
     $this->render('browse', array('rollDataProvider' => $rollDataProvider, 'browseOffset' => $currentlyviewedrow, 'next' => $next, 'prev' => $prev, 'totalAmount' => $totalAmount));
 }

 /**
  * Generates an array of links for the VCR controls based on the specified dataprovider and 
  * current ID
  * @param CActiveDataProvider $dataProvider the data provider of the most recent gridview
  * @param Integer $id the ID of the current record
  * @return Array array of VCR links and stats
  */
 public static function getVcrLinks(&$dataProvider, $modelId)
 {
     $criteria = $dataProvider->criteria;
     $tableSchema = X2Model::model($dataProvider->modelClass)->getTableSchema();
     if ($tableSchema === null) {
         return false;
     }
     // for the first query, find the current ID's row number in the list
     $criteria->select = 't.id';
     // we also need any columns that are being used in the sort
     foreach (explode(',', $criteria->order) as $token) {
         // so loop through $criteria->order and extract them
         $token = preg_replace('/\\s|asc|desc/i', '', $token);
         if ($token !== '' && $token !== 'id' && $token != 't.id') {
             if (strpos($token, '.') != 1) {
                 $criteria->select .= ',t.' . $token;
             } else {
                 $criteria->select .= ',' . $token;
             }
         }
     }
     // always include "id DESC" in sorting (for order consistency with SmartDataProvider)
     if (!preg_match('/\\bid\\b/', $criteria->order)) {
         if (!empty($criteria->order)) {
             $criteria->order .= ',';
         }
         $criteria->order .= 't.id DESC';
     }
     // get search conditions (WHERE, JOIN, ORDER BY, etc) from the criteria
     $searchConditions = Yii::app()->db->getCommandBuilder()->createFindCommand($tableSchema, $criteria)->getText();
     /*
      * VCR Button Row Number Selection Query
      * 
      * This complicated block of code defines where a record is in the row
      * set to determine its position for VCR controls. This relies on SQL
      * variables and incrementing the variable in each row of the result set
      * from the subquery. A version of this query in plain MySQL looks like:
      * SELECT r-1 
      *   FROM (
      *       SELECT *,@rownum:=@rownum + 1 AS r 
      *       FROM ('.$searchConditions.') t1, (SELECT @rownum:=0) r) t2 
      *   WHERE t2.id='.$modelId
      */
     $varPrefix = '@';
     //Current prefix is MySQL specific
     $varName = $varPrefix . 'rownum';
     $varText = 'SET ' . $varName . ' = 0';
     // Current declaration is MySQL specific
     Yii::app()->db->createCommand()->setText($varText)->execute();
     $subQuery = Yii::app()->db->createCommand()->select('*, (' . $varName . ':=' . $varName . '+1) r')->from('(' . $searchConditions . ') t1')->getText();
     $rowNumberQuery = Yii::app()->db->createCommand()->select('(r-1)')->from('(' . $subQuery . ') t2')->where('t2.id=:t2_id');
     //        $rowNumberQuery = Yii::app()->db->createCommand('
     //            SELECT r-1
     //            FROM (
     //                SELECT *,@rownum:=@rownum + 1 AS r
     //                FROM ('.$searchConditions.') t1, (SELECT @rownum:=0) r) t2
     //            WHERE t2.id='.$modelId
     //        );
     // attach params from $criteria to this query
     $rowNumberQuery->params = array_merge(array(':t2_id' => $modelId), $criteria->params);
     $rowNumber = $rowNumberQuery->queryScalar();
     if ($rowNumber === false) {
         // the specified record isn't in this list
         return false;
     } else {
         $criteria->select = '*';
         // need to select everything to be sure ORDER BY will work
         if ($rowNumber == 0) {
             // if we're on the first row, get 2 items, otherwise get 3
             $criteria->offset = 0;
             $criteria->limit = 2;
             $vcrIndex = 0;
         } else {
             $criteria->offset = $rowNumber - 1;
             $criteria->limit = 3;
             $vcrIndex = 1;
             // index of current record in $vcrModels
         }
         $vcrModels = Yii::app()->db->getCommandBuilder()->createFindCommand($tableSchema, $criteria)->queryAll();
         $count = $dataProvider->getTotalItemCount();
         $vcrData = array();
         $vcrData['index'] = $rowNumber + 1;
         $vcrData['count'] = $dataProvider->getTotalItemCount();
         /* if($vcrIndex > 0)		// there's a record before the current one
                       $vcrData['prev'] = '<li class="prev">'.CHtml::link('<',array('view/'.$vcrModels[0]['id']),array('title'=>$vcrModels[0]['name'],'class'=>'x2-button')).'</li>';
                       else
                       $vcrData['prev'] = '<li class="prev">'.CHtml::link('<','javascript:void(0);',array('class'=>'x2-button disabled')).'</li>';
         
                       if(count($vcrModels) - 1 > $vcrIndex)	// there's a record after the current one
                       $vcrData['next'] = '<li class="next">'.CHtml::link('>', array('view/'.$vcrModels[$vcrIndex+1]['id']), array('title'=>$vcrModels[$vcrIndex+1]['name'],'class'=>'x2-button')).'</li>';
                       else
                       $vcrData['next'] = '<li class="next">'.CHtml::link('>','javascript:void(0);',array('class'=>'x2-button disabled')).'</li>';
                      */
//.........这里部分代码省略.........

 /**
  * Returns the total number of data items.
  * When {@link pagination} is set false, this returns the same value as {@link itemCount}.
  * @param boolean $refresh whether the total number of data items should be re-calculated.
  * @return integer total number of possible data items.
  */
 public function getTotalItemCount($refresh = false)
 {
     /* x2modstart */
     if ($this->calculateChecksum && $refresh) {
         throw new CException('refresh cannot be called if calculcateChecksum is set to true');
     }
     /* x2modend */
     return parent::getTotalItemCount($refresh);
 }

                break;
            case 1:
                echo '筹资成功';
                break;
            case 2:
                echo '筹资失败';
                break;
            default:
                echo '筹资中';
        }
        ?>
                            </td>
                        </tr>
                        <?php 
    }
    $totalpages = ceil($dataProvider->getTotalItemCount() / 20);
    ?>
                    <tr><td colspan=9>
                            <div class="text-center">
                                <ul id="pagination-memerlog" class="pagination-sm"></ul>
                            </div>
                        </td>
                <script type="text/javascript">
                    $('#pagination-memerlog').twbsPagination({
                        totalPages: <?php 
    echo $totalpages;
    ?>
,
                        visiblePages: <?php 
    echo $totalpages >= 5 ? 5 : $totalpages;
    ?>

 /**
  * 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;
 }

 public function actionJqgriddata()
 {
     $rowsCount = $_GET['rows'] == 0 ? 10 : $_GET['rows'];
     $page = $_GET['page'] == 0 ? 1 : $_GET['page'];
     $dataProvider = new CActiveDataProvider('WotPlayer', array('pagination' => array('pageSize' => $rowsCount, 'currentPage' => $page - 1)));
     $responce->page = $page;
     $responce->records = $dataProvider->getTotalItemCount();
     $responce->total = ceil($responce->records / $rowsCount);
     $rows = $dataProvider->getData();
     foreach ($rows as $i => $row) {
         $responce->rows[$i]['id'] = $row->getPrimaryKey();
         $responce->rows[$i]['cell'] = array($row->player_id, $row->player_name);
     }
     echo json_encode($responce);
 }

 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->together = true;
     $criteria->with = array('usuario');
     $criteria->compare('itens_id', $this->itens_id);
     $criteria->compare('itens_titulo', $this->itens_titulo, true);
     $criteria->compare('itens_descricao', $this->itens_descricao, true);
     $criteria->compare('itens_excluido', $this->itens_excluido);
     $criteria->compare('itens_dt_criacao', $this->itens_dt_criacao, true);
     $criteria->compare('itens_dt_modificacao', $this->itens_dt_modificacao, true);
     $criteria->compare('itens_destaque', $this->itens_destaque, true);
     $criteria->compare('itens_atividade', $this->itens_atividade);
     $criteria->compare('itens_cnae', $this->itens_cnae);
     $criteria->compare('itens_uf', $this->itens_uf, true);
     $criteria->compare('itens_cidade', $this->itens_cidade, true);
     //$criteria->compare('itens_preco',$this->itens_preco,true);
     //$criteria->compare('itens_receita_anual',$this->itens_receita_anual,true);
     //$criteria->compare('itens_ebitda',$this->itens_ebitda,true);
     //$criteria->compare('itens_resultado_operacional',$this->itens_resultado_operacional,true);
     $criteria->compare('itens_fluxo_de_caixa', $this->itens_fluxo_de_caixa, true);
     $criteria->compare('itens_destaque_detalhes', $this->itens_destaque_detalhes, true);
     $criteria->compare('itens_localizacao', $this->itens_localizacao, true);
     $criteria->compare('itens_fundacao', $this->itens_fundacao, true);
     $criteria->compare('itens_tipo', $this->itens_tipo, true);
     $criteria->compare('itens_funcionarios', $this->itens_funcionarios, true);
     $criteria->compare('itens_area_total', $this->itens_area_total, true);
     $criteria->compare('itens_area_total_locavel', $this->itens_area_total_locavel, true);
     $criteria->compare('itens_unidades', $this->itens_unidades, true);
     $criteria->compare('itens_incluso_na_venda', $this->itens_incluso_na_venda, true);
     $criteria->compare('itens_curiosidades', $this->itens_curiosidades, true);
     $criteria->compare('itens_financas', $this->itens_financas, true);
     $criteria->compare('itens_receita_total', $this->itens_receita_total, true);
     $tipo_usuario = Yii::app()->user->getState(Yii::app()->params['user_session_usuario_tipo']);
     $tipo_usuario = $tipo_usuario[Yii::app()->params['user_session_usuario_tipo']];
     $id_usuario = Yii::app()->user->getState(Yii::app()->params['user_session_usuario_id']);
     $id_usuario = $id_usuario[Yii::app()->params['user_session_usuario_id']];
     /* se for meus negócios */
     if (Yii::app()->controller->id == 'meusnegocios') {
         $criteria->compare('usuario.usuario_id', $id_usuario);
     } else {
         $criteria->compare('usuario_id', $this->usuario_id);
     }
     $this->pg_size = Yii::app()->params['listPerPage'];
     /* se vier do front página negócios a venda */
     if (Yii::app()->controller->id == 'negociosavenda') {
         $criteria->compare('itens_excluido', 'S');
         /* Por default carrega somente os destaques */
         if (!isset($_GET['buscar']) && !isset($_POST['buscar'])) {
             $criteria->compare('itens_destaque', 'S');
             $this->pg_size = Yii::app()->params['listPerPageDestaque'];
             //$criteria->order=new CDbExpression('RAND()');
         }
         $this->compararPrecos($criteria);
     }
     //$criteria->addBetweenCondition('itens_receita_anual', 200, 400, 'AND');
     $sort = new CSort();
     $sort->defaultOrder = !isset($_GET['buscar']) && !isset($_POST['buscar']) && Yii::app()->controller->id != 'meusnegocios' && Yii::app()->controller->id != 'negocios' ? 'RANDOM()' : array('itens_id' => true);
     /* retorna o total de registros */
     $mActive = new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => $sort));
     $this->totReg = !isset($_GET['buscar']) && !isset($_POST['buscar']) && Yii::app()->controller->id != 'meusnegocios' && Yii::app()->controller->id != 'negocios' ? $this->pg_size : $mActive->getTotalItemCount();
     return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => $sort, 'pagination' => array('pageSize' => $this->pg_size), 'totalItemCount' => $this->totReg));
 }

    /**
     * This is the default 'index' action that is invoked
     * when an action is not explicitly requested by users.
     */
    public function actionIndex($selector = 'all')
    {
        // renders the view file 'protected/views/site/index.php'
        // using the default layout 'protected/views/layouts/main.php'

        $criteria= new CDbCriteria;
        $criteria->alias = 'course';
        $criteria->order = 'rating DESC';
        if ($selector !== 'all'){
            if ($selector == 'junior'){
                $criteria->addInCondition('level', array('intern','strong junior','junior'));
            } else {
                $criteria->condition = 'level=:level';
                $criteria->params = array(':level'=>$selector);
            }
        }

        $dataProvider = new CActiveDataProvider('Course', array(
            'criteria' => $criteria,
            'Pagination'=>false,
        ));

        $total = $dataProvider->getTotalItemCount();
        $count1 =round($total/2);
        $count2 = $total - $count1;

        $this->render('index', array(

            'dataProvider' => $dataProvider,
            'count1' => $count1,
            'count2' => $count2,
        ));
    }