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
134
135
136
137
138
139
140
|
/* -*- 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 DBAUI_QUERYFILTER_HXX
#define DBAUI_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 rtl
{
class OUString;
}
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;
String aSTR_NOENTRY;
String 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 String& 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 String& _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 // DBAUI_QUERYFILTER_HXX
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|