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 ##############################################################################
24 from openerp import SUPERUSER_ID
25 from openerp.osv import fields, osv
26 import openerp.addons.decimal_precision as dp
27 from openerp.tools.translate import _
30 class procurement_group(osv.osv):
32 The procurement group class is used to group products together
33 when computing procurements. (tasks, physical products, ...)
35 The goal is that when you have one sale order of several products
36 and the products are pulled from the same or several location(s), to keep
37 having the moves grouped into pickings that represent the sale order.
39 Used in: sales order (to group delivery order lines like the so), pull/push
40 rules (to pack like the delivery order), on orderpoints (e.g. for wave picking
41 all the similar products together).
43 Grouping is made only if the source and the destination is the same.
44 Suppose you have 4 lines on a picking from Output where 2 lines will need
45 to come from Input (crossdock) and 2 lines coming from Stock -> Output As
46 the four procurement orders will have the same group ids from the SO, the
47 move from input will have a stock.picking with 2 grouped lines and the move
48 from stock will have 2 grouped lines also.
50 The name is usually the name of the original document (sale order) or a
51 sequence computed if created manually.
53 _name = 'procurement.group'
54 _description = 'Procurement Requisition'
57 'name': fields.char('Reference', required=True),
58 'move_type': fields.selection([
59 ('direct', 'Partial'), ('one', 'All at once')],
60 'Delivery Method', required=True),
61 'procurement_ids': fields.one2many('procurement.order', 'group_id', 'Procurements'),
64 'name': lambda self, cr, uid, c: self.pool.get('ir.sequence').get(cr, uid, 'procurement.group') or '',
65 'move_type': lambda self, cr, uid, c: 'one'
68 class procurement_rule(osv.osv):
70 A rule describe what a procurement should do; produce, buy, move, ...
72 _name = 'procurement.rule'
73 _description = "Procurement Rule"
76 def _get_action(self, cr, uid, context=None):
80 'name': fields.char('Name', required=True,
81 help="This field will fill the packing origin and the name of its moves"),
82 'group_propagation_option': fields.selection([('none', 'Leave Empty'), ('propagate', 'Propagate'), ('fixed', 'Fixed')], string="Propagation of Procurement Group"),
83 'group_id': fields.many2one('procurement.group', 'Fixed Procurement Group'),
84 'action': fields.selection(selection=lambda s, cr, uid, context=None: s._get_action(cr, uid, context=context),
85 string='Action', required=True),
86 'sequence': fields.integer('Sequence'),
87 'company_id': fields.many2one('res.company', 'Company'),
91 'group_propagation_option': 'propagate',
96 class procurement_order(osv.osv):
100 _name = "procurement.order"
101 _description = "Procurement"
102 _order = 'priority desc, date_planned, id asc'
103 _inherit = ['mail.thread']
106 'name': fields.text('Description', required=True),
108 'origin': fields.char('Source Document', size=64,
109 help="Reference of the document that created this Procurement.\n"
110 "This is automatically completed by OpenERP."),
111 'company_id': fields.many2one('res.company', 'Company', required=True),
113 # These two fields are used for shceduling
114 'priority': fields.selection([('0', 'Not urgent'), ('1', 'Normal'), ('2', 'Urgent'), ('3', 'Very Urgent')], 'Priority', required=True, select=True, track_visibility='onchange'),
115 'date_planned': fields.datetime('Scheduled Date', required=True, select=True, track_visibility='onchange'),
117 'group_id': fields.many2one('procurement.group', 'Procurement Group'),
118 'rule_id': fields.many2one('procurement.rule', 'Rule', track_visibility='onchange', help="Chosen rule for the procurement resolution. Usually chosen by the system but can be manually set by the procurement manager to force an unusual behavior."),
120 'product_id': fields.many2one('product.product', 'Product', required=True, states={'confirmed': [('readonly', False)]}, readonly=True),
121 'product_qty': fields.float('Quantity', digits_compute=dp.get_precision('Product Unit of Measure'), required=True, states={'confirmed': [('readonly', False)]}, readonly=True),
122 'product_uom': fields.many2one('product.uom', 'Product Unit of Measure', required=True, states={'confirmed': [('readonly', False)]}, readonly=True),
124 'product_uos_qty': fields.float('UoS Quantity', states={'confirmed': [('readonly', False)]}, readonly=True),
125 'product_uos': fields.many2one('product.uom', 'Product UoS', states={'confirmed': [('readonly', False)]}, readonly=True),
127 'state': fields.selection([
128 ('cancel', 'Cancelled'),
129 ('confirmed', 'Confirmed'),
130 ('exception', 'Exception'),
131 ('running', 'Running'),
133 ], 'Status', required=True, track_visibility='onchange'),
137 'state': 'confirmed',
139 'date_planned': lambda *a: time.strftime('%Y-%m-%d %H:%M:%S'),
140 'company_id': lambda self, cr, uid, c: self.pool.get('res.company')._company_default_get(cr, uid, 'procurement.order', context=c)
143 def unlink(self, cr, uid, ids, context=None):
144 procurements = self.read(cr, uid, ids, ['state'], context=context)
146 for s in procurements:
147 if s['state'] in ['draft', 'cancel']:
148 unlink_ids.append(s['id'])
150 raise osv.except_osv(_('Invalid Action!'),
151 _('Cannot delete Procurement Order(s) which are in %s state.') % s['state'])
152 return osv.osv.unlink(self, cr, uid, unlink_ids, context=context)
154 def do_view_procurements(self, cr, uid, ids, context=None):
156 This function returns an action that display existing procurement orders
157 of same procurement group of given ids.
159 mod_obj = self.pool.get('ir.model.data')
160 act_obj = self.pool.get('ir.actions.act_window')
161 result = mod_obj.get_object_reference(cr, uid, 'procurement', 'do_view_procurements')
162 id = result and result[1] or False
163 result = act_obj.read(cr, uid, [id], context=context)[0]
164 group_ids = set([proc.group_id.id for proc in self.browse(cr, uid, ids, context=context) if proc.group_id])
165 result['domain'] = "[('group_id','in',[" + ','.join(map(str, list(group_ids))) + "])]"
168 def onchange_product_id(self, cr, uid, ids, product_id, context=None):
169 """ Finds UoM and UoS of changed product.
170 @param product_id: Changed id of product.
171 @return: Dictionary of values.
174 w = self.pool.get('product.product').browse(cr, uid, product_id, context=context)
176 'product_uom': w.uom_id.id,
177 'product_uos': w.uos_id and w.uos_id.id or w.uom_id.id
182 def get_cancel_ids(self, cr, uid, ids, context=None):
183 return [proc.id for proc in self.browse(cr, uid, ids, context=context) if proc.state != 'done']
185 def cancel(self, cr, uid, ids, context=None):
186 #cancel only the procurements that aren't done already
187 to_cancel_ids = self.get_cancel_ids(cr, uid, ids, context=context)
189 return self.write(cr, uid, to_cancel_ids, {'state': 'cancel'}, context=context)
191 def reset_to_confirmed(self, cr, uid, ids, context=None):
192 return self.write(cr, uid, ids, {'state': 'confirmed'}, context=context)
194 def run(self, cr, uid, ids, context=None):
195 for procurement_id in ids:
196 #we intentionnaly do the browse under the for loop to avoid caching all ids which would be ressource greedy
197 #and useless as we'll make a refresh later that will invalidate all the cache (and thus the next iteration
198 #will fetch all the ids again)
199 procurement = self.browse(cr, uid, procurement_id, context=context)
200 if procurement.state not in ("running", "done"):
201 if self._assign(cr, uid, procurement, context=context):
202 procurement.refresh()
203 res = self._run(cr, uid, procurement, context=context or {})
205 self.write(cr, uid, [procurement.id], {'state': 'running'}, context=context)
207 self.write(cr, uid, [procurement.id], {'state': 'exception'}, context=context)
209 self.message_post(cr, uid, [procurement.id], body=_('No rule matching this procurement'), context=context)
210 self.write(cr, uid, [procurement.id], {'state': 'exception'}, context=context)
213 def check(self, cr, uid, ids, context=None):
215 for procurement in self.browse(cr, uid, ids, context=context):
216 result = self._check(cr, uid, procurement, context=context)
218 done_ids.append(procurement.id)
220 self.write(cr, uid, done_ids, {'state': 'done'}, context=context)
224 # Method to overwrite in different procurement modules
226 def _find_suitable_rule(self, cr, uid, procurement, context=None):
227 '''This method returns a procurement.rule that depicts what to do with the given procurement
228 in order to complete its needs. It returns False if no suiting rule is found.
229 :param procurement: browse record
234 def _assign(self, cr, uid, procurement, context=None):
235 '''This method check what to do with the given procurement in order to complete its needs.
236 It returns False if no solution is found, otherwise it stores the matching rule (if any) and
238 :param procurement: browse record
241 #if the procurement already has a rule assigned, we keep it (it has a higher priority as it may have been chosen manually)
242 if procurement.rule_id:
244 elif procurement.product_id.type != 'service':
245 rule_id = self._find_suitable_rule(cr, uid, procurement, context=context)
247 self.write(cr, uid, [procurement.id], {'rule_id': rule_id}, context=context)
251 def _run(self, cr, uid, procurement, context=None):
252 '''This method implements the resolution of the given procurement
253 :param procurement: browse record
254 :returns: True if the resolution of the procurement was a success, False otherwise to set it in exception
258 def _check(self, cr, uid, procurement, context=None):
259 '''Returns True if the given procurement is fulfilled, False otherwise
260 :param procurement: browse record
268 def run_scheduler(self, cr, uid, use_new_cursor=False, context=None):
270 Call the scheduler to check the procurement order. This is intented to be done for all existing companies at
271 the same time, so we're running all the methods as SUPERUSER to avoid intercompany and access rights issues.
273 @param self: The object pointer
274 @param cr: The current row, from the database cursor,
275 @param uid: The current user ID for security checks
276 @param ids: List of selected IDs
277 @param use_new_cursor: False or the dbname
278 @param context: A standard dictionary for contextual values
279 @return: Dictionary of values
285 cr = openerp.registry(use_new_cursor).cursor()
287 # Run confirmed procurements
289 ids = self.search(cr, SUPERUSER_ID, [('state', '=', 'confirmed')], context=context)
292 self.run(cr, SUPERUSER_ID, ids, context=context)
296 # Check if running procurements are done
299 ids = self.search(cr, SUPERUSER_ID, [('state', '=', 'running')], offset=offset, context=context)
302 done = self.check(cr, SUPERUSER_ID, ids, context=context)
303 offset += len(ids) - len(done)
314 # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: