void WomatlCluster::setWoid(int pWoid)
{
_source = WorkOrder;
_sourceId = pWoid;
bool qual = FALSE;
QString sql( "SELECT womatl_id AS womatlid, item_number,"
" wo_id, uom_name, item_descrip1, item_descrip2,"
" womatl_qtyreq AS _qtyreq, womatl_qtyiss AS _qtyiss,"
" formatQtyPer(womatl_qtyper) AS qtyper,"
" formatScrap(womatl_scrap) AS scrap,"
" formatQtyPer(womatl_qtyreq) AS qtyreq,"
" formatQtyPer(womatl_qtyiss) AS qtyiss,"
" formatQtyPer(womatl_qtywipscrap) AS qtywipscrap "
"FROM womatl, wo, itemsite, item, uom "
"WHERE ( (womatl_wo_id=wo_id)"
" AND (womatl_itemsite_id=itemsite_id)"
" AND (itemsite_item_id=item_id)"
" AND (womatl_uom_id=uom_id)"
" AND (wo_id=:wo_id)"
" AND (womatl_issuemethod IN (" );
if (_type & Push)
{
sql += "'S'";
qual = TRUE;
}
if (_type & Pull)
{
if (qual)
sql += ",";
else
qual = TRUE;
sql += "'L'";
}
if (_type & Mixed)
{
if (qual)
sql += ",";
sql += "'M'";
}
sql += ")) );";
XSqlQuery query;
query.prepare(sql);
query.bindValue(":wo_id", pWoid);
query.exec();
if (query.first())
{
_womatl.prepare(sql);
_womatl.bindValue(":wo_id", pWoid);
_womatl.exec();
_itemNumber->populate(query);
}
else
{
_id = -1;
_woid = -1;
_valid = FALSE;
_required = 0.0;
_issued = 0.0;
emit newId(-1);
emit newQtyRequired(formatQtyPer(0.0));
emit newQtyIssued(formatQtyPer(0.0));
emit newQtyScrappedFromWIP(formatQtyPer(0.0));
_itemNumber->clear();
}
}
void WomatlCluster::setWoid(int pWoid)
{
_source = WorkOrder;
_sourceId = pWoid;
bool qual = FALSE;
QString sql( "SELECT womatl_id AS womatlid, item_number,"
" wo_id, wo_qtyord, uom_name, item_descrip1, item_descrip2,"
" womatl_qtyreq AS _qtyreq, womatl_qtyiss AS _qtyiss,"
" womatl_qtyper AS qtyper,"
" womatl_scrap * 100 AS scrap,"
" ABS(womatl_qtyreq) AS qtyreq,"
" ABS(womatl_qtyiss) AS qtyiss,"
" womatl_qtywipscrap AS qtywipscrap "
"FROM womatl, wo, itemsite, item, uom "
"WHERE ( (womatl_wo_id=wo_id)"
" AND (womatl_itemsite_id=itemsite_id)"
" AND (itemsite_item_id=item_id)"
" AND (womatl_uom_id=uom_id)"
" AND (wo_id=:wo_id)"
" AND (womatl_issuemethod IN (" );
if (_type & Push)
{
sql += "'S'";
qual = TRUE;
}
if (_type & Pull)
{
if (qual)
sql += ",";
else
qual = TRUE;
sql += "'L'";
}
if (_type & Mixed)
{
if (qual)
sql += ",";
sql += "'M'";
}
sql += ")) );";
_womatl.prepare(sql);
_womatl.bindValue(":wo_id", pWoid);
_womatl.exec();
_itemNumber->populate(_womatl);
if (_womatl.first())
{
if (_womatl.value("wo_qtyord").toDouble() < 0)
{
_qtyRequiredLit->setText("Qty. to Return:");
_qtyIssuedLit->setText("Qty. Returned:");
_sense = -1;
}
else
{
_qtyRequiredLit->setText("Qty. Required:");
_qtyIssuedLit->setText("Qty. Issued:");
_sense = 1;
}
}
else
{
_id = -1;
_woid = -1;
_valid = FALSE;
_required = 0.0;
_issued = 0.0;
emit newId(-1);
emit newQtyRequired(0.0);
emit newQtyIssued(0.0);
emit newQtyScrappedFromWIP(0.0);
_itemNumber->clear();
}
}
