Example #1
0
 $client = new SoapClient($wsdl, array("cache_wsdl" => WSDL_CACHE_NONE));
 $alias = "SX2";
 $deleted = false;
 $recno = false;
 $param = array("ALIAS" => $alias, "RDELETED" => $deleted);
 $result = $client->GETTRMAX($param);
 $tRMax = $result->GETTRMAXRESULT;
 $fields = $client->getTFieldsName($param);
 $array = $fields->GETTFIELDSNAMERESULT->UFLDNAME->STRING;
 $fNames = array("X2_CHAVE", "X2_TABELA", "X2_NOME", "X2_UNICO");
 $arrRemove = array_merge(array_diff($array, $fNames));
 $fields->GETTFIELDSNAMERESULT->UFLDNAME->STRING = array_merge(array_diff($array, $arrRemove));
 $fields = $fields->GETTFIELDSNAMERESULT;
 $where = "SubStr(X2_CHAVE,1,2)\$'SR/SP'";
 $param = array("ALIAS" => $alias, "RINIT" => 1, "REND" => $tRMax, "WHERE" => $where, "FIELDSNAME" => $fields, "RDELETED" => $deleted, "RRECNO" => $recno);
 $result = $client->GETTBYWHEREANDFIELDSNAME($param);
 echo "<table border='1' align='left'>";
 echo "<thead>";
 echo "<tr align='left'>";
 echo "<th>FLDNAME</th>";
 echo "<th>FLDTYPE</th>";
 echo "<th>FLDSIZE</th>";
 echo "<th>FLDDEC</th>";
 echo "<th>FLDTITLE</th>";
 echo "<th>FLDDESCRIPTION</th>";
 echo "<th>FLDMANDATORY</th>";
 echo "</tr>";
 echo "</thead>";
 echo "<tbody>";
 if (is_array($result->GETTBYWHEREANDFIELDSNAMERESULT->TABLESTRUCT->UFIELDSTRUCT)) {
     foreach ($result->GETTBYWHEREANDFIELDSNAMERESULT->TABLESTRUCT->UFIELDSTRUCT as $item) {