function doGet(e) { try { var uid = e.parameter.uid; var type = e.parameter.type; var availableSlots = e.parameter.availableSlots; var assignedSlot = e.parameter.assignedSlot; var timeZone = "Asia/Kolkata"; var timestamp = Utilities.formatDate( new Date(), timeZone, "dd-MM-yyyy hh:mm:ss a", ); var uidEmailMap = { E38839DA: "ammu7019344005@gmail.com", DE67E056: "madannayak23062004@gmail.com", }; var ownerEmail = uidEmailMap[uid] || ""; var sheet = SpreadsheetApp.openById( "1dYBcaik1kQvP7uywwh_8Giz2vlJ4qD0S-ZIR438RNDM", ).getActiveSheet(); var amount = ""; var durationText = ""; var entryTimeFormatted = ""; if (type === "ENTRY") { var props = PropertiesService.getScriptProperties(); props.setProperty(uid + "_entry", new Date().toISOString()); sheet.appendRow([ uid, type, availableSlots, assignedSlot, timestamp, ownerEmail, "", "", ]); var html = `

Smart Parking Entry Ticket

UID${uid}
Entry Time${timestamp}
Slot No.${assignedSlot}
WELCOME TO OUR SMART PARKING!
`; var blob = Utilities.newBlob( HtmlService.createHtmlOutput(html).getContent(), "text/html", "entry_ticket.html", ) .getAs("application/pdf") .setName("Entry_Ticket.pdf"); MailApp.sendEmail({ to: ownerEmail, subject: `Smart Parking - ENTRY Ticket for UID: ${uid}`, body: `Hello,\n\nWelcome! Your car has entered the parking lot.\n\nYour entry ticket is attached.\n\n- Smart Parking System`, attachments: [blob], }); } else if (type === "EXIT") { var props = PropertiesService.getScriptProperties(); var entryTimeStr = props.getProperty(uid + "_entry"); if (entryTimeStr) { var entryDate = new Date(entryTimeStr); var exitDate = new Date(); var durationMs = exitDate - entryDate; var minutesParked = Math.ceil(durationMs / (1000 * 60)); durationText = minutesParked + " minutes"; var chargeUnits = Math.ceil(minutesParked / 2); var charge = chargeUnits * 10; amount = "₹" + charge; entryTimeFormatted = Utilities.formatDate( entryDate, timeZone, "yyyy-MM-dd hh:mm:ss a", ); props.deleteProperty(uid + "_entry"); sheet.appendRow([ uid, type, availableSlots, assignedSlot, timestamp, ownerEmail, durationText, amount, ]); var upiLink = `upi://pay?pa=6360046560@ybl&pn=Smart%20Parking&am=${charge}&cu=INR`; var encodedUpiLink = encodeURIComponent(upiLink); var qrUrl = `https://api.qrserver.com/v1/create-qr-code/?size=200x200&data=${encodedUpiLink}`; var qrBlob = UrlFetchApp.fetch(qrUrl).getBlob(); var qrBase64 = Utilities.base64Encode(qrBlob.getBytes()); var html = `

Smart Parking Receipt

UID${uid}
Entry Time${entryTimeFormatted}
Exit Time${timestamp}
Duration${durationText}
Slot No.${assignedSlot}
Amount${amount}

Pay Now

Scan the UPI QR below or use the UPI ID manually:

UPI QR Code

UPI ID: 6360046560@ybl
Amount: ₹${charge}
Use any UPI app to scan or enter the UPI ID to pay.

Thank you for using Smart Parking. Have a safe journey!
`; var blob = Utilities.newBlob( HtmlService.createHtmlOutput(html).getContent(), "text/html", "receipt.html", ) .getAs("application/pdf") .setName("Parking_Receipt.pdf"); MailApp.sendEmail({ to: ownerEmail, subject: `Smart Parking - EXIT Receipt for UID: ${uid}`, body: `Hello,\n\nThanks! Your car has exited the parking lot.\n\nYour parking receipt is attached.\n\n- Smart Parking System`, attachments: [blob], }); Utilities.sleep(20000); MailApp.sendEmail({ to: ownerEmail, subject: "Thank You for Parking With Us!", htmlBody: `

Thank You for Visiting!

We truly appreciate your trust in our Smart Parking service.

Have a great day, and we hope to see you again soon!

Confirm Payment
Leave Feedback
Thank You!
`, }); } else { sheet.appendRow([ uid, type, availableSlots, assignedSlot, timestamp, ownerEmail, "Not found", "", ]); } } else if (type === "PAYMENT") { var uid = e.parameter.uid; var sheet = SpreadsheetApp.openById( "1dYBcaik1kQvP7uywwh_8Giz2vlJ4qD0S-ZIR438RNDM", ).getActiveSheet(); var data = sheet.getDataRange().getValues(); // Find the latest EXIT row for this UID for (var i = data.length - 1; i >= 0; i--) { if (data[i][0] == uid && data[i][1] == "EXIT") { sheet.getRange(i + 1, 9).setValue("Paid ✅"); sheet.getRange(i + 1, 10).setValue(""); // Clear Unpaid break; } } // Return a simple thank you page return HtmlService.createHtmlOutput(` Smart Parking - Payment Successful

Payment Successful 🎉

Thank you for completing the payment.

Payment Done
`); } return ContentService.createTextOutput( "Success: Data logged and email sent if applicable.", ); } catch (error) { return ContentService.createTextOutput("Error: " + error.message); } }