sc/source/ui/dbgui/PivotLayoutTreeListData.cxx

   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
  12 #include "PivotLayoutTreeListData.hxx"
  13 #include "PivotLayoutDialog.hxx"
  14
  15 #include <vcl/builderfactory.hxx>
  16 #include <svtools/treelistentry.hxx>
  17 #include "pivot.hxx"
  18 #include "scabstdlg.hxx"
  19
  20 using namespace std;
  21
  22 VCL_BUILDER_FACTORY_ARGS(ScPivotLayoutTreeListData,
  23                          WB_BORDER | WB_TABSTOP | WB_CLIPCHILDREN |
  24                          WB_FORCE_MAKEVISIBLE)
  25
  26 namespace
  27 {
  28
  29 OUString lclGetFunctionMaskName(const PivotFunc nFunctionMask)
  30 {
  31     switch (nFunctionMask)
  32     {
  33         case PivotFunc::Sum:       return OUString("Sum");
  34         case PivotFunc::Count:     return OUString("Count");
  35         case PivotFunc::Average:   return OUString("Mean");
  36         case PivotFunc::Max:       return OUString("Max");
  37         case PivotFunc::Min:       return OUString("Min");
  38         case PivotFunc::Product:   return OUString("Product");
  39         case PivotFunc::CountNum: return OUString("Count");
  40         case PivotFunc::StdDev:   return OUString("StDev");
  41         case PivotFunc::StdDevP:  return OUString("StDevP");
  42         case PivotFunc::StdVar:   return OUString("Var");
  43         case PivotFunc::StdVarP:  return OUString("VarP");
  44         default:
  45             break;
  46     }
  47     return OUString();
  48 }
  49
  50 OUString lclCreateDataItemName(const PivotFunc nFunctionMask, const OUString& rName, const sal_uInt8 nDuplicationCount)
  51 {
  52     OUString aBuffer = lclGetFunctionMaskName(nFunctionMask) + " - " + rName;
  53     if(nDuplicationCount > 0)
  54     {
  55         aBuffer += " " + OUString::number(nDuplicationCount);
  56     }
  57     return aBuffer;
  58 }
  59
  60 } // anonymous namespace
  61
  62 ScPivotLayoutTreeListData::ScPivotLayoutTreeListData(vcl::Window* pParent, WinBits nBits) :
  63     ScPivotLayoutTreeListBase(pParent, nBits, DATA_LIST)
  64 {}
  65
  66 ScPivotLayoutTreeListData::~ScPivotLayoutTreeListData()
  67 {}
  68
  69 bool ScPivotLayoutTreeListData::DoubleClickHdl()
  70 {
  71     ScItemValue* pCurrentItemValue = static_cast<ScItemValue*>(GetCurEntry()->GetUserData());
  72     ScPivotFuncData& rCurrentFunctionData = pCurrentItemValue->maFunctionData;
  73
  74     SCCOL nCurrentColumn = rCurrentFunctionData.mnCol;
  75     ScDPLabelData& rCurrentLabelData = mpParent->GetLabelData(nCurrentColumn);
  76
  77     ScAbstractDialogFactory* pFactory = ScAbstractDialogFactory::Create();
  78
  79     std::unique_ptr<AbstractScDPFunctionDlg> pDialog(
  80         pFactory->CreateScDPFunctionDlg(this, mpParent->GetLabelDataVector(), rCurrentLabelData, rCurrentFunctionData));
  81
  82     if (pDialog->Execute() == RET_OK)
  83     {
  84         rCurrentFunctionData.mnFuncMask = pDialog->GetFuncMask();
  85         rCurrentLabelData.mnFuncMask = pDialog->GetFuncMask();
  86
  87         rCurrentFunctionData.maFieldRef = pDialog->GetFieldRef();
  88
  89         ScDPLabelData& rDFData = mpParent->GetLabelData(rCurrentFunctionData.mnCol);
  90
  91         AdjustDuplicateCount(pCurrentItemValue);
  92
  93         OUString sDataItemName = lclCreateDataItemName(
  94                                     rCurrentFunctionData.mnFuncMask,
  95                                     rDFData.maName,
  96                                     rCurrentFunctionData.mnDupCount);
  97
  98         SetEntryText(GetCurEntry(), sDataItemName);
  99     }
 100
 101     return true;
 102 }
 103
 104 void ScPivotLayoutTreeListData::FillDataField(ScPivotFieldVector& rDataFields)
 105 {
 106     Clear();
 107     maDataItemValues.clear();
 108
 109     ScPivotFieldVector::iterator it;
 110     for (it = rDataFields.begin(); it != rDataFields.end(); ++it)
 111     {
 112         ScPivotField& rField = *it;
 113
 114         if (rField.nCol == PIVOT_DATA_FIELD)
 115             continue;
 116
 117         SCCOL nColumn;
 118         if (rField.mnOriginalDim >= 0)
 119             nColumn = rField.mnOriginalDim;
 120         else
 121             nColumn = rField.nCol;
 122
 123         ScItemValue* pOriginalItemValue = mpParent->GetItem(nColumn);
 124         ScItemValue* pItemValue = new ScItemValue(pOriginalItemValue->maName, nColumn, rField.nFuncMask);
 125
 126         pItemValue->mpOriginalItemValue = pOriginalItemValue;
 127         pItemValue->maFunctionData.mnOriginalDim = rField.mnOriginalDim;
 128         pItemValue->maFunctionData.maFieldRef = rField.maFieldRef;
 129
 130         AdjustDuplicateCount(pItemValue);
 131         OUString sDataItemName = lclCreateDataItemName(pItemValue->maFunctionData.mnFuncMask,
 132                                                        pItemValue->maName,
 133                                                        pItemValue->maFunctionData.mnDupCount);
 134
 135         maDataItemValues.push_back(std::unique_ptr<ScItemValue>(pItemValue));
 136         InsertEntry(sDataItemName, nullptr, false, TREELIST_APPEND, pItemValue);
 137     }
 138 }
 139
 140 void ScPivotLayoutTreeListData::PushDataFieldNames(vector<ScDPName>& rDataFieldNames)
 141 {
 142     SvTreeListEntry* pLoopEntry;
 143     for (pLoopEntry = First(); pLoopEntry != nullptr; pLoopEntry = Next(pLoopEntry))
 144     {
 145         ScItemValue* pEachItemValue = static_cast<ScItemValue*>(pLoopEntry->GetUserData());
 146         SCCOL nColumn = pEachItemValue->maFunctionData.mnCol;
 147
 148         ScDPLabelData& rLabelData = mpParent->GetLabelData(nColumn);
 149
 150         if (rLabelData.maName.isEmpty())
 151             continue;
 152
 153         OUString sLayoutName = rLabelData.maLayoutName;
 154         if (sLayoutName.isEmpty())
 155         {
 156             sLayoutName = lclCreateDataItemName(
 157                             pEachItemValue->maFunctionData.mnFuncMask,
 158                             pEachItemValue->maName,
 159                             pEachItemValue->maFunctionData.mnDupCount);
 160         }
 161
 162         rDataFieldNames.push_back(ScDPName(rLabelData.maName, sLayoutName, rLabelData.mnDupCount));
 163     }
 164 }
 165
 166 void ScPivotLayoutTreeListData::InsertEntryForSourceTarget(SvTreeListEntry* pSource, SvTreeListEntry* pTarget)
 167 {
 168     ScItemValue* pItemValue = static_cast<ScItemValue*>(pSource->GetUserData());
 169
 170     if(mpParent->IsDataElement(pItemValue->maFunctionData.mnCol))
 171         return;
 172
 173     if (HasEntry(pSource))
 174     {
 175         OUString rText = GetEntryText(pSource);
 176         GetModel()->Remove(pSource);
 177         sal_uLong nPosition = (pTarget == nullptr) ? TREELIST_APPEND : GetModel()->GetAbsPos(pTarget) + 1;
 178         InsertEntry(rText, nullptr, false, nPosition, pItemValue);
 179     }
 180     else
 181     {
 182         sal_uLong nPosition = (pTarget == nullptr) ? TREELIST_APPEND : GetModel()->GetAbsPos(pTarget) + 1;
 183         InsertEntryForItem(pItemValue->mpOriginalItemValue, nPosition);
 184     }
 185 }
 186
 187 void ScPivotLayoutTreeListData::InsertEntryForItem(ScItemValue* pItemValue, sal_uLong nPosition)
 188 {
 189     ScItemValue* pDataItemValue = new ScItemValue(pItemValue);
 190     pDataItemValue->mpOriginalItemValue = pItemValue;
 191     maDataItemValues.push_back(std::unique_ptr<ScItemValue>(pDataItemValue));
 192
 193     ScPivotFuncData& rFunctionData = pDataItemValue->maFunctionData;
 194
 195     if (rFunctionData.mnFuncMask == PivotFunc::NONE ||
 196         rFunctionData.mnFuncMask == PivotFunc::Auto)
 197     {
 198         rFunctionData.mnFuncMask = PivotFunc::Sum;
 199     }
 200
 201     AdjustDuplicateCount(pDataItemValue);
 202
 203     OUString sDataName = lclCreateDataItemName(
 204                             rFunctionData.mnFuncMask,
 205                             pDataItemValue->maName,
 206                             rFunctionData.mnDupCount);
 207
 208     InsertEntry(sDataName, nullptr, false, nPosition, pDataItemValue);
 209 }
 210
 211 void ScPivotLayoutTreeListData::AdjustDuplicateCount(ScItemValue* pInputItemValue)
 212 {
 213     ScPivotFuncData& rInputFunctionData = pInputItemValue->maFunctionData;
 214
 215     bool bFoundDuplicate = false;
 216
 217     rInputFunctionData.mnDupCount = 0;
 218     sal_uInt8 nMaxDuplicateCount = 0;
 219
 220     SvTreeListEntry* pEachEntry;
 221     for (pEachEntry = First(); pEachEntry != nullptr; pEachEntry = Next(pEachEntry))
 222     {
 223         ScItemValue* pItemValue = static_cast<ScItemValue*>(pEachEntry->GetUserData());
 224         if (pItemValue == pInputItemValue)
 225             continue;
 226
 227         ScPivotFuncData& rFunctionData = pItemValue->maFunctionData;
 228
 229         if (rFunctionData.mnCol      == rInputFunctionData.mnCol &&
 230             rFunctionData.mnFuncMask == rInputFunctionData.mnFuncMask)
 231         {
 232             bFoundDuplicate = true;
 233             if(rFunctionData.mnDupCount > nMaxDuplicateCount)
 234                 nMaxDuplicateCount = rFunctionData.mnDupCount;
 235         }
 236     }
 237
 238     if(bFoundDuplicate)
 239     {
 240         rInputFunctionData.mnDupCount = nMaxDuplicateCount + 1;
 241     }
 242 }
 243
 244 void ScPivotLayoutTreeListData::KeyInput(const KeyEvent& rKeyEvent)
 245 {
 246     vcl::KeyCode aCode = rKeyEvent.GetKeyCode();
 247     sal_uInt16 nCode = aCode.GetCode();
 248
 249     if (nCode == KEY_DELETE)
 250     {
 251         const SvTreeListEntry* pEntry = GetCurEntry();
 252         if (pEntry)
 253             GetModel()->Remove(pEntry);
 254         return;
 255     }
 256
 257     SvTreeListBox::KeyInput(rKeyEvent);
 258 }
 259
 260 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */