LCOV - code coverage report
Current view: top level - sw/source/ui/dbui - selectdbtabledialog.cxx (source / functions) Hit Total Coverage
Test: commit e02a6cb2c3e2b23b203b422e4e0680877f232636 Lines: 0 97 0.0 %
Date: 2014-04-14 Functions: 0 7 0.0 %
Legend: Lines: hit not hit

          Line data    Source code
       1             : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
       2             : /*
       3             :  * This file is part of the LibreOffice project.
       4             :  *
       5             :  * This Source Code Form is subject to the terms of the Mozilla Public
       6             :  * License, v. 2.0. If a copy of the MPL was not distributed with this
       7             :  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
       8             :  *
       9             :  * This file incorporates work covered by the following license notice:
      10             :  *
      11             :  *   Licensed to the Apache Software Foundation (ASF) under one or more
      12             :  *   contributor license agreements. See the NOTICE file distributed
      13             :  *   with this work for additional information regarding copyright
      14             :  *   ownership. The ASF licenses this file to you under the Apache
      15             :  *   License, Version 2.0 (the "License"); you may not use this file
      16             :  *   except in compliance with the License. You may obtain a copy of
      17             :  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
      18             :  */
      19             : 
      20             : #include <swtypes.hxx>
      21             : #include <selectdbtabledialog.hxx>
      22             : #include <dbtablepreviewdialog.hxx>
      23             : #include "svtools/treelistentry.hxx"
      24             : #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
      25             : #include <com/sun/star/sdb/XQueriesSupplier.hpp>
      26             : #include <com/sun/star/beans/XPropertySet.hpp>
      27             : #include <com/sun/star/beans/PropertyValue.hpp>
      28             : #include <com/sun/star/container/XChild.hpp>
      29             : #include <com/sun/star/sdbc/XDataSource.hpp>
      30             : 
      31             : #include <unomid.h>
      32             : 
      33             : #include <selectdbtabledialog.hrc>
      34             : #include <dbui.hrc>
      35             : #include <helpid.h>
      36             : 
      37             : using namespace ::com::sun::star;
      38             : using namespace ::com::sun::star::sdbcx;
      39             : using namespace ::com::sun::star::sdbc;
      40             : using namespace ::com::sun::star::sdb;
      41             : using namespace ::com::sun::star::uno;
      42             : using namespace ::com::sun::star::container;
      43             : using namespace ::com::sun::star::beans;
      44             : 
      45           0 : SwSelectDBTableDialog::SwSelectDBTableDialog(Window* pParent,
      46             :         const uno::Reference< sdbc::XConnection>& rConnection) :
      47             :     SfxModalDialog(pParent, SW_RES(DLG_MM_SELECTDBTABLEDDIALOG)),
      48             :     m_aSelectFI( this, SW_RES(       FI_SELECT     )),
      49             :     m_aTableHB( this, WB_BUTTONSTYLE | WB_BOTTOMBORDER),
      50             :     m_aTableLB( this, SW_RES(        LB_TABLE      )),
      51             :     m_aPreviewPB( this, SW_RES(      PB_PREVIEW    )),
      52             :     m_aSeparatorFL(this, SW_RES(    FL_SEPARATOR      )),
      53             :     m_aOK( this, SW_RES(             PB_OK         )),
      54             :     m_aCancel( this, SW_RES(         PB_CANCEL     )),
      55             :     m_aHelp( this, SW_RES(           PB_HELP       )),
      56             :     m_sName( SW_RES( ST_NAME )),
      57             :     m_sType( SW_RES( ST_TYPE )),
      58             :     m_sTable( SW_RES( ST_TABLE )),
      59             :     m_sQuery( SW_RES( ST_QUERY )),
      60           0 :     m_xConnection(rConnection)
      61             : {
      62           0 :     FreeResource();
      63             : 
      64           0 :     Size aLBSize(m_aTableLB.GetSizePixel());
      65           0 :     m_aTableHB.SetSizePixel(aLBSize);
      66           0 :     Size aHeadSize(m_aTableHB.CalcWindowSizePixel());
      67           0 :     aHeadSize.Width() = aLBSize.Width();
      68           0 :     m_aTableHB.SetSizePixel(aHeadSize);
      69           0 :     Point aLBPos(m_aTableLB.GetPosPixel());
      70           0 :     m_aTableHB.SetPosPixel(aLBPos);
      71           0 :     aLBPos.Y() += aHeadSize.Height();
      72           0 :     aLBSize.Height() -= aHeadSize.Height();
      73           0 :     m_aTableLB.SetPosSizePixel(aLBPos, aLBSize);
      74             : 
      75           0 :     Size aSz(m_aTableHB.GetOutputSizePixel());
      76             :     m_aTableHB.InsertItem( 1, m_sName,
      77           0 :                             aSz.Width()/2,
      78           0 :                             HIB_LEFT | HIB_VCENTER /*| HIB_CLICKABLE | HIB_UPARROW */);
      79             :     m_aTableHB.InsertItem( 2, m_sType,
      80           0 :                             aSz.Width()/2,
      81           0 :                             HIB_LEFT | HIB_VCENTER /*| HIB_CLICKABLE | HIB_UPARROW */);
      82           0 :     m_aTableHB.SetHelpId(HID_MM_ADDRESSLIST_HB );
      83           0 :     m_aTableHB.Show();
      84             : 
      85           0 :     static long nTabs[] = {3, 0, aSz.Width()/2, aSz.Width() };
      86           0 :     m_aTableLB.SetTabs(&nTabs[0], MAP_PIXEL);
      87           0 :     m_aTableLB.SetHelpId(HID_MM_SELECTDBTABLEDDIALOG_LISTBOX);
      88           0 :     m_aTableLB.SetStyle( m_aTableLB.GetStyle() | WB_CLIPCHILDREN );
      89           0 :     m_aTableLB.SetSpaceBetweenEntries(3);
      90           0 :     m_aTableLB.SetSelectionMode( SINGLE_SELECTION );
      91           0 :     m_aTableLB.SetDragDropMode( 0 );
      92           0 :     m_aTableLB.EnableAsyncDrag(false);
      93             : 
      94           0 :     m_aPreviewPB.SetClickHdl(LINK(this, SwSelectDBTableDialog, PreviewHdl));
      95             : 
      96           0 :     Reference<XTablesSupplier> xTSupplier(m_xConnection, UNO_QUERY);
      97           0 :     if(xTSupplier.is())
      98             :     {
      99           0 :         Reference<XNameAccess> xTbls = xTSupplier->getTables();
     100           0 :         Sequence<OUString> aTbls = xTbls->getElementNames();
     101           0 :         const OUString* pTbls = aTbls.getConstArray();
     102           0 :         for(long i = 0; i < aTbls.getLength(); i++)
     103             :         {
     104           0 :             OUString sEntry = pTbls[i];
     105           0 :             sEntry += "\t";
     106           0 :             sEntry += m_sTable;
     107           0 :             SvTreeListEntry* pEntry = m_aTableLB.InsertEntry(sEntry);
     108           0 :             pEntry->SetUserData((void*)0);
     109           0 :         }
     110             :     }
     111           0 :     Reference<XQueriesSupplier> xQSupplier(m_xConnection, UNO_QUERY);
     112           0 :     if(xQSupplier.is())
     113             :     {
     114           0 :         Reference<XNameAccess> xQueries = xQSupplier->getQueries();
     115           0 :         Sequence<OUString> aQueries = xQueries->getElementNames();
     116           0 :         const OUString* pQueries = aQueries.getConstArray();
     117           0 :         for(long i = 0; i < aQueries.getLength(); i++)
     118             :         {
     119           0 :             OUString sEntry = pQueries[i];
     120           0 :             sEntry += "\t";
     121           0 :             sEntry += m_sQuery;
     122           0 :             SvTreeListEntry* pEntry = m_aTableLB.InsertEntry(sEntry);
     123           0 :             pEntry->SetUserData((void*)1);
     124           0 :         }
     125           0 :     }
     126           0 : }
     127             : 
     128           0 : SwSelectDBTableDialog::~SwSelectDBTableDialog()
     129             : {
     130           0 : }
     131             : 
     132           0 : IMPL_LINK(SwSelectDBTableDialog, PreviewHdl, PushButton*, pButton)
     133             : {
     134           0 :     SvTreeListEntry* pEntry = m_aTableLB.FirstSelected();
     135           0 :     if(pEntry)
     136             :     {
     137           0 :         OUString sTableOrQuery = m_aTableLB.GetEntryText(pEntry, 0);
     138           0 :         sal_Int32 nCommandType = 0 == pEntry->GetUserData() ? 0 : 1;
     139             : 
     140           0 :         OUString sDataSourceName;
     141           0 :         Reference<XChild> xChild(m_xConnection, UNO_QUERY);
     142           0 :         if(xChild.is())
     143             :         {
     144           0 :             Reference<XDataSource> xSource(xChild->getParent(), UNO_QUERY);
     145           0 :             Reference<XPropertySet> xPrSet(xSource, UNO_QUERY);
     146           0 :             xPrSet->getPropertyValue("Name") >>= sDataSourceName;
     147             :         }
     148             :         OSL_ENSURE(!sDataSourceName.isEmpty(), "no data source found");
     149           0 :         Sequence<PropertyValue> aProperties(5);
     150           0 :         PropertyValue* pProperties = aProperties.getArray();
     151           0 :         pProperties[0].Name = "DataSourceName";
     152           0 :         pProperties[0].Value <<= sDataSourceName;
     153           0 :         pProperties[1].Name = "Command";
     154           0 :         pProperties[1].Value <<= sTableOrQuery;
     155           0 :         pProperties[2].Name = "CommandType";
     156           0 :         pProperties[2].Value <<= nCommandType;
     157           0 :         pProperties[3].Name = "ShowTreeView";
     158           0 :         pProperties[3].Value <<= sal_False;
     159           0 :         pProperties[4].Name = "ShowTreeViewButton";
     160           0 :         pProperties[4].Value <<= sal_False;
     161             : 
     162           0 :         SwDBTablePreviewDialog* pDlg = new SwDBTablePreviewDialog(pButton, aProperties);
     163           0 :         pDlg->Execute();
     164           0 :         delete pDlg;
     165             :     }
     166             : 
     167           0 :     return 0;
     168             : }
     169             : 
     170           0 : OUString    SwSelectDBTableDialog::GetSelectedTable(bool& bIsTable)
     171             : {
     172           0 :     SvTreeListEntry* pEntry = m_aTableLB.FirstSelected();
     173           0 :     bIsTable = pEntry->GetUserData() ? false : true;
     174           0 :     return m_aTableLB.GetEntryText(pEntry, 0);
     175             : }
     176             : 
     177           0 : void   SwSelectDBTableDialog::SetSelectedTable(const OUString& rTable, bool bIsTable)
     178             : {
     179           0 :     SvTreeListEntry*    pEntry = m_aTableLB.First();
     180           0 :     while(pEntry)
     181             :     {
     182           0 :         if((m_aTableLB.GetEntryText(pEntry, 0) == rTable) &&
     183           0 :                  ((pEntry->GetUserData() == 0 ) == bIsTable))
     184             :         {
     185           0 :             m_aTableLB.Select(pEntry);
     186           0 :             break;
     187             :         }
     188           0 :         pEntry = m_aTableLB.Next( pEntry );
     189             :     }
     190           0 : }
     191             : 
     192             : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

Generated by: LCOV version 1.10