⚡ 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 { and, eq, sql } from "drizzle-orm";
import { HTTPException } from "hono/http-exception";
import db from "../../database";
import {
customFieldDefinitionTable,
customFieldValueTable,
taskTable,
} from "../../database/schema";
import {
findNewHiddenPicks,
isChoiceType,
readHiddenOptions,
readOptions,
} from "../choice-options";
function isMultiselectEmpty(value: string): boolean {
if (!value || value.trim().length === 0) return true;
try {
const parsed = JSON.parse(value);
return Array.isArray(parsed) && parsed.length === 0;
} catch {
return false;
}
}
async function setCustomFieldValue(
taskId: string,
fieldId: string,
value: string,
) {
const [task] = await db
.select({
projectId: taskTable.projectId,
})
.from(taskTable)
.where(eq(taskTable.id, taskId))
.limit(1);
if (!task) {
throw new HTTPException(404, {
message: "Task not found",
});
}
const [field] = await db
.select()
.from(customFieldDefinitionTable)
.where(eq(customFieldDefinitionTable.id, fieldId))
.limit(1);
if (!field || field.projectId !== task.projectId) {
throw new HTTPException(404, {
message: "Custom field not found",
});
}
const normalizedValue = value.trim();
if (field.required) {
if (field.type === "multiselect") {
if (isMultiselectEmpty(normalizedValue)) {
throw new HTTPException(400, {
message: "This custom field is required",
});
}
} else if (normalizedValue.length === 0) {
throw new HTTPException(400, {
message: "This custom field is required",
});
}
}
if (field.type === "dropdown" && normalizedValue.length > 0) {
if (
Array.isArray(field.options) &&
!field.options.includes(normalizedValue)
) {
throw new HTTPException(400, {
message: "Invalid option for this custom field",
});
}
}
if (field.type === "number" && normalizedValue.length > 0) {
if (Number.isNaN(Number(normalizedValue))) {
throw new HTTPException(400, {
message: "Value must be a valid number",
});
}
}
if (field.type === "boolean" && normalizedValue.length > 0) {
if (normalizedValue !== "true" && normalizedValue !== "false") {
throw new HTTPException(400, {
message: "Value must be true or false",
});
}
}
if (field.type === "multiselect" && normalizedValue.length > 0) {
let parsed: unknown;
try {
parsed = JSON.parse(normalizedValue);
} catch {
throw new HTTPException(400, {
message: "Value must be a valid JSON array",
});
}
if (!Array.isArray(parsed)) {
throw new HTTPException(400, {
message: "Value must be a JSON array",
});
}
if (Array.isArray(field.options)) {
const options = field.options as string[];
const invalid = parsed.some(
(v) => typeof v !== "string" || !options.includes(v),
);
if (invalid) {
throw new HTTPException(400, {
message: "Invalid option(s) for this custom field",
});
}
}
}
const hidden = readHiddenOptions(
field.hiddenOptions,
readOptions(field.options),
);
if (isChoiceType(field.type) && hidden.length > 0) {
const [current] = await db
.select({ value: customFieldValueTable.value })
.from(customFieldValueTable)
.where(
and(
eq(customFieldValueTable.taskId, taskId),
eq(customFieldValueTable.fieldId, fieldId),
),
)
.limit(1);
if (
findNewHiddenPicks(
normalizedValue,
current?.value ?? null,
field.type,
hidden,
).length > 0
) {
throw new HTTPException(400, {
message: "Hidden options can't be selected",
});
}
}
const [result] = await db
.insert(customFieldValueTable)
.values({
taskId,
fieldId,
value: normalizedValue,
})
.onConflictDoUpdate({
target: [customFieldValueTable.taskId, customFieldValueTable.fieldId],
set: {
value: sql`excluded.value`,
},
})
.returning();
return result;
}
export default setCustomFieldValue;