<?php

/*
 * 	This example demonstrates usage of the "list" function exposed by any
 *  Adabas SOA Gateway "WebService" from PHP, retrieving selected records
 *	from the Adabas demo file "Employees", and formatting it, in 4 easy steps.
 */


/*
 * 	Step 1: Instantiate the PHP "SoapClient" class
 */
try {
	$soapclient = new SoapClient("http://localhost:8022/adabas_Employees_special?WSDL");
} catch (SoapFault $soapfault) {
	echo "<pre>";
	print_r($soapfault);
	echo "</pre>";
	return;
}

/*
 * 	Step 2: Build the key ("descriptor") array, due to parser requirements ALL
 * 			key elements need to be specified, but elements may be left empty
 * 			when unused. Here we are using the SUB-descriptor "department".
 */
$listkey = array(
        'personnel_id' => "",
        'first_name'    => "",
        'name'                  => "",
        'birthday'              => "",
        'city'                  => "",
        'dept'=> "",
        'job_title'             => "",
        'language_spoken'=>"",
        'leave_left'    => "",
        'dept_person'   =>  "",
        'currency_salary'=> "",
        'department'    => array('dept' => "MGMT"),
        'phonetic_name' => "");

/*
 * 	Step 3:	Execute the "list" request, passing the key array as the only parameter,
 * 			the response object will consist of an "adabasEmployees" element containing
 * 			an array of "adabasEmployee" elements.
 */
try {
	$listresponse = $soapclient->list($listkey);
} catch (SoapFault $soapfault) {
	echo "<pre>";
	print_r($soapfault);
	echo "</pre>";
	return;
}

/*
 * 	Step 4:	Format the Employee records nicely into a HTML table.
 */

echo "Find all Employees in department group \"MGMT\" - using an Adabas SUB-Descriptor<br><br>";
echo "<table border=1 cellpadding=5>";
echo "<tr><th>Personnel Id</th><th>Name</th><th>First Name</th><th>City</th><th>Department</td>";

/*
 * 	Loop through all "adabasEmployee" elements, creating a table row for every single one
 */
foreach ($listresponse->adabasDemoEmployeesSpecial->demoEmployeeSpecial as $Employee) {
	echo 	"<tr><td>$Employee->personnel_id</td><td>$Employee->name</td><td>",
			"$Employee->first_name</td><td>$Employee->city</td><td>$Employee->department_code</td>";
	echo "</td></tr>";
}

/*
 * 	Proceed to ex03_SoaGatewayEmpAdd.php - Add a new employee record
 */
?>