sc/inc/dbcolect.hxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: dbcolect.hxx,v $
  10  * $Revision: 1.13.32.5 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 #ifndef SC_DBCOLECT_HXX
  32 #define SC_DBCOLECT_HXX
  33
  34 #include "scdllapi.h"
  35 #include "collect.hxx"
  36 #include "global.hxx"           // MAXQUERY
  37 #include "sortparam.hxx"        // MAXSORT
  38 #include "refreshtimer.hxx"
  39 #include "address.hxx"
  40 #include "scdllapi.h"
  41
  42 //------------------------------------------------------------------------
  43
  44 class ScDocument;
  45
  46 //------------------------------------------------------------------------
  47
  48 class ScDBData : public ScDataObject, public ScRefreshTimer
  49 {
  50
  51 private:
  52     // DBParam
  53     String                      aName;
  54     SCTAB                       nTable;
  55     SCCOL           nStartCol;
  56     SCROW                       nStartRow;
  57     SCCOL                       nEndCol;
  58     SCROW                       nEndRow;
  59     BOOL                        bByRow;
  60     BOOL                        bHasHeader;
  61     BOOL                        bDoSize;
  62     BOOL                        bKeepFmt;
  63     BOOL                        bStripData;
  64     // SortParam
  65     BOOL                        bSortCaseSens;
  66     BOOL                        bSortNaturalSort;
  67     BOOL                        bIncludePattern;
  68     BOOL                        bSortInplace;
  69     BOOL                        bSortUserDef;
  70     USHORT                      nSortUserIndex;
  71     SCTAB                       nSortDestTab;
  72     SCCOL                       nSortDestCol;
  73     SCROW                       nSortDestRow;
  74     BOOL                        bDoSort[MAXSORT];
  75     SCCOLROW            nSortField[MAXSORT];
  76     BOOL                        bAscending[MAXSORT];
  77     ::com::sun::star::lang::Locale aSortLocale;
  78     String                      aSortAlgorithm;
  79     // QueryParam
  80     BOOL                        bQueryInplace;
  81     BOOL                        bQueryCaseSens;
  82     BOOL                        bQueryRegExp;
  83     BOOL                        bQueryDuplicate;
  84     SCTAB                       nQueryDestTab;
  85     SCCOL                       nQueryDestCol;
  86     SCROW                       nQueryDestRow;
  87     BOOL                        bDoQuery[MAXQUERY];
  88     SCCOLROW            nQueryField[MAXQUERY];
  89     ScQueryOp           eQueryOp[MAXQUERY];
  90     BOOL                        bQueryByString[MAXQUERY];
  91     bool            bQueryByDate[MAXQUERY];
  92     String*                     pQueryStr[MAXQUERY];
  93     double                      nQueryVal[MAXQUERY];
  94     ScQueryConnect  eQueryConnect[MAXQUERY];
  95     BOOL                        bIsAdvanced;            // TRUE if created by advanced filter
  96     ScRange                     aAdvSource;                     // source range
  97     SCROW           nDynamicEndRow;
  98     // SubTotalParam
  99     BOOL                        bSubRemoveOnly;
 100     BOOL                        bSubReplace;
 101     BOOL                        bSubPagebreak;
 102     BOOL                        bSubCaseSens;
 103     BOOL                        bSubDoSort;
 104     BOOL                        bSubAscending;
 105     BOOL                        bSubIncludePattern;
 106     BOOL                        bSubUserDef;
 107     USHORT                      nSubUserIndex;
 108     BOOL                        bDoSubTotal[MAXSUBTOTAL];
 109     SCCOL                       nSubField[MAXSUBTOTAL];
 110     SCCOL                       nSubTotals[MAXSUBTOTAL];
 111     SCCOL*                      pSubTotals[MAXSUBTOTAL];
 112     ScSubTotalFunc*     pFunctions[MAXSUBTOTAL];
 113     // Datenbank-Import
 114     BOOL                        bDBImport;
 115     String                      aDBName;
 116     String                      aDBStatement;
 117     BOOL                        bDBNative;
 118     BOOL                        bDBSelection;           // nicht im Param: Wenn Selektion, Update sperren
 119     BOOL                        bDBSql;                         // aDBStatement ist SQL und kein Name
 120     BYTE                        nDBType;                        // enum DBObject (bisher nur dbTable, dbQuery)
 121
 122     USHORT                      nIndex;                         // eindeutiger Index fuer Formeln
 123     BOOL                        bAutoFilter;            // AutoFilter? (nicht gespeichert)
 124     BOOL                        bModified;                      // wird bei UpdateReference gesetzt/geloescht
 125
 126     using ScRefreshTimer::operator==;
 127
 128 public:
 129             SC_DLLPUBLIC ScDBData(const String& rName,
 130                      SCTAB nTab,
 131                      SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2,
 132                      BOOL bByR = TRUE, BOOL bHasH = TRUE);
 133             ScDBData(const ScDBData& rData);
 134             ~ScDBData();
 135
 136     virtual     ScDataObject*   Clone() const;
 137
 138             ScDBData&   operator= (const ScDBData& rData);
 139
 140             BOOL                operator== (const ScDBData& rData) const;
 141
 142             const String& GetName() const                               { return aName; }
 143             void                GetName(String& rName) const    { rName = aName; }
 144             void                SetName(const String& rName)    { aName = rName; }
 145                         void            GetArea(SCTAB& rTab, SCCOL& rCol1, SCROW& rRow1, SCCOL& rCol2, SCROW& rRow2, bool bUseDynamicRange = false) const;
 146                         SC_DLLPUBLIC void               GetArea(ScRange& rRange, bool bUseDynamicRange = false) const;
 147             void                SetArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2);
 148             void        SetDynamicEndRow(SCROW nRow);
 149             void                MoveTo(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2);
 150             BOOL                IsByRow() const                                 { return bByRow; }
 151             void                SetByRow(BOOL bByR)                     { bByRow = bByR; }
 152             BOOL                HasHeader() const                               { return bHasHeader; }
 153             void                SetHeader(BOOL bHasH)                   { bHasHeader = bHasH; }
 154             void        SetIndex(USHORT nInd)           { nIndex = nInd; }
 155             USHORT              GetIndex() const                                { return nIndex; }
 156             BOOL                IsDoSize() const                                { return bDoSize; }
 157             void                SetDoSize(BOOL bSet)                    { bDoSize = bSet; }
 158             BOOL                IsKeepFmt() const                               { return bKeepFmt; }
 159             void                SetKeepFmt(BOOL bSet)                   { bKeepFmt = bSet; }
 160             BOOL                IsStripData() const                             { return bStripData; }
 161             void                SetStripData(BOOL bSet)                 { bStripData = bSet; }
 162
 163 //UNUSED2008-05  BOOL           IsBeyond(SCROW nMaxRow) const;
 164
 165             String              GetSourceString() const;
 166             String              GetOperations() const;
 167
 168             void                GetSortParam(ScSortParam& rSortParam) const;
 169             void                SetSortParam(const ScSortParam& rSortParam);
 170
 171             SC_DLLPUBLIC void           GetQueryParam(ScQueryParam& rQueryParam) const;
 172             SC_DLLPUBLIC void           SetQueryParam(const ScQueryParam& rQueryParam);
 173             SC_DLLPUBLIC BOOL           GetAdvancedQuerySource(ScRange& rSource) const;
 174             SC_DLLPUBLIC void           SetAdvancedQuerySource(const ScRange* pSource);
 175
 176             void                GetSubTotalParam(ScSubTotalParam& rSubTotalParam) const;
 177             void                SetSubTotalParam(const ScSubTotalParam& rSubTotalParam);
 178
 179             void                GetImportParam(ScImportParam& rImportParam) const;
 180             void                SetImportParam(const ScImportParam& rImportParam);
 181
 182             BOOL                IsDBAtCursor(SCCOL nCol, SCROW nRow, SCTAB nTab, BOOL bStartOnly) const;
 183             BOOL                IsDBAtArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2) const;
 184
 185             BOOL                HasImportParam() const   { return bDBImport; }
 186             BOOL                HasQueryParam() const    { return bDoQuery[0]; }
 187             BOOL                HasSortParam() const     { return bDoSort[0]; }
 188             BOOL                HasSubTotalParam() const { return bDoSubTotal[0]; }
 189
 190             BOOL                HasImportSelection() const              { return bDBSelection; }
 191             void                SetImportSelection(BOOL bSet)   { bDBSelection = bSet; }
 192
 193             BOOL                HasAutoFilter() const           { return bAutoFilter; }
 194             void                SetAutoFilter(BOOL bSet)        { bAutoFilter = bSet; }
 195
 196             BOOL                IsModified() const                      { return bModified; }
 197             void                SetModified(BOOL bMod)          { bModified = bMod; }
 198 };
 199
 200
 201 //------------------------------------------------------------------------
 202 class SC_DLLPUBLIC ScDBCollection : public ScSortedCollection
 203 {
 204
 205 private:
 206     Link                aRefreshHandler;
 207     ScDocument* pDoc;
 208     USHORT nEntryIndex;                 // Zaehler fuer die eindeutigen Indizes
 209
 210 public:
 211     ScDBCollection(USHORT nLim = 4, USHORT nDel = 4, BOOL bDup = FALSE, ScDocument* pDocument = NULL) :
 212                     ScSortedCollection  ( nLim, nDel, bDup ),
 213                     pDoc                                ( pDocument ),
 214                     nEntryIndex                 ( SC_START_INDEX_DB_COLL )      // oberhalb der Namen
 215                     {}
 216     ScDBCollection(const ScDBCollection& rScDBCollection) :
 217                     ScSortedCollection  ( rScDBCollection ),
 218                     pDoc                                ( rScDBCollection.pDoc ),
 219                     nEntryIndex                 ( rScDBCollection.nEntryIndex)
 220                     {}
 221
 222     virtual     ScDataObject*   Clone() const { return new ScDBCollection(*this); }
 223             ScDBData*   operator[]( const USHORT nIndex) const {return (ScDBData*)At(nIndex);}
 224     virtual     short           Compare(ScDataObject* pKey1, ScDataObject* pKey2) const;
 225     virtual     BOOL            IsEqual(ScDataObject* pKey1, ScDataObject* pKey2) const;
 226             ScDBData*   GetDBAtCursor(SCCOL nCol, SCROW nRow, SCTAB nTab, BOOL bStartOnly) const;
 227             ScDBData*   GetDBAtArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2) const;
 228
 229     BOOL        SearchName( const String& rName, USHORT& rIndex ) const;
 230
 231     void    DeleteOnTab( SCTAB nTab );
 232     void        UpdateReference(UpdateRefMode eUpdateRefMode,
 233                                 SCCOL nCol1, SCROW nRow1, SCTAB nTab1,
 234                                 SCCOL nCol2, SCROW nRow2, SCTAB nTab2,
 235                                 SCsCOL nDx, SCsROW nDy, SCsTAB nDz );
 236     void        UpdateMoveTab( SCTAB nOldPos, SCTAB nNewPos );
 237
 238     ScDBData* FindIndex(USHORT nIndex);
 239     USHORT      GetEntryIndex()                                 { return nEntryIndex; }
 240     void        SetEntryIndex(USHORT nInd)              { nEntryIndex = nInd; }
 241     virtual BOOL Insert(ScDataObject* pScDataObject);
 242
 243     void                        SetRefreshHandler( const Link& rLink )
 244                         { aRefreshHandler = rLink; }
 245     const Link&         GetRefreshHandler() const       { return aRefreshHandler; }
 246 };
 247
 248 #endif