| /************************************************************** | |
| * | |
| * 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 | |
| * | |
| * Unless required by applicable law or agreed to in writing, | |
| * software distributed under the License is distributed on an | |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| * KIND, either express or implied. See the License for the | |
| * specific language governing permissions and limitations | |
| * under the License. | |
| * | |
| *************************************************************/ | |
| #ifndef DBAUI_QUERYCONTROLLER_HXX | |
| #define DBAUI_QUERYCONTROLLER_HXX | |
| #include "JoinController.hxx" | |
| #include "JoinTableView.hxx" | |
| #include "querycontainerwindow.hxx" | |
| #include "queryview.hxx" | |
| #include "svx/ParseContext.hxx" | |
| #include "TableFieldDescription.hxx" | |
| /** === begin UNO includes === **/ | |
| #include <com/sun/star/io/XObjectInputStream.hpp> | |
| #include <com/sun/star/io/XObjectOutputStream.hpp> | |
| #include <com/sun/star/sdb/CommandType.hpp> | |
| #include <com/sun/star/sdb/XSQLQueryComposer.hpp> | |
| #include <com/sun/star/sdbc/XConnection.hpp> | |
| #include <com/sun/star/sdbcx/XAlterView.hpp> | |
| /** === end UNO includes === **/ | |
| #include <comphelper/proparrhlp.hxx> | |
| #include <comphelper/propertycontainer.hxx> | |
| #include <comphelper/uno3.hxx> | |
| #include <comphelper/uno3.hxx> | |
| #include <connectivity/sqliterator.hxx> | |
| #include <connectivity/sqlnode.hxx> | |
| #include <connectivity/sqlparse.hxx> | |
| #include <svl/undo.hxx> | |
| namespace comphelper | |
| { | |
| class NamedValueCollection; | |
| } | |
| class VCLXWindow; | |
| namespace dbaui | |
| { | |
| class OQueryView; | |
| class OQueryContainerWindow; | |
| class OTableConnectionData; | |
| class OTableWindowData; | |
| class OAddTableDlg; | |
| class OTableFieldDesc; | |
| class OQueryTableWindow; | |
| class OQueryController; | |
| typedef ::comphelper::OPropertyContainer OQueryController_PBase; | |
| typedef ::comphelper::OPropertyArrayUsageHelper< OQueryController > OQueryController_PABase; | |
| class OQueryController :public OJoinController | |
| ,public OQueryController_PBase | |
| ,public OQueryController_PABase | |
| { | |
| OTableFields m_vTableFieldDesc; | |
| OTableFields m_vUnUsedFieldsDesc; // contains fields which aren't visible and don't have any criteria | |
| ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue > m_aFieldInformation; | |
| ::svxform::OSystemParseContext* m_pParseContext; | |
| ::connectivity::OSQLParser m_aSqlParser; | |
| ::connectivity::OSQLParseTreeIterator* m_pSqlIterator; | |
| ::com::sun::star::uno::Reference< ::com::sun::star::sdb::XSQLQueryComposer > m_xComposer; | |
| /// if we're editing an existing view, this is non-NULL | |
| ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XAlterView > m_xAlterView; | |
| ::rtl::OUString m_sStatement; // contains the current sql statement | |
| ::rtl::OUString m_sUpdateCatalogName; // catalog for update data | |
| ::rtl::OUString m_sUpdateSchemaName; // schema for update data | |
| ::rtl::OUString m_sUpdateTableName; // table for update data | |
| mutable ::rtl::OUString | |
| m_sName; // name of the query | |
| sal_Int32 m_nVisibleRows; // which rows the selection browse should show | |
| sal_Int32 m_nSplitPos; // the position of the splitter | |
| sal_Int32 m_nCommandType; // the type of the object we're designing | |
| sal_Bool m_bGraphicalDesign; // are we in the graphical design mode (sal_True) or in the text design (sal_False)? | |
| sal_Bool m_bDistinct; // true when you want "select distinct" otherwise false | |
| sal_Bool m_bViewAlias; // show the alias row in the design view | |
| sal_Bool m_bViewTable; // show the table row in the design view | |
| sal_Bool m_bViewFunction; // show the function row in the design view | |
| sal_Bool m_bEscapeProcessing;// is true when we shouldn't parse the statement | |
| /** returns the container of queries, views, or command definitions, depending on what object type | |
| we design currently. | |
| Not allowed to be called if we design an independent SQL command. | |
| */ | |
| ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess > | |
| getObjectContainer() const; | |
| inline bool editingView() const { return m_nCommandType == ::com::sun::star::sdb::CommandType::TABLE; } | |
| inline bool editingQuery() const { return m_nCommandType == ::com::sun::star::sdb::CommandType::QUERY; } | |
| inline bool editingCommand() const { return m_nCommandType == ::com::sun::star::sdb::CommandType::COMMAND; } | |
| sal_Bool askForNewName( const ::com::sun::star::uno::Reference< ::com::sun::star::container::XNameAccess>& _xElements, | |
| sal_Bool _bSaveAs); | |
| // creates the querycomposer | |
| void setQueryComposer(); | |
| void deleteIterator(); | |
| void executeQuery(); | |
| bool doSaveAsDoc(sal_Bool _bSaveAs); | |
| void saveViewSettings( ::comphelper::NamedValueCollection& o_rViewSettings, const bool i_includingCriteria ) const; | |
| void loadViewSettings( const ::comphelper::NamedValueCollection& o_rViewSettings ); | |
| ::rtl::OUString translateStatement( bool _bFireStatementChange = true ); | |
| ::rtl::OUString getDefaultName() const; | |
| protected: | |
| // all the features which should be handled by this class | |
| virtual void describeSupportedFeatures(); | |
| // 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. | |
| virtual FeatureState GetState(sal_uInt16 nId) const; | |
| // execute a feature | |
| virtual void Execute(sal_uInt16 nId, const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue>& aArgs); | |
| virtual void reconnect( sal_Bool _bUI ); | |
| virtual ::rtl::OUString getPrivateTitle( ) const; | |
| OQueryContainerWindow* getContainer() const { return static_cast< OQueryContainerWindow* >( getView() ); } | |
| public: | |
| OQueryController(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rM); | |
| virtual ~OQueryController(); | |
| OTableFields& getTableFieldDesc() { return m_vTableFieldDesc; } | |
| OTableFields& getUnUsedFields() { return m_vUnUsedFieldsDesc; } | |
| void clearFields(); | |
| virtual void impl_onModifyChanged(); | |
| // should the statement be parsed by our own sql parser | |
| sal_Bool isEsacpeProcessing() const { return m_bEscapeProcessing; } | |
| sal_Bool isGraphicalDesign() const { return m_bGraphicalDesign; } | |
| sal_Bool isDistinct() const { return m_bDistinct; } | |
| ::rtl::OUString getStatement() const { return m_sStatement; } | |
| sal_Int32 getSplitPos() const { return m_nSplitPos;} | |
| sal_Int32 getVisibleRows() const { return m_nVisibleRows; } | |
| void setDistinct(sal_Bool _bDistinct) { m_bDistinct = _bDistinct;} | |
| void setSplitPos(sal_Int32 _nSplitPos) { m_nSplitPos = _nSplitPos;} | |
| void setVisibleRows(sal_Int32 _nVisibleRows) { m_nVisibleRows = _nVisibleRows;} | |
| sal_Int32 getColWidth(sal_uInt16 _nColPos) const; | |
| const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue >& | |
| getFieldInformation() const { return m_aFieldInformation; } | |
| ::connectivity::OSQLParser& getParser() { return m_aSqlParser; } | |
| ::connectivity::OSQLParseTreeIterator& getParseIterator() { return *m_pSqlIterator; } | |
| virtual sal_Bool Construct(Window* pParent); | |
| DECLARE_XINTERFACE( ) | |
| DECLARE_XTYPEPROVIDER( ) | |
| // XPropertySet | |
| virtual com::sun::star::uno::Reference<com::sun::star::beans::XPropertySetInfo> SAL_CALL getPropertySetInfo(); | |
| virtual ::cppu::IPropertyArrayHelper& SAL_CALL getInfoHelper(); | |
| // XEventListener | |
| virtual void SAL_CALL disposing( const ::com::sun::star::lang::EventObject& Source ); | |
| // ::com::sun::star::lang::XComponent | |
| virtual void SAL_CALL disposing(); | |
| virtual ::rtl::OUString SAL_CALL getImplementationName(); | |
| virtual ::com::sun::star::uno::Sequence< ::rtl::OUString> SAL_CALL getSupportedServiceNames(); | |
| // need by registration | |
| static ::rtl::OUString getImplementationName_Static(); | |
| static ::com::sun::star::uno::Sequence< ::rtl::OUString > getSupportedServiceNames_Static(void); | |
| static ::com::sun::star::uno::Reference< ::com::sun::star::uno::XInterface > | |
| SAL_CALL Create(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >&); | |
| // XController | |
| virtual ::com::sun::star::uno::Any SAL_CALL getViewData(void); | |
| virtual void SAL_CALL restoreViewData(const ::com::sun::star::uno::Any& Data); | |
| private: | |
| virtual void onLoadedMenu(const ::com::sun::star::uno::Reference< ::com::sun::star::frame::XLayoutManager >& _xLayoutManager); | |
| // OPropertyArrayUsageHelper | |
| virtual ::cppu::IPropertyArrayHelper* createArrayHelper( ) const; | |
| // OPropertySetHelper | |
| virtual sal_Bool SAL_CALL convertFastPropertyValue( | |
| ::com::sun::star::uno::Any& rConvertedValue, | |
| ::com::sun::star::uno::Any& rOldValue, | |
| sal_Int32 nHandle, | |
| const ::com::sun::star::uno::Any& rValue | |
| ); | |
| virtual void SAL_CALL setFastPropertyValue_NoBroadcast( | |
| sal_Int32 nHandle, | |
| const ::com::sun::star::uno::Any& rValue | |
| ); | |
| virtual void SAL_CALL getFastPropertyValue( | |
| ::com::sun::star::uno::Any& rValue, | |
| sal_Int32 nHandle | |
| ) const; | |
| virtual OJoinDesignView* getJoinView(); | |
| // ask the user if the design should be saved when it is modified | |
| virtual short saveModified(); | |
| virtual void reset(); | |
| virtual void impl_initialize(); | |
| void impl_reset( const bool i_bIgnoreQuerySettings = false ); | |
| /// tells the user that we needed to switch to SQL view automatically | |
| void impl_showAutoSQLViewError( const ::com::sun::star::uno::Any& _rErrorDetails ); | |
| /** switches to the graphical or SQL view mode, as determined by m_bGraphicalDesign | |
| */ | |
| bool impl_setViewMode( ::dbtools::SQLExceptionInfo* _pErrorInfo ); | |
| /// sets m_sStatement, and notifies our respective property change listeners | |
| void setStatement_fireEvent( const ::rtl::OUString& _rNewStatement, bool _bFireStatementChange = true ); | |
| /// sets the m_bEscapeProcessing member, and notifies our respective property change listeners | |
| void setEscapeProcessing_fireEvent( const sal_Bool _bEscapeProcessing ); | |
| // OJoinController overridables | |
| virtual bool allowViews() const; | |
| virtual bool allowQueries() const; | |
| private: | |
| DECL_LINK( OnExecuteAddTable, void* ); | |
| private: | |
| using OQueryController_PBase::getFastPropertyValue; | |
| }; | |
| } | |
| #endif // DBAUI_QUERYCONTROLLER_HXX |