This question has been flagged
3352 Views

I want to show a history of sale by partner by product: when i open the form view of sale qutation and when i choose a product i want to have a button when i click a popup apper to list the history sale for this partner and this product (qty,price ....)

this is my module.py :

def product_history_client(self, cr, uid, ids, context=None):
    ir_model_data = self.pool.get('ir.model.data')
    try:
        compose_form_id = ir_model_data.get_object_reference(cr, uid, 'sms_product_client_hist', 'hist_product_cust')[1]
    except ValueError:
        compose_form_id = False
    return {
        'name': _('Customer sale history'),
        'type': 'ir.actions.act_window',
        'view_type': 'form',
        'view_mode': 'form',
        'res_model': 'sale.order.line',
        'views': [(compose_form_id, 'form')],
        'view_id': compose_form_id,
        'target': 'new',
        'context': context,
    }

and module.xml:

<?xml version="1.0"?>

<openerp> <data>

  <record id="hist_product_cust" model="ir.ui.view">
    <field name="name">hist.product.cust</field>
    <field name="model">product.product</field>
    <field name="type">tree</field>
    <field name="priority">16</field>
    <field name="arch" type="xml">
        <tree string="product cust">
            <field name="id"/>
            <field name="name"/>
        </tree>
    </field>
  </record>


  <record id="view_order_form_histo" model="ir.ui.view">
  <field name="name">sale.order.form.histo</field>
  <field name="model">sale.order</field>
  <field name="inherit_id" ref="sale.view_order_form"/>
  <field name="arch" type="xml">
    <data>
      <xpath expr="/form/sheet/notebook/page/field[@name='order_line']/form/group/group/div/field[@name='product_uom_qty']" position="after">
          <!-- <button name="%(pop_hist_product)d" string="historique client" type="action" class="oe_highlight" /> -->
          <button name="product_history_client" string="historique client" type="object" class="oe_highlight oe_link" />
      </xpath>

    </data>
  </field>
  </record>






</data>

</openerp>

the popup window appear normally but when i close it a got this error :(

DataError: invalid input syntax for integer: "one2many_v_id_370" LINE 1: ...OM "sale_order_line" WHERE sale_order_line.id IN ('one2many_...

how can i fix this, i'm blocked please any idea will be appreciated

Thanks :)

Avatar
Discard