/**************************************************************
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*
*************************************************************/
// MARKER(update_precomp.py): autogen include statement, do not remove
#include "precompiled_scui.hxx"
#include "dpgroupdlg.hxx"
#ifndef SC_DPGROUPDLG_HRC
#include "dpgroupdlg.hrc"
#endif
#include "scresid.hxx"
#ifndef SC_SC_HRC
#include "sc.hrc"
#endif
#include "globstr.hrc"
#include <com/sun/star/sheet/DataPilotFieldGroupBy.hpp>
// ============================================================================
namespace {
/** Date part flags in order of the list box entries. */
static const sal_Int32 spnDateParts[] =
{
com::sun::star::sheet::DataPilotFieldGroupBy::SECONDS,
com::sun::star::sheet::DataPilotFieldGroupBy::MINUTES,
com::sun::star::sheet::DataPilotFieldGroupBy::HOURS,
com::sun::star::sheet::DataPilotFieldGroupBy::DAYS,
com::sun::star::sheet::DataPilotFieldGroupBy::MONTHS,
com::sun::star::sheet::DataPilotFieldGroupBy::QUARTERS,
com::sun::star::sheet::DataPilotFieldGroupBy::YEARS
};
static const sal_uInt16 nDatePartResIds[] =
{
STR_DPFIELD_GROUP_BY_SECONDS,
STR_DPFIELD_GROUP_BY_MINUTES,
STR_DPFIELD_GROUP_BY_HOURS,
STR_DPFIELD_GROUP_BY_DAYS,
STR_DPFIELD_GROUP_BY_MONTHS,
STR_DPFIELD_GROUP_BY_QUARTERS,
STR_DPFIELD_GROUP_BY_YEARS
};
} // namespace
// ============================================================================
ScDPGroupEditHelper::ScDPGroupEditHelper( RadioButton& rRbAuto, RadioButton& rRbMan, Edit& rEdValue ) :
mrRbAuto( rRbAuto ),
mrRbMan( rRbMan ),
mrEdValue( rEdValue )
{
mrRbAuto.SetClickHdl( LINK( this, ScDPGroupEditHelper, ClickHdl ) );
mrRbMan.SetClickHdl( LINK( this, ScDPGroupEditHelper, ClickHdl ) );
}
bool ScDPGroupEditHelper::IsAuto() const
{
return mrRbAuto.IsChecked();
}
double ScDPGroupEditHelper::GetValue() const
{
double fValue;
if( !ImplGetValue( fValue ) )
fValue = 0.0;
return fValue;
}
void ScDPGroupEditHelper::SetValue( bool bAuto, double fValue )
{
if( bAuto )
{
mrRbAuto.Check();
ClickHdl( &mrRbAuto );
}
else
{
mrRbMan.Check();
ClickHdl( &mrRbMan );
}
ImplSetValue( fValue );
}
IMPL_LINK( ScDPGroupEditHelper, ClickHdl, RadioButton*, pButton )
{
if( pButton == &mrRbAuto )
{
// disable edit field on clicking "automatic" radio button
mrEdValue.Disable();
}
else if( pButton == &mrRbMan )
{
// enable and set focus to edit field on clicking "manual" radio button
mrEdValue.Enable();
mrEdValue.GrabFocus();
}
return 0;
}
// ----------------------------------------------------------------------------
ScDPNumGroupEditHelper::ScDPNumGroupEditHelper(
RadioButton& rRbAuto, RadioButton& rRbMan, ScDoubleField& rEdValue ) :
ScDPGroupEditHelper( rRbAuto, rRbMan, rEdValue ),
mrEdValue( rEdValue )
{
}
bool ScDPNumGroupEditHelper::ImplGetValue( double& rfValue ) const
{
return mrEdValue.GetValue( rfValue );
}
void ScDPNumGroupEditHelper::ImplSetValue( double fValue )
{
mrEdValue.SetValue( fValue );
}
// ----------------------------------------------------------------------------
ScDPDateGroupEditHelper::ScDPDateGroupEditHelper(
RadioButton& rRbAuto, RadioButton& rRbMan, DateField& rEdValue, const Date& rNullDate ) :
ScDPGroupEditHelper( rRbAuto, rRbMan, rEdValue ),
mrEdValue( rEdValue ),
maNullDate( rNullDate )
{
}
bool ScDPDateGroupEditHelper::ImplGetValue( double& rfValue ) const
{
rfValue = mrEdValue.GetDate() - maNullDate;
return true;
}
void ScDPDateGroupEditHelper::ImplSetValue( double fValue )
{
Date aDate( maNullDate );
aDate += static_cast< sal_Int32 >( fValue );
mrEdValue.SetDate( aDate );
}
// ============================================================================
// ============================================================================
ScDPNumGroupDlg::ScDPNumGroupDlg( Window* pParent, const ScDPNumGroupInfo& rInfo ) :
ModalDialog ( pParent, ScResId( RID_SCDLG_DPNUMGROUP ) ),
maFlStart ( this, ScResId( FL_START ) ),
maRbAutoStart ( this, ScResId( RB_AUTOSTART ) ),
maRbManStart ( this, ScResId( RB_MANSTART ) ),
maEdStart ( this, ScResId( ED_START ) ),
maFlEnd ( this, ScResId( FL_END ) ),
maRbAutoEnd ( this, ScResId( RB_AUTOEND ) ),
maRbManEnd ( this, ScResId( RB_MANEND ) ),
maEdEnd ( this, ScResId( ED_END ) ),
maFlBy ( this, ScResId( FL_BY ) ),
maEdBy ( this, ScResId( ED_BY ) ),
maBtnOk ( this, ScResId( BTN_OK ) ),
maBtnCancel ( this, ScResId( BTN_CANCEL ) ),
maBtnHelp ( this, ScResId( BTN_HELP ) ),
maStartHelper ( maRbAutoStart, maRbManStart, maEdStart ),
maEndHelper ( maRbAutoEnd, maRbManEnd, maEdEnd )
{
FreeResource();
maStartHelper.SetValue( rInfo.AutoStart, rInfo.Start );
maEndHelper.SetValue( rInfo.AutoEnd, rInfo.End );
maEdBy.SetValue( (rInfo.Step <= 0.0) ? 1.0 : rInfo.Step );
/* Set the initial focus, currently it is somewhere after calling all the radio
button click handlers. Now the first enabled editable control is focused. */
if( maEdStart.IsEnabled() )
maEdStart.GrabFocus();
else if( maEdEnd.IsEnabled() )
maEdEnd.GrabFocus();
else
maEdBy.GrabFocus();
}
ScDPNumGroupInfo ScDPNumGroupDlg::GetGroupInfo() const
{
ScDPNumGroupInfo aInfo;
aInfo.Enable = sal_True;
aInfo.DateValues = sal_False;
aInfo.AutoStart = maStartHelper.IsAuto();
aInfo.AutoEnd = maEndHelper.IsAuto();
// get values and silently auto-correct them, if they are not valid
// TODO: error messages in OK event?
aInfo.Start = maStartHelper.GetValue();
aInfo.End = maEndHelper.GetValue();
if( !maEdBy.GetValue( aInfo.Step ) || (aInfo.Step <= 0.0) )
aInfo.Step = 1.0;
if( aInfo.End <= aInfo.Start )
aInfo.End = aInfo.Start + aInfo.Step;
return aInfo;
}
// ============================================================================
ScDPDateGroupDlg::ScDPDateGroupDlg( Window* pParent,
const ScDPNumGroupInfo& rInfo, sal_Int32 nDatePart, const Date& rNullDate ) :
ModalDialog ( pParent, ScResId( RID_SCDLG_DPDATEGROUP ) ),
maFlStart ( this, ScResId( FL_START ) ),
maRbAutoStart ( this, ScResId( RB_AUTOSTART ) ),
maRbManStart ( this, ScResId( RB_MANSTART ) ),
maEdStart ( this, ScResId( ED_START ) ),
maFlEnd ( this, ScResId( FL_END ) ),
maRbAutoEnd ( this, ScResId( RB_AUTOEND ) ),
maRbManEnd ( this, ScResId( RB_MANEND ) ),
maEdEnd ( this, ScResId( ED_END ) ),
maFlBy ( this, ScResId( FL_BY ) ),
maRbNumDays ( this, ScResId( RB_NUMDAYS ) ),
maRbUnits ( this, ScResId( RB_UNITS ) ),
maEdNumDays ( this, ScResId( ED_NUMDAYS ) ),
maLbUnits ( this, ScResId( LB_UNITS ) ),
maBtnOk ( this, ScResId( BTN_OK ) ),
maBtnCancel ( this, ScResId( BTN_CANCEL ) ),
maBtnHelp ( this, ScResId( BTN_HELP ) ),
maStartHelper ( maRbAutoStart, maRbManStart, maEdStart, rNullDate ),
maEndHelper ( maRbAutoEnd, maRbManEnd, maEdEnd, rNullDate )
{
FreeResource();
maLbUnits.SetHelpId( HID_SC_DPDATEGROUP_LB );
static const size_t nCount = sizeof( nDatePartResIds ) / sizeof( nDatePartResIds[0] );
for( size_t nIdx = 0 ; nIdx < nCount; ++nIdx )
maLbUnits.InsertEntry( ScGlobal::GetRscString( nDatePartResIds[nIdx] ) );
maEdStart.SetShowDateCentury( sal_True );
maEdEnd.SetShowDateCentury( sal_True );
maStartHelper.SetValue( rInfo.AutoStart, rInfo.Start );
maEndHelper.SetValue( rInfo.AutoEnd, rInfo.End );
if( nDatePart == 0 )
nDatePart = com::sun::star::sheet::DataPilotFieldGroupBy::MONTHS;
for( size_t nIdx = 0; nIdx < nCount; ++nIdx )
maLbUnits.CheckEntryPos( static_cast< sal_uInt16 >( nIdx ), (nDatePart & spnDateParts[ nIdx ]) != 0 );
if( rInfo.DateValues )
{
maRbNumDays.Check();
ClickHdl( &maRbNumDays );
double fNumDays = rInfo.Step;
if( fNumDays < 1.0 )
fNumDays = 1.0;
else if( fNumDays > 32767.0 )
fNumDays = 32767.0;
maEdNumDays.SetValue( static_cast< long >( fNumDays ) );
}
else
{
maRbUnits.Check();
ClickHdl( &maRbUnits );
}
/* Set the initial focus, currently it is somewhere after calling all the radio
button click handlers. Now the first enabled editable control is focused. */
if( maEdStart.IsEnabled() )
maEdStart.GrabFocus();
else if( maEdEnd.IsEnabled() )
maEdEnd.GrabFocus();
else if( maEdNumDays.IsEnabled() )
maEdNumDays.GrabFocus();
else if( maLbUnits.IsEnabled() )
maLbUnits.GrabFocus();
maRbNumDays.SetClickHdl( LINK( this, ScDPDateGroupDlg, ClickHdl ) );
maRbUnits.SetClickHdl( LINK( this, ScDPDateGroupDlg, ClickHdl ) );
maLbUnits.SetCheckButtonHdl( LINK( this, ScDPDateGroupDlg, CheckHdl ) );
}
ScDPNumGroupInfo ScDPDateGroupDlg::GetGroupInfo() const
{
ScDPNumGroupInfo aInfo;
aInfo.Enable = sal_True;
aInfo.DateValues = maRbNumDays.IsChecked();
aInfo.AutoStart = maStartHelper.IsAuto();
aInfo.AutoEnd = maEndHelper.IsAuto();
// get values and silently auto-correct them, if they are not valid
// TODO: error messages in OK event?
aInfo.Start = maStartHelper.GetValue();
aInfo.End = maEndHelper.GetValue();
sal_Int64 nNumDays = maEdNumDays.GetValue();
aInfo.Step = static_cast<double>( aInfo.DateValues ? nNumDays : 0L );
if( aInfo.End <= aInfo.Start )
aInfo.End = aInfo.Start + nNumDays;
return aInfo;
}
sal_Int32 ScDPDateGroupDlg::GetDatePart() const
{
// return DAYS for special "number of days" mode
if( maRbNumDays.IsChecked() )
return com::sun::star::sheet::DataPilotFieldGroupBy::DAYS;
// return listbox contents for "units" mode
sal_Int32 nDatePart = 0;
for( sal_uLong nIdx = 0, nCount = maLbUnits.GetEntryCount(); nIdx < nCount; ++nIdx )
if( maLbUnits.IsChecked( static_cast< sal_uInt16 >( nIdx ) ) )
nDatePart |= spnDateParts[ nIdx ];
return nDatePart;
}
IMPL_LINK( ScDPDateGroupDlg, ClickHdl, RadioButton*, pButton )
{
if( pButton == &maRbNumDays )
{
maLbUnits.Disable();
// enable and set focus to edit field on clicking "num of days" radio button
maEdNumDays.Enable();
maEdNumDays.GrabFocus();
maBtnOk.Enable();
}
else if( pButton == &maRbUnits )
{
maEdNumDays.Disable();
// enable and set focus to listbox on clicking "units" radio button
maLbUnits.Enable();
maLbUnits.GrabFocus();
// disable OK button if no date part selected
CheckHdl( &maLbUnits );
}
return 0;
}
IMPL_LINK( ScDPDateGroupDlg, CheckHdl, SvxCheckListBox*, pListBox )
{
// enable/disable OK button on modifying check list box
if( pListBox == &maLbUnits )
maBtnOk.Enable( maLbUnits.GetCheckedEntryCount() > 0 );
return 0;
}
// ============================================================================