/**************************************************************
*
* 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_sc.hxx"
// System - Includes ---------------------------------------------------------
// INCLUDE -------------------------------------------------------------------
#include <rangelst.hxx>
#include <sfx2/dispatch.hxx>
#include <vcl/waitobj.hxx>
#include "uiitems.hxx"
#include "dbcolect.hxx"
#include "reffact.hxx"
#include "viewdata.hxx"
#include "document.hxx"
#include "docsh.hxx"
#include "scresid.hxx"
#include "foptmgr.hxx"
#include "globstr.hrc"
#include "filter.hrc"
#define _FILTDLG_CXX
#include "filtdlg.hxx"
#undef _FILTDLG_CXX
#include <vcl/msgbox.hxx>
// DEFINE --------------------------------------------------------------------
#define ERRORBOX(rid) ErrorBox( this, WinBits( WB_OK|WB_DEF_OK), \
ScGlobal::GetRscString(rid) ).Execute()
//============================================================================
// class ScFilterDlg
//----------------------------------------------------------------------------
ScFilterDlg::ScFilterDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent,
const SfxItemSet& rArgSet )
: ScAnyRefDlg ( pB, pCW, pParent, RID_SCDLG_FILTER ),
//
aFlCriteria ( this, ScResId( FL_CRITERIA ) ),
aLbConnect1 ( this, ScResId( LB_OP1 ) ),
aLbField1 ( this, ScResId( LB_FIELD1 ) ),
aLbCond1 ( this, ScResId( LB_COND1 ) ),
aEdVal1 ( this, ScResId( ED_VAL1 ) ),
aLbConnect2 ( this, ScResId( LB_OP2 ) ),
aLbField2 ( this, ScResId( LB_FIELD2 ) ),
aLbCond2 ( this, ScResId( LB_COND2 ) ),
aEdVal2 ( this, ScResId( ED_VAL2 ) ),
aLbConnect3 ( this, ScResId( LB_OP3 ) ),
aLbField3 ( this, ScResId( LB_FIELD3 ) ),
aLbCond3 ( this, ScResId( LB_COND3 ) ),
aEdVal3 ( this, ScResId( ED_VAL3 ) ),
aLbConnect4 ( this, ScResId( LB_OP4 ) ),
aLbField4 ( this, ScResId( LB_FIELD4 ) ),
aLbCond4 ( this, ScResId( LB_COND4 ) ),
aEdVal4 ( this, ScResId( ED_VAL4 ) ),
aFtConnect ( this, ScResId( FT_OP ) ),
aFtField ( this, ScResId( FT_FIELD ) ),
aFtCond ( this, ScResId( FT_COND ) ),
aFtVal ( this, ScResId( FT_VAL ) ),
aFlSeparator ( this, ScResId( FL_SEPARATOR ) ),
aScrollBar ( this, ScResId( LB_SCROLL ) ),
aFlOptions ( this, ScResId( FL_OPTIONS ) ),
aBtnMore ( this, ScResId( BTN_MORE ) ),
aBtnHelp ( this, ScResId( BTN_HELP ) ),
aBtnOk ( this, ScResId( BTN_OK ) ),
aBtnCancel ( this, ScResId( BTN_CANCEL ) ),
_INIT_COMMON_FILTER_RSCOBJS
aStrEmpty ( ScResId( SCSTR_EMPTY ) ),
aStrNotEmpty ( ScResId( SCSTR_NOTEMPTY ) ),
aStrRow ( ScResId( SCSTR_ROW ) ),
aStrColumn ( ScResId( SCSTR_COLUMN ) ),
//
pOptionsMgr ( NULL ),
nWhichQuery ( rArgSet.GetPool()->GetWhich( SID_QUERY ) ),
theQueryData ( ((const ScQueryItem&)
rArgSet.Get( nWhichQuery )).GetQueryData() ),
pOutItem ( NULL ),
pViewData ( NULL ),
pDoc ( NULL ),
nSrcTab ( 0 ),
nFieldCount ( 0 ),
bRefInputMode ( sal_False ),
pTimer ( NULL )
{
for (sal_uInt16 i=0; i<=MAXCOL; i++)
pEntryLists[i] = NULL;
for (SCSIZE i=0;i<MAXQUERY;i++)
{
bRefreshExceptQuery[i]=sal_False;
}
aBtnMore.SetMoreText( String(ScResId( SCSTR_MOREBTN_MOREOPTIONS )) );
aBtnMore.SetLessText( String(ScResId( SCSTR_MOREBTN_FEWEROPTIONS )) );
Init( rArgSet );
FreeResource();
// Hack: RefInput-Kontrolle
pTimer = new Timer;
pTimer->SetTimeout( 50 ); // 50ms warten
pTimer->SetTimeoutHdl( LINK( this, ScFilterDlg, TimeOutHdl ) );
String sAccName (ScResId(RID_FILTER_OPERATOR));
String sIndexName(sAccName);
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 1"));
aLbConnect1.SetAccessibleName(sIndexName);
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 2"));
aLbConnect2.SetAccessibleName(sIndexName);
sAccName = String(ScResId(RID_FILTER_FIELDNAME));
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 1"));
aLbField1.SetAccessibleName(sIndexName);
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 2"));
aLbField2.SetAccessibleName(sIndexName);
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 3"));
aLbField3.SetAccessibleName(sIndexName);
sAccName = String(ScResId(RID_FILTER_CONDITION));
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 1"));
aLbCond1.SetAccessibleName(sIndexName);
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 2"));
aLbCond2.SetAccessibleName(sIndexName);
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 3"));
aLbCond3.SetAccessibleName(sIndexName);
sAccName = String(ScResId(RID_FILTER_VALUE));
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 1"));
aEdVal1.SetAccessibleName(sIndexName);
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 2"));
aEdVal2.SetAccessibleName(sIndexName);
sIndexName = sAccName;
sIndexName.AppendAscii (RTL_CONSTASCII_STRINGPARAM (" 3"));
aEdVal3.SetAccessibleName(sIndexName);
aLbCopyArea.SetAccessibleName(ScResId(STR_COPY_AREA_TO));
aEdCopyArea.SetAccessibleName(ScResId(STR_COPY_AREA_TO));
aLbCopyArea.SetAccessibleRelationLabeledBy(&aBtnCopyResult);
aEdCopyArea.SetAccessibleRelationLabeledBy(&aBtnCopyResult);
aLbConnect1.SetAccessibleRelationLabeledBy(&aFtConnect);
aLbConnect2.SetAccessibleRelationLabeledBy(&aFtConnect);
aLbField1.SetAccessibleRelationLabeledBy(&aFtField);
aLbField2.SetAccessibleRelationLabeledBy(&aFtField);
aLbField3.SetAccessibleRelationLabeledBy(&aFtField);
aLbCond1.SetAccessibleRelationLabeledBy(&aFtCond);
aLbCond2.SetAccessibleRelationLabeledBy(&aFtCond);
aLbCond3.SetAccessibleRelationLabeledBy(&aFtCond);
aEdVal1.SetAccessibleRelationLabeledBy(&aFtVal);
aEdVal2.SetAccessibleRelationLabeledBy(&aFtVal);
aEdVal3.SetAccessibleRelationLabeledBy(&aFtVal);
}
//----------------------------------------------------------------------------
__EXPORT ScFilterDlg::~ScFilterDlg()
{
for (sal_uInt16 i=0; i<=MAXCOL; i++)
delete pEntryLists[i];
delete pOptionsMgr;
delete pOutItem;
// Hack: RefInput-Kontrolle
pTimer->Stop();
delete pTimer;
}
//----------------------------------------------------------------------------
void __EXPORT ScFilterDlg::Init( const SfxItemSet& rArgSet )
{
const ScQueryItem& rQueryItem = (const ScQueryItem&)
rArgSet.Get( nWhichQuery );
aBtnOk.SetClickHdl ( LINK( this, ScFilterDlg, EndDlgHdl ) );
aBtnCancel.SetClickHdl ( LINK( this, ScFilterDlg, EndDlgHdl ) );
aBtnMore.SetClickHdl ( LINK( this, ScFilterDlg, MoreClickHdl ) );
aBtnHeader.SetClickHdl ( LINK( this, ScFilterDlg, CheckBoxHdl ) );
aBtnCase.SetClickHdl ( LINK( this, ScFilterDlg, CheckBoxHdl ) );
//
aLbField1.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbField2.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbField3.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbField4.SetSelectHdl ( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbConnect1.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbConnect2.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbConnect3.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbConnect4.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbCond1.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbCond2.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbCond3.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
aLbCond4.SetSelectHdl( LINK( this, ScFilterDlg, LbSelectHdl ) );
pViewData = rQueryItem.GetViewData();
pDoc = pViewData ? pViewData->GetDocument() : NULL;
nSrcTab = pViewData ? pViewData->GetTabNo() : static_cast<SCTAB>(0);
// fuer leichteren Zugriff:
aFieldLbArr [0] = &aLbField1;
aFieldLbArr [1] = &aLbField2;
aFieldLbArr [2] = &aLbField3;
aFieldLbArr [3] = &aLbField4;
aValueEdArr [0] = &aEdVal1;
aValueEdArr [1] = &aEdVal2;
aValueEdArr [2] = &aEdVal3;
aValueEdArr [3] = &aEdVal4;
aCondLbArr [0] = &aLbCond1;
aCondLbArr [1] = &aLbCond2;
aCondLbArr [2] = &aLbCond3;
aCondLbArr [3] = &aLbCond4;
aConnLbArr [0] = &aLbConnect1;
aConnLbArr [1] = &aLbConnect2;
aConnLbArr [2] = &aLbConnect3;
aConnLbArr [3] = &aLbConnect4;
// Optionen initialisieren lassen:
pOptionsMgr = new ScFilterOptionsMgr(
this,
pViewData,
theQueryData,
aBtnMore,
aBtnCase,
aBtnRegExp,
aBtnHeader,
aBtnUnique,
aBtnCopyResult,
aBtnDestPers,
aLbCopyArea,
aEdCopyArea,
aRbCopyArea,
aFtDbAreaLabel,
aFtDbArea,
aFlOptions,
aStrNoName,
aStrUndefined );
// Feldlisten einlesen und Eintraege selektieren:
FillFieldLists();
for ( SCSIZE i=0; i<4; i++ )
{
String aValStr;
sal_uInt16 nCondPos = 0;
sal_uInt16 nFieldSelPos = 0;
ScQueryEntry& rEntry = theQueryData.GetEntry(i);
if ( rEntry.bDoQuery )
{
nCondPos = (sal_uInt16)rEntry.eOp;
nFieldSelPos = GetFieldSelPos( static_cast<SCCOL>(rEntry.nField) );
if ( rEntry.nVal == SC_EMPTYFIELDS && !rEntry.bQueryByString && *rEntry.pStr == EMPTY_STRING )
{
aValStr = aStrEmpty;
aCondLbArr[i]->Disable();
}
else if ( rEntry.nVal == SC_NONEMPTYFIELDS && !rEntry.bQueryByString && *rEntry.pStr == EMPTY_STRING )
{
aValStr = aStrNotEmpty;
aCondLbArr[i]->Disable();
}
else
aValStr = *rEntry.pStr;
}
else if ( i == 0 )
{
nFieldSelPos = GetFieldSelPos( pViewData->GetCurX() );
rEntry.nField = nFieldSelPos ? (theQueryData.nCol1 +
static_cast<SCCOL>(nFieldSelPos) - 1) : static_cast<SCCOL>(0);
rEntry.bDoQuery=sal_True;
bRefreshExceptQuery[i]=sal_True;
}
aFieldLbArr[i]->SelectEntryPos( nFieldSelPos );
aCondLbArr [i]->SelectEntryPos( nCondPos );
aValueEdArr[i]->SetText( aValStr );
aValueEdArr[i]->SetModifyHdl( LINK( this, ScFilterDlg, ValModifyHdl ) );
UpdateValueList( static_cast<sal_uInt16>(i+1) );
}
aScrollBar.SetEndScrollHdl( LINK( this, ScFilterDlg, ScrollHdl ) );
aScrollBar.SetScrollHdl( LINK( this, ScFilterDlg, ScrollHdl ) );
aScrollBar.SetRange( Range( 0, 4 ) );
aScrollBar.SetLineSize( 1 );
aLbConnect1.Hide();
// Disable/Enable Logik:
(aLbField1.GetSelectEntryPos() != 0)
&& (aLbField2.GetSelectEntryPos() != 0)
? aLbConnect2.SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(1).eConnect )
: aLbConnect2.SetNoSelection();
(aLbField2.GetSelectEntryPos() != 0)
&& (aLbField3.GetSelectEntryPos() != 0)
? aLbConnect3.SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(2).eConnect )
: aLbConnect3.SetNoSelection();
(aLbField3.GetSelectEntryPos() != 0)
&& (aLbField4.GetSelectEntryPos() != 0)
? aLbConnect4.SelectEntryPos( (sal_uInt16)theQueryData.GetEntry(3).eConnect )
: aLbConnect4.SetNoSelection();
if ( aLbField1.GetSelectEntryPos() == 0 )
{
aLbConnect2.Disable();
aLbField2.Disable();
aLbCond2.Disable();
aEdVal2.Disable();
}
else if ( aLbConnect2.GetSelectEntryCount() == 0 )
{
aLbField2.Disable();
aLbCond2.Disable();
aEdVal2.Disable();
}
if ( aLbField2.GetSelectEntryPos() == 0 )
{
aLbConnect3.Disable();
aLbField3.Disable();
aLbCond3.Disable();
aEdVal3.Disable();
}
else if ( aLbConnect3.GetSelectEntryCount() == 0 )
{
aLbField3.Disable();
aLbCond3.Disable();
aEdVal3.Disable();
}
if ( aLbField3.GetSelectEntryPos() == 0 )
{
aLbConnect4.Disable();
aLbField4.Disable();
aLbCond4.Disable();
aEdVal4.Disable();
}
else if ( aLbConnect4.GetSelectEntryCount() == 0 )
{
aLbField4.Disable();
aLbCond4.Disable();
aEdVal4.Disable();
}
if(pDoc!=NULL &&
pDoc->GetChangeTrack()!=NULL) aBtnCopyResult.Disable();
// Modal-Modus einschalten
// SetDispatcherLock( sal_True );
//@BugID 54702 Enablen/Disablen nur noch in Basisklasse
// SFX_APPWINDOW->Disable(sal_False); //! allgemeine Methode im ScAnyRefDlg
}
//----------------------------------------------------------------------------
sal_Bool __EXPORT ScFilterDlg::Close()
{
if (pViewData)
pViewData->GetDocShell()->CancelAutoDBRange();
return DoClose( ScFilterDlgWrapper::GetChildWindowId() );
}
//----------------------------------------------------------------------------
// Uebergabe eines mit der Maus selektierten Tabellenbereiches, der dann als
// neue Selektion im Referenz-Edit angezeigt wird.
void ScFilterDlg::SetReference( const ScRange& rRef, ScDocument* pDocP )
{
if ( bRefInputMode ) // Nur moeglich, wenn im Referenz-Editmodus
{
if ( rRef.aStart != rRef.aEnd )
RefInputStart( &aEdCopyArea );
String aRefStr;
rRef.aStart.Format( aRefStr, SCA_ABS_3D, pDocP, pDocP->GetAddressConvention() );
aEdCopyArea.SetRefString( aRefStr );
}
}
//----------------------------------------------------------------------------
void ScFilterDlg::SetActive()
{
if ( bRefInputMode )
{
aEdCopyArea.GrabFocus();
if ( aEdCopyArea.GetModifyHdl().IsSet() )
((Link&)aEdCopyArea.GetModifyHdl()).Call( &aEdCopyArea );
}
else
GrabFocus();
RefInputDone();
}
//----------------------------------------------------------------------------
void ScFilterDlg::FillFieldLists()
{
aLbField1.Clear();
aLbField2.Clear();
aLbField3.Clear();
aLbField4.Clear();
aLbField1.InsertEntry( aStrNone, 0 );
aLbField2.InsertEntry( aStrNone, 0 );
aLbField3.InsertEntry( aStrNone, 0 );
aLbField4.InsertEntry( aStrNone, 0 );
if ( pDoc )
{
String aFieldName;
SCTAB nTab = nSrcTab;
SCCOL nFirstCol = theQueryData.nCol1;
SCROW nFirstRow = theQueryData.nRow1;
SCCOL nMaxCol = theQueryData.nCol2;
SCCOL col = 0;
sal_uInt16 i=1;
for ( col=nFirstCol; col<=nMaxCol; col++ )
{
pDoc->GetString( col, nFirstRow, nTab, aFieldName );
if ( !aBtnHeader.IsChecked() || (aFieldName.Len() == 0) )
{
aFieldName = aStrColumn;
aFieldName += ' ';
aFieldName += ScColToAlpha( col );
}
aLbField1.InsertEntry( aFieldName, i );
aLbField2.InsertEntry( aFieldName, i );
aLbField3.InsertEntry( aFieldName, i );
aLbField4.InsertEntry( aFieldName, i );
i++;
}
nFieldCount = i;
}
}
//----------------------------------------------------------------------------
void ScFilterDlg::UpdateValueList( sal_uInt16 nList )
{
if ( pDoc && nList>0 && nList<=4 )
{
ComboBox* pValList = aValueEdArr[nList-1];
sal_uInt16 nFieldSelPos = aFieldLbArr[nList-1]->GetSelectEntryPos();
sal_uInt16 nListPos = 0;
String aCurValue = pValList->GetText();
pValList->Clear();
pValList->InsertEntry( aStrNotEmpty, 0 );
pValList->InsertEntry( aStrEmpty, 1 );
nListPos = 2;
if ( nFieldSelPos )
{
WaitObject aWaiter( this ); // auch wenn nur die ListBox gefuellt wird
SCCOL nColumn = theQueryData.nCol1 + static_cast<SCCOL>(nFieldSelPos) - 1;
if (!pEntryLists[nColumn])
{
sal_uInt16 nOffset = GetSliderPos();
SCTAB nTab = nSrcTab;
SCROW nFirstRow = theQueryData.nRow1;
SCROW nLastRow = theQueryData.nRow2;
mbHasDates[nOffset+nList-1] = false;
// erstmal ohne die erste Zeile
pEntryLists[nColumn] = new TypedScStrCollection( 128, 128 );
pEntryLists[nColumn]->SetCaseSensitive( aBtnCase.IsChecked() );
pDoc->GetFilterEntriesArea( nColumn, nFirstRow+1, nLastRow,
nTab, *pEntryLists[nColumn], mbHasDates[nOffset+nList-1] );
// Eintrag fuer die erste Zeile
//! Eintrag (pHdrEntry) ohne Collection erzeugen?
nHeaderPos[nColumn] = USHRT_MAX;
TypedScStrCollection aHdrColl( 1, 1 );
bool bDummy = false;
pDoc->GetFilterEntriesArea( nColumn, nFirstRow, nFirstRow,
nTab, aHdrColl, bDummy );
TypedStrData* pHdrEntry = aHdrColl[0];
if ( pHdrEntry )
{
TypedStrData* pNewEntry = new TypedStrData(*pHdrEntry);
if ( pEntryLists[nColumn]->Insert( pNewEntry ) )
{
nHeaderPos[nColumn] = pEntryLists[nColumn]->IndexOf( pNewEntry );
DBG_ASSERT( nHeaderPos[nColumn] != USHRT_MAX,
"Header-Eintrag nicht wiedergefunden" );
}
else
delete pNewEntry; // war schon drin
}
}
TypedScStrCollection* pColl = pEntryLists[nColumn];
sal_uInt16 nValueCount = pColl->GetCount();
if ( nValueCount > 0 )
{
for ( sal_uInt16 i=0; i<nValueCount; i++ )
{
pValList->InsertEntry( (*pColl)[i]->GetString(), nListPos );
nListPos++;
}
}
}
pValList->SetText( aCurValue );
}
UpdateHdrInValueList( nList );
}
void ScFilterDlg::UpdateHdrInValueList( sal_uInt16 nList )
{
//! GetText / SetText ??
if ( pDoc && nList>0 && nList<=4 )
{
sal_uInt16 nFieldSelPos = aFieldLbArr[nList-1]->GetSelectEntryPos();
if ( nFieldSelPos )
{
SCCOL nColumn = theQueryData.nCol1 + static_cast<SCCOL>(nFieldSelPos) - 1;
if ( pEntryLists[nColumn] )
{
sal_uInt16 nPos = nHeaderPos[nColumn];
if ( nPos != USHRT_MAX )
{
ComboBox* pValList = aValueEdArr[nList-1];
sal_uInt16 nListPos = nPos + 2; // nach "leer" und "nicht leer"
TypedStrData* pHdrEntry = (*pEntryLists[nColumn])[nPos];
if ( pHdrEntry )
{
String aHdrStr = pHdrEntry->GetString();
sal_Bool bWasThere = ( pValList->GetEntry(nListPos) == aHdrStr );
sal_Bool bInclude = !aBtnHeader.IsChecked();
if (bInclude) // Eintrag aufnehmen
{
if (!bWasThere)
pValList->InsertEntry(aHdrStr, nListPos);
}
else // Eintrag weglassen
{
if (bWasThere)
pValList->RemoveEntry(nListPos);
}
}
else
{
DBG_ERROR("Eintag in Liste nicht gefunden");
}
}
}
else
{
DBG_ERROR("Spalte noch nicht initialisiert");
}
}
}
}
//----------------------------------------------------------------------------
void ScFilterDlg::ClearValueList( sal_uInt16 nList )
{
if ( nList>0 && nList<=4 )
{
ComboBox* pValList = aValueEdArr[nList-1];
pValList->Clear();
pValList->InsertEntry( aStrNotEmpty, 0 );
pValList->InsertEntry( aStrEmpty, 1 );
pValList->SetText( EMPTY_STRING );
}
}
//----------------------------------------------------------------------------
sal_uInt16 ScFilterDlg::GetFieldSelPos( SCCOL nField )
{
if ( nField >= theQueryData.nCol1 && nField <= theQueryData.nCol2 )
return static_cast<sal_uInt16>(nField - theQueryData.nCol1 + 1);
else
return 0;
}
//----------------------------------------------------------------------------
ScQueryItem* ScFilterDlg::GetOutputItem()
{
ScAddress theCopyPos;
ScQueryParam theParam( theQueryData );
sal_Bool bCopyPosOk = sal_False;
if ( aBtnCopyResult.IsChecked() )
{
String theCopyStr( aEdCopyArea.GetText() );
xub_StrLen nColonPos = theCopyStr.Search( ':' );
if ( STRING_NOTFOUND != nColonPos )
theCopyStr.Erase( nColonPos );
sal_uInt16 nResult = theCopyPos.Parse( theCopyStr, pDoc, pDoc->GetAddressConvention() );
bCopyPosOk = ( SCA_VALID == (nResult & SCA_VALID) );
}
if ( aBtnCopyResult.IsChecked() && bCopyPosOk )
{
theParam.bInplace = sal_False;
theParam.nDestTab = theCopyPos.Tab();
theParam.nDestCol = theCopyPos.Col();
theParam.nDestRow = theCopyPos.Row();
}
else
{
theParam.bInplace = sal_True;
theParam.nDestTab = 0;
theParam.nDestCol = 0;
theParam.nDestRow = 0;
}
theParam.bHasHeader = aBtnHeader.IsChecked();
theParam.bByRow = sal_True;
theParam.bDuplicate = !aBtnUnique.IsChecked();
theParam.bCaseSens = aBtnCase.IsChecked();
theParam.bRegExp = aBtnRegExp.IsChecked();
theParam.bDestPers = aBtnDestPers.IsChecked();
// nur die drei eingestellten - alles andere zuruecksetzen
DELETEZ( pOutItem );
pOutItem = new ScQueryItem( nWhichQuery, &theParam );
return pOutItem;
}
//----------------------------------------------------------------------------
sal_Bool ScFilterDlg::IsRefInputMode() const
{
return bRefInputMode;
}
//----------------------------------------------------------------------------
// Handler:
// ========
IMPL_LINK( ScFilterDlg, EndDlgHdl, Button*, pBtn )
{
if ( pBtn == &aBtnOk )
{
sal_Bool bAreaInputOk = sal_True;
if ( aBtnCopyResult.IsChecked() )
{
if ( !pOptionsMgr->VerifyPosStr( aEdCopyArea.GetText() ) )
{
if ( !aBtnMore.GetState() )
aBtnMore.SetState( sal_True );
ERRORBOX( STR_INVALID_TABREF );
aEdCopyArea.GrabFocus();
bAreaInputOk = sal_False;
}
}
if ( bAreaInputOk )
{
SetDispatcherLock( sal_False );
SwitchToDocument();
GetBindings().GetDispatcher()->Execute( FID_FILTER_OK,
SFX_CALLMODE_SLOT | SFX_CALLMODE_RECORD,
GetOutputItem(), 0L, 0L );
Close();
}
}
else if ( pBtn == &aBtnCancel )
{
Close();
}
return 0;
}
//----------------------------------------------------------------------------
IMPL_LINK( ScFilterDlg, MoreClickHdl, MoreButton*, EMPTYARG )
{
if ( aBtnMore.GetState() )
pTimer->Start();
else
{
pTimer->Stop();
bRefInputMode = sal_False;
//@BugID 54702 Enablen/Disablen nur noch in Basisklasse
//SFX_APPWINDOW->Disable(sal_False); //! allgemeine Methode im ScAnyRefDlg
}
return 0;
}
//----------------------------------------------------------------------------
IMPL_LINK( ScFilterDlg, TimeOutHdl, Timer*, _pTimer )
{
// alle 50ms nachschauen, ob RefInputMode noch stimmt
if( _pTimer == pTimer && IsActive() )
bRefInputMode = (aEdCopyArea.HasFocus() || aRbCopyArea.HasFocus());
if ( aBtnMore.GetState() )
pTimer->Start();
return 0;
}
//----------------------------------------------------------------------------
IMPL_LINK( ScFilterDlg, LbSelectHdl, ListBox*, pLb )
{
/*
* Behandlung der Enable/Disable-Logik,
* abhaengig davon, welche ListBox angefasst wurde:
*/
sal_uInt16 nOffset = GetSliderPos();
if ( pLb == &aLbConnect1 )
{
aLbField1.Enable();
aLbCond1.Enable();
aEdVal1.Enable();
sal_uInt16 nConnect1 = aLbConnect1.GetSelectEntryPos();
sal_uInt16 nQE = nOffset;
theQueryData.GetEntry(nQE).eConnect =(ScQueryConnect)nConnect1;
bRefreshExceptQuery[nQE]=sal_True;
}
else if ( pLb == &aLbConnect2 )
{
aLbField2.Enable();
aLbCond2.Enable();
aEdVal2.Enable();
sal_uInt16 nConnect2 = aLbConnect2.GetSelectEntryPos();
sal_uInt16 nQE = 1+nOffset;
theQueryData.GetEntry(nQE).eConnect =(ScQueryConnect)nConnect2;
bRefreshExceptQuery[nQE]=sal_True;
}
else if ( pLb == &aLbConnect3 )
{
aLbField3.Enable();
aLbCond3.Enable();
aEdVal3.Enable();
sal_uInt16 nConnect3 = aLbConnect3.GetSelectEntryPos();
sal_uInt16 nQE = 2+nOffset;
theQueryData.GetEntry(nQE).eConnect = (ScQueryConnect)nConnect3;
bRefreshExceptQuery[nQE]=sal_True;
}
else if ( pLb == &aLbConnect4 )
{
aLbField4.Enable();
aLbCond4.Enable();
aEdVal4.Enable();
sal_uInt16 nConnect4 = aLbConnect4.GetSelectEntryPos();
sal_uInt16 nQE = 3+nOffset;
theQueryData.GetEntry(nQE).eConnect = (ScQueryConnect)nConnect4;
bRefreshExceptQuery[nQE]=sal_True;
}
else if ( pLb == &aLbField1 )
{
if ( aLbField1.GetSelectEntryPos() == 0 )
{
aLbConnect2.SetNoSelection();
aLbConnect3.SetNoSelection();
aLbConnect4.SetNoSelection();
aLbField2.SelectEntryPos( 0 );
aLbField3.SelectEntryPos( 0 );
aLbField4.SelectEntryPos( 0 );
aLbCond2.SelectEntryPos( 0 );
aLbCond3.SelectEntryPos( 0 );
aLbCond4.SelectEntryPos( 0 );
ClearValueList( 1 );
ClearValueList( 2 );
ClearValueList( 3 );
ClearValueList( 4 );
aLbConnect2.Disable();
aLbConnect3.Disable();
aLbConnect4.Disable();
aLbField2.Disable();
aLbField3.Disable();
aLbField4.Disable();
aLbCond2.Disable();
aLbCond3.Disable();
aLbCond4.Disable();
aEdVal2.Disable();
aEdVal3.Disable();
aEdVal4.Disable();
for (sal_uInt16 i= nOffset; i< MAXQUERY; i++)
{
theQueryData.GetEntry(i).bDoQuery = sal_False;
bRefreshExceptQuery[i]=sal_False;
theQueryData.GetEntry(i).nField = static_cast<SCCOL>(0);
}
bRefreshExceptQuery[nOffset] =sal_True;
}
else
{
UpdateValueList( 1 );
if ( !aLbConnect2.IsEnabled() )
{
aLbConnect2.Enable();
}
theQueryData.GetEntry(nOffset).bDoQuery = sal_True;
sal_uInt16 nField = pLb->GetSelectEntryPos();
theQueryData.GetEntry(nOffset).nField = theQueryData.nCol1 + static_cast<SCCOL>(nField) - 1 ;
}
}
else if ( pLb == &aLbField2 )
{
if ( aLbField2.GetSelectEntryPos() == 0 )
{
aLbConnect3.SetNoSelection();
aLbConnect4.SetNoSelection();
aLbField3.SelectEntryPos( 0 );
aLbField4.SelectEntryPos( 0 );
aLbCond3.SelectEntryPos( 0 );
aLbCond4.SelectEntryPos( 0 );
ClearValueList( 2 );
ClearValueList( 3 );
ClearValueList( 4 );
aLbConnect3.Disable();
aLbConnect4.Disable();
aLbField3.Disable();
aLbField4.Disable();
aLbCond3.Disable();
aLbCond4.Disable();
aEdVal3.Disable();
aEdVal4.Disable();
sal_uInt16 nTemp=nOffset+1;
for (sal_uInt16 i= nTemp; i< MAXQUERY; i++)
{
theQueryData.GetEntry(i).bDoQuery = sal_False;
bRefreshExceptQuery[i]=sal_False;
theQueryData.GetEntry(i).nField = static_cast<SCCOL>(0);
}
bRefreshExceptQuery[nTemp]=sal_True;
}
else
{
UpdateValueList( 2 );
if ( !aLbConnect3.IsEnabled() )
{
aLbConnect3.Enable();
}
sal_uInt16 nField = pLb->GetSelectEntryPos();
sal_uInt16 nQ=1+nOffset;
theQueryData.GetEntry(nQ).bDoQuery = sal_True;
theQueryData.GetEntry(nQ).nField = theQueryData.nCol1 + static_cast<SCCOL>(nField) - 1 ;
}
}
else if ( pLb == &aLbField3 )
{
if ( aLbField3.GetSelectEntryPos() == 0 )
{
aLbConnect4.SetNoSelection();
aLbField4.SelectEntryPos( 0 );
aLbCond4.SelectEntryPos( 0 );
ClearValueList( 3 );
ClearValueList( 4 );
aLbConnect4.Disable();
aLbField4.Disable();
aLbCond4.Disable();
aEdVal4.Disable();
sal_uInt16 nTemp=nOffset+2;
for (sal_uInt16 i= nTemp; i< MAXQUERY; i++)
{
theQueryData.GetEntry(i).bDoQuery = sal_False;
bRefreshExceptQuery[i]=sal_False;
theQueryData.GetEntry(i).nField = static_cast<SCCOL>(0);
}
bRefreshExceptQuery[nTemp]=sal_True;
}
else
{
UpdateValueList( 3 );
if ( !aLbConnect4.IsEnabled() )
{
aLbConnect4.Enable();
}
sal_uInt16 nField = pLb->GetSelectEntryPos();
sal_uInt16 nQ=2+nOffset;
theQueryData.GetEntry(nQ).bDoQuery = sal_True;
theQueryData.GetEntry(nQ).nField = theQueryData.nCol1 + static_cast<SCCOL>(nField) - 1 ;
}
}
else if ( pLb == &aLbField4 )
{
if ( aLbField4.GetSelectEntryPos() == 0 )
{
ClearValueList( 4 );
sal_uInt16 nTemp=nOffset+3;
for (sal_uInt16 i= nTemp; i< MAXQUERY; i++)
{
theQueryData.GetEntry(i).bDoQuery = sal_False;
bRefreshExceptQuery[i]=sal_False;
theQueryData.GetEntry(i).nField = static_cast<SCCOL>(0);
}
bRefreshExceptQuery[nTemp]=sal_True;
}
else
{
UpdateValueList( 4 );
sal_uInt16 nField = pLb->GetSelectEntryPos();
sal_uInt16 nQ=3+nOffset;
theQueryData.GetEntry(nQ).bDoQuery = sal_True;
theQueryData.GetEntry(nQ).nField = theQueryData.nCol1 + static_cast<SCCOL>(nField) - 1 ;
}
}
else if ( pLb == &aLbCond1)
{
theQueryData.GetEntry(nOffset).eOp=(ScQueryOp)pLb->GetSelectEntryPos();
}
else if ( pLb == &aLbCond2)
{
sal_uInt16 nQ=1+nOffset;
theQueryData.GetEntry(nQ).eOp=(ScQueryOp)pLb->GetSelectEntryPos();
}
else if ( pLb == &aLbCond3)
{
sal_uInt16 nQ=2+nOffset;
theQueryData.GetEntry(nQ).eOp=(ScQueryOp)pLb->GetSelectEntryPos();
}
else
{
sal_uInt16 nQ=3+nOffset;
theQueryData.GetEntry(nQ).eOp=(ScQueryOp)pLb->GetSelectEntryPos();
}
return 0;
}
//----------------------------------------------------------------------------
IMPL_LINK( ScFilterDlg, CheckBoxHdl, CheckBox*, pBox )
{
// Spaltenkoepfe:
// FeldListen: Spaltexx <-> Spaltenkopf-String
// WertListen: Spaltenkopf-Wert entfaellt.
// Gross-/Kleinschreibung:
// WertListen: komplett neu
if ( pBox == &aBtnHeader ) // Feldlisten und Wertlisten
{
sal_uInt16 nCurSel1 = aLbField1.GetSelectEntryPos();
sal_uInt16 nCurSel2 = aLbField2.GetSelectEntryPos();
sal_uInt16 nCurSel3 = aLbField3.GetSelectEntryPos();
sal_uInt16 nCurSel4 = aLbField4.GetSelectEntryPos();
FillFieldLists();
aLbField1.SelectEntryPos( nCurSel1 );
aLbField2.SelectEntryPos( nCurSel2 );
aLbField3.SelectEntryPos( nCurSel3 );
aLbField4.SelectEntryPos( nCurSel4 );
UpdateHdrInValueList( 1 );
UpdateHdrInValueList( 2 );
UpdateHdrInValueList( 3 );
UpdateHdrInValueList( 4 );
}
if ( pBox == &aBtnCase ) // Wertlisten komplett
{
for (sal_uInt16 i=0; i<=MAXCOL; i++)
DELETEZ( pEntryLists[i] );
UpdateValueList( 1 ); // aktueller Text wird gemerkt
UpdateValueList( 2 );
UpdateValueList( 3 );
UpdateValueList( 4 );
}
return 0;
}
//----------------------------------------------------------------------------
IMPL_LINK( ScFilterDlg, ValModifyHdl, ComboBox*, pEd )
{
sal_uInt16 nOffset = GetSliderPos();
sal_uInt16 i=0;
sal_uInt16 nQE =i + nOffset;
if ( pEd )
{
String aStrVal = pEd->GetText();
ListBox* pLbCond = &aLbCond1;
ListBox* pLbField = &aLbField1;
if ( pEd == &aEdVal2 )
{
pLbCond = &aLbCond2;
pLbField = &aLbField2;
i=1;
nQE=i+nOffset;
}
if ( pEd == &aEdVal3 )
{
pLbCond = &aLbCond3;
pLbField = &aLbField3;
i=2;
nQE=i+nOffset;
}
if ( pEd == &aEdVal4 )
{
pLbCond = &aLbCond4;
pLbField = &aLbField4;
i=3;
nQE=i+nOffset;
}
if ( aStrEmpty == aStrVal || aStrNotEmpty == aStrVal )
{
pLbCond->SelectEntry( '=' );
pLbCond->Disable();
}
else
pLbCond->Enable();
ScQueryEntry& rEntry = theQueryData.GetEntry( nQE );
sal_Bool bDoThis = (pLbField->GetSelectEntryPos() != 0);
rEntry.bDoQuery = bDoThis;
if ( rEntry.bDoQuery || bRefreshExceptQuery[nQE] )
{
if ( aStrVal == aStrEmpty )
{
rEntry.pStr->Erase();
rEntry.nVal = SC_EMPTYFIELDS;
rEntry.bQueryByString = sal_False;
}
else if ( aStrVal == aStrNotEmpty )
{
rEntry.pStr->Erase();
rEntry.nVal = SC_NONEMPTYFIELDS;
rEntry.bQueryByString = sal_False;
}
else
{
*rEntry.pStr = aStrVal;
rEntry.nVal = 0;
rEntry.bQueryByString = sal_True;
}
sal_uInt16 nField = pLbField->GetSelectEntryPos();
rEntry.nField = nField ? (theQueryData.nCol1 +
static_cast<SCCOL>(nField) - 1) : static_cast<SCCOL>(0);
ScQueryOp eOp = (ScQueryOp)pLbCond->GetSelectEntryPos();
rEntry.eOp = eOp;
rEntry.bQueryByDate = mbHasDates[nQE];
}
}
return 0;
}
//----------------------------------------------------------------------------
IMPL_LINK( ScFilterDlg, ScrollHdl, ScrollBar*, EMPTYARG )
{
SliderMoved();
return 0;
}
void ScFilterDlg::SliderMoved()
{
sal_uInt16 nOffset = GetSliderPos();
RefreshEditRow( nOffset);
}
sal_uInt16 ScFilterDlg::GetSliderPos()
{
return (sal_uInt16) aScrollBar.GetThumbPos();
}
void ScFilterDlg::RefreshEditRow( sal_uInt16 nOffset )
{
if (nOffset==0)
aConnLbArr[0]->Hide();
else
aConnLbArr[0]->Show();
for ( sal_uInt16 i=0; i<4; i++ )
{
String aValStr;
sal_uInt16 nCondPos = 0;
sal_uInt16 nFieldSelPos = 0;
sal_uInt16 nQE = i+nOffset;
ScQueryEntry& rEntry = theQueryData.GetEntry( nQE);
if ( rEntry.bDoQuery || bRefreshExceptQuery[nQE] )
{
nCondPos = (sal_uInt16)rEntry.eOp;
if(rEntry.bDoQuery)
nFieldSelPos = GetFieldSelPos( static_cast<SCCOL>(rEntry.nField) );
if ( rEntry.nVal == SC_EMPTYFIELDS && !rEntry.bQueryByString && *rEntry.pStr == EMPTY_STRING )
{
aValStr = aStrEmpty;
aCondLbArr[i]->Disable();
}
else if ( rEntry.nVal == SC_NONEMPTYFIELDS && !rEntry.bQueryByString && *rEntry.pStr == EMPTY_STRING )
{
aValStr = aStrNotEmpty;
aCondLbArr[i]->Disable();
}
else
{
aValStr = *rEntry.pStr;
aCondLbArr[i]->Enable();
}
aFieldLbArr[i]->Enable();
aValueEdArr[i]->Enable();
if (nOffset==0)
{
if (i<3)
{
if(rEntry.bDoQuery)
aConnLbArr[i+1]->Enable();
else
aConnLbArr[i+1]->Disable();
sal_uInt16 nQENext = nQE+1;
if(theQueryData.GetEntry(nQENext).bDoQuery || bRefreshExceptQuery[nQENext])
aConnLbArr[i+1]->SelectEntryPos( (sal_uInt16) theQueryData.GetEntry(nQENext).eConnect );
else
aConnLbArr[i+1]->SetNoSelection();
}
}
else
{
if(theQueryData.GetEntry( nQE-1).bDoQuery)
aConnLbArr[i]->Enable();
else
aConnLbArr[i]->Disable();
if(rEntry.bDoQuery || bRefreshExceptQuery[nQE])
aConnLbArr[i]->SelectEntryPos( (sal_uInt16) rEntry.eConnect );
else
aConnLbArr[i]->SetNoSelection();
}
}
else
{
if (nOffset==0)
{
if(i<3)
{
aConnLbArr[i+1]->SetNoSelection();
aConnLbArr[i+1]->Disable();
}
}
else
{
if(theQueryData.GetEntry( nQE-1).bDoQuery)
aConnLbArr[i]->Enable();
else
aConnLbArr[i]->Disable();
aConnLbArr[i]->SetNoSelection();
}
aFieldLbArr[i]->Disable();
aCondLbArr[i]->Disable();
aValueEdArr[i]->Disable();
}
aFieldLbArr[i]->SelectEntryPos( nFieldSelPos );
aCondLbArr [i]->SelectEntryPos( nCondPos );
aValueEdArr[i]->SetText( aValStr );
UpdateValueList( static_cast<sal_uInt16>(i+1) );
}
}