#
##############################################################################
-from osv import fields, osv
-from tools import config
import time
+from osv import fields, osv
import decimal_precision as dp
-
+from tools.translate import _
STATE = [
('none', 'Non Member'),
]
STATE_PRIOR = {
- 'none' : 0,
- 'canceled' : 1,
- 'old' : 2,
- 'waiting' : 3,
- 'invoiced' : 4,
- 'free' : 6,
- 'paid' : 7
- }
-
-#~ REQUETE = '''SELECT partner, state FROM (
-#~ SELECT members.partner AS partner,
-#~ CASE WHEN MAX(members.state) = 0 THEN 'none'
-#~ ELSE CASE WHEN MAX(members.state) = 1 THEN 'canceled'
-#~ ELSE CASE WHEN MAX(members.state) = 2 THEN 'old'
-#~ ELSE CASE WHEN MAX(members.state) = 3 THEN 'waiting'
-#~ ELSE CASE WHEN MAX(members.state) = 4 THEN 'invoiced'
-#~ ELSE CASE WHEN MAX(members.state) = 6 THEN 'free'
-#~ ELSE CASE WHEN MAX(members.state) = 7 THEN 'paid'
-#~ END END END END END END END END
- #~ AS state FROM (
-#~ SELECT partner,
- #~ CASE WHEN MAX(inv_digit.state) = 4 THEN 7
- #~ ELSE CASE WHEN MAX(inv_digit.state) = 3 THEN 4
- #~ ELSE CASE WHEN MAX(inv_digit.state) = 2 THEN 3
- #~ ELSE CASE WHEN MAX(inv_digit.state) = 1 THEN 1
-#~ END END END END
-#~ AS state
-#~ FROM (
- #~ SELECT p.id as partner,
- #~ CASE WHEN ai.state = 'paid' THEN 4
- #~ ELSE CASE WHEN ai.state = 'open' THEN 3
- #~ ELSE CASE WHEN ai.state = 'proforma' THEN 2
- #~ ELSE CASE WHEN ai.state = 'draft' THEN 2
- #~ ELSE CASE WHEN ai.state = 'cancel' THEN 1
-#~ END END END END END
-#~ AS state
-#~ FROM res_partner p
-#~ JOIN account_invoice ai ON (
- #~ p.id = ai.partner_id
-#~ )
-#~ JOIN account_invoice_line ail ON (
- #~ ail.invoice_id = ai.id
-#~ )
-#~ JOIN membership_membership_line ml ON (
- #~ ml.account_invoice_line = ail.id
-#~ )
-#~ WHERE ml.date_from <= '%s'
-#~ AND ml.date_to >= '%s'
-#~ GROUP BY
-#~ p.id,
-#~ ai.state
- #~ )
- #~ AS inv_digit
- #~ GROUP by partner
-#~ UNION
-#~ SELECT p.id AS partner,
- #~ CASE WHEN p.free_member THEN 6
- #~ ELSE CASE WHEN p.associate_member IN (
- #~ SELECT ai.partner_id FROM account_invoice ai JOIN
- #~ account_invoice_line ail ON (ail.invoice_id = ai.id AND ai.state = 'paid')
- #~ JOIN membership_membership_line ml ON (ml.account_invoice_line = ail.id)
- #~ WHERE ml.date_from <= '%s'
- #~ AND ml.date_to >= '%s'
- #~ )
- #~ THEN 5
-#~ END END
-#~ AS state
-#~ FROM res_partner p
-#~ WHERE p.free_member
-#~ OR p.associate_member > 0
-#~ UNION
-#~ SELECT p.id as partner,
- #~ MAX(CASE WHEN ai.state = 'paid' THEN 2
- #~ ELSE 0
- #~ END)
-#~ AS state
-#~ FROM res_partner p
-#~ JOIN account_invoice ai ON (
- #~ p.id = ai.partner_id
-#~ )
-#~ JOIN account_invoice_line ail ON (
- #~ ail.invoice_id = ai.id
-#~ )
-#~ JOIN membership_membership_line ml ON (
- #~ ml.account_invoice_line = ail.id
-#~ )
-#~ WHERE ml.date_from < '%s'
-#~ AND ml.date_to < '%s'
-#~ AND ml.date_from <= ml.date_to
-#~ GROUP BY
-#~ p.id
-#~ )
-#~ AS members
-#~ GROUP BY members.partner
-#~ )
-#~ AS final
-#~ %s
-#~ '''
+ 'none': 0,
+ 'canceled': 1,
+ 'old': 2,
+ 'waiting': 3,
+ 'invoiced': 4,
+ 'free': 6,
+ 'paid': 7
+}
class membership_line(osv.osv):
'''Member line'''
+ def _get_partners(self, cr, uid, ids, context=None):
+ list_membership_line = []
+ member_line_obj = self.pool.get('membership.membership_line')
+ for partner in self.pool.get('res.partner').browse(cr, uid, ids, context=context):
+ if partner.member_lines:
+ list_membership_line += member_line_obj.search(cr, uid, [('id', 'in', [ l.id for l in partner.member_lines])], context=context)
+ return list_membership_line
+
+ def _get_membership_lines(self, cr, uid, ids, context=None):
+ list_membership_line = []
+ member_line_obj = self.pool.get('membership.membership_line')
+ for invoice in self.pool.get('account.invoice').browse(cr, uid, ids, context=context):
+ if invoice.invoice_line:
+ list_membership_line += member_line_obj.search(cr, uid, [('account_invoice_line', 'in', [ l.id for l in invoice.invoice_line])], context=context)
+ return list_membership_line
+
def _check_membership_date(self, cr, uid, ids, context=None):
- '''Check if membership product is not in the past'''
+ """Check if membership product is not in the past
+ @param self: The object pointer
+ @param cr: the current row, from the database cursor,
+ @param uid: the current user’s ID for security checks,
+ @param ids: List of Membership Line IDs
+ @param context: A standard dictionary for contextual values
+ """
cr.execute('''
SELECT MIN(ml.date_to - ai.date_invoice)
- FROM membership_membership_line ml
- JOIN account_invoice_line ail ON (
- ml.account_invoice_line = ail.id
- )
- JOIN account_invoice ai ON (
+ FROM membership_membership_line ml
+ JOIN account_invoice_line ail ON (
+ ml.account_invoice_line = ail.id
+ )
+ JOIN account_invoice ai ON (
ai.id = ail.invoice_id)
- WHERE ml.id =ANY(%s)''',(ids,))
+ WHERE ml.id IN %s''', (tuple(ids),))
res = cr.fetchall()
for r in res:
if r[0] and r[0] < 0:
return True
def _state(self, cr, uid, ids, name, args, context=None):
- '''Compute the state lines'''
+ """Compute the state lines
+ @param self: The object pointer
+ @param cr: the current row, from the database cursor,
+ @param uid: the current user’s ID for security checks,
+ @param ids: List of Membership Line IDs
+ @param name: Field Name
+ @param context: A standard dictionary for contextual values
+ @param return: Dictionary of state Value
+ """
res = {}
- for line in self.browse(cr, uid, ids):
+ inv_obj = self.pool.get('account.invoice')
+ for line in self.browse(cr, uid, ids, context=context):
cr.execute('''
- SELECT i.state FROM
- account_invoice i WHERE
+ SELECT i.state, i.id FROM
+ account_invoice i
+ WHERE
i.id = (
SELECT l.invoice_id FROM
account_invoice_line l WHERE
)
''', (line.id,))
fetched = cr.fetchone()
- if not fetched :
+ if not fetched:
res[line.id] = 'canceled'
continue
istate = fetched[0]
state = 'invoiced'
elif istate == 'paid':
state = 'paid'
+ inv = inv_obj.browse(cr, uid, fetched[1], context=context)
+ for payment in inv.payment_ids:
+ if payment.invoice and payment.invoice.type == 'out_refund':
+ state = 'canceled'
elif istate == 'cancel':
state = 'canceled'
res[line.id] = state
_description = __doc__
_name = 'membership.membership_line'
_columns = {
- 'partner': fields.many2one('res.partner', 'Partner', ondelete='cascade', select=1),
- 'date_from': fields.date('From'),
- 'date_to': fields.date('To'),
- 'date_cancel' : fields.date('Cancel date'),
- 'account_invoice_line': fields.many2one('account.invoice.line', 'Account Invoice line'),
- 'state': fields.function(_state, method=True, string='State', type='selection', selection=STATE),
- }
+ 'partner': fields.many2one('res.partner', 'Partner', ondelete='cascade', select=1),
+ 'membership_id': fields.many2one('product.product', string="Membership Product", required=True),
+ 'date_from': fields.date('From', readonly=True),
+ 'date_to': fields.date('To', readonly=True),
+ 'date_cancel': fields.date('Cancel date'),
+ 'date': fields.date('Join Date', help="Date on which member has joined the membership"),
+ 'member_price': fields.float('Member Price', digits_compute= dp.get_precision('Sale Price'), required=True, help='Amount for the membership'),
+ 'account_invoice_line': fields.many2one('account.invoice.line', 'Account Invoice line', readonly=True),
+ 'account_invoice_id': fields.related('account_invoice_line', 'invoice_id', type='many2one', relation='account.invoice', string='Invoice', readonly=True),
+ 'state': fields.function(_state,
+ string='Membership State', type='selection',
+ selection=STATE, store = {
+ 'account.invoice': (_get_membership_lines, ['state'], 10),
+ 'res.partner': (_get_partners, ['membership_state'], 12),
+ }, help="""It indicates the membership state.
+ -Non Member: A member 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.
+ -Paid Member: A member who has paid the membership amount."""),
+ 'company_id': fields.related('account_invoice_line', 'invoice_id', 'company_id', type="many2one", relation="res.company", string="Company", readonly=True, store=True)
+ }
_rec_name = 'partner'
_order = 'id desc'
_constraints = [
- (_check_membership_date, 'Error, this membership product is out of date', [])
+ (_check_membership_date, 'Error, this membership product is out of date', [])
]
membership_line()
_inherit = 'res.partner'
def _get_partner_id(self, cr, uid, ids, context=None):
- data_inv = self.pool.get('membership.membership_line').browse(cr, uid, ids, context)
+ member_line_obj = self.pool.get('membership.membership_line')
+ res_obj = self.pool.get('res.partner')
+ data_inv = member_line_obj.browse(cr, uid, ids, context=context)
list_partner = []
for data in data_inv:
list_partner.append(data.partner.id)
ids2 = list_partner
while ids2:
- ids2 = self.pool.get('res.partner').search(cr, uid, [('associate_member','in',ids2)], context=context)
+ ids2 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
list_partner += ids2
return list_partner
def _get_invoice_partner(self, cr, uid, ids, context=None):
- data_inv = self.pool.get('account.invoice').browse(cr, uid, ids, context)
+ inv_obj = self.pool.get('account.invoice')
+ res_obj = self.pool.get('res.partner')
+ data_inv = inv_obj.browse(cr, uid, ids, context=context)
list_partner = []
for data in data_inv:
list_partner.append(data.partner_id.id)
ids2 = list_partner
while ids2:
- ids2 = self.pool.get('res.partner').search(cr, uid, [('associate_member','in',ids2)], context=context)
+ ids2 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
list_partner += ids2
return list_partner
def _membership_state(self, cr, uid, ids, name, args, context=None):
+ """This Function return Membership State For Given Partner.
+ @param self: The object pointer
+ @param cr: the current row, from the database cursor,
+ @param uid: the current user’s ID for security checks,
+ @param ids: List of Partner IDs
+ @param name: Field Name
+ @param context: A standard dictionary for contextual values
+ @param return: Dictionary of Membership state Value
+ """
res = {}
for id in ids:
res[id] = 'none'
today = time.strftime('%Y-%m-%d')
for id in ids:
- partner_data = self.browse(cr,uid,id)
+ partner_data = self.browse(cr, uid, id, context=context)
if partner_data.membership_cancel and today > partner_data.membership_cancel:
res[id] = 'canceled'
continue
mstate = mline.account_invoice_line.invoice_id.state
if mstate == 'paid':
s = 0
+ inv = mline.account_invoice_line.invoice_id
+ for payment in inv.payment_ids:
+ if payment.invoice.type == 'out_refund':
+ s = 2
break
elif mstate == 'open' and s!=0:
s = 1
s = 3
if s==4:
for mline in partner_data.member_lines:
- if mline.date_from < today and mline.date_to < today and mline.date_from<=mline.date_to and (mline.account_invoice_line and mline.account_invoice_line.invoice_id.state) == 'paid':
+ if mline.date_from < today and mline.date_to < today and mline.date_from <= mline.date_to and (mline.account_invoice_line and mline.account_invoice_line.invoice_id.state) == 'paid':
s = 5
else:
s = 6
if partner_data.free_member and s!=0:
res[id] = 'free'
if partner_data.associate_member:
- res_state = self._membership_state(cr, uid, [partner_data.associate_member.id], name, args, context)
+ res_state = self._membership_state(cr, uid, [partner_data.associate_member.id], name, args, context=context)
res[id] = res_state[partner_data.associate_member.id]
return res
- def _membership_start(self, cr, uid, ids, name, args, context=None):
- '''Return the start date of membership'''
+ def _membership_date(self, cr, uid, ids, name, args, context=None):
+ """Return date of membership"""
+ name = name[0]
res = {}
member_line_obj = self.pool.get('membership.membership_line')
- for partner in self.browse(cr, uid, ids):
- if partner.associate_member:
- partner_id = partner.associate_member.id
- else:
- partner_id = partner.id
- line_id = member_line_obj.search(cr, uid, [('partner', '=', partner_id)],
- limit=1, order='date_from')
- if line_id:
- res[partner.id] = member_line_obj.read(cr, uid, line_id[0],
- ['date_from'])['date_from']
- else:
- res[partner.id] = False
- return res
-
- def _membership_stop(self, cr, uid, ids, name, args, context=None):
- '''Return the stop date of membership'''
- res = {}
- member_line_obj = self.pool.get('membership.membership_line')
- for partner in self.browse(cr, uid, ids):
- cr.execute('select membership_state from res_partner where id=%s', (partner.id,))
- data_state = cr.fetchall()
+ for partner in self.browse(cr, uid, ids, context=context):
if partner.associate_member:
- partner_id = partner.associate_member.id
+ partner_id = partner.associate_member.id
else:
- partner_id = partner.id
- line_id = member_line_obj.search(cr, uid, [('partner', '=', partner_id)],
- limit=1, order='date_to desc')
- if line_id:
- res[partner.id] = member_line_obj.read(cr, uid, line_id[0],
- ['date_to'])['date_to']
- else:
- res[partner.id] = False
- return res
-
- def _membership_cancel(self, cr, uid, ids, name, args, context=None):
- '''Return the cancel date of membership'''
- res = {}
- member_line_obj = self.pool.get('membership.membership_line')
- for partner in self.browse(cr, uid, ids, context=context):
- res[partner.id] = False
- if partner.membership_state == 'canceled':
- line_id = member_line_obj.search(cr, uid, [('partner', '=', partner.id)],limit=1, order='date_cancel')
+ partner_id = partner.id
+ res[partner.id] = {
+ 'membership_start': False,
+ 'membership_stop': False,
+ 'membership_cancel': False
+ }
+ if name == 'membership_start':
+ line_id = member_line_obj.search(cr, uid, [('partner', '=', partner_id),('date_cancel','=',False)],
+ limit=1, order='date_from', context=context)
if line_id:
- res[partner.id] = member_line_obj.read(cr, uid, line_id[0],['date_cancel'])['date_cancel']
+ res[partner.id]['membership_start'] = member_line_obj.read(cr, uid, line_id[0],
+ ['date_from'], context=context)['date_from']
+
+ 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)
+ if line_id1:
+ res[partner.id]['membership_stop'] = member_line_obj.read(cr, uid, line_id1[0],
+ ['date_to'], context=context)['date_to']
+
+ 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)
+ if line_id2:
+ res[partner.id]['membership_cancel'] = member_line_obj.read(cr, uid, line_id2[0], ['date_cancel'], context=context)['date_cancel']
return res
- def _get_partners(self, cr, uid, ids, context={}):
+ def _get_partners(self, cr, uid, ids, context=None):
ids2 = ids
while ids2:
- ids2 = self.search(cr, uid, [('associate_member','in',ids2)], context=context)
- ids+=ids2
+ ids2 = self.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
+ ids += ids2
return ids
+ def __get_membership_state(self, *args, **kwargs):
+ return self._membership_state(*args, **kwargs)
+
_columns = {
- 'associate_member': fields.many2one('res.partner', 'Associate member'),
+ 'associate_member': fields.many2one('res.partner', 'Associate member',help="A member with whom you want to associate your membership.It will consider the membership state of the associated member."),
'member_lines': fields.one2many('membership.membership_line', 'partner', 'Membership'),
- 'free_member': fields.boolean('Free member'),
+ 'free_member': fields.boolean('Free member', help = "Select if you want to give membership free of cost."),
'membership_amount': fields.float(
'Membership amount', digits=(16, 2),
- help='The price negociated by the partner'),
+ help = 'The price negotiated by the partner'),
'membership_state': fields.function(
- _membership_state, method = True,
- string = 'Current membership state', type = 'selection',
- selection = STATE ,store = {
- 'account.invoice':(_get_invoice_partner,['state'], 10),
- 'membership.membership_line':(_get_partner_id,['state'], 10),
- 'res.partner':(_get_partners, ['free_member', 'membership_state','associate_member'], 10)
- }
- ),
+ __get_membership_state,
+ string = 'Current Membership State', type = 'selection',
+ selection = STATE,
+ store = {
+ 'account.invoice': (_get_invoice_partner, ['state'], 10),
+ 'membership.membership_line': (_get_partner_id, ['state'], 10),
+ 'res.partner': (_get_partners, ['free_member', 'membership_state', 'associate_member'], 10)
+ }, help="""It indicates the membership state.
+ -Non Member: A member 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.
+ -Paid Member: A member who has paid the membership amount."""),
'membership_start': fields.function(
- _membership_start, method=True,
+ _membership_date, multi = 'membeship_start',
string = 'Start membership date', type = 'date',
store = {
- 'account.invoice':(_get_invoice_partner,['state'], 10),
- 'membership.membership_line':(_get_partner_id,['state'], 10),
- 'res.partner':(lambda self,cr,uid,ids,c={}:ids, ['free_member'], 10)
- }
- ),
+ 'account.invoice': (_get_invoice_partner, ['state'], 10),
+ 'membership.membership_line': (_get_partner_id, ['state'], 10, ),
+ 'res.partner': (lambda self, cr, uid, ids, c={}: ids, ['free_member'], 10)
+ }, help="Date from which membership becomes active."),
'membership_stop': fields.function(
- _membership_stop, method = True,
- string = 'Stop membership date', type = 'date',
+ _membership_date,
+ string = 'Stop membership date', type='date', multi='membership_stop',
store = {
- 'account.invoice':(_get_invoice_partner,['state'], 10),
- 'membership.membership_line':(_get_partner_id,['state'], 10),
- 'res.partner':(lambda self,cr,uid,ids,c={}:ids, ['free_member'], 10)
- }
- ),
-
+ 'account.invoice': (_get_invoice_partner, ['state'], 10),
+ 'membership.membership_line': (_get_partner_id, ['state'], 10),
+ 'res.partner': (lambda self, cr, uid, ids, c={}: ids, ['free_member'], 10)
+ }, help="Date until which membership remains active."),
'membership_cancel': fields.function(
- _membership_cancel, method = True,
- string = 'Cancel membership date', type='date',
+ _membership_date,
+ string = 'Cancel membership date', type='date', multi='membership_cancel',
store = {
- 'account.invoice':(_get_invoice_partner,['state'], 11),
- 'membership.membership_line':(_get_partner_id,['state'], 10),
- 'res.partner':(lambda self,cr,uid,ids,c={}:ids, ['free_member'], 10)
- }
- ),
+ 'account.invoice': (_get_invoice_partner, ['state'], 11),
+ 'membership.membership_line': (_get_partner_id, ['state'], 10),
+ 'res.partner': (lambda self, cr, uid, ids, c={}: ids, ['free_member'], 10)
+ }, help="Date on which membership has been cancelled"),
}
_defaults = {
- 'free_member': lambda *a: False,
- 'membership_cancel' : lambda *d : False,
+ 'free_member': False,
+ 'membership_cancel': False,
}
- def _check_recursion(self, cr, uid, ids):
+ def _check_recursion(self, cr, uid, ids, context=None):
+ """Check Recursive for Associated Members.
+ """
level = 100
while len(ids):
- cr.execute('select distinct associate_member from res_partner where id =ANY(%s)',(ids,))
+ cr.execute('SELECT DISTINCT associate_member FROM res_partner WHERE id IN %s', (tuple(ids),))
ids = filter(None, map(lambda x:x[0], cr.fetchall()))
if not level:
return False
return True
_constraints = [
- (_check_recursion, 'Error ! You can not create recursive associated members.', ['associate_member'])
+ (_check_recursion, 'Error ! You cannot create recursive associated members.', ['associate_member'])
]
-
+
def copy(self, cr, uid, id, default=None, context=None):
if default is None:
default = {}
- if context is None:
- context = {}
default = default.copy()
default['member_lines'] = []
- return super(Partner, self).copy(cr, uid, id, default, context)
-
+ return super(Partner, self).copy(cr, uid, id, default, context=context)
+
+ def create_membership_invoice(self, cr, uid, ids, product_id=None, datas=None, context=None):
+ """ Create Customer Invoice of Membership for partners.
+ @param datas: datas has dictionary value which consist Id of Membership product and Cost Amount of Membership.
+ datas = {'membership_product_id': None, 'amount': None}
+ """
+ invoice_obj = self.pool.get('account.invoice')
+ invoice_line_obj = self.pool.get('account.invoice.line')
+ invoice_tax_obj = self.pool.get('account.invoice.tax')
+ product_id = product_id or datas.get('membership_product_id', False)
+ amount = datas.get('amount', 0.0)
+ invoice_list = []
+ if type(ids) in (int, long,):
+ ids = [ids]
+ for partner in self.browse(cr, uid, ids, context=context):
+ account_id = partner.property_account_receivable and partner.property_account_receivable.id or False
+ fpos_id = partner.property_account_position and partner.property_account_position.id or False
+ addr = self.address_get(cr, uid, [partner.id], ['invoice'])
+ if partner.free_member:
+ raise osv.except_osv(_('Error !'),
+ _("Partner is a free Member."))
+ if not addr.get('invoice', False):
+ raise osv.except_osv(_('Error !'),
+ _("Partner doesn't have an address to make the invoice."))
+ quantity = 1
+ line_value = {
+ 'product_id': product_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)
+ line_value.update(line_dict['value'])
+ line_value['price_unit'] = amount
+ 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
+
+ invoice_id = invoice_obj.create(cr, uid, {
+ 'partner_id': partner.id,
+ 'address_invoice_id': addr.get('invoice', False),
+ 'account_id': account_id,
+ 'fiscal_position': fpos_id or False
+ }, context=context)
+ line_value['invoice_id'] = invoice_id
+ invoice_line_id = invoice_line_obj.create(cr, uid, line_value, context=context)
+ invoice_obj.write(cr, uid, invoice_id, {'invoice_line': [(6, 0, [invoice_line_id])]}, context=context)
+ invoice_list.append(invoice_id)
+ if line_value['invoice_line_tax_id']:
+ tax_value = invoice_tax_obj.compute(cr, uid, invoice_id).values()
+ for tax in tax_value:
+ invoice_tax_obj.create(cr, uid, tax, context=context)
+ #recompute the membership_state of those partners
+ self.pool.get('res.partner').write(cr, uid, ids, {})
+ return invoice_list
+
Partner()
class product_template(osv.osv):
_inherit = 'product.template'
_columns = {
- 'member_price':fields.float('Member Price', digits_compute= dp.get_precision('Sale Price')),
- }
+ 'member_price': fields.float('Member Price', digits_compute= dp.get_precision('Sale Price')),
+ }
+
product_template()
class Product(osv.osv):
def fields_view_get(self, cr, user, view_id=None, view_type='form', context=None, toolbar=False, submenu=False):
+ model_obj = self.pool.get('ir.model.data')
+ if context is None:
+ context = {}
+
if ('product' in context) and (context['product']=='membership_product'):
- model_data_ids_form = self.pool.get('ir.model.data').search(cr,user,[('model','=','ir.ui.view'),('name','in',['membership_products_form','membership_products_tree'])])
- resource_id_form = self.pool.get('ir.model.data').read(cr,user,model_data_ids_form,fields=['res_id','name'])
- dict_model={}
+ model_data_ids_form = model_obj.search(cr, user, [('model','=','ir.ui.view'), ('name', 'in', ['membership_products_form', 'membership_products_tree'])], context=context)
+ resource_id_form = model_obj.read(cr, user, model_data_ids_form, fields=['res_id', 'name'], context=context)
+ dict_model = {}
for i in resource_id_form:
- dict_model[i['name']]=i['res_id']
- if view_type=='form':
+ dict_model[i['name']] = i['res_id']
+ if view_type == 'form':
view_id = dict_model['membership_products_form']
else:
view_id = dict_model['membership_products_tree']
'''Product'''
_inherit = 'product.product'
- _description = 'product.product'
-
_columns = {
- 'membership': fields.boolean('Membership', help='Specify if this product is a membership product'),
- 'membership_date_from': fields.date('Date from'),
- 'membership_date_to': fields.date('Date to'),
-# 'member_price':fields.float('Member Price'),
- }
+ 'membership': fields.boolean('Membership', help='Select if a product is a membership product.'),
+ 'membership_date_from': fields.date('Date from', help='Date from which membership becomes active.'),
+ 'membership_date_to': fields.date('Date to', help='Date until which membership remains active.'),
+ }
_defaults = {
- 'membership': lambda *args: False
- }
+ 'membership': False,
+ }
+
Product()
class Invoice(osv.osv):
'''Invoice'''
-
_inherit = 'account.invoice'
- def action_cancel(self, cr, uid, ids, context=None):
+ def action_cancel(self, cr, uid, ids, *args):
'''Create a 'date_cancel' on the membership_line object'''
- if context is None:
- context = {}
member_line_obj = self.pool.get('membership.membership_line')
today = time.strftime('%Y-%m-%d')
for invoice in self.browse(cr, uid, ids):
- mlines = member_line_obj.search(cr,uid,
- [('account_invoice_line','in',
- [ l.id for l in invoice.invoice_line])], context)
- member_line_obj.write(cr,uid,mlines, {'date_cancel':today}, context)
- return super(Invoice, self).action_cancel(cr, uid, ids, context)
-Invoice()
-
-
-class ReportPartnerMemberYear(osv.osv):
- '''Membership by Years'''
-
- _name = 'report.partner_member.year'
- _description = __doc__
- _auto = False
- _rec_name = 'year'
- _columns = {
- 'year': fields.char('Year', size='4', readonly=True, select=1),
- 'canceled_number': fields.integer('Canceled', readonly=True),
- 'waiting_number': fields.integer('Waiting', readonly=True),
- 'invoiced_number': fields.integer('Invoiced', readonly=True),
- 'paid_number': fields.integer('Paid', readonly=True),
- 'canceled_amount': fields.float('Canceled', digits=(16, 2), readonly=True),
- 'waiting_amount': fields.float('Waiting', digits=(16, 2), readonly=True),
- 'invoiced_amount': fields.float('Invoiced', digits=(16, 2), readonly=True),
- 'paid_amount': fields.float('Paid', digits=(16, 2), readonly=True),
- 'currency': fields.many2one('res.currency', 'Currency', readonly=True,
- select=2),
- }
+ mlines = member_line_obj.search(cr, uid,
+ [('account_invoice_line', 'in',
+ [l.id for l in invoice.invoice_line])])
+ member_line_obj.write(cr, uid, mlines, {'date_cancel': today})
+ return super(Invoice, self).action_cancel(cr, uid, ids)
- def init(self, cr):
- '''Create the view'''
- cr.execute("""
- CREATE OR REPLACE VIEW report_partner_member_year AS (
- SELECT
- MIN(id) AS id,
- COUNT(ncanceled) as canceled_number,
- COUNT(npaid) as paid_number,
- COUNT(ninvoiced) as invoiced_number,
- COUNT(nwaiting) as waiting_number,
- SUM(acanceled) as canceled_amount,
- SUM(apaid) as paid_amount,
- SUM(ainvoiced) as invoiced_amount,
- SUM(awaiting) as waiting_amount,
- year,
- currency
- FROM (SELECT
- CASE WHEN ai.state = 'cancel' THEN ml.id END AS ncanceled,
- CASE WHEN ai.state = 'paid' THEN ml.id END AS npaid,
- CASE WHEN ai.state = 'open' THEN ml.id END AS ninvoiced,
- CASE WHEN (ai.state = 'draft' OR ai.state = 'proforma')
- THEN ml.id END AS nwaiting,
- CASE WHEN ai.state = 'cancel'
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS acanceled,
- CASE WHEN ai.state = 'paid'
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS apaid,
- CASE WHEN ai.state = 'open'
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS ainvoiced,
- CASE WHEN (ai.state = 'draft' OR ai.state = 'proforma')
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS awaiting,
- TO_CHAR(ml.date_from, 'YYYY') AS year,
- ai.currency_id AS currency,
- MIN(ml.id) AS id
- FROM membership_membership_line ml
- JOIN (account_invoice_line ail
- LEFT JOIN account_invoice ai
- ON (ail.invoice_id = ai.id))
- ON (ml.account_invoice_line = ail.id)
- JOIN res_partner p
- ON (ml.partner = p.id)
- GROUP BY TO_CHAR(ml.date_from, 'YYYY'), ai.state,
- ai.currency_id, ml.id) AS foo
- GROUP BY year, currency)
- """)
-
-ReportPartnerMemberYear()
-
-
-class ReportPartnerMemberYearNew(osv.osv):
- '''New Membership by Years'''
-
- _name = 'report.partner_member.year_new'
- _description = __doc__
- _auto = False
- _rec_name = 'year'
- _columns = {
- 'year': fields.char('Year', size='4', readonly=True, select=1),
- 'canceled_number': fields.integer('Canceled', readonly=True),
- 'waiting_number': fields.integer('Waiting', readonly=True),
- 'invoiced_number': fields.integer('Invoiced', readonly=True),
- 'paid_number': fields.integer('Paid', readonly=True),
- 'canceled_amount': fields.float('Canceled', digits=(16, 2), readonly=True),
- 'waiting_amount': fields.float('Waiting', digits=(16, 2), readonly=True),
- 'invoiced_amount': fields.float('Invoiced', digits=(16, 2), readonly=True),
- 'paid_amount': fields.float('Paid', digits=(16, 2), readonly=True),
- 'currency': fields.many2one('res.currency', 'Currency', readonly=True,
- select=2),
- }
-
- def init(self, cursor):
- '''Create the view'''
- cursor.execute("""
- CREATE OR REPLACE VIEW report_partner_member_year_new AS (
- SELECT
- MIN(id) AS id,
- COUNT(ncanceled) AS canceled_number,
- COUNT(npaid) AS paid_number,
- COUNT(ninvoiced) AS invoiced_number,
- COUNT(nwaiting) AS waiting_number,
- SUM(acanceled) AS canceled_amount,
- SUM(apaid) AS paid_amount,
- SUM(ainvoiced) AS invoiced_amount,
- SUM(awaiting) AS waiting_amount,
- year,
- currency
- FROM (SELECT
- CASE WHEN ai.state = 'cancel' THEN ml2.id END AS ncanceled,
- CASE WHEN ai.state = 'paid' THEN ml2.id END AS npaid,
- CASE WHEN ai.state = 'open' THEN ml2.id END AS ninvoiced,
- CASE WHEN (ai.state = 'draft' OR ai.state = 'proforma')
- THEN ml2.id END AS nwaiting,
- CASE WHEN ai.state = 'cancel'
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS acanceled,
- CASE WHEN ai.state = 'paid'
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS apaid,
- CASE WHEN ai.state = 'open'
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS ainvoiced,
- CASE WHEN (ai.state = 'draft' OR ai.state = 'proforma')
- THEN SUM(ail.price_unit * ail.quantity * (1 - ail.discount / 100))
- ELSE 0 END AS awaiting,
- TO_CHAR(ml2.date_from, 'YYYY') AS year,
- ai.currency_id AS currency,
- MIN(ml2.id) AS id
- FROM (SELECT
- partner AS id,
- MIN(date_from) AS date_from
- FROM membership_membership_line
- GROUP BY partner
- ) AS ml1
- JOIN membership_membership_line ml2
- JOIN (account_invoice_line ail
- LEFT JOIN account_invoice ai
- ON (ail.invoice_id = ai.id))
- ON (ml2.account_invoice_line = ail.id)
- ON (ml1.id = ml2.partner AND ml1.date_from = ml2.date_from)
- JOIN res_partner p
- ON (ml2.partner = p.id)
- GROUP BY TO_CHAR(ml2.date_from, 'YYYY'), ai.state,
- ai.currency_id, ml2.id) AS foo
- GROUP BY year, currency
- )
- """)
-
-ReportPartnerMemberYearNew()
+Invoice()
class account_invoice_line(osv.osv):
_inherit='account.invoice.line'
+
def write(self, cr, uid, ids, vals, context=None):
- if not context:
- context={}
- res = super(account_invoice_line, self).write(cr, uid, ids, vals, context=context)
+ """Overrides orm write method
+ """
member_line_obj = self.pool.get('membership.membership_line')
- for line in self.browse(cr, uid, ids):
- ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line','=',line.id)])
- if line.product_id and line.product_id.membership and not ml_ids:
- # Product line has changed to a membership product
- date_from = line.product_id.membership_date_from
- date_to = line.product_id.membership_date_to
- if line.invoice_id.date_invoice > date_from and line.invoice_id.date_invoice < date_to:
- date_from = line.invoice_id.date_invoice
- line_id = member_line_obj.create(cr, uid, {
- 'partner': line.invoice_id.partner_id.id,
- 'date_from': date_from,
- 'date_to': date_to,
- 'account_invoice_line': line.id,
- })
- if line.product_id and not line.product_id.membership and ml_ids:
- # Product line has changed to a non membership product
- member_line_obj.unlink(cr, uid, ml_ids, context=context)
+ res = super(account_invoice_line, self).write(cr, uid, ids, vals, context=context)
+ for line in self.browse(cr, uid, ids, context=context):
+ if line.invoice_id.type == 'out_invoice':
+ ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line', '=', line.id)], context=context)
+ if line.product_id and line.product_id.membership and not ml_ids:
+ # Product line has changed to a membership product
+ date_from = line.product_id.membership_date_from
+ date_to = line.product_id.membership_date_to
+ if line.invoice_id.date_invoice > date_from and line.invoice_id.date_invoice < date_to:
+ date_from = line.invoice_id.date_invoice
+ member_line_obj.create(cr, uid, {
+ 'partner': line.invoice_id.partner_id.id,
+ 'membership_id': line.product_id.id,
+ 'member_price': line.price_unit,
+ 'date': time.strftime('%Y-%m-%d'),
+ 'date_from': date_from,
+ 'date_to': date_to,
+ 'account_invoice_line': line.id,
+ }, context=context)
+ if line.product_id and not line.product_id.membership and ml_ids:
+ # Product line has changed to a non membership product
+ member_line_obj.unlink(cr, uid, ml_ids, context=context)
return res
def unlink(self, cr, uid, ids, context=None):
- if not context:
- context={}
+ """Remove Membership Line Record for Account Invoice Line
+ """
member_line_obj = self.pool.get('membership.membership_line')
for id in ids:
- ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line','=',id)])
+ ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line', '=', id)], context=context)
member_line_obj.unlink(cr, uid, ml_ids, context=context)
return super(account_invoice_line, self).unlink(cr, uid, ids, context=context)
- def create(self, cr, uid, vals, context={}):
- result = super(account_invoice_line, self).create(cr, uid, vals, context)
- line = self.browse(cr, uid, result)
+ def create(self, cr, uid, vals, context=None):
+ """Overrides orm create method
+ """
member_line_obj = self.pool.get('membership.membership_line')
- ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line','=',line.id)])
- if line.product_id and line.product_id.membership and not ml_ids:
- # Product line is a membership product
- date_from = line.product_id.membership_date_from
- date_to = line.product_id.membership_date_to
- if line.invoice_id.date_invoice > date_from and line.invoice_id.date_invoice < date_to:
- date_from = line.invoice_id.date_invoice
- line_id = member_line_obj.create(cr, uid, {
- 'partner': line.invoice_id.partner_id and line.invoice_id.partner_id.id or False,
- 'date_from': date_from,
- 'date_to': date_to,
- 'account_invoice_line': line.id,
- })
+ result = super(account_invoice_line, self).create(cr, uid, vals, context=context)
+ line = self.browse(cr, uid, result, context=context)
+ if line.invoice_id.type == 'out_invoice':
+ ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line', '=', line.id)], context=context)
+ if line.product_id and line.product_id.membership and not ml_ids:
+ # Product line is a membership product
+ date_from = line.product_id.membership_date_from
+ date_to = line.product_id.membership_date_to
+ if line.invoice_id.date_invoice > date_from and line.invoice_id.date_invoice < date_to:
+ date_from = line.invoice_id.date_invoice
+ member_line_obj.create(cr, uid, {
+ 'partner': line.invoice_id.partner_id and line.invoice_id.partner_id.id or False,
+ 'membership_id': line.product_id.id,
+ 'member_price': line.price_unit,
+ 'date': time.strftime('%Y-%m-%d'),
+ 'date_from': date_from,
+ 'date_to': date_to,
+ 'account_invoice_line': line.id,
+ }, context=context)
return result
account_invoice_line()
+
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: