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
|
from odoo import models, api, fields
from odoo.exceptions import AccessError, UserError, ValidationError
from datetime import timedelta, date
import logging
_logger = logging.getLogger(__name__)
class CommissionInternal(models.Model):
_name = 'commission.internal'
_description = 'Commission Internal'
_order = 'date_doc, id desc'
_inherit = ['mail.thread']
_rec_name = 'number'
number = fields.Char(string='Document No', index=True, copy=False, readonly=True)
date_doc = fields.Date(string='Document Date', required=True)
month = fields.Selection([
('01', 'January'), ('02', 'February'), ('03', 'March'),
('04', 'April'), ('05', 'May'), ('06', 'June'),
('07', 'July'), ('08', 'August'), ('09', 'September'),
('10', 'October'), ('11', 'November'), ('12', 'December')
], string="Commission Month")
year = fields.Selection([(str(y), str(y)) for y in range(2025, 2036)], string="Commission Year")
description = fields.Char(string='Description')
comment = fields.Char(string='Comment')
commission_internal_line = fields.One2many('commission.internal.line', 'commission_internal_id', string='Lines',
auto_join=True, order='account_move_id asc')
@api.model
def create(self, vals):
vals['number'] = self.env['ir.sequence'].next_by_code('commission.internal') or '0'
result = super(CommissionInternal, self).create(vals)
return result
def _get_commission_internal_bank_account_ids(self):
bank_ids = self.env['ir.config_parameter'].sudo().get_param('commission.internal.bank.account.id')
if not bank_ids:
return []
return [int(x.strip()) for x in bank_ids.split(',') if x.strip().isdigit()]
def _get_period_range(self, period_year, period_month):
"""Return (date_start, date_end) using separate year and month fields."""
self.ensure_one() # make sure it's called on a single record
year_str = period_year or ''
month_str = period_month or ''
# Validate both fields exist
if not (year_str.isdigit() and month_str.isdigit()):
return None, None
year = int(year_str)
month = int(month_str)
# First day of this month
dt_start = date(year, month, 1)
# Compute first day of next month
if month == 12:
next_month = date(year + 1, 1, 1)
else:
next_month = date(year, month + 1, 1)
# Last day = one day before next month's first day
dt_end = next_month - timedelta(days=1)
return dt_start, dt_end
def generate_commission_from_generate_ledger(self):
if self.commission_internal_line:
raise UserError('Harus hapus semua line jika ingin generate ulang')
if not self.month:
raise UserError('Commission Month harus diisi')
if not self.year:
raise UserError('Commission Year harus diisi')
dt_start, dt_end = self._get_period_range(self.year, self.month)
account_bank_ids = self._get_commission_internal_bank_account_ids()
query = [
('move_id.state', '=', 'posted'),
('account_id', 'in', account_bank_ids),
('date', '>=', dt_start),
('date', '<=', dt_end)
]
ledgers = self.env['account.move.line'].search(query)
count = 0
for ledger in ledgers:
_logger.info("Read General Ledger Account Move Line %s" % ledger.id)
self.env['commission.internal.line'].create([{
'commission_internal_id': self.id,
'date': ledger.date,
'number': ledger.move_id.name,
'account_move_id': ledger.move_id.id,
'account_move_line_id': ledger.id,
'account_id': ledger.account_id.id,
'label': ledger.name,
'debit': ledger.debit,
'credit': ledger.credit,
'balance': ledger.balance
}])
count += 1
_logger.info("Commission Internal Line generated %s" % count)
class CommissionInternalLine(models.Model):
_name = 'commission.internal.line'
_description = 'Line'
_order = 'number asc, id'
commission_internal_id = fields.Many2one('commission.internal', string='Internal Ref', required=True,
ondelete='cascade', index=True, copy=False)
date = fields.Date(string='Date')
number = fields.Char(string='Number')
account_move_id = fields.Many2one('account.move', string='Account Move')
account_move_line_id = fields.Many2one('account.move.line', string='Account Move Line')
account_id = fields.Many2one('account.account', string='Account')
label = fields.Char(string='Label')
debit = fields.Float(string='Debit')
credit = fields.Float(string='Credit')
balance = fields.Float(string='Balance')
ongkir = fields.Float(string='Ongkir')
refund = fields.Float(string='Refund')
pph = fields.Float(string='PPh23')
others = fields.Float(string='Others')
linenetamt = fields.Float(string='Net Amount')
dpp = fields.Float(string='DPP')
status = fields.Char(string='Status')
|
