<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:p="http://www.springframework.org/schema/p"
       xmlns:util="http://www.springframework.org/schema/util"
       xsi:schemaLocation="
		http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/util
		http://www.springframework.org/schema/util/spring-util.xsd">

    <bean id="pdfReport"
          class="org.springframework.web.servlet.view.jasperreports.JasperReportsPdfView"
          p:url="resources/reports/report1.jrxml"
          p:reportDataKey="datasource" />


    <bean id="xlsReport"
          class="org.springframework.web.servlet.view.jasperreports.JasperReportsXlsView"
          p:url="resources/reports/report1.jrxml"
          p:reportDataKey="datasource" />


    <bean id="htmlReport"
          class="org.springframework.web.servlet.view.jasperreports.JasperReportsHtmlView"
          p:url="resources/reports/report1.jrxml"
          p:reportDataKey="datasource" />


    <bean id="csvReport"
          class="org.springframework.web.servlet.view.jasperreports.JasperReportsCsvView"
          p:url="resources/reports/report1.jrxml"
          p:reportDataKey="datasource"/>
</beans>

<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

	<annotation-driven />

	<beans:import resource="jasper-views.xml"/>

	<resources mapping="/resources/**" location="/resources/" />
  
  <beans:bean class="org.springframework.web.servlet.view.ResourceBundleViewResolver">
  		<beans:property name="order" value="0"/>
		<beans:property name="basename" value="views" />
	</beans:bean>
	
  	
  <beans:bean class="org.springframework.web.servlet.view.tiles2.TilesConfigurer">
		<beans:property name="definitions" value="/WEB-INF/views/tiles/tiles_templates.xml" />
	</beans:bean>
	
 	<beans:bean class="org.springframework.web.servlet.view.XmlViewResolver">
        <beans:property name="location" value="/WEB-INF/spring/appServlet/jasper-views.xml"/>
        <beans:property name="order" value="1"/>
    </beans:bean>
	
	 <context:component-scan base-package="kz.eec.erp" />
</beans:beans>

import java.lang.reflect.InvocationTargetException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import kz.eec.erp.service.UseService;
import kz.eec.erp.view.DigDataJasperReportsView;
import kz.eec.erp.view.UserView;

import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

@Controller
@Scope("session")
@RequestMapping("/reports")
public class JasperController {

	@Autowired
	private UseService useService;

	public void setUseService(UseService useService) {
		this.useService = useService;
	}
	
	@RequestMapping(method = RequestMethod.GET , value = "reportCSV")
    public ModelAndView generateCSVReport(ModelAndView modelAndView) throws SecurityException, NoSuchMethodException, IllegalArgumentException, InstantiationException, IllegalAccessException, InvocationTargetException{
        Map<String,Object> parameterMap = new HashMap<String,Object>();
        List<UserView> usersList = this.useService.getListUser();
        JRDataSource JRdataSource = new JRBeanCollectionDataSource(usersList);
        parameterMap.put("datasource", JRdataSource);
        modelAndView = new ModelAndView("csvReport", parameterMap);
        return modelAndView;
    }
	
	@RequestMapping(method = RequestMethod.GET , value = "reportHTML")
    public ModelAndView generateHTMLReport(ModelAndView modelAndView) throws SecurityException, NoSuchMethodException, IllegalArgumentException, InstantiationException, IllegalAccessException, InvocationTargetException{
        Map<String,Object> parameterMap = new HashMap<String,Object>();
        List<UserView> usersList = this.useService.getListUser();
        JRDataSource JRdataSource = new JRBeanCollectionDataSource(usersList);
        parameterMap.put("datasource", JRdataSource);
        modelAndView = new ModelAndView("htmlReport", parameterMap);
        return modelAndView;
    }
	
	@RequestMapping(method = RequestMethod.GET , value = "reportPDF")
    public ModelAndView generatePDFReport(ModelAndView modelAndView) throws SecurityException, NoSuchMethodException, IllegalArgumentException, InstantiationException, IllegalAccessException, InvocationTargetException{
        Map<String,Object> parameterMap = new HashMap<String,Object>();
        List<UserView> usersList = this.useService.getListUser();
        JRDataSource JRdataSource = new JRBeanCollectionDataSource(usersList);
        parameterMap.put("datasource", JRdataSource);
        modelAndView = new ModelAndView("pdfReport", parameterMap);
        return modelAndView;
    }

	@RequestMapping(method = RequestMethod.GET , value = "reportXLS")
    public ModelAndView generateXLSReport(ModelAndView modelAndView) throws SecurityException, NoSuchMethodException, IllegalArgumentException, InstantiationException, IllegalAccessException, InvocationTargetException{
        Map<String,Object> parameterMap = new HashMap<String,Object>();
        List<UserView> usersList = this.useService.getListUser();
        JRDataSource JRdataSource = new JRBeanCollectionDataSource(usersList);
        parameterMap.put("datasource", JRdataSource);
        modelAndView = new ModelAndView("xlsReport", parameterMap);
        return modelAndView;
    }	
}