supernovaplus

function DeleteAllTriggers() {
  var allTriggers = ScriptApp.getProjectTriggers();
  if(allTriggers.length<1)return Logger.log("list is empty");
  Logger.log("Deleted => "+allTriggers.length);
  for (var i = 0; i < allTriggers.length; i++) {
    ScriptApp.deleteTrigger(allTriggers[i]);
  }
}

supernovaplus

function LogAllTriggers() {
  var allTriggers = ScriptApp.getProjectTriggers();
  if(allTriggers.length<1)return Logger.log("list is empty");
  Logger.log("Trigers Count: "+allTriggers.length);
  for (var i = 0; i < allTriggers.length; i++) {
    Logger.log(i+1+"->"+allTriggers[i].getHandlerFunction()+"=>"+allTriggers[i].getTriggerSource()+"=>"+allTriggers[i].getUniqueId()+"=>"+JSON.stringify(allTriggers[i].getEventType()));
  }
}

supernovaplus

function fireselected(){
  var spreadsheet = SpreadsheetApp.getActive();
//Logger.log(spreadsheet.getName());

  
  if(spreadsheet.getSheetName()!=="Vouchers")return Logger.log("not vouchers page");
  if(spreadsheet.getActiveRange().getColumn() !== 2)return Logger.log("not second column");
  if(!spreadsheet.getActiveRange().getValue().match(/#/g))return Logger.log("wrong cell");
  

supernovaplus

function MoveBatEmployeesInactiveSheetWhoLeftCompany() {
  var console = {log: function(item){return Logger.log(item)}}
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet1 = spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Vouchers'), true);
  
  var ActiveEmployeeArray = sheet1.getRange('S4:S132').getValues().filter(function(item){return item[0]!="";})
  
  var sheet2 = spreadsheet.setActiveSheet(spreadsheet.getSheetByName('InactiveList'), true);
  
  var ScanningThisArray = sheet2.getRange('I2:I173').getValues();

supernovaplus

function companyBankVouchersMove() {
  var initialScanLocation = 69;
  var spreadsheet = SpreadsheetApp.openById("-");
  
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Company Bank'), true);
  var column = spreadsheet.getRange('D'+initialScanLocation+':D');
  var values = column.getValues(); // get all data in one call
  
  var location = 0;

supernovaplus

function COPYVOUCHERSONDATE() {
  //if(new Date().getDay()!=6)return Logger.log("not today ;)");
  
  var DATETIMESTRING = Utilities.formatDate(new Date(),"GMT+1","M/d");

  var spreadsheet = SpreadsheetApp.openById("-");
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Vouchers'), true);
  spreadsheet.duplicateActiveSheet();
  spreadsheet.moveActiveSheet(17);

supernovaplus

var input = `149579
95962
97899
etc...`;

input = input.split("\n").map(n=>Number(n));

const part1 = (number) => {
    let val = (Math.floor(number/3)-2)
    return val > 0 ? val : 0

supernovaplus

const fs = require('fs')
const fetch = require("node-fetch")
const path = "C:\\DOWNLOADS\\";
const urlArray = [
    //["url","fileName"]
    //"url"
    //["url","filename"],"url",["url","filename"]
    
    "http://somesite.com/somevideo.mp4",
    ["http://somesite.com/somevideo2.mp4","renamedvideo.mp4"],

supernovaplus

<?php
//case(3): array_push($fetch_array, [&$response->vouchers,"select * from vouchers_config;"]); break;

function fetchdb($data){
    global $response, $conn; 
    $query = "";
    for ($i=0; $i < count($data); $i++) { 
        $query .= $data[$i][1];
    }
    if (mysqli_multi_query($conn, $query)) {

supernovaplus

data.duration.split(".")[0].split(":").reduce((acc,val,i)=>i===0 ? acc += +val * 60 * 60 : i===1 ? acc += +val * 60 : acc += +val,0)