244 lines
8.5 KiB
C++
244 lines
8.5 KiB
C++
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
|
|
/*
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*
|
|
* This file incorporates work covered by the following license notice:
|
|
*
|
|
* 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 .
|
|
*/
|
|
|
|
#pragma once
|
|
|
|
#include <address.hxx>
|
|
#include "anyrefdg.hxx"
|
|
#include <queryparam.hxx>
|
|
#include <filterentries.hxx>
|
|
#include <queryentry.hxx>
|
|
|
|
#include <memory>
|
|
#include <deque>
|
|
#include <vector>
|
|
#include <map>
|
|
|
|
class ScFilterOptionsMgr;
|
|
class ScViewData;
|
|
class ScDocument;
|
|
class ScQueryItem;
|
|
|
|
class ScFilterDlg : public ScAnyRefDlgController
|
|
{
|
|
struct EntryList
|
|
{
|
|
ScFilterEntries maFilterEntries;
|
|
size_t mnHeaderPos;
|
|
|
|
EntryList(const EntryList&) = delete;
|
|
const EntryList& operator=(const EntryList&) = delete;
|
|
|
|
EntryList();
|
|
};
|
|
typedef std::map<SCCOL, std::unique_ptr<EntryList>> EntryListsMap;
|
|
public:
|
|
ScFilterDlg(SfxBindings* pB, SfxChildWindow* pCW, weld::Window* pParent,
|
|
const SfxItemSet& rArgSet);
|
|
virtual ~ScFilterDlg() override;
|
|
|
|
virtual void SetReference( const ScRange& rRef, ScDocument& rDoc ) override;
|
|
|
|
virtual bool IsRefInputMode() const override;
|
|
virtual void SetActive() override;
|
|
|
|
virtual void Close() override;
|
|
void SliderMoved();
|
|
size_t GetSliderPos() const;
|
|
void RefreshEditRow( size_t nOffset );
|
|
|
|
private:
|
|
const OUString aStrUndefined;
|
|
const OUString aStrNone;
|
|
|
|
const OUString aStrEmpty;
|
|
const OUString aStrNotEmpty;
|
|
const OUString aStrColumn;
|
|
const OUString aStrFontColor;
|
|
const OUString aStrBackgroundColor;
|
|
|
|
std::unique_ptr<ScFilterOptionsMgr> pOptionsMgr;
|
|
|
|
const sal_uInt16 nWhichQuery;
|
|
ScQueryParam theQueryData;
|
|
std::unique_ptr<ScQueryItem> pOutItem;
|
|
ScViewData* pViewData;
|
|
ScDocument* pDoc;
|
|
SCTAB nSrcTab;
|
|
|
|
std::vector<weld::ComboBox*> maValueEdArr;
|
|
std::vector<weld::ComboBox*> maFieldLbArr;
|
|
std::vector<weld::ComboBox*> maCondLbArr;
|
|
std::vector<weld::ComboBox*> maConnLbArr;
|
|
std::vector<weld::ComboBox*> maColorLbArr;
|
|
std::vector<weld::Button*> maRemoveBtnArr;
|
|
|
|
std::deque<bool> maHasDates;
|
|
std::deque<bool> maRefreshExceptQuery;
|
|
bool bRefInputMode;
|
|
|
|
EntryListsMap m_EntryLists;
|
|
|
|
// Hack: RefInput control
|
|
std::unique_ptr<Timer> pTimer;
|
|
|
|
std::unique_ptr<weld::ComboBox> m_xLbConnect1;
|
|
std::unique_ptr<weld::ComboBox> m_xLbField1;
|
|
std::unique_ptr<weld::ComboBox> m_xLbCond1;
|
|
std::unique_ptr<weld::ComboBox> m_xEdVal1;
|
|
std::unique_ptr<weld::ComboBox> m_xLbColor1;
|
|
std::unique_ptr<weld::Button> m_xBtnRemove1;
|
|
|
|
std::unique_ptr<weld::ComboBox> m_xLbConnect2;
|
|
std::unique_ptr<weld::ComboBox> m_xLbField2;
|
|
std::unique_ptr<weld::ComboBox> m_xLbCond2;
|
|
std::unique_ptr<weld::ComboBox> m_xEdVal2;
|
|
std::unique_ptr<weld::ComboBox> m_xLbColor2;
|
|
std::unique_ptr<weld::Button> m_xBtnRemove2;
|
|
|
|
std::unique_ptr<weld::ComboBox> m_xLbConnect3;
|
|
std::unique_ptr<weld::ComboBox> m_xLbField3;
|
|
std::unique_ptr<weld::ComboBox> m_xLbCond3;
|
|
std::unique_ptr<weld::ComboBox> m_xEdVal3;
|
|
std::unique_ptr<weld::ComboBox> m_xLbColor3;
|
|
std::unique_ptr<weld::Button> m_xBtnRemove3;
|
|
|
|
std::unique_ptr<weld::ComboBox> m_xLbConnect4;
|
|
std::unique_ptr<weld::ComboBox> m_xLbField4;
|
|
std::unique_ptr<weld::ComboBox> m_xLbCond4;
|
|
std::unique_ptr<weld::ComboBox> m_xEdVal4;
|
|
std::unique_ptr<weld::ComboBox> m_xLbColor4;
|
|
std::unique_ptr<weld::Button> m_xBtnRemove4;
|
|
|
|
std::unique_ptr<weld::Widget> m_xContents;
|
|
std::unique_ptr<weld::ScrolledWindow> m_xScrollBar;
|
|
std::unique_ptr<weld::Expander> m_xExpander;
|
|
|
|
std::unique_ptr<weld::Button> m_xBtnClear;
|
|
std::unique_ptr<weld::Button> m_xBtnOk;
|
|
std::unique_ptr<weld::Button> m_xBtnCancel;
|
|
|
|
std::unique_ptr<weld::CheckButton> m_xBtnCase;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnRegExp;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnHeader;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnUnique;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnCopyResult;
|
|
std::unique_ptr<weld::ComboBox> m_xLbCopyArea;
|
|
std::unique_ptr<formula::RefEdit> m_xEdCopyArea;
|
|
std::unique_ptr<formula::RefButton> m_xRbCopyArea;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnDestPers;
|
|
std::unique_ptr<weld::Label> m_xFtDbAreaLabel;
|
|
std::unique_ptr<weld::Label> m_xFtDbArea;
|
|
|
|
private:
|
|
void Init ( const SfxItemSet& rArgSet );
|
|
void FillFieldLists ();
|
|
void UpdateValueList ( size_t nList );
|
|
void UpdateHdrInValueList( size_t nList );
|
|
void ClearValueList ( size_t nList );
|
|
void UpdateColorList ( size_t nList );
|
|
size_t GetFieldSelPos ( SCCOL nField );
|
|
ScQueryItem* GetOutputItem ();
|
|
void SetValString ( const OUString& rQueryStr,
|
|
const ScQueryEntry::Item& rItem,
|
|
OUString& rValStr );
|
|
|
|
// Handler:
|
|
DECL_LINK( LbSelectHdl, weld::ComboBox&, void );
|
|
DECL_LINK( ValModifyHdl, weld::ComboBox&, void );
|
|
DECL_LINK( CheckBoxHdl, weld::Toggleable&, void );
|
|
DECL_LINK( BtnClearHdl, weld::Button&, void );
|
|
DECL_LINK( BtnRemoveHdl, weld::Button&, void );
|
|
DECL_LINK( EndDlgHdl, weld::Button&, void );
|
|
DECL_LINK( ScrollHdl, weld::ScrolledWindow&, void );
|
|
DECL_LINK( MoreExpandedHdl, weld::Expander&, void );
|
|
|
|
// Hack: RefInput control
|
|
DECL_LINK( TimeOutHdl, Timer*, void );
|
|
};
|
|
|
|
class ScSpecialFilterDlg : public ScAnyRefDlgController
|
|
{
|
|
public:
|
|
ScSpecialFilterDlg(SfxBindings* pB, SfxChildWindow* pCW, weld::Window* pParent,
|
|
const SfxItemSet& rArgSet);
|
|
virtual ~ScSpecialFilterDlg() override;
|
|
|
|
virtual void SetReference( const ScRange& rRef, ScDocument& rDoc ) override;
|
|
|
|
virtual bool IsRefInputMode() const override;
|
|
virtual void SetActive() override;
|
|
|
|
virtual void Close() override;
|
|
|
|
private:
|
|
const OUString aStrUndefined;
|
|
|
|
std::unique_ptr<ScFilterOptionsMgr> pOptionsMgr;
|
|
|
|
const sal_uInt16 nWhichQuery;
|
|
const ScQueryParam theQueryData;
|
|
std::unique_ptr<ScQueryItem> pOutItem;
|
|
ScViewData* pViewData;
|
|
ScDocument* pDoc;
|
|
|
|
bool bRefInputMode;
|
|
|
|
formula::RefEdit* m_pRefInputEdit;
|
|
|
|
std::unique_ptr<weld::ComboBox> m_xLbFilterArea;
|
|
std::unique_ptr<formula::RefEdit> m_xEdFilterArea;
|
|
std::unique_ptr<formula::RefButton> m_xRbFilterArea;
|
|
|
|
std::unique_ptr<weld::Expander> m_xExpander;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnCase;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnRegExp;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnHeader;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnUnique;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnCopyResult;
|
|
std::unique_ptr<weld::ComboBox> m_xLbCopyArea;
|
|
std::unique_ptr<formula::RefEdit> m_xEdCopyArea;
|
|
std::unique_ptr<formula::RefButton> m_xRbCopyArea;
|
|
std::unique_ptr<weld::CheckButton> m_xBtnDestPers;
|
|
std::unique_ptr<weld::Label> m_xFtDbAreaLabel;
|
|
std::unique_ptr<weld::Label> m_xFtDbArea;
|
|
|
|
std::unique_ptr<weld::Button> m_xBtnOk;
|
|
std::unique_ptr<weld::Button> m_xBtnCancel;
|
|
|
|
std::unique_ptr<weld::Frame> m_xFilterFrame;
|
|
std::unique_ptr<weld::Label> m_xFilterLabel;
|
|
|
|
private:
|
|
void Init( const SfxItemSet& rArgSet );
|
|
ScQueryItem* GetOutputItem( const ScQueryParam& rParam,
|
|
const ScRange& rSource );
|
|
|
|
// Handler
|
|
DECL_LINK( FilterAreaSelHdl, weld::ComboBox&, void );
|
|
DECL_LINK( FilterAreaModHdl, formula::RefEdit&, void );
|
|
DECL_LINK( EndDlgHdl, weld::Button&, void );
|
|
|
|
// RefInput control
|
|
DECL_LINK( RefInputEditHdl, formula::RefEdit&, void );
|
|
DECL_LINK( RefInputButtonHdl, formula::RefButton&, void );
|
|
void RefInputHdl();
|
|
};
|
|
|
|
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|