xref: /aoo41x/main/extensions/source/abpilot/fieldmappingimpl.cxx (revision 2a97ec55)

/**************************************************************
 *
 * 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_extensions.hxx"
#include "fieldmappingimpl.hxx"
#include <com/sun/star/lang/XMultiServiceFactory.hpp>
#include <com/sun/star/beans/PropertyValue.hpp>
#include <com/sun/star/beans/XPropertySet.hpp>
#include <com/sun/star/ui/dialogs/XExecutableDialog.hpp>
#include <com/sun/star/awt/XWindow.hpp>
#include <com/sun/star/sdb/CommandType.hpp>
#include <tools/debug.hxx>
#ifndef _TOOLKIT_HELPER_VCLUNOHELPER_HXX_
#include <toolkit/unohlp.hxx>
#endif
#include <vcl/stdtext.hxx>
#include <com/sun/star/util/AliasProgrammaticPair.hpp>
#ifndef EXTENSIONS_ABPRESID_HRC
#include "abpresid.hrc"
#endif
#include "componentmodule.hxx"
#include <unotools/confignode.hxx>

//.........................................................................
namespace abp
{
//.........................................................................

	using namespace ::utl;
	using namespace ::com::sun::star::uno;
	using namespace ::com::sun::star::awt;
	using namespace ::com::sun::star::util;
	using namespace ::com::sun::star::lang;
	using namespace ::com::sun::star::beans;
	using namespace ::com::sun::star::sdb;
	using namespace ::com::sun::star::ui::dialogs;

	//---------------------------------------------------------------------
	static const ::rtl::OUString& lcl_getDriverSettingsNodeName()
	{
		static const ::rtl::OUString s_sDriverSettingsNodeName =
			::rtl::OUString::createFromAscii( "/org.openoffice.Office.DataAccess/DriverSettings/com.sun.star.comp.sdbc.MozabDriver" );
		return s_sDriverSettingsNodeName;
	}

	//---------------------------------------------------------------------
	static const ::rtl::OUString& lcl_getAddressBookNodeName()
	{
		static const ::rtl::OUString s_sAddressBookNodeName =
			::rtl::OUString::createFromAscii( "/org.openoffice.Office.DataAccess/AddressBook" );
		return s_sAddressBookNodeName;
	}

	//.....................................................................
	namespace fieldmapping
	{
	//.....................................................................

		//-----------------------------------------------------------------
		sal_Bool invokeDialog( const Reference< XMultiServiceFactory >& _rxORB, class Window* _pParent,
			const Reference< XPropertySet >& _rxDataSource, AddressSettings& _rSettings ) SAL_THROW ( ( ) )
		{
            _rSettings.aFieldMapping.clear();

			DBG_ASSERT( _rxORB.is(), "fieldmapping::invokeDialog: invalid service factory!" );
			DBG_ASSERT( _rxDataSource.is(), "fieldmapping::invokeDialog: invalid data source!" );
            if ( !_rxORB.is() || !_rxDataSource.is() )
                return sal_False;

			try
			{
				// ........................................................
				// the parameters for creating the dialog
				Sequence< Any > aArguments(5);
				Any* pArguments = aArguments.getArray();

				// the parent window
				Reference< XWindow > xDialogParent = VCLUnoHelper::GetInterface( _pParent );
				*pArguments++ <<= PropertyValue(::rtl::OUString::createFromAscii( "ParentWindow" ), -1, makeAny( xDialogParent ), PropertyState_DIRECT_VALUE);

				// the data source to use
				*pArguments++ <<= PropertyValue(::rtl::OUString::createFromAscii( "DataSource" ), -1, makeAny( _rxDataSource ), PropertyState_DIRECT_VALUE);
                *pArguments++ <<= PropertyValue(::rtl::OUString::createFromAscii( "DataSourceName" ), -1, makeAny( (sal_Bool)_rSettings.bRegisterDataSource ? _rSettings.sRegisteredDataSourceName : _rSettings.sDataSourceName ), PropertyState_DIRECT_VALUE);

				// the table to use
				*pArguments++ <<= PropertyValue(::rtl::OUString::createFromAscii( "Command" ), -1, makeAny( _rSettings.sSelectedTable ), PropertyState_DIRECT_VALUE);

				// the title
				::rtl::OUString sTitle = String( ModuleRes( RID_STR_FIELDDIALOGTITLE ) );
				*pArguments++ <<= PropertyValue(::rtl::OUString::createFromAscii( "Title" ), -1, makeAny( sTitle ), PropertyState_DIRECT_VALUE);

				// ........................................................
				// create an instance of the dialog service
				static ::rtl::OUString s_sAdressBookFieldAssignmentServiceName = ::rtl::OUString::createFromAscii( "com.sun.star.ui.AddressBookSourceDialog" );
				Reference< XExecutableDialog > xDialog(
					_rxORB->createInstanceWithArguments( s_sAdressBookFieldAssignmentServiceName, aArguments ),
					UNO_QUERY
				);
				if ( !xDialog.is( ) )
				{
					ShowServiceNotAvailableError( _pParent, s_sAdressBookFieldAssignmentServiceName, sal_True );
					return sal_False;
				}

				// execute the dialog
				if ( xDialog->execute() )
				{
					// retrieve the field mapping as set by he user
					Reference< XPropertySet > xDialogProps( xDialog, UNO_QUERY );

					Sequence< AliasProgrammaticPair > aMapping;
#ifdef DBG_UTIL
					sal_Bool bSuccess =
#endif
					xDialogProps->getPropertyValue( ::rtl::OUString::createFromAscii( "FieldMapping" ) ) >>= aMapping;
					DBG_ASSERT( bSuccess, "fieldmapping::invokeDialog: invalid property type for FieldMapping!" );

					// and copy it into the map
					const AliasProgrammaticPair* pMapping = aMapping.getConstArray();
					const AliasProgrammaticPair* pMappingEnd = pMapping + aMapping.getLength();
					for (;pMapping != pMappingEnd; ++pMapping)
						_rSettings.aFieldMapping[ pMapping->ProgrammaticName ] = pMapping->Alias;

					return sal_True;
				}

			}
			catch(const Exception&)
			{
				DBG_ERROR("fieldmapping::invokeDialog: caught an exception while executing the dialog!");
			}
			return sal_False;
		}

		//-----------------------------------------------------------------
		void defaultMapping(  const Reference< XMultiServiceFactory >& _rxORB, MapString2String& _rFieldAssignment ) SAL_THROW ( ( ) )
		{
			_rFieldAssignment.clear();

			try
			{
				// what we have:
				// a) For the address data source, we need a mapping from programmatic names (1) to real column names
				// b) The SDBC driver has a fixed set of columns, which, when returned, are named according to
				//    some configuration entries. E.g., the driver displays the field which it knows contains
				//    the first name as "First Name" - the latter string is stored in the config.
				//    For this, the driver uses programmatic names, too, but they differ from the programmatic names the
				//    template documents have.
				// So what we need first is a mapping from programmatic names (1) to programmatic names (2)
				const sal_Char* pMappingProgrammatics[] =
				{
					"FirstName",			"FirstName",
					"LastName",				"LastName",
					"Street",				"HomeAddress",
					"Zip",					"HomeZipCode",
					"City",					"HomeCity",
					"State",				"HomeState",
					"Country",				"HomeCountry",
					"PhonePriv",			"HomePhone",
					"PhoneComp",			"WorkPhone",
					"PhoneCell",			"CellularNumber",
					"Pager",				"PagerNumber",
					"Fax",					"FaxNumber",
					"EMail",				"PrimaryEmail",
					"URL",					"WebPage1",
					"Note",					"Notes",
					"Altfield1",			"Custom1",
					"Altfield2",			"Custom2",
					"Altfield3",			"Custom3",
					"Altfield4",			"Custom4",
					"Title",				"JobTitle",
					"Company",				"Company",
					"Department",			"Department"
				};
					// (this list is not complete: both lists of programmatic names are larger in real,
					// but this list above is the intersection)


				// access the configuration information which the driver uses for determining it's column names
				::rtl::OUString sDriverAliasesNodeName = lcl_getDriverSettingsNodeName();
				sDriverAliasesNodeName += ::rtl::OUString::createFromAscii( "/ColumnAliases" );

				// create a config node for this
				OConfigurationTreeRoot aDriverFieldAliasing = OConfigurationTreeRoot::createWithServiceFactory(
					_rxORB, sDriverAliasesNodeName, -1, OConfigurationTreeRoot::CM_READONLY);

				// loop through all programmatic pairs
				DBG_ASSERT( 0 == ( sizeof( pMappingProgrammatics ) / sizeof( pMappingProgrammatics[ 0 ] ) ) % 2,
					"fieldmapping::defaultMapping: invalid programmatic map!" );
				// number of pairs
				sal_Int32 nIntersectedProgrammatics = sizeof( pMappingProgrammatics ) / sizeof( pMappingProgrammatics[ 0 ] ) / 2;

				const sal_Char** pProgrammatic = pMappingProgrammatics;
				::rtl::OUString sAddressProgrammatic;
				::rtl::OUString sDriverProgrammatic;
				::rtl::OUString sDriverUI;
				for	(	sal_Int32 i=0;
						i < nIntersectedProgrammatics;
						++i
					)
				{
					sAddressProgrammatic = ::rtl::OUString::createFromAscii( *pProgrammatic++ );
					sDriverProgrammatic = ::rtl::OUString::createFromAscii( *pProgrammatic++ );

					if ( aDriverFieldAliasing.hasByName( sDriverProgrammatic ) )
					{
						aDriverFieldAliasing.getNodeValue( sDriverProgrammatic ) >>= sDriverUI;
						if ( 0 == sDriverUI.getLength() )
						{
							DBG_ERROR( "fieldmapping::defaultMapping: invalid driver UI column name!");
						}
						else
							_rFieldAssignment[ sAddressProgrammatic ] = sDriverUI;
					}
					else
					{
						DBG_ERROR( "fieldmapping::defaultMapping: invalid driver programmatic name!" );
					}
				}
			}
			catch( const Exception& )
			{
				DBG_ERROR("fieldmapping::defaultMapping: code is assumed to throw no exceptions!");
					// the config nodes we're using herein should not do this ....
			}
		}

		//-----------------------------------------------------------------
		void writeTemplateAddressFieldMapping( const Reference< XMultiServiceFactory >& _rxORB, const MapString2String& _rFieldAssignment ) SAL_THROW ( ( ) )
		{
			// want to have a non-const map for easier handling
			MapString2String aFieldAssignment( _rFieldAssignment );

			// access the configuration information which the driver uses for determining it's column names
			const ::rtl::OUString& sAddressBookNodeName = lcl_getAddressBookNodeName();

			// create a config node for this
			OConfigurationTreeRoot aAddressBookSettings = OConfigurationTreeRoot::createWithServiceFactory(
				_rxORB, sAddressBookNodeName, -1, OConfigurationTreeRoot::CM_UPDATABLE);

			OConfigurationNode aFields = aAddressBookSettings.openNode( ::rtl::OUString::createFromAscii( "Fields" ) );

			// loop through all existent fields
			Sequence< ::rtl::OUString > aExistentFields = aFields.getNodeNames();
			const ::rtl::OUString* pExistentFields = aExistentFields.getConstArray();
			const ::rtl::OUString* pExistentFieldsEnd = pExistentFields + aExistentFields.getLength();

			const ::rtl::OUString sProgrammaticNodeName = ::rtl::OUString::createFromAscii( "ProgrammaticFieldName" );
			const ::rtl::OUString sAssignedNodeName = ::rtl::OUString::createFromAscii( "AssignedFieldName" );

			for ( ; pExistentFields != pExistentFieldsEnd; ++pExistentFields )
			{
#ifdef DBG_UTIL
				::rtl::OUString sRedundantProgrammaticName;
				aFields.openNode( *pExistentFields ).getNodeValue( sProgrammaticNodeName ) >>= sRedundantProgrammaticName;
#endif
				DBG_ASSERT( sRedundantProgrammaticName == *pExistentFields,
					"fieldmapping::writeTemplateAddressFieldMapping: inconsistent config data!" );
					// there should be a redundancy in the config data .... if this asserts, there isn't anymore!

				// do we have a new alias for the programmatic?
				MapString2StringIterator aPos = aFieldAssignment.find( *pExistentFields );
				if ( aFieldAssignment.end() != aPos )
				{	// yes
					// -> set a new value
					OConfigurationNode aExistentField = aFields.openNode( *pExistentFields );
					aExistentField.setNodeValue( sAssignedNodeName, makeAny( aPos->second ) );
					// and remove the mapping entry
					aFieldAssignment.erase( *pExistentFields );
				}
				else
				{	// no
					// -> remove it
					aFields.removeNode( *pExistentFields );
				}
			}

			// now everything remaining in aFieldAssignment marks a mapping entry which was not present
			// in the config before
			for (	ConstMapString2StringIterator aNewMapping = aFieldAssignment.begin();
					aNewMapping != aFieldAssignment.end();
					++aNewMapping
				)
			{
				DBG_ASSERT( !aFields.hasByName( aNewMapping->first ),
					"fieldmapping::writeTemplateAddressFieldMapping: inconsistence!" );
					// in case the config node for the fields already has the node named <aNewMapping->first>,
					// the entry should have been removed from aNewMapping (in the above loop)
				OConfigurationNode aNewField =  aFields.createNode( aNewMapping->first );
				aNewField.setNodeValue( sProgrammaticNodeName, makeAny( aNewMapping->first ) );
				aNewField.setNodeValue( sAssignedNodeName, makeAny( aNewMapping->second ) );
			}

			// commit the changes done
			aAddressBookSettings.commit();
		}

	//.....................................................................
	}	// namespace fieldmapping
	//.....................................................................

	//.....................................................................
	namespace addressconfig
	{
	//.....................................................................

		//-----------------------------------------------------------------
		void writeTemplateAddressSource( const Reference< XMultiServiceFactory >& _rxORB,
			const ::rtl::OUString& _rDataSourceName, const ::rtl::OUString& _rTableName ) SAL_THROW ( ( ) )
		{
			// access the configuration information which the driver uses for determining it's column names
			const ::rtl::OUString& sAddressBookNodeName = lcl_getAddressBookNodeName();

			// create a config node for this
			OConfigurationTreeRoot aAddressBookSettings = OConfigurationTreeRoot::createWithServiceFactory(
				_rxORB, sAddressBookNodeName, -1, OConfigurationTreeRoot::CM_UPDATABLE);

			aAddressBookSettings.setNodeValue( ::rtl::OUString::createFromAscii( "DataSourceName" ), makeAny( _rDataSourceName ) );
			aAddressBookSettings.setNodeValue( ::rtl::OUString::createFromAscii( "Command" ), makeAny( _rTableName ) );
			aAddressBookSettings.setNodeValue( ::rtl::OUString::createFromAscii( "CommandType" ), makeAny( (sal_Int32)CommandType::TABLE ) );

			// commit the changes done
			aAddressBookSettings.commit();
		}

		//-----------------------------------------------------------------
		void markPilotSuccess( const Reference< XMultiServiceFactory >& _rxORB ) SAL_THROW ( ( ) )
		{
			// access the configuration information which the driver uses for determining it's column names
			const ::rtl::OUString& sAddressBookNodeName = lcl_getAddressBookNodeName();

			// create a config node for this
			OConfigurationTreeRoot aAddressBookSettings = OConfigurationTreeRoot::createWithServiceFactory(
				_rxORB, sAddressBookNodeName, -1, OConfigurationTreeRoot::CM_UPDATABLE);

			// set the flag
			aAddressBookSettings.setNodeValue( ::rtl::OUString::createFromAscii( "AutoPilotCompleted" ), makeAny( (sal_Bool)sal_True ) );

			// commit the changes done
			aAddressBookSettings.commit();
		}

	//.....................................................................
	}	// namespace addressconfig
	//.....................................................................

//.........................................................................
}	// namespace abp
//.........................................................................