Task Comments

interface TaskComment {
  id: number;           // Unique identifier
  created_at: DateTime; // Timestamp
  task_id: number;      // Reference to parent task
  comment: string;      // Comment text
}

model task_comments {
  id         Int      @id @default(autoincrement())
  created_at DateTime @default(now())
  task       Tasks    @relation(fields: [task_id], references: [id], onDelete: Cascade)
  task_id    Int
  comment    String

  @@map("task_comments")
}

model Tasks {
  // ... other fields
  task_comments          task_comments[]
  amount_of_comments     Int             @default(0)
}

POST /api/addCommentToTask

Request Body:
{
  "task_id": 123,
  "comment": "Photos edited and sent to client for review"
}

Response:
"Successful!"

export const POST: RequestHandler = async ({ request }) => {
  try {
    const { task_id, comment } = await request.json();
    
    // Create the comment
    await prisma.task_comments.create({
      data: {
        task_id: task_id,
        comment: comment,
        created_at: new Date()
      }
    });
    
    // Increment the comment counter
    await prisma.tasks.update({
      where: { id: task_id },
      data: {
        amount_of_comments: { increment: 1 }
      }
    });
    
    return json('Successful!');
  } catch {
    return json('Invalid!');
  }
};

POST /api/updateCommentFromTask

Request Body:
{
  "comment_id": 45,
  "comment": "Updated: Photos sent to client and approved"
}

Response:
"Successful!"

POST /api/deleteCommentFromTask

Request Body:
{
  "comment_id": 45,
  "task_id": 123
}

Response:
"Successful!"

amount_of_comments: number;  // Displayed on task cards

✓ "Client approved proofs, starting final edits"
✓ "Issue: Missing shot of bride with parents. Requested reshoot."
✓ "Delivered 150 edited photos via cloud link"

✗ "done"
✗ "working on it"
✗ "???"

created_at: new Date()  // Set automatically

"@John - Can you verify the client's delivery address?"

task_comments {
  task       Tasks    @relation(fields: [task_id], references: [id], onDelete: Cascade)
  task_id    Int
}

const commentsWithTask = await prisma.task_comments.findMany({
  where: { task_id: 123 },
  orderBy: { created_at: 'asc' },
  include: {
    task: true  // Include parent task details
  }
});

const commentCount = await prisma.task_comments.count({
  where: { task_id: 123 }
});