void vendor::sNewTaxreg()
{
ParameterList params;
params.append("mode", "new");
params.append("taxreg_rel_id", _vendid);
params.append("taxreg_rel_type", "V");
taxRegistration newdlg(this, "", TRUE);
if (newdlg.set(params) == NoError && newdlg.exec() != XDialog::Rejected)
sFillTaxregList();
}
void vendor::sEditTaxreg()
{
ParameterList params;
params.append("mode", "edit");
params.append("taxreg_id", _taxreg->id());
taxRegistration newdlg(this, "", TRUE);
newdlg.set(params);
if (newdlg.set(params) == NoError && newdlg.exec() != XDialog::Rejected)
sFillTaxregList();
}
void vendor::sDeleteTaxreg()
{
XSqlQuery delq;
delq.prepare("DELETE FROM taxreg WHERE (taxreg_id=:taxreg_id);");
delq.bindValue(":taxreg_id", _taxreg->id());
delq.exec();
if (ErrorReporter::error(QtCriticalMsg, this, tr("Deleting Tax Registration"),
delq, __FILE__, __LINE__))
return;
sFillTaxregList();
}
void vendor::sDeleteTaxreg()
{
q.prepare("DELETE FROM taxreg "
"WHERE (taxreg_id=:taxreg_id);");
q.bindValue(":taxreg_id", _taxreg->id());
q.exec();
if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
sFillTaxregList();
}
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 customer::populate()
{
XSqlQuery cust;
_notice = FALSE;
cust.prepare( "SELECT custinfo.*, "
" formatScrap(cust_commprcnt) AS commprcnt,"
" formatScrap(cust_discntprcnt) AS discountpercent,"
" crmacct_id "
"FROM custinfo, crmacct "
"WHERE ((cust_id=:cust_id) "
" AND (cust_id=crmacct_cust_id));" );
cust.bindValue(":cust_id", _custid);
cust.exec();
if (cust.first())
{
_crmacctid = cust.value("crmacct_id").toInt();
_number->setText(cust.value("cust_number"));
_cachedNumber = cust.value("cust_number").toString();
_name->setText(cust.value("cust_name"));
_corrCntct->setId(cust.value("cust_corrcntct_id").toInt());
_billCntct->setId(cust.value("cust_cntct_id").toInt());
_creditLimit->set(cust.value("cust_creditlmt").toDouble(),
cust.value("cust_creditlmt_curr_id").toInt(),
QDate::currentDate());
_creditRating->setText(cust.value("cust_creditrating"));
_autoUpdateStatus->setChecked(cust.value("cust_autoupdatestatus").toBool());
_autoHoldOrders->setChecked(cust.value("cust_autoholdorders").toBool());
_defaultDiscountPrcnt->setText(cust.value("discountpercent"));
_notes->setText(cust.value("cust_comments").toString());
_custtype->setId(cust.value("cust_custtype_id").toInt());
_salesrep->setId(cust.value("cust_salesrep_id").toInt());
_defaultCommissionPrcnt->setText(cust.value("commprcnt"));
_terms->setId(cust.value("cust_terms_id").toInt());
_taxauth->setId(cust.value("cust_taxauth_id").toInt());
_shipform->setId(cust.value("cust_shipform_id").toInt());
_shipchrg->setId(cust.value("cust_shipchrg_id").toInt());
_shipvia->setText(cust.value("cust_shipvia").toString());
_sellingWarehouse->setId(cust.value("cust_preferred_warehous_id").toInt());
if (cust.value("cust_balmethod").toString() == "B")
_balanceMethod->setCurrentItem(0);
else if (cust.value("cust_balmethod").toString() == "O")
_balanceMethod->setCurrentItem(1);
_active->setChecked(cust.value("cust_active").toBool());
_backorders->setChecked(cust.value("cust_backorder").toBool());
_partialShipments->setChecked(cust.value("cust_partialship").toBool());
_partialShipments->setEnabled(cust.value("cust_backorder").toBool());
_allowFFShipto->setChecked(cust.value("cust_ffshipto").toBool());
_allowFFBillto->setChecked(cust.value("cust_ffbillto").toBool());
_usesPOs->setChecked(cust.value("cust_usespos").toBool());
_blanketPos->setChecked(cust.value("cust_blanketpos").toBool());
_currency->setId(cust.value("cust_curr_id").toInt());
if (cust.value("cust_creditstatus").toString() == "G")
_inGoodStanding->setChecked(TRUE);
else if (cust.value("cust_creditstatus").toString() == "W")
_onCreditWarning->setChecked(TRUE);
else
_onCreditHold->setChecked(TRUE);
if(cust.value("cust_emaildelivery").toBool())
_ediProfile->setId(0);
else
{
_ediProfile->setId(cust.value("cust_ediprofile_id").toInt());
if(0 == _ediProfile->id())
_ediProfile->setId(-1);
}
sProfileSelected();
_ediEmail->setText(cust.value("cust_ediemail"));
_ediSubject->setText(cust.value("cust_edisubject"));
_ediFilename->setText(cust.value("cust_edifilename"));
_ediEmailBody->setText(cust.value("cust_ediemailbody").toString());
_ediCC->setText(cust.value("cust_edicc").toString());
if(cust.value("cust_soemaildelivery").toBool())
_soEdiProfile->setId(0);
else
{
_soEdiProfile->setId(cust.value("cust_soediprofile_id").toInt());
if(0 == _soEdiProfile->id())
_soEdiProfile->setId(-1);
}
sSoProfileSelected();
_soEdiEmail->setText(cust.value("cust_soediemail"));
_soEdiSubject->setText(cust.value("cust_soedisubject"));
_soEdiFilename->setText(cust.value("cust_soedifilename"));
_soEdiEmailBody->setText(cust.value("cust_soediemailbody").toString());
_soEdiCC->setText(cust.value("cust_soedicc").toString());
_comments->setId(_custid);
sFillShiptoList();
sFillTaxregList();
sFillCharacteristicList();
sFillCcardList();
}
else if (cust.lastError().type() != QSqlError::None)
{
systemError(this, cust.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;
}
