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
|
from odoo import models, api, fields
from odoo.exceptions import UserError
from datetime import datetime
import logging
_logger = logging.getLogger(__name__)
class AutomaticPurchase(models.Model):
_name = 'automatic.purchase'
date_doc = fields.Date(string='Date', required=True, help='Isi tanggal hari ini')
description = fields.Char(string='Description', help='bebas isi nya apa')
purchase_lines = fields.One2many('automatic.purchase.line', 'automatic_purchase_id', string='Lines', auto_join=True)
notification = fields.Char(string='Notification')
is_po = fields.Boolean(string='Is PO')
purchase_match = fields.One2many('automatic.purchase.match', 'automatic_purchase_id', string='Matches', auto_join=True)
def create_po_from_automatic_purchase(self):
if not self.purchase_lines:
raise UserError('Tidak ada Lines, belum bisa create PO')
if self.is_po:
raise UserError('Sudah pernah di create PO')
current_time = datetime.now()
vendor_ids = self.env['automatic.purchase.line'].read_group([('automatic_purchase_id', '=', self.id), ('partner_id', '!=', False)], fields=['partner_id'], groupby=['partner_id'])
for vendor in vendor_ids:
param_header = {
'partner_id': vendor['partner_id'][0],
'partner_ref': 'Automatic PO',
'currency_id': 12,
'user_id': self.env.user.id,
'company_id': 1, # indoteknik dotcom gemilang
'picking_type_id': 28, # indoteknik bandengan receipts
'date_order': current_time
}
new_po = self.env['purchase.order'].create([param_header])
products_vendors = self.env['automatic.purchase.line'].search([('automatic_purchase_id', '=', self.id), ('partner_id', '=', vendor['partner_id'][0])])
count=0
for product in products_vendors:
count += 10
param_line = {
'order_id': new_po.id,
'sequence': count,
'product_id': product.product_id.id,
'product_qty': product.qty_purchase,
'product_uom_qty': product.qty_purchase,
'price_unit': product.last_price,
}
new_line = self.env['purchase.order.line'].create([param_line])
product.current_po_id = new_po.id
product.current_po_line_id = new_line.id
_logger.info('Automatic Create PO Line %s' % product.product_id.name)
self.notification = self.notification + ' %s' % new_po.name
self.env['automatic.purchase.match'].create([{
'automatic_purchase_id': self.id,
'order_id': new_po.id
}])
def generate_automatic_purchase(self):
if self.purchase_lines:
raise UserError('Sudah digenerate sebelumnya, hapus line terlebih dahulu')
query = [
('product_min_qty', '>', 0)
]
orderpoints = self.env['stock.warehouse.orderpoint'].search(query)
count = 0
for point in orderpoints:
# _logger.info('test %s' % point.product_id.name)
if point.product_id.qty_available > point.product_min_qty:
continue
qty_purchase = point.product_max_qty - point.product_id.qty_available
po_line = self.env['purchase.order.line'].search([('product_id', '=', point.product_id.id), ('order_id.state', '=', 'done')], limit=1)
self.env['automatic.purchase.line'].create([{
'automatic_purchase_id': self.id,
'product_id': point.product_id.id,
'qty_purchase': qty_purchase,
'qty_min': point.product_min_qty,
'qty_max': point.product_max_qty,
'qty_available': point.product_id.qty_available,
'partner_id': po_line.order_id.partner_id.id,
'last_price': po_line.price_unit,
'subtotal': qty_purchase * po_line.price_unit,
'last_order_id': po_line.order_id.id,
'last_orderline_id': po_line.id
}])
count += 1
_logger.info('Create Automatic Purchase Line %s' % point.product_id.name)
self.notification = "Automatic PO Created %s Lines" % count
class AutomaticPurchaseLine(models.Model):
_name = 'automatic.purchase.line'
_description = 'Automatic Purchase Line'
_order = 'automatic_purchase_id, id'
automatic_purchase_id = fields.Many2one('automatic.purchase', string='Ref', required=True, ondelete='cascade', index=True, copy=False)
product_id = fields.Many2one('product.product', string='Product')
qty_purchase = fields.Float(string='Qty Purchase')
qty_min = fields.Float(string='Qty Min')
qty_max = fields.Float(string='Qty Max')
qty_available = fields.Float(string='Qty Available')
partner_id = fields.Many2one('res.partner', string='Vendor')
last_price = fields.Float(string='Last Price')
subtotal = fields.Float(string='Subtotal')
last_order_id = fields.Many2one('purchase.order', string='Last Order')
last_orderline_id = fields.Many2one('purchase.order.line', string='Last Order Line')
is_po = fields.Boolean(String='Is PO')
current_po_id = fields.Many2one('purchase.order', string='Current')
current_po_line_id = fields.Many2one('purchase.order.line', string='Current Line')
class AutomaticPurchaseMatch(models.Model):
_name = 'automatic.purchase.match'
_order = 'automatic_purchase_id, id'
automatic_purchase_id = fields.Many2one('automatic.purchase', string='Ref', required=True, ondelete='cascade', index=True, copy=False)
order_id = fields.Many2one('purchase.order', string='Purchase Order')
vendor = fields.Char(string='Vendor', compute='_compute_info_po')
total = fields.Float(string='Total', compute='_compute_info_po')
def _compute_info_po(self):
for match in self:
match.vendor = match.order_id.partner_id.name
match.total = match.order_id.amount_total
|
