from __future__ import unicode_literals
import webnotes
from webnotes.utils import cstr

def execute(filters=None):
    if not filters: filters ={}
    data = []
    i = 1
    columns = ['Check::','Item:Link/Item:120', 'creation::', 'modified', 'Description::120', 'last purchase rate::80']
    data = webnotes.conn.sql("select name, creation, modified, description, last_purchase_rate from `tabItem`", as_list=1)
    for d in data:
        d.insert(0, '<input type="checkbox" id="'+ cstr(i) +'">')
        i = i+1

    return columns, data