/*************************************************************************
*
* $RCSfile: dbcolect.hxx,v $
*
* $Revision: 1.8 $
*
* last change: $Author: kz $ $Date: 2005-01-14 11:58:41 $
*
* The Contents of this file are made available subject to the terms of
* either of the following licenses
*
* - GNU Lesser General Public License Version 2.1
* - Sun Industry Standards Source License Version 1.1
*
* Sun Microsystems Inc., October, 2000
*
* GNU Lesser General Public License Version 2.1
* =============================================
* Copyright 2000 by Sun Microsystems, Inc.
* 901 San Antonio Road, Palo Alto, CA 94303, USA
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License version 2.1, as published by the Free Software Foundation.
*
* This library 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 for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
*
* Sun Industry Standards Source License Version 1.1
* =================================================
* The contents of this file are subject to the Sun Industry Standards
* Source License Version 1.1 (the "License"); You may not use this file
* except in compliance with the License. You may obtain a copy of the
* License at http://www.openoffice.org/license.html.
*
* Software provided under this License is provided on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
* WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
* MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
* See the License for the specific provisions governing your rights and
* obligations concerning the Software.
*
* The Initial Developer of the Original Code is: Sun Microsystems, Inc.
*
* Copyright: 2000 by Sun Microsystems, Inc.
*
* All Rights Reserved.
*
* Contributor(s): _______________________________________
*
*
************************************************************************/
#ifndef SC_DBCOLECT_HXX
#define SC_DBCOLECT_HXX
#ifndef INCLUDED_SCDLLAPI_H
#include "scdllapi.h"
#endif
#ifndef SC_COLLECT_HXX
#include "collect.hxx"
#endif
#ifndef SC_SCGLOB_HXX
#include "global.hxx" // MAXQUERY
#endif
#ifndef SC_SORTPARAM_HXX
#include "sortparam.hxx" // MAXSORT
#endif
#ifndef SC_REFRESHTIMER_HXX
#include "refreshtimer.hxx"
#endif
#ifndef SC_ADDRESS_HXX
#include "address.hxx"
#endif
//------------------------------------------------------------------------
class ScDocument;
class ScMultipleReadHeader;
class ScMultipleWriteHeader;
//------------------------------------------------------------------------
class ScDBData : public DataObject, public ScRefreshTimer
{
private:
// DBParam
String aName;
SCTAB nTable;
SCCOL nStartCol;
SCROW nStartRow;
SCCOL nEndCol;
SCROW nEndRow;
BOOL bByRow;
BOOL bHasHeader;
BOOL bDoSize;
BOOL bKeepFmt;
BOOL bStripData;
// SortParam
BOOL bSortCaseSens;
BOOL bIncludePattern;
BOOL bSortInplace;
BOOL bSortUserDef;
USHORT nSortUserIndex;
SCTAB nSortDestTab;
SCCOL nSortDestCol;
SCROW nSortDestRow;
BOOL bDoSort[MAXSORT];
SCCOLROW nSortField[MAXSORT];
BOOL bAscending[MAXSORT];
::com::sun::star::lang::Locale aSortLocale;
String aSortAlgorithm;
// QueryParam
BOOL bQueryInplace;
BOOL bQueryCaseSens;
BOOL bQueryRegExp;
BOOL bQueryDuplicate;
SCTAB nQueryDestTab;
SCCOL nQueryDestCol;
SCROW nQueryDestRow;
BOOL bDoQuery[MAXQUERY];
SCCOLROW nQueryField[MAXQUERY];
ScQueryOp eQueryOp[MAXQUERY];
BOOL bQueryByString[MAXQUERY];
String* pQueryStr[MAXQUERY];
double nQueryVal[MAXQUERY];
ScQueryConnect eQueryConnect[MAXQUERY];
BOOL bIsAdvanced; // TRUE if created by advanced filter
ScRange aAdvSource; // source range
// SubTotalParam
BOOL bSubRemoveOnly;
BOOL bSubReplace;
BOOL bSubPagebreak;
BOOL bSubCaseSens;
BOOL bSubDoSort;
BOOL bSubAscending;
BOOL bSubIncludePattern;
BOOL bSubUserDef;
USHORT nSubUserIndex;
BOOL bDoSubTotal[MAXSUBTOTAL];
SCCOL nSubField[MAXSUBTOTAL];
SCCOL nSubTotals[MAXSUBTOTAL];
SCCOL* pSubTotals[MAXSUBTOTAL];
ScSubTotalFunc* pFunctions[MAXSUBTOTAL];
// Datenbank-Import
BOOL bDBImport;
String aDBName;
String aDBStatement;
BOOL bDBNative;
BOOL bDBSelection; // nicht im Param: Wenn Selektion, Update sperren
BOOL bDBSql; // aDBStatement ist SQL und kein Name
BYTE nDBType; // enum DBObject (bisher nur dbTable, dbQuery)
USHORT nIndex; // eindeutiger Index fuer Formeln
BOOL bAutoFilter; // AutoFilter? (nicht gespeichert)
BOOL bModified; // wird bei UpdateReference gesetzt/geloescht
public:
ScDBData(const String& rName,
SCTAB nTab,
SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2,
BOOL bByR = TRUE, BOOL bHasH = TRUE);
ScDBData(const ScDBData& rData);
ScDBData( SvStream& rStream, ScMultipleReadHeader& rHdr );
~ScDBData();
virtual DataObject* Clone() const;
ScDBData& operator= (const ScDBData& rData);
BOOL operator== (const ScDBData& rData) const;
BOOL Store( SvStream& rStream, ScMultipleWriteHeader& rHdr ) 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;
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);
BOOL IsByRow() const { return bByRow; }
void SetByRow(BOOL bByR) { bByRow = bByR; }
BOOL HasHeader() const { return bHasHeader; }
void SetHeader(BOOL bHasH) { bHasHeader = bHasH; }
void SetIndex(USHORT nInd) { nIndex = nInd; }
USHORT GetIndex() const { return nIndex; }
BOOL IsDoSize() const { return bDoSize; }
void SetDoSize(BOOL bSet) { bDoSize = bSet; }
BOOL IsKeepFmt() const { return bKeepFmt; }
void SetKeepFmt(BOOL bSet) { bKeepFmt = bSet; }
BOOL IsStripData() const { return bStripData; }
void SetStripData(BOOL bSet) { bStripData = bSet; }
BOOL IsBeyond(SCROW nMaxRow) const;
String GetSourceString() const;
String GetOperations() const;
void GetSortParam(ScSortParam& rSortParam) const;
void SetSortParam(const ScSortParam& rSortParam);
void GetQueryParam(ScQueryParam& rQueryParam) const;
void SetQueryParam(const ScQueryParam& rQueryParam);
BOOL GetAdvancedQuerySource(ScRange& rSource) const;
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);
BOOL IsDBAtCursor(SCCOL nCol, SCROW nRow, SCTAB nTab, BOOL bStartOnly) const;
BOOL IsDBAtArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2) const;
String GetTargetName(const String& rDocName) const;
BOOL HasImportParam() const { return bDBImport; }
BOOL HasQueryParam() const { return bDoQuery[0]; }
BOOL HasSortParam() const { return bDoSort[0]; }
BOOL HasSubTotalParam() const { return bDoSubTotal[0]; }
BOOL HasImportSelection() const { return bDBSelection; }
void SetImportSelection(BOOL bSet) { bDBSelection = bSet; }
BOOL HasAutoFilter() const { return bAutoFilter; }
void SetAutoFilter(BOOL bSet) { bAutoFilter = bSet; }
BOOL IsModified() const { return bModified; }
void SetModified(BOOL bMod) { bModified = bMod; }
};
//------------------------------------------------------------------------
class SC_DLLPUBLIC ScDBCollection : public SortedCollection
{
private:
Link aRefreshHandler;
ScDocument* pDoc;
USHORT nEntryIndex; // Zaehler fuer die eindeutigen Indizes
public:
ScDBCollection(USHORT nLim = 4, USHORT nDel = 4, BOOL bDup = FALSE, ScDocument* pDocument = NULL) :
SortedCollection ( nLim, nDel, bDup ),
pDoc ( pDocument ),
nEntryIndex ( SC_START_INDEX_DB_COLL ) // oberhalb der Namen
{}
ScDBCollection(const ScDBCollection& rScDBCollection) :
SortedCollection ( rScDBCollection ),
pDoc ( rScDBCollection.pDoc ),
nEntryIndex ( rScDBCollection.nEntryIndex)
{}
virtual DataObject* Clone() const { return new ScDBCollection(*this); }
ScDBData* operator[]( const USHORT nIndex) const {return (ScDBData*)At(nIndex);}
virtual short Compare(DataObject* pKey1, DataObject* pKey2) const;
virtual BOOL IsEqual(DataObject* pKey1, DataObject* pKey2) const;
ScDBData* GetDBAtCursor(SCCOL nCol, SCROW nRow, SCTAB nTab, BOOL bStartOnly) const;
ScDBData* GetDBAtArea(SCTAB nTab, SCCOL nCol1, SCROW nRow1, SCCOL nCol2, SCROW nRow2) const;
BOOL Load( SvStream& rStream );
BOOL Store( SvStream& rStream ) const;
BOOL SearchName( const String& rName, USHORT& rIndex ) const;
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(USHORT nIndex);
USHORT GetEntryIndex() { return nEntryIndex; }
void SetEntryIndex(USHORT nInd) { nEntryIndex = nInd; }
virtual BOOL Insert(DataObject* pDataObject);
void SetRefreshHandler( const Link& rLink )
{ aRefreshHandler = rLink; }
const Link& GetRefreshHandler() const { return aRefreshHandler; }
};
#endif