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();
}
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();
}
dspCustomersByCustomerType::dspCustomersByCustomerType(QWidget* parent, const char*, Qt::WFlags fl)
: display(parent, "dspCustomersByCustomerType", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Customers by Customer Type"));
setListLabel(tr("Customers"));
setReportName("CustomersByCustomerType");
setMetaSQLOptions("customer", "detail");
setAutoUpdateEnabled(true);
_customerType->setType(ParameterGroup::CustomerType);
list()->addColumn(tr("Type"), _itemColumn, Qt::AlignLeft, true, "custtype_code");
list()->addColumn(tr("Active"), _ynColumn, Qt::AlignLeft, true, "cust_active");
list()->addColumn(tr("Number"), _itemColumn, Qt::AlignLeft, true, "cust_number");
list()->addColumn(tr("Name"), 200, Qt::AlignLeft, true, "cust_name");
list()->addColumn(tr("Address"), -1, Qt::AlignLeft, true, "cust_address1");
list()->setDragString("custid=");
connect(omfgThis, SIGNAL(customersUpdated(int, bool)), SLOT(sFillList()));
}
dspSalesOrders::dspSalesOrders(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "dspSalesOrders", fl)
{
setupUi(optionsWidget());
setWindowTitle(tr("Sales Orders"));
setListLabel(tr("Sales Orders"));
setMetaSQLOptions("salesOrders", "detail");
/* setReportName("ListSalesOrders"); */
setParameterWidgetVisible(true);
setNewVisible(true);
setQueryOnStartEnabled(false);
setAutoUpdateEnabled(true);
if (_metrics->boolean("MultiWhs"))
parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site);
parameterWidget()->append(tr("Customer"), "cust_id", ParameterWidget::Customer);
parameterWidget()->appendComboBox(tr("Customer Type"), "custtype_id", XComboBox::CustomerTypes);
parameterWidget()->append(tr("Customer Type Pattern"), "custtype_pattern", ParameterWidget::Text);
parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date, QDate::currentDate());
parameterWidget()->append(tr("P/O Number"), "poNumber", ParameterWidget::Text);
parameterWidget()->append(tr("Project"), "prj_id", ParameterWidget::Project);
parameterWidget()->appendComboBox(tr("Sales Rep."), "salesrep_id", XComboBox::SalesRepsActive);
parameterWidget()->appendComboBox(tr("Sale Type"), "saletype_id", XComboBox::SaleTypes);
parameterWidget()->append(tr("Hide Closed"), "hideClosed", ParameterWidget::Exists);
list()->addColumn(tr("Customer"), _itemColumn, Qt::AlignLeft, true, "cust_number" );
list()->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "cohead_number" );
list()->addColumn(tr("Sale Type"), _orderColumn, Qt::AlignLeft, true, "saletype_descr" );
list()->addColumn(tr("Ordered"), _dateColumn, Qt::AlignRight, true, "cohead_orderdate" );
list()->addColumn(tr("Scheduled"), _dateColumn, Qt::AlignRight, true, "min_scheddate" );
list()->addColumn(tr("Status"), _itemColumn, Qt::AlignCenter, true, "order_status" );
list()->addColumn(tr("Ship-to"), -1, Qt::AlignLeft, true, "cohead_shiptoname" );
list()->addColumn(tr("Cust. P/O #"), 200, Qt::AlignLeft, true, "cohead_custponumber" );
parameterWidget()->applyDefaultFilterSet();
connect(omfgThis, SIGNAL(salesOrdersUpdated(int, bool)), this, SLOT(sFillList()) );
}
incidentWorkbench::incidentWorkbench(QWidget* parent, const char*, Qt::WindowFlags fl)
: display(parent, "incidentWorkbench", fl)
{
setWindowTitle(tr("Incidents"));
setListLabel(tr("Incidents"));
setReportName("IncidentWorkbenchList");
setMetaSQLOptions("incidents", "detail");
setParameterWidgetVisible(true);
setNewVisible(_privileges->check("MaintainAllIncidents") || _privileges->check("MaintainPersonalIncidents"));
setSearchVisible(true);
setQueryOnStartEnabled(true);
setAutoUpdateEnabled(true);
QString qryStatus = QString("SELECT status_seq, "
" CASE WHEN status_code = 'N' THEN '%1' "
" WHEN status_code = 'F' THEN '%2' "
" WHEN status_code = 'C' THEN '%3' "
" WHEN status_code = 'A' THEN '%4' "
" WHEN status_code = 'R' THEN '%5' "
" WHEN status_code = 'L' THEN '%6' "
" END AS name, status_code AS code "
"FROM status; ")
.arg(tr("New"))
.arg(tr("Feedback"))
.arg(tr("Confirmed"))
.arg(tr("Assigned"))
.arg(tr("Resolved"))
.arg(tr("Closed"));
QString qryPriority = "SELECT incdtpriority_id, incdtpriority_name "
"FROM incdtpriority "
"ORDER BY incdtpriority_order, incdtpriority_name ";
parameterWidget()->append(tr("Account"), "crmAccountId", ParameterWidget::Crmacct);
parameterWidget()->append(tr("Contact"),"cntct_id", ParameterWidget::Contact);
parameterWidget()->append(tr("Category"), "categorylist",
ParameterWidget::Multiselect, QVariant(), false,
"SELECT incdtcat_id, incdtcat_name"
" FROM incdtcat"
" ORDER BY incdtcat_name;");
parameterWidget()->appendComboBox(tr("Status Above"), "status_above", qryStatus, 4);
parameterWidget()->append(tr("Status"), "statuslist",
ParameterWidget::Multiselect, QVariant(), false,
qryStatus);
parameterWidget()->appendComboBox(tr("Severity"), "severity_id", XComboBox::IncidentSeverity);
parameterWidget()->append(tr("User"), "username", ParameterWidget::User, omfgThis->username());
parameterWidget()->append(tr("Owner"), "owner_username", ParameterWidget::User);
parameterWidget()->append(tr("Assigned To"), "assigned_username", ParameterWidget::User);
parameterWidget()->append(tr("Start Date"), "startDate", ParameterWidget::Date);
parameterWidget()->append(tr("End Date"), "endDate", ParameterWidget::Date);
parameterWidget()->append(tr("Priority"), "incdtpriority_id_list", ParameterWidget::Multiselect, QVariant(), false, qryPriority);
parameterWidget()->append(tr("Project"), "prj_id", ParameterWidget::Project);
if(_metrics->boolean("IncidentsPublicPrivate"))
parameterWidget()->append(tr("Public"), "public", ParameterWidget::CheckBox);
parameterWidget()->append(tr("Item"), "item_id", ParameterWidget::Item);
if (_metrics->boolean("LotSerialControl"))
parameterWidget()->append(tr("Lot/Serial Pattern"), "lspattern", ParameterWidget::Text);
parameterWidget()->applyDefaultFilterSet();
connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sOpen()));
if (!_privileges->check("MaintainAllIncidents") && !_privileges->check("MaintainPersonalIncidents"))
newAction()->setEnabled(false);
list()->addColumn(tr("Number"), _orderColumn,Qt::AlignLeft, true, "incdt_number" );
list()->addColumn(tr("Created"), _dateColumn, Qt::AlignLeft, true, "incdt_timestamp" );
list()->addColumn(tr("Account"), _itemColumn, Qt::AlignLeft, true, "crmacct_name" );
list()->addColumn(tr("Status"), _itemColumn, Qt::AlignLeft, true, "incdt_status" );
list()->addColumn(tr("Updated"), _dateColumn, Qt::AlignLeft, true, "incdt_updated" );
list()->addColumn(tr("Assigned To"), _userColumn, Qt::AlignLeft, true, "incdt_assigned_username" );
list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, true, "incdt_owner_username" );
list()->addColumn(tr("Summary"), -1, Qt::AlignLeft, true, "incdt_summary" );
list()->addColumn(tr("Category"), _userColumn, Qt::AlignLeft, false, "incdtcat_name");
list()->addColumn(tr("Severity"), _userColumn, Qt::AlignLeft, false, "incdtseverity_name");
list()->addColumn(tr("Priority"), _userColumn, Qt::AlignLeft, false, "incdtpriority_name");
list()->addColumn(tr("Contact"), _userColumn, Qt::AlignLeft, false, "cntct_name");
list()->addColumn(tr("Project"), _userColumn, Qt::AlignLeft, false, "prj_number");
if(_metrics->boolean("IncidentsPublicPrivate"))
list()->addColumn(tr("Public"), _userColumn, Qt::AlignLeft, false, "incdt_public");
list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, false, "item_number");
list()->addColumn(tr("Lot/Serial"), _itemColumn, Qt::AlignLeft, false, "ls_number");
setupCharacteristics("INCDT");
parameterWidget()->applyDefaultFilterSet();
}
