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;     
    OptValue< 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 : 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 : 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 : 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 : 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 : 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 : 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 : 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 : 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: */