196de5490SAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 396de5490SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 496de5490SAndrew Rist * or more contributor license agreements. See the NOTICE file 596de5490SAndrew Rist * distributed with this work for additional information 696de5490SAndrew Rist * regarding copyright ownership. The ASF licenses this file 796de5490SAndrew Rist * to you under the Apache License, Version 2.0 (the 896de5490SAndrew Rist * "License"); you may not use this file except in compliance 996de5490SAndrew Rist * with the License. You may obtain a copy of the License at 1096de5490SAndrew Rist * 1196de5490SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 1296de5490SAndrew Rist * 1396de5490SAndrew Rist * Unless required by applicable law or agreed to in writing, 1496de5490SAndrew Rist * software distributed under the License is distributed on an 1596de5490SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1696de5490SAndrew Rist * KIND, either express or implied. See the License for the 1796de5490SAndrew Rist * specific language governing permissions and limitations 1896de5490SAndrew Rist * under the License. 1996de5490SAndrew Rist * 2096de5490SAndrew Rist *************************************************************/ 2196de5490SAndrew Rist 2296de5490SAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 25cdf0e10cSrcweir #include "precompiled_dbaccess.hxx" 26cdf0e10cSrcweir 27cdf0e10cSrcweir #include "browserids.hxx" 28cdf0e10cSrcweir #include "dbaccess_helpid.hrc" 29cdf0e10cSrcweir #include "dbexchange.hxx" 30cdf0e10cSrcweir #include "dbtreelistbox.hxx" 31cdf0e10cSrcweir #include "dbtreemodel.hxx" 32cdf0e10cSrcweir #include "dbtreeview.hxx" 33cdf0e10cSrcweir #include "dbu_brw.hrc" 34cdf0e10cSrcweir #include "dbu_reghelper.hxx" 35cdf0e10cSrcweir #include "dbustrings.hrc" 36cdf0e10cSrcweir #include "dlgsave.hxx" 37cdf0e10cSrcweir #include "HtmlReader.hxx" 38cdf0e10cSrcweir #include "imageprovider.hxx" 39cdf0e10cSrcweir #include "listviewitems.hxx" 40cdf0e10cSrcweir #include "QEnumTypes.hxx" 41cdf0e10cSrcweir #include "RtfReader.hxx" 42cdf0e10cSrcweir #include "sbagrid.hrc" 43cdf0e10cSrcweir #include "sbagrid.hxx" 44cdf0e10cSrcweir #include "sqlmessage.hxx" 45cdf0e10cSrcweir #include "TokenWriter.hxx" 46cdf0e10cSrcweir #include "UITools.hxx" 47cdf0e10cSrcweir #include "unodatbr.hxx" 48cdf0e10cSrcweir #include "WColumnSelect.hxx" 49cdf0e10cSrcweir #include "WCopyTable.hxx" 50cdf0e10cSrcweir #include "WCPage.hxx" 51cdf0e10cSrcweir #include "WExtendPages.hxx" 52cdf0e10cSrcweir #include "WNameMatch.hxx" 53cdf0e10cSrcweir 54cdf0e10cSrcweir /** === begin UNO includes === **/ 55cdf0e10cSrcweir #include <com/sun/star/awt/LineEndFormat.hpp> 56cdf0e10cSrcweir #include <com/sun/star/awt/LineEndFormat.hpp> 57cdf0e10cSrcweir #include <com/sun/star/awt/MouseWheelBehavior.hpp> 58cdf0e10cSrcweir #include <com/sun/star/awt/TextAlign.hpp> 59cdf0e10cSrcweir #include <com/sun/star/awt/VisualEffect.hpp> 60cdf0e10cSrcweir #include <com/sun/star/beans/NamedValue.hpp> 61cdf0e10cSrcweir #include <com/sun/star/beans/PropertyValue.hpp> 62cdf0e10cSrcweir #include <com/sun/star/container/XNameContainer.hpp> 63cdf0e10cSrcweir #include <com/sun/star/form/XForm.hpp> 64cdf0e10cSrcweir #include <com/sun/star/form/XGridColumnFactory.hpp> 65cdf0e10cSrcweir #include <com/sun/star/form/XLoadable.hpp> 66cdf0e10cSrcweir #include <com/sun/star/form/XReset.hpp> 67cdf0e10cSrcweir #include <com/sun/star/frame/FrameSearchFlag.hpp> 68cdf0e10cSrcweir #include <com/sun/star/frame/XLayoutManager.hpp> 69cdf0e10cSrcweir #include <com/sun/star/lang/DisposedException.hpp> 70cdf0e10cSrcweir #include <com/sun/star/sdb/CommandType.hpp> 71cdf0e10cSrcweir #include <com/sun/star/sdb/SQLContext.hpp> 72cdf0e10cSrcweir #include <com/sun/star/sdb/XBookmarksSupplier.hpp> 73cdf0e10cSrcweir #include <com/sun/star/sdb/XCompletedConnection.hpp> 74cdf0e10cSrcweir #include <com/sun/star/sdb/XDatabaseRegistrations.hpp> 75cdf0e10cSrcweir #include <com/sun/star/sdb/XDocumentDataSource.hpp> 76cdf0e10cSrcweir #include <com/sun/star/sdb/XParametersSupplier.hpp> 77cdf0e10cSrcweir #include <com/sun/star/sdb/XQueriesSupplier.hpp> 78cdf0e10cSrcweir #include <com/sun/star/sdb/XQueryDefinitionsSupplier.hpp> 79cdf0e10cSrcweir #include <com/sun/star/sdb/XResultSetAccess.hpp> 80cdf0e10cSrcweir #include <com/sun/star/sdb/XSingleSelectQueryComposer.hpp> 81cdf0e10cSrcweir #include <com/sun/star/sdb/application/NamedDatabaseObject.hpp> 82cdf0e10cSrcweir #include <com/sun/star/sdbc/ColumnValue.hpp> 83cdf0e10cSrcweir #include <com/sun/star/sdbc/DataType.hpp> 84cdf0e10cSrcweir #include <com/sun/star/sdbc/FetchDirection.hpp> 85cdf0e10cSrcweir #include <com/sun/star/sdbc/SQLWarning.hpp> 86cdf0e10cSrcweir #include <com/sun/star/sdbc/XDataSource.hpp> 87cdf0e10cSrcweir #include <com/sun/star/sdbc/XResultSetMetaDataSupplier.hpp> 88cdf0e10cSrcweir #include <com/sun/star/sdbc/XWarningsSupplier.hpp> 89cdf0e10cSrcweir #include <com/sun/star/sdbcx/Privilege.hpp> 90cdf0e10cSrcweir #include <com/sun/star/sdbcx/XColumnsSupplier.hpp> 91cdf0e10cSrcweir #include <com/sun/star/sdbcx/XDataDescriptorFactory.hpp> 92cdf0e10cSrcweir #include <com/sun/star/sdbcx/XDrop.hpp> 93cdf0e10cSrcweir #include <com/sun/star/sdbcx/XTablesSupplier.hpp> 94cdf0e10cSrcweir #include <com/sun/star/sdbcx/XViewsSupplier.hpp> 95cdf0e10cSrcweir #include <com/sun/star/ui/dialogs/XExecutableDialog.hpp> 96cdf0e10cSrcweir #include <com/sun/star/util/XFlushable.hpp> 97cdf0e10cSrcweir #include <com/sun/star/sdb/XDocumentDataSource.hpp> 98cdf0e10cSrcweir #include <com/sun/star/document/MacroExecMode.hpp> 99cdf0e10cSrcweir #include <com/sun/star/frame/XComponentLoader.hpp> 100cdf0e10cSrcweir #include <com/sun/star/ui/XContextMenuInterceptor.hpp> 101cdf0e10cSrcweir /** === end UNO includes === **/ 102cdf0e10cSrcweir 103cdf0e10cSrcweir #include <comphelper/extract.hxx> 104cdf0e10cSrcweir #include <comphelper/sequence.hxx> 105cdf0e10cSrcweir #include <comphelper/types.hxx> 106cdf0e10cSrcweir #include <connectivity/dbexception.hxx> 107cdf0e10cSrcweir #include <cppuhelper/exc_hlp.hxx> 108cdf0e10cSrcweir #include <cppuhelper/implbase2.hxx> 109cdf0e10cSrcweir #include <cppuhelper/typeprovider.hxx> 110cdf0e10cSrcweir #include <sfx2/app.hxx> 111cdf0e10cSrcweir #include <sfx2/dispatch.hxx> 112cdf0e10cSrcweir #include <sot/storage.hxx> 113cdf0e10cSrcweir #include <svl/filenotation.hxx> 114cdf0e10cSrcweir #include <svl/intitem.hxx> 115cdf0e10cSrcweir #include <unotools/moduleoptions.hxx> 116cdf0e10cSrcweir #include <svtools/svlbitm.hxx> 117cdf0e10cSrcweir #include <svtools/svtreebx.hxx> 118cdf0e10cSrcweir #include <svx/algitem.hxx> 119cdf0e10cSrcweir #include <svx/dataaccessdescriptor.hxx> 120cdf0e10cSrcweir #include <svx/databaseregistrationui.hxx> 121cdf0e10cSrcweir #include <svx/gridctrl.hxx> 122cdf0e10cSrcweir #include <toolkit/unohlp.hxx> 123cdf0e10cSrcweir #include <tools/diagnose_ex.h> 124cdf0e10cSrcweir #include <tools/multisel.hxx> 125cdf0e10cSrcweir #include <tools/urlobj.hxx> 126cdf0e10cSrcweir #include <unotools/confignode.hxx> 127cdf0e10cSrcweir #include <vcl/msgbox.hxx> 128cdf0e10cSrcweir #include <vcl/split.hxx> 129cdf0e10cSrcweir #include <vcl/stdtext.hxx> 130cdf0e10cSrcweir #include <vcl/svapp.hxx> 131cdf0e10cSrcweir #include <vcl/toolbox.hxx> 132cdf0e10cSrcweir #include <vcl/waitobj.hxx> 133cdf0e10cSrcweir #include <vcl/wrkwin.hxx> 134cdf0e10cSrcweir #include <rtl/logfile.hxx> 135cdf0e10cSrcweir 136cdf0e10cSrcweir #include <memory> 137cdf0e10cSrcweir 138cdf0e10cSrcweir using namespace ::com::sun::star::uno; 139cdf0e10cSrcweir using namespace ::com::sun::star::awt; 140cdf0e10cSrcweir using namespace ::com::sun::star::sdb; 141cdf0e10cSrcweir using namespace ::com::sun::star::sdb::application; 142cdf0e10cSrcweir using namespace ::com::sun::star::sdbc; 143cdf0e10cSrcweir using namespace ::com::sun::star::sdbcx; 144cdf0e10cSrcweir using namespace ::com::sun::star::beans; 145cdf0e10cSrcweir using namespace ::com::sun::star::util; 146cdf0e10cSrcweir using namespace ::com::sun::star::frame; 147cdf0e10cSrcweir using namespace ::com::sun::star::container; 148cdf0e10cSrcweir using namespace ::com::sun::star::lang; 149cdf0e10cSrcweir using namespace ::com::sun::star::ui::dialogs; 150cdf0e10cSrcweir using namespace ::com::sun::star::task; 151cdf0e10cSrcweir using namespace ::com::sun::star::form; 152cdf0e10cSrcweir using namespace ::com::sun::star::io; 153cdf0e10cSrcweir using namespace ::com::sun::star::i18n; 154cdf0e10cSrcweir using namespace ::com::sun::star::view; 155cdf0e10cSrcweir using namespace ::com::sun::star::datatransfer; 156cdf0e10cSrcweir using namespace ::com::sun::star::document; 157cdf0e10cSrcweir using namespace ::com::sun::star::ui; 158cdf0e10cSrcweir using namespace ::dbtools; 159cdf0e10cSrcweir using namespace ::comphelper; 160cdf0e10cSrcweir using namespace ::svx; 161cdf0e10cSrcweir 162cdf0e10cSrcweir // ......................................................................... 163cdf0e10cSrcweir namespace dbaui 164cdf0e10cSrcweir { 165cdf0e10cSrcweir // ......................................................................... 166cdf0e10cSrcweir 167cdf0e10cSrcweir namespace DatabaseObject = ::com::sun::star::sdb::application::DatabaseObject; 168cdf0e10cSrcweir namespace DatabaseObjectContainer = ::com::sun::star::sdb::application::DatabaseObjectContainer; 169cdf0e10cSrcweir 170cdf0e10cSrcweir //================================================================== 171cdf0e10cSrcweir //= SbaTableQueryBrowser 172cdf0e10cSrcweir //================================================================== 173cdf0e10cSrcweir // ------------------------------------------------------------------------- 174cdf0e10cSrcweir extern "C" void SAL_CALL createRegistryInfo_OBrowser() 175cdf0e10cSrcweir { 176cdf0e10cSrcweir static OMultiInstanceAutoRegistration< SbaTableQueryBrowser > aAutoRegistration; 177cdf0e10cSrcweir } 178cdf0e10cSrcweir // ------------------------------------------------------------------------- 179cdf0e10cSrcweir void SafeAddPropertyListener(const Reference< XPropertySet > & xSet, const ::rtl::OUString& rPropName, XPropertyChangeListener* pListener) 180cdf0e10cSrcweir { 181cdf0e10cSrcweir Reference< XPropertySetInfo > xInfo = xSet->getPropertySetInfo(); 182cdf0e10cSrcweir if (xInfo->hasPropertyByName(rPropName)) 183cdf0e10cSrcweir xSet->addPropertyChangeListener(rPropName, pListener); 184cdf0e10cSrcweir } 185cdf0e10cSrcweir 186cdf0e10cSrcweir // ------------------------------------------------------------------------- 187cdf0e10cSrcweir void SafeRemovePropertyListener(const Reference< XPropertySet > & xSet, const ::rtl::OUString& rPropName, XPropertyChangeListener* pListener) 188cdf0e10cSrcweir { 189cdf0e10cSrcweir Reference< XPropertySetInfo > xInfo = xSet->getPropertySetInfo(); 190cdf0e10cSrcweir if (xInfo->hasPropertyByName(rPropName)) 191cdf0e10cSrcweir xSet->removePropertyChangeListener(rPropName, pListener); 192cdf0e10cSrcweir } 193cdf0e10cSrcweir //------------------------------------------------------------------------- 194cdf0e10cSrcweir ::rtl::OUString SAL_CALL SbaTableQueryBrowser::getImplementationName() throw(RuntimeException) 195cdf0e10cSrcweir { 196cdf0e10cSrcweir return getImplementationName_Static(); 197cdf0e10cSrcweir } 198cdf0e10cSrcweir //------------------------------------------------------------------------- 199cdf0e10cSrcweir ::comphelper::StringSequence SAL_CALL SbaTableQueryBrowser::getSupportedServiceNames() throw(RuntimeException) 200cdf0e10cSrcweir { 201cdf0e10cSrcweir return getSupportedServiceNames_Static(); 202cdf0e10cSrcweir } 203cdf0e10cSrcweir // ------------------------------------------------------------------------- 204cdf0e10cSrcweir ::rtl::OUString SbaTableQueryBrowser::getImplementationName_Static() throw(RuntimeException) 205cdf0e10cSrcweir { 206cdf0e10cSrcweir return ::rtl::OUString::createFromAscii("org.openoffice.comp.dbu.ODatasourceBrowser"); 207cdf0e10cSrcweir } 208cdf0e10cSrcweir //------------------------------------------------------------------------- 209cdf0e10cSrcweir ::comphelper::StringSequence SbaTableQueryBrowser::getSupportedServiceNames_Static() throw(RuntimeException) 210cdf0e10cSrcweir { 211cdf0e10cSrcweir ::comphelper::StringSequence aSupported(1); 212cdf0e10cSrcweir aSupported.getArray()[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdb.DataSourceBrowser"); 213cdf0e10cSrcweir return aSupported; 214cdf0e10cSrcweir } 215cdf0e10cSrcweir //------------------------------------------------------------------------- 216cdf0e10cSrcweir Reference< XInterface > SAL_CALL SbaTableQueryBrowser::Create(const Reference<XMultiServiceFactory >& _rxFactory) 217cdf0e10cSrcweir { 218cdf0e10cSrcweir ::vos::OGuard aGuard(Application::GetSolarMutex()); 219cdf0e10cSrcweir return *(new SbaTableQueryBrowser(_rxFactory)); 220cdf0e10cSrcweir } 221cdf0e10cSrcweir 222cdf0e10cSrcweir DBG_NAME(SbaTableQueryBrowser); 223cdf0e10cSrcweir //------------------------------------------------------------------------------ 224cdf0e10cSrcweir SbaTableQueryBrowser::SbaTableQueryBrowser(const Reference< XMultiServiceFactory >& _rM) 225cdf0e10cSrcweir :SbaXDataBrowserController(_rM) 226cdf0e10cSrcweir ,m_aSelectionListeners( getMutex() ) 227cdf0e10cSrcweir ,m_aContextMenuInterceptors( getMutex() ) 228cdf0e10cSrcweir ,m_aTableCopyHelper(this) 229cdf0e10cSrcweir ,m_pTreeView(NULL) 230cdf0e10cSrcweir ,m_pSplitter(NULL) 231cdf0e10cSrcweir ,m_pTreeModel(NULL) 232cdf0e10cSrcweir ,m_pCurrentlyDisplayed(NULL) 233cdf0e10cSrcweir ,m_nAsyncDrop(0) 234cdf0e10cSrcweir ,m_nBorder(1) 235cdf0e10cSrcweir ,m_bQueryEscapeProcessing( sal_False ) 236cdf0e10cSrcweir ,m_bShowMenu(sal_False) 237cdf0e10cSrcweir ,m_bInSuspend(sal_False) 238cdf0e10cSrcweir ,m_bEnableBrowser(sal_True) 239cdf0e10cSrcweir { 240cdf0e10cSrcweir DBG_CTOR(SbaTableQueryBrowser,NULL); 241cdf0e10cSrcweir } 242cdf0e10cSrcweir 243cdf0e10cSrcweir //------------------------------------------------------------------------------ 244cdf0e10cSrcweir SbaTableQueryBrowser::~SbaTableQueryBrowser() 245cdf0e10cSrcweir { 246cdf0e10cSrcweir DBG_DTOR(SbaTableQueryBrowser,NULL); 247cdf0e10cSrcweir if ( !rBHelper.bDisposed && !rBHelper.bInDispose ) 248cdf0e10cSrcweir { 249cdf0e10cSrcweir OSL_ENSURE(0,"Please check who doesn't dispose this component!"); 250cdf0e10cSrcweir // increment ref count to prevent double call of Dtor 251cdf0e10cSrcweir osl_incrementInterlockedCount( &m_refCount ); 252cdf0e10cSrcweir dispose(); 253cdf0e10cSrcweir } 254cdf0e10cSrcweir } 255cdf0e10cSrcweir 256cdf0e10cSrcweir //------------------------------------------------------------------------------ 257cdf0e10cSrcweir Any SAL_CALL SbaTableQueryBrowser::queryInterface(const Type& _rType) throw (RuntimeException) 258cdf0e10cSrcweir { 259cdf0e10cSrcweir if ( _rType.equals( XScriptInvocationContext::static_type() ) ) 260cdf0e10cSrcweir { 261cdf0e10cSrcweir OSL_PRECOND( !!m_aDocScriptSupport, "SbaTableQueryBrowser::queryInterface: did not initialize this, yet!" ); 262cdf0e10cSrcweir if ( !!m_aDocScriptSupport && *m_aDocScriptSupport ) 263cdf0e10cSrcweir return makeAny( Reference< XScriptInvocationContext >( this ) ); 264cdf0e10cSrcweir return Any(); 265cdf0e10cSrcweir } 266cdf0e10cSrcweir 267cdf0e10cSrcweir Any aReturn = SbaXDataBrowserController::queryInterface(_rType); 268cdf0e10cSrcweir if (!aReturn.hasValue()) 269cdf0e10cSrcweir aReturn = SbaTableQueryBrowser_Base::queryInterface(_rType); 270cdf0e10cSrcweir return aReturn; 271cdf0e10cSrcweir } 272cdf0e10cSrcweir 273cdf0e10cSrcweir //------------------------------------------------------------------------------ 274cdf0e10cSrcweir Sequence< Type > SAL_CALL SbaTableQueryBrowser::getTypes( ) throw (RuntimeException) 275cdf0e10cSrcweir { 276cdf0e10cSrcweir Sequence< Type > aTypes( ::comphelper::concatSequences( 277cdf0e10cSrcweir SbaXDataBrowserController::getTypes(), 278cdf0e10cSrcweir SbaTableQueryBrowser_Base::getTypes() 279cdf0e10cSrcweir ) ); 280cdf0e10cSrcweir 281cdf0e10cSrcweir OSL_PRECOND( !!m_aDocScriptSupport, "SbaTableQueryBrowser::getTypes: did not initialize this, yet!" ); 282cdf0e10cSrcweir if ( !m_aDocScriptSupport || !*m_aDocScriptSupport ) 283cdf0e10cSrcweir { 284cdf0e10cSrcweir Sequence< Type > aStrippedTypes( aTypes.getLength() - 1 ); 285cdf0e10cSrcweir ::std::remove_copy_if( 286cdf0e10cSrcweir aTypes.getConstArray(), 287cdf0e10cSrcweir aTypes.getConstArray() + aTypes.getLength(), 288cdf0e10cSrcweir aStrippedTypes.getArray(), 289cdf0e10cSrcweir ::std::bind2nd( ::std::equal_to< Type >(), XScriptInvocationContext::static_type() ) 290cdf0e10cSrcweir ); 291cdf0e10cSrcweir aTypes = aStrippedTypes; 292cdf0e10cSrcweir } 293cdf0e10cSrcweir return aTypes; 294cdf0e10cSrcweir } 295cdf0e10cSrcweir 296cdf0e10cSrcweir //------------------------------------------------------------------------------ 297cdf0e10cSrcweir Sequence< sal_Int8 > SAL_CALL SbaTableQueryBrowser::getImplementationId( ) throw (RuntimeException) 298cdf0e10cSrcweir { 299cdf0e10cSrcweir static ::cppu::OImplementationId * pId = 0; 300cdf0e10cSrcweir if (! pId) 301cdf0e10cSrcweir { 302cdf0e10cSrcweir ::osl::MutexGuard aGuard( ::osl::Mutex::getGlobalMutex() ); 303cdf0e10cSrcweir if (! pId) 304cdf0e10cSrcweir { 305cdf0e10cSrcweir static ::cppu::OImplementationId aId; 306cdf0e10cSrcweir pId = &aId; 307cdf0e10cSrcweir } 308cdf0e10cSrcweir } 309cdf0e10cSrcweir return pId->getImplementationId(); 310cdf0e10cSrcweir } 311cdf0e10cSrcweir 312cdf0e10cSrcweir //------------------------------------------------------------------------------ 313cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::disposing() 314cdf0e10cSrcweir { 315cdf0e10cSrcweir ::vos::OGuard aGuard(Application::GetSolarMutex()); 316cdf0e10cSrcweir // doin' a lot of VCL stuff here -> lock the SolarMutex 317cdf0e10cSrcweir 318cdf0e10cSrcweir // kiss our listeners goodbye 319cdf0e10cSrcweir EventObject aEvt(*this); 320cdf0e10cSrcweir m_aSelectionListeners.disposeAndClear(aEvt); 321cdf0e10cSrcweir m_aContextMenuInterceptors.disposeAndClear(aEvt); 322cdf0e10cSrcweir 323cdf0e10cSrcweir // reset the content's tree view: it holds a reference to our model which is to be deleted immediately, 324cdf0e10cSrcweir // and it will live longer than we do. 325cdf0e10cSrcweir if (getBrowserView()) 326cdf0e10cSrcweir getBrowserView()->setTreeView(NULL); 327cdf0e10cSrcweir 328cdf0e10cSrcweir clearTreeModel(); 329cdf0e10cSrcweir // clear the tree model 330cdf0e10cSrcweir { 331cdf0e10cSrcweir ::std::auto_ptr<SvLBoxTreeList> aTemp(m_pTreeModel); 332cdf0e10cSrcweir m_pTreeModel = NULL; 333cdf0e10cSrcweir } 334cdf0e10cSrcweir 335cdf0e10cSrcweir // remove ourself as status listener 336cdf0e10cSrcweir implRemoveStatusListeners(); 337cdf0e10cSrcweir 338cdf0e10cSrcweir // remove the container listener from the database context 339cdf0e10cSrcweir try 340cdf0e10cSrcweir { 341cdf0e10cSrcweir Reference< XDatabaseRegistrations > xDatabaseRegistrations( m_xDatabaseContext, UNO_QUERY_THROW ); 342cdf0e10cSrcweir xDatabaseRegistrations->removeDatabaseRegistrationsListener( this ); 343cdf0e10cSrcweir } 344cdf0e10cSrcweir catch( const Exception& ) 345cdf0e10cSrcweir { 346cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 347cdf0e10cSrcweir } 348cdf0e10cSrcweir 349cdf0e10cSrcweir // check out from all the objects we are listening 350cdf0e10cSrcweir // the frame 351cdf0e10cSrcweir if (m_xCurrentFrameParent.is()) 352cdf0e10cSrcweir m_xCurrentFrameParent->removeFrameActionListener((::com::sun::star::frame::XFrameActionListener*)this); 353cdf0e10cSrcweir SbaXDataBrowserController::disposing(); 354cdf0e10cSrcweir } 355cdf0e10cSrcweir 356cdf0e10cSrcweir //------------------------------------------------------------------------------ 357cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::Construct(Window* pParent) 358cdf0e10cSrcweir { 359cdf0e10cSrcweir if ( !SbaXDataBrowserController::Construct( pParent ) ) 360cdf0e10cSrcweir return sal_False; 361cdf0e10cSrcweir 362cdf0e10cSrcweir try 363cdf0e10cSrcweir { 364cdf0e10cSrcweir Reference< XDatabaseRegistrations > xDatabaseRegistrations( m_xDatabaseContext, UNO_QUERY_THROW ); 365cdf0e10cSrcweir xDatabaseRegistrations->addDatabaseRegistrationsListener( this ); 366cdf0e10cSrcweir 367cdf0e10cSrcweir // the collator for the string compares 368cdf0e10cSrcweir m_xCollator = Reference< XCollator >( getORB()->createInstance(::rtl::OUString::createFromAscii( "com.sun.star.i18n.Collator" ) ), UNO_QUERY_THROW ); 369cdf0e10cSrcweir m_xCollator->loadDefaultCollator( Application::GetSettings().GetLocale(), 0 ); 370cdf0e10cSrcweir } 371cdf0e10cSrcweir catch(Exception&) 372cdf0e10cSrcweir { 373cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::Construct: could not create (or start listening at) the database context!"); 374cdf0e10cSrcweir } 375cdf0e10cSrcweir // some help ids 376cdf0e10cSrcweir if (getBrowserView() && getBrowserView()->getVclControl()) 377cdf0e10cSrcweir { 378cdf0e10cSrcweir 379cdf0e10cSrcweir // create controls and set sizes 380cdf0e10cSrcweir const long nFrameWidth = getBrowserView()->LogicToPixel( ::Size( 3, 0 ), MAP_APPFONT ).Width(); 381cdf0e10cSrcweir 382cdf0e10cSrcweir m_pSplitter = new Splitter(getBrowserView(),WB_HSCROLL); 383cdf0e10cSrcweir m_pSplitter->SetPosSizePixel( ::Point(0,0), ::Size(nFrameWidth,0) ); 384cdf0e10cSrcweir m_pSplitter->SetBackground( Wallpaper( Application::GetSettings().GetStyleSettings().GetDialogColor() ) ); 385cdf0e10cSrcweir 386cdf0e10cSrcweir m_pTreeView = new DBTreeView(getBrowserView(),getORB(), WB_TABSTOP | WB_BORDER); 387cdf0e10cSrcweir m_pTreeView->SetPreExpandHandler(LINK(this, SbaTableQueryBrowser, OnExpandEntry)); 388cdf0e10cSrcweir 389cdf0e10cSrcweir m_pTreeView->setCopyHandler(LINK(this, SbaTableQueryBrowser, OnCopyEntry)); 390cdf0e10cSrcweir 391cdf0e10cSrcweir m_pTreeView->getListBox().setContextMenuProvider( this ); 392cdf0e10cSrcweir m_pTreeView->getListBox().setControlActionListener( this ); 393cdf0e10cSrcweir m_pTreeView->SetHelpId(HID_CTL_TREEVIEW); 394cdf0e10cSrcweir 395cdf0e10cSrcweir // a default pos for the splitter, so that the listbox is about 80 (logical) pixels wide 396cdf0e10cSrcweir m_pSplitter->SetSplitPosPixel( getBrowserView()->LogicToPixel( ::Size( 80, 0 ), MAP_APPFONT ).Width() ); 397cdf0e10cSrcweir 398cdf0e10cSrcweir getBrowserView()->setSplitter(m_pSplitter); 399cdf0e10cSrcweir getBrowserView()->setTreeView(m_pTreeView); 400cdf0e10cSrcweir 401cdf0e10cSrcweir // fill view with data 402cdf0e10cSrcweir m_pTreeModel = new SvLBoxTreeList; 403cdf0e10cSrcweir m_pTreeModel->SetSortMode(SortAscending); 404cdf0e10cSrcweir m_pTreeModel->SetCompareHdl(LINK(this, SbaTableQueryBrowser, OnTreeEntryCompare)); 405cdf0e10cSrcweir m_pTreeView->setModel(m_pTreeModel); 406cdf0e10cSrcweir m_pTreeView->setSelChangeHdl( LINK( this, SbaTableQueryBrowser, OnSelectionChange ) ); 407cdf0e10cSrcweir 408cdf0e10cSrcweir // TODO 409cdf0e10cSrcweir getBrowserView()->getVclControl()->GetDataWindow().SetUniqueId(UID_DATABROWSE_DATAWINDOW); 410cdf0e10cSrcweir getBrowserView()->getVclControl()->SetHelpId(HID_CTL_TABBROWSER); 411cdf0e10cSrcweir getBrowserView()->SetUniqueId(UID_CTL_CONTENT); 412cdf0e10cSrcweir if (getBrowserView()->getVclControl()->GetHeaderBar()) 413cdf0e10cSrcweir getBrowserView()->getVclControl()->GetHeaderBar()->SetHelpId(HID_DATABROWSE_HEADER); 414cdf0e10cSrcweir InvalidateFeature(ID_BROWSER_EXPLORER); 415cdf0e10cSrcweir } 416cdf0e10cSrcweir 417cdf0e10cSrcweir return sal_True; 418cdf0e10cSrcweir } 419cdf0e10cSrcweir // --------------------------------------------------------------------------------------------------------------------- 420cdf0e10cSrcweir namespace 421cdf0e10cSrcweir { 422cdf0e10cSrcweir // ----------------------------------------------------------------------------------------------------------------- 423cdf0e10cSrcweir struct SelectValueByName : public ::std::unary_function< ::rtl::OUString, Any > 424cdf0e10cSrcweir { 425cdf0e10cSrcweir const Any& operator()( ::rtl::OUString const& i_name ) const 426cdf0e10cSrcweir { 427cdf0e10cSrcweir return m_rCollection.get( i_name ); 428cdf0e10cSrcweir } 429cdf0e10cSrcweir 430cdf0e10cSrcweir SelectValueByName( ::comphelper::NamedValueCollection const& i_collection ) 431cdf0e10cSrcweir :m_rCollection( i_collection ) 432cdf0e10cSrcweir { 433cdf0e10cSrcweir } 434cdf0e10cSrcweir 435cdf0e10cSrcweir ::comphelper::NamedValueCollection const& m_rCollection; 436cdf0e10cSrcweir }; 437cdf0e10cSrcweir } 438cdf0e10cSrcweir 439cdf0e10cSrcweir // --------------------------------------------------------------------------------------------------------------------- 440cdf0e10cSrcweir void SbaTableQueryBrowser::impl_sanitizeRowSetClauses_nothrow() 441cdf0e10cSrcweir { 442cdf0e10cSrcweir try 443cdf0e10cSrcweir { 444cdf0e10cSrcweir Reference< XPropertySet > xRowSetProps( getRowSet(), UNO_QUERY_THROW ); 445cdf0e10cSrcweir sal_Bool bEscapeProcessing = sal_False; 446cdf0e10cSrcweir OSL_VERIFY( xRowSetProps->getPropertyValue( PROPERTY_ESCAPE_PROCESSING ) >>= bEscapeProcessing ); 447cdf0e10cSrcweir if ( !bEscapeProcessing ) 448cdf0e10cSrcweir // don't touch or interpret anything if escape processing is disabled 449cdf0e10cSrcweir return; 450cdf0e10cSrcweir 451cdf0e10cSrcweir Reference< XSingleSelectQueryComposer > xComposer( createParser_nothrow() ); 452cdf0e10cSrcweir if ( !xComposer.is() ) 453cdf0e10cSrcweir // can't do anything. Already reported via assertion in createParser_nothrow. 454cdf0e10cSrcweir return; 455cdf0e10cSrcweir 456cdf0e10cSrcweir // the tables participating in the statement 457cdf0e10cSrcweir const Reference< XTablesSupplier > xSuppTables( xComposer, UNO_QUERY_THROW ); 458cdf0e10cSrcweir const Reference< XNameAccess > xTableNames( xSuppTables->getTables(), UNO_QUERY_THROW ); 459cdf0e10cSrcweir 460cdf0e10cSrcweir // the columns participating in the statement 461cdf0e10cSrcweir const Reference< XColumnsSupplier > xSuppColumns( xComposer, UNO_QUERY_THROW ); 462cdf0e10cSrcweir const Reference< XNameAccess > xColumnNames( xSuppColumns->getColumns(), UNO_QUERY_THROW ); 463cdf0e10cSrcweir 464cdf0e10cSrcweir // ............................................................................................................. 465cdf0e10cSrcweir // check if the order columns apply to tables which really exist in the statement 466cdf0e10cSrcweir const Reference< XIndexAccess > xOrderColumns( xComposer->getOrderColumns(), UNO_SET_THROW ); 467cdf0e10cSrcweir const sal_Int32 nOrderColumns( xOrderColumns->getCount() ); 468cdf0e10cSrcweir bool invalidColumn = nOrderColumns == 0; 469cdf0e10cSrcweir for ( sal_Int32 c=0; ( c < nOrderColumns ) && !invalidColumn; ++c ) 470cdf0e10cSrcweir { 471cdf0e10cSrcweir const Reference< XPropertySet > xOrderColumn( xOrderColumns->getByIndex(c), UNO_QUERY_THROW ); 472cdf0e10cSrcweir ::rtl::OUString sTableName; 473cdf0e10cSrcweir OSL_VERIFY( xOrderColumn->getPropertyValue( PROPERTY_TABLENAME ) >>= sTableName ); 474cdf0e10cSrcweir ::rtl::OUString sColumnName; 475cdf0e10cSrcweir OSL_VERIFY( xOrderColumn->getPropertyValue( PROPERTY_NAME ) >>= sColumnName ); 476cdf0e10cSrcweir 477cdf0e10cSrcweir if ( sTableName.getLength() == 0 ) 478cdf0e10cSrcweir { 479cdf0e10cSrcweir if ( !xColumnNames->hasByName( sColumnName ) ) 480cdf0e10cSrcweir { 481cdf0e10cSrcweir invalidColumn = true; 482cdf0e10cSrcweir break; 483cdf0e10cSrcweir } 484cdf0e10cSrcweir } 485cdf0e10cSrcweir else 486cdf0e10cSrcweir { 487cdf0e10cSrcweir if ( !xTableNames->hasByName( sTableName ) ) 488cdf0e10cSrcweir { 489cdf0e10cSrcweir invalidColumn = true; 490cdf0e10cSrcweir break; 491cdf0e10cSrcweir } 492cdf0e10cSrcweir 493cdf0e10cSrcweir const Reference< XColumnsSupplier > xSuppTableColumns( xTableNames->getByName( sTableName ), UNO_QUERY_THROW ); 494cdf0e10cSrcweir const Reference< XNameAccess > xTableColumnNames( xSuppTableColumns->getColumns(), UNO_QUERY_THROW ); 495cdf0e10cSrcweir if ( !xTableColumnNames->hasByName( sColumnName ) ) 496cdf0e10cSrcweir { 497cdf0e10cSrcweir invalidColumn = true; 498cdf0e10cSrcweir break; 499cdf0e10cSrcweir } 500cdf0e10cSrcweir } 501cdf0e10cSrcweir } 502cdf0e10cSrcweir 503cdf0e10cSrcweir if ( invalidColumn ) 504cdf0e10cSrcweir { 505cdf0e10cSrcweir // reset the complete order statement at both the row set and the parser 506cdf0e10cSrcweir const ::rtl::OUString sEmptyOrder; 507cdf0e10cSrcweir xRowSetProps->setPropertyValue( PROPERTY_ORDER, makeAny( sEmptyOrder ) ); 508cdf0e10cSrcweir xComposer->setOrder( sEmptyOrder ); 509cdf0e10cSrcweir } 510cdf0e10cSrcweir 511cdf0e10cSrcweir // ............................................................................................................. 512cdf0e10cSrcweir // check if the columns participating in the filter refer to existing tables 513cdf0e10cSrcweir // TODO: there's no API at all for this. The method which comes nearest to what we need is 514cdf0e10cSrcweir // "getStructuredFilter", but it returns pure column names only. That is, for a statement like 515cdf0e10cSrcweir // "SELECT * FROM <table> WHERE <other_table>.<column> = <value>", it will return "<column>". But 516cdf0e10cSrcweir // there's no API at all to retrieve the information about "<other_table>" - which is what would 517cdf0e10cSrcweir // be needed here. 518cdf0e10cSrcweir // That'd be a chance to replace getStructuredFilter with something more reasonable. This method 519cdf0e10cSrcweir // has at least one other problem: For a clause like "<column> != <value>", it will return "<column>" 520cdf0e10cSrcweir // as column name, "NOT_EQUAL" as operator, and "!= <value>" as value, effectively duplicating the 521cdf0e10cSrcweir // information about the operator, and beding all clients to manually remove the "!=" from the value 522cdf0e10cSrcweir // string. 523cdf0e10cSrcweir // So, what really would be handy, is some 524cdf0e10cSrcweir // XNormalizedFilter getNormalizedFilter(); 525cdf0e10cSrcweir // with 526cdf0e10cSrcweir // interface XDisjunctiveFilterExpression 527cdf0e10cSrcweir // { 528cdf0e10cSrcweir // XConjunctiveFilterTerm getTerm( int index ); 529cdf0e10cSrcweir // } 530cdf0e10cSrcweir // interface XConjunctiveFilterTerm 531cdf0e10cSrcweir // { 532cdf0e10cSrcweir // ComparisonPredicate getPredicate( int index ); 533cdf0e10cSrcweir // } 534cdf0e10cSrcweir // struct ComparisonPredicate 535cdf0e10cSrcweir // { 536cdf0e10cSrcweir // XComparisonOperand Lhs; 537cdf0e10cSrcweir // SQLFilterOperator Operator; 538cdf0e10cSrcweir // XComparisonOperand Rhs; 539cdf0e10cSrcweir // } 540cdf0e10cSrcweir // interface XComparisonOperand 541cdf0e10cSrcweir // { 542cdf0e10cSrcweir // SQLFilterOperand Type; 543cdf0e10cSrcweir // XPropertySet getColumn(); 544cdf0e10cSrcweir // string getLiteral(); 545cdf0e10cSrcweir // ... 546cdf0e10cSrcweir // } 547cdf0e10cSrcweir // enum SQLFilterOperand { Column, Literal, ... } 548cdf0e10cSrcweir // 549cdf0e10cSrcweir // ... or something like this .... 550cdf0e10cSrcweir } 551cdf0e10cSrcweir catch( const Exception& ) 552cdf0e10cSrcweir { 553cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 554cdf0e10cSrcweir } 555cdf0e10cSrcweir } 556cdf0e10cSrcweir 557cdf0e10cSrcweir // --------------------------------------------------------------------------------------------------------------------- 558cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::InitializeForm( const Reference< XPropertySet > & i_formProperties ) 559cdf0e10cSrcweir { 560cdf0e10cSrcweir if(!m_pCurrentlyDisplayed) 561cdf0e10cSrcweir return sal_True; 562cdf0e10cSrcweir 563cdf0e10cSrcweir // this method set all format settings from the orignal table or query 564cdf0e10cSrcweir try 565cdf0e10cSrcweir { 566cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(m_pCurrentlyDisplayed->GetUserData()); 567cdf0e10cSrcweir ENSURE_OR_RETURN_FALSE( pData, "SbaTableQueryBrowser::InitializeForm: No user data set at the currently displayed entry!" ); 568cdf0e10cSrcweir ENSURE_OR_RETURN_FALSE( pData->xObjectProperties.is(), "SbaTableQueryBrowser::InitializeForm: No table available!" ); 569cdf0e10cSrcweir 570cdf0e10cSrcweir Reference< XPropertySetInfo > xPSI( pData->xObjectProperties->getPropertySetInfo(), UNO_SET_THROW ); 571cdf0e10cSrcweir 572cdf0e10cSrcweir ::comphelper::NamedValueCollection aPropertyValues; 573cdf0e10cSrcweir 574cdf0e10cSrcweir const ::rtl::OUString aTransferProperties[] = 575cdf0e10cSrcweir { 576cdf0e10cSrcweir PROPERTY_APPLYFILTER, 577cdf0e10cSrcweir PROPERTY_FILTER, 578cdf0e10cSrcweir PROPERTY_HAVING_CLAUSE, 579cdf0e10cSrcweir PROPERTY_ORDER 580cdf0e10cSrcweir }; 581cdf0e10cSrcweir for ( size_t i=0; i < sizeof( aTransferProperties ) / sizeof( aTransferProperties[0] ); ++i ) 582cdf0e10cSrcweir { 583cdf0e10cSrcweir if ( !xPSI->hasPropertyByName( aTransferProperties[i] ) ) 584cdf0e10cSrcweir continue; 585cdf0e10cSrcweir aPropertyValues.put( aTransferProperties[i], pData->xObjectProperties->getPropertyValue( aTransferProperties[i] ) ); 586cdf0e10cSrcweir } 587cdf0e10cSrcweir 588cdf0e10cSrcweir const ::std::vector< ::rtl::OUString > aNames( aPropertyValues.getNames() ); 589cdf0e10cSrcweir Sequence< ::rtl::OUString > aPropNames( aNames.size() ); 590cdf0e10cSrcweir ::std::copy( aNames.begin(), aNames.end(), aPropNames.getArray() ); 591cdf0e10cSrcweir 592cdf0e10cSrcweir Sequence< Any > aPropValues( aNames.size() ); 593cdf0e10cSrcweir ::std::transform( aNames.begin(), aNames.end(), aPropValues.getArray(), SelectValueByName( aPropertyValues ) ); 594cdf0e10cSrcweir 595cdf0e10cSrcweir Reference< XMultiPropertySet > xFormMultiSet( i_formProperties, UNO_QUERY_THROW ); 596cdf0e10cSrcweir xFormMultiSet->setPropertyValues( aPropNames, aPropValues ); 597cdf0e10cSrcweir 598cdf0e10cSrcweir impl_sanitizeRowSetClauses_nothrow(); 599cdf0e10cSrcweir } 600cdf0e10cSrcweir catch ( const Exception& ) 601cdf0e10cSrcweir { 602cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 603cdf0e10cSrcweir return sal_False; 604cdf0e10cSrcweir } 605cdf0e10cSrcweir 606cdf0e10cSrcweir return sal_True; 607cdf0e10cSrcweir } 608cdf0e10cSrcweir 609cdf0e10cSrcweir //------------------------------------------------------------------------------ 610cdf0e10cSrcweir void SbaTableQueryBrowser::initializePreviewMode() 611cdf0e10cSrcweir { 612cdf0e10cSrcweir if ( getBrowserView() && getBrowserView()->getVclControl() ) 613cdf0e10cSrcweir { 614cdf0e10cSrcweir getBrowserView()->getVclControl()->AlwaysEnableInput( sal_False ); 615cdf0e10cSrcweir getBrowserView()->getVclControl()->EnableInput( sal_False ); 616cdf0e10cSrcweir getBrowserView()->getVclControl()->ForceHideScrollbars( sal_True ); 617cdf0e10cSrcweir } 618cdf0e10cSrcweir Reference< XPropertySet > xDataSourceSet(getRowSet(), UNO_QUERY); 619cdf0e10cSrcweir if ( xDataSourceSet.is() ) 620cdf0e10cSrcweir { 621cdf0e10cSrcweir xDataSourceSet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("AllowInserts")),makeAny(sal_False)); 622cdf0e10cSrcweir xDataSourceSet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("AllowUpdates")),makeAny(sal_False)); 623cdf0e10cSrcweir xDataSourceSet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("AllowDeletes")),makeAny(sal_False)); 624cdf0e10cSrcweir } 625cdf0e10cSrcweir } 626cdf0e10cSrcweir 627cdf0e10cSrcweir //------------------------------------------------------------------------------ 628cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::InitializeGridModel(const Reference< ::com::sun::star::form::XFormComponent > & xGrid) 629cdf0e10cSrcweir { 630cdf0e10cSrcweir try 631cdf0e10cSrcweir { 632cdf0e10cSrcweir Reference< ::com::sun::star::form::XGridColumnFactory > xColFactory(xGrid, UNO_QUERY); 633cdf0e10cSrcweir Reference< XNameContainer > xColContainer(xGrid, UNO_QUERY); 634cdf0e10cSrcweir clearGridColumns( xColContainer ); 635cdf0e10cSrcweir 636cdf0e10cSrcweir Reference< XChild > xGridAsChild(xGrid, UNO_QUERY); 637cdf0e10cSrcweir Reference< XLoadable > xFormAsLoadable; 638cdf0e10cSrcweir if (xGridAsChild.is()) 639cdf0e10cSrcweir xFormAsLoadable = xFormAsLoadable.query(xGridAsChild->getParent()); 640cdf0e10cSrcweir if (xFormAsLoadable.is() && xFormAsLoadable->isLoaded()) 641cdf0e10cSrcweir { 642cdf0e10cSrcweir // set the formats from the table 643cdf0e10cSrcweir if(m_pCurrentlyDisplayed) 644cdf0e10cSrcweir { 645cdf0e10cSrcweir Sequence< ::rtl::OUString> aProperties(6 + ( m_bPreview ? 5 : 0 )); 646cdf0e10cSrcweir Sequence< Any> aValues(7 + ( m_bPreview ? 5 : 0 )); 647cdf0e10cSrcweir 648cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(m_pCurrentlyDisplayed->GetUserData()); 649cdf0e10cSrcweir OSL_ENSURE( pData->xObjectProperties.is(), "SbaTableQueryBrowser::InitializeGridModel: No table available!" ); 650cdf0e10cSrcweir if ( !pData->xObjectProperties.is() ) 651cdf0e10cSrcweir return sal_False; 652cdf0e10cSrcweir 653cdf0e10cSrcweir ::rtl::OUString* pStringIter = aProperties.getArray(); 654cdf0e10cSrcweir Any* pValueIter = aValues.getArray(); 655cdf0e10cSrcweir if ( m_bPreview ) 656cdf0e10cSrcweir { 657cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("AlwaysShowCursor")); 658cdf0e10cSrcweir *pValueIter++ <<= sal_False; 659cdf0e10cSrcweir *pStringIter++ = PROPERTY_BORDER; 660cdf0e10cSrcweir *pValueIter++ <<= sal_Int16(0); 661cdf0e10cSrcweir } 662cdf0e10cSrcweir 663cdf0e10cSrcweir *pStringIter++ = PROPERTY_FONT; 664cdf0e10cSrcweir *pValueIter++ = pData->xObjectProperties->getPropertyValue(PROPERTY_FONT); 665cdf0e10cSrcweir *pStringIter++ = PROPERTY_TEXTEMPHASIS; 666cdf0e10cSrcweir *pValueIter++ = pData->xObjectProperties->getPropertyValue(PROPERTY_TEXTEMPHASIS); 667cdf0e10cSrcweir *pStringIter++ = PROPERTY_TEXTRELIEF; 668cdf0e10cSrcweir *pValueIter++ = pData->xObjectProperties->getPropertyValue(PROPERTY_TEXTRELIEF); 669cdf0e10cSrcweir if ( m_bPreview ) 670cdf0e10cSrcweir { 671cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("HasNavigationBar")); 672cdf0e10cSrcweir *pValueIter++ <<= sal_False; 673cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("HasRecordMarker")); 674cdf0e10cSrcweir *pValueIter++ <<= sal_False; 675cdf0e10cSrcweir } 676cdf0e10cSrcweir *pStringIter++ = PROPERTY_ROW_HEIGHT; 677cdf0e10cSrcweir *pValueIter++ = pData->xObjectProperties->getPropertyValue(PROPERTY_ROW_HEIGHT); 678cdf0e10cSrcweir if ( m_bPreview ) 679cdf0e10cSrcweir { 680cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Tabstop")); 681cdf0e10cSrcweir *pValueIter++ <<= sal_False; 682cdf0e10cSrcweir } 683cdf0e10cSrcweir *pStringIter++ = PROPERTY_TEXTCOLOR; 684cdf0e10cSrcweir *pValueIter++ = pData->xObjectProperties->getPropertyValue(PROPERTY_TEXTCOLOR); 685cdf0e10cSrcweir *pStringIter++ = PROPERTY_TEXTLINECOLOR; 686cdf0e10cSrcweir *pValueIter++ = pData->xObjectProperties->getPropertyValue(PROPERTY_TEXTLINECOLOR); 687cdf0e10cSrcweir 688cdf0e10cSrcweir Reference< XMultiPropertySet > xFormMultiSet(xGrid, UNO_QUERY); 689cdf0e10cSrcweir xFormMultiSet->setPropertyValues(aProperties, aValues); 690cdf0e10cSrcweir } 691cdf0e10cSrcweir 692cdf0e10cSrcweir 693cdf0e10cSrcweir // get the formats supplier of the database we're working with 694cdf0e10cSrcweir Reference< ::com::sun::star::util::XNumberFormatsSupplier > xSupplier = getNumberFormatter()->getNumberFormatsSupplier(); 695cdf0e10cSrcweir 696cdf0e10cSrcweir Reference<XConnection> xConnection; 697cdf0e10cSrcweir Reference<XPropertySet> xRowSetProps(getRowSet(),UNO_QUERY); 698cdf0e10cSrcweir xRowSetProps->getPropertyValue( PROPERTY_ACTIVE_CONNECTION ) >>= xConnection; 699cdf0e10cSrcweir OSL_ENSURE(xConnection.is(),"A ActiveConnection should normaly exists!"); 700cdf0e10cSrcweir 701cdf0e10cSrcweir Reference<XChild> xChild(xConnection,UNO_QUERY); 702cdf0e10cSrcweir Reference<XPropertySet> xDataSourceProp(xChild->getParent(),UNO_QUERY); 703cdf0e10cSrcweir sal_Bool bSuppressVersionCol = sal_False; 704cdf0e10cSrcweir OSL_VERIFY( xDataSourceProp->getPropertyValue( PROPERTY_SUPPRESSVERSIONCL ) >>= bSuppressVersionCol ); 705cdf0e10cSrcweir 706cdf0e10cSrcweir // insert the column into the gridcontrol so that we see something :-) 707cdf0e10cSrcweir ::rtl::OUString aCurrentModelType; 708cdf0e10cSrcweir Reference<XColumnsSupplier> xSupCols(getRowSet(),UNO_QUERY); 709cdf0e10cSrcweir Reference<XNameAccess> xColumns = xSupCols->getColumns(); 710cdf0e10cSrcweir Sequence< ::rtl::OUString> aNames = xColumns->getElementNames(); 711cdf0e10cSrcweir const ::rtl::OUString* pIter = aNames.getConstArray(); 712cdf0e10cSrcweir const ::rtl::OUString* pEnd = pIter + aNames.getLength(); 713cdf0e10cSrcweir 714cdf0e10cSrcweir ::rtl::OUString sDefaultProperty; 715cdf0e10cSrcweir Reference< XPropertySet > xColumn; 716cdf0e10cSrcweir Reference< XPropertySetInfo > xColPSI; 717cdf0e10cSrcweir for (sal_uInt16 i=0; pIter != pEnd; ++i,++pIter) 718cdf0e10cSrcweir { 719cdf0e10cSrcweir xColumn.set( xColumns->getByName( *pIter ), UNO_QUERY_THROW ); 720cdf0e10cSrcweir xColPSI.set( xColumn->getPropertySetInfo(), UNO_SET_THROW ); 721cdf0e10cSrcweir 722cdf0e10cSrcweir // ignore the column when it is a rowversion one 723cdf0e10cSrcweir if ( bSuppressVersionCol 724cdf0e10cSrcweir && xColPSI->hasPropertyByName( PROPERTY_ISROWVERSION ) 725cdf0e10cSrcweir && ::cppu::any2bool( xColumn->getPropertyValue( PROPERTY_ISROWVERSION ) ) 726cdf0e10cSrcweir ) 727cdf0e10cSrcweir continue; 728cdf0e10cSrcweir 729cdf0e10cSrcweir // use the result set column's type to determine the type of grid column to create 730cdf0e10cSrcweir sal_Bool bFormattedIsNumeric = sal_True; 731cdf0e10cSrcweir sal_Int32 nType = ::comphelper::getINT32( xColumn->getPropertyValue( PROPERTY_TYPE ) ); 732cdf0e10cSrcweir 733cdf0e10cSrcweir ::std::vector< NamedValue > aInitialValues; 734cdf0e10cSrcweir ::std::vector< ::rtl::OUString > aCopyProperties; 735cdf0e10cSrcweir Any aDefault; 736cdf0e10cSrcweir 737cdf0e10cSrcweir switch(nType) 738cdf0e10cSrcweir { 739cdf0e10cSrcweir case DataType::BIT: 740cdf0e10cSrcweir case DataType::BOOLEAN: 741cdf0e10cSrcweir { 742cdf0e10cSrcweir aCurrentModelType = ::rtl::OUString::createFromAscii("CheckBox"); 743cdf0e10cSrcweir aInitialValues.push_back( NamedValue( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "VisualEffect" ) ), makeAny( VisualEffect::FLAT ) ) ); 744cdf0e10cSrcweir sDefaultProperty = PROPERTY_DEFAULTSTATE; 745cdf0e10cSrcweir 746cdf0e10cSrcweir sal_Int32 nNullable = ColumnValue::NULLABLE_UNKNOWN; 747cdf0e10cSrcweir OSL_VERIFY( xColumn->getPropertyValue( PROPERTY_ISNULLABLE ) >>= nNullable ); 748cdf0e10cSrcweir aInitialValues.push_back( NamedValue( 749cdf0e10cSrcweir ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "TriState" ) ), 750cdf0e10cSrcweir makeAny( sal_Bool( ColumnValue::NO_NULLS != nNullable ) ) 751cdf0e10cSrcweir ) ); 752cdf0e10cSrcweir if ( ColumnValue::NO_NULLS == nNullable ) 753cdf0e10cSrcweir aDefault <<= (sal_Int16)STATE_NOCHECK; 754cdf0e10cSrcweir } 755cdf0e10cSrcweir break; 756cdf0e10cSrcweir 757cdf0e10cSrcweir case DataType::LONGVARCHAR: 758cdf0e10cSrcweir case DataType::CLOB: 759cdf0e10cSrcweir aInitialValues.push_back( NamedValue( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "MultiLine" ) ), makeAny( (sal_Bool)sal_True ) ) ); 760cdf0e10cSrcweir // NO break! 761cdf0e10cSrcweir case DataType::BINARY: 762cdf0e10cSrcweir case DataType::VARBINARY: 763cdf0e10cSrcweir case DataType::LONGVARBINARY: 764cdf0e10cSrcweir aCurrentModelType = ::rtl::OUString::createFromAscii("TextField"); 765cdf0e10cSrcweir sDefaultProperty = PROPERTY_DEFAULTTEXT; 766cdf0e10cSrcweir break; 767cdf0e10cSrcweir 768cdf0e10cSrcweir case DataType::VARCHAR: 769cdf0e10cSrcweir case DataType::CHAR: 770cdf0e10cSrcweir bFormattedIsNumeric = sal_False; 771cdf0e10cSrcweir // NO break! 772cdf0e10cSrcweir default: 773cdf0e10cSrcweir aCurrentModelType = ::rtl::OUString::createFromAscii("FormattedField"); 774cdf0e10cSrcweir sDefaultProperty = PROPERTY_EFFECTIVEDEFAULT; 775cdf0e10cSrcweir 776cdf0e10cSrcweir if ( xSupplier.is() ) 777cdf0e10cSrcweir aInitialValues.push_back( NamedValue( ::rtl::OUString::createFromAscii( "FormatsSupplier" ), makeAny( xSupplier ) ) ); 778cdf0e10cSrcweir aInitialValues.push_back( NamedValue( ::rtl::OUString::createFromAscii( "TreatAsNumber" ), makeAny( (sal_Bool)bFormattedIsNumeric ) ) ); 779cdf0e10cSrcweir aCopyProperties.push_back( PROPERTY_FORMATKEY ); 780cdf0e10cSrcweir break; 781cdf0e10cSrcweir } 782cdf0e10cSrcweir 783cdf0e10cSrcweir aInitialValues.push_back( NamedValue( PROPERTY_CONTROLSOURCE, makeAny( *pIter ) ) ); 784cdf0e10cSrcweir ::rtl::OUString sLabel; 785cdf0e10cSrcweir xColumn->getPropertyValue(PROPERTY_LABEL) >>= sLabel; 786cdf0e10cSrcweir if ( sLabel.getLength() ) 787cdf0e10cSrcweir aInitialValues.push_back( NamedValue( PROPERTY_LABEL, makeAny( sLabel ) ) ); 788cdf0e10cSrcweir else 789cdf0e10cSrcweir aInitialValues.push_back( NamedValue( PROPERTY_LABEL, makeAny( *pIter ) ) ); 790cdf0e10cSrcweir 791cdf0e10cSrcweir Reference< XPropertySet > xGridCol( xColFactory->createColumn( aCurrentModelType ), UNO_SET_THROW ); 792cdf0e10cSrcweir Reference< XPropertySetInfo > xGridColPSI( xGridCol->getPropertySetInfo(), UNO_SET_THROW ); 793cdf0e10cSrcweir 794cdf0e10cSrcweir // calculate the default 795cdf0e10cSrcweir if ( xGridColPSI->hasPropertyByName( PROPERTY_CONTROLDEFAULT ) ) 796cdf0e10cSrcweir { 797cdf0e10cSrcweir aDefault = xColumn->getPropertyValue( PROPERTY_CONTROLDEFAULT ); 798cdf0e10cSrcweir // default value 799cdf0e10cSrcweir if ( nType == DataType::BIT || nType == DataType::BOOLEAN ) 800cdf0e10cSrcweir { 801cdf0e10cSrcweir if ( aDefault.hasValue() ) 802cdf0e10cSrcweir aDefault <<= (comphelper::getString(aDefault).toInt32() == 0) ? (sal_Int16)STATE_NOCHECK : (sal_Int16)STATE_CHECK; 803cdf0e10cSrcweir else 804cdf0e10cSrcweir aDefault <<= ((sal_Int16)STATE_DONTKNOW); 805cdf0e10cSrcweir } 806cdf0e10cSrcweir } 807cdf0e10cSrcweir 808cdf0e10cSrcweir if ( aDefault.hasValue() ) 809cdf0e10cSrcweir aInitialValues.push_back( NamedValue( sDefaultProperty, aDefault ) ); 810cdf0e10cSrcweir 811cdf0e10cSrcweir // transfer properties from the definition to the UNO-model : 812cdf0e10cSrcweir aCopyProperties.push_back( PROPERTY_HIDDEN ); 813cdf0e10cSrcweir aCopyProperties.push_back( PROPERTY_WIDTH ); 814cdf0e10cSrcweir 815cdf0e10cSrcweir // help text to display for the column 816cdf0e10cSrcweir Any aDescription; 817cdf0e10cSrcweir if ( xColPSI->hasPropertyByName( PROPERTY_HELPTEXT ) ) 818cdf0e10cSrcweir aDescription = xColumn->getPropertyValue( PROPERTY_HELPTEXT ); 819cdf0e10cSrcweir ::rtl::OUString sTemp; 820cdf0e10cSrcweir aDescription >>= sTemp; 821cdf0e10cSrcweir if ( !sTemp.getLength() ) 822cdf0e10cSrcweir xColumn->getPropertyValue( PROPERTY_DESCRIPTION ) >>= sTemp; 823cdf0e10cSrcweir 824cdf0e10cSrcweir aDescription <<= sTemp; 825cdf0e10cSrcweir aInitialValues.push_back( NamedValue( PROPERTY_HELPTEXT, aDescription ) ); 826cdf0e10cSrcweir 827cdf0e10cSrcweir // ... horizontal justify 828cdf0e10cSrcweir Any aAlign; aAlign <<= sal_Int16( 0 ); 829cdf0e10cSrcweir Any aColAlign( xColumn->getPropertyValue( PROPERTY_ALIGN ) ); 830cdf0e10cSrcweir if ( aColAlign.hasValue() ) 831cdf0e10cSrcweir aAlign <<= sal_Int16( ::comphelper::getINT32( aColAlign ) ); 832cdf0e10cSrcweir aInitialValues.push_back( NamedValue( PROPERTY_ALIGN, aAlign ) ); 833cdf0e10cSrcweir 834cdf0e10cSrcweir // don't allow the mouse to scroll in the cells 835cdf0e10cSrcweir if ( xGridColPSI->hasPropertyByName( PROPERTY_MOUSE_WHEEL_BEHAVIOR ) ) 836cdf0e10cSrcweir aInitialValues.push_back( NamedValue( PROPERTY_MOUSE_WHEEL_BEHAVIOR, makeAny( MouseWheelBehavior::SCROLL_DISABLED ) ) ); 837cdf0e10cSrcweir 838cdf0e10cSrcweir // now set all those values 839cdf0e10cSrcweir for ( ::std::vector< NamedValue >::const_iterator property = aInitialValues.begin(); 840cdf0e10cSrcweir property != aInitialValues.end(); 841cdf0e10cSrcweir ++property 842cdf0e10cSrcweir ) 843cdf0e10cSrcweir { 844cdf0e10cSrcweir xGridCol->setPropertyValue( property->Name, property->Value ); 845cdf0e10cSrcweir } 846cdf0e10cSrcweir for ( ::std::vector< ::rtl::OUString >::const_iterator copyPropertyName = aCopyProperties.begin(); 847cdf0e10cSrcweir copyPropertyName != aCopyProperties.end(); 848cdf0e10cSrcweir ++copyPropertyName 849cdf0e10cSrcweir ) 850cdf0e10cSrcweir xGridCol->setPropertyValue( *copyPropertyName, xColumn->getPropertyValue( *copyPropertyName ) ); 851cdf0e10cSrcweir 852cdf0e10cSrcweir xColContainer->insertByName(*pIter, makeAny(xGridCol)); 853cdf0e10cSrcweir } 854cdf0e10cSrcweir } 855cdf0e10cSrcweir } 856cdf0e10cSrcweir catch(Exception&) 857cdf0e10cSrcweir { 858cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 859cdf0e10cSrcweir return sal_False; 860cdf0e10cSrcweir } 861cdf0e10cSrcweir 862cdf0e10cSrcweir return sal_True; 863cdf0e10cSrcweir } 864cdf0e10cSrcweir // ----------------------------------------------------------------------------- 865cdf0e10cSrcweir Reference<XPropertySet> getColumnHelper(SvLBoxEntry* _pCurrentlyDisplayed,const Reference<XPropertySet>& _rxSource) 866cdf0e10cSrcweir { 867cdf0e10cSrcweir Reference<XPropertySet> xRet; 868cdf0e10cSrcweir if(_pCurrentlyDisplayed) 869cdf0e10cSrcweir { 870cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(_pCurrentlyDisplayed->GetUserData()); 871cdf0e10cSrcweir Reference<XColumnsSupplier> xColumnsSup(pData->xObjectProperties,UNO_QUERY); 872cdf0e10cSrcweir Reference<XNameAccess> xNames = xColumnsSup->getColumns(); 873cdf0e10cSrcweir ::rtl::OUString aName; 874cdf0e10cSrcweir _rxSource->getPropertyValue(PROPERTY_NAME) >>= aName; 875cdf0e10cSrcweir if(xNames.is() && xNames->hasByName(aName)) 876cdf0e10cSrcweir xRet.set(xNames->getByName(aName),UNO_QUERY); 877cdf0e10cSrcweir } 878cdf0e10cSrcweir return xRet; 879cdf0e10cSrcweir } 880cdf0e10cSrcweir 881cdf0e10cSrcweir // ----------------------------------------------------------------------- 882cdf0e10cSrcweir void SbaTableQueryBrowser::transferChangedControlProperty(const ::rtl::OUString& _rProperty, const Any& _rNewValue) 883cdf0e10cSrcweir { 884cdf0e10cSrcweir if(m_pCurrentlyDisplayed) 885cdf0e10cSrcweir { 886cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(m_pCurrentlyDisplayed->GetUserData()); 887cdf0e10cSrcweir Reference< XPropertySet > xObjectProps(pData->xObjectProperties, UNO_QUERY); 888cdf0e10cSrcweir OSL_ENSURE(xObjectProps.is(),"SbaTableQueryBrowser::transferChangedControlProperty: no table/query object!"); 889cdf0e10cSrcweir if (xObjectProps.is()) 890cdf0e10cSrcweir xObjectProps->setPropertyValue(_rProperty, _rNewValue); 891cdf0e10cSrcweir } 892cdf0e10cSrcweir } 893cdf0e10cSrcweir 894cdf0e10cSrcweir // ----------------------------------------------------------------------- 895cdf0e10cSrcweir void SbaTableQueryBrowser::propertyChange(const PropertyChangeEvent& evt) throw(::com::sun::star::uno::RuntimeException) 896cdf0e10cSrcweir { 897cdf0e10cSrcweir SbaXDataBrowserController::propertyChange(evt); 898cdf0e10cSrcweir 899cdf0e10cSrcweir try 900cdf0e10cSrcweir { 901cdf0e10cSrcweir Reference< XPropertySet > xSource(evt.Source, UNO_QUERY); 902cdf0e10cSrcweir if (!xSource.is()) 903cdf0e10cSrcweir return; 904cdf0e10cSrcweir 905cdf0e10cSrcweir // one of the many properties which require us to update the definition ? 906cdf0e10cSrcweir // a column's width ? 907cdf0e10cSrcweir else if (evt.PropertyName.equals(PROPERTY_WIDTH)) 908cdf0e10cSrcweir { // a column width has changed -> update the model 909cdf0e10cSrcweir // (the update of the view is done elsewhere) 910cdf0e10cSrcweir Reference<XPropertySet> xProp = getColumnHelper(m_pCurrentlyDisplayed,xSource); 911cdf0e10cSrcweir if(xProp.is()) 912cdf0e10cSrcweir { 913cdf0e10cSrcweir if(!evt.NewValue.hasValue()) 914cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_WIDTH,makeAny((sal_Int32)227)); 915cdf0e10cSrcweir else 916cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_WIDTH,evt.NewValue); 917cdf0e10cSrcweir } 918cdf0e10cSrcweir } 919cdf0e10cSrcweir 920cdf0e10cSrcweir // a column's 'visible' state ? 921cdf0e10cSrcweir else if (evt.PropertyName.equals(PROPERTY_HIDDEN)) 922cdf0e10cSrcweir { 923cdf0e10cSrcweir Reference<XPropertySet> xProp = getColumnHelper(m_pCurrentlyDisplayed,xSource); 924cdf0e10cSrcweir if(xProp.is()) 925cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_HIDDEN,evt.NewValue); 926cdf0e10cSrcweir } 927cdf0e10cSrcweir 928cdf0e10cSrcweir // a columns alignment ? 929cdf0e10cSrcweir else if (evt.PropertyName.equals(PROPERTY_ALIGN)) 930cdf0e10cSrcweir { 931cdf0e10cSrcweir Reference<XPropertySet> xProp = getColumnHelper(m_pCurrentlyDisplayed,xSource); 932cdf0e10cSrcweir try 933cdf0e10cSrcweir { 934cdf0e10cSrcweir if(xProp.is()) 935cdf0e10cSrcweir { 936cdf0e10cSrcweir if(evt.NewValue.hasValue()) 937cdf0e10cSrcweir { 938cdf0e10cSrcweir sal_Int16 nAlign = 0; 939cdf0e10cSrcweir if(evt.NewValue >>= nAlign) 940cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_ALIGN,makeAny(sal_Int32(nAlign))); 941cdf0e10cSrcweir else 942cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_ALIGN,evt.NewValue); 943cdf0e10cSrcweir } 944cdf0e10cSrcweir else 945cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_ALIGN,makeAny(::com::sun::star::awt::TextAlign::LEFT)); 946cdf0e10cSrcweir } 947cdf0e10cSrcweir } 948cdf0e10cSrcweir catch( const Exception& ) 949cdf0e10cSrcweir { 950cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 951cdf0e10cSrcweir } 952cdf0e10cSrcweir } 953cdf0e10cSrcweir 954cdf0e10cSrcweir // a column's format ? 955cdf0e10cSrcweir else if ( (evt.PropertyName.equals(PROPERTY_FORMATKEY)) 956cdf0e10cSrcweir && (TypeClass_LONG == evt.NewValue.getValueTypeClass()) 957cdf0e10cSrcweir ) 958cdf0e10cSrcweir { 959cdf0e10cSrcweir // update the model (means the definition object) 960cdf0e10cSrcweir Reference<XPropertySet> xProp = getColumnHelper(m_pCurrentlyDisplayed,xSource); 961cdf0e10cSrcweir if(xProp.is()) 962cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_FORMATKEY,evt.NewValue); 963cdf0e10cSrcweir } 964cdf0e10cSrcweir 965cdf0e10cSrcweir // some table definition properties ? 966cdf0e10cSrcweir // the height of the rows in the grid ? 967cdf0e10cSrcweir else if (evt.PropertyName.equals(PROPERTY_ROW_HEIGHT)) 968cdf0e10cSrcweir { 969cdf0e10cSrcweir if(m_pCurrentlyDisplayed) 970cdf0e10cSrcweir { 971cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(m_pCurrentlyDisplayed->GetUserData()); 972cdf0e10cSrcweir OSL_ENSURE( pData->xObjectProperties.is(), "No table available!" ); 973cdf0e10cSrcweir 974cdf0e10cSrcweir sal_Bool bDefault = !evt.NewValue.hasValue(); 975cdf0e10cSrcweir if (bDefault) 976cdf0e10cSrcweir pData->xObjectProperties->setPropertyValue(PROPERTY_ROW_HEIGHT,makeAny((sal_Int32)45)); 977cdf0e10cSrcweir else 978cdf0e10cSrcweir pData->xObjectProperties->setPropertyValue(PROPERTY_ROW_HEIGHT,evt.NewValue); 979cdf0e10cSrcweir } 980cdf0e10cSrcweir } 981cdf0e10cSrcweir 982cdf0e10cSrcweir else if ( evt.PropertyName.equals(PROPERTY_FONT) // the font ? 983cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_TEXTCOLOR) // the text color ? 984cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_FILTER) // the filter ? 985cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_HAVING_CLAUSE) // the having clause ? 986cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_ORDER) // the sort ? 987cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_APPLYFILTER) // the appliance of the filter ? 988cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_TEXTLINECOLOR) // the text line color ? 989cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_TEXTEMPHASIS) // the text emphasis ? 990cdf0e10cSrcweir || evt.PropertyName.equals(PROPERTY_TEXTRELIEF) // the text relief ? 991cdf0e10cSrcweir ) 992cdf0e10cSrcweir { 993cdf0e10cSrcweir transferChangedControlProperty(evt.PropertyName, evt.NewValue); 994cdf0e10cSrcweir } 995cdf0e10cSrcweir } 996cdf0e10cSrcweir catch( const Exception& ) 997cdf0e10cSrcweir { 998cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 999cdf0e10cSrcweir } 1000cdf0e10cSrcweir } 1001cdf0e10cSrcweir 1002cdf0e10cSrcweir // ----------------------------------------------------------------------- 1003cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::suspend(sal_Bool bSuspend) throw( RuntimeException ) 1004cdf0e10cSrcweir { 1005cdf0e10cSrcweir vos::OGuard aSolarGuard( Application::GetSolarMutex() ); 1006cdf0e10cSrcweir ::osl::MutexGuard aGuard( getMutex() ); 1007cdf0e10cSrcweir if ( getView() && getView()->IsInModalMode() ) 1008cdf0e10cSrcweir return sal_False; 1009cdf0e10cSrcweir sal_Bool bRet = sal_False; 1010cdf0e10cSrcweir if ( !m_bInSuspend ) 1011cdf0e10cSrcweir { 1012cdf0e10cSrcweir m_bInSuspend = sal_True; 1013cdf0e10cSrcweir if ( rBHelper.bDisposed ) 1014cdf0e10cSrcweir throw DisposedException( ::rtl::OUString(), *this ); 1015cdf0e10cSrcweir 1016cdf0e10cSrcweir bRet = SbaXDataBrowserController::suspend(bSuspend); 1017cdf0e10cSrcweir if ( bRet && getView() ) 1018cdf0e10cSrcweir getView()->Hide(); 1019cdf0e10cSrcweir 1020cdf0e10cSrcweir m_bInSuspend = sal_False; 1021cdf0e10cSrcweir } 1022cdf0e10cSrcweir 1023cdf0e10cSrcweir return bRet; 1024cdf0e10cSrcweir } 1025cdf0e10cSrcweir 1026cdf0e10cSrcweir // ------------------------------------------------------------------------- 1027cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::statusChanged( const FeatureStateEvent& _rEvent ) throw(RuntimeException) 1028cdf0e10cSrcweir { 1029cdf0e10cSrcweir // search the external dispatcher causing this call 1030cdf0e10cSrcweir Reference< XDispatch > xSource(_rEvent.Source, UNO_QUERY); 1031cdf0e10cSrcweir ExternalFeaturesMap::iterator aLoop; 1032cdf0e10cSrcweir for ( aLoop = m_aExternalFeatures.begin(); 1033cdf0e10cSrcweir aLoop != m_aExternalFeatures.end(); 1034cdf0e10cSrcweir ++aLoop 1035cdf0e10cSrcweir ) 1036cdf0e10cSrcweir { 1037cdf0e10cSrcweir if ( _rEvent.FeatureURL.Complete == aLoop->second.aURL.Complete) 1038cdf0e10cSrcweir { 1039cdf0e10cSrcweir DBG_ASSERT( xSource.get() == aLoop->second.xDispatcher.get(), "SbaTableQueryBrowser::statusChanged: inconsistent!" ); 1040cdf0e10cSrcweir // update the enabled state 1041cdf0e10cSrcweir aLoop->second.bEnabled = _rEvent.IsEnabled; 1042cdf0e10cSrcweir 1043cdf0e10cSrcweir switch ( aLoop->first ) 1044cdf0e10cSrcweir { 1045cdf0e10cSrcweir case ID_BROWSER_DOCUMENT_DATASOURCE: 1046cdf0e10cSrcweir { 1047cdf0e10cSrcweir // if it's the slot for the document data source, remember the state 1048cdf0e10cSrcweir Sequence< PropertyValue > aDescriptor; 1049cdf0e10cSrcweir #if OSL_DEBUG_LEVEL > 0 1050cdf0e10cSrcweir sal_Bool bProperFormat = 1051cdf0e10cSrcweir #endif 1052cdf0e10cSrcweir _rEvent.State >>= aDescriptor; 1053cdf0e10cSrcweir OSL_ENSURE(bProperFormat, "SbaTableQueryBrowser::statusChanged: need a data access descriptor here!"); 1054cdf0e10cSrcweir m_aDocumentDataSource.initializeFrom(aDescriptor); 1055cdf0e10cSrcweir 1056cdf0e10cSrcweir OSL_ENSURE( ( m_aDocumentDataSource.has(daDataSource) 1057cdf0e10cSrcweir || m_aDocumentDataSource.has(daDatabaseLocation) 1058cdf0e10cSrcweir ) 1059cdf0e10cSrcweir && m_aDocumentDataSource.has(daCommand) 1060cdf0e10cSrcweir && m_aDocumentDataSource.has(daCommandType), 1061cdf0e10cSrcweir "SbaTableQueryBrowser::statusChanged: incomplete descriptor!"); 1062cdf0e10cSrcweir 1063cdf0e10cSrcweir // check if we know the object which is set as document data source 1064cdf0e10cSrcweir checkDocumentDataSource(); 1065cdf0e10cSrcweir } 1066cdf0e10cSrcweir break; 1067cdf0e10cSrcweir 1068cdf0e10cSrcweir default: 1069cdf0e10cSrcweir // update the toolbox 1070cdf0e10cSrcweir implCheckExternalSlot( aLoop->first ); 1071cdf0e10cSrcweir break; 1072cdf0e10cSrcweir } 1073cdf0e10cSrcweir break; 1074cdf0e10cSrcweir } 1075cdf0e10cSrcweir } 1076cdf0e10cSrcweir 1077cdf0e10cSrcweir DBG_ASSERT(aLoop != m_aExternalFeatures.end(), "SbaTableQueryBrowser::statusChanged: don't know who sent this!"); 1078cdf0e10cSrcweir } 1079cdf0e10cSrcweir 1080cdf0e10cSrcweir // ------------------------------------------------------------------------- 1081cdf0e10cSrcweir void SbaTableQueryBrowser::checkDocumentDataSource() 1082cdf0e10cSrcweir { 1083cdf0e10cSrcweir SvLBoxEntry* pDataSourceEntry = NULL; 1084cdf0e10cSrcweir SvLBoxEntry* pContainerEntry = NULL; 1085cdf0e10cSrcweir SvLBoxEntry* pObjectEntry = getObjectEntry( m_aDocumentDataSource, &pDataSourceEntry, &pContainerEntry, sal_False ); 1086cdf0e10cSrcweir sal_Bool bKnownDocDataSource = (NULL != pObjectEntry); 1087cdf0e10cSrcweir if (!bKnownDocDataSource) 1088cdf0e10cSrcweir { 1089cdf0e10cSrcweir if (NULL != pDataSourceEntry) 1090cdf0e10cSrcweir { // at least the data source is know 1091cdf0e10cSrcweir if (NULL != pContainerEntry) 1092cdf0e10cSrcweir bKnownDocDataSource = sal_True; // assume we know it. 1093cdf0e10cSrcweir // TODO: should we expand the object container? This may be too expensive just for checking .... 1094cdf0e10cSrcweir else 1095cdf0e10cSrcweir { 1096cdf0e10cSrcweir if ((NULL == pObjectEntry) && m_aDocumentDataSource.has(daCommandType) && m_aDocumentDataSource.has(daCommand)) 1097cdf0e10cSrcweir { // maybe we have a command to be displayed ? 1098cdf0e10cSrcweir sal_Int32 nCommandType = CommandType::TABLE; 1099cdf0e10cSrcweir m_aDocumentDataSource[daCommandType] >>= nCommandType; 1100cdf0e10cSrcweir 1101cdf0e10cSrcweir ::rtl::OUString sCommand; 1102cdf0e10cSrcweir m_aDocumentDataSource[daCommand] >>= sCommand; 1103cdf0e10cSrcweir 1104cdf0e10cSrcweir bKnownDocDataSource = (CommandType::COMMAND == nCommandType) && (0 != sCommand.getLength()); 1105cdf0e10cSrcweir } 1106cdf0e10cSrcweir } 1107cdf0e10cSrcweir } 1108cdf0e10cSrcweir } 1109cdf0e10cSrcweir 1110cdf0e10cSrcweir if ( !bKnownDocDataSource ) 1111cdf0e10cSrcweir m_aExternalFeatures[ ID_BROWSER_DOCUMENT_DATASOURCE ].bEnabled = sal_False; 1112cdf0e10cSrcweir 1113cdf0e10cSrcweir // update the toolbox 1114cdf0e10cSrcweir implCheckExternalSlot(ID_BROWSER_DOCUMENT_DATASOURCE); 1115cdf0e10cSrcweir } 1116cdf0e10cSrcweir 1117cdf0e10cSrcweir // ------------------------------------------------------------------------- 1118cdf0e10cSrcweir void SbaTableQueryBrowser::extractDescriptorProps(const ::svx::ODataAccessDescriptor& _rDescriptor, ::rtl::OUString& _rDataSource, ::rtl::OUString& _rCommand, sal_Int32& _rCommandType, sal_Bool& _rEscapeProcessing) 1119cdf0e10cSrcweir { 1120cdf0e10cSrcweir _rDataSource = _rDescriptor.getDataSource(); 1121cdf0e10cSrcweir if ( _rDescriptor.has(daCommand) ) 1122cdf0e10cSrcweir _rDescriptor[daCommand] >>= _rCommand; 1123cdf0e10cSrcweir if ( _rDescriptor.has(daCommandType) ) 1124cdf0e10cSrcweir _rDescriptor[daCommandType] >>= _rCommandType; 1125cdf0e10cSrcweir 1126cdf0e10cSrcweir // escape processing is the only one allowed not to be present 1127cdf0e10cSrcweir _rEscapeProcessing = sal_True; 1128cdf0e10cSrcweir if (_rDescriptor.has(daEscapeProcessing)) 1129cdf0e10cSrcweir _rEscapeProcessing = ::cppu::any2bool(_rDescriptor[daEscapeProcessing]); 1130cdf0e10cSrcweir } 1131cdf0e10cSrcweir 1132cdf0e10cSrcweir // ------------------------------------------------------------------------- 1133cdf0e10cSrcweir namespace 1134cdf0e10cSrcweir { 1135cdf0e10cSrcweir bool getDataSourceDisplayName_isURL( const String& _rDS, String& _rDisplayName, String& _rUniqueId ) 1136cdf0e10cSrcweir { 1137cdf0e10cSrcweir INetURLObject aURL( _rDS ); 1138cdf0e10cSrcweir if ( aURL.GetProtocol() != INET_PROT_NOT_VALID ) 1139cdf0e10cSrcweir { 1140cdf0e10cSrcweir _rDisplayName = aURL.getBase(INetURLObject::LAST_SEGMENT,true,INetURLObject::DECODE_WITH_CHARSET); 1141cdf0e10cSrcweir // _rDisplayName = aURL.getName(INetURLObject::LAST_SEGMENT,true,INetURLObject::DECODE_WITH_CHARSET); 1142cdf0e10cSrcweir _rUniqueId = aURL.GetMainURL( INetURLObject::NO_DECODE ); 1143cdf0e10cSrcweir return true; 1144cdf0e10cSrcweir } 1145cdf0e10cSrcweir _rDisplayName = _rDS; 1146cdf0e10cSrcweir _rUniqueId = String(); 1147cdf0e10cSrcweir return false; 1148cdf0e10cSrcweir } 1149cdf0e10cSrcweir 1150cdf0e10cSrcweir // ..................................................................... 1151cdf0e10cSrcweir struct FilterByEntryDataId : public IEntryFilter 1152cdf0e10cSrcweir { 1153cdf0e10cSrcweir String sId; 1154cdf0e10cSrcweir FilterByEntryDataId( const String& _rId ) : sId( _rId ) { } 1155cdf0e10cSrcweir 1156cdf0e10cSrcweir virtual ~FilterByEntryDataId() {} 1157cdf0e10cSrcweir 1158cdf0e10cSrcweir virtual bool includeEntry( SvLBoxEntry* _pEntry ) const; 1159cdf0e10cSrcweir }; 1160cdf0e10cSrcweir 1161cdf0e10cSrcweir bool FilterByEntryDataId::includeEntry( SvLBoxEntry* _pEntry ) const 1162cdf0e10cSrcweir { 1163cdf0e10cSrcweir DBTreeListUserData* pData = static_cast< DBTreeListUserData* >( _pEntry->GetUserData() ); 1164cdf0e10cSrcweir return ( !pData || ( pData->sAccessor == sId ) ); 1165cdf0e10cSrcweir } 1166cdf0e10cSrcweir } 1167cdf0e10cSrcweir 1168cdf0e10cSrcweir // ------------------------------------------------------------------------- 1169cdf0e10cSrcweir String SbaTableQueryBrowser::getDataSourceAcessor( SvLBoxEntry* _pDataSourceEntry ) const 1170cdf0e10cSrcweir { 1171cdf0e10cSrcweir DBG_ASSERT( _pDataSourceEntry, "SbaTableQueryBrowser::getDataSourceAcessor: invalid entry!" ); 1172cdf0e10cSrcweir 1173cdf0e10cSrcweir DBTreeListUserData* pData = static_cast< DBTreeListUserData* >( _pDataSourceEntry->GetUserData() ); 1174cdf0e10cSrcweir DBG_ASSERT( pData, "SbaTableQueryBrowser::getDataSourceAcessor: invalid entry data!" ); 1175cdf0e10cSrcweir DBG_ASSERT( pData->eType == etDatasource, "SbaTableQueryBrowser::getDataSourceAcessor: entry does not denote a data source!" ); 1176cdf0e10cSrcweir return pData->sAccessor.Len() ? pData->sAccessor : GetEntryText( _pDataSourceEntry ); 1177cdf0e10cSrcweir } 1178cdf0e10cSrcweir 1179cdf0e10cSrcweir // ------------------------------------------------------------------------- 1180cdf0e10cSrcweir SvLBoxEntry* SbaTableQueryBrowser::getObjectEntry(const ::rtl::OUString& _rDataSource, const ::rtl::OUString& _rCommand, sal_Int32 _nCommandType, 1181cdf0e10cSrcweir SvLBoxEntry** _ppDataSourceEntry, SvLBoxEntry** _ppContainerEntry, sal_Bool _bExpandAncestors, 1182cdf0e10cSrcweir const SharedConnection& _rxConnection ) 1183cdf0e10cSrcweir { 1184cdf0e10cSrcweir if (_ppDataSourceEntry) 1185cdf0e10cSrcweir *_ppDataSourceEntry = NULL; 1186cdf0e10cSrcweir if (_ppContainerEntry) 1187cdf0e10cSrcweir *_ppContainerEntry = NULL; 1188cdf0e10cSrcweir 1189cdf0e10cSrcweir SvLBoxEntry* pObject = NULL; 1190cdf0e10cSrcweir if ( m_pTreeView ) 1191cdf0e10cSrcweir { 1192cdf0e10cSrcweir // look for the data source entry 1193cdf0e10cSrcweir String sDisplayName, sDataSourceId; 1194cdf0e10cSrcweir bool bIsDataSourceURL = getDataSourceDisplayName_isURL( _rDataSource, sDisplayName, sDataSourceId ); 1195cdf0e10cSrcweir // the display name may differ from the URL for readability reasons 1196cdf0e10cSrcweir // #i33699# - 2004-09-24 - fs@openoffice.org 1197cdf0e10cSrcweir 1198cdf0e10cSrcweir FilterByEntryDataId aFilter( sDataSourceId ); 1199cdf0e10cSrcweir SvLBoxEntry* pDataSource = m_pTreeView->getListBox().GetEntryPosByName( sDisplayName, NULL, &aFilter ); 1200cdf0e10cSrcweir if ( !pDataSource ) // check if the data source name is a file location 1201cdf0e10cSrcweir { 1202cdf0e10cSrcweir if ( bIsDataSourceURL ) 1203cdf0e10cSrcweir { 1204cdf0e10cSrcweir // special case, the data source is a URL 1205cdf0e10cSrcweir // add new entries to the list box model 1206cdf0e10cSrcweir implAddDatasource( _rDataSource, _rxConnection ); 1207cdf0e10cSrcweir pDataSource = m_pTreeView->getListBox().GetEntryPosByName( sDisplayName, NULL, &aFilter ); 1208cdf0e10cSrcweir DBG_ASSERT( pDataSource, "SbaTableQueryBrowser::getObjectEntry: hmm - did not find it again!" ); 1209cdf0e10cSrcweir } 1210cdf0e10cSrcweir } 1211cdf0e10cSrcweir if (_ppDataSourceEntry) 1212cdf0e10cSrcweir // (caller wants to have it ...) 1213cdf0e10cSrcweir *_ppDataSourceEntry = pDataSource; 1214cdf0e10cSrcweir 1215cdf0e10cSrcweir if (pDataSource) 1216cdf0e10cSrcweir { 1217cdf0e10cSrcweir // expand if required so 1218cdf0e10cSrcweir if (_bExpandAncestors) 1219cdf0e10cSrcweir m_pTreeView->getListBox().Expand(pDataSource); 1220cdf0e10cSrcweir 1221cdf0e10cSrcweir // look for the object container 1222cdf0e10cSrcweir SvLBoxEntry* pCommandType = NULL; 1223cdf0e10cSrcweir switch (_nCommandType) 1224cdf0e10cSrcweir { 1225cdf0e10cSrcweir case CommandType::TABLE: 1226cdf0e10cSrcweir pCommandType = m_pTreeView->getListBox().GetModel()->GetEntry(pDataSource, CONTAINER_TABLES); 1227cdf0e10cSrcweir break; 1228cdf0e10cSrcweir 1229cdf0e10cSrcweir case CommandType::QUERY: 1230cdf0e10cSrcweir pCommandType = m_pTreeView->getListBox().GetModel()->GetEntry(pDataSource, CONTAINER_QUERIES); 1231cdf0e10cSrcweir break; 1232cdf0e10cSrcweir } 1233cdf0e10cSrcweir 1234cdf0e10cSrcweir if (_ppContainerEntry) 1235cdf0e10cSrcweir *_ppContainerEntry = pCommandType; 1236cdf0e10cSrcweir 1237cdf0e10cSrcweir if (pCommandType) 1238cdf0e10cSrcweir { 1239cdf0e10cSrcweir // expand if required so 1240cdf0e10cSrcweir if (_bExpandAncestors) 1241cdf0e10cSrcweir { 1242cdf0e10cSrcweir m_pTreeView->getListBox().Expand(pCommandType); 1243cdf0e10cSrcweir } 1244cdf0e10cSrcweir 1245cdf0e10cSrcweir // look for the object 1246cdf0e10cSrcweir ::rtl::OUString sCommand = _rCommand; 1247cdf0e10cSrcweir sal_Int32 nIndex = 0; 1248cdf0e10cSrcweir do 1249cdf0e10cSrcweir { 1250cdf0e10cSrcweir ::rtl::OUString sPath = sCommand.getToken( 0, '/', nIndex ); 1251cdf0e10cSrcweir pObject = m_pTreeView->getListBox().GetEntryPosByName(sPath, pCommandType); 1252cdf0e10cSrcweir pCommandType = pObject; 1253cdf0e10cSrcweir if ( nIndex >= 0 ) 1254cdf0e10cSrcweir { 1255cdf0e10cSrcweir if (ensureEntryObject(pObject)) 1256cdf0e10cSrcweir { 1257cdf0e10cSrcweir DBTreeListUserData* pParentData = static_cast< DBTreeListUserData* >( pObject->GetUserData() ); 1258cdf0e10cSrcweir Reference< XNameAccess > xCollection( pParentData->xContainer, UNO_QUERY ); 1259cdf0e10cSrcweir sal_Int32 nIndex2 = nIndex; 1260cdf0e10cSrcweir sPath = sCommand.getToken( 0, '/', nIndex2 ); 1261cdf0e10cSrcweir try 1262cdf0e10cSrcweir { 1263cdf0e10cSrcweir if ( xCollection->hasByName(sPath) ) 1264cdf0e10cSrcweir { 1265cdf0e10cSrcweir if(!m_pTreeView->getListBox().GetEntryPosByName(sPath,pObject)) 1266cdf0e10cSrcweir { 1267cdf0e10cSrcweir Reference<XNameAccess> xChild(xCollection->getByName(sPath),UNO_QUERY); 1268cdf0e10cSrcweir DBTreeListUserData* pEntryData = new DBTreeListUserData; 1269cdf0e10cSrcweir pEntryData->eType = etQuery; 1270cdf0e10cSrcweir if ( xChild.is() ) 1271cdf0e10cSrcweir { 1272cdf0e10cSrcweir pEntryData->eType = etQueryContainer; 1273cdf0e10cSrcweir } 1274cdf0e10cSrcweir implAppendEntry( pObject, sPath, pEntryData, pEntryData->eType ); 1275cdf0e10cSrcweir } 1276cdf0e10cSrcweir } 1277cdf0e10cSrcweir } 1278cdf0e10cSrcweir catch(Exception&) 1279cdf0e10cSrcweir { 1280cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::populateTree: could not fill the tree"); 1281cdf0e10cSrcweir } 1282cdf0e10cSrcweir } 1283cdf0e10cSrcweir } 1284cdf0e10cSrcweir // m_pTreeView->getListBox().Expand(pCommandType); 1285cdf0e10cSrcweir } 1286cdf0e10cSrcweir while ( nIndex >= 0 ); 1287cdf0e10cSrcweir } 1288cdf0e10cSrcweir } 1289cdf0e10cSrcweir } 1290cdf0e10cSrcweir return pObject; 1291cdf0e10cSrcweir } 1292cdf0e10cSrcweir 1293cdf0e10cSrcweir // ------------------------------------------------------------------------- 1294cdf0e10cSrcweir SvLBoxEntry* SbaTableQueryBrowser::getObjectEntry(const ::svx::ODataAccessDescriptor& _rDescriptor, 1295cdf0e10cSrcweir SvLBoxEntry** _ppDataSourceEntry, SvLBoxEntry** _ppContainerEntry, 1296cdf0e10cSrcweir sal_Bool _bExpandAncestors) 1297cdf0e10cSrcweir { 1298cdf0e10cSrcweir // extract the props from the descriptor 1299cdf0e10cSrcweir ::rtl::OUString sDataSource; 1300cdf0e10cSrcweir ::rtl::OUString sCommand; 1301cdf0e10cSrcweir sal_Int32 nCommandType = CommandType::COMMAND; 1302cdf0e10cSrcweir sal_Bool bEscapeProcessing = sal_True; 1303cdf0e10cSrcweir extractDescriptorProps(_rDescriptor, sDataSource, sCommand, nCommandType, bEscapeProcessing); 1304cdf0e10cSrcweir 1305cdf0e10cSrcweir return getObjectEntry( sDataSource, sCommand, nCommandType, _ppDataSourceEntry, _ppContainerEntry, _bExpandAncestors, SharedConnection() ); 1306cdf0e10cSrcweir } 1307cdf0e10cSrcweir 1308cdf0e10cSrcweir // ------------------------------------------------------------------------- 1309cdf0e10cSrcweir void SbaTableQueryBrowser::connectExternalDispatches() 1310cdf0e10cSrcweir { 1311cdf0e10cSrcweir Reference< XDispatchProvider > xProvider( getFrame(), UNO_QUERY ); 1312cdf0e10cSrcweir DBG_ASSERT(xProvider.is(), "SbaTableQueryBrowser::connectExternalDispatches: no DispatchProvider !"); 1313cdf0e10cSrcweir if (xProvider.is()) 1314cdf0e10cSrcweir { 1315cdf0e10cSrcweir if ( m_aExternalFeatures.empty() ) 1316cdf0e10cSrcweir { 1317cdf0e10cSrcweir const sal_Char* pURLs[] = { 1318cdf0e10cSrcweir ".uno:DataSourceBrowser/DocumentDataSource", 1319cdf0e10cSrcweir ".uno:DataSourceBrowser/FormLetter", 1320cdf0e10cSrcweir ".uno:DataSourceBrowser/InsertColumns", 1321cdf0e10cSrcweir ".uno:DataSourceBrowser/InsertContent", 1322cdf0e10cSrcweir }; 1323cdf0e10cSrcweir const sal_uInt16 nIds[] = { 1324cdf0e10cSrcweir ID_BROWSER_DOCUMENT_DATASOURCE, 1325cdf0e10cSrcweir ID_BROWSER_FORMLETTER, 1326cdf0e10cSrcweir ID_BROWSER_INSERTCOLUMNS, 1327cdf0e10cSrcweir ID_BROWSER_INSERTCONTENT 1328cdf0e10cSrcweir }; 1329cdf0e10cSrcweir 1330cdf0e10cSrcweir for ( size_t i=0; i < sizeof( pURLs ) / sizeof( pURLs[0] ); ++i ) 1331cdf0e10cSrcweir { 1332cdf0e10cSrcweir URL aURL; 1333cdf0e10cSrcweir aURL.Complete = ::rtl::OUString::createFromAscii( pURLs[i] ); 1334cdf0e10cSrcweir if ( m_xUrlTransformer.is() ) 1335cdf0e10cSrcweir m_xUrlTransformer->parseStrict( aURL ); 1336cdf0e10cSrcweir m_aExternalFeatures[ nIds[ i ] ] = ExternalFeature( aURL ); 1337cdf0e10cSrcweir } 1338cdf0e10cSrcweir } 1339cdf0e10cSrcweir 1340cdf0e10cSrcweir for ( ExternalFeaturesMap::iterator feature = m_aExternalFeatures.begin(); 1341cdf0e10cSrcweir feature != m_aExternalFeatures.end(); 1342cdf0e10cSrcweir ++feature 1343cdf0e10cSrcweir ) 1344cdf0e10cSrcweir { 1345cdf0e10cSrcweir feature->second.xDispatcher = xProvider->queryDispatch( 1346cdf0e10cSrcweir feature->second.aURL, ::rtl::OUString::createFromAscii("_parent"), FrameSearchFlag::PARENT 1347cdf0e10cSrcweir ); 1348cdf0e10cSrcweir 1349cdf0e10cSrcweir if ( feature->second.xDispatcher.get() == static_cast< XDispatch* >( this ) ) 1350cdf0e10cSrcweir { 1351cdf0e10cSrcweir OSL_ENSURE( sal_False, "SbaTableQueryBrowser::connectExternalDispatches: this should not happen anymore!" ); 1352cdf0e10cSrcweir // (nowadays, the URLs aren't in our SupportedFeatures list anymore, so we should 1353cdf0e10cSrcweir // not supply a dispatcher for this) 1354cdf0e10cSrcweir feature->second.xDispatcher.clear(); 1355cdf0e10cSrcweir } 1356cdf0e10cSrcweir 1357cdf0e10cSrcweir if ( feature->second.xDispatcher.is() ) 1358cdf0e10cSrcweir { 1359cdf0e10cSrcweir try 1360cdf0e10cSrcweir { 1361cdf0e10cSrcweir feature->second.xDispatcher->addStatusListener( this, feature->second.aURL ); 1362cdf0e10cSrcweir } 1363cdf0e10cSrcweir catch( const Exception& ) 1364cdf0e10cSrcweir { 1365cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 1366cdf0e10cSrcweir } 1367cdf0e10cSrcweir } 1368cdf0e10cSrcweir 1369cdf0e10cSrcweir implCheckExternalSlot( feature->first ); 1370cdf0e10cSrcweir } 1371cdf0e10cSrcweir } 1372cdf0e10cSrcweir } 1373cdf0e10cSrcweir 1374cdf0e10cSrcweir // ------------------------------------------------------------------------- 1375cdf0e10cSrcweir void SbaTableQueryBrowser::implCheckExternalSlot( sal_uInt16 _nId ) 1376cdf0e10cSrcweir { 1377cdf0e10cSrcweir if ( !m_xMainToolbar.is() ) 1378cdf0e10cSrcweir return; 1379cdf0e10cSrcweir 1380cdf0e10cSrcweir Window* pToolboxWindow = VCLUnoHelper::GetWindow( m_xMainToolbar ); 1381cdf0e10cSrcweir ToolBox* pToolbox = dynamic_cast< ToolBox* >( pToolboxWindow ); 1382cdf0e10cSrcweir OSL_ENSURE( pToolbox, "SbaTableQueryBrowser::implCheckExternalSlot: cannot obtain the toolbox window!" ); 1383cdf0e10cSrcweir 1384cdf0e10cSrcweir // check if we have to hide this item from the toolbox 1385cdf0e10cSrcweir if ( pToolbox ) 1386cdf0e10cSrcweir { 1387cdf0e10cSrcweir sal_Bool bHaveDispatcher = m_aExternalFeatures[ _nId ].xDispatcher.is(); 1388cdf0e10cSrcweir if ( bHaveDispatcher != pToolbox->IsItemVisible( _nId ) ) 1389cdf0e10cSrcweir bHaveDispatcher ? pToolbox->ShowItem( _nId ) : pToolbox->HideItem( _nId ); 1390cdf0e10cSrcweir } 1391cdf0e10cSrcweir 1392cdf0e10cSrcweir // and invalidate this feature in general 1393cdf0e10cSrcweir InvalidateFeature( _nId ); 1394cdf0e10cSrcweir } 1395cdf0e10cSrcweir 1396cdf0e10cSrcweir // ------------------------------------------------------------------------- 1397cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::disposing( const EventObject& _rSource ) throw(RuntimeException) 1398cdf0e10cSrcweir { 1399cdf0e10cSrcweir // our frame ? 1400cdf0e10cSrcweir Reference< ::com::sun::star::frame::XFrame > xSourceFrame(_rSource.Source, UNO_QUERY); 1401cdf0e10cSrcweir if (m_xCurrentFrameParent.is() && (xSourceFrame == m_xCurrentFrameParent)) 1402cdf0e10cSrcweir m_xCurrentFrameParent->removeFrameActionListener((::com::sun::star::frame::XFrameActionListener*)this); 1403cdf0e10cSrcweir else 1404cdf0e10cSrcweir { 1405cdf0e10cSrcweir // search the external dispatcher causing this call in our map 1406cdf0e10cSrcweir Reference< XDispatch > xSource(_rSource.Source, UNO_QUERY); 1407cdf0e10cSrcweir if(xSource.is()) 1408cdf0e10cSrcweir { 1409cdf0e10cSrcweir for ( ExternalFeaturesMap::iterator aLoop = m_aExternalFeatures.begin(); 1410cdf0e10cSrcweir aLoop != m_aExternalFeatures.end(); 1411cdf0e10cSrcweir ) 1412cdf0e10cSrcweir { 14137816784cSHerbert Dürr if ( aLoop->second.xDispatcher.get() != xSource.get() ) { 14147816784cSHerbert Dürr ++aLoop; 14157816784cSHerbert Dürr continue; 14167816784cSHerbert Dürr } 1417cdf0e10cSrcweir 14187816784cSHerbert Dürr // prepare to erase the aLoop iterator 14197816784cSHerbert Dürr const sal_uInt16 nSlotId = aLoop->first; 14207816784cSHerbert Dürr ExternalFeaturesMap::iterator aNext = aLoop; 14217816784cSHerbert Dürr ++aNext; 1422cdf0e10cSrcweir 14237816784cSHerbert Dürr // remove it 14247816784cSHerbert Dürr m_aExternalFeatures.erase( aLoop ); 1425cdf0e10cSrcweir 14267816784cSHerbert Dürr // maybe update the UI 14277816784cSHerbert Dürr implCheckExternalSlot( nSlotId ); 14287816784cSHerbert Dürr 14297816784cSHerbert Dürr // continue, the same XDispatch may be resposible for more than one URL 14307816784cSHerbert Dürr aLoop = aNext; 1431cdf0e10cSrcweir } 1432cdf0e10cSrcweir } 1433cdf0e10cSrcweir else 1434cdf0e10cSrcweir { 1435cdf0e10cSrcweir Reference<XConnection> xCon(_rSource.Source, UNO_QUERY); 1436cdf0e10cSrcweir if ( xCon.is() && m_pTreeView ) 1437cdf0e10cSrcweir { // our connection is in dispose so we have to find the entry equal with this connection 1438cdf0e10cSrcweir // and close it what means to collapse the entry 1439cdf0e10cSrcweir // get the top-level representing the removed data source 1440cdf0e10cSrcweir SvLBoxEntry* pDSLoop = m_pTreeView->getListBox().FirstChild(NULL); 1441cdf0e10cSrcweir while (pDSLoop) 1442cdf0e10cSrcweir { 1443cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(pDSLoop->GetUserData()); 1444cdf0e10cSrcweir if ( pData && pData->xConnection == xCon ) 1445cdf0e10cSrcweir { 1446cdf0e10cSrcweir // we set the conenction to null to avoid a second disposing of the connection 1447cdf0e10cSrcweir pData->xConnection.clear(); 1448cdf0e10cSrcweir closeConnection(pDSLoop,sal_False); 1449cdf0e10cSrcweir break; 1450cdf0e10cSrcweir } 1451cdf0e10cSrcweir 1452cdf0e10cSrcweir pDSLoop = m_pTreeView->getListBox().NextSibling(pDSLoop); 1453cdf0e10cSrcweir } 1454cdf0e10cSrcweir } 1455cdf0e10cSrcweir else 1456cdf0e10cSrcweir SbaXDataBrowserController::disposing(_rSource); 1457cdf0e10cSrcweir } 1458cdf0e10cSrcweir } 1459cdf0e10cSrcweir } 1460cdf0e10cSrcweir 1461cdf0e10cSrcweir // ------------------------------------------------------------------------- 1462cdf0e10cSrcweir void SbaTableQueryBrowser::implRemoveStatusListeners() 1463cdf0e10cSrcweir { 1464cdf0e10cSrcweir // clear all old dispatches 1465cdf0e10cSrcweir for ( ExternalFeaturesMap::const_iterator aLoop = m_aExternalFeatures.begin(); 1466cdf0e10cSrcweir aLoop != m_aExternalFeatures.end(); 1467cdf0e10cSrcweir ++aLoop 1468cdf0e10cSrcweir ) 1469cdf0e10cSrcweir { 1470cdf0e10cSrcweir if ( aLoop->second.xDispatcher.is() ) 1471cdf0e10cSrcweir { 1472cdf0e10cSrcweir try 1473cdf0e10cSrcweir { 1474cdf0e10cSrcweir aLoop->second.xDispatcher->removeStatusListener( this, aLoop->second.aURL ); 1475cdf0e10cSrcweir } 1476cdf0e10cSrcweir catch (Exception&) 1477cdf0e10cSrcweir { 1478cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::implRemoveStatusListeners: could not remove a status listener!"); 1479cdf0e10cSrcweir } 1480cdf0e10cSrcweir } 1481cdf0e10cSrcweir } 1482cdf0e10cSrcweir m_aExternalFeatures.clear(); 1483cdf0e10cSrcweir } 1484cdf0e10cSrcweir 1485cdf0e10cSrcweir // ------------------------------------------------------------------------- 1486cdf0e10cSrcweir sal_Bool SAL_CALL SbaTableQueryBrowser::select( const Any& _rSelection ) throw (IllegalArgumentException, RuntimeException) 1487cdf0e10cSrcweir { 1488cdf0e10cSrcweir ::vos::OGuard aGuard(Application::GetSolarMutex()); 1489cdf0e10cSrcweir // doin' a lot of VCL stuff here -> lock the SolarMutex 1490cdf0e10cSrcweir 1491cdf0e10cSrcweir Sequence< PropertyValue > aDescriptorSequence; 1492cdf0e10cSrcweir if (!(_rSelection >>= aDescriptorSequence)) 1493cdf0e10cSrcweir throw IllegalArgumentException(::rtl::OUString(), *this, 1); 1494cdf0e10cSrcweir // TODO: error message 1495cdf0e10cSrcweir 1496cdf0e10cSrcweir ODataAccessDescriptor aDescriptor; 1497cdf0e10cSrcweir try 1498cdf0e10cSrcweir { 1499cdf0e10cSrcweir aDescriptor = ODataAccessDescriptor(aDescriptorSequence); 1500cdf0e10cSrcweir } 1501cdf0e10cSrcweir catch(const Exception&) 1502cdf0e10cSrcweir { 1503cdf0e10cSrcweir OSL_ENSURE(sal_False, "SbaTableQueryBrowser::select: could not extract the descriptor!"); 1504cdf0e10cSrcweir } 1505cdf0e10cSrcweir 1506cdf0e10cSrcweir // check the precense of the props we need 1507cdf0e10cSrcweir if ( !(aDescriptor.has(daDataSource) || aDescriptor.has(daDatabaseLocation)) || !aDescriptor.has(daCommand) || !aDescriptor.has(daCommandType)) 1508cdf0e10cSrcweir throw IllegalArgumentException(::rtl::OUString(), *this, 1); 1509cdf0e10cSrcweir // TODO: error message 1510cdf0e10cSrcweir 1511cdf0e10cSrcweir return implSelect(aDescriptor,sal_True); 1512cdf0e10cSrcweir } 1513cdf0e10cSrcweir 1514cdf0e10cSrcweir // ------------------------------------------------------------------------- 1515cdf0e10cSrcweir Any SAL_CALL SbaTableQueryBrowser::getSelection( ) throw (RuntimeException) 1516cdf0e10cSrcweir { 1517cdf0e10cSrcweir Any aReturn; 1518cdf0e10cSrcweir 1519cdf0e10cSrcweir try 1520cdf0e10cSrcweir { 1521cdf0e10cSrcweir Reference< XLoadable > xLoadable(getRowSet(), UNO_QUERY); 1522cdf0e10cSrcweir if (xLoadable.is() && xLoadable->isLoaded()) 1523cdf0e10cSrcweir { 1524cdf0e10cSrcweir Reference< XPropertySet > aFormProps(getRowSet(), UNO_QUERY); 1525cdf0e10cSrcweir ODataAccessDescriptor aDescriptor(aFormProps); 1526cdf0e10cSrcweir // remove properties which are not part of our "selection" 1527cdf0e10cSrcweir aDescriptor.erase(daConnection); 1528cdf0e10cSrcweir aDescriptor.erase(daCursor); 1529cdf0e10cSrcweir 1530cdf0e10cSrcweir aReturn <<= aDescriptor.createPropertyValueSequence(); 1531cdf0e10cSrcweir } 1532cdf0e10cSrcweir } 1533cdf0e10cSrcweir catch( const Exception& ) 1534cdf0e10cSrcweir { 1535cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 1536cdf0e10cSrcweir } 1537cdf0e10cSrcweir 1538cdf0e10cSrcweir return aReturn; 1539cdf0e10cSrcweir } 1540cdf0e10cSrcweir 1541cdf0e10cSrcweir // ------------------------------------------------------------------------- 1542cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::addSelectionChangeListener( const Reference< XSelectionChangeListener >& _rxListener ) throw (RuntimeException) 1543cdf0e10cSrcweir { 1544cdf0e10cSrcweir m_aSelectionListeners.addInterface(_rxListener); 1545cdf0e10cSrcweir } 1546cdf0e10cSrcweir 1547cdf0e10cSrcweir // ------------------------------------------------------------------------- 1548cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::removeSelectionChangeListener( const Reference< XSelectionChangeListener >& _rxListener ) throw (RuntimeException) 1549cdf0e10cSrcweir { 1550cdf0e10cSrcweir m_aSelectionListeners.removeInterface(_rxListener); 1551cdf0e10cSrcweir } 1552cdf0e10cSrcweir 1553cdf0e10cSrcweir // ------------------------------------------------------------------------- 1554cdf0e10cSrcweir void SbaTableQueryBrowser::attachFrame(const Reference< ::com::sun::star::frame::XFrame > & _xFrame) throw( RuntimeException ) 1555cdf0e10cSrcweir { 1556cdf0e10cSrcweir implRemoveStatusListeners(); 1557cdf0e10cSrcweir 1558cdf0e10cSrcweir if (m_xCurrentFrameParent.is()) 1559cdf0e10cSrcweir m_xCurrentFrameParent->removeFrameActionListener((::com::sun::star::frame::XFrameActionListener*)this); 1560cdf0e10cSrcweir 1561cdf0e10cSrcweir SbaXDataBrowserController::attachFrame(_xFrame); 1562cdf0e10cSrcweir 1563cdf0e10cSrcweir Reference< XFrame > xCurrentFrame( getFrame() ); 1564cdf0e10cSrcweir if ( xCurrentFrame.is() ) 1565cdf0e10cSrcweir { 1566cdf0e10cSrcweir m_xCurrentFrameParent = xCurrentFrame->findFrame(::rtl::OUString::createFromAscii("_parent"),FrameSearchFlag::PARENT); 1567cdf0e10cSrcweir if ( m_xCurrentFrameParent.is() ) 1568cdf0e10cSrcweir m_xCurrentFrameParent->addFrameActionListener((::com::sun::star::frame::XFrameActionListener*)this); 1569cdf0e10cSrcweir 1570cdf0e10cSrcweir // obtain our toolbox 1571cdf0e10cSrcweir try 1572cdf0e10cSrcweir { 1573cdf0e10cSrcweir Reference< XPropertySet > xFrameProps( m_aCurrentFrame.getFrame(), UNO_QUERY_THROW ); 1574cdf0e10cSrcweir Reference< XLayoutManager > xLayouter( 1575cdf0e10cSrcweir xFrameProps->getPropertyValue( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "LayoutManager" ) ) ), 1576cdf0e10cSrcweir UNO_QUERY ); 1577cdf0e10cSrcweir 1578cdf0e10cSrcweir if ( xLayouter.is() ) 1579cdf0e10cSrcweir { 1580cdf0e10cSrcweir Reference< XUIElement > xUI( 1581cdf0e10cSrcweir xLayouter->getElement( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "private:resource/toolbar/toolbar" ) ) ), 1582cdf0e10cSrcweir UNO_SET_THROW ); 1583cdf0e10cSrcweir m_xMainToolbar = m_xMainToolbar.query( xUI->getRealInterface() ); 1584cdf0e10cSrcweir OSL_ENSURE( m_xMainToolbar.is(), "SbaTableQueryBrowser::attachFrame: where's my toolbox?" ); 1585cdf0e10cSrcweir } 1586cdf0e10cSrcweir } 1587cdf0e10cSrcweir catch( const Exception& ) 1588cdf0e10cSrcweir { 1589cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 1590cdf0e10cSrcweir } 1591cdf0e10cSrcweir } 1592cdf0e10cSrcweir 1593cdf0e10cSrcweir // get the dispatchers for the external slots 1594cdf0e10cSrcweir connectExternalDispatches(); 1595cdf0e10cSrcweir } 1596cdf0e10cSrcweir 1597cdf0e10cSrcweir // ------------------------------------------------------------------------- 1598cdf0e10cSrcweir void SbaTableQueryBrowser::addModelListeners(const Reference< ::com::sun::star::awt::XControlModel > & _xGridControlModel) 1599cdf0e10cSrcweir { 1600cdf0e10cSrcweir SbaXDataBrowserController::addModelListeners(_xGridControlModel); 1601cdf0e10cSrcweir Reference< XPropertySet > xSourceSet(_xGridControlModel, UNO_QUERY); 1602cdf0e10cSrcweir if (xSourceSet.is()) 1603cdf0e10cSrcweir { 1604cdf0e10cSrcweir xSourceSet->addPropertyChangeListener(PROPERTY_ROW_HEIGHT, static_cast<XPropertyChangeListener*>(this)); 1605cdf0e10cSrcweir xSourceSet->addPropertyChangeListener(PROPERTY_FONT, static_cast<XPropertyChangeListener*>(this)); 1606cdf0e10cSrcweir xSourceSet->addPropertyChangeListener(PROPERTY_TEXTCOLOR, static_cast<XPropertyChangeListener*>(this)); 1607cdf0e10cSrcweir xSourceSet->addPropertyChangeListener(PROPERTY_TEXTLINECOLOR, static_cast<XPropertyChangeListener*>(this)); 1608cdf0e10cSrcweir xSourceSet->addPropertyChangeListener(PROPERTY_TEXTEMPHASIS, static_cast<XPropertyChangeListener*>(this)); 1609cdf0e10cSrcweir xSourceSet->addPropertyChangeListener(PROPERTY_TEXTRELIEF, static_cast<XPropertyChangeListener*>(this)); 1610cdf0e10cSrcweir } 1611cdf0e10cSrcweir 1612cdf0e10cSrcweir } 1613cdf0e10cSrcweir 1614cdf0e10cSrcweir // ------------------------------------------------------------------------- 1615cdf0e10cSrcweir void SbaTableQueryBrowser::removeModelListeners(const Reference< ::com::sun::star::awt::XControlModel > & _xGridControlModel) 1616cdf0e10cSrcweir { 1617cdf0e10cSrcweir SbaXDataBrowserController::removeModelListeners(_xGridControlModel); 1618cdf0e10cSrcweir Reference< XPropertySet > xSourceSet(_xGridControlModel, UNO_QUERY); 1619cdf0e10cSrcweir if (xSourceSet.is()) 1620cdf0e10cSrcweir { 1621cdf0e10cSrcweir xSourceSet->removePropertyChangeListener(PROPERTY_ROW_HEIGHT, static_cast<XPropertyChangeListener*>(this)); 1622cdf0e10cSrcweir xSourceSet->removePropertyChangeListener(PROPERTY_FONT, static_cast<XPropertyChangeListener*>(this)); 1623cdf0e10cSrcweir xSourceSet->removePropertyChangeListener(PROPERTY_TEXTCOLOR, static_cast<XPropertyChangeListener*>(this)); 1624cdf0e10cSrcweir xSourceSet->removePropertyChangeListener(PROPERTY_TEXTLINECOLOR, static_cast<XPropertyChangeListener*>(this)); 1625cdf0e10cSrcweir xSourceSet->removePropertyChangeListener(PROPERTY_TEXTEMPHASIS, static_cast<XPropertyChangeListener*>(this)); 1626cdf0e10cSrcweir xSourceSet->removePropertyChangeListener(PROPERTY_TEXTRELIEF, static_cast<XPropertyChangeListener*>(this)); 1627cdf0e10cSrcweir } 1628cdf0e10cSrcweir } 1629cdf0e10cSrcweir // ------------------------------------------------------------------------- 1630cdf0e10cSrcweir void SbaTableQueryBrowser::RowChanged() 1631cdf0e10cSrcweir { 1632cdf0e10cSrcweir if(getBrowserView()) 1633cdf0e10cSrcweir { 1634cdf0e10cSrcweir SbaGridControl* pControl = getBrowserView()->getVclControl(); 1635cdf0e10cSrcweir if (!pControl->IsEditing()) 1636cdf0e10cSrcweir InvalidateFeature(ID_BROWSER_COPY); 1637cdf0e10cSrcweir } 1638cdf0e10cSrcweir SbaXDataBrowserController::RowChanged(); 1639cdf0e10cSrcweir } 1640cdf0e10cSrcweir 1641cdf0e10cSrcweir // ------------------------------------------------------------------------- 1642cdf0e10cSrcweir void SbaTableQueryBrowser::ColumnChanged() 1643cdf0e10cSrcweir { 1644cdf0e10cSrcweir if(getBrowserView()) 1645cdf0e10cSrcweir { 1646cdf0e10cSrcweir SbaGridControl* pControl = getBrowserView()->getVclControl(); 1647cdf0e10cSrcweir if (!pControl->IsEditing()) 1648cdf0e10cSrcweir InvalidateFeature(ID_BROWSER_COPY); 1649cdf0e10cSrcweir } 1650cdf0e10cSrcweir SbaXDataBrowserController::ColumnChanged(); 1651cdf0e10cSrcweir } 1652cdf0e10cSrcweir //------------------------------------------------------------------------------ 1653cdf0e10cSrcweir void SbaTableQueryBrowser::AddColumnListener(const Reference< XPropertySet > & xCol) 1654cdf0e10cSrcweir { 1655cdf0e10cSrcweir SbaXDataBrowserController::AddColumnListener(xCol); 1656cdf0e10cSrcweir SafeAddPropertyListener(xCol, PROPERTY_WIDTH, static_cast<XPropertyChangeListener*>(this)); 1657cdf0e10cSrcweir SafeAddPropertyListener(xCol, PROPERTY_HIDDEN, static_cast<XPropertyChangeListener*>(this)); 1658cdf0e10cSrcweir SafeAddPropertyListener(xCol, PROPERTY_ALIGN, static_cast<XPropertyChangeListener*>(this)); 1659cdf0e10cSrcweir SafeAddPropertyListener(xCol, PROPERTY_FORMATKEY, static_cast<XPropertyChangeListener*>(this)); 1660cdf0e10cSrcweir } 1661cdf0e10cSrcweir 1662cdf0e10cSrcweir //------------------------------------------------------------------------------ 1663cdf0e10cSrcweir void SbaTableQueryBrowser::RemoveColumnListener(const Reference< XPropertySet > & xCol) 1664cdf0e10cSrcweir { 1665cdf0e10cSrcweir SbaXDataBrowserController::RemoveColumnListener(xCol); 1666cdf0e10cSrcweir SafeRemovePropertyListener(xCol, PROPERTY_WIDTH, static_cast<XPropertyChangeListener*>(this)); 1667cdf0e10cSrcweir SafeRemovePropertyListener(xCol, PROPERTY_HIDDEN, static_cast<XPropertyChangeListener*>(this)); 1668cdf0e10cSrcweir SafeRemovePropertyListener(xCol, PROPERTY_ALIGN, static_cast<XPropertyChangeListener*>(this)); 1669cdf0e10cSrcweir SafeRemovePropertyListener(xCol, PROPERTY_FORMATKEY, static_cast<XPropertyChangeListener*>(this)); 1670cdf0e10cSrcweir } 1671cdf0e10cSrcweir 1672cdf0e10cSrcweir //------------------------------------------------------------------------------ 1673cdf0e10cSrcweir void SbaTableQueryBrowser::criticalFail() 1674cdf0e10cSrcweir { 1675cdf0e10cSrcweir SbaXDataBrowserController::criticalFail(); 1676cdf0e10cSrcweir unloadAndCleanup( sal_False ); 1677cdf0e10cSrcweir } 1678cdf0e10cSrcweir 1679cdf0e10cSrcweir //------------------------------------------------------------------------------ 1680cdf0e10cSrcweir void SbaTableQueryBrowser::LoadFinished(sal_Bool _bWasSynch) 1681cdf0e10cSrcweir { 1682cdf0e10cSrcweir SbaXDataBrowserController::LoadFinished(_bWasSynch); 1683cdf0e10cSrcweir 1684cdf0e10cSrcweir m_sQueryCommand = ::rtl::OUString(); 1685cdf0e10cSrcweir m_bQueryEscapeProcessing = sal_False; 1686cdf0e10cSrcweir 1687cdf0e10cSrcweir if (isValid() && !loadingCancelled()) 1688cdf0e10cSrcweir { 1689cdf0e10cSrcweir // did we load a query? 1690cdf0e10cSrcweir sal_Bool bTemporary; // needed because we m_bQueryEscapeProcessing is only one bit wide (and we want to pass it by reference) 1691cdf0e10cSrcweir if ( implGetQuerySignature( m_sQueryCommand, bTemporary ) ) 1692cdf0e10cSrcweir m_bQueryEscapeProcessing = bTemporary; 1693cdf0e10cSrcweir } 1694cdf0e10cSrcweir 1695cdf0e10cSrcweir // if the form has been loaded, this means that our "selection" has changed 1696cdf0e10cSrcweir EventObject aEvent( *this ); 1697cdf0e10cSrcweir m_aSelectionListeners.notifyEach( &XSelectionChangeListener::selectionChanged, aEvent ); 1698cdf0e10cSrcweir } 1699cdf0e10cSrcweir 1700cdf0e10cSrcweir //------------------------------------------------------------------------------ 1701cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::getExternalSlotState( sal_uInt16 _nId ) const 1702cdf0e10cSrcweir { 1703cdf0e10cSrcweir sal_Bool bEnabled = sal_False; 1704cdf0e10cSrcweir ExternalFeaturesMap::const_iterator aPos = m_aExternalFeatures.find( _nId ); 1705cdf0e10cSrcweir if ( ( m_aExternalFeatures.end() != aPos ) && aPos->second.xDispatcher.is() ) 1706cdf0e10cSrcweir bEnabled = aPos->second.bEnabled; 1707cdf0e10cSrcweir return bEnabled; 1708cdf0e10cSrcweir } 1709cdf0e10cSrcweir 1710cdf0e10cSrcweir //------------------------------------------------------------------------------ 1711cdf0e10cSrcweir FeatureState SbaTableQueryBrowser::GetState(sal_uInt16 nId) const 1712cdf0e10cSrcweir { 1713cdf0e10cSrcweir FeatureState aReturn; 1714cdf0e10cSrcweir // (disabled automatically) 1715cdf0e10cSrcweir 1716cdf0e10cSrcweir // no chance without a view 1717cdf0e10cSrcweir if (!getBrowserView() || !getBrowserView()->getVclControl()) 1718cdf0e10cSrcweir return aReturn; 1719cdf0e10cSrcweir 1720cdf0e10cSrcweir switch ( nId ) 1721cdf0e10cSrcweir { 1722cdf0e10cSrcweir case ID_TREE_ADMINISTRATE: 1723cdf0e10cSrcweir aReturn.bEnabled = true; 1724cdf0e10cSrcweir return aReturn; 1725cdf0e10cSrcweir 1726cdf0e10cSrcweir case ID_BROWSER_CLOSE: 1727cdf0e10cSrcweir // the close button should always be enabled 1728cdf0e10cSrcweir aReturn.bEnabled = !m_bEnableBrowser; 1729cdf0e10cSrcweir return aReturn; 1730cdf0e10cSrcweir 1731cdf0e10cSrcweir // "toggle explorer" is always enabled (if we have a explorer) 1732cdf0e10cSrcweir case ID_BROWSER_EXPLORER: 1733cdf0e10cSrcweir aReturn.bEnabled = m_bEnableBrowser; 1734cdf0e10cSrcweir aReturn.bChecked = haveExplorer(); 1735cdf0e10cSrcweir return aReturn; 1736cdf0e10cSrcweir 1737cdf0e10cSrcweir case ID_BROWSER_REMOVEFILTER: 1738cdf0e10cSrcweir return SbaXDataBrowserController::GetState( nId ); 1739cdf0e10cSrcweir 1740cdf0e10cSrcweir case ID_BROWSER_COPY: 1741cdf0e10cSrcweir if ( !m_pTreeView->HasChildPathFocus() ) 1742cdf0e10cSrcweir // handled below 1743cdf0e10cSrcweir break; 1744cdf0e10cSrcweir // NO break! 1745cdf0e10cSrcweir case ID_TREE_CLOSE_CONN: 1746cdf0e10cSrcweir case ID_TREE_EDIT_DATABASE: 1747cdf0e10cSrcweir { 1748cdf0e10cSrcweir SvLBoxEntry* pCurrentEntry( m_pTreeView->getListBox().GetCurEntry() ); 1749cdf0e10cSrcweir EntryType eType = getEntryType( pCurrentEntry ); 1750cdf0e10cSrcweir if ( eType == etUnknown ) 1751cdf0e10cSrcweir return aReturn; 1752cdf0e10cSrcweir 1753cdf0e10cSrcweir SvLBoxEntry* pDataSourceEntry = m_pTreeView->getListBox().GetRootLevelParent( pCurrentEntry ); 1754cdf0e10cSrcweir DBTreeListUserData* pDSData 1755cdf0e10cSrcweir = pDataSourceEntry 1756cdf0e10cSrcweir ? static_cast< DBTreeListUserData* >( pDataSourceEntry->GetUserData() ) 1757cdf0e10cSrcweir : NULL; 1758cdf0e10cSrcweir 1759cdf0e10cSrcweir if ( nId == ID_TREE_CLOSE_CONN ) 1760cdf0e10cSrcweir { 1761cdf0e10cSrcweir aReturn.bEnabled = ( pDSData != NULL ) && pDSData->xConnection.is(); 1762cdf0e10cSrcweir } 1763cdf0e10cSrcweir else if ( nId == ID_TREE_EDIT_DATABASE ) 1764cdf0e10cSrcweir { 1765cdf0e10cSrcweir ::utl::OConfigurationTreeRoot aConfig( ::utl::OConfigurationTreeRoot::createWithServiceFactory( getORB(), 1766cdf0e10cSrcweir ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "/org.openoffice.Office.DataAccess/Policies/Features/Common" ) ) ) ); 1767cdf0e10cSrcweir sal_Bool bHaveEditDatabase( sal_True ); 1768cdf0e10cSrcweir OSL_VERIFY( aConfig.getNodeValue( "EditDatabaseFromDataSourceView" ) >>= bHaveEditDatabase ); 1769cdf0e10cSrcweir aReturn.bEnabled = getORB().is() && ( pDataSourceEntry != NULL ) && bHaveEditDatabase; 1770cdf0e10cSrcweir } 1771cdf0e10cSrcweir else if ( nId == ID_BROWSER_COPY ) 1772cdf0e10cSrcweir { 1773cdf0e10cSrcweir aReturn.bEnabled = isEntryCopyAllowed( pCurrentEntry ); 1774cdf0e10cSrcweir } 1775cdf0e10cSrcweir 1776cdf0e10cSrcweir return aReturn; 1777cdf0e10cSrcweir } 1778cdf0e10cSrcweir } 1779cdf0e10cSrcweir 1780cdf0e10cSrcweir // all slots not handled above are not available if no form is loaded 1781cdf0e10cSrcweir if (!isLoaded()) 1782cdf0e10cSrcweir return aReturn; 1783cdf0e10cSrcweir 1784cdf0e10cSrcweir try 1785cdf0e10cSrcweir { 1786cdf0e10cSrcweir sal_Bool bHandled = sal_False; 1787cdf0e10cSrcweir switch (nId) 1788cdf0e10cSrcweir { 1789cdf0e10cSrcweir case ID_BROWSER_DOCUMENT_DATASOURCE: 1790cdf0e10cSrcweir // the slot is enabled if we have an external dispatcher able to handle it, 1791cdf0e10cSrcweir // and the dispatcher must have enabled the slot in general 1792cdf0e10cSrcweir aReturn.bEnabled = getExternalSlotState( ID_BROWSER_DOCUMENT_DATASOURCE ); 1793cdf0e10cSrcweir bHandled = sal_True; 1794cdf0e10cSrcweir break; 1795cdf0e10cSrcweir case ID_BROWSER_REFRESH: 1796cdf0e10cSrcweir aReturn.bEnabled = sal_True; 1797cdf0e10cSrcweir bHandled = sal_True; 1798cdf0e10cSrcweir break; 1799cdf0e10cSrcweir } 1800cdf0e10cSrcweir 1801cdf0e10cSrcweir if (bHandled) 1802cdf0e10cSrcweir return aReturn; 1803cdf0e10cSrcweir 1804cdf0e10cSrcweir // no chance without valid models 1805cdf0e10cSrcweir if (isValid() && !isValidCursor() && nId != ID_BROWSER_CLOSE) 1806cdf0e10cSrcweir return aReturn; 1807cdf0e10cSrcweir 1808cdf0e10cSrcweir switch (nId) 1809cdf0e10cSrcweir { 1810cdf0e10cSrcweir case ID_BROWSER_INSERTCOLUMNS: 1811cdf0e10cSrcweir case ID_BROWSER_INSERTCONTENT: 1812cdf0e10cSrcweir case ID_BROWSER_FORMLETTER: 1813cdf0e10cSrcweir { 1814cdf0e10cSrcweir // the slot is enabled if we have an external dispatcher able to handle it, 1815cdf0e10cSrcweir // and the dispatcher must have enabled the slot in general 1816cdf0e10cSrcweir aReturn.bEnabled = getExternalSlotState( nId ); 1817cdf0e10cSrcweir 1818cdf0e10cSrcweir // for the Insert* slots, we need at least one selected row 1819cdf0e10cSrcweir if (ID_BROWSER_FORMLETTER != nId) 1820cdf0e10cSrcweir aReturn.bEnabled = aReturn.bEnabled && getBrowserView()->getVclControl()->GetSelectRowCount(); 1821cdf0e10cSrcweir 1822cdf0e10cSrcweir // disabled for native queries which are not saved within the database 1823cdf0e10cSrcweir // 67706 - 23.08.99 - FS 1824cdf0e10cSrcweir Reference< XPropertySet > xDataSource(getRowSet(), UNO_QUERY); 1825cdf0e10cSrcweir try 1826cdf0e10cSrcweir { 1827cdf0e10cSrcweir aReturn.bEnabled = aReturn.bEnabled && xDataSource.is(); 1828cdf0e10cSrcweir 1829cdf0e10cSrcweir if (xDataSource.is()) 1830cdf0e10cSrcweir { 1831cdf0e10cSrcweir sal_Int32 nType = ::comphelper::getINT32(xDataSource->getPropertyValue(PROPERTY_COMMAND_TYPE)); 1832cdf0e10cSrcweir aReturn.bEnabled = aReturn.bEnabled && ((::comphelper::getBOOL(xDataSource->getPropertyValue(PROPERTY_ESCAPE_PROCESSING)) || (nType == ::com::sun::star::sdb::CommandType::QUERY))); 1833cdf0e10cSrcweir } 1834cdf0e10cSrcweir } 1835cdf0e10cSrcweir catch(DisposedException&) 1836cdf0e10cSrcweir { 1837cdf0e10cSrcweir OSL_ENSURE(sal_False, "SbaTableQueryBrowser::GetState: object already disposed!"); 1838cdf0e10cSrcweir } 1839cdf0e10cSrcweir catch( const Exception& ) 1840cdf0e10cSrcweir { 1841cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 1842cdf0e10cSrcweir } 1843cdf0e10cSrcweir } 1844cdf0e10cSrcweir break; 1845cdf0e10cSrcweir 1846cdf0e10cSrcweir case ID_BROWSER_TITLE: 1847cdf0e10cSrcweir { 1848cdf0e10cSrcweir Reference<XPropertySet> xProp(getRowSet(),UNO_QUERY); 1849cdf0e10cSrcweir sal_Int32 nCommandType = CommandType::TABLE; 1850cdf0e10cSrcweir xProp->getPropertyValue(PROPERTY_COMMAND_TYPE) >>= nCommandType; 1851cdf0e10cSrcweir String sTitle; 1852cdf0e10cSrcweir switch (nCommandType) 1853cdf0e10cSrcweir { 1854cdf0e10cSrcweir case CommandType::TABLE: 1855cdf0e10cSrcweir sTitle = String(ModuleRes(STR_TBL_TITLE)); break; 1856cdf0e10cSrcweir case CommandType::QUERY: 1857cdf0e10cSrcweir case CommandType::COMMAND: 1858cdf0e10cSrcweir sTitle = String(ModuleRes(STR_QRY_TITLE)); break; 1859cdf0e10cSrcweir default: 1860cdf0e10cSrcweir DBG_ASSERT(sal_False, "SbaTableQueryBrowser::GetState: unknown command type!"); 1861cdf0e10cSrcweir } 1862cdf0e10cSrcweir ::rtl::OUString aName; 1863cdf0e10cSrcweir xProp->getPropertyValue(PROPERTY_COMMAND) >>= aName; 1864cdf0e10cSrcweir String sObject(aName.getStr()); 1865cdf0e10cSrcweir 1866cdf0e10cSrcweir sTitle.SearchAndReplace('#',sObject); 1867cdf0e10cSrcweir aReturn.sTitle = sTitle; 1868cdf0e10cSrcweir aReturn.bEnabled = sal_True; 1869cdf0e10cSrcweir } 1870cdf0e10cSrcweir break; 1871cdf0e10cSrcweir case ID_BROWSER_TABLEATTR: 1872cdf0e10cSrcweir case ID_BROWSER_ROWHEIGHT: 1873cdf0e10cSrcweir case ID_BROWSER_COLATTRSET: 1874cdf0e10cSrcweir case ID_BROWSER_COLWIDTH: 1875cdf0e10cSrcweir aReturn.bEnabled = getBrowserView() && getBrowserView()->getVclControl() && isValid() && isValidCursor(); 1876cdf0e10cSrcweir // aReturn.bEnabled &= getDefinition() && !getDefinition()->GetDatabase()->IsReadOnly(); 1877cdf0e10cSrcweir break; 1878cdf0e10cSrcweir 1879cdf0e10cSrcweir case ID_BROWSER_COPY: 1880cdf0e10cSrcweir OSL_ENSURE( !m_pTreeView->HasChildPathFocus(), "SbaTableQueryBrowser::GetState( ID_BROWSER_COPY ): this should have been handled above!" ); 1881cdf0e10cSrcweir if (getBrowserView() && getBrowserView()->getVclControl() && !getBrowserView()->getVclControl()->IsEditing()) 1882cdf0e10cSrcweir { 1883cdf0e10cSrcweir SbaGridControl* pControl = getBrowserView()->getVclControl(); 1884cdf0e10cSrcweir if ( pControl->GetSelectRowCount() ) 1885cdf0e10cSrcweir { 1886cdf0e10cSrcweir aReturn.bEnabled = m_aCurrentFrame.isActive(); 1887cdf0e10cSrcweir break; 1888cdf0e10cSrcweir } // if ( getBrowserView()->getVclControl()->GetSelectRowCount() ) 1889cdf0e10cSrcweir else 1890cdf0e10cSrcweir aReturn.bEnabled = pControl->canCopyCellText(pControl->GetCurRow(), pControl->GetCurColumnId()); 1891cdf0e10cSrcweir break; 1892cdf0e10cSrcweir } 1893cdf0e10cSrcweir // NO break here 1894cdf0e10cSrcweir default: 1895cdf0e10cSrcweir return SbaXDataBrowserController::GetState(nId); 1896cdf0e10cSrcweir } 1897cdf0e10cSrcweir } 1898cdf0e10cSrcweir catch(const Exception&) 1899cdf0e10cSrcweir { 1900cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 1901cdf0e10cSrcweir } 1902cdf0e10cSrcweir 1903cdf0e10cSrcweir return aReturn; 1904cdf0e10cSrcweir 1905cdf0e10cSrcweir } 1906cdf0e10cSrcweir 1907cdf0e10cSrcweir //------------------------------------------------------------------------------ 1908cdf0e10cSrcweir void SbaTableQueryBrowser::Execute(sal_uInt16 nId, const Sequence< PropertyValue >& aArgs) 1909cdf0e10cSrcweir { 1910cdf0e10cSrcweir switch (nId) 1911cdf0e10cSrcweir { 1912cdf0e10cSrcweir default: 1913cdf0e10cSrcweir SbaXDataBrowserController::Execute(nId,aArgs); 1914cdf0e10cSrcweir break; 1915cdf0e10cSrcweir 1916cdf0e10cSrcweir case ID_TREE_EDIT_DATABASE: 1917cdf0e10cSrcweir implAdministrate( m_pTreeView->getListBox().GetCurEntry() ); 1918cdf0e10cSrcweir break; 1919cdf0e10cSrcweir 1920cdf0e10cSrcweir case ID_TREE_CLOSE_CONN: 1921cdf0e10cSrcweir openHelpAgent( HID_DSBROWSER_DISCONNECTING ); 1922cdf0e10cSrcweir closeConnection( m_pTreeView->getListBox().GetRootLevelParent( m_pTreeView->getListBox().GetCurEntry() ) ); 1923cdf0e10cSrcweir break; 1924cdf0e10cSrcweir 1925cdf0e10cSrcweir case ID_TREE_ADMINISTRATE: 1926cdf0e10cSrcweir ::svx::administrateDatabaseRegistration( getView() ); 1927cdf0e10cSrcweir break; 1928cdf0e10cSrcweir 1929cdf0e10cSrcweir case ID_BROWSER_REFRESH: 1930cdf0e10cSrcweir { 1931cdf0e10cSrcweir if ( !SaveModified( ) ) 1932cdf0e10cSrcweir // nothing to do 1933cdf0e10cSrcweir break; 1934cdf0e10cSrcweir 1935cdf0e10cSrcweir sal_Bool bFullReinit = sal_False; 1936cdf0e10cSrcweir // check if the query signature (if the form is based on a query) has changed 1937cdf0e10cSrcweir if ( m_sQueryCommand.getLength() ) 1938cdf0e10cSrcweir { 1939cdf0e10cSrcweir ::rtl::OUString sNewQueryCommand; 1940cdf0e10cSrcweir sal_Bool bNewQueryEP; 1941cdf0e10cSrcweir 1942cdf0e10cSrcweir #if OSL_DEBUG_LEVEL > 0 1943cdf0e10cSrcweir sal_Bool bIsQuery = 1944cdf0e10cSrcweir #endif 1945cdf0e10cSrcweir implGetQuerySignature( sNewQueryCommand, bNewQueryEP ); 1946cdf0e10cSrcweir OSL_ENSURE( bIsQuery, "SbaTableQueryBrowser::Execute: was a query before, but is not anymore?" ); 1947cdf0e10cSrcweir 1948cdf0e10cSrcweir bFullReinit = ( sNewQueryCommand != m_sQueryCommand ) || ( m_bQueryEscapeProcessing != bNewQueryEP ); 1949cdf0e10cSrcweir } 1950cdf0e10cSrcweir if ( !bFullReinit ) 1951cdf0e10cSrcweir { 1952cdf0e10cSrcweir // let the base class do a simple reload 1953cdf0e10cSrcweir SbaXDataBrowserController::Execute(nId,aArgs); 1954cdf0e10cSrcweir break; 1955cdf0e10cSrcweir } 1956cdf0e10cSrcweir // NO break here! 1957cdf0e10cSrcweir } 1958cdf0e10cSrcweir 1959cdf0e10cSrcweir case ID_BROWSER_REFRESH_REBUILD: 1960cdf0e10cSrcweir { 1961cdf0e10cSrcweir if ( !SaveModified() ) 1962cdf0e10cSrcweir // nothing to do 1963cdf0e10cSrcweir break; 1964cdf0e10cSrcweir 1965cdf0e10cSrcweir SvLBoxEntry* pSelected = m_pCurrentlyDisplayed; 1966cdf0e10cSrcweir // unload 1967cdf0e10cSrcweir unloadAndCleanup( sal_False ); 1968cdf0e10cSrcweir 1969cdf0e10cSrcweir // reselect the entry 1970cdf0e10cSrcweir if ( pSelected ) 1971cdf0e10cSrcweir { 1972cdf0e10cSrcweir implSelect( pSelected ); 1973cdf0e10cSrcweir } 1974cdf0e10cSrcweir else 1975cdf0e10cSrcweir { 1976cdf0e10cSrcweir Reference<XPropertySet> xProp(getRowSet(),UNO_QUERY); 1977cdf0e10cSrcweir implSelect(::svx::ODataAccessDescriptor(xProp)); 1978cdf0e10cSrcweir } 1979cdf0e10cSrcweir } 1980cdf0e10cSrcweir break; 1981cdf0e10cSrcweir 1982cdf0e10cSrcweir case ID_BROWSER_EXPLORER: 1983cdf0e10cSrcweir toggleExplorer(); 1984cdf0e10cSrcweir break; 1985cdf0e10cSrcweir 1986cdf0e10cSrcweir case ID_BROWSER_DOCUMENT_DATASOURCE: 1987cdf0e10cSrcweir implSelect(m_aDocumentDataSource); 1988cdf0e10cSrcweir break; 1989cdf0e10cSrcweir 1990cdf0e10cSrcweir case ID_BROWSER_INSERTCOLUMNS: 1991cdf0e10cSrcweir case ID_BROWSER_INSERTCONTENT: 1992cdf0e10cSrcweir case ID_BROWSER_FORMLETTER: 1993cdf0e10cSrcweir if (getBrowserView() && isValidCursor()) 1994cdf0e10cSrcweir { 1995cdf0e10cSrcweir // the URL the slot id is assigned to 1996cdf0e10cSrcweir OSL_ENSURE( m_aExternalFeatures.find( nId ) != m_aExternalFeatures.end(), 1997cdf0e10cSrcweir "SbaTableQueryBrowser::Execute( ID_BROWSER_?): how could this ever be enabled?" ); 1998cdf0e10cSrcweir URL aParentUrl = m_aExternalFeatures[ nId ].aURL; 1999cdf0e10cSrcweir 2000cdf0e10cSrcweir // let the dispatcher execute the slot 2001cdf0e10cSrcweir Reference< XDispatch > xDispatch( m_aExternalFeatures[ nId ].xDispatcher ); 2002cdf0e10cSrcweir if (xDispatch.is()) 2003cdf0e10cSrcweir { 2004cdf0e10cSrcweir // set the properties for the dispatch 2005cdf0e10cSrcweir 2006cdf0e10cSrcweir // first fill the selection 2007cdf0e10cSrcweir SbaGridControl* pGrid = getBrowserView()->getVclControl(); 2008cdf0e10cSrcweir MultiSelection* pSelection = (MultiSelection*)pGrid->GetSelection(); 2009cdf0e10cSrcweir Sequence< Any > aSelection; 2010cdf0e10cSrcweir if ( !pGrid->IsAllSelected() ) 2011cdf0e10cSrcweir { // transfer the selected rows only if not all rows are selected 2012cdf0e10cSrcweir // (all rows means the whole table) 2013cdf0e10cSrcweir // i3832 - 03.04.2002 - fs@openoffice.org 2014cdf0e10cSrcweir if (pSelection != NULL) 2015cdf0e10cSrcweir { 2016cdf0e10cSrcweir aSelection.realloc(pSelection->GetSelectCount()); 2017cdf0e10cSrcweir long nIdx = pSelection->FirstSelected(); 2018cdf0e10cSrcweir Any* pSelectionNos = aSelection.getArray(); 2019cdf0e10cSrcweir while (nIdx >= 0) 2020cdf0e10cSrcweir { 2021cdf0e10cSrcweir *pSelectionNos++ <<= (sal_Int32)(nIdx + 1); 2022cdf0e10cSrcweir nIdx = pSelection->NextSelected(); 2023cdf0e10cSrcweir } 2024cdf0e10cSrcweir } 2025cdf0e10cSrcweir } 2026cdf0e10cSrcweir 2027cdf0e10cSrcweir Reference< XResultSet > xCursorClone; 2028cdf0e10cSrcweir try 2029cdf0e10cSrcweir { 2030cdf0e10cSrcweir Reference< XResultSetAccess > xResultSetAccess(getRowSet(),UNO_QUERY); 2031cdf0e10cSrcweir if (xResultSetAccess.is()) 2032cdf0e10cSrcweir xCursorClone = xResultSetAccess->createResultSet(); 2033cdf0e10cSrcweir } 2034cdf0e10cSrcweir catch(DisposedException&) 2035cdf0e10cSrcweir { 2036cdf0e10cSrcweir OSL_ENSURE(0,"Object already disposed!"); 2037cdf0e10cSrcweir } 2038cdf0e10cSrcweir catch(Exception&) 2039cdf0e10cSrcweir { 2040cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::Execute(ID_BROWSER_?): could not clone the cursor!"); 2041cdf0e10cSrcweir } 2042cdf0e10cSrcweir 2043cdf0e10cSrcweir Reference<XPropertySet> xProp(getRowSet(),UNO_QUERY); 2044cdf0e10cSrcweir 2045cdf0e10cSrcweir try 2046cdf0e10cSrcweir { 2047cdf0e10cSrcweir ODataAccessDescriptor aDescriptor; 2048cdf0e10cSrcweir ::rtl::OUString sDataSourceName; 2049cdf0e10cSrcweir xProp->getPropertyValue(PROPERTY_DATASOURCENAME) >>= sDataSourceName; 2050cdf0e10cSrcweir 2051cdf0e10cSrcweir aDescriptor.setDataSource(sDataSourceName); 2052cdf0e10cSrcweir aDescriptor[daCommand] = xProp->getPropertyValue(PROPERTY_COMMAND); 2053cdf0e10cSrcweir aDescriptor[daCommandType] = xProp->getPropertyValue(PROPERTY_COMMAND_TYPE); 2054cdf0e10cSrcweir aDescriptor[daConnection] = xProp->getPropertyValue(PROPERTY_ACTIVE_CONNECTION); 2055cdf0e10cSrcweir aDescriptor[daCursor] <<= xCursorClone; 2056cdf0e10cSrcweir if ( aSelection.getLength() ) 2057cdf0e10cSrcweir { 2058cdf0e10cSrcweir aDescriptor[daSelection] <<= aSelection; 2059cdf0e10cSrcweir aDescriptor[daBookmarkSelection] <<= sal_False; 206007a3d7f1SPedro Giffuni // these are selection indices 2061cdf0e10cSrcweir // before we change this, all clients have to be adjusted 2062cdf0e10cSrcweir // so that they recognize the new BookmarkSelection property! 2063cdf0e10cSrcweir } 2064cdf0e10cSrcweir 2065cdf0e10cSrcweir xDispatch->dispatch(aParentUrl, aDescriptor.createPropertyValueSequence()); 2066cdf0e10cSrcweir } 2067cdf0e10cSrcweir catch( const Exception& ) 2068cdf0e10cSrcweir { 2069cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 2070cdf0e10cSrcweir } 2071cdf0e10cSrcweir } 2072cdf0e10cSrcweir } 2073cdf0e10cSrcweir break; 2074cdf0e10cSrcweir 2075cdf0e10cSrcweir case ID_BROWSER_CLOSE: 2076cdf0e10cSrcweir closeTask(); 2077cdf0e10cSrcweir // if it's not 0, such a async close is already pending 2078cdf0e10cSrcweir break; 2079cdf0e10cSrcweir 2080cdf0e10cSrcweir case ID_BROWSER_COPY: 2081cdf0e10cSrcweir if(m_pTreeView->HasChildPathFocus()) 2082cdf0e10cSrcweir { 2083cdf0e10cSrcweir copyEntry(m_pTreeView->getListBox().GetCurEntry()); 2084cdf0e10cSrcweir } 2085cdf0e10cSrcweir else if (getBrowserView() && getBrowserView()->getVclControl() && !getBrowserView()->getVclControl()->IsEditing() && getBrowserView()->getVclControl()->GetSelectRowCount() < 1) 2086cdf0e10cSrcweir { 2087cdf0e10cSrcweir SbaGridControl* pControl = getBrowserView()->getVclControl(); 2088cdf0e10cSrcweir pControl->copyCellText(pControl->GetCurRow(), pControl->GetCurColumnId()); 2089cdf0e10cSrcweir } 2090cdf0e10cSrcweir else 2091cdf0e10cSrcweir SbaXDataBrowserController::Execute(nId,aArgs); 2092cdf0e10cSrcweir break; 2093cdf0e10cSrcweir } 2094cdf0e10cSrcweir } 2095cdf0e10cSrcweir 2096cdf0e10cSrcweir // ------------------------------------------------------------------------- 2097cdf0e10cSrcweir void SbaTableQueryBrowser::implAddDatasource( const String& _rDataSourceName, const SharedConnection& _rxConnection ) 2098cdf0e10cSrcweir { 2099cdf0e10cSrcweir Image a, b, c; 2100cdf0e10cSrcweir String d, e; 2101cdf0e10cSrcweir implAddDatasource( _rDataSourceName, a, d, b, e, c, _rxConnection ); 2102cdf0e10cSrcweir } 2103cdf0e10cSrcweir 2104cdf0e10cSrcweir // ------------------------------------------------------------------------- 2105cdf0e10cSrcweir void SbaTableQueryBrowser::implAddDatasource(const String& _rDbName, Image& _rDbImage, 2106cdf0e10cSrcweir String& _rQueryName, Image& _rQueryImage, String& _rTableName, Image& _rTableImage, 2107cdf0e10cSrcweir const SharedConnection& _rxConnection) 2108cdf0e10cSrcweir { 2109cdf0e10cSrcweir vos::OGuard aGuard( Application::GetSolarMutex() ); 2110cdf0e10cSrcweir // initialize the names/images if necessary 2111cdf0e10cSrcweir if (!_rQueryName.Len()) 2112cdf0e10cSrcweir _rQueryName = String(ModuleRes(RID_STR_QUERIES_CONTAINER)); 2113cdf0e10cSrcweir if (!_rTableName.Len()) 2114cdf0e10cSrcweir _rTableName = String(ModuleRes(RID_STR_TABLES_CONTAINER)); 2115cdf0e10cSrcweir 2116cdf0e10cSrcweir ImageProvider aImageProvider; 2117cdf0e10cSrcweir if (!_rQueryImage) 2118cdf0e10cSrcweir _rQueryImage = aImageProvider.getFolderImage( DatabaseObject::QUERY, isHiContrast() ); 2119cdf0e10cSrcweir if (!_rTableImage) 2120cdf0e10cSrcweir _rTableImage = aImageProvider.getFolderImage( DatabaseObject::TABLE, isHiContrast() ); 2121cdf0e10cSrcweir 2122cdf0e10cSrcweir if (!_rDbImage) 2123cdf0e10cSrcweir _rDbImage = aImageProvider.getDatabaseImage( isHiContrast() ); 2124cdf0e10cSrcweir 2125cdf0e10cSrcweir // add the entry for the data source 2126cdf0e10cSrcweir // special handling for data sources denoted by URLs - we do not want to display this ugly URL, do we? 2127cdf0e10cSrcweir // #i33699# - 2004-09-24 - fs@openoffice.org 2128cdf0e10cSrcweir String sDSDisplayName, sDataSourceId; 2129cdf0e10cSrcweir getDataSourceDisplayName_isURL( _rDbName, sDSDisplayName, sDataSourceId ); 2130cdf0e10cSrcweir 2131cdf0e10cSrcweir SvLBoxEntry* pDatasourceEntry = m_pTreeView->getListBox().InsertEntry( sDSDisplayName, _rDbImage, _rDbImage, NULL, sal_False ); 2132cdf0e10cSrcweir DBTreeListUserData* pDSData = new DBTreeListUserData; 2133cdf0e10cSrcweir pDSData->eType = etDatasource; 2134cdf0e10cSrcweir pDSData->sAccessor = sDataSourceId; 2135cdf0e10cSrcweir pDSData->xConnection = _rxConnection; 2136cdf0e10cSrcweir pDatasourceEntry->SetUserData(pDSData); 2137cdf0e10cSrcweir 2138cdf0e10cSrcweir // the child for the queries container 2139cdf0e10cSrcweir { 2140cdf0e10cSrcweir DBTreeListUserData* pQueriesData = new DBTreeListUserData; 2141cdf0e10cSrcweir pQueriesData->eType = etQueryContainer; 2142cdf0e10cSrcweir 2143cdf0e10cSrcweir m_pTreeView->getListBox().InsertEntry( 2144cdf0e10cSrcweir _rQueryName, _rQueryImage, _rQueryImage, pDatasourceEntry, 2145cdf0e10cSrcweir sal_True /*ChildsOnDemand*/, LIST_APPEND, pQueriesData ); 2146cdf0e10cSrcweir } 2147cdf0e10cSrcweir 2148cdf0e10cSrcweir // the child for the tables container 2149cdf0e10cSrcweir { 2150cdf0e10cSrcweir DBTreeListUserData* pTablesData = new DBTreeListUserData; 2151cdf0e10cSrcweir pTablesData->eType = etTableContainer; 2152cdf0e10cSrcweir 2153cdf0e10cSrcweir m_pTreeView->getListBox().InsertEntry( 2154cdf0e10cSrcweir _rTableName, _rTableImage, _rTableImage, pDatasourceEntry, 2155cdf0e10cSrcweir sal_True /*ChildsOnDemand*/, LIST_APPEND, pTablesData ); 2156cdf0e10cSrcweir } 2157cdf0e10cSrcweir 2158cdf0e10cSrcweir } 2159cdf0e10cSrcweir // ------------------------------------------------------------------------- 2160cdf0e10cSrcweir void SbaTableQueryBrowser::initializeTreeModel() 2161cdf0e10cSrcweir { 2162cdf0e10cSrcweir if (m_xDatabaseContext.is()) 2163cdf0e10cSrcweir { 2164cdf0e10cSrcweir Image aDBImage, aQueriesImage, aTablesImage; 2165cdf0e10cSrcweir String sQueriesName, sTablesName; 2166cdf0e10cSrcweir 2167cdf0e10cSrcweir // fill the model with the names of the registered datasources 2168cdf0e10cSrcweir Sequence< ::rtl::OUString > aDatasources = m_xDatabaseContext->getElementNames(); 2169cdf0e10cSrcweir const ::rtl::OUString* pIter = aDatasources.getConstArray(); 2170cdf0e10cSrcweir const ::rtl::OUString* pEnd = pIter + aDatasources.getLength(); 2171cdf0e10cSrcweir for (; pIter != pEnd; ++pIter) 2172cdf0e10cSrcweir implAddDatasource( *pIter, aDBImage, sQueriesName, aQueriesImage, sTablesName, aTablesImage, SharedConnection() ); 2173cdf0e10cSrcweir } 2174cdf0e10cSrcweir } 2175cdf0e10cSrcweir // ------------------------------------------------------------------------- 2176cdf0e10cSrcweir void SbaTableQueryBrowser::populateTree(const Reference<XNameAccess>& _xNameAccess, 2177cdf0e10cSrcweir SvLBoxEntry* _pParent, 2178cdf0e10cSrcweir EntryType _eEntryType) 2179cdf0e10cSrcweir { 2180cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(_pParent->GetUserData()); 2181cdf0e10cSrcweir if(pData) // don't ask if the nameaccess is already set see OnExpandEntry views and tables 2182cdf0e10cSrcweir pData->xContainer = _xNameAccess; 2183cdf0e10cSrcweir 2184cdf0e10cSrcweir try 2185cdf0e10cSrcweir { 2186cdf0e10cSrcweir Sequence< ::rtl::OUString > aNames = _xNameAccess->getElementNames(); 2187cdf0e10cSrcweir const ::rtl::OUString* pIter = aNames.getConstArray(); 2188cdf0e10cSrcweir const ::rtl::OUString* pEnd = pIter + aNames.getLength(); 2189cdf0e10cSrcweir for (; pIter != pEnd; ++pIter) 2190cdf0e10cSrcweir { 2191cdf0e10cSrcweir if( !m_pTreeView->getListBox().GetEntryPosByName(*pIter,_pParent)) 2192cdf0e10cSrcweir { 2193cdf0e10cSrcweir DBTreeListUserData* pEntryData = new DBTreeListUserData; 2194cdf0e10cSrcweir pEntryData->eType = _eEntryType; 2195cdf0e10cSrcweir if ( _eEntryType == etQuery ) 2196cdf0e10cSrcweir { 2197cdf0e10cSrcweir Reference<XNameAccess> xChild(_xNameAccess->getByName(*pIter),UNO_QUERY); 2198cdf0e10cSrcweir if ( xChild.is() ) 2199cdf0e10cSrcweir pEntryData->eType = etQueryContainer; 2200cdf0e10cSrcweir } 2201cdf0e10cSrcweir implAppendEntry( _pParent, *pIter, pEntryData, pEntryData->eType ); 2202cdf0e10cSrcweir } 2203cdf0e10cSrcweir } 2204cdf0e10cSrcweir } 2205cdf0e10cSrcweir catch(Exception&) 2206cdf0e10cSrcweir { 2207cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::populateTree: could not fill the tree"); 2208cdf0e10cSrcweir } 2209cdf0e10cSrcweir } 2210cdf0e10cSrcweir 2211cdf0e10cSrcweir //------------------------------------------------------------------------------ 2212cdf0e10cSrcweir SvLBoxEntry* SbaTableQueryBrowser::implAppendEntry( SvLBoxEntry* _pParent, const String& _rName, void* _pUserData, EntryType _eEntryType ) 2213cdf0e10cSrcweir { 2214cdf0e10cSrcweir ::std::auto_ptr< ImageProvider > pImageProvider( getImageProviderFor( _pParent ) ); 2215cdf0e10cSrcweir 2216cdf0e10cSrcweir Image aImage, aImageHC; 2217cdf0e10cSrcweir pImageProvider->getImages( _rName, getDatabaseObjectType( _eEntryType ), aImage, aImageHC ); 2218cdf0e10cSrcweir 2219cdf0e10cSrcweir SvLBoxEntry* pNewEntry = m_pTreeView->getListBox().InsertEntry( _rName, _pParent, _eEntryType == etQueryContainer , LIST_APPEND, _pUserData ); 2220cdf0e10cSrcweir 2221cdf0e10cSrcweir m_pTreeView->getListBox().SetExpandedEntryBmp( pNewEntry, aImage, BMP_COLOR_NORMAL ); 2222cdf0e10cSrcweir m_pTreeView->getListBox().SetCollapsedEntryBmp( pNewEntry, aImage, BMP_COLOR_NORMAL ); 2223cdf0e10cSrcweir m_pTreeView->getListBox().SetExpandedEntryBmp( pNewEntry, aImageHC, BMP_COLOR_HIGHCONTRAST ); 2224cdf0e10cSrcweir m_pTreeView->getListBox().SetCollapsedEntryBmp( pNewEntry, aImageHC, BMP_COLOR_HIGHCONTRAST ); 2225cdf0e10cSrcweir 2226cdf0e10cSrcweir return pNewEntry; 2227cdf0e10cSrcweir } 2228cdf0e10cSrcweir 2229cdf0e10cSrcweir //------------------------------------------------------------------------------ 2230cdf0e10cSrcweir IMPL_LINK(SbaTableQueryBrowser, OnExpandEntry, SvLBoxEntry*, _pParent) 2231cdf0e10cSrcweir { 2232cdf0e10cSrcweir if (_pParent->HasChilds()) 2233cdf0e10cSrcweir // nothing to to ... 2234cdf0e10cSrcweir return 1L; 2235cdf0e10cSrcweir 2236cdf0e10cSrcweir SvLBoxEntry* pFirstParent = m_pTreeView->getListBox().GetRootLevelParent(_pParent); 2237cdf0e10cSrcweir OSL_ENSURE(pFirstParent,"SbaTableQueryBrowser::OnExpandEntry: No rootlevelparent!"); 2238cdf0e10cSrcweir 2239cdf0e10cSrcweir DBTreeListUserData* pData = static_cast< DBTreeListUserData* >(_pParent->GetUserData()); 2240cdf0e10cSrcweir OSL_ENSURE(pData,"SbaTableQueryBrowser::OnExpandEntry: No user data!"); 2241cdf0e10cSrcweir #if OSL_DEBUG_LEVEL > 0 2242cdf0e10cSrcweir SvLBoxString* pString = static_cast<SvLBoxString*>(pFirstParent->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING)); 2243cdf0e10cSrcweir OSL_ENSURE(pString,"SbaTableQueryBrowser::OnExpandEntry: No string item!"); 2244cdf0e10cSrcweir #endif 2245cdf0e10cSrcweir 2246cdf0e10cSrcweir if (etTableContainer == pData->eType) 2247cdf0e10cSrcweir { 2248cdf0e10cSrcweir WaitObject aWaitCursor(getBrowserView()); 2249cdf0e10cSrcweir 2250cdf0e10cSrcweir // it could be that we already have a connection 2251cdf0e10cSrcweir SharedConnection xConnection; 2252cdf0e10cSrcweir ensureConnection( pFirstParent, xConnection ); 2253cdf0e10cSrcweir 2254cdf0e10cSrcweir if ( xConnection.is() ) 2255cdf0e10cSrcweir { 2256cdf0e10cSrcweir SQLExceptionInfo aInfo; 2257cdf0e10cSrcweir try 2258cdf0e10cSrcweir { 2259cdf0e10cSrcweir Reference< XWarningsSupplier > xWarnings(xConnection, UNO_QUERY); 2260cdf0e10cSrcweir if (xWarnings.is()) 2261cdf0e10cSrcweir xWarnings->clearWarnings(); 2262cdf0e10cSrcweir 2263cdf0e10cSrcweir // first insert the views because the tables can also include 2264cdf0e10cSrcweir // views but that time the bitmap is the wrong one 2265cdf0e10cSrcweir // the nameaccess will be overwriten in populateTree 2266cdf0e10cSrcweir Reference<XViewsSupplier> xViewSup(xConnection,UNO_QUERY); 2267cdf0e10cSrcweir if(xViewSup.is()) 2268cdf0e10cSrcweir populateTree( xViewSup->getViews(), _pParent, etTableOrView ); 2269cdf0e10cSrcweir 2270cdf0e10cSrcweir Reference<XTablesSupplier> xTabSup(xConnection,UNO_QUERY); 2271cdf0e10cSrcweir if(xTabSup.is()) 2272cdf0e10cSrcweir { 2273cdf0e10cSrcweir populateTree( xTabSup->getTables(), _pParent, etTableOrView ); 2274cdf0e10cSrcweir Reference<XContainer> xCont(xTabSup->getTables(),UNO_QUERY); 2275cdf0e10cSrcweir if(xCont.is()) 2276cdf0e10cSrcweir // add as listener to know when elements are inserted or removed 2277cdf0e10cSrcweir xCont->addContainerListener(this); 2278cdf0e10cSrcweir } 2279cdf0e10cSrcweir 2280cdf0e10cSrcweir if (xWarnings.is()) 2281cdf0e10cSrcweir { 2282cdf0e10cSrcweir SQLExceptionInfo aWarnings(xWarnings->getWarnings()); 2283cdf0e10cSrcweir if (aWarnings.isValid() && sal_False) 2284cdf0e10cSrcweir { 2285cdf0e10cSrcweir SQLContext aContext; 2286cdf0e10cSrcweir aContext.Message = String(ModuleRes(STR_OPENTABLES_WARNINGS)); 2287cdf0e10cSrcweir aContext.Details = String(ModuleRes(STR_OPENTABLES_WARNINGS_DETAILS)); 2288cdf0e10cSrcweir aContext.NextException = aWarnings.get(); 2289cdf0e10cSrcweir aWarnings = aContext; 2290cdf0e10cSrcweir showError(aWarnings); 2291cdf0e10cSrcweir } 2292cdf0e10cSrcweir // TODO: we need a better concept for these warnings: 2293cdf0e10cSrcweir // something like "don't show any warnings for this datasource, again" would be nice 2294cdf0e10cSrcweir // But this requires an extension of the InteractionHandler and an additional property on the data source 2295cdf0e10cSrcweir } 2296cdf0e10cSrcweir } 2297cdf0e10cSrcweir catch(const SQLContext& e) { aInfo = e; } 2298cdf0e10cSrcweir catch(const SQLWarning& e) { aInfo = e; } 2299cdf0e10cSrcweir catch(const SQLException& e) { aInfo = e; } 2300cdf0e10cSrcweir catch(const WrappedTargetException& e) 2301cdf0e10cSrcweir { 2302cdf0e10cSrcweir SQLException aSql; 2303cdf0e10cSrcweir if(e.TargetException >>= aSql) 2304cdf0e10cSrcweir aInfo = aSql; 2305cdf0e10cSrcweir else 230607a3d7f1SPedro Giffuni OSL_ENSURE(sal_False, "SbaTableQueryBrowser::OnExpandEntry: something strange happened!"); 2307cdf0e10cSrcweir } 2308cdf0e10cSrcweir catch( const Exception& ) 2309cdf0e10cSrcweir { 2310cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 2311cdf0e10cSrcweir } 2312cdf0e10cSrcweir if (aInfo.isValid()) 2313cdf0e10cSrcweir showError(aInfo); 2314cdf0e10cSrcweir } 2315cdf0e10cSrcweir else 2316cdf0e10cSrcweir return 0L; 231707a3d7f1SPedro Giffuni // 0 indicates that an error occurred 2318cdf0e10cSrcweir } 2319cdf0e10cSrcweir else 2320cdf0e10cSrcweir { // we have to expand the queries or bookmarks 2321cdf0e10cSrcweir if (ensureEntryObject(_pParent)) 2322cdf0e10cSrcweir { 2323cdf0e10cSrcweir DBTreeListUserData* pParentData = static_cast< DBTreeListUserData* >( _pParent->GetUserData() ); 2324cdf0e10cSrcweir Reference< XNameAccess > xCollection( pParentData->xContainer, UNO_QUERY ); 2325cdf0e10cSrcweir populateTree( xCollection, _pParent, etQuery ); 2326cdf0e10cSrcweir } 2327cdf0e10cSrcweir } 2328cdf0e10cSrcweir return 1L; 2329cdf0e10cSrcweir } 2330cdf0e10cSrcweir 2331cdf0e10cSrcweir //------------------------------------------------------------------------------ 2332cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::ensureEntryObject( SvLBoxEntry* _pEntry ) 2333cdf0e10cSrcweir { 2334cdf0e10cSrcweir DBG_ASSERT(_pEntry, "SbaTableQueryBrowser::ensureEntryObject: invalid argument!"); 2335cdf0e10cSrcweir if (!_pEntry) 2336cdf0e10cSrcweir return sal_False; 2337cdf0e10cSrcweir 2338cdf0e10cSrcweir EntryType eType = getEntryType( _pEntry ); 2339cdf0e10cSrcweir 2340cdf0e10cSrcweir // the user data of the entry 2341cdf0e10cSrcweir DBTreeListUserData* pEntryData = static_cast<DBTreeListUserData*>(_pEntry->GetUserData()); 2342cdf0e10cSrcweir OSL_ENSURE(pEntryData,"ensureEntryObject: user data should already be set!"); 2343cdf0e10cSrcweir 2344cdf0e10cSrcweir SvLBoxEntry* pDataSourceEntry = m_pTreeView->getListBox().GetRootLevelParent(_pEntry); 2345cdf0e10cSrcweir 2346cdf0e10cSrcweir sal_Bool bSuccess = sal_False; 2347cdf0e10cSrcweir switch (eType) 2348cdf0e10cSrcweir { 2349cdf0e10cSrcweir case etQueryContainer: 2350cdf0e10cSrcweir if ( pEntryData->xContainer.is() ) 2351cdf0e10cSrcweir { 2352cdf0e10cSrcweir // nothing to do 2353cdf0e10cSrcweir bSuccess = sal_True; 2354cdf0e10cSrcweir break; 2355cdf0e10cSrcweir } 2356cdf0e10cSrcweir 2357cdf0e10cSrcweir { 2358cdf0e10cSrcweir SvLBoxEntry* pParent = m_pTreeView->getListBox().GetParent(_pEntry); 2359cdf0e10cSrcweir if ( pParent != pDataSourceEntry ) 2360cdf0e10cSrcweir { 2361cdf0e10cSrcweir SvLBoxString* pString = (SvLBoxString*)_pEntry->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING); 2362cdf0e10cSrcweir OSL_ENSURE(pString,"There must be a string item!"); 2363cdf0e10cSrcweir ::rtl::OUString aName(pString->GetText()); 2364cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(pParent->GetUserData()); 2365cdf0e10cSrcweir try 2366cdf0e10cSrcweir { 2367cdf0e10cSrcweir Reference< XNameAccess > xNameAccess(pData->xContainer,UNO_QUERY); 2368cdf0e10cSrcweir if ( xNameAccess.is() ) 2369cdf0e10cSrcweir pEntryData->xContainer.set(xNameAccess->getByName(aName),UNO_QUERY); 2370cdf0e10cSrcweir } 2371cdf0e10cSrcweir catch(const Exception& ) 2372cdf0e10cSrcweir { 2373cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 2374cdf0e10cSrcweir } 2375cdf0e10cSrcweir 2376cdf0e10cSrcweir bSuccess = pEntryData->xContainer.is(); 2377cdf0e10cSrcweir } 2378cdf0e10cSrcweir else 2379cdf0e10cSrcweir { 2380cdf0e10cSrcweir try 2381cdf0e10cSrcweir { 2382cdf0e10cSrcweir Reference< XQueryDefinitionsSupplier > xQuerySup; 2383cdf0e10cSrcweir m_xDatabaseContext->getByName( getDataSourceAcessor( pDataSourceEntry ) ) >>= xQuerySup; 2384cdf0e10cSrcweir if (xQuerySup.is()) 2385cdf0e10cSrcweir { 2386cdf0e10cSrcweir Reference< XNameAccess > xQueryDefs = xQuerySup->getQueryDefinitions(); 2387cdf0e10cSrcweir Reference< XContainer > xCont(xQueryDefs, UNO_QUERY); 2388cdf0e10cSrcweir if (xCont.is()) 2389cdf0e10cSrcweir // add as listener to get notified if elements are inserted or removed 2390cdf0e10cSrcweir xCont->addContainerListener(this); 2391cdf0e10cSrcweir 2392cdf0e10cSrcweir pEntryData->xContainer = xQueryDefs; 2393cdf0e10cSrcweir bSuccess = pEntryData->xContainer.is(); 2394cdf0e10cSrcweir } 2395cdf0e10cSrcweir else { 2396cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::ensureEntryObject: no XQueryDefinitionsSupplier interface!"); 2397cdf0e10cSrcweir } 2398cdf0e10cSrcweir } 2399cdf0e10cSrcweir catch( const Exception& ) 2400cdf0e10cSrcweir { 2401cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 2402cdf0e10cSrcweir } 2403cdf0e10cSrcweir } 2404cdf0e10cSrcweir } 2405cdf0e10cSrcweir break; 2406cdf0e10cSrcweir 2407cdf0e10cSrcweir default: 2408cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::ensureEntryObject: ooops ... missing some implementation here!"); 2409cdf0e10cSrcweir // TODO ... 2410cdf0e10cSrcweir break; 2411cdf0e10cSrcweir } 2412cdf0e10cSrcweir 2413cdf0e10cSrcweir return bSuccess; 2414cdf0e10cSrcweir } 2415cdf0e10cSrcweir //------------------------------------------------------------------------------ 2416cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::implSelect(const ::svx::ODataAccessDescriptor& _rDescriptor,sal_Bool _bSelectDirect) 2417cdf0e10cSrcweir { 2418cdf0e10cSrcweir // extract the props 2419cdf0e10cSrcweir ::rtl::OUString sDataSource; 2420cdf0e10cSrcweir ::rtl::OUString sCommand; 2421cdf0e10cSrcweir sal_Int32 nCommandType = CommandType::COMMAND; 2422cdf0e10cSrcweir sal_Bool bEscapeProcessing = sal_True; 2423cdf0e10cSrcweir extractDescriptorProps(_rDescriptor, sDataSource, sCommand, nCommandType, bEscapeProcessing); 2424cdf0e10cSrcweir 2425cdf0e10cSrcweir // select it 2426cdf0e10cSrcweir return implSelect( sDataSource, sCommand, nCommandType, bEscapeProcessing, SharedConnection(), _bSelectDirect ); 2427cdf0e10cSrcweir } 2428cdf0e10cSrcweir 2429cdf0e10cSrcweir //------------------------------------------------------------------------------ 2430cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::implLoadAnything(const ::rtl::OUString& _rDataSourceName, const ::rtl::OUString& _rCommand, 2431cdf0e10cSrcweir const sal_Int32 _nCommandType, const sal_Bool _bEscapeProcessing, const SharedConnection& _rxConnection) 2432cdf0e10cSrcweir { 2433cdf0e10cSrcweir try 2434cdf0e10cSrcweir { 2435cdf0e10cSrcweir Reference<XPropertySet> xProp( getRowSet(), UNO_QUERY_THROW ); 2436cdf0e10cSrcweir Reference< XLoadable > xLoadable( xProp, UNO_QUERY_THROW ); 2437cdf0e10cSrcweir // the values allowing the RowSet to re-execute 2438cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_DATASOURCENAME, makeAny(_rDataSourceName)); 2439cdf0e10cSrcweir if(_rxConnection.is()) 2440cdf0e10cSrcweir xProp->setPropertyValue( PROPERTY_ACTIVE_CONNECTION, makeAny( _rxConnection.getTyped() ) ); 2441cdf0e10cSrcweir 2442cdf0e10cSrcweir // set this _before_ setting the connection, else the rowset would rebuild it ... 2443cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_COMMAND_TYPE, makeAny(_nCommandType)); 2444cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_COMMAND, makeAny(_rCommand)); 2445cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_ESCAPE_PROCESSING, ::cppu::bool2any(_bEscapeProcessing)); 2446cdf0e10cSrcweir if ( m_bPreview ) 2447cdf0e10cSrcweir { 2448cdf0e10cSrcweir xProp->setPropertyValue(PROPERTY_FETCHDIRECTION, makeAny(FetchDirection::FORWARD)); 2449cdf0e10cSrcweir } 2450cdf0e10cSrcweir 2451cdf0e10cSrcweir // the formatter depends on the data source we're working on, so rebuild it here ... 2452cdf0e10cSrcweir initFormatter(); 2453cdf0e10cSrcweir 2454cdf0e10cSrcweir // switch the grid to design mode while loading 2455cdf0e10cSrcweir getBrowserView()->getGridControl()->setDesignMode(sal_True); 2456cdf0e10cSrcweir InitializeForm( xProp ); 2457cdf0e10cSrcweir 2458cdf0e10cSrcweir sal_Bool bSuccess = sal_True; 2459cdf0e10cSrcweir 2460cdf0e10cSrcweir { 2461cdf0e10cSrcweir { 2462cdf0e10cSrcweir Reference< XNameContainer > xColContainer(getFormComponent(), UNO_QUERY); 2463cdf0e10cSrcweir // first we have to clear the grid 2464cdf0e10cSrcweir clearGridColumns(xColContainer); 2465cdf0e10cSrcweir } 2466cdf0e10cSrcweir FormErrorHelper aHelper(this); 2467cdf0e10cSrcweir // load the form 2468cdf0e10cSrcweir bSuccess = reloadForm(xLoadable); 2469cdf0e10cSrcweir 2470cdf0e10cSrcweir // initialize the model 2471cdf0e10cSrcweir InitializeGridModel(getFormComponent()); 2472cdf0e10cSrcweir 2473cdf0e10cSrcweir Any aVal = xProp->getPropertyValue(PROPERTY_ISNEW); 2474cdf0e10cSrcweir if (aVal.hasValue() && ::comphelper::getBOOL(aVal)) 2475cdf0e10cSrcweir { 2476cdf0e10cSrcweir // then set the default values and the parameters given from the parent 2477cdf0e10cSrcweir Reference< XReset> xReset(xProp, UNO_QUERY); 2478cdf0e10cSrcweir xReset->reset(); 2479cdf0e10cSrcweir } 2480cdf0e10cSrcweir 2481cdf0e10cSrcweir if ( m_bPreview ) 2482cdf0e10cSrcweir initializePreviewMode(); 2483cdf0e10cSrcweir 2484cdf0e10cSrcweir LoadFinished(sal_True); 2485cdf0e10cSrcweir } 2486cdf0e10cSrcweir 2487cdf0e10cSrcweir InvalidateAll(); 2488cdf0e10cSrcweir return bSuccess; 2489cdf0e10cSrcweir } 2490cdf0e10cSrcweir catch( const SQLException& e ) 2491cdf0e10cSrcweir { 2492cdf0e10cSrcweir Any aException( ::cppu::getCaughtException() ); 2493cdf0e10cSrcweir showError( SQLExceptionInfo( aException ) ); 2494cdf0e10cSrcweir } 2495cdf0e10cSrcweir catch( const WrappedTargetException& e ) 2496cdf0e10cSrcweir { 2497cdf0e10cSrcweir SQLException aSql; 2498cdf0e10cSrcweir if ( e.TargetException.isExtractableTo( ::cppu::UnoType< SQLException >::get() ) ) 2499cdf0e10cSrcweir showError( SQLExceptionInfo( e.TargetException ) ); 2500cdf0e10cSrcweir else 2501cdf0e10cSrcweir { 2502cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 2503cdf0e10cSrcweir } 2504cdf0e10cSrcweir } 2505cdf0e10cSrcweir catch(Exception&) 2506cdf0e10cSrcweir { 2507cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 2508cdf0e10cSrcweir } 2509cdf0e10cSrcweir 2510cdf0e10cSrcweir InvalidateAll(); 2511cdf0e10cSrcweir return sal_False; 2512cdf0e10cSrcweir } 2513cdf0e10cSrcweir 2514cdf0e10cSrcweir //------------------------------------------------------------------------------ 2515cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::implSelect(const ::rtl::OUString& _rDataSourceName, const ::rtl::OUString& _rCommand, 2516cdf0e10cSrcweir const sal_Int32 _nCommandType, const sal_Bool _bEscapeProcessing, 2517cdf0e10cSrcweir const SharedConnection& _rxConnection 2518cdf0e10cSrcweir ,sal_Bool _bSelectDirect) 2519cdf0e10cSrcweir { 2520cdf0e10cSrcweir if (_rDataSourceName.getLength() && _rCommand.getLength() && (-1 != _nCommandType)) 2521cdf0e10cSrcweir { 2522cdf0e10cSrcweir SvLBoxEntry* pDataSource = NULL; 2523cdf0e10cSrcweir SvLBoxEntry* pCommandType = NULL; 2524cdf0e10cSrcweir SvLBoxEntry* pCommand = getObjectEntry( _rDataSourceName, _rCommand, _nCommandType, &pDataSource, &pCommandType, sal_True, _rxConnection ); 2525cdf0e10cSrcweir 2526cdf0e10cSrcweir if (pCommand) 2527cdf0e10cSrcweir { 2528cdf0e10cSrcweir bool bSuccess = true; 2529cdf0e10cSrcweir if ( _bSelectDirect ) 2530cdf0e10cSrcweir { 2531cdf0e10cSrcweir bSuccess = implSelect( pCommand ); 2532cdf0e10cSrcweir } 2533cdf0e10cSrcweir else 2534cdf0e10cSrcweir { 2535cdf0e10cSrcweir m_pTreeView->getListBox().Select( pCommand ); 2536cdf0e10cSrcweir } 2537cdf0e10cSrcweir 2538cdf0e10cSrcweir if ( bSuccess ) 2539cdf0e10cSrcweir { 2540cdf0e10cSrcweir m_pTreeView->getListBox().MakeVisible(pCommand); 2541cdf0e10cSrcweir m_pTreeView->getListBox().SetCursor(pCommand); 2542cdf0e10cSrcweir } 2543cdf0e10cSrcweir } 2544cdf0e10cSrcweir else if (!pCommandType) 2545cdf0e10cSrcweir { 2546cdf0e10cSrcweir if ( m_pCurrentlyDisplayed ) 2547cdf0e10cSrcweir { // tell the old entry (if any) it has been deselected 2548cdf0e10cSrcweir selectPath(m_pCurrentlyDisplayed, sal_False); 2549cdf0e10cSrcweir m_pCurrentlyDisplayed = NULL; 2550cdf0e10cSrcweir } 2551cdf0e10cSrcweir 2552cdf0e10cSrcweir // we have a command and need to display this in the rowset 2553cdf0e10cSrcweir return implLoadAnything(_rDataSourceName, _rCommand, _nCommandType, _bEscapeProcessing, _rxConnection); 2554cdf0e10cSrcweir } 2555cdf0e10cSrcweir } 2556cdf0e10cSrcweir return sal_False; 2557cdf0e10cSrcweir } 2558cdf0e10cSrcweir 2559cdf0e10cSrcweir //------------------------------------------------------------------------------ 2560cdf0e10cSrcweir IMPL_LINK(SbaTableQueryBrowser, OnSelectionChange, void*, /*NOINTERESTEDIN*/) 2561cdf0e10cSrcweir { 2562cdf0e10cSrcweir return implSelect( m_pTreeView->getListBox().FirstSelected() ) ? 1L : 0L; 2563cdf0e10cSrcweir } 2564cdf0e10cSrcweir //------------------------------------------------------------------------------ 2565cdf0e10cSrcweir SvLBoxEntry* SbaTableQueryBrowser::implGetConnectionEntry(SvLBoxEntry* _pEntry) const 2566cdf0e10cSrcweir { 2567cdf0e10cSrcweir SvLBoxEntry* pCurrentEntry = _pEntry; 2568cdf0e10cSrcweir DBTreeListUserData* pEntryData = static_cast< DBTreeListUserData* >( pCurrentEntry->GetUserData() ); 2569cdf0e10cSrcweir while(pEntryData->eType != etDatasource ) 2570cdf0e10cSrcweir { 2571cdf0e10cSrcweir pCurrentEntry = m_pTreeModel->GetParent(pCurrentEntry); 2572cdf0e10cSrcweir pEntryData = static_cast< DBTreeListUserData* >( pCurrentEntry->GetUserData() ); 2573cdf0e10cSrcweir } 2574cdf0e10cSrcweir return pCurrentEntry; 2575cdf0e10cSrcweir } 2576cdf0e10cSrcweir //------------------------------------------------------------------------------ 2577cdf0e10cSrcweir bool SbaTableQueryBrowser::implSelect( SvLBoxEntry* _pEntry ) 2578cdf0e10cSrcweir { 2579cdf0e10cSrcweir if ( !_pEntry ) 2580cdf0e10cSrcweir return false; 2581cdf0e10cSrcweir 2582cdf0e10cSrcweir DBTreeListUserData* pEntryData = static_cast< DBTreeListUserData* >( _pEntry->GetUserData() ); 2583cdf0e10cSrcweir switch (pEntryData->eType) 2584cdf0e10cSrcweir { 2585cdf0e10cSrcweir case etTableOrView: 2586cdf0e10cSrcweir case etQuery: 2587cdf0e10cSrcweir break; 2588cdf0e10cSrcweir default: 2589cdf0e10cSrcweir // nothing to do 2590cdf0e10cSrcweir return false; 2591cdf0e10cSrcweir } 2592cdf0e10cSrcweir 2593cdf0e10cSrcweir OSL_ENSURE(m_pTreeModel->HasParent(_pEntry), "SbaTableQueryBrowser::implSelect: invalid entry (1)!"); 2594cdf0e10cSrcweir OSL_ENSURE(m_pTreeModel->HasParent(m_pTreeModel->GetParent(_pEntry)), "SbaTableQueryBrowser::implSelect: invalid entry (2)!"); 2595cdf0e10cSrcweir 2596cdf0e10cSrcweir // get the entry for the tables or queries 2597cdf0e10cSrcweir SvLBoxEntry* pContainer = m_pTreeModel->GetParent(_pEntry); 2598cdf0e10cSrcweir DBTreeListUserData* pContainerData = static_cast<DBTreeListUserData*>(pContainer->GetUserData()); 2599cdf0e10cSrcweir 2600cdf0e10cSrcweir // get the entry for the datasource 2601cdf0e10cSrcweir SvLBoxEntry* pConnection = implGetConnectionEntry(pContainer); 2602cdf0e10cSrcweir DBTreeListUserData* pConData = static_cast<DBTreeListUserData*>(pConnection->GetUserData()); 2603cdf0e10cSrcweir 2604cdf0e10cSrcweir // reinitialize the rowset 2605cdf0e10cSrcweir // but first check if it is necessary 2606cdf0e10cSrcweir // get all old properties 2607cdf0e10cSrcweir Reference<XPropertySet> xRowSetProps(getRowSet(),UNO_QUERY); 2608cdf0e10cSrcweir ::rtl::OUString aOldName; 2609cdf0e10cSrcweir xRowSetProps->getPropertyValue(PROPERTY_COMMAND) >>= aOldName; 2610cdf0e10cSrcweir sal_Int32 nOldType = 0; 2611cdf0e10cSrcweir xRowSetProps->getPropertyValue(PROPERTY_COMMAND_TYPE) >>= nOldType; 2612cdf0e10cSrcweir Reference<XConnection> xOldConnection(xRowSetProps->getPropertyValue(PROPERTY_ACTIVE_CONNECTION),UNO_QUERY); 2613cdf0e10cSrcweir 2614cdf0e10cSrcweir // the name of the table or query 2615cdf0e10cSrcweir SvLBoxString* pString = (SvLBoxString*)_pEntry->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING); 2616cdf0e10cSrcweir OSL_ENSURE(pString,"There must be a string item!"); 2617cdf0e10cSrcweir const ::rtl::OUString sSimpleName = pString->GetText(); 2618cdf0e10cSrcweir ::rtl::OUStringBuffer sNameBuffer(sSimpleName); 2619cdf0e10cSrcweir if ( etQueryContainer == pContainerData->eType ) 2620cdf0e10cSrcweir { 2621cdf0e10cSrcweir SvLBoxEntry* pTemp = pContainer; 2622cdf0e10cSrcweir while( m_pTreeModel->GetParent(pTemp) != pConnection ) 2623cdf0e10cSrcweir { 2624cdf0e10cSrcweir sNameBuffer.insert(0,sal_Unicode('/')); 2625cdf0e10cSrcweir pString = (SvLBoxString*)pTemp->GetFirstItem(SV_ITEM_ID_BOLDLBSTRING); 2626cdf0e10cSrcweir OSL_ENSURE(pString,"There must be a string item!"); 2627cdf0e10cSrcweir sNameBuffer.insert(0,pString->GetText()); 2628cdf0e10cSrcweir pTemp = m_pTreeModel->GetParent(pTemp); 2629cdf0e10cSrcweir } 2630cdf0e10cSrcweir } 2631cdf0e10cSrcweir ::rtl::OUString aName = sNameBuffer.makeStringAndClear(); 2632cdf0e10cSrcweir 2633cdf0e10cSrcweir sal_Int32 nCommandType = ( etTableContainer == pContainerData->eType) 2634cdf0e10cSrcweir ? CommandType::TABLE 2635cdf0e10cSrcweir : CommandType::QUERY; 2636cdf0e10cSrcweir 2637cdf0e10cSrcweir // check if need to rebuild the rowset 2638cdf0e10cSrcweir sal_Bool bRebuild = ( xOldConnection != pConData->xConnection ) 2639cdf0e10cSrcweir || ( nOldType != nCommandType ) 2640cdf0e10cSrcweir || ( aName != aOldName ); 2641cdf0e10cSrcweir 2642cdf0e10cSrcweir Reference< ::com::sun::star::form::XLoadable > xLoadable = getLoadable(); 2643cdf0e10cSrcweir bRebuild |= !xLoadable->isLoaded(); 2644cdf0e10cSrcweir bool bSuccess = true; 2645cdf0e10cSrcweir if ( bRebuild ) 2646cdf0e10cSrcweir { 2647cdf0e10cSrcweir try 2648cdf0e10cSrcweir { 2649cdf0e10cSrcweir WaitObject aWaitCursor(getBrowserView()); 2650cdf0e10cSrcweir 2651cdf0e10cSrcweir // tell the old entry it has been deselected 2652cdf0e10cSrcweir selectPath(m_pCurrentlyDisplayed, sal_False); 2653cdf0e10cSrcweir m_pCurrentlyDisplayed = NULL; 2654cdf0e10cSrcweir 2655cdf0e10cSrcweir // not really loaded 2656cdf0e10cSrcweir m_pCurrentlyDisplayed = _pEntry; 2657cdf0e10cSrcweir // tell the new entry it has been selected 2658cdf0e10cSrcweir selectPath(m_pCurrentlyDisplayed, sal_True); 2659cdf0e10cSrcweir 2660cdf0e10cSrcweir // get the name of the data source currently selected 2661cdf0e10cSrcweir ensureConnection( m_pCurrentlyDisplayed, pConData->xConnection ); 2662cdf0e10cSrcweir 2663cdf0e10cSrcweir if ( !pConData->xConnection.is() ) 2664cdf0e10cSrcweir { 2665cdf0e10cSrcweir unloadAndCleanup( sal_False ); 2666cdf0e10cSrcweir return false; 2667cdf0e10cSrcweir } 2668cdf0e10cSrcweir 2669cdf0e10cSrcweir Reference<XNameAccess> xNameAccess; 2670cdf0e10cSrcweir switch(nCommandType) 2671cdf0e10cSrcweir { 2672cdf0e10cSrcweir case CommandType::TABLE: 2673cdf0e10cSrcweir { 2674cdf0e10cSrcweir // only for tables 2675cdf0e10cSrcweir if ( !pContainerData->xContainer.is() ) 2676cdf0e10cSrcweir { 2677cdf0e10cSrcweir Reference<XTablesSupplier> xSup( pConData->xConnection, UNO_QUERY ); 2678cdf0e10cSrcweir if(xSup.is()) 2679cdf0e10cSrcweir xNameAccess = xSup->getTables(); 2680cdf0e10cSrcweir 2681cdf0e10cSrcweir pContainerData->xContainer = xNameAccess; 2682cdf0e10cSrcweir } 2683cdf0e10cSrcweir else 2684cdf0e10cSrcweir xNameAccess.set( pContainerData->xContainer, UNO_QUERY ); 2685cdf0e10cSrcweir } 2686cdf0e10cSrcweir break; 2687cdf0e10cSrcweir case CommandType::QUERY: 2688cdf0e10cSrcweir { 2689cdf0e10cSrcweir if ( pContainerData->xContainer.is() ) 2690cdf0e10cSrcweir xNameAccess.set( pContainerData->xContainer, UNO_QUERY ); 2691cdf0e10cSrcweir else 2692cdf0e10cSrcweir { 2693cdf0e10cSrcweir Reference<XQueriesSupplier> xSup( pConData->xConnection, UNO_QUERY ); 2694cdf0e10cSrcweir if(xSup.is()) 2695cdf0e10cSrcweir xNameAccess = xSup->getQueries(); 2696cdf0e10cSrcweir } 2697cdf0e10cSrcweir } 2698cdf0e10cSrcweir break; 2699cdf0e10cSrcweir } 2700cdf0e10cSrcweir String sStatus(ModuleRes( CommandType::TABLE == nCommandType ? STR_LOADING_TABLE : STR_LOADING_QUERY )); 2701cdf0e10cSrcweir sStatus.SearchAndReplaceAscii("$name$", aName); 2702cdf0e10cSrcweir BrowserViewStatusDisplay aShowStatus(static_cast<UnoDataBrowserView*>(getView()), sStatus); 2703cdf0e10cSrcweir 2704cdf0e10cSrcweir 2705cdf0e10cSrcweir sal_Bool bEscapeProcessing = sal_True; 2706cdf0e10cSrcweir if(xNameAccess.is() && xNameAccess->hasByName(sSimpleName)) 2707cdf0e10cSrcweir { 2708cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(_pEntry->GetUserData()); 2709cdf0e10cSrcweir if ( !pData->xObjectProperties.is() ) 2710cdf0e10cSrcweir { 2711cdf0e10cSrcweir Reference<XInterface> xObject; 2712cdf0e10cSrcweir if(xNameAccess->getByName(sSimpleName) >>= xObject) // remember the table or query object 2713cdf0e10cSrcweir { 2714cdf0e10cSrcweir pData->xObjectProperties = pData->xObjectProperties.query( xObject ); 2715cdf0e10cSrcweir // if the query contains a parameterized statement and preview is enabled we won't get any data. 2716cdf0e10cSrcweir if ( nCommandType == CommandType::QUERY && xObject.is() ) 2717cdf0e10cSrcweir { 2718cdf0e10cSrcweir Reference<XPropertySet> xObjectProps(xObject,UNO_QUERY); 2719cdf0e10cSrcweir xObjectProps->getPropertyValue(PROPERTY_ESCAPE_PROCESSING) >>= bEscapeProcessing; 2720cdf0e10cSrcweir if ( m_bPreview ) 2721cdf0e10cSrcweir { 2722cdf0e10cSrcweir ::rtl::OUString sSql; 2723cdf0e10cSrcweir xObjectProps->getPropertyValue(PROPERTY_COMMAND) >>= sSql; 2724cdf0e10cSrcweir Reference< XMultiServiceFactory > xFactory( pConData->xConnection, UNO_QUERY ); 2725cdf0e10cSrcweir if (xFactory.is()) 2726cdf0e10cSrcweir { 2727cdf0e10cSrcweir try 2728cdf0e10cSrcweir { 2729cdf0e10cSrcweir Reference<XSingleSelectQueryAnalyzer> xAnalyzer(xFactory->createInstance(SERVICE_NAME_SINGLESELECTQUERYCOMPOSER),UNO_QUERY); 2730cdf0e10cSrcweir if ( xAnalyzer.is() ) 2731cdf0e10cSrcweir { 2732cdf0e10cSrcweir xAnalyzer->setQuery(sSql); 2733cdf0e10cSrcweir Reference<XParametersSupplier> xParSup(xAnalyzer,UNO_QUERY); 2734cdf0e10cSrcweir if ( xParSup->getParameters()->getCount() > 0 ) 2735cdf0e10cSrcweir { 2736cdf0e10cSrcweir String sFilter = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" WHERE ")); 2737cdf0e10cSrcweir sFilter = sFilter + xAnalyzer->getFilter(); 2738cdf0e10cSrcweir String sReplace(sSql); 2739cdf0e10cSrcweir sReplace.SearchAndReplace(sFilter,String()); 2740cdf0e10cSrcweir xAnalyzer->setQuery(sReplace); 2741cdf0e10cSrcweir Reference<XSingleSelectQueryComposer> xComposer(xAnalyzer,UNO_QUERY); 2742cdf0e10cSrcweir xComposer->setFilter(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("0=1"))); 2743cdf0e10cSrcweir aName = xAnalyzer->getQuery(); 2744cdf0e10cSrcweir nCommandType = CommandType::COMMAND; 2745cdf0e10cSrcweir } 2746cdf0e10cSrcweir } 2747cdf0e10cSrcweir } 2748cdf0e10cSrcweir catch (Exception&) 2749cdf0e10cSrcweir { 2750cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 2751cdf0e10cSrcweir } 2752cdf0e10cSrcweir } 2753cdf0e10cSrcweir } 2754cdf0e10cSrcweir } 2755cdf0e10cSrcweir } 2756cdf0e10cSrcweir } 2757cdf0e10cSrcweir } 2758cdf0e10cSrcweir 2759cdf0e10cSrcweir String sDataSourceName( getDataSourceAcessor( pConnection ) ); 2760cdf0e10cSrcweir bSuccess = implLoadAnything( sDataSourceName, aName, nCommandType, bEscapeProcessing, pConData->xConnection ); 2761cdf0e10cSrcweir if ( !bSuccess ) 2762cdf0e10cSrcweir { // clean up 2763cdf0e10cSrcweir criticalFail(); 2764cdf0e10cSrcweir } 2765cdf0e10cSrcweir } 2766cdf0e10cSrcweir catch(const SQLException& e) 2767cdf0e10cSrcweir { 2768cdf0e10cSrcweir showError(SQLExceptionInfo(e)); 2769cdf0e10cSrcweir // reset the values 2770cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_DATASOURCENAME,Any()); 2771cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_ACTIVE_CONNECTION,Any()); 2772cdf0e10cSrcweir } 2773cdf0e10cSrcweir catch(WrappedTargetException& e) 2774cdf0e10cSrcweir { 2775cdf0e10cSrcweir SQLException aSql; 2776cdf0e10cSrcweir if(e.TargetException >>= aSql) 2777cdf0e10cSrcweir showError(SQLExceptionInfo(aSql)); 2778cdf0e10cSrcweir else 277907a3d7f1SPedro Giffuni OSL_ENSURE(sal_False, "SbaTableQueryBrowser::implSelect: something strange happened!"); 2780cdf0e10cSrcweir // reset the values 2781cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_DATASOURCENAME,Any()); 2782cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_ACTIVE_CONNECTION,Any()); 2783cdf0e10cSrcweir } 2784cdf0e10cSrcweir catch(Exception&) 2785cdf0e10cSrcweir { 2786cdf0e10cSrcweir // reset the values 2787cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_DATASOURCENAME,Any()); 2788cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_ACTIVE_CONNECTION,Any()); 2789cdf0e10cSrcweir } 2790cdf0e10cSrcweir } 2791cdf0e10cSrcweir return bSuccess; 2792cdf0e10cSrcweir } 2793cdf0e10cSrcweir 2794cdf0e10cSrcweir // ----------------------------------------------------------------------------- 2795cdf0e10cSrcweir SvLBoxEntry* SbaTableQueryBrowser::getEntryFromContainer(const Reference<XNameAccess>& _rxNameAccess) 2796cdf0e10cSrcweir { 2797cdf0e10cSrcweir DBTreeListBox& rListBox = m_pTreeView->getListBox(); 2798cdf0e10cSrcweir SvLBoxEntry* pContainer = NULL; 2799cdf0e10cSrcweir SvLBoxEntry* pDSLoop = rListBox.FirstChild(NULL); 2800cdf0e10cSrcweir while (pDSLoop) 2801cdf0e10cSrcweir { 2802cdf0e10cSrcweir pContainer = rListBox.GetEntry(pDSLoop, CONTAINER_QUERIES); 2803cdf0e10cSrcweir DBTreeListUserData* pQueriesData = static_cast<DBTreeListUserData*>(pContainer->GetUserData()); 2804cdf0e10cSrcweir if ( pQueriesData && pQueriesData->xContainer == _rxNameAccess ) 2805cdf0e10cSrcweir break; 2806cdf0e10cSrcweir 2807cdf0e10cSrcweir pContainer = rListBox.GetEntry(pDSLoop, CONTAINER_TABLES); 2808cdf0e10cSrcweir DBTreeListUserData* pTablesData = static_cast<DBTreeListUserData*>(pContainer->GetUserData()); 2809cdf0e10cSrcweir if ( pTablesData && pTablesData->xContainer == _rxNameAccess ) 2810cdf0e10cSrcweir break; 2811cdf0e10cSrcweir 2812cdf0e10cSrcweir pDSLoop = rListBox.NextSibling(pDSLoop); 2813cdf0e10cSrcweir pContainer = NULL; 2814cdf0e10cSrcweir } 2815cdf0e10cSrcweir return pContainer; 2816cdf0e10cSrcweir } 2817cdf0e10cSrcweir 2818cdf0e10cSrcweir // ------------------------------------------------------------------------- 2819cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::elementInserted( const ContainerEvent& _rEvent ) throw(RuntimeException) 2820cdf0e10cSrcweir { 2821cdf0e10cSrcweir vos::OGuard aSolarGuard( Application::GetSolarMutex() ); 2822cdf0e10cSrcweir 2823cdf0e10cSrcweir Reference< XNameAccess > xNames(_rEvent.Source, UNO_QUERY); 2824cdf0e10cSrcweir // first search for a definition container where we can insert this element 2825cdf0e10cSrcweir 2826cdf0e10cSrcweir SvLBoxEntry* pEntry = getEntryFromContainer(xNames); 2827cdf0e10cSrcweir if(pEntry) // found one 2828cdf0e10cSrcweir { 2829cdf0e10cSrcweir // insert the new entry into the tree 2830cdf0e10cSrcweir DBTreeListUserData* pContainerData = static_cast<DBTreeListUserData*>(pEntry->GetUserData()); 2831cdf0e10cSrcweir OSL_ENSURE(pContainerData, "elementInserted: There must be user data for this type!"); 2832cdf0e10cSrcweir 2833cdf0e10cSrcweir DBTreeListUserData* pNewData = new DBTreeListUserData; 2834cdf0e10cSrcweir sal_Bool bIsTable = etTableContainer == pContainerData->eType; 2835cdf0e10cSrcweir if ( bIsTable ) 2836cdf0e10cSrcweir { 2837cdf0e10cSrcweir _rEvent.Element >>= pNewData->xObjectProperties;// remember the new element 2838cdf0e10cSrcweir pNewData->eType = etTableOrView; 2839cdf0e10cSrcweir } 2840cdf0e10cSrcweir else 2841cdf0e10cSrcweir { 2842cdf0e10cSrcweir if ((sal_Int32)m_pTreeView->getListBox().GetChildCount(pEntry) < ( xNames->getElementNames().getLength() - 1 ) ) 2843cdf0e10cSrcweir { 2844cdf0e10cSrcweir // the item inserts its children on demand, but it has not been expanded yet. So ensure here and 2845cdf0e10cSrcweir // now that it has all items 2846cdf0e10cSrcweir populateTree(xNames, pEntry, etQuery ); 2847cdf0e10cSrcweir } 2848cdf0e10cSrcweir pNewData->eType = etQuery; 2849cdf0e10cSrcweir } 2850cdf0e10cSrcweir implAppendEntry( pEntry, ::comphelper::getString( _rEvent.Accessor ), pNewData, pNewData->eType ); 2851cdf0e10cSrcweir } 2852cdf0e10cSrcweir else 2853cdf0e10cSrcweir SbaXDataBrowserController::elementInserted(_rEvent); 2854cdf0e10cSrcweir } 2855cdf0e10cSrcweir // ------------------------------------------------------------------------- 2856cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::isCurrentlyDisplayedChanged(const String& _sName,SvLBoxEntry* _pContainer) 2857cdf0e10cSrcweir { 2858cdf0e10cSrcweir return m_pCurrentlyDisplayed 2859cdf0e10cSrcweir && getEntryType(m_pCurrentlyDisplayed) == getChildType(_pContainer) 2860cdf0e10cSrcweir && m_pTreeView->getListBox().GetParent(m_pCurrentlyDisplayed) == _pContainer 2861cdf0e10cSrcweir && m_pTreeView->getListBox().GetEntryText(m_pCurrentlyDisplayed) == _sName; 2862cdf0e10cSrcweir } 2863cdf0e10cSrcweir // ------------------------------------------------------------------------- 2864cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::elementRemoved( const ContainerEvent& _rEvent ) throw(RuntimeException) 2865cdf0e10cSrcweir { 2866cdf0e10cSrcweir ::vos::OGuard aSolarGuard(Application::GetSolarMutex()); 2867cdf0e10cSrcweir 2868cdf0e10cSrcweir Reference< XNameAccess > xNames(_rEvent.Source, UNO_QUERY); 2869cdf0e10cSrcweir // get the top-level representing the removed data source 2870cdf0e10cSrcweir // and search for the queries and tables 2871cdf0e10cSrcweir SvLBoxEntry* pContainer = getEntryFromContainer(xNames); 2872cdf0e10cSrcweir if ( pContainer ) 2873cdf0e10cSrcweir { // a query or table has been removed 2874cdf0e10cSrcweir String aName = ::comphelper::getString(_rEvent.Accessor).getStr(); 2875cdf0e10cSrcweir 2876cdf0e10cSrcweir if ( isCurrentlyDisplayedChanged( aName, pContainer) ) 2877cdf0e10cSrcweir { // the element displayed currently has been replaced 2878cdf0e10cSrcweir 2879cdf0e10cSrcweir // we need to remember the old value 2880cdf0e10cSrcweir SvLBoxEntry* pTemp = m_pCurrentlyDisplayed; 2881cdf0e10cSrcweir 2882cdf0e10cSrcweir // unload 2883cdf0e10cSrcweir unloadAndCleanup( sal_False ); // don't dispose the connection 2884cdf0e10cSrcweir 2885cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(pTemp->GetUserData()); 2886cdf0e10cSrcweir pTemp->SetUserData(NULL); 2887cdf0e10cSrcweir delete pData; 2888cdf0e10cSrcweir // the data could be null because we have a table which isn't correct 2889cdf0e10cSrcweir m_pTreeModel->Remove(pTemp); 2890cdf0e10cSrcweir } 2891cdf0e10cSrcweir else 2892cdf0e10cSrcweir { 2893cdf0e10cSrcweir // remove the entry from the model 2894cdf0e10cSrcweir SvLBoxEntry* pChild = m_pTreeModel->FirstChild(pContainer); 2895cdf0e10cSrcweir while(pChild) 2896cdf0e10cSrcweir { 2897cdf0e10cSrcweir if (m_pTreeView->getListBox().GetEntryText(pChild) == aName) 2898cdf0e10cSrcweir { 2899cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(pChild->GetUserData()); 2900cdf0e10cSrcweir pChild->SetUserData(NULL); 2901cdf0e10cSrcweir delete pData; 2902cdf0e10cSrcweir m_pTreeModel->Remove(pChild); 2903cdf0e10cSrcweir break; 2904cdf0e10cSrcweir } 2905cdf0e10cSrcweir pChild = m_pTreeModel->NextSibling(pChild); 2906cdf0e10cSrcweir } 2907cdf0e10cSrcweir } 2908cdf0e10cSrcweir 2909cdf0e10cSrcweir // maybe the object which is part of the document data source has been removed 2910cdf0e10cSrcweir checkDocumentDataSource(); 2911cdf0e10cSrcweir } 2912cdf0e10cSrcweir else 2913cdf0e10cSrcweir SbaXDataBrowserController::elementRemoved(_rEvent); 2914cdf0e10cSrcweir } 2915cdf0e10cSrcweir 2916cdf0e10cSrcweir // ------------------------------------------------------------------------- 2917cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::elementReplaced( const ContainerEvent& _rEvent ) throw(RuntimeException) 2918cdf0e10cSrcweir { 2919cdf0e10cSrcweir ::vos::OGuard aSolarGuard(Application::GetSolarMutex()); 2920cdf0e10cSrcweir 2921cdf0e10cSrcweir Reference< XNameAccess > xNames(_rEvent.Source, UNO_QUERY); 2922cdf0e10cSrcweir SvLBoxEntry* pContainer = getEntryFromContainer(xNames); 2923cdf0e10cSrcweir if ( pContainer ) 2924cdf0e10cSrcweir { // a table or query as been replaced 2925cdf0e10cSrcweir String aName = ::comphelper::getString(_rEvent.Accessor).getStr(); 2926cdf0e10cSrcweir 2927cdf0e10cSrcweir if ( isCurrentlyDisplayedChanged( aName, pContainer) ) 2928cdf0e10cSrcweir { // the element displayed currently has been replaced 2929cdf0e10cSrcweir 2930cdf0e10cSrcweir // we need to remember the old value 2931cdf0e10cSrcweir SvLBoxEntry* pTemp = m_pCurrentlyDisplayed; 2932cdf0e10cSrcweir unloadAndCleanup( sal_False ); // don't dispose the connection 2933cdf0e10cSrcweir 2934cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(pTemp->GetUserData()); 2935cdf0e10cSrcweir if (pData) 2936cdf0e10cSrcweir { 2937cdf0e10cSrcweir if ( etTableOrView == pData->eType ) 2938cdf0e10cSrcweir { // only insert userdata when we have a table because the query is only a commanddefinition object and not a query 2939cdf0e10cSrcweir _rEvent.Element >>= pData->xObjectProperties; // remember the new element 2940cdf0e10cSrcweir } 2941cdf0e10cSrcweir else 2942cdf0e10cSrcweir { 2943cdf0e10cSrcweir pTemp->SetUserData(NULL); 2944cdf0e10cSrcweir delete pData; 2945cdf0e10cSrcweir } 2946cdf0e10cSrcweir } 2947cdf0e10cSrcweir } 2948cdf0e10cSrcweir else 2949cdf0e10cSrcweir { 2950cdf0e10cSrcweir // find the entry for this name 2951cdf0e10cSrcweir SvLBoxEntry* pChild = m_pTreeModel->FirstChild(pContainer); 2952cdf0e10cSrcweir while(pChild) 2953cdf0e10cSrcweir { 2954cdf0e10cSrcweir if (m_pTreeView->getListBox().GetEntryText(pChild) == aName) 2955cdf0e10cSrcweir { 2956cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(pChild->GetUserData()); 2957cdf0e10cSrcweir if (pData) 2958cdf0e10cSrcweir { 2959cdf0e10cSrcweir if ( etTableOrView == pData->eType ) 2960cdf0e10cSrcweir { // only insert userdata when we have a table because the query is only a commanddefinition object and not a query 2961cdf0e10cSrcweir _rEvent.Element >>= pData->xObjectProperties; // remember the new element 2962cdf0e10cSrcweir } 2963cdf0e10cSrcweir else 2964cdf0e10cSrcweir { 2965cdf0e10cSrcweir pChild->SetUserData(NULL); 2966cdf0e10cSrcweir delete pData; 2967cdf0e10cSrcweir } 2968cdf0e10cSrcweir } 2969cdf0e10cSrcweir break; 2970cdf0e10cSrcweir } 2971cdf0e10cSrcweir pChild = m_pTreeModel->NextSibling(pChild); 2972cdf0e10cSrcweir } 2973cdf0e10cSrcweir } 2974cdf0e10cSrcweir 2975cdf0e10cSrcweir // maybe the object which is part of the document data source has been removed 2976cdf0e10cSrcweir checkDocumentDataSource(); 2977cdf0e10cSrcweir } 2978cdf0e10cSrcweir else if (xNames.get() == m_xDatabaseContext.get()) 2979cdf0e10cSrcweir { // a datasource has been replaced in the context 2980cdf0e10cSrcweir DBG_ERROR("SbaTableQueryBrowser::elementReplaced: no support for replaced data sources!"); 2981cdf0e10cSrcweir // very suspicious: the database context should not allow to replace data source, only to register 2982cdf0e10cSrcweir // and revoke them 2983cdf0e10cSrcweir } 2984cdf0e10cSrcweir else 2985cdf0e10cSrcweir SbaXDataBrowserController::elementReplaced(_rEvent); 2986cdf0e10cSrcweir } 2987cdf0e10cSrcweir 2988cdf0e10cSrcweir // ------------------------------------------------------------------------- 2989cdf0e10cSrcweir void SbaTableQueryBrowser::impl_releaseConnection( SharedConnection& _rxConnection ) 2990cdf0e10cSrcweir { 2991cdf0e10cSrcweir // remove as event listener 2992cdf0e10cSrcweir Reference< XComponent > xComponent( _rxConnection, UNO_QUERY ); 2993cdf0e10cSrcweir if ( xComponent.is() ) 2994cdf0e10cSrcweir { 2995cdf0e10cSrcweir Reference< XEventListener > xListener( static_cast< ::cppu::OWeakObject* >( this ), UNO_QUERY ); 2996cdf0e10cSrcweir xComponent->removeEventListener( xListener ); 2997cdf0e10cSrcweir } 2998cdf0e10cSrcweir 2999cdf0e10cSrcweir try 3000cdf0e10cSrcweir { 3001cdf0e10cSrcweir // temporary (hopefully!) hack for #i55274# 3002cdf0e10cSrcweir Reference< XFlushable > xFlush( _rxConnection, UNO_QUERY ); 3003cdf0e10cSrcweir if ( xFlush.is() ) 3004cdf0e10cSrcweir xFlush->flush(); 3005cdf0e10cSrcweir } 3006cdf0e10cSrcweir catch( const Exception& ) 3007cdf0e10cSrcweir { 3008cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 3009cdf0e10cSrcweir } 3010cdf0e10cSrcweir 3011cdf0e10cSrcweir // clear 3012cdf0e10cSrcweir _rxConnection.clear(); 3013cdf0e10cSrcweir // will implicitly dispose if we have the ownership, since xConnection is a SharedConnection 3014cdf0e10cSrcweir } 3015cdf0e10cSrcweir 3016cdf0e10cSrcweir // ------------------------------------------------------------------------- 3017cdf0e10cSrcweir void SbaTableQueryBrowser::disposeConnection( SvLBoxEntry* _pDSEntry ) 3018cdf0e10cSrcweir { 3019cdf0e10cSrcweir DBG_ASSERT( _pDSEntry, "SbaTableQueryBrowser::disposeConnection: invalid entry (NULL)!" ); 3020cdf0e10cSrcweir DBG_ASSERT( impl_isDataSourceEntry( _pDSEntry ), "SbaTableQueryBrowser::disposeConnection: invalid entry (not top-level)!" ); 3021cdf0e10cSrcweir 3022cdf0e10cSrcweir if ( _pDSEntry ) 3023cdf0e10cSrcweir { 3024cdf0e10cSrcweir DBTreeListUserData* pTreeListData = static_cast< DBTreeListUserData* >( _pDSEntry->GetUserData() ); 3025cdf0e10cSrcweir if ( pTreeListData ) 3026cdf0e10cSrcweir impl_releaseConnection( pTreeListData->xConnection ); 3027cdf0e10cSrcweir } 3028cdf0e10cSrcweir } 3029cdf0e10cSrcweir 3030cdf0e10cSrcweir // ------------------------------------------------------------------------- 3031cdf0e10cSrcweir void SbaTableQueryBrowser::closeConnection(SvLBoxEntry* _pDSEntry,sal_Bool _bDisposeConnection) 3032cdf0e10cSrcweir { 3033cdf0e10cSrcweir DBG_ASSERT(_pDSEntry, "SbaTableQueryBrowser::closeConnection: invalid entry (NULL)!"); 3034cdf0e10cSrcweir DBG_ASSERT( impl_isDataSourceEntry( _pDSEntry ), "SbaTableQueryBrowser::closeConnection: invalid entry (not top-level)!"); 3035cdf0e10cSrcweir 3036cdf0e10cSrcweir // if one of the entries of the given DS is displayed currently, unload the form 3037cdf0e10cSrcweir if (m_pCurrentlyDisplayed && (m_pTreeView->getListBox().GetRootLevelParent(m_pCurrentlyDisplayed) == _pDSEntry)) 3038cdf0e10cSrcweir unloadAndCleanup(_bDisposeConnection); 3039cdf0e10cSrcweir 3040cdf0e10cSrcweir // collapse the query/table container 3041cdf0e10cSrcweir for (SvLBoxEntry* pContainers = m_pTreeModel->FirstChild(_pDSEntry); pContainers; pContainers= m_pTreeModel->NextSibling(pContainers)) 3042cdf0e10cSrcweir { 3043cdf0e10cSrcweir SvLBoxEntry* pElements = m_pTreeModel->FirstChild(pContainers); 3044cdf0e10cSrcweir if ( pElements ) 3045cdf0e10cSrcweir m_pTreeView->getListBox().Collapse(pContainers); 3046cdf0e10cSrcweir m_pTreeView->getListBox().EnableExpandHandler(pContainers); 3047cdf0e10cSrcweir // and delete their children (they are connection-relative) 3048cdf0e10cSrcweir for (; pElements; ) 3049cdf0e10cSrcweir { 3050cdf0e10cSrcweir SvLBoxEntry* pRemove = pElements; 3051cdf0e10cSrcweir pElements= m_pTreeModel->NextSibling(pElements); 3052cdf0e10cSrcweir DBTreeListUserData* pData = static_cast<DBTreeListUserData*>(pRemove->GetUserData()); 3053cdf0e10cSrcweir pRemove->SetUserData(NULL); 3054cdf0e10cSrcweir delete pData; 3055cdf0e10cSrcweir m_pTreeModel->Remove(pRemove); 3056cdf0e10cSrcweir } 3057cdf0e10cSrcweir } 3058cdf0e10cSrcweir // collapse the entry itself 3059cdf0e10cSrcweir m_pTreeView->getListBox().Collapse(_pDSEntry); 3060cdf0e10cSrcweir 3061cdf0e10cSrcweir // dispose/reset the connection 3062cdf0e10cSrcweir if ( _bDisposeConnection ) 3063cdf0e10cSrcweir disposeConnection( _pDSEntry ); 3064cdf0e10cSrcweir } 3065cdf0e10cSrcweir 3066cdf0e10cSrcweir // ------------------------------------------------------------------------- 3067cdf0e10cSrcweir void SbaTableQueryBrowser::unloadAndCleanup( sal_Bool _bDisposeConnection ) 3068cdf0e10cSrcweir { 3069cdf0e10cSrcweir if (!m_pCurrentlyDisplayed) 3070cdf0e10cSrcweir // nothing to do 3071cdf0e10cSrcweir return; 3072cdf0e10cSrcweir 3073cdf0e10cSrcweir SvLBoxEntry* pDSEntry = m_pTreeView->getListBox().GetRootLevelParent(m_pCurrentlyDisplayed); 3074cdf0e10cSrcweir 3075cdf0e10cSrcweir // de-select the path for the currently displayed table/query 3076cdf0e10cSrcweir if (m_pCurrentlyDisplayed) 3077cdf0e10cSrcweir { 3078cdf0e10cSrcweir selectPath(m_pCurrentlyDisplayed, sal_False); 3079cdf0e10cSrcweir } 3080cdf0e10cSrcweir m_pCurrentlyDisplayed = NULL; 3081cdf0e10cSrcweir 3082cdf0e10cSrcweir try 3083cdf0e10cSrcweir { 3084cdf0e10cSrcweir // get the active connection. We need to dispose it. 3085cdf0e10cSrcweir Reference< XPropertySet > xRowSetProps(getRowSet(),UNO_QUERY); 3086cdf0e10cSrcweir Reference< XConnection > xConn; 3087cdf0e10cSrcweir xRowSetProps->getPropertyValue(PROPERTY_ACTIVE_CONNECTION) >>= xConn; 3088cdf0e10cSrcweir #if OSL_DEBUG_LEVEL > 1 3089cdf0e10cSrcweir { 3090cdf0e10cSrcweir Reference< XComponent > xComp; 3091cdf0e10cSrcweir ::cppu::extractInterface(xComp, xRowSetProps->getPropertyValue(PROPERTY_ACTIVE_CONNECTION)); 3092cdf0e10cSrcweir } 3093cdf0e10cSrcweir #endif 3094cdf0e10cSrcweir 3095cdf0e10cSrcweir // unload the form 3096cdf0e10cSrcweir Reference< XLoadable > xLoadable = getLoadable(); 3097cdf0e10cSrcweir if (xLoadable->isLoaded()) 3098cdf0e10cSrcweir xLoadable->unload(); 3099cdf0e10cSrcweir 3100cdf0e10cSrcweir // clear the grid control 3101cdf0e10cSrcweir Reference< XNameContainer > xConta(getControlModel(),UNO_QUERY); 3102cdf0e10cSrcweir clearGridColumns(xConta); 3103cdf0e10cSrcweir 3104cdf0e10cSrcweir // dispose the connection 3105cdf0e10cSrcweir if(_bDisposeConnection) 3106cdf0e10cSrcweir disposeConnection( pDSEntry ); 3107cdf0e10cSrcweir } 3108cdf0e10cSrcweir catch(SQLException& e) 3109cdf0e10cSrcweir { 3110cdf0e10cSrcweir showError(SQLExceptionInfo(e)); 3111cdf0e10cSrcweir } 3112cdf0e10cSrcweir catch(WrappedTargetException& e) 3113cdf0e10cSrcweir { 3114cdf0e10cSrcweir SQLException aSql; 3115cdf0e10cSrcweir if(e.TargetException >>= aSql) 3116cdf0e10cSrcweir showError(SQLExceptionInfo(aSql)); 3117cdf0e10cSrcweir else 311807a3d7f1SPedro Giffuni OSL_ENSURE(sal_False, "SbaTableQueryBrowser::unloadAndCleanup: something strange happened!"); 3119cdf0e10cSrcweir } 3120cdf0e10cSrcweir catch(Exception&) 3121cdf0e10cSrcweir { 3122cdf0e10cSrcweir OSL_ENSURE(sal_False, "SbaTableQueryBrowser::unloadAndCleanup: could not reset the form"); 3123cdf0e10cSrcweir } 3124cdf0e10cSrcweir } 3125cdf0e10cSrcweir 3126cdf0e10cSrcweir // ------------------------------------------------------------------------- 3127cdf0e10cSrcweir namespace 3128cdf0e10cSrcweir { 3129cdf0e10cSrcweir Reference< XInterface > lcl_getDataSource( const Reference< XNameAccess >& _rxDatabaseContext, 3130cdf0e10cSrcweir const ::rtl::OUString& _rDataSourceName, const Reference< XConnection >& _rxConnection ) 3131cdf0e10cSrcweir { 3132cdf0e10cSrcweir Reference< XDataSource > xDataSource; 3133cdf0e10cSrcweir try 3134cdf0e10cSrcweir { 3135cdf0e10cSrcweir if ( _rDataSourceName.getLength() && _rxDatabaseContext->hasByName( _rDataSourceName ) ) 3136cdf0e10cSrcweir xDataSource.set( _rxDatabaseContext->getByName( _rDataSourceName ), UNO_QUERY_THROW ); 3137cdf0e10cSrcweir 3138cdf0e10cSrcweir if ( !xDataSource.is() ) 3139cdf0e10cSrcweir { 3140cdf0e10cSrcweir Reference< XChild > xConnAsChild( _rxConnection, UNO_QUERY ); 3141cdf0e10cSrcweir if ( xConnAsChild.is() ) 3142cdf0e10cSrcweir xDataSource.set( xConnAsChild->getParent(), UNO_QUERY_THROW ); 3143cdf0e10cSrcweir } 3144cdf0e10cSrcweir } 3145cdf0e10cSrcweir catch( const Exception& ) 3146cdf0e10cSrcweir { 3147cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 3148cdf0e10cSrcweir } 3149cdf0e10cSrcweir return xDataSource.get(); 3150cdf0e10cSrcweir } 3151cdf0e10cSrcweir } 3152cdf0e10cSrcweir 3153cdf0e10cSrcweir // ------------------------------------------------------------------------- 3154cdf0e10cSrcweir void SbaTableQueryBrowser::impl_initialize() 3155cdf0e10cSrcweir { 3156cdf0e10cSrcweir ::vos::OGuard aGuard(Application::GetSolarMutex()); 3157cdf0e10cSrcweir // doin' a lot of VCL stuff here -> lock the SolarMutex 3158cdf0e10cSrcweir 3159cdf0e10cSrcweir // first initialize the parent 3160cdf0e10cSrcweir SbaXDataBrowserController::impl_initialize(); 3161cdf0e10cSrcweir 3162cdf0e10cSrcweir Reference<XConnection> xForeignConnection; 3163cdf0e10cSrcweir Reference< XFrame > xFrame; 3164cdf0e10cSrcweir 3165cdf0e10cSrcweir ::rtl::OUString aTableName, aCatalogName, aSchemaName; 3166cdf0e10cSrcweir 3167cdf0e10cSrcweir sal_Bool bEsacpeProcessing = sal_True; 3168cdf0e10cSrcweir sal_Int32 nInitialDisplayCommandType = CommandType::COMMAND; 3169cdf0e10cSrcweir ::rtl::OUString sInitialDataSourceName; 3170cdf0e10cSrcweir ::rtl::OUString sInitialCommand; 3171cdf0e10cSrcweir 3172cdf0e10cSrcweir const NamedValueCollection& rArguments( getInitParams() ); 3173cdf0e10cSrcweir 3174cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_DATASOURCENAME, sInitialDataSourceName ); 3175cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_COMMAND_TYPE, nInitialDisplayCommandType ); 3176cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_COMMAND, sInitialCommand ); 3177cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_ACTIVE_CONNECTION, xForeignConnection ); 3178cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_UPDATE_CATALOGNAME, aCatalogName ); 3179cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_UPDATE_SCHEMANAME, aSchemaName ); 3180cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_UPDATE_TABLENAME, aTableName ); 3181cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_ESCAPE_PROCESSING, bEsacpeProcessing ); 3182cdf0e10cSrcweir rArguments.get_ensureType( "Frame", xFrame ); 3183cdf0e10cSrcweir rArguments.get_ensureType( (::rtl::OUString)PROPERTY_SHOWMENU, m_bShowMenu ); 3184cdf0e10cSrcweir 3185cdf0e10cSrcweir // disable the browser if either of ShowTreeViewButton (compatibility name) or EnableBrowser 3186cdf0e10cSrcweir // is present and set to FALSE 3187cdf0e10cSrcweir sal_Bool bDisableBrowser = ( sal_False == rArguments.getOrDefault( "ShowTreeViewButton", sal_True ) ) // compatibility name 3188cdf0e10cSrcweir || ( sal_False == rArguments.getOrDefault( (::rtl::OUString)PROPERTY_ENABLE_BROWSER, sal_True ) ); 3189cdf0e10cSrcweir OSL_ENSURE( !rArguments.has( "ShowTreeViewButton" ), 3190cdf0e10cSrcweir "SbaTableQueryBrowser::impl_initialize: ShowTreeViewButton is superseded by EnableBrowser!" ); 3191cdf0e10cSrcweir m_bEnableBrowser = !bDisableBrowser; 3192cdf0e10cSrcweir 3193cdf0e10cSrcweir // hide the tree view it is disabled in general, or if the settings tell to hide it initially 3194cdf0e10cSrcweir sal_Bool bHideTreeView = ( !m_bEnableBrowser ) 3195cdf0e10cSrcweir || ( sal_False == rArguments.getOrDefault( "ShowTreeView", sal_True ) ) // compatibility name 3196cdf0e10cSrcweir || ( sal_False == rArguments.getOrDefault( (::rtl::OUString)PROPERTY_SHOW_BROWSER, sal_True ) ); 3197cdf0e10cSrcweir OSL_ENSURE( !rArguments.has( "ShowTreeView" ), 3198cdf0e10cSrcweir "SbaTableQueryBrowser::impl_initialize: ShowTreeView is superseded by ShowBrowser!" ); 3199cdf0e10cSrcweir 3200cdf0e10cSrcweir if ( bHideTreeView ) 3201cdf0e10cSrcweir hideExplorer(); 3202cdf0e10cSrcweir else 3203cdf0e10cSrcweir showExplorer(); 3204cdf0e10cSrcweir 3205cdf0e10cSrcweir if ( m_bPreview ) 3206cdf0e10cSrcweir { 3207cdf0e10cSrcweir try 3208cdf0e10cSrcweir { 3209cdf0e10cSrcweir Sequence< ::rtl::OUString> aProperties(5); 3210cdf0e10cSrcweir Sequence< Any> aValues(5); 3211cdf0e10cSrcweir 3212cdf0e10cSrcweir ::rtl::OUString* pStringIter = aProperties.getArray(); 3213cdf0e10cSrcweir Any* pValueIter = aValues.getArray(); 3214cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("AlwaysShowCursor")); 3215cdf0e10cSrcweir *pValueIter++ <<= sal_False; 3216cdf0e10cSrcweir *pStringIter++ = PROPERTY_BORDER; 3217cdf0e10cSrcweir *pValueIter++ <<= sal_Int16(0); 3218cdf0e10cSrcweir 3219cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("HasNavigationBar")); 3220cdf0e10cSrcweir *pValueIter++ <<= sal_False; 3221cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("HasRecordMarker")); 3222cdf0e10cSrcweir *pValueIter++ <<= sal_False; 3223cdf0e10cSrcweir 3224cdf0e10cSrcweir *pStringIter++ = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Tabstop")); 3225cdf0e10cSrcweir *pValueIter++ <<= sal_False; 3226cdf0e10cSrcweir 3227cdf0e10cSrcweir Reference< XMultiPropertySet > xFormMultiSet(getFormComponent(), UNO_QUERY); 3228cdf0e10cSrcweir if ( xFormMultiSet.is() ) 3229cdf0e10cSrcweir xFormMultiSet->setPropertyValues(aProperties, aValues); 3230cdf0e10cSrcweir } 3231cdf0e10cSrcweir catch(Exception) 3232cdf0e10cSrcweir { 3233cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 3234cdf0e10cSrcweir } 3235cdf0e10cSrcweir } 3236cdf0e10cSrcweir 3237cdf0e10cSrcweir // are we loaded into a (sub)frame of an embedded document (i.e. a form belonging to a database 3238cdf0e10cSrcweir // document)? 3239cdf0e10cSrcweir sal_Bool bSubFrameOfEmbeddedDocument = sal_False; 3240cdf0e10cSrcweir if ( xFrame.is() ) 3241cdf0e10cSrcweir { 3242cdf0e10cSrcweir Reference<XFramesSupplier> xSup = xFrame->getCreator(); 3243cdf0e10cSrcweir Reference<XController> xCont = xSup.is() ? xSup->getController() : Reference<XController>(); 3244cdf0e10cSrcweir 3245cdf0e10cSrcweir bSubFrameOfEmbeddedDocument = xCont.is() && ::dbtools::isEmbeddedInDatabase( xCont->getModel(), xForeignConnection ); 3246cdf0e10cSrcweir } 3247cdf0e10cSrcweir 3248cdf0e10cSrcweir // if we have a connection at this point, it was either passed from outside, our 3249cdf0e10cSrcweir // determined from a outer DB document. In both cases, do not dispose it later on. 3250cdf0e10cSrcweir SharedConnection xConnection( xForeignConnection, SharedConnection::NoTakeOwnership ); 3251cdf0e10cSrcweir 3252cdf0e10cSrcweir // should we display all registered databases in the left hand side tree? 3253cdf0e10cSrcweir // or only *one* special? 3254cdf0e10cSrcweir sal_Bool bLimitedTreeEntries = sal_False; 3255cdf0e10cSrcweir // if we're part of a frame which is a secondary frame of a database document, then only 3256cdf0e10cSrcweir // display the database for this document, not all registered ones 3257cdf0e10cSrcweir bLimitedTreeEntries |= bSubFrameOfEmbeddedDocument; 3258cdf0e10cSrcweir // if the tree view is not to be displayed at all, then only display the data source 3259cdf0e10cSrcweir // which was given as initial selection 3260cdf0e10cSrcweir bLimitedTreeEntries |= ( m_bEnableBrowser != sal_True ); 3261cdf0e10cSrcweir 3262cdf0e10cSrcweir if ( bLimitedTreeEntries ) 3263cdf0e10cSrcweir { 3264cdf0e10cSrcweir if ( xConnection.is() ) 3265cdf0e10cSrcweir { 3266cdf0e10cSrcweir startConnectionListening( xConnection ); 3267cdf0e10cSrcweir 3268cdf0e10cSrcweir // if no initial name was given, try to obtain one from the data source 3269cdf0e10cSrcweir if ( !sInitialDataSourceName.getLength() ) 3270cdf0e10cSrcweir { 3271cdf0e10cSrcweir Reference< XChild > xChild( xConnection, UNO_QUERY ); 3272cdf0e10cSrcweir Reference< XPropertySet > xDataSourceProperties; 3273cdf0e10cSrcweir if ( xChild.is() ) 3274cdf0e10cSrcweir xDataSourceProperties = xDataSourceProperties.query( xChild->getParent() ); 3275cdf0e10cSrcweir if ( xDataSourceProperties.is() ) 3276cdf0e10cSrcweir { 3277cdf0e10cSrcweir try 3278cdf0e10cSrcweir { 3279cdf0e10cSrcweir OSL_VERIFY( xDataSourceProperties->getPropertyValue( PROPERTY_NAME ) >>= sInitialDataSourceName ); 3280cdf0e10cSrcweir } 3281cdf0e10cSrcweir catch( const Exception& ) 3282cdf0e10cSrcweir { 3283cdf0e10cSrcweir OSL_ENSURE( sal_False, "SbaTableQueryBrowser::impl_initialize: a connection parent which does not have a 'Name'!??" ); 3284cdf0e10cSrcweir } 3285cdf0e10cSrcweir } 3286cdf0e10cSrcweir } 3287cdf0e10cSrcweir } 3288cdf0e10cSrcweir 3289cdf0e10cSrcweir implAddDatasource( sInitialDataSourceName, xConnection ); 3290cdf0e10cSrcweir m_pTreeView->getListBox().Expand( m_pTreeView->getListBox().First() ); 3291cdf0e10cSrcweir } 3292cdf0e10cSrcweir else 3293cdf0e10cSrcweir initializeTreeModel(); 3294cdf0e10cSrcweir 3295cdf0e10cSrcweir if ( m_bEnableBrowser ) 3296cdf0e10cSrcweir { 3297cdf0e10cSrcweir m_aDocScriptSupport = ::boost::optional< bool >( false ); 3298cdf0e10cSrcweir } 3299cdf0e10cSrcweir else 3300cdf0e10cSrcweir { 3301cdf0e10cSrcweir // we are not used as "browser", but as mere view for a single table/query/command. In particular, 3302cdf0e10cSrcweir // there is a specific database document which we belong to. 3303cdf0e10cSrcweir Reference< XOfficeDatabaseDocument > xDocument( getDataSourceOrModel( 3304cdf0e10cSrcweir lcl_getDataSource( m_xDatabaseContext, sInitialDataSourceName, xConnection ) ), UNO_QUERY ); 3305cdf0e10cSrcweir m_aDocScriptSupport = ::boost::optional< bool >( Reference< XEmbeddedScripts >( xDocument, UNO_QUERY ).is() ); 3306cdf0e10cSrcweir } 3307cdf0e10cSrcweir 3308cdf0e10cSrcweir if ( implSelect( sInitialDataSourceName, sInitialCommand, nInitialDisplayCommandType, bEsacpeProcessing, xConnection, sal_True ) ) 3309cdf0e10cSrcweir { 3310cdf0e10cSrcweir try 3311cdf0e10cSrcweir { 3312cdf0e10cSrcweir Reference< XPropertySet > xRowSetProps(getRowSet(), UNO_QUERY); 3313cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_UPDATE_CATALOGNAME,makeAny(aCatalogName)); 3314cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_UPDATE_SCHEMANAME,makeAny(aSchemaName)); 3315cdf0e10cSrcweir xRowSetProps->setPropertyValue(PROPERTY_UPDATE_TABLENAME,makeAny(aTableName)); 3316cdf0e10cSrcweir 3317cdf0e10cSrcweir } 3318cdf0e10cSrcweir catch(const Exception&) 3319cdf0e10cSrcweir { 3320cdf0e10cSrcweir OSL_ENSURE(sal_False, "SbaTableQueryBrowser::impl_initialize: could not set the update related names!"); 3321cdf0e10cSrcweir } 3322cdf0e10cSrcweir } 3323cdf0e10cSrcweir 3324cdf0e10cSrcweir InvalidateAll(); 3325cdf0e10cSrcweir } 3326cdf0e10cSrcweir 3327cdf0e10cSrcweir // ------------------------------------------------------------------------- 3328cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::haveExplorer() const 3329cdf0e10cSrcweir { 3330cdf0e10cSrcweir return m_pTreeView && m_pTreeView->IsVisible(); 3331cdf0e10cSrcweir } 3332cdf0e10cSrcweir 3333cdf0e10cSrcweir // ------------------------------------------------------------------------- 3334cdf0e10cSrcweir void SbaTableQueryBrowser::hideExplorer() 3335cdf0e10cSrcweir { 3336cdf0e10cSrcweir if (!haveExplorer()) 3337cdf0e10cSrcweir return; 3338cdf0e10cSrcweir if (!getBrowserView()) 3339cdf0e10cSrcweir return; 3340cdf0e10cSrcweir 3341cdf0e10cSrcweir m_pTreeView->Hide(); 3342cdf0e10cSrcweir m_pSplitter->Hide(); 3343cdf0e10cSrcweir getBrowserView()->Resize(); 3344cdf0e10cSrcweir 3345cdf0e10cSrcweir InvalidateFeature(ID_BROWSER_EXPLORER); 3346cdf0e10cSrcweir } 3347cdf0e10cSrcweir 3348cdf0e10cSrcweir // ------------------------------------------------------------------------- 3349cdf0e10cSrcweir void SbaTableQueryBrowser::showExplorer() 3350cdf0e10cSrcweir { 3351cdf0e10cSrcweir if (haveExplorer()) 3352cdf0e10cSrcweir return; 3353cdf0e10cSrcweir 3354cdf0e10cSrcweir if (!getBrowserView()) 3355cdf0e10cSrcweir return; 3356cdf0e10cSrcweir 3357cdf0e10cSrcweir m_pTreeView->Show(); 3358cdf0e10cSrcweir m_pSplitter->Show(); 3359cdf0e10cSrcweir getBrowserView()->Resize(); 3360cdf0e10cSrcweir 3361cdf0e10cSrcweir InvalidateFeature(ID_BROWSER_EXPLORER); 3362cdf0e10cSrcweir } 3363cdf0e10cSrcweir 3364cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3365cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::ensureConnection(SvLBoxEntry* _pAnyEntry, SharedConnection& _rConnection) 3366cdf0e10cSrcweir { 3367cdf0e10cSrcweir SvLBoxEntry* pDSEntry = m_pTreeView->getListBox().GetRootLevelParent(_pAnyEntry); 3368cdf0e10cSrcweir DBTreeListUserData* pDSData = 3369cdf0e10cSrcweir pDSEntry 3370cdf0e10cSrcweir ? static_cast<DBTreeListUserData*>(pDSEntry->GetUserData()) 3371cdf0e10cSrcweir : NULL; 3372cdf0e10cSrcweir 3373cdf0e10cSrcweir return ensureConnection( pDSEntry, pDSData, _rConnection ); 3374cdf0e10cSrcweir } 3375cdf0e10cSrcweir 3376cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3377cdf0e10cSrcweir ::std::auto_ptr< ImageProvider > SbaTableQueryBrowser::getImageProviderFor( SvLBoxEntry* _pAnyEntry ) 3378cdf0e10cSrcweir { 3379cdf0e10cSrcweir ::std::auto_ptr< ImageProvider > pImageProvider( new ImageProvider ); 3380cdf0e10cSrcweir SharedConnection xConnection; 3381cdf0e10cSrcweir if ( getExistentConnectionFor( _pAnyEntry, xConnection ) ) 3382cdf0e10cSrcweir pImageProvider.reset( new ImageProvider( xConnection ) ); 3383cdf0e10cSrcweir return pImageProvider; 3384cdf0e10cSrcweir } 3385cdf0e10cSrcweir 3386cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3387cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::getExistentConnectionFor( SvLBoxEntry* _pAnyEntry, SharedConnection& _rConnection ) 3388cdf0e10cSrcweir { 3389cdf0e10cSrcweir SvLBoxEntry* pDSEntry = m_pTreeView->getListBox().GetRootLevelParent( _pAnyEntry ); 3390cdf0e10cSrcweir DBTreeListUserData* pDSData = 3391cdf0e10cSrcweir pDSEntry 3392cdf0e10cSrcweir ? static_cast< DBTreeListUserData* >( pDSEntry->GetUserData() ) 3393cdf0e10cSrcweir : NULL; 3394cdf0e10cSrcweir if ( pDSData ) 3395cdf0e10cSrcweir _rConnection = pDSData->xConnection; 3396cdf0e10cSrcweir return _rConnection.is(); 3397cdf0e10cSrcweir } 3398cdf0e10cSrcweir 3399cdf0e10cSrcweir #ifdef DBG_UTIL 3400cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3401cdf0e10cSrcweir bool SbaTableQueryBrowser::impl_isDataSourceEntry( SvLBoxEntry* _pEntry ) const 3402cdf0e10cSrcweir { 3403cdf0e10cSrcweir return m_pTreeModel->GetRootLevelParent( _pEntry ) == _pEntry; 3404cdf0e10cSrcweir } 3405cdf0e10cSrcweir #endif 3406cdf0e10cSrcweir 3407cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3408cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::ensureConnection( SvLBoxEntry* _pDSEntry, void* pDSData, SharedConnection& _rConnection ) 3409cdf0e10cSrcweir { 3410cdf0e10cSrcweir DBG_ASSERT( impl_isDataSourceEntry( _pDSEntry ), "SbaTableQueryBrowser::ensureConnection: this entry does not denote a data source!" ); 3411cdf0e10cSrcweir if(_pDSEntry) 3412cdf0e10cSrcweir { 3413cdf0e10cSrcweir DBTreeListUserData* pTreeListData = static_cast<DBTreeListUserData*>(pDSData); 3414cdf0e10cSrcweir ::rtl::OUString aDSName = GetEntryText(_pDSEntry); 3415cdf0e10cSrcweir 3416cdf0e10cSrcweir if ( pTreeListData ) 3417cdf0e10cSrcweir _rConnection = pTreeListData->xConnection; 3418cdf0e10cSrcweir 3419cdf0e10cSrcweir if ( !_rConnection.is() && pTreeListData ) 3420cdf0e10cSrcweir { 3421cdf0e10cSrcweir // show the "connecting to ..." status 3422cdf0e10cSrcweir String sConnecting(ModuleRes(STR_CONNECTING_DATASOURCE)); 3423cdf0e10cSrcweir sConnecting.SearchAndReplaceAscii("$name$", aDSName); 3424cdf0e10cSrcweir BrowserViewStatusDisplay aShowStatus(static_cast<UnoDataBrowserView*>(getView()), sConnecting); 3425cdf0e10cSrcweir 3426cdf0e10cSrcweir // build a string showing context information in case of error 3427cdf0e10cSrcweir String sConnectingContext( ModuleRes( STR_COULDNOTCONNECT_DATASOURCE ) ); 3428cdf0e10cSrcweir sConnectingContext.SearchAndReplaceAscii("$name$", aDSName); 3429cdf0e10cSrcweir 3430cdf0e10cSrcweir // connect 3431cdf0e10cSrcweir _rConnection.reset( 3432cdf0e10cSrcweir connect( getDataSourceAcessor( _pDSEntry ), sConnectingContext, NULL ), 3433cdf0e10cSrcweir SharedConnection::TakeOwnership 3434cdf0e10cSrcweir ); 3435cdf0e10cSrcweir 3436cdf0e10cSrcweir // remember the connection 3437cdf0e10cSrcweir pTreeListData->xConnection = _rConnection; 3438cdf0e10cSrcweir } 3439cdf0e10cSrcweir } 3440cdf0e10cSrcweir 3441cdf0e10cSrcweir return _rConnection.is(); 3442cdf0e10cSrcweir } 3443cdf0e10cSrcweir 3444cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3445cdf0e10cSrcweir IMPL_LINK( SbaTableQueryBrowser, OnTreeEntryCompare, const SvSortData*, _pSortData ) 3446cdf0e10cSrcweir { 3447cdf0e10cSrcweir SvLBoxEntry* pLHS = static_cast<SvLBoxEntry*>(_pSortData->pLeft); 3448cdf0e10cSrcweir SvLBoxEntry* pRHS = static_cast<SvLBoxEntry*>(_pSortData->pRight); 3449cdf0e10cSrcweir DBG_ASSERT(pLHS && pRHS, "SbaTableQueryBrowser::OnTreeEntryCompare: invalid tree entries!"); 3450cdf0e10cSrcweir // we want the table entry and the end so we have to do a check 3451cdf0e10cSrcweir 3452cdf0e10cSrcweir if (isContainer(pRHS)) 3453cdf0e10cSrcweir { 3454cdf0e10cSrcweir // don't use getEntryType (directly or indirecly) for the LHS: 3455*30acf5e8Spfg // LHS is currently being inserted, so it is not "completely valid" at the moment 3456cdf0e10cSrcweir 3457cdf0e10cSrcweir const EntryType eRight = getEntryType(pRHS); 3458cdf0e10cSrcweir if (etTableContainer == eRight) 3459cdf0e10cSrcweir // every other container should be placed _before_ the bookmark container 3460cdf0e10cSrcweir return -1; 3461cdf0e10cSrcweir 3462cdf0e10cSrcweir const String sLeft = m_pTreeView->getListBox().GetEntryText(pLHS); 3463cdf0e10cSrcweir 3464cdf0e10cSrcweir EntryType eLeft = etTableContainer; 3465cdf0e10cSrcweir if (String(ModuleRes(RID_STR_TABLES_CONTAINER)) == sLeft) 3466cdf0e10cSrcweir eLeft = etTableContainer; 3467cdf0e10cSrcweir else if (String(ModuleRes(RID_STR_QUERIES_CONTAINER)) == sLeft) 3468cdf0e10cSrcweir eLeft = etQueryContainer; 3469cdf0e10cSrcweir 3470cdf0e10cSrcweir if ( eLeft == eRight ) 3471cdf0e10cSrcweir return COMPARE_EQUAL; 3472cdf0e10cSrcweir 3473cdf0e10cSrcweir if ( ( eLeft == etTableContainer ) && ( eRight == etQueryContainer ) ) 3474cdf0e10cSrcweir return COMPARE_GREATER; 3475cdf0e10cSrcweir 3476cdf0e10cSrcweir if ( ( eLeft == etQueryContainer ) && ( eRight == etTableContainer ) ) 3477cdf0e10cSrcweir return COMPARE_LESS; 3478cdf0e10cSrcweir 3479cdf0e10cSrcweir OSL_ENSURE( false, "SbaTableQueryBrowser::OnTreeEntryCompare: unexpected case!" ); 3480cdf0e10cSrcweir return COMPARE_EQUAL; 3481cdf0e10cSrcweir } 3482cdf0e10cSrcweir 3483cdf0e10cSrcweir SvLBoxString* pLeftTextItem = static_cast<SvLBoxString*>(pLHS->GetFirstItem(SV_ITEM_ID_LBOXSTRING)); 3484cdf0e10cSrcweir SvLBoxString* pRightTextItem = static_cast<SvLBoxString*>(pRHS->GetFirstItem(SV_ITEM_ID_LBOXSTRING)); 3485cdf0e10cSrcweir DBG_ASSERT(pLeftTextItem && pRightTextItem, "SbaTableQueryBrowser::OnTreeEntryCompare: invalid text items!"); 3486cdf0e10cSrcweir 3487cdf0e10cSrcweir String sLeftText = pLeftTextItem->GetText(); 3488cdf0e10cSrcweir String sRightText = pRightTextItem->GetText(); 3489cdf0e10cSrcweir 3490cdf0e10cSrcweir sal_Int32 nCompareResult = 0; // equal by default 3491cdf0e10cSrcweir 3492cdf0e10cSrcweir if (m_xCollator.is()) 3493cdf0e10cSrcweir { 3494cdf0e10cSrcweir try 3495cdf0e10cSrcweir { 3496cdf0e10cSrcweir nCompareResult = m_xCollator->compareString(sLeftText, sRightText); 3497cdf0e10cSrcweir } 3498cdf0e10cSrcweir catch(Exception&) 3499cdf0e10cSrcweir { 3500cdf0e10cSrcweir } 3501cdf0e10cSrcweir } 3502cdf0e10cSrcweir else 3503cdf0e10cSrcweir // default behaviour if we do not have a collator -> do the simple string compare 3504cdf0e10cSrcweir nCompareResult = sLeftText.CompareTo(sRightText); 3505cdf0e10cSrcweir 3506cdf0e10cSrcweir return nCompareResult; 3507cdf0e10cSrcweir } 3508cdf0e10cSrcweir 3509cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3510cdf0e10cSrcweir void SbaTableQueryBrowser::implAdministrate( SvLBoxEntry* _pApplyTo ) 3511cdf0e10cSrcweir { 3512cdf0e10cSrcweir OSL_PRECOND( _pApplyTo, "SbaTableQueryBrowser::implAdministrate: illegal entry!" ); 3513cdf0e10cSrcweir if ( !_pApplyTo ) 3514cdf0e10cSrcweir return; 3515cdf0e10cSrcweir 3516cdf0e10cSrcweir try 3517cdf0e10cSrcweir { 3518cdf0e10cSrcweir // get the desktop object 3519cdf0e10cSrcweir sal_Int32 nFrameSearchFlag = FrameSearchFlag::ALL | FrameSearchFlag::GLOBAL ; 3520cdf0e10cSrcweir Reference< XComponentLoader > xFrameLoader(getORB()->createInstance(SERVICE_FRAME_DESKTOP),UNO_QUERY); 3521cdf0e10cSrcweir 3522cdf0e10cSrcweir if ( xFrameLoader.is() ) 3523cdf0e10cSrcweir { 3524cdf0e10cSrcweir // the initial selection 3525cdf0e10cSrcweir SvLBoxEntry* pTopLevelSelected = _pApplyTo; 3526cdf0e10cSrcweir while (pTopLevelSelected && m_pTreeView->getListBox().GetParent(pTopLevelSelected)) 3527cdf0e10cSrcweir pTopLevelSelected = m_pTreeView->getListBox().GetParent(pTopLevelSelected); 3528cdf0e10cSrcweir ::rtl::OUString sInitialSelection; 3529cdf0e10cSrcweir if (pTopLevelSelected) 3530cdf0e10cSrcweir sInitialSelection = getDataSourceAcessor( pTopLevelSelected ); 3531cdf0e10cSrcweir 3532cdf0e10cSrcweir Reference< XDataSource > xDataSource( getDataSourceByName( sInitialSelection, getView(), getORB(), NULL ) ); 3533cdf0e10cSrcweir Reference< XModel > xDocumentModel( getDataSourceOrModel( xDataSource ), UNO_QUERY ); 3534cdf0e10cSrcweir 3535cdf0e10cSrcweir if ( xDocumentModel.is() ) 3536cdf0e10cSrcweir { 3537cdf0e10cSrcweir Reference< XInteractionHandler > xInteractionHandler( 3538cdf0e10cSrcweir getORB()->createInstance( 3539cdf0e10cSrcweir ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "com.sun.star.task.InteractionHandler" ) ) ), 3540cdf0e10cSrcweir UNO_QUERY ); 3541cdf0e10cSrcweir OSL_ENSURE( xInteractionHandler.is(), "SbaTableQueryBrowser::implAdministrate: no interaction handler available!" ); 3542cdf0e10cSrcweir 3543cdf0e10cSrcweir ::comphelper::NamedValueCollection aLoadArgs; 3544cdf0e10cSrcweir aLoadArgs.put( "Model", xDocumentModel ); 3545cdf0e10cSrcweir aLoadArgs.put( "InteractionHandler", xInteractionHandler ); 3546cdf0e10cSrcweir aLoadArgs.put( "MacroExecutionMode", MacroExecMode::USE_CONFIG ); 3547cdf0e10cSrcweir 3548cdf0e10cSrcweir Sequence< PropertyValue > aLoadArgPV; 3549cdf0e10cSrcweir aLoadArgs >>= aLoadArgPV; 3550cdf0e10cSrcweir 3551cdf0e10cSrcweir xFrameLoader->loadComponentFromURL( 3552cdf0e10cSrcweir xDocumentModel->getURL(), 3553cdf0e10cSrcweir ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("_default")), 3554cdf0e10cSrcweir nFrameSearchFlag, 3555cdf0e10cSrcweir aLoadArgPV 3556cdf0e10cSrcweir ); 3557cdf0e10cSrcweir } 3558cdf0e10cSrcweir } 3559cdf0e10cSrcweir } 3560cdf0e10cSrcweir catch( const Exception& ) 3561cdf0e10cSrcweir { 3562cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 3563cdf0e10cSrcweir } 3564cdf0e10cSrcweir } 3565cdf0e10cSrcweir 3566cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3567cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::requestQuickHelp( const SvLBoxEntry* _pEntry, String& _rText ) const 3568cdf0e10cSrcweir { 3569cdf0e10cSrcweir const DBTreeListUserData* pData = static_cast< const DBTreeListUserData* >( _pEntry->GetUserData() ); 3570cdf0e10cSrcweir if ( ( pData->eType == etDatasource ) && pData->sAccessor.Len() ) 3571cdf0e10cSrcweir { 3572cdf0e10cSrcweir _rText = ::svt::OFileNotation( pData->sAccessor ).get( ::svt::OFileNotation::N_SYSTEM ); 3573cdf0e10cSrcweir return sal_True; 3574cdf0e10cSrcweir } 3575cdf0e10cSrcweir return sal_False; 3576cdf0e10cSrcweir } 3577cdf0e10cSrcweir 3578cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3579cdf0e10cSrcweir PopupMenu* SbaTableQueryBrowser::getContextMenu( Control& _rControl ) const 3580cdf0e10cSrcweir { 3581cdf0e10cSrcweir OSL_PRECOND( &m_pTreeView->getListBox() == &_rControl, 3582cdf0e10cSrcweir "SbaTableQueryBrowser::getContextMenu: where does this come from?" ); 3583cdf0e10cSrcweir if ( &m_pTreeView->getListBox() != &_rControl ) 3584cdf0e10cSrcweir return NULL; 3585cdf0e10cSrcweir 3586cdf0e10cSrcweir return new PopupMenu( ModuleRes( MENU_BROWSER_DEFAULTCONTEXT ) ); 3587cdf0e10cSrcweir } 3588cdf0e10cSrcweir 3589cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3590cdf0e10cSrcweir IController& SbaTableQueryBrowser::getCommandController() 3591cdf0e10cSrcweir { 3592cdf0e10cSrcweir return *this; 3593cdf0e10cSrcweir } 3594cdf0e10cSrcweir 3595cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3596cdf0e10cSrcweir ::cppu::OInterfaceContainerHelper* SbaTableQueryBrowser::getContextMenuInterceptors() 3597cdf0e10cSrcweir { 3598cdf0e10cSrcweir return &m_aContextMenuInterceptors; 3599cdf0e10cSrcweir } 3600cdf0e10cSrcweir 3601cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3602cdf0e10cSrcweir Any SbaTableQueryBrowser::getCurrentSelection( Control& _rControl ) const 3603cdf0e10cSrcweir { 3604cdf0e10cSrcweir OSL_PRECOND( &m_pTreeView->getListBox() == &_rControl, 3605cdf0e10cSrcweir "SbaTableQueryBrowser::getCurrentSelection: where does this come from?" ); 3606cdf0e10cSrcweir 3607cdf0e10cSrcweir if ( &m_pTreeView->getListBox() != &_rControl ) 3608cdf0e10cSrcweir return Any(); 3609cdf0e10cSrcweir 3610cdf0e10cSrcweir SvLBoxEntry* pSelected = m_pTreeView->getListBox().FirstSelected(); 3611cdf0e10cSrcweir if ( !pSelected ) 3612cdf0e10cSrcweir return Any(); 3613cdf0e10cSrcweir 3614cdf0e10cSrcweir OSL_ENSURE( m_pTreeView->getListBox().NextSelected( pSelected ) == NULL, 3615cdf0e10cSrcweir "SbaTableQueryBrowser::getCurrentSelection: single-selection is expected here!" ); 3616cdf0e10cSrcweir 3617cdf0e10cSrcweir NamedDatabaseObject aSelectedObject; 3618cdf0e10cSrcweir DBTreeListUserData* pData = static_cast< DBTreeListUserData* >( pSelected->GetUserData() ); 3619cdf0e10cSrcweir aSelectedObject.Type = static_cast< sal_Int32 >( pData->eType ); 3620cdf0e10cSrcweir 3621cdf0e10cSrcweir switch ( aSelectedObject.Type ) 3622cdf0e10cSrcweir { 3623cdf0e10cSrcweir case DatabaseObject::QUERY: 3624cdf0e10cSrcweir case DatabaseObject::TABLE: 3625cdf0e10cSrcweir aSelectedObject.Name = m_pTreeView->getListBox().GetEntryText( pSelected ); 3626cdf0e10cSrcweir break; 3627cdf0e10cSrcweir 3628cdf0e10cSrcweir case DatabaseObjectContainer::DATA_SOURCE: 3629cdf0e10cSrcweir case DatabaseObjectContainer::QUERIES: 3630cdf0e10cSrcweir case DatabaseObjectContainer::TABLES: 3631cdf0e10cSrcweir aSelectedObject.Name = getDataSourceAcessor( pSelected ); 3632cdf0e10cSrcweir break; 3633cdf0e10cSrcweir 3634cdf0e10cSrcweir default: 3635cdf0e10cSrcweir OSL_ENSURE( false, "SbaTableQueryBrowser::getCurrentSelection: invalid (unexpected) object type!" ); 3636cdf0e10cSrcweir break; 3637cdf0e10cSrcweir } 3638cdf0e10cSrcweir 3639cdf0e10cSrcweir return makeAny( aSelectedObject ); 3640cdf0e10cSrcweir } 3641cdf0e10cSrcweir 3642cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3643cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::implGetQuerySignature( ::rtl::OUString& _rCommand, sal_Bool& _bEscapeProcessing ) 3644cdf0e10cSrcweir { 3645cdf0e10cSrcweir _rCommand = ::rtl::OUString(); 3646cdf0e10cSrcweir _bEscapeProcessing = sal_False; 3647cdf0e10cSrcweir 3648cdf0e10cSrcweir try 3649cdf0e10cSrcweir { 3650cdf0e10cSrcweir // ontain the dss (data source signature) of the form 3651cdf0e10cSrcweir ::rtl::OUString sDataSourceName; 3652cdf0e10cSrcweir ::rtl::OUString sCommand; 3653cdf0e10cSrcweir sal_Int32 nCommandType = CommandType::COMMAND; 3654cdf0e10cSrcweir Reference< XPropertySet > xRowsetProps( getRowSet(), UNO_QUERY ); 3655cdf0e10cSrcweir ODataAccessDescriptor aDesc( xRowsetProps ); 3656cdf0e10cSrcweir sDataSourceName = aDesc.getDataSource(); 3657cdf0e10cSrcweir aDesc[ daCommand ] >>= sCommand; 3658cdf0e10cSrcweir aDesc[ daCommandType ] >>= nCommandType; 3659cdf0e10cSrcweir 3660cdf0e10cSrcweir // do we need to do anything? 3661cdf0e10cSrcweir if ( CommandType::QUERY != nCommandType ) 3662cdf0e10cSrcweir return sal_False; 3663cdf0e10cSrcweir 3664cdf0e10cSrcweir // get the query object 3665cdf0e10cSrcweir Reference< XQueryDefinitionsSupplier > xSuppQueries; 3666cdf0e10cSrcweir Reference< XNameAccess > xQueries; 3667cdf0e10cSrcweir Reference< XPropertySet > xQuery; 3668cdf0e10cSrcweir m_xDatabaseContext->getByName( sDataSourceName ) >>= xSuppQueries; 3669cdf0e10cSrcweir if ( xSuppQueries.is() ) 3670cdf0e10cSrcweir xQueries = xSuppQueries->getQueryDefinitions(); 3671cdf0e10cSrcweir if ( xQueries.is() ) 3672cdf0e10cSrcweir xQueries->getByName( sCommand ) >>= xQuery; 3673cdf0e10cSrcweir OSL_ENSURE( xQuery.is(), "SbaTableQueryBrowser::implGetQuerySignature: could not retrieve the query object!" ); 3674cdf0e10cSrcweir 3675cdf0e10cSrcweir // get the two properties we need 3676cdf0e10cSrcweir if ( xQuery.is() ) 3677cdf0e10cSrcweir { 3678cdf0e10cSrcweir xQuery->getPropertyValue( PROPERTY_COMMAND ) >>= _rCommand; 3679cdf0e10cSrcweir _bEscapeProcessing = ::cppu::any2bool( xQuery->getPropertyValue( PROPERTY_ESCAPE_PROCESSING ) ); 3680cdf0e10cSrcweir return sal_True; 3681cdf0e10cSrcweir } 3682cdf0e10cSrcweir } 3683cdf0e10cSrcweir catch( const Exception& ) 3684cdf0e10cSrcweir { 3685cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 3686cdf0e10cSrcweir } 3687cdf0e10cSrcweir 3688cdf0e10cSrcweir return sal_False; 3689cdf0e10cSrcweir } 3690cdf0e10cSrcweir //------------------------------------------------------------------------------ 3691cdf0e10cSrcweir void SbaTableQueryBrowser::frameAction(const ::com::sun::star::frame::FrameActionEvent& aEvent) throw( RuntimeException ) 3692cdf0e10cSrcweir { 3693cdf0e10cSrcweir if (aEvent.Frame == m_xCurrentFrameParent) 3694cdf0e10cSrcweir { 3695cdf0e10cSrcweir if(aEvent.Action == FrameAction_COMPONENT_DETACHING) 3696cdf0e10cSrcweir implRemoveStatusListeners(); 3697cdf0e10cSrcweir else if (aEvent.Action == FrameAction_COMPONENT_REATTACHED) 3698cdf0e10cSrcweir connectExternalDispatches(); 3699cdf0e10cSrcweir } 3700cdf0e10cSrcweir else 3701cdf0e10cSrcweir SbaXDataBrowserController::frameAction(aEvent); 3702cdf0e10cSrcweir 3703cdf0e10cSrcweir } 3704cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3705cdf0e10cSrcweir void SbaTableQueryBrowser::clearGridColumns(const Reference< XNameContainer >& _xColContainer) 3706cdf0e10cSrcweir { 3707cdf0e10cSrcweir // first we have to clear the grid 3708cdf0e10cSrcweir Sequence< ::rtl::OUString > aNames = _xColContainer->getElementNames(); 3709cdf0e10cSrcweir const ::rtl::OUString* pIter = aNames.getConstArray(); 3710cdf0e10cSrcweir const ::rtl::OUString* pEnd = pIter + aNames.getLength(); 3711cdf0e10cSrcweir Reference< XInterface > xColumn; 3712cdf0e10cSrcweir for (; pIter != pEnd;++pIter) 3713cdf0e10cSrcweir { 3714cdf0e10cSrcweir _xColContainer->getByName(*pIter) >>= xColumn; 3715cdf0e10cSrcweir _xColContainer->removeByName(*pIter); 3716cdf0e10cSrcweir ::comphelper::disposeComponent(xColumn); 3717cdf0e10cSrcweir } 3718cdf0e10cSrcweir } 3719cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3720cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::isHiContrast() const 3721cdf0e10cSrcweir { 3722cdf0e10cSrcweir sal_Bool bRet = sal_False; 3723cdf0e10cSrcweir if ( m_pTreeView ) 3724cdf0e10cSrcweir bRet = m_pTreeView->getListBox().GetSettings().GetStyleSettings().GetHighContrastMode(); 3725cdf0e10cSrcweir return bRet; 3726cdf0e10cSrcweir } 3727cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3728cdf0e10cSrcweir void SbaTableQueryBrowser::loadMenu(const Reference< XFrame >& _xFrame) 3729cdf0e10cSrcweir { 3730cdf0e10cSrcweir if ( m_bShowMenu ) 3731cdf0e10cSrcweir { 3732cdf0e10cSrcweir OGenericUnoController::loadMenu(_xFrame); 3733cdf0e10cSrcweir } 3734cdf0e10cSrcweir else if ( !m_bPreview ) 3735cdf0e10cSrcweir { 3736cdf0e10cSrcweir Reference< ::com::sun::star::frame::XLayoutManager > xLayoutManager = getLayoutManager(_xFrame); 3737cdf0e10cSrcweir 3738cdf0e10cSrcweir if ( xLayoutManager.is() ) 3739cdf0e10cSrcweir { 3740cdf0e10cSrcweir xLayoutManager->lock(); 3741cdf0e10cSrcweir xLayoutManager->createElement( rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "private:resource/toolbar/toolbar" ))); 3742cdf0e10cSrcweir xLayoutManager->unlock(); 3743cdf0e10cSrcweir xLayoutManager->doLayout(); 3744cdf0e10cSrcweir } 3745cdf0e10cSrcweir onLoadedMenu( xLayoutManager ); 3746cdf0e10cSrcweir } 3747cdf0e10cSrcweir } 3748cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3749cdf0e10cSrcweir ::rtl::OUString SbaTableQueryBrowser::getPrivateTitle() const 3750cdf0e10cSrcweir { 3751cdf0e10cSrcweir ::rtl::OUString sTitle; 3752cdf0e10cSrcweir if ( m_pCurrentlyDisplayed ) 3753cdf0e10cSrcweir { 3754cdf0e10cSrcweir SvLBoxEntry* pContainer = m_pTreeModel->GetParent(m_pCurrentlyDisplayed); 3755cdf0e10cSrcweir // get the entry for the datasource 3756cdf0e10cSrcweir SvLBoxEntry* pConnection = implGetConnectionEntry(pContainer); 3757cdf0e10cSrcweir ::rtl::OUString sName = m_pTreeView->getListBox().GetEntryText(m_pCurrentlyDisplayed); 3758cdf0e10cSrcweir sTitle = GetEntryText( pConnection ); 3759cdf0e10cSrcweir INetURLObject aURL(sTitle); 3760cdf0e10cSrcweir if ( aURL.GetProtocol() != INET_PROT_NOT_VALID ) 3761cdf0e10cSrcweir sTitle = aURL.getBase(INetURLObject::LAST_SEGMENT,true,INetURLObject::DECODE_WITH_CHARSET); 3762cdf0e10cSrcweir if ( sName.getLength() ) 3763cdf0e10cSrcweir { 3764cdf0e10cSrcweir sName += ::rtl::OUString::createFromAscii(" - "); 3765cdf0e10cSrcweir sName += sTitle; 3766cdf0e10cSrcweir sTitle = sName; 3767cdf0e10cSrcweir } 3768cdf0e10cSrcweir } 3769cdf0e10cSrcweir 3770cdf0e10cSrcweir return sTitle; 3771cdf0e10cSrcweir } 3772cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3773cdf0e10cSrcweir sal_Bool SbaTableQueryBrowser::preReloadForm() 3774cdf0e10cSrcweir { 3775cdf0e10cSrcweir sal_Bool bIni = sal_False; 3776cdf0e10cSrcweir if ( !m_pCurrentlyDisplayed ) 3777cdf0e10cSrcweir { 3778cdf0e10cSrcweir // switch the grid to design mode while loading 3779cdf0e10cSrcweir getBrowserView()->getGridControl()->setDesignMode(sal_True); 3780cdf0e10cSrcweir // we had an invalid statement so we need to connect the column models 3781cdf0e10cSrcweir Reference<XPropertySet> xRowSetProps(getRowSet(),UNO_QUERY); 3782cdf0e10cSrcweir ::svx::ODataAccessDescriptor aDesc(xRowSetProps); 3783cdf0e10cSrcweir // extract the props 3784cdf0e10cSrcweir ::rtl::OUString sDataSource; 3785cdf0e10cSrcweir ::rtl::OUString sCommand; 3786cdf0e10cSrcweir sal_Int32 nCommandType = CommandType::COMMAND; 3787cdf0e10cSrcweir sal_Bool bEscapeProcessing = sal_True; 3788cdf0e10cSrcweir extractDescriptorProps(aDesc, sDataSource, sCommand, nCommandType, bEscapeProcessing); 3789cdf0e10cSrcweir if ( sDataSource.getLength() && sCommand.getLength() && (-1 != nCommandType) ) 3790cdf0e10cSrcweir { 3791cdf0e10cSrcweir SvLBoxEntry* pDataSource = NULL; 3792cdf0e10cSrcweir SvLBoxEntry* pCommandType = NULL; 3793cdf0e10cSrcweir m_pCurrentlyDisplayed = getObjectEntry( sDataSource, sCommand, nCommandType, &pDataSource, &pCommandType, sal_True, SharedConnection() ); 3794cdf0e10cSrcweir bIni = sal_True; 3795cdf0e10cSrcweir } 3796cdf0e10cSrcweir } 3797cdf0e10cSrcweir return bIni; 3798cdf0e10cSrcweir } 3799cdf0e10cSrcweir 3800cdf0e10cSrcweir // ----------------------------------------------------------------------------- 3801cdf0e10cSrcweir void SbaTableQueryBrowser::postReloadForm() 3802cdf0e10cSrcweir { 3803cdf0e10cSrcweir InitializeGridModel(getFormComponent()); 3804cdf0e10cSrcweir LoadFinished(sal_True); 3805cdf0e10cSrcweir //updateTitle(); 3806cdf0e10cSrcweir } 3807cdf0e10cSrcweir 3808cdf0e10cSrcweir //------------------------------------------------------------------------------ 3809cdf0e10cSrcweir Reference< XEmbeddedScripts > SAL_CALL SbaTableQueryBrowser::getScriptContainer() throw (RuntimeException) 3810cdf0e10cSrcweir { 3811cdf0e10cSrcweir // update our database document 3812cdf0e10cSrcweir Reference< XModel > xDocument; 3813cdf0e10cSrcweir try 3814cdf0e10cSrcweir { 3815cdf0e10cSrcweir Reference< XPropertySet > xCursorProps( getRowSet(), UNO_QUERY_THROW ); 3816cdf0e10cSrcweir Reference< XConnection > xConnection( xCursorProps->getPropertyValue( PROPERTY_ACTIVE_CONNECTION ), UNO_QUERY ); 3817cdf0e10cSrcweir if ( xConnection.is() ) 3818cdf0e10cSrcweir { 3819cdf0e10cSrcweir Reference< XChild > xChild( xConnection, UNO_QUERY_THROW ); 3820cdf0e10cSrcweir Reference< XDocumentDataSource > xDataSource( xChild->getParent(), UNO_QUERY_THROW ); 3821cdf0e10cSrcweir xDocument.set( xDataSource->getDatabaseDocument(), UNO_QUERY_THROW ); 3822cdf0e10cSrcweir } 3823cdf0e10cSrcweir } 3824cdf0e10cSrcweir catch( const Exception& ) 3825cdf0e10cSrcweir { 3826cdf0e10cSrcweir DBG_UNHANDLED_EXCEPTION(); 3827cdf0e10cSrcweir } 3828cdf0e10cSrcweir Reference< XEmbeddedScripts > xScripts( xDocument, UNO_QUERY ); 3829cdf0e10cSrcweir OSL_ENSURE( xScripts.is() || !xDocument.is(), 3830cdf0e10cSrcweir "SbaTableQueryBrowser::getScriptContainer: invalid database document!" ); 3831cdf0e10cSrcweir return xScripts; 3832cdf0e10cSrcweir } 3833cdf0e10cSrcweir 3834cdf0e10cSrcweir //------------------------------------------------------------------------------ 3835cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::registerContextMenuInterceptor( const Reference< XContextMenuInterceptor >& _Interceptor ) throw (RuntimeException) 3836cdf0e10cSrcweir { 3837cdf0e10cSrcweir if ( _Interceptor.is() ) 3838cdf0e10cSrcweir m_aContextMenuInterceptors.addInterface( _Interceptor ); 3839cdf0e10cSrcweir } 3840cdf0e10cSrcweir 3841cdf0e10cSrcweir //------------------------------------------------------------------------------ 3842cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::releaseContextMenuInterceptor( const Reference< XContextMenuInterceptor >& _Interceptor ) throw (RuntimeException) 3843cdf0e10cSrcweir { 3844cdf0e10cSrcweir if ( _Interceptor.is() ) 3845cdf0e10cSrcweir m_aContextMenuInterceptors.removeInterface( _Interceptor ); 3846cdf0e10cSrcweir } 3847cdf0e10cSrcweir 3848cdf0e10cSrcweir //------------------------------------------------------------------------------ 3849cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::registeredDatabaseLocation( const DatabaseRegistrationEvent& _Event ) throw (RuntimeException) 3850cdf0e10cSrcweir { 3851cdf0e10cSrcweir ::vos::OGuard aGuard( Application::GetSolarMutex() ); 3852cdf0e10cSrcweir implAddDatasource( _Event.Name, SharedConnection() ); 3853cdf0e10cSrcweir } 3854cdf0e10cSrcweir 3855cdf0e10cSrcweir //------------------------------------------------------------------------------ 3856cdf0e10cSrcweir void SbaTableQueryBrowser::impl_cleanupDataSourceEntry( const String& _rDataSourceName ) 3857cdf0e10cSrcweir { 3858cdf0e10cSrcweir // get the top-level representing the removed data source 3859cdf0e10cSrcweir SvLBoxEntry* pDataSourceEntry = m_pTreeView->getListBox().FirstChild( NULL ); 3860cdf0e10cSrcweir while ( pDataSourceEntry ) 3861cdf0e10cSrcweir { 3862cdf0e10cSrcweir if ( m_pTreeView->getListBox().GetEntryText( pDataSourceEntry ) == _rDataSourceName ) 3863cdf0e10cSrcweir break; 3864cdf0e10cSrcweir 3865cdf0e10cSrcweir pDataSourceEntry = m_pTreeView->getListBox().NextSibling( pDataSourceEntry ); 3866cdf0e10cSrcweir } 3867cdf0e10cSrcweir 3868cdf0e10cSrcweir OSL_ENSURE( pDataSourceEntry, "SbaTableQueryBrowser::impl_cleanupDataSourceEntry: do not know this data source!" ); 3869cdf0e10cSrcweir if ( !pDataSourceEntry ) 3870cdf0e10cSrcweir return; 3871cdf0e10cSrcweir 3872cdf0e10cSrcweir if ( isSelected( pDataSourceEntry ) ) 3873*30acf5e8Spfg { // a table or query belonging to the deleted data source is currently being displayed. 3874cdf0e10cSrcweir OSL_ENSURE( m_pTreeView->getListBox().GetRootLevelParent( m_pCurrentlyDisplayed ) == pDataSourceEntry, 3875cdf0e10cSrcweir "SbaTableQueryBrowser::impl_cleanupDataSourceEntry: inconsistence (1)!" ); 3876cdf0e10cSrcweir unloadAndCleanup( sal_True ); 3877cdf0e10cSrcweir } 3878cdf0e10cSrcweir else 3879cdf0e10cSrcweir OSL_ENSURE( 3880cdf0e10cSrcweir ( NULL == m_pCurrentlyDisplayed ) 3881cdf0e10cSrcweir || ( m_pTreeView->getListBox().GetRootLevelParent( m_pCurrentlyDisplayed ) != pDataSourceEntry ), 3882cdf0e10cSrcweir "SbaTableQueryBrowser::impl_cleanupDataSourceEntry: inconsistence (2)!"); 3883cdf0e10cSrcweir 3884cdf0e10cSrcweir // delete any user data of the child entries of the to-be-removed entry 3885cdf0e10cSrcweir SvTreeEntryList* pList = m_pTreeModel->GetChildList( pDataSourceEntry ); 3886cdf0e10cSrcweir if ( pList ) 3887cdf0e10cSrcweir { 3888cdf0e10cSrcweir SvLBoxEntry* pEntryLoop = static_cast<SvLBoxEntry*>( pList->First() ); 3889cdf0e10cSrcweir while ( pEntryLoop ) 3890cdf0e10cSrcweir { 3891cdf0e10cSrcweir DBTreeListUserData* pData = static_cast< DBTreeListUserData* >( pEntryLoop->GetUserData() ); 3892cdf0e10cSrcweir pEntryLoop->SetUserData( NULL ); 3893cdf0e10cSrcweir delete pData; 3894cdf0e10cSrcweir pEntryLoop = static_cast< SvLBoxEntry* >( pList->Next() ); 3895cdf0e10cSrcweir } 3896cdf0e10cSrcweir } 3897cdf0e10cSrcweir 3898cdf0e10cSrcweir // remove the entry 3899cdf0e10cSrcweir DBTreeListUserData* pData = static_cast< DBTreeListUserData* >( pDataSourceEntry->GetUserData() ); 3900cdf0e10cSrcweir pDataSourceEntry->SetUserData( NULL ); 3901cdf0e10cSrcweir delete pData; 3902cdf0e10cSrcweir m_pTreeModel->Remove( pDataSourceEntry ); 3903cdf0e10cSrcweir } 3904cdf0e10cSrcweir 3905cdf0e10cSrcweir //------------------------------------------------------------------------------ 3906cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::revokedDatabaseLocation( const DatabaseRegistrationEvent& _Event ) throw (RuntimeException) 3907cdf0e10cSrcweir { 3908cdf0e10cSrcweir ::vos::OGuard aGuard( Application::GetSolarMutex() ); 3909cdf0e10cSrcweir 3910cdf0e10cSrcweir impl_cleanupDataSourceEntry( _Event.Name ); 3911cdf0e10cSrcweir 3912cdf0e10cSrcweir // maybe the object which is part of the document data source has been removed 3913cdf0e10cSrcweir checkDocumentDataSource(); 3914cdf0e10cSrcweir } 3915cdf0e10cSrcweir 3916cdf0e10cSrcweir //------------------------------------------------------------------------------ 3917cdf0e10cSrcweir void SAL_CALL SbaTableQueryBrowser::changedDatabaseLocation( const DatabaseRegistrationEvent& _Event ) throw (RuntimeException) 3918cdf0e10cSrcweir { 3919cdf0e10cSrcweir ::vos::OGuard aGuard( Application::GetSolarMutex() ); 3920cdf0e10cSrcweir 3921cdf0e10cSrcweir // in case the data source was expanded, and connected, we need to clean it up 3922cdf0e10cSrcweir // for simplicity, just do as if the data source were completely removed and re-added 3923cdf0e10cSrcweir impl_cleanupDataSourceEntry( _Event.Name ); 3924cdf0e10cSrcweir implAddDatasource( _Event.Name, SharedConnection() ); 3925cdf0e10cSrcweir } 3926cdf0e10cSrcweir 3927cdf0e10cSrcweir 3928cdf0e10cSrcweir // ......................................................................... 3929cdf0e10cSrcweir } // namespace dbaui 3930cdf0e10cSrcweir // ......................................................................... 3931cdf0e10cSrcweir 3932cdf0e10cSrcweir 3933