Thank you guys but making a plug-in is another time investment and I have
other priorities. If someone wants to make it I'll be happy to give a hand.
Il giorno mercoledì 27 luglio 2016 20:32:02 UTC+2, Ron Chatterjee ha
scritto:
>
> 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.
