[FIX] crm.lead: missing index on stage_id/type/state
[odoo/odoo.git] / addons / crm / crm_report_view.xml
1 <?xml version="1.0"?>
2 <openerp>
3 <data>
4
5 <!--  Cases by section and category2 of case Tree View -->
6
7     <record model="ir.ui.view" id="view_crm_case_section_categ_tree">
8         <field name="name">CRM Report - Teams and Type(Tree)</field>
9         <field name="model">report.crm.case.section.categ2</field>
10         <field name="arch" type="xml">
11             <tree string="Cases by Team and Type">
12                 <field name="name"/>
13                 <field name="month"/>
14                 <field name="user_id"/>
15                 <field name="section_id"/>
16                 <field name="category2_id"/>
17                 <field name="stage_id"/>
18                 <field name="amount_revenue"/>
19                 <field name="nbr"/>
20                 <field name="delay_close"/>
21                 <field name="state"/>
22             </tree>
23         </field>
24     </record>
25
26 <!--  Cases by section and category2 of case Form View -->
27
28     <record model="ir.ui.view" id="view_crm_case_section_categ_form">
29         <field name="name">CRM Report - Teams and Type(Form)</field>
30         <field name="model">report.crm.case.section.categ2</field>
31         <field name="arch" type="xml">
32             <form string="Cases by Team and Category2">
33                 <field name="name"/>
34                 <field name="month"/>
35                 <field name="user_id"/>
36                 <field name="section_id"  widget="selection"/>
37                 <field name="category2_id" />
38                 <field name="stage_id"/>
39                 <field name="amount_revenue"/>
40                 <field name="nbr" />
41                 <field name="state" />
42                 <field name="delay_close"/>
43             </form>
44         </field>
45     </record>
46
47 <!--  Cases by section and category2 of case Graph View -->
48
49     <record model="ir.ui.view" id="view_crm_case_section_categ_graph">
50         <field name="name">CRM Report - Teams and Type(Graph)</field>
51         <field name="model">report.crm.case.section.categ2</field>
52         <field name="arch" type="xml">
53             <graph string="Cases by Teams and Type" type="bar" orientation="horizontal">
54                 <field name="category2_id"/>
55                 <field name="amount_revenue" operator="+"/>
56                 <field name="section_id" group="True"/>
57             </graph>
58         </field>
59     </record>
60
61 <!--  Cases by section and category2 of case Search View -->
62
63     <record id="view_crm_case_section_categ_filter" model="ir.ui.view">
64             <field name="name">CRM Report - Teams and Type(Select)</field>
65             <field name="model">report.crm.case.section.categ2</field>
66             <field name="arch" type="xml">
67                 <search string="Cases by Team and Type">
68                     <field name="name"/>
69                     <field name="month"/>
70                     <field name="nbr"/>
71                     <field name="state"/>
72                     <field name="section_id"/>
73                     <field name="category2_id"/>
74                </search>
75             </field>
76         </record>
77
78 <!--  Cases by section and category2 of case Action -->
79
80     <record model="ir.actions.act_window" id="action_report_crm_case_section_categ_tree">
81         <field name="name">Cases By Section and Category</field>
82         <field name="res_model">report.crm.case.section.categ2</field>
83         <field name="view_type">form</field>
84         <field name="view_mode">graph,tree</field>
85         <field name="search_view_id" ref="view_crm_case_section_categ_filter"/>
86     </record>
87
88 <!-- Cases by section and stage Tree View -->
89
90     <record model="ir.ui.view" id="view_crm_case_section_stage_tree">
91         <field name="name">CRM Report - Teams and Stage(Tree)</field>
92         <field name="model">report.crm.case.section.stage</field>
93         <field name="arch" type="xml">
94             <tree string="Cases by Team and Stage">
95                 <field name="name"/>
96                 <field name="month"/>
97                 <field name="user_id"/>
98                 <field name="section_id"/>
99                 <field name="stage_id"/>
100                 <field name="amount_revenue"/>
101                 <field name="nbr"/>
102                 <field name="delay_close"/>
103                 <field name="state"/>
104             </tree>
105         </field>
106     </record>
107
108 <!-- Cases by section and stage Form View -->
109
110     <record model="ir.ui.view" id="view_crm_case_section_stage_form">
111         <field name="name">CRM Report - Teams and Stage(Form)</field>
112         <field name="model">report.crm.case.section.stage</field>
113         <field name="arch" type="xml">
114             <form string="Cases by Team and Stage">
115                 <field name="name"/>
116                 <field name="month"/>
117                 <field name="user_id"/>
118                 <field name="section_id"  widget="selection"/>
119                 <field name="stage_id"/>
120                 <field name="amount_revenue"/>
121                 <field name="nbr" />
122                 <field name="state" />
123                 <field name="delay_close"/>
124             </form>
125         </field>
126     </record>
127
128 <!-- Cases by section and stage Graph View -->
129
130     <record model="ir.ui.view" id="view_crm_case_section_stage_graph">
131         <field name="name">CRM Report - Teams and Stage(Graph)</field>
132         <field name="model">report.crm.case.section.stage</field>
133         <field name="arch" type="xml">
134             <graph string="Cases by Team and Stage" type="bar" orientation="horizontal">
135                 <field name="stage_id"/>
136                 <field name="amount_revenue" operator="+"/>
137                 <field name="section_id" group="True"/>
138             </graph>
139         </field>
140     </record>
141
142 <!-- Cases by section and stage Search View -->
143
144     <record id="view_crm_case_section_stage_filter" model="ir.ui.view">
145             <field name="name">CRM Report - Teams and Stage(Select)</field>
146             <field name="model">report.crm.case.section.stage</field>
147             <field name="arch" type="xml">
148                 <search string="Cases by Team and Stage">
149                     <field name="name"/>
150                     <field name="month"/>
151                     <field name="nbr"/>
152                     <field name="state"/>
153                     <field name="section_id"/>
154                </search>
155             </field>
156         </record>
157
158 <!-- Cases by section and stage Action -->
159
160     <record model="ir.actions.act_window" id="action_report_crm_case_section_stage_tree">
161         <field name="name">Cases By Section and Stage</field>
162         <field name="res_model">report.crm.case.section.stage</field>
163         <field name="view_type">form</field>
164         <field name="view_mode">graph,tree</field>
165         <field name="search_view_id" ref="view_crm_case_section_stage_filter"/>
166     </record>
167
168 <!-- Cases by section, category and stage Tree View -->
169
170     <record model="ir.ui.view" id="view_crm_case_section_categ_stage_tree">
171         <field name="name">CRM Report - Team, Category and Stage(Tree)</field>
172         <field name="model">report.crm.case.section.categ.stage</field>
173         <field name="arch" type="xml">
174             <tree string="Cases by Team, Category and Stage">
175                 <field name="name"/>
176                 <field name="month"/>
177                 <field name="user_id"/>
178                 <field name="section_id"/>
179                 <field name="categ_id"/>
180                 <field name="stage_id"/>
181                 <field name="nbr"/>
182                 <field name="delay_close"/>
183                 <field name="state"/>
184             </tree>
185         </field>
186     </record>
187
188 <!-- Cases by section, category and stage Form View -->
189
190     <record model="ir.ui.view" id="view_crm_case_section_categ_stage_form">
191         <field name="name">CRM Report - Team, Category and Stage(Form)</field>
192         <field name="model">report.crm.case.section.categ.stage</field>
193         <field name="arch" type="xml">
194             <form string="Cases by Section, Category and Stage">
195                 <field name="name"/>
196                 <field name="month"/>
197                 <field name="user_id"/>
198                 <field name="section_id"  widget="selection"/>
199                 <field name="categ_id"/>
200                 <field name="stage_id"/>
201                 <field name="nbr" />
202                 <field name="state" />
203                 <field name="delay_close"/>
204             </form>
205         </field>
206     </record>
207
208 <!-- Cases by section, category and stage Search View -->
209
210     <record id="view_crm_case_section_categ_stage_filter" model="ir.ui.view">
211             <field name="name">CRM Report - Section, Category and Stage(Select)</field>
212             <field name="model">report.crm.case.section.categ.stage</field>
213             <field name="arch" type="xml">
214                 <search string="Cases by Section, Category and Stage">
215                     <field name="name"/>
216                     <field name="month"/>
217                     <field name="nbr"/>
218                     <field name="state"/>
219                     <field name="section_id"/>
220                </search>
221             </field>
222         </record>
223
224 <!-- Cases by section, category and stage Graph View -->
225
226     <record model="ir.ui.view" id="view_crm_case_section_categ_stage_graph">
227         <field name="name">CRM Report - Section, Category and Stage(Select)</field>
228         <field name="model">report.crm.case.section.categ.stage</field>
229         <field name="arch" type="xml">
230             <graph string="Cases by Section, Category and Stage" type="bar" orientation="horizontal">
231                 <field name="categ_id"/>
232                 <field name="nbr" operator="+"/>
233                 <field name="section_id" group="True"/>
234             </graph>
235         </field>
236     </record>
237
238 <!-- Cases by section, category and stage Action -->
239
240     <record model="ir.actions.act_window" id="action_report_crm_case_section_categ_stage_tree">
241         <field name="name">Cases By Section ,Category and Stage</field>
242         <field name="res_model">report.crm.case.section.categ.stage</field>
243         <field name="view_type">form</field>
244         <field name="view_mode">tree,graph</field>
245         <field name="search_view_id" ref="view_crm_case_section_categ_stage_filter"/>
246     </record>
247
248 <!--  Cases by section, category and category2 Tree View -->
249
250     <record model="ir.ui.view" id="view_crm_case_section_categ_categ2_tree">
251         <field name="name">CRM Report - Section, Category and Type(Tree)</field>
252         <field name="model">report.crm.case.section.categ.categ2</field>
253         <field name="arch" type="xml">
254             <tree string="Cases by Section, Category and Type">
255                 <field name="name"/>
256                 <field name="month"/>
257                 <field name="user_id"/>
258                 <field name="section_id"/>
259                 <field name="categ_id"/>
260                 <field name="category2_id"/>
261                 <field name="stage_id"/>
262                 <field name="nbr"/>
263                 <field name="delay_close"/>
264                 <field name="state"/>
265             </tree>
266         </field>
267     </record>
268
269 <!--  Cases by section, category and category2 Form View -->
270
271     <record model="ir.ui.view" id="view_crm_case_section_categ_categ2_form">
272         <field name="name">CRM Report - Section, Category and Type(Form)</field>
273         <field name="model">report.crm.case.section.categ.categ2</field>
274         <field name="arch" type="xml">
275             <form string="Cases by Section, Category and Type">
276                 <field name="name"/>
277                 <field name="month"/>
278                 <field name="user_id"/>
279                 <field name="section_id"  widget="selection"/>
280                 <field name="categ_id"/>
281                 <field name="category2_id"/>
282                 <field name="stage_id"/>
283                 <field name="nbr" />
284                 <field name="state" />
285                 <field name="delay_close"/>
286             </form>
287         </field>
288     </record>
289
290 <!--  Cases by section, category and category2 Search View -->
291
292     <record id="view_crm_case_section_categ_categ2_filter" model="ir.ui.view">
293             <field name="name">CRM Report - Section, Category and Type(Select)</field>
294             <field name="model">report.crm.case.section.categ.categ2</field>
295             <field name="arch" type="xml">
296                 <search string="Search Cases by User">
297                     <field name="name"/>
298                     <field name="month"/>
299                     <field name="nbr"/>
300                     <field name="state"/>
301                     <field name="section_id"/>
302                </search>
303             </field>
304     </record>
305
306 <!--  Cases by section, category and category2 Graph View -->
307
308     <record model="ir.ui.view" id="view_crm_case_section_categ_categ2_graph">
309         <field name="name">CRM Report - Section, Category and Type(Select)</field>
310         <field name="model">report.crm.case.section.categ.categ2</field>
311         <field name="arch" type="xml">
312             <graph string="Cases by Section, Category and Type" type="bar" orientation="horizontal">
313                 <field name="category2_id"/>
314                 <field name="nbr" operator="+"/>
315                 <field name="section_id" group="True"/>
316             </graph>
317         </field>
318     </record>
319
320 <!--  Cases by section, category and category2 Action -->
321
322     <record model="ir.actions.act_window" id="action_report_crm_case_section_categ_categ2_tree">
323         <field name="name">Cases By Section ,Category and Category2</field>
324         <field name="res_model">report.crm.case.section.categ.categ2</field>
325         <field name="view_type">form</field>
326         <field name="view_mode">tree,graph</field>
327         <field name="search_view_id" ref="view_crm_case_section_categ_categ2_filter"/>
328     </record>
329
330 </data>
331 </openerp>