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