new 2

New Text editor similar to notepad with new features...........

package mastermind.web.action.sis;

import java.util.Date;
import java.util.Vector;

import java.net.URLEncoder;

import java.io.File;
import java.io.IOException;

import java.sql.Connection;
import java.sql.Timestamp;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.log4j.Category;

import mastermind.db.RecordIterator;

import mastermind.common.Constants;

import mastermind.web.session.User;

import mastermind.web.action.AbstractAction;
import mastermind.web.action.ActionRedirect;
import mastermind.web.action.ScreenRedirect;

import mastermind.wrappers.StaffData;
import mastermind.wrappers.DupStmtHistory;

import mastermind.web.form.servers.StaffForm;

import mastermind.store.SystemStore;
import mastermind.store.StatementStore;
import mastermind.store.DuplicateStatStore;


import mastermind.parsers.StaffStatementParser;

import mastermind.utils.Utilities;

import mastermind.sis.CustomerStatement;

import com.oreilly.servlet.MultipartRequest;

public class GetStatementAction extends AbstractAction {

	private ScreenRedirect screen( StaffForm form ) {
        return new ScreenRedirect( "/sis/staff-upload", form.getQueryString() );
    }

	private ScreenRedirect screen( StaffForm form, String message ) {
        form.setMessage( message );
        return screen( form );
    }

    public void handleAction( HttpServletRequest request, HttpServletResponse response,
                              HttpSession session, Connection conn ) {

		String cardNo = request.getParameter("cardno");
		String statementDate = request.getParameter("statement_date");

		System.out.println("The cardNo is : " + cardNo );
		System.out.println("The date is : " + statementDate );

		if ( cardNo == null || cardNo.length() == 0 || statementDate == null || statementDate.length() == 0  )
		{
			throw new ScreenRedirect("/sis/sis-details", "message=" + URLEncoder.encode("Please check the input") );
		}

		CustomerStatement stat =  new CustomerStatement(cardNo, statementDate );
		Vector data = stat.readTableEntry(conn);
		int size = data.size();
		if ( size < 1 )
		{
			throw new ScreenRedirect("/sis/sis-details", "message=" + URLEncoder.encode("Data not available for the given card number") );
		}
		int statusView=0;
		int statusMail=0;
		int statusFax=0;
		int statusSms=0;
		Vector historyData = DuplicateStatStore.getDuplicateStmtHistory( conn, cardNo, statementDate );
		if(historyData!=null && historyData.size() > 0){
			for(int i=0;i<historyData.size();++i){
				DupStmtHistory history = (DupStmtHistory)historyData.elementAt(i);
				if( history.getDispatchMode().equals("V") ) ++statusView;
				if( history.getDispatchMode().equals("M") ) ++statusMail;
				if( history.getDispatchMode().equals("F") ) ++statusFax;
				if( history.getDispatchMode().equals("S") ) ++statusSms;
			}
		}
		session.setAttribute( Constants.CARD_DETAILS, data );
	    throw new ScreenRedirect( "/sis/statement-options", "cardno=" + cardNo + "&statement_date=" + statementDate +"&statusview="+statusView+"&statusmail="+statusMail+"&statussms="+statusSms+"&statusfax="+statusFax );

    }
}