enum SetResponse dspPlannedOrders::set(const ParameterList &pParams) { XWidget::set(pParams); QVariant param; bool valid; parameterWidget()->setSavedFilters(); param = pParams.value("plancode_id", &valid); if (valid) parameterWidget()->setDefault(tr("Planner Code"), param); param = pParams.value("warehous_id", &valid); if (valid) parameterWidget()->setDefault(tr("Site"), param); param = pParams.value("type", &valid); if (valid) { QVariantList list; list.append(param.toString()); parameterWidget()->setDefault(tr("Order Types"), list); } parameterWidget()->applyDefaultFilterSet(); if (pParams.inList("run")) { sFillList(); return NoError_Run; } return NoError; }
bool dspTimePhasedSales::setParamsTP(ParameterList & params) { parameterWidget()->appendValue(params); params.append("filter", parameterWidget()->filter()); int idx = _groupBy->id(); if (idx == 1) params.append("byProdcat"); else if (idx == 2) params.append("byItem"); else params.append("byCust"); idx = _units->id(); if (idx == 1) params.append("inventoryUnits"); else if (idx == 2) params.append("capacityUnits"); else if (idx == 3) params.append("altCapacityUnits"); else params.append("salesDollars"); params.append("baseCurrAbbr", CurrDisplay::baseCurrAbbr()); return true; }
employees::employees(QWidget* parent, const char*, Qt::WFlags fl) : display(parent, "employees", fl) { setWindowTitle(tr("Employees")); setReportName("EmployeeList"); setMetaSQLOptions("employees", "detail"); setParameterWidgetVisible(true); setNewVisible(true); setSearchVisible(true); setQueryOnStartEnabled(true); parameterWidget()->append(tr("Show Inactive"), "showInactive", ParameterWidget::Exists); if (_metrics->boolean("MultiWhs")) parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site); parameterWidget()->applyDefaultFilterSet(); connect(omfgThis, SIGNAL(employeesUpdated(int)), this, SLOT(sFillList())); list()->addColumn(tr("Site"), _whsColumn, Qt::AlignLeft, true, "warehous_code"); list()->addColumn(tr("Active"), _ynColumn, Qt::AlignLeft, true, "emp_active"); list()->addColumn(tr("Code"), _itemColumn, Qt::AlignLeft, true, "emp_code"); list()->addColumn(tr("Number"), -1, Qt::AlignLeft, true, "emp_number"); list()->addColumn(tr("First"), _itemColumn, Qt::AlignLeft, true, "cntct_first_name"); list()->addColumn(tr("Last"), _itemColumn, Qt::AlignLeft, true, "cntct_last_name"); setupCharacteristics(characteristic::Employees); parameterWidget()->applyDefaultFilterSet(); connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sOpen())); if (!_privileges->check("MaintainEmployees")) newAction()->setEnabled(FALSE); }
enum SetResponse dspJournals::set(const ParameterList &pParams) { XWidget::set(pParams); parameterWidget()->setSavedFilters(); QVariant param; bool valid; param = pParams.value("accnt_id", &valid); if (valid) parameterWidget()->setDefault(tr("GL Account"), param); param = pParams.value("startDate", &valid); if (valid) parameterWidget()->setDefault(tr("Start Date"), param); param = pParams.value("endDate", &valid); if (valid) parameterWidget()->setDefault(tr("End Date"), param); param = pParams.value("posted", &valid); if (valid) parameterWidget()->setDefault(tr("Posted"), param); param = pParams.value("journalnumber", &valid); if (valid) parameterWidget()->setDefault(tr("GL Journal"), param); param = pParams.value("source", &valid); if (valid) parameterWidget()->setDefault(tr("Source Pattern"), param.toString()); param = pParams.value("period_id", &valid); if (valid) { q.prepare( "SELECT period_start, period_end " "FROM period " "WHERE (period_id=:period_id);" ); q.bindValue(":period_id", param.toInt()); q.exec(); if (q.first()) { parameterWidget()->setDefault(tr("Start Date"), q.value("period_start").toDate()); parameterWidget()->setDefault(tr("End Date"), q.value("period_end").toDate()); } } parameterWidget()->applyDefaultFilterSet(); if (pParams.inList("run")) { sFillList(); return NoError_Run; } return NoError; }
todoList::todoList(QWidget* parent, const char*, Qt::WFlags fl) : display(parent, "todoList", fl) { setupUi(optionsWidget()); setWindowTitle(tr("To-Do Items")); setReportName("TodoList"); setMetaSQLOptions("todolist", "detail"); setUseAltId(true); setParameterWidgetVisible(true); setNewVisible(true); setQueryOnStartEnabled(true); parameterWidget()->append(tr("Assigned"), "assigned_username", ParameterWidget::User, omfgThis->username()); parameterWidget()->append(tr("Assigned Pattern"), "assigned_usr_pattern", ParameterWidget::Text); parameterWidget()->append(tr("Owner"), "owner_username", ParameterWidget::User); parameterWidget()->append(tr("Owner Pattern"), "owner_usr_pattern", ParameterWidget::Text); parameterWidget()->append(tr("CRM Account"), "crmacct_id", ParameterWidget::Crmacct); parameterWidget()->append(tr("Start Date Before"), "startStartDate", ParameterWidget::Date); parameterWidget()->append(tr("Start Date After"), "startEndDate", ParameterWidget::Date); parameterWidget()->append(tr("Due Date Before"), "dueStartDate", ParameterWidget::Date); parameterWidget()->append(tr("Due Date After"), "dueEndDate", ParameterWidget::Date); parameterWidget()->applyDefaultFilterSet(); connect(_completed, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_todolist, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_incidents, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_projects, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(list(), SIGNAL(itemSelected(int)), this, SLOT(sEdit())); list()->addColumn(tr("Type"), _userColumn, Qt::AlignCenter, true, "type"); list()->addColumn(tr("Seq"), _seqColumn, Qt::AlignRight, false, "seq"); list()->addColumn(tr("Priority"), _userColumn, Qt::AlignLeft, true, "priority"); list()->addColumn(tr("Assigned To"),_userColumn, Qt::AlignLeft, true, "usr"); list()->addColumn(tr("Name"), 100, Qt::AlignLeft, true, "name"); list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "descrip"); list()->addColumn(tr("Status"), _statusColumn, Qt::AlignLeft, true, "status"); list()->addColumn(tr("Start Date"),_dateColumn, Qt::AlignLeft, false, "start"); list()->addColumn(tr("Due Date"), _dateColumn, Qt::AlignLeft, true, "due"); list()->addColumn(tr("Parent#"), _orderColumn, Qt::AlignLeft, true, "number"); list()->addColumn(tr("Customer#"),_orderColumn, Qt::AlignLeft, false, "cust"); list()->addColumn(tr("Account#"), _orderColumn, Qt::AlignLeft, false, "crmacct_number"); list()->addColumn(tr("Account Name"), 100, Qt::AlignLeft, true, "crmacct_name"); list()->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, false,"owner"); QToolButton * newBtn = (QToolButton*)toolBar()->widgetForAction(newAction()); newBtn->setPopupMode(QToolButton::MenuButtonPopup); QAction *menuItem; QMenu * todoMenu = new QMenu; menuItem = todoMenu->addAction(tr("Incident"), this, SLOT(sNewIncdt())); menuItem->setEnabled(_privileges->check("MaintainIncidents")); menuItem = todoMenu->addAction(tr("To-Do Item"), this, SLOT(sNew())); menuItem->setShortcut(QKeySequence::New); menuItem->setEnabled(_privileges->check("MaintainPersonalTodoList") || _privileges->check("MaintainOtherTodoLists")); newBtn->setMenu(todoMenu); }
dspUsageStatistics::dspUsageStatistics(QWidget* parent, const char* name, Qt::WFlags fl) : display(parent, name, fl) { setWindowTitle(tr("Item Usage Statistics")); setReportName("UsageStatistics"); setMetaSQLOptions("usageStatistics", "detail"); setUseAltId(true); setParameterWidgetVisible(true); _printing = false; 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()->applyDefaultFilterSet(); 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" ); }
dspQOH::dspQOH(QWidget* parent, const char*, Qt::WFlags fl) : display(parent, "dspQOH", fl) { setupUi(optionsWidget()); setWindowTitle(tr("Quantities on Hand")); setReportName("QOH"); setMetaSQLOptions("qoh", "detail"); setUseAltId(true); setParameterWidgetVisible(true); _costsGroupInt = new QButtonGroup(this); _costsGroupInt->addButton(_useStandardCosts); _costsGroupInt->addButton(_useActualCosts); _costsGroupInt->addButton(_usePostedCosts); _showGroupInt = new QButtonGroup(this); _showGroupInt->addButton(_showAll); _showGroupInt->addButton(_showPositive); _showGroupInt->addButton(_showNegative); parameterWidget()->appendComboBox(tr("Class Code"), "classcode_id", XComboBox::ClassCodes); parameterWidget()->append(tr("Class Code Pattern"), "classcode_pattern", ParameterWidget::Text); parameterWidget()->appendComboBox(tr("Cost Category"), "costcat_id", XComboBox::CostCategories); parameterWidget()->append(tr("Cost Category Pattern"), "costcat_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); if (_metrics->boolean("EnableAsOfQOH")) parameterWidget()->appendComboBox(tr("As Of"), "asOf", XComboBox::AccountingPeriods); connect(_showValue, SIGNAL(toggled(bool)), this, SLOT(sHandleValue(bool))); 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("Class Code"), _itemColumn, Qt::AlignLeft, true, "classcode_code" ); list()->addColumn(tr("Cost Category"), _itemColumn, Qt::AlignLeft, false, "costcat_code" ); list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter, true, "uom_name" ); list()->addColumn(tr("Default Location"), _itemColumn, Qt::AlignLeft, true, "defaultlocation" ); list()->addColumn(tr("Reorder Lvl."), _qtyColumn, Qt::AlignRight, true, "reorderlevel" ); list()->addColumn(tr("QOH"), _qtyColumn, Qt::AlignRight, true, "qoh" ); list()->addColumn(tr("Non-Netable"), _qtyColumn, Qt::AlignRight, true, "nnqoh" ); list()->addColumn(tr("Unit Cost"), _costColumn, Qt::AlignRight, true, "cost" ); list()->addColumn(tr("Value"), _costColumn, Qt::AlignRight, true, "value" ); list()->addColumn(tr("NN Value"), _costColumn, Qt::AlignRight, true, "nnvalue" ); list()->addColumn(tr("Cost Method"), _costColumn, Qt::AlignCenter, true, "costmethod" ); sHandleValue(_showValue->isChecked()); _showValue->setEnabled(_privileges->check("ViewInventoryValue")); }
SetResponse dspQOHByZone::set(const ParameterList &pParams) { XWidget::set(pParams); QVariant param; bool valid; parameterWidget()->setSavedFilters(); param = pParams.value("whsezone_id", &valid); if (valid) parameterWidget()->setDefault(tr("Zone"), param); parameterWidget()->applyDefaultFilterSet(); return NoError; }
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); }
dspQOHByZone::dspQOHByZone(QWidget* parent, const char*, Qt::WindowFlags fl) : display(parent, "dspQOHByZone", fl) { setupUi(optionsWidget()); setWindowTitle(tr("Quantities on Hand By Zone")); setReportName("QOHByZone"); setMetaSQLOptions("qoh", "detailByZone"); setUseAltId(true); setParameterWidgetVisible(true); QString _zoneSQL ("SELECT whsezone_id, warehous_code||' :- '||whsezone_name||' - '||whsezone_descrip " "FROM whsezone " "JOIN whsinfo ON (warehous_id=whsezone_warehous_id) " " ORDER BY warehous_code, whsezone_name;"); //if (_metrics->boolean("MultiWhs")) // parameterWidget()->append(tr("Site"), "warehous_id", ParameterWidget::Site, "", true); // TODO filter Zone based on Site selection parameterWidget()->appendComboBox(tr("Zone"), "whsezone_id", _zoneSQL, "", true); if (_metrics->boolean("MultiWhs")) list()->addColumn(tr("Site"), _whsColumn, Qt::AlignCenter, true, "warehous_code" ); list()->addColumn(tr("Zone"), _whsColumn, Qt::AlignCenter, true, "whsezone_name" ); list()->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft, true, "item_number" ); list()->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "item_descrip1" ); list()->addColumn(tr("UOM"), _uomColumn, Qt::AlignCenter, true, "uom_name" ); list()->addColumn(tr("Location"), _itemColumn, Qt::AlignLeft, false, "location_descrip" ); list()->addColumn(tr("QOH"), _qtyColumn, Qt::AlignRight, true, "qoh" ); list()->addColumn(tr("Aisle"), -1, Qt::AlignLeft, false, "location_aisle" ); list()->addColumn(tr("Rack"), -1, Qt::AlignLeft, false, "location_rack" ); list()->addColumn(tr("Bin"), -1, Qt::AlignLeft, false, "location_bin" ); }
void dspPlannedOrders::sDspUsageStatistics() { XSqlQuery dspDspUsageStatistics; dspDspUsageStatistics.prepare("SELECT itemsite_item_id " "FROM itemsite " "WHERE (itemsite_id=:itemsite_id);"); dspDspUsageStatistics.bindValue(":itemsite_id", list()->altId()); dspDspUsageStatistics.exec(); if (dspDspUsageStatistics.first()) { ParameterList params = parameterWidget()->parameters(); params.append("item_id", dspDspUsageStatistics.value("itemsite_item_id")); params.append("run"); dspUsageStatistics *newdlg = new dspUsageStatistics(); SetResponse setresp = newdlg->set(params); if (setresp == NoError || setresp == NoError_Run) omfgThis->handleNewWindow(newdlg); } else if (dspDspUsageStatistics.lastError().type() != QSqlError::NoError) { systemError(this, dspDspUsageStatistics.lastError().databaseText(), __FILE__, __LINE__); return; } }
SetResponse dspQOH::set(const ParameterList &pParams) { XWidget::set(pParams); QVariant param; bool valid; parameterWidget()->setSavedFilters(); param = pParams.value("classcode_id", &valid); if (valid) parameterWidget()->setDefault(tr("Class Code"), param); param = pParams.value("classcode_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Class Code Pattern"), param); param = pParams.value("costcat_id", &valid); if (valid) parameterWidget()->setDefault(tr("Cost Category"), param); param = pParams.value("costcat_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Cost Category Pattern"), param); param = pParams.value("item_id", &valid); if (valid) parameterWidget()->setDefault(tr("Item"), param); param = pParams.value("itemgrp_id", &valid); if (valid) parameterWidget()->setDefault(tr("Item Group"), param); param = pParams.value("itemgrp_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Item Group Pattern"), param); param = pParams.value("warehous_id", &valid); if (valid) parameterWidget()->setDefault(tr("Site"), param); parameterWidget()->applyDefaultFilterSet(); if (pParams.inList("run")) sFillList(); return NoError; }
bool display::setParams(ParameterList & params) { parameterWidget()->appendValue(params); if (!_data->_search->isNull()) params.append("search_pattern", _data->_search->text()); return true; }
bool dspSalesOrders::setParams(ParameterList & params) { parameterWidget()->appendValue(params); params.append("noLines", tr("No Lines")); params.append("closed", tr("Closed")); params.append("open", tr("Open")); params.append("partial", tr("Partial")); return true; }
void todoList::sNewOpportunity() { ParameterList params; parameterWidget()->appendValue(params); params.append("mode", "new"); opportunity newdlg(this, "", true); newdlg.set(params); if (newdlg.exec() != XDialog::Rejected) sFillList(); }
void dspTimePhasedSales::sViewHistory() { ParameterList params; parameterWidget()->appendValue(params); params.append("filter", parameterWidget()->filter()); if (_groupBy->id() == 1) params.append("prodcat_id", list()->id()); else if (_groupBy->id() == 2) params.append("item_id", list()->id()); else params.append("cust_id", list()->id()); params.append("warehous_id", list()->altId()); params.append("startDate", _columnDates[_column - 4].startDate); params.append("endDate", _columnDates[_column - 4].endDate); params.append("run"); dspSalesHistory *newdlg = new dspSalesHistory(); newdlg->set(params); omfgThis->handleNewWindow(newdlg); }
bool opportunityList::setParams(ParameterList ¶ms) { parameterWidget()->appendValue(params); if (!searchText().isEmpty()) params.append("searchpattern", searchText()); if (!findChild<QCheckBox*>("_showInactive")->isChecked()) params.append("activeOnly"); return true; }
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(); }
void todoList::sNew() { ParameterList params; parameterWidget()->appendValue(params); params.append("mode", "new"); //if (_selected->isChecked()) // params.append("username", _usr->username()); todoItem newdlg(this, "", TRUE); newdlg.set(params); if (newdlg.exec() != XDialog::Rejected) sFillList(); }
void dspGLTransactions::handleTotalCheckbox() { ParameterList params; parameterWidget()->appendValue(params); _showRunningTotal->setVisible(params.inList("accnt_id") && !params.inList("source_id") && !params.inList("docnum")); _beginningBalanceLit->setVisible(_showRunningTotal->isChecked() && _showRunningTotal->isVisible()); _beginningBalance->setVisible(_showRunningTotal->isChecked() && _showRunningTotal->isVisible()); }
bool dspDetailedInventoryHistoryByLotSerial::setParams(ParameterList ¶ms) { if (!display::setParams(params)) return false; QString trace = "N"; params = parameterWidget()->parameters(); if ( ((_selected->isChecked() && _lotSerial->number().trimmed().length() == 0) || (_pattern->isChecked() && _lotSerialPattern->text().trimmed().length() == 0)) && (!_item->isValid()) ) { QMessageBox::warning( this, tr("Enter Lot/Serial #"), tr("<p>You must enter a Lot/Serial or Item criteria to print Inventory " "Detail by Lot/Serial #.</p>") ); _lotSerial->setFocus(); return false; } bool valid; QVariant param; param = params.value("traceId", &valid); if (valid) { int traceid = param.toInt(); if (traceid) trace = "B"; else trace = "F"; } if (_item->isValid()) params.append("itemid", _item->id()); params.append("trace", trace); if (_selected->isChecked()) { if (_lotSerial->number().trimmed().length() > 0) params.append("lotSerial", _lotSerial->number().trimmed()); } else { params.append("pattern", "t"); params.append("lotSerial", _lotSerialPattern->text().trimmed().toUpper()); } return true; }
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" ); }
enum SetResponse dspBacklog::set(const ParameterList &pParams) { XWidget::set(pParams); QVariant param; bool valid; param = pParams.value("custtype_id", &valid); if (valid) parameterWidget()->setDefault(tr("Customer Type"), param); param = pParams.value("custtype_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Customer Type Pattern"), param); param = pParams.value("custgrp_id", &valid); if (valid) parameterWidget()->setDefault(tr("Customer Group"), param); param = pParams.value("custgrp_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Customer Group Pattern"), param); param = pParams.value("prodcat_id", &valid); if (valid) parameterWidget()->setDefault(tr("Product Category"), param); param = pParams.value("prodcat_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Product Category Pattern"), param); param = pParams.value("item_id", &valid); if (valid) parameterWidget()->setDefault(tr("Item"), param); param = pParams.value("sohead_id", &valid); if (valid) parameterWidget()->setDefault(tr("Sales Order"), param); if (pParams.inList("run")) { sFillList(); return NoError_Run; } return NoError; }
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(); }
void todoList::sNew() { //Need an extra priv check because of display trigger if (!_privileges->check("MaintainPersonalToDoItems") && !_privileges->check("MaintainAllToDoItems")) return; ParameterList params; parameterWidget()->appendValue(params); params.append("mode", "new"); todoItem newdlg(this, "", true); newdlg.set(params); if (newdlg.exec() != XDialog::Rejected) sFillList(); }
bool dspSubLedger::setParams(ParameterList ¶ms) { parameterWidget()->appendValue(params); bool valid; QVariant param; param = params.value("accnttype_id", &valid); if (valid) { int typid = param.toInt(); QString type; if (typid == 1) type = "A"; else if (typid ==2) type = "E"; else if (typid ==3) type = "L"; else if (typid ==4) type = "Q"; else if (typid ==5) type = "R"; params.append("accntType", type); } param = params.value("source_id", &valid); if (valid) params.append("source", _sources.at(param.toInt())); param = params.value("num_id", &valid); if (valid) { XSqlQuery num; num.prepare("SELECT accnt_number " "FROM accnt " "WHERE (accnt_id=:accnt_id);"); num.bindValue(":accnt_id", params.value("num_id").toInt()); num.exec(); if (num.first()) params.append("accnt_number", num.value("accnt_number").toString()); } return true; }
enum SetResponse dspGLTransactions::set(const ParameterList &pParams) { XSqlQuery dspet; XWidget::set(pParams); parameterWidget()->setSavedFilters(); QVariant param; bool valid; param = pParams.value("accnt_id", &valid); if (valid) parameterWidget()->setDefault(tr("GL Account"), param.toInt()); param = pParams.value("startDate", &valid); if (valid) parameterWidget()->setDefault(tr("Start Date"), param.toDate()); param = pParams.value("endDate", &valid); if (valid) parameterWidget()->setDefault(tr("End Date"), param.toDate()); param = pParams.value("period_id", &valid); if (valid) { dspet.prepare( "SELECT period_start, period_end " "FROM period " "WHERE (period_id=:period_id);" ); dspet.bindValue(":period_id", param.toInt()); dspet.exec(); if (dspet.first()) { parameterWidget()->setDefault(tr("Start Date"), dspet.value("period_start").toDate()); parameterWidget()->setDefault(tr("End Date"), dspet.value("period_end").toDate()); } } parameterWidget()->applyDefaultFilterSet(); if (pParams.inList("run")) { emit fillList(); return NoError_Run; } return NoError; }
enum SetResponse dspUsageStatistics::set(const ParameterList &pParams) { XWidget::set(pParams); QVariant param; bool valid; parameterWidget()->setSavedFilters(); param = pParams.value("item_id", &valid); if (valid) parameterWidget()->setDefault(tr("Item"), param); param = pParams.value("warehous_id", &valid); if (valid) { if (param.toInt() > 0) parameterWidget()->setDefault(tr("Site"), param); } param = pParams.value("startDate", &valid); if (valid) parameterWidget()->setDefault(tr("Start Date"), param); else parameterWidget()->setDefault(tr("Start Date"), omfgThis->startOfTime()); param = pParams.value("endDate", &valid); if (valid) parameterWidget()->setDefault(tr("End Date"), param); else parameterWidget()->setDefault(tr("End Date"), omfgThis->endOfTime()); parameterWidget()->applyDefaultFilterSet(); if (pParams.inList("run")) { sFillList(); return NoError_Run; } return NoError; }
bool dspInventoryLocator::setParams(ParameterList ¶ms) { if(!_item->isValid()) { QMessageBox::warning( this, tr("Enter a Valid Item Number"), tr("You must enter a valid Item Number for this report.") ); return false; } _warehouse->appendValue(params); params.append("item_id", _item->id()); params.append("yes", tr("Yes")); params.append("no", tr("No")); params.append("na", tr("N/A")); ParameterList widgetParams = parameterWidget()->parameters(); foreach(const Parameter &p, widgetParams) { params.append(p); }
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"); }