int MPF::animateWidget(QWidget* widget, bool hide, int effect)
{
if(!widget)
{
return 1;
}
if(effect == FADING)
{
QGraphicsOpacityEffect* opacityEffect = new QGraphicsOpacityEffect(this);
opacityEffect->setOpacity(0);
widget->setGraphicsEffect(opacityEffect);
QPropertyAnimation* anim = new QPropertyAnimation(this);
anim->setTargetObject(opacityEffect);
anim->setPropertyName("opacity");
anim->setDuration(3000);
anim->setStartValue(opacityEffect->opacity());
anim->setEndValue(1);
anim->setEasingCurve(QEasingCurve::OutQuad);
anim->start(QAbstractAnimation::DeleteWhenStopped);
}
return 0;
}
int MPF::showHelp()
{
QGraphicsOpacityEffect* opacityEffect = new QGraphicsOpacityEffect(this);
helpTextEdit->setGraphicsEffect(opacityEffect);
//helpTextEdit->setText("");
QPropertyAnimation* anim = new QPropertyAnimation(this);
if(helpTextEdit->isHidden())
{
opacityEffect->setOpacity(1);
anim->setEndValue(0);
helpPushButton->setText(trUtf8("&Hide Help"));
helpTextEdit->show();
fullHelpPushButton->show();
}
else
{
opacityEffect->setOpacity(0);
anim->setEndValue(1);
helpPushButton->setText(trUtf8("&Show Help"));
helpTextEdit->hide();
fullHelpPushButton->hide();
}
anim->setTargetObject(opacityEffect);
anim->setPropertyName("opacity");
anim->setDuration(3000);
anim->setStartValue(opacityEffect->opacity());
anim->setEasingCurve(QEasingCurve::InBounce);
anim->start(QAbstractAnimation::DeleteWhenStopped);
return 0;
}
void Manager::on_pushButton_Clear_clicked()
{
//Clearing Text Fields
progressBar->setValue(0);
ui->lineEdit_Album->clear();
ui->lineEdit_band_name->clear();
ui->lineEdit_price_max->clear();
ui->lineEdit_price_min->clear();
ui->label_results->clear();
Database conn;
QSqlQueryModel * model = new QSqlQueryModel();
conn.connOpen("Inventory");
QSqlQuery * qry = new QSqlQuery(conn.mydb);
progressBar->setValue(25);
qry->prepare("SELECT * FROM Inventory");
qry->exec();
model->setQuery(*qry);
ui->tableView_Master->setModel(model);
ui->comboBox_Type->setCurrentIndex(0);
progressBar->setValue(50);
ui->checkBox_XS->setChecked(false);
ui->checkBox_S->setChecked(false);
ui->checkBox_M->setChecked(false);
progressBar->setValue(75);
ui->checkBox_L->setChecked(false);
ui->checkBox_XL->setChecked(false);
ui->checkBox_xxl->setChecked(false);
progressBar->setValue(100);
QGraphicsOpacityEffect* opacityEffect = new QGraphicsOpacityEffect(this);
opacityEffect->setOpacity(1.0);
ui->statusbar->setGraphicsEffect(opacityEffect);
QPropertyAnimation* anim = new QPropertyAnimation(this);
anim->setTargetObject(opacityEffect);
anim->setPropertyName("opacity");
anim->setDuration(4000);
anim->setStartValue(opacityEffect->opacity());
anim->setEndValue(0);
anim->setEasingCurve(QEasingCurve::OutQuad);
anim->start(QAbstractAnimation::DeleteWhenStopped);
qDebug() << (model->rowCount());
}
void Manager::on_pushButton_clicked()
{
progressBar->setValue(0);
Database conn;
QSqlQueryModel * model = new QSqlQueryModel();
conn.connOpen("Inventory");
QSqlQuery * qry = new QSqlQuery(conn.mydb);
QString Band_Name = ui->lineEdit_band_name->text();
QString Album = ui->lineEdit_Album->text();
QString Type = ui->comboBox_Type->currentText();
qint32 minPrice = 0;
if(!ui->lineEdit_price_min->text().isEmpty())
minPrice = ui->lineEdit_price_min->text().toInt();
qint32 maxPrice = 99999;
progressBar->setValue(25);
if(!ui->lineEdit_price_max->text().isEmpty())
maxPrice = ui->lineEdit_price_max->text().toInt();
if(Type == "Select a Type")
Type = "";
qint32 xs_int = 999;
qint32 s_int = 999;
qint32 m_int = 999;
qint32 l_int = 999;
qint32 xl_int = 999;
qint32 xxl_int = 999;
progressBar->setValue(50);
if(!ui->checkBox_XS->isChecked() && !ui->checkBox_S->isChecked() && !ui->checkBox_M->isChecked() &&
!ui->checkBox_L->isChecked() && !ui->checkBox_XL->isChecked() && !ui->checkBox_xxl->isChecked())
{
QString queryString;
QTextStream queryStream(&queryString);
queryStream
<< "SELECT * FROM Inventory WHERE \"Price\" >= '"
<< minPrice << "' AND \"Price\" <= '"
<< maxPrice << "' AND Band LIKE '%"+Band_Name+"%' AND Album LIKE '%"+Album+"%' AND Type LIKE '"+Type+"%'";
qry->prepare(queryString);
}
else
{
if(ui->checkBox_XS->isChecked())
xs_int = 0;
if(ui->checkBox_S->isChecked())
s_int = 0;
if(ui->checkBox_M->isChecked())
m_int = 0;
if(ui->checkBox_L->isChecked())
l_int = 0;
if(ui->checkBox_XL->isChecked())
xl_int = 0;
if(ui->checkBox_xxl->isChecked())
xxl_int = 0;
QString queryString;
QTextStream queryStream(&queryString);
queryStream
<< "SELECT * FROM Inventory WHERE \"XS(Quantity)\" > '"
<< xs_int << "' AND \"Price\" >= '"
<< minPrice << "' AND \"Price\" <= '"
<< maxPrice << "' AND Band LIKE '%" << Band_Name << "%' AND Album LIKE '%"+Album+"%' AND Type LIKE '"+Type+"%' OR \"S(Quantity)\" > '"
<< s_int << "' AND \"Price\" >= '"
<< minPrice << "' AND \"Price\" <= '"
<< maxPrice << "' AND Band LIKE '%" << Band_Name << "%' AND Album LIKE '%"+Album+"%' AND Type LIKE '"+Type+"%' OR \"M(Quantity)\" > '"
<< m_int << "' AND \"Price\" >= '"
<< minPrice << "' AND \"Price\" <= '"
<< maxPrice << "' AND Band LIKE '%" << Band_Name << "%' AND Album LIKE '%"+Album+"%' AND Type LIKE '"+Type+"%' OR \"L(Quantity)\" > '"
<< l_int << "' AND \"Price\" >= '"
<< minPrice << "' AND \"Price\" <= '"
<< maxPrice << "' AND Band LIKE '%" << Band_Name << "%' AND Album LIKE '%"+Album+"%' AND Type LIKE '"+Type+"%' OR \"XL(Quantity)\" > '"
<< xl_int << "' AND \"Price\" >= '"
<< minPrice << "' AND \"Price\" <= '"
<< maxPrice << "' AND Band LIKE '%" << Band_Name << "%' AND Album LIKE '%"+Album+"%' AND Type LIKE '"+Type+"%' OR \"XXL(Quantity)\" > '"
<< xxl_int << "' AND \"Price\" >= '"
<< minPrice << "' AND \"Price\" <= '"
<< maxPrice << "' AND Band LIKE '%" << Band_Name << "%' AND Album LIKE '%"+Album+"%' AND Type LIKE '"+Type+"%'";
qry->prepare(queryString);
}
progressBar->setValue(75);
if(!qry->exec())
{
QMessageBox::critical(this, tr("Error"), qry->lastError().text());
}
model->setQuery(*qry);
ui->tableView_Master->setModel(model);
qint32 i = (model->rowCount());
QString str;
str.append(QString("%1").arg(i));
progressBar->setValue(100);
QGraphicsOpacityEffect* opacityEffect = new QGraphicsOpacityEffect(this);
opacityEffect->setOpacity(1.0);
ui->statusbar->setGraphicsEffect(opacityEffect);
QPropertyAnimation* anim = new QPropertyAnimation(this);
anim->setTargetObject(opacityEffect);
anim->setPropertyName("opacity");
anim->setDuration(4000);
anim->setStartValue(opacityEffect->opacity());
anim->setEndValue(0);
anim->setEasingCurve(QEasingCurve::OutQuad);
anim->start(QAbstractAnimation::DeleteWhenStopped);
ui->label_results->setText(str + " Results Found!");
}
