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 osv,fields
24 from tools.translate import _
26 class pos_open_statement(osv.osv_memory):
27 _name = 'pos.open.statement'
28 _description = 'Open Statements'
31 def open_statement(self, cr, uid, ids, context):
34 @param self: The object pointer.
35 @param cr: A database cursor
36 @param uid: ID of the user currently logged in
37 @param context: A standard dictionary
38 @return : Blank Directory
40 company_id=self.pool.get('res.users').browse(cr,uid,uid).company_id.id
41 statement_obj =self.pool.get('account.bank.statement')
42 singer_obj = self.pool.get('singer.statement')
43 journal_obj=self.pool.get('account.journal')
44 journal_lst=journal_obj.search(cr,uid,[('company_id','=',company_id),('auto_cash','=',True)])
45 journal_ids=journal_obj.browse(cr,uid, journal_lst)
46 for journal in journal_ids:
47 ids = statement_obj.search(cr, uid, [('state','!=','confirm'),('user_id','=',uid),('journal_id','=',journal.id)])
49 raise osv.except_osv(_('Message'),_('You can not open a Cashbox for "%s". \n Please close the cashbox related to. '%(journal.name) ))
50 sql = """ Select id from account_bank_statement
53 order by id desc limit 1"""%(journal.id,company_id)
58 sequence_obj=self.pool.get('ir.sequence')
59 if journal.statement_sequence_id:
60 number = sequence_obj.get_id(cr, uid, journal.id)
62 number = sequence_obj.get(cr, uid,
63 'account.bank.statement')
65 # statement_id=statement_obj.create(cr,uid,{'journal_id':journal.id,
66 # 'company_id':company_id,
71 period=statement_obj._get_period(cr,uid,context) or None
72 cr.execute("INSERT INTO account_bank_statement(journal_id,company_id,user_id,state,name, period_id,date) VALUES(%d,%d,%d,'open','%s',%d,'%s')"%(journal.id,company_id,uid,number, period, time.strftime('%Y-%m-%d %H:%M:%S')))
74 cr.execute("select id from account_bank_statement where journal_id=%d and company_id=%d and user_id=%d and state='open' and name='%s'"%(journal.id,company_id,uid,number))
75 statement_id=cr.fetchone()[0]
77 statemt_id=statement_obj.browse(cr,uid,st_id[0])
78 if statemt_id and statemt_id.ending_details_ids:
79 statement_obj.write(cr, uid,[statement_id], {'balance_start':statemt_id.balance_end,
81 if statemt_id.ending_details_ids:
82 for i in statemt_id.ending_details_ids:
83 c=singer_obj.create(cr,uid, { 'pieces':i.pieces,
85 'starting_id':statement_id,
90 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: