1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_svx.hxx"
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski #include "tabwin.hxx"
28*b1cdbd2cSJim Jagielski #include "svx/fmtools.hxx"
29*b1cdbd2cSJim Jagielski #include "fmservs.hxx"
30*b1cdbd2cSJim Jagielski #include "stringlistresource.hxx"
31*b1cdbd2cSJim Jagielski
32*b1cdbd2cSJim Jagielski #include <svx/svxids.hrc>
33*b1cdbd2cSJim Jagielski #include <svx/dbaexchange.hxx>
34*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/CommandType.hpp>
35*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
36*b1cdbd2cSJim Jagielski #include <com/sun/star/sdb/XQueriesSupplier.hpp>
37*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XPreparedStatement.hpp>
38*b1cdbd2cSJim Jagielski #include <com/sun/star/awt/XControlContainer.hpp>
39*b1cdbd2cSJim Jagielski #include <com/sun/star/util/XLocalizedAliases.hpp>
40*b1cdbd2cSJim Jagielski #include <comphelper/processfactory.hxx>
41*b1cdbd2cSJim Jagielski #include <comphelper/stl_types.hxx>
42*b1cdbd2cSJim Jagielski
43*b1cdbd2cSJim Jagielski #ifndef _SVX_FMHELP_HRC
44*b1cdbd2cSJim Jagielski #include "fmhelp.hrc"
45*b1cdbd2cSJim Jagielski #endif
46*b1cdbd2cSJim Jagielski #include <svx/fmshell.hxx>
47*b1cdbd2cSJim Jagielski #include "fmshimp.hxx"
48*b1cdbd2cSJim Jagielski #include "svx/dbtoolsclient.hxx"
49*b1cdbd2cSJim Jagielski #include <svx/fmpage.hxx>
50*b1cdbd2cSJim Jagielski
51*b1cdbd2cSJim Jagielski #ifndef _SVX_FMPGEIMP_HXX
52*b1cdbd2cSJim Jagielski #include "fmpgeimp.hxx"
53*b1cdbd2cSJim Jagielski #endif
54*b1cdbd2cSJim Jagielski
55*b1cdbd2cSJim Jagielski #ifndef _SVX_FMPROP_HRC
56*b1cdbd2cSJim Jagielski #include "fmprop.hrc"
57*b1cdbd2cSJim Jagielski #endif
58*b1cdbd2cSJim Jagielski
59*b1cdbd2cSJim Jagielski #ifndef _SVX_FMRESIDS_HRC
60*b1cdbd2cSJim Jagielski #include "svx/fmresids.hrc"
61*b1cdbd2cSJim Jagielski #endif
62*b1cdbd2cSJim Jagielski #include <svx/dialmgr.hxx>
63*b1cdbd2cSJim Jagielski #include <tools/shl.hxx>
64*b1cdbd2cSJim Jagielski #include <svx/svdpagv.hxx>
65*b1cdbd2cSJim Jagielski #include <sfx2/objitem.hxx>
66*b1cdbd2cSJim Jagielski #include <sfx2/dispatch.hxx>
67*b1cdbd2cSJim Jagielski #include <comphelper/property.hxx>
68*b1cdbd2cSJim Jagielski #include <sfx2/frame.hxx>
69*b1cdbd2cSJim Jagielski #include <svx/dataaccessdescriptor.hxx>
70*b1cdbd2cSJim Jagielski
71*b1cdbd2cSJim Jagielski const long STD_WIN_POS_X = 50;
72*b1cdbd2cSJim Jagielski const long STD_WIN_POS_Y = 50;
73*b1cdbd2cSJim Jagielski
74*b1cdbd2cSJim Jagielski const long STD_WIN_SIZE_X = 120;
75*b1cdbd2cSJim Jagielski const long STD_WIN_SIZE_Y = 150;
76*b1cdbd2cSJim Jagielski
77*b1cdbd2cSJim Jagielski const long MIN_WIN_SIZE_X = 50;
78*b1cdbd2cSJim Jagielski const long MIN_WIN_SIZE_Y = 50;
79*b1cdbd2cSJim Jagielski
80*b1cdbd2cSJim Jagielski const long LISTBOX_BORDER = 2;
81*b1cdbd2cSJim Jagielski
82*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbc;
83*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdb;
84*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
85*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::datatransfer;
86*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::beans;
87*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::lang;
88*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::form;
89*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::container;
90*b1cdbd2cSJim Jagielski using namespace ::com::sun::star;
91*b1cdbd2cSJim Jagielski using namespace ::svxform;
92*b1cdbd2cSJim Jagielski using namespace ::svx;
93*b1cdbd2cSJim Jagielski
94*b1cdbd2cSJim Jagielski
95*b1cdbd2cSJim Jagielski struct ColumnInfo
96*b1cdbd2cSJim Jagielski {
97*b1cdbd2cSJim Jagielski ::rtl::OUString sColumnName;
98*b1cdbd2cSJim Jagielski ::rtl::OUString sLabel;
99*b1cdbd2cSJim Jagielski bool bColumn;
ColumnInfoColumnInfo100*b1cdbd2cSJim Jagielski ColumnInfo(const ::rtl::OUString& i_sColumnName,const ::rtl::OUString& i_sLabel)
101*b1cdbd2cSJim Jagielski : sColumnName(i_sColumnName)
102*b1cdbd2cSJim Jagielski , sLabel(i_sLabel)
103*b1cdbd2cSJim Jagielski , bColumn(true)
104*b1cdbd2cSJim Jagielski {
105*b1cdbd2cSJim Jagielski }
ColumnInfoColumnInfo106*b1cdbd2cSJim Jagielski ColumnInfo(const ::rtl::OUString& i_sColumnName)
107*b1cdbd2cSJim Jagielski : sColumnName(i_sColumnName)
108*b1cdbd2cSJim Jagielski , bColumn(false)
109*b1cdbd2cSJim Jagielski {
110*b1cdbd2cSJim Jagielski }
111*b1cdbd2cSJim Jagielski };
112*b1cdbd2cSJim Jagielski
lcl_addToList(SvTreeListBox & _rListBox,const uno::Reference<container::XNameAccess> & i_xColumns)113*b1cdbd2cSJim Jagielski void lcl_addToList( SvTreeListBox& _rListBox, const uno::Reference< container::XNameAccess>& i_xColumns )
114*b1cdbd2cSJim Jagielski {
115*b1cdbd2cSJim Jagielski uno::Sequence< ::rtl::OUString > aEntries = i_xColumns->getElementNames();
116*b1cdbd2cSJim Jagielski const ::rtl::OUString* pEntries = aEntries.getConstArray();
117*b1cdbd2cSJim Jagielski sal_Int32 nEntries = aEntries.getLength();
118*b1cdbd2cSJim Jagielski for ( sal_Int32 i = 0; i < nEntries; ++i, ++pEntries )
119*b1cdbd2cSJim Jagielski {
120*b1cdbd2cSJim Jagielski uno::Reference< beans::XPropertySet> xColumn(i_xColumns->getByName(*pEntries),UNO_QUERY_THROW);
121*b1cdbd2cSJim Jagielski ::rtl::OUString sLabel;
122*b1cdbd2cSJim Jagielski if ( xColumn->getPropertySetInfo()->hasPropertyByName(FM_PROP_LABEL) )
123*b1cdbd2cSJim Jagielski xColumn->getPropertyValue(FM_PROP_LABEL) >>= sLabel;
124*b1cdbd2cSJim Jagielski if ( sLabel.getLength() )
125*b1cdbd2cSJim Jagielski _rListBox.InsertEntry( sLabel,NULL,sal_False,LIST_APPEND,new ColumnInfo(*pEntries,sLabel) );
126*b1cdbd2cSJim Jagielski else
127*b1cdbd2cSJim Jagielski _rListBox.InsertEntry( *pEntries,NULL,sal_False,LIST_APPEND,new ColumnInfo(*pEntries,sLabel) );
128*b1cdbd2cSJim Jagielski }
129*b1cdbd2cSJim Jagielski }
130*b1cdbd2cSJim Jagielski //==================================================================
131*b1cdbd2cSJim Jagielski // class FmFieldWinListBox
132*b1cdbd2cSJim Jagielski //==================================================================
DBG_NAME(FmFieldWinListBox)133*b1cdbd2cSJim Jagielski DBG_NAME(FmFieldWinListBox)
134*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
135*b1cdbd2cSJim Jagielski FmFieldWinListBox::FmFieldWinListBox( FmFieldWin* pParent )
136*b1cdbd2cSJim Jagielski :SvTreeListBox( pParent, WB_HASBUTTONS|WB_BORDER )
137*b1cdbd2cSJim Jagielski ,pTabWin( pParent )
138*b1cdbd2cSJim Jagielski {
139*b1cdbd2cSJim Jagielski DBG_CTOR(FmFieldWinListBox,NULL);
140*b1cdbd2cSJim Jagielski SetHelpId( HID_FIELD_SEL );
141*b1cdbd2cSJim Jagielski
142*b1cdbd2cSJim Jagielski SetHighlightRange( );
143*b1cdbd2cSJim Jagielski }
144*b1cdbd2cSJim Jagielski
145*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
~FmFieldWinListBox()146*b1cdbd2cSJim Jagielski FmFieldWinListBox::~FmFieldWinListBox()
147*b1cdbd2cSJim Jagielski {
148*b1cdbd2cSJim Jagielski DBG_DTOR(FmFieldWinListBox,NULL);
149*b1cdbd2cSJim Jagielski }
150*b1cdbd2cSJim Jagielski
151*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
AcceptDrop(const AcceptDropEvent &)152*b1cdbd2cSJim Jagielski sal_Int8 FmFieldWinListBox::AcceptDrop( const AcceptDropEvent& /*rEvt*/ )
153*b1cdbd2cSJim Jagielski {
154*b1cdbd2cSJim Jagielski return DND_ACTION_NONE;
155*b1cdbd2cSJim Jagielski }
156*b1cdbd2cSJim Jagielski
157*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
ExecuteDrop(const ExecuteDropEvent &)158*b1cdbd2cSJim Jagielski sal_Int8 FmFieldWinListBox::ExecuteDrop( const ExecuteDropEvent& /*rEvt*/ )
159*b1cdbd2cSJim Jagielski {
160*b1cdbd2cSJim Jagielski return DND_ACTION_NONE;
161*b1cdbd2cSJim Jagielski }
162*b1cdbd2cSJim Jagielski
163*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
DoubleClickHdl()164*b1cdbd2cSJim Jagielski sal_Bool FmFieldWinListBox::DoubleClickHdl()
165*b1cdbd2cSJim Jagielski {
166*b1cdbd2cSJim Jagielski if ( pTabWin->createSelectionControls() )
167*b1cdbd2cSJim Jagielski return sal_True;
168*b1cdbd2cSJim Jagielski
169*b1cdbd2cSJim Jagielski return SvTreeListBox::DoubleClickHdl();
170*b1cdbd2cSJim Jagielski }
171*b1cdbd2cSJim Jagielski
172*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------------
StartDrag(sal_Int8,const Point &)173*b1cdbd2cSJim Jagielski void FmFieldWinListBox::StartDrag( sal_Int8 /*_nAction*/, const Point& /*_rPosPixel*/ )
174*b1cdbd2cSJim Jagielski {
175*b1cdbd2cSJim Jagielski SvLBoxEntry* pSelected = FirstSelected();
176*b1cdbd2cSJim Jagielski if (!pSelected)
177*b1cdbd2cSJim Jagielski // no drag without a field
178*b1cdbd2cSJim Jagielski return;
179*b1cdbd2cSJim Jagielski
180*b1cdbd2cSJim Jagielski ::svx::ODataAccessDescriptor aDescriptor;
181*b1cdbd2cSJim Jagielski aDescriptor[ daDataSource ] <<= pTabWin->GetDatabaseName();
182*b1cdbd2cSJim Jagielski aDescriptor[ daConnection ] <<= pTabWin->GetConnection().getTyped();
183*b1cdbd2cSJim Jagielski aDescriptor[ daCommand ] <<= pTabWin->GetObjectName();
184*b1cdbd2cSJim Jagielski aDescriptor[ daCommandType ]<<= pTabWin->GetObjectType();
185*b1cdbd2cSJim Jagielski ColumnInfo* pInfo = static_cast<ColumnInfo*>(pSelected->GetUserData());
186*b1cdbd2cSJim Jagielski aDescriptor[ daColumnName ] <<= pInfo->sColumnName;
187*b1cdbd2cSJim Jagielski
188*b1cdbd2cSJim Jagielski TransferableHelper* pTransferColumn = new OColumnTransferable(
189*b1cdbd2cSJim Jagielski aDescriptor, CTF_FIELD_DESCRIPTOR | CTF_CONTROL_EXCHANGE | CTF_COLUMN_DESCRIPTOR
190*b1cdbd2cSJim Jagielski );
191*b1cdbd2cSJim Jagielski Reference< XTransferable> xEnsureDelete = pTransferColumn;
192*b1cdbd2cSJim Jagielski if (pTransferColumn)
193*b1cdbd2cSJim Jagielski {
194*b1cdbd2cSJim Jagielski EndSelection();
195*b1cdbd2cSJim Jagielski pTransferColumn->StartDrag( this, DND_ACTION_COPY );
196*b1cdbd2cSJim Jagielski }
197*b1cdbd2cSJim Jagielski }
198*b1cdbd2cSJim Jagielski
199*b1cdbd2cSJim Jagielski //========================================================================
200*b1cdbd2cSJim Jagielski // class FmFieldWinData
201*b1cdbd2cSJim Jagielski //========================================================================
202*b1cdbd2cSJim Jagielski DBG_NAME(FmFieldWinData);
203*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
FmFieldWinData()204*b1cdbd2cSJim Jagielski FmFieldWinData::FmFieldWinData()
205*b1cdbd2cSJim Jagielski {
206*b1cdbd2cSJim Jagielski DBG_CTOR(FmFieldWinData,NULL);
207*b1cdbd2cSJim Jagielski }
208*b1cdbd2cSJim Jagielski
209*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
~FmFieldWinData()210*b1cdbd2cSJim Jagielski FmFieldWinData::~FmFieldWinData()
211*b1cdbd2cSJim Jagielski {
212*b1cdbd2cSJim Jagielski DBG_DTOR(FmFieldWinData,NULL);
213*b1cdbd2cSJim Jagielski }
214*b1cdbd2cSJim Jagielski
215*b1cdbd2cSJim Jagielski //========================================================================
216*b1cdbd2cSJim Jagielski // class FmFieldWin
217*b1cdbd2cSJim Jagielski //========================================================================
218*b1cdbd2cSJim Jagielski DBG_NAME(FmFieldWin);
219*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
FmFieldWin(SfxBindings * _pBindings,SfxChildWindow * _pMgr,Window * _pParent)220*b1cdbd2cSJim Jagielski FmFieldWin::FmFieldWin(SfxBindings* _pBindings, SfxChildWindow* _pMgr, Window* _pParent)
221*b1cdbd2cSJim Jagielski :SfxFloatingWindow(_pBindings, _pMgr, _pParent, WinBits(WB_STDMODELESS|WB_SIZEABLE))
222*b1cdbd2cSJim Jagielski ,SfxControllerItem(SID_FM_FIELDS_CONTROL, *_pBindings)
223*b1cdbd2cSJim Jagielski ,::comphelper::OPropertyChangeListener(m_aMutex)
224*b1cdbd2cSJim Jagielski ,pData(new FmFieldWinData)
225*b1cdbd2cSJim Jagielski ,m_nObjectType(0)
226*b1cdbd2cSJim Jagielski ,m_pChangeListener(NULL)
227*b1cdbd2cSJim Jagielski {
228*b1cdbd2cSJim Jagielski DBG_CTOR(FmFieldWin,NULL);
229*b1cdbd2cSJim Jagielski SetHelpId( HID_FIELD_SEL_WIN );
230*b1cdbd2cSJim Jagielski
231*b1cdbd2cSJim Jagielski SetBackground( Wallpaper( Application::GetSettings().GetStyleSettings().GetFaceColor()) );
232*b1cdbd2cSJim Jagielski pListBox = new FmFieldWinListBox( this );
233*b1cdbd2cSJim Jagielski pListBox->Show();
234*b1cdbd2cSJim Jagielski UpdateContent(NULL);
235*b1cdbd2cSJim Jagielski SetSizePixel(Size(STD_WIN_SIZE_X,STD_WIN_SIZE_Y));
236*b1cdbd2cSJim Jagielski }
237*b1cdbd2cSJim Jagielski
238*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
~FmFieldWin()239*b1cdbd2cSJim Jagielski FmFieldWin::~FmFieldWin()
240*b1cdbd2cSJim Jagielski {
241*b1cdbd2cSJim Jagielski if (m_pChangeListener)
242*b1cdbd2cSJim Jagielski {
243*b1cdbd2cSJim Jagielski m_pChangeListener->dispose();
244*b1cdbd2cSJim Jagielski m_pChangeListener->release();
245*b1cdbd2cSJim Jagielski // delete m_pChangeListener;
246*b1cdbd2cSJim Jagielski }
247*b1cdbd2cSJim Jagielski delete pListBox;
248*b1cdbd2cSJim Jagielski delete pData;
249*b1cdbd2cSJim Jagielski DBG_DTOR(FmFieldWin,NULL);
250*b1cdbd2cSJim Jagielski }
251*b1cdbd2cSJim Jagielski
252*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
GetFocus()253*b1cdbd2cSJim Jagielski void FmFieldWin::GetFocus()
254*b1cdbd2cSJim Jagielski {
255*b1cdbd2cSJim Jagielski if ( pListBox )
256*b1cdbd2cSJim Jagielski pListBox->GrabFocus();
257*b1cdbd2cSJim Jagielski else
258*b1cdbd2cSJim Jagielski SfxFloatingWindow::GetFocus();
259*b1cdbd2cSJim Jagielski }
260*b1cdbd2cSJim Jagielski
261*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
createSelectionControls()262*b1cdbd2cSJim Jagielski sal_Bool FmFieldWin::createSelectionControls( )
263*b1cdbd2cSJim Jagielski {
264*b1cdbd2cSJim Jagielski SvLBoxEntry* pSelected = pListBox->FirstSelected();
265*b1cdbd2cSJim Jagielski if ( pSelected )
266*b1cdbd2cSJim Jagielski {
267*b1cdbd2cSJim Jagielski // build a descriptor for the currently selected field
268*b1cdbd2cSJim Jagielski ODataAccessDescriptor aDescr;
269*b1cdbd2cSJim Jagielski aDescr.setDataSource(GetDatabaseName());
270*b1cdbd2cSJim Jagielski
271*b1cdbd2cSJim Jagielski aDescr[ daConnection ] <<= GetConnection().getTyped();
272*b1cdbd2cSJim Jagielski
273*b1cdbd2cSJim Jagielski aDescr[ daCommand ] <<= GetObjectName();
274*b1cdbd2cSJim Jagielski aDescr[ daCommandType ] <<= GetObjectType();
275*b1cdbd2cSJim Jagielski ColumnInfo* pInfo = static_cast<ColumnInfo*>(pSelected->GetUserData());
276*b1cdbd2cSJim Jagielski aDescr[ daColumnName ] <<= pInfo->sColumnName;//::rtl::OUString( pListBox->GetEntryText( pSelected) );
277*b1cdbd2cSJim Jagielski
278*b1cdbd2cSJim Jagielski // transfer this to the SFX world
279*b1cdbd2cSJim Jagielski SfxUnoAnyItem aDescriptorItem( SID_FM_DATACCESS_DESCRIPTOR, makeAny( aDescr.createPropertyValueSequence() ) );
280*b1cdbd2cSJim Jagielski const SfxPoolItem* pArgs[] =
281*b1cdbd2cSJim Jagielski {
282*b1cdbd2cSJim Jagielski &aDescriptorItem, NULL
283*b1cdbd2cSJim Jagielski };
284*b1cdbd2cSJim Jagielski
285*b1cdbd2cSJim Jagielski // execute the create slot
286*b1cdbd2cSJim Jagielski GetBindings().Execute( SID_FM_CREATE_FIELDCONTROL, pArgs );
287*b1cdbd2cSJim Jagielski }
288*b1cdbd2cSJim Jagielski
289*b1cdbd2cSJim Jagielski return NULL != pSelected;
290*b1cdbd2cSJim Jagielski }
291*b1cdbd2cSJim Jagielski
292*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
PreNotify(NotifyEvent & _rNEvt)293*b1cdbd2cSJim Jagielski long FmFieldWin::PreNotify( NotifyEvent& _rNEvt )
294*b1cdbd2cSJim Jagielski {
295*b1cdbd2cSJim Jagielski if ( EVENT_KEYINPUT == _rNEvt.GetType() )
296*b1cdbd2cSJim Jagielski {
297*b1cdbd2cSJim Jagielski const KeyCode& rKeyCode = _rNEvt.GetKeyEvent()->GetKeyCode();
298*b1cdbd2cSJim Jagielski if ( ( 0 == rKeyCode.GetModifier() ) && ( KEY_RETURN == rKeyCode.GetCode() ) )
299*b1cdbd2cSJim Jagielski {
300*b1cdbd2cSJim Jagielski if ( createSelectionControls() )
301*b1cdbd2cSJim Jagielski return 1;
302*b1cdbd2cSJim Jagielski }
303*b1cdbd2cSJim Jagielski }
304*b1cdbd2cSJim Jagielski
305*b1cdbd2cSJim Jagielski return SfxFloatingWindow::PreNotify( _rNEvt );
306*b1cdbd2cSJim Jagielski }
307*b1cdbd2cSJim Jagielski
308*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
Close()309*b1cdbd2cSJim Jagielski sal_Bool FmFieldWin::Close()
310*b1cdbd2cSJim Jagielski {
311*b1cdbd2cSJim Jagielski return SfxFloatingWindow::Close();
312*b1cdbd2cSJim Jagielski }
313*b1cdbd2cSJim Jagielski
314*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
_propertyChanged(const::com::sun::star::beans::PropertyChangeEvent & evt)315*b1cdbd2cSJim Jagielski void FmFieldWin::_propertyChanged(const ::com::sun::star::beans::PropertyChangeEvent& evt) throw( ::com::sun::star::uno::RuntimeException )
316*b1cdbd2cSJim Jagielski {
317*b1cdbd2cSJim Jagielski ::com::sun::star::uno::Reference< ::com::sun::star::form::XForm > xForm(evt.Source, ::com::sun::star::uno::UNO_QUERY);
318*b1cdbd2cSJim Jagielski UpdateContent(xForm);
319*b1cdbd2cSJim Jagielski }
320*b1cdbd2cSJim Jagielski
321*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
StateChanged(sal_uInt16 nSID,SfxItemState eState,const SfxPoolItem * pState)322*b1cdbd2cSJim Jagielski void FmFieldWin::StateChanged(sal_uInt16 nSID, SfxItemState eState, const SfxPoolItem* pState)
323*b1cdbd2cSJim Jagielski {
324*b1cdbd2cSJim Jagielski if (!pState || SID_FM_FIELDS_CONTROL != nSID)
325*b1cdbd2cSJim Jagielski return;
326*b1cdbd2cSJim Jagielski
327*b1cdbd2cSJim Jagielski if (eState >= SFX_ITEM_AVAILABLE)
328*b1cdbd2cSJim Jagielski {
329*b1cdbd2cSJim Jagielski FmFormShell* pShell = PTR_CAST(FmFormShell,((SfxObjectItem*)pState)->GetShell());
330*b1cdbd2cSJim Jagielski UpdateContent(pShell);
331*b1cdbd2cSJim Jagielski }
332*b1cdbd2cSJim Jagielski else
333*b1cdbd2cSJim Jagielski UpdateContent(NULL);
334*b1cdbd2cSJim Jagielski }
335*b1cdbd2cSJim Jagielski
336*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
UpdateContent(FmFormShell * pShell)337*b1cdbd2cSJim Jagielski void FmFieldWin::UpdateContent(FmFormShell* pShell)
338*b1cdbd2cSJim Jagielski {
339*b1cdbd2cSJim Jagielski pListBox->Clear();
340*b1cdbd2cSJim Jagielski String aTitle( SVX_RES( RID_STR_FIELDSELECTION ) );
341*b1cdbd2cSJim Jagielski SetText( aTitle );
342*b1cdbd2cSJim Jagielski
343*b1cdbd2cSJim Jagielski if (!pShell || !pShell->GetImpl())
344*b1cdbd2cSJim Jagielski return;
345*b1cdbd2cSJim Jagielski
346*b1cdbd2cSJim Jagielski Reference< XForm > xForm = pShell->GetImpl()->getCurrentForm();
347*b1cdbd2cSJim Jagielski if ( xForm.is() )
348*b1cdbd2cSJim Jagielski UpdateContent( xForm );
349*b1cdbd2cSJim Jagielski }
350*b1cdbd2cSJim Jagielski
351*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
UpdateContent(const::com::sun::star::uno::Reference<::com::sun::star::form::XForm> & xForm)352*b1cdbd2cSJim Jagielski void FmFieldWin::UpdateContent(const ::com::sun::star::uno::Reference< ::com::sun::star::form::XForm > & xForm)
353*b1cdbd2cSJim Jagielski {
354*b1cdbd2cSJim Jagielski try
355*b1cdbd2cSJim Jagielski {
356*b1cdbd2cSJim Jagielski // ListBox loeschen
357*b1cdbd2cSJim Jagielski pListBox->Clear();
358*b1cdbd2cSJim Jagielski UniString aTitle(SVX_RES(RID_STR_FIELDSELECTION));
359*b1cdbd2cSJim Jagielski SetText(aTitle);
360*b1cdbd2cSJim Jagielski
361*b1cdbd2cSJim Jagielski if (!xForm.is())
362*b1cdbd2cSJim Jagielski return;
363*b1cdbd2cSJim Jagielski
364*b1cdbd2cSJim Jagielski Reference< XPreparedStatement > xStatement;
365*b1cdbd2cSJim Jagielski Reference< XPropertySet > xSet(xForm, UNO_QUERY);
366*b1cdbd2cSJim Jagielski
367*b1cdbd2cSJim Jagielski m_aObjectName = ::comphelper::getString(xSet->getPropertyValue(FM_PROP_COMMAND));
368*b1cdbd2cSJim Jagielski m_aDatabaseName = ::comphelper::getString(xSet->getPropertyValue(FM_PROP_DATASOURCE));
369*b1cdbd2cSJim Jagielski m_nObjectType = ::comphelper::getINT32(xSet->getPropertyValue(FM_PROP_COMMANDTYPE));
370*b1cdbd2cSJim Jagielski
371*b1cdbd2cSJim Jagielski // get the connection of the form
372*b1cdbd2cSJim Jagielski OStaticDataAccessTools aTools;
373*b1cdbd2cSJim Jagielski m_aConnection.reset(
374*b1cdbd2cSJim Jagielski aTools.connectRowset( Reference< XRowSet >( xForm, UNO_QUERY ), ::comphelper::getProcessServiceFactory(), sal_True ),
375*b1cdbd2cSJim Jagielski SharedConnection::NoTakeOwnership
376*b1cdbd2cSJim Jagielski );
377*b1cdbd2cSJim Jagielski // TODO: When incompatible changes (such as extending the "virtualdbtools" interface by ensureRowSetConnection)
378*b1cdbd2cSJim Jagielski // are allowed, again, we should change this: dbtools should consistently use SharedConnection all over
379*b1cdbd2cSJim Jagielski // the place, and connectRowset should be replaced with ensureRowSetConnection
380*b1cdbd2cSJim Jagielski
381*b1cdbd2cSJim Jagielski // get the fields of the object
382*b1cdbd2cSJim Jagielski
383*b1cdbd2cSJim Jagielski if ( m_aConnection.is() && m_aObjectName.getLength() )
384*b1cdbd2cSJim Jagielski {
385*b1cdbd2cSJim Jagielski Reference< XComponent > xKeepFieldsAlive;
386*b1cdbd2cSJim Jagielski Reference< XNameAccess > xColumns = getFieldsByCommandDescriptor( m_aConnection, m_nObjectType, m_aObjectName,xKeepFieldsAlive );
387*b1cdbd2cSJim Jagielski if ( xColumns.is() )
388*b1cdbd2cSJim Jagielski lcl_addToList(*pListBox,xColumns);
389*b1cdbd2cSJim Jagielski }
390*b1cdbd2cSJim Jagielski
391*b1cdbd2cSJim Jagielski // Prefix setzen
392*b1cdbd2cSJim Jagielski UniString aPrefix;
393*b1cdbd2cSJim Jagielski StringListResource aPrefixes( SVX_RES( RID_RSC_TABWIN_PREFIX ) );
394*b1cdbd2cSJim Jagielski
395*b1cdbd2cSJim Jagielski switch (m_nObjectType)
396*b1cdbd2cSJim Jagielski {
397*b1cdbd2cSJim Jagielski case CommandType::TABLE:
398*b1cdbd2cSJim Jagielski aPrefix = aPrefixes[0];
399*b1cdbd2cSJim Jagielski break;
400*b1cdbd2cSJim Jagielski case CommandType::QUERY:
401*b1cdbd2cSJim Jagielski aPrefix = aPrefixes[1];
402*b1cdbd2cSJim Jagielski break;
403*b1cdbd2cSJim Jagielski default:
404*b1cdbd2cSJim Jagielski aPrefix = aPrefixes[2];
405*b1cdbd2cSJim Jagielski break;
406*b1cdbd2cSJim Jagielski }
407*b1cdbd2cSJim Jagielski
408*b1cdbd2cSJim Jagielski // an dem PropertySet nach Aenderungen der ControlSource lauschen
409*b1cdbd2cSJim Jagielski if (m_pChangeListener)
410*b1cdbd2cSJim Jagielski {
411*b1cdbd2cSJim Jagielski m_pChangeListener->dispose();
412*b1cdbd2cSJim Jagielski m_pChangeListener->release();
413*b1cdbd2cSJim Jagielski }
414*b1cdbd2cSJim Jagielski m_pChangeListener = new ::comphelper::OPropertyChangeMultiplexer(this, xSet);
415*b1cdbd2cSJim Jagielski m_pChangeListener->acquire();
416*b1cdbd2cSJim Jagielski m_pChangeListener->addProperty(FM_PROP_DATASOURCE);
417*b1cdbd2cSJim Jagielski m_pChangeListener->addProperty(FM_PROP_COMMAND);
418*b1cdbd2cSJim Jagielski m_pChangeListener->addProperty(FM_PROP_COMMANDTYPE);
419*b1cdbd2cSJim Jagielski
420*b1cdbd2cSJim Jagielski // Titel setzen
421*b1cdbd2cSJim Jagielski aTitle.AppendAscii(" ");
422*b1cdbd2cSJim Jagielski aTitle += aPrefix;
423*b1cdbd2cSJim Jagielski aTitle.AppendAscii(" ");
424*b1cdbd2cSJim Jagielski aTitle += m_aObjectName.getStr();
425*b1cdbd2cSJim Jagielski SetText( aTitle );
426*b1cdbd2cSJim Jagielski }
427*b1cdbd2cSJim Jagielski catch( const Exception& )
428*b1cdbd2cSJim Jagielski {
429*b1cdbd2cSJim Jagielski DBG_ERROR( "FmTabWin::UpdateContent: caught an exception!" );
430*b1cdbd2cSJim Jagielski }
431*b1cdbd2cSJim Jagielski }
432*b1cdbd2cSJim Jagielski
433*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
Resize()434*b1cdbd2cSJim Jagielski void FmFieldWin::Resize()
435*b1cdbd2cSJim Jagielski {
436*b1cdbd2cSJim Jagielski SfxFloatingWindow::Resize();
437*b1cdbd2cSJim Jagielski
438*b1cdbd2cSJim Jagielski Point aPos(GetPosPixel());
439*b1cdbd2cSJim Jagielski Size aOutputSize( GetOutputSizePixel() );
440*b1cdbd2cSJim Jagielski
441*b1cdbd2cSJim Jagielski //////////////////////////////////////////////////////////////////////
442*b1cdbd2cSJim Jagielski
443*b1cdbd2cSJim Jagielski // Groesse der ::com::sun::star::form::ListBox anpassen
444*b1cdbd2cSJim Jagielski Point aLBPos( LISTBOX_BORDER, LISTBOX_BORDER );
445*b1cdbd2cSJim Jagielski Size aLBSize( aOutputSize );
446*b1cdbd2cSJim Jagielski aLBSize.Width() -= (2*LISTBOX_BORDER);
447*b1cdbd2cSJim Jagielski aLBSize.Height() -= (2*LISTBOX_BORDER);
448*b1cdbd2cSJim Jagielski
449*b1cdbd2cSJim Jagielski pListBox->SetPosSizePixel( aLBPos, aLBSize );
450*b1cdbd2cSJim Jagielski }
451*b1cdbd2cSJim Jagielski
452*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
FillInfo(SfxChildWinInfo & rInfo) const453*b1cdbd2cSJim Jagielski void FmFieldWin::FillInfo( SfxChildWinInfo& rInfo ) const
454*b1cdbd2cSJim Jagielski {
455*b1cdbd2cSJim Jagielski rInfo.bVisible = sal_False;
456*b1cdbd2cSJim Jagielski }
457*b1cdbd2cSJim Jagielski
458*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
SFX_IMPL_FLOATINGWINDOW(FmFieldWinMgr,SID_FM_ADD_FIELD)459*b1cdbd2cSJim Jagielski SFX_IMPL_FLOATINGWINDOW(FmFieldWinMgr, SID_FM_ADD_FIELD)
460*b1cdbd2cSJim Jagielski
461*b1cdbd2cSJim Jagielski //-----------------------------------------------------------------------
462*b1cdbd2cSJim Jagielski FmFieldWinMgr::FmFieldWinMgr(Window* _pParent, sal_uInt16 _nId,
463*b1cdbd2cSJim Jagielski SfxBindings* _pBindings, SfxChildWinInfo* _pInfo)
464*b1cdbd2cSJim Jagielski :SfxChildWindow(_pParent, _nId)
465*b1cdbd2cSJim Jagielski {
466*b1cdbd2cSJim Jagielski pWindow = new FmFieldWin(_pBindings, this, _pParent);
467*b1cdbd2cSJim Jagielski SetHideNotDelete(sal_True);
468*b1cdbd2cSJim Jagielski eChildAlignment = SFX_ALIGN_NOALIGNMENT;
469*b1cdbd2cSJim Jagielski ((SfxFloatingWindow*)pWindow)->Initialize( _pInfo );
470*b1cdbd2cSJim Jagielski }
471*b1cdbd2cSJim Jagielski
472*b1cdbd2cSJim Jagielski
473