Debian Codegraph @

addons/hr_timesheet/controllers/portal.py

raw
1 # Part of Odoo. See LICENSE file for full copyright and licensing details.
2
3 from dateutil.relativedelta import relativedelta
4 from operator import itemgetter
5
6 from odoo import fields, http, _
7 from odoo.fields import Domain
8 from odoo.http import request
9 from odoo.tools import date_utils, groupby as groupbyelem
10
11 from odoo.addons.portal.controllers.portal import CustomerPortal, pager as portal_pager
12 from odoo.addons.project.controllers.portal import ProjectCustomerPortal
13
14
15 class TimesheetCustomerPortal(CustomerPortal):
16
17 def _prepare_home_portal_values(self, counters):
18 values = super()._prepare_home_portal_values(counters)
19 if 'timesheet_count' in counters:
20 Timesheet = request.env['account.analytic.line']
21 domain = Timesheet._timesheet_get_portal_domain()
22 values['timesheet_count'] = Timesheet.sudo().search_count(domain)
23 return values
24
25 def _get_searchbar_inputs(self):
26 return {
27 'name': {'input': 'name', 'label': _('Search in Description'), 'sequence': 10},
28 'employee_id': {'input': 'employee_id', 'label': _('Search in Employee'), 'sequence': 20},
29 'project_id': {'input': 'project_id', 'label': _('Search in Project'), 'sequence': 30},
30 'task_id': {'input': 'task_id', 'label': _('Search in Task'), 'sequence': 40},
31 'parent_task_id': {'input': 'parent_task_id', 'label': _('Search in Parent Task'), 'sequence': 70},
32 }
33
34 def _task_get_searchbar_sortings(self, milestones_allowed, project=False):
35 return super()._task_get_searchbar_sortings(milestones_allowed, project) | {
36 'progress asc': {'label': _('Progress'), 'order': 'progress asc', 'sequence': 100},
37 }
38
39 def _get_searchbar_groupby(self):
40 return {
41 'none': {'label': _('None'), 'sequence': 10},
42 'date': {'label': _('Date'), 'sequence': 20},
43 'project_id': {'label': _('Project'), 'sequence': 30},
44 'parent_task_id': {'label': _('Parent Task'), 'sequence': 40},
45 'task_id': {'label': _('Task'), 'sequence': 50},
46 'employee_id': {'label': _('Employee'), 'sequence': 70},
47 }
48
49 def _get_search_domain(self, search_in, search):
50 if search_in in self._get_searchbar_inputs():
51 return Domain(search_in, 'ilike', search)
52 else:
53 return Domain.FALSE
54
55 def _get_searchbar_sortings(self):
56 return {
57 'date desc': {'label': _('Newest')},
58 'employee_id': {'label': _('Employee')},
59 'project_id': {'label': _('Project')},
60 'task_id': {'label': _('Task')},
61 'name': {'label': _('Description')},
62 }
63
64 def _project_get_page_view_values(self, project, access_token, page=1, date_begin=None, date_end=None, sortby=None, search=None, search_in='content', groupby=None, **kwargs):
65 values = super()._project_get_page_view_values(project, access_token, page, date_begin, date_end, sortby, search, search_in, groupby, **kwargs)
66 values['allow_timesheets'] = project.allow_timesheets
67 return values
68
69 @http.route(['/my/timesheets', '/my/timesheets/page/<int:page>'], type='http', auth="user", website=True)
70 def portal_my_timesheets(self, page=1, sortby=None, filterby=None, search=None, search_in='all', groupby='none', **kw):
71 Timesheet = request.env['account.analytic.line']
72 domain = Domain(Timesheet._timesheet_get_portal_domain())
73 Timesheet_sudo = Timesheet.sudo()
74
75 values = self._prepare_portal_layout_values()
76 items_per_page = 100
77
78 searchbar_sortings = self._get_searchbar_sortings()
79
80 searchbar_inputs = dict(sorted(self._get_searchbar_inputs().items(), key=lambda item: item[1]['sequence']))
81
82 searchbar_groupby = dict(sorted(self._get_searchbar_groupby().items(), key=lambda item: item[1]['sequence']))
83
84 today = fields.Date.today()
85 quarter_start, quarter_end = date_utils.get_quarter(today)
86 last_quarter_date = date_utils.subtract(quarter_start, weeks=1)
87 last_quarter_start, last_quarter_end = date_utils.get_quarter(last_quarter_date)
88 last_week = today + relativedelta(weeks=-1)
89 last_month = today + relativedelta(months=-1)
90 last_year = today + relativedelta(years=-1)
91
92 searchbar_filters = {
93 'all': {'label': _('All'), 'domain': []},
94 'last_year': {'label': _('Last Year'), 'domain': [('date', '>=', date_utils.start_of(last_year, 'year')), ('date', '<=', date_utils.end_of(last_year, 'year'))]},
95 'last_quarter': {'label': _('Last Quarter'), 'domain': [('date', '>=', last_quarter_start), ('date', '<=', last_quarter_end)]},
96 'last_month': {'label': _('Last Month'), 'domain': [('date', '>=', date_utils.start_of(last_month, 'month')), ('date', '<=', date_utils.end_of(last_month, 'month'))]},
97 'last_week': {'label': _('Last Week'), 'domain': [('date', '>=', date_utils.start_of(last_week, "week")), ('date', '<=', date_utils.end_of(last_week, 'week'))]},
98 'today': {'label': _('Today'), 'domain': [("date", "=", today)]},
99 'week': {'label': _('This Week'), 'domain': [('date', '>=', date_utils.start_of(today, "week")), ('date', '<=', date_utils.end_of(today, 'week'))]},
100 'month': {'label': _('This Month'), 'domain': [('date', '>=', date_utils.start_of(today, 'month')), ('date', '<=', date_utils.end_of(today, 'month'))]},
101 'quarter': {'label': _('This Quarter'), 'domain': [('date', '>=', quarter_start), ('date', '<=', quarter_end)]},
102 'year': {'label': _('This Year'), 'domain': [('date', '>=', date_utils.start_of(today, 'year')), ('date', '<=', date_utils.end_of(today, 'year'))]},
103 }
104 # default sort by value
105 if not sortby:
106 sortby = 'date desc'
107 # default filter by value
108 if not filterby:
109 filterby = 'all'
110 domain &= Domain(searchbar_filters[filterby]['domain'])
111
112 if search and search_in:
113 domain &= self._get_search_domain(search_in, search)
114
115 if parent_task_id := kw.get('parent_task_id'):
116 domain &= Domain('parent_task_id', '=', int(parent_task_id))
117
118 timesheet_count = Timesheet_sudo.search_count(domain)
119 # pager
120 pager = portal_pager(
121 url="/my/timesheets",
122 url_args={'sortby': sortby, 'search_in': search_in, 'search': search, 'filterby': filterby, 'groupby': groupby},
123 total=timesheet_count,
124 page=page,
125 step=items_per_page,
126 )
127
128 def get_timesheets():
129 field = None if groupby == 'none' else groupby
130 orderby = '%s, %s' % (field, sortby) if field else sortby
131 timesheets = Timesheet_sudo.search(domain, order=orderby, limit=items_per_page, offset=pager['offset'])
132 if field:
133 if groupby == 'date':
134 raw_timesheets_group = Timesheet_sudo._read_group(
135 domain, ['date:day'], ['unit_amount:sum', 'id:recordset'], order='date:day desc'
136 )
137 grouped_timesheets = [(records, unit_amount) for __, unit_amount, records in raw_timesheets_group]
138
139 else:
140 time_data = Timesheet_sudo._read_group(domain, [field], ['unit_amount:sum'])
141 mapped_time = {field.id: unit_amount for field, unit_amount in time_data}
142 grouped_timesheets = [(Timesheet_sudo.concat(*g), mapped_time[k.id]) for k, g in groupbyelem(timesheets, itemgetter(field))]
143 return timesheets, grouped_timesheets
144
145 grouped_timesheets = [(
146 timesheets,
147 Timesheet_sudo._read_group(domain, aggregates=['unit_amount:sum'])[0][0]
148 )] if timesheets else []
149 return timesheets, grouped_timesheets
150
151 timesheets, grouped_timesheets = get_timesheets()
152
153 values.update({
154 'timesheets': timesheets,
155 'grouped_timesheets': grouped_timesheets,
156 'page_name': 'timesheet',
157 'default_url': '/my/timesheets',
158 'pager': pager,
159 'searchbar_sortings': searchbar_sortings,
160 'search_in': search_in,
161 'search': search,
162 'sortby': sortby,
163 'groupby': groupby,
164 'searchbar_inputs': searchbar_inputs,
165 'searchbar_groupby': searchbar_groupby,
166 'searchbar_filters': searchbar_filters,
167 'filterby': filterby,
168 'is_uom_day': request.env['account.analytic.line']._is_timesheet_encode_uom_day(),
169 })
170 return request.render("hr_timesheet.portal_my_timesheets", values)
171
172
173 class TimesheetProjectCustomerPortal(ProjectCustomerPortal):
174
175 def _show_task_report(self, task_sudo, report_type, download):
176 domain = request.env['account.analytic.line']._timesheet_get_portal_domain()
177 task_domain = Domain(domain) & Domain('task_id', '=', task_sudo.id)
178 timesheets = request.env['account.analytic.line'].sudo().search(task_domain)
179 return self._show_report(model=timesheets,
180 report_type=report_type, report_ref='hr_timesheet.timesheet_report_task_timesheets', download=download)
181
182 def _prepare_tasks_values(self, page, date_begin, date_end, sortby, search, search_in, groupby, url="/my/tasks", domain=None, su=False, project=False):
183 values = super()._prepare_tasks_values(page, date_begin, date_end, sortby, search, search_in, groupby, url, domain, su, project)
184 values.update(
185 is_uom_day=request.env['account.analytic.line']._is_timesheet_encode_uom_day(),
186 )
187
188 return values