/** * List of all Ort entities */ public function listAction() { if ($this->request->getFormat() === 'json') { $this->view->setVariablesToRender(['ort']); } $searchArr = []; if ($this->request->hasArgument('columns')) { $columns = $this->request->getArgument('columns'); foreach ($columns as $column) { if (!empty($column['data']) && !empty($column['search']['value'])) { $searchArr[$column['data']] = $column['search']['value']; } } } if ($this->request->hasArgument('order')) { $order = $this->request->getArgument('order'); if (!empty($order)) { $orderDir = $order[0]['dir']; $orderById = $order[0]['column']; if (!empty($orderById)) { $columns = $this->request->getArgument('columns'); $orderBy = $columns[$orderById]['data']; } } } if ($this->request->hasArgument('draw')) { $draw = $this->request->getArgument('draw'); } else { $draw = 0; } $start = $this->request->hasArgument('start') ? $this->request->getArgument('start') : self::start; $length = $this->request->hasArgument('length') ? $this->request->getArgument('length') : self::length; if (empty($searchArr)) { if (isset($orderBy) && !empty($orderBy) && (isset($orderDir) && !empty($orderDir))) { if ($orderDir === 'asc') { $orderArr = [$orderBy => \TYPO3\Flow\Persistence\QueryInterface::ORDER_ASCENDING]; } elseif ($orderDir === 'desc') { $orderArr = [$orderBy => \TYPO3\Flow\Persistence\QueryInterface::ORDER_DESCENDING]; } } if (isset($orderArr) && !empty($orderArr)) { $orderings = $orderArr; } else { $orderings = ['ort' => \TYPO3\Flow\Persistence\QueryInterface::ORDER_ASCENDING]; } $orts = $this->ortRepository->getCertainNumberOfOrt($start, $length, $orderings); $recordsTotal = $this->ortRepository->getNumberOfEntries(); } else { if (isset($orderBy) && !empty($orderBy) && (isset($orderDir) && !empty($orderDir))) { if ($orderDir === 'asc') { $orderArr = [$orderBy, 'ASC']; } elseif ($orderDir === 'desc') { $orderArr = [$orderBy, 'DESC']; } } if (isset($orderArr) && !empty($orderArr)) { $orderings = $orderArr; } else { $orderings = ['ort', 'ASC']; } $orts = $this->ortRepository->searchCertainNumberOfOrt($start, $length, $orderings, $searchArr, 1); $recordsFiltered = $this->ortRepository->searchCertainNumberOfOrt($start, $length, $orderings, $searchArr, 2); $recordsTotal = $this->ortRepository->getNumberOfEntries(); } if (!isset($recordsFiltered)) { $recordsFiltered = $recordsTotal; } $ortArr = []; foreach ($orts as $k => $ort) { if (is_object($ort)) { $uUID = $ort->getUUID(); if (!empty($uUID)) { $ortArr[$k]['uUID'] = $uUID; } else { $ortArr[$k]['uUID'] = ''; } $ortName = $ort->getOrt(); if (!empty($ortName)) { $ortArr[$k]['ort'] = $ortName; } else { $ortArr[$k]['ort'] = ''; } $gemeinde = $ort->getGemeinde(); if (!empty($gemeinde)) { $ortArr[$k]['gemeinde'] = $gemeinde; } else { $ortArr[$k]['gemeinde'] = ''; } $kreis = $ort->getKreis(); if (!empty($kreis)) { $ortArr[$k]['kreis'] = $kreis; } else { $ortArr[$k]['kreis'] = ''; } $wuestung = $ort->getWuestung(); if (!empty($wuestung)) { $ortArr[$k]['wuestung'] = $wuestung; } else { $ortArr[$k]['wuestung'] = ''; } $breite = $ort->getBreite(); if (!empty($breite)) { $ortArr[$k]['breite'] = $breite; } else { $ortArr[$k]['breite'] = ''; } $laenge = $ort->getLaenge(); if (!empty($laenge)) { $ortArr[$k]['laenge'] = $laenge; } else { $ortArr[$k]['laenge'] = ''; } $bistumObj = $ort->getBistum(); if (is_object($bistumObj)) { $bistum = $bistumObj->getUUID(); if (!empty($bistum)) { $ortArr[$k]['bistum'] = $bistum; } else { $ortArr[$k]['bistum'] = ''; } } else { $ortArr[$k]['bistum'] = ''; } } } $this->view->assign('ort', ['data' => $ortArr, 'draw' => $draw, 'recordsTotal' => $recordsTotal, 'recordsFiltered' => $recordsFiltered]); $this->view->assign('bearbeiter', $this->bearbeiterObj->getBearbeiter()); return $this->view->render(); }