addons/purchase/report/purchase_report_view.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3     <data>
   4         <record model="ir.ui.view" id="view_purchase_order_graph">
   5             <field name="name">product.month.graph</field>
   6             <field name="model">purchase.report</field>
   7             <field name="type">graph</field>
   8             <field name="arch" type="xml">
   9                 <graph string="Purchase Orders Statistics" type="bar">
  10                     <field name="product_id"/>
  11                     <field name="price_total" operator="+"/>
  12                 </graph>
  13             </field>
  14         </record>
  15
  16         <record id="view_purchase_order_tree" model="ir.ui.view">
  17             <field name="name">purchase.order.tree</field>
  18             <field name="model">purchase.report</field>
  19             <field name="type">tree</field>
  20             <field name="arch" type="xml">
  21                 <tree string="Purchase Orders Statistics">
  22                     <field name="date" invisible="1"/>
  23                     <field name="date_approve" invisible="1"/>
  24                     <field name="expected_date" invisible="1"/>
  25                     <field name="user_id" invisible="1"/>
  26                     <field name="partner_id" invisible="1"/>
  27                     <field name="product_id" invisible="1"/>
  28                     <field name="category_id" invisible="1"/>
  29                     <field name="product_uom" invisible="1"/>
  30                     <field name="day" invisible="1"/>
  31                     <field name="name" invisible="1"/>
  32                     <field name="month" invisible="1"/>
  33                     <field name="warehouse_id" invisible="1"/>
  34                     <field name="validator" invisible="1"/>
  35                     <field name="company_id" invisible="1"/>
  36                     <field name="state" invisible="1"/>
  37                     <field name="location_id" invisible="1"/>
  38                     <field name="nbr" sum="# of Lines"/>
  39                     <field name="quantity" sum="Quantity"/>
  40                     <field name="price_average" sum="Average Price"/>
  41                     <field name="price_total" sum="Total Price"/>
  42                     <field name="price_standard" sum="Products Value"/>
  43                     <field name="negociation" widget="progressbar"/>
  44                     <field name="delay" sum="Days to Validate"/>
  45                     <field name="delay_pass" sum="Days to Deliver"/>
  46                 </tree>
  47             </field>
  48         </record>
  49
  50         <record id="view_purchase_order_search" model="ir.ui.view">
  51         <field name="name">report.purchase.order.search</field>
  52         <field name="model">purchase.report</field>
  53         <field name="type">search</field>
  54         <field name="arch" type="xml">
  55             <search string="Purchase Orders">
  56             <group>
  57                 <filter icon="terp-go-year" string="Year"
  58                 name="year"
  59                 domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d')),('date','&gt;=',time.strftime('%%Y-01-01'))]"
  60                 help="Order in current year"/>
  61                 <separator orientation="vertical"/>
  62                 <filter icon="terp-go-month" string="Month"
  63                         name="month"
  64                         domain="[('date','&lt;=',(datetime.date.today()+relativedelta(day=31)).strftime('%%Y-%%m-%%d')),('date','&gt;=',(datetime.date.today()-relativedelta(day=1)).strftime('%%Y-%%m-%%d'))]"
  65                         help="Order in  current month"/>
  66                 <filter icon="terp-go-month"
  67                          string="Month-1"
  68                          domain="[('date','&lt;=', (datetime.date.today() - relativedelta(day=31, months=1)).strftime('%%Y-%%m-%%d')),('date','&gt;=',(datetime.date.today() - relativedelta(day=1,months=1)).strftime('%%Y-%%m-%%d'))]"
  69                          help="Order in last month"/>
  70                 <separator orientation="vertical"/>
  71                 <filter icon="terp-document-new"
  72                         string="Quotations"
  73                         name="quotes"
  74                         domain="[('state','=','draft')]"/>
  75                 <filter icon="terp-gtk-jump-to-rtl"
  76                         string="Orders"
  77                         name="orders"
  78                         domain="[('state','&lt;&gt;','draft'),('state','&lt;&gt;','cancel')]"/>
  79                 <separator orientation="vertical"/>
  80                 <field name="partner_id"/>
  81                 <field name="product_id"/>
  82                 </group>
  83                 <newline/>
  84                 <group expand="0" string="Extended Filters..." groups="base.group_extended">
  85                     <field name="user_id"/>
  86                     <field name="validator"/>
  87                     <separator orientation="vertical"/>
  88                     <field name="location_id"/>
  89                     <field name="warehouse_id" widget="selection"/>
  90                     <separator orientation="vertical"/>
  91                     <field name="company_id" groups="base.group_multi_company"/>
  92                     <newline/>
  93                     <field name="date"/>
  94                     <field name="date_approve"/>
  95                     <field name="expected_date"/>
  96                 </group>
  97                 <newline/>
  98                 <group expand="1" string="Group By...">
  99                     <filter string="Supplier" name="group_partner_id" icon="terp-personal" context="{'group_by':'partner_id'}"/>
 100                     <filter string="Responsible" name="Responsible" icon="terp-personal" context="{'group_by':'user_id'}"/>
 101                     <filter string="Validated by" icon="terp-personal" context="{'group_by':'validator'}"/>
 102                     <separator orientation="vertical"/>
 103                     <filter string="Product" name="group_product_id" icon="terp-accessories-archiver" context="{'group_by':'product_id'}"/>
 104                     <filter string="Category" name="group_category_id" icon="terp-stock_symbol-selection" context="{'group_by':'category_id'}"/>
 105                     <filter string="Reference UOM" name="group_product_uom" icon="terp-mrp" context="{'group_by':'product_uom'}"/>
 106                     <filter string="Warehouse" icon="terp-go-home" context="{'group_by':'warehouse_id'}" groups="base.group_extended"/>
 107                     <filter string="Destination" icon="terp-gtk-jump-to-ltr" context="{'group_by':'location_id'}"/>
 108                     <separator orientation="vertical"/>
 109                     <filter string="State" icon="terp-stock_effects-object-colorize" context="{'group_by':'state'}"/>
 110                     <separator orientation="vertical"/>
 111                     <filter string="Company" icon="terp-go-home" context="{'group_by':'company_id'}" groups="base.group_multi_company"/>
 112                     <separator orientation="vertical"/>
 113                     <filter string="Day" icon="terp-go-today" context="{'group_by':'day'}" help="Order of Day"/>
 114                     <filter string="Month" icon="terp-go-month" context="{'group_by':'month'}" help="Order of Month"/>
 115                     <filter string="Year" icon="terp-go-year" context="{'group_by':'name'}" help="Order of Year"/>
 116                 </group>
 117             </search>
 118         </field>
 119     </record>
 120
 121     <record model="ir.ui.view" id="view_purchase_order_qty_amount_graph">
 122             <field name="name">purchase.order.qty.amount.graph</field>
 123             <field name="model">purchase.report</field>
 124             <field name="type">graph</field>
 125             <field name="arch" type="xml">
 126                 <graph string="Total Qty and Amount by month" type="bar">
 127                     <field name="month"/>
 128                     <field name="quantity" operator="+"/>
 129                     <field name="price_total" operator="+"/>
 130                 </graph>
 131             </field>
 132         </record>
 133
 134     <record model="ir.ui.view" id="view_purchase_order_by_user_graph">
 135             <field name="name">purchase.order.by.user.graph</field>
 136             <field name="model">purchase.report</field>
 137             <field name="type">graph</field>
 138             <field name="arch" type="xml">
 139                 <graph string="Total Orders Lines by User per month" orientation="vertical" type="bar">
 140                     <field name="month" />
 141                     <field name="nbr" operator="+"/>
 142                     <field name="user_id" group="True" />
 143                 </graph>
 144             </field>
 145         </record>
 146
 147
 148     <record id="action_purchase_order_report_all" model="ir.actions.act_window">
 149         <field name="name">Purchase Analysis</field>
 150         <field name="res_model">purchase.report</field>
 151         <field name="view_type">form</field>
 152         <field name="view_mode">tree,graph</field>
 153         <field name="view_id" ref="view_purchase_order_tree"></field>
 154         <field name="context">{'search_default_year':1,'search_default_month':1,'search_default_group_partner_id':1,'search_default_group_product_id': 1, 'search_default_orders': 1, 'group_by_no_leaf':1,'group_by':[]}</field>
 155         <field name="help">Purchase Analysis allows you to easily check and analyse your company purchase history and performance. From this menu you can track your negotiation performance, the delivery performance of your suppliers, etc.</field>
 156     </record>
 157
 158     <record id="action_purchase_order_report_graph" model="ir.actions.act_window">
 159         <field name="name">Total Qty and Amount by month</field>
 160         <field name="res_model">purchase.report</field>
 161         <field name="view_type">form</field>
 162         <field name="view_mode">graph,tree</field>
 163         <field name="view_id" ref="view_purchase_order_qty_amount_graph"></field>
 164     </record>
 165
 166     <record id="action_purchase_order_by_user_all" model="ir.actions.act_window">
 167         <field name="name">Total Orders by User per month</field>
 168         <field name="res_model">purchase.report</field>
 169         <field name="view_type">form</field>
 170         <field name="view_mode">graph,tree</field>
 171         <field name="view_id" ref="view_purchase_order_by_user_graph"></field>
 172     </record>
 173
 174
 175     <menuitem id="base.next_id_73" name="Reporting" parent="base.menu_purchase_root" sequence="8"
 176         groups="purchase.group_purchase_manager"/>
 177     <menuitem action="action_purchase_order_report_all" id="menu_action_purchase_order_report_all" parent="base.next_id_73" sequence="3"/>
 178
 179     <record id="action_stock_move_report_po" model="ir.actions.act_window">
 180         <field name="name">Receptions Analysis</field>
 181         <field name="res_model">report.stock.move</field>
 182         <field name="view_type">form</field>
 183         <field name="view_mode">tree,graph</field>
 184         <field name="search_view_id" ref="stock.view_stock_search"/>
 185         <field name="context">{'full':'1','contact_display': 'partner','search_default_done':1, 'search_default_month':1, 'search_default_group_type':1, 'group_by': [], 'group_by_no_leaf':1,'search_default_year':1,}</field>
 186         <field name="help">Reception Analysis allows you to easily check and analyse your company order receptions and the performance of your supplier's deliveries.</field>
 187     </record>
 188     <menuitem action="action_stock_move_report_po" id="menu_action_stock_move_report_po" parent="base.next_id_73" sequence="8"/>
 189
 190     </data>
 191 </openerp>