D-Net

    @Rollback(true)

    public void getRequestsForLibrarian() throws PersonManagerException {

        List<String> organizationIds = new ArrayList<>();

                .getAffiliations()) {

            if(affiliation.getOrganization()!=null)

                organizationIds.add(affiliation.getOrganization().getId());

    @Transactional

    @Rollback(true)

    public void getRequest() throws PersonManagerException {

        System.out.println(r.getPublisherEmail());

        System.out.println(r.getEligibility().getStatus());

    }

	@Override

	public Request saveRequest(final Request request) {

		if (request.getId() == null) {

			request.setId(new SimpleDateFormat("yyyyMMdd-").format(new Date()) + requestDAO.getRequestId());

			Budget budget = null;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.hibernate.Criteria;

import org.hibernate.Query;

import org.hibernate.criterion.Restrictions;

import org.hibernate.type.StringType;

import org.hibernate.type.Type;

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

import org.springframework.stereotype.Repository;

	public void saveRequest(final Request request) {

			if(request.getBankAccount().getId() == null)

				request.getBankAccount().setId(getBankId());

		}

		if(request.getRequestCoFunders() !=null) {

			for (RequestCoFunder rc : request.getRequestCoFunders())

				rc.getPk().setRequest(request);

			Date date = new Date();

			request.setDate(new Timestamp(date.getTime()));

	}

				" c.name as country, p.id as pid, p.acronym, p.startdate, p.enddate, p.scientificarea, " +

				"pub.title, pub.type, j.title as journal,j.issn as issn,(case when jp.id is not null then jp.name else mp.name end) as publisher, " +

				" r.approvaldate as approvaldate, r.apc as apc,r.currency as currency,r.datepaid, r.apcpaid, r.transfercost, " +

				"left join \"user\" u on r.researcher = u.email " +

				"left join project p on r.project=p.id " +

				"left join publication pub on r.publication=pub.id " +

				"left join journal j on j.id=r.journal " +

				"left join publisher jp on j.publisher=jp.id " +

				"left join publisher mp on mp.id=r.publisher " +

		List<String[]> requests = new ArrayList<>();

		Type[] t = new Type[types.size()];

		t = types.toArray(t);

		List<Object[]> resultSet = getSession().createSQLQuery(query)

				.setParameters(args.toArray(), t).list();

		for(Object rs[] : resultSet){

			objs[0] = rs[0].toString();

			objs[1] = String.valueOf(Request.RequestStatus.forStatus(Integer.parseInt(rs[1].toString())));

			objs[2] = rs[2]!=null?new SimpleDateFormat("yyyy/MM/dd").format(rs[2]):null;

			objs[4] = rs[4]!=null?rs[4].toString():null;

			objs[5] = rs[5]!=null?rs[5].toString():null;

			objs[6] = rs[6]!=null?rs[6].toString():null;

			objs[8] = rs[8]!=null?rs[8].toString():null;

			objs[9] = rs[9]!=null?new SimpleDateFormat("yyyy/MM/dd").format(rs[9]):null;

			objs[10] = rs[10]!=null?new SimpleDateFormat("yyyy/MM/dd").format(rs[10]):null;

			objs[22] = rs[22]!=null?rs[22].toString() + "":null;

			objs[23] = rs[23]!=null?rs[23].toString() + "":null;

			objs[24] = rs[24]!=null?rs[24].toString():null;

			requests.add(objs);

		}

		csvWriter.writeNext(new String[]{"id", "Status", "Submission Date", "Firstname", "Lastname", "Organization",

				"Country", "Project id", "Acronym", "Start Date", "End Date", "Scientific Area", "Title", "Type",

				"Journal","Journal ISSN", "Publisher", "Date Approved", "APC requested", "Currency", "Date Paid", "APC paid",

		csvWriter.writeAll(requests, false);

		csvWriter.close();

			return new Eligibility(Eligibility.Status.NONO, stillRunningNono);

		} else if (enddate.after(new Date(System.currentTimeMillis() - expirationOk * 1000L * 60 * 60 * 24 * 30))) {

			return Eligibility.OK;

			return new Eligibility(Eligibility.Status.IFFY, expirationIffy);

		} else {

			return new Eligibility(Eligibility.Status.NONO, expirationNono);