/*
* $RCSfile: DisplayExpenseHandler.java,v $ $Revision: 1.1.1.1 $ $Date: 2005/04/28 20:26:12 $ - $Author: mking_cv $
*
* The contents of this file are subject to the Open Software License
* Version 2.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.centraview.com/opensource/license.html
*
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
*
* The Original Code is: CentraView Open Source.
*
* The developer of the Original Code is CentraView. Portions of the
* Original Code created by CentraView are Copyright (c) 2004 CentraView,
* LLC; All Rights Reserved. The terms "CentraView" and the CentraView
* logos are trademarks and service marks of CentraView, LLC.
*/
package com.centraview.account.expense;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.GregorianCalendar;
import java.util.Iterator;
import java.util.StringTokenizer;
import java.util.TimeZone;
import java.util.Vector;
import javax.naming.CommunicationException;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.log4j.Logger;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.centraview.account.accountfacade.AccountFacade;
import com.centraview.account.accountfacade.AccountFacadeHome;
import com.centraview.account.common.AccountConstantKeys;
import com.centraview.account.common.ItemElement;
import com.centraview.account.common.ItemLines;
import com.centraview.account.item.ItemList;
import com.centraview.common.CVUtility;
import com.centraview.common.FloatMember;
import com.centraview.common.IntMember;
import com.centraview.common.ListElement;
import com.centraview.common.ListGenerator;
import com.centraview.common.StringMember;
import com.centraview.common.UserPrefererences;
import com.centraview.settings.Settings;
public class DisplayExpenseHandler extends org.apache.struts.action.Action
{
// Global Forwards
public static final String GLOBAL_FORWARD_failure = "failure";
// Local Forwards
private static final String FORWARD_editexpense = ".view.accounting.expenses.edit";
private static String FORWARD_final = GLOBAL_FORWARD_failure;
static int counter = 0;
private static Logger logger = Logger.getLogger(DisplayExpenseHandler.class);
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException, CommunicationException, NamingException
{
String dataSource = Settings.getInstance().getSiteInfo(CVUtility.getHostName(super.getServlet().getServletContext())).getDataSource();
AccountFacadeHome accountFacadeHome = (AccountFacadeHome)CVUtility.getHomeObject("com.centraview.account.accountfacade.AccountFacadeHome","AccountFacade");
try
{
HttpSession session = request.getSession(true);
request.setAttribute(AccountConstantKeys.TYPEOFSUBMODULE, AccountConstantKeys.EXPENSE);
request.setAttribute("body", "EDIT");
ExpenseForm expenseForm = (ExpenseForm)request.getAttribute("expenseform");
ItemLines itemLines=null;
expenseForm.convertItemLines();
com.centraview.common.UserObject userobjectd = (com.centraview.common.UserObject)session.getAttribute( "userobject" );//get the user object
int individualID = userobjectd.getIndividualID();
int expenseID = 0;
UserPrefererences userPref = userobjectd.getUserPref();
String dateFormat = userPref.getDateFormat();
dateFormat= "M/d/yyyy";
String timeZone = userPref.getTimeZone();
if(timeZone == null)
timeZone = "EST";
GregorianCalendar gCal = new GregorianCalendar(TimeZone.getTimeZone(timeZone));
SimpleDateFormat dForm = new SimpleDateFormat(dateFormat);
dForm.setCalendar(gCal);
if(request.getParameter("rowId") != null)
expenseID = Integer.parseInt((String)request.getParameter("rowId"));
else
expenseID = expenseForm.getExpenseID();
String typeOfOperation = request.getParameter(AccountConstantKeys.TYPEOFOPERATION);
/*
Remove item
*/
if(typeOfOperation != null && typeOfOperation.equals("REMOVEITEM") )
{
String removeIDs = request.getParameter("removeID");
StringTokenizer st;
Iterator itr;
Vector removeKeys = new Vector();
itemLines = expenseForm.getItemLines();
if (itemLines != null)
{
st = new StringTokenizer(removeIDs, ",");
while (st.hasMoreTokens())
{
String str = st.nextToken();
int removeToken = Integer.parseInt(str);
itr = itemLines.keySet().iterator();
while (itr.hasNext())
{
Object obj = itr.next();
ItemElement ILE = (ItemElement)itemLines.get(obj);
IntMember ItemId = (IntMember)ILE.get("ItemId");
Integer currItemId = (Integer)ItemId.getMemberValue();
if ( currItemId.intValue() == removeToken)
{
String status = ILE.getLineStatus();
if (status.equals("Active"))
{
ILE.setLineStatus("Deleted");
}//end of if (status.equals("Active"))
else if (status.equals("New"))
{
removeKeys.add(obj);
}//end of else if (status.equals("New"))
}//end of if ( currItemId.intValue() == removeToken)
}//end of while (itr.hasNext())
}//end of while (st.hasMoreTokens())
for(int i=0; i<removeKeys.size(); i++)
{
itemLines.remove(removeKeys.get(i));
}// end of for(int i=0; i<removeKeys.size(); i++)
}//end of if (itemLines != null)
expenseForm.setItemLines(itemLines);
request.setAttribute("expenseform",expenseForm);
}// end of if(typeOfOperation != null && typeOfOperation.equals("REMOVEITEM") )
/* ADD item */
else if(typeOfOperation != null && typeOfOperation.equals("ADDITEM") )
{
String newItemID = request.getParameter("theitemid");
ItemList IL = null ;
ListGenerator lg = ListGenerator.getListGenerator(dataSource);//get the List Generator object for Listing
IL = (ItemList )lg.getItemList( individualID , 1, 10 , "" , "ItemID");//called when the request for the list is for first time
StringTokenizer st;
String token, nextItr;
if (newItemID != null)
{
st = new StringTokenizer(newItemID, ",");
itemLines = (expenseForm).getItemLines();
if(itemLines == null)
itemLines = new ItemLines();
int counter = itemLines.size();
while (st.hasMoreTokens())
{
token = (String)st.nextToken();
int intToken = Integer.parseInt(token);
Iterator itr = IL.keySet().iterator();
while (itr.hasNext())
{
nextItr = (String)itr.next();
ListElement ile = (ListElement)IL.get(nextItr);
IntMember smid = (IntMember)ile.get("ItemID");
Integer listItemid = (Integer)smid.getMemberValue();
if ( listItemid.intValue() == intToken )
{
StringMember smName = (StringMember)ile.get("Name"); // name = description
String name = (String) smName.getMemberValue();
StringMember smSku = (StringMember) ile.get("SKU");
String sku = (String)smSku.getMemberValue();
FloatMember dmprice = (FloatMember) ile.get("Price");
float price = Float.parseFloat((dmprice.getMemberValue()).toString());
int id = ile.getElementID();
IntMember LineId = new IntMember("LineId",0,'D',"",'T',false,20);
IntMember ItemId = new IntMember("ItemId",id,'D',"",'T',false,20);
IntMember Quantity = new IntMember("Quantity",1,'D',"",'T',false,20);
FloatMember PriceEach = new FloatMember("Price",new Float(price),'D',"",'T',false,20);
StringMember SKU = new StringMember("SKU",sku,'D',"",'T',false);
StringMember Description = new StringMember("Description",name,'D',"",'T',false);
FloatMember PriceExtended = new FloatMember("PriceExtended",new Float(0.0f),'D',"",'T',false,20);
ItemElement ie = new ItemElement(0);
ie.put ("LineId",LineId);
ie.put ("ItemId",ItemId);
ie.put ("SKU",SKU);
ie.put ("Description",Description);
ie.put ("Quantity",Quantity);
ie.put ("Price",PriceEach);
ie.put ("PriceExtended",PriceExtended);
ie.setLineStatus("New");
counter += 1;
itemLines.put(new Integer(counter), ie);
break;
}// end of if ( listItemid.intValue() == intToken )
}// end of while (itr.hasNext())
}// end of while (st.hasMoreTokens())
expenseForm.setItemLines(itemLines);
}// end of if(newItemID != null)
request.setAttribute("expenseform",expenseForm);
}// end of else if(typeOfOperation != null && typeOfOperation.equals("ADDITEM") )
else if (expenseID == 0)
{
expenseForm = (ExpenseForm) form;
String projectTitle = (String) request.getParameter("projectTitle");
String projectID = (String) request.getParameter("projectID");
if(projectTitle != null && !projectTitle.equals("") && !projectTitle.equals("null")){
expenseForm.setProject(projectTitle);
}//end of if(projectTitle != null && !projectTitle.equals("") && !projectTitle.equals("null"))
if(projectID != null && !projectID.equals("") && !projectID.equals("null")){
expenseForm.setProjectID(projectID);
}//end of if(projectID != null && !projectID.equals("") && !projectID.equals("null"))
String opportunityName = (String) request.getParameter("opportunityName");
String opportunityID = (String) request.getParameter("opportunityID");
if(opportunityName != null && !opportunityName.equals("") && !opportunityName.equals("null")){
expenseForm.setOpportunity(opportunityName);
}//end of if(opportunityName != null && !opportunityName.equals("") && !opportunityName.equals("null"))
if(opportunityID != null && !opportunityID.equals("") && !opportunityID.equals("null")){
expenseForm.setOpportunityID(opportunityID);
}//end of if(opportunityID != null && !opportunityID.equals("") && !opportunityID.equals("null"))
expenseForm.convertItemLines();
request.setAttribute("expenseform", expenseForm);
}// end of else if (expenseID == 0)
else if ((request.getParameter("rowId") != null))
{
AccountFacade remote =(AccountFacade)accountFacadeHome.create();
remote.setDataSource(dataSource);
ExpenseVO expenseVO = remote.getExpenseVO(expenseID,individualID);
expenseForm.setExpenseID(expenseID);
expenseForm.setGlAccountID(""+expenseVO.getGlAccountIDValue());
expenseForm.setStrAmount(""+expenseVO.getAmount());
expenseForm.setTitle(expenseVO.getTitle());
expenseForm.setExpenseDescription(expenseVO.getExpenseDescription());
expenseForm.setEntity(expenseVO.getEntity());
expenseForm.setEntityID(""+expenseVO.getEntityIDValue());
java.sql.Date date = expenseVO.getDateEntered();
expenseForm.setDateEntered(dForm.format(date));
String expStatus = expenseVO.getStatus();
if(expStatus.equalsIgnoreCase("Paid"))
expenseForm.setStatusID(""+1);
if(expStatus.equalsIgnoreCase("Unpaid"))
expenseForm.setStatusID(""+2);
if(expStatus.equalsIgnoreCase("Reimbursed"))
expenseForm.setStatusID(""+3);
expenseForm.setEmployee(expenseVO.getEmployee());
expenseForm.setEmployeeID(""+expenseVO.getEmployeeIDValue());
expenseForm.setProject(expenseVO.getProject());
expenseForm.setProjectID(""+expenseVO.getProjectIDValue());
expenseForm.setOpportunity(expenseVO.getOpportunity());
expenseForm.setOpportunityID(""+expenseVO.getOpportunityIDValue());
expenseForm.setSupportTicket(expenseVO.getSupportTicket());
expenseForm.setSupportTicketID(""+expenseVO.getSupportTicketIDValue());
expenseForm.setNotes(expenseVO.getNotes());
itemLines = expenseVO.getItemLines();
expenseForm.setItemLines(itemLines);
request.setAttribute("expenseform",expenseForm);
}// end of else if ( (request.getParameter("expenseid") != null))
else if( expenseID > 0 )
{
itemLines = expenseForm.getItemLines();
request.setAttribute("expenseform",expenseForm);
}//end of else if( expenseID > 0 )
// forward to jsp page
request.setAttribute("moduleName", "Expense");
request.setAttribute("ItemLines", itemLines);
FORWARD_final = FORWARD_editexpense;
} catch (Exception e)
{
logger.error("[Exception] DisplayExpenseHandler.Execute Handler ", e);
FORWARD_final = GLOBAL_FORWARD_failure;
}
return (mapping.findForward(FORWARD_final));
}
}