naosim

テストだよ

naosim

{
  "type": "array",
  "items": {
    "$ref": "#/$defs/table"
  },
  "$defs": {
    "table": {
      "name": "table",
      "type": "object",
      "properties": {

naosim

import http from "http";
import fs from "fs";
import path from "path";
import { fileURLToPath } from 'url';
const __filename = fileURLToPath(import.meta.url);
const __dirname = path.dirname(__filename);

const server = http.createServer((req, res) => {
  const reqPath = req.url;
  const sanitizedPath = path.normalize(reqPath).replace(/^(\.\.[\/\\])+/, '');

naosim

function getBitsAfter33(ipv6) {
  function hexTo2Bits(v, bitLength = 4) {
    if(v >= 10) {
      v = "ABCDEF"[v - 10]
    }
    return (new Array(bitLength).fill("0").join("") + parseInt(v, 16).toString(2)).slice(-bitLength);
  }
  function bit2toHex(num) {
    var p = num.split("").reverse().map((v, i) => Math.pow(2, i) * parseInt(v)).reduce((memo, v) => memo + v, 0);
    if(p < 10) {

naosim

// いい感じに同期します
// 新規タスクの追加
// 変更点の更新
// GoogleTasksの読み込み
function update() {
  new MainService().update();
}

function onOpen() {
  const customMenu = SpreadsheetApp.getUi()

naosim

function exportCalendarEvents() {
  // カレンダーIDを入力してください
  var calendarId = "primary";
  // フォーマット
  var format = "yyyy/MM/dd HH:mm:ss";
  
  // 今日の日付を取得
  var today = new Date();
  // 今日の0時0分0秒を計算
  var startOfDay = new Date(today.getFullYear(), today.getMonth(), today.getDate());

naosim

const headers = ["ID", "タスク名", "開始日", "終了日", "日数", "依存タスク"];

function setup() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("シート1");
  if(sheet.getRange(1, 1).getValue() == "入力用") {
    throw new Error("すでに実行済みです");
  }
  sheet.appendRow(["入力用"])
  sheet.appendRow(headers)
  

naosim

function parseDateString(dateStr, holidays) {
  let date;

  if (/^\d{4}\/\d{1,2}\/\d{1,2}$/.test(dateStr)) {
    // 日付指定の場合
    date = new Date(dateStr);
  } else if (/^FY\d{2}\/\dQ$/.test(dateStr)) {
    // 年度・四半期指定の場合
    const fy = parseInt(dateStr.slice(2, 4), 10);
    const q = parseInt(dateStr.slice(-2, -1), 10);

naosim

function addBusinessDays(date, daysToAdd, holidays) {
  // weekends: 0 = Sunday, 6 = Saturday
  const weekendDays = [0, 6];
  // create a set of holidays for O(1) lookup time
  const holidaySet = new Set(holidays.map((holiday) => holiday.getTime()));
  let businessDaysAdded = 0;
  let currentDate = new Date(date.getTime());
  
  while (businessDaysAdded < daysToAdd) {
    // add one day to the current date

naosim

function getFilePathListById(fileId) {
  var file = DriveApp.getFileById(fileId);
  return getParentPathList(file).map(v => 'G:\\' + v + '\\' + file.getName());
}

function iteratorToArray(iterator) {
  var result = [];
  while (iterator.hasNext()) {
    result.push(iterator.next());
  }