<%@ page import="com.zyom.webclient.util.MozartCostUtils,java.util.*,com.zyom.struts.form.AtsRegionsForm,com.zyom.struts.form.MapCustomerForm,com.zyom.reuse.util.DateHandler,com.zyom.webclient.util.MozartConstants"%> <%@ page language="java" pageEncoding="ISO-8859-1"%> <%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%> <%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%> JSP for UserLoginForm form
→RegionCustomerUserMap→
<% if ((MozartCostUtils.isFirefox(request))) { %>
<%} %> <% String finditem=""; if(request.getAttribute("finditem")!=null) finditem=request.getAttribute("finditem").toString(); String finditem1=""; if(request.getAttribute("finditem1")!=null) finditem1=request.getAttribute("finditem1").toString(); %>
Review Sales Regions, Roles Mapped to Regions (Exec, Cust User, ApAdm), Customer related data     Help
 
    
                     
<%=(DateHandler.getDateInSpecifiedFormat( new java.util.Date(), MozartConstants.MOZART_DATE_FORMAT))%>     Select SalesRegion: ALL    
<% String divStyle = "style=\"overflow:auto;height:550;width:1030;\""; String tBodyStyle = "style=\"overflow:auto;overflow-x:hidden;\""; if ((MozartCostUtils.isFirefox(request))) { divStyle = "style=\"overflow:auto;height:550;width:1030;\""; tBodyStyle = "style=\"overflow:auto;overflow-x:hidden;height:200;\""; } %>
<%-- class="tablesorter" --%> <%ArrayList cust_list=(ArrayList)request.getAttribute("cust_list"); for (int i = 0; i < cust_list.size(); i++) { MapCustomerForm mcf=(MapCustomerForm)cust_list.get(i);%> <%}else{%><%="odd"%><%}%>"> <%} %>
Sales Region ROLES MAPPED AT REGION LEVEL (ALL EXCEPT SALES ID) Customer Country Sales ID
<%=mcf.getRegion()%> <%=mcf.getUser_names() %> <%=mcf.getCustomer()%> <%=mcf.getLocation()%> <%=mcf.getSalesid()%>
----------------> Action class code-----------. package com.zyom.struts.ats.action; import java.io.File; import java.text.NumberFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.HashMap; import java.util.Iterator; import java.util.List; import javax.servlet.ServletContext; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import jxl.Workbook; import jxl.write.Colour; import jxl.write.Label; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DownloadAction; import org.apache.struts.actions.DownloadAction.ResourceStreamInfo; import org.apache.struts.actions.DownloadAction.StreamInfo; import com.zyom.reuse.util.DateHandler; import com.zyom.struts.form.CmForm; import com.zyom.struts.form.DemandFGForm; import com.zyom.webclient.util.DBHelper; import com.zyom.webclient.util.AtsHelper; import com.zyom.webclient.util.DemandSupplyItem; import com.zyom.webclient.util.MozartCostUtils; import com.zyom.struts.form.MapCustomerForm; public class RegionCustUserMapXlAction extends DownloadAction { protected StreamInfo getStreamInfo(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { Date currentDatetime = new Date(System.currentTimeMillis()); SimpleDateFormat formatter = new SimpleDateFormat("MM-dd-yyyy-HH-mm"); String myDate = formatter.format(currentDatetime); String myDate1 = formatter.format(currentDatetime); String fileName = "RegCustUsrMap_"+myDate+".xls"; String contentType = "application/vnd.ms-excel"; ServletContext servletCtx = this.servlet.getServletContext(); try{ String path = servletCtx.getRealPath(fileName); WritableWorkbook workbook = Workbook.createWorkbook(new File(path)); HttpSession session = request.getSession(true); List cust_list=new ArrayList(); cust_list=(ArrayList)session.getAttribute("cust_list"); jxl.write.Number num; Calendar stDate = Calendar.getInstance(); Calendar endDate = Calendar.getInstance(); String temp = ""; SimpleDateFormat formatter1 = new SimpleDateFormat("MMM-dd,yyyy"); WritableSheet sheet = workbook.createSheet("RegCustUsrMap_"+myDate1, 1); WritableFont arial10font = new WritableFont(WritableFont.ARIAL, 10); WritableCellFormat arial10format = new WritableCellFormat (arial10font); // sheet.mergeCells(0,0,2,0); WritableFont times16font = new WritableFont(WritableFont.TIMES, 10, WritableFont.BOLD, true); WritableCellFormat times16format = new WritableCellFormat (times16font); times16format.setAlignment(jxl.format.Alignment.CENTRE); // times16format.setBackground(Colour.BLUE); times16format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.MEDIUM,Colour.BLACK); WritableFont datafont = new WritableFont(WritableFont.ARIAL , 10); WritableFont datafont1 = new WritableFont(WritableFont.ARIAL , 10); WritableFont datafont2 = new WritableFont(WritableFont.ARIAL , 10); datafont1.setColour(Colour.BLUE); datafont2.setColour(Colour.RED); datafont.setColour(Colour.BLACK); WritableCellFormat dataformat = new WritableCellFormat (datafont2); WritableCellFormat dataformatApproved = new WritableCellFormat (datafont); WritableCellFormat dataformatnotApproved = new WritableCellFormat (datafont1); WritableCellFormat dataformatApproved1 = new WritableCellFormat (datafont); dataformat.setAlignment(jxl.format.Alignment.LEFT); dataformatApproved.setAlignment(jxl.format.Alignment.LEFT); dataformatnotApproved.setAlignment(jxl.format.Alignment.LEFT); dataformatApproved.setBackground(jxl.format.Colour.YELLOW); dataformatApproved1.setAlignment(jxl.format.Alignment.LEFT); dataformatApproved1.setBackground(jxl.format.Colour.BRIGHT_GREEN); // times16format.setBackground(Colour.BLUE); dataformatApproved.setBorder(jxl.format.Border.ALL , jxl.format.BorderLineStyle.MEDIUM_DASHED ,Colour.BLACK); dataformatApproved1.setBorder(jxl.format.Border.ALL , jxl.format.BorderLineStyle.MEDIUM_DASHED ,Colour.BLACK); Label label = new Label(0, 0, "Region Customer User Map",arial10format); sheet.addCell(label); label=new Label(0,2,"As of: ",arial10format); sheet.addCell(label); label=new Label(1,2,DateHandler.getTodaysDate(),arial10format); sheet.addCell(label); int i=0; int j=3; j++; label = new Label(i, j, "Sales Region" ,times16format); sheet.addCell(label); i++; label = new Label(i, j, "ROLES MAPPED AT REGION LEVEL (ALL EXCEPT SALES ID)" ,times16format); sheet.addCell(label); i++; label = new Label(i, j, "Customer" ,times16format); sheet.addCell(label); i++; label = new Label(i, j, "Country" ,times16format); sheet.addCell(label); i++; label = new Label(i, j, "Sales Id" ,times16format); sheet.addCell(label); i++; while(endDate.after(stDate)){ label = new Label(i, j, formatter1.format(new java.util.Date(stDate.getTimeInMillis())) ,times16format); sheet.addCell(label); i++; stDate.add(Calendar.DATE, 7); } for (int count = 0; count < cust_list.size(); count++) { MapCustomerForm mapCustomerForm=new MapCustomerForm(); mapCustomerForm = (MapCustomerForm) cust_list.get(count); j++; i=0; label = new Label(i, j, mapCustomerForm.getRegion(),arial10format); sheet.addCell(label); i++; label = new Label(i, j, mapCustomerForm.getUser_names(),arial10format); sheet.addCell(label); i++; label = new Label(i, j,mapCustomerForm.getCustomer(),arial10format); sheet.addCell(label); i++; label = new Label(i, j, mapCustomerForm.getLocation(),arial10format); sheet.addCell(label); i++; label = new Label(i, j,mapCustomerForm.getSalesid(),arial10format); sheet.addCell(label); i++; } j=j+2; workbook.write(); workbook.close(); }catch(Exception e){ System.out.print(e); } response.setHeader("Content-disposition", "attachment;filename="+ fileName ); return new ResourceStreamInfo(contentType, servletCtx, fileName); } }