void address::sEdit()
{
internalSave();
switch (_uses->altId())
{
case 1:
sEditContact();
break;
case 2:
sEditShipto();
break;
case 3:
sEditVendor();
break;
case 4:
sEditVendorAddress();
break;
case 5:
sEditWarehouse();
break;
default:
break;
}
// force AddressCluster to reload its data
int tmpAddrId = _addr->id();
_addr->setId(-1);
_addr->setId(tmpAddrId);
sPopulate();
}
void contact::sEditUse()
{
switch (_uses->altId())
{
case 1:
case 2:
sEditCRMAccount();
break;
case 3:
case 4:
sEditCustomer();
break;
case 5:
case 6:
sEditVendor();
break;
case 7:
sEditProspect();
break;
case 8:
sEditShipto();
break;
case 9:
sEditVendorAddress();
break;
case 10:
sEditWarehouse();
break;
case 11:
sEditEmployee();
break;
default:
break;
}
}
void crmaccount::sPopulate()
{
q.prepare( "SELECT * "
"FROM crmacct "
"WHERE (crmacct_id=:crmacct_id);" );
q.bindValue(":crmacct_id", _crmacctId);
q.exec();
if (q.first())
{
_number->setText(q.value("crmacct_number").toString());
_name->setText(q.value("crmacct_name").toString());
_active->setChecked(q.value("crmacct_active").toBool());
QString acctType = q.value("crmacct_type").toString();
if (acctType == "O")
_organization->setChecked(true);
else if (acctType == "I")
_individual->setChecked(true);
else
qWarning("crmaccount::sPopulate() - acctType '%s' incorrect", acctType.toLatin1().data());
_custId = q.value("crmacct_cust_id").toInt();
_competitorId = q.value("crmacct_competitor_id").toInt();
_partnerId = q.value("crmacct_partner_id").toInt();
_prospectId = q.value("crmacct_prospect_id").toInt();
_vendId = q.value("crmacct_vend_id").toInt();
_taxauthId = q.value("crmacct_taxauth_id").toInt();
_primary->setId(q.value("crmacct_cntct_id_1").toInt());
_secondary->setId(q.value("crmacct_cntct_id_2").toInt());
_notes->setText(q.value("crmacct_notes").toString());
_parentCrmacct->setId(q.value("crmacct_parent_id").toInt());
_comments->setId(_crmacctId);
_documents->setId(_crmacctId);
_primary->setSearchAcct(_crmacctId);
_secondary->setSearchAcct(_crmacctId);
_owner->setUsername(q.value("crmacct_owner_username").toString());
_customer->setDisabled(_customer->isChecked());
_prospect->setChecked(_prospectId > 0);
_prospect->setDisabled(_customer->isChecked());
_taxauth->setChecked(_taxauthId > 0);
if (_custId > 0)
{
_customer->setChecked(true);
if (_privileges->check("MaintainCustomerMasters") ||
_privileges->check("ViewCustomerMasters") )
_customerButton->setEnabled(true);
}
if (_vendId > 0)
{
_vendor->setChecked(true);
_vendorButton->setText("Vendor");
disconnect(_vendorButton, SIGNAL(clicked()), this, SLOT(sEditVendor()));
QMenu * vendorMenu = new QMenu;
QAction *menuItem;
menuItem=vendorMenu->addAction(tr("Edit..."), this, SLOT(sEditVendor()));
menuItem->setEnabled(_privileges->check("MaintainVendors") &&
(_mode == cEdit));
menuItem=vendorMenu->addAction(tr("View..."), this, SLOT(sViewVendor()));
menuItem->setEnabled(_privileges->check("ViewVendors") ||
_privileges->check("MaintainVendors"));
menuItem=vendorMenu->addAction(tr("Workbench..."), this, SLOT(sVendorInfo()));
menuItem->setEnabled(_privileges->check("MaintainVendors"));
_vendorButton->setMenu(vendorMenu);
}
_partner->setChecked(_partnerId > 0);
_competitor->setChecked(_competitorId > 0);
}
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
sGetCharacteristics();
sPopulateRegistrations();
_contacts->sFillList();
_todoList->sFillList();
_oplist->sFillList();
}
crmaccount::crmaccount(QWidget* parent, const char* name, Qt::WFlags fl)
: XWidget(parent, name, fl)
{
setupUi(this);
_todoList = new todoList(this, "todoList", Qt::Widget);
_todoListTab->layout()->addWidget(_todoList);
_todoList->setCloseVisible(false);
_todoList->list()->hideColumn("crmacct_number");
_todoList->list()->hideColumn("crmacct_name");
_todoList->parameterWidget()->setDefault(tr("Assigned"), QVariant(), true);
_todoList->setParameterWidgetVisible(false);
_todoList->setQueryOnStartEnabled(false);
_contacts = new contacts(this, "contacts", Qt::Widget);
_allPage->layout()->addWidget(_contacts);
_contacts->setCloseVisible(false);
_contacts->list()->hideColumn("crmacct_number");
_contacts->list()->hideColumn("crmacct_name");
_contacts->setParameterWidgetVisible(false);
_contacts->setQueryOnStartEnabled(false);
_oplist = new opportunityList(this, "opportunityList", Qt::Widget);
_oplistTab->layout()->addWidget(_oplist);
_oplist->setCloseVisible(false);
_oplist->list()->hideColumn("crmacct_number");
_oplist->parameterWidget()->setDefault(tr("User"), QVariant(), true);
_oplist->setParameterWidgetVisible(false);
_oplist->setQueryOnStartEnabled(false);
if(!_privileges->check("EditOwner")) _owner->setEnabled(false);
_owner->setUsername(omfgThis->username());
_owner->setType(UsernameLineEdit::UsersActive);
connect(_close, SIGNAL(clicked()), this, SLOT(sClose()));
connect(_competitor, SIGNAL(clicked()), this, SLOT(sCompetitor()));
connect(_deleteCharacteristic,SIGNAL(clicked()), this, SLOT(sDeleteCharacteristic()));
connect(_deleteReg, SIGNAL(clicked()), this, SLOT(sDeleteReg()));
connect(_editCharacteristic, SIGNAL(clicked()), this, SLOT(sEditCharacteristic()));
connect(_editReg, SIGNAL(clicked()), this, SLOT(sEditReg()));
connect(_newCharacteristic, SIGNAL(clicked()), this, SLOT(sNewCharacteristic()));
connect(_newReg, SIGNAL(clicked()), this, SLOT(sNewReg()));
connect(_partner, SIGNAL(clicked()), this, SLOT(sPartner()));
connect(_prospectButton, SIGNAL(clicked()), this, SLOT(sProspect()));
connect(_save, SIGNAL(clicked()), this, SLOT(sSave()));
connect(_taxauthButton, SIGNAL(clicked()), this, SLOT(sTaxAuth()));
connect(omfgThis, SIGNAL(customersUpdated(int, bool)), this, SLOT(sUpdateRelationships()));
connect(omfgThis, SIGNAL(prospectsUpdated()), this, SLOT(sUpdateRelationships()));
connect(omfgThis, SIGNAL(taxAuthsUpdated(int)),this, SLOT(sUpdateRelationships()));
connect(omfgThis, SIGNAL(vendorsUpdated()), this, SLOT(sUpdateRelationships()));
connect(_customer, SIGNAL(toggled(bool)), this, SLOT(sCustomerToggled()));
connect(_prospect, SIGNAL(toggled(bool)), this, SLOT(sProspectToggled()));
connect(_number, SIGNAL(lostFocus()), this, SLOT(sCheckNumber()));
connect(_primaryButton, SIGNAL(toggled(bool)), this, SLOT(sHandleButtons()));
connect(_secondaryButton, SIGNAL(toggled(bool)), this, SLOT(sHandleButtons()));
connect(_allButton, SIGNAL(toggled(bool)), this, SLOT(sHandleButtons()));
connect(_customerButton, SIGNAL(clicked()), this, SLOT(sCustomer()));
connect(_vendorButton, SIGNAL(clicked()), this, SLOT(sEditVendor()));
connect(_contacts, SIGNAL(cntctDetached(int)), this, SLOT(sHandleCntctDetach(int)));
_charass->addColumn(tr("Characteristic"), _itemColumn, Qt::AlignLeft, true, "char_name");
_charass->addColumn(tr("Value"), -1, Qt::AlignLeft, true, "charass_value");
_reg->addColumn(tr("Lot/Serial") , _itemColumn, Qt::AlignLeft, true, "ls_number" );
_reg->addColumn(tr("Item") , _itemColumn, Qt::AlignLeft, true, "item_number" );
_reg->addColumn(tr("Description") , -1, Qt::AlignLeft, true, "item_descrip1" );
_reg->addColumn(tr("Qty" ) , _qtyColumn, Qt::AlignLeft, true, "lsreg_qty" );
_reg->addColumn(tr("Sold" ), _dateColumn, Qt::AlignLeft, true, "lsreg_solddate" );
_reg->addColumn(tr("Registered" ), _dateColumn, Qt::AlignLeft, true, "lsreg_regdate" );
_reg->addColumn(tr("Expires" ) , _dateColumn, Qt::AlignLeft, true, "lsreg_expiredate" );
if (_preferences->boolean("XCheckBox/forgetful"))
_active->setChecked(true);
_NumberGen = -1;
_mode = cNew;
_crmacctId = -1;
_competitorId = -1;
_custId = -1;
_partnerId = -1;
_prospectId = -1;
_taxauthId = -1;
_vendId = -1;
_comments->setId(-1);
_documents->setId(-1);
_modal = false;
if (!_metrics->boolean("LotSerialControl"))
_tab->removeTab(_tab->indexOf(_registrationsTab));
}
void contact::sPopulateUsesMenu(QMenu* pMenu)
{
int menuItem;
QString editStr = tr("Edit...");
QString viewStr = tr("View...");
QString detachStr = tr("Detach");
switch (_uses->altId())
{
case 1:
case 2:
menuItem = pMenu->insertItem(editStr, this, SLOT(sEditCRMAccount()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainCRMAccounts"));
menuItem = pMenu->insertItem(viewStr, this, SLOT(sViewCRMAccount()));
pMenu->setItemEnabled(menuItem, _privileges->check("ViewCRMAccounts"));
menuItem = pMenu->insertItem(detachStr, this, SLOT(sDetachUse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainCRMAccounts"));
break;
case 3:
case 4:
menuItem = pMenu->insertItem(editStr, this, SLOT(sEditCustomer()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainCustomerMasters"));
menuItem = pMenu->insertItem(viewStr, this, SLOT(sViewCustomer()));
pMenu->setItemEnabled(menuItem, _privileges->check("ViewCustomerMasters"));
menuItem = pMenu->insertItem(detachStr, this, SLOT(sDetachUse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainCustomerMasters"));
break;
case 5:
case 6:
menuItem = pMenu->insertItem(editStr, this, SLOT(sEditVendor()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainVendors"));
menuItem = pMenu->insertItem(viewStr, this, SLOT(sViewVendor()));
pMenu->setItemEnabled(menuItem, _privileges->check("ViewVendors"));
menuItem = pMenu->insertItem(detachStr, this, SLOT(sDetachUse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainVendors"));
break;
case 7:
menuItem = pMenu->insertItem(editStr, this, SLOT(sEditProspect()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainProspects"));
menuItem = pMenu->insertItem(viewStr, this, SLOT(sViewProspect()));
pMenu->setItemEnabled(menuItem, _privileges->check("ViewProspects"));
menuItem = pMenu->insertItem(detachStr, this, SLOT(sDetachUse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainProspects"));
break;
case 8:
menuItem = pMenu->insertItem(editStr, this, SLOT(sEditShipto()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainShiptos"));
menuItem = pMenu->insertItem(viewStr, this, SLOT(sViewShipto()));
pMenu->setItemEnabled(menuItem, _privileges->check("ViewShiptos"));
menuItem = pMenu->insertItem(detachStr, this, SLOT(sDetachUse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainShiptos"));
break;
case 9:
menuItem = pMenu->insertItem(editStr, this, SLOT(sEditVendorAddress()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainVendorAddresses"));
menuItem = pMenu->insertItem(viewStr, this, SLOT(sViewVendorAddress()));
pMenu->setItemEnabled(menuItem, _privileges->check("ViewVendorAddresses"));
menuItem = pMenu->insertItem(detachStr, this, SLOT(sDetachUse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainVendorAddresses"));
break;
case 10:
menuItem = pMenu->insertItem(editStr, this, SLOT(sEditWarehouse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainWarehouses"));
menuItem = pMenu->insertItem(viewStr, this, SLOT(sViewWarehouse()));
pMenu->setItemEnabled(menuItem, _privileges->check("ViewWarehouses"));
menuItem = pMenu->insertItem(detachStr, this, SLOT(sDetachUse()));
pMenu->setItemEnabled(menuItem, _privileges->check("MaintainWarehouses"));
break;
default:
break;
}
}
