reportdesign/source/ui/dlg/Formula.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: formula.cxx,v $
  10  * $Revision: 1.19 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_reportdesign.hxx"
  33
  34
  35 //----------------------------------------------------------------------------
  36
  37 #include <vcl/svapp.hxx>
  38 #include <vcl/mnemonic.hxx>
  39 #include <vcl/msgbox.hxx>
  40 #include <unotools/charclass.hxx>
  41 #include <svtools/viewoptions.hxx>
  42 #include <tools/urlobj.hxx>
  43 #include <formula/formdata.hxx>
  44 #include <formula/funcutl.hxx>
  45 #include <formula/tokenarray.hxx>
  46
  47 #include "Formula.hxx"
  48 #include "AddField.hxx"
  49 #include "helpids.hrc"
  50
  51 //============================================================================
  52 namespace rptui
  53 {
  54     using namespace formula;
  55     using namespace ::com::sun::star;
  56
  57 //      --------------------------------------------------------------------------
  58 //              Initialisierung / gemeinsame Funktionen  fuer Dialog
  59 //      --------------------------------------------------------------------------
  60
  61 FormulaDialog::FormulaDialog(Window* pParent
  62                              , const uno::Reference<lang::XMultiServiceFactory>& _xServiceFactory
  63                              , const ::boost::shared_ptr< IFunctionManager >&  _pFunctionMgr
  64                              , const ::rtl::OUString& _sFormula
  65                              , const ::com::sun::star::uno::Reference < ::com::sun::star::beans::XPropertySet >& _xRowSet)
  66     : FormulaModalDialog( pParent, false,false,false,this,_pFunctionMgr.get(),this)
  67     ,m_aFunctionManager(_pFunctionMgr)
  68     ,m_pFormulaData(new FormEditData())
  69     ,m_pAddField(NULL)
  70     ,m_xRowSet(_xRowSet)
  71     ,m_pEdit(NULL)
  72     ,m_sFormula(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("=")))
  73     ,m_nStart(0)
  74     ,m_nEnd(1)
  75 {
  76     if ( _sFormula.getLength() > 0 )
  77     {
  78         if ( _sFormula.getStr()[0] != '=' )
  79             m_sFormula += String(_sFormula);
  80         else
  81             m_sFormula = _sFormula;
  82     }
  83     m_xParser.set(_xServiceFactory->createInstance(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.report.pentaho.SOFormulaParser"))),uno::UNO_QUERY);
  84     if ( m_xParser.is() )
  85         m_xOpCodeMapper = m_xParser->getFormulaOpCodeMapper();
  86     fill();
  87 }
  88
  89 void FormulaDialog::notifyChange()
  90 {
  91 }
  92 // -----------------------------------------------------------------------------
  93 void FormulaDialog::fill()
  94 {
  95     SetMeText(m_sFormula);
  96     Update(m_sFormula);
  97     CheckMatrix(m_sFormula);
  98     Update();
  99 }
 100
 101 FormulaDialog::~FormulaDialog()
 102 {
 103     if ( m_pAddField )
 104     {
 105         SvtViewOptions aDlgOpt( E_WINDOW, String::CreateFromInt32( HID_RPT_FIELD_SEL_WIN ) );
 106         aDlgOpt.SetWindowState( ::rtl::OUString::createFromAscii( m_pAddField->GetWindowState((WINDOWSTATE_MASK_X | WINDOWSTATE_MASK_Y | WINDOWSTATE_MASK_STATE | WINDOWSTATE_MASK_MINIMIZED)).GetBuffer() ) );
 107
 108         ::std::auto_ptr<Window> aTemp2(m_pAddField);
 109         m_pAddField = NULL;
 110     }
 111 }
 112
 113 //      --------------------------------------------------------------------------
 114 //                                                      Funktionen fuer rechte Seite
 115 //      --------------------------------------------------------------------------
 116 bool FormulaDialog::calculateValue( const String& rStrExp, String& rStrResult )
 117 {
 118     rStrResult = rStrExp;
 119     return false;
 120 }
 121 void FormulaDialog::doClose(BOOL _bOk)
 122 {
 123     EndDialog(_bOk ? RET_OK : RET_CANCEL);
 124 }
 125 void FormulaDialog::insertEntryToLRUList(const IFunctionDescription*    /*_pDesc*/)
 126 {
 127 }
 128 void FormulaDialog::showReference(const String& /*_sFormula*/)
 129 {
 130 }
 131 void FormulaDialog::dispatch(BOOL /*_bOK*/,BOOL /*_bMartixChecked*/)
 132 {
 133 }
 134 void FormulaDialog::setDispatcherLock( BOOL /*bLock*/ )
 135 {
 136 }
 137 void FormulaDialog::setReferenceInput(const FormEditData* /*_pData*/)
 138 {
 139 }
 140 void FormulaDialog::deleteFormData()
 141 {
 142 }
 143 void FormulaDialog::clear()
 144 {
 145 }
 146 void FormulaDialog::switchBack()
 147 {
 148 }
 149 FormEditData* FormulaDialog::getFormEditData() const
 150 {
 151     return m_pFormulaData;
 152 }
 153 void FormulaDialog::setCurrentFormula(const String& _sReplacement)
 154 {
 155     const xub_StrLen nOldLen = m_nEnd - m_nStart;
 156     const xub_StrLen nNewLen = _sReplacement.Len();
 157     if (nOldLen)
 158         m_sFormula.Erase( m_nStart, nOldLen );
 159     if (nNewLen)
 160         m_sFormula.Insert( _sReplacement, m_nStart );
 161     m_nEnd = m_nStart + nNewLen;
 162 }
 163 void FormulaDialog::setSelection(xub_StrLen _nStart,xub_StrLen _nEnd)
 164 {
 165     if ( _nStart <= _nEnd )
 166     {
 167         m_nStart = _nStart;
 168         m_nEnd = _nEnd;
 169     }
 170     else
 171     {
 172         m_nEnd = _nStart;
 173         m_nStart = _nEnd;
 174     }
 175 }
 176 void FormulaDialog::getSelection(xub_StrLen& _nStart,xub_StrLen& _nEnd) const
 177 {
 178     _nStart = m_nStart;
 179     _nEnd = m_nEnd;
 180 }
 181 String FormulaDialog::getCurrentFormula() const
 182 {
 183     return m_sFormula;
 184 }
 185 IFunctionManager* FormulaDialog::getFunctionManager()
 186 {
 187     return m_aFunctionManager.get();
 188 }
 189 // -----------------------------------------------------------------------------
 190 void FormulaDialog::ShowReference(const String& /*_sRef*/)
 191 {
 192 }
 193 // -----------------------------------------------------------------------------
 194 void FormulaDialog::HideReference( BOOL /*bDoneRefMode*/)
 195 {
 196 }
 197 // -----------------------------------------------------------------------------
 198 void FormulaDialog::ReleaseFocus( RefEdit* /*pEdit*/, RefButton* /*pButton*/)
 199 {
 200 }
 201 // -----------------------------------------------------------------------------
 202 void FormulaDialog::ToggleCollapsed( RefEdit* _pEdit, RefButton* _pButton)
 203 {
 204     ::std::pair<RefButton*,RefEdit*> aPair = RefInputStartBefore( _pEdit, _pButton );
 205     m_pEdit = aPair.second;
 206     if ( m_pEdit )
 207         m_pEdit->Hide();
 208     if ( aPair.first )
 209         aPair.first->Hide();
 210
 211     if ( !m_pAddField )
 212     {
 213         m_pAddField = new OAddFieldWindow(this,m_xRowSet);
 214         m_pAddField->SetCreateHdl(LINK( this, FormulaDialog, OnClickHdl ) );
 215         SvtViewOptions aDlgOpt( E_WINDOW, String::CreateFromInt32( HID_RPT_FIELD_SEL_WIN ) );
 216         if ( aDlgOpt.Exists() )
 217         {
 218             m_pAddField->SetWindowState( ByteString( aDlgOpt.GetWindowState().getStr(), RTL_TEXTENCODING_ASCII_US ) );
 219
 220         }
 221
 222         m_pAddField->Update();
 223     } // if ( !m_pAddField )
 224     RefInputStartAfter( aPair.second, aPair.first );
 225     m_pAddField->Show();
 226
 227 }
 228 // -----------------------------------------------------------------------------
 229 IMPL_LINK( FormulaDialog, OnClickHdl, OAddFieldWindow* ,_pAddFieldDlg)
 230 {
 231     const uno::Sequence< beans::PropertyValue > aArgs = _pAddFieldDlg->getSelectedFieldDescriptors();
 232     // we use this way to create undo actions
 233     if ( m_pEdit && aArgs.getLength() == 1)
 234     {
 235         uno::Sequence< beans::PropertyValue > aValue;
 236         aArgs[0].Value >>= aValue;
 237         ::svx::ODataAccessDescriptor aDescriptor(aValue);
 238         ::rtl::OUString sName;
 239         aDescriptor[ ::svx::daColumnName ] >>= sName;
 240         if ( sName.getLength() )
 241         {
 242             sName = ::rtl::OUString (RTL_CONSTASCII_USTRINGPARAM("[")) + sName + ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("]"));
 243             m_pEdit->SetText(sName);
 244         }
 245     } // if ( m_pEdit && aArgs.getLength() )
 246     m_pEdit = NULL;
 247     _pAddFieldDlg->Hide();
 248     RefInputDoneAfter( TRUE );
 249
 250     return 0L;
 251 }
 252 // -----------------------------------------------------------------------------
 253 uno::Reference< sheet::XFormulaParser> FormulaDialog::getFormulaParser() const
 254 {
 255     return m_xParser.get();
 256 }
 257 // -----------------------------------------------------------------------------
 258 uno::Reference< sheet::XFormulaOpCodeMapper> FormulaDialog::getFormulaOpCodeMapper() const
 259 {
 260     return m_xOpCodeMapper;
 261 }
 262 // -----------------------------------------------------------------------------
 263 table::CellAddress FormulaDialog::getReferencePosition() const
 264 {
 265     return table::CellAddress();
 266 }
 267 // -----------------------------------------------------------------------------
 268 ::std::auto_ptr<formula::FormulaTokenArray> FormulaDialog::convertToTokenArray(const uno::Sequence< sheet::FormulaToken >& _aTokenList)
 269 {
 270     ::std::auto_ptr<formula::FormulaTokenArray> pArray(new FormulaTokenArray());
 271     pArray->Fill(_aTokenList, NULL);
 272     return pArray;
 273 }
 274 // =============================================================================
 275 } // rptui
 276 // =============================================================================