Hey there @boomshakalaka
Since the previous posts on this subject, I made this into a CustomJS user script. I find it more convenient. I call the script from within my daily note template like so:
let today = "{{date:YYYY-MM-DD}}";
let tomorrow = "{{date+1:YYYY-MM-DD}}";
let showDone = dv.current().showDone;
function checkAndExecuteGantt() {
const { dailyGantt } = customJS || {};
if (dailyGantt && dailyGantt.drawGantt) {
let parsedToday = new Date(today);
if (parsedToday.getDay() != 0) {
dailyGantt.drawGantt(dv, today, tomorrow, moment, showDone);
}
} else {
setTimeout(checkAndExecuteGantt, 500);
}
}
checkAndExecuteGantt();
and here is the script itself:
class dailyGantt{
isValidDate(d) {
return d instanceof Date && !isNaN(d);
}
createDateFromString(dateStr) {
if (!/^\d{4}-\d{2}-\d{2}$/.test(dateStr.trim())) {
console.error("Date string format is incorrect:", dateStr);
return null;
}
const [year, month, day] = dateStr.split('-').map(Number);
const date = new Date(year, month - 1, day); // month is zero-indexed, day is one-indexed
if (!this.isValidDate(date)) {
console.error ("function createDateFromString() — Failed to create a valid date from:", dateStr, "— returning null");
return null;
}
return date;
}
extractDate(emoji, taskText) {
const start = taskText.indexOf(emoji);
if (start < 0) {
return "";
}
const match = taskText.slice(start + 1).match(/([12]\d{3}-(0[1-9]|1[0-2])-(0[1-9]|[12]\d|3[01]))(\s|$)/);
return match ? match[0] : "";
}
textParser(taskText, noteCreationDate) {
const emojis = ["📅", "⏳", "🛫", "➕", "✅", "⏫", "🔼", "🔽"];
const DueText = this.extractDate("📅", taskText);
const scheduledText = this.extractDate("⏳", taskText);
const startText = this.extractDate("🛫", taskText);
let addText = this.extractDate("➕", taskText);
const doneText = this.extractDate("✅", taskText);
if (addText === "") {
addText = noteCreationDate;
}
let h = taskText.indexOf("⏫");
let m = taskText.indexOf("🔼");
let l = taskText.indexOf("🔽");
let PriorityText="";
if(h>=0){
PriorityText="High";
}
if(m>=0){
PriorityText="Medium";
}
if(l>=0){
PriorityText="Low";
}
const emojisIndex = emojis.map(emoji => taskText.indexOf(emoji)).filter(index => index >= 0);
let words;
if (emojisIndex.length > 0) {
words = taskText.slice(0, Math.min(...emojisIndex)).split(" ");
} else {
words = taskText.split(" ");
}
words = words.filter((word) => (word) !== "#task");
let newWords = words.map(
(word) => word.startsWith("#") ? `{${word.slice(1)}}` : word);
let nameText = newWords.join(" ");
return {
add: addText,
done: doneText,
due: DueText,
name: nameText,
priority: PriorityText,
scheduled: scheduledText,
start: startText
};
}
loopGantt (args){
const { pageArray, showDone, today, tomorrow, moment } = args;
let queryGlobal = "";
let i;
for (i = 0; i < pageArray.length; i+=1) {
let taskQuery = "";
if (!pageArray[i].file.tasks || pageArray[i].file.tasks.length === 0) {
continue;
}
let taskArray = pageArray[i].file.tasks;
let taskObjs = [];
let noteCreationDate = moment(pageArray[i].file.cday).format('YYYY-MM-DD');
let j;
for (j = 0; j < taskArray.length; j+=1){
taskObjs[j] = this.textParser(taskArray[j].text, noteCreationDate);
let theTask = taskObjs[j];
let monthLater = new Date(today);
monthLater.setDate(monthLater.getDate() + 30);
monthLater = monthLater.toISOString().slice(0, 10);
let monthBefore = new Date(today);
monthBefore.setDate(monthBefore.getDate() + 30);
monthBefore = monthBefore.toISOString().slice(0, 10);
monthLater = this.createDateFromString(monthLater);
if (!monthLater) {
console.error("Failed to create a valid date from monthLater:", monthLater);
}
if (theTask.name === "") continue;
if (!showDone && theTask.done) continue;
if (theTask.name.includes("⛔")) continue;
let taskName = theTask.name
.replace(/:/g, '') // Removes colons
.replace(/\(http[^\)]+\)/g, '') // Removes anything that starts with "(http" and ends with ")"
.replace(/\(file[^\)]+\)/g, '') // Removes anything that starts with "(http" and ends with ")"
.replace(/\(obsidian[^\)]+\)/g, '') // Removes anything that starts with "(http" and ends with ")"
.replace(/\[\[[^\|]+\|/g, '') // Removes wiki link aliases "[[...|"
.replace(/\]\]/g, '') // Removes "]]"
.replace(/\[|\]/g, '') // Removes "[" and "]"
.replace(/\(file[^\)]+\)/g, ''); // Removes anything that starts with "(file" and ends with ")"
let startDate = theTask.start || theTask.scheduled || theTask.add || noteCreationDate || today;
let newStartDate = this.createDateFromString(startDate);
if (!newStartDate) {
console.error("Failed to create a valid date from startDate: ", startDate);
} else {
startDate = newStartDate;
}
if (startDate > monthLater) continue;
if (startDate < monthBefore) continue;
let endDate = theTask.done || theTask.due || theTask.scheduled;
if (!endDate) {
if (startDate >= today) {
let weekLater = new Date(startDate);
weekLater.setDate(weekLater.getDate() + 7);
endDate = weekLater.toISOString().slice(0, 10);
endDate = this.createDateFromString(endDate);
if (!endDate) {
console.error("Failed to create a valid date from weekLater:", weekLater);
}
} else {
endDate = tomorrow;
endDate = this.createDateFromString(endDate);
if (!endDate) {
console.error("Failed to create a valid date from tomorrow:", tomorrow);
}
}
}
// Handling tasks with only a due date and no start date
if (!theTask.start && !theTask.scheduled && theTask.due) {
let weekBefore = new Date(theTask.due);
weekBefore.setDate(weekBefore.getDate() - 7);
startDate = weekBefore.toISOString().slice(0, 10);
newStartDate = this.createDateFromString(startDate);
if (!newStartDate) {
console.error("Failed to create a valid date from weekBefore:", weekBefore);
} else {
startDate = newStartDate;
}
}
if (endDate == startDate) {
let weekLater = new Date(startDate);
weekLater.setDate(weekLater.getDate() + 7);
endDate = weekLater.toISOString().slice(0, 10);
let newEndDate = this.createDateFromString(endDate);
if (!newEndDate) {
console.error("Failed to create a valid date from weekLater:", weekLater);
} else {
endDate = newEndDate;
}
}
// mise des tâches au format mermaid
if (theTask.due){
if (theTask.due < today){
taskQuery += taskName + ` :crit, ` + startDate + `, ` + endDate + `\n\n`;
} else {
taskQuery += taskName + ` :active, ` + startDate + `, ` + endDate + `\n\n`;
}
} else if (theTask.scheduled){
if (startDate >= today){
taskQuery += taskName + ` :active, ` + startDate + `, ` + endDate + `\n\n`;
} else {
taskQuery += taskName + ` :inactive, ` + startDate + `, ` + endDate + `\n\n`;
}
} else {
taskQuery += taskName + ` :active, ` + startDate + `, ` + endDate + `\n\n`;
}
}
queryGlobal += taskQuery;
}
return queryGlobal;
}
drawGantt(dv, today, tomorrow, moment, showDone) {
const Mermaid = `gantt
dateFormat YYYY-MM-DD
axisFormat %b\n %d
`;
// Get all dashboard pages with status "en cours" (ongoing)
let dashboardPages = dv.pages().where(p => (p.status == "en cours" || p.status == "permanent") && p.type == "dashboard");
// Extract tagNames from these dashboard pages
let tagNames = dashboardPages.map(page => page.tagName);
// Get all pages that contain tasks with the extracted tagNames and #task
let filteredPages = [];
for (let page of dv.pages()) {
let tasks = page.file.tasks.filter(t =>
t.status != "-" &&
t.text.includes("#task") &&
tagNames.some(tag => t.text.includes(tag)) &&
!t.text.includes("#someday") &&
!t.text.includes("#waitingFor") &&
!t.text.includes("Revue hebdomadaire")
);
if (tasks.length > 0) {
filteredPages.push({ ...page, file: { ...page.file, tasks: tasks } });
}
}
let ganttOutput = this.loopGantt({pageArray:filteredPages, showDone, today, tomorrow, moment});
// console.log(ganttOutput);
ganttOutput += "🧘🏻♂️ :active, " + today + ", " + today + "\n\n"; // (dummy task to display today's date)
dv.paragraph("```mermaid\n" +
Mermaid +
ganttOutput +
"\n```");
// this prints a meta-bind inline field allowing the user to toggle a boolean in the metadata and thus show/hide completed tasks:
//dv.paragraph(`Montrer les tâches terminées \`INPUT[toggle:showDone]\``);
}
}
edit: a few corrections brought to the script a few months later
another edit: update to fix date creation logic broken by some change somewhere else + hide blocked tasks
Let me know if you could adapt it to your use case.
parameter isn’t specified, the date of creation of the note containing the task is used instead, which is why I’m passing noteCreationDate to the textParser function along with pageArray. This creation date is fetched from the note’s metadata, all my notes having a “created” YAML field with a timestamp, so the method here may need some adaptation.
10d” will therefore be considered by the plugin as a task without a due date, and it won’t show in a query targetting tasks due 10 days from now. If you’re a task query user that might be a problem. But I guess it can be useful for specific tasks that you only need to see in the gantt chart.
