/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */

/*

 * This file is part of the LibreOffice project.

 *

 * This Source Code Form is subject to the terms of the Mozilla Public

 * License, v. 2.0. If a copy of the MPL was not distributed with this

 * file, You can obtain one at http://mozilla.org/MPL/2.0/.

 *

 */

#include <rangelst.hxx>

#include <TableFillingAndNavigationTools.hxx>

#include <MatrixComparisonGenerator.hxx>

#include <scresid.hxx>

#include <strings.hrc>

namespace

{

    void lclWriteCorrelationFormulas(

            AddressWalkerWriter& aOutput, FormulaTemplate& aTemplate,

            const ScRangeList& aRangeList, const OUString& aTemplateString)

    {

        for (size_t i = 0; i < aRangeList.size(); i++)

        {

            aOutput.resetRow();

            for (size_t j = 0; j < aRangeList.size(); j++)

            {

                if (j >= i)

                {

                    aTemplate.setTemplate(aTemplateString);

                    aTemplate.applyRange(u"%VAR1%", aRangeList[i]);

                    aTemplate.applyRange(u"%VAR2%", aRangeList[j]);

                    aOutput.writeFormula(aTemplate.getTemplate());

                }

                aOutput.nextRow();

            }

            aOutput.nextColumn();

        }

    }

}

ScMatrixComparisonGenerator::ScMatrixComparisonGenerator(

                                    SfxBindings* pSfxBindings, SfxChildWindow* pChildWindow,

                                    weld::Window* pParent, ScViewData& rViewData,

                                    const OUString& rUiXmlDescription,

                                    const OUString& rID)

    : ScStatisticsInputOutputDialog(pSfxBindings, pChildWindow, pParent, rViewData, rUiXmlDescription, rID)

{}

ScMatrixComparisonGenerator::~ScMatrixComparisonGenerator()

{}

TranslateId ScMatrixComparisonGenerator::GetUndoNameId()

{

    return STR_CORRELATION_UNDO_NAME;

}

ScRange ScMatrixComparisonGenerator::ApplyOutput(ScDocShell* pDocShell)

{

    AddressWalkerWriter output(mOutputAddress, pDocShell, mDocument,

            formula::FormulaGrammar::mergeToGrammar( formula::FormulaGrammar::GRAM_ENGLISH, mAddressDetails.eConv));

    FormulaTemplate aTemplate(&mDocument);

    SCTAB inTab = mInputRange.aStart.Tab();

    ScRangeList aRangeList = (mGroupedBy == BY_COLUMN) ?

        MakeColumnRangeList(inTab, mInputRange.aStart, mInputRange.aEnd) :

        MakeRowRangeList(inTab, mInputRange.aStart, mInputRange.aEnd);

    // labels

    output.writeString(getLabel());

    output.nextColumn();

    static constexpr OUString strWildcardNumber(u"%NUMBER%"_ustr);

    // write labels to columns

    for (size_t i = 0; i < aRangeList.size(); i++)

    {

        if (mGroupedBy == BY_COLUMN)

            aTemplate.setTemplate(ScResId(STR_COLUMN_LABEL_TEMPLATE));

        else

            aTemplate.setTemplate(ScResId(STR_ROW_LABEL_TEMPLATE));

        aTemplate.applyNumber(strWildcardNumber, i + 1);

        output.writeString(aTemplate.getTemplate());

        output.nextColumn();

    }

    // write labels to rows

    output.resetColumn();

    output.nextRow();

    for (size_t i = 0; i < aRangeList.size(); i++)

    {

        if (mGroupedBy == BY_COLUMN)

            aTemplate.setTemplate(ScResId(STR_COLUMN_LABEL_TEMPLATE));

        else

            aTemplate.setTemplate(ScResId(STR_ROW_LABEL_TEMPLATE));

        aTemplate.applyNumber(strWildcardNumber, i + 1);

        output.writeString(aTemplate.getTemplate());

        output.nextRow();

    }

    // write correlation formulas

    output.reset();

    output.push(1, 1);

    lclWriteCorrelationFormulas(output, aTemplate, aRangeList, getTemplate());

    return ScRange(output.mMinimumAddress, output.mMaximumAddress);

}

/* vim:set shiftwidth=4 softtabstop=4 expandtab: */