remembership.py

   1 # -*- coding: utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    Remembership module for OpenERP, Overload membership module
   5 #    Copyright (C) 2012 L'Heureux Cyclage (<http://www.heureux-cyclage.org>) Ludovic CHEVALIER
   6 #
   7 #    This file is a part of Remembership
   8 #
   9 #    Remembership is free software: you can redistribute it and/or modify
  10 #    it under the terms of the GNU General Public License as published by
  11 #    the Free Software Foundation, either version 3 of the License, or
  12 #    (at your option) any later version.
  13 #
  14 #    Remembership is distributed in the hope that it will be useful,
  15 #    but WITHOUT ANY WARRANTY; without even the implied warranty of
  16 #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  17 #    GNU General Public License for more details.
  18 #
  19 #    You should have received a copy of the GNU General Public License
  20 #    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  21 #
  22 ##############################################################################
  23
  24 from osv import osv
  25 from osv import fields
  26 import time
  27 from datetime import datetime, date
  28 from dateutil.relativedelta import relativedelta
  29 from openerp.tools.translate import _
  30
  31
  32 class Partner(osv.osv):
  33     _inherit = 'res.partner'
  34
  35     # XXX: copied from openerp/addons/membership/membership.py
  36     def _membership_date(self, cr, uid, ids, name, args, context=None):
  37         """Return  date of membership"""
  38         name = name[0]
  39         res = {}
  40         member_line_obj = self.pool.get('membership.membership_line')
  41         print ("DEV: [remembership] [_membership_date]")
  42         for partner in self.browse(cr, uid, ids, context=context):
  43             # XXX: commented part from openerp/addons/membership/membership.py
  44             #if partner.associate_member:
  45             #     partner_id = partner.associate_member.id
  46             #else:
  47             # NOTE: hmm, ça devrait être toujours partner.id
  48             partner_id = partner.id
  49             res[partner.id] = {
  50                  'membership_start': False,
  51                  'membership_stop': False,
  52                  'membership_cancel': False
  53             }
  54             if name == 'membership_start':
  55                 line_id = member_line_obj.search(cr, uid, [('partner', '=', partner_id),('date_cancel','=',False)],
  56                             limit=1, order='date_from', context=context)
  57                 if line_id:
  58                     res[partner.id]['membership_start'] = member_line_obj.read(cr, uid, line_id[0],
  59                             ['date_from'], context=context)['date_from']
  60                     if partner.associate_member:
  61                         print ("DEV: [_membership_date] [associate] date_from: %s" % str(res[partner.id]['membership_start']))
  62                     else:
  63                         print ("DEV: [_membership_date] date_from: %s" % str(res[partner.id]['membership_start']))
  64
  65             if name == 'membership_stop':
  66                 line_id1 = member_line_obj.search(cr, uid, [('partner', '=', partner_id),('date_cancel','=',False)],
  67                             limit=1, order='date_to desc', context=context)
  68                 if line_id1:
  69                     res[partner.id]['membership_stop'] = member_line_obj.read(cr, uid, line_id1[0],
  70                               ['date_to'], context=context)['date_to']
  71                     if partner.associate_member:
  72                         print ("DEV: [_membership_date] [associate] date_to: %s" % str(res[partner.id]['membership_stop']))
  73                     else:
  74                         print ("DEV: [_membership_date] date_to: %s" % str(res[partner.id]['membership_stop']))
  75
  76             if name == 'membership_cancel':
  77                 if partner.membership_state == 'canceled':
  78                     line_id2 = member_line_obj.search(cr, uid, [('partner', '=', partner.id)], limit=1, order='date_cancel', context=context)
  79                     if line_id2:
  80                         res[partner.id]['membership_cancel'] = member_line_obj.read(cr, uid, line_id2[0], ['date_cancel'], context=context)['date_cancel']
  81         return res
  82     # XXX: copied from openerp/addons/membership/membership.py
  83     def _get_partner_id(self, cr, uid, ids, context=None):
  84         member_line_obj = self.pool.get('membership.membership_line')
  85         res_obj =  self.pool.get('res.partner')
  86         data_inv = member_line_obj.browse(cr, uid, ids, context=context)
  87         list_partner = []
  88         for data in data_inv:
  89             list_partner.append(data.partner.id)
  90         ids2 = list_partner
  91         while ids2:
  92             ids2 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
  93             list_partner += ids2
  94         return list_partner
  95     # XXX: copied from openerp/addons/membership/membership.py
  96     def _get_invoice_partner(self, cr, uid, ids, context=None):
  97         inv_obj = self.pool.get('account.invoice')
  98         res_obj = self.pool.get('res.partner')
  99         data_inv = inv_obj.browse(cr, uid, ids, context=context)
 100         list_partner = []
 101         for data in data_inv:
 102             list_partner.append(data.partner_id.id)
 103         ids2 = list_partner
 104         while ids2:
 105             ids2 = res_obj.search(cr, uid, [('associate_member', 'in', ids2)], context=context)
 106             list_partner += ids2
 107         return list_partner
 108
 109     _columns = {
 110         'member_ident': fields.char('Member identifier', size=64),
 111         'associate_members': fields.one2many('res.partner', 'associate_member', 'Associate members', help='Members who are associated to this partner.'),
 112         # XXX: copied from openerp/addons/membership/membership.py
 113         'membership_start': fields.function(
 114                     _membership_date, multi = 'membership_start',
 115                     string = 'Membership Start Date', type = 'date',
 116                     store = {
 117                         'account.invoice': (_get_invoice_partner, ['state'], 10),
 118                         'membership.membership_line': (_get_partner_id, ['state'], 10, ),
 119                         'res.partner': (lambda self, cr, uid, ids, c={}: ids, ['free_member'], 10)
 120                     }, help="Date from which membership becomes active."),
 121         # XXX: copied from openerp/addons/membership/membership.py
 122         'membership_stop': fields.function(
 123                     _membership_date,
 124                     string = 'Membership End Date', type='date', multi='membership_stop',
 125                     store = {
 126                         'account.invoice': (_get_invoice_partner, ['state'], 10),
 127                         'membership.membership_line': (_get_partner_id, ['state'], 10),
 128                         'res.partner': (lambda self, cr, uid, ids, c={}: ids, ['free_member'], 10)
 129                     }, help="Date until which membership remains active."),
 130         # XXX: copied from openerp/addons/membership/membership.py
 131         'membership_cancel': fields.function(
 132                     _membership_date,
 133                     string = 'Cancel Membership Date', type='date', multi='membership_cancel',
 134                     store = {
 135                         'account.invoice': (_get_invoice_partner, ['state'], 11),
 136                         'membership.membership_line': (_get_partner_id, ['state'], 10),
 137                         'res.partner': (lambda self, cr, uid, ids, c={}: ids, ['free_member'], 10)
 138                     }, help="Date on which membership has been cancelled"),
 139     }
 140
 141     _sql_constraints = [
 142         ('member_ident_uniq', 'unique(member_ident, company_id)', 'The member identifier must be unique !'),
 143     ]
 144
 145     def create_membership_invoice(self, cr, uid, ids, product_id=None, datas=None, context=None):
 146         # NOTE: use context to supply date_from to account_invoice_line.create
 147         context = context and context.copy() or {}
 148         context['date_from'] = datas.get('date_from', None)
 149         # XXX: copied from openerp/addons/membership/membership.py to fix account_invoice_line creation
 150         print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s" % str(ids))
 151         invoice_obj = self.pool.get('account.invoice')
 152         invoice_line_obj = self.pool.get('account.invoice.line')
 153         invoice_tax_obj = self.pool.get('account.invoice.tax')
 154         product_id = product_id or datas.get('membership_product_id', False)
 155         amount = datas.get('amount', 0.0)
 156         invoice_list = []
 157         if type(ids) in (int, long,):
 158             ids = [ids]
 159         for partner in self.browse(cr, uid, ids, context=context):
 160             print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s" % (str(ids),str(partner.id)))
 161             account_id = partner.property_account_receivable and partner.property_account_receivable.id or False
 162             fpos_id = partner.property_account_position and partner.property_account_position.id or False
 163             addr = self.address_get(cr, uid, [partner.id], ['invoice'])
 164             if partner.free_member:
 165                 raise osv.except_osv(_('Error!'),
 166                         _("Partner is a free Member."))
 167             if not addr.get('invoice', False):
 168                 raise osv.except_osv(_('Error!'),
 169                         _("Partner doesn't have an address to make the invoice."))
 170             quantity = 1
 171             line_value =  {
 172                 'product_id': product_id,
 173             }
 174
 175             print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_line_obj] [product_id_change]" % (str(ids),str(partner.id)))
 176             line_dict = invoice_line_obj.product_id_change(cr, uid, {},
 177                             product_id, False, quantity, '', 'out_invoice', partner.id, fpos_id, price_unit=amount, context=context)
 178             line_value.update(line_dict['value'])
 179             line_value['price_unit'] = amount
 180             if line_value.get('invoice_line_tax_id', False):
 181                 tax_tab = [(6, 0, line_value['invoice_line_tax_id'])]
 182                 line_value['invoice_line_tax_id'] = tax_tab
 183
 184             print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_obj] [create] account=%s" % (str(ids),str(partner.id),str(account_id)))
 185             # NOTE: let account_invoice_obj.create() call account_invoice_line.create()
 186             #       to have a correct membership_state: becauce now fields.function 'store' watchdogs
 187             #       are triggered after account_invoice_line.create().
 188             invoice_id = invoice_obj.create(cr, uid, {
 189                 'partner_id': partner.id,
 190                 'account_id': account_id,
 191                 'fiscal_position': fpos_id or False,
 192                 'invoice_line':[(0, 0, line_value)]
 193                 }, context=context)
 194             #line_value['invoice_id'] = invoice_id
 195             #print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s partner=%s [invoice_line_obj] [create]" % (str(ids),str(partner.id)))
 196             #invoice_line_id = invoice_line_obj.create(cr, uid, line_value, context=context)
 197             #invoice_obj.write(cr, uid, invoice_id, {'invoice_line': line_value}, context=context)
 198             invoice_list.append(invoice_id)
 199             if line_value['invoice_line_tax_id']:
 200                 tax_value = invoice_tax_obj.compute(cr, uid, invoice_id).values()
 201                 for tax in tax_value:
 202                        invoice_tax_obj.create(cr, uid, tax, context=context)
 203         # NOTE: this wasn't working, and is not needed now.
 204         #recompute the membership_state of those partners
 205         #print ("DEV: [remembership] [partner] [create_membership_invoice] ids=%s [recompute states]" % str(ids))
 206         #self.pool.get('res.partner').write(cr, uid, ids, {}, context=context)
 207         return invoice_list
 208
 209 Partner()
 210
 211
 212 class Product(osv.osv):
 213     _inherit = 'product.product'
 214
 215     _columns = {
 216         'membership_grouped': fields.boolean('Grouped membership product', help='Check if it\'s a grouped membership product.'),
 217         'membership_date2date': fields.boolean('Date to date membership product', required=False, help='Check if it\'s a date to date membership product.'),
 218     }
 219
 220 Product()
 221
 222
 223 class account_invoice_line(osv.osv):
 224     _inherit = 'account.invoice.line'
 225
 226     def write(self, cr, uid, ids, vals, context=None):
 227         member_line_obj = self.pool.get('membership.membership_line')
 228         res = super(account_invoice_line, self).write(cr, uid, ids, vals, context=context)
 229         for line in self.browse(cr, uid, ids, context=context):
 230             if line.invoice_id.type == 'out_invoice':
 231                 ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line', '=', line.id)], context=context)
 232                 if line.product_id and line.product_id.membership:
 233                     member_line_id = member_line_obj.search(cr, uid
 234                       , [('partner'             , '=', line.invoice_id.partner_id.id)
 235                         ,('account_invoice_line', '=', line.id)]
 236                       , limit=1
 237                       , context=context)
 238                     for member_line in member_line_obj.browse(cr, uid, member_line_id, context=context):
 239                       # NOTE: get member_line created in membership.account_invoice_line.create
 240                         date_from = member_line.date_from
 241                         date_to   = member_line.date_to
 242                         if line.product_id.membership_date2date:
 243                             date_from = ('date_from' in context
 244                               and context['date_from']
 245                               and datetime.strptime(context['date_from'], "%Y-%m-%d")
 246                               or date.today())
 247                             date_to   = date_from + relativedelta(months = +12) # TODO: parameterize this delta?
 248                             date_from = date_from.strftime("%Y-%m-%d")
 249                             date_to   = date_to  .strftime("%Y-%m-%d")
 250                         print ("DEV: [write] date_from: %s" % str(date_from))
 251                         print ("DEV: [write] date_to  : %s" % str(date_to))
 252                         member_line_obj.write(cr, uid, member_line.id
 253                           , {'date_from': date_from
 254                             ,'date_to'  : date_to
 255                             }
 256                           , context=context)
 257                     if line.product_id.membership_grouped:
 258                         if line.invoice_id.partner_id.associate_members:
 259                             associate_member_line_ids = member_line_obj.search(cr, uid
 260                               , [ ('account_invoice_line', '=', line.id)
 261                                 , ('partner', '!=', line.invoice_id.partner_id.id)
 262                                 ]
 263                               , context=context)
 264                             for associate_member_line in member_line_obj.browse(cr, uid, associate_member_line_ids, context=context):
 265                                 print ("DEV: [write] [associate] date_from: %s" % str(date_from))
 266                                 print ("DEV: [write] [associate] date_to  : %s" % str(date_to))
 267                                 member_line_obj.write(cr, uid, associate_member_line.id
 268                                   , {'date_from': date_from
 269                                     ,'date_to'  : date_to
 270                                     }
 271                                   , context=context)
 272                         else:
 273                             print("DEV: mettre une contrainte pour l'objet\
 274                                   membership.membership_line interdisant les\
 275                                   adhésions groupées reliées à des partenaires\
 276                                   sans membres associés")
 277                     else:
 278                         associate_member_line_ids = member_line_obj.search(cr, uid
 279                           , [ ('account_invoice_line', '=', line.id)
 280                             , ('partner', '!=', line.invoice_id.partner_id.id)
 281                             ]
 282                           , context=context)
 283                         member_line_obj.unlink(cr, uid, associate_member_line_ids, context=context)
 284
 285                     #Define member ident if it's necessary
 286                     partners = [line.invoice_id.partner_id]
 287                     if line.invoice_id.partner_id.associate_members:
 288                         partners.extend(line.invoice_id.partner_id.associate_members)
 289                     for i in partners:
 290                         if not i.member_ident:
 291                             mbr_id = self.pool.get('ir.sequence').get(cr, uid, 'member_ident')
 292                             self.pool.get('res.partner').write(cr, uid, i.id, {'member_ident': mbr_id})
 293                 if line.product_id and not line.product_id.membership and ml_ids:
 294                     # Product line has changed to a non membership product
 295                     member_line_obj.unlink(cr, uid, ml_ids, context=context)
 296         return res
 297
 298     def create(self, cr, uid, vals, context=None):
 299         member_line_obj = self.pool.get('membership.membership_line')
 300         res = super(account_invoice_line, self).create(cr, uid, vals, context=context)
 301         line = self.browse(cr, uid, res, context=context)
 302
 303         if line.invoice_id.type == 'out_invoice' and line.product_id and line.product_id.membership:
 304             member_line_id = member_line_obj.search(cr, uid
 305               , [('partner'             , '=', line.invoice_id.partner_id.id)
 306                 ,('account_invoice_line', '=', line.id)]
 307               , limit=1
 308               , context=context)
 309             for member_line in member_line_obj.browse(cr, uid, member_line_id, context=context):
 310               # NOTE: get member_line created in membership.account_invoice_line.create
 311                 date_from = member_line.date_from
 312                 date_to   = member_line.date_to
 313                 if line.product_id.membership_date2date:
 314                     date_from = ('date_from' in context
 315                       and context['date_from']
 316                       and datetime.strptime(context['date_from'], "%Y-%m-%d")
 317                       or date.today())
 318                     date_to   = date_from + relativedelta(months = +12) # TODO: parameterize this delta?
 319                     date_from = date_from.strftime("%Y-%m-%d")
 320                     date_to   = date_to  .strftime("%Y-%m-%d")
 321                 print ("DEV: [create] date_from: %s" % str(date_from))
 322                 print ("DEV: [create] date_to  : %s" % str(date_to))
 323                 member_line_obj.write(cr, uid, member_line.id
 324                   , {'date_from': date_from
 325                     ,'date_to'  : date_to
 326                     }
 327                   , context=context)
 328             partners = [line.invoice_id.partner_id]
 329             if line.product_id.membership_grouped and line.invoice_id.partner_id.associate_members:
 330                 partners.extend(line.invoice_id.partner_id.associate_members)
 331                 #Adding membership lines just for associate partners
 332                 for associate_member in line.invoice_id.partner_id.associate_members:
 333                     print ("DEV: [create] [associate] date_from: %s" % str(date_from))
 334                     print ("DEV: [create] [associate] date_to  : %s" % str(date_to))
 335                     member_line_obj.create(cr, uid, {
 336                         'partner': associate_member.id,
 337                         'membership_id': line.product_id.id,
 338                         'member_price': line.price_unit,
 339                         'date': time.strftime('%Y-%m-%d'),
 340                         'date_from': date_from,
 341                         'date_to': date_to,
 342                         'account_invoice_line': line.id,
 343                     }, context=context)
 344             elif line.product_id.membership_grouped and not line.invoice_id.partner_id.associate_members:
 345                 raise osv.except_osv(_('Error!!!'), _('You try to invoice grouped membership product to a partner who hasn\'t associated partners.'))
 346             #Define member ident if it's necessary
 347             for i in partners:
 348                 if not i.member_ident:
 349                     mbr_id = self.pool.get('ir.sequence').get(cr, uid, 'member_ident')
 350                     self.pool.get('res.partner').write(cr, uid, i.id, {'member_ident': mbr_id})
 351         return res
 352
 353 account_invoice_line()
 354
 355
 356 class pos_make_payment(osv.osv_memory):
 357     _inherit = 'pos.make.payment'
 358
 359     def check(self, cr, uid, ids, context=None):
 360         """
 361         Auto invoice orders. Temporarly solution before make partner members just with orders, without invoice.
 362         """
 363         res = super(pos_make_payment, self).check(cr, uid, ids, context=context)
 364
 365         order_obj = self.pool.get('pos.order')
 366         order_obj.action_invoice(cr, uid, ids, context=context)
 367
 368         return res
 369
 370 pos_make_payment()
 371
 372 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: