1 # -*- encoding: utf-8 -*-
2 ##############################################################################
4 # OpenERP, Open Source Management Solution
5 # Copyright (C) 2004-2009 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 ##############################################################################
22 from osv import fields, osv
24 class lunch_cashbox_clean(osv.osv_memory):
26 _name = "lunch.cashbox.clean"
27 _description = "clean cashbox"
29 def set_to_zero(self, cr, uid, ids, context):
32 clean Cashbox. set active fields False.
33 @param cr: the current row, from the database cursor,
34 @param uid: the current user’s ID for security checks,
35 @param ids: List Lunch cashbox Clean’s IDs
36 @return:Dictionary {}.
38 #TOFIX: use orm methods
39 data = context and context.get('active_ids', []) or []
40 cashmove_ref = self.pool.get('lunch.cashmove')
41 cr.execute("select user_cashmove, box,sum(amount) from lunch_cashmove \
42 where active = 't' and box IN %s group by user_cashmove, \
43 box" , (tuple(data),))
46 cr.execute("update lunch_cashmove set active = 'f' where active= 't' \
47 and box IN %s" , (tuple(data),))
48 #TOCHECK: Why need to create duplicate entry after clean box ?
50 #for (user_id, box_id, amount) in res:
51 # cashmove_ref.create(cr, uid, {
52 # 'name': 'Summary for user' + str(user_id),
54 # 'user_cashmove': user_id,
62 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: