1b3f79822SAndrew Rist /**************************************************************
2cdf0e10cSrcweir *
3b3f79822SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
4b3f79822SAndrew Rist * or more contributor license agreements. See the NOTICE file
5b3f79822SAndrew Rist * distributed with this work for additional information
6b3f79822SAndrew Rist * regarding copyright ownership. The ASF licenses this file
7b3f79822SAndrew Rist * to you under the Apache License, Version 2.0 (the
8b3f79822SAndrew Rist * "License"); you may not use this file except in compliance
9b3f79822SAndrew Rist * with the License. You may obtain a copy of the License at
10b3f79822SAndrew Rist *
11b3f79822SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0
12b3f79822SAndrew Rist *
13b3f79822SAndrew Rist * Unless required by applicable law or agreed to in writing,
14b3f79822SAndrew Rist * software distributed under the License is distributed on an
15b3f79822SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16b3f79822SAndrew Rist * KIND, either express or implied. See the License for the
17b3f79822SAndrew Rist * specific language governing permissions and limitations
18b3f79822SAndrew Rist * under the License.
19b3f79822SAndrew Rist *
20b3f79822SAndrew Rist *************************************************************/
21b3f79822SAndrew Rist
22b3f79822SAndrew Rist
23cdf0e10cSrcweir
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_sc.hxx"
26cdf0e10cSrcweir
27cdf0e10cSrcweir
28cdf0e10cSrcweir
29cdf0e10cSrcweir //------------------------------------------------------------------
30cdf0e10cSrcweir
31cdf0e10cSrcweir #include "scitems.hxx"
32cdf0e10cSrcweir #include <svl/srchitem.hxx>
33cdf0e10cSrcweir #include <sfx2/app.hxx>
34cdf0e10cSrcweir #include <sfx2/objface.hxx>
35cdf0e10cSrcweir #include <sfx2/objsh.hxx>
36cdf0e10cSrcweir #include <sfx2/request.hxx>
37cdf0e10cSrcweir #include <svl/whiter.hxx>
38cdf0e10cSrcweir #include <vcl/msgbox.hxx>
39*f120fe41SAndre Fischer #include <sfx2/sidebar/EnumContext.hxx>
40cdf0e10cSrcweir
41cdf0e10cSrcweir #include "sc.hrc"
42cdf0e10cSrcweir #include "pivotsh.hxx"
43cdf0e10cSrcweir #include "tabvwsh.hxx"
44cdf0e10cSrcweir #include "docsh.hxx"
45cdf0e10cSrcweir #include "scresid.hxx"
46cdf0e10cSrcweir #include "document.hxx"
47cdf0e10cSrcweir #include "dpobject.hxx"
48cdf0e10cSrcweir #include "dpshttab.hxx"
49cdf0e10cSrcweir #include "dbdocfun.hxx"
50cdf0e10cSrcweir #include "uiitems.hxx"
51cdf0e10cSrcweir //CHINA001 #include "pfiltdlg.hxx"
52cdf0e10cSrcweir #include "scabstdlg.hxx" //CHINA001
53cdf0e10cSrcweir //------------------------------------------------------------------------
54cdf0e10cSrcweir
55cdf0e10cSrcweir #define ScPivotShell
56cdf0e10cSrcweir #include "scslots.hxx"
57cdf0e10cSrcweir
58cdf0e10cSrcweir //------------------------------------------------------------------------
59cdf0e10cSrcweir
60cdf0e10cSrcweir TYPEINIT1( ScPivotShell, SfxShell );
61cdf0e10cSrcweir
SFX_IMPL_INTERFACE(ScPivotShell,SfxShell,ScResId (SCSTR_PIVOTSHELL))62cdf0e10cSrcweir SFX_IMPL_INTERFACE(ScPivotShell, SfxShell, ScResId(SCSTR_PIVOTSHELL))
63cdf0e10cSrcweir {
64cdf0e10cSrcweir SFX_POPUPMENU_REGISTRATION( ScResId(RID_POPUP_PIVOT) );
65cdf0e10cSrcweir }
66cdf0e10cSrcweir
67cdf0e10cSrcweir
68cdf0e10cSrcweir //------------------------------------------------------------------------
69cdf0e10cSrcweir
ScPivotShell(ScTabViewShell * pViewSh)70cdf0e10cSrcweir ScPivotShell::ScPivotShell( ScTabViewShell* pViewSh ) :
71cdf0e10cSrcweir SfxShell(pViewSh),
72cdf0e10cSrcweir pViewShell( pViewSh )
73cdf0e10cSrcweir {
74cdf0e10cSrcweir SetPool( &pViewSh->GetPool() );
75cdf0e10cSrcweir ScViewData* pViewData = pViewSh->GetViewData();
76cdf0e10cSrcweir ::svl::IUndoManager* pMgr = pViewData->GetSfxDocShell()->GetUndoManager();
77cdf0e10cSrcweir SetUndoManager( pMgr );
78cdf0e10cSrcweir if ( !pViewData->GetDocument()->IsUndoEnabled() )
79cdf0e10cSrcweir {
80cdf0e10cSrcweir pMgr->SetMaxUndoActionCount( 0 );
81cdf0e10cSrcweir }
82cdf0e10cSrcweir SetHelpId( HID_SCSHELL_PIVOTSH );
83cdf0e10cSrcweir SetName(String::CreateFromAscii(RTL_CONSTASCII_STRINGPARAM("Pivot")));
84*f120fe41SAndre Fischer SfxShell::SetContextName(sfx2::sidebar::EnumContext::GetContextName(sfx2::sidebar::EnumContext::Context_Pivot));
85cdf0e10cSrcweir }
86cdf0e10cSrcweir
87cdf0e10cSrcweir //------------------------------------------------------------------------
~ScPivotShell()88cdf0e10cSrcweir ScPivotShell::~ScPivotShell()
89cdf0e10cSrcweir {
90cdf0e10cSrcweir }
91cdf0e10cSrcweir
92cdf0e10cSrcweir //------------------------------------------------------------------------
Execute(SfxRequest & rReq)93cdf0e10cSrcweir void ScPivotShell::Execute( SfxRequest& rReq )
94cdf0e10cSrcweir {
95cdf0e10cSrcweir switch ( rReq.GetSlot() )
96cdf0e10cSrcweir {
97cdf0e10cSrcweir case SID_PIVOT_RECALC:
98cdf0e10cSrcweir pViewShell->RecalcPivotTable();
99cdf0e10cSrcweir break;
100cdf0e10cSrcweir
101cdf0e10cSrcweir case SID_PIVOT_KILL:
102cdf0e10cSrcweir pViewShell->DeletePivotTable();
103cdf0e10cSrcweir break;
104cdf0e10cSrcweir
105cdf0e10cSrcweir case SID_DP_FILTER:
106cdf0e10cSrcweir {
107cdf0e10cSrcweir ScDPObject* pDPObj = GetCurrDPObject();
108cdf0e10cSrcweir if( pDPObj )
109cdf0e10cSrcweir {
110cdf0e10cSrcweir ScQueryParam aQueryParam;
111cdf0e10cSrcweir SCTAB nSrcTab = 0;
112cdf0e10cSrcweir const ScSheetSourceDesc* pDesc = pDPObj->GetSheetDesc();
113cdf0e10cSrcweir DBG_ASSERT( pDesc, "no sheet source for DP filter dialog" );
114cdf0e10cSrcweir if( pDesc )
115cdf0e10cSrcweir {
116cdf0e10cSrcweir aQueryParam = pDesc->aQueryParam;
117cdf0e10cSrcweir nSrcTab = pDesc->aSourceRange.aStart.Tab();
118cdf0e10cSrcweir }
119cdf0e10cSrcweir
120cdf0e10cSrcweir ScViewData* pViewData = pViewShell->GetViewData();
121cdf0e10cSrcweir SfxItemSet aArgSet( pViewShell->GetPool(),
122cdf0e10cSrcweir SCITEM_QUERYDATA, SCITEM_QUERYDATA );
123cdf0e10cSrcweir aArgSet.Put( ScQueryItem( SCITEM_QUERYDATA, pViewData, &aQueryParam ) );
124cdf0e10cSrcweir
125cdf0e10cSrcweir //CHINA001 ScPivotFilterDlg* pDlg = new ScPivotFilterDlg(
126cdf0e10cSrcweir //CHINA001 pViewShell->GetDialogParent(), aArgSet, nSrcTab );
127cdf0e10cSrcweir
128cdf0e10cSrcweir ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
129cdf0e10cSrcweir DBG_ASSERT(pFact, "ScAbstractFactory create fail!");//CHINA001
130cdf0e10cSrcweir
131cdf0e10cSrcweir AbstractScPivotFilterDlg* pDlg = pFact->CreateScPivotFilterDlg( pViewShell->GetDialogParent(),
132cdf0e10cSrcweir aArgSet, nSrcTab,
133cdf0e10cSrcweir RID_SCDLG_PIVOTFILTER);
134cdf0e10cSrcweir DBG_ASSERT(pDlg, "Dialog create fail!");//CHINA001
135cdf0e10cSrcweir
136cdf0e10cSrcweir if( pDlg->Execute() == RET_OK )
137cdf0e10cSrcweir {
138cdf0e10cSrcweir ScSheetSourceDesc aNewDesc;
139cdf0e10cSrcweir if( pDesc )
140cdf0e10cSrcweir aNewDesc = *pDesc;
141cdf0e10cSrcweir
142cdf0e10cSrcweir const ScQueryItem& rQueryItem = pDlg->GetOutputItem();
143cdf0e10cSrcweir aNewDesc.aQueryParam = rQueryItem.GetQueryData();
144cdf0e10cSrcweir
145cdf0e10cSrcweir ScDPObject aNewObj( *pDPObj );
146cdf0e10cSrcweir aNewObj.SetSheetDesc( aNewDesc );
147cdf0e10cSrcweir ScDBDocFunc aFunc( *pViewData->GetDocShell() );
148cdf0e10cSrcweir aFunc.DataPilotUpdate( pDPObj, &aNewObj, sal_True, sal_False );
149cdf0e10cSrcweir pViewData->GetView()->CursorPosChanged(); // shells may be switched
150cdf0e10cSrcweir }
151cdf0e10cSrcweir delete pDlg;
152cdf0e10cSrcweir }
153cdf0e10cSrcweir }
154cdf0e10cSrcweir break;
155cdf0e10cSrcweir }
156cdf0e10cSrcweir }
157cdf0e10cSrcweir
158cdf0e10cSrcweir //------------------------------------------------------------------------
GetState(SfxItemSet & rSet)159cdf0e10cSrcweir void __EXPORT ScPivotShell::GetState( SfxItemSet& rSet )
160cdf0e10cSrcweir {
161cdf0e10cSrcweir ScDocShell* pDocSh = pViewShell->GetViewData()->GetDocShell();
162cdf0e10cSrcweir ScDocument* pDoc = pDocSh->GetDocument();
163cdf0e10cSrcweir sal_Bool bDisable = pDocSh->IsReadOnly() || pDoc->GetChangeTrack();
164cdf0e10cSrcweir
165cdf0e10cSrcweir SfxWhichIter aIter(rSet);
166cdf0e10cSrcweir sal_uInt16 nWhich = aIter.FirstWhich();
167cdf0e10cSrcweir while (nWhich)
168cdf0e10cSrcweir {
169cdf0e10cSrcweir switch (nWhich)
170cdf0e10cSrcweir {
171cdf0e10cSrcweir case SID_PIVOT_RECALC:
172cdf0e10cSrcweir case SID_PIVOT_KILL:
173cdf0e10cSrcweir {
174cdf0e10cSrcweir //! move ReadOnly check to idl flags
175cdf0e10cSrcweir if ( bDisable )
176cdf0e10cSrcweir {
177cdf0e10cSrcweir rSet.DisableItem( nWhich );
178cdf0e10cSrcweir }
179cdf0e10cSrcweir }
180cdf0e10cSrcweir break;
181cdf0e10cSrcweir case SID_DP_FILTER:
182cdf0e10cSrcweir {
183cdf0e10cSrcweir ScDPObject* pDPObj = GetCurrDPObject();
184cdf0e10cSrcweir if( bDisable || !pDPObj || !pDPObj->IsSheetData() )
185cdf0e10cSrcweir rSet.DisableItem( nWhich );
186cdf0e10cSrcweir }
187cdf0e10cSrcweir break;
188cdf0e10cSrcweir }
189cdf0e10cSrcweir nWhich = aIter.NextWhich();
190cdf0e10cSrcweir }
191cdf0e10cSrcweir }
192cdf0e10cSrcweir
193cdf0e10cSrcweir
194cdf0e10cSrcweir //------------------------------------------------------------------------
195cdf0e10cSrcweir
GetCurrDPObject()196cdf0e10cSrcweir ScDPObject* ScPivotShell::GetCurrDPObject()
197cdf0e10cSrcweir {
198cdf0e10cSrcweir const ScViewData& rViewData = *pViewShell->GetViewData();
199cdf0e10cSrcweir return rViewData.GetDocument()->GetDPAtCursor(
200cdf0e10cSrcweir rViewData.GetCurX(), rViewData.GetCurY(), rViewData.GetTabNo() );
201cdf0e10cSrcweir }
202