diff options
Diffstat (limited to 'dbaccess/source/ui/misc/WNameMatch.cxx')
-rw-r--r-- | dbaccess/source/ui/misc/WNameMatch.cxx | 453 |
1 files changed, 453 insertions, 0 deletions
diff --git a/dbaccess/source/ui/misc/WNameMatch.cxx b/dbaccess/source/ui/misc/WNameMatch.cxx new file mode 100644 index 000000000000..5b50a7e553cd --- /dev/null +++ b/dbaccess/source/ui/misc/WNameMatch.cxx @@ -0,0 +1,453 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2008 by Sun Microsystems, Inc. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * $RCSfile: WNameMatch.cxx,v $ + * $Revision: 1.26 $ + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +// MARKER(update_precomp.py): autogen include statement, do not remove +#include "precompiled_dbaccess.hxx" +#ifndef DBAUI_WIZ_NAMEMATCHING_HXX +#include "WNameMatch.hxx" +#endif +#ifndef _TOOLS_DEBUG_HXX +#include <tools/debug.hxx> +#endif +#ifndef DBAUI_FIELDDESCRIPTIONS_HXX +#include "FieldDescriptions.hxx" +#endif +#ifndef DBAUI_WIZ_COPYTABLEDIALOG_HXX +#include "WCopyTable.hxx" +#endif +#ifndef _DBA_DBACCESS_HELPID_HRC_ +#include "dbaccess_helpid.hrc" +#endif +#ifndef _DBU_MISC_HRC_ +#include "dbu_misc.hrc" +#endif +#ifndef DBAUI_WIZARD_PAGES_HRC +#include "WizardPages.hrc" +#endif +#ifndef _SV_SCRBAR_HXX +#include <vcl/scrbar.hxx> +#endif +#ifndef DBAUI_WIZ_COPYTABLEDIALOG_HXX +#include "WCopyTable.hxx" +#endif +#ifndef _COM_SUN_STAR_SDBC_DATATYPE_HPP_ +#include <com/sun/star/sdbc/DataType.hpp> +#endif + +using namespace ::dbaui; +//======================================================================== +// OWizColumnSelect +DBG_NAME(OWizNameMatching) +//======================================================================== +OWizNameMatching::OWizNameMatching( Window* pParent) + :OWizardPage( pParent, ModuleRes( TAB_WIZ_NAME_MATCHING ) ) + ,m_FT_TABLE_LEFT( this, ModuleRes( FT_TABLE_LEFT ) ) + ,m_FT_TABLE_RIGHT( this, ModuleRes( FT_TABLE_RIGHT ) ) + ,m_CTRL_LEFT( this, ModuleRes( CTRL_LEFT ) ) + ,m_CTRL_RIGHT( this, ModuleRes( CTRL_RIGHT ) ) + ,m_ibColumn_up( this, ModuleRes( IB_COLUMN_UP ) ) + ,m_ibColumn_down( this, ModuleRes( IB_COLUMN_DOWN ) ) + ,m_ibColumn_up_right( this, ModuleRes( IB_COLUMN_UP_RIGHT ) ) + ,m_ibColumn_down_right( this, ModuleRes( IB_COLUMN_DOWN_RIGHT ) ) + ,m_pbAll( this, ModuleRes( PB_ALL ) ) + ,m_pbNone( this, ModuleRes( PB_NONE ) ) + +{ + DBG_CTOR(OWizNameMatching,NULL); + + m_ibColumn_up.SetClickHdl(LINK(this,OWizNameMatching,ButtonClickHdl)); + m_ibColumn_down.SetClickHdl(LINK(this,OWizNameMatching,ButtonClickHdl)); + + m_ibColumn_up_right.SetClickHdl(LINK(this,OWizNameMatching,RightButtonClickHdl)); + m_ibColumn_down_right.SetClickHdl(LINK(this,OWizNameMatching,RightButtonClickHdl)); + + m_pbAll.SetClickHdl(LINK(this,OWizNameMatching,AllNoneClickHdl)); + m_pbNone.SetClickHdl(LINK(this,OWizNameMatching,AllNoneClickHdl)); + + m_CTRL_LEFT.SetSelectHdl(LINK(this,OWizNameMatching,TableListClickHdl)); + m_CTRL_RIGHT.SetSelectHdl(LINK(this,OWizNameMatching,TableListRightSelectHdl)); + m_CTRL_RIGHT.EnableCheckButton( NULL ); + + m_CTRL_LEFT.SetWindowBits( WB_FORCE_MAKEVISIBLE ); + m_CTRL_RIGHT.SetWindowBits( WB_FORCE_MAKEVISIBLE ); + + m_sSourceText = m_FT_TABLE_LEFT.GetText(); + m_sSourceText.AppendAscii("\n"); + m_sDestText = m_FT_TABLE_RIGHT.GetText(); + m_sDestText.AppendAscii("\n"); + + // set hiContrast + m_ibColumn_up.SetModeImage(ModuleRes(IMG_SORTUP_H),BMP_COLOR_HIGHCONTRAST); + m_ibColumn_down.SetModeImage(ModuleRes(IMG_SORTDOWN_H),BMP_COLOR_HIGHCONTRAST); + m_ibColumn_up_right.SetModeImage(ModuleRes(IMG_SORTUP_H),BMP_COLOR_HIGHCONTRAST); + m_ibColumn_down_right.SetModeImage(ModuleRes(IMG_SORTDOWN_H),BMP_COLOR_HIGHCONTRAST); + + FreeResource(); +} +// ----------------------------------------------------------------------- +OWizNameMatching::~OWizNameMatching() +{ + DBG_DTOR(OWizNameMatching,NULL); +} + +// ----------------------------------------------------------------------- +void OWizNameMatching::Reset() +{ + // urspr"unglichen zustand wiederherstellen + DBG_CHKTHIS(OWizNameMatching,NULL); + // the left tree contains bitmaps so i need to resize the right one + if(m_bFirstTime) + { + m_CTRL_RIGHT.SetReadOnly(); // sets autoinc to readonly + m_CTRL_RIGHT.SetEntryHeight(m_CTRL_LEFT.GetEntryHeight()); + m_CTRL_RIGHT.SetIndent(m_CTRL_LEFT.GetIndent()); + m_CTRL_RIGHT.SetSpaceBetweenEntries(m_CTRL_LEFT.GetSpaceBetweenEntries()); + + m_bFirstTime = sal_False; + } + + // m_CTRL_LEFT.Clear(); +} +// ----------------------------------------------------------------------- +void OWizNameMatching::ActivatePage( ) +{ + DBG_CHKTHIS(OWizNameMatching,NULL); + + // set source table name + String aName = m_sSourceText; + aName += String(m_pParent->m_sSourceName); + + m_FT_TABLE_LEFT.SetText(aName); + + // set dest table name + aName = m_sDestText; + aName += String(m_pParent->m_sName); + m_FT_TABLE_RIGHT.SetText(aName); + + + m_CTRL_LEFT.FillListBox(*m_pParent->getSrcVector()); + m_CTRL_RIGHT.FillListBox(*m_pParent->getDestVector()); + + m_ibColumn_up.Enable( m_CTRL_LEFT.GetEntryCount() > 1 ); + m_ibColumn_down.Enable( m_CTRL_LEFT.GetEntryCount() > 1 ); + + m_ibColumn_up_right.Enable( m_CTRL_RIGHT.GetEntryCount() > 1 ); + m_ibColumn_down_right.Enable( m_CTRL_RIGHT.GetEntryCount() > 1 ); + + + m_pParent->EnableButton(OCopyTableWizard::WIZARD_NEXT,sal_False); + m_CTRL_LEFT.GrabFocus(); +} +// ----------------------------------------------------------------------- +sal_Bool OWizNameMatching::LeavePage() +{ + DBG_CHKTHIS(OWizNameMatching,NULL); + + const ODatabaseExport::TColumnVector* pSrcColumns = m_pParent->getSrcVector(); + + m_pParent->m_vColumnPos.clear(); + m_pParent->m_vColumnTypes.clear(); + m_pParent->m_vColumnPos.resize( pSrcColumns->size(), ODatabaseExport::TPositions::value_type( COLUMN_POSITION_NOT_FOUND, COLUMN_POSITION_NOT_FOUND ) ); + m_pParent->m_vColumnTypes.resize( pSrcColumns->size(), COLUMN_POSITION_NOT_FOUND ); + + + sal_Int32 nParamPos = 0; + SvLBoxEntry* pLeftEntry = m_CTRL_LEFT.GetModel()->First(); + SvLBoxEntry* pRightEntry = m_CTRL_RIGHT.GetModel()->First(); + while(pLeftEntry && pRightEntry) + { + OFieldDescription* pSrcField = static_cast<OFieldDescription*>(pLeftEntry->GetUserData()); + DBG_ASSERT(pSrcField,"OWizNameMatching: OColumn can not be null!"); + + ODatabaseExport::TColumnVector::const_iterator aSrcIter = pSrcColumns->begin(); + ODatabaseExport::TColumnVector::const_iterator aSrcEnd = pSrcColumns->end(); + for(;aSrcIter != aSrcEnd && (*aSrcIter)->second != pSrcField;++aSrcIter) + ; + const sal_Int32 nPos = ::std::distance(pSrcColumns->begin(),aSrcIter); + + // sal_Int32 nPos = m_CTRL_LEFT.GetModel()->GetAbsPos(pLeftEntry); + if(m_CTRL_LEFT.GetCheckButtonState(pLeftEntry) == SV_BUTTON_CHECKED) + { + OFieldDescription* pDestField = static_cast<OFieldDescription*>(pRightEntry->GetUserData()); + DBG_ASSERT(pDestField,"OWizNameMatching: OColumn can not be null!"); + const ODatabaseExport::TColumnVector* pDestColumns = m_pParent->getDestVector(); + ODatabaseExport::TColumnVector::const_iterator aDestIter = pDestColumns->begin(); + ODatabaseExport::TColumnVector::const_iterator aDestEnd = pDestColumns->end(); + + for(;aDestIter != aDestEnd && (*aDestIter)->second != pDestField;++aDestIter) + ; + + OSL_ENSURE((nPos) < static_cast<sal_Int32>(m_pParent->m_vColumnPos.size()),"m_pParent->m_vColumnPos: Illegal index for vector"); + m_pParent->m_vColumnPos[nPos].first = ++nParamPos; + m_pParent->m_vColumnPos[nPos].second = ::std::distance(pDestColumns->begin(),aDestIter) + 1; + sal_Bool bNotConvert = sal_True; + TOTypeInfoSP pTypeInfo = m_pParent->convertType((*aDestIter)->second->getSpecialTypeInfo(),bNotConvert); + sal_Int32 nType = ::com::sun::star::sdbc::DataType::VARCHAR; + if ( pTypeInfo.get() ) + nType = pTypeInfo->nType; + m_pParent->m_vColumnTypes[nPos] = nType; + } + else + { + m_pParent->m_vColumnPos[nPos].first = COLUMN_POSITION_NOT_FOUND; + m_pParent->m_vColumnPos[nPos].second = COLUMN_POSITION_NOT_FOUND; + } + + pLeftEntry = m_CTRL_LEFT.GetModel()->Next(pLeftEntry); + pRightEntry = m_CTRL_RIGHT.GetModel()->Next(pRightEntry); + } + + return sal_True; +} +// ----------------------------------------------------------------------- +String OWizNameMatching::GetTitle() const { return String(ModuleRes(STR_WIZ_NAME_MATCHING_TITEL)); } +// ----------------------------------------------------------------------- +IMPL_LINK( OWizNameMatching, ButtonClickHdl, Button *, pButton ) +{ + SvLBoxEntry* pEntry = m_CTRL_LEFT.FirstSelected(); + if ( pEntry ) + { + sal_Int32 nPos = m_CTRL_LEFT.GetModel()->GetAbsPos(pEntry); + if(pButton == &m_ibColumn_up && nPos) + --nPos; + else if(pButton == &m_ibColumn_down) + nPos += 2; + + m_CTRL_LEFT.ModelIsMoving(pEntry,NULL,nPos); + m_CTRL_LEFT.GetModel()->Move(pEntry,NULL,nPos); + m_CTRL_LEFT.ModelHasMoved(pEntry); + + long nThumbPos = m_CTRL_LEFT.GetVScroll()->GetThumbPos(); + long nVisibleSize = m_CTRL_LEFT.GetVScroll()->GetVisibleSize(); + + if(pButton == &m_ibColumn_down && (nThumbPos+nVisibleSize+1) < nPos) + { + m_CTRL_LEFT.GetVScroll()->DoScrollAction(SCROLL_LINEDOWN); + // m_CTRL_LEFT.MakeVisible(pEntry,sal_True); + } + + TableListClickHdl(&m_CTRL_LEFT); + } + + + return 0; +} +//------------------------------------------------------------------------------ +IMPL_LINK( OWizNameMatching, RightButtonClickHdl, Button *, pButton ) +{ + SvLBoxEntry* pEntry = m_CTRL_RIGHT.FirstSelected(); + if ( pEntry ) + { + sal_Int32 nPos = m_CTRL_RIGHT.GetModel()->GetAbsPos(pEntry); + if(pButton == &m_ibColumn_up_right && nPos) + --nPos; + else if(pButton == &m_ibColumn_down_right) + nPos += 2; + + m_CTRL_RIGHT.ModelIsMoving(pEntry,NULL,nPos); + m_CTRL_RIGHT.GetModel()->Move(pEntry,NULL,nPos); + m_CTRL_RIGHT.ModelHasMoved(pEntry); + long nThumbPos = m_CTRL_RIGHT.GetVScroll()->GetThumbPos(); + long nVisibleSize = m_CTRL_RIGHT.GetVScroll()->GetVisibleSize(); + + if(pButton == &m_ibColumn_down_right && (nThumbPos+nVisibleSize+1) < nPos) + m_CTRL_RIGHT.GetVScroll()->DoScrollAction(SCROLL_LINEDOWN); + TableListRightSelectHdl(&m_CTRL_RIGHT); + } + return 0; +} +//------------------------------------------------------------------------------ +IMPL_LINK( OWizNameMatching, TableListClickHdl, void*, /*NOTINTERESTEDIN*/ ) +{ + SvLBoxEntry* pEntry = m_CTRL_LEFT.FirstSelected(); + if(pEntry) + { + ULONG nPos = m_CTRL_LEFT.GetModel()->GetAbsPos(pEntry); + SvLBoxEntry* pOldEntry = m_CTRL_RIGHT.FirstSelected(); + if(pOldEntry && nPos != m_CTRL_RIGHT.GetModel()->GetAbsPos(pOldEntry)) + { + if(pOldEntry) + m_CTRL_RIGHT.Select(pOldEntry,sal_False); + pOldEntry = m_CTRL_RIGHT.GetEntry(nPos); + if(pOldEntry) + { + ULONG nNewPos = m_CTRL_LEFT.GetModel()->GetAbsPos(m_CTRL_LEFT.GetFirstEntryInView()); + if ( nNewPos - nPos == 1 ) + --nNewPos; + m_CTRL_RIGHT.MakeVisible(m_CTRL_RIGHT.GetEntry(nNewPos),sal_True); + m_CTRL_RIGHT.Select(pOldEntry,sal_True); + } + } + else if(!pOldEntry) + { + pOldEntry = m_CTRL_RIGHT.GetEntry(nPos); + if(pOldEntry) + { + m_CTRL_RIGHT.Select(pOldEntry,sal_True); + } + } + } + + return 0; +} +//------------------------------------------------------------------------------ +IMPL_LINK( OWizNameMatching, TableListRightSelectHdl, void*, /*NOTINTERESTEDIN*/ ) +{ + SvLBoxEntry* pEntry = m_CTRL_RIGHT.FirstSelected(); + if(pEntry) + { + ULONG nPos = m_CTRL_RIGHT.GetModel()->GetAbsPos(pEntry); + SvLBoxEntry* pOldEntry = m_CTRL_LEFT.FirstSelected(); + if(pOldEntry && nPos != m_CTRL_LEFT.GetModel()->GetAbsPos(pOldEntry)) + { + if(pOldEntry) + m_CTRL_LEFT.Select(pOldEntry,sal_False); + pOldEntry = m_CTRL_LEFT.GetEntry(nPos); + if(pOldEntry) + { + ULONG nNewPos = m_CTRL_RIGHT.GetModel()->GetAbsPos(m_CTRL_RIGHT.GetFirstEntryInView()); + if ( nNewPos - nPos == 1 ) + nNewPos--; + m_CTRL_LEFT.MakeVisible(m_CTRL_LEFT.GetEntry(nNewPos),sal_True); + m_CTRL_LEFT.Select(pOldEntry,sal_True); + } + } + else if(!pOldEntry) + { + pOldEntry = m_CTRL_LEFT.GetEntry(nPos); + if(pOldEntry) + { + m_CTRL_LEFT.Select(pOldEntry,sal_True); + } + } + } + + return 0; +} +// ----------------------------------------------------------------------- +IMPL_LINK( OWizNameMatching, AllNoneClickHdl, Button *, pButton ) +{ + sal_Bool bAll = pButton == &m_pbAll; + SvLBoxEntry* pEntry = m_CTRL_LEFT.First(); + while(pEntry) + { + m_CTRL_LEFT.SetCheckButtonState( pEntry, bAll ? SV_BUTTON_CHECKED : SV_BUTTON_UNCHECKED); + pEntry = m_CTRL_LEFT.Next(pEntry); + } + + return 0; +} +// ----------------------------------------------------------------------- +//======================================================================== +// class OColumnString +//======================================================================== +class OColumnString : public SvLBoxString +{ + sal_Bool m_bReadOnly; +public: + OColumnString( SvLBoxEntry* pEntry, sal_uInt16 nFlags, const String& rStr,sal_Bool _RO) + :SvLBoxString(pEntry,nFlags,rStr) + ,m_bReadOnly(_RO) + { + } + + virtual void Paint(const Point& rPos, SvLBox& rDev, sal_uInt16 nFlags, SvLBoxEntry* pEntry); + //virtual void InitViewData( SvLBox* pView,SvLBoxEntry* pEntry, SvViewDataItem* pViewData); +}; + + + +//------------------------------------------------------------------------ +/* +void OColumnString::InitViewData( SvLBox* pView,SvLBoxEntry* pEntry, SvViewDataItem* pViewData) +{ + SvLBoxString::InitViewData(pView,pEntry,pViewData); +} +*/ +//------------------------------------------------------------------------ +void OColumnString::Paint(const Point& rPos, SvLBox& rDev, sal_uInt16 /*nFlags*/, SvLBoxEntry* /*pEntry*/ ) +{ + if(m_bReadOnly) + { + const StyleSettings& rStyleSettings = rDev.GetSettings().GetStyleSettings(); + rDev.SetTextColor( rStyleSettings.GetDisableColor() ); + rDev.SetTextFillColor( rStyleSettings.GetFieldColor() ); + } + rDev.DrawText( rPos, GetText() ); +} +//======================================================================== +OColumnTreeBox::OColumnTreeBox( Window* pParent, const ResId& rResId ) + : OMarkableTreeListBox(pParent,NULL,rResId) +{ + SetDragDropMode( 0 ); + EnableInplaceEditing( sal_False ); + SetWindowBits(WB_BORDER | WB_HASBUTTONS | WB_HSCROLL); + SetSelectionMode( SINGLE_SELECTION ); +} +//------------------------------------------------------------------------ +void OColumnTreeBox::InitEntry(SvLBoxEntry* pEntry, const String& rStr, const Image& rImg1, const Image& rImg2, SvLBoxButtonKind eButtonKind) +{ + DBTreeListBox::InitEntry( pEntry, rStr, rImg1, rImg2, eButtonKind ); + SvLBoxString* pString = new OColumnString(pEntry, 0, rStr,sal_False); + if (pString) + pEntry->ReplaceItem( pString, pEntry->ItemCount() - 1 ); +} +//------------------------------------------------------------------------ +sal_Bool OColumnTreeBox::Select( SvLBoxEntry* pEntry, sal_Bool bSelect ) +{ + if(bSelect) + { + OFieldDescription* pColumn = static_cast<OFieldDescription*>(pEntry->GetUserData()); + if(!(pColumn->IsAutoIncrement() && m_bReadOnly)) + bSelect = DBTreeListBox::Select( pEntry,bSelect ); + } + else + bSelect = DBTreeListBox::Select( pEntry,bSelect ); + return bSelect; +} +//------------------------------------------------------------------------ +void OColumnTreeBox::FillListBox( const ODatabaseExport::TColumnVector& _rList) +{ + Clear(); + ODatabaseExport::TColumnVector::const_iterator aIter = _rList.begin(); + ODatabaseExport::TColumnVector::const_iterator aEnd = _rList.end(); + for(;aIter != aEnd;++aIter) + { + SvLBoxEntry* pEntry = InsertEntry((*aIter)->first,0,sal_False,LIST_APPEND,(*aIter)->second); + SvButtonState eState = !(m_bReadOnly && (*aIter)->second->IsAutoIncrement()) ? SV_BUTTON_CHECKED : SV_BUTTON_UNCHECKED; + SetCheckButtonState( pEntry, eState ); + } +} +// ----------------------------------------------------------------------------- + + + + + |