[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="name" />
11                         <field name="total_att" operator = "+"/>
12                         <field name="total_ts" operator = "+"/>
13                         <field name="user_id" group = "True"/>
14                 </graph>
15             </field>
16         </record>
17         <record id="view_timesheet_report_tree" model="ir.ui.view">
18             <field name="name">timesheet.report.tree</field>
19             <field name="model">timesheet.report</field>
20             <field name="type">tree</field>
21             <field name="arch" type="xml">
22                 <tree string="Timesheet">
23                     <field name="date_current"/>
24                     <field name="name"/>
25                     <field name="user_id"/>
26                     <field name="date_from"/>
27                     <field name="date_to"/>
28                                         <field name="total_att"/>
29                                         <field name="total_diff"/>
30                     <field name="total_ts"/>
31                     <field name="state"/>
32                     <field name="department_id" invisible="1"/>
33                     <field name="company_id" invisible="1"/>
34                     <field name="name" invisible="1"/>
35                     <field name="month" invisible="1"/>
36                 </tree>
37             </field>
38         </record>
39         <record id="view_timesheet_report_search" model="ir.ui.view">
40             <field name="name">timesheet.report.search</field>
41             <field name="model">timesheet.report</field>
42             <field name="type">search</field>
43             <field name="arch" type="xml">
44                 <search string="Timesheet">
45                     <group col="10" colspan="4">
46                         <filter icon="terp-hr" string="This Year" domain="[('year','=',time.strftime('%%Y'))]" help="Timesheet by user in this year"/>
47                         <filter icon="terp-hr" string="This Month" domain="[('month','=',time.strftime('%%m'))]" help="Timesheet by user in this month"/>
48                         <separator orientation="vertical"/>
49                         <field name="user_id" widget="selection">
50                                 <filter icon="terp-hr"
51                                 string="My Timesheet"
52                                 domain="[('user_id','=',uid)]"/></field>
53                         <field name="name"/>
54                         <field name="department_id"/>
55                     </group>
56                     <newline/>
57                 <group expand="1" string="Extended options..." colspan="10" col="12">
58                         <filter icon="terp-hr"
59                                 string="New"
60                                 domain="[('state','=','new')]"/>
61                     <filter icon="terp-hr"
62                                 string="Draft"
63                                 domain="[('state','=','draft')]"/>
64                     <filter icon="terp-hr"
65                                 string="Confirmed"
66                                 domain="[('state','=','confirm')]"/>
67                     <filter icon="terp-hr"
68                                 string="Done"
69                                 domain="[('state','=','done')]"/>
70                     <newline/>
71                     <field name="date_from"/>
72                     <field name="date_to"/>
73                 </group>
74                     <newline/>
75                     <group expand="1" string="Group By..." colspan="10" col="12">
76                             <filter string="User" name="User" icon="terp-hr" context="{'group_by':'user_id'}"/>
77                             <filter string="Company" icon="terp-hr" context="{'group_by':'company_id'}"/>
78                             <filter string="Department" icon="terp-hr" context="{'group_by':'department_id'}"/>
79                             <separator orientation="vertical"/>
80                             <filter string="State" icon="terp-hr" context="{'group_by':'state'}"/>
81                             <separator orientation="vertical"/>
82                             <filter string="Month" icon="terp-hr" context="{'group_by':'date_current'}"/>
83                             <filter string="Year" icon="terp-hr" context="{'group_by':'year'}"/>
84                     </group>
85                 </search>
86             </field>
87         </record>
88
89         <record id="action_timesheet_report_stat_all" model="ir.actions.act_window">
90             <field name="name">Timesheet</field>
91             <field name="res_model">timesheet.report</field>
92             <field name="view_type">form</field>
93             <field name="view_mode">tree,graph</field>
94             <field name="context">{'search_default_User': 1}</field>
95             <field name="search_view_id" ref="view_timesheet_report_search"/>
96         </record>
97         <menuitem action="action_timesheet_report_stat_all" id="menu_timesheet_report_all" parent="hr.menu_hr_reporting"/>
98     </data>
99 </openerp>