addEvent.php 1.48 KB
Newer Older
Hamza Arfaoui's avatar
Hamza Arfaoui committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
<?php
session_start();
require_once("../../inc/confNetisse.php"); 

$id_conseiller = isset($_POST['id_conseiller']) ? intval($_POST['id_conseiller']) : intval($_SESSION['id']);
$id_agence = isset($_POST["id_agence"]) ? intval($_POST["id_agence"]) : '-1';
$title = isset($_POST["title"]) ? $_POST["title"] : '';
$start = isset($_POST["start"]) ? $_POST["start"] : '';
$end = (isset($_POST["end"]) && $_POST["end"]!="") ? $_POST["end"] : date('Y-m-d',$start)." 20:00:00";
$allDay = isset($_POST["allDay"]) ? $_POST["allDay"] : 0;
//$allDay = ($allDay==false) ? 0 : 1;
if($title != ''){
	$query = "INSERT INTO ca_events (id_agence, id_conseiller, title, start, end, allDay) VALUES (:id_agence, :id_conseiller, :title, :startq, :endq, :allDay)";
	$v = array(':id_agence'=>$id_agence, ':id_conseiller'=>$id_conseiller, ':title'=>$title, ':startq'=>$start, ':endq'=>$end, ':allDay'=>$allDay);
	$stmt = excuteQuery($query, $v);
	$res = excuteQuery($GLOBALS["cnx"], "SELECT LAST_INSERT_ID( ) AS  'id_event'");
	if (!$res['status']) 
        wts_die (var_dump($res['stmt']->errorInfo()));
	$id = $res['stmt']->fetchObject();
	print $id->id_event;
	
}
else{
	print "Requete non aboutie";
	print "<br/>ID Agence: ".$id_agence."<br/>Titre: ".$title."<br/>Start: ".$start."<br/>End: ".$end."<br/>AllDay: ".$allDay;
}
//date('Y-m-d T H:i:s' , strtotime($start)+900)
//print  "INSERT INTO ca_events (id_agence, id_conseiller, title, start, end, allDay) VALUES ($id_agence, '$id_conseiller', '$title', '$start', '$end', '$allDay')";
?>