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     _columns = {
  36         'member_ident': fields.char('Member identifier', size=64),
  37         'associate_members': fields.one2many('res.partner', 'associate_member', 'Associate members', help='Members who are associated to this partner. If this member buy a membership, the associates members will be members too.'),
  38     }
  39
  40     _sql_constraints = [
  41         ('member_ident_uniq', 'unique(member_ident, company_id)', 'The member identifier must be unique !'),
  42     ]
  43
  44     def _membership_date(self, cr, uid, ids, name, args, context=None):
  45         """Return  date of membership"""
  46         name = name[0]
  47         res = {}
  48         member_line_obj = self.pool.get('membership.membership_line')
  49         for partner in self.browse(cr, uid, ids, context=context):
  50             #if partner.associate_member:
  51             #     partner_id = partner.associate_member.id
  52             #else:
  53             # NOTE: hmm, ça devrait être toujours partner.id
  54             partner_id = partner.id
  55             res[partner.id] = {
  56                  'membership_start': False,
  57                  'membership_stop': False,
  58                  'membership_cancel': False
  59             }
  60             if name == 'membership_start':
  61                 line_id = member_line_obj.search(cr, uid, [('partner', '=', partner_id),('date_cancel','=',False)],
  62                             limit=1, order='date_from', context=context)
  63                 if line_id:
  64                         res[partner.id]['membership_start'] = member_line_obj.read(cr, uid, line_id[0],
  65                                 ['date_from'], context=context)['date_from']
  66
  67             if name == 'membership_stop':
  68                 line_id1 = member_line_obj.search(cr, uid, [('partner', '=', partner_id),('date_cancel','=',False)],
  69                             limit=1, order='date_to desc', context=context)
  70                 if line_id1:
  71                       res[partner.id]['membership_stop'] = member_line_obj.read(cr, uid, line_id1[0],
  72                                 ['date_to'], context=context)['date_to']
  73
  74             if name == 'membership_cancel':
  75                 if partner.membership_state == 'canceled':
  76                     # NOTE: hmm, partner_id et pas partner.id ?
  77                     line_id2 = member_line_obj.search(cr, uid, [('partner', '=', partner_id)], limit=1, order='date_cancel', context=context)
  78                     if line_id2:
  79                         res[partner.id]['membership_cancel'] = member_line_obj.read(cr, uid, line_id2[0], ['date_cancel'], context=context)['date_cancel']
  80         return res
  81
  82     def create_membership_invoice(self, cr, uid, ids, product_id=None, datas=None, context=None):
  83         # NOTE: use context to supply date_from to account_invoice_line.create
  84         ctx = context and context.copy() or {}
  85         ctx['date_from'] = datas.get('date_from', None)
  86         return super(Partner, self).create_membership_invoice(cr, uid, ids, product_id=product_id, datas=datas, context=ctx)
  87
  88 Partner()
  89
  90
  91 class Product(osv.osv):
  92     _inherit = 'product.product'
  93
  94     _columns = {
  95         'membership_grouped': fields.boolean('Grouped membership product', help='Check if it\'s a grouped membership product.'),
  96         'membership_date2date': fields.boolean('Date to date membership product', required=False, help='Check if it\'s a date to date membership product.'),
  97     }
  98
  99 Product()
 100
 101
 102 class account_invoice_line(osv.osv):
 103     _inherit = 'account.invoice.line'
 104
 105     def write(self, cr, uid, ids, vals, context=None):
 106         member_line_obj = self.pool.get('membership.membership_line')
 107         res = super(account_invoice_line, self).write(cr, uid, ids, vals, context=context)
 108         for line in self.browse(cr, uid, ids, context=context):
 109             if line.invoice_id.type == 'out_invoice':
 110                 ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line', '=', line.id)], context=context)
 111                 if line.product_id and line.product_id.membership:
 112                     member_line_id = member_line_obj.search(cr, uid
 113                       , [('partner'             , '=', line.invoice_id.partner_id.id)
 114                         ,('account_invoice_line', '=', line.id)]
 115                       , limit=1
 116                       , context=context)
 117                     for member_line in member_line_obj.browse(cr, uid, member_line_id, context=context):
 118                       # NOTE: get member_line created in membership.account_invoice_line.create
 119                         date_from = member_line.date_from
 120                         date_to   = member_line.date_to
 121                         if line.product_id.membership_date2date:
 122                             date_from = context['date_from'] and datetime.strptime(context['date_from'], "%Y-%m-%d") or date.today()
 123                             date_to   = date_from + relativedelta(months = +12) # TODO: parameterize this delta?
 124                             date_from = date_from.strftime("%Y-%m-%d")
 125                             date_to   = date_to  .strftime("%Y-%m-%d")
 126                         print ("DEV: [write] date_from: %s" % str(date_from))
 127                         print ("DEV: [write] date_to  : %s" % str(date_to))
 128                         member_line_obj.write(cr, uid, member_line.id
 129                           , {'date_from': date_from
 130                             ,'date_to'  : date_to
 131                             }
 132                           , context=context)
 133                     if line.product_id.membership_grouped:
 134                         if line.invoice_id.partner_id.associate_members:
 135                             for associate_member in line.invoice_id.partner_id.associate_members:
 136                                 print ("DEV: [write] [associate] date_from: %s" % str(date_from))
 137                                 print ("DEV: [write] [associate] date_to  : %s" % str(date_to))
 138                                 member_line_obj.create(cr, uid, {
 139                                     'partner': associate_member.id,
 140                                     'membership_id': line.product_id.id,
 141                                     'member_price': line.price_unit,
 142                                     'date': time.strftime('%Y-%m-%d'),
 143                                     'date_from': date_from,
 144                                     'date_to': date_to,
 145                                     'account_invoice_line': line.id,
 146                                 }, context=context)
 147                         else:
 148                             print("DEV: mettre une contrainte pour l'objet\
 149                                   membership.membership_line interdisant les\
 150                                   adhésions groupées reliées à des partenaires\
 151                                   sans membres associés")
 152                     else:
 153                         associate_ml_ids = member_line_obj.search(cr, uid, [('account_invoice_line', '=', line.id), ('partner', '!=', line.invoice_id.partner_id.id)], context=context)
 154                         member_line_obj.unlink(cr, uid, associate_ml_ids, context=context)
 155
 156                     #Define member ident if it's necessary
 157                     partners = [line.invoice_id.partner_id]
 158                     if line.invoice_id.partner_id.associate_members:
 159                         partners.extend(line.invoice_id.partner_id.associate_members)
 160                     for i in partners:
 161                         if not i.member_ident:
 162                             mbr_id = self.pool.get('ir.sequence').get(cr, uid, 'member_ident')
 163                             self.pool.get('res.partner').write(cr, uid, i.id, {'member_ident': mbr_id})
 164                 if line.product_id and not line.product_id.membership and ml_ids:
 165                     # Product line has changed to a non membership product
 166                     member_line_obj.unlink(cr, uid, ml_ids, context=context)
 167         return res
 168
 169     def create(self, cr, uid, vals, context=None):
 170         member_line_obj = self.pool.get('membership.membership_line')
 171         res = super(account_invoice_line, self).create(cr, uid, vals, context=context)
 172         line = self.browse(cr, uid, res, context=context)
 173
 174         if line.invoice_id.type == 'out_invoice' and line.product_id and line.product_id.membership:
 175             member_line_id = member_line_obj.search(cr, uid
 176               , [('partner'             , '=', line.invoice_id.partner_id.id)
 177                 ,('account_invoice_line', '=', line.id)]
 178               , limit=1
 179               , context=context)
 180             for member_line in member_line_obj.browse(cr, uid, member_line_id, context=context):
 181               # NOTE: get member_line created in membership.account_invoice_line.create
 182                 date_from = member_line.date_from
 183                 date_to   = member_line.date_to
 184                 if line.product_id.membership_date2date:
 185                     print "DEV: line.product_id.membership_date2date"
 186                     date_from = context['date_from'] and datetime.strptime(context['date_from'], "%Y-%m-%d") or date.today()
 187                     date_to   = date_from + relativedelta(months = +12) # TODO: parameterize this delta?
 188                     date_from = date_from.strftime("%Y-%m-%d")
 189                     date_to   = date_to  .strftime("%Y-%m-%d")
 190                 print ("DEV: [create] date_from: %s" % str(date_from))
 191                 print ("DEV: [create] date_to  : %s" % str(date_to))
 192                 member_line_obj.write(cr, uid, member_line.id
 193                   , {'date_from': date_from
 194                     ,'date_to'  : date_to
 195                     }
 196                   , context=context)
 197             partners = [line.invoice_id.partner_id]
 198             if line.product_id.membership_grouped and line.invoice_id.partner_id.associate_members:
 199                 partners.extend(line.invoice_id.partner_id.associate_members)
 200                 #Adding membership lines just for associate partners
 201                 for associate_member in line.invoice_id.partner_id.associate_members:
 202                     print ("DEV: [create] [associate] date_from: %s" % str(date_from))
 203                     print ("DEV: [create] [associate] date_to  : %s" % str(date_to))
 204                     member_line_obj.create(cr, uid, {
 205                         'partner': associate_member.id,
 206                         'membership_id': line.product_id.id,
 207                         'member_price': line.price_unit,
 208                         'date': time.strftime('%Y-%m-%d'),
 209                         'date_from': date_from,
 210                         'date_to': date_to,
 211                         'account_invoice_line': line.id,
 212                     }, context=context)
 213             elif line.product_id.membership_grouped and not line.invoice_id.partner_id.associate_members:
 214                 raise osv.except_osv(_('Error!!!'), _('You try to invoice grouped membership product to a partner who hasn\'t associated partners.'))
 215             #Define member ident if it's necessary
 216             for i in partners:
 217                 if not i.member_ident:
 218                     mbr_id = self.pool.get('ir.sequence').get(cr, uid, 'member_ident')
 219                     self.pool.get('res.partner').write(cr, uid, i.id, {'member_ident': mbr_id})
 220         return res
 221
 222 account_invoice_line()
 223
 224
 225 class pos_make_payment(osv.osv_memory):
 226     _inherit = 'pos.make.payment'
 227
 228     def check(self, cr, uid, ids, context=None):
 229         """
 230         Auto invoice orders. Temporarly solution before make partner members just with orders, without invoice.
 231         """
 232         res = super(pos_make_payment, self).check(cr, uid, ids, context=context)
 233
 234         order_obj = self.pool.get('pos.order')
 235         order_obj.action_invoice(cr, uid, ids, context=context)
 236
 237         return res
 238
 239 pos_make_payment()
 240
 241 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: