void dspRunningAvailability::sHandleResort()
{
for (int i = 0; i < _availability->topLevelItemCount(); i++)
{
XTreeWidgetItem *item = _availability->topLevelItem(i);
if (item->data(RUNNINGAVAIL_COL, Qt::DisplayRole).toDouble() < 0)
item->setTextColor(RUNNINGAVAIL_COL, namedColor("error"));
else if (item->data(RUNNINGAVAIL_COL, Qt::DisplayRole).toDouble() < _reorderLevel->toDouble())
item->setTextColor(RUNNINGAVAIL_COL, namedColor("warning"));
else
item->setTextColor(RUNNINGAVAIL_COL, namedColor(""));
}
}
void dspRunningAvailability::sHandleResort()
{
for (int i = 0; i < list()->topLevelItemCount(); i++)
{
XTreeWidgetItem *item = list()->topLevelItem(i);
if (item->data(list()->column("runningavail"), Qt::DisplayRole).toDouble() < 0)
item->setTextColor(list()->column("runningavail"), namedColor("error"));
else if (item->data(list()->column("runningavail"), Qt::DisplayRole).toDouble() < _reorderLevel->toDouble())
item->setTextColor(list()->column("runningavail"), namedColor("warning"));
else
item->setTextColor(list()->column("runningavail"), namedColor(""));
}
}
void dspGLTransactions::sPopulateMenu(QMenu * menuThis, QTreeWidgetItem* pItem, int)
{
XTreeWidgetItem * item = (XTreeWidgetItem*)pItem;
if(0 == item)
return;
menuThis->addAction(tr("View..."), this, SLOT(sViewTrans()));
if (item->rawValue("journalnumber").toInt() > 0)
{
QAction* viewSeriesAct = menuThis->addAction(tr("View Journal Series..."), this, SLOT(sViewSeries()));
viewSeriesAct->setDisabled(item->data(0, Xt::DeletedRole).toBool());
}
if(item->rawValue("gltrans_doctype").toString() == "VO")
menuThis->addAction(tr("View Voucher..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "IN")
menuThis->addAction(tr("View Invoice..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "PO")
menuThis->addAction(tr("View Purchase Order..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "SH")
menuThis->addAction(tr("View Shipment..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "CM")
menuThis->addAction(tr("View Credit Memo..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "DM")
menuThis->addAction(tr("View Debit Memo..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "SO")
menuThis->addAction(tr("View Sales Order..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "WO")
menuThis->addAction(tr("View WO History..."), this, SLOT(sViewDocument()));
else if(item->rawValue("gltrans_doctype").toString() == "JP")
menuThis->addAction(tr("View Journal..."), this, SLOT(sViewJournal()));
else if(item->rawValue("gltrans_source").toString() == "I/M")
menuThis->addAction(tr("View Inventory History..."), this, SLOT(sViewDocument()));
}
void voucherItem::sToggleReceiving(QTreeWidgetItem *pItem)
{
XSqlQuery voucherToggleReceiving;
double vch = 0;
double amt = 0;
double rcv = 0;
double rej = 0;
QString s;
XTreeWidgetItem* item = (XTreeWidgetItem*)pItem;
if(item->id() == -1)
return;
// TODO: translation
if (item->text(4) == "Yes")
item->setText(4, "No");
else
item->setText(4, "Yes");
for (int i = 0; i < _uninvoiced->topLevelItemCount(); i++)
{
XTreeWidgetItem *item = _uninvoiced->topLevelItem(i);
double pp = item->data(3, Xt::RawRole).toDouble();
double qty = item->data(2, Xt::RawRole).toDouble();
if (item->text(4) == "Yes")
{
vch = vch + qty;
amt = amt + (qty * pp);
}
else
{
if (item->text(0) == "Receiving")
{
rcv = rcv + qty;
}
else
{
rej = rej + qty;
}
}
}
_qtyToVoucher->setDouble(vch);
_amtToVoucher->setDouble(amt);
_uninvoicedReceived->setDouble(rcv);
_uninvoicedRejected->setDouble(rej);
// Check PO Close flag
if ( ((_ordered->toDouble() <= (_received->toDouble() - _rejected->toDouble()))) && (_uninvoicedReceived->toDouble() == 0) && (_uninvoicedRejected->toDouble() == 0) )
_closePoitem->setChecked(true);
else
_closePoitem->setChecked(false);
// Update the receipt record
if (item->text("f_tagged") == "Yes")
{
if (item->altId() == 1)
voucherToggleReceiving.prepare( "UPDATE recv "
"SET recv_vohead_id=:vohead_id "
"WHERE (recv_id=:target_id);" );
else if (item->altId() == 2)
voucherToggleReceiving.prepare( "UPDATE poreject "
"SET poreject_vohead_id=:vohead_id,poreject_voitem_id=:voitem_id "
"WHERE (poreject_id=:target_id);" );
}
else
{
if (item->altId() == 1)
voucherToggleReceiving.prepare( "UPDATE recv "
"SET recv_vohead_id=NULL "
"WHERE ((recv_id=:target_id)"
" AND (recv_vohead_id=:vohead_id));" );
else if (item->altId() == 2)
voucherToggleReceiving.prepare( "UPDATE poreject "
"SET poreject_vohead_id=NULL,poreject_voitem_id=NULL "
"WHERE ((poreject_id=:target_id)"
" AND (poreject_vohead_id=:vohead_id));" );
}
voucherToggleReceiving.bindValue(":vohead_id", _voheadid);
voucherToggleReceiving.bindValue(":voitem_id", _voitemid);
voucherToggleReceiving.bindValue(":target_id", item->id());
voucherToggleReceiving.exec();
if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Saving Voucher Item Information"),
voucherToggleReceiving, __FILE__, __LINE__))
{
reject();
return;
}
}