sc/source/filter/xml/xmldpimp.hxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19 #pragma once
  20
  21 #include <memory>
  22 #include <xmloff/xmltoken.hxx>
  23
  24 #include <dpsave.hxx>
  25 #include <queryparam.hxx>
  26 #include "importcontext.hxx"
  27
  28 #include <unordered_map>
  29
  30 namespace com::sun::star::sheet { struct DataPilotFieldAutoShowInfo; }
  31 namespace com::sun::star::sheet { struct DataPilotFieldLayoutInfo; }
  32 namespace com::sun::star::sheet { struct DataPilotFieldReference; }
  33 namespace com::sun::star::sheet { struct DataPilotFieldSortInfo; }
  34 namespace sax_fastparser { class FastAttributeList; }
  35
  36 class ScDPSaveNumGroupDimension;
  37 class ScDPSaveGroupDimension;
  38 class ScDPObject;
  39
  40 enum ScMySourceType
  41 {
  42     SQL,
  43     TABLE,
  44     QUERY,
  45     SERVICE,
  46     CELLRANGE
  47 };
  48
  49 class ScXMLDataPilotTablesContext : public ScXMLImportContext
  50 {
  51 public:
  52
  53     ScXMLDataPilotTablesContext( ScXMLImport& rImport);
  54
  55     virtual ~ScXMLDataPilotTablesContext() override;
  56
  57     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
  58         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
  59 };
  60
  61 class ScXMLDataPilotTableContext : public ScXMLImportContext
  62 {
  63     typedef std::unordered_map<OUString, OUString> SelectedPagesType;
  64
  65     struct GrandTotalItem
  66     {
  67         OUString maDisplayName;
  68         bool            mbVisible;
  69         GrandTotalItem();
  70     };
  71     ScDocument*     pDoc;
  72     std::unique_ptr<ScDPSaveData> pDPSave;
  73     std::unique_ptr<ScDPDimensionSaveData> pDPDimSaveData;
  74     GrandTotalItem  maRowGrandTotal;
  75     GrandTotalItem  maColGrandTotal;
  76     OUString   sDataPilotTableName;
  77     OUString   sApplicationData;
  78     OUString   sDatabaseName;
  79     OUString   sSourceObject;
  80     OUString   sServiceName;
  81     OUString   sServiceSourceName;
  82     OUString   sServiceSourceObject;
  83     OUString   sServiceUsername;
  84     OUString   sServicePassword;
  85     OUString   sButtons;
  86     OUString   sSourceRangeName;
  87     ScRange         aSourceCellRangeAddress;
  88     ScRange         aTargetRangeAddress;
  89     ScQueryParam    aSourceQueryParam;
  90     ScMySourceType  nSourceType;
  91     sal_uInt32      mnRowFieldCount;
  92     sal_uInt32      mnColFieldCount;
  93     sal_uInt32      mnPageFieldCount;
  94     sal_uInt32      mnDataFieldCount;
  95     css::sheet::DataPilotFieldOrientation
  96                     mnDataLayoutType;
  97     bool            bIsNative:1;
  98     bool            bIgnoreEmptyRows:1;
  99     bool            bIdentifyCategories:1;
 100     bool            bTargetRangeAddress:1;
 101     bool            bSourceCellRange:1;
 102     bool            bShowFilter:1;
 103     bool            bDrillDown:1;
 104     bool            bHeaderGridLayout:1;
 105
 106     SelectedPagesType maSelectedPages;
 107
 108 public:
 109
 110     ScXMLDataPilotTableContext( ScXMLImport& rImport,
 111                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList );
 112
 113     virtual ~ScXMLDataPilotTableContext() override;
 114
 115     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 116         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 117
 118     virtual void SAL_CALL endFastElement( sal_Int32 nElement ) override;
 119
 120     void SetGrandTotal(::xmloff::token::XMLTokenEnum eOrientation, bool bVisible, const OUString& rDisplayName);
 121     void SetDatabaseName(const OUString& sValue) { sDatabaseName = sValue; }
 122     void SetSourceObject(const OUString& sValue) { sSourceObject = sValue; }
 123     void SetNative(bool bValue) { bIsNative = bValue; }
 124     void SetServiceName(const OUString& sValue) { sServiceName = sValue; }
 125     void SetServiceSourceName(const OUString& sValue) { sServiceSourceName = sValue; }
 126     void SetServiceSourceObject(const OUString& sValue) { sServiceSourceObject = sValue; }
 127     void SetServiceUsername(const OUString& sValue) { sServiceUsername = sValue; }
 128     void SetServicePassword(const OUString& sValue) { sServicePassword = sValue; }
 129     void SetSourceRangeName(const OUString& sValue) { sSourceRangeName = sValue; bSourceCellRange = true; }
 130     void SetSourceCellRangeAddress(const ScRange& aValue) { aSourceCellRangeAddress = aValue; bSourceCellRange = true; }
 131     void SetSourceQueryParam(const ScQueryParam& aValue) { aSourceQueryParam = aValue; }
 132     void AddDimension(ScDPSaveDimension* pDim);
 133     void AddGroupDim(const ScDPSaveNumGroupDimension& aNumGroupDim);
 134     void AddGroupDim(const ScDPSaveGroupDimension& aGroupDim);
 135     void SetButtons(ScDPObject* pDPObject);
 136     void SetSelectedPage( const OUString& rDimName, const OUString& rSelected );
 137 };
 138
 139 class ScXMLDPSourceSQLContext : public ScXMLImportContext
 140 {
 141 public:
 142
 143     ScXMLDPSourceSQLContext( ScXMLImport& rImport,
 144                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 145                         ScXMLDataPilotTableContext* pDataPilotTable);
 146
 147     virtual ~ScXMLDPSourceSQLContext() override;
 148 };
 149
 150 class ScXMLDPSourceTableContext : public ScXMLImportContext
 151 {
 152 public:
 153
 154     ScXMLDPSourceTableContext( ScXMLImport& rImport,
 155                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 156                         ScXMLDataPilotTableContext* pDataPilotTable);
 157
 158     virtual ~ScXMLDPSourceTableContext() override;
 159 };
 160
 161 class ScXMLDPSourceQueryContext : public ScXMLImportContext
 162 {
 163 public:
 164
 165     ScXMLDPSourceQueryContext( ScXMLImport& rImport,
 166                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 167                         ScXMLDataPilotTableContext* pDataPilotTable);
 168
 169     virtual ~ScXMLDPSourceQueryContext() override;
 170 };
 171
 172 class ScXMLSourceServiceContext : public ScXMLImportContext
 173 {
 174 public:
 175
 176     ScXMLSourceServiceContext( ScXMLImport& rImport,
 177                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 178                         ScXMLDataPilotTableContext* pDataPilotTable);
 179
 180     virtual ~ScXMLSourceServiceContext() override;
 181 };
 182
 183 class ScXMLDataPilotGrandTotalContext : public ScXMLImportContext
 184 {
 185     enum Orientation { COLUMN, ROW, BOTH, NONE };
 186
 187     ScXMLDataPilotTableContext* mpTableContext;
 188     OUString                    maDisplayName;
 189     Orientation                 meOrientation;
 190     bool                        mbVisible;
 191
 192 public:
 193     ScXMLDataPilotGrandTotalContext(
 194         ScXMLImport& rImport,
 195         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 196         ScXMLDataPilotTableContext* pTableContext );
 197
 198     virtual ~ScXMLDataPilotGrandTotalContext() override;
 199
 200     virtual void SAL_CALL endFastElement( sal_Int32 nElement ) override;
 201 };
 202
 203 class ScXMLSourceCellRangeContext : public ScXMLImportContext
 204 {
 205     ScXMLDataPilotTableContext* pDataPilotTable;
 206
 207 public:
 208
 209     ScXMLSourceCellRangeContext( ScXMLImport& rImport,
 210                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 211                         ScXMLDataPilotTableContext* pDataPilotTable);
 212
 213     virtual ~ScXMLSourceCellRangeContext() override;
 214
 215     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 216         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 217 };
 218
 219 struct ScXMLDataPilotGroup
 220 {
 221     ::std::vector<OUString> aMembers;
 222     OUString aName;
 223 };
 224
 225 class ScXMLDataPilotFieldContext : public ScXMLImportContext
 226 {
 227     ScXMLDataPilotTableContext* pDataPilotTable;
 228     std::unique_ptr<ScDPSaveDimension> xDim;
 229
 230     ::std::vector<ScXMLDataPilotGroup> aGroups;
 231     OUString                    sGroupSource;
 232     OUString                    sSelectedPage;
 233     OUString                    sName;
 234     double                      fStart;
 235     double                      fEnd;
 236     double                      fStep;
 237     sal_Int32                   nUsedHierarchy;
 238     sal_Int32                   nGroupPart;
 239     ScGeneralFunction           nFunction;
 240     css::sheet::DataPilotFieldOrientation
 241                                 nOrientation;
 242     bool                        bSelectedPage:1;
 243     bool                        bIsGroupField:1;
 244     bool                        bDateValue:1;
 245     bool                        bAutoStart:1;
 246     bool                        bAutoEnd:1;
 247     bool                        mbHasHiddenMember:1; // TODO: import to document core
 248
 249 public:
 250
 251     ScXMLDataPilotFieldContext( ScXMLImport& rImport,
 252                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 253                         ScXMLDataPilotTableContext* pDataPilotTable);
 254
 255     virtual ~ScXMLDataPilotFieldContext() override;
 256
 257     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 258         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 259
 260     virtual void SAL_CALL endFastElement( sal_Int32 nElement ) override;
 261
 262     void SetShowEmpty(const bool bValue) { if (xDim) xDim->SetShowEmpty(bValue); }
 263     void SetRepeatItemLabels(const bool bSet) { if (xDim) xDim->SetRepeatItemLabels(bSet); }
 264     void SetSubTotals(std::vector<ScGeneralFunction> && rFunctions) { if (xDim) xDim->SetSubTotals(std::move(rFunctions)); }
 265     void AddMember(std::unique_ptr<ScDPSaveMember> pMember);
 266     void SetSubTotalName(const OUString& rName);
 267     void SetFieldReference(const css::sheet::DataPilotFieldReference& aRef) { if (xDim) xDim->SetReferenceValue(&aRef); }
 268     void SetAutoShowInfo(const css::sheet::DataPilotFieldAutoShowInfo& aInfo) { if (xDim) xDim->SetAutoShowInfo(&aInfo); }
 269     void SetSortInfo(const css::sheet::DataPilotFieldSortInfo& aInfo) { if (xDim) xDim->SetSortInfo(&aInfo); }
 270     void SetLayoutInfo(const css::sheet::DataPilotFieldLayoutInfo& aInfo) { if (xDim) xDim->SetLayoutInfo(&aInfo); }
 271     void SetGrouping(const OUString& rGroupSource, const double& rStart, const double& rEnd, const double& rStep,
 272         sal_Int32 nPart, bool bDate, bool bAutoSt, bool bAutoE)
 273     {
 274         bIsGroupField = true;
 275         sGroupSource = rGroupSource;
 276         fStart = rStart;
 277         fEnd = rEnd;
 278         fStep = rStep;
 279         nGroupPart = nPart;
 280         bDateValue = bDate;
 281         bAutoStart = bAutoSt;
 282         bAutoEnd = bAutoE;
 283     }
 284     void AddGroup(::std::vector<OUString>&& rMembers, const OUString& rName);
 285 };
 286
 287 class ScXMLDataPilotFieldReferenceContext : public ScXMLImportContext
 288 {
 289 public:
 290
 291     ScXMLDataPilotFieldReferenceContext( ScXMLImport& rImport,
 292                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 293                         ScXMLDataPilotFieldContext* pDataPilotField);
 294
 295     virtual ~ScXMLDataPilotFieldReferenceContext() override;
 296 };
 297
 298 class ScXMLDataPilotLevelContext : public ScXMLImportContext
 299 {
 300     ScXMLDataPilotFieldContext* pDataPilotField;
 301
 302 public:
 303
 304     ScXMLDataPilotLevelContext( ScXMLImport& rImport,
 305                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 306                         ScXMLDataPilotFieldContext* pDataPilotField);
 307
 308     virtual ~ScXMLDataPilotLevelContext() override;
 309
 310     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 311         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 312 };
 313
 314 class ScXMLDataPilotDisplayInfoContext : public ScXMLImportContext
 315 {
 316 public:
 317
 318     ScXMLDataPilotDisplayInfoContext( ScXMLImport& rImport,
 319                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 320                         ScXMLDataPilotFieldContext* pDataPilotField);
 321
 322     virtual ~ScXMLDataPilotDisplayInfoContext() override;
 323 };
 324
 325 class ScXMLDataPilotSortInfoContext : public ScXMLImportContext
 326 {
 327 public:
 328
 329     ScXMLDataPilotSortInfoContext( ScXMLImport& rImport,
 330                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 331                         ScXMLDataPilotFieldContext* pDataPilotField);
 332
 333     virtual ~ScXMLDataPilotSortInfoContext() override;
 334 };
 335
 336 class ScXMLDataPilotLayoutInfoContext : public ScXMLImportContext
 337 {
 338 public:
 339
 340     ScXMLDataPilotLayoutInfoContext( ScXMLImport& rImport,
 341                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 342                         ScXMLDataPilotFieldContext* pDataPilotField);
 343
 344     virtual ~ScXMLDataPilotLayoutInfoContext() override;
 345 };
 346
 347 class ScXMLDataPilotSubTotalsContext : public ScXMLImportContext
 348 {
 349     ScXMLDataPilotFieldContext*    pDataPilotField;
 350
 351     std::vector<ScGeneralFunction> maFunctions;
 352     OUString                       maDisplayName;
 353
 354 public:
 355     ScXMLDataPilotSubTotalsContext( ScXMLImport& rImport,
 356                         ScXMLDataPilotFieldContext* pDataPilotField);
 357
 358     virtual ~ScXMLDataPilotSubTotalsContext() override;
 359
 360     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 361         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 362
 363     virtual void SAL_CALL endFastElement( sal_Int32 nElement ) override;
 364     void AddFunction(ScGeneralFunction nFunction);
 365     void SetDisplayName(const OUString& rName);
 366 };
 367
 368 class ScXMLDataPilotSubTotalContext : public ScXMLImportContext
 369 {
 370 public:
 371
 372     ScXMLDataPilotSubTotalContext( ScXMLImport& rImport,
 373                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 374                         ScXMLDataPilotSubTotalsContext* pDataPilotSubTotals);
 375
 376     virtual ~ScXMLDataPilotSubTotalContext() override;
 377 };
 378
 379 class ScXMLDataPilotMembersContext : public ScXMLImportContext
 380 {
 381     ScXMLDataPilotFieldContext* pDataPilotField;
 382
 383 public:
 384
 385     ScXMLDataPilotMembersContext( ScXMLImport& rImport,
 386                         ScXMLDataPilotFieldContext* pDataPilotField);
 387
 388     virtual ~ScXMLDataPilotMembersContext() override;
 389
 390     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 391         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 392 };
 393
 394 class ScXMLDataPilotMemberContext : public ScXMLImportContext
 395 {
 396     ScXMLDataPilotFieldContext* pDataPilotField;
 397
 398     OUString sName;
 399     OUString maDisplayName;
 400     bool     bDisplay;
 401     bool     bDisplayDetails;
 402     bool     bHasName;
 403
 404 public:
 405
 406     ScXMLDataPilotMemberContext( ScXMLImport& rImport,
 407                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 408                         ScXMLDataPilotFieldContext* pDataPilotField);
 409
 410     virtual ~ScXMLDataPilotMemberContext() override;
 411
 412     virtual void SAL_CALL endFastElement( sal_Int32 nElement ) override;
 413 };
 414
 415 class ScXMLDataPilotGroupsContext : public ScXMLImportContext
 416 {
 417     ScXMLDataPilotFieldContext* pDataPilotField;
 418
 419 public:
 420
 421     ScXMLDataPilotGroupsContext( ScXMLImport& rImport,
 422                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 423                         ScXMLDataPilotFieldContext* pDataPilotField);
 424
 425     virtual ~ScXMLDataPilotGroupsContext() override;
 426
 427     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 428         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 429 };
 430
 431 class ScXMLDataPilotGroupContext : public ScXMLImportContext
 432 {
 433     ScXMLDataPilotFieldContext* pDataPilotField;
 434
 435     OUString sName;
 436     ::std::vector<OUString> aMembers;
 437
 438 public:
 439
 440     ScXMLDataPilotGroupContext( ScXMLImport& rImport,
 441                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 442                         ScXMLDataPilotFieldContext* pDataPilotField);
 443
 444     virtual ~ScXMLDataPilotGroupContext() override;
 445
 446     virtual css::uno::Reference< css::xml::sax::XFastContextHandler > SAL_CALL createFastChildContext(
 447         sal_Int32 nElement, const css::uno::Reference< css::xml::sax::XFastAttributeList >& xAttrList ) override;
 448
 449     virtual void SAL_CALL endFastElement( sal_Int32 nElement ) override;
 450
 451     void AddMember(const OUString& sMember) { aMembers.push_back(sMember); }
 452 };
 453
 454 class ScXMLDataPilotGroupMemberContext : public ScXMLImportContext
 455 {
 456     ScXMLDataPilotGroupContext* pDataPilotGroup;
 457     OUString sName;
 458
 459 public:
 460
 461     ScXMLDataPilotGroupMemberContext( ScXMLImport& rImport,
 462                         const rtl::Reference<sax_fastparser::FastAttributeList>& rAttrList,
 463                         ScXMLDataPilotGroupContext* pDataPilotGroup);
 464
 465     virtual ~ScXMLDataPilotGroupMemberContext() override;
 466
 467     virtual void SAL_CALL endFastElement( sal_Int32 nElement ) override;
 468 };
 469
 470 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */