void WomatlCluster::sPopulateInfo(int pWomatlid) { if (pWomatlid == -1) { _itemNumber->setCurrentIndex(0); _uom->setText(""); _descrip1->setText(""); _descrip2->setText(""); _qtyFxd->setText(""); _qtyPer->setText(""); _scrap->setText(""); _qtyRequired->setText(""); _qtyIssued->setText(""); _id = -1; _valid = FALSE; _required = 0; _issued = 0; emit newId(-1); emit newQtyScrappedFromWIP(0.0); emit valid(FALSE); } else if (_womatl.findFirst("womatlid", pWomatlid) != -1) { _uom->setText(_womatl.value("uom_name").toString()); _descrip1->setText(_womatl.value("item_descrip1").toString()); _descrip2->setText(_womatl.value("item_descrip2").toString()); _qtyFxd->setDouble(_womatl.value("qtyfxd").toDouble()); _qtyPer->setDouble(_womatl.value("qtyper").toDouble()); _scrap->setDouble(_womatl.value("scrap").toDouble()); _qtyRequired->setDouble(_womatl.value("qtyreq").toDouble()); _qtyIssued->setDouble(_womatl.value("qtyiss").toDouble()); _id = pWomatlid; _valid = TRUE; _required = _womatl.value("_qtyreq").toDouble(); _issued = _womatl.value("_qtyiss").toDouble(); emit newId(_id); emit newQtyScrappedFromWIP(_womatl.value("qtywipscrap").toDouble()); emit valid(TRUE); } }
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(); } }