1
=== modified file 'account_financial_report_webkit/account_move_line.py'
2
--- account_financial_report_webkit/account_move_line.py	2012-12-11 16:32:26 +0000
3
+++ account_financial_report_webkit/account_move_line.py	2014-04-25 13:34:20 +0000
4
@@ -28,24 +28,6 @@
5
28
    Last rec date is the date of the last reconciliation (full or partial) account move line"""
28
    Last rec date is the date of the last reconciliation (full or partial) account move line"""
6
29
    _inherit = 'account.move.line'
29
    _inherit = 'account.move.line'
7
30
30
8
31
    def init(self, cr):
9
32
        ##We do not want to catch error as if sql is not run it will give invalid data
10
33
        cr.execute("UPDATE account_move_line as acm "
11
34
                   " SET last_rec_date ="
12
35
                   "     (SELECT date from account_move_line"
13
36
                   "          WHERE reconcile_id =  acm.reconcile_id"
14
37
                   "              AND reconcile_id IS NOT NULL"
15
38
                   "          ORDER BY date DESC LIMIT 1)"
16
39
                   " WHERE last_rec_date is null;")
17
40
18
41
        cr.execute("UPDATE account_move_line as acm "
19
42
                   " SET last_rec_date ="
20
43
                   "     (SELECT date from account_move_line"
21
44
                   "          WHERE reconcile_partial_id =  acm.reconcile_partial_id"
22
45
                   "              AND reconcile_partial_id IS NOT NULL"
23
46
                   "          ORDER BY date DESC LIMIT 1)"
24
47
                   " WHERE last_rec_date is null;")
25
48
26
49
    def _get_move_line_from_line_rec(self, cr, uid, ids, context=None):
31
    def _get_move_line_from_line_rec(self, cr, uid, ids, context=None):
27
50
        moves = []
32
        moves = []
28
51
        for reconcile in self.pool.get('account.move.reconcile').browse(cr, uid, ids, context=context):
33
        for reconcile in self.pool.get('account.move.reconcile').browse(cr, uid, ids, context=context):
29
52
34
30
=== added directory 'account_financial_report_webkit/migrations'
31
=== added directory 'account_financial_report_webkit/migrations/7.0.1.0.2'
32
=== added file 'account_financial_report_webkit/migrations/7.0.1.0.2/post-migration.py'
33
--- account_financial_report_webkit/migrations/7.0.1.0.2/post-migration.py	1970-01-01 00:00:00 +0000
34
+++ account_financial_report_webkit/migrations/7.0.1.0.2/post-migration.py	2014-04-25 13:34:20 +0000
35
@@ -0,0 +1,39 @@
36
1
# -*- encoding: utf-8 -*-
37
2
##############################################################################
38
3
#
39
4
#    Author: Nicolas Bessi.
40
5
#    Copyright Camptocamp SA 2011
41
6
#
42
7
#    This program is free software: you can redistribute it and/or modify
43
8
#    it under the terms of the GNU General Public License as published by
44
9
#    the Free Software Foundation, either version 3 of the License, or
45
10
#    (at your option) any later version.
46
11
#
47
12
#    This program is distributed in the hope that it will be useful,
48
13
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
49
14
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
50
15
#    GNU General Public License for more details.
51
16
#
52
17
#    You should have received a copy of the GNU General Public License
53
18
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
54
19
#
55
20
##############################################################################
56
21
57
22
def migrate(cr, version):
58
23
    if not version:
59
24
        # only run at first install
60
25
        cr.execute("UPDATE account_move_line as acm "
61
26
                   " SET last_rec_date ="
62
27
                   "     (SELECT date from account_move_line"
63
28
                   "          WHERE reconcile_id =  acm.reconcile_id"
64
29
                   "              AND reconcile_id IS NOT NULL"
65
30
                   "          ORDER BY date DESC LIMIT 1)"
66
31
                   " WHERE last_rec_date is null;")
67
32
    
68
33
        cr.execute("UPDATE account_move_line as acm "
69
34
                   " SET last_rec_date ="
70
35
                   "     (SELECT date from account_move_line"
71
36
                   "          WHERE reconcile_partial_id =  acm.reconcile_partial_id"
72
37
                   "              AND reconcile_partial_id IS NOT NULL"
73
38
                   "          ORDER BY date DESC LIMIT 1)"
74
39
                   " WHERE last_rec_date is null;")
Reviewer	Date Requested	Status
Pedro Manuel Baeza		Needs Resubmitting on 2014-08-06
Yannick Vaucher @ Camptocamp	2014-04-25	Needs Information on 2014-05-23
Review via email: mp+217240@code.launchpad.net