2b:null 2c:["$","title",null,{"children":"Scheduling Optimization | NB.AI Solutions Team | Observable"}] 31:Tbef,viewof myMap = { apiKey; const BLUE = [23, 184, 190]; const RED = [253, 128, 93]; let origMarker = undefined; let destMarker = undefined; let step = 1; let timerId = 0; let markerCollection = []; await visibility(); const container = html`

`; yield container; let pos = { lat: 36.195, lng: -86.8 }; originSearchResult; const nbmap = (container.value = new nextbillion.maps.Map({ container: container, center: pos, zoom: 13, maxZoom: 18, minZoom: 5, style: "https://api.nextbillion.io/maps/streets/style.json", scrollZoom: true })); nbmap.map.on("click", (e) => { if (geofenceData) { const theFence = isPointInAnyGeofence( [e.lngLat.lng, e.lngLat.lat], geofenceData ); let srchPt = new nextbillion.maps.Marker({ color: theFence ? "#00dd00" : "#ed9a9a", draggable: false, scale: 0.8, offset: [0, 0] }) .setLngLat({ lat: e.lngLat.lat, lng: e.lngLat.lng }) .addTo(nbmap.map); } }); nbmap.map.on("load", function () { if (geofenceData) { let coordinates = []; showGeofences(nbmap); geofenceData.data.list.forEach((fence) => { fence.geojson.coordinates[0].forEach((c) => { coordinates.push(c); }); }); let bounds = coordinates.reduce(function (bounds, coord) { return bounds.extend(coord); }, new nextbillion.maps.LngLatBounds(coordinates[0], coordinates[0])); nbmap.map.fitBounds(bounds, { padding: 120 }); const fence = isPointInAnyGeofence( mutable originSearchResult[0].center, geofenceData ); if (fence) { mutable originSearchResult[0].geofence = fence; } if (mutable originSearchResult.length) { let srchPt = new nextbillion.maps.Marker({ color: fence ? "#00dd00" : "#ed9a9a", draggable: false, scale: 0.8, offset: [0, 0] }) .setLngLat({ lat: mutable originSearchResult[0].center[1], lng: mutable originSearchResult[0].center[0] }) .addTo(nbmap.map); new nextbillion.maps.Popup({ closeButton: false, closeOnClick: false, offset: { top: [0, 0], "top-left": [0, 0] } }) .setLngLat({ lat: mutable originSearchResult[0].center[1], lng: mutable originSearchResult[0].center[0] }) .setHTML(fence ? `${fence.name}` : "out of service area") .addTo(nbmap.map); coordinates.push(mutable originSearchResult[0].center); let bounds = coordinates.reduce(function (bounds, coord) { return bounds.extend(coord); }, new nextbillion.maps.LngLatBounds(coordinates[0], coordinates[0])); nbmap.map.fitBounds(bounds, { padding: 120 }); } } }); invalidation.then(() => nbmap.map.remove()); }32:T5f37,chart = { // Specify the charts’ dimensions. The height is variable, depending on the layout. const resetBtn = document.getElementById("resetButton"); //const addAppointmentBtn = document.getElementById("checkButton"); const width = 1328; const marginTop = 50; const marginRight = 0; const marginBottom = 50; const marginLeft = 120; // Rows are separated by dx pixels, columns by dy pixels. recalculateSchedule(); let root = d3.hierarchy(mutable baseSchedule); const dx = 35; let dy = (width - marginRight - marginLeft) / (1 + root.height); let x0 = Infinity; let x1 = -x0; // Define the tree layout and the shape for links. const tree = d3.tree().nodeSize([dx, dy]); let selectedNode = null; // Define the diagonal function to create link paths const diagonal = d3 .linkHorizontal() .x((d) => d.y) .y((d) => d.x); // Create the SVG container, a layer for the links and a layer for the nodes. const svg = d3 .create("svg") .attr("width", width) .attr("height", dx) .attr("viewBox", [-marginLeft, -marginTop, width, dx]) .attr( "style", "max-width: 100%; height: auto; font: 12px sans-serif; user-select: none;" ); const gLink = svg .append("g") .attr("fill", "none") .attr("stroke-opacity", 0.4) .attr("stroke-width", 1.5); const gNode = svg .append("g") .attr("cursor", "pointer") .attr("pointer-events", "all"); function dragStarted(event, d) { if (d.depth === 3) { if (!event.active) { root.eachBefore((node) => { node.x0 = node.x; node.y0 = node.y; }); } // Raise the node to the top of the rendering order d3.select(this).raise().attr("stroke", "red"); // Set the drag start position to the current node's position console.log(`Start ${d.x0} ${d.y0}`); d.x = d.x0; d.y = d.y0; } } function dragged(event, d) { // Get the transformation applied to the SVG container, if any if (d.depth === 3) { const transform = d3.zoomTransform(svg.node()); console.log(`Dragging ${d.x} ${d.y} ${event.y} ${event.x}`); // Adjust the coordinates based on the transform d.x = event.x; //d.y = event.x; // Move the node to the new position d3.select(this).attr("transform", `translate(0,${d.x})`); // Update the links connected to the dragged node gLink.selectAll("path").attr("d", (link) => { if (link.source === d || link.target === d) { return diagonal({ source: link.source, target: link.target }); } }); } } function dragEnded(event, d) { d3.select(this).attr("stroke", null); // Find the nearest node to the drop location const nearestNode = root .descendants() .filter((node) => node !== d && node.depth === d.depth) // Ensure we are comparing nodes at the same depth .reduce((closest, node) => { const distance = Math.sqrt( Math.pow(node.x - d.x, 2) + Math.pow(node.y - d.y, 2) ); return !closest || distance < closest.distance ? { node, distance } : closest; }, null); if (nearestNode) { // Get the parent of the nearest node const newParent = nearestNode.node.parent; if (newParent && newParent !== d.parent) { // Remove the node from its original parent's children array if (d.parent) { d.parent.children = d.parent.children.filter((child) => child !== d); if (d.parent.children.length === 0) { d.parent.children = null; // Remove empty children array if no children left } } // Update the `mutable baseSchedule` to reflect the change const nodeData = d.data; const oldParentData = findNodeByName( mutable baseSchedule, d.parent.data.name ); const newParentData = findNodeByName( mutable baseSchedule, newParent.data.name ); // Remove from old parent in the baseSchedule if (oldParentData && oldParentData.children) { oldParentData.children = oldParentData.children.filter( (child) => child !== nodeData ); } // Add to new parent in the baseSchedule if (newParentData) { if (!newParentData.children) { newParentData.children = []; } newParentData.children.push(nodeData); } // Update the parent reference in the hierarchy d.parent = newParent; // Recompute the layout and re-render the tree root = d3.hierarchy(mutable baseSchedule); // Rebuild the hierarchy update(event, root); } } } function removeNode(baseSchedule, node) { // Traverse the baseSchedule to find the parent node function traverseAndRemove(currentNode, nodeToRemove) { if (!currentNode.children) return false; // Find the index of the node to remove const index = currentNode.children.findIndex( (child) => child.name === nodeToRemove.data.name ); if (index !== -1) { // Remove the node currentNode.children.splice(index, 1); return true; } // Recursively check in children for (let child of currentNode.children) { const result = traverseAndRemove(child, nodeToRemove); if (result) return true; } return false; } const nodeRemoved = traverseAndRemove(baseSchedule, node); if (nodeRemoved) { console.log("Node removed successfully"); } else { console.error("Node not found in baseSchedule"); } // Force the update of mutable baseSchedule mutable baseSchedule = baseSchedule; } async function update(event, source) { const duration = event?.altKey ? 2500 : 550; // hold the alt key to slow down the transition const nodes = root.descendants().reverse(); const links = root.links(); // Compute the new tree layout. tree(root); let left = root; let right = root; root.eachBefore((node) => { if (node.x < left.x) left = node; if (node.x > right.x) right = node; }); const height = right.x - left.x + marginTop + marginBottom; const transition = svg .transition() .duration(duration) .attr("height", height) .attr("viewBox", [-marginLeft, left.x - marginTop, width, height]) .tween( "resize", window.ResizeObserver ? null : () => () => svg.dispatch("toggle") ); // Update the nodes… const node = gNode.selectAll("g").data(nodes, (d) => d.id); // Enter any new nodes at the parent's previous position. const nodeEnter = node .enter() .append("g") .call((selection) => { // Apply drag behavior only if depth is 3 selection.each(function (d) { if (d.depth === 3) { d3.select(this).call( d3 .drag() .on("start", dragStarted) .on("drag", dragged) .on("end", dragEnded) ); } }); }) .attr("transform", (d) => { // Adjust horizontal spacing based on depth if (d.depth === 2) { d.y = d.depth * dy * 0.75; // Adjust spacing for depth 2 } else if (d.depth === 3) { d.y = d.depth * dy * 0.75; } else { d.y = d.depth * dy; } return `translate(${d.y},${d.x})`; }) .attr("fill-opacity", 0) .attr("font-family", "Helvetica Neue") .attr("font-size", (d) => (d.depth == 1 ? 16 : 12)) .attr("font-color", "blue") .style("font-weight", (d) => (d.depth <= 2 ? "bold" : "bold")) .style("fill", (d) => (d.depth === 1 ? "blue" : "black")) .on("dblclick", (event, d) => {}) .on("contextmenu", async (event, d) => { event.preventDefault(); // Right click action over a time slot if (d.depth === 2) { const parentNode = findParentNode(root, d); console.log(parentNode); const path = `2024-08-15 > ${parentNode.data.name} > ${d.data.name}`; const newNodeData = { name: `${d.data.name.split("-")[0]}:00 ${ mutable originSearchResult[0].place_name }`, location: `${mutable originSearchResult[0].center[1]},${ mutable originSearchResult[0].center[0] }`, arrival: 1723731238, new: true }; if (!d.children) { d.children = []; } d.children.push(newNodeData); const success = insertChildAtPath( mutable baseSchedule, path, newNodeData ); console.log(mutable baseSchedule); //saveHierarchyToBaseSchedule(root); // Update the D3 hierarchy with the new node root = d3.hierarchy(mutable baseSchedule); update(event, root); } // Right click action over an appointment if (d.depth === 3 && d.data.new) { // Remove the node from the hierarchy removeNode(mutable baseSchedule, d); root = d3.hierarchy(mutable baseSchedule); update(event, root); } else if (d.depth === 1) { // Right click action over a technician - optimize this tech's route mutable optStatus = html`

Optimizing ${d.data.name}

`; let location = []; let loc_index = 0; let jobs = []; let vehicles = []; let locations = []; let bodyData = []; let nbrVehicles = 1; location.push(panel1.startLocation); let vehicle = { id: d.data.name, description: d.data.name, start_index: loc_index, end_index: loc_index++, time_window: [ panel1.shiftStart.getTime() / 1000 + 12 * 3600, panel1.shiftStart.getTime() / 1000 + 12 * 3600 * 2 ] }; vehicles.push(vehicle); // for each timeslot let idx = 0; d.children.forEach((ts) => { const startTime = ts.data.start; const endTime = ts.data.end; // for each job in a time slot if (ts.children) { ts.children.forEach((j) => { if ( !j.data.name.includes("start") && !j.data.name.includes("end") ) { let job = { id: `${idx++} ${j.data.name.substring( 6, j.data.name.length )}`, description: j.data.name.substring(6, j.data.name.length), location_index: loc_index++, time_windows: [[startTime, endTime]], service: parseInt(panel1.serviceDuration) * 60 }; jobs.push(job); location.push(j.data.location); } }); } }); locations = { id: 12, location: location }; bodyData.push({ description: `MVRP Test ${new Date().toISOString()}`, locations: { id: 1, location: location }, vehicles: vehicles, jobs: jobs }); //console.log(bodyData[0]); const reoptimizedRoute = await Promise.all( bodyData.map(async (data) => { return mvrp(data, { objective: { minimise_num_depots: false } }); }) ); // Result returned - build the updated nodes under each time slot let foundTechnician = findNodeByName( mutable baseSchedule, d.data.name ); // rebuild based on reoptimization if (reoptimizedRoute[0].result.summary.unassigned > 0) { mutable optStatus = html`

Not possible to add appointment based on current schedule!

`; } else { // clear out the jobs from each timeslot foundTechnician.children.forEach((ts) => { ts.children = []; }); mutable optStatus = html`

Success!

`; reoptimizedRoute[0].result.routes[0].steps.forEach((s) => { let j = { name: s.type.includes("job") ? `${formatTimestampToHHMM(s.arrival + s.waiting_time)} ${ s.description }` : `${formatTimestampToHHMM(s.arrival + s.waiting_time)} ${ s.type }`, location: `${s.location[0]},${s.location[1]}`, arrival: s.arrival + s.waiting_time }; let slot = foundTechnician.children.find( (timeSlot) => s.arrival + s.waiting_time >= timeSlot.start && s.arrival + s.waiting_time <= timeSlot.end ); if (slot) { slot.children.push(j); } }); root = d3.hierarchy(mutable baseSchedule); dy = (width - marginRight - marginLeft) / (1 + root.height); update(null, root); } } }) .on("click", (event, d) => { //if (d.depth === 1) { console.log("open-close node"); // Toggle the children on click //root = d3.hierarchy(mutable baseSchedule); if (d.children) { d._children = d.children; // Collapse the node by hiding its children d.children = null; } else { d.children = d._children; // Expand the node by showing its hidden children d._children = null; } update(event, d); // Update the tree with the new state //root = d3.hierarchy(mutable baseSchedule); }); // Append a rectangle behind the node to act as a background nodeEnter .filter((d) => d.depth === 3) .append("rect") .attr("x", (d) => { return d.data.name.toLowerCase().includes("start") ? 0 : d.data.name.toLowerCase().endsWith("end") ? 0 : 58; }) //.attr("x", 70) // Adjust positioning as needed .attr("y", -18) .attr("width", (d) => d.data.name.length * 8 + 60) // .attr("height", 34) // Adjust height as needed .attr("rx", 6) // Rounded corners .attr("ry", 6) .attr("fill", (d) => { //console.log(d._children); return d.data.name.toLowerCase().includes("start") ? "green" : d.data.name.toLowerCase().endsWith("end") ? "red" : d.data.new ? "#93cea3" : "#d9c0ea"; }); nodeEnter .append("circle") .attr("r", 5.5) //.attr("fill", (d) => (d._children ? "#555" : "#999")) .attr("fill", (d) => { //console.log(d._children); const validChildren = d._children ? d._children.filter( (child) => !child.data.name.toLowerCase().includes("start") && !child.data.name.toLowerCase().includes("end") ) : d._children; return validChildren && validChildren.length >= parseInt(panel1.maxPerSlot) ? "red" : validChildren && validChildren.length ? "#d9c0ea" : "gray"; }) .attr("stroke-width", 10); nodeEnter .filter((d) => d.depth === 1) .append("clipPath") .attr("id", (d) => `clip-${d.id}`) .append("circle") .attr("cx", 25 - 10) // Adjust x position for clipping .attr("cy", 25 - 15) // Adjust y position for clipping .attr("r", 25); // Radius of the circular clip nodeEnter .filter((d) => d.depth === 1) .append("image") .attr("xlink:href", (d) => d.data.name.includes("BUZZ") ? "https://comicvine.gamespot.com/a/uploads/scale_small/11/111746/5198856-buzz_lightyear_promational_art.jpg" : d.data.name.includes("WOODY") ? "https://pics.craiyon.com/2023-11-20/Yz_-k0bwTQeI3rGJoVle7Q.webp" : d.data.name.includes("REX") ? "https://img.lum.dolimg.com/v1/images/open-uri20150422-20810-1pw6dak_23081c6b.jpeg?region=0,0,450,450" : "" ) // Replace with your icon URL .attr("x", -10) // Position the image to the left of the text .attr("y", -15) // Adjust the vertical positioning .attr("width", 50) // Set the image width .attr("height", 50) .attr("clip-path", (d) => `url(#clip-${d.id})`); nodeEnter .filter((d) => d.data.name.includes("start")) // Check if the name is "start" .append("image") .attr( "xlink:href", "https://d12qcqjlhp2ahm.cloudfront.net/start_flag4.png" ) // URL of the icon .attr("x", -10) // Position the image relative to the text .attr("y", -24) // Vertical positioning .attr("width", 20) // Width of the icon .attr("height", 20); // Height of the icon nodeEnter .filter((d) => d.data.name.includes("end")) // Check if the name is "end" .append("image") .attr( "xlink:href", "https://d12qcqjlhp2ahm.cloudfront.net/start_flag5.png" ) // URL of the icon .attr("x", -10) // Position the image relative to the text .attr("y", -24) // Vertical positioning .attr("width", 20) // Width of the icon .attr("height", 20); // Height of the icon nodeEnter .append("text") .attr("dy", "0.19em") .attr("x", (d) => (d.depth === 1 ? -50 : d._children ? -6 : 6)) .attr("text-anchor", (d) => (d._children ? "end" : "start")) .text((d) => { // Filter children that do not have the name 'start' or 'end' const validChildren = d.children ? d.children.filter( (child) => !child.data.name.toLowerCase().includes("start") && !child.data.name.toLowerCase().includes("end") ) : []; const childCount = validChildren.length; return d.depth === 2 ? `${d.data.name} (${childCount})` : d.data.name; }) .attr("stroke-linejoin", "round") .attr("stroke-width", 1) .attr("stroke", (d) => { return d.data.name.toLowerCase().includes("start") ? "gray" : d.data.name.toLowerCase().endsWith("end") ? "gray" : "white"; }) //.attr("stroke", "white") .attr("paint-order", "stroke") .style("fill", (d) => { return d.data.name.toLowerCase().includes("start") ? "white" : d.data.name.toLowerCase().endsWith("end") ? "white" : d.data.new ? "black" : "black"; }) //.style("fill", (d) => (d.data.new ? "green" : "black")) // Green text if new, black otherwise .style("font-size", (d) => (d.data.new ? "22px" : "20px")) // Larger font size if new .style("font-weight", (d) => (d.data.new ? "bold" : "weight")); // Transition nodes to their new position. const nodeUpdate = node .merge(nodeEnter) .transition(transition) .attr("transform", (d) => { if (d.depth === 2) { d.y = d.depth * dy * 0.75; // Adjust spacing for depth 2 } else if (d.depth === 3) { d.y = d.depth * dy * 0.75; } else { d.y = d.depth * dy; } return `translate(${d.y},${d.x})`; }) .attr("fill-opacity", 1) .attr("stroke-opacity", 1); // Transition exiting nodes to the parent's new position. const nodeExit = node .exit() .transition(transition) .remove() .attr("transform", (d) => { if (d.depth === 2) { d.y = d.depth * dy * 0.75; // Adjust spacing for depth 2 } else if (d.depth === 3) { d.y = d.depth * dy * 0.75; } else { d.y = d.depth * dy; } return `translate(${d.y},${d.x})`; }) .attr("fill-opacity", 0) .attr("stroke-opacity", 0); // Update the links… const link = gLink.selectAll("path").data(root.links(), (d) => d.target.id); // Enter any new links at the parent's previous position. const linkEnter = link .enter() .append("path") .attr("stroke", (d) => d.source.children && d.depth === 3 && d.source.children.length >= parseInt(panel1.maxPerSlot) ? "red" : "#a876cc" ) .attr("d", (d) => diagonal({ source: d.source, target: d.target })); // Transition links to their new position. link .merge(linkEnter) .transition() .duration(550) .attr("stroke-width", 4) .attr("stroke", (d) => { const validChildren = d.source.children ? d.source.children.filter( (child) => !child.data.name.toLowerCase().includes("start") && !child.data.name.toLowerCase().includes("end") ) : d.source.children; return validChildren && d.depth != 2 && validChildren.length >= parseInt(panel1.maxPerSlot) ? "#a876cc" : "#a876cc"; }) .attr("d", (d) => diagonal({ source: d.source, target: d.target })); // Transition exiting nodes to the parent's new position. link .exit() .transition() .duration(550) .remove() .attr("d", (d) => { const o = { x: d.source.x, y: d.source.y }; return diagonal({ source: o, target: o }); }); // Stash the old positions for transition. root.eachBefore((d) => { d.x0 = d.x; d.y0 = d.y; }); } // Do the first update to the initial configuration of the tree — where a number of nodes // are open (arbitrarily selected as the root, plus nodes with 7 letters). root.x0 = dy / 2; root.y0 = 0; root.descendants().forEach((d, i) => { d.id = i; d._children = d.children; if (d.depth && d.data.name === "X") d.children = null; }); //addAppointmentBtn.addEventListener("click", () => { //console.log("calling add"); //root = d3.hierarchy(mutable baseSchedule); //const slots = findOpenSlots(root, parseInt(panel1.maxPerSlot)); //mutable theSlotsTable = slots; //dy = (width - marginRight - marginLeft) / (1 + root.height); //update(null, root); //}); resetBtn.addEventListener("click", () => { const options = { month: "long", day: "numeric" }; const timeWindows = generateTimeWindows( panel1.serviceWindowDivisions.value, panel1.shiftStart.toISOString().split("T")[0] ); mutable baseSchedule = { name: panel1.shiftStart.toLocaleDateString("en-US", options), children: [] }; baseRoutes.result.routes.forEach((r) => { let v = { name: `${r.vehicle}`, children: JSON.parse(JSON.stringify(timeWindows)) }; r.steps.forEach((s) => { let j = { name: s.metadata ? `${formatTimestampToHHMM(s.arrival)} ${ s.metadata.name.split(" ")[1] } ${s.metadata.address.split(",")[0]}` : `${formatTimestampToHHMM(s.arrival)} ${s.type}`, location: `${s.location[0]},${s.location[1]}`, arrival: s.arrival + s.waiting_time }; let slot = v.children.find( (timeSlot) => s.arrival >= timeSlot.start && s.arrival <= timeSlot.end ); if (slot) { slot.children.push(j); } }); mutable baseSchedule.children.push(v); }); root = d3.hierarchy(mutable baseSchedule); dy = (width - marginRight - marginLeft) / (1 + root.height); update(null, root); }); update(null, root); //mutable baseSchedule = recalculateSchedule(); const slots = findOpenSlots(root, parseInt(panel1.maxPerSlot)); mutable theSlotsTable = slots; mutable optStatus = html`

No pending changes

`; return svg.node(); }33:T501,inputs = { const offset = new Date().getTimezoneOffset(); let newBase = new Date("2024-08-15T08:00:00-04:00"); let tmrwStart = new Date( `${newBase.toLocaleDateString("en-US")} 08:00:00 EDT` ); let tmrwEnd = new Date(`${newBase.toLocaleDateString("en-US")} 10:00:00 GMT`); console.log(tmrwEnd); const inputs = { shiftStart: Inputs.date({ label: "Schedule Date", value: tmrwStart.toISOString() }), maxPerSlot: Inputs.text({ readonly: false, label: "Max Appts Per Slot", value: "4", width: 80 }), startLocation: Inputs.text({ readonly: false, label: "Technician Start/End Location", value: "36.14863,-86.7795" }), serviceDuration: Inputs.text({ readonly: false, label: "Service Duration(min)", value: "60", width: 80 }), serviceWindowDivisions: Inputs.select( [ { name: "6", value: 6 }, { name: "4", value: 4 }, { name: "3", value: 3 }, { name: "2", value: 2 } ], { label: "Number of Time Divisions in a Day", width: 80, sort: "descending", format: (x) => x.name } ), roundTrip: Inputs.toggle({ label: "Roundtrip", value: true }) }; return inputs; }34:T430,function insertChildAtPath(baseSchedule, path, newChildData) { // Split the path into an array of node names const pathArray = path.split(" > "); const srchArray = [pathArray[1], pathArray[2]]; // Initialize the current node as the root of the hierarchy let currentNode = baseSchedule; // Traverse the hierarchy according to the path for (const nodeName of srchArray) { // Find the child node with the matching name const childNode = currentNode.children?.find( (child) => child.name === nodeName ); if (!childNode) { console.error(`Node with name '${nodeName}' not found in path`); return false; // Path does not exist } // Move to the child node currentNode = childNode; } // Now `currentNode` is the parent where we want to add the new child if (!currentNode.children) { currentNode.children = []; // Initialize children array if it doesn't exist } // Insert the new child node into the parent's children array currentNode.children.push(newChildData); return true; // Indicate success }35:T574,// Traverse the hierarchy using a breadth-first approach function findOpenSlots(node, maxPerSlot) { let openSlots = []; node.each((d) => { if (d.depth === 2 && d.children) { const validChildren = d.children.filter( (child) => !child.data.name.toLowerCase().includes("start") && !child.data.name.toLowerCase().includes("end") ); // Check if this node has fewer than 4 children if (validChildren.length < parseInt(panel1.maxPerSlot)) { // Now check whether it is feasible to insert the job based // on location of existing jobs, travel time, service time and the time slot start and end openSlots.push({ slot: d.data.name, openSpots: maxPerSlot - validChildren.length, path: d .ancestors() .map((ancestor) => ancestor.data.name) .reverse() .join(" > ") }); } } else if (d.depth === 2 && !d.children) { // If the slot has no children, it has 'maxPerSlot' open spots and // we'll assume that the slot is feasible for adding one job openSlots.push({ slot: d.data.name, openSpots: parseInt(panel1.maxPerSlot), path: d .ancestors() .map((ancestor) => ancestor.data.name) .reverse() .join(" > ") }); } }); return openSlots; }36:T481,function recalculateSchedule() { const options = { month: "long", day: "numeric" }; const timeWindows = generateTimeWindows( panel1.serviceWindowDivisions.value, panel1.shiftStart.toISOString().split("T")[0] ); mutable baseSchedule = { name: panel1.shiftStart.toISOString().split("T")[0], children: [] }; baseRoutes.result.routes.forEach((r) => { let v = { name: `${r.vehicle}`, children: JSON.parse(JSON.stringify(timeWindows)) }; r.steps.forEach((s) => { let j = { name: s.metadata ? `${formatTimestampToHHMM(s.arrival)} ${ s.metadata.name.split(" ")[1] } ${s.metadata.address.split(",")[0]}` : `${formatTimestampToHHMM(s.arrival)} ${s.type}`, location: `${s.location[0]},${s.location[1]}`, arrival: s.arrival, new: false }; let slot = v.children.find( (timeSlot) => s.arrival >= timeSlot.start && s.arrival <= timeSlot.end ); if (slot) { slot.children.push(j); } }); mutable baseSchedule.children.push(v); }); return d3.hierarchy(mutable baseSchedule); }37:T581,showGeofences = function (nbmap) { let firstSymbolId; let geofencesjson = { type: "FeatureCollection", features: [] }; const layers = nbmap.map.getStyle().layers; for (const layer of layers) { firstSymbolId = layer.id; } geofenceData.data.list.forEach((fence) => { let feature = { type: "Feature", properties: { name: fence.name.toUpperCase() }, geometry: fence.geojson }; geofencesjson.features.push(feature); }); if (!nbmap.map.getSource("geofences")) { nbmap.map.addSource("geofences", { type: "geojson", data: null }); } console.log(geofencesjson); nbmap.map.getSource("geofences").setData(geofencesjson); if (nbmap.map.getLayer("geofences")) { nbmap.map.removeLayer("geofences"); } nbmap.map.addLayer({ id: "geofences", type: "fill", source: "geofences", paint: { "fill-color": "#CC3366", "fill-opacity": 0.2 } }); nbmap.map.addLayer( { id: "geofence-label", type: "symbol", // Use "symbol" for labeling source: "geofences", layout: { "text-field": ["get", "name"], "text-size": 12, "text-offset": [0, 1], "text-anchor": "center" }, paint: { "text-halo-width": 5, "text-color": "#000", // Label text color "text-halo-color": "#FFF" } }, firstSymbolId ); }38:T661,async function mvrp( data, options = { objective: { minimise_num_depots: false, travel_cost: "distance" } } ) { let url = ""; url = `https://api.nextbillion.io/optimization/v2`; const optimizeRequest = await axios .post(`${url}` + `?key=${apiKey}`, { ...data, options }) .then((res) => res.data); const mvrpRequestId = optimizeRequest.id; let attempts = 0; while (attempts < 50) { const result = await axios({ url: `${url}/result?id=${mvrpRequestId}&key=${apiKey}`, method: "GET", headers: {} }); if ( result.data && result.data.status === "Ok" && result.data.message == "" ) { result.data.id = mvrpRequestId; // KPIs let deliveryCount = 0; result.data.result.routes.forEach((rte, rteidx) => { rte.steps.forEach((step, index) => { if (step.id && step.id != 99) { ++deliveryCount; } }); }); result.data.kpis = { totalDistance: `${(result.data.result.summary.distance / 1000).toFixed( 1 )} km`, totalTime: `${(result.data.result.summary.duration / 60).toFixed( 1 )} mn`, nbrRoutes: result.data.result.summary.routes, avgStops: (deliveryCount / result.data.result.summary.routes).toFixed( 1 ), unassigned: result.data.result.summary.unassigned, frontSeatWeight: result.data.description.split("|")[1] }; return result.data; } attempts++; await new Promise((resolve) => setTimeout(resolve, 2 * 1000)); } }39:T4e2,async function nbaiDiscoverGeocode(config) { let countryList = [ "GBR", "AND", "USA", "DEU", "CAN", "MEX", "IND", "FRA", "SGP", "GBR", "ZAF", "SWE", "FIN", "NOR", "DNK", "ESP", "POR", "BEL", "CHE", "ARE", "SAU", "BRA", "ARG", "AUS", "AUT", "EST", "IDN", "IRL", "ISR", "ITA", "JPN" ]; const response = await fetch( `https://api.nextbillion.io/h/discover?q=${ config.query }&limit=5&in=countryCode:${countryList.toString()}&lang=en&at=36.195,-86.8&key=${apiKey}` ); let data = await response.json(); let collection = { type: "FeatureCollection", features: [] }; data.items.forEach((itm) => { let ft = { type: "Feature", geometry: { type: "Point", coordinates: [itm.position.lng, itm.position.lat] }, properties: { address: itm.address.label, full_result: itm }, place_name: itm.address.label, result_type: itm.resultType, place_type: itm.categories ? itm.categories[0].name : "N/A", center: [itm.position.lng, itm.position.lat] }; collection.features.push(ft); }); return collection; }3a:[{"id":"7e37097698d3a54328224f6368e192c3a5bf86eb90313dea2390fde503dd4daff2a16f47b8159c37fda9dacf206044907612394bdb9e61c5cdb8ed1142e07e93","href":"https://static.observableusercontent.com/files/7e37097698d3a54328224f6368e192c3a5bf86eb90313dea2390fde503dd4daff2a16f47b8159c37fda9dacf206044907612394bdb9e61c5cdb8ed1142e07e93","name":"bops_output1.json","type":"application/json","lastModified":1735317847226.286,"size":1248818},{"id":"83557342d8502501a51a84c310ca6f272b1a9deda166883920f519dc5897f68ec72e59d6117df7600986b769ef087d2515f0c6a6da2cc856f880a8386e33a2f2","href":"https://static.observableusercontent.com/files/83557342d8502501a51a84c310ca6f272b1a9deda166883920f519dc5897f68ec72e59d6117df7600986b769ef087d2515f0c6a6da2cc856f880a8386e33a2f2","name":"gc_test-6@4.json","type":"application/json","lastModified":1726243396942.64,"size":39242},{"id":"a5d76031a29597b1ddafad9c374194515f65ca1f1850c4d2ca856b544e3d1d9bbb0cefdb8f21449349293b7ec3e10fef367700d60f46800a1479990fd2e83f7f","href":"https://static.observableusercontent.com/files/a5d76031a29597b1ddafad9c374194515f65ca1f1850c4d2ca856b544e3d1d9bbb0cefdb8f21449349293b7ec3e10fef367700d60f46800a1479990fd2e83f7f","name":"untitled.json","type":"application/json","lastModified":1726243396942.64,"size":1670}] 2f:{"id":"ecaae220b57c8013","slug":null,"title":"Scheduling Optimization","thumbnail":"57f8b21d74e9e22dbbab4b104de81790d75897fcdd9e32e65e3b0f75b22a480e","access_level":"public","create_time":"$D2024-09-13T16:03:16.942Z","update_time":"$D2025-02-13T14:50:04.337Z","view_time":null,"first_public_time":"$D2024-09-13T16:04:58.656Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024"},"version":1578,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"53e0d2bd94fa8912","login":"dhivya-s","name":"Dhivya Selvarajan","avatar_url":"https://avatars-next.observableusercontent.com/c2ddc5b79da0e63c190a3f3ac91670f23f26b4bc0b1be30699fe67082ccb4f0b","tier":null}],"members":[{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Scheduling Optimization","cells":[{"id":0,"value":"# Scheduling Optimization","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":30,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1286,"value":"### Settings","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":475,"value":"viewof panel1 = Inputs.form(inputs, {\n template: (v) => htl.html`\n

\n \n ${v.startLocation}\n ${v.roundTrip}\n ${v.shiftEnd}\n ${v.maxPerSlot}\n ${v.serviceWindowDivisions}\n ${v.serviceDuration}\n

\n \n`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"### Supported Service Areas","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":62,"value":"originSearch = {\n const container3 = html`

`;\n yield container3;\n\n var geocoder = new nbaiGeocodePlugin({\n externalGeocoder: externalGeocoder,\n limit: 5,\n placeholder: \"Set Origin\",\n nbaiKey: apiKey,\n render: function (item) {\n const result_type = item.result_type;\n let place_type = \"\";\n let maki = \"location-dot\";\n return ``;\n }\n });\n geocoder.setMinLength(2);\n geocoder.addTo(container3);\n\n geocoder.on(\"result\", function (e) {\n mutable originSearchResult = [];\n mutable originSearchResult.push(e.result);\n });\n\n geocoder.on(\"clear\", function (e) {\n mutable originSearchResult = [];\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":569,"value":"### Scheduling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":72,"value":"selectedText = {\n originSearch;\n originSearchResult;\n if (mutable originSearchResult.length) {\n return md`Selected address: ${mutable originSearchResult[0].place_name}`;\n } else {\n return md`Search for an address..`;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":782,"value":"actionButtons = {\n const buttonReset = html` `;\n const buttonCheck = html``;\n\n return html`${buttonReset}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1312,"value":"#### Click on a technician (Buzz, Woody, or Rex) to minimize or expand their schedules\n#### Right click on the time slot to add the new appointment to the time slot (this won't be possible if the slot is full)\n#### Right click on the technician to optimize and determine whether the appointment insertion is feasible.\n#### Right click on a pending appointment (green background) to remove from the slot","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":895,"value":"mutable optStatus = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":470,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":394,"value":"mutable theSlotsTable = []","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":698,"value":"function findParentByPath(baseSchedule, path) {\n const pathParts = path.split(\" > \");\n const srchArray = [pathParts[1], pathParts[2]];\n // Start traversing from the root\n let currentNode = baseSchedule;\n console.log(currentNode);\n let parentNode = null;\n console.log(srchArray);\n // Traverse the path, skipping the last part which is the target node itself\n for (let i = 0; i < srchArray.length - 1; i++) {\n console.log(currentNode.children);\n if (currentNode.children) {\n parentNode = currentNode;\n currentNode = currentNode.children.find(\n (child) => child.name === srchArray[i]\n );\n } else {\n // If we reach a node that doesn't have the expected children, the path is invalid\n return null;\n }\n }\n\n return parentNode;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"mutable originSearchResult = FileAttachment(\"untitled.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":753,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1369,"value":"function findParentNode(root, targetNode) {\n let parentNode = null;\n\n // Traverse the hierarchy tree\n root.each((node) => {\n if (node.children) {\n // Check if any of the node's children match the target node\n node.children.forEach((child) => {\n if (child === targetNode) {\n parentNode = node;\n }\n });\n }\n });\n\n return parentNode;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"function findNodeByPath(root, path) {\n const pathArray = path.split(\" > \");\n let currentNode = root;\n const srchArray = [pathArray[1], pathArray[2]];\n for (const name of srchArray) {\n const foundChild = currentNode.children.find(\n (child) => child.data.name === name\n );\n if (!foundChild) {\n console.error(`Node with name '${name}' not found in path`);\n return null;\n }\n currentNode = foundChild;\n }\n\n return currentNode.children || [];\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":990,"value":"function findNodeByName(root, nodeName) {\n // Check if the current node is the one we're looking for\n if (root.name === nodeName) {\n return root;\n }\n\n // If the current node has children, search recursively\n if (root.children) {\n for (const child of root.children) {\n const result = findNodeByName(child, nodeName);\n if (result) {\n return result; // Return the found node\n }\n }\n }\n\n // Return null if the node wasn't found\n return null;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1345,"value":"function saveHierarchyToBaseSchedule(hierarchy) {\n console.log(hierarchy);\n function traverse(node) {\n // Copy the data of the current node\n const nodeData = { ...node.data };\n\n // If the node has children, recursively traverse them\n if (node.children) {\n nodeData.children = node.children.map(traverse);\n }\n\n return nodeData;\n }\n\n // Start traversal from the root of the hierarchy\n const updatedBaseSchedule = traverse(hierarchy);\n\n // Save the reconstructed tree back to mutable baseSchedule\n console.log(updatedBaseSchedule);\n mutable baseSchedule = updatedBaseSchedule;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1168,"value":"function moveNode(sourceNode, targetNode) {\n // Remove sourceNode from its current parent\n const parentIndex = sourceNode.parent.children.indexOf(sourceNode);\n sourceNode.parent.children.splice(parentIndex, 1);\n\n // If the sourceNode's parent has no more children, set its children to null\n if (sourceNode.parent.children.length === 0) {\n sourceNode.parent.children = null;\n }\n\n // Add sourceNode to the targetNode's children\n if (!targetNode.children) {\n targetNode.children = [];\n }\n targetNode.children.push(sourceNode);\n\n // Update the sourceNode's parent to be the targetNode\n sourceNode.parent = targetNode;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"geofenceData = {\n let more = true;\n let geofenceCollection = {\n status: \"\",\n data: {\n list: []\n }\n };\n let pn = 1;\n while (more) {\n let retval = null;\n retval = await fetch(\n `https://${serviceHost}/geofence/list?key=${apiKey}&ps=100&pn=${pn}`,\n {\n headers: {\n \"content-type\": \"application/json\"\n }\n }\n ).then((response) => response.json());\n more = retval.data.page.hasmore;\n pn++;\n retval.data.list.forEach((evt) => {\n //if (evt.geojson) {\n // evt.geojson.properties = {\n // name: evt.name\n // };\n //}\n\n if (!evt.meta_data.test) {\n console.log(evt);\n geofenceCollection.data.list.push(evt);\n }\n });\n }\n geofenceCollection.data.list = geofenceCollection.data.list.filter(\n (item) => item.event_type != \"idle\"\n );\n return geofenceCollection;\n}\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"baseRoutes = FileAttachment(\"gc_test-6@4.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":551,"value":"function isFullNode(d) {\n // Filter out children whose name contains 'start' or 'end'\n const validChildren = d.children\n ? d.children.filter(\n (child) =>\n !child.data.name.toLowerCase().includes(\"start\") &&\n !child.data.name.toLowerCase().includes(\"end\")\n )\n : [];\n\n // Return true if the node has exactly 4 valid children\n console.log(validChildren.length);\n return validChildren.length >= parseInt(panel1.maxPerSlot);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"function collapseNodesByCriteria(node, criteria) {\n if (criteria(node)) {\n // Collapse the node by setting its children to null\n node.children = null;\n } else if (node.children) {\n // Recursively check and collapse children\n node.children.forEach((child) => collapseNodesByCriteria(child, criteria));\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":627,"value":"function generateTimeWindows(numSlots, planningDay) {\n const options = { month: \"long\", day: \"numeric\" };\n const startHour = 8; // Workday starts at 08:00 EDT\n const endHour = 20; // Workday ends at 18:00 EDT\n const slotDuration = ((endHour - startHour) * 3600) / numSlots; // Duration of each slot in seconds\n\n const timeWindows = [];\n\n for (let i = 0; i < numSlots; i++) {\n const startTime =\n new Date(\n `${planningDay}T${String(\n startHour + (i * (endHour - startHour)) / numSlots\n ).padStart(2, \"0\")}:00:00-04:00`\n ).getTime() / 1000;\n const endTime = startTime + slotDuration - 1;\n\n const slotName = `${String(\n startHour + (i * (endHour - startHour)) / numSlots\n ).padStart(2, \"0\")}-${String(\n startHour + ((i + 1) * (endHour - startHour)) / numSlots\n ).padStart(2, \"0\")}`;\n\n timeWindows.push({\n name: slotName,\n start: startTime,\n end: endTime,\n max: 6,\n children: []\n });\n }\n\n return timeWindows;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"$36","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"mutable baseSchedule = null","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"import { nextbillion, secret2 } from \"@nbai/nextbillion-ai-dependencies\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"$37","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"serviceHost = \"api.nextbillion.io\"\n//serviceHost = \"stg-gcp-sgp.nextbillion.io\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"apiKey = \"73d4bee8352b46e483d75fb924889ada\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"{\n nextbillion.setApiKey(apiKey);\n return html`Set API key
nextbillion.setApiKey(${apiKey.substr(\n 0,\n 4\n )}....)`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"axios = {\n let axios = await require(\"axios\");\n return axios;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"turf = {\n let turf = await require(\"https://unpkg.com/@turf/turf@6/turf.min.js\");\n return turf;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":967,"value":"$38","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"// Function to determine if a point is inside any geofence\nfunction isPointInAnyGeofence(pointCoordinates, geofenceData) {\n const pt = turf.point(pointCoordinates);\n\n for (const geofence of geofenceData.data.list) {\n if (geofence.type === \"polygon\" && geofence.geojson.type === \"Polygon\") {\n const poly = turf.polygon(geofence.geojson.coordinates);\n\n if (turf.booleanPointInPolygon(pt, poly)) {\n return geofence;\n }\n }\n }\n return false;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"nbaiGeocodePlugin = require(\"https://d12qcqjlhp2ahm.cloudfront.net/mbac_test.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"async function externalGeocoder(input, _features, config) {\n const { features } = await nbaiDiscoverGeocode({\n query: input,\n proximity: config.proximity,\n nbaiKey: config.nbaiKey\n });\n return features;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"$39","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"function formatTimestampToHHMM(timestamp) {\n const date = new Date(timestamp * 1000); // Multiply by 1000 to convert to milliseconds\n\n // Format the date to always use Eastern Time (EDT) and extract the hours and minutes\n const options = {\n timeZone: \"America/New_York\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false // Use 24-hour format\n };\n\n const formattedTime = date.toLocaleString(\"en-US\", options);\n return formattedTime;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":18,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":65,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":101,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W3a","stdlib":"1","titling":"auto"}} 30:"$2f:body"