addons/delivery/stock.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 fields,osv
  23 from tools.translate import _
  24
  25 import decimal_precision as dp
  26
  27 # Overloaded stock_picking to manage carriers :
  28 class stock_picking(osv.osv):
  29     _inherit = 'stock.picking'
  30
  31     def _cal_weight(self, cr, uid, ids, name, args, context=None):
  32         res = {}
  33         uom_obj = self.pool.get('product.uom')
  34         for picking in self.browse(cr, uid, ids, context=context):
  35             total_weight = total_weight_net = 0.00
  36
  37             for move in picking.move_lines:
  38                 total_weight += move.weight
  39                 total_weight_net += move.weight_net
  40
  41             res[picking.id] = {
  42                                 'weight': total_weight,
  43                                 'weight_net': total_weight_net,
  44                               }
  45         return res
  46
  47
  48     def _get_picking_line(self, cr, uid, ids, context=None):
  49         result = {}
  50         for line in self.pool.get('stock.move').browse(cr, uid, ids, context=context):
  51             result[line.picking_id.id] = True
  52         return result.keys()
  53
  54     _columns = {
  55         'carrier_id':fields.many2one("delivery.carrier","Carrier"),
  56         'volume': fields.float('Volume'),
  57         'weight': fields.function(_cal_weight, type='float', string='Weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_weight',
  58                   store={
  59                  'stock.picking': (lambda self, cr, uid, ids, c={}: ids, ['move_lines'], 20),
  60                  'stock.move': (_get_picking_line, ['product_id','product_qty','product_uom','product_uos_qty'], 20),
  61                  }),
  62         'weight_net': fields.function(_cal_weight, type='float', string='Net Weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_weight',
  63                   store={
  64                  'stock.picking': (lambda self, cr, uid, ids, c={}: ids, ['move_lines'], 20),
  65                  'stock.move': (_get_picking_line, ['product_id','product_qty','product_uom','product_uos_qty'], 20),
  66                  }),
  67         'carrier_tracking_ref': fields.char('Carrier Tracking Ref', size=32),
  68         'number_of_packages': fields.integer('Number of Packages'),
  69         'weight_uom_id': fields.many2one('product.uom', 'Unit of Measure', required=True,readonly="1",help="Unit of Measure (Unit of Measure) is the unit of measurement for Weight",),
  70         }
  71
  72     def _prepare_shipping_invoice_line(self, cr, uid, picking, invoice, context=None):
  73         """Prepare the invoice line to add to the shipping costs to the shipping's
  74            invoice.
  75
  76             :param browse_record picking: the stock picking being invoiced
  77             :param browse_record invoice: the stock picking's invoice
  78             :return: dict containing the values to create the invoice line,
  79                      or None to create nothing
  80         """
  81         carrier_obj = self.pool.get('delivery.carrier')
  82         grid_obj = self.pool.get('delivery.grid')
  83         if not picking.carrier_id or \
  84             any(inv_line.product_id.id == picking.carrier_id.product_id.id
  85                 for inv_line in invoice.invoice_line):
  86             return None
  87         grid_id = carrier_obj.grid_get(cr, uid, [picking.carrier_id.id],
  88                 picking.partner_id.id, context=context)
  89         if not grid_id:
  90             raise osv.except_osv(_('Warning!'),
  91                     _('The carrier %s (id: %d) has no delivery grid!') \
  92                             % (picking.carrier_id.name,
  93                                 picking.carrier_id.id))
  94         price = grid_obj.get_price_from_picking(cr, uid, grid_id,
  95                 invoice.amount_untaxed, picking.weight, picking.volume,
  96                 context=context)
  97         account_id = picking.carrier_id.product_id.property_account_income.id
  98         if not account_id:
  99             account_id = picking.carrier_id.product_id.categ_id\
 100                     .property_account_income_categ.id
 101
 102         taxes = picking.carrier_id.product_id.taxes_id
 103         partner = picking.partner_id or False
 104         if partner:
 105             account_id = self.pool.get('account.fiscal.position').map_account(cr, uid, partner.property_account_position, account_id)
 106             taxes_ids = self.pool.get('account.fiscal.position').map_tax(cr, uid, partner.property_account_position, taxes)
 107         else:
 108             taxes_ids = [x.id for x in taxes]
 109
 110         return {
 111             'name': picking.carrier_id.name,
 112             'invoice_id': invoice.id,
 113             'uos_id': picking.carrier_id.product_id.uos_id.id,
 114             'product_id': picking.carrier_id.product_id.id,
 115             'account_id': account_id,
 116             'price_unit': price,
 117             'quantity': 1,
 118             'invoice_line_tax_id': [(6, 0, taxes_ids)],
 119         }
 120
 121     def action_invoice_create(self, cr, uid, ids, journal_id=False,
 122             group=False, type='out_invoice', context=None):
 123         invoice_obj = self.pool.get('account.invoice')
 124         picking_obj = self.pool.get('stock.picking')
 125         invoice_line_obj = self.pool.get('account.invoice.line')
 126         result = super(stock_picking, self).action_invoice_create(cr, uid,
 127                 ids, journal_id=journal_id, group=group, type=type,
 128                 context=context)
 129         for picking in picking_obj.browse(cr, uid, result.keys(), context=context):
 130             invoice = invoice_obj.browse(cr, uid, result[picking.id], context=context)
 131             invoice_line = self._prepare_shipping_invoice_line(cr, uid, picking, invoice, context=context)
 132             if invoice_line:
 133                 invoice_line_obj.create(cr, uid, invoice_line)
 134                 invoice_obj.button_compute(cr, uid, [invoice.id], context=context)
 135         return result
 136
 137     _defaults = {
 138         'weight_uom_id': lambda self,cr,uid,c: self.pool.get('product.uom').search(cr, uid, [('name', '=', _('kg'))], context=c)[0],
 139     }
 140
 141 stock_picking()
 142
 143 class stock_move(osv.osv):
 144     _inherit = 'stock.move'
 145
 146     def _cal_move_weight(self, cr, uid, ids, name, args, context=None):
 147         res = {}
 148         uom_obj = self.pool.get('product.uom')
 149         for move in self.browse(cr, uid, ids, context=context):
 150             weight = weight_net = 0.00
 151             if move.product_id.weight > 0.00:
 152                 converted_qty = move.product_qty
 153
 154                 if move.product_uom.id <> move.product_id.uom_id.id:
 155                     converted_qty = uom_obj._compute_qty(cr, uid, move.product_uom.id, move.product_qty, move.product_id.uom_id.id)
 156
 157                 weight = (converted_qty * move.product_id.weight)
 158
 159                 if move.product_id.weight_net > 0.00:
 160                     weight_net = (converted_qty * move.product_id.weight_net)
 161
 162             res[move.id] =  {
 163                             'weight': weight,
 164                             'weight_net': weight_net,
 165                             }
 166         return res
 167
 168     _columns = {
 169         'weight': fields.function(_cal_move_weight, type='float', string='Weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_move_weight',
 170                   store={
 171                  'stock.move': (lambda self, cr, uid, ids, c=None: ids, ['product_id', 'product_qty', 'product_uom'], 20),
 172                  }),
 173         'weight_net': fields.function(_cal_move_weight, type='float', string='Net weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_move_weight',
 174                   store={
 175                  'stock.move': (lambda self, cr, uid, ids, c=None: ids, ['product_id', 'product_qty', 'product_uom'], 20),
 176                  }),
 177         'weight_uom_id': fields.many2one('product.uom', 'Unit of Measure', required=True,readonly="1",help="Unit of Measure (Unit of Measure) is the unit of measurement for Weight",),
 178         }
 179     _defaults = {
 180         'weight_uom_id': lambda self,cr,uid,c: self.pool.get('product.uom').search(cr, uid, [('name', '=', _('kg'))], context=c)[0],
 181     }
 182 stock_move()
 183
 184 # Redefinition of the new fields in order to update the model stock.picking.out in the orm
 185 # FIXME: this is a temporary workaround because of a framework bug (ref: lp996816). It should be removed as soon as
 186 #        the bug is fixed
 187 class stock_picking_out(osv.osv):
 188     _inherit = 'stock.picking.out'
 189
 190     def _cal_weight(self, cr, uid, ids, name, args, context=None):
 191         return self.pool.get('stock.picking')._cal_weight(cr, uid, ids, name, args, context=context)
 192
 193
 194     def _get_picking_line(self, cr, uid, ids, context=None):
 195         return self.pool.get('stock.picking')._get_picking_line(cr, uid, ids, context=context)
 196
 197     _columns = {
 198         'carrier_id':fields.many2one("delivery.carrier","Carrier"),
 199         'volume': fields.float('Volume'),
 200         'weight': fields.function(_cal_weight, type='float', string='Weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_weight',
 201                   store={
 202                  'stock.picking': (lambda self, cr, uid, ids, c={}: ids, ['move_lines'], 20),
 203                  'stock.move': (_get_picking_line, ['product_id','product_qty','product_uom','product_uos_qty'], 20),
 204                  }),
 205         'weight_net': fields.function(_cal_weight, type='float', string='Net Weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_weight',
 206                   store={
 207                  'stock.picking': (lambda self, cr, uid, ids, c={}: ids, ['move_lines'], 20),
 208                  'stock.move': (_get_picking_line, ['product_id','product_qty','product_uom','product_uos_qty'], 20),
 209                  }),
 210         'carrier_tracking_ref': fields.char('Carrier Tracking Ref', size=32),
 211         'number_of_packages': fields.integer('Number of Packages'),
 212         }
 213 stock_picking_out()
 214
 215 class stock_picking_in(osv.osv):
 216     _inherit = 'stock.picking.in'
 217
 218     def _cal_weight(self, cr, uid, ids, name, args, context=None):
 219         return self.pool.get('stock.picking')._cal_weight(cr, uid, ids, name, args, context=context)
 220
 221     def _get_picking_line(self, cr, uid, ids, context=None):
 222         return self.pool.get('stock.picking')._get_picking_line(cr, uid, ids, context=context)
 223
 224     _columns = {
 225         'weight': fields.function(_cal_weight, type='float', string='Weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_weight',
 226                 store={
 227                 'stock.picking': (lambda self, cr, uid, ids, c={}: ids, ['move_lines'], 20),
 228                 'stock.move': (_get_picking_line, ['product_id','product_qty','product_uom','product_uos_qty'], 20),
 229                 }),
 230         'weight_net': fields.function(_cal_weight, type='float', string='Net Weight', digits_compute= dp.get_precision('Stock Weight'), multi='_cal_weight',
 231                 store={
 232                 'stock.picking': (lambda self, cr, uid, ids, c={}: ids, ['move_lines'], 20),
 233                 'stock.move': (_get_picking_line, ['product_id','product_qty','product_uom','product_uos_qty'], 20),
 234                 }),
 235         }
 236 stock_picking_in()
 237
 238 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 239