1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 
23 
24 // MARKER(update_precomp.py): autogen include statement, do not remove
25 #include "precompiled_dbaccess.hxx"
26 
27 #include "AppController.hxx"
28 #include "dbustrings.hrc"
29 #include "advancedsettingsdlg.hxx"
30 #include "subcomponentmanager.hxx"
31 #include "closeveto.hxx"
32 
33 /** === begin UNO includes === **/
34 #include <com/sun/star/beans/NamedValue.hpp>
35 #include <com/sun/star/container/XChild.hpp>
36 #include <com/sun/star/container/XContainer.hpp>
37 #include <com/sun/star/container/XContentEnumerationAccess.hpp>
38 #include <com/sun/star/container/XHierarchicalNameAccess.hpp>
39 #include <com/sun/star/container/XHierarchicalNameContainer.hpp>
40 #include <com/sun/star/container/XNameContainer.hpp>
41 #include <com/sun/star/frame/FrameSearchFlag.hpp>
42 #include <com/sun/star/frame/XStorable.hpp>
43 #include <com/sun/star/sdb/CommandType.hpp>
44 #include <com/sun/star/sdb/SQLContext.hpp>
45 #include <com/sun/star/sdb/XBookmarksSupplier.hpp>
46 #include <com/sun/star/sdb/XOfficeDatabaseDocument.hpp>
47 #include <com/sun/star/sdb/XQueryDefinitionsSupplier.hpp>
48 #include <com/sun/star/sdbc/XDataSource.hpp>
49 #include <com/sun/star/sdbcx/XAlterView.hpp>
50 #include <com/sun/star/sdbcx/XAppend.hpp>
51 #include <com/sun/star/sdbcx/XRename.hpp>
52 #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
53 #include <com/sun/star/sdbcx/XViewsSupplier.hpp>
54 #include <com/sun/star/ui/dialogs/TemplateDescription.hpp>
55 #include <com/sun/star/uno/XNamingService.hpp>
56 #include <com/sun/star/util/XFlushable.hpp>
57 #include <com/sun/star/util/XModifiable.hpp>
58 #include <com/sun/star/util/XModifyBroadcaster.hpp>
59 #include <com/sun/star/util/XNumberFormatter.hpp>
60 #include <com/sun/star/ui/dialogs/XExecutableDialog.hpp>
61 #include <com/sun/star/document/XEmbeddedScripts.hpp>
62 #include <com/sun/star/frame/XModel2.hpp>
63 #include <com/sun/star/container/XHierarchicalNameContainer.hpp>
64 #include <com/sun/star/util/XModifyBroadcaster.hpp>
65 #include <com/sun/star/util/XModifiable.hpp>
66 #include <com/sun/star/frame/FrameSearchFlag.hpp>
67 #include <com/sun/star/util/XFlushable.hpp>
68 #include "com/sun/star/ui/dialogs/TemplateDescription.hpp"
69 #include "com/sun/star/beans/NamedValue.hpp"
70 #include <com/sun/star/awt/XTopWindow.hpp>
71 #include <com/sun/star/task/XInteractionHandler.hpp>
72 #include <com/sun/star/sdb/application/DatabaseObject.hpp>
73 #include <com/sun/star/sdb/application/DatabaseObjectContainer.hpp>
74 #include <com/sun/star/document/XDocumentEventBroadcaster.hpp>
75 #include <com/sun/star/container/XHierarchicalName.hpp>
76 /** === end UNO includes === **/
77 #include <tools/debug.hxx>
78 #include <tools/diagnose_ex.h>
79 #include <tools/string.hxx>
80 
81 #include <svl/urihelper.hxx>
82 #include <svl/filenotation.hxx>
83 #include <svtools/svtreebx.hxx>
84 #include <svtools/transfer.hxx>
85 #include <svtools/cliplistener.hxx>
86 #include <svtools/svlbitm.hxx>
87 #include <svtools/insdlg.hxx>
88 
89 #include <comphelper/sequence.hxx>
90 #include <comphelper/uno3.hxx>
91 #include <comphelper/string.hxx>
92 #include <comphelper/types.hxx>
93 #include <comphelper/interaction.hxx>
94 #include <comphelper/componentcontext.hxx>
95 
96 #include <vcl/msgbox.hxx>
97 #include <vcl/stdtext.hxx>
98 #include <vcl/svapp.hxx>
99 #include <vcl/menu.hxx>
100 #include <vcl/lstbox.hxx>
101 
102 #include <unotools/pathoptions.hxx>
103 #include <unotools/tempfile.hxx>
104 #include <unotools/internaloptions.hxx>
105 #include <unotools/moduleoptions.hxx>
106 #include <unotools/historyoptions.hxx>
107 
108 #include <sfx2/mailmodelapi.hxx>
109 #include <sfx2/filedlghelper.hxx>
110 #include <sfx2/docfilt.hxx>
111 #include <sfx2/QuerySaveDocument.hxx>
112 
113 #include <cppuhelper/typeprovider.hxx>
114 #include <cppuhelper/exc_hlp.hxx>
115 
116 #include <connectivity/dbtools.hxx>
117 #include <connectivity/dbexception.hxx>
118 
119 #include <svx/dbaexchange.hxx>
120 #include <svx/dbaobjectex.hxx>
121 #include <svx/svxdlg.hxx>
122 
123 #include <vos/mutex.hxx>
124 #include "AppView.hxx"
125 #include "browserids.hxx"
126 #include "dbu_reghelper.hxx"
127 #include "dbu_app.hrc"
128 #include "defaultobjectnamecheck.hxx"
129 #include "databaseobjectview.hxx"
130 #include "listviewitems.hxx"
131 #include "AppDetailView.hxx"
132 #include "linkeddocuments.hxx"
133 #include "sqlmessage.hxx"
134 #include "UITools.hxx"
135 #include "dsntypes.hxx"
136 #include "dbaccess_helpid.hrc"
137 #include "dlgsave.hxx"
138 #include "dbaccess_slotid.hrc"
139 
140 #include <algorithm>
141 #include <functional>
142 
143 #include <boost/noncopyable.hpp>
144 
createRegistryInfo_ODBApplication()145 extern "C" void SAL_CALL createRegistryInfo_ODBApplication()
146 {
147 	static ::dbaui::OMultiInstanceAutoRegistration< ::dbaui::OApplicationController > aAutoRegistration;
148 }
149 //........................................................................
150 namespace dbaui
151 {
152 //........................................................................
153 using namespace ::dbtools;
154 using namespace ::svx;
155 using namespace ::com::sun::star;
156 using namespace ::com::sun::star::uno;
157 using namespace ::com::sun::star::ucb;
158 using namespace ::com::sun::star::view;
159 using namespace ::com::sun::star::util;
160 using namespace ::com::sun::star::beans;
161 using namespace ::com::sun::star::lang;
162 using namespace ::com::sun::star::frame;
163 using namespace ::com::sun::star::container;
164 using namespace ::com::sun::star::sdb;
165 using namespace ::com::sun::star::sdbc;
166 using namespace ::com::sun::star::sdbcx;
167 using namespace ::com::sun::star::datatransfer;
168 using namespace ::com::sun::star::ui::dialogs;
169 using namespace ::com::sun::star::task;
170 using ::com::sun::star::document::XEmbeddedScripts;
171 using ::com::sun::star::document::XDocumentEventBroadcaster;
172 using ::com::sun::star::document::DocumentEvent;
173 using ::com::sun::star::sdb::application::NamedDatabaseObject;
174 
175 namespace DatabaseObject = ::com::sun::star::sdb::application::DatabaseObject;
176 namespace DatabaseObjectContainer = ::com::sun::star::sdb::application::DatabaseObjectContainer;
177 
178 //------------------------------------------------------------------------------
getImplementationName()179 ::rtl::OUString SAL_CALL OApplicationController::getImplementationName() throw( RuntimeException )
180 {
181 	return getImplementationName_Static();
182 }
183 
184 //------------------------------------------------------------------------------
getImplementationName_Static()185 ::rtl::OUString OApplicationController::getImplementationName_Static() throw( RuntimeException )
186 {
187 	return ::rtl::OUString(SERVICE_SDB_APPLICATIONCONTROLLER);
188 }
189 //------------------------------------------------------------------------------
getSupportedServiceNames_Static(void)190 Sequence< ::rtl::OUString> OApplicationController::getSupportedServiceNames_Static(void) throw( RuntimeException )
191 {
192 	Sequence< ::rtl::OUString> aSupported(1);
193 	aSupported.getArray()[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdb.application.DefaultViewController");
194 	return aSupported;
195 }
196 //-------------------------------------------------------------------------
getSupportedServiceNames()197 Sequence< ::rtl::OUString> SAL_CALL OApplicationController::getSupportedServiceNames() throw(RuntimeException)
198 {
199 	return getSupportedServiceNames_Static();
200 }
201 // -------------------------------------------------------------------------
Create(const Reference<XMultiServiceFactory> & _rxFactory)202 Reference< XInterface > SAL_CALL OApplicationController::Create(const Reference<XMultiServiceFactory >& _rxFactory)
203 {
204 	return *(new OApplicationController(_rxFactory));
205 }
206 // -----------------------------------------------------------------------------
207 
208 struct XContainerFunctor : public ::std::unary_function< OApplicationController::TContainerVector::value_type , bool>
209 {
210 	Reference<XContainerListener> m_xContainerListener;
XContainerFunctordbaui::XContainerFunctor211 	XContainerFunctor( const Reference<XContainerListener>& _xContainerListener)
212 		: m_xContainerListener(_xContainerListener){}
213 
operator ()dbaui::XContainerFunctor214 	bool operator() (const OApplicationController::TContainerVector::value_type& lhs) const
215 	{
216 		if ( lhs.is() )
217 			lhs->removeContainerListener(m_xContainerListener);
218 		return true;
219 	}
220 };
221 
222 //====================================================================
223 //= OApplicationController
224 //====================================================================
225 class SelectionNotifier : public ::boost::noncopyable
226 {
227 private:
228     ::cppu::OInterfaceContainerHelper   m_aSelectionListeners;
229     ::cppu::OWeakObject&                m_rContext;
230     sal_Int32                           m_nSelectionNestingLevel;
231 
232 public:
SelectionNotifier(::osl::Mutex & _rMutex,::cppu::OWeakObject & _rContext)233     SelectionNotifier( ::osl::Mutex& _rMutex, ::cppu::OWeakObject& _rContext )
234         :m_aSelectionListeners( _rMutex )
235         ,m_rContext( _rContext )
236         ,m_nSelectionNestingLevel( 0 )
237     {
238     }
239 
addListener(const Reference<XSelectionChangeListener> & _Listener)240     void addListener( const Reference< XSelectionChangeListener >& _Listener )
241     {
242         m_aSelectionListeners.addInterface( _Listener );
243     }
244 
removeListener(const Reference<XSelectionChangeListener> & _Listener)245     void removeListener( const Reference< XSelectionChangeListener >& _Listener )
246     {
247         m_aSelectionListeners.removeInterface( _Listener );
248     }
249 
disposing()250     void disposing()
251     {
252         EventObject aEvent( m_rContext );
253         m_aSelectionListeners.disposeAndClear( aEvent );
254     }
255 
~SelectionNotifier()256     ~SelectionNotifier()
257     {
258     }
259 
SelectionGuardAccessdbaui::SelectionNotifier::SelectionGuardAccess260     struct SelectionGuardAccess { friend class SelectionGuard; private: SelectionGuardAccess() { }  };
261 
262     /** enters a block which modifies the selection of our owner.
263 
264         Can be called multiple times, the only important thing is to call leaveSelection
265         equally often.
266     */
enterSelection(SelectionGuardAccess)267     void    enterSelection( SelectionGuardAccess )
268     {
269         ++m_nSelectionNestingLevel;
270     }
271 
272     /** leaves a block which modifies the selection of our owner
273 
274         Must be paired with enterSelection calls.
275 
276         When the last block is left, i.e. the last leaveSelection call is made on the current stack,
277         then our SelectionChangeListeners are notified
278     */
leaveSelection(SelectionGuardAccess)279     void    leaveSelection( SelectionGuardAccess )
280     {
281         if ( --m_nSelectionNestingLevel == 0 )
282         {
283             EventObject aEvent( m_rContext );
284             m_aSelectionListeners.notifyEach( &XSelectionChangeListener::selectionChanged, aEvent );
285         }
286     }
287 };
288 
289 class SelectionGuard : public ::boost::noncopyable
290 {
291 public:
SelectionGuard(SelectionNotifier & _rNotifier)292     SelectionGuard( SelectionNotifier& _rNotifier )
293         :m_rNotifier( _rNotifier )
294     {
295         m_rNotifier.enterSelection( SelectionNotifier::SelectionGuardAccess() );
296     }
297 
~SelectionGuard()298     ~SelectionGuard()
299     {
300         m_rNotifier.leaveSelection( SelectionNotifier::SelectionGuardAccess() );
301     }
302 
303 private:
304     SelectionNotifier&  m_rNotifier;
305 };
306 
307 //====================================================================
308 //= OApplicationController
309 //====================================================================
DBG_NAME(OApplicationController)310 DBG_NAME(OApplicationController)
311 //--------------------------------------------------------------------
312 OApplicationController::OApplicationController(const Reference< XMultiServiceFactory >& _rxORB)
313 	:OApplicationController_CBASE( _rxORB )
314     ,m_aContextMenuInterceptors( getMutex() )
315     ,m_pSubComponentManager( new SubComponentManager( *this, getSharedMutex() ) )
316     ,m_aTypeCollection(_rxORB)
317     ,m_aTableCopyHelper(this)
318 	,m_pClipbordNotifier(NULL)
319 	,m_nAsyncDrop(0)
320     ,m_aControllerConnectedEvent( LINK( this, OApplicationController, OnFirstControllerConnected ) )
321     ,m_aSelectContainerEvent( LINK( this, OApplicationController, OnSelectContainer ) )
322 	,m_ePreviewMode(E_PREVIEWNONE)
323 	,m_eCurrentType(E_NONE)
324 	,m_bNeedToReconnect(sal_False)
325     ,m_bSuspended( sal_False )
326     ,m_pSelectionNotifier( new SelectionNotifier( getMutex(), *this ) )
327 {
328     DBG_CTOR(OApplicationController,NULL);
329 }
330 //------------------------------------------------------------------------------
~OApplicationController()331 OApplicationController::~OApplicationController()
332 {
333 	if ( !rBHelper.bDisposed && !rBHelper.bInDispose )
334 	{
335 		OSL_ENSURE(0,"Please check who doesn't dispose this component!");
336         // increment ref count to prevent double call of Dtor
337         osl_incrementInterlockedCount( &m_refCount );
338         dispose();
339 	}
340 	::std::auto_ptr< Window> aTemp( getView() );
341     clearView();
342 
343     DBG_DTOR(OApplicationController,NULL);
344 }
345 //--------------------------------------------------------------------
IMPLEMENT_FORWARD_XTYPEPROVIDER2(OApplicationController,OApplicationController_CBASE,OApplicationController_Base)346 IMPLEMENT_FORWARD_XTYPEPROVIDER2(OApplicationController,OApplicationController_CBASE,OApplicationController_Base)
347 IMPLEMENT_FORWARD_XINTERFACE2(OApplicationController,OApplicationController_CBASE,OApplicationController_Base)
348 // -----------------------------------------------------------------------------
349 void OApplicationController::disconnect()
350 {
351     if ( m_xDataSourceConnection.is() )
352 	    stopConnectionListening( m_xDataSourceConnection );
353 
354     try
355     {
356         // temporary (hopefully!) hack for #i55274#
357         Reference< XFlushable > xFlush( m_xDataSourceConnection, UNO_QUERY );
358         if ( xFlush.is() && m_xMetaData.is() && !m_xMetaData->isReadOnly() )
359             xFlush->flush();
360     }
361     catch( const Exception& )
362     {
363         DBG_UNHANDLED_EXCEPTION();
364     }
365 
366     m_xDataSourceConnection.clear();
367     m_xMetaData.clear();
368 
369 	InvalidateAll();
370 }
371 
372 //--------------------------------------------------------------------
disposing()373 void SAL_CALL OApplicationController::disposing()
374 {
375     m_aControllerConnectedEvent.CancelCall();
376 
377 	::std::for_each(m_aCurrentContainers.begin(),m_aCurrentContainers.end(),XContainerFunctor(this));
378 	m_aCurrentContainers.clear();
379     m_pSubComponentManager->disposing();
380     m_pSelectionNotifier->disposing();
381 
382 	if ( getView() )
383 	{
384 		getContainer()->showPreview(NULL);
385 		m_pClipbordNotifier->ClearCallbackLink();
386 		m_pClipbordNotifier->AddRemoveListener( getView(), sal_False );
387 		m_pClipbordNotifier->release();
388 		m_pClipbordNotifier = NULL;
389 	}
390 
391 	disconnect();
392 	try
393 	{
394 		Reference < XFrame > xFrame;
395 		attachFrame( xFrame );
396 
397         if ( m_xDataSource.is() )
398 		{
399 		    m_xDataSource->removePropertyChangeListener(::rtl::OUString(), this);
400             m_xDataSource->removePropertyChangeListener(PROPERTY_INFO, this);
401 			m_xDataSource->removePropertyChangeListener(PROPERTY_URL, this);
402 			m_xDataSource->removePropertyChangeListener(PROPERTY_ISPASSWORDREQUIRED, this);
403 			m_xDataSource->removePropertyChangeListener(PROPERTY_LAYOUTINFORMATION, this);
404 			m_xDataSource->removePropertyChangeListener(PROPERTY_SUPPRESSVERSIONCL, this);
405 			m_xDataSource->removePropertyChangeListener(PROPERTY_TABLEFILTER, this);
406 			m_xDataSource->removePropertyChangeListener(PROPERTY_TABLETYPEFILTER, this);
407 			m_xDataSource->removePropertyChangeListener(PROPERTY_USER, this);
408 			// otherwise we may delete our datasource twice
409 			Reference<XPropertySet> xProp = m_xDataSource;
410 			m_xDataSource = NULL;
411 		}
412 
413 		Reference< XModifyBroadcaster > xBroadcaster( m_xModel, UNO_QUERY );
414 		if ( xBroadcaster.is() )
415 			xBroadcaster->removeModifyListener(static_cast<XModifyListener*>(this));
416 
417 		if ( m_xModel.is() )
418 		{
419 			::rtl::OUString sUrl = m_xModel->getURL();
420 			if ( sUrl.getLength() )
421 	    	{
422                 ::comphelper::NamedValueCollection aArgs( m_xModel->getArgs() );
423                 if ( true == aArgs.getOrDefault( "PickListEntry", true ) )
424                 {
425     				::rtl::OUString		aFilter;
426     				INetURLObject		aURL( m_xModel->getURL() );
427     				const SfxFilter* pFilter = getStandardDatabaseFilter();
428     				if ( pFilter )
429     					aFilter = pFilter->GetFilterName();
430 
431     				// add to svtool history options
432     				SvtHistoryOptions().AppendItem( ePICKLIST,
433     						aURL.GetURLNoPass( INetURLObject::NO_DECODE ),
434     						aFilter,
435     						getStrippedDatabaseName(),
436     						::rtl::OUString() );
437                 }
438             }
439 
440             m_xModel->disconnectController( this );
441 
442             m_xModel.clear();
443 		}
444 	}
445 	catch(Exception)
446 	{
447         DBG_UNHANDLED_EXCEPTION();
448 	}
449 
450     clearView();
451 	OApplicationController_CBASE::disposing(); // here the m_refCount must be equal 5
452 }
453 
454 //--------------------------------------------------------------------
Construct(Window * _pParent)455 sal_Bool OApplicationController::Construct(Window* _pParent)
456 {
457 	setView( * new OApplicationView( _pParent, getORB(), *this, m_ePreviewMode ) );
458 	getView()->SetUniqueId(UID_APP_VIEW);
459 
460 	// late construction
461 	sal_Bool bSuccess = sal_False;
462 	try
463 	{
464 		getContainer()->Construct();
465 		bSuccess = sal_True;
466 	}
467 	catch(SQLException&)
468 	{
469 	}
470 	catch(Exception&)
471 	{
472 		DBG_ERROR("OApplicationController::Construct : the construction of UnoDataBrowserView failed !");
473 	}
474 
475 	if ( !bSuccess )
476 	{
477 		::std::auto_ptr< Window> aTemp( getView() );
478         clearView();
479 		return sal_False;
480 	}
481 
482 	// now that we have a view we can create the clipboard listener
483 	m_aSystemClipboard = TransferableDataHelper::CreateFromSystemClipboard( getView() );
484 	m_aSystemClipboard.StartClipboardListening( );
485 
486 	m_pClipbordNotifier = new TransferableClipboardListener( LINK( this, OApplicationController, OnClipboardChanged ) );
487 	m_pClipbordNotifier->acquire();
488 	m_pClipbordNotifier->AddRemoveListener( getView(), sal_True );
489 
490 	OApplicationController_CBASE::Construct( _pParent );
491 	getView()->Show();
492 
493 	return sal_True;
494 }
495 
496 //--------------------------------------------------------------------
disposing(const EventObject & _rSource)497 void SAL_CALL OApplicationController::disposing(const EventObject& _rSource) throw( RuntimeException )
498 {
499     ::osl::MutexGuard aGuard( getMutex() );
500 	Reference<XConnection> xCon(_rSource.Source, UNO_QUERY);
501 	if ( xCon.is() )
502 	{
503         DBG_ASSERT( m_xDataSourceConnection == xCon,
504             "OApplicationController::disposing: which connection does this come from?" );
505 
506         if ( getContainer() && getContainer()->getElementType() == E_TABLE )
507             getContainer()->clearPages();
508         if ( m_xDataSourceConnection == xCon )
509         {
510 			m_xMetaData.clear();
511             m_xDataSourceConnection.clear();
512 		}
513 	}
514 	else if ( _rSource.Source == m_xModel )
515 	{
516 		m_xModel.clear();
517 	}
518 	else if ( _rSource.Source == m_xDataSource )
519 	{
520 		m_xDataSource = NULL;
521 	}
522 	else
523 	{
524 		Reference<XContainer> xContainer( _rSource.Source, UNO_QUERY );
525 		if ( xContainer.is() )
526 		{
527 			TContainerVector::iterator aFind = ::std::find(m_aCurrentContainers.begin(),m_aCurrentContainers.end(),xContainer);
528 			if ( aFind != m_aCurrentContainers.end() )
529 				m_aCurrentContainers.erase(aFind);
530 		}
531 		OApplicationController_CBASE::disposing( _rSource );
532 	}
533 }
534 //--------------------------------------------------------------------
suspend(sal_Bool bSuspend)535 sal_Bool SAL_CALL OApplicationController::suspend(sal_Bool bSuspend) throw( RuntimeException )
536 {
537     // notify the OnPrepareViewClosing event (before locking any mutex)
538     Reference< XDocumentEventBroadcaster > xBroadcaster( m_xModel, UNO_QUERY );
539     if ( xBroadcaster.is() )
540     {
541         xBroadcaster->notifyDocumentEvent(
542             ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "OnPrepareViewClosing" ) ),
543             this,
544             Any()
545         );
546     }
547 
548     ::vos::OGuard aSolarGuard( Application::GetSolarMutex() );
549     ::osl::MutexGuard aGuard( getMutex() );
550 
551     if ( getView() && getView()->IsInModalMode() )
552         return sal_False;
553 
554     sal_Bool bCanSuspend = sal_True;
555 
556     if ( m_bSuspended != bSuspend )
557     {
558 	    if ( bSuspend && !closeSubComponents() )
559 		    return sal_False;
560 
561 	    Reference<XModifiable> xModi(m_xModel,UNO_QUERY);
562         Reference<XStorable> xStor(getModel(),UNO_QUERY);
563 
564 	    if  (   bSuspend
565             &&  xStor.is()
566             &&  !xStor->isReadonly()
567             &&  (   xModi.is()
568                 &&  xModi->isModified()
569                 )
570             )
571 	    {
572 		    switch (ExecuteQuerySaveDocument(getView(),getStrippedDatabaseName()))
573 		    {
574 			    case RET_YES:
575 				    Execute(ID_BROWSER_SAVEDOC,Sequence<PropertyValue>());
576 				    bCanSuspend = !xModi->isModified();
577                     // when we save the document this must be false else some press cancel
578 				    break;
579 			    case RET_CANCEL:
580 				    bCanSuspend = sal_False;
581 			    default:
582 				    break;
583 		    }
584 	    }
585     }
586 
587     if ( bCanSuspend )
588 	    m_bSuspended = bSuspend;
589 
590 	return bCanSuspend;
591 }
592 // -----------------------------------------------------------------------------
GetState(sal_uInt16 _nId) const593 FeatureState OApplicationController::GetState(sal_uInt16 _nId) const
594 {
595 	FeatureState aReturn;
596 	aReturn.bEnabled = sal_False;
597 	// check this first
598 	if ( !getContainer() || m_bReadOnly )
599 		return aReturn;
600 
601 	try
602 	{
603 		switch (_nId)
604 		{
605             case SID_OPENURL:
606                 aReturn.bEnabled = sal_True;
607                 if ( m_xModel.is() )
608 				    aReturn.sTitle = m_xModel->getURL();
609                 break;
610 			case ID_BROWSER_COPY:
611 				{
612 					sal_Int32 nCount = getContainer()->getSelectionCount();
613 					aReturn.bEnabled = nCount >= 1;
614 					if ( aReturn.bEnabled && nCount == 1 && getContainer()->getElementType() == E_TABLE )
615 						aReturn.bEnabled = getContainer()->isALeafSelected();
616 				}
617 				break;
618 			case ID_BROWSER_CUT:
619 				aReturn.bEnabled = !isDataSourceReadOnly() && getContainer()->getSelectionCount() >= 1;
620 				aReturn.bEnabled = aReturn.bEnabled && ( (ID_BROWSER_CUT == _nId && getContainer()->getElementType() == E_TABLE) ? getContainer()->isCutAllowed() : sal_True);
621 				break;
622 			case ID_BROWSER_PASTE:
623 				switch( getContainer()->getElementType() )
624 				{
625 					case E_TABLE:
626 						aReturn.bEnabled = !isDataSourceReadOnly() && !isConnectionReadOnly() && isTableFormat();
627 						break;
628 					case E_QUERY:
629 						aReturn.bEnabled = !isDataSourceReadOnly() && getViewClipboard().HasFormat(SOT_FORMATSTR_ID_DBACCESS_QUERY);
630 						break;
631 					default:
632 						aReturn.bEnabled = !isDataSourceReadOnly() && OComponentTransferable::canExtractComponentDescriptor(getViewClipboard().GetDataFlavorExVector(),getContainer()->getElementType() == E_FORM);
633 				}
634 				break;
635 			case SID_DB_APP_PASTE_SPECIAL:
636 				aReturn.bEnabled = getContainer()->getElementType() == E_TABLE && !isDataSourceReadOnly() && !isConnectionReadOnly() && isTableFormat();
637 				break;
638 			case SID_OPENDOC:
639 			case SID_HELP_INDEX:
640 				aReturn.bEnabled = sal_True;
641 				break;
642 			case ID_BROWSER_SAVEDOC:
643 				aReturn.bEnabled = !isDataSourceReadOnly() && m_xDocumentModify.is() && m_xDocumentModify->isModified();
644 				break;
645 			case ID_BROWSER_SAVEASDOC:
646 				aReturn.bEnabled = sal_True;
647 				break;
648 			case ID_BROWSER_SORTUP:
649 				aReturn.bEnabled = getContainer()->isFilled() && getContainer()->getElementCount();
650 				aReturn.bChecked = aReturn.bEnabled && getContainer()->isSortUp();
651 				break;
652 			case ID_BROWSER_SORTDOWN:
653 				aReturn.bEnabled = getContainer()->isFilled() && getContainer()->getElementCount();
654 				aReturn.bChecked = aReturn.bEnabled && !getContainer()->isSortUp();
655 				break;
656 
657 			case SID_NEWDOC:
658 			case SID_APP_NEW_FORM:
659 			case ID_DOCUMENT_CREATE_REPWIZ:
660                 aReturn.bEnabled = !isDataSourceReadOnly() && SvtModuleOptions().IsModuleInstalled(SvtModuleOptions::E_SWRITER);
661 				break;
662 			case SID_APP_NEW_REPORT:
663 				aReturn.bEnabled = !isDataSourceReadOnly()
664                                     && SvtModuleOptions().IsModuleInstalled(SvtModuleOptions::E_SWRITER);
665                 if ( aReturn.bEnabled )
666                 {
667                     Reference< XContentEnumerationAccess > xEnumAccess(m_xServiceFactory, UNO_QUERY);
668 					aReturn.bEnabled = xEnumAccess.is();
669 	                if ( aReturn.bEnabled )
670                     {
671                         const ::rtl::OUString sReportEngineServiceName = ::dbtools::getDefaultReportEngineServiceName(m_xServiceFactory);
672                         aReturn.bEnabled = sReportEngineServiceName.getLength() != 0;
673                         if ( aReturn.bEnabled )
674                         {
675                     	    const Reference< XEnumeration > xEnumDrivers = xEnumAccess->createContentEnumeration(sReportEngineServiceName);
676                             aReturn.bEnabled = xEnumDrivers.is() && xEnumDrivers->hasMoreElements();
677                         }
678                     }
679                 }
680 				break;
681 			case SID_DB_APP_VIEW_TABLES:
682 				aReturn.bEnabled = sal_True;
683 				aReturn.bChecked = getContainer()->getElementType() == E_TABLE;
684 				break;
685 			case SID_DB_APP_VIEW_QUERIES:
686 				aReturn.bEnabled = sal_True;
687 				aReturn.bChecked = getContainer()->getElementType() == E_QUERY;
688 				break;
689 			case SID_DB_APP_VIEW_FORMS:
690 				aReturn.bEnabled = sal_True;
691 				aReturn.bChecked = getContainer()->getElementType() == E_FORM;
692 				break;
693 			case SID_DB_APP_VIEW_REPORTS:
694 				aReturn.bEnabled = sal_True;
695 				aReturn.bChecked = getContainer()->getElementType() == E_REPORT;
696 				break;
697 			case ID_NEW_QUERY_DESIGN:
698 			case ID_NEW_QUERY_SQL:
699 			case ID_APP_NEW_QUERY_AUTO_PILOT:
700 			case SID_DB_FORM_NEW_PILOT:
701 				aReturn.bEnabled = !isDataSourceReadOnly();
702 				break;
703 			case ID_NEW_VIEW_DESIGN:
704 			case SID_DB_NEW_VIEW_SQL:
705 			case ID_NEW_VIEW_DESIGN_AUTO_PILOT:
706 				aReturn.bEnabled = !isDataSourceReadOnly() && !isConnectionReadOnly();
707 				if ( aReturn.bEnabled )
708 				{
709 					Reference<XViewsSupplier> xViewsSup( getConnection(), UNO_QUERY );
710 					aReturn.bEnabled = xViewsSup.is();
711 				}
712 				break;
713 			case ID_NEW_TABLE_DESIGN:
714 			case ID_NEW_TABLE_DESIGN_AUTO_PILOT:
715 				aReturn.bEnabled = !isDataSourceReadOnly() && !isConnectionReadOnly();
716 				break;
717 			case ID_DIRECT_SQL:
718 				aReturn.bEnabled = sal_True;
719 				break;
720             case ID_MIGRATE_SCRIPTS:
721             {
722                 // Our document supports embedding scripts into it, if and only if there are no
723                 // forms/reports with macros/scripts into them. So, we need to enable migration
724                 // if and only if the database document does *not* support embedding scripts.
725                 bool bAvailable =
726                         !Reference< XEmbeddedScripts >( m_xModel, UNO_QUERY ).is()
727                     &&  !Reference< XStorable >( m_xModel, UNO_QUERY_THROW )->isReadonly();
728                 aReturn.bEnabled = bAvailable;
729                 if ( !bAvailable )
730                     aReturn.bInvisible = true;
731             }
732             break;
733 			case SID_APP_NEW_FOLDER:
734 				aReturn.bEnabled = !isDataSourceReadOnly() && getContainer()->getSelectionCount() <= 1;
735 				if ( aReturn.bEnabled )
736 				{
737 					const ElementType eType = getContainer()->getElementType();
738 					aReturn.bEnabled = eType == E_REPORT || eType == E_FORM;
739 				}
740 				break;
741 			case SID_FORM_CREATE_REPWIZ_PRE_SEL:
742 			case SID_REPORT_CREATE_REPWIZ_PRE_SEL:
743             case SID_APP_NEW_REPORT_PRE_SEL:
744 				aReturn.bEnabled = !isDataSourceReadOnly()
745 									&& SvtModuleOptions().IsModuleInstalled(SvtModuleOptions::E_SWRITER)
746 									&& getContainer()->isALeafSelected();
747 				if ( aReturn.bEnabled )
748 				{
749 					ElementType eType = getContainer()->getElementType();
750 					aReturn.bEnabled = eType == E_QUERY || eType == E_TABLE;
751                     if ( aReturn.bEnabled && SID_APP_NEW_REPORT_PRE_SEL == _nId )
752                     {
753                         Reference< XContentEnumerationAccess > xEnumAccess(m_xServiceFactory, UNO_QUERY);
754 					    aReturn.bEnabled = xEnumAccess.is();
755 	                    if ( aReturn.bEnabled )
756                         {
757                             static ::rtl::OUString s_sReportDesign(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.report.pentaho.SOReportJobFactory"));
758                     	    Reference< XEnumeration > xEnumDrivers = xEnumAccess->createContentEnumeration(s_sReportDesign);
759                             aReturn.bEnabled = xEnumDrivers.is() && xEnumDrivers->hasMoreElements();
760                         }
761                     }
762 				}
763 				break;
764 			case SID_DB_APP_DELETE:
765 			case SID_DB_APP_RENAME:
766 				aReturn.bEnabled = isRenameDeleteAllowed(getContainer()->getElementType(), _nId == SID_DB_APP_DELETE);
767 				break;
768 			case SID_DB_APP_TABLE_DELETE:
769 			case SID_DB_APP_TABLE_RENAME:
770 				aReturn.bEnabled = isRenameDeleteAllowed(E_TABLE, _nId == SID_DB_APP_TABLE_DELETE);
771 				break;
772 			case SID_DB_APP_QUERY_DELETE:
773 			case SID_DB_APP_QUERY_RENAME:
774 				aReturn.bEnabled = isRenameDeleteAllowed(E_QUERY, _nId == SID_DB_APP_QUERY_DELETE);
775 				break;
776 			case SID_DB_APP_FORM_DELETE:
777 			case SID_DB_APP_FORM_RENAME:
778 				aReturn.bEnabled = isRenameDeleteAllowed(E_FORM, _nId == SID_DB_APP_FORM_DELETE);
779 				break;
780 			case SID_DB_APP_REPORT_DELETE:
781 			case SID_DB_APP_REPORT_RENAME:
782 				aReturn.bEnabled = isRenameDeleteAllowed(E_REPORT, _nId == SID_DB_APP_REPORT_DELETE);
783 				break;
784 
785 			case SID_SELECTALL:
786 				aReturn.bEnabled = getContainer()->getElementCount() > 0 && getContainer()->getSelectionCount() != getContainer()->getElementCount();
787 				break;
788 			case SID_DB_APP_EDIT:
789 			case SID_DB_APP_TABLE_EDIT:
790 			case SID_DB_APP_QUERY_EDIT:
791 			case SID_DB_APP_FORM_EDIT:
792 			case SID_DB_APP_REPORT_EDIT:
793 				aReturn.bEnabled = !isDataSourceReadOnly() && getContainer()->getSelectionCount() > 0
794 									&& getContainer()->isALeafSelected();
795 				break;
796 			case SID_DB_APP_EDIT_SQL_VIEW:
797                 if ( isDataSourceReadOnly() )
798 				    aReturn.bEnabled = sal_False;
799                 else
800                 {
801                     switch ( getContainer()->getElementType() )
802                     {
803                     case E_QUERY:
804                         aReturn.bEnabled =  ( getContainer()->getSelectionCount() > 0 )
805                                         &&  ( getContainer()->isALeafSelected() );
806                         break;
807                     case E_TABLE:
808                         aReturn.bEnabled = sal_False;
809                         // there's one exception: views which support altering their underlying
810                         // command can be edited in SQL view, too
811                         if  (   ( getContainer()->getSelectionCount() > 0 )
812                             &&  ( getContainer()->isALeafSelected() )
813                             )
814                         {
815 						    ::std::vector< ::rtl::OUString > aSelected;
816 						    getSelectionElementNames( aSelected );
817                             bool bAlterableViews = true;
818                             for (   ::std::vector< ::rtl::OUString >::const_iterator selectedName = aSelected.begin();
819                                     bAlterableViews && ( selectedName != aSelected.end() ) ;
820                                     ++selectedName
821                                 )
822                             {
823                                 bAlterableViews &= impl_isAlterableView_nothrow( *selectedName );
824                             }
825                             aReturn.bEnabled = bAlterableViews;
826                         }
827                         break;
828                     default:
829                         break;
830                     }
831                 }
832                 break;
833 			case SID_DB_APP_OPEN:
834 			case SID_DB_APP_TABLE_OPEN:
835 			case SID_DB_APP_QUERY_OPEN:
836 			case SID_DB_APP_FORM_OPEN:
837 			case SID_DB_APP_REPORT_OPEN:
838 				aReturn.bEnabled = getContainer()->getSelectionCount() > 0 && getContainer()->isALeafSelected();
839 				break;
840 			case SID_DB_APP_DSUSERADMIN:
841 				aReturn.bEnabled = !m_aTypeCollection.isEmbeddedDatabase(::comphelper::getString(m_xDataSource->getPropertyValue(PROPERTY_URL)));
842 			    break;
843 			case SID_DB_APP_DSRELDESIGN:
844 				aReturn.bEnabled = sal_True;
845 				break;
846 			case SID_DB_APP_TABLEFILTER:
847 				aReturn.bEnabled = !isDataSourceReadOnly();
848 				break;
849 			case SID_DB_APP_REFRESH_TABLES:
850 				aReturn.bEnabled = getContainer()->getElementType() == E_TABLE && isConnected();
851 				break;
852 			case SID_DB_APP_DSPROPS:
853                 aReturn.bEnabled = m_xDataSource.is() && m_aTypeCollection.isShowPropertiesEnabled(::comphelper::getString(m_xDataSource->getPropertyValue(PROPERTY_URL)));
854 				break;
855 			case SID_DB_APP_DSCONNECTION_TYPE:
856                 aReturn.bEnabled = !isDataSourceReadOnly() && m_xDataSource.is() && !m_aTypeCollection.isEmbeddedDatabase(::comphelper::getString(m_xDataSource->getPropertyValue(PROPERTY_URL)));
857 				break;
858 			case SID_DB_APP_DSADVANCED_SETTINGS:
859                 aReturn.bEnabled = m_xDataSource.is() && AdvancedSettingsDialog::doesHaveAnyAdvancedSettings( m_aTypeCollection.getType(::comphelper::getString( m_xDataSource->getPropertyValue( PROPERTY_URL ) )) );
860 				break;
861 			case SID_DB_APP_CONVERTTOVIEW:
862 				aReturn.bEnabled = !isDataSourceReadOnly();
863 				if ( aReturn.bEnabled )
864 				{
865 					ElementType eType = getContainer()->getElementType();
866 					aReturn.bEnabled = eType == E_QUERY && getContainer()->getSelectionCount() > 0;
867 					if ( aReturn.bEnabled )
868 					{
869 						Reference<XViewsSupplier> xViewSup( getConnection(), UNO_QUERY );
870 						aReturn.bEnabled = xViewSup.is() && Reference<XAppend>(xViewSup->getViews(),UNO_QUERY).is();
871 					}
872 				}
873 				break;
874 			case SID_DB_APP_DISABLE_PREVIEW:
875 				aReturn.bEnabled = sal_True;
876 				aReturn.bChecked = getContainer()->getPreviewMode() == E_PREVIEWNONE;
877 				break;
878 			case SID_DB_APP_VIEW_DOCINFO_PREVIEW:
879 				{
880 					ElementType eType = getContainer()->getElementType();
881 					aReturn.bEnabled = (E_REPORT == eType || E_FORM == eType);
882 					aReturn.bChecked = getContainer()->getPreviewMode() == E_DOCUMENTINFO;
883 				}
884 				break;
885 			case SID_DB_APP_VIEW_DOC_PREVIEW:
886 				aReturn.bEnabled = sal_True;
887 				aReturn.bChecked = getContainer()->getPreviewMode() == E_DOCUMENT;
888 				break;
889             case ID_BROWSER_UNDO:
890                 aReturn.bEnabled = sal_False;
891                 break;
892 			case SID_MAIL_SENDDOC:
893 				aReturn.bEnabled = sal_True;
894 				break;
895 			case SID_DB_APP_SENDREPORTASMAIL:
896 				{
897 					ElementType eType = getContainer()->getElementType();
898 					aReturn.bEnabled = E_REPORT == eType && getContainer()->getSelectionCount() > 0 && getContainer()->isALeafSelected();
899 				}
900 				break;
901 			case SID_DB_APP_SENDREPORTTOWRITER:
902 			case SID_DB_APP_DBADMIN:
903 				aReturn.bEnabled = sal_False;
904 				break;
905 			case SID_DB_APP_STATUS_TYPE:
906                 aReturn.bEnabled = m_xDataSource.is();
907 				if ( aReturn.bEnabled )
908 				{
909                     ::rtl::OUString sURL;
910                     m_xDataSource->getPropertyValue(PROPERTY_URL) >>= sURL;
911                     ::rtl::OUString sDSTypeName;
912                     if ( m_aTypeCollection.isEmbeddedDatabase( sURL ) )
913                     {
914                         sDSTypeName = String( ModuleRes( RID_STR_EMBEDDED_DATABASE ) );
915                     }
916                     else
917                     {
918 					    sDSTypeName = m_aTypeCollection.getTypeDisplayName(sURL);
919                     }
920 				    aReturn.sTitle = sDSTypeName;
921 				}
922 				break;
923 			case SID_DB_APP_STATUS_DBNAME:
924 				aReturn.bEnabled = m_xDataSource.is();
925 				if ( aReturn.bEnabled )
926 				{
927 					::rtl::OUString sURL;
928 					m_xDataSource->getPropertyValue(PROPERTY_URL) >>= sURL;
929                     String sDatabaseName;
930 					String sHostName;
931 					sal_Int32 nPortNumber( -1 );
932 
933 					m_aTypeCollection.extractHostNamePort( sURL, sDatabaseName, sHostName, nPortNumber );
934 
935                     if ( !sDatabaseName.Len() )
936 						sDatabaseName = m_aTypeCollection.cutPrefix( sURL );
937 					if ( m_aTypeCollection.isFileSystemBased(sURL) )
938 					{
939 						sDatabaseName = SvtPathOptions().SubstituteVariable( sDatabaseName );
940 						if ( sDatabaseName.Len() )
941 						{
942 							::svt::OFileNotation aFileNotation(sDatabaseName);
943 							// set this decoded URL as text
944 							sDatabaseName = aFileNotation.get(::svt::OFileNotation::N_SYSTEM);
945 						}
946 					}
947 
948                     if ( sDatabaseName.Len() == 0 )
949                         sDatabaseName = m_aTypeCollection.getTypeDisplayName( sURL );
950 
951                     aReturn.sTitle = sDatabaseName;
952 				}
953 				break;
954 			case SID_DB_APP_STATUS_USERNAME:
955 				aReturn.bEnabled = m_xDataSource.is();
956 				if ( aReturn.bEnabled )
957                     m_xDataSource->getPropertyValue( PROPERTY_USER ) >>= aReturn.sTitle;
958 				break;
959 			case SID_DB_APP_STATUS_HOSTNAME:
960 				aReturn.bEnabled = m_xDataSource.is();
961 				if ( aReturn.bEnabled )
962 				{
963 					::rtl::OUString sURL;
964 					m_xDataSource->getPropertyValue( PROPERTY_URL ) >>= sURL;
965 
966 					String sHostName, sDatabaseName;
967 					sal_Int32 nPortNumber = -1;
968 					m_aTypeCollection.extractHostNamePort( sURL, sDatabaseName, sHostName, nPortNumber );
969 					aReturn.sTitle = sHostName;
970 				}
971 				break;
972 			default:
973 				aReturn = OApplicationController_CBASE::GetState(_nId);
974 		}
975 	}
976 	catch(const Exception& )
977 	{
978         DBG_UNHANDLED_EXCEPTION();
979 	}
980 	return aReturn;
981 }
982 
983 // -----------------------------------------------------------------------------
984 namespace
985 {
lcl_handleException_nothrow(const Reference<XModel> & _rxDocument,const Any & _rException)986     bool lcl_handleException_nothrow( const Reference< XModel >& _rxDocument, const Any& _rException )
987     {
988         bool bHandled = false;
989 
990         // try handling the error with an interaction handler
991         ::comphelper::NamedValueCollection aArgs( _rxDocument->getArgs() );
992         Reference< XInteractionHandler > xHandler( aArgs.getOrDefault( "InteractionHandler", Reference< XInteractionHandler >() ) );
993         if ( xHandler.is() )
994         {
995             ::rtl::Reference< ::comphelper::OInteractionRequest > pRequest( new ::comphelper::OInteractionRequest( _rException ) );
996             ::rtl::Reference< ::comphelper::OInteractionApprove > pApprove( new ::comphelper::OInteractionApprove );
997             pRequest->addContinuation( pApprove.get() );
998 
999             try
1000             {
1001                 xHandler->handle( pRequest.get() );
1002             }
1003             catch( const Exception& )
1004             {
1005                 DBG_UNHANDLED_EXCEPTION();
1006             }
1007 
1008             bHandled = pApprove->wasSelected();
1009         }
1010         return bHandled;
1011     }
1012 }
1013 
1014 // -----------------------------------------------------------------------------
Execute(sal_uInt16 _nId,const Sequence<PropertyValue> & aArgs)1015 void OApplicationController::Execute(sal_uInt16 _nId, const Sequence< PropertyValue >& aArgs)
1016 {
1017 	::vos::OGuard aSolarGuard( Application::GetSolarMutex() );
1018 	::osl::MutexGuard aGuard( getMutex() );
1019 
1020     if ( isUserDefinedFeature( _nId ) )
1021     {
1022         OApplicationController_CBASE::Execute( _nId, aArgs );
1023         return;
1024     }
1025 
1026 	if ( !getContainer() || m_bReadOnly )
1027 		return; // return without execution
1028 
1029 	try
1030 	{
1031 		switch(_nId)
1032 		{
1033 			case ID_BROWSER_CUT:
1034 				getContainer()->cut();
1035 				break;
1036 			case ID_BROWSER_COPY:
1037 				{
1038 					TransferableHelper* pTransfer = copyObject( );
1039 					Reference< XTransferable> aEnsureDelete = pTransfer;
1040 
1041 					if ( pTransfer )
1042 						pTransfer->CopyToClipboard(getView());
1043 				}
1044 				break;
1045 			case ID_BROWSER_PASTE:
1046 				{
1047 					const TransferableDataHelper& rTransferData( getViewClipboard() );
1048 					ElementType eType = getContainer()->getElementType();
1049 
1050 					switch( eType )
1051 					{
1052 						case E_TABLE:
1053 							{
1054 								// get the selected tablename
1055 								::std::vector< ::rtl::OUString > aList;
1056 								getSelectionElementNames( aList );
1057 								if ( !aList.empty() )
1058 									m_aTableCopyHelper.SetTableNameForAppend( *aList.begin() );
1059                                 else
1060                                     m_aTableCopyHelper.ResetTableNameForAppend();
1061 
1062 								m_aTableCopyHelper.pasteTable( rTransferData , getDatabaseName(), ensureConnection() );
1063 							}
1064 							break;
1065 
1066 						case E_QUERY:
1067                             if ( rTransferData.HasFormat(SOT_FORMATSTR_ID_DBACCESS_QUERY) )
1068 							    paste( E_QUERY, ODataAccessObjectTransferable::extractObjectDescriptor( rTransferData ) );
1069 							break;
1070 						default:
1071 							{
1072 								::std::vector< ::rtl::OUString> aList;
1073 								getSelectionElementNames(aList);
1074 								::rtl::OUString sFolderNameToInsertInto;
1075 								if ( !aList.empty() )
1076 								{
1077 									Reference< XHierarchicalNameAccess > xContainer(getElements(eType),UNO_QUERY);
1078 									if ( xContainer.is()
1079 										&& xContainer->hasByHierarchicalName(*aList.begin())
1080 										&& (xContainer->getByHierarchicalName(*aList.begin()) >>= xContainer)
1081 										&& xContainer.is()
1082 										)
1083 										sFolderNameToInsertInto = *aList.begin();
1084 								}
1085 								paste( eType, OComponentTransferable::extractComponentDescriptor( rTransferData ),
1086                                     sFolderNameToInsertInto );
1087 							}
1088 							break;
1089 					}
1090 				}
1091 				break;
1092 			case SID_DB_APP_PASTE_SPECIAL:
1093 				{
1094 					if ( !aArgs.getLength() )
1095 					{
1096                         SvxAbstractDialogFactory* pFact = SvxAbstractDialogFactory::Create();
1097                         ::std::auto_ptr<SfxAbstractPasteDialog> pDlg(pFact->CreatePasteDialog( getView() ));
1098 						::std::vector<SotFormatStringId> aFormatIds;
1099 						getSupportedFormats(getContainer()->getElementType(),aFormatIds);
1100 						const ::std::vector<SotFormatStringId>::iterator aEnd = aFormatIds.end();
1101                         ::rtl::OUString sEmpty;
1102 						for (::std::vector<SotFormatStringId>::iterator aIter = aFormatIds.begin();aIter != aEnd; ++aIter)
1103 							pDlg->Insert(*aIter,sEmpty);
1104 
1105 						const TransferableDataHelper& rClipboard = getViewClipboard();
1106 						pasteFormat(pDlg->GetFormat(rClipboard.GetTransferable()));
1107 					}
1108 					else
1109 					{
1110 						const PropertyValue* pIter = aArgs.getConstArray();
1111 						const PropertyValue* pEnd  = pIter + aArgs.getLength();
1112 						for( ; pIter != pEnd ; ++pIter)
1113 						{
1114 							if ( pIter->Name.equalsAscii("FormatStringId") )
1115 							{
1116 								SotFormatStringId nFormatId = 0;
1117 								if ( pIter->Value >>= nFormatId )
1118 									pasteFormat(nFormatId);
1119 								break;
1120 							}
1121 						}
1122 					}
1123 				}
1124 				break;
1125 			case SID_OPENDOC:
1126 			case SID_HELP_INDEX:
1127 				{
1128 					Reference < XDispatchProvider > xProv( getFrame(), UNO_QUERY );
1129 					if ( xProv.is() )
1130 					{
1131 						URL aURL;
1132 						switch(_nId)
1133 						{
1134 							case SID_HELP_INDEX:
1135 								aURL.Complete = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(".uno:HelpIndex"));
1136 								break;
1137 							case SID_OPENDOC:
1138 								aURL.Complete = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(".uno:Open"));
1139 								break;
1140 						}
1141 
1142 						if ( m_xUrlTransformer.is() )
1143 							m_xUrlTransformer->parseStrict( aURL );
1144 						Reference < XDispatch > xDisp = xProv->queryDispatch( aURL, String(), 0 );
1145             			if ( xDisp.is() )
1146                 			xDisp->dispatch( aURL, Sequence < PropertyValue >() );
1147 					}
1148 				}
1149 				break;
1150 			case ID_BROWSER_SAVEDOC:
1151 				{
1152 					Reference< XStorable > xStore( m_xModel, UNO_QUERY_THROW );
1153                     try
1154                     {
1155                         xStore->store();
1156                     }
1157                     catch( const Exception& )
1158                     {
1159                         lcl_handleException_nothrow( m_xModel, ::cppu::getCaughtException() );
1160                     }
1161 				}
1162 				break;
1163 
1164             case ID_BROWSER_SAVEASDOC:
1165 				{
1166 					WinBits nBits(WB_STDMODAL|WB_SAVEAS);
1167                     ::rtl::OUString sUrl;
1168 			        if ( m_xModel.is() )
1169 				        sUrl = m_xModel->getURL();
1170 			        if ( !sUrl.getLength() )
1171                         sUrl = SvtPathOptions().GetWorkPath();
1172 
1173 					::sfx2::FileDialogHelper aFileDlg( com::sun::star::ui::dialogs::TemplateDescription::FILESAVE_AUTOEXTENSION,static_cast<sal_uInt32>(nBits) ,getView());
1174 					aFileDlg.SetDisplayDirectory( sUrl );
1175 
1176 					const SfxFilter* pFilter = getStandardDatabaseFilter();
1177 					if ( pFilter )
1178 					{
1179 						aFileDlg.AddFilter(pFilter->GetUIName(),pFilter->GetDefaultExtension());
1180 						aFileDlg.SetCurrentFilter(pFilter->GetUIName());
1181 					}
1182 
1183 					if ( aFileDlg.Execute() != ERRCODE_NONE )
1184                         break;
1185 
1186                     Reference<XStorable> xStore( m_xModel, UNO_QUERY_THROW );
1187 					INetURLObject aURL( aFileDlg.GetPath() );
1188                     try
1189                     {
1190                         xStore->storeAsURL( aURL.GetMainURL( INetURLObject::NO_DECODE ), Sequence< PropertyValue >() );
1191                     }
1192                     catch( const Exception& )
1193                     {
1194                         lcl_handleException_nothrow( m_xModel, ::cppu::getCaughtException() );
1195                     }
1196 
1197 					/*updateTitle();*/
1198 					m_bCurrentlyModified = sal_False;
1199 					InvalidateFeature(ID_BROWSER_SAVEDOC);
1200                     if ( getContainer()->getElementType() == E_NONE )
1201                     {
1202                         getContainer()->selectContainer(E_NONE);
1203                         getContainer()->selectContainer(E_TABLE);
1204                         // #i95524#
1205                         getContainer()->Invalidate();
1206                         refreshTables();
1207                     }
1208 
1209 				}
1210 				break;
1211 			case ID_BROWSER_SORTUP:
1212 				getContainer()->sortUp();
1213 				InvalidateFeature(ID_BROWSER_SORTDOWN);
1214 				break;
1215 			case ID_BROWSER_SORTDOWN:
1216 				getContainer()->sortDown();
1217 				InvalidateFeature(ID_BROWSER_SORTUP);
1218 				break;
1219 
1220 			case ID_NEW_TABLE_DESIGN_AUTO_PILOT:
1221 			case ID_NEW_VIEW_DESIGN_AUTO_PILOT:
1222 			case ID_APP_NEW_QUERY_AUTO_PILOT:
1223 			case SID_DB_FORM_NEW_PILOT:
1224 			case SID_REPORT_CREATE_REPWIZ_PRE_SEL:
1225             case SID_APP_NEW_REPORT_PRE_SEL:
1226 			case SID_FORM_CREATE_REPWIZ_PRE_SEL:
1227 			case ID_DOCUMENT_CREATE_REPWIZ:
1228 			case SID_APP_NEW_FORM:
1229 			case SID_APP_NEW_REPORT:
1230 			case ID_NEW_QUERY_SQL:
1231 			case ID_NEW_QUERY_DESIGN:
1232 			case ID_NEW_TABLE_DESIGN:
1233 				{
1234 					ElementType eType = E_TABLE;
1235 					sal_Bool bAutoPilot = sal_False;
1236                     ::comphelper::NamedValueCollection aCreationArgs;
1237 
1238 					switch( _nId )
1239 					{
1240 						case SID_DB_FORM_NEW_PILOT:
1241 						case SID_FORM_CREATE_REPWIZ_PRE_SEL:
1242 							bAutoPilot = sal_True;
1243 							// run through
1244 						case SID_APP_NEW_FORM:
1245 							eType = E_FORM;
1246 							break;
1247 						case ID_DOCUMENT_CREATE_REPWIZ:
1248 						case SID_REPORT_CREATE_REPWIZ_PRE_SEL:
1249 							bAutoPilot = sal_True;
1250 							// run through
1251 						case SID_APP_NEW_REPORT:
1252                         case SID_APP_NEW_REPORT_PRE_SEL:
1253 							eType = E_REPORT;
1254 							break;
1255 						case ID_APP_NEW_QUERY_AUTO_PILOT:
1256 							bAutoPilot = sal_True;
1257 							eType = E_QUERY;
1258 							break;
1259 						case ID_NEW_QUERY_DESIGN:
1260                             aCreationArgs.put( (::rtl::OUString)PROPERTY_GRAPHICAL_DESIGN, sal_True );
1261 							// run through
1262 						case ID_NEW_QUERY_SQL:
1263 							eType = E_QUERY;
1264 							break;
1265  						case ID_NEW_TABLE_DESIGN_AUTO_PILOT:
1266  							bAutoPilot = sal_True;
1267  							// run through
1268 						case ID_NEW_TABLE_DESIGN:
1269 							break;
1270 						default:
1271 							OSL_ENSURE(0,"illegal switch call!");
1272 					}
1273                     if ( bAutoPilot )
1274                         getContainer()->PostUserEvent( LINK( this, OApplicationController, OnCreateWithPilot ), reinterpret_cast< void* >( eType ) );
1275                     else
1276                     {
1277                         Reference< XComponent > xDocDefinition;
1278 					    newElement( eType, aCreationArgs, xDocDefinition );
1279                     }
1280 				}
1281 				break;
1282 			case SID_APP_NEW_FOLDER:
1283 				{
1284 					ElementType eType = getContainer()->getElementType();
1285 					::rtl::OUString sName = getContainer()->getQualifiedName( NULL );
1286 					insertHierachyElement(eType,sName);
1287 				}
1288 				break;
1289 			case ID_NEW_VIEW_DESIGN:
1290 			case SID_DB_NEW_VIEW_SQL:
1291 				{
1292                     SharedConnection xConnection( ensureConnection() );
1293 					if ( xConnection.is() )
1294 					{
1295 						QueryDesigner aDesigner( getORB(), this, getFrame(), true );
1296 
1297                         ::comphelper::NamedValueCollection aCreationArgs;
1298                         aCreationArgs.put( (::rtl::OUString)PROPERTY_GRAPHICAL_DESIGN, ID_NEW_VIEW_DESIGN == _nId );
1299 
1300                         const Reference< XDataSource > xDataSource( m_xDataSource, UNO_QUERY );
1301 						const Reference< XComponent > xComponent( aDesigner.createNew( xDataSource, aCreationArgs ), UNO_QUERY );
1302                         onDocumentOpened( ::rtl::OUString(), E_QUERY, E_OPEN_DESIGN, xComponent, NULL );
1303 					}
1304 				}
1305 				break;
1306 			case SID_DB_APP_DELETE:
1307 			case SID_DB_APP_TABLE_DELETE:
1308 			case SID_DB_APP_QUERY_DELETE:
1309 			case SID_DB_APP_FORM_DELETE:
1310 			case SID_DB_APP_REPORT_DELETE:
1311 				deleteEntries();
1312 				break;
1313 			case SID_DB_APP_RENAME:
1314 			case SID_DB_APP_TABLE_RENAME:
1315 			case SID_DB_APP_QUERY_RENAME:
1316 			case SID_DB_APP_FORM_RENAME:
1317 			case SID_DB_APP_REPORT_RENAME:
1318 				renameEntry();
1319 				break;
1320 			case SID_DB_APP_EDIT:
1321 			case SID_DB_APP_EDIT_SQL_VIEW:
1322 			case SID_DB_APP_TABLE_EDIT:
1323 			case SID_DB_APP_QUERY_EDIT:
1324 			case SID_DB_APP_FORM_EDIT:
1325 			case SID_DB_APP_REPORT_EDIT:
1326 				doAction( _nId, E_OPEN_DESIGN );
1327                 break;
1328 			case SID_DB_APP_OPEN:
1329 			case SID_DB_APP_TABLE_OPEN:
1330 			case SID_DB_APP_QUERY_OPEN:
1331 			case SID_DB_APP_FORM_OPEN:
1332 			case SID_DB_APP_REPORT_OPEN:
1333 				doAction( _nId, E_OPEN_NORMAL );
1334 				break;
1335 			case SID_DB_APP_CONVERTTOVIEW:
1336 				doAction( _nId, E_OPEN_NORMAL );
1337 				break;
1338 			case SID_SELECTALL:
1339 				getContainer()->selectAll();
1340 				InvalidateAll();
1341 				break;
1342 			case SID_DB_APP_DSRELDESIGN:
1343             {
1344                 Reference< XComponent > xRelationDesigner;
1345                 if ( !m_pSubComponentManager->activateSubFrame( ::rtl::OUString(), SID_DB_APP_DSRELDESIGN, E_OPEN_DESIGN, xRelationDesigner ) )
1346                 {
1347 				    SharedConnection xConnection( ensureConnection() );
1348 				    if ( xConnection.is() )
1349 				    {
1350 					    RelationDesigner aDesigner( getORB(), this, m_aCurrentFrame.getFrame() );
1351 
1352                         const Reference< XDataSource > xDataSource( m_xDataSource, UNO_QUERY );
1353 					    const Reference< XComponent > xComponent( aDesigner.createNew( xDataSource ), UNO_QUERY );
1354                         onDocumentOpened( ::rtl::OUString(), SID_DB_APP_DSRELDESIGN, E_OPEN_DESIGN, xComponent, NULL );
1355 				    }
1356                 }
1357             }
1358 			break;
1359 			case SID_DB_APP_DSUSERADMIN:
1360 				{
1361 					SharedConnection xConnection( ensureConnection() );
1362 					if ( xConnection.is() )
1363 						openDialog(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sdb.UserAdministrationDialog")));
1364 				}
1365 				break;
1366 			case SID_DB_APP_TABLEFILTER:
1367 				openTableFilterDialog();
1368 				askToReconnect();
1369 				break;
1370 			case SID_DB_APP_REFRESH_TABLES:
1371 				refreshTables();
1372 				break;
1373 			case SID_DB_APP_DSPROPS:
1374 				openDataSourceAdminDialog();
1375 				askToReconnect();
1376 				break;
1377 			case SID_DB_APP_DSADVANCED_SETTINGS:
1378 				openDialog(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sdb.AdvancedDatabaseSettingsDialog")));
1379 				askToReconnect();
1380 				break;
1381 			case SID_DB_APP_DSCONNECTION_TYPE:
1382 				openDialog(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sdb.DataSourceTypeChangeDialog")));
1383 				askToReconnect();
1384 				break;
1385 			case ID_DIRECT_SQL:
1386 				{
1387 					SharedConnection xConnection( ensureConnection() );
1388 					if ( xConnection.is() )
1389 						openDirectSQLDialog();
1390 				}
1391 				break;
1392             case ID_MIGRATE_SCRIPTS:
1393                 impl_migrateScripts_nothrow();
1394                 break;
1395 			case SID_DB_APP_VIEW_TABLES:
1396                 m_aSelectContainerEvent.Call( reinterpret_cast< void* >( E_TABLE ) );
1397 				break;
1398 			case SID_DB_APP_VIEW_QUERIES:
1399                 m_aSelectContainerEvent.Call( reinterpret_cast< void* >( E_QUERY ) );
1400 				break;
1401 			case SID_DB_APP_VIEW_FORMS:
1402                 m_aSelectContainerEvent.Call( reinterpret_cast< void* >( E_FORM ) );
1403 				break;
1404 			case SID_DB_APP_VIEW_REPORTS:
1405                 m_aSelectContainerEvent.Call( reinterpret_cast< void* >( E_REPORT ) );
1406 				break;
1407 			case SID_DB_APP_DISABLE_PREVIEW:
1408 				m_ePreviewMode = E_PREVIEWNONE;
1409 				getContainer()->switchPreview(m_ePreviewMode);
1410 				break;
1411 			case SID_DB_APP_VIEW_DOCINFO_PREVIEW:
1412 				m_ePreviewMode = E_DOCUMENTINFO;
1413 				getContainer()->switchPreview(m_ePreviewMode);
1414 				break;
1415 			case SID_DB_APP_VIEW_DOC_PREVIEW:
1416 				m_ePreviewMode = E_DOCUMENT;
1417 				getContainer()->switchPreview(m_ePreviewMode);
1418 				break;
1419 			case SID_MAIL_SENDDOC:
1420 				{
1421 					SfxMailModel aSendMail;
1422                     if ( aSendMail.AttachDocument(rtl::OUString(),getModel(), rtl::OUString()) == SfxMailModel::SEND_MAIL_OK )
1423 						aSendMail.Send( getFrame() );
1424 				}
1425 				break;
1426 			case SID_DB_APP_SENDREPORTASMAIL:
1427 				doAction( _nId, E_OPEN_FOR_MAIL );
1428 				break;
1429 		}
1430 	}
1431 	catch( const Exception& )
1432 	{
1433         DBG_UNHANDLED_EXCEPTION();
1434 	}
1435 	InvalidateFeature(_nId);
1436 }
1437 // -----------------------------------------------------------------------------
describeSupportedFeatures()1438 void OApplicationController::describeSupportedFeatures()
1439 {
1440 	OApplicationController_CBASE::describeSupportedFeatures();
1441 
1442     implDescribeSupportedFeature( ".uno:Save",               ID_BROWSER_SAVEDOC,        CommandGroup::DOCUMENT );
1443     implDescribeSupportedFeature( ".uno:SaveAs",             ID_BROWSER_SAVEASDOC,      CommandGroup::DOCUMENT );
1444 	implDescribeSupportedFeature( ".uno:SendMail",			 SID_MAIL_SENDDOC,			CommandGroup::DOCUMENT );
1445 	implDescribeSupportedFeature( ".uno:DBSendReportAsMail",SID_DB_APP_SENDREPORTASMAIL,
1446 																						CommandGroup::DOCUMENT );
1447 	implDescribeSupportedFeature( ".uno:DBSendReportToWriter",SID_DB_APP_SENDREPORTTOWRITER,
1448 																						CommandGroup::DOCUMENT );
1449     implDescribeSupportedFeature( ".uno:DBNewForm",          SID_APP_NEW_FORM,          CommandGroup::INSERT );
1450     implDescribeSupportedFeature( ".uno:DBNewFolder",        SID_APP_NEW_FOLDER,        CommandGroup::INSERT );
1451     implDescribeSupportedFeature( ".uno:DBNewFormAutoPilot", SID_DB_FORM_NEW_PILOT,     CommandGroup::INSERT );
1452     implDescribeSupportedFeature( ".uno:DBNewFormAutoPilotWithPreSelection",
1453                                                              SID_FORM_CREATE_REPWIZ_PRE_SEL,
1454                                                                                         CommandGroup::APPLICATION );
1455 
1456 	implDescribeSupportedFeature( ".uno:DBNewReport",		 SID_APP_NEW_REPORT,		CommandGroup::INSERT );
1457     implDescribeSupportedFeature( ".uno:DBNewReportAutoPilot",
1458                                                              ID_DOCUMENT_CREATE_REPWIZ, CommandGroup::INSERT );
1459     implDescribeSupportedFeature( ".uno:DBNewReportAutoPilotWithPreSelection",
1460                                                              SID_REPORT_CREATE_REPWIZ_PRE_SEL,
1461                                                                                         CommandGroup::APPLICATION );
1462     implDescribeSupportedFeature( ".uno:DBNewQuery",         ID_NEW_QUERY_DESIGN,       CommandGroup::INSERT );
1463     implDescribeSupportedFeature( ".uno:DBNewQuerySql",      ID_NEW_QUERY_SQL,          CommandGroup::INSERT );
1464     implDescribeSupportedFeature( ".uno:DBNewQueryAutoPilot",ID_APP_NEW_QUERY_AUTO_PILOT,
1465                                                                                         CommandGroup::INSERT );
1466     implDescribeSupportedFeature( ".uno:DBNewTable",         ID_NEW_TABLE_DESIGN,       CommandGroup::INSERT );
1467     implDescribeSupportedFeature( ".uno:DBNewTableAutoPilot",ID_NEW_TABLE_DESIGN_AUTO_PILOT,
1468                                                                                         CommandGroup::INSERT );
1469     implDescribeSupportedFeature( ".uno:DBNewView",          ID_NEW_VIEW_DESIGN,        CommandGroup::INSERT );
1470     implDescribeSupportedFeature( ".uno:DBNewViewSQL",       SID_DB_NEW_VIEW_SQL,       CommandGroup::INSERT );
1471 
1472     implDescribeSupportedFeature( ".uno:DBDelete",           SID_DB_APP_DELETE,         CommandGroup::EDIT );
1473 	implDescribeSupportedFeature( ".uno:Delete",			 SID_DB_APP_DELETE,         CommandGroup::EDIT );
1474     implDescribeSupportedFeature( ".uno:DBRename",           SID_DB_APP_RENAME,         CommandGroup::EDIT );
1475     implDescribeSupportedFeature( ".uno:DBEdit",             SID_DB_APP_EDIT,           CommandGroup::EDIT );
1476     implDescribeSupportedFeature( ".uno:DBEditSqlView",      SID_DB_APP_EDIT_SQL_VIEW,  CommandGroup::EDIT );
1477     implDescribeSupportedFeature( ".uno:DBOpen",             SID_DB_APP_OPEN,           CommandGroup::EDIT );
1478 
1479     implDescribeSupportedFeature( ".uno:DBTableDelete",      SID_DB_APP_TABLE_DELETE,   CommandGroup::EDIT );
1480     implDescribeSupportedFeature( ".uno:DBTableRename",      SID_DB_APP_TABLE_RENAME,   CommandGroup::EDIT );
1481     implDescribeSupportedFeature( ".uno:DBTableEdit",        SID_DB_APP_TABLE_EDIT,     CommandGroup::EDIT );
1482     implDescribeSupportedFeature( ".uno:DBTableOpen",        SID_DB_APP_TABLE_OPEN,     CommandGroup::EDIT );
1483 
1484     implDescribeSupportedFeature( ".uno:DBQueryDelete",      SID_DB_APP_QUERY_DELETE,   CommandGroup::EDIT );
1485     implDescribeSupportedFeature( ".uno:DBQueryRename",      SID_DB_APP_QUERY_RENAME,   CommandGroup::EDIT );
1486     implDescribeSupportedFeature( ".uno:DBQueryEdit",        SID_DB_APP_QUERY_EDIT,     CommandGroup::EDIT );
1487     implDescribeSupportedFeature( ".uno:DBQueryOpen",        SID_DB_APP_QUERY_OPEN,     CommandGroup::EDIT );
1488 
1489     implDescribeSupportedFeature( ".uno:DBFormDelete",       SID_DB_APP_FORM_DELETE,    CommandGroup::EDIT );
1490     implDescribeSupportedFeature( ".uno:DBFormRename",       SID_DB_APP_FORM_RENAME,    CommandGroup::EDIT );
1491     implDescribeSupportedFeature( ".uno:DBFormEdit",         SID_DB_APP_FORM_EDIT,      CommandGroup::EDIT );
1492     implDescribeSupportedFeature( ".uno:DBFormOpen",         SID_DB_APP_FORM_OPEN,      CommandGroup::EDIT );
1493 
1494     implDescribeSupportedFeature( ".uno:DBReportDelete",     SID_DB_APP_REPORT_DELETE,  CommandGroup::EDIT );
1495     implDescribeSupportedFeature( ".uno:DBReportRename",     SID_DB_APP_REPORT_RENAME,  CommandGroup::EDIT );
1496     implDescribeSupportedFeature( ".uno:DBReportEdit",       SID_DB_APP_REPORT_EDIT,    CommandGroup::EDIT );
1497     implDescribeSupportedFeature( ".uno:DBReportOpen",       SID_DB_APP_REPORT_OPEN,    CommandGroup::EDIT );
1498 
1499     implDescribeSupportedFeature( ".uno:SelectAll",          SID_SELECTALL,             CommandGroup::EDIT );
1500     implDescribeSupportedFeature( ".uno:Undo",               ID_BROWSER_UNDO,           CommandGroup::EDIT );
1501 
1502     implDescribeSupportedFeature( ".uno:Sortup",             ID_BROWSER_SORTUP,         CommandGroup::VIEW );
1503     implDescribeSupportedFeature( ".uno:SortDown",           ID_BROWSER_SORTDOWN,       CommandGroup::VIEW );
1504     implDescribeSupportedFeature( ".uno:DBRelationDesign",   SID_DB_APP_DSRELDESIGN,    CommandGroup::APPLICATION );
1505     implDescribeSupportedFeature( ".uno:DBUserAdmin",        SID_DB_APP_DSUSERADMIN,    CommandGroup::APPLICATION );
1506     implDescribeSupportedFeature( ".uno:DBTableFilter",      SID_DB_APP_TABLEFILTER,    CommandGroup::APPLICATION );
1507     implDescribeSupportedFeature( ".uno:DBDSProperties",     SID_DB_APP_DSPROPS,        CommandGroup::EDIT );
1508     implDescribeSupportedFeature( ".uno:DBDSConnectionType", SID_DB_APP_DSCONNECTION_TYPE,
1509                                                                                         CommandGroup::EDIT );
1510     implDescribeSupportedFeature( ".uno:DBDSAdvancedSettings",
1511                                                              SID_DB_APP_DSADVANCED_SETTINGS,
1512                                                                                         CommandGroup::EDIT );
1513     implDescribeSupportedFeature( ".uno:PasteSpecial",       SID_DB_APP_PASTE_SPECIAL,  CommandGroup::EDIT );
1514     implDescribeSupportedFeature( ".uno:DBConvertToView",    SID_DB_APP_CONVERTTOVIEW,  CommandGroup::EDIT );
1515     implDescribeSupportedFeature( ".uno:DBRefreshTables",    SID_DB_APP_REFRESH_TABLES, CommandGroup::APPLICATION );
1516     implDescribeSupportedFeature( ".uno:DBDirectSQL",        ID_DIRECT_SQL,             CommandGroup::APPLICATION );
1517     implDescribeSupportedFeature( ".uno:DBMigrateScripts",   ID_MIGRATE_SCRIPTS,        CommandGroup::APPLICATION );
1518     implDescribeSupportedFeature( ".uno:DBViewTables",       SID_DB_APP_VIEW_TABLES,    CommandGroup::VIEW );
1519     implDescribeSupportedFeature( ".uno:DBViewQueries",      SID_DB_APP_VIEW_QUERIES,   CommandGroup::VIEW );
1520     implDescribeSupportedFeature( ".uno:DBViewForms",        SID_DB_APP_VIEW_FORMS,     CommandGroup::VIEW );
1521     implDescribeSupportedFeature( ".uno:DBViewReports",      SID_DB_APP_VIEW_REPORTS,   CommandGroup::VIEW );
1522     implDescribeSupportedFeature( ".uno:DBDisablePreview",   SID_DB_APP_DISABLE_PREVIEW,CommandGroup::VIEW );
1523     implDescribeSupportedFeature( ".uno:DBShowDocInfoPreview",
1524                                                              SID_DB_APP_VIEW_DOCINFO_PREVIEW,
1525                                                                                         CommandGroup::VIEW );
1526     implDescribeSupportedFeature( ".uno:DBShowDocPreview",   SID_DB_APP_VIEW_DOC_PREVIEW,
1527                                                                                         CommandGroup::VIEW );
1528 
1529     implDescribeSupportedFeature( ".uno:OpenUrl",            SID_OPENURL,               CommandGroup::APPLICATION );
1530 
1531     // this one should not appear under Tools->Customize->Keyboard
1532     implDescribeSupportedFeature( ".uno:DBNewReportWithPreSelection",
1533                                                              SID_APP_NEW_REPORT_PRE_SEL,CommandGroup::INTERNAL );
1534 	implDescribeSupportedFeature( ".uno:DBDSImport",		SID_DB_APP_DSIMPORT, CommandGroup::INTERNAL);
1535 	implDescribeSupportedFeature( ".uno:DBDSExport",		SID_DB_APP_DSEXPORT, CommandGroup::INTERNAL);
1536 	implDescribeSupportedFeature( ".uno:DBDBAdmin",			SID_DB_APP_DBADMIN, CommandGroup::INTERNAL);
1537 
1538 	// status info
1539 	implDescribeSupportedFeature( ".uno:DBStatusType",		SID_DB_APP_STATUS_TYPE, CommandGroup::INTERNAL);
1540 	implDescribeSupportedFeature( ".uno:DBStatusDBName",	SID_DB_APP_STATUS_DBNAME, CommandGroup::INTERNAL);
1541 	implDescribeSupportedFeature( ".uno:DBStatusUserName",	SID_DB_APP_STATUS_USERNAME, CommandGroup::INTERNAL);
1542 	implDescribeSupportedFeature( ".uno:DBStatusHostName",	SID_DB_APP_STATUS_HOSTNAME, CommandGroup::INTERNAL);
1543 }
1544 // -----------------------------------------------------------------------------
getContainer() const1545 OApplicationView*	OApplicationController::getContainer() const
1546 {
1547 	return static_cast< OApplicationView* >( getView() );
1548 }
1549 
1550 // -----------------------------------------------------------------------------
1551 // ::com::sun::star::container::XContainerListener
elementInserted(const ContainerEvent & _rEvent)1552 void SAL_CALL OApplicationController::elementInserted( const ContainerEvent& _rEvent ) throw(RuntimeException)
1553 {
1554 	::vos::OGuard aSolarGuard(Application::GetSolarMutex());
1555 	::osl::MutexGuard aGuard( getMutex() );
1556 
1557 	Reference< XContainer > xContainer(_rEvent.Source, UNO_QUERY);
1558 	if ( ::std::find(m_aCurrentContainers.begin(),m_aCurrentContainers.end(),xContainer) != m_aCurrentContainers.end() )
1559 	{
1560 		OSL_ENSURE(getContainer(),"View is NULL! -> GPF");
1561 		if ( getContainer() )
1562 		{
1563 			::rtl::OUString sName;
1564 			_rEvent.Accessor >>= sName;
1565 			ElementType eType = getElementType(xContainer);
1566 
1567 			switch( eType )
1568 			{
1569 				case E_TABLE:
1570 					ensureConnection();
1571 					break;
1572 				case E_FORM:
1573 				case E_REPORT:
1574 					{
1575 						Reference< XContainer > xSubContainer(_rEvent.Element,UNO_QUERY);
1576 						if ( xSubContainer.is() )
1577 							containerFound(xSubContainer);
1578 					}
1579 					break;
1580                 default:
1581                     break;
1582 			}
1583 			getContainer()->elementAdded(eType,sName,_rEvent.Element);
1584 		}
1585 	}
1586 }
1587 // -----------------------------------------------------------------------------
elementRemoved(const ContainerEvent & _rEvent)1588 void SAL_CALL OApplicationController::elementRemoved( const ContainerEvent& _rEvent ) throw(RuntimeException)
1589 {
1590 	::vos::OGuard aSolarGuard(Application::GetSolarMutex());
1591 	::osl::MutexGuard aGuard( getMutex() );
1592 
1593 	Reference< XContainer > xContainer(_rEvent.Source, UNO_QUERY);
1594 	if ( ::std::find(m_aCurrentContainers.begin(),m_aCurrentContainers.end(),xContainer) != m_aCurrentContainers.end() )
1595 	{
1596 		OSL_ENSURE(getContainer(),"View is NULL! -> GPF");
1597 		::rtl::OUString sName;
1598 		_rEvent.Accessor >>= sName;
1599 		ElementType eType = getElementType(xContainer);
1600 		switch( eType )
1601 		{
1602 			case E_TABLE:
1603 				ensureConnection();
1604 				break;
1605 			case E_FORM:
1606 			case E_REPORT:
1607 				{
1608 					Reference<XContent> xContent(xContainer,UNO_QUERY);
1609 					if ( xContent.is() )
1610 					{
1611 						sName = xContent->getIdentifier()->getContentIdentifier() + ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("/")) + sName;
1612 					}
1613 				}
1614 				break;
1615             default:
1616                 break;
1617 		}
1618 		getContainer()->elementRemoved(eType,sName);
1619 	}
1620 }
1621 // -----------------------------------------------------------------------------
elementReplaced(const ContainerEvent & _rEvent)1622 void SAL_CALL OApplicationController::elementReplaced( const ContainerEvent& _rEvent ) throw(RuntimeException)
1623 {
1624 	::vos::OGuard aSolarGuard(Application::GetSolarMutex());
1625 	::osl::MutexGuard aGuard( getMutex() );
1626 
1627 	Reference< XContainer > xContainer(_rEvent.Source, UNO_QUERY);
1628 	if ( ::std::find(m_aCurrentContainers.begin(),m_aCurrentContainers.end(),xContainer) != m_aCurrentContainers.end() )
1629 	{
1630 		OSL_ENSURE(getContainer(),"View is NULL! -> GPF");
1631 		::rtl::OUString sName;
1632 		try
1633 		{
1634 			_rEvent.Accessor >>= sName;
1635 			Reference<XConnection> xConnection;
1636 			Reference<XPropertySet> xProp(_rEvent.Element,UNO_QUERY);
1637 			::rtl::OUString sNewName;
1638 
1639 			ElementType eType = getElementType(xContainer);
1640 			switch( eType )
1641 			{
1642 				case E_TABLE:
1643                 {
1644 					ensureConnection();
1645 					if ( xProp.is() && m_xMetaData.is() )
1646 						sNewName = ::dbaui::composeTableName( m_xMetaData, xProp, ::dbtools::eInDataManipulation, false, false, false );
1647                 }
1648 				break;
1649 				case E_FORM:
1650 				case E_REPORT:
1651 					{
1652 						Reference<XContent> xContent(xContainer,UNO_QUERY);
1653 						if ( xContent.is() )
1654 						{
1655 							sName = xContent->getIdentifier()->getContentIdentifier() + ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("/")) + sName;
1656 						}
1657 					}
1658 					break;
1659                 default:
1660                     break;
1661 			}
1662 			//	getContainer()->elementReplaced(getContainer()->getElementType(),sName,sNewName);
1663 		}
1664 		catch( Exception& )
1665 		{
1666             DBG_UNHANDLED_EXCEPTION();
1667 		}
1668 	}
1669 }
1670 namespace
1671 {
lcl_getToolBarResource(ElementType _eType)1672 	::rtl::OUString lcl_getToolBarResource(ElementType _eType)
1673 	{
1674 		::rtl::OUString sToolbar;
1675 		switch(_eType)
1676 		{
1677 			case E_TABLE:
1678 				sToolbar = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "private:resource/toolbar/tableobjectbar" ));
1679 				break;
1680 			case E_QUERY:
1681 				sToolbar = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "private:resource/toolbar/queryobjectbar" ));
1682 				break;
1683 			case E_FORM:
1684 				sToolbar = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "private:resource/toolbar/formobjectbar" ));
1685 				break;
1686 			case E_REPORT:
1687 				sToolbar = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "private:resource/toolbar/reportobjectbar" ));
1688 				break;
1689 			case E_NONE:
1690 				break;
1691 			default:
1692 				OSL_ENSURE(0,"Invalid ElementType!");
1693 				break;
1694 		}
1695 		return sToolbar;
1696 	}
1697 }
1698 // -----------------------------------------------------------------------------
onContainerSelect(ElementType _eType)1699 sal_Bool OApplicationController::onContainerSelect(ElementType _eType)
1700 {
1701 	OSL_ENSURE(getContainer(),"View is NULL! -> GPF");
1702 
1703     if ( m_eCurrentType != _eType && _eType != E_NONE )
1704 	{
1705         SelectionGuard aSelGuard( *m_pSelectionNotifier );
1706 
1707         if ( _eType == E_TABLE )
1708 		{
1709 			try
1710 			{
1711 				SharedConnection xConnection( ensureConnection() );
1712 				if ( xConnection.is() && getContainer()->getDetailView() )
1713 				{
1714 					getContainer()->getDetailView()->createTablesPage(xConnection);
1715 					Reference<XTablesSupplier> xTabSup(xConnection,UNO_QUERY);
1716 					if ( xTabSup.is() )
1717 						addContainerListener(xTabSup->getTables());
1718 				}
1719 				else
1720 				{
1721 					return sal_False;
1722 				}
1723 			}
1724 			catch( const Exception& )
1725 			{
1726 				return sal_False;
1727 			}
1728 		}
1729         Reference< XLayoutManager > xLayoutManager = getLayoutManager( getFrame() );
1730         if ( xLayoutManager.is() )
1731         {
1732 		    ::rtl::OUString sToolbar = lcl_getToolBarResource(_eType);
1733 		    ::rtl::OUString sDestroyToolbar = lcl_getToolBarResource(m_eCurrentType);
1734 
1735 		    xLayoutManager->lock();
1736 		    xLayoutManager->destroyElement( sDestroyToolbar );
1737 		    if ( sToolbar.getLength() )
1738 		    {
1739 			    xLayoutManager->createElement( sToolbar );
1740 			    xLayoutManager->requestElement( sToolbar );
1741 		    }
1742 		    xLayoutManager->unlock();
1743 		    xLayoutManager->doLayout();
1744         }
1745 
1746 		if ( _eType != E_TABLE && getContainer()->getDetailView() )
1747 		{
1748 			Reference< XNameAccess > xContainer = getElements(_eType);
1749 			addContainerListener(xContainer);
1750 			getContainer()->getDetailView()->createPage(_eType,xContainer);
1751 		}
1752 
1753         SelectionByElementType::iterator pendingSelection = m_aPendingSelection.find( _eType );
1754         if ( pendingSelection != m_aPendingSelection.end() )
1755         {
1756             Sequence< ::rtl::OUString > aSelected( pendingSelection->second.size() );
1757             ::std::copy( pendingSelection->second.begin(), pendingSelection->second.end(), aSelected.getArray() );
1758             getContainer()->selectElements( aSelected );
1759 
1760             m_aPendingSelection.erase( pendingSelection );
1761         }
1762 
1763 		InvalidateAll();
1764 	}
1765 	m_eCurrentType = _eType;
1766 
1767 	return sal_True;
1768 }
1769 // -----------------------------------------------------------------------------
onEntryDoubleClick(SvTreeListBox & _rTree)1770 bool OApplicationController::onEntryDoubleClick( SvTreeListBox& _rTree )
1771 {
1772 	if ( getContainer() && getContainer()->isLeaf( _rTree.GetHdlEntry() ) )
1773 	{
1774 		try
1775 		{
1776 			openElement(
1777                 getContainer()->getQualifiedName( _rTree.GetHdlEntry() ),
1778                 getContainer()->getElementType(),
1779                 E_OPEN_NORMAL
1780             );
1781             return true;    // handled
1782 		}
1783 		catch(const Exception&)
1784 		{
1785 			DBG_UNHANDLED_EXCEPTION();
1786 		}
1787 	}
1788     return false;   // not handled
1789 }
1790 // -----------------------------------------------------------------------------
impl_isAlterableView_nothrow(const::rtl::OUString & _rTableOrViewName) const1791 bool OApplicationController::impl_isAlterableView_nothrow( const ::rtl::OUString& _rTableOrViewName ) const
1792 {
1793     OSL_PRECOND( m_xDataSourceConnection.is(), "OApplicationController::impl_isAlterableView_nothrow: no connection!" );
1794 
1795     bool bIsAlterableView( false );
1796     try
1797     {
1798         Reference< XViewsSupplier > xViewsSupp( m_xDataSourceConnection, UNO_QUERY );
1799         Reference< XNameAccess > xViews;
1800         if ( xViewsSupp.is() )
1801             xViews = xViewsSupp->getViews();
1802 
1803         Reference< XAlterView > xAsAlterableView;
1804         if ( xViews.is() && xViews->hasByName( _rTableOrViewName ) )
1805             xAsAlterableView.set( xViews->getByName( _rTableOrViewName ), UNO_QUERY );
1806 
1807         bIsAlterableView = xAsAlterableView.is();
1808     }
1809     catch( const Exception& )
1810     {
1811         DBG_UNHANDLED_EXCEPTION();
1812     }
1813     return bIsAlterableView;
1814 }
1815 
1816 // -----------------------------------------------------------------------------
openElement(const::rtl::OUString & _sName,ElementType _eType,ElementOpenMode _eOpenMode,sal_uInt16 _nInstigatorCommand)1817 Reference< XComponent > OApplicationController::openElement(const ::rtl::OUString& _sName, ElementType _eType,
1818     ElementOpenMode _eOpenMode, sal_uInt16 _nInstigatorCommand )
1819 {
1820     return openElementWithArguments( _sName, _eType, _eOpenMode, _nInstigatorCommand, ::comphelper::NamedValueCollection() );
1821 }
1822 
1823 // -----------------------------------------------------------------------------
openElementWithArguments(const::rtl::OUString & _sName,ElementType _eType,ElementOpenMode _eOpenMode,sal_uInt16 _nInstigatorCommand,const::comphelper::NamedValueCollection & _rAdditionalArguments)1824 Reference< XComponent > OApplicationController::openElementWithArguments( const ::rtl::OUString& _sName, ElementType _eType,
1825     ElementOpenMode _eOpenMode, sal_uInt16 _nInstigatorCommand, const ::comphelper::NamedValueCollection& _rAdditionalArguments )
1826 {
1827     OSL_PRECOND( getContainer(), "OApplicationController::openElementWithArguments: no view!" );
1828     if ( !getContainer() )
1829         return NULL;
1830 
1831 	Reference< XComponent > xRet;
1832 	if ( _eOpenMode == E_OPEN_DESIGN )
1833 	{
1834 		// OJ: http://www.openoffice.org/issues/show_bug.cgi?id=30382
1835 		getContainer()->showPreview(NULL);
1836 	}
1837 
1838     bool isStandaloneDocument = false;
1839     switch ( _eType )
1840 	{
1841 	case E_REPORT:
1842         if ( _eOpenMode != E_OPEN_DESIGN )
1843         {
1844             // reports which are opened in a mode other than design are no sub components of our application
1845             // component, but standalone documents.
1846             isStandaloneDocument = true;
1847         }
1848         // NO break!
1849 	case E_FORM:
1850 	{
1851         if ( isStandaloneDocument || !m_pSubComponentManager->activateSubFrame( _sName, _eType, _eOpenMode, xRet ) )
1852         {
1853 		    ::std::auto_ptr< OLinkedDocumentsAccess > aHelper = getDocumentsAccess( _eType );
1854             if ( !aHelper->isConnected() )
1855                 break;
1856 
1857 		    Reference< XComponent > xDefinition;
1858 		    xRet = aHelper->open( _sName, xDefinition, _eOpenMode, _rAdditionalArguments );
1859 
1860             if ( !isStandaloneDocument )
1861 		        onDocumentOpened( _sName, _eType, _eOpenMode, xRet, xDefinition );
1862         }
1863 	}
1864 	break;
1865 
1866 	case E_QUERY:
1867 	case E_TABLE:
1868 	{
1869         if ( !m_pSubComponentManager->activateSubFrame( _sName, _eType, _eOpenMode, xRet ) )
1870         {
1871 		    SharedConnection xConnection( ensureConnection() );
1872 		    if ( !xConnection.is() )
1873                 break;
1874 
1875             ::std::auto_ptr< DatabaseObjectView > pDesigner;
1876             ::comphelper::NamedValueCollection aArguments( _rAdditionalArguments );
1877 
1878             Any aDataSource;
1879 		    if ( _eOpenMode == E_OPEN_DESIGN )
1880 		    {
1881                 bool bAddViewTypeArg = false;
1882 
1883 			    if ( _eType == E_TABLE )
1884 			    {
1885                     if ( impl_isAlterableView_nothrow( _sName ) )
1886                     {
1887                         pDesigner.reset( new QueryDesigner( getORB(), this, m_aCurrentFrame.getFrame(), true ) );
1888                         bAddViewTypeArg = true;
1889                     }
1890                     else
1891                     {
1892                         pDesigner.reset( new TableDesigner( getORB(), this, m_aCurrentFrame.getFrame() ) );
1893                     }
1894 			    }
1895 			    else if ( _eType == E_QUERY )
1896 			    {
1897                     pDesigner.reset( new QueryDesigner( getORB(), this, m_aCurrentFrame.getFrame(), false ) );
1898                     bAddViewTypeArg = true;
1899 			    }
1900 			    aDataSource <<= m_xDataSource;
1901 
1902                 if ( bAddViewTypeArg )
1903                 {
1904                     const bool bQueryGraphicalMode =( _nInstigatorCommand != SID_DB_APP_EDIT_SQL_VIEW );
1905                     aArguments.put( (::rtl::OUString)PROPERTY_GRAPHICAL_DESIGN, bQueryGraphicalMode );
1906                 }
1907 
1908 		    }
1909 		    else
1910 		    {
1911 			    pDesigner.reset( new ResultSetBrowser( getORB(), this, m_aCurrentFrame.getFrame(), _eType == E_TABLE ) );
1912 
1913                 if ( !aArguments.has( (::rtl::OUString)PROPERTY_SHOWMENU ) )
1914                     aArguments.put( (::rtl::OUString)PROPERTY_SHOWMENU, makeAny( (sal_Bool)sal_True ) );
1915 
1916 		        aDataSource <<= getDatabaseName();
1917 		    }
1918 
1919 		    xRet.set( pDesigner->openExisting( aDataSource, _sName, aArguments ) );
1920 	        onDocumentOpened( _sName, _eType, _eOpenMode, xRet, NULL );
1921         }
1922 	}
1923 	break;
1924 
1925     default:
1926         OSL_ENSURE( false, "OApplicationController::openElement: illegal object type!" );
1927         break;
1928 	}
1929 	return xRet;
1930 }
1931 // -----------------------------------------------------------------------------
IMPL_LINK(OApplicationController,OnSelectContainer,void *,_pType)1932 IMPL_LINK( OApplicationController, OnSelectContainer, void*, _pType )
1933 {
1934     ElementType eType = (ElementType)reinterpret_cast< sal_IntPtr >( _pType );
1935     getContainer()->selectContainer(eType);
1936     return 0L;
1937 }
1938 // -----------------------------------------------------------------------------
IMPL_LINK(OApplicationController,OnCreateWithPilot,void *,_pType)1939 IMPL_LINK( OApplicationController, OnCreateWithPilot, void*, _pType )
1940 {
1941     ElementType eType = (ElementType)reinterpret_cast< sal_IntPtr >( _pType );
1942     newElementWithPilot( eType );
1943     return 0L;
1944 }
1945 
1946 // -----------------------------------------------------------------------------
newElementWithPilot(ElementType _eType)1947 void OApplicationController::newElementWithPilot( ElementType _eType )
1948 {
1949     CloseVeto aKeepDoc( getFrame() );
1950         // prevent the document being closed while the wizard is open
1951 
1952     OSL_ENSURE( getContainer(), "OApplicationController::newElementWithPilot: without a view?" );
1953 
1954 	switch ( _eType )
1955 	{
1956 		case E_REPORT:
1957 		case E_FORM:
1958 		{
1959 			::std::auto_ptr<OLinkedDocumentsAccess> aHelper = getDocumentsAccess(_eType);
1960             if ( aHelper->isConnected() )
1961 			{
1962                 sal_Int32 nCommandType = -1;
1963                 const ::rtl::OUString sCurrentSelected( getCurrentlySelectedName( nCommandType ) );
1964 				if ( E_REPORT == _eType )
1965 					aHelper->newReportWithPilot( nCommandType, sCurrentSelected );
1966 				else
1967 					aHelper->newFormWithPilot( nCommandType, sCurrentSelected );
1968 			}
1969         }
1970         break;
1971         case E_QUERY:
1972         case E_TABLE:
1973  		{
1974 		    ::std::auto_ptr<OLinkedDocumentsAccess> aHelper = getDocumentsAccess(_eType);
1975             if ( aHelper->isConnected() )
1976             {
1977 		        if ( E_QUERY == _eType )
1978 			        aHelper->newQueryWithPilot();
1979 		        else
1980 			        aHelper->newTableWithPilot();
1981 		    }
1982  		}
1983  		break;
1984         case E_NONE:
1985             break;
1986     }
1987 
1988     // no need for onDocumentOpened, the table wizard opens the created table by using
1989     // XDatabaseDocumentUI::loadComponent method.
1990 }
1991 
1992 // -----------------------------------------------------------------------------
newElement(ElementType _eType,const::comphelper::NamedValueCollection & i_rAdditionalArguments,Reference<XComponent> & o_rDocumentDefinition)1993 Reference< XComponent > OApplicationController::newElement( ElementType _eType, const ::comphelper::NamedValueCollection& i_rAdditionalArguments,
1994                                                            Reference< XComponent >& o_rDocumentDefinition )
1995 {
1996 	OSL_ENSURE(getContainer(),"View is NULL! -> GPF");
1997 
1998     Reference< XComponent > xComponent;
1999     o_rDocumentDefinition.clear();
2000 
2001 	switch ( _eType )
2002 	{
2003         case E_FORM:
2004 		case E_REPORT:
2005 		{
2006 			::std::auto_ptr<OLinkedDocumentsAccess> aHelper = getDocumentsAccess( _eType );
2007             if ( !aHelper->isConnected() )
2008                 break;
2009 
2010             xComponent = aHelper->newDocument( _eType == E_FORM ? ID_FORM_NEW_TEXT : ID_REPORT_NEW_TEXT, i_rAdditionalArguments, o_rDocumentDefinition );
2011 		}
2012 		break;
2013 
2014 		case E_QUERY:
2015 		case E_TABLE:
2016 		{
2017 			::std::auto_ptr< DatabaseObjectView > pDesigner;
2018 			SharedConnection xConnection( ensureConnection() );
2019 			if ( !xConnection.is() )
2020                 break;
2021 
2022             if ( _eType == E_TABLE )
2023 			{
2024 				pDesigner.reset( new TableDesigner( getORB(), this, getFrame() ) );
2025 			}
2026 			else if ( _eType == E_QUERY )
2027 			{
2028 				pDesigner.reset( new QueryDesigner( getORB(), this, getFrame(), false ) );
2029 			}
2030 
2031             Reference< XDataSource > xDataSource( m_xDataSource, UNO_QUERY );
2032 			xComponent.set( pDesigner->createNew( xDataSource, i_rAdditionalArguments ), UNO_QUERY );
2033 		}
2034 		break;
2035 
2036         default:
2037             OSL_ENSURE( false, "OApplicationController::newElement: illegal type!" );
2038             break;
2039 	}
2040 
2041     if ( xComponent.is() )
2042         onDocumentOpened( ::rtl::OUString(), _eType, E_OPEN_DESIGN, xComponent, o_rDocumentDefinition );
2043 
2044     return xComponent;
2045 }
2046 
2047 // -----------------------------------------------------------------------------
addContainerListener(const Reference<XNameAccess> & _xCollection)2048 void OApplicationController::addContainerListener(const Reference<XNameAccess>& _xCollection)
2049 {
2050 	try
2051 	{
2052 		Reference< XContainer > xCont(_xCollection, UNO_QUERY);
2053 		if ( xCont.is() )
2054 		{
2055 			// add as listener to get notified if elements are inserted or removed
2056 			TContainerVector::iterator aFind = ::std::find(m_aCurrentContainers.begin(),m_aCurrentContainers.end(),xCont);
2057 			if ( aFind == m_aCurrentContainers.end() )
2058 			{
2059 				xCont->addContainerListener(this);
2060 				m_aCurrentContainers.push_back(xCont);
2061 			}
2062 		}
2063 	}
2064 	catch( const Exception& )
2065 	{
2066         DBG_UNHANDLED_EXCEPTION();
2067 	}
2068 }
2069 // -----------------------------------------------------------------------------
renameEntry()2070 void OApplicationController::renameEntry()
2071 {
2072 	::vos::OGuard aSolarGuard(Application::GetSolarMutex());
2073 	::osl::MutexGuard aGuard( getMutex() );
2074 
2075 	OSL_ENSURE(getContainer(),"View is NULL! -> GPF");
2076 	::std::vector< ::rtl::OUString> aList;
2077 	getSelectionElementNames(aList);
2078 
2079 	Reference< XNameAccess > xContainer = getElements(getContainer()->getElementType());
2080 	OSL_ENSURE(aList.size() == 1,"Invalid rename call here. More than one element!");
2081     if ( aList.empty() )
2082         return;
2083 
2084 	try
2085 	{
2086 		if ( xContainer.is() )
2087 		{
2088             ::std::auto_ptr< IObjectNameCheck > pNameChecker;
2089             ::std::auto_ptr< OSaveAsDlg > aDialog;
2090 
2091 			Reference<XRename> xRename;
2092 			const ElementType eType = getContainer()->getElementType();
2093 			switch( eType )
2094 			{
2095 				case E_FORM:
2096 				case E_REPORT:
2097 					{
2098 						Reference<XHierarchicalNameContainer> xHNames(xContainer, UNO_QUERY);
2099 						if ( xHNames.is() )
2100 						{
2101 							String sLabel;
2102 							if ( eType == E_FORM )
2103 								sLabel = String(ModuleRes( STR_FRM_LABEL ));
2104 							else
2105 								sLabel = String(ModuleRes( STR_RPT_LABEL ));
2106 
2107 							::rtl::OUString sName = *aList.begin();
2108 							if ( xHNames->hasByHierarchicalName(sName) )
2109 							{
2110 								xRename.set(xHNames->getByHierarchicalName(sName),UNO_QUERY);
2111 								Reference<XChild> xChild(xRename,UNO_QUERY);
2112 								if ( xChild.is() )
2113 								{
2114 									Reference<XHierarchicalNameContainer> xParent(xChild->getParent(),UNO_QUERY);
2115 									if ( xParent.is() )
2116 									{
2117 										xHNames = xParent;
2118 										Reference<XPropertySet>(xRename,UNO_QUERY)->getPropertyValue(PROPERTY_NAME) >>= sName;
2119 									}
2120 								}
2121                                 pNameChecker.reset( new HierarchicalNameCheck( xHNames.get(), String() ) );
2122 								aDialog.reset( new OSaveAsDlg(
2123                                     getView(), getORB(), sName, sLabel, *pNameChecker, SAD_TITLE_RENAME ) );
2124 							}
2125 						}
2126 					}
2127 					break;
2128 				case E_TABLE:
2129                     ensureConnection();
2130                     if ( !getConnection().is() )
2131                         break;
2132                     // NO break
2133 				case E_QUERY:
2134 					if ( xContainer->hasByName(*aList.begin()) )
2135 					{
2136 						xRename.set(xContainer->getByName(*aList.begin()),UNO_QUERY);
2137                         sal_Int32 nCommandType = eType == E_QUERY ? CommandType::QUERY : CommandType::TABLE;
2138 
2139                         ensureConnection();
2140                         pNameChecker.reset( new DynamicTableOrQueryNameCheck( getConnection(), nCommandType ) );
2141 					    aDialog.reset( new OSaveAsDlg(
2142                             getView(), nCommandType, getORB(), getConnection(),
2143                                 *aList.begin(), *pNameChecker, SAD_TITLE_RENAME ) );
2144 					}
2145 					break;
2146                 default:
2147                     break;
2148 			}
2149 
2150 			if ( xRename.is() && aDialog.get() )
2151 			{
2152 
2153 				sal_Bool bTryAgain = sal_True;
2154 				while( bTryAgain )
2155 				{
2156 					if ( aDialog->Execute() == RET_OK )
2157 					{
2158 						try
2159 						{
2160 							::rtl::OUString sNewName;
2161 							if ( eType == E_TABLE )
2162 							{
2163 								::rtl::OUString sName = aDialog->getName();
2164 								::rtl::OUString sCatalog = aDialog->getCatalog();
2165 								::rtl::OUString sSchema	 = aDialog->getSchema();
2166 
2167 								sNewName = ::dbtools::composeTableName( m_xMetaData, sCatalog, sSchema, sName, sal_False, ::dbtools::eInDataManipulation );
2168 							}
2169 							else
2170 								sNewName = aDialog->getName();
2171 
2172 							::rtl::OUString sOldName = *aList.begin();
2173 							if ( eType == E_FORM || eType == E_REPORT )
2174 							{
2175 								Reference<XContent> xContent(xRename,UNO_QUERY);
2176 								if ( xContent.is() )
2177 								{
2178 									sOldName = xContent->getIdentifier()->getContentIdentifier();
2179 								}
2180 							}
2181 
2182 							xRename->rename(sNewName);
2183 
2184                             if ( eType == E_TABLE )
2185                             {
2186                                 Reference<XPropertySet> xProp(xRename,UNO_QUERY);
2187                                 sNewName = ::dbaui::composeTableName( m_xMetaData, xProp, ::dbtools::eInDataManipulation, false, false, false );
2188                             }
2189 							getContainer()->elementReplaced( eType , sOldName, sNewName );
2190 
2191 							bTryAgain = sal_False;
2192 						}
2193 						catch(const SQLException& )
2194                         {
2195                             showError( SQLExceptionInfo( ::cppu::getCaughtException() ) );
2196 
2197 						}
2198 						catch(const ElementExistException& e)
2199 						{
2200 							static ::rtl::OUString sStatus = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("S1000"));
2201 							String sMsg = String( ModuleRes( STR_NAME_ALREADY_EXISTS ) );
2202 							sMsg.SearchAndReplace('#',e.Message);
2203 							showError(SQLExceptionInfo(SQLException(sMsg, e.Context, sStatus, 0, Any())));
2204 						}
2205 						catch(const Exception& )
2206 						{
2207                             DBG_UNHANDLED_EXCEPTION();
2208 						}
2209 					}
2210 					else
2211 						bTryAgain = sal_False;
2212 				}
2213 			}
2214 		}
2215 	}
2216 	catch(const Exception& )
2217 	{
2218         DBG_UNHANDLED_EXCEPTION();
2219 	}
2220 }
2221 
2222 // -----------------------------------------------------------------------------
onSelectionChanged()2223 void OApplicationController::onSelectionChanged()
2224 {
2225 	InvalidateAll();
2226 
2227     SelectionGuard aSelGuard( *m_pSelectionNotifier );
2228 
2229 	OApplicationView* pView = getContainer();
2230     if ( !pView )
2231         return;
2232 
2233     if ( pView->getSelectionCount() == 1 )
2234     {
2235         const ElementType eType = pView->getElementType();
2236   	    if ( pView->isALeafSelected() )
2237         {
2238             const ::rtl::OUString sName = pView->getQualifiedName( NULL /* means 'first selected' */ );
2239             showPreviewFor( eType, sName );
2240         }
2241     }
2242 }
2243 // -----------------------------------------------------------------------------
showPreviewFor(const ElementType _eType,const::rtl::OUString & _sName)2244 void OApplicationController::showPreviewFor(const ElementType _eType,const ::rtl::OUString& _sName)
2245 {
2246     if ( m_ePreviewMode == E_PREVIEWNONE )
2247         return;
2248 
2249     OApplicationView* pView = getContainer();
2250     if ( !pView )
2251         return;
2252 
2253 	try
2254 	{
2255 		switch( _eType )
2256 		{
2257 			case E_FORM:
2258 			case E_REPORT:
2259             {
2260 				Reference< XHierarchicalNameAccess > xContainer( getElements( _eType ), UNO_QUERY_THROW );
2261                 Reference< XContent> xContent( xContainer->getByHierarchicalName( _sName ), UNO_QUERY_THROW );
2262 	            pView->showPreview( xContent );
2263             }
2264 			break;
2265 
2266             case E_TABLE:
2267 			case E_QUERY:
2268                 {
2269                     SharedConnection xConnection( ensureConnection() );
2270 					if ( xConnection.is() )
2271 						pView->showPreview( getDatabaseName(), xConnection, _sName, _eType == E_TABLE );
2272                 }
2273 				return;
2274 
2275             default:
2276                 OSL_ENSURE( false, "OApplicationController::showPreviewFor: unexpected element type!" );
2277                 break;
2278 		}
2279 	}
2280 	catch( const SQLException& )
2281 	{
2282         showError( SQLExceptionInfo( ::cppu::getCaughtException() ) );
2283 	}
2284 	catch(const Exception& )
2285 	{
2286         DBG_UNHANDLED_EXCEPTION();
2287 	}
2288 }
2289 
2290 //------------------------------------------------------------------------------
IMPL_LINK(OApplicationController,OnClipboardChanged,void *,EMPTYARG)2291 IMPL_LINK( OApplicationController, OnClipboardChanged, void*, EMPTYARG )
2292 {
2293 	return OnInvalidateClipboard( NULL );
2294 }
2295 //------------------------------------------------------------------------------
IMPL_LINK(OApplicationController,OnInvalidateClipboard,void *,EMPTYARG)2296 IMPL_LINK(OApplicationController, OnInvalidateClipboard, void*, EMPTYARG)
2297 {
2298 	InvalidateFeature(ID_BROWSER_CUT);
2299 	InvalidateFeature(ID_BROWSER_COPY);
2300 	InvalidateFeature(ID_BROWSER_PASTE);
2301 	InvalidateFeature(SID_DB_APP_PASTE_SPECIAL);
2302 	return 0L;
2303 }
2304 // -----------------------------------------------------------------------------
onCutEntry()2305 void OApplicationController::onCutEntry()
2306 {
2307 }
2308 // -----------------------------------------------------------------------------
onCopyEntry()2309 void OApplicationController::onCopyEntry()
2310 {
2311 	Execute(ID_BROWSER_COPY,Sequence<PropertyValue>());
2312 }
2313 // -----------------------------------------------------------------------------
onPasteEntry()2314 void OApplicationController::onPasteEntry()
2315 {
2316 	Execute(ID_BROWSER_PASTE,Sequence<PropertyValue>());
2317 }
2318 // -----------------------------------------------------------------------------
onDeleteEntry()2319 void OApplicationController::onDeleteEntry()
2320 {
2321 	ElementType eType = getContainer()->getElementType();
2322 	sal_uInt16 nId = 0;
2323 	switch(eType)
2324 	{
2325 		case E_TABLE:
2326 			nId = SID_DB_APP_TABLE_DELETE;
2327 			break;
2328 		case E_QUERY:
2329 			nId = SID_DB_APP_QUERY_DELETE;
2330 			break;
2331 		case E_FORM:
2332 			nId = SID_DB_APP_FORM_DELETE;
2333 			break;
2334 		case E_REPORT:
2335 			nId = SID_DB_APP_REPORT_DELETE;
2336 			break;
2337 		default:
2338 			OSL_ENSURE(0,"Invalid ElementType!");
2339 			break;
2340 	}
2341 	executeChecked(nId,Sequence<PropertyValue>());
2342 }
2343 
2344 // -----------------------------------------------------------------------------
executeUnChecked(const URL & _rCommand,const Sequence<PropertyValue> & aArgs)2345 void OApplicationController::executeUnChecked(const URL& _rCommand, const Sequence< PropertyValue>& aArgs)
2346 {
2347     OApplicationController_CBASE::executeUnChecked( _rCommand, aArgs );
2348 }
2349 
2350 // -----------------------------------------------------------------------------
executeChecked(const URL & _rCommand,const Sequence<PropertyValue> & aArgs)2351 void OApplicationController::executeChecked(const URL& _rCommand, const Sequence< PropertyValue>& aArgs)
2352 {
2353     OApplicationController_CBASE::executeChecked( _rCommand, aArgs );
2354 }
2355 
2356 // -----------------------------------------------------------------------------
executeUnChecked(sal_uInt16 _nCommandId,const Sequence<PropertyValue> & aArgs)2357 void OApplicationController::executeUnChecked(sal_uInt16 _nCommandId, const Sequence< PropertyValue>& aArgs)
2358 {
2359     OApplicationController_CBASE::executeUnChecked( _nCommandId, aArgs );
2360 }
2361 
2362 // -----------------------------------------------------------------------------
executeChecked(sal_uInt16 _nCommandId,const Sequence<PropertyValue> & aArgs)2363 void OApplicationController::executeChecked(sal_uInt16 _nCommandId, const Sequence< PropertyValue>& aArgs)
2364 {
2365     OApplicationController_CBASE::executeChecked( _nCommandId, aArgs );
2366 }
2367 
2368 // -----------------------------------------------------------------------------
isCommandEnabled(sal_uInt16 _nCommandId) const2369 sal_Bool OApplicationController::isCommandEnabled(sal_uInt16 _nCommandId) const
2370 {
2371     return OApplicationController_CBASE::isCommandEnabled( _nCommandId );
2372 }
2373 
2374 // -----------------------------------------------------------------------------
isCommandEnabled(const::rtl::OUString & _rCompleteCommandURL) const2375 sal_Bool OApplicationController::isCommandEnabled( const ::rtl::OUString& _rCompleteCommandURL ) const
2376 {
2377     return OApplicationController_CBASE::isCommandEnabled( _rCompleteCommandURL );
2378 }
2379 
2380 // -----------------------------------------------------------------------------
registerCommandURL(const::rtl::OUString & _rCompleteCommandURL)2381 sal_uInt16 OApplicationController::registerCommandURL( const ::rtl::OUString& _rCompleteCommandURL )
2382 {
2383     return OApplicationController_CBASE::registerCommandURL( _rCompleteCommandURL );
2384 }
2385 
2386 // -----------------------------------------------------------------------------
notifyHiContrastChanged()2387 void OApplicationController::notifyHiContrastChanged()
2388 {
2389     OApplicationController_CBASE::notifyHiContrastChanged();
2390 }
2391 
2392 // -----------------------------------------------------------------------------
getXController()2393 Reference< XController > OApplicationController::getXController() throw( RuntimeException )
2394 {
2395     return OApplicationController_CBASE::getXController();
2396 }
2397 
2398 // -----------------------------------------------------------------------------
interceptUserInput(const NotifyEvent & _rEvent)2399 bool OApplicationController::interceptUserInput( const NotifyEvent& _rEvent )
2400 {
2401     return OApplicationController_CBASE::interceptUserInput( _rEvent );
2402 }
2403 
2404 // -----------------------------------------------------------------------------
getContextMenu(Control &) const2405 PopupMenu* OApplicationController::getContextMenu( Control& /*_rControl*/ ) const
2406 {
2407     return new PopupMenu( ModuleRes( RID_MENU_APP_EDIT ) );
2408 }
2409 
2410 // -----------------------------------------------------------------------------
getCommandController()2411 IController& OApplicationController::getCommandController()
2412 {
2413     return *static_cast< IApplicationController* >( this );
2414 }
2415 
2416 // -----------------------------------------------------------------------------
getContextMenuInterceptors()2417 ::cppu::OInterfaceContainerHelper* OApplicationController::getContextMenuInterceptors()
2418 {
2419     return &m_aContextMenuInterceptors;
2420 }
2421 
2422 // -----------------------------------------------------------------------------
getCurrentSelection(Control & _rControl) const2423 Any OApplicationController::getCurrentSelection( Control& _rControl ) const
2424 {
2425     Sequence< NamedDatabaseObject > aSelection;
2426 	getContainer()->describeCurrentSelectionForControl( _rControl, aSelection );
2427     return makeAny( aSelection );
2428 }
2429 
2430 // -----------------------------------------------------------------------------
requestQuickHelp(const SvLBoxEntry *,String &) const2431 sal_Bool OApplicationController::requestQuickHelp( const SvLBoxEntry* /*_pEntry*/, String& /*_rText*/ ) const
2432 {
2433     return sal_False;
2434 }
2435 
2436 // -----------------------------------------------------------------------------
requestDrag(sal_Int8,const Point &)2437 sal_Bool OApplicationController::requestDrag( sal_Int8 /*_nAction*/, const Point& /*_rPosPixel*/ )
2438 {
2439 	TransferableHelper* pTransfer = NULL;
2440 	if ( getContainer() && getContainer()->getSelectionCount() )
2441 	{
2442 		try
2443 		{
2444 			pTransfer = copyObject( );
2445 			Reference< XTransferable> xEnsureDelete = pTransfer;
2446 
2447 			if ( pTransfer && getContainer()->getDetailView() )
2448 			{
2449 				ElementType eType = getContainer()->getElementType();
2450 				pTransfer->StartDrag( getContainer()->getDetailView()->getTreeWindow(), ((eType == E_FORM || eType == E_REPORT) ? DND_ACTION_COPYMOVE : DND_ACTION_COPY) );
2451 			}
2452 		}
2453 		catch(const Exception& )
2454 		{
2455             DBG_UNHANDLED_EXCEPTION();
2456 		}
2457 	}
2458 
2459 	return NULL != pTransfer;
2460 }
2461 // -----------------------------------------------------------------------------
queryDrop(const AcceptDropEvent & _rEvt,const DataFlavorExVector & _rFlavors)2462 sal_Int8 OApplicationController::queryDrop( const AcceptDropEvent& _rEvt, const DataFlavorExVector& _rFlavors )
2463 {
2464 	sal_Int8 nActionAskedFor = _rEvt.mnAction;
2465 	// check if we're a table or query container
2466 	OApplicationView* pView = getContainer();
2467 	if ( pView && !isDataSourceReadOnly() )
2468 	{
2469 		ElementType eType = pView->getElementType();
2470 		if ( eType != E_NONE && (eType != E_TABLE || !isConnectionReadOnly()) )
2471 		{
2472 			// check for the concrete type
2473 			if(::std::find_if(_rFlavors.begin(),_rFlavors.end(),TAppSupportedSotFunctor(eType,sal_True)) != _rFlavors.end())
2474 				return DND_ACTION_COPY;
2475 			if ( eType == E_FORM || eType == E_REPORT )
2476 			{
2477 				sal_Int8 nAction = OComponentTransferable::canExtractComponentDescriptor(_rFlavors,eType == E_FORM) ? DND_ACTION_COPY : DND_ACTION_NONE;
2478 				if ( nAction != DND_ACTION_NONE )
2479 				{
2480 					SvLBoxEntry* pHitEntry = pView->getEntry(_rEvt.maPosPixel);
2481 					::rtl::OUString sName;
2482 					if ( pHitEntry )
2483 					{
2484 						sName = pView->getQualifiedName( pHitEntry );
2485 						if ( sName.getLength() )
2486 						{
2487 							Reference< XHierarchicalNameAccess > xContainer(getElements(pView->getElementType()),UNO_QUERY);
2488 							if ( xContainer.is() && xContainer->hasByHierarchicalName(sName) )
2489 							{
2490 								Reference< XHierarchicalNameAccess > xHitObject(xContainer->getByHierarchicalName(sName),UNO_QUERY);
2491 								if ( xHitObject.is() )
2492 									nAction = nActionAskedFor & DND_ACTION_COPYMOVE;
2493 							}
2494 							else
2495 								nAction = DND_ACTION_NONE;
2496 						}
2497 					}
2498 					/*else
2499 						nAction = nActionAskedFor & DND_ACTION_COPYMOVE;
2500                     */
2501 				}
2502 				return nAction;
2503 			}
2504 		}
2505 	}
2506 
2507 	return DND_ACTION_NONE;
2508 }
2509 // -----------------------------------------------------------------------------
executeDrop(const ExecuteDropEvent & _rEvt)2510 sal_Int8 OApplicationController::executeDrop( const ExecuteDropEvent& _rEvt )
2511 {
2512 	OApplicationView* pView = getContainer();
2513 	if ( !pView || pView->getElementType() == E_NONE )
2514 	{
2515 		DBG_ERROR("OApplicationController::executeDrop: what the hell did queryDrop do?");
2516 			// queryDrop shoud not have allowed us to reach this situation ....
2517 		return DND_ACTION_NONE;
2518 	}
2519 
2520 	// a TransferableDataHelper for accessing the dropped data
2521 	TransferableDataHelper aDroppedData(_rEvt.maDropEvent.Transferable);
2522 
2523 
2524 	// reset the data of the previous async drop (if any)
2525 	if ( m_nAsyncDrop )
2526 		Application::RemoveUserEvent(m_nAsyncDrop);
2527 
2528 
2529 	m_nAsyncDrop = 0;
2530 	m_aAsyncDrop.aDroppedData.clear();
2531 	m_aAsyncDrop.nType			= pView->getElementType();
2532 	m_aAsyncDrop.nAction		= _rEvt.mnAction;
2533 	m_aAsyncDrop.bError			= sal_False;
2534 	m_aAsyncDrop.bHtml			= sal_False;
2535 	m_aAsyncDrop.aUrl			= ::rtl::OUString();
2536 
2537 
2538 	// loop through the available formats and see what we can do ...
2539 	// first we have to check if it is our own format, if not we have to copy the stream :-(
2540 	if ( ODataAccessObjectTransferable::canExtractObjectDescriptor(aDroppedData.GetDataFlavorExVector()) )
2541 	{
2542 		m_aAsyncDrop.aDroppedData	= ODataAccessObjectTransferable::extractObjectDescriptor(aDroppedData);
2543 
2544 		// asyncron because we some dialogs and we aren't allowed to show them while in D&D
2545 		m_nAsyncDrop = Application::PostUserEvent(LINK(this, OApplicationController, OnAsyncDrop));
2546 		return DND_ACTION_COPY;
2547 	}
2548 	else if ( OComponentTransferable::canExtractComponentDescriptor(aDroppedData.GetDataFlavorExVector(),m_aAsyncDrop.nType == E_FORM) )
2549 	{
2550 		m_aAsyncDrop.aDroppedData = OComponentTransferable::extractComponentDescriptor(aDroppedData);
2551 		SvLBoxEntry* pHitEntry = pView->getEntry(_rEvt.maPosPixel);
2552 		if ( pHitEntry )
2553 			m_aAsyncDrop.aUrl = pView->getQualifiedName( pHitEntry );
2554 
2555 		sal_Int8 nAction = _rEvt.mnAction;
2556 		Reference<XContent> xContent;
2557 		m_aAsyncDrop.aDroppedData[daComponent] >>= xContent;
2558 		if ( xContent.is() )
2559 		{
2560 			::rtl::OUString sName = xContent->getIdentifier()->getContentIdentifier();
2561 			sal_Int32 nIndex = 0;
2562 			sName = sName.copy(sName.getToken(0,'/',nIndex).getLength() + 1);
2563 			if ( m_aAsyncDrop.aUrl.Len() >= sName.getLength() && 0 == sName.compareTo(m_aAsyncDrop.aUrl,sName.getLength()) )
2564 			{
2565 				m_aAsyncDrop.aDroppedData.clear();
2566 				return DND_ACTION_NONE;
2567 			}
2568 
2569 			// check if move is allowed, if another object with the same name exists only copy is allowed
2570 			Reference< XHierarchicalNameAccess > xContainer(getElements(m_aAsyncDrop.nType),UNO_QUERY);
2571 			Reference<XNameAccess> xNameAccess(xContainer,UNO_QUERY);
2572 
2573 			if ( m_aAsyncDrop.aUrl.Len() && xContainer.is() && xContainer->hasByHierarchicalName(m_aAsyncDrop.aUrl) )
2574 				xNameAccess.set(xContainer->getByHierarchicalName(m_aAsyncDrop.aUrl),UNO_QUERY);
2575 
2576 			if ( xNameAccess.is() )
2577 			{
2578 				Reference<XPropertySet> xProp(xContent,UNO_QUERY);
2579 				if ( xProp.is() )
2580 				{
2581 					xProp->getPropertyValue(PROPERTY_NAME) >>= sName;
2582 					if ( xNameAccess.is() && xNameAccess->hasByName(sName) )
2583 						nAction &= ~DND_ACTION_MOVE;
2584 				}
2585 				else
2586 					nAction &= ~DND_ACTION_MOVE;
2587 			}
2588 		}
2589 		if ( nAction != DND_ACTION_NONE )
2590 		{
2591 			m_aAsyncDrop.nAction = nAction;
2592 			// asyncron because we some dialogs and we aren't allowed to show them while in D&D
2593 			m_nAsyncDrop = Application::PostUserEvent(LINK(this, OApplicationController, OnAsyncDrop));
2594 		}
2595 		else
2596 			m_aAsyncDrop.aDroppedData.clear();
2597 		return nAction;
2598 	}
2599 	else
2600 	{
2601         SharedConnection xConnection( ensureConnection() );
2602         if ( xConnection.is() && m_aTableCopyHelper.copyTagTable( aDroppedData, m_aAsyncDrop, xConnection ) )
2603         {
2604 			// asyncron because we some dialogs and we aren't allowed to show them while in D&D
2605 			m_nAsyncDrop = Application::PostUserEvent(LINK(this, OApplicationController, OnAsyncDrop));
2606 			return DND_ACTION_COPY;
2607 		}
2608 	}
2609 
2610 	return DND_ACTION_NONE;
2611 }
2612 // -----------------------------------------------------------------------------
getModel(void)2613 Reference< XModel >  SAL_CALL OApplicationController::getModel(void) throw( RuntimeException )
2614 {
2615 	return m_xModel;
2616 }
2617 
2618 // -----------------------------------------------------------------------------
onAttachedFrame()2619 void OApplicationController::onAttachedFrame()
2620 {
2621     sal_Int32 nConnectedControllers( 0 );
2622     try
2623     {
2624         Reference< XModel2 > xModel( m_xModel, UNO_QUERY_THROW );
2625         Reference< XEnumeration > xEnumControllers( xModel->getControllers(), UNO_SET_THROW );
2626         while ( xEnumControllers->hasMoreElements() )
2627         {
2628             Reference< XController > xController( xEnumControllers->nextElement(), UNO_QUERY_THROW );
2629             ++nConnectedControllers;
2630         }
2631     }
2632     catch( const Exception& )
2633     {
2634     	DBG_UNHANDLED_EXCEPTION();
2635     }
2636 
2637     if ( nConnectedControllers > 1 )
2638     {   // we are not the first connected controller, there were already others
2639         return;
2640     }
2641 
2642     m_aControllerConnectedEvent.Call();
2643 }
2644 
2645 // -----------------------------------------------------------------------------
2646 IMPL_LINK( OApplicationController, OnFirstControllerConnected, void*, /**/ )
2647 {
2648 	::osl::MutexGuard aGuard( getMutex() );
2649 
2650     if ( !m_xModel.is() )
2651     {
2652         OSL_ENSURE( false, "OApplicationController::OnFirstControllerConnected: too late!" );
2653     }
2654 
2655     // if we have forms or reports which contain macros/scripts, then show a warning
2656     // which suggests the user to migrate them to the database document
2657     Reference< XEmbeddedScripts > xDocumentScripts( m_xModel, UNO_QUERY );
2658     if ( xDocumentScripts.is() )
2659     {
2660         // no need to show this warning, obviously the document supports embedding scripts
2661         // into itself, so there are no "old-style" forms/reports which have macros/scripts
2662         // themselves
2663         return 0L;
2664     }
2665 
2666     try
2667     {
2668         // If the migration just happened, but was not successful, the document is reloaded.
2669         // In this case, we should not show the warning, again.
2670         ::comphelper::NamedValueCollection aModelArgs( m_xModel->getArgs() );
2671         if ( aModelArgs.getOrDefault( "SuppressMigrationWarning", sal_False ) )
2672             return 0L;
2673 
2674         // also, if the document is read-only, then no migration is possible, and the
2675         // respective menu entry is hidden. So, don't show the warning in this case, too.
2676         if ( Reference< XStorable >( m_xModel, UNO_QUERY_THROW )->isReadonly() )
2677             return 0L;
2678 
2679         SQLWarning aWarning;
2680         aWarning.Message = String( ModuleRes( STR_SUB_DOCS_WITH_SCRIPTS ) );
2681         SQLException aDetail;
2682         aDetail.Message = String( ModuleRes( STR_SUB_DOCS_WITH_SCRIPTS_DETAIL ) );
2683         aWarning.NextException <<= aDetail;
2684 
2685         ::comphelper::ComponentContext aContext( getORB() );
2686         Sequence< Any > aArgs(1);
2687         aArgs[0] <<= NamedValue( PROPERTY_SQLEXCEPTION, makeAny( aWarning ) );
2688         Reference< XExecutableDialog > xDialog(
2689             aContext.createComponentWithArguments( "com.sun.star.sdb.ErrorMessageDialog", aArgs ),
2690             UNO_QUERY_THROW );
2691         xDialog->execute();
2692     }
2693     catch( const Exception& )
2694     {
2695     	DBG_UNHANDLED_EXCEPTION();
2696     }
2697 
2698     return 1L;
2699 }
2700 
2701 // -----------------------------------------------------------------------------
attachFrame(const Reference<XFrame> & i_rxFrame)2702 void SAL_CALL OApplicationController::attachFrame( const Reference< XFrame > & i_rxFrame ) throw( RuntimeException )
2703 {
2704     OApplicationController_CBASE::attachFrame( i_rxFrame );
2705     if ( getFrame().is() )
2706         onAttachedFrame();
2707 }
2708 
2709 // -----------------------------------------------------------------------------
attachModel(const Reference<XModel> & _rxModel)2710 sal_Bool SAL_CALL OApplicationController::attachModel(const Reference< XModel > & _rxModel) throw( RuntimeException )
2711 {
2712 	::osl::MutexGuard aGuard( getMutex() );
2713     const Reference< XOfficeDatabaseDocument > xOfficeDoc( _rxModel, UNO_QUERY );
2714     const Reference< XModifiable > xDocModify( _rxModel, UNO_QUERY );
2715     if ( ( !xOfficeDoc.is() || !xDocModify.is() ) && _rxModel.is() )
2716     {
2717         DBG_ERROR( "OApplicationController::attachModel: invalid model!" );
2718         return sal_False;
2719     }
2720 
2721     if ( m_xModel.is() && ( m_xModel != _rxModel ) && ( _rxModel.is() ) )
2722     {
2723         OSL_ENSURE( false, "OApplicationController::attachModel: missing implementation: setting a new model while we have another one!" );
2724         // we'd need to completely update our view here, close sub components, and the like
2725         return sal_False;
2726     }
2727 
2728     const ::rtl::OUString aPropertyNames[] =
2729     {
2730         PROPERTY_URL, PROPERTY_USER
2731     };
2732 
2733     // disconnect from old model
2734     try
2735     {
2736         if ( m_xDataSource.is() )
2737         {
2738             for ( size_t i=0; i < sizeof( aPropertyNames ) / sizeof( aPropertyNames[0] ); ++i )
2739             {
2740                 m_xDataSource->removePropertyChangeListener( aPropertyNames[i], this );
2741             }
2742         }
2743 
2744 		Reference< XModifyBroadcaster >  xBroadcaster( m_xModel, UNO_QUERY );
2745         if ( xBroadcaster.is() )
2746 		    xBroadcaster->removeModifyListener( this );
2747     }
2748     catch( const Exception& )
2749     {
2750     	DBG_UNHANDLED_EXCEPTION();
2751     }
2752 
2753     m_xModel = _rxModel;
2754     m_xDocumentModify = xDocModify;
2755     m_xDataSource.set( xOfficeDoc.is() ? xOfficeDoc->getDataSource() : Reference< XDataSource >(), UNO_QUERY );
2756 
2757     // connect to new model
2758     try
2759     {
2760         if ( m_xDataSource.is() )
2761         {
2762             for ( size_t i=0; i < sizeof( aPropertyNames ) / sizeof( aPropertyNames[0] ); ++i )
2763             {
2764                 m_xDataSource->addPropertyChangeListener( aPropertyNames[i], this );
2765             }
2766         }
2767 
2768 		Reference< XModifyBroadcaster >  xBroadcaster( m_xModel, UNO_QUERY_THROW );
2769 		xBroadcaster->addModifyListener( this );
2770 
2771     }
2772     catch( const Exception& )
2773     {
2774     	DBG_UNHANDLED_EXCEPTION();
2775     }
2776 
2777     // initial preview mode
2778 	if ( m_xDataSource.is() )
2779 	{
2780 		try
2781 		{
2782 			// to get the 'modified' for the data source
2783             ::comphelper::NamedValueCollection aLayoutInfo( m_xDataSource->getPropertyValue( PROPERTY_LAYOUTINFORMATION ) );
2784             if ( aLayoutInfo.has( (rtl::OUString)INFO_PREVIEW ) )
2785             {
2786                 const sal_Int32 nPreviewMode( aLayoutInfo.getOrDefault( (rtl::OUString)INFO_PREVIEW, (sal_Int32)0 ) );
2787 				m_ePreviewMode = static_cast< PreviewMode >( nPreviewMode );
2788                 if ( getView() )
2789                     getContainer()->switchPreview( m_ePreviewMode );
2790 			}
2791 		}
2792 		catch( const Exception& )
2793 		{
2794             DBG_UNHANDLED_EXCEPTION();
2795 		}
2796 	}
2797 
2798 	return sal_True;
2799 }
2800 // -----------------------------------------------------------------------------
containerFound(const Reference<XContainer> & _xContainer)2801 void OApplicationController::containerFound( const Reference< XContainer >& _xContainer)
2802 {
2803 	try
2804 	{
2805 		if ( _xContainer.is() )
2806 		{
2807 			m_aCurrentContainers.push_back(_xContainer);
2808 			_xContainer->addContainerListener(this);
2809 		}
2810 	}
2811 	catch(const Exception&)
2812 	{
2813 		DBG_UNHANDLED_EXCEPTION();
2814 	}
2815 }
2816 // -----------------------------------------------------------------------------
getCurrentlySelectedName(sal_Int32 & _rnCommandType) const2817 ::rtl::OUString OApplicationController::getCurrentlySelectedName(sal_Int32& _rnCommandType) const
2818 {
2819     _rnCommandType = ( (getContainer()->getElementType() == E_QUERY)
2820 								? CommandType::QUERY : ( (getContainer()->getElementType() == E_TABLE) ? CommandType::TABLE : -1 ));
2821 
2822 
2823 	::rtl::OUString sName;
2824 	if ( _rnCommandType != -1 )
2825 	{
2826 		try
2827 		{
2828 			sName = getContainer()->getQualifiedName( NULL );
2829             OSL_ENSURE( sName.getLength(), "OApplicationController::getCurrentlySelectedName: no name given!" );
2830 		}
2831 		catch( const Exception& )
2832 		{
2833             DBG_UNHANDLED_EXCEPTION();
2834 		}
2835 	}
2836     return sName;
2837 }
2838 
2839 // -----------------------------------------------------------------------------
addSelectionChangeListener(const Reference<view::XSelectionChangeListener> & _Listener)2840 void SAL_CALL OApplicationController::addSelectionChangeListener( const Reference< view::XSelectionChangeListener >& _Listener ) throw (RuntimeException)
2841 {
2842     m_pSelectionNotifier->addListener( _Listener );
2843 }
2844 
2845 // -----------------------------------------------------------------------------
removeSelectionChangeListener(const Reference<view::XSelectionChangeListener> & _Listener)2846 void SAL_CALL OApplicationController::removeSelectionChangeListener( const Reference< view::XSelectionChangeListener >& _Listener ) throw (RuntimeException)
2847 {
2848     m_pSelectionNotifier->removeListener( _Listener );
2849 }
2850 
2851 // -----------------------------------------------------------------------------
select(const Any & _aSelection)2852 ::sal_Bool SAL_CALL OApplicationController::select( const Any& _aSelection ) throw (IllegalArgumentException, RuntimeException)
2853 {
2854     ::vos::OGuard aSolarGuard( Application::GetSolarMutex() );
2855 	::osl::MutexGuard aGuard( getMutex() );
2856     Sequence< ::rtl::OUString> aSelection;
2857     if ( !_aSelection.hasValue() || !getView() )
2858     {
2859         getContainer()->selectElements(aSelection);
2860         return sal_True;
2861     }
2862 
2863     // --------------------------------------------------------------
2864     // BEGIN compatibility
2865     Sequence< NamedValue > aCurrentSelection;
2866     if ( (_aSelection >>= aCurrentSelection) && aCurrentSelection.getLength() )
2867     {
2868         ElementType eType = E_NONE;
2869         const NamedValue* pIter = aCurrentSelection.getConstArray();
2870         const NamedValue* pEnd	= pIter + aCurrentSelection.getLength();
2871         for(;pIter != pEnd;++pIter)
2872         {
2873             if ( pIter->Name.equalsAscii("Type") )
2874             {
2875                 sal_Int32 nType = 0;
2876                 pIter->Value >>= nType;
2877                 if ( nType < DatabaseObject::TABLE || nType > DatabaseObject::REPORT )
2878                     throw IllegalArgumentException();
2879                 eType = static_cast< ElementType >( nType );
2880             }
2881             else if ( pIter->Name.equalsAscii("Selection") )
2882                 pIter->Value >>= aSelection;
2883         }
2884 
2885         m_aSelectContainerEvent.CancelCall();   // just in case the async select request was running
2886         getContainer()->selectContainer(eType);
2887         getContainer()->selectElements(aSelection);
2888         return sal_True;
2889     }
2890     // END compatibility
2891     // --------------------------------------------------------------
2892 
2893     Sequence< NamedDatabaseObject > aSelectedObjects;
2894     if ( !( _aSelection >>= aSelectedObjects ) )
2895     {
2896         aSelectedObjects.realloc( 1 );
2897         if ( !( _aSelection >>= aSelectedObjects[0] ) )
2898             throw IllegalArgumentException();
2899     }
2900 
2901     SelectionByElementType aSelectedElements;
2902     ElementType eSelectedCategory = E_NONE;
2903     for (   const NamedDatabaseObject* pObject = aSelectedObjects.getConstArray();
2904             pObject != aSelectedObjects.getConstArray() + aSelectedObjects.getLength();
2905             ++pObject
2906         )
2907     {
2908         switch ( pObject->Type )
2909         {
2910             case DatabaseObject::TABLE:
2911             case DatabaseObjectContainer::SCHEMA:
2912             case DatabaseObjectContainer::CATALOG:
2913                 aSelectedElements[ E_TABLE ].push_back( pObject->Name );
2914                 break;
2915             case DatabaseObject::QUERY:
2916                 aSelectedElements[ E_QUERY ].push_back( pObject->Name );
2917                 break;
2918             case DatabaseObject::FORM:
2919             case DatabaseObjectContainer::FORMS_FOLDER:
2920                 aSelectedElements[ E_FORM ].push_back( pObject->Name );
2921                 break;
2922             case DatabaseObject::REPORT:
2923             case DatabaseObjectContainer::REPORTS_FOLDER:
2924                 aSelectedElements[ E_REPORT ].push_back( pObject->Name );
2925                 break;
2926             case DatabaseObjectContainer::TABLES:
2927             case DatabaseObjectContainer::QUERIES:
2928             case DatabaseObjectContainer::FORMS:
2929             case DatabaseObjectContainer::REPORTS:
2930                 if ( eSelectedCategory != E_NONE )
2931                     throw IllegalArgumentException(
2932                         String(ModuleRes(RID_STR_NO_DIFF_CAT)),
2933                         *this, sal_Int16( pObject - aSelectedObjects.getConstArray() ) );
2934                 eSelectedCategory =
2935                         ( pObject->Type == DatabaseObjectContainer::TABLES )  ? E_TABLE
2936                     :   ( pObject->Type == DatabaseObjectContainer::QUERIES ) ? E_QUERY
2937                     :   ( pObject->Type == DatabaseObjectContainer::FORMS )   ? E_FORM
2938                     :   ( pObject->Type == DatabaseObjectContainer::REPORTS ) ? E_REPORT
2939                     :   E_NONE;
2940                 break;
2941 
2942             default:
2943             case DatabaseObjectContainer::DATA_SOURCE:
2944             {
2945                 ::rtl::OUString sMessage = String(ModuleRes( RID_STR_UNSUPPORTED_OBJECT_TYPE ));
2946                 ::comphelper::string::searchAndReplaceAsciiI( sMessage, "$type$", ::rtl::OUString::valueOf(sal_Int32( pObject->Type )) );
2947                 throw IllegalArgumentException(sMessage, *this, sal_Int16( pObject - aSelectedObjects.getConstArray() ));
2948             }
2949         }
2950     }
2951 
2952     for (   SelectionByElementType::const_iterator sel = aSelectedElements.begin();
2953             sel != aSelectedElements.end();
2954             ++sel
2955         )
2956     {
2957         if ( sel->first == m_eCurrentType )
2958         {
2959             Sequence< ::rtl::OUString > aSelected( sel->second.size() );
2960             ::std::copy( sel->second.begin(), sel->second.end(), aSelected.getArray() );
2961             getContainer()->selectElements( aSelected );
2962         }
2963         else
2964         {
2965             m_aPendingSelection[ sel->first ] = sel->second;
2966         }
2967     }
2968 
2969     m_aSelectContainerEvent.CancelCall();   // just in case the async select request was running
2970     getContainer()->selectContainer( eSelectedCategory );
2971 
2972     return sal_True;
2973 }
2974 // -----------------------------------------------------------------------------
getSelection()2975 Any SAL_CALL OApplicationController::getSelection(  ) throw (RuntimeException)
2976 {
2977     ::vos::OGuard aSolarGuard( Application::GetSolarMutex() );
2978     ::osl::MutexGuard aGuard( getMutex() );
2979 
2980     Sequence< NamedDatabaseObject > aCurrentSelection;
2981     const ElementType eType( getContainer()->getElementType() );
2982     if ( eType != E_NONE )
2983     {
2984         getContainer()->describeCurrentSelectionForType( eType, aCurrentSelection );
2985         if ( aCurrentSelection.getLength() == 0 )
2986         {   // if no objects are selected, add an entry to the sequence which describes the overall category
2987             // which is selected currently
2988             aCurrentSelection.realloc(1);
2989             aCurrentSelection[0].Name = getDatabaseName();
2990             switch ( eType )
2991             {
2992             case E_TABLE:   aCurrentSelection[0].Type = DatabaseObjectContainer::TABLES;   break;
2993             case E_QUERY:   aCurrentSelection[0].Type = DatabaseObjectContainer::QUERIES;  break;
2994             case E_FORM:    aCurrentSelection[0].Type = DatabaseObjectContainer::FORMS;    break;
2995             case E_REPORT:  aCurrentSelection[0].Type = DatabaseObjectContainer::REPORTS;  break;
2996             default:
2997                 OSL_ENSURE( false, "OApplicationController::getSelection: unexpected current element type!" );
2998                 break;
2999             }
3000         }
3001     }
3002     return makeAny( aCurrentSelection );
3003 }
3004 // -----------------------------------------------------------------------------
impl_migrateScripts_nothrow()3005 void OApplicationController::impl_migrateScripts_nothrow()
3006 {
3007     try
3008     {
3009         ::rtl::OUString sDialogService( RTL_CONSTASCII_USTRINGPARAM( "com.sun.star.sdb.application.MacroMigrationWizard" ) );
3010         ::comphelper::ComponentContext aContext( getORB() );
3011         Sequence< Any > aDialogArgs(1);
3012         aDialogArgs[0] <<= Reference< XOfficeDatabaseDocument >( m_xModel, UNO_QUERY_THROW );
3013         Reference< XExecutableDialog > xDialog(
3014             aContext.createComponentWithArguments( sDialogService, aDialogArgs ),
3015             UNO_QUERY );
3016 
3017         if ( !xDialog.is() )
3018         {
3019             ShowServiceNotAvailableError( getView(), sDialogService, true );
3020             return;
3021         }
3022 
3023         xDialog->execute();
3024     }
3025     catch( const Exception& )
3026     {
3027     	DBG_UNHANDLED_EXCEPTION();
3028     }
3029 }
3030 
3031 //........................................................................
3032 }	// namespace dbaui
3033 //........................................................................
3034 
3035