diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2022-05-10 21:51:50 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2022-05-10 21:51:50 +0700 |
| commit | 3751379f1e9a4c215fb6eb898b4ccc67659b9ace (patch) | |
| tree | a44932296ef4a9b71d5f010906253d8c53727726 /addons/point_of_sale/models/pos_order.py | |
| parent | 0a15094050bfde69a06d6eff798e9a8ddf2b8c21 (diff) | |
initial commit 2
Diffstat (limited to 'addons/point_of_sale/models/pos_order.py')
| -rw-r--r-- | addons/point_of_sale/models/pos_order.py | 1021 |
1 files changed, 1021 insertions, 0 deletions
diff --git a/addons/point_of_sale/models/pos_order.py b/addons/point_of_sale/models/pos_order.py new file mode 100644 index 00000000..cdcc7a9c --- /dev/null +++ b/addons/point_of_sale/models/pos_order.py @@ -0,0 +1,1021 @@ +# -*- coding: utf-8 -*- +# Part of Odoo. See LICENSE file for full copyright and licensing details. +import logging +from datetime import timedelta +from functools import partial + +import psycopg2 +import pytz +import re + +from odoo import api, fields, models, tools, _ +from odoo.tools import float_is_zero, float_round +from odoo.exceptions import ValidationError, UserError +from odoo.http import request +from odoo.osv.expression import AND +import base64 + +_logger = logging.getLogger(__name__) + + +class PosOrder(models.Model): + _name = "pos.order" + _description = "Point of Sale Orders" + _order = "date_order desc, name desc, id desc" + + @api.model + def _amount_line_tax(self, line, fiscal_position_id): + taxes = line.tax_ids.filtered(lambda t: t.company_id.id == line.order_id.company_id.id) + taxes = fiscal_position_id.map_tax(taxes, line.product_id, line.order_id.partner_id) + price = line.price_unit * (1 - (line.discount or 0.0) / 100.0) + taxes = taxes.compute_all(price, line.order_id.pricelist_id.currency_id, line.qty, product=line.product_id, partner=line.order_id.partner_id or False)['taxes'] + return sum(tax.get('amount', 0.0) for tax in taxes) + + @api.model + def _order_fields(self, ui_order): + process_line = partial(self.env['pos.order.line']._order_line_fields, session_id=ui_order['pos_session_id']) + return { + 'user_id': ui_order['user_id'] or False, + 'session_id': ui_order['pos_session_id'], + 'lines': [process_line(l) for l in ui_order['lines']] if ui_order['lines'] else False, + 'pos_reference': ui_order['name'], + 'sequence_number': ui_order['sequence_number'], + 'partner_id': ui_order['partner_id'] or False, + 'date_order': ui_order['creation_date'].replace('T', ' ')[:19], + 'fiscal_position_id': ui_order['fiscal_position_id'], + 'pricelist_id': ui_order['pricelist_id'], + 'amount_paid': ui_order['amount_paid'], + 'amount_total': ui_order['amount_total'], + 'amount_tax': ui_order['amount_tax'], + 'amount_return': ui_order['amount_return'], + 'company_id': self.env['pos.session'].browse(ui_order['pos_session_id']).company_id.id, + 'to_invoice': ui_order['to_invoice'] if "to_invoice" in ui_order else False, + 'is_tipped': ui_order.get('is_tipped', False), + 'tip_amount': ui_order.get('tip_amount', 0), + } + + @api.model + def _payment_fields(self, order, ui_paymentline): + return { + 'amount': ui_paymentline['amount'] or 0.0, + 'payment_date': ui_paymentline['name'], + 'payment_method_id': ui_paymentline['payment_method_id'], + 'card_type': ui_paymentline.get('card_type'), + 'cardholder_name': ui_paymentline.get('cardholder_name'), + 'transaction_id': ui_paymentline.get('transaction_id'), + 'payment_status': ui_paymentline.get('payment_status'), + 'ticket': ui_paymentline.get('ticket'), + 'pos_order_id': order.id, + } + + # This deals with orders that belong to a closed session. In order + # to recover from this situation we create a new rescue session, + # making it obvious that something went wrong. + # A new, separate, rescue session is preferred for every such recovery, + # to avoid adding unrelated orders to live sessions. + def _get_valid_session(self, order): + PosSession = self.env['pos.session'] + closed_session = PosSession.browse(order['pos_session_id']) + + _logger.warning('session %s (ID: %s) was closed but received order %s (total: %s) belonging to it', + closed_session.name, + closed_session.id, + order['name'], + order['amount_total']) + rescue_session = PosSession.search([ + ('state', 'not in', ('closed', 'closing_control')), + ('rescue', '=', True), + ('config_id', '=', closed_session.config_id.id), + ], limit=1) + if rescue_session: + _logger.warning('reusing recovery session %s for saving order %s', rescue_session.name, order['name']) + return rescue_session + + _logger.warning('attempting to create recovery session for saving order %s', order['name']) + new_session = PosSession.create({ + 'config_id': closed_session.config_id.id, + 'name': _('(RESCUE FOR %(session)s)') % {'session': closed_session.name}, + 'rescue': True, # avoid conflict with live sessions + }) + # bypass opening_control (necessary when using cash control) + new_session.action_pos_session_open() + + return new_session + + + @api.model + def _process_order(self, order, draft, existing_order): + """Create or update an pos.order from a given dictionary. + + :param dict order: dictionary representing the order. + :param bool draft: Indicate that the pos_order is not validated yet. + :param existing_order: order to be updated or False. + :type existing_order: pos.order. + :returns: id of created/updated pos.order + :rtype: int + """ + order = order['data'] + pos_session = self.env['pos.session'].browse(order['pos_session_id']) + if pos_session.state == 'closing_control' or pos_session.state == 'closed': + order['pos_session_id'] = self._get_valid_session(order).id + + pos_order = False + if not existing_order: + pos_order = self.create(self._order_fields(order)) + else: + pos_order = existing_order + pos_order.lines.unlink() + order['user_id'] = pos_order.user_id.id + pos_order.write(self._order_fields(order)) + + pos_order = pos_order.with_company(pos_order.company_id) + self = self.with_company(pos_order.company_id) + self._process_payment_lines(order, pos_order, pos_session, draft) + + if not draft: + try: + pos_order.action_pos_order_paid() + except psycopg2.DatabaseError: + # do not hide transactional errors, the order(s) won't be saved! + raise + except Exception as e: + _logger.error('Could not fully process the POS Order: %s', tools.ustr(e)) + pos_order._create_order_picking() + + if pos_order.to_invoice and pos_order.state == 'paid': + pos_order.action_pos_order_invoice() + + return pos_order.id + + + def _process_payment_lines(self, pos_order, order, pos_session, draft): + """Create account.bank.statement.lines from the dictionary given to the parent function. + + If the payment_line is an updated version of an existing one, the existing payment_line will first be + removed before making a new one. + :param pos_order: dictionary representing the order. + :type pos_order: dict. + :param order: Order object the payment lines should belong to. + :type order: pos.order + :param pos_session: PoS session the order was created in. + :type pos_session: pos.session + :param draft: Indicate that the pos_order is not validated yet. + :type draft: bool. + """ + prec_acc = order.pricelist_id.currency_id.decimal_places + + order_bank_statement_lines= self.env['pos.payment'].search([('pos_order_id', '=', order.id)]) + order_bank_statement_lines.unlink() + for payments in pos_order['statement_ids']: + order.add_payment(self._payment_fields(order, payments[2])) + + order.amount_paid = sum(order.payment_ids.mapped('amount')) + + if not draft and not float_is_zero(pos_order['amount_return'], prec_acc): + cash_payment_method = pos_session.payment_method_ids.filtered('is_cash_count')[:1] + if not cash_payment_method: + raise UserError(_("No cash statement found for this session. Unable to record returned cash.")) + return_payment_vals = { + 'name': _('return'), + 'pos_order_id': order.id, + 'amount': -pos_order['amount_return'], + 'payment_date': fields.Datetime.now(), + 'payment_method_id': cash_payment_method.id, + 'is_change': True, + } + order.add_payment(return_payment_vals) + + def _prepare_invoice_line(self, order_line): + return { + 'product_id': order_line.product_id.id, + 'quantity': order_line.qty if self.amount_total >= 0 else -order_line.qty, + 'discount': order_line.discount, + 'price_unit': order_line.price_unit, + 'name': order_line.product_id.display_name, + 'tax_ids': [(6, 0, order_line.tax_ids_after_fiscal_position.ids)], + 'product_uom_id': order_line.product_uom_id.id, + } + + def _get_pos_anglo_saxon_price_unit(self, product, partner_id, quantity): + moves = self.filtered(lambda o: o.partner_id.id == partner_id)\ + .mapped('picking_ids.move_lines')\ + ._filter_anglo_saxon_moves(product)\ + .sorted(lambda x: x.date) + price_unit = product._compute_average_price(0, quantity, moves) + return price_unit + + name = fields.Char(string='Order Ref', required=True, readonly=True, copy=False, default='/') + date_order = fields.Datetime(string='Date', readonly=True, index=True, default=fields.Datetime.now) + user_id = fields.Many2one( + comodel_name='res.users', string='Responsible', + help="Person who uses the cash register. It can be a reliever, a student or an interim employee.", + default=lambda self: self.env.uid, + states={'done': [('readonly', True)], 'invoiced': [('readonly', True)]}, + ) + amount_tax = fields.Float(string='Taxes', digits=0, readonly=True, required=True) + amount_total = fields.Float(string='Total', digits=0, readonly=True, required=True) + amount_paid = fields.Float(string='Paid', states={'draft': [('readonly', False)]}, + readonly=True, digits=0, required=True) + amount_return = fields.Float(string='Returned', digits=0, required=True, readonly=True) + lines = fields.One2many('pos.order.line', 'order_id', string='Order Lines', states={'draft': [('readonly', False)]}, readonly=True, copy=True) + company_id = fields.Many2one('res.company', string='Company', required=True, readonly=True) + pricelist_id = fields.Many2one('product.pricelist', string='Pricelist', required=True, states={ + 'draft': [('readonly', False)]}, readonly=True) + partner_id = fields.Many2one('res.partner', string='Customer', change_default=True, index=True, states={'draft': [('readonly', False)], 'paid': [('readonly', False)]}) + sequence_number = fields.Integer(string='Sequence Number', help='A session-unique sequence number for the order', default=1) + + session_id = fields.Many2one( + 'pos.session', string='Session', required=True, index=True, + domain="[('state', '=', 'opened')]", states={'draft': [('readonly', False)]}, + readonly=True) + config_id = fields.Many2one('pos.config', related='session_id.config_id', string="Point of Sale", readonly=False) + currency_id = fields.Many2one('res.currency', related='config_id.currency_id', string="Currency") + currency_rate = fields.Float("Currency Rate", compute='_compute_currency_rate', compute_sudo=True, store=True, digits=0, readonly=True, + help='The rate of the currency to the currency of rate applicable at the date of the order') + + invoice_group = fields.Boolean(related="config_id.module_account", readonly=False) + state = fields.Selection( + [('draft', 'New'), ('cancel', 'Cancelled'), ('paid', 'Paid'), ('done', 'Posted'), ('invoiced', 'Invoiced')], + 'Status', readonly=True, copy=False, default='draft') + + account_move = fields.Many2one('account.move', string='Invoice', readonly=True, copy=False) + picking_ids = fields.One2many('stock.picking', 'pos_order_id') + picking_count = fields.Integer(compute='_compute_picking_count') + failed_pickings = fields.Boolean(compute='_compute_picking_count') + picking_type_id = fields.Many2one('stock.picking.type', related='session_id.config_id.picking_type_id', string="Operation Type", readonly=False) + + note = fields.Text(string='Internal Notes') + nb_print = fields.Integer(string='Number of Print', readonly=True, copy=False, default=0) + pos_reference = fields.Char(string='Receipt Number', readonly=True, copy=False) + sale_journal = fields.Many2one('account.journal', related='session_id.config_id.journal_id', string='Sales Journal', store=True, readonly=True, ondelete='restrict') + fiscal_position_id = fields.Many2one( + comodel_name='account.fiscal.position', string='Fiscal Position', + readonly=True, + states={'draft': [('readonly', False)]}, + ) + payment_ids = fields.One2many('pos.payment', 'pos_order_id', string='Payments', readonly=True) + session_move_id = fields.Many2one('account.move', string='Session Journal Entry', related='session_id.move_id', readonly=True, copy=False) + to_invoice = fields.Boolean('To invoice') + is_invoiced = fields.Boolean('Is Invoiced', compute='_compute_is_invoiced') + is_tipped = fields.Boolean('Is this already tipped?', readonly=True) + tip_amount = fields.Float(string='Tip Amount', digits=0, readonly=True) + + @api.depends('account_move') + def _compute_is_invoiced(self): + for order in self: + order.is_invoiced = bool(order.account_move) + + @api.depends('picking_ids', 'picking_ids.state') + def _compute_picking_count(self): + for order in self: + order.picking_count = len(order.picking_ids) + order.failed_pickings = bool(order.picking_ids.filtered(lambda p: p.state != 'done')) + + @api.depends('date_order', 'company_id', 'currency_id', 'company_id.currency_id') + def _compute_currency_rate(self): + for order in self: + order.currency_rate = self.env['res.currency']._get_conversion_rate(order.company_id.currency_id, order.currency_id, order.company_id, order.date_order) + + @api.onchange('payment_ids', 'lines') + def _onchange_amount_all(self): + for order in self: + currency = order.pricelist_id.currency_id + order.amount_paid = sum(payment.amount for payment in order.payment_ids) + order.amount_return = sum(payment.amount < 0 and payment.amount or 0 for payment in order.payment_ids) + order.amount_tax = currency.round(sum(self._amount_line_tax(line, order.fiscal_position_id) for line in order.lines)) + amount_untaxed = currency.round(sum(line.price_subtotal for line in order.lines)) + order.amount_total = order.amount_tax + amount_untaxed + + def _compute_batch_amount_all(self): + """ + Does essentially the same thing as `_onchange_amount_all` but only for actually existing records + It is intended as a helper method , not as a business one + Practical to be used for migrations + """ + amounts = {order_id: {'paid': 0, 'return': 0, 'taxed': 0, 'taxes': 0} for order_id in self.ids} + for order in self.env['pos.payment'].read_group([('pos_order_id', 'in', self.ids)], ['pos_order_id', 'amount'], ['pos_order_id']): + amounts[order['pos_order_id'][0]]['paid'] = order['amount'] + for order in self.env['pos.payment'].read_group(['&', ('pos_order_id', 'in', self.ids), ('amount', '<', 0)], ['pos_order_id', 'amount'], ['pos_order_id']): + amounts[order['pos_order_id'][0]]['return'] = order['amount'] + for order in self.env['pos.order.line'].read_group([('order_id', 'in', self.ids)], ['order_id', 'price_subtotal', 'price_subtotal_incl'], ['order_id']): + amounts[order['order_id'][0]]['taxed'] = order['price_subtotal_incl'] + amounts[order['order_id'][0]]['taxes'] = order['price_subtotal_incl'] - order['price_subtotal'] + + for order in self: + currency = order.pricelist_id.currency_id + order.write({ + 'amount_paid': amounts[order.id]['paid'], + 'amount_return': amounts[order.id]['return'], + 'amount_tax': currency.round(amounts[order.id]['taxes']), + 'amount_total': currency.round(amounts[order.id]['taxed']) + }) + + @api.onchange('partner_id') + def _onchange_partner_id(self): + if self.partner_id: + self.pricelist_id = self.partner_id.property_product_pricelist.id + + def unlink(self): + for pos_order in self.filtered(lambda pos_order: pos_order.state not in ['draft', 'cancel']): + raise UserError(_('In order to delete a sale, it must be new or cancelled.')) + return super(PosOrder, self).unlink() + + @api.model + def create(self, values): + session = self.env['pos.session'].browse(values['session_id']) + values = self._complete_values_from_session(session, values) + return super(PosOrder, self).create(values) + + @api.model + def _complete_values_from_session(self, session, values): + if values.get('state') and values['state'] == 'paid': + values['name'] = session.config_id.sequence_id._next() + values.setdefault('pricelist_id', session.config_id.pricelist_id.id) + values.setdefault('fiscal_position_id', session.config_id.default_fiscal_position_id.id) + values.setdefault('company_id', session.config_id.company_id.id) + return values + + def write(self, vals): + for order in self: + if vals.get('state') and vals['state'] == 'paid' and order.name == '/': + vals['name'] = order.config_id.sequence_id._next() + return super(PosOrder, self).write(vals) + + def action_stock_picking(self): + self.ensure_one() + action = self.env['ir.actions.act_window']._for_xml_id('stock.action_picking_tree_ready') + action['context'] = {} + action['domain'] = [('id', 'in', self.picking_ids.ids)] + return action + + def action_view_invoice(self): + return { + 'name': _('Customer Invoice'), + 'view_mode': 'form', + 'view_id': self.env.ref('account.view_move_form').id, + 'res_model': 'account.move', + 'context': "{'move_type':'out_invoice'}", + 'type': 'ir.actions.act_window', + 'res_id': self.account_move.id, + } + + def _is_pos_order_paid(self): + return float_is_zero(self._get_rounded_amount(self.amount_total) - self.amount_paid, precision_rounding=self.currency_id.rounding) + + def _get_rounded_amount(self, amount): + if self.config_id.cash_rounding: + amount = float_round(amount, precision_rounding=self.config_id.rounding_method.rounding, rounding_method=self.config_id.rounding_method.rounding_method) + currency = self.currency_id + return currency.round(amount) if currency else amount + + def _create_invoice(self, move_vals): + self.ensure_one() + new_move = self.env['account.move'].sudo().with_company(self.company_id).with_context(default_move_type=move_vals['move_type']).create(move_vals) + message = _("This invoice has been created from the point of sale session: <a href=# data-oe-model=pos.order data-oe-id=%d>%s</a>") % (self.id, self.name) + new_move.message_post(body=message) + if self.config_id.cash_rounding: + rounding_applied = float_round(self.amount_paid - self.amount_total, + precision_rounding=new_move.currency_id.rounding) + rounding_line = new_move.line_ids.filtered(lambda line: line.is_rounding_line) + if rounding_line and rounding_line.debit > 0: + rounding_line_difference = rounding_line.debit + rounding_applied + elif rounding_line and rounding_line.credit > 0: + rounding_line_difference = -rounding_line.credit + rounding_applied + else: + rounding_line_difference = rounding_applied + if rounding_applied: + if rounding_applied > 0.0: + account_id = new_move.invoice_cash_rounding_id.loss_account_id.id + else: + account_id = new_move.invoice_cash_rounding_id.profit_account_id.id + if rounding_line: + if rounding_line_difference: + rounding_line.with_context(check_move_validity=False).write({ + 'debit': rounding_applied < 0.0 and -rounding_applied or 0.0, + 'credit': rounding_applied > 0.0 and rounding_applied or 0.0, + 'account_id': account_id, + 'price_unit': rounding_applied, + }) + + else: + self.env['account.move.line'].with_context(check_move_validity=False).create({ + 'debit': rounding_applied < 0.0 and -rounding_applied or 0.0, + 'credit': rounding_applied > 0.0 and rounding_applied or 0.0, + 'quantity': 1.0, + 'amount_currency': rounding_applied, + 'partner_id': new_move.partner_id.id, + 'move_id': new_move.id, + 'currency_id': new_move.currency_id if new_move.currency_id != new_move.company_id.currency_id else False, + 'company_id': new_move.company_id.id, + 'company_currency_id': new_move.company_id.currency_id.id, + 'is_rounding_line': True, + 'sequence': 9999, + 'name': new_move.invoice_cash_rounding_id.name, + 'account_id': account_id, + }) + else: + if rounding_line: + rounding_line.with_context(check_move_validity=False).unlink() + if rounding_line_difference: + existing_terms_line = new_move.line_ids.filtered( + lambda line: line.account_id.user_type_id.type in ('receivable', 'payable')) + if existing_terms_line.debit > 0: + existing_terms_line_new_val = float_round( + existing_terms_line.debit + rounding_line_difference, + precision_rounding=new_move.currency_id.rounding) + else: + existing_terms_line_new_val = float_round( + -existing_terms_line.credit + rounding_line_difference, + precision_rounding=new_move.currency_id.rounding) + existing_terms_line.write({ + 'debit': existing_terms_line_new_val > 0.0 and existing_terms_line_new_val or 0.0, + 'credit': existing_terms_line_new_val < 0.0 and -existing_terms_line_new_val or 0.0, + }) + + new_move._recompute_payment_terms_lines() + return new_move + + def action_pos_order_paid(self): + self.ensure_one() + + # TODO: add support for mix of cash and non-cash payments when both cash_rounding and only_round_cash_method are True + if not self.config_id.cash_rounding \ + or self.config_id.only_round_cash_method \ + and not any(p.payment_method_id.is_cash_count for p in self.payment_ids): + total = self.amount_total + else: + total = float_round(self.amount_total, precision_rounding=self.config_id.rounding_method.rounding, rounding_method=self.config_id.rounding_method.rounding_method) + + isPaid = float_is_zero(total - self.amount_paid, precision_rounding=self.currency_id.rounding) + + if not isPaid and not self.config_id.cash_rounding: + raise UserError(_("Order %s is not fully paid.", self.name)) + elif not isPaid and self.config_id.cash_rounding: + currency = self.currency_id + if self.config_id.rounding_method.rounding_method == "HALF-UP": + maxDiff = currency.round(self.config_id.rounding_method.rounding / 2) + else: + maxDiff = currency.round(self.config_id.rounding_method.rounding) + + diff = currency.round(self.amount_total - self.amount_paid) + if not abs(diff) < maxDiff: + raise UserError(_("Order %s is not fully paid.", self.name)) + + self.write({'state': 'paid'}) + + return True + + def _prepare_invoice_vals(self): + self.ensure_one() + timezone = pytz.timezone(self._context.get('tz') or self.env.user.tz or 'UTC') + note = self.note or '' + terms = '' + if self.env['ir.config_parameter'].sudo().get_param('account.use_invoice_terms') and self.env.company.invoice_terms: + terms = self.with_context(lang=self.partner_id.lang).env.company.invoice_terms + + narration = note + '\n' + terms if note else terms + + vals = { + 'payment_reference': self.name, + 'invoice_origin': self.name, + 'journal_id': self.session_id.config_id.invoice_journal_id.id, + 'move_type': 'out_invoice' if self.amount_total >= 0 else 'out_refund', + 'ref': self.name, + 'partner_id': self.partner_id.id, + 'narration': narration, + # considering partner's sale pricelist's currency + 'currency_id': self.pricelist_id.currency_id.id, + 'invoice_user_id': self.user_id.id, + 'invoice_date': self.date_order.astimezone(timezone).date(), + 'fiscal_position_id': self.fiscal_position_id.id, + 'invoice_line_ids': [(0, None, self._prepare_invoice_line(line)) for line in self.lines], + 'invoice_cash_rounding_id': self.config_id.rounding_method.id + if self.config_id.cash_rounding and (not self.config_id.only_round_cash_method or any(p.payment_method_id.is_cash_count for p in self.payment_ids)) + else False + } + return vals + + def action_pos_order_invoice(self): + moves = self.env['account.move'] + + for order in self: + # Force company for all SUPERUSER_ID action + if order.account_move: + moves += order.account_move + continue + + if not order.partner_id: + raise UserError(_('Please provide a partner for the sale.')) + + move_vals = order._prepare_invoice_vals() + new_move = order._create_invoice(move_vals) + order.write({'account_move': new_move.id, 'state': 'invoiced'}) + new_move.sudo().with_company(order.company_id)._post() + moves += new_move + + if not moves: + return {} + + return { + 'name': _('Customer Invoice'), + 'view_mode': 'form', + 'view_id': self.env.ref('account.view_move_form').id, + 'res_model': 'account.move', + 'context': "{'move_type':'out_invoice'}", + 'type': 'ir.actions.act_window', + 'nodestroy': True, + 'target': 'current', + 'res_id': moves and moves.ids[0] or False, + } + + # this method is unused, and so is the state 'cancel' + def action_pos_order_cancel(self): + return self.write({'state': 'cancel'}) + + @api.model + def create_from_ui(self, orders, draft=False): + """ Create and update Orders from the frontend PoS application. + + Create new orders and update orders that are in draft status. If an order already exists with a status + diferent from 'draft'it will be discareded, otherwise it will be saved to the database. If saved with + 'draft' status the order can be overwritten later by this function. + + :param orders: dictionary with the orders to be created. + :type orders: dict. + :param draft: Indicate if the orders are ment to be finalised or temporarily saved. + :type draft: bool. + :Returns: list -- list of db-ids for the created and updated orders. + """ + order_ids = [] + for order in orders: + existing_order = False + if 'server_id' in order['data']: + existing_order = self.env['pos.order'].search(['|', ('id', '=', order['data']['server_id']), ('pos_reference', '=', order['data']['name'])], limit=1) + if (existing_order and existing_order.state == 'draft') or not existing_order: + order_ids.append(self._process_order(order, draft, existing_order)) + + return self.env['pos.order'].search_read(domain = [('id', 'in', order_ids)], fields = ['id', 'pos_reference']) + + def _create_order_picking(self): + self.ensure_one() + if not self.session_id.update_stock_at_closing or (self.company_id.anglo_saxon_accounting and self.to_invoice): + picking_type = self.config_id.picking_type_id + if self.partner_id.property_stock_customer: + destination_id = self.partner_id.property_stock_customer.id + elif not picking_type or not picking_type.default_location_dest_id: + destination_id = self.env['stock.warehouse']._get_partner_locations()[0].id + else: + destination_id = picking_type.default_location_dest_id.id + + pickings = self.env['stock.picking']._create_picking_from_pos_order_lines(destination_id, self.lines, picking_type, self.partner_id) + pickings.write({'pos_session_id': self.session_id.id, 'pos_order_id': self.id, 'origin': self.name}) + + def add_payment(self, data): + """Create a new payment for the order""" + self.ensure_one() + self.env['pos.payment'].create(data) + self.amount_paid = sum(self.payment_ids.mapped('amount')) + + def _prepare_refund_values(self, current_session): + self.ensure_one() + return { + 'name': self.name + _(' REFUND'), + 'session_id': current_session.id, + 'date_order': fields.Datetime.now(), + 'pos_reference': self.pos_reference, + 'lines': False, + 'amount_tax': -self.amount_tax, + 'amount_total': -self.amount_total, + 'amount_paid': 0, + } + + def refund(self): + """Create a copy of order for refund order""" + refund_orders = self.env['pos.order'] + for order in self: + # When a refund is performed, we are creating it in a session having the same config as the original + # order. It can be the same session, or if it has been closed the new one that has been opened. + current_session = order.session_id.config_id.current_session_id + if not current_session: + raise UserError(_('To return product(s), you need to open a session in the POS %s', order.session_id.config_id.display_name)) + refund_order = order.copy( + order._prepare_refund_values(current_session) + ) + for line in order.lines: + PosOrderLineLot = self.env['pos.pack.operation.lot'] + for pack_lot in line.pack_lot_ids: + PosOrderLineLot += pack_lot.copy() + line.copy(line._prepare_refund_data(refund_order, PosOrderLineLot)) + refund_orders |= refund_order + + return { + 'name': _('Return Products'), + 'view_mode': 'form', + 'res_model': 'pos.order', + 'res_id': refund_orders.ids[0], + 'view_id': False, + 'context': self.env.context, + 'type': 'ir.actions.act_window', + 'target': 'current', + } + + def action_receipt_to_customer(self, name, client, ticket): + if not self: + return False + if not client.get('email'): + return False + + message = _("<p>Dear %s,<br/>Here is your electronic ticket for the %s. </p>") % (client['name'], name) + filename = 'Receipt-' + name + '.jpg' + receipt = self.env['ir.attachment'].create({ + 'name': filename, + 'type': 'binary', + 'datas': ticket, + 'res_model': 'pos.order', + 'res_id': self.ids[0], + 'store_fname': filename, + 'mimetype': 'image/jpeg', + }) + mail_values = { + 'subject': _('Receipt %s', name), + 'body_html': message, + 'author_id': self.env.user.partner_id.id, + 'email_from': self.env.company.email or self.env.user.email_formatted, + 'email_to': client['email'], + 'attachment_ids': [(4, receipt.id)], + } + + if self.mapped('account_move'): + report = self.env.ref('point_of_sale.pos_invoice_report')._render_qweb_pdf(self.ids[0]) + filename = name + '.pdf' + attachment = self.env['ir.attachment'].create({ + 'name': filename, + 'type': 'binary', + 'datas': base64.b64encode(report[0]), + 'store_fname': filename, + 'res_model': 'pos.order', + 'res_id': self.ids[0], + 'mimetype': 'application/x-pdf' + }) + mail_values['attachment_ids'] += [(4, attachment.id)] + + mail = self.env['mail.mail'].sudo().create(mail_values) + mail.send() + + @api.model + def remove_from_ui(self, server_ids): + """ Remove orders from the frontend PoS application + + Remove orders from the server by id. + :param server_ids: list of the id's of orders to remove from the server. + :type server_ids: list. + :returns: list -- list of db-ids for the removed orders. + """ + orders = self.search([('id', 'in', server_ids),('state', '=', 'draft')]) + orders.write({'state': 'cancel'}) + # TODO Looks like delete cascade is a better solution. + orders.mapped('payment_ids').sudo().unlink() + orders.sudo().unlink() + return orders.ids + + @api.model + def search_paid_order_ids(self, config_id, domain, limit, offset): + """Search for 'paid' orders that satisfy the given domain, limit and offset.""" + default_domain = ['&', ('config_id', '=', config_id), '!', '|', ('state', '=', 'draft'), ('state', '=', 'cancelled')] + real_domain = AND([domain, default_domain]) + ids = self.search(AND([domain, default_domain]), limit=limit, offset=offset).ids + totalCount = self.search_count(real_domain) + return {'ids': ids, 'totalCount': totalCount} + + def _export_for_ui(self, order): + timezone = pytz.timezone(self._context.get('tz') or self.env.user.tz or 'UTC') + return { + 'lines': [[0, 0, line] for line in order.lines.export_for_ui()], + 'statement_ids': [[0, 0, payment] for payment in order.payment_ids.export_for_ui()], + 'name': order.pos_reference, + 'uid': re.search('([0-9]|-){14}', order.pos_reference).group(0), + 'amount_paid': order.amount_paid, + 'amount_total': order.amount_total, + 'amount_tax': order.amount_tax, + 'amount_return': order.amount_return, + 'pos_session_id': order.session_id.id, + 'is_session_closed': order.session_id.state == 'closed', + 'pricelist_id': order.pricelist_id.id, + 'partner_id': order.partner_id.id, + 'user_id': order.user_id.id, + 'sequence_number': order.sequence_number, + 'creation_date': order.date_order.astimezone(timezone), + 'fiscal_position_id': order.fiscal_position_id.id, + 'to_invoice': order.to_invoice, + 'state': order.state, + 'account_move': order.account_move.id, + 'id': order.id, + 'is_tipped': order.is_tipped, + 'tip_amount': order.tip_amount, + } + + def export_for_ui(self): + """ Returns a list of dict with each item having similar signature as the return of + `export_as_JSON` of models.Order. This is useful for back-and-forth communication + between the pos frontend and backend. + """ + return self.mapped(self._export_for_ui) if self else [] + + +class PosOrderLine(models.Model): + _name = "pos.order.line" + _description = "Point of Sale Order Lines" + _rec_name = "product_id" + + def _order_line_fields(self, line, session_id=None): + if line and 'name' not in line[2]: + session = self.env['pos.session'].browse(session_id).exists() if session_id else None + if session and session.config_id.sequence_line_id: + # set name based on the sequence specified on the config + line[2]['name'] = session.config_id.sequence_line_id._next() + else: + # fallback on any pos.order.line sequence + line[2]['name'] = self.env['ir.sequence'].next_by_code('pos.order.line') + + if line and 'tax_ids' not in line[2]: + product = self.env['product.product'].browse(line[2]['product_id']) + line[2]['tax_ids'] = [(6, 0, [x.id for x in product.taxes_id])] + # Clean up fields sent by the JS + line = [ + line[0], line[1], {k: v for k, v in line[2].items() if k in self.env['pos.order.line']._fields} + ] + return line + + company_id = fields.Many2one('res.company', string='Company', related="order_id.company_id", store=True) + name = fields.Char(string='Line No', required=True, copy=False) + notice = fields.Char(string='Discount Notice') + product_id = fields.Many2one('product.product', string='Product', domain=[('sale_ok', '=', True)], required=True, change_default=True) + price_unit = fields.Float(string='Unit Price', digits=0) + qty = fields.Float('Quantity', digits='Product Unit of Measure', default=1) + price_subtotal = fields.Float(string='Subtotal w/o Tax', digits=0, + readonly=True, required=True) + price_subtotal_incl = fields.Float(string='Subtotal', digits=0, + readonly=True, required=True) + discount = fields.Float(string='Discount (%)', digits=0, default=0.0) + order_id = fields.Many2one('pos.order', string='Order Ref', ondelete='cascade', required=True) + tax_ids = fields.Many2many('account.tax', string='Taxes', readonly=True) + tax_ids_after_fiscal_position = fields.Many2many('account.tax', compute='_get_tax_ids_after_fiscal_position', string='Taxes to Apply') + pack_lot_ids = fields.One2many('pos.pack.operation.lot', 'pos_order_line_id', string='Lot/serial Number') + product_uom_id = fields.Many2one('uom.uom', string='Product UoM', related='product_id.uom_id') + currency_id = fields.Many2one('res.currency', related='order_id.currency_id') + full_product_name = fields.Char('Full Product Name') + + def _prepare_refund_data(self, refund_order, PosOrderLineLot): + """ + This prepares data for refund order line. Inheritance may inject more data here + + @param refund_order: the pre-created refund order + @type refund_order: pos.order + + @param PosOrderLineLot: the pre-created Pack operation Lot + @type PosOrderLineLot: pos.pack.operation.lot + + @return: dictionary of data which is for creating a refund order line from the original line + @rtype: dict + """ + self.ensure_one() + return { + 'name': self.name + _(' REFUND'), + 'qty': -self.qty, + 'order_id': refund_order.id, + 'price_subtotal': -self.price_subtotal, + 'price_subtotal_incl': -self.price_subtotal_incl, + 'pack_lot_ids': PosOrderLineLot, + } + + @api.model + def create(self, values): + if values.get('order_id') and not values.get('name'): + # set name based on the sequence specified on the config + config = self.env['pos.order'].browse(values['order_id']).session_id.config_id + if config.sequence_line_id: + values['name'] = config.sequence_line_id._next() + if not values.get('name'): + # fallback on any pos.order sequence + values['name'] = self.env['ir.sequence'].next_by_code('pos.order.line') + return super(PosOrderLine, self).create(values) + + def write(self, values): + if values.get('pack_lot_line_ids'): + for pl in values.get('pack_lot_ids'): + if pl[2].get('server_id'): + pl[2]['id'] = pl[2]['server_id'] + del pl[2]['server_id'] + return super().write(values) + + @api.onchange('price_unit', 'tax_ids', 'qty', 'discount', 'product_id') + def _onchange_amount_line_all(self): + for line in self: + res = line._compute_amount_line_all() + line.update(res) + + def _compute_amount_line_all(self): + self.ensure_one() + fpos = self.order_id.fiscal_position_id + tax_ids_after_fiscal_position = fpos.map_tax(self.tax_ids, self.product_id, self.order_id.partner_id) + price = self.price_unit * (1 - (self.discount or 0.0) / 100.0) + taxes = tax_ids_after_fiscal_position.compute_all(price, self.order_id.pricelist_id.currency_id, self.qty, product=self.product_id, partner=self.order_id.partner_id) + return { + 'price_subtotal_incl': taxes['total_included'], + 'price_subtotal': taxes['total_excluded'], + } + + @api.onchange('product_id') + def _onchange_product_id(self): + if self.product_id: + if not self.order_id.pricelist_id: + raise UserError( + _('You have to select a pricelist in the sale form !\n' + 'Please set one before choosing a product.')) + price = self.order_id.pricelist_id.get_product_price( + self.product_id, self.qty or 1.0, self.order_id.partner_id) + self._onchange_qty() + self.tax_ids = self.product_id.taxes_id.filtered(lambda r: not self.company_id or r.company_id == self.company_id) + tax_ids_after_fiscal_position = self.order_id.fiscal_position_id.map_tax(self.tax_ids, self.product_id, self.order_id.partner_id) + self.price_unit = self.env['account.tax']._fix_tax_included_price_company(price, self.product_id.taxes_id, tax_ids_after_fiscal_position, self.company_id) + + @api.onchange('qty', 'discount', 'price_unit', 'tax_ids') + def _onchange_qty(self): + if self.product_id: + if not self.order_id.pricelist_id: + raise UserError(_('You have to select a pricelist in the sale form.')) + price = self.price_unit * (1 - (self.discount or 0.0) / 100.0) + self.price_subtotal = self.price_subtotal_incl = price * self.qty + if (self.product_id.taxes_id): + taxes = self.product_id.taxes_id.compute_all(price, self.order_id.pricelist_id.currency_id, self.qty, product=self.product_id, partner=False) + self.price_subtotal = taxes['total_excluded'] + self.price_subtotal_incl = taxes['total_included'] + + @api.depends('order_id', 'order_id.fiscal_position_id') + def _get_tax_ids_after_fiscal_position(self): + for line in self: + line.tax_ids_after_fiscal_position = line.order_id.fiscal_position_id.map_tax(line.tax_ids, line.product_id, line.order_id.partner_id) + + def _export_for_ui(self, orderline): + return { + 'qty': orderline.qty, + 'price_unit': orderline.price_unit, + 'price_subtotal': orderline.price_subtotal, + 'price_subtotal_incl': orderline.price_subtotal_incl, + 'product_id': orderline.product_id.id, + 'discount': orderline.discount, + 'tax_ids': [[6, False, orderline.tax_ids.mapped(lambda tax: tax.id)]], + 'id': orderline.id, + 'pack_lot_ids': [[0, 0, lot] for lot in orderline.pack_lot_ids.export_for_ui()], + } + + def export_for_ui(self): + return self.mapped(self._export_for_ui) if self else [] + + +class PosOrderLineLot(models.Model): + _name = "pos.pack.operation.lot" + _description = "Specify product lot/serial number in pos order line" + _rec_name = "lot_name" + + pos_order_line_id = fields.Many2one('pos.order.line') + order_id = fields.Many2one('pos.order', related="pos_order_line_id.order_id", readonly=False) + lot_name = fields.Char('Lot Name') + product_id = fields.Many2one('product.product', related='pos_order_line_id.product_id', readonly=False) + + def _export_for_ui(self, lot): + return { + 'lot_name': lot.lot_name, + } + + def export_for_ui(self): + return self.mapped(self._export_for_ui) if self else [] + +class ReportSaleDetails(models.AbstractModel): + + _name = 'report.point_of_sale.report_saledetails' + _description = 'Point of Sale Details' + + + @api.model + def get_sale_details(self, date_start=False, date_stop=False, config_ids=False, session_ids=False): + """ Serialise the orders of the requested time period, configs and sessions. + + :param date_start: The dateTime to start, default today 00:00:00. + :type date_start: str. + :param date_stop: The dateTime to stop, default date_start + 23:59:59. + :type date_stop: str. + :param config_ids: Pos Config id's to include. + :type config_ids: list of numbers. + :param session_ids: Pos Config id's to include. + :type session_ids: list of numbers. + + :returns: dict -- Serialised sales. + """ + domain = [('state', 'in', ['paid','invoiced','done'])] + + if (session_ids): + domain = AND([domain, [('session_id', 'in', session_ids)]]) + else: + if date_start: + date_start = fields.Datetime.from_string(date_start) + else: + # start by default today 00:00:00 + user_tz = pytz.timezone(self.env.context.get('tz') or self.env.user.tz or 'UTC') + today = user_tz.localize(fields.Datetime.from_string(fields.Date.context_today(self))) + date_start = today.astimezone(pytz.timezone('UTC')) + + if date_stop: + date_stop = fields.Datetime.from_string(date_stop) + # avoid a date_stop smaller than date_start + if (date_stop < date_start): + date_stop = date_start + timedelta(days=1, seconds=-1) + else: + # stop by default today 23:59:59 + date_stop = date_start + timedelta(days=1, seconds=-1) + + domain = AND([domain, + [('date_order', '>=', fields.Datetime.to_string(date_start)), + ('date_order', '<=', fields.Datetime.to_string(date_stop))] + ]) + + if config_ids: + domain = AND([domain, [('config_id', 'in', config_ids)]]) + + orders = self.env['pos.order'].search(domain) + + user_currency = self.env.company.currency_id + + total = 0.0 + products_sold = {} + taxes = {} + for order in orders: + if user_currency != order.pricelist_id.currency_id: + total += order.pricelist_id.currency_id._convert( + order.amount_total, user_currency, order.company_id, order.date_order or fields.Date.today()) + else: + total += order.amount_total + currency = order.session_id.currency_id + + for line in order.lines: + key = (line.product_id, line.price_unit, line.discount) + products_sold.setdefault(key, 0.0) + products_sold[key] += line.qty + + if line.tax_ids_after_fiscal_position: + line_taxes = line.tax_ids_after_fiscal_position.sudo().compute_all(line.price_unit * (1-(line.discount or 0.0)/100.0), currency, line.qty, product=line.product_id, partner=line.order_id.partner_id or False) + for tax in line_taxes['taxes']: + taxes.setdefault(tax['id'], {'name': tax['name'], 'tax_amount':0.0, 'base_amount':0.0}) + taxes[tax['id']]['tax_amount'] += tax['amount'] + taxes[tax['id']]['base_amount'] += tax['base'] + else: + taxes.setdefault(0, {'name': _('No Taxes'), 'tax_amount':0.0, 'base_amount':0.0}) + taxes[0]['base_amount'] += line.price_subtotal_incl + + payment_ids = self.env["pos.payment"].search([('pos_order_id', 'in', orders.ids)]).ids + if payment_ids: + self.env.cr.execute(""" + SELECT method.name, sum(amount) total + FROM pos_payment AS payment, + pos_payment_method AS method + WHERE payment.payment_method_id = method.id + AND payment.id IN %s + GROUP BY method.name + """, (tuple(payment_ids),)) + payments = self.env.cr.dictfetchall() + else: + payments = [] + + return { + 'currency_precision': user_currency.decimal_places, + 'total_paid': user_currency.round(total), + 'payments': payments, + 'company_name': self.env.company.name, + 'taxes': list(taxes.values()), + 'products': sorted([{ + 'product_id': product.id, + 'product_name': product.name, + 'code': product.default_code, + 'quantity': qty, + 'price_unit': price_unit, + 'discount': discount, + 'uom': product.uom_id.name + } for (product, price_unit, discount), qty in products_sold.items()], key=lambda l: l['product_name']) + } + + @api.model + def _get_report_values(self, docids, data=None): + data = dict(data or {}) + configs = self.env['pos.config'].browse(data['config_ids']) + data.update(self.get_sale_details(data['date_start'], data['date_stop'], configs.ids)) + return data + +class AccountCashRounding(models.Model): + _inherit = 'account.cash.rounding' + + @api.constrains('rounding', 'rounding_method', 'strategy') + def _check_session_state(self): + open_session = self.env['pos.session'].search([('config_id.rounding_method', '=', self.id), ('state', '!=', 'closed')]) + if open_session: + raise ValidationError( + _("You are not allowed to change the cash rounding configuration while a pos session using it is already opened.")) |
