1 # -*- coding: utf-8 -*-
2 # Copyright 2012-2020 L'Heureux Cyclage
3 # License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl).
5 from openerp
.osv
import fields
, osv
7 from datetime
import datetime
, date
8 from dateutil
.relativedelta
import relativedelta
9 from openerp
.tools
.translate
import _
11 class Partner(osv
.osv
):
12 _inherit
= 'res.partner'
14 # XXX: copied from openerp/addons/membership/membership.py
15 def _membership_date(self
, cr
, uid
, ids
, name
, args
, context
=None):
16 """Return date of membership"""
19 member_line_obj
= self
.pool
.get('membership.membership_line')
20 print ("DEV: [remembership] [_membership_date]")
21 for partner
in self
.browse(cr
, uid
, ids
, context
=context
):
22 # XXX: commented part from openerp/addons/membership/membership.py
23 #if partner.associate_member:
24 # partner_id = partner.associate_member.id
26 # NOTE: hmm, ça devrait être toujours partner.id
27 partner_id
= partner
.id
29 'membership_start': False,
30 'membership_stop': False,
31 'membership_cancel': False
33 if name
== 'membership_start':
34 line_id
= member_line_obj
.search(cr
, uid
, [('partner', '=', partner_id
),('state','!=','canceled')],
35 limit
=1, order
='date_from', context
=context
)
37 res
[partner
.id]['membership_start'] = member_line_obj
.read(cr
, uid
, line_id
[0],
38 ['date_from'], context
=context
)['date_from']
39 if partner
.associate_member
:
40 print ("DEV: [_membership_date] [associate] date_from: %s" % str(res
[partner
.id]['membership_start']))
42 print ("DEV: [_membership_date] date_from: %s" % str(res
[partner
.id]['membership_start']))
44 if name
== 'membership_stop':
45 line_id1
= member_line_obj
.search(cr
, uid
, [('partner', '=', partner_id
),('state','!=','canceled')],
46 limit
=1, order
='date_to desc', context
=context
)
48 res
[partner
.id]['membership_stop'] = member_line_obj
.read(cr
, uid
, line_id1
[0],
49 ['date_to'], context
=context
)['date_to']
50 if partner
.associate_member
:
51 print ("DEV: [_membership_date] [associate] date_to: %s" % str(res
[partner
.id]['membership_stop']))
53 print ("DEV: [_membership_date] date_to: %s" % str(res
[partner
.id]['membership_stop']))
55 if name
== 'membership_cancel':
56 if partner
.membership_state
== 'canceled':
57 line_id2
= member_line_obj
.search(cr
, uid
, [('partner', '=', partner
.id)], limit
=1, order
='date_cancel', context
=context
)
59 res
[partner
.id]['membership_cancel'] = member_line_obj
.read(cr
, uid
, line_id2
[0], ['date_cancel'], context
=context
)['date_cancel']
61 # XXX: copied from openerp/addons/membership/membership.py
62 def _get_partner_id(self
, cr
, uid
, ids
, context
=None):
63 member_line_obj
= self
.pool
.get('membership.membership_line')
64 res_obj
= self
.pool
.get('res.partner')
65 data_inv
= member_line_obj
.browse(cr
, uid
, ids
, context
=context
)
68 list_partner
.append(data
.partner
.id)
71 ids2
= res_obj
.search(cr
, uid
, [('associate_member', 'in', ids2
)], context
=context
)
74 # XXX: copied from openerp/addons/membership/membership.py
75 def _get_invoice_partner(self
, cr
, uid
, ids
, context
=None):
76 inv_obj
= self
.pool
.get('account.invoice')
77 res_obj
= self
.pool
.get('res.partner')
78 data_inv
= inv_obj
.browse(cr
, uid
, ids
, context
=context
)
81 list_partner
.append(data
.partner_id
.id)
84 ids2
= res_obj
.search(cr
, uid
, [('associate_member', 'in', ids2
)], context
=context
)
89 'member_ident': fields
.char('Member identifier', size
=64),
90 'associate_members': fields
.one2many('res.partner', 'associate_member', 'Associate members', help='Members who are associated to this partner.'),
91 # XXX: copied from openerp/addons/membership/membership.py
92 'membership_start': fields
.function(
93 _membership_date
, multi
= 'membership_start',
94 string
= 'Membership Start Date', type = 'date',
96 'account.invoice': (_get_invoice_partner
, ['state'], 10),
97 'membership.membership_line': (_get_partner_id
, ['state'], 10, ),
98 'res.partner': (lambda self
, cr
, uid
, ids
, c
={}: ids
, ['free_member'], 10)
99 }, help="Date from which membership becomes active."),
100 # XXX: copied from openerp/addons/membership/membership.py
101 'membership_stop': fields
.function(
103 string
= 'Membership End Date', type='date', multi
='membership_stop',
105 'account.invoice': (_get_invoice_partner
, ['state'], 10),
106 'membership.membership_line': (_get_partner_id
, ['state'], 10),
107 'res.partner': (lambda self
, cr
, uid
, ids
, c
={}: ids
, ['free_member'], 10)
108 }, help="Date until which membership remains active."),
109 # XXX: copied from openerp/addons/membership/membership.py
110 'membership_cancel': fields
.function(
112 string
= 'Cancel Membership Date', type='date', multi
='membership_cancel',
114 'account.invoice': (_get_invoice_partner
, ['state'], 11),
115 'membership.membership_line': (_get_partner_id
, ['state'], 10),
116 'res.partner': (lambda self
, cr
, uid
, ids
, c
={}: ids
, ['free_member'], 10)
117 }, help="Date on which membership has been cancelled"),
121 ('member_ident_uniq', 'unique(member_ident, company_id)', 'The member identifier must be unique !'),
124 def create_membership_invoice(self
, cr
, uid
, ids
, product_id
=None, datas
=None, context
=None):
125 # NOTE: use context to supply date_from to account_invoice_line.create
126 context
= context
and context
.copy() or {}
127 context
.update({'date_from': datas
.get('date_from', None)});
128 # XXX: copied from openerp/addons/membership/membership.py to fix account_invoice_line creation
129 print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s" % str(ids
))
130 invoice_obj
= self
.pool
.get('account.invoice')
131 invoice_line_obj
= self
.pool
.get('account.invoice.line')
132 invoice_tax_obj
= self
.pool
.get('account.invoice.tax')
133 product_id
= product_id
or datas
.get('membership_product_id', False)
134 amount
= datas
.get('amount', 0.0)
136 if type(ids
) in (int, long,):
138 for partner
in self
.browse(cr
, uid
, ids
, context
=context
):
139 print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s" % (str(ids
),str(partner
.id)))
140 account_id
= partner
.property_account_receivable
and partner
.property_account_receivable
.id or False
141 fpos_id
= partner
.property_account_position
and partner
.property_account_position
.id or False
142 addr
= self
.address_get(cr
, uid
, [partner
.id], ['invoice'])
143 if partner
.free_member
:
144 raise osv
.except_osv(_('Error!'),
145 _("Partner is a free Member."))
146 if not addr
.get('invoice', False):
147 raise osv
.except_osv(_('Error!'),
148 _("Partner doesn't have an address to make the invoice."))
151 'product_id': product_id
,
154 print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_line_obj] [product_id_change]" % (str(ids
),str(partner
.id)))
155 line_dict
= invoice_line_obj
.product_id_change(cr
, uid
, {},
156 product_id
, False, quantity
, '', 'out_invoice', partner
.id, fpos_id
, price_unit
=amount
, context
=context
)
157 line_value
.update(line_dict
['value'])
158 line_value
['price_unit'] = amount
159 if line_value
.get('invoice_line_tax_id', False):
160 tax_tab
= [(6, 0, line_value
['invoice_line_tax_id'])]
161 line_value
['invoice_line_tax_id'] = tax_tab
163 print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_obj] [create] account=%s" % (str(ids
),str(partner
.id),str(account_id
)))
164 # NOTE: let account_invoice_obj.create() call account_invoice_line.create()
165 # to have a correct membership_state: becauce now fields.function 'store' watchdogs
166 # are triggered after account_invoice_line.create().
167 invoice_id
= invoice_obj
.create(cr
, uid
, {
168 'partner_id': partner
.id,
169 'account_id': account_id
,
170 'fiscal_position': fpos_id
or False,
171 'invoice_line':[(0, 0, line_value
)]
173 #line_value['invoice_id'] = invoice_id
174 #print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_line_obj] [create]" % (str(ids),str(partner.id)))
175 #invoice_line_id = invoice_line_obj.create(cr, uid, line_value, context=context)
176 #invoice_obj.write(cr, uid, invoice_id, {'invoice_line': line_value}, context=context)
177 print ("DEV: [remembership] [partner] [create_membership_invoice] : invoice_list.append(invoice_id) : pre")
178 invoice_list
.append(invoice_id
)
179 print ("DEV: [remembership] [partner] [create_membership_invoice] : invoice_list.append(invoice_id) : post")
180 if line_value
['invoice_line_tax_id']:
181 tax_value
= invoice_tax_obj
.compute(cr
, uid
, invoice_id
).values()
182 for tax
in tax_value
:
183 invoice_tax_obj
.create(cr
, uid
, tax
, context
=context
)
184 # NOTE: this wasn't working, and is not needed now.
185 #recompute the membership_state of those partners
186 #print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s [recompute states]" % str(ids))
187 #self.pool.get('res.partner').write(cr, uid, ids, {}, context=context)
188 print ("DEV: [remembership] [partner] [create_membership_invoice] return=%s" % str(invoice_list
))
191 def update_membership_status(self
, cr
, uid
):
192 """Action for updating old members status with scheduled cron job"""
193 partner_obj
= self
.pool
.get('res.partner')
195 ids
= partner_obj
.search(cr
, uid
, [('membership_state', '=', 'paid'), ('membership_stop', '<', today
)], context
=None)
196 self
.write(cr
, uid
, ids
, {'membership_state': 'old'}, context
=None)
198 def copy(self
, cr
, uid
, id, default
=None, context
=None):
201 default
['member_ident'] = None
202 return super(Partner
, self
).copy(cr
, uid
, id, default
, context
)
208 class Product(osv
.osv
):
209 _inherit
= 'product.template'
212 'membership_grouped': fields
.boolean('Grouped membership product', help='Check if it\'s a grouped membership product.'),
213 'membership_date2date': fields
.boolean('Date to date membership product', required
=False, help='Check if it\'s a date to date membership product.'),
219 class account_invoice_line(osv
.osv
):
220 _inherit
= 'account.invoice.line'
222 def write(self
, cr
, uid
, ids
, vals
, context
=None):
223 member_line_obj
= self
.pool
.get('membership.membership_line')
224 res
= super(account_invoice_line
, self
).write(cr
, uid
, ids
, vals
, context
=context
)
225 for line
in self
.browse(cr
, uid
, ids
, context
=context
):
226 if line
.invoice_id
.type == 'out_invoice':
227 ml_ids
= member_line_obj
.search(cr
, uid
, [('account_invoice_line', '=', line
.id)], context
=context
)
228 if line
.product_id
and line
.product_id
.membership
:
229 member_line_id
= member_line_obj
.search(cr
, uid
230 , [('partner' , '=', line
.invoice_id
.partner_id
.id)
231 ,('account_invoice_line', '=', line
.id)]
234 for member_line
in member_line_obj
.browse(cr
, uid
, member_line_id
, context
=context
):
235 # NOTE: get member_line created in membership.account_invoice_line.create
236 date_from
= member_line
.date_from
237 date_to
= member_line
.date_to
238 if line
.product_id
.membership_date2date
:
239 date_from
= ('date_from' in context
240 and context
.get('date_from')
241 and datetime
.strptime(context('date_from'), "%Y-%m-%d")
243 date_to
= date_from
+ relativedelta(months
=+12, days
=-1) # TODO: parameterize this delta?
244 date_from
= date_from
.strftime("%Y-%m-%d")
245 date_to
= date_to
.strftime("%Y-%m-%d")
246 print ("DEV: [remembership] [account_invoice_line] [write] date_from: %s" % str(date_from
))
247 print ("DEV: [remembership] [account_invoice_line] [write] date_to : %s" % str(date_to
))
248 member_line_obj
.write(cr
, uid
, member_line
.id
249 , {'date_from': date_from
253 if line
.product_id
.membership_grouped
:
254 if line
.invoice_id
.partner_id
.associate_members
:
255 associate_member_line_ids
= member_line_obj
.search(cr
, uid
256 , [ ('account_invoice_line', '=', line
.id)
257 , ('partner', '!=', line
.invoice_id
.partner_id
.id)
260 for associate_member_line
in member_line_obj
.browse(cr
, uid
, associate_member_line_ids
, context
=context
):
261 print ("DEV: [remembership] [account_invoice_line] [write] [associate] date_from: %s" % str(date_from
))
262 print ("DEV: [remembership] [account_invoice_line] [write] [associate] date_to : %s" % str(date_to
))
263 member_line_obj
.write(cr
, uid
, associate_member_line
.id
264 , {'date_from': date_from
269 print("DEV: mettre une contrainte pour l'objet\
270 membership.membership_line interdisant les\
271 adhésions groupées reliées à des partenaires\
272 sans membres associés")
274 associate_member_line_ids
= member_line_obj
.search(cr
, uid
275 , [ ('account_invoice_line', '=', line
.id)
276 , ('partner', '!=', line
.invoice_id
.partner_id
.id)
279 member_line_obj
.unlink(cr
, uid
, associate_member_line_ids
, context
=context
)
280 #Define member ident if it's necessary
281 partners
= [line
.invoice_id
.partner_id
]
282 if line
.invoice_id
.partner_id
.associate_members
:
283 partners
.extend(line
.invoice_id
.partner_id
.associate_members
)
285 if not i
.member_ident
:
286 mbr_id
= self
.pool
.get('ir.sequence').get(cr
, uid
, 'member_ident')
287 self
.pool
.get('res.partner').write(cr
, uid
, i
.id, {'member_ident': mbr_id
})
288 if line
.product_id
and not line
.product_id
.membership
and ml_ids
:
289 # Product line has changed to a non membership product
290 member_line_obj
.unlink(cr
, uid
, ml_ids
, context
=context
)
291 print ("DEV: [remembership] [account_invoice_line] [write] : return=%s" % str(res
))
294 def create(self
, cr
, uid
, vals
, context
=None):
295 member_line_obj
= self
.pool
.get('membership.membership_line')
296 res
= super(account_invoice_line
, self
).create(cr
, uid
, vals
, context
=context
)
297 print ("DEV: [remembership] [account_invoice_line] [create] : begin res=%s" % str(res
))
298 line
= self
.browse(cr
, uid
, res
, context
=context
)
300 if line
.invoice_id
.type == 'out_invoice' and line
.product_id
and line
.product_id
.membership
:
301 member_line_id
= member_line_obj
.search(cr
, uid
302 , [('partner' , '=', line
.invoice_id
.partner_id
.id)
303 ,('account_invoice_line', '=', line
.id)]
306 for member_line
in member_line_obj
.browse(cr
, uid
, member_line_id
, context
=context
):
307 # NOTE: get member_line created in membership.account_invoice_line.create
308 date_from
= member_line
.date_from
309 date_to
= member_line
.date_to
310 if line
.product_id
.membership_date2date
:
311 date_from
= ('date_from' in context
312 and context
.get('date_from')
313 and datetime
.strptime(context
.get('date_from'), "%Y-%m-%d")
315 print("#DEBUG: Date de début - %s" % str(date_from
))
316 date_to
= date_from
+ relativedelta(months
=+12, days
=-1) # TODO: parameterize this delta?
317 date_from
= date_from
.strftime("%Y-%m-%d")
318 date_to
= date_to
.strftime("%Y-%m-%d")
319 print ("DEV: [remembership] [account_invoice_line] [create] date_from: %s" % str(date_from
))
320 print ("DEV: [remembership] [account_invoice_line] [create] date_to : %s" % str(date_to
))
321 member_line_obj
.write(cr
, uid
, member_line
.id
322 , {'date_from': date_from
326 partners
= [line
.invoice_id
.partner_id
]
327 if line
.product_id
.membership_grouped
and line
.invoice_id
.partner_id
.associate_members
:
328 partners
.extend(line
.invoice_id
.partner_id
.associate_members
)
329 #Adding membership lines just for associate partners
330 for associate_member
in line
.invoice_id
.partner_id
.associate_members
:
331 print ("DEV: [remembership] [account_invoice_line] [create] [associate] date_from: %s" % str(date_from
))
332 print ("DEV: [remembership] [account_invoice_line] [create] [associate] date_to : %s" % str(date_to
))
333 member_line_obj
.create(cr
, uid
, {
334 'partner': associate_member
.id,
335 'membership_id': line
.product_id
.id,
336 'member_price': line
.price_unit
,
337 'date': time
.strftime('%Y-%m-%d'),
338 'date_from': date_from
,
340 'account_invoice_line': line
.id,
342 elif line
.product_id
.membership_grouped
and not line
.invoice_id
.partner_id
.associate_members
:
343 raise osv
.except_osv(_('Error!!!'), _('You try to invoice grouped membership product to a partner who hasn\'t associated partners.'))
344 #Define member ident if it's necessary
346 if not i
.member_ident
:
347 mbr_id
= self
.pool
.get('ir.sequence').get(cr
, uid
, 'member_ident')
348 self
.pool
.get('res.partner').write(cr
, uid
, i
.id, {'member_ident': mbr_id
})
349 print ("DEV: [remembership] [account_invoice_line] [create] : return=%s" % str(res
))
352 account_invoice_line()
353 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: