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