[IMP]:hr_timesheet_sheet:Improved SQL report.(Timesheet).
[odoo/odoo.git] / addons / hr_timesheet_sheet / report / timesheet_report_view.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <openerp>
3     <data>
4         <record id="view_timesheet_report_graph" model="ir.ui.view">
5             <field name="name">timesheet.report.graph</field>
6             <field name="model">timesheet.report</field>
7             <field name="type">graph</field>
8             <field name="arch" type="xml">
9                 <graph string="Timesheet" type="bar">
10                     <field name="user_id" />
11                         <field name="quantity" operator = "+"/>
12                         <field name="state" group = "True"/>
13                 </graph>
14             </field>
15         </record>
16         <record id="view_timesheet_report_tree" model="ir.ui.view">
17             <field name="name">timesheet.report.tree</field>
18             <field name="model">timesheet.report</field>
19             <field name="type">tree</field>
20             <field name="arch" type="xml">
21                 <tree string="Timesheet">
22                     <field name="date_current" invisible="1"/>
23                     <field name="name" invisible="1"/>
24                     <field name="user_id" invisible="1"/>
25                     <field name="date_from" invisible="1"/>
26                     <field name="date_to" invisible="1"/>
27                                         <field name="quantity" sum="#Quantity"/>
28                                         <field name="cost" sum="#Cost"/>
29                     <field name="state" invisible="1"/>
30                     <field name="department_id" invisible="1"/>
31                     <field name="company_id" invisible="1"/>
32                     <field name="year" invisible="1"/>
33                     <field name="day" invisible="1"/>
34                     <field name="month" invisible="1"/>
35                 </tree>
36             </field>
37         </record>
38         <record id="view_timesheet_report_search" model="ir.ui.view">
39             <field name="name">timesheet.report.search</field>
40             <field name="model">timesheet.report</field>
41             <field name="type">search</field>
42             <field name="arch" type="xml">
43                 <search string="Timesheet">
44                     <group col="10" colspan="4">
45                         <filter icon="terp-hr" string="This Year"
46                                     domain="[('date_current','&lt;=', time.strftime('%%Y-%%m-%%d')),('date_current','&gt;',(datetime.date.today()-datetime.timedelta(days=365)).strftime('%%Y-%%m-%%d'))]"
47                                     help="Timesheet in this year"/>
48                             <filter icon="terp-hr" string="This Month"
49                                         name="month"
50                                         domain="[('date_current','&lt;=', time.strftime('%%Y-%%m-%%d')), ('date_current','&gt;',(datetime.date.today()-datetime.timedelta(days=30)).strftime('%%Y-%%m-%%d'))]"
51                                         help="Timesheet in this month"/>
52                                 <filter icon="gtk-media-rewind"
53                                     string="    7 Days    "
54                                     separator="1"
55                                     domain="[('date_current','&lt;=', time.strftime('%%Y-%%m-%%d')), ('date_current','&gt;',(datetime.date.today()-datetime.timedelta(days=7)).strftime('%%Y-%%m-%%d'))]"
56                                     help="Timesheet during last 7 days"/>
57                             <separator orientation="vertical"/>
58                             <filter icon="terp-hr"
59                                         string="Draft"
60                                         domain="[('state','=','draft')]"/>
61                             <filter icon="terp-hr"
62                                         string="Confirmed"
63                                         domain="[('state','=','confirm')]"/>
64                             <filter icon="terp-hr"
65                                         string="Done"
66                                         domain="[('state','=','done')]"/>
67                             <separator orientation="vertical"/>
68                                                 <field name="user_id" widget="selection">
69                                 <filter icon="terp-hr"
70                                                 string="My timesheet"
71                                                 help = "My timesheet "
72                                                 domain="[('user_id','=',uid)]" />
73                                 <filter icon="terp-hr"
74                                                 string="Non Assigned timesheets to users"
75                                                 help="Non Assigned timesheets to users"
76                                                 domain="[('user_id','=',False)]"/>
77                             </field>
78                             <field name="company_id" widget="selection" groups="base.group_multi_company"/>
79                     </group>
80                     <newline/>
81                 <group expand="0" string="Extended options..." colspan="10" col="12">
82                         <filter icon="terp-hr"
83                                 string="New"
84                                 domain="[('state','=','new')]"/>
85                     <separator orientation="vertical"/>
86                     <field name="department_id" widget="selection"/>
87                     <separator orientation="vertical"/>
88                     <field name="date_from"/>
89                     <field name="date_to"/>
90                 </group>
91                     <newline/>
92                     <group expand="1" string="Group By..." colspan="10" col="12">
93                             <filter string="User" name="User" icon="terp-hr" context="{'group_by':'user_id'}"/>
94                             <filter string="Company" icon="terp-hr" context="{'group_by':'company_id'}" groups="base.group_multi_company"/>
95                             <separator orientation="vertical"/>
96                             <filter string="Department" icon="terp-hr" context="{'group_by':'department_id'}"/>
97                             <filter string="State" icon="terp-hr" context="{'group_by':'state'}"/>
98                             <separator orientation="vertical"/>
99                             <filter string="Day" icon="terp-hr" context="{'group_by':'day'}"/>
100                             <filter string="Month" icon="terp-hr" context="{'group_by':'date_current'}"/>
101                             <filter string="Year" icon="terp-hr" context="{'group_by':'year'}"/>
102                     </group>
103                 </search>
104             </field>
105         </record>
106
107         <record id="action_timesheet_report_stat_all" model="ir.actions.act_window">
108             <field name="name">Timesheet</field>
109             <field name="res_model">timesheet.report</field>
110             <field name="view_type">form</field>
111             <field name="view_mode">tree,graph</field>
112             <field name="context">{'search_default_month':1,'search_default_User':1,'group_by_no_leaf':1,'group_by':[]}</field>
113             <field name="search_view_id" ref="view_timesheet_report_search"/>
114         </record>
115         <menuitem action="action_timesheet_report_stat_all" id="menu_timesheet_report_all" parent="hr.menu_hr_reporting"/>
116     </data>
117 </openerp>