+ 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 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 = {}
+ 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 fetched:
+ istate = fetched[0]
+ state = 'none'
+ if (istate == 'draft') | (istate == 'proforma'):
+ state = 'waiting'
+ elif istate == 'open':
+ 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
+ else:
+ cr.execute('''
+ SELECT i.state, i.id, i.partner_id FROM
+ pos_order i
+ WHERE
+ i.id = (
+ SELECT l.order_id FROM
+ pos_order_line l WHERE
+ l.id = (
+ SELECT ml.pos_order_line FROM
+ membership_membership_line ml WHERE
+ ml.id = %s
+ )
+ )
+ ''', (line.id,))
+ fetched = cr.fetchone()
+ if not fetched:
+ res[line.id] = 'canceled'
+ continue
+ partner_id = fetched[2]
+ self.write(cr, uid, line.id, {'partner': partner_id})
+ # NOTE: force une 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)
+ partner_obj = self.pool.get('res.partner')
+ for partner in partner_obj.browse(cr, uid, [partner_id], context=context):
+ if not partner.member_ident:
+ mbr_id = self.pool.get('ir.sequence').get(cr, uid, 'member_ident')
+ partner_obj.write(cr, uid, partner.id, {'member_ident': mbr_id})
+ ostate = fetched[0]
+ state = 'none'
+ if (ostate == 'paid') | (ostate == 'draft'):
+ state = 'waiting'
+ 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")
+ #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':
+ # state = 'canceled'
+ 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 = {
+ 'pos_order_line': fields.many2one('pos.order.line', 'POS Order line', readonly=True),
+ 'pos_order_id': fields.related('pos_order_line', 'order_id', type='many2one', relation='pos.order', string='Order', readonly=True),
+ 'state': fields.function(_state,
+ string='Membership Status', type='selection',
+ selection=STATE,
+ store = {
+ #'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.
+ -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)
+ # XXX: pos_order_line a aussi un company_id
+ }
+
+membership_line()
+
+class Partner(osv.osv):
+ '''Partner'''
+ _inherit = 'res.partner'
+
+ def _get_partner_id(self, cr, uid, ids, context=None):
+ print("DEV: [pos_membership] [Partner] [_get_partner_id]: ids=%s context=%s" % (str(ids), str(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 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
+ list_partner += ids2
+ print("DEV: [pos_membership] [Partner] [_get_partner_id]: res=%s" % (str(list_partner)))
+ return list_partner
+
+ def _get_invoice_partner(self, cr, uid, ids, context=None):
+ 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 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
+ list_partner += ids2
+ return list_partner
+
+ def _get_order_partner(self, cr, uid, ids, context=None):
+ ord_obj = self.pool.get('pos.order')
+ res_obj = self.pool.get('res.partner')
+ data_ord = ord_obj.browse(cr, uid, ids, context=context)
+ list_partner = []
+ for data in data_ord:
+ list_partner.append(data.partner_id.id)
+ ids2 = list_partner
+ while ids2:
+ 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 = {}
+ 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')
+ for id in ids:
+ print("DEV: [pos_membership] [Partner] [_membership_state] id=%s" % (str(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
+ if partner_data.membership_stop and today > partner_data.membership_stop:
+ res[id] = 'old'
+ continue
+ s = 4
+ print("DEV: [pos_membership] [Partner] [_membership_state] [partner_data] [member_lines] [test]")
+ 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:
+ 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 istate == 'open' and s!=0:
+ s = 1
+ elif istate == 'cancel' and s!=0 and s!=1:
+ s = 2
+ 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
+ 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")
+ #inv = mline.pos_order_line.order_id
+ #for payment in inv.payment_ids:
+ # if payment.invoice.type == 'out_refund':
+ # s = 2
+ break
+ elif ostate == 'open' and s!=0:
+ # XXX: 1 donne invoiced, c'est pitet pas bon
+ print("DEV: [pos_membership] [partner] [_membership_state]: invoiced: TODO")
+ s = 1
+ elif ostate == 'cancel' and s!=0 and s!=1:
+ s = 2
+ elif ostate == 'draft' and s!=0 and 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' or \
+ ( mline.pos_order_line and \
+ ( mline.pos_order_line.order_id.state == 'paid' or \
+ mline.pos_order_line.order_id.state == 'done' or \
+ mline.pos_order_line.order_id.state == 'invoiced' ))):
+ s = 5
+ else:
+ s = 6
+ if s==0:
+ res[id] = 'paid'
+ elif s==1:
+ res[id] = 'invoiced'
+ elif s==2:
+ res[id] = 'canceled'
+ elif s==3:
+ res[id] = 'waiting'
+ elif s==5:
+ res[id] = 'old'
+ elif s==6:
+ res[id] = 'none'
+ 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=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 date of membership"""
+ name = name[0]
+ res = {}
+ member_line_obj = self.pool.get('membership.membership_line')
+ print("DEV: [pos_membership] [Partner] [_membership_date]: ids=%s" % (str(ids)))
+ for partner in self.browse(cr, uid, ids, context=context):
+ if partner.associate_member:
+ partner_id = partner.associate_member.id
+ else:
+ 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]['membership_start'] = member_line_obj.read(cr, uid, line_id[0],
+ ['date_from'], context=context)['date_from']
+ print("DEV: [pos_membership] [Partner] [_membership_date] [membership_start]: ids=%s date=%s" % (str(ids), 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)
+ if line_id1:
+ res[partner.id]['membership_stop'] = member_line_obj.read(cr, uid, line_id1[0],
+ ['date_to'], context=context)['date_to']
+ print("DEV: [pos_membership] [Partner] [_membership_date] [membership_stop]: ids=%s date=%s" % (str(ids), 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)
+ if line_id2:
+ res[partner.id]['membership_cancel'] = member_line_obj.read(cr, uid, line_id2[0], ['date_cancel'], context=context)['date_cancel']
+ print("DEV: [pos_membership] [Partner] [_membership_date] [membership_cancel]: ids=%s date=%s" % (str(ids), str(res[partner.id]['membership_cancel'])))
+ print("DEV: [pos_membership] [Partner] [_membership_date]: res=%s" % (str(res)))
+ return res
+
+ 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
+ return ids
+
+ def __get_membership_state(self, *args, **kwargs):
+ return self._membership_state(*args, **kwargs)
+
+ _columns = {
+ 'membership_state': fields.function(
+ __get_membership_state,
+ string = 'Current Membership Status', type = 'selection',
+ selection = STATE,
+ store = {
+ # NOTE: il est important que la priorité soit plus grande
+ # que les membership_{start,stop,cancel}
+ # car _membership_state s'en sert et doit donc les trouver à jour.
+ 'account.invoice': (_get_invoice_partner, ['state'], 20),
+ 'pos.order': (_get_order_partner, ['state', 'partner_id'], 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."""),
+ 'membership_start': fields.function(
+ _membership_date, multi = 'membership_start',
+ string = 'Membership Start Date', type = 'date',
+ store = {
+ 'account.invoice': (_get_invoice_partner, ['state'], 10),
+ 'pos.order': (_get_order_partner, ['state', 'partner_id'], 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_date,
+ string = 'Membership End Date', type='date', multi='membership_stop',
+ store = {
+ 'account.invoice': (_get_invoice_partner, ['state'], 10),
+ 'pos.order': (_get_order_partner, ['state', 'partner_id'], 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_date,
+ string = 'Cancel Membership Date', type='date', multi='membership_cancel',
+ store = {
+ 'account.invoice': (_get_invoice_partner, ['state'], 11),
+ 'pos.order': (_get_order_partner, ['state', 'partner_id'], 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"),
+ }
+
+Partner()
+
+class pos_order(osv.osv):
+ _inherit = 'pos.order'