void ParameterWidget::removeParam(int pRow) { QLayoutItem *test; QLayoutItem *test2; test = _filtersLayout->itemAtPosition(pRow, 0)->layout()->itemAt(0); XComboBox *mybox = (XComboBox*)test->widget(); QVariant filterVar(mybox->itemData(mybox->currentIndex())); QString filterType = filterVar.toString(); QStringList split = filterType.split(":"); QPair<QString, QVariant> tempPair = _filterValues.value(split[0].toInt()); _filterValues.remove(split[0].toInt()); test2 = _filtersLayout->itemAtPosition(pRow, 0)->layout()->takeAt(1); delete test2; test2 = 0; _filtersLayout->update(); _addFilterRow->setDisabled(false); repopulateComboboxes(); if (!mybox->currentText().isEmpty()) _usedTypes.remove(pRow); emit updated(); }
void ParameterWidget::save() { QString filter; QString filtersetname; QString variantString; QString username; QString query; QVariant tempVar; int filter_id; QMessageBox msgBox; filtersetname = _filterSetName->text(); if ( filtersetname.isEmpty() ) { msgBox.setText(tr("Please enter a name for this filter set before saving.")); msgBox.exec(); return; } else { QMapIterator<int, QPair<QString, QVariant> > i(_filterValues); while (i.hasNext()) { i.next(); QPair<QString, QVariant> tempPair = i.value(); tempVar = tempPair.second; QLayoutItem *test = _filtersLayout->itemAtPosition(i.key(), 0)->layout()->itemAt(0); XComboBox* mybox = (XComboBox*)test->widget(); QStringList split = mybox->itemData(mybox->currentIndex()).toString().split(":"); if ( tempVar.canConvert<QString>() ) { variantString = tempVar.toString(); filter = filter + tempPair.first + ":" + variantString + ":" + split[1] + "|"; } } const QMetaObject *metaobject = this->parent()->metaObject(); QString classname(metaobject->className()); XSqlQuery qry, qry2, qry3; qry.exec("SELECT current_user;"); if (qry.first()) username = qry.value("current_user").toString(); //check to see if filter name exists for this screen QString filter_query = "select filter_name " "from filter " "where filter_name=:name and filter_username=:username " " and filter_screen=:screen"; qry2.prepare(filter_query); qry2.bindValue(":name", filtersetname); qry2.bindValue(":username" , username); qry2.bindValue(":screen", classname); qry2.exec(); //if the filter name is found, update it if (qry2.first() && !qry2.isNull(0)) query = "update filter set filter_value=:value " "where filter_screen=:screen " " and filter_name=:name " " and filter_username=:username"; else query = "insert into filter (filter_screen, filter_name, filter_value, filter_username) " " values (:screen, :name, :value, :username) "; qry.prepare(query); qry.bindValue(":screen", classname); qry.bindValue(":value", filter); qry.bindValue(":username" , username); qry.bindValue(":name", filtersetname ); if (qry.exec()) { query = "select filter_id " "from filter " "where filter_name=:name " " and filter_username=:username " " and filter_screen=:screen"; qry3.prepare(query); qry3.bindValue(":screen", classname); qry3.bindValue(":username" , username); qry3.bindValue(":name", filtersetname ); qry3.exec(); if (qry3.first()) filter_id = qry.value("filter_id").toInt(); emit filterSetSaved(); } } setSavedFilters(); _filterList->setCurrentIndex(_filterList->findText(filtersetname)); }
void ParameterWidget::changeFilterObject(int index) { XComboBox *mybox = (XComboBox *)sender(); QStringList split = mybox->itemData(index).toString().split(":"); QString row = split.at(0); int type = split.at(1).toInt(); XSqlQuery qry; QWidget *widget = _filterGroup->findChild<QWidget *>("widget" + row); QWidget *button = _filterGroup->findChild<QToolButton *>("button" + row); QHBoxLayout *layout = _filterGroup->findChild<QHBoxLayout *>("widgetLayout1" + row);; QPair<QString, ParameterWidgetTypes> tempPair; DLineEdit *dLineEdit= new DLineEdit(_filterGroup); UsernameCluster *usernameCluster = new UsernameCluster(_filterGroup); CRMAcctCluster *crmacctCluster = new CRMAcctCluster(_filterGroup); QLineEdit *lineEdit = new QLineEdit(_filterGroup); XComboBox *xBox = new XComboBox(_filterGroup); ContactCluster *contactCluster = new ContactCluster(_filterGroup); if (widget && layout && button) delete widget; else return; switch (type) { case Date: delete usernameCluster; delete crmacctCluster; delete lineEdit; delete xBox; delete contactCluster; dLineEdit->setObjectName("widget" + row); layout->insertWidget(0, dLineEdit); connect(button, SIGNAL(clicked()), dLineEdit, SLOT( deleteLater() ) ); connect(dLineEdit, SIGNAL(newDate(QDate)), this, SLOT( storeFilterValue(QDate) ) ); break; case User: delete dLineEdit; delete crmacctCluster; delete lineEdit; delete xBox; delete contactCluster; usernameCluster->setObjectName("widget" + row); usernameCluster->setNameVisible(false); usernameCluster->setDescriptionVisible(false); usernameCluster->setLabel(""); layout->insertWidget(0, usernameCluster); connect(button, SIGNAL(clicked()), usernameCluster, SLOT( deleteLater() ) ); connect(usernameCluster, SIGNAL(newId(int)), this, SLOT( storeFilterValue(int) ) ); break; case Crmacct: delete dLineEdit; delete usernameCluster; delete lineEdit; delete xBox; delete contactCluster; crmacctCluster->setObjectName("widget" + row); crmacctCluster->setNameVisible(false); crmacctCluster->setDescriptionVisible(false); crmacctCluster->setLabel(""); layout->insertWidget(0, crmacctCluster); connect(button, SIGNAL(clicked()), crmacctCluster, SLOT( deleteLater() ) ); connect(crmacctCluster, SIGNAL(newId(int)), this, SLOT( storeFilterValue(int) ) ); break; case Contact: delete dLineEdit; delete usernameCluster; delete lineEdit; delete xBox; delete crmacctCluster; contactCluster->setObjectName("widget" + row); contactCluster->setDescriptionVisible(false); contactCluster->setLabel(""); layout->insertWidget(0, contactCluster); connect(button, SIGNAL(clicked()), contactCluster, SLOT( deleteLater() ) ); connect(contactCluster, SIGNAL(newId(int)), this, SLOT( storeFilterValue(int) ) ); break; case XComBox: delete dLineEdit; delete usernameCluster; delete lineEdit; delete crmacctCluster; delete contactCluster; xBox->setObjectName("widget" + row); xBox->setType(_comboTypes[mybox->currentText()]); if (_comboTypes[mybox->currentText()] == XComboBox::Adhoc) { qry.prepare( _comboQuery[mybox->currentText()] ); qry.exec(); xBox->populate(qry); } layout->insertWidget(0, xBox); connect(button, SIGNAL(clicked()), xBox, SLOT( deleteLater() ) ); connect(xBox, SIGNAL(newID(int)), this, SLOT( storeFilterValue(int) ) ); break; default: delete dLineEdit; delete usernameCluster; delete crmacctCluster; delete xBox; delete contactCluster; lineEdit->setObjectName("widget" + row); layout->insertWidget(0, lineEdit); connect(button, SIGNAL(clicked()), lineEdit, SLOT( deleteLater() ) ); connect(lineEdit, SIGNAL(editingFinished()), this, SLOT( storeFilterValue() ) ); break; } }