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