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                 <record id="view_so_pipeline_graph" model="ir.ui.view">
 154              <field name="name">sale.order.dashboard.graph</field>
 155              <field name="model">sale.order</field>
 156              <field name="type">graph</field>
 157              <field name="arch" type="xml">
 158                  <graph string="Sales by State" type="bar">
 159                      <field name="state"/>
 160                      <field name="amount_total"/>
 161                  </graph>
 162              </field>
 163         </record>
 164
 165         <record id="action_so_pipeline" model="ir.actions.act_window">
 166             <field name="name">Sales by State</field>
 167             <field name="res_model">sale.order</field>
 168             <field name="view_type">form</field>
 169             <field name="view_mode">graph,tree,form</field>
 170             <field name="view_id" ref="view_so_pipeline_graph"/>
 171             <field name="domain">[('state','&lt;&gt;','done')]</field>
 172         </record>
 173
 174                 <!-- Turnover Per Month -->
 175
 176                 <record model="ir.ui.view" id="view_turnover_month_tree">
 177             <field name="name">report.turnover.per.month.tree</field>
 178             <field name="model">report.turnover.per.month</field>
 179             <field name="type">tree</field>
 180             <field name="arch" type="xml">
 181                 <tree string="Turnover Per Month">
 182                         <field name="name" select="1"/>
 183                         <field name="turnover" select="2"/>
 184                 </tree>
 185             </field>
 186         </record>
 187
 188         <record id="view_turnover_month_graph" model="ir.ui.view">
 189              <field name="name">report.turnover.per.month.graph</field>
 190              <field name="model">report.turnover.per.month</field>
 191              <field name="type">graph</field>
 192              <field name="arch" type="xml">
 193                  <graph string="Turnover Per Month" type="bar">
 194                     <field name="name" />
 195                         <field name="turnover" />
 196                  </graph>
 197              </field>
 198         </record>
 199
 200                 <record model="ir.actions.act_window" id="action_turnover_month_tree">
 201             <field name="type">ir.actions.act_window</field>
 202             <field name="name">Turnover Per Month</field>
 203             <field name="res_model">report.turnover.per.month</field>
 204             <field name="view_type">form</field>
 205             <field name="view_mode">tree,graph</field>
 206             <field name="view_id" ref="view_turnover_month_tree"/>
 207         </record>
 208
 209         <!-- Turnover Per Product -->
 210
 211                 <record model="ir.ui.view" id="view_turnover_product_tree">
 212             <field name="name">report.turnover.per.product.tree</field>
 213             <field name="model">report.turnover.per.product</field>
 214             <field name="type">tree</field>
 215             <field name="arch" type="xml">
 216                 <tree string="Turnover Per Product">
 217                         <field name="product_id" select="1"/>
 218                         <field name="turnover" select="2"/>
 219                 </tree>
 220             </field>
 221         </record>
 222
 223         <record id="view_turnover_product_graph" model="ir.ui.view">
 224              <field name="name">report.turnover.per.product.graph</field>
 225              <field name="model">report.turnover.per.product</field>
 226              <field name="type">graph</field>
 227              <field name="arch" type="xml">
 228                  <graph string="Turnover Per Product" type="bar">
 229                     <field name="product_id" />
 230                         <field name="turnover" />
 231                  </graph>
 232              </field>
 233         </record>
 234
 235                 <record model="ir.actions.act_window" id="action_turnover_product_tree">
 236             <field name="type">ir.actions.act_window</field>
 237             <field name="name">Turnover Per Product</field>
 238             <field name="res_model">report.turnover.per.product</field>
 239             <field name="view_type">form</field>
 240             <field name="view_mode">tree,graph</field>
 241             <field name="view_id" ref="view_turnover_product_tree"/>
 242         </record>
 243
 244                 <!-- Created Sale orders for random activities dashboard -->
 245
 246                 <record id="board_view_created_sale_order" model="ir.ui.view">
 247             <field name="name">report.sale.order.created.tree</field>
 248             <field name="model">report.sale.order.created</field>
 249             <field name="type">tree</field>
 250             <field name="arch" type="xml">
 251                 <tree string="Created Sales orders">
 252                         <field name="create_date" select="1"/>
 253                     <field name="date_order"/>
 254                     <field name="name" string="Reference" select="1"/>
 255                     <field name="partner_id" select="2"/>
 256                     <field name="partner_shipping_id"/>
 257                     <field name="amount_untaxed"/>
 258                     <field name="state" select="1"/>
 259                 </tree>
 260             </field>
 261         </record>
 262
 263         <record id="action_view_created_sale_order_dashboard" model="ir.actions.act_window">
 264             <field name="name">Created Sale Orders</field>
 265             <field name="res_model">report.sale.order.created</field>
 266             <field name="view_type">form</field>
 267             <field name="view_mode">tree,form</field>
 268             <field name="view_id" ref="board_view_created_sale_order"/>
 269         </record>
 270     </data>
 271 </openerp>