<?php
include_once 'code/init.php';

$erreur = '';
$msg = '';

$inter_genre = getPostValue('inter_genre');
$inter_nom = getPostValue('inter_nom');
$inter_pnom = getPostValue('inter_pnom');
$inter_nomma = getPostValue('inter_nomma');
$inter_adr1 = getPostValue('inter_adr1');
$inter_adr2 = getPostValue('inter_adr2');
$inter_adr3 = getPostValue('inter_adr3');
$inter_cp = getPostValue('inter_cp');
$inter_ville = getPostValue('inter_ville');
$inter_teldomi = getPostValue('inter_teldomi');
$inter_telport = getPostValue('inter_telport');
$inter_daten = sprintf('%04d%02d%02d', $inter_daten_year, $inter_daten_month, $inter_daten_day);
$inter_nat = getPostValue('inter_nat');
$inter_sejourdeliv = getPostValue('inter_sejourdeliv');
$inter_sejourno = getPostValue('inter_sejourno');
$inter_sejourdate = getPostValue('inter_sejourdate');
  if ( $inter_sejourno ) {
    $inter_sejourdate = mktime ( 3, 0, 0, $inter_sejourdate_month, $inter_sejourdate_day,$inter_sejourdate_year );
  } else {
    $inter_sejourdate = 'NULL';
  }
$inter_sejourw = getPostValue('inter_sejourw');
$inter_secuno = getPostValue('inter_secuno');
$inter_secucentre = getPostValue('inter_secucentre');
$inter_medi = getPostValue('inter_medi');
  if ( $inter_medi ) {
    $inter_medidate = mktime ( 3, 0, 0, $inter_medidate_month, $inter_medidate_day,$inter_medidate_year );
  } else {
    $inter_medidate = 'NULL';
  }
$inter_judi = getPostValue('inter_judi');
$inter_statutm = getPostValue('inter_statutm');
$inter_enfantsnb = (int)getPostValue('inter_enfantsnb');
$inter_enfantsgc = getPostValue('inter_enfantsgc');
$inter_statutw = getPostValue('inter_statutw');
$inter_statutwdate = getPostValue('inter_statutwdate');
$inter_ANPE = getPostValue('inter_ANPE');
  if ( $inter_medi ) {
	$inter_ANPEid = getPostValue('inter_ANPEid');
	$inter_ANPEdate = getPostValue('inter_ANPEdate');
  } else {
	$inter_ANPEid = '';
	$inter_ANPEdate = '';
  }
$inter_alloc = getPostValue('inter_alloc');
  if ( $inter_alloc ) {
	$inter_allocdesc = getPostValue('inter_allocdesc');
  } else {
	$inter_allocdesc = '';
  }
$inter_ref1 = getPostValue('inter_ref1');
$inter_ref2 = getPostValue('inter_ref2');
$inter_ref3 = getPostValue('inter_ref3');
$inter_zones = getPostValue('zones');
$inter_zones_id = '';
if (!empty($inter_zones))
    foreach ( $inter_zones as $zone_id ){
		switch ($zone_id) {
		case '10':
		$zone_id = 'A';
		break;
		case '11':
		$zone_id = 'B';
		break;
		case '12':
		$zone_id = 'C';
		break;
		}
		$inter_zones_id .= $zone_id;
    }



$sql = "INSERT INTO `intervenant` 
					( `inter_genre` , `inter_nom` , `inter_pnom` , `inter_nomma` , `inter_adr1` , `inter_adr2` , `inter_adr3` , `inter_cp` , `inter_ville` , `inter_teldomi` , `inter_telport` , `inter_daten` , `inter_nat` , `inter_sejourdeliv` , `inter_sejourno` , `inter_sejourdate` , `inter_sejourw` , `inter_secuno` , `inter_secucentre` , `inter_medi` , `inter_medidate` , `inter_judi` , `inter_statutm` , `inter_enfantsnb` , `inter_enfantsgc` , `inter_statutw` , `inter_statutwdate` , `inter_ANPE` , `inter_ANPEid` , `inter_ANPEdate` , `inter_alloc` , `inter_allocdesc` , `inter_ref1` , `inter_ref2` , `inter_ref3` , `inter_zones_id`  ) 
			VALUES (
'$inter_genre', '$inter_nom', '$inter_pnom', '$inter_nomma', '$inter_adr1', '$inter_adr2', '$inter_adr3', '$inter_cp', '$inter_ville', '$inter_teldomi', '$inter_telport', '$inter_daten', '$inter_nat', '$inter_sejourdeliv', '$inter_sejourno', $inter_sejourdate, '$inter_sejourw', '$inter_secuno', '$inter_secucentre', '$inter_medi', $inter_medidate, '$inter_judi', '$inter_statutm', $inter_enfantsnb, '$inter_enfantsgc', '$inter_statutw', '$inter_statutwdate', '$inter_ANPE', '$inter_ANPEid', '$inter_ANPEdate', '$inter_alloc', '$inter_allocdesc', '$inter_ref1', '$inter_ref2', '$inter_ref3', '$inter_zones_id')";

dbi_query ( $sql );

$_GET['interv_id'] = mysql_insert_id() ;
include 'caa.php' ;
?>
</body>
</html>