autofilterbuffer.hxx

Go to the documentation of this file.

/* -*- 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 <oox/helper/helper.hxx>
#include <oox/helper/refvector.hxx>
#include "workbookhelper.hxx"
#include <com/sun/star/sheet/TableFilterField3.hpp>
#include <com/sun/star/util/Color.hpp>
 
namespace com::sun::star {
    namespace sheet { class XDatabaseRange; }
    namespace sheet { class XSheetFilterDescriptor3; }
}
 
namespace oox { class AttributeList; }
namespace oox { class SequenceInputStream; }
 
namespace oox {
namespace xls {
 
struct ApiFilterSettings
{
    typedef ::std::vector<css::sheet::TableFilterField3> FilterFieldVector;
 
    FilterFieldVector   maFilterFields;     
    std::optional< bool > mobNeedsRegExp;     
 
    explicit            ApiFilterSettings();
 
    void appendField( bool bAnd, sal_Int32 nOperator, double fValue );
    void appendField( bool bAnd, sal_Int32 nOperator, const OUString& rValue );
    void appendField( bool bAnd, css::util::Color aColor, bool bIsBackgroundColor );
    void appendField( bool bAnd, const std::vector<std::pair<OUString, bool>>& rValues );
};
 
class FilterSettingsBase : public WorkbookHelper
{
public:
    explicit            FilterSettingsBase( const WorkbookHelper& rHelper );
 
    virtual void        importAttribs( sal_Int32 nElement, const AttributeList& rAttribs );
    virtual void        importRecord( sal_Int32 nRecId, SequenceInputStream& rStrm );
 
    virtual ApiFilterSettings finalizeImport();
};
 
 
class DiscreteFilter final : public FilterSettingsBase
{
public:
    explicit            DiscreteFilter( const WorkbookHelper& rHelper );
 
    virtual void        importAttribs( sal_Int32 nElement, const AttributeList& rAttribs ) override;
    virtual void        importRecord( sal_Int32 nRecId, SequenceInputStream& rStrm ) override;
 
    virtual ApiFilterSettings finalizeImport() override;
 
private:
 
    std::vector<std::pair<OUString, bool>> maValues; // first->values, second->bDatefFormat
    sal_Int32           mnCalendarType;
    bool                mbShowBlank;
};
 
class Top10Filter final : public FilterSettingsBase
{
public:
    explicit            Top10Filter( const WorkbookHelper& rHelper );
 
    virtual void        importAttribs( sal_Int32 nElement, const AttributeList& rAttribs ) override;
    virtual void        importRecord( sal_Int32 nRecId, SequenceInputStream& rStrm ) override;
 
    virtual ApiFilterSettings finalizeImport() override;
 
private:
    double              mfValue;        
    bool                mbTop;          
    bool                mbPercent;      
};
 
class ColorFilter final : public FilterSettingsBase
{
public:
    explicit ColorFilter(const WorkbookHelper& rHelper);
 
    virtual void importAttribs(sal_Int32 nElement, const AttributeList& rAttribs) override;
    virtual void importRecord(sal_Int32 nRecId, SequenceInputStream& rStrm) override;
 
    virtual ApiFilterSettings finalizeImport() override;
 
private:
    bool mbIsBackgroundColor;
    OUString msStyleName;
};
 
struct FilterCriterionModel
{
    css::uno::Any       maValue; 
    sal_Int32           mnOperator;     
    sal_uInt8           mnDataType;     
 
    explicit            FilterCriterionModel();
 
    void                setBiffOperator( sal_uInt8 nOperator );
 
    void                readBiffData( SequenceInputStream& rStrm );
};
 
class CustomFilter final : public FilterSettingsBase
{
public:
    explicit            CustomFilter( const WorkbookHelper& rHelper );
 
    virtual void        importAttribs( sal_Int32 nElement, const AttributeList& rAttribs ) override;
    virtual void        importRecord( sal_Int32 nRecId, SequenceInputStream& rStrm ) override;
 
    virtual ApiFilterSettings finalizeImport() override;
 
private:
    void                appendCriterion( const FilterCriterionModel& rCriterion );
 
private:
    typedef ::std::vector< FilterCriterionModel > FilterCriterionVector;
 
    FilterCriterionVector maCriteria;
    bool                mbAnd;
};
 
class FilterColumn final : public WorkbookHelper
{
public:
    explicit            FilterColumn( const WorkbookHelper& rHelper );
 
    void                importFilterColumn( const AttributeList& rAttribs );
    void                importFilterColumn( SequenceInputStream& rStrm );
 
    template< typename FilterSettingsType >
    FilterSettingsBase& createFilterSettings()
        { mxSettings = std::make_shared<FilterSettingsType>( *this ); return *mxSettings; }
 
    ApiFilterSettings   finalizeImport();
 
private:
    std::shared_ptr< FilterSettingsBase >
                        mxSettings;
    sal_Int32           mnColId;
    bool                mbHiddenButton;
    bool                mbShowButton;
};
 
// class SortCondition
 
class SortCondition final : public WorkbookHelper
{
public:
    explicit SortCondition( const WorkbookHelper& rHelper );
 
    void importSortCondition( const AttributeList& rAttribs, sal_Int16 nSheet );
 
    ScRange maRange; // Column/Row that this sort condition applies to.
    OUString maSortCustomList; // Sort by a custom list.
    bool mbDescending;
};
 
// class AutoFilter
 
class AutoFilter final : public WorkbookHelper
{
public:
    explicit            AutoFilter( const WorkbookHelper& rHelper );
 
    void                importAutoFilter( const AttributeList& rAttribs, sal_Int16 nSheet );
    void                importAutoFilter( SequenceInputStream& rStrm, sal_Int16 nSheet );
 
    void                importSortState( const AttributeList& rAttribs, sal_Int16 nSheet );
 
    FilterColumn&       createFilterColumn();
 
    SortCondition&      createSortCondition();
 
    void                finalizeImport( const css::uno::Reference< css::sheet::XDatabaseRange >& rxDatabaseRange,
                                        sal_Int16 nSheet );
 
private:
    typedef RefVector< FilterColumn > FilterColumnVector;
 
    FilterColumnVector  maFilterColumns;
    ScRange             maRange;
 
    ScRange maSortRange; // The whole range of data to sort (not just the sort-by column).
    typedef RefVector< SortCondition > SortConditionVector;
    SortConditionVector maSortConditions;
};
 
class AutoFilterBuffer final : public WorkbookHelper
{
public:
    explicit            AutoFilterBuffer( const WorkbookHelper& rHelper );
 
    AutoFilter&         createAutoFilter();
 
    void                finalizeImport( sal_Int16 nSheet );
 
    bool                finalizeImport( const css::uno::Reference< css::sheet::XDatabaseRange >& rxDatabaseRange,
                                        sal_Int16 nSheet );
 
private:
    AutoFilter*         getActiveAutoFilter();
 
private:
    typedef RefVector< AutoFilter > AutoFilterVector;
    AutoFilterVector    maAutoFilters;
};
 
} // namespace xls
} // namespace oox
 
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */