G-Drive 智慧工坊 – 磁碟檔案 002 – 檔案屬性與日期比對

function getDateFormat() {
  let now = new Date();

  // ISO 8601
  console.log(now.toISOString()); // 2024-06-26T09:16:29.183Z
  // Local Time
  console.log(now.toString()); // Wed Jun 26 2024 17:16:29 GMT+0800 (GMT+08:00)
  // RFC 7231
  console.log(now.toUTCString()); // Wed, 26 Jun 2024 09:16:29 GMT
  // Milliseconds
  console.log(now.getTime()); // 1719393389183
}

function getDateDetail()
{
  // Year
  console.log("Year:", now.getFullYear());
  // Month (0-11, where 0 = January and 11 = December)
  console.log("Month:", now.getMonth() + 1); // +1 because months are zero-indexed
  // Day of the Month
  console.log("Day of the Month:", now.getDate());
  // Day of the Week (0-6, where 0 = Sunday and 6 = Saturday)
  console.log("Day of the Week:", now.getDay());
  // Hours (0-23)
  console.log("Hours:", now.getHours());
  // Minutes (0-59)
  console.log("Minutes:", now.getMinutes());
  // Seconds (0-59)
  console.log("Seconds:", now.getSeconds());
  // Milliseconds (0-999)
  console.log("Milliseconds:", now.getMilliseconds());
  // Timezone Offset in Minutes
  console.log("Timezone Offset (in minutes):", now.getTimezoneOffset());
}

// Get all attributes of file
function getFileAttribute() {
  const FILE_ID = 'FILE_ID';
  const file = DriveApp.getFileById(FILE_ID);

  // Basic Attribute
  const fileName = file.getName();
  const fileSize = file.getSize();
  const fileId = file.getId(); 
  const fileUrl = file.getUrl();
  const fileDescription = file.getDescription();
  const fileType = file.getMimeType();
  const fileCreatedDate = file.getDateCreated();
  const fileLastUpdated = file.getLastUpdated();
  const fileOwner = file.getOwner().getEmail();
  const fileEditors = file.getEditors().map(function(editor) {
    return editor.getEmail();
  }).join(', ');
  const fileViewers = file.getViewers().map(function(viewer) {
    return viewer.getEmail();
  }).join(', ');

  console.log('File Name: ' + fileName);
  console.log('File Size: ' + fileSize + ' bytes');
  console.log(`File ID: ${fileId}`); 
  console.log('File URL: ' + fileUrl);
  console.log('File Description: ' + fileDescription);
  console.log('File Type: ' + fileType);
  console.log('File Created Date: ' + fileCreatedDate);
  console.log('File Last Updated: ' + fileLastUpdated);
  console.log('File Owner: ' + fileOwner);
  console.log('File Editors: ' + fileEditors);
  console.log('File Viewers: ' + fileViewers);

  // File download URL
  const fileDownloadUrl = file.getDownloadUrl(); 
  console.log(`File Download URL: ${fileDownloadUrl}`); 

  // An data intercahnge object
  const fileBlob = file.getBlob(); 
  console.log(`File BLOB: ${fileBlob.getBytes()}`); 
}

// - Scan childs in the target folder
// -- Sort all childs by date created
// ---- Compare date created with date today if is |lifeTime| days ago
// ------ T
// -------- Delete the file
// ------ F
// -------- BREAK the loop for there's no more longer than max life-time
function scanLifeTime() {
  let folderId = 'FOLDER_ID';

  // Max lifetime in days
  let lifeTime = 7 * (24 * 3600 * 1000);

  console.warn('# RUN - scanLifeTime()');

  try {
    // Parent 
    let folder = DriveApp.getFolderById(folderId);
    // Childs
    let files = folder.getFiles();

    // List to store file info
    let fileList = [];

    // Timestamp to check lifetime
    let today = new Date().setHours(0, 0, 0, 0);

    // Gather all files into an array
    while (files.hasNext()) {
      let file = files.next();
      fileList.push({
        file: file,
        createdDate: file.getDateCreated()
      });
    }

    console.warn(`@ Sorting Files by Time Created`);

    // Sort files by their creation date
    fileList.sort((a, b) => a.createdDate - b.createdDate);

    console.warn(`@ Deleting Files over Lifetime`);

    // Iterate over the sorted array and delete files over lifetime
    for (let i = 0; i < fileList.length; i++) {
      let fileInfo = fileList[i];
      let createdDate = fileInfo.createdDate.setHours(0, 0, 0, 0);

      console.log(today - createdDate)

      if ((today - createdDate) >= lifeTime) {
        console.log(`(ID: ${fileInfo.file.getId()}) File ${fileInfo.file.getName()} removed for over lifetime`);
        // Move to trash can
        fileInfo.file.setTrashed(true);
      }
      // BREAK loop for no more longer than lifetime 
      else { console.log(`No files older than lifetime`); break; }
    }
  } catch (error) { console.error(error); }

  console.warn('# END - scanLifeTime()');
}