1*38d50f7bSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*38d50f7bSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*38d50f7bSAndrew Rist * or more contributor license agreements. See the NOTICE file 5*38d50f7bSAndrew Rist * distributed with this work for additional information 6*38d50f7bSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*38d50f7bSAndrew Rist * to you under the Apache License, Version 2.0 (the 8*38d50f7bSAndrew Rist * "License"); you may not use this file except in compliance 9*38d50f7bSAndrew Rist * with the License. You may obtain a copy of the License at 10cdf0e10cSrcweir * 11*38d50f7bSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 13*38d50f7bSAndrew Rist * Unless required by applicable law or agreed to in writing, 14*38d50f7bSAndrew Rist * software distributed under the License is distributed on an 15*38d50f7bSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*38d50f7bSAndrew Rist * KIND, either express or implied. See the License for the 17*38d50f7bSAndrew Rist * specific language governing permissions and limitations 18*38d50f7bSAndrew Rist * under the License. 19cdf0e10cSrcweir * 20*38d50f7bSAndrew Rist *************************************************************/ 21*38d50f7bSAndrew Rist 22*38d50f7bSAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir #ifndef SC_DPSDBTAB_HXX 25cdf0e10cSrcweir #define SC_DPSDBTAB_HXX 26cdf0e10cSrcweir 27cdf0e10cSrcweir #include <com/sun/star/uno/Reference.hxx> 28cdf0e10cSrcweir 29cdf0e10cSrcweir #include "dptabdat.hxx" 30cdf0e10cSrcweir 31cdf0e10cSrcweir #include <vector> 32cdf0e10cSrcweir #include <set> 33cdf0e10cSrcweir 34cdf0e10cSrcweir class ScDPCacheTable; 35cdf0e10cSrcweir class ScDocument; 36cdf0e10cSrcweir 37cdf0e10cSrcweir // -------------------------------------------------------------------- 38cdf0e10cSrcweir // 39cdf0e10cSrcweir // implementation of ScDPTableData with database data 40cdf0e10cSrcweir // 41cdf0e10cSrcweir 42cdf0e10cSrcweir struct ScImportSourceDesc 43cdf0e10cSrcweir { 44cdf0e10cSrcweir String aDBName; 45cdf0e10cSrcweir String aObject; 46cdf0e10cSrcweir sal_uInt16 nType; // enum DataImportMode 47cdf0e10cSrcweir sal_Bool bNative; 48cdf0e10cSrcweir ScImportSourceDescScImportSourceDesc49cdf0e10cSrcweir ScImportSourceDesc() : nType(0), bNative(sal_False) {} 50cdf0e10cSrcweir operator ==ScImportSourceDesc51cdf0e10cSrcweir sal_Bool operator== ( const ScImportSourceDesc& rOther ) const 52cdf0e10cSrcweir { return aDBName == rOther.aDBName && 53cdf0e10cSrcweir aObject == rOther.aObject && 54cdf0e10cSrcweir nType == rOther.nType && 55cdf0e10cSrcweir bNative == rOther.bNative; } 56cdf0e10cSrcweir 57cdf0e10cSrcweir // Wang Xu Ming -- 2009-9-15 58cdf0e10cSrcweir // DataPilot Migration - Cache&&Performance 59cdf0e10cSrcweir ScDPTableDataCache* GetExistDPObjectCache( ScDocument* pDoc ) const; 60cdf0e10cSrcweir ScDPTableDataCache* CreateCache( ScDocument* pDoc , long nID ) const; 61cdf0e10cSrcweir ScDPTableDataCache* GetCache( ScDocument* pDoc, long nID ) const; 62cdf0e10cSrcweir long GetCacheId( ScDocument* pDoc, long nID ) const; 63cdf0e10cSrcweir // End Comments 64cdf0e10cSrcweir }; 65cdf0e10cSrcweir 66cdf0e10cSrcweir class ScDatabaseDPData : public ScDPTableData 67cdf0e10cSrcweir { 68cdf0e10cSrcweir private: 69cdf0e10cSrcweir ScDPCacheTable aCacheTable; 70cdf0e10cSrcweir public: 71cdf0e10cSrcweir ScDatabaseDPData(ScDocument* pDoc, const ScImportSourceDesc& rImport, long nCacheId = -1); 72cdf0e10cSrcweir virtual ~ScDatabaseDPData(); 73cdf0e10cSrcweir 74cdf0e10cSrcweir virtual long GetColumnCount(); 75cdf0e10cSrcweir virtual String getDimensionName(long nColumn); 76cdf0e10cSrcweir virtual sal_Bool getIsDataLayoutDimension(long nColumn); 77cdf0e10cSrcweir virtual sal_Bool IsDateDimension(long nDim); 78cdf0e10cSrcweir virtual void DisposeData(); 79cdf0e10cSrcweir virtual void SetEmptyFlags( sal_Bool bIgnoreEmptyRows, sal_Bool bRepeatIfEmpty ); 80cdf0e10cSrcweir 81cdf0e10cSrcweir virtual void CreateCacheTable(); 82cdf0e10cSrcweir virtual void FilterCacheTable(const ::std::vector<ScDPCacheTable::Criterion>& rCriteria, const ::std::hash_set<sal_Int32>& rDataDims); 83cdf0e10cSrcweir virtual void GetDrillDownData(const ::std::vector<ScDPCacheTable::Criterion>& rCriteria, 84cdf0e10cSrcweir const ::std::hash_set<sal_Int32>& rCatDims, 85cdf0e10cSrcweir ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any > >& rData); 86cdf0e10cSrcweir virtual void CalcResults(CalcInfo& rInfo, bool bAutoShow); 87cdf0e10cSrcweir virtual const ScDPCacheTable& GetCacheTable() const; 88cdf0e10cSrcweir }; 89cdf0e10cSrcweir 90cdf0e10cSrcweir 91cdf0e10cSrcweir 92cdf0e10cSrcweir #endif 93