ClublogDialog.cpp

#include <QProgressDialog>
#include <QMessageBox>
#include <QSqlQuery>
#include <QSqlRecord>
#include <QNetworkReply>

#include "ClublogDialog.h"
#include "ui_ClublogDialog.h"
#include "core/ClubLog.h"
#include "core/debug.h"
#include "core/ClubLog.h"
#include "models/SqlListModel.h"
#include "logformat/AdiFormat.h"
#include "ui/ShowUploadDialog.h"
#include "data/StationProfile.h"

MODULE_IDENTIFICATION("qlog.ui.clublogdialog");

ClublogDialog::ClublogDialog(QWidget *parent) :
    QDialog(parent),
    ui(new Ui::ClublogDialog)
{
    FCT_IDENTIFICATION;

    ui->setupUi(this);

    /* Upload */

    ui->myCallsignCombo->setModel(new SqlListModel("SELECT DISTINCT UPPER(station_callsign) FROM contacts ORDER BY station_callsign", ""));
    ui->myGridCombo->setModel(new SqlListModel("SELECT DISTINCT UPPER(my_gridsquare) FROM contacts WHERE station_callsign ='"
                                                + ui->myCallsignCombo->currentText()
                                                + "' ORDER BY my_gridsquare", ""));

    loadDialogState();
}

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

void ClublogDialog::upload()
{
    FCT_IDENTIFICATION;

    QByteArray data;
    QTextStream stream(&data, QIODevice::ReadWrite);

    AdiFormat adi(stream);

    QString QSOList;
    int count = 0;

    QStringList qslUploadStatuses = {"'M'"};

    if ( ui->addlUploadStatusN->isChecked() )
    {
        qslUploadStatuses << "'N'";
    }

    if ( ui->clearReuploadCheckbox->isChecked() )
    {
        //reupload all QSOs (except N)
        qslUploadStatuses << "'Y'";
    }

    /* https://clublog.freshdesk.com/support/solutions/articles/54905-how-to-upload-logs-directly-into-club-log */
    /* https://clublog.freshdesk.com/support/solutions/articles/53202-which-adif-fields-does-club-log-use- */
    QString query_string = QString("SELECT %1 FROM contacts ").arg(ClubLog::supportedDBFields.join(" , "));
    QString query_where =  QString("WHERE (upper(clublog_qso_upload_status) in (%1) OR clublog_qso_upload_status is NULL) ").arg(qslUploadStatuses.join(","));
    QString query_order = " ORDER BY start_time ";

    saveDialogState();

    if ( !ui->myCallsignCombo->currentText().isEmpty() )
    {
        query_where.append(" AND station_callsign = '" + ui->myCallsignCombo->currentText() + "'");
    }

    if ( !ui->myGridCombo->currentText().isEmpty() )
    {
        query_where.append(" AND my_gridsquare = '" + ui->myGridCombo->currentText() + "'");
    }

    query_string = query_string  + query_where + query_order;

    qCDebug(runtime) << query_string;

    QSqlQuery query(query_string);

    adi.exportStart();

    while (query.next())
    {
        const QSqlRecord &record = query.record();

        QSOList.append(" "
                       + record.value("start_time").toDateTime().toTimeZone(QTimeZone::utc()).toString(locale.formatDateTimeShortWithYYYY())
                       + "\t" + record.value("callsign").toString()
                       + "\t" + record.value("mode").toString()
                       + "\n");

        adi.exportContact(record);
        count++;
    }

    stream.flush();

    if (count > 0)
    {
        ShowUploadDialog showDialog(QSOList);

        if ( showDialog.exec() == QDialog::Accepted )
        {
            QProgressDialog* dialog = new QProgressDialog(tr("Uploading to Clublog"), tr("Cancel"), 0, 0, this);
            dialog->setWindowModality(Qt::WindowModal);
            dialog->setRange(0, 0);
            dialog->setAttribute(Qt::WA_DeleteOnClose, true);
            dialog->show();

            ClubLog *clublog = new ClubLog(dialog);

            connect(clublog, &ClubLog::uploadFileOK, this, [this, dialog, query_where, count, clublog](const QString &msg)
            {
                dialog->done(QDialog::Accepted);
                qCDebug(runtime) << "Clublog Upload OK: " << msg;
                QMessageBox::information(this, tr("QLog Information"), tr("%n QSO(s) uploaded.", "", count));
                QString query_string = "UPDATE contacts "
                                       "SET clublog_qso_upload_status='Y', clublog_qso_upload_date = strftime('%Y-%m-%d',DATETIME('now', 'utc')) "
                        + query_where;

                qCDebug(runtime) << query_string;

                QSqlQuery query_update(query_string);
                query_update.exec();
                clublog->deleteLater();
            });

            connect(clublog, &ClubLog::uploadError, this, [this, dialog, clublog](const QString &msg)
            {
                dialog->done(QDialog::Accepted);
                qCInfo(runtime) << "Clublog Upload Error: " << msg;
                QMessageBox::warning(this, tr("QLog Warning"), tr("Cannot upload the QSO(s): ") + msg);
                clublog->deleteLater();
            });

            connect(dialog, &QProgressDialog::canceled, this, [clublog]()
            {
                qCDebug(runtime)<< "Operation canceled";
                clublog->abortRequest();
                clublog->deleteLater();
            });

            clublog->uploadAdif(data,
                                ui->myCallsignCombo->currentText(),
                                ui->clearReuploadCheckbox->isChecked());
        }
    }
    else
    {
        QMessageBox::information(this, tr("QLog Information"), tr("No QSOs found to upload."));
    }
}



void ClublogDialog::uploadCallsignChanged(const QString &my_callsign)
{
    FCT_IDENTIFICATION;

    ui->myGridCombo->setModel(new SqlListModel("SELECT DISTINCT UPPER(my_gridsquare) FROM contacts WHERE station_callsign ='" + my_callsign + "' ORDER BY my_gridsquare", ""));

}

void ClublogDialog::saveDialogState()
{
    FCT_IDENTIFICATION;

    QSettings settings;

    settings.setValue("clublog/last_mycallsign", ui->myCallsignCombo->currentText());
    settings.setValue("clublog/last_mygrid", ui->myGridCombo->currentText());
    //reupload will not be saved becasue it will be used only in exceptional cases - one-time selection
}

void ClublogDialog::loadDialogState()
{
    FCT_IDENTIFICATION;

    QSettings settings;

    const StationProfile &profile = StationProfilesManager::instance()->getCurProfile1();

    int index = ui->myCallsignCombo->findText(profile.callsign);
    if ( index >= 0 )
        ui->myCallsignCombo->setCurrentIndex(index);
    else
        ui->myCallsignCombo->setCurrentText(settings.value("clublog/last_mycallsign").toString());

    index = ui->myGridCombo->findText(profile.locator);

    if ( index >= 0 )
        ui->myGridCombo->setCurrentIndex(index);
    else
        ui->myGridCombo->setCurrentText(settings.value("clublog/last_mygrid").toString());

    //reupload will not be loaded becasue it will be used only in exceptional cases - one-time selection
}