addons/sale/report/sale_report_view.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3 <data>
   4
   5     <record id="view_order_product_tree" model="ir.ui.view">
   6         <field name="name">sale.report.tree</field>
   7         <field name="model">sale.report</field>
   8         <field name="type">tree</field>
   9         <field name="arch" type="xml">
  10             <tree string="Sales Analysis">
  11                 <field name="date" invisible="1"/>
  12                 <field name="user_id" invisible="1"/>
  13                 <field name="year" invisible="1"/>
  14                 <field name="day" invisible="1"/>
  15                 <field name="month" invisible="1"/>
  16                 <field name="shop_id" invisible="1"/>
  17                 <field name="company_id" invisible="1" groups="base.group_multi_company"/>
  18                 <field name="partner_id" invisible="1"/>
  19                 <field name="product_id" invisible="1"/>
  20                 <field name="categ_id" invisible="1"/>
  21                 <field name="nbr" sum="# of Lines"/>
  22                 <field name="product_uom_qty" sum="# of Qty"/>
  23                 <field name="shipped_qty_1" sum="Shipped Qty"/>
  24                 <field name="uom_name" invisible="not context.get('set_visible',False)"/>
  25                 <field name="price_average" sum="Average Price"/>
  26                 <field name="price_total" sum="Total Price"/>
  27                 <field name="delay" sum="Commitment Delay"/>
  28                 <field name="state" invisible="1"/>
  29                 <field name="analytic_account_id" invisible="1" groups="base.group_extended"/>
  30             </tree>
  31         </field>
  32     </record>
  33
  34     <record id="view_order_product_graph" model="ir.ui.view">
  35          <field name="name">sale.report.graph</field>
  36          <field name="model">sale.report</field>
  37          <field name="type">graph</field>
  38          <field name="arch" type="xml">
  39              <graph string="Sales Analysis" type="bar">
  40                  <field name="product_id"/>
  41                  <field name="price_total"/>
  42                  <field name="state" group="True"/>
  43              </graph>
  44          </field>
  45     </record>
  46
  47     <record id="view_order_product_search" model="ir.ui.view">
  48         <field name="name">sale.report.search</field>
  49         <field name="model">sale.report</field>
  50         <field name="type">search</field>
  51         <field name="arch" type="xml">
  52             <search string="Sales Analysis">
  53                 <group>
  54                     <filter icon="terp-go-year" string="  Year  "
  55                         domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')),('date','&gt;=',time.strftime('%%Y-01-01'))]"
  56                         help="Sales order created in current year"/>
  57                     <filter icon="terp-go-month" string="   Month   "
  58                         name="month"
  59                         domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')),('date','&gt;=',time.strftime('%%Y-%%m-01'))]"
  60                         help="Sales order created in current month"/>
  61                     <filter icon="terp-go-month"
  62                          string="    Month-1    "
  63                          separator="1"
  64                          domain="[('date','&lt;=', (datetime.date (int(time.strftime('%%Y')), datetime.date.today().month, 1) - datetime.timedelta (days = 1)).strftime('%%Y-%%m-%%d')),('date','&gt;',(datetime.date (int(time.strftime('%%Y')), datetime.date.today().month-1, 1)).strftime('%%Y-%%m-%%d'))]"
  65                          help="Sales order created in last month"/>
  66                     <separator orientation="vertical"/>
  67                     <filter icon="terp-document-new"
  68                         string="Quotations"
  69                         domain="[('state','=','draft')]"/>
  70                     <filter icon="terp-check"
  71                         string="Sales"
  72                         domain="[('state','not in',('draft','done','cancel'))]"/>
  73                     <separator orientation="vertical"/>
  74                     <filter icon="terp-sale"
  75                         string="Picked"
  76                         domain="[('shipped','=',True)]"/>
  77                     <separator orientation="vertical"/>
  78                     <field name="partner_id"/>
  79                     <field name="product_id"/>
  80                     <field name="user_id">
  81                         <filter icon="terp-personal"
  82                             string="My Sales"
  83                             help="My Sales"
  84                             domain="[('user_id','=',uid)]"/>
  85                     </field>
  86                 </group>
  87                 <newline/>
  88                 <group expand="0" string="Extended Filters..." groups="base.group_extended">
  89                     <field name="shop_id" widget="selection"/>
  90                     <field name="categ_id" widget="selection"/>
  91                     <field name="company_id" groups="base.group_multi_company" widget="selection"/>
  92                     <newline/>
  93                     <field name="date"/>
  94                     <field name="date_confirm"/>
  95                 </group>
  96                 <newline/>
  97                 <group expand="1" string="Group By..." colspan="10" col="12">
  98                     <filter string="Salesman" icon="terp-personal" name="User" context="{'group_by':'user_id'}"/>
  99                     <filter string="Partner" icon="terp-partner" context="{'group_by':'partner_id'}"/>
 100                     <separator orientation="vertical"/>
 101                     <filter string="Product" icon="terp-accessories-archiver" context="{'group_by':'product_id','set_visible':True}"/>
 102                     <filter string="Default UoM" icon="terp-mrp" context="{'group_by':'uom_name'}"/>
 103                     <filter string="Category of Product" icon="terp-stock_symbol-selection" context="{'group_by':'categ_id'}"/>
 104                     <separator orientation="vertical"/>
 105                     <filter string="Analytic Account" icon="terp-folder-green" context="{'group_by':'analytic_account_id'}"/>
 106                     <separator orientation="vertical"/>
 107                     <filter string="State" icon="terp-stock_effects-object-colorize" context="{'group_by':'state'}"/>
 108                     <separator orientation="vertical"/>
 109                     <filter string="Shop" icon="terp-go-home" context="{'group_by':'shop_id'}"/>
 110                     <filter string="Company" icon="terp-go-home" groups="base.group_multi_company" context="{'group_by':'company_id'}"/>
 111                     <separator orientation="vertical"/>
 112                    <filter string="Day" icon="terp-go-today" context="{'group_by':'day'}" help="Ordered date of the sales order"/>
 113                    <filter string="Month" icon="terp-go-month" context="{'group_by':'month'}" help="Ordered month of the sales order"/>
 114                    <filter string="Year" icon="terp-go-year" context="{'group_by':'year'}" help="Ordered Year of the sales order"/>
 115                 </group>
 116             </search>
 117         </field>
 118     </record>
 119
 120     <record id="action_order_report_all" model="ir.actions.act_window">
 121         <field name="name">Sales Analysis</field>
 122         <field name="res_model">sale.report</field>
 123         <field name="view_type">form</field>
 124         <field name="view_mode">tree,graph</field>
 125         <field name="search_view_id" ref="view_order_product_search"/>
 126         <field name="view_id" ref="view_order_product_tree"/>
 127         <field name="context">{'search_default_month':1,'search_default_User':1,'group_by_no_leaf':1,'group_by':[]}</field>
 128         <field name="help">With Sales Analysis consult your sales total amount suits to different group criteria (salesman, partner, product, etc.)</field>
 129     </record>
 130
 131     <menuitem id="base.next_id_64" name="Reporting" parent="base.menu_base_partner" sequence="11"/>
 132     <menuitem action="action_order_report_all" id="menu_report_product_all" parent="base.next_id_64" sequence="1"/>
 133
 134     <!--This views used in board_sale module -->
 135     <record id="view_sales_by_partner_tree" model="ir.ui.view">
 136         <field name="name">sales.by.partner.tree</field>
 137         <field name="model">sale.report</field>
 138         <field name="type">tree</field>
 139         <field name="arch" type="xml">
 140             <tree string="Sales By Partner">
 141                 <field name="partner_id"/>
 142                 <field name="price_total"/>
 143             </tree>
 144         </field>
 145     </record>
 146
 147     <record id="view_sales_by_partner_graph" model="ir.ui.view">
 148          <field name="name">sales.by.partner.graph</field>
 149          <field name="model">sale.report</field>
 150          <field name="type">graph</field>
 151          <field name="arch" type="xml">
 152              <graph string="Sales By Partner" type="bar">
 153                  <field name="partner_id" />
 154                  <field name="price_total" operator="+"/>
 155              </graph>
 156          </field>
 157     </record>
 158
 159    <record id="action_sales_by_partner" model="ir.actions.act_window">
 160         <field name="name">Sales By Partner</field>
 161         <field name="res_model">sale.report</field>
 162         <field name="view_type">form</field>
 163         <field name="view_mode">graph,tree</field>
 164         <field name="domain">[('state','in',('manual','progress')),('date','&lt;=', time.strftime('%Y-%m-%d')),('date','&gt;',(datetime.date.today()-datetime.timedelta(days=90)).strftime('%Y-%m-%d'))]</field>
 165         <field name="view_id" ref="view_sales_by_partner_graph"/>
 166     </record>
 167     <record id="open_view_sales_by_partner_graph" model="ir.actions.act_window.view">
 168             <field eval="1" name="sequence"/>
 169             <field name="view_mode">graph</field>
 170             <field name="view_id" ref="view_sales_by_partner_graph"/>
 171             <field name="act_window_id" ref="action_sales_by_partner"/>
 172    </record>
 173    <record id="open_view_sales_by_partner_tree" model="ir.actions.act_window.view">
 174             <field eval="2" name="sequence"/>
 175             <field name="view_mode">tree</field>
 176             <field name="view_id" ref="view_sales_by_partner_tree"/>
 177             <field name="act_window_id" ref="action_sales_by_partner"/>
 178    </record>
 179
 180     <record id="view_sales_by_salesman_tree" model="ir.ui.view">
 181         <field name="name">sales.by.salesman.tree</field>
 182         <field name="model">sale.report</field>
 183         <field name="type">tree</field>
 184         <field name="arch" type="xml">
 185             <tree string="Sales By Salesman">
 186                 <field name="user_id"/>
 187                 <field name="price_total"/>
 188             </tree>
 189         </field>
 190     </record>
 191
 192     <record id="view_sales_by_salesman_graph" model="ir.ui.view">
 193          <field name="name">sales.by.salesman.graph</field>
 194          <field name="model">sale.report</field>
 195          <field name="type">graph</field>
 196          <field name="arch" type="xml">
 197              <graph string="Sales By Salesman" type="bar">
 198                  <field name="user_id" />
 199                  <field name="price_total" operator="+"/>
 200              </graph>
 201          </field>
 202     </record>
 203
 204    <record id="action_sales_by_salesman" model="ir.actions.act_window">
 205         <field name="name">Sales By Salesman</field>
 206         <field name="res_model">sale.report</field>
 207         <field name="view_type">form</field>
 208         <field name="view_mode">graph,tree</field>
 209         <field name="domain">[('state','in',('manual','progress','done')),('date','&lt;=', time.strftime('%Y-%m-%d')),('date','&gt;',(datetime.date.today()-datetime.timedelta(days=90)).strftime('%Y-%m-%d'))]</field>
 210         <field name="view_id" ref="view_sales_by_salesman_graph"/>
 211     </record>
 212    <record id="open_view_sales_by_salesman_graph" model="ir.actions.act_window.view">
 213             <field eval="7" name="sequence"/>
 214             <field name="view_mode">graph</field>
 215             <field name="view_id" ref="view_sales_by_salesman_graph"/>
 216             <field name="act_window_id" ref="action_sales_by_salesman"/>
 217    </record>
 218     <record id="open_view_sales_by_salesman_tree" model="ir.actions.act_window.view">
 219             <field eval="9" name="sequence"/>
 220             <field name="view_mode">tree</field>
 221             <field name="view_id" ref="view_sales_by_salesman_tree"/>
 222             <field name="act_window_id" ref="action_sales_by_salesman"/>
 223    </record>
 224     <record id="view_sales_product_total_price_tree" model="ir.ui.view">
 225         <field name="name">sold.product.total.price.tree</field>
 226         <field name="model">sale.report</field>
 227         <field name="type">tree</field>
 228         <field name="arch" type="xml">
 229             <tree string="Sales by Products">
 230                 <field name="product_id"/>
 231                 <field name="price_total"/>
 232             </tree>
 233         </field>
 234     </record>
 235
 236     <record id="view_sales_product_total_price_graph" model="ir.ui.view">
 237          <field name="name">sold.product.total.price.graph</field>
 238          <field name="model">sale.report</field>
 239          <field name="type">graph</field>
 240          <field name="arch" type="xml">
 241              <graph string="Sales by Products" type="bar">
 242                  <field name="product_id" />
 243                  <field name="price_total" operator="+"/>
 244              </graph>
 245          </field>
 246     </record>
 247
 248    <record id="action_sales_product_total_price" model="ir.actions.act_window">
 249         <field name="name">Sales by Products</field>
 250         <field name="res_model">sale.report</field>
 251         <field name="view_type">form</field>
 252         <field name="view_mode">graph,tree</field>
 253         <field name="domain">[('state','in',('manual','progress','done')),('date','&gt;',(datetime.date.today()-datetime.timedelta(days=90)).strftime('%Y-%m-%d'))]</field>
 254         <field name="view_id" ref="view_sales_product_total_price_graph"/>
 255     </record>
 256     <record id="open_view_sales_product_total_price_graph" model="ir.actions.act_window.view">
 257             <field eval="3" name="sequence"/>
 258             <field name="view_mode">graph</field>
 259             <field name="view_id" ref="view_sales_product_total_price_graph"/>
 260             <field name="act_window_id" ref="action_sales_product_total_price"/>
 261     </record>
 262     <record id="open_view_sales_product_total_price_tree" model="ir.actions.act_window.view">
 263             <field eval="4" name="sequence"/>
 264             <field name="view_mode">tree</field>
 265             <field name="view_id" ref="view_sales_product_total_price_tree"/>
 266             <field name="act_window_id" ref="action_sales_product_total_price"/>
 267    </record>
 268
 269     <record id="view_sales_by_month_tree" model="ir.ui.view">
 270         <field name="name">view.sales.by.month.tree</field>
 271         <field name="model">sale.report</field>
 272         <field name="type">tree</field>
 273         <field name="arch" type="xml">
 274             <tree string="Sales By Month">
 275                 <field name="month" />
 276                 <field name="product_id" />
 277                 <field name="price_total" />
 278             </tree>
 279         </field>
 280     </record>
 281     <record id="action_view_sales_by_month" model="ir.actions.act_window">
 282         <field name="name">Sales By Month</field>
 283         <field name="res_model">sale.report</field>
 284         <field name="view_type">form</field>
 285         <field name="view_mode">tree,graph</field>
 286         <field name="domain">[('state','in',('manual','progress','done')),('year','=', time.strftime('%Y'))]</field>
 287         <field name="context">{'group_by_no_leaf':1,'group_by':['month','product_id']}</field>
 288         <field name="view_id" ref="view_sales_by_month_tree"/>
 289     </record>
 290
 291      <record id="view_top_quotations_tree" model="ir.ui.view">
 292             <field name="name">sale.top.quotations.tree</field>
 293             <field name="model">sale.order</field>
 294             <field name="type">tree</field>
 295             <field name="arch" type="xml">
 296                 <tree string="Top Quotations">
 297                     <field name="date_order"/>
 298                     <field name="name"/>
 299                     <field name="partner_id"/>
 300                     <field name="user_id" />
 301                     <field name="amount_untaxed" />
 302                     <field name="amount_total"/>
 303                 </tree>
 304             </field>
 305         </record>
 306
 307     <record id="action_quotation_for_sale" model="ir.actions.act_window">
 308         <field name="name">Top Quotations</field>
 309         <field name="res_model">sale.order</field>
 310         <field name="view_type">form</field>
 311         <field name="view_mode">tree,form</field>
 312         <field name="domain">[('state','=','draft')]</field>
 313           <field name="view_id" ref="view_top_quotations_tree"/>
 314     </record>
 315
 316 </data>
 317 </openerp>