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)
+ print("DEV: [pos_membership] [membership_line] [_get_partners]: ids=%s res=%s" % (str(ids), str(list_membership_line)))
return list_membership_line
- def _get_membership_lines_from_account_invoice(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 \
- { 'class': 'account.invoice'
- , 'ids': list_membership_line
- }
+ #def _get_membership_lines_from_account_invoice(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)
+ # res = \
+ # { 'class': 'account.invoice'
+ # , 'ids': list_membership_line
+ # }
+ # #res= list_membership_line
+ # print("DEV: [pos_membership] [membership_line] [_get_membership_lines_from_account_invoice]: res=%s" % str(res))
+ # return res
def _get_membership_lines_from_pos_order(self, cr, uid, ids, context=None):
list_membership_line = []
member_line_obj = self.pool.get('membership.membership_line')
for order in self.pool.get('pos.order').browse(cr, uid, ids, context=context):
- if order.order_line:
- list_membership_line += member_line_obj.search(cr, uid, [('pos_order_line', 'in', [ l.id for l in order.order_line])], context=context)
- return \
- { 'class': 'pos.order'
- , 'ids': list_membership_line
- }
+ if order.lines:
+ list_membership_line += member_line_obj.search(cr, uid, [('pos_order_line', 'in', [ l.id for l in order.lines])], context=context)
+ #res = \
+ # { 'class': 'pos.order'
+ # , 'ids': list_membership_line
+ # }
+ res= list_membership_line
+ print("DEV: [pos_membership] [membership_line] [_get_membership_lines_from_pos_order]: res=%s" % str(res))
+ return res
def _check_membership_date(self, cr, uid, ids, context=None):
"""Check if membership product is not in the past
return False
return True
- def _state(self, cr, uid, data, name, args, context=None):
+ def _state(self, cr, uid, ids, name, args, context=None):
"""Compute the state lines
@param self: The object pointer
@param cr: the current row, from the database cursor,
@param return: Dictionary of state Value
"""
res = {}
- if data['class'] == 'account.invoice':
- inv_obj = self.pool.get('account.invoice')
- for line in self.browse(cr, uid, data['ids'], context=context):
- cr.execute('''
- SELECT i.state, i.id FROM
- account_invoice i
- WHERE
- i.id = (
- SELECT l.invoice_id FROM
- account_invoice_line l WHERE
- l.id = (
- SELECT ml.account_invoice_line FROM
- membership_membership_line ml WHERE
- ml.id = %s
- )
+ print("DEV: [pos_membership] [membership_line] [_state]: name=%s ids=%s args=%s context=%s" % (str(name), str(ids), str(args), str(context)))
+ inv_obj = self.pool.get('account.invoice')
+ ord_obj = self.pool.get('pos.order')
+ for line in self.browse(cr, uid, ids, context=context):
+ cr.execute('''
+ SELECT i.state, i.id FROM
+ account_invoice i
+ WHERE
+ i.id = (
+ SELECT l.invoice_id FROM
+ account_invoice_line l WHERE
+ l.id = (
+ SELECT ml.account_invoice_line FROM
+ membership_membership_line ml WHERE
+ ml.id = %s
)
- ''', (line.id,))
- fetched = cr.fetchone()
- if not fetched:
- res[line.id] = 'canceled'
- continue
+ )
+ ''', (line.id,))
+ fetched = cr.fetchone()
+ if fetched:
istate = fetched[0]
state = 'none'
if (istate == 'draft') | (istate == 'proforma'):
state = 'invoiced'
elif istate == 'paid':
state = 'paid'
- # XXX: regarder l'équivalent de out_refund pour un pos.order
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':
elif istate == 'cancel':
state = 'canceled'
res[line.id] = state
- elif data['class'] == 'pos.order':
- ord_obj = self.pool.get('pos.order')
- for line in self.browse(cr, uid, data['ids'], context=context):
+ else:
cr.execute('''
- SELECT i.state, i.id FROM
+ SELECT i.state, i.id, i.partner_id FROM
pos_order i
WHERE
i.id = (
if not fetched:
res[line.id] = 'canceled'
continue
+ self.write(cr, uid, line.id, {'partner': fetched[2]})
+ # NOTE: force un mise à jour du partner,
+ # car il n'y en a pas lors de la création du pos.order
+ # dans le PoS (pour le moment)
ostate = fetched[0]
state = 'none'
- if (ostate == 'draft'):
+ if (ostate == 'paid') | (ostate == 'draft'):
state = 'waiting'
- elif (ostate == 'paid') | (ostate == 'done') | (ostate == 'invoiced'):
+ elif (ostate == 'done') | (ostate == 'invoiced'):
state = 'paid'
# XXX: regarder l'équivalent de out_refund pour un pos.order
- print("DEV: [pos_membership] [membership_line] [_state]: paid: TODO"),
+ print("DEV: [pos_membership] [membership_line] [_state]: paid: TODO")
#inv = ord_obj.browse(cr, uid, fetched[1], context=context)
#for payment in inv.payment_ids:
# if payment.invoice and payment.invoice.type == 'out_refund':
elif ostate == 'cancel':
state = 'canceled'
res[line.id] = state
+ print("DEV: [pos_membership] [membership_line] [_state]: return=%s" % (str(res)))
+ return res
+
+ def write(self, cr, uid, ids, vals, context=None):
+ print("DEV: [pos_membership] [membership_line] [write]: ids=%s vals=%s" % (str(ids), str(vals)))
+ member_line_obj = self.pool.get('membership.membership_line')
+ res = super(membership_line, self).write(cr, uid, ids, vals, context=context)
+ print("DEV: [pos_membership] [membership_line] [write]: res=%s" % str(res))
+ return res
+
+ def create(self, cr, uid, vals, context=None):
+ print("DEV: [pos_membership] [membership_line] [create]: vals=%s" % (str(vals)))
+ member_line_obj = self.pool.get('membership.membership_line')
+ res = super(membership_line, self).create(cr, uid, vals, context=context)
+ print("DEV: [pos_membership] [membership_line] [create]: res=%s" % (str(res)))
return res
_columns = {
string='Membership Status', type='selection',
selection=STATE,
store = {
- 'account.invoice': (_get_membership_lines_from_account_invoice, ['state'], 10),
- 'pos.order': (_get_membership_lines_from_pos_order, ['state'], 10),
+ #'account.invoice': (_get_membership_lines_from_account_invoice, ['state'], 10),
+ # NOTE: déjà géré par membership.membership_line._get_membership_lines
+ 'pos.order': (_get_membership_lines_from_pos_order, ['state', 'partner_id'], 10),
'res.partner': (_get_partners, ['membership_state'], 12),
}, help="""It indicates the membership status.
-Non Member: A member who has not applied for any membership.
@param return: Dictionary of Membership state Value
"""
res = {}
+ print("DEV: [pos_membership] [Partner] [_membership_state]: name=%s ids=%s args=%s context=%s" % (str(name), str(ids), str(args), str(context)))
for id in ids:
res[id] = 'none'
today = time.strftime('%Y-%m-%d')
continue
s = 4
if partner_data.member_lines:
+ print("DEV: [pos_membership] [Partner] [_membership_state] [partner_data] [member_lines]" % ())
for mline in partner_data.member_lines:
+ print("DEV: [pos_membership] [Partner] [_membership_state] [mline]: id=%s" % str(mline.id))
if mline.date_to >= today:
if mline.account_invoice_line and mline.account_invoice_line.invoice_id:
- mstate = mline.account_invoice_line.invoice_id.state
- if mstate == 'paid':
+ istate = mline.account_invoice_line.invoice_id.state
+ print("DEV: [pos_membership] [Partner] [_membership_state] [account_invoice_line]: id=%s istate=%s" % (str(mline.account_invoice_line.invoice_id.id), str(istate)))
+ if istate == '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:
+ elif istate == 'open' and s!=0:
s = 1
- elif mstate == 'cancel' and s!=0 and s!=1:
+ elif istate == 'cancel' and s!=0 and s!=1:
s = 2
- elif (mstate == 'draft' or mstate == 'proforma') and s!=0 and s!=1:
+ elif (istate == 'draft' or istate == 'proforma') and s!=0 and s!=1:
+ s = 3
+ elif mline.pos_order_line and mline.pos_order_line.order_id:
+ ostate = mline.pos_order_line.order_id.state
+ print("DEV: [pos_membership] [Partner] [_membership_state] [pos_order_line]: id=%s ostate=%s" % (str(mline.pos_order_line.order_id.id), str(ostate)))
+ if ostate == 'paid' and s!=0 and s!=1:
s = 3
- elif mline.order_pos_line and mline.order_pos_line.order_id:
- mstate = mline.pos_order_line.order_id.state
- if (mstate == 'paid') | (mstate == 'done') | (mstate == 'paid'):
+ if ostate == 'invoiced':
+ s = 1
+ if ostate == 'done':
s = 0
# XXX: regarder l'équivalent de out_refund pour un pos.order
- print("DEV: [pos_membership] [partner] [_membership_state]: paid: TODO"),
+ print("DEV: [pos_membership] [partner] [_membership_state]: paid: TODO")
#inv = mline.pos_order_line.order_id
#for payment in inv.payment_ids:
# if payment.invoice.type == 'out_refund':
# s = 2
break
- elif mstate == 'open' and s!=0:
+ elif ostate == 'open' and s!=0:
# XXX: 1 donne invoiced, c'est pitet pas bon
- print("DEV: [pos_membership] [partner] [_membership_state]: invoiced: TODO"),
+ print("DEV: [pos_membership] [partner] [_membership_state]: invoiced: TODO")
s = 1
- elif mstate == 'cancel' and s!=0 and s!=1:
+ elif ostate == 'cancel' and s!=0 and s!=1:
s = 2
- elif mstate == 'draft' and s!=0 and s!=1:
+ elif ostate == 'draft' and s!=0 and s!=1:
s = 3
if s==4:
for mline in partner_data.member_lines:
if partner_data.associate_member:
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]
+ print("DEV: [pos_membership] [Partner] [_membership_state]: res=%s" % (str(res)))
return res
def _membership_date(self, cr, uid, ids, name, args, context=None):
return self._membership_state(*args, **kwargs)
_columns = {
- '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', help = "Select if you want to give free membership."),
- 'membership_amount': fields.float(
- 'Membership Amount', digits=(16, 2),
- help = 'The price negotiated by the partner'),
'membership_state': fields.function(
__get_membership_state,
string = 'Current Membership Status', type = 'selection',
selection = STATE,
store = {
'account.invoice': (_get_invoice_partner, ['state'], 10),
- 'pos.order': (_get_order_partner, ['state'], 10),
+ 'pos.order': (_get_order_partner, ['state', 'partner_id'], 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.
order_line_obj = self.pool.get('pos.order.line')
data_order_line = order_line_obj.browse(cr, uid, ids, context=context)
for data in data_order_line:
- print("DEV: [pos_membership] [_check_membership_product] [order_line]: data=%s product=%s" % (str(data.id), str(data.product_id))),
+ print("DEV: [pos_membership] [_check_membership_product] [order_line]: data=%s product=%s" % (str(data.id), str(data.product_id.id)))
return True
_constraints = [
# XXX: copied from openerp/addons/point_of_sale/point_of_sale.py
def action_invoice(self, cr, uid, ids, context=None):
- print ("DEV: [pos_membership] [pos_order] [action_invoice]");
+ print ("DEV: [pos_membership] [pos_order] [action_invoice]")
wf_service = netsvc.LocalService("workflow")
inv_ref = self.pool.get('account.invoice')
inv_line_ref = self.pool.get('account.invoice.line')
'target': 'current',
'res_id': inv_ids and inv_ids[0] or False,
}
+
+ def write(self, cr, uid, ids, vals, context=None):
+ print("DEV: [pos_membership] [pos_order] [write]: ids=%s vals=%s" % (str(ids), str(vals)))
+ pos_order_obj = self.pool.get('pos.order')
+ res = super(pos_order, self).write(cr, uid, ids, vals, context=context)
+ print("DEV: [pos_membership] [pos_order] [write]: res=%s" % str(res))
+ return res
+
+ def create(self, cr, uid, vals, context=None):
+ print("DEV: [pos_membership] [pos_order] [create]: vals=%s" % (str(vals)))
+ pos_order_obj = self.pool.get('pos.order')
+ res = super(pos_order, self).create(cr, uid, vals, context=context)
+ print("DEV: [pos_membership] [pos_order] [create]: res=%s" % (str(res)))
+ return res
pos_order()
_inherit = 'pos.order.line'
def write(self, cr, uid, ids, vals, context=None):
+ print("DEV: [pos_membership] [pos_order_line] [write]: ids=%s vals=%s context=%s" % (str(ids), str(vals), str(context)))
member_line_obj = self.pool.get('membership.membership_line')
res = super(pos_order_line, self).write(cr, uid, ids, vals, context=context)
+ print ("DEV: [pos_membership] [pos_order_line] [write] [super] : res=%s" % str(res))
for line in self.browse(cr, uid, ids, context=context):
ml_ids = member_line_obj.search(cr, uid, [('pos_order_line', '=', line.id)], context=context)
- if line.product_id and line.product_id.membership:
- member_line_id = member_line_obj.search(cr, uid
- , [('partner' , '=', line.order_id.partner_id.id)
- ,('pos_order_line', '=', line.id)]
- , limit=1
- , context=context)
- for member_line in member_line_obj.browse(cr, uid, member_line_id, context=context):
- # NOTE: get member_line created in membership.pos_order_line.create
- date_from = member_line.date_from
- date_to = member_line.date_to
- if line.product_id.membership_date2date:
- date_from = ('date_from' in context
- and context['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_from = date_from.strftime("%Y-%m-%d")
- date_to = date_to .strftime("%Y-%m-%d")
- print ("DEV: [pos_membership] [write] date_from: %s" % str(date_from))
- print ("DEV: [pos_membership] [write] date_to : %s" % str(date_to))
- member_line_obj.write(cr, uid, member_line.id
- , {'date_from': date_from
- ,'date_to' : date_to
- }
- , context=context)
+ if line.product_id and line.product_id.membership and not ml_ids:
+ date_from = line.product_id.membership_date_from
+ date_to = line.product_id.membership_date_to
+ if line.order_id.date_order > date_from and \
+ line.order_id.date_order < date_to:
+ date_from = line.order_id.date_order
+ if line.product_id.membership_date2date:
+ date_from = ('date_from' in context
+ and context['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_from = date_from.strftime("%Y-%m-%d")
+ date_to = date_to .strftime("%Y-%m-%d")
+ print ("DEV: [pos_membership] [write] date_from: %s" % str(date_from))
+ print ("DEV: [pos_membership] [write] date_to : %s" % str(date_to))
+ member_line_obj.create(cr, uid
+ , { 'partner': line.order_id.partner_id and line.order_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
+ , 'pos_order_line': line.id
+ }
+ , context=context)
if line.product_id.membership_grouped:
if line.order_id.partner_id.associate_members:
associate_member_line_ids = member_line_obj.search(cr, uid
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)
+ print("DEV: [pos_membership] [pos_order_line] [write]: res=%s" % str(res))
return res
+ def unlink(self, cr, uid, ids, context=None):
+ """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, [('pos_order_line', '=', id)], context=context)
+ member_line_obj.unlink(cr, uid, ml_ids, context=context)
+ return super(pos_order_line, self).unlink(cr, uid, ids, context=context)
+
def create(self, cr, uid, vals, context=None):
member_line_obj = self.pool.get('membership.membership_line')
+ print("DEV: [pos_membership] [pos_order_line] [create]: vals=%s context=%s" % (str(vals), str(context)))
res = super(pos_order_line, self).create(cr, uid, vals, context=context)
+ print ("DEV: [pos_membership] [pos_order_line] [create] [super] : res=%s" % str(res))
line = self.browse(cr, uid, res, context=context)
- if line.product_id and line.product_id.membership:
- member_line_id = member_line_obj.search(cr, uid
- , [('partner' , '=', line.order_line.partner_id.id)
- ,('pos_order_line', '=', line.id)]
- , limit=1
- , context=context)
- for member_line in member_line_obj.browse(cr, uid, member_line_id, context=context):
- # NOTE: get member_line created in membership.pos_order_line.create
- date_from = member_line.date_from
- date_to = member_line.date_to
- if line.product_id.membership_date2date:
- date_from = ('date_from' in context
- and context['date_from']
- and datetime.strptime(context['date_from'], "%Y-%m-%d")
- or date.today())
- date_to = date_from + relativedelta(days = +364) # TODO: parameterize this delta?
- date_from = date_from.strftime("%Y-%m-%d")
- date_to = date_to .strftime("%Y-%m-%d")
- print ("DEV: [pos_membership] [create] date_from: %s" % str(date_from))
- print ("DEV: [pos_membership] [create] date_to : %s" % str(date_to))
- member_line_obj.write(cr, uid, member_line.id
- , {'date_from': date_from
- ,'date_to' : date_to
- }
- , context=context)
- partners = [line.order_line.partner_id]
- if line.product_id.membership_grouped and line.order_line.partner_id.associate_members:
- partners.extend(line.order_line.partner_id.associate_members)
+ ml_ids = member_line_obj.search(cr, uid, [('pos_order_line', '=', line.id)], context=context)
+ if line.product_id and line.product_id.membership and not ml_ids:
+ date_from = line.product_id.membership_date_from
+ date_to = line.product_id.membership_date_to
+ if line.order_id.date_order > date_from and line.order_id.date_order < date_to:
+ date_from = line.order_id.date_order
+ if line.product_id.membership_date2date:
+ date_from = ('date_from' in context
+ 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?
+ date_from = date_from.strftime("%Y-%m-%d")
+ date_to = date_to .strftime("%Y-%m-%d")
+ print ("DEV: [pos_membership] [pos_order_line] [create] date_from: %s" % str(date_from))
+ print ("DEV: [pos_membership] [pos_order_line] [create] date_to : %s" % str(date_to))
+ member_line_obj.create(cr, uid, {
+ 'partner': line.order_id.partner_id and line.order_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,
+ 'pos_order_line': line.id,
+ }, context=context)
+ partners = [line.order_id.partner_id]
+ if line.product_id.membership_grouped and line.order_id.partner_id.associate_members:
+ partners.extend(line.order_id.partner_id.associate_members)
#Adding membership lines just for associate partners
- for associate_member in line.order_line.partner_id.associate_members:
- print ("DEV: [pos_membership] [create] [associate] date_from: %s" % str(date_from))
- print ("DEV: [pos_membership] [create] [associate] date_to : %s" % str(date_to))
+ for associate_member in line.order_id.partner_id.associate_members:
+ print ("DEV: [pos_membership] [pos_order_line] [create] [associate] date_from: %s" % str(date_from))
+ print ("DEV: [pos_membership] [pos_order_line] [create] [associate] date_to : %s" % str(date_to))
member_line_obj.create(cr, uid, {
'partner': associate_member.id,
'membership_id': line.product_id.id,
'date_to': date_to,
'pos_order_line': line.id,
}, context=context)
- elif line.product_id.membership_grouped and not line.order_line.partner_id.associate_members:
+ elif line.product_id.membership_grouped and not line.order_id.partner_id.associate_members:
raise osv.except_osv(_('Error!!!'), _('You try to order grouped membership product to a partner who hasn\'t associated partners.'))
#Define member ident if it's necessary
for i in partners:
+ if not i:
+ print ("\033[7mXXX: [pos_membership] [pos_order_line] [create] : pos_order_line has no partner_id!\033[0m")
+ break
if not i.member_ident:
+ print ("DEV: [pos_membership] [pos_order_line] [create] [partners] : i=%s i.id=%s" % (str(i), str(i.id)))
mbr_id = self.pool.get('ir.sequence').get(cr, uid, 'member_ident')
self.pool.get('res.partner').write(cr, uid, i.id, {'member_ident': mbr_id})
+ print ("DEV: [pos_membership] [pos_order_line] [create] : return=%s" % str(res))
return res
pos_order_line()