summaryrefslogtreecommitdiffstats
path: root/sc/inc/dpfilteredcache.hxx
diff options
context:
space:
mode:
Diffstat (limited to 'sc/inc/dpfilteredcache.hxx')
-rw-r--r--sc/inc/dpfilteredcache.hxx175
1 files changed, 175 insertions, 0 deletions
diff --git a/sc/inc/dpfilteredcache.hxx b/sc/inc/dpfilteredcache.hxx
new file mode 100644
index 000000000..e7737141d
--- /dev/null
+++ b/sc/inc/dpfilteredcache.hxx
@@ -0,0 +1,175 @@
+/* -*- 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 <sal/types.h>
+#include "dpitemdata.hxx"
+#include "calcmacros.hxx"
+#include "types.hxx"
+
+#include <unordered_set>
+#include <vector>
+
+#include <mdds/flat_segment_tree.hpp>
+
+namespace com::sun::star::uno
+{
+class Any;
+}
+namespace com::sun::star::uno
+{
+template <typename> class Sequence;
+}
+
+class ScDPCache;
+struct ScDPValue;
+struct ScQueryParam;
+
+/**
+ * This class is only a wrapper to the actual cache, to provide filtering on
+ * the raw data based on the query filter and/or page field filters.
+ */
+class ScDPFilteredCache
+{
+ typedef mdds::flat_segment_tree<SCROW, bool> RowFlagType;
+
+public:
+ /** interface class used for filtering of rows. */
+ class FilterBase
+ {
+ public:
+ virtual ~FilterBase() {}
+ /** returns true if the matching condition is met for a single cell
+ value, or false otherwise. */
+ virtual bool match(const ScDPItemData& rCellData) const = 0;
+
+ virtual std::vector<ScDPItemData> getMatchValues() const = 0;
+ };
+
+ /** ordinary single-item filter. */
+ class SingleFilter final : public FilterBase
+ {
+ public:
+ explicit SingleFilter(const ScDPItemData& rItem);
+
+ virtual bool match(const ScDPItemData& rCellData) const override;
+ virtual std::vector<ScDPItemData> getMatchValues() const override;
+
+ private:
+ ScDPItemData maItem;
+ };
+
+ /** multi-item (group) filter. */
+ class GroupFilter final : public FilterBase
+ {
+ public:
+ GroupFilter();
+ virtual bool match(const ScDPItemData& rCellData) const override;
+ virtual std::vector<ScDPItemData> getMatchValues() const override;
+ void addMatchItem(const ScDPItemData& rItem);
+ size_t getMatchItemCount() const;
+
+ private:
+ ::std::vector<ScDPItemData> maItems;
+ };
+
+ /** single filtering criterion. */
+ struct Criterion
+ {
+ sal_Int32 mnFieldIndex;
+ std::shared_ptr<FilterBase> mpFilter;
+
+ Criterion();
+ };
+
+ ScDPFilteredCache(const ScDPCache& rCache);
+ ~ScDPFilteredCache();
+
+ sal_Int32 getRowSize() const;
+ sal_Int32 getColSize() const;
+
+ const ScDPCache& getCache() const { return mrCache; }
+
+ void fillTable(const ScQueryParam& rQuery, bool bIgnoreEmptyRows, bool bRepeatIfEmpty);
+
+ void fillTable();
+
+ /** Check whether a specified row is active or not. When a row is active,
+ it is used in calculation of the results data. A row becomes inactive
+ when it is filtered out by page field. */
+ bool isRowActive(sal_Int32 nRow, sal_Int32* pLastRow = nullptr) const;
+
+ /** Set filter on/off flag to each row to control visibility. The caller
+ must ensure that the table is filled before calling this function. */
+ void filterByPageDimension(const std::vector<Criterion>& rCriteria,
+ const std::unordered_set<sal_Int32>& rRepeatIfEmptyDims);
+
+ /** Get the cell instance at specified location within the data grid. Note
+ that the data grid doesn't include the header row. Don't delete the
+ returned object! */
+ const ScDPItemData* getCell(SCCOL nCol, SCROW nRow, bool bRepeatIfEmpty) const;
+ void getValue(ScDPValue& rVal, SCCOL nCol, SCROW nRow) const;
+ OUString getFieldName(SCCOL nIndex) const;
+
+ /** Get the unique entries for a field specified by index. The caller must
+ make sure that the table is filled before calling function, or it will
+ get an empty collection. */
+ const ::std::vector<SCROW>& getFieldEntries(sal_Int32 nColumn) const;
+
+ /** Filter the table based on the specified criteria, and copy the
+ result to rTabData. This method is used, for example, to generate
+ a drill-down data table. */
+ void filterTable(const std::vector<Criterion>& rCriteria,
+ css::uno::Sequence<css::uno::Sequence<css::uno::Any>>& rTabData,
+ const std::unordered_set<sal_Int32>& rRepeatIfEmptyDims);
+
+ void clear();
+ bool empty() const;
+
+#if DUMP_PIVOT_TABLE
+ static void dumpRowFlag(const RowFlagType& rFlag);
+ void dump() const;
+#endif
+
+private:
+ ScDPFilteredCache(const ScDPFilteredCache&) = delete;
+
+ /**
+ * Check if a given row meets all specified criteria.
+ *
+ * @param nRow index of row to be tested.
+ * @param rCriteria a list of criteria
+ */
+ bool isRowQualified(sal_Int32 nRow, const ::std::vector<Criterion>& rCriteria,
+ const std::unordered_set<sal_Int32>& rRepeatIfEmptyDims) const;
+
+private:
+ /** unique field entries for each field (column). */
+ ::std::vector<::std::vector<SCROW>> maFieldEntries;
+
+ /** Rows visible by standard filter query. */
+ RowFlagType maShowByFilter;
+ /** Rows visible by page dimension filtering. */
+ RowFlagType maShowByPage;
+
+ const ScDPCache& mrCache;
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */