1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
/* -*- 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 .
*/
#ifndef INCLUDED_DBACCESS_SOURCE_UI_INC_QUERYFILTER_HXX
#define INCLUDED_DBACCESS_SOURCE_UI_INC_QUERYFILTER_HXX
#include <vcl/dialog.hxx>
#include <vcl/lstbox.hxx>
#include <vcl/edit.hxx>
#include <vcl/fixed.hxx>
#include <vcl/button.hxx>
#include <connectivity/sqliterator.hxx>
#include <connectivity/predicateinput.hxx>
#include "svx/ParseContext.hxx"
namespace com
{
namespace sun
{
namespace star
{
namespace sdb
{
class XSingleSelectQueryComposer;
}
namespace sdbc
{
class XConnection;
class XDatabaseMetaData;
}
namespace container
{
class XNameAccess;
}
namespace beans
{
struct PropertyValue;
}
}
}
}
// DlgFilterCrit
namespace dbaui
{
class DlgFilterCrit :public ModalDialog
,public ::svxform::OParseContextClient
{
private:
ListBox aLB_WHEREFIELD1;
ListBox aLB_WHERECOMP1;
Edit aET_WHEREVALUE1;
ListBox aLB_WHERECOND2;
ListBox aLB_WHEREFIELD2;
ListBox aLB_WHERECOMP2;
Edit aET_WHEREVALUE2;
ListBox aLB_WHERECOND3;
ListBox aLB_WHEREFIELD3;
ListBox aLB_WHERECOMP3;
Edit aET_WHEREVALUE3;
FixedText aFT_WHEREFIELD;
FixedText aFT_WHERECOMP;
FixedText aFT_WHEREVALUE;
FixedText aFT_WHEREOPER;
FixedLine aFL_FIELDS;
OKButton aBT_OK;
CancelButton aBT_CANCEL;
HelpButton aBT_HELP;
OUString aSTR_NOENTRY;
OUString aSTR_COMPARE_OPERATORS;
::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSingleSelectQueryComposer> m_xQueryComposer;
::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess> m_xColumns;
::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection> m_xConnection;
::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData> m_xMetaData;
::dbtools::OPredicateInputController m_aPredicateInput;
void SelectField( ListBox& rBox, const OUString& rField );
DECL_LINK( ListSelectHdl, ListBox * );
DECL_LINK( ListSelectCompHdl, ListBox * );
void SetLine( sal_uInt16 nIdx,const ::com::sun::star::beans::PropertyValue& _rItem,sal_Bool _bOr );
void EnableLines();
sal_Int32 GetOSQLPredicateType( const OUString& _rSelectedPredicate ) const;
sal_uInt16 GetSelectionPos(sal_Int32 eType,const ListBox& rListBox) const;
sal_Bool getCondition(const ListBox& _rField,const ListBox& _rComp,const Edit& _rValue,::com::sun::star::beans::PropertyValue& _rFilter) const;
void fillLines(const ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue > >& _aValues);
::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > getMatchingColumn( const Edit& _rValueInput ) const;
::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > getColumn( const OUString& _rFieldName ) const;
::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > getQueryColumn( const OUString& _rFieldName ) const;
public:
DlgFilterCrit( Window * pParent,
const ::com::sun::star::uno::Reference< ::com::sun::star::uno::XComponentContext >& rxContext,
const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection>& _rxConnection,
const ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSingleSelectQueryComposer>& _rxComposer,
const ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>& _rxCols
);
~DlgFilterCrit();
void BuildWherePart();
protected:
DECL_LINK( PredicateLoseFocus, Edit* );
};
}
#endif // INCLUDED_DBACCESS_SOURCE_UI_INC_QUERYFILTER_HXX
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|