include/profil/get_adresses.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2006 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 require_once('geoloc.inc.php');
  23
  24 // on limite à 6 adresses personnelles par utilisateur
  25 $nb_adr_max = 6; // ( = max(adrid possibles)
  26 // on limite à 4 numéros de téléphone par adresse
  27 $nb_tel_max = 4; // ( = max(telid possibles)
  28
  29 //les adresses sont stockées dans un tableau global indéxé par adrid;
  30
  31 function is_adr_empty($adrid){
  32   $adr = &$GLOBALS['adresses'][$adrid];
  33   return (
  34     ($adr['adr1'] == '') && ($adr['adr2'] == '') && ($adr['adr3'] == '') &&
  35     ($adr['postcode'] == '') && ($adr['city'] == '') && ($adr['country'] == '00') &&
  36     (count($adr['tels']) == 0)
  37     );
  38 }
  39
  40 function delete_address($adrid, $in_request_array = false){
  41     XDB::execute("DELETE FROM adresses WHERE uid = {?} AND adrid = {?}",
  42                  S::v('uid', -1), $adrid);
  43     XDB::execute("DELETE FROM tels WHERE uid = {?} AND adrid = {?}",
  44                  S::v('uid', -1), $adrid);
  45     if ($in_request_array == true){
  46         unset($_REQUEST['adrid'][$adrid]);
  47     } else{
  48         unset($GLOBALS['adresses'][$adrid]);
  49     }
  50 }
  51
  52 //on verifie si on nous a demande une suppression
  53 $req_adrid_del = Env::getMixed('adrid_del', Array());
  54 for ($i = 1; $i <= $nb_adr_max; $i++) {
  55     if (isset($req_adrid_del[$i])) {
  56         delete_address($i,true);
  57     }
  58 }
  59
  60 //$sql_order = "ORDER BY (NOT FIND_IN_SET('active', statut)), FIND_IN_SET('temporaire', statut)";
  61 $sql_order = '';
  62
  63 //recuperation des adrid
  64 $res = XDB::query("SELECT adrid FROM adresses WHERE uid = {?} AND NOT FIND_IN_SET('pro', statut) ".$sql_order, S::v('uid', -1));
  65 $adrids = $res->fetchColumn();
  66
  67 //recuperation des donnees de la bd
  68 $res = XDB::iterRow(
  69         "SELECT
  70         FIND_IN_SET('res-secondaire', statut), FIND_IN_SET('courrier', statut),
  71         FIND_IN_SET('active', statut), FIND_IN_SET('temporaire', statut),
  72         adr1, adr2, adr3, postcode, city, cityid,
  73         a.country, region, regiontxt, pub,
  74         gp.pays AS countrytxt, gp.display
  75         FROM adresses AS a INNER JOIN geoloc_pays AS gp ON(gp.a2 = a.country)
  76         WHERE uid = {?} AND NOT FIND_IN_SET('pro',statut) ".$sql_order
  77 , S::v('uid', -1)
  78 );
  79
  80 $nb_adr = $res->total();
  81
  82 for ($i = 0; $i < $nb_adr; $i++) {
  83   $adrid = $adrids[$i];
  84   $adresses[$adrid]['adrid'] = $adrid;
  85   list(
  86        $adresses[$adrid]['secondaire'], $adresses[$adrid]['courrier'],
  87        $adresses[$adrid]['active'], $adresses[$adrid]['temporaire'],
  88        $adresses[$adrid]['adr1'], $adresses[$adrid]['adr2'], $adresses[$adrid]['adr3'], $adresses[$adrid]['postcode'], $adresses[$adrid]['city'], $adresses[$adrid]['cityid'],
  89        $adresses[$adrid]['country'], $adresses[$adrid]['region'], $adresses[$adrid]['regiontxt'],
  90        $adresses[$adrid]['pub'],
  91        $adresses[$adrid]['countrytxt'],$adresses[$adrid]['display']) = $res->next();
  92   $adresses[$adrid]['nouvelle'] = 'modif';
  93   $adresses[$adrid]['numero_formulaire'] = -1;
  94   require_once('geoloc.inc.php');
  95   $adresses[$adrid]['txt'] = get_address_text($adresses[$adrid]);
  96 }
  97
  98 $restels = XDB::iterator(
  99     "SELECT
 100     t.adrid, telid, tel_type, t.tel_pub, t.tel
 101     FROM tels AS t INNER JOIN adresses AS a ON(t.uid = a.uid AND t.adrid = a.adrid)
 102     WHERE t.uid = {?} AND NOT FIND_IN_SET('pro',statut) ORDER BY t.adrid, tel_type DESC, telid"
 103 , S::v('uid', -1)
 104 );
 105 while ($tel = $restels->next()) {
 106     $adrid = $tel['adrid'];
 107     unset($tel['adrid']);
 108     if (!isset($adresses[$adrid]['tels']))
 109         $adresses[$adrid]['tels'] = array($tel);
 110     else
 111         $adresses[$adrid]['tels'][] = $tel;
 112 }
 113 ?>