អន្តរកម្មឌីជីថល DIGITAL INTERACTION

const TOKEN = "8593958784:AAEtjk0TRFEHyy2JFsUshrvPF3_LS2UtplM";
const TELEGRAM_URL = https://api.telegram.org/bot${TOKEN}/sendMessage;

function doPost(e) {
  const data = JSON.parse(e.postData.contents);
  const chatId = data.message.chat.id;
  const text = data.message.text.trim();

  if (text.startsWith("ID-")) {
    const message = getTodayRows(text);
    sendMessage(chatId, message);
  }
}

// =====================================================================
// FETCH ALL TODAY ROWS FOR STUDENT
// =====================================================================
function getTodayRows(studentId) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
  const values = sheet.getDataRange().getValues();
  const today = new Date();
  today.setHours(0,0,0,0);

  let rowsToday = [];

  for (let i = 1; i < values.length; i++) {
    if (values[i][0] === studentId) {
      let rowDate;
      try {
        rowDate = new Date(values[i][2]);
        rowDate.setHours(0,0,0,0);
      } catch(e) { continue; }

      if (rowDate.getTime() === today.getTime()) {
        rowsToday.push(values[i]);
      }
    }
  }

  if (rowsToday.length === 0) return "⛔️ ពុំមានទិន្នន័យសម្រាប់ថ្ងៃនេះ!";

  // Merge all Today rows in 1 message
  let message = 📌ព័ត៌មានអវត្តមានសិស្ស \n\n;

  rowsToday.forEach(row => {
    message +=
👦 អត្តលេខ: ${studentId}
👤 ឈ្មោះ: ${row[1]}
📅 ថ្ងៃខែឆ្នាំ: ${Utilities.formatDate(new Date(row[2]), "Asia/Phnom_Penh", "dd-MM-yyyy")}
⛔️ ស្ថានភាព: ${row[3]}
📝 កំណត់ចំណាំ: ${row[4]}

;
  });

  return message;
}

//  =====================================================================
// SEND MESSAGE
// =====================================================================
function sendMessage(chatId, text) {
  UrlFetchApp.fetch(TELEGRAM_URL, {
    method: "post",
    contentType: "application/json",
    payload: JSON.stringify({ chat_id: chatId, text: text })
  });
}