<?php
declare(strict_types=1);


namespace OneClickFormSync\Google\Sheets;

if (!defined('ABSPATH')) {
    exit;
}

/**
 * Handles worksheet name escaping and range string construction.
 */
class WorksheetManager
{
    /**
     * Escape worksheet name for use in Google Sheets A1 notation.
     *
     * @param string $name Name of the worksheet.
     * @return string Escaped worksheet name.
     */
    public function escapeWorksheetName(string $name): string
    {
        // Double any existing single quotes in the sheet name.
        $escaped = str_replace("'", "''", $name);

        // Wrap in single quotes if it contains spaces or special characters.
        if (preg_match('/[^a-zA-Z0-9]/', $escaped) || is_numeric(substr($escaped, 0, 1))) {
            return "'" . $escaped . "'";
        }

        return $escaped;
    }

    /**
     * Construct a formatted range string (e.g. 'Sheet Name'!A:ZZ).
     *
     * @param string $worksheetName
     * @param string $cellRange Defaults to 'A:ZZ' to reference entire sheet columns.
     * @return string Range string.
     */
    public function getRangeString(string $worksheetName, string $cellRange = 'A:ZZ'): string
    {
        return $this->escapeWorksheetName($worksheetName) . '!' . $cellRange;
    }
}