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 report import report_sxw
26
def titlize(journal_name):
27
words = journal_name.split()
28
while words.pop() != 'journal':
30
return ' '.join(words)
32
class orderB(report_sxw.rml_parse):
34
def __init__(self, cr, uid, name, context):
35
super(orderB, self).__init__(cr, uid, name, context=context)
37
user = pooler.get_pool(cr.dbname).get('res.users').browse(cr, uid, uid)
38
partner = user.company_id.partner_id
40
self.localcontext.update({
42
'convert': self.convert,
46
'disc': self.discount,
47
'net': self.netamount,
49
'get_journal_amt': self._get_journal_amt,
50
'address': partner.address and partner.address[0] or False,
52
'multiplica': self.multiplica,
55
def convert(self, amount): return self.pool.get('ir.translation').amount_to_text(amount, 'pe', 'Nuevo Sol')
57
def day(self, date): return self.pool.get('ir.translation').date_part(date, 'day', format='number' ,lang='pe')
59
def month(self, date): return self.pool.get('ir.translation').date_part(date, 'month', format='text' ,lang='pe')
61
def year(self, date): return self.pool.get('ir.translation').date_part(date, 'year', format='number' ,lang='pe')
63
def multiplica(self,m,n):
66
def untax(self, order_id):
67
sql = 'select price_unit, qty from pos_order_line where order_id = %s'
68
self.cr.execute(sql, (order_id,))
69
res = self.cr.fetchall()
72
tsum = tsum +line[0] * line[1]
75
def netamount(self, order_line_id):
76
sql = 'select (qty*price_unit) as net_price from pos_order_line where id = %s'
77
self.cr.execute(sql, (order_line_id,))
78
res = self.cr.fetchone()
81
def discount(self, order_id):
82
sql = 'select discount, price_unit, qty from pos_order_line where order_id = %s '
83
self.cr.execute(sql, (order_id,))
84
res = self.cr.fetchall()
88
dsum = dsum +(line[2] * (line[0]*line[1]/100))
91
def _get_journal_amt(self, order_id):
93
sql = """ select aj.name,absl.amount as amt from account_bank_statement as abs
94
LEFT JOIN account_bank_statement_line as absl ON abs.id = absl.statement_id
95
LEFT JOIN account_journal as aj ON aj.id = abs.journal_id
96
WHERE absl.pos_statement_id =%d"""%(order_id)
98
data = self.cr.dictfetchall()
101
report_sxw.report_sxw('report.pos.receipt2.ticket', 'pos.order', 'addons/pos_invoicing/report/pos_receipt2_ticket.rml', parser=orderB, header=False)
103
# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: