/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * 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 . */ #include "queryparam.hxx" #include "queryentry.hxx" #include "scmatrix.hxx" #include #include #include namespace { const size_t MAXQUERY = 8; class FindByField : public std::unary_function { SCCOLROW mnField; public: FindByField(SCCOLROW nField) : mnField(nField) {} bool operator() (const ScQueryEntry& rEntry) const { return rEntry.bDoQuery && rEntry.nField == mnField; } }; struct FindUnused : public std::unary_function { bool operator() (const ScQueryEntry& rEntry) const { return !rEntry.bDoQuery; } }; } ScQueryParamBase::const_iterator ScQueryParamBase::begin() const { return maEntries.begin(); } ScQueryParamBase::const_iterator ScQueryParamBase::end() const { return maEntries.end(); } ScQueryParamBase::ScQueryParamBase() : bHasHeader(true), bByRow(true), bInplace(true), bCaseSens(false), bRegExp(false), bDuplicate(false), mbRangeLookup(false) { for (size_t i = 0; i < MAXQUERY; ++i) maEntries.push_back(new ScQueryEntry); } ScQueryParamBase::ScQueryParamBase(const ScQueryParamBase& r) : bHasHeader(r.bHasHeader), bByRow(r.bByRow), bInplace(r.bInplace), bCaseSens(r.bCaseSens), bRegExp(r.bRegExp), bDuplicate(r.bDuplicate), mbRangeLookup(r.mbRangeLookup), maEntries(r.maEntries) { } ScQueryParamBase::~ScQueryParamBase() { } bool ScQueryParamBase::IsValidFieldIndex() const { return true; } SCSIZE ScQueryParamBase::GetEntryCount() const { return maEntries.size(); } const ScQueryEntry& ScQueryParamBase::GetEntry(SCSIZE n) const { return maEntries[n]; } ScQueryEntry& ScQueryParamBase::GetEntry(SCSIZE n) { return maEntries[n]; } ScQueryEntry& ScQueryParamBase::AppendEntry() { // Find the first unused entry. EntriesType::iterator itr = std::find_if( maEntries.begin(), maEntries.end(), FindUnused()); if (itr != maEntries.end()) // Found! return *itr; // Add a new entry to the end. maEntries.push_back(new ScQueryEntry); return maEntries.back(); } ScQueryEntry* ScQueryParamBase::FindEntryByField(SCCOLROW nField, bool bNew) { EntriesType::iterator itr = std::find_if( maEntries.begin(), maEntries.end(), FindByField(nField)); if (itr != maEntries.end()) { // existing entry found! return &(*itr); } if (!bNew) // no existing entry found, and we are not creating a new one. return NULL; return &AppendEntry(); } void ScQueryParamBase::RemoveEntryByField(SCCOLROW nField) { EntriesType::iterator itr = std::find_if( maEntries.begin(), maEntries.end(), FindByField(nField)); if (itr != maEntries.end()) { maEntries.erase(itr); if (maEntries.size() < MAXQUERY) // Make sure that we have at least MAXQUERY number of entries at // all times. maEntries.push_back(new ScQueryEntry); } } void ScQueryParamBase::Resize(size_t nNew) { if (nNew < MAXQUERY) nNew = MAXQUERY; // never less than MAXQUERY if (nNew < maEntries.size()) { size_t n = maEntries.size() - nNew; for (size_t i = 0; i < n; ++i) maEntries.pop_back(); } else if (nNew > maEntries.size()) { size_t n = nNew - maEntries.size(); for (size_t i = 0; i < n; ++i) maEntries.push_back(new ScQueryEntry); } } void ScQueryParamBase::FillInExcelSyntax( svl::SharedStringPool& rPool, const OUString& rStr, SCSIZE nIndex, SvNumberFormatter* pFormatter ) { const OUString aCellStr = rStr; if (nIndex >= maEntries.size()) Resize(nIndex+1); ScQueryEntry& rEntry = GetEntry(nIndex); ScQueryEntry::Item& rItem = rEntry.GetQueryItem(); if (aCellStr.isEmpty()) rItem.maString = svl::SharedString::getEmptyString(); else { rEntry.bDoQuery = true; // Operatoren herausfiltern if (aCellStr[0] == '<') { if (aCellStr[1] == '>') { rItem.maString = rPool.intern(aCellStr.copy(2)); rEntry.eOp = SC_NOT_EQUAL; } else if (aCellStr[1] == '=') { rItem.maString = rPool.intern(aCellStr.copy(2)); rEntry.eOp = SC_LESS_EQUAL; } else { rItem.maString = rPool.intern(aCellStr.copy(1)); rEntry.eOp = SC_LESS; } } else if (aCellStr[0]== '>') { if (aCellStr[1] == '=') { rItem.maString = rPool.intern(aCellStr.copy(2)); rEntry.eOp = SC_GREATER_EQUAL; } else { rItem.maString = rPool.intern(aCellStr.copy(1)); rEntry.eOp = SC_GREATER; } } else { if (aCellStr[0] == '=') rItem.maString = rPool.intern(aCellStr.copy(1)); else rItem.maString = rPool.intern(aCellStr); rEntry.eOp = SC_EQUAL; } } if (pFormatter) { sal_uInt32 nFormat = 0; bool bNumber = pFormatter->IsNumberFormat( rItem.maString.getString(), nFormat, rItem.mfVal); rItem.meType = bNumber ? ScQueryEntry::ByValue : ScQueryEntry::ByString; /* TODO: pFormatter currently is also used as a flag whether matching * empty cells with an empty string is triggered from the interpreter. * This could be handled independently if all queries should support * it, needs to be evaluated if that actually is desired. */ if (rItem.meType == ScQueryEntry::ByString) rItem.mbMatchEmpty = (rEntry.eOp == SC_EQUAL && rItem.maString.isEmpty()); } } ScQueryParamTable::ScQueryParamTable() : nCol1(0),nRow1(0),nCol2(0),nRow2(0),nTab(0) { } ScQueryParamTable::ScQueryParamTable(const ScQueryParamTable& r) : nCol1(r.nCol1),nRow1(r.nRow1),nCol2(r.nCol2),nRow2(r.nRow2),nTab(r.nTab) { } ScQueryParamTable::~ScQueryParamTable() { } ScQueryParam::ScQueryParam() : ScQueryParamBase(), ScQueryParamTable(), bDestPers(true), nDestTab(0), nDestCol(0), nDestRow(0) { Clear(); } ScQueryParam::ScQueryParam( const ScQueryParam& r ) : ScQueryParamBase(r), ScQueryParamTable(r), bDestPers(r.bDestPers), nDestTab(r.nDestTab), nDestCol(r.nDestCol), nDestRow(r.nDestRow) { } ScQueryParam::ScQueryParam( const ScDBQueryParamInternal& r ) : ScQueryParamBase(r), ScQueryParamTable(r), bDestPers(true), nDestTab(0), nDestCol(0), nDestRow(0) { } ScQueryParam::~ScQueryParam() { } void ScQueryParam::Clear() { nCol1=nCol2 = 0; nRow1=nRow2 = 0; nTab = SCTAB_MAX; bHasHeader = bCaseSens = bRegExp = false; bInplace = bByRow = bDuplicate = true; boost::ptr_vector::iterator itr = maEntries.begin(), itrEnd = maEntries.end(); for (; itr != itrEnd; ++itr) itr->Clear(); ClearDestParams(); } void ScQueryParam::ClearDestParams() { bDestPers = true; nDestTab = 0; nDestCol = 0; nDestRow = 0; } ScQueryParam& ScQueryParam::operator=( const ScQueryParam& r ) { nCol1 = r.nCol1; nRow1 = r.nRow1; nCol2 = r.nCol2; nRow2 = r.nRow2; nTab = r.nTab; nDestTab = r.nDestTab; nDestCol = r.nDestCol; nDestRow = r.nDestRow; bHasHeader = r.bHasHeader; bInplace = r.bInplace; bCaseSens = r.bCaseSens; bRegExp = r.bRegExp; bDuplicate = r.bDuplicate; bByRow = r.bByRow; bDestPers = r.bDestPers; maEntries = r.maEntries.clone(); return *this; } bool ScQueryParam::operator==( const ScQueryParam& rOther ) const { bool bEqual = false; // Anzahl der Queries gleich? SCSIZE nUsed = 0; SCSIZE nOtherUsed = 0; SCSIZE nEntryCount = GetEntryCount(); SCSIZE nOtherEntryCount = rOther.GetEntryCount(); while ( nUsed( nCol1 + nDifX ); nRow1 = sal::static_int_cast( nRow1 + nDifY ); nCol2 = sal::static_int_cast( nCol2 + nDifX ); nRow2 = sal::static_int_cast( nRow2 + nDifY ); nTab = sal::static_int_cast( nTab + nDifZ ); size_t n = maEntries.size(); for (size_t i=0; iGetDimensions(nC, nR); return 0 <= mnField && mnField <= static_cast(nC); } ScDBQueryParamMatrix::~ScDBQueryParamMatrix() { } /* vim:set shiftwidth=4 softtabstop=4 expandtab: */