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
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
|
/*************************************************************************
*
* $RCSfile: unodatbr.hxx,v $
*
* $Revision: 1.35 $
*
* last change: $Author: fs $ $Date: 2001-08-16 10:35:57 $
*
* 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 _SBA_UNODATBR_HXX_
#define _SBA_UNODATBR_HXX_
#ifndef _SBA_BWRCTRLR_HXX
#include "brwctrlr.hxx"
#endif
#ifndef _COMPHELPER_STLTYPES_HXX_
#include <comphelper/stl_types.hxx>
#endif
#ifndef _COM_SUN_STAR_FRAME_XSTATUSLISTENER_HPP_
#include <com/sun/star/frame/XStatusListener.hpp>
#endif
#ifndef _COM_SUN_STAR_FRAME_XDISPATCH_HPP_
#include <com/sun/star/frame/XDispatch.hpp>
#endif
#ifndef _COM_SUN_STAR_CONTAINER_XCONTAINERLISTENER_HPP_
#include <com/sun/star/container/XContainerListener.hpp>
#endif
#ifndef _COM_SUN_STAR_I18N_XCOLLATOR_HPP_
#include <com/sun/star/i18n/XCollator.hpp>
#endif
#ifndef _COM_SUN_STAR_VIEW_XSELECTIONSUPPLIER_HPP_
#include <com/sun/star/view/XSelectionSupplier.hpp>
#endif
#ifndef _CPPUHELPER_IMPLBASE2_HXX_
#include <cppuhelper/implbase2.hxx>
#endif
#ifndef _DBACCESS_UI_CALLBACKS_HXX_
#include "callbacks.hxx"
#endif
#ifndef _SV_TIMER_HXX
#include <vcl/timer.hxx>
#endif
#ifndef _TRANSFER_HXX
#include <svtools/transfer.hxx>
#endif
#ifndef _SVX_DATACCESSDESCRIPTOR_HXX_
#include <svx/dataaccessdescriptor.hxx>
#endif
// =========================================================================
class SvLBoxEntry;
class Splitter;
struct SvSortData;
#define CONTAINER_QUERIES sal_Int32(etQuery - etBookmark)
#define CONTAINER_TABLES sal_Int32(etTable - etBookmark)
#define CONTAINER_BOOKMARKS sal_Int32(etBookmark - etBookmark)
// .........................................................................
namespace dbaui
{
// .........................................................................
class DBTreeView;
class DBTreeListModel;
// =====================================================================
typedef ::cppu::ImplHelper2 < ::com::sun::star::frame::XStatusListener
, ::com::sun::star::view::XSelectionSupplier
> SbaTableQueryBrowser_Base;
class SbaTableQueryBrowser
:public SbaXDataBrowserController
,public SbaTableQueryBrowser_Base
,public IControlActionListener
{
protected:
// ---------------------------
DECLARE_STL_STDKEY_MAP( sal_Int32, ::com::sun::star::uno::Reference< ::com::sun::star::frame::XDispatch >, SpecialSlotDispatchers);
DECLARE_STL_STDKEY_MAP( sal_Int32, sal_Bool, SpecialSlotStates);
struct DropDescriptor
{
TransferableDataHelper aDroppedData;
SvLBoxEntry* pDroppedAt;
sal_Bool bTable;
DropDescriptor() : pDroppedAt(NULL), bTable(sal_True) { }
};
// ---------------------------
::com::sun::star::uno::Reference< ::com::sun::star::i18n::XCollator > m_xCollator;
::osl::Mutex m_aEntryMutex;
SpecialSlotDispatchers m_aDispatchers; // external dispatchers for slots we do not execute ourself
SpecialSlotStates m_aDispatchStates; // states of the slots handled by external dispatchers
::svx::ODataAccessDescriptor m_aDocumentDataSource;
// if we're part of a document, this is the state of the DocumentDataSource slot
::cppu::OInterfaceContainerHelper m_aSelectionListeners;
DropDescriptor m_aAsyncDrop;
Timer m_aRefreshMenu; // the timer for the menu "refresh"
::rtl::OUString m_sQueryCommand; // the command of the query currently loaded (if any)
DBTreeView* m_pTreeView;
Splitter* m_pSplitter;
DBTreeListModel* m_pTreeModel; // contains the datasources of the registry
SvLBoxEntry* m_pCurrentlyDisplayed;
sal_Int32 m_nAsyncDrop;
sal_Bool m_bQueryEscapeProcessing : 1; // the escape processing flag of the query currently loaded (if any)
// attribute access
public:
SbaTableQueryBrowser(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM);
~SbaTableQueryBrowser();
enum EntryType
{
etDatasource,
etBookmarkContainer,
etQueryContainer,
etTableContainer,
etBookmark,
etQuery,
etTable,
etView,
etUnknown
};
// need by registration
static ::rtl::OUString getImplementationName_Static() throw( ::com::sun::star::uno::RuntimeException );
static ::com::sun::star::uno::Sequence< ::rtl::OUString > getSupportedServiceNames_Static(void) throw( ::com::sun::star::uno::RuntimeException );
static ::com::sun::star::uno::Reference< ::com::sun::star::uno::XInterface >
SAL_CALL Create(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >&);
DECLARE_UNO3_DEFAULTS(SbaTableQueryBrowser,SbaXDataBrowserController);
// late construction
virtual sal_Bool Construct(Window* pParent);
// XInterface
virtual ::com::sun::star::uno::Any SAL_CALL queryInterface(const ::com::sun::star::uno::Type& _rType) throw (::com::sun::star::uno::RuntimeException);
// XTypeProvider
virtual ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL getTypes( ) throw (::com::sun::star::uno::RuntimeException);
virtual ::com::sun::star::uno::Sequence< sal_Int8 > SAL_CALL getImplementationId( ) throw (::com::sun::star::uno::RuntimeException);
// ::com::sun::star::beans::XPropertyChangeListener
virtual void SAL_CALL propertyChange(const ::com::sun::star::beans::PropertyChangeEvent& evt);
// ::com::sun::star::frame::XController
virtual sal_Bool SAL_CALL suspend(sal_Bool bSuspend) throw( ::com::sun::star::uno::RuntimeException );
virtual void SAL_CALL attachFrame(const ::com::sun::star::uno::Reference< ::com::sun::star::frame::XFrame > & xFrame) throw( ::com::sun::star::uno::RuntimeException );
// ::com::sun::star::lang::XComponent
virtual void SAL_CALL disposing();
// XStatusListener
virtual void SAL_CALL statusChanged( const ::com::sun::star::frame::FeatureStateEvent& Event ) throw(::com::sun::star::uno::RuntimeException);
// XEventListener
virtual void SAL_CALL disposing( const ::com::sun::star::lang::EventObject& Source ) throw(::com::sun::star::uno::RuntimeException);
// XSelectionSupplier
virtual sal_Bool SAL_CALL select( const ::com::sun::star::uno::Any& aSelection ) throw (::com::sun::star::lang::IllegalArgumentException, ::com::sun::star::uno::RuntimeException);
virtual ::com::sun::star::uno::Any SAL_CALL getSelection( ) throw (::com::sun::star::uno::RuntimeException);
virtual void SAL_CALL addSelectionChangeListener( const ::com::sun::star::uno::Reference< ::com::sun::star::view::XSelectionChangeListener >& xListener ) throw (::com::sun::star::uno::RuntimeException);
virtual void SAL_CALL removeSelectionChangeListener( const ::com::sun::star::uno::Reference< ::com::sun::star::view::XSelectionChangeListener >& xListener ) throw (::com::sun::star::uno::RuntimeException);
// XServiceInfo
virtual ::rtl::OUString SAL_CALL getImplementationName() throw(::com::sun::star::uno::RuntimeException);
virtual ::comphelper::StringSequence SAL_CALL getSupportedServiceNames() throw(::com::sun::star::uno::RuntimeException);
// lang::XInitialization
virtual void SAL_CALL initialize( const ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Any >& aArguments ) throw(::com::sun::star::uno::Exception, ::com::sun::star::uno::RuntimeException);
// XContainerListener
virtual void SAL_CALL elementInserted( const ::com::sun::star::container::ContainerEvent& Event ) throw(::com::sun::star::uno::RuntimeException);
virtual void SAL_CALL elementRemoved( const ::com::sun::star::container::ContainerEvent& Event ) throw(::com::sun::star::uno::RuntimeException);
virtual void SAL_CALL elementReplaced( const ::com::sun::star::container::ContainerEvent& Event ) throw(::com::sun::star::uno::RuntimeException);
protected:
// SbaXDataBrowserController overridables
virtual sal_Bool InitializeForm(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XRowSet > & xForm);
virtual sal_Bool InitializeGridModel(const ::com::sun::star::uno::Reference< ::com::sun::star::form::XFormComponent > & xGrid);
virtual ToolBox* CreateToolBox(Window* pParent);
virtual void InvalidateFeature(sal_uInt16 nId, const ::com::sun::star::uno::Reference< ::com::sun::star::frame::XStatusListener > & xListener = ::com::sun::star::uno::Reference< ::com::sun::star::frame::XStatusListener > ());
virtual void addModelListeners(const ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControlModel > & _xGridControlModel);
virtual void removeModelListeners(const ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControlModel > & _xGridControlModel);
virtual void AddColumnListener(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > & xCol);
virtual void RemoveColumnListener(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > & xCol);
virtual void LoadFinished(sal_Bool _bWasSynch);
virtual void criticalFail();
virtual void AddSupportedFeatures();
virtual FeatureState GetState(sal_uInt16 nId);
virtual void Execute(sal_uInt16 nId);
virtual void onToolBoxSelected( sal_uInt16 _nSelectedItem );
virtual void onToolBoxClicked( sal_uInt16 _nClickedItem );
// IControlActionListener overridables
virtual sal_Bool requestContextMenu( const CommandEvent& _rEvent );
virtual sal_Bool requestDrag( sal_Int8 _nAction, const Point& _rPosPixel );
virtual sal_Int8 queryDrop( const AcceptDropEvent& _rEvt, const DataFlavorExVector& _rFlavors );
virtual sal_Int8 executeDrop( const ExecuteDropEvent& _rEvt );
// SbaGridListener overridables
virtual void RowChanged();
virtual void ColumnChanged();
String getURL() const;
// methods for showing/hiding the explorer part
sal_Bool haveExplorer() const;
void hideExplorer();
void showExplorer();
void toggleExplorer() { if (haveExplorer()) hideExplorer(); else showExplorer(); }
// methods for handling the 'selection' (paintin them bold) of SvLBoxEntries
// returns <TRUE/> if the entry is selected (which means it's part of the selected path)
sal_Bool isSelected(SvLBoxEntry* _pEntry) const;
// select the entry (and only the entry, not the whole path)
void select(SvLBoxEntry* _pEntry, sal_Bool _bSelect = sal_True);
// select the path of the entry (which must be an entry without children)
void selectPath(SvLBoxEntry* _pEntry, sal_Bool _bSelect = sal_True);
private:
// check the state of the external slot given, update any UI elements if necessary
void implCheckExternalSlot(sal_Int32 _nId);
// connect to the external dispatchers (if any)
void connectExternalDispatches();
/** add an entry (including the subentries for queries/tables) to the list model
<p>The given names and images may be empty, in this case they're filled with the correct
values. This way they may be reused for the next call, which saves some resource manager calls.</p>
*/
void implAddDatasource(const String& _rDbName, Image& _rDbImage,
String& _rQueryName, Image& _rQueryImage,
String& _rTableName, Image& _rTableImage,
String& _rBookmarkName, Image& _rBookmarkImage);
/** unloads the form, empties the grid model, cleans up anything related to the currently displayed object
@param _bDisposeConnection
<TRUE/> if the connection should be disposed
@param _bFlushData
<TRUE/> if the currently displayed object (if any) should be flushed
*/
void unloadAndCleanup(sal_Bool _bDisposeConnection = sal_True, sal_Bool _bFlushData = sal_True);
/** close the connection (and collapse the list entries) of the given list entries
*/
void closeConnection(SvLBoxEntry* _pEntry,sal_Bool _bDisposeConnection = sal_True);
sal_Bool populateTree(const ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>& _xNameAccess, SvLBoxEntry* _pParent, const EntryType& _rEntryType);
void initializeTreeModel();
/** search in the tree for query- or tablecontainer equal to this interface and return
this container entry
*/
SvLBoxEntry* getEntryFromContainer(const ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>& _rxNameAccess);
// return true when there is connection available
sal_Bool ensureConnection(SvLBoxEntry* _pDSEntry,void * pDSData,::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& _xConnection);
sal_Bool ensureConnection(SvLBoxEntry* _pAnyEntry, ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& _xConnection);
sal_Bool isTableFormat() const;
void implAdministrate( SvLBoxEntry* _pApplyTo );
void implDirectSQL( SvLBoxEntry* _pApplyTo );
void implCreateObject( SvLBoxEntry* _pApplyTo, sal_uInt16 _nAction );
void implRemoveQuery( SvLBoxEntry* _pApplyTo );
void implDropTable( SvLBoxEntry* _pApplyTo );
void implPasteTable( SvLBoxEntry* _pApplyTo, const TransferableDataHelper& _rPasteData );
void implPasteQuery( SvLBoxEntry* _pApplyTo, const TransferableDataHelper& _rPasteData );
TransferableHelper*
implCopyObject( SvLBoxEntry* _pApplyTo, sal_Int32 _nCommandType, sal_Bool _bAllowConnection = sal_True );
EntryType getEntryType( SvLBoxEntry* _pEntry );
EntryType getChildType( SvLBoxEntry* _pEntry );
sal_Bool isObject( EntryType _eType ) { return (etTable == _eType) || (etView == _eType) || (etQuery == _eType) || (etBookmark == _eType); }
sal_Bool isContainer( EntryType _eType ) { return (etTableContainer == _eType) || (etQueryContainer == _eType) || (etBookmarkContainer == _eType); }
sal_Bool isContainer( SvLBoxEntry* _pEntry ) { return isContainer( getEntryType( _pEntry ) ); }
// ensure that the xObject for the given entry is set on the user data
sal_Bool ensureEntryObject( SvLBoxEntry* _pEntry );
// get the display text of the entry given
String GetEntryText( SvLBoxEntry* _pEntry );
// is called when a table or a query was selected
DECL_LINK( OnEntryDoubleClicked, SvLBoxEntry* );
DECL_LINK( OnSelectEntry, SvLBoxEntry* );
DECL_LINK( OnExpandEntry, SvLBoxEntry* );
DECL_LINK( OnCutEntry, SvLBoxEntry* );
DECL_LINK( OnCopyEntry, SvLBoxEntry* );
DECL_LINK( OnPasteEntry, SvLBoxEntry* );
DECL_LINK( OnDeleteEntry, SvLBoxEntry* );
DECL_LINK( OnTreeEntryCompare, const SvSortData* );
DECL_LINK( OnAsyncDrop, void* );
DECL_LINK( OnShowRefreshDropDown, void* );
void implRemoveStatusListeners();
void openHelpAgent(sal_Int32 _nHelpId);
sal_Bool implSelect(const ::svx::ODataAccessDescriptor& _rDescriptor);
/// selects the entry given and loads the grid control with the object's data
sal_Bool implSelect(const ::rtl::OUString& _rDataSourceName, const ::rtl::OUString& _rCommand,
const sal_Int32 _nCommandType, const sal_Bool _bEscapeProcessing,const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& _rxConnection=NULL);
/// loads the grid control with the data object specified (which may be a table, a query or a command)
sal_Bool implLoadAnything(const ::rtl::OUString& _rDataSourceName, const ::rtl::OUString& _rCommand,
const sal_Int32 _nCommandType, const sal_Bool _bEscapeProcessing, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& _rxConnection = NULL);
/** retrieves the tree entry for the object described by <arg>_rDescriptor</arg>
@param _rDescriptor
the object descriptor
@param _ppDataSourceEntry
If not <NULL/>, the data source tree entry will be returned here
@param _ppContainerEntry
If not <NULL/>, the object container tree entry will be returned here
@param _bExpandAncestors
If <TRUE/>, all ancestor on the way to the entry will be expanded
*/
SvLBoxEntry* getObjectEntry(const ::svx::ODataAccessDescriptor& _rDescriptor,
SvLBoxEntry** _ppDataSourceEntry = NULL, SvLBoxEntry** _ppContainerEntry = NULL,
sal_Bool _bExpandAncestors = sal_True
);
/** retrieves the tree entry for the object described by data source name, command and command type
@param _rDataSource
the data source name
@param _rCommand
the command
@param _nCommandType
the command type
@param _rDescriptor
the object descriptor
@param _ppDataSourceEntry
If not <NULL/>, the data source tree entry will be returned here
@param _ppContainerEntry
If not <NULL/>, the object container tree entry will be returned here
@param _bExpandAncestors
If <TRUE/>, all ancestor on the way to the entry will be expanded
*/
SvLBoxEntry* getObjectEntry(
const ::rtl::OUString& _rDataSource, const ::rtl::OUString& _rCommand, sal_Int32 _nCommandType,
SvLBoxEntry** _ppDataSourceEntry = NULL, SvLBoxEntry** _ppContainerEntry = NULL,
sal_Bool _bExpandAncestors = sal_True
);
/// checks if m_aDocumentDataSource describes a known object
void checkDocumentDataSource();
void extractDescriptorProps(const ::svx::ODataAccessDescriptor& _rDescriptor,
::rtl::OUString& _rDataSource, ::rtl::OUString& _rCommand, sal_Int32& _rCommandType, sal_Bool& _rEscapeProcessing);
void transferChangedControlProperty(const ::rtl::OUString& _rProperty, const ::com::sun::star::uno::Any& _rNewValue);
void insertRows(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet>& xSrcRs,
const ::std::vector<sal_Int32>& _rvColumns,
const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& _xTable,
const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData>& _xMetaData,
sal_Bool bIsAutoIncrement) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > connectWithStatus(
const ::rtl::OUString& _rDataSourceName,
void* _pTreeListUserData // in rela a DBTreeListModel::DBTreeListUserData*, but we do not know this class here ....
);
// set _rsName as title at the frame
void setTitle(const ::rtl::OUString& _rsDataSourceName,const ::rtl::OUString& _rsName) const;
void setDefaultTitle() const;
/** get the signature (command/escape processing) of the query the form is based on
<p>If the for is not based on a query or not even loaded, nothing happens and <FALSE/> is returned.</p>
*/
sal_Bool implGetQuerySignature( ::rtl::OUString& _rCommand, sal_Bool& _bEscapeProcessing );
sal_Bool isEntryCutAllowed(SvLBoxEntry* _pEntry);
sal_Bool isEntryCopyAllowed(SvLBoxEntry* _pEntry);
sal_Bool isEntryPasteAllowed(SvLBoxEntry* _pEntry);
void cutEntry(SvLBoxEntry* _pEntry);
void copyEntry(SvLBoxEntry* _pEntry);
void pasteEntry(SvLBoxEntry* _pEntry);
};
// .........................................................................
} // namespace dbaui
// .........................................................................
#endif // _SBA_UNODATBR_HXX_
|
