diff options
author | Timothy Pearson <kb9vqf@pearsoncomputing.net> | 2011-11-08 12:31:36 -0600 |
---|---|---|
committer | Timothy Pearson <kb9vqf@pearsoncomputing.net> | 2011-11-08 12:31:36 -0600 |
commit | d796c9dd933ab96ec83b9a634feedd5d32e1ba3f (patch) | |
tree | 6e3dcca4f77e20ec8966c666aac7c35bd4704053 /examples/sql/overview/table4 | |
download | tqt3-d796c9dd933ab96ec83b9a634feedd5d32e1ba3f.tar.gz tqt3-d796c9dd933ab96ec83b9a634feedd5d32e1ba3f.zip |
Test conversion to TQt3 from Qt3 8c6fc1f8e35fd264dd01c582ca5e7549b32ab731
Diffstat (limited to 'examples/sql/overview/table4')
-rw-r--r-- | examples/sql/overview/table4/main.cpp | 109 | ||||
-rw-r--r-- | examples/sql/overview/table4/main.h | 53 | ||||
-rw-r--r-- | examples/sql/overview/table4/table4.pro | 8 |
3 files changed, 170 insertions, 0 deletions
diff --git a/examples/sql/overview/table4/main.cpp b/examples/sql/overview/table4/main.cpp new file mode 100644 index 000000000..b557b3f1e --- /dev/null +++ b/examples/sql/overview/table4/main.cpp @@ -0,0 +1,109 @@ +/**************************************************************************** +** +** Copyright (C) 1992-2008 Trolltech ASA. All rights reserved. +** +** This file is part of an example program for TQt. This example +** program may be used, distributed and modified without limitation. +** +*****************************************************************************/ + +#include "main.h" + + +StatusPicker::StatusPicker( TQWidget *parent, const char *name ) + : TQComboBox( parent, name ) +{ + TQSqlCursor cur( "status" ); + cur.select( cur.index( "name" ) ); + + int i = 0; + while ( cur.next() ) { + insertItem( cur.value( "name" ).toString(), i ); + index2id[i] = cur.value( "id" ).toInt(); + i++; + } +} + + +int StatusPicker::statusId() const +{ + return index2id[ currentItem() ]; +} + + +void StatusPicker::setStatusId( int statusid ) +{ + TQMap<int,int>::Iterator it; + for ( it = index2id.begin(); it != index2id.end(); ++it ) { + if ( it.data() == statusid ) { + setCurrentItem( it.key() ); + break; + } + } +} + + +void CustomTable::paintField( TQPainter * p, const TQSqlField* field, + const TQRect & cr, bool b) +{ + if ( !field ) + return; + if ( field->name() == "statusid" ) { + TQSqlQuery query( "SELECT name FROM status WHERE id=" + + field->value().toString() ); + TQString text; + if ( query.next() ) { + text = query.value( 0 ).toString(); + } + p->drawText( 2,2, cr.width()-4, cr.height()-4, fieldAlignment( field ), text ); + } + else { + TQDataTable::paintField( p, field, cr, b) ; + } +} + + +TQWidget *CustomSqlEditorFactory::createEditor( + TQWidget *parent, const TQSqlField *field ) +{ + if ( field->name() == "statusid" ) { + TQWidget *editor = new StatusPicker( parent ); + return editor; + } + + return TQSqlEditorFactory::createEditor( parent, field ); +} + + +int main( int argc, char *argv[] ) +{ + TQApplication app( argc, argv ); + + if ( createConnections() ) { + TQSqlCursor staffCursor( "staff" ); + + CustomTable *staffTable = new CustomTable( &staffCursor ); + TQSqlPropertyMap *propMap = new TQSqlPropertyMap(); + CustomSqlEditorFactory *editorFactory = new CustomSqlEditorFactory(); + propMap->insert( "StatusPicker", "statusid" ); + staffTable->installPropertyMap( propMap ); + staffTable->installEditorFactory( editorFactory ); + + app.setMainWidget( staffTable ); + + staffTable->addColumn( "forename", "Forename" ); + staffTable->addColumn( "surname", "Surname" ); + staffTable->addColumn( "salary", "Annual Salary" ); + staffTable->addColumn( "statusid", "Status" ); + + TQStringList order = TQStringList() << "surname" << "forename"; + staffTable->setSort( order ); + + staffTable->refresh(); + staffTable->show(); + + return app.exec(); + } + + return 1; +} diff --git a/examples/sql/overview/table4/main.h b/examples/sql/overview/table4/main.h new file mode 100644 index 000000000..59edfc9d5 --- /dev/null +++ b/examples/sql/overview/table4/main.h @@ -0,0 +1,53 @@ +/**************************************************************************** +** +** Copyright (C) 1992-2008 Trolltech ASA. All rights reserved. +** +** This file is part of an example program for TQt. This example +** program may be used, distributed and modified without limitation. +** +*****************************************************************************/ + +#include <qapplication.h> +#include <qcombobox.h> +#include <qmap.h> +#include <qpainter.h> +#include <qsqldatabase.h> +#include <qsqlcursor.h> +#include <qsqleditorfactory.h> +#include <qsqlpropertymap.h> +#include <qdatatable.h> +#include "../connection.h" + +class StatusPicker : public TQComboBox +{ + Q_OBJECT + Q_PROPERTY( int statusid READ statusId WRITE setStatusId ) +public: + StatusPicker( TQWidget *parent=0, const char *name=0 ); + int statusId() const; + void setStatusId( int id ); +private: + TQMap< int, int > index2id; +}; + + +class CustomTable : public TQDataTable +{ + Q_OBJECT +public: + CustomTable( + TQSqlCursor *cursor, bool autoPopulate = FALSE, + TQWidget * parent = 0, const char * name = 0 ) : + TQDataTable( cursor, autoPopulate, parent, name ) {} + void paintField( + TQPainter * p, const TQSqlField* field, const TQRect & cr, bool ); + +}; + + +class CustomSqlEditorFactory : public TQSqlEditorFactory +{ + Q_OBJECT +public: + TQWidget *createEditor( TQWidget *parent, const TQSqlField *field ); +}; diff --git a/examples/sql/overview/table4/table4.pro b/examples/sql/overview/table4/table4.pro new file mode 100644 index 000000000..c490bedd0 --- /dev/null +++ b/examples/sql/overview/table4/table4.pro @@ -0,0 +1,8 @@ +TEMPLATE = app + +CONFIG += qt warn_on release + +REQUIRES = full-config + +HEADERS = main.h +SOURCES = main.cpp ../connection.cpp |