| 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 |