void prospect::populate()
{
XSqlQuery prospect;
prospect.prepare("SELECT prospect.*, crmacct_id "
"FROM prospect, crmacct "
"WHERE ((prospect_id=:prospect_id)"
" AND (prospect_id=crmacct_prospect_id));" );
prospect.bindValue(":prospect_id", _prospectid);
prospect.exec();
if (prospect.first())
{
_crmacct->setId(prospect.value("crmacct_id").toInt());
_number->setText(prospect.value("prospect_number"));
_cachedNumber = prospect.value("prospect_number").toString();
_name->setText(prospect.value("prospect_name").toString());
_contact->setId(prospect.value("prospect_cntct_id").toInt());
_taxauth->setId(prospect.value("prospect_taxauth_id").toInt());
_salesrep->setId(prospect.value("prospect_salesrep_id").toInt());
_site->setId(prospect.value("prospect_warehous_id").toInt());
_notes->setText(prospect.value("prospect_comments").toString());
_active->setChecked(prospect.value("prospect_active").toBool());
}
else if (prospect.lastError().type() != QSqlError::None)
{
systemError(this, prospect.lastError().databaseText(), __FILE__, __LINE__);
return;
}
sFillQuotesList();
}
bool prospect::sPopulate()
{
XSqlQuery getq;
if (_prospectid >= 0)
{
getq.prepare("SELECT prospect.*, crmacct_id, crmacct_owner_username"
" FROM prospect, crmacct"
" WHERE ((prospect_id=:prospect_id)"
" AND (prospect_id=crmacct_prospect_id));" );
getq.bindValue(":prospect_id", _prospectid);
}
else if (_crmacctid >= 0)
{
getq.prepare("SELECT crmacct_active AS prospect_active,"
" crmacct_name AS prospect_name,"
" crmacct_number AS prospect_number,"
" crmacct_cntct_id_1 AS prospect_cntct_id,"
" crmacct_owner_username AS prospect_owner_username,"
" NULL AS prospect_comments, -1 AS prospect_taxzone_id,"
" -1 AS prospect_salesrep_id, -1 AS prospect_warehous_id,"
" crmacct_id, crmacct_owner_username"
" FROM crmacct"
" WHERE (crmacct_id=:id);");
getq.bindValue(":id", _crmacctid);
}
getq.exec();
if (getq.first())
{
_crmacctid = getq.value("crmacct_id").toInt();
_number->setText(getq.value("prospect_number").toString());
_cachedNumber = getq.value("prospect_number").toString();
_name->setText(getq.value("prospect_name").toString());
_contact->setId(getq.value("prospect_cntct_id").toInt());
_taxzone->setId(getq.value("prospect_taxzone_id").toInt());
_salesrep->setId(getq.value("prospect_salesrep_id").toInt());
_site->setId(getq.value("prospect_warehous_id").toInt());
_notes->setText(getq.value("prospect_comments").toString());
_active->setChecked(getq.value("prospect_active").toBool());
_crmowner = getq.value("crmacct_owner_username").toString();
}
else if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Prospect"),
getq, __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"))));
sFillQuotesList();
emit populated();
return true;
}