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