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(); }