mainwindow.cpp

#include <QProcess>
#include <QInputDialog>
#include <QDebug>
#include <QDir>
#include <QFileDialog>

#include "mainwindow.h"
#include "ui_mainwindow.h"
#include "script.h"
#include <iomanip>

#include <QListView>
#include <QStringList>
#include <QUrl>
#include <QAbstractItemView>

#include <QPixmap>
#include <QPalette>
#include <QTextCodec>

#define DEFAULT_DB_NAME "recipes.db"


MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    cathegory = CATHEGORY_EMPTY;

    dbReady = true;

    Script *updater = new Script;
    updater->moveToThread(&updater_thread);

    connect(&updater_thread, &QThread::finished, updater, &QObject::deleteLater);
    connect(this, &MainWindow::do_update, updater, &Script::update_DB);
    connect(updater, &Script::DB_updated, this, &MainWindow::update_done);

    updater_thread.start();

    DB_manager *manager = new DB_manager;
    manager->moveToThread(&manager_thread);

    connect(&manager_thread, &QThread::finished, manager, &QObject::deleteLater);
    connect(this, &MainWindow::do_search, manager, &DB_manager::search);
    connect(manager, &DB_manager::search_done, this, &MainWindow::search_done);
    connect(this, &MainWindow::do_open, manager, &DB_manager::open_DB);
    connect(manager, &DB_manager::DB_opened, this, &MainWindow::open_done);
    connect(this, &MainWindow::do_create, manager, &DB_manager::create_DB);
    connect(manager, &DB_manager::DB_created, this, &MainWindow::create_done);
    connect(this, &MainWindow::do_get_cathegories, manager, &DB_manager::get_cathegories_slot);
    connect(manager, &DB_manager::got_cathegories, this, &MainWindow::got_cathegories);
    connect(this, &MainWindow::do_get_recipe_details, manager, &DB_manager::get_recipe_details);
    connect(manager, &DB_manager::got_recipe_details, this, &MainWindow::got_recipe_details);

    manager_thread.start();


    ui->setupUi(this);
    // ui->statusBar->hide();

    QPixmap backgroundImage(":/new/prefix1/Frame 6 (1).png");
    QPalette palette;
    palette.setBrush(this->backgroundRole(), QBrush(backgroundImage));
    this->setPalette(palette);

    ui->lineEdit->setPlaceholderText(QTextCodec::codecForName("CP1251")->toUnicode("Ïîäñîåäèíèòå áàçó äàííûõ..."));

    ui->comboBox_2->setView(new QListView());

    ui->tableView->verticalHeader()->hide();
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////

MainWindow::~MainWindow()
{
    updater_thread.exit();
    delete ui;
}

void MainWindow::on_search_clicked()
{

    setlocale(LC_ALL, "RUS");

    ui->statusBar->clearMessage();

    LowSearch = ui->lineEdit->text();

    if (cathegory == QTextCodec::codecForName("CP1251")->toUnicode(CATHEGORY_EMPTY))
        cathegory = CATHEGORY_EMPTY;

    emit do_search(LowSearch, cathegory);
}

void MainWindow::search_done(QSqlQueryModel *res)
{
    ui->tableView->setModel(res);


    ui->tableView->horizontalHeader()->setSectionResizeMode(QHeaderView::Fixed);
    int totalWidth = ui->tableView->width();
    int firstColumnWidth = totalWidth * 0.55;
    int secondColumnWidth = totalWidth * 0.45;
    ui->tableView->setColumnWidth(0, firstColumnWidth);
    ui->tableView->setColumnWidth(1, secondColumnWidth);

    ui->tableView-> setSelectionBehavior(QAbstractItemView::SelectRows);
    ui->tableView->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
}

void MainWindow::on_tableView_doubleClicked(const QModelIndex &index)
{

    ui->textBrowser->clear();

    if (index.isValid())
    {
        QString recipe_name = index.sibling(index.row(), 0).data().toString(); // recipeName
        // QString second = index.sibling(index.row(), 1).data().toString(); // categoryName

        emit do_get_recipe_details(recipe_name);
    }
}

void MainWindow::got_recipe_details(QString res)
{
    ui->textBrowser->setHtml(res);
}



void MainWindow::on_actionUpdateDB_triggered()
{
    bool ok;
    QStringList param;

    param << db_path;

    param << QInputDialog::getText(this, QString("Parameters:"), QString("Enter parameters:"), QLineEdit::Normal,
                                   "", &ok).split(' ');

    if (ok && !param[0].isEmpty())
    {
        dbReady = false;
        emit do_update(param);
    }
}

void MainWindow::update_done()
{
    dbReady = true;
    emit do_get_cathegories();
}

void MainWindow::got_cathegories(QStringList* cathegories)
{
    set_cathegories(cathegories);
}

void MainWindow::on_actionOpenDB_triggered()
{
    QString path = QFileDialog::getOpenFileName(this);
    if(path.isEmpty())
        return;

    if (db.open())
        db.close();
    db_path = path;

    emit do_open(path);
}

void MainWindow::open_done(bool res, QString message, QStringList* cathegories)
{
    ////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    if(res)//ask Lev Olegovich
    {
        ui->statusBar->showMessage("db is open: " + message);
        set_cathegories(cathegories);
        ui->lineEdit->setPlaceholderText(QTextCodec::codecForName("CP1251")->toUnicode("Ââåäèòå äîñòóïíûå èíãðåäèåíòû..."));
    }
    else
        ui->statusBar->showMessage("db have error: " + message);
}

void MainWindow::on_actionCreateDB_triggered()
{
    bool ok;

    QString path = QFileDialog::getExistingDirectory(this);
    if(path.isEmpty()) return;
    QString name = QInputDialog::getText(this, QString("Name"), QTextCodec::codecForName("CP1251")->toUnicode("Ââåäèòå íàçâàíèå áàçû äàííûõ"), QLineEdit::Normal,
                                         "", &ok);
    if(name.isEmpty()) name = DEFAULT_DB_NAME;
    db_path = path + "/" + name;
    if (!ok)
        return;

    emit do_create(path, name);
}

void MainWindow::create_done(bool res, QString message, QStringList* cathegories)
{
    if(res)
    {
        ui->lineEdit->setPlaceholderText(QTextCodec::codecForName("CP1251")->toUnicode("Ââåäèòå äîñòóïíûå èíãðåäèåíòû"));
        ui->statusBar->showMessage("db is open: " + message);
    }
    else
        ui->statusBar->showMessage("db have error: "+ message);
}


void MainWindow::on_comboBox_2_activated(const QString &arg1)
{
    cathegory = arg1;
}


void MainWindow::set_cathegories(QStringList* cathegories)//methods for combobox
{
    ui->comboBox_2->addItems(*cathegories);
}