/************************************************************** * * 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. * *************************************************************/ #include "precompiled_reportdesign.hxx" #include "AddField.hxx" #include "UITools.hxx" #include #include #include #include #include #include #include #include #include #include #include #include "rptui_slotid.hrc" #include #include "helpids.hrc" #include "RptResId.hrc" #include "CondFormat.hrc" #include "ModuleHelper.hxx" #include "uistrings.hrc" #include "ColumnInfo.hxx" #include #include namespace rptui { const long STD_WIN_SIZE_X = 180; const long STD_WIN_SIZE_Y = 320; const long LISTBOX_BORDER = 2; using namespace ::com::sun::star; using namespace sdbc; using namespace sdb; using namespace uno; using namespace datatransfer; using namespace beans; using namespace lang; using namespace container; using namespace ::svx; class OAddFieldWindowListBox : public SvTreeListBox { OAddFieldWindow* m_pTabWin; OAddFieldWindowListBox(const OAddFieldWindowListBox&); void operator =(const OAddFieldWindowListBox&); protected: // virtual void Command( const CommandEvent& rEvt ); public: OAddFieldWindowListBox( OAddFieldWindow* _pParent ); virtual ~OAddFieldWindowListBox(); sal_Int8 AcceptDrop( const AcceptDropEvent& rEvt ); sal_Int8 ExecuteDrop( const ExecuteDropEvent& rEvt ); uno::Sequence< beans::PropertyValue > getSelectedFieldDescriptors(); protected: // DragSourceHelper virtual void StartDrag( sal_Int8 nAction, const Point& rPosPixel ); private: using SvTreeListBox::ExecuteDrop; }; // ----------------------------------------------------------------------------- uno::Sequence< beans::PropertyValue > OAddFieldWindowListBox::getSelectedFieldDescriptors() { uno::Sequence< beans::PropertyValue > aArgs(GetSelectionCount()); sal_Int32 i = 0; SvLBoxEntry* pSelected = FirstSelected(); while( pSelected ) { // build a descriptor for the currently selected field ::svx::ODataAccessDescriptor aDescriptor; m_pTabWin->fillDescriptor(pSelected,aDescriptor); aArgs[i++].Value <<= aDescriptor.createPropertyValueSequence(); pSelected = NextSelected(pSelected); } return aArgs; } //================================================================== // class OAddFieldWindowListBox //================================================================== DBG_NAME( rpt_OAddFieldWindowListBox ); //------------------------------------------------------------------------------ OAddFieldWindowListBox::OAddFieldWindowListBox( OAddFieldWindow* _pParent ) :SvTreeListBox( _pParent, WB_TABSTOP|WB_BORDER|WB_SORT ) ,m_pTabWin( _pParent ) { DBG_CTOR( rpt_OAddFieldWindowListBox,NULL); SetHelpId( HID_RPT_FIELD_SEL ); SetSelectionMode(MULTIPLE_SELECTION); SetDragDropMode( 0xFFFF ); SetHighlightRange( ); } //------------------------------------------------------------------------------ OAddFieldWindowListBox::~OAddFieldWindowListBox() { DBG_DTOR( rpt_OAddFieldWindowListBox,NULL); } //------------------------------------------------------------------------------ sal_Int8 OAddFieldWindowListBox::AcceptDrop( const AcceptDropEvent& /*rEvt*/ ) { return DND_ACTION_NONE; } //------------------------------------------------------------------------------ sal_Int8 OAddFieldWindowListBox::ExecuteDrop( const ExecuteDropEvent& /*rEvt*/ ) { return DND_ACTION_NONE; } //------------------------------------------------------------------------------ void OAddFieldWindowListBox::StartDrag( sal_Int8 /*_nAction*/, const Point& /*_rPosPixel*/ ) { if ( GetSelectionCount() < 1 ) // no drag without a field return; OMultiColumnTransferable* pDataContainer = new OMultiColumnTransferable(getSelectedFieldDescriptors()); Reference< XTransferable> xEnsureDelete = pDataContainer; EndSelection(); pDataContainer->StartDrag( this, DND_ACTION_COPYMOVE | DND_ACTION_LINK ); } //======================================================================== // class OAddFieldWindow //======================================================================== DBG_NAME( rpt_OAddFieldWindow ); //----------------------------------------------------------------------- OAddFieldWindow::OAddFieldWindow(Window* pParent ,const uno::Reference< beans::XPropertySet >& _xRowSet ) :FloatingWindow(pParent, WinBits(WB_STDMODELESS|WB_SIZEABLE)) ,::comphelper::OPropertyChangeListener(m_aMutex) ,::comphelper::OContainerListener(m_aMutex) ,m_xRowSet(_xRowSet) ,m_aActions(this,ModuleRes(RID_TB_SORTING)) ,m_pListBox(new OAddFieldWindowListBox( this )) ,m_aFixedLine(this, ModuleRes(ADDFIELD_FL_HELP_SEPARATOR) ) ,m_aHelpText(this, ModuleRes(ADDFIELD_HELP_FIELD) ) ,m_aInsertButton(this, WB_TABSTOP|WB_CENTER) ,m_nCommandType(0) ,m_bEscapeProcessing(sal_False) ,m_pChangeListener(NULL) ,m_pContainerListener(NULL) { DBG_CTOR( rpt_OAddFieldWindow,NULL); SetHelpId( HID_RPT_FIELD_SEL_WIN ); SetBackground( Wallpaper( Application::GetSettings().GetStyleSettings().GetFaceColor()) ); SetMinOutputSizePixel(Size(STD_WIN_SIZE_X,STD_WIN_SIZE_Y)); m_aActions.SetStyle(m_aActions.GetStyle()|WB_LINESPACING); m_aActions.SetBackground( Wallpaper( Application::GetSettings().GetStyleSettings().GetFaceColor()) ); m_aActions.SetSelectHdl(LINK(this, OAddFieldWindow, OnSortAction)); setToolBox(&m_aActions); m_aActions.CheckItem(SID_FM_SORTUP); m_aActions.EnableItem(SID_ADD_CONTROL_PAIR, sal_False); m_pListBox->SetDoubleClickHdl(LINK( this, OAddFieldWindow, OnDoubleClickHdl ) ); m_pListBox->SetSelectHdl(LINK( this, OAddFieldWindow, OnSelectHdl ) ); m_pListBox->SetDeselectHdl(LINK( this, OAddFieldWindow, OnSelectHdl ) ); m_pListBox->SetDoubleClickHdl(LINK( this, OAddFieldWindow, OnDoubleClickHdl ) ); m_pListBox->Show(); const String sTitle(ModuleRes(RID_STR_INSERT)); m_aInsertButton.SetText(sTitle); m_aInsertButton.SetClickHdl(LINK( this, OAddFieldWindow, OnDoubleClickHdl ) ); m_aInsertButton.Show(); m_aFixedLine.SetControlBackground( GetSettings().GetStyleSettings().GetFaceColor() ); m_aHelpText.SetControlBackground( GetSettings().GetStyleSettings().GetFaceColor() ); SetSizePixel(Size(STD_WIN_SIZE_X,STD_WIN_SIZE_Y)); //Show(); if ( m_xRowSet.is() ) { try { // be notified when the settings of report definition change m_pChangeListener = new ::comphelper::OPropertyChangeMultiplexer( this, m_xRowSet ); m_pChangeListener->addProperty( PROPERTY_COMMAND ); m_pChangeListener->addProperty( PROPERTY_COMMANDTYPE ); m_pChangeListener->addProperty( PROPERTY_ESCAPEPROCESSING ); m_pChangeListener->addProperty( PROPERTY_FILTER ); } catch( const Exception& ) { DBG_UNHANDLED_EXCEPTION(); } } } //----------------------------------------------------------------------- OAddFieldWindow::~OAddFieldWindow() { if ( m_pListBox.get() ) { SvLBoxTreeList* pModel = m_pListBox->GetModel(); sal_uLong nCount = pModel->GetEntryCount(); for(sal_uLong i = 0; i< nCount;++i) { delete static_cast(pModel->GetEntry(i)->GetUserData()); } } if (m_pChangeListener.is()) m_pChangeListener->dispose(); if ( m_pContainerListener.is() ) m_pContainerListener->dispose(); DBG_DTOR( rpt_OAddFieldWindow,NULL); } //----------------------------------------------------------------------- void OAddFieldWindow::GetFocus() { if ( m_pListBox.get() ) m_pListBox->GrabFocus(); else FloatingWindow::GetFocus(); } //----------------------------------------------------------------------- uno::Sequence< beans::PropertyValue > OAddFieldWindow::getSelectedFieldDescriptors() { return m_pListBox->getSelectedFieldDescriptors(); } //----------------------------------------------------------------------- long OAddFieldWindow::PreNotify( NotifyEvent& _rNEvt ) { if ( EVENT_KEYINPUT == _rNEvt.GetType() ) { const KeyCode& rKeyCode = _rNEvt.GetKeyEvent()->GetKeyCode(); if ( ( 0 == rKeyCode.GetModifier() ) && ( KEY_RETURN == rKeyCode.GetCode() ) ) { if ( m_aCreateLink.IsSet() ) { m_aCreateLink.Call(this); return 1; } } } return FloatingWindow::PreNotify( _rNEvt ); } //----------------------------------------------------------------------- void OAddFieldWindow::_propertyChanged( const beans::PropertyChangeEvent& _evt ) throw( uno::RuntimeException ) { OSL_ENSURE( _evt.Source == m_xRowSet, "OAddFieldWindow::_propertyChanged: where did this come from?" ); (void)_evt; Update(); } //----------------------------------------------------------------------- namespace { void lcl_addToList( OAddFieldWindowListBox& _rListBox, const uno::Sequence< ::rtl::OUString >& _rEntries ) { const ::rtl::OUString* pEntries = _rEntries.getConstArray(); sal_Int32 nEntries = _rEntries.getLength(); for ( sal_Int32 i = 0; i < nEntries; ++i, ++pEntries ) _rListBox.InsertEntry( *pEntries,NULL,sal_False,LIST_APPEND,new ColumnInfo(*pEntries) ); } void lcl_addToList( OAddFieldWindowListBox& _rListBox, const uno::Reference< container::XNameAccess>& i_xColumns ) { uno::Sequence< ::rtl::OUString > aEntries = i_xColumns->getElementNames(); const ::rtl::OUString* pEntries = aEntries.getConstArray(); sal_Int32 nEntries = aEntries.getLength(); for ( sal_Int32 i = 0; i < nEntries; ++i, ++pEntries ) { uno::Reference< beans::XPropertySet> xColumn(i_xColumns->getByName(*pEntries),UNO_QUERY_THROW); ::rtl::OUString sLabel; if ( xColumn->getPropertySetInfo()->hasPropertyByName(PROPERTY_LABEL) ) xColumn->getPropertyValue(PROPERTY_LABEL) >>= sLabel; if ( sLabel.getLength() ) _rListBox.InsertEntry( sLabel,NULL,sal_False,LIST_APPEND,new ColumnInfo(*pEntries,sLabel) ); else _rListBox.InsertEntry( *pEntries,NULL,sal_False,LIST_APPEND,new ColumnInfo(*pEntries,sLabel) ); } } } //----------------------------------------------------------------------- void OAddFieldWindow::Update() { if ( m_pContainerListener.is() ) m_pContainerListener->dispose(); m_pContainerListener = NULL; m_xColumns.clear(); try { // ListBox loeschen m_pListBox->Clear(); const sal_uInt16 nItemCount = m_aActions.GetItemCount(); for (sal_uInt16 j = 0; j< nItemCount; ++j) { m_aActions.EnableItem(m_aActions.GetItemId(j),sal_False); } String aTitle(ModuleRes(RID_STR_FIELDSELECTION)); SetText(aTitle); if ( m_xRowSet.is() ) { ::rtl::OUString sCommand( m_aCommandName ); sal_Int32 nCommandType( m_nCommandType ); sal_Bool bEscapeProcessing( m_bEscapeProcessing ); ::rtl::OUString sFilter( m_sFilter ); OSL_VERIFY( m_xRowSet->getPropertyValue( PROPERTY_COMMAND ) >>= sCommand ); OSL_VERIFY( m_xRowSet->getPropertyValue( PROPERTY_COMMANDTYPE ) >>= nCommandType ); OSL_VERIFY( m_xRowSet->getPropertyValue( PROPERTY_ESCAPEPROCESSING ) >>= bEscapeProcessing ); OSL_VERIFY( m_xRowSet->getPropertyValue( PROPERTY_FILTER ) >>= sFilter ); m_aCommandName = sCommand; m_nCommandType = nCommandType; m_bEscapeProcessing = bEscapeProcessing; m_sFilter = sFilter; // add the columns to the list uno::Reference< sdbc::XConnection> xCon = getConnection(); if ( xCon.is() && m_aCommandName.getLength() ) m_xColumns = dbtools::getFieldsByCommandDescriptor( xCon, GetCommandType(), GetCommand(), m_xHoldAlive ); if ( m_xColumns.is() ) { lcl_addToList( *m_pListBox, m_xColumns ); uno::Reference< container::XContainer> xContainer(m_xColumns,uno::UNO_QUERY); if ( xContainer.is() ) m_pContainerListener = new ::comphelper::OContainerListenerAdapter(this,xContainer); } // add the parameter columns to the list uno::Reference< ::com::sun::star::sdbc::XRowSet > xRowSet(m_xRowSet,uno::UNO_QUERY); Sequence< ::rtl::OUString > aParamNames( getParameterNames( xRowSet ) ); lcl_addToList( *m_pListBox, aParamNames ); // set title aTitle.AppendAscii(" "); aTitle += m_aCommandName.getStr(); SetText( aTitle ); if ( m_aCommandName.getLength() ) { for (sal_uInt16 i = 0; i < nItemCount; ++i) { m_aActions.EnableItem(m_aActions.GetItemId(i)); } } OnSelectHdl(NULL); } } catch( const Exception& ) { DBG_UNHANDLED_EXCEPTION(); } } //----------------------------------------------------------------------- void OAddFieldWindow::Resize() { FloatingWindow::Resize(); const Size aWindowSize( GetOutputSizePixel() ); const Size aRelated(LogicToPixel( Size( RELATED_CONTROLS, RELATED_CONTROLS ), MAP_APPFONT )); const Size aFixedTextSize(LogicToPixel( Size( FIXEDTEXT_WIDTH, FIXEDTEXT_HEIGHT ), MAP_APPFONT )); // ToolBar Size aToolbarSize( m_aActions.GetSizePixel() ); Point aToolbarPos( aRelated.Width(), aRelated.Height()); m_aActions.SetPosPixel(Point(aToolbarPos.X(), aToolbarPos.Y())); Size aLBSize( aWindowSize ); aLBSize.Width() -= ( 2 * aRelated.Width() ); // help text const Size aHelpTextSize = m_aHelpText.CalcMinimumSize(aLBSize.Width()); // ListBox Point aLBPos( aRelated.Width(), aRelated.Height() + aToolbarSize.Height() + aRelated.Height() ); aLBSize.Height() -= aToolbarSize.Height(); // Toolbar aLBSize.Height() -= (6*aRelated.Height()); // 6 * gap aLBSize.Height() -= aFixedTextSize.Height(); // fixed line aLBSize.Height() -= aHelpTextSize.Height(); // help text m_pListBox->SetPosSizePixel( aLBPos, aLBSize ); // FixedLine Size aFLSize( aLBSize.Width(),aFixedTextSize.Height() ); Point aFLPos( aRelated.Width(), aLBPos.Y() + aLBSize.Height() + aRelated.Height()); m_aFixedLine.SetPosSizePixel( aFLPos, aFLSize ); // Help text Point aFTPos( aRelated.Width(), aFLPos.Y() + aFLSize.Height() + aRelated.Height() ); m_aHelpText.SetPosSizePixel( aFTPos, aHelpTextSize ); } // ----------------------------------------------------------------------------- uno::Reference< sdbc::XConnection> OAddFieldWindow::getConnection() const { return uno::Reference< sdbc::XConnection>(m_xRowSet->getPropertyValue( PROPERTY_ACTIVECONNECTION ),uno::UNO_QUERY); } // ----------------------------------------------------------------------------- void OAddFieldWindow::fillDescriptor(SvLBoxEntry* _pSelected,::svx::ODataAccessDescriptor& _rDescriptor) { if ( _pSelected && m_xColumns.is() ) { uno::Reference xChild(getConnection(),uno::UNO_QUERY); if ( xChild.is( ) ) { uno::Reference xDocument( xChild->getParent(), uno::UNO_QUERY ); if ( xDocument.is() ) { uno::Reference xModel(xDocument->getDatabaseDocument(),uno::UNO_QUERY); if ( xModel.is() ) _rDescriptor[ daDatabaseLocation ] <<= xModel->getURL(); } // if ( xDocument.is() ) } _rDescriptor[ ::svx::daCommand ] <<= GetCommand(); _rDescriptor[ ::svx::daCommandType ] <<= GetCommandType(); _rDescriptor[ ::svx::daEscapeProcessing ] <<= GetEscapeProcessing(); _rDescriptor[ ::svx::daConnection ] <<= getConnection(); ColumnInfo* pInfo = static_cast(_pSelected->GetUserData()); // ::rtl::OUString sColumnName = m_pListBox->GetEntryText( _pSelected ); _rDescriptor[ ::svx::daColumnName ] <<= pInfo->sColumnName; if ( m_xColumns->hasByName( pInfo->sColumnName ) ) _rDescriptor[ ::svx::daColumnObject ] <<= m_xColumns->getByName(pInfo->sColumnName); } } // ----------------------------------------------------------------------------- void OAddFieldWindow::_elementInserted( const container::ContainerEvent& _rEvent ) throw(::com::sun::star::uno::RuntimeException) { if ( m_pListBox.get() ) { ::rtl::OUString sName; if ( (_rEvent.Accessor >>= sName) && m_xColumns->hasByName(sName) ) { uno::Reference< beans::XPropertySet> xColumn(m_xColumns->getByName(sName),UNO_QUERY_THROW); ::rtl::OUString sLabel; if ( xColumn->getPropertySetInfo()->hasPropertyByName(PROPERTY_LABEL) ) xColumn->getPropertyValue(PROPERTY_LABEL) >>= sLabel; if ( sLabel.getLength() ) m_pListBox->InsertEntry( sLabel,NULL,sal_False,LIST_APPEND,new ColumnInfo(sName,sLabel) ); else m_pListBox->InsertEntry( sName,NULL,sal_False,LIST_APPEND,new ColumnInfo(sName,sLabel) ); } } } // ----------------------------------------------------------------------------- void OAddFieldWindow::_elementRemoved( const container::ContainerEvent& /*_rEvent*/ ) throw(::com::sun::star::uno::RuntimeException) { if ( m_pListBox.get() ) { m_pListBox->Clear(); if ( m_xColumns.is() ) lcl_addToList( *m_pListBox, m_xColumns ); } } // ----------------------------------------------------------------------------- void OAddFieldWindow::_elementReplaced( const container::ContainerEvent& /*_rEvent*/ ) throw(::com::sun::star::uno::RuntimeException) { } // ----------------------------------------------------------------------------- IMPL_LINK( OAddFieldWindow, OnSelectHdl, void* ,/*_pAddFieldDlg*/) { m_aActions.EnableItem(SID_ADD_CONTROL_PAIR, ( m_pListBox.get() && m_pListBox->GetSelectionCount() > 0 )); return 0L; } // ----------------------------------------------------------------------------- IMPL_LINK( OAddFieldWindow, OnDoubleClickHdl, void* ,/*_pAddFieldDlg*/) { if ( m_aCreateLink.IsSet() ) m_aCreateLink.Call(this); return 0L; } //------------------------------------------------------------------------------ ImageList OAddFieldWindow::getImageList(sal_Int16 _eBitmapSet,sal_Bool _bHiContast) const { sal_Int16 nN = IMG_ADDFIELD_DLG_SC; sal_Int16 nH = IMG_ADDFIELD_DLG_SCH; if ( _eBitmapSet == SFX_SYMBOLS_SIZE_LARGE ) { nN = IMG_ADDFIELD_DLG_LC; nH = IMG_ADDFIELD_DLG_LCH; } return ImageList(ModuleRes( _bHiContast ? nH : nN )); } //------------------------------------------------------------------ void OAddFieldWindow::resizeControls(const Size& _rDiff) { // we use large images so we must change them if ( _rDiff.Width() || _rDiff.Height() ) { Invalidate(); } } //------------------------------------------------------------------ IMPL_LINK( OAddFieldWindow, OnSortAction, ToolBox*, /*NOTINTERESTEDIN*/ ) { const sal_uInt16 nCurItem = m_aActions.GetCurItemId(); if ( SID_ADD_CONTROL_PAIR == nCurItem ) OnDoubleClickHdl(NULL); else { if ( SID_FM_REMOVE_FILTER_SORT == nCurItem || !m_aActions.IsItemChecked(nCurItem) ) { const sal_uInt16 nItemCount = m_aActions.GetItemCount(); for (sal_uInt16 j = 0; j< nItemCount; ++j) { const sal_uInt16 nItemId = m_aActions.GetItemId(j); if ( nCurItem != nItemId ) m_aActions.CheckItem(nItemId,sal_False); } SvSortMode eSortMode = SortNone; if ( SID_FM_REMOVE_FILTER_SORT != nCurItem ) { m_aActions.CheckItem(nCurItem,!m_aActions.IsItemChecked(nCurItem)); if ( m_aActions.IsItemChecked(SID_FM_SORTUP) ) eSortMode = SortAscending; else if ( m_aActions.IsItemChecked(SID_FM_SORTDOWN) ) eSortMode = SortDescending; } // if ( SID_FM_REMOVE_FILTER_SORT != nCurItem ) m_pListBox->GetModel()->SetSortMode(eSortMode); if ( SID_FM_REMOVE_FILTER_SORT == nCurItem ) Update(); m_pListBox->GetModel()->Resort(); } } return 0L; } // ----------------------------------------------------------------------------- // ============================================================================= } // namespace rptui // =============================================================================