void itemAliasList::set(ParameterList &pParams)
{
QVariant param;
bool valid;
param = pParams.value("itemType", &valid);
if (valid)
{
_itemType = param.toUInt();
setWindowTitle(buildItemLineEditTitle(_itemType, tr("Item Aliases")));
}
else
{
_itemType = ItemLineEdit::cUndefined;
setWindowTitle(tr("Item Aliases"));
}
param = pParams.value("extraClauses", &valid);
if (valid)
_extraClauses = param.toStringList();
_showInactive->setChecked(FALSE);
_showInactive->setEnabled(!(_itemType & ItemLineEdit::cActive));
param = pParams.value("sql", &valid);
if (valid)
_sql = param.toString();
}
void itemSearch::set(ParameterList &pParams)
{
QVariant param;
bool valid;
param = pParams.value("item_id", &valid);
if (valid)
_itemid = param.toInt();
else
_itemid = -1;
param = pParams.value("sql", &valid);
if (valid)
{
_sql = param.toString();
_useQuery = TRUE;
}
else
_useQuery = FALSE;
param = pParams.value("itemType", &valid);
if (valid)
{
_itemType = param.toUInt();
setWindowTitle(buildItemLineEditTitle(_itemType, tr("Items")));
}
else
_itemType = ItemLineEdit::cUndefined;
param = pParams.value("extraClauses", &valid);
if (valid)
_extraClauses = param.toStringList();
_showInactive->setChecked(FALSE);
_showInactive->setEnabled(!(_itemType & ItemLineEdit::cActive));
param = pParams.value("caption", &valid);
if (valid)
setWindowTitle(param.toString());
param = pParams.value("search", &valid);
if (valid)
_search->setText(param.toString());
param = pParams.value("searchNumber", &valid);
if (valid)
_searchNumber->setChecked(true);
param = pParams.value("searchUpc", &valid);
if (valid)
_searchUpc->setChecked(true);
sFillList();
}
void itemList::set(ParameterList &pParams)
{
QVariant param;
bool valid;
param = pParams.value("item_id", &valid);
if (valid)
_itemid = param.toInt();
else
_itemid = -1;
param = pParams.value("sql", &valid);
if (valid)
{
_sql = param.toString();
_useQuery = TRUE;
}
else
_useQuery = FALSE;
param = pParams.value("itemType", &valid);
if (valid)
{
_itemType = param.toUInt();
setWindowTitle(buildItemLineEditTitle(_itemType, tr("Items")));
_showMake->setChecked(_itemType & ItemLineEdit::cGeneralManufactured);
_showBuy->setChecked(_itemType & ItemLineEdit::cGeneralPurchased);
}
else
{
_itemType = ItemLineEdit::cUndefined;
_showMake->hide();
_showBuy->hide();
}
param = pParams.value("extraClauses", &valid);
if (valid)
_extraClauses = param.toStringList();
_showInactive->setChecked(FALSE);
_showInactive->setEnabled(!(_itemType & ItemLineEdit::cActive));
if(!_showInactive->isEnabled())
_showInactive->hide();
param = pParams.value("caption", &valid);
if (valid)
setWindowTitle(param.toString());
sFillList();
}
void itemList::sFillList()
{
_listTab->clear();
if (_useQuery)
{
_listTab->populate(_sql, _itemid);
}
else
{
QString pre;
QString post;
if(_x_preferences && _x_preferences->boolean("ListNumericItemNumbersFirst"))
{
pre = "SELECT DISTINCT ON (toNumeric(item_number, 999999999999999), item_number) item_id, item_number,"
"(item_descrip1 || ' ' || item_descrip2) AS itemdescrip, item_upccode ";
post = "ORDER BY toNumeric(item_number, 999999999999999), item_number, item_upccode ";
}
else
{
pre = "SELECT DISTINCT item_id, item_number,"
"(item_descrip1 || ' ' || item_descrip2) AS itemdescrip, item_upccode ";
post = "ORDER BY item_number";
}
QStringList clauses;
clauses = _extraClauses;
if(!(_itemType & ItemLineEdit::cActive) && !_showInactive->isChecked())
clauses << "(item_active)";
if (_showMake->isChecked())
_itemType = (_itemType | ItemLineEdit::cGeneralManufactured);
else if (_itemType & ItemLineEdit::cGeneralManufactured)
_itemType = (_itemType ^ ItemLineEdit::cGeneralManufactured);
if (_showBuy->isChecked())
_itemType = (_itemType | ItemLineEdit::cGeneralPurchased);
else if (_itemType & ItemLineEdit::cGeneralPurchased)
_itemType = (_itemType ^ ItemLineEdit::cGeneralPurchased);
setWindowTitle(buildItemLineEditTitle(_itemType, tr("Items")));
_listTab->populate(buildItemLineEditQuery(pre, clauses, post, _itemType, false), _itemid);
}
}
