Customers (Details Program)

Name: $CMNAME

City: $CMCITY

Country: $CMCOUNT

'; } PANEL='ListDetails' { DESC='Page body'; ITERATIONS='10'; DETAILS=' '; } PANEL='ListFooter' { DESC='Page footer'; DETAILS='

Customer Number	Order Number	Purchase Order / Description	Order Date	Order Status	Order Total
$OHCUST	$OHORD	$OHDESC	$OHORDT	$OHSTAT	$OHOTOT

Start a new program named customer_header.php using the \'SQL Page at a Time Maint\' template.

At the \'Additional Design Options\' step, accept the default options.

At the \'File Maintenance Options\' step, uncheck all options except \'Allow display of full record\'.

When prompted, add the file MU_CUSTF in XL_WEBDEMO and choose the fields CMCUST, CMNAME, CMADR1, CMCITY and CMCOUNT. The wizard will also prompt you to select fields for the single record display; choose any field (we won\'t be displaying this page anyway).

Change the \'A\' tag for the \'display\' action in the segment \'ListDetails\' to this:
```
    <a href="customer_detail.php?cmcust=$CMCUST">Orders</a>
    
```

Detail Program:

Start creating a new program named customer_detail.php using the \'SQL Record Listing\' template.

Add the file MU_ORDHL1 in XL_WEBDEMO.

Add the file MU_CUSTF in XL_WEBDEMO.

Choose the fields OHORD, OHDESC, OHORDT, OHSTAT and OHOTOT.

Add these lines to near the top of the program in your PHP:

	// Global variables should be defined here
	global $ww_custno;


	// retrieve the customer number parameter
	if (isset($_REQUEST[\'cmcust\']))
		$ww_custno = $_REQUEST[\'cmcust\'];

Choose the fields OHORD, OHDESC, OHORDT, OHSTAT and OHOTOT.

Replace the existing display() function with this new function

	   
function display()
{ 
	// Make all global variables available here
	foreach($GLOBALS as $arraykey=>$arrayvalue) 
	{
		global $$arraykey;
	}
	
	
	/*
	 *
	 *  Query to find the customer number, name, city, and country
	 *
	 */
	$query = "select CMCUST, CMNAME, CMCITY, CMCOUNT 
	              from XL_WEBDEMO/MU_CUSTF 
	              where CMCUST = $ww_custno";
	
	// Fetch rows for page: relative to initial cursor 
	if (!($stmt = db2_exec($db2conn, $query))) 
	{
		echo "<b>Error ".db2_stmt_error() .":".db2_stmt_errormsg(). "</b>"; 
		die;
	}
	
	$row = db2_fetch_assoc($stmt);
	
	$CMCUST = $row["CMCUST"];
	$CMNAME = $row["CMNAME"];
	$CMCITY = $row["CMCITY"];
	$CMCOUNT = $row["CMCOUNT"];
	
	
	
	
	/*
	 *
	 *  Query to find the orders for the customer
	 *
	 */			
	$query = "select OHORD, OHDESC, OHORDT, OHSTAT, OHOTOT, CMCUST, CMNAME, CMCITY, CMCOUNT  
	              from XL_WEBDEMO/MU_CUSTF inner join XL_WEBDEMO/MU_ORDHL1 on OHCUST=CMCUST 
	              where OHCUST = $ww_custno";
	
	// Fetch rows for page: relative to initial cursor 
	if (!($stmt = db2_exec($db2conn, $query))) 
	{
		echo "<b>Error ".db2_stmt_error() .":".db2_stmt_errormsg(). "</b>"; 
		die;
	}
	
	wrtseg("ListHeader");
	
	while ($row = db2_fetch_assoc($stmt))
	{
		// set color of the line
		xl_set_row_color(\'altcol1\', \'altcol2\');
		
	
		$OHORD = $row["OHORD"];
		$OHDESC = $row["OHDESC"];
		$OHORDT = $row["OHORDT"];
		$OHSTAT	= $row["OHSTAT"];
		$OHOTOT = $row["OHOTOT"];
		
		$mydate = strftime("%Y/%m/%d", strtotime($OHORDT));
		
		wrtseg("ListDetails");
		
		
	}
	
	// closet the database connection
	db2_close($db2conn);   
	
	wrtseg("ListFooter");	
	
}

Header Program Definition: customer_header.phw
Detail Program Definition: customer_detail.phw

Rate This Example

Did this knowledge base article help you to achieve your goal?	Yes	No	Don\'t Know

Enter additional comments below. If you want to hear back from us, include your contact information.

Example 143: Customer Header-Detail

Customers (Details Program)

Detail Program:

Rate This Example