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_dbaccess.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 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 //------------------------------------------------------------------------------ 63 OTableFieldDesc::OTableFieldDesc(const OTableFieldDesc& rRS) 64 : ::vos::OReference() 65 66 { 67 DBG_CTOR(OTableFieldDesc,NULL); 68 *this = rRS; 69 } 70 71 //------------------------------------------------------------------------------ 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 //------------------------------------------------------------------------------ 85 OTableFieldDesc::~OTableFieldDesc() 86 { 87 DBG_DTOR(OTableFieldDesc,NULL); 88 } 89 //------------------------------------------------------------------------------ 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 //------------------------------------------------------------------------------ 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 //------------------------------------------------------------------------------ 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 //------------------------------------------------------------------------------ 146 ::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 { 161 ::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 // ----------------------------------------------------------------------------- 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 //------------------------------------------------------------------------------ 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