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