openerp-dev-web team mailing list archive

["gpa\(Open ERP\)" <gpa@xxxxxxxxxxx>]

gpa(Open ERP) has proposed merging lp:~openerp-dev/openobject-addons/contact_training_duplicate_course into lp:~openobject-training/openobject-addons/training.

Requested reviews:
  Bhumika (OpenERP) (sbh-openerp)

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/contact_training_duplicate_course/+merge/60148

Fixed the duplication of the course in the contact courses tab when more than one course for contact
-- 
https://code.launchpad.net/~openerp-dev/openobject-addons/contact_training_duplicate_course/+merge/60148
Your team OpenERP R&D Team is subscribed to branch lp:~openerp-dev/openobject-addons/contact_training_duplicate_course.

=== modified file 'training/training.py'
--- training/training.py	2011-05-02 04:49:56 +0000
+++ training/training.py	2011-05-06 06:18:28 +0000
@@ -3928,6 +3928,22 @@
             values['reference'] = self.pool.get('ir.sequence').get(cr, uid, 'training.pshr')
         return super(training_participation_stakeholder_request, self).create(cr, uid, values, context)
 
+    def copy(self, cr, uid, id, default=None, context=None):
+        if context is None:
+            context={}
+
+        if not default:
+            default = {}
+        default = default.copy()
+        default.update({
+            'reference': '/',
+            'purchase_order_id': False,
+            'participation_ids' : [],
+        })
+        return super(training_participation_stakeholder_request, self).copy(cr, uid, id, default=default,
+                    context=context)
+
+
     def on_change_job(self, cr, uid, ids, job_id, context=None):
         if not job_id:
             return False
@@ -4423,9 +4439,11 @@
     def init(self, cr):
         tools.drop_view_if_exists(cr, 'training_contact_course')
         cr.execute("CREATE OR REPLACE VIEW training_contact_course as ( "
-                   "SELECT job.id, job.function, rel.course_id, rel.job_id, job.contact_id "
-                   "FROM training_course_job_rel rel, (SELECT id, contact_id, function FROM res_partner_job) AS job "
-                   "WHERE job.id = rel.job_id )")
+                   "SELECT course.id as id, course.id AS course_id, contact.id AS contact_id, job.function AS function "
+                   "FROM training_course course, training_course_job_rel rel, res_partner_job job, res_partner_contact contact "
+                   "WHERE job.id = rel.job_id "
+                   "AND course.id = rel.course_id "
+                   "AND contact.id = job.contact_id )")
 
 training_contact_course()