void user::populateSite()
{
ParameterList params;
QString sql;
MetaSQLQuery mql;
if (_mode == cNew)
{
sql = "SELECT warehous_id, warehous_code "
" FROM whsinfo ";
mql.setQuery(sql);
q = mql.toQuery(params);
_availableSite->populate(q);
if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
}
else
{
params.append("username", _username->text().trimmed().lower());
sql = "SELECT warehous_id, warehous_code "
" FROM whsinfo "
" WHERE warehous_id NOT IN ( "
" SELECT warehous_id "
" FROM whsinfo, usrsite "
" WHERE ( (usrsite_warehous_id=warehous_id) "
" AND (usrsite_username=<? value(\"username\") ?>))) ";
mql.setQuery(sql);
q = mql.toQuery(params);
_availableSite->populate(q);
if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
sql = "SELECT warehous_id,warehous_code,0 AS warehous_level "
"FROM whsinfo, usrsite "
"WHERE ( (usrsite_warehous_id=warehous_id) "
" AND (usrsite_username=<? value(\"username\") ?>)) ";
mql.setQuery(sql);
q = mql.toQuery(params);
_grantedSite->populate(q);
if (q.lastError().type() != QSqlError::NoError)
{
systemError(this, q.lastError().databaseText(), __FILE__, __LINE__);
return;
}
}
}
void user::populateSite()
{
XSqlQuery siteq;
if (_mode == cNew)
{
siteq.prepare("SELECT warehous_id, warehous_code"
" FROM whsinfo"
" ORDER BY warehous_code;");
_availableSite->populate(siteq);
if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Sites"),
siteq, __FILE__, __LINE__))
return;
}
else
{
QString sql;
MetaSQLQuery mql;
ParameterList params;
if(omfgThis->useCloud())
params.append("username", _username->text().trimmed().toLower() + "_" + omfgThis->company());
else
params.append("username", _username->text().trimmed().toLower());
sql = "SELECT warehous_id, warehous_code "
" FROM whsinfo "
" WHERE warehous_id NOT IN ( "
" SELECT warehous_id "
" FROM whsinfo, usrsite "
" WHERE ( (usrsite_warehous_id=warehous_id) "
" AND (usrsite_username=<? value('username') ?>))) ";
mql.setQuery(sql);
siteq = mql.toQuery(params);
_availableSite->populate(siteq);
if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Ungranted Sites"),
siteq, __FILE__, __LINE__))
return;
sql = "SELECT warehous_id,warehous_code,0 AS warehous_level "
"FROM whsinfo, usrsite "
"WHERE ( (usrsite_warehous_id=warehous_id) "
" AND (usrsite_username=<? value('username') ?>)) ";
mql.setQuery(sql);
siteq = mql.toQuery(params);
_grantedSite->populate(siteq);
if (ErrorReporter::error(QtCriticalMsg, this, tr("Getting Granted Sites"),
siteq, __FILE__, __LINE__))
return;
}
}
