QString QgsDateTimeSearchWidgetWrapper::createExpression( QgsSearchWidgetWrapper::FilterFlags flags ) const
{
QString fieldName = QgsExpression::quotedColumnRef( layer()->fields().at( mFieldIdx ).name() );
//clear any unsupported flags
flags &= supportedFlags();
if ( flags & IsNull )
return fieldName + " IS NULL";
if ( flags & IsNotNull )
return fieldName + " IS NOT NULL";
QVariant v = value();
if ( !v.isValid() )
return QString();
if ( flags & EqualTo )
return fieldName + "='" + v.toString() + '\'';
else if ( flags & NotEqualTo )
return fieldName + "<>'" + v.toString() + '\'';
else if ( flags & GreaterThan )
return fieldName + ">'" + v.toString() + '\'';
else if ( flags & LessThan )
return fieldName + "<'" + v.toString() + '\'';
else if ( flags & GreaterThanOrEqualTo )
return fieldName + ">='" + v.toString() + '\'';
else if ( flags & LessThanOrEqualTo )
return fieldName + "<='" + v.toString() + '\'';
return QString();
}
QString QgsValueMapSearchWidgetWrapper::createExpression( QgsSearchWidgetWrapper::FilterFlags flags ) const
{
//if deselect value, always pass
if ( mComboBox->currentIndex() == 0 )
return QString();
//clear any unsupported flags
flags &= supportedFlags();
QVariant::Type fldType = layer()->fields().at( mFieldIdx ).type();
QString fieldName = QgsExpression::quotedColumnRef( layer()->fields().at( mFieldIdx ).name() );
if ( flags & IsNull )
return fieldName + " IS NULL";
if ( flags & IsNotNull )
return fieldName + " IS NOT NULL";
QString currentKey = mComboBox->currentData().toString();
switch ( fldType )
{
case QVariant::Int:
case QVariant::UInt:
case QVariant::Double:
case QVariant::LongLong:
case QVariant::ULongLong:
{
if ( flags & EqualTo )
return fieldName + '=' + currentKey;
else if ( flags & NotEqualTo )
return fieldName + "<>" + currentKey;
break;
}
default:
{
if ( flags & EqualTo )
return fieldName + "='" + currentKey + '\'';
else if ( flags & NotEqualTo )
return fieldName + "<>'" + currentKey + '\'';
break;
}
}
return QString();
}
QString QgsCheckboxSearchWidgetWrapper::createExpression( QgsSearchWidgetWrapper::FilterFlags flags ) const
{
QVariant::Type fldType = layer()->fields().at( mFieldIdx ).type();
QString fieldName = QgsExpression::quotedColumnRef( layer()->fields().at( mFieldIdx ).name() );
//clear any unsupported flags
flags &= supportedFlags();
if ( flags & IsNull )
return fieldName + " IS NULL";
if ( flags & IsNotNull )
return fieldName + " IS NOT NULL";
QVariant v = value();
if ( !v.isValid() )
return QString();
switch ( fldType )
{
case QVariant::Int:
case QVariant::UInt:
case QVariant::Double:
case QVariant::LongLong:
case QVariant::ULongLong:
{
if ( flags & EqualTo )
return fieldName + '=' + v.toString();
else if ( flags & NotEqualTo )
return fieldName + "<>" + v.toString();
break;
}
default:
{
if ( flags & EqualTo )
return fieldName + "='" + v.toString() + '\'';
else if ( flags & NotEqualTo )
return fieldName + "<>'" + v.toString() + '\'';
break;
}
}
return QString();
}
QString QgsValueRelationSearchWidgetWrapper::createExpression( QgsSearchWidgetWrapper::FilterFlags flags ) const
{
QString fieldName = createFieldIdentifier();
//clear any unsupported flags
flags &= supportedFlags();
if ( flags & IsNull )
return fieldName + " IS NULL";
if ( flags & IsNotNull )
return fieldName + " IS NOT NULL";
QVariant v = value();
if ( !v.isValid() )
return QString();
switch ( v.type() )
{
case QVariant::Int:
case QVariant::UInt:
case QVariant::Double:
case QVariant::LongLong:
case QVariant::ULongLong:
{
if ( flags & EqualTo )
return fieldName + '=' + v.toString();
else if ( flags & NotEqualTo )
return fieldName + "<>" + v.toString();
break;
}
default:
{
if ( flags & EqualTo )
return fieldName + "='" + v.toString() + '\'';
else if ( flags & NotEqualTo )
return fieldName + "<>'" + v.toString() + '\'';
break;
}
}
return QString();
}
QString QgsDefaultSearchWidgetWrapper::createExpression( QgsSearchWidgetWrapper::FilterFlags flags ) const
{
//clear any unsupported flags
flags &= supportedFlags();
QVariant::Type fldType = layer()->fields().at( mFieldIdx ).type();
QString fieldName = QgsExpression::quotedColumnRef( layer()->fields().at( mFieldIdx ).name() );
if ( flags & IsNull )
return fieldName + " IS NULL";
if ( flags & IsNotNull )
return fieldName + " IS NOT NULL";
switch ( fldType )
{
case QVariant::Int:
case QVariant::UInt:
case QVariant::Double:
case QVariant::LongLong:
case QVariant::ULongLong:
{
if ( flags & EqualTo )
return fieldName + '=' + mLineEdit->text();
else if ( flags & NotEqualTo )
return fieldName + "<>" + mLineEdit->text();
else if ( flags & GreaterThan )
return fieldName + '>' + mLineEdit->text();
else if ( flags & LessThan )
return fieldName + '<' + mLineEdit->text();
else if ( flags & GreaterThanOrEqualTo )
return fieldName + ">=" + mLineEdit->text();
else if ( flags & LessThanOrEqualTo )
return fieldName + "<=" + mLineEdit->text();
break;
}
case QVariant::Date:
case QVariant::DateTime:
case QVariant::Time:
{
if ( flags & EqualTo )
return fieldName + "='" + mLineEdit->text() + '\'';
else if ( flags & NotEqualTo )
return fieldName + "<>'" + mLineEdit->text() + '\'';
else if ( flags & GreaterThan )
return fieldName + ">'" + mLineEdit->text() + '\'';
else if ( flags & LessThan )
return fieldName + "<'" + mLineEdit->text() + '\'';
else if ( flags & GreaterThanOrEqualTo )
return fieldName + ">='" + mLineEdit->text() + '\'';
else if ( flags & LessThanOrEqualTo )
return fieldName + "<='" + mLineEdit->text() + '\'';
break;
}
case QVariant::String:
{
// case insensitive!
if ( flags & EqualTo || flags & NotEqualTo )
{
if ( mCheckbox && mCheckbox->isChecked() )
return fieldName + ( flags & EqualTo ? "=" : "<>" )
+ QgsExpression::quotedString( mLineEdit->text() );
else
return QStringLiteral( "lower(%1)" ).arg( fieldName )
+ ( flags & EqualTo ? "=" : "<>" ) +
QStringLiteral( "lower(%1)" ).arg( QgsExpression::quotedString( mLineEdit->text() ) );
}
else if ( flags & Contains || flags & DoesNotContain )
{
QString exp = fieldName + ( mCheckbox && mCheckbox->isChecked() ? " LIKE " : " ILIKE " );
QString value = QgsExpression::quotedString( mLineEdit->text() );
value.chop( 1 );
value = value.remove( 0, 1 );
exp += "'%" + value + "%'";
if ( flags & DoesNotContain )
exp.prepend( "NOT (" ).append( ")" );
return exp;
}
break;
}
default:
break;
}
return QString();
}
