/*************************************************************************** FLFieldDB.cpp ------------------- begin : Wed Jul 4 2001 copyright : (C) 2001-2005 by InfoSiAL S.L. email : mail@infosial.com ***************************************************************************/ /*************************************************************************** * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * * the Free Software Foundation; version 2 of the License. * ***************************************************************************/ /*************************************************************************** Este programa es software libre. Puede redistribuirlo y/o modificarlo bajo los términos de la Licencia Pública General de GNU en su versión 2, publicada por la Free Software Foundation. ***************************************************************************/ #include #include "FLFieldDB.h" #include "FLSqlCursor.h" #include "FLSqlQuery.h" #include "FLFormSearchDB.h" #include "FLFormRecordDB.h" #include "FLTableMetaData.h" #include "FLFieldMetaData.h" #include "FLRelationMetaData.h" #include "FLManager.h" #include "FLAction.h" #include "FLTableDB.h" #include "FLDataTable.h" #include "FLUtil.h" #ifdef FL_TEST #include "FLTester.h" #endif #include "FLApplication.h" #include "FLSqlDatabase.h" #include "FLSqlConnections.h" #include "vdatepopup.h" // dpinelo FLLineEdit::FLLineEdit( QWidget * parent, const char *name ) : QLineEdit( parent, name ), tieneFoco_(false) { QLocale locale (QLocale::Spanish, QLocale::Spain); locale_ = locale; } void FLLineEdit::focusOutEvent( QFocusEvent * f ) { // dpinelo tieneFoco_ = false; QString s = text(); #ifndef Q_OS_WIN32 const QValidator *v = validator(); if ( v ) { v->fixup( s ); setText( s ); } #endif // dpinelo aplicarLocaleNumerico(); QLineEdit::focusOutEvent( f ); } void FLLineEdit::focusInEvent( QFocusEvent * f ) { // dpinelo tieneFoco_ = true; eliminarLocaleNumerico(); if ( selectedText().isEmpty() ) selectAll(); QLineEdit::focusInEvent( f ); } FLPixmapView::FLPixmapView( QWidget * parent ) : QScrollView( parent ), autoScaled_( false ), path_( QString::null ) { viewport()->setBackgroundMode( PaletteBase ); } void FLPixmapView::setPixmap( const QPixmap & pix ) { QApplication::setOverrideCursor( waitCursor ); pixmap_ = pix; if ( !autoScaled_ ) resizeContents( pixmap_.size().width(), pixmap_.size().height() ); viewport()->repaint( false ); QApplication::restoreOverrideCursor(); } void FLPixmapView::drawContents( QPainter * p, int cx, int cy, int cw, int ch ) { p->fillRect( cx, cy, cw, ch, colorGroup().brush( QColorGroup::Background ) ); if ( autoScaled_ ) { QImage img; int newWidth = width() - 2; int newHeight = height() - 2; if ( !pixmapView_.isNull() && pixmapView_.width() == newWidth && pixmapView_.height() == newHeight ) return; img = pixmap_; if ( img.width() > newWidth || img.height() > newHeight ) pixmapView_.convertFromImage( img.scale( newWidth, newHeight, QImage::ScaleMin ) ); else pixmapView_.convertFromImage( img ); if ( !pixmapView_.isNull() ) p->drawPixmap( ( width() / 2 ) - ( pixmapView_.width() / 2 ), ( height() / 2 ) - ( pixmapView_.height() / 2 ), pixmapView_ ); } else { if ( !pixmap_.isNull() ) p->drawPixmap( ( width() / 2 ) - ( pixmap_.width() / 2 ), ( height() / 2 ) - ( pixmap_.height() / 2 ), pixmap_ ); } } void FLPixmapView::previewUrl( const QUrl & u ) { if ( u.isLocalFile() ) { QString path = u.path(); if ( path != path_ ) { path_ = path; QImage img( path_ ); if ( img.isNull() ) return; QPixmap pix; QApplication::setOverrideCursor( waitCursor ); pix.convertFromImage( img ); QApplication::restoreOverrideCursor(); if ( !pix.isNull() ) setPixmap( pix ); } } } void FLPixmapView::clear() { setPixmap( QPixmap() ); } QPixmap FLPixmapView::pixmap() { return pixmap_; } void FLPixmapView::setAutoScaled( const bool autoScaled ) { autoScaled_ = autoScaled; } void FLDateEdit::fix() { if ( !date().isNull() ) QDateEdit::fix(); } FLFieldDB::FLFieldDB( QWidget * parent, const char *name ) : FLWidgetFieldDB( parent, name ), editor_( 0 ), fieldName_( QString::null ), tableName_( QString::null ), actionName_( QString::null ), foreignField_( QString::null ), fieldRelation_( QString::null ), filter_( QString::null ), cursor_( 0 ), cursorAux( 0 ), cursorInit( false ), cursorAuxInit( false ), topWidget_( 0 ), showed( false ), showAlias_( true ), datePopup_( 0 ), dateFrame_( 0 ), datePickerOn_( false ), autoComPopup_( 0 ), autoComFrame_( 0 ), accel_( 0 ), keepDisabled_( false ), editorImg_( 0 ), pbAux_( 0 ), pbAux2_( 0 ), pbAux3_( 0 ), fieldAlias_( QString::null ), showEditor_( true ) { pushButtonDB->setFlat( true ); setFocusProxy( pushButtonDB ); // dpinelo QLocale locale(QLocale::Spanish, QLocale::Spain); locale_ = locale; topWidget_ = topLevelWidget(); if ( topWidget_ && !topWidget_->inherits( "FLFormDB" ) ) { QWidget * topWid = parentWidget(); while ( topWid && !topWid->inherits( "FLFormDB" ) ) topWid = topWid->parentWidget(); topWidget_ = topWid; } if ( !topWidget_ ) { #ifdef FL_DEBUG qWarning( tr( "FLFieldDB : El widget de nivel superior deber ser de la clase FLFormDB o heredar de ella - %1" ).arg( name ) ); #endif } else cursor_ = ::qt_cast( topWidget_ )->cursor(); if ( !name ) setName( "FLFieldDB" ); cursorBackup_ = 0; } bool FLFieldDB::eventFilter( QObject * obj, QEvent * ev ) { if ( ev->type() == QEvent::KeyPress ) { QKeyEvent * k = static_cast( ev ); if ( autoComFrame_ && autoComFrame_->isVisible() ) { if ( k->key() == Key_Down && autoComPopup_ ) { autoComPopup_->setQuickFocus(); return true; } autoComFrame_->hide(); } if ( ::qt_cast( obj ) ) { if ( k->key() == Key_F4 ) { emit keyF4Pressed(); return true; } } else if ( ::qt_cast( obj ) ) { if ( k->key() == Key_F4 ) { emit keyF4Pressed(); return true; } return false; } if ( k->key() == Key_Enter || k->key() == Key_Return ) { focusNextPrevChild( true ); return true; } if ( k->key() == Key_Up ) { focusNextPrevChild( false ); return true; } if ( k->key() == Key_Down ) { focusNextPrevChild( true ); return true; } if ( k->key() == Key_F2 ) { emit keyF2Pressed(); return true; } return false; } else return false; } void FLFieldDB::updateValue( const QDate & d ) { if ( !cursor_ ) return ; bool isNull = ( !d.isValid() || d.isNull() ); if ( !cursor_->bufferIsNull( fieldName_ ) ) { if ( d == cursor_->valueBuffer( fieldName_ ).toDate() ) return ; } else if ( isNull ) return ; if ( isNull ) cursor_->setValueBuffer( fieldName_, QDate() ); else cursor_->setValueBuffer( fieldName_, d ); } void FLFieldDB::updateValue( const QTime & t ) { if ( !cursor_ ) return ; bool isNull = ( !t.isValid() || t.isNull() ); if ( !cursor_->bufferIsNull( fieldName_ ) ) { if ( t == cursor_->valueBuffer( fieldName_ ).toTime() ) return ; } else if ( isNull ) return ; if ( isNull ) cursor_->setValueBuffer( fieldName_, QTime() ); else cursor_->setValueBuffer( fieldName_, t ); } void FLFieldDB::updateValue( bool b ) { if ( !cursor_ ) return ; if ( !cursor_->bufferIsNull( fieldName_ ) ) if ( b == cursor_->valueBuffer( fieldName_ ).toBool() ) return ; cursor_->setValueBuffer( fieldName_, QVariant( b, 0 ) ); } void FLFieldDB::updateValue( const QString & t ) { if ( !cursor_ ) return ; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return ; FLFieldMetaData *field = tMD->field( fieldName_ ); if ( !field ) return ; bool ol = field->hasOptionsList(); QString tAux( t ); if ( ol && editor_ ) tAux = field->optionsList()[ ::qt_cast( editor_ )->currentItem()]; if ( !cursor_->bufferIsNull( fieldName_ ) ) { if ( tAux == cursor_->valueBuffer( fieldName_ ).toString() ) { #ifdef FL_TEST ::qt_cast( qApp )->continueTesting( FLTester::FIELD_READY, this->fieldName() ); #endif return ; } } else if ( tAux.isEmpty() ) return ; QString s( tAux ); if ( field->type() == QVariant::String && !ol ) { if ( s.startsWith( " " ) ) { disconnect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); cursor_->setValueBuffer( fieldName_, s.remove( 0, 1 ) ); connect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); return ; } s.remove( "\\" ); s.replace( "'", "\'" ); } // dpinelo: Si este campo es un campo de tipo numérico, no nos vale el valor de la cadena, ya que seguramente // venga formateado con el locale, lo que dará problemas. Mejor, pedírselo al control de texto que tiene // la función que se encarga de devolvérnoslo adecuadamente if ( field->type() == QVariant::Double || field->type() == QVariant::Int || field->type() == QVariant::UInt) { s = ::qt_cast( editor_ )->text(); } if ( s.isEmpty() ) cursor_->setValueBuffer( fieldName_, QVariant() ); else cursor_->setValueBuffer( fieldName_, s ); if ( isVisible() && hasFocus() && field->type() == QVariant::String && field->length() == s.length() ) focusNextPrevChild( true ); } void FLFieldDB::updateValue() { if ( !cursor_ ) return ; if ( !editor_->isA( "QTextEdit" ) ) return ; QString t = ::qt_cast( editor_ )->text(); if ( !cursor_->bufferIsNull( fieldName_ ) ) { if ( t == cursor_->valueBuffer( fieldName_ ).toString() ) return ; } else if ( t.isEmpty() ) return ; t.remove( "\\" ); t.replace( "'", "\'" ); if ( t.isEmpty() ) cursor_->setValueBuffer( fieldName_, QVariant() ); else cursor_->setValueBuffer( fieldName_, t ); } void FLFieldDB::setTextFormat( const int & f ) { if ( !cursor_ ) return; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return; FLFieldMetaData *field = tMD->field( fieldName_ ); if ( field && editor_ && field->type() == QVariant::StringList ) ::qt_cast( editor_ )->setTextFormat( ( Qt::TextFormat ) f ); } int FLFieldDB::textFormat() const { if ( !cursor_ ) return PlainText; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return PlainText; FLFieldMetaData *field = tMD->field( fieldName_ ); if ( field && editor_ && field->type() == QVariant::StringList ) return ::qt_cast( editor_ )->textFormat(); return PlainText; } void FLFieldDB::setValue( QVariant v ) { if ( !cursor_ ) return; FLTableMetaData * tMD = cursor_->metadata(); if ( !tMD ) return; FLFieldMetaData * field = tMD->field( fieldName_ ); if ( !field ) { #ifdef FL_DEBUG qWarning( tr( "FLFieldDB::setValue() : No existe el campo " ) + fieldName_ ); #endif return; } if ( field->hasOptionsList() ) { int idxItem = -1; if ( v.type() == QVariant::String ) idxItem = field->optionsList().findIndex( v.toString() ); if ( idxItem == -1 ) idxItem = v.toInt(); ::qt_cast( editor_ )->setCurrentItem( idxItem ); updateValue( ::qt_cast( editor_ )->currentText() ); #ifdef FL_TEST ::qt_cast( qApp )->continueTesting( FLTester::FIELD_READY, this->name() ); #endif return; } int type = field->type(); QVariant::Type fltype = FLFieldMetaData::flDecodeType( type ); if ( v.type() == QVariant::Bool && fltype != QVariant::Bool ) { if ( type == QVariant::Double || type == QVariant::Int || type == QVariant::UInt ) v = 0; else v.clear(); } if ( v.type() == QVariant::String && v.toString().isEmpty() ) if ( type == QVariant::Double || type == QVariant::Int || type == QVariant::UInt ) v.clear(); bool isNull = ( !v.isValid() || v.isNull() ); if ( isNull && !field->allowNull() ) { QVariant defVal( field->defaultValue() ); if ( defVal.isValid() && !defVal.isNull() ) { v = defVal; isNull = false; } } v.cast( fltype ); switch ( type ) { case QVariant::UInt: case QVariant::Int: case QVariant::String: if ( editor_ ) { bool doHome = ( ::qt_cast( editor_ )->text().isEmpty() ); ::qt_cast( editor_ )->setText( isNull ? QString() : v.toString() ); if ( doHome ) ::qt_cast( editor_ )->home( false ); } break; case QVariant::StringList: if ( !editor_ ) return ; ::qt_cast( editor_ )->setText( isNull ? QString() : v.toString() ); break; case QVariant::Double: if ( editor_ ) { QString s; if ( !isNull ) s.setNum( v.toDouble(), 'f', field->partDecimal() ); ::qt_cast( editor_ )->setText( s ); } break; case FLFieldMetaData::Serial: if ( editor_ ) ::qt_cast( editor_ )->setValue( isNull ? 0 : v.toUInt() ); break; case QVariant::Pixmap: if ( editorImg_ ) { QCString cs; if ( !isNull ) cs = v.toCString(); if ( cs.isEmpty() ) { editorImg_->clear(); return; } QPixmap pix; if ( !QPixmapCache::find( cs.left( 100 ), pix ) ) { pix.loadFromData( cs ); QPixmapCache::insert( cs.left( 100 ), pix ); } if ( !pix.isNull() ) editorImg_->setPixmap( pix ); else editorImg_->clear(); } break; case QVariant::Date: if ( editor_ ) ::qt_cast( editor_ )->setDate( isNull ? QDate() : v.toDate() ); break; case QVariant::Time: if ( editor_ ) ::qt_cast( editor_ )->setTime( isNull ? QTime() : v.toTime() ); break; case QVariant::Bool: if ( editor_ && !isNull ) ::qt_cast( editor_ )->setChecked( v.toBool() ); break; } #ifdef FL_TEST if ( editor_ ) ::qt_cast( qApp )->continueTesting( FLTester::FIELD_READY, this->name() ); #endif } QVariant FLFieldDB::value() { if ( !cursor_ ) return QVariant(); FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return QVariant(); FLFieldMetaData *field = tMD->field( fieldName_ ); if ( !field ) { #ifdef FL_DEBUG qWarning( tr( "FLFieldDB::value() : No existe el campo " ) + fieldName_ ); #endif return QVariant(); } QVariant v; if ( field->hasOptionsList() ) { v = ::qt_cast( editor_ )->currentItem(); v.cast( QVariant::Int ); return v; } int type = field->type(); QVariant::Type fltype = FLFieldMetaData::flDecodeType( type ); if ( cursor_->bufferIsNull( fieldName_ ) ) if ( type == QVariant::Double || type == QVariant::Int || type == QVariant::UInt ) return 0; switch ( type ) { case QVariant::UInt: case QVariant::Int: case QVariant::Double: case QVariant::String: case QVariant::StringList: if ( editor_ ) { FLLineEdit * ed_ = ::qt_cast( editor_ ); if ( ed_ ) v = ed_->text(); } break; case FLFieldMetaData::Serial: if ( editor_ ) { FLSpinBox * ed_ = ::qt_cast( editor_ ); if ( ed_ ) v = ed_->value(); } break; case QVariant::Pixmap: v = cursor_->valueBuffer( fieldName_ ); break; case QVariant::Date: if ( editor_ ) v = ::qt_cast( editor_ )->date().toString( Qt::ISODate ); break; case QVariant::Time: if ( editor_ ) v = ::qt_cast( editor_ )->time().toString( Qt::ISODate ); break; case QVariant::Bool: if ( editor_ ) v = QVariant( ::qt_cast( editor_ )->isChecked(), 0 ); break; } v.cast( fltype ); return v; } void FLFieldDB::selectAll() { if ( !cursor_ ) return ; if ( !cursor_->metadata() ) return ; FLFieldMetaData * field = cursor_->metadata()->field( fieldName_ ); if ( !field ) return ; switch ( field->type() ) { case QVariant::UInt: case QVariant::Int: case QVariant::Double: case QVariant::String: if ( editor_ ) ::qt_cast( editor_ )->selectAll(); break; case FLFieldMetaData::Serial: if ( editor_ ) ::qt_cast( editor_ )->selectAll(); break; } } void FLFieldDB::initCursor() { if ( !tableName_.isEmpty() && foreignField_.isEmpty() && fieldRelation_.isEmpty() ) { cursorBackup_ = cursor_; if ( cursor_ ) cursor_ = new FLSqlCursor( tableName_, true, cursor_->db()->connectionName(), 0, 0, this ); else { if ( !topWidget_ ) return; cursor_ = new FLSqlCursor( tableName_, true, FLSqlConnections::database()->connectionName(), 0, 0, this ); } cursor_->setModeAccess( FLSqlCursor::BROWSE ); if ( showed ) disconnect( cursor_, SIGNAL( cursorUpdated() ), this, SLOT( refresh() ) ); connect( cursor_, SIGNAL( cursorUpdated() ), this, SLOT( refresh() ) ); return; } else { if ( cursorBackup_ ) { disconnect( cursor_, SIGNAL( cursorUpdated() ), this, SLOT( refresh() ) ); cursor_ = cursorBackup_; cursorBackup_ = 0; } } if ( !cursor_ ) return ; if ( !cursor_->metadata() ) return; if ( tableName_.isEmpty() || foreignField_.isEmpty() || fieldRelation_.isEmpty() ) { if ( !foreignField_.isEmpty() && !fieldRelation_.isEmpty() ) { if ( showed ) disconnect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refresh( const QString & ) ) ); connect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refresh( const QString & ) ) ); } if ( showed ) { disconnect( cursor_, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); disconnect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); } connect( cursor_, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); connect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); return ; } if ( !cursorAux ) { if ( cursorAuxInit ) return ; FLTableMetaData *tMD = cursor_->db()->manager()->metadata( tableName_ ); if ( !tMD ) return ; disconnect( cursor_, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); disconnect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); cursorAux = cursor_; QString curName( cursor_->metadata()->name() ); FLRelationMetaData * rMD = tMD->relation( fieldRelation_, foreignField_, curName ); if ( !rMD ) { bool checkIntegrity = false; FLRelationMetaData * testM1 = cursor_->metadata()->relation( foreignField_, fieldRelation_, tableName_ ); if ( testM1 ) checkIntegrity = ( testM1->cardinality() == FLRelationMetaData::RELATION_M1 ); FLFieldMetaData * fMD = tMD->field( fieldRelation_ ); if ( fMD ) { rMD = new FLRelationMetaData( curName, foreignField_, FLRelationMetaData::RELATION_1M, false, false, checkIntegrity ); fMD->addRelationMD( rMD ); #ifdef FL_DEBUG qWarning( tr( "FLFieldDB : La relación entre la tabla del formulario ( %1 ) y la tabla ( %2 ) de este campo ( %3 ) no existe, pero sin embargo se han indicado los campos de relación( %4, %5 )" ) .arg( curName ).arg( tableName_ ).arg( fieldName_ ).arg( fieldRelation_ ).arg( foreignField_ ) ); qWarning( tr( "FLFieldDB : Creando automáticamente %1.%2 --1M--> %3.%4" ) .arg( tableName_ ).arg( fieldRelation_ ).arg( curName ).arg( foreignField_ ) ); #endif } #ifdef FL_DEBUG else { qWarning( tr( "FLFieldDB : El campo ( %1 ) indicado en la propiedad fieldRelation no se encuentra en la tabla ( %2 )" ) .arg( fieldRelation_ ).arg( tableName_ ) ); } #endif } cursor_ = new FLSqlCursor( tableName_, false, cursor_->db()->connectionName(), cursorAux, rMD, this ); if ( !cursor_ ) { cursor_ = cursorAux; if ( showed ) { disconnect( cursor_, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); disconnect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); } connect( cursor_, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); connect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); cursorAux = 0; return ; } else { if ( showed ) disconnect( cursorAux, SIGNAL( newBuffer() ), this, SLOT( setNoShowed() ) ); connect( cursorAux, SIGNAL( newBuffer() ), this, SLOT( setNoShowed() ) ); } cursor_->setModeAccess( FLSqlCursor::BROWSE ); if ( showed ) { disconnect( cursor_, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); disconnect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); } connect( cursor_, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); connect( cursor_, SIGNAL( bufferChanged( const QString & ) ), this, SLOT( refreshQuick( const QString & ) ) ); cursorAuxInit = true; cursor_->append( cursor_->db()->db()->recordInfo( tableName_ ).find( fieldName_ ) ); cursor_->append( cursor_->db()->db()->recordInfo( tableName_ ).find( fieldRelation_ ) ); } } void FLFieldDB::initEditor() { if ( !cursor_ ) return ; if ( editor_ ) { delete editor_; editor_ = 0; } if ( editorImg_ ) { delete editorImg_; editorImg_ = 0; } FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return ; FLFieldMetaData *field = tMD->field( fieldName_ ); if ( !field ) return ; int type = field->type(); int len = field->length(); int partInteger = field->partInteger(); int partDecimal = field->partDecimal(); QString rX = field->regExpValidator(); bool ol = field->hasOptionsList(); QString rt; if ( field->relationM1() ) if ( field->relationM1()->foreignTable() != tMD->name() ) rt = field->relationM1()->foreignTable(); bool hasPushButtonDB = false; fieldAlias_ = field->alias(); textLabelDB->setFont( qApp->font() ); if ( showAlias_ && type != QVariant::Pixmap && type != QVariant::Bool ) textLabelDB->setText( fieldAlias_ ); else textLabelDB->hide(); if ( !rt.isEmpty() ) { hasPushButtonDB = true; FLTableMetaData * tmd = cursor_->db()->manager()->metadata( rt ); if ( !tmd ) pushButtonDB->setDisabled( true ); } initMaxSize_ = maximumSize(); initMinSize_ = minimumSize(); switch ( type ) { case QVariant::UInt: case QVariant::Int: case QVariant::Double: case QVariant::String: if ( ol ) { editor_ = new QComboBox( true, this, "editor" ); ::qt_cast( editor_ )->setEditable( false ); ::qt_cast( editor_ )->setAutoCompletion( true ); ::qt_cast( editor_ )->setFont( qApp->font() ); QStringList olTranslated; QStringList olNoTranslated( field->optionsList() ); int countOl = olNoTranslated.count(); for ( int i = 0; i < countOl; ++i ) olTranslated << FLUtil::translate( "MetaData", olNoTranslated[ i ] ); ::qt_cast( editor_ )->insertStringList( olTranslated ); editor_->installEventFilter( this ); if ( showed ) disconnect( editor_, SIGNAL( activated( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); connect( editor_, SIGNAL( activated( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); } else { editor_ = new FLLineEdit( this, "editor" ); ::qt_cast( editor_ )->setFont( qApp->font() ); ::qt_cast( editor_ )->type = type; // dpinelo ::qt_cast( editor_ )->partDecimal = partDecimal; editor_->installEventFilter( this ); if ( type == QVariant::Double ) { ::qt_cast( editor_ )->setValidator( new FLDoubleValidator( 0, pow( 10, partInteger ) - 1, partDecimal, editor_ ) ); ::qt_cast( editor_ )->setAlignment( Qt::AlignRight ); } else { if ( type == QVariant::UInt || type == QVariant::Int ) { if ( type == QVariant::UInt ) ::qt_cast( editor_ )->setValidator( new FLUIntValidator( 0, ( ( int ) pow( 10, partInteger ) - 1 ), editor_ ) ); else ::qt_cast( editor_ )->setValidator( new FLIntValidator( ( ( int )( pow( 10, partInteger ) - 1 ) *( -1 ) ), ( ( int ) pow( 10, partInteger ) - 1 ), editor_ ) ); ::qt_cast( editor_ )->setAlignment( Qt::AlignRight ); } else { ::qt_cast( editor_ )->setMaxLength( len ); if ( !rX.isEmpty() ) { QRegExp r( rX ); ::qt_cast( editor_ )->setValidator( new QRegExpValidator( r, editor_ ) ); } ::qt_cast( editor_ )->setAlignment( Qt::AlignLeft ); connect( this, SIGNAL( keyF4Pressed() ), this, SLOT( toggleAutoCompletion() ) ); QToolTip::add( editor_, tr( "Para completado automático pulsar F4" ) ); QWhatsThis::add( editor_, tr( "Para completado automático pulsar F4" ) ); } } if ( showed ) { disconnect( editor_, SIGNAL( lostFocus() ), this, SLOT( emitLostFocus() ) ); disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( emitTextChanged( const QString & ) ) ); } connect( editor_, SIGNAL( lostFocus() ), this, SLOT( emitLostFocus() ) ); connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( emitTextChanged( const QString & ) ) ); if ( hasPushButtonDB ) { if ( showed ) disconnect( this, SIGNAL( keyF2Pressed() ), pushButtonDB, SLOT( animateClick() ) ); connect( this, SIGNAL( keyF2Pressed() ), pushButtonDB, SLOT( animateClick() ) ); } } editor_-> setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, ( QSizePolicy::SizeType ) 0, editor_->sizePolicy().hasHeightForWidth() ) ); FLWidgetFieldDBLayout->addWidget( editor_ ); break; case FLFieldMetaData::Serial: editor_ = new FLSpinBox( this, "editor" ); ::qt_cast( editor_ )->setFont( qApp->font() ); ::qt_cast( editor_ )->setMaxValue( ( ( int ) pow( 10, partInteger ) - 1 ) ); editor_-> setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, ( QSizePolicy::SizeType ) 0, editor_->sizePolicy().hasHeightForWidth() ) ); FLWidgetFieldDBLayout->addWidget( editor_ ); editor_->installEventFilter( this ); if ( showed ) disconnect( editor_, SIGNAL( valueChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); connect( editor_, SIGNAL( valueChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case QVariant::Pixmap: if ( cursor_->modeAccess() != FLSqlCursor::BROWSE ) { FLWidgetFieldDBLayout->setDirection( QBoxLayout::Down ); editorImg_ = new FLPixmapView( this ); editorImg_->setFocusPolicy( QWidget::NoFocus ); editorImg_->setSizePolicy( sizePolicy() ); editorImg_->setMaximumSize( initMaxSize_ ); editorImg_->setMinimumSize( initMinSize_ ); editorImg_->setAutoScaled( true ); FLWidgetFieldDBLayout->addWidget( editorImg_ ); if ( !pbAux3_ ) { QSpacerItem * spcBut = new QSpacerItem( 20, 20, QSizePolicy::Expanding, QSizePolicy::Minimum ); lytButtons->addItem( spcBut ); pbAux3_ = new QPushButton( this, "pbAux3" ); pbAux3_->setSizePolicy( QSizePolicy( QSizePolicy::Fixed, QSizePolicy::Fixed, pbAux3_->sizePolicy().hasHeightForWidth() ) ); pbAux3_->setMinimumSize( QSize( 22, 22 ) ); pbAux3_->setFocusPolicy( QPushButton::NoFocus ); pbAux3_->setIconSet( QIconSet( QPixmap::fromMimeSource( "file_open.png" ) ) ); pbAux3_->setText( QString::null ); QToolTip::add( pbAux3_, tr( "Abrir fichero de imagen" ) ); QWhatsThis::add( pbAux3_, tr( "Abrir fichero de imagen" ) ); lytButtons->addWidget( pbAux3_ ); if ( showed ) disconnect( pbAux3_, SIGNAL( clicked() ), this, SLOT( searchPixmap() ) ); connect( pbAux3_, SIGNAL( clicked() ), this, SLOT( searchPixmap() ) ); if ( !hasPushButtonDB ) { if ( showed ) disconnect( this, SIGNAL( keyF2Pressed() ), pbAux3_ , SLOT( animateClick() ) ); connect( this, SIGNAL( keyF2Pressed() ), pbAux3_ , SLOT( animateClick() ) ); pbAux3_->setFocusPolicy( QPushButton::StrongFocus ); pbAux3_->installEventFilter( this ); } } if ( !pbAux_ ) { pbAux_ = new QPushButton( this, "pbAux" ); pbAux_->setSizePolicy( QSizePolicy( QSizePolicy::Fixed, QSizePolicy::Fixed, pbAux_->sizePolicy().hasHeightForWidth() ) ); pbAux_->setMinimumSize( QSize( 22, 22 ) ); pbAux_->setFocusPolicy( QPushButton::NoFocus ); pbAux_->setIconSet( QIconSet( QPixmap::fromMimeSource( "eraser.png" ) ) ); pbAux_->setText( QString::null ); QToolTip::add( pbAux_, tr( "Borrar imagen" ) ); QWhatsThis::add( pbAux_, tr( "Borrar imagen" ) ); lytButtons->addWidget( pbAux_ ); if ( showed ) disconnect( pbAux_, SIGNAL( clicked() ), this, SLOT( clearPixmap() ) ); connect( pbAux_, SIGNAL( clicked() ), this, SLOT( clearPixmap() ) ); } if ( !pbAux2_ ) { pbAux2_ = new QPushButton( this, "pbAux2" ); QPopupMenu * savepixmap = new QPopupMenu( pbAux2_ ); QStrList fmt = QImage::outputFormats(); int id = 0; for ( const char* f = fmt.first(); f; f = fmt.next(), ++id ) savepixmap->insertItem( f, id ); pbAux2_->setPopup( savepixmap ); pbAux2_->setSizePolicy( QSizePolicy( QSizePolicy::Fixed, QSizePolicy::Fixed, pbAux2_->sizePolicy().hasHeightForWidth() ) ); pbAux2_->setMinimumSize( QSize( 22, 22 ) ); pbAux2_->setFocusPolicy( QPushButton::NoFocus ); pbAux2_->setIconSet( QIconSet( QPixmap::fromMimeSource( "filesaveas.png" ) ) ); pbAux2_->setText( QString::null ); QToolTip::add( pbAux2_, tr( "Guardar imagen como..." ) ); QWhatsThis::add( pbAux_, tr( "Guardar imagen como.." ) ); lytButtons->addWidget( pbAux2_ ); if ( showed ) disconnect( savepixmap, SIGNAL( activated( int ) ), this, SLOT( savePixmap( int ) ) ); connect( savepixmap, SIGNAL( activated( int ) ), this, SLOT( savePixmap( int ) ) ); } if ( hasPushButtonDB ) pushButtonDB->installEventFilter( this ); } break; case QVariant::Date: editor_ = new FLDateEdit( this, "editor" ); ::qt_cast( editor_ )->setFont( qApp->font() ); editor_-> setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, ( QSizePolicy::SizeType ) 0, editor_->sizePolicy().hasHeightForWidth() ) ); FLWidgetFieldDBLayout->insertWidget( 1, editor_ ); ::qt_cast( editor_ )->setOrder( QDateEdit::DMY ); ::qt_cast( editor_ )->setAutoAdvance( true ); ::qt_cast( editor_ )->setSeparator( "-" ); editor_->installEventFilter( this ); if ( cursor_->modeAccess() != FLSqlCursor::BROWSE ) { if ( !pbAux_ ) { pbAux_ = new QPushButton( this, "pbAux" ); pbAux_->setFlat( true ); pbAux_->setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType )0, ( QSizePolicy::SizeType )0, 0, 0, pbAux_->sizePolicy().hasHeightForWidth() ) ); pbAux_->setMinimumSize( QSize( 25, 25 ) ); pbAux_->setMaximumSize( QSize( 25, 25 ) ); pbAux_->setFocusPolicy( QPushButton::NoFocus ); pbAux_->setIconSet( QIconSet( QPixmap::fromMimeSource( "date.png" ) ) ); pbAux_->setText( QString::null ); QToolTip::add( pbAux_, tr( "Seleccionar fecha (F2)" ) ); QWhatsThis::add( pbAux_, tr( "Seleccionar fecha (F2)" ) ); lytButtons->addWidget( pbAux_ ); if ( showed ) { disconnect( pbAux_, SIGNAL( clicked() ), this, SLOT( toggleDatePicker() ) ); disconnect( this, SIGNAL( keyF2Pressed() ), pbAux_, SLOT( animateClick() ) ); } connect( pbAux_, SIGNAL( clicked() ), this, SLOT( toggleDatePicker() ) ); connect( this, SIGNAL( keyF2Pressed() ), pbAux_, SLOT( animateClick() ) ); } } if ( showed ) disconnect( editor_, SIGNAL( valueChanged( const QDate & ) ), this, SLOT( updateValue( const QDate & ) ) ); connect( editor_, SIGNAL( valueChanged( const QDate & ) ), this, SLOT( updateValue( const QDate & ) ) ); if ( cursor_->modeAccess() == FLSqlCursor::INSERT && !field->allowNull() ) { QVariant defVal( field->defaultValue() ); if ( !defVal.isValid() || defVal.isNull() ) ::qt_cast( editor_ )->setDate( QDate::currentDate() ); else ::qt_cast( editor_ )->setDate( defVal.toDate() ); } break; case QVariant::Time: { editor_ = new QTimeEdit( this, "editor" ); ::qt_cast( editor_ )->setFont( qApp->font() ); ::qt_cast( editor_ )->setAutoAdvance( true ); editor_-> setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, ( QSizePolicy::SizeType ) 0, editor_->sizePolicy().hasHeightForWidth() ) ); FLWidgetFieldDBLayout->addWidget( editor_ ); editor_->installEventFilter( this ); if ( showed ) disconnect( editor_, SIGNAL( valueChanged( const QTime & ) ), this, SLOT( updateValue( const QTime & ) ) ); connect( editor_, SIGNAL( valueChanged( const QTime & ) ), this, SLOT( updateValue( const QTime & ) ) ); if ( cursor_->modeAccess() == FLSqlCursor::INSERT && !field->allowNull() ) { QVariant defVal( field->defaultValue() ); if ( !defVal.isValid() || defVal.isNull() ) ::qt_cast( editor_ )->setTime( QTime::currentTime() ); else ::qt_cast( editor_ )->setTime( defVal.toTime() ); } } break; case QVariant::StringList: editor_ = new QTextEdit( this, "editor" ); ::qt_cast( editor_ )->setFont( qApp->font() ); ::qt_cast( editor_ )->setTabChangesFocus( true ); editor_->setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, QSizePolicy::Expanding, editor_->sizePolicy().hasHeightForWidth() ) ); FLWidgetFieldDBLayout->addWidget( editor_ ); editor_->installEventFilter( this ); if ( showed ) disconnect( editor_, SIGNAL( textChanged() ), this, SLOT( updateValue() ) ); connect( editor_, SIGNAL( textChanged() ), this, SLOT( updateValue() ) ); connect( this, SIGNAL( keyF4Pressed() ), this, SLOT( toggleAutoCompletion() ) ); QToolTip::add( editor_, tr( "Para completado automático pulsar F4" ) ); QWhatsThis::add( editor_, tr( "Para completado automático pulsar F4" ) ); break; case QVariant::Bool: editor_ = new QCheckBox( this, "editor" ); ::qt_cast( editor_ )->setText( tMD->fieldNameToAlias( fieldName_ ) ); ::qt_cast( editor_ )->setFont( qApp->font() ); editor_->installEventFilter( this ); editor_->setMinimumWidth( fontMetrics().width( tMD->fieldNameToAlias( fieldName_ ) ) + fontMetrics().maxWidth() * 2 ); editor_->setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, ( QSizePolicy::SizeType ) 0, editor_->sizePolicy().hasHeightForWidth() ) ); FLWidgetFieldDBLayout->addWidget( editor_ ); if ( showed ) disconnect( editor_, SIGNAL( toggled( bool ) ), this, SLOT( updateValue( bool ) ) ); connect( editor_, SIGNAL( toggled( bool ) ), this, SLOT( updateValue( bool ) ) ); break; } if ( editor_ ) { editor_->setFocusPolicy( QWidget::StrongFocus ); setFocusProxy( editor_ ); setTabOrder( pushButtonDB, editor_ ); if ( hasPushButtonDB ) { pushButtonDB->setFocusPolicy( QWidget::NoFocus ); QToolTip::add( editor_, tr( "Para buscar un valor en la tabla relacionada pulsar F2" ) ); QWhatsThis::add( editor_, tr( "Para buscar un valor en la tabla relacionada pulsar F2" ) ); } } else if ( editorImg_ ) { editorImg_->setFocusPolicy( QWidget::NoFocus ); if ( hasPushButtonDB ) pushButtonDB->setFocusPolicy( QWidget::StrongFocus ); } if ( !hasPushButtonDB ) pushButtonDB->hide(); if ( initMaxSize_.width() < 80 ) setShowEditor( false ); else setShowEditor( showEditor_ ); } void FLFieldDB::searchValue() { if ( !cursor_ ) return ; if ( fieldName_.isEmpty() ) return ; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return ; FLFieldMetaData *field = tMD->field( fieldName_ ); if ( !field ) return ; if ( !field->relationM1() ) { #ifdef FL_DEBUG qWarning( "FLFieldDB : " + tr( "El campo de búsqueda debe tener una relación M1" ) ); #endif return ; } FLFormSearchDB *f = 0; FLSqlCursor *c = 0; FLFieldMetaData *fMD = field->associatedField(); FLAction *a = 0; if ( fMD ) { if ( !fMD->relationM1() ) { #ifdef FL_DEBUG qWarning( "FLFieldDB : " + tr( "El campo asociado debe tener una relación M1" ) ); #endif return ; } QVariant v = cursor_->valueBuffer( fMD->name() ); if ( v.toString().isEmpty() ) { QMessageBox::warning( qApp->focusWidget(), tr( "Aviso" ), tr( "Debe indicar un valor para %1" ).arg( fMD->alias() ), QMessageBox::Ok, 0, 0 ); return ; } c = new FLSqlCursor( fMD->relationM1()->foreignTable(), true, cursor_->db()->connectionName() ); c->select( cursor_->db()->manager()->formatAssignValue( fMD->relationM1()->foreignField(), fMD, v, true ) ); if ( c->size() > 0 ) c->next(); if ( actionName_.isEmpty() ) a = cursor_->db()->manager()->action( field->relationM1()->foreignTable() ); else { a = cursor_->db()->manager()->action( actionName_ ); a->setTable( field->relationM1()->foreignTable() ); } f = new FLFormSearchDB( c, a->name(), topWidget_ ); } else { if ( actionName_.isEmpty() ) { a = cursor_->db()->manager()->action( field->relationM1()->foreignTable() ); if ( !a ) return ; } else { a = cursor_->db()->manager()->action( actionName_ ); if ( !a ) return ; a->setTable( field->relationM1()->foreignTable() ); } f = new FLFormSearchDB( a->name(), topWidget_ ); } f->setMainWidget(); QObjectList * lObjs = f->queryList( "FLTableDB" ); QObject *obj = lObjs->first(); delete lObjs; if ( fMD && obj ) { ::qt_cast( obj )->setTableName( field->relationM1()->foreignTable() ); ::qt_cast( obj )->setFieldRelation( field->associatedFieldFilterTo() ); ::qt_cast( obj )->setForeignField( fMD->relationM1()->foreignField() ); if ( fMD->relationM1()->foreignTable() == tMD->name() ) ::qt_cast( obj )->setReadOnly( true ); } f->setFilter( filter_ ); if ( f->mainWidget() ) { QVariant curValue( value() ); if ( field->type() == QVariant::String && !curValue.toString().isEmpty() && obj ) { ::qt_cast( obj )->setInitSearch( curValue.toString() ); ::qt_cast( obj )->putFirstCol( field->relationM1()->foreignField() ); } QVariant v = f->exec( field->relationM1()->foreignField() ); if ( v.isValid() && !v.isNull() ) { setValue( QVariant() ); setValue( v ); } } f->close(); if ( c ) { disconnect( c, 0, 0, 0 ); delete c; } } void FLFieldDB::searchPixmap() { if ( !cursor_ || !editorImg_ ) return ; if ( fieldName_.isEmpty() ) return ; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return ; FLFieldMetaData *field = tMD->field( fieldName_ ); if ( !field ) return ; if ( field->type() == QVariant::Pixmap ) { QFileDialog * fd = new QFileDialog( this, 0, true ); FLPixmapView *p = new FLPixmapView( fd ); p->setAutoScaled( true ); fd->setContentsPreviewEnabled( TRUE ); fd->setContentsPreview( p, p ); fd->setPreviewMode( QFileDialog::Contents ); fd->setCaption( tr( "Elegir archivo" ) ); fd->setFilter( "*" ); QString filename; if ( fd->exec() == QDialog::Accepted ) filename = fd->selectedFile(); if ( filename.isEmpty() ) return; setPixmap( filename ); } } void FLFieldDB::setPixmap( const QString &filename ) { QImage img( filename ); if ( img.isNull() ) return; QApplication::setOverrideCursor( waitCursor ); QPixmap pix; QCString s; QBuffer buffer( s ); pix.convertFromImage( img ); QApplication::restoreOverrideCursor(); if ( pix.isNull() ) return; editorImg_->setPixmap( pix ); QApplication::setOverrideCursor( waitCursor ); buffer.open( IO_WriteOnly ); pix.save( &buffer, "XPM" ); QApplication::restoreOverrideCursor(); if ( s.isEmpty() ) return; if ( !QPixmapCache::find( s.left( 100 ) ) ) QPixmapCache::insert( s.left( 100 ), pix ); updateValue( QString( s ) ); } void FLFieldDB::setFilter( const QString & f ) { filter_ = f; } QString FLFieldDB::filter() const { return filter_; } QString FLFieldDB::fieldName() const { return fieldName_; } QString FLFieldDB::actionName() const { return actionName_; } QString FLFieldDB::tableName() const { return tableName_; } QString FLFieldDB::foreignField() const { return foreignField_; } QString FLFieldDB::fieldRelation() const { return fieldRelation_; } QString FLFieldDB::fieldAlias() const { return fieldAlias_; } void FLFieldDB::refreshQuick( const QString & fN ) { if ( fN.isEmpty() || fN != fieldName_ || !cursor_ ) return ; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return ; FLFieldMetaData *field = tMD->field( fieldName_ ); if ( !field ) return ; if ( field->outTransaction() ) return ; int type = field->type(); if ( type != QVariant::Pixmap && !editor_ ) return; QVariant v( cursor_->valueBuffer( fieldName_ ) ); bool null = cursor_->bufferIsNull( fieldName_ ); int partDecimal = field->partDecimal(); bool ol = field->hasOptionsList(); switch ( type ) { case QVariant::Double: if ( v.toDouble() == ::qt_cast( editor_ )->text().toDouble() ) return ; disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); { QString s; if ( !null ) s.setNum( v.toDouble(), 'f', partDecimal ); ::qt_cast( editor_ )->setText( s ); } connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case QVariant::String: { bool doHome = false; if ( ol ) { if ( v.toString() == ::qt_cast( editor_ )->currentText() ) return ; } else { if ( v.toString() == ::qt_cast( editor_ )->text() ) return ; doHome = ( ::qt_cast( editor_ )->text().isEmpty() ); } disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); if ( v.isValid() && !v.isNull() ) { if ( ol ) ::qt_cast( editor_ )->setCurrentItem( field->optionsList().findIndex( v.toString() ) ); else ::qt_cast( editor_ )->setText( v.toString() ); } else { if ( ol ) ::qt_cast( editor_ )->setCurrentItem( 0 ); else ::qt_cast( editor_ )->setText( QString::null ); } if ( !ol && doHome ) ::qt_cast( editor_ )->home( false ); connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); } break; case QVariant::UInt: if ( v.toUInt() == ::qt_cast( editor_ )->text().toUInt() ) return ; disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); { QString s; if ( !null ) s.setNum( v.toUInt() ); ::qt_cast( editor_ )->setText( s ); } connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case QVariant::Int: if ( v.toInt() == ::qt_cast( editor_ )->text().toInt() ) return ; disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); { QString s; if ( !null ) s.setNum( v.toInt() ); ::qt_cast( editor_ )->setText( s ); } connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case FLFieldMetaData::Serial: if ( v.toInt() == ::qt_cast( editor_ )->value() ) return ; disconnect( editor_, SIGNAL( valueChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); ::qt_cast( editor_ )->setValue( v.toInt() ); connect( editor_, SIGNAL( valueChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case QVariant::Pixmap: { if ( !editorImg_ ) { editorImg_ = new FLPixmapView( this ); editorImg_->setFocusPolicy( QWidget::NoFocus ); editorImg_->setSizePolicy( sizePolicy() ); editorImg_->setMaximumSize( initMaxSize_ ); editorImg_->setMinimumSize( initMinSize_ ); editorImg_->setAutoScaled( true ); FLWidgetFieldDBLayout->addWidget( editorImg_ ); if ( field->visible() ) editorImg_->show(); } QCString cs; if ( !null ) cs = v.toCString(); if ( cs.isEmpty() ) { editorImg_->clear(); return ; } QPixmap pix; if ( !QPixmapCache::find( cs.left( 100 ), pix ) ) { pix.loadFromData( cs ); QPixmapCache::insert( cs.left( 100 ), pix ); } if ( pix.isNull() ) editorImg_->clear(); else editorImg_->setPixmap( pix ); } break; case QVariant::Date: if ( v.toDate() == ::qt_cast( editor_ )->date() ) return ; disconnect( editor_, SIGNAL( valueChanged( const QDate & ) ), this, SLOT( updateValue( const QDate & ) ) ); ::qt_cast( editor_ )->setDate( v.toDate() ); connect( editor_, SIGNAL( valueChanged( const QDate & ) ), this, SLOT( updateValue( const QDate & ) ) ); break; case QVariant::Time: if ( v.toTime() == ::qt_cast( editor_ )->time() ) return ; disconnect( editor_, SIGNAL( valueChanged( const QTime & ) ), this, SLOT( updateValue( const QTime & ) ) ); ::qt_cast( editor_ )->setTime( v.toTime() ); connect( editor_, SIGNAL( valueChanged( const QTime & ) ), this, SLOT( updateValue( const QTime & ) ) ); break; case QVariant::StringList: if ( v.toString() == ::qt_cast( editor_ )->text() ) return ; disconnect( editor_, SIGNAL( textChanged() ), this, SLOT( updateValue() ) ); ::qt_cast( editor_ )->setText( v.toString() ); connect( editor_, SIGNAL( textChanged() ), this, SLOT( updateValue() ) ); break; case QVariant::Bool: if ( v.toBool() == ::qt_cast( editor_ )->isChecked() ) return ; disconnect( editor_, SIGNAL( toggled( bool ) ), this, SLOT( updateValue( bool ) ) ); ::qt_cast( editor_ )->setChecked( v.toBool() ); connect( editor_, SIGNAL( toggled( bool ) ), this, SLOT( updateValue( bool ) ) ); break; } } void FLFieldDB::refresh( const QString & fN ) { if ( !cursor_ ) return ; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return ; QVariant v; bool null; if ( fN.isEmpty() ) { v = cursor_->valueBuffer( fieldName_ ); null = cursor_->bufferIsNull( fieldName_ ); } else { if ( !cursorAux && fN.lower() == fieldRelation_.lower() ) { if ( cursor_->bufferIsNull( fieldRelation_ ) ) return ; FLFieldMetaData *field = tMD->field( fieldRelation_ ); FLTableMetaData *tmd = cursor_->db()->manager()->metadata( field->relationM1()->foreignTable() ); if ( !tmd ) return ; if ( topWidget_ && !topWidget_->isShown() && cursor_->modeAccess() != FLSqlCursor::INSERT ) return ; if ( !field ) return ; if ( !field->relationM1() ) { #ifdef FL_DEBUG qWarning( "FLFieldDB : " + tr( "El campo de la relación debe estar relacionado en M1" ) ); #endif return ; } QVariant v = cursor_->valueBuffer( fieldRelation_ ); FLSqlQuery q( 0, cursor_->db()->connectionName() ); q.setForwardOnly( true ); q.setTablesList( field->relationM1()->foreignTable() ); q.setSelect( foreignField_ + "," + field->relationM1()->foreignField() ); q.setFrom( field->relationM1()->foreignTable() ); if ( filter_.isEmpty() ) q.setWhere( cursor_->db()->manager()->formatAssignValue( field->relationM1()->foreignField(), field, v, true ) ); else q.setWhere( filter_ + " AND " + cursor_->db()->manager()->formatAssignValue( field->relationM1()->foreignField(), field, v, true ) ); if ( q.exec() && q.next() ) { QVariant v0( q.value( 0 ) ), v1( q.value( 1 ) ); if ( v0 != value() ) setValue( v0 ); if ( v1 != v ) cursor_->setValueBuffer( fieldRelation_, v1 ); } } return ; } FLFieldMetaData *field = tMD->field( fieldName_ ); if ( !field ) return ; int type = field->type(); if ( type != QVariant::Pixmap && !editor_ ) return; int modeAccess = cursor_->modeAccess(); int partDecimal = field->partDecimal(); bool ol = field->hasOptionsList(); setDisabled( keepDisabled_ || cursor_->fieldDisabled( fieldName_ ) || ( modeAccess == FLSqlCursor::EDIT && ( field->isPrimaryKey() || tMD->fieldListOfCompoundKey( fieldName_ ) ) ) || !field->editable() || modeAccess == FLSqlCursor::BROWSE ); switch ( type ) { case QVariant::Double: disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); { QString s; if ( !null ) s.setNum( v.toDouble(), 'f', partDecimal ); ::qt_cast( editor_ )->setText( s ); } connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case QVariant::String: { bool doHome = false; if ( !ol ) doHome = ( ::qt_cast( editor_ )->text().isEmpty() ); disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); if ( !null ) { if ( ol ) ::qt_cast( editor_ )->setCurrentItem( field->optionsList().findIndex( v.toString() ) ); else ::qt_cast( editor_ )->setText( v.toString() ); } else { if ( ol ) ::qt_cast( editor_ )->setCurrentItem( 0 ); else ::qt_cast( editor_ )->setText( QString::null ); } if ( !ol && doHome ) ::qt_cast( editor_ )->home( false ); connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); } break; case QVariant::UInt: disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); { QString s; if ( !null ) s.setNum( v.toUInt() ); ::qt_cast( editor_ )->setText( s ); } connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case QVariant::Int: disconnect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); { QString s; if ( !null ) s.setNum( v.toInt() ); ::qt_cast( editor_ )->setText( s ); } connect( editor_, SIGNAL( textChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case FLFieldMetaData::Serial: disconnect( editor_, SIGNAL( valueChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); ::qt_cast( editor_ )->setValue( 0 ); connect( editor_, SIGNAL( valueChanged( const QString & ) ), this, SLOT( updateValue( const QString & ) ) ); break; case QVariant::Pixmap: if ( !editorImg_ ) { editorImg_ = new FLPixmapView( this ); editorImg_->setFocusPolicy( QWidget::NoFocus ); editorImg_->setSizePolicy( sizePolicy() ); editorImg_->setMaximumSize( initMaxSize_ ); editorImg_->setMinimumSize( initMinSize_ ); editorImg_->setAutoScaled( true ); FLWidgetFieldDBLayout->addWidget( editorImg_ ); if ( field->visible() ) editorImg_->show(); } if ( modeAccess == FLSqlCursor::BROWSE ) setDisabled( false ); if ( field->visible() ) { QCString cs; if ( !null ) cs = v.toCString(); if ( cs.isEmpty() ) { editorImg_->clear(); return ; } QPixmap pix; if ( !QPixmapCache::find( cs.left( 100 ), pix ) ) { pix.loadFromData( cs ); QPixmapCache::insert( cs.left( 100 ), pix ); } if ( !pix.isNull() ) { editorImg_->setPixmap( pix ); } else editorImg_->clear(); } if ( modeAccess == FLSqlCursor::BROWSE ) pushButtonDB->setDisabled( true ); break; case QVariant::Date: if ( cursor_->modeAccess() == FLSqlCursor::INSERT && null && !field->allowNull() ) { QVariant defVal( field->defaultValue() ); if ( !defVal.isValid() || defVal.isNull() ) ::qt_cast( editor_ )->setDate( QDate::currentDate() ); else ::qt_cast( editor_ )->setDate( defVal.toDate() ); } else { disconnect( editor_, SIGNAL( valueChanged( const QDate & ) ), this, SLOT( updateValue( const QDate & ) ) ); ::qt_cast( editor_ )->setDate( v.toDate() ); connect( editor_, SIGNAL( valueChanged( const QDate & ) ), this, SLOT( updateValue( const QDate & ) ) ); } break; case QVariant::Time: if ( cursor_->modeAccess() == FLSqlCursor::INSERT && null && !field->allowNull() ) { QVariant defVal( field->defaultValue() ); if ( !defVal.isValid() || defVal.isNull() ) ::qt_cast( editor_ )->setTime( QTime::currentTime() ); else ::qt_cast( editor_ )->setTime( defVal.toTime() ); } else { disconnect( editor_, SIGNAL( valueChanged( const QTime & ) ), this, SLOT( updateValue( const QTime & ) ) ); ::qt_cast( editor_ )->setTime( v.toTime() ); connect( editor_, SIGNAL( valueChanged( const QTime & ) ), this, SLOT( updateValue( const QTime & ) ) ); } break; case QVariant::StringList: disconnect( editor_, SIGNAL( textChanged() ), this, SLOT( updateValue() ) ); ::qt_cast( editor_ )->setText( v.toString() ); connect( editor_, SIGNAL( textChanged() ), this, SLOT( updateValue() ) ); break; case QVariant::Bool: disconnect( editor_, SIGNAL( toggled( bool ) ), this, SLOT( updateValue( bool ) ) ); ::qt_cast( editor_ )->setChecked( v.toBool() ); connect( editor_, SIGNAL( toggled( bool ) ), this, SLOT( updateValue( bool ) ) ); break; } if ( !field->visible() ) { if ( editor_ ) editor_->hide(); else if ( editorImg_ ) editorImg_->hide(); setDisabled( true ); } } void FLFieldDB::setTableName( const QString & fT ) { tableName_ = fT; if ( showed ) { if ( topWidget_ ) { initCursor(); initEditor(); } else initFakeEditor(); } } void FLFieldDB::setForeignField( const QString & fN ) { foreignField_ = fN; if ( showed ) { if ( topWidget_ ) { initCursor(); initEditor(); } else initFakeEditor(); } } void FLFieldDB::setFieldRelation( const QString & fN ) { fieldRelation_ = fN; if ( showed ) { if ( topWidget_ ) { initCursor(); initEditor(); } else initFakeEditor(); } } void FLFieldDB::setFieldAlias( const QString & alias ) { if ( !alias.isEmpty() ) { fieldAlias_ = alias; if ( showAlias_ ) textLabelDB->setText( fieldAlias_ ); } } void FLFieldDB::setFieldName( const QString & fN ) { fieldName_ = fN; if ( showed ) { if ( topWidget_ ) { initCursor(); initEditor(); } else initFakeEditor(); } } void FLFieldDB::setActionName( const QString & aN ) { actionName_ = aN; if ( showed && !topWidget_ ) initFakeEditor(); } FLDoubleValidator::FLDoubleValidator( QObject * parent, const char *name ) : QDoubleValidator( parent, name ) {} FLDoubleValidator::FLDoubleValidator( double bottom, double top, int decimals, QObject * parent, const char *name ) : QDoubleValidator( bottom, top, decimals, parent, name ) {} QValidator::State FLDoubleValidator::validate( QString & input, int &i ) const { if ( input.isEmpty() ) return QValidator::Acceptable; input.replace( "," , "." ); QValidator::State state = QDoubleValidator::validate( input, i ); if ( state == QValidator::Invalid || state == QValidator::Intermediate ) { QString s = input.right( input.length() - 1 ); if ( input.left( 1 ) == "-" && ( QDoubleValidator::validate( s, i ) == QValidator::Acceptable || s.isEmpty() ) ) return QValidator::Acceptable; return QValidator::Invalid; } else return QValidator::Acceptable; } FLIntValidator::FLIntValidator( int minimum, int maximum, QObject * parent, const char *name ) : QIntValidator( minimum, maximum, parent, name ) {} QValidator::State FLIntValidator::validate( QString & input, int &i ) const { if ( input.isEmpty() ) return QValidator::Acceptable; QValidator::State state = QIntValidator::validate( input, i ); if ( state == QValidator::Invalid || state == QValidator::Intermediate ) { QString s = input.right( input.length() - 1 ); if ( input.left( 1 ) == "-" && ( QIntValidator::validate( s, i ) == QValidator::Acceptable || s.isEmpty() ) ) return QValidator::Acceptable; return QValidator::Invalid; } else return QValidator::Acceptable; } FLUIntValidator::FLUIntValidator( int minimum, int maximum, QObject * parent, const char *name ) : QIntValidator( minimum, maximum, parent, name ) {} QValidator::State FLUIntValidator::validate( QString & input, int &i ) const { if ( input.isEmpty() ) return QValidator::Acceptable; QIntValidator iV( 0, 1000000000, 0 ); QValidator::State state = iV.validate( input, i ); if ( state == QValidator::Intermediate ) state = QValidator::Invalid; return state; } void FLFieldDB::emitLostFocus() { emit lostFocus(); } void FLFieldDB::showEvent( QShowEvent * e ) { showWidget(); QWidget::showEvent( e ); } void FLFieldDB::showWidget() { if ( !showed ) { if ( topWidget_ ) { refresh(); if ( cursorAux && cursor_ && cursor_->bufferIsNull( fieldName_ ) ) { if ( !cursorAux->bufferIsNull( foreignField_ ) ) { FLTableMetaData * tMD = cursor_->db()->manager()->metadata( tableName_ ); if ( tMD ) { QVariant v = cursorAux->valueBuffer( foreignField_ ); FLSqlQuery q( 0, cursor_->db()->connectionName() ); q.setForwardOnly( true ); q.setTablesList( tableName_ ); q.setSelect( fieldName_ ); q.setFrom( tableName_ ); if ( filter_.isEmpty() ) q.setWhere( cursor_->db()->manager()->formatAssignValue( tMD->field( fieldRelation_ ), v, true ) ); else q.setWhere( filter_ + " AND " + cursor_->db()->manager()->formatAssignValue( tMD->field( fieldRelation_ ), v, true ) ); if ( q.exec() && q.next() ) setValue( q.value( 0 ) ); } } } } else initFakeEditor(); showed = true; } } void FLFieldDB::setNoShowed() { if ( !foreignField_.isEmpty() && !fieldRelation_.isEmpty() ) { showed = false; if ( isVisible() ) showWidget(); } } FLSqlCursor *FLFieldDB::cursor() { return cursor_; } bool FLFieldDB::showAlias() const { return showAlias_; } void FLFieldDB::setShowAlias( const bool value ) { if ( showAlias_ != value ) { showAlias_ = value; if ( showAlias_ ) textLabelDB->show(); else textLabelDB->hide(); } } void FLFieldDB::setMapValue( const QString & v ) { QObject * s = const_cast( sender() ); if ( !s->isA( "FLFieldDB" ) ) return ; if ( !cursor_ ) return ; FLTableMetaData *tMD = cursor_->metadata(); if ( !tMD ) return ; QString fSN = ::qt_cast( s )->fieldName(); FLFieldMetaData *field = tMD->field( fieldName_ ); FLFieldMetaData *fieldSender = tMD->field( fSN ); if ( !field || !fieldSender ) return ; QString rt, fF; if ( field->relationM1() ) { if ( field->relationM1()->foreignTable() != tMD->name() ) { rt = field->relationM1()->foreignTable(); fF = ::qt_cast( s )->foreignField(); FLSqlQuery q( 0, cursor_->db()->connectionName() ); q.setForwardOnly( true ); q.setTablesList( rt ); q.setSelect( field->relationM1()->foreignField() + "," + fF ); q.setFrom( rt ); if ( filter_.isEmpty() ) q.setWhere( cursor_->db()->manager()->formatAssignValue( fF, fieldSender, v, true ) ); else q.setWhere( filter_ + " AND " + cursor_->db()->manager()->formatAssignValue( fF, fieldSender, v, true ) ); if ( q.exec() && q.next() ) { setValue( QVariant() ); setValue( q.value( 0 ) ); } } } } void FLFieldDB::emitKeyF2Pressed() { emit keyF2Pressed(); } void FLFieldDB::emitTextChanged( const QString & t ) { emit textChanged( t ); } void FLFieldDB::toggleDatePicker() { if ( !dateFrame_ ) { dateFrame_ = new QVBox( this, "dateFrame", WType_Popup ); dateFrame_->setFrameStyle( QFrame::PopupPanel | QFrame::Raised ); dateFrame_->setFixedSize( 200, 200 ); dateFrame_->setLineWidth( 3 ); dateFrame_->hide(); if ( !datePopup_ ) { datePopup_ = new VDatePopup( dateFrame_, QDate::currentDate() ); connect( datePopup_, SIGNAL( dateSelected( const QDate & ) ), ::qt_cast( editor_ ), SLOT( setDate( const QDate & ) ) ); } } if ( !datePickerOn_ ) { QPoint tmpPoint = mapToGlobal( pbAux_->geometry().bottomRight() ); dateFrame_->setGeometry( tmpPoint.x() - 207, tmpPoint.y(), 200, 200 ); QDate date = ::qt_cast( editor_ )->date(); if ( date.isValid() ) { datePopup_->setDate( date ); } else { datePopup_->setDate( QDate::currentDate() ); } datePickerOn_ = true; dateFrame_->show(); } if ( !dateFrame_->isVisible() ) datePickerOn_ = false; } void FLFieldDB::clearPixmap() { if ( editorImg_ ) { editorImg_->clear(); cursor_->setValueBuffer( fieldName_, QVariant() ); } } void FLFieldDB::savePixmap( int f ) { if ( editorImg_ ) { QStrList fmtl = QImage::outputFormats(); const char* fmt = fmtl.at( f ); QString ext = QString( fmt ).lower() ; QString filename = "imagen." + ext; QString savefilename = QFileDialog::getSaveFileName( filename.lower(), "*." + ext, this, filename, tr( "Guardar imagen como" ) ); if ( !savefilename.isEmpty() ) { QPixmap pix; QApplication::setOverrideCursor( waitCursor ); pix.loadFromData( value().toCString() ); if ( !pix.isNull() ) if ( !pix.save( savefilename, fmt ) ) QMessageBox::warning( this, tr( "Error" ), tr( "Error guardando fichero" ) ); QApplication::restoreOverrideCursor(); } } } void FLFieldDB::toggleAutoCompletion() { if ( !autoComFrame_ && cursor_ ) { autoComFrame_ = new QVBox( this, "autoComFrame", WType_Popup ); autoComFrame_->setFrameStyle( QFrame::PopupPanel | QFrame::Raised ); autoComFrame_->setFixedSize( width() < 300 ? 300 : width(), 300 ); autoComFrame_->setLineWidth( 1 ); autoComFrame_->hide(); if ( !autoComPopup_ ) { FLTableMetaData * tMD = cursor_->metadata(); FLFieldMetaData * field = tMD ? tMD->field( fieldName_ ) : 0; if ( field ) { autoComPopup_ = new FLDataTable( autoComFrame_, "autoComPopup", true ); FLSqlCursor * cur; if ( !field->relationM1() ) { autoComFieldName_ = fieldName_; cur = new FLSqlCursor( tMD->name(), false, cursor_->db()->connectionName(), 0, 0, autoComFrame_ ); } else { autoComFieldName_ = field->relationM1()->foreignField(); cur = new FLSqlCursor( field->relationM1()->foreignTable(), false, cursor_->db()->connectionName(), 0, 0, autoComFrame_ ); tMD = cur->metadata(); field = tMD ? tMD->field( autoComFieldName_ ) : field; } cur->append( QSqlFieldInfo( autoComFieldName_, FLFieldMetaData::flDecodeType( field->type() ), -1, field->length(), -1 ) ); QStringList fieldsNames = QStringList::split( ",", tMD->fieldsNames() ); for ( QStringList::Iterator it = fieldsNames.begin(); it != fieldsNames.end(); ++it ) { if ( !cur->QSqlCursor::field( ( *it ) ) ) { field = tMD->field( *it ); if ( field ) cur->append( QSqlFieldInfo( field->name(), FLFieldMetaData::flDecodeType( field->type() ), -1, field->length(), -1, QVariant(), 0, true ) ); } } autoComPopup_->setFLSqlCursor( cur ); autoComPopup_->setTopMargin( 0 ); autoComPopup_->setLeftMargin( 0 ); autoComPopup_->horizontalHeader()->hide(); autoComPopup_->verticalHeader()->hide(); connect( cur, SIGNAL( newBuffer() ), this, SLOT( autoCompletionUpdateValue() ) ); connect( autoComPopup_, SIGNAL( recordChoosed() ), this, SLOT( autoCompletionUpdateValue() ) ); } } } if ( autoComPopup_ ) { FLSqlCursor * cur = autoComPopup_->cursor(); FLTableMetaData * tMD = cur->metadata(); FLFieldMetaData * field = tMD ? tMD->field( autoComFieldName_ ) : 0; if ( field ) { QString filter( cursor_->db()->manager()->formatAssignValueLike( field, value(), true ) ); cur->setFilter( filter ); autoComPopup_->setFilter( filter ); autoComPopup_->setSort( QStringList() << autoComFieldName_ + " ASC" ); autoComPopup_->QDataTable::refresh(); } if ( !autoComFrame_->isVisible() && cur->size() > 1 ) { QPoint tmpPoint( mapToGlobal( editor_->geometry().bottomLeft() ) ); autoComFrame_->setGeometry( tmpPoint.x(), tmpPoint.y(), autoComPopup_->width(), 300 ); autoComFrame_->show(); autoComFrame_->setFocus(); } else if ( autoComFrame_->isVisible() && cur->size() == 1 ) autoComFrame_->hide(); cur->first(); } } void FLFieldDB::autoCompletionUpdateValue() { if ( !autoComPopup_ || !autoComFrame_ ) return; FLSqlCursor * cur = autoComPopup_->cursor(); if ( !cur || !cur->isValid() ) return; if ( ::qt_cast( sender() ) ) { setValue( cur->valueBuffer( autoComFieldName_ ) ); autoComFrame_->hide(); } else if ( ::qt_cast( editor_ ) ) { setValue( cur->valueBuffer( autoComFieldName_ ) ); } else { FLLineEdit * ed = ::qt_cast( editor_ ); if ( autoComFrame_->isVisible() && !ed->hasFocus() ) { if ( !autoComPopup_->hasFocus() ) { QString cval( cur->valueBuffer( autoComFieldName_ ).toString() ); QString val( ed->text() ); ed->setText( cval ); ed->QLineEdit::setFocus(); ed->setCursorPosition( cval.length() ); ed->cursorBackward( true, cval.length() - val.length() ); } else setValue( cur->valueBuffer( autoComFieldName_ ) ); } else if ( !autoComFrame_->isVisible() ) { QString cval( cur->valueBuffer( autoComFieldName_ ).toString() ); QString val( ed->text() ); ed->setText( cval ); ed->QLineEdit::setFocus(); ed->setCursorPosition( cval.length() ); ed->cursorBackward( true, cval.length() - val.length() ); } } } int FLFieldDB::insertAccel( const QString & key ) { if ( !accel_ ) { accel_ = new QAccel( editor_ ); connect( accel_, SIGNAL( activated( int ) ), this, SLOT( emitActivatedAccel( int ) ) ); } int id = accel_->findKey( QKeySequence( key ) ); if ( id != -1 ) return id; id = accel_->insertItem( QKeySequence( key ) ); return id; } void FLFieldDB::removeAccel( int id ) { if ( !accel_ ) return; accel_->removeItem( id ); } void FLFieldDB::emitActivatedAccel( int id ) { if ( editor_ && editor_->hasFocus() ) { emit activatedAccel( id ); } } void FLFieldDB::setKeepDisabled( const bool keep ) { keepDisabled_ = keep; } bool FLFieldDB::showEditor() const { return showEditor_; } void FLFieldDB::setShowEditor( const bool show ) { if ( showEditor_ != show ) { QWidget * ed = 0; if ( editor_ ) ed = editor_; else if ( editorImg_ ) ed = editorImg_; if ( ed ) { showEditor_ = show; if ( show ) ed->show(); else ed->hide(); } } } void FLFieldDB::initFakeEditor() { bool hasPushButtonDB = ( tableName_.isEmpty() && foreignField_.isEmpty() && fieldRelation_.isEmpty() ); fieldAlias_ = ( fieldName_.isEmpty() ? tr( "Error: fieldName vacio" ) : fieldName_ ); if ( !editor_ ) { editor_ = new QLineEdit( this ); editor_-> setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, ( QSizePolicy::SizeType ) 0, editor_->sizePolicy().hasHeightForWidth() ) ); FLWidgetFieldDBLayout->addWidget( editor_ ); editor_->setFocusPolicy( QWidget::StrongFocus ); setFocusProxy( editor_ ); setTabOrder( pushButtonDB, editor_ ); editor_->show(); } textLabelDB->setText( fieldAlias_ ); if ( showAlias_ ) textLabelDB->show(); else textLabelDB->hide(); if ( hasPushButtonDB ) { pushButtonDB->setFocusPolicy( QWidget::NoFocus ); pushButtonDB->show(); } else pushButtonDB->hide(); QString prty; if ( !tableName_.isEmpty() ) prty += "tN:" + tableName_ + ","; if ( !foreignField_.isEmpty() ) prty += "fF:" + foreignField_ + ","; if ( !fieldRelation_.isEmpty() ) prty += "fR:" + fieldRelation_ + ","; if ( !actionName_.isEmpty() ) prty += "aN:" + actionName_ + ","; ::qt_cast( editor_ )->setText( prty ); ::qt_cast( editor_ )->home( false ); if ( maximumSize().width() < 80 ) setShowEditor( false ); else setShowEditor( showEditor_ ); } // dpinelo void FLLineEdit::aplicarLocaleNumerico() { bool ok; // dpinelo: Cogemos el texto, si el campo es de tipo numérico y le aplicamos el locale. Esto se produce cuando // se ha perdido el foco if ( type == QVariant::UInt || type == QVariant::Int || type == QVariant::Double ) { double valor = text().toDouble(&ok); if ( ok ) { QString texto = locale_.toString (valor, 'f', partDecimal ); blockSignals(true); setText(texto); blockSignals(false); } } } // dpinelo void FLLineEdit::eliminarLocaleNumerico() { bool ok; // dpinelo: Ahora si es numérico, eliminamos el formato, ya que el usuario va a editar y es mejor hacerlo con el número en limpio if ( type == QVariant::UInt || type == QVariant::Int || type == QVariant::Double ) { double valor = locale_.toDouble(text(), &ok); if ( ok ) { QString texto; texto.setNum( valor, 'f', partDecimal ); blockSignals(true); setText (texto); blockSignals(false); } } } // Si el objeto no tiene el foco, devolvemos el texto SIN formato QString FLLineEdit::text() const { bool ok; QString texto = QLineEdit::text(); if ( !tieneFoco_ && ( type == QVariant::UInt || type == QVariant::Int || type == QVariant::Double ) ) { double valor = locale_.toDouble(texto, &ok); if ( ok ) { texto.setNum( valor, 'f', partDecimal ); } } return texto; } // Si el objeto NO tiene el foco, y es numérico, le damos formato void FLLineEdit::setText(const QString & cadena) { bool ok; QString texto = cadena; if ( !tieneFoco_ && ( type == QVariant::UInt || type == QVariant::Int || type == QVariant::Double ) ) { double dValor = cadena.toDouble(&ok); if ( ok ) { texto = locale_.toString (dValor, 'f', partDecimal ); } } QLineEdit::setText(texto); }