1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
# -*- coding: utf-8 -*-
# Part of Odoo. See LICENSE file for full copyright and licensing details.
from odoo import api, fields, models
from odoo.osv import expression
class ProductCategory(models.Model):
_inherit = "product.category"
property_account_creditor_price_difference_categ = fields.Many2one(
'account.account', string="Price Difference Account",
company_dependent=True, ondelete='restrict',
help="This account will be used to value price difference between purchase price and accounting cost.")
class ProductTemplate(models.Model):
_name = 'product.template'
_inherit = 'product.template'
property_account_creditor_price_difference = fields.Many2one(
'account.account', string="Price Difference Account", company_dependent=True, ondelete='restrict',
help="This account is used in automated inventory valuation to "\
"record the price difference between a purchase order and its related vendor bill when validating this vendor bill.")
@api.model
def _get_buy_route(self):
buy_route = self.env.ref('purchase_stock.route_warehouse0_buy', raise_if_not_found=False)
if buy_route:
return self.env['stock.route'].search([('id', '=', buy_route.id)]).ids
return []
route_ids = fields.Many2many(default=lambda self: self._get_buy_route())
class ProductProduct(models.Model):
_name = 'product.product'
_inherit = 'product.product'
purchase_order_line_ids = fields.One2many('purchase.order.line', 'product_id', string="PO Lines") # used to compute quantities
def _get_quantity_in_progress(self, location_ids=False, warehouse_ids=False):
if not location_ids:
location_ids = []
if not warehouse_ids:
warehouse_ids = []
qty_by_product_location, qty_by_product_wh = super()._get_quantity_in_progress(location_ids, warehouse_ids)
domain = self._get_lines_domain(location_ids, warehouse_ids)
groups = self.env['purchase.order.line']._read_group(domain,
['order_id', 'product_id', 'product_uom', 'orderpoint_id', 'location_final_id'],
['product_qty:sum'])
for order, product, uom, orderpoint, location_final, product_qty_sum in groups:
if orderpoint:
location = orderpoint.location_id
elif location_final:
location = location_final
else:
location = order.picking_type_id.default_location_dest_id
product_qty = uom._compute_quantity(product_qty_sum, product.uom_id, round=False)
qty_by_product_location[(product.id, location.id)] += product_qty
qty_by_product_wh[(product.id, location.warehouse_id.id)] += product_qty
return qty_by_product_location, qty_by_product_wh
def _get_lines_domain(self, location_ids=False, warehouse_ids=False):
domains = []
rfq_domain = [
('state', 'in', ('draft', 'sent', 'to approve')),
('product_id', 'in', self.ids)
]
if location_ids:
domains.append(expression.AND([rfq_domain, [
'|',
'|',
('order_id.picking_type_id.default_location_dest_id', 'in', location_ids),
'&',
('move_ids', '=', False),
('location_final_id', 'child_of', location_ids),
'&',
('move_dest_ids', '=', False),
('orderpoint_id.location_id', 'in', location_ids)
]]))
if warehouse_ids:
domains.append(expression.AND([rfq_domain, [
'|',
('order_id.picking_type_id.warehouse_id', 'in', warehouse_ids),
'&',
('move_dest_ids', '=', False),
('orderpoint_id.warehouse_id', 'in', warehouse_ids)
]]))
return expression.OR(domains) if domains else []
class SupplierInfo(models.Model):
_inherit = 'product.supplierinfo'
last_purchase_date = fields.Date('Last Purchase', compute='_compute_last_purchase_date')
show_set_supplier_button = fields.Boolean(
'Show Set Supplier Button', compute='_compute_show_set_supplier_button')
def _compute_last_purchase_date(self):
self.last_purchase_date = False
purchases = self.env['purchase.order'].search([
('state', 'in', ('purchase', 'done')),
('order_line.product_id', 'in',
self.product_tmpl_id.product_variant_ids.ids),
('partner_id', 'in', self.partner_id.ids),
], order='date_order desc')
for supplier in self:
products = supplier.product_tmpl_id.product_variant_ids
for purchase in purchases:
if purchase.partner_id != supplier.partner_id:
continue
if not (products & purchase.order_line.product_id):
continue
supplier.last_purchase_date = purchase.date_order
break
def _compute_show_set_supplier_button(self):
self.show_set_supplier_button = True
orderpoint_id = self.env.context.get('default_orderpoint_id')
orderpoint = self.env['stock.warehouse.orderpoint'].browse(orderpoint_id)
if orderpoint_id:
self.filtered(
lambda s: s.id == orderpoint.supplier_id.id
).show_set_supplier_button = False
def action_set_supplier(self):
self.ensure_one()
orderpoint_id = self.env.context.get('orderpoint_id')
orderpoint = self.env['stock.warehouse.orderpoint'].browse(orderpoint_id)
if not orderpoint:
return
if 'buy' not in orderpoint.route_id.rule_ids.mapped('action'):
orderpoint.route_id = self.env['stock.rule'].search([('action', '=', 'buy')], limit=1).route_id.id
orderpoint.supplier_id = self
supplier_min_qty = self.product_uom._compute_quantity(self.min_qty, orderpoint.product_id.uom_id)
if orderpoint.qty_to_order < supplier_min_qty:
orderpoint.qty_to_order = supplier_min_qty
if self._context.get('replenish_id'):
replenish = self.env['product.replenish'].browse(self._context.get('replenish_id'))
replenish.supplier_id = self
return {
'type': 'ir.actions.act_window',
'name': 'Replenish',
'res_model': 'product.replenish',
'res_id': replenish.id,
'target': 'new',
'view_mode': 'form',
}
|
