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