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
|
from operator import index
from odoo import models, fields, api
from odoo.exceptions import UserError
from pytz import timezone
from datetime import datetime
import requests
import json
import logging
_logger = logging.getLogger(__name__)
class ReportLogbookSJ(models.Model):
_name = 'report.logbook.sj'
_description = "Logbook SJ"
_inherit = ['mail.thread']
_rec_name = 'name'
name = fields.Char(string='Name', default='Logbook SJ')
date = fields.Datetime(string='Date Created')
date_approve = fields.Datetime(string='Date Approve', tracking=3)
approve_by_finance = fields.Boolean(string='Approve By Finance', tracking=3)
approve_by = fields.Many2one(comodel_name='res.users', string='Approve By', tracking=3)
created_by = fields.Many2one(comodel_name='res.users', string='Created By', tracking=3)
report_logbook_sj_line = fields.One2many(
comodel_name='report.logbook.sj.line',
inverse_name='report_logbook_sj_id',
string='Logbook SJ Line'
)
state = fields.Selection(
[('belum_terima', 'Belum Terima'),
('terima_sebagian', 'Terima Sebagian'),
('terima_semua', 'Sudah di terima semua'),
],
default='terima_semua',
string='Status',
tracking=True,
)
sj_number = fields.Char(string='Picking', related='report_logbook_sj_line.name')
count_line = fields.Char(string='Count Line', compute='_compute_count_line')
@api.depends('report_logbook_sj_line')
def _compute_count_line(self):
for rec in self:
rec.count_line = len(rec.report_logbook_sj_line)
@api.model
def create(self, vals):
vals['name'] = self.env['ir.sequence'].next_by_code('report.logbook.sj') or '0'
result = super(ReportLogbookSJ, self).create(vals)
return result
def approve(self):
current_time = datetime.utcnow()
if self.env.user.is_accounting:
self.approve_by_finance = True
self.date_approve = current_time
self.approve_by = self.env.user.id
if any(line.not_exist for line in self.report_logbook_sj_line):
if all(line.not_exist for line in self.report_logbook_sj_line):
self.state = 'belum_terima'
else:
self.state = 'terima_sebagian'
else:
self.state = 'terima_semua'
else:
raise UserError('Hanya Accounting yang bisa Approve')
def write(self, vals):
res = super(ReportLogbookSJ, self).write(vals)
if 'report_logbook_sj_line' in vals or any(f in vals for f in ()):
self._resequence_lines()
return res
def _resequence_lines(self):
for rec in self:
lines = rec.report_logbook_sj_line.sorted(key=lambda l: (l.line_num or 0, l.id))
for idx, line in enumerate(lines, start=1):
if line.line_num != idx:
line.line_num = idx
@api.onchange('report_logbook_sj_line')
def _onchange_report_logbook_sj_line(self):
self._resequence_lines()
class ReportLogbookSJLine(models.Model):
_name = 'report.logbook.sj.line'
_order = 'sequence, id' # urut default di UI & ORM (drag pakai sequence)
name = fields.Char(string='SJ Number')
driver_id = fields.Many2one(comodel_name='res.users', string='Driver')
departure_date = fields.Char(string='Departure Date')
arrival_date = fields.Char(string='Arrival Date')
carrier_id = fields.Many2one('delivery.carrier', string='Shipping Method')
tracking_no = fields.Char(string='Tracking No')
# NOTE: field ini duplikat relasi; pakai salah satu saja.
# kamu boleh hapus logbook_sj_id kalau tidak dipakai di tempat lain.
logbook_sj_id = fields.Many2one('report.logbook.sj', string='Logbook SJ')
partner_id = fields.Many2one('res.partner', string='Customer')
picking_id = fields.Many2one('stock.picking', string='Picking')
sale_id = fields.Many2one('sale.order', string='Sale Order')
report_logbook_sj_id = fields.Many2one('report.logbook.sj', string='Logbook SJ')
not_exist = fields.Boolean(string='Not Exist')
note = fields.Char(string='Note')
sequence = fields.Integer(string='Sequence', default=0, index=True)
line_num = fields.Integer(string='No', compute='_compute_line_num', store=False)
@api.depends(
'report_logbook_sj_id.report_logbook_sj_line',
'report_logbook_sj_id.report_logbook_sj_line.sequence'
)
def _compute_line_num(self):
for parent in self.mapped('report_logbook_sj_id'):
lines = parent.report_logbook_sj_line.sorted(key=lambda l: (l.sequence or 0, l.id))
for i, l in enumerate(lines, start=1):
l.line_num = i
for rec in self.filtered(lambda r: not r.report_logbook_sj_id):
rec.line_num = 0
@api.model
def create(self, vals):
if not vals.get('sequence') and vals.get('report_logbook_sj_id'):
last = self.search(
[('report_logbook_sj_id', '=', vals['report_logbook_sj_id'])],
order='sequence desc, id desc', limit=1
)
vals['sequence'] = (last.sequence or 0) + 1
return super().create(vals)
|
