/************************************************************************* * * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: AppControllerGen.cxx,v $ * * $Revision: 1.19 $ * * last change: $Author: obo $ $Date: 2006-07-10 15:23:11 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. * * * GNU Lesser General Public License Version 2.1 * ============================================= * Copyright 2005 by Sun Microsystems, Inc. * 901 San Antonio Road, Palo Alto, CA 94303, USA * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License version 2.1, as published by the Free Software Foundation. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * ************************************************************************/ #ifndef DBAUI_APPCONTROLLER_HXX #include "AppController.hxx" #endif #ifndef _COM_SUN_STAR_SDB_XQUERIESSUPPLIER_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDB_SQLCONTEXT_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBCX_XTABLESSUPPLIER_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDB_COMMANDTYPE_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBCX_XVIEWSSUPPLIER_HPP_ #include #endif #ifndef _COM_SUN_STAR_CONTAINER_XNAMEACCESS_HPP_ #include #endif #ifndef _COM_SUN_STAR_CONTAINER_XCONTAINER_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBCX_XRENAME_HPP_ #include #endif #ifndef _COM_SUN_STAR_UNO_XNAMINGSERVICE_HPP_ #include #endif #ifndef _COM_SUN_STAR_UTIL_XREFRESHABLE_HPP_ #include #endif #ifndef _CONNECTIVITY_DBTOOLS_HXX_ #include #endif #ifndef _DBHELPER_DBEXCEPTION_HXX_ #include #endif #ifndef DBAUI_TOOLS_HXX #include "UITools.hxx" #endif #ifndef DBAUI_DLGSAVE_HXX #include "dlgsave.hxx" #endif #ifndef INCLUDED_SFX_MAILMODELAPI_HXX #include #endif #ifndef DBAUI_APPVIEW_HXX #include "AppView.hxx" #endif #ifndef _SVX_DBAEXCHANGE_HXX_ #include #endif #ifndef _UTL_BOOTSTRAP_HXX #include #endif #ifndef _SV_SVAPP_HXX //autogen #include #endif #ifndef _TOOLKIT_HELPER_VCLUNOHELPER_HXX_ #include #endif #ifndef _COM_SUN_STAR_UI_DIALOGS_XEXECUTABLEDIALOG_HPP_ #include #endif #ifndef _SV_WAITOBJ_HXX #include #endif #ifndef DBAUI_APPDETAILVIEW_HXX #include "AppDetailView.hxx" #endif #ifndef DBACCESS_SHARED_DBUSTRINGS_HRC #include "dbustrings.hrc" #endif #ifndef _URLOBJ_HXX #include #endif #ifndef _DBACCESS_SLOTID_HRC_ #include "dbaccess_slotid.hrc" #endif #ifndef _DBU_APP_HRC_ #include "dbu_app.hrc" #endif #ifndef _COM_SUN_STAR_CONTAINER_XHIERARCHICALNAMECONTAINER_HPP_ #include #endif #ifndef _COM_SUN_STAR_CONTAINER_XCHILD_HPP_ #include #endif #ifndef _COM_SUN_STAR_CONTAINER_XNAMECONTAINER_HPP_ #include #endif #ifndef _COM_SUN_STAR_UTIL_XCLOSEABLE_HPP_ #include #endif #ifndef DBACCESS_SOURCE_UI_MISC_DEFAULTOBJECTNAMECHECK_HXX #include "defaultobjectnamecheck.hxx" #endif //........................................................................ namespace dbaui { using namespace ::dbtools; using namespace ::svx; using namespace ::com::sun::star::uno; using namespace ::com::sun::star::util; using namespace ::com::sun::star::frame; using namespace ::com::sun::star::lang; using namespace ::com::sun::star::ui::dialogs; using namespace ::com::sun::star::sdb; using namespace ::com::sun::star::sdbc; using namespace ::com::sun::star::sdbcx; using namespace ::com::sun::star::beans; using namespace ::com::sun::star::container; using namespace ::com::sun::star::ucb; //........................................................................ // ----------------------------------------------------------------------------- void OApplicationController::convertToView(const ::rtl::OUString& _sName) { try { SharedConnection xConnection( getConnection() ); Reference< XQueriesSupplier > xSup( xConnection, UNO_QUERY_THROW ); Reference< XNameAccess > xQueries( xSup->getQueries(), UNO_QUERY_THROW ); Reference< XPropertySet > xSourceObject( xQueries->getByName( _sName ), UNO_QUERY_THROW ); Reference< XTablesSupplier > xTablesSup( xConnection, UNO_QUERY_THROW ); Reference< XNameAccess > xTables( xTablesSup->getTables(), UNO_QUERY_THROW ); Reference< XDatabaseMetaData > xMeta = xConnection->getMetaData(); String aName = String(ModuleRes(STR_TBL_TITLE)); aName = aName.GetToken(0,' '); String aDefaultName = ::dbaui::createDefaultName(xMeta,xTables,aName); DynamicTableOrQueryNameCheck aNameChecker( xConnection, CommandType::TABLE ); OSaveAsDlg aDlg( getView(), CommandType::TABLE, getORB(), xConnection, aDefaultName, aNameChecker ); if ( aDlg.Execute() == RET_OK ) { ::rtl::OUString sName = aDlg.getName(); ::rtl::OUString sCatalog = aDlg.getCatalog(); ::rtl::OUString sSchema = aDlg.getSchema(); ::rtl::OUString sNewName( ::dbtools::composeTableName( xMeta, sCatalog, sSchema, sName, sal_False, ::dbtools::eInTableDefinitions ) ); Reference xView = ::dbaui::createView(sNewName,xConnection,xSourceObject); if ( !xView.is() ) throw SQLException(String(ModuleRes(STR_NO_TABLE_FORMAT_INSIDE)),*this,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("S1000")) ,0,Any()); getContainer()->elementAdded(E_TABLE,sNewName,makeAny(xView),xConnection); } } catch(SQLContext& e) { showError(SQLExceptionInfo(e)); } catch(SQLWarning& e) { showError(SQLExceptionInfo(e)); } catch(SQLException& e) { showError(SQLExceptionInfo(e)); } catch(Exception& ) { OSL_ENSURE(sal_False, "OApplicationController::convertToView: caught a generic exception!"); } } // ----------------------------------------------------------------------------- void OApplicationController::pasteFormat(sal_uInt32 _nFormatId) { if ( _nFormatId ) { try { const TransferableDataHelper& rClipboard = getViewClipboard(); ElementType eType = getContainer()->getElementType(); if ( eType == E_TABLE ) { m_aTableCopyHelper.pasteTable( _nFormatId, rClipboard, getDatabaseName(), ensureConnection() ); } else paste( eType,ODataAccessObjectTransferable::extractObjectDescriptor(rClipboard) ); } catch(Exception& ) { OSL_ENSURE(0,"Exception catched!"); } } } // ----------------------------------------------------------------------------- void OApplicationController::openDataSourceAdminDialog() { openDialog(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sdb.DatasourceAdministrationDialog"))); } // ----------------------------------------------------------------------------- void OApplicationController::openDialog(const ::rtl::OUString& _sServiceName) { try { ::vos::OGuard aSolarGuard( Application::GetSolarMutex() ); ::osl::MutexGuard aGuard(m_aMutex); WaitObject aWO(getView()); SharedConnection xConnection( getConnection() ); Sequence< Any > aArgs(xConnection.is() ? 3 : 2); Reference< ::com::sun::star::awt::XWindow> xWindow = getTopMostContainerWindow(); if ( !xWindow.is() ) { DBG_ASSERT( getContainer(), "OApplicationController::Construct: have no view!" ); if ( getContainer() ) xWindow = VCLUnoHelper::GetInterface(getView()->Window::GetParent()); } // the parent window aArgs[0] <<= PropertyValue( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("ParentWindow")), 0, makeAny(xWindow), PropertyState_DIRECT_VALUE); // the initial selection ::rtl::OUString sInitialSelection; if ( getContainer() ) sInitialSelection = getDatabaseName(); aArgs[1] <<= PropertyValue( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("InitialSelection")), 0, makeAny(sInitialSelection), PropertyState_DIRECT_VALUE); if ( xConnection.is() ) aArgs[2] <<= PropertyValue( PROPERTY_ACTIVECONNECTION, 0, makeAny( xConnection ), PropertyState_DIRECT_VALUE); // create the dialog Reference< XExecutableDialog > xAdminDialog; xAdminDialog = Reference< XExecutableDialog >( m_xMultiServiceFacatory->createInstanceWithArguments(_sServiceName,aArgs), UNO_QUERY); // execute it if (xAdminDialog.is()) xAdminDialog->execute(); } catch(Exception&) { DBG_ERROR("OApplicationController::implAdministrate: caught an exception while creating/executing the dialog!"); } } // ----------------------------------------------------------------------------- void OApplicationController::openTableFilterDialog() { openDialog(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.sdb.TableFilterDialog"))); } // ----------------------------------------------------------------------------- void OApplicationController::refreshTables() { if ( getContainer() && getContainer()->getDetailView() ) { WaitObject aWO(getView()); OSL_ENSURE(getContainer()->getElementType() == E_TABLE,"Only allowed when the tables container is selected!"); try { Reference xRefresh(getElements(E_TABLE),UNO_QUERY); if ( xRefresh.is() ) xRefresh->refresh(); } catch(const Exception&) { OSL_ENSURE(0,"Could not refresh tables!"); } getContainer()->getDetailView()->clearPages(sal_False); getContainer()->getDetailView()->createTablesPage( ensureConnection() ); } } // ----------------------------------------------------------------------------- void OApplicationController::openDirectSQLDialog() { openDialog(::rtl::OUString(SERVICE_SDB_DIRECTSQLDIALOG)); } // ----------------------------------------------------------------------------- void SAL_CALL OApplicationController::propertyChange( const PropertyChangeEvent& evt ) throw (RuntimeException) { ::vos::OGuard aSolarGuard( Application::GetSolarMutex() ); ::osl::MutexGuard aGuard(m_aMutex); m_bNeedToReconnect = sal_True; if ( evt.PropertyName == PROPERTY_USER ) InvalidateFeature(SID_DB_APP_STATUS_USERNAME); else if ( evt.PropertyName == PROPERTY_URL ) { InvalidateFeature(SID_DB_APP_STATUS_DBNAME); InvalidateFeature(SID_DB_APP_STATUS_TYPE); InvalidateFeature(SID_DB_APP_STATUS_HOSTNAME); } EventObject aEvt; aEvt.Source = m_xModel; modified(aEvt); } // ----------------------------------------------------------------------------- void OApplicationController::previewChanged( sal_Int32 _nMode ) { ::vos::OGuard aSolarGuard( Application::GetSolarMutex() ); ::osl::MutexGuard aGuard(m_aMutex); if ( m_xDataSource.is() ) { try { Sequence aFields; m_xDataSource->getPropertyValue(PROPERTY_LAYOUTINFORMATION) >>= aFields; PropertyValue *pIter = aFields.getArray(); PropertyValue *pEnd = pIter + aFields.getLength(); const static ::rtl::OUString s_sPreview(RTL_CONSTASCII_USTRINGPARAM("Preview")); for (; pIter != pEnd && pIter->Name != s_sPreview; ++pIter) ; if ( pIter == pEnd ) { sal_Int32 nLen = aFields.getLength(); aFields.realloc( nLen + 1 ); pIter = aFields.getArray() + nLen; pIter->Name = s_sPreview; } sal_Int32 nOldMode = 0; pIter->Value >>= nOldMode; if ( nOldMode != _nMode ) { pIter->Value <<= _nMode; m_xDataSource->setPropertyValue(PROPERTY_LAYOUTINFORMATION,makeAny(aFields)); } } catch(Exception) { OSL_ENSURE(0,"Exception caught!"); } } InvalidateFeature(SID_DB_APP_DISABLE_PREVIEW); InvalidateFeature(SID_DB_APP_VIEW_DOCINFO_PREVIEW); InvalidateFeature(SID_DB_APP_VIEW_DOC_PREVIEW); } // ----------------------------------------------------------------------------- void OApplicationController::updateTitle() { ::rtl::OUString sName = getStrippedDatabaseName(); String sTitle = String(ModuleRes(STR_APP_TITLE)); sName = sName + sTitle; #ifndef PRODUCT ::rtl::OUString aDefault; sName += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" [")); sName += utl::Bootstrap::getBuildIdData( aDefault ); sName += ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("]")); #endif OGenericUnoController::setTitle(sName); } // ----------------------------------------------------------------------------- void OApplicationController::askToReconnect() { if ( m_bNeedToReconnect ) { m_bNeedToReconnect = sal_False; sal_Bool bClear = sal_True; if ( !m_aDocuments.empty() ) { QueryBox aQry(getView(), ModuleRes(APP_CLOSEDOCUMENTS)); switch (aQry.Execute()) { case RET_YES: suspendDocuments(sal_True); break; default: bClear = sal_False; break; } } if ( bClear ) { ElementType eType = getContainer()->getElementType(); disconnect(); getContainer()->getDetailView()->clearPages(sal_False); getContainer()->changeContainer(E_NONE); // invalidate the old selection getContainer()->changeContainer(eType); // reselect the current one again } } } // ----------------------------------------------------------------------------- sal_Bool OApplicationController::suspendDocument(const TDocuments::key_type& _xComponent,sal_Bool _bSuspend) { sal_Bool bSuspended = sal_True; Reference xController; Reference xModel(_xComponent,UNO_QUERY); if ( xModel.is() ) xController = xModel->getCurrentController(); else { xController.set(_xComponent,UNO_QUERY); if ( !xController.is() ) { Reference xFrame(_xComponent,UNO_QUERY); if ( xFrame.is() ) xController = xFrame->getController(); } } if ( xController.is() && xController != *this ) bSuspended = xController->suspend(_bSuspend); return bSuspended; } // ----------------------------------------------------------------------------- sal_Bool OApplicationController::suspendDocuments(sal_Bool bSuspend) { sal_Bool bSubSuspended = sal_True; Reference xModel; sal_Int32 nSuspendPos = 1; try { TDocuments::iterator aIter = m_aDocuments.begin(); TDocuments::iterator aEnd = m_aDocuments.end(); for (; aIter != aEnd && bSubSuspended; ++aIter,++nSuspendPos) bSubSuspended = suspendDocument(aIter->first,bSuspend); } catch(Exception) { } if ( bSubSuspended && !m_aDocuments.empty() ) { try { TDocuments::iterator document = m_aDocuments.begin(); TDocuments::iterator documentEnd = m_aDocuments.end(); for (; document != documentEnd ; ++document) { Reference< XComponent > xDocument = document->first; if ( xDocument.is() ) xDocument->removeEventListener(static_cast(this)); } document = m_aDocuments.begin(); // first of all we have to set the second to NULL for (; document != documentEnd ; ) { TDocuments::iterator aPos = document++; aPos->second = NULL; // this may also dispose the document } // work on copy TDocuments aDocuments = m_aDocuments; document = aDocuments.begin(); documentEnd = aDocuments.end(); for (; document != documentEnd ; ++document ) { Reference xController; xModel.set(document->first,UNO_QUERY); if ( xModel.is() ) xController = xModel->getCurrentController(); else { xController.set(document->first,UNO_QUERY); if ( !xController.is() ) { Reference xFrame(document->first,UNO_QUERY); if ( xFrame.is() ) xController = xFrame->getController(); } } if ( xController.is() && xController != *this ) { Reference< com::sun::star::util::XCloseable> xCloseable(xController->getFrame(),UNO_QUERY); if ( xCloseable.is() ) xCloseable->close(sal_True); } } } catch(Exception) { } m_aDocuments.clear(); } else // resuspend the documents again { TDocuments::iterator aIter = m_aDocuments.begin(); TDocuments::iterator aEnd = m_aDocuments.end(); try { for (; aIter != aEnd && nSuspendPos ; ++aIter,--nSuspendPos) suspendDocument(aIter->first,!bSuspend); } catch(Exception) { } } return bSubSuspended; } // ----------------------------------------------------------------------------- ::rtl::OUString OApplicationController::getStrippedDatabaseName() const { return ::dbaui::getStrippedDatabaseName(m_xDataSource,m_sDatabaseName); } // ----------------------------------------------------------------------------- void OApplicationController::addDocumentListener(const Reference< XComponent >& _xDocument,const Reference< XComponent >& _xDefintion) { if ( _xDocument.is() ) { m_aDocuments[_xDocument] = _xDefintion; _xDocument->addEventListener(static_cast(this)); } } // ----------------------------------------------------------------------------- sal_Bool OApplicationController::insertHierachyElement(ElementType _eType,const String& _sParentFolder,sal_Bool _bCollection,const Reference& _xContent,sal_Bool _bMove) { Reference xNames(getElements(_eType), UNO_QUERY); return dbaui::insertHierachyElement(getView() ,getORB() ,xNames ,_sParentFolder ,_eType == E_FORM ,_bCollection ,_xContent ,_bMove); } // ----------------------------------------------------------------------------- sal_Bool OApplicationController::isRenameDeleteAllowed(ElementType _eType,sal_Bool _bDelete) const { ElementType eType = getContainer()->getElementType(); sal_Bool bEnabled = !isDataSourceReadOnly() && eType == _eType; if ( bEnabled ) { if ( E_TABLE == eType ) bEnabled = !isConnectionReadOnly() && getContainer()->isALeafSelected(); sal_Bool bCompareRes = sal_False; if ( _bDelete ) bCompareRes = getContainer()->getSelectionCount() > 0; else { bCompareRes = getContainer()->getSelectionCount() == 1; if ( bEnabled && bCompareRes && E_TABLE == eType ) { ::std::vector< ::rtl::OUString> aList; const_cast(this)->getSelectionElementNames(aList); try { Reference< XNameAccess > xContainer = const_cast(this)->getElements(eType); if ( bEnabled = (xContainer.is() && xContainer->hasByName(*aList.begin())) ) bEnabled = Reference(xContainer->getByName(*aList.begin()),UNO_QUERY).is(); } catch(Exception&) { bEnabled = sal_False; } } } bEnabled = bEnabled && bCompareRes; } return bEnabled; } // ----------------------------------------------------------------------------- void OApplicationController::onLoadedMenu(const Reference< ::com::sun::star::frame::XLayoutManager >& _xLayoutManager) { if ( _xLayoutManager.is() ) { static ::rtl::OUString s_sStatusbar(RTL_CONSTASCII_USTRINGPARAM("private:resource/statusbar/statusbar")); _xLayoutManager->createElement( s_sStatusbar ); _xLayoutManager->requestElement( s_sStatusbar ); if ( getContainer() ) getContainer()->createIconAutoMnemonics(); Execute( SID_DB_APP_VIEW_FORMS, Sequence< PropertyValue >() ); InvalidateAll(); } } // ----------------------------------------------------------------------------- void OApplicationController::doAction(sal_uInt16 _nId ,OLinkedDocumentsAccess::EOpenMode _eOpenMode) { ::std::vector< ::rtl::OUString> aList; getSelectionElementNames(aList); ElementType eType = getContainer()->getElementType(); ::std::vector< ::std::pair< ::rtl::OUString ,Reference< XModel > > > aCompoments; ::std::vector< ::rtl::OUString>::iterator aEnd = aList.end(); for (::std::vector< ::rtl::OUString>::iterator aIter = aList.begin(); aIter != aEnd; ++aIter) { if ( SID_DB_APP_CONVERTTOVIEW == _nId ) convertToView(*aIter); else aCompoments.push_back( ::std::pair< ::rtl::OUString ,Reference< XModel > >(*aIter,Reference< XModel >(openElement(*aIter,eType, _eOpenMode ),UNO_QUERY))); } // special handling for mail, if more than one document is selected attach them all if ( _eOpenMode == OLinkedDocumentsAccess::OPEN_FORMAIL ) { ::std::vector< ::std::pair< ::rtl::OUString ,Reference< XModel > > >::iterator componentIter = aCompoments.begin(); ::std::vector< ::std::pair< ::rtl::OUString ,Reference< XModel > > >::iterator componentEnd = aCompoments.end(); ::rtl::OUString aDocTypeString; SfxMailModel aSendMail; SfxMailModel::SendMailResult eResult = SfxMailModel::SEND_MAIL_OK; for (; componentIter != componentEnd && SfxMailModel::SEND_MAIL_OK == eResult; ++componentIter) { Reference< XModel > xModel(componentIter->second,UNO_QUERY); // Send document as e-Mail using stored/default type eResult = aSendMail.AttachDocument(aDocTypeString,xModel,componentIter->first); } if ( !aSendMail.IsEmpty() ) aSendMail.Send( m_xCurrentFrame ); } } // ----------------------------------------------------------------------------- ElementType OApplicationController::getElementType(const Reference< XContainer >& _xContainer) const { ElementType eRet = E_NONE; Reference xServiceInfo(_xContainer,UNO_QUERY); if ( xServiceInfo.is() ) { if ( xServiceInfo->supportsService(SERVICE_SDBCX_TABLES) ) eRet = E_TABLE; else if ( xServiceInfo->supportsService(SERVICE_NAME_FORM_COLLECTION) ) eRet = E_FORM; else if ( xServiceInfo->supportsService(SERVICE_NAME_REPORT_COLLECTION) ) eRet = E_REPORT; else eRet = E_QUERY; } return eRet; } //........................................................................ } // namespace dbaui //........................................................................