D-Net

import org.apache.log4j.Logger;

import org.springframework.core.io.FileSystemResource;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.PrintWriter;

import java.nio.file.Files;

import java.nio.file.Path;

import java.text.SimpleDateFormat;

import java.util.Date;

    private static final Logger LOGGER = Logger

            .getLogger(PiWikController.class);

            @RequestParam(value = "order",required=false,defaultValue = "DSC") OrderByType orderType,

    @ApiImplicitParams({

            @ApiImplicitParam(name = "from", dataType = "number", paramType = "query"),

            @ApiImplicitParam(name = "quantity", dataType = "number", paramType = "query"),

            @ApiImplicitParam(name = "order", dataType = "eu.dnetlib.repo.manager.domain.OrderByType", paramType = "query"),

            @ApiImplicitParam(name = "searchField", dataType = "eu.dnetlib.repo.manager.domain.OrderByField", paramType = "query"),

            @ApiImplicitParam(name = "orderField", dataType = "string", paramType = "query"),

    })

    @RequestMapping(value = "/getPiwikSitesForRepos/csv" , method = RequestMethod.GET,produces = MediaType.APPLICATION_OCTET_STREAM_VALUE)

    @ResponseBody

    public FileSystemResource getPiwikSitesForReposToCsv(

            @RequestParam(value = "from",required=false,defaultValue = "0") int from,

            @RequestParam(value = "quantity",required=false,defaultValue = "100") int quantity,

            @RequestParam(value = "order",required=false,defaultValue = "DSC") OrderByType orderType,

            @RequestParam(value = "orderField", required = false, defaultValue = "REPOSITORY_NAME") OrderByField orderField,

            @RequestParam(value = "searchField", required = false, defaultValue = "") String searchField,

            HttpServletResponse response,

            HttpServletRequest request

    ) throws IOException {

        Path p = Files.createTempFile("exportingCsv-", new Date().toString());

        List<PiwikInfo> returning = piWikService.getPiwikSitesForRepos(orderField,orderType,from,quantity,searchField);

        try (PrintWriter writer = new PrintWriter(p.toFile())) {

            StringBuilder sb = new StringBuilder();

            sb.append(" repositoryid, siteid, authenticationtoken, creationdate, requestorname, requestoremail, validated, validationdate, comment, repositoryname, country \n");

            for(PiwikInfo piwikInfo : returning){

                sb.append(

                        (piwikInfo.getRepositoryId() == null ? "," : piwikInfo.getRepositoryId()+ ",")+

                                (piwikInfo.getSiteId() == null ? "," : piwikInfo.getSiteId()+ ",") +

                                (piwikInfo.getAuthenticationToken() == null ? "," : piwikInfo.getAuthenticationToken()+ ",")+

                                (piwikInfo.getCreationDate() == null ? "," : piwikInfo.getCreationDate().toString()+ ",") +

                                (piwikInfo.getRequestorName() == null ? "," : piwikInfo.getRequestorName()+ ",") +

                                (piwikInfo.getRequestorEmail() == null ? "," : piwikInfo.getRequestorEmail()+ ",")+

                                piwikInfo.isValidated() + "," +

                                (piwikInfo.getValidationDate() == null ? "," : piwikInfo.getValidationDate().toString()+ ",") +

                                (piwikInfo.getComment() == null ? "," : piwikInfo.getComment()+ ",") +

                                (piwikInfo.getRepositoryName() == null ? "," : piwikInfo.getRepositoryName()+ ",")+

                                (piwikInfo.getCountry() == null ? "\n" : piwikInfo.getCountry()+ "\n")

                );

            }

            writer.write(sb.toString());

        } catch (FileNotFoundException e) {

            LOGGER.error(e.getMessage());

        }

        String mimeType = request.getServletContext().getMimeType(p.toFile().getAbsolutePath());

        if (mimeType == null) {

            mimeType = "application/octet-stream";

        }

        response.setContentType(mimeType);

        response.setContentLength((int) p.toFile().length());

        String headerKey = "Content-Disposition";

        SimpleDateFormat sdfDate = new SimpleDateFormat("ddMMyyyy");//dd/MM/yyyy

        Date now = new Date();

        String strDate = sdfDate.format(now);

        String headerValue = String.format("attachment; filename=\"csv-%s.csv\"",

                strDate);

        response.setHeader(headerKey, headerValue);

        return new FileSystemResource(p.toFile());

    }