diff options
author | Michael Stahl <mstahl@redhat.com> | 2012-01-28 20:52:45 +0100 |
---|---|---|
committer | Michael Stahl <mstahl@redhat.com> | 2012-01-28 20:52:45 +0100 |
commit | 2e626373db2412ac22e8c5c27a60d11cd29e875b (patch) | |
tree | 9e9f67205cd5b72f1031721273e1534a3a1e5b0f /extensions/source/propctrlr/formlinkdialog.cxx | |
parent | f7ee7bbd5174b084f018c2ec94d8c70c98ee04da (diff) |
replace obsolete "master" branch with README that points at new repoHEADmaster-deletedmaster
Diffstat (limited to 'extensions/source/propctrlr/formlinkdialog.cxx')
-rw-r--r-- | extensions/source/propctrlr/formlinkdialog.cxx | 675 |
1 files changed, 0 insertions, 675 deletions
diff --git a/extensions/source/propctrlr/formlinkdialog.cxx b/extensions/source/propctrlr/formlinkdialog.cxx deleted file mode 100644 index 1d3a3553a..000000000 --- a/extensions/source/propctrlr/formlinkdialog.cxx +++ /dev/null @@ -1,675 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/************************************************************************* - * - * 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_extensions.hxx" - -#include "formlinkdialog.hxx" -#include "formlinkdialog.hrc" - -#include "modulepcr.hxx" -#include "formresid.hrc" -#include "formstrings.hxx" -#include <vcl/combobox.hxx> -#include <vcl/msgbox.hxx> -#include <vcl/waitobj.hxx> -#include <svtools/localresaccess.hxx> -#include <connectivity/dbtools.hxx> -#include <connectivity/dbexception.hxx> -#include <toolkit/helper/vclunohelper.hxx> - -/** === begin UNO includes === **/ -#include <com/sun/star/sdbcx/XColumnsSupplier.hpp> -#include <com/sun/star/sdbcx/XKeysSupplier.hpp> -#include <com/sun/star/sdbcx/KeyType.hpp> -#include <com/sun/star/container/XNameAccess.hpp> -#include <com/sun/star/sdbcx/XTablesSupplier.hpp> -#include <com/sun/star/sdbc/XRowSet.hpp> -#include <com/sun/star/sdb/CommandType.hpp> -#include <com/sun/star/sdb/SQLContext.hpp> -/** === end UNO includes === **/ - - -//............................................................................ -namespace pcr -{ -//............................................................................ - - using namespace ::com::sun::star::uno; - using namespace ::com::sun::star::lang; - using namespace ::com::sun::star::form; - 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; - - //======================================================================== - //= FieldLinkRow - //======================================================================== - class FieldLinkRow : public Window - { - private: - ComboBox m_aDetailColumn; - FixedText m_aEqualSign; - ComboBox m_aMasterColumn; - - Link m_aLinkChangeHandler; - - public: - FieldLinkRow( Window* _pParent, const ResId& _rId ); - - inline void SetLinkChangeHandler( const Link& _rHdl ) { m_aLinkChangeHandler = _rHdl; } - inline const Link& GetLinkChangeHandler( ) const { return m_aLinkChangeHandler; } - - enum LinkParticipant - { - eDetailField, - eMasterField - }; - /** retrieves the selected field name for either the master or the detail field - @return <TRUE/> if and only a valid field is selected - */ - bool GetFieldName( LinkParticipant _eWhich, String& /* [out] */ _rName ) const; - void SetFieldName( LinkParticipant _eWhich, const String& _rName ); - - void fillList( LinkParticipant _eWhich, const Sequence< ::rtl::OUString >& _rFieldNames ); - - private: - DECL_LINK( OnFieldNameChanged, ComboBox* ); - }; - - //------------------------------------------------------------------------ - FieldLinkRow::FieldLinkRow( Window* _pParent, const ResId& _rId ) - :Window( _pParent, _rId ) - ,m_aDetailColumn( this, ResId( 1, *_rId.GetResMgr() ) ) - ,m_aEqualSign ( this, ResId( 1, *_rId.GetResMgr() ) ) - ,m_aMasterColumn( this, ResId( 2, *_rId.GetResMgr() ) ) - { - FreeResource(); - - m_aDetailColumn.SetDropDownLineCount( 10 ); - m_aMasterColumn.SetDropDownLineCount( 10 ); - - m_aDetailColumn.SetModifyHdl( LINK( this, FieldLinkRow, OnFieldNameChanged ) ); - m_aMasterColumn.SetModifyHdl( LINK( this, FieldLinkRow, OnFieldNameChanged ) ); - } - - //------------------------------------------------------------------------ - void FieldLinkRow::fillList( LinkParticipant _eWhich, const Sequence< ::rtl::OUString >& _rFieldNames ) - { - ComboBox* pBox = ( _eWhich == eDetailField ) ? &m_aDetailColumn : &m_aMasterColumn; - - const ::rtl::OUString* pFieldName = _rFieldNames.getConstArray(); - const ::rtl::OUString* pFieldNameEnd = pFieldName + _rFieldNames.getLength(); - for ( ; pFieldName != pFieldNameEnd; ++pFieldName ) - pBox->InsertEntry( *pFieldName ); - } - - //------------------------------------------------------------------------ - bool FieldLinkRow::GetFieldName( LinkParticipant _eWhich, String& /* [out] */ _rName ) const - { - const ComboBox* pBox = ( _eWhich == eDetailField ) ? &m_aDetailColumn : &m_aMasterColumn; - _rName = pBox->GetText(); - return _rName.Len() != 0; - } - - //------------------------------------------------------------------------ - void FieldLinkRow::SetFieldName( LinkParticipant _eWhich, const String& _rName ) - { - ComboBox* pBox = ( _eWhich == eDetailField ) ? &m_aDetailColumn : &m_aMasterColumn; - pBox->SetText( _rName ); - } - - //------------------------------------------------------------------------ - IMPL_LINK( FieldLinkRow, OnFieldNameChanged, ComboBox*, /*_pBox*/ ) - { - if ( m_aLinkChangeHandler.IsSet() ) - return m_aLinkChangeHandler.Call( this ); - - return 0L; - } - - //======================================================================== - //= FormLinkDialog - //======================================================================== - //------------------------------------------------------------------------ - FormLinkDialog::FormLinkDialog( Window* _pParent, const Reference< XPropertySet >& _rxDetailForm, - const Reference< XPropertySet >& _rxMasterForm, const Reference< XMultiServiceFactory >& _rxORB, - const ::rtl::OUString& _sExplanation, - const ::rtl::OUString& _sDetailLabel, - const ::rtl::OUString& _sMasterLabel) - :ModalDialog( _pParent, PcrRes( RID_DLG_FORMLINKS ) ) - ,m_aExplanation( this, PcrRes( FT_EXPLANATION ) ) - ,m_aDetailLabel( this, PcrRes( FT_DETAIL_LABEL ) ) - ,m_aMasterLabel( this, PcrRes( FT_MASTER_LABEL ) ) - ,m_aRow1 ( new FieldLinkRow( this, PcrRes( 1 ) ) ) - ,m_aRow2 ( new FieldLinkRow( this, PcrRes( 2 ) ) ) - ,m_aRow3 ( new FieldLinkRow( this, PcrRes( 3 ) ) ) - ,m_aRow4 ( new FieldLinkRow( this, PcrRes( 4 ) ) ) - ,m_aOK ( this, PcrRes( PB_OK ) ) - ,m_aCancel ( this, PcrRes( PB_CANCEL ) ) - ,m_aHelp ( this, PcrRes( PB_HELP ) ) - ,m_aSuggest ( this, PcrRes( PB_SUGGEST ) ) - ,m_xORB ( _rxORB ) - ,m_xDetailForm( _rxDetailForm ) - ,m_xMasterForm( _rxMasterForm ) - ,m_sDetailLabel(_sDetailLabel) - ,m_sMasterLabel(_sMasterLabel) - { - FreeResource(); - if ( _sExplanation.getLength() ) - m_aExplanation.SetText(_sExplanation); - - m_aSuggest.SetClickHdl ( LINK( this, FormLinkDialog, OnSuggest ) ); - m_aRow1->SetLinkChangeHandler( LINK( this, FormLinkDialog, OnFieldChanged ) ); - m_aRow2->SetLinkChangeHandler( LINK( this, FormLinkDialog, OnFieldChanged ) ); - m_aRow3->SetLinkChangeHandler( LINK( this, FormLinkDialog, OnFieldChanged ) ); - m_aRow4->SetLinkChangeHandler( LINK( this, FormLinkDialog, OnFieldChanged ) ); - - PostUserEvent( LINK( this, FormLinkDialog, OnInitialize ) ); - - updateOkButton(); - } - - //------------------------------------------------------------------------ - FormLinkDialog::~FormLinkDialog( ) - { - } - - //------------------------------------------------------------------------ - void FormLinkDialog::commitLinkPairs() - { - // collect the field lists from the rows - ::std::vector< ::rtl::OUString > aDetailFields; aDetailFields.reserve( 4 ); - ::std::vector< ::rtl::OUString > aMasterFields; aMasterFields.reserve( 4 ); - - const FieldLinkRow* aRows[] = { - m_aRow1.get(), m_aRow2.get(), m_aRow3.get(), m_aRow4.get() - }; - - for ( sal_Int32 i = 0; i < 4; ++i ) - { - String sDetailField, sMasterField; - aRows[ i ]->GetFieldName( FieldLinkRow::eDetailField, sDetailField ); - aRows[ i ]->GetFieldName( FieldLinkRow::eMasterField, sMasterField ); - if ( !sDetailField.Len() && !sMasterField.Len() ) - continue; - - aDetailFields.push_back( sDetailField ); - aMasterFields.push_back( sMasterField ); - } - - // and set as property values - try - { - Reference< XPropertySet > xDetailFormProps( m_xDetailForm, UNO_QUERY ); - if ( xDetailFormProps.is() ) - { - ::rtl::OUString *pFields = aDetailFields.empty() ? 0 : &aDetailFields[0]; - xDetailFormProps->setPropertyValue( PROPERTY_DETAILFIELDS, makeAny( Sequence< ::rtl::OUString >( pFields, aDetailFields.size() ) ) ); - pFields = aMasterFields.empty() ? 0 : &aMasterFields[0]; - xDetailFormProps->setPropertyValue( PROPERTY_MASTERFIELDS, makeAny( Sequence< ::rtl::OUString >( pFields, aMasterFields.size() ) ) ); - } - } - catch( const Exception& ) - { - OSL_FAIL( "FormLinkDialog::commitLinkPairs: caught an exception while setting the properties!" ); - } - } - - //------------------------------------------------------------------------ - short FormLinkDialog::Execute() - { - short nResult = ModalDialog::Execute(); - - if ( RET_OK == nResult ) - commitLinkPairs(); - - return nResult; - } - - //------------------------------------------------------------------------ - void FormLinkDialog::initializeFieldLists() - { - Sequence< ::rtl::OUString > sDetailFields; - getFormFields( m_xDetailForm, sDetailFields ); - - Sequence< ::rtl::OUString > sMasterFields; - getFormFields( m_xMasterForm, sMasterFields ); - - FieldLinkRow* aRows[] = { - m_aRow1.get(), m_aRow2.get(), m_aRow3.get(), m_aRow4.get() - }; - for ( sal_Int32 i = 0; i < 4 ; ++i ) - { - aRows[i]->fillList( FieldLinkRow::eDetailField, sDetailFields ); - aRows[i]->fillList( FieldLinkRow::eMasterField, sMasterFields ); - } - - } - - //------------------------------------------------------------------------ - void FormLinkDialog::initializeColumnLabels() - { - // label for the detail form - String sDetailType = getFormDataSourceType( m_xDetailForm ); - if ( !sDetailType.Len() ) - { - if ( !m_sDetailLabel.getLength() ) - { - ::svt::OLocalResourceAccess aStringAccess( PcrRes( RID_DLG_FORMLINKS ), RSC_MODALDIALOG ); - m_sDetailLabel = String( PcrRes( STR_DETAIL_FORM ) ); - } - sDetailType = m_sDetailLabel; - } - m_aDetailLabel.SetText( sDetailType ); - - // label for the master form - String sMasterType = getFormDataSourceType( m_xMasterForm ); - if ( !sMasterType.Len() ) - { - if ( !m_sMasterLabel.getLength() ) - { - ::svt::OLocalResourceAccess aStringAccess( PcrRes( RID_DLG_FORMLINKS ), RSC_MODALDIALOG ); - m_sMasterLabel = String( PcrRes( STR_MASTER_FORM ) ); - } - sMasterType = m_sMasterLabel; - } - m_aMasterLabel.SetText( sMasterType ); - } - - //------------------------------------------------------------------------ - void FormLinkDialog::initializeFieldRowsFrom( Sequence< ::rtl::OUString >& _rDetailFields, Sequence< ::rtl::OUString >& _rMasterFields ) - { - // our UI does allow 4 fields max - _rDetailFields.realloc( 4 ); - _rMasterFields.realloc( 4 ); - - const ::rtl::OUString* pDetailFields = _rDetailFields.getConstArray(); - const ::rtl::OUString* pMasterFields = _rMasterFields.getConstArray(); - - FieldLinkRow* aRows[] = { - m_aRow1.get(), m_aRow2.get(), m_aRow3.get(), m_aRow4.get() - }; - for ( sal_Int32 i = 0; i < 4; ++i, ++pDetailFields, ++pMasterFields ) - { - aRows[ i ]->SetFieldName( FieldLinkRow::eDetailField, *pDetailFields ); - aRows[ i ]->SetFieldName( FieldLinkRow::eMasterField, *pMasterFields ); - } - } - - //------------------------------------------------------------------------ - void FormLinkDialog::initializeLinks() - { - try - { - Sequence< ::rtl::OUString > aDetailFields; - Sequence< ::rtl::OUString > aMasterFields; - - Reference< XPropertySet > xDetailFormProps( m_xDetailForm, UNO_QUERY ); - if ( xDetailFormProps.is() ) - { - xDetailFormProps->getPropertyValue( PROPERTY_DETAILFIELDS ) >>= aDetailFields; - xDetailFormProps->getPropertyValue( PROPERTY_MASTERFIELDS ) >>= aMasterFields; - } - - initializeFieldRowsFrom( aDetailFields, aMasterFields ); - } - catch( const Exception& ) - { - OSL_FAIL( "FormLinkDialog::initializeLinks: caught an exception!" ); - } - } - - //------------------------------------------------------------------------ - void FormLinkDialog::updateOkButton() - { - // in all rows, there must be either two valid selections, or none at all - // If there is at least one row with exactly one valid selection, then the - // OKButton needs to be disabled - sal_Bool bEnable = sal_True; - - const FieldLinkRow* aRows[] = { - m_aRow1.get(), m_aRow2.get(), m_aRow3.get(), m_aRow4.get() - }; - - for ( sal_Int32 i = 0; ( i < 4 ) && bEnable; ++i ) - { - String sNotInterestedInRightNow; - if ( aRows[ i ]->GetFieldName( FieldLinkRow::eDetailField, sNotInterestedInRightNow ) - != aRows[ i ]->GetFieldName( FieldLinkRow::eMasterField, sNotInterestedInRightNow ) - ) - bEnable = sal_False; - } - - m_aOK.Enable( bEnable ); - } - - //------------------------------------------------------------------------ - String FormLinkDialog::getFormDataSourceType( const Reference< XPropertySet >& _rxForm ) const SAL_THROW(()) - { - String sReturn; - Reference< XPropertySet > xFormProps( _rxForm, UNO_QUERY ); - if ( !xFormProps.is() ) - return sReturn; - - try - { - sal_Int32 nCommandType = CommandType::COMMAND; - ::rtl::OUString sCommand; - - xFormProps->getPropertyValue( PROPERTY_COMMANDTYPE ) >>= nCommandType; - xFormProps->getPropertyValue( PROPERTY_COMMAND ) >>= sCommand; - - if ( ( nCommandType == CommandType::TABLE ) - || ( nCommandType == CommandType::QUERY ) - ) - sReturn = sCommand; - } - catch( const Exception& ) - { - OSL_FAIL( "FormLinkDialog::getFormDataSourceType: caught an exception!" ); - } - return sReturn; - } - - //------------------------------------------------------------------------ - void FormLinkDialog::getFormFields( const Reference< XPropertySet >& _rxForm, Sequence< ::rtl::OUString >& /* [out] */ _rNames ) const SAL_THROW(( )) - { - _rNames.realloc( 0 ); - - ::dbtools::SQLExceptionInfo aErrorInfo; - ::rtl::OUString sCommand; - try - { - WaitObject aWaitCursor( const_cast< FormLinkDialog* >( this ) ); - - Reference< XPropertySet > xFormProps( _rxForm, UNO_QUERY ); - OSL_ENSURE( xFormProps.is(), "FormLinkDialog::getFormFields: invalid form!" ); - - sal_Int32 nCommandType = CommandType::COMMAND; - - xFormProps->getPropertyValue( PROPERTY_COMMANDTYPE ) >>= nCommandType; - xFormProps->getPropertyValue( PROPERTY_COMMAND ) >>= sCommand; - - Reference< XConnection > xConnection; - ensureFormConnection( xFormProps, xConnection ); - - _rNames = ::dbtools::getFieldNamesByCommandDescriptor( - xConnection, - nCommandType, - sCommand, - &aErrorInfo - ); - } - catch (const SQLContext& e) { aErrorInfo = e; } - catch (const SQLWarning& e) { aErrorInfo = e; } - catch (const SQLException& e ) { aErrorInfo = e; } - catch( const Exception& ) - { - OSL_FAIL( "FormLinkDialog::getFormFields: caught a non-SQL exception!" ); - } - - if ( aErrorInfo.isValid() ) - { - String sErrorMessage; - { - ::svt::OLocalResourceAccess aStringAccess( PcrRes( RID_DLG_FORMLINKS ), RSC_MODALDIALOG ); - sErrorMessage = String( PcrRes( STR_ERROR_RETRIEVING_COLUMNS) ); - sErrorMessage.SearchAndReplace('#',sCommand); - } - - SQLContext aContext; - aContext.Message = sErrorMessage; - aContext.NextException = aErrorInfo.get(); - ::dbtools::showError( aContext, VCLUnoHelper::GetInterface( const_cast< FormLinkDialog* >( this ) ), m_xORB ); - } - } - - //------------------------------------------------------------------------ - void FormLinkDialog::ensureFormConnection( const Reference< XPropertySet >& _rxFormProps, Reference< XConnection >& /* [out] */ _rxConnection ) const SAL_THROW(( Exception )) - { - OSL_PRECOND( _rxFormProps.is(), "FormLinkDialog::ensureFormConnection: invalid form!" ); - if ( !_rxFormProps.is() ) - return; - if ( _rxFormProps->getPropertySetInfo()->hasPropertyByName(PROPERTY_ACTIVE_CONNECTION) ) - _rxConnection.set(_rxFormProps->getPropertyValue(PROPERTY_ACTIVE_CONNECTION),UNO_QUERY); - - if ( !_rxConnection.is() ) - _rxConnection = ::dbtools::connectRowset( Reference< XRowSet >( _rxFormProps, UNO_QUERY ), m_xORB, sal_True ); - } - - //------------------------------------------------------------------------ - void FormLinkDialog::getConnectionMetaData( const Reference< XPropertySet >& _rxFormProps, Reference< XDatabaseMetaData >& /* [out] */ _rxMeta ) const SAL_THROW(( Exception )) - { - if ( _rxFormProps.is() ) - { - Reference< XConnection > xConnection; - if ( !::dbtools::isEmbeddedInDatabase( _rxFormProps, xConnection ) ) - _rxFormProps->getPropertyValue( PROPERTY_ACTIVE_CONNECTION ) >>= xConnection; - if ( xConnection.is() ) - _rxMeta = xConnection->getMetaData(); - } - } - - //------------------------------------------------------------------------ - Reference< XPropertySet > FormLinkDialog::getCanonicUnderlyingTable( const Reference< XPropertySet >& _rxFormProps ) const - { - Reference< XPropertySet > xTable; - try - { - Reference< XTablesSupplier > xTablesInForm( ::dbtools::getCurrentSettingsComposer( _rxFormProps, m_xORB ), UNO_QUERY ); - Reference< XNameAccess > xTables; - if ( xTablesInForm.is() ) - xTables = xTablesInForm->getTables(); - Sequence< ::rtl::OUString > aTableNames; - if ( xTables.is() ) - aTableNames = xTables->getElementNames(); - - if ( aTableNames.getLength() == 1 ) - { - xTables->getByName( aTableNames[ 0 ] ) >>= xTable; - OSL_ENSURE( xTable.is(), "FormLinkDialog::getCanonicUnderlyingTable: invalid table!" ); - } - } - catch( const Exception& ) - { - OSL_FAIL( "FormLinkDialog::getCanonicUnderlyingTable: caught an exception!" ); - } - return xTable; - } - - //------------------------------------------------------------------------ - sal_Bool FormLinkDialog::getExistingRelation( const Reference< XPropertySet >& _rxLHS, const Reference< XPropertySet >& /*_rxRHS*/, - // TODO: fix the usage of _rxRHS. This is issue #i81956#. - Sequence< ::rtl::OUString >& _rLeftFields, Sequence< ::rtl::OUString >& _rRightFields ) const - { - try - { - Reference< XKeysSupplier > xSuppKeys( _rxLHS, UNO_QUERY ); - Reference< XIndexAccess > xKeys; - if ( xSuppKeys.is() ) - xKeys = xSuppKeys->getKeys(); - - if ( xKeys.is() ) - { - Reference< XPropertySet > xKey; - Reference< XColumnsSupplier > xKeyColSupp( xKey, UNO_QUERY ); - Reference< XIndexAccess > xKeyColumns; - Reference< XPropertySet > xKeyColumn; - ::rtl::OUString sColumnName, sRelatedColumnName; - - const sal_Int32 keyCount = xKeys->getCount(); - for ( sal_Int32 key = 0; key < keyCount; ++key ) - { - xKeys->getByIndex( key ) >>= xKey; - sal_Int32 nKeyType = 0; - xKey->getPropertyValue( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Type" ) ) ) >>= nKeyType; - if ( nKeyType != KeyType::FOREIGN ) - continue; - - xKeyColumns.clear(); - xKeyColSupp = xKeyColSupp.query( xKey ); - if ( xKeyColSupp.is() ) - xKeyColumns = xKeyColumns.query( xKeyColSupp->getColumns() ); - OSL_ENSURE( xKeyColumns.is(), "FormLinkDialog::getExistingRelation: could not obtain the columns for the key!" ); - - if ( !xKeyColumns.is() ) - continue; - - const sal_Int32 columnCount = xKeyColumns->getCount(); - _rLeftFields.realloc( columnCount ); - _rRightFields.realloc( columnCount ); - for ( sal_Int32 column = 0; column < columnCount; ++column ) - { - xKeyColumn.clear(); - xKeyColumns->getByIndex( column ) >>= xKeyColumn; - OSL_ENSURE( xKeyColumn.is(), "FormLinkDialog::getExistingRelation: invalid key column!" ); - if ( xKeyColumn.is() ) - { - xKeyColumn->getPropertyValue( PROPERTY_NAME ) >>= sColumnName; - xKeyColumn->getPropertyValue( ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "RelatedColumn" ) ) ) >>= sRelatedColumnName; - - _rLeftFields[ column ] = sColumnName; - _rRightFields[ column ] = sRelatedColumnName; - } - } - } - } - } - catch( const Exception& ) - { - OSL_FAIL( "FormLinkDialog::getExistingRelation: caught an exception!" ); - } - - return ( _rLeftFields.getLength() > 0 ) && ( _rLeftFields[ 0 ].getLength() > 0 ); - } - - //------------------------------------------------------------------------ - void FormLinkDialog::initializeSuggest() - { - Reference< XPropertySet > xDetailFormProps( m_xDetailForm, UNO_QUERY ); - Reference< XPropertySet > xMasterFormProps( m_xMasterForm, UNO_QUERY ); - if ( !xDetailFormProps.is() || !xMasterFormProps.is() ) - return; - - try - { - sal_Bool bEnable = sal_True; - - // only show the button when both forms are based on the same data source - if ( bEnable ) - { - ::rtl::OUString sMasterDS, sDetailDS; - xMasterFormProps->getPropertyValue( PROPERTY_DATASOURCE ) >>= sMasterDS; - xDetailFormProps->getPropertyValue( PROPERTY_DATASOURCE ) >>= sDetailDS; - bEnable = ( sMasterDS == sDetailDS ); - } - - // only show the button when the connection supports relations - if ( bEnable ) - { - Reference< XDatabaseMetaData > xMeta; - getConnectionMetaData( xDetailFormProps, xMeta ); - OSL_ENSURE( xMeta.is(), "FormLinkDialog::initializeSuggest: unable to retrieve the meta data for the connection!" ); - try - { - bEnable = xMeta.is() && xMeta->supportsIntegrityEnhancementFacility(); - } - catch(const Exception&) - { - bEnable = sal_False; - } - } - - // only enable the button if there is a "canonic" table underlying both forms - Reference< XPropertySet > xDetailTable, xMasterTable; - if ( bEnable ) - { - xDetailTable = getCanonicUnderlyingTable( xDetailFormProps ); - xMasterTable = getCanonicUnderlyingTable( xMasterFormProps ); - bEnable = xDetailTable.is() && xMasterTable.is(); - } - - // only enable the button if there is a relation between both tables - m_aRelationDetailColumns.realloc( 0 ); - m_aRelationMasterColumns.realloc( 0 ); - if ( bEnable ) - { - bEnable = getExistingRelation( xDetailTable, xMasterTable, m_aRelationDetailColumns, m_aRelationMasterColumns ); - OSL_POSTCOND( m_aRelationMasterColumns.getLength() == m_aRelationDetailColumns.getLength(), "FormLinkDialog::initializeSuggest: nonsense!" ); - if ( m_aRelationMasterColumns.getLength() == 0 ) - { // okay, there is no relation "pointing" (via a foreign key) from the detail table to the master table - // but perhaps the other way round (would make less sense, but who knows ...) - bEnable = getExistingRelation( xMasterTable, xDetailTable, m_aRelationMasterColumns, m_aRelationDetailColumns ); - } - } - - // only enable the button if the relation contains at most 4 field pairs - if ( bEnable ) - { - bEnable = ( m_aRelationMasterColumns.getLength() <= 4 ); - } - - m_aSuggest.Enable( bEnable ); - } - catch( const Exception& ) - { - OSL_FAIL( "FormLinkDialog::initializeSuggest: caught an exception!" ); - } - } - - //------------------------------------------------------------------------ - IMPL_LINK( FormLinkDialog, OnSuggest, void*, /*_pNotInterestedIn*/ ) - { - initializeFieldRowsFrom( m_aRelationDetailColumns, m_aRelationMasterColumns ); - return 0L; - } - - //------------------------------------------------------------------------ - IMPL_LINK( FormLinkDialog, OnFieldChanged, FieldLinkRow*, /*_pRow*/ ) - { - updateOkButton(); - return 0L; - } - - //------------------------------------------------------------------------ - IMPL_LINK( FormLinkDialog, OnInitialize, void*, /*_pNotInterestedIn*/ ) - { - initializeColumnLabels(); - initializeFieldLists(); - initializeLinks(); - initializeSuggest(); - return 0L; - } -//............................................................................ -} // namespace pcr -//............................................................................ - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |