src/tools/docs/formatting/updateTableCellStyle.ts

import type { FastMCP } from 'fastmcp';
import { UserError } from 'fastmcp';
import { z } from 'zod';
import { getDocsClient } from '../../../clients.js';
import { getTableById } from '../structureHelpers.js';
import * as GDocsHelpers from '../../../googleDocsApiHelpers.js';
import { DocumentIdParameter, validateHexColor, hexToRgbColor } from '../../../types.js';

const HexColor = z
  .string()
  .refine(validateHexColor, { message: 'Invalid hex color format (e.g., #D9E2F3).' });

const Alignment = z.enum(['TOP', 'MIDDLE', 'BOTTOM']);

export function register(server: FastMCP) {
  server.addTool({
    name: 'updateTableCellStyle',
    description:
      'Applies cell-level formatting to a Google Docs table range, including background color, alignment, padding, and borders.',
    parameters: DocumentIdParameter.extend({
      tableId: z.string().min(1).describe('The MCP table ID returned by listDocumentTables.'),
      rowStart: z.number().int().min(0).describe('Zero-based starting row index.'),
      rowEnd: z.number().int().min(0).describe('Zero-based ending row index (inclusive).'),
      columnStart: z.number().int().min(0).describe('Zero-based starting column index.'),
      columnEnd: z.number().int().min(0).describe('Zero-based ending column index (inclusive).'),
      backgroundColor: HexColor.optional().describe('Cell background color, e.g. "#D9E2F3".'),
      contentAlignment: Alignment.optional().describe('Vertical content alignment inside cells.'),
      paddingTopPt: z.number().min(0).optional().describe('Top padding in points.'),
      paddingBottomPt: z.number().min(0).optional().describe('Bottom padding in points.'),
      paddingLeftPt: z.number().min(0).optional().describe('Left padding in points.'),
      paddingRightPt: z.number().min(0).optional().describe('Right padding in points.'),
      tabId: z.string().optional().describe('Optional target tab ID.'),
    })
      .refine((data) => data.rowEnd >= data.rowStart, {
        message: 'rowEnd must be greater than or equal to rowStart',
        path: ['rowEnd'],
      })
      .refine((data) => data.columnEnd >= data.columnStart, {
        message: 'columnEnd must be greater than or equal to columnStart',
        path: ['columnEnd'],
      }),
    execute: async (args, { log }) => {
      const docs = await getDocsClient();
      log.info(
        `Updating table cell style in ${args.tableId} for doc ${args.documentId}${args.tabId ? ` (tab: ${args.tabId})` : ''}`
      );

      try {
        const res = await docs.documents.get({
          documentId: args.documentId,
          includeTabsContent: true,
          fields:
            'body(content(startIndex,endIndex,table(tableRows(tableCells(startIndex,endIndex))))),tabs(tabProperties(tabId,title),documentTab(body(content(startIndex,endIndex,table(tableRows(tableCells(startIndex,endIndex)))))))',
        });

        const table = getTableById(res.data, args.tableId, args.tabId);
        if (!table) throw new UserError(`Table "${args.tableId}" not found in document.`);
        if (table.startIndex == null) {
          throw new UserError(`Table "${args.tableId}" does not expose a valid table start index.`);
        }
        if (args.rowEnd >= table.rowCount) {
          throw new UserError(`rowEnd ${args.rowEnd} exceeds table row count ${table.rowCount}.`);
        }
        if (args.columnEnd >= table.columnCount) {
          throw new UserError(
            `columnEnd ${args.columnEnd} exceeds table column count ${table.columnCount}.`
          );
        }

        const requestInfo = GDocsHelpers.buildTableCellStyleRequest(
          table.startIndex,
          args.rowStart,
          args.columnStart,
          {
            rowSpan: args.rowEnd - args.rowStart + 1,
            columnSpan: args.columnEnd - args.columnStart + 1,
            backgroundColor: args.backgroundColor
              ? (hexToRgbColor(args.backgroundColor) ?? undefined)
              : undefined,
            contentAlignment: args.contentAlignment,
            paddingTopPt: args.paddingTopPt,
            paddingBottomPt: args.paddingBottomPt,
            paddingLeftPt: args.paddingLeftPt,
            paddingRightPt: args.paddingRightPt,
          },
          args.tabId
        );

        if (!requestInfo) {
          throw new UserError('No table cell style options were provided.');
        }

        await GDocsHelpers.executeBatchUpdate(docs, args.documentId, [requestInfo.request]);
        return `Successfully updated table cell style (${requestInfo.fields.join(', ')}) for ${args.tableId}.`;
      } catch (error: any) {
        log.error(
          `Error updating table cell style for ${args.tableId} in doc ${args.documentId}: ${error.message || error}`
        );
        if (error instanceof UserError) throw error;
        throw new UserError(
          `Failed to update table cell style: ${error.message || 'Unknown error'}`
        );
      }
    },
  });
}