models/remembership.py

   1 # -*- coding: utf-8 -*-
   2 # Copyright 2012-2020 L'Heureux Cyclage
   3 # License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl).
   4
   5 from openerp.osv import fields, osv
   6 import time
   7 from datetime import datetime, date
   8 from dateutil.relativedelta import relativedelta
   9 from openerp.tools.translate import _
  10
  11 class Partner(osv.osv):
  12     _inherit = 'res.partner'
  13
  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"""
  17         name = name[0]
  18         res = {}
  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
  25             #else:
  26             # NOTE: hmm, ça devrait être toujours partner.id
  27             partner_id = partner.id
  28             res[partner.id] = {
  29                  'membership_start': False,
  30                  'membership_stop': False,
  31                  'membership_cancel': False
  32             }
  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)
  36                 if line_id:
  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']))
  41                     else:
  42                         print ("DEV: [_membership_date] date_from: %s" % str(res[partner.id]['membership_start']))
  43
  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)
  47                 if line_id1:
  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']))
  52                     else:
  53                         print ("DEV: [_membership_date] date_to: %s" % str(res[partner.id]['membership_stop']))
  54
  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)
  58                     if line_id2:
  59                         res[partner.id]['membership_cancel'] = member_line_obj.read(cr, uid, line_id2[0], ['date_cancel'], context=context)['date_cancel']
  60         return res
  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)
  66         list_partner = []
  67         for data in data_inv:
  68             list_partner.append(data.partner.id)
  69         ids2 = list_partner
  70         while ids2:
  71             ids2 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
  72             list_partner += ids2
  73         return list_partner
  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)
  79         list_partner = []
  80         for data in data_inv:
  81             list_partner.append(data.partner_id.id)
  82         ids2 = list_partner
  83         while ids2:
  84             ids2 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
  85             list_partner += ids2
  86         return list_partner
  87
  88     _columns = {
  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',
  95                     store = {
  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(
 102                     _membership_date,
 103                     string = 'Membership End Date', type='date', multi='membership_stop',
 104                     store = {
 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(
 111                     _membership_date,
 112                     string = 'Cancel Membership Date', type='date', multi='membership_cancel',
 113                     store = {
 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"),
 118     }
 119
 120     _sql_constraints = [
 121         ('member_ident_uniq', 'unique(member_ident, company_id)', 'The member identifier must be unique !'),
 122     ]
 123
 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)
 135         invoice_list = []
 136         if type(ids) in (int, long,):
 137             ids = [ids]
 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."))
 149             quantity = 1
 150             line_value =  {
 151                 'product_id': product_id,
 152             }
 153
 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
 162
 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)]
 172                 }, context=context)
 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))
 189         return invoice_list
 190
 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')
 194         today = date.today()
 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)
 197
 198     def copy(self, cr, uid, id, default=None, context=None):
 199         if default is None:
 200             default = {}
 201         default['member_ident'] = None
 202         return super(Partner, self).copy(cr, uid, id, default, context)
 203
 204
 205 Partner()
 206
 207
 208 class Product(osv.osv):
 209     _inherit = 'product.template'
 210
 211     _columns = {
 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.'),
 214     }
 215
 216 Product()
 217
 218
 219 class account_invoice_line(osv.osv):
 220     _inherit = 'account.invoice.line'
 221
 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)]
 232                       , limit=1
 233                       , context=context)
 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")
 242                               or date.today())
 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
 250                             ,'date_to'  : date_to
 251                             }
 252                           , context=context)
 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)
 258                                 ]
 259                               , context=context)
 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
 265                                     ,'date_to'  : date_to
 266                                     }
 267                                   , context=context)
 268                         else:
 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")
 273                     else:
 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)
 277                             ]
 278                           , context=context)
 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)
 284                     for i in partners:
 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))
 292         return res
 293
 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)
 299
 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)]
 304               , limit=1
 305               , context=context)
 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")
 314                       or date.today())
 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
 323                     ,'date_to'  : date_to
 324                     }
 325                   , context=context)
 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,
 339                         'date_to': date_to,
 340                         'account_invoice_line': line.id,
 341                     }, context=context)
 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
 345             for i in partners:
 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))
 350         return res
 351
 352 account_invoice_line()
 353 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: