1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 
23 
24 // MARKER(update_precomp.py): autogen include statement, do not remove
25 #include "precompiled_dbui.hxx"
26 
27 #ifndef DBAUI_TABLEFIELDDESC_HXX
28 #include "TableFieldDescription.hxx"
29 #endif
30 #ifndef _TOOLS_DEBUG_HXX
31 #include <tools/debug.hxx>
32 #endif
33 #ifndef _COM_SUN_STAR_SDBC_DATATYPE_HPP_
34 #include <com/sun/star/sdbc/DataType.hpp>
35 #endif
36 #include <comphelper/namedvaluecollection.hxx>
37 
38 #include <functional>
39 
40 using namespace ::com::sun::star::sdbc;
41 using namespace ::com::sun::star::uno;
42 using namespace ::com::sun::star::beans;
43 using namespace comphelper;
44 using namespace dbaui;
45 
DBG_NAME(OTableFieldDesc)46 DBG_NAME(OTableFieldDesc)
47 //==============================================================================
48 OTableFieldDesc::OTableFieldDesc()
49     :m_pTabWindow(0)
50     ,m_eDataType(1000)
51     ,m_eFunctionType( FKT_NONE )
52     ,m_eFieldType(TAB_NORMAL_FIELD)
53     ,m_eOrderDir( ORDER_NONE )
54     ,m_nIndex(0)
55     ,m_nColWidth(0)
56     ,m_nColumnId((sal_uInt16)-1)
57     ,m_bGroupBy(sal_False)
58     ,m_bVisible(sal_False)
59 {
60 	DBG_CTOR(OTableFieldDesc,NULL);
61 }
62 //------------------------------------------------------------------------------
OTableFieldDesc(const OTableFieldDesc & rRS)63 OTableFieldDesc::OTableFieldDesc(const OTableFieldDesc& rRS)
64     : ::vos::OReference()
65 
66 {
67 	DBG_CTOR(OTableFieldDesc,NULL);
68     *this = rRS;
69 }
70 
71 //------------------------------------------------------------------------------
OTableFieldDesc(const::rtl::OUString & rT,const::rtl::OUString & rF)72 OTableFieldDesc::OTableFieldDesc(const ::rtl::OUString& rT, const ::rtl::OUString& rF )
73     :m_pTabWindow(0)
74     ,m_eFunctionType( FKT_NONE )
75     ,m_eOrderDir( ORDER_NONE )
76     ,m_nColumnId((sal_uInt16)-1)
77     ,m_bGroupBy(sal_False)
78     ,m_bVisible(sal_False)
79 {
80 	DBG_CTOR(OTableFieldDesc,NULL);
81 	SetField( rF );	SetTable( rT );
82 }
83 
84 //------------------------------------------------------------------------------
~OTableFieldDesc()85 OTableFieldDesc::~OTableFieldDesc()
86 {
87 	DBG_DTOR(OTableFieldDesc,NULL);
88 }
89 //------------------------------------------------------------------------------
operator =(const OTableFieldDesc & rRS)90 OTableFieldDesc& OTableFieldDesc::operator=( const OTableFieldDesc& rRS )
91 {
92     if (&rRS == this)
93 		return *this;
94 
95     m_aCriteria = rRS.GetCriteria();
96     m_aTableName = rRS.GetTable();
97     m_aAliasName = rRS.GetAlias();		// table range
98     m_aFieldName = rRS.GetField();		// column
99     m_aFieldAlias = rRS.GetFieldAlias();	// column alias
100     m_aFunctionName = rRS.GetFunction();	// Funktionsname
101     m_pTabWindow = rRS.GetTabWindow();
102     m_eDataType = rRS.GetDataType();
103     m_eFunctionType = rRS.GetFunctionType();
104     m_eFieldType = rRS.GetFieldType();
105     m_eOrderDir = rRS.GetOrderDir();
106     m_nIndex = rRS.GetFieldIndex();
107     m_nColWidth = rRS.GetColWidth();
108     m_nColumnId = rRS.m_nColumnId;
109     m_bGroupBy = rRS.IsGroupBy();
110     m_bVisible = rRS.IsVisible();
111 
112 	return *this;
113 }
114 //------------------------------------------------------------------------------
operator ==(const OTableFieldDesc & rDesc)115 sal_Bool OTableFieldDesc::operator==( const OTableFieldDesc& rDesc )
116 {
117 	DBG_CHKTHIS(OTableFieldDesc,NULL);
118 
119 	return (	m_eOrderDir != rDesc.GetOrderDir()		||
120 				m_eDataType != rDesc.GetDataType()		||
121 				m_aAliasName != rDesc.GetAlias()	 	||
122 				m_aFunctionName != rDesc.GetFunction()	||
123 				m_aFieldName != rDesc.GetField()		||
124 				m_aTableName != rDesc.GetTable()	 	||
125 				m_bGroupBy != rDesc.IsGroupBy()			||
126 				m_aCriteria != rDesc.GetCriteria()	||
127 				m_bVisible != rDesc.IsVisible() );
128 
129 }
130 
131 //------------------------------------------------------------------------------
SetCriteria(sal_uInt16 nIdx,const::rtl::OUString & rCrit)132 void OTableFieldDesc::SetCriteria( sal_uInt16 nIdx, const ::rtl::OUString& rCrit)
133 {
134 	DBG_CHKTHIS(OTableFieldDesc,NULL);
135 	if (nIdx < m_aCriteria.size())
136 		m_aCriteria[nIdx] = rCrit;
137 	else
138 	{
139 		for(sal_Int32 i=m_aCriteria.size();i<nIdx;++i)
140 			m_aCriteria.push_back( ::rtl::OUString());
141 		m_aCriteria.push_back(rCrit);
142 	}
143 }
144 
145 //------------------------------------------------------------------------------
GetCriteria(sal_uInt16 nIdx) const146 ::rtl::OUString OTableFieldDesc::GetCriteria( sal_uInt16 nIdx ) const
147 {
148 	DBG_CHKTHIS(OTableFieldDesc,NULL);
149 	::rtl::OUString aRetStr;
150 	if( nIdx < m_aCriteria.size())
151 		aRetStr = m_aCriteria[nIdx];
152 
153 	return aRetStr;
154 }
155 
156 // -----------------------------------------------------------------------------
157 namespace
158 {
159     struct SelectPropertyValueAsString : public ::std::unary_function< PropertyValue, ::rtl::OUString >
160     {
operator ()__anon612a863b0111::SelectPropertyValueAsString161         ::rtl::OUString operator()( const PropertyValue& i_rPropValue ) const
162         {
163             ::rtl::OUString sValue;
164             OSL_VERIFY( i_rPropValue.Value >>= sValue );
165             return sValue;
166         }
167     };
168 }
169 
170 // -----------------------------------------------------------------------------
Load(const::com::sun::star::beans::PropertyValue & i_rSettings,const bool i_bIncludingCriteria)171 void OTableFieldDesc::Load( const ::com::sun::star::beans::PropertyValue& i_rSettings, const bool i_bIncludingCriteria )
172 {
173 	DBG_CHKTHIS(OTableFieldDesc,NULL);
174 
175     ::comphelper::NamedValueCollection aFieldDesc( i_rSettings.Value );
176     m_aAliasName = aFieldDesc.getOrDefault( "AliasName", m_aAliasName );
177     m_aTableName = aFieldDesc.getOrDefault( "TableName", m_aTableName );
178     m_aFieldName = aFieldDesc.getOrDefault( "FieldName", m_aFieldName );
179     m_aFieldAlias = aFieldDesc.getOrDefault( "FieldAlias", m_aFieldAlias );
180     m_aFunctionName = aFieldDesc.getOrDefault( "FunctionName", m_aFunctionName );
181     m_eDataType = aFieldDesc.getOrDefault( "DataType", m_eDataType );
182     m_eFunctionType = aFieldDesc.getOrDefault( "FunctionType", m_eFunctionType );
183     m_nColWidth = aFieldDesc.getOrDefault( "ColWidth", m_nColWidth );
184     m_bGroupBy = aFieldDesc.getOrDefault( "GroupBy", m_bGroupBy );
185     m_bVisible = aFieldDesc.getOrDefault( "Visible", m_bVisible );
186 
187     m_eFieldType = static_cast< ETableFieldType >( aFieldDesc.getOrDefault( "FieldType", static_cast< sal_Int32 >( m_eFieldType ) ) );
188     m_eOrderDir = static_cast< EOrderDir >( aFieldDesc.getOrDefault( "OrderDir", static_cast< sal_Int32 >( m_eOrderDir ) ) );
189 
190     if ( i_bIncludingCriteria )
191     {
192         const Sequence< PropertyValue > aCriteria( aFieldDesc.getOrDefault( "Criteria", Sequence< PropertyValue >() ) );
193         m_aCriteria.resize( aCriteria.getLength() );
194         ::std::transform(
195             aCriteria.getConstArray(),
196             aCriteria.getConstArray() + aCriteria.getLength(),
197             m_aCriteria.begin(),
198             SelectPropertyValueAsString()
199         );
200     }
201 }
202 //------------------------------------------------------------------------------
Save(::comphelper::NamedValueCollection & o_rSettings,const bool i_bIncludingCriteria)203 void OTableFieldDesc::Save( ::comphelper::NamedValueCollection& o_rSettings, const bool i_bIncludingCriteria )
204 {
205 	DBG_CHKTHIS(OTableFieldDesc,NULL);
206 
207 	o_rSettings.put( "AliasName", m_aAliasName );
208 	o_rSettings.put( "TableName", m_aTableName );
209 	o_rSettings.put( "FieldName", m_aFieldName );
210 	o_rSettings.put( "FieldAlias", m_aFieldAlias );
211 	o_rSettings.put( "FunctionName", m_aFunctionName );
212 	o_rSettings.put( "DataType", m_eDataType );
213 	o_rSettings.put( "FunctionType", (sal_Int32)m_eFunctionType );
214 	o_rSettings.put( "FieldType", (sal_Int32)m_eFieldType );
215 	o_rSettings.put( "OrderDir", (sal_Int32)m_eOrderDir );
216 	o_rSettings.put( "ColWidth", m_nColWidth );
217 	o_rSettings.put( "GroupBy", m_bGroupBy );
218 	o_rSettings.put( "Visible", m_bVisible );
219 
220     if ( i_bIncludingCriteria )
221     {
222         if ( !m_aCriteria.empty() )
223         {
224             sal_Int32 c = 0;
225             Sequence< PropertyValue > aCriteria( m_aCriteria.size() );
226             for (   ::std::vector< ::rtl::OUString >::const_iterator crit = m_aCriteria.begin();
227                     crit != m_aCriteria.end();
228                     ++crit, ++c
229                 )
230             {
231                 aCriteria[c].Name = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "Criterion_" ) ) + ::rtl::OUString::valueOf( c );
232                 aCriteria[c].Value <<= *crit;
233             }
234 
235             o_rSettings.put( "Criteria", aCriteria );
236         }
237     }
238 }
239 // -----------------------------------------------------------------------------
240 
241 
242 
243