addons/point_of_sale/report/pos_order_report_view.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <openerp>
   3     <data>
   4         <record id="view_report_pos_order_tree" model="ir.ui.view">
   5                 <field name="name">report.pos.order.tree</field>
   6                 <field name="model">report.pos.order</field>
   7                 <field name="type">tree</field>
   8                 <field name="arch" type="xml">
   9                     <tree string="Point of Sale Analysis">
  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="partner_id" invisible="1"/>
  16                         <field name="product_id" invisible="1"/>
  17                         <field name="shop_id" invisible="1"/>
  18                         <!--<field name="journal_id" invisible="1"/>-->
  19                         <field name="date_validation" invisible="1"/>
  20                         <field name="date_payment" invisible="1"/>
  21                     <field name="company_id" invisible="1" groups="base.group_multi_company"/>
  22                         <field name="nbr" sum="# of Lines"/>
  23                         <field name="product_qty" sum="# of Qty"/>
  24                         <field name="average_price" sum="Average Price"/>
  25                         <field name="total_discount" sum="Total Discount"/>
  26                         <field name="price_total" sum="Total Price"/>
  27                         <field name="delay_validation"/>
  28                         <field name="delay_payment"/>
  29                         <!--<field name="state" invisible="1"/>-->
  30                     </tree>
  31                 </field>
  32         </record>
  33
  34         <record id="view_report_pos_order_search" model="ir.ui.view">
  35                 <field name="name">report.pos.order.search</field>
  36                 <field name="model">report.pos.order</field>
  37                 <field name="type">search</field>
  38                 <field name="arch" type="xml">
  39                     <search string="Point of Sale Analysis">
  40                         <group>
  41                             <filter icon="terp-go-year" string="Year"
  42                                 domain="[('year','=',time.strftime('%%Y'))]"
  43                                 help="POS ordered created during current year"/>
  44                             <filter icon="terp-go-month" string="Month"
  45                                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'))]"
  46                                 help="POS ordered created during current month"/>
  47                             <filter icon="terp-go-month"
  48                                  string="Month -1"
  49                                  separator="1"
  50                                  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'))]"
  51                                  help="POS ordered created last month"/>
  52                             <separator orientation="vertical"/>
  53                             <filter icon="terp-go-today"
  54                              string="Today"
  55                              name="today"
  56                              separator="1"
  57                              domain="[('date','&lt;=', time.strftime('%%Y-%%m-%%d'))]"
  58                              help="POS ordered created by today"/>
  59                             <separator orientation="vertical"/>
  60                         <filter icon="terp-dolar"
  61                             string="Invoiced"
  62                             domain="[('state','=',('invoiced'))]"/>
  63                             <filter icon="terp-dolar"
  64                                 string="Paid"
  65                                 domain="[('state','=',('paid'))]"/>
  66                     <separator orientation="vertical"/>
  67                     <field name="partner_id"/>
  68                     <field name="user_id" widget="selection">
  69                         <filter icon="terp-personal"
  70                             string="My Sales"
  71                             help="My Sales"
  72                             domain="[('user_id','=',uid)]"/>
  73                     </field>
  74                         </group>
  75                         <newline/>
  76                     <group expand="0" string="Extended Filters..." groups="base.group_extended">
  77                         <field name="date_validation"/>
  78                         <field name="date_payment"/>
  79                     </group>
  80                         <newline/>
  81                         <group expand="1" string="Group By..." colspan="10" col="12">
  82                             <filter string="Salesman" icon="terp-personal" name="User" context="{'group_by':'user_id'}"/>
  83                             <filter string="Customer" icon="terp-personal" context="{'group_by':'partner_id'}"/>
  84                             <separator orientation="vertical"/>
  85                             <filter string="Product" icon="terp-accessories-archiver" context="{'group_by':'product_id'}"/>
  86                         <separator orientation="vertical"/>
  87                         <filter string="Day" icon="terp-go-today" context="{'group_by':'day'}" help="Day of order date"/>
  88                         <filter string="Month" icon="terp-go-month" context="{'group_by':'month'}" help="Month of order date"/>
  89                         <filter string="Year" icon="terp-go-year" context="{'group_by':'year'}" help="Year of order date"/>
  90                         </group>
  91                     </search>
  92                 </field>
  93         </record>
  94
  95         <record id="action_report_pos_order_all" model="ir.actions.act_window">
  96                 <field name="name">Point of Sale Analysis</field>
  97                 <field name="res_model">report.pos.order</field>
  98                 <field name="view_type">form</field>
  99                 <field name="view_mode">tree,graph</field>
 100                 <field name="search_view_id" ref="view_report_pos_order_search"/>
 101                 <field name="context">{'search_default_today':1,'search_default_User':1,'group_by_no_leaf':1,'group_by':[]}</field>
 102             </record>
 103
 104             <menuitem action="action_report_pos_order_all" id="menu_report_pos_order_all" parent="menu_point_rep" sequence="3"/>
 105         </data>
 106 </openerp>