The project is on github?
Em quinta-feira, 28 de julho de 2016 04:10:37 UTC-3, Gael Princivalle
escreveu:
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
