def portal_my_requet(self, page=1, date_begin=None, date_end=None,
sortby=None, **kw):
values = self._prepare_portal_layout_values()
ReturnRequest = request.env['rma.request']
domain = [
('state', 'in', ['draft', 'confirmed', 'rma_created',
'replacement_created'])
]
request_count = ReturnRequest.search_count(domain)
pager = portal_pager(
url="/my/request",
url_args={},
total=request_count,
page=page,
step=self._items_per_page
)
# content according to pager and archive selected
requests = ReturnRequest.sudo().search(domain,
limit=self._items_per_page,
offset=pager['offset'])
request.session['my_requests_history'] = requests.ids[:100]
values.update({
'date': date_begin,
'requests': requests.sudo(),
'page_name': 'return_request',
'pager': pager,
'archive_groups': '',
'default_url': '/my/request',
'searchbar_sortings': '',
'sortby': sortby,
})
return request.render("website_rma.portal_my_requests", values)
def portal_my_invoices(self, page=1, date_begin=None, date_end=None, sortby=None, filterby=None, **kw):
values = self._prepare_portal_layout_values()
AccountInvoice = request.env['account.move']
domain = self._get_invoices_domain()
searchbar_sortings = {
'date': {'label': _('Date'), 'order': 'invoice_date desc'},
'duedate': {'label': _('Due Date'), 'order': 'invoice_date_due desc'},
'name': {'label': _('Reference'), 'order': 'name desc'},
'state': {'label': _('Status'), 'order': 'state'},
}
# default sort by order
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
searchbar_filters = {
'all': {'label': _('All'), 'domain': []},
'invoices': {'label': _('Invoices'), 'domain': [('move_type', '=', ('out_invoice', 'out_refund'))]},
'bills': {'label': _('Bills'), 'domain': [('move_type', '=', ('in_invoice', 'in_refund'))]},
}
# default filter by value
if not filterby:
filterby = 'all'
domain += searchbar_filters[filterby]['domain']
if date_begin and date_end:
domain += [('create_date', '>', date_begin), ('create_date', '<=', date_end)]
# count for pager
invoice_count = AccountInvoice.search_count(domain)
# pager
pager = portal_pager(
url="/my/invoices",
url_args={'date_begin': date_begin, 'date_end': date_end, 'sortby': sortby},
total=invoice_count,
page=page,
step=self._items_per_page
)
# content according to pager and archive selected
invoices = AccountInvoice.search(domain, order=order, limit=self._items_per_page, offset=pager['offset'])
request.session['my_invoices_history'] = invoices.ids[:100]
values.update({
'date': date_begin,
'invoices': invoices,
'page_name': 'invoice',
'pager': pager,
'default_url': '/my/invoices',
'searchbar_sortings': searchbar_sortings,
'sortby': sortby,
'searchbar_filters': OrderedDict(sorted(searchbar_filters.items())),
'filterby':filterby,
})
return request.render("account.portal_my_invoices", values)
def portal_my_invoices(self, page=1, date_begin=None, date_end=None, sortby=None, **kw):
values = self._prepare_portal_layout_values()
partner = request.env.user.partner_id
AccountInvoice = request.env['account.invoice']
domain = [
('type', 'in', ['out_invoice', 'out_refund']),
('message_partner_ids', 'child_of', [partner.commercial_partner_id.id]),
('state', 'in', ['open', 'paid', 'cancelled'])
]
searchbar_sortings = {
'date': {'label': _('Invoice Date'), 'order': 'date_invoice desc'},
'duedate': {'label': _('Due Date'), 'order': 'date_due desc'},
'name': {'label': _('Reference'), 'order': 'name desc'},
'state': {'label': _('Status'), 'order': 'state'},
}
# default sort by order
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
archive_groups = self._get_archive_groups('account.invoice', domain)
if date_begin and date_end:
domain += [('create_date', '>', date_begin), ('create_date', '<=', date_end)]
# count for pager
invoice_count = AccountInvoice.search_count(domain)
# pager
pager = portal_pager(
url="/my/invoices",
url_args={'date_begin': date_begin, 'date_end': date_end, 'sortby': sortby},
total=invoice_count,
page=page,
step=self._items_per_page
)
# content according to pager and archive selected
invoices = AccountInvoice.search(domain, order=order, limit=self._items_per_page, offset=pager['offset'])
values.update({
'date': date_begin,
'invoices': invoices,
'page_name': 'invoice',
'pager': pager,
'archive_groups': archive_groups,
'default_url': '/my/invoices',
'searchbar_sortings': searchbar_sortings,
'sortby': sortby,
})
return request.render("account.portal_my_invoices", values)
def pages_management(self, page=1, sortby='url', search='', **kw):
# only website_designer should access the page Management
if not request.env.user.has_group('website.group_website_designer'):
raise werkzeug.exceptions.NotFound()
Page = request.env['website.page']
searchbar_sortings = {
'url': {
'label': _('Sort by Url'),
'order': 'url'
},
'name': {
'label': _('Sort by Name'),
'order': 'name'
},
}
# default sortby order
sort_order = searchbar_sortings.get(
sortby, 'url')['order'] + ', website_id desc, id'
domain = request.website.website_domain()
if search:
domain += [
'|', ('name', 'ilike', search), ('url', 'ilike', search)
]
pages = Page.search(domain, order=sort_order)
if sortby != 'url' or not request.env.user.has_group(
'website.group_multi_website'):
pages = pages.filtered(pages._is_most_specific_page)
pages_count = len(pages)
step = 50
pager = portal_pager(url="/website/pages",
url_args={'sortby': sortby},
total=pages_count,
page=page,
step=step)
pages = pages[(page - 1) * step:page * step]
values = {
'pager': pager,
'pages': pages,
'search': search,
'sortby': sortby,
'searchbar_sortings': searchbar_sortings,
}
return request.render("website.list_website_pages", values)
def pages_management(self, page=1, sortby='name', search='', **kw):
# only website_designer should access the page Management
if not request.env.user.has_group('website.group_website_designer'):
raise werkzeug.exceptions.NotFound()
Page = request.env['website.page']
searchbar_sortings = {
'url': {
'label': _('Sort by Url'),
'order': 'url'
},
'name': {
'label': _('Sort by Name'),
'order': 'name'
},
}
# default sortby order
sort_order = searchbar_sortings.get(sortby, 'name')['order']
domain = [
'|', ('website_ids', 'in', request.website.id),
('website_ids', '=', False)
]
if search:
domain += [
'|', ('name', 'ilike', search), ('url', 'ilike', search)
]
pages_count = Page.search_count(domain)
pager = portal_pager(url="/website/pages",
url_args={'sortby': sortby},
total=pages_count,
page=page,
step=50)
pages = Page.search(domain,
order=sort_order,
limit=50,
offset=pager['offset'])
values = {
'pager': pager,
'pages': pages,
'search': search,
'sortby': sortby,
'searchbar_sortings': searchbar_sortings,
}
return request.render("website.edit_website_pages", values)
def portal_my_ticket(self, page=1, ticket_id=None, **kw):
domain = [('user_id', '=', request.session.uid)]
ticket_count = request.env['helpdesk.ticket'].search_count(domain)
pager = portal_pager(url="/my/tickets",
url_args={},
total=ticket_count,
page=page,
step=self._items_per_page)
tickets = request.env['helpdesk.ticket'].search(
domain, limit=self._items_per_page, offset=pager['offset'])
request.session['my_tickets_history'] = tickets.ids[:100]
vals = {
'ticket': tickets,
'user': request.env.user,
'pager': pager,
}
return request.render("website_helpdesk.my_tickets", vals)
def portal_my_projects(self, page=1, date_begin=None, date_end=None, sortby=None, **kw):
values = self._prepare_portal_layout_values()
Project = request.env['project.project']
domain = []
searchbar_sortings = {
'date': {'label': _('Newest'), 'order': 'create_date desc'},
'name': {'label': _('Name'), 'order': 'name'},
}
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
if date_begin and date_end:
domain += [('create_date', '>', date_begin), ('create_date', '<=', date_end)]
# projects count
project_count = Project.search_count(domain)
# pager
pager = portal_pager(
url="/my/projects",
url_args={'date_begin': date_begin, 'date_end': date_end, 'sortby': sortby},
total=project_count,
page=page,
step=self._items_per_page
)
# content according to pager and archive selected
projects = Project.search(domain, order=order, limit=self._items_per_page, offset=pager['offset'])
request.session['my_projects_history'] = projects.ids[:100]
values.update({
'date': date_begin,
'date_end': date_end,
'projects': projects,
'page_name': 'project',
'default_url': '/my/projects',
'pager': pager,
'searchbar_sortings': searchbar_sortings,
'sortby': sortby
})
return request.render("project.portal_my_projects", values)
def portal_my_purchase_orders(self,
page=1,
date_begin=None,
date_end=None,
sortby=None,
filterby=None,
**kw):
values = self._prepare_portal_layout_values()
PurchaseOrder = request.env['purchase.order']
domain = []
if date_begin and date_end:
domain += [('create_date', '>', date_begin),
('create_date', '<=', date_end)]
searchbar_sortings = {
'date': {
'label': _('Newest'),
'order': 'create_date desc, id desc'
},
'name': {
'label': _('Name'),
'order': 'name asc, id asc'
},
'amount_total': {
'label': _('Total'),
'order': 'amount_total desc, id desc'
},
}
# default sort by value
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
searchbar_filters = {
'all': {
'label': _('All'),
'domain': [('state', 'in', ['purchase', 'done', 'cancel'])]
},
'purchase': {
'label': _('Purchase Order'),
'domain': [('state', '=', 'purchase')]
},
'cancel': {
'label': _('Cancelled'),
'domain': [('state', '=', 'cancel')]
},
'done': {
'label': _('Locked'),
'domain': [('state', '=', 'done')]
},
}
# default filter by value
if not filterby:
filterby = 'all'
domain += searchbar_filters[filterby]['domain']
# count for pager
purchase_count = PurchaseOrder.search_count(domain)
# make pager
pager = portal_pager(url="/my/purchase",
url_args={
'date_begin': date_begin,
'date_end': date_end,
'sortby': sortby,
'filterby': filterby
},
total=purchase_count,
page=page,
step=self._items_per_page)
# search the purchase orders to display, according to the pager data
orders = PurchaseOrder.search(domain,
order=order,
limit=self._items_per_page,
offset=pager['offset'])
request.session['my_purchases_history'] = orders.ids[:100]
values.update({
'date':
date_begin,
'orders':
orders,
'page_name':
'purchase',
'pager':
pager,
'searchbar_sortings':
searchbar_sortings,
'sortby':
sortby,
'searchbar_filters':
OrderedDict(sorted(searchbar_filters.items())),
'filterby':
filterby,
'default_url':
'/my/purchase',
})
return request.render("purchase.portal_my_purchase_orders", values)
def portal_my_quotes(self,
page=1,
date_begin=None,
date_end=None,
sortby=None,
**kw):
values = self._prepare_portal_layout_values()
partner = request.env.user.partner_id
SaleOrder = request.env['sale.order']
domain = [('message_partner_ids', 'child_of',
[partner.commercial_partner_id.id]),
('state', 'in', ['sent', 'cancel'])]
searchbar_sortings = {
'date': {
'label': _('Order Date'),
'order': 'date_order desc'
},
'name': {
'label': _('Reference'),
'order': 'name'
},
'stage': {
'label': _('Stage'),
'order': 'state'
},
}
# default sortby order
if not sortby:
sortby = 'date'
sort_order = searchbar_sortings[sortby]['order']
archive_groups = self._get_archive_groups('sale.order', domain)
if date_begin and date_end:
domain += [('create_date', '>', date_begin),
('create_date', '<=', date_end)]
# count for pager
quotation_count = SaleOrder.search_count(domain)
# make pager
pager = portal_pager(url="/my/quotes",
url_args={
'date_begin': date_begin,
'date_end': date_end,
'sortby': sortby
},
total=quotation_count,
page=page,
step=self._items_per_page)
# search the count to display, according to the pager data
quotations = SaleOrder.search(domain,
order=sort_order,
limit=self._items_per_page,
offset=pager['offset'])
request.session['my_quotes_history'] = quotations.ids[:100]
values.update({
'date': date_begin,
'quotations': quotations.sudo(),
'page_name': 'quote',
'pager': pager,
'archive_groups': archive_groups,
'default_url': '/my/quotes',
'searchbar_sortings': searchbar_sortings,
'sortby': sortby,
})
return request.render("sale.portal_my_quotations", values)
def portal_my_tasks(self,
page=1,
date_begin=None,
date_end=None,
sortby=None,
filterby=None,
search=None,
search_in='content',
**kw):
groupby = kw.get('groupby', 'project') #TODO master fix this
values = self._prepare_portal_layout_values()
searchbar_sortings = {
'date': {
'label': _('Newest'),
'order': 'create_date desc'
},
'name': {
'label': _('Title'),
'order': 'name'
},
'stage': {
'label': _('Stage'),
'order': 'stage_id'
},
'update': {
'label': _('Last Stage Update'),
'order': 'date_last_stage_update desc'
},
}
searchbar_filters = {
'all': {
'label': _('All'),
'domain': []
},
}
searchbar_inputs = {
'content': {
'input': 'content',
'label': _('Search <span class="nolabel"> (in Content)</span>')
},
'message': {
'input': 'message',
'label': _('Search in Messages')
},
'customer': {
'input': 'customer',
'label': _('Search in Customer')
},
'stage': {
'input': 'stage',
'label': _('Search in Stages')
},
'all': {
'input': 'all',
'label': _('Search in All')
},
}
searchbar_groupby = {
'none': {
'input': 'none',
'label': _('None')
},
'project': {
'input': 'project',
'label': _('Project')
},
}
# extends filterby criteria with project (criteria name is the project id)
# Note: portal users can't view projects they don't follow
partner = request.env.user.partner_id
domain_projects = [
'&', ('privacy_visibility', '=', 'portal'), '|',
('message_partner_ids', 'child_of',
[partner.commercial_partner_id.id]),
('task_ids.message_partner_ids', 'child_of',
[partner.commercial_partner_id.id])
]
projects = request.env['project.project'].sudo().search(
domain_projects)
domain = [('project_id', 'in', projects.ids)]
for proj in projects:
searchbar_filters.update({
str(proj.id): {
'label': proj.name,
'domain': [('project_id', '=', proj.id)]
}
})
# default sort by value
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
# default filter by value
if not filterby:
filterby = 'all'
domain += searchbar_filters[filterby]['domain']
# archive groups - Default Group By 'create_date'
archive_groups = self._get_archive_groups('project.task', domain)
if date_begin and date_end:
domain += [('create_date', '>', date_begin),
('create_date', '<=', date_end)]
# search
if search and search_in:
search_domain = []
if search_in in ('content', 'all'):
search_domain = OR([
search_domain,
[
'|', ('name', 'ilike', search),
('description', 'ilike', search)
]
])
if search_in in ('customer', 'all'):
search_domain = OR(
[search_domain, [('partner_id', 'ilike', search)]])
if search_in in ('message', 'all'):
search_domain = OR(
[search_domain, [('message_ids.body', 'ilike', search)]])
if search_in in ('stage', 'all'):
search_domain = OR(
[search_domain, [('stage_id', 'ilike', search)]])
domain += search_domain
# task count
task_count = request.env['project.task'].search_count(domain)
# pager
pager = portal_pager(url="/my/tasks",
url_args={
'date_begin': date_begin,
'date_end': date_end,
'sortby': sortby,
'filterby': filterby,
'search_in': search_in,
'search': search
},
total=task_count,
page=page,
step=self._items_per_page)
# content according to pager and archive selected
if groupby == 'project':
order = "project_id, %s" % order # force sort on project first to group by project in view
tasks = request.env['project.task'].search(domain,
order=order,
limit=self._items_per_page,
offset=(page - 1) *
self._items_per_page)
request.session['my_tasks_history'] = tasks.ids[:100]
if groupby == 'project':
grouped_tasks = [
request.env['project.task'].concat(*g)
for k, g in groupbyelem(tasks, itemgetter('project_id'))
]
else:
grouped_tasks = [tasks]
values.update({
'date':
date_begin,
'date_end':
date_end,
'projects':
projects,
'tasks':
tasks,
'grouped_tasks':
grouped_tasks,
'page_name':
'task',
'archive_groups':
archive_groups,
'default_url':
'/my/tasks',
'pager':
pager,
'searchbar_sortings':
searchbar_sortings,
'searchbar_groupby':
searchbar_groupby,
'searchbar_inputs':
searchbar_inputs,
'search_in':
search_in,
'sortby':
sortby,
'groupby':
groupby,
'searchbar_filters':
OrderedDict(sorted(searchbar_filters.items())),
'filterby':
filterby,
})
return request.render("project.portal_my_tasks", values)
def portal_my_ticket(self,
page=1,
ticket_id=None,
sortby=None,
filterby=None,
groupby=None,
search=None,
search_in='all',
**kw):
values = self._prepare_portal_layout_values()
domain = []
searchbar_sortings = {
'id': {
'label': _('Newest'),
'order': 'id desc'
},
'issue_name': {
'label': _('Subject'),
'order': 'issue_name asc'
},
'ticket_seq': {
'label': _('Sequence'),
'order': 'ticket_seq asc'
},
}
searchbar_filters = {
'all': {
'label': _('All'),
'domain': []
},
'draft': {
'label': _('Draft'),
'domain': [('stage_id.stage_type', '=', 'draft')]
},
'done': {
'label': _('Done'),
'domain': [('stage_id.stage_type', '=', 'done')]
},
}
searchbar_inputs = {
'all': {
'input': 'all',
'label': _('Search in All')
},
'ticket_seq': {
'input': 'ticket_seq',
'label': _('Search in Sequence No')
},
'issue_name': {
'input': 'issue_name',
'label': _('Search in Name')
},
}
searchbar_groupby = {
'none': {
'input': 'none',
'label': _('None')
},
'stage_id': {
'input': 'stage_id',
'label': _('Stage')
},
}
if not sortby:
sortby = 'id'
if not filterby:
filterby = 'all'
order = searchbar_sortings[sortby]['order']
if not groupby:
groupby = 'none'
if groupby == 'team_id':
order = "team_id, %s" % order
elif groupby == 'stage_id':
order = "stage_id, %s" % order
user = request.env.user
domain = [
'|', ('user_id', '=', user.id),
('partner_id', '=', user.partner_id.id)
]
if search and search_in:
search_domain = []
if search_in in ('all', 'ticket_seq'):
search_domain = expression.OR(
[search_domain, [('ticket_seq', 'ilike', search)]])
if search_in in ('all', 'issue_name'):
search_domain = expression.OR(
[search_domain, [('issue_name', 'ilike', search)]])
domain += search_domain
attrib_list = request.httprequest.args.getlist('attrib')
attrib_values = [map(int, v.split("-")) for v in attrib_list if v]
attrib_set = set([v[1] for v in attrib_values])
domain += self.get_search_domain_ticket(search, attrib_values)
domain += searchbar_filters[filterby]['domain']
tickets = request.env['helpdesk.ticket'].sudo().search(domain,
order=order)
ticket_count = tickets.sudo().search_count(domain)
pager = portal_pager(url="/my/tickets",
url_args={
'sortby': sortby,
'filterby': filterby,
'groupby': groupby,
'search_in': search_in,
'search': search
},
total=ticket_count,
page=page,
step=self._items_per_page)
request.session['my_tickets_history'] = tickets.ids[:100]
values.update({
'tickets':
tickets,
'user':
request.env.user,
'page_name':
'ticket',
'default_url':
'/my/tickets',
'pager':
pager,
'searchbar_sortings':
searchbar_sortings,
'search_in':
search_in,
'search':
search,
'sortby':
sortby,
'groupby':
groupby,
'searchbar_inputs':
searchbar_inputs,
'searchbar_groupby':
searchbar_groupby,
'searchbar_filters':
OrderedDict(sorted(searchbar_filters.items())),
'filterby':
filterby,
})
return request.render("website_helpdesk.my_tickets", values)
def portal_my_timesheets(self, page=1, sortby=None, filterby=None, search=None, search_in='all', groupby='none', **kw):
Timesheet_sudo = request.env['account.analytic.line'].sudo()
values = self._prepare_portal_layout_values()
domain = request.env['account.analytic.line']._timesheet_get_portal_domain()
_items_per_page = 100
searchbar_sortings = {
'date': {'label': _('Newest'), 'order': 'date desc'},
'name': {'label': _('Description'), 'order': 'name'},
}
searchbar_inputs = self._get_searchbar_inputs()
searchbar_groupby = self._get_searchbar_groupby()
today = fields.Date.today()
quarter_start, quarter_end = date_utils.get_quarter(today)
last_week = today + relativedelta(weeks=-1)
last_month = today + relativedelta(months=-1)
last_year = today + relativedelta(years=-1)
searchbar_filters = {
'all': {'label': _('All'), 'domain': []},
'today': {'label': _('Today'), 'domain': [("date", "=", today)]},
'week': {'label': _('This week'), 'domain': [('date', '>=', date_utils.start_of(today, "week")), ('date', '<=', date_utils.end_of(today, 'week'))]},
'month': {'label': _('This month'), 'domain': [('date', '>=', date_utils.start_of(today, 'month')), ('date', '<=', date_utils.end_of(today, 'month'))]},
'year': {'label': _('This year'), 'domain': [('date', '>=', date_utils.start_of(today, 'year')), ('date', '<=', date_utils.end_of(today, 'year'))]},
'quarter': {'label': _('This Quarter'), 'domain': [('date', '>=', quarter_start), ('date', '<=', quarter_end)]},
'last_week': {'label': _('Last week'), 'domain': [('date', '>=', date_utils.start_of(last_week, "week")), ('date', '<=', date_utils.end_of(last_week, 'week'))]},
'last_month': {'label': _('Last month'), 'domain': [('date', '>=', date_utils.start_of(last_month, 'month')), ('date', '<=', date_utils.end_of(last_month, 'month'))]},
'last_year': {'label': _('Last year'), 'domain': [('date', '>=', date_utils.start_of(last_year, 'year')), ('date', '<=', date_utils.end_of(last_year, 'year'))]},
}
# default sort by value
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
# default filter by value
if not filterby:
filterby = 'all'
domain = AND([domain, searchbar_filters[filterby]['domain']])
if search and search_in:
domain += self._get_search_domain(search_in, search)
timesheet_count = Timesheet_sudo.search_count(domain)
# pager
pager = portal_pager(
url="/my/timesheets",
url_args={'sortby': sortby, 'search_in': search_in, 'search': search, 'filterby': filterby, 'groupby': groupby},
total=timesheet_count,
page=page,
step=_items_per_page
)
def get_timesheets():
groupby_mapping = self._get_groupby_mapping()
field = groupby_mapping.get(groupby, None)
orderby = '%s, %s' % (field, order) if field else order
timesheets = Timesheet_sudo.search(domain, order=orderby, limit=_items_per_page, offset=pager['offset'])
if field:
if groupby == 'date':
time_data = Timesheet_sudo.read_group(domain, ['date', 'unit_amount:sum'], ['date:day'])
mapped_time = dict([(datetime.strptime(m['date:day'], '%d %b %Y').date(), m['unit_amount']) for m in time_data])
grouped_timesheets = [(Timesheet_sudo.concat(*g), mapped_time[k]) for k, g in groupbyelem(timesheets, itemgetter('date'))]
else:
time_data = time_data = Timesheet_sudo.read_group(domain, [field, 'unit_amount:sum'], [field])
mapped_time = dict([(m[field][0] if m[field] else False, m['unit_amount']) for m in time_data])
grouped_timesheets = [(Timesheet_sudo.concat(*g), mapped_time[k.id]) for k, g in groupbyelem(timesheets, itemgetter(field))]
return timesheets, grouped_timesheets
grouped_timesheets = [(
timesheets,
sum(Timesheet_sudo.search(domain).mapped('unit_amount'))
)] if timesheets else []
return timesheets, grouped_timesheets
timesheets, grouped_timesheets = get_timesheets()
values.update({
'timesheets': timesheets,
'grouped_timesheets': grouped_timesheets,
'page_name': 'timesheet',
'default_url': '/my/timesheets',
'pager': pager,
'searchbar_sortings': searchbar_sortings,
'search_in': search_in,
'search': search,
'sortby': sortby,
'groupby': groupby,
'searchbar_inputs': searchbar_inputs,
'searchbar_groupby': searchbar_groupby,
'searchbar_filters': OrderedDict(sorted(searchbar_filters.items())),
'filterby': filterby,
'is_uom_day': request.env['account.analytic.line']._is_timesheet_encode_uom_day(),
})
return request.render("hr_timesheet.portal_my_timesheets", values)
def my_tickets(self,
page=1,
start_date=None,
end_date=None,
sort=None,
search=None,
in_search='content',
**kw):
result = self._prepare_portal_layout_values()
domain = self._get_tickets_domain(request.env.user.partner_id)
sortings = {
'name': {
'label': _('Subject'),
'order': 'name'
},
'date': {
'label': _('Newest'),
'order': 'create_date desc'
},
'stage': {
'label': _('Stage'),
'order': 'stage_id'
},
}
if not sort:
sort = 'date'
order = sortings[sort]['order']
archive_groups = self._get_archive_groups('supportdesk.ticket', domain)
if start_date and end_date:
domain += [('create_date', '>', start_date),
('create_date', '<=', end_date)]
if search and in_search:
in_search_filter = []
if in_search in ('customer', 'all'):
in_search_filter = OR(
[in_search_filter, [('partner_id', 'ilike', search)]])
if in_search in ('content', 'all'):
in_search_filter = OR([
in_search_filter,
[
'|', ('name', 'ilike', search),
('description', 'ilike', search)
]
])
if in_search in ('stage', 'all'):
in_search_filter = OR(
[in_search_filter, [('stage_id', 'ilike', search)]])
if in_search in ('message', 'all'):
in_search_filter = OR([
in_search_filter, [('message_ids.body', 'ilike', search)]
])
domain += in_search_filter
support_tickets_count = request.env['supportdesk.ticket'].search_count(
domain)
pager = portal_pager(url="/my/support_tickets",
url_args={
'start_date': start_date,
'end_date': end_date,
'sortby': sort
},
total=support_tickets_count,
page=page,
step=self._items_per_page)
support_tickets = request.env['supportdesk.ticket'].sudo().search(
domain,
order=order,
limit=self._items_per_page,
offset=pager['offset'])
request.session['my_tickets_history'] = support_tickets.ids[:50]
result.update({
'page_name': 'ticket',
'pager': pager,
'date': start_date,
'tickets': support_tickets,
'default_url': '/my/support_tickets',
'sortby': sort,
'search_in': in_search,
'search': search,
'searchbar_sortings': sortings,
'archive_groups': archive_groups,
})
return request.render("support_desk.portal_support_ticket", result)
def portal_my_tasks(self,
page=1,
date_begin=None,
date_end=None,
sortby=None,
filterby=None,
search=None,
search_in='content',
**kw):
values = self._prepare_portal_layout_values()
domain = [('project_id.privacy_visibility', '=', 'portal')]
searchbar_sortings = {
'date': {
'label': _('Newest'),
'order': 'create_date desc'
},
'name': {
'label': _('Title'),
'order': 'name'
},
'stage': {
'label': _('Stage'),
'order': 'stage_id'
},
'update': {
'label': _('Last Stage Update'),
'order': 'date_last_stage_update desc'
},
}
searchbar_filters = {
'all': {
'label': _('All'),
'domain': []
},
}
searchbar_inputs = {
'content': {
'input': 'content',
'label': _('Search <span class="nolabel"> (in Content)</span>')
},
'message': {
'input': 'message',
'label': _('Search in Messages')
},
'customer': {
'input': 'customer',
'label': _('Search in Customer')
},
'stage': {
'input': 'stage',
'label': _('Search in Stages')
},
'all': {
'input': 'all',
'label': _('Search in All')
},
}
# extends filterby criteria with project (criteria name is the project id)
projects = request.env['project.project'].search([
('privacy_visibility', '=', 'portal')
])
for proj in projects:
searchbar_filters.update({
str(proj.id): {
'label': proj.name,
'domain': [('project_id', '=', proj.id)]
}
})
# default sort by value
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
# default filter by value
if not filterby:
filterby = 'all'
domain += searchbar_filters[filterby]['domain']
# archive groups - Default Group By 'create_date'
archive_groups = self._get_archive_groups('project.task', domain)
if date_begin and date_end:
domain += [('create_date', '>', date_begin),
('create_date', '<=', date_end)]
# search
if search and search_in:
search_domain = []
if search_in in ('content', 'all'):
search_domain = OR([
search_domain,
[
'|', ('name', 'ilike', search),
('description', 'ilike', search)
]
])
if search_in in ('customer', 'all'):
search_domain = OR(
[search_domain, [('partner_id', 'ilike', search)]])
if search_in in ('message', 'all'):
search_domain = OR(
[search_domain, [('message_ids.body', 'ilike', search)]])
if search_in in ('stage', 'all'):
search_domain = OR(
[search_domain, [('stage_id', 'ilike', search)]])
domain += search_domain
# task count
task_count = request.env['project.task'].search_count(domain)
# pager
pager = portal_pager(url="/my/tasks",
url_args={
'date_begin': date_begin,
'date_end': date_end,
'sortby': sortby,
'filterby': filterby
},
total=task_count,
page=page,
step=self._items_per_page)
# content according to pager and archive selected
tasks = request.env['project.task'].search(domain,
order=order,
limit=self._items_per_page,
offset=pager['offset'])
request.session['my_tasks_history'] = tasks.ids[:100]
values.update({
'date':
date_begin,
'date_end':
date_end,
'projects':
projects,
'tasks':
tasks,
'page_name':
'task',
'archive_groups':
archive_groups,
'default_url':
'/my/tasks',
'pager':
pager,
'searchbar_sortings':
searchbar_sortings,
'searchbar_inputs':
searchbar_inputs,
'search_in':
search_in,
'sortby':
sortby,
'searchbar_filters':
OrderedDict(sorted(searchbar_filters.items())),
'filterby':
filterby,
})
return request.render("project.portal_my_tasks", values)
def portal_my_tasks(self, page=1, date_begin=None, date_end=None, sortby=None, filterby=None, search=None, search_in='content', groupby=None, **kw):
values = self._prepare_portal_layout_values()
searchbar_sortings = {
'date': {'label': _('Newest'), 'order': 'create_date desc'},
'name': {'label': _('Title'), 'order': 'name'},
'stage': {'label': _('Stage'), 'order': 'stage_id, project_id'},
'project': {'label': _('Project'), 'order': 'project_id, stage_id'},
'update': {'label': _('Last Stage Update'), 'order': 'date_last_stage_update desc'},
}
searchbar_filters = {
'all': {'label': _('All'), 'domain': []},
}
searchbar_inputs = {
'content': {'input': 'content', 'label': _('Search <span class="nolabel"> (in Content)</span>')},
'message': {'input': 'message', 'label': _('Search in Messages')},
'customer': {'input': 'customer', 'label': _('Search in Customer')},
'stage': {'input': 'stage', 'label': _('Search in Stages')},
'project': {'input': 'project', 'label': _('Search in Project')},
'all': {'input': 'all', 'label': _('Search in All')},
}
searchbar_groupby = {
'none': {'input': 'none', 'label': _('None')},
'project': {'input': 'project', 'label': _('Project')},
'stage': {'input': 'stage', 'label': _('Stage')},
}
# extends filterby criteria with project the customer has access to
projects = request.env['project.project'].search([])
for project in projects:
searchbar_filters.update({
str(project.id): {'label': project.name, 'domain': [('project_id', '=', project.id)]}
})
# extends filterby criteria with project (criteria name is the project id)
# Note: portal users can't view projects they don't follow
project_groups = request.env['project.task'].read_group([('project_id', 'not in', projects.ids)],
['project_id'], ['project_id'])
for group in project_groups:
proj_id = group['project_id'][0] if group['project_id'] else False
proj_name = group['project_id'][1] if group['project_id'] else _('Others')
searchbar_filters.update({
str(proj_id): {'label': proj_name, 'domain': [('project_id', '=', proj_id)]}
})
# default sort by value
if not sortby:
sortby = 'date'
order = searchbar_sortings[sortby]['order']
# default filter by value
if not filterby:
filterby = 'all'
domain = searchbar_filters.get(filterby, searchbar_filters.get('all'))['domain']
# default group by value
if not groupby:
groupby = 'project'
if date_begin and date_end:
domain += [('create_date', '>', date_begin), ('create_date', '<=', date_end)]
# search
if search and search_in:
search_domain = []
if search_in in ('content', 'all'):
search_domain = OR([search_domain, ['|', ('name', 'ilike', search), ('description', 'ilike', search)]])
if search_in in ('customer', 'all'):
search_domain = OR([search_domain, [('partner_id', 'ilike', search)]])
if search_in in ('message', 'all'):
search_domain = OR([search_domain, [('message_ids.body', 'ilike', search)]])
if search_in in ('stage', 'all'):
search_domain = OR([search_domain, [('stage_id', 'ilike', search)]])
if search_in in ('project', 'all'):
search_domain = OR([search_domain, [('project_id', 'ilike', search)]])
domain += search_domain
# task count
task_count = request.env['project.task'].search_count(domain)
# pager
pager = portal_pager(
url="/my/tasks",
url_args={'date_begin': date_begin, 'date_end': date_end, 'sortby': sortby, 'filterby': filterby, 'groupby': groupby, 'search_in': search_in, 'search': search},
total=task_count,
page=page,
step=self._items_per_page
)
# content according to pager and archive selected
if groupby == 'project':
order = "project_id, %s" % order # force sort on project first to group by project in view
elif groupby == 'stage':
order = "stage_id, %s" % order # force sort on stage first to group by stage in view
tasks = request.env['project.task'].search(domain, order=order, limit=self._items_per_page, offset=pager['offset'])
request.session['my_tasks_history'] = tasks.ids[:100]
if groupby == 'project':
grouped_tasks = [request.env['project.task'].concat(*g) for k, g in groupbyelem(tasks, itemgetter('project_id'))]
elif groupby == 'stage':
grouped_tasks = [request.env['project.task'].concat(*g) for k, g in groupbyelem(tasks, itemgetter('stage_id'))]
else:
grouped_tasks = [tasks]
values.update({
'date': date_begin,
'date_end': date_end,
'grouped_tasks': grouped_tasks,
'page_name': 'task',
'default_url': '/my/tasks',
'pager': pager,
'searchbar_sortings': searchbar_sortings,
'searchbar_groupby': searchbar_groupby,
'searchbar_inputs': searchbar_inputs,
'search_in': search_in,
'search': search,
'sortby': sortby,
'groupby': groupby,
'searchbar_filters': OrderedDict(sorted(searchbar_filters.items())),
'filterby': filterby,
})
return request.render("project.portal_my_tasks", values)
def portal_my_orders(self,
page=1,
date_begin=None,
date_end=None,
sortby=None,
**kw):
values = self._prepare_portal_layout_values()
partner = request.env.user.partner_id
SaleOrder = request.env['sale.order']
domain = self._prepare_orders_domain(partner)
searchbar_sortings = {
'date': {
'label': _('Order Date'),
'order': 'date_order desc'
},
'name': {
'label': _('Reference'),
'order': 'name'
},
'stage': {
'label': _('Stage'),
'order': 'state'
},
}
# default sortby order
if not sortby:
sortby = 'date'
sort_order = searchbar_sortings[sortby]['order']
if date_begin and date_end:
domain += [('create_date', '>', date_begin),
('create_date', '<=', date_end)]
# count for pager
order_count = SaleOrder.search_count(domain)
# pager
pager = portal_pager(url="/my/orders",
url_args={
'date_begin': date_begin,
'date_end': date_end,
'sortby': sortby
},
total=order_count,
page=page,
step=self._items_per_page)
# content according to pager
orders = SaleOrder.search(domain,
order=sort_order,
limit=self._items_per_page,
offset=pager['offset'])
request.session['my_orders_history'] = orders.ids[:100]
values.update({
'date': date_begin,
'orders': orders.sudo(),
'page_name': 'order',
'pager': pager,
'default_url': '/my/orders',
'searchbar_sortings': searchbar_sortings,
'sortby': sortby,
})
return request.render("sale.portal_my_orders", values)
