Merge lp:~vauxoo/addons-vauxoo/mrp-gbw-dev-julio into lp:addons-vauxoo

[Julio Serna-http://www.vauxoo.com]

agrega la linea con many2one en la producción hacia el pedido de venta

[Moisés López - http://www.vauxoo.com (moylop260)]

review: Approve

[Moisés López - http://www.vauxoo.com (moylop260)]

Este módulo no es, era otro
 sale_mrp

review: Disapprove

Unmerged revisions

1. By Julio Serna-http://www.vauxoo.com on 2012-06-08

[INIT]

=== added directory 'sale_mrp_autosplit'
=== added file 'sale_mrp_autosplit/__init__.py'
--- sale_mrp_autosplit/__init__.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/__init__.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,26 @@
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2009 Tiny SPRL (<http://tiny.be>).
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import sale
+import report
+import mrp_production
+import wizard
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'sale_mrp_autosplit/__openerp__.py'
--- sale_mrp_autosplit/__openerp__.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/__openerp__.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,46 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2010 moylop260 - http://moylop.blogspot.com/
+#    All Rights Reserved.
+#    info moylop260 ([e-mail])
+############################################################################
+#    Coded by: moylop260 ([e-mail])
+############################################################################
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+{
+    "name" : "Sale MRP Autosplit",
+    "version" : "1.0",
+    "author" : "[e-mail]",
+    "category" : "Localization/Mexico",
+    "description" : """This module add fields to sale_order for auto split production lot
+    """,
+    "website" : "http://moylop.blogspot.com/",
+    "license" : "AGPL-3",
+    "depends" : ["mrp", "sale", "sale_mrp"],
+    "init_xml" : [],
+    "demo_xml" : [],
+    "update_xml" : [
+        "sale_view.xml",
+        "sale_mrp_autosplit_report.xml",
+        "wizard/wizard_force_cancel_view.xml",
+    ],
+    "installable" : True,
+    "active" : False,
+}

=== added file 'sale_mrp_autosplit/mrp_production.py'
--- sale_mrp_autosplit/mrp_production.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/mrp_production.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,137 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2010 moylop260 - http://moylop.blogspot.com/
+#    All Rights Reserved.
+#    info moylop260 ([e-mail])
+############################################################################
+#    Coded by: moylop260 ([e-mail])
+############################################################################
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from osv import fields, osv
+import netsvc
+import time
+
+class mrp_production(osv.osv):
+    _inherit = 'mrp.production'
+    _order = 'name'
+    
+    def _get_sale_id(self, cr, uid, ids, field_names=False):
+        move_obj = self.pool.get('stock.move')
+
+        def get_parent_move(move_id):
+            move = move_obj.browse(cr, uid, move_id)
+            if move.move_dest_id:
+                return get_parent_move(move.move_dest_id.id)
+            return move_id
+
+        res = {}
+        productions = self.browse(cr, uid, ids)
+        for production in productions:
+            res[production.id] = {}
+            if production.move_prod_id:
+                parent_move_line = get_parent_move(production.move_prod_id.id)
+                if parent_move_line:
+                    move = move_obj.browse(cr, uid, parent_move_line)
+                    res[production.id]['sale_id'] = move.sale_line_id and move.sale_line_id.order_id.id or False
+                    res[production.id]['sale_line_id'] = move.sale_line_id and move.sale_line_id.id or False
+        return res
+    
+    def _split_production(self, cr, uid, ids):
+        wf_service = netsvc.LocalService("workflow")
+        sale_line_obj = self.pool.get('sale.order.line')
+        production_id__sale_id = self._get_sale_id(cr, uid, ids)
+        #print "action_confirm", ids
+        for production in self.browse(cr, uid, ids):
+            #sale_id = production_id__sale_id[id]['sale_id']
+            
+            additional_production_ids = []
+            #print "production.id",production.id
+            sale_line_id = production_id__sale_id[production.id].get('sale_line_id', False)
+            #print "sale_line_id",sale_line_id
+            if sale_line_id: 
+                sale_line = sale_line_obj.browse(cr, uid, [sale_line_id])[0]
+                
+                date_planned_start = sale_line.date_planned_start
+                product_qty_split = sale_line.product_qty_split
+                #print "date_planned_start",date_planned_start
+                self.write(cr, uid, [production.id], {'date_planned': date_planned_start})
+                
+                while production.product_qty > product_qty_split:
+                    new_production_id = self.copy(cr, uid, production.id, {
+                        'product_qty': product_qty_split,
+                        'product_uos_qty': product_qty_split,
+                    })
+                    wf_service.trg_validate(uid, 'mrp.production', new_production_id, 'button_confirm', cr)
+                    additional_production_ids.append( new_production_id )
+                    production.product_qty -= product_qty_split
+                self.write(cr, uid, [production.id],  {
+                    'product_qty': production.product_qty,
+                    'product_uos_qty': production.product_qty,
+                })
+        return additional_production_ids
+    
+    def set_local_number(self, cr, uid, ids, context={}):
+        """
+        production_id__sale_id = self._get_sale_id(cr, uid, ids)
+        sale_line_obj = self.pool.get('sale.order.line')
+        for production in self.browse(cr, uid, ids):
+            sale_line_id = production_id__sale_id[production.id].get('sale_line_id', False)
+            if sale_line_id:
+                sale_line = sale_line_obj.browse(cr, uid, [sale_line_id])[0]
+                sale_line.
+        """
+        count = 0
+        for production in self.browse(cr, uid, ids):
+            count += 1
+            date_obj = time.strptime(production.date_planned, '%Y-%m-%d %H:%M:%S')
+            year = int(time.strftime('%y', date_obj))
+            #week_of_year = int(time.strftime('%U', date_obj))+1
+            week_of_year = int(time.strftime('%W', date_obj))+0
+            week_of_year_str = '%%0%sd' % 2 % week_of_year
+            day_of_week = date_obj.tm_wday + 1
+            product_code = production.product_id.default_code or ''
+            qty = "%%0%sd"% 2 % production.product_qty
+            lot = '%%0%sd' % 3 % count
+            
+            new_name = ""
+            new_name += "%s"%(year)
+            #new_name += "-"
+            new_name += "%s"%(week_of_year_str)
+            #new_name += "-"
+            new_name += "%s"%(day_of_week)
+            #new_name += "-"
+            new_name += "%s"%( product_code )
+            #new_name += "-"
+            new_name += "%s"%( qty )
+            #new_name += "-"
+            new_name += lot
+            self.write(cr, uid, [production.id], {'name': new_name})
+        return True
+    
+    
+    def action_confirm(self, cr, uid, ids):
+        additional_production_ids = self._split_production(cr, uid, ids)
+        self.action_compute(cr, uid, ids, properties=[])
+        ret = super(mrp_production, self).action_confirm(cr, uid, ids)
+        self.set_local_number(cr, uid, ids + additional_production_ids)
+        return ret
+mrp_production()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
\ No newline at end of file

=== added directory 'sale_mrp_autosplit/report'
=== added file 'sale_mrp_autosplit/report/__init__.py'
--- sale_mrp_autosplit/report/__init__.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/report/__init__.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,29 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2010 moylop260 - http://moylop.blogspot.com/
+#    All Rights Reserved.
+#    info moylop260 ([e-mail])
+############################################################################
+#    Coded by: moylop260 ([e-mail])
+############################################################################
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+import mrp_lot_barcode
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+

=== added file 'sale_mrp_autosplit/report/mrp_lot_barcode.py'
--- sale_mrp_autosplit/report/mrp_lot_barcode.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/report/mrp_lot_barcode.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,53 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2010 moylop260 - http://moylop.blogspot.com/
+#    All Rights Reserved.
+#    info moylop260 ([e-mail])
+############################################################################
+#    Coded by: moylop260 ([e-mail])
+############################################################################
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+from report import report_sxw
+import pooler
+import tools
+
+#DELETE FROM ir_act_report_xml WHERE report_name = 'mrp.lot.barcode';
+
+class mrp_lot_barcode(report_sxw.rml_parse):
+    def __init__(self, cr, uid, name, context):
+        super(mrp_lot_barcode, self).__init__(cr, uid, name, context=context)
+        self.localcontext.update({
+            'get_count': self._get_count,
+        })
+    
+    def _get_count(self, count=1):
+        try:
+            self.count += count
+        except:
+            self.count = count
+        return self.count
+        
+report_sxw.report_sxw(
+    'report.mrp.lot.barcode',
+    'mrp.production',
+    'addons/sale_mrp_autosplit/report/mrp_lot_barcode.rml',
+    header=False,
+    parser=mrp_lot_barcode,
+)
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'sale_mrp_autosplit/report/mrp_lot_barcode.rml'
--- sale_mrp_autosplit/report/mrp_lot_barcode.rml	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/report/mrp_lot_barcode.rml	2012-06-08 16:18:19 +0000
@@ -0,0 +1,106 @@
+<?xml version="1.0"?>
+<document filename="test.pdf">
+  <template pageSize="(612.0,792.0)" title="Test" author="Martin Simon" allowSplitting="20">
+    <pageTemplate id="first">
+      <frame id="first" x1="0.0" y1="0.0" width="612" height="792"/>
+    </pageTemplate>
+  </template>
+  <stylesheet>
+    <blockTableStyle id="Standard_Outline">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla2">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <blockTableStyle id="Tabla1">
+      <blockAlignment value="LEFT"/>
+      <blockValign value="TOP"/>
+    </blockTableStyle>
+    <initialize>
+      <paraStyle name="all" alignment="justify"/>
+    </initialize>
+    <paraStyle name="P1" fontName="Helvetica"/>
+    <paraStyle name="P2" fontName="Helvetica" fontSize="6.0" leading="8"/>
+    <paraStyle name="P3" fontName="Helvetica" fontSize="12.0" leading="15"/>
+    <paraStyle name="P4" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
+    <paraStyle name="P5" fontName="Helvetica" fontSize="12.0" leading="15" alignment="CENTER"/>
+    <paraStyle name="Standard" fontName="Helvetica"/>
+    <paraStyle name="Heading" fontName="Helvetica" fontSize="14.0" leading="17" spaceBefore="12.0" spaceAfter="6.0"/>
+    <paraStyle name="Text body" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="List" fontName="Helvetica" spaceBefore="0.0" spaceAfter="6.0"/>
+    <paraStyle name="Caption" fontName="Helvetica" fontSize="12.0" leading="15" spaceBefore="6.0" spaceAfter="6.0"/>
+    <paraStyle name="Index" fontName="Helvetica"/>
+    <paraStyle name="Table Contents" fontName="Helvetica"/>
+    <images/>
+  </stylesheet>
+  <story>
+    <section>
+      <para style="P2">[[ repeatIn(objects,'o') ]]</para>
+      <blockTable colWidths="50.0,36.0,29.0,323.0,54.0,59.0,62.0" style="Tabla2">
+        <tr>
+          <td>
+            <para style="P3">Año</para>
+          </td>
+          <td>
+            <para style="P3">Sem</para>
+          </td>
+          <td>
+            <para style="P3">Día</para>
+          </td>
+          <td>
+            <para style="P3">Estilo – Talla – Color</para>
+          </td>
+          <td>
+            <para style="P4">Pares</para>
+          </td>
+          <td>
+            <para style="P4">Lote</para>
+          </td>
+          <td>
+            <para style="P4">Cliente</para>
+          </td>
+        </tr>
+        <tr>
+          <td>
+            <para style="P3">20[[ o.name[:2] ]]</para>
+          </td>
+          <td>
+            <para style="P4">[[ o.name[2:4] ]]</para>
+          </td>
+          <td>
+            <para style="P4">[[ o.name[4:5] ]]</para>
+          </td>
+          <td>
+            <para style="P3">[[ o.product_id.name ]] – [[ o.product_id.variants ]]</para>
+          </td>
+          <td>
+            <para style="P4">[[ '%d'%(o.product_qty) ]]</para>
+          </td>
+          <td>
+            <para style="P4">[[ o.name[-3:] ]]</para>
+          </td>
+          <td>
+            <para style="P4">[[ o.partner_id.ref ]]</para>
+          </td>
+        </tr>
+      </blockTable>
+      <blockTable colWidths="612.0" style="Tabla1">
+        <tr>
+          <td>
+            <para style="Standard">[[ o.name and setTag('para','barCode',{'barWidth':'1.5', 'code':'code128'}) ]][[ o.name ]]</para>
+          </td>
+        </tr>
+        <tr>
+          <td>
+            <para style="Standard">............... [[ o.name ]] .......................</para>
+            <para style="Standard">=========================================================================================</para>
+          </td>
+        </tr>
+      </blockTable>
+      <para style="P1">[[ get_count(1)%6 == 0 and get_count(0)&lt;&gt;len(objects) and setTag('para','nextPage') ]]</para>
+    </section>
+  </story>
+</document>
+

=== added file 'sale_mrp_autosplit/report/mrp_lot_barcode.sxw'
Binary files sale_mrp_autosplit/report/mrp_lot_barcode.sxw	1970-01-01 00:00:00 +0000 and sale_mrp_autosplit/report/mrp_lot_barcode.sxw	2012-06-08 16:18:19 +0000 differ
=== added file 'sale_mrp_autosplit/report/rml2pdf_OpenERP-6.bat'
--- sale_mrp_autosplit/report/rml2pdf_OpenERP-6.bat	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/report/rml2pdf_OpenERP-6.bat	2012-06-08 16:18:19 +0000
@@ -0,0 +1,6 @@
+SET path=%path%;C:\python25
+SET tiny_sxw2rml_path=../../base_report_designer/wizard/tiny_sxw2rml/tiny_sxw2rml.py
+SET tiny_sxw2rml_path=../../../addons/base_report_designer/wizard/tiny_sxw2rml/tiny_sxw2rml.py
+SET tiny_sxw2rml_path=../../../addons\base_report_designer\openerp_sxw2rml\openerp_sxw2rml.py
+python %tiny_sxw2rml_path% mrp_lot_barcode.sxw > mrp_lot_barcode.rml
+pause
\ No newline at end of file

=== added file 'sale_mrp_autosplit/sale.py'
--- sale_mrp_autosplit/sale.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/sale.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,113 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2010 moylop260 - http://moylop.blogspot.com/
+#    All Rights Reserved.
+#    info moylop260 ([e-mail])
+############################################################################
+#    Coded by: moylop260 ([e-mail])
+############################################################################
+#
+#    This program is free software: you can redistribute it and/or modify
+#    it under the terms of the GNU Affero General Public License as
+#    published by the Free Software Foundation, either version 3 of the
+#    License, or (at your option) any later version.
+#
+#    This program is distributed in the hope that it will be useful,
+#    but WITHOUT ANY WARRANTY; without even the implied warranty of
+#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+#    GNU Affero General Public License for more details.
+#
+#    You should have received a copy of the GNU Affero General Public License
+#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+##############################################################################
+
+from osv import fields, osv
+import netsvc
+import time
+
+class sale_order_line(osv.osv):
+    _inherit = 'sale.order.line'
+    
+    _columns = {
+        'date_planned_start': fields.datetime(u'Date Planned Start'),
+        'product_qty_split': fields.integer(u'Quantity Split Lot'),
+    }
+sale_order_line()
+
+class sale_order(osv.osv):
+    _inherit = "sale.order"
+    
+    def _production_rate(self, cursor, user, ids, name, arg, context=None):
+        res = {}
+        production_obj = self.pool.get('mrp.production')
+        for sale in self.browse(cursor, user, ids, context=context):
+            production_ids = production_obj.search(cursor, user, [('sale_id', '=', sale.id)], context=context)
+            #print "sale_id",sale.id
+            #print "production_ids",production_ids
+            productions = production_obj.browse(cursor, user, production_ids, context=context)
+            #print "production_ids",production_ids
+            if sale.produced:
+                res[sale.id] = 100.0
+                continue
+            tot = 0.0
+            for production in productions:
+                if production.state not in ('draft', 'cancel'):
+                    tot += production.product_qty
+            if tot:
+                sale_total_qty = sum([sale_line.product_uom_qty for sale_line in sale.order_line])
+                #print "sale_total_qty",sale_total_qty
+                #print "tot",tot
+                res[sale.id] = min(100.0, tot * 100.0 / sale_total_qty or 1.00)
+            else:
+                res[sale.id] = 0.0
+            #print "********************"
+        return res
+    
+    def _produced(self, cursor, user, ids, name, arg, context=None):
+        res = {}
+        for sale in self.browse(cursor, user, ids, context=context):
+            res[sale.id] = True
+            for invoice in sale.invoice_ids:
+                if invoice.state != 'paid':
+                    res[sale.id] = False
+                    break
+            if not sale.invoice_ids:
+                res[sale.id] = False
+        return res
+    
+    _columns = {
+        'production_rate': fields.function(_production_rate, method=True, string='Produced', type='float'),
+        'produced': fields.function(_produced, method=True, string='Produced',
+            type='boolean', help="It indicates that productions are finished", ),#fnct_search=_invoiced_search),
+    }
+sale_order()
+"""
+class sale_order(osv.osv):
+    _inherit = "sale.order"
+    '''
+    def action_ship_create(self, cr, uid, ids, *args):
+        production_obj = self.pool.get('production.order')
+        production_line_obj = self.pool.get('production.order.line')
+        
+        ret = super(sale_order, self).action_ship_create(cr, uid, ids)
+        
+        sales = self.browse(cr, uid, ids)
+        for sale in sales:
+            production_ids = []
+            
+            for sale_line in sale.order_line:
+                production = sale_line.procurement_id and sale_line.procurement_id.production_id or False
+                if production:
+                    production_ids.append( production.id )
+            data = {'ids': production_ids}
+            print "sale",sale.id
+            print "production_ids",production_ids
+        return ret
+        '''
+sale_order()
+"""
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
\ No newline at end of file

=== added file 'sale_mrp_autosplit/sale_mrp.patch'
--- sale_mrp_autosplit/sale_mrp.patch	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/sale_mrp.patch	2012-06-08 16:18:19 +0000
@@ -0,0 +1,148 @@
+=== modified file 'base_vat/base_vat.py'
+--- base_vat/base_vat.py	2011-01-17 20:44:55 +0000
++++ base_vat/base_vat.py	2011-06-01 01:47:27 +0000
+@@ -23,6 +23,9 @@
+ 
+ from osv import osv, fields
+ from tools.translate import _
++from tools.misc import ustr
++import re
++import datetime
+ 
+ _ref_vat = {
+     'be': 'BE0477472701', 'at': 'ATU12345675',
+@@ -38,7 +41,9 @@
+     'nl': 'NL123456782B90', 'pl': 'PL1234567883',
+     'pt': 'PT123456789', 'ro': 'RO1234567897',
+     'se': 'SE123456789701', 'si': 'SI12345679',
+-    'sk': 'SK0012345675', 'el': 'EL12345670'
++    'sk': 'SK0012345675', 'el': 'EL12345670',
++    'mx': 'MXABCD831230T1B',
++
+             }
+ 
+ def mult_add(i, j):
+@@ -1064,6 +1069,36 @@
+                 return False
+         return True
+ 
++    __check_vat_mx_re = re.compile(r"(?P<primeras>[A-Za-z\xd1\xf1&]{3,4})" \
++                                    r"[ \-_]?" \
++                                    r"(?P<ano>[0-9]{2})(?P<mes>[01][0-9])(?P<dia>[0-3][0-9])" \
++                                    r"[ \-_]?" \
++                                    r"(?P<code>[A-Za-z0-9&\xd1\xf1]{3})$")
++    
++    def check_vat_mx(self, vat):
++        ''' Mexican VAT verification
++        
++        Verificar RFC México
++        '''
++        # we convert to 8-bit encoding, to help the regex parse only bytes
++        vat = ustr(vat).encode('iso8859-1')
++        m = self.__check_vat_mx_re.match(vat)
++        if not m:
++            #No valid format
++            return False
++        try:
++            ano = int(m.group('ano'))
++            if ano > 30:
++                ano = 1900 + ano
++            else:
++                ano = 2000 + ano
++            datetime.date(ano, int(m.group('mes')), int(m.group('dia')))
++        except ValueError:
++            return False
++        
++        #Valid format and valid date
++        return True
++        
+ res_partner()
+ 
+ # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
+=== modified file 'sale_mrp/sale_mrp.py'
+--- sale_mrp/sale_mrp.py	2011-01-14 00:11:01 +0000
++++ sale_mrp/sale_mrp.py	2011-06-06 21:41:04 +0000
+@@ -25,28 +25,12 @@
+ class mrp_production(osv.osv):
+     _inherit = 'mrp.production'
+ 
+-    def _ref_calc(self, cr, uid, ids, field_names=None, arg=False, context=None):
++    def _get_sale_ref(self, cr, uid, ids, field_names=None, arg=False, context=None):
+         """ Finds reference of sales order for production order.
+         @param field_names: Names of fields.
+         @param arg: User defined arguments
+         @return: Dictionary of values.
+         """
+-        res = {}
+-        if not field_names:
+-            field_names = []
+-        for id in ids:
+-            res[id] = {}.fromkeys(field_names, False)
+-        for f in field_names:
+-            field_name = False
+-            if f == 'sale_name':
+-                field_name = 'name'
+-            if f == 'sale_ref':
+-                field_name = 'client_order_ref'
+-            for key, value in self._get_sale_ref(cr, uid, ids, field_name).items():
+-                res[key][f] = value
+-        return res
+-
+-    def _get_sale_ref(self, cr, uid, ids, field_name=False):
+         move_obj = self.pool.get('stock.move')
+ 
+         def get_parent_move(move_id):
+@@ -58,20 +42,30 @@
+         res = {}
+         productions = self.browse(cr, uid, ids)
+         for production in productions:
+-            res[production.id] = False
++            res[production.id] = {}
+             if production.move_prod_id:
+                 parent_move_line = get_parent_move(production.move_prod_id.id)
+                 if parent_move_line:
+                     move = move_obj.browse(cr, uid, parent_move_line)
+-                    if field_name == 'name':
+-                        res[production.id] = move.sale_line_id and move.sale_line_id.order_id.name or False
+-                    if field_name == 'client_order_ref':
+-                        res[production.id] = move.sale_line_id and move.sale_line_id.order_id.client_order_ref or False
++                    for field_name in field_names:
++                        if field_name == 'sale_name':
++                            res[production.id][field_name] = move.sale_line_id and move.sale_line_id.order_id.name or False
++                        if field_name == 'sale_ref':
++                            res[production.id][field_name] = move.sale_line_id and move.sale_line_id.order_id.client_order_ref or False
++                        if field_name == 'sale_id':
++                            res[production.id][field_name] = move.sale_line_id and move.sale_line_id.order_id.id or False
++                        if field_name == 'sale_line_id':
++                            res[production.id][field_name] = move.sale_line_id and move.sale_line_id.id or False
++                        if field_name == 'partner_id':
++                            res[production.id][field_name] = move.sale_line_id and move.sale_line_id.order_id.partner_id.id or False
+         return res
+ 
+     _columns = {
+-        'sale_name': fields.function(_ref_calc, method=True, multi='sale_name', type='char', string='Sales Name', help='Indicate the name of sales order.'),
+-        'sale_ref': fields.function(_ref_calc, method=True, multi='sale_name', type='char', string='Sales Reference', help='Indicate the Customer Reference from sales order.'),
++        'sale_name': fields.function(_get_sale_ref, method=True, multi='sale_name', type='char', string='Sales Name', help='Indicate the name of sales order.'),
++        'sale_ref': fields.function(_get_sale_ref, method=True, multi='sale_name', type='char', string='Sales Reference', help='Indicate the Customer Reference from sales order.'),
++        'sale_id': fields.function(_get_sale_ref, method=True, multi='sale_name', type='many2one', relation='sale.order', string='Sale Order', help=''),
++        'sale_line_id': fields.function(_get_sale_ref, method=True, multi='sale_name', type='many2one', relation='sale.order.line', string='Sale Line', help=''),
++        'partner_id':  fields.function(_get_sale_ref, method=True, multi='sale_name', type='many2one', relation='res.partner', string='Partner', help=''),
+     }
+ 
+ mrp_production()
+
+=== modified file 'sale_mrp/sale_mrp_view.xml'
+--- sale_mrp/sale_mrp_view.xml	2011-01-14 00:11:01 +0000
++++ sale_mrp/sale_mrp_view.xml	2011-06-06 21:28:34 +0000
+@@ -11,6 +11,9 @@
+                 <xpath expr="/form/notebook/page/field[@name='move_prod_id']" position="after">
+                     <field name="sale_name" groups="base.group_extended"/>
+                     <field name="sale_ref" groups="base.group_extended"/>
++                    <field name="sale_id" groups="base.group_extended"/>
++                    <field name="sale_line_id" groups="base.group_extended"/>
++                    <field name="partner_id" groups="base.group_extended"/>
+                 </xpath>
+             </field>
+         </record>
+

=== added file 'sale_mrp_autosplit/sale_mrp_autosplit_report.xml'
--- sale_mrp_autosplit/sale_mrp_autosplit_report.xml	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/sale_mrp_autosplit_report.xml	2012-06-08 16:18:19 +0000
@@ -0,0 +1,13 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+    
+        <report id="mrp_lot_barcode"
+            name="mrp.lot.barcode"
+            string="Barcode"
+            model="mrp.production"
+            header="False"
+            rml="sale_mrp_autosplit/report/mrp_lot_barcode.rml"
+        />
+    </data>
+</openerp>
\ No newline at end of file

=== added file 'sale_mrp_autosplit/sale_view.xml'
--- sale_mrp_autosplit/sale_view.xml	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/sale_view.xml	2012-06-08 16:18:19 +0000
@@ -0,0 +1,59 @@
+<?xml version="1.0" ?>
+<openerp>
+    <data>
+        
+        <record model="ir.ui.view" id="view_order_form_inh_sale_mrp_autosplit_02">
+            <field name="name">view.order.form.inh.sale.mrp.autosplit.02</field>
+            <field name="model">sale.order</field>
+            <field name="type">form</field>
+            <field name="priority" eval="20"/>
+            <field name="inherit_id" ref="sale.view_order_form"/>
+            <field name="arch" type="xml">
+                <field name="product_uom_qty" position="after">
+                    <field name="product_qty_split" select="1"/>
+                </field>
+            </field>
+        </record>
+        
+        <record model="ir.ui.view" id="view_order_form_inh_sale_mrp_autosplit_01">
+            <field name="name">view.order.form.inh.sale.mrp.autosplit.01</field>
+            <field name="model">sale.order</field>
+            <field name="priority" eval="10"/>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="sale.view_order_form"/>
+            <field name="arch" type="xml">
+                <field name="product_uom_qty" position="after">
+                    <field name="date_planned_start" select="1"/>
+                </field>
+            </field>
+        </record>
+        
+        <record model="ir.ui.view" id="view_order_tree_inh_sale_mrp_autosplit_03">
+            <field name="name">view.order.tree.inh.sale.mrp.autosplit.03</field>
+            <field name="model">sale.order</field>
+            <field name="priority" eval="10"/>
+            <field name="type">tree</field>
+            <field name="inherit_id" ref="sale.view_order_tree"/>
+            <field name="arch" type="xml">
+                <field name="picked_rate" position="after">
+                    <field name="production_rate" widget="progressbar"/>
+                </field>
+            </field>
+        </record>
+        
+        <!--
+        <record model="ir.ui.view" id="view_order_form_inh_pricelist_date_02">
+            <field name="name">view.order.form.inh.pricelist.date.02</field>
+            <field name="model">sale.order</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="sale_layout.view_order_form_inherit_1"/>
+            <field name="arch" type="xml">
+                <field name="price_unit" position="after">
+                    <field name="date_pricelist" select="1"/>
+                </field>
+            </field>
+        </record>
+        -->
+    </data>
+</openerp>
+

=== added directory 'sale_mrp_autosplit/wizard'
=== added file 'sale_mrp_autosplit/wizard/__init__.py'
--- sale_mrp_autosplit/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/wizard/__init__.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,2 @@
+# -*- coding: utf-8 -*-
+import wizard_force_cancel
\ No newline at end of file

=== added file 'sale_mrp_autosplit/wizard/wizard_force_cancel.py'
--- sale_mrp_autosplit/wizard/wizard_force_cancel.py	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/wizard/wizard_force_cancel.py	2012-06-08 16:18:19 +0000
@@ -0,0 +1,141 @@
+# -*- coding: utf-8 -*-
+from osv import osv, fields
+import netsvc
+import time
+from tools.translate import _
+
+class wizard_force_cancel(osv.osv_memory):
+    _name = 'wizard.force.cancel'
+    _description = 'Force at cancel the sale.order and sub-process'
+    
+    def force_cancel(self, cr, uid, ids, context=None):
+        if context is None:
+            context = {}
+        wf_service = netsvc.LocalService("workflow")
+        sale_ids = context['active_ids']
+        #print "sale_ids",sale_ids
+        
+        sale_obj = self.pool.get('sale.order')
+        sale_line_obj = self.pool.get('sale.order.line')
+        picking_obj = self.pool.get('stock.picking')
+        production_obj = self.pool.get('mrp.production')
+        move_obj = self.pool.get('stock.move')
+        workcenter_line_obj = self.pool.get('mrp.production.workcenter.line')
+        
+        sale_filter = [('sale_id', 'in', sale_ids)]
+        
+        production_ids = production_obj.search(cr, uid, sale_filter, context=context)
+        		
+        if not 'sale_id' in cr.query:
+            print "No se puede forzar cancelar esta venta, porque no tiene referencias"
+            return {}
+        #cancel workflow
+        #Tambien considerar mrp.production.line
+        moves_data = production_obj.read(cr, uid, production_ids, ['move_prod_id', 'picking_id'], context=context)
+        move_ids = []
+        picking_ids = []
+        for move_data in moves_data:
+            #print "move_data",move_data
+            picking_id = move_data['picking_id'] and move_data['picking_id'][0] or False
+            if picking_id:
+                picking_ids.append( picking_id )
+            move_prod_id = move_data['move_prod_id'] and move_data['move_prod_id'][0] or False
+            if move_prod_id:
+                move_ids.append( move_prod_id )
+            #break
+        
+        #print "move_ids",move_ids
+        #print "move_ids",move_ids
+        #print "moves_data",moves_data
+        ##production.move_prod_id.picking_id
+        pickings_data = move_ids and move_obj.read(cr, uid, move_ids, ['picking_id'], context=context) or []
+        for picking_data in pickings_data:
+            picking_ids.append( picking_data['picking_id'][0] )
+        #sale_filter = ['|', ('sale_id', 'in', sale_ids), ('production_id', 'in', production_ids)]
+        picking_ids.extend( picking_obj.search(cr, uid, sale_filter, context=context) )
+        
+        #print "picking_obj.search--cr.query",cr.query
+        #print "picking_ids",picking_ids
+        for picking_id in picking_ids:
+            wf_service.trg_validate(uid, 'stock.picking', picking_id, 'button_cancel', cr)
+        #print "picking_ids",picking_ids
+        #############picking_obj.write(cr, uid, picking_ids, {'state': 'cancel'}, context=context)
+        
+        move_ids.extend( move_obj.search(cr, uid, [('picking_id', 'in', picking_ids)], context=context) )
+        #print "move_obj.search--cr.query",cr.query
+        #print "move_ids",move_ids
+        for move_id in move_ids:
+            wf_service.trg_validate(uid, 'stock.move', move_id, 'button_cancel', cr)
+        
+        workcenter_line_ids = workcenter_line_obj.search(cr, uid, [('production_id', 'in', production_ids)], context=context)
+        #print "workcenter_line_obj.search-cr.query",cr.query
+        #print "workcenter_line_ids",workcenter_line_ids
+        for workcenter_line_id in workcenter_line_ids:
+            wf_service.trg_validate(uid, 'mrp.production.workcenter.line', workcenter_line_id , 'button_cancel', cr)
+        #########workcenter_line_obj.write(cr, uid, workcenter_line_ids, {'state': 'cancel'}, context=context)
+        
+        #print "production_obj.search--cr.query",cr.query
+        #print "production_ids",production_ids
+        for production_id in production_ids:
+            wf_service.trg_validate(uid, 'mrp.production', production_id , 'button_cancel', cr)
+            
+        ########production_obj.write(cr, uid, production_ids, {'state': 'cancel'}, context=context)
+        #sale_line_ids = sale_line_obj.search(cr, uid, [('order_id', 'in', sale_ids)], context=context)
+        
+        for sale_id in sale_ids:
+            #wf_service.trg_validate(uid, 'sale.order', sale_id, 'button_cancel', cr)
+            #print "action_cancel"
+            #wf_service.trg_validate(uid, 'sale.order', sale_id, 'action_cancel', cr)
+            #print "cancel"
+            #wf_service.trg_validate(uid, 'sale.order', sale_id, 'cancel', cr)
+            #print "ship_cancel"
+            wf_service.trg_validate(uid, 'sale.order', sale_id, 'ship_cancel', cr)
+            wf_service.trg_validate(uid, 'sale.order', sale_id, 'action_cancel', cr)
+            wf_service.trg_validate(uid, 'sale.order', sale_id, 'cancel', cr)
+            wf_service.trg_validate(uid, 'sale.order', sale_id, 'invoice_cancel', cr)
+        
+        #Tambien considerar mrp.procurement
+        #tambien considerar facturas
+        return {}
+wizard_force_cancel()
+"""
+class wizard_finished_wcl(osv.osv_memory):
+    _name = 'wizard.finished.wcl'
+    _description = 'Finish a Work Center Line with a sequence'
+
+    _columns = {
+        'production_id': fields.many2one('mrp.production', 'Produccion', required=True),
+        'workcenter_line_id': fields.many2one('mrp.production.workcenter.line', 'Fraccion', required=True),
+        #'workcenter_id': fields.many2one('mrp.workcenter', 'Departamento', required=False),
+        #'sequence': fields.integer('Fraccion', required=False),
+    }
+    
+    def confirm(self, cr, uid, ids, context={}):
+        if not context:
+            context = {}
+        wkl_obj = self.pool.get('mrp.production.workcenter.line')
+        wf_service = netsvc.LocalService("workflow")
+        data = self.read(cr, uid, ids)[0]
+        workcenter_line_id = data['workcenter_line_id']
+        wf_service.trg_validate(uid, 'mrp.production.workcenter.line', workcenter_line_id, 'button_start_working', cr)
+        wf_service.trg_validate(uid, 'mrp.production.workcenter.line', workcenter_line_id, 'button_done', cr)
+        state = wkl_obj.read(cr, uid, [workcenter_line_id], ['state'], context=context)[0]['state']
+        if state <> 'done':
+            raise osv.except_osv(_('UserError'), _('No se pudo finalizar esta fraccion\nSe quedo en estado [%s]'%(state)))
+        return {}
+    
+    def onchange_production_id(self, cr, uid, ids, production_id, context={}):
+        production_obj = self.pool.get('mrp.production')
+        wkl_obj = self.pool.get('mrp.production.workcenter.line')
+        res = {}
+        wkl_ids = wkl_obj.search(cr, uid, [
+            ('production_id', '=', production_id),
+            ('state', '<>', 'done'),
+            ('name','ilike','%pase%'),
+        ], limit=1, order='production_id, sequence', context=context)
+        wkl_id = wkl_ids and wkl_ids[0] or False
+        res['value'] = {'workcenter_line_id': wkl_id}
+        return res
+wizard_finished_wcl()
+"""
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:

=== added file 'sale_mrp_autosplit/wizard/wizard_force_cancel_view.xml'
--- sale_mrp_autosplit/wizard/wizard_force_cancel_view.xml	1970-01-01 00:00:00 +0000
+++ sale_mrp_autosplit/wizard/wizard_force_cancel_view.xml	2012-06-08 16:18:19 +0000
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        
+        <record id="view_wizard_force_cancel_form" model="ir.ui.view">
+            <field name="name">view.wizard.force.cancel.form</field>
+            <field name="model">wizard.force.cancel</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+            <form string="Finalizar Fraccion">
+                <separator string="Esta usted seguro?" colspan="4"/>
+                <separator string="Se tardara varios minutos y no podras deshacer esta accion"/>
+                <group colspan="4" col="6">
+                    <button special="cancel" string="_Salir" icon="gtk-cancel"/>
+                    <button name="force_cancel" string="Confir_mar Cancelacion" type="object" icon="gtk-ok"/>
+                </group>
+            </form>
+            </field>
+        </record>
+        <record id="action_view_wizard_force_cancel_form" model="ir.actions.act_window">
+            <field name="name">Force cancel sale</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="res_model">wizard.force.cancel</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">form</field>
+            <field name="view_id" ref="view_wizard_force_cancel_form"/>
+            <field name="target">new</field>
+        </record>
+        <record model="ir.values" id="wizard_force_cancel">
+            <field name="model_id" ref="sale.model_sale_order"/>
+            <field name="object" eval="1" />
+            <field name="name">Force Cancel Sale</field>
+            <field name="key2">client_action_multi</field>
+            <field name="value" eval="'ir.actions.act_window,' + str(ref('action_view_wizard_force_cancel_form'))" />
+            <field name="key">action</field>
+            <field name="model">sale.order</field>
+        </record>
+        <!--
+        <menuitem id="menu_action_view_wizard_force_cancel_form"
+            action="action_view_wizard_force_cancel_form"
+            name="Finalizar Fraccion"
+            parent="mrp.menu_mrp_manufacturing"
+             sequence="30"
+        />
+        -->
+    </data>
+</openerp>
+