creditMemoItem::creditMemoItem(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
#ifndef Q_WS_MAC
_listPrices->setMaximumWidth(25);
#endif
connect(_discountFromSale, SIGNAL(lostFocus()), this, SLOT(sCalculateFromDiscount()));
//connect(_extendedPrice, SIGNAL(valueChanged()), this, SLOT(sLookupTax()));
connect(_item, SIGNAL(newId(int)), this, SLOT(sPopulateItemInfo()));
connect(_listPrices, SIGNAL(clicked()), this, SLOT(sListPrices()));
connect(_netUnitPrice, SIGNAL(valueChanged()), this, SLOT(sCalculateDiscountPrcnt()));
connect(_netUnitPrice, SIGNAL(valueChanged()), this, SLOT(sCalculateExtendedPrice()));
connect(_netUnitPrice, SIGNAL(idChanged(int)), this, SLOT(sPriceGroup()));
connect(_qtyToCredit, SIGNAL(textChanged(const QString&)), this, SLOT(sCalculateExtendedPrice()));
connect(_save, SIGNAL(clicked()), this, SLOT(sSave()));
connect(_taxCode, SIGNAL(newID(int)), this, SLOT(sLookupTax()));
connect(_taxLit, SIGNAL(leftClickedURL(const QString&)), this, SLOT(sTaxDetail()));
connect(_taxType, SIGNAL(newID(int)), this, SLOT(sLookupTaxCode()));
connect(_qtyUOM, SIGNAL(newID(int)), this, SLOT(sQtyUOMChanged()));
connect(_pricingUOM, SIGNAL(newID(int)), this, SLOT(sPriceUOMChanged()));
_mode = cNew;
_cmitemid = -1;
_cmheadid = -1;
_custid = -1;
_invoiceNumber = -1;
_priceRatio = 1.0;
_qtyShippedCache = 0.0;
_shiptoid = -1;
_taxauthid = -1;
_taxCache.clear();
_qtyinvuomratio = 1.0;
_priceinvuomratio = 1.0;
_invuomid = -1;
_qtyToCredit->setValidator(omfgThis->qtyVal());
_qtyReturned->setValidator(omfgThis->qtyVal());
_qtyShipped->setPrecision(omfgThis->qtyVal());
_discountFromList->setPrecision(omfgThis->percentVal());
_discountFromSale->setValidator(new QDoubleValidator(-9999, 100, 2, this));
_taxType->setEnabled(_privileges->check("OverrideTax"));
_taxCode->setEnabled(_privileges->check("OverrideTax"));
//If not multi-warehouse hide whs control
if (!_metrics->boolean("MultiWhs"))
{
_warehouseLit->hide();
_warehouse->hide();
}
adjustSize();
}
enum SetResponse creditMemoItem::set(const ParameterList &pParams)
{
XDialog::set(pParams);
QVariant param;
bool valid;
bool vrestrict = FALSE;
param = pParams.value("cmhead_id", &valid);
if (valid)
{
_cmheadid = param.toInt();
q.prepare("SELECT cmhead_cust_id, cmhead_shipto_id, "
" cmhead_number, COALESCE(cmhead_invcnumber, '-1') AS cmhead_invcnumber, "
" cmhead_docdate, cmhead_curr_id, "
" cmhead_taxzone_id, cmhead_rsncode_id "
"FROM cmhead "
"WHERE (cmhead_id=:cmhead_id);");
q.bindValue(":cmhead_id", _cmheadid);
q.exec();
if (q.first())
{
_custid = q.value("cmhead_cust_id").toInt();
_shiptoid = q.value("cmhead_shipto_id").toInt();
_orderNumber->setText(q.value("cmhead_number").toString());
_invoiceNumber = q.value("cmhead_invcnumber").toInt();
if ( (_invoiceNumber != -1) && (_metrics->boolean("RestrictCreditMemos")) )
vrestrict = TRUE;
_taxzoneid = q.value("cmhead_taxzone_id").toInt();
_tax->setId(q.value("cmhead_curr_id").toInt());
_tax->setEffective(q.value("cmhead_docdate").toDate());
_netUnitPrice->setId(q.value("cmhead_curr_id").toInt());
_netUnitPrice->setEffective(q.value("cmhead_docdate").toDate());
_rsnCode->setId(q.value("cmhead_rsncode_id").toInt());
}
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
}
param = pParams.value("cmitem_id", &valid);
if (valid)
{
_cmitemid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
q.prepare( "SELECT (COALESCE(MAX(cmitem_linenumber), 0) + 1) AS n_linenumber "
"FROM cmitem "
"WHERE (cmitem_cmhead_id=:cmhead_id);" );
q.bindValue(":cmhead_id", _cmheadid);
q.exec();
if (q.first())
_lineNumber->setText(q.value("n_linenumber").toString());
else if (q.lastError().type() == QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
connect(_discountFromSale, SIGNAL(editingFinished()), this, SLOT(sCalculateFromDiscount()));
connect(_item, SIGNAL(valid(bool)), _listPrices, SLOT(setEnabled(bool)));
_item->setFocus();
}
else if (param.toString() == "edit")
{
_mode = cEdit;
_item->setReadOnly(TRUE);
_warehouse->setEnabled(FALSE);
_qtyReturned->setFocus();
connect(_discountFromSale, SIGNAL(editingFinished()), this, SLOT(sCalculateFromDiscount()));
connect(_item, SIGNAL(valid(bool)), _listPrices, SLOT(setEnabled(bool)));
_save->setFocus();
}
else if (param.toString() == "view")
{
_mode = cView;
_item->setReadOnly(TRUE);
_warehouse->setEnabled(FALSE);
_qtyReturned->setEnabled(FALSE);
_qtyToCredit->setEnabled(FALSE);
_netUnitPrice->setEnabled(FALSE);
_discountFromSale->setEnabled(FALSE);
_comments->setReadOnly(TRUE);
_taxType->setEnabled(FALSE);
_rsnCode->setEnabled(FALSE);
_save->hide();
_close->setText(tr("&Close"));
_close->setFocus();
}
}
if (vrestrict)
_item->setQuery( QString( "SELECT DISTINCT item_id, item_number,"
" (item_descrip1 || ' ' || item_descrip2) AS itemdescrip,"
" item_upccode,"
" item_descrip1, item_descrip2,"
" item_active, item_config, item_type, uom_name, item_upccode "
"FROM invchead, invcitem, item, uom "
"WHERE ( (invcitem_invchead_id=invchead_id)"
" AND (invcitem_item_id=item_id)"
" AND (item_inv_uom_id=uom_id)"
" AND (invchead_invcnumber='%1') ) "
"ORDER BY item_number" )
.arg(_invoiceNumber) );
else
_item->setQuery( QString( "SELECT DISTINCT item_id, item_number,"
" (item_descrip1 || ' ' || item_descrip2) AS itemdescrip,"
" item_upccode,"
" item_descrip1, item_descrip2,"
" item_active, uom_name, item_type, item_config "
"FROM item, itemsite, uom "
"WHERE ( (itemsite_item_id=item_id)"
" AND (item_inv_uom_id=uom_id)"
" AND (itemsite_active)"
" AND (item_active)"
" AND (item_id IN (SELECT custitem FROM custitem(%1, %2) ) ) ) "
"ORDER BY item_number" )
.arg(_custid).arg(_shiptoid) );
return NoError;
}
enum SetResponse creditMemoItem::set(const ParameterList &pParams)
{
QVariant param;
bool valid;
bool restrict = FALSE;
param = pParams.value("cmhead_id", &valid);
if (valid)
{
_cmheadid = param.toInt();
q.prepare("SELECT cmhead_taxauth_id,"
" COALESCE(cmhead_tax_curr_id, cmhead_curr_id) AS taxcurr "
"FROM cmhead "
"WHERE (cmhead_id=:cmhead_id);");
q.bindValue(":cmhead_id", _cmheadid);
q.exec();
if (q.first())
{
_taxauthid = q.value("cmhead_taxauth_id").toInt();
_tax->setId(q.value("taxcurr").toInt());
}
else if (q.lastError().type() != QSqlError::None)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
}
param = pParams.value("rsncode_id", &valid);
if (valid)
_rsnCode->setId(param.toInt());
param = pParams.value("cust_id", &valid);
if (valid)
_custid = param.toInt();
param = pParams.value("shipto_id", &valid);
if (valid)
_shiptoid = param.toInt();
param = pParams.value("invoiceNumber", &valid);
if (valid)
{
if ( (param.toInt() == 0) || (param.toInt() == -1) )
_invoiceNumber = -1;
else
{
_invoiceNumber = param.toInt();
if (_metrics->boolean("RestrictCreditMemos"))
restrict = TRUE;
}
}
param = pParams.value("creditMemoNumber", &valid);
if (valid)
_orderNumber->setText(param.toString());
param = pParams.value("curr_id", &valid);
if (valid)
_netUnitPrice->setId(param.toInt());
param = pParams.value("effective", &valid);
if (valid)
_netUnitPrice->setEffective(param.toDate());
param = pParams.value("cmitem_id", &valid);
if (valid)
{
_cmitemid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
q.prepare( "SELECT (COALESCE(MAX(cmitem_linenumber), 0) + 1) AS n_linenumber "
"FROM cmitem "
"WHERE (cmitem_cmhead_id=:cmhead_id);" );
q.bindValue(":cmhead_id", _cmheadid);
q.exec();
if (q.first())
_lineNumber->setText(q.value("n_linenumber").toString());
else if (q.lastError().type() == QSqlError::None)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
connect(_discountFromSale, SIGNAL(lostFocus()), this, SLOT(sCalculateFromDiscount()));
connect(_item, SIGNAL(valid(bool)), _listPrices, SLOT(setEnabled(bool)));
_item->setFocus();
}
else if (param.toString() == "edit")
{
_mode = cEdit;
_item->setReadOnly(TRUE);
_warehouse->setEnabled(FALSE);
_qtyReturned->setFocus();
connect(_discountFromSale, SIGNAL(lostFocus()), this, SLOT(sCalculateFromDiscount()));
connect(_item, SIGNAL(valid(bool)), _listPrices, SLOT(setEnabled(bool)));
_save->setFocus();
}
else if (param.toString() == "view")
{
_mode = cView;
_item->setReadOnly(TRUE);
_warehouse->setEnabled(FALSE);
_qtyReturned->setEnabled(FALSE);
_qtyToCredit->setEnabled(FALSE);
_netUnitPrice->setEnabled(FALSE);
_discountFromSale->setEnabled(FALSE);
_comments->setReadOnly(TRUE);
_taxType->setEnabled(FALSE);
_taxCode->setEnabled(FALSE);
_rsnCode->setEnabled(FALSE);
_save->hide();
_close->setText(tr("&Close"));
_close->setFocus();
}
}
if (restrict)
_item->setQuery( QString( "SELECT DISTINCT item_id, item_number, item_descrip1, item_descrip2, item_active,"
" item_config, item_type, uom_name "
"FROM invchead, invcitem, item, uom "
"WHERE ( (invcitem_invchead_id=invchead_id)"
" AND (invcitem_item_id=item_id)"
" AND (item_inv_uom_id=uom_id)"
" AND (invchead_invcnumber=%1) ) "
"ORDER BY item_number;" )
.arg(_invoiceNumber) );
else
_item->setQuery( QString( "SELECT DISTINCT item_id, item_number, item_descrip1, item_descrip2,"
" uom_name, item_type, item_config "
"FROM item, itemsite, uom "
"WHERE ( (itemsite_item_id=item_id)"
" AND (item_inv_uom_id=uom_id)"
" AND (itemsite_active)"
" AND (item_active)"
" AND (customerCanPurchase(item_id, %1, %2)) ) "
"ORDER BY item_number;" )
.arg(_custid).arg(_shiptoid) );
return NoError;
}
enum SetResponse creditMemoItem::set(const ParameterList &pParams)
{
XSqlQuery creditet;
XDialog::set(pParams);
QVariant param;
bool valid;
bool vrestrict = false;
param = pParams.value("cmhead_id", &valid);
if (valid)
{
_cmheadid = param.toInt();
creditet.prepare("SELECT * "
"FROM cmhead "
"WHERE (cmhead_id=:cmhead_id);");
creditet.bindValue(":cmhead_id", _cmheadid);
creditet.exec();
if (creditet.first())
{
_custid = creditet.value("cmhead_cust_id").toInt();
_shiptoid = creditet.value("cmhead_shipto_id").toInt();
_orderNumber->setText(creditet.value("cmhead_number").toString());
if (! creditet.value("cmhead_invcnumber").toString().isEmpty())
_invoiceNumber = creditet.value("cmhead_invcnumber").toInt();
if ( (_invoiceNumber != -1) && (_metrics->boolean("RestrictCreditMemos")) )
vrestrict = true;
_taxzoneid = creditet.value("cmhead_taxzone_id").toInt();
_tax->setId(creditet.value("cmhead_curr_id").toInt());
_tax->setEffective(creditet.value("cmhead_docdate").toDate());
_netUnitPrice->setId(creditet.value("cmhead_curr_id").toInt());
_netUnitPrice->setEffective(creditet.value("cmhead_docdate").toDate());
_rsnCode->setId(creditet.value("cmhead_rsncode_id").toInt());
}
else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Credit Memo Information"),
creditet, __FILE__, __LINE__))
{
return UndefinedError;
}
}
param = pParams.value("cmitem_id", &valid);
if (valid)
{
_cmitemid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
creditet.prepare( "SELECT (COALESCE(MAX(cmitem_linenumber), 0) + 1) AS n_linenumber "
"FROM cmitem "
"WHERE (cmitem_cmhead_id=:cmhead_id);" );
creditet.bindValue(":cmhead_id", _cmheadid);
creditet.exec();
if (creditet.first())
_lineNumber->setText(creditet.value("n_linenumber").toString());
else if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Credit Memo Information"),
creditet, __FILE__, __LINE__))
{
return UndefinedError;
}
connect(_discountFromSale, SIGNAL(editingFinished()), this, SLOT(sCalculateFromDiscount()));
connect(_item, SIGNAL(valid(bool)), _listPrices, SLOT(setEnabled(bool)));
}
else if (param.toString() == "edit")
{
_mode = cEdit;
_item->setReadOnly(true);
_warehouse->setEnabled(false);
connect(_discountFromSale, SIGNAL(editingFinished()), this, SLOT(sCalculateFromDiscount()));
connect(_item, SIGNAL(valid(bool)), _listPrices, SLOT(setEnabled(bool)));
}
else if (param.toString() == "view")
{
_mode = cView;
_item->setReadOnly(true);
_warehouse->setEnabled(false);
_miscGroup->setEnabled(false);
_qtyReturned->setEnabled(false);
_qtyToCredit->setEnabled(false);
_netUnitPrice->setEnabled(false);
_discountFromSale->setEnabled(false);
_comments->setReadOnly(true);
_taxType->setEnabled(false);
_rsnCode->setEnabled(false);
_revAccnt->setEnabled(false);
_save->hide();
_close->setText(tr("&Close"));
}
}
if (vrestrict)
_item->setQuery( QString( "SELECT DISTINCT item_id, item_number,"
" (item_descrip1 || ' ' || item_descrip2) AS itemdescrip,"
" item_upccode,"
" item_descrip1, item_descrip2,"
" item_active, item_config, item_type, uom_name, item_upccode "
"FROM invchead, invcitem, item, uom "
"WHERE ( (invcitem_invchead_id=invchead_id)"
" AND (invcitem_item_id=item_id)"
" AND (item_inv_uom_id=uom_id)"
" AND (invchead_invcnumber='%1') ) "
"ORDER BY item_number" )
.arg(_invoiceNumber) );
else
_item->addExtraClause( QString("(item_id IN (SELECT custitem FROM custitem(%1, %2) ) )").arg(_custid).arg(_shiptoid) );
return NoError;
}
