printQuote::printQuote(QWidget* parent, const char* name, bool modal, Qt::WindowFlags fl)
: printSinglecopyDocument(parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("QT");
setReportKey("quhead_id");
_docinfoQueryString = "SELECT quhead_id AS docid, quhead_id,"
" quhead_number AS docnumber,"
" false AS printed,"
"<? if exists('reportname') ?>"
" <? value('reportname') ?>"
"<? else ?>"
" findCustomerForm(quhead_cust_id, 'Q')"
" <? endif ?> AS reportname"
" FROM quhead"
" WHERE (quhead_id=<? value('docid') ?>);" ;
connect(_quote, SIGNAL(newId(int)), this, SLOT(sHandleNewQuoteId()));
connect(_report, SIGNAL(newID(int)), this, SLOT(sHandleButtons()));
connect(this, SIGNAL(finishedWithAll()), this, SLOT(sFinishedWithAll()));
connect(this, SIGNAL(populated(XSqlQuery*)), this, SLOT(sPopulate(XSqlQuery*)));
}
printPurchaseOrder::printPurchaseOrder(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: printMulticopyDocument("POCopies", "POWatermark",
"POShowPrices", "",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("PO");
setReportKey("pohead_id");
_docinfoQueryString =
"SELECT pohead_id AS docid, pohead_id,"
" pohead_number AS docnumber,"
" pohead_printed AS printed,"
" false AS posted,"
" 'PurchaseOrder' AS reportname,"
" pohead_saved"
" FROM pohead"
" WHERE (pohead_id=<? value('docid') ?>);" ;
_markOnePrintedQry = "UPDATE pohead"
" SET pohead_printed=TRUE "
" WHERE (pohead_id=<? value('docid') ?>);" ;
connect(_po, SIGNAL(newId(int, QString)), this, SLOT(setId(int)));
connect(this, SIGNAL(docUpdated(int)), this, SLOT(sHandleDocUpdated(int)));
connect(this, SIGNAL(populated(XSqlQuery*)), this, SLOT(sHandlePopulated(XSqlQuery*)));
}
reprintCreditMemos::reprintCreditMemos(QWidget *parent,
const char *name,
bool modal,
Qt::WFlags fl)
: reprintMulticopyDocument("CreditMemoCopies", "CreditMemoWatermark",
"CreditMemoShowPrices", parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
list()->addColumn(tr("C/M #"), _orderColumn, Qt::AlignRight, true, "docnumber");
list()->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter,true, "cmhead_docdate");
list()->addColumn(tr("Cust. #"), -1, Qt::AlignLeft, true, "cust_number");
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name");
list()->addColumn(tr("Report"), -1, Qt::AlignLeft, false, "reportname");
_docListQueryString = "SELECT cmhead_id, cust_id,"
" cmhead_number AS docnumber, cmhead_docdate,"
" cust_number, cust_name,"
" findCustomerForm(cust_id, 'C') AS reportname"
" FROM cmhead"
" JOIN custinfo ON (cmhead_cust_id=cust_id)"
" WHERE checkCreditMemoSitePrivs(cmhead_id)"
" ORDER BY cmhead_docdate DESC;" ;
setDoctype("CM");
setReportKey("cmhead_id");
sPopulate();
}
reprintInvoices::reprintInvoices(QWidget *parent,
const char *name,
bool modal,
Qt::WFlags fl)
: reprintMulticopyDocument("InvoiceCopies", "InvoiceWatermark",
"InvoiceShowPrices",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
list()->addColumn(tr("Invoice #"), _orderColumn, Qt::AlignRight, true, "docnumber");
list()->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter,true, "invchead_invcdate");
list()->addColumn(tr("Cust. #"), -1, Qt::AlignLeft, true, "cust_number");
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name");
list()->addColumn(tr("Total Amount"),_bigMoneyColumn, Qt::AlignRight, true, "extprice" );
list()->addColumn(tr("Balance"), _bigMoneyColumn, Qt::AlignRight, true, "balance" );
list()->addColumn(tr("Report"), -1, Qt::AlignLeft, false,"reportname");
QString errmsg;
bool ok = false;
MetaSQLQuery mql = MQLUtil::mqlLoad("invoices", "detail", errmsg, &ok);
if (! ok)
ErrorReporter::error(QtCriticalMsg, this, tr("Error Getting Invoices"),
errmsg, __FILE__, __LINE__);
setDoctype("IN");
setReportKey("invchead_id");
_docListQueryString = mql.getSource();
}
printPoForm::printPoForm(QWidget* parent, const char* name, bool modal, Qt::WFlags fl)
: printSinglecopyDocument(parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("PO");
setReportKey("pohead_id");
_docinfoQueryString = "SELECT pohead_id AS docid, pohead_id,"
" pohead_number AS docnumber,"
" pohead_printed AS printed,"
"<? if exists('reportname') ?>"
" (SELECT form_report_name"
" FROM form"
" WHERE ((form_name=<? value('reportname') ?>)"
" AND (form_key='PO')))"
"<? else ?>"
" COALESCE((SELECT MIN(form_report_name)"
" FROM form WHERE (form_key='PO')),"
" 'PurchaseOrder')"
"<? endif ?> AS reportname"
" FROM pohead"
" WHERE (pohead_id=<? value('docid') ?>);" ;
_report->populate( "SELECT form_id, form_name, form_name "
"FROM form "
"WHERE (form_key='PO') "
"ORDER BY form_name;" );
connect(_po, SIGNAL(newId(int, QString)), this, SLOT(sHandleNewOrderId()));
connect(_report, SIGNAL(newID(int)), this, SLOT(sHandleButtons()));
connect(this, SIGNAL(finishedWithAll()), this, SLOT(sFinishedWithAll()));
connect(this, SIGNAL(populated(XSqlQuery*)), this, SLOT(sPopulate(XSqlQuery*)));
}
printInvoices::printInvoices(QWidget *parent, const char *name, bool modal, Qt::WFlags fl)
: printMulticopyDocument("InvoiceCopies", "InvoiceWatermark",
"InvoiceShowPrices", "PostMiscInvoices",
parent, name, modal, fl)
{
setupUi(optionsWidget());
setWindowTitle(optionsWidget()->windowTitle());
setDoctype("IN");
setReportKey("invchead_id");
_distributeInventory = true;
_shipvia->populate( "SELECT MIN(invchead_id), invchead_shipvia "
" FROM invchead "
" WHERE ( (NOT invchead_printed)"
" AND (NOT invchead_posted) )"
" GROUP BY invchead_shipvia"
" ORDER BY invchead_shipvia;" );
QString errmsg;
bool ok = false;
MetaSQLQuery mql = MQLUtil::mqlLoad("invoices", "print", errmsg, &ok);
if (ok)
_docinfoQueryString = mql.getSource();
else
ErrorReporter::error(QtCriticalMsg, this, tr("Getting Invoices to Print"),
errmsg, __FILE__, __LINE__);
_markAllPrintedQry = "UPDATE invchead"
" SET invchead_printed=TRUE "
" WHERE invchead_id IN ("
"<? foreach('printedDocs') ?>"
" <? if not isfirst('printedDocs') ?>, <? endif ?>"
" <? value('printedDocs') ?>"
"<? endforeach ?>"
");" ;
_postFunction = "postInvoice";
_postQuery = "SELECT postInvoice(<? value('docid') ?>) AS result;" ;
_askBeforePostingQry = "SELECT invoiceTotal(<? value('docid') ?>) = 0 AS ask;" ;
_askBeforePostingMsg = tr("<p>Invoice %1 has a total value of 0.<br/>"
"Would you like to post it anyway?</p>");
_errCheckBeforePostingQry =
"SELECT EXISTS(SELECT *"
" FROM curr_rate, invchead "
" WHERE ((curr_id=invchead_curr_id)"
" AND (invchead_invcdate BETWEEN curr_effective AND curr_expires)"
" AND (invchead_id=<? value('docid') ?>))) AS ok;" ;
_errCheckBeforePostingMsg =
tr("Could not post Invoice %1 because of a missing exchange rate.");
connect(this, SIGNAL(aboutToStart(XSqlQuery*)), this, SLOT(sHandleAboutToStart(XSqlQuery*)));
connect(this, SIGNAL(finishedWithAll()), this, SLOT(sHandleFinishedWithAll()));
}
dspSubstituteAvailabilityByItem::dspSubstituteAvailabilityByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspSubstituteAvailabilityByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Substitute Availability by Root Item"));
setListLabel(tr("Substitute Availability"));
setReportName("SubstituteAvailabilityByRootItem");
setMetaSQLOptions("substituteAvailability", "detail");
setUseAltId(true);
_showByGroupInt = new QButtonGroup(this);
_showByGroupInt->addButton(_leadTime);
_showByGroupInt->addButton(_byDays);
_showByGroupInt->addButton(_byDate);
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" );
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number" );
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "itemdescrip" );
list()->addColumn(tr("LT"), _whsColumn, Qt::AlignCenter, true, "leadtime" );
list()->addColumn(tr("QOH"), _qtyColumn, Qt::AlignRight, true, "qtyonhand" );
list()->addColumn(tr("Allocated"), _qtyColumn, Qt::AlignRight, true, "allocated" );
list()->addColumn(tr("On Order"), _qtyColumn, Qt::AlignRight, true, "ordered" );
list()->addColumn(tr("Reorder Lvl."), _qtyColumn, Qt::AlignRight, true, "reorderlevel" );
list()->addColumn(tr("Available"), _qtyColumn, Qt::AlignRight, true, "available" );
}
dspInventoryLocator::dspInventoryLocator(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspInventoryLocator", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Location/Lot/Serial # Detail"));
setListLabel(tr("Locations"));
setReportName("LocationLotSerialNumberDetail");
setMetaSQLOptions("inventoryLocator", "detail");
setUseAltId(true);
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter,true, "warehous_code");
list()->addColumn(tr("Location"), 200, Qt::AlignLeft, true, "locationname");
list()->addColumn(tr("Netable"), _orderColumn, Qt::AlignCenter,true, "netable");
list()->addColumn(tr("Usable"), _orderColumn, Qt::AlignCenter,true, "usable");
list()->addColumn(tr("Lot/Serial #"), -1, Qt::AlignLeft, true, "lotserial");
list()->addColumn(tr("Expiration"),_dateColumn, Qt::AlignCenter,true, "expiration");
list()->addColumn(tr("Warranty"), _dateColumn, Qt::AlignCenter,true, "warranty");
list()->addColumn(tr("Qty."), _qtyColumn, Qt::AlignRight, true, "qoh");
ParameterWidget *pw = parameterWidget();
pw->append(tr("Site"), "site", ParameterWidget::Site);
pw->append(tr("Location"), "_location_name", ParameterWidget::Text);
pw->append(tr("Lot/Serial"), "lot_serial", ParameterWidget::Text);
setupCharacteristics("LS");
setParameterWidgetVisible(true);
}
dspIndentedWhereUsed::dspIndentedWhereUsed(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspIndentedWhereUsed", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Indented Where Used"));
setListLabel(tr("Bill of Materials Items"));
setReportName("IndentedWhereUsed");
setMetaSQLOptions("whereUsed", "detail");
setUseAltId(true);
_worksetid = 0;
if (_metrics->boolean("AllowInactiveBomItems"))
_item->setType(ItemLineEdit::cGeneralComponents);
else
_item->setType(ItemLineEdit::cGeneralComponents | ItemLineEdit::cActive);
list()->setRootIsDecorated(true);
list()->addColumn(tr("Seq. #"), 80, Qt::AlignRight, true, "bomwork_seqnumber");
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number");
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "descrip");
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter,true, "uom_name");
list()->addColumn(tr("Fxd. Qty."), _qtyColumn, Qt::AlignRight, true, "bomwork_qtyfxd");
list()->addColumn(tr("Qty. Per"), _qtyColumn, Qt::AlignRight, true, "bomwork_qtyper");
list()->addColumn(tr("Scrap %"), _prcntColumn, Qt::AlignRight, true, "bomwork_scrap");
list()->addColumn(tr("Effective"), _dateColumn, Qt::AlignCenter,true, "bomwork_effective");
list()->addColumn(tr("Expires"), _dateColumn, Qt::AlignCenter,true, "bomwork_expires");
_item->setFocus();
}
dspBacklogByItem::dspBacklogByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspBacklogByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Backlog by Item"));
setListLabel(tr("Backlog"));
setReportName("BacklogByItemNumber");
setMetaSQLOptions("salesOrderItems", "detail");
setUseAltId(true);
connect(_showPrices, SIGNAL(toggled(bool)), this, SLOT(sHandlePrices(bool)));
_item->setType(ItemLineEdit::cSold);
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("S/O #"), _orderColumn, Qt::AlignLeft, true, "cohead_number");
list()->addColumn(tr("#"), _seqColumn, Qt::AlignCenter,true, "coitem_linenumber");
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "item_number");
list()->addColumn(tr("Ordered"), _dateColumn, Qt::AlignCenter,true, "cohead_orderdate");
list()->addColumn(tr("Scheduled"),_dateColumn, Qt::AlignCenter,true, "coitem_scheddate");
list()->addColumn(tr("Qty. UOM"), _qtyColumn, Qt::AlignRight, true, "uom_name");
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyord");
list()->addColumn(tr("Shipped"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyshipped");
list()->addColumn(tr("Balance"), _qtyColumn, Qt::AlignRight, true, "qtybalance");
if (_privileges->check("ViewCustomerPrices") || _privileges->check("MaintainCustomerPrices"))
list()->addColumn(tr("Ext. Price"), _bigMoneyColumn, Qt::AlignRight, true, "baseextpricebalance");
_showPrices->setEnabled(_privileges->check("ViewCustomerPrices") || _privileges->check("MaintainCustomerPrices"));
if (! _showPrices->isChecked())
list()->hideColumn("baseextpricebalance");
_item->setFocus();
}
dspPricesByItem::dspPricesByItem(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspPricesByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Prices by Item"));
setListLabel(tr("Prices"));
setReportName("PricesByItem");
setMetaSQLOptions("prices", "detail");
setUseAltId(true);
connect(_showCosts, SIGNAL(toggled(bool)), this, SLOT(sHandleCosts(bool)));
_item->setType(ItemLineEdit::cSold);
list()->addColumn(tr("Schedule"), _itemColumn, Qt::AlignLeft, true, "schedulename" );
list()->addColumn(tr("Source"), _itemColumn, Qt::AlignLeft, true, "type" );
list()->addColumn(tr("Customer/Customer Type"), -1, Qt::AlignLeft, true, "typename" );
list()->addColumn(tr("Qty. Break"), _qtyColumn, Qt::AlignRight, true, "f_qtybreak" );
list()->addColumn(tr("Price"), _priceColumn, Qt::AlignRight, true, "price" );
list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "currConcat" );
list()->addColumn(tr("Cost"), _costColumn, Qt::AlignRight, true, "f_cost" );
list()->addColumn(tr("Margin"), _prcntColumn, Qt::AlignRight, true, "f_margin" );
if (omfgThis->singleCurrency())
list()->hideColumn(CURR_COL);
sHandleCosts(_showCosts->isChecked());
}
dspCountTagsBase::dspCountTagsBase(QWidget* parent, const char* name, Qt::WFlags fl)
: display(parent, name, fl)
{
setupUi(optionsWidget());
setListLabel(tr("Count Tags"));
setMetaSQLOptions("countTags", "detail");
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("Tag #"), -1, Qt::AlignLeft, true, "invcnt_tagnumber");
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter,true, "warehous_code");
list()->addColumn(tr("Item"), _itemColumn, Qt::AlignLeft, true, "item_number");
list()->addColumn(tr("Created"), _dateColumn, Qt::AlignCenter,true, "invcnt_tagdate");
list()->addColumn(tr("Created By"), _dateColumn, Qt::AlignCenter,true, "creator");
list()->addColumn(tr("Entered"), _dateColumn, Qt::AlignCenter,true, "invcnt_cntdate");
list()->addColumn(tr("Entered By"), _dateColumn, Qt::AlignCenter,true, "counter");
list()->addColumn(tr("Posted"), _dateColumn, Qt::AlignCenter,true, "invcnt_postdate");
list()->addColumn(tr("Posted By"), _dateColumn, Qt::AlignCenter,true, "poster");
list()->addColumn(tr("QOH Before"), _qtyColumn, Qt::AlignRight, true, "qohbefore");
list()->addColumn(tr("Qty. Counted"),_qtyColumn, Qt::AlignRight, true, "invcnt_qoh_after");
list()->addColumn(tr("Variance"), _qtyColumn, Qt::AlignRight, true, "variance");
list()->addColumn(tr("%"), _prcntColumn, Qt::AlignRight, true, "percent");
if (_preferences->boolean("XCheckBox/forgetful"))
_showUnposted->setChecked(true);
sFillList();
}
dspPoItemsByVendor::dspPoItemsByVendor(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPoItemsByVendor", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Purchase Order Items by Vendor"));
setListLabel(tr("Purchase Order Items"));
setReportName("POLineItemsByVendor");
setMetaSQLOptions("poItems", "detail");
setUseAltId(true);
connect(_vendor, SIGNAL(updated()), this, SLOT(sPopulatePo()));
connect(_searchFor, SIGNAL(textChanged(const QString&)), this, SLOT(sSearch(const QString&)));
connect(_next, SIGNAL(clicked()), this, SLOT(sSearchNext()));
_agent->setText(omfgThis->username());
list()->addColumn(tr("P/O #"), _orderColumn, Qt::AlignRight, true, "pohead_number" );
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" );
list()->addColumn(tr("Status"), 0, Qt::AlignCenter, true, "poitem_status" );
list()->addColumn(tr("Status"), _dateColumn, Qt::AlignCenter, true, "f_poitem_status" );
list()->addColumn(tr("Vendor"), _itemColumn, Qt::AlignLeft, true, "vend_name" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "poitem_duedate" );
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "itemnumber" );
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "itemdescrip" );
list()->addColumn(tr("Vend. Item #"), _itemColumn, Qt::AlignLeft, true, "poitem_vend_item_number");
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter, true, "itemuom" );
list()->addColumn(tr("Vend. UOM"), _uomColumn, Qt::AlignCenter, true, "poitem_vend_uom" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "poitem_qty_ordered" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "poitem_qty_received" );
list()->addColumn(tr("Returned"), _qtyColumn, Qt::AlignRight, true, "poitem_qty_returned" );
}
dspVoucherRegister::dspVoucherRegister(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspVoucherRegister", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Voucher Register"));
setListLabel(tr("Vouchers"));
setReportName("VoucherRegister");
setMetaSQLOptions("voucherRegister", "detail");
connect(_selectedAccount, SIGNAL(toggled(bool)), _account, SLOT(setEnabled(bool)));
connect(_showUsername, SIGNAL(toggled(bool)), this, SLOT(sShowUsername(bool)));
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("Date"), _dateColumn, Qt::AlignCenter, true, "gltrans_date" );
list()->addColumn(tr("Vend. #"), _orderColumn, Qt::AlignRight, true, "vend_number" );
list()->addColumn(tr("Vend. Name"), _itemColumn, Qt::AlignLeft, true, "vend_name" );
list()->addColumn(tr("Doc. Type"), _docTypeColumn, Qt::AlignCenter, true, "gltrans_doctype" );
list()->addColumn(tr("Doc. #"), _orderColumn, Qt::AlignCenter, true, "gltrans_docnumber" );
list()->addColumn(tr("Reference"), -1, Qt::AlignLeft, true, "reference" );
list()->addColumn(tr("Account"), _itemColumn, Qt::AlignLeft, true, "account" );
list()->addColumn(tr("Debit"), _moneyColumn, Qt::AlignRight, true, "debit" );
list()->addColumn(tr("Credit"), _moneyColumn, Qt::AlignRight, true, "credit" );
list()->addColumn(tr("Username"), _userColumn, Qt::AlignLeft, true, "gltrans_username" );
sShowUsername(_showUsername->isChecked());
}
dspWoScheduleByItem::dspWoScheduleByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspWoScheduleByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Work Order Schedule by Item"));
setListLabel(tr("Work Orders"));
setReportName("WOScheduleByParameterList");
setMetaSQLOptions("workOrderSchedule", "detail");
setUseAltId(true);
setAutoUpdateEnabled(true);
_item->setType(ItemLineEdit::cGeneralManufactured | ItemLineEdit::cGeneralPurchased);
_item->setDefaultType(ItemLineEdit::cGeneralManufactured);
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("W/O #"), -1, Qt::AlignLeft, true, "wonumber" );
list()->addColumn(tr("Status"), _statusColumn, Qt::AlignCenter, true, "wo_status" );
list()->addColumn(tr("Pri."), _statusColumn, Qt::AlignCenter, true, "wo_priority" );
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "wo_qtyord" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "wo_qtyrcv" );
list()->addColumn(tr("Start Date"), _dateColumn, Qt::AlignCenter, true, "wo_startdate" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "wo_duedate" );
list()->addColumn(tr("User"), -1, Qt::AlignLeft, true, "wo_username" );
connect(omfgThis, SIGNAL(workOrdersUpdated(int, bool)), this, SLOT(sFillList()));
_item->setFocus();
}
dspCashReceipts::dspCashReceipts(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspCashReceipts", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Cash Receipts"));
setListLabel(tr("Cash Receipts"));
setReportName("CashReceipts");
setMetaSQLOptions("cashReceipts", "detail");
setNewVisible(true);
setUseAltId(true);
connect(_applications, SIGNAL(toggled(bool)), list(), SLOT(clear()));
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), TRUE);
_dates->setStartDate(QDate().currentDate().addDays(-90));
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), TRUE);
list()->addColumn(tr("Number"), _orderColumn, Qt::AlignLeft, true, "cashrcpt_number" );
list()->addColumn(tr("Source"), _itemColumn, Qt::AlignLeft, true, "source" );
list()->addColumn(tr("Cust. #"), _orderColumn, Qt::AlignLeft, true, "cust_number" );
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name" );
list()->addColumn(tr("Posted"), _ynColumn, Qt::AlignCenter, true, "posted" );
list()->addColumn(tr("Voided"), _ynColumn, Qt::AlignCenter, true, "voided" );
list()->addColumn(tr("Date"), _dateColumn, Qt::AlignCenter, true, "postdate" );
list()->addColumn(tr("Apply-To"), -1, Qt::AlignLeft, true, "target" );
list()->addColumn(tr("Amount"), _moneyColumn, Qt::AlignRight, true, "applied" );
list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "currAbbr" );
list()->addColumn(tr("Base Amount"), _moneyColumn, Qt::AlignRight, true, "base_applied" );
newAction()->setEnabled(_privileges->check("MaintainCashReceipts"));
}
dspPoItemsByItem::dspPoItemsByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPoItemsByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Purchase Order Items by Item"));
setListLabel(tr("Purchase Order Items"));
setReportName("POLineItemsByItem");
setMetaSQLOptions("poItems", "detail");
setUseAltId(true);
_item->setType(ItemLineEdit::cGeneralPurchased | ItemLineEdit::cGeneralManufactured);
_item->setDefaultType(ItemLineEdit::cGeneralPurchased);
_agent->setText(omfgThis->username());
list()->addColumn(tr("P/O #"), _orderColumn, Qt::AlignRight, true, "pohead_number" );
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" );
list()->addColumn(tr("Status"), 0, Qt::AlignCenter, true, "poitem_status" );
list()->addColumn(tr("Status"), _dateColumn, Qt::AlignCenter, true, "f_poitem_status" );
list()->addColumn(tr("Vendor"), -1, Qt::AlignLeft, true, "vend_name" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "poitem_duedate" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "poitem_qty_ordered" );
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter, true, "itemuom" );
list()->addColumn(tr("Vend. UOM"), _uomColumn, Qt::AlignCenter, true, "poitem_vend_uom" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "poitem_qty_received" );
list()->addColumn(tr("Returned"), _qtyColumn, Qt::AlignRight, true, "poitem_qty_returned" );
}
dspARApplications::dspARApplications(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspARApplications", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("A/R Applications"));
setListLabel(tr("A/R Applications"));
setReportName("ARApplications");
setMetaSQLOptions("arApplications", "detail");
_cust->setType(CLineEdit::ActiveCustomers);
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("Cust. #"), _orderColumn, Qt::AlignCenter, true, "cust_number" );
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name" );
list()->addColumn(tr("Post Date"), _dateColumn, Qt::AlignCenter, true, "arapply_postdate" );
list()->addColumn(tr("Dist. Date"), _dateColumn, Qt::AlignCenter, true, "arapply_distdate" );
list()->addColumn(tr("Source Doc Type"), 10, Qt::AlignCenter, true, "arapply_source_doctype" );
list()->addColumn(tr("Source"), _itemColumn, Qt::AlignCenter, true, "doctype" );
list()->addColumn(tr("Doc #"), _orderColumn, Qt::AlignCenter, true, "source" );
list()->addColumn(tr("Apply-To Doc Type"), 10, Qt::AlignCenter, true, "arapply_target_doctype" );
list()->addColumn(tr("Apply-To"), _itemColumn, Qt::AlignCenter, true, "targetdoctype" );
list()->addColumn(tr("Doc #"), _orderColumn, Qt::AlignCenter, true, "target" );
list()->addColumn(tr("Amount"), _moneyColumn, Qt::AlignRight, true, "arapply_applied" );
list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "currAbbr" );
list()->addColumn(tr("Base Amount"), _bigMoneyColumn, Qt::AlignRight, true, "base_applied" );
list()->hideColumn(4);
list()->hideColumn(7);
}
dspPoDeliveryDateVariancesByVendor::dspPoDeliveryDateVariancesByVendor(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPoDeliveryDateVariancesByVendor", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Purchase Order Delivery Date Variances by Vendor"));
setListLabel(tr("Purchase Item Receipts"));
setReportName("DeliveryDateVariancesByVendor");
setMetaSQLOptions("poDeliveryDateVariances", "detail");
connect(_selectedPurchasingAgent, SIGNAL(toggled(bool)), _agent, SLOT(setEnabled(bool)));
_agent->setType(XComboBox::Agent);
_agent->setText(omfgThis->username());
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("P/O #"), _orderColumn, Qt::AlignRight, true, "porecv_ponumber" );
list()->addColumn(tr("Vendor"), _orderColumn, Qt::AlignLeft, true, "vend_name" );
list()->addColumn(tr("Date"), _dateColumn, Qt::AlignCenter, true, "receivedate" );
list()->addColumn(tr("Vend. Item #"), _itemColumn, Qt::AlignLeft, true, "venditemnumber" );
list()->addColumn(tr("Vendor Description"), -1, Qt::AlignLeft, true, "venditemdescrip" );
list()->addColumn(tr("Qty."), _qtyColumn, Qt::AlignRight, true, "porecv_qty" );
list()->addColumn(tr("Req. Due"), _dateColumn, Qt::AlignCenter, true, "release_duedate" );
list()->addColumn(tr("Req. Leadtime"), _dateColumn, Qt::AlignRight, true, "req_leadtime" );
list()->addColumn(tr("Agrd. Due"), _dateColumn, Qt::AlignCenter, true, "argd_duedate" );
list()->addColumn(tr("Agrd. Leadtime"), _dateColumn, Qt::AlignRight, true, "agrd_leadtime" );
list()->addColumn(tr("Recv. Date"), _dateColumn, Qt::AlignCenter, true, "receivedate" );
list()->addColumn(tr("Real Leadtime"), _dateColumn, Qt::AlignRight, true, "real_leadtime" );
list()->addColumn(tr("Req. Diff"), _dateColumn, Qt::AlignRight, true, "req_diff" );
list()->addColumn(tr("Agrd. Diff"), _dateColumn, Qt::AlignRight, true, "argd_diff" );
}
dspCustomerARHistory::dspCustomerARHistory(QWidget* parent, const char* name, Qt::WindowFlags fl)
: display(parent, "dspCustomerARHistory", fl)
{
Q_UNUSED(name);
setupUi(optionsWidget());
setWindowTitle(tr("Customer History"));
setListLabel(tr("Customer History"));
setReportName("CustomerARHistory");
setMetaSQLOptions("arHistory", "detail");
setUseAltId(true);
list()->setRootIsDecorated(true);
list()->addColumn(tr("Open"), _dateColumn, Qt::AlignCenter, true, "open" );
list()->addColumn(tr("Doc. Type"), _itemColumn, Qt::AlignCenter, true, "documenttype" );
list()->addColumn(tr("Doc. #"), _orderColumn, Qt::AlignRight, true, "docnumber" );
list()->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter, true, "docdate" );
list()->addColumn(tr("Due/Dist Date"), _dateColumn, Qt::AlignCenter, true, "duedate" );
list()->addColumn(tr("Amount"), _moneyColumn, Qt::AlignRight, true, "amount" );
list()->addColumn(tr("Balance"), _moneyColumn, Qt::AlignRight, true, "balance" );
list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignCenter, true, "currAbbr" );
list()->addColumn(tr("Base Balance"), _bigMoneyColumn, Qt::AlignRight, true, "base_balance" );
_cust->setType(CLineEdit::ActiveCustomers);
}
dspPurchaseReqsByItem::dspPurchaseReqsByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPurchaseReqsByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Purchase Requests by Item"));
setListLabel(tr("Purchase Requests"));
setReportName("PurchaseRequestsByItem");
setMetaSQLOptions("purchase", "purchaserequests");
setUseAltId(true);
list()->addColumn(tr("P/R #"), _orderColumn, Qt::AlignLeft, true, "pr_number");
list()->addColumn(tr("Sub #"), _orderColumn, Qt::AlignLeft, true, "pr_subnumber");
list()->addColumn(tr("Status"), _statusColumn, Qt::AlignCenter, true, "pr_status" );
list()->addColumn(tr("Parent Order"), _orderColumn, Qt::AlignLeft, true, "parent" );
list()->addColumn(tr("Create Date"), _dateColumn, Qt::AlignCenter, true, "pr_createdate" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "pr_duedate" );
list()->addColumn(tr("Qty."), _qtyColumn, Qt::AlignRight, true, "pr_qtyreq" );
list()->addColumn(tr("Netable QOH"), _qtyColumn, Qt::AlignRight, true, "netableqoh" );
list()->addColumn(tr("Reorder Lvl."), _qtyColumn, Qt::AlignRight, true, "itemsite_reorderlevel" );
list()->addColumn(tr("Notes"), -1, Qt::AlignLeft, true, "pr_releasenote" );
list()->setSelectionMode(QAbstractItemView::ExtendedSelection);
connect(omfgThis, SIGNAL(purchaseRequestsUpdated()), this, SLOT(sFillList()));
}
dspReturnAuthorizationsByItem::dspReturnAuthorizationsByItem(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspReturnAuthorizationsByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Return Authorization Lookup by Item"));
setListLabel(tr("Return Authorizations"));
setMetaSQLOptions("returnAuthorizationItems", "detail");
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setStartCaption(tr("Starting Order Date:"));
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
_dates->setEndCaption(tr("Ending Order Date:"));
_item->setType(ItemLineEdit::cSold);
list()->addColumn(tr("Return #"), _orderColumn, Qt::AlignLeft, true, "rahead_number" );
list()->addColumn(tr("Created"), _dateColumn, Qt::AlignCenter, true, "rahead_authdate" );
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "rahead_billtoname" );
list()->addColumn(tr("Status"), _orderColumn, Qt::AlignLeft, true, "raitem_status" );
list()->addColumn(tr("Order UOM"), _uomColumn, Qt::AlignCenter, true, "uom_name" );
list()->addColumn(tr("Authorized"), _qtyColumn, Qt::AlignRight, true, "raitem_qtyauthorized" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "raitem_qtyreceived" );
connect(omfgThis, SIGNAL(returnAuthorizationsUpdated(int, bool)), this, SLOT(sFillList()));
}
dspSalesOrdersByItem::dspSalesOrdersByItem(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspSalesOrdersByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Sales Order Lookup by Item"));
setListLabel(tr("Sales Orders"));
setMetaSQLOptions("salesOrderItems", "detail");
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setStartCaption(tr("Starting Order Date:"));
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
_dates->setEndCaption(tr("Ending Order Date:"));
_item->setType(ItemLineEdit::cSold);
list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "cohead_number" );
list()->addColumn(tr("Order Date"), _dateColumn, Qt::AlignCenter, true, "cohead_orderdate" );
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name" );
list()->addColumn(tr("Order UOM"), _uomColumn, Qt::AlignCenter, true, "uom_name" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyord" );
list()->addColumn(tr("Shipped"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyshipped" );
list()->addColumn(tr("Returned"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyreturned" );
list()->addColumn(tr("Balance"), _qtyColumn, Qt::AlignRight, true, "qtybalance" );
list()->addColumn(tr("Inv. UOM"), _uomColumn, Qt::AlignCenter, false, "inv_uom_name" );
list()->addColumn(tr("Inv. Ordered"), _qtyColumn, Qt::AlignRight, false, "invqtyord" );
list()->addColumn(tr("Inv. Shipped"), _qtyColumn, Qt::AlignRight, false, "invqtyshipped" );
list()->addColumn(tr("Inv. Returned"), _qtyColumn, Qt::AlignRight, false, "invqtyreturned" );
list()->addColumn(tr("Inv. Balance"), _qtyColumn, Qt::AlignRight, false, "invqtybalance" );
connect(omfgThis, SIGNAL(salesOrdersUpdated(int, bool)), this, SLOT(sFillList()));
}
dspMaterialUsageVarianceByBOMItem::dspMaterialUsageVarianceByBOMItem(QWidget* parent, const char* name, Qt::WindowFlags fl)
: display(parent, "dspMaterialUsageVarianceByBOMItem", fl)
{
if (name)
setObjectName(name);
setupUi(optionsWidget());
setWindowTitle(tr("Material Usage Variance by Bill of Materials Item"));
setListLabel(tr("Material Usage Variance"));
setReportName("MaterialUsageVarianceByBOMItem");
setMetaSQLOptions("workOrderVariance", "material");
connect(_item, SIGNAL(newId(int)), this, SLOT(sPopulateComponentItems(int)));
_item->setType(ItemLineEdit::cGeneralManufactured);
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("Post Date"), _dateColumn, Qt::AlignCenter, true, "posted" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "ordered" );
list()->addColumn(tr("Produced"), _qtyColumn, Qt::AlignRight, true, "received" );
list()->addColumn(tr("Proj. Req."), _qtyColumn, Qt::AlignRight, true, "projreq" );
list()->addColumn(tr("Proj. Qty. per"), _qtyColumn, Qt::AlignRight, true, "projqtyper" );
list()->addColumn(tr("Act. Iss."), _qtyColumn, Qt::AlignRight, true, "actiss" );
list()->addColumn(tr("Act. Qty. per"), _qtyColumn, Qt::AlignRight, true, "actqtyper" );
list()->addColumn(tr("Qty. per Var."), _qtyColumn, Qt::AlignRight, true, "qtypervar" );
list()->addColumn(tr("%"), _prcntColumn, Qt::AlignRight, true, "qtypervarpercent" );
list()->addColumn(tr("Notes"), -1, Qt::AlignLeft, false, "womatlvar_notes");
list()->addColumn(tr("Reference"), -1, Qt::AlignLeft, false, "womatlvar_ref");
}
dspWoHistoryByItem::dspWoHistoryByItem(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspWoHistoryByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Work Order History by Item"));
setListLabel(tr("Work Orders"));
setReportName("WOHistoryByItem");
setMetaSQLOptions("workOrderHistory", "detail");
connect(_showCost, SIGNAL(toggled(bool)), this, SLOT(sHandleCosts(bool)));
_item->setType(ItemLineEdit::cGeneralManufactured | ItemLineEdit::cGeneralPurchased);
_item->setDefaultType(ItemLineEdit::cGeneralManufactured);
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("W/O #"), -1, Qt::AlignLeft, true, "wonumber" );
list()->addColumn(tr("Status"), _statusColumn, Qt::AlignCenter, true, "wo_status" );
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "wo_qtyord" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "wo_qtyrcv" );
list()->addColumn(tr("Start Date"), _dateColumn, Qt::AlignCenter, true, "wo_startdate" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "wo_duedate" );
list()->addColumn(tr("Cost"), _costColumn, Qt::AlignRight, true, "wo_postedvalue" );
sHandleCosts(_showCost->isChecked());
connect(omfgThis, SIGNAL(workOrdersUpdated(int, bool)), this, SLOT(sFillList()));
}
dspWoHistoryByNumber::dspWoHistoryByNumber(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspWoHistoryByNumber", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Work Order History by W/O Number"));
setListLabel(tr("Work Orders"));
setReportName("WOHistoryByNumber");
setMetaSQLOptions("workOrderHistory", "detail");
connect(_showCost, SIGNAL(toggled(bool)), this, SLOT(sHandleCosts(bool)));
list()->addColumn(tr("W/O #"), _orderColumn, Qt::AlignLeft, true, "wo_number" );
list()->addColumn(tr("Sub. #"), _uomColumn, Qt::AlignLeft, true, "wo_subnumber" );
list()->addColumn(tr("Item #"), _itemColumn, Qt::AlignLeft, true, "item_number" );
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "itemdescrip" );
list()->addColumn(tr("Status"), _statusColumn, Qt::AlignCenter, true, "wo_status" );
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "wo_qtyord" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "wo_qtyrcv" );
list()->addColumn(tr("Start Date"), _dateColumn, Qt::AlignCenter, true, "wo_startdate" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "wo_duedate" );
list()->addColumn(tr("Cost"), _costColumn, Qt::AlignRight, true, "wo_postedvalue" );
list()->addColumn(tr("WIP"), _costColumn, Qt::AlignRight, false, "wo_wipvalue" );
list()->addColumn(tr("Project"), _orderColumn, Qt::AlignLeft, false, "project" );
list()->addColumn(tr("Priority"), _statusColumn, Qt::AlignCenter, false, "wo_priority" );
list()->addColumn(tr("BOM Rev"), _orderColumn, Qt::AlignLeft, false, "bom_rev_number" );
list()->addColumn(tr("BOO Rev"), _orderColumn, Qt::AlignLeft, false, "boo_rev_number" );
sHandleCosts(_showCost->isChecked());
connect(omfgThis, SIGNAL(workOrdersUpdated(int, bool)), SLOT(sFillList()));
}
dspWoHistoryByClassCode::dspWoHistoryByClassCode(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspWoHistoryByClassCode", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Work Order History by Class Code"));
setListLabel(tr("Work Orders"));
setReportName("WOHistoryByClassCode");
setMetaSQLOptions("workOrderHistory", "detail");
connect(_showCost, SIGNAL(toggled(bool)), this, SLOT(sHandleCosts(bool)));
_classCode->setType(ParameterGroup::ClassCode);
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("W/O #"), _orderColumn, Qt::AlignLeft, true, "wonumber" );
list()->addColumn(tr("Item #"), _itemColumn, Qt::AlignLeft, true, "item_number" );
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "itemdescrip" );
list()->addColumn(tr("Status"), _statusColumn, Qt::AlignCenter, true, "wo_status" );
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "wo_qtyord" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "wo_qtyrcv" );
list()->addColumn(tr("Start Date"), _dateColumn, Qt::AlignRight, true, "wo_startdate" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignRight, true, "wo_duedate" );
list()->addColumn(tr("Cost"), _costColumn, Qt::AlignRight, true, "wo_postedvalue" );
sHandleCosts(_showCost->isChecked());
}
dspPoDeliveryDateVariancesByItem::dspPoDeliveryDateVariancesByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPoDeliveryDateVariancesByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Purchase Order Delivery Date Variances by Item"));
setListLabel(tr("Purchase Item Receipts"));
setReportName("DeliveryDateVariancesByItem");
setMetaSQLOptions("poDeliveryDateVariances", "detail");
_item->setType(ItemLineEdit::cGeneralPurchased | ItemLineEdit::cGeneralManufactured);
_item->setDefaultType(ItemLineEdit::cGeneralPurchased);
_agent->setType(XComboBox::Agent);
_agent->setText(omfgThis->username());
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("P/O #"), _orderColumn, Qt::AlignRight, true, "recv_order_number");
list()->addColumn(tr("Vendor"), _orderColumn, Qt::AlignLeft, true, "vend_name");
list()->addColumn(tr("Vend. Item #"), _itemColumn, Qt::AlignLeft, true, "itemnumber");
list()->addColumn(tr("Vendor Description"), -1, Qt::AlignLeft, true, "itemdescrip");
list()->addColumn(tr("Qty."), _qtyColumn, Qt::AlignRight, true, "recv_qty");
list()->addColumn(tr("Req. Due"), _dateColumn, Qt::AlignCenter,true, "release_duedate" );
list()->addColumn(tr("Req. Leadtime"), _dateColumn, Qt::AlignRight, true, "req_leadtime" );
list()->addColumn(tr("Agrd. Due"), _dateColumn, Qt::AlignCenter,true, "argd_duedate" );
list()->addColumn(tr("Agrd. Leadtime"),_dateColumn, Qt::AlignRight, true, "agrd_leadtime" );
list()->addColumn(tr("Recv. Date"), _dateColumn, Qt::AlignCenter,true, "receivedate" );
list()->addColumn(tr("Real Leadtime"), _dateColumn, Qt::AlignRight, true, "real_leadtime" );
list()->addColumn(tr("Req. Diff"), _dateColumn, Qt::AlignRight, true, "req_diff" );
list()->addColumn(tr("Agrd. Diff"), _dateColumn, Qt::AlignRight, true, "argd_diff" );
}
dspVendorAPHistory::dspVendorAPHistory(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspVendorAPHistory", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Vendor History"));
setReportName("VendorAPHistory");
setMetaSQLOptions("vendorAPHistory", "detail");
setUseAltId(true);
connect(_searchInvoiceNum, SIGNAL(textChanged(const QString&)), this, SLOT(sSearchInvoiceNum()));
list()->setRootIsDecorated(true);
list()->addColumn(tr("Open"), _dateColumn, Qt::AlignCenter, true, "f_open" );
list()->addColumn(tr("Doc. Type"), _itemColumn, Qt::AlignCenter, true, "documenttype" );
list()->addColumn(tr("Doc. #"), _orderColumn, Qt::AlignRight, true, "docnumber" );
list()->addColumn(tr("Invoice #"), _orderColumn, Qt::AlignRight, true, "invoicenumber" );
list()->addColumn(tr("P/O #"), _orderColumn, Qt::AlignRight, true, "ponumber" );
list()->addColumn(tr("Doc. Date"), _dateColumn, Qt::AlignCenter, true, "docdate" );
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter, true, "duedate" );
list()->addColumn(tr("Amount"), _moneyColumn, Qt::AlignRight, true, "amount" );
list()->addColumn(tr("Amount (%1)").arg(CurrDisplay::baseCurrAbbr()), _bigMoneyColumn, Qt::AlignRight, false, "base_amount" );
list()->addColumn(tr("Applied (%1)").arg(CurrDisplay::baseCurrAbbr()), _bigMoneyColumn, Qt::AlignRight, false, "base_applied" );
list()->addColumn(tr("Balance"), _moneyColumn, Qt::AlignRight, true, "balance" );
list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignCenter, true, "currAbbr" );
list()->addColumn(tr("Base Balance"), _bigMoneyColumn, Qt::AlignRight, true, "base_balance" );
list()->setPopulateLinear();
}
dspOrders::dspOrders(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspOrders", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Item Orders"));
setListLabel(tr("Item Orders"));
setMetaSQLOptions("orders", "detail");
setUseAltId(true);
_item->setReadOnly(true);
_warehouse->setEnabled(false);
list()->addColumn(tr("Type"), _docTypeColumn, Qt::AlignCenter, true, "order_type" );
list()->addColumn(tr("Status"), _statusColumn, Qt::AlignCenter, true, "order_status" );
list()->addColumn(tr("Order #"), -1, Qt::AlignLeft, true, "order_number" );
list()->addColumn(tr("Total"), _qtyColumn, Qt::AlignRight, true, "totalqty" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "relievedqty" );
list()->addColumn(tr("Balance"), _qtyColumn, Qt::AlignRight, true, "balanceqty" );
list()->addColumn(tr("Running Bal."), _qtyColumn, Qt::AlignRight, true, "runningbalanceqty" );
list()->addColumn(tr("Required"), _dateColumn, Qt::AlignCenter, true, "duedate" );
if (!_metrics->boolean("MultiWhs"))
{
_warehouseLit->hide();
_warehouse->hide();
}
}