| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the 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; |
| } |
| |