1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 #ifndef _SBA_BWRCTRLR_HXX 25 #define _SBA_BWRCTRLR_HXX 26 27 #include "genericcontroller.hxx" 28 #include "moduledbu.hxx" 29 #include "brwview.hxx" 30 #include "sbagrid.hxx" 31 32 /** === begin UNO includes === **/ 33 #include <com/sun/star/form/XLoadable.hpp> 34 #include <com/sun/star/container/XContainerListener.hpp> 35 #include <com/sun/star/sdb/XSQLErrorListener.hpp> 36 #include <com/sun/star/sdbc/XRowSet.hpp> 37 #include <com/sun/star/form/XResetListener.hpp> 38 #include <com/sun/star/form/XDatabaseParameterListener.hpp> 39 #include <com/sun/star/form/XConfirmDeleteListener.hpp> 40 #include <com/sun/star/form/XFormComponent.hpp> 41 #include <com/sun/star/awt/XFocusListener.hpp> 42 #include <com/sun/star/sdbcx/XColumnsSupplier.hpp> 43 #include <com/sun/star/sdb/XSingleSelectQueryComposer.hpp> 44 #include <com/sun/star/beans/XPropertyChangeListener.hpp> 45 #include <com/sun/star/frame/XModule.hpp> 46 /** === end UNO includes === **/ 47 48 #include <vcl/timer.hxx> 49 #include <svtools/transfer.hxx> 50 #include <osl/mutex.hxx> 51 #include <vos/thread.hxx> 52 #include <cppuhelper/implbase9.hxx> 53 #include <svtools/cliplistener.hxx> 54 55 class ResMgr; 56 struct FmFoundRecordInformation; 57 struct FmSearchContext; 58 59 namespace dbtools 60 { 61 class SQLExceptionInfo; 62 } 63 64 namespace dbaui 65 { 66 // ========================================================================= 67 68 typedef ::cppu::ImplInheritanceHelper9 < OGenericUnoController 69 , ::com::sun::star::sdb::XSQLErrorListener 70 , ::com::sun::star::form::XDatabaseParameterListener 71 , ::com::sun::star::form::XConfirmDeleteListener 72 , ::com::sun::star::form::XLoadListener 73 , ::com::sun::star::form::XResetListener 74 , ::com::sun::star::awt::XFocusListener 75 , ::com::sun::star::container::XContainerListener 76 , ::com::sun::star::beans::XPropertyChangeListener 77 , ::com::sun::star::frame::XModule 78 > SbaXDataBrowserController_Base; 79 80 class SbaXDataBrowserController :public SbaXDataBrowserController_Base 81 ,public SbaGridListener 82 { 83 // ========== 84 // attributes 85 private: 86 // for implementing the XFormController 87 class FormControllerImpl; 88 friend class FormControllerImpl; 89 OModuleClient m_aModuleClient; 90 91 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XRowSet > m_xRowSet; // our rowset 92 ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XColumnsSupplier > m_xColumnsSupplier; // queried from the rowset member 93 ::com::sun::star::uno::Reference< ::com::sun::star::form::XLoadable > m_xLoadable; // queried from the rowset member as well 94 ::com::sun::star::uno::Reference< ::com::sun::star::form::XFormComponent > m_xGridModel; // the model of our grid 95 ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter > m_xFormatter; // a number formatter working with the connection's NumberFormatsSupplier 96 ::com::sun::star::uno::Reference< ::com::sun::star::uno::XAggregation > m_xFormControllerImpl; 97 mutable ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSingleSelectQueryComposer > 98 m_xParser; // for sorting 'n filtering 99 100 sal_Int32 m_nRowSetPrivileges; // cached Privileges property of m_xRowSet 101 102 AutoTimer m_aInvalidateClipboard; // for testing the state of the CUT/COPY/PASTE-slots 103 104 TransferableDataHelper m_aSystemClipboard; // content of the clipboard 105 TransferableClipboardListener* 106 m_pClipbordNotifier; // notifier for changes in the clipboard 107 108 ::osl::Mutex m_aAsyncLoadSafety; // for multi-thread access to our members 109 110 OAsyncronousLink m_aAsyncGetCellFocus; 111 OAsyncronousLink m_aAsyncDisplayError; 112 ::dbtools::SQLExceptionInfo m_aCurrentError; 113 114 String m_sStateSaveRecord; 115 String m_sStateUndoRecord; 116 ::rtl::OUString m_sModuleIdentifier; 117 118 // members for asynchronous load operations 119 FormControllerImpl* m_pFormControllerImpl; // implementing the XFormController 120 121 sal_uLong m_nPendingLoadFinished; // the event used to tell ourself that the load is finished 122 sal_uInt16 m_nFormActionNestingLevel; // see enter-/leaveFormAction 123 124 sal_Bool m_bLoadCanceled : 1; // the load was canceled somehow 125 sal_Bool m_bClosingKillOpen : 1; // are we killing the load thread because we are to be suspended ? 126 bool m_bCannotSelectUnfiltered : 1; // received a DATA_CANNOT_SELECT_UNFILTERED error 127 128 protected: 129 class FormErrorHelper 130 { 131 SbaXDataBrowserController* m_pOwner; 132 public: FormErrorHelper(SbaXDataBrowserController * pOwner)133 FormErrorHelper(SbaXDataBrowserController* pOwner) : m_pOwner(pOwner) { m_pOwner->enterFormAction(); } ~FormErrorHelper()134 virtual ~FormErrorHelper() { m_pOwner->leaveFormAction(); } 135 }; 136 friend class FormErrorHelper; 137 138 // ================ 139 // attribute access 140 protected: getRowSet() const141 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XRowSet > getRowSet() const { return m_xRowSet; } getColumnsSupplier() const142 ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XColumnsSupplier > getColumnsSupplier()const { return m_xColumnsSupplier; } getLoadable() const143 ::com::sun::star::uno::Reference< ::com::sun::star::form::XLoadable > getLoadable() const { return m_xLoadable; } 144 getFormComponent() const145 ::com::sun::star::uno::Reference< ::com::sun::star::form::XFormComponent > getFormComponent() const { return m_xGridModel; } getControlModel() const146 ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControlModel > getControlModel() const { return ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControlModel > (m_xGridModel, ::com::sun::star::uno::UNO_QUERY); } getNumberFormatter() const147 ::com::sun::star::uno::Reference< ::com::sun::star::util::XNumberFormatter > getNumberFormatter()const { return m_xFormatter; } 148 isValid() const149 sal_Bool isValid() const { return m_xRowSet.is() && m_xGridModel.is(); } 150 sal_Bool isValidCursor() const; // checks the ::com::sun::star::data::XDatabaseCursor-interface of m_xRowSet 151 sal_Bool isLoaded() const; loadingCancelled() const152 sal_Bool loadingCancelled() const { return m_bLoadCanceled; } 153 void onStartLoading( const ::com::sun::star::uno::Reference< ::com::sun::star::form::XLoadable >& _rxLoadable ); setLoadingCancelled()154 void setLoadingCancelled() { m_bLoadCanceled = sal_True; } 155 156 const TransferableDataHelper& getViewClipboard() const157 getViewClipboard() const { return m_aSystemClipboard; } 158 159 public: 160 SbaXDataBrowserController(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM); 161 getBrowserView() const162 UnoDataBrowserView* getBrowserView() const { return static_cast< UnoDataBrowserView*>(getView()); } 163 // late construction 164 virtual sal_Bool Construct(Window* pParent); 165 166 // UNO 167 virtual ::com::sun::star::uno::Any SAL_CALL queryInterface(const ::com::sun::star::uno::Type& _rType) throw (::com::sun::star::uno::RuntimeException); 168 169 // XTypeProvider 170 virtual ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL getTypes( ) throw (::com::sun::star::uno::RuntimeException); 171 virtual ::com::sun::star::uno::Sequence< sal_Int8 > SAL_CALL getImplementationId( ) throw (::com::sun::star::uno::RuntimeException); 172 173 // ::com::sun::star::lang::XEventListener 174 virtual void SAL_CALL disposing(const ::com::sun::star::lang::EventObject& Source) throw( ::com::sun::star::uno::RuntimeException ); 175 176 // ::com::sun::star::util::XModifyListener 177 virtual void SAL_CALL modified(const ::com::sun::star::lang::EventObject& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 178 179 // ::com::sun::star::container::XContainerListener 180 virtual void SAL_CALL elementInserted(const ::com::sun::star::container::ContainerEvent& Event) throw( ::com::sun::star::uno::RuntimeException ); 181 virtual void SAL_CALL elementRemoved(const ::com::sun::star::container::ContainerEvent& Event) throw( ::com::sun::star::uno::RuntimeException ); 182 virtual void SAL_CALL elementReplaced(const ::com::sun::star::container::ContainerEvent& Event) throw( ::com::sun::star::uno::RuntimeException ); 183 184 // XPropertyChangeListener 185 virtual void SAL_CALL propertyChange( const ::com::sun::star::beans::PropertyChangeEvent& evt ) throw (::com::sun::star::uno::RuntimeException); 186 187 // XModule 188 virtual void SAL_CALL setIdentifier( const ::rtl::OUString& Identifier ) throw (::com::sun::star::uno::RuntimeException); 189 virtual ::rtl::OUString SAL_CALL getIdentifier( ) throw (::com::sun::star::uno::RuntimeException); 190 191 // ::com::sun::star::awt::XFocusListener 192 virtual void SAL_CALL focusGained(const ::com::sun::star::awt::FocusEvent& e) throw( ::com::sun::star::uno::RuntimeException ); 193 virtual void SAL_CALL focusLost(const ::com::sun::star::awt::FocusEvent& e) throw( ::com::sun::star::uno::RuntimeException ); 194 195 // ::com::sun::star::frame::XController 196 virtual sal_Bool SAL_CALL suspend(sal_Bool bSuspend) throw( ::com::sun::star::uno::RuntimeException ); 197 198 // ::com::sun::star::lang::XComponent 199 virtual void SAL_CALL disposing(); 200 201 // ::com::sun::star::frame::XFrameActionListener 202 virtual void SAL_CALL frameAction(const ::com::sun::star::frame::FrameActionEvent& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 203 204 // ::com::sun::star::sdb::XSQLErrorListener 205 virtual void SAL_CALL errorOccured(const ::com::sun::star::sdb::SQLErrorEvent& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 206 207 // ::com::sun::star::form::XDatabaseParameterListener 208 virtual sal_Bool SAL_CALL approveParameter(const ::com::sun::star::form::DatabaseParameterEvent& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 209 210 // ::com::sun::star::form::XConfirmDeleteListener 211 virtual sal_Bool SAL_CALL confirmDelete(const ::com::sun::star::sdb::RowChangeEvent& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 212 213 // ::com::sun::star::form::XLoadListener 214 virtual void SAL_CALL loaded(const ::com::sun::star::lang::EventObject& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 215 virtual void SAL_CALL unloading(const ::com::sun::star::lang::EventObject& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 216 virtual void SAL_CALL unloaded(const ::com::sun::star::lang::EventObject& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 217 virtual void SAL_CALL reloading(const ::com::sun::star::lang::EventObject& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 218 virtual void SAL_CALL reloaded(const ::com::sun::star::lang::EventObject& aEvent) throw( ::com::sun::star::uno::RuntimeException ); 219 220 // ::com::sun::star::form::XResetListener 221 virtual sal_Bool SAL_CALL approveReset(const ::com::sun::star::lang::EventObject& rEvent) throw( ::com::sun::star::uno::RuntimeException ); 222 virtual void SAL_CALL resetted(const ::com::sun::star::lang::EventObject& rEvent) throw( ::com::sun::star::uno::RuntimeException ); 223 224 // SbaGridListener 225 virtual void RowChanged(); 226 virtual void ColumnChanged(); 227 virtual void SelectionChanged(); 228 virtual void CellActivated(); 229 virtual void CellDeactivated(); 230 virtual void BeforeDrop(); 231 virtual void AfterDrop(); 232 233 public: 234 235 protected: 236 virtual ~SbaXDataBrowserController(); 237 238 // all the features which should be handled by this class 239 virtual void describeSupportedFeatures(); 240 // state of a feature. 'feature' may be the handle of a ::com::sun::star::util::URL somebody requested a dispatch interface for OR a toolbar slot. 241 virtual FeatureState GetState(sal_uInt16 nId) const; 242 // execute a feature 243 virtual void Execute(sal_uInt16 nId, const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue>& aArgs); 244 245 virtual void startFrameListening( const ::com::sun::star::uno::Reference< ::com::sun::star::frame::XFrame >& _rxFrame ); 246 virtual void stopFrameListening( const ::com::sun::star::uno::Reference< ::com::sun::star::frame::XFrame >& _rxFrame ); 247 248 virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XRowSet > CreateForm(); 249 // our default implementation simply instantiates a stardiv.one.form.component.Form service 250 // (probably this needs not to be overloaded, but you may return anything you want as long as it 251 // supports the ::com::sun::star::form::DatabaseForm service. For instance you may want to create an adapter here which 252 // is synchronized with a foreign ::com::sun::star::form::DatabaseForm you got elsewhere) 253 virtual sal_Bool InitializeForm( 254 const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& i_formProperties ) = 0; 255 // called immediately after a successful CreateForm 256 // do any initialization (data source etc.) here. the form should be fully functional after that. 257 // return sal_False if you didn't succeed (don't throw exceptions, they won't be caught) 258 259 virtual sal_Bool InitializeGridModel(const ::com::sun::star::uno::Reference< ::com::sun::star::form::XFormComponent > & xGrid); 260 261 262 virtual ::com::sun::star::uno::Reference< ::com::sun::star::form::XFormComponent > CreateGridModel(); 263 // our default implementation simply instantiates a stardiv.one.form.component.Grid service 264 // you most probably don't want to override this behaviuor 265 266 // the default implementation of disposing distributes the events to the following disposingXXX functions 267 virtual void disposingGridControl(const ::com::sun::star::lang::EventObject& Source); // calls removeControlListeners 268 virtual void disposingGridModel(const ::com::sun::star::lang::EventObject& Source); // calls removeModelListeners 269 virtual void disposingFormModel(const ::com::sun::star::lang::EventObject& Source); 270 virtual void disposingColumnModel(const ::com::sun::star::lang::EventObject& Source); 271 272 // want to be a listener to the grid control ? use this ! 273 virtual void addControlListeners(const ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControl > & _xGridControl); 274 virtual void removeControlListeners(const ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControl > & _xGridControl); 275 276 // want to be a listener to the grid model ? use this ! 277 virtual void addModelListeners(const ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControlModel > & _xGridControlModel); 278 virtual void removeModelListeners(const ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControlModel > & _xGridControlModel); 279 280 // want to be a listener grid columns ? use this ! 281 virtual void AddColumnListener(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > & xCol); 282 virtual void RemoveColumnListener(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > & xCol); 283 284 285 // call after "major changes" (e.g. the completion of the async load). 286 // invalidates all toolbox slots and all supported features. 287 288 virtual sal_Bool LoadForm(); 289 // load the form 290 // the default implementation does an direct load or starts a load thread, depending on the multithread capabilities 291 // of the data source. 292 // the default implementation also calls LoadFinished after a syncronous load, so be sure to do the same if you override 293 // this metod and don't call the base class' method 294 295 virtual void LoadFinished(sal_Bool bWasSynch); 296 // called if the loading (the _complete_ loading process) is done (no matter if synchron or asynchron). 297 298 virtual void criticalFail(); 299 // called whenever a reload operation on the rowset failed 300 // (a "operation" is not only a simple reload: If the user sets a filter, an reloading the form 301 // after setting this filter fails, the filter is reset and the form is reloaded, again. Only the 302 // whole process (_both_ XLoadable::reload calls _together_) form the "reload operation" 303 304 // -------------------- 305 306 // empty the frame where our view resides 307 virtual sal_Bool CommitCurrent(); 308 // commit the current column (i.e. cell) 309 virtual sal_Bool SaveModified(sal_Bool bAskFor = sal_True); 310 // save the modified record 311 312 ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > getBoundField(sal_uInt16 nViewPos = (sal_uInt16)-1) const; 313 // a PropertySet corresponding to the cursor field a column is bound to 314 // if nViewPos is (sal_uInt16)-1 (the default) then the field for the current column will be retrieved 315 316 void enterFormAction(); 317 void leaveFormAction(); 318 319 // init the formatter if form changes 320 void initFormatter(); 321 322 /// loads or reloads the form 323 virtual sal_Bool reloadForm(const ::com::sun::star::uno::Reference< ::com::sun::star::form::XLoadable >& _rxLoadable); 324 preReloadForm()325 virtual sal_Bool preReloadForm(){ return sal_False; } postReloadForm()326 virtual void postReloadForm(){} 327 328 ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSingleSelectQueryComposer > 329 createParser_nothrow(); 330 331 private: 332 void setCurrentModified( sal_Bool _bSet ); 333 334 // execute the filter or sort slot 335 void ExecuteFilterSortCrit(sal_Bool bFilter); 336 337 // execute the search slot 338 void ExecuteSearch(); 339 340 void initializeParser() const; // changes the mutable member m_xParser 341 void applyParserFilter(const ::rtl::OUString& _rOldFilter, sal_Bool _bOldFilterApplied,const ::rtl::OUString& _sOldHaving,const ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSingleSelectQueryComposer >& _xParser); 342 void applyParserOrder(const ::rtl::OUString& _rOldOrder,const ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSingleSelectQueryComposer >& _xParser); 343 344 sal_Int16 getCurrentColumnPosition(); 345 void setCurrentColumnPosition( sal_Int16 _nPos ); 346 void addColumnListeners(const ::com::sun::star::uno::Reference< ::com::sun::star::awt::XControlModel > & _xGridControlModel); 347 348 void impl_checkForCannotSelectUnfiltered( const ::dbtools::SQLExceptionInfo& _rError ); 349 350 // time to check the CUT/COPY/PASTE-slot-states 351 DECL_LINK( OnInvalidateClipboard, AutoTimer* ); 352 DECL_LINK( OnClipboardChanged, void* ); 353 354 // search callbacks 355 DECL_LINK(OnSearchContextRequest, FmSearchContext*); 356 DECL_LINK(OnFoundData, FmFoundRecordInformation*); 357 DECL_LINK(OnCanceledNotFound, FmFoundRecordInformation*); 358 359 DECL_LINK(OnAsyncGetCellFocus, void*); 360 361 DECL_LINK( OnAsyncDisplayError, void* ); 362 }; 363 } 364 365 #endif // _SBA_BWRCTRLR_HXX 366 367