<?php
/***************************************************************************
 *  Copyright (C) 2003-2004 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/


reset($adresses);

foreach($adresses as $adrid => $adr){

  if($adr['nouvelle'] != 'new'){ // test si on vient de creer cette adresse dans verif_adresse.inc.php
  
    //construction des bits
    $statut = "";
    if ($adr["secondaire"])    $statut .= 'res-secondaire,';
    if ($adr["courrier"])      $statut .= 'courrier,';
    if ($adr["active"])        $statut .= 'active,';
    if ($adr["temporaire"])    $statut .= 'temporaire,';
    if (! empty($statut)) $statut = substr($statut, 0, -1);

    if ($adr["nouvelle"] == 'ajout') {
    //nouvelle adresse
      $globals->xdb->execute("INSERT INTO adresses SET
			 adr1 = {?},
			 adr2 = {?},
			 adr3 = {?},
			 postcode = {?},
			 city = {?},
			 cityid = {?},
			 country = {?},
			 region = {?},
			 regiontxt = {?},
			 tel = {?},
			 fax = {?},
			 pub = {?},
			 tel_pub = {?},
			 datemaj = NOW(),
			 statut = {?},
			 uid = {?}, adrid = {?}",
			 $adr['adr1'],
			 $adr['adr2'],
			 $adr['adr3'],
			 $adr['postcode'],
			 $adr['city'],
			 $adr['cityid'],
			 $adr['country'],
			 $adr['region'],
			 $adr['regiontxt'],
			 $adr['tel'],
			 $adr['fax'],
			 $adr['pub'],
			 $adr['tel_pub'],
			 $statut,
			 Session::getInt('uid', -1), $adrid);
    }
    
    else{ 
      //c'est une mise à jour
      $globals->xdb->execute(
		    "UPDATE adresses SET
				 adr1 = {?},
				 adr2 = {?},
				 adr3 = {?},
				 postcode = {?},
				 city = {?},
				 cityid = {?},
				 country = {?},
				 region = {?},
				 regiontxt = {?},
				 tel = {?},
				 fax = {?},
				 pub = {?},
				 tel_pub = {?},
				 datemaj = NOW(),
				 statut = {?}
				 WHERE uid = {?} AND adrid = {?}",
				 $adr['adr1'],
				 $adr['adr2'],
				 $adr['adr3'],
				 $adr['postcode'],
				 $adr['city'],
				 $adr['cityid'],
				 $adr['country'],
				 $adr['region'],
				 $adr['regiontxt'],
				 $adr['tel'],
				 $adr['fax'],
				 $adr['pub'],
				 $adr['tel_pub'],
				 $statut,
				 Session::getInt('uid', -1), $adrid
		    );
    }// fin nouvelle / ancienne adresse
  }//fin if nouvellement crée
}//fin foreach
?>