1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski  *
3*b1cdbd2cSJim Jagielski  * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski  * or more contributor license agreements.  See the NOTICE file
5*b1cdbd2cSJim Jagielski  * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski  * regarding copyright ownership.  The ASF licenses this file
7*b1cdbd2cSJim Jagielski  * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski  * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski  * with the License.  You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski  *
11*b1cdbd2cSJim Jagielski  *   http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski  *
13*b1cdbd2cSJim Jagielski  * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski  * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski  * KIND, either express or implied.  See the License for the
17*b1cdbd2cSJim Jagielski  * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski  * under the License.
19*b1cdbd2cSJim Jagielski  *
20*b1cdbd2cSJim Jagielski  *************************************************************/
21*b1cdbd2cSJim Jagielski 
22*b1cdbd2cSJim Jagielski 
23*b1cdbd2cSJim Jagielski 
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_connectivity.hxx"
26*b1cdbd2cSJim Jagielski 
27*b1cdbd2cSJim Jagielski #include "kfields.hxx"
28*b1cdbd2cSJim Jagielski #include "resource/common_res.hrc"
29*b1cdbd2cSJim Jagielski #include "resource/sharedresources.hxx"
30*b1cdbd2cSJim Jagielski 
31*b1cdbd2cSJim Jagielski using namespace ::connectivity::kab;
32*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbc;
33*b1cdbd2cSJim Jagielski 
34*b1cdbd2cSJim Jagielski namespace connectivity
35*b1cdbd2cSJim Jagielski {
36*b1cdbd2cSJim Jagielski 	namespace kab
37*b1cdbd2cSJim Jagielski 	{
38*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
39*b1cdbd2cSJim Jagielski // return the value of a KDE address book field, given an addressee and a field number
valueOfKabField(const::KABC::Addressee & aAddressee,sal_Int32 nFieldNumber)40*b1cdbd2cSJim Jagielski QString valueOfKabField(const ::KABC::Addressee &aAddressee, sal_Int32 nFieldNumber)
41*b1cdbd2cSJim Jagielski {
42*b1cdbd2cSJim Jagielski 	switch (nFieldNumber)
43*b1cdbd2cSJim Jagielski 	{
44*b1cdbd2cSJim Jagielski 		case KAB_FIELD_REVISION:
45*b1cdbd2cSJim Jagielski 			return aAddressee.revision().toString("yyyy-MM-dd hh:mm:ss");
46*b1cdbd2cSJim Jagielski 		default:
47*b1cdbd2cSJim Jagielski 			::KABC::Field::List aFields = ::KABC::Field::allFields();
48*b1cdbd2cSJim Jagielski 			return aFields[nFieldNumber - KAB_DATA_FIELDS]->value(aAddressee);
49*b1cdbd2cSJim Jagielski 	}
50*b1cdbd2cSJim Jagielski }
51*b1cdbd2cSJim Jagielski // ------------------------------------------------------------------------------
52*b1cdbd2cSJim Jagielski // search the KDE address book field number of a given column name
findKabField(const::rtl::OUString & columnName)53*b1cdbd2cSJim Jagielski sal_uInt32 findKabField(const ::rtl::OUString& columnName) throw(SQLException)
54*b1cdbd2cSJim Jagielski {
55*b1cdbd2cSJim Jagielski 	QString aQtName;
56*b1cdbd2cSJim Jagielski 	::rtl::OUString aName;
57*b1cdbd2cSJim Jagielski 
58*b1cdbd2cSJim Jagielski 	aQtName = KABC::Addressee::revisionLabel();
59*b1cdbd2cSJim Jagielski 	aName = ::rtl::OUString((const sal_Unicode *) aQtName.ucs2());
60*b1cdbd2cSJim Jagielski 	if (columnName == aName)
61*b1cdbd2cSJim Jagielski 		return KAB_FIELD_REVISION;
62*b1cdbd2cSJim Jagielski 
63*b1cdbd2cSJim Jagielski 	::KABC::Field::List aFields = ::KABC::Field::allFields();
64*b1cdbd2cSJim Jagielski 	::KABC::Field::List::iterator aField;
65*b1cdbd2cSJim Jagielski 	sal_uInt32 nResult;
66*b1cdbd2cSJim Jagielski 
67*b1cdbd2cSJim Jagielski 	for (	aField = aFields.begin(), nResult = KAB_DATA_FIELDS;
68*b1cdbd2cSJim Jagielski 			aField != aFields.end();
69*b1cdbd2cSJim Jagielski 			++aField, ++nResult)
70*b1cdbd2cSJim Jagielski 	{
71*b1cdbd2cSJim Jagielski 		aQtName = (*aField)->label();
72*b1cdbd2cSJim Jagielski 		aName = ::rtl::OUString((const sal_Unicode *) aQtName.ucs2());
73*b1cdbd2cSJim Jagielski 
74*b1cdbd2cSJim Jagielski 		if (columnName == aName)
75*b1cdbd2cSJim Jagielski 			return nResult;
76*b1cdbd2cSJim Jagielski 	}
77*b1cdbd2cSJim Jagielski 
78*b1cdbd2cSJim Jagielski     ::connectivity::SharedResources aResources;
79*b1cdbd2cSJim Jagielski     const ::rtl::OUString sError( aResources.getResourceStringWithSubstitution(
80*b1cdbd2cSJim Jagielski             STR_INVALID_COLUMNNAME,
81*b1cdbd2cSJim Jagielski             "$columnname$",columnName
82*b1cdbd2cSJim Jagielski          ) );
83*b1cdbd2cSJim Jagielski 	::dbtools::throwGenericSQLException(sError,NULL);
84*b1cdbd2cSJim Jagielski     // Unreachable:
85*b1cdbd2cSJim Jagielski     OSL_ASSERT(false);
86*b1cdbd2cSJim Jagielski     return 0;
87*b1cdbd2cSJim Jagielski }
88*b1cdbd2cSJim Jagielski // ------------------------------------------------------------------------------
89*b1cdbd2cSJim Jagielski 	}
90*b1cdbd2cSJim Jagielski }
91