src/flbase/FLTableDB.h

Ir a la documentación de este archivo.

/***************************************************************************
                              FLTableDB.h
                          -------------------
 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.
 ***************************************************************************/

#ifndef FLTABLEDB_H
#define FLTABLEDB_H

#include <qlayout.h>
#include <qcombobox.h>
#include <qlineedit.h>
#include <qtimer.h>
#include <qvalidator.h>
#include <qstringlist.h>
#include <qwidgetstack.h>
#include <qbuttongroup.h>
#include <qprogressdialog.h>
#include "FLWidgetTableDB.h"

class FLSqlCursor;
class FLDataTable;
class FLFieldMetaData;
class FLTableDBInterface;

class FL_EXPORT FLTableDB: public FLWidgetTableDB {

  Q_OBJECT

  Q_PROPERTY( QString tableName READ tableName WRITE setTableName )
  Q_PROPERTY( QString foreignField READ foreignField WRITE setForeignField )
  Q_PROPERTY( QString fieldRelation READ fieldRelation WRITE setFieldRelation )
  Q_PROPERTY( bool checkColumnEnabled READ checkColumnEnabled WRITE setCheckColumnEnabled )
  Q_PROPERTY( QString aliasCheckColumn READ aliasCheckColumn WRITE setAliasCheckColumn )
  Q_PROPERTY( bool findHidden READ findHidden WRITE setFindHidden )
  Q_PROPERTY( bool filterHidden READ filterHidden WRITE setFilterHidden )
  Q_PROPERTY( bool showAllPixmaps READ showAllPixmaps WRITE setShowAllPixmaps )
  Q_PROPERTY( QString functionGetColor READ functionGetColor WRITE setFunctionGetColor )
  
  friend class FLTableDBInterface;
  friend class FLFormDB;

public:

  FLTableDB( QWidget * parent = 0, const char *name = 0 );

  FLDataTable * tableRecords();

  FLSqlCursor *cursor();

  QString tableName() const;

  void setTableName( const QString & fT );

  QString foreignField() const;

  void setForeignField( const QString & fN );

  QString fieldRelation() const;

  void setFieldRelation( const QString & fN );

  void setReadOnly( const bool mode );

  void setEditOnly( const bool mode );

  void setInsertOnly( const bool mode );

  void setInitSearch( const QString & iS ) {
    initSearch_ = iS;
  }

  void setOrderCols( QStringList & fields );

  QStringList orderCols();

  void setFilter( const QString &f );

  QString filter();

  QString findFilter();

  bool checkColumnEnabled() const;

  void setCheckColumnEnabled( bool b );

  QString aliasCheckColumn() const;

  void setAliasCheckColumn( const QString & t );

  bool findHidden() const;

  void setFindHidden( bool h );

  bool filterHidden() const;

  void setFilterHidden( bool h );

  bool showAllPixmaps() const;

  void setShowAllPixmaps( bool s );

  QString functionGetColor() const;

  void setFunctionGetColor( const QString & f );
  
protected:

  bool eventFilter( QObject * obj, QEvent * ev );

  void showEvent( QShowEvent * e );

private:

  enum CondType {
    All,
    Contains,
    Starts,
    End,
    Equal,
    Dist,
    Greater,
    Less,
    FromTo,
    Null,
    NotNull
  };

  void showWidget();

  void setTableRecordsCursor();

  void refreshTabData();

  void refreshTabFilter();

  FLTableDB::CondType decodeCondType( const QString & strCondType ) const;

  QString tdbFilterBuildWhere();

  void initFakeEditor();

  FLDataTable * tableRecords_;

  QString tableName_;

  QString foreignField_;

  QString fieldRelation_;

  FLSqlCursor *cursor_;

  FLSqlCursor *cursorAux;

  QWidget *topWidget;

  bool showed;

  QString filter_;

  bool readonly_;
  bool reqReadOnly_;

  bool editonly_;
  bool reqEditOnly_;

  bool insertonly_;
  bool reqInsertOnly_;

  FLFieldMetaData *sortField_;

  QTimer *timer;

  QString initSearch_;

  bool checkColumnEnabled_;

  QString aliasCheckColumn_;

  QString fieldNameCheckColumn_;

  bool checkColumnVisible_;

  int sortColumn_;

  bool orderAsc_;

  QString tdbFilterLastWhere_;

  QMap<QString, FLTableDB::CondType> mapCondType;

  bool findHidden_;

  bool filterHidden_;

  bool showAllPixmaps_;

  QString functionGetColor_;
  
  QWidget * fakeEditor_;

public slots:

  void refresh( const bool refreshHead = false, const bool refreshData = false );

  void refreshDelayed( int msec = 50, const bool refreshData = true );

  void insertRecord();

  void editRecord();

  void browseRecord();

  void deleteRecord();

  void copyRecord();

  void putFirstCol( const QString & c );

  void moveCol( const QString & from, const QString & to );

  void initCursor();

  void seekCursor();

  void setEnabled( bool );

  void setColumnWidth( const QString & field, int w );

  int columnWidth( int c );

  void setRowHeight( int row, int h );

  int rowHeight( int row );

  void exportToOds();

protected slots:

  void putFirstCol( int c );

  void moveCol( int from, int to );

  void filterRecords( const QString & p );

  void switchSortOrder( int );

  void activeTabData( bool );

  void activeTabFilter( bool );

  void tdbFilterClear();

signals:

  void readOnlyChanged( bool );

  void editOnlyChanged( bool );

  void insertOnlyChanged( bool );

  void currentChanged();
};

#endif