1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
|
/**
* SPDX-FileCopyrightText: 2001-2015 Klaralvdalens Datakonsult AB. All rights reserved.
*
* This file is part of the KD Chart library.
*
* SPDX-License-Identifier: GPL-2.0-or-later
*/
#include "TableModel.h"
#include <QtGlobal>
#include <QtDebug>
#include <QFile>
#include <QByteArray>
#include <QString>
TableModel::TableModel( QObject* parent )
: QAbstractTableModel( parent ),
m_dataHasHorizontalHeaders( true ),
m_dataHasVerticalHeaders( true ),
m_supplyHeaderData( true )
{
}
TableModel::~TableModel()
{
}
int TableModel::rowCount( const QModelIndex& ) const
{
return m_rows.size();
}
int TableModel::columnCount( const QModelIndex& ) const
{
return m_rows.isEmpty() ? 0 : m_rows.first().size();
}
QVariant TableModel::data( const QModelIndex& index, int role ) const
{
// FIXME kchart queries (-1, -1) for empty models
if ( index.row() == -1 || index.column() == -1 ) {
qDebug() << "TableModel::data: row:"
<< index.row() << ", column:" << index.column()
<< ", rowCount:" << rowCount() << ", columnCount:"
<< columnCount()
<< "\nTableModel::data: FIXME fix kchart views to not query"
" model data for invalid indices!";
return QVariant();
}
/* qDebug () << "TableModel::data: row: "<< index.row() << ", column: "
<< index.column() << endl;*/
Q_ASSERT( index.row() >= 0 && index.row() < rowCount() );
Q_ASSERT( index.column() >= 0 && index.column() < columnCount() );
if ( role == Qt::DisplayRole || role == Qt::EditRole ) {
return m_rows[ index.row() ][ index.column() ];
} else {
return QVariant();
}
}
QVariant TableModel::headerData( int section, Qt::Orientation orientation, int role ) const
{
QVariant result;
switch ( role ) {
case Qt::DisplayRole:
case Qt::EditRole:
if ( m_supplyHeaderData ) {
if ( orientation == Qt::Horizontal ) {
// column header data
if ( !m_horizontalHeaderData.isEmpty() )
result = m_horizontalHeaderData[ section ];
} else {
// row header data:
if ( !m_verticalHeaderData.isEmpty() )
result = m_verticalHeaderData[ section ];
}
}
break;
case Qt::TextAlignmentRole:
// result = QVariant ( Qt::AlignHCenter | Qt::AlignHCenter );
break;
case Qt::DecorationRole:
case Qt::ToolTipRole:
break;
default:
// qDebug () << "TableModel::headerData: unknown role " << role << "." << endl;
break;
}
return result;
}
bool TableModel::setData( const QModelIndex& index, const QVariant& value, int role/* = Qt::EditRole */ )
{
Q_ASSERT( index.row() >= 0 && index.row() < rowCount() );
Q_ASSERT( index.column() >= 0 && index.column() < columnCount() );
if ( role == Qt::EditRole ) {
m_rows[ index.row() ][ index.column() ] = value;
Q_EMIT dataChanged( index, index );
return true;
} else {
return false;
}
}
static QStringList splitLine( const QString& line )
{
QStringList sl = line.split( QChar( ',' ) );
QStringList ret;
for ( int i = 0; i < sl.size(); i++ ) {
// get rid of leading and trailing whitespace and quotes
QString s = sl.at( i ).simplified();
if ( s.startsWith( '\"') ) {
s.remove( 0, 1 );
}
if ( s.endsWith( '\"') ) {
s.remove( s.length() - 1, 1 );
}
ret.append( s );
}
return ret;
}
bool TableModel::loadFromCSV( const QString& filename )
{
QFile file( filename );
if ( !file.exists() || !file.open ( QIODevice::ReadOnly ) ) {
qDebug() << "TableModel::loadFromCSV: file" << filename
<< "does not exist or could not be opened";
return false;
}
QStringList lines;
while ( !file.atEnd() ) {
lines.append( QString::fromUtf8( file.readLine() ) );
}
setTitleText( QString() );
m_rows.clear();
m_rows.resize( qMax( 0, lines.size() - ( m_dataHasHorizontalHeaders ? 1 : 0 ) ) );
for ( int row = 0; row < lines.size(); ++row ) {
QStringList cells = splitLine( lines.at( row ) );
QVector<QVariant> values( qMax( 0, cells.size() - ( m_dataHasVerticalHeaders ? 1 : 0 ) ) );
for ( int column = 0; column < cells.size(); ++column ) {
QString cell = cells.at( column );
if ( row == 0 && m_dataHasHorizontalHeaders ) {
// interpret the first row as column headers:
// the first one is an exception: interpret that as title
if ( column == 0 && m_dataHasVerticalHeaders ) {
setTitleText( cell );
} else {
m_horizontalHeaderData.append( cell );
}
} else {
if ( column == 0 && m_dataHasVerticalHeaders ) {
// interpret first column as row headers:
m_verticalHeaderData.append( cell );
} else {
// try to interpret cell values as floating point
bool convertedOk = false;
qreal numeric = cell.toDouble( &convertedOk );
const int destColumn = column - ( m_dataHasVerticalHeaders ? 1 : 0 );
values[ destColumn ] = convertedOk ? numeric : ( cell.isEmpty() ? QVariant() : cell );
}
}
}
const int destRow = row - ( m_dataHasHorizontalHeaders ? 1 : 0 );
if ( destRow >= 0 ) {
m_rows[ destRow ] = values;
}
}
beginResetModel();
endResetModel();
if ( m_rows.isEmpty() ) {
qDebug() << "TableModel::loadFromCSV: table loaded, but no "
"model data found.";
}
return true;
}
void TableModel::clear()
{
beginResetModel();
m_rows.clear();
endResetModel();
}
|
