openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #01006
[Merge] lp:~openerp-dev/openerp-india/payroll-india-yearly-report-psi into lp:~openerp-dev/openerp-india/payroll-india
Purnendu Singh (OpenERP) has proposed merging lp:~openerp-dev/openerp-india/payroll-india-yearly-report-psi into lp:~openerp-dev/openerp-india/payroll-india.
Requested reviews:
OpenERP R&D Team (openerp-dev)
For more details, see:
https://code.launchpad.net/~openerp-dev/openerp-india/payroll-india-yearly-report-psi/+merge/82104
Hello,
Added a new report to get details of employee's payslips by year.
Thanks,
Purnendu singh
--
https://code.launchpad.net/~openerp-dev/openerp-india/payroll-india-yearly-report-psi/+merge/82104
Your team OpenERP Indian Team is subscribed to branch lp:~openerp-dev/openerp-india/payroll-india.
=== modified file 'l10n_in_hr_payroll/__init__.py'
--- l10n_in_hr_payroll/__init__.py 2011-10-11 07:03:15 +0000
+++ l10n_in_hr_payroll/__init__.py 2011-11-14 07:29:29 +0000
@@ -1,8 +1,7 @@
-# -*- encoding: utf-8 -*-
+# -*- coding: utf-8 -*-
##############################################################################
#
-# OpenERP, Open Source Management Solution
-# Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as
@@ -21,6 +20,7 @@
import hr_payroll
import l10n_in_hr_payroll
+import wizard
import report
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
\ No newline at end of file
=== modified file 'l10n_in_hr_payroll/__openerp__.py'
--- l10n_in_hr_payroll/__openerp__.py 2011-10-11 07:21:41 +0000
+++ l10n_in_hr_payroll/__openerp__.py 2011-11-14 07:29:29 +0000
@@ -1,8 +1,7 @@
-# -*- encoding: utf-8 -*-
+# -*- coding: utf-8 -*-
##############################################################################
#
-# OpenERP, Open Source Management Solution
-# Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as
@@ -18,6 +17,7 @@
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
##############################################################################
+
{
'name': 'Human Resource Payroll for India',
'category': 'Human Resources',
@@ -45,8 +45,10 @@
'update_xml': [
'l10n_in_hr_payroll_view.xml',
'l10n_in_hr_payroll_data.xml',
+ 'l10n_in_hr_payroll_wizard.xml',
'data/hr.salary.rule.csv',
'l10n_in_hr_payroll_report.xml',
+ 'wizard/hr_payroll_summary_year_view.xml',
],
'demo_xml': ['l10n_in_hr_payroll_demo.xml'],
'installable': True
=== modified file 'l10n_in_hr_payroll/l10n_in_hr_payroll.py'
--- l10n_in_hr_payroll/l10n_in_hr_payroll.py 2011-10-07 10:29:26 +0000
+++ l10n_in_hr_payroll/l10n_in_hr_payroll.py 2011-11-14 07:29:29 +0000
@@ -1,13 +1,12 @@
-#-*- coding:utf-8 -*-
+# -*- coding: utf-8 -*-
##############################################################################
#
-# OpenERP, Open Source Management Solution
-# Copyright (C) 2011 OpenERP SA (<http://openerp.com>). All Rights Reserved
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
#
# 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.
+# 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.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
=== modified file 'l10n_in_hr_payroll/l10n_in_hr_payroll_report.xml'
--- l10n_in_hr_payroll/l10n_in_hr_payroll_report.xml 2011-10-12 05:51:55 +0000
+++ l10n_in_hr_payroll/l10n_in_hr_payroll_report.xml 2011-11-14 07:29:29 +0000
@@ -1,14 +1,22 @@
<?xml version="1.0"?>
<openerp>
- <data>
-
- <report
- auto="False"
- id="payslip_details_report"
- model="hr.payslip"
- name="paylip.details.in"
- rml="l10n_in_hr_payroll/report/report_payslip_details.rml"
- string="PaySlip Details" />
-
- </data>
+ <data>
+ <report
+ auto="False"
+ id="payslip_details_report"
+ model="hr.payslip"
+ name="paylip.details.in"
+ rml="l10n_in_hr_payroll/report/report_payslip_details.rml"
+ string="PaySlip Details" />
+
+ <report
+ auto="False"
+ menu="False"
+ id="account_general_ledger_landscape"
+ model="hr.payslip"
+ name="payslip.year.landscape"
+ rml="l10n_in_hr_payroll/report/report_payslip_year_landscape.rml"
+ string="Yearly Payslips"/>
+
+ </data>
</openerp>
=== added file 'l10n_in_hr_payroll/l10n_in_hr_payroll_wizard.xml'
--- l10n_in_hr_payroll/l10n_in_hr_payroll_wizard.xml 1970-01-01 00:00:00 +0000
+++ l10n_in_hr_payroll/l10n_in_hr_payroll_wizard.xml 2011-11-14 07:29:29 +0000
@@ -0,0 +1,18 @@
+<?xml version="1.0" ?>
+<openerp>
+ <data>
+
+ <menuitem
+ id="hr.menu_hr_reporting"
+ name="Reporting"
+ parent="hr.menu_hr_root"
+ sequence="10" />
+
+ <menuitem
+ id="menu_hr_reporting_payroll"
+ name="payroll"
+ parent="hr.menu_hr_reporting"
+ sequence="15"/>
+
+ </data>
+</openerp>
=== modified file 'l10n_in_hr_payroll/report/__init__.py'
--- l10n_in_hr_payroll/report/__init__.py 2011-10-11 07:03:15 +0000
+++ l10n_in_hr_payroll/report/__init__.py 2011-11-14 07:29:29 +0000
@@ -1,16 +1,12 @@
-#!/usr/bin/env python
-#-*- coding:utf-8 -*-
-
+# -*- coding: utf-8 -*-
##############################################################################
#
-# OpenERP, Open Source Management Solution
-# Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). All Rights Reserved
-# d$
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
#
# 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.
+# 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.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
@@ -23,5 +19,6 @@
##############################################################################
import report_payslip_details
+import yearly_payslips
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
=== modified file 'l10n_in_hr_payroll/report/report_payslip_details.py'
--- l10n_in_hr_payroll/report/report_payslip_details.py 2011-10-11 07:03:15 +0000
+++ l10n_in_hr_payroll/report/report_payslip_details.py 2011-11-14 07:29:29 +0000
@@ -1,16 +1,12 @@
-#!/usr/bin/env python
-#-*- coding:utf-8 -*-
-
+# -*- coding: utf-8 -*-
##############################################################################
#
-# OpenERP, Open Source Management Solution
-# Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>). All Rights Reserved
-# d$
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
#
# 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.
+# 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.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
=== added file 'l10n_in_hr_payroll/report/report_payslip_year_landscape.rml'
--- l10n_in_hr_payroll/report/report_payslip_year_landscape.rml 1970-01-01 00:00:00 +0000
+++ l10n_in_hr_payroll/report/report_payslip_year_landscape.rml 2011-11-14 07:29:29 +0000
@@ -0,0 +1,339 @@
+<?xml version="1.0"?>
+<document filename="test.pdf">
+ <template pageSize="(842.0,595.0)" title="Test" author="Martin Simon" allowSplitting="20">
+ <pageTemplate id="first">
+ <frame id="first" x1="28.0" y1="42.0" width="786" height="511"/>
+ </pageTemplate>
+ </template>
+ <stylesheet>
+ <blockTableStyle id="Standard_Outline">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ </blockTableStyle>
+ <blockTableStyle id="Table_Header_Title">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ </blockTableStyle>
+ <blockTableStyle id="Table1">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
+ <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
+ </blockTableStyle>
+ <blockTableStyle id="Table4">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
+ <lineStyle kind="LINEAFTER" colorName="#cccccc" start="1,0" stop="1,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
+ </blockTableStyle>
+ <blockTableStyle id="Table5">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
+ <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
+ </blockTableStyle>
+ <blockTableStyle id="Table6">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="0,0" stop="0,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="0,0" stop="0,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="0,-1" stop="0,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="1,0" stop="1,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="1,0" stop="1,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="1,-1" stop="1,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="2,0" stop="2,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="2,0" stop="2,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="2,-1" stop="2,-1"/>
+ <lineStyle kind="LINEBEFORE" colorName="#cccccc" start="3,0" stop="3,-1"/>
+ <lineStyle kind="LINEAFTER" colorName="#cccccc" start="3,0" stop="3,-1"/>
+ <lineStyle kind="LINEABOVE" colorName="#cccccc" start="3,0" stop="3,0"/>
+ <lineStyle kind="LINEBELOW" colorName="#cccccc" start="3,-1" stop="3,-1"/>
+ </blockTableStyle>
+ <blockTableStyle id="Table2">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="0,-1" stop="0,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="1,-1" stop="1,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="2,-1" stop="2,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="3,-1" stop="3,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="4,-1" stop="4,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="5,-1" stop="5,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="6,-1" stop="6,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="7,-1" stop="7,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="8,-1" stop="8,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="9,-1" stop="9,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="10,-1" stop="10,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="11,-1" stop="11,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="12,-1" stop="12,-1"/>
+ <lineStyle kind="LINEBELOW" colorName="#000000" start="13,-1" stop="13,-1"/>
+ </blockTableStyle>
+ <blockTableStyle id="Table3">
+ <blockAlignment value="LEFT"/>
+ <blockValign value="TOP"/>
+ </blockTableStyle>
+ <initialize>
+ <paraStyle name="all" alignment="justify"/>
+ </initialize>
+ <paraStyle name="P1" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="P2" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="P3" rightIndent="-56.0" leftIndent="0.0" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="P4" fontName="Helvetica" fontSize="2.0" leading="3"/>
+ <paraStyle name="P5" fontName="Helvetica-Bold" fontSize="14.0" leading="17" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
+ <paraStyle name="P6" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="P7" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="P8" rightIndent="0.0" leftIndent="0.0" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="P9" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="Standard" fontName="Helvetica"/>
+ <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+ <paraStyle name="Table Contents" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+ <paraStyle name="Table Heading" fontName="Helvetica" alignment="CENTER" spaceBefore="0.0" spaceAfter="6.0"/>
+ <paraStyle name="Heading" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="12.0" spaceAfter="6.0"/>
+ <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+ <paraStyle name="Caption" fontName="Helvetica-Oblique" fontSize="9.0" leading="11" spaceBefore="6.0" spaceAfter="6.0"/>
+ <paraStyle name="Index" fontName="Helvetica"/>
+ <paraStyle name="Footer" fontName="Helvetica"/>
+ <paraStyle name="Horizontal Line" fontName="Helvetica" fontSize="6.0" leading="8" spaceBefore="0.0" spaceAfter="14.0"/>
+ <paraStyle name="terp_header" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+ <paraStyle name="Heading 9" fontName="Helvetica-Bold" fontSize="75%" leading="NaN" spaceBefore="12.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_tblheader_General" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_tblheader_Details" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="6.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_default_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_Bold_8" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_tblheader_General_Centre" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_tblheader_General_Right" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_tblheader_Details_Centre" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="6.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_tblheader_Details_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="6.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_default_Right_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_Centre_8" fontName="Helvetica" fontSize="8.0" leading="10" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_header_Right" fontName="Helvetica-Bold" fontSize="15.0" leading="19" alignment="LEFT" spaceBefore="12.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_header_Centre" fontName="Helvetica-Bold" fontSize="12.0" leading="15" alignment="CENTER" spaceBefore="12.0" spaceAfter="6.0"/>
+ <paraStyle name="terp_default_address" fontName="Helvetica" fontSize="10.0" leading="13" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_Bold_9" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_Centre_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="CENTER" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_Right_9" fontName="Helvetica" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_2" fontName="Helvetica" fontSize="2.0" leading="3" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="terp_default_Bold_9_Right" fontName="Helvetica-Bold" fontSize="9.0" leading="11" alignment="RIGHT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <paraStyle name="P10" fontName="Helvetica-Bold" fontSize="8.0" leading="10" alignment="LEFT" spaceBefore="0.0" spaceAfter="0.0"/>
+ <images/>
+ </stylesheet>
+ <story>
+ <para style="P3">[[repeatIn(lines(data),'o')]]</para>
+ <para style="terp_default_8">
+ <font color="white"> </font>
+ </para>
+ <para style="terp_default_8">
+ <font color="white"> </font>
+ </para>
+ <blockTable colWidths="262.0,262.0,262.0" style="Table_Header_Title">
+ <tr>
+ <td>
+ <para style="terp_header">
+ <font color="white"> </font>
+ </para>
+ </td>
+ <td>
+ <para style="P5">Payslips by Year</para>
+ </td>
+ <td>
+ <para style="terp_header">
+ <font color="white"> </font>
+ </para>
+ </td>
+ </tr>
+ </blockTable>
+ <blockTable colWidths="93.0,300.0,130.0,263.0" style="Table1">
+ <tr>
+ <td>
+ <para style="P1">Name</para>
+ </td>
+ <td>
+ <para style="P1">[[o.name]]</para>
+ </td>
+ <td>
+ <para style="P1">Designation </para>
+ </td>
+ <td>
+ <para style="P6">[[ o.job_id.name or '' ]]</para>
+ </td>
+ </tr>
+ </blockTable>
+ <blockTable colWidths="93.0,693.0" style="Table4">
+ <tr>
+ <td>
+ <para style="terp_default_Bold_8">
+ <font face="Helvetica">Address </font>
+ </para>
+ </td>
+ <td>
+ <para style="P6">[[o.address_home_id and o.address_home_id.name or '' ]],[[o.address_home_id and o.address_home_id.street or '' ]],[[o.address_home_id and o.address_home_id.street2 or '' ]],[[o.address_home_id and o.address_home_id.zip or '' ]],[[o.address_home_id and o.address_home_id.city or '' ]],[[o.address_home_id and o.address_home_id.state_id and o.address_home_id.state_id.name or '' ]] [[o.address_home_id and o.address_home_id.country_id and o.address_home_id.country_id.name or '' ]]</para>
+ </td>
+ </tr>
+ </blockTable>
+ <blockTable colWidths="93.0,300.0,130.0,263.0" style="Table5">
+ <tr>
+ <td>
+ <para style="P1">Email</para>
+ </td>
+ <td>
+ <para style="P6">[[ o.work_email or '' ]]</para>
+ </td>
+ <td>
+ <para style="terp_default_Bold_8">
+ <font face="Helvetica">Identification No</font>
+ </para>
+ </td>
+ <td>
+ <para style="P6">[[ o.identification_id or '' ]]</para>
+ </td>
+ </tr>
+ </blockTable>
+ <blockTable colWidths="93.0,299.0,130.0,263.0" style="Table6">
+ <tr>
+ <td>
+ <para style="P1">Year</para>
+ </td>
+ <td>
+ <para style="P6">[[ get_year(data) ]]</para>
+ </td>
+ <td>
+ <para style="P1">Bank Account</para>
+ </td>
+ <td>
+ <para style="P6">[[ o.otherid or '' ]]</para>
+ </td>
+ </tr>
+ </blockTable>
+ <para style="Standard">
+ <font color="white"> </font>
+ </para>
+ <blockTable colWidths="71.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0" style="Table2">
+ <tr>
+ <td>
+ <para style="terp_default_Bold_8">Salary Rules</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 0)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 1)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 2)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 3)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 4)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 5)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 6)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 7)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 8)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 9)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 10)]]</para>
+ </td>
+ <td>
+ <para style="P8">[[get_month(data['form']['month'], 11)]]</para>
+ </td>
+ <td>
+ <para style="P7">Total</para>
+ </td>
+ </tr>
+ </blockTable>
+ <section>
+ <para style="P1">[[repeatIn(get_rules(o),'h') ]]</para>
+ <blockTable colWidths="71.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0,55.0" style="Table3">
+ <tr>
+ <td>
+ <para style="P2">
+ <font face="Helvetica">[[ h['code'] ]]</font>
+ </para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 0)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 1)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 2)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 3)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 4)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 5)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 6)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 7)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 8)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 9)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 10)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h[get_month(data['form']['month'], 11)] or '0.0']]</para>
+ </td>
+ <td>
+ <para style="P9">[[ h['total'] or '0.0']] <font face="Helvetica">[[o.company_id and o.company_id.currency_id.symbol or '']] </font></para>
+ </td>
+ </tr>
+ </blockTable>
+ <para style="P4">
+ <font color="white"> </font>
+ </para>
+ </section>
+ </story>
+</document>
+
=== added file 'l10n_in_hr_payroll/report/report_payslip_year_landscape.sxw'
Binary files l10n_in_hr_payroll/report/report_payslip_year_landscape.sxw 1970-01-01 00:00:00 +0000 and l10n_in_hr_payroll/report/report_payslip_year_landscape.sxw 2011-11-14 07:29:29 +0000 differ
=== added file 'l10n_in_hr_payroll/report/yearly_payslips.py'
--- l10n_in_hr_payroll/report/yearly_payslips.py 1970-01-01 00:00:00 +0000
+++ l10n_in_hr_payroll/report/yearly_payslips.py 2011-11-14 07:29:29 +0000
@@ -0,0 +1,117 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
+#
+# 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.
+#
+# 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.
+#
+# 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 datetime
+
+from report import report_sxw
+
+class payslip_year_report(report_sxw.rml_parse):
+
+ def __init__(self, cr, uid, name, context=None):
+ super(payslip_year_report, self).__init__(cr, uid, name, context=context)
+ self.year = ''
+ self.month = ''
+ self.localcontext.update({
+ 'get_rules': self._get_rules,
+ 'get_year': self._get_year,
+ 'get_month': self._get_month_name,
+ 'lines': self._get_lines,
+ 'details_by_month': self._details_by_month,
+ })
+ self.context = context
+
+ def lengthmonth(self, year, month):
+ if month == 2 and ((year % 4 == 0) and ((year % 100 != 0) or (year % 400 == 0))):
+ return 29
+ return [0, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31][month]
+
+ def _get_year(self, data):
+ self.year = data['form']['year']
+ return str(self.year)+ ' - ' +str(self.year + 1)
+
+ def _get_month_name(self, month, column=None):
+ self.month = month
+ months = {1:"Jan", 2:"Feb", 3:"Mar", 4:"Apr", 5:"May", 6:"Jun", 7:"Jul", 8:"Aug", 9:"Sep", 10:"Oct", 11:"Nov", 12:"Dec"}
+ if self.month + column <= 12:
+ month = month + column
+ else:
+ month = (month + column) - 12
+ return months[month]
+
+ def _details_by_month(self, rule, emp_id):
+ res = {}
+ total = 0.0
+ for month in range(1,13):
+ som = datetime.date(self.year+1, month, 1)
+ eom = som + datetime.timedelta(self.lengthmonth(som.year, som.month)-1)
+ if month >= self.month:
+ som = datetime.date(self.year, month, 1)
+ eom = som + datetime.timedelta(self.lengthmonth(som.year, som.month)-1)
+ self.cr.execute("SELECT sum(sl.total) as total FROM hr_payslip_line AS sl "\
+ "LEFT JOIN hr_salary_rule sr ON (sl.salary_rule_id=sr.id) "\
+ "LEFT JOIN hr_payslip hp ON (sl.slip_id=hp.id) "\
+ "WHERE sr.id = %s AND "\
+ "hp.date_from>=%s AND hp.date_to<=%s "\
+ "AND sl.employee_id = %s", (rule.id, som, eom, emp_id)
+ )
+ res[month] = self.cr.fetchone()[0] or 0.0
+ total += res[month]
+ return res, total
+
+ def _get_rules(self, obj):
+ rule_obj = self.pool.get('hr.salary.rule')
+ contract_obj = self.pool.get('hr.contract')
+ struct_obj = self.pool.get('hr.payroll.structure')
+ res = []
+ monthly_details = []
+ self.cr.execute("SELECT hc.id FROM hr_contract AS hc "\
+ "WHERE hc.employee_id = %s" %(obj.id))
+ contract_ids = [x[0] for x in self.cr.fetchall()]
+ structure_ids = contract_obj.get_all_structures(self.cr, self.uid, contract_ids)
+ rule_ids = struct_obj.get_all_rules(self.cr, self.uid, structure_ids)
+ sorted_rule_ids = [id for id, sequence in sorted(rule_ids, key=lambda x:x[1])]
+ for rule in rule_obj.browse(self.cr, self.uid, sorted_rule_ids):
+ monthly_details, total = self._details_by_month(rule, obj.id)
+ res.append({
+ 'name': rule.name,
+ 'code': rule.code,
+ 'Jan': monthly_details[1],
+ 'Feb': monthly_details[2],
+ 'Mar': monthly_details[3],
+ 'Apr': monthly_details[4],
+ 'May': monthly_details[5],
+ 'Jun': monthly_details[6],
+ 'Jul': monthly_details[7],
+ 'Aug': monthly_details[8],
+ 'Sep': monthly_details[9],
+ 'Oct': monthly_details[10],
+ 'Nov': monthly_details[11],
+ 'Dec': monthly_details[12],
+ 'total': total,
+ })
+ return res
+
+
+ def _get_lines(self, data):
+ return self.pool.get('hr.employee').browse(self.cr, self.uid, data['form']['employee_ids'])
+
+report_sxw.report_sxw('report.payslip.year.landscape', 'hr.payslip', 'l10n_in_hr_payroll/report/report_payslip_year_landscape.rml', parser=payslip_year_report, header='internal landscape')
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
=== added directory 'l10n_in_hr_payroll/wizard'
=== added file 'l10n_in_hr_payroll/wizard/__init__.py'
--- l10n_in_hr_payroll/wizard/__init__.py 1970-01-01 00:00:00 +0000
+++ l10n_in_hr_payroll/wizard/__init__.py 2011-11-14 07:29:29 +0000
@@ -0,0 +1,24 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
+#
+# 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.
+#
+# 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.
+#
+# 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 hr_payroll_summary_year
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
=== added file 'l10n_in_hr_payroll/wizard/hr_payroll_summary_year.py'
--- l10n_in_hr_payroll/wizard/hr_payroll_summary_year.py 1970-01-01 00:00:00 +0000
+++ l10n_in_hr_payroll/wizard/hr_payroll_summary_year.py 2011-11-14 07:29:29 +0000
@@ -0,0 +1,55 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+# Copyright (C) 2010 OpenERP s.a. (<http://www.openerp.com>).
+#
+# 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.
+#
+# 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.
+#
+# 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 datetime
+
+from osv import osv, fields
+
+class hr_payroll_summary_year(osv.osv_memory):
+ _name = 'hr.payroll.summary.year'
+ _description = 'HR Payroll Summary Report By Year'
+ _columns = {
+ 'month': fields.selection([(x, datetime.date(2000, x, 1).strftime('%B')) for x in range(1, 13)],
+ 'Starting Month', required=True),
+ 'year': fields.integer('Year', required=True),
+ 'employee_ids': fields.many2many('hr.employee', 'payroll_employee_rel', 'payroll_id', 'employee_id', 'Employee(s)'),
+ }
+
+ _defaults = {
+ 'month': lambda *a: datetime.date.today().month,
+ 'year': lambda *a: datetime.date.today().year,
+ }
+
+ def print_report(self, cr, uid, ids, context=None):
+ data = self.read(cr, uid, ids, [], context=context)[0]
+ datas = {
+ 'ids': [],
+ 'model': 'ir.ui.menu',
+ 'form': data
+ }
+ return {
+ 'type': 'ir.actions.report.xml',
+ 'report_name': 'payslip.year.landscape',
+ 'datas': datas,
+ }
+
+hr_payroll_summary_year()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
=== added file 'l10n_in_hr_payroll/wizard/hr_payroll_summary_year_view.xml'
--- l10n_in_hr_payroll/wizard/hr_payroll_summary_year_view.xml 1970-01-01 00:00:00 +0000
+++ l10n_in_hr_payroll/wizard/hr_payroll_summary_year_view.xml 2011-11-14 07:29:29 +0000
@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+ <data>
+
+ <record id="view_hr_payroll_summary_year" model="ir.ui.view">
+ <field name="name">hr.payroll.summary.year.form</field>
+ <field name="model">hr.payroll.summary.year</field>
+ <field name="type">form</field>
+ <field name="arch" type="xml">
+ <form string="Employee's Payslip">
+ <group colspan="4">
+ <field name="month"/>
+ <field name="year"/>
+ <separator string="Employees" colspan="4"/>
+ <field name="employee_ids" height="250" colspan="4" nolabel="1"/>
+ </group>
+ <separator colspan="4"/>
+ <group colspan="4">
+ <button icon="gtk-cancel" special="cancel" string="Cancel"/>
+ <button icon="gtk-print" string="Print" name="print_report" type="object"/>
+ </group>
+ </form>
+ </field>
+ </record>
+
+ <record id="action_hr_payroll_summary_year" model="ir.actions.act_window">
+ <field name="name">Payslip Year</field>
+ <field name="type">ir.actions.act_window</field>
+ <field name="res_model">hr.payroll.summary.year</field>
+ <field name="view_type">form</field>
+ <field name="view_mode">form</field>
+ <field name="target">new</field>
+ </record>
+
+ <menuitem
+ name="Payslip by Year"
+ parent="menu_hr_reporting_payroll"
+ action="action_hr_payroll_summary_year"
+ id="menu_payslip_year"
+ groups="base.group_extended"
+ icon="STOCK_PRINT"/>
+
+ </data>
+</openerp>
\ No newline at end of file
Follow ups
