void itemSource::populate()
{
XSqlQuery itemsrcQ;
itemsrcQ.prepare( "SELECT * "
"FROM itemsrc "
"WHERE (itemsrc_id=:itemsrc_id);" );
itemsrcQ.bindValue(":itemsrc_id", _itemsrcid);
itemsrcQ.exec();
if (itemsrcQ.first())
{
_item->setId(itemsrcQ.value("itemsrc_item_id").toInt());
_active->setChecked(itemsrcQ.value("itemsrc_active").toBool());
_default->setChecked(itemsrcQ.value("itemsrc_default").toBool());
_vendor->setId(itemsrcQ.value("itemsrc_vend_id").toInt());
_vendorItemNumber->setText(itemsrcQ.value("itemsrc_vend_item_number").toString());
_vendorItemDescrip->setText(itemsrcQ.value("itemsrc_vend_item_descrip").toString());
_vendorUOM->setText(itemsrcQ.value("itemsrc_vend_uom").toString());
_invVendorUOMRatio->setDouble(itemsrcQ.value("itemsrc_invvendoruomratio").toDouble());
_upcCode->setText(itemsrcQ.value("itemsrc_upccode"));
_minOrderQty->setDouble(itemsrcQ.value("itemsrc_minordqty").toDouble());
_multOrderQty->setDouble(itemsrcQ.value("itemsrc_multordqty").toDouble());
_vendorRanking->setValue(itemsrcQ.value("itemsrc_ranking").toInt());
_leadTime->setValue(itemsrcQ.value("itemsrc_leadtime").toInt());
_notes->setText(itemsrcQ.value("itemsrc_comments").toString());
_manufName->setCode(itemsrcQ.value("itemsrc_manuf_name").toString());
_manufItemNumber->setText(itemsrcQ.value("itemsrc_manuf_item_number").toString());
_manufItemDescrip->setText(itemsrcQ.value("itemsrc_manuf_item_descrip").toString());
sFillPriceList();
}
else if (itemsrcQ.lastError().type() != QSqlError::NoError)
{
systemError(this, itemsrcQ.lastError().databaseText(), __FILE__, __LINE__);
return;
}
}
void itemSource::sEdit()
{
ParameterList params;
params.append("mode", "edit");
params.append("itemsrcp_id", _itemsrcp->id());
itemSourcePrice newdlg(this, "", TRUE);
newdlg.set(params);
if (newdlg.exec() != XDialog::Rejected)
sFillPriceList();
}
void itemSource::populate()
{
XSqlQuery itemsrcQ;
itemsrcQ.prepare( "SELECT * FROM itemsrc WHERE (itemsrc_id=:itemsrc_id);" );
itemsrcQ.bindValue(":itemsrc_id", _itemsrcid);
itemsrcQ.exec();
if (itemsrcQ.first())
{
_item->setId(itemsrcQ.value("itemsrc_item_id").toInt());
_active->setChecked(itemsrcQ.value("itemsrc_active").toBool());
_default->setChecked(itemsrcQ.value("itemsrc_default").toBool());
_vendor->setId(itemsrcQ.value("itemsrc_vend_id").toInt());
_contract->setId(itemsrcQ.value("itemsrc_contrct_id").toInt());
_dates->setStartDate(itemsrcQ.value("itemsrc_effective").toDate());
_dates->setEndDate(itemsrcQ.value("itemsrc_expires").toDate());
_vendorItemNumber->setText(itemsrcQ.value("itemsrc_vend_item_number").toString());
_vendorItemDescrip->setText(itemsrcQ.value("itemsrc_vend_item_descrip").toString());
_vendorUOM->setCode(itemsrcQ.value("itemsrc_vend_uom").toString());
_invVendorUOMRatio->setDouble(itemsrcQ.value("itemsrc_invvendoruomratio").toDouble());
_upcCode->setText(itemsrcQ.value("itemsrc_upccode"));
_minOrderQty->setDouble(itemsrcQ.value("itemsrc_minordqty").toDouble());
_multOrderQty->setDouble(itemsrcQ.value("itemsrc_multordqty").toDouble());
_vendorRanking->setValue(itemsrcQ.value("itemsrc_ranking").toInt());
_leadTime->setValue(itemsrcQ.value("itemsrc_leadtime").toInt());
_notes->setText(itemsrcQ.value("itemsrc_comments").toString());
_manufName->setCode(itemsrcQ.value("itemsrc_manuf_name").toString());
_manufItemNumber->setText(itemsrcQ.value("itemsrc_manuf_item_number").toString());
_manufItemDescrip->setText(itemsrcQ.value("itemsrc_manuf_item_descrip").toString());
if (_metrics->value("Application") == "Standard")
{
if (_contract->id() > 0)
{
_contractedQty->setDouble(itemsrcQ.value("itemsrc_contrct_min").toDouble());
_contractedQty->setDisabled(false);
_contractedQtyLit->setDisabled(false);
}
else
{
_contractedQty->setDouble(0.00);
_contractedQty->setDisabled(true);
_contractedQtyLit->setDisabled(true);
}
}
sFillPriceList();
}
else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Item Source Information"),
itemsrcQ, __FILE__, __LINE__))
{
return;
}
}
void itemSource::sAdd()
{
ParameterList params;
params.append("mode", "new");
params.append("itemsrc_id", _itemsrcid);
params.append("curr_id", _vendorCurrency->id());
itemSourcePrice newdlg(this, "", TRUE);
newdlg.set(params);
if (newdlg.exec() != XDialog::Rejected)
sFillPriceList();
}
void itemSource::sAdd()
{
if (_mode == cNew || _mode == cCopy)
{
if (!sSave())
return;
}
ParameterList params;
params.append("mode", "new");
params.append("itemsrc_id", _itemsrcid);
params.append("curr_id", _vendorCurrency->id());
itemSourcePrice newdlg(this, "", true);
newdlg.set(params);
if (newdlg.exec() != XDialog::Rejected)
sFillPriceList();
}
void itemSource::sDelete()
{
// Make sure the user is sure
if ( QMessageBox::warning( this, tr("Delete Item Source Price"),
tr("Are you sure you want to delete this Item Source price?"),
tr("&Delete"), tr("&Cancel"), 0, 0, 1) == 0 )
{
q.prepare( "DELETE FROM itemsrcp "
"WHERE (itemsrcp_id=:itemsrcp_id);" );
q.bindValue(":itemsrcp_id", _itemsrcp->id());
q.exec();
if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
sFillPriceList();
}
}
void itemSource::sDelete()
{
XSqlQuery itemDelete;
// Make sure the user is sure
if ( QMessageBox::warning( this, tr("Delete Item Source Price"),
tr("Are you sure you want to delete this Item Source price?"),
tr("&Delete"), tr("&Cancel"), 0, 0, 1) == 0 )
{
itemDelete.prepare( "DELETE FROM itemsrcp "
"WHERE (itemsrcp_id=:itemsrcp_id);" );
itemDelete.bindValue(":itemsrcp_id", _itemsrcp->id());
itemDelete.exec();
if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Deleting Item Source Information"),
itemDelete, __FILE__, __LINE__))
{
return;
}
sFillPriceList();
}
}
enum SetResponse itemSource::set(const ParameterList &pParams)
{
XDialog::set(pParams);
QVariant param;
bool valid;
param = pParams.value("itemsrc_id", &valid);
if (valid)
{
_itemsrcid = param.toInt();
populate();
}
param = pParams.value("item_id", &valid);
if (valid)
{
_item->setId(param.toInt());
_item->setEnabled(FALSE);
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
_new = true;
q.exec("SELECT NEXTVAL('itemsrc_itemsrc_id_seq') AS _itemsrc_id;");
if (q.first())
_itemsrcid = q.value("_itemsrc_id").toInt();
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
_captive = true;
connect(_itemsrcp, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick()));
_item->setFocus();
}
else if (param.toString() == "edit")
{
_mode = cEdit;
connect(_itemsrcp, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick()));
_item->setReadOnly(TRUE);
_vendor->setEnabled(FALSE);
_save->setFocus();
}
else if (param.toString() == "view")
{
_mode = cView;
_item->setReadOnly(TRUE);
_active->setEnabled(FALSE);
_default->setEnabled(FALSE);
_vendor->setEnabled(FALSE);
_vendorItemNumber->setEnabled(FALSE);
_vendorItemDescrip->setEnabled(FALSE);
_vendorUOM->setEnabled(FALSE);
_invVendorUOMRatio->setEnabled(FALSE);
_vendorRanking->setEnabled(FALSE);
_minOrderQty->setEnabled(FALSE);
_multOrderQty->setEnabled(FALSE);
_leadTime->setEnabled(FALSE);
_notes->setEnabled(FALSE);
_upcCode->setEnabled(FALSE);
_add->setEnabled(FALSE);
_delete->setEnabled(FALSE);
_close->setText(tr("&Close"));
_save->hide();
_close->setFocus();
}
if (param.toString() == "copy")
{
_mode = cCopy;
_new = true;
_captive = true;
int itemsrcidold = _itemsrcid;
q.exec("SELECT NEXTVAL('itemsrc_itemsrc_id_seq') AS _itemsrc_id;");
if (q.first())
_itemsrcid = q.value("_itemsrc_id").toInt();
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
connect(_itemsrcp, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick()));
_item->setReadOnly(TRUE);
_vendorItemNumber->setText(_vendorItemNumber->text().prepend("Copy Of "));
if (sSave())
{
q.prepare("INSERT INTO itemsrcp ( "
"itemsrcp_itemsrc_id, itemsrcp_qtybreak, "
"itemsrcp_price, itemsrcp_updated, itemsrcp_curr_id) "
"SELECT :itemsrcid, itemsrcp_qtybreak, "
"itemsrcp_price, current_date, itemsrcp_curr_id "
"FROM itemsrcp "
"WHERE (itemsrcp_itemsrc_id=:itemsrcidold); ");
q.bindValue(":itemsrcid", _itemsrcid);
q.bindValue(":itemsrcidold", itemsrcidold);
q.exec();
sFillPriceList();
}
}
}
return NoError;
}
enum SetResponse itemSource::set(const ParameterList &pParams)
{
XSqlQuery itemet;
XDialog::set(pParams);
QVariant param;
bool valid;
param = pParams.value("itemsrc_id", &valid);
if (valid)
{
_itemsrcid = param.toInt();
_documents->setId(_itemsrcid);
populate();
}
param = pParams.value("item_id", &valid);
if (valid)
{
_item->setId(param.toInt());
_item->setEnabled(false);
}
param = pParams.value("vend_id", &valid);
if (valid)
{
_vendor->setId(param.toInt());
_vendor->setEnabled(false);
}
param = pParams.value("contrct_id", &valid);
if (valid)
{
_contract->setId(param.toInt());
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
_new = true;
itemet.exec("SELECT NEXTVAL('itemsrc_itemsrc_id_seq') AS _itemsrc_id;");
if (itemet.first())
{
_itemsrcid = itemet.value("_itemsrc_id").toInt();
_documents->setId(_itemsrcid);
}
else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Item Source Information"),
itemet, __FILE__, __LINE__))
{
return UndefinedError;
}
_captive = true;
connect(_itemsrcp, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick()));
}
else if (param.toString() == "edit")
{
_mode = cEdit;
connect(_itemsrcp, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick()));
_item->setReadOnly(true);
_vendor->setEnabled(false);
}
else if (param.toString() == "view")
{
_mode = cView;
_item->setReadOnly(true);
_active->setEnabled(false);
_default->setEnabled(false);
_vendor->setEnabled(false);
_dates->setEnabled(false);
_vendorItemNumber->setEnabled(false);
_vendorItemDescrip->setEnabled(false);
_vendorUOM->setEnabled(false);
_invVendorUOMRatio->setEnabled(false);
_vendorRanking->setEnabled(false);
_minOrderQty->setEnabled(false);
_multOrderQty->setEnabled(false);
_leadTime->setEnabled(false);
_notes->setEnabled(false);
_upcCode->setEnabled(false);
_documents->setReadOnly(true);
_add->setEnabled(false);
_delete->setEnabled(false);
_close->setText(tr("&Close"));
_save->hide();
}
if (param.toString() == "copy")
{
_mode = cCopy;
_new = true;
_captive = true;
int itemsrcidold = _itemsrcid;
itemet.exec("SELECT NEXTVAL('itemsrc_itemsrc_id_seq') AS _itemsrc_id;");
if (itemet.first())
_itemsrcid = itemet.value("_itemsrc_id").toInt();
else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Item Source Information"),
itemet, __FILE__, __LINE__))
{
return UndefinedError;
}
connect(_itemsrcp, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool)));
connect(_itemsrcp, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick()));
_item->setReadOnly(true);
_vendorItemNumber->setText(_vendorItemNumber->text().prepend("Copy Of "));
_dates->setStartDate(omfgThis->dbDate());
if (sSave())
{
itemet.prepare("INSERT INTO itemsrcp ( "
"itemsrcp_itemsrc_id, itemsrcp_qtybreak, itemsrcp_price, "
"itemsrcp_updated, itemsrcp_curr_id, itemsrcp_dropship, "
"itemsrcp_warehous_id, itemsrcp_type, itemsrcp_discntprcnt, "
"itemsrcp_fixedamtdiscount) "
"SELECT :itemsrcid, itemsrcp_qtybreak, itemsrcp_price, "
"current_date, itemsrcp_curr_id, itemsrcp_dropship, "
"itemsrcp_warehous_id, itemsrcp_type, itemsrcp_discntprcnt, "
"itemsrcp_fixedamtdiscount "
"FROM itemsrcp "
"WHERE (itemsrcp_itemsrc_id=:itemsrcidold); ");
itemet.bindValue(":itemsrcid", _itemsrcid);
itemet.bindValue(":itemsrcidold", itemsrcidold);
itemet.exec();
sFillPriceList();
}
}
}
if (_metrics->value("Application") != "Standard")
{
_contractedQtyLit->hide();
_contractedQty->hide();
}
return NoError;
}
