diff options
Diffstat (limited to 'sc/inc/dbcolect.hxx')
-rw-r--r-- | sc/inc/dbcolect.hxx | 242 |
1 files changed, 242 insertions, 0 deletions
diff --git a/sc/inc/dbcolect.hxx b/sc/inc/dbcolect.hxx new file mode 100644 index 000000000000..2398a142ee4e --- /dev/null +++ b/sc/inc/dbcolect.hxx @@ -0,0 +1,242 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * 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 + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +#ifndef SC_DBCOLECT_HXX +#define SC_DBCOLECT_HXX + +#include "scdllapi.h" +#include "collect.hxx" +#include "global.hxx" // MAXQUERY +#include "sortparam.hxx" // MAXSORT +#include "refreshtimer.hxx" +#include "address.hxx" +#include "scdllapi.h" + +//------------------------------------------------------------------------ + +class ScDocument; + +//------------------------------------------------------------------------ + +class ScDBData : public ScDataObject, public ScRefreshTimer +{ + +private: + // DBParam + String aName; + SCTAB nTable; + SCCOL nStartCol; + SCROW nStartRow; + SCCOL nEndCol; + SCROW nEndRow; + sal_Bool bByRow; + sal_Bool bHasHeader; + sal_Bool bDoSize; + sal_Bool bKeepFmt; + sal_Bool bStripData; + // SortParam + sal_Bool bSortCaseSens; + sal_Bool bIncludePattern; + sal_Bool bSortInplace; + sal_Bool bSortUserDef; + sal_uInt16 nSortUserIndex; + SCTAB nSortDestTab; + SCCOL nSortDestCol; + SCROW nSortDestRow; + sal_Bool bDoSort[MAXSORT]; + SCCOLROW nSortField[MAXSORT]; + sal_Bool bAscending[MAXSORT]; + ::com::sun::star::lang::Locale aSortLocale; + String aSortAlgorithm; + // QueryParam + sal_Bool bQueryInplace; + sal_Bool bQueryCaseSens; + sal_Bool bQueryRegExp; + sal_Bool bQueryDuplicate; + SCTAB nQueryDestTab; + SCCOL nQueryDestCol; + SCROW nQueryDestRow; + sal_Bool bDoQuery[MAXQUERY]; + SCCOLROW nQueryField[MAXQUERY]; + ScQueryOp eQueryOp[MAXQUERY]; + sal_Bool bQueryByString[MAXQUERY]; + bool bQueryByDate[MAXQUERY]; + String* pQueryStr[MAXQUERY]; + double nQueryVal[MAXQUERY]; + ScQueryConnect eQueryConnect[MAXQUERY]; + sal_Bool bIsAdvanced; // sal_True if created by advanced filter + ScRange aAdvSource; // source range + // SubTotalParam + sal_Bool bSubRemoveOnly; + sal_Bool bSubReplace; + sal_Bool bSubPagebreak; + sal_Bool bSubCaseSens; + sal_Bool bSubDoSort; + sal_Bool bSubAscending; + sal_Bool bSubIncludePattern; + sal_Bool bSubUserDef; + sal_uInt16 nSubUserIndex; + sal_Bool bDoSubTotal[MAXSUBTOTAL]; + SCCOL nSubField[MAXSUBTOTAL]; + SCCOL nSubTotals[MAXSUBTOTAL]; + SCCOL* pSubTotals[MAXSUBTOTAL]; + ScSubTotalFunc* pFunctions[MAXSUBTOTAL]; + // Datenbank-Import + sal_Bool bDBImport; + String aDBName; + String aDBStatement; + sal_Bool bDBNative; + sal_Bool bDBSelection; // nicht im Param: Wenn Selektion, Update sperren + sal_Bool bDBSql; // aDBStatement ist SQL und kein Name + sal_uInt8 nDBType; // enum DBObject (bisher nur dbTable, dbQuery) + + sal_uInt16 nIndex; // eindeutiger Index fuer Formeln + sal_Bool bAutoFilter; // AutoFilter? (nicht gespeichert) + sal_Bool bModified; // wird bei UpdateReference gesetzt/geloescht + + using ScRefreshTimer::operator==; + +public: + SC_DLLPUBLIC ScDBData(const String& rName, + SCTAB nTab, + SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2, + sal_Bool bByR = sal_True, sal_Bool bHasH = sal_True); + ScDBData(const ScDBData& rData); + ~ScDBData(); + + virtual ScDataObject* Clone() const; + + ScDBData& operator= (const ScDBData& rData); + + sal_Bool operator== (const ScDBData& rData) const; + + const String& GetName() const { return aName; } + void GetName(String& rName) const { rName = aName; } + void SetName(const String& rName) { aName = rName; } + void GetArea(SCTAB& rTab, SCCOL& rCol1, SCROW& rRow1, SCCOL& rCol2, SCROW& rRow2) const; + SC_DLLPUBLIC void GetArea(ScRange& rRange) const; + void SetArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2); + void MoveTo(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2); + sal_Bool IsByRow() const { return bByRow; } + void SetByRow(sal_Bool bByR) { bByRow = bByR; } + sal_Bool HasHeader() const { return bHasHeader; } + void SetHeader(sal_Bool bHasH) { bHasHeader = bHasH; } + void SetIndex(sal_uInt16 nInd) { nIndex = nInd; } + sal_uInt16 GetIndex() const { return nIndex; } + sal_Bool IsDoSize() const { return bDoSize; } + void SetDoSize(sal_Bool bSet) { bDoSize = bSet; } + sal_Bool IsKeepFmt() const { return bKeepFmt; } + void SetKeepFmt(sal_Bool bSet) { bKeepFmt = bSet; } + sal_Bool IsStripData() const { return bStripData; } + void SetStripData(sal_Bool bSet) { bStripData = bSet; } + +//UNUSED2008-05 sal_Bool IsBeyond(SCROW nMaxRow) const; + + String GetSourceString() const; + String GetOperations() const; + + void GetSortParam(ScSortParam& rSortParam) const; + void SetSortParam(const ScSortParam& rSortParam); + + SC_DLLPUBLIC void GetQueryParam(ScQueryParam& rQueryParam) const; + SC_DLLPUBLIC void SetQueryParam(const ScQueryParam& rQueryParam); + SC_DLLPUBLIC sal_Bool GetAdvancedQuerySource(ScRange& rSource) const; + SC_DLLPUBLIC void SetAdvancedQuerySource(const ScRange* pSource); + + void GetSubTotalParam(ScSubTotalParam& rSubTotalParam) const; + void SetSubTotalParam(const ScSubTotalParam& rSubTotalParam); + + void GetImportParam(ScImportParam& rImportParam) const; + void SetImportParam(const ScImportParam& rImportParam); + + sal_Bool IsDBAtCursor(SCCOL nCol, SCROW nRow, SCTAB nTab, sal_Bool bStartOnly) const; + sal_Bool IsDBAtArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2) const; + + sal_Bool HasImportParam() const { return bDBImport; } + sal_Bool HasQueryParam() const { return bDoQuery[0]; } + sal_Bool HasSortParam() const { return bDoSort[0]; } + sal_Bool HasSubTotalParam() const { return bDoSubTotal[0]; } + + sal_Bool HasImportSelection() const { return bDBSelection; } + void SetImportSelection(sal_Bool bSet) { bDBSelection = bSet; } + + sal_Bool HasAutoFilter() const { return bAutoFilter; } + void SetAutoFilter(sal_Bool bSet) { bAutoFilter = bSet; } + + sal_Bool IsModified() const { return bModified; } + void SetModified(sal_Bool bMod) { bModified = bMod; } +}; + + +//------------------------------------------------------------------------ +class SC_DLLPUBLIC ScDBCollection : public ScSortedCollection +{ + +private: + Link aRefreshHandler; + ScDocument* pDoc; + sal_uInt16 nEntryIndex; // Zaehler fuer die eindeutigen Indizes + +public: + ScDBCollection(sal_uInt16 nLim = 4, sal_uInt16 nDel = 4, sal_Bool bDup = sal_False, ScDocument* pDocument = NULL) : + ScSortedCollection ( nLim, nDel, bDup ), + pDoc ( pDocument ), + nEntryIndex ( SC_START_INDEX_DB_COLL ) // oberhalb der Namen + {} + ScDBCollection(const ScDBCollection& rScDBCollection) : + ScSortedCollection ( rScDBCollection ), + pDoc ( rScDBCollection.pDoc ), + nEntryIndex ( rScDBCollection.nEntryIndex) + {} + + virtual ScDataObject* Clone() const { return new ScDBCollection(*this); } + ScDBData* operator[]( const sal_uInt16 nIndex) const {return (ScDBData*)At(nIndex);} + virtual short Compare(ScDataObject* pKey1, ScDataObject* pKey2) const; + virtual sal_Bool IsEqual(ScDataObject* pKey1, ScDataObject* pKey2) const; + ScDBData* GetDBAtCursor(SCCOL nCol, SCROW nRow, SCTAB nTab, sal_Bool bStartOnly) const; + ScDBData* GetDBAtArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2) const; + + sal_Bool SearchName( const String& rName, sal_uInt16& rIndex ) const; + + void DeleteOnTab( SCTAB nTab ); + void UpdateReference(UpdateRefMode eUpdateRefMode, + SCCOL nCol1, SCROW nRow1, SCTAB nTab1, + SCCOL nCol2, SCROW nRow2, SCTAB nTab2, + SCsCOL nDx, SCsROW nDy, SCsTAB nDz ); + void UpdateMoveTab( SCTAB nOldPos, SCTAB nNewPos ); + + ScDBData* FindIndex(sal_uInt16 nIndex); + sal_uInt16 GetEntryIndex() { return nEntryIndex; } + void SetEntryIndex(sal_uInt16 nInd) { nEntryIndex = nInd; } + virtual sal_Bool Insert(ScDataObject* pScDataObject); + + void SetRefreshHandler( const Link& rLink ) + { aRefreshHandler = rLink; } + const Link& GetRefreshHandler() const { return aRefreshHandler; } +}; + +#endif |