Help with Servlet Code

[Michele Smith]

What am I looking at:

public void doAction( Context ctx, BcSQLAgent agt, HttpServletRequest req, HttpServletResponse response)
throws ServletException, IOException, Exception
  {
    SimpleDateFormat dateFormatLong = new SimpleDateFormat("MMMM dd, yyyy"); 

    String caseId = req.getParameter ("caseId");
    String homeId = req.getParameter ("homeId");
    String fileName = req.getParameter ("documentFileName"); 
    String dmDocumentId = req.getParameter ("dmDocumentId");
    String fileExt = fileName.substring( fileName.lastIndexOf(".") );
    String savedFileName = new String();
    String savedFileNameOriginal = new String();
    String savedFileNameNoSpaces = new String();
    String savedFileNameNoSpacesOriginal = new String();
    String templateFile = "fhfiles/templates/" + fileName;
    String tempString = new String();
    String generalDocumentType = req.getParameter ("generalDocumentType");

    WordTemplate oWW = null;

    String serverName = req.getServerName();
    Home h = ctx.getHome( agt );
    BcInteger _homeid = new BcInteger(ctx.getHomeId());

    Case c = new Case (agt);
    Package pack = new Package( agt );
    Properties _tagsByName = new Properties();
    TagHandler _tagHandler = new TagHandler( ctx, agt );

I am wanting to determine if these strings are being passed on the query string and if I needed to add a parameter, how to do so.

Thanks,

[Paul Clapham]

Yes, in that code "req.getParameter(something)" gets one of the request parameters.

As for how they get into your application, that depends on whether the request was GET or POST (or one of the other more unusual methods). If it's a GET request then the parameters come in as parameters of the URL (probably what you meant by "on the query string") but if it's a POST request then they work somewhat differently.

As for adding a parameter, you can't do that in your servlet. You can only respond to whatever your client has sent. Now if that question was meant to be how to get the client to send another parameter, then it's a question about the client. About which we know nothing.

[Bear Bibeault]

Taking a guess, if you mean these lines:

    String caseId = req.getParameter ("caseId");  
    String homeId = req.getParameter ("homeId");  
    String fileName = req.getParameter ("documentFileName");   
    String dmDocumentId = req.getParameter ("dmDocumentId");  

Then yes, those are request parameters.

They can be set by the query string on a the request URL (in the case of a GET), or by form elements (in the case of a POST).

[Edit: Paul shot first while I was posting! ]

[Michele Smith]

How can I be sure that the parentid is passing? I have examined DMTemplateLoaderFLReports and it apperas to be passing a "1" as a parameter.

For example,

https://209.173.134.79:7001/DMTemplateLoaderFLReports?sdate=03/16/2010&edate=03/19/2012&caseid=0&homeid=1&parentid=1&userid=100059&mode=APA&documentFileName=1-EmbalmingReport.doc&homeId=<xsl:value-of select="../../Home/Id"/>&transId=NA&dmDocumentId=<xsl:value-of select="../../DMDocumentId"/>

package bcc.pages.documentManagement;

/*************************************************************
* File Name: DMTemplateLoaderFLReports.java
*
* Created:  January 2009
* Original Author: Josh Asbury
*

*
*-------------------------------------------------------------
* MODIFICATION HISTORY
*-------------------------------------------------------------
* When          Who             		Why
* 01/21/2009	Kendra Fluegeman		Initial revision
* 03/19/2012    Michele Smith	        Revision for reports
**************************************************************/

import bcc.lib.dob.Package;
import com.bc.domain.BcTransactor;
import com.softartisans.wordwriter.WordTemplate;
import java.io.File;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpServletRequest;
import java.io.InputStream;
import java.io.IOException;
import java.io.BufferedInputStream;
import java.util.Collections;
import java.util.Comparator;
import java.util.Properties;
import java.util.Iterator;
import java.util.List;
import java.util.ListIterator;
import java.text.DecimalFormat;
import java.lang.String;
import java.text.DateFormat;
import java.text.ParsePosition;
import java.util.Calendar;
import java.util.GregorianCalendar;
import com.bc.domain.BcInteger;
import com.bc.util.BcSQLAgent;
import bcc.lib.BccUtil;
import bcc.lib.Context;
import bcc.lib.dob.Home;
import bcc.lib.dob.RParameters;
import bcc.lib.dob.Case;
import bcc.lib.TagHandler;
import bcc.lib.dob.CaseDMDocuments;
import com.bc.util.logging.Logger;


 
public class DMTemplateLoaderFLReports extends bcc.lib.BaseDoServlet 
{

    
    private boolean findMyFile(String savedFileNameNoSpacesOriginal, String path)
    {
              boolean bUseOriginal = false;
              File dir = new File(path);
              String[] children = dir.list();
              if (children == null) 
              {
                // Either dir does not exist or is not a directory
              } 
              else 
              {
                for (int i=0; i<children.length; i++) 
                {
                  String filename = children[i];
                  if(filename.equals(savedFileNameNoSpacesOriginal))
                  {
                    bUseOriginal = true;
                  }
                }
              }
              return bUseOriginal;
    }
    private Properties assignTags(Properties _tagsByName)
    {
    	_tagsByName.setProperty("DATE" , "" );
        _tagsByName.setProperty("DATE_VERBAL_MONTH" , "" );
        _tagsByName.setProperty("DATE_YEAR_ONLY" , "" );
        
        return _tagsByName;
    }
    
    private class CaseInfo {
    	public String firstName;
    	public String middleName;
    	public String lastName;
    	public String deathCounty;
    	public String deathDate;
    	public String cremationDate;
    	public String casketMaterial;
    	public String cremator;
    	public String licenseNumber;
    	public String atNeedNumber;
    	public Date myCremDate; 
    	
    	public CaseInfo(Case c1, Date cremDate, BcSQLAgent agt, BcInteger homeId) {
    		firstName = c1.getFirstName();
    		middleName = c1.getMiddleName();
    		lastName = c1.getLastName();
    		myCremDate = cremDate;
    		try{
    			deathCounty = RParameters.getValueByCase( c1.getId(), RParameters.STAT_DEATH_PLACE_COUNTY, agt );
        		deathDate = c1.getDeathShort();
        		cremationDate = RParameters.getValueByCase( c1.getId(), RParameters.STAT_CREMATION_DATE, agt );
        		casketMaterial = RParameters.getValueByCase(c1.getId(), RParameters.STAT_PREP_CASKET_MATERIAL, agt );
        		cremator = RParameters.getValueByCase( c1.getId(), RParameters.STAT_CREMATOR, agt );
        		licenseNumber = RParameters.getValueByHome( homeId, RParameters.HOME_LIC, agt );
        		atNeedNumber = c1.getSrvCaseNbr();
    		}
    		catch (Exception e){
    			
    		}
    		
    		
    	}
    	
    }
  public void doAction( Context ctx, BcSQLAgent agt, HttpServletRequest req, HttpServletResponse response) throws ServletException, IOException, Exception
  {
    SimpleDateFormat dateFormatLong = new SimpleDateFormat("MMMM dd, yyyy"); 

    String caseId = req.getParameter ("caseId");
    String homeId = req.getParameter ("homeId");
    String fileName = req.getParameter ("documentFileName"); 
    String dmDocumentId = req.getParameter ("dmDocumentId");
    String fileExt = fileName.substring( fileName.lastIndexOf(".") );
    String savedFileName = new String();
    String savedFileNameOriginal = new String();
    String savedFileNameNoSpaces = new String();
    String savedFileNameNoSpacesOriginal = new String();
    String templateFile = "fhfiles/templates/" + fileName;
    String tempString = new String();
    String generalDocumentType = req.getParameter ("generalDocumentType");

    WordTemplate oWW = null;

    String serverName = req.getServerName();
    Home h = ctx.getHome( agt );
    BcInteger _homeid = new BcInteger(ctx.getHomeId());

    Case c = new Case (agt);
    Package pack = new Package( agt );
    Properties _tagsByName = new Properties();
    TagHandler _tagHandler = new TagHandler( ctx, agt );

			//--- Data to populate the document will come from two arrays
			//--- This is the "names" array which holds the names of
			//--- the mergefields in the document
  	String[] mergeFields =	{

"CaseFullName",
"InstitutionCounty",
"CaseDeathDateShort",
"PrepCasketMaterialCdbd",
"FHAddress1",
"FHAddress2",//5
"FHBCCAccountNumber",
"FHGSTNumber",
"FHCity",
"FHEmailAddress",
"FHFaxNumber",//10
"FHLicenseNumber",
"FHCommitmentText",
"FHLegalName",
"FHShortName",
"FHPhoneNumber",//15
"FHState",
"FHZipCode",
"RemTransferDate",
"EmbEmbalmingDate",
"EmbEmbalmerName",//20
"CaseAtNeedNum",
"CommittalCremDate",
"CrematorName", 
"CineratorName",
"CineratorLicense", //25
"CineratorPhone",
"CineratorAddress",
"RmvlSrvName",
"RmvlSrvLicense",
"LicenseFHByCase", //30
"TodaysMonth",
"TodaysYear",
"PrepCasketMaterialWood",
"PrepCasketMaterialMtl",
"Disposition", //35
"RefrigName",
"RefrigLicense",
"EmbalmFacName",
"EmbalmFacLicense"



};

			//--- This is the "values" array
			//--- Its elements correspond to the merge field
			//--- names defined in the "names" array
			//--- Copy the values from the DataTable
			//--- and add the employeeId and PostUrl

      Object[] mergeValues = new Object[40];

      StringBuffer sb = new StringBuffer();
 
        String fhaddress = h.getAddress1();
        if( fhaddress != null)
        {
        	mergeValues[4] = h.getAddress1();
        }
        else
        {
        	mergeValues[4] = "";
        }
        String fhaddress2 = h.getAddress2();
        if( fhaddress2 != null)
        {
        	mergeValues[5] = h.getAddress2();
        }
        else
        {
        	mergeValues[5] = "";
        }
        String fhbccaccount = RParameters.getValueByHome( _homeid, RParameters.HOME_ACC_NUM, agt );
        if( fhbccaccount != null)
        {
        	mergeValues[6] = RParameters.getValueByHome( _homeid, RParameters.HOME_ACC_NUM, agt );
        }
        else
        {
        	mergeValues[6] = "";
        }
        String fhgstnumber = RParameters.getValueByHome( _homeid, RParameters.HOME_GST_NUMBER, agt );
        if( fhgstnumber != null)
        {
        	mergeValues[7] = RParameters.getValueByHome( _homeid, RParameters.HOME_GST_NUMBER, agt );
        }
        else
        {
        	mergeValues[7] = "";
        }
        String fhcity = h.getCity();
        if( fhcity != null)
        {
        	mergeValues[8] = h.getCity();
        }
        else
        {
        	mergeValues[8] = "";
        }
        String fhemail = h.getEmail(); 
        if( fhemail != null)
        {
        	mergeValues[9] = h.getEmail();
        }
        else
        {
        	mergeValues[9] = "";
        }
        String fhfax = h.getFax();
        if( fhfax != null)
        {
        	mergeValues[10] = h.getFax();
        }
        else
        {
        	mergeValues[10] = "";
        }
        String fhlicense = RParameters.getValueByHome( _homeid, RParameters.HOME_LIC, agt );
        if( fhlicense != null)
        {
        	 mergeValues[11] = RParameters.getValueByHome( _homeid, RParameters.HOME_LIC, agt );
        }
        else
        {
        	mergeValues[11] = "";
        }
        String fhcommitment = RParameters.getValueByHome( _homeid, RParameters.HOME_OUR_COMMITMENT, agt );
        if( fhcommitment != null)
        {
        	mergeValues[12] = RParameters.getValueByHome( _homeid, RParameters.HOME_OUR_COMMITMENT, agt );
        }
        else
        {
        	mergeValues[12] = "";
        }
        String fhname = h.getName();
        if( fhname != null)
        {
        	mergeValues[13] = h.getName();
        }
        else
        {
        	mergeValues[13] = "";
        }
        String fhshortname = h.getHomeShortName();
        if( fhshortname != null)
        {
        	mergeValues[14] = h.getHomeShortName();
        }
        else
        {
        	mergeValues[14] = "";
        }
        String fhphone = h.getPhone();
        if( fhphone != null)
        {
        	mergeValues[15] = h.getPhone();
        }
        else
        {
        	mergeValues[15] = "";
        }
        String fhstate = h.getState();
        if( fhstate != null)
        {
        	mergeValues[16] =  h.getState();
        }
        else
        {
        	mergeValues[16] = "";
        }
        String fhzip = h.getZip();
        if( fhzip != null)
        {
        	mergeValues[17] = h.getZip();
        }
        else
        {
        	mergeValues[17] = "";
        }

        String cineratorname = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_NAME, agt );
        if( cineratorname != null)
        {
        	mergeValues[24] = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_NAME, agt );
        }
        else
        {
        	mergeValues[24] = "";
        }
        
        String cineratorlicense = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_LICENSE, agt );
        if( cineratorlicense != null)
        {
        	mergeValues[25] = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_LICENSE, agt );
        }
        else
        {
        	mergeValues[25] = "";
        }
        
        String cineratorphone = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_PHONE, agt );
        if( cineratorphone != null)
        {
        	mergeValues[26] = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_PHONE, agt );
        }
        else
        {
        	mergeValues[26] = "";
        }
        
        String cineratoraddress = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_ADDRESS, agt );
        if( cineratoraddress != null)
        {
        	mergeValues[27] = RParameters.getValueByHome( _homeid, RParameters.CINERATOR_ADDRESS, agt );
        }
        else
        {
        	mergeValues[27] = "";
        }

        String rmvlsrvname = RParameters.getValueByHome( _homeid, RParameters.REMOVAL_SERV_NAME, agt );
        if( rmvlsrvname != null)
        {
        	mergeValues[28] = RParameters.getValueByHome( _homeid, RParameters.REMOVAL_SERV_NAME, agt );
        }
        else
        {
        	mergeValues[28] = "";
        }
        
        String rmvlsrvlicense = RParameters.getValueByHome( _homeid, RParameters.REMOVAL_SERV_LICENSE, agt );
        if( rmvlsrvlicense != null)
        {
        	mergeValues[29] = RParameters.getValueByHome( _homeid, RParameters.REMOVAL_SERV_LICENSE, agt );
        }
        else
        {
        	mergeValues[29] = "";
        }
        
        String refrigName = RParameters.getValueByHome( _homeid, RParameters.REFRIG_NAME, agt );
        if( refrigName != null)
        {
        	mergeValues[36] = RParameters.getValueByHome( _homeid, RParameters.REFRIG_NAME, agt );
        }
        else
        {
        	mergeValues[36] = "";
        }
        
        String refrigLicense = RParameters.getValueByHome( _homeid, RParameters.REFRIG_LICENSE, agt );
        if( refrigLicense != null)
        {
        	mergeValues[37] = RParameters.getValueByHome( _homeid, RParameters.REFRIG_LICENSE, agt );
        }
        else
        {
        	mergeValues[37] = "";
        }
        
        String embalmFacName = RParameters.getValueByHome( _homeid, RParameters.EMBALM_FAC_NAME, agt );
        if( embalmFacName != null)
        {
        	mergeValues[38] = RParameters.getValueByHome( _homeid, RParameters.EMBALM_FAC_NAME, agt );
        }
        else
        {
        	mergeValues[38] = "";
        }
        
        String embalFacLicense = RParameters.getValueByHome( _homeid, RParameters.EMBALM_FAC_LICENSE, agt );
        if( embalFacLicense != null)
        {
        	mergeValues[39] = RParameters.getValueByHome( _homeid, RParameters.EMBALM_FAC_LICENSE, agt );
        }
        else
        {
        	mergeValues[39] = "";
        }

        h.getXML( sb );
        h.getCasesXML( sb );

        
        StringBuffer name = new StringBuffer();
        StringBuffer deathcounty = new StringBuffer();
        StringBuffer deathdateshort = new StringBuffer();
        StringBuffer cremationdate = new StringBuffer();
        StringBuffer containertypecdbd = new StringBuffer();
        StringBuffer containertypewood = new StringBuffer();
        StringBuffer containertypemtl = new StringBuffer();
        StringBuffer crematorname = new StringBuffer();
        StringBuffer licensefh = new StringBuffer();
        StringBuffer burialtransitpermitnum = new StringBuffer();
        
        
        //changed by Michele Smith -- the file name per new changes required with reporting on 03/19/2012.
        if(fileName.equals("CineratorReport.doc"))
        {	        	
	        ArrayList caseidlist = (ArrayList)h.getCases();
	        ArrayList<CaseInfo> reportList = new ArrayList<CaseInfo>();
	        int j = 0;
	        for(int i = 0; i < caseidlist.size(); ++i)
	        {
	        	Case c1 = (Case)caseidlist.get(i);
	        	if (c1.getDispositionId().equals("2"))
	        	{
	        		if (RParameters.getValueByCase( c1.getId(), RParameters.STAT_CREMATION_DATE, agt ).trim().length() > 0)
	        		{
		        		SimpleDateFormat shortDateFormatter = new SimpleDateFormat("MM/dd/yyyy");
		        		String cremdate = RParameters.getValueByCase( c1.getId(), RParameters.STAT_CREMATION_DATE, agt );
		        		Date myCremDate = shortDateFormatter.parse(cremdate);
		        		String sdate = req.getParameter ("sdate");
		        		Date startdate = shortDateFormatter.parse(sdate);
		        		String edate = req.getParameter ("edate");
		        		Date enddate = shortDateFormatter.parse(edate);
			        	if ((myCremDate.after(startdate) && myCremDate.before(enddate)) || myCremDate.equals(enddate) || myCremDate.equals(startdate))
			        	{
			        		reportList.add(new CaseInfo(c1, myCremDate, agt, h.getId()));
			        			
			        	}
	        		}
	        	}     	
	        }
	        Collections.sort(reportList, new Comparator<CaseInfo>() {

				public int compare(CaseInfo o1, CaseInfo o2) {
					int fc = o1.myCremDate.compareTo(o2.myCremDate);
					if (fc==0) return o1.lastName.compareTo(o2.lastName);
					else return fc;
				}
	        	
	        });
	        for (CaseInfo ci : reportList) {
	        	name.append(ci.firstName);
	        	name.append( " " );
	        	name.append(ci.middleName);
	        	name.append( " " );
	        	name.append(ci.lastName);
	        	name.append( "\n" );
	        	deathcounty.append(ci.deathCounty);
	        	deathcounty.append( "\n" );
	        	deathdateshort.append(ci.deathDate);
	        	deathdateshort.append( "\n" );
	        	cremationdate.append(ci.cremationDate);
	        	cremationdate.append( "\n" );
	        	
	        	if(ci.casketMaterial.equals("Cardboard"))
	        	{
	        		containertypecdbd.append("X");
	        	}
	        		containertypecdbd.append( "\n" );
	        	
	        	if(ci.casketMaterial.equals("Wood"))
	        	{
	        		containertypewood.append("X");
	        	}
	        		containertypewood.append( "\n" );
	        	
	        	if(ci.casketMaterial.equals("Metal"))
	        	{
	        		containertypemtl.append("X");
	        	}
	        		containertypemtl.append( "\n" );
	        		
	        	crematorname.append(ci.cremator);
	        	crematorname.append( "\n" );
	        	licensefh.append(ci.licenseNumber);
	        	licensefh.append( "\n" );
	        	burialtransitpermitnum.append(ci.atNeedNumber);
	        	burialtransitpermitnum.append( "\n" );
	        }
        	
	      
	        if( name != null)
	        {
	        	 mergeValues[0] = name;
	        }
	        else
	        {
	        	mergeValues[0] = "";
	        }
	        
	        if( deathcounty != null)
	        {
	        	mergeValues[1] = deathcounty;
	        }
	        else
	        {
	        	mergeValues[1] = "";
	        }
	        
	        if( deathdateshort != null)
	        {
	        	mergeValues[2] = deathdateshort;
	        }
	        else
	        {
	        	mergeValues[2] = "";
	        }
	        
	        if( cremationdate != null)
	        {
	        	mergeValues[22] = cremationdate;
	        }
	        else
	        {
	        	mergeValues[22] = "";
	        }
	        
	        if( containertypecdbd != null )
	        {
	        	mergeValues[3] = containertypecdbd;
	        }
	        else
	        {
	        	mergeValues[3] = "";
	        }
	        
	        if( containertypewood != null)
	        {
	        	mergeValues[33] = containertypewood;
	        }
	        else
	        {
	        	mergeValues[33] = "";
	        }
	        
	        if( containertypemtl != null)
	        {
	        	mergeValues[34] = containertypemtl;
	        }
	        else
	        {
	        	mergeValues[34] = "";
	        }
	        
	        if( crematorname != null)
	        {
	        	mergeValues[23] = crematorname;
	        }
	        else
	        {
	        	mergeValues[23] = "";
	        }
	        
	        if( licensefh != null)
	        {
	        	mergeValues[30] = licensefh;
	        }
	        else
	        {
	        	mergeValues[30] = "";
	        }
	        
	        if( burialtransitpermitnum != null)
	        {
	        	mergeValues[21] = burialtransitpermitnum;
	        }
	        else
	        {
	        	mergeValues[21] = "";
	        }
          }
      //changed by Michele Smith -- the file name per new changes required with reporting on 03/19/2012.        
        if(fileName.equals("EmbalmingReport.doc"))
        {
        	StringBuffer ername = new StringBuffer();
            StringBuffer erremtransferdate = new StringBuffer();
            StringBuffer erdeathdateshort = new StringBuffer();
            StringBuffer erembdate = new StringBuffer();
            StringBuffer erembname = new StringBuffer();
            StringBuffer erdisposition = new StringBuffer();
            StringBuffer erdeathcounty = new StringBuffer();
            StringBuffer erburialtransitpermitnum = new StringBuffer();
            
	        ArrayList caseidlist = (ArrayList)h.getCasesEmbReport();
	        
	        for(int i = 0; i < caseidlist.size(); ++i)
	        {
	        	Case c1 = (Case)caseidlist.get(i);

	        		if (c1.getDeath().trim().length() > 0)
	        		{
	        		SimpleDateFormat shortDateFormatter = new SimpleDateFormat("MM/dd/yyyy");
	        		String deathdate = c1.getDeath();
	        		Date myDeathDate = shortDateFormatter.parse(deathdate);
	        		String sdate = req.getParameter ("sdate");
	        		Date startdate = shortDateFormatter.parse(sdate);
	        		String edate = req.getParameter ("edate");
	        		Date enddate = shortDateFormatter.parse(edate);
	        		
		        	if ((myDeathDate.after(startdate) && myDeathDate.before(enddate)) || myDeathDate.equals(enddate) || myDeathDate.equals(startdate))
		        	{
		        		erdeathdateshort.append(c1.getDeathShort());
			        	erdeathdateshort.append( "\n" );
		        		ername.append(c1.getFirstName());
			        	ername.append( " " );
			        	ername.append(c1.getMiddleName());
			        	ername.append( " " );
			        	ername.append(c1.getLastName());
			        	ername.append( "\n" );
			        	erremtransferdate.append(RParameters.getValueByCase( c1.getId(), RParameters.STAT_REMOVAL_DATE, agt ));
			        	erremtransferdate.append( "\n" );
			        	erembdate.append(RParameters.getValueByCase( c1.getId(), RParameters.STAT_EMBALMING_DATE, agt ));
			        	erembdate.append( "\n" );
			        	erembname.append(RParameters.getValueByCase( c1.getId(), RParameters.STAT_EMB_NAME, agt ));
			        	erembname.append( "\n" );
			        	erdisposition.append(RParameters.getValueByCase( c1.getId(), RParameters.INTRO_FILE_DISPOSITION, agt ));
			        	erdisposition.append( "\n" );
			        	erdeathcounty.append(RParameters.getValueByCase( c1.getId(), RParameters.STAT_DEATH_PLACE_COUNTY, agt ));
			        	erdeathcounty.append( "\n" );
			        	erburialtransitpermitnum.append(c1.getSrvCaseNbr());
			        	erburialtransitpermitnum.append( "\n" );
		        	}
	        	}
	        }
	      
	        if( ername != null)
	        {
	        	 mergeValues[0] = ername;
	        }
	        else
	        {
	        	mergeValues[0] = "";
	        }
	        
	        if( erremtransferdate != null)
	        {
	        	mergeValues[18] = erremtransferdate;
	        }
	        else
	        {
	        	mergeValues[18] = "";
	        }
	        
	        if( erdeathdateshort != null)
	        {
	        	mergeValues[2] = erdeathdateshort;
	        }
	        else
	        {
	        	mergeValues[2] = "";
	        }
	        
	        if( erembdate != null)
	        {
	        	mergeValues[19] = erembdate;
	        }
	        else
	        {
	        	mergeValues[19] = "";
	        }
	        if( erembname != null)
	        {
	        	mergeValues[20] = erembname;
	        }
	        else
	        {
	        	mergeValues[20] = "";
	        }
	        if( erdisposition != null)
	        {
	        	mergeValues[35] = erdisposition;
	        }
	        else
	        {
	        	mergeValues[35] = "";
	        }
	        
	        if( erdeathcounty != null)
	        {
	        	mergeValues[1] = erdeathcounty;
	        }
	        else
	        {
	        	mergeValues[1] = "";
	        }
	        
	        if( erburialtransitpermitnum != null)
	        {
	        	mergeValues[21] = erburialtransitpermitnum;
	        }
	        else
	        {
	        	mergeValues[21] = "";
	        }
          }
        
        String reportMonthStr = req.getParameter ("sdate").substring(0,2);
        String reportMonth = "";
        if(reportMonthStr.equals("01"))
        {
        	reportMonth = "January";
        }
        if(reportMonthStr.equals("02"))
        {
        	reportMonth = "February";
        }
        if(reportMonthStr.equals("03"))
        {
        	reportMonth = "March";
        }
        if(reportMonthStr.equals("04"))
        {
        	reportMonth = "April";
        }
        if(reportMonthStr.equals("05"))
        {
        	reportMonth = "May";
        }
        if(reportMonthStr.equals("06"))
        {
        	reportMonth = "June";
        }
        if(reportMonthStr.equals("07"))
        {
        	reportMonth = "July";
        }
        if(reportMonthStr.equals("08"))
        {
        	reportMonth = "August";
        }
        if(reportMonthStr.equals("09"))
        {
        	reportMonth = "September";
        }
        if(reportMonthStr.equals("10"))
        {
        	reportMonth = "October";
        }
        if(reportMonthStr.equals("11"))
        {
        	reportMonth = "November";
        }
        if(reportMonthStr.equals("12"))
        {
        	reportMonth = "December";
        }
        

          String reportMonthLong =  reportMonth; 
          String reportYear = req.getParameter ("sdate").substring(6,10);
          
          mergeValues[31] = reportMonthLong;

          mergeValues[32] = reportYear;

        
        Connection conn =agt.getConnection().getConnection();

       
        
        PreparedStatement psIsNull = conn.prepareStatement("SELECT ID FROM THE_CASE WHERE HOME_ID = " + ctx.getHomeId());
        ResultSet rs = psIsNull.executeQuery();

        while (rs.next())
        {
          List cases = c.find("WHERE ID = " + rs.getString(1) +  " AND HOME_ID = " + ctx.getHomeId(), "", new ArrayList());

          for (Iterator it = cases.iterator(); it.hasNext(); )
          {
            Case cas = (Case) it.next();
            c.getXMLTrans( sb, agt, cas );
          }
        }
    //--- Path to the template file, relative to the Servlet context root.

    //System.out.println("##################### TEMPLATE FILE: " + templateFile);
    //--- Declare the InputStream we will use to open the template.
    InputStream iStream = null;
    CaseDMDocuments cdm = new CaseDMDocuments( agt );
    int printedDocumentCount = 0;
    int timesDocumentPrinted = 0;
    
    try
    {
// MN - SCR 1560
      Date date = new Date();
      SimpleDateFormat dateFormat = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");
      String dateString = dateFormat.format( date );

      if(fileExt.equals( ".doc" )||fileExt.equals( ".docx" ))  // Call WordWriter
      {
          //--- Instantiate the WordTemplate object.
        oWW = new WordTemplate();

        //--- Open Word template file as a resource: have to do it
        //--- this way to work from unexpanded WAR files. For greatest
        //--- efficiency and reliability, use a BufferedInputStream.
        iStream = new BufferedInputStream(ctx.getResourceAsStream(templateFile));

        //--- Open the template file.
        oWW.open(iStream);

        //--- Set the data source of the document by passing
        //--- the value array and the name array that we initialized above.
        oWW.setDataSource(mergeValues, mergeFields);

        //--- Call WordTemplate.process() to populate the template with
        //--- the new data.
        oWW.process();

        //--- After processing the template, call WordTemplate.save() and
        //--- pass HttpServletResponse to stream. The second argument is
        //--- the file name that will appear in the SaveAs dialog
        //--- The third argument is "open inline".  Here it's false, so
        //--- it will open in a new Microsoft Word instance instead of
        //--- in the browser.    
              List params = new ArrayList();
              params.add( new BcInteger(dmDocumentId) );
              params.add (h.getId());
              params.add (new BcInteger(caseId));

              savedFileNameOriginal =  savedFileName;
              savedFileNameNoSpacesOriginal = removeSpecialCharacters(savedFileNameOriginal);
              savedFileName =  fileName;
              savedFileNameNoSpaces = removeSpecialCharacters(savedFileName);
              
// MN - If file doesn't exist yet, create it with lowercase Last Name
//      For an existing file, retrieve it as is
              boolean bUseOriginal = false;

              bUseOriginal = findMyFile(savedFileNameNoSpacesOriginal,getServletContext().getRealPath("fhfiles") + File.separator + "output");


              if(bUseOriginal)
              {
                oWW.save(getServletContext().getRealPath("fhfiles") + File.separator + "output" + File.separator + savedFileNameNoSpacesOriginal);
                response.sendRedirect( ctx.getWebApp() + "fhfiles/output/" + savedFileNameNoSpacesOriginal);
              }
              else
              {
                oWW.save(getServletContext().getRealPath("fhfiles") + File.separator + "output" + File.separator + savedFileNameNoSpaces);
                response.sendRedirect( ctx.getWebApp() + "fhfiles/output/" + savedFileNameNoSpaces);
              }


      String returnString = "SelectCineratorReport";
      //return;


      }
    }

    catch(Exception ex)
    {
      //--- Alert the user if there's any exception.

      //response.resetBuffer();
      response.getWriter().println("<b>An exception has occurred</b>
" + String.valueOf(ex));
    }
    finally
    {
      //--- Close the template input stream.
      if(iStream!=null)
        iStream.close();
    }
  }


    private String check( String checklist )
    {
      String result;
      
      if(!( checklist == null || checklist.equals("") || checklist.equals(" ")))
          {
            if(checklist.equals("T"))
            {
              result = "Yes";
            }
            else
            {
              result = "No";
            }
          }
          else
          {
            result = "No";  // "N/A"
          }

          return result;
    }


    private String integerFormat( double num )
    {
        return(new DecimalFormat("###,###,###")).format( num );
    }

    private String dollarFormat( double num )
    {
        if( num == 0 )
            return "";
        return(new DecimalFormat("###,###,###.00")).format( num );
    }


   /**********************************************************************
     * Remove XML special characters
     *  & - &
     *  " - "
     *  ' - '
     *  < - <
     *  > - >
     *
     *  @param  s -     String to clean (in-place)
     *  @return String with removed characters, if any
     *
     *  @author Josh Asbury - September 2004
     **********************************************************************/

    public static String removeSpecialCharacters( final String s )
    {
      StringBuffer sb = new StringBuffer( s );
      int i;

      //  Spaces
      i = sb.toString().indexOf( ' ' );
      while (i > -1)
      {
		    sb.replace( i, i + 1, "" );
    		i = sb.toString().indexOf( ' ', ++i );
      }

      //  Ampersands
      i = sb.toString().indexOf( '&' );
      while (i > -1)
      {
		    sb.replace( i, i + 1, "" );
    		i = sb.toString().indexOf( '&', ++i );
      }

    	//  Double quote
      i = sb.toString().indexOf( '"' );
      while (i > -1)
      {
		    sb.replace( i, i + 1, "" );
    		i = sb.toString().indexOf( '"', ++i );
      }

    	//  Single quote
      i = sb.toString().indexOf( '\'' );
      while (i > -1)
      {
		    sb.replace( i, i + 1, "" );
    		i = sb.toString().indexOf( "\'", ++i );
      }

    	//  Left angle bracket
      i = sb.toString().indexOf( '<' );
      while (i > -1)
      {
		    sb.replace( i, i + 1, "" );
    		i = sb.toString().indexOf( '<', ++i );
      }

    	//  Right angle bracket
      i = sb.toString().indexOf( '>' );
      while (i > -1)
      {
		    sb.replace( i, i + 1, "" );
    		i = sb.toString().indexOf( '>', ++i );
      }

      return sb.toString();
    }   // cleanXML(sb)

    class StringComparator implements Comparator
    {
    // Compare two Strings. Callback for sort.
    // effectively returns a-b;
    // e.g. +1 (or any +ve number) if a > b
    // 0 if a == b
    // -1 (or any -ve number) if a < b
    public final int compare ( Object a, Object b )
       {
       return( (String)a ).compareTo( (String)b );
       } // end compare
    } // end class StringComparator


}

[Paul Clapham]

I don't know what that enormous bit of code was supposed to mean. (Please don't post huge code samples, nobody wants to read them.) However in the URL you posted at the beginning, after the XSLT transformation was complete, there would be three URL parameters, namely "homeId", "transId", and "dmDocumentId". Actually I suppose there could be others if the XSLT transformation generated them, but the code doesn't look to me as if it would do that. It's not impossible, though, so the best way to see what parameters are being passed is to look at the actual URL which is generated rather than trying to figure out what the code might produce.