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)