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                 <field name="date_due" invisible="1"/>
  31                 <field name="address_contact_id" invisible="1"/>
  32                 <field name="address_invoice_id" invisible="1"/>
  33                 <field name="account_id" invisible="1"/>
  34                 <field name="partner_bank" invisible="1"/>
  35                 <field name="residual"  sum="Total Residual"/>
  36                 <field name="delay_to_pay"  avg="Avg. Delay To Pay"/>
  37             </tree>
  38         </field>
  39     </record>
  40
  41     <record id="view_account_invoice_report_graph" model="ir.ui.view">
  42          <field name="name">account.invoice.report.graph</field>
  43          <field name="model">account.invoice.report</field>
  44          <field name="type">graph</field>
  45          <field name="arch" type="xml">
  46              <graph string="Invoices Statistics" type="bar">
  47                  <field name="product_id"/>
  48                  <field name="price_total"/>
  49              </graph>
  50          </field>
  51     </record>
  52
  53     <record id="view_account_invoice_report_search" model="ir.ui.view">
  54         <field name="name">account.invoice.report.search</field>
  55         <field name="model">account.invoice.report</field>
  56         <field name="type">search</field>
  57         <field name="arch" type="xml">
  58             <search string="Invoices">
  59               <group col="10" colspan="12">
  60                         <filter icon="terp-account" string="This Year"
  61                                     domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')),('date','&gt;',(datetime.date.today()-datetime.timedelta(days=365)).strftime('%%Y-%%m-%%d'))]"
  62                                     help="Invoices of the year"/>
  63                         <filter icon="terp-account" string="This Month"
  64                                         name="month"
  65                                         domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')), ('date','&gt;',(datetime.date.today()-datetime.timedelta(days=30)).strftime('%%Y-%%m-%%d'))]"
  66                                         help="Invoices of this month"/>
  67                         <filter icon="gtk-media-rewind"
  68                                 string="    7 Days    "
  69                                 separator="1"
  70                                 domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')), ('date','&gt;',(datetime.date.today()-datetime.timedelta(days=7)).strftime('%%Y-%%m-%%d'))]"
  71                                 help="Invoices during last 7 days"/>
  72                         <separator orientation="vertical"/>
  73                     <filter string="Draft"
  74                                 icon="terp-account"
  75                                 domain="[('state','=','draft')]"
  76                                 help = "Draft tasks"/>
  77                         <filter string="Pro-forma"
  78                                         icon="terp-account"
  79                                         domain="[('state','=','proforma'),('state','=','proforma2')]"
  80                                         help = "Pro-forma tasks"/>
  81                         <filter string="Current"
  82                                         icon="terp-account"
  83                                         domain="[('state', '=' ,'open')]"
  84                                         help = "In progress tasks"/>
  85                                         <separator orientation="vertical"/>
  86                 <field name="user_id" widget="selection">
  87
  88                     <filter icon="terp-account"
  89                                 string="My Invoices"
  90                                 help = "My Invoices"
  91                                 domain="[('user_id','=',uid)]" />
  92                     <filter icon="terp-account"
  93                                 string="Invoices Non Users"
  94                                 help="Invoices Non Users"
  95                                 domain="[('user_id','=',False)]"/>
  96                 </field>
  97                 <field name="product_id"/>
  98                 <field name="partner_id"/>
  99                                 <field name="company_id" groups="base.group_multi_company" widget="selection"/>
 100                                 </group>
 101                 <newline/>
 102                 <group expand="0" string="Extended options..." colspan="10" col="12">
 103                         <filter string="Done"
 104                                         icon="terp-account"
 105                                         domain="[('state','=','paid')]"
 106                                         help = "Done tasks"/>
 107                         <filter string="Cancelled"
 108                                 icon="terp-account"
 109                                 domain="[('state', '=' ,'cancel')]"
 110                                 help = "Cancelled tasks"/>
 111                         <separator orientation="vertical"/>
 112                         <field name="type"/>
 113                         <field name="payment_term" widget="selection"/>
 114                         <separator orientation="vertical"/>
 115                         <field name="currency_id" widget="selection"/>
 116                         <field name="journal_id" widget="selection"/>
 117                         <newline/>
 118                         <field name="address_contact_id"/>
 119                         <field name="address_invoice_id"/>
 120                         <separator orientation="vertical"/>
 121                         <field name="account_id"/>
 122                         <field name="partner_bank" widget="selection"/>
 123                         <separator orientation="vertical"/>
 124                         <field name="period_id" widget="selection"/>
 125                         <field name="fiscal_position" widget="selection"/>
 126                         <newline/>
 127                                         <field name="date" string="Date Invoiced"/>
 128                                         <separator orientation="vertical"/>
 129                                         <field name="date_due"/>
 130                 </group>
 131                 <newline/>
 132                 <group expand="1" string="Group By..." colspan="10" col="12">
 133                     <filter string="Salesman" name='User' icon="terp-account" context="{'group_by':'user_id'}"/>
 134                     <filter string="Product" icon="terp-account" context="{'group_by':'product_id'}"/>
 135                     <filter string="Partner" icon="terp-account" context="{'group_by':'partner_id'}"/>
 136                     <filter string="Company" icon="terp-account" context="{'group_by':'company_id'}" groups="base.group_multi_company"/>
 137                     <separator orientation="vertical"/>
 138                     <filter string="State" icon="terp-account" context="{'group_by':'state'}"/>
 139                     <filter string="Type" icon="terp-account" context="{'group_by':'type'}"/>
 140                     <filter string="Payment Term" icon="terp-account" context="{'group_by':'payment_term'}"/>
 141                     <separator orientation="vertical"/>
 142                     <filter string="Currency" icon="terp-account" context="{'group_by':'currency_id'}"/>
 143                     <filter string="Journal" icon="terp-account" context="{'group_by':'journal_id'}"/>
 144                     <separator orientation="vertical"/>
 145                     <filter string="Account" icon="terp-account" context="{'group_by':'account_id'}"/>
 146                     <filter string="Bank Account" icon="terp-account" context="{'group_by':'partner_bank'}"/>
 147                     <newline/>
 148                     <filter string="Contact Address Name" icon="terp-account" context="{'group_by':'address_contact_id'}"/>
 149                     <filter string="Invoice Address Name" icon="terp-account" context="{'group_by':'address_invoice_id'}"/>
 150                     <separator orientation="vertical"/>
 151                     <filter string="Force Period" icon="terp-account" context="{'group_by':'period_id'}"/>
 152                     <filter string="Fiscal Position" icon="terp-account" context="{'group_by':'fiscal_position'}"/>
 153                     <separator orientation="vertical"/>
 154                     <filter string="Day" icon="terp-account" context="{'group_by':'day'}"/>
 155                     <filter string="Month" icon="terp-account" context="{'group_by':'month'}"/>
 156                     <filter string="Year" icon="terp-account" context="{'group_by':'year'}"/>
 157                 </group>
 158             </search>
 159         </field>
 160     </record>
 161
 162     <record id="action_account_invoice_report_all" model="ir.actions.act_window">
 163         <field name="name">Invoices</field>
 164         <field name="res_model">account.invoice.report</field>
 165         <field name="view_type">form</field>
 166         <field name="view_mode">tree,graph</field>
 167         <field name="context">{'search_default_month':1,'search_default_User':1,'group_by_no_leaf':1,'group_by':[]}</field>
 168         <field name="search_view_id" ref="view_account_invoice_report_search"/>
 169     </record>
 170
 171     <menuitem action="action_account_invoice_report_all" id="menu_action_account_invoice_report_all" parent="account.menu_finance_reporting" sequence="0"/>
 172
 173 </data>
 174 </openerp>