package unitest;

import eu.dnetlib.goldoa.domain.*;
import eu.dnetlib.goldoa.service.*;
import eu.dnetlib.goldoa.service.utils.EmailUtils;
import org.apache.commons.codec.digest.DigestUtils;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.annotation.Rollback;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import javax.mail.MessagingException;
import javax.transaction.Transactional;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * Created by panagiotis on 2/2/2017.
 */
@RunWith( SpringJUnit4ClassRunner.class )
@ContextConfiguration(locations = "classpath:applicationContext-goldoa-service-test.xml")
public class ManageRequestsTest {

    @Autowired
    UserManager um;
    @Autowired
    ProjectManager pm;
    @Autowired
    EligibilityManager em;
    @Autowired
    PublicationManager pum;
    @Autowired
    OrganizationManager om;
    @Autowired
    SearchManager sm;
    @Autowired
    RequestManager rm;
    @Autowired
    JournalManager jm;
    @Autowired
    PublisherManager pubm;
    @Autowired
    InvoiceManager im;
    @Autowired
    EmailUtils email;

    @Test
    @Transactional
    @Rollback(true)
    public void getRequestsForLibrarian() throws PersonManagerException {
        List<String> organizationIds = new ArrayList<>();
        for(Affiliation affiliation : um.getByEmail("pkanakakis@di.uoa.gr")
                .getAffiliations()) {
            if(affiliation.getOrganization()!=null)
                organizationIds.add(affiliation.getOrganization().getId());
        }
        System.out.println(organizationIds.get(0));
        RequestPage rs = rm.getForOrganization(organizationIds,null, null, RequestSort.DATE,
                RequestSortOrder.DESCENDING,
                null, null, null, 0, 9);
        List<Request> rss = rs.getRequests();
        for(Request r:rss)
            System.out.println(r.getId());
    }

    @Test
    @Transactional
    @Rollback(true)
    public void getRequestsForGeneralUser() throws PersonManagerException {
        List<String> organizationIds = new ArrayList<>();
        for(Affiliation affiliation : um.getByEmail("ant.lebesis@gmail.com")
                .getAffiliations()) {
            if(affiliation.getOrganization()!=null)
                organizationIds.add(affiliation.getOrganization().getId());
        }
        System.out.println(organizationIds.get(0));
        RequestPage rs = rm.getForUser("ant.lebesis@gmail.com",null, null, RequestSort.DATE,
                RequestSortOrder.DESCENDING,
                null, null, null, 0, 9);
        List<Request> rss = rs.getRequests();
        for(Request r:rss)
            System.out.println(r.getId());
    }



    @Test
    @Transactional
    @Rollback(true)
    public void getRequestsForPublisher() throws PersonManagerException {
        User user = null;

        try {
            user = um.getByEmail("ant.lebesis@gmail.com");
        } catch (PersonManagerException e) {
            e.printStackTrace();
        }

        RequestPage rs = rm.getForPublisher(user.getEmail(),null, null, RequestSort.DATE,
                RequestSortOrder.DESCENDING,
                null, null, null, 0, 9);
        List<Request> rss = rs.getRequests();
        for(Request r:rss)
            System.out.println(r.getId());
    }

    @Test
    @Transactional
    @Rollback(true)
    public void getProjectInfoAndEligibility() {

        Project project = pm.getById("corda::100016");
        Request request = new Request();
        request.setStatus(Request.RequestStatus.INCOMPLETE);
        request.setProject(project);
        em.validate(request);

    }

    @Test
    @Transactional
    @Rollback(true)
    public void resolveDOI() {
        try {
            Publication p = pum.resolveDOI("10.1155/2017/1297658");
            System.out.println(p.getType().getType());
        } catch (ManagerException e) {
            e.printStackTrace();
        }
    }

    @Test
    @Transactional
    @Rollback(true)
    public void savePublicationAndPublisherInfo() throws PersonManagerException, OrganizationManagerException {
        try {
            Publication p = pum.resolveDOI("10.1038/srep12540");

            Request r  = new Request();
            r.setStatus(Request.RequestStatus.INCOMPLETE);
            r.setUser(um.getByEmail("pkanakakis@di.uoa.gr"));
            r.setPublication(pum.getPublication("portal::d48191df0a20dfff1d1332574440ff29"));
            r.setJournal(p.getJournal());
            r.setOrganization(om.getById("corda::999643007"));
            r.setEligibility(em.validate(r));

            RequestCoFunder rc = new RequestCoFunder();
            RequestCoFunderPK rcpk = new RequestCoFunderPK();

            List<Object> res = sm.search(SearchManager.TYPE.FUNDER, "1675 Foundation");
            Funder f = (Funder)res.get(0);

            rcpk.setFunder(f);
            rcpk.setRequest(r);
            rc.setPk(rcpk);
            rc.setPercentage(50);

            List<RequestCoFunder> rc_list = new ArrayList<>();
            rc_list.add(rc);

            r.setRequestCoFunders(rc_list);


            Comment c = new Comment();
            c.setId("portal::" + DigestUtils.md5Hex("comment" + new Date()));
            c.setComment("comment");
            List<Comment> c_list = new ArrayList<>();
            c_list.add(c);
            r.setRequestComments(c_list);

            //r.setInvoice(new Invoice());
            BankAccount bankAccount = new BankAccount();
            bankAccount.setBankName("Wells Fargo Bank, N.A.");
            r.setBankAccount(bankAccount);

            rm.saveRequest(r);
        } catch (ManagerException e) {
            e.printStackTrace();
        }
    }


    @Test
    @Transactional
    @Rollback(true)
    public void updateRequest() throws PersonManagerException {
        Request r = rm.getById("20160720-982");

        List<Object> res = sm.search(SearchManager.TYPE.FUNDER, "8020 Promotion Foundation");
        Funder f = (Funder)res.get(0);

        RequestCoFunder rc = new RequestCoFunder();
        RequestCoFunderPK rcpk = new RequestCoFunderPK();
        rcpk.setFunder(f);
        rcpk.setRequest(r);
        rc.setPk(rcpk);
        rc.setPercentage(50);

        r.getRequestCoFunders().add(rc);
        r.setPublisher((Publisher)sm.search(SearchManager.TYPE.PUBLISHER, "EDP Sciences").get(0));

        r.setApcPaid((float) 10000);


        BankAccount bankAccount = new BankAccount();
        bankAccount.setBankName("Wells Fargo Bank, N.A.");
        r.setBankAccount(bankAccount);
        rm.submitRequest(r);
//        rm.saveRequest(r);
    }


    @Test
    @Transactional
    @Rollback(true)
    public void downaloadInvoiceFile() throws PersonManagerException, ManagerException {
        InvoiceFile file = im.downloadInvoice("portal::93b206de-03e3-482f-a924-7f152d692964");
    }


    @Test
    @Transactional
    @Rollback(true)
    public void processingRequest() throws PersonManagerException, ManagerException {
        Request r = rm.getById("20170429-1492");
        rm.processingRequest(r.getId(),"ant.lebesis@gmail.com","comment",null);
    }

    @Test
    @Transactional
    @Rollback(true)
    public void getRequest() throws PersonManagerException {
        Request r = rm.getById("20170524-1518");
        System.out.println(r.getBankTransferReceipt());
        System.out.println(r.getPublisherEmail());
        System.out.println(r.getEligibility().getStatus());
    }

    @Test
    @Transactional
    @Rollback(true)
    public void importCSVRequests() throws IOException {

        String csv = "Firstname,Lastname,Email, Affiliation,Project Grant Number,DOI,Acceptance Date,Publication Identifier Type,Publication Identifier value," +
                "APC,APC currency,Discount\n" +
                "Panagiotis,Kanakakis,pkanakakis@di.uoa.gr,NATIONAL AND KAPODISTRIAN UNIVERSITY OF ATHENS,641489,10.1002/0470841559.ch10,2015-05-27,doi,doiValue,1000,EUR,0\n "+
                "Panagiotis,Kanakakis,p2@di.uoa.gr,NATIONAL AND KAPODISTRIAN UNIVERSITY OF ATHENS,641489,10.1002/0470841559.ch10,2015-05-27,doi,doiValue,1000,EUR,0\n "+
                "Panagiotis,Kanakakis,,NATIONAL AND KAPODISTRIAN UNIVERSITY OF ATHENS,641489,10.1002/0470841559.ch10,2015-05-27,doi,doiValue,,EUR,";

        try {
            rm.importCSV(csv);
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Error message: " + e.getMessage());
        }
    }

    @Test
    @Transactional
    @Rollback(true)
    public void uploadBankReceipt() throws PersonManagerException {
        Request r = rm.getById("20170530-1529");
        rm.uploadTransferReceipt(r.getId(),null,null);
    }

    @Test
    @Transactional
    @Rollback(true)
    public void paidRequestComment() throws PersonManagerException {
        Request r = rm.getById("20170314-1397");
        rm.approveRequest(r.getId(),"pkanakakis@di.uoa.gr","Test Comment",null);
    }

    @Test
    @Transactional
    @Rollback(true)
    public void getCSV() throws PersonManagerException {
        String resultSet = rm.getCSV("moderator", null, null, null, null, null);
        System.out.println(resultSet);
    }

    @Test
    @Transactional
    @Rollback(true)
    public void sendEmailForPendingIncompleteRequests() throws MessagingException {
       rm.sendEmailForPendingIncompleteRequests();
    }

    @Test
    @Transactional
    @Rollback(true)
    public void sendEmailForConditionallyApprovedRequests() throws MessagingException {
        rm.sendEmailForPendingConditionallyApprovedRequests();
    }

    @Test
    @Transactional
    @Rollback(true)
    public void potentiallyEligibleProjects()  {
        pm.getEligibleProjectsForOrganization("corda::983580389\t");
    }



}