Hi,
I created a search engine that uses multiple tables:
private function listDataprovider($filtro, $q, $cidade){
$unionAll = array();
$selectCid = CadastrarCidades::model()->findByPk((int)$cidade,'status=1');
foreach($filtro as $model =>$consulta){
$consulta['params'][':cidade']=$selectCid->nome_cidade;
$consulta['params'][':q']=$q;
$consulta = $model::model()->findAll($consulta);
foreach ($consulta as $linha => $coluna) {
$unionAll[] = array(
'id'=>$coluna->id,
'perfil'=>$coluna->SearPerfil,
);
}
}
/* $unioAll =array(
array('id'=>1, 'username'=>'from', 'email'=>'array'),
array('id'=>2, 'username'=>'test 2', 'email'=>'hello@example.com'),
);*/
$dataProvider= new CArrayDataProvider($unionAll, array(
'sort'=>array(
'attributes'=>array(
'id','perfil'
),
),
'pagination'=> array(
'pageSize'=>20,
),
));
return $dataProvider;
}
but pagination not working, the sistem limit in 20 elements:
<?php
$this->widget('zii.widgets.CListView', array(
'dataProvider' => $dataProvider,
'itemView' => '_resultadolista',
/*'viewData' => array( 'perfils' => array('')), */
'ajaxUpdate'=>false,
'enablePagination'=>false,
'pagerCssClass' => 'result-list',
'template'=>'{items}<div class="row">{pager}</div>',
'pager' => array(
'class' => 'CLinkPager',
//'cssFile' => Yii::app()->baseUrl . "/themes/flat/css/paginacao.css",
'header' => '',
'firstPageLabel' => '<<',
'prevPageLabel' => '<',
'nextPageLabel' => '>',
'lastPageLabel' => '>>',
'maxButtonCount' => 5 // defalut 10
),
'emptyText'=>'Nenhum resultado encontrado por esta pesquisa',
'summaryText' => '{start} - {end} de {count}'
));
?>
In firebug no displays errors, and in html displays hidden tag:
<div title="/guiafacilbrasil/index.php?r=Resultado&buscar=maria+&cidade=12&filtro_cat=geral" style="display:none" class="keys"><span>43</span><span>44</span><span>45</span><span>47</span><span>108</span><span>114</span><span>118</span><span>140</span><span>168</span><span>169</span><span>170</span><span>171</span><span>172</span><span>173</span><span>174</span><span>198</span><span>207</span><span>209</span><span>212</span><span>229</span></div>
I update 1.1.15 to Yii 1.1.16
In changelog Version 1.1.16 December 21, 2014
- Bug #2658: CBaseListView, CGridView, CListView: added note about $itemsCssClass and $pagerCssClass properties, they must not contain empty string, null or false values (resurtm)
I not understend becouse the sistem not generate errors!
