Anonymous

<?php
session_start();

	//clears all session data - debugging only
	//unset($_SESSION['part_form']);
	
if(isset($_SESSION["wo_complete"], $_SESSION["parts_complete"])) 
{
		
echo "<strong>ECN  details</strong><br />";	
	// displays progressive results
foreach($_SESSION['add_ecn'] as $add_ecn)
	{
       // print_r($add_ecn);
		
		print('<br /><strong>Date raised:</strong> '.$add_ecn['Date_raised'].'<br />');
		print('<strong>Implementation date:</strong> '.$add_ecn['Imp_Date'].'<br />');
		print('<strong>Units affected:</strong> '.$add_ecn['Units_affected'].'<br />');
		print('<strong>Reason for change:</strong> '.$add_ecn['Reason_Chng'].'<br />');
		print('<strong>Assembly updated:</strong> '.$add_ecn['Assem_Details'].' ');
		print('<strong>New assembly:</strong> '.$add_ecn['assem_new'].'<br />');
		print('<strong>Drawing details:</strong> '.$add_ecn['Draw_detail'].'<br />');
		
		}

echo "<br /><strong>Parts affected </strong><br />";	
foreach($_SESSION['part_form'] as $part_form)
	{
        //print_r($part_form);
		print('<br /><strong>Part number:</strong> '.$part_form['txtSearch'].'<br />');
		print('<strong>Part quanitity:</strong> '.$part_form['part_qty'].'<br />');
		print('<strong>Part action:</strong> '.$part_form['part_num_action'].'<br />');
	}
	echo "<br /><strong>Works orders </strong><br />";
	// displays progressive results
	foreach($_SESSION['wo_form'] as $part)
		{
		print(''.$part['Wo_details'].'<br />');
		}
	
	echo "<br />Are these details correct? If not please use the navigation buttons and make changes where neccescary.";
	
	}
//insert data into db
elseif(isset($_POST["ecn_create"]))
{
//initiate connection to mysql
	include 'inc/config.php';
	include 'inc/opendb.php';
	
//we need to create the ecn_notes entry first to produce an ECN number
echo "Loading ECN data...<br />";
$add_ecn=$_SESSION['add_ecn'];

echo "Filtering for query...<br />";
$insert = array();
foreach($add_ecn as $key => $value)
{
    //keys which we dont want to add
	if($key == 'nextstep'
     AND $key == 'planning')
        continue;  
     $insert[] = $key.' = "'.$value.'"';
}


//       	$add_code = "INSERT INTO `callreg_tbl` ( `pcode` , `instock` , `nilstock` , `Reasoncode` ,  `date` , `userid` , `whs` ) VALUES ( '$pcode', '$instock', '$nilstock', '$reasoncode', '$date', '$userid', '$whs' )";
		echo "Inserting ECN data to mysql...<br />";
		mysql_query("INSERT INTO `Ecn_Notes`".implode(',',$insert));
		$add_code = "FLUSH PRIVILEGES";
		mysql_query($add_code) or die('Error, insert query failed');
 
//		print('<br /><strong>Date raised:</strong> '.$add_ecn['Date_raised'].'<br />');
//		print('<strong>Implementation date:</strong> '.$add_ecn['Imp_Date'].'<br />');
//		print('<strong>Units affected:</strong> '.$add_ecn['Units_affected'].'<br />');
//		print('<strong>Reason for change:</strong> '.$add_ecn['Reason_Chng'].'<br />');
//		print('<strong>Assembly updated:</strong> '.$add_ecn['Assem_Details'].' ');
//		print('<strong>New assembly:</strong> '.$add_ecn['assem_new'].'<br />');
//		print('<strong>Drawing details:</strong> '.$add_ecn['Draw_detail'].'<br />');
		
	
echo "Closing connection...<br />";
		include 'inc/closedb.php';

}
else
{
	echo "Something went wrong.";
}

?>	
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ECN Confirmation</title>
<script language="JavaScript" type="text/javascript" src="ajax_search.js"></script>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="confirmation"><input name="ecn_create" type="submit" value="Create ECN" />
</form>
</body>
</html>