<?php
include('../scripts/includes/pdo_connect.php');
//*** Edit these to fit your needs ***//
$dbtableblock = 'name of your appointment table';
//*** End of edit ***//


$sql = $pdo->prepare("SELECT date(date) a FROM $dbtableblock WHERE time ='' ORDER BY date DESC");
$sql->execute();
$results = $sql;
$results = array();;
$sql->bindColumn('a',$a);
while($row = $sql->fetch()) {
$results = array_merge($results, explode(',', date('Y-n-j',strtotime($a))));

}

?>

<script src="../scripts/jquery-ui-1.13.1.custom/jquery.min.js"></script>

<script src="../scripts/jquery-ui-1.13.1.custom/jquery-ui.js"></script>

<script>
var jQ = $.noConflict();
jQ(function() {

//***Datepicker
var UnavailableDates = ["<?php echo implode('","', $results);?>"];

function Unavailable(date) {
dmy1 =date.getFullYear() + "-" + (date.getMonth()+1) + "-" + date.getDate() ;
if (jQ.inArray(dmy1, UnavailableDates) >=0 || !jQ.datepicker.noWeekends(date)[0]) {
return [false,"", "Appointments Unavailable"];
} else {
return [true, "", "Appointments Available"];
}
}


jQ("input[name='date']").datepicker({

dateFormat: "yy-mm-dd",
changeMonth: true,
changeYear: false,
minDate: 0,
beforeShowDay: Unavailable,
dateFormat: 'yy-mm-dd',
onSelect: function(date,i) {
if(date !== i.lastVal){
jQ('select[name="time"]').load("../scripts/includes/time-drop-down.php?date=" + jQ('input[name="date"]').val());
}
}

});
jQ('select[name="time"]').change(function() {
if(jQ(this).val()== ''){
jQ(':input[type="submit"]').prop('disabled', true);
}else{jQ(':input[type="submit"]').prop('disabled', false);}
});

jQ("form").submit(function () {
if(jQ('select[name="time"]').val()== ''){
jQ(':input[type="submit"]').prop('disabled', true);
}else{jQ(':input[type="submit"]').prop('disabled', false);}
});

});
</script>

$filename = $this->name . '.html';

$filename = $this->name . '.php';

"time":{"label":"Select an available Time","fieldtype":"dropdown","required":true,"values":[""]