1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
|
/*************************************************************************
*
* $RCSfile: SelectionBrowseBox.hxx,v $
*
* $Revision: 1.6 $
*
* last change: $Author: fs $ $Date: 2001-06-29 08:40:31 $
*
* 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 DBAUI_QUERYDESIGN_OSELECTIONBROWSEBOX_HXX
#define DBAUI_QUERYDESIGN_OSELECTIONBROWSEBOX_HXX
#ifndef _SVTOOLS_EDITBROWSEBOX_HXX_
#include <svtools/editbrowsebox.hxx>
#endif
#ifndef _VECTOR_
#include <vector>
#endif
#ifndef DBAUI_TABLEFIELDDESC_HXX
#include "TableFieldDescription.hxx"
#endif
#ifndef DBAUI_JOINEXCHANGE_HXX
#include "JoinExchange.hxx"
#endif
#ifndef DBAUI_ENUMTYPES_HXX
#include "QEnumTypes.hxx"
#endif
#ifndef _COM_SUN_STAR_UTIL_XNUMBERFORMATTER_HPP_
#include <com/sun/star/util/XNumberFormatter.hpp>
#endif
#ifndef _STRING_HXX
#include <tools/string.hxx>
#endif
#ifndef _TRANSFER_HXX
#include <svtools/transfer.hxx>
#endif
namespace dbaui
{
//==================================================================
#define SIZ_NONE 0
#define SIZ_TOP 1
#define SIZ_BOTTOM 2
#define SIZ_LEFT 4
#define SIZ_RIGHT 8
#define BROW_FIELD_ROW 0
#define BROW_COLUMNALIAS_ROW 1
#define BROW_TABLE_ROW 2
#define BROW_ORDER_ROW 3
#define BROW_VIS_ROW 4
#define BROW_FUNCTION_ROW 5
#define BROW_CRIT1_ROW 6
#define BROW_CRIT2_ROW 7
#define BROW_CRIT3_ROW 8
#define BROW_CRIT4_ROW 9
#define BROW_CRIT5_ROW 10
#define BROW_CRIT6_ROW 11
#define BROW_ROW_CNT 12
//==================================================================
class OQueryDesignView;
class OSelectionBrowseBox : public ::svt::EditBrowseBox
{
friend class OQueryDesignView;
::std::vector<FASTBOOL> m_bVisibleRow; // an Pos steht die RowId
Timer m_timerInvalidate;
long m_nSeekRow;
BrowserMode m_nMode; // Merken des BrowseModes
Edit* m_pTextCell;
::svt::CheckBoxControl* m_pVisibleCell;
::svt::ComboBoxControl* m_pFieldCell;
::svt::ListBoxControl* m_pFunctionCell;
::svt::ListBoxControl* m_pTableCell;
::svt::ListBoxControl* m_pOrderCell;
sal_Int32 m_nMaxColumns; // maximale Anzahl der Spalten in einem Select-Statement
String m_aFunctionStrings;
sal_uInt16 m_nVisibleCount; // Anzahl der max sichtbaren Zeilen
sal_Bool m_bOrderByUnRelated;
sal_Bool m_bGroupByUnRelated;
sal_Bool m_bStopTimer;
DECL_LINK(OnInvalidateTimer, void*);
public: OSelectionBrowseBox( Window* pParent );
~OSelectionBrowseBox();
void initialize();
OTableFieldDesc* InsertField( const OJoinExchangeData& jxdSource, long nColId=-1, sal_Bool bVis=sal_True, sal_Bool bActivate=sal_True );
OTableFieldDesc* InsertField( const OTableFieldDesc& rInfo, long nCol=-1, sal_Bool bVis=sal_True, sal_Bool bActivate=sal_True );
void InsertColumn( OTableFieldDesc* pEntry, long& nColId );
void RemoveColumn( sal_uInt16 nColId );
void DeleteFields( const String& rAliasName );
// AddGroupBy:: F"ugt ein Feld mit Funktion == Grupierung. Falls das Feld schon vorhanden ist und ein Aggregate Funktion
// benutzt, wird das Flag nicht gesetzt
void AddGroupBy( const OTableFieldDesc& rInfo );
void AddCondition( const OTableFieldDesc& rInfo,
const String& rValue,
const sal_uInt16 nLevel, const char* pOp=0 );
void AddOrder(const OTableFieldDesc& rInfo, const EOrderDir eDir, sal_uInt16& nPos);
void ClearAll();
OTableFieldDesc* AppendNewCol( sal_uInt16 nCnt=1 );
void Save();
OQueryDesignView* getDesignView();
OQueryDesignView* getDesignView() const;
void SetColWidth();
sal_uInt16 FieldsCount();
void SetColWidth(sal_uInt16 nColId, long lNewWidth);
// beachtet im Gegensatz zum SetColumnWidth der Basisklasse auch eine eventuell aktive Zelle in dieser Spalte
String GetCellContents(sal_uInt16 nCellIndex, long nColId);
void SetCellContents(sal_uInt16 nCellIndex, long nColId, const String& strNewText);
// Zelleninhalt (als String formatiert) setzen/liefern
sal_Int32 GetNoneVisibleRows() const;
void SetNoneVisbleRow(long nRows);
sal_Bool IsRowVisible(sal_uInt16 _nWhich) const;
void SetRowVisible(sal_uInt16 _nWhich, sal_Bool _bVis);
void SetReadOnly(sal_Bool bRO);
// can the current content be cut
sal_Bool isCutAllowed();
void cut();
void paste();
void copy();
protected:
virtual sal_Bool SeekRow( long nRow );
virtual void PaintStatusCell(OutputDevice& rDev, const Rectangle& rRect) const;
virtual void PaintCell(OutputDevice& rDev, const Rectangle& rRect,
sal_uInt16 nColumnId ) const;
virtual sal_Int8 AcceptDrop( const BrowserAcceptDropEvent& rEvt );
virtual sal_Int8 ExecuteDrop( const BrowserExecuteDropEvent& rEvt );
// virtual sal_Bool QueryDrop(const BrowserDropEvent& rEvt);
// virtual sal_Bool Drop(const BrowserDropEvent& rEvt);
virtual void MouseButtonDown( const BrowserMouseEvent& rEvt );
virtual void MouseButtonUp( const BrowserMouseEvent& rEvt );
virtual void KeyInput( const KeyEvent& rEvt );
virtual void Command(const CommandEvent& rEvt);
virtual void ArrangeControls(sal_uInt16& nX, sal_uInt16 nY);
virtual ::svt::CellController* GetController(long nRow, sal_uInt16 nCol);
virtual void InitController(::svt::CellControllerRef& rController, long nRow, sal_uInt16 nCol);
virtual void CellModified();
virtual sal_Bool SaveModified();
virtual void Init();
virtual String GetCellText(long nRow, sal_uInt16 nColId) const;
virtual sal_uInt32 GetTotalCellWidth(long nRow, sal_uInt16 nColId) const;
virtual void ColumnResized( sal_uInt16 nColId );
virtual sal_uInt32 GetTotalCellWidth(long nRow, sal_uInt16 nColId);
virtual sal_uInt16 GetDefaultColumnWidth(const String& rName) const;
void Fill();
void stopTimer();
void startTimer();
private:
OTableFieldDesc* FindFirstFreeCol(long & rCol);
// rCol enthaelt die Nummer (in pOTableFieldDescList) der ersten Spalte, die von sich sagt, dass sie leer ist
// wenn es keine solche gibt, ist rCol undefiniert und der Rueckgabewert NULL
void CheckFreeColumns(long& rCol);
// testet, ob es noch freie Spalten gibt, wenn nicht, wird ein neuer Packen angefuegt
// rCol enthaelt die Nummer der ersten freien Spalte (in pOTableFieldDescList)
void RemoveField( sal_uInt16 nId, sal_Bool bActivate = sal_True);
Rectangle GetInvalidRect( sal_uInt16 nColId );
long GetRealRow(long nRow) const;
long GetBrowseRow(long nRowId) const;
sal_Bool GetFunktionName(String& rFkt);
void appendUndoAction(const String& _rOldValue,const String& _rNewValue,sal_Int32 _nRow);
void PreFill();
::std::vector<OTableFieldDesc*>* getFields() const;
};
}
#endif // DBAUI_QUERYDESIGN_OSELECTIONBROWSEBOX_HXX
|
