dbaccess/source/ui/querydesign/TableFieldDescription.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #include "TableFieldDescription.hxx"
  21
  22 #include <osl/diagnose.h>
  23 #include <tools/debug.hxx>
  24 #include <com/sun/star/sdbc/DataType.hpp>
  25 #include <comphelper/namedvaluecollection.hxx>
  26 #include <vcl/window.hxx>
  27
  28 #include <functional>
  29
  30 using namespace ::com::sun::star::sdbc;
  31 using namespace ::com::sun::star::uno;
  32 using namespace ::com::sun::star::beans;
  33 using namespace comphelper;
  34 using namespace dbaui;
  35
  36 OTableFieldDesc::OTableFieldDesc()
  37     :m_pTabWindow(0)
  38     ,m_eDataType(1000)
  39     ,m_eFunctionType( FKT_NONE )
  40     ,m_eFieldType(TAB_NORMAL_FIELD)
  41     ,m_eOrderDir( ORDER_NONE )
  42     ,m_nIndex(0)
  43     ,m_nColWidth(0)
  44     ,m_nColumnId((sal_uInt16)-1)
  45     ,m_bGroupBy(false)
  46     ,m_bVisible(false)
  47 {
  48 }
  49
  50 OTableFieldDesc::OTableFieldDesc(const OTableFieldDesc& rRS)
  51     : ::salhelper::SimpleReferenceObject()
  52     , m_pTabWindow(NULL)
  53 {
  54     *this = rRS;
  55 }
  56
  57 OTableFieldDesc::OTableFieldDesc(const OUString& rT, const OUString& rF )
  58     :m_pTabWindow(0)
  59     ,m_eDataType(1000)
  60     ,m_eFunctionType( FKT_NONE )
  61     ,m_eFieldType(TAB_NORMAL_FIELD)
  62     ,m_eOrderDir( ORDER_NONE )
  63     ,m_nIndex(0)
  64     ,m_nColWidth(0)
  65     ,m_nColumnId((sal_uInt16)-1)
  66     ,m_bGroupBy(false)
  67     ,m_bVisible(false)
  68 {
  69     SetField( rF ); SetTable( rT );
  70 }
  71
  72 OTableFieldDesc::~OTableFieldDesc()
  73 {
  74 }
  75
  76 OTableFieldDesc& OTableFieldDesc::operator=( const OTableFieldDesc& rRS )
  77 {
  78     if (&rRS == this)
  79         return *this;
  80
  81     m_aCriteria = rRS.GetCriteria();
  82     m_aTableName = rRS.GetTable();
  83     m_aAliasName = rRS.GetAlias();      // table range
  84     m_aFieldName = rRS.GetField();      // column
  85     m_aFieldAlias = rRS.GetFieldAlias();    // column alias
  86     m_aFunctionName = rRS.GetFunction();    // Funktionsname
  87     m_pTabWindow = rRS.GetTabWindow();
  88     m_eDataType = rRS.GetDataType();
  89     m_eFunctionType = rRS.GetFunctionType();
  90     m_eFieldType = rRS.GetFieldType();
  91     m_eOrderDir = rRS.GetOrderDir();
  92     m_nIndex = rRS.GetFieldIndex();
  93     m_nColWidth = rRS.GetColWidth();
  94     m_nColumnId = rRS.m_nColumnId;
  95     m_bGroupBy = rRS.IsGroupBy();
  96     m_bVisible = rRS.IsVisible();
  97
  98     return *this;
  99 }
 100
 101 bool OTableFieldDesc::operator==( const OTableFieldDesc& rDesc )
 102 {
 103
 104     return (    m_eOrderDir != rDesc.GetOrderDir()      ||
 105                 m_eDataType != rDesc.GetDataType()      ||
 106                 m_aAliasName != rDesc.GetAlias()        ||
 107                 m_aFunctionName != rDesc.GetFunction()  ||
 108                 m_aFieldName != rDesc.GetField()        ||
 109                 m_aTableName != rDesc.GetTable()        ||
 110                 m_bGroupBy != rDesc.IsGroupBy()         ||
 111                 m_aCriteria != rDesc.GetCriteria()  ||
 112                 m_bVisible != rDesc.IsVisible() );
 113
 114 }
 115
 116 void OTableFieldDesc::SetCriteria( sal_uInt16 nIdx, const OUString& rCrit)
 117 {
 118     if (nIdx < m_aCriteria.size())
 119         m_aCriteria[nIdx] = rCrit;
 120     else
 121     {
 122         for(sal_Int32 i=m_aCriteria.size();i<nIdx;++i)
 123             m_aCriteria.push_back( OUString());
 124         m_aCriteria.push_back(rCrit);
 125     }
 126 }
 127
 128 OUString OTableFieldDesc::GetCriteria( sal_uInt16 nIdx ) const
 129 {
 130     OUString aRetStr;
 131     if( nIdx < m_aCriteria.size())
 132         aRetStr = m_aCriteria[nIdx];
 133
 134     return aRetStr;
 135 }
 136
 137 namespace
 138 {
 139     struct SelectPropertyValueAsString : public ::std::unary_function< PropertyValue, OUString >
 140     {
 141         OUString operator()( const PropertyValue& i_rPropValue ) const
 142         {
 143             OUString sValue;
 144             OSL_VERIFY( i_rPropValue.Value >>= sValue );
 145             return sValue;
 146         }
 147     };
 148 }
 149
 150 void OTableFieldDesc::Load( const ::com::sun::star::beans::PropertyValue& i_rSettings, const bool i_bIncludingCriteria )
 151 {
 152
 153     ::comphelper::NamedValueCollection aFieldDesc( i_rSettings.Value );
 154     m_aAliasName = aFieldDesc.getOrDefault( "AliasName", m_aAliasName );
 155     m_aTableName = aFieldDesc.getOrDefault( "TableName", m_aTableName );
 156     m_aFieldName = aFieldDesc.getOrDefault( "FieldName", m_aFieldName );
 157     m_aFieldAlias = aFieldDesc.getOrDefault( "FieldAlias", m_aFieldAlias );
 158     m_aFunctionName = aFieldDesc.getOrDefault( "FunctionName", m_aFunctionName );
 159     m_eDataType = aFieldDesc.getOrDefault( "DataType", m_eDataType );
 160     m_eFunctionType = aFieldDesc.getOrDefault( "FunctionType", m_eFunctionType );
 161     m_nColWidth = aFieldDesc.getOrDefault( "ColWidth", m_nColWidth );
 162     m_bGroupBy = aFieldDesc.getOrDefault( "GroupBy", m_bGroupBy );
 163     m_bVisible = aFieldDesc.getOrDefault( "Visible", m_bVisible );
 164
 165     m_eFieldType = static_cast< ETableFieldType >( aFieldDesc.getOrDefault( "FieldType", static_cast< sal_Int32 >( m_eFieldType ) ) );
 166     m_eOrderDir = static_cast< EOrderDir >( aFieldDesc.getOrDefault( "OrderDir", static_cast< sal_Int32 >( m_eOrderDir ) ) );
 167
 168     if ( i_bIncludingCriteria )
 169     {
 170         const Sequence< PropertyValue > aCriteria( aFieldDesc.getOrDefault( "Criteria", Sequence< PropertyValue >() ) );
 171         m_aCriteria.resize( aCriteria.getLength() );
 172         ::std::transform(
 173             aCriteria.getConstArray(),
 174             aCriteria.getConstArray() + aCriteria.getLength(),
 175             m_aCriteria.begin(),
 176             SelectPropertyValueAsString()
 177         );
 178     }
 179 }
 180
 181 void OTableFieldDesc::Save( ::comphelper::NamedValueCollection& o_rSettings, const bool i_bIncludingCriteria )
 182 {
 183
 184     o_rSettings.put( "AliasName", m_aAliasName );
 185     o_rSettings.put( "TableName", m_aTableName );
 186     o_rSettings.put( "FieldName", m_aFieldName );
 187     o_rSettings.put( "FieldAlias", m_aFieldAlias );
 188     o_rSettings.put( "FunctionName", m_aFunctionName );
 189     o_rSettings.put( "DataType", m_eDataType );
 190     o_rSettings.put( "FunctionType", (sal_Int32)m_eFunctionType );
 191     o_rSettings.put( "FieldType", (sal_Int32)m_eFieldType );
 192     o_rSettings.put( "OrderDir", (sal_Int32)m_eOrderDir );
 193     o_rSettings.put( "ColWidth", m_nColWidth );
 194     o_rSettings.put( "GroupBy", m_bGroupBy );
 195     o_rSettings.put( "Visible", m_bVisible );
 196
 197     if ( i_bIncludingCriteria )
 198     {
 199         if ( !m_aCriteria.empty() )
 200         {
 201             sal_Int32 c = 0;
 202             Sequence< PropertyValue > aCriteria( m_aCriteria.size() );
 203             for (   ::std::vector< OUString >::const_iterator crit = m_aCriteria.begin();
 204                     crit != m_aCriteria.end();
 205                     ++crit, ++c
 206                 )
 207             {
 208                 aCriteria[c].Name = "Criterion_" + OUString::number( c );
 209                 aCriteria[c].Value <<= *crit;
 210             }
 211
 212             o_rSettings.put( "Criteria", aCriteria );
 213         }
 214     }
 215 }
 216
 217 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */