D-Net

    private static final String GET_PUBLISHER = "select id, name, email, contact, apc, discount, source from publisher where id=?";

    private static final String UPDATE_PUBLISHER = "update publisher set name=?, email=?, contact=?, apc=?, discount=?, source=? where id=?";

    private static final String INSERT_PUBLISHER = "insert into publisher (name, email, contact, apc, discount, source, id) values (?, ?, ?, ?, ?, ?, ?)";

                return new Publisher(rs.getString("id"), rs.getString("name"), rs.getString("email"), person, rs.getFloat("apc"), rs.getFloat("discount"), rs.getString("source"));

        Object[] args = {publisher.getName(), publisher.getEmail(), publisher.getContact()!=null?publisher.getContact().getEmail():null, publisher.getAPC(), publisher.getDiscount(), publisher.getSource(), publisher.getId()};

        int[] types = {Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.REAL, Types.REAL, Types.VARCHAR, Types.VARCHAR};

                project.setTitle(rs.getString("title"));

    private static final String INSERT_PUBLICATION = "insert into publication (title, languages, subjects, doi, source, date, type, journal, publisher, repository, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    private static final String UPDATE_PUBLICATION_AFFILIATIONS =

            "with aff as (select id from affiliation where person=? and organization=?) insert into publication_affiliation (publication, affiliation) select ?, aff.id from aff";

        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

        if (publication.getAuthors() != null) {

            for (Affiliation affiliation:publication.getAuthors()) {

                if (jdbcTemplate.update(UPDATE_PUBLICATION_AFFILIATIONS, new String[] {affiliation.getPerson().getEmail(), affiliation.getOrganization().getId(), publication.getId()}, new int[] {Types.VARCHAR, Types.VARCHAR, Types.VARCHAR}) == 0) {

                    jdbcTemplate.update(INSERT_PUBLICATION_AFFILIATIONS,

                            new Object[] {affiliation.getPerson().getEmail(), affiliation.getOrganization().getId(), affiliation.getStart()!=null?affiliation.getStart():null, affiliation.getEnd()!=null?affiliation.getEnd():null, affiliation.getDepartment(), publication.getId()},

                            new int[] {Types.VARCHAR, Types.VARCHAR, Types.TIMESTAMP, Types.TIMESTAMP, Types.VARCHAR, Types.VARCHAR});

                }

        }

package eu.dnetlib.goldoa.service.eligibility;

import eu.dnetlib.goldoa.domain.Eligibility;

import eu.dnetlib.goldoa.domain.Request;

import eu.dnetlib.goldoa.service.EligibilityManager;

/**

 * Created by antleb on 3/25/15.

 */

public class AccountingEligibilityManager implements EligibilityManager {

    private String participationNoNoMessage;

    private String fundingRequestedNoNoMessage;

    @Override

    public Eligibility validate(Request request) {

        Eligibility eligibility = new Eligibility();

        if (request.getProjectParticipation() <= 0 || request.getProjectParticipation() > 100)

            eligibility.merge(new Eligibility(Eligibility.Status.NONO, this.participationNoNoMessage));

        if (request.getFundingRequested() <= 0)

            eligibility.merge(new Eligibility(Eligibility.Status.NONO, this.fundingRequestedNoNoMessage));

        return eligibility;

    }

    public String getParticipationNoNoMessage() {

        return participationNoNoMessage;

    }

    public void setParticipationNoNoMessage(String participationNoNoMessage) {

        this.participationNoNoMessage = participationNoNoMessage;

    }

    public String getFundingRequestedNoNoMessage() {

        return fundingRequestedNoNoMessage;

    }

    public void setFundingRequestedNoNoMessage(String fundingRequestedNoNoMessage) {

        this.fundingRequestedNoNoMessage = fundingRequestedNoNoMessage;

    }

}

    private float APC;

    public Publisher(String id, String name, String email, Person contact, float APC, float discount, String source) {

        this.id = id;

        this.name = name;

        this.email = email;

        this.contact = contact;

        this.APC = APC;

        this.discount = discount;

        this.source = source;

    }

    public Publisher() {

    public float getAPC() {

        return APC;

    }

    public void setAPC(float APC) {

        this.APC = APC;

    }

    public String getSource() {

goldoa.eligibility.project.request.nono.message = request per project nono message!

goldoa.eligibility.accounting.participation.nono.message = participation no no!

goldoa.eligibility.accounting.funding.nono.message = funding request no no!