<%@page session="true"%> <%@ page import="java.io.PrintWriter"%> <%@ page import="com.edeal.frontline.FrontlineException"%> <%@ page import="com.edeal.frontline.navigation.*"%> <%@ page import="com.edeal.frontline.FlContext"%> <%@ page import="com.edeal.frontline.DataDictionary"%> <%@ page import="com.edeal.frontline.Utils"%> <%@ page import="com.edeal.frontline.FieldNotInitializedException"%> <%@ page import="com.edeal.frontline.MetaDataTransferBean"%> <%@page import="com.edeal.frontline.transfer.actions.RetrieveTransferSqlAction"%> <%@page import="org.apache.commons.lang.StringUtils"%> <%@page import="java.util.Date"%> <%@page import="org.apache.commons.lang.time.DateUtils"%> <%@page import="java.util.Calendar"%> <%@page import="java.text.SimpleDateFormat"%> <%@taglib uri="http://www.e-deal.com/taglib/fl" prefix="fl"%> <% final org.apache.commons.logging.Log logger = org.apache.commons.logging.LogFactory.getLog(getClass()); FlRequest flRequest = new FlRequest(request); FlContext context = flRequest.getContext(); DataDictionary dico = context.getDataDictionary(); String id = flRequest.getRequestParameterOrAttribute("id"); String code = flRequest.getRequestParameterOrAttribute(RetrieveTransferSqlAction.queriesToDownload); MetaDataTransferBean mdt = new MetaDataTransferBean(id,context); String defOutEnc = null; String fileName; try { defOutEnc = context.getContextParameter("DefaultOutputEncoding"); } catch (FrontlineException fex) { logger.debug("error when try to get output encoding from context" , fex); } String pattern = "dd-MM-yy"; SimpleDateFormat form = new SimpleDateFormat(pattern); fileName = StringUtils.replace(mdt.getMdtName(), " ", "_") + "_Apply_" + form.format(mdt.getMdtUpd()) + ".sql" ; response.setContentType("text/plain; filename=" + fileName + (defOutEnc != null ? "; charset=" + defOutEnc : "")); response.setHeader("Content-Disposition", "attachment; filename='" + fileName+"';"); PrintWriter writer = response.getWriter(); writer.write(code); writer.flush(); writer.close(); %>