void arWorkBench::sPostCashrcpt() { XSqlQuery arPostCashrcpt; int journalNumber = -1; bool changeDate = false; QDate newDate = QDate(); if (_privileges->check("ChangeCashRecvPostDate")) { getGLDistDate newdlg(this, "", TRUE); newdlg.sSetDefaultLit(tr("Distribution Date")); if (newdlg.exec() == XDialog::Accepted) { newDate = newdlg.date(); changeDate = (newDate.isValid()); } else return; } arPostCashrcpt.exec("BEGIN;"); arPostCashrcpt.exec("SELECT fetchJournalNumber('C/R') AS journalnumber;"); if (arPostCashrcpt.first()) journalNumber = arPostCashrcpt.value("journalnumber").toInt(); else if (arPostCashrcpt.lastError().type() != QSqlError::NoError) { systemError(this, arPostCashrcpt.lastError().databaseText(), __FILE__, __LINE__); return; } XSqlQuery setDate; setDate.prepare("UPDATE cashrcpt SET cashrcpt_distdate=:distdate," " cashrcpt_applydate=CASE WHEN (cashrcpt_applydate < :distdate) THEN :distdate" " ELSE cashrcpt_applydate END " "WHERE cashrcpt_id=:cashrcpt_id;"); QList<XTreeWidgetItem*> selected = _cashrcpt->selectedItems(); for (int i = 0; i < selected.size(); i++) { int id = ((XTreeWidgetItem*)(selected[i]))->id(); if (changeDate) { setDate.bindValue(":distdate", newDate); setDate.bindValue(":cashrcpt_id", id); setDate.exec(); ErrorReporter::error(QtCriticalMsg, this, tr("Changing Dist. Date"), setDate, __FILE__, __LINE__); } } for (int i = 0; i < selected.size(); i++) { arPostCashrcpt.prepare("SELECT postCashReceipt(:cashrcpt_id, :journalNumber) AS result;"); arPostCashrcpt.bindValue(":cashrcpt_id", ((XTreeWidgetItem*)(selected[i]))->id()); arPostCashrcpt.bindValue(":journalNumber", journalNumber); arPostCashrcpt.exec(); if (arPostCashrcpt.first()) { int result = arPostCashrcpt.value("result").toInt(); if (result < 0) { systemError(this, storedProcErrorLookup("postCashReceipt", result), __FILE__, __LINE__); arPostCashrcpt.exec("ROLLBACK;"); return; } } else if (arPostCashrcpt.lastError().type() != QSqlError::NoError) { systemError(this, arPostCashrcpt.lastError().databaseText(), __FILE__, __LINE__); arPostCashrcpt.exec("ROLLBACK;"); return; } } arPostCashrcpt.exec("COMMIT;"); sFillList(); }
quoteList::quoteList( QWidget* parent, const char* name, bool modal, Qt::WFlags fl ) : QDialog( parent, fl ) { setObjectName(name ? name : "quoteList" ); setModal(modal); _quheadid = -1; _custid = -1; _openOnly = false; setWindowTitle(tr("Quotes")); QVBoxLayout *mainLayout = new QVBoxLayout(this); mainLayout->setContentsMargins(5, 5, 5, 5); mainLayout->setSpacing(5); mainLayout->setObjectName("mainLayout"); QVBoxLayout *warehouseLayout = new QVBoxLayout(); warehouseLayout->setObjectName("warehouseLayout"); QHBoxLayout *topLayout = new QHBoxLayout(); topLayout->setSpacing(7); topLayout->setObjectName("topLayout"); QVBoxLayout *buttonsLayout = new QVBoxLayout(); buttonsLayout->setSpacing(5); buttonsLayout->setObjectName("buttonsLayout"); QVBoxLayout *listLayout = new QVBoxLayout(); listLayout->setObjectName("listLayout"); _warehouse = new WarehouseGroup(this, "_warehouse"); warehouseLayout->addWidget(_warehouse); QSpacerItem* spacer = new QSpacerItem(0, 0, QSizePolicy::Minimum, QSizePolicy::Preferred); warehouseLayout->addItem(spacer); topLayout->addLayout(warehouseLayout); QSpacerItem* spacer_2 = new QSpacerItem(0, 0, QSizePolicy::Expanding, QSizePolicy::Minimum); topLayout->addItem(spacer_2); _close = new QPushButton(tr("&Cancel"), this); _close->setObjectName("_close"); buttonsLayout->addWidget(_close); _select = new QPushButton(tr("&Select"), this); _select->setObjectName("_select"); _select->setEnabled( FALSE ); _select->setDefault( TRUE ); buttonsLayout->addWidget(_select); buttonsLayout->addSpacerItem(new QSpacerItem(20, 20, QSizePolicy::Minimum, QSizePolicy::Expanding)); topLayout->addLayout(buttonsLayout); mainLayout->addLayout(topLayout); QLabel *_quotesLit = new QLabel(tr("Quotes:"), this); _quotesLit->setObjectName("_quotesLit"); listLayout->addWidget(_quotesLit); _qu = new XTreeWidget(this); _qu->setObjectName("_qu"); listLayout->addWidget(_qu, 1); mainLayout->addLayout(listLayout, 1); resize( QSize(490, 390).expandedTo(minimumSizeHint()) ); connect( _close, SIGNAL( clicked() ), this, SLOT( reject() ) ); connect( _select, SIGNAL( clicked() ), this, SLOT( sSelect() ) ); connect( _qu, SIGNAL( itemSelected(int) ), _select, SLOT( animateClick() ) ); connect( _qu, SIGNAL( valid(bool) ), _select, SLOT( setEnabled(bool) ) ); connect( _warehouse, SIGNAL(updated()), this, SLOT( sFillList() ) ); _qu->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "quhead_number"); _qu->addColumn(tr("Customer"), -1, Qt::AlignLeft, true, "cust_name"); _qu->addColumn(tr("Ordered"), _dateColumn, Qt::AlignCenter,true, "quhead_quotedate"); _qu->addColumn(tr("Scheduled"),_dateColumn, Qt::AlignCenter,true, "duedate"); setTabOrder(_warehouse, _qu); setTabOrder(_qu, _select); setTabOrder(_select, _close); setTabOrder(_close, _warehouse); _warehouse->setFocus(); }
void purchaseOrder::populate() { XSqlQuery po; po.prepare( "SELECT pohead_number, COALESCE(pohead_warehous_id,-1) AS pohead_warehous_id, " " pohead_orderdate, pohead_status, pohead_printed, pohead_taxzone_id, " " pohead_shipvia, pohead_comments," " pohead_fob, COALESCE(pohead_terms_id,-1) AS pohead_terms_id, " " COALESCE(pohead_vend_id,-1) AS pohead_vend_id," " pohead_tax, pohead_freight," " pohead_agent_username," " vend_name, vend_address1, vend_address2, vend_address3," " vend_city, vend_state, vend_zip, vend_country," " COALESCE(vendaddr_id, -1) AS vendaddrid," " vendaddr_code, vendaddr_name, vendaddr_address1, vendaddr_address2," " vendaddr_address3, vendaddr_city, vendaddr_state, vendaddr_zipcode," " vendaddr_country, pohead_curr_id " "FROM vend, pohead LEFT OUTER JOIN vendaddr ON (pohead_vendaddr_id=vendaddr_id) " "WHERE ( (pohead_vend_id=vend_id)" " AND (pohead_id=:pohead_id) );" ); po.bindValue(":pohead_id", _poheadid); po.exec(); if (po.first()) { _orderNumber->setText(po.value("pohead_number")); _warehouse->setId(po.value("pohead_warehous_id").toInt()); _orderDate->setDate(po.value("pohead_orderdate").toDate(), true); _agent->setText(po.value("pohead_agent_username").toString()); _status->setText(po.value("pohead_status").toString()); _printed = po.value("pohead_printed").toBool(); _terms->setId(po.value("pohead_terms_id").toInt()); _shipVia->setText(po.value("pohead_shipvia")); _fob->setText(po.value("pohead_fob")); _notes->setText(po.value("pohead_comments").toString()); _vendaddrid = po.value("vendaddrid").toInt(); if (_vendaddrid == -1) { _vendaddrCode->setText(tr("Main")); _vendaddrName->setText(po.value("vend_name")); _vendaddrAddr1->setText(po.value("vend_address1")); _vendaddrAddr2->setText(po.value("vend_address2")); _vendaddrAddr3->setText(po.value("vend_address3")); _vendaddrCity->setText(po.value("vend_city")); _vendaddrState->setText(po.value("vend_state")); _vendaddrZipCode->setText(po.value("vend_zip")); _vendaddrCountry->setText(po.value("vend_country")); } else { _vendaddrCode->setText(po.value("vendaddr_code")); _vendaddrName->setText(po.value("vendaddr_name")); _vendaddrAddr1->setText(po.value("vendaddr_address1")); _vendaddrAddr2->setText(po.value("vendaddr_address2")); _vendaddrAddr3->setText(po.value("vendaddr_address3")); _vendaddrCity->setText(po.value("vendaddr_city")); _vendaddrState->setText(po.value("vendaddr_state")); _vendaddrZipCode->setText(po.value("vendaddr_zipcode")); _vendaddrCountry->setText(po.value("vendaddr_country")); } _comments->setId(_poheadid); _vendor->setId(po.value("pohead_vend_id").toInt()); _taxZone->setId(po.value("pohead_taxzone_id").toInt()); _poCurrency->setId(po.value("pohead_curr_id").toInt()); _tax->setLocalValue(po.value("pohead_tax").toDouble()); _freight->setLocalValue(po.value("pohead_freight").toDouble()); } sFillList(); }
itemList::itemList( QWidget* parent, const char* name, bool modal, Qt::WFlags fl ) : QDialog( parent, name, modal, fl ) { if ( !name ) setName( "itemList" ); _itemid = -1; _itemType = ItemLineEdit::cUndefined; _useQuery = FALSE; setCaption(tr("Item List")); Q3VBoxLayout *itemListLayout = new Q3VBoxLayout( this, 5, 5, "itemListLayout"); Q3HBoxLayout *Layout69 = new Q3HBoxLayout( 0, 0, 0, "Layout69"); Q3HBoxLayout *Layout72 = new Q3HBoxLayout( 0, 0, 7, "Layout72"); Q3VBoxLayout *Layout71 = new Q3VBoxLayout( 0, 0, 0, "Layout71"); Q3VBoxLayout *Layout70 = new Q3VBoxLayout( 0, 0, 5, "Layout70"); Q3HBoxLayout *Layout5 = new Q3HBoxLayout( 0, 0, 5, "Layout5"); Q3VBoxLayout *Layout18 = new Q3VBoxLayout( 0, 0, 5, "Layout18"); Q3VBoxLayout *Layout20 = new Q3VBoxLayout( 0, 0, 0, "Layout20"); QLabel *_searchForLit = new QLabel(tr("S&earch for:"), this, "_searchForLit"); _searchForLit->setAlignment( int( Qt::AlignVCenter | Qt::AlignRight ) ); Layout5->addWidget( _searchForLit ); _searchFor = new QLineEdit( this, "_searchFor" ); _searchForLit->setBuddy(_searchFor); Layout5->addWidget( _searchFor ); Layout70->addLayout( Layout5 ); _showInactive = new QCheckBox(tr("Show &Inactive Items"), this, "_showInactive"); Layout69->addWidget( _showInactive ); QSpacerItem* spacer = new QSpacerItem( 20, 20, QSizePolicy::Expanding, QSizePolicy::Minimum ); Layout69->addItem( spacer ); _showMake = new QCheckBox(tr("Show &Make Items"), this, "_showMake"); _showBuy = new QCheckBox(tr("Show &Buy Items"), this, "_showBuy"); Layout70->addWidget( _showMake ); Layout70->addWidget( _showBuy ); Layout70->addLayout( Layout69 ); Layout71->addLayout( Layout70 ); QSpacerItem* spacer_2 = new QSpacerItem( 20, 20, QSizePolicy::Minimum, QSizePolicy::Preferred ); Layout71->addItem( spacer_2 ); Layout72->addLayout( Layout71 ); _close = new QPushButton(tr("&Cancel"), this, "_close"); Layout18->addWidget( _close ); _select = new QPushButton(tr("&Select"), this, "_select"); _select->setEnabled( FALSE ); _select->setAutoDefault( TRUE ); _select->setDefault( TRUE ); Layout18->addWidget( _select ); Layout72->addLayout( Layout18 ); itemListLayout->addLayout( Layout72 ); QLabel *_itemsLit = new QLabel(tr("&Items:"), this, "_itemsLit"); Layout20->addWidget( _itemsLit ); _item = new XTreeWidget(this); _item->setName("_item"); _itemsLit->setBuddy(_item ); Layout20->addWidget( _item ); itemListLayout->addLayout( Layout20 ); resize( QSize(467, 393).expandedTo(minimumSizeHint()) ); //clearWState( WState_Polished ); connect( _item, SIGNAL( itemSelected(int) ), this, SLOT( sSelect() ) ); connect( _select, SIGNAL( clicked() ), this, SLOT( sSelect() ) ); connect( _close, SIGNAL( clicked() ), this, SLOT( sClose() ) ); connect( _searchFor, SIGNAL( textChanged(const QString&) ), this, SLOT( sSearch(const QString&) ) ); connect( _showInactive, SIGNAL( clicked() ), this, SLOT( sFillList() ) ); connect( _showMake, SIGNAL( clicked() ), this, SLOT( sFillList() ) ); connect( _showBuy, SIGNAL( clicked() ), this, SLOT( sFillList() ) ); connect( _item, SIGNAL( valid(bool) ), _select, SLOT( setEnabled(bool) ) ); _item->addColumn(tr("Item Number"), 100, Qt::AlignLeft ); _item->addColumn(tr("Description"), -1, Qt::AlignLeft ); }
void userPreferences::sPopulate() { if (_currentUser->isChecked()) _pref = Preferences(omfgThis->username()); else _pref = Preferences(_user->currentText()); if (_pref.value("BackgroundImageid").toInt() > 0) { _backgroundImage->setChecked(TRUE); setBackgroundImage(_pref.value("BackgroundImageid").toInt()); } else { _noBackgroundImage->setChecked(TRUE); _backgroundImageid = -1; } if (_pref.value("PreferredWarehouse").toInt() == -1) _noWarehouse->setChecked(TRUE); else { _selectedWarehouse->setChecked(TRUE); _warehouse->setId(_pref.value("PreferredWarehouse").toInt()); } if (_pref.value("InterfaceWindowOption") == "TopLevel") _interfaceTopLevel->setChecked(true); else _interfaceWorkspace->setChecked(true); _rememberCheckBoxes->setChecked(! _pref.boolean("XCheckBox/forgetful")); _itemCache->setChecked(_pref.boolean("UseItemCache")); _customerCache->setChecked(_pref.boolean("UseCustCache")); _standard->setChecked(_pref.boolean("UseOldMenu")); sStyleChanged(); //New Menus _inventoryMenu->setChecked(_pref.boolean("ShowIMMenu")); _productsMenu->setChecked(_pref.boolean("ShowPDMenu")); _scheduleMenu->setChecked(_pref.boolean("ShowMSMenu")); _manufactureMenu->setChecked(_pref.boolean("ShowWOMenu")); _crmMenu2->setChecked(_pref.boolean("ShowCRMMenu")); _purchaseMenu->setChecked(_pref.boolean("ShowPOMenu")); _salesMenu->setChecked(_pref.boolean("ShowSOMenu")); _accountingMenu->setChecked(_pref.boolean("ShowGLMenu")); _inventoryToolbar->setChecked(_pref.boolean("ShowIMToolbar")); _productsToolbar->setChecked(_pref.boolean("ShowPDToolbar")); _scheduleToolbar->setChecked(_pref.boolean("ShowMSToolbar")); _manufactureToolbar->setChecked(_pref.boolean("ShowWOToolbar")); _crmToolbar2->setChecked(_pref.boolean("ShowCRMToolbar")); _purchaseToolbar->setChecked(_pref.boolean("ShowPOToolbar")); _salesToolbar->setChecked(_pref.boolean("ShowSOToolbar")); _accountingToolbar->setChecked(_pref.boolean("ShowGLToolbar")); //Old Menus _imMenu->setChecked(_pref.boolean("ShowIMMenu")); _pdMenu->setChecked(_pref.boolean("ShowPDMenu")); _msMenu->setChecked(_pref.boolean("ShowMSMenu")); _cpMenu->setChecked(_pref.boolean("ShowCPMenu")); _woMenu->setChecked(_pref.boolean("ShowWOMenu")); _crmMenu->setChecked(_pref.boolean("ShowCRMMenu")); _poMenu->setChecked(_pref.boolean("ShowPOMenu")); _soMenu->setChecked(_pref.boolean("ShowSOMenu")); _srMenu->setChecked(_pref.boolean("ShowSRMenu")); _saMenu->setChecked(_pref.boolean("ShowSAMenu")); _pmMenu->setChecked(_pref.boolean("ShowPMMenu")); _arMenu->setChecked(_pref.boolean("ShowARMenu")); _apMenu->setChecked(_pref.boolean("ShowAPMenu")); _glMenu->setChecked(_pref.boolean("ShowGLMenu")); _imToolbar->setChecked(_pref.boolean("ShowIMToolbar")); _pdToolbar->setChecked(_pref.boolean("ShowPDToolbar")); _msToolbar->setChecked(_pref.boolean("ShowMSToolbar")); _cpToolbar->setChecked(_pref.boolean("ShowCPToolbar")); _woToolbar->setChecked(_pref.boolean("ShowWOToolbar")); _crmToolbar->setChecked(_pref.boolean("ShowCRMToolbar")); _poToolbar->setChecked(_pref.boolean("ShowPOToolbar")); _soToolbar->setChecked(_pref.boolean("ShowSOToolbar")); _srToolbar->setChecked(_pref.boolean("ShowSRToolbar")); _saToolbar->setChecked(_pref.boolean("ShowSAToolbar")); _pmToolbar->setChecked(_pref.boolean("ShowPMToolbar")); _arToolbar->setChecked(_pref.boolean("ShowARToolbar")); _apToolbar->setChecked(_pref.boolean("ShowAPToolbar")); _glToolbar->setChecked(_pref.boolean("ShowGLToolbar")); _fixedWidthFonts->setChecked(_pref.boolean("UsedFixedWidthFonts")); _listNumericItemsFirst->setChecked(_pref.boolean("ListNumericItemNumbersFirst")); _showSoitemAvailability->setChecked(_pref.boolean("ShowSOItemAvailability")); _idleTimeout->setValue(_pref.value("IdleTimeout").toInt()); if(_pref.value("DefaultEllipsesAction") == "search") _ellipsesAction->setId(2); else _ellipsesAction->setId(1); //Hide for PostBooks if (_metrics->value("Application") != "OpenMFG") { _scheduleMenu->hide(); _scheduleToolbar->hide(); _msMenu->hide(); _msToolbar->hide(); _cpMenu->hide(); _cpToolbar->hide(); } if (!_metrics->boolean("MultiWhs")) _warehouseGroup->hide(); sFillList(); sFillWarehouseList(); }
void dspSingleLevelBOM::sFillList() { if (_item->isValid()) sFillList(-1, FALSE); }
void boo::sFillList() { sFillList(-1, TRUE); }
void fixSerial::sFix() { if (fixOne(static_cast<XTreeWidgetItem*>(_serial->currentItem()))) sFillList(); }
void itemUOM::sCheck() { if(cNew != _mode || _ignoreSignals) return; _ignoreSignals = true; _uomFrom->setEnabled(false); _uomTo->setEnabled(false); q.prepare("SELECT itemuomconv_id" " FROM itemuomconv" " WHERE((itemuomconv_item_id=:item_id)" " AND (((itemuomconv_from_uom_id=:from_uom_id) AND (itemuomconv_to_uom_id=:to_uom_id))" " OR ((itemuomconv_from_uom_id=:to_uom_id) AND (itemuomconv_to_uom_id=:from_uom_id))));"); q.bindValue(":item_id", _itemid); q.bindValue(":from_uom_id", _uomFrom->id()); q.bindValue(":to_uom_id", _uomTo->id()); q.exec(); if(q.first()) { _itemuomconvid = q.value("itemuomconv_id").toInt(); _mode = cEdit; populate(); _ignoreSignals = false; return; } q.prepare("SELECT uomconv_from_uom_id, uomconv_from_value," " uomconv_to_uom_id, uomconv_to_value," " uomconv_fractional" " FROM uomconv" " WHERE(((uomconv_from_uom_id=:from_uom_id) AND (uomconv_to_uom_id=:to_uom_id))" " OR ((uomconv_from_uom_id=:to_uom_id) AND (uomconv_to_uom_id=:from_uom_id)));"); q.bindValue(":from_uom_id", _uomFrom->id()); q.bindValue(":to_uom_id", _uomTo->id()); q.exec(); if(q.first()) { _uomFrom->setId(q.value("uomconv_from_uom_id").toInt()); _uomTo->setId(q.value("uomconv_to_uom_id").toInt()); _fromValue->setDouble(q.value("uomconv_from_value").toDouble()); _toValue->setDouble(q.value("uomconv_to_value").toDouble()); _fractional->setChecked(q.value("uomconv_fractional").toBool()); _fromValue->setEnabled(false); _toValue->setEnabled(false); } else { _fromValue->setEnabled(true); _toValue->setEnabled(true); } q.exec("SELECT nextval('itemuomconv_itemuomconv_id_seq') AS result;"); q.first(); _itemuomconvid = q.value("result").toInt(); q.prepare("INSERT INTO itemuomconv" " (itemuomconv_id, itemuomconv_item_id, itemuomconv_from_uom_id, itemuomconv_to_uom_id," " itemuomconv_from_value, itemuomconv_to_value, itemuomconv_fractional) " "VALUES(:id, :item_id, :from_uom_id, :to_uom_id, :fromvalue, :tovalue, :fractional);"); q.bindValue(":id", _itemuomconvid); q.bindValue(":item_id", _itemid); q.bindValue(":from_uom_id", _uomFrom->id()); q.bindValue(":to_uom_id", _uomTo->id()); q.bindValue(":fromvalue", _fromValue->toDouble()); q.bindValue(":tovalue", _toValue->toDouble()); q.bindValue(":fractional", QVariant(_fractional->isChecked())); q.exec(); sFillList(); _ignoreSignals = false; }
enum SetResponse dspBacklogByParameterList::set(const ParameterList &pParams) { QVariant param; bool valid; param = pParams.value("custtype_id", &valid); if (valid) { _parameter->setType(CustomerType); _parameter->setId(param.toInt()); } param = pParams.value("custtype_pattern", &valid); if (valid) { _parameter->setType(CustomerType); _parameter->setPattern(param.toString()); } param = pParams.value("custtype", &valid); if (valid) _parameter->setType(CustomerType); param = pParams.value("custgrp_id", &valid); if (valid) { _parameter->setType(CustomerGroup); _parameter->setId(param.toInt()); } param = pParams.value("custgrp_pattern", &valid); if (valid) { _parameter->setType(CustomerGroup); _parameter->setPattern(param.toString()); } param = pParams.value("custgrp", &valid); if (valid) _parameter->setType(CustomerGroup); param = pParams.value("prodcat_id", &valid); if (valid) { _parameter->setType(ProductCategory); _parameter->setId(param.toInt()); } param = pParams.value("prodcat_pattern", &valid); if (valid) { _parameter->setType(ProductCategory); _parameter->setPattern(param.toString()); } param = pParams.value("prodcat", &valid); if (valid) _parameter->setType(ProductCategory); if (pParams.inList("run")) { sFillList(); return NoError_Run; } switch (_parameter->type()) { case CustomerType: setCaption(tr("Backlog by Customer Type")); break; case CustomerGroup: setCaption(tr("Backlog by Customer Group")); break; case ProductCategory: setCaption(tr("Backlog by Product Category")); break; default: break; } return NoError; }
plannedOrderList::plannedOrderList(QWidget *parent, const char *name, bool modal, Qt::WFlags fl) : QDialog( parent, name, modal, fl ) { setWindowTitle(tr("Planned Orders")); _planordid = -1; if ( !name ) setObjectName( "plannedOrderList" ); QVBoxLayout *plannedOrderListLayout = new QVBoxLayout( this, 5, 5, "plannedOrderListLayout"); QHBoxLayout *layout6387 = new QHBoxLayout( 0, 0, 7, "layout6387"); QVBoxLayout *layout6385 = new QVBoxLayout( 0, 0, 0, "layout6385"); QHBoxLayout *layout6384 = new QHBoxLayout( 0, 0, 5, "layout6384"); QVBoxLayout *Layout183 = new QVBoxLayout( 0, 0, 5, "Layout183"); QVBoxLayout *Layout185 = new QVBoxLayout( 0, 0, 0, "Layout185"); QHBoxLayout *layout6386 = new QHBoxLayout( 0, 0, 0, "layout6386"); _warehouseGroup = new QGroupBox( this ); QVBoxLayout *_warehouseGroupLayout = new QVBoxLayout( _warehouseGroup ); _warehouseGroupLayout->setSpacing( 0 ); _warehouseGroupLayout->setMargin( 5 ); _warehouseGroupLayout->setAlignment( Qt::AlignTop ); _allWarehouses = new QRadioButton(tr("&All Sites"), _warehouseGroup, "_allWarehouses"); _allWarehouses->setChecked( TRUE ); _warehouseGroupLayout->addWidget( _allWarehouses ); _selectedWarehouse = new QRadioButton(tr("Site:"), _warehouseGroup, "_selectedWarehouse"); _selectedWarehouse->setChecked( FALSE ); layout6384->addWidget( _selectedWarehouse ); _warehouse = new WComboBox( _warehouseGroup, "_warehouse" ); _warehouse->setEnabled( FALSE ); layout6384->addWidget( _warehouse ); _warehouseGroupLayout->addLayout( layout6384 ); layout6385->addWidget( _warehouseGroup ); _warehouseGroup->setLayout( _warehouseGroupLayout ); QSpacerItem* spacer = new QSpacerItem( 20, 20, QSizePolicy::Minimum, QSizePolicy::Preferred ); layout6385->addItem( spacer ); layout6387->addLayout( layout6385 ); QSpacerItem* spacer_2 = new QSpacerItem( 223, 20, QSizePolicy::Expanding, QSizePolicy::Minimum ); layout6386->addItem( spacer_2 ); _close = new QPushButton(tr("&Cancel"), this, "_close"); Layout183->addWidget( _close ); _select = new QPushButton(tr("&Select"), this, "_select"); _select->setAutoDefault( TRUE ); _select->setDefault( TRUE ); Layout183->addWidget( _select ); layout6386->addLayout( Layout183 ); layout6387->addLayout( layout6386 ); plannedOrderListLayout->addLayout( layout6387 ); QLabel *_plannedOrdersLit = new QLabel(tr("Planned Orders:"), this, "_plannedOrdersLit"); Layout185->addWidget( _plannedOrdersLit ); _planord = new XTreeWidget( this); _planord->setObjectName("_planord" ); Layout185->addWidget( _planord ); plannedOrderListLayout->addLayout( Layout185 ); resize( QSize(496, 360).expandedTo(minimumSizeHint()) ); //clearWState( WState_Polished ); // signals and slots connections connect( _close, SIGNAL( clicked() ), this, SLOT( sClose() ) ); connect( _select, SIGNAL( clicked() ), this, SLOT( sSelect() ) ); connect( _planord, SIGNAL( itemSelected(int) ), this, SLOT( sSelect() ) ); connect( _selectedWarehouse, SIGNAL( toggled(bool) ), this, SLOT( sFillList() ) ); connect( _warehouse, SIGNAL( newID(int) ), this, SLOT( sFillList() ) ); connect( _selectedWarehouse, SIGNAL( toggled(bool) ), _warehouse, SLOT( setEnabled(bool) ) ); setTabOrder(_allWarehouses, _selectedWarehouse); setTabOrder(_selectedWarehouse, _warehouse); setTabOrder(_warehouse, _planord); setTabOrder(_planord, _select); setTabOrder(_select, _close); setTabOrder(_close, _allWarehouses); _planord->setFocus(); _planord->addColumn(tr("PL/O #"), _orderColumn, Qt::AlignLeft, true, "number"); _planord->addColumn(tr("Firmed"), 40, Qt::AlignCenter,true, "planord_firm"); _planord->addColumn(tr("Whs."), _whsColumn, Qt::AlignCenter,true, "warehous_code"); _planord->addColumn(tr("Item Number"),_itemColumn, Qt::AlignLeft, true, "item_number"); _planord->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "descrip"); sFillList(); }
void selectOrderForBilling::sPopulate(int pSoheadid) { if (_so->isValid()) { q.prepare("SELECT createBillingHeader(:sohead_id) AS cobmisc_id;"); q.bindValue(":sohead_id", pSoheadid); q.exec(); if (q.first()) { _cobmiscid = q.value("cobmisc_id").toInt(); if (_cobmiscid < 0) { systemError(this, storedProcErrorLookup("createBillingHeader", _cobmiscid), __FILE__, __LINE__); return; } } else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } XSqlQuery cobmisc; cobmisc.prepare( "SELECT cobmisc_id, cobmisc_notes, cobmisc_shipvia," " cohead_orderdate, cobmisc_shipdate," " cobmisc_invcdate, cobmisc_taxzone_id," " cobmisc_freight AS freight," " cobmisc_misc, cobmisc_misc_accnt_id, cobmisc_misc_descrip," " cobmisc_payment AS payment," " cobmisc_closeorder," " cobmisc_curr_id," " cohead_number, cohead_shipto_id," " cohead_custponumber," " cohead_billtoname, cohead_shiptoname," " CASE WHEN (shipchrg_custfreight IS NULL) THEN TRUE" " ELSE shipchrg_custfreight" " END AS custfreight " "FROM cobmisc , cohead " " LEFT OUTER JOIN shipchrg ON (cohead_shipchrg_id=shipchrg_id) " "WHERE ( (cobmisc_id=:cobmisc_id)" " AND (cohead_id=:cohead_id) ) "); cobmisc.bindValue(":cobmisc_id", _cobmiscid); cobmisc.bindValue(":cohead_id", pSoheadid); cobmisc.exec(); if (cobmisc.first()) { _cobmiscid = cobmisc.value("cobmisc_id").toInt(); // do taxzone first so we can overwrite the result of the signal cascade _taxzoneidCache = cobmisc.value("cobmisc_taxzone_id").toInt(); _taxZone->setId(cobmisc.value("cobmisc_taxzone_id").toInt()); _orderDate->setDate(cobmisc.value("cohead_orderdate").toDate(), true); _shipDate->setDate(cobmisc.value("cobmisc_shipdate").toDate()); _invoiceDate->setDate(cobmisc.value("cobmisc_invcdate").toDate()); _poNumber->setText(cobmisc.value("cohead_custponumber").toString()); _custName->setText(cobmisc.value("cohead_billtoname").toString()); _shipToName->setText(cobmisc.value("cohead_shiptoname").toString()); _shipvia->setText(cobmisc.value("cobmisc_shipvia").toString()); _miscCharge->setLocalValue(cobmisc.value("cobmisc_misc").toDouble()); _miscChargeAccount->setId(cobmisc.value("cobmisc_misc_accnt_id").toInt()); _miscChargeDescription->setText(cobmisc.value("cobmisc_misc_descrip")); _payment->set(cobmisc.value("payment").toDouble(), cobmisc.value("cobmisc_curr_id").toInt(), cobmisc.value("cohead_orderdate").toDate(), false); _custCurrency->setId(cobmisc.value("cobmisc_curr_id").toInt()); _comments->setText(cobmisc.value("cobmisc_notes").toString()); _closeOpenItems->setChecked(cobmisc.value("cobmisc_closeorder").toBool()); _freightCache = cobmisc.value("freight").toDouble(); if (cobmisc.value("custfreight").toBool()) { _freight->setEnabled(TRUE); _freight->setLocalValue(cobmisc.value("freight").toDouble()); } else { _freight->setEnabled(FALSE); _freight->clear(); } } else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } } else { clear(); } sFillList(); }
void userPreferences::sPopulate() { if (_currentUser->isChecked()) { _pref = _preferences; _username->setText(omfgThis->username()); } else { if(_altPref) delete _altPref; _altPref = new Preferences(_user->currentText()); _pref = _altPref; _username->setText(_user->currentText()); } _username->setEnabled(FALSE); _currentpassword->setEnabled(_currentUser->isChecked()); _newpassword->setEnabled(_currentUser->isChecked()); _retypepassword->setEnabled(_currentUser->isChecked()); if (_pref->value("BackgroundImageid").toInt() > 0) { _backgroundImage->setChecked(TRUE); setBackgroundImage(_pref->value("BackgroundImageid").toInt()); } else { _noBackgroundImage->setChecked(TRUE); _background->clear(); _backgroundImageid = -1; } if (_pref->value("PreferredWarehouse").toInt() == -1) _noWarehouse->setChecked(TRUE); else { _selectedWarehouse->setChecked(TRUE); _warehouse->setId(_pref->value("PreferredWarehouse").toInt()); } if (_pref->value("InterfaceWindowOption") == "Workspace") _interfaceWorkspace->setChecked(true); else _interfaceTopLevel->setChecked(true); if (_pref->boolean("CopyListsPlainText")) _plainText->setChecked(true); else _richText->setChecked(true); _enableSpell->setChecked(_pref->boolean("SpellCheck")); //_rememberCheckBoxes->setChecked(! _pref->boolean("XCheckBox/forgetful")); _inventoryMenu->setChecked(_pref->boolean("ShowIMMenu")); _productsMenu->setChecked(_pref->boolean("ShowPDMenu")); _scheduleMenu->setChecked(_pref->boolean("ShowMSMenu")); _manufactureMenu->setChecked(_pref->boolean("ShowWOMenu")); _crmMenu2->setChecked(_pref->boolean("ShowCRMMenu")); _purchaseMenu->setChecked(_pref->boolean("ShowPOMenu")); _salesMenu->setChecked(_pref->boolean("ShowSOMenu")); _accountingMenu->setChecked(_pref->boolean("ShowGLMenu")); _inventoryToolbar->setChecked(_pref->boolean("ShowIMToolbar")); _productsToolbar->setChecked(_pref->boolean("ShowPDToolbar")); _scheduleToolbar->setChecked(_pref->boolean("ShowMSToolbar")); _manufactureToolbar->setChecked(_pref->boolean("ShowWOToolbar")); _crmToolbar2->setChecked(_pref->boolean("ShowCRMToolbar")); _purchaseToolbar->setChecked(_pref->boolean("ShowPOToolbar")); _salesToolbar->setChecked(_pref->boolean("ShowSOToolbar")); _accountingToolbar->setChecked(_pref->boolean("ShowGLToolbar")); _listNumericItemsFirst->setChecked(_pref->boolean("ListNumericItemNumbersFirst")); _ignoreTranslation->setChecked(_pref->boolean("IngoreMissingTranslationFiles")); _idleTimeout->setValue(_pref->value("IdleTimeout").toInt()); _emailEvents->setChecked(_pref->boolean("EmailEvents")); _alarmEvent->setChecked(_pref->boolean("AlarmEventDefault")); _alarmEmail->setChecked(_pref->boolean("AlarmEmailDefault")); _alarmSysmsg->setChecked(_pref->boolean("AlarmSysmsgDefault")); if(_pref->value("DefaultEllipsesAction") == "search") _ellipsesAction->setId(2); else _ellipsesAction->setId(1); _alternating->setChecked(!_pref->boolean("NoAlternatingRowColors")); //Hide for PostBooks if (_metrics->value("Application") == "PostBooks") { _scheduleMenu->hide(); _scheduleToolbar->hide(); } if (!_metrics->boolean("MultiWhs")) _warehouseGroup->hide(); _debug->setChecked(_pref->boolean("EnableScriptDebug")); sFillList(); sFillWarehouseList(); }
enum SetResponse dspItemSitesByParameterList::set(const ParameterList &pParams) { QVariant param; bool valid; param = pParams.value("warehous_id", &valid); if (valid) _warehouse->setId(param.toInt()); _showInactive->setChecked(pParams.inList("showInactive")); param = pParams.value("classcode_id", &valid); if (valid) { _parameter->setType(ClassCode); _parameter->setId(param.toInt()); } param = pParams.value("classcode_pattern", &valid); if (valid) { _parameter->setType(ClassCode); _parameter->setPattern(param.toString()); } param = pParams.value("classcode", &valid); if (valid) _parameter->setType(ClassCode); param = pParams.value("plancode_id", &valid); if (valid) { _parameter->setType(PlannerCode); _parameter->setId(param.toInt()); } param = pParams.value("plancode_pattern", &valid); if (valid) { _parameter->setType(PlannerCode); _parameter->setPattern(param.toString()); } param = pParams.value("plancode", &valid); if (valid) _parameter->setType(PlannerCode); param = pParams.value("itemgrp_id", &valid); if (valid) { _parameter->setType(ItemGroup); _parameter->setId(param.toInt()); } param = pParams.value("itemgrp_pattern", &valid); if (valid) { _parameter->setType(ItemGroup); _parameter->setPattern(param.toString()); } param = pParams.value("itemgrp", &valid); if (valid) _parameter->setType(ItemGroup); param = pParams.value("costcat_id", &valid); if (valid) { _parameter->setType(CostCategory); _parameter->setId(param.toInt()); } param = pParams.value("costcat_pattern", &valid); if (valid) { _parameter->setType(CostCategory); _parameter->setPattern(param.toString()); } param = pParams.value("costcat", &valid); if (valid) _parameter->setType(CostCategory); switch (_parameter->type()) { case ClassCode: setCaption(tr("Item Sites by Class Code")); break; case PlannerCode: setCaption(tr("Item Sites by Planner Code")); break; case ItemGroup: setCaption(tr("Item Sites by Item Group")); break; case CostCategory: setCaption(tr("Item Sites by Cost Category")); break; default: break; } if (pParams.inList("run")) { sFillList(); return NoError_Run; } return NoError; }
void BOM::sFillList() { sFillList(_item->id(), TRUE); }
void bbom::sFillList() { sFillList(_item->id(), FALSE); }
void reassignLotSerial::sReassign() { if (_source->currentItem() == 0) { QMessageBox::critical( this, tr("Select Source Location"), tr("You must select a Source Location before reassigning its Lot/Serial #.") ); _source->setFocus(); return; } if (_qty->toDouble() == 0) { QMessageBox::critical( this, tr("Enter Quantity to Reassign"), tr("You must enter a quantity to reassign.") ); _qty->setFocus(); return; } QDoubleValidator* qtyVal = (QDoubleValidator*)(_qty->validator()); q.prepare("SELECT reassignLotSerial(:source, CAST (:qty AS NUMERIC(100,:decimals)), " " :lotNumber, :expirationDate, :warrantyDate) AS result;"); q.bindValue(":source", _source->id()); q.bindValue(":qty", _qty->toDouble()); q.bindValue(":decimals", qtyVal->decimals()); q.bindValue(":lotNumber", _lotNumber->text()); if (_expirationDate->isEnabled()) q.bindValue(":expirationDate", _expirationDate->date()); else q.bindValue(":expirationDate", omfgThis->startOfTime()); if (_warrantyDate->isEnabled()) q.bindValue(":warrantyDate", _warrantyDate->date()); q.exec(); if (q.first()) { int result = q.value("result").toInt(); if (result < 0) { systemError(this, storedProcErrorLookup("reassignLotSerial", result), __FILE__, __LINE__); return; } } else if (q.lastError().type() != QSqlError::None) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } if (_captive) accept(); else { _close->setText(tr("&Close")); sFillList(); if (_qty->isEnabled()) _qty->clear(); _qty->setFocus(); _lotNumber->clear(); _expirationDate->setNull(); _warrantyDate->setNull(); } }
woList::woList(QWidget * parent, const char * name, bool modal, Qt::WFlags fl) : QDialog( parent, name, modal, fl ) { setCaption(tr("Work Orders")); _woid = -1; _type = 0; if ( !name ) setName( "woList" ); Q3VBoxLayout *mainLayout = new Q3VBoxLayout( this, 5, 5, "woListLayout"); Q3HBoxLayout *topLayout = new Q3HBoxLayout( 0, 0, 7, "topLayout"); Q3VBoxLayout *warehouseLayout = new Q3VBoxLayout( 0, 0, 0, "warehouseLayout"); Q3VBoxLayout *buttonsLayout = new Q3VBoxLayout( 0, 0, 5, "buttonsLayout"); Q3VBoxLayout *listLayout = new Q3VBoxLayout( 0, 0, 0, "listLayout"); _warehouse = new WarehouseGroup(this, "_warehouse"); warehouseLayout->addWidget(_warehouse); QSpacerItem* spacer = new QSpacerItem(0, 0, QSizePolicy::Minimum, QSizePolicy::Preferred); warehouseLayout->addItem(spacer); topLayout->addLayout(warehouseLayout); QSpacerItem* spacer_2 = new QSpacerItem(0, 0, QSizePolicy::Expanding, QSizePolicy::Minimum); topLayout->addItem(spacer_2); _close = new QPushButton(tr("&Cancel"), this, "_close"); buttonsLayout->addWidget(_close); _select = new QPushButton(tr("&Select"), this, "_select"); _select->setAutoDefault(TRUE); _select->setDefault(TRUE); buttonsLayout->addWidget(_select); topLayout->addLayout(buttonsLayout); mainLayout->addLayout(topLayout); QLabel *_workOrdersLit = new QLabel(tr("Work Orders:"), this, "_workOrdersLit"); listLayout->addWidget(_workOrdersLit); _wo = new XTreeWidget(this); _wo->setName("_wo"); listLayout->addWidget( _wo ); mainLayout->addLayout(listLayout); resize( QSize(484, 366).expandedTo(minimumSizeHint()) ); connect( _close, SIGNAL( clicked() ), this, SLOT( sClose() ) ); connect( _select, SIGNAL( clicked() ), this, SLOT( sSelect() ) ); connect( _wo, SIGNAL( itemSelected(int) ), this, SLOT( sSelect() ) ); connect( _warehouse, SIGNAL(updated()), this, SLOT( sFillList() ) ); setTabOrder(_warehouse, _wo); setTabOrder(_wo, _select); setTabOrder(_select, _close); setTabOrder(_close, _warehouse); _wo->setFocus(); _wo->addColumn(tr("W/O #"), _orderColumn, Qt::AlignLeft ); _wo->addColumn(tr("Status"), 40, Qt::AlignCenter ); _wo->addColumn(tr("Whs."), _whsColumn, Qt::AlignCenter ); _wo->addColumn(tr("Item Number"), _itemColumn, Qt::AlignLeft ); _wo->addColumn(tr("Description"), -1, Qt::AlignLeft ); }
void dspSingleLevelWhereUsed::sFillList() { sFillList(-1, FALSE); }
todoList::todoList(QWidget* parent, const char* name, Qt::WFlags fl) : XWidget(parent, name, fl) { setupUi(this); QSqlDatabase db = QSqlDatabase::database(); _parameterWidget->setType(tr("CRM Account"), "crmAccountId", ParameterWidget::Crmacct); _parameterWidget->setType(tr("Assigned"), "assigned_username", ParameterWidget::User, db.userName()); _parameterWidget->setType(tr("Owner"), "owner_username", ParameterWidget::User); _parameterWidget->setType(tr("Assigned Pattern"), "assigned_usr_pattern", ParameterWidget::Text); _parameterWidget->setType(tr("Owner Pattern"), "owner_usr_pattern", ParameterWidget::Text); _parameterWidget->setType(tr("Start Date Before"), "startStartDate", ParameterWidget::Date); _parameterWidget->setType(tr("Start Date After"), "startEndDate", ParameterWidget::Date); _parameterWidget->setType(tr("Due Date Before"), "dueStartDate", ParameterWidget::Date); _parameterWidget->setType(tr("Due Date After"), "dueEndDate", ParameterWidget::Date); _parameterWidget->applyDefaultFilterSet(); _crmAccount->hide(); q.exec("SELECT current_user;"); if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); close(); } connect(_parameterWidget, SIGNAL(updated()), this, SLOT(sFillList())); connect(_query, SIGNAL(clicked()), this, SLOT(sFillList())); connect(_autoUpdate, SIGNAL(toggled(bool)), this, SLOT(sHandleAutoUpdate(bool))); connect(_close, SIGNAL(clicked()), this, SLOT(sClose())); connect(_completed, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_delete, SIGNAL(clicked()), this, SLOT(sDelete())); connect(_todolist, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_incidents, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_projects, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_new, SIGNAL(clicked()), this, SLOT(sNew())); connect(_print, SIGNAL(clicked()), this, SLOT(sPrint())); connect(_todoList, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick())); connect(_todoList, SIGNAL(populateMenu(QMenu*, QTreeWidgetItem*, int)), this, SLOT(sPopulateMenu(QMenu*))); connect(_todoList, SIGNAL(itemSelectionChanged()), this, SLOT(handlePrivs())); connect(_edit, SIGNAL(clicked()), this, SLOT(sEdit())); connect(_view, SIGNAL(clicked()), this, SLOT(sView())); _todoList->addColumn(tr("Type"), _userColumn, Qt::AlignCenter, true, "type"); _todoList->addColumn(tr("Seq"), _seqColumn, Qt::AlignRight, false, "seq"); _todoList->addColumn(tr("Priority"), _userColumn, Qt::AlignLeft, true, "priority"); _todoList->addColumn(tr("Assigned To"),_userColumn, Qt::AlignLeft, true, "usr"); _todoList->addColumn(tr("Name"), 100, Qt::AlignLeft, true, "name"); _todoList->addColumn(tr("Description"), -1, Qt::AlignLeft, true, "descrip"); _todoList->addColumn(tr("Status"), _statusColumn, Qt::AlignLeft, true, "status"); _todoList->addColumn(tr("Start Date"),_dateColumn, Qt::AlignLeft, false, "start"); _todoList->addColumn(tr("Due Date"), _dateColumn, Qt::AlignLeft, true, "due"); _todoList->addColumn(tr("Parent#"), _orderColumn, Qt::AlignLeft, true, "number"); _todoList->addColumn(tr("Customer#"),_orderColumn, Qt::AlignLeft, false, "cust"); _todoList->addColumn(tr("Account#"), _orderColumn, Qt::AlignLeft, false, "crmacct_number"); _todoList->addColumn(tr("Account Name"), 100, Qt::AlignLeft, true, "crmacct_name"); _todoList->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, false,"owner"); int menuItem; QMenu * todoMenu = new QMenu; menuItem = todoMenu->insertItem(tr("Incident"), this, SLOT(sNewIncdt())); if (!_privileges->check("MaintainIncidents")) todoMenu->setItemEnabled(menuItem, FALSE); menuItem = todoMenu->insertItem(tr("To-Do Item"), this, SLOT(sNew())); if (!_privileges->check("MaintainPersonalTodoList") && !_privileges->check("MaintainOtherTodoLists")) todoMenu->setItemEnabled(menuItem, FALSE); _new->setMenu(todoMenu); if (_preferences->boolean("XCheckBox/forgetful")) _incidents->setChecked(true); handlePrivs(); sHandleAutoUpdate(_autoUpdate->isChecked()); }
void dspCustomersByCharacteristic::sFillList() { sFillList(-1, TRUE); }
void todoList::sDelete() { QString recurstr; QString recurtype; if (_todoList->altId() == 1) { recurstr = "SELECT MAX(todoitem_due_date) AS max" " FROM todoitem" " WHERE todoitem_recurring_todoitem_id=:id" " AND todoitem_id!=:id;" ; recurtype = "TODO"; } /* TODO: can't delete incidents from here. why not? else if (_todoList->altId() == 2) { recurstr = "SELECT MAX(incdt_timestamp) AS max" " FROM incdt" " WHERE incdt_recurring_incdt_id=:id;" ; recurtype = "INCDT"; } */ bool deleteAll = false; bool createMore = false; if (! recurstr.isEmpty()) { XSqlQuery recurq; recurq.prepare(recurstr); recurq.bindValue(":id", _todoList->id()); recurq.exec(); if (recurq.first()) { QMessageBox askdelete(QMessageBox::Question, tr("Delete Recurring Item?"), tr("<p>This is a recurring item. Do you want to " "delete just this one item or delete all open " "items in this recurrence?"), QMessageBox::Yes | QMessageBox::YesToAll | QMessageBox::Cancel, this); askdelete.setDefaultButton(QMessageBox::Cancel); int ret = askdelete.exec(); if (ret == QMessageBox::Cancel) return; else if (ret == QMessageBox::YesToAll) deleteAll = true; // user said delete one but the only one that exists is the base else if (ret == QMessageBox::Yes && recurq.value("max").isNull()) createMore = true; } else if (recurq.lastError().type() != QSqlError::NoError) { systemError(this, recurq.lastError().text(), __FILE__, __LINE__); return; } } else if (QMessageBox::warning(this, tr("Delete List Item?"), tr("<p>Are you sure that you want to " "completely delete the selected item?"), QMessageBox::Yes | QMessageBox::No, QMessageBox::No) == QMessageBox::No) return; QString procname; int procresult = 0; if (deleteAll) { procname = "deleteOpenRecurringItems"; q.prepare("SELECT deleteOpenRecurringItems(:id, :type, NULL, TRUE)" " AS result;"); q.bindValue(":id", _todoList->id()); q.bindValue(":type", recurtype); q.exec(); if (q.first()) procresult = q.value("result").toInt(); } if (procresult >= 0 && createMore) { procname = "createRecurringItems"; q.prepare("SELECT createRecurringItems(:id, :type) AS result;"); q.bindValue(":id", _todoList->id()); q.bindValue(":type", recurtype); q.exec(); if (q.first()) procresult = q.value("result").toInt(); } // not elseif - error handling for 1 or 2 queries if (procresult < 0) { systemError(this, storedProcErrorLookup(procname, procresult)); return; } else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } if (_todoList->altId() == 1) q.prepare("SELECT deleteTodoItem(:todoitem_id) AS result;"); else if (_todoList->altId() == 3) q.prepare("DELETE FROM prjtask" " WHERE (prjtask_id=:todoitem_id); "); else if (_todoList->altId() == 4) q.prepare("SELECT deleteProject(:todoitem_id) AS result"); else return; q.bindValue(":todoitem_id", _todoList->id()); q.exec(); if (q.first()) { int result = q.value("result").toInt(); if (result < 0) { systemError(this, storedProcErrorLookup("deleteTodoItem", result)); return; } } else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return; } sFillList(); }
void viewCheckRun::sFillList(int pBankaccntid) { if (pBankaccntid == _bankaccnt->id()) sFillList(); }
enum SetResponse dspSalesHistory::set(const ParameterList &pParams) { XWidget::set(pParams); QVariant param; bool valid; parameterWidget()->setSavedFilters(); param = pParams.value("cohead_id", &valid); if (valid) parameterWidget()->setDefault(tr("Sales Order"), param.toInt()); param = pParams.value("cust_id", &valid); if (valid) parameterWidget()->setDefault(tr("Customer"), param.toInt()); param = pParams.value("custtype_id", &valid); if (valid) parameterWidget()->setDefault(tr("Customer Type"), param.toInt()); param = pParams.value("custtype_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Customer Type Pattern"), param.toString()); param = pParams.value("item_id", &valid); if (valid) parameterWidget()->setDefault(tr("Item"), param.toInt()); param = pParams.value("prodcat_id", &valid); if (valid) parameterWidget()->setDefault(tr("Product Category"), param.toInt()); param = pParams.value("prodcat_pattern", &valid); if (valid) parameterWidget()->setDefault(tr("Product Category Pattern"), param.toString()); param = pParams.value("salesrep_id", &valid); if (valid) parameterWidget()->setDefault(tr("Sales Rep."), param.toInt()); param = pParams.value("startDate", &valid); if (valid) parameterWidget()->setDefault(tr("Invoice Start Date"), param.toDate()); else parameterWidget()->setDefault(tr("Invoice Start Date"), QVariant()); param = pParams.value("endDate", &valid); if (valid) parameterWidget()->setDefault(tr("Invoice End Date"), param.toDate()); else parameterWidget()->setDefault(tr("Invoice End Date"), QVariant()); param = pParams.value("shipStartDate", &valid); if (valid) parameterWidget()->setDefault(tr("Ship Start Date"), param.toDate()); else parameterWidget()->setDefault(tr("Ship Start Date"), QVariant()); param = pParams.value("shipEndDate", &valid); if (valid) parameterWidget()->setDefault(tr("Ship End Date"), param.toDate()); else parameterWidget()->setDefault(tr("Ship End Date"), QVariant()); param = pParams.value("shipzone_id", &valid); if (valid) parameterWidget()->setDefault(tr("Shipping Zones"), param.toInt()); param = pParams.value("warehous_id", &valid); if (valid) parameterWidget()->setDefault(tr("Site"), param.toInt()); parameterWidget()->applyDefaultFilterSet(); if (pParams.inList("run")) { sFillList(); return NoError_Run; } return NoError; }
enum SetResponse customerGroup::set(const ParameterList &pParams) { XDialog::set(pParams); QVariant param; bool valid; param = pParams.value("custgrp_id", &valid); if (valid) { _custgrpid = param.toInt(); populate(); } param = pParams.value("mode", &valid); if (valid) { if (param.toString() == "new") { _mode = cNew; q.exec("SELECT NEXTVAL('custgrp_custgrp_id_seq') AS _custgrp_id;"); if (q.first()) _custgrpid = q.value("_custgrp_id").toInt(); else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); return UndefinedError; } connect(_custgrpitem, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool))); _name->setFocus(); } else if (param.toString() == "edit") { _mode = cEdit; sFillList(); connect(_custgrpitem, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool))); _name->setFocus(); } else if (param.toString() == "view") { _mode = cView; _name->setEnabled(FALSE); _descrip->setEnabled(FALSE); _new->setEnabled(FALSE); _close->setText(tr("&Close")); _save->hide(); sFillList(); _close->setFocus(); } } return NoError; }
void itemPricingSchedule::sFillList() { sFillList(-1); }
enum SetResponse purchaseOrder::set(const ParameterList &pParams) { QVariant param; bool valid; int itemsiteid; int parentwo = -1; int parentso = -1; int prjid = -1; double qty; QDate dueDate; setPoheadid(-1); int _prid = -1; param = pParams.value("pr_id", &valid); if (valid) _prid = param.toInt(); param = pParams.value("itemsite_id", &valid); if (valid) itemsiteid = param.toInt(); else itemsiteid = -1; param = pParams.value("qty", &valid); if (valid) qty = param.toDouble(); else qty = 0.0; param = pParams.value("dueDate", &valid); if (valid) dueDate = param.toDate(); param = pParams.value("mode", &valid); if (valid) { if ( (param.toString() == "new") || (param.toString() == "releasePr") ) { _mode = cNew; if (param.toString() == "releasePr") { q.prepare( "SELECT pr_itemsite_id, pr_qtyreq, pr_duedate," " CASE WHEN(pr_order_type='W') THEN" " COALESCE((SELECT womatl_wo_id FROM womatl WHERE womatl_id=pr_order_id),-1)" " ELSE -1" " END AS parentwo," " CASE WHEN(pr_order_type='S') THEN pr_order_id" " ELSE -1" " END AS parentso," " pr_prj_id " "FROM pr " "WHERE (pr_id=:pr_id);" ); q.bindValue(":pr_id", _prid); q.exec(); if (q.first()) { itemsiteid = q.value("pr_itemsite_id").toInt(); qty = q.value("pr_qtyreq").toDouble(); dueDate = q.value("pr_duedate").toDate(); parentwo = q.value("parentwo").toInt(); parentso = q.value("parentso").toInt(); prjid = q.value("pr_prj_id").toInt(); } else { systemError(this, tr("A System Error occurred at %1::%2.") .arg(__FILE__) .arg(__LINE__) ); return UndefinedError; } } connect(_poitem, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick())); connect(_poitem, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool))); connect(_poitem, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick())); connect(_vendor, SIGNAL(valid(bool)), _new, SLOT(setEnabled(bool))); //_new->setEnabled(TRUE); if (itemsiteid != -1) { q.prepare( "SELECT itemsite_item_id, itemsrc_id " "FROM itemsite, itemsrc " "WHERE ( (itemsrc_item_id=itemsite_item_id)" " AND (itemsite_id=:itemsite_id) ) " "LIMIT 1;" ); q.bindValue(":itemsite_id", itemsiteid); q.exec(); if (!q.first()) { QMessageBox::warning(omfgThis, tr("Cannot Create P/O"), tr("<p>A Purchase Order cannot be automatically " "created for this Item as there are no Item " "Sources for it. You must create one or " "more Item Sources for this Item before " "the application can automatically create " "Purchase Orders for it." ) ); return UndefinedError; } ParameterList itemSourceParams; itemSourceParams.append("item_id", q.value("itemsite_item_id").toInt()); itemSourceParams.append("qty", qty); itemSourceList newdlg(omfgThis, "", TRUE); newdlg.set(itemSourceParams); int itemsrcid = newdlg.exec(); if (itemsrcid == XDialog::Rejected) { deleteLater(); return UndefinedError; } q.prepare( "SELECT itemsrc_vend_id " "FROM itemsrc " "WHERE (itemsrc_id=:itemsrc_id);" ); q.bindValue(":itemsrc_id", itemsrcid); q.exec(); if (!q.first()) { systemError(this, tr("A System Error occurred at %1::%2.") .arg(__FILE__) .arg(__LINE__) ); return UndefinedError; } else { int vendid = q.value("itemsrc_vend_id").toInt();; q.prepare( "SELECT pohead_id " "FROM pohead " "WHERE ( (pohead_status='U')" " AND (pohead_vend_id=:vend_id) ) " "ORDER BY pohead_number " "LIMIT 1;" ); q.bindValue(":vend_id", vendid); q.exec(); if (q.first()) { if(QMessageBox::question( this, tr("An Open Purchase Order Exists"), tr("An Open Purchase Order already exists for this Vendor.\n" "Would you like to use this Purchase Order?\n" "Click Yes to use the existing Purchase Order otherwise a new one will be created."), QMessageBox::Yes | QMessageBox::No, QMessageBox::Yes) == QMessageBox::Yes) { // Use an existing pohead _mode = cEdit; setPoheadid(q.value("pohead_id").toInt()); _orderNumber->setEnabled(FALSE); _orderDate->setEnabled(FALSE); _vendor->setReadOnly(TRUE); populate(); } else { _vendor->setId(vendid); createHeader(); } } else { // Create a new pohead for the chosen vend _vendor->setId(vendid); createHeader(); } // Start to create the new Poitem ParameterList newItemParams; newItemParams.append("mode", "new"); newItemParams.append("pohead_id", _poheadid); newItemParams.append("itemsrc_id", itemsrcid); if (qty > 0.0) newItemParams.append("qty", qty); if (!dueDate.isNull()) newItemParams.append("dueDate", dueDate); if (parentwo != -1) newItemParams.append("parentWo", parentwo); if (parentso != -1) newItemParams.append("parentSo", parentso); if (prjid != -1) newItemParams.append("prj_id", prjid); purchaseOrderItem poItem(this, "", TRUE); poItem.set(newItemParams); if (poItem.exec() != XDialog::Rejected) { if(_mode == cEdit) { // check for another open window QWidgetList list = omfgThis->windowList(); for(int i = 0; i < list.size(); i++) { QWidget * w = list.at(i); if(w->isA("purchaseOrder") && w != this) { purchaseOrder *other = (purchaseOrder*)w; if(_poheadid == other->_poheadid) { if(_prid != -1 && cEdit == other->_mode) { q.prepare("SELECT deletePr(:pr_id) AS _result;"); q.bindValue(":pr_id", _prid); q.exec(); omfgThis->sPurchaseRequestsUpdated(); } other->sFillList(); other->setFocus(); return UndefinedError; } } } } sFillList(); } else _prid = -1; } } else // This is a new P/O without a chosen Itemsite Line Item createHeader(); } else if (param.toString() == "edit") { _mode = cEdit; _orderNumber->setEnabled(FALSE); _orderDate->setEnabled(FALSE); _warehouse->setEnabled(FALSE); _vendor->setReadOnly(TRUE); connect(_poitem, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool))); connect(_poitem, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick())); _new->setEnabled(TRUE); } else if (param.toString() == "view") { _mode = cView; _orderNumber->setEnabled(FALSE); _orderDate->setEnabled(FALSE); _warehouse->setEnabled(FALSE); _taxZone->setEnabled(FALSE); _agent->setEnabled(FALSE); _terms->setEnabled(FALSE); _terms->setType(XComboBox::Terms); _vendor->setReadOnly(TRUE); _shipVia->setEnabled(FALSE); _fob->setEnabled(FALSE); _notes->setEnabled(FALSE); _new->setEnabled(FALSE); _freight->setEnabled(FALSE); _tax->setEnabled(FALSE); _vendaddrList->hide(); _purchaseOrderInformation->removePage(_quickEntryTab); _poCurrency->setEnabled(FALSE); _qeitemView->setEnabled(FALSE); _qesave->setEnabled(FALSE); _qedelete->setEnabled(FALSE); _qecurrency->setEnabled(FALSE); _comments->setReadOnly(TRUE); _delete->hide(); _edit->setText(tr("&View")); _close->setText(tr("&Close")); _save->hide(); connect(_poitem, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick())); connect(_poitem, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool))); _close->setFocus(); } } if (_prid != -1 && cNew != _mode) { q.prepare("SELECT deletePr(:pr_id) AS _result;"); q.bindValue(":pr_id", _prid); q.exec(); _prid = -1; omfgThis->sPurchaseRequestsUpdated(); } if(_prid != -1) _pridList.append(_prid); param = pParams.value("pohead_id", &valid); if (valid) { setPoheadid(param.toInt()); populate(); } return NoError; }
opportunityList::opportunityList(QWidget* parent, const char* name, Qt::WFlags fl) : XWidget(parent, name, fl) { setupUi(this); _targetDates->setStartNull(tr("Earliest"), omfgThis->startOfTime(), TRUE); _targetDates->setEndNull(tr("Latest"), omfgThis->endOfTime(), TRUE); _targetDates->setStartCaption(tr("First Target Date:")); _targetDates->setEndCaption(tr("Last Target Date:")); _usrGroup->setEnabled(_privileges->check("MaintainOtherTodoLists")); q.exec("SELECT current_user;"); if (q.first()) _usr->setUsername(q.value("current_user").toString()); else if (q.lastError().type() != QSqlError::NoError) { systemError(this, q.lastError().databaseText(), __FILE__, __LINE__); close(); } connect(_close, SIGNAL(clicked()), this, SLOT(sClose())); connect(_delete, SIGNAL(clicked()), this, SLOT(sDelete())); connect(_crmAccount, SIGNAL(newId(int)), this, SLOT(sFillList())); connect(_showInactive, SIGNAL(toggled(bool)), this, SLOT(sFillList())); connect(_search, SIGNAL(lostFocus()), this, SLOT(sFillList())); connect(_targetDates, SIGNAL(updated()), this, SLOT(sFillList())); connect(_opsource, SIGNAL(updated()), this, SLOT(sFillList())); connect(_opstage, SIGNAL(updated()), this, SLOT(sFillList())); connect(_optype, SIGNAL(updated()), this, SLOT(sFillList())); connect(_all, SIGNAL(clicked()), this, SLOT(sFillList())); connect(_selected, SIGNAL(clicked()), this, SLOT(sFillList())); connect(_usr, SIGNAL(newId(int)), this, SLOT(sFillList())); connect(_pattern, SIGNAL(editingFinished()), this, SLOT(sFillList())); connect(_edit, SIGNAL(clicked()), this, SLOT(sEdit())); connect(_new, SIGNAL(clicked()), this, SLOT(sNew())); connect(_print, SIGNAL(clicked()), this, SLOT(sPrint())); connect(_list, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick())); connect(_list, SIGNAL(populateMenu(QMenu*, QTreeWidgetItem*, int)), this, SLOT(sPopulateMenu(QMenu*))); connect(_view, SIGNAL(clicked()), this, SLOT(sView())); connect(_more, SIGNAL(clicked()), this, SLOT(sHandleMore())); connect(_usePattern, SIGNAL(toggled(bool)), _pattern, SLOT(setEnabled(bool))); if(_privileges->check("MaintainOpportunities")) { connect(_list, SIGNAL(valid(bool)), _edit, SLOT(setEnabled(bool))); connect(_list, SIGNAL(valid(bool)), _view, SLOT(setEnabled(bool))); connect(_list, SIGNAL(valid(bool)), _delete, SLOT(setEnabled(bool))); connect(_list, SIGNAL(itemSelected(int)), _edit, SLOT(animateClick())); } else { connect(_list, SIGNAL(valid(bool)), _view, SLOT(setEnabled(bool))); connect(_list, SIGNAL(itemSelected(int)), _view, SLOT(animateClick())); } // statusBar()->hide(); _list->addColumn(tr("Active"), _orderColumn, Qt::AlignLeft, false, "ophead_active" ); _list->addColumn(tr("Name"), -1, Qt::AlignLeft, true, "ophead_name" ); _list->addColumn(tr("CRM Acct."), _userColumn, Qt::AlignLeft, true, "crmacct_number" ); _list->addColumn(tr("Owner"), _userColumn, Qt::AlignLeft, true, "ophead_owner_username" ); _list->addColumn(tr("Stage"), _orderColumn, Qt::AlignLeft, true, "opstage_name" ); _list->addColumn(tr("Source"), _orderColumn, Qt::AlignLeft, false, "opsource_name" ); _list->addColumn(tr("Type"), _orderColumn, Qt::AlignLeft, false, "optype_name" ); _list->addColumn(tr("Prob.%"), _prcntColumn, Qt::AlignCenter, false, "ophead_probability_prcnt" ); _list->addColumn(tr("Amount"), _moneyColumn, Qt::AlignRight, false, "ophead_amount" ); _list->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, false, "f_currency" ); _list->addColumn(tr("Target Date"), _dateColumn, Qt::AlignLeft, false, "ophead_target_date" ); _list->addColumn(tr("Actual Date"), _dateColumn, Qt::AlignLeft, false, "ophead_actual_date" ); _more->setChecked(_preferences->boolean("opListShowAll")); sHandleMore(); _search->setFocus(); }
transferOrderList::transferOrderList( QWidget* parent, const char* name, bool modal, Qt::WFlags fl ) : QDialog( parent, name, modal, fl ) { if ( !name ) setObjectName( "transferOrderList" ); _toheadid = -1; _type = (cToOpen | cToClosed); setWindowTitle(tr("Transfer Orders")); QVBoxLayout *mainLayout = new QVBoxLayout(this, 5, 5, "mainLayout"); QHBoxLayout *warehouseLayout = new QHBoxLayout(0, 0, 0, "warehouseLayout"); QHBoxLayout *topLayout = new QHBoxLayout( 0, 0, 7, "topLayout"); QVBoxLayout *buttonsLayout = new QVBoxLayout(0, 0, 5, "buttonsLayout"); QVBoxLayout *listLayout = new QVBoxLayout( 0, 0, 0, "listLayout"); _srcwhs = new WarehouseGroup(this, "_srcwhs"); _srcwhs->setTitle(tr("From Site:")); _dstwhs = new WarehouseGroup(this, "_dstwhs"); _dstwhs->setTitle(tr("To Site:")); _dstwhs->setAll(); warehouseLayout->addWidget(_srcwhs); warehouseLayout->addWidget(_dstwhs); QSpacerItem* spacer = new QSpacerItem(0, 0, QSizePolicy::Minimum, QSizePolicy::Preferred); warehouseLayout->addItem(spacer); topLayout->addLayout(warehouseLayout); QSpacerItem* spacer_2 = new QSpacerItem(0, 0, QSizePolicy::Expanding, QSizePolicy::Minimum); topLayout->addItem(spacer_2); _close = new QPushButton(tr("&Cancel"), this, "_close"); buttonsLayout->addWidget(_close); _select = new QPushButton(tr("&Select"), this, "_select"); _select->setEnabled( FALSE ); _select->setDefault( TRUE ); buttonsLayout->addWidget(_select); topLayout->addLayout(buttonsLayout); mainLayout->addLayout(topLayout); QLabel *_transferOrdersLit = new QLabel(tr("Transfer Orders:"), this, "_transferOrdersLit"); listLayout->addWidget(_transferOrdersLit); _to = new XTreeWidget(this); _to->setObjectName("_to"); listLayout->addWidget(_to); mainLayout->addLayout(listLayout); resize( QSize(490, 390).expandedTo(minimumSizeHint()) ); connect(_close, SIGNAL(clicked()), this, SLOT( sClose() ) ); connect(_dstwhs, SIGNAL(updated()), this, SLOT( sFillList() ) ); connect(_select, SIGNAL(clicked()), this, SLOT( sSelect() ) ); connect(_srcwhs, SIGNAL(updated()), this, SLOT( sFillList() ) ); connect(_to, SIGNAL(valid(bool)), _select, SLOT( setEnabled(bool) ) ); connect(_to, SIGNAL(itemSelected(int)), _select, SLOT( animateClick() ) ); _to->addColumn(tr("Order #"), _orderColumn, Qt::AlignLeft, true, "tohead_number"); _to->addColumn(tr("From Whs."), -1, Qt::AlignLeft, true, "tohead_srcname"); _to->addColumn(tr("To Whs."), _orderColumn, Qt::AlignLeft, true, "tohead_destname"); _to->addColumn(tr("Ordered"), _dateColumn, Qt::AlignCenter, true, "tohead_orderdate"); _to->addColumn(tr("Scheduled"),_dateColumn, Qt::AlignCenter,true, "scheddate"); setTabOrder(_srcwhs, _dstwhs); setTabOrder(_dstwhs, _to); setTabOrder(_to, _select); setTabOrder(_select, _close); setTabOrder(_close, _srcwhs); _srcwhs->setFocus(); }
arWorkBench::arWorkBench(QWidget* parent, const char* name, Qt::WFlags fl) : XWidget(parent, name, fl) { setupUi(this); _aritems = new dspAROpenItems(this, "_aritems", Qt::Widget); _aropenFrame->layout()->addWidget(_aritems); _aritems->setCloseVisible(false); _aritems->findChild<QWidget*>("_customerSelector")->hide(); _aritems->queryAction()->setVisible(false); _aritems->findChild<QWidget*>("_asofGroup")->hide(); _aritems->findChild<DLineEdit*>("_asOf")->setDate(omfgThis->endOfTime()); _aritems->findChild<QWidget*>("_dateGroup")->hide(); _aritems->findChild<QWidget*>("_showGroup")->hide(); _aritems->findChild<QWidget*>("_printGroup")->hide(); _aritems->findChild<QRadioButton*>("_dueDate")->click(); _cctrans = new dspCreditCardTransactions(this, "_cctrans", Qt::Widget); _creditCardTab->layout()->addWidget(_cctrans); _cctrans->findChild<QWidget*>("_close")->hide(); _cctrans->findChild<QWidget*>("_customerSelector")->hide(); _cctrans->findChild<QWidget*>("_query")->hide(); _cctrans->findChild<QWidget*>("_alltrans")->hide(); _cctrans->findChild<QWidget*>("_pending")->hide(); _cctrans->findChild<QWidget*>("_processed")->hide(); _cctrans->findChild<XTreeWidget*>("_preauth")->hideColumn("type"); _cctrans->findChild<XTreeWidget*>("_preauth")->hideColumn("status"); connect(_query, SIGNAL(clicked()), this, SLOT(sFillList())); connect(_newCashrcpt, SIGNAL(clicked()), this, SLOT(sNewCashrcpt())); connect(_editCashrcpt, SIGNAL(clicked()), this, SLOT(sEditCashrcpt())); connect(_viewCashrcpt, SIGNAL(clicked()), this, SLOT(sViewCashrcpt())); connect(_deleteCashrcpt, SIGNAL(clicked()), this, SLOT(sDeleteCashrcpt())); connect(_postCashrcpt, SIGNAL(clicked()), this, SLOT(sPostCashrcpt())); connect(_cashrcpt, SIGNAL(populateMenu(QMenu*, QTreeWidgetItem*)), this, SLOT(sPopulateCashRcptMenu(QMenu*))); connect(_customerSelector, SIGNAL(newState(int)), this, SLOT(sClear())); connect(_customerSelector, SIGNAL(newCustId(int)), this, SLOT(sClear())); connect(_customerSelector, SIGNAL(newCustTypeId(int)), this, SLOT(sClear())); connect(_customerSelector, SIGNAL(newTypePattern(QString)), this, SLOT(sClear())); connect(_customerSelector, SIGNAL(newCustGroupId(int)), this, SLOT(sClear())); connect(_customerSelector, SIGNAL(newState(int)), _aritems->findChild<CustomerSelector*>("_customerSelector"), SLOT(setState(int))); connect(_customerSelector, SIGNAL(newCustId(int)), _aritems->findChild<CustomerSelector*>("_customerSelector"), SLOT(setCustId(int))); connect(_customerSelector, SIGNAL(newCustTypeId(int)), _aritems->findChild<CustomerSelector*>("_customerSelector"), SLOT(setCustTypeId(int))); connect(_customerSelector, SIGNAL(newCustGroupId(int)), _aritems->findChild<CustomerSelector*>("_customerSelector"), SLOT(setCustGroupId(int))); connect(_customerSelector, SIGNAL(newTypePattern(QString)), _aritems->findChild<CustomerSelector*>("_customerSelector"), SLOT(setTypePattern(QString))); connect(_customerSelector, SIGNAL(newState(int)), _cctrans->findChild<CustomerSelector*>("_customerSelector"), SLOT(setState(int))); connect(_customerSelector, SIGNAL(newCustId(int)), _cctrans->findChild<CustomerSelector*>("_customerSelector"), SLOT(setCustId(int))); connect(_customerSelector, SIGNAL(newCustTypeId(int)), _cctrans->findChild<CustomerSelector*>("_customerSelector"), SLOT(setCustTypeId(int))); connect(_customerSelector, SIGNAL(newCustGroupId(int)), _cctrans->findChild<CustomerSelector*>("_customerSelector"), SLOT(setCustGroupId(int))); connect(_customerSelector, SIGNAL(newTypePattern(QString)), _cctrans->findChild<CustomerSelector*>("_customerSelector"), SLOT(setTypePattern(QString))); connect(_debits, SIGNAL(clicked()), _aritems->findChild<QRadioButton*>("_debits"), SLOT(click())); connect(_credits, SIGNAL(clicked()), _aritems->findChild<QRadioButton*>("_credits"), SLOT(click())); connect(_both, SIGNAL(clicked()), _aritems->findChild<QRadioButton*>("_both"), SLOT(click())); connect(_searchDocNum, SIGNAL(textChanged(const QString&)), this, SLOT(sSearchDocNumChanged())); _cashrcpt->addColumn(tr("Cust. #"), _bigMoneyColumn, Qt::AlignLeft, true, "cust_number"); _cashrcpt->addColumn(tr("Name"), -1, Qt::AlignLeft, true, "cust_name"); _cashrcpt->addColumn(tr("Check/Doc. #"), _orderColumn, Qt::AlignLeft, true, "cashrcpt_docnumber"); _cashrcpt->addColumn(tr("Bank Account"), _orderColumn, Qt::AlignLeft, true, "bankaccnt_name"); _cashrcpt->addColumn(tr("Dist. Date"), _dateColumn, Qt::AlignCenter,true, "cashrcpt_distdate"); _cashrcpt->addColumn(tr("Funds Type"), _bigMoneyColumn, Qt::AlignCenter,true, "cashrcpt_fundstype"); _cashrcpt->addColumn(tr("Amount"), _bigMoneyColumn, Qt::AlignRight, true, "cashrcpt_amount"); _cashrcpt->addColumn(tr("Currency"), _currencyColumn, Qt::AlignLeft, true, "currabbr"); if (_privileges->check("MaintainCashReceipts")) { connect(_cashrcpt, SIGNAL(valid(bool)), _editCashrcpt, SLOT(setEnabled(bool))); connect(_cashrcpt, SIGNAL(valid(bool)), _deleteCashrcpt, SLOT(setEnabled(bool))); if (_privileges->check("PostCashReceipts")) connect(_cashrcpt, SIGNAL(valid(bool)), _postCashrcpt, SLOT(setEnabled(bool))); } else { _newCashrcpt->setEnabled(FALSE); connect(_cashrcpt, SIGNAL(itemSelected(int)), _viewCashrcpt, SLOT(animateClick())); } if(_privileges->check("PostCashReceipts")) connect(_cashrcpt, SIGNAL(itemSelected(int)), _editCashrcpt, SLOT(animateClick())); connect(omfgThis, SIGNAL(cashReceiptsUpdated(int, bool)), this, SLOT(sFillList())); if (omfgThis->singleCurrency()) _cashrcpt->hideColumn(2); if (!_metrics->boolean("CCAccept") || !_privileges->check("ProcessCreditCards")) _tab->removeTab(_tab->indexOf(_creditCardTab)); }