legalcase/inc inc_obj_fu.php,1.26,1.27

Update of /cvsroot/legalcase/legalcase/inc
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv464

Modified Files:
	inc_obj_fu.php 
Log Message:
add use of id_stage in stage changes

Index: inc_obj_fu.php
===================================================================
RCS file: /cvsroot/legalcase/legalcase/inc/inc_obj_fu.php,v
retrieving revision 1.26
retrieving revision 1.27
diff -C2 -d -r1.26 -r1.27
*** inc_obj_fu.php	1 Feb 2008 21:48:35 -0000	1.26
--- inc_obj_fu.php	7 Apr 2008 19:13:03 -0000	1.27
***************
*** 274,278 ****

  			// Get stage of the follow-up entry
! 			$q = "SELECT case_stage FROM lcm_followup WHERE id_followup = $id_followup";
  			$result = lcm_query($q);

--- 274,278 ----

  			// Get stage of the follow-up entry
! 			$q = "SELECT id_stage, case_stage FROM lcm_followup WHERE id_followup = $id_followup";
  			$result = lcm_query($q);

***************
*** 301,309 ****

  			// Get the current case stage
! 			$q = "SELECT stage FROM lcm_case WHERE id_case=" . $this->getDataInt('id_case', '__ASSERT__');
  			$result = lcm_query($q);

  			if ($row = lcm_fetch_array($result)) {
  				$case_stage = lcm_assert_value($row['stage']);
  			} else {
  				lcm_panic("There is no such case (" . $this->getDataInt('id_case') . ")");
--- 301,310 ----

  			// Get the current case stage
! 			$q = "SELECT id_stage, stage FROM lcm_case WHERE id_case=" . $this->getDataInt('id_case', '__ASSERT__');
  			$result = lcm_query($q);

  			if ($row = lcm_fetch_array($result)) {
  				$case_stage = lcm_assert_value($row['stage']);
+ 				$case_stage_id = lcm_assert_value($row['id_stage']);
  			} else {
  				lcm_panic("There is no such case (" . $this->getDataInt('id_case') . ")");
***************
*** 313,319 ****
  			$q = "INSERT INTO lcm_followup
  					SET id_case=" . $this->getDataInt('id_case') . ",
! 					id_author=" . $GLOBALS['author_session']['id_author'] . ",
! 					$fl,
! 					case_stage='$case_stage'";
  	
  			lcm_query($q);
--- 314,321 ----
  			$q = "INSERT INTO lcm_followup
  					SET id_case=" . $this->getDataInt('id_case') . ",
! 						id_author=" . $GLOBALS['author_session']['id_author'] . ",
! 						$fl,
! 						id_stage = $case_stage_id,
! 						case_stage='$case_stage'";
  	
  			lcm_query($q);

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Register now and save $200. Hurry, offer ends at 11:59 p.m., 
Monday, April 7! Use priority code J8TLD2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone