ERP, OpenERP, ruby on rails, crm, web development

Goal: Displaying additional information for each record in list through a tooltip. As in the following picture.
(You can see the tooltip displaying the supplier information for the product.)

Change following in client code:-

1. web_client/openerp/widgets/listgrid.py
2. web_client/openerp/widgets/template/listgrid.maco

In listgrid.py file there is a class list. It is having a list named params with various values.

Like 'name', 'data', 'columns', 'headers', 'model', 'selectable', 'editable' etc.

Do the following steps:

1. Define your own name in this list to which you are going to assign the values fetched from database. For this we need to deal with database.

2. In the same class (list) The init function gets called everytime a list is created in web client. So we can put our code to deal with database in the init function of this class.
You can use following code to fetch data from database.

proxy = rpc.RPCProxy(model)
partners = proxy.read(ids, ['seller_ids'], ctx)

here model is name of the table and seller_ids is the column name to retrive.

3. After fetching the values you can assign these values to the name you have defined in params.

if model=='product.product':

partners = proxy.read(ids, ['seller_ids'], ctx)

for partner in partners:

li_st.append(partner["seller_ids"])

for item in li_st:

for l in item:

part_list.append(l)

proxy2 = rpc.RPCProxy("product.supplierinfo")

supp_info_id = proxy2.read(part_list, ['name','product_id'], ctx)

for dic in supp_info_id:

if not self.suppliers.has_key(dic['product_id'][0]):

self.suppliers.update({dic['product_id'][0]:[dic['name'][1]]})

else:

self.suppliers [dic['product_id'][0]].append(dic['name'][1])

for key in self.suppliers.keys():

str=" ".join(["%s" % el for el in self.suppliers[key]])

self.suppliers[key]=str

Create a dictionary with keys equal to ids of the products and values equal to supplier of the product.

4. Now you can access this variable (suppliers) in listgrid.maco file directly. In listgrid.maco file i have changed the following line

<span>
<a href="javascript: void(0)" onclick="do_select(${data['id']}, '${name}'); return false;">${data[field]}</a>
</span>

as

<span>
<a href="javascript: void(0)" title=${suppliers[data['id']].encode('ascii','ignore')}  onclick="do_select(${data['id']}, '${name}'); return false;">${data[field]}</a>
</span>

data['id'] represents the id of each record(each product) in the list.