/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2008 by Sun Microsystems, Inc. * * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: dpobject.hxx,v $ * $Revision: 1.15 $ * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License version 3 * only, as published by the Free Software Foundation. * * OpenOffice.org is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License version 3 for more details * (a copy is included in the LICENSE file that accompanied this code). * * You should have received a copy of the GNU Lesser General Public License * version 3 along with OpenOffice.org. If not, see * * for a copy of the LGPLv3 License. * ************************************************************************/ #ifndef SC_DPOBJECT_HXX #define SC_DPOBJECT_HXX #include "scdllapi.h" #include "global.hxx" #include "address.hxx" #include "collect.hxx" #include "dpoutput.hxx" #include //------------------------------------------------------------------ namespace com { namespace sun { namespace star { namespace sheet { struct DataPilotTablePositionData; struct DataPilotTableHeaderData; }}}} namespace com { namespace sun { namespace star { namespace sheet { struct DataPilotFieldFilter; }}}} class Rectangle; class SvStream; class ScDPSaveData; class ScDPOutput; class ScMultipleReadHeader; class ScMultipleWriteHeader; class ScPivot; class ScPivotCollection; struct ScPivotParam; struct ScImportSourceDesc; struct ScSheetSourceDesc; class ScStrCollection; class TypedScStrCollection; struct PivotField; class ScDPCacheTable; struct ScDPServiceDesc { String aServiceName; String aParSource; String aParName; String aParUser; String aParPass; ScDPServiceDesc( const String& rServ, const String& rSrc, const String& rNam, const String& rUser, const String& rPass ) : aServiceName( rServ ), aParSource( rSrc ), aParName( rNam ), aParUser( rUser ), aParPass( rPass ) { } BOOL operator== ( const ScDPServiceDesc& rOther ) const { return aServiceName == rOther.aServiceName && aParSource == rOther.aParSource && aParName == rOther.aParName && aParUser == rOther.aParUser && aParPass == rOther.aParPass; } }; class SC_DLLPUBLIC ScDPObject : public ScDataObject { private: ScDocument* pDoc; // settings ScDPSaveData* pSaveData; String aTableName; String aTableTag; ScRange aOutRange; ScSheetSourceDesc* pSheetDesc; // for sheet data ScImportSourceDesc* pImpDesc; // for database data ScDPServiceDesc* pServDesc; // for external service // cached data com::sun::star::uno::Reference xSource; ScDPOutput* pOutput; BOOL bSettingsChanged; BOOL bAlive; // FALSE if only used to hold settings BOOL bAllowMove; BOOL bInfoValid; // affects: nHeaderRows long nHeaderRows; // page fields plus filter button SC_DLLPRIVATE void CreateObjects(); SC_DLLPRIVATE void CreateOutput(); public: ScDPObject( ScDocument* pD ); ScDPObject(const ScDPObject& r); virtual ~ScDPObject(); virtual ScDataObject* Clone() const; void SetAlive(BOOL bSet); void SetAllowMove(BOOL bSet); void InvalidateData(); void InvalidateSource(); void Output(); ScRange GetNewOutputRange( BOOL& rOverflow ); const ScRange GetOutputRangeByType( sal_Int32 nType ); void SetSaveData(const ScDPSaveData& rData); ScDPSaveData* GetSaveData() const { return pSaveData; } void SetOutRange(const ScRange& rRange); const ScRange& GetOutRange() const { return aOutRange; } void SetSheetDesc(const ScSheetSourceDesc& rDesc); void SetImportDesc(const ScImportSourceDesc& rDesc); void SetServiceData(const ScDPServiceDesc& rDesc); void WriteSourceDataTo( ScDPObject& rDest ) const; void WriteTempDataTo( ScDPObject& rDest ) const; const ScSheetSourceDesc* GetSheetDesc() const { return pSheetDesc; } const ScImportSourceDesc* GetImportSourceDesc() const { return pImpDesc; } const ScDPServiceDesc* GetDPServiceDesc() const { return pServDesc; } com::sun::star::uno::Reference GetSource(); BOOL IsSheetData() const; BOOL IsImportData() const { return(pImpDesc != NULL); } BOOL IsServiceData() const { return(pServDesc != NULL); } void SetName(const String& rNew); const String& GetName() const { return aTableName; } void SetTag(const String& rNew); const String& GetTag() const { return aTableTag; } BOOL IsDimNameInUse( const String& rName ) const; String GetDimName( long nDim, BOOL& rIsDataLayout ); BOOL IsDuplicated( long nDim ); long GetDimCount(); void GetHeaderPositionData(const ScAddress& rPos, ::com::sun::star::sheet::DataPilotTableHeaderData& rData); long GetHeaderDim( const ScAddress& rPos, USHORT& rOrient ); BOOL GetHeaderDrag( const ScAddress& rPos, BOOL bMouseLeft, BOOL bMouseTop, long nDragDim, Rectangle& rPosRect, USHORT& rOrient, long& rDimPos ); BOOL IsFilterButton( const ScAddress& rPos ); BOOL GetPivotData( ScDPGetPivotDataField& rTarget, /* returns result */ const std::vector< ScDPGetPivotDataField >& rFilters ); BOOL ParseFilters( ScDPGetPivotDataField& rTarget, std::vector< ScDPGetPivotDataField >& rFilters, const String& rFilterList ); void GetMemberResultNames( ScStrCollection& rNames, long nDimension ); void FillPageList( TypedScStrCollection& rStrings, long nField ); void ToggleDetails(const ::com::sun::star::sheet::DataPilotTableHeaderData& rElemDesc, ScDPObject* pDestObj); BOOL FillOldParam(ScPivotParam& rParam, BOOL bForFile) const; BOOL FillLabelData(ScPivotParam& rParam); void InitFromOldPivot(const ScPivot& rOld, ScDocument* pDoc, BOOL bSetSource); BOOL GetHierarchiesNA( sal_Int32 nDim, com::sun::star::uno::Reference< com::sun::star::container::XNameAccess >& xHiers ); BOOL GetHierarchies( sal_Int32 nDim, com::sun::star::uno::Sequence< rtl::OUString >& rHiers ); sal_Int32 GetUsedHierarchy( sal_Int32 nDim ); BOOL GetMembersNA( sal_Int32 nDim, com::sun::star::uno::Reference< com::sun::star::container::XNameAccess >& xMembers ); BOOL GetMembers( sal_Int32 nDim, com::sun::star::uno::Sequence< rtl::OUString >& rMembers, com::sun::star::uno::Sequence< sal_Bool >* pVisible = 0, com::sun::star::uno::Sequence< sal_Bool >* pShowDet = 0 ); BOOL GetMembersNA( sal_Int32 nDim, sal_Int32 nHier, com::sun::star::uno::Reference< com::sun::star::container::XNameAccess >& xMembers ); BOOL GetMembers( sal_Int32 nDim, sal_Int32 nHier, com::sun::star::uno::Sequence< rtl::OUString >& rMembers, com::sun::star::uno::Sequence< sal_Bool >* pVisible = 0, com::sun::star::uno::Sequence< sal_Bool >* pShowDet = 0 ); void UpdateReference( UpdateRefMode eUpdateRefMode, const ScRange& r, SCsCOL nDx, SCsROW nDy, SCsTAB nDz ); BOOL RefsEqual( const ScDPObject& r ) const; void WriteRefsTo( ScDPObject& r ) const; void GetPositionData(const ScAddress& rPos, ::com::sun::star::sheet::DataPilotTablePositionData& rPosData); bool GetDataFieldPositionData(const ScAddress& rPos, ::com::sun::star::uno::Sequence< ::com::sun::star::sheet::DataPilotFieldFilter >& rFilters); void GetDrillDownData(const ScAddress& rPos, ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any > >& rTableData); // apply drop-down attribute, initialize nHeaderRows, without accessing the source // (button attribute must be present) void RefreshAfterLoad(); static BOOL HasRegisteredSources(); static com::sun::star::uno::Sequence GetRegisteredSources(); static com::sun::star::uno::Reference CreateSource( const ScDPServiceDesc& rDesc ); static void ConvertOrientation( ScDPSaveData& rSaveData, PivotField* pFields, SCSIZE nCount, USHORT nOrient, ScDocument* pDoc, SCROW nRow, SCTAB nTab, const com::sun::star::uno::Reference< com::sun::star::sheet::XDimensionsSupplier>& xSource, BOOL bOldDefaults, PivotField* pRefColFields = NULL, SCSIZE nRefColCount = 0, PivotField* pRefRowFields = NULL, SCSIZE nRefRowCount = 0, PivotField* pRefPageFields = NULL, SCSIZE nRefPageCount = 0 ); }; // ============================================================================ struct ScDPCacheCell { sal_Int32 mnStrId; sal_uInt8 mnType; double mfValue; bool mbNumeric; ScDPCacheCell(); ScDPCacheCell(const ScDPCacheCell& r); ~ScDPCacheCell(); }; // ============================================================================ class ScDPCollection : public ScCollection { private: ScDocument* pDoc; ScSimpleSharedString maSharedString; struct CacheCellHash { size_t operator()(const ScDPCacheCell* pCell) const; }; struct CacheCellEqual { bool operator()(const ScDPCacheCell* p1, const ScDPCacheCell* p2) const; }; typedef ::std::hash_set CacheCellPoolType; CacheCellPoolType maCacheCellPool; public: ScDPCollection(ScDocument* pDocument); ScDPCollection(const ScDPCollection& r); virtual ~ScDPCollection(); virtual ScDataObject* Clone() const; ScDPObject* operator[](USHORT nIndex) const {return (ScDPObject*)At(nIndex);} #if OLD_PIVOT_IMPLEMENTATION void ConvertOldTables( ScPivotCollection& rOldColl ); #endif void DeleteOnTab( SCTAB nTab ); void UpdateReference( UpdateRefMode eUpdateRefMode, const ScRange& r, SCsCOL nDx, SCsROW nDy, SCsTAB nDz ); BOOL RefsEqual( const ScDPCollection& r ) const; void WriteRefsTo( ScDPCollection& r ) const; String CreateNewName( USHORT nMin = 1 ) const; ScSimpleSharedString& GetSharedString(); ScDPCacheCell* getCacheCellFromPool(const ScDPCacheCell& rCell); void clearCacheCellPool(); }; #endif