<?php
require('SOAP/Client.php');
$proxy = array('user' => 'bblier', 'pass' => 'maarch', 'timeout' => '600');
$wsdl = new SOAP_WSDL('http://127.0.0.1/maarch_entreprise/ws_server.php?WSDL', $proxy, false);
$client = $wsdl->getProxy();

session_start();

if ( isset($_REQUEST['Afficher']) && $_REQUEST['Afficher'] == 'Afficher la liste de contacts' ) {
    //Le formulaire a été validé

    if (    !empty($_REQUEST['contact_id'])
         || !empty($_REQUEST['lastname'])
         || !empty($_REQUEST['firstname'])
         || !empty($_REQUEST['society'])
         || !empty($_REQUEST['function'])
         || !empty($_REQUEST['address_num'])
         || !empty($_REQUEST['address_street'])
         || !empty($_REQUEST['address_complement'])
         || !empty($_REQUEST['address_town'])
         || !empty($_REQUEST['address_postal_code'])
         || !empty($_REQUEST['address_country'])
         || !empty($_REQUEST['email'])
         || !empty($_REQUEST['phone'])
         || !empty($_REQUEST['other_data'])
         || !empty($_REQUEST['is_corporate_preson'])
         || !empty($_REQUEST['user_id'])
         || !empty($_REQUEST['title'])
         || !empty($_REQUEST['enabled'])
    ) {
        $finalWhereClause = '';
        $andAffiche = 0;

        if (!empty($_REQUEST['methodSearch'])) {
            if ($_REQUEST['methodSearch'] == 'and') {
                $methodSearch = 'AND';
            }
            elseif ($_REQUEST['methodSearch'] == 'or') {
                $methodSearch = 'OR';
            }
            else {
                $methodSearch = 'AND';
            }
        }
        else {
            $methodSearch = 'AND';
        }

        if ( !empty($_REQUEST['contact_id']) ) {
            $finalWhereClause .= 'contact_id=';
            $finalWhereClause .= '\''.$_REQUEST['contact_id'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['lastname']) ) {
            $finalWhereClause .= 'lastname LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['lastname'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['firstname']) ) {
            $finalWhereClause .= 'firstname LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['firstname'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['society']) ) {
            $finalWhereClause .= 'society LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['society'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['function']) ) {
            $finalWhereClause .= 'function LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['function'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['address_num']) ) {
            $finalWhereClause .= 'address_num LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['address_num'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['address_street']) ) {
            $finalWhereClause .= 'address_street LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['address_street'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['address_complement']) ) {
            $finalWhereClause .= 'address_complement LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['address_complement'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['address_town']) ) {
            $finalWhereClause .= 'address_town LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['address_town'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['address_postal_code']) ) {
            $finalWhereClause .= 'address_postal_code LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['address_postal_code'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['address_country']) ) {
            $finalWhereClause .= 'address_country LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['address_country'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['email']) ) {
            $finalWhereClause .= 'email LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['email'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['phone']) ) {
            $finalWhereClause .= 'phone LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['phone'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['other_data']) ) {
            $finalWhereClause .= 'other_data LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['other_data'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['is_corporate_person']) ) {
            $finalWhereClause .= 'is_corporate_person LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['is_corporate_person'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['user_id']) ) {
            $finalWhereClause .= 'user_id LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['user_id'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['title']) ) {
            $finalWhereClause .= 'title LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['title'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ( !empty($_REQUEST['enabled']) ) {
            $finalWhereClause .= 'enabled LIKE ';
            $finalWhereClause .= '\''.$_REQUEST['enabled'].'\'';
            $andAffiche++;
        }
        if ($andAffiche != 0) { $finalWhereClause .= ' '.$methodSearch.' '; $andAffiche--; }

        if ($methodSearch == 'AND') {
            $finalWhereClauseTemp = substr($finalWhereClause, 0, -5);

        }
        elseif ($methodSearch == 'OR') {
            $finalWhereClauseTemp = substr($finalWhereClause, 0, -4);
        }
        else {
            $finalWhereClauseTemp = substr($finalWhereClause, 0, -4);
        }

        $finalWhereClause = $finalWhereClauseTemp;
    }
    elseif ( !empty($_REQUEST['clause']) ) {
        $finalWhereClause = $_REQUEST['clause'];
    }
    else {
        $finalWhereClause = '1=1';
    }

    $searchParamsForm = array("whereClause" => $finalWhereClause);
    $listContacts = $client->listContacts($searchParamsForm);

    /* TESTS & DEBUG */
    /* $debug = 'finalWhereClause : '.$finalWhereClause.'<br />';
    $debug .= 'whereClauseFormRecu : <br />';
    $debug .= '<pre>'.print_r($searchParamsForm, true).'</pre>';
    $debug .= '<hr />';
    $debug .= '<pre>'.print_r($client, true).'</pre>';
    $debug .= '<pre>'.print_r($listContacts, true).'</pre>';
    $debug .= '<pre>'.print_r($listContacts->value[0]->contact_id, true).'</pre>'; */


    $contactResult = '';
    $contactResult .= '<table border="1" cellpadding="3" style="background-color: #1F1FAF;">';
      $contactResult .= '<tr align="center" style="background-color: #1F1FAF; color: #FFFFFF;">';
        $contactResult .= '<td><b>';
          $contactResult .= 'contact_id';
          $contactResult .= '<br />';
          $contactResult .= '(Id)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'lastname';
          $contactResult .= '<br />';
          $contactResult .= '(Nom de famille)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'firstname';
          $contactResult .= '<br />';
          $contactResult .= '(Pr&eacute;nom)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'society';
          $contactResult .= '<br />';
          $contactResult .= '(Soci&eacute;t&eacute;)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'function';
          $contactResult .= '<br />';
          $contactResult .= '(Poste)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'address_num';
          $contactResult .= '<br />';
          $contactResult .= '(Num&eacute;ro)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'address_street';
          $contactResult .= '<br />';
          $contactResult .= '(Rue)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'address_complement';
          $contactResult .= '<br />';
          $contactResult .= '(Compl&eacute;ment d\'adresse)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'address_town';
          $contactResult .= '<br />';
          $contactResult .= '(Ville)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'address_postal_code';
          $contactResult .= '<br />';
          $contactResult .= '(Code postal)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'address_country';
          $contactResult .= '<br />';
          $contactResult .= '(Pays)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'email';
          $contactResult .= '<br />';
          $contactResult .= '(email)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'phone';
          $contactResult .= '<br />';
          $contactResult .= '(T&eacute;l&eacute;phone)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'other_data';
          $contactResult .= '<br />';
          $contactResult .= '(Autre)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'is_corporate_person';
          $contactResult .= '<br />';
          $contactResult .= '(Interne)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'user_id';
          $contactResult .= '<br />';
          $contactResult .= '(ID utilisateur)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'title';
          $contactResult .= '<br />';
          $contactResult .= '(Titre)';
        $contactResult .= '</b></td>';
        $contactResult .= '<td><b>';
          $contactResult .= 'enabled';
          $contactResult .= '<br />';
          $contactResult .= '(Activ&eacute;)';
        $contactResult .= '</b></td>';
      $contactResult .= '</tr>';


    $cpt = 0;
    $cptMax = count($listContacts->value);

    if (empty($listContacts->value)) {
        $contactResult .= '<tr style="background-color: #4F4FDF;" align="center">';
          $contactResult .= '<td colspan="18">';
            $contactResult .= 'Aucune corr&eacute;spondance';
          $contactResult .= '</td>';
        $contactResult .= '</tr>';
    }
    else {

        while ($cpt < $cptMax) {
            $contactResult .= '<tr style="background-color: #7F7FDF;">';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->contact_id;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->lastname;;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->firstname;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->society;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->function;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->address_num;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->address_street;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->address_complement;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->address_town;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->address_postal_code;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->address_country;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->email;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->phone;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->other_data;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->is_corporate_person;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->user_id;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->title;
              $contactResult .= '</td>';
              $contactResult .= '<td>';
                $contactResult .= $listContacts->value[$cpt]->enabled;
              $contactResult .= '</td>';
            $contactResult .= '</tr>';

            $cpt++;
        }
    }
    $contactResult .= '</table>';

    $contactResult .= '<br />';
    $contactResult .= '<a href="ws_client_contacts.php">';
      $contactResult .= 'Nouvelle recherche';
    $contactResult .= '</a>';

    /*
    'contact_id'=>'long',
    'lastname'=>'string',
    'firstname'=>'string',
    'society'=>'string',
    'function'=>'string',
    'address_num'=>'string',
    'address_street'=>'string',
    'address_complement'=>'string',
    'address_town'=>'string',
    'address_postal_code'=>'string',
    'address_country'=>'string',
    'email'=>'string',
    'phone'=>'string',
    'other_data'=>'string',
    'is_corporate_person'=>'string',
    'user_id'=>'string',
    'title'=>'string',
    'enabled'=>'string'
    */

}
else {
    $whereClauseForm = '<div align="center">';
      $whereClauseForm .= '<form action="" method="post">';
        $whereClauseForm .= '<div style="border: solid 1px; background-color: #CCCCCC; background-image: url(backgroundMaarch.png)">';
          $whereClauseForm .= '<br />';
          $whereClauseForm .= 'Laissez vide tous les champs pour avoir la liste compl&egrave;te';
          $whereClauseForm .= '<br />';
          $whereClauseForm .= '<br />';
        $whereClauseForm .= '</div>';
        $whereClauseForm .= '<h4>';
          $whereClauseForm .= 'OU';
        $whereClauseForm .= '</h4>';
        $whereClauseForm .= '<div style="border: solid 1px; background-color: #CCCCCC; background-image: url(backgroundMaarch.png)">';
          $whereClauseForm .= '<br />';
          $whereClauseForm .= '<b>Exemples de WHERE clause</b> <br />';
          $whereClauseForm .= 'Si l\'on recherche des habitant de <b>Cergy</b> dont l\'id est <b>100</b> :<br />';
          $whereClauseForm .= '<div style="color: #FF0000;">';
            $whereClauseForm .= 'address_town=\'Cergy\' AND contact_id=\'100\'';
          $whereClauseForm .= '</div>';
          $whereClauseForm .= 'Si l\'on recherche des habitant dont le code postal commence par <b>95</b> ou par <b>75</b> ou n\'est pas en <b>France</b> :<br />';
          $whereClauseForm .= '<div style="color: #FF0000;">';
            $whereClauseForm .= 'address_postal_code LIKE \'95%\' OR address_postal_code LIKE \'75%\' OR address_country NOT LIKE \'France\'';
          $whereClauseForm .= '</div>';
          $whereClauseForm .= '<TEXTAREA name="clause" cols="75" rows="3"></TEXTAREA><br />';
          $whereClauseForm .= '<br />';
        $whereClauseForm .= '</div>';
        $whereClauseForm .= '<h4>';
          $whereClauseForm .= 'OU';
        $whereClauseForm .= '</h4>';
        $whereClauseForm .= '<div style="border: solid 1px; background-color: #CCCCCC; background-image: url(backgroundMaarch.png)">';
          $whereClauseForm .= '<br />';
          $whereClauseForm .= 'Remplissez les champs qui vous int&eacute;ressent et laissez vide les autres';
          $whereClauseForm .= '<br />';
          $whereClauseForm .= '<br />';
          $whereClauseForm .= '<table border="1">';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'contact_id';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' = ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="contact_id" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'lastname';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="lastname" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'firstname';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="firstname" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'society';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="society" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'function';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="function" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'address_num';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="address_num" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'address_street';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="address_street" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'address_complement';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="address_complement" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'address_town';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="address_town" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'address_postal_code';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="address_postal_code" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'address_country';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="address_country" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'email';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="email" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'phone';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="phone" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'other_data';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="other_data" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'is_corporate_person';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="is_corporate_person" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'user_id';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="user_id" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'title';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="title" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= 'enabled';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= ' LIKE ';
              $whereClauseForm .= '</td>';
              $whereClauseForm .= '<td>';
                $whereClauseForm .= '<input type="text" name="enabled" />';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
            $whereClauseForm .= '<tr>';
              $whereClauseForm .= '<td colspan="3">';
                $whereClauseForm .= '<div align="center">';
                  $whereClauseForm .= 'M&eacute;thode de recherche';
                  $whereClauseForm .= '<br />';
                  $whereClauseForm .= '"et" : ';
                  $whereClauseForm .= '<input type="radio" name="methodSearch" value="and" />';
                  $whereClauseForm .= '<br />';
                  $whereClauseForm .= '"ou" : ';
                  $whereClauseForm .= '<input type="radio" name="methodSearch" value="or"/>';
                $whereClauseForm .= '</div>';
              $whereClauseForm .= '</td>';
            $whereClauseForm .= '</tr>';
          $whereClauseForm .= '</table>';
        $whereClauseForm .= '</div>';
        $whereClauseForm .= '<br />';
        $whereClauseForm .= '<br />';
        $whereClauseForm .= '<input type="submit" value="Afficher la liste de contacts" name="Afficher" style="background-color: #0F0FFF; color: #FFFFFF; font-weight: bold; font-size: 20px;"/>';
      $whereClauseForm .= '</form>';
    $whereClauseForm .= '</div>';

}
?>

<HTML>
    <HEAD>
        <TITLE>WS Service > Liste de Contacts</TITLE>
    </HEAD>
    <BODY>
        <?php if (isset($whereClauseForm) && !empty($whereClauseForm)) { echo $whereClauseForm; } ?>
        <?php if (isset($contactResult) && !empty($contactResult)) { echo $contactResult; } ?>
        <?php if (isset($debug) && !empty($debug)) { echo '<hr /><h3>Debug</h3><br />'.$debug; } ?>
    </BODY>
</HTML>