Purnendu Singh (OpenERP) has proposed merging 
lp:~openerp-dev/openobject-addons/trunk-payroll-contribution-report-state-psi 
into lp:~openerp-dev/openobject-addons/trunk-payroll.

Requested reviews:
  OpenERP R&D Team (openerp-dev)

For more details, see:
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-payroll-contribution-report-state-psi/+merge/66265

hello,

Improve the contribution report so it will now show the payslip lines of those 
payslips only which are in done state.

Thanks
Purnendu Singh
-- 
https://code.launchpad.net/~openerp-dev/openobject-addons/trunk-payroll-contribution-report-state-psi/+merge/66265
Your team OpenERP R&D Team is requested to review the proposed merge of 
lp:~openerp-dev/openobject-addons/trunk-payroll-contribution-report-state-psi 
into lp:~openerp-dev/openobject-addons/trunk-payroll.
=== modified file 'hr_payroll/report/report_contribution_register.py'
--- hr_payroll/report/report_contribution_register.py	2011-06-02 13:00:43 +0000
+++ hr_payroll/report/report_contribution_register.py	2011-06-29 09:24:43 +0000
@@ -54,6 +54,7 @@
                         "LEFT JOIN hr_payslip AS hp on (pl.slip_id = hp.id) "\
                         "WHERE (hp.date_from >= %s) AND (hp.date_to <= %s) "\
                         "AND pl.register_id = %s "\
+                        "AND hp.state = 'done' "\
                         "ORDER BY pl.slip_id, pl.sequence",
                         (self.date_from, self.date_to, obj.id))
         payslip_lines = [x[0] for x in self.cr.fetchall()]

_______________________________________________
Mailing list: https://launchpad.net/~openerp-dev-gtk
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~openerp-dev-gtk
More help   : https://help.launchpad.net/ListHelp

Reply via email to