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
|
/* This file is part of the KDE project
Copyright 2007 Stefan Nikolaus <stefan.nikolaus@kdemail.net>
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Library General Public
License as published by the Free Software Foundation; either
version 2 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Library General Public License for more details.
You should have received a copy of the GNU Library General Public License
along with this library; see the file COPYING.LIB. If not, write to
the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
Boston, MA 02110-1301, USA.
*/
#include "DatabaseManager.h"
#include <QHash>
#include <KoXmlNS.h>
#include <KoXmlWriter.h>
#include "CellStorage.h"
#include "Database.h"
#include "Map.h"
#include "Region.h"
#include "Sheet.h"
using namespace Calligra::Sheets;
class Q_DECL_HIDDEN DatabaseManager::Private
{
public:
const Map* map;
static int s_id;
};
int DatabaseManager::Private::s_id = 1;
DatabaseManager::DatabaseManager(const Map* map)
: d(new Private)
{
d->map = map;
}
DatabaseManager::~DatabaseManager()
{
delete d;
}
QString DatabaseManager::createUniqueName() const
{
return "database-" + QString::number(Private::s_id++);
}
bool DatabaseManager::loadOdf(const KoXmlElement& body)
{
const KoXmlNode databaseRanges = KoXml::namedItemNS(body, KoXmlNS::table, "database-ranges");
KoXmlElement element;
forEachElement(element, databaseRanges) {
if (element.namespaceURI() != KoXmlNS::table)
continue;
if (element.localName() == "database-range") {
Database database;
if (!database.loadOdf(element, d->map))
return false;
const Region region = database.range();
if (!region.isValid())
continue;
const Sheet* sheet = region.lastSheet();
if (!sheet)
continue;
sheet->cellStorage()->setDatabase(region, database);
}
}
return true;
}
void DatabaseManager::saveOdf(KoXmlWriter& xmlWriter) const
{
QList< QPair<QRectF, Database> > databases;
const Region region(QRect(QPoint(1, 1), QPoint(KS_colMax, KS_rowMax)));
const QList<Sheet*>& sheets = d->map->sheetList();
for (int i = 0; i < sheets.count(); ++i)
databases << sheets[i]->cellStorage()->databases(region);
if (databases.isEmpty())
return;
xmlWriter.startElement("table:database-ranges");
for (int i = 0; i < databases.count(); ++i) {
Database database = databases[i].second;
database.setRange(Region(databases[i].first.toRect(), database.range().firstSheet()));
if (!database.range().isValid())
continue;
database.saveOdf(xmlWriter);
}
xmlWriter.endElement();
}
|
