addons/report_sale/report_sale_view.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3     <data>
   4
   5         <!--  Sales by products by month -->
   6         <record id="view_order_product_form" model="ir.ui.view">
   7             <field name="name">report.sale.order.product.form</field>
   8             <field name="model">report.sale.order.product</field>
   9             <field name="type">form</field>
  10             <field name="arch" type="xml">
  11                 <form string="Sales by Product">
  12                     <field name="name" 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
  24         <record id="view_order_product_tree" model="ir.ui.view">
  25             <field name="name">report.sale.order.product.tree</field>
  26             <field name="model">report.sale.order.product</field>
  27             <field name="type">tree</field>
  28             <field name="arch" type="xml">
  29                 <tree string="Sales by Product">
  30                     <field name="name"/>
  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="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="action_order_product_tree" model="ir.actions.act_window">
  54             <field name="name">Sales by Product (this month)</field>
  55             <field name="res_model">report.sale.order.product</field>
  56             <field name="view_type">form</field>
  57             <field name="view_mode">graph,tree</field>
  58             <field name="domain">[('name','=',time.strftime('%Y-%m-01'))]</field>
  59         </record>
  60         <menuitem id="next_id_80" name="Reporting" parent="sale.menu_sale_root"/><menuitem id="next_id_81" name="This Month" parent="next_id_80"/><menuitem action="action_order_product_tree" id="menu_report_order_product" parent="next_id_81"/>
  61         <record id="action_order_product_tree_all" model="ir.actions.act_window">
  62             <field name="name">Sales by Product</field>
  63             <field name="res_model">report.sale.order.product</field>
  64             <field name="view_type">form</field>
  65             <field name="view_mode">graph,tree</field>
  66         </record>
  67         <menuitem id="next_id_82" name="All Months" parent="report_sale.next_id_80"/><menuitem action="action_order_product_tree_all" id="menu_report_order_product_all" parent="next_id_82"/>
  68
  69         <!-- Sales by category by month -->
  70
  71         <record id="view_order_category_form" model="ir.ui.view">
  72             <field name="name">report.sale.order.category.form</field>
  73             <field name="model">report.sale.order.category</field>
  74             <field name="type">form</field>
  75             <field name="arch" type="xml">
  76                 <form string="Sales Orders by category">
  77                     <field name="name" select="1"/>
  78                     <field name="category_id" select="1"/>
  79                     <field name="count"/>
  80                     <field name="quantity" select="2"/>
  81                     <field name="price_total" select="2"/>
  82                     <field name="price_average" select="2"/>
  83                     <field name="state" select="1"/>
  84                 </form>
  85             </field>
  86         </record>
  87
  88         <record id="view_order_category_tree" model="ir.ui.view">
  89             <field name="name">report.sale.order.category.tree</field>
  90             <field name="model">report.sale.order.category</field>
  91             <field name="type">tree</field>
  92             <field name="arch" type="xml">
  93                 <tree string="Sales by Category of Products">
  94                     <field name="name"/>
  95                     <field name="category_id"/>
  96                     <field name="count"/>
  97                     <field name="quantity"/>
  98                     <field name="price_total"/>
  99                     <field name="price_average"/>
 100                     <field name="state"/>
 101                 </tree>
 102             </field>
 103         </record>
 104
 105         <record id="view_order_category_graph" model="ir.ui.view">
 106             <field name="name">report.sale.order.category.graph</field>
 107             <field name="model">report.sale.order.category</field>
 108             <field name="type">graph</field>
 109             <field name="arch" type="xml">
 110                 <graph string="Sales by Category of Products" type="pie">
 111                     <field name="category_id"/>
 112                     <field name="price_average"/>
 113                 </graph>
 114             </field>
 115         </record>
 116         <record id="action_order_category_tree" model="ir.actions.act_window">
 117             <field name="name">Sales by Category of Product (this month)</field>
 118             <field name="res_model">report.sale.order.category</field>
 119             <field name="view_type">form</field>
 120             <field name="view_mode">graph,tree</field>
 121             <field name="domain">[('name','=',time.strftime('%Y-%m-01'))]</field>
 122         </record>
 123         <menuitem action="action_order_category_tree" id="menu_report_order_category" parent="report_sale.next_id_81"/>
 124         <record id="action_order_category_tree_all" model="ir.actions.act_window">
 125             <field name="name">Sales by Category of Products</field>
 126             <field name="res_model">report.sale.order.category</field>
 127             <field name="view_type">form</field>
 128             <field name="view_mode">graph,tree</field>
 129         </record>
 130         <menuitem action="action_order_category_tree_all" id="menu_report_order_category_all" parent="report_sale.next_id_82"/>
 131
 132         <!-- Sales of the month -->
 133         <record id="view_order_graph" model="ir.ui.view">
 134              <field name="name">sale.order.graph</field>
 135              <field name="model">sale.order</field>
 136              <field name="type">graph</field>
 137              <field name="arch" type="xml">
 138                  <graph string="Sales orders" type="pie">
 139                      <field name="partner_id"/>
 140                      <field name="amount_untaxed"/>
 141                  </graph>
 142              </field>
 143         </record>
 144         <record id="action_order_sale_list" model="ir.actions.act_window">
 145             <field name="name">Sales of the Month</field>
 146             <field name="res_model">sale.order</field>
 147             <field name="view_type">form</field>
 148             <field name="view_mode">graph,tree,form</field>
 149             <field name="domain">[('date_order','&gt;=',time.strftime('%Y-%m-01')),('state','&lt;&gt;','draft'),('state','&lt;&gt;','cancel')]</field>
 150         </record>
 151         <menuitem action="action_order_sale_list" id="menu_report_order_sale_list" parent="report_sale.next_id_81"/>
 152
 153
 154
 155
 156     </data>
 157 </openerp>