QgsSearchQueryBuilder::QgsSearchQueryBuilder( QgsVectorLayer* layer,
QWidget *parent, const Qt::WindowFlags& fl )
: QDialog( parent, fl ), mLayer( layer )
{
setupUi( this );
setupListViews();
setWindowTitle( tr( "Search query builder" ) );
QPushButton *pbn = new QPushButton( tr( "&Test" ) );
buttonBox->addButton( pbn, QDialogButtonBox::ActionRole );
connect( pbn, SIGNAL( clicked() ), this, SLOT( on_btnTest_clicked() ) );
pbn = new QPushButton( tr( "&Clear" ) );
buttonBox->addButton( pbn, QDialogButtonBox::ActionRole );
connect( pbn, SIGNAL( clicked() ), this, SLOT( on_btnClear_clicked() ) );
pbn = new QPushButton( tr( "&Save..." ) );
buttonBox->addButton( pbn, QDialogButtonBox::ActionRole );
pbn->setToolTip( tr( "Save query to an xml file" ) );
connect( pbn, SIGNAL( clicked() ), this, SLOT( saveQuery() ) );
pbn = new QPushButton( tr( "&Load..." ) );
buttonBox->addButton( pbn, QDialogButtonBox::ActionRole );
pbn->setToolTip( tr( "Load query from xml file" ) );
connect( pbn, SIGNAL( clicked() ), this, SLOT( loadQuery() ) );
if ( layer )
lblDataUri->setText( layer->name() );
populateFields();
}
MetadataEditor::MetadataEditor( const Tomahawk::query_ptr& query, const Tomahawk::playlistinterface_ptr& plInterface, QWidget* parent )
: QDialog( parent )
{
init( plInterface );
loadQuery( query );
}
AddClientDialog::AddClientDialog(QWidget *parent, Qt::WFlags flags)
: QDialog(parent, flags)
{
setupUi(this);
info = new ConnectionInfoWidget(this);
gridLayout_3->addWidget(info, 1, 0, 1, 1);
accountGroupBox->hide();
layout()->setSizeConstraint( QLayout::SetFixedSize );
currencyShortLabel->setText(tr("Code: "));
QRegExp regexp("[1-9][0-9][0-9]{1,1}");
numberLineEdit->setValidator(new QRegExpValidator(regexp, this));
connect( nameLineEdit, SIGNAL( textChanged(const QString &)), this, SLOT( enableOkButton() ) );
connect( cancelButton, SIGNAL( clicked() ), this, SLOT( reject() ) );
connect( okButton, SIGNAL( clicked() ), this, SLOT( okButtonClicked() ) );
connect( moreButton, SIGNAL( toggled(bool) ), this, SLOT( changeMoreButtonText() ) );
connect( moreButton, SIGNAL( toggled(bool) ), this, SLOT( moreButtonClicked() ) );
connect( currencyComboBox, SIGNAL( currentIndexChanged(int)), this, SLOT( changeShortLabelText() ));
connect( numberLineEdit, SIGNAL( textChanged(const QString &) ), this, SLOT( enableOkButton() ));
qList << "get_currency_list" << "create_client" << "create_client_with_account";
tcs = new ThreadControl( this );
connect( tcs, SIGNAL(canGetData()), this, SLOT(loadQuery()));
connect( tcs, SIGNAL(errorRaised(QString)), this, SLOT(loadError(QString)));
loadCurrencyRequest();
}
void AddCourseDialog::loadEnv()
{
qList << "get_currency_properties" << "create_course" << "create_sale_course_for_course";
tcs = new ThreadControl( this );
connect( tcs, SIGNAL( errorRaised(QString) ), this, SLOT( loadError(QString) ) );
connect( tcs, SIGNAL( canGetData() ), this, SLOT( loadQuery() ) );
}
void CoefficientDialog::loadEnv()
{
qList << "get_coefficient_page_info" << "get_account_coefficient_list" << "assign_deal_coefficient";
socket = new QuerySocket( this );
connect( socket, SIGNAL( errorRaised() ), this, SLOT( loadError() ) );
connect( socket, SIGNAL( canGetData() ), this, SLOT( loadQuery() ) );
}
void
MetadataEditor::loadPreviousQuery()
{
writeMetadata();
if ( m_interface->siblingIndex( -1, m_index ) > 0 )
{
m_index = m_interface->siblingIndex( -1, m_index );
loadQuery( m_interface->queryAt( m_index ) );
}
}
void TransactionWidget::loadEnv()
{
qList << "get_account_header" << "get_account_statement";
qList << "clear_deal_coefficients" << "get_account_passive";
qList << "get_account_statement_for_the_date" << "get_account_statement_for_the_period";
qList << "get_account_saldo_info"; // << "get_account_initial_saldo";
tcs = new ThreadControl( this );
connect( tcs, SIGNAL( canGetData() ), this, SLOT( loadQuery() ) );
connect( tcs, SIGNAL( stateChanged( bool ) ), this, SLOT( enableActions( bool ) ) );
connect( tcs, SIGNAL( stateChanged( bool ) ), this, SLOT( changeState( bool ) ) );
}
int main(int argc, char *argv[])
{
MainApplication a(argc, argv);
// setup style
QFile f(":/DarkBlue.css");
if (f.open(QIODevice::ReadOnly))
a.setStyleSheet(f.readAll());
a.setOrganizationName("FenNils");
a.setApplicationName( APP_NAME );
a.setApplicationVersion( APP_VERSION );
QSettings::setDefaultFormat( QSettings::IniFormat );
QStringList args = a.arguments();
// setupTranslators(a);
const QString locale = QLocale::system().name();
QTranslator qtTranslator;
qtTranslator.load( QStringLiteral("qt_") + locale,
QLibraryInfo::location( QLibraryInfo::TranslationsPath ) );
a.installTranslator( &qtTranslator );
QTranslator translator;
translator.load( QStringLiteral("xqeval_") + locale,
QDir::cleanPath(QApplication::applicationDirPath() + SHARE_PATH + QStringLiteral("/translations")) );
a.installTranslator( &translator );
XQEMainWindow w;
QObject::connect( &a, SIGNAL(fileOpened(QString)), &w, SLOT(loadQuery(QString)), Qt::DirectConnection );
//!@todo Need to do it right! (file associations)
if ( args.count() > 1 )
{
const QString queryFile( args[1].trimmed() );
if ( !queryFile.startsWith(QChar(L'-')) ) {
w.loadQuery(queryFile);
}
}
w.show();
return a.exec();
}
void CoefficientDialog::saveTransactionRequest( quint64 dealId, quint64 coefId )
{
if( qList.count() < 3 )
return;
QuerySocket *scket;
if( socket->state() != QAbstractSocket::UnconnectedState )
{
scket = new QuerySocket( this );
connect( socket, SIGNAL( errorRaised() ), this, SLOT( loadError() ) );
connect( socket, SIGNAL( canGetData() ), this, SLOT( loadQuery() ) );
}
else
scket = socket;
QString query = qList[2] + "('" + QString::number( dealId ) + "', '" + QString::number( coefId ) + "')";
socket->setConnection( host, port, query );
info->showProgressBar( true );
}
void MangoExact::loadQuery (const Array<char> &buf)
{
BufferScanner scanner(buf);
loadQuery(scanner);
}
void MangoExact::loadQuery (const char *buf)
{
BufferScanner scanner(buf);
loadQuery(scanner);
}
void MangoSubstructure::loadQuery (const Array<char> &buf)
{
BufferScanner scanner(buf);
loadQuery(scanner);
}
void MangoSimilarity::loadQuery (const char *str)
{
BufferScanner scanner(str);
loadQuery(scanner);
}
void MangoSubstructure::loadQuery (const char *str)
{
BufferScanner scanner(str);
loadQuery(scanner);
}
void MangoTautomer::loadQuery (const Array<char> &buf)
{
BufferScanner scanner(buf);
loadQuery(scanner);
}
void CGantnerTime::reloadAllData()
{
//Reload all user
QSqlQuery userQuery("SELECT id, CONCAT(name, ' ', firstname) AS fullname, language FROM hr_user");
while(userQuery.next())
{
QSqlQuery groupAttributionQuery;
groupAttributionQuery.prepare("SELECT pg.id, pg.name, pg.comment FROM hr_user_group AS pg LEFT JOIN hr_user_group_attribution AS ga ON ga.id_group=pg.id LEFT JOIN hr_user AS pe ON pe.id=ga.id_user WHERE pe.id=:id");
groupAttributionQuery.bindValue(":id", userQuery.value(0));
groupAttributionQuery.exec();
while( groupAttributionQuery.next())
{
QString groupId = groupAttributionQuery.value(0).toString();
QSqlQuery deviceQuery;
deviceQuery.prepare("SELECT uga.id_device FROM hr_user_group_access AS uga LEFT JOIN hr_device AS d ON d.id = uga.id_device WHERE id_group=:id AND d.type='gantner_TimeTerminal'");
deviceQuery.bindValue(":id", groupId);
deviceQuery.exec();
while( deviceQuery.next())
{
QString deviceId = deviceQuery.value(0).toString();
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`, `param2`, `param3`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param, :param2, :param3)");
insertQuery.bindValue(":func", "add");
insertQuery.bindValue(":type", "user");
insertQuery.bindValue(":userId", userQuery.value(0) );
insertQuery.bindValue(":keyId", 0 );
insertQuery.bindValue(":deviceId", deviceId );
insertQuery.bindValue(":param", userQuery.value(1) );
insertQuery.bindValue(":param2",userQuery.value(2) );
//check the last booking to know if the user is present or absent
QSqlQuery checkLastBooking;
checkLastBooking.prepare("SELECT * FROM hr_tracking AS t LEFT JOIN hr_timux_booking AS tb ON t.id=tb.tracking_id WHERE t.id_user=:userId ORDER BY t.date DESC, t.time DESC, tb.action DESC LIMIT 0,1");
checkLastBooking.bindValue(":userId", userQuery.value(0) );
checkLastBooking.exec();
if(checkLastBooking.next()) {
if(checkLastBooking.value(11).toInt() == 255 || checkLastBooking.value(11).toInt() == 155 || checkLastBooking.value(12).toString().right(3) == "_IN" ) {
insertQuery.bindValue(":param3",1 );
} else {
insertQuery.bindValue(":param3",2 );
}
} else {
//no booking, the user is absent
insertQuery.bindValue(":param3",2 );
}
insertQuery.exec();
QSqlQuery keyQuery;
keyQuery.prepare("SELECT k.id, serialNumber FROM hr_keys_attribution AS ka LEFT JOIN hr_keys AS k ON k.id=ka.id_key WHERE id_user=:id AND k.isBlocked=0");
keyQuery.bindValue(":id", userQuery.value(0) );
keyQuery.exec();
while(keyQuery.next())
{
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`, `param2`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param, :param2)");
insertQuery.bindValue(":func", "add");
insertQuery.bindValue(":type", "key");
insertQuery.bindValue(":userId", userQuery.value(0) );
insertQuery.bindValue(":keyId", keyQuery.value(0) );
insertQuery.bindValue(":deviceId", deviceId );
insertQuery.bindValue(":param", keyQuery.value(1) );
insertQuery.bindValue(":param2", "" );
insertQuery.exec();
}
}
}
}
// Reload all absent reason
QSqlQuery deviceQuery("SELECT id_device FROM hr_gantner_TimeTerminal");
while( deviceQuery.next())
{
QSqlQuery timeCodeInQuery("SELECT * FROM hr_timux_timecode WHERE signtype='both' OR signtype='in'");
while( timeCodeInQuery.next())
{
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`, `param2`,`reasonId`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param, :param2,:reasonId)");
insertQuery.bindValue(":func", "add");
insertQuery.bindValue(":type", "reason");
insertQuery.bindValue(":userId", 0 );
insertQuery.bindValue(":keyId", 0 );
insertQuery.bindValue(":deviceId", deviceQuery.value(0) );
insertQuery.bindValue(":param", timeCodeInQuery.value(13).toString() );
insertQuery.bindValue(":param2", "1" );
insertQuery.bindValue(":reasonId", timeCodeInQuery.value(0).toString() + "_IN" );
insertQuery.exec();
}
QSqlQuery timeCodeOutQuery("SELECT * FROM hr_timux_timecode WHERE signtype='both' OR signtype='out'");
while( timeCodeOutQuery.next())
{
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`, `param2`,`reasonId`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param, :param2,:reasonId)");
insertQuery.bindValue(":func", "add");
insertQuery.bindValue(":type", "reason");
insertQuery.bindValue(":userId", 0 );
insertQuery.bindValue(":keyId", 0 );
insertQuery.bindValue(":deviceId", deviceQuery.value(0) );
insertQuery.bindValue(":param", timeCodeOutQuery.value(13).toString() );
insertQuery.bindValue(":param2", "2" );
insertQuery.bindValue(":reasonId", timeCodeOutQuery.value(0).toString() + "_OUT" );
insertQuery.exec();
}
//Reload balances text
QSqlQuery balancesTextQuery("SELECT * FROM hr_timux_timecode WHERE (type='overtime' OR type='leave') AND (defaultHoliday=1 OR defaultOvertime=1) ORDER BY type");
int fieldNo = 0;
while( balancesTextQuery.next())
{
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`, `param2`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param, :param2)");
insertQuery.bindValue(":func", "add");
insertQuery.bindValue(":type", "balancesText");
insertQuery.bindValue(":userId", 0 );
insertQuery.bindValue(":keyId", 0 );
insertQuery.bindValue(":deviceId", deviceQuery.value(0) );
insertQuery.bindValue(":param",fieldNo );
insertQuery.bindValue(":param2",balancesTextQuery.value(13).toString() );
insertQuery.exec();
fieldNo++;
}
for(int i=fieldNo; i<10; i++)
{
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`, `param2`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param, :param2)");
insertQuery.bindValue(":func", "add");
insertQuery.bindValue(":type", "balancesText");
insertQuery.bindValue(":userId", 0 );
insertQuery.bindValue(":keyId", 0 );
insertQuery.bindValue(":deviceId", deviceQuery.value(0) );
insertQuery.bindValue(":param",i );
insertQuery.bindValue(":param2","");
insertQuery.exec();
}
//Reload user balances
checkBalances();
// Remove all the load time code
for(int i=1; i<=20; i++ ) {
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param)");
insertQuery.bindValue(":func", "sub");
insertQuery.bindValue(":type", "load");
insertQuery.bindValue(":userId", 0 );
insertQuery.bindValue(":keyId", 0 );
insertQuery.bindValue(":deviceId", deviceQuery.value(0) );
insertQuery.bindValue(":param",i );
insertQuery.exec();
}
//Reload the load time code
QSqlQuery loadQuery("SELECT * FROM hr_timux_timecode WHERE type='load' ORDER BY name");
while( loadQuery.next()) {
QSqlQuery insertQuery;
insertQuery.prepare("INSERT INTO hr_gantner_standalone_action (`type`, `func`, `userId`,`keyId`, `deviceId`, `param`, `param2`, `param3`) VALUES (:type,:func,:userId,:keyId,:deviceId, :param, :param2, :param3)");
insertQuery.bindValue(":type", "load");
insertQuery.bindValue(":func", "add");
insertQuery.bindValue(":userId", 0 );
insertQuery.bindValue(":keyId", 0 );
insertQuery.bindValue(":deviceId", deviceQuery.value(0) );
insertQuery.bindValue(":param",loadQuery.value(15).toString() );
insertQuery.bindValue(":param2",loadQuery.value(2).toString());
insertQuery.bindValue(":param3",loadQuery.value(13).toString());
insertQuery.exec();
}
}
}
void MangoTautomer::loadQuery (const char *str)
{
BufferScanner scanner(str);
loadQuery(scanner);
}
void MangoSimilarity::loadQuery (const Array<char> &buf)
{
BufferScanner scanner(buf);
loadQuery(scanner);
}
