addons/sale/report/sale_report_view.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3 <data>
   4
   5     <record id="view_order_product_tree" model="ir.ui.view">
   6         <field name="name">sale.report.tree</field>
   7         <field name="model">sale.report</field>
   8         <field name="type">tree</field>
   9         <field name="arch" type="xml">
  10             <tree string="Sales Analysis">
  11                 <field name="date" invisible="1"/>
  12                 <field name="user_id" invisible="1"/>
  13                 <field name="year" invisible="1"/>
  14                 <field name="day" invisible="1"/>
  15                 <field name="month" invisible="1"/>
  16                 <field name="shop_id" invisible="1"/>
  17                 <field name="company_id" invisible="1"/>
  18                 <field name="partner_id" invisible="1"/>
  19                 <field name="product_id" invisible="1"/>
  20                 <field name="categ_id" invisible="1"/>
  21                 <field name="nbr" sum="# of Lines"/>
  22                 <field name="product_qty" sum="# of Qty"/>
  23                 <field name="price_average" avg="Average Price"/>
  24                 <field name="price_total" sum="Total Price"/>
  25                 <field name="delay" avg="Days to Close"/>
  26                 <field name="state" invisible="1"/>
  27                 <field name="pricelist_id" invisible="1"/>
  28                 <field name="analytic_account_id" invisible="1"/>
  29             </tree>
  30         </field>
  31     </record>
  32
  33     <record id="view_order_product_graph" model="ir.ui.view">
  34          <field name="name">sale.report.graph</field>
  35          <field name="model">sale.report</field>
  36          <field name="type">graph</field>
  37          <field name="arch" type="xml">
  38              <graph string="Sales Analysis" type="bar">
  39                  <field name="product_id"/>
  40                  <field name="price_total"/>
  41                  <field name="state" group="True"/>
  42              </graph>
  43          </field>
  44     </record>
  45
  46     <record id="view_order_product_search" model="ir.ui.view">
  47         <field name="name">sale.report.search</field>
  48         <field name="model">sale.report</field>
  49         <field name="type">search</field>
  50         <field name="arch" type="xml">
  51             <search string="Sales Analysis">
  52                 <group>
  53                     <filter icon="terp-sale" string="Last 365 Days"
  54                             domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')),('date','&gt;',(datetime.date.today()-datetime.timedelta(days=365)).strftime('%%Y-%%m-%%d'))]"
  55                             help="Tasks performed in last 365 days"/>
  56                         <filter icon="terp-sale" string="Last 30 Days"
  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="Tasks performed in last 30 days"/>
  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="Tasks during last 7 days"/>
  65                         <separator orientation="vertical"/>
  66                         <filter icon="terp-sale"
  67                             string="Quotations"
  68                             domain="[('state','=','draft')]"/>
  69                         <filter icon="terp-sale"
  70                                 string="Sales"
  71                                 domain="[('state','not in',('draft','done','cancel'))]"/>
  72                         <separator orientation="vertical"/>
  73                         <field name="partner_id"/>
  74                     <field name="product_id"/>
  75                         <field name="user_id" widget="selection">
  76                             <filter icon="terp-sale"
  77                             string="My Sales"
  78                             help="My Sales"
  79                             domain="[('user_id','=',uid)]"/>
  80                         </field>
  81                         <field name="company_id" groups="base.group_multi_company" widget="selection"/>
  82                                 </group>
  83                                 <newline/>
  84                 <group expand="0" string="Extended options..." colspan="10" col="12">
  85                     <field name="date"/>
  86                     <separator orientation="vertical"/>
  87                     <field name="shop_id" widget="selection"/>
  88                     <field name="state"/>
  89                     <field name="categ_id" widget="selection"/>
  90                 </group>
  91                 <newline/>
  92                 <newline/>
  93                 <group expand="1" string="Group By..." colspan="10" col="12">
  94                     <filter string="Salesman" icon="terp-sale" name="User" context="{'group_by':'user_id'}"/>
  95                     <filter string="Shop" icon="terp-sale" context="{'group_by':'shop_id'}"/>
  96                     <filter string="Company" icon="terp-sale" groups="base.group_multi_company" context="{'group_by':'company_id'}"/>
  97                     <separator orientation="vertical"/>
  98                     <filter string="Product" icon="terp-sale" context="{'group_by':'product_id'}"/>
  99                     <filter string="Partner" icon="terp-sale" context="{'group_by':'partner_id'}"/>
 100                     <filter string="State" icon="terp-sale" context="{'group_by':'state'}"/>
 101                     <separator orientation="vertical"/>
 102                     <filter string="Pricelist" icon="terp-sale" context="{'group_by':'pricelist_id'}"/>
 103                     <filter string="Analytic Account" icon="terp-sale" context="{'group_by':'analytic_account_id'}"/>
 104                     <filter string="Category of Product" icon="terp-sale" context="{'group_by':'categ_id'}"/>
 105                     <separator orientation="vertical"/>
 106                                         <filter string="Day" icon="terp-sale" context="{'group_by':'day'}"/>
 107                     <filter string="Month" icon="terp-sale" context="{'group_by':'month'}"/>
 108                     <filter string="Year" icon="terp-sale" context="{'group_by':'year'}"/>
 109                 </group>
 110             </search>
 111         </field>
 112     </record>
 113
 114     <record id="action_order_report_all" model="ir.actions.act_window">
 115         <field name="name">Sales Analysis</field>
 116         <field name="res_model">sale.report</field>
 117         <field name="view_type">form</field>
 118         <field name="view_mode">tree,graph</field>
 119         <field name="search_view_id" ref="view_order_product_search"/>
 120         <field name="context">{'search_default_month':1,'search_default_User':1,'group_by_no_leaf':1,'group_by':[]}</field>
 121     </record>
 122
 123     <menuitem id="base.next_id_64" name="Reporting" parent="base.menu_base_partner" sequence="8"/>
 124     <menuitem action="action_order_report_all" id="menu_report_product_all" parent="base.next_id_64" sequence="3"/>
 125
 126     <!--This views used in board_sale module -->
 127     <record id="view_sale_order_by_clients_tree" model="ir.ui.view">
 128         <field name="name">sale.order.by.clients.tree</field>
 129         <field name="model">sale.order.by.clients</field>
 130         <field name="type">tree</field>
 131         <field name="arch" type="xml">
 132             <tree string="Sales order by clients">
 133                 <field name="partner_id"/>
 134                 <field name="total_orders"/>
 135             </tree>
 136         </field>
 137     </record>
 138
 139     <record id="view_sale_order_by_clients_graph" model="ir.ui.view">
 140          <field name="name">sale.order.by.clients.graph</field>
 141          <field name="model">sale.order.by.clients</field>
 142          <field name="type">graph</field>
 143          <field name="arch" type="xml">
 144              <graph string="Sales order by clients" type="bar">
 145                  <field name="partner_id" />
 146                  <field name="total_orders" operator="+"/>
 147              </graph>
 148          </field>
 149     </record>
 150
 151    <record id="action_sale_order_by_clients" model="ir.actions.act_window">
 152         <field name="name">Sales Orders</field>
 153         <field name="res_model">sale.order.by.clients</field>
 154         <field name="view_type">form</field>
 155         <field name="view_mode">tree,graph</field>
 156         <field name="view_id" ref="view_sale_order_by_clients_tree"/>
 157     </record>
 158
 159    <record id="view_uninvoiced_lines_per_month_tree" model="ir.ui.view">
 160         <field name="name">uninvoiced.lines.per.month.tree</field>
 161         <field name="model">uninvoiced.lines.per.month</field>
 162         <field name="type">tree</field>
 163         <field name="arch" type="xml">
 164             <tree string="Uninvoiced lines per month">
 165                 <field name="year"/>
 166                 <field name="month"/>
 167                 <field name="number_of_lines"/>
 168             </tree>
 169         </field>
 170     </record>
 171
 172     <record id="view_uninvoiced_lines_per_month_graph" model="ir.ui.view">
 173          <field name="name">uninvoiced.lines.per.month.graph</field>
 174          <field name="model">uninvoiced.lines.per.month</field>
 175          <field name="type">graph</field>
 176          <field name="arch" type="xml">
 177              <graph string="Uninvoiced lines per month" type="bar">
 178                  <field name="month" />
 179                  <field name="number_of_lines" operator="+"/>
 180              </graph>
 181          </field>
 182     </record>
 183
 184    <record id="action_suninvoiced_lines_per_month" model="ir.actions.act_window">
 185         <field name="name">Uninvoiced Lines</field>
 186         <field name="res_model">uninvoiced.lines.per.month</field>
 187         <field name="view_type">form</field>
 188         <field name="view_mode">tree,graph</field>
 189         <field name="view_id" ref="view_uninvoiced_lines_per_month_tree"/>
 190     </record>
 191
 192     <record id="view_product_bought_by_sale_order_tree" model="ir.ui.view">
 193         <field name="name">product.bought.by.sale.order.tree</field>
 194         <field name="model">product.bought.by.sale.order</field>
 195         <field name="type">tree</field>
 196         <field name="arch" type="xml">
 197             <tree string="Product bought by sale order">
 198                 <field name="product_id"/>
 199                  <field name="month"/>
 200                  <field name="year"/>
 201                 <field name="total_products"/>
 202             </tree>
 203         </field>
 204     </record>
 205
 206     <record id="view_product_bought_by_sale_order_graph" model="ir.ui.view">
 207          <field name="name">product.bought.by.sale.order.graph</field>
 208          <field name="model">product.bought.by.sale.order</field>
 209          <field name="type">graph</field>
 210          <field name="arch" type="xml">
 211              <graph string="Product bought by sale order" type="bar">
 212                  <field name="product_id" select="1"/>
 213                  <field name="total_products" select="1"/>
 214                  <field name="month" group = "True"/>
 215              </graph>
 216          </field>
 217     </record>
 218
 219    <record id="action_product_bought_by_sale_order" model="ir.actions.act_window">
 220         <field name="name">Product bought by sale order</field>
 221         <field name="res_model">product.bought.by.sale.order</field>
 222         <field name="view_type">form</field>
 223         <field name="view_mode">graph,tree</field>
 224         <field name="domain">[('year','=', time.strftime('%Y'))]</field>
 225         <field name="view_id" ref="view_product_bought_by_sale_order_tree"/>
 226     </record>
 227
 228    <record id="view_sales_by_regions_tree" model="ir.ui.view">
 229         <field name="name">sales.by.regions.tree</field>
 230         <field name="model">sales.by.regions</field>
 231         <field name="type">tree</field>
 232         <field name="arch" type="xml">
 233             <tree string="Sales by regions">
 234                 <field name="name"/>
 235                 <field name="total_sales"/>
 236             </tree>
 237         </field>
 238     </record>
 239
 240     <record id="view_sales_by_regions_graph" model="ir.ui.view">
 241          <field name="name">sales.by.regions.graph</field>
 242          <field name="model">sales.by.regions</field>
 243          <field name="type">graph</field>
 244          <field name="arch" type="xml">
 245              <graph string="Sales by regions" type="bar">
 246                  <field name="name"/>
 247                  <field name="total_sales" operator="+"/>
 248              </graph>
 249          </field>
 250     </record>
 251
 252    <record id="action_sales_by_regions" model="ir.actions.act_window">
 253         <field name="name">Sales by regions</field>
 254         <field name="res_model">sales.by.regions</field>
 255         <field name="view_type">form</field>
 256         <field name="view_mode">tree,graph</field>
 257         <field name="view_id" ref="view_sales_by_regions_tree"/>
 258     </record>
 259
 260 </data>
 261 </openerp>