-# -*- encoding: utf-8 -*-
+# -*- coding: utf-8 -*-
##############################################################################
#
-# Copyright (c) 2007 TINY SPRL. (http://tiny.be) All Rights Reserved.
+# OpenERP, Open Source Management Solution
+# Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as
+# published by the Free Software Foundation, either version 3 of the
+# License, or (at your option) any later version.
#
-# WARNING: This program as such is intended to be used by professional
-# programmers who take the whole responsability of assessing all potential
-# consequences resulting from its eventual inadequacies and bugs
-# End users who are looking for a ready-to-use solution with commercial
-# garantees and support are strongly adviced to contract a Free Software
-# Service Company
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
#
-# This program is Free Software; you can redistribute it and/or
-# modify it under the terms of the GNU General Public License
-# as published by the Free Software Foundation; either version 2
-# of the License, or (at your option) any later version.
-#
-# This program is distributed in the hope that it will be useful,
-# but WITHOUT ANY WARRANTY; without even the implied warranty of
-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-# GNU General Public License for more details.
-#
-# You should have received a copy of the GNU General Public License
-# along with this program; if not, write to the Free Software
-# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
##############################################################################
import netsvc
import pooler
import tools
+from tools.translate import _
+from crm import crm
class crm_case_log(osv.osv):
_inherit = 'crm.case.log'
}
crm_case_log()
-class one2many_mod_task(fields.one2many):
- def get(self, cr, obj, ids, name, user=None, offset=0, context=None, values=None):
- if not context:
- context = {}
- if not values:
- values = {}
- res = {}
- for id in ids:
- res[id] = []
- for id in ids:
- query = "select project_id from event_event where id = %i" %id
- cr.execute(query)
- project_ids = [ x[0] for x in cr.fetchall()]
- ids2 = obj.pool.get(self._obj).search(cr, user, [(self._fields_id,'in',project_ids),('state','<>','done')], limit=self._limit)
- for r in obj.pool.get(self._obj)._read_flat(cr, user, ids2, [self._fields_id], context=context, load='_classic_write'):
- res[id].append( r['id'] )
- return res
-
class event_type(osv.osv):
_name = 'event.type'
_description= 'Event type'
_order = 'date_begin'
def copy(self, cr, uid, id, default=None, context=None):
- return super(event, self).copy(cr, uid,id, default={'code': self.pool.get('ir.sequence').get(cr, uid, 'event.event'),})
+ return super(event, self).copy(cr, uid,id, default={'code': self.pool.get('ir.sequence').get(cr, uid, 'event.event'),'state':'draft'})
def button_draft(self, cr, uid, ids, context={}):
return self.write(cr, uid, ids, {'state':'draft'})
+
def button_cancel(self, cr, uid, ids, context={}):
return self.write(cr, uid, ids, {'state':'cancel'})
+
def button_done(self, cr, uid, ids, context={}):
return self.write(cr, uid, ids, {'state':'done'})
+
def button_confirm(self, cr, uid, ids, context={}):
+ for eve in self.browse(cr, uid, ids):
+ if eve.mail_auto_confirm:
+ #send reminder that will confirm the event for all the people that were already confirmed
+ reg_ids = self.pool.get('event.registration').search(cr, uid, [('event_id','=',eve.id),('state','not in',['draft','cancel'])])
+ if reg_ids:
+ self.pool.get('event.registration').mail_user_confirm(cr, uid, reg_ids)
return self.write(cr, uid, ids, {'state':'confirm'})
def _get_register(self, cr, uid, ids, name, args, context=None):
res={}
for event in self.browse(cr, uid, ids, context):
- query = """select sum(nb_register) from crm_case c left join crm_case_section s on (c.section_id=s.id) right join event_event e on (e.section_id=s.id) right join event_registration r on (r.case_id=c.id) where e.section_id = %s and c.state in ('open','done')""" % event.section_id.id
- cr.execute(query)
+ query = """select sum(nb_register) from crm_case c left join crm_case_section s on (c.section_id=s.id) right join event_event e on (e.section_id=s.id) right join event_registration r on (r.case_id=c.id) where e.section_id = %s and c.state in ('open','done')"""
+ cr.execute(query,(event.section_id.id,))
res2 = cr.fetchone()
if res2 and res2[0]:
res[event.id] = res2[0]
def _get_prospect(self, cr, uid, ids, name, args, context=None):
res={}
for event in self.browse(cr, uid, ids, context):
- query = """select sum(nb_register) from crm_case c left join crm_case_section s on (c.section_id=s.id) right join event_event e on (e.section_id=s.id) right join event_registration r on (r.case_id=c.id) where e.section_id = %s and c.state = 'draft'""" % event.section_id.id
- cr.execute(query)
+ query = """select sum(nb_register) from crm_case c left join crm_case_section s on (c.section_id=s.id) right join event_event e on (e.section_id=s.id) right join event_registration r on (r.case_id=c.id) where e.section_id = %s and c.state = 'draft'"""
+ cr.execute(query,(event.section_id.id,))
res2 = cr.fetchone()
if res2 and res2[0]:
res[event.id] = res2[0]
def write(self, cr, uid, ids,vals, *args, **kwargs):
res = super(event,self).write(cr, uid, ids,vals, *args, **kwargs)
if 'date_begin' in vals and vals['date_begin']:
- data_event = self.browse(cr, uid, ids)
- for eve in data_event:
- if eve.project_id:
- self.pool.get('project.project').write(cr, uid, [eve.project_id.id], {'date_end':eve.date_begin})
+ for eve in self.browse(cr, uid, ids):
+ #change the deadlines of the registration linked to this event
+ reg_ids = self.pool.get('event.registration').search(cr, uid, [('event_id','=',eve.id)])
+ if reg_ids:
+ self.pool.get('event.registration').write(cr, uid, reg_ids, {'date_deadline':vals['date_begin']})
+
+ #change the description of the registration linked to this event
+ if 'mail_auto_confirm' in vals:
+ if vals['mail_auto_confirm']:
+ if 'mail_confirm' not in vals:
+ for eve in self.browse(cr, uid, ids):
+ vals['mail_confirm'] = eve.mail_confirm
+ else:
+ vals['mail_confirm']=False
+ if 'mail_confirm' in vals:
+ for eve in self.browse(cr, uid, ids):
+ reg_ids = self.pool.get('event.registration').search(cr, uid, [('event_id','=',eve.id)])
+ if reg_ids:
+ self.pool.get('event.registration').write(cr, uid, reg_ids, {'description':vals['mail_confirm']})
return res
_columns = {
'register_min': fields.integer('Minimum Registrations'),
'register_current': fields.function(_get_register, method=True, string='Confirmed Registrations'),
'register_prospect': fields.function(_get_prospect, method=True, string='Unconfirmed Registrations'),
- 'project_id': fields.many2one('project.project', 'Project', readonly=True),
- 'task_ids': one2many_mod_task('project.task', 'project_id', "Project tasks", readonly=True, domain="[('state','<>', 'done')]"),
'date_begin': fields.datetime('Beginning date', required=True),
'date_end': fields.datetime('Ending date', required=True),
- 'state': fields.selection([('draft','Draft'),('confirm','Confirmed'),('done','Done'),('cancel','Canceled')], 'Status', readonly=True, required=True),
- 'mail_auto_registr':fields.boolean('Mail Auto Register',help='A mail is sent when the registration is confirmed'),
- 'mail_auto_confirm':fields.boolean('Mail Auto Confirm',help='A mail is sent when the event is confimed'),
- 'mail_registr':fields.text('Mail Register',help='Template for the mail'),
- 'mail_confirm':fields.text('Mail Confirm',help='Template for the mail'),
- 'budget_id':fields.many2one('account.budget.post','Budget'),
- 'product_id':fields.many2one('product.product','Product'),
+ 'state': fields.selection([('draft','Draft'),('confirm','Confirmed'),('done','Done'),('cancel','Cancelled')], 'State', readonly=True, required=True,
+ help='If event is created, the state is \'Draft\'.\n If event is confirmed for the particular dates the state is set to \'Confirmed\'.\
+ \nIf the event is over, the state is set to \'Done\'.\n If event is cancelled the state is set to \'Cancelled\'.'),
+ 'mail_auto_registr':fields.boolean('Mail Auto Register',help='Check this box if you want to use the automatic mailing for new registration'),
+ 'mail_auto_confirm':fields.boolean('Mail Auto Confirm',help='Check this box if you want ot use the automatic confirmation emailing or the reminder'),
+ 'mail_registr':fields.text('Registration Email',help='This email will be sent when someone subscribes to the event.'),
+ 'mail_confirm': fields.text('Confirmation Email', help="This email will be sent when the event gets confimed or when someone subscribes to a confirmed event. This is also the email sent to remind someone about the event."),
+ 'product_id':fields.many2one('product.product','Product', required=True),
}
+
_defaults = {
'state': lambda *args: 'draft',
'code': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'event.event'),
'user_id': lambda self,cr,uid,ctx: uid,
+
}
event()
class event_registration(osv.osv):
def _history(self, cr, uid,ids,keyword, history=False, email=False, context={}):
- for case in ids:
+ for case in self.browse(cr, uid, ids):
+ if not case.case_id:
+ return True
data = {
'name': keyword,
'som': case.som.id,
def button_reg_close(self, cr, uid, ids, *args):
self.write(cr, uid, ids, {'state':'done',})
- cases = self.browse(cr, uid, ids)
- self._history(cr, uid, cases, 'Done', history=True)
+ self._history(cr, uid, ids, 'Done', history=True)
return True
def button_reg_cancel(self, cr, uid, ids, *args):
self.write(cr, uid, ids, {'state':'cancel',})
- cases = self.browse(cr, uid, ids)
- self._history(cr, uid, cases, 'Cancel', history=True)
+ self._history(cr, uid, ids, 'Cancel', history=True)
return True
def create(self, cr, uid, *args, **argv):
- args[0]['section_id']= self.pool.get('event.event').browse(cr, uid, args[0]['event_id'], None).section_id.id
+ event = self.pool.get('event.event').browse(cr, uid, args[0]['event_id'], None)
+ args[0]['section_id']= event.section_id.id
+ args[0]['date_deadline']= event.date_begin
+ args[0]['description']= event.mail_confirm
res = super(event_registration, self).create(cr, uid, *args, **argv)
- self._history(cr, uid,self.browse(cr, uid, [res]), 'Created', history=True)
+ self._history(cr, uid,[res], 'Created', history=True)
return res
def write(self, cr, uid, *args, **argv):
if 'event_id' in args[1]:
- args[1]['section_id']= self.pool.get('event.event').browse(cr, uid, args[1]['event_id'], None).section_id.id
+ event = self.pool.get('event.event').browse(cr, uid, args[1]['event_id'], None)
+ args[1]['section_id']= event.section_id.id
+ args[1]['date_deadline']= event.date_begin
+ args[1]['description']= event.mail_confirm
return super(event_registration, self).write(cr, uid, *args, **argv)
+ def mail_user_confirm(self,cr,uid,ids):
+ reg_ids=self.browse(cr,uid,ids)
+ for reg_id in reg_ids:
+ src = reg_id.event_id.reply_to or False
+ dest = [reg_id.email_from]
+ if reg_id.email_cc:
+ dest += [reg_id.email_cc]
+ if dest and src:
+ tools.email_send(src, dest,'Auto Confirmation: '+'['+str(reg_id.id)+']'+' '+reg_id.name, reg_id.event_id.mail_confirm, openobject_id = str(reg_id.case_id.id))
+ if not src:
+ raise osv.except_osv(_('Error!'), _('You must define a reply-to address in order to mail the participant. You can do this in the Mailing tab of your event. Note that this is also the place where you can configure your event to not send emails automaticly while registering'))
+ return False
+
def mail_user(self,cr,uid,ids):
- src=tools.config.options['smtp_user']
reg_ids=self.browse(cr,uid,ids)
for reg_id in reg_ids:
- dest=reg_id.email_from
- if (reg_id.event_id.state in ['confirm','running']) and reg_id.event_id.mail_auto_confirm:
- if dest:
- tools.email_send(src,[dest],'Auto Confirmation: '+'['+str(reg_id.id)+']'+' '+reg_id.name,reg_id.event_id.mail_confirm)
- return True
- # Sending another mail
- if reg_id.event_id.state in ['draft', 'fixed', 'open','confirm','running'] and reg_id.event_id.mail_auto_registr:
- if dest:
- tools.email_send(src,[dest],'Auto Registration: '+'['+str(reg_id.id)+']'+' '+reg_id.name,reg_id.event_id.mail_registr)
- return True
+ src = reg_id.event_id.reply_to or False
+ dest = [reg_id.email_from]
+ if reg_id.email_cc:
+ dest += [reg_id.email_cc]
+ if reg_id.event_id.mail_auto_confirm or reg_id.event_id.mail_auto_registr:
+ if dest and src:
+ if reg_id.event_id.state in ['draft', 'fixed', 'open','confirm','running'] and reg_id.event_id.mail_auto_registr:
+ tools.email_send(src, dest,'Auto Registration: '+'['+str(reg_id.id)+']'+' '+reg_id.name, reg_id.event_id.mail_registr, openobject_id = str(reg_id.case_id.id))
+ if (reg_id.event_id.state in ['confirm','running']) and reg_id.event_id.mail_auto_confirm:
+ tools.email_send(src, dest,'Auto Confirmation: '+'['+str(reg_id.id)+']'+' '+reg_id.name, reg_id.event_id.mail_confirm, openobject_id = str(reg_id.case_id.id))
+ if not src:
+ raise osv.except_osv(_('Error!'), _('You must define a reply-to address in order to mail the participant. You can do this in the Mailing tab of your event. Note that this is also the place where you can configure your event to not send emails automaticly while registering'))
return False
+ def _create_invoice_lines(self, cr, uid, ids, vals):
+ return self.pool.get('account.invoice.line').create(cr, uid,vals )
+
_name= 'event.registration'
_description = 'Event Registration'
_inherits = {'crm.case': 'case_id'}
_columns = {
'case_id':fields.many2one('crm.case','Case'),
'nb_register': fields.integer('Number of Registration', readonly=True, states={'draft':[('readonly',False)]}),
- "partner_order_id":fields.many2one('res.partner','Partner Order'),
'event_id':fields.many2one('event.event', 'Event Related', required=True),
- "partner_invoice_id":fields.many2one('res.partner', 'Partner Invoice'),
+ "partner_invoice_id":fields.many2one('res.partner', 'Partner Invoiced'),
+ "contact_id":fields.many2one('res.partner.contact', 'Partner Contact'), #TODO: filter only the contacts that have a function into the selected partner_id
"unit_price": fields.float('Unit Price'),
"badge_title":fields.char('Badge Title',size=128),
"badge_name":fields.char('Badge Name',size=128),
"invoice_label":fields.char("Label Invoice",size=128,required=True),
"tobe_invoiced":fields.boolean("To be Invoiced"),
"invoice_id":fields.many2one("account.invoice","Invoice"),
+ 'date_closed': fields.datetime('Closed', readonly=True),
+ 'ref' : fields.reference('Reference', selection=crm._links_get, size=128),
+ 'ref2' : fields.reference('Reference 2', selection=crm._links_get, size=128),
+ 'categ_id': fields.many2one('crm.case.categ','Category', domain="[('section_id','=',section_id)]"),
+ 'canal_id': fields.many2one('res.partner.canal', 'Channel',help="The channels represent the different communication modes available with the customer." \
+ " With each commercial opportunity, you can indicate the canall which is this opportunity source."),
+ 'som': fields.many2one('res.partner.som', 'State of Mind', help="The minds states allow to define a value scale which represents" \
+ "the partner mentality in relation to our services.The scale has" \
+ "to be created with a factor for each level from 0 (Very dissatisfied) to 10 (Extremely satisfied)."),
+
}
_defaults = {
'nb_register': lambda *a: 1,
'tobe_invoiced' : lambda *a: True,
- 'name': lambda *a: 'Registration'
+ 'name': lambda *a: 'Registration',
+ 'state': lambda *b: 'draft'
}
def onchange_badge_name(self, cr, uid, ids, badge_name):
data['name'] = 'Registration: ' + badge_name
return {'value':data}
- def onchange_contact_id(self, cr, uid, ids, contact_id):
+ def onchange_contact_id(self, cr, uid, ids, contact, partner):
data ={}
- if not contact_id:
+ if not contact:
return data
- obj_addr=self.pool.get('res.partner.address').browse(cr, uid, contact_id)
- data['email_from'] = obj_addr.email
-
- if obj_addr.contact_id:
- data['badge_name']=obj_addr.contact_id.name
- data['badge_title']=obj_addr.contact_id.title
- d=self.onchange_badge_name(cr, uid, ids,data['badge_name'])
- data.update(d['value'])
+ contact_id = self.pool.get('res.partner.contact').browse(cr, uid, contact)
+ data['badge_name'] = contact_id.name
+ data['badge_title'] = contact_id.title
+ if partner:
+ partner_addresses = self.pool.get('res.partner.address').search(cr, uid, [('partner_id','=',partner)])
+ job_ids = self.pool.get('res.partner.job').search(cr, uid, [('contact_id','=',contact),('address_id','in',partner_addresses)])
+ if job_ids:
+ data['email_from'] = self.pool.get('res.partner.job').browse(cr, uid, job_ids[0]).email
+ d = self.onchange_badge_name(cr, uid, ids,data['badge_name'])
+ data.update(d['value'])
return {'value':data}
return {'value':{'unit_price' : False,'invoice_label' : False}}
- def onchange_partner_id(self, cr, uid, ids, part, event_id, email=False):#override function for partner name.
+ def onchange_partner_id(self, cr, uid, ids, part, event_id, email=False):
data={}
- data['badge_partner']=data['partner_address_id']=data['partner_invoice_id']=data['email_from']=data['badge_title']=data['badge_name']=False
+ data['badge_partner'] = data['contact_id'] = data['partner_invoice_id'] = data['email_from'] = data['badge_title'] = data['badge_name'] = False
if not part:
return {'value':data}
-
data['partner_invoice_id']=part
# this calls onchange_partner_invoice_id
- d=self.onchange_partner_invoice_id(cr, uid, ids, event_id,part)
+ d = self.onchange_partner_invoice_id(cr, uid, ids, event_id,part)
# this updates the dictionary
data.update(d['value'])
- addr = self.pool.get('res.partner').address_get(cr, uid, [part], ['contact'])
- data['partner_address_id']=addr['contact']
- if addr['contact']:
- d=self.onchange_contact_id(cr, uid, ids,addr['contact'])
- data.update(d['value'])
- partner_data=self.pool.get('res.partner').browse(cr, uid, part)
- data['badge_partner']=partner_data.name
+ addr = self.pool.get('res.partner').address_get(cr, uid, [part])
+ if addr:
+ if addr.has_key('default'):
+ job_ids = self.pool.get('res.partner.job').search(cr, uid, [('address_id','=',addr['default'])])
+ if job_ids:
+ data['contact_id'] = self.pool.get('res.partner.job').browse(cr, uid, job_ids[0]).contact_id.id
+ d = self.onchange_contact_id(cr, uid, ids, data['contact_id'],part)
+ data.update(d['value'])
+ partner_data = self.pool.get('res.partner').browse(cr, uid, part)
+ data['badge_partner'] = partner_data.name
return {'value':data}
def onchange_partner_invoice_id(self, cr, uid, ids, event_id, partner_invoice_id):
case_data = self.browse(cr,uid,ids)
new_ids=[]
for case in case_data:
- new_ids.append(case.case_id.id)
+ if case.case_id:
+ new_ids.append(case.case_id.id)
return getattr(self.pool.get('crm.case'),method)(cr, uid, new_ids, *args, **argv)
projects / odoo / odoo.git / blobdiff