Showing posts with label FullCalendar in MySQL. Show all posts
Showing posts with label FullCalendar in MySQL. Show all posts

Thursday, 12 June 2014

How to Save clientEvents from FullCalendar in MySQL /w PHP ?

Edit some things in js:

$( "#datepicker_startdate" ).datepicker({
   dateFormat: 'dd/mm/yy'
  });

$( "#datepicker_enddate" ).datepicker({
   dateFormat: 'dd/mm/yy'
  });

add following lines in addEvent:
// is a date selected in the datepickers, then use those dates
var dp_startdate  = $( "#datepicker_startdate" ).datepicker('getDate');
var dp_enddate   = $( "#datepicker_enddate" ).datepicker('getDate');

if(dp_startdate !== null && dp_enddate !== null) {
 start = dp_startdate;
 end = dp_enddate;
}

before:

if($('#allday_checkbox').is(':checked')) {
 var startdate  = Date.parse(start) / 1000;
 var enddate  = Date.parse(end) / 1000;
} else {
    var startdate  = Date.parse(start.format('mm/dd/yyyy')+ ' ' + $('#timepicker_starttime')[0].value + ':00') / 1000;
    var enddate  = Date.parse(end.format('mm/dd/yyyy')+ ' ' + $('#timepicker_endtime')[0].value + ':00') / 1000;
    }

add following lines in onClickEvent:

$( "#datepicker_startdate" ).datepicker('setDate',  dateFormat(Date.parse(event.date_start),'dd/mm/yy')); 
$( "#datepicker_enddate" ).datepicker('setDate', dateFormat(Date.parse(event.date_end),'dd/mm/yy'));

before:

$('#timepicker_starttime')[0].value = event.time_start.substring(0,5);
$('#timepicker_endtime')[0].value = event.time_end.substring(0,5);

and following lines in updateEvent:

// is a date selected in the datepickers, then use those dates
var dp_startdate  = $( "#datepicker_startdate" ).datepicker('getDate');
var dp_enddate   = $( "#datepicker_enddate" ).datepicker('getDate');

if(dp_startdate !== null && dp_enddate !== null) {
 event.start = dp_startdate;
 event.end = dp_enddate;
}

before:

if($('#allday_checkbox').is(':checked')) {
 var startdate = Date.parse(event.start) / 1000;
 var enddate = event.end !== null ? Date.parse(event.end) / 1000 : startdate;
 event.allDay = 1;
}