D-Net

package eu.dnetlib.organizations.repository.readonly;

import org.springframework.stereotype.Repository;

import eu.dnetlib.organizations.model.view.WarningView;

import eu.dnetlib.organizations.model.view.WarningViewPK;

@Repository

public interface WarningViewRepository extends ReadOnlyRepository<WarningView, WarningViewPK> {

}

package eu.dnetlib.organizations.model.view;

import java.io.Serializable;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.IdClass;

import javax.persistence.Table;

@Entity

@Table(name = "warnings_view")

@IdClass(WarningViewPK.class)

public class WarningView implements Serializable {

	/**

	 *

	 */

	private static final long serialVersionUID = -6621501199394187765L;

	@Id

	@Column(name = "id_1")

	private String id1;

	@Id

	@Column(name = "id_2")

	private String id2;

	@Column(name = "name_1")

	private String name1;

	@Column(name = "name_2")

	private String name2;

	@Column(name = "type_1")

	private String type1;

	@Column(name = "type_2")

	private String type2;

	@Column(name = "city_1")

	private String city1;

	@Column(name = "city_2")

	private String city2;

	@Column(name = "country_1")

	private String country1;

	@Column(name = "country_2")

	private String country2;

	public String getId1() {

		return id1;

	}

	public void setId1(final String id1) {

		this.id1 = id1;

	}

	public String getId2() {

		return id2;

	}

	public void setId2(final String id2) {

		this.id2 = id2;

	}

	public String getName1() {

		return name1;

	}

	public void setName1(final String name1) {

		this.name1 = name1;

	}

	public String getName2() {

		return name2;

	}

	public void setName2(final String name2) {

		this.name2 = name2;

	}

	public String getType1() {

		return type1;

	}

	public void setType1(final String type1) {

		this.type1 = type1;

	}

	public String getType2() {

		return type2;

	}

	public void setType2(final String type2) {

		this.type2 = type2;

	}

	public String getCity1() {

		return city1;

	}

	public void setCity1(final String city1) {

		this.city1 = city1;

	}

	public String getCity2() {

		return city2;

	}

	public void setCity2(final String city2) {

		this.city2 = city2;

	}

	public String getCountry1() {

		return country1;

	}

	public void setCountry1(final String country1) {

		this.country1 = country1;

	}

	public String getCountry2() {

		return country2;

	}

	public void setCountry2(final String country2) {

		this.country2 = country2;

	}

}

package eu.dnetlib.organizations.model.view;

import java.io.Serializable;

import java.util.Objects;

public class WarningViewPK implements Serializable {

	/**

	 *

	 */

	private static final long serialVersionUID = -4702103726315884367L;

	private String id1;

	private String id2;

	public String getId1() {

		return id1;

	}

	public void setId1(final String id1) {

		this.id1 = id1;

	}

	public String getId2() {

		return id2;

	}

	public void setId2(final String id2) {

		this.id2 = id2;

	}

	@Override

	public int hashCode() {

		return Objects.hash(id1, id2);

	}

	@Override

	public boolean equals(final Object obj) {

		if (this == obj) { return true; }

		if (obj == null) { return false; }

		if (!(obj instanceof WarningViewPK)) { return false; }

		final WarningViewPK other = (WarningViewPK) obj;

		return Objects.equals(id1, other.id1) && Objects.equals(id2, other.id2);

	}

	@Override

	public String toString() {

		return String.format("WarningViewPK [id1=%s, id2=%s]", id1, id2);

	}

}

	public static final String OPENORGS_PREFIX = "openorgs____::";

	public static final String OPENORGS_MESH_PREFIX = "openorgsmesh::";

import java.util.stream.Collectors;

import eu.dnetlib.organizations.model.view.WarningView;

import eu.dnetlib.organizations.repository.readonly.WarningViewRepository;

import eu.dnetlib.organizations.utils.OpenOrgsConstants;

	private WarningViewRepository warningViewRepository;

	@Autowired

			return openaireSimRelRepository.findByLocalId(id).stream().filter(s -> !s.getOaOriginalId().startsWith(OpenOrgsConstants.OPENORGS_PREFIX)).collect(Collectors.toList());

	@RequestMapping(value = "/warnings", method = RequestMethod.GET)

	public Iterable<WarningView> findWarningsById(final Authentication authentication) {

		if (UserInfo.isSuperUser(authentication)) {

			return warningViewRepository.findAll();

		} else {

			throw new RuntimeException("User not authorized");

		}

	}

		final boolean b = UserInfo.isSuperUser(authentication)

				|| simrels.stream().map(OpenaireSimRel::getLocalId).distinct().allMatch(id -> organizationRepository.verifyAuthorizationForId(id, authentication.getName()));

DROP VIEW warnings_view;

CREATE VIEW warnings_view AS SELECT

    o1.id      AS id_1,

    o1.name    AS name_1,

    o1.type    AS type_1,

	o1.city    AS city_1,

	o1.country AS country_1,

    o2.id      AS id_2,

    o2.name    AS name_2,

    o2.type    AS type_2,

	o2.city    AS city_2,

	o2.country AS country_2

FROM

	openaire_simrels s

	LEFT OUTER JOIN organizations o1 ON (s.local_id = o1.id)

    LEFT OUTER JOIN organizations o2 ON (s.oa_original_id = o2.id)

WHERE

	s.oa_original_id LIKE 'openorgs____::%' AND o1.id IS NOT NULL AND O2.id IS NOT NULL;

<div class="row" style="height: 5em">

	<div class="col-xl-8 col-lg-10">

		<p class="muted"><b>ID: </b>{{orgId}}</p>

	</div>

</div>

	<div class="col-xl-10">

						<a href="#!/relations/{{orgId}}" class="nav-link">Relations</a>

						<a href="javascript:void(0)" class="nav-link active">Similarities</a>

						<th style="border-top: none;">Source</th>

						<td class="text-center small"><img ng-src="resources/images/flags/{{sr.oaCountry}}.gif" /> {{sr.oaCountry}}</td>

						<td class="small">

							<b>Collected from:</b> {{sr.oaCollectedFrom}}<br />

							<b>Original Id:</b> <span class="text-monospace">{{sr.oaOriginalId}}</span>

						</td>

							<div class="btn-group btn-group-toggle btn-group-sm" data-toggle="buttons">

									<input type="radio" autocomplete="off" ng-model="sr.relType" value="is_different" ng-class="{'active' : sr.relType == 'is_different'}"><i class="fas fa-times fa-fw"></i>

									<input type="radio" autocomplete="off" ng-model="sr.relType" value="suggested" ng-class="{'active' : sr.relType == 'suggested'}"><i class="fas fa-question fa-fw"></i>

									<input type="radio" autocomplete="off" ng-model="sr.relType" value="is_similar" ng-class="{'active' : sr.relType == 'is_similar'}"/><i class="fas fa-check fa-fw"></i>

<div class="row" style="height: 5em">

	<div class="col-xl-8 col-lg-10">

		<p class="muted"><b>ID: </b>{{orgId}}</p>

	</div>

</div>

						<a href="javascript:void(0)" class="nav-link active">Relations</a>

						<a href="#!/similarities/{{orgId}}" class="nav-link">Similarities</a>

						<a href="#!/relations/{{orgId}}" class="nav-link">Relations</a>

						<a href="#!/similarities/{{orgId}}" class="nav-link">Similarities</a>

<h3>{{warnings.length}} warning(s)</h3>

<table class="table table-sm"  ng-if="warnings.length > 0">

	<thead class="thead-light">

		<tr>

			<th style="width:40px"></th>

			<th>Organization name</th>

			<th style="width:180px">Place</th>

			<th style="width:80px">Type</th>

		</tr>

	</thead>

	<tbody ng-repeat="w in warnings" class="mb-2">

		<tr>

			<th class="text-center">#1</th>

			<td><a href="#!/metadata/0/{{w.id1}}" title="{{w.id1}}">{{w.name1}}</a></td>

			<td><img ng-src="resources/images/flags/{{w.country1}}.gif" /> {{w.city1}}, {{w.country1}}</td>

			<td class="text-right">{{w.type1}}</td>

		</tr>

		<tr>

			<th class="text-center" style="width:40px">#2</th>

			<td><a href="#!/metadata/0/{{w.id2}}" title="{{w.id2}}">{{w.name2}}</a></td>

			<td><img ng-src="resources/images/flags/{{w.country2}}.gif" /> {{w.city2}}, {{w.country2}}</td>

			<td class="text-right">{{w.type2}}</td>

		</tr>

		<tr>

			<th style="width:40px"></th>

			<td colspan="3">

				<button type="button" class="btn btn-sm btn-primary">merge</button>

				<button type="button" class="btn btn-sm btn-outline-danger"><i class="fa fa-trash"></i></button>

			</td>

		</tr>

	</tbody>

</table>

		.when('/warnings',                         { templateUrl: 'resources/html/warnings.html',     controller: 'showWarningsCtrl' })

orgsModule.controller('showWarningsCtrl', function ($scope, $http, $routeParams) {

	$scope.orgId = $routeParams.id;

	$scope.warnings = [];

	$http.get('api/organizations/warnings?id=' + $routeParams.id).then(function successCallback(res) {

		$scope.warnings = res.data;

	}, function errorCallback(res) {

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

	});

});

				<li class="nav-item" sec:authorize="hasRole('ROLE_SUPERUSER')"><a class="nav-link" href="#!/warnings">Warnings</a></li>