displaytablesdialog.cpp

#include "displaytablesdialog.h"
#include "ui_displaytablesdialog.h"

#include <QFileDialog>
#include <QDir>
#include <QtXlsx>

#include "windowtools.h"

DisplayTablesDialog::DisplayTablesDialog(QWidget *parent) :
    QDialog(parent),
    ui(new Ui::DisplayTablesDialog)
{
    ui->setupUi(this);

    setWindowTitle(tr("Results Table"));

    WindowTools::SetDialogFixedMaximize(this);
}

DisplayTablesDialog::~DisplayTablesDialog()
{
    delete ui;
}

/**
 * @brief DisplayTablesDialog::InsertData
 * @param data
 */
void DisplayTablesDialog::InsertData(QList<QList<QStringList>> * data)
{
    QList<QTableWidget *> mTables;
    mTables.append(ui->tableWidgetOverall);
    mTables.append(ui->tableWidgetOne);
    mTables.append(ui->tableWidgetTwo);
    mTables.append(ui->tableWidgetThree);

    for (int i(0); i<mTables.count(); i++)
    {
        mTables.at(i)->clear();
        mTables.at(i)->setRowCount(0);
        mTables.at(i)->setColumnCount(0);

        QStringList temp;

        for (int tableNumberRows(0); tableNumberRows < data->at(i).count(); tableNumberRows++)
        {
            temp = data->at(i).at(tableNumberRows);
            mTables.at(i)->insertRow(mTables.at(i)->rowCount());

            for (int tableNumberCols(0); tableNumberCols < data->at(i).at(tableNumberRows).count(); tableNumberCols++)
            {
                if(tableNumberCols >= mTables.at(i)->columnCount())
                {
                    mTables.at(i)->insertColumn(mTables.at(i)->columnCount());
                }

                // Less one to adjust for Excel-style coordinates
                mTables.at(i)->setItem(tableNumberRows - 1, tableNumberCols - 1, new QTableWidgetItem(temp.at(tableNumberCols)));
            }
        }
    }
}

void DisplayTablesDialog::on_pushButtonSave_clicked()
{
    QString file_name;
    QString fileFilter = "Spreadsheet (*.xlsx)";

#ifdef _WIN32

        file_name = QFileDialog::getSaveFileName(this, tr("Save spreadsheet file"), QDir::homePath(),
                                         fileFilter);

#elif TARGET_OS_MAC

        file_name = QFileDialog::getSaveFileName(this, tr("Save spreadsheet file"), QDir::homePath(),
                                         fileFilter, &fileFilter, QFileDialog::Option::DontUseNativeDialog);

        if (!file_name.contains(".xlsx"))
        {
            file_name.append(".xlsx");
        }

#endif

    if(!file_name.trimmed().isEmpty())
    {
        QList<QTableWidget *> mTables;
        mTables.append(ui->tableWidgetOverall);
        mTables.append(ui->tableWidgetOne);
        mTables.append(ui->tableWidgetTwo);
        mTables.append(ui->tableWidgetThree);

        QStringList sheetNames;
        sheetNames << "Case Report" << "Schedule One" << "Schedule Two" << "Schedule Three";

        QApplication::setOverrideCursor(Qt::WaitCursor);

        QXlsx::Document xlsx;

        int rows, cols;
        QString temp;

        for (int i(0); i<mTables.count(); i++)
        {
            rows = mTables.at(i)->rowCount();
            cols = mTables.at(i)->columnCount();

            xlsx.addSheet(sheetNames.at(i));

            for (int r=0; r<rows; r++)
            {
                for (int c=0; c<cols; c++)
                {
                    QTableWidgetItem *item = mTables.at(i)->item(r, c);

                    if (item != NULL && !item->text().isEmpty())
                    {
                        temp = mTables.at(i)->item(r, c)->data(Qt::DisplayRole).toString();
                        xlsx.write(r + 1, c + 1, temp);
                    }
                }
            }
        }

        xlsx.selectSheet(sheetNames.at(0));
        xlsx.saveAs(file_name);

        QApplication::restoreOverrideCursor();
    }
}