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