void vendor::sNewAddress()
{
ParameterList params;
params.append("mode", "new");
params.append("vend_id", _vendid);
vendorAddress newdlg(this, "", TRUE);
newdlg.set(params);
if (newdlg.exec() != XDialog::Rejected)
sFillAddressList();
}
void vendor::sDeleteAddress()
{
XSqlQuery delq;
delq.prepare( "DELETE FROM vendaddrinfo "
"WHERE (vendaddr_id=:vendaddr_id);" );
delq.bindValue(":vendaddr_id", _vendaddr->id());
delq.exec();
sFillAddressList();
if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Vendor Addresses"),
delq, __FILE__, __LINE__))
return;
}
void vendor::sEditAddress()
{
ParameterList params;
params.append("mode", "edit");
params.append("vendaddr_id", _vendaddr->id());
vendorAddress newdlg(this, "", TRUE);
newdlg.set(params);
if (newdlg.exec() != XDialog::Rejected)
sFillAddressList();
}
void vendor::populate()
{
MetaSQLQuery mql(
"SELECT vendinfo.*, crmacct_id, "
"<? if exists(\"key\") ?>"
" CASE WHEN LENGTH(vend_ach_routingnumber) > 0 THEN"
" formatbytea(decrypt(setbytea(vend_ach_routingnumber),"
" setbytea(<? value(\"key\") ?>), 'bf'))"
" ELSE '' END AS routingnum,"
" CASE WHEN LENGTH(vend_ach_accntnumber) > 0 THEN"
" formatbytea(decrypt(setbytea(vend_ach_accntnumber),"
" setbytea(<? value(\"key\") ?>), 'bf'))"
" ELSE '' END AS accntnum "
"<? else ?>"
" <? value(\"na\") ?> AS routingnum,"
" <? value(\"na\") ?> AS accntnum "
"<? endif ?>"
"FROM vendinfo "
" JOIN crmacct ON (vend_id=crmacct_vend_id) "
"WHERE (vend_id=<? value(\"vend_id\") ?>);" );
ParameterList params;
params.append("vend_id", _vendid);
params.append("key", omfgThis->_key);
params.append("na", tr("N/A"));
q = mql.toQuery(params);
if (q.first())
{
_notice = FALSE;
_cachedNumber = q.value("vend_number").toString();
_number->setText(q.value("vend_number"));
_accountNumber->setText(q.value("vend_accntnum"));
_vendtype->setId(q.value("vend_vendtype_id").toInt());
_active->setChecked(q.value("vend_active").toBool());
_name->setText(q.value("vend_name"));
_contact1->setId(q.value("vend_cntct1_id").toInt());
_contact1->setSearchAcct(q.value("crmacct_id").toInt());
_contact2->setId(q.value("vend_cntct2_id").toInt());
_contact2->setSearchAcct(q.value("crmacct_id").toInt());
_address->setId(q.value("vend_addr_id").toInt());
_defaultTerms->setId(q.value("vend_terms_id").toInt());
_defaultShipVia->setText(q.value("vend_shipvia").toString());
_defaultCurr->setId(q.value("vend_curr_id").toInt());
_poItems->setChecked(q.value("vend_po").toBool());
_restrictToItemSource->setChecked(q.value("vend_restrictpurch").toBool());
_receives1099->setChecked(q.value("vend_1099").toBool());
_match->setChecked(q.value("vend_match").toBool());
_qualified->setChecked(q.value("vend_qualified").toBool());
_notes->setText(q.value("vend_comments").toString());
_poComments->setText(q.value("vend_pocomments").toString());
_taxzone->setId(q.value("vend_taxzone_id").toInt());
if (q.value("vend_fobsource").toString() == "V")
{
_useVendorFOB->setChecked(TRUE);
_vendorFOB->setText(q.value("vend_fob"));
}
else
_useWarehouseFOB->setChecked(TRUE);
_achGroup->setChecked(q.value("vend_ach_enabled").toBool());
_routingNumber->setText(q.value("routingnum").toString());
_achAccountNumber->setText(q.value("accntnum").toString());
_useACHSpecial->setChecked(! q.value("vend_ach_use_vendinfo").toBool());
_individualId->setText(q.value("vend_ach_indiv_number").toString());
_individualName->setText(q.value("vend_ach_indiv_name").toString());
_accountType->setCode(q.value("vend_ach_accnttype").toString());
sFillAddressList();
sFillTaxregList();
_comments->setId(_vendid);
_crmacctid = q.value("crmacct_id").toInt();
_address->setSearchAcct(_crmacctid);
emit newId(_vendid);
}
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
else
{
systemError(this, tr("Could not find the Vendor information. Perhaps the "
"Vendor and CRM Account have been disconnected."),
__FILE__, __LINE__);
return;
}
emit populated();
}
void vendor::populate()
{
q.prepare( "SELECT vend_number, vend_accntnum, vend_active, vend_vendtype_id, vend_name,"
" vend_cntct1_id, vend_cntct2_id, vend_addr_id, "
" vend_po, vend_restrictpurch,"
" vend_1099, vend_qualified,"
" vend_comments, vend_pocomments,"
" vend_fobsource, vend_fob, vend_terms_id, vend_shipvia,"
" vend_curr_id, "
" vend_emailpodelivery, vend_ediemail, vend_ediemailbody,"
" vend_edisubject, vend_edifilename, vend_edicc,"
" vend_taxauth_id, vend_match "
"FROM vendinfo "
"WHERE (vend_id=:vend_id);" );
q.bindValue(":vend_id", _vendid);
q.exec();
if (q.first())
{
_cachedNumber = q.value("vend_number").toString();
_number->setText(q.value("vend_number"));
_accountNumber->setText(q.value("vend_accntnum"));
_vendtype->setId(q.value("vend_vendtype_id").toInt());
_active->setChecked(q.value("vend_active").toBool());
_name->setText(q.value("vend_name"));
_contact1->setId(q.value("vend_cntct1_id").toInt());
_contact2->setId(q.value("vend_cntct2_id").toInt());
_address->setId(q.value("vend_addr_id").toInt());
_defaultTerms->setId(q.value("vend_terms_id").toInt());
_defaultShipVia->setText(q.value("vend_shipvia").toString());
_defaultCurr->setId(q.value("vend_curr_id").toInt());
_poItems->setChecked(q.value("vend_po").toBool());
_restrictToItemSource->setChecked(q.value("vend_restrictpurch").toBool());
_receives1099->setChecked(q.value("vend_1099").toBool());
_match->setChecked(q.value("vend_match").toBool());
_qualified->setChecked(q.value("vend_qualified").toBool());
_notes->setText(q.value("vend_comments").toString());
_poComments->setText(q.value("vend_pocomments").toString());
_emailPODelivery->setChecked(q.value("vend_emailpodelivery").toBool());
_ediEmail->setText(q.value("vend_ediemail"));
_ediSubject->setText(q.value("vend_edisubject"));
_ediFilename->setText(q.value("vend_edifilename"));
_ediEmailBody->setText(q.value("vend_ediemailbody").toString());
_ediCC->setText(q.value("vend_edicc").toString());
_taxauth->setId(q.value("vend_taxauth_id").toInt());
if (q.value("vend_fobsource").toString() == "V")
{
_useVendorFOB->setChecked(TRUE);
_vendorFOB->setText(q.value("vend_fob"));
}
else
_useWarehouseFOB->setChecked(TRUE);
sFillAddressList();
sFillTaxregList();
_comments->setId(_vendid);
}
else if (q.lastError().type() == QSqlError::None)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
q.prepare("SELECT crmacct_id "
"FROM crmacct "
"WHERE (crmacct_vend_id=:vend_id);");
q.bindValue(":vend_id", _vendid);
q.exec();
if (q.first())
_crmacctid = q.value("crmacct_id").toInt();
else if (q.lastError().type() == QSqlError::None)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
}
void vendor::populate()
{
MetaSQLQuery mql(
"SELECT *, crmacct_id, "
"<? if exists(\"key\") ?>"
" CASE WHEN LENGTH(vend_ach_routingnumber) > 0 THEN"
" formatbytea(decrypt(setbytea(vend_ach_routingnumber),"
" setbytea(<? value(\"key\") ?>), 'bf'))"
" ELSE '' END AS routingnum,"
" CASE WHEN LENGTH(vend_ach_accntnumber) > 0 THEN"
" formatbytea(decrypt(setbytea(vend_ach_accntnumber),"
" setbytea(<? value(\"key\") ?>), 'bf'))"
" ELSE '' END AS accntnum "
"<? else ?>"
" <? value(\"na\") ?> AS routingnum,"
" <? value(\"na\") ?> AS accntnum "
"<? endif ?>"
"FROM vendinfo "
" JOIN crmacct ON (vend_id=crmacct_vend_id) "
"WHERE (vend_id=<? value(\"vend_id\") ?>);" );
ParameterList params;
params.append("vend_id", _vendid);
params.append("key", omfgThis->_key);
params.append("na", tr("N/A"));
q = mql.toQuery(params);
if (q.first())
{
_cachedNumber = q.value("vend_number").toString();
_number->setText(q.value("vend_number"));
_accountNumber->setText(q.value("vend_accntnum"));
_vendtype->setId(q.value("vend_vendtype_id").toInt());
_active->setChecked(q.value("vend_active").toBool());
_name->setText(q.value("vend_name"));
_contact1->setId(q.value("vend_cntct1_id").toInt());
_contact1->setSearchAcct(q.value("crmacct_id").toInt());
_contact2->setId(q.value("vend_cntct2_id").toInt());
_contact2->setSearchAcct(q.value("crmacct_id").toInt());
_address->setId(q.value("vend_addr_id").toInt());
_defaultTerms->setId(q.value("vend_terms_id").toInt());
_defaultShipVia->setText(q.value("vend_shipvia").toString());
_defaultCurr->setId(q.value("vend_curr_id").toInt());
_poItems->setChecked(q.value("vend_po").toBool());
_restrictToItemSource->setChecked(q.value("vend_restrictpurch").toBool());
_receives1099->setChecked(q.value("vend_1099").toBool());
_match->setChecked(q.value("vend_match").toBool());
_qualified->setChecked(q.value("vend_qualified").toBool());
_notes->setText(q.value("vend_comments").toString());
_poComments->setText(q.value("vend_pocomments").toString());
_emailPODelivery->setChecked(q.value("vend_emailpodelivery").toBool());
_ediEmail->setText(q.value("vend_ediemail"));
_ediSubject->setText(q.value("vend_edisubject"));
_ediFilename->setText(q.value("vend_edifilename"));
_ediEmailBody->setText(q.value("vend_ediemailbody").toString());
_ediCC->setText(q.value("vend_edicc").toString());
_taxauth->setId(q.value("vend_taxauth_id").toInt());
if (q.value("vend_fobsource").toString() == "V")
{
_useVendorFOB->setChecked(TRUE);
_vendorFOB->setText(q.value("vend_fob"));
}
else
_useWarehouseFOB->setChecked(TRUE);
_achGroup->setChecked(q.value("vend_ach_enabled").toBool());
_routingNumber->setText(q.value("routingnum").toString());
_achAccountNumber->setText(q.value("accntnum").toString());
_useACHSpecial->setChecked(! q.value("vend_ach_use_vendinfo").toBool());
_individualId->setText(q.value("vend_ach_indiv_number").toString());
_individualName->setText(q.value("vend_ach_indiv_name").toString());
if (q.value("vend_ach_accnttype").toString() == "K")
_accountType->setCurrentItem(0);
else if (q.value("vend_ach_accnttype").toString() == "C")
_accountType->setCurrentItem(1);
sFillAddressList();
sFillTaxregList();
_comments->setId(_vendid);
}
else if (q.lastError().type() == QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
q.prepare("SELECT crmacct_id "
"FROM crmacct "
"WHERE (crmacct_vend_id=:vend_id);");
q.bindValue(":vend_id", _vendid);
q.exec();
if (q.first())
_crmacctid = q.value("crmacct_id").toInt();
else if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
}
bool vendor::sPopulate()
{
if (DEBUG)
qDebug("vendor::sPopulate() entered with _vendid %d and _crmacctid %d",
_vendid, _crmacctid);
MetaSQLQuery mql(
"<? if exists('vend_id') ?>"
"SELECT vendinfo.*, crmacct_id, crmacct_owner_username, "
"<? if exists('key') ?>"
" CASE WHEN LENGTH(vend_ach_routingnumber) > 0 THEN"
" formatbytea(decrypt(setbytea(vend_ach_routingnumber),"
" setbytea(<? value('key') ?>), 'bf'))"
" ELSE '' END AS routingnum,"
" CASE WHEN LENGTH(vend_ach_accntnumber) > 0 THEN"
" formatbytea(decrypt(setbytea(vend_ach_accntnumber),"
" setbytea(<? value('key') ?>), 'bf'))"
" ELSE '' END AS accntnum "
"<? else ?>"
" <? value('na') ?> AS routingnum,"
" <? value('na') ?> AS accntnum "
"<? endif ?>"
"FROM vendinfo "
" JOIN crmacct ON (vend_id=crmacct_vend_id) "
"WHERE (vend_id=<? value('vend_id') ?>);"
"<? elseif exists('crmacct_id') ?>"
"SELECT crmacct_number AS vend_number, crmacct_name AS vend_name,"
" crmacct_active AS vend_active,"
" crmacct_cntct_id_1 AS vend_cntct1_id,"
" crmacct_cntct_id_2 AS vend_cntct2_id,"
" fetchMetricText('DefaultPOShipVia') AS vend_shipvia,"
" NULL AS vend_accntnum, NULL AS vend_vendtype_id,"
" NULL AS vend_name, NULL AS vend_addr_id,"
" fetchMetricValue('DefaultTerms') AS vend_terms_id,"
" NULL AS vend_curr_id,"
" FALSE AS vend_po, FALSE AS vend_restrictpurch,"
" FALSE AS vend_1099, NULL AS vend_match,"
" FALSE AS vend_qualified, NULL AS vend_comments,"
" NULL AS vend_pocomments, NULL AS vend_taxzone_id,"
" 'W' AS vend_fobsource, NULL AS vend_fob,"
" NULL AS vend_ach_enabled, NULL AS routingnum,"
" NULL AS accntnum, NULL AS vend_ach_use_vendinfo,"
" NULL AS vend_ach_indiv_number, NULL AS vend_ach_indiv_name,"
" NULL AS vend_ach_accnttype,"
" crmacct_id, crmacct_owner_username"
" FROM crmacct"
" WHERE crmacct_id=<? value('crmacct_id') ?>;"
"<? endif ?>");
ParameterList params;
if (_vendid > 0)
params.append("vend_id", _vendid);
else if (_crmacctid > 0)
params.append("crmacct_id", _crmacctid);
params.append("key", omfgThis->_key);
params.append("na", tr("N/A"));
XSqlQuery getq = mql.toQuery(params);
if (getq.first())
{
_notice = FALSE;
_cachedNumber = getq.value("vend_number").toString();
_crmacctid = getq.value("crmacct_id").toInt();
_crmowner = getq.value("crmacct_owner_username").toString();
_number->setText(getq.value("vend_number"));
_accountNumber->setText(getq.value("vend_accntnum"));
_vendtype->setId(getq.value("vend_vendtype_id").toInt());
_active->setChecked(getq.value("vend_active").toBool());
_name->setText(getq.value("vend_name"));
_contact1->setId(getq.value("vend_cntct1_id").toInt());
_contact1->setSearchAcct(_crmacctid);
_contact2->setId(getq.value("vend_cntct2_id").toInt());
_contact2->setSearchAcct(_crmacctid);
_address->setId(getq.value("vend_addr_id").toInt());
_defaultTerms->setId(getq.value("vend_terms_id").toInt());
_defaultShipVia->setText(getq.value("vend_shipvia").toString());
_defaultCurr->setId(getq.value("vend_curr_id").toInt());
_poItems->setChecked(getq.value("vend_po").toBool());
_restrictToItemSource->setChecked(getq.value("vend_restrictpurch").toBool());
_receives1099->setChecked(getq.value("vend_1099").toBool());
_match->setChecked(getq.value("vend_match").toBool());
_qualified->setChecked(getq.value("vend_qualified").toBool());
_notes->setText(getq.value("vend_comments").toString());
_poComments->setText(getq.value("vend_pocomments").toString());
_taxzone->setId(getq.value("vend_taxzone_id").toInt());
if (getq.value("vend_fobsource").toString() == "V")
{
_useVendorFOB->setChecked(TRUE);
_vendorFOB->setText(getq.value("vend_fob"));
}
else
_useWarehouseFOB->setChecked(TRUE);
_achGroup->setChecked(getq.value("vend_ach_enabled").toBool());
_routingNumber->setText(getq.value("routingnum").toString());
_achAccountNumber->setText(getq.value("accntnum").toString());
_useACHSpecial->setChecked(! getq.value("vend_ach_use_vendinfo").toBool());
_individualId->setText(getq.value("vend_ach_indiv_number").toString());
_individualName->setText(getq.value("vend_ach_indiv_name").toString());
_accountType->setCode(getq.value("vend_ach_accnttype").toString());
_account->setId(getq.value("vend_accnt_id").toInt());
if(getq.value("vend_expcat_id").toInt() != -1)
{
_expcatSelected->setChecked(TRUE);
_expcat->setId(getq.value("vend_expcat_id").toInt());
}
if(getq.value("vend_tax_id").toInt() != -1)
{
_taxSelected->setChecked(TRUE);
_taxCode->setId(getq.value("vend_tax_id").toInt());
}
sFillAddressList();
sFillTaxregList();
sFillCharacteristic();
_comments->setId(_crmacctid);
_address->setSearchAcct(_crmacctid);
emit newId(_vendid);
}
else if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Vendor"),
getq, __FILE__, __LINE__))
return false;
else
{
ErrorReporter::error(QtCriticalMsg, this, tr("Getting Vendor"),
tr("Could not find the Vendor information. Perhaps "
"the Vendor and CRM Account have been disconnected."),
__FILE__, __LINE__);
return false;
}
_crmacct->setEnabled(_crmacctid > 0 &&
(_privileges->check("MaintainAllCRMAccounts") ||
_privileges->check("ViewAllCRMAccounts") ||
(omfgThis->username() == _crmowner && _privileges->check("MaintainPersonalCRMAccounts")) ||
(omfgThis->username() == _crmowner && _privileges->check("ViewPersonalCRMAccounts"))));
emit populated();
return true;
}
