diff options
Diffstat (limited to 'sc/inc/dpcache.hxx')
-rw-r--r-- | sc/inc/dpcache.hxx | 215 |
1 files changed, 215 insertions, 0 deletions
diff --git a/sc/inc/dpcache.hxx b/sc/inc/dpcache.hxx new file mode 100644 index 0000000000..e46e38f66a --- /dev/null +++ b/sc/inc/dpcache.hxx @@ -0,0 +1,215 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ +#pragma once + +#include "address.hxx" +#include "calcmacros.hxx" +#include "dpitemdata.hxx" +#include "dpnumgroupinfo.hxx" +#include "scdllapi.h" +#include "types.hxx" + +#include <mdds/flat_segment_tree.hpp> +#include <tools/long.hxx> +#include <o3tl/sorted_vector.hxx> + +#include <memory> +#include <unordered_set> +#include <vector> + +struct ScQueryParam; +class ScDPObject; +class ScDocument; +class SvNumberFormatter; + +enum class SvNumFormatType : sal_Int16; + +/** + * This class represents the cached data part of the datapilot cache table + * implementation. + */ +class SC_DLLPUBLIC ScDPCache +{ +public: + typedef std::unordered_set<OUString> StringSetType; + typedef mdds::flat_segment_tree<SCROW, bool> EmptyRowsType; + typedef std::vector<ScDPItemData> ScDPItemDataVec; + typedef o3tl::sorted_vector<ScDPObject*> ScDPObjectSet; + typedef std::vector<SCROW> IndexArrayType; + + struct SAL_DLLPRIVATE GroupItems + { + ScDPItemDataVec maItems; + ScDPNumGroupInfo maInfo; + sal_Int32 mnGroupType; + + GroupItems(); + GroupItems(const GroupItems&) = delete; + const GroupItems& operator=(const GroupItems&) = delete; + GroupItems(const ScDPNumGroupInfo& rInfo, sal_Int32 nGroupType); + }; + + struct SAL_DLLPRIVATE Field + { + /** + * Optional items for grouped field. + */ + std::unique_ptr<GroupItems> mpGroup; + + /** + * Unique values in the field, stored in ascending order. + */ + ScDPItemDataVec maItems; + + /** + * Original source data represented as indices to the unique value + * list. The order of the data is as they appear in the original + * data source. + */ + IndexArrayType maData; + + sal_uInt32 mnNumFormat; + + Field(); + Field(const Field&) = delete; + const Field& operator=(const Field&) = delete; + }; + + /** + * Interface for connecting to database source. Column index is 0-based. + */ + class DBConnector + { + public: + virtual tools::Long getColumnCount() const = 0; + virtual OUString getColumnLabel(tools::Long nCol) const = 0; + virtual bool first() = 0; + virtual bool next() = 0; + virtual void finish() = 0; + virtual void getValue(tools::Long nCol, ScDPItemData& rData, SvNumFormatType& rNumType) const = 0; + virtual ~DBConnector() {} + }; + +private: + + ScDocument& mrDoc; + SCCOL mnColumnCount; + + /** + * All pivot table objects that references this cache. + */ + mutable ScDPObjectSet maRefObjects; + + typedef std::vector< std::unique_ptr<Field> > FieldsType; + typedef std::vector< std::unique_ptr<GroupItems> > GroupFieldsType; + + FieldsType maFields; + GroupFieldsType maGroupFields; + std::vector<StringSetType> maStringPools; // one for each field. + + std::vector<OUString> maLabelNames; // Stores dimension names and the data layout dimension name at position 0. + EmptyRowsType maEmptyRows; + SCROW mnDataSize; + SCROW mnRowCount; + + bool mbDisposing; + +public: + rtl_uString* InternString( size_t nDim, const OUString& rStr ); + void AddReference(ScDPObject* pObj) const; + void RemoveReference(ScDPObject* pObj) const; + const ScDPObjectSet& GetAllReferences() const; + + SCROW GetIdByItemData(tools::Long nDim, const ScDPItemData& rItem) const; + + static sal_uInt32 GetLocaleIndependentFormat( SvNumberFormatter& rFormatter, sal_uInt32 nNumFormat ); + static OUString GetLocaleIndependentFormattedNumberString( double fValue ); + static OUString GetLocaleIndependentFormattedString( double fValue, SvNumberFormatter& rFormatter, sal_uInt32 nNumFormat ); + OUString GetFormattedString(tools::Long nDim, const ScDPItemData& rItem, bool bLocaleIndependent) const; + SvNumberFormatter* GetNumberFormatter() const; + + tools::Long AppendGroupField(); + void ResetGroupItems(tools::Long nDim, const ScDPNumGroupInfo& rNumInfo, sal_Int32 nGroupType); + SCROW SetGroupItem(tools::Long nDim, const ScDPItemData& rData); + void GetGroupDimMemberIds(tools::Long nDim, std::vector<SCROW>& rIds) const; + void ClearGroupFields(); + void ClearAllFields(); + const ScDPNumGroupInfo* GetNumGroupInfo(tools::Long nDim) const; + + /** + * Return a group type identifier. The values correspond with + * css::sheet::DataPilotFieldGroupBy constant values. + * + * @param nDim 0-based dimension index. + * + * @return group type identifier, or 0 on failure. + */ + sal_Int32 GetGroupType(tools::Long nDim) const; + + SCCOL GetDimensionIndex(std::u16string_view sName) const; + sal_uInt32 GetNumberFormat( tools::Long nDim ) const; + bool IsDateDimension( tools::Long nDim ) const ; + tools::Long GetDimMemberCount(tools::Long nDim) const; + + const IndexArrayType* GetFieldIndexArray( size_t nDim ) const; + const ScDPItemDataVec& GetDimMemberValues( SCCOL nDim ) const; + void InitFromDoc(ScDocument& rDoc, const ScRange& rRange); + bool InitFromDataBase(DBConnector& rDB); + + /** + * Row count is the number of records plus any trailing empty rows in case + * the source data is sheet and contains trailing empty rows. + */ + SCROW GetRowCount() const; + + /** + * Data size is the number of records without any trailing empty rows for + * sheet source data. For any other source type, this should equal the + * row count. + */ + SCROW GetDataSize() const; + SCROW GetItemDataId( sal_uInt16 nDim, SCROW nRow, bool bRepeatIfEmpty ) const; + OUString GetDimensionName(std::vector<OUString>::size_type nDim) const; + bool IsRowEmpty(SCROW nRow) const; + bool ValidQuery(SCROW nRow, const ScQueryParam& rQueryParam) const; + + ScDocument& GetDoc() const; + tools::Long GetColumnCount() const; + + const ScDPItemData* GetItemDataById( tools::Long nDim, SCROW nId ) const; + + size_t GetFieldCount() const; + size_t GetGroupFieldCount() const; + + ScDPCache(const ScDPCache&) = delete; + const ScDPCache& operator=(const ScDPCache&) = delete; + ScDPCache(ScDocument& rDoc); + ~ScDPCache(); + +#if DUMP_PIVOT_TABLE + void Dump() const; +#endif + +private: + void PostInit(); + void Clear(); + const GroupItems* GetGroupItems(tools::Long nDim) const; +}; + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |