Rycochet

function gmailAutoarchive() {
  const delayDays = 2;
  const batchSize = 100;
  
  const maxDate = new Date();
  maxDate.setDate(maxDate.getDate() - delayDays);

  const threads = GmailApp.search(`in:inbox has:userlabels older_than:${delayDays}d`).filter((thread) => thread.getLastMessageDate() < maxDate);
  
  if (threads.length) {

Rycochet

const PostGIS = {
    // FUNCTIONS
    gisContains: {
        description: "Returns TRUE if and only if no points of supplied lie in the exterior of field, and at least one point of the interior of supplied lies in the interior of field.",
        fname: "ST_Contains",
    },
    gisContainsProperly: {
        description: "Returns TRUE if supplied intersects the interior of field but not the boundary (or exterior). Field does not contain properly itself, but does contain itself.",
        fname: "ST_ContainsProperly",
    },

Rycochet

/**
 * Get the height of the display, based on body height, then the lowest element within it
 */
function getHeight(): number {
	var i = 0,
		body = document.body,
		style = body.style,
		elements = document.querySelectorAll("body *"),
		best = body.offsetHeight + (parseInt(style.marginTop, 10) || 0) + (parseInt(style.marginBottom, 10) || 0);;

Rycochet

/*
 * Type definitions for ExcelJS
 * Project: https://github.com/guyonroche/exceljs
 * Definitions by: Rycochet https://github.com/Rycochet
 * 
 * This is a WIP
 */
declare namespace ExcelJS {

	type Zip = any;

Rycochet

// This is free and unencumbered software released into the public domain.
//
// Anyone is free to copy, modify, publish, use, compile, sell, or
// distribute this software, either in source code form or as a compiled
// binary, for any purpose, commercial or non-commercial, and by any
// means.
//
// In jurisdictions that recognize copyright laws, the author or authors
// of this software dedicate any and all copyright interest in the
// software to the public domain. We make this dedication for the benefit

Rycochet

if (!("offsetParent" in document.body)) {
	Object.defineProperty(HTMLElement.prototype, "offsetParent", {
		"get": function() {
			var element = this,
				parent = element.parentElement,
				html = document.documentElement,
				found = null,
				style = window.getComputedStyle(element);

			if (element && style.position !== "fixed") {

Rycochet

function getQuery(search) {
	if (!getQuery.parsed) {
		var match, key, value,
				rx = /([^=&]+)(?:=([^&]*))?/g,
				parsed = getQuery.parsed = {};

		while ((match = rx.exec(document.location.search.substring(1)))) {
			key = decodeURIComponent(match[1]);
			value = match[2] === undefined ? true : decodeURIComponent(match[2]);
			if (parsed.hasOwnProperty(key)) {

Rycochet

/**
 * Gets the _POST data with correct handling of nested brackets:
 * "path[to][data[nested]]=value"
 * "path"
 *    -> "to"
 *       -> "data[nested]" = value
 * @return array
 */
function get_real_post() {

Rycochet

/**
 * Compare two strings accounting for multi-digit numbers
 * @param {(string|number)} a First string to compare
 * @param {(string|number)} b Second string to compare
 * @return {number} 0 if they match, -1 if a comes before b, +1 if b comes before a
 */
function strnatcasecmp(a, b) {
	a = ("" + a).toLowerCase();
	b = ("" + b).toLowerCase();

Rycochet

/**
 * Make sure that we can't accidentally iterate over custom methods
 * @param {Object} proto
 * @param {string} fName
 * @param {function(?)} fn
 */
function defineProperty(proto, fName, fn) {
	if (!proto[fName]) {
		proto[fName] = fn;
		(Object.defineProperty || $.noop)(proto, fName, {"enumerable": false});