This can be a good plugin for w2p to have. Add this to grid or a table.
Thank you Gael for sharing. Great work!
On Wednesday, July 27, 2016 at 6:58:36 AM UTC-4, Marlysson Silva wrote:
>
> @Gael Princivalle , good code, you could to post this code in GitHub , so
> everybody could see your code and can improvement them.
>
> Em terça-feira, 26 de julho de 2016 16:32:12 UTC-3, Gael Princivalle
> escreveu:
>>
>> Sure Ron I can share.
>> In a few words on each select I've add a call to a javascript function
>> that say which select has been change, for avoiding to call an update on it:
>> onchange="update_data('from_cm2')"
>>
>> The update_data function call by ajax all changes:
>> function update_data(from){
>> if (from != 'from_cm1') {
>> ajax('{{=URL('default','get_options_for_cm1_id')}}', [
>> 'search_string','cm1_id','cm2_id','cm3_id','cm4_id','ng'], ':eval');
>> }
>> if (from != 'from_cm2') {
>> ajax('{{=URL('default','get_options_for_cm2_id')}}', [
>> 'search_string','cm1_id','cm2_id','cm3_id','cm4_id','ng'], ':eval');
>> }
>> if (from != 'from_cm3') {
>> ajax('{{=URL('default','get_options_for_cm3_id')}}', [
>> 'search_string','cm1_id','cm2_id','cm3_id','cm4_id','ng'], ':eval');
>> }
>> if (from != 'from_cm4') {
>> ajax('{{=URL('default','get_options_for_cm4_id')}}', [
>> 'search_string','cm1_id','cm2_id','cm3_id','cm4_id','ng'], ':eval');
>> }
>> if (from != 'from_ng') {
>> ajax('{{=URL('default','get_options_for_ng')}}', [
>> 'search_string','cm1_id','cm2_id','cm3_id','cm4_id','ng'], ':eval');
>> }
>> switch (from) {
>> case 'from_previous':
>> ajax('{{=URL('default','get_products_grid', vars={'
>> from':'from_previous'})}}', ['search_string','cm1_id','cm2_id','cm3_id',
>> 'cm4_id','ng'], 'target_data');
>> break;
>> case 'from_next':
>> ajax('{{=URL('default','get_products_grid', vars={'
>> from':'from_next'})}}', ['search_string','cm1_id','cm2_id','cm3_id',
>> 'cm4_id','ng'], 'target_data');
>> break;
>> default:
>> ajax('{{=URL('default','get_products_grid')}}', [
>> 'search_string','cm1_id','cm2_id','cm3_id','cm4_id','ng'], 'target_data'
>> );
>> }
>> }
>>
>> An example of a get_options:
>> def get_options_for_cm1_id():
>> search_string = request.vars['search_string']
>> cm1_id = int(request.vars['cm1_id'])
>> cm2_id = int(request.vars['cm2_id'])
>> cm3_id = int(request.vars['cm3_id'])
>> cm4_id = int(request.vars['cm4_id'])
>> ng = int(request.vars['ng'])
>> criteria = 0
>> query_str = ''
>> if len(search_string) > 0:
>> query_main_str = "(db.products.code.contains('" + search_string +
>> "'))
>> | (db.products.material_number.contains('" + search_string + "')) |
>> (db.products.description.contains('" + search_string + "'))"
>> else:
>> query_main_str = 'db.products.cm1 == db.cm1.id'
>> if cm1_id != 0:
>> cm1 = db.cm1(request.vars['cm1_id'])
>> if cm2_id != 0:
>> cm2 = db.cm2(request.vars['cm2_id'])
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.cm2 == cm2.id)'
>> criteria += 1
>> if cm3_id != 0:
>> cm3 = db.cm3(request.vars['cm3_id'])
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.cm3 == cm3.id)'
>> criteria += 1
>> if cm4_id != 0:
>> cm4 = db.cm4(request.vars['cm4_id'])
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.cm4 == cm4.id)'
>> criteria += 1
>> if ng > 0:
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.ng == ' + str(ng) + ')'
>> criteria += 1
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.cm1.id == db.products.cm1)'
>> if request.uri_language == 'it':
>> order_by = 'db.cm1.title_it'
>> else:
>> order_by = 'db.cm1.title_en'
>> cms = db(eval(query_main_str)).select(db.cm1.ALL, orderby=eval(
>> order_by), groupby=db.cm1.id, join=(db.products.on(eval(query_str))))
>> html=''
>> #html += query_str
>> html += "<option value='0'>" + T('All') + "</option>" + ' '
>> if request.uri_language == 'it':
>> for cm in cms:
>> html += "<option value='" + str(cm.id) + "' "
>> if cm.id == cm1_id:
>> html += ' selected'
>> html += ">" + cm.title_it + "</option>" + ' '
>> else:
>> for cm in cms:
>> html += "<option value='" + str(cm.id) + "' "
>> if cm.id == cm1_id:
>> html += ' selected'
>> html += ">" + cm.title_en + "</option>" + ' '
>> return 'jQuery("#cm1_id").html("%s");' % html #
>> jQuery("#cm1_id").change();
>>
>> get_products_grid (that update the div target_data):
>> def get_products_grid():
>> #take all vars
>> search_string = request.vars['search_string']
>> cm1_id = int(request.vars['cm1_id'])
>> cm2_id = int(request.vars['cm2_id'])
>> cm3_id = int(request.vars['cm3_id'])
>> cm4_id = int(request.vars['cm4_id'])
>> ng = int(request.vars['ng'])
>> criteria = 0
>> query_str = ''
>> if len(search_string) > 0:
>> query_str += "((db.products.code.contains('" + search_string + "'))
>> | (db.products.material_number.contains('" + search_string + "')) |
>> (db.products.description.contains('" + search_string + "')))"
>> criteria += 1
>> if cm1_id != 0:
>> cm1 = db.cm1(cm1_id)
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.cm1 == cm1.id)'
>> criteria += 1
>> if cm2_id != 0:
>> cm2 = db.cm2(cm2_id)
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.cm2 == cm2.id)'
>> criteria += 1
>> if cm3_id != 0:
>> cm3 = db.cm3(cm3_id)
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.cm3 == cm3.id)'
>> criteria += 1
>> if cm4_id != 0:
>> cm4 = db.cm4(cm4_id)
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.cm4 == cm4.id)'
>> criteria += 1
>> if ng != 0:
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.ng == ' + str(ng) + ')'
>> criteria += 1
>> if criteria > 0:
>> query_str += ' & '
>> query_str += '(db.products.ecommerce>0)'
>> n_page_rows = 10
>> n_products = db(eval(query_str)).count()
>> n_pages = (n_products / n_page_rows)
>> if n_products % n_page_rows > 0:
>> n_pages += 1
>> if (request.vars['from'] == 'from_previous') &
>> (session.current_first_product
>> > n_page_rows):
>> session.current_first_product -= n_page_rows
>> elif (request.vars['from'] == 'from_next'):
>> if session.current_first_product + n_page_rows < n_products:
>> session.current_first_product += n_page_rows
>> else: session.current_first_product = 0
>> current_last_product = session.current_first_product + n_page_rows
>> current_product_page = current_last_product / n_page_rows
>> products = db(eval(query_str)).select(limitby=(session.
>> current_first_product,current_last_product), orderby=db.products.code)
>> if auth.is_logged_in():
>> discounts=db(db.discounts.user_id == auth.user_id).select(db.
>> discounts.ALL)
>> html = ''
>> html += "<div class='left'>" + str(n_products)
>> if n_products > 1:
>> html += ' ' + T('products found')
>> else:
>> html += ' ' + T('product found')
>> '''
>> if request.vars['from']:
>> html += ' ' + request.vars['from']
>> '''
>> html += "</div>"
>> html += "<div class='right'>" + T('Page') + ' ' + str(
>> current_product_page) + "/" + str(n_pages) + '</div>'
>> html += "<table class='table table-striped cmtable'>"
>> html += "<thead>"
>> html += "<tr>"
>> html += "<th>" + T('Product code') + "</th>"
>> html += "<th>" + T('Mat. nr.') + "</th>"
>> html += "<th>" + T('Description') + "</th>"
>> html += "<th>" + T('PC1') + "</th>"
>> html += "<th>" + T('PC2') + "</th>"
>> html += "<th>" + T('PC3') + "</th>"
>> html += "<th>" + T('PC4') + "</th>"
>> html += "<th>NG</th>"
>> html += "<th>" + T('Price') + "</th>"
>> html += "<th>" + T('Catalogue') + "</th>"
>> html += "</thead>"
>> html += "<tbody>"
>> for product in products:
>> html+= "<tr>"
>> html+= "<td>" + product.code + "</td>"
>> html+= "<td>" + product.material_number + "</td>"
>> html+= "<td>" + product.description + "</td>"
>> if request.uri_language == 'it':
>> html+= "<td>" + product.cm1.title_it + "</td>"
>> html+= "<td>" + product.cm2.title_it + "</td>"
>> html+= "<td>" + product.cm3.title_it + "</td>"
>> html+= "<td>" + product.cm4.title_it + "</td>"
>> else:
>> html+= "<td>" + product.cm1.title_en + "</td>"
>> html+= "<td>" + product.cm2.title_en + "</td>"
>> html+= "<td>" + product.cm3.title_en + "</td>"
>> html+= "<td>" + product.cm4.title_en + "</td>"
>> html+= "<td>"
>> if product.ng > 0:
>> html += str(product.ng)
>> else:
>> html += '-'
>> html += "</td>"
>> html+= "<td>"
>> if product.special_offer:
>> html+= T('Special offer, contact us.')
>> else:
>> if auth.is_logged_in():
>> found_discount=False
>> for discount in discounts:
>> if discount.brand == product.brand:
>> xcent_discount=discount.xcent
>> found_discount=True
>> if found_discount and product.price_list > 0:
>> price_str = "{0:.2f}".format(product.price_list * (
>> 100 - xcent_discount) / 100) + "<small> EUR</small>"
>> html+= price_str
>> else:
>> html+= T('Ask for it')
>> else:
>> html+= T('login required')
>> html+= "</td>"
>> html+= "<td>"
>> html+= "<a href='" + product.pdf_path + "' target='blank'
>> alt='Download pdf'>Download</a>"
>> html+= "</td>"
>> html+= "</tr>"
>> html += "</tbody>"
>> html += "</table>"
>> html += "<div class='web2py_paginator'>"
>> html += "</div>"
>> return html
>>
>> Hope it can help.
>>
>> Il giorno martedì 26 luglio 2016 19:49:24 UTC+2, Ron Chatterjee ha
>> scritto:
>>>
>>> How did you do it? Can you share?
>>>
>>>
>>> On Tuesday, July 26, 2016 at 11:49:52 AM UTC-4, Antonio Salazar wrote:
>>>>
>>>> This is very nice and user friendly!
>>>>
>>>> I noticed it takes a second or more per request. Does the number of
>>>> criteria combinations affect performance?
>>>>
>>>> On Tuesday, July 26, 2016 at 2:26:16 AM UTC-5, Gael Princivalle wrote:
>>>>>
>>>>> Done it:
>>>>> http://www.hydrover.it/en/search_product
>>>>>
>>>>> Thank's again to all the web2py community for the support.
>>>>>
>>>>> If someone need to do a similar job I'll be happy to give a help.
>>>>>
>>>>> Il giorno mercoledì 13 aprile 2016 17:29:27 UTC+2, Gael Princivalle ha
>>>>> scritto:
>>>>>>
>>>>>> Hello.
>>>>>>
>>>>>> I would like to make a grid with some drop down menus for filtering
>>>>>> results.
>>>>>>
>>>>>> Is there already something that exist ?
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
