/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * 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 . */ #include #include #include "addresstemplate.hrc" #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include namespace svt { using namespace ::com::sun::star::uno; using namespace ::com::sun::star::lang; using namespace ::com::sun::star::container; using namespace ::com::sun::star::ui::dialogs; using namespace ::com::sun::star::util; using namespace ::com::sun::star::beans; using namespace ::com::sun::star::sdb; using namespace ::com::sun::star::sdbc; using namespace ::com::sun::star::sdbcx; using namespace ::com::sun::star::task; using namespace ::comphelper; using namespace ::utl; typedef std::vector StringArray; typedef std::set StringBag; typedef std::map MapString2String; namespace { OUString lcl_getSelectedDataSource( const ComboBox& _dataSourceCombo ) { OUString selectedDataSource = _dataSourceCombo.GetText(); if ( _dataSourceCombo.GetEntryPos( selectedDataSource ) == LISTBOX_ENTRY_NOTFOUND ) { // none of the pre-selected entries -> assume a path to a database document OFileNotation aFileNotation( selectedDataSource, OFileNotation::N_SYSTEM ); selectedDataSource = aFileNotation.get( OFileNotation::N_URL ); } return selectedDataSource; } } // = IAssigmentData class IAssigmentData { public: virtual ~IAssigmentData(); /// the data source to use for the address book virtual OUString getDatasourceName() const = 0; /// the command to use for the address book virtual OUString getCommand() const = 0; /// checks whether or not there is an assignment for a given logical field virtual bool hasFieldAssignment(const OUString& _rLogicalName) = 0; /// retrieves the assignment for a given logical field virtual OUString getFieldAssignment(const OUString& _rLogicalName) = 0; /// set the assignment for a given logical field virtual void setFieldAssignment(const OUString& _rLogicalName, const OUString& _rAssignment) = 0; virtual void setDatasourceName(const OUString& _rName) = 0; virtual void setCommand(const OUString& _rCommand) = 0; }; IAssigmentData::~IAssigmentData() { } // = AssigmentTransientData class AssigmentTransientData : public IAssigmentData { protected: Reference< XDataSource > m_xDataSource; OUString m_sDSName; OUString m_sTableName; MapString2String m_aAliases; public: AssigmentTransientData( const Reference< XDataSource >& _rxDataSource, const OUString& _rDataSourceName, const OUString& _rTableName, const Sequence< AliasProgrammaticPair >& _rFields ); // IAssigmentData overridables virtual OUString getDatasourceName() const SAL_OVERRIDE; virtual OUString getCommand() const SAL_OVERRIDE; virtual bool hasFieldAssignment(const OUString& _rLogicalName) SAL_OVERRIDE; virtual OUString getFieldAssignment(const OUString& _rLogicalName) SAL_OVERRIDE; virtual void setFieldAssignment(const OUString& _rLogicalName, const OUString& _rAssignment) SAL_OVERRIDE; virtual void setDatasourceName(const OUString& _rName) SAL_OVERRIDE; virtual void setCommand(const OUString& _rCommand) SAL_OVERRIDE; }; AssigmentTransientData::AssigmentTransientData( const Reference< XDataSource >& _rxDataSource, const OUString& _rDataSourceName, const OUString& _rTableName, const Sequence< AliasProgrammaticPair >& _rFields ) :m_xDataSource( _rxDataSource ) ,m_sDSName( _rDataSourceName ) ,m_sTableName( _rTableName ) { // fill our aliases structure // first collect all known programmatic names StringBag aKnownNames; OUString sLogicalFieldNames(SVT_RESSTR(STR_LOGICAL_FIELD_NAMES)); sal_Int32 nIndex = 0; do { OUString aToken = sLogicalFieldNames.getToken(0, ';', nIndex); aKnownNames.insert(aToken); } while ( nIndex >= 0); // loop through the given names const AliasProgrammaticPair* pFields = _rFields.getConstArray(); const AliasProgrammaticPair* pFieldsEnd = pFields + _rFields.getLength(); for (;pFields != pFieldsEnd; ++pFields) { StringBag::const_iterator aKnownPos = aKnownNames.find( pFields->ProgrammaticName ); if ( aKnownNames.end() != aKnownPos ) { m_aAliases[ pFields->ProgrammaticName ] = pFields->Alias; } else { OSL_FAIL( ( OString("AssigmentTransientData::AssigmentTransientData: unknown programmatic name (") += OString(pFields->ProgrammaticName.getStr(), pFields->ProgrammaticName.getLength(), RTL_TEXTENCODING_ASCII_US) += OString(")!") ).getStr() ); } } } OUString AssigmentTransientData::getDatasourceName() const { return m_sDSName; } OUString AssigmentTransientData::getCommand() const { return m_sTableName; } bool AssigmentTransientData::hasFieldAssignment(const OUString& _rLogicalName) { MapString2String::const_iterator aPos = m_aAliases.find( _rLogicalName ); return ( m_aAliases.end() != aPos ) && ( !aPos->second.isEmpty() ); } OUString AssigmentTransientData::getFieldAssignment(const OUString& _rLogicalName) { OUString sReturn; MapString2String::const_iterator aPos = m_aAliases.find( _rLogicalName ); if ( m_aAliases.end() != aPos ) sReturn = aPos->second; return sReturn; } void AssigmentTransientData::setFieldAssignment(const OUString& _rLogicalName, const OUString& _rAssignment) { m_aAliases[ _rLogicalName ] = _rAssignment; } void AssigmentTransientData::setDatasourceName(const OUString&) { OSL_FAIL( "AssigmentTransientData::setDatasourceName: cannot be implemented for transient data!" ); } void AssigmentTransientData::setCommand(const OUString&) { OSL_FAIL( "AssigmentTransientData::setCommand: cannot be implemented for transient data!" ); } // = AssignmentPersistentData class AssignmentPersistentData :public ::utl::ConfigItem ,public IAssigmentData { protected: StringBag m_aStoredFields; protected: ::com::sun::star::uno::Any getProperty(const OUString& _rLocalName) const; ::com::sun::star::uno::Any getProperty(const sal_Char* _pLocalName) const; OUString getStringProperty(const sal_Char* _pLocalName) const; OUString getStringProperty(const OUString& _rLocalName) const; void setStringProperty(const sal_Char* _pLocalName, const OUString& _rValue); public: AssignmentPersistentData(); virtual ~AssignmentPersistentData(); // IAssigmentData overridables virtual OUString getDatasourceName() const SAL_OVERRIDE; virtual OUString getCommand() const SAL_OVERRIDE; virtual bool hasFieldAssignment(const OUString& _rLogicalName) SAL_OVERRIDE; virtual OUString getFieldAssignment(const OUString& _rLogicalName) SAL_OVERRIDE; virtual void setFieldAssignment(const OUString& _rLogicalName, const OUString& _rAssignment) SAL_OVERRIDE; virtual void setDatasourceName(const OUString& _rName) SAL_OVERRIDE; virtual void setCommand(const OUString& _rCommand) SAL_OVERRIDE; virtual void Notify( const com::sun::star::uno::Sequence& aPropertyNames) SAL_OVERRIDE; virtual void Commit() SAL_OVERRIDE; private: virtual void clearFieldAssignment(const OUString& _rLogicalName); }; void AssignmentPersistentData::Notify( const com::sun::star::uno::Sequence& ) { } void AssignmentPersistentData::Commit() { } AssignmentPersistentData::AssignmentPersistentData() :ConfigItem( OUString( "Office.DataAccess/AddressBook" )) { Sequence< OUString > aStoredNames = GetNodeNames(OUString("Fields")); const OUString* pStoredNames = aStoredNames.getConstArray(); for (sal_Int32 i=0; i aProperties(&_rLocalName, 1); Sequence< Any > aValues = const_cast(this)->GetProperties(aProperties); DBG_ASSERT(aValues.getLength() == 1, "AssignmentPersistentData::getProperty: invalid sequence length!"); return aValues[0]; } OUString AssignmentPersistentData::getStringProperty(const OUString& _rLocalName) const { OUString sReturn; getProperty( _rLocalName ) >>= sReturn; return sReturn; } OUString AssignmentPersistentData::getStringProperty(const sal_Char* _pLocalName) const { OUString sReturn; getProperty( _pLocalName ) >>= sReturn; return sReturn; } void AssignmentPersistentData::setStringProperty(const sal_Char* _pLocalName, const OUString& _rValue) { Sequence< OUString > aNames(1); Sequence< Any > aValues(1); aNames[0] = OUString::createFromAscii(_pLocalName); aValues[0] <<= _rValue; PutProperties(aNames, aValues); } void AssignmentPersistentData::setFieldAssignment(const OUString& _rLogicalName, const OUString& _rAssignment) { if (_rAssignment.isEmpty()) { if (hasFieldAssignment(_rLogicalName)) { // the assignment exists but it should be reset clearFieldAssignment(_rLogicalName); } return; } // Fields OUString sDescriptionNodePath("Fields"); // Fields/ OUString sFieldElementNodePath(sDescriptionNodePath); sFieldElementNodePath += "/"; sFieldElementNodePath += _rLogicalName; Sequence< PropertyValue > aNewFieldDescription(2); // Fields//ProgrammaticFieldName aNewFieldDescription[0].Name = sFieldElementNodePath + "/ProgrammaticFieldName"; aNewFieldDescription[0].Value <<= _rLogicalName; // Fields//AssignedFieldName aNewFieldDescription[1].Name = sFieldElementNodePath + "/AssignedFieldName"; aNewFieldDescription[1].Value <<= _rAssignment; // just set the new value #ifdef DBG_UTIL bool bSuccess = #endif SetSetProperties(sDescriptionNodePath, aNewFieldDescription); DBG_ASSERT(bSuccess, "AssignmentPersistentData::setFieldAssignment: could not commit the changes a field!"); } void AssignmentPersistentData::clearFieldAssignment(const OUString& _rLogicalName) { if (!hasFieldAssignment(_rLogicalName)) // nothing to do return; OUString sDescriptionNodePath("Fields"); Sequence< OUString > aNames(&_rLogicalName, 1); ClearNodeElements(sDescriptionNodePath, aNames); } OUString AssignmentPersistentData::getDatasourceName() const { return getStringProperty( "DataSourceName" ); } OUString AssignmentPersistentData::getCommand() const { return getStringProperty( "Command" ); } void AssignmentPersistentData::setDatasourceName(const OUString& _rName) { setStringProperty( "DataSourceName", _rName ); } void AssignmentPersistentData::setCommand(const OUString& _rCommand) { setStringProperty( "Command", _rCommand ); } // = AddressBookSourceDialogData struct AddressBookSourceDialogData { FixedText* pFieldLabels[FIELD_PAIRS_VISIBLE * 2]; ListBox* pFields[FIELD_PAIRS_VISIBLE * 2]; /// when working transient, we need the data source Reference< XDataSource > m_xTransientDataSource; /// current scroll pos in the field list sal_Int32 nFieldScrollPos; /// the index within m_pFields of the last visible list box. This is redundant, it could be extracted from other members sal_Int32 nLastVisibleListIndex; /// indicates that we've an odd field number. This member is for efficiency only, it's redundant. bool bOddFieldNumber : 1; /// indicates that we're working with the real persistent configuration bool bWorkingPersistent : 1; /// the strings to use as labels for the field selection listboxes StringArray aFieldLabels; // the current field assignment StringArray aFieldAssignments; /// the logical field names StringArray aLogicalFieldNames; IAssigmentData* pConfigData; AddressBookSourceDialogData( ) :nFieldScrollPos(0) ,nLastVisibleListIndex(0) ,bOddFieldNumber(false) ,bWorkingPersistent( true ) ,pConfigData( new AssignmentPersistentData ) { memset(pFieldLabels, 0, sizeof(pFieldLabels)); memset(pFields, 0, sizeof(pFields)); } AddressBookSourceDialogData( const Reference< XDataSource >& _rxTransientDS, const OUString& _rDataSourceName, const OUString& _rTableName, const Sequence< AliasProgrammaticPair >& _rFields ) :m_xTransientDataSource( _rxTransientDS ) ,nFieldScrollPos(0) ,nLastVisibleListIndex(0) ,bOddFieldNumber(false) ,bWorkingPersistent( false ) ,pConfigData( new AssigmentTransientData( m_xTransientDataSource, _rDataSourceName, _rTableName, _rFields ) ) { memset(pFieldLabels, 0, sizeof(pFieldLabels)); memset(pFields, 0, sizeof(pFields)); } ~AddressBookSourceDialogData() { delete pConfigData; } }; // = AddressBookSourceDialog AddressBookSourceDialog::AddressBookSourceDialog(Window* _pParent, const Reference< XComponentContext >& _rxORB ) : ModalDialog(_pParent, "AddressTemplateDialog", "svt/ui/addresstemplatedialog.ui") , m_sNoFieldSelection(SVT_RESSTR(STR_NO_FIELD_SELECTION)) , m_xORB(_rxORB) , m_pImpl( new AddressBookSourceDialogData ) { implConstruct(); } AddressBookSourceDialog::AddressBookSourceDialog( Window* _pParent, const Reference< XComponentContext >& _rxORB, const Reference< XDataSource >& _rxTransientDS, const OUString& _rDataSourceName, const OUString& _rTable, const Sequence< AliasProgrammaticPair >& _rMapping ) : ModalDialog(_pParent, "AddressTemplateDialog", "svt/ui/addresstemplatedialog.ui") , m_sNoFieldSelection(SVT_RESSTR(STR_NO_FIELD_SELECTION)) , m_xORB(_rxORB) , m_pImpl( new AddressBookSourceDialogData( _rxTransientDS, _rDataSourceName, _rTable, _rMapping ) ) { implConstruct(); } void AddressBookSourceDialog::implConstruct() { get(m_pDatasource, "datasource"); get(m_pAdministrateDatasources, "admin"); get(m_pTable, "datatable"); VclScrolledWindow *pScrollWindow = get("scrollwindow"); pScrollWindow->setUserManagedScrolling(true); m_pFieldScroller = &pScrollWindow->getVertScrollBar(); for (sal_Int32 row=0; rowpFieldLabels[row * 2 + column] = get(OString("label") + OString::number(row * 2 + column)); // the listbox m_pImpl->pFields[row * 2 + column] = get(OString("box") + OString::number(row * 2 + column)); m_pImpl->pFields[row * 2 + column]->SetSelectHdl(LINK(this, AddressBookSourceDialog, OnFieldSelect)); } } initializeDatasources(); // for the moment, we have a hard coded list of all known fields. // A better solution would be to store all known field translations in the configuration, which could be // extensible by the user in an arbitrary way. // But for the moment we need a quick solution ... // (the main thing would be to store the translations to use here in the user interface, besides that, the code // should be adjustable with a rather small effort.) // initialize the strings for the field labels m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_FIRSTNAME )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_LASTNAME )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_COMPANY)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_DEPARTMENT )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_STREET )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_ZIPCODE )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_CITY )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_STATE)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_COUNTRY )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_HOMETEL )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_WORKTEL )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_OFFICETEL)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_MOBILE)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_TELOTHER)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_PAGER)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_FAX )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_EMAIL )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_URL )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_TITLE )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_POSITION )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_INITIALS )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_ADDRFORM )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_SALUTATION )); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_ID)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_CALENDAR)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_INVITE)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_NOTE)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_USER1)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_USER2)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_USER3)); m_pImpl->aFieldLabels.push_back( SVT_RESSTR( STR_FIELD_USER4)); long nLabelWidth = 0; long nListBoxWidth = m_pImpl->pFields[0]->approximate_char_width() * 20; for (StringArray::const_iterator aI = m_pImpl->aFieldLabels.begin(), aEnd = m_pImpl->aFieldLabels.end(); aI != aEnd; ++aI) { nLabelWidth = std::max(nLabelWidth, FixedText::getTextDimensions(m_pImpl->pFieldLabels[0], *aI, 0x7FFFFFFF).Width()); } for (sal_Int32 row=0; rowpFieldLabels[row * 2 + column]->set_width_request(nLabelWidth); m_pImpl->pFields[row * 2 + column]->set_width_request(nListBoxWidth); } } // force a even number of known fields m_pImpl->bOddFieldNumber = (m_pImpl->aFieldLabels.size() % 2) != 0; if (m_pImpl->bOddFieldNumber) m_pImpl->aFieldLabels.push_back( OUString() ); // limit the scrollbar range accordingly sal_Int32 nOverallFieldPairs = m_pImpl->aFieldLabels.size() / 2; m_pFieldScroller->SetRange( Range(0, nOverallFieldPairs - FIELD_PAIRS_VISIBLE) ); m_pFieldScroller->SetLineSize(1); m_pFieldScroller->SetPageSize(FIELD_PAIRS_VISIBLE); // reset the current field assignments m_pImpl->aFieldAssignments.resize(m_pImpl->aFieldLabels.size()); // (empty strings mean "no assignment") // some knittings m_pFieldScroller->SetScrollHdl(LINK(this, AddressBookSourceDialog, OnFieldScroll)); m_pAdministrateDatasources->SetClickHdl(LINK(this, AddressBookSourceDialog, OnAdministrateDatasources)); m_pDatasource->EnableAutocomplete(true); m_pTable->EnableAutocomplete(true); m_pTable->SetGetFocusHdl(LINK(this, AddressBookSourceDialog, OnComboGetFocus)); m_pDatasource->SetGetFocusHdl(LINK(this, AddressBookSourceDialog, OnComboGetFocus)); m_pTable->SetLoseFocusHdl(LINK(this, AddressBookSourceDialog, OnComboLoseFocus)); m_pDatasource->SetLoseFocusHdl(LINK(this, AddressBookSourceDialog, OnComboLoseFocus)); m_pTable->SetSelectHdl(LINK(this, AddressBookSourceDialog, OnComboSelect)); m_pDatasource->SetSelectHdl(LINK(this, AddressBookSourceDialog, OnComboSelect)); get("ok")->SetClickHdl(LINK(this, AddressBookSourceDialog, OnOkClicked)); // initialize the field controls resetFields(); m_pFieldScroller->SetThumbPos(0); m_pImpl->nFieldScrollPos = -1; implScrollFields(0, false, false); // the logical names OUString sLogicalFieldNames(SVT_RESSTR(STR_LOGICAL_FIELD_NAMES)); sal_Int32 nAdjustedTokenCount = comphelper::string::getTokenCount(sLogicalFieldNames, ';') + (m_pImpl->bOddFieldNumber ? 1 : 0); DBG_ASSERT(nAdjustedTokenCount == (sal_Int32)m_pImpl->aFieldLabels.size(), "AddressBookSourceDialog::AddressBookSourceDialog: inconsistence between logical and UI field names!"); m_pImpl->aLogicalFieldNames.reserve(nAdjustedTokenCount); for (sal_Int32 i = 0; iaLogicalFieldNames.push_back(comphelper::string::getToken(sLogicalFieldNames, i, ';')); PostUserEvent(LINK(this, AddressBookSourceDialog, OnDelayedInitialize)); // so the dialog will at least show up before we do the loading of the // configuration data and the (maybe time consuming) analysis of the data source/table to select if ( !m_pImpl->bWorkingPersistent ) { StyleSettings aSystemStyle = GetSettings().GetStyleSettings(); const ::Color& rNewColor = aSystemStyle.GetDialogColor(); m_pDatasource->SetReadOnly( true ); m_pDatasource->SetBackground( Wallpaper( rNewColor ) ); m_pDatasource->SetControlBackground( rNewColor ); m_pTable->SetReadOnly( true ); m_pTable->SetBackground( Wallpaper( rNewColor ) ); m_pTable->SetControlBackground( rNewColor ); m_pAdministrateDatasources->Hide( ); } } void AddressBookSourceDialog::getFieldMapping(Sequence< AliasProgrammaticPair >& _rMapping) const { _rMapping.realloc( m_pImpl->aLogicalFieldNames.size() ); AliasProgrammaticPair* pPair = _rMapping.getArray(); OUString sCurrent; for ( StringArray::const_iterator aProgrammatic = m_pImpl->aLogicalFieldNames.begin(); aProgrammatic != m_pImpl->aLogicalFieldNames.end(); ++aProgrammatic ) { sCurrent = *aProgrammatic; if ( m_pImpl->pConfigData->hasFieldAssignment( sCurrent ) ) { // the user gave us an assignment for this field pPair->ProgrammaticName = *aProgrammatic; pPair->Alias = m_pImpl->pConfigData->getFieldAssignment( *aProgrammatic ); ++pPair; } } _rMapping.realloc( pPair - _rMapping.getArray() ); } void AddressBookSourceDialog::loadConfiguration() { OUString sName = m_pImpl->pConfigData->getDatasourceName(); INetURLObject aURL( sName ); if( aURL.GetProtocol() != INET_PROT_NOT_VALID ) { OFileNotation aFileNotation( aURL.GetMainURL( INetURLObject::NO_DECODE ) ); sName = aFileNotation.get(OFileNotation::N_SYSTEM); } m_pDatasource->SetText(sName); m_pTable->SetText(m_pImpl->pConfigData->getCommand()); // we ignore the CommandType: only tables are supported // the logical names for the fields // AddressBookSourceDialog::loadConfiguration: inconsistence between field names and field assignments! assert(m_pImpl->aLogicalFieldNames.size() == m_pImpl->aFieldAssignments.size()); StringArray::const_iterator aLogical = m_pImpl->aLogicalFieldNames.begin(); StringArray::iterator aAssignment = m_pImpl->aFieldAssignments.begin(); for ( ; aLogical != m_pImpl->aLogicalFieldNames.end(); ++aLogical, ++aAssignment ) *aAssignment = m_pImpl->pConfigData->getFieldAssignment(*aLogical); } AddressBookSourceDialog::~AddressBookSourceDialog() { delete m_pImpl; } void AddressBookSourceDialog::initializeDatasources() { if (!m_xDatabaseContext.is()) { DBG_ASSERT(m_xORB.is(), "AddressBookSourceDialog::initializeDatasources: no service factory!"); if (!m_xORB.is()) return; try { m_xDatabaseContext = DatabaseContext::create(m_xORB); } catch(const Exception&) { } if (!m_xDatabaseContext.is()) { const OUString sContextServiceName("com.sun.star.sdb.DatabaseContext"); ShowServiceNotAvailableError( this, sContextServiceName, false); return; } } m_pDatasource->Clear(); // fill the datasources listbox Sequence< OUString > aDatasourceNames; try { aDatasourceNames = m_xDatabaseContext->getElementNames(); } catch(Exception&) { OSL_FAIL("AddressBookSourceDialog::initializeDatasources: caught an exception while asking for the data source names!"); } const OUString* pDatasourceNames = aDatasourceNames.getConstArray(); const OUString* pEnd = pDatasourceNames + aDatasourceNames.getLength(); for (; pDatasourceNames < pEnd; ++pDatasourceNames) m_pDatasource->InsertEntry(*pDatasourceNames); } IMPL_LINK(AddressBookSourceDialog, OnFieldScroll, ScrollBar*, _pScrollBar) { implScrollFields( _pScrollBar->GetThumbPos(), true, true ); return 0L; } void AddressBookSourceDialog::resetTables() { if (!m_xDatabaseContext.is()) return; WaitObject aWaitCursor(this); // no matter what we do here, we handled the currently selected data source (no matter if successful or not) m_pDatasource->SaveValue(); // create an interaction handler (may be needed for connecting) Reference< XInteractionHandler > xHandler; try { xHandler.set( InteractionHandler::createWithParent(m_xORB, 0), UNO_QUERY_THROW ); } catch(const Exception&) { } if (!xHandler.is()) { const OUString sInteractionHandlerServiceName("com.sun.star.task.InteractionHandler"); ShowServiceNotAvailableError(this, sInteractionHandlerServiceName, true); return; } // the currently selected table OUString sOldTable = m_pTable->GetText(); m_pTable->Clear(); m_xCurrentDatasourceTables= NULL; // get the tables of the connection Sequence< OUString > aTableNames; Any aException; try { Reference< XCompletedConnection > xDS; if ( m_pImpl->bWorkingPersistent ) { OUString sSelectedDS = lcl_getSelectedDataSource(*m_pDatasource); // get the data source the user has chosen and let it build a connection INetURLObject aURL( sSelectedDS ); if ( aURL.GetProtocol() != INET_PROT_NOT_VALID || m_xDatabaseContext->hasByName(sSelectedDS) ) m_xDatabaseContext->getByName( sSelectedDS ) >>= xDS; } else { xDS.set(m_pImpl->m_xTransientDataSource, css::uno::UNO_QUERY); } // build the connection Reference< XConnection > xConn; if (xDS.is()) xConn = xDS->connectWithCompletion(xHandler); // get the table names Reference< XTablesSupplier > xSupplTables(xConn, UNO_QUERY); if (xSupplTables.is()) { m_xCurrentDatasourceTables = Reference< XNameAccess >(xSupplTables->getTables(), UNO_QUERY); if (m_xCurrentDatasourceTables.is()) aTableNames = m_xCurrentDatasourceTables->getElementNames(); } } catch(const SQLContext& e) { aException <<= e; } catch(const SQLWarning& e) { aException <<= e; } catch(const SQLException& e) { aException <<= e; } catch(Exception&) { OSL_FAIL("AddressBookSourceDialog::resetTables: could not retrieve the table!"); } if (aException.hasValue()) { Reference< XInteractionRequest > xRequest = new OInteractionRequest(aException); try { xHandler->handle(xRequest); } catch(Exception&) { } return; } bool bKnowOldTable = false; // fill the table list const OUString* pTableNames = aTableNames.getConstArray(); const OUString* pEnd = pTableNames + aTableNames.getLength(); for (;pTableNames != pEnd; ++pTableNames) { m_pTable->InsertEntry(*pTableNames); if (0 == pTableNames->compareTo(sOldTable)) bKnowOldTable = true; } // set the old table, if the new data source knows a table with this name, too. Else reset the tables edit field. if (!bKnowOldTable) sOldTable = OUString(); m_pTable->SetText(sOldTable); resetFields(); } void AddressBookSourceDialog::resetFields() { WaitObject aWaitCursor(this); // no matter what we do here, we handled the currently selected table (no matter if successful or not) m_pDatasource->SaveValue(); OUString sSelectedTable = m_pTable->GetText(); Sequence< OUString > aColumnNames; try { if (m_xCurrentDatasourceTables.is()) { // get the table and the columns Reference< XColumnsSupplier > xSuppTableCols; if (m_xCurrentDatasourceTables->hasByName(sSelectedTable)) xSuppTableCols.set( m_xCurrentDatasourceTables->getByName(sSelectedTable), css::uno::UNO_QUERY); Reference< XNameAccess > xColumns; if (xSuppTableCols.is()) xColumns = xSuppTableCols->getColumns(); if (xColumns.is()) aColumnNames = xColumns->getElementNames(); } } catch (const Exception&) { OSL_FAIL("AddressBookSourceDialog::resetFields: could not retrieve the table columns!"); } const OUString* pColumnNames = aColumnNames.getConstArray(); const OUString* pEnd = pColumnNames + aColumnNames.getLength(); // for quicker access ::std::set< OUString > aColumnNameSet; for (pColumnNames = aColumnNames.getConstArray(); pColumnNames != pEnd; ++pColumnNames) aColumnNameSet.insert(*pColumnNames); std::vector::iterator aInitialSelection = m_pImpl->aFieldAssignments.begin() + m_pImpl->nFieldScrollPos; ListBox** pListbox = m_pImpl->pFields; OUString sSaveSelection; for (sal_Int32 i=0; iGetSelectEntry(); (*pListbox)->Clear(); // the one entry for "no selection" (*pListbox)->InsertEntry(m_sNoFieldSelection, 0); // as it's entry data, set the index of the list box in our array (*pListbox)->SetEntryData(0, reinterpret_cast(i)); // the field names for (pColumnNames = aColumnNames.getConstArray(); pColumnNames != pEnd; ++pColumnNames) (*pListbox)->InsertEntry(*pColumnNames); if (!aInitialSelection->isEmpty() && (aColumnNameSet.end() != aColumnNameSet.find(*aInitialSelection))) // we can select the entry as specified in our field assignment array (*pListbox)->SelectEntry(*aInitialSelection); else // try to restore the selection if (aColumnNameSet.end() != aColumnNameSet.find(sSaveSelection)) // the old selection is a valid column name (*pListbox)->SelectEntry(sSaveSelection); else // select the entry (*pListbox)->SelectEntryPos(0); } // adjust m_pImpl->aFieldAssignments for ( StringArray::iterator aAdjust = m_pImpl->aFieldAssignments.begin(); aAdjust != m_pImpl->aFieldAssignments.end(); ++aAdjust ) if (!aAdjust->isEmpty()) if (aColumnNameSet.end() == aColumnNameSet.find(*aAdjust)) (*aAdjust) = ""; } IMPL_LINK(AddressBookSourceDialog, OnFieldSelect, ListBox*, _pListbox) { // the index of the affected list box in our array sal_IntPtr nListBoxIndex = reinterpret_cast(_pListbox->GetEntryData(0)); DBG_ASSERT(nListBoxIndex >= 0 && nListBoxIndex < FIELD_CONTROLS_VISIBLE, "AddressBookSourceDialog::OnFieldScroll: invalid list box entry!"); // update the array where we remember the field selections if (0 == _pListbox->GetSelectEntryPos()) // it's the "no field selection" entry m_pImpl->aFieldAssignments[m_pImpl->nFieldScrollPos * 2 + nListBoxIndex] = ""; else // it's a regular field entry m_pImpl->aFieldAssignments[m_pImpl->nFieldScrollPos * 2 + nListBoxIndex] = _pListbox->GetSelectEntry(); return 0L; } void AddressBookSourceDialog::implScrollFields(sal_Int32 _nPos, bool _bAdjustFocus, bool _bAdjustScrollbar) { if (_nPos == m_pImpl->nFieldScrollPos) // nothing to do return; // loop through our field control rows and do some adjustments // for the new texts FixedText** pLeftLabelControl = m_pImpl->pFieldLabels; FixedText** pRightLabelControl = pLeftLabelControl + 1; StringArray::const_iterator pLeftColumnLabel = m_pImpl->aFieldLabels.begin() + 2 * _nPos; StringArray::const_iterator pRightColumnLabel = pLeftColumnLabel + 1; // for the focus movement and the selection scroll ListBox** pLeftListControl = m_pImpl->pFields; ListBox** pRightListControl = pLeftListControl + 1; // for the focus movement sal_Int32 nOldFocusRow = -1; sal_Int32 nOldFocusColumn = 0; // for the selection scroll StringArray::const_iterator pLeftAssignment = m_pImpl->aFieldAssignments.begin() + 2 * _nPos; StringArray::const_iterator pRightAssignment = pLeftAssignment + 1; m_pImpl->nLastVisibleListIndex = -1; // loop for (sal_Int32 i=0; iHasChildPathFocus()) { nOldFocusRow = i; nOldFocusColumn = 0; } else if ((*pRightListControl)->HasChildPathFocus()) { nOldFocusRow = i; nOldFocusColumn = 1; } // the new texts of the label controls (*pLeftLabelControl)->SetText(*pLeftColumnLabel); (*pRightLabelControl)->SetText(*pRightColumnLabel); // we may have to hide the controls in the right column, if we have no label text for it // (which means we have an odd number of fields, though we forced our internal arrays to // be even-sized for easier handling) // (If sometimes we support an arbitrary number of field assignments, we would have to care for // an invisible left hand side column, too. But right now, the left hand side controls are always // visible) bool bHideRightColumn = pRightColumnLabel->isEmpty(); (*pRightLabelControl)->Show(!bHideRightColumn); (*pRightListControl)->Show(!bHideRightColumn); // the new selections of the listboxes implSelectField(*pLeftListControl, *pLeftAssignment); implSelectField(*pRightListControl, *pRightAssignment); // the index of the last visible list box ++m_pImpl->nLastVisibleListIndex; // the left hand side box is always visible if (!bHideRightColumn) ++m_pImpl->nLastVisibleListIndex; // increment ... if ( i < FIELD_PAIRS_VISIBLE - 1 ) { // (not in the very last round, here the +=2 could result in an invalid // iterator position, which causes an abort in a non-product version pLeftLabelControl += 2; pRightLabelControl += 2; pLeftColumnLabel += 2; pRightColumnLabel += 2; pLeftListControl += 2; pRightListControl += 2; pLeftAssignment += 2; pRightAssignment += 2; } } if (_bAdjustFocus && (nOldFocusRow >= 0)) { // we have to adjust the focus and one of the list boxes has the focus sal_Int32 nDelta = m_pImpl->nFieldScrollPos - _nPos; // the new row for the focus sal_Int32 nNewFocusRow = nOldFocusRow + nDelta; // normalize nNewFocusRow = std::min(nNewFocusRow, (sal_Int32)(FIELD_PAIRS_VISIBLE - 1), ::std::less< sal_Int32 >()); nNewFocusRow = std::max(nNewFocusRow, (sal_Int32)0, ::std::less< sal_Int32 >()); // set the new focus (in the same column) m_pImpl->pFields[nNewFocusRow * 2 + nOldFocusColumn]->GrabFocus(); } m_pImpl->nFieldScrollPos = _nPos; if (_bAdjustScrollbar) m_pFieldScroller->SetThumbPos(m_pImpl->nFieldScrollPos); } void AddressBookSourceDialog::implSelectField(ListBox* _pBox, const OUString& _rText) { if (!_rText.isEmpty()) // a valid field name _pBox->SelectEntry(_rText); else // no selection for this item _pBox->SelectEntryPos(0); } IMPL_LINK_NOARG(AddressBookSourceDialog, OnDelayedInitialize) { // load the initial data from the configuration loadConfiguration(); resetTables(); // will reset the tables/fields implicitly if ( !m_pImpl->bWorkingPersistent ) if ( m_pImpl->pFields[0] ) m_pImpl->pFields[0]->GrabFocus(); return 0L; } IMPL_LINK(AddressBookSourceDialog, OnComboSelect, ComboBox*, _pBox) { if (_pBox == m_pDatasource) resetTables(); else resetFields(); return 0; } IMPL_LINK(AddressBookSourceDialog, OnComboGetFocus, ComboBox*, _pBox) { _pBox->SaveValue(); return 0L; } IMPL_LINK(AddressBookSourceDialog, OnComboLoseFocus, ComboBox*, _pBox) { if ( _pBox->IsValueChangedFromSaved() ) { if (_pBox == m_pDatasource) resetTables(); else resetFields(); } return 0L; } IMPL_LINK_NOARG(AddressBookSourceDialog, OnOkClicked) { OUString sSelectedDS = lcl_getSelectedDataSource(*m_pDatasource); if ( m_pImpl->bWorkingPersistent ) { m_pImpl->pConfigData->setDatasourceName(sSelectedDS); m_pImpl->pConfigData->setCommand(m_pTable->GetText()); } // AddressBookSourceDialog::loadConfiguration: inconsistence between field names and field assignments! assert(m_pImpl->aLogicalFieldNames.size() == m_pImpl->aFieldAssignments.size()); // set the field assignments StringArray::const_iterator aLogical = m_pImpl->aLogicalFieldNames.begin(); StringArray::const_iterator aAssignment = m_pImpl->aFieldAssignments.begin(); for ( ; aLogical != m_pImpl->aLogicalFieldNames.end(); ++aLogical, ++aAssignment ) m_pImpl->pConfigData->setFieldAssignment(*aLogical, *aAssignment); EndDialog(RET_OK); return 0L; } IMPL_LINK_NOARG(AddressBookSourceDialog, OnAdministrateDatasources) { // create the dialog object Reference< XExecutableDialog > xAdminDialog; try { xAdminDialog = AddressBookSourcePilot::createWithParent( m_xORB, VCLUnoHelper::GetInterface(this) ); } catch(const Exception&) { } if (!xAdminDialog.is()) { ShowServiceNotAvailableError(this, OUString("com.sun.star.ui.dialogs.AddressBookSourcePilot"), true); return 1L; } // excute the dialog try { if ( xAdminDialog->execute() == RET_OK ) { Reference xProp(xAdminDialog,UNO_QUERY); if ( xProp.is() ) { OUString sName; xProp->getPropertyValue("DataSourceName") >>= sName; INetURLObject aURL( sName ); if( aURL.GetProtocol() != INET_PROT_NOT_VALID ) { OFileNotation aFileNotation( aURL.GetMainURL( INetURLObject::NO_DECODE ) ); sName = aFileNotation.get(OFileNotation::N_SYSTEM); } m_pDatasource->InsertEntry(sName); delete m_pImpl->pConfigData; m_pImpl->pConfigData = new AssignmentPersistentData(); loadConfiguration(); resetTables(); // will reset the fields implicitly } } } catch(const Exception&) { OSL_FAIL("AddressBookSourceDialog::OnAdministrateDatasources: an error occurred while executing the administration dialog!"); } // re-fill the data source list // try to preserve the current selection // initializeDatasources(); return 0L; } bool AddressBookSourceDialog::PreNotify( NotifyEvent& _rNEvt ) { switch (_rNEvt.GetType()) { case EVENT_KEYINPUT: { const KeyEvent* pKeyEvent = _rNEvt.GetKeyEvent(); sal_uInt16 nCode = pKeyEvent->GetKeyCode().GetCode(); bool bShift = pKeyEvent->GetKeyCode().IsShift(); bool bCtrl = pKeyEvent->GetKeyCode().IsMod1(); bool bAlt = pKeyEvent->GetKeyCode().IsMod2(); if (KEY_TAB == nCode) { // somebody pressed the tab key if (!bAlt && !bCtrl && !bShift) { // it's really the only the key (no modifiers) if (m_pImpl->pFields[m_pImpl->nLastVisibleListIndex]->HasChildPathFocus()) // the last of our visible list boxes has the focus if (m_pImpl->nFieldScrollPos < m_pFieldScroller->GetRangeMax()) { // we can still scroll down sal_Int32 nNextFocusList = m_pImpl->nLastVisibleListIndex + 1 - 2; // -> scroll down implScrollFields(m_pImpl->nFieldScrollPos + 1, false, true); // give the left control in the "next" line the focus m_pImpl->pFields[nNextFocusList]->GrabFocus(); // return saying "have handled this" return true; } } else if (!bAlt && !bCtrl && bShift) { // it's shift-tab if (m_pImpl->pFields[0]->HasChildPathFocus()) // our first list box has the focus if (m_pImpl->nFieldScrollPos > 0) { // we can still scroll up // -> scroll up implScrollFields(m_pImpl->nFieldScrollPos - 1, false, true); // give the right control in the "prebious" line the focus m_pImpl->pFields[0 - 1 + 2]->GrabFocus(); // return saying "have handled this" return true; } } } } break; } return ModalDialog::PreNotify(_rNEvt); } } // namespace svt /* vim:set shiftwidth=4 softtabstop=4 expandtab: */