void dspReservations::sFillList() { _allocations->clear(); if (_item->isValid()) { MetaSQLQuery mql = mqlLoad(":so/displays/Reservations/FillListDetail.mql"); ParameterList params; params.append("warehous_id", _warehouse->id()); params.append("item_id", _item->id()); q = mql.toQuery(params); double runningBal = 0; XTreeWidgetItem *last = 0; while (q.next()) { runningBal += q.value("coitem_qtyreserved").toDouble(); last = new XTreeWidgetItem(_allocations, last, q.value("source_id").toInt(), q.value("order_number"), q.value("totalqty"), q.value("relievedqty"), q.value("balanceqty"), formatQty(runningBal), q.value("duedate") ); last->setTextColor(5, "red"); } if (q.lastError().type() != QSqlError::None) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } QString avails("SELECT formatQty(itemsite_qtyonhand) AS f_qoh," " formatQty(qtyunreserved(itemsite_id)) AS f_unreserved " "FROM itemsite " "WHERE ((itemsite_item_id=<? value(\"item_id\") ?>)" " AND (itemsite_warehous_id=<? value(\"warehous_id\") ?>));"); MetaSQLQuery availm(avails); q = availm.toQuery(params); if (q.first()) { _qoh->setText(q.value("f_qoh").toString()); _available->setText(q.value("f_unreserved").toString()); } else if (q.lastError().type() != QSqlError::None) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } } }
void assessFinanceCharges::sFillList() { _invoiceList->clear(); XSqlQuery arFillInvoiceList; MetaSQLQuery mql = mqlLoad("assessFinanceCharges", "detail"); ParameterList params; _customerSelector->appendValue(params); params.append("assessmentDate", _assessmentDate->date()); arFillInvoiceList = mql.toQuery(params); _invoiceList->populate(arFillInvoiceList); }
void dspBankrecHistory::sFillList() { q.prepare( "SELECT bankrec_username, " " bankrec_posted," " bankrec_postdate," " bankrec_opendate," " bankrec_enddate," " bankrec_openbal," " bankrec_endbal " "FROM bankrec " "WHERE (bankrec_id=:bankrecid);" ); q.bindValue(":bankrecid", _bankrec->id()); q.exec(); if(q.first()) { _poster->setText(q.value("bankrec_username").toString()); _postdate->setDate(q.value("bankrec_postdate").toDate()); ParameterList params; params.append("treeView", true); if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("bankrecHistory", "reconciled"); q = mql.toQuery(params); _rec->populate(q, true); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } else _rec->expandAll(); if (_showUnreconciled->isChecked()) { ParameterList params2; params2.append("treeView", true); if (! setParams(params2)) return; MetaSQLQuery mql2 = mqlLoad("bankrecHistory", "unreconciled"); q = mql2.toQuery(params2); _unrec->populate(q, true); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } else _unrec->expandAll(); } } }
void cashReceiptsEditList::sFillList() { XSqlQuery cashFillList; ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("unpostedCashReceipts", "detail"); cashFillList = mql.toQuery(params); _cashrcpt->populate(cashFillList); }
void itemSourceList::sFillList() { XSqlQuery itemFillList; MetaSQLQuery mql = mqlLoad("itemSources", "detail"); ParameterList params; params.append("item_id", _item->id()); params.append("onlyShowActive", true); itemFillList = mql.toQuery(params); _itemsrc->populate(itemFillList); }
void updatePrices::sRemove() { XSqlQuery updateRemove; MetaSQLQuery mql = mqlLoad("updateprices", "remove"); ParameterList params; params.append("ipshead_id", _sel->id()); updateRemove = mql.toQuery(params); if (updateRemove.lastError().type() != QSqlError::NoError) systemError(this, updateRemove.lastError().databaseText(), __FILE__, __LINE__); populate(); }
void printPackingListBatchByShipvia::sPopulateShipVia() { ParameterList params; if (_metrics->boolean("MultiWhs")) params.append("MultiWhs"); MetaSQLQuery mql = mqlLoad("packingListBatchByShipVia", "shipVia"); q = mql.toQuery(params); _shipvia->populate(q); if (q.lastError().type() != QSqlError::NoError) systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); }
void creditMemoItem::sPopulateUOM() { if (_item->id() != -1) { // Get list of active, valid Selling UOMs MetaSQLQuery muom = mqlLoad("uoms", "item"); ParameterList params; params.append("uomtype", "Selling"); params.append("item_id", _item->id()); // Include Global UOMs if (_privileges->check("MaintainUOMs")) { params.append("includeGlobal", true); params.append("global", tr("-Global")); } // Also have to factor UOMs previously used on Sales Credit now inactive if (_cmitemid != -1) { XSqlQuery cmuom; cmuom.prepare("SELECT cmitem_qty_uom_id, cmitem_price_uom_id " " FROM cmitem" " WHERE(cmitem_id=:cmitem_id);"); cmuom.bindValue(":cmitem_id", _cmitemid); cmuom.exec(); if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Sales Credit UOMs"), cmuom, __FILE__, __LINE__)) return; else if (cmuom.first()) { params.append("uom_id", cmuom.value("cmitem_qty_uom_id")); params.append("uom_id2", cmuom.value("cmitem_price_uom_id")); } } XSqlQuery uom = muom.toQuery(params); if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting UOMs"), uom, __FILE__, __LINE__)) return; int saveqtyuomid = _qtyUOM->id(); int savepriceuomid = _pricingUOM->id(); disconnect(_qtyUOM, SIGNAL(newID(int)), this, SLOT(sQtyUOMChanged())); disconnect(_pricingUOM, SIGNAL(newID(int)), this, SLOT(sPriceUOMChanged())); _qtyUOM->populate(uom); _pricingUOM->populate(uom); _qtyUOM->setId(saveqtyuomid); _pricingUOM->setId(savepriceuomid); connect(_qtyUOM, SIGNAL(newID(int)), this, SLOT(sQtyUOMChanged())); connect(_pricingUOM, SIGNAL(newID(int)), this, SLOT(sPriceUOMChanged())); }
void dspMRPDetail::sFillItemsites() { ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("mrpDetail", "item"); q = mql.toQuery(params); _itemsite->populate(q, true); }
void selectPayments::sFillList() { XSqlQuery selectFillList; if(_ignoreUpdates) return; // if (_vendorgroup->isSelectedVend()) // _apopen->showColumn(9); // else // _apopen->hideColumn(9); if ( (_selectDate->currentIndex() == 1 && !_onOrBeforeDate->isValid()) || (_selectDate->currentIndex() == 2 && (!_startDate->isValid() || !_endDate->isValid())) ) return; int _currid = -1; if (_bankaccnt->isValid()) { selectFillList.prepare( "SELECT bankaccnt_curr_id " "FROM bankaccnt " "WHERE (bankaccnt_id=:bankaccnt_id);" ); selectFillList.bindValue(":bankaccnt_id", _bankaccnt->id()); selectFillList.exec(); if (selectFillList.first()) _currid = selectFillList.value("bankaccnt_curr_id").toInt(); } ParameterList params; if (! setParams(params)) return; params.append("voucher", tr("Voucher")); params.append("debitMemo", tr("Debit Memo")); params.append("creditMemo", tr("Credit Memo")); if (_selectDate->currentIndex()==1) params.append("olderDate", _onOrBeforeDate->date()); else if (_selectDate->currentIndex()==2) { params.append("startDate", _startDate->date()); params.append("endDate", _endDate->date()); } if (_currid >= 0) params.append("curr_id", _currid); MetaSQLQuery mql = mqlLoad("apOpenItems", "selectpayments"); selectFillList = mql.toQuery(params); _apopen->populate(selectFillList,true); if (selectFillList.lastError().type() != QSqlError::NoError) { systemError(this, selectFillList.lastError().databaseText(), __FILE__, __LINE__); return; } }
void unpostedInvoices::sFillList() { MetaSQLQuery mql = mqlLoad("invoices", "detail"); ParameterList params; params.append("unpostedOnly"); q = mql.toQuery(params); _invchead->populate(q); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void packingListBatch::sFillList() { ParameterList params; setParams(params); MetaSQLQuery mql = mqlLoad("packingListBatch", "detail"); q = mql.toQuery(params); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } _pack->populate(q, true); }
void priceList::sFillList() { bool ok = false; QString errString; MetaSQLQuery pricelistm = MQLUtil::mqlLoad("pricelist", "detail", errString, &ok); if (! ok) { ErrorReporter::error(QtCriticalMsg, this, tr("Error Occurred"), tr("%1: %2") .arg(windowTitle()) .arg(errString),__FILE__,__LINE__); return; } ParameterList pricelistp; pricelistp.append("na", tr("N/A")); pricelistp.append("customer", tr("Customer")); pricelistp.append("shipTo", tr("Cust. Ship-To")); pricelistp.append("shipToPattern", tr("Cust. Ship-To Pattern")); pricelistp.append("custType", tr("Cust. Type")); pricelistp.append("custTypePattern", tr("Cust. Type Pattern")); pricelistp.append("shipZone", tr("Shipping Zone")); pricelistp.append("saleType", tr("Sale Type")); pricelistp.append("sale", tr("Sale")); pricelistp.append("listPrice", tr("List Price")); pricelistp.append("nominal", tr("Nominal")); pricelistp.append("discount", tr("Discount")); pricelistp.append("markup", tr("Markup")); pricelistp.append("item_id", _item->id()); pricelistp.append("warehous_id", _warehouse->id()); pricelistp.append("prodcat_id", _prodcatid); pricelistp.append("cust_id", _cust->id()); pricelistp.append("custtype_id", _custtypeid); pricelistp.append("custtype_code", _custtypecode); pricelistp.append("saletype_id", _saletypeid); pricelistp.append("shipzone_id", _shipzoneid); pricelistp.append("shipto_id", _shiptoid); pricelistp.append("shipto_num", _shiptonum); pricelistp.append("curr_id", _curr_id); pricelistp.append("effective", _effective); pricelistp.append("asof", _asOf); pricelistp.append("qty", _qty->toDouble()); pricelistp.append("item_listcost", _listCost->toDouble()); pricelistp.append("item_unitcost", _unitCost->toDouble()); pricelistp.append("item_listprice", _listPrice->toDouble()); pricelistp.append("listpricesched", _listpriceschedule); XSqlQuery pricelistq = pricelistm.toQuery(pricelistp); _price->populate(pricelistq, true); }
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"); } }
void dspCountTagsByItem::sFillList() { MetaSQLQuery mql = mqlLoad("countTags", "detail"); ParameterList params; if (! setParams(params)) return; q = mql.toQuery(params); _cnttag->populate(q); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void unappliedARCreditMemos::sFillList() { MetaSQLQuery mql = mqlLoad("arCreditMemos", "unapplied"); ParameterList params; XSqlQuery qry = mql.toQuery(params); _aropen->populate(qry); if (qry.lastError().type() != QSqlError::NoError) { systemError(this, qry.lastError().databaseText(), __FILE__, __LINE__); return; } }
void dspJobCosting::sFillList(int, bool) { ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("manufacture", "jobcosting"); q = mql.toQuery(params); _cost->populate(q, TRUE); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void contactMerge::sRestore() { MetaSQLQuery mql = mqlLoad("contactmerge", "restore"); ParameterList params; params.append("cntct_id", _cntct->id()); q = mql.toQuery(params); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } sFillList(); }
void dspBreederDistributionVarianceByWarehouse::sFillList() { ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("breederDistributionVariance", "detail"); q = mql.toQuery(params); _brdvar->populate(q); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void selectedPayments::sFillList() { ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("apOpenItems", "selectedpayments"); q = mql.toQuery(params); _apselect->populate(q,true); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void saleType::populate() { MetaSQLQuery mql = mqlLoad("saletype", "table"); ParameterList params; params.append("ViewMode"); params.append("saletype_id", _saletypeid); XSqlQuery saleTypePopulate = mql.toQuery(params); if (saleTypePopulate.first()) { _code->setText(saleTypePopulate.value("saletype_code")); _description->setText(saleTypePopulate.value("saletype_descr")); _active->setChecked(saleTypePopulate.value("saletype_active").toBool()); } }
void openReturnAuthorizations::sFillList() { MetaSQLQuery mql = mqlLoad("returnAuthorizations", "detail"); ParameterList params; setParams(params); q = mql.toQuery(params); _ra->populate(q); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } _ra->setDragString("raheadid="); }
void dspBookingsByCustomerGroup::sFillList() { MetaSQLQuery mql = mqlLoad("salesOrderItems", "detail"); ParameterList params; if (! setParams(params)) return; q = mql.toQuery(params); _soitem->populate(q); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void dspTimePhasedOpenAPItems::sFillStd() { MetaSQLQuery mql = mqlLoad("apAging", "detail"); ParameterList params; if (! setParams(params)) return; q = mql.toQuery(params); _apopen->populate(q); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void dspPlannedOrdersByItem::sFillList() { ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("schedule", "plannedorders"); q = mql.toQuery(params); _planord->populate(q, TRUE); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void dspLaborVarianceByWorkCenter::sFillList() { ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("manufacture", "laborvariance"); q = mql.toQuery(params); _woopervar->populate(q); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void pricingScheduleAssignments::sFillList() { MetaSQLQuery mql = mqlLoad("pricingScheduleAssignment", "detail"); ParameterList params; if (_listpricesched) params.append("listpricesched", true); XSqlQuery ps = mql.toQuery(params); if(!ErrorReporter::error(QtCriticalMsg, this, tr("Pricing Schedule Assignments "), ps.lastError(), __FILE__, __LINE__)) { _ipsass->populate(ps, true); } }
void dspPurchaseReqsByItem::sFillList() { ParameterList params; if (! setParams(params)) return; MetaSQLQuery mql = mqlLoad("purchase", "purchaserequests"); q = mql.toQuery(params); _pr->populate(q, TRUE); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } }
void contactMerge::sPopulateSources() { ParameterList params; params.append("target", QVariant(false)); MetaSQLQuery mql = mqlLoad("contactmerge", "populate"); q = mql.toQuery(params); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } _srccntct->populate(q); }
void unappliedARCreditMemos::sFillList() { MetaSQLQuery mql = mqlLoad("arCreditMemos", "unapplied"); ParameterList params; XSqlQuery qry = mql.toQuery(params); _aropen->populate(qry); if (ErrorReporter::error(QtCriticalMsg, this, tr("Error Retrieving Unapplied AR Credit Memo Information"), qry, __FILE__, __LINE__)) { return; } }