addons/report_sale/report_sale_view.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3   <data>
   4         <!--  Sales by products by month -->
   5         <record id="view_order_product_form" model="ir.ui.view">
   6             <field name="name">report.sale.order.product.form</field>
   7             <field name="model">report.sale.order.product</field>
   8             <field name="type">form</field>
   9             <field name="arch" type="xml">
  10                 <form string="Sale Orders by Product">
  11                     <field name="name" select="1"/>
  12                     <field name="month" select="1"/>
  13                     <field name="product_id" select="1"/>
  14                     <field name="count"/>
  15                     <field name="quantity" select="2"/>
  16                     <field name="price_total" select="2"/>
  17                     <field name="price_average" select="2"/>
  18                     <field name="state" select="1"/>
  19                 </form>
  20             </field>
  21         </record>
  22
  23         <record id="view_order_product_tree" model="ir.ui.view">
  24             <field name="name">report.sale.order.product.tree</field>
  25             <field name="model">report.sale.order.product</field>
  26             <field name="type">tree</field>
  27             <field name="arch" type="xml">
  28                 <tree string="Sale Orders by Product">
  29                     <field name="name"/>
  30                     <field name="month" />
  31                     <field name="product_id"/>
  32                     <field name="count"/>
  33                     <field name="quantity"/>
  34                     <field name="price_total"/>
  35                     <field name="price_average"/>
  36                     <field name="state"/>
  37                 </tree>
  38             </field>
  39         </record>
  40
  41         <record id="view_order_product_graph" model="ir.ui.view">
  42              <field name="name">report.sale.order.product.graph</field>
  43              <field name="model">report.sale.order.product</field>
  44              <field name="type">graph</field>
  45              <field name="arch" type="xml">
  46                  <graph string="Average Sales by Product" type="pie">
  47                      <field name="product_id"/>
  48                      <field name="price_average"/>
  49                  </graph>
  50              </field>
  51         </record>
  52
  53         <record id="view_order_product_search" model="ir.ui.view">
  54             <field name="name">report.sale.order.product.search</field>
  55             <field name="model">report.sale.order.product</field>
  56             <field name="type">search</field>
  57             <field name="arch" type="xml">
  58                 <search string="Sale Orders by Product">
  59                         <group col="8" colspan="4">
  60                                 <filter icon="terp-sale" string="This Year" domain="[('name','=',time.strftime('%%Y'))]" help="Sale orders during this year"/>
  61                                 <filter icon="terp-sale" string="This Month" domain="[('month','=',time.strftime('%%m'))]" help="Sale orders during this month"/>
  62                                 <separator orientation="vertical"/>
  63                             <field name="name" select="1"/>
  64                             <field name="month" select="1"/>
  65                             <field name="product_id" select="1"/>
  66                             <field name="state" select="1"/>
  67                             </group>
  68                                 <group expand="1" string="Group By..." colspan="4" col="8">
  69                         <filter string="By Year" icon="terp-sale" domain="[]"  context="{'group_by':'name'}"/>
  70                         <filter string="By Month" icon="terp-sale" domain="[]" context="{'group_by':'month'}"/>
  71                         <filter string="By State" icon="terp-sale" domain="[]" context="{'group_by':'state'}"/>
  72                         <filter string="By Product" icon="terp-sale" domain="[]" context="{'group_by':'product_id'}"/>
  73                         </group>
  74                 </search>
  75             </field>
  76         </record>
  77
  78         <record id="action_order_product_tree_all" model="ir.actions.act_window">
  79             <field name="name">Sale Orders by Product</field>
  80             <field name="res_model">report.sale.order.product</field>
  81             <field name="view_type">form</field>
  82             <field name="view_mode">graph,tree</field>
  83             <field name="search_view_id" ref="view_order_product_search"/>
  84         </record>
  85
  86                 <menuitem id="base.next_id_64" name="Reporting" parent="base.menu_base_partner" sequence="8"/>
  87 <!--        <menuitem id="base.next_id_80" name="Reporting" parent="base.menu_base_partner" sequence="7"/>-->
  88         <menuitem action="action_order_product_tree_all" id="menu_report_order_product_all" parent="base.next_id_64" sequence="3"/>
  89
  90         <!-- Sales by category by month -->
  91
  92         <record id="view_order_category_form" model="ir.ui.view">
  93             <field name="name">report.sale.order.category.form</field>
  94             <field name="model">report.sale.order.category</field>
  95             <field name="type">form</field>
  96             <field name="arch" type="xml">
  97                 <form string="Sale Orders by category">
  98                     <field name="name" select="1"/>
  99                     <field name="month" select="1"/>
 100                     <field name="category_id" select="1"/>
 101                     <field name="count"/>
 102                     <field name="quantity" select="2"/>
 103                     <field name="price_total" select="2"/>
 104                     <field name="price_average" select="2"/>
 105                     <field name="state" select="1"/>
 106                 </form>
 107             </field>
 108         </record>
 109
 110         <record id="view_order_category_tree" model="ir.ui.view">
 111             <field name="name">report.sale.order.category.tree</field>
 112             <field name="model">report.sale.order.category</field>
 113             <field name="type">tree</field>
 114             <field name="arch" type="xml">
 115                 <tree string="Sale Orders by Category of Products">
 116                     <field name="name"/>
 117                     <field name="month" />
 118                     <field name="category_id"/>
 119                     <field name="count"/>
 120                     <field name="quantity"/>
 121                     <field name="price_total"/>
 122                     <field name="price_average"/>
 123                     <field name="state"/>
 124                 </tree>
 125             </field>
 126         </record>
 127
 128         <record id="view_order_category_graph" model="ir.ui.view">
 129             <field name="name">report.sale.order.category.graph</field>
 130             <field name="model">report.sale.order.category</field>
 131             <field name="type">graph</field>
 132             <field name="arch" type="xml">
 133                 <graph string="Average Sales by Category of Products" type="pie">
 134                     <field name="category_id"/>
 135                     <field name="price_average"/>
 136                 </graph>
 137             </field>
 138         </record>
 139
 140                 <record id="view_order_category_search" model="ir.ui.view">
 141             <field name="name">report.sale.order.category.search</field>
 142             <field name="model">report.sale.order.category</field>
 143             <field name="type">search</field>
 144             <field name="arch" type="xml">
 145                 <search string="Sale Orders by Category of Products">
 146                         <group col="8" colspan="4">
 147                                 <filter icon="terp-sale" string="This Year" domain="[('name','=',time.strftime('%%Y'))]" help="Sale orders during this year"/>
 148                                 <filter icon="terp-sale" string="This Month" domain="[('month','=',time.strftime('%%m'))]" help="Sale orders during this month"/>
 149                                 <separator orientation="vertical"/>
 150                             <field name="name" select="1"/>
 151                             <field name="month" select="1"/>
 152                             <field name="category_id" select="1"/>
 153                             <field name="state" select="1"/>
 154                                                 </group>
 155                                 <group expand="1" string="Group By..." colspan="4" col="20">
 156                         <filter string="By Year" icon="terp-sale" domain="[]"  context="{'group_by':'name'}"/>
 157                         <filter string="By Month" icon="terp-sale" domain="[]" context="{'group_by':'month'}"/>
 158                         <filter string="By State" icon="terp-sale" domain="[]" context="{'group_by':'state'}"/>
 159                         <filter string="By Category" icon="terp-sale" domain="[]" context="{'group_by':'category_id'}"/>
 160                                                 </group>
 161
 162                 </search>
 163             </field>
 164         </record>
 165
 166         <record id="action_order_category_tree_all" model="ir.actions.act_window">
 167             <field name="name">Sale Orders by Category of Products</field>
 168             <field name="res_model">report.sale.order.category</field>
 169             <field name="view_type">form</field>
 170             <field name="view_mode">graph,tree</field>
 171             <field name="search_view_id" ref="view_order_category_search"/>
 172         </record>
 173         <menuitem action="action_order_category_tree_all" id="menu_report_order_category_all" parent="base.next_id_64" sequence="4"/>
 174
 175         <!-- Sales of the month -->
 176         <record id="view_order_graph" model="ir.ui.view">
 177              <field name="name">sale.order.graph</field>
 178              <field name="model">sale.order</field>
 179              <field name="type">graph</field>
 180              <field name="arch" type="xml">
 181                  <graph string="Sale orders" type="pie">
 182                      <field name="partner_id"/>
 183                      <field name="amount_untaxed"/>
 184                  </graph>
 185              </field>
 186         </record>
 187         <record id="action_order_sale_list" model="ir.actions.act_window">
 188             <field name="name">Sale Orders of the Month</field>
 189             <field name="res_model">sale.order</field>
 190             <field name="view_type">form</field>
 191             <field name="view_mode">graph,tree,form</field>
 192             <field name="domain">[('date_order','&gt;=',time.strftime('%Y-%m-01')),('state','&lt;&gt;','draft'),('state','&lt;&gt;','cancel')]</field>
 193         </record>
 194         <menuitem action="action_order_sale_list" id="menu_report_order_sale_list" parent="base.next_id_64" sequence="5"/>
 195
 196                 <record id="view_so_pipeline_graph" model="ir.ui.view">
 197              <field name="name">sale.order.dashboard.graph</field>
 198              <field name="model">sale.order</field>
 199              <field name="type">graph</field>
 200              <field name="arch" type="xml">
 201                 <graph string="Sales by State" type="bar">
 202                      <field name="state"/>
 203                      <field name="amount_total"/>
 204                  </graph>
 205              </field>
 206         </record>
 207
 208         <record id="action_so_pipeline" model="ir.actions.act_window">
 209             <field name="name">Sales by State</field>
 210             <field name="res_model">sale.order</field>
 211             <field name="view_type">form</field>
 212             <field name="view_mode">graph,tree,form</field>
 213             <field name="view_id" ref="view_so_pipeline_graph"/>
 214             <field name="domain">[('state','&lt;&gt;','done')]</field>
 215         </record>
 216
 217                 <!-- Turnover Per Month -->
 218
 219                 <record model="ir.ui.view" id="view_turnover_month_tree">
 220             <field name="name">report.turnover.per.month.tree</field>
 221             <field name="model">report.turnover.per.month</field>
 222             <field name="type">tree</field>
 223             <field name="arch" type="xml">
 224                 <tree string="Turnover Per Month">
 225                         <field name="name" select="1"/>
 226                         <field name="turnover" select="2"/>
 227                 </tree>
 228             </field>
 229         </record>
 230
 231         <record id="view_turnover_month_graph" model="ir.ui.view">
 232              <field name="name">report.turnover.per.month.graph</field>
 233              <field name="model">report.turnover.per.month</field>
 234              <field name="type">graph</field>
 235              <field name="arch" type="xml">
 236                  <graph string="Turnover Per Month" type="bar">
 237                     <field name="name" />
 238                         <field name="turnover" />
 239                  </graph>
 240              </field>
 241         </record>
 242
 243                 <record model="ir.actions.act_window" id="action_turnover_month_tree">
 244             <field name="type">ir.actions.act_window</field>
 245             <field name="name">Turnover Per Month</field>
 246             <field name="res_model">report.turnover.per.month</field>
 247             <field name="view_type">form</field>
 248             <field name="view_mode">tree,graph</field>
 249             <field name="view_id" ref="view_turnover_month_tree"/>
 250         </record>
 251
 252         <!-- Turnover Per Product -->
 253
 254                 <record model="ir.ui.view" id="view_turnover_product_tree">
 255             <field name="name">report.turnover.per.product.tree</field>
 256             <field name="model">report.turnover.per.product</field>
 257             <field name="type">tree</field>
 258             <field name="arch" type="xml">
 259                 <tree string="Turnover Per Product">
 260                         <field name="product_id" select="1"/>
 261                         <field name="turnover" select="2"/>
 262                 </tree>
 263             </field>
 264         </record>
 265
 266         <record id="view_turnover_product_graph" model="ir.ui.view">
 267              <field name="name">report.turnover.per.product.graph</field>
 268              <field name="model">report.turnover.per.product</field>
 269              <field name="type">graph</field>
 270              <field name="arch" type="xml">
 271                  <graph string="Turnover Per Product" type="bar">
 272                     <field name="product_id" />
 273                         <field name="turnover" />
 274                  </graph>
 275              </field>
 276         </record>
 277
 278                 <record model="ir.actions.act_window" id="action_turnover_product_tree">
 279             <field name="type">ir.actions.act_window</field>
 280             <field name="name">Turnover Per Product</field>
 281             <field name="res_model">report.turnover.per.product</field>
 282             <field name="view_type">form</field>
 283             <field name="view_mode">tree,graph</field>
 284             <field name="view_id" ref="view_turnover_product_tree"/>
 285         </record>
 286
 287                 <!-- Created Sale orders for random activities dashboard -->
 288
 289                 <record id="board_view_created_sale_order" model="ir.ui.view">
 290             <field name="name">report.sale.order.created.tree</field>
 291             <field name="model">report.sale.order.created</field>
 292             <field name="type">tree</field>
 293             <field name="arch" type="xml">
 294                 <tree string="Created Sale orders">
 295                         <field name="create_date" select="1"/>
 296                     <field name="date_order"/>
 297                     <field name="name" string="Reference" select="1"/>
 298                     <field name="partner_id" select="2"/>
 299                     <field name="partner_shipping_id"/>
 300                     <field name="amount_untaxed"/>
 301                     <field name="state" select="1"/>
 302                 </tree>
 303             </field>
 304         </record>
 305
 306         <record id="action_view_created_sale_order_dashboard" model="ir.actions.act_window">
 307             <field name="name">Created Sale Orders</field>
 308             <field name="res_model">report.sale.order.created</field>
 309             <field name="view_type">form</field>
 310             <field name="view_mode">tree,form</field>
 311             <field name="view_id" ref="board_view_created_sale_order"/>
 312         </record>
 313     </data>
 314 </openerp>