<?php
include_once 'code/init.php';
//include_once 'includes/site_extras.php';
$conflicts = '';


// echo "===> lllll <br/>" ; 
// exit() ; 

$presta_id = getPostValue('presta_id');
$presta_desc = getPostValue('presta_desc');
$presta_Hdebh = getPostValue('presta_Hdebh');
$presta_Hdebm = getPostValue('presta_Hdebm');
$presta_Hdeb = sprintf ( "%02d%02d", getPostValue('presta_Hdebh'), getPostValue('presta_Hdebm') ) .'00';
$presta_Hfinh = getPostValue('presta_Hfinh');
$presta_Hfinm = getPostValue('presta_Hfinm');
$presta_Hfin = getPostValue('presta_Hfin');
    if ( ! isset ( $presta_Hfinh ) ) {
        $presta_Hduree = 0;
    } else {
      $endmins = ( 60 * (int) ( $presta_Hfinh ) ) + $presta_Hfinm;
      $startmins = ( 60 * $presta_Hdebh ) + $presta_Hdebm;
      $presta_Hduree = $endmins - $startmins;
    }
    if ( $presta_Hduree < 0 ) {
        $presta_Hduree = 0;
    } 
$presta_recur = getPostValue('presta_recur');
$presta_fin = getPostValue('presta_fin');
  if ( $presta_recur ) {
	$presta_date_debut = sprintf ( "%04d%02d%02d", getPostValue('presta_date_debut_year'), getPostValue('presta_date_debut_month'), getPostValue('presta_date_debut_day') );
	$presta_date_fin = sprintf ( "%04d%02d%02d", getPostValue('presta_date_fin_year'), getPostValue('presta_date_fin_month'), getPostValue('presta_date_fin_day') );

    $presta_jour = getPostValue('presta_jour');
    $presta_jour = jour2presta_jour($presta_jour) ;
	
	//$presta_sem = isset($_POST['alter']) ? (date("W",int2time($presta_date_debut))%2) : '';
	  
  } else {
	$presta_date_debut = sprintf ( "%04d%02d%02d", getPostValue('presta_date_year'), getPostValue('presta_date_month'), getPostValue('presta_date_day') );
	$presta_date_fin = $presta_date_debut;
    $presta_jour = "nnnnnnn";
  }
  
$presta_forfait = getPostValue('presta_forfait');
  if ( $presta_forfait ) {
	$presta_forfait = getPostValue('presta_forfait_s_v');
  } else {
	$presta_forfait = floatval(getPostValue('presta_forfait_p_v'));
  }
  
$inter_id = getPostValue('inter_id');
$chantier_id = getPostValue('chantier_id');
$type_pre_id = getPostValue('type_pre_id');
if(empty($_POST['presta_desc']))
$presta_desc = NULL ;
else
$presta_desc = getPostValue('presta_desc') ;
$sql = "INSERT INTO ".TABLE_PREST." (`presta_desc`, `presta_date_debut`, `presta_Hdeb`, `presta_Hduree`, `presta_recur`, `presta_date_fin`, `presta_jour`, `presta_forfait`, `presta_status`, `presta_sem`, `client_id`, `inter_id`, agence_id,`chantier_id`,`prestation_type`) 
	VALUES ('$presta_desc', '$presta_date_debut', '$presta_Hdeb', '$presta_Hduree', '$presta_recur', ".((int)$presta_date_fin ? $presta_date_fin : 'NULL').", '$presta_jour', '$presta_forfait', 'ON','', '$client_id', '$inter_id', $agence,'$chantier_id','$type_pre_id')";
// echo $sql;
dbi_query ( $sql );

$plng = dbi_query("SELECT * FROM ".TABLE_CLIENT." where client_id =$client_id ");

if ($dcl = dbi_fetch_row($plng)){

$client_adr1=addslashes($dcl['client_adr1']);
$client_nom=addslashes($dcl['client_nom']);
$client_pnom=addslashes($dcl['client_pnom']);
$client_ville=addslashes($dcl['client_ville']);
$client_cp=$dcl['client_cp'];
$client_teldom=$dcl['client_teldom'];
$client_telport1=$dcl['client_telport1'];
$client_telport2=$dcl['client_telport2'];
$client_telpro=$dcl['client_telpro'];
$client_zones_id=$dcl['client_zones_id'];
}
$reqint = dbi_query("SELECT * FROM ".TABLE_INTERV." WHERE  inter_id=$inter_id ");
if ($int = dbi_fetch_row($reqint)){
$inter_genre=$int['inter_genre'];
$inter_nom=addslashes($int['inter_nom']);
$inter_pnom=addslashes($int['inter_pnom']);
$inter_adr1=addslashes($int['inter_adr1']);
$inter_cp=$int['inter_cp'];
$inter_ville=addslashes($int['inter_ville']);
$inter_teldomi=$int['inter_teldomi'];
$inter_telport=$int['inter_telport'];
$inter_zones_id=$int['inter_zones_id'];
$inter_chien=$int['inter_chien'];
$inter_chat=$int['inter_chat'];
$inter_vehicule=$int['inter_vehicule'];
$inter_repass=$int['inter_repass'];
$inter_menage=$int['inter_menage'];

}

$q1 = dbi_query("SELECT * FROM ".TABLE_PREST." WHERE `presta_id` = ( SELECT MAX(`presta_id`) FROM ".TABLE_PREST." WHERE inter_id=$inter_id AND agence_id=$agence) ");
		if($ma = dbi_fetch_row($q1)){

$presta_id=$ma['presta_id'];	
		}
		$d = date('d', strtotime($presta_date_debut));
 $m = date('m', strtotime($presta_date_debut));
 $y = date('Y', strtotime($presta_date_debut));
$db=debutsem($y,$m,$d);
$from = isset($db) ? $db : time2int(time()-(date('w')-1)*24*3600) ;
$to = time2int(int2time($from)+6*24*3600) ;
$plng = dbi_query("SELECT * FROM ".TABLE_PLNG." WHERE date_debutpln=$from and date_finpln=$to and inter_id=$inter_id ");

if ($pres = dbi_fetch_row($plng))
 
		{
$dat = date("Ymd");
			$d1 = date('d', strtotime($dat));
 $m1 = date('m', strtotime($dat));
 $y1 = date('Y', strtotime($dat));
$dayOfWeek = date("l",mktime(0,0,0, $m1, $d1,$y1));
if ($dayOfWeek=="Sunday") $presj=0;
if ($dayOfWeek=="Monday") $presj=1;
if ($dayOfWeek=="Tuesday") $presj=2;
if ($dayOfWeek=="Wednesday") $presj=3;
if ($dayOfWeek=="Thursday") $presj=4;
if ($dayOfWeek=="Friday") $presj=5;
if ($dayOfWeek=="Saturday") $presj=6;
$timestamp =  date('His');
$d = date('d', strtotime($presta_date_debut));
 $m = date('m', strtotime($presta_date_debut));
 $y = date('Y', strtotime($presta_date_debut));
$db=debutsem($y,$m,$d);
$from = isset($db) ? $db : time2int(time()-(date('w')-1)*24*3600) ;
$to = time2int(int2time($from)+6*24*3600) ;
$dayOfWeek = date("l",mktime(0,0,0, $m, $d,$y));
if ($dayOfWeek=="Sunday") $presjour=0;
if ($dayOfWeek=="Monday") $presjour=1;
if ($dayOfWeek=="Tuesday") $presjour=2;
if ($dayOfWeek=="Wednesday") $presjour=3;
if ($dayOfWeek=="Thursday") $presjour=4;
if ($dayOfWeek=="Friday") $presjour=5;
if ($dayOfWeek=="Saturday") $presjour=6;

$jour=strpos($presta_jour, 'y');
if ($jour>=$presjour){
$sql = "INSERT INTO ".TABLE_PLNG." ( `client_id`,`client_nom` , `client_pnom` , `client_adr1` , `client_cp` , `client_ville`, `client_teldom` , `client_telport1` , `client_telport2` , `client_telpro`, `client_zones_id` , agence_id,`presta_id`,`presta_date_debut`,`presta_Hdeb`,`presta_Hduree`,`presta_recur`, `presta_date_fin`,`presta_jour`,`presta_forfait`,`presta_forfaitHT`,`inter_id`,`date_debutpln`,`date_finpln`,`date_pln`,`pln_Hdeb`,`inter_genre`,`inter_nom`,`inter_pnom`,`inter_adr1`,`inter_cp`,`inter_ville`,`inter_teldomi`,`inter_telport`,`inter_zones_id`,`inter_chien`,`inter_chat`,`inter_vehicule`,`inter_repass`,`inter_menage`) 
	VALUES (
	'".$client_id."','$client_nom', '$client_pnom', '$client_adr1', '$client_cp', '$client_ville', '$client_teldom', '$client_telport1', '$client_telport2', '$client_telpro', '$client_zones_id', '$agence','$presta_id','$presta_date_debut', '$presta_Hdeb', '$presta_Hduree', '$presta_recur','".((int)$presta_date_fin ? $presta_date_fin : 'NULL')."','$jour','$presta_forfait','NULL','$inter_id','$from','$to','$dat','$timestamp','$inter_genre','$inter_nom','$inter_pnom','$inter_adr1','$inter_cp','$inter_ville','$inter_teldomi','$inter_telport','$inter_zones_id','$inter_chien','$inter_chat','$inter_vehicule','$inter_repass','$inter_menage')";
	
	dbi_query ( $sql );
	}
elseif ($jour==null) {
$sql = "INSERT INTO ".TABLE_PLNG." ( `client_id`,`client_nom` , `client_pnom` , `client_adr1` , `client_cp` , `client_ville`, `client_teldom` , `client_telport1` , `client_telport2` , `client_telpro`, `client_zones_id` , agence_id,`presta_id`,`presta_date_debut`,`presta_Hdeb`,`presta_Hduree`,`presta_recur`, `presta_date_fin`,`presta_jour`,`presta_forfait`,`presta_forfaitHT`,`inter_id`,`date_debutpln`,`date_finpln`,`date_pln`,`pln_Hdeb`,`inter_genre`,`inter_nom`,`inter_pnom`,`inter_adr1`,`inter_cp`,`inter_ville`,`inter_teldomi`,`inter_telport`,`inter_zones_id`,`inter_chien`,`inter_chat`,`inter_vehicule`,`inter_repass`,`inter_menage`) 
	VALUES (
	'".$client_id."','$client_nom', '$client_pnom', '$client_adr1', '$client_cp', '$client_ville', '$client_teldom', '$client_telport1', '$client_telport2', '$client_telpro', '$client_zones_id', '$agence','$presta_id','$presta_date_debut', '$presta_Hdeb', '$presta_Hduree', '$presta_recur','".((int)$presta_date_fin ? $presta_date_fin : 'NULL')."','$presjour','$presta_forfait','NULL','$inter_id','$from','$to','$dat','$timestamp','$inter_genre','$inter_nom','$inter_pnom','$inter_adr1','$inter_cp','$inter_ville','$inter_teldomi','$inter_telport','$inter_zones_id','$inter_chien','$inter_chat','$inter_vehicule','$inter_repass','$inter_menage')";
	
	dbi_query ( $sql );
} 

$plng1 = dbi_query("SELECT DISTINCT date_debutpln,date_finpln FROM ".TABLE_PLNG." WHERE date_debutpln>$to AND inter_id=$inter_id ");
while ($dd = dbi_fetch_row($plng1))
    {

   if ($presta_date_fin!='00000000'  )      {
 $d1 = date('d', strtotime($presta_date_fin));
 $m1 = date('m', strtotime($presta_date_fin));
 $y1 = date('Y', strtotime($presta_date_fin));
 $dbf=debutsem($y1,$m1,$d1);
 $dayOfWeek = date("l",mktime(0,0,0, $m1, $d1,$y1));
if ($dayOfWeek=="Sunday") $presfin=0;
if ($dayOfWeek=="Monday") $presfin=1;
if ($dayOfWeek=="Tuesday") $presfin=2;
if ($dayOfWeek=="Wednesday") $presfin=3;
if ($dayOfWeek=="Thursday") $presfin=4;
if ($dayOfWeek=="Friday") $presfin=5;
if ($dayOfWeek=="Saturday") $presfin=6;
$fromf = isset($dbf) ? $dbf : time2int(time()-(date('w')-1)*24*3600) ;
$tof = time2int(int2time($fromf)+6*24*3600) ;
        if ($dd['date_debutpln']==$fromf AND $dd['date_finpln']==$tof ){
if($jour<=$presfin)  {

$sql = "INSERT INTO ".TABLE_PLNG." ( `client_id`,`client_nom` , `client_pnom` , `client_adr1` , `client_cp` , `client_ville`, `client_teldom` , `client_telport1` , `client_telport2` , `client_telpro`, `client_zones_id` , agence_id,`presta_id`,`presta_date_debut`,`presta_Hdeb`,`presta_Hduree`,`presta_recur`, `presta_date_fin`,`presta_jour`,`presta_forfait`,`presta_forfaitHT`,`inter_id`,`date_debutpln`,`date_finpln`,`date_pln`,`pln_Hdeb`,`inter_genre`,`inter_nom`,`inter_pnom`,`inter_adr1`,`inter_cp`,`inter_ville`,`inter_teldomi`,`inter_telport`,`inter_zones_id`,`inter_chien`,`inter_chat`,`inter_vehicule`,`inter_repass`,`inter_menage`) 
	VALUES (
	'".$client_id."','$client_nom', '$client_pnom', '$client_adr1', '$client_cp', '$client_ville', '$client_teldom', '$client_telport1', '$client_telport2', '$client_telpro', '$client_zones_id', '$agence','$presta_id','$presta_date_debut', '$presta_Hdeb', '$presta_Hduree', '$presta_recur','".((int)$presta_date_fin ? $presta_date_fin : 'NULL')."','$jour','$presta_forfait','NULL','$inter_id','".$dd['date_debutpln']."','".$dd['date_finpln']."','$dat','$timestamp','$inter_genre','$inter_nom','$inter_pnom','$inter_adr1','$inter_cp','$inter_ville','$inter_teldomi','$inter_telport','$inter_zones_id','$inter_chien','$inter_chat','$inter_vehicule','$inter_repass','$inter_menage')";
	
	dbi_query ( $sql );
	  }
	                   }
elseif($dd['date_finpln']<$tof){
					   $sql = "INSERT INTO ".TABLE_PLNG." ( `client_id`,`client_nom` , `client_pnom` , `client_adr1` , `client_cp` , `client_ville`, `client_teldom` , `client_telport1` , `client_telport2` , `client_telpro`, `client_zones_id` , agence_id,`presta_id`,`presta_date_debut`,`presta_Hdeb`,`presta_Hduree`,`presta_recur`, `presta_date_fin`,`presta_jour`,`presta_forfait`,`presta_forfaitHT`,`inter_id`,`date_debutpln`,`date_finpln`,`date_pln`,`pln_Hdeb`,`inter_genre`,`inter_nom`,`inter_pnom`,`inter_adr1`,`inter_cp`,`inter_ville`,`inter_teldomi`,`inter_telport`,`inter_zones_id`,`inter_chien`,`inter_chat`,`inter_vehicule`,`inter_repass`,`inter_menage`) 
	VALUES (
	'".$client_id."','$client_nom', '$client_pnom', '$client_adr1', '$client_cp', '$client_ville', '$client_teldom', '$client_telport1', '$client_telport2', '$client_telpro', '$client_zones_id', '$agence','$presta_id','$presta_date_debut', '$presta_Hdeb', '$presta_Hduree', '$presta_recur','".((int)$presta_date_fin ? $presta_date_fin : 'NULL')."','$jour','$presta_forfait','NULL','$inter_id','".$dd['date_debutpln']."','".$dd['date_finpln']."','$dat','$timestamp','$inter_genre','$inter_nom','$inter_pnom','$inter_adr1','$inter_cp','$inter_ville','$inter_teldomi','$inter_telport','$inter_zones_id','$inter_chien','$inter_chat','$inter_vehicule','$inter_repass','$inter_menage')";
	
	dbi_query ( $sql );
	} else{}
		 }
		else{
			
		$sql = "INSERT INTO ".TABLE_PLNG." ( `client_id`,`client_nom` , `client_pnom` , `client_adr1` , `client_cp` , `client_ville`, `client_teldom` , `client_telport1` , `client_telport2` , `client_telpro`, `client_zones_id` , agence_id,`presta_id`,`presta_date_debut`,`presta_Hdeb`,`presta_Hduree`,`presta_recur`, `presta_date_fin`,`presta_jour`,`presta_forfait`,`presta_forfaitHT`,`inter_id`,`date_debutpln`,`date_finpln`,`date_pln`,`pln_Hdeb`,`inter_genre`,`inter_nom`,`inter_pnom`,`inter_adr1`,`inter_cp`,`inter_ville`,`inter_teldomi`,`inter_telport`,`inter_zones_id`,`inter_chien`,`inter_chat`,`inter_vehicule`,`inter_repass`,`inter_menage`) 
	VALUES (
	'".$client_id."','$client_nom', '$client_pnom', '$client_adr1', '$client_cp', '$client_ville', '$client_teldom', '$client_telport1', '$client_telport2', '$client_telpro', '$client_zones_id', '$agence','$presta_id','$presta_date_debut', '$presta_Hdeb', '$presta_Hduree', '$presta_recur','".((int)$presta_date_fin ? $presta_date_fin : 'NULL')."','$jour','$presta_forfait','NULL','$inter_id','".$dd['date_debutpln']."','".$dd['date_finpln']."','$dat','$timestamp','$inter_genre','$inter_nom','$inter_pnom','$inter_adr1','$inter_cp','$inter_ville','$inter_teldomi','$inter_telport','$inter_zones_id','$inter_chien','$inter_chat','$inter_vehicule','$inter_repass','$inter_menage')";
	
	dbi_query ( $sql );
	   
	}
	}

	}
	$_GET['client_id'] = $client_id ;

$prest = $_POST;
$prest['presta_id'] = mysqli_insert_id();
if ($presta_recur)$alerte = 11; else $alerte=12;
//create_alerte($alerte, $prest, $presta_date_debut, $presta_Hdeb, $presta_Hduree, $presta_jour, null, $inter_id) ;//kmc_ac 6/1/11 - Alertes SMS MAIL
if($_POST['insert']){
}
elseif (isset($_POST['fermer']))
define('FERMER',true);
?>