/**
* 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;
}
}
/** Update a Kloster entity
**/
public function updateAction()
{
// Update Kloster
if ($this->request->hasArgument('uUID')) {
$uuid = $this->request->getArgument('uUID');
}
if (empty($uuid)) {
$this->throwStatus(400, 'Required uUID not provided', null);
}
$kloster = $this->klosterRepository->findByIdentifier($uuid);
if (!is_object($kloster)) {
$this->throwStatus(400, 'Entity Kloster not available', null);
}
$bearbeitungsstatus_uuid = $this->request->getArgument('bearbeitungsstatus');
$bearbeitungsstatus = $this->bearbeitungsstatusRepository->findByIdentifier($bearbeitungsstatus_uuid);
$role = array_keys($this->securityContext->getAccount()->getRoles())[0];
if (trim($role) == 'Flow.Login:Hiwi') {
if (is_object($bearbeitungsstatus)) {
$bearbeitungsstatusName = $bearbeitungsstatus->getName();
}
if (isset($bearbeitungsstatusName) && !empty($bearbeitungsstatusName)) {
if (trim($bearbeitungsstatusName) == 'Online') {
$this->throwStatus(400, 'You are not allowed to set a Kloster entry online', null);
}
}
}
$kloster->setKloster($this->request->getArgument('kloster_name'));
$kloster->setPatrozinium($this->request->getArgument('patrozinium'));
$kloster->setBemerkung($this->request->getArgument('bemerkung'));
$kloster->setBand_seite($this->request->getArgument('band_seite'));
$kloster->setText_gs_band($this->request->getArgument('text_gs_band'));
$kloster->setBearbeitungsstand($this->request->getArgument('bearbeitungsstand'));
$kloster->setBearbeitungsstatus($bearbeitungsstatus);
$bearbeiter = $this->bearbeiterObj;
$kloster->setBearbeiter($bearbeiter);
if ($this->request->hasArgument('band')) {
$band_uuid = $this->request->getArgument('band');
$band = $this->bandRepository->findByIdentifier($band_uuid);
$kloster->setBand($band);
}
$this->klosterRepository->update($kloster);
// Update Klosterstandort
if ($this->request->hasArgument('ort')) {
$ortArr = $this->request->getArgument('ort');
}
if ($this->request->hasArgument('bistum')) {
$bistumArr = $this->request->getArgument('bistum');
}
$gruenderArr = $this->request->getArgument('gruender');
$breiteArr = $this->request->getArgument('breite');
$laengeArr = $this->request->getArgument('laenge');
$bemerkung_standortArr = $this->request->getArgument('bemerkung_standort');
$bemerkungArr = $this->request->getArgument('standort_interne_bemerkung');
$von_vonArr = $this->request->getArgument('von_von');
$von_bisArr = $this->request->getArgument('von_bis');
$von_verbalArr = $this->request->getArgument('von_verbal');
$bis_vonArr = $this->request->getArgument('bis_von');
$bis_bisArr = $this->request->getArgument('bis_bis');
$bis_verbalArr = $this->request->getArgument('bis_verbal');
if ($this->request->hasArgument('wuestung')) {
$wuestungArr = $this->request->getArgument('wuestung');
}
$klosterstandortNumber = count($ortArr);
$klosterstandortArr = [];
for ($i = 0; $i < $klosterstandortNumber; $i++) {
$klosterstandortArr[$i]['kloster'] = $uuid;
if (!empty($ortArr[$i])) {
$klosterstandortArr[$i]['ort'] = $ortArr[$i];
}
if (!empty($bistumArr[$i])) {
$klosterstandortArr[$i]['bistum'] = $bistumArr[$i];
}
$klosterstandortArr[$i]['gruender'] = $gruenderArr[$i];
$klosterstandortArr[$i]['breite'] = $breiteArr[$i];
$klosterstandortArr[$i]['laenge'] = $laengeArr[$i];
$klosterstandortArr[$i]['bemerkung_standort'] = $bemerkung_standortArr[$i];
$klosterstandortArr[$i]['bemerkung'] = $bemerkungArr[$i];
$klosterstandortArr[$i]['von_von'] = $von_vonArr[$i];
$klosterstandortArr[$i]['von_bis'] = $von_bisArr[$i];
$klosterstandortArr[$i]['von_verbal'] = $von_verbalArr[$i];
$klosterstandortArr[$i]['bis_von'] = $bis_vonArr[$i];
$klosterstandortArr[$i]['bis_bis'] = $bis_bisArr[$i];
$klosterstandortArr[$i]['bis_verbal'] = $bis_verbalArr[$i];
if (isset($wuestungArr[$i]) && !empty($wuestungArr[$i])) {
$klosterstandortArr[$i]['wuestung'] = 1;
} else {
$klosterstandortArr[$i]['wuestung'] = 0;
}
}
if (isset($klosterstandortArr) && !empty($klosterstandortArr) && is_array($klosterstandortArr)) {
$klosterstandorts = $kloster->getKlosterstandorts();
foreach ($klosterstandorts as $i => $klosterstandort) {
$this->klosterstandortRepository->remove($klosterstandort);
}
$lastKlosterstandortId = $this->getLastKlosterstandortIdAction();
foreach ($klosterstandortArr as $ko) {
$klosterstandort = new Klosterstandort();
$kloster_uuid = $ko['kloster'];
$kloster = $this->klosterRepository->findByIdentifier($kloster_uuid);
$klosterstandort->setUid(++$lastKlosterstandortId);
$klosterstandort->setKloster($kloster);
if (!empty($ko['ort'])) {
$ort_uuid = $ko['ort'];
$ort = $this->ortRepository->findByIdentifier($ort_uuid);
$klosterstandort->setOrt($ort);
}
$klosterstandort->setGruender($ko['gruender']);
$klosterstandort->setBreite($ko['breite']);
$klosterstandort->setLaenge($ko['laenge']);
$klosterstandort->setVon_von($ko['von_von']);
$klosterstandort->setVon_bis($ko['von_bis']);
$klosterstandort->setVon_verbal($ko['von_verbal']);
$klosterstandort->setBis_von($ko['bis_von']);
$klosterstandort->setBis_bis($ko['bis_bis']);
$klosterstandort->setBis_verbal($ko['bis_verbal']);
$klosterstandort->setBemerkung_standort($ko['bemerkung_standort']);
$klosterstandort->setBemerkung($ko['bemerkung']);
$this->klosterstandortRepository->add($klosterstandort);
if (isset($ort) && is_object($ort)) {
$ort->setWuestung($ko['wuestung']);
}
if (!empty($ko['bistum'])) {
$bistumObject = $this->bistumRepository->findByIdentifier($ko['bistum']);
if (is_object($bistumObject) && isset($ort) && is_object($ort)) {
$ort->setBistum($bistumObject);
}
}
if (isset($ort) && is_object($ort)) {
$this->ortRepository->update($ort);
}
}
}
// Update Orden
$ordenArr = $this->request->getArgument('orden');
$klosterstatusArr = $this->request->getArgument('klosterstatus');
$bemerkung_ordenArr = $this->request->getArgument('bemerkung_orden');
$orden_von_vonArr = $this->request->getArgument('orden_von_von');
$orden_von_bisArr = $this->request->getArgument('orden_von_bis');
$orden_von_verbalArr = $this->request->getArgument('orden_von_verbal');
$orden_bis_vonArr = $this->request->getArgument('orden_bis_von');
$orden_bis_bisArr = $this->request->getArgument('orden_bis_bis');
$orden_bis_verbalArr = $this->request->getArgument('orden_bis_verbal');
$klosterordenNumber = count($ordenArr);
$klosterordenArr = [];
for ($i = 0; $i < $klosterordenNumber; $i++) {
$klosterordenArr[$i]['kloster'] = $uuid;
$klosterordenArr[$i]['orden'] = $ordenArr[$i];
$klosterordenArr[$i]['klosterstatus'] = $klosterstatusArr[$i];
$klosterordenArr[$i]['bemerkung_orden'] = $bemerkung_ordenArr[$i];
$klosterordenArr[$i]['orden_von_von'] = $orden_von_vonArr[$i];
$klosterordenArr[$i]['orden_von_bis'] = $orden_von_bisArr[$i];
$klosterordenArr[$i]['orden_von_verbal'] = $orden_von_verbalArr[$i];
$klosterordenArr[$i]['orden_bis_von'] = $orden_bis_vonArr[$i];
$klosterordenArr[$i]['orden_bis_bis'] = $orden_bis_bisArr[$i];
$klosterordenArr[$i]['orden_bis_verbal'] = $orden_bis_verbalArr[$i];
}
if (isset($klosterordenArr) && !empty($klosterordenArr) && is_array($klosterordenArr)) {
$klosterordens = $kloster->getKlosterordens();
foreach ($klosterordens as $i => $klosterorden) {
$this->klosterordenRepository->remove($klosterorden);
}
$lastKlosterordentId = $this->getLastKlosterordenIdAction();
foreach ($klosterordenArr as $ko) {
$klosterorden = new Klosterorden();
$kloster_uuid = $ko['kloster'];
$kloster = $this->klosterRepository->findByIdentifier($kloster_uuid);
$klosterorden->setUid(++$lastKlosterordentId);
$klosterorden->setKloster($kloster);
$klosterorden->setVon_von($ko['orden_von_von']);
$klosterorden->setVon_bis($ko['orden_von_bis']);
$klosterorden->setVon_verbal($ko['orden_von_verbal']);
$klosterorden->setBis_von($ko['orden_bis_von']);
$klosterorden->setBis_bis($ko['orden_bis_bis']);
$klosterorden->setBis_verbal($ko['orden_bis_verbal']);
$orden_uuid = $ko['orden'];
$orden = $this->ordenRepository->findByIdentifier($orden_uuid);
$klosterorden->setOrden($orden);
$klosterstatus_uuid = $ko['klosterstatus'];
$klosterstatus = $this->klosterstatusRepository->findByIdentifier($klosterstatus_uuid);
$klosterorden->setKlosterstatus($klosterstatus);
$klosterorden->setBemerkung($ko['bemerkung_orden']);
$this->klosterordenRepository->add($klosterorden);
}
}
// Update literatur
$literaturs = $kloster->getKlosterHasLiteraturs();
if (!empty($literaturs)) {
foreach ($literaturs as $literatur) {
$this->klosterHasLiteraturRepository->remove($literatur);
}
}
if ($this->request->hasArgument('literatur')) {
$literaturArr = $this->request->getArgument('literatur');
if ($this->request->hasArgument('fundstelle')) {
$fundstelleArr = $this->request->getArgument('fundstelle');
}
if (isset($literaturArr) && !empty($literaturArr) && is_array($literaturArr)) {
foreach ($literaturArr as $k => $lit) {
if (isset($lit) && !empty($lit)) {
$lit = trim($lit);
$fundstelle = trim($fundstelleArr[$k]);
if (!empty($fundstelle)) {
$literatur = $this->literaturRepository->findByProperties(['citekey' => $lit, 'beschreibung' => $fundstelle]);
if (count($literatur) > 0) {
$litUUID = $literatur->getFirst()->getUUID();
if (!empty($litUUID)) {
$literatur = $this->literaturRepository->findByIdentifier($litUUID);
}
} else {
$literatur = new Literatur();
$literatur->setCitekey($lit);
$literatur->setBeschreibung($fundstelle);
$this->literaturRepository->add($literatur);
$litUUID = $literatur->getUUID();
}
if (is_object($kloster) && is_object($literatur)) {
$klosterHasLiteratur = new KlosterHasLiteratur();
$klosterHasLiteratur->setKloster($kloster);
$klosterHasLiteratur->setLiteratur($literatur);
$this->klosterHasLiteraturRepository->add($klosterHasLiteratur);
}
}
}
}
}
}
// Fetch Kloster Urls
$klosterHasUrls = $kloster->getKlosterHasUrls();
$klosterHasGND = false;
// Update GND if set
if ($this->request->hasArgument('gnd')) {
$gnd = $this->request->getArgument('gnd');
if ($this->request->hasArgument('gnd_label')) {
$gnd_label = $this->request->getArgument('gnd_label');
}
if (empty($gnd_label)) {
$gndid = str_replace('http://d-nb.info/gnd/', '', trim($gnd));
$gnd_label = $kloster . ' [' . $gndid . ']';
}
if (isset($gnd) && !empty($gnd)) {
foreach ($klosterHasUrls as $i => $klosterHasUrl) {
$urlObj = $klosterHasUrl->getUrl();
$urlTypObj = $urlObj->getUrltyp();
if (is_object($urlTypObj)) {
$urlTyp = $urlTypObj->getName();
if ($urlTyp == "GND") {
$urlObj->setUrl($gnd);
if (!empty($gnd_label)) {
$urlObj->setBemerkung($gnd_label);
}
$this->urlRepository->update($urlObj);
$klosterHasGND = true;
}
}
}
if (!$klosterHasGND) {
$url = new Url();
$url->setUrl($gnd);
if (!empty($gnd_label)) {
$url->setBemerkung($gnd_label);
}
$urlTypObj = $this->urltypRepository->findOneByName('GND');
$url->setUrltyp($urlTypObj);
$this->urlRepository->add($url);
$urlUUID = $url->getUUID();
$urlObj = $this->urlRepository->findByIdentifier($urlUUID);
$klosterhasurl = new KlosterHasUrl();
$klosterhasurl->setKloster($kloster);
$klosterhasurl->setUrl($urlObj);
$this->klosterHasUrlRepository->add($klosterhasurl);
}
}
}
//Update Wikipedia if set
$klosterHasWiki = false;
if ($this->request->hasArgument('wikipedia')) {
$wikipedia = $this->request->getArgument('wikipedia');
if ($this->request->hasArgument('wikipedia_label')) {
$wikipedia_label = $this->request->getArgument('wikipedia_label');
}
if (empty($wikipedia_label)) {
$wikipedia_label = str_replace('http://de.wikipedia.org/wiki/', '', trim($wikipedia));
$wikipedia_label = str_replace('_', ' ', $wikipedia_label);
$wikipedia_label = rawurldecode($wikipedia_label);
}
if (isset($wikipedia) && !empty($wikipedia)) {
foreach ($klosterHasUrls as $i => $klosterHasUrl) {
$urlObj = $klosterHasUrl->getUrl();
$url = $urlObj->getUrl();
$urlTypObj = $urlObj->getUrltyp();
if (is_object($urlTypObj)) {
$urlTyp = $urlTypObj->getName();
if ($urlTyp == "Wikipedia") {
$urlObj->setUrl($wikipedia);
if (!empty($wikipedia_label)) {
$urlObj->setBemerkung($wikipedia_label);
}
$this->urlRepository->update($urlObj);
$klosterHasWiki = true;
}
}
}
if (!$klosterHasWiki) {
$url = new Url();
$url->setUrl($wikipedia);
if (!empty($wikipedia_label)) {
$url->setBemerkung($wikipedia_label);
}
$urlTypObj = $this->urltypRepository->findOneByName('Wikipedia');
$url->setUrltyp($urlTypObj);
$this->urlRepository->add($url);
$urlUUID = $url->getUUID();
$urlObj = $this->urlRepository->findByIdentifier($urlUUID);
$klosterhasurl = new KlosterHasUrl();
$klosterhasurl->setKloster($kloster);
$klosterhasurl->setUrl($urlObj);
$this->klosterHasUrlRepository->add($klosterhasurl);
}
}
}
// Add Url if set
if ($this->request->hasArgument('url')) {
$urlArr = $this->request->getArgument('url');
if (isset($urlArr) && !empty($urlArr)) {
if ($this->request->hasArgument('url_typ')) {
$urlTypArr = $this->request->getArgument('url_typ');
}
if ($this->request->hasArgument('links_label')) {
$linksLabelArr = $this->request->getArgument('links_label');
}
if (isset($klosterHasUrls) && $klosterHasUrls !== []) {
foreach ($klosterHasUrls as $i => $klosterHasUrl) {
$urlObj = $klosterHasUrl->getUrl();
$urlTypObj = $urlObj->getUrltyp();
if (is_object($urlTypObj)) {
$urlTyp = $urlTypObj->getName();
}
if (isset($urlTyp) && ($urlTyp != "Wikipedia" && $urlTyp != "GND")) {
$this->klosterHasUrlRepository->remove($klosterHasUrl);
$this->urlRepository->remove($urlObj);
}
}
}
foreach ($urlArr as $k => $url) {
if (!empty($url)) {
$urlObj = new Url();
$urlObj->setUrl($url);
if (isset($urlTypArr[$k]) && !empty($urlTypArr[$k])) {
$urlTypObj = $this->urltypRepository->findByIdentifier($urlTypArr[$k]);
$urlTyp = $urlTypObj->getName();
$urlObj->setUrltyp($urlTypObj);
}
if (isset($linksLabelArr[$k]) && !empty($linksLabelArr[$k])) {
$urlObj->setBemerkung($linksLabelArr[$k]);
} else {
$urlObj->setBemerkung($urlTyp);
}
$this->urlRepository->add($urlObj);
$klosterhasurlObj = new KlosterHasUrl();
$klosterhasurlObj->setKloster($kloster);
$klosterhasurlObj->setUrl($urlObj);
$this->klosterHasUrlRepository->add($klosterhasurlObj);
}
}
}
}
$this->throwStatus(200, null, null);
}