dspInvoiceRegister::dspInvoiceRegister(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspInvoiceRegister", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Invoice Register"));
setListLabel(tr("Transactions"));
setReportName("InvoiceRegister");
setMetaSQLOptions("invoiceRegister", "detail");
setUseAltId(true);
list()->addColumn(tr("Date"), _dateColumn, Qt::AlignCenter,true, "transdate");
list()->addColumn(tr("Source"), _orderColumn, Qt::AlignCenter,true, "gltrans_source");
list()->addColumn(tr("Doc Type"),_orderColumn, Qt::AlignLeft, true, "doctype");
list()->addColumn(tr("Doc. #"), _orderColumn, Qt::AlignCenter,true, "gltrans_docnumber");
list()->addColumn(tr("Reference"), -1, Qt::AlignLeft, true, "notes");
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");
}
dspItemSourcesByItem::dspItemSourcesByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspItemSourcesByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Item Sources by Item"));
setListLabel(tr("Item Sources"));
setReportName("ItemSourcesByItem");
setMetaSQLOptions("itemSources", "detail");
setUseAltId(true);
_item->setType(ItemLineEdit::cGeneralPurchased);
list()->addColumn(tr("Vendor"), -1, Qt::AlignLeft, true, "vend_name" );
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "itemsrc_vend_item_number" );
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter, true, "itemsrc_vend_uom" );
list()->addColumn(tr("UOM Ratio"), _qtyColumn, Qt::AlignRight, true, "itemsrc_invvendoruomratio" );
_item->setFocus();
}
dspStandardJournalHistory::dspStandardJournalHistory(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspStandardJournalHistory", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Standard Journal History"));
setListLabel(tr("G/L Transactions"));
setReportName("StandardJournalHistory");
setMetaSQLOptions("standardJournalHistory", "detail");
setUseAltId(true);
list()->setRootIsDecorated(true);
list()->addColumn(tr("Date"), _dateColumn, Qt::AlignCenter, true, "gltrans_date" );
list()->addColumn(tr("Journal #"), _itemColumn, Qt::AlignCenter, true, "gltrans_journalnumber" );
list()->addColumn(tr("Posted"), _ynColumn, Qt::AlignCenter, true, "gltrans_posted" );
list()->addColumn(tr("Journal Name"), _orderColumn, Qt::AlignCenter, true, "gltrans_docnumber" );
list()->addColumn(tr("Account"), -1, Qt::AlignLeft, true, "account" );
list()->addColumn(tr("Debit"), _bigMoneyColumn, Qt::AlignRight, true, "debit" );
list()->addColumn(tr("Credit"), _bigMoneyColumn, Qt::AlignRight, true, "credit" );
}
dspJobCosting::dspJobCosting(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspJobCosting", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Work Order Costing"));
setListLabel(tr("Posted Costs"));
setReportName("JobCosting");
setMetaSQLOptions("manufacture", "jobcosting");
setUseAltId(true);
list()->addColumn(tr("Type"), _itemColumn, Qt::AlignLeft, true, "type");
list()->addColumn(tr("Work Center/Item"),_itemColumn, Qt::AlignLeft, true, "code");
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "descrip");
list()->addColumn(tr("Qty."), _qtyColumn, Qt::AlignRight, true, "qty");
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter,true, "uom");
list()->addColumn(tr("Cost"),_moneyColumn, Qt::AlignRight, true, "cost");
_wo->setFocus();
}
dspPlannedOrders::dspPlannedOrders(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPlannedOrders", fl)
{
setWindowTitle(tr("Planned Orders"));
setReportName("PlannedOrders");
setMetaSQLOptions("schedule", "plannedorders");
setUseAltId(true);
setParameterWidgetVisible(true);
setSearchVisible(true);
setQueryOnStartEnabled(true);
QString qryType = QString( "SELECT 'P', '%1' UNION "
"SELECT 'W', '%2'")
.arg(tr("Purchase"))
.arg(tr("Manufacture"));
if (_metrics->boolean("MultiWhs"))
qryType.append(QString( " UNION "
"SELECT 'T', '%1'")
.arg(tr("Transfers")));
parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item);
parameterWidget()->append(tr("Order Types"), "type_list", ParameterWidget::Multiselect, QVariant(), false, qryType );
parameterWidget()->appendComboBox(tr("Planner Code"), "plancode_id", XComboBox::PlannerCodes);
parameterWidget()->append(tr("Planner Code Pattern"), "plancode_pattern", ParameterWidget::Text);
parameterWidget()->appendComboBox(tr("Class Code"), "classcode_id", XComboBox::ClassCodes);
parameterWidget()->append(tr("Show Inactive"), "showInactive", ParameterWidget::Exists);
if (_metrics->boolean("MultiWhs"))
parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site);
list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "ordernum");
list()->addColumn(tr("Type"), _uomColumn, Qt::AlignCenter,true, "ordtype");
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter,true, "warehous_code");
list()->addColumn(tr("From Site"), _whsColumn, Qt::AlignCenter,true, "supply_warehous_code");
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number");
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "item_descrip");
list()->addColumn(tr("Classcode Description"), -1, Qt::AlignLeft, true, "classcode_descrip");
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter,true, "uom_name");
list()->addColumn(tr("Start Date"), _dateColumn, Qt::AlignCenter,true, "planord_startdate");
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter,true, "planord_duedate");
list()->addColumn(tr("Qty"), _qtyColumn, Qt::AlignRight, true, "planord_qty");
list()->addColumn(tr("Firm"), _ynColumn, Qt::AlignCenter,true, "planord_firm");
}
dspReorderExceptionsByPlannerCode::dspReorderExceptionsByPlannerCode(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspReorderExceptionsByPlannerCode", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Reorder Exceptions by Planner Code"));
setListLabel(tr("Expedite Exceptions"));
setReportName("ReorderExceptionsByPlannerCode");
setMetaSQLOptions("reorderExceptionsByPlannerCode", "detail");
setUseAltId(true);
_plannerCode->setType(ParameterGroup::PlannerCode);
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("Exception Date"), _dateColumn, Qt::AlignCenter, true, "reorderdate" );
list()->addColumn(tr("Reorder Level"), _qtyColumn, Qt::AlignRight, true, "reorderlevel" );
list()->addColumn(tr("Proj. Avail."), _qtyColumn, Qt::AlignRight, true, "projavail" );
}
dspInventoryAvailabilityByCustomerType::dspInventoryAvailabilityByCustomerType(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspInventoryAvailabilityByCustomerType", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Inventory Availability by Customer Type"));
setListLabel(tr("Availability"));
setReportName("InventoryAvailabilityByCustomerType");
setMetaSQLOptions("inventoryAvailability", "byCustOrSO");
setUseAltId(true);
setAutoUpdateEnabled(true);
_custtype->setType(ParameterGroup::CustomerType);
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("QOH"), _qtyColumn, Qt::AlignRight, true, "qoh");
list()->addColumn(tr("This Alloc."), _qtyColumn, Qt::AlignRight, true, "sobalance");
list()->addColumn(tr("Total Alloc."), _qtyColumn, Qt::AlignRight, true, "allocated");
list()->addColumn(tr("Orders"), _qtyColumn, Qt::AlignRight, true, "ordered");
list()->addColumn(tr("This Avail."), _qtyColumn, Qt::AlignRight, true, "orderavail");
list()->addColumn(tr("Total Avail."), _qtyColumn, Qt::AlignRight, true, "totalavail");
list()->addColumn(tr("At Shipping"), _qtyColumn, Qt::AlignRight, true, "atshipping");
list()->addColumn(tr("Order/Start Date"),_dateColumn, Qt::AlignCenter,true, "orderdate");
list()->addColumn(tr("Sched./Due Date"), _dateColumn, Qt::AlignCenter,true, "duedate");
list()->setIndentation(10);
list()->setPopulateLinear(true);
if(!_metrics->boolean("EnableSOReservations"))
{
_useReservationNetting->hide();
_useReservationNetting->setEnabled(false);
}
else
{
connect(_useReservationNetting, SIGNAL(toggled(bool)), this, SLOT(sHandleReservationNetting(bool)));
if(_useReservationNetting->isChecked())
sHandleReservationNetting(true);
}
connect(omfgThis, SIGNAL(workOrdersUpdated(int, bool)), this, SLOT(sFillList()));
sFillList();
}
dspSummarizedBacklogByWarehouse::dspSummarizedBacklogByWarehouse(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspSummarizedBacklogByWarehouse", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Summarized Backlog by Site"));
setListLabel(tr("Backlog"));
setReportName("SummarizedBacklogByWarehouse");
setMetaSQLOptions("summarizedBacklogByWarehouse", "detail");
setUseAltId(true);
connect(_showPrices, SIGNAL(toggled(bool)), this, SLOT(sHandlePrices(bool)));
_customerType->setType(ParameterGroup::CustomerType);
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
list()->addColumn(tr("Order#/Shipment#"), _itemColumn, Qt::AlignLeft, true, "cohead_number");
list()->addColumn(tr("Customer/Ship Via"), -1, Qt::AlignLeft, true, "cust_name");
list()->addColumn(tr("Hold Type/Shipped"), _orderColumn*2, Qt::AlignRight, true, "f_holdtype");
list()->addColumn(tr("Ordered/Shipped"), _dateColumn, Qt::AlignRight, true, "cohead_orderdate");
list()->addColumn(tr("Scheduled"), _dateColumn, Qt::AlignRight, true, "scheddate");
list()->addColumn(tr("Pack Date"), _dateColumn, Qt::AlignRight, true, "cohead_packdate");
if (_privileges->check("ViewCustomerPrices"))
list()->addColumn(tr("Sales"), _moneyColumn, Qt::AlignRight, true, "sales");
if (_privileges->check("ViewCosts"))
list()->addColumn(tr("Cost"), _moneyColumn, Qt::AlignRight, true, "cost");
if (_privileges->check("ViewCustomerPrices") && _privileges->check("ViewCosts"))
list()->addColumn(tr("Margin"), _moneyColumn, Qt::AlignRight, true, "margin");
list()->addColumn(tr("Sales Rep"), _itemColumn, Qt::AlignRight, true, "salesrep_name");
list()->addColumn(tr("Time Received"), _dateColumn, Qt::AlignRight, false, "cohead_created");
list()->addColumn(tr("Pack List Batch"), _dateColumn, Qt::AlignRight, false, "packed");
list()->setRootIsDecorated(true);
list()->setDragString("soheadid=");
if ( (!_privileges->check("ViewCustomerPrices")) && (!_privileges->check("ViewCosts")) )
_showPrices->setEnabled(false);
sHandlePrices(_showPrices->isChecked());
connect(omfgThis, SIGNAL(salesOrdersUpdated(int, bool)), this, SLOT(sFillList()));
sFillList();
}
dspUsageStatistics::dspUsageStatistics(QWidget* parent, const char* name, Qt::WindowFlags fl)
: display(parent, name, fl)
{
setWindowTitle(tr("Item Usage Statistics"));
setReportName("UsageStatistics");
setMetaSQLOptions("usageStatistics", "detail");
setUseAltId(true);
setParameterWidgetVisible(true);
_printing = false;
QString qryABC = QString( "SELECT 'A', '%1' UNION "
"SELECT 'B', '%2' UNION "
"SELECT 'C', '%3' ORDER BY 1;")
.arg(tr("A Class"))
.arg(tr("B Class"))
.arg(tr("C Class"));
parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date, QDate(QDate::currentDate().year(),1,1), true);
parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date, QDate::currentDate(), true);
parameterWidget()->appendComboBox(tr("Class Code"), "classcode_id", XComboBox::ClassCodes);
parameterWidget()->append(tr("Class Code Pattern"), "classcode_pattern", ParameterWidget::Text);
parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item);
parameterWidget()->appendComboBox(tr("Item Group"), "itemgrp_id", XComboBox::ItemGroups);
parameterWidget()->append(tr("Item Group Pattern"), "itemgrp_pattern", ParameterWidget::Text);
if (_metrics->boolean("MultiWhs"))
parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site);
parameterWidget()->append(tr("ABC Class"), "abc_class",
ParameterWidget::Multiselect, QVariant(), false,
qryABC);
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("ABC Class"), _itemColumn, Qt::AlignLeft, false, "itemsite_abcclass" );
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "received" );
list()->addColumn(tr("Issued"), _qtyColumn, Qt::AlignRight, true, "issued" );
list()->addColumn(tr("Sold"), _qtyColumn, Qt::AlignRight, true, "sold" );
list()->addColumn(tr("Scrap"), _qtyColumn, Qt::AlignRight, true, "scrap" );
list()->addColumn(tr("Adjustments"), _qtyColumn, Qt::AlignRight, true, "adjust" );
if (_metrics->boolean("MultiWhs"))
list()->addColumn(tr("Transfers"), _qtyColumn, Qt::AlignRight, true, "transfer" );
}
dspExpediteExceptionsByPlannerCode::dspExpediteExceptionsByPlannerCode(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspExpediteExceptionsByPlannerCode", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Expedite Exceptions by Planner Code"));
setListLabel(tr("Expedite Exceptions"));
setReportName("ExpediteExceptionsByPlannerCode");
setMetaSQLOptions("schedule", "expedite");
setUseAltId(true);
_plannerCode->setType(ParameterGroup::PlannerCode);
list()->addColumn(tr("Order Type/#"), _itemColumn, Qt::AlignCenter,true, "order_number");
list()->addColumn(tr("To Site"), _whsColumn, Qt::AlignCenter,true, "to_warehous");
list()->addColumn(tr("From Site"), _whsColumn, Qt::AlignCenter,true, "from_warehous");
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number");
list()->addColumn(tr("Descriptions"), -1, Qt::AlignLeft, true, "item_descrip");
list()->addColumn(tr("Start/Due Date"), _itemColumn, Qt::AlignLeft, true, "keydate");
list()->addColumn(tr("Exception"), 120, Qt::AlignLeft, true, "exception");
}
dspUnbalancedQOHByClassCode::dspUnbalancedQOHByClassCode(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspUnbalancedQOHByClassCode", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Unbalanced QOH by Class Code"));
setListLabel(tr("&Item Sites"));
setMetaSQLOptions("unbalancedQOHByClassCode", "detail");
setUseAltId(true);
_classCode->setType(ParameterGroup::ClassCode);
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("UOM"), _uomColumn, Qt::AlignCenter, true, "uom_name" );
list()->addColumn(tr("QOH"), _qtyColumn, Qt::AlignRight, true, "itemsite_qtyonhand" );
list()->addColumn(tr("QOH Detail."), _qtyColumn, Qt::AlignRight, true, "detailedqoh" );
list()->addColumn(tr("NN QOH"), _qtyColumn, Qt::AlignRight, true, "itemsite_nnqoh" );
list()->addColumn(tr("NN Detail."), _qtyColumn, Qt::AlignRight, true, "detailednnqoh" );
}
dspRunningAvailability::dspRunningAvailability(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspRunningAvailability", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Running Availability"));
setListLabel(tr("Running Availability"));
setReportName("RunningAvailability");
setMetaSQLOptions("runningAvailability", "detail");
setUseAltId(true);
_ready = true;
connect(list(), SIGNAL(populated()), this, SLOT(sHandleResort()));
connect(list(), SIGNAL(resorted()), this, SLOT(sHandleResort()));
list()->addColumn(tr("Order Type"), _itemColumn, Qt::AlignLeft, true, "ordertype");
list()->addColumn(tr("Order #"), _itemColumn, Qt::AlignLeft, true, "ordernumber");
list()->addColumn(tr("Source/Destination"), -1, Qt::AlignLeft, true, "item_number");
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignLeft, true, "duedate");
list()->addColumn(tr("Amount"), _moneyColumn, Qt::AlignRight, true, "amount");
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "qtyordered");
list()->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "qtyreceived");
list()->addColumn(tr("Balance"), _qtyColumn, Qt::AlignRight, true, "balance");
list()->addColumn(tr("Running Avail."), _qtyColumn, Qt::AlignRight, true, "runningavail");
list()->addColumn(tr("Running Netable"), _qtyColumn, Qt::AlignRight, true, "runningnetable");
list()->addColumn(tr("Notes"), _itemColumn, Qt::AlignLeft, true, "notes");
_qoh->setValidator(omfgThis->qtyVal());
_netableqoh->setValidator(omfgThis->qtyVal());
_reorderLevel->setValidator(omfgThis->qtyVal());
_orderMultiple->setValidator(omfgThis->qtyVal());
_orderToQty->setValidator(omfgThis->qtyVal());
connect(omfgThis, SIGNAL(workOrdersUpdated(int, bool)), this, SLOT(sFillList()));
if (!_metrics->boolean("MultiWhs"))
{
_warehouseLit->hide();
_warehouse->hide();
}
}
dspPoHistory::dspPoHistory(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPoHistory", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Purchase Order History"));
setListLabel(tr("P/O Items"));
setReportName("POHistory");
setMetaSQLOptions("poHistory", "detail");
setUseAltId(true);
list()->addColumn(tr("#"), _whsColumn, Qt::AlignCenter, true, "poitem_linenumber");
list()->addColumn(tr("Item/Doc. #"), _itemColumn, Qt::AlignLeft, true, "itemnumber");
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "itemdescription");
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter, true, "uomname");
list()->addColumn(tr("Due/Recvd."), _dateColumn, Qt::AlignCenter, true, "poitem_duedate");
list()->addColumn(tr("Vend. Item #"), -1, Qt::AlignLeft, true, "poitem_vend_item_number");
list()->addColumn(tr("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");
}
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"), -1, Qt::AlignLeft, true, "parent" );
list()->addColumn(tr("Create Date"), -1, Qt::AlignLeft, 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("Notes"), -1, Qt::AlignLeft, true, "pr_releasenote" );
connect(omfgThis, SIGNAL(purchaseRequestsUpdated()), this, SLOT(sFillList()));
}
dspDetailedInventoryHistoryByLocation::dspDetailedInventoryHistoryByLocation(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspDetailedInventoryHistoryByLocation", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Detailed Inventory History by Location"));
setListLabel(tr("Inventory History"));
setReportName("DetailedInventoryHistoryByLocation");
setMetaSQLOptions("detailedInventoryHistory", "detail");
setUseAltId(true);
connect(_location, SIGNAL(newID(int)), this, SLOT(sPopulateLocationInfo(int)));
connect(_warehouse, SIGNAL(updated()), this, SLOT(sPopulateLocations()));
_transType->append(cTransAll, tr("All Transactions") );
_transType->append(cTransReceipts, tr("Receipts") );
_transType->append(cTransIssues, tr("Issues") );
_transType->append(cTransShipments, tr("Shipments") );
_transType->append(cTransAdjCounts, tr("Adjustments and Counts") );
if (_metrics->value("Application") != "PostBooks")
_transType->append(cTransTransfers, tr("Transfers") );
_transType->append(cTransScraps, tr("Scraps") );
_transType->setCurrentIndex(0);
list()->addColumn(tr("Date"), (_dateColumn + 30), Qt::AlignRight, true, "invhist_transdate");
list()->addColumn(tr("Type"), _transColumn, Qt::AlignCenter,true, "invhist_transtype");
list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "ordernumber");
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number");
list()->addColumn(tr("Lot/Serial #"), -1, Qt::AlignLeft, true, "lotserial");
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter,true, "invhist_invuom");
list()->addColumn(tr("Trans-Qty"), _qtyColumn, Qt::AlignRight, true, "transqty");
list()->addColumn(tr("Qty. Before"), _qtyColumn, Qt::AlignRight, true, "qohbefore");
list()->addColumn(tr("Qty. After"), _qtyColumn, Qt::AlignRight, true, "qohafter");
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
sPopulateLocations();
}
dspBookings::dspBookings(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspBookings", fl)
{
setWindowTitle(tr("Bookings"));
setReportName("Bookings");
setMetaSQLOptions("bookings", "detail");
setParameterWidgetVisible(true);
setUseAltId(true);
parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date, QDate::currentDate(), true );
parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date, QDate::currentDate(), true);
parameterWidget()->append(tr("Customer"), "cust_id", ParameterWidget::Customer);
parameterWidget()->append(tr("Customer Ship-to"), "shipto_id", ParameterWidget::Shipto);
parameterWidget()->appendComboBox(tr("Customer Group"), "custgrp_id", XComboBox::CustomerGroups);
parameterWidget()->append(tr("Customer Group Pattern"), "custgrp_pattern", ParameterWidget::Text);
parameterWidget()->appendComboBox(tr("Customer Type"), "custtype_id", XComboBox::CustomerTypes);
parameterWidget()->append(tr("Customer Type Pattern"), "custtype_pattern", ParameterWidget::Text);
parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item);
parameterWidget()->appendComboBox(tr("Product Category"), "prodcat_id", XComboBox::ProductCategories);
parameterWidget()->append(tr("Product Category Pattern"), "prodcat_pattern", ParameterWidget::Text);
parameterWidget()->appendComboBox(tr("Sales Rep."), "salesrep_id", XComboBox::SalesReps);
if (_metrics->boolean("MultiWhs"))
parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site);
parameterWidget()->applyDefaultFilterSet();
list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "cohead_number" );
list()->addColumn(tr("Line #"), _seqColumn, Qt::AlignLeft, true, "f_linenumber" );
list()->addColumn(tr("Ord. Date"), _dateColumn, Qt::AlignCenter, true, "cohead_orderdate");
list()->addColumn(tr("Cust. #"), _itemColumn, Qt::AlignLeft, true, "cust_number" );
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, false, "cust_name" );
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number" );
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "itemdescription" );
list()->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "coitem_qtyord" );
list()->addColumn(tr("Unit Price"), _priceColumn, Qt::AlignRight, false, "coitem_price" );
list()->addColumn(tr("Ext. Price"), _bigMoneyColumn, Qt::AlignRight, false, "extprice" );
list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignCenter, false, "currAbbr" );
list()->addColumn(tr("Base Unit Price"), _priceColumn, Qt::AlignRight, true, "baseunitprice" );
list()->addColumn(tr("Base Ext. Price"), _bigMoneyColumn, Qt::AlignRight, true, "baseextprice" );
}
dspPlannedOrdersByItem::dspPlannedOrdersByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPlannedOrdersByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Planned Orders by Item"));
setListLabel(tr("Planned Orders"));
setReportName("PlannedOrdersByItem");
setMetaSQLOptions("schedule", "plannedorders");
setUseAltId(true);
list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignCenter,true, "ordernum");
list()->addColumn(tr("Type"), _uomColumn, Qt::AlignCenter,true, "ordtype");
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter,true, "warehous_code");
list()->addColumn(tr("From Site"), _whsColumn, Qt::AlignCenter,true, "supply_warehous_code");
list()->addColumn(tr("Start Date"), _dateColumn, Qt::AlignCenter,true, "planord_startdate");
list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignCenter,true, "planord_duedate");
list()->addColumn(tr("Qty"), _qtyColumn, Qt::AlignRight, true, "planord_qty");
list()->addColumn(tr("Firm"), _uomColumn, Qt::AlignCenter,true, "planord_firm");
list()->addColumn(tr("Comments"), -1, Qt::AlignLeft, true, "comments");
connect(omfgThis, SIGNAL(workOrdersUpdated(int, bool)), this, SLOT(sFillList()));
}
dspInvalidBillsOfMaterials::dspInvalidBillsOfMaterials(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspInvalidBillsOfMaterials", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Bills of Materials without Component Item Sites"));
setListLabel(tr("Invalid Bill of Material Items"));
setMetaSQLOptions("invalidBillsofMaterials", "detail");
setUseAltId(true);
connect(_update, SIGNAL(toggled(bool)), this, SLOT(sHandleUpdate()));
list()->addColumn("componentItemid", 0, Qt::AlignCenter,true, "pitem_id");
list()->addColumn("componentSiteId", 0, Qt::AlignCenter,true, "citem_id");
list()->addColumn("warehousId", 0, Qt::AlignCenter,true, "warehous_id");
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter,true, "warehous_code");
list()->addColumn(tr("Parent Item #"), _itemColumn, Qt::AlignLeft, true, "parentitem");
list()->addColumn(tr("Component Item #"), _itemColumn, Qt::AlignLeft, true, "componentitem");
list()->addColumn(tr("Component Item Description"), -1, Qt::AlignLeft, true, "descrip");
if (_preferences->boolean("XCheckBox/forgetful"))
_update->setChecked(true);
}
dspFreightPricesByCustomer::dspFreightPricesByCustomer(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspFreightPricesByCustomer", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Freight Prices by Customer"));
setListLabel(tr("Freight Prices"));
setReportName("FreightPricesByCustomer");
setMetaSQLOptions("freightPrices", "detail");
setUseAltId(true);
list()->addColumn(tr("Schedule"), _itemColumn, Qt::AlignLeft, true, "ipshead_name" );
list()->addColumn(tr("Source"), _itemColumn, Qt::AlignLeft, true, "source" );
list()->addColumn(tr("Qty. Break"), _qtyColumn, Qt::AlignRight, true, "ipsfreight_qtybreak" );
list()->addColumn(tr("Price"), _priceColumn, Qt::AlignRight, true, "ipsfreight_price" );
list()->addColumn(tr("Method"), _itemColumn, Qt::AlignLeft, true, "method" );
list()->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "currConcat");
list()->addColumn(tr("From"), _itemColumn, Qt::AlignLeft, true, "warehous_code" );
list()->addColumn(tr("To"), _itemColumn, Qt::AlignLeft, true, "shipzone_name" );
list()->addColumn(tr("Freight Class"), _itemColumn, Qt::AlignLeft, true, "freightclass_code" );
list()->addColumn(tr("Ship Via"), _itemColumn, Qt::AlignLeft, true, "ipsfreight_shipvia" );
}
dspTrialBalances::dspTrialBalances(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspTrialBalances", fl)
{
setWindowTitle(tr("Trial Balances"));
setListLabel(tr("Trial Balances"));
setReportName("TrialBalances");
setMetaSQLOptions("trialBalances", "detail");
setUseAltId(true);
setParameterWidgetVisible(true);
list()->addColumn(tr("Start"), _dateColumn, Qt::AlignCenter, true, "period_start" );
list()->addColumn(tr("End"), _dateColumn, Qt::AlignCenter, true, "period_end" );
list()->addColumn(tr("Account #"), _itemColumn, Qt::AlignLeft, true, "account" );
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "accnt_descrip" );
list()->addColumn(tr("Beg. Bal."), _bigMoneyColumn, Qt::AlignRight, true, "beginning" );
list()->addColumn(tr("Beg. Bal. Sense"), 25, Qt::AlignLeft, true, "beginningsense" );
list()->addColumn(tr("Debits"), _bigMoneyColumn, Qt::AlignRight, true, "debits" );
list()->addColumn(tr("Credits"), _bigMoneyColumn, Qt::AlignRight, true, "credits" );
list()->addColumn(tr("Difference"), _bigMoneyColumn, Qt::AlignRight, true, "diff" );
list()->addColumn(tr("Difference Sense"), 25, Qt::AlignLeft, true, "diffsense" );
list()->addColumn(tr("End Bal."), _bigMoneyColumn, Qt::AlignRight, true, "ending" );
list()->addColumn(tr("End Bal. Sense"), 25, Qt::AlignLeft, true, "endingsense" );
// Determine current period
int periodid = -1;
XSqlQuery qry;
qry.exec("SELECT period_id "
"FROM period "
"WHERE (current_date BETWEEN period_start AND period_end);");
if (qry.first())
periodid = qry.value("period_id").toInt();
parameterWidget()->appendComboBox(tr("Period"), "period_id", XComboBox::AccountingPeriods, QVariant(periodid));
if (_metrics->value("GLCompanySize").toInt() > 0)
parameterWidget()->appendComboBox(tr("Company"), "company_id", XComboBox::Companies);
parameterWidget()->append(tr("GL Account"), "accnt_id", ParameterWidget::GLAccount);
parameterWidget()->append(tr("Show Zero Amounts"), "showZero", ParameterWidget::Exists);
parameterWidget()->applyDefaultFilterSet();
}
dspPoReturnsByVendor::dspPoReturnsByVendor(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspPoReturnsByVendor", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Rejected Material by Vendor"));
setListLabel(tr("Rejected Material"));
setReportName("RejectedMaterialByVendor");
setMetaSQLOptions("poReturns", "detail");
setUseAltId(true);
connect(_selectedPurchasingAgent, SIGNAL(toggled(bool)), _agent, SLOT(setEnabled(bool)));
_agent->setType(XComboBox::Agent);
_agent->setText(omfgThis->username());
list()->addColumn(tr("P/O #"), _orderColumn, Qt::AlignRight, true, "poreject_ponumber" );
list()->addColumn(tr("Vendor"), _orderColumn, Qt::AlignLeft, true, "vend_name" );
list()->addColumn(tr("Date"), _dateColumn, Qt::AlignCenter, true, "poreject_date" );
list()->addColumn(tr("Vend. Item #"), _itemColumn, Qt::AlignLeft, true, "poreject_vend_item_number" );
list()->addColumn(tr("Vendor Description"), -1, Qt::AlignLeft, true, "poreject_vend_item_descrip" );
list()->addColumn(tr("Qty."), _qtyColumn, Qt::AlignRight, true, "poreject_qty" );
list()->addColumn(tr("Reject Code"), _itemColumn, Qt::AlignRight, true, "rjctcode_code" );
}
dspInventoryAvailability::dspInventoryAvailability(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspInventoryAvailability", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Inventory Availability"));
setReportName("InventoryAvailability");
setMetaSQLOptions("inventoryAvailability", "general");
setUseAltId(true);
setParameterWidgetVisible(true);
_forgetful = true;
if(window())
_settingsName = window()->objectName() + "/asof";
_asof->setCurrentIndex(_preferences->value(_settingsName).toInt());
_forgetful = false;
parameterWidget()->appendComboBox(tr("Class Code"), "classcode_id", XComboBox::ClassCodes);
parameterWidget()->append(tr("Class Code Pattern"), "classcode_pattern", ParameterWidget::Text);
parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item);
parameterWidget()->appendComboBox(tr("Item Group"), "itemgrp_id", XComboBox::ItemGroups);
parameterWidget()->append(tr("Item Group Pattern"), "itemgrp_pattern", ParameterWidget::Text);
parameterWidget()->appendComboBox(tr("Planner Code"), "plancode_id", XComboBox::PlannerCodes);
parameterWidget()->append(tr("Planner Code Pattern"), "plancode_pattern", ParameterWidget::Text);
parameterWidget()->append(tr("Source Vendor"), "vend_id", ParameterWidget::Vendor);
parameterWidget()->appendComboBox(tr("Source Vendor Type"), "vendtype_id", XComboBox::VendorTypes);
parameterWidget()->append(tr("Source Vendor Type Pattern"), "vendtype_pattern", ParameterWidget::Text);
if (_metrics->boolean("MultiWhs"))
parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site);
sHandleShowReorder(_showReorder->isChecked());
sByVendorChanged();
connect(_showReorder, SIGNAL(toggled(bool)), this, SLOT(sHandleShowReorder(bool)));
connect(omfgThis, SIGNAL(workOrdersUpdated(int, bool)), this, SLOT(sFillList()));
connect(_byVendor, SIGNAL(toggled(bool)), this, SLOT(sByVendorChanged()));
connect(_asof, SIGNAL(currentIndexChanged(int)), this, SLOT(sAsofChanged(int)));
}
dspTimePhasedSales::dspTimePhasedSales(QWidget* parent, const char*, Qt::WFlags fl)
: displayTimePhased(parent, "dspTimePhasedSales", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Time-Phased Sales History"));
setReportName("TimePhasedSalesHistory");
setMetaSQLOptions("timePhasedSales", "detail");
setUseAltId(true);
setParameterWidgetVisible(true);
parameterWidget()->append(tr("Customer"), "cust_id", ParameterWidget::Customer);
parameterWidget()->appendComboBox(tr("Customer Group"), "custgrp_id", XComboBox::CustomerGroups);
parameterWidget()->append(tr("Customer Group Pattern"), "custgrp_pattern", ParameterWidget::Text);
parameterWidget()->appendComboBox(tr("Customer Type"), "custtype_id", XComboBox::CustomerTypes);
parameterWidget()->append(tr("Customer Type Pattern"), "custtype_pattern", ParameterWidget::Text);
parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item);
parameterWidget()->appendComboBox(tr("Product Category"), "prodcat_id", XComboBox::ProductCategories);
parameterWidget()->append(tr("Product Category Pattern"), "prodcat_pattern", ParameterWidget::Text);
if (_metrics->boolean("MultiWhs"))
parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site);
parameterWidget()->applyDefaultFilterSet();
_groupBy->append(0,tr("Customer"));
_groupBy->append(1,tr("Product Category"));
_groupBy->append(2,tr("Item"));
_units->append(0, tr("Sales Dollars"));
_units->append(1, tr("Inventory"));
_units->append(2,tr("Capacity"));
_units->append(3, tr("Alt. Capacity"));
connect(_groupBy, SIGNAL(newID(int)), this, SLOT(sGroupByChanged()));
sGroupByChanged();
}
dspCustomersByCharacteristic::dspCustomersByCharacteristic(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspCustomersByCharacteristic", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Customers by Characteristic"));
setListLabel(tr("Characteristic"));
setReportName("CustomersByCharacteristic");
setMetaSQLOptions("customer", "detail");
setUseAltId(true);
_char->populate( "SELECT char_id, char_name "
"FROM char "
"WHERE (char_customers) "
"ORDER BY char_name;" );
list()->addColumn(tr("Active"), _ynColumn, Qt::AlignLeft, true, "cust_active");
list()->addColumn(tr("Number"), _itemColumn, Qt::AlignLeft, true, "cust_number");
list()->addColumn(tr("Name"), -1, Qt::AlignLeft, true, "cust_name");
list()->addColumn(tr("Characteristic"), _itemColumn, Qt::AlignCenter,true, "char_name");
list()->addColumn(tr("Value"), _itemColumn, Qt::AlignLeft, true, "charass_value");
list()->setDragString("custid=");
connect(omfgThis, SIGNAL(itemsUpdated(int, bool)), this, SLOT(sFillList(int, bool)));
}
dspQuotesByItem::dspQuotesByItem(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspQuotesByItem", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Quote Lookup by Item"));
setListLabel(tr("Quotes"));
setMetaSQLOptions("quoteItems", "detail");
setUseAltId(true);
_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("Quote #"), _orderColumn, Qt::AlignLeft, true, "quhead_number" );
list()->addColumn(tr("Quote Date"), _dateColumn, Qt::AlignCenter, true, "quhead_quotedate" );
list()->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name" );
list()->addColumn(tr("Status"), _statusColumn, Qt::AlignCenter, true, "quhead_status" );
list()->addColumn(tr("Quoted"), _qtyColumn, Qt::AlignRight, true, "quitem_qtyord" );
connect(omfgThis, SIGNAL(salesOrdersUpdated(int, bool)), this, SLOT(sFillList()));
}
dspUserPrivileges::dspUserPrivileges(QWidget* parent, const char* name, Qt::WindowFlags fl)
: display(parent, name, fl)
{
setWindowTitle(tr("User Privilege Audit"));
setReportName("UserPrivileges");
setMetaSQLOptions("permissions", "privileges");
setParameterWidgetVisible(true);
setUseAltId(true);
_printing = false;
_grpSql = "SELECT grp_id, grp_name FROM grp ORDER BY grp_name;";
parameterWidget()->append(tr("Username"), "username", ParameterWidget::User);
parameterWidget()->appendComboBox(tr("Role"), "role", _grpSql);
parameterWidget()->append(tr("Privilege"), "privilege", ParameterWidget::Text);
parameterWidget()->applyDefaultFilterSet();
list()->addColumn(tr("Username"), 100, Qt::AlignLeft, true, "priv_username" );
list()->addColumn(tr("Role"), 100, Qt::AlignLeft, true, "grp_name" );
list()->addColumn(tr("Module"), -1, Qt::AlignLeft, true, "priv_module" );
list()->addColumn(tr("Privilege Name"), -1, Qt::AlignLeft, true, "priv_name" );
list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "priv_descrip" );
}
dspUsageStatisticsBase::dspUsageStatisticsBase(QWidget* parent, const char* name, Qt::WFlags fl)
: display(parent, name, fl)
{
setupUi(optionsWidget());
setListLabel(tr("Usage"));
setMetaSQLOptions("usageStatistics", "detail");
setUseAltId(true);
_printing = false;
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("Received"), _qtyColumn, Qt::AlignRight, true, "received" );
list()->addColumn(tr("Issued"), _qtyColumn, Qt::AlignRight, true, "issued" );
list()->addColumn(tr("Sold"), _qtyColumn, Qt::AlignRight, true, "sold" );
list()->addColumn(tr("Scrap"), _qtyColumn, Qt::AlignRight, true, "scrap" );
list()->addColumn(tr("Adjustments"), _qtyColumn, Qt::AlignRight, true, "adjust" );
if (_metrics->boolean("MultiWhs"))
list()->addColumn(tr("Transfers"), _qtyColumn, Qt::AlignRight, true, "transfer" );
_dates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), true);
_dates->setEndNull(tr("Latest"), omfgThis->endOfTime(), true);
}
dspDetailedInventoryHistoryByLotSerial::dspDetailedInventoryHistoryByLotSerial(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspDetailedInventoryHistoryByLotSerial", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Detailed Inventory History by Lot/Serial #"));
setListLabel(tr("Inventory History"));
setReportName("DetailedInventoryHistoryByLotSerial");
setMetaSQLOptions("detailedInventoryHistory", "detail");
setUseAltId(true);
setParameterWidgetVisible(true);
connect(_selected, SIGNAL(clicked()), this, SLOT(sSelect()));
connect(_pattern, SIGNAL(clicked()), this, SLOT(sSelect()));
QString qryTransType = QString("SELECT %1 AS id, '%8' AS type UNION "
"SELECT %2 AS id, '%9' AS type UNION "
"SELECT %3 AS id, '%10' AS type UNION "
"SELECT %4 AS id, '%11' AS type UNION "
"SELECT %5 AS id, '%12' AS type UNION "
"SELECT %6 AS id, '%13' AS type UNION "
"SELECT %7 AS id, '%14' AS type;")
.arg(cTransAll)
.arg(cTransReceipts)
.arg(cTransIssues)
.arg(cTransShipments)
.arg(cTransAdjCounts)
.arg(cTransTransfers)
.arg(cTransScraps)
.arg(tr("All Transactions"))
.arg(tr("Receipts"))
.arg(tr("Issues") )
.arg(tr("Shipments"))
.arg(tr("Adjustments and Counts"))
.arg(tr("Transfers"))
.arg(tr("Scraps") );
QString qryTrace = QString("SELECT 0 AS id, '%1' AS type "
"UNION "
"SELECT 1 AS id, '%2' AS type; ")
.arg(tr("Forward"))
.arg(tr("Backward"));
list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "lshist_warehous_code" );
list()->addColumn(tr("Date"), (_dateColumn + 30), Qt::AlignRight, true, "lshist_transdate" );
list()->addColumn(tr("Type"), _transColumn, Qt::AlignCenter, true, "lshist_transtype" );
list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "lshist_ordernumber" );
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "lshist_item_number" );
list()->addColumn(tr("Location"), _dateColumn, Qt::AlignLeft, true, "lshist_locationname" );
list()->addColumn(tr("Lot/Serial #"), -1, Qt::AlignLeft, true, "lshist_lotserial" );
list()->addColumn(tr("Perishable"), -1, Qt::AlignLeft, true, "lshist_perishable" );
list()->addColumn(tr("Expiration"), _dateColumn, Qt::AlignLeft, true, "lshist_expiration" );
list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter, true, "lshist_invuom" );
list()->addColumn(tr("Trans-Qty"), _qtyColumn, Qt::AlignRight, true, "lshist_transqty" );
list()->addColumn(tr("Qty. Before"), _qtyColumn, Qt::AlignRight, true, "lshist_qty_before" );
list()->addColumn(tr("Qty. After"), _qtyColumn, Qt::AlignRight, true, "lshist_qty_after" );
list()->addColumn(tr("Customer #/Name"), 170, Qt::AlignLeft, false, "customerinfo");
list()->addColumn(tr("ShipTo Name"), 170, Qt::AlignLeft, false, "shiptoname");
list()->addColumn(tr("ShipTo Line1"), 200, Qt::AlignLeft, false, "shiptol1");
list()->addColumn(tr("ShipTo Line2"), 200, Qt::AlignLeft, false, "shiptol2");
list()->addColumn(tr("ShipTo Line3"), 200, Qt::AlignLeft, false, "shiptol3");
list()->addColumn(tr("City/State/Zip"), 200, Qt::AlignLeft, false, "citystatezip");
list()->addColumn(tr("Country"), 120, Qt::AlignLeft, false, "country");
list()->addColumn(tr("Contact"), 120, Qt::AlignLeft, false, "contact");
list()->addColumn(tr("Contact Phone"), 100, Qt::AlignLeft, false, "contact_phone");
list()->addColumn(tr("Contact Fax"), 100, Qt::AlignLeft, false, "contact_fax");
list()->addColumn(tr("Contact Email"), 175, Qt::AlignLeft, false, "contact_email");
list()->addColumn(tr("Phone"), 100, Qt::AlignLeft, false, "phone");
parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date);
parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date);
if (_metrics->boolean("MultiWhs"))
parameterWidget()->append(tr("Site"), "warehouseid", ParameterWidget::Site);
parameterWidget()->appendComboBox(tr("Transaction Type"), "transType", qryTransType);
parameterWidget()->appendComboBox(tr("Multi-Level Trace"), "traceId", qryTrace);
}
dspGLTransactions::dspGLTransactions(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspGLTransactions", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("General Ledger Transactions"));
setListLabel(tr("Transactions"));
setReportName("GLTransactions");
setMetaSQLOptions("gltransactions", "detail");
setUseAltId(true);
setParameterWidgetVisible(true);
QString qryType = QString( "SELECT 1, '%1' UNION "
"SELECT 2, '%2' UNION "
"SELECT 3, '%3' UNION "
"SELECT 4, '%4' UNION "
"SELECT 5, '%5'")
.arg(tr("Asset"))
.arg(tr("Expense"))
.arg(tr("Liability"))
.arg(tr("Equity"))
.arg(tr("Revenue"));
QString qrySubType = QString("SELECT subaccnttype_id, "
" (subaccnttype_code || '-' || subaccnttype_descrip) "
"FROM subaccnttype "
"ORDER BY subaccnttype_code;");
QString qrySource = QString("SELECT 1 AS id, 'A/P' AS source UNION "
"SELECT 2 AS id, 'A/R' AS source UNION "
"SELECT 3 AS id, 'G/L' AS source UNION "
"SELECT 4 AS id, 'I/M' AS source UNION "
"SELECT 5 AS id, 'P/D' AS source UNION "
"SELECT 6 AS id, 'P/O' AS source UNION "
"SELECT 7 AS id, 'S/O' AS source UNION "
"SELECT 8 AS id, 'S/R' AS source UNION "
"SELECT 9 AS id, 'W/O' AS source;");
QString qryAccNum = QString("SELECT min(accnt_id) as num_id,"
" accnt_number AS num_number "
"FROM accnt "
"GROUP BY accnt_number "
"ORDER BY accnt_number;");
connect(parameterWidget(), SIGNAL(filterChanged()), this, SLOT(handleTotalCheckbox()));
connect(_showRunningTotal, SIGNAL(toggled(bool)), this, SLOT(handleTotalCheckbox()));
list()->addColumn(tr("Date"), _dateColumn, Qt::AlignCenter, true, "gltrans_date");
list()->addColumn(tr("Source"), _orderColumn, Qt::AlignCenter, true, "gltrans_source");
list()->addColumn(tr("Doc. Type"), _docTypeColumn, Qt::AlignCenter, !_metrics->boolean("UseJournals"), "gltrans_doctype");
list()->addColumn(tr("Doc. #"), _orderColumn, Qt::AlignCenter, true, "docnumber");
list()->addColumn(tr("Reference"), -1, Qt::AlignLeft, !_metrics->boolean("UseJournals"), "notes");
list()->addColumn(tr("Journal #"), _orderColumn, Qt::AlignLeft, false,"gltrans_journalnumber");
list()->addColumn(tr("Account"), -1, 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("Posted"), _ynColumn, Qt::AlignCenter, false, "gltrans_posted");
list()->addColumn(tr("Username"), _userColumn, Qt::AlignLeft, false, "gltrans_username");
list()->addColumn(tr("Running Total"), _moneyColumn, Qt::AlignRight,false,"running");
_beginningBalance->setPrecision(omfgThis->moneyVal());
_beginningBalanceLit->setVisible(_showRunningTotal->isChecked());
_beginningBalance->setVisible(_showRunningTotal->isChecked());
if (_showRunningTotal->isChecked())
list()->showColumn("running");
else
list()->hideColumn("running");
parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date, QDate::currentDate(), true);
parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date, QDate::currentDate(), true);
parameterWidget()->append(tr("GL Account"), "accnt_id", ParameterWidget::GLAccount);
parameterWidget()->append(tr("Document #"), "docnum", ParameterWidget::Text);
parameterWidget()->appendComboBox(tr("Source"), "source_id", qrySource);
if (_metrics->value("GLCompanySize").toInt() > 0)
parameterWidget()->appendComboBox(tr("Company"), "company_id", XComboBox::Companies);
if (_metrics->value("GLProfitSize").toInt() > 0)
parameterWidget()->appendComboBox(tr("Profit Center"), "prfcntr_id", XComboBox::ProfitCenters);
parameterWidget()->appendComboBox(tr("Main Segment"), "num_id", qryAccNum);
if (_metrics->value("GLSubaccountSize").toInt() > 0)
parameterWidget()->appendComboBox(tr("Sub Account"), "subaccnt_id", XComboBox::Subaccounts);
parameterWidget()->appendComboBox(tr("Account Type"), "accnttype_id", qryType);
parameterWidget()->appendComboBox(tr("Sub Type"), "subType", qrySubType);
parameterWidget()->append(tr("Show Deleted"), "showDeleted", ParameterWidget::Exists);
parameterWidget()->applyDefaultFilterSet();
_sources << "None" << "A/P" << "A/R" << "G/L" << "I/M" << "P/D" << "P/O" << "S/O" << "S/R" << "W/O";
}
projects::projects(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "projects", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Projects"));
setMetaSQLOptions("projects", "detail_nohierarchy");
setReportName("ProjectsList");
setParameterWidgetVisible(true);
setNewVisible(true);
setSearchVisible(true);
setQueryOnStartEnabled(true);
setUseAltId(true);
// Project Details
list()->addColumn(tr("Project"), _orderColumn, Qt::AlignLeft, true, "prj_number");
list()->addColumn(tr("Project Name"), -1, Qt::AlignLeft, true, "prj_name");
list()->addColumn(tr("Project Description"), -1, Qt::AlignLeft, true, "prj_descrip");
list()->addColumn(tr("Status"), _itemColumn, Qt::AlignCenter, true, "project_status" );
list()->addColumn(tr("Project Type"), _itemColumn, Qt::AlignCenter, true, "project_type" );
list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, true, "prj_owner_username");
list()->addColumn(tr("Assigned To"), _userColumn, Qt::AlignLeft, true, "prj_username");
list()->addColumn(tr("Account"), _userColumn, Qt::AlignLeft, true, "crmacct_name");
list()->addColumn(tr("Contact"), _userColumn, Qt::AlignLeft, true, "cntct_name");
list()->addColumn(tr("City"), -1, Qt::AlignLeft, true, "addr_city");
list()->addColumn(tr("State"), -1, Qt::AlignLeft, true, "addr_state");
list()->addColumn(tr("Project Due"), _dateColumn, Qt::AlignCenter, true, "prj_due_date");
list()->addColumn(tr("Project Assigned"), _dateColumn, Qt::AlignCenter, true, "prj_assigned_date");
list()->addColumn(tr("Project Started"), _dateColumn, Qt::AlignCenter, true, "prj_start_date");
list()->addColumn(tr("Project Completed"), _dateColumn, Qt::AlignCenter, true, "prj_completed_date");
connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sOpen()));
if (!_privileges->check("MaintainAllProjects") && !_privileges->check("MaintainPersonalProjects"))
newAction()->setEnabled(false);
_salesOrders->setChecked(false);
_workOrders->setChecked(false);
_purchaseOrders->setChecked(false);
_incidents->setChecked(false);
_showHierarchy->setChecked(false);
connect(omfgThis, SIGNAL(projectsUpdated(int)), this, SLOT(sFillList()));
connect(_showComplete, SIGNAL(toggled(bool)), this, SLOT(sFillList()));
// connect(_salesOrders, SIGNAL(toggled(bool)), this, SLOT(sFillList()));
// connect(_workOrders, SIGNAL(toggled(bool)), this, SLOT(sFillList()));
// connect(_purchaseOrders, SIGNAL(toggled(bool)), this, SLOT(sFillList()));
// connect(_incidents, SIGNAL(toggled(bool)), this, SLOT(sFillList()));
// connect(_showHierarchy, SIGNAL(toggled(bool)), this, SLOT(sBuildList()));
_ordersGroup->hide();
QString qryType = QString( "SELECT prjtype_id, prjtype_descr FROM prjtype " );
QString qryStatus = QString( "SELECT 1, '%1' UNION "
"SELECT 2, '%2' UNION "
"SELECT 3, '%3'")
.arg(tr("Complete"))
.arg(tr("Concept"))
.arg(tr("In-Process"));
parameterWidget()->append(tr("Owner"), "owner_username", ParameterWidget::User);
parameterWidget()->append(tr("AssignedTo"), "assigned_username", ParameterWidget::User);
parameterWidget()->append(tr("Account"), "crmacct_id", ParameterWidget::Crmacct);
parameterWidget()->append(tr("Contact"), "cntct_id", ParameterWidget::Contact);
parameterWidget()->appendComboBox(tr("Project Type"), "prjtype_id", qryType);
parameterWidget()->appendComboBox(tr("Project Status"), "prjstatus_id", qryStatus);
parameterWidget()->append(tr("Project"), "prj_id", ParameterWidget::Project);
parameterWidget()->append(tr("Project Task"), "project_task", ParameterWidget::Text);
parameterWidget()->append(tr("Sales Order"), "cohead_id", ParameterWidget::SalesOrder);
parameterWidget()->append(tr("Work Order"), "wo_id", ParameterWidget::WorkOrder);
parameterWidget()->append(tr("Purchase Order"), "pohead_id", ParameterWidget::PurchaseOrder);
parameterWidget()->append(tr("Start Start Date"), "startStartDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("Start End Date"), "startEndDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("Due Start Date"), "dueStartDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("Due End Date"), "dueEndDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("Assigned Start Date"), "assignedStartDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("Assigned End Date"), "assignedEndDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("Completed Start Date"), "completedStartDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("Completed End Date"), "completedEndDate", ParameterWidget::Date, QDate::currentDate());
setupCharacteristics("PROJ");
_statuses << "None" << "C" << "P" << "O";
// sBuildList();
}
