diff options
Diffstat (limited to 'svx/source/form/fmtools.cxx')
| -rw-r--r-- | svx/source/form/fmtools.cxx | 496 |
1 files changed, 496 insertions, 0 deletions
diff --git a/svx/source/form/fmtools.cxx b/svx/source/form/fmtools.cxx new file mode 100644 index 000000000000..460d2e1cd787 --- /dev/null +++ b/svx/source/form/fmtools.cxx @@ -0,0 +1,496 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org 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 version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +// MARKER(update_precomp.py): autogen include statement, do not remove +#include "precompiled_svx.hxx" + +#include "fmprop.hrc" +#include "fmservs.hxx" +#include "svx/fmtools.hxx" +#include "svx/dbtoolsclient.hxx" +#include "svx/fmglob.hxx" + +/** === begin UNO includes === **/ +#include <com/sun/star/awt/LineEndFormat.hpp> +#include <com/sun/star/beans/PropertyAttribute.hpp> +#include <com/sun/star/beans/XIntrospection.hpp> +#include <com/sun/star/container/XChild.hpp> +#include <com/sun/star/form/XForm.hpp> +#include <com/sun/star/form/XFormComponent.hpp> +#include <com/sun/star/form/XGridColumnFactory.hpp> +#include <com/sun/star/io/XActiveDataSink.hpp> +#include <com/sun/star/io/XActiveDataSource.hpp> +#include <com/sun/star/io/XObjectInputStream.hpp> +#include <com/sun/star/io/XObjectOutputStream.hpp> +#include <com/sun/star/io/XPersistObject.hpp> +#include <com/sun/star/lang/Locale.hpp> +#include <com/sun/star/lang/XServiceInfo.hpp> +#include <com/sun/star/sdb/CommandType.hpp> +#include <com/sun/star/sdb/ErrorCondition.hpp> +#include <com/sun/star/sdb/SQLContext.hpp> +#include <com/sun/star/sdb/XCompletedConnection.hpp> +#include <com/sun/star/sdb/XQueriesSupplier.hpp> +#include <com/sun/star/sdb/XResultSetAccess.hpp> +#include <com/sun/star/sdbc/DataType.hpp> +#include <com/sun/star/sdbc/XDataSource.hpp> +#include <com/sun/star/sdbcx/Privilege.hpp> +#include <com/sun/star/sdbcx/XTablesSupplier.hpp> +#include <com/sun/star/task/XInteractionHandler.hpp> +#include <com/sun/star/ui/dialogs/XExecutableDialog.hpp> +#include <com/sun/star/uno/XNamingService.hpp> +#include <com/sun/star/util/Language.hpp> +#include <com/sun/star/util/NumberFormat.hpp> +#include <com/sun/star/util/XCloneable.hpp> +#include <com/sun/star/util/XNumberFormatTypes.hpp> +#include <com/sun/star/util/XNumberFormats.hpp> +#include <com/sun/star/util/XNumberFormatsSupplier.hpp> +#include <com/sun/star/util/XNumberFormatter.hpp> +/** === end UNO includes === **/ + +#include <basic/sbxvar.hxx> +#include <svl/eitem.hxx> +#include <svl/stritem.hxx> +#include <comphelper/container.hxx> +#include <comphelper/extract.hxx> +#include <comphelper/processfactory.hxx> +#include <comphelper/property.hxx> +#include <comphelper/sequence.hxx> +#include <comphelper/types.hxx> +#include <comphelper/uno3.hxx> +#include <connectivity/dbexception.hxx> +#include <connectivity/dbtools.hxx> +#include <cppuhelper/servicefactory.hxx> +#include <cppuhelper/typeprovider.hxx> +#include <rtl/logfile.hxx> +#include <rtl/math.hxx> +#include <sfx2/bindings.hxx> +#include <svl/eitem.hxx> +#include <svl/stritem.hxx> +#include <toolkit/unohlp.hxx> +#include <tools/debug.hxx> +#include <tools/string.hxx> +#include <vcl/stdtext.hxx> +#include <vcl/svapp.hxx> + +#include <algorithm> + +using namespace ::com::sun::star::uno; +using namespace ::com::sun::star::util; +using namespace ::com::sun::star::lang; +using namespace ::com::sun::star::frame; +using namespace ::com::sun::star::awt; +using namespace ::com::sun::star::beans; +using namespace ::com::sun::star::container; +using namespace ::com::sun::star::ui::dialogs; +using namespace ::com::sun::star::sdbc; +using namespace ::com::sun::star::sdbcx; +using namespace ::com::sun::star::sdb; +using namespace ::com::sun::star::task; +using namespace ::com::sun::star::form; +using namespace ::svxform; +using namespace ::connectivity::simple; + +// ------------------------------------------------------------------------------ +namespace +{ + static bool lcl_shouldDisplayError( const Any& _rError ) + { + SQLException aError; + if ( !( _rError >>= aError ) ) + return true; + + if ( aError.Message.indexOfAsciiL( RTL_CONSTASCII_STRINGPARAM( "[OOoBase]" ) ) != 0 ) + // it is an exception *not* thrown by an OOo Base core component + return true; + + // the only exception we do not display ATM is a RowSetVetoException, which + // has been raised because an XRowSetApprovalListener vetoed a change + if ( aError.ErrorCode + ErrorCondition::ROW_SET_OPERATION_VETOED == 0 ) + return false; + + // everything else is to be displayed + return true; + } +} + +// ------------------------------------------------------------------------------ +void displayException(const Any& _rExcept, Window* _pParent) +{ + RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "svx", "Ocke.Janssen@sun.com", "fmtools::displayException" ); + // check whether we need to display it + if ( !lcl_shouldDisplayError( _rExcept ) ) + return; + + try + { + // the parent window + Window* pParentWindow = _pParent ? _pParent : GetpApp()->GetDefDialogParent(); + Reference< XWindow > xParentWindow = VCLUnoHelper::GetInterface(pParentWindow); + + Sequence< Any > aArgs(2); + aArgs[0] <<= PropertyValue(::rtl::OUString::createFromAscii("SQLException"), 0, _rExcept, PropertyState_DIRECT_VALUE); + aArgs[1] <<= PropertyValue(::rtl::OUString::createFromAscii("ParentWindow"), 0, makeAny(xParentWindow), PropertyState_DIRECT_VALUE); + + static ::rtl::OUString s_sDialogServiceName = ::rtl::OUString::createFromAscii("com.sun.star.sdb.ErrorMessageDialog"); + Reference< XExecutableDialog > xErrorDialog( + ::comphelper::getProcessServiceFactory()->createInstanceWithArguments(s_sDialogServiceName, aArgs), UNO_QUERY); + if (xErrorDialog.is()) + xErrorDialog->execute(); + else + ShowServiceNotAvailableError(pParentWindow, s_sDialogServiceName, sal_True); + } + catch(Exception&) + { + OSL_ENSURE(sal_False, "displayException: could not display the error message!"); + } +} + +// ------------------------------------------------------------------------------ +void displayException(const ::com::sun::star::sdbc::SQLException& _rExcept, Window* _pParent) +{ + displayException(makeAny(_rExcept), _pParent); +} + +// ------------------------------------------------------------------------------ +void displayException(const ::com::sun::star::sdbc::SQLWarning& _rExcept, Window* _pParent) +{ + displayException(makeAny(_rExcept), _pParent); +} + +// ------------------------------------------------------------------------------ +void displayException(const ::com::sun::star::sdb::SQLContext& _rExcept, Window* _pParent) +{ + displayException(makeAny(_rExcept), _pParent); +} + +// ------------------------------------------------------------------------------ +void displayException(const ::com::sun::star::sdb::SQLErrorEvent& _rEvent, Window* _pParent) +{ + displayException(_rEvent.Reason, _pParent); +} + +//------------------------------------------------------------------------------ +sal_Int32 getElementPos(const Reference< ::com::sun::star::container::XIndexAccess>& xCont, const Reference< XInterface >& xElement) +{ + sal_Int32 nIndex = -1; + if (!xCont.is()) + return nIndex; + + + Reference< XInterface > xNormalized( xElement, UNO_QUERY ); + DBG_ASSERT( xNormalized.is(), "getElementPos: invalid element!" ); + if ( xNormalized.is() ) + { + // Feststellen an welcher Position sich das Kind befindet + nIndex = xCont->getCount(); + while (nIndex--) + { + try + { + Reference< XInterface > xCurrent(xCont->getByIndex( nIndex ),UNO_QUERY); + DBG_ASSERT( xCurrent.get() == Reference< XInterface >( xCurrent, UNO_QUERY ).get(), + "getElementPos: container element not normalized!" ); + if ( xNormalized.get() == xCurrent.get() ) + break; + } + catch(Exception&) + { + DBG_ERROR( "getElementPos: caught an exception!" ); + } + + } + } + return nIndex; +} + +//------------------------------------------------------------------ +::rtl::OUString getLabelName(const Reference< ::com::sun::star::beans::XPropertySet>& xControlModel) +{ + RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "svx", "Ocke.Janssen@sun.com", "fmtools::getLabelName" ); + if (!xControlModel.is()) + return ::rtl::OUString(); + + if (::comphelper::hasProperty(FM_PROP_CONTROLLABEL, xControlModel)) + { + Reference< ::com::sun::star::beans::XPropertySet> xLabelSet; + xControlModel->getPropertyValue(FM_PROP_CONTROLLABEL) >>= xLabelSet; + if (xLabelSet.is() && ::comphelper::hasProperty(FM_PROP_LABEL, xLabelSet)) + { + Any aLabel( xLabelSet->getPropertyValue(FM_PROP_LABEL) ); + if ((aLabel.getValueTypeClass() == TypeClass_STRING) && ::comphelper::getString(aLabel).getLength()) + return ::comphelper::getString(aLabel); + } + } + + return ::comphelper::getString(xControlModel->getPropertyValue(FM_PROP_CONTROLSOURCE)); +} + +//======================================================================== +// = CursorWrapper +//------------------------------------------------------------------------ +CursorWrapper::CursorWrapper(const Reference< ::com::sun::star::sdbc::XRowSet>& _rxCursor, sal_Bool bUseCloned) +{ + ImplConstruct(Reference< ::com::sun::star::sdbc::XResultSet>(_rxCursor, UNO_QUERY), bUseCloned); +} + +//------------------------------------------------------------------------ +CursorWrapper::CursorWrapper(const Reference< ::com::sun::star::sdbc::XResultSet>& _rxCursor, sal_Bool bUseCloned) +{ + ImplConstruct(_rxCursor, bUseCloned); +} + +//------------------------------------------------------------------------ +void CursorWrapper::ImplConstruct(const Reference< ::com::sun::star::sdbc::XResultSet>& _rxCursor, sal_Bool bUseCloned) +{ + if (bUseCloned) + { + Reference< ::com::sun::star::sdb::XResultSetAccess> xAccess(_rxCursor, UNO_QUERY); + try + { + m_xMoveOperations = xAccess.is() ? xAccess->createResultSet() : Reference< ::com::sun::star::sdbc::XResultSet>(); + } + catch(Exception&) + { + } + } + else + m_xMoveOperations = _rxCursor; + + m_xBookmarkOperations = m_xBookmarkOperations.query( m_xMoveOperations ); + m_xColumnsSupplier = m_xColumnsSupplier.query( m_xMoveOperations ); + m_xPropertyAccess = m_xPropertyAccess.query( m_xMoveOperations ); + + if ( !m_xMoveOperations.is() || !m_xBookmarkOperations.is() || !m_xColumnsSupplier.is() || !m_xPropertyAccess.is() ) + { // all or nothing !! + m_xMoveOperations = NULL; + m_xBookmarkOperations = NULL; + m_xColumnsSupplier = NULL; + } + else + m_xGeneric = m_xMoveOperations.get(); +} + +//------------------------------------------------------------------------ +const CursorWrapper& CursorWrapper::operator=(const Reference< ::com::sun::star::sdbc::XRowSet>& _rxCursor) +{ + m_xMoveOperations = Reference< ::com::sun::star::sdbc::XResultSet>(_rxCursor, UNO_QUERY); + m_xBookmarkOperations = Reference< ::com::sun::star::sdbcx::XRowLocate>(_rxCursor, UNO_QUERY); + m_xColumnsSupplier = Reference< ::com::sun::star::sdbcx::XColumnsSupplier>(_rxCursor, UNO_QUERY); + if (!m_xMoveOperations.is() || !m_xBookmarkOperations.is() || !m_xColumnsSupplier.is()) + { // all or nothing !! + m_xMoveOperations = NULL; + m_xBookmarkOperations = NULL; + m_xColumnsSupplier = NULL; + } + return *this; +} + +//------------------------------------------------------------------------------ +FmXDisposeListener::~FmXDisposeListener() +{ + setAdapter(NULL); +} + +//------------------------------------------------------------------------------ +void FmXDisposeListener::setAdapter(FmXDisposeMultiplexer* pAdapter) +{ + if (m_pAdapter) + { + ::osl::MutexGuard aGuard(m_rMutex); + m_pAdapter->release(); + m_pAdapter = NULL; + } + + if (pAdapter) + { + ::osl::MutexGuard aGuard(m_rMutex); + m_pAdapter = pAdapter; + m_pAdapter->acquire(); + } +} + +//============================================================================== +DBG_NAME(FmXDisposeMultiplexer); +//------------------------------------------------------------------------------ +FmXDisposeMultiplexer::FmXDisposeMultiplexer(FmXDisposeListener* _pListener, const Reference< ::com::sun::star::lang::XComponent>& _rxObject, sal_Int16 _nId) + :m_xObject(_rxObject) + ,m_pListener(_pListener) + ,m_nId(_nId) +{ + DBG_CTOR(FmXDisposeMultiplexer, NULL); + m_pListener->setAdapter(this); + + if (m_xObject.is()) + m_xObject->addEventListener(this); +} + +//------------------------------------------------------------------------------ +FmXDisposeMultiplexer::~FmXDisposeMultiplexer() +{ + DBG_DTOR(FmXDisposeMultiplexer, NULL); +} + +// ::com::sun::star::lang::XEventListener +//------------------------------------------------------------------ +void FmXDisposeMultiplexer::disposing(const ::com::sun::star::lang::EventObject& _Source) throw( RuntimeException ) +{ + Reference< ::com::sun::star::lang::XEventListener> xPreventDelete(this); + + if (m_pListener) + { + m_pListener->disposing(_Source, m_nId); + m_pListener->setAdapter(NULL); + m_pListener = NULL; + } + m_xObject = NULL; +} + +//------------------------------------------------------------------ +void FmXDisposeMultiplexer::dispose() +{ + if (m_xObject.is()) + { + Reference< ::com::sun::star::lang::XEventListener> xPreventDelete(this); + + m_xObject->removeEventListener(this); + m_xObject = NULL; + + m_pListener->setAdapter(NULL); + m_pListener = NULL; + } +} + +//============================================================================== +//------------------------------------------------------------------------------ +sal_Int16 getControlTypeByObject(const Reference< ::com::sun::star::lang::XServiceInfo>& _rxObject) +{ + RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "svx", "Ocke.Janssen@sun.com", "fmtools::getControlTypeByObject" ); + // ask for the persistent service name + Reference< ::com::sun::star::io::XPersistObject> xPersistence(_rxObject, UNO_QUERY); + DBG_ASSERT(xPersistence.is(), "::getControlTypeByObject : argument shold be an ::com::sun::star::io::XPersistObject !"); + if (!xPersistence.is()) + return OBJ_FM_CONTROL; + + ::rtl::OUString sPersistentServiceName = xPersistence->getServiceName(); + if (sPersistentServiceName.equals(FM_COMPONENT_EDIT)) // 5.0-Name + { + // may be a simple edit field or a formatted field, dependent of the supported services + if (_rxObject->supportsService(FM_SUN_COMPONENT_FORMATTEDFIELD)) + return OBJ_FM_FORMATTEDFIELD; + return OBJ_FM_EDIT; + } + if (sPersistentServiceName.equals(FM_COMPONENT_TEXTFIELD)) + return OBJ_FM_EDIT; + if (sPersistentServiceName.equals(FM_COMPONENT_COMMANDBUTTON)) + return OBJ_FM_BUTTON; + if (sPersistentServiceName.equals(FM_COMPONENT_FIXEDTEXT)) + return OBJ_FM_FIXEDTEXT; + if (sPersistentServiceName.equals(FM_COMPONENT_LISTBOX)) + return OBJ_FM_LISTBOX; + if (sPersistentServiceName.equals(FM_COMPONENT_CHECKBOX)) + return OBJ_FM_CHECKBOX; + if (sPersistentServiceName.equals(FM_COMPONENT_RADIOBUTTON)) + return OBJ_FM_RADIOBUTTON; + if (sPersistentServiceName.equals(FM_COMPONENT_GROUPBOX)) + return OBJ_FM_GROUPBOX; + if (sPersistentServiceName.equals(FM_COMPONENT_COMBOBOX)) + return OBJ_FM_COMBOBOX; + if (sPersistentServiceName.equals(FM_COMPONENT_GRID)) // 5.0-Name + return OBJ_FM_GRID; + if (sPersistentServiceName.equals(FM_COMPONENT_GRIDCONTROL)) + return OBJ_FM_GRID; + if (sPersistentServiceName.equals(FM_COMPONENT_IMAGEBUTTON)) + return OBJ_FM_IMAGEBUTTON; + if (sPersistentServiceName.equals(FM_COMPONENT_FILECONTROL)) + return OBJ_FM_FILECONTROL; + if (sPersistentServiceName.equals(FM_COMPONENT_DATEFIELD)) + return OBJ_FM_DATEFIELD; + if (sPersistentServiceName.equals(FM_COMPONENT_TIMEFIELD)) + return OBJ_FM_TIMEFIELD; + if (sPersistentServiceName.equals(FM_COMPONENT_NUMERICFIELD)) + return OBJ_FM_NUMERICFIELD; + if (sPersistentServiceName.equals(FM_COMPONENT_CURRENCYFIELD)) + return OBJ_FM_CURRENCYFIELD; + if (sPersistentServiceName.equals(FM_COMPONENT_PATTERNFIELD)) + return OBJ_FM_PATTERNFIELD; + if (sPersistentServiceName.equals(FM_COMPONENT_HIDDEN)) // 5.0-Name + return OBJ_FM_HIDDEN; + if (sPersistentServiceName.equals(FM_COMPONENT_HIDDENCONTROL)) + return OBJ_FM_HIDDEN; + if (sPersistentServiceName.equals(FM_COMPONENT_IMAGECONTROL)) + return OBJ_FM_IMAGECONTROL; + if (sPersistentServiceName.equals(FM_COMPONENT_FORMATTEDFIELD)) + { + DBG_ERROR("::getControlTypeByObject : suspicious persistent service name (formatted field) !"); + // objects with that service name should exist as they aren't compatible with older versions + return OBJ_FM_FORMATTEDFIELD; + } + if ( sPersistentServiceName.equals( FM_SUN_COMPONENT_SCROLLBAR ) ) + return OBJ_FM_SCROLLBAR; + if ( sPersistentServiceName.equals( FM_SUN_COMPONENT_SPINBUTTON) ) + return OBJ_FM_SPINBUTTON; + if (sPersistentServiceName.equals(FM_SUN_COMPONENT_NAVIGATIONBAR)) + return OBJ_FM_NAVIGATIONBAR; + + DBG_ERROR("::getControlTypeByObject : unknown object type !"); + return OBJ_FM_CONTROL; +} + +//------------------------------------------------------------------------------ +void setConnection(const Reference< ::com::sun::star::sdbc::XRowSet>& _rxRowSet, const Reference< ::com::sun::star::sdbc::XConnection>& _rxConn) +{ + RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "svx", "Ocke.Janssen@sun.com", "fmtools::setConnection" ); + Reference< ::com::sun::star::beans::XPropertySet> xRowSetProps(_rxRowSet, UNO_QUERY); + if (xRowSetProps.is()) + { + try + { + Any aConn(makeAny(_rxConn)); + xRowSetProps->setPropertyValue(FM_PROP_ACTIVE_CONNECTION, aConn); + } + catch(Exception&) + { + DBG_ERROR("::setConnection : could not set the connection !"); + } + + } +} +//------------------------------------------------------------------------------ +sal_Bool isRowSetAlive(const Reference< XInterface >& _rxRowSet) +{ + RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "svx", "Ocke.Janssen@sun.com", "fmtools::isRowSetAlive" ); + sal_Bool bIsAlive = sal_False; + Reference< ::com::sun::star::sdbcx::XColumnsSupplier> xSupplyCols(_rxRowSet, UNO_QUERY); + Reference< ::com::sun::star::container::XIndexAccess> xCols; + if (xSupplyCols.is()) + xCols = Reference< ::com::sun::star::container::XIndexAccess>(xSupplyCols->getColumns(), UNO_QUERY); + if (xCols.is() && (xCols->getCount() > 0)) + bIsAlive = sal_True; + + return bIsAlive; +} + |