Online Seat Booking System

 

Online Seat Booking System

नमस्‍कार दोस्‍तो,

इस ब्‍लॉग में हम आपको बहुत ही सरल भाषा में बतायेगें की किस प्रकार गुगल शीट के डेटा एवं वेब एप स्‍क्रीप्‍ट की मदद से ऑनलाईन सीट बुंकिग सिस्‍टम बना सकते है ा

अत- आप उक्‍त साफटवेयर की मदद से अपने दैनिक कार्य सरल तरिके से कर सकतें है ा

 

In this blog we will tell you Online Seat Booking System so read the complete blog carefully and learn  Online Seat Booking System according to given guidelines.

 Practical For Click :- Practical

Step 1 :- Click to Google Sheet Copy With Source Code

Step 2 :- Click to >> Extensions >> App Script >>

Step 3 :- Create 13 file Name Given Below

Code.gs

Form.html

Index.html 

CSS.html

DataTable.html

JavaScript.html

createWorksheet.gs

bookingDetails.gs

specificDays.gs

funcs.gs

utils.gs

covidDialog.gs

backupcode.gs

Step 4 :- Click to Copy Below Code and Paste to Code.gs File

function doGet(e) { return loadForm(); } function loadForm() { var htmlOutput = HtmlService.createTemplateFromFile('Index'); var pictures = getPictures(); var tableChair = ''; // var session = getSessions(); htmlOutput.message = ''; //htmlOutput.session = session; htmlOutput.pictures = pictures; return htmlOutput.evaluate(); }

Step 5 :- Click to Copy Below Code and Paste to Form.html File

<form id="myForm" name="myForm" class="p-2 border border-light rounded bg-light" onsubmit="handleFormSubmit(this)"> <!-- Call JavaScript function "handleFormSubmit" --> <p class="h4 mb-4 text-center">Seat Booking</p> <div id="covidDialog" title="NOTICE"> <p style="font-size: 11px;">Sunrise IT Education<br><br> <p style="font-size: 14px;"> ✔ Information<span style="color: red;">*</span>: 123 </p><p style="font-size: 14px;"> </div> <div id="message"></div> <div class="form-row"> <div class="form-group"> </div> </div> <input type="text" id="RecId" name="RecId" value="" style="display: none"> <div class="form-group"> <label for="dateOfBooking">Date Of Booking<strong class="valid">*</strong> </label> <input type="text" class="form-control" id="dateOfBooking" name="dateOfBooking" autofocus="dd-mm-yyyy" readonly="readonly" placeholder="Select Date & Click Search Button for available booking" required> <span class="input-group-addon"><i class="glyphicon glyphicon-calendar"></i></span> <button type="button" id="search" name="search" class="btn btn-success" onclick="getAll();" >Search </button> <div id="dialog" class="dialog" title="TheArt Booking"> <p>Click the Search Button to continue booking</p> </div> </div> <div class="form-row"> <div class="form-group col-md-6"> <div id="lundinOutput"> </div> </div> <div class="form-group col-md-6"> <div id="divArrivalTime"> <label for="ArrivalTime">Arrival Time<strong class="valid">*</strong> </label> <select class="form-control" id="ArrivalTime" name="ArrivalTime" placeholder="Select Arrival Time" required> </select> <err6 style="color:red;"></err6> </div> </div> </div> <div class="form-row"> <div class="form-group col-md-6"> <label for="name" >Name<strong class="valid">*</strong></label> <input type="text" class="form-control" id="name" name="name" placeholder="Name" required> </div> <div class="form-group col-md-6"> <label for="phone">Phone Number<strong class="valid">*</strong> </label> <input type="tel" class="form-control" id="phone" name="phone" placeholder="Phone Number" required> </div> </div> <div class="form-row"> <div class="form-group col-md-6"> <label for="email">Email</label> <input type="email" class="form-control" id="email" name="email" placeholder="Email" > </div> <div class="form-group col-md-6"> <label for="Diners">Lunch/Dinner<strong class="valid">*</strong> </label> <select class="form-control" id="diners" name="diners" required> </select> <err4 style="color:red;"></err4> </div> </div> <div class="form-row"> <div class="form-group col-md-6"> <label for="phone">No of Person<strong class="valid">*</strong> </label> <select class="form-control" id="person" name="person" required> </select> <err1 style="color:red;"></err1> </div> <div class="form-group col-md-6"> <label for="exampleFormControlSelect1">Table <strong class="valid">*</strong> <a href="https://sunriseiteducation.blogspot.com/" target="_blank">Click here</a> to view seating</label> <select class="form-control" id="tableChair" name="tableChair" placeholder="Select Table" required> <!-- onclick="GetTotPax()" --> </select> <err2 style="color:red;"></err2> </div> </div> <div class="form-row"> <div class="form-group"> <!-- <label for="Session">Session<strong class="valid">*</strong> </label> <select class="form-control" id="session" name="session" onchange="GetTables(this.value)" required> </select> <err3 style = "color:red;"></err3> --> </div> </div> <div id="dialogMsg" class="dialogMsg" title="TheArt Booking"> </div> <input type="submit" id="submit" class="btn btn-primary" value="Submit"> <input type="button" id="reset" class="btn btn-secondary" value="Reset"> <!-- <button type="submit" class="btn btn-primary">Submit</button> <button type="button" class="btn btn-danger">Reset</button> --> <div id="output" style="color:blue;"> </div> </form> <script> //### Dropdown Session ###// /*(function () { google.script.run.withSuccessHandler( function (sessionList) { var select = document.getElementById("session"); for( var i=0; i<sessionList.length; i++ ) { var option = document.createElement("option"); if(sessionList[i][0] != ''){ option.value = sessionList[i][1]; option.text = sessionList[i][0]; select.add(option); } } } ).getSessions(); }()); */ //### Dropdown Session ###// //### Dropdown Person ###// (function () { google.script.run.withSuccessHandler( function (personList) { var select = document.getElementById("person"); for( var i=0; i<personList.length; i++ ) { var option = document.createElement("option"); if(personList[i][0] != ''){ option.value = personList[i][0]; option.text = personList[i][0]; select.add(option); } } } ).getPersons(); }()); //### Dropdown Person ###// //### Dropdown Person ###// (function () { google.script.run.withSuccessHandler( function (dinersList) { var select = document.getElementById("diners"); for( var i=0; i<dinersList.length; i++ ) { var option = document.createElement("option"); if(dinersList[i][0] != ''){ option.value = dinersList[i][1]; option.text = dinersList[i][0]; select.add(option); } } } ).getDiners(); }()); //### Dropdown Person ###// $(document).ready(function(){ var mtVal = 0; $("input[type='radio']").click(function(){ var radioValue = $("input[name='lundin']:checked").val(); alert("test"); if(radioValue){ alert("Your are a - " + radioValue); } }); $("#divArrivalTime").hide(); $("#name").prop("disabled", true); //$("#session").prop("disabled", true); $("#email").prop("disabled", true); $("#person").prop("disabled",true); $("#phone").prop("disabled", true); $("#tableChair").prop("disabled", true); $("#diners").prop("disabled", true); $("#submit").prop("disabled", true); $("#reset").prop("disabled", true); //$("#reset").prop("disabled", 'disabled'); //$('#submit'). prop('disabled','disabled'); var Alldays = ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"]; var disableDates = ["2022/02/22", "2022/02/24"]; // yyyy/MM/dd var disableDays = ["Saturday", "Sunday"]; function ShowDisableDates(date) { ymd = date.getFullYear() + "/" + ("0" + (date.getMonth() + 1)).slice(-2) + "/" + ("0" + date.getDate()).slice(-2); day = new Date(ymd).getDay(); if ($.inArray(ymd, disableDates) < 0 && $.inArray(Alldays[day], disableDays) < 0) { return [true, "enabled", "Book Now"]; } else { return [false, "disabled", "Holiday"]; } } $(function() { $("#dateOfBooking").datepicker({minDate: new Date(), maxDate: '+1m', dateFormat:'dd-mm-yy',beforeShowDay:ShowDisableDates, onSelect: function () { DisplayDate("Click Search Button to continue your booking"); }}); }); //$('#covidDialog').html('some message'); $( function() { $( "#covidDialog" ).dialog({autoOpen: true,width: 500, height: 300, show: "blind", hide: "explode", modal: true}); } ); // $( "#covidDialog" ).dialog( "open" ); //vaccinDialog $("#vaccinDialog").click(function(event){ $(this).parent().parent().children("#divvaccinDialog").dialog({ close: function(event, ui){ $("#divvaccinDialog").dialog('destory'); } }); }); function DisplayDate(message) { $( function() { $( "#dialog" ).dialog(); }); }; $('#submit').on("click", function() { // if ($('#session').val() === "session0") { // $("err3").html("Please select an item in the list."); // return false; // } // else if($('#person').val() === "Select Person") { $("err1").html("Please select an item in the list."); return false; } else if ($('#tableChair').val() === "Select Table" || $('#tableChair').val() === "") { $("err2").html("Please select an item in the list."); return false; } else if ($('#diners').val() === "Null") { $("err4").html("Please select an item in the list."); return false; } else if ($('#sltlundin').val() === "Null") { $("err5").html("Please select an item in the list."); return false; } else if ($('#ArrivalTime').val() === "Select Arrival Time") { $("err6").html("Please select Arival Time."); return false; } else{ $("err1").html(""); $("err2").html(""); // $("err3").html(""); $("err4").html(""); $("err5").html(""); $("err6").html(""); return true; } }); //Get total no of pax in TCDetails /* google.script.run.withSuccessHandler(function (paxVal) { // will be called when done mtVal = paxVal; }).getTablePax(); */ //######### Fully Booked disabled the from #############// $( "#ArrivalTime" ).on("click", function(){ if($('#fMsg').val() == 'Full') { swal("Fully Booked, Please select other date. Thank you."); $("#name").prop("disabled", true); //$("#session").prop("disabled", true); $("#email").prop("disabled", true); $("#person").prop("disabled",true); $("#phone").prop("disabled", true); $("#tableChair").prop("disabled", true); $("#diners").prop("disabled", true); $("#submit").prop("disabled", true); $("#reset").prop("disabled", true); $("#sltlundin").prop("disabled", true); $("#ArrivalTime").prop("disabled", true); } }); $( "#search" ).on("click", function(){ // alert( "Handler for select() called." ); $("demo").empty(); //document.getElementById("demo").innerHTML = ''; var searchDate = $("#dateOfBooking").val(); $("#name").prop("disabled", false); //$("#session").prop("disabled", false); $("#email").prop("disabled", false); $("#person").prop("disabled",false); $("#phone").prop("disabled", false); $("#tableChair").prop("disabled", false); $("#diners").prop("disabled", false); $("#submit").prop("disabled", false); $("#reset").prop("disabled", false); $("#lundinOutput").show(); $("#ArrivalTime").prop("disabled", false); //### Dropdown tableChair ###// /*(function () { google.script.run.withSuccessHandler(function(ar){ tableChair.length = 0; ar.forEach(function(item, index) { let option = document.createElement("option"); option.value = item; option.text = item; tableChair.appendChild(option); }); }).getTableList(searchDate); // google.script.run.withSuccessHandler(aftersubmit,GetTotPax).getSessionData(searchDate); }()); */ //### Dropdown tableChair ###// }); $("#reset").click(function(){ $("#myForm").trigger("reset"); $("#name").prop("disabled", true); // $("#session").prop("disabled", true); $("#person").prop("disabled",true); $("#email").prop("disabled", true); $("#phone").prop("disabled", true); $("#tableChair").prop("disabled", true); $("#diners").prop("disabled", true); $("#sltlundin").prop("disabled", true); $("#ArrivalTime").prop("disabled", true); $("#submit").prop("disabled", true); $("#reset").prop("disabled", true); $("#dateOfBooking").val(''); $("#name").val(''); //$("#session").val(''); $("#person").val(''); $("#email").val(''); $("#phone").val(''); $("#tableChair").val(''); $("#diners").val(''); $("#sltlundin").val(''); $("#ArrivalTime").val(''); $("#divArrivalTime").hide(); $("#lundinOutput").hide(); }); }); </script>

Step 6 :- Click to Copy Below Code and Paste to Index.html  File

<!DOCTYPE html> <html> <head> <base target="_top"> <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous"> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.bundle.min.js" integrity="sha384-xrRywqdh3PHs8keKZN+8zzc5TX0GRTLCcmivcbNJWm2rs5C8PRhcEn3czEjhAO9o" crossorigin="anonymous"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"> </script> <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/smoothness/jquery-ui.css"> <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script> <script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script> <?!= include('JavaScript'); ?> <!-- See JavaScript.html file --> <?!= include('CSS'); ?> <!-- See CSS.html file --> </head> <body> <table class="center"> <?for(var i = 1; i < pictures.length; i++) { ?> <tr><td ><img src="https://drive.google.com/uc?export=view&id=<?= pictures[i] ?>" style="width:80px;height:45px;" ></td></tr> <? } ?> </table> <div class="container"> <div class="row"> <div class="col-lg-6"> <?!= include('Form'); ?> <!-- See Form.html file --> <br><br> <div id="output"></div> </div> <div class="col-lg-6"> <?!= include('DataTable'); ?> <!-- See DataTable.html File --> </div> </div> </div> </body> </html>

Step 7 :- Click to Copy Below Code and Paste to CSS.html  File

<style> table, th, td {border: 1px solid white; border-collapse: collapse;} table.center { margin-left: auto; margin-right: auto; } .valid { color: #FF0000; } </style>

Step 8 :- Click to Copy Below Code and Paste to DataTable.html  File

<p class="h4 mb-4 text-center">Booking Details</p> <p id="demo" style = "color:red;" class="h4 mb-4 text-center"></p> <div id="dataTable" class="table-responsive"> <!-- The Data Table is inserted here by JavaScript --> </div> <br> <!-- <button type="button" class="btn btn-success btn-sm" onclick="getAllData()">Get Booking Details</button> -->

Step 9 :- Click to Copy Below Code and Paste to JavaScript html  File

<script> function getAll() { var dateDes = document.getElementById("dateOfBooking").value; document.getElementById("RecId").value = "sVal"; //alert(document.getElementById("RecId").value); //alert("test"+dateDes); // ## Lunch/Dinner ## // google.script.run.withSuccessHandler(getLunDin).specificDays(dateDes); // ## Search ## // google.script.run.withSuccessHandler(aftersubmit).getAllData(dateDes); } function aftersubmit(output) { // document.getElementById("output").innerHTML = output; document.getElementById("dataTable").innerHTML = output; } function getLunDin(result) { document.getElementById("lundinOutput").innerHTML = result; } // Prevent forms from submitting. function preventFormSubmit() { var forms = document.querySelectorAll('form'); for (var i = 0; i < forms.length; i++) { forms[i].addEventListener('submit', function(event) { event.preventDefault(); }); } } window.addEventListener('load', preventFormSubmit); function handleFormSubmit(formObject) { google.script.run.withSuccessHandler(function(output){ var msg = "<div class=\"modal\" tabindex=\"-1\" role=\"dialog\" id=\"myModal\" title=\"TheArt Booking\">"; msg += "<h5>Successfully submitted <br/> </h5>"; msg += "</div>"; $("#dialogMsg").html(msg); $("#myModal").dialog(); document.getElementById("dataTable").innerHTML = output; }).processForm(formObject); //document.getElementById("myForm").reset(); document.getElementById('dateOfBooking').value=''; document.getElementById('name').value=''; // document.getElementById('session').value=''; document.getElementById('email').value=''; document.getElementById('person').value=''; document.getElementById('phone').value=''; document.getElementById('tableChair').value=''; document.getElementById('diners').value=''; document.getElementById('name').disabled = true; // document.getElementById('session').disabled = true; document.getElementById('email').disabled = true; document.getElementById('person').disabled = true; document.getElementById('phone').disabled = true; document.getElementById('tableChair').disabled = true; document.getElementById('diners').disabled = true; document.getElementById('sltlundin').disabled = true; document.getElementById('ArrivalTime').value=''; document.getElementById('ArrivalTime').disabled = true; document.getElementById('divArrivalTime').disabled = true; document.getElementById("submit").disabled = true; document.getElementById("reset").disabled = true; } function dialogMsg(result){ document.getElementById("dialogMsg").innerHTML = result; } //### Dropdown Table Chair Filter Pre-booking tables ###// function GetTables(lundin) { var searchDate = document.getElementById('dateOfBooking').value; document.getElementById("demo").innerHTML = ''; // alert(session+" : "+searchDate); google.script.run.withSuccessHandler(function(ar) { var tableChair = document.getElementById("tableChair"); console.log(ar); tableChair.length = 0; //let option = document.createElement("option"); //option.value = ""; //option.text = ""; //tableChair.appendChild(option); ar.forEach(function(item, index) { let option = document.createElement("option"); option.value = item; option.text = item; tableChair.appendChild(option); }); }).withFailureHandler(Error).getTableList(lundin,searchDate); google.script.run.withSuccessHandler(aftersubmit).withFailureHandler(Error).getSessionData(lundin,searchDate); } //### Dropdown Table Chair Filter Pre-booking tables ###// function getFullBookMsg(){ var lundin = document.getElementById("sltlundin"); var searchDate = document.getElementById('dateOfBooking').value; //Get total no of prebooked pax google.script.run.withSuccessHandler(function (result) { // will be called when done bkPax (result); }).getBookedTablePax(searchDate, lundin); function bkPax(result) { alert("res="+result + "m="+mtVal); if((result < mtVal && searchDate != "")|| (bkPax == 0 && searchDate != "")){ $("#name").prop("disabled", false); //$("#session").prop("disabled", false); $("#email").prop("disabled", false); $("#person").prop("disabled",false); $("#phone").prop("disabled", false); $("#tableChair").prop("disabled", false); $("#diners").prop("disabled", false); $("#submit").prop("disabled", false); $("#reset").prop("disabled", false); $("#lundinOutput").show(); $("#ArrivalTime").prop("disabled", false); } else{ $("#name").prop("disabled", true); //$("#session").prop("disabled", true); $("#email").prop("disabled", true); $("#person").prop("disabled",true); $("#phone").prop("disabled", true); $("#tableChair").prop("disabled", true); $("#diners").prop("disabled", true); $("#submit").prop("disabled", true); $("#reset").prop("disabled", true); $("#lundinOutput").hide(); $("#ArrivalTime").val(''); $("#ArrivalTime").prop("disabled", true); $("#divArrivalTime").hide(); } } //document.getElementById("dataTable").innerHTML = output; } function ShowHideDiv() { var ddlsltlundin = document.getElementById("sltlundin"); var divArrivalTime = document.getElementById("divArrivalTime"); var ldValue = ddlsltlundin.value; var dpDate = document.getElementById('dateOfBooking').value; var lunCOT = document.getElementById('lunCOTime').value; var dinCOT = document.getElementById("dinCOTime").value; var lCOT = ""; var dCOT = ""; var timeFlag = false; var today = ''; var dateObj = new Date(); //Wed Sep 01 2021 15:13:55 // Mon Sep 13 2021 11:08:07 GMT+0800 (Singapore Standard Time) var dd = dateObj.getDate(); var mm = dateObj.getMonth()+1; var yyyy = dateObj.getFullYear(); if(dd<10) { dd='0'+dd; } if(mm<10) { mm='0'+mm; } var systimeval = formatAMPM(dateObj); // var time = dt.getHours() + ":" + dt.getMinutes(); var sysDateTime = dd+'-'+mm+'-'+yyyy;//+' '+systimeval; alert("sysDateTime: "+sysDateTime+" cutoffDateTime: "+dpDate+" ldValue: "+ldValue); //alert(lunCOT.replace(".", ":")); if(ldValue == "Lunch"){ var cutoffDateTime = dpDate;//+' '+ lCOT; }else{ var cutoffDateTime = dpDate;//+' '+ dCOT; } if(ldValue == "Lunch" && sysDateTime == dpDate){ { lCOT = lunCOT.replace(".", ":"); alert("if =" + "systimeval: "+systimeval+" lCOT: "+lCOT); if(lCOT <= systimeval) { timeFlag = true; } } } else if(ldValue == "Dinner" && sysDateTime != dpDate){ dCOT = dinCOT.replace(".", ":"); alert("elseif ="+ "systimeval: "+systimeval+" dCOT: "+dCOT); if(dCOT <= systimeval) { timeFlag = true; } } else{ alert("else"); timeFlag = false; } //alert("ldValue: "+ldValue+"sysDateTime: "+sysDateTime+", cutoffDateTime: "+cutoffDateTime); // alert(timeFlag +": timeval "+ timeval + "<= 1.30pm" ); if(timeFlag == true){ swal("Booking is closed for selected date: "+dpDate+".\n Please select another date available. Thank you."); document.getElementById('dateOfBooking').value=''; document.getElementById('name').value=''; // document.getElementById('session').value=''; document.getElementById('email').value=''; document.getElementById('person').value=''; document.getElementById('phone').value=''; document.getElementById('tableChair').value=''; document.getElementById('diners').value=''; document.getElementById('name').disabled = true; // document.getElementById('session').disabled = true; document.getElementById('email').disabled = true; document.getElementById('person').disabled = true; document.getElementById('phone').disabled = true; document.getElementById('tableChair').disabled = true; document.getElementById('diners').disabled = true; document.getElementById('sltlundin').disabled = true; document.getElementById('ArrivalTime').value=''; document.getElementById('ArrivalTime').disabled = true; document.getElementById('divArrivalTime').disabled = true; document.getElementById("submit").disabled = true; document.getElementById("reset").disabled = true; } else{ google.script.run.withSuccessHandler(function(ar) { console.log(ar); var ArrivalTime = document.getElementById("ArrivalTime"); ArrivalTime.length = 0; if(ddlsltlundin != "Null"){ ar.forEach(function(item, index) { if(item != ''){ let option = document.createElement("option"); option.value = item; option.text = item; ArrivalTime.appendChild(option); } }); } }).withFailureHandler(Error).getArrival(ldValue); divArrivalTime.style.display = ddlsltlundin.value == "Null" ? "none" : "block"; } //alert ("Warning danger you have not filled everything"); //document.write ("Warning danger you have not filled everything"); /* google.script.run.withSuccessHandler(function(ar) { console.log(ar); var ArrivalTime = document.getElementById("ArrivalTime"); ArrivalTime.length = 0; if(ddlsltlundin != "Null"){ ar.forEach(function(item, index) { if(item != ''){ let option = document.createElement("option"); option.value = item; option.text = item; ArrivalTime.appendChild(option); } }); } }).withFailureHandler(Error).getArrival(ldValue); divArrivalTime.style.display = ddlsltlundin.value == "Null" ? "none" : "block"; */ } function formatAMPM(date) { var hours = date.getHours(); var minutes = date.getMinutes(); // var ampm = hours >= 12 ? 'pm' : 'am'; // hours = hours % 12; // hours = hours ? hours : 12; // the hour '0' should be '12' minutes = minutes < 10 ? '0'+minutes : minutes; var strTime = hours + ':' + minutes; //+ ampm; return strTime; } /*function GetTotPax(val){ var msg = ''; var totPax = 0; var tPaxVal = document.getElementById('tPax').value; var maxPax = document.getElementById('MasterTotalPax').value; var searchDate = document.getElementById('dateOfBooking').value; //alert(searchDate+"date" + val+"tPaxVal:"+tPaxVal); if(document.getElementById('tPax').value != "null"){ var tPax = document.getElementById('tPax').value; document.getElementById("demo").innerHTML = ''; var arr1 = val.toString().split("("); var pax = arr1[1].split("pax"); //alert("pax:"+pax[0]); totPax = parseInt(tPax) + parseInt(pax[0]); //alert("Tpax: "+totPax); if(totPax < maxPax) { document.getElementById("submit").disabled = false; } else { var valMsg = maxPax - tPax; if(tPax >= maxPax) msg = "Fully Booked, Please select other session. Thank you."; else msg = "Only "+valMsg+" pax avaliable, Please select other session. Thank you."; document.getElementById("demo").innerHTML = msg; document.getElementById("submit").disabled = true; } } }*/ /* if(document.getElementById('tPax').value != "null"){ var totPax = 0; var tPax = document.getElementById('tPax').value; var arr1 = val.toString().split("("); var pax = arr1[1].split("pax)"); Logger.log(pax); // cntpax = // pax = arr1[1].substring(0,1); totPax = tPax + parseInt(pax[0]); Logger.log("Tpax: "+totPax); if(totPax <= 50) { document.getElementById("submit").disabled = false; } else { alert("Fully Booked"+totPax); document.getElementById("submit").disabled = true; } } */ </script>

Step 10 :- Click to Copy Below Code and Paste to createWorksheet.gs  File

function createWorksheet(DOBoking) { // var monthNames = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]; // var byDay = ''; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); // var monthsToAdd = 1; // var currentDate = new Date(); // currentDate.setMonth(currentDate.getMonth() + monthsToAdd); // var todayDate = Utilities.formatDate(currentDate, 'Asia/Singapore', 'dd/MM/yyyy HH:mm:ss'); //Convert in to date // var convertDate = dateFormat(DOBoking); // var array1 = convertDate.split(" "); // var cDate = array1[0]; // var arrDate1 = DOBoking.toString().split("-"); //Logger.log(arrDate1); // var cDay = arrDate1[2]; // var cMon = arrDate1[1]; // var cYear = arrDate1[0]; // byDay = cDay+"-"+cMon+"-"+cYear; //currentDate.setMonth(currentDate.getMonth()); var sheetName = DOBoking; var sheetsArray = spreadsheet.getSheets(); var creationFlag = false; //Logger.log(sheetsArray) for(var itr in sheetsArray) { if(sheetsArray[itr].getSheetName() == sheetName) { creationFlag = false; break; } else creationFlag = true; } if(creationFlag){ spreadsheet.insertSheet(sheetName); SpreadsheetApp.getActiveSheet().setFrozenRows(1); SpreadsheetApp.getActiveSheet().getRange('A1').setValue('Date Of Booking'); SpreadsheetApp.getActiveSheet().getRange('B1').setValue('Booking ID'); SpreadsheetApp.getActiveSheet().getRange('C1').setValue('Name'); // SpreadsheetApp.getActiveSheet().getRange('D1').setValue('Session'); SpreadsheetApp.getActiveSheet().getRange('D1').setValue('Email'); SpreadsheetApp.getActiveSheet().getRange('E1').setValue('Phone Number'); SpreadsheetApp.getActiveSheet().getRange('F1').setValue('Person'); SpreadsheetApp.getActiveSheet().getRange('G1').setValue('Table'); SpreadsheetApp.getActiveSheet().getRange('H1').setValue('Lunch'); SpreadsheetApp.getActiveSheet().getRange('I1').setValue('Dinner'); SpreadsheetApp.getActiveSheet().getRange('J1').setValue('Arrival Time'); SpreadsheetApp.getActiveSheet().getRange('K1').setValue('Diners'); SpreadsheetApp.getActiveSheet().getRange('L1').setValue('Entry Date'); } // if(!creationFlag) // Logger.log("Worksheet Exists"); return sheetName; }//createWorksheet

Step 11 :- Click to Copy Below Code and Paste to bookingDetails.gs  File

function getAllData(dateDes){ var sheetName = dateDes; // '03-03-2021'; var totpax = 0; var result = "<table class='table table-sm' style='font-size:0.8em'>"+ "<thead style='white-space: nowrap'>"+ "<tr>"+ //Change table headings to match witht he Google Sheet "<th scope='col'>S.No.</th>"+ "<th scope='col'>Booking ID</th>"+ "<th scope='col'>Table</th>"+ "</tr>"+ "</thead>"; // result += "<tr><td></td><td>"+sheetName+"</td>"; // result += "</tr>"; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sheetsArray = spreadsheet.getSheets(); var creationFlag = false; //Logger.log(sheetsArray) for(var itr in sheetsArray) { if(sheetsArray[itr].getSheetName() == sheetName) { creationFlag = false; break; } else creationFlag = true; } if(creationFlag){ result += "<tr><td></td><td>No More Record</td></tr>"; } else{ var rows = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName).getDataRange().getValues(); var filteredRows = rows.filter(function(row){ return row; }); // Logger.log(rows); for (var i=1;i<filteredRows.length;i++){ var rowArray = filteredRows[i]; for (var j=1;j<rowArray.length;j++){ if(j == 5){ result += "<tr><td>"+ i + "</td>"+"<td>"+ rowArray[1] + "</td>" + "<td>"+ rowArray[6] + "</td></tr>"; // var arr1 = rowArray[6].toString().split("("); // var pax = arr1[1].split("pax"); //Logger.log(pax); // cntpax = // pax = arr1[1].substring(0,1); // totpax = totpax + parseInt(pax[0]); //Logger.log("Tpax: "+totpax); } } } }// end if result += "</table>"; result += "<input type='hidden' id='lunCOTime' name='lunCOTime' value = '"+getLunCutOffTime()+"'>"; result += "<input type='hidden' id='dinCOTime' name='dinCOTime' value = '"+getDinCutOffTime()+"'>"; // result += "<input type='text' class='form-control' id='tPax' name='tPax' value = '"+getBookedTablePax(sheetName)+"'>"; // result += "<input type='text' class='form-control' id='MasterTotalPax' name='MasterTotalPax' value = '"+getTablePax()+"'>"; return result; } function getSessionData(lundin,searchDate){ var rowNo = 1; var sheetName = searchDate; // '09-07-2021'; // // session = 'session2'; //lundin = "Dinner"; var totpax = 0; var cntpax = 0; var result = "<table class='table table-sm' style='font-size:0.8em'>"+ "<thead style='white-space: nowrap'>"+ "<tr>"+ //Change table headings to match witht he Google Sheet "<th scope='col'>S.No.</th>"+ "<th scope='col'>Booking ID"+lundin+"</th>"+ "<th scope='col'>Table</th>"+ "</tr>"+ "</thead>"; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sheetsArray = spreadsheet.getSheets(); var creationFlag = false; //Logger.log(sheetsArray) for(var itr in sheetsArray) { if(sheetsArray[itr].getSheetName() == sheetName) { creationFlag = false; break; } else creationFlag = true; } if(creationFlag){ result += "<tr><td></td><td>No More Record</td><td></td></tr>"; } else{ // Logger.log(sheetName); var rows = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName).getDataRange().getValues(); var filteredRows = rows.filter(function(row){ return row; }); //Logger.log(rows); // if(filteredRows.length != 0){ for (var i=1;i<filteredRows.length;i++){ var rowArray = filteredRows[i]; for (var j=1;j<rowArray.length;j++){ if(j == 5 ) { if(lundin == "Lunch"){ var ld = rowArray[7]; } else{ var ld = rowArray[8]; } if(ld == lundin){ result += "<tr><td>"+ rowNo + "</td>" +"<td>"+ rowArray[1] + "<td>"+ rowArray[6] + "</td></tr>"; //Logger.log(rowArray[6]) // var arr1 = rowArray[6].toString().split("("); // var pax = arr1[1].split("pax"); Logger.log(pax); // cntpax = // pax = arr1[1].substring(0,1); // totpax = totpax + parseInt(pax[0]); //Logger.log("Tpax: "+totpax); rowNo++; } else if(lundin == 'Null'){ result += "<tr><td>"+ rowNo + "</td>" +"<td>"+ rowArray[1] + "<td>"+ rowArray[6] + "</td></tr>"; //Logger.log(rowArray[6]) // var arr1 = rowArray[6].toString().split("("); // var pax = arr1[1].split("pax"); Logger.log(pax); // cntpax = // pax = arr1[1].substring(0,1); // totpax = totpax + parseInt(pax[0]); //Logger.log("Tpax: "+totpax); rowNo++; } else{} } } } if(lundin != 'Null'){ var fMsg = ""; var bkMsg = ""; bkMsg += "<h4>Booking Date: " + searchDate+ "</h4><br/>"; var BKval = getBookedTablePax(sheetName,lundin); var Mtval = getTablePax(); if(BKval >= Mtval){ bkMsg += "<p style = \"color:red;\" class=\"h4 mb-4 text-center\">Fully Booked, Please select other date. Thank you.</p>"; fMsg = "Full"; } result += "<tr><td colspan = '2'> Total Seat </td><td>"+ BKval +"</td></tr>"; result += "</table>"; result += "<input type='text' class='form-control' id='fMsg' name='fMsg' value = '"+fMsg+"'>"; result += "<input type='hidden' class='form-control' id='lunCOTime' name='lunCOTime' value = '"+getLunCutOffTime()+"'>"; result += "<input type='hidden' class='form-control' id='dinCOTime' name='dinCOTime' value = '"+getDinCutOffTime()+"'>"; // result += "<input type='text' class='form-control' id='MasterTotalPax' name='MasterTotalPax' value = '"+Mtval+"'>"; result += "<p class='text-center'>For Cancel booking, Please contact 1234567890 </p>"; } // } // else // { // result += "No more data"; // } } // end if ## creationFlag ## Logger.log(result); return bkMsg + result; } function getTablePax() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var lovSheet = ss.getSheetByName("TCDetails"); var getLastRow = lovSheet.getLastRow(); var masterPax = []; var sum = 0; var data = lovSheet.getRange(3, 2, getLastRow , 1).getValues(); for(var i = data.length - 1 ; i >= 0 ; i--){ if (data[i][0] != null && data[i][0] != ""){ sum += data[i][0]; } } console.log(sum); return sum; } function getBookedTablePax(sheetName,lundin) { // sheetName = "27-08-2021"; //lundin = "Dinner"; var bktotpax = 0; var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheetsArray = ss.getSheets(); var creationFlag = false; //Logger.log(sheetsArray) for(var itr in sheetsArray) { if(sheetsArray[itr].getSheetName() == sheetName) { creationFlag = false; break; } else creationFlag = true; } console.log(creationFlag); if(creationFlag == false){ var lovSheet = ss.getSheetByName(sheetName); var getLastRow = lovSheet.getLastRow(); var rowArray = lovSheet.getRange(1, 7, getLastRow , 3).getValues(); // console.log(rowArray.length); for (var i=1;i<rowArray.length;i++){ var arrVal = rowArray[i]; //console.log(arrVal[0]); for (var j=0;j<arrVal.length;j++){ var tb = arrVal[0]; if(j == 1 && lundin == "Lunch"){ if(arrVal[1] != null && arrVal[1] != ""){ var arr1 = tb.toString().split("("); var pax = arr1[1].split("pax"); //Logger.log(pax); bktotpax = bktotpax + parseInt(pax[0]); } } if(j == 2 && lundin == "Dinner"){ if(arrVal[2] != null && arrVal[2] != ""){ var arr1 = tb.toString().split("("); var pax = arr1[1].split("pax"); //Logger.log(pax); bktotpax = bktotpax + parseInt(pax[0]); } } } } //console.log(bktotpax); } return bktotpax; } function getLunCutOffTime() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var coTimeSheet = ss.getSheetByName("TCDetails"); var lun= coTimeSheet.getRange("P2:P2").getValues(); console.log(lun); return lun; } function getDinCutOffTime() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var coTimeSheet = ss.getSheetByName("TCDetails"); var din= coTimeSheet.getRange("P3:P3").getValues(); console.log(din); return din; }

Step 12 :- Click to Copy Below Code and Paste to specificDays.gs  File

function specificDays(searchDate) { var sDate = searchDate; // "27-08-2021";// var arrDate1 = sDate.toString().split("-"); var cMon = arrDate1[1]; var cYear = arrDate1[2]; // set Month names var monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" ]; var dayNames = ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saterday"]; var dayName = 'Friday'; var monthName = monthNames[Number(cMon)]; var year = Number(cYear); var data = []; // change string to index of array var day = dayNames.indexOf(dayName); var month = monthNames.indexOf(monthName); //console.log(month+":"+day+":"+year); // determine the number of days in month var daysinMonth = new Date(year, month, 0).getDate(); // set counter var sumDays=0; // iterate over the days and compare to day for(var i=1; i<=daysinMonth; i++) { var checkDay = new Date(year, month-1, parseInt(i)).getDay(); var dVals = new Date(year, month-1, parseInt(i)); var tDate = Utilities.formatDate(dVals, 'Asia/Singapore', 'yyyy-MM-dd'); if(day == checkDay) { sumDays ++; data.push(tDate); // console.log("Dates:"+dVals); } } // end of for loop // console.log(data); // Dinner Message var dinnerMsg = getDinnerType(); var displayif = ""; // displayif += "<input type=\"radio\" id=\"lunch\" name=\"lundin\" value=\"Lunch\" checked>"; // displayif += "<label for=\"lunch\">Lunch </label>"; // displayif += "<input type=\"radio\" id=\"dinner\" name=\"lundin\" value=\"Dinner\">"; // var displayelse = ""; // displayelse += "<input type=\"radio\" id=\"lunch\" name=\"lundin\" value=\"Lunch\" checked>"; // "+item[0]+" // displayelse += "<label for=\"html\">Lunch</label>"; var lenVal = data.length - 1; var dataDate = ""; console.log("LenVal: "+lenVal); for(var j=0; j<=lenVal; j++) { if(bdateFormat(data[1]) == sDate) { displayif += "<label for=\"exampleFormControlSelect1\">Select Lunch/Dinner <strong class=\"valid\">*</strong> </label>"; displayif += "<select class=\"form-control\" id=\"sltlundin\" name=\"sltlundin\" onchange=\"GetTables(this.value);ShowHideDiv();\" required>" displayif += "<option value=\"Null\"> --Select-- </option>"; displayif += "<option value=\"Lunch\"> Lunch </option>"; displayif += "<option value=\"Dinner\"> Dinner " + dinnerMsg[0][0]+" </option>"; displayif += "</select>"; displayif += "<err5 style=\"color:red;\"></err5>"; console.log(displayif); return displayif; } else if(j == lenVal){ dataDate = bdateFormat(data[j]); //console.log("if J="+dataDate); //bdateFormat if(dataDate == sDate) { displayif += "<label for=\"exampleFormControlSelect1\">Select Lunch/Dinner <strong class=\"valid\">*</strong> </label>"; displayif += "<select class=\"form-control\" id=\"sltlundin\" name=\"sltlundin\" onchange=\"GetTables(this.value);ShowHideDiv();\" required>" displayif += "<option value=\"Null\"> --Select-- </option>"; displayif += "<option value=\"Lunch\"> Lunch </option>"; displayif += "<option value=\"Dinner\"> Dinner " + dinnerMsg[1][0]+" </option>"; displayif += "</select>"; displayif += "<err5 style=\"color:red;\"></err5>"; console.log(displayif); return displayif; } else { displayif += "<label for=\"exampleFormControlSelect1\">Select Lunch/Dinner <strong class=\"valid\">*</strong> </label>"; displayif += "<select class=\"form-control\" id=\"sltlundin\" name=\"sltlundin\" onchange=\"GetTables(this.value);ShowHideDiv();\" required>" displayif += "<option value=\"Null\"> --Select-- </option>"; displayif += "<option value=\"Lunch\"> Lunch </option>"; displayif += "<option value=\"Dinner\"> Dinner </option>"; displayif += "</select>"; displayif += "<err5 style=\"color:red;\"></err5>"; console.log(displayif); return displayif; } } } // var bkMsg = ""; // var BKval = getBookedTablePax(sDate); // var Mtval = getTablePax(); // bkMsg += "<h4>Booking Date: " + sDate+ "</h4><br/>"; // if(BKval >= Mtval){ // bkMsg += "<p style = \"color:red;\" class=\"h4 mb-4 text-center\">Fully Booked, Please select other date. Thank you.</p>"; // } } // Auto Sort the Table column function autoSort(sheetName) { var ss= SpreadsheetApp.getActiveSpreadsheet(); var ws = ss.getSheetByName(sheetName); var getLRow = ws.getLastRow(); // getRange(row, column, numRows, numColumns) var range = ws.getRange(2,1,getLRow,12); range.sort({column: 7, ascending: true}); //Logger.log(getLastRow); //return data; } function daFormat(sDate) { // sDate = "Fri Jul 09 2021 00:00:00 GMT+0800 (Hong Kong Standard Time)"; var startDate = new Date(sDate); // var weekDay; switch (startDate.getDay()) { case 0: weekDay = "Sun"; break; case 1: weekDay = "Mon"; break; case 2: weekDay = "Tue"; break; case 3: weekDay = "Wed"; break; case 4: weekDay = "Thu"; break; case 5: weekDay = "Fri"; break; case 6: weekDay = "Sat"; break; } var month; switch (startDate.getMonth()) { case 0: month = "01"; break; case 1: month = "02"; break; case 2: month = "03"; break; case 3: month = "04"; break; case 4: month = "05"; break; case 5: month = "06"; break; case 6: month = "07"; break; case 7: month = "08"; break; case 8: month = "09"; break; case 9: month = "10"; break; case 10: month = "11"; break; case 11: month = "12"; break; } var formattedDate = startDate.getDate() + "-" + month + "-" + startDate.getFullYear(); //var formattedDate = weekDay + " " + month + " " + startDate.getDate() + " " + startDate.getFullYear(); /* var mon = ''; var splitDate = sDate.toString().split(" "); var arr = ["Jan","Feb","Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; arr.forEach(function (element, index) { if(splitDate[1] == element) { mon = index + 1; } }); if(splitDate.length <= 2){ var d = sDate; } else{ var d =splitDate[2] + '-' + mon + '-' + splitDate[3]; } */ console.log(formattedDate); return formattedDate; }

Step 13 :- Click to Copy Below Code and Paste to funcs.gs  File

/* @Process Form */ function processForm(formObject) { var DOBoking = formObject.dateOfBooking; // "2021-02-27"; // "07-07-2021"; // var name = formObject.name; // "Test1"; // // var session = formObject.session; // "session1"; // var email = formObject.email; // "test@gmail.com"; // var person = formObject.person; // "2 Person"; // var phone = formObject.phone; // "12345678"; // var tChair = formObject.tableChair; // "Table 3(4pax)"; var diners = formObject.diners; // "Table 3(4pax)"; var lundin = formObject.sltlundin; // "Lunch"; // var arrivalTime = formObject.ArrivalTime; var displayValue = "Null"; if (lundin == "Lunch") { var lundinVal = "Lunch"; var dinnerVal = ""; var displayValue = "Lunch"; } else { var lundinVal = ""; var dinnerVal = "Dinner"; var displayValue = "Dinner"; } var curMon_sheetName = createWorksheet(DOBoking); //current date and time by the timezone var curDate = new Date(); var todayDate = Utilities.formatDate(curDate, 'Asia/Singapore', 'dd/MM/yyyy HH:mm:ss'); // Logger.log(todayDate); var url = "Paste Google Sheet Link"; var ss = SpreadsheetApp.openByUrl(url); var ws = ss.getSheetByName(curMon_sheetName); var bookID = getBookID(DOBoking); //Convert in to date var cDate = dateFormat(todayDate); // getDialogMsg(bookID,DOBoking,name); ws.appendRow([DOBoking, bookID, name, email, phone, person, tChair, lundinVal, dinnerVal, arrivalTime, diners, cDate]); autoSort(curMon_sheetName); return "<h4>Successfully submitted <br/> Your Booking ID: " + bookID + "<br/></h4>" + getSessionData(displayValue,DOBoking); } function dateFormat(sDate) { var mon = ''; var splitDate = sDate.toString().split(" "); // Logger.log(splitDate); var arr = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; arr.forEach(function (element, index) { if (splitDate[1] == element) { mon = index + 1; } }); if (splitDate.length <= 2) { var d = sDate; } else { var d = mon + '/' + splitDate[2] + '/' + splitDate[3] + " " + splitDate[4]; } return d; } function bdateFormat(bDate) { //var bDate = "2021-02-27"; var byDay = ''; var arrDate1 = bDate.toString().split("-"); var cDay = arrDate1[2]; var cMon = arrDate1[1]; var cYear = arrDate1[0]; byDay = cDay + "-" + cMon + "-" + cYear; Logger.log(byDay); return byDay; } function getListOfTable() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var lovSheet = ss.getSheetByName("TCDetails"); var getLastRow = lovSheet.getLastRow(); var data = []; for (var i = 2; i <= getLastRow; i++) { if (data.indexOf(lovSheet.getRange(i, 1).getValue()) === -1) { data.push(lovSheet.getRange(i, 1).getValue()); } } //Logger.log(data); return data; } function getTableList(lundin,searchDate) {// (){// var sheetName = searchDate; // '09-07-2021'; // console.log("searchDate: " + sheetName); //var lundin = "Lunch"; // var session = 'session1'; var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var sheetsArray = spreadsheet.getSheets(); var creationFlag = false; //Logger.log(sheetsArray) for (var itr in sheetsArray) { console.log(sheetName); if (sheetsArray[itr].getSheetName() == sheetName) { creationFlag = false; break; } else creationFlag = true; } if (creationFlag) { var tcDataArr = getListOfTable(); //console.log("if"+tcDataArr); return tcDataArr; } else { var ss = SpreadsheetApp.getActiveSpreadsheet(); var lovSheet = ss.getSheetByName(sheetName); var getLastRow = lovSheet.getLastRow(); var existingDataArr = []; for (var i = 2; i <= getLastRow; i++) { // Logger.log(lovSheet.getRange(i, 8).getValue()); if(lundin == "Lunch"){ Logger.log(lovSheet.getRange(i, 8).getValue()); if(lovSheet.getRange(i, 8).getValue() === lundin) { existingDataArr.push(lovSheet.getRange(i, 7).getValue()); } } else{ Logger.log(lovSheet.getRange(i, 9).getValue()); if(lovSheet.getRange(i, 9).getValue() === lundin) { existingDataArr.push(lovSheet.getRange(i, 7).getValue()); } } } Logger.log("Exist:" + existingDataArr); var tcDataArr = getListOfTable(); //filtering an array based on another array in google apps script var res = []; res = tcDataArr.filter(f => !existingDataArr.includes(f)); console.log("else" + res); return res; } } function getArrival(sltlundin){ // sltlundin = "Lunch"; var ss = SpreadsheetApp.getActiveSpreadsheet(); var ldSheet = ss.getSheetByName("TCDetails"); var getLastRow = ldSheet.getLastRow(); // getRange(row, column, numRows, numColumns) if(sltlundin == "Lunch"){ var data = ldSheet.getRange(2, 13, getLastRow - 1, 1).getValues(); } else if(sltlundin == "Dinner"){ var data = ldSheet.getRange(2, 14, getLastRow - 1, 1).getValues(); } Logger.log(data); return data; } function getBookID(DOBoking) { // DOBoking = "19-04-2021"; // session = "session1"; var bDay = ''; var arrDate1 = DOBoking.toString().split("-"); var cDay = arrDate1[0]; var cMon = arrDate1[1]; var ss = 'B'; var rowCount = ''; var sNo = ''; // if(session == "session1") // ss = "S1"; // else // ss = "S2"; //get no of rows var rows = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(DOBoking).getDataRange().getValues(); var filteredRows = rows.filter(function (row) { if (row != 0) { rowCount = row; } else rowCount = '1'; return row; }); sNo = filteredRows.length; // Logger.log("RC:" + rowCount); Logger.log(sNo); // bDay = ss+"-"+cDay+cMon+"-"+sNo; bDay = ss + "-" + cDay + cMon + "-" + sNo; return bDay; } function getPictures() { //Sort Worksheet Tabs in Alphabetical Order in Google sheet Please don't delete "sortSheets" funcion sortSheets(); var destination_id = '15C1HFYAk-2uKAGaMvKmerSRGigAaLKw8';// ID OF GOOGLE DRIVE DIRECTORY; var destination = DriveApp.getFolderById(destination_id); var files = destination.getFiles(); var file_array = []; while (files.hasNext()) { var file = files.next(); file_array.push(file.getId()); } return file_array; } function getSessions() { sortSheets(); var ss = SpreadsheetApp.getActiveSpreadsheet(); var psSheet = ss.getSheetByName("TCDetails"); var getLastRow = psSheet.getLastRow(); // getRange(row, column, numRows, numColumns) var data = psSheet.getRange(2, 4, getLastRow - 1, 2).getValues(); // Logger.log(data); return data; // Logger.log( psSheet.getRange(2, 4, getLastRow -1, 2).getValues()); } function getPersons() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var psSheet = ss.getSheetByName("TCDetails"); var getLastRow = psSheet.getLastRow(); // Logger.log( psSheet.getRange(2, 7, getLastRow -1, 2).getValues()); // Logger.log(data); return psSheet.getRange(2, 7, getLastRow - 1, 2).getValues(); } function getDiners() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var psSheet = ss.getSheetByName("TCDetails"); var getLastRow = psSheet.getLastRow(); // Logger.log( psSheet.getRange(2, 7, getLastRow -1, 2).getValues()); // Logger.log(data); return psSheet.getRange(2, 10, getLastRow - 1, 2).getValues(); } function getDinnerType() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var dtSheet = ss.getSheetByName("Event_Holidays"); var getLastRow = dtSheet.getLastRow(); //console.log(dtSheet.getRange(2, 4, getLastRow - 1, 2).getValues()); return dtSheet.getRange(2, 4, getLastRow - 1, 2).getValues(); } function getHDate() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var HDSheet = ss.getSheetByName("Event_Holidays"); var getHDLastRow = HDSheet.getLastRow(); var data_array = []; var dateArr = []; for (var i = 2; i <= getHDLastRow; i++) { if (data_array.indexOf(HDSheet.getRange(i, 1).getValue()) === -1) { data_array.push(HDSheet.getRange(i, 1).getValue()); } } //Logger.log(data_array); for (var i = 0; i < data_array.length; i++) { var mon = ''; var arr = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; var dateVal = data_array[i]; //Logger.log(dateVal); var splitDate1 = dateVal.toString().split("-"); var splitDate2 = dateVal.toString().split(" "); arr.forEach(function (element, index) { if (splitDate2[1] == element) { mon = index + 1; } }); if (splitDate1.length == 3) { var dtvals = splitDate1[0] + '-' + splitDate1[1] + '-' + splitDate1[2]; dateArr.push(dtvals); Logger.log(dtvals); } else { var dtvals = mon + '-' + splitDate2[2] + '-' + splitDate2[3]; dateArr.push(dtvals); // Logger.log("else: "+dtvals); } } // end for loop Logger.log(dateArr); return dateArr; } function getHolidayDates() { var dataDates = []; var rowsValue = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Holidays").getDataRange().getValues(); //Logger.log(rowsValue.length); for (var i = 0; i < rowsValue.length; i++) { var mon = ''; var arr = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; var dateVal = rowsValue[i]; var splitDate1 = dateVal.toString().split("-"); var splitDate2 = dateVal.toString().split(" "); arr.forEach(function (element, index) { if (splitDate2[1] == element) { mon = index + 1; } }); if (splitDate1.length == 3) { dataDates = dateVal; // Logger.log(dataDates); } else { var dtvals = mon + '-' + splitDate2[2] + '-' + splitDate2[3]; dataDates = dtvals; // Logger.log("else: "+dataDates); } } // end for loop /* var ss= SpreadsheetApp.getActiveSpreadsheet(); var hdSheet = ss.getSheetByName("Holidays"); var getLastRow = hdSheet.getLastRow(); // getRange(row, column, numRows, numColumns) var data = hdSheet.getRange(2, 1, getLastRow -1, 1).getValues().toString(); Logger.log(data); var dataDates = []; var getNoRows = data.length; var monD = ''; for(var i = 2; i <= getNoRows; i++) { // Logger.log(getNoRows); Logger.log(data[i]); */ // var splitDate = data[i].split("-"); // dataDates = new Date( splitDate[2], splitDate[1], splitDate[0]).getTime(); Logger.log(dataDates[i]); // var splitDate = Utilities.formatDate(data[i], 'Asia/Singapore', 'dd-MM-yy HH:mm:ss'); // Logger.log(data[i]); // var arr = ["Jan","Feb","Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]; // arr.forEach(function (element, index) // { // if(splitDate[1] == element) // { // monD = index + 1; // } // }); // // if(splitDate.length <= 2){ // dataDates = data[i]; // } // else{ // dataDates = monD + '-' + splitDate[2] + '-' + splitDate[3] ; // } // } Logger.log(dataDates); return dataDates; } /*function sortSheets () { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheetNameArray = []; var sheetMap = {}; var sheets = ss.getSheets(); for (var i = 0; i < sheets.length; i++) { sheetNameArray.push(sheets[i].getName()); sheetMap[sheets[i].getName()] = sheets[i] } sheetNameArray.sort(); for( var j = 0; j < sheets.length; j++ ) { //ss.setActiveSheet(ss.getSheetByName(sheetNameArray[j])); ss.setActiveSheet(sheetMap[sheetNameArray[j]]); ss.moveActiveSheet(j + 1); } }*/ function sortSheets() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheets = ss.getSheets(); var obj = sheets.map(function (s) { var sheetName = s.getSheetName(); var date = 0; if (sheetName != "GUI") { var ar = sheetName.split("-"); Logger.log(ar); date = new Date(ar[2], ar[1], ar[0]).getTime(); Logger.log(date); } return { sheet: s, converted: date }; }); obj.sort(function (a, b) { return a.converted > b.converted ? 1 : -1 }); obj.forEach(function (s, i) { ss.setActiveSheet(s.sheet); ss.moveActiveSheet(i + 1); }); }

Step 14 :- Click to Copy Below Code and Paste to utils.gs  File

/* @Include JavaScript and CSS Files */ function include(filename) { return HtmlService.createHtmlOutputFromFile(filename) .getContent(); } function DMTest(){ var sDate = "27-08-2021";//searchDate; // var arrDate1 = sDate.toString().split("-"); var cDay = arrDate1[0]; var cMon = arrDate1[1]; var cYear = arrDate1[2]; // set Month names var monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" ]; console.log(monthNames[Number(cMon)]); var dayNames = ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saterday"]; var dayName = 'Friday'; var monthName = "July"; var year = Number(cYear); var data = []; } function checkTime(){ // You could use now Date(); on its own but it will not look nice. var sysDate = Utilities.formatDate(new Date(), 'Asia/Singapore', 'dd-MM-yyyy HH:mm') var splitDate = sysDate.toString().split(" "); var cutoffTime = splitDate[0]+" "+ "16:00"; if(sysDate > cutoffTime){ console.log(sysDate +" > "+ cutoffTime); } else{ console.log(sysDate +" < "+ cutoffTime); } }

Step 15 :- Click to Copy Below Code and Paste to covidDialog.gs  File

<!DOCTYPE html> <html> <head> <base target="_top"> </head> <body> <script> $('#covidDialog').dialog({ autoOpen: true, title: "NOTICE", width: 500, height: 330, show: "blind", hide: "explode", modal: true, open: function(event, ui) { // setTimeout(function(){ // $('#covidDialog').dialog('close'); // }, 3000); //set initial time var init_time = 10; $("#covidDialog").html("<p style=\"font-size: 10px;\">This window will close automatically in " +init_time+" seconds</p><p style=\"font-size: 11px;\">We are delighted that The ART will be re-opening to the public for dine-in on Mon 16 August 2021. <br><br> Prevailing SMMs will apply: <p style=\"font-size: 14px;\"> ✔ All vaccinated<span style=\"color: red;\">*</span>: up to 5 per table, provision for children applies^ </p><p style=\"font-size: 14px;\"> ✔ Ensure TraceTogether Token/App is active at all times</p> <p style=\"font-size: 14px;\"> ✔ Mask-on at all times unless eating or drinking </p> </p>"); //start count setTimeout(countDown,1000); //function count function countDown(){ init_time--; $("#covidDialog").html("<p style=\"font-size: 10px;\">This window will close automatically in " +init_time+" seconds</p><p style=\"font-size: 12px;\">We are delighted that The ART will be re-opening to the public for dine-in on Mon 16 August 2021. <br><br> Prevailing SMMs will apply: <p style=\"font-size: 14px;\"> ✔ All vaccinated<span style=\"color: red;\">*</span>: up to 5 per table, provision for children applies^ </p><p style=\"font-size: 14px;\"> ✔ Ensure TraceTogether Token/App is active at all times</p> <p style=\"font-size: 14px;\"> ✔ Mask-on at all times unless eating or drinking </p> </p>"); if(init_time > 0){ setTimeout(countDown,1000); } else { setTimeout(function(){ $("#covidDialog").dialog("close"); }, 500); } } } }); </script> </body> </html>

Step 16 :- Click to Copy Below Code and Paste to backupcode.gs  File

<script> function ShowHideDiv() { var ddlsltlundin = document.getElementById("sltlundin"); var divArrivalTime = document.getElementById("divArrivalTime"); var ldValue = ddlsltlundin.value; var dpDate = document.getElementById('dateOfBooking').value; var lunCOT = document.getElementById('lunCOTime').value; var dinCOT = document.getElementById("dinCOTime").value; var lCOT = ""; var dCOT = ""; //alert(lunCOT.replace(".", ":")); if(ldValue == "Lunch"){ lCOT = lunCOT.replace(".", ":"); var cutoffDateTime = dpDate;//+' '+ lCOT; }else{ dCOT = dinCOT.replace(".", ":"); var cutoffDateTime = dpDate;//+' '+ dCOT; } var timeFlag = false; var today = ''; var dateObj = new Date(); //Wed Sep 01 2021 15:13:55 // Mon Sep 13 2021 11:08:07 GMT+0800 (Singapore Standard Time) var dd = dateObj.getDate(); var mm = dateObj.getMonth()+1; var yyyy = dateObj.getFullYear(); if(dd<10) { dd='0'+dd; } if(mm<10) { mm='0'+mm; } // var dt = new Date(); var systimeval = formatAMPM(dateObj); // var time = dt.getHours() + ":" + dt.getMinutes(); sysDateTime = dd+'-'+mm+'-'+yyyy;//+' '+systimeval; alert("sysDateTime: "+sysDateTime+" cutoffDateTime: "+cutoffDateTime); if(ldValue == "Lunch" && sysDateTime == cutoffDateTime){ { if(systimeval >= lCOT) { alert("if time"); timeFlag = true; } } } else if(ldValue == "Dinner" && sysDateTime <= cutoffDateTime){ timeFlag = true; } else{ timeFlag = false; } //alert("ldValue: "+ldValue+"sysDateTime: "+sysDateTime+", cutoffDateTime: "+cutoffDateTime); // alert(timeFlag +": timeval "+ timeval + "<= 1.30pm" ); if(timeFlag == false){ swal("Booking is closed for selected date: "+dpDate+"<br>. Please select another date available. Thank you."); document.getElementById('dateOfBooking').value=''; document.getElementById('name').value=''; // document.getElementById('session').value=''; document.getElementById('email').value=''; document.getElementById('person').value=''; document.getElementById('phone').value=''; document.getElementById('tableChair').value=''; document.getElementById('diners').value=''; document.getElementById('name').disabled = true; // document.getElementById('session').disabled = true; document.getElementById('email').disabled = true; document.getElementById('person').disabled = true; document.getElementById('phone').disabled = true; document.getElementById('tableChair').disabled = true; document.getElementById('diners').disabled = true; document.getElementById('sltlundin').disabled = true; document.getElementById('ArrivalTime').value=''; document.getElementById('ArrivalTime').disabled = true; document.getElementById('divArrivalTime').disabled = true; document.getElementById("submit").disabled = true; document.getElementById("reset").disabled = true; } else{ google.script.run.withSuccessHandler(function(ar) { console.log(ar); var ArrivalTime = document.getElementById("ArrivalTime"); ArrivalTime.length = 0; if(ddlsltlundin != "Null"){ ar.forEach(function(item, index) { if(item != ''){ let option = document.createElement("option"); option.value = item; option.text = item; ArrivalTime.appendChild(option); } }); } }).withFailureHandler(Error).getArrival(ldValue); divArrivalTime.style.display = ddlsltlundin.value == "Null" ? "none" : "block"; } //alert ("Warning danger you have not filled everything"); //document.write ("Warning danger you have not filled everything"); /* google.script.run.withSuccessHandler(function(ar) { console.log(ar); var ArrivalTime = document.getElementById("ArrivalTime"); ArrivalTime.length = 0; if(ddlsltlundin != "Null"){ ar.forEach(function(item, index) { if(item != ''){ let option = document.createElement("option"); option.value = item; option.text = item; ArrivalTime.appendChild(option); } }); } }).withFailureHandler(Error).getArrival(ldValue); divArrivalTime.style.display = ddlsltlundin.value == "Null" ? "none" : "block"; */ } </script>

Step 17 :- Click to Deploy >> New Deployment >> Deploy >>

More Detail See Video :-