/**
* Update a Band entity
*/
public function updateAction()
{
if ($this->request->hasArgument('uUID')) {
$uuid = $this->request->getArgument('uUID');
}
if (empty($uuid)) {
$this->throwStatus(400, 'Required uUID not provided', null);
}
$bandObj = $this->bandRepository->findByIdentifier($uuid);
if (is_object($bandObj)) {
$bandObj->setNummer($this->request->getArgument('nummer'));
$bandObj->setTitel($this->request->getArgument('titel'));
$bandObj->setKurztitel($this->request->getArgument('kurztitel'));
$bandObj->setSortierung($this->request->getArgument('sortierung'));
if ($this->request->hasArgument('bistum')) {
$bistumUUID = $this->request->getArgument('bistum');
$bistumObj = $this->bistumRepository->findByIdentifier($bistumUUID);
if (is_object($bistumObj)) {
$bandObj->setBistum($bistumObj);
}
}
$this->bandRepository->update($bandObj);
// Fetch Band Urls
$bandHasUrls = $bandObj->getBandHasUrls();
$bandHasGND = 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 = $this->request->getArgument('nummer') . ' [' . $gndid . ']';
}
if (isset($gnd) && !empty($gnd)) {
if (!empty($bandHasUrls)) {
foreach ($bandHasUrls as $i => $bandHasUrl) {
$urlObj = $bandHasUrl->getUrl();
$urlTypObj = $urlObj->getUrltyp();
$urlTyp = $urlTypObj->getName();
if ($urlTyp == "GND") {
$urlObj->setUrl($gnd);
if (!empty($gnd_label)) {
$urlObj->setBemerkung($gnd_label);
}
$this->urlRepository->update($urlObj);
$bandHasGND = true;
}
}
}
if (!$bandHasGND) {
$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);
$bandhasurl = new BandHasUrl();
$bandhasurl->setBand($bandObj);
$bandhasurl->setUrl($urlObj);
$this->bandHasUrlRepository->add($bandhasurl);
}
}
}
//Update Wikipedia if set
$bandHasWiki = 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 ($bandHasUrls as $i => $bandHasUrl) {
$urlObj = $bandHasUrl->getUrl();
$urlTypObj = $urlObj->getUrltyp();
$urlTyp = $urlTypObj->getName();
if ($urlTyp == "Wikipedia") {
$urlObj->setUrl($wikipedia);
if (!empty($wikipedia_label)) {
$urlObj->setBemerkung($wikipedia_label);
}
$this->urlRepository->update($urlObj);
$bandHasWiki = true;
}
}
if (!$bandHasWiki) {
$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);
$bandhasurl = new BandHasUrl();
$bandhasurl->setBand($bandObj);
$bandhasurl->setUrl($urlObj);
$this->bandHasUrlRepository->add($bandhasurl);
}
}
}
// 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($urlArr) && !empty($urlArr) && (isset($urlTypArr) && !empty($urlTypArr))) {
foreach ($bandHasUrls as $i => $bandHasUrl) {
$urlObj = $bandHasUrl->getUrl();
$urlTypObj = $urlObj->getUrltyp();
$urlTyp = $urlTypObj->getName();
if ($urlTyp != "Wikipedia" && $urlTyp != "GND") {
$this->bandHasUrlRepository->remove($bandHasUrl);
$this->urlRepository->remove($urlObj);
}
}
foreach ($urlArr as $k => $url) {
if (!empty($url)) {
$urlObj = new Url();
$urlObj->setUrl($url);
$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);
$bandhasurl = new BandHasUrl();
$bandhasurl->setBand($bandObj);
$bandhasurl->setUrl($urlObj);
$this->bandHasUrlRepository->add($bandhasurl);
}
}
}
}
}
$this->persistenceManager->persistAll();
$this->throwStatus(200, null, null);
} else {
$this->throwStatus(400, 'Entity Band not available', null);
}
}
/**
* Import Orden table into the FLOW domain_model tabel subugoe_germaniasacra_domain_model_orden
* @return int
*/
public function importOrdenAction()
{
if ($this->logger) {
$start = microtime(true);
}
/** @var \Doctrine\DBAL\Connection $sqlConnection */
$sqlConnection = $this->entityManager->getConnection();
$sql = 'SELECT * FROM Orden';
$ordens = $sqlConnection->fetchAll($sql);
$ordenstypArr = [];
if (isset($ordens) and is_array($ordens)) {
$nOrden = 0;
foreach ($ordens as $ordenvalue) {
$uid = $ordenvalue['ID_Ordo'];
$orden = $ordenvalue['Ordensbezeichnung'];
$ordo = $ordenvalue['Ordo'];
$symbol = $ordenvalue['Symbol'];
$graphik = null;
if (isset($ordenvalue['Grafikdatei']) && !empty($ordenvalue['Grafikdatei'])) {
$graphik = $ordenvalue['Grafikdatei'];
}
$ordenstyp = $ordenvalue['Geschlecht'];
$gnd = $ordenvalue['GND_Orden'];
$wikipedia = $ordenvalue['Wikipedia_Orden'];
if (empty($ordenstyp)) {
$ordenstyp = 'unbekannt';
}
if (!in_array($ordenstyp, $ordenstypArr)) {
$ordenstypObject = new Ordenstyp();
$ordenstypObject->setOrdenstyp($ordenstyp);
$this->ordenstypRepository->add($ordenstypObject);
$this->persistenceManager->persistAll();
$ordenstypUUID = $ordenstypObject->getUUID();
}
array_push($ordenstypArr, $ordenstyp);
if (isset($ordenstypUUID) && !empty($ordenstypUUID)) {
$ordenstypObject = $this->ordenstypRepository->findByIdentifier($ordenstypUUID);
} else {
$ordenstypObject = $this->ordenstypRepository->findOneByOrdenstyp($ordenstyp);
}
$ordenObject = new Orden();
$ordenObject->setUid($uid);
$ordenObject->setOrden($orden);
$ordenObject->setOrdo($ordo);
$ordenObject->setSymbol($symbol);
$ordenObject->setGraphik($graphik);
$ordenObject->setOrdenstyp($ordenstypObject);
$this->ordenRepository->add($ordenObject);
$this->persistenceManager->persistAll();
unset($ordenstypUUID);
$ordenUUID = $ordenObject->getUUID();
if (isset($gnd) && !empty($gnd)) {
$gnd = str_replace("\t", " ", $gnd);
$gnd = str_replace("http:// ", " ", $gnd);
$gnd = str_replace(" http", ";http", $gnd);
$gnd = str_replace(";", "#", $gnd);
$gnds = explode("#", $gnd);
if (isset($gnds) && is_array($gnds)) {
$oldgnd = "";
foreach ($gnds as $gnd) {
if (isset($gnd) && !empty($gnd)) {
if ($gnd != $oldgnd) {
$gnd = str_replace(" ", "", $gnd);
$gnd = str_replace("# ", "", $gnd);
$gndid = str_replace("http://d-nb.info/gnd/", "", $gnd);
$gndbemerkung = $orden . " [" . $gndid . "]";
$urlObject = new Url();
$urlObject->setUrl($gnd);
$urlObject->setBemerkung($gndbemerkung);
$gndurltypObject = $this->urltypRepository->findOneByName('GND');
$urlObject->setUrltyp($gndurltypObject);
$this->urlRepository->add($urlObject);
$this->persistenceManager->persistAll();
$gndurlUUID = $urlObject->getUUID();
$oldgnd = $gnd;
$ordenhasurlObject = new Ordenhasurl();
$ordenObject = $this->ordenRepository->findByIdentifier($ordenUUID);
$ordenhasurlObject->setOrden($ordenObject);
$gndurlObject = $this->urlRepository->findByIdentifier($gndurlUUID);
$ordenhasurlObject->setUrl($gndurlObject);
$this->ordenHasUrlRepository->add($ordenhasurlObject);
$this->persistenceManager->persistAll();
}
}
}
}
}
if (isset($wikipedia) && !empty($wikipedia)) {
$wikipedia = str_replace("http:// ", " ", $wikipedia);
$wikipedia = str_replace(";", "#", $wikipedia);
$wikipedias = explode("#", $wikipedia);
if (isset($wikipedias) && is_array($wikipedias)) {
$oldwikipedia = "";
foreach ($wikipedias as $wikipedia) {
if (isset($wikipedia) && !empty($wikipedia)) {
if ($wikipedia != $oldwikipedia) {
$wikipediabemerkung = str_replace("http://de.wikipedia.org/wiki/", "", $wikipedia);
$wikipediabemerkung = str_replace("_", " ", $wikipediabemerkung);
$wikipediabemerkung = rawurldecode($wikipediabemerkung);
$urlObject = new Url();
$urlObject->setUrl($wikipedia);
$urlObject->setBemerkung($wikipediabemerkung);
$wikiurltypObject = $this->urltypRepository->findOneByName('Wikipedia');
$urlObject->setUrltyp($wikiurltypObject);
$this->urlRepository->add($urlObject);
$this->persistenceManager->persistAll();
$wikiurlUUID = $urlObject->getUUID();
$oldwikipedia = $wikipedia;
$ordenhasurlObject = new Ordenhasurl();
$ordenObject = $this->ordenRepository->findByIdentifier($ordenUUID);
$ordenhasurlObject->setOrden($ordenObject);
$wikiurlObject = $this->urlRepository->findByIdentifier($wikiurlUUID);
$ordenhasurlObject->setUrl($wikiurlObject);
$this->ordenHasUrlRepository->add($ordenhasurlObject);
$this->persistenceManager->persistAll();
}
}
}
}
}
$nOrden++;
}
if ($this->logger) {
$end = microtime(true);
$time = number_format($end - $start, 2);
$this->logger->log('Orden import completed in ' . round($time / 60, 2) . ' minutes.');
}
return $nOrden;
}
}
/** Updates the list of Kloster
* @FLOW\SkipCsrfProtection
* @return int $status http status
*/
public function updateListAction()
{
if ($this->request->hasArgument('data')) {
$klosterlist = $this->request->getArgument('data');
}
if (empty($klosterlist)) {
$this->throwStatus(400, 'Required data arguemnts not provided', null);
}
$role = array_keys($this->securityContext->getAccount()->getRoles())[0];
if (trim($role) == 'Flow.Login:Hiwi') {
if (is_array($klosterlist) && !empty($klosterlist)) {
$error = 0;
foreach ($klosterlist as $k => $v) {
$bearbeitungsstatus = $this->bearbeitungsstatusRepository->findByIdentifier($v['bearbeitungsstatus']);
if (is_object($bearbeitungsstatus)) {
$bearbeitungsstatusName = $bearbeitungsstatus->getName();
}
if (isset($bearbeitungsstatusName) && !empty($bearbeitungsstatusName)) {
if (trim($bearbeitungsstatusName) == 'Online') {
$error++;
}
}
}
}
if ($error > 0) {
$this->throwStatus(400, 'You are not allowed to set a Kloster entry online', null);
}
}
if (is_array($klosterlist) && !empty($klosterlist)) {
foreach ($klosterlist as $k => $v) {
$klosterObject = $this->klosterRepository->findByIdentifier((string) $k);
$klosterObject->setKloster($v['kloster']);
$bearbeitungsstatusObject = $this->bearbeitungsstatusRepository->findByIdentifier($v['bearbeitungsstatus']);
$klosterObject->setBearbeitungsstatus($bearbeitungsstatusObject);
$klosterObject->setBearbeitungsstand($v['bearbeitungsstand']);
$this->klosterRepository->update($klosterObject);
$gndAlreadyExists = false;
$klosterHasUrls = $klosterObject->getKlosterHasUrls();
if (is_object($klosterHasUrls) && count($klosterHasUrls) > 0) {
foreach ($klosterHasUrls as $klosterHasUrl) {
$urlObject = $klosterHasUrl->getUrl();
$urlTypObject = $urlObject->getUrltyp();
$urlTyp = $urlTypObject->getName();
if ($urlTyp == "GND") {
if (!empty($v['gnd'])) {
$urlObject->setUrl($v['gnd']);
$this->urlRepository->update($urlObject);
} elseif (isset($v['gnd']) && empty($v['gnd'])) {
$this->klosterHasUrlRepository->remove($klosterHasUrl);
$this->urlRepository->remove($urlObject);
}
$gndAlreadyExists = true;
}
}
}
if (!$gndAlreadyExists) {
$urlObject = new Url();
$urlObject->setUrl($v['gnd']);
$gndid = str_replace('http://d-nb.info/gnd/', '', $v['gnd']);
$gndbemerkung = $v['kloster'] . ' [' . $gndid . ']';
$urlObject->setBemerkung($gndbemerkung);
$urlTypObj = $this->urltypRepository->findOneByName('GND');
$urlObject->setUrltyp($urlTypObj);
$this->urlRepository->add($urlObject);
$klosterhasurl = new KlosterHasUrl();
$klosterhasurl->setKloster($klosterObject);
$klosterhasurl->setUrl($urlObject);
$this->klosterHasUrlRepository->add($klosterhasurl);
}
}
$this->persistenceManager->persistAll();
}
$this->throwStatus(200, null, null);
}