addons/sale/report/sale_report_view.xml

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