/*************************************************************************** FLTableDB.cpp ------------------- begin : Sun Jul 1 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 "FLTableDB.h" #include "FLDataTable.h" #include "FLSqlCursor.h" #include "FLTableMetaData.h" #include "FLFieldMetaData.h" #include "FLRelationMetaData.h" #include "FLFormSearchDB.h" #include "FLManager.h" #ifdef FL_TEST #include "FLTester.h" #endif #include "FLAction.h" #include "FLApplication.h" #include "FLSqlDatabase.h" #include "FLSqlConnections.h" #include "FLFieldDB.h" #include "FLUtil.h" #include "FLSqlQuery.h" extern void qt_set_table_clipper_enabled( bool enabled ); FLTableDB::FLTableDB( QWidget * parent, const char *name ) : FLWidgetTableDB( parent, name ), tableRecords_( 0 ), tableName_( QString::null ), foreignField_( QString::null ), fieldRelation_( QString::null ), cursor_( 0 ), cursorVisualizacion_ (0), cursorAux( 0 ), topWidget( 0 ), showed( false ), filter_( QString::null ), readonly_( false ), reqReadOnly_( false ), editonly_( false ), reqEditOnly_( false ), insertonly_( false ), reqInsertOnly_( false ), sortField_( 0 ), initSearch_( QString::null ), checkColumnEnabled_( false ), aliasCheckColumn_( tr( "Seleccionar" ) ), fieldNameCheckColumn_( QString::null ), checkColumnVisible_( false ), sortColumn_( 0 ), orderAsc_( true ), sortColumn2_(1), orderAsc2_(true), tdbFilterLastWhere_( QString::null ), findHidden_( false ), filterHidden_( false ), fakeEditor_( 0 ), qryVisualizacion_ ( QString::null ), bQryVisualizacion_(false) { #ifndef Q_OS_WIN32 qt_set_table_clipper_enabled( false ); #endif 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( "FLTableDB : Uno de los padres o antecesores de FLTableDB deber ser de la clase FLFormDB o heredar de ella" ) ); #endif return ; } else { cursor_ = ::qt_cast( topWidget ) ->cursor(); cursorVisualizacion_ = cursor_; setFont( qApp->font() ); } if ( !name ) setName( "FLTableDB" ); timer = new QTimer( this, QObject::name() ); connect( timer, SIGNAL( timeout() ), SLOT( refreshDelayed() ) ); } FLDataTable * FLTableDB::tableRecords() { if ( !tableRecords_ ) { tableRecords_ = new FLDataTable( tabData, "tableRecords" ); tableRecords_->setFocusPolicy( QTable::StrongFocus ); setFocusProxy( tableRecords_ ); tabDataLayout->addWidget( tableRecords_ ); setTabOrder( tableRecords_, lineEditSearch ); setTabOrder( lineEditSearch, comboBoxFieldToSearch ); // dpinelo setTabOrder( comboBoxFieldToSearch, comboBoxFieldToSearch2 ); lineEditSearch->installEventFilter( this ); tableRecords_->installEventFilter( this ); connect( tableRecords_->horizontalHeader(), SIGNAL( clicked( int ) ), this, SLOT( switchSortOrder( int ) ) ); } FLSqlCursor * tCursor = tableRecords_->cursor(); // dpinelo: Modificado para permitir que lo que se muestre en el table sea una consulta y no el contenido de una tabla if ( cursorVisualizacion_ && cursorVisualizacion_ != tCursor && cursorVisualizacion_->metadata() && ( !tCursor || ( tCursor && tCursor->metadata() && tCursor->metadata()->name() != cursorVisualizacion_->metadata()->name() ) ) ) setTableRecordsCursor(); return tableRecords_; } void FLTableDB::setTableRecordsCursor() { if ( !tableRecords_ ) { tableRecords_ = new FLDataTable( tabData, "tableRecords" ); tableRecords_->setFocusPolicy( QTable::StrongFocus ); setFocusProxy( tableRecords_ ); tabDataLayout->addWidget( tableRecords_ ); setTabOrder( tableRecords_, lineEditSearch ); setTabOrder( lineEditSearch, comboBoxFieldToSearch ); // dpinelo setTabOrder( comboBoxFieldToSearch, comboBoxFieldToSearch2 ); lineEditSearch->installEventFilter( this ); tableRecords_->installEventFilter( this ); } FLSqlCursor * tCursor = tableRecords_->cursor(); tableRecords_->setFLSqlCursor( cursorVisualizacion_ ); if ( showed ) disconnect( tableRecords_, SIGNAL( currentChanged( QSqlRecord * ) ), this, SIGNAL( currentChanged() ) ); connect( tableRecords_, SIGNAL( currentChanged( QSqlRecord * ) ), this, SIGNAL( currentChanged() ) ); if ( bQryVisualizacion_ ) { connect( tableRecords_, SIGNAL( currentChanged( QSqlRecord * ) ), this, SLOT(sincronizarCursorConVisualizacion() ) ); } if ( tCursor ) disconnect( tableRecords_, SIGNAL( recordChoosed() ), tCursor, SLOT( chooseRecord() ) ); // dpinelo: Esto será lo que haya q cambiar para cuando se escoge el registro connect( tableRecords_, SIGNAL( recordChoosed() ), this, SLOT( registroElegido() ) ); } bool FLTableDB::eventFilter( QObject * obj, QEvent * ev ) { // dpinelo if ( !tableRecords_ || !lineEditSearch || !comboBoxFieldToSearch || !cursorVisualizacion_ || !comboBoxFieldToSearch2 ) return FLWidgetTableDB::eventFilter( obj, ev ); if ( ev->type() == QEvent::KeyPress && obj == tableRecords_ ) { QKeyEvent * k = static_cast( ev ); if ( k->key() == Key_F2 ) { comboBoxFieldToSearch->popup(); return true; } } if ( ev->type() == QEvent::KeyPress && obj == lineEditSearch ) { QKeyEvent * k = static_cast( ev ); if ( k->key() == Key_Enter || k->key() == Key_Return ) { tableRecords_->setFocus(); return true; } if ( k->key() == Key_Up ) { comboBoxFieldToSearch->setFocus(); return true; } if ( k->key() == Key_Down ) { tableRecords_->setFocus(); return true; } if ( k->key() == Key_F2 ) { comboBoxFieldToSearch->popup(); return true; } if ( k->text() == "'" || k->text() == "\\" ) return true; } if ( obj == tableRecords_ || obj == lineEditSearch ) return false; else return FLWidgetTableDB::eventFilter( obj, ev ); } void FLTableDB::putFirstCol( const QString & c ) { // dpinelo: Introducimos la ordenación por los dos campos QSqlIndex sort; FLTableMetaData *tMD = cursorVisualizacion_->metadata(); sort.append ( tMD->fieldAliasToName( c ) ); sort.append ( tMD->fieldAliasToName( comboBoxFieldToSearch2->text( comboBoxFieldToSearch2->currentItem() ) ) ); cursorVisualizacion_->setSort( sort ); moveCol( c, QString::null ); } void FLTableDB::putFirstCol( int c ) { // dpinelo: Introducimos la ordenación por los dos campos QSqlIndex sort; QHeader *horizHeader = tableRecords()->horizontalHeader(); FLTableMetaData *tMD = cursorVisualizacion_->metadata(); sort.append ( tMD->fieldAliasToName( horizHeader->label(c) ) ); sort.append ( tMD->fieldAliasToName( comboBoxFieldToSearch2->text( comboBoxFieldToSearch2->currentItem() ) ) ); cursorVisualizacion_->setSort( sort ); moveCol( c, 0 ); } // dpinelo void FLTableDB::putSecondCol( const QString & c ) { // dpinelo: Introducimos la ordenación por los dos campos QSqlIndex sort; FLTableMetaData *tMD = cursorVisualizacion_->metadata(); sort.append ( tMD->fieldAliasToName( comboBoxFieldToSearch->text( comboBoxFieldToSearch->currentItem() ) ) ); sort.append ( tMD->fieldAliasToName( c ) ); cursorVisualizacion_->setSort( sort ); // Aprovechamos que siempre, el combo box de filtro presenta sus items ordenados igual que el grid if ( c != comboBoxFieldToSearch->text( comboBoxFieldToSearch->currentItem() + 1 ) ) { moveCol( c, comboBoxFieldToSearch->text( comboBoxFieldToSearch->currentItem() + 1 ), false ); } } void FLTableDB::putSecondCol( int c ) { // dpinelo: No entiendo cómo el código funciona sin esto... QSqlIndex sort; QHeader *horizHeader = tableRecords()->horizontalHeader(); FLTableMetaData *tMD = cursorVisualizacion_->metadata(); sort.append ( tMD->fieldAliasToName( comboBoxFieldToSearch->text( comboBoxFieldToSearch->currentItem() ) ) ); sort.append ( tMD->fieldAliasToName( horizHeader->label(c) ) ); cursorVisualizacion_->setSort( sort ); // Aprovechamos que siempre, el combo box de filtro presenta sus items ordenados igual que el grid if ( c != ( comboBoxFieldToSearch->currentItem() + 1 ) ) { moveCol( c, ( comboBoxFieldToSearch->currentItem() + 1), false ); } } void FLTableDB::moveCol( const QString & from, const QString & to, bool firstSearch ) { if ( !topWidget || !cursorVisualizacion_ || !showed ) return ; FLTableMetaData *tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return ; QHeader *horizHeader = tableRecords()->horizontalHeader(); int i = sortColumn_, hCount = horizHeader->count(); int iFrom = ( from.isEmpty() ? sortColumn_ : sortColumn_ - 1 ), iTo = ( to.isEmpty() ? sortColumn_ : sortColumn_ - 1 ); while ( i < hCount && ( iFrom < sortColumn_ || iTo < sortColumn_ ) ) { if ( iFrom < sortColumn_ && horizHeader->label( i ) == tMD->fieldNameToAlias( from ) ) iFrom = i; if ( iTo < sortColumn_ && horizHeader->label( i ) == tMD->fieldNameToAlias( to ) ) iTo = i; ++i; } if ( iFrom < sortColumn_ ) { #ifdef FL_DEBUG qWarning( tr( "FLTableDB : No se puede cambiar la posicion de la columna, campo ( %1 ) no encontrado" ).arg( from ) ); #endif return; } if ( iTo < sortColumn_ ) { #ifdef FL_DEBUG qWarning( tr( "FLTableDB : No se puede cambiar la posicion de la columna, campo ( %1 ) no encontrado" ).arg( to ) ); #endif return; } moveCol( iFrom - sortColumn_, iTo - sortColumn_, firstSearch ); } void FLTableDB::moveCol( int from, int to, bool firstSearch ) { // dpinelo if ( from == to || !lineEditSearch || !comboBoxFieldToSearch || !cursorVisualizacion_ || !comboBoxFieldToSearch2 ) return ; if ( comboBoxFieldToSearch->text( from ) == "*" || comboBoxFieldToSearch->text( to ) == "*" ) return; QHeader * horizHeader = tableRecords()->horizontalHeader(); // dpinelo FLTableMetaData *tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return ; tableRecords_->hide(); int fromS = from + sortColumn_, toS = to + sortColumn_; QString fieldName = tMD->fieldAliasToName( horizHeader->label( fromS ) ), fieldNameItem; QString textSearch( lineEditSearch->text() ); if ( !textSearch.isEmpty() ) textSearch = cursorVisualizacion_->QSqlCursor::value( fieldName ).toString(); if ( fromS > toS ) { for ( int i = fromS - 1; i >= toS; --i ) { fieldNameItem = tMD->fieldAliasToName( horizHeader->label( i ) ); tableRecords_->setColumn( i + 1, fieldNameItem, fieldNameItem ); } } else { for ( int i = fromS + 1; i <= toS; ++i ) { fieldNameItem = tMD->fieldAliasToName( horizHeader->label( i ) ); tableRecords_->setColumn( i - 1, fieldNameItem, fieldNameItem ); } } tableRecords_->setColumn( toS, fieldName, fieldName ); refresh( true ); if ( !textSearch.isEmpty() ) { refresh( false, true ); if ( firstSearch ) { disconnect( lineEditSearch, SIGNAL( textChanged( const QString& ) ), this, SLOT( filterRecords( const QString& ) ) ); // dpinelo lineEditSearch->setText( textSearch ); connect( lineEditSearch, SIGNAL( textChanged( const QString& ) ), this, SLOT( filterRecords( const QString& ) ) ); lineEditSearch->selectAll(); } seekCursor(); QTimer::singleShot( 0, tableRecords_, SLOT( ensureRowSelectedVisible() ) ); } else refreshDelayed(); if ( !sender() ) tableRecords_->setQuickFocus(); } void FLTableDB::setReadOnly( const bool mode ) { if ( tableRecords_ ) { readonly_ = mode; tableRecords_->setFLReadOnly( mode ); emit readOnlyChanged( mode ); } reqReadOnly_ = mode; } void FLTableDB::setEditOnly( const bool mode ) { if ( tableRecords_ ) { editonly_ = mode; tableRecords_->setEditOnly( mode ); emit editOnlyChanged( mode ); } reqEditOnly_ = mode; } void FLTableDB::setInsertOnly( const bool mode ) { if ( tableRecords_ ) { insertonly_ = mode; tableRecords_->setInsertOnly( mode ); emit insertOnlyChanged( mode ); } reqInsertOnly_ = mode; } void FLTableDB::setFilter( const QString &f ) { filter_ = f; } QString FLTableDB::filter() { return filter_; } QString FLTableDB::findFilter() { return tdbFilterLastWhere_; } void FLTableDB::refreshDelayed( int msec, const bool refreshData ) { if ( !timer ) return; timer->stop(); const QObject * obj = sender(); if ( obj ) { if ( !obj->inherits( "QTimer" ) ) { timer->start( msec, true ); return ; } } else { timer->start( msec, true ); return ; } if ( cursorVisualizacion_->modeAccess() != FLSqlCursor::BROWSE ) return; if ( refreshData ) refresh( false, true ); seekCursor(); } void FLTableDB::refresh( const bool refreshHead, const bool refreshData ) { // dpinelo if ( !lineEditSearch || !comboBoxFieldToSearch || !cursorVisualizacion_ || ( topWidget && !topWidget->isShown() ) || !comboBoxFieldToSearch2 ) return ; FLTableMetaData * tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return ; if ( tableName_.isEmpty() ) tableName_ = tMD->name(); if ( checkColumnEnabled_ ) { if ( !checkColumnVisible_ ) { FLFieldMetaData * fieldCheck = tMD->field( fieldNameCheckColumn_ ); if ( !fieldCheck ) { fieldNameCheckColumn_ = tMD->name() + "_check_column"; fieldCheck = new FLFieldMetaData( fieldNameCheckColumn_, aliasCheckColumn_, true, false, FLFieldMetaData::Check, 0, false, true, true, 0, 0, false, false, false, QVariant(), false, QString::null, true, false, false ); tMD->addFieldMD( fieldCheck ); } if ( !cursorVisualizacion_->contains( fieldNameCheckColumn_ ) ) { QSqlRecord recordCursor( *( cursorVisualizacion_->editBuffer() ) ); QSqlFieldInfo fakeFieldInfo( fieldNameCheckColumn_, QVariant::Bool, -1, -1, -1, QVariant(), 0, false, false, true ); cursorVisualizacion_->clear(); cursorVisualizacion_->append( fakeFieldInfo ); for ( int i = 0; i < recordCursor.count(); ++i ) cursorVisualizacion_->append( QSqlFieldInfo( *( recordCursor.field( i ) ) ) ); setTableRecordsCursor(); tableRecords_->setColumn( 0, fieldNameCheckColumn_, aliasCheckColumn_ ); sortColumn_ = 1; // dpinelo sortColumn_ = 2; } checkColumnVisible_ = true; } } else { if ( checkColumnVisible_ ) { tMD->removeFieldMD( fieldNameCheckColumn_ ); if ( cursorVisualizacion_->contains( fieldNameCheckColumn_ ) ) { QSqlRecord recordCursor( *( cursorVisualizacion_->editBuffer() ) ); cursorVisualizacion_->clear(); for ( int i = 1; i < recordCursor.count(); ++i ) cursorVisualizacion_->append( QSqlFieldInfo( *( recordCursor.field( i ) ) ) ); setTableRecordsCursor(); sortColumn_ = 0; } checkColumnVisible_ = false; } } if ( refreshHead ) { QHeader * horizHeader = tableRecords()->horizontalHeader(); horizHeader->hide(); tableRecords_->QDataTable::refresh( QDataTable::RefreshColumns ); FLFieldMetaData *field; for ( int i = sortColumn_; i < tableRecords_->numCols(); ++i ) { field = tMD->field( tMD->fieldAliasToName( horizHeader->label( i ) ) ); if ( !field ) continue; if ( !field->visibleGrid() ) { horizHeader->removeLabel( i ); tableRecords_->removeColumn( i ); if ( i < tableRecords_->numCols() ) i--; } } // dpinelo: Para permitir ordenaciones por dos campos hace falta agregarlos así QStringList s = QStringList() << tMD->fieldAliasToName( horizHeader->label( sortColumn_ ) ) + ( orderAsc_ ? " ASC" : " DESC" ); s << tMD->fieldAliasToName( horizHeader->label( sortColumn2_ ) ) + ( orderAsc2_ ? " ASC" : " DESC" ); tableRecords_->setSort( s ); tableRecords_->QDataTable::refresh( QDataTable::RefreshColumns ); comboBoxFieldToSearch->clear(); // dpinelo comboBoxFieldToSearch2->clear(); for ( int i = sortColumn_; i < tableRecords_->numCols(); ++i ) { field = tMD->field( tMD->fieldAliasToName( horizHeader->label( i ) ) ); if ( !field ) continue; if ( i == sortColumn_ ) sortField_ = field; if ( comboBoxFieldToSearch->count() == ( i - sortColumn_ ) ) comboBoxFieldToSearch->insertItem( field->alias() ); horizHeader->setLabel( i, field->alias() ); tableRecords_->setColumn( i, field->name(), field->alias() ); } // dpinelo for ( int i = sortColumn2_; i < tableRecords_->numCols(); ++i ) { field = tMD->field( tMD->fieldAliasToName( horizHeader->label( i ) ) ); if ( !field ) continue; if ( i == sortColumn2_ ) sortField2_ = field; if ( comboBoxFieldToSearch2->count() == ( i - sortColumn2_ ) ) comboBoxFieldToSearch2->insertItem( field->alias() ); horizHeader->setLabel( i, field->alias() ); tableRecords_->setColumn( i, field->name(), field->alias() ); } comboBoxFieldToSearch->insertItem( "*" ); horizHeader->setClickEnabled( false ); horizHeader->setClickEnabled( true, sortColumn_ ); // dpinelo horizHeader->setClickEnabled( true, sortColumn2_ ); horizHeader->setSortIndicator( -1, Qt::Ascending ); horizHeader->setSortIndicator( sortColumn_, ( orderAsc_ ? Qt::Ascending : Qt::Descending ) ); horizHeader->show(); } if ( refreshData || sender() ) { QString finalFilter = filter_; if ( !tdbFilterLastWhere_.isEmpty() ) { if ( finalFilter.isEmpty() ) finalFilter = tdbFilterLastWhere_; else finalFilter += " and " + tdbFilterLastWhere_; } tableRecords()->setPersistentFilter( finalFilter ); tableRecords_->refresh(); } if ( !initSearch_.isEmpty() ) { disconnect( lineEditSearch, SIGNAL( textChanged( const QString& ) ), this, SLOT( filterRecords( const QString& ) ) ); lineEditSearch->setText( initSearch_ ); connect( lineEditSearch, SIGNAL( textChanged( const QString& ) ), this, SLOT( filterRecords( const QString& ) ) ); lineEditSearch->selectAll(); initSearch_ = QString::null; seekCursor(); } if ( readonly_ != reqReadOnly_ ) setReadOnly( reqReadOnly_ ); if ( editonly_ != reqEditOnly_ ) setEditOnly( reqEditOnly_ ); if ( insertonly_ != reqInsertOnly_ ) setInsertOnly( reqInsertOnly_ ); if ( showed && tableRecords_ && tableRecords_->isHidden() ) tableRecords_->show(); } void FLTableDB::filterRecords( const QString & p ) { if ( !topWidget || !cursorVisualizacion_ || ( p.isEmpty() && filter_.isEmpty() ) ) return ; if ( !sortField_ ) { FLTableMetaData * tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return; sortField_ = tMD->field( tMD->primaryKey() ); } if ( sortField_->type() == FLFieldMetaData::Unlock ) return ; bool refreshData = filter_.contains( "%" ); bool allFields = comboBoxFieldToSearch->text( comboBoxFieldToSearch->currentItem() ) == "*"; filter_ = ""; if ( !p.isEmpty() && allFields ) { FLTableMetaData::FLFieldMetaDataList * fieldList = cursorVisualizacion_->metadata() ->fieldList(); if ( fieldList ) { FLFieldMetaData * field; QDictIterator it( *fieldList ); while ( ( field = it.current() ) != 0 ) { ++it; if ( !field->visibleGrid() ) continue; if ( !p.contains( "'" ) && !p.contains( "\\" ) && field->type() == QVariant::String ) { if ( !filter_.isEmpty() ) filter_ += " OR "; filter_ += cursorVisualizacion_->db()->manager()->formatAssignValueLike( field, p, true ); } } } } if ( ( !p.isEmpty() || !refreshData ) && !allFields && !p.contains( "'" ) && !p.contains( "\\" ) ) { /* dpinelo: No se puede construir el filtro así: La razón: Tenemos un archivo qry (articulosqry.qry) que estará asociado a una tabla (articulos.mtd). Tendremos que establecer una definición de metadatos para la consulta: articulosqry.mtd. Estos metadatos serán los de cursorVisualizacion, y el nombre de la tabla de ese mtd será artículos. formatAssignValueLike asigna siempre al nombre de la columna el prefijo con el nombre de la tabla. Si tenemos una columna que viene de dos tablas (por ejemplo, estamos mostrando el nombre de una columna que NO es de la tabla principal), siempre asignará la columna de la tabla principal, y cuando busquemos por una columna de la tabla no principal (como la tabla articulosprov, por ejemplo) dará error */ filter_ = cursorVisualizacion_->db()->manager()->formatAssignValueLike( sortField_, p, true ); if ( cursorVisualizacion_->metadata()->isQuery() ) { filter_ = cursorVisualizacion_->db()->manager()->formatAssignValueLike( sortField_->name(), sortField_, p, true ); } else { filter_ = cursorVisualizacion_->db()->manager()->formatAssignValueLike( sortField_, p, true ); } } refreshDelayed( 300, !filter_.isEmpty() || refreshData ); } QString FLTableDB::tableName() const { return tableName_; } QString FLTableDB::foreignField() const { return foreignField_; } QString FLTableDB::fieldRelation() const { return fieldRelation_; } void FLTableDB::setTableName( const QString & fT ) { tableName_ = fT; if ( showed ) { if ( topWidget ) initCursor(); else initFakeEditor(); } } void FLTableDB::setForeignField( const QString & fN ) { foreignField_ = fN; if ( showed ) { if ( topWidget ) initCursor(); else initFakeEditor(); } } void FLTableDB::setFieldRelation( const QString & fN ) { fieldRelation_ = fN; if ( showed ) { if ( topWidget ) initCursor(); else initFakeEditor(); } } void FLTableDB::deleteRecord() { QWidget * w = ::qt_cast( sender() ); if ( w && ( !cursorVisualizacion_ || readonly_ || insertonly_ || editonly_ || ( cursorVisualizacion_->cursorRelation() && cursorVisualizacion_->cursorRelation()->isLocked() ) ) ) { w->setDisabled( true ); return ; } sincronizarCursorConVisualizacion(); cursor_->deleteRecord(); #ifdef FL_TEST ::qt_cast( qApp ) ->continueTesting( FLTester::RECORD_DELETED, "VOID" ); #endif } void FLTableDB::browseRecord() { if ( !cursor_ && !cursorVisualizacion_ ) return ; sincronizarCursorConVisualizacion(); cursor_->browseRecord(); #ifdef FL_TEST QString formName = "formRecord" + cursor_->action() ->name(); ::qt_cast( qApp ) ->continueTesting( FLTester::FORM_RECORD_READY, formName ); #endif } void FLTableDB::editRecord() { QWidget * w = ::qt_cast( sender() ); if ( w && ( !cursor_ || !cursorVisualizacion_ || readonly_ || insertonly_ || ( cursor_->cursorRelation() && cursor_->cursorRelation()->isLocked() ) ) ) { w->setDisabled( true ); return ; } sincronizarCursorConVisualizacion(); cursor_->editRecord(); #ifdef FL_TEST if ( cursor_->action() ) { QString formName = "formRecord" + cursor_->action() ->name(); ::qt_cast( qApp ) ->continueTesting( FLTester::FORM_RECORD_READY, formName ); } #endif } void FLTableDB::insertRecord() { QWidget * w = ::qt_cast( sender() ); if ( w && ( !cursorVisualizacion_ || !cursor_ || readonly_ || editonly_ || ( cursor_->cursorRelation() && cursor_->cursorRelation()->isLocked() ) ) ) { w->setDisabled( true ); return ; } sincronizarCursorConVisualizacion(); cursor_->insertRecord(); #ifdef FL_TEST QString formName = "formRecord" + cursor_->action() ->name(); ::qt_cast( qApp ) ->continueTesting( FLTester::FORM_RECORD_READY, formName ); #endif } void FLTableDB::copyRecord() { QWidget * w = ::qt_cast( sender() ); if ( w && ( !cursorVisualizacion_ || !cursor_ || readonly_ || editonly_ || ( cursor_->cursorRelation() && cursor_->cursorRelation()->isLocked() ) ) ) { w->setDisabled( true ); return ; } sincronizarCursorConVisualizacion(); cursor_->copyRecord(); #ifdef FL_TEST QString formName = "formRecord" + cursor_->action() ->name(); ::qt_cast( qApp ) ->continueTesting( FLTester::FORM_RECORD_READY, formName ); #endif } void FLTableDB::initCursor() { if ( !topWidget || !cursor_ ) return; if ( bQryVisualizacion_ ) { // El nuevo cursor de visualización DEBE tener la misma primary key que tiene el cursor de la tabla // e inicialmente será ordenador por esa primarykey para evitar problemas de visualización. La primary key // en consulta y tabla es lo garantizará la sincronización de ambos cursorVisualizacion_ = new FLSqlCursor( qryVisualizacion_, true, "default", 0, 0, this ); // dpinelo: Puede ser que el objeto cursor que alimenta la tabla venga con un filtro. // Lo establecemos también para el de visualización if ( cursor_->filtroVisualizacion().isEmpty() ) cursorVisualizacion_->setMainFilter( cursor_->mainFilter() ); else cursorVisualizacion_->setMainFilter( cursor_->filtroVisualizacion() ); sincronizarVisualizacionConCursor(); } else { cursorVisualizacion_ = cursor_; } if ( !cursorVisualizacion_->metadata() ) return; FLTableMetaData *tMD = 0; if ( !sortField_ ) { tMD = cursorVisualizacion_->metadata(); if ( tMD ) { sortField_ = tMD->field( tMD->primaryKey() ); // dpinelo: añadido para que se inicie el table ordenado por la primary key cursorVisualizacion_->setSort( cursorVisualizacion_->index( tMD->primaryKey( ) ) ); } } if ( !tableName_.isEmpty() ) { // dpinelo if ( !cursor_->db()->manager()->existsTable( tableName_ ) ) tMD = cursor_->db()->manager()->createTable( tableName_ ); else { // dpinelo if ( bQryVisualizacion_ ) { tMD = cursorVisualizacion_->db()->manager()->metadata( qryVisualizacion_ ); } else { tMD = cursorVisualizacion_->db()->manager()->metadata( tableName_ ); } } if ( !tMD ) return ; if ( foreignField_.isEmpty() || fieldRelation_.isEmpty() ) { if ( !cursorVisualizacion_->metadata() ) { return ; } if ( cursor_->metadata() ->name() != tableName_ ) { QObject * ctxt = cursor_->context(); cursor_ = new FLSqlCursor( tableName_, true, cursor_->db()->connectionName(), 0, 0, this ); if ( cursor_ ) { cursor_->setContext( ctxt ); cursorAux = 0; } return ; } } else { FLSqlCursor * cursorTopWidget = ::qt_cast( topWidget ) ->cursor(); if ( cursorTopWidget && cursorTopWidget->metadata() ->name() != tableName_ ) cursor_ = cursorTopWidget; } } if ( tableName_.isEmpty() || foreignField_.isEmpty() || fieldRelation_.isEmpty() || cursorAux ) return ; cursorAux = cursor_; QString curName( cursor_->metadata()->name() ); FLRelationMetaData * rMD = cursor_->metadata()->relation( foreignField_, fieldRelation_, tableName_ ); FLRelationMetaData * testM1 = tMD->relation( fieldRelation_, foreignField_, curName ); bool checkIntegrity = false; if ( !rMD ) { if ( testM1 ) checkIntegrity = ( testM1->cardinality() == FLRelationMetaData::RELATION_M1 ); FLFieldMetaData * fMD = cursorVisualizacion_->metadata()->field( foreignField_ ); if ( fMD ) { rMD = new FLRelationMetaData( tableName_, fieldRelation_, FLRelationMetaData::RELATION_1M, false, false, checkIntegrity ); fMD->addRelationMD( rMD ); #ifdef FL_DEBUG qWarning( tr( "FLTableDB : La relación entre la tabla del formulario %1 y esta tabla %2 de este campo no existe, pero sin embargo se han indicado los campos de relación( %3, %4 )" ) .arg( curName ).arg( tableName_ ).arg( fieldRelation_ ).arg( foreignField_ ) ); qWarning( tr( "FLTableDB : Creando automáticamente %1.%2 --1M--> %3.%4" ) .arg( curName ).arg( foreignField_ ).arg( tableName_ ).arg( fieldRelation_ ) ); #endif } #ifdef FL_DEBUG else { qWarning( tr( "FLTableDB : El campo ( %1 ) indicado en la propiedad foreignField no se encuentra en la tabla ( %2 )" ) .arg( foreignField_ ).arg( curName ) ); } #endif } rMD = testM1; if ( !rMD ) { FLFieldMetaData * fMD = tMD->field( fieldRelation_ ); if ( fMD ) { rMD = new FLRelationMetaData( curName, foreignField_, FLRelationMetaData::RELATION_1M, false, false, false ); fMD->addRelationMD( rMD ); #ifdef FL_DEBUG qWarning( tr( "FLTableDB : Creando automáticamente %1.%2 --1M--> %3.%4" ) .arg( tableName_ ).arg( fieldRelation_ ).arg( curName ).arg( foreignField_ ) ); #endif } #ifdef FL_DEBUG else { qWarning( tr( "FLTableDB : El campo ( %1 ) indicado en la propiedad fieldRelation no se encuentra en la tabla ( %2 )" ) .arg( fieldRelation_ ).arg( tableName_ ) ); } #endif } cursor_ = new FLSqlCursor( tableName_, true, cursor_->db()->connectionName(), cursorAux, rMD, this ); // dpinelo: Si había que crear un nuevo cursor, REasignamos if ( !bQryVisualizacion_ ) { cursorVisualizacion_ = cursor_; } if ( !cursor_ ) { cursor_ = cursorAux; cursorAux = 0; } else { cursor_->setContext( cursorAux->context() ); if ( showed ) disconnect( cursorAux, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); connect( cursorAux, SIGNAL( newBuffer() ), this, SLOT( refresh() ) ); } if ( cursorAux && topWidget->isA( "FLFormSearchDB" ) ) { topWidget->setCaption( cursor_->metadata() ->alias() ); ::qt_cast( topWidget ) ->setCursor( cursor_ ); } } void FLTableDB::showEvent( QShowEvent * e ) { QWidget::showEvent( e ); showWidget(); } void FLTableDB::showWidget() { if ( showed ) return; if ( !topWidget ) { initFakeEditor(); showed = true; return; } if ( !cursor_ && !cursorVisualizacion_ ) return; showed = true; FLTableMetaData *tMD; if ( !tableName_.isEmpty() ) { if ( !cursorVisualizacion_->db()->manager()->existsTable( tableName_ ) ) tMD = cursorVisualizacion_->db()->manager()->createTable( tableName_ ); else tMD = cursorVisualizacion_->db()->manager()->metadata( tableName_ ); if ( !tMD ) return ; } tableRecords(); if ( !cursorAux ) { if ( !initSearch_.isEmpty() ) { refresh( true, true ); QTimer::singleShot( 0, tableRecords_, SLOT( ensureRowSelectedVisible() ) ); } else { refresh( true ); if ( tableRecords_->numRows() <= 0 ) refresh( false, true ); else refreshDelayed(); } if ( !topWidget->isA( "FLFormRecordDB" ) ) tableRecords_->setQuickFocus(); } if ( cursorAux ) { if ( topWidget->isA( "FLFormRecordDB" ) && cursorAux->modeAccess() == FLSqlCursor::BROWSE ) { cursor_->setEdition( false ); cursorVisualizacion_->setEdition ( false ); setReadOnly( true ); } if ( !initSearch_.isEmpty() ) { refresh( true, true ); QTimer::singleShot( 0, tableRecords_, SLOT( ensureRowSelectedVisible() ) ); } else { refresh( true ); if ( tableRecords_->numRows() <= 0 ) refresh( false, true ); else refreshDelayed(); } } else if ( topWidget->isA( "FLFormRecordDB" ) && cursor_->modeAccess() == FLSqlCursor::BROWSE && !tMD->isQuery() ) { cursor_->setEdition( false ); cursorVisualizacion_->setEdition ( false ); setReadOnly( true ); } } FLSqlCursor * FLTableDB::cursor() { return cursor_; } void FLTableDB::setOrderCols( QStringList & fields ) { if ( !cursor_ ) return ; // dpinelo FLTableMetaData *tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return ; QHeader * horizHeader = tableRecords()->horizontalHeader(); int i = fields.count(), hCount = horizHeader->count(); if ( i > ( hCount - sortColumn_ ) ) return; int j; for ( j = sortColumn_; j < i; ++j ) if ( fields[j] != tMD->fieldAliasToName( horizHeader->label( j ) ) ) break; if ( j == i ) return; int c; QString fieldName, fieldAlias; QStringList::Iterator it = fields.end(); tableRecords_->hide(); do { --it; --i; fieldAlias = tMD->fieldNameToAlias( *it ); for ( c = sortColumn_; horizHeader->label( c ) != fieldAlias && c < hCount; ++c ) ; if ( c < hCount ) { fieldName = tMD->fieldAliasToName( horizHeader->label( i + sortColumn_ ) ); if ( fieldName != ( *it ) ) { tableRecords_->setColumn( i + sortColumn_, *it, fieldAlias ); horizHeader->setLabel( i + sortColumn_, tMD->fieldNameToAlias( *it ) ); horizHeader->setLabel( c, tMD->fieldNameToAlias( fieldName ) ); tableRecords_->setColumn( c, fieldName, tMD->fieldNameToAlias( fieldName ) ); tableRecords_->QDataTable::refresh( QDataTable::RefreshColumns ); } } } while ( it != fields.begin() ); QString textSearch( lineEditSearch->text() ); if ( !textSearch.isEmpty() ) textSearch = cursorVisualizacion_->QSqlCursor::value( fieldName ).toString(); refresh( true ); if ( !textSearch.isEmpty() ) { refresh( false, true ); disconnect( lineEditSearch, SIGNAL( textChanged( const QString& ) ), this, SLOT( filterRecords( const QString& ) ) ); lineEditSearch->setText( textSearch ); connect( lineEditSearch, SIGNAL( textChanged( const QString& ) ), this, SLOT( filterRecords( const QString& ) ) ); lineEditSearch->selectAll(); seekCursor(); QTimer::singleShot( 0, tableRecords_, SLOT( ensureRowSelectedVisible() ) ); } else refreshDelayed(); } QStringList FLTableDB::orderCols() { QStringList list; if ( !cursorVisualizacion_ ) return list; // dpinelo: FLTableMetaData *tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return list; QHeader * horizHeader = tableRecords()->horizontalHeader(); int hCount = horizHeader->count(); for ( int i = sortColumn_; i < hCount; ++i ) list.append( tMD->fieldAliasToName( horizHeader->label( i ) ) ); return list; } void FLTableDB::seekCursor() { if ( !cursorVisualizacion_ ) return ; // dpinelo: FLTableMetaData *tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return ; QString textSearch( lineEditSearch->text() ); if ( textSearch.isEmpty() ) return; QString fN( sortField_->name() ); textSearch.replace( "%", "" ); if ( !textSearch.contains( "'" ) && !textSearch.contains( "\\" ) ) { // dpinelo: Comento el código: Debemos localizar el primer registro que cumple con el filtro para asignarlo al cursor // de visualización if ( bQryVisualizacion_ ) { FLSqlCursor *temp = new FLSqlCursor( qryVisualizacion_, true, "default", 0, 0, this ); QString where( ( cursorVisualizacion_->curFilter().isEmpty() ? "" : cursorVisualizacion_->curFilter() + " and " ) ); where += cursorVisualizacion_->db()->manager()->formatAssignValueLike( fN, sortField_, textSearch, true ); if ( !sortField_->name().isEmpty() ) { where += " ORDER BY " + sortField_->name() + ", " + tMD->primaryKey() ; } else { where += " ORDER BY " + tMD->primaryKey() ; } where += " LIMIT 1"; // Para que ordenes en query, debemos hacerlo así y no así, ya que he deshabilitado esta fórmula // temp->select( where, QSqlIndex::fromStringList( orden, temp )); temp->select( where ); if ( temp->first() ) { int pos = cursorVisualizacion_->atFromBinarySearch( fN, temp->QSqlCursor::value( fN ).toString(), orderAsc_ ); cursorVisualizacion_->seek( pos, false, true ); } delete temp; } else { QString where( ( cursorVisualizacion_->curFilter().isEmpty() ? " where " : " where " + cursorVisualizacion_->curFilter() + " and " ) ); where += cursorVisualizacion_->db()->manager()->formatAssignValueLike( fN, sortField_, textSearch, true ); QString sql( "select " + fN + " from " + tMD->name() + where + " order by " + fN + QString( orderAsc_ ? " ASC" : " DESC" ) + " limit 1" ); QSqlQuery qry( sql, cursorVisualizacion_->db()->db() ); if ( qry.first() ) cursorVisualizacion_->seek( cursorVisualizacion_->atFromBinarySearch( fN, qry.value( 0 ).toString(), orderAsc_ ), false, true ); } // dpinelo sincronizarCursorConVisualizacion(); } } bool FLTableDB::checkColumnEnabled() const { return checkColumnEnabled_; } void FLTableDB::setCheckColumnEnabled( bool b ) { checkColumnEnabled_ = b; } QString FLTableDB::aliasCheckColumn() const { return aliasCheckColumn_; } void FLTableDB::setAliasCheckColumn( const QString & t ) { aliasCheckColumn_ = t; } void FLTableDB::switchSortOrder( int col ) { // dpinelo if ( col == 0 ) { orderAsc_ = !orderAsc_; } else if ( col == 1 ) { orderAsc2_ = !orderAsc2_; } tableRecords()->hide(); refresh( true, true ); } void FLTableDB::activeTabData( bool on ) { if ( topWidget && tabTable->visibleWidget() != tabData ) { refreshTabData(); tabTable->raiseWidget( tabData ); } } void FLTableDB::activeTabFilter( bool on ) { if ( topWidget && tabTable->visibleWidget() != tabFilter ) { refreshTabFilter(); tabTable->raiseWidget( tabFilter ); } } void FLTableDB::refreshTabData() { QString tdbWhere( tdbFilterBuildWhere() ); if ( tdbWhere != tdbFilterLastWhere_ ) { tdbFilterLastWhere_ = tdbWhere; refresh( false, true ); } } void FLTableDB::refreshTabFilter() { QHeader * horizHeader = tableRecords()->horizontalHeader(); if ( !horizHeader ) return; int hCount = horizHeader->count() - sortColumn_; if ( tdbFilter->numRows() < hCount && cursorVisualizacion_ ) { FLTableMetaData *tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return ; FLFieldMetaData * field = 0; QWidget * editor_ = 0; int type, len, partInteger, partDecimal; QString rX; bool ol; tdbFilter->setSelectionMode( QTable::NoSelection ); tdbFilter->setNumCols( 5 ); tdbFilter->setNumRows( hCount ); tdbFilter->setColumnReadOnly( 0, true ); tdbFilter->setColumnLabels( QStringList::split( ",", tr( "Campo,Condición,Valor,Desde,Hasta" ) ) ); mapCondType.insert( tr( "Todos" ), FLTableDB::All ); mapCondType.insert( tr( "Contiene Valor" ), FLTableDB::Contains ); mapCondType.insert( tr( "Empieza por Valor" ), FLTableDB::Starts ); mapCondType.insert( tr( "Acaba por Valor" ), FLTableDB::End ); mapCondType.insert( tr( "Igual a Valor" ), FLTableDB::Equal ); mapCondType.insert( tr( "Distinto de Valor" ), FLTableDB::Dist ); mapCondType.insert( tr( "Mayor que Valor" ), FLTableDB::Greater ); mapCondType.insert( tr( "Menor que Valor" ), FLTableDB::Less ); mapCondType.insert( tr( "Desde - Hasta" ), FLTableDB::FromTo ); mapCondType.insert( tr( "Vacío" ), FLTableDB::Null ); mapCondType.insert( tr( "No Vacío" ), FLTableDB::NotNull ); for ( int i = 0; i < hCount; ++i ) { tdbFilter->setText( i, 0, horizHeader->label( i + sortColumn_ ) ) ; field = tMD->field( tMD->fieldAliasToName( horizHeader->label( i + sortColumn_ ) ) ); if ( !field ) continue; type = field->type(); len = field->length(); partInteger = field->partInteger(); partDecimal = field->partDecimal(); rX = field->regExpValidator(); ol = field->hasOptionsList(); QComboBox * cond; if ( type != QVariant::Pixmap ) { QStringList condList; condList << tr( "Todos" ) << tr( "Igual a Valor" ) << tr( "Distinto de Valor" ) << tr( "Vacío" ) << tr( "No Vacío" ); if ( type != QVariant::Bool ) { condList << tr( "Contiene Valor" ) << tr( "Empieza por Valor" ) << tr( "Acaba por Valor" ) << tr( "Mayor que Valor" ) << tr( "Menor que Valor" ) << tr( "Desde - Hasta" ); } cond = new QComboBox; cond->insertStringList( condList ); tdbFilter->setCellWidget( i, 1, cond ); } for ( int j = 2; j < 5; ++j ) { editor_ = 0; switch ( type ) { case QVariant::UInt: case QVariant::Int: case QVariant::Double: case QVariant::String: case QVariant::StringList: if ( ol ) { editor_ = new QComboBox; 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 ); } else { editor_ = new FLLineEdit( 0 ); if ( type == QVariant::Double ) { ::qt_cast( editor_ )->setValidator( new FLDoubleValidator( 0, pow( 10, partInteger ) - 1, partDecimal, editor_ ) ); // dpinelo: Alineamiento vertical ::qt_cast( editor_ )->setAlignment( Qt::AlignRight | Qt::AlignTop ); } 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_ ) ); // dpinelo ::qt_cast( editor_ )->setAlignment( Qt::AlignRight | Qt::AlignTop ); } else { ::qt_cast( editor_ )->setMaxLength( len ); if ( !rX.isEmpty() ) { QRegExp r( rX ); ::qt_cast( editor_ )->setValidator( new QRegExpValidator( r, editor_ ) ); } // dpinelo ::qt_cast( editor_ )->setAlignment( Qt::AlignLeft | Qt::AlignTop ); } } } break; case FLFieldMetaData::Serial: editor_ = new FLSpinBox; ::qt_cast( editor_ )->setMaxValue( ( ( int ) pow( 10, partInteger ) - 1 ) ); break; case QVariant::Pixmap: tdbFilter->setRowReadOnly( i, true ); break; case QVariant::Date: { editor_ = new QDateEdit; ::qt_cast( editor_ )->setOrder( QDateEdit::DMY ); ::qt_cast( editor_ )->setAutoAdvance( true ); ::qt_cast( editor_ )->setSeparator( "-" ); QDate da; ::qt_cast( editor_ )->setDate( da.currentDate() ); } break; case QVariant::Time: { editor_ = new QTimeEdit; QTime timeNow = QTime::currentTime(); ::qt_cast( editor_ ) ->setTime( timeNow ); } break; case QVariant::Bool: editor_ = new FLCheckBox( 0 ); break; } if ( editor_ ) tdbFilter->setCellWidget( i, j, editor_ ); } } for ( int k = 0; k < 5; ++k ) tdbFilter->adjustColumn( k ); } } FLTableDB::CondType FLTableDB::decodeCondType( const QString & strCondType ) const { if ( mapCondType.contains( strCondType ) ) return mapCondType[ strCondType ]; return FLTableDB::All; } QString FLTableDB::tdbFilterBuildWhere() { if ( !topWidget ) return QString::null; int rCount = tdbFilter->numRows(); if ( !rCount || !cursorVisualizacion_ ) return QString::null; FLTableMetaData *tMD = cursorVisualizacion_->metadata(); if ( !tMD ) return QString::null; FLFieldMetaData * field = 0; QComboBox * cond = 0; int type; CondType condType; QString fieldName, condValue, where, fieldArg, arg2, arg4; bool ol; for ( int i = 0; i < rCount; ++i ) { fieldName = tMD->fieldAliasToName( tdbFilter->text( i, 0 ) ); field = tMD->field( fieldName ); if ( !field ) continue; cond = ::qt_cast( tdbFilter->cellWidget( i, 1 ) ); if ( !cond ) continue; condType = decodeCondType( cond->currentText() ); if ( condType == FLTableDB::All ) continue; fieldArg = fieldName; arg2 = arg4 = QString::null; type = field->type(); ol = field->hasOptionsList(); switch ( type ) { // dpinelo: Este código así creo que es erróneo /* case QVariant::UInt: case QVariant::Int: case QVariant::Double: case QVariant::String: case QVariant::StringList: { fieldArg = "upper(" + fieldName + ")";*/ case QVariant::String: case QVariant::StringList: { fieldArg = "upper(" + fieldName + ")"; case QVariant::UInt: case QVariant::Int: case QVariant::Double: if ( ol ) { if ( condType == FLTableDB::FromTo ) { QComboBox * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 3 ) ); QComboBox * editorOp2 = ::qt_cast( tdbFilter->cellWidget( i, 4 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, editorOp1->currentText(), true ); arg4 = cursorVisualizacion_->db()->manager()->formatValue( type, editorOp2->currentText(), true ); } else { QComboBox * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 2 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, editorOp1->currentText(), true ); } } else { if ( condType == FLTableDB::FromTo ) { FLLineEdit * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 3 ) ); FLLineEdit * editorOp2 = ::qt_cast( tdbFilter->cellWidget( i, 4 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, editorOp1->text(), true ); arg4 = cursorVisualizacion_->db()->manager()->formatValue( type, editorOp2->text(), true ); } else { FLLineEdit * editorOp1 = static_cast( tdbFilter->cellWidget( i, 2 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, editorOp1->text(), true ); } } } break; case FLFieldMetaData::Serial: if ( condType == FLTableDB::FromTo ) { FLSpinBox * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 3 ) ); FLSpinBox * editorOp2 = ::qt_cast( tdbFilter->cellWidget( i, 4 ) ); arg2 = QString::number( editorOp1->value() ); arg4 = QString::number( editorOp2->value() ); } else { FLSpinBox * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 2 ) ); arg2 = QString::number( editorOp1->value() ); } break; case QVariant::Pixmap: break; case QVariant::Date: { if ( condType == FLTableDB::FromTo ) { QDateEdit * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 3 ) ); QDateEdit * editorOp2 = ::qt_cast( tdbFilter->cellWidget( i, 4 ) ); // dpinelo: He cambiado los formatos de fecha arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, QVariant( editorOp1->date().toString( "dd/MM/yyyy" ) ) ); arg4 = cursorVisualizacion_->db()->manager()->formatValue( type, QVariant( editorOp2->date().toString( "dd/MM/yyyy" ) ) ); } else { QDateEdit * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 2 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, QVariant( editorOp1->date().toString( "dd/MM/yyyy" ) ) ); } } break; case QVariant::Time: { if ( condType == FLTableDB::FromTo ) { QTimeEdit * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 3 ) ); QTimeEdit * editorOp2 = ::qt_cast( tdbFilter->cellWidget( i, 4 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, QVariant( editorOp1->time().toString( Qt::ISODate ) ) ); arg4 = cursorVisualizacion_->db()->manager()->formatValue( type, QVariant( editorOp2->time().toString( Qt::ISODate ) ) ); } else { QTimeEdit * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 2 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, QVariant( editorOp1->time().toString( Qt::ISODate ) ) ); } } break; case QVariant::Bool: { FLCheckBox * editorOp1 = ::qt_cast( tdbFilter->cellWidget( i, 2 ) ); arg2 = cursorVisualizacion_->db()->manager()->formatValue( type, QString( editorOp1->isChecked() ? tr( "Sí" ) : tr( "No" ) ) ); } break; } if ( !where.isEmpty() ) where += " and"; condValue = " " + fieldArg; if ( condType == FLTableDB::Contains ) condValue += " like '%%" + arg2.replace( "'", "" ) + "%%'"; else if ( condType == FLTableDB::Starts ) condValue += " like '" + arg2.replace( "'", "" ) + "%%'"; else if ( condType == FLTableDB::End ) condValue += " like '%%" + arg2.replace( "'", "" ) + "'"; else if ( condType == FLTableDB::Equal ) condValue += " = " + arg2; else if ( condType == FLTableDB::Dist ) condValue += " <> " + arg2; else if ( condType == FLTableDB::Greater ) condValue += " > " + arg2; else if ( condType == FLTableDB::Less ) condValue += " < " + arg2; else if ( condType == FLTableDB::FromTo ) condValue += " >= " + arg2 + " and " + fieldArg + " <= " + arg4; else if ( condType == FLTableDB::Null ) condValue += " is null "; else if ( condType == FLTableDB::NotNull ) condValue += " is not null "; where += condValue; } return where; } void FLTableDB::tdbFilterClear() { if ( !topWidget ) return; int rCount = tdbFilter->numRows(); QComboBox * cond = 0; for ( int i = 0; i < rCount; ++i ) { cond = ::qt_cast( tdbFilter->cellWidget( i, 1 ) ); cond->setCurrentItem( 0 ); } } bool FLTableDB::findHidden() const { return findHidden_; } void FLTableDB::setFindHidden( bool h ) { if ( findHidden_ != h ) { findHidden_ = h; if ( h ) FrameFind->hide(); else FrameFind->show(); } } bool FLTableDB::filterHidden() const { return filterHidden_; } void FLTableDB::setFilterHidden( bool h ) { if ( filterHidden_ != h ) { filterHidden_ = h; if ( h ) bgrDataFilter->hide(); else bgrDataFilter->show(); } } void FLTableDB::initFakeEditor() { if ( !fakeEditor_ ) { fakeEditor_ = new QTextEdit( tabData ); fakeEditor_->setSizePolicy( QSizePolicy( ( QSizePolicy::SizeType ) 7, QSizePolicy::Expanding, fakeEditor_->sizePolicy().hasHeightForWidth() ) ); ::qt_cast( fakeEditor_ )->setTabChangesFocus( true ); fakeEditor_->setFocusPolicy( QTable::StrongFocus ); setFocusProxy( fakeEditor_ ); tabDataLayout->addWidget( fakeEditor_ ); setTabOrder( fakeEditor_, lineEditSearch ); setTabOrder( fakeEditor_, comboBoxFieldToSearch ); fakeEditor_->show(); } QString prty; if ( !tableName_.isEmpty() ) prty += "tableName: " + tableName_ + "\n"; if ( !foreignField_.isEmpty() ) prty += "foreignField: " + foreignField_ + "\n"; if ( !fieldRelation_.isEmpty() ) prty += "fieldRelation: " + fieldRelation_ + "\n"; // dpinelo: Modificado para permitir que lo que se muestre en el table sea una consulta y no el contenido de una tabla if ( !qryVisualizacion_.isEmpty() ) prty += "qryVisualizacion: " + qryVisualizacion_ + "\n"; static_cast( fakeEditor_ )->setText( prty ); } // dpinelo: Agregados para visualizar datos distintos. QString FLTableDB::qryVisualizacion() const { return qryVisualizacion_; } void FLTableDB::setQryVisualizacion(const QString & fT) { qryVisualizacion_ = fT; if ( !qryVisualizacion_.isNull () && !qryVisualizacion_.isEmpty() ) { bQryVisualizacion_ = true; } else { bQryVisualizacion_ = false; } if ( showed && bQryVisualizacion_ ) { if ( topWidget ) { initCursor(); setTableRecordsCursor(); FLTableMetaData *tMD = cursorVisualizacion_->metadata(); sortField_ = tMD->field( tMD->primaryKey() ); cursorVisualizacion_->setSort( cursorVisualizacion_->index( tMD->primaryKey( ) ) ); refresh(true, true); seekCursor(); } else { initFakeEditor(); } } } void FLTableDB::registroElegido() { sincronizarCursorConVisualizacion(); cursor_->chooseRecord(); } void FLTableDB::sincronizarCursorConVisualizacion() { if ( bQryVisualizacion_ ) { FLTableMetaData * tMDVis = cursorVisualizacion_->metadata(); FLTableMetaData * tMD = cursor_->metadata(); if ( !tMD || !tMDVis ) return; FLFieldMetaData *pk = tMD->field( tMD->primaryKey() ); FLFieldMetaData *pkVis = tMDVis->field ( tMDVis->primaryKey() ); QString fN( pkVis->name() ); QString filtro = fN + " = " + cursor_->db()->manager()->formatValue( pk->type(), cursorVisualizacion_->value(fN), true ); cursor_->setFilter ( filtro ); cursor_->QSqlCursor::select( ); cursor_->first(); } } void FLTableDB::sincronizarVisualizacionConCursor() { if ( bQryVisualizacion_ ) { FLTableMetaData * tMD = cursor_->metadata(); FLFieldMetaData *pk = tMD->field ( tMD->primaryKey() ); // dpinelo: Aqui tenemos la primary key del registro seleccionado actualmente en cursor QString fN( pk->name() ); int pos = cursorVisualizacion_->atFromBinarySearch( fN, cursor_->QSqlCursor::value( fN ).toString(), orderAsc_ ); qWarning ("Valor del registro actualmente seleccionado: " + cursor_->QSqlCursor::value( fN ).toString()); cursorVisualizacion_->seek( pos, false, true ); } }