src/ProdOnCode.cpp

Fri, 20 Jan 2023 16:44:08 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Fri, 20 Jan 2023 16:44:08 +0100
changeset 467
c5f6f3f1b714
parent 231
54b5abd46958
permissions
-rw-r--r--

Added more buttons to the images tab. Load images from the database and display thumbnails added. Added support for jpeg files. Rename pictures in the database to .png. Added temporary images_list, images_count and images_current variables to the product record.

/**
 * ProdOnCode.cpp is part of bmsapp.
 *
 * bmsapp is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * bmsapp is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
#include "ProdOnCode.h"
#include "MainWindow.h"
#include "EditProduct.h"
#include "config.h"
#include "global.h"


ProdOnCode::ProdOnCode(QWidget *parent) : QDialog(parent)
{
    qDebug() << "ProdOnCode start";

    gridLayout = new QGridLayout(this);
    gridLayout->setObjectName(QString::fromUtf8("gridLayout"));
    tableOnCode = new QTableWidget(this);
    tableOnCode->setObjectName(QString::fromUtf8("tableOnCode"));
    tableOnCode->setEnabled(true);
    QSizePolicy sizePolicy(QSizePolicy::Fixed, QSizePolicy::Expanding);
    sizePolicy.setHorizontalStretch(0);
    sizePolicy.setVerticalStretch(0);
    sizePolicy.setHeightForWidth(tableOnCode->sizePolicy().hasHeightForWidth());
    tableOnCode->setSizePolicy(sizePolicy);
    tableOnCode->setMinimumSize(QSize(1164, 0));
    gridLayout->addWidget(tableOnCode, 0, 0, 1, 1);

    groupBox = new QGroupBox(this);
    groupBox->setObjectName(QString::fromUtf8("groupBox"));
    groupBox->setEnabled(true);
    groupBox->setFlat(false);

    horizontalLayout = new QHBoxLayout(groupBox);
    horizontalLayout->setSpacing(6);
    horizontalLayout->setObjectName(QString::fromUtf8("horizontalLayout"));
    horizontalLayout->setContentsMargins(0, 0, 0, 0);

    quitButton = new QPushButton(groupBox);
    quitButton->setObjectName(QString::fromUtf8("quitButton"));
    quitButton->setMinimumSize(QSize(80, 24));
    quitButton->setText(tr("Quit"));
    QIcon icon;
    icon.addFile(QString::fromUtf8(":icons/silk/door_out.png"), QSize(), QIcon::Normal, QIcon::Off);
    quitButton->setIcon(icon);
    horizontalLayout->addWidget(quitButton, 0, Qt::AlignCenter);
    gridLayout->addWidget(groupBox, 1, 0, 1, 1);

    connect(quitButton, SIGNAL(clicked()), parent, SLOT(fromProdOnCode()));
    connect(this, SIGNAL(setStatus(QString)), parent, SLOT(statusMsg(QString)));
    emit refreshTable();
}


void ProdOnCode::refreshTable()
{
    QString w;
    QWidget* pWidget;
    QHBoxLayout* pLayout;

    qDebug() << "ProdOnCode reload";
    QSqlQuery query("SELECT record,name,st_name,og,fg,brew_date_start,code FROM products WHERE stage = '11' ORDER BY code,brew_date_start");
    const QStringList labels({tr("Code"), tr("Name"), tr("Style"), tr("OG"), tr("FG"),  tr("Date"), tr("Edit")});

    this->tableOnCode->setColumnCount(7);
    this->tableOnCode->setColumnWidth(0, 100);  /* Code         */
    this->tableOnCode->setColumnWidth(1, 500);	/* Product name	*/
    this->tableOnCode->setColumnWidth(2, 200);	/* Style	*/
    this->tableOnCode->setColumnWidth(3,  75);	/* OG		*/
    this->tableOnCode->setColumnWidth(4,  75);	/* FG		*/
    this->tableOnCode->setColumnWidth(5, 100);	/* Date		*/
    this->tableOnCode->setColumnWidth(6, 90);	/* Edit button	*/
    this->tableOnCode->setRowCount(query.size());
    this->tableOnCode->setHorizontalHeaderLabels(labels);
    this->tableOnCode->verticalHeader()->hide();

    query.first();
    for (int ridx = 0 ; ridx < query.size() ; ridx++ ) {

	this->tableOnCode->setItem(ridx, 0, new QTableWidgetItem(query.value("code").toString()));
	this->tableOnCode->setItem(ridx, 1, new QTableWidgetItem(query.value("name").toString()));
	this->tableOnCode->setItem(ridx, 2, new QTableWidgetItem(query.value("st_name").toString()));
	QTableWidgetItem *item = new QTableWidgetItem(QString("%1").arg(query.value("og").toFloat(), 4, 'f', 3, '0' ));
	item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
	this->tableOnCode->setItem(ridx, 3, item);

	item = new QTableWidgetItem(QString("%1").arg(query.value("fg").toFloat(), 4, 'f', 3, '0' ));
        item->setTextAlignment(Qt::AlignCenter|Qt::AlignVCenter);
        this->tableOnCode->setItem(ridx, 4, item);

	this->tableOnCode->setItem(ridx, 5, new QTableWidgetItem(query.value("brew_date_start").toDate().toString("dd MMM yyyy")));

	/* Add the Edit button */
        QWidget* pWidget = new QWidget();
        QPushButton* btn_edit = new QPushButton();
        btn_edit->setObjectName(QString("%1").arg(query.value(0).toString()));  /* Send record with the button */
        btn_edit->setText(tr("Edit"));
        connect(btn_edit, SIGNAL(clicked()), this, SLOT(on_editButton_clicked()));
        QHBoxLayout* pLayout = new QHBoxLayout(pWidget);
        pLayout->addWidget(btn_edit);
        pLayout->setContentsMargins(5, 0, 5, 0);
        pWidget->setLayout(pLayout);
        this->tableOnCode->setCellWidget(ridx, 6, pWidget);
        query.next();
    }

    emit setStatus(QString(tr("Total items: %1")).arg(query.size()));
}


ProdOnCode::~ProdOnCode() {}


void ProdOnCode::edit(int recno)
{
    EditProduct dialog(recno, this);
    /* Signal from editor if a refresh is needed */
    connect(&dialog, SIGNAL(entry_changed()), this, SLOT(refreshTable()));
    dialog.setModal(true);
    dialog.exec();
}


void ProdOnCode::on_editButton_clicked()
{
    QPushButton *pb = qobject_cast<QPushButton *>(QObject::sender());
    int recno = pb->objectName().toInt();
    edit(recno);
}

mercurial