[IMP]:account:improved SQL report.(expand=0)
[odoo/odoo.git] / addons / account / report / account_invoice_report_view.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <openerp>
3 <data>
4     <record id="view_account_invoice_report_tree" model="ir.ui.view">
5         <field name="name">account.invoice.report.tree</field>
6         <field name="model">account.invoice.report</field>
7         <field name="type">tree</field>
8         <field name="arch" type="xml">
9             <tree string="Invoices Statistics">
10                 <field name="date" invisible="1"/>
11                 <field name="user_id" invisible="1"/>
12                 <field name="year" invisible="1"/>
13                 <field name="day" invisible="1"/>
14                 <field name="month" invisible="1"/>
15                 <field name="type" invisible="1"/>
16                 <field name="company_id" invisible="1"/>
17                 <field name="partner_id" invisible="1"/>
18                 <field name="product_id" invisible="1"/>
19                 <field name="product_qty" invisible="1"/>
20                 <!--field name="delay" avg="Days to Close"/-->
21                 <field name="nbr" sum="# of Lines"/>
22                 <field name="price_average" avg="Average Price"/>
23                 <field name="price_total" sum="Total Price"/>
24                 <field name="state" invisible="1"/>
25                 <field name="payment_term" invisible="1"/>
26                 <field name="period_id" invisible="1"/>
27                 <field name="fiscal_position" invisible="1"/>
28                 <field name="currency_id" invisible="1"/>
29                 <field name="journal_id" invisible="1"/>
30             </tree>
31         </field>
32     </record>
33
34     <record id="view_account_invoice_report_graph" model="ir.ui.view">
35          <field name="name">account.invoice.report.graph</field>
36          <field name="model">account.invoice.report</field>
37          <field name="type">graph</field>
38          <field name="arch" type="xml">
39              <graph string="Invoices Statistics" type="bar">
40                  <field name="product_id"/>
41                  <field name="price_total"/>
42              </graph>
43          </field>
44     </record>
45
46     <record id="view_account_invoice_report_search" model="ir.ui.view">
47         <field name="name">account.invoice.report.search</field>
48         <field name="model">account.invoice.report</field>
49         <field name="type">search</field>
50         <field name="arch" type="xml">
51             <search string="Invoices">
52                 <group>
53                         <filter icon="terp-account" string="This Year"
54                                     domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')),('date','&gt;',(datetime.date.today()-datetime.timedelta(days=365)).strftime('%%Y-%%m-%%d'))]"
55                                     help="Invoices of the year"/>
56                         <filter icon="terp-account" string="This Month"
57                                         name="month"
58                                         domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')), ('date','&gt;',(datetime.date.today()-datetime.timedelta(days=30)).strftime('%%Y-%%m-%%d'))]"
59                                         help="Invoices of this month"/>
60                         <filter icon="gtk-media-rewind"
61                                 string="    7 Days    "
62                                 separator="1"
63                                 domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')), ('date','&gt;',(datetime.date.today()-datetime.timedelta(days=7)).strftime('%%Y-%%m-%%d'))]"
64                                 help="Invoices during last 7 days"/>
65                         <separator orientation="vertical"/>
66                     <filter string="Draft"
67                                 icon="terp-account"
68                                 domain="[('state','=','draft')]"
69                                 help = "Draft tasks"/>
70                         <filter string="Pro-forma"
71                                         icon="terp-account"
72                                         domain="[('state','=','proforma'),('state','=','proforma2')]"
73                                         help = "Pro-forma tasks"/>
74                         <filter string="Current"
75                                         icon="terp-account"
76                                         domain="[('state', '=' ,'open')]"
77                                         help = "In progress tasks"/>
78                                         <separator orientation="vertical"/>
79                 <field name="product_id"/>
80                 <field name="user_id" widget="selection">
81
82                     <filter icon="terp-account"
83                                 string="My Invoices"
84                                 help = "My Invoices"
85                                 domain="[('user_id','=',uid)]" />
86                     <filter icon="terp-account"
87                                 string="Invoices Non Users"
88                                 help="Invoices Non Users"
89                                 domain="[('user_id','=',False)]"/>
90                 </field>
91                 <field name="partner_id"/>
92                                 <field name="company_id" groups="base.group_multi_company" widget="selection"/>
93                                 </group>
94                 <newline/>
95                 <group expand="0" string="Extended options..." colspan="10" col="12">
96                         <filter string="Done"
97                                         icon="terp-account"
98                                         domain="[('state','=','paid')]"
99                                         help = "Done tasks"/>
100                         <filter string="Cancelled"
101                                 icon="terp-account"
102                                 domain="[('state', '=' ,'cancel')]"
103                                 help = "Cancelled tasks"/>
104                         <separator orientation="vertical"/>
105                         <field name="payment_term" widget="selection"/>
106                         <field name="currency_id" widget="selection"/>
107                         <field name="journal_id" widget="selection"/>
108                         <newline/>
109                         <field name="type"/>
110                         <field name="period_id" widget="selection"/>
111                         <field name="fiscal_position" widget="selection"/>
112                                         <field name="date"/>
113                 </group>
114                 <newline/>
115                 <group expand="1" string="Group By..." colspan="10" col="12">
116                     <filter string="Company" icon="terp-account" context="{'group_by':'company_id'}" groups="base.group_multi_company"/>
117                     <filter string="Salesman" name='User' icon="terp-account" context="{'group_by':'user_id'}"/>
118                     <filter string="Payment Term" icon="terp-account" context="{'group_by':'payment_term'}"/>
119                     <separator orientation="vertical"/>
120                     <filter string="Currency" icon="terp-account" context="{'group_by':'currency_id'}"/>
121                     <filter string="Journal" icon="terp-account" context="{'group_by':'journal_id'}"/>
122                     <filter string="Product" icon="terp-account" context="{'group_by':'product_id'}"/>
123                     <separator orientation="vertical"/>
124                     <filter string="Partner" icon="terp-account" context="{'group_by':'partner_id'}"/>
125                     <filter string="Type" icon="terp-account" context="{'group_by':'type'}"/>
126                     <filter string="State" icon="terp-account" context="{'group_by':'state'}"/>
127                     <separator orientation="vertical"/>
128                     <filter string="Force Period" icon="terp-account" context="{'group_by':'period_id'}"/>
129                     <filter string="Fiscal Position" icon="terp-account" context="{'group_by':'fiscal_position'}"/>
130                     <separator orientation="vertical"/>
131                     <filter string="Day" icon="terp-account" context="{'group_by':'day'}"/>
132                     <filter string="Month" icon="terp-account" context="{'group_by':'date'}"/>
133                     <filter string="Year" icon="terp-account" context="{'group_by':'year'}"/>
134                 </group>
135             </search>
136         </field>
137     </record>
138
139     <record id="action_account_invoice_report_all" model="ir.actions.act_window">
140         <field name="name">Invoices</field>
141         <field name="res_model">account.invoice.report</field>
142         <field name="view_type">form</field>
143         <field name="view_mode">tree,graph</field>
144         <field name="context">{'search_default_month':1,'search_default_User':1,'group_by_no_leaf':1,'group_by':[]}</field>
145         <field name="search_view_id" ref="view_account_invoice_report_search"/>
146     </record>
147
148     <menuitem action="action_account_invoice_report_all" id="menu_action_account_invoice_report_all" parent="account.menu_finance_reporting" sequence="0"/>
149
150 </data>
151 </openerp>