1
# -*- coding: utf-8 -*-
2
##############################################################################
4
# OpenERP, Open Source Management Solution
5
# Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
7
# This program is free software: you can redistribute it and/or modify
8
# it under the terms of the GNU Affero General Public License as
9
# published by the Free Software Foundation, either version 3 of the
10
# License, or (at your option) any later version.
12
# This program is distributed in the hope that it will be useful,
13
# but WITHOUT ANY WARRANTY; without even the implied warranty of
14
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15
# GNU Affero General Public License for more details.
17
# You should have received a copy of the GNU Affero General Public License
18
# along with this program. If not, see <http://www.gnu.org/licenses/>.
20
##############################################################################
23
from osv import fields,osv
24
from decimal_precision import decimal_precision as dp
27
class query_cash_in_out(osv.osv):
29
_name = 'account.query_cash_in_out'
30
_description = 'Query Cash In/Out'
33
'name' : fields.char(string='Description', size=64),
34
'move_id' : fields.many2one(string='# Move', obj='account.move'),
35
'account_id' : fields.many2one(string='Account', obj='account.account'),
36
'company_id' : fields.many2one(string='Company', obj='res.company'),
37
'date' : fields.date(string='Date'),
38
'journal_id' : fields.many2one(string='Journal', obj='account.journal'),
39
'partner_id' : fields.many2one(string='Partner', obj='res.partner'),
40
'period_id' : fields.many2one(string='Period', obj='account.period'),
41
'debit' : fields.float(string='Debit'),
42
'credit' : fields.float(string='Credit'),
48
tools.drop_view_if_exists(cr, 'account_query_cash_in_out')
50
CREATE OR REPLACE VIEW account_query_cash_in_out AS (
55
A.account_id AS account_id,
56
B.company_id AS company_id,
58
B.journal_id AS journal_id,
59
A.partner_id AS partner_id,
60
B.period_id AS period_id,
63
FROM account_move_line AS A
64
JOIN account_move AS B ON A.move_id = B.id
65
JOIN account_journal C ON B.journal_id = C.id
66
WHERE (C.type = 'cash' OR C.type = 'bank') AND
76
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: