Skip to content

Instantly share code, notes, and snippets.

View supernovaplus's full-sized avatar

SuperNova+ supernovaplus

View GitHub Profile
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]);
}
}
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()));
}
}
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");
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();
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;
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
supernovaplus / Day 1 - Advent of Code 2019.js
Last active December 2, 2019 22:23
Day 1 - Advent of Code 2019
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
supernovaplus / dl.js
Last active April 17, 2020 15:26
downloading file with node js
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"],
<?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
supernovaplus / timestamp.js
Created July 16, 2020 16:09
convert timestamp to seconds
data.duration.split(".")[0].split(":").reduce((acc,val,i)=>i===0 ? acc += +val * 60 * 60 : i===1 ? acc += +val * 60 : acc += +val,0)