dspRunningAvailability::dspRunningAvailability(QWidget* parent, const char* name, Qt::WFlags fl) : XWidget(parent, name, fl) { setupUi(this); connect(_availability, SIGNAL(populateMenu(QMenu*,QTreeWidgetItem*,int)), this, SLOT(sPopulateMenu(QMenu*,QTreeWidgetItem*))); connect(_availability,SIGNAL(resorted()), this, SLOT(sHandleResort())); connect(_item, SIGNAL(newId(int)), this, SLOT(sFillList())); connect(_print, SIGNAL(clicked()), this, SLOT(sPrint())); connect(_showPlanned, SIGNAL(clicked()), this, SLOT(sFillList())); connect(_warehouse, SIGNAL(newID(int)), this, SLOT(sFillList())); _availability->addColumn(tr("Order Type"), _itemColumn, Qt::AlignLeft, true, "ordertype"); _availability->addColumn(tr("Order #"), _itemColumn, Qt::AlignLeft, true, "ordernumber"); _availability->addColumn(tr("Source/Destination"), -1, Qt::AlignLeft, true, "item_number"); _availability->addColumn(tr("Due Date"), _dateColumn, Qt::AlignLeft, true, "duedate"); _availability->addColumn(tr("Ordered"), _qtyColumn, Qt::AlignRight, true, "qtyordered"); _availability->addColumn(tr("Received"), _qtyColumn, Qt::AlignRight, true, "qtyreceived"); _availability->addColumn(tr("Balance"), _qtyColumn, Qt::AlignRight, true, "balance"); _availability->addColumn(tr("Running Avail."), _qtyColumn, Qt::AlignRight, true, "runningavail"); _qoh->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(); } }
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(); } }
void dspRunningAvailability::sFillList() { if (_item->isValid()) { q.prepare( "SELECT itemsite_qtyonhand," " CASE WHEN(itemsite_useparams) THEN itemsite_reorderlevel ELSE 0.0 END AS reorderlevel," " CASE WHEN(itemsite_useparams) THEN itemsite_ordertoqty ELSE 0.0 END AS ordertoqty," " CASE WHEN(itemsite_useparams) THEN itemsite_multordqty ELSE 0.0 END AS multorderqty " "FROM item, itemsite " "WHERE ( (itemsite_item_id=item_id)" " AND (itemsite_warehous_id=:warehous_id)" " AND (item_id=:item_id) );" ); q.bindValue(":item_id", _item->id()); q.bindValue(":warehous_id", _warehouse->id()); q.exec(); if (q.first()) { _qoh->setDouble(q.value("itemsite_qtyonhand").toDouble()); _reorderLevel->setDouble(q.value("reorderlevel").toDouble()); _orderMultiple->setDouble(q.value("multorderqty").toDouble()); _orderToQty->setDouble(q.value("ordertoqty").toDouble()); MetaSQLQuery mql = mqlLoad("runningAvailability", "detail"); ParameterList params; setParams(params); params.append("qoh", q.value("itemsite_qtyonhand").toDouble()); q = mql.toQuery(params); _availability->populate(q, true); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } sHandleResort(); } else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } } else { _qoh->setText("0.00"); _reorderLevel->setText("0.00"); _orderMultiple->setText("0.00"); _orderToQty->setText("0.00"); } }