D-Net

NotificationHandler.java & EmailSender.java: bug fix in calculating seconds (store 12:00 and add 1 sec to last_interaction_date when sending email).

springContext-claimsDemo.xml: targetHour and targetMinute beans restored (were changed for testing purposes).

1. FetchClaimHandler.java: add method fetchNumberOfClaimsByDateAndOpenaireId.
2. CommunityUtils.java: request datasource API to get community information (including managers).
3. FetchContextHandler.java: Method fetchFirstContextByCommunityId to parse name of community to be used in the above API....

1. Add entity 'Notification': pairs of mail-openaireId, with the preferences for notifications of this user for this id.
2. Add FetchNotificationHandler and NotificationHandler for 'Notification' entity.
3. springContext-claimsDemo.xml: Add beans for FetchNotificationHandler, NotificationHandler, defaultFrequencyInHours....

1. Project.java: Remove 'token' field from 'Project' entity.
2. FetchProjectHandler.java, ProjectHandler.java, TestClass.java: Remove methods related to 'token' field.
3. FetchProjectHandler.java: Add 'fetchProjectIdsAndNamesByProjectManagerMail' method | Change 'fetchContactEmailsByProjectId' method (mails are returned as List from DAO).

SqlStore.java:
close ResultSet and Statement in finally clause
return CachedRowSet instead of ResultSet when needed (avoids problems with closed connection, nothing else changes because CachedRowSet extends ResultSet)

Parameterize context utils methods with a boolean parameter for productionIndex, add production url
In delete claims method add check for deleting record

Enable claiming for ORPs
Set direct index url in properties
Migration:
save orphan Ids, claims
uncomment fetch dedup

1. FetchProjectHandler.java: Rename 'fetchProjectIdByToken' to 'fetchProjectIdByTokenAndEmail' and create 'public String fetchProjectIdByToken(String token)' method.
2. QueryGenerator.java: Rename 'generateSelectProjectIdByTokenQuery' to 'generateSelectProjectIdByTokenAndEmailQuery' -...

Change ContextUtils to get concept label from new Context API