applyARCreditMemo::applyARCreditMemo(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
connect(_apply, SIGNAL(clicked()), this, SLOT(sApply()));
connect(_applyLineBalance, SIGNAL(clicked()), this, SLOT(sApplyLineBalance()));
connect(_applyToBalance, SIGNAL(clicked()), this, SLOT(sApplyBalance()));
connect(_available, SIGNAL(idChanged(int)), this, SLOT(sPriceGroup()));
connect(_clear, SIGNAL(clicked()), this, SLOT(sClear()));
connect(_close, SIGNAL(clicked()), this, SLOT(sClose()));
connect(_post, SIGNAL(clicked()), this, SLOT(sPost()));
connect(_searchDocNum, SIGNAL(textChanged(const QString&)), this, SLOT(sSearchDocNumChanged(const QString&)));
_captive = FALSE;
_aropen->addColumn(tr("Doc. Type"), _docTypeColumn, Qt::AlignCenter, true, "doctype");
_aropen->addColumn(tr("Doc. Number"), -1, Qt::AlignCenter, true, "aropen_docnumber");
_aropen->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter, true, "aropen_docdate");
_aropen->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "aropen_duedate");
_aropen->addColumn(tr("Open"), _moneyColumn, Qt::AlignRight, true, "balance");
_aropen->addColumn(tr("Currency"), _currencyColumn,Qt::AlignLeft, !omfgThis->singleCurrency(), "balance_curr");
_aropen->addColumn(tr("Applied"), _moneyColumn, Qt::AlignRight, true, "applied");
_aropen->addColumn(tr("Currency"), _currencyColumn,Qt::AlignLeft, !omfgThis->singleCurrency(), "applied_curr");
_aropen->addColumn(tr("All Pending"), _moneyColumn, Qt::AlignRight, true, "pending");
_aropen->addColumn(tr("Currency"), _currencyColumn,Qt::AlignLeft, !omfgThis->singleCurrency(), "balance_curr");
_cust->setReadOnly(TRUE);
if(_metrics->boolean("HideApplyToBalance"))
_applyToBalance->hide();
sPriceGroup();
}
applyAPCreditMemo::applyAPCreditMemo(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
connect(_apply, SIGNAL(clicked()), this, SLOT(sApply()));
connect(_applyToBalance, SIGNAL(clicked()), this, SLOT(sApplyBalance()));
connect(_available, SIGNAL(idChanged(int)), this, SLOT(sPriceGroup()));
connect(_clear, SIGNAL(clicked()), this, SLOT(sClear()));
connect(_close, SIGNAL(clicked()), this, SLOT(sClose()));
connect(_post, SIGNAL(clicked()), this, SLOT(sPost()));
_captive = FALSE;
_apopen->addColumn(tr("Doc. Type"), _docTypeColumn, Qt::AlignCenter,true, "doctype");
_apopen->addColumn(tr("Doc. Number"), -1, Qt::AlignCenter,true, "apopen_docnumber");
_apopen->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter,true, "apopen_docdate");
_apopen->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter,true, "apopen_duedate");
_apopen->addColumn(tr("Open"), _moneyColumn, Qt::AlignRight, true, "openamount");
_apopen->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "opencurrabbr");
_apopen->addColumn(tr("Applied"), _moneyColumn, Qt::AlignRight, true, "apcreditapply_amount");
_apopen->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "appliedcurrabbr");
if (omfgThis->singleCurrency())
{
_apopen->hideColumn("opencurrabbr");
_apopen->hideColumn("appliedcurrabbr");
}
_vend->setReadOnly(TRUE);
sPriceGroup();
}
selectPayment::selectPayment(QWidget* parent, const char* name, bool modal, Qt::WindowFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
connect(_discount, SIGNAL(clicked()), this, SLOT(sDiscount()));
connect(_save, SIGNAL(clicked()), this, SLOT(sSave()));
connect(_selected, SIGNAL(idChanged(int)), this, SLOT(sPriceGroup()));
_bankaccnt->setAllowNull(true);
_bankaccnt->setType(XComboBox::APBankAccounts);
_vendor->setReadOnly(true);
sPriceGroup();
}
applyAPCreditMemo::applyAPCreditMemo(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: XDialog(parent, name, modal, fl)
{
setupUi(this);
connect(_apply, SIGNAL(clicked()), this, SLOT(sApply()));
connect(_applyToBalance, SIGNAL(clicked()), this, SLOT(sApplyBalance()));
connect(_available, SIGNAL(idChanged(int)), this, SLOT(sPriceGroup()));
connect(_clear, SIGNAL(clicked()), this, SLOT(sClear()));
connect(_buttonBox, SIGNAL(accepted()), this, SLOT(sPost()));
connect(_buttonBox, SIGNAL(rejected()), this, SLOT(reject()));
_buttonBox->button(QDialogButtonBox::Save)->setText(tr("Post"));
_captive = FALSE;
_apopen->addColumn(tr("Doc. Type"), _docTypeColumn, Qt::AlignCenter,true, "doctype");
_apopen->addColumn(tr("Doc. Number"), -1, Qt::AlignCenter,true, "apopen_docnumber");
_apopen->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter,true, "apopen_docdate");
_apopen->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter,true, "apopen_duedate");
_apopen->addColumn(tr("Open"), _moneyColumn, Qt::AlignRight, true, "openamount");
_apopen->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "opencurrabbr");
_apopen->addColumn(tr("Applied"), _moneyColumn, Qt::AlignRight, true, "apcreditapply_amount");
_apopen->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "appliedcurrabbr");
if (_privileges->check("ApplyAPMemos"))
connect(_apopen, SIGNAL(valid(bool)), _apply, SLOT(setEnabled(bool)));
if (omfgThis->singleCurrency())
{
_apopen->hideColumn("opencurrabbr");
_apopen->hideColumn("appliedcurrabbr");
}
_vend->setReadOnly(TRUE);
sPriceGroup();
adjustSize();
}
enum SetResponse invoiceItem::set(const ParameterList &pParams)
{
QVariant param;
bool valid;
param = pParams.value("invchead_id", &valid);
if (valid)
{
_invcheadid = param.toInt();
q.prepare("SELECT taxauth_id, "
" COALESCE(taxauth_curr_id, invchead_curr_id) AS curr_id "
"FROM invchead, taxauth "
"WHERE ((invchead_taxauth_id=taxauth_id)"
" AND (invchead_id=:invchead_id));");
q.bindValue(":invchead_id", _invcheadid);
q.exec();
if (q.first())
{
_taxauthid = q.value("taxauth_id").toInt();
_tax->setId(q.value("curr_id").toInt());
}
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
}
param = pParams.value("invoiceNumber", &valid);
if (valid)
_invoiceNumber->setText(param.toString());
param = pParams.value("cust_id", &valid);
if (valid)
_custid = param.toInt();
param = pParams.value("cust_curr_id", &valid);
if (valid)
{
_price->setId(param.toInt());
sPriceGroup();
}
param = pParams.value("curr_date", &valid);
if (valid)
_price->setEffective(param.toDate());
param = pParams.value("invcitem_id", &valid);
if (valid)
{
_invcitemid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
q.prepare( "SELECT (COALESCE(MAX(invcitem_linenumber), 0) + 1) AS linenumber "
"FROM invcitem "
"WHERE (invcitem_invchead_id=:invchead_id);" );
q.bindValue(":invchead_id", _invcheadid);
q.exec();
if (q.first())
_lineNumber->setText(q.value("linenumber").toString());
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
connect(_billed, SIGNAL(lostFocus()), this, SLOT(sDeterminePrice()));
connect(_billed, SIGNAL(lostFocus()), this, SLOT(sCalculateExtendedPrice()));
connect(_price, SIGNAL(lostFocus()), this, SLOT(sCalculateExtendedPrice()));
}
else if (param.toString() == "edit")
{
_mode = cEdit;
connect(_billed, SIGNAL(lostFocus()), this, SLOT(sCalculateExtendedPrice()));
connect(_price, SIGNAL(lostFocus()), this, SLOT(sCalculateExtendedPrice()));
_save->setFocus();
}
else if (param.toString() == "view")
{
_mode = cView;
_itemTypeGroup->setEnabled(FALSE);
_custPn->setEnabled(FALSE);
_ordered->setEnabled(FALSE);
_billed->setEnabled(FALSE);
_price->setEnabled(FALSE);
_notes->setReadOnly(TRUE);
_taxtype->setEnabled(false);
_taxcode->setEnabled(false);
_save->hide();
_close->setText(tr("&Cancel"));
_close->setFocus();
}
}
return NoError;
}
enum SetResponse invoiceItem::set(const ParameterList &pParams)
{
XSqlQuery invoiceet;
XDialog::set(pParams);
QVariant param;
bool valid;
param = pParams.value("invchead_id", &valid);
if (valid)
{
_invcheadid = param.toInt();
invoiceet.prepare("SELECT * "
"FROM invchead "
"WHERE (invchead_id = :invchead_id);");
invoiceet.bindValue(":invchead_id", _invcheadid);
invoiceet.exec();
if (invoiceet.first())
{
_invoiceNumber->setText(invoiceet.value("invchead_invcnumber").toString());
_custid = invoiceet.value("invchead_cust_id").toInt();
_taxzoneid = invoiceet.value("invchead_taxzone_id").toInt();
_tax->setId(invoiceet.value("invchead_curr_id").toInt());
_price->setId(invoiceet.value("invchead_curr_id").toInt());
_price->setEffective(invoiceet.value("invchead_invcdate").toDate());
sPriceGroup();
}
else if (invoiceet.lastError().type() != QSqlError::NoError)
{
systemError(this, invoiceet.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
}
param = pParams.value("invcitem_id", &valid);
if (valid)
{
_invcitemid = param.toInt();
populate();
}
param = pParams.value("mode", &valid);
if (valid)
{
if (param.toString() == "new")
{
_mode = cNew;
invoiceet.exec("SELECT NEXTVAL('invcitem_invcitem_id_seq') AS invcitem_id;");
if (invoiceet.first())
_invcitemid = invoiceet.value("invcitem_id").toInt();
else if (invoiceet.lastError().type() != QSqlError::NoError)
{
systemError(this, invoiceet.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
invoiceet.prepare( "SELECT (COALESCE(MAX(invcitem_linenumber), 0) + 1) AS linenumber "
"FROM invcitem "
"WHERE (invcitem_invchead_id=:invchead_id);" );
invoiceet.bindValue(":invchead_id", _invcheadid);
invoiceet.exec();
if (invoiceet.first())
_lineNumber->setText(invoiceet.value("linenumber").toString());
else if (invoiceet.lastError().type() != QSqlError::NoError)
{
systemError(this, invoiceet.lastError().databaseText(), __FILE__, __LINE__);
return UndefinedError;
}
connect(_billed, SIGNAL(editingFinished()), this, SLOT(sDeterminePrice()));
connect(_billed, SIGNAL(editingFinished()), this, SLOT(sCalculateExtendedPrice()));
connect(_price, SIGNAL(editingFinished()), this, SLOT(sCalculateExtendedPrice()));
_item->setType(ItemLineEdit::cSold);
_salescat->setType(XComboBox::SalesCategoriesActive);
}
else if (param.toString() == "edit")
{
_mode = cEdit;
connect(_billed, SIGNAL(editingFinished()), this, SLOT(sDeterminePrice()));
connect(_billed, SIGNAL(editingFinished()), this, SLOT(sCalculateExtendedPrice()));
connect(_price, SIGNAL(editingFinished()), this, SLOT(sCalculateExtendedPrice()));
}
else if (param.toString() == "view")
{
_mode = cView;
_itemTypeGroup->setEnabled(FALSE);
_custPn->setEnabled(FALSE);
_ordered->setEnabled(FALSE);
_billed->setEnabled(FALSE);
_price->setEnabled(FALSE);
_notes->setReadOnly(TRUE);
_taxtype->setEnabled(false);
_altRevAccnt->setEnabled(false);
_qtyUOM->setEnabled(false);
_pricingUOM->setEnabled(false);
_save->hide();
_close->setText(tr("&Cancel"));
}
}
return NoError;
}
