public function listAction() { if ($this->getRequest()->isXmlHttpRequest()) { $id_slownika = $this->getEvent()->getRouteMatch()->getParam('id_slownika'); $aSlownik = \My\Tools\Lista::ListaWhere('import_slo', 'id', $id_slownika); if ($aSlownik['column_list'] != '') { $aSlownikListAvailable = explode(',', $aSlownik['column_list']); } else { $aSlownikListAvailable = array(); } $aColumnNameSlo = explode(',', $aSlownik['column_mapping_list']); $aMetadata = \My\Tools\Lista::Kolumny($aSlownik['nazwa']); $aHeadFilter = array(); $i = 0; foreach ($aMetadata as $iKey => $column) { if (in_array($column->getName(), $aSlownikListAvailable) || empty($aSlownikListAvailable)) { $aHead[$iKey]['name'] = $aColumnNameSlo[$i]; $aHead[$iKey]['width'] = '*'; $aHead[$iKey]['type'] = 'ro'; $aHead[$iKey]['align'] = 'left'; $aHead[$iKey]['sort'] = ''; $aHeadFilter[$iKey] = '#select_filter'; $i++; } } $iCount = (int) $this->params()->fromQuery('count', 10); $iStart = (int) $this->params()->fromQuery('posStart', 0); $iPage = round($iStart / $iCount, 0, PHP_ROUND_HALF_UP) + 1; // $aHead['filter'] = $aHeadFilter; //$aHead['paging'] = '<div id="paging_slowniki" style="top:0px; left:-10px;border:0;width:101%;height:100%;margin: 0px; padding: 0px;" xmlns="http://www.w3.org/1999/html"><br><br></div>'; $aData = \My\Tools\Lista::ListaWszystkieKolumnyLimit($aSlownik['nazwa']); // $aDataLimit = \My\Tools\Lista::ListaWszystkieKolumnyLimit($aSlownik['nazwa'],$iCount,$iStart); $oMyGrid = new \My\Dhtmlx\Grid($aData, 'id', '', $aHead); //$oMyGrid->setPagingGrid($iStart, count($aData)); $xml = $oMyGrid->createXml(); $this->getResponse()->getHeaders()->addHeaders(array('Content-type' => 'text/xml')); return $this->getResponse()->setContent($xml); } }