: QMainWindow(parent),

ui(new Ui::AddSales),

tableView(new QTableView(this)),

model(new QStandardItemModel(this))

{

ui->setupUi(this);

// Set up the model with the appropriate column count

model->setColumnCount(5); // Adjusted the column count to 5 to match the actual data being used

model->setHorizontalHeaderLabels({"Product ID", "Product", "Quantity", "Sale Date", "Price","Discount","Customer ID","Total Price"});

// Set the model for the table view

tableView->setModel(model);

tableView->setSelectionMode(QAbstractItemView::SingleSelection);

tableView->setSelectionBehavior(QAbstractItemView::SelectRows);

tableView->setEditTriggers(QAbstractItemView::DoubleClicked | QAbstractItemView::SelectedClicked);

ui->table_horizontalLayout->addWidget(tableView);

tableView->setSizePolicy(QSizePolicy::Expanding, QSizePolicy::Preferred);

ui->table_horizontalLayout->setStretch(0, 1);

ui->Total_label->setText(QString::number(total, 'f', 2)); // Format total to two decimals

// Adjust column sizes based on the content

tableView->resizeColumnsToContents();

// Set a minimum width for each column to ensure the table looks good

for (int column = 0; column < model->columnCount(); ++column) {

// Set a minimum width for the column, you can adjust this value as needed

tableView->setColumnWidth(column, qMax(tableView->columnWidth(column), 100)); // Minimum width is 100px

}

{

// Retrieve user input values

QString productId = ui->Product_id->text();

QString productName = ui->Product_name->text();

int quantity = ui->quantity_spinBox->value();

double price = ui->price_doubleSpinBox->value();

QDate saleDate = ui->purchase_Date_dateEdit->date();

double discount = ui->discount_doubleSpinBox->value();

QString customer_Id = ui->customer_id->text();

double total_price_payable = price - ((price*discount)/100);

if(customer_Id.isEmpty()){

QMessageBox::warning(this, "Input Error", "Please fill customer");

return;

}

// Check for empty fields or invalid values

if (productId.isEmpty() || productName.isEmpty() || quantity <= 0 || price <= 0 || saleDate.isNull() || customer_Id.isEmpty()) {

QMessageBox::warning(this, "Input Error", "Please fill all necessary fields.");

return;

}

// Check available stock

QSqlQuery stockQuery;

stockQuery.prepare("SELECT quantity FROM products WHERE product_id = :id");

stockQuery.bindValue(":id", productId);

if (!stockQuery.exec()) {

QMessageBox::critical(this, "Stock Error", "Failed to execute stock query.");

return;

}

if (stockQuery.next()) { //Move to the first (and only) row

int availableStock = stockQuery.value(0).toInt();

if (availableStock < quantity) {

QMessageBox::warning(this, "Out of Stock",

QString("Only %1 units available in stock.").arg(availableStock));

return;

}

} else {

QMessageBox::critical(this, "Stock Error", "Product not found in inventory.");

return;

}

// Create a new row with the appropriate data

QList<QStandardItem*> newRow;

newRow.append(new QStandardItem(productId)); // Product ID

newRow.append(new QStandardItem(productName)); // Product Name

newRow.append(new QStandardItem(QString::number(quantity))); // Quantity

newRow.append(new QStandardItem(saleDate.toString("yyyy-MM-dd"))); // Sale Date

newRow.append(new QStandardItem(QString::number(price, 'f', 2))); // Price (formatted to 2 decimal places)

newRow.append(new QStandardItem(QString::number(discount, 'f', 2))); // discount (formatted to 2 decimal places)

newRow.append(new QStandardItem(customer_Id)); // Price (formatted to 2 decimal places)

newRow.append(new QStandardItem(QString::number(total_price_payable, 'f', 2))); // total_price_payable (formatted to 2 decimal places)

// Append the new row to the model

model->appendRow(newRow);

// Update the total by adding the price of the newly added product

total += total_price_payable;

// Update the total label in the UI, ensuring it's formatted correctly

ui->Total_label->setText(QString::number(total, 'f', 2));

{

// Get the selected indexes from the table view

QModelIndexList selectedIndexes = tableView->selectionModel()->selectedRows();

if (selectedIndexes.isEmpty()) {

QMessageBox::warning(this, "Warning", "Please select a product to delete.");

return;

}

// Calculate the total price of the selected products to delete

double totalToSubtract = 0;

for (const QModelIndex &index : selectedIndexes) {

int row = index.row();

QModelIndex priceIndex = model->index(row, 7); // Assuming price is in the 5th column (index 4)

double price = priceIndex.data().toString().toDouble();

totalToSubtract += price;

}

// Remove selected rows from the model

for (int i = selectedIndexes.size() - 1; i >= 0; --i) {

model->removeRow(selectedIndexes[i].row());

}

// Update the total by subtracting the price of the deleted items

total -= totalToSubtract;

ui->Total_label->setText(QString::number(total, 'f', 2));

QMessageBox::information(this, "Success", "Selected product(s) deleted successfully.");

{

int rowCount = model->rowCount();

if (rowCount == 0) {

QMessageBox::warning(this, "Warning", "No products to insert.");

return;

}

QSqlDatabase db = QSqlDatabase::database();

if (!db.isOpen()) {

QMessageBox::critical(this, "Error", "Database is not open.");

return;

}

QSqlQuery query(db);

if (!query.exec("BEGIN TRANSACTION")) {

QMessageBox::critical(this, "Error", "Failed to start database transaction.");

return;

}

for (int row = 0; row < rowCount; ++row) {

QString productId = model->item(row, 0)->text();

int quantity = model->item(row, 2)->text().toInt();

QDate saleDate = QDate::fromString(model->item(row, 3)->text(), "yyyy-MM-dd");

double price = model->item(row, 4)->text().toDouble();

double discount = model->item(row, 5)->text().toDouble();

QString customer_id = model->item(row, 6)->text();

query.prepare("INSERT INTO sales (product_id, quantity_sold, sale_date, total_price, discount, customer_id) "

"VALUES (:product_id, :quantity, :sale_date, :price, :discount, :customer_id)");

query.bindValue(":product_id", productId);

query.bindValue(":quantity", quantity);

query.bindValue(":sale_date", saleDate.toString("yyyy-MM-dd"));

query.bindValue(":price", price * quantity); // Calculate total price

query.bindValue(":discount", discount);

query.bindValue(":customer_id", customer_id);

if (!query.exec()) {

QMessageBox::critical(this, "Error", "Failed to insert product: " + query.lastError().text());

query.exec("ROLLBACK");

return;

}

}

if (!query.exec("COMMIT")) {

QMessageBox::critical(this, "Error", "Failed to commit transaction: " + query.lastError().text());

return;

}

total=0;

ui->Total_label->setText(QString::number(total, 'f', 2));

QMessageBox::information(this, "Success", "Products Sale successfully");

// Remove all rows from the model after successful insertion

model->removeRows(0, rowCount);

//logs

GlobalFunctions::log_add_sale();

{

bool ok;

int productId = arg1.toInt(&ok);

if (!ok || productId <= 0) {

ui->Product_id->clear();

return;

}

QSqlQuery query;

query.prepare("SELECT * FROM products WHERE product_id = :product_id");

query.bindValue(":product_id", productId);

if (!query.exec()) {

QMessageBox::critical(this, "Error", "Failed to execute query: " + query.lastError().text());

return;

}

if (query.next()) {

QString productName = query.value("name").toString();

int quantity = query.value("quantity").toInt();

float price = query.value("price").toFloat();

if (quantity == 0) {

ui->statusbar->showMessage("The product is out of stock.", 3000);

ui->statusbar->setStyleSheet("QStatusBar { background-color: yellow; color: white; }");

return;

}

ui->Product_name->setText(productName);

ui->quantity_spinBox->setValue(1); // Default quantity

ui->price_doubleSpinBox->setValue(price);

ui->statusbar->showMessage("Product found customer with the given ID.", 3000);

ui->statusbar->setStyleSheet("QStatusBar { background-color: green; color: white; }");

} else {

ui->Product_name->clear();

ui->quantity_spinBox->setValue(0); // Default quantity

ui->price_doubleSpinBox->setValue(0);

ui->statusbar->showMessage("No product found with the given ID.", 3000);

ui->statusbar->setStyleSheet("QStatusBar { background-color: red; color: white; }");

}

{

double price = ui->price_doubleSpinBox->value();

ui->price_doubleSpinBox->setValue(price * arg1);

{

bool ok;

int customerId = arg1.toInt(&ok);

if (!ok || customerId <= 0) {

ui->customer_id->clear();

return;

}

QSqlQuery query;

query.prepare("SELECT * FROM customers WHERE customer_id = :customer_id");

query.bindValue(":customer_id", customerId);

if (!query.exec()) {

QMessageBox::critical(this, "Error", "Failed to execute query: " + query.lastError().text());

return;

}

if (query.next()) {

QString CustomerName = query.value("name").toString();

QString Address = query.value("address").toString();

QString Contact_info = query.value("contact_info").toString();

int loyalty_points = query.value("loyalty_points").toInt();

ui->customer_name->setText(CustomerName);

ui->customer_addresss->setText(Address);

ui->customer_label->setText(Contact_info);

ui->customer_loyalty_points->setText(QString::number(loyalty_points));

ui->statusbar->showMessage("Customer found with the given ID.", 3000);

ui->statusbar->setStyleSheet("QStatusBar { background-color: green; color: white; }");

} else {

ui->customer_name->clear();

ui->customer_addresss->clear();

ui->customer_label->clear();

ui->customer_loyalty_points->clear();

ui->statusbar->showMessage("No customer found with the given ID.", 3000);

ui->statusbar->setStyleSheet("QStatusBar { background-color: red; color: white; }");

}

{

Register_Customer = new RegisterCustomer(this);

Register_Customer->show();

{

checkdiscount = new CheckDiscount;

//checkdiscount->show();

checkdiscount->exec();

// After the dialog is closed, retrieve the discount value

QString discount = checkdiscount->getSelectedDiscount();

// Handle the discount (e.g., display it or apply it to a price)

if (!discount.isEmpty()) {

QMessageBox::information(this, "Discount Selected", "You selected a discount of " + discount + "%.");

} else {

QMessageBox::warning(this, "No Discount", "No discount was selected.");

}

// Clean up the dialog

delete checkdiscount;

//setting discount in ui

ui->discount_doubleSpinBox->setValue( discount.toDouble());