Merge lp:~unifield-team/unifield-addons/new-purchase-order-state into lp:unifield-addons

[Quentin THEURET @Amaris]

[lp:~unifield-team/unifield-addons/new-purchase-order-state]

4469. By Quentin THEURET @Amaris on 2011-03-16

UF-98: [FIX] Fixed bug on confirmation of a purchase order with a line which hasn't linked procurement list line

4470. By Quentin THEURET @Amaris on 2011-03-16

UF-98: [ADD] Added csv file for import test

4471. By Quentin THEURET <quentin@tempo-quentin> on 2011-03-16

UF-98: [IMP] Added copy method to procurement.list to increase sequence and set empty the latest field of lines

=== added directory 'procurement_list'
=== added file 'procurement_list/__init__.py'
--- procurement_list/__init__.py	1970-01-01 00:00:00 +0000
+++ procurement_list/__init__.py	2011-03-16 16:41:25 +0000
@@ -0,0 +1,25 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 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 procurement_list
+import wizard
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 
=== added file 'procurement_list/__openerp__.py'
--- procurement_list/__openerp__.py	1970-01-01 00:00:00 +0000
+++ procurement_list/__openerp__.py	2011-03-16 16:41:25 +0000
@@ -0,0 +1,53 @@
+# -*- coding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 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/>.
+#
+##############################################################################
+{
+    'name' : 'Purchase list',
+    'version' : '1.0',
+    'author' : 'TeMPO Consulting, MSF',
+    'category': 'Generic Modules/Sales & Purchases',
+    'description': '''
+        This module allows you to create a list of items to procure. You can create automatically RfQ for these lists after choosing a list \
+        of suppliers. You can also compare these RfQ, choose the best supplier for each product and create automatically the associated \
+        purchase orders.
+    ''',
+    'website': 'http://unifield.msf.org',
+    'init_xml': [
+    ],
+    'depends' : [
+        'purchase',
+    ],
+    'update_xml': [
+        'procurement_list_sequence.xml',
+        'procurement_list_view.xml',
+        'procurement_list_wizard.xml',
+        'wizard/wizard_import_list_view.xml',
+        'security/ir.model.access.csv',
+    ],
+    'demo_xml': [
+    ],
+    'test': [
+        'test/procurement_list.yml',
+        'test/procurement_copy.yml',
+    ],
+    'installable': True,
+    'active': False,
+}
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
 
=== added file 'procurement_list/procurement_list.py'
--- procurement_list/procurement_list.py	1970-01-01 00:00:00 +0000
+++ procurement_list/procurement_list.py	2011-03-16 16:41:25 +0000
@@ -0,0 +1,217 @@
+#!/usr/bin/env python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 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 time
+import netsvc
+
+from osv import osv
+from osv import fields
+from tools.translate import _
+
+class procurement_list(osv.osv):
+    _name = 'procurement.list'
+    _description = 'Procurement list'
+
+    _columns = {
+        'name': fields.char(size=64, string='Ref.', required=True, readonly=True, 
+                            states={'draft': [('readonly', False)]}),
+        'requestor': fields.char(size=20, string='Requestor',),
+        'order_date': fields.date(string='Order date', required=True),
+        'warehouse_id': fields.many2one('stock.warehouse', string='Warehouse'),
+        'origin': fields.char(size=64, string='Origin'),
+        'state': fields.selection([('draft', 'Draft'),('done', 'Done'), ('cancel', 'Cancel')], 
+                                   string='State', readonly=True),
+        'line_ids': fields.one2many('procurement.list.line', 'list_id', string='Lines', readonly=True,
+                                    states={'draft': [('readonly', False)]}),
+        'notes': fields.text(string='Notes'),
+        'supplier_ids': fields.many2many('res.partner', 'procurement_list_supplier_rel',
+                                         'list_id', 'supplier_id', string='Suppliers',
+                                         domain="[('supplier', '=', True)]",
+                                         states={'done': [('readonly', True)]}),
+        'order_ids': fields.many2many('purchase.order', 'procurement_list_order_rel',
+                                      'list_id', 'order_id', string='Orders', readonly=True),
+    }
+
+    _defaults = {
+        'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'procurement.list'),
+        'state': lambda *a: 'draft',
+        'order_date': lambda *a: time.strftime('%Y-%m-%d'),
+    }
+    
+    def copy(self, cr, uid, ids, default={}, context={}):
+        '''
+        Increments the sequence for the new list
+        '''        
+        default['name'] = self.pool.get('ir.sequence').get(cr, uid, 'procurement.list')
+        
+        res = super(procurement_list, self).copy(cr, uid, ids, default, context=context)
+        
+        return res
+
+    def cancel(self, cr, uid, ids, context={}):
+        '''
+        Sets the procurement list to the 'Cancel' state
+        '''
+        self.write(cr, uid, ids, {'state': 'cancel'})
+
+        return True
+
+    def create_rfq(self, cr, uid, ids, context={}):
+        ''' 
+        Create a RfQ per supplier with all products
+        '''
+        purchase_obj = self.pool.get('purchase.order')
+        line_obj = self.pool.get('purchase.order.line')
+
+        order_ids = []
+
+        for list in self.browse(cr, uid, ids, context=context):
+            # Returns an error message if no suppliers or no products
+            if not list.supplier_ids or len(list.supplier_ids) == 0:
+                raise osv.except_osv(_('Error'), _('No supplier defined for this list !'))
+            if not list.line_ids or len(list.line_ids) == 0:
+                raise osv.except_osv(_('Error'), _('No line defined for this list !'))
+
+            location_id = self._get_location(cr, uid, list.warehouse_id)
+            # Creates a RfQ for each supplier...
+            for supplier in list.supplier_ids:
+                po_id = purchase_obj.create(cr, uid, {'partner_id': supplier.id,
+                                                      'partner_address_id': supplier.address_get().get('default'),
+                                                      'pricelist_id': supplier.property_product_pricelist.id,
+                                                      'origin': list.name,
+                                                      'location_id': location_id})
+                order_ids.append(po_id)
+
+                # ... with all lines...
+                for line in list.line_ids:
+                    # ... which aren't from stock
+                    if not line.from_stock:
+                        line_obj.create(cr, uid, {'product_uom': line.product_uom_id.id,
+                                                  'product_id': line.product_id.id,
+                                                  'order_id': po_id,
+                                                  'price_unit': 0.00,
+                                                  'date_planned': list.order_date,
+                                                  'product_qty': line.product_qty,
+                                                  'procurement_line_id': line.id,
+                                                  'name': line.product_id.name,})
+                    self.pool.get('procurement.list.line').write(cr, uid, line.id, {'latest': 'RfQ In Progress'})
+
+        self.write(cr, uid, ids, {'state': 'done', 'order_ids': [(6, 0, order_ids)]})
+
+        return {'type': 'ir.actions.act_window',
+                'res_model': 'purchase.order',
+                'view_type': 'form',
+                'view_mode': 'tree,form',
+                'domain': [('id', 'in', order_ids)]}
+
+    def reset(self, cr, uid, ids, context={}):
+        '''
+        Sets the procurement list to the 'Draft' state
+        '''
+        self.write(cr, uid, ids, {'state': 'draft'})
+
+        return True
+
+    def _get_location(self, cr, uid, warehouse=None):
+        '''
+        Returns the default input location for product
+        '''
+        if warehouse:
+            return warehouse.lot_input_id.id
+        warehouse_obj = self.pool.get('stock.warehouse')
+        warehouse_id = warehouse_obj.search(cr, uid, [])[0]
+        return warehouse_obj.browse(cr, uid, warehouse_id).lot_input_id.id
+
+procurement_list()
+
+
+class procurement_list_line(osv.osv):
+    _name = 'procurement.list.line'
+    _description = 'Procurement line'
+    _rec_name = 'product_id'
+
+    _columns = {
+        'product_id': fields.many2one('product.product', string='Product', required=True),
+        'product_uom_id': fields.many2one('product.uom', string='UoM', required=True),
+        'product_qty': fields.float(digits=(16,4), string='Quantity', required=True),
+        'comment': fields.char(size=128, string='Comment'),
+        'from_stock': fields.boolean(string='From stock ?'),
+        'latest': fields.char(size=64, string='Latest document', readonly=True),
+        'list_id': fields.many2one('procurement.list', string='List', required=True, ondelete='cascade'),
+    }
+    
+    _defaults = {
+        'latest': lambda *a: '',
+    }
+    
+    def copy_data(self, cr, uid, id, default={}, context={}):
+        '''
+        Initializes the 'latest' fields to an empty field
+        '''
+        default['latest'] = ''
+        
+        res = super(procurement_list_line, self).copy_data(cr, uid, id, default, context=context)
+        
+        return res
+
+    def product_id_change(self, cr, uid, ids, product_id, context={}):
+        '''
+        Fills automatically the product_uom_id field on the line when the 
+        product was changed.
+        '''
+        product_obj = self.pool.get('product.product')
+
+        v = {}
+        if not product_id:
+            v.update({'product_uom_id': False})
+        else:
+            product = product_obj.browse(cr, uid, product_id, context=context)
+            v.update({'product_uom_id': product.uom_id.id})
+
+        return {'value': v}
+
+procurement_list_line()
+
+
+class purchase_order_line(osv.osv):
+    _name = 'purchase.order.line'
+    _inherit = 'purchase.order.line'
+    
+    _columns = {
+        'procurement_line_id': fields.many2one('procurement.list.line', string='Procurement Line', readonly=True, ondelete='set null'),
+    }
+    
+    def action_confirm(self, cr, uid, ids, context={}):
+        '''
+        Changes the status of the procurement line
+        '''
+        proc_line_obj = self.pool.get('procurement.list.line')
+        for line in self.browse(cr, uid, ids):
+            if line.procurement_line_id and line.procurement_line_id.id:
+                proc_line_obj.write(cr, uid, [line.procurement_line_id.id], {'latest': line.order_id.name})
+        
+        return super(purchase_order_line, self).action_confirm(cr, uid, ids, context=context)
+    
+purchase_order_line()
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
 
=== added file 'procurement_list/procurement_list_sequence.xml'
--- procurement_list/procurement_list_sequence.xml	1970-01-01 00:00:00 +0000
+++ procurement_list/procurement_list_sequence.xml	2011-03-16 16:41:25 +0000
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<openerp>
+	<data>
+
+        <!-- Sequences for procurement.list -->
+        <record id="seq_type_procurement_list" model="ir.sequence.type">
+            <field name="name">Procurement List Order</field>
+            <field name="code">procurement.list</field>
+        </record>
+
+        <record id="seq_procurement_list" model="ir.sequence">
+            <field name="name">Procurement List</field>
+            <field name="code">procurement.list</field>
+            <field name="prefix">PR/</field>
+            <field name="padding">5</field>
+        </record>
+
+	</data>
+</openerp>
+
 
=== added file 'procurement_list/procurement_list_view.xml'
--- procurement_list/procurement_list_view.xml	1970-01-01 00:00:00 +0000
+++ procurement_list/procurement_list_view.xml	2011-03-16 16:41:25 +0000
@@ -0,0 +1,111 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<openerp>
+	<data>
+
+        <record id="procurement_list_form_view" model="ir.ui.view">
+            <field name="name">procurement.list.form.view</field>
+            <field name="model">procurement.list</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Procurement list">
+                    <group colspan="4" col="6">
+                        <field name="name" />
+                        <field name="order_date" />
+                        <field name="warehouse_id" widget="selection" />
+                        <field name="requestor" />
+                        <field name="origin" />
+                    </group>
+                    <notebook colspan="4">
+                        <page string="Products">
+                            <field name="line_ids" mode="tree" colspan="4" nolabel="1">
+                                <tree editable="top" string="Products">
+                                    <field name="product_id" on_change="product_id_change(product_id)" />
+                                    <field name="product_uom_id" />
+                                    <field name="product_qty" />
+                                    <field name="comment" />
+                                    <field name="from_stock" />
+                                    <field name="latest" />
+                                </tree>
+                            </field>
+                            <group colspan="4" col="6">
+                                <field name="state" />
+                                <button name="cancel" string="Cancel" icon="gtk-cancel" type="object" states="draft"/>
+                                <button name="create_rfq" string="Create RfQ" icon="gtk-execute" type="object" states="draft" />
+                                <button name="reset" string="Reset to Draft" icon="gtk-ok" type="object" states="cancel" />
+                            </group>
+                        </page>
+                        <page string="Suppliers">
+                            <field name="supplier_ids" nolabel="1" />
+                        </page>
+                        <page string="Sourcing Documents">
+                        	<field name="order_ids" nolabel="1" colspan="4">
+                        		<tree string="Sourcing Documents" colors="blue:state=='draft'">
+                        			<field name="name" />
+                        			<field name="partner_id" />
+                        			<field name="state" />
+                        		</tree>
+                        	</field>
+                        </page>
+                        <page string="Notes">
+                            <field name="notes" nolabel="1" />
+                        </page>
+                    </notebook>
+                </form>
+            </field>
+        </record>
+
+        <record id="procurement_list_tree_view" model="ir.ui.view">
+            <field name="name">procurement.list.tree.view</field>
+            <field name="model">procurement.list</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Procurement lists">
+                    <field name="name" />
+                    <field name="order_date" />
+                    <field name="requestor" />
+                </tree>
+            </field>
+        </record>
+
+        <record id="procurement_list_filter_view" model="ir.ui.view">
+            <field name="name">procurement.list.filter.view</field>
+            <field name="model">procurement.list</field>
+            <field name="type">search</field>
+            <field name="arch" type="xml">
+                <search string="Search Procurement List">
+                    <group col="10" colspan="4">
+                        <filter icon="terp-document-new" string="Draft" domain="[('state', '=', 'draft')]" help="Draft Procurement list" />
+                        <filter icon="terp-dialog-close" string="Done" domain="[('state', '=', 'done')]" help="Done Procurement list" />
+                        <separator orientation="vertical" />
+                        <field name="name" />
+                        <field name="order_date" />
+                        <field name="requestor" />
+                    </group>
+                    <newline />
+                    <group expand="0" string="Group By..." colspan="4" col="10" groups="base.group_extended">
+                        <filter string="Responsible" icon="terp-personal" domain="[]" context="{'group_by': 'user_id'}" />
+                        <separator orientation="vertical" />
+                    </group>
+                </search>
+            </field>
+        </record>
+
+        <record id="action_procurement_list_tree" model="ir.actions.act_window">
+            <field name="name">Procurement Lists</field>
+            <field name="res_model">procurement.list</field>
+            <field name="view_type">form</field>
+            <field name="view_mode">tree,form</field>
+            <field name="search_id" ref="procurement_list_filter_view" />
+            <field name="help">A procurement list is a list of items to supply. After creation of the list of items, you can choose
+            a list of suppliers and create automatically a Request for Quotation for each supplier.</field>
+        </record>
+
+        <menuitem
+            action="action_procurement_list_tree"
+            id="menu_procurement_list"
+            sequence="0"
+            parent="purchase.menu_procurement_management" />
+
+	</data>
+</openerp>
+
 
=== added file 'procurement_list/procurement_list_wizard.xml'
--- procurement_list/procurement_list_wizard.xml	1970-01-01 00:00:00 +0000
+++ procurement_list/procurement_list_wizard.xml	2011-03-16 16:41:25 +0000
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<openerp>
+	<data>
+
+        <wizard
+            id="wizard_list_to_order"
+            model="procurement.list"
+            name="wizard_list_to_order"
+            keyword="client_action_relate"
+            string="Purchase Orders" />
+
+        <wizard
+            id="wizard_list_to_rfq"
+            model="procurement.list"
+            name="wizard_list_to_rfq"
+            keyword="client_action_relate"
+            string="Requests for Quotation" />
+
+	</data>
+</openerp>
+
 
=== added directory 'procurement_list/security'
=== added file 'procurement_list/security/ir.model.access.csv'
--- procurement_list/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ procurement_list/security/ir.model.access.csv	2011-03-16 16:41:25 +0000
@@ -0,0 +1,3 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_procurement_list_all","procurement.list all","model_procurement_list",,1,1,1,1
+"access_procurement_list_line_all","procurement.list.line all","model_procurement_list_line",,1,1,1,1
 
=== added directory 'procurement_list/test'
=== added file 'procurement_list/test/list_import.csv'
--- procurement_list/test/list_import.csv	1970-01-01 00:00:00 +0000
+++ procurement_list/test/list_import.csv	2011-03-16 16:41:25 +0000
@@ -0,0 +1,5 @@
+'CPU1';'Processor AMD Athlon XP 1800+';'PCE';12,00;'test import';
+'CPU2';'High speed processor config';'PCE';15,00;;'True'
+'CPU3';'Processor AMD Athlon XP 2200+';'PCE';25,00;;
+'CPU_DEM';'Processor on demand';'PCE';30,00;;
+'CPU_GEN';'Regular processor config';'PCE';32,00;;
 
=== added file 'procurement_list/test/procurement_list.yml'
--- procurement_list/test/procurement_list.yml	1970-01-01 00:00:00 +0000
+++ procurement_list/test/procurement_list.yml	2011-03-16 16:41:25 +0000
@@ -0,0 +1,143 @@
+-
+    In order to test the procurement list module, I start by creating a new product category
+-
+  !record {model: product.category, id: product_cat1}:
+    name: Categ1
+-
+    I create new product 'P1'
+-
+  !record {model: product.product, id: product1}:
+    categ_id: product_cat1
+    cost_method: standard
+    mes_type: fixed
+    name: P1
+    price_margin: 2.0
+    procure_method: make_to_stock
+    property_stock_inventory: stock.location_inventory
+    property_stock_procurement: stock.location_procurement
+    property_stock_production: stock.location_production
+    seller_delay: '1'
+    standard_price: 100.0
+    supply_method: buy
+    type: product
+    uom_id: product.product_uom_unit
+    uom_po_id: product.product_uom_unit
+    volume: 0.0
+    warranty: 0.0
+    weight: 0.0
+    weight_net: 0.0
+-
+    I create a second product, P2
+-
+  !record {model: product.product, id: product2}:
+    categ_id: product_cat1
+    cost_method: standard
+    mes_type: fixed
+    name: P2
+    price_margin: 2.0
+    procure_method: make_to_stock
+    property_stock_inventory: stock.location_inventory
+    property_stock_procurement: stock.location_procurement
+    property_stock_production: stock.location_production
+    seller_delay: '1'
+    standard_price: 100.0
+    supply_method: buy
+    type: product
+    uom_id: product.product_uom_unit
+    uom_po_id: product.product_uom_unit
+    volume: 0.0
+    warranty: 0.0
+    weight: 0.0
+    weight_net: 0.0
+-
+    I create a partner
+-
+  !record {model: res.partner, id: partner1}:
+    name: Supplier 1
+-
+    I create an address for this partner
+-
+  !record {model: res.partner.address, id: addr1}:
+    partner_id: partner1
+    name: Supplier1
+-
+    I create a second partner
+-
+  !record {model: res.partner, id: partner2}:
+    name: Supplier 2
+-
+    I create an address for this second partner
+-
+  !record {model: res.partner.address, id: addr2}:
+    partner_id: partner2
+    name: Supplier2
+-
+    I create a procurement list for these two products 
+-
+  !record {model: procurement.list, id: list1}:
+    requestor: Administration
+    warehouse_id: stock.warehouse0
+    origin: R 20043
+    supplier_ids:
+      - partner1
+      - partner2
+-
+    I add two lines in this procurement list
+-
+  !record {model: procurement.list.line, id: list1_line1}:
+    product_id: product1
+    product_uom_id: product.product_uom_unit
+    product_qty: 100.00
+    comment: special comment
+    from_stock: False
+    list_id: list1
+-
+    The second line
+-
+  !record {model: procurement.list.line, id: list1_line2}:
+    product_id: product2
+    product_uom_id: product.product_uom_unit
+    product_qty: 50.0
+    from_stock: True
+    list_id: list1
+-
+    I check that the list which was initially in the draft state
+-
+  !assert {model: procurement.list, id: list1}:
+    - state == 'draft'
+    - requestor == 'Administration'
+    - origin == 'R 20043'
+-
+    I create RfQ from this list
+-
+  !python {model: procurement.list}: |
+    pl_obj = self.pool.get('procurement.list')
+    pl_id1 = pl_obj.browse(cr, uid, ref('list1'))
+    pl_id1.create_rfq()
+-
+    I check if the latest message in procurement line is 'RfQ In Progress'
+-
+  !assert {model: procurement.list.line, id: list1_line1}:
+    - latest == 'RfQ In Progress'
+-
+    I check if only one RfQ will be created for the 
+-
+  !python {model: procurement.list}: |
+    pl_obj = self.pool.get('procurement.list')
+    pol_obj = self.pool.get('purchase.order.line')
+    order_obj = self.pool.get('purchase.order')
+    pol_ids = pol_obj.search(cr, uid, [('product_id', '=', ref('product1'))])
+    pl = pl_obj.browse(cr, uid, ref('list1'))
+
+    for pol in pol_obj.browse(cr, uid, pol_ids):
+        assert pol.order_id.origin == pl.name, "Bad name for the name of the generated Purchase Order"
+    order_obj.wkf_confirm_order(cr, uid, [pol.order_id.id])
+    assert pol.procurement_line_id.latest == pol.order_id.name, "Procurement line not updated"
+-
+    I check that no purchase order line with P2
+-
+  !python {model: procurement.list}: |
+    pl_obj = self.pool.get('procurement.list')
+    pol_obj = self.pool.get('purchase.order.line')
+    pol_ids = pol_obj.search(cr, uid, [('product_id', '=', ref('product2'))])
+    assert len(pol_ids) == 0, "No purchase order line found !"
 
=== added directory 'procurement_list/wizard'
=== added file 'procurement_list/wizard/__init__.py'
--- procurement_list/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ procurement_list/wizard/__init__.py	2011-03-16 16:41:25 +0000
@@ -0,0 +1,28 @@
+#!/usr/bin/env python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 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 wizard_list_to_order
+import wizard_list_to_rfq
+import wizard_import_list
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
 
=== added file 'procurement_list/wizard/wizard_import_list.py'
--- procurement_list/wizard/wizard_import_list.py	1970-01-01 00:00:00 +0000
+++ procurement_list/wizard/wizard_import_list.py	2011-03-16 16:41:25 +0000
@@ -0,0 +1,196 @@
+#!/usr/bin/env python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 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/>.
+#
+##############################################################################
+
+from osv import osv
+from osv import fields
+
+from tools.translate import _
+
+from tempfile import TemporaryFile
+
+import base64
+import csv
+
+
+
+class wizard_import_list(osv.osv_memory):
+    _name = 'procurement.list.import'
+    _description = 'Import of Procurement List'
+
+    _columns = {
+        'file': fields.binary(strign='File to import', required=True),
+        'message': fields.text(string='Message', readonly=True),
+        'info': fields.text(string='Info', readonly=True),
+    }
+
+    _defaults = {
+        'info': lambda *a : """
+        The file should be in CSV format (with ';' character as delimiter).
+        The columns should be in this order :
+          * Product code
+          * Product name
+          * UoM
+          * Quantity
+          * Comment
+          * From stock ? (Write True if you want that the product will be supply from stock, leave blank if not)
+        """
+    }
+
+    def close_window(self, cr, uid, ids, context={}):
+        '''
+        Simply close the wizard
+        '''
+        return {'type': 'ir.actions.act_window',
+                'res_model': 'procurement.list',
+                'view_type': 'form',
+                'view_mode': 'form,tree',
+                'res_id': context.get('list_id'),
+                'target': 'crush'}
+
+    def default_get(self, cr, uid, fields, context={}):
+        '''
+        Check if the Procurement List is saved and 
+        set the error message
+        '''
+        res = super(wizard_import_list, self).default_get(cr, uid, fields, context=context)
+
+        # If we are after the importation
+        if context.get('step', False) and context.get('step', False) == 'import':
+            res['message'] = context.get('message', '')
+
+            return res
+        else:
+            if not context.get('active_id', False):
+                raise osv.except_osv(_('Warning'), _('Please save the Procurement List before importing lines'))
+
+            # We check if the Procurement List is in 'Draft' state
+            list_id = self.pool.get('procurement.list').browse(cr, uid, context.get('active_id', []))
+            if not list_id or list_id.state != 'draft':
+                raise osv.except_osv(_('Warning'), _('You cannot import lines in a confirmed Procurement List'))
+
+        return res
+
+
+    def import_file(self, cr, uid, ids, context={}):
+        '''
+        Import the file passed on the wizard in the
+        Procurement List
+        '''
+        list_line_obj = self.pool.get('procurement.list.line')
+        list_obj = self.pool.get('procurement.list')
+        product_obj = self.pool.get('product.product')
+        uom_obj = self.pool.get('product.uom')
+        model_data_obj = self.pool.get('ir.model.data')
+
+        list_id = context.get('active_id', False)
+
+        if not list_id:
+            raise osv.except_osv(_('Error'), _('The system hasn\'t found a Procurement List to import lines'))
+
+        import_list = self.browse(cr, uid, ids[0], context)
+
+        fileobj = TemporaryFile('w+')
+        fileobj.write(base64.decodestring(import_list.file))
+
+        # now we determine the file format
+        fileobj.seek(0)
+
+        reader = csv.reader(fileobj, quotechar='\'', delimiter=';')
+
+        error = ''
+
+        line_num = 0
+
+        for line in reader:
+            line_num += 1
+            if len(line) < 6:
+                error += 'Line %s is not valid !' % (line_num)
+                error += '\n'
+                continue
+            # Get the product
+            product_ids = product_obj.search(cr, uid, [('default_code', '=', line[0])], context=context)
+            if not product_ids:
+                product_ids = product_obj.search(cr, uid, [('name', '=', line[1])], context=context)
+            
+            if not product_ids:
+                error += 'Product [%s] %s not found !' % (line[0], line[1])
+                error += '\n'
+                continue
+
+            product_id = product_ids[0]
+
+            # Get the UoM
+            uom_ids = uom_obj.search(cr, uid, [('name', '=', line[2])])
+            if not uom_ids:
+                error += 'Uom %s not found !' % line[2]
+                error += '\n'
+                continue
+
+            uom_id = uom_ids[0]
+
+            # Get the quantity
+            product_qty = float(line[3].replace(',', '.'))
+
+            # Get the comment
+            comment = line[4]
+
+            # Get the method
+            from_stock = False
+            if line[5] == 'True':
+                from_stock = True
+
+
+            list_line_obj.create(cr, uid, {'product_id': product_id,
+                                           'product_uom_id': uom_id,
+                                           'product_qty': product_qty,
+                                           'comment': comment,
+                                           'from_stock': from_stock,
+                                           'list_id': list_id})
+
+        view_ids = model_data_obj.search(cr, uid, 
+                                        [('module', '=', 'procurement_list'), 
+                                         ('name', '=', 'wizard_import_list_done')],
+                                        offset=0, limit=1)[0]
+        view_id = model_data_obj.browse(cr, uid, view_ids).res_id
+
+        if error and error != '':
+            context['message'] = error
+        else:
+            context['message'] = 'All lines have been succesfully imported !'
+
+        context['step'] = 'import'
+        context['list_id'] = list_id
+
+        return {'type': 'ir.actions.act_window',
+                'res_model': 'procurement.list.import',
+                'view_type': 'form',
+                'view_mode': 'form',
+                'target': 'new',
+                'view_id': [view_id],
+                'context': context,
+               }
+
+wizard_import_list()
+
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
 
=== added file 'procurement_list/wizard/wizard_import_list_view.xml'
--- procurement_list/wizard/wizard_import_list_view.xml	1970-01-01 00:00:00 +0000
+++ procurement_list/wizard/wizard_import_list_view.xml	2011-03-16 16:41:25 +0000
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<openerp>
+	<data>
+
+
+        <record id="wizard_import_list_init" model="ir.ui.view">
+            <field name="name">wizard.import.list.init</field>
+            <field name="model">procurement.list.import</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Import lines">
+                    <separator string="Information" colspan="4" />
+                    <field name="info" colspan="4" nolabel="1" />
+                    <separator string="File to import" colspan="4" />
+                    <field name="file" nolabel="1" colspan="4" />
+                    <button special="cancel" string="Cancel" icon="gtk-cancel" />
+                    <button name="import_file" string="Import file" type="object" icon="gtk-convert" />
+                </form>
+            </field>
+        </record>
+
+        <record id="wizard_import_list_done" model="ir.ui.view">
+            <field name="name">wizard.import.list.done</field>
+            <field name="model">procurement.list.import</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Result of importation">
+                    <separator colspan="4" string="Result of importation" />
+                    <field name="message" colspan="4" nolabel="1" />
+                    <button name="close_window" string="Close" icon="gtk-close" type="object" />
+                </form>
+            </field>
+        </record>
+
+        <act_window
+            name="Import lines"
+            res_model="procurement.list.import"
+            src_model="procurement.list"
+            view_mode="form"
+            view_type="form"
+            view_id="wizard_import_list_init"
+            target="new"
+            key2="client_action_multi"
+            id="action_open_wizard_import" />
+
+	</data>
+</openerp>
+
 
=== added file 'procurement_list/wizard/wizard_list_to_order.py'
--- procurement_list/wizard/wizard_list_to_order.py	1970-01-01 00:00:00 +0000
+++ procurement_list/wizard/wizard_list_to_order.py	2011-03-16 16:41:25 +0000
@@ -0,0 +1,63 @@
+#!/usr/bin/env python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 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 wizard
+import pooler
+
+class wizard_list_to_order(wizard.interface):
+
+    def _get_order(self, cr, uid, data, context={}):
+        '''
+        Returns the Purchase Orders generated by the current
+        Procurement List
+        '''
+        pool_obj = pooler.get_pool(cr.dbname)
+        list_obj = pool_obj.get('procurement.list')
+
+        order_ids = []
+
+        for l in list_obj.browse(cr, uid, data['ids'], context=context):
+            for o in l.order_ids:
+                order_ids.append(o.id)
+
+        return {'type': 'ir.actions.act_window',
+                'res_model': 'purchase.order',
+                'view_type': 'form',
+                'view_mode': 'tree,form',
+                'domain': [('state', '!=', 'draft'), ('id', 'in', order_ids)],
+               }
+
+    states = {
+        'init': {
+            'actions': [],
+            'result': {
+                'type': 'action',
+                'action': _get_order,
+                'state': 'end',
+            },
+        },
+    }
+
+wizard_list_to_order('wizard_list_to_order')
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+
 
=== added file 'procurement_list/wizard/wizard_list_to_rfq.py'
--- procurement_list/wizard/wizard_list_to_rfq.py	1970-01-01 00:00:00 +0000
+++ procurement_list/wizard/wizard_list_to_rfq.py	2011-03-16 16:41:25 +0000
@@ -0,0 +1,63 @@
+#!/usr/bin/env python
+# -*- encoding: utf-8 -*-
+##############################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 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 wizard
+import pooler
+
+class wizard_list_to_rfq(wizard.interface):
+
+    def _get_order(self, cr, uid, data, context={}):
+        '''
+        Returns the Requests for Quotation generated by the current
+        Procurement List
+        '''
+        pool_obj = pooler.get_pool(cr.dbname)
+        list_obj = pool_obj.get('procurement.list')
+
+        order_ids = []
+
+        for l in list_obj.browse(cr, uid, data['ids'], context=context):
+            for o in l.order_ids:
+                order_ids.append(o.id)
+
+        return {'type': 'ir.actions.act_window',
+                'res_model': 'purchase.order',
+                'view_type': 'form',
+                'view_mode': 'tree,form',
+                'domain': [('state', '=', 'draft'), ('id', 'in', order_ids)],
+               }
+
+    states = {
+        'init': {
+            'actions': [],
+            'result': {
+                'type': 'action',
+                'action': _get_order,
+                'state': 'end',
+            },
+        },
+    }
+
+wizard_list_to_rfq('wizard_list_to_rfq')
+
+# vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4:
+