1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 #ifndef SC_DPGROUP_HXX 25 #define SC_DPGROUP_HXX 26 27 #include <vector> 28 #include <hash_set> 29 #include <boost/shared_ptr.hpp> 30 31 #include "dptabdat.hxx" 32 #include "scdllapi.h" 33 // Wang Xu Ming -- 2009-8-17 34 // DataPilot Migration - Cache&&Performance 35 #include "dpglobal.hxx" 36 // End Comments 37 class ScDocument; 38 class SvNumberFormatter; 39 40 // -------------------------------------------------------------------- 41 42 //! API struct? 43 struct ScDPNumGroupInfo 44 { 45 sal_Bool Enable; 46 sal_Bool DateValues; 47 sal_Bool AutoStart; 48 sal_Bool AutoEnd; 49 double Start; 50 double End; 51 double Step; 52 ScDPNumGroupInfoScDPNumGroupInfo53 ScDPNumGroupInfo() : Enable(sal_False), DateValues(sal_False), AutoStart(sal_False), AutoEnd(sal_False), 54 Start(0.0), End(0.0), Step(0.0) {} 55 }; 56 57 // -------------------------------------------------------------------- 58 59 // ScDPDateGroupHelper is used as part of ScDPGroupDimension (additional dim.) 60 // or ScDPNumGroupDimension (innermost, replaces the original dim.). 61 // Source index, name and result collection are stored at the parent. 62 63 class ScDPDateGroupHelper 64 { 65 ScDPNumGroupInfo aNumInfo; // only start and end (incl. auto flags) are used 66 sal_Int32 nDatePart; // single part 67 68 public: 69 ScDPDateGroupHelper( const ScDPNumGroupInfo& rInfo, sal_Int32 nPart ); 70 ~ScDPDateGroupHelper(); 71 GetDatePart() const72 sal_Int32 GetDatePart() const { return nDatePart; } GetNumInfo() const73 const ScDPNumGroupInfo& GetNumInfo() const { return aNumInfo; } 74 75 // Wang Xu Ming -- 2009-9-8 76 // DataPilot Migration - Cache&&Performance 77 void FillColumnEntries( SCCOL nSourceDim, ScDPTableDataCache* pCahe , std::vector< SCROW >& rEntries, 78 const std::vector< SCROW >& rOriginal ) const; 79 // End Comments 80 }; 81 82 // -------------------------------------------------------------------- 83 84 typedef ::std::vector<ScDPItemData> ScDPItemDataVec; 85 86 class ScDPGroupItem 87 { 88 ScDPItemData aGroupName; // name of group item 89 ScDPItemDataVec aElements; // names of items in original dimension 90 91 public: 92 ScDPGroupItem( const ScDPItemData& rName ); 93 ~ScDPGroupItem(); 94 95 void AddElement( const ScDPItemData& rName ); 96 GetName() const97 const ScDPItemData& GetName() const { return aGroupName; } 98 bool HasElement( const ScDPItemData& rData ) const; 99 bool HasCommonElement( const ScDPGroupItem& rOther ) const; 100 101 void FillGroupFilter( ScDPCacheTable::GroupFilter& rFilter ) const; 102 }; 103 104 typedef ::std::vector<ScDPGroupItem> ScDPGroupItemVec; 105 106 class ScDPGroupDimension 107 { 108 long nSourceDim; 109 long nGroupDim; 110 String aGroupName; 111 ScDPDateGroupHelper* pDateHelper; 112 ScDPGroupItemVec aItems; 113 // Wang Xu Ming -- 2009-9-4 114 // DataPilot Migration - Cache&&Performance 115 mutable ::std::vector< SCROW > maMemberEntries; 116 // End Comments 117 public: 118 ScDPGroupDimension( long nSource, const String& rNewName ); 119 ScDPGroupDimension( const ScDPGroupDimension& rOther ); 120 ~ScDPGroupDimension(); 121 122 ScDPGroupDimension& operator=( const ScDPGroupDimension& rOther ); 123 124 void AddItem( const ScDPGroupItem& rItem ); 125 void SetGroupDim( long nDim ); // called from AddGroupDimension 126 GetSourceDim() const127 long GetSourceDim() const { return nSourceDim; } GetGroupDim() const128 long GetGroupDim() const { return nGroupDim; } GetName() const129 const String& GetName() const { return aGroupName; } 130 131 // Wang Xu Ming -- 2009-9-2 132 // DataPilot Migration - Cache&&Performance 133 const std::vector< SCROW >& GetColumnEntries( const ScDPCacheTable& rCacheTable, const std::vector< SCROW >& rOriginal ) const; 134 // End Comments 135 const ScDPGroupItem* GetGroupForData( const ScDPItemData& rData ) const; // rData = entry in original dim. 136 const ScDPGroupItem* GetGroupForName( const ScDPItemData& rName ) const; // rName = entry in group dim. 137 const ScDPGroupItem* GetGroupByIndex( size_t nIndex ) const; 138 GetDateHelper() const139 const ScDPDateGroupHelper* GetDateHelper() const { return pDateHelper; } 140 141 void MakeDateHelper( const ScDPNumGroupInfo& rInfo, sal_Int32 nPart ); 142 143 void DisposeData(); 144 GetItemCount() const145 size_t GetItemCount() const { return aItems.size(); } 146 }; 147 148 typedef ::std::vector<ScDPGroupDimension> ScDPGroupDimensionVec; 149 150 // -------------------------------------------------------------------- 151 152 class SC_DLLPUBLIC ScDPNumGroupDimension 153 { 154 ScDPNumGroupInfo aGroupInfo; // settings 155 ScDPDateGroupHelper* pDateHelper; 156 // Wang Xu Ming -- 2009-9-4 157 // DataPilot Migration - Cache&&Performance 158 mutable ::std::vector< SCROW > maMemberEntries; 159 // End Comments 160 mutable bool bHasNonInteger; // initialized in GetNumEntries 161 mutable sal_Unicode cDecSeparator; // initialized in GetNumEntries 162 163 public: 164 ScDPNumGroupDimension(); 165 ScDPNumGroupDimension( const ScDPNumGroupInfo& rInfo ); 166 ScDPNumGroupDimension( const ScDPNumGroupDimension& rOther ); 167 ~ScDPNumGroupDimension(); 168 169 ScDPNumGroupDimension& operator=( const ScDPNumGroupDimension& rOther ); 170 GetInfo() const171 const ScDPNumGroupInfo& GetInfo() const { return aGroupInfo; } HasNonInteger() const172 bool HasNonInteger() const { return bHasNonInteger; } GetDecSeparator() const173 sal_Unicode GetDecSeparator() const { return cDecSeparator; } 174 GetDateHelper() const175 const ScDPDateGroupHelper* GetDateHelper() const { return pDateHelper; } 176 177 const std::vector< SCROW >& GetNumEntries( SCCOL nSourceDim, ScDPTableDataCache* pCache, 178 const std::vector< SCROW >& rOriginal ) const; 179 180 void MakeDateHelper( const ScDPNumGroupInfo& rInfo, sal_Int32 nPart ); 181 182 void DisposeData(); 183 }; 184 185 // -------------------------------------------------------------------- 186 // 187 // proxy implementation of ScDPTableData to add grouped items 188 // 189 190 class ScDPGroupTableData : public ScDPTableData 191 { 192 typedef ::std::hash_set< ::rtl::OUString, ::rtl::OUStringHash, ::std::equal_to< ::rtl::OUString > > StringHashSet; 193 194 ::boost::shared_ptr<ScDPTableData> pSourceData; 195 long nSourceCount; 196 ScDPGroupDimensionVec aGroups; 197 ScDPNumGroupDimension* pNumGroups; // array[nSourceCount] 198 ScDocument* pDoc; 199 StringHashSet aGroupNames; 200 201 // Wang Xu Ming -- 2009-8-17 202 // DataPilot Migration - Cache&&Performance 203 void FillGroupValues( SCROW* pItemDataIndex, long nCount, const long* pDims ); 204 virtual long GetSourceDim( long nDim ); 205 // End Comments 206 207 bool IsNumGroupDimension( long nDimension ) const; 208 void GetNumGroupInfo( long nDimension, ScDPNumGroupInfo& rInfo, 209 bool& rNonInteger, sal_Unicode& rDecimal ); 210 211 void ModifyFilterCriteria(::std::vector<ScDPCacheTable::Criterion>& rCriteria); 212 213 public: 214 // takes ownership of pSource 215 ScDPGroupTableData( const ::boost::shared_ptr<ScDPTableData>& pSource, ScDocument* pDocument ); 216 virtual ~ScDPGroupTableData(); 217 218 void AddGroupDimension( const ScDPGroupDimension& rGroup ); 219 void SetNumGroupDimension( long nIndex, const ScDPNumGroupDimension& rGroup ); 220 long GetDimensionIndex( const String& rName ); 221 GetDocument()222 ScDocument* GetDocument() { return pDoc; } 223 224 virtual long GetColumnCount(); 225 // Wang Xu Ming -- 2009-8-17 226 // DataPilot Migration - Cache&&Performance 227 virtual long GetMembersCount( long nDim ); 228 virtual const std::vector< SCROW >& GetColumnEntries( long nColumn ) ; 229 virtual const ScDPItemData* GetMemberById( long nDim, long nId); 230 virtual long Compare( long nDim, long nDataId1, long nDataId2); 231 232 // End Comments 233 virtual String getDimensionName(long nColumn); 234 virtual sal_Bool getIsDataLayoutDimension(long nColumn); 235 virtual sal_Bool IsDateDimension(long nDim); 236 virtual sal_uLong GetNumberFormat(long nDim); 237 virtual void DisposeData(); 238 virtual void SetEmptyFlags( sal_Bool bIgnoreEmptyRows, sal_Bool bRepeatIfEmpty ); 239 240 virtual bool IsRepeatIfEmpty(); 241 242 virtual void CreateCacheTable(); 243 virtual void FilterCacheTable(const ::std::vector<ScDPCacheTable::Criterion>& rCriteria, const ::std::hash_set<sal_Int32>& rDataDims); 244 virtual void GetDrillDownData(const ::std::vector<ScDPCacheTable::Criterion>& rCriteria, 245 const ::std::hash_set<sal_Int32>& rCatDims, 246 ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any > >& rData); 247 virtual void CalcResults(CalcInfo& rInfo, bool bAutoShow); 248 virtual const ScDPCacheTable& GetCacheTable() const; 249 250 virtual sal_Bool IsBaseForGroup(long nDim) const; 251 virtual long GetGroupBase(long nGroupDim) const; 252 virtual sal_Bool IsNumOrDateGroup(long nDim) const; 253 virtual sal_Bool IsInGroup( const ScDPItemData& rGroupData, long nGroupIndex, 254 const ScDPItemData& rBaseData, long nBaseIndex ) const; 255 virtual sal_Bool HasCommonElement( const ScDPItemData& rFirstData, long nFirstIndex, 256 const ScDPItemData& rSecondData, long nSecondIndex ) const; 257 }; 258 259 260 #endif 261 262