/** * Delete an Orden entity */ public function deleteAction() { if ($this->request->hasArgument('uUID')) { $uuid = $this->request->getArgument('uUID'); } if (empty($uuid)) { $this->throwStatus(400, 'Required uUID not provided', null); } $klosterordens = count($this->klosterordenRepository->findByOrden($uuid)); $ordenhasurls = count($this->ordenHasUrlRepository->findByOrden($uuid)); if ($klosterordens == 0 && $ordenhasurls == 0) { $ordenObj = $this->ordenRepository->findByIdentifier($uuid); if (!is_object($ordenObj)) { $this->throwStatus(400, 'Entity Orden not available', null); } $this->ordenRepository->remove($ordenObj); // Fetch Orden Urls $ordenHasUrls = $ordenObj->getOrdenHasUrls(); if (is_array($ordenHasUrls)) { foreach ($ordenHasUrls as $ordenHasUrl) { $this->ordenHasUrlRepository->remove($ordenHasUrl); } } $this->throwStatus(200, null, null); } else { $this->throwStatus(400, 'Due to dependencies Orden entity could not be deleted', null); } }
/** * @return int $lastKlosterordenId The last insert id */ public function getLastKlosterordenIdAction() { $result = $this->klosterordenRepository->findLastEntry(); foreach ($result as $res) { $lastKlosterordenId = $res->getUid(); } return $lastKlosterordenId; }
/** * Import Klosterorden table into the FLOW domain_model tabel subugoe_germaniasacra_domain_klosterorden_band * @return int */ public function importKlosterordenAction() { if ($this->logger) { $start = microtime(true); } /** @var \Doctrine\DBAL\Connection $sqlConnection */ $sqlConnection = $this->entityManager->getConnection(); $sql = 'SELECT * FROM Klosterorden ORDER BY ID_KlosterOrden ASC'; $klosterordens = $sqlConnection->fetchAll($sql); $klosterstatusArr = []; if (isset($klosterordens) and is_array($klosterordens)) { $nKlosterorden = 0; foreach ($klosterordens as $klosterorden) { $uid = $klosterorden['ID_KlosterOrden']; $kloster = $klosterorden['Klosternummer']; $orden = $klosterorden['Orden']; if (isset($kloster) && !empty($kloster) && (isset($orden) && !empty($orden))) { $klosterObject = $this->klosterRepository->findOneByUid($kloster); $ordenObject = $this->ordenRepository->findOneByUid($orden); if (is_object($klosterObject) && $klosterObject !== null && (is_object($ordenObject) && $ordenObject !== null)) { if (!isset($klosterorden['Klosterstatus']) || empty($klosterorden['Klosterstatus'])) { $klosterorden['Klosterstatus'] = "keine Angabe"; } $klosterstatus = $klosterorden['Klosterstatus']; if (!in_array($klosterstatus, $klosterstatusArr)) { array_push($klosterstatusArr, $klosterstatus); $klosterstatusObject = new Klosterstatus(); $klosterstatusObject->setStatus($klosterstatus); $this->klosterstatusRepository->add($klosterstatusObject); $this->persistenceManager->persistAll(); $klosterstatusUUID = $klosterstatusObject->getUUID(); $klosterstatusObject = $this->klosterstatusRepository->findByIdentifier($klosterstatusUUID); } else { $klosterstatusObject = $this->klosterstatusRepository->findOneByStatus($klosterstatus); } $von_von = $klosterorden['von_von']; $von_bis = $klosterorden['von_bis']; $von_verbal = $klosterorden['verbal_von']; $bis_von = $klosterorden['bis_von']; $bis_bis = $klosterorden['bis_bis']; $bis_verbal = $klosterorden['verbal_bis']; $bemerkung = $klosterorden['interne_Anmerkungen']; $klosterordenObject = new Klosterorden(); $klosterordenObject->setUid($uid); $klosterordenObject->setKloster($klosterObject); $klosterordenObject->setOrden($ordenObject); $klosterordenObject->setKlosterstatus($klosterstatusObject); $klosterordenObject->setVon_von($von_von); $klosterordenObject->setVon_bis($von_bis); $klosterordenObject->setVon_verbal($von_verbal); $klosterordenObject->setBis_von($bis_von); $klosterordenObject->setBis_bis($bis_bis); $klosterordenObject->setBis_verbal($bis_verbal); $klosterordenObject->setBemerkung($bemerkung); $this->klosterordenRepository->add($klosterordenObject); $this->persistenceManager->persistAll(); } $nKlosterorden++; } else { if ($klosterObject === null) { $this->importExportLogger->log('Entweder ist das Feld Klosternummer in Klosterordentabelle leer oder das Klosterobject in der Klostertabelle für das Kloster mit der Id = ' . $kloster . ' wurde nicht gefunden.', LOG_ERR); } if ($ordenObject === null) { $this->importExportLogger->log('Entweder ist das Feld Orden in Klosterordentabelle leer oder das Ordenobject in der Ordentabelle für den Orden mit der Id = ' . $orden . ' wurde nicht gefunden.', LOG_ERR); } } } if ($this->logger) { $end = microtime(true); $time = number_format($end - $start, 2); $this->logger->log('Klosterorden import completed in ' . round($time / 60, 2) . ' minutes.'); } return $nKlosterorden; } }