void ItemLineEdit::sAlias()
{
ParameterList params;
if (queryUsed())
params.append("sql", _sql);
else
params.append("itemType", _type);
if (!_extraClauses.isEmpty())
params.append("extraClauses", _extraClauses);
itemAliasList newdlg(parentWidget(), "", TRUE);
newdlg.set(params);
int itemaliasid;
if ((itemaliasid = newdlg.exec()) != QDialog::Rejected)
{
XSqlQuery itemalias;
itemalias.prepare( "SELECT itemalias_number, itemalias_item_id "
"FROM itemalias "
"WHERE (itemalias_id=:itemalias_id);" );
itemalias.bindValue(":itemalias_id", itemaliasid);
itemalias.exec();
if (itemalias.first())
{
setId(itemalias.value("itemalias_item_id").toInt());
emit aliasChanged(itemalias.value("itemalias_number").toString());
focusNextPrevChild(TRUE);
}
}
}
void ItemLineEdit::sSearch(ParameterList params)
{
disconnect(this, SIGNAL(editingFinished()), this, SLOT(sParse()));
params.append("item_id", _id);
if (queryUsed())
params.append("sql", _sql);
else
params.append("itemType", _type);
if (!_extraClauses.isEmpty())
params.append("extraClauses", _extraClauses);
itemSearch* newdlg = searchFactory();
QString stripped = text().trimmed();
if(stripped.length())
{
XSqlQuery numQ;
numQ.prepare(_query + _numClause +
(_extraClause.isEmpty() || !_strict ? "" : " AND " + _extraClause) +
QString("ORDER BY %1;").arg(_numColName));
numQ.bindValue(":number", "^" + stripped);
numQ.exec();
if (numQ.first())
newdlg->setQuery(numQ);
}
newdlg->setSearchText(text());
int id;
if ((id = newdlg->exec()) != QDialog::Rejected)
setId(id);
connect(this, SIGNAL(editingFinished()), this, SLOT(sParse()));
}
void ItemLineEdit::sSearch()
{
ParameterList params;
params.append("item_id", _id);
if (queryUsed())
params.append("sql", _sql);
else
params.append("itemType", _type);
if (!_extraClauses.isEmpty())
params.append("extraClauses", _extraClauses);
itemSearch newdlg(parentWidget(), "", TRUE);
newdlg.set(params);
int id;
if ((id = newdlg.exec()) != QDialog::Rejected)
{
setId(id);
if (id != -1 && hasFocus())
focusNextPrevChild(TRUE);
}
}
void ItemLineEdit::sList()
{
disconnect(this, SIGNAL(editingFinished()), this, SLOT(sParse()));
ParameterList params;
params.append("item_id", _id);
if (queryUsed())
params.append("sql", _sql);
else
params.append("itemType", _defaultType);
if (!_extraClauses.isEmpty())
params.append("extraClauses", _extraClauses);
itemList* newdlg = listFactory();
newdlg->set(params);
int id;
if ((id = newdlg->exec())!= _id)
setId(id);
disconnect(this, SIGNAL(editingFinished()), this, SLOT(sParse()));
}
