# -*- coding: utf-8 -*-
##############################################################################
#
-# Remembership module for OpenERP, Overload membership module
+# Remembership module for OpenERP, Membership module enhancement and bug fixes
# Copyright (C) 2012-2013 L'Heureux Cyclage (<http://www.heureux-cyclage.org>)
#
# This file is a part of Remembership
from dateutil.relativedelta import relativedelta
from openerp.tools.translate import _
+STATE = [
+ ('none', 'Non Member'),
+ ('canceled', 'Cancelled Member'),
+ ('old', 'Old Member'),
+ ('waiting', 'Waiting Member'),
+ ('invoiced', 'Invoiced Member'),
+ ('free', 'Free Member'),
+ ('paid', 'Paid Member'),
+]
class Partner(osv.osv):
_inherit = 'res.partner'
-
+
# XXX: copied from openerp/addons/membership/membership.py
def _membership_date(self, cr, uid, ids, name, args, context=None):
"""Return date of membership"""
print ("DEV: [_membership_date] [associate] date_from: %s" % str(res[partner.id]['membership_start']))
else:
print ("DEV: [_membership_date] date_from: %s" % str(res[partner.id]['membership_start']))
-
+
if name == 'membership_stop':
line_id1 = member_line_obj.search(cr, uid, [('partner', '=', partner_id),('date_cancel','=',False)],
limit=1, order='date_to desc', context=context)
print ("DEV: [_membership_date] [associate] date_to: %s" % str(res[partner.id]['membership_stop']))
else:
print ("DEV: [_membership_date] date_to: %s" % str(res[partner.id]['membership_stop']))
-
+
if name == 'membership_cancel':
if partner.membership_state == 'canceled':
line_id2 = member_line_obj.search(cr, uid, [('partner', '=', partner.id)], limit=1, order='date_cancel', context=context)
ids2 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
list_partner += ids2
return list_partner
-
+
+
+ def __get_membership_state(self, cr, uid, ids, name, args, context=None):
+ res = super(Partner, self).__get_membership_state(cr, uid, ids, name, args, context)
+ today = time.strftime('%Y-%m-%d')
+
+ # special case when the partner is imported from a file,
+ # in this case is has a valid membership line but
+ # no payment information associated to it, consider it valid
+ for id in ids:
+ if res[id] == 'none':
+
+ partner_data = self.browse(cr, uid, id, context=context)
+
+ no_payment_info_at_all = True
+ valid_line = False
+
+ for mline in partner_data.member_lines:
+ if mline.date_to >= today:
+ valid_line = True
+
+ if mline.account_invoice_line:
+ no_payment_info_at_all = False
+
+ if no_payment_info_at_all and valid_line:
+ res[id] = 'paid'
+
+ return res
+
+
+ def _get_partners(self, *args, **kwargs):
+ res = super(Partner, self.pool.get('res.partner'))._get_partners(*args, **kwargs)
+ return res
+
+
_columns = {
'member_ident': fields.char('Member identifier', size=64),
'associate_members': fields.one2many('res.partner', 'associate_member', 'Associate members', help='Members who are associated to this partner.'),
# XXX: copied from openerp/addons/membership/membership.py
+ 'membership_state': fields.function(
+ __get_membership_state,
+ string = 'Current Membership Status', type = 'selection',
+ selection = STATE,
+ store = {
+ 'account.invoice': (_get_invoice_partner, ['state'], 20),
+ 'membership.membership_line': (_get_partner_id, ['state'], 20),
+ 'res.partner': (_get_partners, ['free_member', 'membership_state', 'associate_member'], 20)
+ }, help="""It indicates the membership state.
+ -Non Member: A partner who has not applied for any membership.
+ -Cancelled Member: A member who has cancelled his membership.
+ -Old Member: A member whose membership date has expired.
+ -Waiting Member: A member who has applied for the membership and whose invoice is going to be created.
+ -Invoiced Member: A member whose invoice has been created.
+ -Paying member: A member who has paid the membership fee."""),
+ # XXX: copied from openerp/addons/membership/membership.py
'membership_start': fields.function(
_membership_date, multi = 'membership_start',
string = 'Membership Start Date', type = 'date',
'res.partner': (lambda self, cr, uid, ids, c={}: ids, ['free_member'], 10)
}, help="Date on which membership has been cancelled"),
}
-
+
_sql_constraints = [
('member_ident_uniq', 'unique(member_ident, company_id)', 'The member identifier must be unique !'),
]
-
+
def create_membership_invoice(self, cr, uid, ids, product_id=None, datas=None, context=None):
# NOTE: use context to supply date_from to account_invoice_line.create
context = context and context.copy() or {}
line_value = {
'product_id': product_id,
}
-
+
print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_line_obj] [product_id_change]" % (str(ids),str(partner.id)))
line_dict = invoice_line_obj.product_id_change(cr, uid, {},
product_id, False, quantity, '', 'out_invoice', partner.id, fpos_id, price_unit=amount, context=context)
if line_value.get('invoice_line_tax_id', False):
tax_tab = [(6, 0, line_value['invoice_line_tax_id'])]
line_value['invoice_line_tax_id'] = tax_tab
-
+
print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_obj] [create] account=%s" % (str(ids),str(partner.id),str(account_id)))
# NOTE: let account_invoice_obj.create() call account_invoice_line.create()
# to have a correct membership_state: becauce now fields.function 'store' watchdogs
print ("DEV: [remembership] [partner] [create_membership_invoice] return=%s" % str(invoice_list))
return invoice_list
+ def update_membership_status(self, cr, uid):
+ """Action for updating old members status with scheduled cron job"""
+ partner_obj = self.pool.get('res.partner')
+ today = date.today()
+ ids = partner_obj.search(cr, uid, [('membership_state', '=', 'paid'), ('membership_stop', '<', today)], context=None)
+ self.write(cr, uid, ids, {'membership_state': 'old'}, context=None)
+
Partner()
class Product(osv.osv):
_inherit = 'product.product'
-
+
_columns = {
'membership_grouped': fields.boolean('Grouped membership product', help='Check if it\'s a grouped membership product.'),
'membership_date2date': fields.boolean('Date to date membership product', required=False, help='Check if it\'s a date to date membership product.'),
class account_invoice_line(osv.osv):
_inherit = 'account.invoice.line'
-
+
def write(self, cr, uid, ids, vals, context=None):
member_line_obj = self.pool.get('membership.membership_line')
res = super(account_invoice_line, self).write(cr, uid, ids, vals, context=context)
and context.get('date_from')
and datetime.strptime(context('date_from'), "%Y-%m-%d")
or date.today())
- date_to = date_from + relativedelta(months = +12) # TODO: parameterize this delta?
+ date_to = date_from + relativedelta(months=+12, days=-1) # TODO: parameterize this delta?
date_from = date_from.strftime("%Y-%m-%d")
date_to = date_to .strftime("%Y-%m-%d")
print ("DEV: [remembership] [account_invoice_line] [write] date_from: %s" % str(date_from))
member_line_obj.unlink(cr, uid, ml_ids, context=context)
print ("DEV: [remembership] [account_invoice_line] [write] : return=%s" % str(res))
return res
-
+
def create(self, cr, uid, vals, context=None):
member_line_obj = self.pool.get('membership.membership_line')
res = super(account_invoice_line, self).create(cr, uid, vals, context=context)
print ("DEV: [remembership] [account_invoice_line] [create] : begin res=%s" % str(res))
line = self.browse(cr, uid, res, context=context)
-
+
if line.invoice_id.type == 'out_invoice' and line.product_id and line.product_id.membership:
member_line_id = member_line_obj.search(cr, uid
, [('partner' , '=', line.invoice_id.partner_id.id)
and context.get('date_from')
and datetime.strptime(context.get('date_from'), "%Y-%m-%d")
or date.today())
- date_to = date_from + relativedelta(days = +364) # TODO: parameterize this delta?
+ print("#DEBUG: Date de début - %s" % str(date_from))
+ date_to = date_from + relativedelta(months=+12, days=-1) # TODO: parameterize this delta?
date_from = date_from.strftime("%Y-%m-%d")
date_to = date_to .strftime("%Y-%m-%d")
print ("DEV: [remembership] [account_invoice_line] [create] date_from: %s" % str(date_from))