// This file has been generated by NetDynamics Studio on Tue Apr. 06, 1999 09:35

package PrTITimeMgmt;

import java.awt.event.*;
import java.util.*;
import spider.event.*;
import spider.database.*;
import spider.visual.*;
import spider.*;
import spider.session.*;
import spider.util.*;
import spider.html.*;


//[[SPIDER_CLASS BEGIN
public class PgEnterTimeDay extends spider.visual.CSpPage
//]]SPIDER_CLASS END
{
	// This function returns a string that will be used in the INSERT
	public String setInsertHours()
	{
	  String sReturn;
	  String sMon = new String("0");
	  String sTue = new String("0");
	  String sWed = new String("0");
	  String sThu = new String("0"); 
	  String sFri = new String("0"); 
	  String sSat = new String("0"); 
	  String sSun = new String("0");
		
	  sReturn = sMon + ", " + sTue + ", " + sWed + ", " + sThu + ", " +
		sFri + ", " + sSat + ", " + sSun + ", ";
	  return sReturn;
	}
	
	// This function adds a time charge	
	public int addRecord()
	{
	  String sCurrProj, sCurrWorkplan, sCurrEndDate, sTaskValues;
	  String sPhase, sSegment, sStep, sTask,sSubTask, sUserID;
	  String sInsertHours, sSqlStatement;
	  CSpSelect doUserActivities;
	  int nRows;
	  StringTokenizer st;
	  String sETC = "null"; //JT 8-11-99

	  // Get all information needed to add time
	  // Get Project
	  sCurrProj = CSpider.getUserSessionObject("soCurrProj").toString();
	
	  // Get Workplan
	  sCurrWorkplan = CSpider.getUserSessionObject("soCurrWorkPlan").toString();
	
	  // Get Week Ending Date
	  sCurrEndDate = CSpider.getUserSessionObject("soWeekEndDate").toString();
	
	  // Get activity info
	  sTaskValues = getDisplayFieldValue("CboBudgetTasks").toString();
	  st = new StringTokenizer(sTaskValues,",");
	  sPhase = st.nextToken();
	  sSegment = st.nextToken();
	  sStep = st.nextToken();
	  sTask = st.nextToken();
	  sSubTask = st.nextToken();
	  sUserID = CSpider.getUserSessionObject("soUserID").toString();
		
	  // Check if row already exists
	  doUserActivities = (CSpSelect) CSpider.getDataObject("doActivityDisplay");
	  doUserActivities.clearDynamicCriteria();
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.iproj_id = '" + 
		sCurrProj.toString() + "'");
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.iproj_wp_nm = '" +
		sCurrWorkplan.toString() + "'");
	  doUserActivities.addDynamicStrCriterion("iproj_wp.wp_phs_cd = '" + sPhase + "'");
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.wp_seg_cd = '" + sSegment + "'");
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.wp_step_cd = '" + sStep + "'");
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.wp_task_cd = '" + sTask + "'");
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.wp_sub_task_id = '"+sSubTask+"'");
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.user_id = '"+sUserID+"'");
	  doUserActivities.addDynamicStrCriterion("w_iproj_wp_user.wk_end_dt = '" + sCurrEndDate
		+ "'");
	  doUserActivities.execute();
	  nRows = doUserActivities.getNumOfRows();
	
	  //Either insert or update depending on existence of row	
	  if (nRows == 0){// If new task for the week

		//JT 8-11-99 commented next line since Rick never used it
//		sInsertHours = setInsertHours();
		
		//JT 8-11-99 add this if statement
		// if workplan is ADMIN, set ETC to zero so user won't have to enter it
		if (sCurrWorkplan.equals("Administration") )
			sETC = "0";
		
		sSqlStatement = new String("INSERT INTO w_iproj_wp_user " +
		"(iproj_id, iproj_wp_nm, wp_phs_cd, wp_seg_cd, wp_step_cd, " +
		"wp_task_cd, wp_sub_task_id, user_id, wk_end_dt, " +
		//JT 8-11-99 replace next line to include ETC hrs in SQL
//		"apprv_flg) " +
		"user_task_etc_hrs, apprv_flg) " +
		"VALUES ('" + sCurrProj + "', '" + sCurrWorkplan + "', " + sPhase + ", " +
		sSegment + ", " + sStep +", " + sTask +", '" + sSubTask + "', '"
		//JT 8-11-99 replace next line to include ETC hrs in SQL 
//		+ sUserID + "', '" + sCurrEndDate + "', 'N')");
		+ sUserID + "', '" + sCurrEndDate + "'," + sETC + ", 'N')");
	
		//CSpider.putUserSessionObject("soDisplay", new CSpString(sSqlStatement));
		CSpDataObject.executeImmediate("dsTimeTrackDB",sSqlStatement);
	  }
	  else{// Task already has an entry for the week
		return 1;
	  }
	  return 0;
	}

	//this function populates the Task drop-down
	//it is called when:  user selects the ADMIN Project AND
	//when user hits GO after selecting a Workplan
	public void populateTaskDropDown(CSpValue vWorkplan)
	{
		int nPhase, nSegment, nStep, nTask, nSubTask, rows;
		CSpValue sPhaseCd, sSegmentCd, sStepCd, sTaskCd, sSubTaskId;
		String sIndex, sPhase, sSegment, sStep, sTask, sSubTask, sListLabel;
		CSpSelect doPhase,doSegment,doStep,doTask,doBudgetTasks;
		CSpSelect doAddlSeg, doAddlStep, doAddlTask;
		CSpValue vProjID;
		CSpComboBox cboTasks;
		CSpString sListValue;
		
		//Get the project
		vProjID = CSpider.getUserSessionObject("soCurrProj");

	    //Clear the tasks list box
		cboTasks= (CSpComboBox)getDisplayField("CboBudgetTasks");
		cboTasks.removeAllChildren(true);
		cboTasks.addSelectable("<Select one>", new CSpString("none"));
		
	    //Get the tasks for the workplan
		doBudgetTasks = (CSpSelect)CSpider.getDataObject("doBudgetTasks");
		doBudgetTasks.clearDynamicCriteria();
		
	    //Set the select criteria
		doBudgetTasks.addDynamicStrCriterion("iproj_wp.iproj_id = '" + 
		  vProjID.toString() + "'");
		doBudgetTasks.addDynamicStrCriterion("iproj_wp.iproj_wp_nm = '" +
		  vWorkplan.toString() + "'");
		
		CSpHtml.sendMessage("vProjID = " + vProjID.toString() + "<BR>");
		CSpHtml.sendMessage("vWorkplan = " + vWorkplan.toString() + "<BR>");
		
	    //Execute the select
		doBudgetTasks.execute();
		
	    //Get the data indices
		nPhase = doBudgetTasks.getDataFieldPosition(
		  "wp_phs_cd");
		nSegment = doBudgetTasks.getDataFieldPosition(
		  "informix_iproj_wp_bdgt_wp_seg_cd");
		nStep = doBudgetTasks.getDataFieldPosition(
		  "informix_iproj_wp_bdgt_wp_step_cd");
		nTask = doBudgetTasks.getDataFieldPosition(
		  "informix_iproj_wp_bdgt_wp_task_cd");
		nSubTask = doBudgetTasks.getDataFieldPosition(
		  "informix_iproj_wp_bdgt_wp_sub_task_id");
		
	    //Create the list box	 
		rows = doBudgetTasks.getNumOfRows();
		for(int i = 0; i < rows; i++){
		  //get phase
		  sPhaseCd = doBudgetTasks.getValue(i, nPhase);
		  doPhase = (CSpSelect) CSpider.getDataObject("doPhase");
		  doPhase.clearDynamicCriteria();
		  doPhase.addDynamicStrCriterion("wp_phs_cd = '" + sPhaseCd + "'");
		  doPhase.execute();
		  if(vProjID.toString().compareTo("ADMIN")==0){
			sPhase = "";
		  }
		  else{
			sPhase = doPhase.getValue(0,
			  "informix_wp_phs_dspl_wp_phs_cd").toString();
		  }
		  
		  //get segment
		  sSegmentCd = doBudgetTasks.getValue(i,nSegment);
		  if(sSegmentCd.intValue() != 0){// if segment
			doSegment = (CSpSelect) CSpider.getDataObject("doSegment");
			doSegment.clearDynamicCriteria();
			doSegment.addDynamicStrCriterion("wp_phs_cd = '" + sPhaseCd + "'");
			doSegment.addDynamicStrCriterion("wp_seg_cd = '" + sSegmentCd + "'");
			doSegment.execute();
			if(doSegment.getNumOfRows()>0){
			  sSegment = doSegment.getValue(0,
				"informix_wp_seg_wp_seg_desc").toString();
			}
			else{
			  doAddlSeg = (CSpSelect)CSpider.getDataObject("doAddlSeg");
			  doAddlSeg.clearDynamicCriteria();
			  doAddlSeg.addDynamicStrCriterion("iproj_id = '" + 
				vProjID.toString() + "'");
			  doAddlSeg.addDynamicStrCriterion("iproj_wp_nm = '" +
				vWorkplan.toString() + "'");
			  doAddlSeg.addDynamicStrCriterion("wp_phs_cd = " + sPhaseCd);
			  doAddlSeg.addDynamicStrCriterion("wp_addl_seg_cd = "+ sSegmentCd);
			  doAddlSeg.execute();
			  sSegment = doAddlSeg.getValue(0,
				"wp_addl_seg_desc").toString();
			}
			//JT 9-20-99 if not the ADMIN, workplan, add Index as Prefix
			if (!vProjID.toString().equals("ADMIN")){
			  sIndex = sPhaseCd.toString() + "." + sSegmentCd.toString() + " ";
			  sSegment = sIndex + sSegment;	 			
			}
		  }
		  else{
			sSegment = "";			
		  }
		  
		  //get step
		  sStepCd = doBudgetTasks.getValue(i,nStep);
		  if(sStepCd.intValue() != 0){// if step
			doStep = (CSpSelect) CSpider.getDataObject("doStep");
			doStep.clearDynamicCriteria();
			doStep.addDynamicStrCriterion("wp_phs_cd = '" + sPhaseCd + "'");
			doStep.addDynamicStrCriterion("wp_seg_cd = '" + sSegmentCd + "'");
			doStep.addDynamicStrCriterion("wp_step_cd = '" + sStepCd + "'");
			doStep.execute();
			if(doStep.getNumOfRows() > 0){
			  sStep = doStep.getValue(0,
				"informix_wp_step_wp_step_desc").toString();
			}
			else{
			  doAddlStep = (CSpSelect)CSpider.getDataObject("doAddlStep");
			  doAddlStep.clearDynamicCriteria();
			  doAddlStep.addDynamicStrCriterion("iproj_id = '" + 
				vProjID.toString() + "'");
			  doAddlStep.addDynamicStrCriterion("iproj_wp_nm = '" +
				vWorkplan.toString() + "'");
			  doAddlStep.addDynamicStrCriterion("wp_phs_cd = " + sPhaseCd);
			  doAddlStep.addDynamicStrCriterion("wp_seg_cd = "+ sSegmentCd);
			  doAddlStep.addDynamicStrCriterion("wp_addl_step_cd = " +sStepCd);
			  doAddlStep.execute();
			  sStep = doAddlStep.getValue(0,
				"wp_addl_step_desc").toString();
			}
			//JT 9-20-99 if not the ADMIN, workplan, add Index as Prefix
			if (!vProjID.toString().equals("ADMIN")){
			  sIndex = "  " + sPhaseCd.toString() + "." + sSegmentCd.toString() +
					 "." + sStepCd.toString()+ " ";
			  sStep = " -> " + sIndex + sStep;  	 			
			}
		  }
		  else{
			sStep = "";
		  }
			
		  //get task
		  sTaskCd = doBudgetTasks.getValue(i,nTask);
		  if(sTaskCd.intValue() != 0){ // if Task
			doTask = (CSpSelect) CSpider.getDataObject("doTask");
			doTask.clearDynamicCriteria();
			doTask.addDynamicStrCriterion("wp_phs_cd = '" + sPhaseCd + "'");
			doTask.addDynamicStrCriterion("wp_seg_cd = '" + sSegmentCd + "'");
			doTask.addDynamicStrCriterion("wp_step_cd = '" + sStepCd + "'");
			doTask.addDynamicStrCriterion("wp_task_cd = '" + sTaskCd + "'");
			doTask.execute();
			if(vProjID.toString().compareTo("ADMIN")==0){
			  sTask = doTask.getValue(0,
				"informix_wp_task_wp_task_desc").toString();
			}
			else{
			  if(doTask.getNumOfRows()>0){
				sTask = doTask.getValue(0,
				  "informix_wp_task_wp_task_desc").toString();
			  }
			  else{
				doAddlTask = (CSpSelect)CSpider.getDataObject("doAddlTask");
				doAddlTask.clearDynamicCriteria();
				doAddlTask.addDynamicStrCriterion("iproj_id = '" + 
				  vProjID.toString() + "'");
				doAddlTask.addDynamicStrCriterion("iproj_wp_nm = '" +
				  vWorkplan.toString() + "'");
				doAddlTask.addDynamicStrCriterion("wp_phs_cd = " + sPhaseCd);
				doAddlTask.addDynamicStrCriterion("wp_seg_cd = "+ sSegmentCd);
				doAddlTask.addDynamicStrCriterion("wp_step_cd = "+sStepCd);
				doAddlTask.addDynamicStrCriterion("wp_addl_task_cd = "+sTaskCd);
				doAddlTask.execute();
				sTask = doAddlTask.getValue(0,
				  "wp_addl_task_desc").toString();
			  }
			  
			}
			//JT 9-20-99 if not the ADMIN, workplan, add Index as Prefix
			if (!vProjID.toString().equals("ADMIN")){
			  sIndex = "  " + sPhaseCd.toString() + "." + sSegmentCd.toString() +
					 "." + sStepCd.toString() + "." + sTaskCd.toString() + " ";
			  sTask = " -> " + sIndex + sTask;  	 			
			}
		  }
		  else{
			sTask = "";
		  }
		  
		  //get sub task
		  sSubTaskId = doBudgetTasks.getValue(i,nSubTask);
		  if(sSubTaskId.toString().compareTo("0") != 0){
			sSubTask = " -> " + sSubTaskId.toString();
		  }
		  else{
			sSubTask = "";
		  }
		  
		  //add final string
		  sListLabel = sSegment + sStep + sTask +sSubTask;
		  sListValue = new CSpString(sPhaseCd.toString() + "," + 
			sSegmentCd.toString() + "," + sStepCd.toString() + "," +
			sTaskCd.toString() + "," + sSubTaskId.toString());
		  
		  //JT 9-20-99 if NOT the "Phase row", then add row to the ListBox
		  if (! (sSegmentCd.equals("0")&& sStepCd.equals("0") && sTaskCd.equals("0"))){
		  	cboTasks.addSelectable(sListLabel, sListValue);
		  }
		}
	}//end of populateTaskDropDown()

	//[[SPIDER_EVENTS BEGIN

	//[[SPIDER_EVENT<CboProjects_onBeforeDisplayEvent>
	public int CboProjects_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpComboBox cbo = (CSpComboBox)getDisplayField("CboProjects");
		cbo.doAutoFill();
		
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		
		if(val.toString().compareTo("1")!=0)
		{ //if not the first time page is displayed, default the Project
		  CSpString currProj = (CSpString)CSpider.getUserSessionObject("soCurrProj");
		  setDisplayFieldValue("CboProjects",currProj);
		}
		return (PROCEED);
	}
	//]]SPIDER_EVENT<CboProjects_onBeforeDisplayEvent>
	
	//[[SPIDER_EVENT<BtnProject_onWebEvent>
	public int BtnProject_onWebEvent(CSpWebEvent event)
	{
		CSpValue vProjID = getDisplayFieldValue("CboProjects");
		CSpider.putUserSessionObject("soCurrProj", vProjID);
		
		//if user selected the ADMIN project 
		if (vProjID.toString().equals("ADMIN"))
		{	//default the PhaseCd and Workplan session objects
			CSpider.putUserSessionObject("soCurrPhase", new CSpString("0"));
			CSpider.putUserSessionObject("soCurrWorkPlan", 
					new CSpString("Administration"));
					
			//set flag, which is used to: jump down to the Task drop-down,
			//and also hide both the Phase and Workplan drop-downs
			CSpider.putUserSessionObject("soTimeEntryFlag", new CSpString("5"));
			
			//populate the Task drop-down, pass in the Workplan name
			populateTaskDropDown(new CSpString("Administration"));
		}
		else
		{	//set flag to display the Phase drop-down next
			CSpider.putUserSessionObject("soTimeEntryFlag", new CSpString("2"));
			
			//set the dyn criteria to filter the Phase drop-down
			CSpSelect doGetPhases = (CSpSelect)CSpider.getDataObject("doGetPhases");
			doGetPhases.clearDynamicCriteria();
			doGetPhases.addDynamicStrCriterion
						("iproj.iproj_id = '" + vProjID.toString() + "'");
		}
		
		int command = PROCEED;
		command = doAction(event);
		return(command);
	}
	//]]SPIDER_EVENT<BtnProject_onWebEvent>

	//[[SPIDER_EVENT<TxtPhase_onBeforeDisplayEvent>
	public int TxtPhase_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("5")==0){
		  return(SKIP);
		}
		return (PROCEED);
	}
	//]]SPIDER_EVENT<TxtPhase_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<CboPhase_onBeforeDisplayEvent>
	public int CboPhase_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("5")==0){
		  return(SKIP);
		}
		
		CSpComboBox cbo = (CSpComboBox)getDisplayField("CboPhase");
		cbo.doAutoFill();
		if( val.toString().compareTo("3")==0 ||
			val.toString().compareTo("4")==0){
		  CSpString currProj = (CSpString)CSpider.getUserSessionObject("soCurrPhase");
		  
		  //default the Phase
		  setDisplayFieldValue("CboPhase",currProj);
		}
		return (PROCEED);
	}
	//]]SPIDER_EVENT<CboPhase_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<BtnPhase_onBeforeDisplayEvent>
	public int BtnPhase_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("5")==0){
		  return(SKIP);
		}
		return (PROCEED);
	}
	//]]SPIDER_EVENT<BtnPhase_onBeforeDisplayEvent>
	
	//[[SPIDER_EVENT<BtnPhase_onWebEvent>
	public int BtnPhase_onWebEvent(CSpWebEvent event)
	{
		String sProjID = CSpider.getUserSessionObject("soCurrProj").toString();
		String sPhaseCd;
		
		//set the dyn criteria to filter the Workplan drop-down
		sPhaseCd = getDisplayFieldValue("CboPhase").toString();
		CSpSelect doWorkplan = (CSpSelect) CSpider.getDataObject("doWorkplan");
		doWorkplan.clearDynamicCriteria();
		doWorkplan.addDynamicStrCriterion("iproj_wp.iproj_id = '" +  sProjID + "'");
		doWorkplan.addDynamicStrCriterion("iproj_wp.wp_phs_cd = '" + sPhaseCd + "'");
		
		CSpider.putUserSessionObject("soCurrPhase", new CSpString(sPhaseCd));
		CSpider.putUserSessionObject("soTimeEntryFlag", new CSpString("3"));
		
		int command = PROCEED;
		command = doAction(event);
		return(command);
	}
	//]]SPIDER_EVENT<BtnPhase_onWebEvent>
	
	//[[SPIDER_EVENT<TxtWorkplan_onBeforeDisplayEvent>
	public int TxtWorkplan_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("5")==0){
		  return(SKIP);
		}
		return (PROCEED);
	}
	//]]SPIDER_EVENT<TxtWorkplan_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<CboWorkplans_onBeforeDisplayEvent>
	public int CboWorkplans_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("5")==0){
		  return(SKIP);
		}
		
		CSpComboBox cbo = (CSpComboBox)getDisplayField("CboWorkplans");
		cbo.doAutoFill();
		
		if(val.toString().compareTo("4")==0){
		 CSpString currProj = 
			(CSpString)CSpider.getUserSessionObject("soCurrWorkPlan");
			
		//default the Workplan
		setDisplayFieldValue("CboWorkplans",currProj);
		}
		return (PROCEED);
	}
	//]]SPIDER_EVENT<CboWorkplans_onBeforeDisplayEvent>
	
	//[[SPIDER_EVENT<BtnWorkplan_onBeforeDisplayEvent>
	public int BtnWorkplan_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("5")==0){
		  return(SKIP);
		}
		return (PROCEED);
	}
	//]]SPIDER_EVENT<BtnWorkplan_onBeforeDisplayEvent>
	
	//[[SPIDER_EVENT<BtnWorkplan_onWebEvent>
	public int BtnWorkplan_onWebEvent(CSpWebEvent event)
	{
		//Get the workplan
		CSpValue vWorkplan = getDisplayFieldValue("CboWorkplans");
		
		//populate the Task drop-down, pass in the Workplan name
		populateTaskDropDown(vWorkplan);
		
		CSpider.putUserSessionObject("soTimeEntryFlag", new CSpString("4"));
		CSpider.putUserSessionObject("soCurrWorkPlan", vWorkplan);
		
		int command = PROCEED;
		command = doAction(event);
		return(command);
	}
	//]]SPIDER_EVENT<BtnWorkplan_onWebEvent>

	//[[SPIDER_EVENT<TxtActivities_onBeforeDisplayEvent>
	public int TxtActivities_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("3")==0){
		  return(SKIP);
		}
		return (PROCEED);//flag = 4 or 5
	}
	//]]SPIDER_EVENT<TxtActivities_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<CboBudgetTasks_onBeforeDisplayEvent>
	public int CboBudgetTasks_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("3")==0){
		  return(SKIP);
		}
		
		CSpComboBox cbo = (CSpComboBox)getDisplayField("CboBudgetTasks");
		cbo.doAutoFill();
		
		//if Add&Contnue or Add My Tasks buttons were pressed; i.e flag=true
		if(CSpider.getUserSessionObject("soCurrTaskDefaultFlag").booleanValue()){

		  CSpString sTask = (CSpString)CSpider.getUserSessionObject("soCurrTask");
		  
		  //default the Task
		  setDisplayFieldValue("CboBudgetTasks", sTask);
		
		  //reset the flag
		  CSpider.putUserSessionObject("soCurrTaskDefaultFlag", new CSpBoolean(false));
		}

		return (PROCEED);//flag = 4 or 5
	}
	//]]SPIDER_EVENT<CboBudgetTasks_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<BtnDone_onBeforeDisplayEvent>
	public int BtnDone_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("3")==0){
		  return(SKIP);
		}
		return (PROCEED);//flag = 4 or 5
	}
	//]]SPIDER_EVENT<BtnDone_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<BtnContinue_onBeforeDisplayEvent>
	public int BtnContinue_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("3")==0){
		  return(SKIP);
		}
		return (PROCEED);//flag = 4 or 5
	}
	//]]SPIDER_EVENT<BtnContinue_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<BtnAddFUT_onBeforeDisplayEvent>
	public int BtnAddFUT_onBeforeDisplayEvent(CSpDisplayEvent event)
	{
		CSpValue val = CSpider.getUserSessionObject("soTimeEntryFlag");
		if( val.toString().compareTo("1")==0 ||
			val.toString().compareTo("2")==0 ||
			val.toString().compareTo("3")==0){
		  return(SKIP);
		}
		return (PROCEED);//flag = 4 or 5
	}
	//]]SPIDER_EVENT<BtnAddFUT_onBeforeDisplayEvent>

	//[[SPIDER_EVENT<BtnDone_onWebEvent>
	public int BtnDone_onWebEvent(CSpWebEvent event)
	{
		int error = addRecord();
		CSpButton btnAdd = (CSpButton)getDisplayField("BtnDone");
		if(error == 1){
		  CSpString sErrMsg = new CSpString(
			"The task you are trying to add is already on<BR>the " +
			"current week's timesheet.");
		  CSpider.putUserSessionObject("soErrMsg",sErrMsg);
		  btnAdd.setTargetNDPage(new CSpCommonPageRef("PgErrorPage"));
		  int command = PROCEED;
		  command = doAction(event);
		  return(command);
		}
		btnAdd.setTargetNDPage(new CSpCommonPageRef("PgEnterTimeCalendar"));
		
		int command = PROCEED;
		command = doAction(event);
		return(command);
	}
	//]]SPIDER_EVENT<BtnDone_onWebEvent>
	
	//[[SPIDER_EVENT<BtnContinue_onWebEvent>
	public int BtnContinue_onWebEvent(CSpWebEvent event)
	{
		CSpButton btnAdd = (CSpButton)getDisplayField("BtnContinue");
		int command = PROCEED;
		int error = addRecord();
		
		if(error == 1){
		  CSpString sErrMsg = new CSpString(
			"The task you are trying to add is already on<BR>the " +
			"current week's timesheet.");
		  CSpider.putUserSessionObject("soErrMsg",sErrMsg);
		  
		  command = load("PgErrorPage");
		  return(command);
		}
		
		//JT 10-26-99
		// set flag to default Task when this page is reloaded
	 	CSpider.putUserSessionObject("soCurrTaskDefaultFlag", new CSpBoolean(true));
	  
	 	//Store display value the selected task so it can be restored when
		//this page is reloaded
		String sTask = getDisplayFieldValue("CboBudgetTasks").toString();
		CSpider.putUserSessionObject("soCurrTask", new CSpString(sTask));
	  
		CSpHtml.sendMessage("sTask = " + sTask + "<BR>");
		
	    //load same page...which will Default the Tasks drop-down to the one the 
	    //user just selected.
	    		
		command = load("PgEnterTimeDay");
		return(command);
	}
	//]]SPIDER_EVENT<BtnContinue_onWebEvent>
	
	//[[SPIDER_EVENT<BtnAddFUT_onWebEvent>
	public int BtnAddFUT_onWebEvent(CSpWebEvent event)
	{
	  String sCurrProj, sCurrWorkplan, sCurrEndDate, sTaskValues;
	  String sPhase, sSegment, sStep, sTask,sSubTask, sUserID;
	  String sInsertHours, sSqlStatement;
	  CSpSelect doUserActivities;
	  int nRows;
	  StringTokenizer st;
	  CSpButton btnAdd = (CSpButton)getDisplayField("BtnAddFUT");
	  
	  // Get all information needed to add time
	  // Get Project
	  sCurrProj = CSpider.getUserSessionObject("soCurrProj").toString();
	
	  // Get Workplan
	  sCurrWorkplan = CSpider.getUserSessionObject("soCurrWorkPlan").toString();
	
	  // Get Week Ending Date
	  sCurrEndDate = CSpider.getUserSessionObject("soWeekEndDate").toString();
		
	  // Get activity info
	  sTaskValues = getDisplayFieldValue("CboBudgetTasks").toString();
	  st = new StringTokenizer(sTaskValues,",");
	  sPhase = st.nextToken();
	  sSegment = st.nextToken();
	  sStep = st.nextToken();
	  sTask = st.nextToken();
	  sSubTask = st.nextToken();
	  sUserID = CSpider.getUserSessionObject("soUserID").toString();
	 
	 sSqlStatement = new String("INSERT INTO ttrk_user_iproj_wp " +
		"(iproj_id, iproj_wp_nm, wp_phs_cd, wp_seg_cd, wp_step_cd, " +
		"wp_task_cd, wp_sub_task_id, user_id) " +
		"VALUES ('" + sCurrProj + "', '" + sCurrWorkplan + "', " + sPhase + ", " +
		sSegment + ", " + sStep +", " + sTask +", '" + sSubTask + "', '"
		+ sUserID +"')");
	
	  //CSpider.putUserSessionObject("soDisplay", new CSpString(sSqlStatement));
	  CSpDataObject.executeImmediate("dsTimeTrackDB",sSqlStatement);
	  
	  //JT later...NOTE: Rick has NO SQL error chking here, not good!

	  //JT 10-26-99
	  // set flag to default Task when this page is reloaded
	  CSpider.putUserSessionObject("soCurrTaskDefaultFlag", new CSpBoolean(true));

	  //Store display value the selected task so it can be restored when
	  //this page is reloaded
	  sTask = getDisplayFieldValue("CboBudgetTasks").toString();
	  CSpider.putUserSessionObject("soCurrTask", new CSpString(sTask));
	  
	  CSpHtml.sendMessage("sTask = " + sTask + "<BR>");
	  
	  //load same page...which will Default the Tasks drop-down to the one the 
	  //user just selected.
	  btnAdd.setTargetNDPage(new CSpCommonPageRef("PgEnterTimeDay"));
	  	  
	  int command = PROCEED;
	  command = doAction(event);
		
	  return(command);
	}
	//]]SPIDER_EVENT<BtnAddFUT_onWebEvent>
	
	//[[SPIDER_EVENT<BtnCancel_onWebEvent>
	public int BtnCancel_onWebEvent(CSpWebEvent event)
	{
		int command = PROCEED;
		command = doAction(event);
		return(command);
	}
	//]]SPIDER_EVENT<BtnCancel_onWebEvent>


	//[[SPIDER_EVENT<BtnMainMenu_onWebEvent>
	public int BtnMainMenu_onWebEvent(CSpWebEvent event)
	{
		int command = PROCEED;
		command = doAction(event);
		return(command);
	}
	//]]SPIDER_EVENT<BtnMainMenu_onWebEvent>

	//]]SPIDER_EVENTS END
}