addons/point_of_sale/wizard/pos_open_statement.py

   1 # -*- coding: utf-8 -*-
   2 ##############################################################################
   3 #
   4 #    OpenERP, Open Source Management Solution
   5 #    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>).
   6 #
   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.
  11 #
  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.
  16 #
  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/>.
  19 #
  20 ##############################################################################
  21
  22 from osv import osv
  23 from tools.translate import _
  24 import time
  25
  26
  27 class pos_open_statement(osv.osv_memory):
  28     _name = 'pos.open.statement'
  29     _description = 'Open Statements'
  30
  31     def open_statement(self, cr, uid, ids, context):
  32         """
  33              Open the statements
  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
  39         """
  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)])
  48             if len(ids):
  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
  51                                     where journal_id=%d
  52                                     and company_id =%d
  53                                     order by id desc limit 1""" % (journal.id, company_id)
  54             cr.execute(sql)
  55             st_id = cr.fetchone()
  56             number = ''
  57             sequence_obj = self.pool.get('ir.sequence')
  58             if journal.statement_sequence_id:
  59                 number = sequence_obj.get_id(cr, uid, journal.id)
  60             else:
  61                 number = sequence_obj.get(cr, uid,
  62                                 'account.bank.statement')
  63
  64     #        statement_id=statement_obj.create(cr,uid,{'journal_id':journal.id,
  65     #                                                  'company_id':company_id,
  66     #                                                  'user_id':uid,
  67     #                                                  'state':'open',
  68     #                                                  'name':number
  69     #                                                  })
  70             period = statement_obj._get_period(cr, uid, context) or None
  71             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')))
  72             cr.commit()
  73             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))
  74             statement_id = cr.fetchone()[0]
  75             if st_id:
  76                 statemt_id = statement_obj.browse(cr, uid, st_id[0])
  77                 if statemt_id and statemt_id.ending_details_ids:
  78                     statement_obj.write(cr, uid, [statement_id], {
  79                         'balance_start': statemt_id.balance_end,
  80                         'state': 'open',
  81                     })
  82                     if statemt_id.ending_details_ids:
  83                         for i in statemt_id.ending_details_ids:
  84                             c = singer_obj.create(cr, uid, {
  85                                 'pieces': i.pieces,
  86                                 'number': i.number,
  87                                 'starting_id': statement_id,
  88                             })
  89             cr.commit()
  90         return {}
  91
  92 pos_open_statement()
  93
  94 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
  95