/************************************************************** * * 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 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ // MARKER(update_precomp.py): autogen include statement, do not remove #include "precompiled_sc.hxx" // INCLUDE --------------------------------------------------------------- #include #include #include #include #include #include #include #include "dptabdat.hxx" #include "global.hxx" #include "dpcachetable.hxx" #include "dptabres.hxx" #include "document.hxx" #include "dpobject.hxx" using namespace ::com::sun::star; using ::com::sun::star::uno::Sequence; using ::com::sun::star::uno::Any; using ::std::vector; // --------------------------------------------------------------------------- ScDPTableData::CalcInfo::CalcInfo() : bRepeatIfEmpty(false) { } // --------------------------------------------------------------------------- ScDPTableData::ScDPTableData(ScDocument* pDoc, long nCacheId ) : mnCacheId( nCacheId ), mpDoc ( pDoc ) { nLastDateVal = nLastHier = nLastLevel = nLastRet = -1; // invalid //! reset before new calculation (in case the base date is changed) } ScDPTableData::~ScDPTableData() { } long ScDPTableData::GetDatePart( long nDateVal, long nHierarchy, long nLevel ) { if ( nDateVal == nLastDateVal && nHierarchy == nLastHier && nLevel == nLastLevel ) return nLastRet; Date aDate( 30,12,1899 ); //! get from source data (and cache here) aDate += nDateVal; 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: DBG_ERROR("GetDatePart: wrong level"); } break; case SC_DAPI_HIERARCHY_WEEK: switch (nLevel) { //! use settings for different definitions case 0: nRet = aDate.GetYear(); break; //!... case 1: nRet = aDate.GetWeekOfYear(); break; case 2: nRet = (long)aDate.GetDayOfWeek(); break; default: DBG_ERROR("GetDatePart: wrong level"); } break; default: DBG_ERROR("GetDatePart: wrong hierarchy"); } nLastDateVal = nDateVal; nLastHier = nHierarchy; nLastLevel = nLevel; nLastRet = nRet; return nRet; } bool ScDPTableData::IsRepeatIfEmpty() { return false; } sal_uLong ScDPTableData::GetNumberFormat(long) { return 0; // default format } sal_Bool ScDPTableData::IsBaseForGroup(long) const { return sal_False; // always false } long ScDPTableData::GetGroupBase(long) const { return -1; // always none } sal_Bool ScDPTableData::IsNumOrDateGroup(long) const { return sal_False; // always false } sal_Bool ScDPTableData::IsInGroup( const ScDPItemData&, long, const ScDPItemData&, long ) const { DBG_ERROR("IsInGroup shouldn't be called for non-group data"); return sal_False; } sal_Bool ScDPTableData::HasCommonElement( const ScDPItemData&, long, const ScDPItemData&, long ) const { DBG_ERROR("HasCommonElement shouldn't be called for non-group data"); return sal_False; } void ScDPTableData::FillRowDataFromCacheTable(sal_Int32 nRow, const ScDPCacheTable& 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); long nCacheColumnCount = rCacheTable.GetCache()->GetColumnCount(); sal_Int32 n = rInfo.aDataSrcCols.size(); for (sal_Int32 i = 0; i < n; ++i) { long nDim = rInfo.aDataSrcCols[i]; rData.aValues.push_back( ScDPValueData() ); // #i111435# GetItemData needs dimension indexes including groups, // so the index must be checked here (groups aren't useful as data fields). if ( nDim < nCacheColumnCount ) { ScDPValueData& rVal = rData.aValues.back(); rCacheTable.getValue( rVal, static_cast(nDim), static_cast(nRow), false); } } } void ScDPTableData::ProcessRowData(CalcInfo& rInfo, CalcRowData& rData, bool bAutoShow) { // Wang Xu Ming -- 2009-6-16 // DataPilot Migration if (!bAutoShow) { LateInitParams aColParams( rInfo.aColDims, rInfo.aColLevels, sal_False ); LateInitParams aRowParams ( rInfo.aRowDims, rInfo.aRowLevels, sal_True ); // root always init child aColParams.SetInitChild( sal_True ); aColParams.SetInitAllChildren( sal_False); aRowParams.SetInitChild( sal_True ); aRowParams.SetInitAllChildren( sal_False); rInfo.pColRoot->LateInitFrom( aColParams, rData.aColData,0, *rInfo.pInitState); rInfo.pRowRoot->LateInitFrom( aRowParams, rData.aRowData, 0, *rInfo.pInitState); } // End Comments if ( ( !rInfo.pColRoot->GetChildDimension() || rInfo.pColRoot->GetChildDimension()->IsValidEntry(rData.aColData) ) && ( !rInfo.pRowRoot->GetChildDimension() || rInfo.pRowRoot->GetChildDimension()->IsValidEntry(rData.aRowData) ) ) { //! single process method with ColMembers, RowMembers and data !!! if (rInfo.pColRoot->GetChildDimension()) { // Wang Xu Ming -- 2009-6-10 // DataPilot Migration vector aEmptyData; rInfo.pColRoot->GetChildDimension()->ProcessData(rData.aColData, NULL, aEmptyData, rData.aValues); // End Comments } rInfo.pRowRoot->ProcessData(rData.aRowData, rInfo.pColRoot->GetChildDimension(), rData.aColData, rData.aValues); } } void ScDPTableData::CalcResultsFromCacheTable(const ScDPCacheTable& rCacheTable, CalcInfo& rInfo, bool bAutoShow) { sal_Int32 nRowSize = rCacheTable.getRowSize(); for (sal_Int32 nRow = 0; nRow < nRowSize; ++nRow) { if (!rCacheTable.isRowActive(nRow)) continue; CalcRowData aData; FillRowDataFromCacheTable(nRow, rCacheTable, rInfo, aData); ProcessRowData(rInfo, aData, bAutoShow); } } // Wang Xu Ming -- 2009-6-10 // DataPilot Migration void ScDPTableData::GetItemData(const ScDPCacheTable& rCacheTable, sal_Int32 nRow, const vector& rDims, vector< SCROW/*ScDPItemData*/>& rItemData) // End Comments { sal_Int32 nDimSize = rDims.size(); for (sal_Int32 i = 0; i < nDimSize; ++i) { long 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 ); } } // ----------------------------------------------------------------------- // Wang Xu Ming -- 2009-6-8 // DataPilot Migration long ScDPTableData::GetMembersCount( long nDim ) { if ( nDim > MAXCOL ) return 0; return GetCacheTable().getFieldEntries( nDim ).size(); } long ScDPTableData::GetCacheId() const { return mnCacheId; } const ScDPItemData* ScDPTableData::GetMemberByIndex( long nDim, long nIndex ) { if ( nIndex >= GetMembersCount( nDim ) ) return NULL; const ::std::vector& nMembers = GetCacheTable().getFieldEntries( nDim ); return GetCacheTable().GetCache()->GetItemDataById( (SCCOL) nDim, (SCROW)nMembers[nIndex] ); } const ScDPItemData* ScDPTableData::GetMemberById( long nDim, long nId) { return GetCacheTable().GetCache()->GetItemDataById( (SCCOL) nDim, (SCROW)nId); } SCROW ScDPTableData::GetIdOfItemData( long nDim, const ScDPItemData& rData ) { return GetCacheTable().GetCache()->GetIdByItemData((SCCOL) nDim, rData ); } const std::vector< SCROW >& ScDPTableData::GetColumnEntries( long nColumn ) { return GetCacheTable().getFieldEntries( nColumn ); } long ScDPTableData::GetSourceDim( long nDim ) { return nDim; } long ScDPTableData::Compare( long nDim, long nDataId1, long nDataId2) { if ( getIsDataLayoutDimension(nDim) ) return 0; long n1 = GetCacheTable().GetCache()->GetOrder( nDim, nDataId1); long n2 = GetCacheTable().GetCache()->GetOrder( nDim, nDataId2); if ( n1 > n2 ) return 1; else if ( n1 == n2 ) return 0; else return -1; } // End Comments // -----------------------------------------------------------------------