Merge lp:~vauxoo/addons-vauxoo/addons-vauxoo-stock_dumb_wizard_export_csv-dev-fernando into lp:addons-vauxoo

[Fernando Lopez]

Se modificó el manejo del diccionario ya que se estaban sobre escribiendo los datos y por eso repetía las líneas.
Se movió la columna name de la columna 3 a la 4.
La columna 3 se le asignó al campo 'reference'
El nombre del csv por default se cambio a "PT OpenERP - PWST.csv"

[Fernando Lopez (kyon)]

Funcionalidad migrada a stock.move

[Ulises Lopez (ulcalderon)]

- Cuando selecciono varios pickings solo toma los datos del último picking seleccionado, envío evidencia:
"2012-09-25 19:01:05","","[09878] Producto terminado 4","","167.0","09878"
"2012-09-25 19:01:05","","[09878] Producto terminado 4","","167.0","09878"
"2012-09-25 19:01:05","","[09878] Producto terminado 4","","167.0","09878"

- El formato de la columna 1, que es la fecha del movimiento aparece "2012-09-25 19:01:05", debe de ser con el siguiente formato "DD/MM/AAAA" sin hora.

- En la columna 3, debe de contener la referencia del documento ejemplo "OUT/00001"

- Colocar el nombre del producto en la columna 4 ejemplo "[09878] Producto terminado 4"

review: Needs Fixing

[Ulises Lopez (ulcalderon)]

- Colocar el siguiente nombre de archivo al momento de exportar: "PT OpenERP - PWST AAMMDD HH:MM.csv"

review: Needs Fixing

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

Equipo,
En la solicitud:
- En la columna 3, debe de contener la referencia del documento ejemplo "OUT/00001"

Creo que lo vamos a dejar tal cual está ahora + lo que pide Ulises, debido a que va a haber exportaciones de stock.move que no tengan stock.picking y esto podría causar error.

Es decir,
stock_move.picking_id and stock_move.picking_id.name or stock_move.name

¿Me explico?

review: Needs Fixing

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

Acorde a las guidelines
2.5 Factor out the code
Del documento
http://doc.openerp.com/v6.0/contribute/15_guidelines/coding_guidelines_framework.html

Se detecta que la función de stock_picking llamada "create_export_stk_moves" se está haciendo más de 1 vez exactamente la misma funcionalidad.

Dejar esta funcionalidad en stock_move (tal cual como está ahora), pero en la función del picking, hacer un ciclo para acumular move_ids donde al final, mande a llamar a stock_move.create_export_stk_moves(move_ids)

Y cuando termines esto, no darle en "Resubmit proposal merge", más bien darle en en comentario
Review: resumit y escribir tu comentario largo (que faltó en este nuevo feature)

review: Needs Fixing

[Ulises Lopez (ulcalderon)]

Se cambio al branch lp:vauxoo-private/sabersabor6.1

=== added file '__init__.py'
--- __init__.py	1970-01-01 00:00:00 +0000
+++ __init__.py	2012-09-25 23:32:22 +0000
@@ -0,0 +1,27 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([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 wizard
+import stock
\ No newline at end of file

=== added file '__openerp__.py'
--- __openerp__.py	1970-01-01 00:00:00 +0000
+++ __openerp__.py	2012-09-25 23:32:22 +0000
@@ -0,0 +1,45 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([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": "Stock dumb wizard export csv",
+    "version": "1.0",
+    "author" : "Vauxoo",
+    "category": "Generic Modules/Production",
+    "website" : "http://www.vauxoo.com/",
+    "description": """ Add wizard to export to a csv the stock_move lines 
+    from the stock_picking model
+    """,
+    'depends': ['stock'],
+    'init_xml': [],
+    'update_xml': [
+        'stock_view.xml',
+        ],
+    'demo_xml': [],
+    'test': [],
+    'installable': True,
+    'active': False,
+}
\ No newline at end of file

=== added directory 'i18n'
=== added file 'i18n/es_MX.mo'
Binary files i18n/es_MX.mo	1970-01-01 00:00:00 +0000 and i18n/es_MX.mo	2012-09-25 23:32:22 +0000 differ
=== added file 'i18n/es_MX.po'
--- i18n/es_MX.po	1970-01-01 00:00:00 +0000
+++ i18n/es_MX.po	2012-09-25 23:32:22 +0000
@@ -0,0 +1,93 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* stock_dumb_wizard_export_csv
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.1\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2012-09-24 23:15+0000\n"
+"PO-Revision-Date: 2012-09-24 18:23-0600\n"
+"Last-Translator: Kyon <[e-mail]>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: \n"
+
+#. module: stock_dumb_wizard_export_csv
+#: model:ir.model,name:stock_dumb_wizard_export_csv.model_stock_dumb_wizard_export_csv
+msgid "stock.dumb.wizard.export.csv"
+msgstr "stock.dumb.wizard.export.csv"
+
+#. module: stock_dumb_wizard_export_csv
+#: view:stock.dumb.wizard.export.csv:0
+#: view:stock.dumb.wizard.export.stk.move:0
+msgid "Exportar to CSV"
+msgstr "Exportar a csv"
+
+#. module: stock_dumb_wizard_export_csv
+#: model:ir.model,name:stock_dumb_wizard_export_csv.model_stock_dumb_wizard_export_stk_move
+msgid "stock.dumb.wizard.export.stk.move"
+msgstr "stock.dumb.wizard.export.stk.move"
+
+#. module: stock_dumb_wizard_export_csv
+#: model:ir.model,name:stock_dumb_wizard_export_csv.model_stock_move
+msgid "Stock Move"
+msgstr "Stock Move"
+
+#. module: stock_dumb_wizard_export_csv
+#: model:ir.actions.act_window,name:stock_dumb_wizard_export_csv.stock_dumb_wizard_stock_move
+#: model:ir.actions.act_window,name:stock_dumb_wizard_export_csv.stock_dumb_wizard_stock_picking
+msgid "Export to csv"
+msgstr "Exportar a csv"
+
+#. module: stock_dumb_wizard_export_csv
+#: constraint:stock.move:0
+msgid "You can not move products from or to a location of the type view."
+msgstr "No puedes mover productos desde o a una locación del tipo vista"
+
+#. module: stock_dumb_wizard_export_csv
+#: model:ir.actions.act_window,name:stock_dumb_wizard_export_csv.stock_dumb_wizard_export_csv_action
+#: model:ir.actions.act_window,name:stock_dumb_wizard_export_csv.stock_dumb_wizard_stock_move_action
+msgid "Wizard"
+msgstr "Asistente"
+
+#. module: stock_dumb_wizard_export_csv
+#: constraint:stock.move:0
+msgid "You must assign a production lot for this product"
+msgstr "Debe asignar un lote de producción para este producto"
+
+#. module: stock_dumb_wizard_export_csv
+#: field:stock.dumb.wizard.export.csv,file.csv:0
+#: field:stock.dumb.wizard.export.stk.move,file.csv:0
+msgid "File CSV"
+msgstr "Archivo CSV"
+
+#. module: stock_dumb_wizard_export_csv
+#: constraint:stock.move:0
+msgid "You try to assign a lot which is not from the same product"
+msgstr "Está intentando asignar un lote que no es del mismo producto"
+
+#. module: stock_dumb_wizard_export_csv
+#: view:stock.dumb.wizard.export.csv:0
+#: view:stock.dumb.wizard.export.stk.move:0
+msgid "Get data to export"
+msgstr "Obtener datos a exportar"
+
+#. module: stock_dumb_wizard_export_csv
+#: sql_constraint:stock.picking:0
+msgid "Reference must be unique per Company!"
+msgstr "¡La referencia debe ser única por compañía!"
+
+#. module: stock_dumb_wizard_export_csv
+#: model:ir.model,name:stock_dumb_wizard_export_csv.model_stock_picking
+msgid "Picking List"
+msgstr "Albarán (lista de remisiones)"
+
+#. module: stock_dumb_wizard_export_csv
+#: view:stock.dumb.wizard.export.csv:0
+#: view:stock.dumb.wizard.export.stk.move:0
+msgid "Cancel"
+msgstr "Cancelar"
+

=== added file 'stock.py'
--- stock.py	1970-01-01 00:00:00 +0000
+++ stock.py	2012-09-25 23:32:22 +0000
@@ -0,0 +1,122 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([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 pooler
+import wizard
+import base64
+import cStringIO
+import netsvc
+from tools.translate import _
+import tools
+import os
+from osv import osv, fields
+import base64
+import csv
+import StringIO
+import time
+
+class stock_picking(osv.osv):
+    _inherit = "stock.picking"
+    
+    """equivalent query to this export ---
+    select sm.date, sm.name, sm.product_qty, pp.default_code
+    from stock_move as sm, product_product as pp
+    where sm.product_id=pp.id
+    """
+    
+    def create_export_stk_moves(self,cr,uid,picking_ids,context=None):
+        if not context:
+            context={}
+            
+        stock_picking = self.browse(cr, uid, picking_ids, context=context)
+        val=[]
+        diction={}
+        
+        for picking in stock_picking:
+            for line in picking.move_lines:
+                my_date = time.strptime(line.date, "%Y-%m-%d %H:%M:%S")
+                diction['date'] = time.strftime("%d/%m/%Y", my_date)
+                diction['1'] = ""
+                diction['reference'] = picking.name
+                diction['name'] = line.name
+                diction['product_qty'] = line.product_qty
+                diction['default_code'] = line.product_id.default_code
+                val.append(diction.copy())
+        
+        buf = StringIO.StringIO()
+
+        csv.register_dialect('dialect_1', lineterminator = '\n', delimiter=',', quoting=csv.QUOTE_ALL)
+
+        writer = csv.DictWriter(buf, ['date','1','reference','name','product_qty','default_code',], dialect='dialect_1')
+
+        writer.writerows(val)
+        values = base64.encodestring( buf.getvalue() )
+        buf.close()
+        return values
+
+stock_picking()
+
+class stock_move(osv.osv):
+    _inherit = "stock.move"
+    
+    """equivalent query to this export ---
+    select sm.date, sm.name, sm.product_qty, pp.default_code
+    from stock_move as sm, product_product as pp
+    where sm.product_id=pp.id
+    """
+    
+    def create_export_stk_moves(self,cr,uid,move_ids,context=None):
+        if not context:
+            context={}
+            
+        stock_move = self.browse(cr, uid, move_ids, context=context)
+        val=[]
+        diction={}
+        
+        for move in stock_move:
+            my_date = time.strptime(move.date, "%Y-%m-%d %H:%M:%S")
+            diction['date'] = time.strftime("%d/%m/%Y", my_date)
+            diction['1'] = ""
+            diction['reference'] = move.picking_id.name
+            diction['name'] = move.name
+            diction['product_qty'] = move.product_qty
+            diction['default_code'] = move.product_id.default_code
+            val.append(diction.copy())
+        
+        contx=context.copy()
+        
+        buf = StringIO.StringIO()
+
+        csv.register_dialect('dialect_1', lineterminator = '\n', delimiter=',', quoting=csv.QUOTE_ALL)
+
+        writer = csv.DictWriter(buf, ['date','1','reference','name','product_qty','default_code',], dialect='dialect_1')
+
+        writer.writerows(val)
+        values = base64.encodestring( buf.getvalue() )
+        buf.close()
+        return values
+
+stock_move()
\ No newline at end of file

=== added file 'stock_view.xml'
--- stock_view.xml	1970-01-01 00:00:00 +0000
+++ stock_view.xml	2012-09-25 23:32:22 +0000
@@ -0,0 +1,75 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+<!--
+	View of wizard on stock.picking
+-->
+        <record id="stock_dumb_wizard_export_csv_form" model="ir.ui.view">
+            <field name="name">stock.dumb.wizard.export.csv.form</field>
+            <field name="model">stock.dumb.wizard.export.csv</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Exportar to CSV">
+			<field name="file.csv" colspan="4" nolabel="1" filename="PT OpenERP - PWST.csv"/>
+			<group colspan="4">
+				<button string="Cancel" icon="gtk-cancel" type="object" special="cancel"/>
+				<button string="Get data to export" icon="gtk-ok" name="action_export2" type="object"/>
+			</group>
+                </form>
+            </field>
+        </record>
+		
+	<act_window id="stock_dumb_wizard_stock_picking"
+		name="Export to csv"
+		src_model="stock.picking"
+		res_model="stock.dumb.wizard.export.csv"
+		view_mode="form"
+		target="new"
+		key2="client_action_multi"
+		  />
+
+       <record id="stock_dumb_wizard_export_csv_action" model="ir.actions.act_window">
+            <field name="name">Wizard</field>
+            <field name="res_model">stock.dumb.wizard.export.csv</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+<!--
+	View of wizard on stock.picking
+-->
+        <record id="stock_dumb_wizard_export_stk_move_form" model="ir.ui.view">
+            <field name="name">stock.dumb.wizard.export.stk.move.form</field>
+            <field name="model">stock.dumb.wizard.export.stk.move</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Exportar to CSV">
+			<field name="file.csv" colspan="4" nolabel="1" filename="PT OpenERP - PWST.csv"/>
+			<group colspan="4">
+				<button string="Cancel" icon="gtk-cancel" type="object" special="cancel"/>
+				<button string="Get data to export" icon="gtk-ok" name="action_export3" type="object"/>
+			</group>
+                </form>
+            </field>
+        </record>
+		  
+	<act_window id="stock_dumb_wizard_stock_move"
+		name="Export to csv"
+		src_model="stock.move"
+		res_model="stock.dumb.wizard.export.stk.move"
+		view_mode="form"
+		target="new"
+		key2="client_action_multi"
+		  />
+
+
+       <record id="stock_dumb_wizard_stock_move_action" model="ir.actions.act_window">
+            <field name="name">Wizard</field>
+            <field name="res_model">stock.dumb.wizard.export.stk.move</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">form</field>
+            <field name="target">new</field>
+        </record>
+	
+    </data>
+</openerp>

=== added directory 'wizard'
=== added file 'wizard/__init__.py'
--- wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ wizard/__init__.py	2012-09-25 23:32:22 +0000
@@ -0,0 +1,26 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([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 wizard
\ No newline at end of file

=== added file 'wizard/wizard.py'
--- wizard/wizard.py	1970-01-01 00:00:00 +0000
+++ wizard/wizard.py	2012-09-25 23:32:22 +0000
@@ -0,0 +1,61 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([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 time
+from osv import osv, fields
+import decimal_precision as dp
+from tools.translate import _
+
+class stock_dumb_wizard_export_csv(osv.osv_memory):
+    _name='stock.dumb.wizard.export.csv'
+    _columns={
+        'file.csv' : fields.binary('File CSV'),
+    }
+    
+    def action_export2(self,cr,uid,ids,context={}):
+        if not context:
+            context={}
+        picking_ids = context.get('active_ids', [])
+        stock_picking_obj = self.pool.get('stock.picking')
+        val = stock_picking_obj.create_export_stk_moves(cr,uid,picking_ids,context=context)
+        self.write(cr,uid,ids,{'file.csv' : val})
+        return True
+stock_dumb_wizard_export_csv()
+
+class stock_dumb_wizard_export_stk_move(osv.osv_memory):
+    _name='stock.dumb.wizard.export.stk.move'
+    _columns={
+        'file.csv' : fields.binary('File CSV'),
+    }
+    
+    def action_export3(self,cr,uid,ids,context={}):
+        if not context:
+            context={}
+        move_ids = context.get('active_ids', [])
+        stock_move_obj = self.pool.get('stock.move')
+        val = stock_move_obj.create_export_stk_moves(cr,uid,move_ids,context=context)
+        self.write(cr,uid,ids,{'file.csv' : val})
+        return True
+stock_dumb_wizard_export_stk_move()
\ No newline at end of file