| 1 |
vpihour |
741 |
<?php |
| 2 |
|
|
/** |
| 3 |
|
|
* Ce script a pour objet de recuperer la liste des pétionnaires correspondant aux critères de recherche |
| 4 |
|
|
* |
| 5 |
|
|
* @package openfoncier |
| 6 |
|
|
* @version SVN : $Id$ |
| 7 |
|
|
*/ |
| 8 |
|
|
$DEBUG=1; |
| 9 |
|
|
require_once "../obj/utils.class.php"; |
| 10 |
|
|
|
| 11 |
|
|
// Donnees |
| 12 |
|
|
$par_nom = (isset($_GET['par_nom']) ? $_GET['par_nom'] : "" ); |
| 13 |
|
|
$par_prenom = (isset($_GET['par_prenom']) ? $_GET['par_prenom'] : "" ); |
| 14 |
|
|
$mor_denomination = (isset($_GET['mor_denomination']) ? $_GET['mor_denomination'] : "" ); |
| 15 |
|
|
$mor_nom = (isset($_GET['mor_nom']) ? $_GET['mor_nom'] : "" ); |
| 16 |
|
|
$type = (isset($_GET['type']) ? $_GET['type'] : "" ); |
| 17 |
vpihour |
756 |
$listData = ""; |
| 18 |
vpihour |
741 |
|
| 19 |
vpihour |
756 |
if ( $type != "" ){ |
| 20 |
|
|
$f = new utils("nohtml"); |
| 21 |
|
|
$f->disableLog(); |
| 22 |
vpihour |
741 |
|
| 23 |
vpihour |
756 |
$requete = "frequent is TRUE AND type_demandeur = '$type' AND "; |
| 24 |
|
|
/* Créé la requête si le type de demandeur est particulier */ |
| 25 |
|
|
if ( strcmp( 'particulier', $type) == 0 ){ |
| 26 |
|
|
|
| 27 |
|
|
$requete .= " |
| 28 |
|
|
upper(particulier_nom) LIKE upper('%$par_nom%') AND upper(particulier_prenom) LIKE upper('%$par_prenom%') |
| 29 |
|
|
"; |
| 30 |
vpihour |
741 |
} |
| 31 |
vpihour |
756 |
|
| 32 |
|
|
/* Créé la requête si le type de demandeur est personne morale */ |
| 33 |
|
|
if ( strcmp( 'personne_morale', $type) == 0 ){ |
| 34 |
|
|
|
| 35 |
|
|
$requete .= " |
| 36 |
|
|
upper(personne_morale_denomination) LIKE upper('%$mor_denomination%') AND upper(personne_morale_nom) LIKE upper('%$mor_nom%') |
| 37 |
|
|
"; |
| 38 |
|
|
} |
| 39 |
|
|
|
| 40 |
|
|
$sql = |
| 41 |
|
|
"SELECT |
| 42 |
|
|
demandeur, particulier_nom, particulier_prenom, particulier_date_naissance, particulier_civilite, |
| 43 |
|
|
personne_morale_denomination, personne_morale_siret, personne_morale_nom, personne_morale_civilite, personne_morale_prenom, |
| 44 |
|
|
particulier_commune_naissance, particulier_departement_naissance, |
| 45 |
|
|
personne_morale_raison_sociale, personne_morale_categorie_juridique, |
| 46 |
|
|
numero, voie, complement, lieu_dit, localite, code_postal, bp, cedex, pays, |
| 47 |
|
|
division_territoriale, telephone_fixe, telephone_mobile, indicatif, courriel, notification |
| 48 |
|
|
FROM |
| 49 |
|
|
".DB_PREFIXE."demandeur |
| 50 |
|
|
WHERE $requete |
| 51 |
|
|
"; |
| 52 |
|
|
|
| 53 |
|
|
$res = $f->db->query($sql); |
| 54 |
|
|
$f->isDatabaseError($res); |
| 55 |
|
|
|
| 56 |
|
|
$civ = ''; |
| 57 |
|
|
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)) { |
| 58 |
|
|
|
| 59 |
|
|
foreach ($row as $value) { |
| 60 |
|
|
|
| 61 |
|
|
$listData .= (($value!= '') ? $value:'') . '_'; |
| 62 |
|
|
} |
| 63 |
|
|
$listData .= ";"; |
| 64 |
|
|
} |
| 65 |
|
|
|
| 66 |
|
|
|
| 67 |
vpihour |
741 |
} |
| 68 |
|
|
echo json_encode($listData); |
| 69 |
|
|
?> |
Parent Directory
| 
Revision Log