1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
#!/usr/bin/python
# -*- encoding: utf-8 -*-
###########################################################################
# Module Writen to OpenERP, Open Source Management Solution
# Copyright (C) OpenERP Venezuela (<http://openerp.com.ve>).
# All Rights Reserved
# Credits######################################################
# Coded by: Katherine Zaoral <katherine.zaoral@vauxoo.com>
# Coded by: Yanina Aular <yanina.aular@vauxoo.com>
# Planified by: Humberto Arocha <hbto@vauxoo.com>
# Audited by: Nhomar Hernandez <nhomar@vauxoo.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/>.
##########################################################################
from osv import osv
from osv import fields
import mx.DateTime
import time
class account_period(osv.osv):
_inherit = 'account.period'
def _get_period_days(self, cr, uid, init_period, last_period, context=None):
if context is None:
context = {}
#~ TODO: ERASE LINE BEFORE GO-LIVE
# last_period = init_period = 2
date_start = self.browse(
cr, uid, init_period, context=context).date_start
date_stop = self.browse(
cr, uid, last_period, context=context).date_stop
date_start = mx.DateTime.strptime(date_start, '%Y-%m-%d')
date_stop = mx.DateTime.strptime(date_stop, '%Y-%m-%d')
return (date_stop - date_start).day + 1
def previous(self, cr, uid, id, step=1, context=None):
if context is None:
context = {}
period = self.pool.get('account.period').browse(
cr, uid, id, context=context)
user = self.pool.get('res.users').browse(cr, uid, uid, context=context)
#~ TODO: Take into account previous fiscalyear or just the fiscalyear of the period
ids = self.search(cr, uid, [('date_stop', '<=', period.date_start), (
'special', '=', False), ('company_id', '=', user.company_id.id)])
if not ids:
ids = self.search(cr, uid, [('date_stop', '<=', period.date_start), (
'special', '=', True), ('company_id', '=', user.company_id.id)])
if len(ids) >= step:
return ids[-step]
ids3 = self.search(cr, uid, [('special', '=', True), ('company_id', '=', user.company_id.id), (
'fiscalyear_id', '=', context['fiscalyear'])], limit=1)
# return ids3 and ids3[0] or False
return False
account_period()
class account_fiscalyear(osv.osv):
_inherit = "account.fiscalyear"
def _get_fy_period_ids(self, cr, uid, id, special=False, context=None):
if context is None:
context = {}
res = self.pool.get('account.period').search(cr, uid, [special and ('fiscalyear_id', '=', id) or (
'fiscalyear_id', '=', id), ('special', '=', special)], context=context)
return res
def _get_fy_periods(self, cr, uid, id, special=False, context=None):
if context is None:
context = {}
return len(self._get_fy_period_ids(cr, uid, id, special=special, context=context))
def _get_fy_month(self, cr, uid, id, period_id, special=False, context=None):
if context is None:
context = {}
ap_obj = self.pool.get('account.period')
ap_brw = ap_obj.browse(cr, uid, period_id, context=context)
start_date = ap_brw.date_start
#~ TODO: ERASE LINE BEFORE GO-LIVE
# return 1.0
return time.strptime(start_date, '%Y-%m-%d').tm_mon
account_fiscalyear()
class account_move_line(osv.osv):
_inherit = "account.move.line"
def _query_get(self, cr, uid, obj='l', context=None):
query = super(account_move_line, self)._query_get(
cr, uid, obj=obj, context=context)
if context.get('analytic', False):
list_analytic_ids = context.get('analytic')
ids2 = self.pool.get('account.analytic.account').search(cr, uid, [
('parent_id', 'child_of', list_analytic_ids)], context=context)
query += 'AND '+obj+'.analytic_account_id in (%s)' % (
','.join(map(str, ids2)))
if context.get('partner_detail', False):
query += 'AND l.partner_id in (%s)' % (
context.get('partner_detail'))
return query
account_move_line()
|