int main(int argc, char *argv[])
{
XSqlQuery main;
Q_INIT_RESOURCE(guiclient);
QString username;
QString databaseURL;
QString passwd;
bool haveUsername = FALSE;
bool haveDatabaseURL = FALSE;
bool loggedIn = FALSE;
bool haveEnhancedAuth= false;
bool _enhancedAuth = false;
bool havePasswd = false;
bool forceWelcomeStub= false;
qInstallMsgHandler(xTupleMessageOutput);
QApplication app(argc, argv);
app.setOrganizationDomain("xTuple.com");
app.setOrganizationName("xTuple");
app.setApplicationName("xTuple");
app.setApplicationVersion(_Version);
#if QT_VERSION >= 0x040400
// This is the correct place for this call but on versions less
// than 4.4 it causes a crash for an unknown reason so it is
// called later on earlier versions.
QCoreApplication::addLibraryPath(QString("."));
#endif
#ifndef Q_WS_MACX
QApplication::setWindowIcon(QIcon(":/images/icon32x32.png"));
#endif
app.processEvents();
if (argc > 1)
{
for (int intCounter = 1; intCounter < argc; intCounter++)
{
QString argument(argv[intCounter]);
if (argument.contains("-databaseURL=", Qt::CaseInsensitive))
{
haveDatabaseURL = TRUE;
databaseURL = argument.right(argument.length() - 13);
}
else if (argument.contains("-username="******"-passwd=", Qt::CaseInsensitive))
{
havePasswd = TRUE;
passwd = argument.right(argument.length() - 8);
}
else if (argument.contains("-noAuth", Qt::CaseInsensitive))
{
haveUsername = TRUE;
havePasswd = TRUE;
}
else if (argument.contains("-enhancedAuth", Qt::CaseInsensitive))
{
haveEnhancedAuth = true;
_enhancedAuth = true;
if(argument.contains("=no", Qt::CaseInsensitive) || argument.contains("=false", Qt::CaseInsensitive))
_enhancedAuth = false;
}
else if (argument.contains("-forceWelcomeStub", Qt::CaseInsensitive))
forceWelcomeStub = true;
}
}
// Try and load a default translation file and install it
// otherwise if we are non-english inform the user that translation are available
bool checkLanguage = false;
QLocale sysl = QLocale::system();
QTranslator defaultTranslator(&app);
if (defaultTranslator.load(translationFile(sysl.name().toLower(), "default")))
app.installTranslator(&defaultTranslator);
else if(!xtsettingsValue("LanguageCheckIgnore", false).toBool() && sysl.language() != QLocale::C && sysl.language() != QLocale::English)
checkLanguage = translationFile(sysl.name().toLower(), "xTuple").isNull();
if (forceWelcomeStub || checkLanguage)
{
QTranslator * translator = new QTranslator(&app);
if (translator->load(translationFile(sysl.name().toLower(), "welcome/wmsg")))
app.installTranslator(translator);
welcomeStub wsdlg;
wsdlg.checkBox->setChecked(xtsettingsValue("LanguageCheckIgnore", false).toBool());
wsdlg.exec();
xtsettingsSetValue("LanguageCheckIgnore", wsdlg.checkBox->isChecked());
}
_splash = new QSplashScreen();
_splash->setPixmap(QPixmap(":/images/splashEmpty.png"));
_evaluation = FALSE;
if (!loggedIn)
{
ParameterList params;
params.append("copyright", _Copyright);
params.append("version", _Version);
params.append("build", _Build.arg(__DATE__).arg(__TIME__));
params.append("setSearchPath", true);
if (haveUsername)
params.append("username", username);
if (havePasswd)
params.append("password", passwd);
if (haveDatabaseURL)
params.append("databaseURL", databaseURL);
if (haveEnhancedAuth)
params.append("enhancedAuth", _enhancedAuth);
if (_evaluation)
params.append("evaluation");
if ( (haveDatabaseURL) && (haveUsername) && (havePasswd) )
params.append("login");
login2 newdlg(0, "", TRUE);
newdlg.set(params, _splash);
if(newdlg.result() != QDialog::Accepted)
{
if (newdlg.exec() == QDialog::Rejected)
return -1;
else
{
databaseURL = newdlg._databaseURL;
username = newdlg.username();
__password = newdlg.password();
}
}
}
// TODO: can/should we compose the splash screen on the fly from parts?
QList<editionDesc> edition;
edition << editionDesc( "Enterprise", ":/images/splashEnterprise.png", true,
"SELECT fetchMetricText('Application') = 'Standard' AND COUNT(*) = 4"
" FROM pkghead"
" WHERE pkghead_name IN ('xtmfg', 'xtprjaccnt', 'asset', 'assetdepn');" )
<< editionDesc( "Manufacturing", ":/images/splashMfgEdition.png", true,
"SELECT fetchMetricText('Application') = 'Standard' AND COUNT(*) = 1"
" FROM pkghead"
" WHERE pkghead_name IN ('xtmfg');" )
<< editionDesc( "Distribution", ":/images/splashDistEdition.png", true,
"SELECT fetchMetricText('Application') = 'Standard';" )
<< editionDesc( "PostBooks", ":/images/splashPostBooks.png", true,
"SELECT fetchMetricText('Application') = 'PostBooks';" )
;
XSqlQuery metric;
int editionIdx; // we'll use this after the loop
for (editionIdx = 0; editionIdx < edition.size(); editionIdx++)
{
metric.exec(edition[editionIdx].queryString);
if (metric.first() && metric.value(0).toBool())
break;
}
if (editionIdx >= edition.size())
editionIdx = edition.size(); // default to PostBooks
_splash->setPixmap(QPixmap(edition[editionIdx].splashResource));
_Name = _Name.arg(edition[editionIdx].editionName);
if (edition[editionIdx].shouldCheckLicense)
{
_splash->showMessage(QObject::tr("Checking License Key"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
// PostgreSQL changed the column "procpid" to just "pid" in 9.2.0+ Incident #21852
XSqlQuery checkVersion(QString("select compareversion('9.2.0');"));
if(checkVersion.first())
{
if(checkVersion.value("compareversion").toInt() > 0)
{
metric.exec("SELECT count(*) AS registered, (SELECT count(*) FROM pg_stat_activity WHERE datname=current_database()) AS total"
" FROM pg_stat_activity, pg_locks"
" WHERE((database=datid)"
" AND (classid=datid)"
" AND (objsubid=2)"
" AND (procpid = pg_backend_pid()));");
}
else
{
metric.exec("SELECT count(*) AS registered, (SELECT count(*) FROM pg_stat_activity WHERE datname=current_database()) AS total"
" FROM pg_stat_activity, pg_locks"
" WHERE((database=datid)"
" AND (classid=datid)"
" AND (objsubid=2)"
" AND (pg_stat_activity.pid = pg_backend_pid()));");
}
}
int cnt = 50000;
int tot = 50000;
if(metric.first())
{
cnt = metric.value("registered").toInt();
tot = metric.value("total").toInt();
}
metric.exec("SELECT packageIsEnabled('drupaluserinfo') AS result;");
bool xtweb = false;
if(metric.first())
xtweb = metric.value("result").toBool();
metric.exec("SELECT fetchMetricBool('ForceLicenseLimit') as metric_value;");
bool forceLimit = false;
bool forced = false;
if(metric.first())
forceLimit = metric.value("metric_value").toBool();
metric.exec("SELECT metric_value"
" FROM metric"
" WHERE(metric_name = 'RegistrationKey');");
bool checkPass = true;
bool checkLock = false;
bool expired = false;
QString checkPassReason;
QString rkey = "";
if(metric.first())
rkey = metric.value("metric_value").toString();
XTupleProductKey pkey(rkey);
QString application;
metric.exec("SELECT fetchMetricText('Application') as app;");
if(metric.first())
{
application = metric.value("app").toString();
}
if(pkey.valid() && (pkey.version() == 1 || pkey.version() == 2 || pkey.version() == 3))
{
if(pkey.expiration() < QDate::currentDate())
{
checkPass = false;
checkPassReason = QObject::tr("<p>Your license has expired.");
if(!pkey.perpetual())
{
int daysTo = pkey.expiration().daysTo(QDate::currentDate());
if(daysTo > 30)
{
checkLock = true;
expired = true;
checkPassReason = QObject::tr("<p>Your xTuple license expired over 30 days ago, and this software will no longer function. Please contact xTuple immediately to reinstate your software.");
}
else
checkPassReason = QObject::tr("<p>Attention: Your xTuple license has expired, and in %1 days this software will cease to function. Please make arrangements for immediate payment").arg(30 - daysTo);
}
else
expired = true;
}
else if(application == "PostBooks" && pkey.users() == 1)
{
if(pkey.users() < cnt)
{
checkPass = false;
checkPassReason = QObject::tr("<p>Multiple concurrent users of xTuple PostBooks require a license key. Please contact [email protected] to request a free license key for your local installation, or [email protected] to purchase additional users in the xTuple Cloud Service. <p>Thank you.");
checkLock = forced = forceLimit;
}
}
else if(pkey.users() != 0 && (pkey.users() < cnt || (!xtweb && (pkey.users() * 2 < tot))))
{
checkPass = false;
checkPassReason = QObject::tr("<p>You have exceeded the number of allowed concurrent users for your license.");
checkLock = forced = forceLimit;
}
else
{
int daysTo = QDate::currentDate().daysTo(pkey.expiration());
if(!pkey.perpetual() && daysTo <= 15)
{
checkPass = false;
checkPassReason = QObject::tr("<p>Please note: your xTuple license will expire in %1 days. You should already have received your renewal invoice; please contact xTuple at your earliest convenience.").arg(daysTo);
}
}
}
else
{
checkPass = false;
checkPassReason = QObject::tr("<p>The Registration key installed for this system does not appear to be valid.");
}
if(!checkPass)
{
_splash->hide();
if (expired)
{
registrationKeyDialog newdlg(0, "", TRUE);
if(newdlg.exec() == -1)
{
QMessageBox::critical(0, QObject::tr("Registration Key"), checkPassReason);
return 0;
}
}
else if(checkLock)
{
QMessageBox::critical(0, QObject::tr("Registration Key"), checkPassReason);
if(!forced)
return 0;
}
else
{
if(QMessageBox::critical(0, QObject::tr("Registration Key"), QObject::tr("%1\n<p>Would you like to continue anyway?").arg(checkPassReason), QMessageBox::Yes | QMessageBox::No, QMessageBox::No) == QMessageBox::No)
return 0;
}
if(forced)
checkPassReason.append(" FORCED!");
metric.exec("SELECT current_database() AS db,"
" fetchMetricText('DatabaseName') AS dbname,"
" fetchMetricText('remitto_name') AS name;");
QString db = "";
QString dbname = "";
QString name = "";
if(metric.first())
{
db = metric.value("db").toString();
dbname = metric.value("dbname").toString();
name = metric.value("name").toString();
}
QHttp *http = new QHttp();
QUrl url;
url.setPath("/api/regviolation.php");
url.addQueryItem("key", QUrl::toPercentEncoding(rkey));
url.addQueryItem("error", QUrl::toPercentEncoding(checkPassReason));
url.addQueryItem("name", QUrl::toPercentEncoding(name));
url.addQueryItem("dbname", QUrl::toPercentEncoding(dbname));
url.addQueryItem("db", QUrl::toPercentEncoding(db));
url.addQueryItem("cnt", QString::number(cnt));
url.addQueryItem("tot", QString::number(tot));
url.addQueryItem("ver", _Version);
http->setHost("www.xtuple.org");
http->get(url.toString());
if(forced)
return 0;
_splash->show();
}
}
bool disallowMismatch = false;
bool shouldCheckForUpdates = false;
metric.exec("SELECT metric_value"
" FROM metric"
" WHERE (metric_name = 'ServerVersion')");
if (!metric.first() || (metric.value("metric_value").toString() != _dbVersion)) {
int result = 0;
metric.exec("SELECT metric_value FROM metric WHERE (metric_name = 'DisallowMismatchClientVersion')");
if (metric.first() && (metric.value("metric_value").toString() == "t")) {
disallowMismatch = true;
}
metric.exec("SELECT metric_value FROM metric WHERE (metric_name = 'CheckForUpdates')");
if (metric.first()) {
shouldCheckForUpdates = (metric.value("metric_value").toString() == "t" ? true : false);
}
if (shouldCheckForUpdates) {
_splash->hide();
checkForUpdates newdlg(0,"", TRUE);
result = newdlg.exec();
if (result == QDialog::Rejected) {
return 0;
}
}
else if (!shouldCheckForUpdates && disallowMismatch) {
_splash->hide();
result = QMessageBox::warning( 0, QObject::tr("Version Mismatch"),
QObject::tr("<p>The version of the database you are connecting to is "
"not the version this client was designed to work against. "
"This client was designed to work against the database "
"version %1. The system has been configured to disallow "
"access in this case.<p>Please contact your systems "
"administrator.").arg(_Version),
QMessageBox::Ok | QMessageBox::Escape | QMessageBox::Default );
return 0;
}
else {
_splash->hide();
result = QMessageBox::warning( 0, QObject::tr("Version Mismatch"),
QObject::tr("<p>The version of the database you are connecting to is "
"not the version this client was designed to work against. "
"This client was designed to work against the database "
"version %1. If you continue some or all functionality may "
"not work properly or at all. You may also cause other "
"problems on the database.<p>Do you want to continue "
"anyway?").arg(_Version), QMessageBox::Yes,
QMessageBox::No | QMessageBox::Escape | QMessageBox::Default );
if (result != QMessageBox::Yes) {
return 0;
}
else {
_splash->show();
}
}
}
_splash->showMessage(QObject::tr("Loading Database Metrics"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_metrics = new Metrics();
_splash->showMessage(QObject::tr("Loading User Preferences"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_preferences = new Preferences(username);
_splash->showMessage(QObject::tr("Loading User Privileges"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_privileges = new Privileges();
// Load the translator and set the locale from the User's preferences
_splash->showMessage(QObject::tr("Loading Translation Dictionary"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
XSqlQuery langq("SELECT * "
"FROM usr, locale LEFT OUTER JOIN"
" lang ON (locale_lang_id=lang_id) LEFT OUTER JOIN"
" country ON (locale_country_id=country_id) "
"WHERE ( (usr_username=getEffectiveXtUser())"
" AND (usr_locale_id=locale_id) );" );
if (langq.first())
{
QStringList files;
if (!langq.value("locale_lang_file").toString().isEmpty())
files << langq.value("locale_lang_file").toString();
QString langext;
if (!langq.value("lang_abbr2").toString().isEmpty() &&
!langq.value("country_abbr").toString().isEmpty())
{
langext = langq.value("lang_abbr2").toString() + "_" +
langq.value("country_abbr").toString().toLower();
}
else if (!langq.value("lang_abbr2").toString().isEmpty())
{
langext = langq.value("lang_abbr2").toString();
}
if(!langext.isEmpty())
{
files << "qt";
files << "xTuple";
files << "openrpt";
files << "reports";
XSqlQuery pkglist("SELECT pkghead_name"
" FROM pkghead"
" WHERE packageIsEnabled(pkghead_name);");
while(pkglist.next())
files << pkglist.value("pkghead_name").toString();
}
if (files.size() > 0)
{
QStringList notfound;
QTranslator *translator = new QTranslator(&app);
for (QStringList::Iterator fit = files.begin(); fit != files.end(); ++fit)
{
if (DEBUG)
qDebug("looking for %s", (*fit).toAscii().data());
if (translator->load(translationFile(langext, *fit)))
{
app.installTranslator(translator);
qDebug("installed %s", (*fit).toAscii().data());
translator = new QTranslator(&app);
}
else
{
notfound << *fit;
}
}
if (! notfound.isEmpty() &&
!_preferences->boolean("IngoreMissingTranslationFiles"))
QMessageBox::warning( 0, QObject::tr("Cannot Load Dictionary"),
QObject::tr("<p>The Translation Dictionaries %1 "
"cannot be loaded. Reverting "
"to the default dictionary." )
.arg(notfound.join(QObject::tr(", "))));
}
/* set the locale to langabbr_countryabbr, langabbr, {lang# country#}, or
lang#, depending on what information is available
*/
QString langAbbr = langq.value("lang_abbr2").toString();
QString cntryAbbr = langq.value("country_abbr").toString().toUpper();
if(cntryAbbr == "UK")
cntryAbbr = "GB";
if (! langAbbr.isEmpty() &&
! cntryAbbr.isEmpty())
QLocale::setDefault(QLocale(langAbbr + "_" + cntryAbbr));
else if (! langAbbr.isEmpty())
QLocale::setDefault(QLocale(langq.value("lang_abbr2").toString()));
else if (langq.value("lang_qt_number").toInt() &&
langq.value("country_qt_number").toInt())
QLocale::setDefault(
QLocale(QLocale::Language(langq.value("lang_qt_number").toInt()),
QLocale::Country(langq.value("country_qt_number").toInt())));
else
QLocale::setDefault(QLocale::system());
qDebug("Locale set to language %s and country %s",
QLocale().languageToString(QLocale().language()).toAscii().data(),
QLocale().countryToString(QLocale().country()).toAscii().data());
}
else if (langq.lastError().type() != QSqlError::NoError)
{
systemError(0, langq.lastError().databaseText(), __FILE__, __LINE__);
}
qApp->processEvents();
QString key;
// TODO: Add code to check a few locations - Hopefully done
QString keypath;
QString keyname;
QString keytogether;
#ifdef Q_WS_WIN
keypath = _metrics->value("CCWinEncKey");
#elif defined Q_WS_MACX
keypath = _metrics->value("CCMacEncKey");
#elif defined Q_WS_X11
keypath = _metrics->value("CCLinEncKey");
#endif
if (keypath.isEmpty())
keypath = app.applicationDirPath();
if (! keypath.endsWith(QDir::separator()))
keypath += QDir::separator();
keyname = _metrics->value("CCEncKeyName");
if (keyname.isEmpty())
{
keyname = "xTuple.key";
keytogether = keypath + keyname;
QFile kn(keytogether);
if(!kn.exists())
keyname = "OpenMFG.key";
}
keytogether = keypath + keyname;
// qDebug("keytogether: %s", keytogether.toAscii().data());
QFile keyFile(keytogether);
if(keyFile.exists())
{
if(keyFile.open(QIODevice::ReadOnly))
{
key = keyFile.readLine(1024);
// strip off any newline characters
key = key.trimmed();
}
}
omfgThis = 0;
omfgThis = new GUIClient(databaseURL, username);
omfgThis->_key = key;
if (key.length() > 0) {
_splash->showMessage(QObject::tr("Loading Database Encryption Metrics"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_metricsenc = new Metricsenc(key);
}
initializePlugin(_preferences, _metrics, _privileges, omfgThis->username(), omfgThis->workspace());
// START code for updating the locale settings if they haven't been already
XSqlQuery lc;
lc.exec("SELECT count(*) FROM metric WHERE metric_name='AutoUpdateLocaleHasRun';");
lc.first();
if(lc.value(0).toInt() == 0)
{
lc.exec("INSERT INTO metric (metric_name, metric_value) values('AutoUpdateLocaleHasRun', 't');");
lc.exec("SELECT locale_id from locale;");
while(lc.next())
{
ParameterList params;
params.append("mode","edit");
params.append("locale_id", lc.value(0));
sysLocale lcdlg;
lcdlg.set(params);
lcdlg.sSave();
}
}
// END code for updating locale settings
QObject::connect(&app, SIGNAL(aboutToQuit()), &app, SLOT(closeAllWindows()));
if (omfgThis->_singleWindow.isEmpty())
{
omfgThis->setAttribute(Qt::WA_DeleteOnClose);
omfgThis->show();
}
// keep this synchronized with GUIClient and user.ui.h
else if (omfgThis->_singleWindow == "woTimeClock")
{
ScriptToolbox sb(0);
QWidget* newdlg = sb.openWindow("woTimeClock");
if(newdlg)
{
XMainWindow *mw = qobject_cast<XMainWindow*>(newdlg);
if(mw)
{
ParameterList params;
params.append("captive");
mw->set(params);
}
newdlg->setAttribute(Qt::WA_DeleteOnClose);
QObject::connect(omfgThis, SIGNAL(destroyed(QObject*)), &app, SLOT(quit()));
newdlg->show();
}
else
{
int main(int argc, char *argv[])
{
Q_INIT_RESOURCE(guiclient);
QString username;
QString databaseURL;
QString passwd;
QString company;
bool haveUsername = FALSE;
bool haveDatabaseURL = FALSE;
bool loggedIn = FALSE;
bool haveEnhancedAuth= false;
bool _enhancedAuth = false;
bool haveRequireSSL = false;
bool _requireSSL = false;
bool havePasswd = false;
bool cloudOption = false;
bool haveCloud = false;
qInstallMsgHandler(xTupleMessageOutput);
QApplication app(argc, argv);
#if QT_VERSION >= 0x040400
// This is the correct place for this call but on versions less
// than 4.4 it causes a crash for an unknown reason so it is
// called later on earlier versions.
QCoreApplication::addLibraryPath(QString("."));
#endif
#ifndef Q_WS_MACX
QApplication::setWindowIcon(QIcon(":/images/icon32x32.png"));
#endif
// Try and load a default translation file and install it
QTranslator defaultTranslator(&app);
if (defaultTranslator.load("default.qm", app.applicationDirPath()))
app.installTranslator(&defaultTranslator);
app.processEvents();
if (argc > 1)
{
for (int intCounter = 1; intCounter < argc; intCounter++)
{
QString argument(argv[intCounter]);
if (argument.contains("-databaseURL=", Qt::CaseInsensitive))
{
haveDatabaseURL = TRUE;
databaseURL = argument.right(argument.length() - 13);
}
else if (argument.contains("-username="******"-passwd=", Qt::CaseInsensitive))
{
havePasswd = TRUE;
passwd = argument.right(argument.length() - 8);
}
else if (argument.contains("-noAuth", Qt::CaseInsensitive))
{
haveUsername = TRUE;
havePasswd = TRUE;
}
else if (argument.contains("-enhancedAuth", Qt::CaseInsensitive))
{
haveEnhancedAuth = true;
_enhancedAuth = true;
if(argument.contains("=no", Qt::CaseInsensitive) || argument.contains("=false", Qt::CaseInsensitive))
_enhancedAuth = false;
}
else if (argument.contains("-requireSSL", Qt::CaseInsensitive))
{
haveRequireSSL = true;
_requireSSL = true;
if(argument.contains("=no", Qt::CaseInsensitive) || argument.contains("=false", Qt::CaseInsensitive))
_requireSSL = false;
}
else if (argument.contains("-cloud", Qt::CaseInsensitive))
{
haveCloud = true;
cloudOption = true;
if(argument.contains("=no", Qt::CaseInsensitive) || argument.contains("=false", Qt::CaseInsensitive))
cloudOption = false;
}
else if (argument.contains("-company=", Qt::CaseInsensitive))
{
company = argument.right(argument.length() - 9);
}
}
}
_splash = new QSplashScreen();
_splash->setPixmap(QPixmap(":/images/splashEmpty.png"));
_evaluation = FALSE;
if (!loggedIn)
{
ParameterList params;
params.append("copyright", _Copyright);
params.append("version", _Version);
params.append("build", QString("%1 %2").arg(__DATE__).arg(__TIME__));
if (haveUsername)
params.append("username", username);
if (havePasswd)
params.append("password", passwd);
if (haveDatabaseURL)
params.append("databaseURL", databaseURL);
if (haveEnhancedAuth)
params.append("enhancedAuth", _enhancedAuth);
if (haveRequireSSL)
params.append("requireSSL", _requireSSL);
if (_evaluation)
params.append("evaluation");
if ( (haveDatabaseURL) && (haveUsername) && (havePasswd) )
params.append("login");
if (haveCloud)
params.append("cloud", cloudOption);
if (!company.isEmpty())
params.append("company", company);
login2 newdlg(0, "", TRUE);
newdlg.set(params, _splash);
if(newdlg.result() != QDialog::Accepted)
{
if (newdlg.exec() == QDialog::Rejected)
return -1;
else
{
databaseURL = newdlg._databaseURL;
username = newdlg.username();
__password = newdlg.password();
company = newdlg.company();
cloudOption = newdlg.useCloud();
}
}
}
XSqlQuery metric;
metric.exec("SELECT metric_value"
" FROM metric"
" WHERE (metric_name = 'Application')" );
if(!metric.first() || (metric.value("metric_value").toString() == "Standard"))
{
// check if the xtmfg package is installed
metric.exec("SELECT pkghead_name FROM pkghead WHERE pkghead_name='xtmfg'");
if(metric.first())
{
_splash->setPixmap(QPixmap(":/images/splashMfgEdition.png"));
_Name = _Name.arg("Manufacturing");
}
else
{
_splash->setPixmap(QPixmap(":/images/splashStdEdition.png"));
_Name = _Name.arg("Standard");
}
_splash->showMessage(QObject::tr("Checking License Key"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
metric.exec("SELECT count(*) AS registered, (SELECT count(*) FROM pg_stat_activity WHERE datname=current_database()) AS total"
" FROM pg_stat_activity, pg_locks"
" WHERE((database=datid)"
" AND (classid=datid)"
" AND (objsubid=2)"
" AND (procpid = pg_backend_pid()));");
int cnt = 50000;
int tot = 50000;
if(metric.first())
{
cnt = metric.value("registered").toInt();
tot = metric.value("total").toInt();
}
metric.exec("SELECT metric_value"
" FROM metric"
" WHERE(metric_name = 'RegistrationKey');");
bool checkPass = true;
QString checkPassReason;
QString rkey = "";
if(metric.first())
rkey = metric.value("metric_value").toString();
XTupleProductKey pkey(rkey);
if(pkey.valid() && pkey.version() == 1)
{
if(pkey.expiration() < QDate::currentDate())
{
checkPass = false;
checkPassReason = QObject::tr("Your license has expired.");
}
else if(pkey.users() != 0 && (pkey.users() < cnt || pkey.users() * 2 < tot))
{
checkPass = false;
checkPassReason = QObject::tr("You have exceeded the number of allowed concurrent users for your license.");
}
}
else
{
checkPass = false;
checkPassReason = QObject::tr("<p>The Registration key installed for this system does not appear to be valid.");
}
if(!checkPass)
{
_splash->hide();
if(QMessageBox::critical(0, QObject::tr("Registration Key"), QObject::tr("%1\n<p>Would you like to continue anyway?").arg(checkPassReason), QMessageBox::Yes | QMessageBox::No, QMessageBox::No) == QMessageBox::No)
return 0;
metric.exec("SELECT current_database() AS db,"
" fetchMetricText('DatabaseName') AS dbname,"
" fetchMetricText('remitto_name') AS name;");
QString db = "";
QString dbname = "";
QString name = "";
if(metric.first())
{
db = metric.value("db").toString();
dbname = metric.value("dbname").toString();
name = metric.value("name").toString();
}
QHttp *http = new QHttp();
QUrl url;
url.setPath("/api/regviolation.php");
url.addQueryItem("key", QUrl::toPercentEncoding(rkey));
url.addQueryItem("error", QUrl::toPercentEncoding(checkPassReason));
url.addQueryItem("name", QUrl::toPercentEncoding(name));
url.addQueryItem("dbname", QUrl::toPercentEncoding(dbname));
url.addQueryItem("db", QUrl::toPercentEncoding(db));
url.addQueryItem("cnt", QString::number(cnt));
http->setHost("www.xtuple.org");
http->get(url.toString());
_splash->show();
}
}
else
{
_splash->setPixmap(QPixmap(":/images/splashPostBooks.png"));
_Name = _Name.arg("PostBooks");
}
metric.exec("SELECT metric_value"
" FROM metric"
" WHERE (metric_name = 'ServerVersion')" );
if(!metric.first() || (metric.value("metric_value").toString() != _dbVersion))
{
bool disallowMismatch = false;
metric.exec("SELECT metric_value FROM metric WHERE(metric_name='DisallowMismatchClientVersion')");
if(metric.first() && (metric.value("metric_value").toString() == "t"))
disallowMismatch = true;
_splash->hide();
int result;
if(disallowMismatch)
result = QMessageBox::warning( 0, QObject::tr("Version Mismatch"),
QObject::tr("<p>The version of the database you are connecting to is "
"not the version this client was designed to work against. "
"This client was designed to work against the database "
"version %1. The system has been configured to disallow "
"access in this case.<p>Please contact your systems "
"administrator.").arg(_dbVersion),
QMessageBox::Ok | QMessageBox::Escape | QMessageBox::Default );
else
result = QMessageBox::warning( 0, QObject::tr("Version Mismatch"),
QObject::tr("<p>The version of the database you are connecting to is "
"not the version this client was designed to work against. "
"This client was designed to work against the database "
"version %1. If you continue some or all functionality may "
"not work properly or at all. You may also cause other "
"problems on the database.<p>Do you want to continue "
"anyway?").arg(_dbVersion),
QMessageBox::Yes,
QMessageBox::No | QMessageBox::Escape | QMessageBox::Default );
if(result != QMessageBox::Yes)
return 0;
_splash->show();
}
_splash->showMessage(QObject::tr("Loading Database Metrics"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_metrics = new Metrics();
_splash->showMessage(QObject::tr("Loading User Preferences"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_preferences = new Preferences(username);
_splash->showMessage(QObject::tr("Loading User Privileges"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_privileges = new Privileges();
// Load the translator and set the locale from the User's preferences
_splash->showMessage(QObject::tr("Loading Translation Dictionary"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
XSqlQuery langq("SELECT * "
"FROM usr, locale LEFT OUTER JOIN"
" lang ON (locale_lang_id=lang_id) LEFT OUTER JOIN"
" country ON (locale_country_id=country_id) "
"WHERE ( (usr_username=CURRENT_USER)"
" AND (usr_locale_id=locale_id) );" );
if (langq.first())
{
QStringList files;
if (!langq.value("locale_lang_file").toString().isEmpty())
files << langq.value("locale_lang_file").toString();
QString langext;
if (!langq.value("lang_abbr2").toString().isEmpty() &&
!langq.value("country_abbr").toString().isEmpty())
{
langext = langq.value("lang_abbr2").toString() + "_" +
langq.value("country_abbr").toString().toLower();
}
else if (!langq.value("lang_abbr2").toString().isEmpty())
{
langext = langq.value("lang_abbr2").toString();
}
if(!langext.isEmpty())
{
files << "xTuple";
files << "openrpt";
files << "reports";
XSqlQuery pkglist("SELECT pkghead_name"
" FROM pkghead"
" WHERE packageIsEnabled(pkghead_name);");
while(pkglist.next())
files << pkglist.value("pkghead_name").toString();
}
if (files.size() > 0)
{
QStringList notfound;
QTranslator *translator = new QTranslator(&app);
for (QStringList::Iterator fit = files.begin(); fit != files.end(); ++fit)
{
if (DEBUG)
qDebug("looking for %s", (*fit).toAscii().data());
if (translator->load(translationFile(langext, *fit)))
{
app.installTranslator(translator);
qDebug("installed %s", (*fit).toAscii().data());
translator = new QTranslator(&app);
}
else
notfound << *fit;
}
if (! notfound.isEmpty() &&
!_preferences->boolean("IngoreMissingTranslationFiles"))
QMessageBox::warning( 0, QObject::tr("Cannot Load Dictionary"),
QObject::tr("<p>The Translation Dictionaries %1 "
"cannot be loaded. Reverting "
"to the default dictionary." )
.arg(notfound.join(QObject::tr(", "))));
}
/* set the locale to langabbr_countryabbr, langabbr, {lang# country#}, or
lang#, depending on what information is available
*/
QString langAbbr = langq.value("lang_abbr2").toString();
QString cntryAbbr = langq.value("country_abbr").toString().toUpper();
if(cntryAbbr == "UK")
cntryAbbr = "GB";
if (! langAbbr.isEmpty() &&
! cntryAbbr.isEmpty())
QLocale::setDefault(QLocale(langAbbr + "_" + cntryAbbr));
else if (! langAbbr.isEmpty())
QLocale::setDefault(QLocale(langq.value("lang_abbr2").toString()));
else if (langq.value("lang_qt_number").toInt() &&
langq.value("country_qt_number").toInt())
QLocale::setDefault(
QLocale(QLocale::Language(langq.value("lang_qt_number").toInt()),
QLocale::Country(langq.value("country_qt_number").toInt())));
else
QLocale::setDefault(QLocale::system());
qDebug("Locale set to language %s and country %s",
QLocale().languageToString(QLocale().language()).toAscii().data(),
QLocale().countryToString(QLocale().country()).toAscii().data());
}
else if (langq.lastError().type() != QSqlError::NoError)
{
systemError(0, langq.lastError().databaseText(), __FILE__, __LINE__);
}
qApp->processEvents();
QString key;
// TODO: Add code to check a few locations - Hopefully done
QString keypath;
QString keyname;
QString keytogether;
#ifdef Q_WS_WIN
keypath = _metrics->value("CCWinEncKey");
#elif defined Q_WS_MACX
keypath = _metrics->value("CCMacEncKey");
#elif defined Q_WS_X11
keypath = _metrics->value("CCLinEncKey");
#endif
if (keypath.isEmpty())
keypath = app.applicationDirPath();
if (! keypath.endsWith(QDir::separator()))
keypath += QDir::separator();
keyname = _metrics->value("CCEncKeyName");
if (keyname.isEmpty())
{
keyname = "xTuple.key";
keytogether = keypath + keyname;
QFile kn(keytogether);
if(!kn.exists())
keyname = "OpenMFG.key";
}
keytogether = keypath + keyname;
// qDebug("keytogether: %s", keytogether.toAscii().data());
QFile keyFile(keytogether);
if(keyFile.exists())
{
if(keyFile.open(QIODevice::ReadOnly))
{
key = keyFile.readLine(1024);
// strip off any newline characters
key = key.trimmed();
}
}
omfgThis = 0;
omfgThis = new GUIClient(databaseURL, username);
omfgThis->_key = key;
omfgThis->_company = company;
omfgThis->_useCloud = cloudOption;
// qDebug("Encryption Key: %s", key.toAscii().data() );
if (key.length() > 0) {
_splash->showMessage(QObject::tr("Loading Database Encryption Metrics"), SplashTextAlignment, SplashTextColor);
qApp->processEvents();
_metricsenc = new Metricsenc(key);
}
initializePlugin(_preferences, _metrics, _privileges, omfgThis->workspace());
// START code for updating the locale settings if they haven't been already
XSqlQuery lc;
lc.exec("SELECT count(*) FROM metric WHERE metric_name='AutoUpdateLocaleHasRun';");
lc.first();
if(lc.value(0).toInt() == 0)
{
lc.exec("INSERT INTO metric (metric_name, metric_value) values('AutoUpdateLocaleHasRun', 't');");
lc.exec("SELECT locale_id from locale;");
while(lc.next())
{
ParameterList params;
params.append("mode","edit");
params.append("locale_id", lc.value(0));
sysLocale lcdlg;
lcdlg.set(params);
lcdlg.sSave();
}
}
// END code for updating locale settings
QObject::connect(&app, SIGNAL(aboutToQuit()), &app, SLOT(closeAllWindows()));
if (omfgThis->_singleWindow.isEmpty())
{
omfgThis->setAttribute(Qt::WA_DeleteOnClose);
omfgThis->show();
}
// keep this synchronized with GUIClient and user.ui.h
else if (omfgThis->_singleWindow == "woTimeClock")
{
ScriptToolbox sb(0);
QWidget* newdlg = sb.openWindow("woTimeClock");
if(newdlg)
{
XMainWindow *mw = qobject_cast<XMainWindow*>(newdlg);
if(mw)
{
ParameterList params;
params.append("captive");
mw->set(params);
}
newdlg->setAttribute(Qt::WA_DeleteOnClose);
QObject::connect(omfgThis, SIGNAL(destroyed(QObject*)), &app, SLOT(quit()));
newdlg->show();
}
else
{
/*!
* parse a text file and return an author list in an html table:
* left the names and right the contact address
* the html table can be "split" in sections
* @param QString fileName the file to be parsed
* @return QString the html table
*/
QString About::parseTranslationFile(QString fileName)
{
QString result;
QString file;
QFile translationFile(fileName);
if (translationFile.open(QIODevice::ReadOnly | QIODevice::Text))
{
QTextStream inTS(&translationFile);
inTS.setCodec("UTF-8");
inTS.setAutoDetectUnicode(true);
QString lineTS;
QStringList fieldTS;
QString code;
QString name;
QString contact;
// LanguageManager langmgr;
// langmgr.init(false);
bool isSectionTitle = true;
bool isTitle = false;
bool startText = false;
bool startTitle = false;
result = "<table>";
QMap<QString, QString> sections;
QMap<QString, QString> languages;
QMultiMap<QString, QString> names;
QString currLang;
int section=0;
QString snum;
while (!inTS.atEnd())
{
lineTS = inTS.readLine();
lineTS.replace("<", "<");
lineTS.replace(">", ">");
name = "";
contact = "";
if (!lineTS.isEmpty())
{
if (isSectionTitle)
{
++section;
snum.setNum(section);
//result += "<tr><td><b><i>"+About::trTranslationTitle(lineTS)+"</i></b></td><td></td></tr>";
sections.insert(snum, "<tr><td><b><i>"+About::trTranslationTitle(lineTS)+"</i></b></td><td></td></tr>");
isSectionTitle = false;
isTitle = false;
startTitle = false;
}
else if (isTitle)
{
startTitle = false;
fieldTS = lineTS.split(" ");
code = (fieldTS.isEmpty() ? "" : fieldTS.takeLast());
if (!code.isEmpty())
{
code.replace("(", "");
code.replace(")", "");
code = LanguageManager::instance()->getLangFromAbbrev(code);
}
//result += "<tr><td><b>"+code+"</b></td><td></td></tr>";
languages.insert(snum+":"+code, "<tr><td><b>"+code+"</b></td><td></td></tr>");
isTitle = false;
currLang=code;
} // if is title
else
{
startText = false;
fieldTS = lineTS.split(" ");
contact = (fieldTS.isEmpty() ? "" : fieldTS.takeLast());
contact.replace("(", "");
contact.replace(")", "");
name = (fieldTS.isEmpty() ? "" : fieldTS.join(" "));
//result += "<tr><td>"+name+"</td><td>"+(contact == "@" ? "" : contact)+"</td></tr>";
names.insert(snum+":"+code, "<tr><td>"+name+"</td><td>"+(contact == "@" ? "" : contact)+"</td></tr>");
} // else is title
} // if is empty line
else
{
// empty lines switch between title and text
if (!startText && !startTitle)
{
isTitle = !isTitle;
if (isTitle)
{
//result += "<tr><td></td><td></td></tr>";
startTitle = true;
}
else
{
startText = true;
}
//
// multiple empty lines start a section instead of marking a title
}
else if (startTitle)
{
isTitle = false;
isSectionTitle = true;
}
} // else is empty line
} // while ! atEnd
QMapIterator<QString, QString> s(sections);
while (s.hasNext())
{
s.next();
result += s.value();
QMapIterator<QString, QString> l(languages);
while (l.hasNext())
{
l.next();
QStringList sl=l.key().split(":");
if (s.key()==sl.first())
{
result += l.value();
QMapIterator<QString, QString> n(names);
while (n.hasNext())
{
n.next();
if (n.key()==l.key())
result += n.value();
}
result += "<tr><td></td><td></td></tr>";
}
}
result += "<tr><td></td><td></td></tr><tr><td></td><td></td></tr>";
}
result += "<table>";
} // if file found
else
{
if (!fileName.isEmpty())
{
QStringList field = fileName.split("/");
if (!field.isEmpty())
{
file = field.takeLast();
}
}
result = tr("Unable to open %1 file. Please check your install directory or the Scribus website for %1 information.").arg(file);
result = "";
} // else file found
return result;
} // parseTranslationFile()
checkForUpdates::checkForUpdates(QWidget* parent, Qt::WFlags fl)
: XWidget(parent, fl)
{
setupUi(this);
QUrl updatequrl("http://updates.xtuple.com/checkForUpdates.php");
updatequrl.addQueryItem("xtuple", _Version);
XSqlQuery versions;
versions.exec("SELECT version() AS pgver,"
" fetchMetricText('ServerVersion') AS dbver,"
" fetchMetricText('Application') AS dbprod;");
if(versions.first())
{
updatequrl.addQueryItem("postgres", versions.value("pgver").toString());
updatequrl.addQueryItem(versions.value("dbprod").toString(),
versions.value("dbver").toString());
}
else if (versions.lastError().type() != QSqlError::NoError)
systemError(this, versions.lastError().text(), __FILE__, __LINE__);
// no return - let's learn as much as we can
#ifdef Q_WS_MACX
QString helpdir = QApplication::applicationDirPath() +
"/../Resources/helpXTupleGUIClient";
#else
QString helpdir = QApplication::applicationDirPath() + "helpXTupleGUIClient";
#endif
QFile helpfile(helpdir + "/index.html");
QString helpver;
if (helpfile.exists())
{
if (helpfile.open(QIODevice::ReadOnly))
{
QXmlQuery helpverq;
if (helpverq.setFocus(&helpfile))
{
helpverq.setQuery("/descendant::p[attribute::class='releaseinfo']/text()/string()");
if (helpverq.isValid())
{
QStringList helpverlist;
if (helpverq.evaluateTo(&helpverlist) && ! helpverlist.isEmpty())
helpver = helpverlist.at(0);
else if (DEBUG)
qDebug("Could not find the releaseinfo in %s",
qPrintable(helpfile.fileName()));
}
else if (DEBUG)
qDebug("The helpver query is not valid for some reason");
}
else if (DEBUG)
qDebug("Could not set focus on the help file %s",
qPrintable(helpfile.fileName()));
}
else if (DEBUG)
qDebug("Found the help file %s but could not open it: %s",
qPrintable(helpfile.fileName()),
qPrintable(helpfile.errorString()));
}
else if (DEBUG)
qDebug("The help file %s does not exist", qPrintable(helpfile.fileName()));
updatequrl.addQueryItem("xTupleHelp", helpver);
QStringList context;
context << "xTuple" << "openrpt" << "reports"; // duplicated from main.cpp!
versions.exec("SELECT pkghead_name, pkghead_version"
" FROM pkghead"
" WHERE packageisenabled(pkghead_id);");
while(versions.next())
{
updatequrl.addQueryItem(versions.value("pkghead_name").toString(),
versions.value("pkghead_version").toString());
context << versions.value("pkghead_name").toString();
}
if (versions.lastError().type() != QSqlError::NoError)
systemError(this, versions.lastError().text(), __FILE__, __LINE__);
// no return - let's learn as much as we can
// get all of the locales on the system
versions.exec("SELECT DISTINCT lang_abbr2, country_abbr"
" FROM locale"
" JOIN lang ON (locale_lang_id=lang_id)"
" LEFT OUTER JOIN country ON (locale_country_id=country_id)"
" ORDER BY lang_abbr2, country_abbr;");
QStringList locale;
while(versions.next())
{
QString tmp = versions.value("lang_abbr2").toString();
if (! versions.value("country_abbr").isNull())
tmp += "_" + versions.value("country_abbr").toString();
locale.append(tmp);
}
if (! locale.isEmpty())
updatequrl.addQueryItem("locales", locale.join(","));
else if(versions.lastError().type() != QSqlError::NoError)
systemError(this, versions.lastError().text(), __FILE__, __LINE__);
// maybe i want to update just _my_ translation file
versions.exec("SELECT lang_abbr2, country_abbr"
" FROM locale"
" JOIN usr ON (locale_id=usr_locale_id)"
" JOIN lang ON (locale_lang_id=lang_id)"
" LEFT OUTER JOIN country ON (locale_country_id=country_id)"
" WHERE (usr_username=getEffectiveXtUser());");
if (versions.first())
{
QString tmp = versions.value("lang_abbr2").toString();
if (! versions.value("country_abbr").isNull())
tmp += "_" + versions.value("country_abbr").toString();
updatequrl.addQueryItem("mylocale", tmp);
}
else if(versions.lastError().type() != QSqlError::NoError)
systemError(this, versions.lastError().text(), __FILE__, __LINE__);
QString qmparam = "qm.%1.%2";
for (int l = 0; l < locale.length(); l++)
{
for (int c = 0; c < context.length(); c++)
{
QString version("");
QString tf = translationFile(locale.at(l), context.at(c), version);
updatequrl.addQueryItem(qmparam.arg(context.at(c), locale.at(l)), version);
}
}
if (DEBUG)
qDebug("checkForUpdates::checkForUpdates() sending %s",
updatequrl.toEncoded().data());
_view->load(updatequrl);
}
