<?php
//error_reporting(E_ALL);
//ini_set('display_errors', 1);

function get_sheet_name_by_gid($service,$spreadsheetId,$gid,$fn){
    // Define the request body
    $requestBody = new Google_Service_Sheets_GetSpreadsheetByDataFilterRequest([
        'dataFilters' => [
            'gridRange' => [
                'sheetId' => $gid,
            ],
        ],
    ]);

    // Retrieve the values from the sheet
    $response = $service->spreadsheets->getByDataFilter($spreadsheetId, $requestBody);
    $sheetsData = $response->getSheets();

    if (empty($sheetsData)) {
        echo 'No data found.';
    } else {
        foreach ($sheetsData as $sheet) {
            $data = $sheet->getData();
            $sheet_title = $sheet->getProperties()->getTitle();
            get_data_by_sheet_name_and_save($sheet_title,$service,$spreadsheetId,$fn);
        }
    }
}

function get_data_by_sheet_name_and_save($sheet_title,$service,$spreadsheetId,$fn){

    $range = $sheet_title .'!A:E';
    $response = $service->spreadsheets_values->get($spreadsheetId, $range);
    $values = $response->getValues();

    $fileName = $fn;  // Specify the file name or path

    $fileHandle = fopen($fileName, 'w');  // Open the file in write mode

    foreach ($values as $row) {
        fputcsv($fileHandle, $row);  // Write each row to the CSV file
    }

    fclose($fileHandle);  // Close the file

    $fileContents = file_get_contents($fileName);
    $pattern = '/"(\d+:\d+ - \d+:\d+)"/';
    $fileContents = preg_replace($pattern, '$1', $fileContents);
    file_put_contents($fileName, $fileContents);

}


//return $service;
// $spreadsheetId = '1-YDHd-5o0fbHFBbmVgOz792m_V8j9s9FfSgR1AepdTc';
// $range = '課程總覽!A:G';

// $response = $service->spreadsheets_values->get($spreadsheetId, $range);
// $values = $response->getValues();
// print_r($values);
// foreach ($values as $row) {
//     // 對讀取的每一行進行處理
//     print_r($row);
// }
// die("test");
?>