⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { createId } from "@paralleldrive/cuid2";
import { eq } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import { taskTable, timeEntryTable } from "../../database/schema";
import { publishEvent } from "../../events";
import { resolveDuration } from "../duration";
async function createTimeEntry({
taskId,
userId,
description,
startTime,
endTime,
}: {
taskId: string;
userId: string;
description?: string;
startTime: Date;
endTime?: Date;
}) {
const duration = resolveDuration(startTime, endTime);
const [createdTimeEntry] = await db
.insert(timeEntryTable)
.values({
id: createId(),
taskId,
userId,
description: description || "",
startTime,
endTime: endTime || null,
duration,
})
.returning();
if (!createdTimeEntry) {
throw new HTTPException(500, {
message: "Failed to create time entry",
});
}
const [task] = await db
.select({ userId: taskTable.userId, title: taskTable.title })
.from(taskTable)
.where(eq(taskTable.id, taskId));
await publishEvent("time-entry.created", {
timeEntryId: createdTimeEntry.id,
taskId: createdTimeEntry.taskId,
userId,
type: "create",
content: "started time tracking",
taskOwnerId: task?.userId,
taskTitle: task?.title,
});
return createdTimeEntry;
}
export default createTimeEntry;