/*
 * Copyright (C) Ascensio System SIA, 2009-2026
 *
 * This program is a free software product. You can redistribute it and/or
 * modify it under the terms of the GNU Affero General Public License (AGPL)
 * version 3 as published by the Free Software Foundation, together with the
 * additional terms provided in the LICENSE file.
 *
 * This program is distributed WITHOUT ANY WARRANTY; without even the implied
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. For
 * details, see the GNU AGPL at: https://www.gnu.org/licenses/agpl-3.0.html
 *
 * You can contact Ascensio System SIA by email at info@onlyoffice.com
 * or by postal mail at 20A-6 Ernesta Birznieka-Upisha Street, Riga,
 * LV-1050, Latvia, European Union.
 *
 * The interactive user interfaces in modified versions of the Program
 * are required to display Appropriate Legal Notices in accordance with
 * Section 5 of the GNU AGPL version 3.
 *
 * No trademark rights are granted under this License.
 *
 * All non-code elements of the Product, including illustrations,
 * icon sets, and technical writing content, are licensed under the
 * Creative Commons Attribution-ShareAlike 4.0 International License:
 * https://creativecommons.org/licenses/by-sa/4.0/legalcode
 *
 * This license applies only to such non-code elements and does not
 * modify or replace the licensing terms applicable to the Program's
 * source code, which remains licensed under the GNU Affero General
 * Public License v3.
 *
 * SPDX-License-Identifier: AGPL-3.0-only
 */
#ifndef WORKBOOK_H
#define WORKBOOK_H

#include "Biff12RecordBase.h"
#include <vector>
namespace XLSB {

    class DefinedNameRecord : public CBiff12RecordBase
    {

        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
            if (reclen >= 17)
            {
                WORD grbits    = CBinaryBiff12StreamReader::GetWord(p + 0);
                DWORD nametype = CBinaryBiff12StreamReader::GetDword(p + 5);
                DWORD lenName  = CBinaryBiff12StreamReader::GetDword(p + 9);

                std::wstring wszName = CBinaryBiff12StreamReader::GetString(p + 13, lenName);

                DWORD lenFormula = CBinaryBiff12StreamReader::GetDword(p + 13 + 2 * lenName);
                // formula ptg tokens follow between
                //  p + 13 + 2 * lenName + 4
                //   and
                //  p + 13 + 2 * lenName + 4 + lenFormula

                bool bHidden  = (grbits & 0x0001) != 0;
                bool bFunc    = (grbits & 0x0002) != 0;
                bool bBuiltin = (grbits & 0x0020) != 0;

                WCHAR wszNameType[64];
                switch (nametype)
                {
                    case 0 : wcscpy(wszNameType, L"Print_Area"); break; // or Print_Titles in fact
                    case 1 : wcscpy(wszNameType, L"Database"); break;
                    //TODO (Consolidate_Area,Auto_Open,Auto_Close,Extract,Criteria,Recorder
                    //      Data_Form,Auto_Activate,Auto_Deactivate,Sheet_Title,FilterDatabase)
                    default : wcscpy(wszNameType, L"Normal"); break;
                }


                WCHAR s[256];
                swprintf(s, sizeof(s), L"\tinfo : hidden=%s, addinfunc=%s, builtin=%s, type=%s, name=%s, lenName=%d, lenFormula=%d\r\n",
                    bHidden ? L"true" : L"false",
                    bFunc ? L"true" : L"false",
                    bBuiltin ? L"true" : L"false",
                    wszNameType,
                    wszName.c_str(),
                    lenName,
                    lenFormula);
                std::cout<<(s);
            }
            else
            {
                std::cout<<("\tinfo : invalid defined name record length\r\n");
            }

        }

        std::string GetTag()
        {
            return "definedName";
        }
    };

    class FileVersionRecord : public CBiff12RecordBase
    {

        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "fileVersion";
        }
    };

    class WorkbookRecord : public CBiff12RecordBase
    {
    public:
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "workbook";
        }

    };

    class WorkbookEndRecord : public CBiff12RecordBase
    {
    public:
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "/workbook";
        }

    };

    class BookViewsRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "bookViews";
        }

    };

    class BookViewsEndRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "/bookViews";
        }

    };

    class SheetsRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "sheets";
        }

    };

    class SheetsEndRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "/sheets";
        }

    };

    class WorkbookPRRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "workbookPr";
        }

    };

    class SheetRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
            DWORD sheet_id = CBinaryBiff12StreamReader::GetDword(p + 8);

            DWORD sheet_opc_ref_len = CBinaryBiff12StreamReader::GetDword(p + 12);

            std::wstring sheet_opc_ref = CBinaryBiff12StreamReader::GetString(p + 16, sheet_opc_ref_len);

            DWORD sheet_name_len = CBinaryBiff12StreamReader::GetDword( p + 16 + 2 * sheet_opc_ref_len);

            std::wstring sheet_name = CBinaryBiff12StreamReader::GetString(p + 16 + 2 * sheet_opc_ref_len + 4, sheet_name_len);

            WCHAR s[300];
           swprintf(s, sizeof(s), L"\tinfo : id=%d, r:id=%s, name=%s\r\n",
                sheet_id,
                sheet_opc_ref.c_str(),
                sheet_name.c_str());
            std::cout<<(s);
        }

        std::string GetTag()
        {
            return "sheet";
        }

    };

    class CalcPRRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "calcPr";
        }

    };

    class WorkbookViewRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "workbookView";
        }

    };

    class WebPublishingRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "webPublishing";
        }

    };

    class ExternalReferencesRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "externalReferences";
        }

    };

    class ExternalReferenceRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
            if (reclen < 4)
            {
                std::cout<<("\tinfo : invalid externalReference record length\r\n");
                return;
            }

            DWORD lenStr = CBinaryBiff12StreamReader::GetDword(p + 0);
            std::wstring sRId = CBinaryBiff12StreamReader::GetString(p + 4, lenStr);

            WCHAR s[256];
           swprintf(s, sizeof(s), L"\tinfo : r:id=%s r:id:lenStr=%d\r\n",
                sRId.c_str(),
                lenStr);
            std::cout<<(s);
        }

        std::string GetTag()
        {
            return "externalReference";
        }

    };

    class ExternalReferencesEndRecord : public CBiff12RecordBase
    {
        void Read(LPBYTE p, DWORD recid, DWORD reclen)
        {
        }

        std::string GetTag()
        {
            return "/externalReferences";
        }

    };
}


#endif