/* -*- 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 #include #include #include #include #include using namespace ::com::sun::star; using ::std::vector; ScDPTableData::CalcInfo::CalcInfo() : pInitState( nullptr ), pColRoot( nullptr ), pRowRoot( nullptr ) { } ScDPTableData::ScDPTableData(const ScDocument* pDoc) : mpDoc(pDoc) { nLastDateVal = nLastHier = nLastLevel = nLastRet = -1; // invalid //TODO: reset before new calculation (in case the base date is changed) } ScDPTableData::~ScDPTableData() { } OUString ScDPTableData::GetFormattedString(sal_Int32 nDim, const ScDPItemData& rItem, bool bLocaleIndependent) const { const ScDPCache& rCache = GetCacheTable().getCache(); return rCache.GetFormattedString(nDim, rItem, bLocaleIndependent); } tools::Long ScDPTableData::GetDatePart( tools::Long nDateVal, tools::Long nHierarchy, tools::Long nLevel ) { if ( nDateVal == nLastDateVal && nHierarchy == nLastHier && nLevel == nLastLevel ) return nLastRet; Date aDate( 30,12,1899 ); //TODO: get from source data (and cache here) aDate.AddDays( nDateVal); tools::Long nRet = 0; switch (nHierarchy) { case SC_DAPI_HIERARCHY_QUARTER: switch (nLevel) { case 0: nRet = aDate.GetYear(); break; case 1: nRet = (aDate.GetMonth()-1) / 3 + 1; break; case 2: nRet = aDate.GetMonth(); break; case 3: nRet = aDate.GetDay(); break; default: OSL_FAIL("GetDatePart: wrong level"); } break; case SC_DAPI_HIERARCHY_WEEK: switch (nLevel) { //TODO: use settings for different definitions case 0: nRet = aDate.GetYear(); break; //!... case 1: nRet = aDate.GetWeekOfYear(); break; case 2: nRet = static_cast(aDate.GetDayOfWeek()); break; default: OSL_FAIL("GetDatePart: wrong level"); } break; default: OSL_FAIL("GetDatePart: wrong hierarchy"); } nLastDateVal = nDateVal; nLastHier = nHierarchy; nLastLevel = nLevel; nLastRet = nRet; return nRet; } bool ScDPTableData::IsRepeatIfEmpty() { return false; } sal_uInt32 ScDPTableData::GetNumberFormat(sal_Int32) { return 0; // default format } bool ScDPTableData::IsBaseForGroup(sal_Int32) const { return false; // always false } sal_Int32 ScDPTableData::GetGroupBase(sal_Int32) const { return -1; // always none } bool ScDPTableData::IsNumOrDateGroup(sal_Int32) const { return false; // always false } bool ScDPTableData::IsInGroup( const ScDPItemData&, sal_Int32, const ScDPItemData&, sal_Int32 ) const { OSL_FAIL("IsInGroup shouldn't be called for non-group data"); return false; } bool ScDPTableData::HasCommonElement( const ScDPItemData&, sal_Int32, const ScDPItemData&, sal_Int32 ) const { OSL_FAIL("HasCommonElement shouldn't be called for non-group data"); return false; } void ScDPTableData::FillRowDataFromCacheTable(sal_Int32 nRow, const ScDPFilteredCache& rCacheTable, const CalcInfo& rInfo, CalcRowData& rData) { // column dimensions GetItemData(rCacheTable, nRow, rInfo.aColLevelDims, rData.aColData); // row dimensions GetItemData(rCacheTable, nRow, rInfo.aRowLevelDims, rData.aRowData); // page dimensions GetItemData(rCacheTable, nRow, rInfo.aPageDims, rData.aPageData); tools::Long nCacheColumnCount = rCacheTable.getCache().GetColumnCount(); sal_Int32 n = rInfo.aDataSrcCols.size(); for (sal_Int32 i = 0; i < n; ++i) { tools::Long nDim = rInfo.aDataSrcCols[i]; rData.aValues.emplace_back( ); // #i111435# GetItemData needs dimension indexes including groups, // so the index must be checked here (groups aren't useful as data fields). if ( nDim < nCacheColumnCount ) { ScDPValue& rVal = rData.aValues.back(); rCacheTable.getValue( rVal, static_cast(nDim), static_cast(nRow)); } } } void ScDPTableData::ProcessRowData(CalcInfo& rInfo, const CalcRowData& rData, bool bAutoShow) { if (!bAutoShow) { LateInitParams aColParams(rInfo.aColDims, rInfo.aColLevels, false); LateInitParams aRowParams(rInfo.aRowDims, rInfo.aRowLevels, true); // root always init child aColParams.SetInitChild(true); aColParams.SetInitAllChildren( false); aRowParams.SetInitChild(true); aRowParams.SetInitAllChildren( false); rInfo.pColRoot->LateInitFrom(aColParams, rData.aColData, 0, *rInfo.pInitState); rInfo.pRowRoot->LateInitFrom(aRowParams, rData.aRowData, 0, *rInfo.pInitState); } if ( ( !rInfo.pColRoot->GetChildDimension() || rInfo.pColRoot->GetChildDimension()->IsValidEntry(rData.aColData) ) && ( !rInfo.pRowRoot->GetChildDimension() || rInfo.pRowRoot->GetChildDimension()->IsValidEntry(rData.aRowData) ) ) { //TODO: single process method with ColMembers, RowMembers and data !!! if (rInfo.pColRoot->GetChildDimension()) { vector aEmptyData; rInfo.pColRoot->GetChildDimension()->ProcessData(rData.aColData, nullptr, aEmptyData, rData.aValues); } rInfo.pRowRoot->ProcessData(rData.aRowData, rInfo.pColRoot->GetChildDimension(), rData.aColData, rData.aValues); } } void ScDPTableData::CalcResultsFromCacheTable(const ScDPFilteredCache& rCacheTable, CalcInfo& rInfo, bool bAutoShow) { sal_Int32 nRowSize = rCacheTable.getRowSize(); for (sal_Int32 nRow = 0; nRow < nRowSize; ++nRow) { sal_Int32 nLastRow; if (!rCacheTable.isRowActive(nRow, &nLastRow)) { nRow = nLastRow; continue; } CalcRowData aData; FillRowDataFromCacheTable(nRow, rCacheTable, rInfo, aData); ProcessRowData(rInfo, aData, bAutoShow); } } void ScDPTableData::GetItemData(const ScDPFilteredCache& rCacheTable, sal_Int32 nRow, const vector& rDims, vector& rItemData) { sal_Int32 nDimSize = rDims.size(); rItemData.reserve(rItemData.size() + nDimSize); for (sal_Int32 i = 0; i < nDimSize; ++i) { sal_Int32 nDim = rDims[i]; if (getIsDataLayoutDimension(nDim)) { rItemData.push_back( -1 ); continue; } nDim = GetSourceDim( nDim ); if ( nDim >= rCacheTable.getCache().GetColumnCount() ) continue; SCROW nId= rCacheTable.getCache().GetItemDataId( static_cast(nDim), static_cast(nRow), IsRepeatIfEmpty()); rItemData.push_back( nId ); } } sal_Int32 ScDPTableData::GetMembersCount( sal_Int32 nDim ) { if ( nDim > MAXCOL ) return 0; return GetCacheTable().getFieldEntries( nDim ).size(); } const ScDPItemData* ScDPTableData::GetMemberByIndex( sal_Int32 nDim, sal_Int32 nIndex ) { if ( nIndex >= GetMembersCount( nDim ) ) return nullptr; const ::std::vector& nMembers = GetCacheTable().getFieldEntries( nDim ); return GetCacheTable().getCache().GetItemDataById( static_cast(nDim), static_cast(nMembers[nIndex]) ); } const ScDPItemData* ScDPTableData::GetMemberById( sal_Int32 nDim, sal_Int32 nId) { return GetCacheTable().getCache().GetItemDataById(nDim, static_cast(nId)); } const std::vector< SCROW >& ScDPTableData::GetColumnEntries( sal_Int32 nColumn ) { return GetCacheTable().getFieldEntries( nColumn ); } sal_Int32 ScDPTableData::GetSourceDim( sal_Int32 nDim ) { return nDim; } sal_Int32 ScDPTableData::Compare( sal_Int32 nDim, sal_Int32 nDataId1, sal_Int32 nDataId2) { if ( getIsDataLayoutDimension(nDim) ) return 0; if ( nDataId1 > nDataId2 ) return 1; else if ( nDataId1 == nDataId2 ) return 0; else return -1; } #if DUMP_PIVOT_TABLE void ScDPTableData::Dump() const { } #endif /* vim:set shiftwidth=4 softtabstop=4 expandtab: */