forms/source/component/Date.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: Date.cxx,v $
  10  * $Revision: 1.27 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_forms.hxx"
  33 #include "Date.hxx"
  34 #include <tools/debug.hxx>
  35 #include <tools/date.hxx>
  36 #include <connectivity/dbconversion.hxx>
  37 #include <com/sun/star/sdbc/DataType.hpp>
  38
  39 using namespace dbtools;
  40
  41 //.........................................................................
  42 namespace frm
  43 {
  44 //.........................................................................
  45
  46 using namespace ::com::sun::star;
  47 using namespace ::com::sun::star::uno;
  48 using namespace ::com::sun::star::sdb;
  49 using namespace ::com::sun::star::sdbc;
  50 using namespace ::com::sun::star::sdbcx;
  51 using namespace ::com::sun::star::beans;
  52 using namespace ::com::sun::star::util;
  53 using namespace ::com::sun::star::container;
  54 using namespace ::com::sun::star::form;
  55 using namespace ::com::sun::star::awt;
  56 using namespace ::com::sun::star::io;
  57 using namespace ::com::sun::star::lang;
  58
  59 //------------------------------------------------------------------
  60 ODateControl::ODateControl(const Reference<XMultiServiceFactory>& _rxFactory)
  61                :OBoundControl(_rxFactory, VCL_CONTROL_DATEFIELD)
  62 {
  63 }
  64
  65 //------------------------------------------------------------------
  66 InterfaceRef SAL_CALL ODateControl_CreateInstance(const Reference<XMultiServiceFactory>& _rxFactory)
  67 {
  68     return *(new ODateControl(_rxFactory));
  69 }
  70
  71 //------------------------------------------------------------------------------
  72 Sequence<Type> ODateControl::_getTypes()
  73 {
  74     return OBoundControl::_getTypes();
  75 }
  76
  77 //------------------------------------------------------------------------------
  78 StringSequence SAL_CALL ODateControl::getSupportedServiceNames() throw()
  79 {
  80     StringSequence aSupported = OBoundControl::getSupportedServiceNames();
  81     aSupported.realloc(aSupported.getLength() + 1);
  82
  83     ::rtl::OUString*pArray = aSupported.getArray();
  84     pArray[aSupported.getLength()-1] = FRM_SUN_CONTROL_DATEFIELD;
  85     return aSupported;
  86 }
  87
  88 /*************************************************************************/
  89 //------------------------------------------------------------------
  90 InterfaceRef SAL_CALL ODateModel_CreateInstance(const Reference<XMultiServiceFactory>& _rxFactory)
  91 {
  92     return *(new ODateModel(_rxFactory));
  93 }
  94
  95 //------------------------------------------------------------------------------
  96 Sequence<Type> ODateModel::_getTypes()
  97 {
  98     return OEditBaseModel::_getTypes();
  99 }
 100
 101 //------------------------------------------------------------------
 102 DBG_NAME( ODateModel )
 103 //------------------------------------------------------------------
 104 ODateModel::ODateModel(const Reference<XMultiServiceFactory>& _rxFactory)
 105             :OEditBaseModel( _rxFactory, VCL_CONTROLMODEL_DATEFIELD, FRM_SUN_CONTROL_DATEFIELD, sal_True, sal_True )
 106                         // use the old control name for compytibility reasons
 107             ,OLimitedFormats( _rxFactory, FormComponentType::DATEFIELD )
 108 {
 109     DBG_CTOR( ODateModel, NULL );
 110
 111     m_nClassId = FormComponentType::DATEFIELD;
 112     initValueProperty( PROPERTY_DATE, PROPERTY_ID_DATE );
 113
 114     setAggregateSet(m_xAggregateFastSet, getOriginalHandle(PROPERTY_ID_DATEFORMAT));
 115
 116     osl_incrementInterlockedCount( &m_refCount );
 117     try
 118     {
 119         if ( m_xAggregateSet.is() )
 120             m_xAggregateSet->setPropertyValue( PROPERTY_DATEMIN, makeAny( (sal_Int32)( ::Date( 1, 1, 1800 ).GetDate() ) ) );
 121     }
 122     catch( const Exception& )
 123     {
 124         OSL_ENSURE( sal_False, "ODateModel::ODateModel: caught an exception!" );
 125     }
 126     osl_decrementInterlockedCount( &m_refCount );
 127 }
 128
 129 //------------------------------------------------------------------------------
 130 ODateModel::ODateModel( const ODateModel* _pOriginal, const Reference<XMultiServiceFactory>& _rxFactory )
 131     :OEditBaseModel( _pOriginal, _rxFactory )
 132     ,OLimitedFormats( _rxFactory, FormComponentType::DATEFIELD )
 133 {
 134     DBG_CTOR( ODateModel, NULL );
 135
 136     setAggregateSet( m_xAggregateFastSet, getOriginalHandle( PROPERTY_ID_DATEFORMAT ) );
 137 }
 138
 139 //------------------------------------------------------------------------------
 140 ODateModel::~ODateModel( )
 141 {
 142     setAggregateSet(Reference< XFastPropertySet >(), -1);
 143     DBG_DTOR( ODateModel, NULL );
 144 }
 145
 146 // XCloneable
 147 //------------------------------------------------------------------------------
 148 IMPLEMENT_DEFAULT_CLONING( ODateModel )
 149
 150 // XServiceInfo
 151 //------------------------------------------------------------------------------
 152 StringSequence SAL_CALL ODateModel::getSupportedServiceNames() throw()
 153 {
 154     StringSequence aSupported = OBoundControlModel::getSupportedServiceNames();
 155
 156     sal_Int32 nOldLen = aSupported.getLength();
 157     aSupported.realloc( nOldLen + 8 );
 158     ::rtl::OUString* pStoreTo = aSupported.getArray() + nOldLen;
 159
 160     *pStoreTo++ = BINDABLE_CONTROL_MODEL;
 161     *pStoreTo++ = DATA_AWARE_CONTROL_MODEL;
 162     *pStoreTo++ = VALIDATABLE_CONTROL_MODEL;
 163
 164     *pStoreTo++ = BINDABLE_DATA_AWARE_CONTROL_MODEL;
 165     *pStoreTo++ = VALIDATABLE_BINDABLE_CONTROL_MODEL;
 166
 167     *pStoreTo++ = FRM_SUN_COMPONENT_DATEFIELD;
 168     *pStoreTo++ = FRM_SUN_COMPONENT_DATABASE_DATEFIELD;
 169     *pStoreTo++ = BINDABLE_DATABASE_DATE_FIELD;
 170
 171     return aSupported;
 172 }
 173
 174 //------------------------------------------------------------------------------
 175 ::rtl::OUString SAL_CALL ODateModel::getServiceName() throw ( ::com::sun::star::uno::RuntimeException)
 176 {
 177     return FRM_COMPONENT_DATEFIELD;     // old (non-sun) name for compatibility !
 178 }
 179
 180 // XPropertySet
 181 //------------------------------------------------------------------------------
 182 void ODateModel::describeFixedProperties( Sequence< Property >& _rProps ) const
 183 {
 184     BEGIN_DESCRIBE_PROPERTIES( 4, OEditBaseModel )
 185         DECL_PROP3(DEFAULT_DATE,                        sal_Int32,                              BOUND, MAYBEDEFAULT, MAYBEVOID);
 186         DECL_PROP1(TABINDEX,                            sal_Int16,                              BOUND);
 187         DECL_PROP1(FORMATKEY,                           sal_Int32,                              TRANSIENT);
 188         DECL_IFACE_PROP2(FORMATSSUPPLIER,       XNumberFormatsSupplier, READONLY, TRANSIENT);
 189     END_DESCRIBE_PROPERTIES();
 190 }
 191
 192 //------------------------------------------------------------------------------
 193 void SAL_CALL ODateModel::getFastPropertyValue(Any& _rValue, sal_Int32 _nHandle ) const
 194 {
 195     switch (_nHandle)
 196     {
 197         case PROPERTY_ID_FORMATKEY:
 198             getFormatKeyPropertyValue(_rValue);
 199             break;
 200         case PROPERTY_ID_FORMATSSUPPLIER:
 201             _rValue <<= getFormatsSupplier();
 202             break;
 203         default:
 204             OEditBaseModel::getFastPropertyValue(_rValue, _nHandle);
 205             break;
 206     }
 207 }
 208
 209 //------------------------------------------------------------------------------
 210 sal_Bool SAL_CALL ODateModel::convertFastPropertyValue(Any& _rConvertedValue, Any& _rOldValue,
 211         sal_Int32 _nHandle, const Any& _rValue ) throw(IllegalArgumentException)
 212 {
 213     if (PROPERTY_ID_FORMATKEY == _nHandle)
 214         return convertFormatKeyPropertyValue(_rConvertedValue, _rOldValue, _rValue);
 215     else
 216         return OEditBaseModel::convertFastPropertyValue(_rConvertedValue, _rOldValue, _nHandle, _rValue );
 217 }
 218
 219 //------------------------------------------------------------------------------
 220 void SAL_CALL ODateModel::setFastPropertyValue_NoBroadcast(sal_Int32 _nHandle, const Any& _rValue) throw ( ::com::sun::star::uno::Exception)
 221 {
 222     if (PROPERTY_ID_FORMATKEY == _nHandle)
 223         setFormatKeyPropertyValue(_rValue);
 224     else
 225         OEditBaseModel::setFastPropertyValue_NoBroadcast(_nHandle, _rValue);
 226 }
 227
 228 // XLoadListener
 229 //------------------------------------------------------------------------------
 230 void ODateModel::onConnectedDbColumn( const Reference< XInterface >& _rxForm )
 231 {
 232     OBoundControlModel::onConnectedDbColumn( _rxForm );
 233     Reference<XPropertySet> xField = getField();
 234     if (xField.is())
 235     {
 236         m_bDateTimeField = sal_False;
 237         try
 238         {
 239             sal_Int32 nFieldType = 0;
 240             xField->getPropertyValue(PROPERTY_FIELDTYPE) >>= nFieldType;
 241             m_bDateTimeField = (nFieldType == DataType::TIMESTAMP);
 242         }
 243         catch(Exception&)
 244         {
 245         }
 246     }
 247 }
 248
 249 //------------------------------------------------------------------------------
 250 sal_Bool ODateModel::commitControlValueToDbColumn( bool /*_bPostReset*/ )
 251 {
 252     Any aControlValue( m_xAggregateFastSet->getFastPropertyValue( getValuePropertyAggHandle() ) );
 253     if ( !compare( aControlValue, m_aSaveValue ) )
 254     {
 255         if ( !aControlValue.hasValue() )
 256             m_xColumnUpdate->updateNull();
 257         else
 258         {
 259             try
 260             {
 261                 util::Date aDate;
 262                 if ( !( aControlValue >>= aDate ) )
 263                 {
 264                     sal_Int32 nAsInt(0);
 265                     aControlValue >>= nAsInt;
 266                     aDate = DBTypeConversion::toDate(nAsInt);
 267                 }
 268
 269                 if ( !m_bDateTimeField )
 270                     m_xColumnUpdate->updateDate( aDate );
 271                 else
 272                 {
 273                     util::DateTime aDateTime = m_xColumn->getTimestamp();
 274                     aDateTime.Day = aDate.Day;
 275                     aDateTime.Month = aDate.Month;
 276                     aDateTime.Year = aDate.Year;
 277                     m_xColumnUpdate->updateTimestamp( aDateTime );
 278                 }
 279             }
 280             catch(Exception&)
 281             {
 282                 return sal_False;
 283             }
 284         }
 285         m_aSaveValue = aControlValue;
 286     }
 287     return sal_True;
 288 }
 289
 290 //------------------------------------------------------------------------------
 291 void ODateModel::impl_translateControlValueToUNODate( Any& _rUNOValue ) const
 292 {
 293     _rUNOValue = getControlValue();
 294     if ( _rUNOValue.hasValue() )
 295     {
 296         sal_Int32 nDate = 0;
 297         OSL_VERIFY( _rUNOValue >>= nDate );
 298         _rUNOValue <<= DBTypeConversion::toDate( nDate );
 299     }
 300 }
 301
 302 //------------------------------------------------------------------------------
 303 Any ODateModel::translateControlValueToExternalValue( ) const
 304 {
 305     Any aExternalValue;
 306     impl_translateControlValueToUNODate( aExternalValue );
 307     return aExternalValue;
 308 }
 309
 310 //------------------------------------------------------------------------------
 311 Any ODateModel::translateExternalValueToControlValue( const Any& _rExternalValue ) const
 312 {
 313     Any aControlValue;
 314     if ( _rExternalValue.hasValue() )
 315     {
 316         util::Date aDate;
 317         OSL_VERIFY( _rExternalValue >>= aDate );
 318         aControlValue <<= DBTypeConversion::toINT32( aDate );
 319     }
 320     return aControlValue;
 321 }
 322
 323 //------------------------------------------------------------------------------
 324 Any ODateModel::translateControlValueToValidatableValue( ) const
 325 {
 326     Any aValidatableValue;
 327     impl_translateControlValueToUNODate( aValidatableValue );
 328     return aValidatableValue;
 329 }
 330
 331 //------------------------------------------------------------------------------
 332 Any ODateModel::translateDbColumnToControlValue()
 333 {
 334     util::Date aDate = m_xColumn->getDate();
 335     if (m_xColumn->wasNull())
 336         m_aSaveValue.clear();
 337     else
 338         // the aggregated set expects an Int32 as value ...
 339         m_aSaveValue <<= DBTypeConversion::toINT32(aDate);
 340
 341     return m_aSaveValue;
 342 }
 343
 344 //------------------------------------------------------------------------------
 345 Any ODateModel::getDefaultForReset() const
 346 {
 347     return m_aDefault;
 348 }
 349
 350 //------------------------------------------------------------------------------
 351 Sequence< Type > ODateModel::getSupportedBindingTypes()
 352 {
 353     return Sequence< Type >( &::getCppuType( static_cast< util::Date* >( NULL ) ), 1 );
 354 }
 355
 356 //.........................................................................
 357 }       // namespace frm
 358 //.........................................................................
 359