D-Net

package eu.dnetlib.openaire.blacklist;

import java.io.StringReader;

import javax.xml.ws.wsaddressing.W3CEndpointReference;

import javax.xml.xpath.XPath;

import javax.xml.xpath.XPathExpressionException;

import javax.xml.xpath.XPathFactory;

import org.apache.commons.lang.StringUtils;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Value;

import org.xml.sax.InputSource;

import eu.dnetlib.enabling.database.rmi.DatabaseService;

import eu.dnetlib.enabling.locators.UniqueServiceLocator;

import eu.dnetlib.enabling.resultset.client.IterableResultSetClient;

import eu.dnetlib.enabling.resultset.client.ResultSetClientFactory;

import eu.dnetlib.miscutils.collections.MappedCollection;

import eu.dnetlib.miscutils.functional.UnaryFunction;

public class BlacklistManager {

	private static final Log log = LogFactory.getLog(BlacklistManager.class); // NOPMD by marko on 11/24/08 5:02 PM

	public enum IIS_STATUS {

		UNSOLVED, SOLVED;

	}

	public enum STATUS {

		PENDING, ACCEPTED, REFUSED, DELETED;

	}

	@Value("${dnet.openaire.blacklist.db.name}")

	private String blacklistDatabaseName;

	@Autowired

	private UniqueServiceLocator serviceLocator;

	@Autowired

	private ResultSetClientFactory resultSetClientFactory;

	public Iterable<BlacklistEntry> getBlacklist() {

		String sqlQuery = "SELECT * from blacklist";

		// TODO: ask the database service to get the blacklist entries and translate them into pojo instances.

		W3CEndpointReference epr = serviceLocator.getService(DatabaseService.class).searchSQL(blacklistDatabaseName, sqlQuery);

		IterableResultSetClient iter = resultSetClientFactory.getClient(epr);

		return new MappedCollection<BlacklistEntry, String>(iter, new UnaryFunction<BlacklistEntry, String>() {

			@Override

			public BlacklistEntry evaluate(final String dbEntry) {

				BlacklistEntry be = new BlacklistEntry();

				try {

					InputSource doc = new InputSource(new StringReader(dbEntry));

					XPath xpath = XPathFactory.newInstance().newXPath();

					String provenance = xpath.evaluate("//FIELD[./@name='provenance']", doc);

					be.setProvenance(provenance);

					if (provenance.equalsIgnoreCase("iis")) {

						be.setIisModule(xpath.evaluate("//FIELD[./@name='iis_module']", doc));

						be.setIisStatus(IIS_STATUS.valueOf(StringUtils.upperCase(xpath.evaluate("//FIELD[./@name='iis_status']", doc))));

					}

					// xpath.evaluate("//*[local-name()='objIdentifier']", doc)

					be.setCreationDate(xpath.evaluate("//FIELD[./@name='creation_time']", doc));

					be.setLastUpdateDate(xpath.evaluate("//FIELD[./@name='last_update_time']", doc));

					be.setNote(xpath.evaluate("//FIELD[./@name='note']", doc));

					be.setSemanticClass(xpath.evaluate("//FIELD[./@name='semantic_class']", doc));

					be.setSemanticScheme(xpath.evaluate("//FIELD[./@name='semantic_scheme']", doc));

					be.setStatus(STATUS.valueOf(StringUtils.upperCase(xpath.evaluate("//FIELD[./@name='note']", doc))));

					be.setTicketId(xpath.evaluate("//FIELD[./@name='ticket_id']", doc));

					be.setUser(xpath.evaluate("//FIELD[./@name='userid']", doc));

					be.setSourceObject(xpath.evaluate("//FIELD[./@name='source_object']", doc));

					be.setTargetObject(xpath.evaluate("//FIELD[./@name='target_object']", doc));

					// TODO: get the array of original identifiers

					// xpath.evaluate(("//FIELD[./@name='original_source_objects']/", doc,XPathConstants.NODESET);

					// xpath.evaluate(("//FIELD[./@name='target_source_objects']/", doc,XPathConstants.NODESET);

				} catch (XPathExpressionException e) {

					log.error("Can't parse blacklist entry from database:\n" + dbEntry);

					e.printStackTrace();

				}

				return be;

			}

		});

	}

}

package eu.dnetlib.openaire.blacklist;

import java.util.List;

import com.google.gson.Gson;

import eu.dnetlib.openaire.blacklist.BlacklistManager.IIS_STATUS;

import eu.dnetlib.openaire.blacklist.BlacklistManager.STATUS;

public class BlacklistEntry {

	/** The user who reported the wrong link **/

	private String user;

	/** A note regarding the reported 'wrong' relationship **/

	private String note;

	/** The id of the ticket associated to this entry **/

	private String ticketId;

	/** Provenance of the relationship. 'iis' when the relatonship is inferred **/

	private String provenance;

	/** Semantics of the relationship. E.g. 'isProducedBy' and 'dnet:result_project_relations' **/

	private String semanticClass, semanticScheme;

	/** The inference module that generated the relationship. Blank if provenance is not 'iis'. **/

	private String iisModule;

	/** Status of the report **/

	private STATUS status;

	/** Status of the issue from the pov of IIS. Blank if provenance is not 'iis'. **/

	private IIS_STATUS iisStatus;

	// using String instead of date because the datasource manager forgets the types.

	private String creationDate, lastUpdateDate;

	/** OpenAIRE ids of the objects linked by the 'wrong' relationship **/

	private String sourceObject, targetObject;

	/** If the source or the target are representatives, then the following lists are not empty and contain the ids of the merged objects **/

	private List<String> originalSourceObjects, originalTargetObjects;

	@Override

	public String toString() {

		Gson gson = new Gson();

		return gson.toJson(this);

	}

	public String getUser() {

		return user;

	}

	public void setUser(final String user) {

		this.user = user;

	}

	public String getNote() {

		return note;

	}

	public void setNote(final String note) {

		this.note = note;

	}

	public String getTicketId() {

		return ticketId;

	}

	public void setTicketId(final String ticketId) {

		this.ticketId = ticketId;

	}

	public String getProvenance() {

		return provenance;

	}

	public void setProvenance(final String provenance) {

		this.provenance = provenance;

	}

	public String getSemanticClass() {

		return semanticClass;

	}

	public void setSemanticClass(final String semanticClass) {

		this.semanticClass = semanticClass;

	}

	public String getSemanticScheme() {

		return semanticScheme;

	}

	public void setSemanticScheme(final String semanticScheme) {

		this.semanticScheme = semanticScheme;

	}

	public String getIisModule() {

		return iisModule;

	}

	public void setIisModule(final String iisModule) {

		this.iisModule = iisModule;

	}

	public STATUS getStatus() {

		return status;

	}

	public void setStatus(final STATUS status) {

		this.status = status;

	}

	public IIS_STATUS getIisStatus() {

		return iisStatus;

	}

	public void setIisStatus(final IIS_STATUS iisStatus) {

		this.iisStatus = iisStatus;

	}

	public String getCreationDate() {

		return creationDate;

	}

	public void setCreationDate(final String creationDate) {

		this.creationDate = creationDate;

	}

	public String getLastUpdateDate() {

		return lastUpdateDate;

	}

	public void setLastUpdateDate(final String lastUpdateDate) {

		this.lastUpdateDate = lastUpdateDate;

	}

	public String getSourceObject() {

		return sourceObject;

	}

	public void setSourceObject(final String sourceObject) {

		this.sourceObject = sourceObject;

	}

	public String getTargetObject() {

		return targetObject;

	}

	public void setTargetObject(final String targetObject) {

		this.targetObject = targetObject;

	}

	public List<String> getOriginalSourceObjects() {

		return originalSourceObjects;

	}

	public void setOriginalSourceObjects(final List<String> originalSourceObjects) {

		this.originalSourceObjects = originalSourceObjects;

	}

	public List<String> getOriginalTargetObjects() {

		return originalTargetObjects;

	}

	public void setOriginalTargetObjects(final List<String> originalTargetObjects) {

		this.originalTargetObjects = originalTargetObjects;

	}

}

package eu.dnetlib.functioanlity.modular.ui.blacklist;

import eu.dnetlib.functionality.modular.ui.ModuleEntryPoint;

import org.springframework.ui.ModelMap;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

/**

 * Created by alessia on 18/09/15.

 */

public class BlacklistEntryPointController extends ModuleEntryPoint {

		@Override

		protected void initialize(final ModelMap map, final HttpServletRequest request, final HttpServletResponse response) throws Exception {}

}

package eu.dnetlib.functioanlity.modular.ui.blacklist;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpServletResponse;

/**

 * Created by alessia on 18/09/15.

 */

@Controller

public class BlacklistInternalController {

	@RequestMapping(value = "/ui/getBlacklist.do")

	public void getBlacklist(final HttpServletResponse response) throws Exception {

	}

}

dnet.openaire.blacklist.db.name=dnet_openaire_blacklist

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:jaxws="http://cxf.apache.org/jaxws"

	   xmlns:sec="http://cxf.apache.org/configuration/security" xmlns:wsa="http://cxf.apache.org/ws/addressing"

	   xmlns:p="http://www.springframework.org/schema/p" xmlns:http="http://cxf.apache.org/transports/http/configuration"

	   xmlns:t="http://dnetlib.eu/springbeans/t" xmlns:template="http://dnetlib.eu/springbeans/template"

	   xmlns:util="http://www.springframework.org/schema/util" xmlns:context="http://www.springframework.org/schema/context"

	   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

						http://cxf.apache.org/ws/addressing http://cxf.apache.org/schemas/ws-addr-conf.xsd

						http://cxf.apache.org/configuration/security http://cxf.apache.org/schemas/configuration/security.xsd

						http://cxf.apache.org/transports/http/configuration http://cxf.apache.org/schemas/configuration/http-conf.xsd

						http://cxf.apache.org/jaxws http://cxf.apache.org/schemas/jaxws.xsd

						http://dnetlib.eu/springbeans/template http://dnetlib.eu/springbeans/template.xsd

						http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd

						http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<bean name="/ui/blacklist.do"

		  class="eu.dnetlib.functionality.modular.ui.blacklist.BlacklistEntryPointController"

		  p:menu="Blacklist Manager"

		  p:title="Blacklist Manager"

		  p:description="Manager for the Blacklist of links"

		  p:group="Tools">

		<property name="permissionLevels">

			<set>

				<value>IS_ADMIN</value>

			</set>

		</property>

	</bean>

</beans>

$common/master( header={

	<script type="text/javascript" src="../resources/js/angular.min.js" ></script>

	<script type="text/javascript" src="../resources/js/angular-route.min.js"></script>

	<script type="text/javascript" src="../resources/js/db_manager.js"></script>

	<script type="text/javascript" src="../resources/js/db_manager_controllers.js"></script>

}, body={

	<div ng-app="dbManager">

		<div ng-view></div>

	</div>

} )$

		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>cnr-resultset-client</artifactId>

			<version>[2.0.0,3.0.0)</version>

		</dependency>

		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>cnr-enabling-database-api</artifactId>

			<version>[1.0.0,2.0.0)</version>

		</dependency>

		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>dnet-modular-ui</artifactId>

			<version>[3.0.0,4.0.0)</version>

		</dependency>

		<dependency>

			<groupId>javax.servlet</groupId>

			<artifactId>javax.servlet-api</artifactId>

			<version>${javax.servlet.version}</version>

			<scope>provided</scope>

		</dependency>